ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
gcmsPOOJAMEENA827ccb0eea8a706c4c34a16891f84e7b![]()
INRF500250000Ffiresql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtname := sqlget({m2},{court_name})firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})m_courttype := sqlget({m3},{court_type})firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})m_courtid := sqlget({m4},{court_name_mastid})firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})login_userid := sqlget({m4},{axusersid})firesql({m4},{select :username as uname from dual})u_name := sqlget({m4},{uname})firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtcode := sqlget({m4},{COURT_CODE})firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})m_statename := sqlget({m2},{STATE_NAME})firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_distName := sqlget({m7},{DISTNAMEENG})firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_courtcatid := sqlget({m8},{COURT_CATEGOTY})firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})m_deptid := sqlget({m4},{department_mastid})firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})m_courttypeid := sqlget({m3},{court_type_mastid})firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })urole := sqlget({m4},{groupname})firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})m_cutoffdt := sqlget({a1},{dd})firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})m_offcount := sqlget({P1},{ct})00000F
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
username=POOJAMEENA
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=POOJAMEENA
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = BOARD OF REVENUE,AJMER
Result = BOARD OF REVENUE,AJMER
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=POOJAMEENA
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=POOJAMEENA
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = Revenue Board
Result = Revenue Board
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=POOJAMEENA
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=POOJAMEENA
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 11599000000000
Result = 11599000000000
Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=POOJAMEENA
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1686550007217
Result = 1686550007217
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=POOJAMEENA
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = POOJAMEENA
Result = POOJAMEENA
Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=POOJAMEENA
Time elapsed = 10
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10006
Result = 10006
Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=POOJAMEENA
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=POOJAMEENA
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Ajmer
Result = Ajmer
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=POOJAMEENA
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=POOJAMEENA
Time elapsed = 11
Result of firesql =
Result =
Evaluating sqlget({m8},{COURT_CATEGOTY})
Calling function sqlget
Result of sqlget = 10593000000007
Result = 10593000000007
Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
Calling function firesql
login_userid=1686550007217
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1686550007217
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=POOJAMEENA
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10206000000012
Result = 10206000000012
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=POOJAMEENA
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=POOJAMEENA
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = rb_fbroom
Result = rb_fbroom
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=POOJAMEENA
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=POOJAMEENA
Time elapsed = 10
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 0
Result = 0
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('bor_talbi','rb_fbroom') and lower(sname)='bocup' and stype = 't' )
Time elapsed = 7
select Props from axuseraccess where lower(rname)='bor_talbi' and lower(sname)='bocup' and stype = 't'
Time elapsed = 7
select Props from axuseraccess where lower(rname)='rb_fbroom' and lower(sname)='bocup' and stype = 't'
Time elapsed = 12
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : rb_fbroom,bocup,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 3
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : bocup
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 7
Step4
tstructs\stm size:4415
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Evaluating dtchk
Result =
Evaluating {NO}
Result =
Evaluating 1
Result =
Evaluating 1
Result =
Evaluating 0
Result =
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=bocup
adxinout=o
Time elapsed = 4
select * from trn_bor_mhearing where trn_bor_mhearingid=0
Time elapsed = 4
select * from Axusers where 1=2
Time elapsed = 4
select distinct(fldname) from AxTempUserFields
Time elapsed = 6
select * from AxAttachWorkflow where lower(transid) = 'bocup'
Time elapsed = 8
select distinct(schemaname) from axschema where lower(transid)='rbcrt'
Time elapsed = 3
select trn_bor_caseregid from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 4
select hearingdate from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 4
select distinct(schemaname) from axschema where lower(transid)='rbcrt'
Time elapsed = 3
select case_purpose_name from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 5
select distinct(schemaname) from axschema where lower(transid)='rbcrt'
Time elapsed = 9
select case_purpose_code from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 2
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : rbchh
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 6
Step4
tstructs\stm size:2091
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=rbchh
adxinout=o
Time elapsed = 6
select * from trn_bor_case_hist where trn_bor_case_histid=0
Time elapsed = 7
Evaluating date()
Result =
Evaluating {Feedback}
Result =
Loading genmaps
Creating Action object
Submitting data to dbcall
Submiting & Registering data
Registering Global variables data
Registering Global variables data over
Setting values over
DB Call Validate and save
>>Validating bocup
>>Frame No 1
courtname = 11599000000000
courtcode = 10006
cldate = 29/08/2025
cltype = R
benchname = ?????? ?????
benchcode = 15
cluser = ALL
bench_mem1 = 0
bench_mem2 = 0
time zone difference = 0
>>Writing to tables bocup
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'bocup'
Time elapsed = 3
Saving to table TRN_BOR_MHEARING
select * from TRN_BOR_MHEARING where TRN_BOR_MHEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009801
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
cluser = ALL
benchcode = 15
bench_mem2 = 0
bench_mem1 = 0
benchname = ?????? ?????
courtcode = 10006
courtname = 11599000000000
cltype = R
cldate = 29/08/2025
Posting record
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:39
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
cluser=ALL
Param Type = c
benchcode=15
Param Type = c
bench_mem2=0
Param Type = c
bench_mem1=0
Param Type = c
benchname=?????? ?????
Param Type = c
courtcode=10006
Param Type = c
courtname=11599000000000
Param Type = c
cltype=R
Param Type = c
cldate=29/08/2025 00:00:00
insert into TRN_BOR_MHEARING (trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,cluser,benchcode,bench_mem2,bench_mem1,benchname,courtcode,courtname,cltype,cldate) values (:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:cluser,:benchcode,:bench_mem2,:bench_mem1,:benchname,:courtcode,:courtname,:cltype,to_date(:cldate,'dd/mm/yyyy hh24:mi:ss'))
Saving to table TRN_BOR_HEARING
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009802
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2020/165
trn_bor_caseid = 13801000003408
manual_case_no =
docid = 100062020/165
puname = POOJAMEENA
court_name = 11599000000000
court_code = 10006
new_purpose_code = 201
new_purpose_group = 19968000000591
next_hear_date = 08/09/2025
new_case_purpose = 10189000000601
bench_code = 15
prev_purpose_code = 201
prev_hear_date = 29/08/2025
TRN_BOR_HEARINGrow = 1
Posting record
Param Type = n
trn_bor_hearingid=17994000009802
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:39
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2020/165
Param Type = n
trn_bor_caseid=13801000003408
Param Type = c
docid=100062020/165
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=201
Param Type = n
new_purpose_group=19968000000591
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
new_case_purpose=10189000000601
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=201
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = n
trn_bor_hearingrow=1
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009803
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2020/283
trn_bor_caseid = 16117000003737
manual_case_no =
docid = 100062020/283
puname = POOJAMEENA
court_name = 11599000000000
court_code = 10006
new_purpose_code = 120
new_purpose_group = 19973000000612
next_hear_date = 15/09/2025
new_case_purpose = 10107000000777
bench_code = 15
prev_purpose_code = 120
prev_hear_date = 29/08/2025
TRN_BOR_HEARINGrow = 2
Posting record
Param Type = n
trn_bor_hearingid=17994000009803
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:39
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2020/283
Param Type = n
trn_bor_caseid=16117000003737
Param Type = c
docid=100062020/283
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=120
Param Type = n
new_purpose_group=19973000000612
Param Type = c
next_hear_date=15/09/2025 00:00:00
Param Type = c
new_case_purpose=10107000000777
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=120
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = n
trn_bor_hearingrow=2
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 13
RecordId = 17994000009804
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 6
manual_case_no =
bench_code = 15
trn_bor_caseid = 14026000003241
docid = 100062020/478
case_no = 2020/478
prev_purpose_code = 112
new_purpose_group = 19971000000602
next_hear_date = 21/11/2025
new_purpose_code = 112
prev_hear_date = 29/08/2025
new_case_purpose = 10035000000979
puname = POOJAMEENA
court_name = 11599000000000
court_code = 10006
TRN_BOR_HEARINGrow = 3
Posting record
Param Type = n
trn_bor_hearingid=17994000009804
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:39
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
bench_code=15
Param Type = n
trn_bor_caseid=14026000003241
Param Type = c
docid=100062020/478
Param Type = c
case_no=2020/478
Param Type = c
prev_purpose_code=112
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=21/11/2025 00:00:00
Param Type = c
new_purpose_code=112
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
new_case_purpose=10035000000979
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = n
trn_bor_hearingrow=3
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,manual_case_no,bench_code,trn_bor_caseid,docid,case_no,prev_purpose_code,new_purpose_group,next_hear_date,new_purpose_code,prev_hear_date,new_case_purpose,puname,court_name,court_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:bench_code,:trn_bor_caseid,:docid,:case_no,:prev_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:puname,:court_name,:court_code,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009805
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2020/479
bench_code = 15
manual_case_no =
docid = 100062020/479
puname = POOJAMEENA
court_name = 11599000000000
court_code = 10006
trn_bor_caseid = 14050000003562
new_purpose_group = 19971000000602
next_hear_date = 21/11/2025
new_purpose_code = 112
prev_purpose_code = 112
prev_hear_date = 29/08/2025
new_case_purpose = 10035000000979
TRN_BOR_HEARINGrow = 4
Posting record
Param Type = n
trn_bor_hearingid=17994000009805
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:39
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2020/479
Param Type = c
bench_code=15
Param Type = c
docid=100062020/479
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = n
trn_bor_caseid=14050000003562
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=21/11/2025 00:00:00
Param Type = c
new_purpose_code=112
Param Type = c
prev_purpose_code=112
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
new_case_purpose=10035000000979
Param Type = n
trn_bor_hearingrow=4
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,bench_code,manual_case_no,docid,puname,court_name,court_code,trn_bor_caseid,new_purpose_group,next_hear_date,new_purpose_code,prev_purpose_code,prev_hear_date,new_case_purpose,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:bench_code,null,:docid,:puname,:court_name,:court_code,:trn_bor_caseid,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 12
RecordId = 17994000009806
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
case_no = 2020/528
trn_bor_caseid = 15764000002775
manual_case_no =
docid = 100062020/528
puname = POOJAMEENA
court_name = 11599000000000
court_code = 10006
new_purpose_code = 112
new_purpose_group = 19971000000602
next_hear_date = 21/11/2025
new_case_purpose = 10035000000979
bench_code = 15
prev_purpose_code = 112
prev_hear_date = 29/08/2025
TRN_BOR_HEARINGrow = 5
Posting record
Param Type = n
trn_bor_hearingid=17994000009806
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:39
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2020/528
Param Type = n
trn_bor_caseid=15764000002775
Param Type = c
docid=100062020/528
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=112
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=21/11/2025 00:00:00
Param Type = c
new_case_purpose=10035000000979
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=112
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = n
trn_bor_hearingrow=5
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009807
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trn_bor_caseid = 18757000003886
manual_case_no =
bench_code = 15
court_code = 10006
docid = 100062020/595
case_no = 2020/595
new_purpose_code = 120
next_hear_date = 15/09/2025
new_purpose_group = 19973000000612
prev_purpose_code = 120
prev_hear_date = 29/08/2025
new_case_purpose = 10107000000777
court_name = 11599000000000
puname = POOJAMEENA
TRN_BOR_HEARINGrow = 6
Posting record
Param Type = n
trn_bor_hearingid=17994000009807
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:39
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
trn_bor_caseid=18757000003886
Param Type = c
bench_code=15
Param Type = c
court_code=10006
Param Type = c
docid=100062020/595
Param Type = c
case_no=2020/595
Param Type = c
new_purpose_code=120
Param Type = c
next_hear_date=15/09/2025 00:00:00
Param Type = n
new_purpose_group=19973000000612
Param Type = c
prev_purpose_code=120
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
new_case_purpose=10107000000777
Param Type = c
court_name=11599000000000
Param Type = c
puname=POOJAMEENA
Param Type = n
trn_bor_hearingrow=6
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_bor_caseid,manual_case_no,bench_code,court_code,docid,case_no,new_purpose_code,next_hear_date,new_purpose_group,prev_purpose_code,prev_hear_date,new_case_purpose,court_name,puname,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_bor_caseid,null,:bench_code,:court_code,:docid,:case_no,:new_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:court_name,:puname,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 17994000009808
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 16
docid = 100062020/652
prev_purpose_code = 201
puname = POOJAMEENA
bench_code = 15
case_no = 2020/652
trn_bor_caseid = 15372000003727
manual_case_no =
new_purpose_code = 201
new_purpose_group = 19968000000591
next_hear_date = 29/09/2025
new_case_purpose = 10189000000601
prev_hear_date = 29/08/2025
court_code = 10006
court_name = 11599000000000
TRN_BOR_HEARINGrow = 7
Posting record
Param Type = n
trn_bor_hearingid=17994000009808
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:39
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
docid=100062020/652
Param Type = c
prev_purpose_code=201
Param Type = c
puname=POOJAMEENA
Param Type = c
bench_code=15
Param Type = c
case_no=2020/652
Param Type = n
trn_bor_caseid=15372000003727
Param Type = c
new_purpose_code=201
Param Type = n
new_purpose_group=19968000000591
Param Type = c
next_hear_date=29/09/2025 00:00:00
Param Type = c
new_case_purpose=10189000000601
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = n
trn_bor_hearingrow=7
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,docid,prev_purpose_code,puname,bench_code,case_no,trn_bor_caseid,manual_case_no,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,prev_hear_date,court_code,court_name,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:docid,:prev_purpose_code,:puname,:bench_code,:case_no,:trn_bor_caseid,null,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:court_name,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009809
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2020/744
trn_bor_caseid = 19133000004049
manual_case_no =
docid = 100062020/744
puname = POOJAMEENA
court_name = 11599000000000
court_code = 10006
new_purpose_code = 167
new_purpose_group = 19971000000602
next_hear_date = 21/11/2025
new_case_purpose = 10173000000547
bench_code = 15
prev_purpose_code = 167
prev_hear_date = 29/08/2025
TRN_BOR_HEARINGrow = 8
Posting record
Param Type = n
trn_bor_hearingid=17994000009809
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:39
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2020/744
Param Type = n
trn_bor_caseid=19133000004049
Param Type = c
docid=100062020/744
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=167
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=21/11/2025 00:00:00
Param Type = c
new_case_purpose=10173000000547
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=167
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = n
trn_bor_hearingrow=8
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17994000009810
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
case_no = 2020/890
trn_bor_caseid = 18553000003006
manual_case_no =
docid = 100062020/890
puname = POOJAMEENA
court_name = 11599000000000
court_code = 10006
new_purpose_code = 122
new_purpose_group = 19971000000602
next_hear_date = 21/11/2025
new_case_purpose = 10110000000719
bench_code = 15
prev_purpose_code = 122
prev_hear_date = 29/08/2025
TRN_BOR_HEARINGrow = 9
Posting record
Param Type = n
trn_bor_hearingid=17994000009810
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:39
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2020/890
Param Type = n
trn_bor_caseid=18553000003006
Param Type = c
docid=100062020/890
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=122
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=21/11/2025 00:00:00
Param Type = c
new_case_purpose=10110000000719
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=122
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = n
trn_bor_hearingrow=9
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 8
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009811
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 8
prev_purpose_code = 122
next_hear_date = 21/11/2025
bench_code = 15
prev_hear_date = 29/08/2025
new_purpose_group = 19971000000602
new_purpose_code = 122
new_case_purpose = 10110000000719
court_code = 10006
court_name = 11599000000000
puname = POOJAMEENA
docid = 100062020/1355
manual_case_no =
trn_bor_caseid = 10117000003214
case_no = 2020/1355
TRN_BOR_HEARINGrow = 10
Posting record
Param Type = n
trn_bor_hearingid=17994000009811
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:39
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_purpose_code=122
Param Type = c
next_hear_date=21/11/2025 00:00:00
Param Type = c
bench_code=15
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = n
new_purpose_group=19971000000602
Param Type = c
new_purpose_code=122
Param Type = c
new_case_purpose=10110000000719
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
puname=POOJAMEENA
Param Type = c
docid=100062020/1355
Param Type = n
trn_bor_caseid=10117000003214
Param Type = c
case_no=2020/1355
Param Type = n
trn_bor_hearingrow=10
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_purpose_code,next_hear_date,bench_code,prev_hear_date,new_purpose_group,new_purpose_code,new_case_purpose,court_code,court_name,puname,docid,manual_case_no,trn_bor_caseid,case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:new_case_purpose,:court_code,:court_name,:puname,:docid,null,:trn_bor_caseid,:case_no,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009812
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 08/09/2025
docid = 100062020/1387
case_no = 2020/1387
trn_bor_caseid = 12585000003678
puname = POOJAMEENA
court_name = 11599000000000
court_code = 10006
manual_case_no =
new_case_purpose = 10189000000601
new_purpose_code = 201
new_purpose_group = 19968000000591
bench_code = 15
prev_purpose_code = 201
prev_hear_date = 29/08/2025
TRN_BOR_HEARINGrow = 11
Posting record
Param Type = n
trn_bor_hearingid=17994000009812
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:39
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
docid=100062020/1387
Param Type = c
case_no=2020/1387
Param Type = n
trn_bor_caseid=12585000003678
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_case_purpose=10189000000601
Param Type = c
new_purpose_code=201
Param Type = n
new_purpose_group=19968000000591
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=201
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = n
trn_bor_hearingrow=11
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,docid,case_no,trn_bor_caseid,puname,court_name,court_code,manual_case_no,new_case_purpose,new_purpose_code,new_purpose_group,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:docid,:case_no,:trn_bor_caseid,:puname,:court_name,:court_code,null,:new_case_purpose,:new_purpose_code,:new_purpose_group,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17994000009813
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 11/09/2025
new_purpose_code = 120
puname = POOJAMEENA
court_name = 11599000000000
prev_purpose_code = 120
prev_hear_date = 29/08/2025
bench_code = 15
court_code = 10006
trn_bor_caseid = 17579000004293
manual_case_no =
new_purpose_group = 19973000000612
docid = 100062020/1719
case_no = 2020/1719
new_case_purpose = 10107000000777
TRN_BOR_HEARINGrow = 12
Posting record
Param Type = n
trn_bor_hearingid=17994000009813
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:39
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/09/2025 00:00:00
Param Type = c
new_purpose_code=120
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
prev_purpose_code=120
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
bench_code=15
Param Type = c
court_code=10006
Param Type = n
trn_bor_caseid=17579000004293
Param Type = n
new_purpose_group=19973000000612
Param Type = c
docid=100062020/1719
Param Type = c
case_no=2020/1719
Param Type = c
new_case_purpose=10107000000777
Param Type = n
trn_bor_hearingrow=12
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_purpose_code,puname,court_name,prev_purpose_code,prev_hear_date,bench_code,court_code,trn_bor_caseid,manual_case_no,new_purpose_group,docid,case_no,new_case_purpose,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_code,:puname,:court_name,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,:court_code,:trn_bor_caseid,null,:new_purpose_group,:docid,:case_no,:new_case_purpose,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009814
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 9
next_hear_date = 10/10/2025
new_purpose_group = 19973000000612
docid = 100062020/1824
case_no = 2020/1824
trn_bor_caseid = 11126000003318
puname = POOJAMEENA
court_name = 11599000000000
court_code = 10006
prev_hear_date = 29/08/2025
new_case_purpose = 10107000000777
new_purpose_code = 120
manual_case_no =
bench_code = 15
prev_purpose_code = 120
TRN_BOR_HEARINGrow = 13
Posting record
Param Type = n
trn_bor_hearingid=17994000009814
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:39
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=10/10/2025 00:00:00
Param Type = n
new_purpose_group=19973000000612
Param Type = c
docid=100062020/1824
Param Type = c
case_no=2020/1824
Param Type = n
trn_bor_caseid=11126000003318
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
new_case_purpose=10107000000777
Param Type = c
new_purpose_code=120
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=120
Param Type = n
trn_bor_hearingrow=13
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_purpose_group,docid,case_no,trn_bor_caseid,puname,court_name,court_code,prev_hear_date,new_case_purpose,new_purpose_code,manual_case_no,bench_code,prev_purpose_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:docid,:case_no,:trn_bor_caseid,:puname,:court_name,:court_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:new_purpose_code,null,:bench_code,:prev_purpose_code,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009815
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 9
new_purpose_group = 19971000000602
next_hear_date = 28/11/2025
docid = 100062020/1836
case_no = 2020/1836
trn_bor_caseid = 14264000003331
puname = POOJAMEENA
court_name = 11599000000000
court_code = 10006
prev_hear_date = 29/08/2025
new_case_purpose = 10110000000719
new_purpose_code = 122
manual_case_no =
bench_code = 15
prev_purpose_code = 122
TRN_BOR_HEARINGrow = 14
Posting record
Param Type = n
trn_bor_hearingid=17994000009815
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=28/11/2025 00:00:00
Param Type = c
docid=100062020/1836
Param Type = c
case_no=2020/1836
Param Type = n
trn_bor_caseid=14264000003331
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
new_case_purpose=10110000000719
Param Type = c
new_purpose_code=122
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=122
Param Type = n
trn_bor_hearingrow=14
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_group,next_hear_date,docid,case_no,trn_bor_caseid,puname,court_name,court_code,prev_hear_date,new_case_purpose,new_purpose_code,manual_case_no,bench_code,prev_purpose_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:docid,:case_no,:trn_bor_caseid,:puname,:court_name,:court_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:new_purpose_code,null,:bench_code,:prev_purpose_code,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009816
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 5
new_purpose_group = 19973000000612
next_hear_date = 15/12/2025
new_purpose_code = 120
court_code = 10006
docid = 100062020/2063
court_name = 11599000000000
prev_purpose_code = 120
puname = POOJAMEENA
case_no = 2020/2063
prev_hear_date = 29/08/2025
new_case_purpose = 10107000000777
bench_code = 15
trn_bor_caseid = 15095000003405
manual_case_no =
TRN_BOR_HEARINGrow = 15
Posting record
Param Type = n
trn_bor_hearingid=17994000009816
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
new_purpose_group=19973000000612
Param Type = c
next_hear_date=15/12/2025 00:00:00
Param Type = c
new_purpose_code=120
Param Type = c
court_code=10006
Param Type = c
docid=100062020/2063
Param Type = c
court_name=11599000000000
Param Type = c
prev_purpose_code=120
Param Type = c
puname=POOJAMEENA
Param Type = c
case_no=2020/2063
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
new_case_purpose=10107000000777
Param Type = c
bench_code=15
Param Type = n
trn_bor_caseid=15095000003405
Param Type = n
trn_bor_hearingrow=15
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_group,next_hear_date,new_purpose_code,court_code,docid,court_name,prev_purpose_code,puname,case_no,prev_hear_date,new_case_purpose,bench_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_code,:court_code,:docid,:court_name,:prev_purpose_code,:puname,:case_no,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:trn_bor_caseid,null,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 20
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 17994000009817
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 12
new_purpose_code = 122
new_purpose_group = 19971000000602
next_hear_date = 28/11/2025
docid = 100062020/2608
case_no = 2020/2608
court_code = 10006
puname = POOJAMEENA
court_name = 11599000000000
trn_bor_caseid = 14347000000236
prev_hear_date = 29/08/2025
new_case_purpose = 10110000000719
prev_purpose_code = 122
manual_case_no =
bench_code = 15
TRN_BOR_HEARINGrow = 16
Posting record
Param Type = n
trn_bor_hearingid=17994000009817
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_purpose_code=122
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=28/11/2025 00:00:00
Param Type = c
docid=100062020/2608
Param Type = c
case_no=2020/2608
Param Type = c
court_code=10006
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = n
trn_bor_caseid=14347000000236
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
new_case_purpose=10110000000719
Param Type = c
prev_purpose_code=122
Param Type = c
bench_code=15
Param Type = n
trn_bor_hearingrow=16
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_code,new_purpose_group,next_hear_date,docid,case_no,court_code,puname,court_name,trn_bor_caseid,prev_hear_date,new_case_purpose,prev_purpose_code,manual_case_no,bench_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:docid,:case_no,:court_code,:puname,:court_name,:trn_bor_caseid,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:prev_purpose_code,null,:bench_code,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009818
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 3
new_purpose_code = 112
new_purpose_group = 19971000000602
next_hear_date = 28/11/2025
new_case_purpose = 10035000000979
docid = 100062020/2657
case_no = 2020/2657
court_code = 10006
puname = POOJAMEENA
court_name = 11599000000000
prev_purpose_code = 112
prev_hear_date = 29/08/2025
bench_code = 15
trn_bor_caseid = 16071000004208
manual_case_no =
TRN_BOR_HEARINGrow = 17
Posting record
Param Type = n
trn_bor_hearingid=17994000009818
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_purpose_code=112
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=28/11/2025 00:00:00
Param Type = c
new_case_purpose=10035000000979
Param Type = c
docid=100062020/2657
Param Type = c
case_no=2020/2657
Param Type = c
court_code=10006
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
prev_purpose_code=112
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
bench_code=15
Param Type = n
trn_bor_caseid=16071000004208
Param Type = n
trn_bor_hearingrow=17
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,docid,case_no,court_code,puname,court_name,prev_purpose_code,prev_hear_date,bench_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:docid,:case_no,:court_code,:puname,:court_name,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,:trn_bor_caseid,null,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 17994000009819
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
new_purpose_code = 112
new_case_purpose = 10035000000979
next_hear_date = 28/11/2025
new_purpose_group = 19971000000602
court_name = 11599000000000
puname = POOJAMEENA
court_code = 10006
trn_bor_caseid = 13310000005020
docid = 100062020/3185
prev_purpose_code = 112
prev_hear_date = 29/08/2025
bench_code = 15
case_no = 2020/3185
manual_case_no =
TRN_BOR_HEARINGrow = 18
Posting record
Param Type = n
trn_bor_hearingid=17994000009819
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_purpose_code=112
Param Type = c
new_case_purpose=10035000000979
Param Type = c
next_hear_date=28/11/2025 00:00:00
Param Type = n
new_purpose_group=19971000000602
Param Type = c
court_name=11599000000000
Param Type = c
puname=POOJAMEENA
Param Type = c
court_code=10006
Param Type = n
trn_bor_caseid=13310000005020
Param Type = c
docid=100062020/3185
Param Type = c
prev_purpose_code=112
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
bench_code=15
Param Type = c
case_no=2020/3185
Param Type = n
trn_bor_hearingrow=18
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,court_name,puname,court_code,trn_bor_caseid,docid,prev_purpose_code,prev_hear_date,bench_code,case_no,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:court_name,:puname,:court_code,:trn_bor_caseid,:docid,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,:case_no,null,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009820
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 4
new_case_purpose = 10107000000777
new_purpose_code = 120
next_hear_date = 10/10/2025
new_purpose_group = 19973000000612
prev_hear_date = 29/08/2025
court_code = 10006
docid = 100062020/3394
puname = POOJAMEENA
court_name = 11599000000000
case_no = 2020/3394
bench_code = 15
prev_purpose_code = 120
trn_bor_caseid = 13773000004026
manual_case_no =
TRN_BOR_HEARINGrow = 19
Posting record
Param Type = n
trn_bor_hearingid=17994000009820
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=10107000000777
Param Type = c
new_purpose_code=120
Param Type = c
next_hear_date=10/10/2025 00:00:00
Param Type = n
new_purpose_group=19973000000612
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
court_code=10006
Param Type = c
docid=100062020/3394
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
case_no=2020/3394
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=120
Param Type = n
trn_bor_caseid=13773000004026
Param Type = n
trn_bor_hearingrow=19
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,new_purpose_code,next_hear_date,new_purpose_group,prev_hear_date,court_code,docid,puname,court_name,case_no,bench_code,prev_purpose_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,:new_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:docid,:puname,:court_name,:case_no,:bench_code,:prev_purpose_code,:trn_bor_caseid,null,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17994000009821
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 5
new_case_purpose = 10107000000777
prev_hear_date = 29/08/2025
next_hear_date = 29/09/2025
new_purpose_group = 19973000000612
new_purpose_code = 120
court_code = 10006
docid = 100062020/3645
puname = POOJAMEENA
court_name = 11599000000000
case_no = 2020/3645
bench_code = 15
prev_purpose_code = 120
trn_bor_caseid = 19727000004564
manual_case_no =
TRN_BOR_HEARINGrow = 20
Posting record
Param Type = n
trn_bor_hearingid=17994000009821
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=10107000000777
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
next_hear_date=29/09/2025 00:00:00
Param Type = n
new_purpose_group=19973000000612
Param Type = c
new_purpose_code=120
Param Type = c
court_code=10006
Param Type = c
docid=100062020/3645
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
case_no=2020/3645
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=120
Param Type = n
trn_bor_caseid=19727000004564
Param Type = n
trn_bor_hearingrow=20
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,prev_hear_date,next_hear_date,new_purpose_group,new_purpose_code,court_code,docid,puname,court_name,case_no,bench_code,prev_purpose_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:docid,:puname,:court_name,:case_no,:bench_code,:prev_purpose_code,:trn_bor_caseid,null,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009822
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
new_case_purpose = 10110000000719
prev_hear_date = 29/08/2025
next_hear_date = 29/09/2025
new_purpose_group = 19971000000602
new_purpose_code = 122
prev_purpose_code = 122
court_code = 10006
docid = 100062020/3647
court_name = 11599000000000
puname = POOJAMEENA
manual_case_no =
trn_bor_caseid = 19778000004619
case_no = 2020/3647
bench_code = 15
TRN_BOR_HEARINGrow = 21
Posting record
Param Type = n
trn_bor_hearingid=17994000009822
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=10110000000719
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
next_hear_date=29/09/2025 00:00:00
Param Type = n
new_purpose_group=19971000000602
Param Type = c
new_purpose_code=122
Param Type = c
prev_purpose_code=122
Param Type = c
court_code=10006
Param Type = c
docid=100062020/3647
Param Type = c
court_name=11599000000000
Param Type = c
puname=POOJAMEENA
Param Type = n
trn_bor_caseid=19778000004619
Param Type = c
case_no=2020/3647
Param Type = c
bench_code=15
Param Type = n
trn_bor_hearingrow=21
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,prev_hear_date,next_hear_date,new_purpose_group,new_purpose_code,prev_purpose_code,court_code,docid,court_name,puname,manual_case_no,trn_bor_caseid,case_no,bench_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:prev_purpose_code,:court_code,:docid,:court_name,:puname,null,:trn_bor_caseid,:case_no,:bench_code,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 17994000009823
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_hear_date = 29/08/2025
prev_purpose_code = 120
new_case_purpose = 10107000000777
next_hear_date = 08/09/2025
new_purpose_group = 19973000000612
new_purpose_code = 120
court_code = 10006
docid = 100062020/4047
puname = POOJAMEENA
court_name = 11599000000000
manual_case_no =
bench_code = 15
case_no = 2020/4047
trn_bor_caseid = 13512000004584
TRN_BOR_HEARINGrow = 22
Posting record
Param Type = n
trn_bor_hearingid=17994000009823
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
prev_purpose_code=120
Param Type = c
new_case_purpose=10107000000777
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = n
new_purpose_group=19973000000612
Param Type = c
new_purpose_code=120
Param Type = c
court_code=10006
Param Type = c
docid=100062020/4047
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
bench_code=15
Param Type = c
case_no=2020/4047
Param Type = n
trn_bor_caseid=13512000004584
Param Type = n
trn_bor_hearingrow=22
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,court_code,docid,puname,court_name,manual_case_no,bench_code,case_no,trn_bor_caseid,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:docid,:puname,:court_name,null,:bench_code,:case_no,:trn_bor_caseid,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009824
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 15
prev_hear_date = 29/08/2025
prev_purpose_code = 113
new_case_purpose = 10037000000780
next_hear_date = 10/10/2025
new_purpose_group = 19971000000602
new_purpose_code = 113
court_code = 10006
docid = 100062020/4186
puname = POOJAMEENA
court_name = 11599000000000
manual_case_no =
bench_code = 15
case_no = 2020/4186
trn_bor_caseid = 13088000005037
TRN_BOR_HEARINGrow = 23
Posting record
Param Type = n
trn_bor_hearingid=17994000009824
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
prev_purpose_code=113
Param Type = c
new_case_purpose=10037000000780
Param Type = c
next_hear_date=10/10/2025 00:00:00
Param Type = n
new_purpose_group=19971000000602
Param Type = c
new_purpose_code=113
Param Type = c
court_code=10006
Param Type = c
docid=100062020/4186
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
bench_code=15
Param Type = c
case_no=2020/4186
Param Type = n
trn_bor_caseid=13088000005037
Param Type = n
trn_bor_hearingrow=23
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,court_code,docid,puname,court_name,manual_case_no,bench_code,case_no,trn_bor_caseid,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:docid,:puname,:court_name,null,:bench_code,:case_no,:trn_bor_caseid,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 17994000009825
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 13
prev_hear_date = 29/08/2025
prev_purpose_code = 120
new_case_purpose = 10107000000777
next_hear_date = 10/10/2025
new_purpose_group = 19973000000612
new_purpose_code = 120
bench_code = 15
court_code = 10006
court_name = 11599000000000
puname = POOJAMEENA
docid = 100062020/4937
manual_case_no =
trn_bor_caseid = 12597000004817
case_no = 2020/4937
TRN_BOR_HEARINGrow = 24
Posting record
Param Type = n
trn_bor_hearingid=17994000009825
Param Type = n
trn_bor_mhearingid=17994000009801
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=29/08/2025 00:00:00
Param Type = c
prev_purpose_code=120
Param Type = c
new_case_purpose=10107000000777
Param Type = c
next_hear_date=10/10/2025 00:00:00
Param Type = n
new_purpose_group=19973000000612
Param Type = c
new_purpose_code=120
Param Type = c
bench_code=15
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
puname=POOJAMEENA
Param Type = c
docid=100062020/4937
Param Type = n
trn_bor_caseid=12597000004817
Param Type = c
case_no=2020/4937
Param Type = n
trn_bor_hearingrow=24
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,bench_code,court_code,court_name,puname,docid,manual_case_no,trn_bor_caseid,case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:bench_code,:court_code,:court_name,:puname,:docid,null,:trn_bor_caseid,:case_no,:trn_bor_hearingrow)
Time elapsed for insert/update = 3965891145534
>>Executing genmaps
>>Posting from bocup to rbchh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/165 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???. idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 13801000003408 idvalue 0
Mapped case_docid Row = 1 value = 100062020/165 idvalue 0
Mapped case_purpose Row = 1 value = 10189000000601 idvalue 0
Mapped case_purpose_code Row = 1 value = 201 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 13801000003408
case_docid = 100062020/165
case_no = 2020/165
prev_hearing_date = 29/08/2025
hearing_date = 08/09/2025
prev_case_purposename = ???.
prev_case_purpose =
prev_case_purposename=???.
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???.
Time elapsed = 4
prev_case_purpose after validation = 10189000000601
case_purpose = 10189000000601
case_purpose_code = 201
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 17994000009826
MapName bocup1
SourceId 17994000009802
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
prev_case_purpose = 10189000000601
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 201
hearing_date = 08/09/2025
prev_case_purposename = ???.
court_code = 10006
case_no = 2020/165
case_docid = 100062020/165
case_purpose = 10189000000601
trn_bor_caseregid = 13801000003408
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009826
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009802
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10189000000601
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=201
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
prev_case_purposename=???.
Param Type = c
court_code=10006
Param Type = c
case_no=2020/165
Param Type = c
case_docid=100062020/165
Param Type = c
case_purpose=10189000000601
Param Type = n
trn_bor_caseregid=13801000003408
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 2
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/283 idvalue 0
Mapped hearing_date Row = 1 value = 15/09/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 16117000003737 idvalue 0
Mapped case_docid Row = 1 value = 100062020/283 idvalue 0
Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0
Mapped case_purpose_code Row = 1 value = 120 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 16117000003737
case_docid = 100062020/283
case_no = 2020/283
prev_hearing_date = 29/08/2025
hearing_date = 15/09/2025
prev_case_purposename = ???????? ????????? ????
prev_case_purpose =
prev_case_purposename=???????? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???????? ????????? ????
Time elapsed = 6
prev_case_purpose after validation = 10107000000777
case_purpose = 10107000000777
case_purpose_code = 120
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 15
RecordId = 17994000009827
MapName bocup1
SourceId 17994000009803
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 15/09/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2020/283
case_docid = 100062020/283
case_purpose = 10107000000777
trn_bor_caseregid = 16117000003737
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009827
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009803
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10107000000777
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=120
Param Type = c
hearing_date=15/09/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/283
Param Type = c
case_docid=100062020/283
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=16117000003737
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 3
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/478 idvalue 0
Mapped hearing_date Row = 1 value = 21/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 14026000003241 idvalue 0
Mapped case_docid Row = 1 value = 100062020/478 idvalue 0
Mapped case_purpose Row = 1 value = 10035000000979 idvalue 0
Mapped case_purpose_code Row = 1 value = 112 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 14026000003241
case_docid = 100062020/478
case_no = 2020/478
prev_hearing_date = 29/08/2025
hearing_date = 21/11/2025
prev_case_purposename = ?????? ?????
prev_case_purpose =
prev_case_purposename=?????? ?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????? ?????
Time elapsed = 6
prev_case_purpose after validation = 10035000000979
case_purpose = 10035000000979
case_purpose_code = 112
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 10
RecordId = 17994000009828
MapName bocup1
SourceId 17994000009804
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10035000000979
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 112
hearing_date = 21/11/2025
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2020/478
case_docid = 100062020/478
case_purpose = 10035000000979
trn_bor_caseregid = 14026000003241
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009828
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009804
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10035000000979
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=112
Param Type = c
hearing_date=21/11/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/478
Param Type = c
case_docid=100062020/478
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=14026000003241
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 4
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/479 idvalue 0
Mapped hearing_date Row = 1 value = 21/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 14050000003562 idvalue 0
Mapped case_docid Row = 1 value = 100062020/479 idvalue 0
Mapped case_purpose Row = 1 value = 10035000000979 idvalue 0
Mapped case_purpose_code Row = 1 value = 112 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 14050000003562
case_docid = 100062020/479
case_no = 2020/479
prev_hearing_date = 29/08/2025
hearing_date = 21/11/2025
prev_case_purposename = ?????? ?????
prev_case_purpose =
prev_case_purpose after validation = 10035000000979
case_purpose = 10035000000979
case_purpose_code = 112
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009829
MapName bocup1
SourceId 17994000009805
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10035000000979
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 112
hearing_date = 21/11/2025
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2020/479
case_docid = 100062020/479
case_purpose = 10035000000979
trn_bor_caseregid = 14050000003562
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009829
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009805
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10035000000979
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=112
Param Type = c
hearing_date=21/11/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/479
Param Type = c
case_docid=100062020/479
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=14050000003562
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 5
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/528 idvalue 0
Mapped hearing_date Row = 1 value = 21/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 15764000002775 idvalue 0
Mapped case_docid Row = 1 value = 100062020/528 idvalue 0
Mapped case_purpose Row = 1 value = 10035000000979 idvalue 0
Mapped case_purpose_code Row = 1 value = 112 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 15764000002775
case_docid = 100062020/528
case_no = 2020/528
prev_hearing_date = 29/08/2025
hearing_date = 21/11/2025
prev_case_purposename = ?????? ?????
prev_case_purpose =
prev_case_purpose after validation = 10035000000979
case_purpose = 10035000000979
case_purpose_code = 112
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009830
MapName bocup1
SourceId 17994000009806
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10035000000979
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 112
hearing_date = 21/11/2025
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2020/528
case_docid = 100062020/528
case_purpose = 10035000000979
trn_bor_caseregid = 15764000002775
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009830
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009806
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:40
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10035000000979
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=112
Param Type = c
hearing_date=21/11/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/528
Param Type = c
case_docid=100062020/528
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=15764000002775
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 6
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/595 idvalue 0
Mapped hearing_date Row = 1 value = 15/09/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 18757000003886 idvalue 0
Mapped case_docid Row = 1 value = 100062020/595 idvalue 0
Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0
Mapped case_purpose_code Row = 1 value = 120 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 18757000003886
case_docid = 100062020/595
case_no = 2020/595
prev_hearing_date = 29/08/2025
hearing_date = 15/09/2025
prev_case_purposename = ???????? ????????? ????
prev_case_purpose =
prev_case_purposename=???????? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???????? ????????? ????
Time elapsed = 5
prev_case_purpose after validation = 10107000000777
case_purpose = 10107000000777
case_purpose_code = 120
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 17994000009831
MapName bocup1
SourceId 17994000009807
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 15/09/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2020/595
case_docid = 100062020/595
case_purpose = 10107000000777
trn_bor_caseregid = 18757000003886
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009831
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009807
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:41
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10107000000777
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=120
Param Type = c
hearing_date=15/09/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/595
Param Type = c
case_docid=100062020/595
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=18757000003886
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 7
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/652 idvalue 0
Mapped hearing_date Row = 1 value = 29/09/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???. idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 15372000003727 idvalue 0
Mapped case_docid Row = 1 value = 100062020/652 idvalue 0
Mapped case_purpose Row = 1 value = 10189000000601 idvalue 0
Mapped case_purpose_code Row = 1 value = 201 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 15372000003727
case_docid = 100062020/652
case_no = 2020/652
prev_hearing_date = 29/08/2025
hearing_date = 29/09/2025
prev_case_purposename = ???.
prev_case_purpose =
prev_case_purposename=???.
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???.
Time elapsed = 7
prev_case_purpose after validation = 10189000000601
case_purpose = 10189000000601
case_purpose_code = 201
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009832
MapName bocup1
SourceId 17994000009808
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10189000000601
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 201
hearing_date = 29/09/2025
prev_case_purposename = ???.
court_code = 10006
case_no = 2020/652
case_docid = 100062020/652
case_purpose = 10189000000601
trn_bor_caseregid = 15372000003727
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009832
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009808
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:41
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10189000000601
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=201
Param Type = c
hearing_date=29/09/2025 00:00:00
Param Type = c
prev_case_purposename=???.
Param Type = c
court_code=10006
Param Type = c
case_no=2020/652
Param Type = c
case_docid=100062020/652
Param Type = c
case_purpose=10189000000601
Param Type = n
trn_bor_caseregid=15372000003727
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 8
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/744 idvalue 0
Mapped hearing_date Row = 1 value = 21/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 19133000004049 idvalue 0
Mapped case_docid Row = 1 value = 100062020/744 idvalue 0
Mapped case_purpose Row = 1 value = 10173000000547 idvalue 0
Mapped case_purpose_code Row = 1 value = 167 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 19133000004049
case_docid = 100062020/744
case_no = 2020/744
prev_hearing_date = 29/08/2025
hearing_date = 21/11/2025
prev_case_purposename = ?????? ????? ????
prev_case_purpose =
prev_case_purposename=?????? ????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????? ????? ????
Time elapsed = 4
prev_case_purpose after validation = 10173000000547
case_purpose = 10173000000547
case_purpose_code = 167
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009833
MapName bocup1
SourceId 17994000009809
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10173000000547
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 167
hearing_date = 21/11/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2020/744
case_docid = 100062020/744
case_purpose = 10173000000547
trn_bor_caseregid = 19133000004049
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009833
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009809
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:41
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10173000000547
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=167
Param Type = c
hearing_date=21/11/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/744
Param Type = c
case_docid=100062020/744
Param Type = c
case_purpose=10173000000547
Param Type = n
trn_bor_caseregid=19133000004049
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 9
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/890 idvalue 0
Mapped hearing_date Row = 1 value = 21/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 18553000003006 idvalue 0
Mapped case_docid Row = 1 value = 100062020/890 idvalue 0
Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0
Mapped case_purpose_code Row = 1 value = 122 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 18553000003006
case_docid = 100062020/890
case_no = 2020/890
prev_hearing_date = 29/08/2025
hearing_date = 21/11/2025
prev_case_purposename = ?????? ????? ????
prev_case_purpose =
prev_case_purposename=?????? ????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????? ????? ????
Time elapsed = 10
prev_case_purpose after validation = 10110000000719
case_purpose = 10110000000719
case_purpose_code = 122
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17994000009834
MapName bocup1
SourceId 17994000009810
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 21/11/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2020/890
case_docid = 100062020/890
case_purpose = 10110000000719
trn_bor_caseregid = 18553000003006
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009834
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009810
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:41
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10110000000719
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=122
Param Type = c
hearing_date=21/11/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/890
Param Type = c
case_docid=100062020/890
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=18553000003006
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 10
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/1355 idvalue 0
Mapped hearing_date Row = 1 value = 21/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 10117000003214 idvalue 0
Mapped case_docid Row = 1 value = 100062020/1355 idvalue 0
Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0
Mapped case_purpose_code Row = 1 value = 122 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 10117000003214
case_docid = 100062020/1355
case_no = 2020/1355
prev_hearing_date = 29/08/2025
hearing_date = 21/11/2025
prev_case_purposename = ?????? ????? ????
prev_case_purpose =
prev_case_purpose after validation = 10110000000719
case_purpose = 10110000000719
case_purpose_code = 122
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 15
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009835
MapName bocup1
SourceId 17994000009811
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 21/11/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2020/1355
case_docid = 100062020/1355
case_purpose = 10110000000719
trn_bor_caseregid = 10117000003214
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009835
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009811
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:41
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10110000000719
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=122
Param Type = c
hearing_date=21/11/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/1355
Param Type = c
case_docid=100062020/1355
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=10117000003214
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 11
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/1387 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???. idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 12585000003678 idvalue 0
Mapped case_docid Row = 1 value = 100062020/1387 idvalue 0
Mapped case_purpose Row = 1 value = 10189000000601 idvalue 0
Mapped case_purpose_code Row = 1 value = 201 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 12585000003678
case_docid = 100062020/1387
case_no = 2020/1387
prev_hearing_date = 29/08/2025
hearing_date = 08/09/2025
prev_case_purposename = ???.
prev_case_purpose =
prev_case_purposename=???.
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???.
Time elapsed = 4
prev_case_purpose after validation = 10189000000601
case_purpose = 10189000000601
case_purpose_code = 201
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009836
MapName bocup1
SourceId 17994000009812
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10189000000601
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 201
hearing_date = 08/09/2025
prev_case_purposename = ???.
court_code = 10006
case_no = 2020/1387
case_docid = 100062020/1387
case_purpose = 10189000000601
trn_bor_caseregid = 12585000003678
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009836
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009812
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:41
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10189000000601
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=201
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
prev_case_purposename=???.
Param Type = c
court_code=10006
Param Type = c
case_no=2020/1387
Param Type = c
case_docid=100062020/1387
Param Type = c
case_purpose=10189000000601
Param Type = n
trn_bor_caseregid=12585000003678
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 12
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/1719 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 17579000004293 idvalue 0
Mapped case_docid Row = 1 value = 100062020/1719 idvalue 0
Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0
Mapped case_purpose_code Row = 1 value = 120 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 17579000004293
case_docid = 100062020/1719
case_no = 2020/1719
prev_hearing_date = 29/08/2025
hearing_date = 11/09/2025
prev_case_purposename = ???????? ????????? ????
prev_case_purpose =
prev_case_purposename=???????? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???????? ????????? ????
Time elapsed = 3
prev_case_purpose after validation = 10107000000777
case_purpose = 10107000000777
case_purpose_code = 120
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 16
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 17994000009837
MapName bocup1
SourceId 17994000009813
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 11/09/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2020/1719
case_docid = 100062020/1719
case_purpose = 10107000000777
trn_bor_caseregid = 17579000004293
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009837
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009813
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:41
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10107000000777
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=120
Param Type = c
hearing_date=11/09/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/1719
Param Type = c
case_docid=100062020/1719
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=17579000004293
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 13
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/1824 idvalue 0
Mapped hearing_date Row = 1 value = 10/10/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 11126000003318 idvalue 0
Mapped case_docid Row = 1 value = 100062020/1824 idvalue 0
Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0
Mapped case_purpose_code Row = 1 value = 120 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 11126000003318
case_docid = 100062020/1824
case_no = 2020/1824
prev_hearing_date = 29/08/2025
hearing_date = 10/10/2025
prev_case_purposename = ???????? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 10107000000777
case_purpose = 10107000000777
case_purpose_code = 120
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 20
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 17994000009838
MapName bocup1
SourceId 17994000009814
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 10/10/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2020/1824
case_docid = 100062020/1824
case_purpose = 10107000000777
trn_bor_caseregid = 11126000003318
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009838
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009814
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:41
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10107000000777
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=120
Param Type = c
hearing_date=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/1824
Param Type = c
case_docid=100062020/1824
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=11126000003318
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 14
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/1836 idvalue 0
Mapped hearing_date Row = 1 value = 28/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 14264000003331 idvalue 0
Mapped case_docid Row = 1 value = 100062020/1836 idvalue 0
Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0
Mapped case_purpose_code Row = 1 value = 122 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 14264000003331
case_docid = 100062020/1836
case_no = 2020/1836
prev_hearing_date = 29/08/2025
hearing_date = 28/11/2025
prev_case_purposename = ?????? ????? ????
prev_case_purpose =
prev_case_purposename=?????? ????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????? ????? ????
Time elapsed = 15
prev_case_purpose after validation = 10110000000719
case_purpose = 10110000000719
case_purpose_code = 122
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 1
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17994000009839
MapName bocup1
SourceId 17994000009815
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 28/11/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2020/1836
case_docid = 100062020/1836
case_purpose = 10110000000719
trn_bor_caseregid = 14264000003331
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009839
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009815
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:41
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10110000000719
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=122
Param Type = c
hearing_date=28/11/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/1836
Param Type = c
case_docid=100062020/1836
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=14264000003331
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 15
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/2063 idvalue 0
Mapped hearing_date Row = 1 value = 15/12/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 15095000003405 idvalue 0
Mapped case_docid Row = 1 value = 100062020/2063 idvalue 0
Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0
Mapped case_purpose_code Row = 1 value = 120 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 15095000003405
case_docid = 100062020/2063
case_no = 2020/2063
prev_hearing_date = 29/08/2025
hearing_date = 15/12/2025
prev_case_purposename = ???????? ????????? ????
prev_case_purpose =
prev_case_purposename=???????? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???????? ????????? ????
Time elapsed = 4
prev_case_purpose after validation = 10107000000777
case_purpose = 10107000000777
case_purpose_code = 120
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 1
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 27
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 14
RecordId = 17994000009840
MapName bocup1
SourceId 17994000009816
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 15/12/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2020/2063
case_docid = 100062020/2063
case_purpose = 10107000000777
trn_bor_caseregid = 15095000003405
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009840
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009816
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:41
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10107000000777
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=120
Param Type = c
hearing_date=15/12/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/2063
Param Type = c
case_docid=100062020/2063
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=15095000003405
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 16
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/2608 idvalue 0
Mapped hearing_date Row = 1 value = 28/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 14347000000236 idvalue 0
Mapped case_docid Row = 1 value = 100062020/2608 idvalue 0
Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0
Mapped case_purpose_code Row = 1 value = 122 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 14347000000236
case_docid = 100062020/2608
case_no = 2020/2608
prev_hearing_date = 29/08/2025
hearing_date = 28/11/2025
prev_case_purposename = ?????? ????? ????
prev_case_purpose =
prev_case_purposename=?????? ????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????? ????? ????
Time elapsed = 7
prev_case_purpose after validation = 10110000000719
case_purpose = 10110000000719
case_purpose_code = 122
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 12
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 17994000009841
MapName bocup1
SourceId 17994000009817
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 28/11/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2020/2608
case_docid = 100062020/2608
case_purpose = 10110000000719
trn_bor_caseregid = 14347000000236
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009841
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009817
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:41
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10110000000719
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=122
Param Type = c
hearing_date=28/11/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/2608
Param Type = c
case_docid=100062020/2608
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=14347000000236
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 17
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/2657 idvalue 0
Mapped hearing_date Row = 1 value = 28/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 16071000004208 idvalue 0
Mapped case_docid Row = 1 value = 100062020/2657 idvalue 0
Mapped case_purpose Row = 1 value = 10035000000979 idvalue 0
Mapped case_purpose_code Row = 1 value = 112 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 16071000004208
case_docid = 100062020/2657
case_no = 2020/2657
prev_hearing_date = 29/08/2025
hearing_date = 28/11/2025
prev_case_purposename = ?????? ?????
prev_case_purpose =
prev_case_purposename=?????? ?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????? ?????
Time elapsed = 5
prev_case_purpose after validation = 10035000000979
case_purpose = 10035000000979
case_purpose_code = 112
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009842
MapName bocup1
SourceId 17994000009818
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 9
prev_case_purpose = 10035000000979
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 112
hearing_date = 28/11/2025
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2020/2657
case_docid = 100062020/2657
case_purpose = 10035000000979
trn_bor_caseregid = 16071000004208
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009842
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009818
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:42
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10035000000979
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=112
Param Type = c
hearing_date=28/11/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/2657
Param Type = c
case_docid=100062020/2657
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=16071000004208
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 18
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/3185 idvalue 0
Mapped hearing_date Row = 1 value = 28/11/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 13310000005020 idvalue 0
Mapped case_docid Row = 1 value = 100062020/3185 idvalue 0
Mapped case_purpose Row = 1 value = 10035000000979 idvalue 0
Mapped case_purpose_code Row = 1 value = 112 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 13310000005020
case_docid = 100062020/3185
case_no = 2020/3185
prev_hearing_date = 29/08/2025
hearing_date = 28/11/2025
prev_case_purposename = ?????? ?????
prev_case_purpose =
prev_case_purpose after validation = 10035000000979
case_purpose = 10035000000979
case_purpose_code = 112
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 4
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 18
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009843
MapName bocup1
SourceId 17994000009819
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
prev_case_purpose = 10035000000979
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 112
hearing_date = 28/11/2025
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2020/3185
case_docid = 100062020/3185
case_purpose = 10035000000979
trn_bor_caseregid = 13310000005020
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009843
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009819
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:42
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10035000000979
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=112
Param Type = c
hearing_date=28/11/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/3185
Param Type = c
case_docid=100062020/3185
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=13310000005020
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 19
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/3394 idvalue 0
Mapped hearing_date Row = 1 value = 10/10/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 13773000004026 idvalue 0
Mapped case_docid Row = 1 value = 100062020/3394 idvalue 0
Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0
Mapped case_purpose_code Row = 1 value = 120 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 13773000004026
case_docid = 100062020/3394
case_no = 2020/3394
prev_hearing_date = 29/08/2025
hearing_date = 10/10/2025
prev_case_purposename = ???????? ????????? ????
prev_case_purpose =
prev_case_purposename=???????? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???????? ????????? ????
Time elapsed = 5
prev_case_purpose after validation = 10107000000777
case_purpose = 10107000000777
case_purpose_code = 120
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009844
MapName bocup1
SourceId 17994000009820
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 10/10/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2020/3394
case_docid = 100062020/3394
case_purpose = 10107000000777
trn_bor_caseregid = 13773000004026
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009844
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009820
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:42
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10107000000777
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=120
Param Type = c
hearing_date=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/3394
Param Type = c
case_docid=100062020/3394
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=13773000004026
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 20
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/3645 idvalue 0
Mapped hearing_date Row = 1 value = 29/09/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 19727000004564 idvalue 0
Mapped case_docid Row = 1 value = 100062020/3645 idvalue 0
Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0
Mapped case_purpose_code Row = 1 value = 120 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 19727000004564
case_docid = 100062020/3645
case_no = 2020/3645
prev_hearing_date = 29/08/2025
hearing_date = 29/09/2025
prev_case_purposename = ???????? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 10107000000777
case_purpose = 10107000000777
case_purpose_code = 120
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 17994000009845
MapName bocup1
SourceId 17994000009821
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 29/09/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2020/3645
case_docid = 100062020/3645
case_purpose = 10107000000777
trn_bor_caseregid = 19727000004564
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009845
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009821
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:42
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10107000000777
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=120
Param Type = c
hearing_date=29/09/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/3645
Param Type = c
case_docid=100062020/3645
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=19727000004564
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 21
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/3647 idvalue 0
Mapped hearing_date Row = 1 value = 29/09/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 19778000004619 idvalue 0
Mapped case_docid Row = 1 value = 100062020/3647 idvalue 0
Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0
Mapped case_purpose_code Row = 1 value = 122 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 19778000004619
case_docid = 100062020/3647
case_no = 2020/3647
prev_hearing_date = 29/08/2025
hearing_date = 29/09/2025
prev_case_purposename = ?????? ????? ????
prev_case_purpose =
prev_case_purposename=?????? ????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????? ????? ????
Time elapsed = 6
prev_case_purpose after validation = 10110000000719
case_purpose = 10110000000719
case_purpose_code = 122
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 17994000009846
MapName bocup1
SourceId 17994000009822
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 29/09/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2020/3647
case_docid = 100062020/3647
case_purpose = 10110000000719
trn_bor_caseregid = 19778000004619
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009846
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009822
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:42
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10110000000719
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=122
Param Type = c
hearing_date=29/09/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/3647
Param Type = c
case_docid=100062020/3647
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=19778000004619
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 22
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/4047 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 13512000004584 idvalue 0
Mapped case_docid Row = 1 value = 100062020/4047 idvalue 0
Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0
Mapped case_purpose_code Row = 1 value = 120 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 13512000004584
case_docid = 100062020/4047
case_no = 2020/4047
prev_hearing_date = 29/08/2025
hearing_date = 08/09/2025
prev_case_purposename = ???????? ????????? ????
prev_case_purpose =
prev_case_purposename=???????? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???????? ????????? ????
Time elapsed = 3
prev_case_purpose after validation = 10107000000777
case_purpose = 10107000000777
case_purpose_code = 120
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 1
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009847
MapName bocup1
SourceId 17994000009823
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 08/09/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2020/4047
case_docid = 100062020/4047
case_purpose = 10107000000777
trn_bor_caseregid = 13512000004584
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009847
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009823
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:42
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10107000000777
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=120
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/4047
Param Type = c
case_docid=100062020/4047
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=13512000004584
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 23
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/4186 idvalue 0
Mapped hearing_date Row = 1 value = 10/10/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 13088000005037 idvalue 0
Mapped case_docid Row = 1 value = 100062020/4186 idvalue 0
Mapped case_purpose Row = 1 value = 10037000000780 idvalue 0
Mapped case_purpose_code Row = 1 value = 113 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 13088000005037
case_docid = 100062020/4186
case_no = 2020/4186
prev_hearing_date = 29/08/2025
hearing_date = 10/10/2025
prev_case_purposename = ?????? ????
prev_case_purpose =
prev_case_purposename=?????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????? ????
Time elapsed = 4
prev_case_purpose after validation = 10037000000780
case_purpose = 10037000000780
case_purpose_code = 113
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 17994000009848
MapName bocup1
SourceId 17994000009824
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10037000000780
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 113
hearing_date = 10/10/2025
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2020/4186
case_docid = 100062020/4186
case_purpose = 10037000000780
trn_bor_caseregid = 13088000005037
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009848
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009824
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:42
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10037000000780
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=113
Param Type = c
hearing_date=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/4186
Param Type = c
case_docid=100062020/4186
Param Type = c
case_purpose=10037000000780
Param Type = n
trn_bor_caseregid=13088000005037
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from bocup to rbchh from row 24
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2020/4937 idvalue 0
Mapped hearing_date Row = 1 value = 10/10/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/08/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 12597000004817 idvalue 0
Mapped case_docid Row = 1 value = 100062020/4937 idvalue 0
Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0
Mapped case_purpose_code Row = 1 value = 120 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0
>>Validating rbchh
>>Frame No 1
doc_date =
Evaluating - date()
Result of date = 01/09/2025
doc_date after validation = 01/09/2025
court_code = 10006
trn_bor_caseregid = 12597000004817
case_docid = 100062020/4937
case_no = 2020/4937
prev_hearing_date = 29/08/2025
hearing_date = 10/10/2025
prev_case_purposename = ???????? ????????? ????
prev_case_purpose =
prev_case_purposename=???????? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???????? ????????? ????
Time elapsed = 4
prev_case_purpose after validation = 10107000000777
case_purpose = 10107000000777
case_purpose_code = 120
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 17994000009849
MapName bocup1
SourceId 17994000009825
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 01/09/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 10/10/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2020/4937
case_docid = 100062020/4937
case_purpose = 10107000000777
trn_bor_caseregid = 12597000004817
prev_hearing_date = 29/08/2025
Posting record
Param Type = n
trn_bor_case_histid=17994000009849
Param Type = c
mapname=bocup1
Param Type = n
sourceid=17994000009825
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=01/09/2025 12:25:42
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=01/09/2025 12:25:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10107000000777
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=01/09/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=120
Param Type = c
hearing_date=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2020/4937
Param Type = c
case_docid=100062020/4937
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=12597000004817
Param Type = c
prev_hearing_date=29/08/2025 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
Time elapsed for Gen Map = 3965891147587
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=13801000003408
@trn_bor_caseregid=13801000003408
*hearingdate=08/09/2025
*case_purpose_name=10189000000601
*case_purpose_code=201
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13801000003408 for update
Time elapsed = 170
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13801000003408
Time elapsed = 143
Param Type = c
hearingdate=08/09/2025 00:00:00
Param Type = c
case_purpose_name=10189000000601
Param Type = c
case_purpose_code=201
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=13801000003408
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=16117000003737
@trn_bor_caseregid=16117000003737
*hearingdate=15/09/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16117000003737 for update
Time elapsed = 115
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16117000003737
Time elapsed = 84
Param Type = c
hearingdate=15/09/2025 00:00:00
Param Type = c
case_purpose_name=10107000000777
Param Type = c
case_purpose_code=120
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=16117000003737
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=14026000003241
@trn_bor_caseregid=14026000003241
*hearingdate=21/11/2025
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14026000003241 for update
Time elapsed = 61
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14026000003241
Time elapsed = 58
Param Type = c
hearingdate=21/11/2025 00:00:00
Param Type = c
case_purpose_name=10035000000979
Param Type = c
case_purpose_code=112
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=14026000003241
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=14050000003562
@trn_bor_caseregid=14050000003562
*hearingdate=21/11/2025
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14050000003562 for update
Time elapsed = 94
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14050000003562
Time elapsed = 120
Param Type = c
hearingdate=21/11/2025 00:00:00
Param Type = c
case_purpose_name=10035000000979
Param Type = c
case_purpose_code=112
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=14050000003562
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=15764000002775
@trn_bor_caseregid=15764000002775
*hearingdate=21/11/2025
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15764000002775 for update
Time elapsed = 92
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15764000002775
Time elapsed = 58
Param Type = c
hearingdate=21/11/2025 00:00:00
Param Type = c
case_purpose_name=10035000000979
Param Type = c
case_purpose_code=112
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=15764000002775
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=18757000003886
@trn_bor_caseregid=18757000003886
*hearingdate=15/09/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18757000003886 for update
Time elapsed = 90
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18757000003886
Time elapsed = 85
Param Type = c
hearingdate=15/09/2025 00:00:00
Param Type = c
case_purpose_name=10107000000777
Param Type = c
case_purpose_code=120
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=18757000003886
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=15372000003727
@trn_bor_caseregid=15372000003727
*hearingdate=29/09/2025
*case_purpose_name=10189000000601
*case_purpose_code=201
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15372000003727 for update
Time elapsed = 70
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15372000003727
Time elapsed = 31
Param Type = c
hearingdate=29/09/2025 00:00:00
Param Type = c
case_purpose_name=10189000000601
Param Type = c
case_purpose_code=201
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=15372000003727
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=19133000004049
@trn_bor_caseregid=19133000004049
*hearingdate=21/11/2025
*case_purpose_name=10173000000547
*case_purpose_code=167
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19133000004049 for update
Time elapsed = 61
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19133000004049
Time elapsed = 60
Param Type = c
hearingdate=21/11/2025 00:00:00
Param Type = c
case_purpose_name=10173000000547
Param Type = c
case_purpose_code=167
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=19133000004049
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=18553000003006
@trn_bor_caseregid=18553000003006
*hearingdate=21/11/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18553000003006 for update
Time elapsed = 92
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18553000003006
Time elapsed = 54
Param Type = c
hearingdate=21/11/2025 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=18553000003006
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=10117000003214
@trn_bor_caseregid=10117000003214
*hearingdate=21/11/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10117000003214 for update
Time elapsed = 72
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10117000003214
Time elapsed = 64
Param Type = c
hearingdate=21/11/2025 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=10117000003214
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=12585000003678
@trn_bor_caseregid=12585000003678
*hearingdate=08/09/2025
*case_purpose_name=10189000000601
*case_purpose_code=201
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=12585000003678 for update
Time elapsed = 62
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=12585000003678
Time elapsed = 60
Param Type = c
hearingdate=08/09/2025 00:00:00
Param Type = c
case_purpose_name=10189000000601
Param Type = c
case_purpose_code=201
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=12585000003678
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=17579000004293
@trn_bor_caseregid=17579000004293
*hearingdate=11/09/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17579000004293 for update
Time elapsed = 66
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17579000004293
Time elapsed = 57
Param Type = c
hearingdate=11/09/2025 00:00:00
Param Type = c
case_purpose_name=10107000000777
Param Type = c
case_purpose_code=120
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=17579000004293
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=11126000003318
@trn_bor_caseregid=11126000003318
*hearingdate=10/10/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=11126000003318 for update
Time elapsed = 92
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=11126000003318
Time elapsed = 97
Param Type = c
hearingdate=10/10/2025 00:00:00
Param Type = c
case_purpose_name=10107000000777
Param Type = c
case_purpose_code=120
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=11126000003318
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=14264000003331
@trn_bor_caseregid=14264000003331
*hearingdate=28/11/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14264000003331 for update
Time elapsed = 67
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14264000003331
Time elapsed = 57
Param Type = c
hearingdate=28/11/2025 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=14264000003331
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=15095000003405
@trn_bor_caseregid=15095000003405
*hearingdate=15/12/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15095000003405 for update
Time elapsed = 99
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15095000003405
Time elapsed = 86
Param Type = c
hearingdate=15/12/2025 00:00:00
Param Type = c
case_purpose_name=10107000000777
Param Type = c
case_purpose_code=120
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=15095000003405
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=14347000000236
@trn_bor_caseregid=14347000000236
*hearingdate=28/11/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14347000000236 for update
Time elapsed = 63
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14347000000236
Time elapsed = 69
Param Type = c
hearingdate=28/11/2025 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=14347000000236
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=16071000004208
@trn_bor_caseregid=16071000004208
*hearingdate=28/11/2025
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16071000004208 for update
Time elapsed = 87
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16071000004208
Time elapsed = 81
Param Type = c
hearingdate=28/11/2025 00:00:00
Param Type = c
case_purpose_name=10035000000979
Param Type = c
case_purpose_code=112
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=16071000004208
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=13310000005020
@trn_bor_caseregid=13310000005020
*hearingdate=28/11/2025
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13310000005020 for update
Time elapsed = 62
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13310000005020
Time elapsed = 57
Param Type = c
hearingdate=28/11/2025 00:00:00
Param Type = c
case_purpose_name=10035000000979
Param Type = c
case_purpose_code=112
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=13310000005020
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=13773000004026
@trn_bor_caseregid=13773000004026
*hearingdate=10/10/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13773000004026 for update
Time elapsed = 62
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13773000004026
Time elapsed = 81
Param Type = c
hearingdate=10/10/2025 00:00:00
Param Type = c
case_purpose_name=10107000000777
Param Type = c
case_purpose_code=120
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=13773000004026
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=19727000004564
@trn_bor_caseregid=19727000004564
*hearingdate=29/09/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19727000004564 for update
Time elapsed = 69
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19727000004564
Time elapsed = 60
Param Type = c
hearingdate=29/09/2025 00:00:00
Param Type = c
case_purpose_name=10107000000777
Param Type = c
case_purpose_code=120
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=19727000004564
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=19778000004619
@trn_bor_caseregid=19778000004619
*hearingdate=29/09/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19778000004619 for update
Time elapsed = 64
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19778000004619
Time elapsed = 70
Param Type = c
hearingdate=29/09/2025 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=19778000004619
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=13512000004584
@trn_bor_caseregid=13512000004584
*hearingdate=08/09/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13512000004584 for update
Time elapsed = 99
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13512000004584
Time elapsed = 66
Param Type = c
hearingdate=08/09/2025 00:00:00
Param Type = c
case_purpose_name=10107000000777
Param Type = c
case_purpose_code=120
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=13512000004584
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=13088000005037
@trn_bor_caseregid=13088000005037
*hearingdate=10/10/2025
*case_purpose_name=10037000000780
*case_purpose_code=113
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13088000005037 for update
Time elapsed = 66
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13088000005037
Time elapsed = 121
Param Type = c
hearingdate=10/10/2025 00:00:00
Param Type = c
case_purpose_name=10037000000780
Param Type = c
case_purpose_code=113
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=13088000005037
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=12597000004817
@trn_bor_caseregid=12597000004817
*hearingdate=10/10/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=12597000004817 for update
Time elapsed = 103
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=12597000004817
Time elapsed = 57
Param Type = c
hearingdate=10/10/2025 00:00:00
Param Type = c
case_purpose_name=10107000000777
Param Type = c
case_purpose_code=120
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=12597000004817
Time elapsed for MD Map = 3965891153194
Time elapsed for Save History = 3965891153194
Time elapsed for Save Attachment = 3965891153194
Time elapsed for After Save WF Exec = 3965891153197
Transaction commited
Result : {"message":[{"msg":"Cause List Feedback Saved","recordid":"17994000009801"}]}
Savedata webservice completed
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=POOJAMEENA
Param Type = c
calledon=01/09/2025 12:25:43
Param Type = c
callfinished=01/09/2025 12:25:53
Param Type = c
structname=bocup
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=success
Param Type = n
timetaken=9774
Param Type = n
dbtimetaken=8197
insert into axmwslog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken) values (null,:username,to_date(:calledon,'dd/mm/yyyy hh24:mi:ss'),to_date(:callfinished,'dd/mm/yyyy hh24:mi:ss'),:structname,:recordid,:servicename,:serviceresult,:timetaken,:dbtimetaken)
Freeing AxProvider Resources
Freeing DbManager Resources