ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
gcmsPOOJAMEENA827ccb0eea8a706c4c34a16891f84e7b![]()
INRF500250000Ffiresql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtname := sqlget({m2},{court_name})firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})m_courttype := sqlget({m3},{court_type})firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})m_courtid := sqlget({m4},{court_name_mastid})firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})login_userid := sqlget({m4},{axusersid})firesql({m4},{select :username as uname from dual})u_name := sqlget({m4},{uname})firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtcode := sqlget({m4},{COURT_CODE})firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})m_statename := sqlget({m2},{STATE_NAME})firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_distName := sqlget({m7},{DISTNAMEENG})firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_courtcatid := sqlget({m8},{COURT_CATEGOTY})firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})m_deptid := sqlget({m4},{department_mastid})firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})m_courttypeid := sqlget({m3},{court_type_mastid})firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })urole := sqlget({m4},{groupname})firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})m_cutoffdt := sqlget({a1},{dd})firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})m_offcount := sqlget({P1},{ct})00000F
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
username=POOJAMEENA
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=POOJAMEENA
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = BOARD OF REVENUE,AJMER
Result = BOARD OF REVENUE,AJMER
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=POOJAMEENA
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=POOJAMEENA
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = Revenue Board
Result = Revenue Board
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=POOJAMEENA
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=POOJAMEENA
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 11599000000000
Result = 11599000000000
Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=POOJAMEENA
Time elapsed = 18
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1686550007217
Result = 1686550007217
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=POOJAMEENA
Time elapsed = 15
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = POOJAMEENA
Result = POOJAMEENA
Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=POOJAMEENA
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10006
Result = 10006
Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 13
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=POOJAMEENA
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=POOJAMEENA
Time elapsed = 12
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Ajmer
Result = Ajmer
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=POOJAMEENA
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=POOJAMEENA
Time elapsed = 18
Result of firesql =
Result =
Evaluating sqlget({m8},{COURT_CATEGOTY})
Calling function sqlget
Result of sqlget = 10593000000007
Result = 10593000000007
Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
Calling function firesql
login_userid=1686550007217
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1686550007217
Time elapsed = 14
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=POOJAMEENA
Time elapsed = 14
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10206000000012
Result = 10206000000012
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=POOJAMEENA
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=POOJAMEENA
Time elapsed = 20
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = rb_fbroom
Result = rb_fbroom
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 10
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=POOJAMEENA
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=POOJAMEENA
Time elapsed = 26
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 0
Result = 0
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('rb_fbroom') and lower(sname)='bocup' and stype = 't' )
Time elapsed = 5
select Props from axuseraccess where lower(rname)='rb_fbroom' and lower(sname)='bocup' and stype = 't'
Time elapsed = 10
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : rb_fbroom,bocup,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 4
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 = 10
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 = 6
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 = 8
select * from AxAttachWorkflow where lower(transid) = 'bocup'
Time elapsed = 13
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 = 4
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 = 7
select case_purpose_name from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 11
select distinct(schemaname) from axschema where lower(transid)='rbcrt'
Time elapsed = 5
select case_purpose_code from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 4
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 = 4
Step4
tstructs\stm size:2091
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=rbchh
adxinout=o
Time elapsed = 6
select * from trn_bor_case_hist where trn_bor_case_histid=0
Time elapsed = 7
Evaluating date()
Result =
Evaluating {Feedback}
Result =
Loading genmaps
Creating Action object
Submitting data to dbcall
Submiting & Registering data
Registering Global variables data
Registering Global variables data over
Setting values over
DB Call Validate and save
>>Validating bocup
>>Frame No 1
courtname = 11599000000000
courtcode = 10006
cldate = 25/06/2025
cltype = A
benchname = ??. ??-5
benchcode = 6
cluser =
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 = 9
RecordId = 19644000010587
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 23
cluser =
benchcode = 6
bench_mem2 = 0
bench_mem1 = 0
benchname = ??. ??-5
courtcode = 10006
courtname = 11599000000000
cltype = A
cldate = 25/06/2025
Posting record
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:18
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
benchcode=6
Param Type = c
bench_mem2=0
Param Type = c
bench_mem1=0
Param Type = c
benchname=??. ??-5
Param Type = c
courtcode=10006
Param Type = c
courtname=11599000000000
Param Type = c
cltype=A
Param Type = c
cldate=25/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,null,:benchcode,:bench_mem2,:bench_mem1,:benchname,:courtcode,:courtname,:cltype,to_date(:cldate,'dd/mm/yyyy hh24:mi:ss'))
Saving to table TRN_BOR_CASEMEMBER
select * from TRN_BOR_CASEMEMBER where TRN_BOR_CASEMEMBERid=0
Time elapsed = 5
Adding new record to store data from Frame 3, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 19644000010588
Select sysdate as sdt from dual
Time elapsed = 12
officer_mastid = 1453880009973
trn_bor_caseregid = 18383000003564
mem_inactive = NO
request_type = RESERVED
TRN_BOR_CASEMEMBERrow = 1
Posting record
Param Type = n
trn_bor_casememberid=19644000010588
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = c
officer_mastid=1453880009973
Param Type = n
trn_bor_caseregid=18383000003564
Param Type = c
mem_inactive=NO
Param Type = c
request_type=RESERVED
Param Type = n
trn_bor_casememberrow=1
insert into TRN_BOR_CASEMEMBER (trn_bor_casememberid,trn_bor_mhearingid,officer_mastid,trn_bor_caseregid,mem_inactive,request_type,trn_bor_casememberrow) values (:trn_bor_casememberid,:trn_bor_mhearingid,:officer_mastid,:trn_bor_caseregid,:mem_inactive,:request_type,:trn_bor_casememberrow)
select * from TRN_BOR_CASEMEMBER where TRN_BOR_CASEMEMBERid=0
Time elapsed = 8
Adding new record to store data from Frame 3, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 19644000010589
Select sysdate as sdt from dual
Time elapsed = 9
officer_mastid = 1453880009973
trn_bor_caseregid = 18183000005923
mem_inactive = NO
request_type = RESERVED
TRN_BOR_CASEMEMBERrow = 2
Posting record
Param Type = n
trn_bor_casememberid=19644000010589
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = c
officer_mastid=1453880009973
Param Type = n
trn_bor_caseregid=18183000005923
Param Type = c
mem_inactive=NO
Param Type = c
request_type=RESERVED
Param Type = n
trn_bor_casememberrow=2
insert into TRN_BOR_CASEMEMBER (trn_bor_casememberid,trn_bor_mhearingid,officer_mastid,trn_bor_caseregid,mem_inactive,request_type,trn_bor_casememberrow) values (:trn_bor_casememberid,:trn_bor_mhearingid,:officer_mastid,:trn_bor_caseregid,:mem_inactive,:request_type,:trn_bor_casememberrow)
select * from TRN_BOR_CASEMEMBER where TRN_BOR_CASEMEMBERid=0
Time elapsed = 7
Adding new record to store data from Frame 3, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 19644000010590
Select sysdate as sdt from dual
Time elapsed = 6
request_type = RESERVED
mem_inactive = NO
officer_mastid = 1453880009973
trn_bor_caseregid = 18029000006298
TRN_BOR_CASEMEMBERrow = 3
Posting record
Param Type = n
trn_bor_casememberid=19644000010590
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = c
request_type=RESERVED
Param Type = c
mem_inactive=NO
Param Type = c
officer_mastid=1453880009973
Param Type = n
trn_bor_caseregid=18029000006298
Param Type = n
trn_bor_casememberrow=3
insert into TRN_BOR_CASEMEMBER (trn_bor_casememberid,trn_bor_mhearingid,request_type,mem_inactive,officer_mastid,trn_bor_caseregid,trn_bor_casememberrow) values (:trn_bor_casememberid,:trn_bor_mhearingid,:request_type,:mem_inactive,:officer_mastid,:trn_bor_caseregid,:trn_bor_casememberrow)
Saving to table TRN_BOR_HEARING
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 10
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 = 19644000010591
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 13
trn_bor_caseid = 16629000011168
manual_case_no =
court_name = 11599000000000
case_no = 2025/5385
court_code = 10006
new_case_purpose = 10110000000719
new_purpose_code = 122
next_hear_date = 18/09/2025
new_purpose_group = 19971000000602
docid = 100062025/5385
bench_code = 6
puname = POOJAMEENA
prev_hear_date = 25/06/2025
prev_purpose_code = 121
TRN_BOR_HEARINGrow = 1
Posting record
Param Type = n
trn_bor_hearingid=19644000010591
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:18
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
trn_bor_caseid=16629000011168
Param Type = c
court_name=11599000000000
Param Type = c
case_no=2025/5385
Param Type = c
court_code=10006
Param Type = c
new_case_purpose=10110000000719
Param Type = c
new_purpose_code=122
Param Type = c
next_hear_date=18/09/2025 00:00:00
Param Type = n
new_purpose_group=19971000000602
Param Type = c
docid=100062025/5385
Param Type = c
bench_code=6
Param Type = c
puname=POOJAMEENA
Param Type = c
prev_hear_date=25/06/2025 00:00:00
Param Type = c
prev_purpose_code=121
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,trn_bor_caseid,manual_case_no,court_name,case_no,court_code,new_case_purpose,new_purpose_code,next_hear_date,new_purpose_group,docid,bench_code,puname,prev_hear_date,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,:trn_bor_caseid,null,:court_name,:case_no,:court_code,:new_case_purpose,:new_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:docid,:bench_code,:puname,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,: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 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 20
RecordId = 19644000010592
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 11
case_no = 2025/5408
trn_bor_caseid = 18585000009725
manual_case_no =
docid = 100062025/5408
puname = POOJAMEENA
court_name = 11599000000000
court_code = 10006
new_purpose_code = 121
new_purpose_group = 19966000000909
next_hear_date = 27/06/2025
new_case_purpose = 10109000001043
bench_code = 6
prev_purpose_code = 121
prev_hear_date = 25/06/2025
TRN_BOR_HEARINGrow = 2
Posting record
Param Type = n
trn_bor_hearingid=19644000010592
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:19
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2025/5408
Param Type = n
trn_bor_caseid=18585000009725
Param Type = c
docid=100062025/5408
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=121
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=27/06/2025 00:00:00
Param Type = c
new_case_purpose=10109000001043
Param Type = c
bench_code=6
Param Type = c
prev_purpose_code=121
Param Type = c
prev_hear_date=25/06/2025 00:00:00
Param Type = n
trn_bor_hearingrow=2
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 9
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 = 6
RecordId = 19644000010593
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 27
Select sysdate as sdt from dual
Time elapsed = 10
case_no = 2025/5470
trn_bor_caseid = 19263000009705
manual_case_no =
docid = 100062025/5470
puname = POOJAMEENA
court_name = 11599000000000
court_code = 10006
new_purpose_code = 73
new_purpose_group = 19966000000909
next_hear_date = 27/06/2025
new_case_purpose = 17553000001243
bench_code = 6
prev_purpose_code = 73
prev_hear_date = 25/06/2025
TRN_BOR_HEARINGrow = 3
Posting record
Param Type = n
trn_bor_hearingid=19644000010593
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:19
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2025/5470
Param Type = n
trn_bor_caseid=19263000009705
Param Type = c
docid=100062025/5470
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=73
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=27/06/2025 00:00:00
Param Type = c
new_case_purpose=17553000001243
Param Type = c
bench_code=6
Param Type = c
prev_purpose_code=73
Param Type = c
prev_hear_date=25/06/2025 00:00:00
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,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 = 15
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 = 6
RecordId = 19644000010594
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 7
prev_hear_date = 25/06/2025
prev_purpose_code = 121
bench_code = 6
new_case_purpose = 10110000000719
next_hear_date = 19/09/2025
new_purpose_group = 19971000000602
new_purpose_code = 122
court_code = 10006
court_name = 11599000000000
puname = POOJAMEENA
docid = 100062025/5523
manual_case_no =
trn_bor_caseid = 15585000010202
case_no = 2025/5523
TRN_BOR_HEARINGrow = 4
Posting record
Param Type = n
trn_bor_hearingid=19644000010594
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:19
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=25/06/2025 00:00:00
Param Type = c
prev_purpose_code=121
Param Type = c
bench_code=6
Param Type = c
new_case_purpose=10110000000719
Param Type = c
next_hear_date=19/09/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
court_name=11599000000000
Param Type = c
puname=POOJAMEENA
Param Type = c
docid=100062025/5523
Param Type = n
trn_bor_caseid=15585000010202
Param Type = c
case_no=2025/5523
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,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 = 10
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 = 6
RecordId = 19644000010595
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2025/5527
trn_bor_caseid = 15851000010006
manual_case_no =
docid = 100062025/5527
puname = POOJAMEENA
court_name = 11599000000000
court_code = 10006
new_purpose_group = 19971000000602
next_hear_date = 19/09/2025
prev_purpose_code = 121
new_purpose_code = 122
bench_code = 6
prev_hear_date = 25/06/2025
new_case_purpose = 10110000000719
TRN_BOR_HEARINGrow = 5
Posting record
Param Type = n
trn_bor_hearingid=19644000010595
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:19
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2025/5527
Param Type = n
trn_bor_caseid=15851000010006
Param Type = c
docid=100062025/5527
Param Type = c
puname=POOJAMEENA
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=19/09/2025 00:00:00
Param Type = c
prev_purpose_code=121
Param Type = c
new_purpose_code=122
Param Type = c
bench_code=6
Param Type = c
prev_hear_date=25/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,prev_purpose_code,new_purpose_code,bench_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'),:prev_purpose_code,:new_purpose_code,:bench_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 = 8
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 = 5
RecordId = 19644000010596
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
court_code = 10006
docid = 100062025/5532
puname = POOJAMEENA
court_name = 11599000000000
case_no = 2025/5532
new_purpose_code = 121
new_case_purpose = 10109000001043
next_hear_date = 27/06/2025
new_purpose_group = 19966000000909
prev_hear_date = 25/06/2025
manual_case_no =
trn_bor_caseid = 16513000009859
prev_purpose_code = 121
bench_code = 6
TRN_BOR_HEARINGrow = 6
Posting record
Param Type = n
trn_bor_hearingid=19644000010596
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:19
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10006
Param Type = c
docid=100062025/5532
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
case_no=2025/5532
Param Type = c
new_purpose_code=121
Param Type = c
new_case_purpose=10109000001043
Param Type = c
next_hear_date=27/06/2025 00:00:00
Param Type = n
new_purpose_group=19966000000909
Param Type = c
prev_hear_date=25/06/2025 00:00:00
Param Type = n
trn_bor_caseid=16513000009859
Param Type = c
prev_purpose_code=121
Param Type = c
bench_code=6
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,court_code,docid,puname,court_name,case_no,new_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,prev_hear_date,manual_case_no,trn_bor_caseid,prev_purpose_code,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,:court_code,:docid,:puname,:court_name,:case_no,:new_purpose_code,:new_case_purpose,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'),null,:trn_bor_caseid,:prev_purpose_code,: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 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 19644000010597
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
manual_case_no =
bench_code = 6
trn_bor_caseid = 17086000010401
docid = 100062025/5544
case_no = 2025/5544
prev_purpose_code = 229
new_purpose_group = 19966000000909
new_purpose_code = 229
next_hear_date = 27/06/2025
prev_hear_date = 25/06/2025
new_case_purpose = 11356000002249
court_code = 10006
puname = POOJAMEENA
court_name = 11599000000000
TRN_BOR_HEARINGrow = 7
Posting record
Param Type = n
trn_bor_hearingid=19644000010597
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:19
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
bench_code=6
Param Type = n
trn_bor_caseid=17086000010401
Param Type = c
docid=100062025/5544
Param Type = c
case_no=2025/5544
Param Type = c
prev_purpose_code=229
Param Type = n
new_purpose_group=19966000000909
Param Type = c
new_purpose_code=229
Param Type = c
next_hear_date=27/06/2025 00:00:00
Param Type = c
prev_hear_date=25/06/2025 00:00:00
Param Type = c
new_case_purpose=11356000002249
Param Type = c
court_code=10006
Param Type = c
puname=POOJAMEENA
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,new_purpose_group,new_purpose_code,next_hear_date,prev_hear_date,new_case_purpose,court_code,puname,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,:new_purpose_group,:new_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:court_code,:puname,:court_name,:trn_bor_hearingrow)
select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0
Time elapsed = 9
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 = 5
RecordId = 19644000010598
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 6
court_name = 11599000000000
prev_hear_date = 25/06/2025
new_case_purpose = 10110000000719
puname = POOJAMEENA
bench_code = 6
manual_case_no =
prev_purpose_code = 2
trn_bor_caseid = 17525000010357
next_hear_date = 18/09/2025
docid = 100062025/5553
new_purpose_group = 19971000000602
new_purpose_code = 122
case_no = 2025/5553
court_code = 10006
TRN_BOR_HEARINGrow = 8
Posting record
Param Type = n
trn_bor_hearingid=19644000010598
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:19
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_name=11599000000000
Param Type = c
prev_hear_date=25/06/2025 00:00:00
Param Type = c
new_case_purpose=10110000000719
Param Type = c
puname=POOJAMEENA
Param Type = c
bench_code=6
Param Type = c
prev_purpose_code=2
Param Type = n
trn_bor_caseid=17525000010357
Param Type = c
next_hear_date=18/09/2025 00:00:00
Param Type = c
docid=100062025/5553
Param Type = n
new_purpose_group=19971000000602
Param Type = c
new_purpose_code=122
Param Type = c
case_no=2025/5553
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,court_name,prev_hear_date,new_case_purpose,puname,bench_code,manual_case_no,prev_purpose_code,trn_bor_caseid,next_hear_date,docid,new_purpose_group,new_purpose_code,case_no,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,:court_name,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:puname,:bench_code,null,:prev_purpose_code,:trn_bor_caseid,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:docid,:new_purpose_group,:new_purpose_code,:case_no,: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 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 19644000010599
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 14
case_no = 2025/5560
trn_bor_caseid = 17961000009127
manual_case_no =
docid = 100062025/5560
puname = POOJAMEENA
court_name = 11599000000000
court_code = 10006
new_purpose_code = 122
new_purpose_group = 19971000000602
next_hear_date = 19/09/2025
new_case_purpose = 10110000000719
bench_code = 6
prev_purpose_code = 2
prev_hear_date = 25/06/2025
TRN_BOR_HEARINGrow = 9
Posting record
Param Type = n
trn_bor_hearingid=19644000010599
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:19
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2025/5560
Param Type = n
trn_bor_caseid=17961000009127
Param Type = c
docid=100062025/5560
Param Type = c
puname=POOJAMEENA
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=122
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=19/09/2025 00:00:00
Param Type = c
new_case_purpose=10110000000719
Param Type = c
bench_code=6
Param Type = c
prev_purpose_code=2
Param Type = c
prev_hear_date=25/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 = 9
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 = 8
RecordId = 19644000010600
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
prev_hear_date = 25/06/2025
prev_purpose_code = 120
bench_code = 6
new_case_purpose = 15904000000025
next_hear_date = 25/06/2025
new_purpose_group = 18437000000000
new_purpose_code = 301
court_code = 10006
court_name = 11599000000000
puname = POOJAMEENA
docid = 100062020/1015
manual_case_no =
trn_bor_caseid = 18383000003564
case_no = 2020/1015
TRN_BOR_HEARINGrow = 10
Posting record
Param Type = n
trn_bor_hearingid=19644000010600
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:19
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=25/06/2025 00:00:00
Param Type = c
prev_purpose_code=120
Param Type = c
bench_code=6
Param Type = c
new_case_purpose=15904000000025
Param Type = c
next_hear_date=25/06/2025 00:00:00
Param Type = n
new_purpose_group=18437000000000
Param Type = c
new_purpose_code=301
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
puname=POOJAMEENA
Param Type = c
docid=100062020/1015
Param Type = n
trn_bor_caseid=18383000003564
Param Type = c
case_no=2020/1015
Param Type = n
trn_bor_hearingrow=10
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_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 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 19644000010601
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
docid = 100062021/4709
prev_purpose_code = 120
prev_hear_date = 25/06/2025
bench_code = 6
case_no = 2021/4709
trn_bor_caseid = 18183000005923
manual_case_no =
court_code = 10006
court_name = 11599000000000
puname = POOJAMEENA
next_hear_date = 25/06/2025
new_case_purpose = 15904000000025
new_purpose_code = 301
new_purpose_group = 18437000000000
TRN_BOR_HEARINGrow = 11
Posting record
Param Type = n
trn_bor_hearingid=19644000010601
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:19
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
docid=100062021/4709
Param Type = c
prev_purpose_code=120
Param Type = c
prev_hear_date=25/06/2025 00:00:00
Param Type = c
bench_code=6
Param Type = c
case_no=2021/4709
Param Type = n
trn_bor_caseid=18183000005923
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
puname=POOJAMEENA
Param Type = c
next_hear_date=25/06/2025 00:00:00
Param Type = c
new_case_purpose=15904000000025
Param Type = c
new_purpose_code=301
Param Type = n
new_purpose_group=18437000000000
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,docid,prev_purpose_code,prev_hear_date,bench_code,case_no,trn_bor_caseid,manual_case_no,court_code,court_name,puname,next_hear_date,new_case_purpose,new_purpose_code,new_purpose_group,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:docid,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,:case_no,:trn_bor_caseid,null,:court_code,:court_name,:puname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:new_purpose_code,:new_purpose_group,: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 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 20
RecordId = 19644000010602
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 32
Select sysdate as sdt from dual
Time elapsed = 30
prev_hear_date = 25/06/2025
prev_purpose_code = 120
bench_code = 6
new_case_purpose = 15904000000025
next_hear_date = 25/06/2025
new_purpose_group = 18437000000000
new_purpose_code = 301
court_code = 10006
court_name = 11599000000000
puname = POOJAMEENA
docid = 100062022/6272
manual_case_no =
trn_bor_caseid = 18029000006298
case_no = 2022/6272
TRN_BOR_HEARINGrow = 12
Posting record
Param Type = n
trn_bor_hearingid=19644000010602
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:19
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=25/06/2025 00:00:00
Param Type = c
prev_purpose_code=120
Param Type = c
bench_code=6
Param Type = c
new_case_purpose=15904000000025
Param Type = c
next_hear_date=25/06/2025 00:00:00
Param Type = n
new_purpose_group=18437000000000
Param Type = c
new_purpose_code=301
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
puname=POOJAMEENA
Param Type = c
docid=100062022/6272
Param Type = n
trn_bor_caseid=18029000006298
Param Type = c
case_no=2022/6272
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,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 = 14
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 = 6
RecordId = 19644000010603
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 20
manual_case_no =
bench_code = 6
court_name = 11599000000000
trn_bor_caseid = 14055000007735
court_code = 10006
docid = 100062023/3644
case_no = 2023/3644
new_purpose_group = 19973000000612
next_hear_date = 30/06/2025
puname = POOJAMEENA
new_purpose_code = 120
prev_purpose_code = 120
prev_hear_date = 25/06/2025
new_case_purpose = 10107000000777
TRN_BOR_HEARINGrow = 13
Posting record
Param Type = n
trn_bor_hearingid=19644000010603
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:19
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
bench_code=6
Param Type = c
court_name=11599000000000
Param Type = n
trn_bor_caseid=14055000007735
Param Type = c
court_code=10006
Param Type = c
docid=100062023/3644
Param Type = c
case_no=2023/3644
Param Type = n
new_purpose_group=19973000000612
Param Type = c
next_hear_date=30/06/2025 00:00:00
Param Type = c
puname=POOJAMEENA
Param Type = c
new_purpose_code=120
Param Type = c
prev_purpose_code=120
Param Type = c
prev_hear_date=25/06/2025 00:00:00
Param Type = c
new_case_purpose=10107000000777
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,manual_case_no,bench_code,court_name,trn_bor_caseid,court_code,docid,case_no,new_purpose_group,next_hear_date,puname,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,null,:bench_code,:court_name,:trn_bor_caseid,:court_code,:docid,:case_no,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:puname,:new_purpose_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_bor_hearingrow)
Saving to table TRN_BOR_ZFUPDATE
select * from TRN_BOR_ZFUPDATE where TRN_BOR_ZFUPDATEid=0
Time elapsed = 18
Adding new record to store data from Frame 4, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 14
RecordId = 19644000010604
Select sysdate as sdt from dual
Time elapsed = 52
memupdate = 1
trn_bor_case_id = 18383000003564
is_update = 1
TRN_BOR_ZFUPDATErow = 1
Posting record
Param Type = n
trn_bor_zfupdateid=19644000010604
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
memupdate=1
Param Type = n
trn_bor_case_id=18383000003564
Param Type = n
is_update=1
Param Type = n
trn_bor_zfupdaterow=1
insert into TRN_BOR_ZFUPDATE (trn_bor_zfupdateid,trn_bor_mhearingid,memupdate,trn_bor_case_id,is_update,trn_bor_zfupdaterow) values (:trn_bor_zfupdateid,:trn_bor_mhearingid,:memupdate,:trn_bor_case_id,:is_update,:trn_bor_zfupdaterow)
select * from TRN_BOR_ZFUPDATE where TRN_BOR_ZFUPDATEid=0
Time elapsed = 9
Adding new record to store data from Frame 4, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 11
RecordId = 19644000010605
Select sysdate as sdt from dual
Time elapsed = 6
memupdate = 1
trn_bor_case_id = 18183000005923
is_update = 1
TRN_BOR_ZFUPDATErow = 2
Posting record
Param Type = n
trn_bor_zfupdateid=19644000010605
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
memupdate=1
Param Type = n
trn_bor_case_id=18183000005923
Param Type = n
is_update=1
Param Type = n
trn_bor_zfupdaterow=2
insert into TRN_BOR_ZFUPDATE (trn_bor_zfupdateid,trn_bor_mhearingid,memupdate,trn_bor_case_id,is_update,trn_bor_zfupdaterow) values (:trn_bor_zfupdateid,:trn_bor_mhearingid,:memupdate,:trn_bor_case_id,:is_update,:trn_bor_zfupdaterow)
select * from TRN_BOR_ZFUPDATE where TRN_BOR_ZFUPDATEid=0
Time elapsed = 4
Adding new record to store data from Frame 4, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 19644000010606
Select sysdate as sdt from dual
Time elapsed = 4
memupdate = 1
trn_bor_case_id = 18029000006298
is_update = 1
TRN_BOR_ZFUPDATErow = 3
Posting record
Param Type = n
trn_bor_zfupdateid=19644000010606
Param Type = n
trn_bor_mhearingid=19644000010587
Param Type = n
memupdate=1
Param Type = n
trn_bor_case_id=18029000006298
Param Type = n
is_update=1
Param Type = n
trn_bor_zfupdaterow=3
insert into TRN_BOR_ZFUPDATE (trn_bor_zfupdateid,trn_bor_mhearingid,memupdate,trn_bor_case_id,is_update,trn_bor_zfupdaterow) values (:trn_bor_zfupdateid,:trn_bor_mhearingid,:memupdate,:trn_bor_case_id,:is_update,:trn_bor_zfupdaterow)
Time elapsed for insert/update = 3960105578391
>>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 = 2025/5385 idvalue 0
Mapped hearing_date Row = 1 value = 18/09/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 25/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 16629000011168 idvalue 0
Mapped case_docid Row = 1 value = 100062025/5385 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 = 26/06/2025
doc_date after validation = 26/06/2025
court_code = 10006
trn_bor_caseregid = 16629000011168
case_docid = 100062025/5385
case_no = 2025/5385
prev_hearing_date = 25/06/2025
hearing_date = 18/09/2025
prev_case_purposename = ?????? ????
prev_case_purpose =
prev_case_purposename=?????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????? ????
Time elapsed = 4
prev_case_purpose after validation = 10109000001043
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 = 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 = 5
RecordId = 19644000010607
MapName bocup1
SourceId 19644000010591
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
prev_case_purpose = 10109000001043
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 26/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 18/09/2025
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2025/5385
case_docid = 100062025/5385
case_purpose = 10110000000719
trn_bor_caseregid = 16629000011168
prev_hearing_date = 25/06/2025
Posting record
Param Type = n
trn_bor_case_histid=19644000010607
Param Type = c
mapname=bocup1
Param Type = n
sourceid=19644000010591
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:33
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10109000001043
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=26/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=18/09/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2025/5385
Param Type = c
case_docid=100062025/5385
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=16629000011168
Param Type = c
prev_hearing_date=25/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 = 2025/5408 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 = 25/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 18585000009725 idvalue 0
Mapped case_docid Row = 1 value = 100062025/5408 idvalue 0
Mapped case_purpose Row = 1 value = 10109000001043 idvalue 0
Mapped case_purpose_code Row = 1 value = 121 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 = 26/06/2025
doc_date after validation = 26/06/2025
court_code = 10006
trn_bor_caseregid = 18585000009725
case_docid = 100062025/5408
case_no = 2025/5408
prev_hearing_date = 25/06/2025
hearing_date = 27/06/2025
prev_case_purposename = ?????? ????
prev_case_purpose =
prev_case_purpose after validation = 10109000001043
case_purpose = 10109000001043
case_purpose_code = 121
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 15
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 13
RecordId = 19644000010608
MapName bocup1
SourceId 19644000010592
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 9
prev_case_purpose = 10109000001043
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 26/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 121
hearing_date = 27/06/2025
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2025/5408
case_docid = 100062025/5408
case_purpose = 10109000001043
trn_bor_caseregid = 18585000009725
prev_hearing_date = 25/06/2025
Posting record
Param Type = n
trn_bor_case_histid=19644000010608
Param Type = c
mapname=bocup1
Param Type = n
sourceid=19644000010592
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:33
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10109000001043
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=26/06/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=121
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=2025/5408
Param Type = c
case_docid=100062025/5408
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=18585000009725
Param Type = c
prev_hearing_date=25/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 = 2025/5470 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 = 25/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 19263000009705 idvalue 0
Mapped case_docid Row = 1 value = 100062025/5470 idvalue 0
Mapped case_purpose Row = 1 value = 17553000001243 idvalue 0
Mapped case_purpose_code Row = 1 value = 73 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 = 26/06/2025
doc_date after validation = 26/06/2025
court_code = 10006
trn_bor_caseregid = 19263000009705
case_docid = 100062025/5470
case_no = 2025/5470
prev_hearing_date = 25/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 = 17553000001243
case_purpose = 17553000001243
case_purpose_code = 73
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 = 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 = 19644000010609
MapName bocup1
SourceId 19644000010593
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 17553000001243
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 26/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 73
hearing_date = 27/06/2025
prev_case_purposename = ?????? ???? ??????
court_code = 10006
case_no = 2025/5470
case_docid = 100062025/5470
case_purpose = 17553000001243
trn_bor_caseregid = 19263000009705
prev_hearing_date = 25/06/2025
Posting record
Param Type = n
trn_bor_case_histid=19644000010609
Param Type = c
mapname=bocup1
Param Type = n
sourceid=19644000010593
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:34
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=17553000001243
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=26/06/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=73
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=2025/5470
Param Type = c
case_docid=100062025/5470
Param Type = c
case_purpose=17553000001243
Param Type = n
trn_bor_caseregid=19263000009705
Param Type = c
prev_hearing_date=25/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 = 2025/5523 idvalue 0
Mapped hearing_date Row = 1 value = 19/09/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 25/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 15585000010202 idvalue 0
Mapped case_docid Row = 1 value = 100062025/5523 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 = 26/06/2025
doc_date after validation = 26/06/2025
court_code = 10006
trn_bor_caseregid = 15585000010202
case_docid = 100062025/5523
case_no = 2025/5523
prev_hearing_date = 25/06/2025
hearing_date = 19/09/2025
prev_case_purposename = ?????? ????
prev_case_purpose =
prev_case_purposename=?????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????? ????
Time elapsed = 11
prev_case_purpose after validation = 10109000001043
case_purpose = 10110000000719
case_purpose_code = 122
bench_type =
bench_name =
clcheck =
decision_type =
decision_date =
module =
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)
>>Writing to tables rbchh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh'
Time elapsed = 12
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0
Time elapsed = 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 = 9
RecordId = 19644000010610
MapName bocup1
SourceId 19644000010594
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 12
prev_case_purpose = 10109000001043
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 26/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 19/09/2025
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2025/5523
case_docid = 100062025/5523
case_purpose = 10110000000719
trn_bor_caseregid = 15585000010202
prev_hearing_date = 25/06/2025
Posting record
Param Type = n
trn_bor_case_histid=19644000010610
Param Type = c
mapname=bocup1
Param Type = n
sourceid=19644000010594
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:34
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10109000001043
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=26/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=19/09/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2025/5523
Param Type = c
case_docid=100062025/5523
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=15585000010202
Param Type = c
prev_hearing_date=25/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 = 2025/5527 idvalue 0
Mapped hearing_date Row = 1 value = 19/09/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 25/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 15851000010006 idvalue 0
Mapped case_docid Row = 1 value = 100062025/5527 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 = 26/06/2025
doc_date after validation = 26/06/2025
court_code = 10006
trn_bor_caseregid = 15851000010006
case_docid = 100062025/5527
case_no = 2025/5527
prev_hearing_date = 25/06/2025
hearing_date = 19/09/2025
prev_case_purposename = ?????? ????
prev_case_purpose =
prev_case_purpose after validation = 10109000001043
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 = 25
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 = 19644000010611
MapName bocup1
SourceId 19644000010595
Select sysdate as sdt from dual
Time elapsed = 36
Select sysdate as sdt from dual
Time elapsed = 18
prev_case_purpose = 10109000001043
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 26/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 19/09/2025
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2025/5527
case_docid = 100062025/5527
case_purpose = 10110000000719
trn_bor_caseregid = 15851000010006
prev_hearing_date = 25/06/2025
Posting record
Param Type = n
trn_bor_case_histid=19644000010611
Param Type = c
mapname=bocup1
Param Type = n
sourceid=19644000010595
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:34
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10109000001043
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=26/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=19/09/2025 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2025/5527
Param Type = c
case_docid=100062025/5527
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=15851000010006
Param Type = c
prev_hearing_date=25/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 = 2025/5532 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 = 25/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 16513000009859 idvalue 0
Mapped case_docid Row = 1 value = 100062025/5532 idvalue 0
Mapped case_purpose Row = 1 value = 10109000001043 idvalue 0
Mapped case_purpose_code Row = 1 value = 121 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 = 26/06/2025
doc_date after validation = 26/06/2025
court_code = 10006
trn_bor_caseregid = 16513000009859
case_docid = 100062025/5532
case_no = 2025/5532
prev_hearing_date = 25/06/2025
hearing_date = 27/06/2025
prev_case_purposename = ?????? ????
prev_case_purpose =
prev_case_purpose after validation = 10109000001043
case_purpose = 10109000001043
case_purpose_code = 121
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 = 19
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 = 8
RecordId = 19644000010612
MapName bocup1
SourceId 19644000010596
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 8
prev_case_purpose = 10109000001043
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 26/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 121
hearing_date = 27/06/2025
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2025/5532
case_docid = 100062025/5532
case_purpose = 10109000001043
trn_bor_caseregid = 16513000009859
prev_hearing_date = 25/06/2025
Posting record
Param Type = n
trn_bor_case_histid=19644000010612
Param Type = c
mapname=bocup1
Param Type = n
sourceid=19644000010596
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:34
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10109000001043
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=26/06/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=121
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=2025/5532
Param Type = c
case_docid=100062025/5532
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=16513000009859
Param Type = c
prev_hearing_date=25/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 = 2025/5544 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 = 25/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 17086000010401 idvalue 0
Mapped case_docid Row = 1 value = 100062025/5544 idvalue 0
Mapped case_purpose Row = 1 value = 11356000002249 idvalue 0
Mapped case_purpose_code Row = 1 value = 229 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 = 26/06/2025
doc_date after validation = 26/06/2025
court_code = 10006
trn_bor_caseregid = 17086000010401
case_docid = 100062025/5544
case_no = 2025/5544
prev_hearing_date = 25/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 = 6
prev_case_purpose after validation = 11356000002249
case_purpose = 11356000002249
case_purpose_code = 229
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 = 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 = 6
RecordId = 19644000010613
MapName bocup1
SourceId 19644000010597
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 8
prev_case_purpose = 11356000002249
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 26/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 229
hearing_date = 27/06/2025
prev_case_purposename = ???????? ??????
court_code = 10006
case_no = 2025/5544
case_docid = 100062025/5544
case_purpose = 11356000002249
trn_bor_caseregid = 17086000010401
prev_hearing_date = 25/06/2025
Posting record
Param Type = n
trn_bor_case_histid=19644000010613
Param Type = c
mapname=bocup1
Param Type = n
sourceid=19644000010597
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:34
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=11356000002249
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=26/06/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=229
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=2025/5544
Param Type = c
case_docid=100062025/5544
Param Type = c
case_purpose=11356000002249
Param Type = n
trn_bor_caseregid=17086000010401
Param Type = c
prev_hearing_date=25/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 = 2025/5553 idvalue 0
Mapped hearing_date Row = 1 value = 18/09/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 25/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 17525000010357 idvalue 0
Mapped case_docid Row = 1 value = 100062025/5553 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 = 26/06/2025
doc_date after validation = 26/06/2025
court_code = 10006
trn_bor_caseregid = 17525000010357
case_docid = 100062025/5553
case_no = 2025/5553
prev_hearing_date = 25/06/2025
hearing_date = 18/09/2025
prev_case_purposename = ??????
prev_case_purpose =
prev_case_purposename=??????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????
Time elapsed = 6
prev_case_purpose after validation = 10001000000775
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 = 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 = 5
RecordId = 19644000010614
MapName bocup1
SourceId 19644000010598
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 14
prev_case_purpose = 10001000000775
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 26/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 18/09/2025
prev_case_purposename = ??????
court_code = 10006
case_no = 2025/5553
case_docid = 100062025/5553
case_purpose = 10110000000719
trn_bor_caseregid = 17525000010357
prev_hearing_date = 25/06/2025
Posting record
Param Type = n
trn_bor_case_histid=19644000010614
Param Type = c
mapname=bocup1
Param Type = n
sourceid=19644000010598
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:34
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10001000000775
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=26/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=18/09/2025 00:00:00
Param Type = c
prev_case_purposename=??????
Param Type = c
court_code=10006
Param Type = c
case_no=2025/5553
Param Type = c
case_docid=100062025/5553
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=17525000010357
Param Type = c
prev_hearing_date=25/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 = 2025/5560 idvalue 0
Mapped hearing_date Row = 1 value = 19/09/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 25/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 17961000009127 idvalue 0
Mapped case_docid Row = 1 value = 100062025/5560 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 = 26/06/2025
doc_date after validation = 26/06/2025
court_code = 10006
trn_bor_caseregid = 17961000009127
case_docid = 100062025/5560
case_no = 2025/5560
prev_hearing_date = 25/06/2025
hearing_date = 19/09/2025
prev_case_purposename = ??????
prev_case_purpose =
prev_case_purpose after validation = 10001000000775
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 = 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 = 19644000010615
MapName bocup1
SourceId 19644000010599
Select sysdate as sdt from dual
Time elapsed = 35
Select sysdate as sdt from dual
Time elapsed = 6
prev_case_purpose = 10001000000775
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 26/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 122
hearing_date = 19/09/2025
prev_case_purposename = ??????
court_code = 10006
case_no = 2025/5560
case_docid = 100062025/5560
case_purpose = 10110000000719
trn_bor_caseregid = 17961000009127
prev_hearing_date = 25/06/2025
Posting record
Param Type = n
trn_bor_case_histid=19644000010615
Param Type = c
mapname=bocup1
Param Type = n
sourceid=19644000010599
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:34
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10001000000775
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=26/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=19/09/2025 00:00:00
Param Type = c
prev_case_purposename=??????
Param Type = c
court_code=10006
Param Type = c
case_no=2025/5560
Param Type = c
case_docid=100062025/5560
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=17961000009127
Param Type = c
prev_hearing_date=25/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 = 2020/1015 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 = 25/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 18383000003564 idvalue 0
Mapped case_docid Row = 1 value = 100062020/1015 idvalue 0
Mapped case_purpose Row = 1 value = 15904000000025 idvalue 0
Mapped case_purpose_code Row = 1 value = 301 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 = 26/06/2025
doc_date after validation = 26/06/2025
court_code = 10006
trn_bor_caseregid = 18383000003564
case_docid = 100062020/1015
case_no = 2020/1015
prev_hearing_date = 25/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 = 10107000000777
case_purpose = 15904000000025
case_purpose_code = 301
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 = 9
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 = 19644000010616
MapName bocup1
SourceId 19644000010600
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 5
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 26/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 301
hearing_date = 25/06/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2020/1015
case_docid = 100062020/1015
case_purpose = 15904000000025
trn_bor_caseregid = 18383000003564
prev_hearing_date = 25/06/2025
Posting record
Param Type = n
trn_bor_case_histid=19644000010616
Param Type = c
mapname=bocup1
Param Type = n
sourceid=19644000010600
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:34
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:34
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=26/06/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=301
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=2020/1015
Param Type = c
case_docid=100062020/1015
Param Type = c
case_purpose=15904000000025
Param Type = n
trn_bor_caseregid=18383000003564
Param Type = c
prev_hearing_date=25/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 = 2021/4709 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 = 25/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 18183000005923 idvalue 0
Mapped case_docid Row = 1 value = 100062021/4709 idvalue 0
Mapped case_purpose Row = 1 value = 15904000000025 idvalue 0
Mapped case_purpose_code Row = 1 value = 301 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 = 26/06/2025
doc_date after validation = 26/06/2025
court_code = 10006
trn_bor_caseregid = 18183000005923
case_docid = 100062021/4709
case_no = 2021/4709
prev_hearing_date = 25/06/2025
hearing_date = 25/06/2025
prev_case_purposename = ???????? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 10107000000777
case_purpose = 15904000000025
case_purpose_code = 301
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 = 19644000010617
MapName bocup1
SourceId 19644000010601
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 26/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 301
hearing_date = 25/06/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2021/4709
case_docid = 100062021/4709
case_purpose = 15904000000025
trn_bor_caseregid = 18183000005923
prev_hearing_date = 25/06/2025
Posting record
Param Type = n
trn_bor_case_histid=19644000010617
Param Type = c
mapname=bocup1
Param Type = n
sourceid=19644000010601
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:35
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:35
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=26/06/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=301
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=2021/4709
Param Type = c
case_docid=100062021/4709
Param Type = c
case_purpose=15904000000025
Param Type = n
trn_bor_caseregid=18183000005923
Param Type = c
prev_hearing_date=25/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/6272 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 = 25/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 18029000006298 idvalue 0
Mapped case_docid Row = 1 value = 100062022/6272 idvalue 0
Mapped case_purpose Row = 1 value = 15904000000025 idvalue 0
Mapped case_purpose_code Row = 1 value = 301 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 = 26/06/2025
doc_date after validation = 26/06/2025
court_code = 10006
trn_bor_caseregid = 18029000006298
case_docid = 100062022/6272
case_no = 2022/6272
prev_hearing_date = 25/06/2025
hearing_date = 25/06/2025
prev_case_purposename = ???????? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 10107000000777
case_purpose = 15904000000025
case_purpose_code = 301
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 = 8
RecordId = 19644000010618
MapName bocup1
SourceId 19644000010602
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 26/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 301
hearing_date = 25/06/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2022/6272
case_docid = 100062022/6272
case_purpose = 15904000000025
trn_bor_caseregid = 18029000006298
prev_hearing_date = 25/06/2025
Posting record
Param Type = n
trn_bor_case_histid=19644000010618
Param Type = c
mapname=bocup1
Param Type = n
sourceid=19644000010602
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:35
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:35
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=26/06/2025 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=301
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/6272
Param Type = c
case_docid=100062022/6272
Param Type = c
case_purpose=15904000000025
Param Type = n
trn_bor_caseregid=18029000006298
Param Type = c
prev_hearing_date=25/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 = 2023/3644 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 = 25/06/2025 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 14055000007735 idvalue 0
Mapped case_docid Row = 1 value = 100062023/3644 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 = 26/06/2025
doc_date after validation = 26/06/2025
court_code = 10006
trn_bor_caseregid = 14055000007735
case_docid = 100062023/3644
case_no = 2023/3644
prev_hearing_date = 25/06/2025
hearing_date = 30/06/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 = 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 = 5
RecordId = 19644000010619
MapName bocup1
SourceId 19644000010603
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 8
prev_case_purpose = 10107000000777
bench_type =
trans_type = Cause List Update (Custom)
doc_date = 26/06/2025
decision_date =
module = Feedback
bench_name =
decision_type = 0
case_purpose_code = 120
hearing_date = 30/06/2025
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2023/3644
case_docid = 100062023/3644
case_purpose = 10107000000777
trn_bor_caseregid = 14055000007735
prev_hearing_date = 25/06/2025
Posting record
Param Type = n
trn_bor_case_histid=19644000010619
Param Type = c
mapname=bocup1
Param Type = n
sourceid=19644000010603
Param Type = c
cancel=F
Param Type = c
createdby=POOJAMEENA
Param Type = c
createdon=26/06/2025 13:19:35
Param Type = c
username=POOJAMEENA
Param Type = c
modifiedon=26/06/2025 13:19:35
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=26/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=30/06/2025 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/3644
Param Type = c
case_docid=100062023/3644
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=14055000007735
Param Type = c
prev_hearing_date=25/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 = 3960105579830
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=16629000011168
@trn_bor_caseregid=16629000011168
*hearingdate=18/09/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16629000011168 for update
Time elapsed = 124
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16629000011168
Time elapsed = 62
Param Type = c
hearingdate=18/09/2025 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=16629000011168
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=18585000009725
@trn_bor_caseregid=18585000009725
*hearingdate=27/06/2025
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18585000009725 for update
Time elapsed = 61
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18585000009725
Time elapsed = 56
Param Type = c
hearingdate=27/06/2025 00:00:00
Param Type = c
case_purpose_name=10109000001043
Param Type = c
case_purpose_code=121
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=18585000009725
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=19263000009705
@trn_bor_caseregid=19263000009705
*hearingdate=27/06/2025
*case_purpose_name=17553000001243
*case_purpose_code=73
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19263000009705 for update
Time elapsed = 67
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19263000009705
Time elapsed = 69
Param Type = c
hearingdate=27/06/2025 00:00:00
Param Type = c
case_purpose_name=17553000001243
Param Type = c
case_purpose_code=73
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=19263000009705
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=15585000010202
@trn_bor_caseregid=15585000010202
*hearingdate=19/09/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15585000010202 for update
Time elapsed = 85
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15585000010202
Time elapsed = 69
Param Type = c
hearingdate=19/09/2025 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=15585000010202
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=15851000010006
@trn_bor_caseregid=15851000010006
*hearingdate=19/09/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15851000010006 for update
Time elapsed = 87
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15851000010006
Time elapsed = 70
Param Type = c
hearingdate=19/09/2025 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=15851000010006
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=16513000009859
@trn_bor_caseregid=16513000009859
*hearingdate=27/06/2025
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16513000009859 for update
Time elapsed = 103
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16513000009859
Time elapsed = 62
Param Type = c
hearingdate=27/06/2025 00:00:00
Param Type = c
case_purpose_name=10109000001043
Param Type = c
case_purpose_code=121
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=16513000009859
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=17086000010401
@trn_bor_caseregid=17086000010401
*hearingdate=27/06/2025
*case_purpose_name=11356000002249
*case_purpose_code=229
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17086000010401 for update
Time elapsed = 64
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17086000010401
Time elapsed = 577
Param Type = c
hearingdate=27/06/2025 00:00:00
Param Type = c
case_purpose_name=11356000002249
Param Type = c
case_purpose_code=229
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=17086000010401
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=17525000010357
@trn_bor_caseregid=17525000010357
*hearingdate=18/09/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17525000010357 for update
Time elapsed = 86
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17525000010357
Time elapsed = 98
Param Type = c
hearingdate=18/09/2025 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=17525000010357
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=17961000009127
@trn_bor_caseregid=17961000009127
*hearingdate=19/09/2025
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17961000009127 for update
Time elapsed = 94
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17961000009127
Time elapsed = 89
Param Type = c
hearingdate=19/09/2025 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
where trn_bor_caseregid=17961000009127
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=18383000003564
@trn_bor_caseregid=18383000003564
*hearingdate=25/06/2025
*case_purpose_name=15904000000025
*case_purpose_code=301
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18383000003564 for update
Time elapsed = 65
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18383000003564
Time elapsed = 47
Param Type = c
hearingdate=25/06/2025 00:00:00
Param Type = c
case_purpose_name=15904000000025
Param Type = c
case_purpose_code=301
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=18383000003564
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=18183000005923
@trn_bor_caseregid=18183000005923
*hearingdate=25/06/2025
*case_purpose_name=15904000000025
*case_purpose_code=301
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18183000005923 for update
Time elapsed = 59
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18183000005923
Time elapsed = 91
Param Type = c
hearingdate=25/06/2025 00:00:00
Param Type = c
case_purpose_name=15904000000025
Param Type = c
case_purpose_code=301
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=18183000005923
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=18029000006298
@trn_bor_caseregid=18029000006298
*hearingdate=25/06/2025
*case_purpose_name=15904000000025
*case_purpose_code=301
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18029000006298 for update
Time elapsed = 105
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18029000006298
Time elapsed = 76
Param Type = c
hearingdate=25/06/2025 00:00:00
Param Type = c
case_purpose_name=15904000000025
Param Type = c
case_purpose_code=301
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=18029000006298
>>Posting MD Maps :
Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=14055000007735
@trn_bor_caseregid=14055000007735
*hearingdate=30/06/2025
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14055000007735 for update
Time elapsed = 51
SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14055000007735
Time elapsed = 64
Param Type = c
hearingdate=30/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=14055000007735
Time elapsed for MD Map = 3960105583153
Time elapsed for Save History = 3960105583154
Time elapsed for Save Attachment = 3960105583154
Time elapsed for After Save WF Exec = 3960105583156
Transaction commited
Result : {"message":[{"msg":"Cause List Feedback Saved","recordid":"19644000010587"}]}
Savedata webservice completed
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=POOJAMEENA
Param Type = c
calledon=26/06/2025 13:19:22
Param Type = c
callfinished=26/06/2025 13:19:43
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=20882
Param Type = n
dbtimetaken=19650
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