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
gcmssdobaraa827ccb0eea8a706c4c34a16891f84e7b![]()
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=sdobaraa
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=sdobaraa
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = SDO, ???????,?????
Result = SDO, ???????,?????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=sdobaraa
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=sdobaraa
Time elapsed = 6
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=sdobaraa
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=sdobaraa
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 12122000000113
Result = 12122000000113
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=sdobaraa
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1068010008204
Result = 1068010008204
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=sdobaraa
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = sdobaraa
Result = sdobaraa
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=sdobaraa
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10236
Result = 10236
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 = 5
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=sdobaraa
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=sdobaraa
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Baran
Result = Baran
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=sdobaraa
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=sdobaraa
Time elapsed = 5
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=1068010008204
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1068010008204
Time elapsed = 7
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=sdobaraa
Time elapsed = 4
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=sdobaraa
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=sdobaraa
Time elapsed = 9
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=sdobaraa
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=sdobaraa
Time elapsed = 10
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 9
Result = 9
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 = 2
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 5
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 = 3
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : trcmf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 4
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 = 10236
hearing_date = 16/10/2023
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 = 4
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 = 18202000008458
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
hearing_date = 16/10/2023
courtcode = 10236
Posting record
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:34
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=16/10/2023 00:00:00
Param Type = c
courtcode=10236
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 = 3
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 18202000008459
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
court_code = 10236
case_no = 2016/00121
trn_rcms_caseid = 16679000000773
new_case_purpose = 18473000000000
isadjourn = NO
pre_case_purpose = 18473000000000
next_hear_date = 11/01/2024
adjourn_remark =
pre_hear_date = 16/10/2023
adjourn_type = 0
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=18202000008459
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:34
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10236
Param Type = c
case_no=2016/00121
Param Type = c
trn_rcms_caseid=16679000000773
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,case_no,trn_rcms_caseid,new_case_purpose,isadjourn,pre_case_purpose,next_hear_date,adjourn_remark,pre_hear_date,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,:court_code,:case_no,:trn_rcms_caseid,:new_case_purpose,:isadjourn,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),: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 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 18202000008460
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
court_code = 10236
pre_hear_date = 16/10/2023
adjourn_type = 0
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
trn_rcms_caseid = 12482000007278
adjourn_remark =
case_no = 2022/3
isadjourn = NO
next_hear_date = 11/01/2024
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=18202000008460
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:34
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10236
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=12482000007278
Param Type = c
case_no=2022/3
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=11/01/2024 00:00:00
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,court_code,pre_hear_date,adjourn_type,new_case_purpose,pre_case_purpose,trn_rcms_caseid,adjourn_remark,case_no,isadjourn,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,null,:case_no,:isadjourn,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 = 4
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 = 3
RecordId = 18202000008461
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 11/01/2024
new_case_purpose = 1000525
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2016/00109
court_code = 10236
trn_rcms_caseid = 10450000000948
pre_case_purpose = 1000525
pre_hear_date = 16/10/2023
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=18202000008461
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:34
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2016/00109
Param Type = c
court_code=10236
Param Type = c
trn_rcms_caseid=10450000000948
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=16/10/2023 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 = 5
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 18202000008462
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 11/01/2024
new_case_purpose = 1000497
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2016/00119
court_code = 10236
trn_rcms_caseid = 19292000000548
pre_case_purpose = 1000497
pre_hear_date = 16/10/2023
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=18202000008462
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:34
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2016/00119
Param Type = c
court_code=10236
Param Type = c
trn_rcms_caseid=19292000000548
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 4
RecordId = 18202000008463
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 11/01/2024
new_case_purpose = 1000507
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2015/00120
court_code = 10236
trn_rcms_caseid = 11527000001232
pre_case_purpose = 1000507
pre_hear_date = 16/10/2023
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=18202000008463
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:34
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
new_case_purpose=1000507
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2015/00120
Param Type = c
court_code=10236
Param Type = c
trn_rcms_caseid=11527000001232
Param Type = n
pre_case_purpose=1000507
Param Type = c
pre_hear_date=16/10/2023 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 = 4
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 = 4
RecordId = 18202000008464
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 16/10/2023
pre_case_purpose = 1000507
trn_rcms_caseid = 12956000002315
court_code = 10236
case_no = 2018/00370
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000507
next_hear_date = 11/01/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=18202000008464
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:34
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = n
pre_case_purpose=1000507
Param Type = c
trn_rcms_caseid=12956000002315
Param Type = c
court_code=10236
Param Type = c
case_no=2018/00370
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000507
Param Type = c
next_hear_date=11/01/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,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 = 4
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 = 4
RecordId = 18202000008465
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_case_purpose = 1000507
court_code = 10236
pre_hear_date = 16/10/2023
case_no = 2020/00045
trn_rcms_caseid = 11312000003974
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000507
next_hear_date = 11/01/2024
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=18202000008465
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:34
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000507
Param Type = c
court_code=10236
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = c
case_no=2020/00045
Param Type = c
trn_rcms_caseid=11312000003974
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000507
Param Type = c
next_hear_date=11/01/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,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 = 6
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 = 3
RecordId = 18202000008466
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 11/01/2024
new_case_purpose = 1000507
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2020/00129
court_code = 10236
trn_rcms_caseid = 11232000005069
pre_case_purpose = 1000507
pre_hear_date = 16/10/2023
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=18202000008466
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:34
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
new_case_purpose=1000507
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2020/00129
Param Type = c
court_code=10236
Param Type = c
trn_rcms_caseid=11232000005069
Param Type = n
pre_case_purpose=1000507
Param Type = c
pre_hear_date=16/10/2023 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 = 18202000008467
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_case_purpose = 1000507
new_case_purpose = 1000507
next_hear_date = 11/01/2024
pre_hear_date = 16/10/2023
court_code = 10236
case_no = 2021/182
trn_rcms_caseid = 13196000005971
adjourn_remark =
adjourn_type = 0
isadjourn = NO
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=18202000008467
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:35
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000507
Param Type = c
new_case_purpose=1000507
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = c
court_code=10236
Param Type = c
case_no=2021/182
Param Type = c
trn_rcms_caseid=13196000005971
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
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,pre_case_purpose,new_case_purpose,next_hear_date,pre_hear_date,court_code,case_no,trn_rcms_caseid,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,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,null,:adjourn_type,:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 3
RecordId = 18202000008468
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trn_rcms_caseid = 347414
new_case_purpose = 1000490
next_hear_date = 11/01/2024
pre_case_purpose = 1000490
court_code = 10236
case_no = 2013/00166
pre_hear_date = 16/10/2023
adjourn_type = 0
isadjourn = NO
adjourn_remark =
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=18202000008468
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:35
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=347414
Param Type = c
new_case_purpose=1000490
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = n
pre_case_purpose=1000490
Param Type = c
court_code=10236
Param Type = c
case_no=2013/00166
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
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,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 = 3
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 = 3
RecordId = 18202000008469
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 11/01/2024
isadjourn = NO
new_case_purpose = 11417000000000
pre_hear_date = 16/10/2023
pre_case_purpose = 11417000000000
trn_rcms_caseid = 12780000006402
court_code = 10236
adjourn_remark =
case_no = 2022/4
adjourn_type = 0
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=18202000008469
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:35
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=11417000000000
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = n
pre_case_purpose=11417000000000
Param Type = c
trn_rcms_caseid=12780000006402
Param Type = c
court_code=10236
Param Type = c
case_no=2022/4
Param Type = c
adjourn_type=0
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,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 = 4
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 = 3
RecordId = 18202000008470
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 16/10/2023
pre_case_purpose = 18470000000000
trn_rcms_caseid = 347249
court_code = 10236
case_no = 2010/00077
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18470000000000
next_hear_date = 11/01/2024
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=18202000008470
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:35
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = n
pre_case_purpose=18470000000000
Param Type = c
trn_rcms_caseid=347249
Param Type = c
court_code=10236
Param Type = c
case_no=2010/00077
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18470000000000
Param Type = c
next_hear_date=11/01/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,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 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 18202000008471
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 16/10/2023
pre_case_purpose = 18470000000000
trn_rcms_caseid = 347423
court_code = 10236
case_no = 2015/00061
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18470000000000
next_hear_date = 11/01/2024
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=18202000008471
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:35
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = n
pre_case_purpose=18470000000000
Param Type = c
trn_rcms_caseid=347423
Param Type = c
court_code=10236
Param Type = c
case_no=2015/00061
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18470000000000
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 18202000008472
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
court_code = 10236
case_no = 2016/00113
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 11/01/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 13639000001234
pre_hear_date = 16/10/2023
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=18202000008472
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:35
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10236
Param Type = c
case_no=2016/00113
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=13639000001234
Param Type = c
pre_hear_date=16/10/2023 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,court_code,case_no,isadjourn,adjourn_remark,adjourn_type,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:case_no,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 510
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 = 4
RecordId = 18202000008473
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
pre_case_purpose = 18678000000000
trn_rcms_caseid = 13713000000761
court_code = 10236
pre_hear_date = 16/10/2023
new_case_purpose = 18678000000000
adjourn_type = 0
adjourn_remark =
next_hear_date = 11/01/2024
isadjourn = NO
case_no = 2016/00114
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=18202000008473
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:36
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=13713000000761
Param Type = c
court_code=10236
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2016/00114
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_case_purpose,trn_rcms_caseid,court_code,pre_hear_date,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,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,:pre_case_purpose,:trn_rcms_caseid,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 3
RecordId = 18202000008474
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
new_case_purpose = 18678000000000
next_hear_date = 11/01/2024
adjourn_type = 0
isadjourn = NO
adjourn_remark =
trn_rcms_caseid = 15060000002542
court_code = 10236
pre_hear_date = 16/10/2023
case_no = 2018/00375
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=18202000008474
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:36
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:36
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=11/01/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=15060000002542
Param Type = c
court_code=10236
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = c
case_no=2018/00375
Param Type = n
pre_case_purpose=18678000000000
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,new_case_purpose,next_hear_date,adjourn_type,isadjourn,adjourn_remark,trn_rcms_caseid,court_code,pre_hear_date,case_no,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,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:trn_rcms_caseid,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:pre_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 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 18202000008475
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 16/10/2023
pre_case_purpose = 18678000000000
trn_rcms_caseid = 10689000006212
court_code = 10236
case_no = 2022/265
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 11/01/2024
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=18202000008475
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:36
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=10689000006212
Param Type = c
court_code=10236
Param Type = c
case_no=2022/265
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=11/01/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,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 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 18202000008476
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark =
trn_rcms_caseid = 19364000006695
adjourn_type = 0
court_code = 10236
case_no = 2022/282
pre_hear_date = 16/10/2023
new_case_purpose = 18678000000000
next_hear_date = 11/01/2024
pre_case_purpose = 18678000000000
isadjourn = NO
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=18202000008476
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:36
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=19364000006695
Param Type = c
adjourn_type=0
Param Type = c
court_code=10236
Param Type = c
case_no=2022/282
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
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,adjourn_remark,trn_rcms_caseid,adjourn_type,court_code,case_no,pre_hear_date,new_case_purpose,next_hear_date,pre_case_purpose,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,:adjourn_type,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 3
RecordId = 18202000008477
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark =
trn_rcms_caseid = 19525000007316
pre_hear_date = 16/10/2023
court_code = 10236
case_no = 2022/283
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 11/01/2024
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=18202000008477
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:36
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=19525000007316
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = c
court_code=10236
Param Type = c
case_no=2022/283
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=11/01/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,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 3
RecordId = 18202000008478
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 12491000007439
pre_hear_date = 16/10/2023
court_code = 10236
case_no = 2023/105
next_hear_date = 11/01/2024
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=18202000008478
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:36
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=12491000007439
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = c
court_code=10236
Param Type = c
case_no=2023/105
Param Type = c
next_hear_date=11/01/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=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,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 = 4
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 = 3
RecordId = 18202000008479
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 18264000007210
case_no = 2023/33
new_case_purpose = 18678000000000
pre_hear_date = 16/10/2023
next_hear_date = 11/01/2024
isadjourn = NO
court_code = 10236
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=18202000008479
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:36
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18264000007210
Param Type = c
case_no=2023/33
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
court_code=10236
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,new_case_purpose,pre_hear_date,next_hear_date,isadjourn,court_code,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:trn_rcms_caseid,:case_no,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
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 = 305
RecordId = 18202000008480
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_type = 0
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 17745000000571
case_no = 2016/00118
court_code = 10236
pre_hear_date = 16/10/2023
next_hear_date = 11/01/2024
new_case_purpose = 15904000000025
pre_case_purpose = 15904000000025
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=18202000008480
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:36
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:36
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=17745000000571
Param Type = c
case_no=2016/00118
Param Type = c
court_code=10236
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
new_case_purpose=15904000000025
Param Type = n
pre_case_purpose=15904000000025
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,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 = 3
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 = 3
RecordId = 18202000008481
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 8
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 347405
case_no = 2010/00097
court_code = 10236
pre_hear_date = 16/10/2023
next_hear_date = 11/01/2024
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=18202000008481
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:37
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=347405
Param Type = c
case_no=2010/00097
Param Type = c
court_code=10236
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
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,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
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 = 18202000008482
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 11/01/2024
case_no = 2013/00182
court_code = 10236
trn_rcms_caseid = 347482
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
pre_hear_date = 16/10/2023
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=18202000008482
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:37
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:37
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=11/01/2024 00:00:00
Param Type = c
case_no=2013/00182
Param Type = c
court_code=10236
Param Type = c
trn_rcms_caseid=347482
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=16/10/2023 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,isadjourn,adjourn_remark,adjourn_type,next_hear_date,case_no,court_code,trn_rcms_caseid,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 18202000008483
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 11/01/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 347429
case_no = 2014/00229
court_code = 10236
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
pre_hear_date = 16/10/2023
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=18202000008483
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:37
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=347429
Param Type = c
case_no=2014/00229
Param Type = c
court_code=10236
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=16/10/2023 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,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
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 = 3
RecordId = 18202000008484
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 11/01/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18466000000000
case_no = 2018/00372
court_code = 10236
trn_rcms_caseid = 13356000002673
pre_case_purpose = 18466000000000
pre_hear_date = 16/10/2023
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=18202000008484
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:37
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18466000000000
Param Type = c
case_no=2018/00372
Param Type = c
court_code=10236
Param Type = c
trn_rcms_caseid=13356000002673
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,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 = 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 = 3
RecordId = 18202000008485
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 11/01/2024
new_case_purpose = 18466000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2018/00377
court_code = 10236
trn_rcms_caseid = 15147000002960
pre_case_purpose = 18466000000000
pre_hear_date = 16/10/2023
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=18202000008485
Param Type = n
trn_rcms_mhearingid=18202000008458
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:37
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/01/2024 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2018/00377
Param Type = c
court_code=10236
Param Type = c
trn_rcms_caseid=15147000002960
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=16/10/2023 00:00:00
Param Type = n
trn_rcms_hearingrow=27
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 = 3912060238670
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16679000000773 idvalue 0
Mapped case_no Row = 1 value = 2016/00121 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 16679000000773
case_no = 2016/00121
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 5
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
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 = 18202000008486
MapName trcmf1
SourceId 18202000008459
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 11/01/2024
case_no = 2016/00121
trn_rcms_caseregid = 16679000000773
court_code = 10236
case_purpose = 18473000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008486
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008459
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:37
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24: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=18473000000000
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2016/00121
Param Type = c
trn_rcms_caseregid=16679000000773
Param Type = c
court_code=10236
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12482000007278 idvalue 0
Mapped case_no Row = 1 value = 2022/3 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 12482000007278
case_no = 2022/3
prev_hearing_date = 16/10/2023
hearing_date = 11/01/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
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 = 4
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 = 18202000008487
MapName trcmf1
SourceId 18202000008460
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 11/01/2024
case_no = 2022/3
trn_rcms_caseregid = 12482000007278
court_code = 10236
case_purpose = 18473000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008487
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008460
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:37
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24: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=18473000000000
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2022/3
Param Type = c
trn_rcms_caseregid=12482000007278
Param Type = c
court_code=10236
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10450000000948 idvalue 0
Mapped case_no Row = 1 value = 2016/00109 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 10450000000948
case_no = 2016/00109
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 5
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 18202000008488
MapName trcmf1
SourceId 18202000008461
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 11/01/2024
case_no = 2016/00109
trn_rcms_caseregid = 10450000000948
court_code = 10236
case_purpose = 1000525
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008488
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008461
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:37
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24: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=1000525
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2016/00109
Param Type = c
trn_rcms_caseregid=10450000000948
Param Type = c
court_code=10236
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19292000000548 idvalue 0
Mapped case_no Row = 1 value = 2016/00119 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 19292000000548
case_no = 2016/00119
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 4
prev_case_purpose after validation = 1000497
case_purpose = 1000497
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 = 3
RecordId = 18202000008489
MapName trcmf1
SourceId 18202000008462
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 11/01/2024
case_no = 2016/00119
trn_rcms_caseregid = 19292000000548
court_code = 10236
case_purpose = 1000497
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008489
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008462
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:37
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24: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=1000497
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2016/00119
Param Type = c
trn_rcms_caseregid=19292000000548
Param Type = c
court_code=10236
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11527000001232 idvalue 0
Mapped case_no Row = 1 value = 2015/00120 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000507 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 11527000001232
case_no = 2015/00120
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 5
prev_case_purpose after validation = 1000507
case_purpose = 1000507
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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
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 = 18202000008490
MapName trcmf1
SourceId 18202000008463
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000507
hearing_date = 11/01/2024
case_no = 2015/00120
trn_rcms_caseregid = 11527000001232
court_code = 10236
case_purpose = 1000507
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008490
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008463
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:38
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:38
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=1000507
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2015/00120
Param Type = c
trn_rcms_caseregid=11527000001232
Param Type = c
court_code=10236
Param Type = c
case_purpose=1000507
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12956000002315 idvalue 0
Mapped case_no Row = 1 value = 2018/00370 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000507 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 12956000002315
case_no = 2018/00370
prev_hearing_date = 16/10/2023
hearing_date = 11/01/2024
prev_case_purposename = ???? ?????
prev_case_purpose =
prev_case_purpose after validation = 1000507
case_purpose = 1000507
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 = 4
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 = 18202000008491
MapName trcmf1
SourceId 18202000008464
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000507
hearing_date = 11/01/2024
case_no = 2018/00370
trn_rcms_caseregid = 12956000002315
court_code = 10236
case_purpose = 1000507
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008491
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008464
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:38
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:38
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=1000507
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2018/00370
Param Type = c
trn_rcms_caseregid=12956000002315
Param Type = c
court_code=10236
Param Type = c
case_purpose=1000507
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11312000003974 idvalue 0
Mapped case_no Row = 1 value = 2020/00045 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000507 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 11312000003974
case_no = 2020/00045
prev_hearing_date = 16/10/2023
hearing_date = 11/01/2024
prev_case_purposename = ???? ?????
prev_case_purpose =
prev_case_purpose after validation = 1000507
case_purpose = 1000507
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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
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 = 18202000008492
MapName trcmf1
SourceId 18202000008465
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000507
hearing_date = 11/01/2024
case_no = 2020/00045
trn_rcms_caseregid = 11312000003974
court_code = 10236
case_purpose = 1000507
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008492
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008465
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:38
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:38
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=1000507
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2020/00045
Param Type = c
trn_rcms_caseregid=11312000003974
Param Type = c
court_code=10236
Param Type = c
case_purpose=1000507
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11232000005069 idvalue 0
Mapped case_no Row = 1 value = 2020/00129 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000507 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 11232000005069
case_no = 2020/00129
prev_hearing_date = 16/10/2023
hearing_date = 11/01/2024
prev_case_purposename = ???? ?????
prev_case_purpose =
prev_case_purpose after validation = 1000507
case_purpose = 1000507
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 = 4
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 = 18202000008493
MapName trcmf1
SourceId 18202000008466
Select sysdate as sdt from dual
Time elapsed = 3
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 = 1000507
hearing_date = 11/01/2024
case_no = 2020/00129
trn_rcms_caseregid = 11232000005069
court_code = 10236
case_purpose = 1000507
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008493
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008466
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:38
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:38
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=1000507
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2020/00129
Param Type = c
trn_rcms_caseregid=11232000005069
Param Type = c
court_code=10236
Param Type = c
case_purpose=1000507
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13196000005971 idvalue 0
Mapped case_no Row = 1 value = 2021/182 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000507 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 13196000005971
case_no = 2021/182
prev_hearing_date = 16/10/2023
hearing_date = 11/01/2024
prev_case_purposename = ???? ?????
prev_case_purpose =
prev_case_purpose after validation = 1000507
case_purpose = 1000507
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 = 4
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 = 18202000008494
MapName trcmf1
SourceId 18202000008467
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 = 1000507
hearing_date = 11/01/2024
case_no = 2021/182
trn_rcms_caseregid = 13196000005971
court_code = 10236
case_purpose = 1000507
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008494
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008467
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:38
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:38
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=1000507
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2021/182
Param Type = c
trn_rcms_caseregid=13196000005971
Param Type = c
court_code=10236
Param Type = c
case_purpose=1000507
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 347414 idvalue 0
Mapped case_no Row = 1 value = 2013/00166 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? / ??????? idvalue 0
Mapped case_purpose Row = 1 value = 1000490 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 347414
case_no = 2013/00166
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 1000490
case_purpose = 1000490
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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 18202000008495
MapName trcmf1
SourceId 18202000008468
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000490
hearing_date = 11/01/2024
case_no = 2013/00166
trn_rcms_caseregid = 347414
court_code = 10236
case_purpose = 1000490
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008495
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008468
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:38
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:38
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=1000490
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2013/00166
Param Type = c
trn_rcms_caseregid=347414
Param Type = c
court_code=10236
Param Type = c
case_purpose=1000490
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12780000006402 idvalue 0
Mapped case_no Row = 1 value = 2022/4 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 11417000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 12780000006402
case_no = 2022/4
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 4
prev_case_purpose after validation = 11417000000000
case_purpose = 11417000000000
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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
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 = 18202000008496
MapName trcmf1
SourceId 18202000008469
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 11417000000000
hearing_date = 11/01/2024
case_no = 2022/4
trn_rcms_caseregid = 12780000006402
court_code = 10236
case_purpose = 11417000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008496
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008469
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:38
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:38
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=11417000000000
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2022/4
Param Type = c
trn_rcms_caseregid=12780000006402
Param Type = c
court_code=10236
Param Type = c
case_purpose=11417000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 347249 idvalue 0
Mapped case_no Row = 1 value = 2010/00077 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ?????? ???????? idvalue 0
Mapped case_purpose Row = 1 value = 18470000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 347249
case_no = 2010/00077
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 5
prev_case_purpose after validation = 18470000000000
case_purpose = 18470000000000
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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
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 = 18202000008497
MapName trcmf1
SourceId 18202000008470
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 = 18470000000000
hearing_date = 11/01/2024
case_no = 2010/00077
trn_rcms_caseregid = 347249
court_code = 10236
case_purpose = 18470000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008497
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008470
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:38
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:38
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=18470000000000
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2010/00077
Param Type = c
trn_rcms_caseregid=347249
Param Type = c
court_code=10236
Param Type = c
case_purpose=18470000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 347423 idvalue 0
Mapped case_no Row = 1 value = 2015/00061 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ?????? ???????? idvalue 0
Mapped case_purpose Row = 1 value = 18470000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 347423
case_no = 2015/00061
prev_hearing_date = 16/10/2023
hearing_date = 11/01/2024
prev_case_purposename = ??????? ?????? ????????
prev_case_purpose =
prev_case_purpose after validation = 18470000000000
case_purpose = 18470000000000
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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
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 = 18202000008498
MapName trcmf1
SourceId 18202000008471
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18470000000000
hearing_date = 11/01/2024
case_no = 2015/00061
trn_rcms_caseregid = 347423
court_code = 10236
case_purpose = 18470000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008498
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008471
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:39
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24: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=18470000000000
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2015/00061
Param Type = c
trn_rcms_caseregid=347423
Param Type = c
court_code=10236
Param Type = c
case_purpose=18470000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13639000001234 idvalue 0
Mapped case_no Row = 1 value = 2016/00113 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 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 = 11/01/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 = 10236
trn_rcms_caseregid = 13639000001234
case_no = 2016/00113
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 4
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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
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 = 18202000008499
MapName trcmf1
SourceId 18202000008472
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/01/2024
case_no = 2016/00113
trn_rcms_caseregid = 13639000001234
court_code = 10236
case_purpose = 18678000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008499
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008472
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:39
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24: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=11/01/2024 00:00:00
Param Type = c
case_no=2016/00113
Param Type = c
trn_rcms_caseregid=13639000001234
Param Type = c
court_code=10236
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13713000000761 idvalue 0
Mapped case_no Row = 1 value = 2016/00114 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 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 = 11/01/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 = 10236
trn_rcms_caseregid = 13713000000761
case_no = 2016/00114
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
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 = 18202000008500
MapName trcmf1
SourceId 18202000008473
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/01/2024
case_no = 2016/00114
trn_rcms_caseregid = 13713000000761
court_code = 10236
case_purpose = 18678000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008500
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008473
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:39
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24: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=11/01/2024 00:00:00
Param Type = c
case_no=2016/00114
Param Type = c
trn_rcms_caseregid=13713000000761
Param Type = c
court_code=10236
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15060000002542 idvalue 0
Mapped case_no Row = 1 value = 2018/00375 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 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 = 11/01/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 = 10236
trn_rcms_caseregid = 15060000002542
case_no = 2018/00375
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 4
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 = 18202000008501
MapName trcmf1
SourceId 18202000008474
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/01/2024
case_no = 2018/00375
trn_rcms_caseregid = 15060000002542
court_code = 10236
case_purpose = 18678000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008501
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008474
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:39
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24: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=11/01/2024 00:00:00
Param Type = c
case_no=2018/00375
Param Type = c
trn_rcms_caseregid=15060000002542
Param Type = c
court_code=10236
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10689000006212 idvalue 0
Mapped case_no Row = 1 value = 2022/265 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 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 = 11/01/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 = 10236
trn_rcms_caseregid = 10689000006212
case_no = 2022/265
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 4
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 = 18202000008502
MapName trcmf1
SourceId 18202000008475
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 = 11/01/2024
case_no = 2022/265
trn_rcms_caseregid = 10689000006212
court_code = 10236
case_purpose = 18678000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008502
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008475
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:39
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24: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=11/01/2024 00:00:00
Param Type = c
case_no=2022/265
Param Type = c
trn_rcms_caseregid=10689000006212
Param Type = c
court_code=10236
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19364000006695 idvalue 0
Mapped case_no Row = 1 value = 2022/282 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 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 = 11/01/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 = 10236
trn_rcms_caseregid = 19364000006695
case_no = 2022/282
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
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 = 18202000008503
MapName trcmf1
SourceId 18202000008476
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/01/2024
case_no = 2022/282
trn_rcms_caseregid = 19364000006695
court_code = 10236
case_purpose = 18678000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008503
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008476
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:39
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24: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=11/01/2024 00:00:00
Param Type = c
case_no=2022/282
Param Type = c
trn_rcms_caseregid=19364000006695
Param Type = c
court_code=10236
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19525000007316 idvalue 0
Mapped case_no Row = 1 value = 2022/283 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 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 = 11/01/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 = 10236
trn_rcms_caseregid = 19525000007316
case_no = 2022/283
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
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 = 18202000008504
MapName trcmf1
SourceId 18202000008477
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/01/2024
case_no = 2022/283
trn_rcms_caseregid = 19525000007316
court_code = 10236
case_purpose = 18678000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008504
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008477
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:39
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24: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=11/01/2024 00:00:00
Param Type = c
case_no=2022/283
Param Type = c
trn_rcms_caseregid=19525000007316
Param Type = c
court_code=10236
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12491000007439 idvalue 0
Mapped case_no Row = 1 value = 2023/105 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 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 = 11/01/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 = 10236
trn_rcms_caseregid = 12491000007439
case_no = 2023/105
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
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 = 2
RecordId = 18202000008505
MapName trcmf1
SourceId 18202000008478
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/01/2024
case_no = 2023/105
trn_rcms_caseregid = 12491000007439
court_code = 10236
case_purpose = 18678000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008505
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008478
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:39
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24: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=11/01/2024 00:00:00
Param Type = c
case_no=2023/105
Param Type = c
trn_rcms_caseregid=12491000007439
Param Type = c
court_code=10236
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18264000007210 idvalue 0
Mapped case_no Row = 1 value = 2023/33 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 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 = 11/01/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 = 10236
trn_rcms_caseregid = 18264000007210
case_no = 2023/33
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 18202000008506
MapName trcmf1
SourceId 18202000008479
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/01/2024
case_no = 2023/33
trn_rcms_caseregid = 18264000007210
court_code = 10236
case_purpose = 18678000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008506
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008479
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:39
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24: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=11/01/2024 00:00:00
Param Type = c
case_no=2023/33
Param Type = c
trn_rcms_caseregid=18264000007210
Param Type = c
court_code=10236
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17745000000571 idvalue 0
Mapped case_no Row = 1 value = 2016/00118 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? idvalue 0
Mapped case_purpose Row = 1 value = 15904000000025 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 17745000000571
case_no = 2016/00118
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 5
prev_case_purpose after validation = 15904000000025
case_purpose = 15904000000025
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 = 4
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 = 18202000008507
MapName trcmf1
SourceId 18202000008480
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 = 15904000000025
hearing_date = 11/01/2024
case_no = 2016/00118
trn_rcms_caseregid = 17745000000571
court_code = 10236
case_purpose = 15904000000025
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008507
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008480
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:40
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:40
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=15904000000025
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2016/00118
Param Type = c
trn_rcms_caseregid=17745000000571
Param Type = c
court_code=10236
Param Type = c
case_purpose=15904000000025
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 347405 idvalue 0
Mapped case_no Row = 1 value = 2010/00097 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 347405
case_no = 2010/00097
prev_hearing_date = 16/10/2023
hearing_date = 11/01/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 = 4
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
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 = 18202000008508
MapName trcmf1
SourceId 18202000008481
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 11/01/2024
case_no = 2010/00097
trn_rcms_caseregid = 347405
court_code = 10236
case_purpose = 18466000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008508
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008481
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:40
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2010/00097
Param Type = c
trn_rcms_caseregid=347405
Param Type = c
court_code=10236
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 347482 idvalue 0
Mapped case_no Row = 1 value = 2013/00182 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 347482
case_no = 2013/00182
prev_hearing_date = 16/10/2023
hearing_date = 11/01/2024
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 18202000008509
MapName trcmf1
SourceId 18202000008482
Select sysdate as sdt from dual
Time elapsed = 3
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 = 18466000000000
hearing_date = 11/01/2024
case_no = 2013/00182
trn_rcms_caseregid = 347482
court_code = 10236
case_purpose = 18466000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008509
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008482
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:40
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2013/00182
Param Type = c
trn_rcms_caseregid=347482
Param Type = c
court_code=10236
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 347429 idvalue 0
Mapped case_no Row = 1 value = 2014/00229 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 347429
case_no = 2014/00229
prev_hearing_date = 16/10/2023
hearing_date = 11/01/2024
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
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 = 2
RecordId = 18202000008510
MapName trcmf1
SourceId 18202000008483
Select sysdate as sdt from dual
Time elapsed = 6
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 = 18466000000000
hearing_date = 11/01/2024
case_no = 2014/00229
trn_rcms_caseregid = 347429
court_code = 10236
case_purpose = 18466000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008510
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008483
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:40
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2014/00229
Param Type = c
trn_rcms_caseregid=347429
Param Type = c
court_code=10236
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13356000002673 idvalue 0
Mapped case_no Row = 1 value = 2018/00372 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 13356000002673
case_no = 2018/00372
prev_hearing_date = 16/10/2023
hearing_date = 11/01/2024
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 18202000008511
MapName trcmf1
SourceId 18202000008484
Select sysdate as sdt from dual
Time elapsed = 3
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 = 18466000000000
hearing_date = 11/01/2024
case_no = 2018/00372
trn_rcms_caseregid = 13356000002673
court_code = 10236
case_purpose = 18466000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008511
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008484
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:40
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2018/00372
Param Type = c
trn_rcms_caseregid=13356000002673
Param Type = c
court_code=10236
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 10236 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15147000002960 idvalue 0
Mapped case_no Row = 1 value = 2018/00377 idvalue 0
Mapped prev_hearing_date Row = 1 value = 16/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/01/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 = 10236
trn_rcms_caseregid = 15147000002960
case_no = 2018/00377
prev_hearing_date = 16/10/2023
hearing_date = 11/01/2024
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
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 = 18202000008512
MapName trcmf1
SourceId 18202000008485
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 11/01/2024
case_no = 2018/00377
trn_rcms_caseregid = 15147000002960
court_code = 10236
case_purpose = 18466000000000
prev_hearing_date = 16/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=18202000008512
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18202000008485
Param Type = c
cancel=F
Param Type = c
createdby=sdobaraa
Param Type = c
createdon=18/12/2023 11:24:40
Param Type = c
username=sdobaraa
Param Type = c
modifiedon=18/12/2023 11:24:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=11/01/2024 00:00:00
Param Type = c
case_no=2018/00377
Param Type = c
trn_rcms_caseregid=15147000002960
Param Type = c
court_code=10236
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=16/10/2023 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 = 3912060241898
Time elapsed for MD Map = 3912060241899
Time elapsed for Save History = 3912060241900
Time elapsed for Save Attachment = 3912060241901
Time elapsed for After Save WF Exec = 3912060241903
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"18202000008458"}]}
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=sdobaraa
Param Type = c
calledon=18/12/2023 11:23:54
Param Type = c
callfinished=18/12/2023 11:24:01
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=7028
Param Type = n
dbtimetaken=4481
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