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
gcmsDM_Anupghar_R827ccb0eea8a706c4c34a16891f84e7b![]()
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=DM_Anupghar_R
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=DM_Anupghar_R
Time elapsed = 32
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=DM_Anupghar_R
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=DM_Anupghar_R
Time elapsed = 34
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = DM
Result = DM
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=DM_Anupghar_R
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=DM_Anupghar_R
Time elapsed = 38
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 1395770007168
Result = 1395770007168
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=DM_Anupghar_R
Time elapsed = 42
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1636010008335
Result = 1636010008335
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=DM_Anupghar_R
Time elapsed = 52
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = DM_Anupghar_R
Result = DM_Anupghar_R
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=DM_Anupghar_R
Time elapsed = 47
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 18175
Result = 18175
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 = 24
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=DM_Anupghar_R
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=DM_Anupghar_R
Time elapsed = 44
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Anoopgarh
Result = Anoopgarh
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=DM_Anupghar_R
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=DM_Anupghar_R
Time elapsed = 27
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=1636010008335
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1636010008335
Time elapsed = 24
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=DM_Anupghar_R
Time elapsed = 27
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10206000000014
Result = 10206000000014
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=DM_Anupghar_R
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=DM_Anupghar_R
Time elapsed = 31
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_reader
Result = court_reader
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 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=DM_Anupghar_R
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=DM_Anupghar_R
Time elapsed = 58
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 2
Result = 2
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_reader') and lower(sname)='rctcr' and stype = 't' )
Time elapsed = 16
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='rctcr' and stype = 't'
Time elapsed = 20
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_reader,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 = 15
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 = 14
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 = 47
select * from trn_rcms_transreq where trn_rcms_transreqid=0
Time elapsed = 39
select * from Axusers where 1=2
Time elapsed = 20
select distinct(fldname) from AxTempUserFields
Time elapsed = 17
select * from AxAttachWorkflow where lower(transid) = 'rctcr'
Time elapsed = 18
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 = 17
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 = 28
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tscd
adxinout=o
Time elapsed = 35
select * from trn_rcms_decision where trn_rcms_decisionid=0
Time elapsed = 20
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 = 16
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 = 35
select * from trn_rcms_hearing where trn_rcms_hearingid=0
Time elapsed = 14
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 = 19
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 = 50
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 19
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 = 18
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 = 40
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 18
select distinct(schemaname) from axschema where lower(transid)='tscrg'
Time elapsed = 13
select trn_rcms_caseregid from trn_rcms_casereg where trn_rcms_caseregid=0
Time elapsed = 16
select case_decision_date from trn_rcms_casereg where trn_rcms_caseregid=0
Time elapsed = 16
select distinct(schemaname) from axschema where lower(transid)='tscrg'
Time elapsed = 18
select decision_type from trn_rcms_casereg where trn_rcms_caseregid=0
Time elapsed = 14
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 = 21/04/2025
currdate after validation = 21/04/2025
court_code = 18175
trans_ccode = 10437
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 = 25
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 = 26
dec_type after validation = ????????? Id = 11782000000706
time zone difference = 0
>>Writing to tables rctcr
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rctcr'
Time elapsed = 16
Saving to table TRN_RCMS_TRANSREQ
select * from TRN_RCMS_TRANSREQ where TRN_RCMS_TRANSREQid=0
Time elapsed = 30
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 = 24
RecordId = 16670000010725
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 20
Select sysdate as sdt from dual
Time elapsed = 27
trans_ccode = 10437
court_code = 18175
Posting record
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_Anupghar_R
Param Type = c
createdon=21/04/2025 12:04:53
Param Type = c
username=DM_Anupghar_R
Param Type = c
modifiedon=21/04/2025 12:04:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_ccode=10437
Param Type = c
court_code=18175
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 = 15
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 = 22
RecordId = 16670000010726
Select sysdate as sdt from dual
Time elapsed = 16
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/468
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/468
trn_rcms_caseregid = 11807000007938
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 1
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010726
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/468
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/468
Param Type = n
trn_rcms_caseregid=11807000007938
Param Type = c
transccode=10437
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 = 43
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 = 16670000010727
Select sysdate as sdt from dual
Time elapsed = 17
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/470
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/470
trn_rcms_caseregid = 12292000009113
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 2
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010727
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/470
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/470
Param Type = n
trn_rcms_caseregid=12292000009113
Param Type = c
transccode=10437
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 = 20
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 = 18
RecordId = 16670000010728
Select sysdate as sdt from dual
Time elapsed = 18
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/420
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/420
trn_rcms_caseregid = 12330000008273
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 3
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010728
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/420
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/420
Param Type = n
trn_rcms_caseregid=12330000008273
Param Type = c
transccode=10437
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 = 13
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 = 13
RecordId = 16670000010729
Select sysdate as sdt from dual
Time elapsed = 15
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/472
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/472
trn_rcms_caseregid = 12663000008241
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 4
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010729
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/472
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/472
Param Type = n
trn_rcms_caseregid=12663000008241
Param Type = c
transccode=10437
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 = 32
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 = 14
RecordId = 16670000010730
Select sysdate as sdt from dual
Time elapsed = 19
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/426
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/426
trn_rcms_caseregid = 12973000007874
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 5
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010730
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/426
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/426
Param Type = n
trn_rcms_caseregid=12973000007874
Param Type = c
transccode=10437
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 = 20
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 = 19
RecordId = 16670000010731
Select sysdate as sdt from dual
Time elapsed = 17
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/481
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/481
trn_rcms_caseregid = 13382000007635
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 6
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010731
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/481
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/481
Param Type = n
trn_rcms_caseregid=13382000007635
Param Type = c
transccode=10437
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 = 15
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 = 20
RecordId = 16670000010732
Select sysdate as sdt from dual
Time elapsed = 15
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/484
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/484
trn_rcms_caseregid = 13535000009132
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 7
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010732
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/484
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/484
Param Type = n
trn_rcms_caseregid=13535000009132
Param Type = c
transccode=10437
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 = 26
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 = 18
RecordId = 16670000010733
Select sysdate as sdt from dual
Time elapsed = 21
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/489
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/489
trn_rcms_caseregid = 13758000008975
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 8
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010733
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/489
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/489
Param Type = n
trn_rcms_caseregid=13758000008975
Param Type = c
transccode=10437
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 = 17
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 = 28
RecordId = 16670000010734
Select sysdate as sdt from dual
Time elapsed = 21
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/320
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/320
trn_rcms_caseregid = 13795000007917
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 9
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010734
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/320
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/320
Param Type = n
trn_rcms_caseregid=13795000007917
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=9
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 = 23
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 = 14
RecordId = 16670000010735
Select sysdate as sdt from dual
Time elapsed = 17
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/491
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/491
trn_rcms_caseregid = 13818000007584
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 10
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010735
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/491
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/491
Param Type = n
trn_rcms_caseregid=13818000007584
Param Type = c
transccode=10437
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 = 17
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 = 14
RecordId = 16670000010736
Select sysdate as sdt from dual
Time elapsed = 14
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/492
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/492
trn_rcms_caseregid = 13855000007623
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 11
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010736
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/492
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/492
Param Type = n
trn_rcms_caseregid=13855000007623
Param Type = c
transccode=10437
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 = 18
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 = 17
RecordId = 16670000010737
Select sysdate as sdt from dual
Time elapsed = 18
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/494
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/494
trn_rcms_caseregid = 13928000007988
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 12
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010737
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/494
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/494
Param Type = n
trn_rcms_caseregid=13928000007988
Param Type = c
transccode=10437
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 = 32
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 = 17
RecordId = 16670000010738
Select sysdate as sdt from dual
Time elapsed = 23
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/332
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/332
trn_rcms_caseregid = 15730000007972
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 13
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010738
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/332
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/332
Param Type = n
trn_rcms_caseregid=15730000007972
Param Type = c
transccode=10437
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 = 15
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 = 15
RecordId = 16670000010739
Select sysdate as sdt from dual
Time elapsed = 16
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/381
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/381
trn_rcms_caseregid = 16415000007925
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 14
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010739
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/381
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/381
Param Type = n
trn_rcms_caseregid=16415000007925
Param Type = c
transccode=10437
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 = 23
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 = 18
RecordId = 16670000010740
Select sysdate as sdt from dual
Time elapsed = 16
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/379
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/379
trn_rcms_caseregid = 16362000007652
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 15
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010740
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/379
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/379
Param Type = n
trn_rcms_caseregid=16362000007652
Param Type = c
transccode=10437
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 = 14
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 = 13
RecordId = 16670000010741
Select sysdate as sdt from dual
Time elapsed = 15
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/459
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/459
trn_rcms_caseregid = 11082000007964
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 16
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010741
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/459
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/459
Param Type = n
trn_rcms_caseregid=11082000007964
Param Type = c
transccode=10437
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 = 13
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 = 20
RecordId = 16670000010742
Select sysdate as sdt from dual
Time elapsed = 20
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/138
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/138
trn_rcms_caseregid = 11539000008312
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 17
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010742
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/138
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/138
Param Type = n
trn_rcms_caseregid=11539000008312
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=17
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 = 26
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 = 24
RecordId = 16670000010743
Select sysdate as sdt from dual
Time elapsed = 26
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/502
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/502
trn_rcms_caseregid = 14184000007321
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 18
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010743
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/502
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/502
Param Type = n
trn_rcms_caseregid=14184000007321
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=18
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 = 37
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 = 25
RecordId = 16670000010744
Select sysdate as sdt from dual
Time elapsed = 15
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/384
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/384
trn_rcms_caseregid = 16618000007040
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 19
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010744
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/384
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/384
Param Type = n
trn_rcms_caseregid=16618000007040
Param Type = c
transccode=10437
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 = 15
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 = 13
RecordId = 16670000010745
Select sysdate as sdt from dual
Time elapsed = 22
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/463
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/463
trn_rcms_caseregid = 11398000007407
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 20
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010745
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/463
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/463
Param Type = n
trn_rcms_caseregid=11398000007407
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=20
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 = 20
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 = 16
RecordId = 16670000010746
Select sysdate as sdt from dual
Time elapsed = 29
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/423
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/423
trn_rcms_caseregid = 12862000008801
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 21
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010746
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/423
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/423
Param Type = n
trn_rcms_caseregid=12862000008801
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=21
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 = 17
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 = 15
RecordId = 16670000010747
Select sysdate as sdt from dual
Time elapsed = 16
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/325
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/325
trn_rcms_caseregid = 13978000008819
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 22
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010747
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/325
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/325
Param Type = n
trn_rcms_caseregid=13978000008819
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=22
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 = 16
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 = 12
RecordId = 16670000010748
Select sysdate as sdt from dual
Time elapsed = 17
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/380
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/380
trn_rcms_caseregid = 16387000008109
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 23
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010748
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/380
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/380
Param Type = n
trn_rcms_caseregid=16387000008109
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=23
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 = 24
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 = 7
RecordId = 16670000010749
Select sysdate as sdt from dual
Time elapsed = 24
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/219
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2024/219
trn_rcms_caseregid = 19363000010022
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 24
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010749
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/219
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2024/219
Param Type = n
trn_rcms_caseregid=19363000010022
Param Type = c
transccode=10437
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 = 25
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 = 27
RecordId = 16670000010750
Select sysdate as sdt from dual
Time elapsed = 34
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/220
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2024/220
trn_rcms_caseregid = 19497000009904
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 25
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010750
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/220
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2024/220
Param Type = n
trn_rcms_caseregid=19497000009904
Param Type = c
transccode=10437
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 = 13
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 = 21
RecordId = 16670000010751
Select sysdate as sdt from dual
Time elapsed = 18
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/221
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2024/221
trn_rcms_caseregid = 19577000008664
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 26
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010751
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/221
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2024/221
Param Type = n
trn_rcms_caseregid=19577000008664
Param Type = c
transccode=10437
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 = 12
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 = 16
RecordId = 16670000010752
Select sysdate as sdt from dual
Time elapsed = 22
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/222
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2024/222
trn_rcms_caseregid = 19629000010161
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 27
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010752
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/222
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2024/222
Param Type = n
trn_rcms_caseregid=19629000010161
Param Type = c
transccode=10437
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 = 11
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 = 29
RecordId = 16670000010753
Select sysdate as sdt from dual
Time elapsed = 17
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/172
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2024/172
trn_rcms_caseregid = 19928000008947
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 28
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010753
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/172
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2024/172
Param Type = n
trn_rcms_caseregid=19928000008947
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=28
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 = 15
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 = 18
RecordId = 16670000010754
Select sysdate as sdt from dual
Time elapsed = 27
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/105
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2024/105
trn_rcms_caseregid = 10017000009318
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 29
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010754
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/105
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2024/105
Param Type = n
trn_rcms_caseregid=10017000009318
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=29
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 = 25
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 = 37
RecordId = 16670000010755
Select sysdate as sdt from dual
Time elapsed = 22
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/106
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2024/106
trn_rcms_caseregid = 10151000008412
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 30
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010755
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/106
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2024/106
Param Type = n
trn_rcms_caseregid=10151000008412
Param Type = c
transccode=10437
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 = 18
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 = 21
RecordId = 16670000010756
Select sysdate as sdt from dual
Time elapsed = 28
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/107
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2024/107
trn_rcms_caseregid = 10374000010498
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 31
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010756
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/107
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2024/107
Param Type = n
trn_rcms_caseregid=10374000010498
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=31
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 = 17
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 = 53
RecordId = 16670000010757
Select sysdate as sdt from dual
Time elapsed = 18
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/488
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/488
trn_rcms_caseregid = 13720000008524
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 32
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010757
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/488
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/488
Param Type = n
trn_rcms_caseregid=13720000008524
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=32
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 = 24
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 = 17
RecordId = 16670000010758
Select sysdate as sdt from dual
Time elapsed = 22
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/138
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2024/138
trn_rcms_caseregid = 16273000008796
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 33
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010758
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/138
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2024/138
Param Type = n
trn_rcms_caseregid=16273000008796
Param Type = c
transccode=10437
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 = 16
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 = 16
RecordId = 16670000010759
Select sysdate as sdt from dual
Time elapsed = 14
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/98
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2024/98
trn_rcms_caseregid = 17610000009085
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 34
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010759
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/98
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2024/98
Param Type = n
trn_rcms_caseregid=17610000009085
Param Type = c
transccode=10437
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 = 13
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 = 25
RecordId = 16670000010760
Select sysdate as sdt from dual
Time elapsed = 15
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/100
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2024/100
trn_rcms_caseregid = 17949000008607
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 35
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010760
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/100
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2024/100
Param Type = n
trn_rcms_caseregid=17949000008607
Param Type = c
transccode=10437
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 = 17
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 = 16
RecordId = 16670000010761
Select sysdate as sdt from dual
Time elapsed = 22
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/103
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2024/103
trn_rcms_caseregid = 19286000010352
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 36
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010761
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/103
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2024/103
Param Type = n
trn_rcms_caseregid=19286000010352
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=36
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 = 17
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 = 20
RecordId = 16670000010762
Select sysdate as sdt from dual
Time elapsed = 20
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/104
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2024/104
trn_rcms_caseregid = 19443000008964
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 37
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010762
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/104
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2024/104
Param Type = n
trn_rcms_caseregid=19443000008964
Param Type = c
transccode=10437
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 = 18
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 = 21
RecordId = 16670000010763
Select sysdate as sdt from dual
Time elapsed = 30
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/162
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2024/162
trn_rcms_caseregid = 19770000009682
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 38
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010763
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/162
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2024/162
Param Type = n
trn_rcms_caseregid=19770000009682
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=38
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 = 20
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 = 21
RecordId = 16670000010764
Select sysdate as sdt from dual
Time elapsed = 15
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/220
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/220
trn_rcms_caseregid = 19261000008667
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 39
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010764
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/220
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/220
Param Type = n
trn_rcms_caseregid=19261000008667
Param Type = c
transccode=10437
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 = 42
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 = 32
RecordId = 16670000010765
Select sysdate as sdt from dual
Time elapsed = 61
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/461
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/461
trn_rcms_caseregid = 11244000008639
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 40
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010765
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/461
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/461
Param Type = n
trn_rcms_caseregid=11244000008639
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=40
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 = 30
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 = 29
RecordId = 16670000010766
Select sysdate as sdt from dual
Time elapsed = 28
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/479
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/479
trn_rcms_caseregid = 13260000007072
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 41
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010766
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/479
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/479
Param Type = n
trn_rcms_caseregid=13260000007072
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=41
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 = 38
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 = 28
RecordId = 16670000010767
Select sysdate as sdt from dual
Time elapsed = 41
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/94
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2024/94
trn_rcms_caseregid = 13888000008129
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 42
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010767
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/94
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2024/94
Param Type = n
trn_rcms_caseregid=13888000008129
Param Type = c
transccode=10437
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 = 21
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 = 30
RecordId = 16670000010768
Select sysdate as sdt from dual
Time elapsed = 19
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/76
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/76
trn_rcms_caseregid = 14007000008018
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 43
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010768
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/76
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/76
Param Type = n
trn_rcms_caseregid=14007000008018
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=43
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 = 43
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 = 9
RecordId = 16670000010769
Select sysdate as sdt from dual
Time elapsed = 32
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/329
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/329
trn_rcms_caseregid = 14409000007224
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 44
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010769
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/329
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/329
Param Type = n
trn_rcms_caseregid=14409000007224
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=44
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 = 16
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 = 19
RecordId = 16670000010770
Select sysdate as sdt from dual
Time elapsed = 40
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/205
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2024/205
trn_rcms_caseregid = 15764000008147
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 45
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010770
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/205
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2024/205
Param Type = n
trn_rcms_caseregid=15764000008147
Param Type = c
transccode=10437
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)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 18
Adding new record to store data from Frame 2, Row 46 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 21
RecordId = 16670000010771
Select sysdate as sdt from dual
Time elapsed = 17
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/218
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2024/218
trn_rcms_caseregid = 17426000008735
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 46
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010771
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/218
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2024/218
Param Type = n
trn_rcms_caseregid=17426000008735
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=46
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 47 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 14
RecordId = 16670000010772
Select sysdate as sdt from dual
Time elapsed = 17
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/78
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/78
trn_rcms_caseregid = 14131000007074
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 47
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010772
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/78
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/78
Param Type = n
trn_rcms_caseregid=14131000007074
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=47
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 = 18
Adding new record to store data from Frame 2, Row 48 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 19
RecordId = 16670000010773
Select sysdate as sdt from dual
Time elapsed = 19
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/321
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/321
trn_rcms_caseregid = 13847000007740
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 48
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010773
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/321
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/321
Param Type = n
trn_rcms_caseregid=13847000007740
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=48
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 = 38
Adding new record to store data from Frame 2, Row 49 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 20
RecordId = 16670000010774
Select sysdate as sdt from dual
Time elapsed = 35
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/322
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/322
trn_rcms_caseregid = 13864000008903
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 49
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010774
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/322
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/322
Param Type = n
trn_rcms_caseregid=13864000008903
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=49
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 = 20
Adding new record to store data from Frame 2, Row 50 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 16
RecordId = 16670000010775
Select sysdate as sdt from dual
Time elapsed = 12
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/503
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/503
trn_rcms_caseregid = 14259000008162
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 50
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010775
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/503
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/503
Param Type = n
trn_rcms_caseregid=14259000008162
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=50
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 = 16
Adding new record to store data from Frame 2, Row 51 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 24
RecordId = 16670000010776
Select sysdate as sdt from dual
Time elapsed = 18
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/376
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/376
trn_rcms_caseregid = 15967000007553
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 51
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010776
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/376
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/376
Param Type = n
trn_rcms_caseregid=15967000007553
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=51
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 = 15
Adding new record to store data from Frame 2, Row 52 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 15
RecordId = 16670000010777
Select sysdate as sdt from dual
Time elapsed = 17
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/377
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/377
trn_rcms_caseregid = 15992000008394
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 52
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010777
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/377
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/377
Param Type = n
trn_rcms_caseregid=15992000008394
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=52
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 = 16
Adding new record to store data from Frame 2, Row 53 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 14
RecordId = 16670000010778
Select sysdate as sdt from dual
Time elapsed = 15
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/104
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/104
trn_rcms_caseregid = 17727000008013
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 53
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010778
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/104
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/104
Param Type = n
trn_rcms_caseregid=17727000008013
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=53
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 = 20
Adding new record to store data from Frame 2, Row 54 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 16
RecordId = 16670000010779
Select sysdate as sdt from dual
Time elapsed = 24
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/443
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/443
trn_rcms_caseregid = 18716000008297
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 54
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010779
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/443
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/443
Param Type = n
trn_rcms_caseregid=18716000008297
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=54
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 = 16
Adding new record to store data from Frame 2, Row 55 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 14
RecordId = 16670000010780
Select sysdate as sdt from dual
Time elapsed = 18
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/444
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/444
trn_rcms_caseregid = 18742000008577
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 55
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010780
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/444
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/444
Param Type = n
trn_rcms_caseregid=18742000008577
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=55
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 = 19
Adding new record to store data from Frame 2, Row 56 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 18
RecordId = 16670000010781
Select sysdate as sdt from dual
Time elapsed = 14
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/125
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2024/125
trn_rcms_caseregid = 15765000009445
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 56
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010781
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/125
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2024/125
Param Type = n
trn_rcms_caseregid=15765000009445
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=56
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 = 30
Adding new record to store data from Frame 2, Row 57 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 24
RecordId = 16670000010782
Select sysdate as sdt from dual
Time elapsed = 34
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/467
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/467
trn_rcms_caseregid = 11764000008048
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 57
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010782
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/467
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/467
Param Type = n
trn_rcms_caseregid=11764000008048
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=57
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 = 19
Adding new record to store data from Frame 2, Row 58 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 17
RecordId = 16670000010783
Select sysdate as sdt from dual
Time elapsed = 18
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/469
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/469
trn_rcms_caseregid = 11922000009263
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 58
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010783
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/469
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/469
Param Type = n
trn_rcms_caseregid=11922000009263
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=58
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 = 17
Adding new record to store data from Frame 2, Row 59 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 23
RecordId = 16670000010784
Select sysdate as sdt from dual
Time elapsed = 7
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/471
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/471
trn_rcms_caseregid = 12532000008347
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 59
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010784
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/471
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/471
Param Type = n
trn_rcms_caseregid=12532000008347
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=59
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 = 16
Adding new record to store data from Frame 2, Row 60 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 19
RecordId = 16670000010785
Select sysdate as sdt from dual
Time elapsed = 18
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/328
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/328
trn_rcms_caseregid = 14334000008290
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 60
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010785
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/328
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/328
Param Type = n
trn_rcms_caseregid=14334000008290
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=60
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 = 19
Adding new record to store data from Frame 2, Row 61 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 15
RecordId = 16670000010786
Select sysdate as sdt from dual
Time elapsed = 17
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/330
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/330
trn_rcms_caseregid = 14428000007140
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 61
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010786
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/330
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/330
Param Type = n
trn_rcms_caseregid=14428000007140
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=61
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 = 16
Adding new record to store data from Frame 2, Row 62 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 15
RecordId = 16670000010787
Select sysdate as sdt from dual
Time elapsed = 16
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/435
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/435
trn_rcms_caseregid = 18037000009712
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 62
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010787
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/435
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/435
Param Type = n
trn_rcms_caseregid=18037000009712
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=62
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 = 19
Adding new record to store data from Frame 2, Row 63 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 19
RecordId = 16670000010788
Select sysdate as sdt from dual
Time elapsed = 23
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/439
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/439
trn_rcms_caseregid = 18219000008419
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 63
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010788
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/439
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/439
Param Type = n
trn_rcms_caseregid=18219000008419
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=63
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 = 20
Adding new record to store data from Frame 2, Row 64 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 15
RecordId = 16670000010789
Select sysdate as sdt from dual
Time elapsed = 32
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/447
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/447
trn_rcms_caseregid = 19008000007966
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 64
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010789
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/447
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/447
Param Type = n
trn_rcms_caseregid=19008000007966
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=64
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 = 16
Adding new record to store data from Frame 2, Row 65 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 16
RecordId = 16670000010790
Select sysdate as sdt from dual
Time elapsed = 18
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/132
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/132
trn_rcms_caseregid = 11205000008603
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 65
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010790
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/132
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/132
Param Type = n
trn_rcms_caseregid=11205000008603
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=65
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 = 28
Adding new record to store data from Frame 2, Row 66 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 16
RecordId = 16670000010791
Select sysdate as sdt from dual
Time elapsed = 45
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/466
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/466
trn_rcms_caseregid = 11641000008027
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 66
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010791
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/466
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/466
Param Type = n
trn_rcms_caseregid=11641000008027
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=66
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 = 20
Adding new record to store data from Frame 2, Row 67 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 18
RecordId = 16670000010792
Select sysdate as sdt from dual
Time elapsed = 28
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/478
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/478
trn_rcms_caseregid = 13209000008966
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 67
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010792
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/478
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/478
Param Type = n
trn_rcms_caseregid=13209000008966
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=67
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 = 29
Adding new record to store data from Frame 2, Row 68 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 18
RecordId = 16670000010793
Select sysdate as sdt from dual
Time elapsed = 17
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/74
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/74
trn_rcms_caseregid = 13816000007501
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 68
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010793
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/74
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/74
Param Type = n
trn_rcms_caseregid=13816000007501
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=68
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 = 29
Adding new record to store data from Frame 2, Row 69 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 13
RecordId = 16670000010794
Select sysdate as sdt from dual
Time elapsed = 19
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/81
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/81
trn_rcms_caseregid = 14353000007884
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 69
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010794
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/81
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/81
Param Type = n
trn_rcms_caseregid=14353000007884
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=69
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 = 16
Adding new record to store data from Frame 2, Row 70 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 15
RecordId = 16670000010795
Select sysdate as sdt from dual
Time elapsed = 13
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/378
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/378
trn_rcms_caseregid = 16297000008342
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 70
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010795
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/378
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/378
Param Type = n
trn_rcms_caseregid=16297000008342
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=70
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 = 18
Adding new record to store data from Frame 2, Row 71 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 21
RecordId = 16670000010796
Select sysdate as sdt from dual
Time elapsed = 26
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/528
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/528
trn_rcms_caseregid = 17620000007654
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 71
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010796
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/528
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/528
Param Type = n
trn_rcms_caseregid=17620000007654
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=71
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 = 25
Adding new record to store data from Frame 2, Row 72 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 28
RecordId = 16670000010797
Select sysdate as sdt from dual
Time elapsed = 32
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/428
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/428
trn_rcms_caseregid = 13114000007578
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 72
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010797
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/428
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/428
Param Type = n
trn_rcms_caseregid=13114000007578
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=72
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 = 19
Adding new record to store data from Frame 2, Row 73 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 22
RecordId = 16670000010798
Select sysdate as sdt from dual
Time elapsed = 20
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/429
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/429
trn_rcms_caseregid = 13204000007018
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 73
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010798
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/429
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/429
Param Type = n
trn_rcms_caseregid=13204000007018
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=73
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 = 19
Adding new record to store data from Frame 2, Row 74 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 22
RecordId = 16670000010799
Select sysdate as sdt from dual
Time elapsed = 19
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/483
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/483
trn_rcms_caseregid = 13499000008698
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 74
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010799
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/483
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/483
Param Type = n
trn_rcms_caseregid=13499000008698
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=74
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 = 15
Adding new record to store data from Frame 2, Row 75 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 13
RecordId = 16670000010800
Select sysdate as sdt from dual
Time elapsed = 26
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/500
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/500
trn_rcms_caseregid = 14131000007105
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 75
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010800
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/500
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/500
Param Type = n
trn_rcms_caseregid=14131000007105
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=75
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 = 36
Adding new record to store data from Frame 2, Row 76 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 15
RecordId = 16670000010801
Select sysdate as sdt from dual
Time elapsed = 17
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/4
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/4
trn_rcms_caseregid = 12322000008735
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 76
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010801
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/4
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/4
Param Type = n
trn_rcms_caseregid=12322000008735
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=76
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 = 17
Adding new record to store data from Frame 2, Row 77 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 13
RecordId = 16670000010802
Select sysdate as sdt from dual
Time elapsed = 14
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/319
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/319
trn_rcms_caseregid = 13740000008588
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 77
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010802
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/319
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/319
Param Type = n
trn_rcms_caseregid=13740000008588
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=77
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 = 14
Adding new record to store data from Frame 2, Row 78 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 14
RecordId = 16670000010803
Select sysdate as sdt from dual
Time elapsed = 15
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/130
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/130
trn_rcms_caseregid = 10966000006726
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 78
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010803
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/130
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/130
Param Type = n
trn_rcms_caseregid=10966000006726
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=78
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 = 17
Adding new record to store data from Frame 2, Row 79 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 20
RecordId = 16670000010804
Select sysdate as sdt from dual
Time elapsed = 24
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2024/86
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2024/86
trn_rcms_caseregid = 14099000008151
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 79
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010804
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2024/86
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2024/86
Param Type = n
trn_rcms_caseregid=14099000008151
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=79
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 = 15
Adding new record to store data from Frame 2, Row 80 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 15
RecordId = 16670000010805
Select sysdate as sdt from dual
Time elapsed = 21
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/445
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/445
trn_rcms_caseregid = 18792000008184
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 80
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010805
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/445
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/445
Param Type = n
trn_rcms_caseregid=18792000008184
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=80
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 = 17
Adding new record to store data from Frame 2, Row 81 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 19
RecordId = 16670000010806
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/446
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/446
trn_rcms_caseregid = 18833000008352
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 81
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010806
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/446
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/446
Param Type = n
trn_rcms_caseregid=18833000008352
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=81
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 = 16
Adding new record to store data from Frame 2, Row 82 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 14
RecordId = 16670000010807
Select sysdate as sdt from dual
Time elapsed = 15
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/441
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/441
trn_rcms_caseregid = 18635000008748
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 82
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010807
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/441
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/441
Param Type = n
trn_rcms_caseregid=18635000008748
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=82
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 = 22
Adding new record to store data from Frame 2, Row 83 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 17
RecordId = 16670000010808
Select sysdate as sdt from dual
Time elapsed = 18
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/128
fromcourt = 1395770007168
fromccode = 18175
transcourt = 13794000000036
case_no = 2023/128
trn_rcms_caseregid = 10844000008327
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 83
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010808
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/128
Param Type = n
fromcourt=1395770007168
Param Type = c
fromccode=18175
Param Type = n
transcourt=13794000000036
Param Type = c
case_no=2023/128
Param Type = n
trn_rcms_caseregid=10844000008327
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=83
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 = 18
Adding new record to store data from Frame 2, Row 84 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 29
RecordId = 16670000010809
Select sysdate as sdt from dual
Time elapsed = 44
decision_date = 30/12/2024
status = 0
transContFld = T
requestno = 18175-10437#2023/135
transcourt = 13794000000036
fromccode = 18175
fromcourt = 1395770007168
case_no = 2023/135
trn_rcms_caseregid = 11392000007297
transccode = 10437
TRN_RCMS_TRANSREQDTLrow = 84
Posting record
Param Type = n
trn_rcms_transreqdtlid=16670000010809
Param Type = n
trn_rcms_transreqid=16670000010725
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18175-10437#2023/135
Param Type = n
transcourt=13794000000036
Param Type = c
fromccode=18175
Param Type = n
fromcourt=1395770007168
Param Type = c
case_no=2023/135
Param Type = n
trn_rcms_caseregid=11392000007297
Param Type = c
transccode=10437
Param Type = n
trn_rcms_transreqdtlrow=84
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 = 3954398748145
>>Executing genmaps
>>Posting from rctcr to tscd from row 1
>>Mapping
Mapped court_code Row = 1 value = 18175 idvalue 0
Mapped case_no Row = 1 value = 2023/468 idvalue 0
Mapped new_case_purpose Row = 1 value = ????????? idvalue 1025550004746
Mapped decision_type Row = 1 value = ????????? idvalue 11782000000706
Mapped decision_date Row = 1 value = 30/12/2024 idvalue 0
Mapped hearing_date Row = 1 value = 30/12/2024 idvalue 0
Mapped pagesource Row = 1 value = TRANSPAGE idvalue 0
>>Validating tscd
>>Frame No 1
currdate =
Evaluating - date()
Result of date = 21/04/2025
currdate after validation = 21/04/2025
court_name =
username=DM_Anupghar_R
select court_name_mastid,court_name,court_code from v_axcourts where paxusername=:username
username=DM_Anupghar_R
Time elapsed = 34
Evaluating - m_courtname
m_courtname = ???? ???????,??????
court_name after validation = ???? ???????,?????? Id = 1395770007168
court_code = 18175
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
viewfilter =
Evaluating - {AND a1.court_code=:m_courtcode }
viewfilter after validation = AND a1.court_code=:m_courtcode
case_no = 2023/468
casedetails =
court_code=18175
case_no=2023/468
recordid=0
SELECT A1.COURT_CODE,
A1.TRN_RCMS_CASEREGID,
A1.INSTITUTION_DATE,
A1.CASE_NO,
A1.MCASE_NO,
A1.LAST_HEARING_DATE AS hearing_date,
B2.DISTRICT_NAME,
B3.CASE_TYPE,
B1.CASE_PURPOSE_NAME,
A1.CASE_PURPOSE_NAME AS CPID,
B4.ACT_NAME,
A1.SECTION_NAME,
A1.PRIMARY_APPELLANT AS APPELLANT_NAME,
A1.PRIMARY_RESPONDENT AS RESPONDENT_NAME
FROM trn_rcms_casereg a1,
case_purpose_mast b1,
district_mast b2,
case_type_mast b3,
rule_act_mast b4
WHERE A1.CASE_PURPOSE_NAME = B1.CASE_PURPOSE_MASTID
AND A1.DISTRICT_NAME = B2.DISTRICT_MASTID
AND A1.ACT_NAME = B4.RULE_ACT_MASTID
AND A1.CASE_TYPE = B3.CASE_TYPE_MASTID
AND A1.COURT_CODE = :court_code
AND a1.CASE_NO = :case_no
AND (CASE
WHEN :recordid > 0
THEN
1
WHEN :recordid = 0
AND b1.CASE_PURPOSE_MASTID <> 1364660005542
AND b1.CASE_PURPOSE_GROUP <> 18438000000000
AND NOT EXISTS
(SELECT 1
FROM TRN_RCMS_DECISION
WHERE TRN_RCMS_CASEID = a1.TRN_RCMS_CASEREGID)
THEN
1
ELSE
0
END) = 1
court_code=18175
case_no=2023/468
recordid=0
recordid=0
Time elapsed = 1058
casedetails after validation = 18175
trn_rcms_caseid =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
S=11807000007938
Select trn_rcms_caseid from trn_rcms_decision where trn_rcms_caseid = :S
S=11807000007938
Time elapsed = 977
trn_rcms_caseid after validation = 11807000007938
pagesource = TRANSPAGE
instdate =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
instdate after validation = 27/09/2023
case_type =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
case_type after validation = ????
act =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
act after validation = ???????? ??-?????? ?????? 1956
section =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
section after validation = 75
case_purposeid =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
case_purposeid after validation = 1000492
purpose =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
purpose after validation = ?????
hearing_date = 30/12/2024
Evaluating - iif(hearing_date>currdate,{Hearing Date Can not be greater Than Today },{T})
hearing_date = 30/12/2024
currdate = 21/04/2025
Result of iif = T
escase =
court_code=18175
case_no=2023/468
SELECT REPLACE (A1.CASE_NO, '/', '')
FROM trn_rcms_casereg a1
WHERE A1.COURT_CODE = :court_code AND A1.CASE_NO = :case_no
court_code=18175
case_no=2023/468
Time elapsed = 36
escase after validation = 2023468
appellant =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
appellant after validation = ??????? ???
respondent =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
respondent after validation = ????? ? ???? ????
decision_date = 30/12/2024
Evaluating - iif(decision_date>currdate,{Decision Date Can not be greater Than Today },{T})
decision_date = 30/12/2024
currdate = 21/04/2025
Result of iif = T
decision_type = ????????? Id = 11782000000706
recordid=0
pagesource=TRANSPAGE
SELECT DECISION_MASTID, DECISION_NAME
FROM decision_mast A
WHERE court_code = '10006'
AND DECISION_MASTID NOT IN
(11469000000000, 11463000000022, 11776000000009)
AND (CASE
WHEN :recordid > 0
THEN
1
WHEN NVL ( :recordid, 0) = 0
AND DECISION_MASTID != 11782000000706
THEN
1
WHEN NVL ( :pagesource, 'F') = 'TRANSPAGE'
AND DECISION_MASTID = 11782000000706
THEN
1
ELSE
0
END) =
1
ORDER BY DECISION_NAME
recordid=0
recordid=0
pagesource=TRANSPAGE
Time elapsed = 45
decsion_mastid =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
decsion_mastid after validation = 11782000000706
new_case_purpose = ????????? Id = 1025550004746
decision_type=?????????
SELECT b.CASE_PURPOSE_MASTID, b.CASE_PURPOSE_NAME, b.case_purpose_code
FROM case_purpose_mast b
WHERE CASE_PURPOSE_NAME = :decision_type
ORDER BY CASE_PURPOSE_NAME
decision_type=?????????
Time elapsed = 29
new_purpose_id =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
new_purpose_id after validation = 1025550004746
new_purpose_code =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
new_purpose_code after validation = 900
showinactive =
member_name =
court_code=18175
showinactive=
SELECT a.OFFICER_NAME ,a.AADHAAR_NO FROM mst_rcms_officer a,trn_rcms_officer b where a.MST_RCMS_OFFICERID = b.OFFICER_NAME
AND b.court_code = :court_code AND UPPER (b.INACTIVE) = (CASE WHEN :showinactive = 'T' THEN 'T' ELSE 'F' END)
court_code=18175
showinactive=
Time elapsed = 45
member_name after validation = AVDHESH MEENA
decision_remark =
template =
template after validation = General Decision
no_of_page =
Evaluating - 0
no_of_page after validation = 0
chkfinal =
Evaluating - {F}
chkfinal after validation = F
isoneside =
Evaluating - {F}
isoneside after validation = F
chkworth =
Evaluating - {F}
chkworth after validation = F
dupchk =
Evaluating - court_code+case_no
court_code = 18175
case_no = 2023/468
S=181752023/468
Select dupchk from trn_rcms_decision where lower(dupchk) = :S
S=181752023/468
Time elapsed = 1608
dupchk after validation = 181752023/468
usern =
Evaluating - username
username = DM_Anupghar_R
usern after validation = DM_Anupghar_R
adharno =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
adharno after validation = 451000995073
esign_template =
Evaluating - {cd.pdf}
esign_template after validation = cd.pdf
esign_filename =
court_code=18175
case_no=2023/468
SELECT UPPER ('CD' || REGEXP_REPLACE ( :court_code || A1.CASE_NO, '[^0-9A-Za-z]', ''))
AS FileName
FROM trn_rcms_casereg a1
WHERE A1.COURT_CODE = :court_code AND A1.CASE_NO = :case_no
court_code=18175
court_code=18175
case_no=2023/468
Time elapsed = 63
esign_filename after validation = CD181752023468
trans_type =
Evaluating - iif(recordid>0,{Decision Updated},{Decision Submitted})
recordid = 0
Result of iif = Decision Submitted
trans_type after validation = Decision Submitted
isfeedback =
Evaluating - iif(recordid>0,{F},{T})
recordid = 0
Result of iif = T
isfeedback after validation = T
rtf_letter_content =
rtf_letter_content_printable =
html_letter_content =
rtf_qr_content =
rtf_qr_content_printable =
html_qr_details =
dc_summ =
>>Writing to tables tscd
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tscd'
Time elapsed = 23
Saving to table TRN_RCMS_DECISION
select * from TRN_RCMS_DECISION where TRN_RCMS_DECISIONid=0
Time elapsed = 31
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 15
RecordId = 16670000010810
MapName rctcr1
SourceId 16670000010726
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 24
isoneside = F
chkfinal = F
chkworth = F
trn_rcms_caseid = 11807000007938
dupchk = 181752023/468
no_of_page = 0
showinactive =
new_purpose_code = 900
member_name = AVDHESH MEENA
template = General Decision
decision_remark =
decision_type = 11782000000706
decision_date = 30/12/2024
hearing_date = 30/12/2024
court_code = 18175
case_no = 2023/468
new_case_purpose = 1025550004746
Posting record
Param Type = n
trn_rcms_decisionid=16670000010810
Param Type = c
mapname=rctcr1
Param Type = n
sourceid=16670000010726
Param Type = c
cancel=F
Param Type = c
createdby=DM_Anupghar_R
Param Type = c
createdon=21/04/2025 12:05:55
Param Type = c
username=DM_Anupghar_R
Param Type = c
modifiedon=21/04/2025 12:05:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isoneside=F
Param Type = c
chkfinal=F
Param Type = c
chkworth=F
Param Type = n
trn_rcms_caseid=11807000007938
Param Type = c
dupchk=181752023/468
Param Type = n
no_of_page=0
Param Type = c
new_purpose_code=900
Param Type = c
member_name=AVDHESH MEENA
Param Type = c
template=General Decision
Param Type = n
decision_type=11782000000706
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = c
hearing_date=30/12/2024 00:00:00
Param Type = c
court_code=18175
Param Type = c
case_no=2023/468
Param Type = n
new_case_purpose=1025550004746
insert into TRN_RCMS_DECISION (trn_rcms_decisionid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isoneside,chkfinal,chkworth,trn_rcms_caseid,dupchk,no_of_page,showinactive,new_purpose_code,member_name,template,decision_remark,decision_type,decision_date,hearing_date,court_code,case_no,new_case_purpose) values (:trn_rcms_decisionid,: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,:isoneside,:chkfinal,:chkworth,:trn_rcms_caseid,:dupchk,:no_of_page,null,:new_purpose_code,:member_name,:template,null,:decision_type,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:new_case_purpose)
Saving to table TRN_RCMS_DECCONTENT
select * from TRN_RCMS_DECCONTENT where TRN_RCMS_DECCONTENTid=0
Time elapsed = 24
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 = 21
RecordId = 16670000010811
Select sysdate as sdt from dual
Time elapsed = 31
rtf_qr_content_printable =
html_qr_details =
dc_summ =
rtf_qr_content =
rtf_letter_content =
rtf_letter_content_printable =
html_letter_content =
Posting record
Param Type = n
trn_rcms_deccontentid=16670000010811
Param Type = n
trn_rcms_decisionid=16670000010810
insert into TRN_RCMS_DECCONTENT (trn_rcms_deccontentid,trn_rcms_decisionid,rtf_qr_content_printable,html_qr_details,dc_summ,rtf_qr_content,rtf_letter_content,rtf_letter_content_printable,html_letter_content) values (:trn_rcms_deccontentid,:trn_rcms_decisionid,null,null,null,null,null,null,null)
>>Mapping
Mapped court_code Row = 1 value = 18175 idvalue 0
Mapped case_no Row = 1 value = 2023/468 idvalue 0
Mapped trn_rcms_caseid Row = 1 value = 11807000007938 idvalue 0
Mapped next_hear_date Row = 1 value = 30/12/2024 idvalue 0
Mapped new_case_purpose Row = 1 value = ????????? idvalue 1025550004746
Mapped pagesrc Row = 1 value = DECISION idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Decision) idvalue 0
>>Validating tsrcf
>>Frame No 1
currdate =
Evaluating - date()
Result of date = 21/04/2025
currdate after validation = 21/04/2025
pagesrc = DECISION
viewfilter =
Evaluating - { AND a1.court_code = :m_courtcode }
viewfilter after validation = AND a1.court_code = :m_courtcode
court_name =
username=DM_Anupghar_R
select court_name_mastid,court_name,court_code from v_axcourts where paxusername=:username
username=DM_Anupghar_R
Time elapsed = 44
Evaluating - m_courtname
m_courtname = ???? ???????,??????
court_name after validation = ???? ???????,?????? Id = 1395770007168
court_code = 18175
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
case_no = 2023/468
Dynamicfilter x1.CASE_NO~Case No =
Query component recreating again
pagesrc=DECISION
court_code=18175
SELECT x1.CASE_NO,x1.TRN_RCMS_CASEREGID
FROM trn_rcms_casereg x1,CASE_PURPOSE_mast x2
WHERE x1.CASE_PURPOSE_NAME = x2.CASE_PURPOSE_mastid
AND (x2.CASE_PURPOSE_GROUP <> 18438000000000 OR :pagesrc = 'DECISION')
AND x1.COURT_CODE = :court_code
ORDER BY CASE_NO
pagesrc=DECISION
court_code=18175
Time elapsed = 98
trn_rcms_caseid = 11807000007938
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
Dynamicfilter x1.CASE_NO~Case No =
casedetails =
court_code=18175
trn_rcms_caseid=11807000007938
SELECT DISTINCT A1.CASE_NO,
A1.DOCID,
A1.TRN_RCMS_CASEREGID,
A1.INSTITUTION_DATE,
A2.ACT_NAME,
A1.SECTION_NAME,
A3.CASE_PURPOSE_NAME,
A4.CASE_PURPOSE_GROUP,
A1.CASEDESCRIPTION,
A1.LAST_HEARING_DATE as HEARINGDATE,
A1.PRIMARY_APPELLANT,
A1.PRIMARY_RESPONDENT
FROM trn_rcms_casereg A1,
rule_Act_mast A2,
case_purpose_mast A3,
case_purpose_group_mast A4
WHERE A1.ACT_NAME = A2.RULE_ACT_MASTID
AND A1.COURT_CODE = :court_code
AND A1.CASE_PURPOSE_NAME = A3.CASE_PURPOSE_MASTID(+)
AND A3.CASE_PURPOSE_GROUP = A4.CASE_PURPOSE_GROUP_MASTID(+)
AND A1.TRN_RCMS_CASEREGID = :trn_rcms_caseid
court_code=18175
trn_rcms_caseid=11807000007938
Time elapsed = 39
casedetails after validation = 2023/468
pre_hear_date =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
pre_hear_date after validation = 02/01/2025
inst_date =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
inst_date after validation = 27/09/2023
act_name =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
act_name after validation = ???????? ??-?????? ?????? 1956
section_name =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
section_name after validation = 75
case_purpose_group =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
case_purpose_group after validation = ????? / ?????
case_purpose_name =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
case_purpose_name after validation = ?????
appellant_name =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
appellant_name after validation = ??????? ???
respondent_name =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
respondent_name after validation = ????? ? ???? ????
description =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
new_case_purpose = ????????? Id = 1025550004746
pagesrc=DECISION
court_code=18175
SELECT b.CASE_PURPOSE_MASTID,
b.CASE_PURPOSE_NAME,
b.CASE_PURPOSE_GROUP,
b.case_purpose_code
FROM case_purpose_mast b, court_setup_casepurpose a
WHERE A.CASE_PURPOSE_NAME = B.CASE_PURPOSE_MASTID
AND (B.CASE_PURPOSE_GROUP <> 18438000000000 OR :pagesrc = 'DECISION')
AND CASE_PURPOSE_MASTID != 1364660005542
AND a.PCOURT_CODE = :court_code
UNION
SELECT b.CASE_PURPOSE_MASTID,
b.CASE_PURPOSE_NAME,
b.CASE_PURPOSE_GROUP,
b.case_purpose_code
FROM case_purpose_mast b
WHERE (B.CASE_PURPOSE_GROUP = 18438000000000 AND :pagesrc = 'DECISION')
OR (case_purpose_code = '1111' AND :pagesrc = 'PRO_ADJ')
ORDER BY 2
pagesrc=DECISION
court_code=18175
pagesrc=DECISION
pagesrc=DECISION
Time elapsed = 74
new_purpose_code =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
new_purpose_code after validation = 900
next_hear_date = 30/12/2024
case_purpose_nameid =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
case_purpose_nameid after validation = 1025550004746
isadjourn =
Evaluating - {NO}
isadjourn after validation = NO
adjourn_type =
SELECT A1.ADJOURN_MASTID, A1.ADJOURN_TYPE
FROM adjourn_mast a1
WHERE a1.inactive = 'F'
ORDER BY A1.ADJOURN_TYPE
Time elapsed = 18
adj_mastid =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
adjourn_remark =
trans_type = Feedback Submitted (Decision)
>>Writing to tables tsrcf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tsrcf'
Time elapsed = 12
Saving to table TRN_RCMS_HEARING
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=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 = 21
RecordId = 16670000010812
MapName tscd2
SourceId 16670000010810
Select sysdate as sdt from dual
Time elapsed = 23
Select sysdate as sdt from dual
Time elapsed = 23
adjourn_type = 0
adjourn_remark =
pre_hear_date = 02/01/2025
isadjourn = NO
new_case_purpose = 1025550004746
case_no = 2023/468
court_code = 18175
trn_rcms_caseid = 11807000007938
next_hear_date = 30/12/2024
Posting record
Param Type = n
trn_rcms_hearingid=16670000010812
Param Type = c
mapname=tscd2
Param Type = n
sourceid=16670000010810
Param Type = c
cancel=F
Param Type = c
createdby=DM_Anupghar_R
Param Type = c
createdon=21/04/2025 12:05:58
Param Type = c
username=DM_Anupghar_R
Param Type = c
modifiedon=21/04/2025 12:05:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
adjourn_type=0
Param Type = c
pre_hear_date=02/01/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
new_case_purpose=1025550004746
Param Type = c
case_no=2023/468
Param Type = c
court_code=18175
Param Type = c
trn_rcms_caseid=11807000007938
Param Type = c
next_hear_date=30/12/2024 00:00:00
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,pre_hear_date,isadjourn,new_case_purpose,case_no,court_code,trn_rcms_caseid,next_hear_date) values (:trn_rcms_hearingid,: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,:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'))
>>Mapping
Mapped court_code Row = 1 value = 18175 idvalue 0
Mapped case_no Row = 1 value = 2023/468 idvalue 0
Mapped hearing_date Row = 1 value = 30/12/2024 idvalue 0
Mapped case_purpose Row = 1 value = 1025550004746 idvalue 0
Mapped trans_type Row = 1 value = Decision Submitted idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11807000007938 idvalue 0
Mapped decision_date Row = 1 value = 30/12/2024 idvalue 0
Mapped decision_type Row = 1 value = 11782000000706 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 30/12/2024 idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18175
trn_rcms_caseregid = 11807000007938
case_no = 2023/468
prev_hearing_date = 30/12/2024
hearing_date = 30/12/2024
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 = 37
prev_case_purpose after validation = 1000492
case_purpose = 1025550004746
trans_type = Decision Submitted
clcheck =
isadjourn =
adjourn_type =
decision_type = 11782000000706
decision_date = 30/12/2024
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 13
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 16
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 17
RecordId = 16670000010813
MapName tscd1
SourceId 16670000010810
Select sysdate as sdt from dual
Time elapsed = 20
Select sysdate as sdt from dual
Time elapsed = 20
prev_hearing_date = 30/12/2024
decision_type = 11782000000706
decision_date = 30/12/2024
adjourn_type =
isadjourn =
prev_case_purpose = 1000492
hearing_date = 30/12/2024
case_no = 2023/468
court_code = 18175
case_purpose = 1025550004746
trans_type = Decision Submitted
trn_rcms_caseregid = 11807000007938
Posting record
Param Type = n
trn_rcms_case_histid=16670000010813
Param Type = c
mapname=tscd1
Param Type = n
sourceid=16670000010810
Param Type = c
cancel=F
Param Type = c
createdby=DM_Anupghar_R
Param Type = c
createdon=21/04/2025 12:25:29
Param Type = c
username=DM_Anupghar_R
Param Type = c
modifiedon=21/04/2025 12:25:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hearing_date=30/12/2024 00:00:00
Param Type = n
decision_type=11782000000706
Param Type = c
decision_date=30/12/2024 00:00:00
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=30/12/2024 00:00:00
Param Type = c
case_no=2023/468
Param Type = c
court_code=18175
Param Type = c
case_purpose=1025550004746
Param Type = c
trans_type=Decision Submitted
Param Type = c
trn_rcms_caseregid=11807000007938
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hearing_date,decision_type,decision_date,adjourn_type,isadjourn,prev_case_purpose,hearing_date,case_no,court_code,case_purpose,trans_type,trn_rcms_caseregid) values (:trn_rcms_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,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'),:decision_type,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),null,null,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:case_purpose,:trans_type,:trn_rcms_caseregid)
>>Mapping
Mapped court_code Row = 1 value = 18175 idvalue 0
Mapped case_no Row = 1 value = 2023/468 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/01/2025 idvalue 0
Mapped hearing_date Row = 1 value = 30/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1025550004746 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Decision) idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11807000007938 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18175
trn_rcms_caseregid = 11807000007938
case_no = 2023/468
prev_hearing_date = 02/01/2025
hearing_date = 30/12/2024
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 = 29
prev_case_purpose after validation = 1000492
case_purpose = 1025550004746
trans_type = Feedback Submitted (Decision)
clcheck =
isadjourn = NO
adjourn_type =
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 12
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_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 = 16
RecordId = 16670000010814
MapName tsrcf1
SourceId 16670000010812
Select sysdate as sdt from dual
Time elapsed = 222
Select sysdate as sdt from dual
Time elapsed = 15
adjourn_type =
isadjourn = NO
trn_rcms_caseregid = 11807000007938
decision_date =
decision_type = 0
prev_case_purpose = 1000492
trans_type = Feedback Submitted (Decision)
prev_hearing_date = 02/01/2025
case_no = 2023/468
court_code = 18175
case_purpose = 1025550004746
hearing_date = 30/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=16670000010814
Param Type = c
mapname=tsrcf1
Param Type = n
sourceid=16670000010812
Param Type = c
cancel=F
Param Type = c
createdby=DM_Anupghar_R
Param Type = c
createdon=21/04/2025 12:25:34
Param Type = c
username=DM_Anupghar_R
Param Type = c
modifiedon=21/04/2025 12:25:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseregid=11807000007938
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
trans_type=Feedback Submitted (Decision)
Param Type = c
prev_hearing_date=02/01/2025 00:00:00
Param Type = c
case_no=2023/468
Param Type = c
court_code=18175
Param Type = c
case_purpose=1025550004746
Param Type = c
hearing_date=30/12/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,isadjourn,trn_rcms_caseregid,decision_date,decision_type,prev_case_purpose,trans_type,prev_hearing_date,case_no,court_code,case_purpose,hearing_date) values (:trn_rcms_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,null,:isadjourn,:trn_rcms_caseregid,null,:decision_type,:prev_case_purpose,:trans_type,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from rctcr to tscd from row 2
>>Mapping
Mapped court_code Row = 1 value = 18175 idvalue 0
Mapped case_no Row = 1 value = 2023/470 idvalue 0
Mapped new_case_purpose Row = 1 value = ????????? idvalue 1025550004746
Mapped decision_type Row = 1 value = ????????? idvalue 11782000000706
Mapped decision_date Row = 1 value = 30/12/2024 idvalue 0
Mapped hearing_date Row = 1 value = 30/12/2024 idvalue 0
Mapped pagesource Row = 1 value = TRANSPAGE idvalue 0
>>Validating tscd
>>Frame No 1
currdate =
Evaluating - date()
Result of date = 21/04/2025
currdate after validation = 21/04/2025
court_name =
Evaluating - m_courtname
m_courtname = ???? ???????,??????
court_name after validation = ???? ???????,?????? Id = 1395770007168
court_code = 18175
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
viewfilter =
Evaluating - {AND a1.court_code=:m_courtcode }
viewfilter after validation = AND a1.court_code=:m_courtcode
case_no = 2023/470
casedetails =
case_no=2023/470
SELECT A1.COURT_CODE,
A1.TRN_RCMS_CASEREGID,
A1.INSTITUTION_DATE,
A1.CASE_NO,
A1.MCASE_NO,
A1.LAST_HEARING_DATE AS hearing_date,
B2.DISTRICT_NAME,
B3.CASE_TYPE,
B1.CASE_PURPOSE_NAME,
A1.CASE_PURPOSE_NAME AS CPID,
B4.ACT_NAME,
A1.SECTION_NAME,
A1.PRIMARY_APPELLANT AS APPELLANT_NAME,
A1.PRIMARY_RESPONDENT AS RESPONDENT_NAME
FROM trn_rcms_casereg a1,
case_purpose_mast b1,
district_mast b2,
case_type_mast b3,
rule_act_mast b4
WHERE A1.CASE_PURPOSE_NAME = B1.CASE_PURPOSE_MASTID
AND A1.DISTRICT_NAME = B2.DISTRICT_MASTID
AND A1.ACT_NAME = B4.RULE_ACT_MASTID
AND A1.CASE_TYPE = B3.CASE_TYPE_MASTID
AND A1.COURT_CODE = :court_code
AND a1.CASE_NO = :case_no
AND (CASE
WHEN :recordid > 0
THEN
1
WHEN :recordid = 0
AND b1.CASE_PURPOSE_MASTID <> 1364660005542
AND b1.CASE_PURPOSE_GROUP <> 18438000000000
AND NOT EXISTS
(SELECT 1
FROM TRN_RCMS_DECISION
WHERE TRN_RCMS_CASEID = a1.TRN_RCMS_CASEREGID)
THEN
1
ELSE
0
END) = 1
court_code=18175
case_no=2023/470
recordid=0
recordid=0
Time elapsed = 66
trn_rcms_caseid =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
S=0
Select trn_rcms_caseid from trn_rcms_decision where trn_rcms_caseid = :S
S=0
Time elapsed = 1526
Duplicate values are not allowed in Case No.
Error :
Select sysdate as sdt from dual
Time elapsed = 23
insert into axerrorlog values('DM_Anupghar_R',to_date('21/04/2025 12:25:37','dd/mm/yyyy hh24:mi:ss'),'rctcr','SaveData','')
Time elapsed = 19
Constraint Name =
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=DM_Anupghar_R
Param Type = c
calledon=21/04/2025 12:04:45
Param Type = c
callfinished=21/04/2025 12:25:38
Param Type = c
structname=rctcr
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=Duplicate values are not allowed in Case No.
Param Type = n
timetaken=1252068
Param Type = n
dbtimetaken=1219098
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