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
gcmsSurendrasingh827ccb0eea8a706c4c34a16891f84e7b![]()
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=surendrasingh
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=surendrasingh
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ???????? ??????? ??????,??????
Result = ???????? ??????? ??????,??????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=surendrasingh
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=surendrasingh
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = ADC
Result = ADC
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=surendrasingh
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=surendrasingh
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 17410000000002
Result = 17410000000002
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=surendrasingh
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 17657000000515
Result = 17657000000515
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=surendrasingh
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = surendrasingh
Result = surendrasingh
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=surendrasingh
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10635
Result = 10635
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=surendrasingh
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=surendrasingh
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Udaipur
Result = Udaipur
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=surendrasingh
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=surendrasingh
Time elapsed = 5
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=17657000000515
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=17657000000515
Time elapsed = 8
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=surendrasingh
Time elapsed = 10
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 17410000000000
Result = 17410000000000
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=surendrasingh
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=surendrasingh
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_reader
Result = court_reader
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 = 8
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=surendrasingh
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=surendrasingh
Time elapsed = 12
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 7
Result = 7
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('rb_admin') and lower(sname)='bocup' and stype = 't' )
Time elapsed = 4
select Props from axuseraccess where lower(rname)='rb_admin' and lower(sname)='bocup' and stype = 't'
Time elapsed = 8
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : rb_admin,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 = 5
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 = 5
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 = 8
select * from trn_bor_mhearing where trn_bor_mhearingid=0
Time elapsed = 7
select * from Axusers where 1=2
Time elapsed = 12
select distinct(fldname) from AxTempUserFields
Time elapsed = 3
select * from AxAttachWorkflow where lower(transid) = 'bocup'
Time elapsed = 6
select distinct(schemaname) from axschema where lower(transid)='rbcrt'
Time elapsed = 4
select trn_bor_caseregid from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 9
select hearingdate from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 6
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 = 3
select distinct(schemaname) from axschema where lower(transid)='rbcrt'
Time elapsed = 3
select case_purpose_code from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 3
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 = 8
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 = 4
select * from trn_bor_case_hist where trn_bor_case_histid=0
Time elapsed = 12
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 = 13/06/2025
cltype = R
benchname = ?????? ?????
benchcode = 15
cluser = bor2022
bench_mem1 = 0
bench_mem2 = 0
time zone difference = 0
>>Writing to tables bocup
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'bocup'
Time elapsed = 4
Saving to table TRN_BOR_MHEARING
select * from TRN_BOR_MHEARING where TRN_BOR_MHEARINGid=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 = 10
RecordId = 12889000010035
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 18
cluser = bor2022
benchcode = 15
bench_mem2 = 0
bench_mem1 = 0
benchname = ?????? ?????
courtcode = 10006
courtname = 11599000000000
cltype = R
cldate = 13/06/2025
Posting record
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:36
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
cluser=bor2022
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=13/06/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 = 4
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 = 6
RecordId = 12889000010036
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 3
prev_hear_date = 13/06/2025
puname = Surendrasingh
manual_case_no =
trn_bor_caseid = 10956000005859
prev_purpose_code = 120
case_no = 2022/412
bench_code = 15
new_purpose_group = 19973000000612
court_code = 10006
new_purpose_code = 120
docid = 100062022/412
court_name = 11599000000000
next_hear_date = 19/06/2025
new_case_purpose = 10107000000777
TRN_BOR_HEARINGrow = 1
Posting record
Param Type = n
trn_bor_hearingid=12889000010036
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:36
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
puname=Surendrasingh
Param Type = n
trn_bor_caseid=10956000005859
Param Type = c
prev_purpose_code=120
Param Type = c
case_no=2022/412
Param Type = c
bench_code=15
Param Type = n
new_purpose_group=19973000000612
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=120
Param Type = c
docid=100062022/412
Param Type = c
court_name=11599000000000
Param Type = c
next_hear_date=19/06/2025 00:00:00
Param Type = c
new_case_purpose=10107000000777
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,prev_hear_date,puname,manual_case_no,trn_bor_caseid,prev_purpose_code,case_no,bench_code,new_purpose_group,court_code,new_purpose_code,docid,court_name,next_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,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:puname,null,:trn_bor_caseid,:prev_purpose_code,:case_no,:bench_code,:new_purpose_group,:court_code,:new_purpose_code,:docid,:court_name,to_date(:next_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 = 13
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 = 5
RecordId = 12889000010037
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_hear_date = 13/06/2025
prev_purpose_code = 120
bench_code = 15
new_case_purpose = 10107000000777
next_hear_date = 08/08/2025
new_purpose_group = 19973000000612
new_purpose_code = 120
court_code = 10006
court_name = 11599000000000
puname = Surendrasingh
docid = 100062022/889
manual_case_no =
trn_bor_caseid = 11555000006614
case_no = 2022/889
TRN_BOR_HEARINGrow = 2
Posting record
Param Type = n
trn_bor_hearingid=12889000010037
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:36
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
prev_purpose_code=120
Param Type = c
bench_code=15
Param Type = c
new_case_purpose=10107000000777
Param Type = c
next_hear_date=08/08/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
court_name=11599000000000
Param Type = c
puname=Surendrasingh
Param Type = c
docid=100062022/889
Param Type = n
trn_bor_caseid=11555000006614
Param Type = c
case_no=2022/889
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,prev_hear_date,prev_purpose_code,bench_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_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,:bench_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,: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 = 6
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 = 4
RecordId = 12889000010038
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
prev_hear_date = 13/06/2025
prev_purpose_code = 122
bench_code = 15
next_hear_date = 08/08/2025
new_case_purpose = 10110000000719
new_purpose_code = 122
new_purpose_group = 19971000000602
court_code = 10006
court_name = 11599000000000
puname = Surendrasingh
docid = 100062022/1686
manual_case_no =
trn_bor_caseid = 10515000006069
case_no = 2022/1686
TRN_BOR_HEARINGrow = 3
Posting record
Param Type = n
trn_bor_hearingid=12889000010038
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:36
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
prev_purpose_code=122
Param Type = c
bench_code=15
Param Type = c
next_hear_date=08/08/2025 00:00:00
Param Type = c
new_case_purpose=10110000000719
Param Type = c
new_purpose_code=122
Param Type = n
new_purpose_group=19971000000602
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
puname=Surendrasingh
Param Type = c
docid=100062022/1686
Param Type = n
trn_bor_caseid=10515000006069
Param Type = c
case_no=2022/1686
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,prev_hear_date,prev_purpose_code,bench_code,next_hear_date,new_case_purpose,new_purpose_code,new_purpose_group,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,:bench_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:new_purpose_code,:new_purpose_group,: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 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 11
RecordId = 12889000010039
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
bench_code = 15
prev_purpose_code = 122
manual_case_no =
case_no = 2022/1687
trn_bor_caseid = 10584000007378
new_purpose_group = 19971000000602
next_hear_date = 08/08/2025
new_purpose_code = 122
prev_hear_date = 13/06/2025
new_case_purpose = 10110000000719
court_name = 11599000000000
puname = Surendrasingh
docid = 100062022/1687
court_code = 10006
TRN_BOR_HEARINGrow = 4
Posting record
Param Type = n
trn_bor_hearingid=12889000010039
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:36
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=122
Param Type = c
case_no=2022/1687
Param Type = n
trn_bor_caseid=10584000007378
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=08/08/2025 00:00:00
Param Type = c
new_purpose_code=122
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
new_case_purpose=10110000000719
Param Type = c
court_name=11599000000000
Param Type = c
puname=Surendrasingh
Param Type = c
docid=100062022/1687
Param Type = c
court_code=10006
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,bench_code,prev_purpose_code,manual_case_no,case_no,trn_bor_caseid,new_purpose_group,next_hear_date,new_purpose_code,prev_hear_date,new_case_purpose,court_name,puname,docid,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,:bench_code,:prev_purpose_code,null,:case_no,:trn_bor_caseid,: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,:court_name,:puname,:docid,:court_code,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 19
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 = 5
RecordId = 12889000010040
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 15
case_no = 2022/1744
trn_bor_caseid = 13575000007177
manual_case_no =
docid = 100062022/1744
puname = Surendrasingh
court_name = 11599000000000
court_code = 10006
new_purpose_group = 19971000000602
next_hear_date = 10/07/2025
bench_code = 15
new_purpose_code = 122
prev_purpose_code = 122
prev_hear_date = 13/06/2025
new_case_purpose = 10110000000719
TRN_BOR_HEARINGrow = 5
Posting record
Param Type = n
trn_bor_hearingid=12889000010040
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:36
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2022/1744
Param Type = n
trn_bor_caseid=13575000007177
Param Type = c
docid=100062022/1744
Param Type = c
puname=Surendrasingh
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=10/07/2025 00:00:00
Param Type = c
bench_code=15
Param Type = c
new_purpose_code=122
Param Type = c
prev_purpose_code=122
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
new_case_purpose=10110000000719
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_group,next_hear_date,bench_code,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,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,: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 = 4
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 = 12889000010041
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 12
case_no = 2022/1948
trn_bor_caseid = 15055000007385
manual_case_no =
docid = 100062022/1948
puname = Surendrasingh
court_name = 11599000000000
court_code = 10006
new_purpose_code = 112
new_purpose_group = 19971000000602
next_hear_date = 30/06/2025
new_case_purpose = 10035000000979
bench_code = 15
prev_purpose_code = 112
prev_hear_date = 13/06/2025
TRN_BOR_HEARINGrow = 6
Posting record
Param Type = n
trn_bor_hearingid=12889000010041
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:36
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2022/1948
Param Type = n
trn_bor_caseid=15055000007385
Param Type = c
docid=100062022/1948
Param Type = c
puname=Surendrasingh
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=30/06/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=13/06/2025 00:00:00
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,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 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12889000010042
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
manual_case_no =
bench_code = 15
trn_bor_caseid = 16434000008462
docid = 100062022/2145
case_no = 2022/2145
prev_purpose_code = 120
next_hear_date = 04/07/2025
new_purpose_group = 19973000000612
new_purpose_code = 120
prev_hear_date = 13/06/2025
new_case_purpose = 10107000000777
puname = Surendrasingh
court_code = 10006
court_name = 11599000000000
TRN_BOR_HEARINGrow = 7
Posting record
Param Type = n
trn_bor_hearingid=12889000010042
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:36
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
bench_code=15
Param Type = n
trn_bor_caseid=16434000008462
Param Type = c
docid=100062022/2145
Param Type = c
case_no=2022/2145
Param Type = c
prev_purpose_code=120
Param Type = c
next_hear_date=04/07/2025 00:00:00
Param Type = n
new_purpose_group=19973000000612
Param Type = c
new_purpose_code=120
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
new_case_purpose=10107000000777
Param Type = c
puname=Surendrasingh
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,manual_case_no,bench_code,trn_bor_caseid,docid,case_no,prev_purpose_code,next_hear_date,new_purpose_group,new_purpose_code,prev_hear_date,new_case_purpose,puname,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,null,:bench_code,:trn_bor_caseid,:docid,:case_no,:prev_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:puname,: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 = 8
RecordId = 12889000010043
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 26
trn_bor_caseid = 11173000005794
prev_purpose_code = 112
prev_hear_date = 13/06/2025
court_name = 11599000000000
manual_case_no =
bench_code = 15
puname = Surendrasingh
new_purpose_code = 112
new_purpose_group = 19971000000602
next_hear_date = 09/07/2025
case_no = 2022/2397
new_case_purpose = 10035000000979
docid = 100062022/2397
court_code = 10006
TRN_BOR_HEARINGrow = 8
Posting record
Param Type = n
trn_bor_hearingid=12889000010043
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:36
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
trn_bor_caseid=11173000005794
Param Type = c
prev_purpose_code=112
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
court_name=11599000000000
Param Type = c
bench_code=15
Param Type = c
puname=Surendrasingh
Param Type = c
new_purpose_code=112
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=09/07/2025 00:00:00
Param Type = c
case_no=2022/2397
Param Type = c
new_case_purpose=10035000000979
Param Type = c
docid=100062022/2397
Param Type = c
court_code=10006
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,trn_bor_caseid,prev_purpose_code,prev_hear_date,court_name,manual_case_no,bench_code,puname,new_purpose_code,new_purpose_group,next_hear_date,case_no,new_case_purpose,docid,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,:trn_bor_caseid,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_name,null,:bench_code,:puname,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:new_case_purpose,:docid,:court_code,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 16
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 = 4
RecordId = 12889000010044
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
case_no = 2022/2442
trn_bor_caseid = 14763000005769
manual_case_no =
docid = 100062022/2442
puname = Surendrasingh
court_name = 11599000000000
court_code = 10006
new_purpose_code = 122
new_purpose_group = 19971000000602
next_hear_date = 10/10/2025
new_case_purpose = 10110000000719
bench_code = 15
prev_purpose_code = 122
prev_hear_date = 13/06/2025
TRN_BOR_HEARINGrow = 9
Posting record
Param Type = n
trn_bor_hearingid=12889000010044
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:36
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2022/2442
Param Type = n
trn_bor_caseid=14763000005769
Param Type = c
docid=100062022/2442
Param Type = c
puname=Surendrasingh
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=10/10/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=13/06/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 = 7
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 = 6
RecordId = 12889000010045
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 4
case_no = 2022/4177
trn_bor_caseid = 15898000006649
manual_case_no =
docid = 100062022/4177
puname = Surendrasingh
court_name = 11599000000000
court_code = 10006
new_purpose_code = 122
new_purpose_group = 19971000000602
next_hear_date = 10/10/2025
new_case_purpose = 10110000000719
bench_code = 15
prev_purpose_code = 122
prev_hear_date = 13/06/2025
TRN_BOR_HEARINGrow = 10
Posting record
Param Type = n
trn_bor_hearingid=12889000010045
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:36
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2022/4177
Param Type = n
trn_bor_caseid=15898000006649
Param Type = c
docid=100062022/4177
Param Type = c
puname=Surendrasingh
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=10/10/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=13/06/2025 00:00:00
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,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 = 6
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 = 22
RecordId = 12889000010046
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2022/4409
trn_bor_caseid = 15489000007106
manual_case_no =
court_name = 11599000000000
court_code = 10006
docid = 100062022/4409
bench_code = 15
new_purpose_code = 122
new_purpose_group = 19971000000602
next_hear_date = 10/10/2025
prev_purpose_code = 122
prev_hear_date = 13/06/2025
new_case_purpose = 10110000000719
puname = Surendrasingh
TRN_BOR_HEARINGrow = 11
Posting record
Param Type = n
trn_bor_hearingid=12889000010046
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:36
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2022/4409
Param Type = n
trn_bor_caseid=15489000007106
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
docid=100062022/4409
Param Type = c
bench_code=15
Param Type = c
new_purpose_code=122
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=10/10/2025 00:00:00
Param Type = c
prev_purpose_code=122
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
new_case_purpose=10110000000719
Param Type = c
puname=Surendrasingh
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,case_no,trn_bor_caseid,manual_case_no,court_name,court_code,docid,bench_code,new_purpose_code,new_purpose_group,next_hear_date,prev_purpose_code,prev_hear_date,new_case_purpose,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,:case_no,:trn_bor_caseid,null,:court_name,:court_code,:docid,:bench_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:puname,: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 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12889000010047
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 14
manual_case_no =
bench_code = 15
puname = Surendrasingh
trn_bor_caseid = 12411000007849
court_code = 10006
docid = 100062022/4453
case_no = 2022/4453
new_purpose_code = 122
new_purpose_group = 19971000000602
next_hear_date = 10/10/2025
new_case_purpose = 10110000000719
court_name = 11599000000000
prev_purpose_code = 122
prev_hear_date = 13/06/2025
TRN_BOR_HEARINGrow = 12
Posting record
Param Type = n
trn_bor_hearingid=12889000010047
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:36
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
bench_code=15
Param Type = c
puname=Surendrasingh
Param Type = n
trn_bor_caseid=12411000007849
Param Type = c
court_code=10006
Param Type = c
docid=100062022/4453
Param Type = c
case_no=2022/4453
Param Type = c
new_purpose_code=122
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=10/10/2025 00:00:00
Param Type = c
new_case_purpose=10110000000719
Param Type = c
court_name=11599000000000
Param Type = c
prev_purpose_code=122
Param Type = c
prev_hear_date=13/06/2025 00:00:00
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,manual_case_no,bench_code,puname,trn_bor_caseid,court_code,docid,case_no,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,court_name,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,null,:bench_code,:puname,:trn_bor_caseid,:court_code,:docid,:case_no,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:court_name,: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 = 6
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 = 4
RecordId = 12889000010048
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2022/4512
trn_bor_caseid = 10052000007205
manual_case_no =
docid = 100062022/4512
puname = Surendrasingh
court_name = 11599000000000
court_code = 10006
new_purpose_code = 122
new_purpose_group = 19971000000602
next_hear_date = 10/10/2025
new_case_purpose = 10110000000719
bench_code = 15
prev_purpose_code = 122
prev_hear_date = 13/06/2025
TRN_BOR_HEARINGrow = 13
Posting record
Param Type = n
trn_bor_hearingid=12889000010048
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2022/4512
Param Type = n
trn_bor_caseid=10052000007205
Param Type = c
docid=100062022/4512
Param Type = c
puname=Surendrasingh
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=10/10/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=13/06/2025 00:00:00
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,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 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12889000010049
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 10/10/2025
puname = Surendrasingh
new_purpose_group = 19971000000602
court_name = 11599000000000
prev_purpose_code = 122
prev_hear_date = 13/06/2025
bench_code = 15
court_code = 10006
trn_bor_caseid = 14883000006745
manual_case_no =
new_case_purpose = 10110000000719
docid = 100062022/4526
case_no = 2022/4526
new_purpose_code = 122
TRN_BOR_HEARINGrow = 14
Posting record
Param Type = n
trn_bor_hearingid=12889000010049
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
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 = c
puname=Surendrasingh
Param Type = n
new_purpose_group=19971000000602
Param Type = c
court_name=11599000000000
Param Type = c
prev_purpose_code=122
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
bench_code=15
Param Type = c
court_code=10006
Param Type = n
trn_bor_caseid=14883000006745
Param Type = c
new_case_purpose=10110000000719
Param Type = c
docid=100062022/4526
Param Type = c
case_no=2022/4526
Param Type = c
new_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,next_hear_date,puname,new_purpose_group,court_name,prev_purpose_code,prev_hear_date,bench_code,court_code,trn_bor_caseid,manual_case_no,new_case_purpose,docid,case_no,new_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'),:puname,:new_purpose_group,: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_case_purpose,:docid,:case_no,:new_purpose_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 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12889000010050
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 25/06/2025
docid = 100062022/4711
case_no = 2022/4711
trn_bor_caseid = 15625000007783
puname = Surendrasingh
court_name = 11599000000000
court_code = 10006
manual_case_no =
new_case_purpose = 10035000000979
new_purpose_code = 112
new_purpose_group = 19971000000602
bench_code = 15
prev_purpose_code = 112
prev_hear_date = 13/06/2025
TRN_BOR_HEARINGrow = 15
Posting record
Param Type = n
trn_bor_hearingid=12889000010050
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=25/06/2025 00:00:00
Param Type = c
docid=100062022/4711
Param Type = c
case_no=2022/4711
Param Type = n
trn_bor_caseid=15625000007783
Param Type = c
puname=Surendrasingh
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_case_purpose=10035000000979
Param Type = c
new_purpose_code=112
Param Type = n
new_purpose_group=19971000000602
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=112
Param Type = c
prev_hear_date=13/06/2025 00:00:00
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,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 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12889000010051
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 10/10/2025
new_purpose_group = 19971000000602
bench_code = 15
manual_case_no =
trn_bor_caseid = 17429000007682
prev_hear_date = 13/06/2025
prev_purpose_code = 122
new_case_purpose = 10110000000719
court_name = 11599000000000
puname = Surendrasingh
new_purpose_code = 122
case_no = 2022/4729
docid = 100062022/4729
court_code = 10006
TRN_BOR_HEARINGrow = 16
Posting record
Param Type = n
trn_bor_hearingid=12889000010051
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
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=19971000000602
Param Type = c
bench_code=15
Param Type = n
trn_bor_caseid=17429000007682
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
prev_purpose_code=122
Param Type = c
new_case_purpose=10110000000719
Param Type = c
court_name=11599000000000
Param Type = c
puname=Surendrasingh
Param Type = c
new_purpose_code=122
Param Type = c
case_no=2022/4729
Param Type = c
docid=100062022/4729
Param Type = c
court_code=10006
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,next_hear_date,new_purpose_group,bench_code,manual_case_no,trn_bor_caseid,prev_hear_date,prev_purpose_code,new_case_purpose,court_name,puname,new_purpose_code,case_no,docid,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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:bench_code,null,:trn_bor_caseid,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_case_purpose,:court_name,:puname,:new_purpose_code,:case_no,:docid,:court_code,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 6
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 = 4
RecordId = 12889000010052
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
new_purpose_group = 19968000000591
next_hear_date = 27/06/2025
docid = 100062022/5166
case_no = 2022/5166
trn_bor_caseid = 15968000007033
puname = Surendrasingh
court_name = 11599000000000
court_code = 10006
prev_hear_date = 13/06/2025
new_case_purpose = 10189000000601
new_purpose_code = 201
manual_case_no =
bench_code = 15
prev_purpose_code = 201
TRN_BOR_HEARINGrow = 17
Posting record
Param Type = n
trn_bor_hearingid=12889000010052
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
new_purpose_group=19968000000591
Param Type = c
next_hear_date=27/06/2025 00:00:00
Param Type = c
docid=100062022/5166
Param Type = c
case_no=2022/5166
Param Type = n
trn_bor_caseid=15968000007033
Param Type = c
puname=Surendrasingh
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
new_case_purpose=10189000000601
Param Type = c
new_purpose_code=201
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=201
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_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 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12889000010053
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
new_purpose_group = 19971000000602
next_hear_date = 10/10/2025
new_purpose_code = 122
court_code = 10006
docid = 100062022/5701
court_name = 11599000000000
prev_purpose_code = 122
puname = Surendrasingh
case_no = 2022/5701
prev_hear_date = 13/06/2025
new_case_purpose = 10110000000719
bench_code = 15
trn_bor_caseid = 10733000006893
manual_case_no =
TRN_BOR_HEARINGrow = 18
Posting record
Param Type = n
trn_bor_hearingid=12889000010053
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
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=10/10/2025 00:00:00
Param Type = c
new_purpose_code=122
Param Type = c
court_code=10006
Param Type = c
docid=100062022/5701
Param Type = c
court_name=11599000000000
Param Type = c
prev_purpose_code=122
Param Type = c
puname=Surendrasingh
Param Type = c
case_no=2022/5701
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
new_case_purpose=10110000000719
Param Type = c
bench_code=15
Param Type = n
trn_bor_caseid=10733000006893
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_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 = 4
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 = 2
RecordId = 12889000010054
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
new_purpose_code = 122
new_purpose_group = 19971000000602
next_hear_date = 10/10/2025
docid = 100062022/5733
case_no = 2022/5733
court_code = 10006
puname = Surendrasingh
court_name = 11599000000000
trn_bor_caseid = 12796000007095
prev_hear_date = 13/06/2025
new_case_purpose = 10110000000719
prev_purpose_code = 122
manual_case_no =
bench_code = 15
TRN_BOR_HEARINGrow = 19
Posting record
Param Type = n
trn_bor_hearingid=12889000010054
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
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=10/10/2025 00:00:00
Param Type = c
docid=100062022/5733
Param Type = c
case_no=2022/5733
Param Type = c
court_code=10006
Param Type = c
puname=Surendrasingh
Param Type = c
court_name=11599000000000
Param Type = n
trn_bor_caseid=12796000007095
Param Type = c
prev_hear_date=13/06/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=19
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 = 5
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 = 4
RecordId = 12889000010055
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
new_purpose_code = 122
new_purpose_group = 19971000000602
next_hear_date = 10/10/2025
new_case_purpose = 10110000000719
docid = 100062022/5918
case_no = 2022/5918
court_code = 10006
puname = Surendrasingh
court_name = 11599000000000
prev_purpose_code = 122
prev_hear_date = 13/06/2025
bench_code = 15
trn_bor_caseid = 14855000007264
manual_case_no =
TRN_BOR_HEARINGrow = 20
Posting record
Param Type = n
trn_bor_hearingid=12889000010055
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
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=10/10/2025 00:00:00
Param Type = c
new_case_purpose=10110000000719
Param Type = c
docid=100062022/5918
Param Type = c
case_no=2022/5918
Param Type = c
court_code=10006
Param Type = c
puname=Surendrasingh
Param Type = c
court_name=11599000000000
Param Type = c
prev_purpose_code=122
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
bench_code=15
Param Type = n
trn_bor_caseid=14855000007264
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_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 = 5
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 = 6
RecordId = 12889000010056
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
new_purpose_code = 120
new_case_purpose = 10107000000777
next_hear_date = 04/07/2025
new_purpose_group = 19973000000612
court_name = 11599000000000
puname = Surendrasingh
court_code = 10006
trn_bor_caseid = 10955000006703
docid = 100062022/6219
prev_purpose_code = 120
prev_hear_date = 13/06/2025
bench_code = 15
case_no = 2022/6219
manual_case_no =
TRN_BOR_HEARINGrow = 21
Posting record
Param Type = n
trn_bor_hearingid=12889000010056
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_purpose_code=120
Param Type = c
new_case_purpose=10107000000777
Param Type = c
next_hear_date=04/07/2025 00:00:00
Param Type = n
new_purpose_group=19973000000612
Param Type = c
court_name=11599000000000
Param Type = c
puname=Surendrasingh
Param Type = c
court_code=10006
Param Type = n
trn_bor_caseid=10955000006703
Param Type = c
docid=100062022/6219
Param Type = c
prev_purpose_code=120
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
bench_code=15
Param Type = c
case_no=2022/6219
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_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 = 4
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 = 3
RecordId = 12889000010057
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
new_case_purpose = 10107000000777
new_purpose_code = 120
next_hear_date = 04/07/2025
new_purpose_group = 19973000000612
prev_hear_date = 13/06/2025
court_code = 10006
docid = 100062022/6223
puname = Surendrasingh
court_name = 11599000000000
case_no = 2022/6223
bench_code = 15
prev_purpose_code = 120
trn_bor_caseid = 11112000007225
manual_case_no =
TRN_BOR_HEARINGrow = 22
Posting record
Param Type = n
trn_bor_hearingid=12889000010057
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
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=04/07/2025 00:00:00
Param Type = n
new_purpose_group=19973000000612
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
court_code=10006
Param Type = c
docid=100062022/6223
Param Type = c
puname=Surendrasingh
Param Type = c
court_name=11599000000000
Param Type = c
case_no=2022/6223
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=120
Param Type = n
trn_bor_caseid=11112000007225
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,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 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12889000010058
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 7
new_case_purpose = 10189000000601
prev_hear_date = 13/06/2025
next_hear_date = 17/06/2025
new_purpose_group = 19968000000591
new_purpose_code = 201
court_code = 10006
docid = 100062022/6274
puname = Surendrasingh
court_name = 11599000000000
case_no = 2022/6274
bench_code = 15
prev_purpose_code = 201
trn_bor_caseid = 19460000007151
manual_case_no =
TRN_BOR_HEARINGrow = 23
Posting record
Param Type = n
trn_bor_hearingid=12889000010058
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=10189000000601
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
next_hear_date=17/06/2025 00:00:00
Param Type = n
new_purpose_group=19968000000591
Param Type = c
new_purpose_code=201
Param Type = c
court_code=10006
Param Type = c
docid=100062022/6274
Param Type = c
puname=Surendrasingh
Param Type = c
court_name=11599000000000
Param Type = c
case_no=2022/6274
Param Type = c
bench_code=15
Param Type = c
prev_purpose_code=201
Param Type = n
trn_bor_caseid=19460000007151
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,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 = 12
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 = 11
RecordId = 12889000010059
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
new_case_purpose = 10110000000719
prev_hear_date = 13/06/2025
next_hear_date = 10/10/2025
new_purpose_group = 19971000000602
new_purpose_code = 122
prev_purpose_code = 122
court_code = 10006
docid = 100062022/6470
court_name = 11599000000000
puname = Surendrasingh
manual_case_no =
trn_bor_caseid = 13359000006266
case_no = 2022/6470
bench_code = 15
TRN_BOR_HEARINGrow = 24
Posting record
Param Type = n
trn_bor_hearingid=12889000010059
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
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=13/06/2025 00:00:00
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=122
Param Type = c
prev_purpose_code=122
Param Type = c
court_code=10006
Param Type = c
docid=100062022/6470
Param Type = c
court_name=11599000000000
Param Type = c
puname=Surendrasingh
Param Type = n
trn_bor_caseid=13359000006266
Param Type = c
case_no=2022/6470
Param Type = c
bench_code=15
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,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 = 26
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 12889000010060
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 18
Select sysdate as sdt from dual
Time elapsed = 8
prev_hear_date = 13/06/2025
prev_purpose_code = 122
new_case_purpose = 10110000000719
next_hear_date = 10/10/2025
new_purpose_group = 19971000000602
new_purpose_code = 122
court_code = 10006
docid = 100062022/7161
puname = Surendrasingh
court_name = 11599000000000
manual_case_no =
bench_code = 15
case_no = 2022/7161
trn_bor_caseid = 18817000006470
TRN_BOR_HEARINGrow = 25
Posting record
Param Type = n
trn_bor_hearingid=12889000010060
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
prev_purpose_code=122
Param Type = c
new_case_purpose=10110000000719
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=122
Param Type = c
court_code=10006
Param Type = c
docid=100062022/7161
Param Type = c
puname=Surendrasingh
Param Type = c
court_name=11599000000000
Param Type = c
bench_code=15
Param Type = c
case_no=2022/7161
Param Type = n
trn_bor_caseid=18817000006470
Param Type = n
trn_bor_hearingrow=25
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 = 16
Adding new record to store data from Frame 2, Row 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12889000010061
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 5
prev_hear_date = 13/06/2025
prev_purpose_code = 112
new_case_purpose = 10035000000979
next_hear_date = 10/10/2025
new_purpose_group = 19971000000602
new_purpose_code = 112
court_code = 10006
docid = 100062022/7339
puname = Surendrasingh
court_name = 11599000000000
manual_case_no =
bench_code = 15
case_no = 2022/7339
trn_bor_caseid = 11827000007404
TRN_BOR_HEARINGrow = 26
Posting record
Param Type = n
trn_bor_hearingid=12889000010061
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
prev_purpose_code=112
Param Type = c
new_case_purpose=10035000000979
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=112
Param Type = c
court_code=10006
Param Type = c
docid=100062022/7339
Param Type = c
puname=Surendrasingh
Param Type = c
court_name=11599000000000
Param Type = c
bench_code=15
Param Type = c
case_no=2022/7339
Param Type = n
trn_bor_caseid=11827000007404
Param Type = n
trn_bor_hearingrow=26
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 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12889000010062
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
prev_hear_date = 13/06/2025
prev_purpose_code = 112
new_case_purpose = 10035000000979
next_hear_date = 10/10/2025
new_purpose_group = 19971000000602
new_purpose_code = 112
bench_code = 15
court_code = 10006
court_name = 11599000000000
puname = Surendrasingh
docid = 100062022/7341
manual_case_no =
trn_bor_caseid = 11882000008788
case_no = 2022/7341
TRN_BOR_HEARINGrow = 27
Posting record
Param Type = n
trn_bor_hearingid=12889000010062
Param Type = n
trn_bor_mhearingid=12889000010035
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=13/06/2025 00:00:00
Param Type = c
prev_purpose_code=112
Param Type = c
new_case_purpose=10035000000979
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=112
Param Type = c
bench_code=15
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
puname=Surendrasingh
Param Type = c
docid=100062022/7341
Param Type = n
trn_bor_caseid=11882000008788
Param Type = c
case_no=2022/7341
Param Type = n
trn_bor_hearingrow=27
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 = 3959239043077
>>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 = 2022/412 idvalue 0
Mapped hearing_date Row = 1 value = 19/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 10956000005859 idvalue 0
Mapped case_docid Row = 1 value = 100062022/412 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 10956000005859
case_docid = 100062022/412
case_no = 2022/412
prev_hearing_date = 13/06/2025
hearing_date = 19/06/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 = 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 = 12889000010063
MapName bocup1
SourceId 12889000010036
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 = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 19/06/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2022/412
case_docid = 100062022/412
case_purpose = 10107000000777
trn_bor_caseregid = 10956000005859
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010063
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010036
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
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=16/06/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=19/06/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/412
Param Type = c
case_docid=100062022/412
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=10956000005859
Param Type = c
prev_hearing_date=13/06/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 = 2022/889 idvalue 0
Mapped hearing_date Row = 1 value = 08/08/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 11555000006614 idvalue 0
Mapped case_docid Row = 1 value = 100062022/889 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 11555000006614
case_docid = 100062022/889
case_no = 2022/889
prev_hearing_date = 13/06/2025
hearing_date = 08/08/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 = 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 = 4
RecordId = 12889000010064
MapName bocup1
SourceId 12889000010037
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 7
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 08/08/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2022/889
case_docid = 100062022/889
case_purpose = 10107000000777
trn_bor_caseregid = 11555000006614
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010064
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010037
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:37
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:37
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=16/06/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/08/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/889
Param Type = c
case_docid=100062022/889
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=11555000006614
Param Type = c
prev_hearing_date=13/06/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 = 2022/1686 idvalue 0
Mapped hearing_date Row = 1 value = 08/08/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 10515000006069 idvalue 0
Mapped case_docid Row = 1 value = 100062022/1686 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 10515000006069
case_docid = 100062022/1686
case_no = 2022/1686
prev_hearing_date = 13/06/2025
hearing_date = 08/08/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 = 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 = 5
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 = 12889000010065
MapName bocup1
SourceId 12889000010038
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 08/08/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/1686
case_docid = 100062022/1686
case_purpose = 10110000000719
trn_bor_caseregid = 10515000006069
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010065
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010038
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:38
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:38
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=16/06/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=08/08/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/1686
Param Type = c
case_docid=100062022/1686
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=10515000006069
Param Type = c
prev_hearing_date=13/06/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 = 2022/1687 idvalue 0
Mapped hearing_date Row = 1 value = 08/08/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 10584000007378 idvalue 0
Mapped case_docid Row = 1 value = 100062022/1687 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 10584000007378
case_docid = 100062022/1687
case_no = 2022/1687
prev_hearing_date = 13/06/2025
hearing_date = 08/08/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 = 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 = 5
RecordId = 12889000010066
MapName bocup1
SourceId 12889000010039
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 20
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 08/08/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/1687
case_docid = 100062022/1687
case_purpose = 10110000000719
trn_bor_caseregid = 10584000007378
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010066
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010039
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:38
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:38
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=16/06/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=08/08/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/1687
Param Type = c
case_docid=100062022/1687
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=10584000007378
Param Type = c
prev_hearing_date=13/06/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 = 2022/1744 idvalue 0
Mapped hearing_date Row = 1 value = 10/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 13575000007177 idvalue 0
Mapped case_docid Row = 1 value = 100062022/1744 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 13575000007177
case_docid = 100062022/1744
case_no = 2022/1744
prev_hearing_date = 13/06/2025
hearing_date = 10/07/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 = 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 = 12889000010067
MapName bocup1
SourceId 12889000010040
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 10/07/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/1744
case_docid = 100062022/1744
case_purpose = 10110000000719
trn_bor_caseregid = 13575000007177
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010067
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010040
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:38
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:38
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=16/06/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=10/07/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/1744
Param Type = c
case_docid=100062022/1744
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=13575000007177
Param Type = c
prev_hearing_date=13/06/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 = 2022/1948 idvalue 0
Mapped hearing_date Row = 1 value = 30/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 15055000007385 idvalue 0
Mapped case_docid Row = 1 value = 100062022/1948 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 15055000007385
case_docid = 100062022/1948
case_no = 2022/1948
prev_hearing_date = 13/06/2025
hearing_date = 30/06/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 = 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 = 12889000010068
MapName bocup1
SourceId 12889000010041
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
prev_case_purpose = 10035000000979
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 112
hearing_date = 30/06/2025
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2022/1948
case_docid = 100062022/1948
case_purpose = 10035000000979
trn_bor_caseregid = 15055000007385
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010068
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010041
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:38
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:38
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=16/06/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=30/06/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/1948
Param Type = c
case_docid=100062022/1948
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=15055000007385
Param Type = c
prev_hearing_date=13/06/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 = 2022/2145 idvalue 0
Mapped hearing_date Row = 1 value = 04/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 16434000008462 idvalue 0
Mapped case_docid Row = 1 value = 100062022/2145 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 16434000008462
case_docid = 100062022/2145
case_no = 2022/2145
prev_hearing_date = 13/06/2025
hearing_date = 04/07/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 = 9
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 = 3
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 = 12889000010069
MapName bocup1
SourceId 12889000010042
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 04/07/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2022/2145
case_docid = 100062022/2145
case_purpose = 10107000000777
trn_bor_caseregid = 16434000008462
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010069
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010042
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:38
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:38
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=16/06/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=04/07/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/2145
Param Type = c
case_docid=100062022/2145
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=16434000008462
Param Type = c
prev_hearing_date=13/06/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 = 2022/2397 idvalue 0
Mapped hearing_date Row = 1 value = 09/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 11173000005794 idvalue 0
Mapped case_docid Row = 1 value = 100062022/2397 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 11173000005794
case_docid = 100062022/2397
case_no = 2022/2397
prev_hearing_date = 13/06/2025
hearing_date = 09/07/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 = 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 = 10
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 = 12889000010070
MapName bocup1
SourceId 12889000010043
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 10
prev_case_purpose = 10035000000979
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 112
hearing_date = 09/07/2025
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2022/2397
case_docid = 100062022/2397
case_purpose = 10035000000979
trn_bor_caseregid = 11173000005794
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010070
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010043
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:38
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:38
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=16/06/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=09/07/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/2397
Param Type = c
case_docid=100062022/2397
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=11173000005794
Param Type = c
prev_hearing_date=13/06/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 = 2022/2442 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 = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 14763000005769 idvalue 0
Mapped case_docid Row = 1 value = 100062022/2442 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 14763000005769
case_docid = 100062022/2442
case_no = 2022/2442
prev_hearing_date = 13/06/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 = 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 = 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 = 12889000010071
MapName bocup1
SourceId 12889000010044
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 = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 10/10/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/2442
case_docid = 100062022/2442
case_purpose = 10110000000719
trn_bor_caseregid = 14763000005769
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010071
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010044
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:38
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:38
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=16/06/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=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/2442
Param Type = c
case_docid=100062022/2442
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=14763000005769
Param Type = c
prev_hearing_date=13/06/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 = 2022/4177 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 = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 15898000006649 idvalue 0
Mapped case_docid Row = 1 value = 100062022/4177 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 15898000006649
case_docid = 100062022/4177
case_no = 2022/4177
prev_hearing_date = 13/06/2025
hearing_date = 10/10/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 = 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 = 5
RecordId = 12889000010072
MapName bocup1
SourceId 12889000010045
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 2
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 10/10/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/4177
case_docid = 100062022/4177
case_purpose = 10110000000719
trn_bor_caseregid = 15898000006649
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010072
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010045
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:38
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:38
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=16/06/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=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/4177
Param Type = c
case_docid=100062022/4177
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=15898000006649
Param Type = c
prev_hearing_date=13/06/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 = 2022/4409 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 = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 15489000007106 idvalue 0
Mapped case_docid Row = 1 value = 100062022/4409 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 15489000007106
case_docid = 100062022/4409
case_no = 2022/4409
prev_hearing_date = 13/06/2025
hearing_date = 10/10/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 = 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 = 12889000010073
MapName bocup1
SourceId 12889000010046
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 16
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 10/10/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/4409
case_docid = 100062022/4409
case_purpose = 10110000000719
trn_bor_caseregid = 15489000007106
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010073
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010046
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:38
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:38
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=16/06/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=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/4409
Param Type = c
case_docid=100062022/4409
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=15489000007106
Param Type = c
prev_hearing_date=13/06/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 = 2022/4453 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 = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 12411000007849 idvalue 0
Mapped case_docid Row = 1 value = 100062022/4453 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 12411000007849
case_docid = 100062022/4453
case_no = 2022/4453
prev_hearing_date = 13/06/2025
hearing_date = 10/10/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 = 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 = 12889000010074
MapName bocup1
SourceId 12889000010047
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 10/10/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/4453
case_docid = 100062022/4453
case_purpose = 10110000000719
trn_bor_caseregid = 12411000007849
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010074
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010047
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:38
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:38
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=16/06/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=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/4453
Param Type = c
case_docid=100062022/4453
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=12411000007849
Param Type = c
prev_hearing_date=13/06/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 = 2022/4512 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 = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 10052000007205 idvalue 0
Mapped case_docid Row = 1 value = 100062022/4512 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 10052000007205
case_docid = 100062022/4512
case_no = 2022/4512
prev_hearing_date = 13/06/2025
hearing_date = 10/10/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 = 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 = 4
RecordId = 12889000010075
MapName bocup1
SourceId 12889000010048
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 10/10/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/4512
case_docid = 100062022/4512
case_purpose = 10110000000719
trn_bor_caseregid = 10052000007205
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010075
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010048
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:38
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:38
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=16/06/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=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/4512
Param Type = c
case_docid=100062022/4512
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=10052000007205
Param Type = c
prev_hearing_date=13/06/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 = 2022/4526 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 = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 14883000006745 idvalue 0
Mapped case_docid Row = 1 value = 100062022/4526 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 14883000006745
case_docid = 100062022/4526
case_no = 2022/4526
prev_hearing_date = 13/06/2025
hearing_date = 10/10/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 = 4
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 10
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 = 12889000010076
MapName bocup1
SourceId 12889000010049
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 11
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 10/10/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/4526
case_docid = 100062022/4526
case_purpose = 10110000000719
trn_bor_caseregid = 14883000006745
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010076
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010049
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:38
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:38
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=16/06/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=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/4526
Param Type = c
case_docid=100062022/4526
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=14883000006745
Param Type = c
prev_hearing_date=13/06/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 = 2022/4711 idvalue 0
Mapped hearing_date Row = 1 value = 25/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 15625000007783 idvalue 0
Mapped case_docid Row = 1 value = 100062022/4711 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 15625000007783
case_docid = 100062022/4711
case_no = 2022/4711
prev_hearing_date = 13/06/2025
hearing_date = 25/06/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 = 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 = 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 = 3
RecordId = 12889000010077
MapName bocup1
SourceId 12889000010050
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10035000000979
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 112
hearing_date = 25/06/2025
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2022/4711
case_docid = 100062022/4711
case_purpose = 10035000000979
trn_bor_caseregid = 15625000007783
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010077
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010050
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:39
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:39
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=16/06/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=25/06/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/4711
Param Type = c
case_docid=100062022/4711
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=15625000007783
Param Type = c
prev_hearing_date=13/06/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 = 2022/4729 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 = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 17429000007682 idvalue 0
Mapped case_docid Row = 1 value = 100062022/4729 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 17429000007682
case_docid = 100062022/4729
case_no = 2022/4729
prev_hearing_date = 13/06/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 = 3
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 = 6
RecordId = 12889000010078
MapName bocup1
SourceId 12889000010051
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 26
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 10/10/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/4729
case_docid = 100062022/4729
case_purpose = 10110000000719
trn_bor_caseregid = 17429000007682
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010078
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010051
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:39
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:39
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=16/06/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=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/4729
Param Type = c
case_docid=100062022/4729
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=17429000007682
Param Type = c
prev_hearing_date=13/06/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 = 2022/5166 idvalue 0
Mapped hearing_date Row = 1 value = 27/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???. idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 15968000007033 idvalue 0
Mapped case_docid Row = 1 value = 100062022/5166 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 15968000007033
case_docid = 100062022/5166
case_no = 2022/5166
prev_hearing_date = 13/06/2025
hearing_date = 27/06/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 = 14
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 = 11
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 = 9
RecordId = 12889000010079
MapName bocup1
SourceId 12889000010052
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10189000000601
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 201
hearing_date = 27/06/2025
prev_case_purposename = ???.
court_code = 10006
case_no = 2022/5166
case_docid = 100062022/5166
case_purpose = 10189000000601
trn_bor_caseregid = 15968000007033
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010079
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010052
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:39
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:39
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=16/06/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=27/06/2025 00:00:00
Param Type = c
prev_case_purposename=???.
Param Type = c
court_code=10006
Param Type = c
case_no=2022/5166
Param Type = c
case_docid=100062022/5166
Param Type = c
case_purpose=10189000000601
Param Type = n
trn_bor_caseregid=15968000007033
Param Type = c
prev_hearing_date=13/06/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 = 2022/5701 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 = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 10733000006893 idvalue 0
Mapped case_docid Row = 1 value = 100062022/5701 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 10733000006893
case_docid = 100062022/5701
case_no = 2022/5701
prev_hearing_date = 13/06/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 = 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 = 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 = 7
RecordId = 12889000010080
MapName bocup1
SourceId 12889000010053
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 = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 10/10/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/5701
case_docid = 100062022/5701
case_purpose = 10110000000719
trn_bor_caseregid = 10733000006893
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010080
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010053
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:39
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:39
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=16/06/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=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/5701
Param Type = c
case_docid=100062022/5701
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=10733000006893
Param Type = c
prev_hearing_date=13/06/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 = 2022/5733 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 = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 12796000007095 idvalue 0
Mapped case_docid Row = 1 value = 100062022/5733 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 12796000007095
case_docid = 100062022/5733
case_no = 2022/5733
prev_hearing_date = 13/06/2025
hearing_date = 10/10/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 = 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 = 12889000010081
MapName bocup1
SourceId 12889000010054
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 10/10/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/5733
case_docid = 100062022/5733
case_purpose = 10110000000719
trn_bor_caseregid = 12796000007095
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010081
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010054
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:39
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:39
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=16/06/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=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/5733
Param Type = c
case_docid=100062022/5733
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=12796000007095
Param Type = c
prev_hearing_date=13/06/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 = 2022/5918 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 = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 14855000007264 idvalue 0
Mapped case_docid Row = 1 value = 100062022/5918 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 14855000007264
case_docid = 100062022/5918
case_no = 2022/5918
prev_hearing_date = 13/06/2025
hearing_date = 10/10/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 = 7
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 8
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 = 12889000010082
MapName bocup1
SourceId 12889000010055
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 10/10/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/5918
case_docid = 100062022/5918
case_purpose = 10110000000719
trn_bor_caseregid = 14855000007264
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010082
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010055
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:39
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:39
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=16/06/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=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/5918
Param Type = c
case_docid=100062022/5918
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=14855000007264
Param Type = c
prev_hearing_date=13/06/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 = 2022/6219 idvalue 0
Mapped hearing_date Row = 1 value = 04/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 10955000006703 idvalue 0
Mapped case_docid Row = 1 value = 100062022/6219 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 10955000006703
case_docid = 100062022/6219
case_no = 2022/6219
prev_hearing_date = 13/06/2025
hearing_date = 04/07/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 = 33
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 = 3
RecordId = 12889000010083
MapName bocup1
SourceId 12889000010056
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 29
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 04/07/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2022/6219
case_docid = 100062022/6219
case_purpose = 10107000000777
trn_bor_caseregid = 10955000006703
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010083
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010056
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:39
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:39
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=16/06/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=04/07/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/6219
Param Type = c
case_docid=100062022/6219
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=10955000006703
Param Type = c
prev_hearing_date=13/06/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 = 2022/6223 idvalue 0
Mapped hearing_date Row = 1 value = 04/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 11112000007225 idvalue 0
Mapped case_docid Row = 1 value = 100062022/6223 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 11112000007225
case_docid = 100062022/6223
case_no = 2022/6223
prev_hearing_date = 13/06/2025
hearing_date = 04/07/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 = 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 = 21
RecordId = 12889000010084
MapName bocup1
SourceId 12889000010057
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 04/07/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2022/6223
case_docid = 100062022/6223
case_purpose = 10107000000777
trn_bor_caseregid = 11112000007225
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010084
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010057
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:39
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:39
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=16/06/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=04/07/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/6223
Param Type = c
case_docid=100062022/6223
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=11112000007225
Param Type = c
prev_hearing_date=13/06/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 = 2022/6274 idvalue 0
Mapped hearing_date Row = 1 value = 17/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???. idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 19460000007151 idvalue 0
Mapped case_docid Row = 1 value = 100062022/6274 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 19460000007151
case_docid = 100062022/6274
case_no = 2022/6274
prev_hearing_date = 13/06/2025
hearing_date = 17/06/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 = 49
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 = 5
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 = 14
RecordId = 12889000010085
MapName bocup1
SourceId 12889000010058
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 13
prev_case_purpose = 10189000000601
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 201
hearing_date = 17/06/2025
prev_case_purposename = ???.
court_code = 10006
case_no = 2022/6274
case_docid = 100062022/6274
case_purpose = 10189000000601
trn_bor_caseregid = 19460000007151
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010085
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010058
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:39
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:39
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=16/06/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=17/06/2025 00:00:00
Param Type = c
prev_case_purposename=???.
Param Type = c
court_code=10006
Param Type = c
case_no=2022/6274
Param Type = c
case_docid=100062022/6274
Param Type = c
case_purpose=10189000000601
Param Type = n
trn_bor_caseregid=19460000007151
Param Type = c
prev_hearing_date=13/06/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 = 2022/6470 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 = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 13359000006266 idvalue 0
Mapped case_docid Row = 1 value = 100062022/6470 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 13359000006266
case_docid = 100062022/6470
case_no = 2022/6470
prev_hearing_date = 13/06/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 = 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 = 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 = 9
RecordId = 12889000010086
MapName bocup1
SourceId 12889000010059
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
prev_case_purpose = 10110000000719
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 10/10/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/6470
case_docid = 100062022/6470
case_purpose = 10110000000719
trn_bor_caseregid = 13359000006266
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010086
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010059
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:39
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:39
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=16/06/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=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/6470
Param Type = c
case_docid=100062022/6470
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=13359000006266
Param Type = c
prev_hearing_date=13/06/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 25
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2022/7161 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 = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 18817000006470 idvalue 0
Mapped case_docid Row = 1 value = 100062022/7161 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 18817000006470
case_docid = 100062022/7161
case_no = 2022/7161
prev_hearing_date = 13/06/2025
hearing_date = 10/10/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 = 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 = 3
RecordId = 12889000010087
MapName bocup1
SourceId 12889000010060
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 = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 10/10/2025
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/7161
case_docid = 100062022/7161
case_purpose = 10110000000719
trn_bor_caseregid = 18817000006470
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010087
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010060
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:40
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38:40
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=16/06/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=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/7161
Param Type = c
case_docid=100062022/7161
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=18817000006470
Param Type = c
prev_hearing_date=13/06/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 26
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2022/7339 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 = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 11827000007404 idvalue 0
Mapped case_docid Row = 1 value = 100062022/7339 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 11827000007404
case_docid = 100062022/7339
case_no = 2022/7339
prev_hearing_date = 13/06/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 = 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 = 12
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 = 12889000010088
MapName bocup1
SourceId 12889000010061
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10035000000979
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 112
hearing_date = 10/10/2025
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2022/7339
case_docid = 100062022/7339
case_purpose = 10035000000979
trn_bor_caseregid = 11827000007404
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010088
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010061
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:40
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38: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=16/06/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=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/7339
Param Type = c
case_docid=100062022/7339
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=11827000007404
Param Type = c
prev_hearing_date=13/06/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 27
>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2022/7341 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 = 13/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 11882000008788 idvalue 0
Mapped case_docid Row = 1 value = 100062022/7341 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 = 16/06/2025
doc_date after validation = 16/06/2025
court_code = 10006
trn_bor_caseregid = 11882000008788
case_docid = 100062022/7341
case_no = 2022/7341
prev_hearing_date = 13/06/2025
hearing_date = 10/10/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 = 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 = 12889000010089
MapName bocup1
SourceId 12889000010062
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 9
prev_case_purpose = 10035000000979
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 16/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 112
hearing_date = 10/10/2025
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2022/7341
case_docid = 100062022/7341
case_purpose = 10035000000979
trn_bor_caseregid = 11882000008788
prev_hearing_date = 13/06/2025
Posting record
Param Type = n
trn_bor_case_histid=12889000010089
Param Type = c
mapname=bocup1
Param Type = n
sourceid=12889000010062
Param Type = c
cancel=F
Param Type = c
createdby=surendrasingh
Param Type = c
createdon=16/06/2025 12:38:40
Param Type = c
username=surendrasingh
Param Type = c
modifiedon=16/06/2025 12:38: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=16/06/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=10/10/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/7341
Param Type = c
case_docid=100062022/7341
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=11882000008788
Param Type = c
prev_hearing_date=13/06/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 = 3959239045451
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=10956000005859
@trn_bor_caseregid=10956000005859
*hearingdate=19/06/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10956000005859 for update
Time elapsed = 87
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10956000005859
Time elapsed = 43
Param Type = c
hearingdate=19/06/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=10956000005859
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=11555000006614
@trn_bor_caseregid=11555000006614
*hearingdate=08/08/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=11555000006614 for update
Time elapsed = 41
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=11555000006614
Time elapsed = 50
Param Type = c
hearingdate=08/08/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=11555000006614
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=10515000006069
@trn_bor_caseregid=10515000006069
*hearingdate=08/08/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10515000006069 for update
Time elapsed = 46
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10515000006069
Time elapsed = 46
Param Type = c
hearingdate=08/08/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=10515000006069
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=10584000007378
@trn_bor_caseregid=10584000007378
*hearingdate=08/08/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10584000007378 for update
Time elapsed = 54
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10584000007378
Time elapsed = 57
Param Type = c
hearingdate=08/08/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=10584000007378
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=13575000007177
@trn_bor_caseregid=13575000007177
*hearingdate=10/07/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13575000007177 for update
Time elapsed = 72
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13575000007177
Time elapsed = 59
Param Type = c
hearingdate=10/07/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=13575000007177
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=15055000007385
@trn_bor_caseregid=15055000007385
*hearingdate=30/06/2025
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15055000007385 for update
Time elapsed = 45
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15055000007385
Time elapsed = 42
Param Type = c
hearingdate=30/06/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=15055000007385
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=16434000008462
@trn_bor_caseregid=16434000008462
*hearingdate=04/07/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16434000008462 for update
Time elapsed = 54
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16434000008462
Time elapsed = 39
Param Type = c
hearingdate=04/07/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=16434000008462
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=11173000005794
@trn_bor_caseregid=11173000005794
*hearingdate=09/07/2025
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=11173000005794 for update
Time elapsed = 52
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=11173000005794
Time elapsed = 44
Param Type = c
hearingdate=09/07/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=11173000005794
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=14763000005769
@trn_bor_caseregid=14763000005769
*hearingdate=10/10/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14763000005769 for update
Time elapsed = 43
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14763000005769
Time elapsed = 42
Param Type = c
hearingdate=10/10/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=14763000005769
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=15898000006649
@trn_bor_caseregid=15898000006649
*hearingdate=10/10/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15898000006649 for update
Time elapsed = 50
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15898000006649
Time elapsed = 44
Param Type = c
hearingdate=10/10/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=15898000006649
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=15489000007106
@trn_bor_caseregid=15489000007106
*hearingdate=10/10/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15489000007106 for update
Time elapsed = 45
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15489000007106
Time elapsed = 42
Param Type = c
hearingdate=10/10/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=15489000007106
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=12411000007849
@trn_bor_caseregid=12411000007849
*hearingdate=10/10/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=12411000007849 for update
Time elapsed = 84
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=12411000007849
Time elapsed = 50
Param Type = c
hearingdate=10/10/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=12411000007849
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=10052000007205
@trn_bor_caseregid=10052000007205
*hearingdate=10/10/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10052000007205 for update
Time elapsed = 50
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10052000007205
Time elapsed = 47
Param Type = c
hearingdate=10/10/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=10052000007205
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=14883000006745
@trn_bor_caseregid=14883000006745
*hearingdate=10/10/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14883000006745 for update
Time elapsed = 47
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14883000006745
Time elapsed = 51
Param Type = c
hearingdate=10/10/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=14883000006745
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=15625000007783
@trn_bor_caseregid=15625000007783
*hearingdate=25/06/2025
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15625000007783 for update
Time elapsed = 54
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15625000007783
Time elapsed = 39
Param Type = c
hearingdate=25/06/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=15625000007783
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=17429000007682
@trn_bor_caseregid=17429000007682
*hearingdate=10/10/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17429000007682 for update
Time elapsed = 51
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17429000007682
Time elapsed = 90
Param Type = c
hearingdate=10/10/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=17429000007682
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=15968000007033
@trn_bor_caseregid=15968000007033
*hearingdate=27/06/2025
*case_purpose_name=10189000000601
*case_purpose_code=201
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15968000007033 for update
Time elapsed = 48
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15968000007033
Time elapsed = 39
Param Type = c
hearingdate=27/06/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=15968000007033
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=10733000006893
@trn_bor_caseregid=10733000006893
*hearingdate=10/10/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10733000006893 for update
Time elapsed = 43
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10733000006893
Time elapsed = 36
Param Type = c
hearingdate=10/10/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=10733000006893
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=12796000007095
@trn_bor_caseregid=12796000007095
*hearingdate=10/10/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=12796000007095 for update
Time elapsed = 39
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=12796000007095
Time elapsed = 41
Param Type = c
hearingdate=10/10/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=12796000007095
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=14855000007264
@trn_bor_caseregid=14855000007264
*hearingdate=10/10/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14855000007264 for update
Time elapsed = 43
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14855000007264
Time elapsed = 52
Param Type = c
hearingdate=10/10/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=14855000007264
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=10955000006703
@trn_bor_caseregid=10955000006703
*hearingdate=04/07/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10955000006703 for update
Time elapsed = 55
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10955000006703
Time elapsed = 41
Param Type = c
hearingdate=04/07/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=10955000006703
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=11112000007225
@trn_bor_caseregid=11112000007225
*hearingdate=04/07/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=11112000007225 for update
Time elapsed = 48
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=11112000007225
Time elapsed = 38
Param Type = c
hearingdate=04/07/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=11112000007225
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=19460000007151
@trn_bor_caseregid=19460000007151
*hearingdate=17/06/2025
*case_purpose_name=10189000000601
*case_purpose_code=201
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19460000007151 for update
Time elapsed = 44
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19460000007151
Time elapsed = 44
Param Type = c
hearingdate=17/06/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=19460000007151
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=13359000006266
@trn_bor_caseregid=13359000006266
*hearingdate=10/10/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13359000006266 for update
Time elapsed = 42
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13359000006266
Time elapsed = 39
Param Type = c
hearingdate=10/10/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=13359000006266
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=18817000006470
@trn_bor_caseregid=18817000006470
*hearingdate=10/10/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18817000006470 for update
Time elapsed = 43
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18817000006470
Time elapsed = 47
Param Type = c
hearingdate=10/10/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=18817000006470
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=11827000007404
@trn_bor_caseregid=11827000007404
*hearingdate=10/10/2025
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=11827000007404 for update
Time elapsed = 50
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=11827000007404
Time elapsed = 40
Param Type = c
hearingdate=10/10/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=11827000007404
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=11882000008788
@trn_bor_caseregid=11882000008788
*hearingdate=10/10/2025
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=11882000008788 for update
Time elapsed = 50
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=11882000008788
Time elapsed = 49
Param Type = c
hearingdate=10/10/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=11882000008788
Time elapsed for MD Map = 3959239049202
Time elapsed for Save History = 3959239049203
Time elapsed for Save Attachment = 3959239049203
Time elapsed for After Save WF Exec = 3959239049206
Transaction commited
Result : {"message":[{"msg":"Cause List Feedback Saved","recordid":"12889000010035"}]}
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=surendrasingh
Param Type = c
calledon=16/06/2025 12:37:20
Param Type = c
callfinished=16/06/2025 12:37:29
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=8487
Param Type = n
dbtimetaken=6953
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