ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
gcmsSDO_Ladnoo_PRO827ccb0eea8a706c4c34a16891f84e7b![]()
INRF500250000Ffiresql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtname := sqlget({m2},{court_name})firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})m_courttype := sqlget({m3},{court_type})firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})m_courtid := sqlget({m4},{court_name_mastid})firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})login_userid := sqlget({m4},{axusersid})firesql({m4},{select :username as uname from dual})u_name := sqlget({m4},{uname})firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtcode := sqlget({m4},{COURT_CODE})firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})m_statename := sqlget({m2},{STATE_NAME})firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_distName := sqlget({m7},{DISTNAMEENG})firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_courtcatid := sqlget({m8},{COURT_CATEGOTY})firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})m_deptid := sqlget({m4},{department_mastid})firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})m_courttypeid := sqlget({m3},{court_type_mastid})firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })urole := sqlget({m4},{groupname})firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})m_cutoffdt := sqlget({a1},{dd})firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})m_offcount := sqlget({P1},{ct})00000F
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
username=SDO_Ladnoo_PRO
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Ladnoo_PRO
Time elapsed = 36
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ????? ???????,??????,???????-??????
Result = ????? ???????,??????,???????-??????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=SDO_Ladnoo_PRO
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Ladnoo_PRO
Time elapsed = 245
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = SDO
Result = SDO
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=SDO_Ladnoo_PRO
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Ladnoo_PRO
Time elapsed = 223
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 12122000000002
Result = 12122000000002
Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=SDO_Ladnoo_PRO
Time elapsed = 17
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1050010007684
Result = 1050010007684
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_Ladnoo_PRO
Time elapsed = 20
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_Ladnoo_PRO
Result = SDO_Ladnoo_PRO
Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Ladnoo_PRO
Time elapsed = 18
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10125
Result = 10125
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 = 74
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Ladnoo_PRO
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Ladnoo_PRO
Time elapsed = 17
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Deedwana-Kuchaman
Result = Deedwana-Kuchaman
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Ladnoo_PRO
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Ladnoo_PRO
Time elapsed = 233
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=1050010007684
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1050010007684
Time elapsed = 20
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=SDO_Ladnoo_PRO
Time elapsed = 224
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10823000000000
Result = 10823000000000
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=SDO_Ladnoo_PRO
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=SDO_Ladnoo_PRO
Time elapsed = 18
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_admin
Result = court_admin
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 220
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=SDO_Ladnoo_PRO
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=SDO_Ladnoo_PRO
Time elapsed = 32
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 7
Result = 7
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_admin') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 13
select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 248
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_admin,trcmf,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 = 9
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 : trcmf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 10
Step4
tstructs\stm size:2075
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Evaluating date()
Result =
Evaluating iif((next_hear_date>Validating trcmf
>>Frame No 1
courtcode = 10125
hearing_date = 13/02/2025
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 9
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 23
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 = 11
RecordId = 19479000008767
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 37
hearing_date = 13/02/2025
courtcode = 10125
Posting record
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:00
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=13/02/2025 00:00:00
Param Type = c
courtcode=10125
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)
Saving to table TRN_RCMS_HEARING
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 65
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 = 7
RecordId = 19479000008768
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 221
court_code = 10125
case_no = 2024/9
trn_rcms_caseid = 17037000007460
adjourn_type = 0
adjourn_remark =
new_case_purpose = 1000525
isadjourn = NO
pre_hear_date = 13/02/2025
pre_case_purpose = 1000525
next_hear_date = 13/02/2025
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=19479000008768
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:00
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10125
Param Type = c
case_no=2024/9
Param Type = c
trn_rcms_caseid=17037000007460
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000525
Param Type = c
isadjourn=NO
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
pre_case_purpose=1000525
Param Type = c
next_hear_date=13/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,new_case_purpose,isadjourn,pre_hear_date,pre_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:case_no,:trn_rcms_caseid,:adjourn_type,null,:new_case_purpose,:isadjourn,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 10
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 = 6
RecordId = 19479000008769
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 631
trn_rcms_caseid = 13240000006774
case_no = 2022/116
court_code = 10125
isadjourn = NO
adjourn_type = 0
adjourn_remark =
next_hear_date = 27/03/2025
pre_hear_date = 13/02/2025
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=19479000008769
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:00
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=13240000006774
Param Type = c
case_no=2022/116
Param Type = c
court_code=10125
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=27/03/2025 00:00:00
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,case_no,court_code,isadjourn,adjourn_type,adjourn_remark,next_hear_date,pre_hear_date,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,:case_no,:court_code,:isadjourn,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 10
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 = 8
RecordId = 19479000008770
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 432
Select sysdate as sdt from dual
Time elapsed = 18
next_hear_date = 09/04/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2022/63
court_code = 10125
trn_rcms_caseid = 16018000006125
pre_case_purpose = 18678000000000
pre_hear_date = 13/02/2025
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=19479000008770
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:01
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=09/04/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/63
Param Type = c
court_code=10125
Param Type = c
trn_rcms_caseid=16018000006125
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 10
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 19479000008771
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 217
Select sysdate as sdt from dual
Time elapsed = 238
next_hear_date = 09/04/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2022/64
court_code = 10125
trn_rcms_caseid = 16069000006203
pre_case_purpose = 18678000000000
pre_hear_date = 13/02/2025
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=19479000008771
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:02
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=09/04/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/64
Param Type = c
court_code=10125
Param Type = c
trn_rcms_caseid=16069000006203
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 11
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 = 7
RecordId = 19479000008772
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 649
next_hear_date = 15/04/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/42
court_code = 10125
trn_rcms_caseid = 14990000007481
pre_case_purpose = 18678000000000
pre_hear_date = 13/02/2025
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=19479000008772
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:02
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=15/04/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/42
Param Type = c
court_code=10125
Param Type = c
trn_rcms_caseid=14990000007481
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 9
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 = 7
RecordId = 19479000008773
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 637
Select sysdate as sdt from dual
Time elapsed = 220
pre_hear_date = 13/02/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 15032000007253
court_code = 10125
case_no = 2023/760
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 13/02/2025
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=19479000008773
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:03
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:04
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=15032000007253
Param Type = c
court_code=10125
Param Type = c
case_no=2023/760
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=13/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 12
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 = 7
RecordId = 19479000008774
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 32
Select sysdate as sdt from dual
Time elapsed = 635
case_no = 2023/761
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 15071000008146
pre_hear_date = 13/02/2025
adjourn_remark =
court_code = 10125
adjourn_type = 0
next_hear_date = 13/02/2025
isadjourn = NO
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=19479000008774
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:04
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:04
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/761
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=15071000008146
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = c
court_code=10125
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=13/02/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 30
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 = 6
RecordId = 19479000008775
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 11
next_hear_date = 13/02/2025
court_code = 10125
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/770
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
trn_rcms_caseid = 15733000008340
pre_hear_date = 13/02/2025
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=19479000008775
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:05
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:05
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=13/02/2025 00:00:00
Param Type = c
court_code=10125
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/770
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=15733000008340
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,court_code,isadjourn,adjourn_remark,adjourn_type,case_no,pre_case_purpose,new_case_purpose,trn_rcms_caseid,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:isadjourn,null,:adjourn_type,:case_no,:pre_case_purpose,:new_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 8
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 = 7
RecordId = 19479000008776
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 33
Select sysdate as sdt from dual
Time elapsed = 33
case_no = 2024/173
trn_rcms_caseid = 17190000008893
isadjourn = NO
next_hear_date = 23/04/2025
court_code = 10125
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18678000000000
pre_hear_date = 13/02/2025
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=19479000008776
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:05
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:05
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2024/173
Param Type = c
trn_rcms_caseid=17190000008893
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=23/04/2025 00:00:00
Param Type = c
court_code=10125
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_rcms_caseid,isadjourn,next_hear_date,court_code,adjourn_remark,adjourn_type,new_case_purpose,pre_hear_date,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_rcms_caseid,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,null,:adjourn_type,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 11
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 19479000008777
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 659
Select sysdate as sdt from dual
Time elapsed = 13
pre_hear_date = 13/02/2025
trn_rcms_caseid = 17283000008110
court_code = 10125
case_no = 2024/174
pre_case_purpose = 18678000000000
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 23/04/2025
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=19479000008777
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:05
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = c
trn_rcms_caseid=17283000008110
Param Type = c
court_code=10125
Param Type = c
case_no=2024/174
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=23/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,court_code,case_no,pre_case_purpose,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:court_code,:case_no,:pre_case_purpose,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 222
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 = 17
RecordId = 19479000008778
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 32
pre_hear_date = 13/02/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 17508000009572
court_code = 10125
case_no = 2024/176
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 20/03/2025
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=19479000008778
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:06
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=17508000009572
Param Type = c
court_code=10125
Param Type = c
case_no=2024/176
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=20/03/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 54
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 19479000008779
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 11
next_hear_date = 03/03/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/177
court_code = 10125
trn_rcms_caseid = 17608000007687
pre_case_purpose = 18678000000000
pre_hear_date = 13/02/2025
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=19479000008779
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:07
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=03/03/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/177
Param Type = c
court_code=10125
Param Type = c
trn_rcms_caseid=17608000007687
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 14
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 19479000008780
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 96
Select sysdate as sdt from dual
Time elapsed = 75
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 27/03/2025
case_no = 2024/190
court_code = 10125
trn_rcms_caseid = 13713000009163
pre_case_purpose = 18678000000000
pre_hear_date = 13/02/2025
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=19479000008780
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:07
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=27/03/2025 00:00:00
Param Type = c
case_no=2024/190
Param Type = c
court_code=10125
Param Type = c
trn_rcms_caseid=13713000009163
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 10
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 = 6
RecordId = 19479000008781
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 219
pre_hear_date = 13/02/2025
trn_rcms_caseid = 13826000008141
next_hear_date = 09/04/2025
pre_case_purpose = 18678000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2024/192
court_code = 10125
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=19479000008781
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:07
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = c
trn_rcms_caseid=13826000008141
Param Type = c
next_hear_date=09/04/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/192
Param Type = c
court_code=10125
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=14
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,next_hear_date,pre_case_purpose,adjourn_remark,adjourn_type,isadjourn,case_no,court_code,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,null,:adjourn_type,:isadjourn,:case_no,:court_code,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 16
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 = 213
RecordId = 19479000008782
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 629
next_hear_date = 22/04/2025
isadjourn = NO
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 13/02/2025
adjourn_remark =
court_code = 10125
trn_rcms_caseid = 16196000007570
case_no = 2024/245
adjourn_type = 0
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=19479000008782
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:08
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/04/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = c
court_code=10125
Param Type = c
trn_rcms_caseid=16196000007570
Param Type = c
case_no=2024/245
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,adjourn_remark,court_code,trn_rcms_caseid,case_no,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:trn_rcms_caseid,:case_no,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 30
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 = 6
RecordId = 19479000008783
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 1656
pre_hear_date = 13/02/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16282000008136
court_code = 10125
case_no = 2024/246
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 22/04/2025
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=19479000008783
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:08
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16282000008136
Param Type = c
court_code=10125
Param Type = c
case_no=2024/246
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=22/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 216
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 = 415
RecordId = 19479000008784
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 71
Select sysdate as sdt from dual
Time elapsed = 74
next_hear_date = 23/04/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/32
court_code = 10125
trn_rcms_caseid = 10609000008343
pre_case_purpose = 18678000000000
pre_hear_date = 13/02/2025
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=19479000008784
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:11
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:11
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=23/04/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/32
Param Type = c
court_code=10125
Param Type = c
trn_rcms_caseid=10609000008343
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 20
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 = 7
RecordId = 19479000008785
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 249
Select sysdate as sdt from dual
Time elapsed = 221
pre_case_purpose = 18678000000000
court_code = 10125
pre_hear_date = 13/02/2025
case_no = 2024/34
trn_rcms_caseid = 10685000007930
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 23/04/2025
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=19479000008785
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:11
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:11
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=10125
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = c
case_no=2024/34
Param Type = c
trn_rcms_caseid=10685000007930
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=23/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,court_code,pre_hear_date,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 31
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 = 8
RecordId = 19479000008786
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 31
Select sysdate as sdt from dual
Time elapsed = 244
adjourn_remark =
trn_rcms_caseid = 11069000009502
adjourn_type = 0
court_code = 10125
case_no = 2024/448
pre_hear_date = 13/02/2025
new_case_purpose = 18678000000000
next_hear_date = 27/02/2025
pre_case_purpose = 18678000000000
isadjourn = NO
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=19479000008786
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:12
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=11069000009502
Param Type = c
adjourn_type=0
Param Type = c
court_code=10125
Param Type = c
case_no=2024/448
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=27/02/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,adjourn_type,court_code,case_no,pre_hear_date,new_case_purpose,next_hear_date,pre_case_purpose,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,:adjourn_type,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 12
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 = 218
RecordId = 19479000008787
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 22
Select sysdate as sdt from dual
Time elapsed = 33
adjourn_remark =
trn_rcms_caseid = 11997000008611
pre_hear_date = 13/02/2025
court_code = 10125
case_no = 2024/58
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 18/02/2025
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=19479000008787
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:13
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=11997000008611
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = c
court_code=10125
Param Type = c
case_no=2024/58
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=18/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=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 = 218
RecordId = 19479000008788
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 16
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 12259000008468
pre_hear_date = 13/02/2025
court_code = 10125
case_no = 2024/59
next_hear_date = 18/02/2025
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=19479000008788
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:13
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=12259000008468
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = c
court_code=10125
Param Type = c
case_no=2024/59
Param Type = c
next_hear_date=18/02/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 10
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 = 6
RecordId = 19479000008789
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 428
Select sysdate as sdt from dual
Time elapsed = 219
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 17489000009413
case_no = 2024/76
new_case_purpose = 18678000000000
pre_hear_date = 13/02/2025
next_hear_date = 10/03/2025
isadjourn = NO
court_code = 10125
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=19479000008789
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:13
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=17489000009413
Param Type = c
case_no=2024/76
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = c
next_hear_date=10/03/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
court_code=10125
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,new_case_purpose,pre_hear_date,next_hear_date,isadjourn,court_code,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:trn_rcms_caseid,:case_no,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 231
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 = 7
RecordId = 19479000008790
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 220
Select sysdate as sdt from dual
Time elapsed = 16
adjourn_type = 0
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 14900000008931
case_no = 2025/18
court_code = 10125
pre_hear_date = 13/02/2025
next_hear_date = 25/02/2025
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=19479000008790
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:14
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:15
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=14900000008931
Param Type = c
case_no=2025/18
Param Type = c
court_code=10125
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = c
next_hear_date=25/02/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 30
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 = 215
RecordId = 19479000008791
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 449
Select sysdate as sdt from dual
Time elapsed = 14
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 15948000008981
case_no = 2025/5
court_code = 10125
pre_hear_date = 13/02/2025
next_hear_date = 24/02/2025
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=19479000008791
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:15
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:15
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=15948000008981
Param Type = c
case_no=2025/5
Param Type = c
court_code=10125
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = c
next_hear_date=24/02/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 32
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 = 10
RecordId = 19479000008792
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 228
Select sysdate as sdt from dual
Time elapsed = 15
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 13/02/2025
case_no = 2015/00107
court_code = 10125
trn_rcms_caseid = 13496000000174
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
pre_hear_date = 13/02/2025
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=19479000008792
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:16
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:16
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=13/02/2025 00:00:00
Param Type = c
case_no=2015/00107
Param Type = c
court_code=10125
Param Type = c
trn_rcms_caseid=13496000000174
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,case_no,court_code,trn_rcms_caseid,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 14
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 = 8
RecordId = 19479000008793
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 30
Select sysdate as sdt from dual
Time elapsed = 32
next_hear_date = 20/03/2025
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 12548000002810
case_no = 2019/00256
court_code = 10125
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
pre_hear_date = 13/02/2025
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=19479000008793
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:17
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=20/03/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=12548000002810
Param Type = c
case_no=2019/00256
Param Type = c
court_code=10125
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 9
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 = 9
RecordId = 19479000008794
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 37
Select sysdate as sdt from dual
Time elapsed = 14
next_hear_date = 21/04/2025
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18466000000000
case_no = 2022/107
court_code = 10125
trn_rcms_caseid = 14254000006505
pre_case_purpose = 18466000000000
pre_hear_date = 13/02/2025
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=19479000008794
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:17
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/04/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18466000000000
Param Type = c
case_no=2022/107
Param Type = c
court_code=10125
Param Type = c
trn_rcms_caseid=14254000006505
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=27
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 16
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 = 426
RecordId = 19479000008795
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 32
Select sysdate as sdt from dual
Time elapsed = 220
next_hear_date = 09/04/2025
new_case_purpose = 18466000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2024/193
court_code = 10125
trn_rcms_caseid = 13871000009028
pre_case_purpose = 18466000000000
pre_hear_date = 13/02/2025
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=19479000008795
Param Type = n
trn_rcms_mhearingid=19479000008767
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:17
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=09/04/2025 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/193
Param Type = c
court_code=10125
Param Type = c
trn_rcms_caseid=13871000009028
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=13/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_remark,adjourn_type,isadjourn,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,null,:adjourn_type,:isadjourn,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
Time elapsed for insert/update = 3948955218430
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17037000007460 idvalue 0
Mapped case_no Row = 1 value = 2024/9 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 17037000007460
case_no = 2024/9
prev_hearing_date = 13/02/2025
hearing_date = 13/02/2025
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purposename=???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????
Time elapsed = 16
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 218
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 19479000008796
MapName trcmf1
SourceId 19479000008768
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 34
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 13/02/2025
case_no = 2024/9
trn_rcms_caseregid = 17037000007460
court_code = 10125
case_purpose = 1000525
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008796
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008768
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:18
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=13/02/2025 00:00:00
Param Type = c
case_no=2024/9
Param Type = c
trn_rcms_caseregid=17037000007460
Param Type = c
court_code=10125
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 2
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13240000006774 idvalue 0
Mapped case_no Row = 1 value = 2022/116 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 27/03/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 13240000006774
case_no = 2022/116
prev_hearing_date = 13/02/2025
hearing_date = 27/03/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 225
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 18
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 = 9
RecordId = 19479000008797
MapName trcmf1
SourceId 19479000008769
Select sysdate as sdt from dual
Time elapsed = 33
Select sysdate as sdt from dual
Time elapsed = 13
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 27/03/2025
case_no = 2022/116
trn_rcms_caseregid = 13240000006774
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008797
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008769
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:21
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=27/03/2025 00:00:00
Param Type = c
case_no=2022/116
Param Type = c
trn_rcms_caseregid=13240000006774
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 3
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16018000006125 idvalue 0
Mapped case_no Row = 1 value = 2022/63 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 16018000006125
case_no = 2022/63
prev_hearing_date = 13/02/2025
hearing_date = 09/04/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 7
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=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 = 7
RecordId = 19479000008798
MapName trcmf1
SourceId 19479000008770
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 305
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/04/2025
case_no = 2022/63
trn_rcms_caseregid = 16018000006125
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008798
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008770
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:23
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/04/2025 00:00:00
Param Type = c
case_no=2022/63
Param Type = c
trn_rcms_caseregid=16018000006125
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 4
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16069000006203 idvalue 0
Mapped case_no Row = 1 value = 2022/64 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 16069000006203
case_no = 2022/64
prev_hearing_date = 13/02/2025
hearing_date = 09/04/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 216
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 11
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 19479000008799
MapName trcmf1
SourceId 19479000008771
Select sysdate as sdt from dual
Time elapsed = 24
Select sysdate as sdt from dual
Time elapsed = 13
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/04/2025
case_no = 2022/64
trn_rcms_caseregid = 16069000006203
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008799
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008771
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:25
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/04/2025 00:00:00
Param Type = c
case_no=2022/64
Param Type = c
trn_rcms_caseregid=16069000006203
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 5
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14990000007481 idvalue 0
Mapped case_no Row = 1 value = 2023/42 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 14990000007481
case_no = 2023/42
prev_hearing_date = 13/02/2025
hearing_date = 15/04/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 8
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 10
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 10
RecordId = 19479000008800
MapName trcmf1
SourceId 19479000008772
Select sysdate as sdt from dual
Time elapsed = 34
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 15/04/2025
case_no = 2023/42
trn_rcms_caseregid = 14990000007481
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008800
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008772
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:26
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=15/04/2025 00:00:00
Param Type = c
case_no=2023/42
Param Type = c
trn_rcms_caseregid=14990000007481
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 6
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15032000007253 idvalue 0
Mapped case_no Row = 1 value = 2023/760 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 15032000007253
case_no = 2023/760
prev_hearing_date = 13/02/2025
hearing_date = 13/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 422
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 22
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 19479000008801
MapName trcmf1
SourceId 19479000008773
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 430
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 13/02/2025
case_no = 2023/760
trn_rcms_caseregid = 15032000007253
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008801
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008773
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:28
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=13/02/2025 00:00:00
Param Type = c
case_no=2023/760
Param Type = c
trn_rcms_caseregid=15032000007253
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 7
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15071000008146 idvalue 0
Mapped case_no Row = 1 value = 2023/761 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 15071000008146
case_no = 2023/761
prev_hearing_date = 13/02/2025
hearing_date = 13/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 12
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 = 216
RecordId = 19479000008802
MapName trcmf1
SourceId 19479000008774
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 12
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 13/02/2025
case_no = 2023/761
trn_rcms_caseregid = 15071000008146
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008802
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008774
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:30
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=13/02/2025 00:00:00
Param Type = c
case_no=2023/761
Param Type = c
trn_rcms_caseregid=15071000008146
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 8
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15733000008340 idvalue 0
Mapped case_no Row = 1 value = 2023/770 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 15733000008340
case_no = 2023/770
prev_hearing_date = 13/02/2025
hearing_date = 13/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 7
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 12
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 19479000008803
MapName trcmf1
SourceId 19479000008775
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 220
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 13/02/2025
case_no = 2023/770
trn_rcms_caseregid = 15733000008340
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008803
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008775
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:32
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=13/02/2025 00:00:00
Param Type = c
case_no=2023/770
Param Type = c
trn_rcms_caseregid=15733000008340
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 9
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17190000008893 idvalue 0
Mapped case_no Row = 1 value = 2024/173 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 23/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 17190000008893
case_no = 2024/173
prev_hearing_date = 13/02/2025
hearing_date = 23/04/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 65
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 12
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 19479000008804
MapName trcmf1
SourceId 19479000008776
Select sysdate as sdt from dual
Time elapsed = 221
Select sysdate as sdt from dual
Time elapsed = 14
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 23/04/2025
case_no = 2024/173
trn_rcms_caseregid = 17190000008893
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008804
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008776
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:33
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=23/04/2025 00:00:00
Param Type = c
case_no=2024/173
Param Type = c
trn_rcms_caseregid=17190000008893
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 10
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17283000008110 idvalue 0
Mapped case_no Row = 1 value = 2024/174 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 23/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 17283000008110
case_no = 2024/174
prev_hearing_date = 13/02/2025
hearing_date = 23/04/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 9
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 33
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 = 11
RecordId = 19479000008805
MapName trcmf1
SourceId 19479000008777
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 14
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 23/04/2025
case_no = 2024/174
trn_rcms_caseregid = 17283000008110
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008805
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008777
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:35
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=23/04/2025 00:00:00
Param Type = c
case_no=2024/174
Param Type = c
trn_rcms_caseregid=17283000008110
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 11
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17508000009572 idvalue 0
Mapped case_no Row = 1 value = 2024/176 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 20/03/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 17508000009572
case_no = 2024/176
prev_hearing_date = 13/02/2025
hearing_date = 20/03/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 7
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 10
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 19479000008806
MapName trcmf1
SourceId 19479000008778
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 65
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 20/03/2025
case_no = 2024/176
trn_rcms_caseregid = 17508000009572
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008806
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008778
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:37
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=20/03/2025 00:00:00
Param Type = c
case_no=2024/176
Param Type = c
trn_rcms_caseregid=17508000009572
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 12
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17608000007687 idvalue 0
Mapped case_no Row = 1 value = 2024/177 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 03/03/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 17608000007687
case_no = 2024/177
prev_hearing_date = 13/02/2025
hearing_date = 03/03/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 451
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 = 12
RecordId = 19479000008807
MapName trcmf1
SourceId 19479000008779
Select sysdate as sdt from dual
Time elapsed = 35
Select sysdate as sdt from dual
Time elapsed = 244
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 03/03/2025
case_no = 2024/177
trn_rcms_caseregid = 17608000007687
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008807
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008779
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:39
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=03/03/2025 00:00:00
Param Type = c
case_no=2024/177
Param Type = c
trn_rcms_caseregid=17608000007687
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 13
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13713000009163 idvalue 0
Mapped case_no Row = 1 value = 2024/190 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 27/03/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 13713000009163
case_no = 2024/190
prev_hearing_date = 13/02/2025
hearing_date = 27/03/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 7
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 121
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 19479000008808
MapName trcmf1
SourceId 19479000008780
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 227
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 27/03/2025
case_no = 2024/190
trn_rcms_caseregid = 13713000009163
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008808
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008780
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:41
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=27/03/2025 00:00:00
Param Type = c
case_no=2024/190
Param Type = c
trn_rcms_caseregid=13713000009163
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 14
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13826000008141 idvalue 0
Mapped case_no Row = 1 value = 2024/192 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 13826000008141
case_no = 2024/192
prev_hearing_date = 13/02/2025
hearing_date = 09/04/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 66
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 442
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 19479000008809
MapName trcmf1
SourceId 19479000008781
Select sysdate as sdt from dual
Time elapsed = 222
Select sysdate as sdt from dual
Time elapsed = 14
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/04/2025
case_no = 2024/192
trn_rcms_caseregid = 13826000008141
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008809
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008781
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:43
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/04/2025 00:00:00
Param Type = c
case_no=2024/192
Param Type = c
trn_rcms_caseregid=13826000008141
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 15
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16196000007570 idvalue 0
Mapped case_no Row = 1 value = 2024/245 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 16196000007570
case_no = 2024/245
prev_hearing_date = 13/02/2025
hearing_date = 22/04/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 6
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 11
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 215
RecordId = 19479000008810
MapName trcmf1
SourceId 19479000008782
Select sysdate as sdt from dual
Time elapsed = 220
Select sysdate as sdt from dual
Time elapsed = 218
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/04/2025
case_no = 2024/245
trn_rcms_caseregid = 16196000007570
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008810
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008782
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:45
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/04/2025 00:00:00
Param Type = c
case_no=2024/245
Param Type = c
trn_rcms_caseregid=16196000007570
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 16
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16282000008136 idvalue 0
Mapped case_no Row = 1 value = 2024/246 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 16282000008136
case_no = 2024/246
prev_hearing_date = 13/02/2025
hearing_date = 22/04/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 7
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 13
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 19479000008811
MapName trcmf1
SourceId 19479000008783
Select sysdate as sdt from dual
Time elapsed = 34
Select sysdate as sdt from dual
Time elapsed = 36
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/04/2025
case_no = 2024/246
trn_rcms_caseregid = 16282000008136
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008811
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008783
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:47
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/04/2025 00:00:00
Param Type = c
case_no=2024/246
Param Type = c
trn_rcms_caseregid=16282000008136
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 17
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10609000008343 idvalue 0
Mapped case_no Row = 1 value = 2024/32 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 23/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 10609000008343
case_no = 2024/32
prev_hearing_date = 13/02/2025
hearing_date = 23/04/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 6
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 11
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 19479000008812
MapName trcmf1
SourceId 19479000008784
Select sysdate as sdt from dual
Time elapsed = 662
Select sysdate as sdt from dual
Time elapsed = 16
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 23/04/2025
case_no = 2024/32
trn_rcms_caseregid = 10609000008343
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008812
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008784
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:49
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=23/04/2025 00:00:00
Param Type = c
case_no=2024/32
Param Type = c
trn_rcms_caseregid=10609000008343
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 18
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10685000007930 idvalue 0
Mapped case_no Row = 1 value = 2024/34 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 23/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 10685000007930
case_no = 2024/34
prev_hearing_date = 13/02/2025
hearing_date = 23/04/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 7
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 56
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 19479000008813
MapName trcmf1
SourceId 19479000008785
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 427
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 23/04/2025
case_no = 2024/34
trn_rcms_caseregid = 10685000007930
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008813
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008785
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:51
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=23/04/2025 00:00:00
Param Type = c
case_no=2024/34
Param Type = c
trn_rcms_caseregid=10685000007930
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 19
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11069000009502 idvalue 0
Mapped case_no Row = 1 value = 2024/448 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 27/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 11069000009502
case_no = 2024/448
prev_hearing_date = 13/02/2025
hearing_date = 27/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 7
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 29
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 19479000008814
MapName trcmf1
SourceId 19479000008786
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 221
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 27/02/2025
case_no = 2024/448
trn_rcms_caseregid = 11069000009502
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008814
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008786
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:53
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=27/02/2025 00:00:00
Param Type = c
case_no=2024/448
Param Type = c
trn_rcms_caseregid=11069000009502
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 20
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11997000008611 idvalue 0
Mapped case_no Row = 1 value = 2024/58 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 11997000008611
case_no = 2024/58
prev_hearing_date = 13/02/2025
hearing_date = 18/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 27
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 11
RecordId = 19479000008815
MapName trcmf1
SourceId 19479000008787
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 12
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 18/02/2025
case_no = 2024/58
trn_rcms_caseregid = 11997000008611
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008815
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008787
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:55
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=18/02/2025 00:00:00
Param Type = c
case_no=2024/58
Param Type = c
trn_rcms_caseregid=11997000008611
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 21
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12259000008468 idvalue 0
Mapped case_no Row = 1 value = 2024/59 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 12259000008468
case_no = 2024/59
prev_hearing_date = 13/02/2025
hearing_date = 18/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 7
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 10
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 216
RecordId = 19479000008816
MapName trcmf1
SourceId 19479000008788
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 14
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 18/02/2025
case_no = 2024/59
trn_rcms_caseregid = 12259000008468
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008816
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008788
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:57
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=18/02/2025 00:00:00
Param Type = c
case_no=2024/59
Param Type = c
trn_rcms_caseregid=12259000008468
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 22
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17489000009413 idvalue 0
Mapped case_no Row = 1 value = 2024/76 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 10/03/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 17489000009413
case_no = 2024/76
prev_hearing_date = 13/02/2025
hearing_date = 10/03/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 18
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 32
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 19479000008817
MapName trcmf1
SourceId 19479000008789
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 13
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 10/03/2025
case_no = 2024/76
trn_rcms_caseregid = 17489000009413
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008817
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008789
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:58
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=10/03/2025 00:00:00
Param Type = c
case_no=2024/76
Param Type = c
trn_rcms_caseregid=17489000009413
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 23
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14900000008931 idvalue 0
Mapped case_no Row = 1 value = 2025/18 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 25/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 14900000008931
case_no = 2025/18
prev_hearing_date = 13/02/2025
hearing_date = 25/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 8
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 11
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 19479000008818
MapName trcmf1
SourceId 19479000008790
Select sysdate as sdt from dual
Time elapsed = 25
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 25/02/2025
case_no = 2025/18
trn_rcms_caseregid = 14900000008931
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008818
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008790
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:00:59
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:00:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=25/02/2025 00:00:00
Param Type = c
case_no=2025/18
Param Type = c
trn_rcms_caseregid=14900000008931
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 24
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15948000008981 idvalue 0
Mapped case_no Row = 1 value = 2025/5 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 24/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 15948000008981
case_no = 2025/5
prev_hearing_date = 13/02/2025
hearing_date = 24/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 7
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 10
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 9
RecordId = 19479000008819
MapName trcmf1
SourceId 19479000008791
Select sysdate as sdt from dual
Time elapsed = 223
Select sysdate as sdt from dual
Time elapsed = 19
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/02/2025
case_no = 2025/5
trn_rcms_caseregid = 15948000008981
court_code = 10125
case_purpose = 18678000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008819
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008791
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:01:01
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:01:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=24/02/2025 00:00:00
Param Type = c
case_no=2025/5
Param Type = c
trn_rcms_caseregid=15948000008981
Param Type = c
court_code=10125
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 25
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13496000000174 idvalue 0
Mapped case_no Row = 1 value = 2015/00107 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 13496000000174
case_no = 2015/00107
prev_hearing_date = 13/02/2025
hearing_date = 13/02/2025
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purposename=??????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ????
Time elapsed = 33
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 19479000008820
MapName trcmf1
SourceId 19479000008792
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 218
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 13/02/2025
case_no = 2015/00107
trn_rcms_caseregid = 13496000000174
court_code = 10125
case_purpose = 18466000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008820
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008792
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:01:03
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:01:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=13/02/2025 00:00:00
Param Type = c
case_no=2015/00107
Param Type = c
trn_rcms_caseregid=13496000000174
Param Type = c
court_code=10125
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 26
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12548000002810 idvalue 0
Mapped case_no Row = 1 value = 2019/00256 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 20/03/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 12548000002810
case_no = 2019/00256
prev_hearing_date = 13/02/2025
hearing_date = 20/03/2025
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 27
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 15
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 234
RecordId = 19479000008821
MapName trcmf1
SourceId 19479000008793
Select sysdate as sdt from dual
Time elapsed = 221
Select sysdate as sdt from dual
Time elapsed = 14
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 20/03/2025
case_no = 2019/00256
trn_rcms_caseregid = 12548000002810
court_code = 10125
case_purpose = 18466000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008821
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008793
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:01:05
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:01:05
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=20/03/2025 00:00:00
Param Type = c
case_no=2019/00256
Param Type = c
trn_rcms_caseregid=12548000002810
Param Type = c
court_code=10125
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 27
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14254000006505 idvalue 0
Mapped case_no Row = 1 value = 2022/107 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 21/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 14254000006505
case_no = 2022/107
prev_hearing_date = 13/02/2025
hearing_date = 21/04/2025
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 6
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=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 = 10
RecordId = 19479000008822
MapName trcmf1
SourceId 19479000008794
Select sysdate as sdt from dual
Time elapsed = 224
Select sysdate as sdt from dual
Time elapsed = 219
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 21/04/2025
case_no = 2022/107
trn_rcms_caseregid = 14254000006505
court_code = 10125
case_purpose = 18466000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008822
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008794
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:01:06
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:01:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=21/04/2025 00:00:00
Param Type = c
case_no=2022/107
Param Type = c
trn_rcms_caseregid=14254000006505
Param Type = c
court_code=10125
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 28
>>Mapping
Mapped court_code Row = 1 value = 10125 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13871000009028 idvalue 0
Mapped case_no Row = 1 value = 2024/193 idvalue 0
Mapped prev_hearing_date Row = 1 value = 13/02/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10125
trn_rcms_caseregid = 13871000009028
case_no = 2024/193
prev_hearing_date = 13/02/2025
hearing_date = 09/04/2025
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 6
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 13
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 19479000008823
MapName trcmf1
SourceId 19479000008795
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 35
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 09/04/2025
case_no = 2024/193
trn_rcms_caseregid = 13871000009028
court_code = 10125
case_purpose = 18466000000000
prev_hearing_date = 13/02/2025
Posting record
Param Type = n
trn_rcms_case_histid=19479000008823
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=19479000008795
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Ladnoo_PRO
Param Type = c
createdon=17/02/2025 12:01:09
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
modifiedon=17/02/2025 12:01:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=09/04/2025 00:00:00
Param Type = c
case_no=2024/193
Param Type = c
trn_rcms_caseregid=13871000009028
Param Type = c
court_code=10125
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=13/02/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_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,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
Time elapsed for Gen Map = 3948955270587
Time elapsed for MD Map = 3948955270589
Time elapsed for Save History = 3948955270591
Time elapsed for Save Attachment = 3948955270593
Time elapsed for After Save WF Exec = 3948955270610
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"19479000008767"}]}
Savedata webservice completed
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=SDO_Ladnoo_PRO
Param Type = c
calledon=17/02/2025 11:59:55
Param Type = c
callfinished=17/02/2025 12:01:10
Param Type = c
structname=trcmf
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=success
Param Type = n
timetaken=74774
Param Type = n
dbtimetaken=67662
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