ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
gcmsDM_Badmer_R827ccb0eea8a706c4c34a16891f84e7b![]()
INRF500250000Ffiresql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtname := sqlget({m2},{court_name})firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})m_courttype := sqlget({m3},{court_type})firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})m_courtid := sqlget({m4},{court_name_mastid})firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})login_userid := sqlget({m4},{axusersid})firesql({m4},{select :username as uname from dual})u_name := sqlget({m4},{uname})firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtcode := sqlget({m4},{COURT_CODE})firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})m_statename := sqlget({m2},{STATE_NAME})firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_distName := sqlget({m7},{DISTNAMEENG})firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_courtcatid := sqlget({m8},{COURT_CATEGOTY})firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})m_deptid := sqlget({m4},{department_mastid})firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})m_courttypeid := sqlget({m3},{court_type_mastid})firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })urole := sqlget({m4},{groupname})firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})m_cutoffdt := sqlget({a1},{dd})firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})m_offcount := sqlget({P1},{ct})00000F
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
username=DM_badmer_r
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=DM_badmer_r
Time elapsed = 12
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ???? ???????,???????
Result = ???? ???????,???????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=DM_badmer_r
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=DM_badmer_r
Time elapsed = 12
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = DM
Result = DM
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=DM_badmer_r
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=DM_badmer_r
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 12836000000152
Result = 12836000000152
Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=DM_badmer_r
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 3633
Result = 3633
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=DM_badmer_r
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = DM_badmer_r
Result = DM_badmer_r
Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=DM_badmer_r
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10399
Result = 10399
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 = 6
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=DM_badmer_r
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=DM_badmer_r
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Barmer
Result = Barmer
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=DM_badmer_r
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=DM_badmer_r
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m8},{COURT_CATEGOTY})
Calling function sqlget
Result of sqlget = 10593000000007
Result = 10593000000007
Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
Calling function firesql
login_userid=3633
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=3633
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=DM_badmer_r
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10206000000014
Result = 10206000000014
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=DM_badmer_r
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=DM_badmer_r
Time elapsed = 10
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_reader
Result = court_reader
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 11
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=DM_badmer_r
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=DM_badmer_r
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 = 5
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 31
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 = 7
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 = 7
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 = 10399
hearing_date = 11/09/2024
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 5
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=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 = 10888000008614
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
hearing_date = 11/09/2024
courtcode = 10399
Posting record
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:18
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
courtcode=10399
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)
Saving to table TRN_RCMS_HEARING
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008615
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 18945000001102
new_case_purpose = 18473000000000
trn_rcms_caseid = 14089000005730
court_code = 10399
pre_hear_date = 11/09/2024
pre_case_purpose = 18473000000000
isadjourn = YES
case_no = 2021/217
adjourn_remark =
next_hear_date = 08/10/2024
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=10888000008615
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:19
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=18945000001102
Param Type = c
new_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=14089000005730
Param Type = c
court_code=10399
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
isadjourn=YES
Param Type = c
case_no=2021/217
Param Type = c
next_hear_date=08/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,new_case_purpose,trn_rcms_caseid,court_code,pre_hear_date,pre_case_purpose,isadjourn,case_no,adjourn_remark,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,:adjourn_type,:new_case_purpose,:trn_rcms_caseid,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:isadjourn,:case_no,null,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 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008616
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 8
pre_case_purpose = 18473000000000
court_code = 10399
case_no = 2022/173
next_hear_date = 08/10/2024
new_case_purpose = 18473000000000
trn_rcms_caseid = 10840000006382
adjourn_type = 18945000001102
adjourn_remark =
pre_hear_date = 11/09/2024
isadjourn = YES
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=10888000008616
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:19
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
court_code=10399
Param Type = c
case_no=2022/173
Param Type = c
next_hear_date=08/10/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=10840000006382
Param Type = c
adjourn_type=18945000001102
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
isadjourn=YES
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,court_code,case_no,next_hear_date,new_case_purpose,trn_rcms_caseid,adjourn_type,adjourn_remark,pre_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_caseid,:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 10
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 9
RecordId = 10888000008617
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 31
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 11/09/2024
pre_case_purpose = 18473000000000
trn_rcms_caseid = 12407000007269
court_code = 10399
case_no = 2023/149
adjourn_type = 18945000001102
adjourn_remark =
isadjourn = YES
new_case_purpose = 18473000000000
next_hear_date = 08/10/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=10888000008617
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:19
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=12407000007269
Param Type = c
court_code=10399
Param Type = c
case_no=2023/149
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=08/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008618
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 24/09/2024
new_case_purpose = 18473000000000
isadjourn = YES
adjourn_remark =
adjourn_type = 18945000001102
case_no = 2023/172
court_code = 10399
trn_rcms_caseid = 18641000007004
pre_case_purpose = 18473000000000
pre_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=10888000008618
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:19
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/09/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
case_no=2023/172
Param Type = c
court_code=10399
Param Type = c
trn_rcms_caseid=18641000007004
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 17
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 = 5
RecordId = 10888000008619
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 24/09/2024
new_case_purpose = 18473000000000
isadjourn = YES
adjourn_remark =
adjourn_type = 18945000001102
case_no = 2023/173
court_code = 10399
trn_rcms_caseid = 18713000008062
pre_case_purpose = 18473000000000
pre_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=10888000008619
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:19
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/09/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
case_no=2023/173
Param Type = c
court_code=10399
Param Type = c
trn_rcms_caseid=18713000008062
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 17
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008620
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 26
next_hear_date = 09/10/2024
new_case_purpose = 18473000000000
isadjourn = YES
adjourn_remark =
adjourn_type = 18945000001102
case_no = 2023/214
court_code = 10399
trn_rcms_caseid = 17645000007171
pre_case_purpose = 18473000000000
pre_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=10888000008620
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:19
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=09/10/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
case_no=2023/214
Param Type = c
court_code=10399
Param Type = c
trn_rcms_caseid=17645000007171
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 10
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 = 8
RecordId = 10888000008621
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 08/10/2024
new_case_purpose = 18473000000000
isadjourn = YES
adjourn_remark =
adjourn_type = 18945000001102
case_no = 2024/103
court_code = 10399
trn_rcms_caseid = 17223000009352
pre_case_purpose = 18473000000000
pre_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=10888000008621
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:19
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/10/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
case_no=2024/103
Param Type = c
court_code=10399
Param Type = c
trn_rcms_caseid=17223000009352
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 10888000008622
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 9
next_hear_date = 16/10/2024
new_case_purpose = 18473000000000
isadjourn = YES
adjourn_type = 18945000001102
adjourn_remark =
case_no = 2024/53
court_code = 10399
trn_rcms_caseid = 18417000008330
pre_case_purpose = 18473000000000
pre_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=10888000008622
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:19
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/10/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
case_no=2024/53
Param Type = c
court_code=10399
Param Type = c
trn_rcms_caseid=18417000008330
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_type,adjourn_remark,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,:adjourn_type,null,: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 = 5
RecordId = 10888000008623
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
pre_hear_date = 11/09/2024
trn_rcms_caseid = 11935000008690
court_code = 10399
case_no = 2024/84
pre_case_purpose = 18473000000000
adjourn_type = 18945000001102
adjourn_remark =
isadjourn = YES
new_case_purpose = 18473000000000
next_hear_date = 08/10/2024
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=10888000008623
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:19
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
trn_rcms_caseid=11935000008690
Param Type = c
court_code=10399
Param Type = c
case_no=2024/84
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=08/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,court_code,case_no,pre_case_purpose,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:court_code,:case_no,:pre_case_purpose,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008624
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 19
next_hear_date = 16/10/2024
new_case_purpose = 18678000000000
isadjourn = YES
adjourn_remark =
adjourn_type = 18945000001102
court_code = 10399
case_no = 2018/00070
trn_rcms_caseid = 16082000002105
pre_case_purpose = 18678000000000
pre_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=10888000008624
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:20
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/10/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
court_code=10399
Param Type = c
case_no=2018/00070
Param Type = c
trn_rcms_caseid=16082000002105
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,court_code,case_no,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,:court_code,:case_no,: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 = 18
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 = 6
RecordId = 10888000008625
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 18
Select sysdate as sdt from dual
Time elapsed = 10
adjourn_type = 18945000001102
court_code = 10399
isadjourn = YES
next_hear_date = 16/10/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
case_no = 2021/212
adjourn_remark =
pre_hear_date = 11/09/2024
trn_rcms_caseid = 10465000006340
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=10888000008625
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:20
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=18945000001102
Param Type = c
court_code=10399
Param Type = c
isadjourn=YES
Param Type = c
next_hear_date=16/10/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2021/212
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
trn_rcms_caseid=10465000006340
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,adjourn_type,court_code,isadjourn,next_hear_date,new_case_purpose,pre_case_purpose,case_no,adjourn_remark,pre_hear_date,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:case_no,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,: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 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008626
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
isadjourn = YES
next_hear_date = 16/10/2024
new_case_purpose = 18678000000000
trn_rcms_caseid = 13355000006359
court_code = 10399
adjourn_type = 18945000001102
pre_case_purpose = 18678000000000
pre_hear_date = 11/09/2024
adjourn_remark =
case_no = 2022/286
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=10888000008626
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:20
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=YES
Param Type = c
next_hear_date=16/10/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=13355000006359
Param Type = c
court_code=10399
Param Type = c
adjourn_type=18945000001102
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
case_no=2022/286
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,isadjourn,next_hear_date,new_case_purpose,trn_rcms_caseid,court_code,adjourn_type,pre_case_purpose,pre_hear_date,adjourn_remark,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,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_caseid,:court_code,:adjourn_type,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:case_no,: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 = 6
RecordId = 10888000008627
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = YES
adjourn_type = 18945000001102
new_case_purpose = 18678000000000
next_hear_date = 21/10/2024
adjourn_remark =
case_no = 2022/350
court_code = 10399
trn_rcms_caseid = 15273000006595
pre_case_purpose = 18678000000000
pre_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=10888000008627
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:20
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=21/10/2024 00:00:00
Param Type = c
case_no=2022/350
Param Type = c
court_code=10399
Param Type = c
trn_rcms_caseid=15273000006595
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=11/09/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,isadjourn,adjourn_type,new_case_purpose,next_hear_date,adjourn_remark,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,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 13
RecordId = 10888000008628
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 11/09/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 10711000008272
court_code = 10399
case_no = 2023/263
adjourn_type = 18945000001102
adjourn_remark =
isadjourn = YES
new_case_purpose = 18678000000000
next_hear_date = 21/10/2024
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=10888000008628
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:20
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=10711000008272
Param Type = c
court_code=10399
Param Type = c
case_no=2023/263
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=21/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=14
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 10888000008629
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 11/09/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 10763000007609
court_code = 10399
case_no = 2023/264
adjourn_type = 18945000001102
adjourn_remark =
isadjourn = YES
new_case_purpose = 18678000000000
next_hear_date = 21/10/2024
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=10888000008629
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:20
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=10763000007609
Param Type = c
court_code=10399
Param Type = c
case_no=2023/264
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=21/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008630
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 21/10/2024
new_case_purpose = 18678000000000
isadjourn = YES
adjourn_remark =
adjourn_type = 18945000001102
case_no = 2023/266
court_code = 10399
trn_rcms_caseid = 10876000008834
pre_case_purpose = 18678000000000
pre_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=10888000008630
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:20
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/10/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
case_no=2023/266
Param Type = c
court_code=10399
Param Type = c
trn_rcms_caseid=10876000008834
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 10888000008631
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 11/09/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 19589000008103
court_code = 10399
case_no = 2023/37
adjourn_type = 18945000001102
adjourn_remark =
isadjourn = YES
new_case_purpose = 18678000000000
next_hear_date = 21/10/2024
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=10888000008631
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:20
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=19589000008103
Param Type = c
court_code=10399
Param Type = c
case_no=2023/37
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=21/10/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 = 3
RecordId = 10888000008632
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 11/09/2024
pre_case_purpose = 18678000000000
court_code = 10399
case_no = 2024/160
trn_rcms_caseid = 16156000007872
adjourn_type = 18945000001102
adjourn_remark =
isadjourn = YES
new_case_purpose = 18678000000000
next_hear_date = 07/10/2024
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=10888000008632
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:21
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=10399
Param Type = c
case_no=2024/160
Param Type = c
trn_rcms_caseid=16156000007872
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=07/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,court_code,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,:case_no,:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10888000008633
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 4
trn_rcms_caseid = 18782000009456
pre_hear_date = 11/09/2024
case_no = 2024/161
adjourn_remark =
court_code = 10399
pre_case_purpose = 18678000000000
next_hear_date = 22/10/2024
isadjourn = YES
new_case_purpose = 18678000000000
adjourn_type = 18945000001102
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=10888000008633
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:21
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=18782000009456
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
case_no=2024/161
Param Type = c
court_code=10399
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
next_hear_date=22/10/2024 00:00:00
Param Type = c
isadjourn=YES
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=18945000001102
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,trn_rcms_caseid,pre_hear_date,case_no,adjourn_remark,court_code,pre_case_purpose,next_hear_date,isadjourn,new_case_purpose,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,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,null,:court_code,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,: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 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008634
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
court_code = 10399
case_no = 2024/165
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 11943000010314
pre_hear_date = 11/09/2024
adjourn_remark =
next_hear_date = 09/10/2024
isadjourn = YES
adjourn_type = 18945000001102
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=10888000008634
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:21
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10399
Param Type = c
case_no=2024/165
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=11943000010314
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
next_hear_date=09/10/2024 00:00:00
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
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,court_code,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,next_hear_date,isadjourn,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,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,: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 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008635
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 27
Select sysdate as sdt from dual
Time elapsed = 5
new_case_purpose = 18678000000000
isadjourn = YES
next_hear_date = 09/10/2024
pre_case_purpose = 18678000000000
case_no = 2024/166
court_code = 10399
pre_hear_date = 11/09/2024
trn_rcms_caseid = 11967000008752
adjourn_remark =
adjourn_type = 18945000001102
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=10888000008635
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:21
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=YES
Param Type = c
next_hear_date=09/10/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2024/166
Param Type = c
court_code=10399
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
trn_rcms_caseid=11967000008752
Param Type = c
adjourn_type=18945000001102
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,new_case_purpose,isadjourn,next_hear_date,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,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,:new_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008636
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2024/167
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 12004000009715
pre_hear_date = 11/09/2024
adjourn_remark =
court_code = 10399
adjourn_type = 18945000001102
next_hear_date = 09/10/2024
isadjourn = YES
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=10888000008636
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:21
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2024/167
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=12004000009715
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
court_code=10399
Param Type = c
adjourn_type=18945000001102
Param Type = c
next_hear_date=09/10/2024 00:00:00
Param Type = c
isadjourn=YES
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,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008637
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 19
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 09/10/2024
new_case_purpose = 18678000000000
isadjourn = YES
adjourn_remark =
adjourn_type = 18945000001102
case_no = 2024/168
court_code = 10399
trn_rcms_caseid = 12035000007682
pre_case_purpose = 18678000000000
pre_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=10888000008637
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:21
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=09/10/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
case_no=2024/168
Param Type = c
court_code=10399
Param Type = c
trn_rcms_caseid=12035000007682
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 10888000008638
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 09/10/2024
isadjourn = YES
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 11/09/2024
case_no = 2024/169
court_code = 10399
trn_rcms_caseid = 12069000009183
adjourn_type = 18945000001102
adjourn_remark =
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=10888000008638
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:21
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=09/10/2024 00:00:00
Param Type = c
isadjourn=YES
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
case_no=2024/169
Param Type = c
court_code=10399
Param Type = c
trn_rcms_caseid=12069000009183
Param Type = c
adjourn_type=18945000001102
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,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_type,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:adjourn_type,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 10
RecordId = 10888000008639
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 11/09/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 12091000008577
court_code = 10399
case_no = 2024/170
isadjourn = YES
adjourn_type = 18945000001102
next_hear_date = 09/10/2024
adjourn_remark =
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=10888000008639
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:21
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=12091000008577
Param Type = c
court_code=10399
Param Type = c
case_no=2024/170
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
next_hear_date=09/10/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_type,next_hear_date,adjourn_remark,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008640
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 9
court_code = 10399
isadjourn = YES
next_hear_date = 08/10/2024
adjourn_remark =
adjourn_type = 18945000001102
new_case_purpose = 18678000000000
pre_hear_date = 11/09/2024
trn_rcms_caseid = 17804000009778
case_no = 2024/179
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=10888000008640
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:21
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10399
Param Type = c
isadjourn=YES
Param Type = c
next_hear_date=08/10/2024 00:00:00
Param Type = c
adjourn_type=18945000001102
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
trn_rcms_caseid=17804000009778
Param Type = c
case_no=2024/179
Param Type = n
pre_case_purpose=18678000000000
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,court_code,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,pre_hear_date,trn_rcms_caseid,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,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 20
RecordId = 10888000008641
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
court_code = 10399
pre_case_purpose = 18678000000000
case_no = 2024/180
trn_rcms_caseid = 17859000008962
pre_hear_date = 11/09/2024
new_case_purpose = 18678000000000
adjourn_type = 18945000001102
adjourn_remark =
next_hear_date = 22/10/2024
isadjourn = YES
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=10888000008641
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:22
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10399
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2024/180
Param Type = c
trn_rcms_caseid=17859000008962
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=18945000001102
Param Type = c
next_hear_date=22/10/2024 00:00:00
Param Type = c
isadjourn=YES
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,court_code,pre_case_purpose,case_no,trn_rcms_caseid,pre_hear_date,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:pre_case_purpose,:case_no,:trn_rcms_caseid,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,: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 28 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 10888000008642
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
trn_rcms_caseid = 16864000003428
pre_hear_date = 11/09/2024
court_code = 10399
case_no = 2019/00159
pre_case_purpose = 18472000000000
isadjourn = YES
adjourn_type = 18945000001102
new_case_purpose = 18472000000000
next_hear_date = 16/10/2024
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=10888000008642
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:22
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=16864000003428
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
court_code=10399
Param Type = c
case_no=2019/00159
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
new_case_purpose=18472000000000
Param Type = c
next_hear_date=16/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 6
Adding new record to store data from Frame 2, Row 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008643
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_remark =
isadjourn = YES
trn_rcms_caseid = 17093000003449
pre_case_purpose = 18472000000000
pre_hear_date = 11/09/2024
case_no = 2019/00160
new_case_purpose = 18472000000000
adjourn_type = 18945000001102
court_code = 10399
next_hear_date = 16/10/2024
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=10888000008643
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:22
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=YES
Param Type = c
trn_rcms_caseid=17093000003449
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
case_no=2019/00160
Param Type = c
new_case_purpose=18472000000000
Param Type = c
adjourn_type=18945000001102
Param Type = c
court_code=10399
Param Type = c
next_hear_date=16/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=29
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,isadjourn,trn_rcms_caseid,pre_case_purpose,pre_hear_date,case_no,new_case_purpose,adjourn_type,court_code,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,:isadjourn,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:new_case_purpose,:adjourn_type,:court_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 30 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008644
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 34
adjourn_remark =
adjourn_type = 18945000001102
trn_rcms_caseid = 17279000003240
pre_hear_date = 11/09/2024
court_code = 10399
case_no = 2019/00161
next_hear_date = 16/10/2024
isadjourn = YES
pre_case_purpose = 18472000000000
new_case_purpose = 18472000000000
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=10888000008644
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:22
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=18945000001102
Param Type = c
trn_rcms_caseid=17279000003240
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
court_code=10399
Param Type = c
case_no=2019/00161
Param Type = c
next_hear_date=16/10/2024 00:00:00
Param Type = c
isadjourn=YES
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
new_case_purpose=18472000000000
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,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 = 6
Adding new record to store data from Frame 2, Row 31 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 16
RecordId = 10888000008645
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 18
adjourn_type = 18945000001102
adjourn_remark =
pre_hear_date = 11/09/2024
trn_rcms_caseid = 17530000003237
new_case_purpose = 18472000000000
pre_case_purpose = 18472000000000
next_hear_date = 16/10/2024
isadjourn = YES
case_no = 2019/00162
court_code = 10399
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=10888000008645
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:22
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=18945000001102
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
trn_rcms_caseid=17530000003237
Param Type = c
new_case_purpose=18472000000000
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
next_hear_date=16/10/2024 00:00:00
Param Type = c
isadjourn=YES
Param Type = c
case_no=2019/00162
Param Type = c
court_code=10399
Param Type = n
trn_rcms_hearingrow=31
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,pre_hear_date,trn_rcms_caseid,new_case_purpose,pre_case_purpose,next_hear_date,isadjourn,case_no,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 32 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008646
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 18945000001102
adjourn_remark =
isadjourn = YES
trn_rcms_caseid = 17643000003996
case_no = 2019/00163
court_code = 10399
pre_hear_date = 11/09/2024
next_hear_date = 16/10/2024
new_case_purpose = 18472000000000
pre_case_purpose = 18472000000000
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=10888000008646
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:22
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = c
trn_rcms_caseid=17643000003996
Param Type = c
case_no=2019/00163
Param Type = c
court_code=10399
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
next_hear_date=16/10/2024 00:00:00
Param Type = c
new_case_purpose=18472000000000
Param Type = n
pre_case_purpose=18472000000000
Param Type = n
trn_rcms_hearingrow=32
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_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 = 5
Adding new record to store data from Frame 2, Row 33 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008647
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = YES
adjourn_type = 18945000001102
adjourn_remark =
case_no = 2022/105
court_code = 10399
pre_hear_date = 11/09/2024
trn_rcms_caseid = 14319000006605
next_hear_date = 22/10/2024
new_case_purpose = 18472000000000
pre_case_purpose = 18472000000000
TRN_RCMS_HEARINGrow = 33
Posting record
Param Type = n
trn_rcms_hearingid=10888000008647
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:22
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
case_no=2022/105
Param Type = c
court_code=10399
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = c
trn_rcms_caseid=14319000006605
Param Type = c
next_hear_date=22/10/2024 00:00:00
Param Type = c
new_case_purpose=18472000000000
Param Type = n
pre_case_purpose=18472000000000
Param Type = n
trn_rcms_hearingrow=33
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,case_no,court_code,pre_hear_date,trn_rcms_caseid,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 16
Adding new record to store data from Frame 2, Row 34 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 10888000008648
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = YES
adjourn_remark =
adjourn_type = 18945000001102
next_hear_date = 22/10/2024
trn_rcms_caseid = 14367000005683
case_no = 2022/106
court_code = 10399
new_case_purpose = 18472000000000
pre_case_purpose = 18472000000000
pre_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 34
Posting record
Param Type = n
trn_rcms_hearingid=10888000008648
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:22
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
next_hear_date=22/10/2024 00:00:00
Param Type = c
trn_rcms_caseid=14367000005683
Param Type = c
case_no=2022/106
Param Type = c
court_code=10399
Param Type = c
new_case_purpose=18472000000000
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=34
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 16
Adding new record to store data from Frame 2, Row 35 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 10888000008649
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 22/10/2024
isadjourn = YES
adjourn_remark =
adjourn_type = 18945000001102
trn_rcms_caseid = 14421000006191
court_code = 10399
case_no = 2022/107
new_case_purpose = 18472000000000
pre_case_purpose = 18472000000000
pre_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 35
Posting record
Param Type = n
trn_rcms_hearingid=10888000008649
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:23
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/10/2024 00:00:00
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
trn_rcms_caseid=14421000006191
Param Type = c
court_code=10399
Param Type = c
case_no=2022/107
Param Type = c
new_case_purpose=18472000000000
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=35
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,court_code,case_no,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:court_code,:case_no,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 36 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008650
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 22/10/2024
isadjourn = YES
adjourn_remark =
adjourn_type = 18945000001102
new_case_purpose = 18472000000000
case_no = 2022/108
court_code = 10399
trn_rcms_caseid = 14454000005989
pre_case_purpose = 18472000000000
pre_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 36
Posting record
Param Type = n
trn_rcms_hearingid=10888000008650
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:23
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/10/2024 00:00:00
Param Type = c
isadjourn=YES
Param Type = c
adjourn_type=18945000001102
Param Type = c
new_case_purpose=18472000000000
Param Type = c
case_no=2022/108
Param Type = c
court_code=10399
Param Type = c
trn_rcms_caseid=14454000005989
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=36
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 8
Adding new record to store data from Frame 2, Row 37 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 10888000008651
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 23
next_hear_date = 22/10/2024
new_case_purpose = 18472000000000
adjourn_remark =
adjourn_type = 18945000001102
isadjourn = YES
case_no = 2022/33
court_code = 10399
trn_rcms_caseid = 15526000006365
pre_case_purpose = 18472000000000
pre_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 37
Posting record
Param Type = n
trn_rcms_hearingid=10888000008651
Param Type = n
trn_rcms_mhearingid=10888000008614
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:23
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/10/2024 00:00:00
Param Type = c
new_case_purpose=18472000000000
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = c
case_no=2022/33
Param Type = c
court_code=10399
Param Type = c
trn_rcms_caseid=15526000006365
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
pre_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=37
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 = 3935226448707
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14089000005730 idvalue 0
Mapped case_no Row = 1 value = 2021/217 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 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 = 08/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 14089000005730
case_no = 2021/217
prev_hearing_date = 11/09/2024
hearing_date = 08/10/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 = 13
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008652
MapName trcmf1
SourceId 10888000008615
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 08/10/2024
case_no = 2021/217
trn_rcms_caseregid = 14089000005730
court_code = 10399
case_purpose = 18473000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008652
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008615
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:23
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=08/10/2024 00:00:00
Param Type = c
case_no=2021/217
Param Type = c
trn_rcms_caseregid=14089000005730
Param Type = c
court_code=10399
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 2
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10840000006382 idvalue 0
Mapped case_no Row = 1 value = 2022/173 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 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 = 08/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 10840000006382
case_no = 2022/173
prev_hearing_date = 11/09/2024
hearing_date = 08/10/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
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 = 10888000008653
MapName trcmf1
SourceId 10888000008616
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 08/10/2024
case_no = 2022/173
trn_rcms_caseregid = 10840000006382
court_code = 10399
case_purpose = 18473000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008653
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008616
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:25
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=08/10/2024 00:00:00
Param Type = c
case_no=2022/173
Param Type = c
trn_rcms_caseregid=10840000006382
Param Type = c
court_code=10399
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 3
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12407000007269 idvalue 0
Mapped case_no Row = 1 value = 2023/149 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 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 = 08/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 12407000007269
case_no = 2023/149
prev_hearing_date = 11/09/2024
hearing_date = 08/10/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008654
MapName trcmf1
SourceId 10888000008617
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 08/10/2024
case_no = 2023/149
trn_rcms_caseregid = 12407000007269
court_code = 10399
case_purpose = 18473000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008654
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008617
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:26
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=08/10/2024 00:00:00
Param Type = c
case_no=2023/149
Param Type = c
trn_rcms_caseregid=12407000007269
Param Type = c
court_code=10399
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 4
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18641000007004 idvalue 0
Mapped case_no Row = 1 value = 2023/172 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 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 = 24/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 18641000007004
case_no = 2023/172
prev_hearing_date = 11/09/2024
hearing_date = 24/09/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
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 = 4
RecordId = 10888000008655
MapName trcmf1
SourceId 10888000008618
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 24/09/2024
case_no = 2023/172
trn_rcms_caseregid = 18641000007004
court_code = 10399
case_purpose = 18473000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008655
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008618
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:28
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=24/09/2024 00:00:00
Param Type = c
case_no=2023/172
Param Type = c
trn_rcms_caseregid=18641000007004
Param Type = c
court_code=10399
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 5
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18713000008062 idvalue 0
Mapped case_no Row = 1 value = 2023/173 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 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 = 24/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 18713000008062
case_no = 2023/173
prev_hearing_date = 11/09/2024
hearing_date = 24/09/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008656
MapName trcmf1
SourceId 10888000008619
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 = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 24/09/2024
case_no = 2023/173
trn_rcms_caseregid = 18713000008062
court_code = 10399
case_purpose = 18473000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008656
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008619
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:29
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:29
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=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=24/09/2024 00:00:00
Param Type = c
case_no=2023/173
Param Type = c
trn_rcms_caseregid=18713000008062
Param Type = c
court_code=10399
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 6
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17645000007171 idvalue 0
Mapped case_no Row = 1 value = 2023/214 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 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 = 09/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 17645000007171
case_no = 2023/214
prev_hearing_date = 11/09/2024
hearing_date = 09/10/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10888000008657
MapName trcmf1
SourceId 10888000008620
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 09/10/2024
case_no = 2023/214
trn_rcms_caseregid = 17645000007171
court_code = 10399
case_purpose = 18473000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008657
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008620
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:31
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:31
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=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=09/10/2024 00:00:00
Param Type = c
case_no=2023/214
Param Type = c
trn_rcms_caseregid=17645000007171
Param Type = c
court_code=10399
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 7
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17223000009352 idvalue 0
Mapped case_no Row = 1 value = 2024/103 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 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 = 08/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 17223000009352
case_no = 2024/103
prev_hearing_date = 11/09/2024
hearing_date = 08/10/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008658
MapName trcmf1
SourceId 10888000008621
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 08/10/2024
case_no = 2024/103
trn_rcms_caseregid = 17223000009352
court_code = 10399
case_purpose = 18473000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008658
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008621
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:32
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=08/10/2024 00:00:00
Param Type = c
case_no=2024/103
Param Type = c
trn_rcms_caseregid=17223000009352
Param Type = c
court_code=10399
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 8
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18417000008330 idvalue 0
Mapped case_no Row = 1 value = 2024/53 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 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 = 16/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 18417000008330
case_no = 2024/53
prev_hearing_date = 11/09/2024
hearing_date = 16/10/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10888000008659
MapName trcmf1
SourceId 10888000008622
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 16/10/2024
case_no = 2024/53
trn_rcms_caseregid = 18417000008330
court_code = 10399
case_purpose = 18473000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008659
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008622
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:33
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=16/10/2024 00:00:00
Param Type = c
case_no=2024/53
Param Type = c
trn_rcms_caseregid=18417000008330
Param Type = c
court_code=10399
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 9
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11935000008690 idvalue 0
Mapped case_no Row = 1 value = 2024/84 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 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 = 08/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 11935000008690
case_no = 2024/84
prev_hearing_date = 11/09/2024
hearing_date = 08/10/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 10888000008660
MapName trcmf1
SourceId 10888000008623
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 = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 08/10/2024
case_no = 2024/84
trn_rcms_caseregid = 11935000008690
court_code = 10399
case_purpose = 18473000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008660
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008623
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:35
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=08/10/2024 00:00:00
Param Type = c
case_no=2024/84
Param Type = c
trn_rcms_caseregid=11935000008690
Param Type = c
court_code=10399
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 10
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16082000002105 idvalue 0
Mapped case_no Row = 1 value = 2018/00070 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 16082000002105
case_no = 2018/00070
prev_hearing_date = 11/09/2024
hearing_date = 16/10/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 = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
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 = 10888000008661
MapName trcmf1
SourceId 10888000008624
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 16/10/2024
case_no = 2018/00070
trn_rcms_caseregid = 16082000002105
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008661
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008624
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:36
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:36
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=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=16/10/2024 00:00:00
Param Type = c
case_no=2018/00070
Param Type = c
trn_rcms_caseregid=16082000002105
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 11
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10465000006340 idvalue 0
Mapped case_no Row = 1 value = 2021/212 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 10465000006340
case_no = 2021/212
prev_hearing_date = 11/09/2024
hearing_date = 16/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 16
RecordId = 10888000008662
MapName trcmf1
SourceId 10888000008625
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 16/10/2024
case_no = 2021/212
trn_rcms_caseregid = 10465000006340
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008662
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008625
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:38
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32: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=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=16/10/2024 00:00:00
Param Type = c
case_no=2021/212
Param Type = c
trn_rcms_caseregid=10465000006340
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 12
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13355000006359 idvalue 0
Mapped case_no Row = 1 value = 2022/286 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 13355000006359
case_no = 2022/286
prev_hearing_date = 11/09/2024
hearing_date = 16/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008663
MapName trcmf1
SourceId 10888000008626
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 = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 16/10/2024
case_no = 2022/286
trn_rcms_caseregid = 13355000006359
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008663
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008626
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:39
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32: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=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=16/10/2024 00:00:00
Param Type = c
case_no=2022/286
Param Type = c
trn_rcms_caseregid=13355000006359
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 13
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15273000006595 idvalue 0
Mapped case_no Row = 1 value = 2022/350 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 21/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 15273000006595
case_no = 2022/350
prev_hearing_date = 11/09/2024
hearing_date = 21/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008664
MapName trcmf1
SourceId 10888000008627
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/10/2024
case_no = 2022/350
trn_rcms_caseregid = 15273000006595
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008664
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008627
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:40
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32: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=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/10/2024 00:00:00
Param Type = c
case_no=2022/350
Param Type = c
trn_rcms_caseregid=15273000006595
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 14
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10711000008272 idvalue 0
Mapped case_no Row = 1 value = 2023/263 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 21/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 10711000008272
case_no = 2023/263
prev_hearing_date = 11/09/2024
hearing_date = 21/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
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 = 3
RecordId = 10888000008665
MapName trcmf1
SourceId 10888000008628
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/10/2024
case_no = 2023/263
trn_rcms_caseregid = 10711000008272
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008665
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008628
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:42
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:42
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=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/10/2024 00:00:00
Param Type = c
case_no=2023/263
Param Type = c
trn_rcms_caseregid=10711000008272
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 15
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10763000007609 idvalue 0
Mapped case_no Row = 1 value = 2023/264 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 21/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 10763000007609
case_no = 2023/264
prev_hearing_date = 11/09/2024
hearing_date = 21/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008666
MapName trcmf1
SourceId 10888000008629
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/10/2024
case_no = 2023/264
trn_rcms_caseregid = 10763000007609
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008666
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008629
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:43
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/10/2024 00:00:00
Param Type = c
case_no=2023/264
Param Type = c
trn_rcms_caseregid=10763000007609
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 16
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10876000008834 idvalue 0
Mapped case_no Row = 1 value = 2023/266 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 21/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 10876000008834
case_no = 2023/266
prev_hearing_date = 11/09/2024
hearing_date = 21/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
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 = 10888000008667
MapName trcmf1
SourceId 10888000008630
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/10/2024
case_no = 2023/266
trn_rcms_caseregid = 10876000008834
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008667
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008630
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:44
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/10/2024 00:00:00
Param Type = c
case_no=2023/266
Param Type = c
trn_rcms_caseregid=10876000008834
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 17
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19589000008103 idvalue 0
Mapped case_no Row = 1 value = 2023/37 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 21/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 19589000008103
case_no = 2023/37
prev_hearing_date = 11/09/2024
hearing_date = 21/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008668
MapName trcmf1
SourceId 10888000008631
Select sysdate as sdt from dual
Time elapsed = 208
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/10/2024
case_no = 2023/37
trn_rcms_caseregid = 19589000008103
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008668
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008631
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:46
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:46
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=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/10/2024 00:00:00
Param Type = c
case_no=2023/37
Param Type = c
trn_rcms_caseregid=19589000008103
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 18
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16156000007872 idvalue 0
Mapped case_no Row = 1 value = 2024/160 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 07/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 16156000007872
case_no = 2024/160
prev_hearing_date = 11/09/2024
hearing_date = 07/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
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 = 10888000008669
MapName trcmf1
SourceId 10888000008632
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 = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 07/10/2024
case_no = 2024/160
trn_rcms_caseregid = 16156000007872
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008669
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008632
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:48
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:48
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=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=07/10/2024 00:00:00
Param Type = c
case_no=2024/160
Param Type = c
trn_rcms_caseregid=16156000007872
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 19
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18782000009456 idvalue 0
Mapped case_no Row = 1 value = 2024/161 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 18782000009456
case_no = 2024/161
prev_hearing_date = 11/09/2024
hearing_date = 22/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008670
MapName trcmf1
SourceId 10888000008633
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 10
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/10/2024
case_no = 2024/161
trn_rcms_caseregid = 18782000009456
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008670
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008633
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:49
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/10/2024 00:00:00
Param Type = c
case_no=2024/161
Param Type = c
trn_rcms_caseregid=18782000009456
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 20
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11943000010314 idvalue 0
Mapped case_no Row = 1 value = 2024/165 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 11943000010314
case_no = 2024/165
prev_hearing_date = 11/09/2024
hearing_date = 09/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008671
MapName trcmf1
SourceId 10888000008634
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 = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/10/2024
case_no = 2024/165
trn_rcms_caseregid = 11943000010314
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008671
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008634
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:50
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:50
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=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/10/2024 00:00:00
Param Type = c
case_no=2024/165
Param Type = c
trn_rcms_caseregid=11943000010314
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 21
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11967000008752 idvalue 0
Mapped case_no Row = 1 value = 2024/166 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 11967000008752
case_no = 2024/166
prev_hearing_date = 11/09/2024
hearing_date = 09/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008672
MapName trcmf1
SourceId 10888000008635
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/10/2024
case_no = 2024/166
trn_rcms_caseregid = 11967000008752
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008672
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008635
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:52
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:52
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=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/10/2024 00:00:00
Param Type = c
case_no=2024/166
Param Type = c
trn_rcms_caseregid=11967000008752
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 22
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12004000009715 idvalue 0
Mapped case_no Row = 1 value = 2024/167 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 12004000009715
case_no = 2024/167
prev_hearing_date = 11/09/2024
hearing_date = 09/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008673
MapName trcmf1
SourceId 10888000008636
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 = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/10/2024
case_no = 2024/167
trn_rcms_caseregid = 12004000009715
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008673
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008636
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:53
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/10/2024 00:00:00
Param Type = c
case_no=2024/167
Param Type = c
trn_rcms_caseregid=12004000009715
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 23
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12035000007682 idvalue 0
Mapped case_no Row = 1 value = 2024/168 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 12035000007682
case_no = 2024/168
prev_hearing_date = 11/09/2024
hearing_date = 09/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008674
MapName trcmf1
SourceId 10888000008637
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 212
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/10/2024
case_no = 2024/168
trn_rcms_caseregid = 12035000007682
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008674
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008637
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:55
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/10/2024 00:00:00
Param Type = c
case_no=2024/168
Param Type = c
trn_rcms_caseregid=12035000007682
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 24
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12069000009183 idvalue 0
Mapped case_no Row = 1 value = 2024/169 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 12069000009183
case_no = 2024/169
prev_hearing_date = 11/09/2024
hearing_date = 09/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
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 = 10888000008675
MapName trcmf1
SourceId 10888000008638
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 = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/10/2024
case_no = 2024/169
trn_rcms_caseregid = 12069000009183
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008675
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008638
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:56
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:56
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=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/10/2024 00:00:00
Param Type = c
case_no=2024/169
Param Type = c
trn_rcms_caseregid=12069000009183
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 25
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12091000008577 idvalue 0
Mapped case_no Row = 1 value = 2024/170 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 12091000008577
case_no = 2024/170
prev_hearing_date = 11/09/2024
hearing_date = 09/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
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 = 10888000008676
MapName trcmf1
SourceId 10888000008639
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/10/2024
case_no = 2024/170
trn_rcms_caseregid = 12091000008577
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008676
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008639
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:58
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/10/2024 00:00:00
Param Type = c
case_no=2024/170
Param Type = c
trn_rcms_caseregid=12091000008577
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 26
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17804000009778 idvalue 0
Mapped case_no Row = 1 value = 2024/179 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 17804000009778
case_no = 2024/179
prev_hearing_date = 11/09/2024
hearing_date = 08/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 10888000008677
MapName trcmf1
SourceId 10888000008640
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/10/2024
case_no = 2024/179
trn_rcms_caseregid = 17804000009778
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008677
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008640
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:32:59
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:32:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/10/2024 00:00:00
Param Type = c
case_no=2024/179
Param Type = c
trn_rcms_caseregid=17804000009778
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 27
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17859000008962 idvalue 0
Mapped case_no Row = 1 value = 2024/180 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 17859000008962
case_no = 2024/180
prev_hearing_date = 11/09/2024
hearing_date = 22/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008678
MapName trcmf1
SourceId 10888000008641
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/10/2024
case_no = 2024/180
trn_rcms_caseregid = 17859000008962
court_code = 10399
case_purpose = 18678000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008678
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008641
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:33:00
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:33:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/10/2024 00:00:00
Param Type = c
case_no=2024/180
Param Type = c
trn_rcms_caseregid=17859000008962
Param Type = c
court_code=10399
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 28
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16864000003428 idvalue 0
Mapped case_no Row = 1 value = 2019/00159 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 16864000003428
case_no = 2019/00159
prev_hearing_date = 11/09/2024
hearing_date = 16/10/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 = 10
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10888000008679
MapName trcmf1
SourceId 10888000008642
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 16/10/2024
case_no = 2019/00159
trn_rcms_caseregid = 16864000003428
court_code = 10399
case_purpose = 18472000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008679
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008642
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:33:02
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:33:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=16/10/2024 00:00:00
Param Type = c
case_no=2019/00159
Param Type = c
trn_rcms_caseregid=16864000003428
Param Type = c
court_code=10399
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 29
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17093000003449 idvalue 0
Mapped case_no Row = 1 value = 2019/00160 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 17093000003449
case_no = 2019/00160
prev_hearing_date = 11/09/2024
hearing_date = 16/10/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 10888000008680
MapName trcmf1
SourceId 10888000008643
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 16/10/2024
case_no = 2019/00160
trn_rcms_caseregid = 17093000003449
court_code = 10399
case_purpose = 18472000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008680
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008643
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:33:03
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:33:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=16/10/2024 00:00:00
Param Type = c
case_no=2019/00160
Param Type = c
trn_rcms_caseregid=17093000003449
Param Type = c
court_code=10399
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 30
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17279000003240 idvalue 0
Mapped case_no Row = 1 value = 2019/00161 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 17279000003240
case_no = 2019/00161
prev_hearing_date = 11/09/2024
hearing_date = 16/10/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
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 = 10888000008681
MapName trcmf1
SourceId 10888000008644
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 16/10/2024
case_no = 2019/00161
trn_rcms_caseregid = 17279000003240
court_code = 10399
case_purpose = 18472000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008681
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008644
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:33:05
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:33:05
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=16/10/2024 00:00:00
Param Type = c
case_no=2019/00161
Param Type = c
trn_rcms_caseregid=17279000003240
Param Type = c
court_code=10399
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 31
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17530000003237 idvalue 0
Mapped case_no Row = 1 value = 2019/00162 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 17530000003237
case_no = 2019/00162
prev_hearing_date = 11/09/2024
hearing_date = 16/10/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
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 = 11
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 10888000008682
MapName trcmf1
SourceId 10888000008645
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 16/10/2024
case_no = 2019/00162
trn_rcms_caseregid = 17530000003237
court_code = 10399
case_purpose = 18472000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008682
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008645
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:33:06
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:33:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=16/10/2024 00:00:00
Param Type = c
case_no=2019/00162
Param Type = c
trn_rcms_caseregid=17530000003237
Param Type = c
court_code=10399
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 32
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17643000003996 idvalue 0
Mapped case_no Row = 1 value = 2019/00163 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 16/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 17643000003996
case_no = 2019/00163
prev_hearing_date = 11/09/2024
hearing_date = 16/10/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 10888000008683
MapName trcmf1
SourceId 10888000008646
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 16/10/2024
case_no = 2019/00163
trn_rcms_caseregid = 17643000003996
court_code = 10399
case_purpose = 18472000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008683
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008646
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:33:07
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:33:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=16/10/2024 00:00:00
Param Type = c
case_no=2019/00163
Param Type = c
trn_rcms_caseregid=17643000003996
Param Type = c
court_code=10399
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 33
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14319000006605 idvalue 0
Mapped case_no Row = 1 value = 2022/105 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 14319000006605
case_no = 2022/105
prev_hearing_date = 11/09/2024
hearing_date = 22/10/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008684
MapName trcmf1
SourceId 10888000008647
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 22/10/2024
case_no = 2022/105
trn_rcms_caseregid = 14319000006605
court_code = 10399
case_purpose = 18472000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008684
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008647
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:33:09
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:33:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=22/10/2024 00:00:00
Param Type = c
case_no=2022/105
Param Type = c
trn_rcms_caseregid=14319000006605
Param Type = c
court_code=10399
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 34
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14367000005683 idvalue 0
Mapped case_no Row = 1 value = 2022/106 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 14367000005683
case_no = 2022/106
prev_hearing_date = 11/09/2024
hearing_date = 22/10/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 10888000008685
MapName trcmf1
SourceId 10888000008648
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 22/10/2024
case_no = 2022/106
trn_rcms_caseregid = 14367000005683
court_code = 10399
case_purpose = 18472000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008685
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008648
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:33:10
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:33:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=22/10/2024 00:00:00
Param Type = c
case_no=2022/106
Param Type = c
trn_rcms_caseregid=14367000005683
Param Type = c
court_code=10399
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 35
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14421000006191 idvalue 0
Mapped case_no Row = 1 value = 2022/107 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 14421000006191
case_no = 2022/107
prev_hearing_date = 11/09/2024
hearing_date = 22/10/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008686
MapName trcmf1
SourceId 10888000008649
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 22/10/2024
case_no = 2022/107
trn_rcms_caseregid = 14421000006191
court_code = 10399
case_purpose = 18472000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008686
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008649
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:33:11
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:33:11
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=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=22/10/2024 00:00:00
Param Type = c
case_no=2022/107
Param Type = c
trn_rcms_caseregid=14421000006191
Param Type = c
court_code=10399
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 36
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14454000005989 idvalue 0
Mapped case_no Row = 1 value = 2022/108 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 14454000005989
case_no = 2022/108
prev_hearing_date = 11/09/2024
hearing_date = 22/10/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
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 = 10888000008687
MapName trcmf1
SourceId 10888000008650
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 22/10/2024
case_no = 2022/108
trn_rcms_caseregid = 14454000005989
court_code = 10399
case_purpose = 18472000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008687
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008650
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:33:13
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:33:13
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=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=22/10/2024 00:00:00
Param Type = c
case_no=2022/108
Param Type = c
trn_rcms_caseregid=14454000005989
Param Type = c
court_code=10399
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 37
>>Mapping
Mapped court_code Row = 1 value = 10399 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15526000006365 idvalue 0
Mapped case_no Row = 1 value = 2022/33 idvalue 0
Mapped prev_hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/10/2024 idvalue 0
Mapped isadjourn Row = 1 value = YES idvalue 0
Mapped adjourn_type Row = 1 value = 18945000001102 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10399
trn_rcms_caseregid = 15526000006365
case_no = 2022/33
prev_hearing_date = 11/09/2024
hearing_date = 22/10/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = YES
adjourn_type = 18945000001102
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10888000008688
MapName trcmf1
SourceId 10888000008651
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 18945000001102
isadjourn = YES
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 22/10/2024
case_no = 2022/33
trn_rcms_caseregid = 15526000006365
court_code = 10399
case_purpose = 18472000000000
prev_hearing_date = 11/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=10888000008688
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10888000008651
Param Type = c
cancel=F
Param Type = c
createdby=DM_badmer_r
Param Type = c
createdon=11/09/2024 14:33:14
Param Type = c
username=DM_badmer_r
Param Type = c
modifiedon=11/09/2024 14:33:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=18945000001102
Param Type = c
isadjourn=YES
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=22/10/2024 00:00:00
Param Type = c
case_no=2022/33
Param Type = c
trn_rcms_caseregid=15526000006365
Param Type = c
court_code=10399
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=11/09/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
Time elapsed for Gen Map = 3935226501682
Time elapsed for MD Map = 3935226501684
Time elapsed for Save History = 3935226501685
Time elapsed for Save Attachment = 3935226501686
Time elapsed for After Save WF Exec = 3935226501701
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"10888000008614"}]}
Savedata webservice completed
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=DM_badmer_r
Param Type = c
calledon=11/09/2024 14:27:23
Param Type = c
callfinished=11/09/2024 14:28:21
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=58411
Param Type = n
dbtimetaken=54119
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