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
gcmsSDO_Girva_PRO827ccb0eea8a706c4c34a16891f84e7b![]()
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=SDO_Girva_PRO
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Girva_PRO
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ????? ???????, ??????,???? -??????
Result = ????? ???????, ??????,???? -??????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=SDO_Girva_PRO
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Girva_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = SDO
Result = SDO
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=SDO_Girva_PRO
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Girva_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 12122000000118
Result = 12122000000118
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=SDO_Girva_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1411330009425
Result = 1411330009425
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_Girva_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_Girva_PRO
Result = SDO_Girva_PRO
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=SDO_Girva_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10241
Result = 10241
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 = 2
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=SDO_Girva_PRO
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Girva_PRO
Time elapsed = 3
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Udaipur
Result = Udaipur
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Girva_PRO
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Girva_PRO
Time elapsed = 4
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=1411330009425
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1411330009425
Time elapsed = 5
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=SDO_Girva_PRO
Time elapsed = 2
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10823000000000
Result = 10823000000000
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=SDO_Girva_PRO
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=SDO_Girva_PRO
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_admin
Result = court_admin
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 = 3
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=SDO_Girva_PRO
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=SDO_Girva_PRO
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 12
Result = 12
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_admin') and lower(sname)='rctcr' and stype = 't' )
Time elapsed = 2
select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='rctcr' and stype = 't'
Time elapsed = 3
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_admin,rctcr,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 3
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : rctcr
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 3
Step4
tstructs\stm size:2355
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Evaluating date()
Result =
Evaluating 0
Result =
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=rctcr
adxinout=o
Time elapsed = 4
select * from trn_rcms_transreq where trn_rcms_transreqid=0
Time elapsed = 3
select * from Axusers where 1=2
Time elapsed = 5
select distinct(fldname) from AxTempUserFields
Time elapsed = 3
select * from AxAttachWorkflow where lower(transid) = 'rctcr'
Time elapsed = 2
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : tscd
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 2
Step4
tstructs\stm size:6667
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
select lpad(' ', 250, ' ') LVAL from dual
Time elapsed = 3
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tscd
adxinout=o
Time elapsed = 3
select * from trn_rcms_decision where trn_rcms_decisionid=0
Time elapsed = 4
Evaluating date()
Result =
Evaluating m_courtname
Result =
Evaluating {AND a1.court_code=:m_courtcode }
Result =
Evaluating iif(hearing_date>currdate,{Hearing Date Can not be greater Than Today },{T})
Result =
Evaluating iif(decision_date>currdate,{Decision Date Can not be greater Than Today },{T})
Result =
Evaluating 0
Result =
Evaluating {F}
Result =
Evaluating {F}
Result =
Evaluating {F}
Result =
Evaluating court_code+case_no
Result =
Evaluating username
Result =
Evaluating {cd.pdf}
Result =
Evaluating iif(recordid>0,{Decision Updated},{Decision Submitted})
Result =
Evaluating iif(recordid>0,{F},{T})
Result =
Loading genmaps
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : tsrcf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 3
Step4
tstructs\stm size:4166
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=tsrcf
adxinout=o
Time elapsed = 4
select * from trn_rcms_hearing where trn_rcms_hearingid=0
Time elapsed = 6
Evaluating date()
Result =
Evaluating { AND a1.court_code = :m_courtcode }
Result =
Evaluating m_courtname
Result =
Evaluating case_purpose_name
Result =
Evaluating {NO}
Result =
Evaluating {Feedback Submitted}
Result =
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : tchdh
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 2
Step4
tstructs\stm size:1907
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=tchdh
adxinout=o
Time elapsed = 2
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 2
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : tchdh
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 2
Step4
tstructs\stm size:1907
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=tchdh
adxinout=o
Time elapsed = 3
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 3
select distinct(schemaname) from axschema where lower(transid)='tscrg'
Time elapsed = 3
select trn_rcms_caseregid from trn_rcms_casereg where trn_rcms_caseregid=0
Time elapsed = 2
select case_decision_date from trn_rcms_casereg where trn_rcms_caseregid=0
Time elapsed = 2
select distinct(schemaname) from axschema where lower(transid)='tscrg'
Time elapsed = 2
select decision_type from trn_rcms_casereg where trn_rcms_caseregid=0
Time elapsed = 3
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 rctcr
>>Frame No 1
currdate =
Evaluating - date()
Result of date = 05/01/2026
currdate after validation = 05/01/2026
court_code = 10241
trans_ccode = 10689
case_purpose =
SELECT b.CASE_PURPOSE_MASTID, b.CASE_PURPOSE_NAME, b.case_purpose_code
FROM case_purpose_mast b WHERE CASE_PURPOSE_MASTID = 1025550004746
Time elapsed = 5
case_purpose after validation = ????????? Id = 1025550004746
dec_type =
SELECT DECISION_MASTID, DECISION_NAME
FROM decision_mast A
WHERE court_code = '10006' AND a.DECISION_MASTID = 11782000000706
ORDER BY DECISION_NAME
Time elapsed = 4
dec_type after validation = ????????? Id = 11782000000706
time zone difference = 0
>>Writing to tables rctcr
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rctcr'
Time elapsed = 2
Saving to table TRN_RCMS_TRANSREQ
select * from TRN_RCMS_TRANSREQ where TRN_RCMS_TRANSREQid=0
Time elapsed = 3
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 = 12684000010969
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_ccode = 10689
court_code = 10241
Posting record
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Girva_PRO
Param Type = c
createdon=05/01/2026 15:54:33
Param Type = c
username=SDO_Girva_PRO
Param Type = c
modifiedon=05/01/2026 15:54:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_ccode=10689
Param Type = c
court_code=10241
insert into TRN_RCMS_TRANSREQ (trn_rcms_transreqid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_ccode,court_code) values (:trn_rcms_transreqid,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,:trans_ccode,:court_code)
Saving to table TRN_RCMS_TRANSREQDTL
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12684000010970
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00463
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00463
trn_rcms_caseregid = 16708000005183
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 1
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010970
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00463
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00463
Param Type = n
trn_rcms_caseregid=16708000005183
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=1
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
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 = 1
RecordId = 12684000010971
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00462
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00462
trn_rcms_caseregid = 16691000005127
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 2
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010971
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00462
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00462
Param Type = n
trn_rcms_caseregid=16691000005127
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=2
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
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 = 2
RecordId = 12684000010972
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00472
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00472
trn_rcms_caseregid = 16943000005068
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 3
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010972
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00472
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00472
Param Type = n
trn_rcms_caseregid=16943000005068
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=3
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
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 = 2
RecordId = 12684000010973
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00471
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00471
trn_rcms_caseregid = 16927000004941
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 4
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010973
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00471
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00471
Param Type = n
trn_rcms_caseregid=16927000004941
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=4
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
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 = 1
RecordId = 12684000010974
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00098
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00098
trn_rcms_caseregid = 18342000003426
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 5
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010974
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00098
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00098
Param Type = n
trn_rcms_caseregid=18342000003426
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=5
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000010975
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00096
fromcourt = 12122000000118
fromccode = 10241
transcourt = 18156000000007
case_no = 2020/00096
trn_rcms_caseregid = 18232000003885
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 6
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010975
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00096
Param Type = n
fromcourt=12122000000118
Param Type = c
fromccode=10241
Param Type = n
transcourt=18156000000007
Param Type = c
case_no=2020/00096
Param Type = n
trn_rcms_caseregid=18232000003885
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=6
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
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 = 2
RecordId = 12684000010976
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00151
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00151
trn_rcms_caseregid = 13764000005192
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 7
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010976
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00151
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00151
Param Type = n
trn_rcms_caseregid=13764000005192
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=7
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
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 = 1
RecordId = 12684000010977
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00497
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00497
trn_rcms_caseregid = 12636000003999
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 8
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010977
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00497
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00497
Param Type = n
trn_rcms_caseregid=12636000003999
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=8
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000010978
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00055
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00055
trn_rcms_caseregid = 13130000003636
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 9
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010978
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00055
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00055
Param Type = n
trn_rcms_caseregid=13130000003636
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=9
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
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 = 1
RecordId = 12684000010979
Select sysdate as sdt from dual
Time elapsed = 1
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00114
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00114
trn_rcms_caseregid = 17052000004190
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 10
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010979
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00114
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00114
Param Type = n
trn_rcms_caseregid=17052000004190
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=10
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
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 = 1
RecordId = 12684000010980
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00136
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00136
trn_rcms_caseregid = 12965000004139
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 11
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010980
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00136
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00136
Param Type = n
trn_rcms_caseregid=12965000004139
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=11
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
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 = 1
RecordId = 12684000010981
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00135
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00135
trn_rcms_caseregid = 12934000004305
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 12
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010981
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00135
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00135
Param Type = n
trn_rcms_caseregid=12934000004305
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=12
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
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 = 1
RecordId = 12684000010982
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00125
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00125
trn_rcms_caseregid = 10369000003289
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 13
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010982
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00125
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00125
Param Type = n
trn_rcms_caseregid=10369000003289
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=13
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000010983
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00560
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00560
trn_rcms_caseregid = 10943000005348
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 14
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010983
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00560
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00560
Param Type = n
trn_rcms_caseregid=10943000005348
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=14
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000010984
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00559
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00559
trn_rcms_caseregid = 10904000005260
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 15
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010984
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00559
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00559
Param Type = n
trn_rcms_caseregid=10904000005260
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=15
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000010985
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00104
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00104
trn_rcms_caseregid = 19282000003362
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 16
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010985
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00104
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00104
Param Type = n
trn_rcms_caseregid=19282000003362
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=16
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000010986
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00018
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00018
trn_rcms_caseregid = 18780000003200
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 17
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010986
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00018
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00018
Param Type = n
trn_rcms_caseregid=18780000003200
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=17
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000010987
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00017
fromcourt = 12122000000118
fromccode = 10241
transcourt = 18156000000007
case_no = 2020/00017
trn_rcms_caseregid = 18713000003726
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 18
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010987
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00017
Param Type = n
fromcourt=12122000000118
Param Type = c
fromccode=10241
Param Type = n
transcourt=18156000000007
Param Type = c
case_no=2020/00017
Param Type = n
trn_rcms_caseregid=18713000003726
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=18
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 1
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000010988
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00142
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00142
trn_rcms_caseregid = 13613000006016
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 19
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010988
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00142
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00142
Param Type = n
trn_rcms_caseregid=13613000006016
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=19
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000010989
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00058
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00058
trn_rcms_caseregid = 14642000003428
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 20
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010989
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00058
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00058
Param Type = n
trn_rcms_caseregid=14642000003428
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=20
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000010990
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00057
fromcourt = 12122000000118
fromccode = 10241
transcourt = 18156000000007
case_no = 2020/00057
trn_rcms_caseregid = 14590000003714
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 21
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010990
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00057
Param Type = n
fromcourt=12122000000118
Param Type = c
fromccode=10241
Param Type = n
transcourt=18156000000007
Param Type = c
case_no=2020/00057
Param Type = n
trn_rcms_caseregid=14590000003714
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=21
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000010991
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00089
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00089
trn_rcms_caseregid = 10605000003409
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 22
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010991
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00089
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00089
Param Type = n
trn_rcms_caseregid=10605000003409
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=22
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000010992
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00088
fromcourt = 12122000000118
fromccode = 10241
transcourt = 18156000000007
case_no = 2020/00088
trn_rcms_caseregid = 10541000004248
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 23
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010992
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00088
Param Type = n
fromcourt=12122000000118
Param Type = c
fromccode=10241
Param Type = n
transcourt=18156000000007
Param Type = c
case_no=2020/00088
Param Type = n
trn_rcms_caseregid=10541000004248
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=23
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000010993
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00087
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00087
trn_rcms_caseregid = 10389000003172
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 24
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010993
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00087
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00087
Param Type = n
trn_rcms_caseregid=10389000003172
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=24
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000010994
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00086
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00086
trn_rcms_caseregid = 10338000004259
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 25
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010994
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00086
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00086
Param Type = n
trn_rcms_caseregid=10338000004259
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=25
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000010995
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00450
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00450
trn_rcms_caseregid = 10773000005282
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 26
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010995
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00450
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00450
Param Type = n
trn_rcms_caseregid=10773000005282
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=26
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000010996
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00449
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00449
trn_rcms_caseregid = 10737000006015
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 27
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010996
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00449
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00449
Param Type = n
trn_rcms_caseregid=10737000006015
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=27
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 28 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000010997
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00537
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00537
trn_rcms_caseregid = 13149000005030
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 28
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010997
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00537
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00537
Param Type = n
trn_rcms_caseregid=13149000005030
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=28
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000010998
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00536
fromcourt = 12122000000118
fromccode = 10241
transcourt = 18156000000007
case_no = 2020/00536
trn_rcms_caseregid = 12910000005073
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 29
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010998
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00536
Param Type = n
fromcourt=12122000000118
Param Type = c
fromccode=10241
Param Type = n
transcourt=18156000000007
Param Type = c
case_no=2020/00536
Param Type = n
trn_rcms_caseregid=12910000005073
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=29
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 30 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000010999
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00160
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00160
trn_rcms_caseregid = 13551000004629
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 30
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000010999
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00160
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00160
Param Type = n
trn_rcms_caseregid=13551000004629
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=30
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 31 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000011000
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00060
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00060
trn_rcms_caseregid = 16440000004534
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 31
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011000
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00060
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00060
Param Type = n
trn_rcms_caseregid=16440000004534
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=31
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 32 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000011001
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00059
fromcourt = 12122000000118
fromccode = 10241
transcourt = 18156000000007
case_no = 2020/00059
trn_rcms_caseregid = 15572000004638
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 32
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011001
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00059
Param Type = n
fromcourt=12122000000118
Param Type = c
fromccode=10241
Param Type = n
transcourt=18156000000007
Param Type = c
case_no=2020/00059
Param Type = n
trn_rcms_caseregid=15572000004638
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=32
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 33 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000011002
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00016
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00016
trn_rcms_caseregid = 16470000003615
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 33
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011002
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00016
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00016
Param Type = n
trn_rcms_caseregid=16470000003615
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=33
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 34 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000011003
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00015
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00015
trn_rcms_caseregid = 16434000004085
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 34
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011003
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00015
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00015
Param Type = n
trn_rcms_caseregid=16434000004085
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=34
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 35 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000011004
Select sysdate as sdt from dual
Time elapsed = 1
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00084
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00084
trn_rcms_caseregid = 10209000004395
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 35
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011004
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00084
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00084
Param Type = n
trn_rcms_caseregid=10209000004395
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=35
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 36 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000011005
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00085
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00085
trn_rcms_caseregid = 10281000003941
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 36
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011005
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00085
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00085
Param Type = n
trn_rcms_caseregid=10281000003941
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=36
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 37 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000011006
Select sysdate as sdt from dual
Time elapsed = 1
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00101
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00101
trn_rcms_caseregid = 19216000004312
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 37
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011006
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00101
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00101
Param Type = n
trn_rcms_caseregid=19216000004312
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=37
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 14
Adding new record to store data from Frame 2, Row 38 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000011007
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00100
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00100
trn_rcms_caseregid = 19206000004188
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 38
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011007
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00100
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00100
Param Type = n
trn_rcms_caseregid=19206000004188
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=38
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 39 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000011008
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00474
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00474
trn_rcms_caseregid = 11448000005756
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 39
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011008
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00474
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00474
Param Type = n
trn_rcms_caseregid=11448000005756
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=39
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 40 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000011009
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00473
fromcourt = 12122000000118
fromccode = 10241
transcourt = 18156000000007
case_no = 2020/00473
trn_rcms_caseregid = 11412000005703
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 40
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011009
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00473
Param Type = n
fromcourt=12122000000118
Param Type = c
fromccode=10241
Param Type = n
transcourt=18156000000007
Param Type = c
case_no=2020/00473
Param Type = n
trn_rcms_caseregid=11412000005703
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=40
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 41 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000011010
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00529
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00529
trn_rcms_caseregid = 15831000005337
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 41
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011010
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00529
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00529
Param Type = n
trn_rcms_caseregid=15831000005337
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=41
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 13
Adding new record to store data from Frame 2, Row 42 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000011011
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00528
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00528
trn_rcms_caseregid = 15789000005264
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 42
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011011
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00528
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00528
Param Type = n
trn_rcms_caseregid=15789000005264
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=42
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 43 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12684000011012
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00162
fromcourt = 12122000000118
fromccode = 10241
transcourt = 18156000000007
case_no = 2020/00162
trn_rcms_caseregid = 19981000004929
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 43
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011012
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00162
Param Type = n
fromcourt=12122000000118
Param Type = c
fromccode=10241
Param Type = n
transcourt=18156000000007
Param Type = c
case_no=2020/00162
Param Type = n
trn_rcms_caseregid=19981000004929
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=43
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 44 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000011013
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00013
fromcourt = 12122000000118
fromccode = 10241
transcourt = 18156000000007
case_no = 2020/00013
trn_rcms_caseregid = 14391000003823
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 44
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011013
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00013
Param Type = n
fromcourt=12122000000118
Param Type = c
fromccode=10241
Param Type = n
transcourt=18156000000007
Param Type = c
case_no=2020/00013
Param Type = n
trn_rcms_caseregid=14391000003823
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=44
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 2
Adding new record to store data from Frame 2, Row 45 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 1
RecordId = 12684000011014
Select sysdate as sdt from dual
Time elapsed = 2
decision_date = 01/01/2026
status = 0
transContFld = F
requestno = 10241-10689#2020/00012
transcourt = 18156000000007
fromccode = 10241
fromcourt = 12122000000118
case_no = 2020/00012
trn_rcms_caseregid = 14320000003926
transccode = 10689
TRN_RCMS_TRANSREQDTLrow = 45
Posting record
Param Type = n
trn_rcms_transreqdtlid=12684000011014
Param Type = n
trn_rcms_transreqid=12684000010969
Param Type = c
decision_date=01/01/2026 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=F
Param Type = c
requestno=10241-10689#2020/00012
Param Type = n
transcourt=18156000000007
Param Type = c
fromccode=10241
Param Type = n
fromcourt=12122000000118
Param Type = c
case_no=2020/00012
Param Type = n
trn_rcms_caseregid=14320000003926
Param Type = c
transccode=10689
Param Type = n
trn_rcms_transreqdtlrow=45
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
Time elapsed for insert/update = 3976790071742
>>Executing genmaps
>>Posting from rctcr to tscd from row 1
>>Posting from rctcr to tscd from row 2
>>Posting from rctcr to tscd from row 3
>>Posting from rctcr to tscd from row 4
>>Posting from rctcr to tscd from row 5
>>Posting from rctcr to tscd from row 6
>>Posting from rctcr to tscd from row 7
>>Posting from rctcr to tscd from row 8
>>Posting from rctcr to tscd from row 9
>>Posting from rctcr to tscd from row 10
>>Posting from rctcr to tscd from row 11
>>Posting from rctcr to tscd from row 12
>>Posting from rctcr to tscd from row 13
>>Posting from rctcr to tscd from row 14
>>Posting from rctcr to tscd from row 15
>>Posting from rctcr to tscd from row 16
>>Posting from rctcr to tscd from row 17
>>Posting from rctcr to tscd from row 18
>>Posting from rctcr to tscd from row 19
>>Posting from rctcr to tscd from row 20
>>Posting from rctcr to tscd from row 21
>>Posting from rctcr to tscd from row 22
>>Posting from rctcr to tscd from row 23
>>Posting from rctcr to tscd from row 24
>>Posting from rctcr to tscd from row 25
>>Posting from rctcr to tscd from row 26
>>Posting from rctcr to tscd from row 27
>>Posting from rctcr to tscd from row 28
>>Posting from rctcr to tscd from row 29
>>Posting from rctcr to tscd from row 30
>>Posting from rctcr to tscd from row 31
>>Posting from rctcr to tscd from row 32
>>Posting from rctcr to tscd from row 33
>>Posting from rctcr to tscd from row 34
>>Posting from rctcr to tscd from row 35
>>Posting from rctcr to tscd from row 36
>>Posting from rctcr to tscd from row 37
>>Posting from rctcr to tscd from row 38
>>Posting from rctcr to tscd from row 39
>>Posting from rctcr to tscd from row 40
>>Posting from rctcr to tscd from row 41
>>Posting from rctcr to tscd from row 42
>>Posting from rctcr to tscd from row 43
>>Posting from rctcr to tscd from row 44
>>Posting from rctcr to tscd from row 45
Time elapsed for Gen Map = 3976790071756
Time elapsed for MD Map = 3976790071756
Time elapsed for Save History = 3976790071756
Time elapsed for Save Attachment = 3976790071756
Time elapsed for After Save WF Exec = 3976790071760
Transaction commited
Result : {"message":[{"msg":"Request for Case Transfer Saved","recordid":"12684000010969"}]}
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=SDO_Girva_PRO
Param Type = c
calledon=05/01/2026 15:54:30
Param Type = c
callfinished=05/01/2026 15:54:31
Param Type = c
structname=rctcr
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=success
Param Type = n
timetaken=1560
Param Type = n
dbtimetaken=948
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