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_jayal827ccb0eea8a706c4c34a16891f84e7b![]()
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_jayal
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_jayal
Time elapsed = 12
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_jayal
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_jayal
Time elapsed = 9
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_jayal
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_jayal
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 12122000000085
Result = 12122000000085
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_jayal
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 3349
Result = 3349
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_jayal
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_jayal
Result = SDO_jayal
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_jayal
Time elapsed = 13
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10208
Result = 10208
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 = 7
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_jayal
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_jayal
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Nagaur
Result = Nagaur
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_jayal
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_jayal
Time elapsed = 8
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=3349
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=3349
Time elapsed = 9
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_jayal
Time elapsed = 8
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_jayal
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_jayal
Time elapsed = 10
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_reader
Result = court_reader
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 5
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_jayal
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_jayal
Time elapsed = 13
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 8
Result = 8
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 7
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 9
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_reader,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 = 5
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : trcmf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 6
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 = 10208
hearing_date = 19/11/2024
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 3
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008420
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
hearing_date = 19/11/2024
courtcode = 10208
Posting record
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:35:59
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:35:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
courtcode=10208
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 = 6
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 = 4
RecordId = 11628000008421
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2022/169
isadjourn = NO
adjourn_type = 0
trn_rcms_caseid = 17690000006655
adjourn_remark =
pre_case_purpose = 1000492
court_code = 10208
pre_hear_date = 19/11/2024
next_hear_date = 06/12/2024
new_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=11628000008421
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:35:59
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:35:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2022/169
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=17690000006655
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=10208
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = c
next_hear_date=06/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
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,case_no,isadjourn,adjourn_type,trn_rcms_caseid,adjourn_remark,pre_case_purpose,court_code,pre_hear_date,next_hear_date,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,:case_no,:isadjourn,:adjourn_type,:trn_rcms_caseid,null,:pre_case_purpose,: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,: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 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008422
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
pre_case_purpose = 1000492
new_case_purpose = 1000492
pre_hear_date = 19/11/2024
court_code = 10208
case_no = 2023/378
trn_rcms_caseid = 10452000006776
adjourn_type = 0
adjourn_remark =
next_hear_date = 24/12/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=11628000008422
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:00
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = c
court_code=10208
Param Type = c
case_no=2023/378
Param Type = c
trn_rcms_caseid=10452000006776
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
isadjourn=NO
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,pre_case_purpose,new_case_purpose,pre_hear_date,court_code,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,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,:pre_case_purpose,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,:adjourn_type,null,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 = 6
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008423
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 9
next_hear_date = 24/12/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/403
court_code = 10208
trn_rcms_caseid = 12386000007982
pre_case_purpose = 1000492
pre_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=11628000008423
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:00
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/403
Param Type = c
court_code=10208
Param Type = c
trn_rcms_caseid=12386000007982
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=19/11/2024 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 = 7
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 = 5
RecordId = 11628000008424
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 7
pre_hear_date = 19/11/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 17249000007227
court_code = 10208
case_no = 2023/409
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 24/12/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=11628000008424
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:00
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=17249000007227
Param Type = c
court_code=10208
Param Type = c
case_no=2023/409
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=24/12/2024 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,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 = 6
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 11628000008425
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 24/12/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/423
court_code = 10208
trn_rcms_caseid = 14240000007698
pre_case_purpose = 1000492
pre_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=11628000008425
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:00
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/423
Param Type = c
court_code=10208
Param Type = c
trn_rcms_caseid=14240000007698
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=19/11/2024 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 = 6
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008426
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 24/12/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/424
court_code = 10208
trn_rcms_caseid = 14297000007696
pre_case_purpose = 1000492
pre_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=11628000008426
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:00
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/424
Param Type = c
court_code=10208
Param Type = c
trn_rcms_caseid=14297000007696
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=19/11/2024 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,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 = 7
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008427
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 24/12/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/425
court_code = 10208
trn_rcms_caseid = 14328000008107
pre_case_purpose = 1000492
pre_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=11628000008427
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:00
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/425
Param Type = c
court_code=10208
Param Type = c
trn_rcms_caseid=14328000008107
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=19/11/2024 00:00:00
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,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 = 7
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 = 4
RecordId = 11628000008428
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 27/11/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/440
court_code = 10208
trn_rcms_caseid = 12084000008456
pre_case_purpose = 1000492
pre_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=11628000008428
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:00
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=27/11/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/440
Param Type = c
court_code=10208
Param Type = c
trn_rcms_caseid=12084000008456
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=19/11/2024 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,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 = 5
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008429
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 8
next_hear_date = 24/12/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/47
court_code = 10208
trn_rcms_caseid = 10889000007056
pre_case_purpose = 1000492
pre_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=11628000008429
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:00
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/47
Param Type = c
court_code=10208
Param Type = c
trn_rcms_caseid=10889000007056
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=19/11/2024 00:00:00
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,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 = 6
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 = 5
RecordId = 11628000008430
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 19/11/2024
pre_case_purpose = 1000492
court_code = 10208
case_no = 2023/66
trn_rcms_caseid = 16531000006549
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 24/12/2024
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=11628000008430
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:00
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=10208
Param Type = c
case_no=2023/66
Param Type = c
trn_rcms_caseid=16531000006549
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=24/12/2024 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,pre_case_purpose,court_code,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,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,: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 = 5
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 = 4
RecordId = 11628000008431
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 24/12/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/320
trn_rcms_caseid = 14411000009300
court_code = 10208
pre_case_purpose = 1000492
pre_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=11628000008431
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:01
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/320
Param Type = c
trn_rcms_caseid=14411000009300
Param Type = c
court_code=10208
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=19/11/2024 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,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,trn_rcms_caseid,court_code,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,:trn_rcms_caseid,:court_code,: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 = 5
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 = 4
RecordId = 11628000008432
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
court_code = 10208
case_no = 2022/82
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
next_hear_date = 25/11/2024
adjourn_remark =
adjourn_type = 0
isadjourn = NO
trn_rcms_caseid = 17606000005733
pre_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=11628000008432
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:01
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10208
Param Type = c
case_no=2022/82
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=25/11/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=17606000005733
Param Type = c
pre_hear_date=19/11/2024 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,court_code,case_no,pre_case_purpose,new_case_purpose,next_hear_date,adjourn_remark,adjourn_type,isadjourn,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,:court_code,:case_no,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:isadjourn,: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 = 7
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 = 11628000008433
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trn_rcms_caseid = 12133000008066
court_code = 10208
adjourn_remark =
adjourn_type = 0
isadjourn = NO
next_hear_date = 06/12/2024
new_case_purpose = 18678000000000
pre_hear_date = 19/11/2024
pre_case_purpose = 18678000000000
case_no = 2023/193
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=11628000008433
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:01
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=12133000008066
Param Type = c
court_code=10208
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=06/12/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2023/193
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,trn_rcms_caseid,court_code,adjourn_remark,adjourn_type,isadjourn,next_hear_date,new_case_purpose,pre_hear_date,pre_case_purpose,case_no,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,:court_code,null,:adjourn_type,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 4
RecordId = 11628000008434
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 06/12/2024
case_no = 2023/194
court_code = 10208
trn_rcms_caseid = 12135000008044
pre_case_purpose = 18678000000000
pre_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=11628000008434
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:01
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:01
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=06/12/2024 00:00:00
Param Type = c
case_no=2023/194
Param Type = c
court_code=10208
Param Type = c
trn_rcms_caseid=12135000008044
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=19/11/2024 00:00:00
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,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 = 6
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 = 5
RecordId = 11628000008435
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 19/11/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 12282000008873
court_code = 10208
case_no = 2023/222
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 24/12/2024
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=11628000008435
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:01
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=12282000008873
Param Type = c
court_code=10208
Param Type = c
case_no=2023/222
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=24/12/2024 00:00:00
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,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 = 7
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 = 4
RecordId = 11628000008436
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 19/11/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16788000006857
court_code = 10208
case_no = 2023/253
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 20/11/2024
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=11628000008436
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:01
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16788000006857
Param Type = c
court_code=10208
Param Type = c
case_no=2023/253
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/11/2024 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 = 5
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 = 3
RecordId = 11628000008437
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 24/12/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/257
court_code = 10208
trn_rcms_caseid = 17904000007795
pre_case_purpose = 18678000000000
pre_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=11628000008437
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:01
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/12/2024 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/257
Param Type = c
court_code=10208
Param Type = c
trn_rcms_caseid=17904000007795
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=19/11/2024 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 = 7
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 = 4
RecordId = 11628000008438
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 19/11/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 18000000009124
court_code = 10208
case_no = 2023/258
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 24/12/2024
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=11628000008438
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:01
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=18000000009124
Param Type = c
court_code=10208
Param Type = c
case_no=2023/258
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=24/12/2024 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_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 = 5
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 = 4
RecordId = 11628000008439
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
pre_case_purpose = 18678000000000
court_code = 10208
pre_hear_date = 19/11/2024
case_no = 2023/344
trn_rcms_caseid = 14997000008134
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 24/12/2024
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=11628000008439
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:01
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=10208
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/344
Param Type = c
trn_rcms_caseid=14997000008134
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=24/12/2024 00:00:00
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,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 = 5
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008440
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
adjourn_type = 0
pre_case_purpose = 18678000000000
isadjourn = NO
next_hear_date = 24/12/2024
new_case_purpose = 18678000000000
pre_hear_date = 19/11/2024
court_code = 10208
case_no = 2023/367
trn_rcms_caseid = 14361000007569
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=11628000008440
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:02
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = c
court_code=10208
Param Type = c
case_no=2023/367
Param Type = c
trn_rcms_caseid=14361000007569
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,adjourn_type,pre_case_purpose,isadjourn,next_hear_date,new_case_purpose,pre_hear_date,court_code,case_no,trn_rcms_caseid,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,:pre_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 4
RecordId = 11628000008441
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 24/12/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
case_no = 2023/368
trn_rcms_caseid = 14396000007633
pre_hear_date = 19/11/2024
court_code = 10208
adjourn_remark =
adjourn_type = 0
isadjourn = NO
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=11628000008441
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:02
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2023/368
Param Type = c
trn_rcms_caseid=14396000007633
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = c
court_code=10208
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
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,next_hear_date,new_case_purpose,pre_case_purpose,case_no,trn_rcms_caseid,pre_hear_date,court_code,adjourn_remark,adjourn_type,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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,null,:adjourn_type,:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
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 = 4
RecordId = 11628000008442
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trn_rcms_caseid = 12116000008574
new_case_purpose = 18678000000000
next_hear_date = 27/11/2024
pre_case_purpose = 18678000000000
court_code = 10208
case_no = 2023/441
pre_hear_date = 19/11/2024
adjourn_type = 0
isadjourn = NO
adjourn_remark =
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=11628000008442
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:02
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=12116000008574
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=27/11/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=10208
Param Type = c
case_no=2023/441
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
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,trn_rcms_caseid,new_case_purpose,next_hear_date,pre_case_purpose,court_code,case_no,pre_hear_date,adjourn_type,isadjourn,adjourn_remark,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,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 4
RecordId = 11628000008443
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 24/12/2024
isadjourn = NO
new_case_purpose = 18678000000000
pre_hear_date = 19/11/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 11658000008079
court_code = 10208
adjourn_remark =
case_no = 2023/445
adjourn_type = 0
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=11628000008443
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:02
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=11658000008079
Param Type = c
court_code=10208
Param Type = c
case_no=2023/445
Param Type = c
adjourn_type=0
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,next_hear_date,isadjourn,new_case_purpose,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,adjourn_remark,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,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,null,:case_no,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 4
RecordId = 11628000008444
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 19/11/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 19889000007299
court_code = 10208
case_no = 2023/455
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 24/12/2024
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=11628000008444
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:02
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=19889000007299
Param Type = c
court_code=10208
Param Type = c
case_no=2023/455
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=24/12/2024 00:00:00
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,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 = 6
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 = 5
RecordId = 11628000008445
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 19/11/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 19943000008654
court_code = 10208
case_no = 2023/456
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 24/12/2024
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=11628000008445
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:02
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=19943000008654
Param Type = c
court_code=10208
Param Type = c
case_no=2023/456
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=24/12/2024 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,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 = 5
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 = 4
RecordId = 11628000008446
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 24/12/2024
new_case_purpose = 18678000000000
adjourn_type = 0
isadjourn = NO
pre_case_purpose = 18678000000000
case_no = 2023/464
court_code = 10208
pre_hear_date = 19/11/2024
trn_rcms_caseid = 12413000008546
adjourn_remark =
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=11628000008446
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:02
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2023/464
Param Type = c
court_code=10208
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = c
trn_rcms_caseid=12413000008546
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,new_case_purpose,adjourn_type,isadjourn,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,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,:adjourn_type,:isadjourn,:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008447
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
new_case_purpose = 18678000000000
next_hear_date = 24/12/2024
trn_rcms_caseid = 12494000007249
pre_hear_date = 19/11/2024
pre_case_purpose = 18678000000000
adjourn_type = 0
adjourn_remark =
isadjourn = NO
court_code = 10208
case_no = 2023/465
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=11628000008447
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:02
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
trn_rcms_caseid=12494000007249
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
court_code=10208
Param Type = c
case_no=2023/465
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,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_hear_date,pre_case_purpose,adjourn_type,adjourn_remark,isadjourn,court_code,case_no,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,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:adjourn_type,null,:isadjourn,:court_code,:case_no,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 27
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 = 5
RecordId = 11628000008448
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 19/11/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 12604000008098
court_code = 10208
case_no = 2023/469
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 24/12/2024
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=11628000008448
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:02
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=12604000008098
Param Type = c
court_code=10208
Param Type = c
case_no=2023/469
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=24/12/2024 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,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 = 5
Adding new record to store data from Frame 2, Row 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 11628000008449
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 19/11/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 12687000009002
court_code = 10208
case_no = 2023/471
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 24/12/2024
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=11628000008449
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:02
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=12687000009002
Param Type = c
court_code=10208
Param Type = c
case_no=2023/471
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=29
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 = 7
Adding new record to store data from Frame 2, Row 30 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008450
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 7
adjourn_remark =
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
isadjourn = NO
next_hear_date = 24/12/2024
case_no = 2023/472
court_code = 10208
pre_hear_date = 19/11/2024
trn_rcms_caseid = 12741000008060
adjourn_type = 0
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=11628000008450
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:03
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
case_no=2023/472
Param Type = c
court_code=10208
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = c
trn_rcms_caseid=12741000008060
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,new_case_purpose,pre_case_purpose,isadjourn,next_hear_date,case_no,court_code,pre_hear_date,trn_rcms_caseid,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,null,:new_case_purpose,:pre_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 31 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008451
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trn_rcms_caseid = 16520000008008
case_no = 2023/57
pre_case_purpose = 18678000000000
pre_hear_date = 19/11/2024
next_hear_date = 24/12/2024
adjourn_type = 0
isadjourn = NO
adjourn_remark =
court_code = 10208
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=11628000008451
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:03
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=16520000008008
Param Type = c
case_no=2023/57
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
court_code=10208
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=31
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,pre_case_purpose,pre_hear_date,next_hear_date,adjourn_type,isadjourn,adjourn_remark,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,:trn_rcms_caseid,:case_no,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:court_code,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 32 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008452
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 9
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 14508000007731
pre_hear_date = 19/11/2024
court_code = 10208
case_no = 2023/6
next_hear_date = 24/12/2024
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=11628000008452
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:03
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=14508000007731
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = c
court_code=10208
Param Type = c
case_no=2023/6
Param Type = c
next_hear_date=24/12/2024 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=32
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 = 5
Adding new record to store data from Frame 2, Row 33 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008453
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark =
pre_hear_date = 19/11/2024
trn_rcms_caseid = 13155000007472
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
next_hear_date = 24/12/2024
isadjourn = NO
case_no = 2023/68
court_code = 10208
TRN_RCMS_HEARINGrow = 33
Posting record
Param Type = n
trn_rcms_hearingid=11628000008453
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:03
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = c
trn_rcms_caseid=13155000007472
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2023/68
Param Type = c
court_code=10208
Param Type = n
trn_rcms_hearingrow=33
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,pre_hear_date,trn_rcms_caseid,new_case_purpose,pre_case_purpose,next_hear_date,isadjourn,case_no,court_code,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,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 34 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 11628000008454
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 10
adjourn_type = 0
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 19404000006982
case_no = 2023/74
court_code = 10208
pre_hear_date = 19/11/2024
next_hear_date = 24/12/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 34
Posting record
Param Type = n
trn_rcms_hearingid=11628000008454
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:03
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:03
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=19404000006982
Param Type = c
case_no=2023/74
Param Type = c
court_code=10208
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=34
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 = 6
Adding new record to store data from Frame 2, Row 35 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008455
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 8
isadjourn = NO
adjourn_type = 0
adjourn_remark =
case_no = 2023/75
court_code = 10208
pre_hear_date = 19/11/2024
trn_rcms_caseid = 19491000007640
next_hear_date = 24/12/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 35
Posting record
Param Type = n
trn_rcms_hearingid=11628000008455
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:03
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:03
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
case_no=2023/75
Param Type = c
court_code=10208
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = c
trn_rcms_caseid=19491000007640
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=35
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,case_no,court_code,pre_hear_date,trn_rcms_caseid,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,:case_no,:court_code,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'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 36 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008456
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 24/12/2024
trn_rcms_caseid = 18597000008553
case_no = 2023/82
court_code = 10208
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 36
Posting record
Param Type = n
trn_rcms_hearingid=11628000008456
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:03
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:03
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=24/12/2024 00:00:00
Param Type = c
trn_rcms_caseid=18597000008553
Param Type = c
case_no=2023/82
Param Type = c
court_code=10208
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=36
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,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,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),: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 = 5
Adding new record to store data from Frame 2, Row 37 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 11628000008457
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 24/12/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 18634000007414
court_code = 10208
case_no = 2023/83
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 37
Posting record
Param Type = n
trn_rcms_hearingid=11628000008457
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:03
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18634000007414
Param Type = c
court_code=10208
Param Type = c
case_no=2023/83
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=37
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,court_code,case_no,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,:court_code,:case_no,: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 = 5
Adding new record to store data from Frame 2, Row 38 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008458
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 24/12/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18678000000000
case_no = 2024/121
court_code = 10208
trn_rcms_caseid = 16726000007517
pre_case_purpose = 18678000000000
pre_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 38
Posting record
Param Type = n
trn_rcms_hearingid=11628000008458
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:03
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
case_no=2024/121
Param Type = c
court_code=10208
Param Type = c
trn_rcms_caseid=16726000007517
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=38
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 = 6
Adding new record to store data from Frame 2, Row 39 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008459
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 24/12/2024
new_case_purpose = 18678000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2024/330
court_code = 10208
trn_rcms_caseid = 15002000008658
pre_case_purpose = 18678000000000
pre_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 39
Posting record
Param Type = n
trn_rcms_hearingid=11628000008459
Param Type = n
trn_rcms_mhearingid=11628000008420
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:04
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:04
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/12/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/330
Param Type = c
court_code=10208
Param Type = c
trn_rcms_caseid=15002000008658
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=19/11/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=39
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 = 3941192163549
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17690000006655 idvalue 0
Mapped case_no Row = 1 value = 2022/169 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 06/12/2024 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 = 10208
trn_rcms_caseregid = 17690000006655
case_no = 2022/169
prev_hearing_date = 19/11/2024
hearing_date = 06/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purposename=?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????
Time elapsed = 6
prev_case_purpose after validation = 1000492
case_purpose = 1000492
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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008460
MapName trcmf1
SourceId 11628000008421
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 06/12/2024
case_no = 2022/169
trn_rcms_caseregid = 17690000006655
court_code = 10208
case_purpose = 1000492
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008460
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008421
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:04
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:04
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=1000492
Param Type = c
hearing_date=06/12/2024 00:00:00
Param Type = c
case_no=2022/169
Param Type = c
trn_rcms_caseregid=17690000006655
Param Type = c
court_code=10208
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10452000006776 idvalue 0
Mapped case_no Row = 1 value = 2023/378 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/12/2024 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 = 10208
trn_rcms_caseregid = 10452000006776
case_no = 2023/378
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
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 = 15
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008461
MapName trcmf1
SourceId 11628000008422
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/12/2024
case_no = 2023/378
trn_rcms_caseregid = 10452000006776
court_code = 10208
case_purpose = 1000492
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008461
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008422
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:06
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:06
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=1000492
Param Type = c
hearing_date=24/12/2024 00:00:00
Param Type = c
case_no=2023/378
Param Type = c
trn_rcms_caseregid=10452000006776
Param Type = c
court_code=10208
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12386000007982 idvalue 0
Mapped case_no Row = 1 value = 2023/403 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/12/2024 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 = 10208
trn_rcms_caseregid = 12386000007982
case_no = 2023/403
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
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 = 3
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 = 6
RecordId = 11628000008462
MapName trcmf1
SourceId 11628000008423
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/12/2024
case_no = 2023/403
trn_rcms_caseregid = 12386000007982
court_code = 10208
case_purpose = 1000492
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008462
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008423
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:08
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:08
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=1000492
Param Type = c
hearing_date=24/12/2024 00:00:00
Param Type = c
case_no=2023/403
Param Type = c
trn_rcms_caseregid=12386000007982
Param Type = c
court_code=10208
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17249000007227 idvalue 0
Mapped case_no Row = 1 value = 2023/409 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/12/2024 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 = 10208
trn_rcms_caseregid = 17249000007227
case_no = 2023/409
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 11628000008463
MapName trcmf1
SourceId 11628000008424
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/12/2024
case_no = 2023/409
trn_rcms_caseregid = 17249000007227
court_code = 10208
case_purpose = 1000492
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008463
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008424
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:10
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:10
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=1000492
Param Type = c
hearing_date=24/12/2024 00:00:00
Param Type = c
case_no=2023/409
Param Type = c
trn_rcms_caseregid=17249000007227
Param Type = c
court_code=10208
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14240000007698 idvalue 0
Mapped case_no Row = 1 value = 2023/423 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/12/2024 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 = 10208
trn_rcms_caseregid = 14240000007698
case_no = 2023/423
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
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 = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008464
MapName trcmf1
SourceId 11628000008425
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/12/2024
case_no = 2023/423
trn_rcms_caseregid = 14240000007698
court_code = 10208
case_purpose = 1000492
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008464
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008425
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:12
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:12
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=1000492
Param Type = c
hearing_date=24/12/2024 00:00:00
Param Type = c
case_no=2023/423
Param Type = c
trn_rcms_caseregid=14240000007698
Param Type = c
court_code=10208
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14297000007696 idvalue 0
Mapped case_no Row = 1 value = 2023/424 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/12/2024 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 = 10208
trn_rcms_caseregid = 14297000007696
case_no = 2023/424
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
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 = 209
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 11628000008465
MapName trcmf1
SourceId 11628000008426
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/12/2024
case_no = 2023/424
trn_rcms_caseregid = 14297000007696
court_code = 10208
case_purpose = 1000492
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008465
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008426
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:15
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:15
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=1000492
Param Type = c
hearing_date=24/12/2024 00:00:00
Param Type = c
case_no=2023/424
Param Type = c
trn_rcms_caseregid=14297000007696
Param Type = c
court_code=10208
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14328000008107 idvalue 0
Mapped case_no Row = 1 value = 2023/425 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/12/2024 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 = 10208
trn_rcms_caseregid = 14328000008107
case_no = 2023/425
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
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 = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008466
MapName trcmf1
SourceId 11628000008427
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/12/2024
case_no = 2023/425
trn_rcms_caseregid = 14328000008107
court_code = 10208
case_purpose = 1000492
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008466
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008427
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:17
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:17
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=1000492
Param Type = c
hearing_date=24/12/2024 00:00:00
Param Type = c
case_no=2023/425
Param Type = c
trn_rcms_caseregid=14328000008107
Param Type = c
court_code=10208
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12084000008456 idvalue 0
Mapped case_no Row = 1 value = 2023/440 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 27/11/2024 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 = 10208
trn_rcms_caseregid = 12084000008456
case_no = 2023/440
prev_hearing_date = 19/11/2024
hearing_date = 27/11/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008467
MapName trcmf1
SourceId 11628000008428
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 27/11/2024
case_no = 2023/440
trn_rcms_caseregid = 12084000008456
court_code = 10208
case_purpose = 1000492
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008467
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008428
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:19
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:19
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=1000492
Param Type = c
hearing_date=27/11/2024 00:00:00
Param Type = c
case_no=2023/440
Param Type = c
trn_rcms_caseregid=12084000008456
Param Type = c
court_code=10208
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10889000007056 idvalue 0
Mapped case_no Row = 1 value = 2023/47 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/12/2024 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 = 10208
trn_rcms_caseregid = 10889000007056
case_no = 2023/47
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
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 = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008468
MapName trcmf1
SourceId 11628000008429
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/12/2024
case_no = 2023/47
trn_rcms_caseregid = 10889000007056
court_code = 10208
case_purpose = 1000492
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008468
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008429
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:20
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=1000492
Param Type = c
hearing_date=24/12/2024 00:00:00
Param Type = c
case_no=2023/47
Param Type = c
trn_rcms_caseregid=10889000007056
Param Type = c
court_code=10208
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16531000006549 idvalue 0
Mapped case_no Row = 1 value = 2023/66 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/12/2024 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 = 10208
trn_rcms_caseregid = 16531000006549
case_no = 2023/66
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
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 = 18
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008469
MapName trcmf1
SourceId 11628000008430
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/12/2024
case_no = 2023/66
trn_rcms_caseregid = 16531000006549
court_code = 10208
case_purpose = 1000492
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008469
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008430
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:22
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:22
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=1000492
Param Type = c
hearing_date=24/12/2024 00:00:00
Param Type = c
case_no=2023/66
Param Type = c
trn_rcms_caseregid=16531000006549
Param Type = c
court_code=10208
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14411000009300 idvalue 0
Mapped case_no Row = 1 value = 2024/320 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/12/2024 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 = 10208
trn_rcms_caseregid = 14411000009300
case_no = 2024/320
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
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 = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008470
MapName trcmf1
SourceId 11628000008431
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/12/2024
case_no = 2024/320
trn_rcms_caseregid = 14411000009300
court_code = 10208
case_purpose = 1000492
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008470
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008431
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:24
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:24
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=1000492
Param Type = c
hearing_date=24/12/2024 00:00:00
Param Type = c
case_no=2024/320
Param Type = c
trn_rcms_caseregid=14411000009300
Param Type = c
court_code=10208
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17606000005733 idvalue 0
Mapped case_no Row = 1 value = 2022/82 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/11/2024 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 = 10208
trn_rcms_caseregid = 17606000005733
case_no = 2022/82
prev_hearing_date = 19/11/2024
hearing_date = 25/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 7
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 11628000008471
MapName trcmf1
SourceId 11628000008432
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 25/11/2024
case_no = 2022/82
trn_rcms_caseregid = 17606000005733
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008471
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008432
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:26
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=25/11/2024 00:00:00
Param Type = c
case_no=2022/82
Param Type = c
trn_rcms_caseregid=17606000005733
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12133000008066 idvalue 0
Mapped case_no Row = 1 value = 2023/193 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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 = 06/12/2024 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 = 10208
trn_rcms_caseregid = 12133000008066
case_no = 2023/193
prev_hearing_date = 19/11/2024
hearing_date = 06/12/2024
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 = 4
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 = 4
RecordId = 11628000008472
MapName trcmf1
SourceId 11628000008433
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 06/12/2024
case_no = 2023/193
trn_rcms_caseregid = 12133000008066
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008472
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008433
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:28
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=06/12/2024 00:00:00
Param Type = c
case_no=2023/193
Param Type = c
trn_rcms_caseregid=12133000008066
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12135000008044 idvalue 0
Mapped case_no Row = 1 value = 2023/194 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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 = 06/12/2024 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 = 10208
trn_rcms_caseregid = 12135000008044
case_no = 2023/194
prev_hearing_date = 19/11/2024
hearing_date = 06/12/2024
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008473
MapName trcmf1
SourceId 11628000008434
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 208
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 06/12/2024
case_no = 2023/194
trn_rcms_caseregid = 12135000008044
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008473
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008434
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:30
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=06/12/2024 00:00:00
Param Type = c
case_no=2023/194
Param Type = c
trn_rcms_caseregid=12135000008044
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12282000008873 idvalue 0
Mapped case_no Row = 1 value = 2023/222 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 12282000008873
case_no = 2023/222
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008474
MapName trcmf1
SourceId 11628000008435
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/222
trn_rcms_caseregid = 12282000008873
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008474
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008435
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:33
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:33
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/12/2024 00:00:00
Param Type = c
case_no=2023/222
Param Type = c
trn_rcms_caseregid=12282000008873
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16788000006857 idvalue 0
Mapped case_no Row = 1 value = 2023/253 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/11/2024 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 = 10208
trn_rcms_caseregid = 16788000006857
case_no = 2023/253
prev_hearing_date = 19/11/2024
hearing_date = 20/11/2024
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008475
MapName trcmf1
SourceId 11628000008436
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 20/11/2024
case_no = 2023/253
trn_rcms_caseregid = 16788000006857
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008475
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008436
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:35
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=20/11/2024 00:00:00
Param Type = c
case_no=2023/253
Param Type = c
trn_rcms_caseregid=16788000006857
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17904000007795 idvalue 0
Mapped case_no Row = 1 value = 2023/257 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 17904000007795
case_no = 2023/257
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008476
MapName trcmf1
SourceId 11628000008437
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/257
trn_rcms_caseregid = 17904000007795
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008476
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008437
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:37
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=24/12/2024 00:00:00
Param Type = c
case_no=2023/257
Param Type = c
trn_rcms_caseregid=17904000007795
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18000000009124 idvalue 0
Mapped case_no Row = 1 value = 2023/258 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 18000000009124
case_no = 2023/258
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008477
MapName trcmf1
SourceId 11628000008438
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/258
trn_rcms_caseregid = 18000000009124
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008477
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008438
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:39
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=24/12/2024 00:00:00
Param Type = c
case_no=2023/258
Param Type = c
trn_rcms_caseregid=18000000009124
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14997000008134 idvalue 0
Mapped case_no Row = 1 value = 2023/344 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 14997000008134
case_no = 2023/344
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 4
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 = 7
RecordId = 11628000008478
MapName trcmf1
SourceId 11628000008439
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/344
trn_rcms_caseregid = 14997000008134
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008478
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008439
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:41
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=24/12/2024 00:00:00
Param Type = c
case_no=2023/344
Param Type = c
trn_rcms_caseregid=14997000008134
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14361000007569 idvalue 0
Mapped case_no Row = 1 value = 2023/367 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 14361000007569
case_no = 2023/367
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 11628000008479
MapName trcmf1
SourceId 11628000008440
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/367
trn_rcms_caseregid = 14361000007569
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008479
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008440
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:43
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36:43
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/12/2024 00:00:00
Param Type = c
case_no=2023/367
Param Type = c
trn_rcms_caseregid=14361000007569
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14396000007633 idvalue 0
Mapped case_no Row = 1 value = 2023/368 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 14396000007633
case_no = 2023/368
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008480
MapName trcmf1
SourceId 11628000008441
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/368
trn_rcms_caseregid = 14396000007633
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008480
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008441
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:45
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=24/12/2024 00:00:00
Param Type = c
case_no=2023/368
Param Type = c
trn_rcms_caseregid=14396000007633
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12116000008574 idvalue 0
Mapped case_no Row = 1 value = 2023/441 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/11/2024 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 = 10208
trn_rcms_caseregid = 12116000008574
case_no = 2023/441
prev_hearing_date = 19/11/2024
hearing_date = 27/11/2024
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008481
MapName trcmf1
SourceId 11628000008442
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 27/11/2024
case_no = 2023/441
trn_rcms_caseregid = 12116000008574
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008481
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008442
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:47
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=27/11/2024 00:00:00
Param Type = c
case_no=2023/441
Param Type = c
trn_rcms_caseregid=12116000008574
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11658000008079 idvalue 0
Mapped case_no Row = 1 value = 2023/445 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 11658000008079
case_no = 2023/445
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008482
MapName trcmf1
SourceId 11628000008443
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/445
trn_rcms_caseregid = 11658000008079
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008482
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008443
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:49
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=24/12/2024 00:00:00
Param Type = c
case_no=2023/445
Param Type = c
trn_rcms_caseregid=11658000008079
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19889000007299 idvalue 0
Mapped case_no Row = 1 value = 2023/455 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 19889000007299
case_no = 2023/455
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008483
MapName trcmf1
SourceId 11628000008444
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/455
trn_rcms_caseregid = 19889000007299
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008483
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008444
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:51
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=24/12/2024 00:00:00
Param Type = c
case_no=2023/455
Param Type = c
trn_rcms_caseregid=19889000007299
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19943000008654 idvalue 0
Mapped case_no Row = 1 value = 2023/456 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 19943000008654
case_no = 2023/456
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008484
MapName trcmf1
SourceId 11628000008445
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/456
trn_rcms_caseregid = 19943000008654
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008484
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008445
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:53
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=24/12/2024 00:00:00
Param Type = c
case_no=2023/456
Param Type = c
trn_rcms_caseregid=19943000008654
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12413000008546 idvalue 0
Mapped case_no Row = 1 value = 2023/464 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 12413000008546
case_no = 2023/464
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008485
MapName trcmf1
SourceId 11628000008446
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/464
trn_rcms_caseregid = 12413000008546
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008485
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008446
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:55
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=24/12/2024 00:00:00
Param Type = c
case_no=2023/464
Param Type = c
trn_rcms_caseregid=12413000008546
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12494000007249 idvalue 0
Mapped case_no Row = 1 value = 2023/465 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 12494000007249
case_no = 2023/465
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008486
MapName trcmf1
SourceId 11628000008447
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/465
trn_rcms_caseregid = 12494000007249
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008486
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008447
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:57
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=24/12/2024 00:00:00
Param Type = c
case_no=2023/465
Param Type = c
trn_rcms_caseregid=12494000007249
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12604000008098 idvalue 0
Mapped case_no Row = 1 value = 2023/469 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 12604000008098
case_no = 2023/469
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008487
MapName trcmf1
SourceId 11628000008448
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/469
trn_rcms_caseregid = 12604000008098
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008487
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008448
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:36:58
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:36: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=24/12/2024 00:00:00
Param Type = c
case_no=2023/469
Param Type = c
trn_rcms_caseregid=12604000008098
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 29
>>Mapping
Mapped court_code Row = 1 value = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12687000009002 idvalue 0
Mapped case_no Row = 1 value = 2023/471 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 12687000009002
case_no = 2023/471
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 11628000008488
MapName trcmf1
SourceId 11628000008449
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/471
trn_rcms_caseregid = 12687000009002
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008488
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008449
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:37:00
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:37:00
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/12/2024 00:00:00
Param Type = c
case_no=2023/471
Param Type = c
trn_rcms_caseregid=12687000009002
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 30
>>Mapping
Mapped court_code Row = 1 value = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12741000008060 idvalue 0
Mapped case_no Row = 1 value = 2023/472 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 12741000008060
case_no = 2023/472
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 4
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 = 5
RecordId = 11628000008489
MapName trcmf1
SourceId 11628000008450
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/472
trn_rcms_caseregid = 12741000008060
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008489
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008450
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:37:02
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:37:02
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/12/2024 00:00:00
Param Type = c
case_no=2023/472
Param Type = c
trn_rcms_caseregid=12741000008060
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 31
>>Mapping
Mapped court_code Row = 1 value = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16520000008008 idvalue 0
Mapped case_no Row = 1 value = 2023/57 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 16520000008008
case_no = 2023/57
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008490
MapName trcmf1
SourceId 11628000008451
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/57
trn_rcms_caseregid = 16520000008008
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008490
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008451
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:37:04
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:37:04
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/12/2024 00:00:00
Param Type = c
case_no=2023/57
Param Type = c
trn_rcms_caseregid=16520000008008
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 32
>>Mapping
Mapped court_code Row = 1 value = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14508000007731 idvalue 0
Mapped case_no Row = 1 value = 2023/6 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 14508000007731
case_no = 2023/6
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 11628000008491
MapName trcmf1
SourceId 11628000008452
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/6
trn_rcms_caseregid = 14508000007731
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008491
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008452
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:37:06
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:37:06
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/12/2024 00:00:00
Param Type = c
case_no=2023/6
Param Type = c
trn_rcms_caseregid=14508000007731
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 33
>>Mapping
Mapped court_code Row = 1 value = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13155000007472 idvalue 0
Mapped case_no Row = 1 value = 2023/68 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 13155000007472
case_no = 2023/68
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008492
MapName trcmf1
SourceId 11628000008453
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/68
trn_rcms_caseregid = 13155000007472
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008492
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008453
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:37:08
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:37:08
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/12/2024 00:00:00
Param Type = c
case_no=2023/68
Param Type = c
trn_rcms_caseregid=13155000007472
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 34
>>Mapping
Mapped court_code Row = 1 value = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19404000006982 idvalue 0
Mapped case_no Row = 1 value = 2023/74 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 19404000006982
case_no = 2023/74
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008493
MapName trcmf1
SourceId 11628000008454
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/74
trn_rcms_caseregid = 19404000006982
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008493
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008454
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:37:10
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:37:10
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/12/2024 00:00:00
Param Type = c
case_no=2023/74
Param Type = c
trn_rcms_caseregid=19404000006982
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 35
>>Mapping
Mapped court_code Row = 1 value = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19491000007640 idvalue 0
Mapped case_no Row = 1 value = 2023/75 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 19491000007640
case_no = 2023/75
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 3
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 = 4
RecordId = 11628000008494
MapName trcmf1
SourceId 11628000008455
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/75
trn_rcms_caseregid = 19491000007640
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008494
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008455
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:37:12
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:37:12
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/12/2024 00:00:00
Param Type = c
case_no=2023/75
Param Type = c
trn_rcms_caseregid=19491000007640
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 36
>>Mapping
Mapped court_code Row = 1 value = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18597000008553 idvalue 0
Mapped case_no Row = 1 value = 2023/82 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 18597000008553
case_no = 2023/82
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 3
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 = 7
RecordId = 11628000008495
MapName trcmf1
SourceId 11628000008456
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/82
trn_rcms_caseregid = 18597000008553
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008495
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008456
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:37:14
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:37:14
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/12/2024 00:00:00
Param Type = c
case_no=2023/82
Param Type = c
trn_rcms_caseregid=18597000008553
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 37
>>Mapping
Mapped court_code Row = 1 value = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18634000007414 idvalue 0
Mapped case_no Row = 1 value = 2023/83 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 18634000007414
case_no = 2023/83
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 11628000008496
MapName trcmf1
SourceId 11628000008457
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2023/83
trn_rcms_caseregid = 18634000007414
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008496
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008457
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:37:17
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:37:17
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/12/2024 00:00:00
Param Type = c
case_no=2023/83
Param Type = c
trn_rcms_caseregid=18634000007414
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 38
>>Mapping
Mapped court_code Row = 1 value = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16726000007517 idvalue 0
Mapped case_no Row = 1 value = 2024/121 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 16726000007517
case_no = 2024/121
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008497
MapName trcmf1
SourceId 11628000008458
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2024/121
trn_rcms_caseregid = 16726000007517
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008497
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008458
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:37:18
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:37:19
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/12/2024 00:00:00
Param Type = c
case_no=2024/121
Param Type = c
trn_rcms_caseregid=16726000007517
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 39
>>Mapping
Mapped court_code Row = 1 value = 10208 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15002000008658 idvalue 0
Mapped case_no Row = 1 value = 2024/330 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/11/2024 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/12/2024 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 = 10208
trn_rcms_caseregid = 15002000008658
case_no = 2024/330
prev_hearing_date = 19/11/2024
hearing_date = 24/12/2024
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 11628000008498
MapName trcmf1
SourceId 11628000008459
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/12/2024
case_no = 2024/330
trn_rcms_caseregid = 15002000008658
court_code = 10208
case_purpose = 18678000000000
prev_hearing_date = 19/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=11628000008498
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=11628000008459
Param Type = c
cancel=F
Param Type = c
createdby=SDO_jayal
Param Type = c
createdon=19/11/2024 15:37:21
Param Type = c
username=SDO_jayal
Param Type = c
modifiedon=19/11/2024 15:37: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=24/12/2024 00:00:00
Param Type = c
case_no=2024/330
Param Type = c
trn_rcms_caseregid=15002000008658
Param Type = c
court_code=10208
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=19/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3941192242443
Time elapsed for MD Map = 3941192242445
Time elapsed for Save History = 3941192242447
Time elapsed for Save Attachment = 3941192242449
Time elapsed for After Save WF Exec = 3941192242455
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"11628000008420"}]}
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_jayal
Param Type = c
calledon=19/11/2024 15:35:58
Param Type = c
callfinished=19/11/2024 15:37:22
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=84117
Param Type = n
dbtimetaken=79617
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