ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
gcmsSDO_aamet827ccb0eea8a706c4c34a16891f84e7b![]()
INRF500250000Ffiresql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtname := sqlget({m2},{court_name})firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})m_courttype := sqlget({m3},{court_type})firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})m_courtid := sqlget({m4},{court_name_mastid})firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})login_userid := sqlget({m4},{axusersid})firesql({m4},{select :username as uname from dual})u_name := sqlget({m4},{uname})firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtcode := sqlget({m4},{COURT_CODE})firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})m_statename := sqlget({m2},{STATE_NAME})firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_distName := sqlget({m7},{DISTNAMEENG})firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_courtcatid := sqlget({m8},{COURT_CATEGOTY})firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})m_deptid := sqlget({m4},{department_mastid})firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})m_courttypeid := sqlget({m3},{court_type_mastid})firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })urole := sqlget({m4},{groupname})firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})m_cutoffdt := sqlget({a1},{dd})firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})m_offcount := sqlget({P1},{ct})00000F
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
username=SDO_aamet
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_aamet
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = SDO, ????,????????
Result = SDO, ????,????????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=SDO_aamet
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_aamet
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = SDO
Result = SDO
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=SDO_aamet
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_aamet
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 12122000000044
Result = 12122000000044
Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=SDO_aamet
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 3277
Result = 3277
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_aamet
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_aamet
Result = SDO_aamet
Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_aamet
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10167
Result = 10167
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 = 3
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_aamet
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_aamet
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Rajsamand
Result = Rajsamand
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_aamet
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_aamet
Time elapsed = 6
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=3277
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=3277
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=SDO_aamet
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10823000000000
Result = 10823000000000
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=SDO_aamet
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=SDO_aamet
Time elapsed = 6
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 = 3
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=SDO_aamet
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=SDO_aamet
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 1
Result = 1
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 = 3
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 4
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_reader,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 3
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : trcmf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 4
Step4
tstructs\stm size:2075
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Evaluating date()
Result =
Evaluating iif((next_hear_date>Validating trcmf
>>Frame No 1
courtcode = 10167
hearing_date = 10/01/2024
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 2
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009139
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
hearing_date = 10/01/2024
courtcode = 10167
Posting record
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:26
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=10/01/2024 00:00:00
Param Type = c
courtcode=10167
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 = 4
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 = 3
RecordId = 12304000009140
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2014/00057
isadjourn = NO
adjourn_type = 0
trn_rcms_caseid = 219993
adjourn_remark =
pre_case_purpose = 1000492
court_code = 10167
pre_hear_date = 10/01/2024
next_hear_date = 28/02/2024
new_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=12304000009140
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:26
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2014/00057
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=219993
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=10167
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,isadjourn,adjourn_type,trn_rcms_caseid,adjourn_remark,pre_case_purpose,court_code,pre_hear_date,next_hear_date,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:isadjourn,:adjourn_type,:trn_rcms_caseid,null,:pre_case_purpose,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 2
RecordId = 12304000009141
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_case_purpose = 1000492
new_case_purpose = 1000492
pre_hear_date = 10/01/2024
court_code = 10167
case_no = 2014/00066
trn_rcms_caseid = 220006
adjourn_type = 0
adjourn_remark =
next_hear_date = 28/02/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=12304000009141
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:26
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = c
court_code=10167
Param Type = c
case_no=2014/00066
Param Type = c
trn_rcms_caseid=220006
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,new_case_purpose,pre_hear_date,court_code,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009142
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 28/02/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2014/00138
court_code = 10167
trn_rcms_caseid = 10068000004953
pre_case_purpose = 1000492
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=12304000009142
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:26
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2014/00138
Param Type = c
court_code=10167
Param Type = c
trn_rcms_caseid=10068000004953
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 3
RecordId = 12304000009143
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 10/01/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 10665000000270
court_code = 10167
case_no = 2016/00041
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 28/02/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=12304000009143
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:26
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=10665000000270
Param Type = c
court_code=10167
Param Type = c
case_no=2016/00041
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
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 = 3
RecordId = 12304000009144
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 28/02/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2017/00194
court_code = 10167
trn_rcms_caseid = 14351000001702
pre_case_purpose = 1000492
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=12304000009144
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:26
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2017/00194
Param Type = c
court_code=10167
Param Type = c
trn_rcms_caseid=14351000001702
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=10/01/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 = 4
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12304000009145
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 12/01/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2018/00111
court_code = 10167
trn_rcms_caseid = 11711000002529
pre_case_purpose = 1000492
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=12304000009145
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:26
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=12/01/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2018/00111
Param Type = c
court_code=10167
Param Type = c
trn_rcms_caseid=11711000002529
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12304000009146
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 28/02/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2018/00114
court_code = 10167
trn_rcms_caseid = 17482000002780
pre_case_purpose = 1000492
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=12304000009146
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:26
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2018/00114
Param Type = c
court_code=10167
Param Type = c
trn_rcms_caseid=17482000002780
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009147
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 24/01/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2019/00123
court_code = 10167
trn_rcms_caseid = 13598000005232
pre_case_purpose = 1000492
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=12304000009147
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:26
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/01/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2019/00123
Param Type = c
court_code=10167
Param Type = c
trn_rcms_caseid=13598000005232
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 12304000009148
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 28/02/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2020/00078
court_code = 10167
trn_rcms_caseid = 13659000005385
pre_case_purpose = 1000492
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=12304000009148
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:27
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2020/00078
Param Type = c
court_code=10167
Param Type = c
trn_rcms_caseid=13659000005385
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009149
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_case_purpose = 1000492
court_code = 10167
pre_hear_date = 10/01/2024
case_no = 2020/00114
trn_rcms_caseid = 17385000006160
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 24/01/2024
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=12304000009149
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:27
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=10167
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = c
case_no=2020/00114
Param Type = c
trn_rcms_caseid=17385000006160
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=24/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,court_code,pre_hear_date,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12304000009150
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 28/02/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 19970000006334
pre_hear_date = 10/01/2024
case_no = 2021/101
pre_case_purpose = 1000492
court_code = 10167
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=12304000009150
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:27
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=19970000006334
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = c
case_no=2021/101
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=10167
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,case_no,pre_case_purpose,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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:pre_case_purpose,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12304000009151
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trn_rcms_caseid = 19978000006120
case_no = 2021/102
court_code = 10167
new_case_purpose = 1000492
next_hear_date = 28/02/2024
pre_hear_date = 10/01/2024
pre_case_purpose = 1000492
adjourn_type = 0
adjourn_remark =
isadjourn = NO
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=12304000009151
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:27
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=19978000006120
Param Type = c
case_no=2021/102
Param Type = c
court_code=10167
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
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,trn_rcms_caseid,case_no,court_code,new_case_purpose,next_hear_date,pre_hear_date,pre_case_purpose,adjourn_type,adjourn_remark,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,:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:adjourn_type,null,:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12304000009152
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_case_purpose = 1000492
court_code = 10167
case_no = 2021/149
trn_rcms_caseid = 15971000008089
adjourn_remark =
next_hear_date = 24/01/2024
isadjourn = NO
adjourn_type = 0
new_case_purpose = 1000492
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=12304000009152
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:27
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=10167
Param Type = c
case_no=2021/149
Param Type = c
trn_rcms_caseid=15971000008089
Param Type = c
next_hear_date=24/01/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,court_code,case_no,trn_rcms_caseid,adjourn_remark,next_hear_date,isadjourn,adjourn_type,new_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,:pre_case_purpose,:court_code,:case_no,:trn_rcms_caseid,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:adjourn_type,:new_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 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12304000009153
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
case_no = 2021/150
trn_rcms_caseid = 15982000005560
adjourn_remark =
court_code = 10167
new_case_purpose = 1000492
next_hear_date = 24/01/2024
isadjourn = NO
pre_hear_date = 10/01/2024
pre_case_purpose = 1000492
adjourn_type = 0
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=12304000009153
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:27
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2021/150
Param Type = c
trn_rcms_caseid=15982000005560
Param Type = c
court_code=10167
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=24/01/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
adjourn_type=0
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,case_no,trn_rcms_caseid,adjourn_remark,court_code,new_case_purpose,next_hear_date,isadjourn,pre_hear_date,pre_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,:case_no,:trn_rcms_caseid,null,:court_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009154
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 10/01/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 12344000006198
court_code = 10167
case_no = 2021/157
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 28/02/2024
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=12304000009154
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:27
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=12344000006198
Param Type = c
court_code=10167
Param Type = c
case_no=2021/157
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=28/02/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 = 5
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009155
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 10/01/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 14566000006462
court_code = 10167
case_no = 2022/103
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 28/02/2024
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=12304000009155
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:27
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=14566000006462
Param Type = c
court_code=10167
Param Type = c
case_no=2022/103
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 2
RecordId = 12304000009156
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 24/01/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2022/130
court_code = 10167
trn_rcms_caseid = 13598000006605
pre_case_purpose = 1000492
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=12304000009156
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:27
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/01/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/130
Param Type = c
court_code=10167
Param Type = c
trn_rcms_caseid=13598000006605
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009157
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 10/01/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 18898000007861
court_code = 10167
case_no = 2023/115
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 24/01/2024
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=12304000009157
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:27
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=18898000007861
Param Type = c
court_code=10167
Param Type = c
case_no=2023/115
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=24/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 2
RecordId = 12304000009158
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2023/133
new_case_purpose = 1000492
pre_case_purpose = 1000492
trn_rcms_caseid = 10012000008289
pre_hear_date = 10/01/2024
adjourn_remark =
court_code = 10167
adjourn_type = 0
next_hear_date = 12/01/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=12304000009158
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:27
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/133
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=10012000008289
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = c
court_code=10167
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=12/01/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 4
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009159
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
new_case_purpose = 1000492
adjourn_remark =
next_hear_date = 12/01/2024
adjourn_type = 0
isadjourn = NO
court_code = 10167
case_no = 2023/134
trn_rcms_caseid = 10036000007700
pre_case_purpose = 1000492
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=12304000009159
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:27
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=12/01/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
court_code=10167
Param Type = c
case_no=2023/134
Param Type = c
trn_rcms_caseid=10036000007700
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,adjourn_remark,next_hear_date,adjourn_type,isadjourn,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,:new_case_purpose,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,: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 = 4
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009160
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trn_rcms_caseid = 14185000008035
pre_hear_date = 10/01/2024
pre_case_purpose = 1000492
case_no = 2023/137
adjourn_remark =
next_hear_date = 24/01/2024
court_code = 10167
isadjourn = NO
new_case_purpose = 1000492
adjourn_type = 0
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=12304000009160
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:27
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=14185000008035
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
case_no=2023/137
Param Type = c
next_hear_date=24/01/2024 00:00:00
Param Type = c
court_code=10167
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
adjourn_type=0
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,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,adjourn_remark,next_hear_date,court_code,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'),:pre_case_purpose,:case_no,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,: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 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12304000009161
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
isadjourn = NO
court_code = 10167
adjourn_type = 0
adjourn_remark =
next_hear_date = 12/01/2024
pre_hear_date = 10/01/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 17384000007562
new_case_purpose = 1000492
case_no = 2023/164
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=12304000009161
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:28
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
court_code=10167
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=12/01/2024 00:00:00
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=17384000007562
Param Type = c
new_case_purpose=1000492
Param Type = c
case_no=2023/164
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,isadjourn,court_code,adjourn_type,adjourn_remark,next_hear_date,pre_hear_date,pre_case_purpose,trn_rcms_caseid,new_case_purpose,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:court_code,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:new_case_purpose,:case_no,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009162
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 10/01/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 17405000008533
court_code = 10167
case_no = 2023/165
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 12/01/2024
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=12304000009162
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:28
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=17405000008533
Param Type = c
court_code=10167
Param Type = c
case_no=2023/165
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=12/01/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,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009163
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 28/02/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/75
court_code = 10167
trn_rcms_caseid = 10164000008139
pre_case_purpose = 1000492
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=12304000009163
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:28
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/75
Param Type = c
court_code=10167
Param Type = c
trn_rcms_caseid=10164000008139
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3
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 = 3
RecordId = 12304000009164
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 28/02/2024
case_no = 2023/76
court_code = 10167
trn_rcms_caseid = 10183000007748
pre_case_purpose = 1000492
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=12304000009164
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:28
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
case_no=2023/76
Param Type = c
court_code=10167
Param Type = c
trn_rcms_caseid=10183000007748
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009165
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 28/02/2024
new_case_purpose = 1000492
adjourn_type = 0
isadjourn = NO
pre_case_purpose = 1000492
court_code = 10167
case_no = 2023/77
pre_hear_date = 10/01/2024
trn_rcms_caseid = 10188000008141
adjourn_remark =
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=12304000009165
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:28
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=10167
Param Type = c
case_no=2023/77
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = c
trn_rcms_caseid=10188000008141
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_type,isadjourn,pre_case_purpose,court_code,case_no,pre_hear_date,trn_rcms_caseid,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:isadjourn,:pre_case_purpose,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 4
RecordId = 12304000009166
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 28/02/2024
isadjourn = NO
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
pre_hear_date = 10/01/2024
adjourn_remark =
court_code = 10167
trn_rcms_caseid = 219779
case_no = 2010/00002
adjourn_type = 0
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=12304000009166
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:28
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = c
court_code=10167
Param Type = c
trn_rcms_caseid=219779
Param Type = c
case_no=2010/00002
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=27
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,adjourn_remark,court_code,trn_rcms_caseid,case_no,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:trn_rcms_caseid,:case_no,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 3
RecordId = 12304000009167
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 10/01/2024
pre_case_purpose = 18473000000000
trn_rcms_caseid = 220181
court_code = 10167
case_no = 2011/00036
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 24/01/2024
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=12304000009167
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:28
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=220181
Param Type = c
court_code=10167
Param Type = c
case_no=2011/00036
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=24/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 3
RecordId = 12304000009168
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 28/02/2024
new_case_purpose = 18473000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2012/00059
court_code = 10167
trn_rcms_caseid = 220050
pre_case_purpose = 18473000000000
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=12304000009168
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:28
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2012/00059
Param Type = c
court_code=10167
Param Type = c
trn_rcms_caseid=220050
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=10/01/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,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 = 3
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 = 3
RecordId = 12304000009169
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_case_purpose = 18473000000000
court_code = 10167
pre_hear_date = 10/01/2024
case_no = 2013/00052
trn_rcms_caseid = 219995
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 24/01/2024
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=12304000009169
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:28
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
court_code=10167
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = c
case_no=2013/00052
Param Type = c
trn_rcms_caseid=219995
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=24/01/2024 00:00:00
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,pre_case_purpose,court_code,pre_hear_date,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 2
RecordId = 12304000009170
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark =
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
isadjourn = NO
next_hear_date = 28/02/2024
case_no = 2014/00056
court_code = 10167
pre_hear_date = 10/01/2024
trn_rcms_caseid = 219992
adjourn_type = 0
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=12304000009170
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:28
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
case_no=2014/00056
Param Type = c
court_code=10167
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = c
trn_rcms_caseid=219992
Param Type = c
adjourn_type=0
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_remark,new_case_purpose,pre_case_purpose,isadjourn,next_hear_date,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:new_case_purpose,:pre_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 2
RecordId = 12304000009171
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trn_rcms_caseid = 11208000001132
case_no = 2017/00139
pre_case_purpose = 18473000000000
pre_hear_date = 10/01/2024
next_hear_date = 28/02/2024
adjourn_type = 0
isadjourn = NO
adjourn_remark =
court_code = 10167
new_case_purpose = 18473000000000
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=12304000009171
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:28
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=11208000001132
Param Type = c
case_no=2017/00139
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
court_code=10167
Param Type = c
new_case_purpose=18473000000000
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,trn_rcms_caseid,case_no,pre_case_purpose,pre_hear_date,next_hear_date,adjourn_type,isadjourn,adjourn_remark,court_code,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,:case_no,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:court_code,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 33 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009172
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 14497000001624
pre_hear_date = 10/01/2024
court_code = 10167
case_no = 2017/00196
next_hear_date = 28/02/2024
isadjourn = NO
pre_case_purpose = 18473000000000
new_case_purpose = 18473000000000
TRN_RCMS_HEARINGrow = 33
Posting record
Param Type = n
trn_rcms_hearingid=12304000009172
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:28
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=14497000001624
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = c
court_code=10167
Param Type = c
case_no=2017/00196
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
new_case_purpose=18473000000000
Param Type = n
trn_rcms_hearingrow=33
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 34 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009173
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_type = 0
adjourn_remark =
pre_hear_date = 10/01/2024
trn_rcms_caseid = 11669000002543
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
next_hear_date = 24/01/2024
isadjourn = NO
case_no = 2018/00110
court_code = 10167
TRN_RCMS_HEARINGrow = 34
Posting record
Param Type = n
trn_rcms_hearingid=12304000009173
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:28
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = c
trn_rcms_caseid=11669000002543
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
next_hear_date=24/01/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2018/00110
Param Type = c
court_code=10167
Param Type = n
trn_rcms_hearingrow=34
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,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 = 3
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 = 2
RecordId = 12304000009174
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 11745000000396
case_no = 2015/00110
court_code = 10167
pre_hear_date = 10/01/2024
next_hear_date = 28/02/2024
new_case_purpose = 11415000000002
pre_case_purpose = 11415000000002
TRN_RCMS_HEARINGrow = 35
Posting record
Param Type = n
trn_rcms_hearingid=12304000009174
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:29
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=11745000000396
Param Type = c
case_no=2015/00110
Param Type = c
court_code=10167
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
new_case_purpose=11415000000002
Param Type = n
pre_case_purpose=11415000000002
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,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 36 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009175
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
isadjourn = NO
adjourn_type = 0
adjourn_remark =
case_no = 2017/00195
court_code = 10167
pre_hear_date = 10/01/2024
trn_rcms_caseid = 14433000001509
next_hear_date = 28/02/2024
new_case_purpose = 11415000000002
pre_case_purpose = 11415000000002
TRN_RCMS_HEARINGrow = 36
Posting record
Param Type = n
trn_rcms_hearingid=12304000009175
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:29
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2017/00195
Param Type = c
court_code=10167
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = c
trn_rcms_caseid=14433000001509
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
new_case_purpose=11415000000002
Param Type = n
pre_case_purpose=11415000000002
Param Type = n
trn_rcms_hearingrow=36
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_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 = 4
Adding new record to store data from Frame 2, Row 37 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009176
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 28/02/2024
trn_rcms_caseid = 219999
case_no = 2014/00060
court_code = 10167
new_case_purpose = 1000525
pre_case_purpose = 1000525
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 37
Posting record
Param Type = n
trn_rcms_hearingid=12304000009176
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:29
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
trn_rcms_caseid=219999
Param Type = c
case_no=2014/00060
Param Type = c
court_code=10167
Param Type = c
new_case_purpose=1000525
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=10/01/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,isadjourn,adjourn_remark,adjourn_type,next_hear_date,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 38 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009177
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 28/02/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 15739000000224
court_code = 10167
case_no = 2015/00092
new_case_purpose = 1000525
pre_case_purpose = 1000525
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 38
Posting record
Param Type = n
trn_rcms_hearingid=12304000009177
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:29
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=15739000000224
Param Type = c
court_code=10167
Param Type = c
case_no=2015/00092
Param Type = c
new_case_purpose=1000525
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=38
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,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 = 4
Adding new record to store data from Frame 2, Row 39 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009178
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 28/02/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 1000497
case_no = 2018/00125
court_code = 10167
trn_rcms_caseid = 17055000003318
pre_case_purpose = 1000497
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 39
Posting record
Param Type = n
trn_rcms_hearingid=12304000009178
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:29
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000497
Param Type = c
case_no=2018/00125
Param Type = c
court_code=10167
Param Type = c
trn_rcms_caseid=17055000003318
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=39
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 = 4
Adding new record to store data from Frame 2, Row 40 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009179
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 24/01/2024
new_case_purpose = 1000497
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2021/153
court_code = 10167
trn_rcms_caseid = 12330000006785
pre_case_purpose = 1000497
pre_hear_date = 10/01/2024
TRN_RCMS_HEARINGrow = 40
Posting record
Param Type = n
trn_rcms_hearingid=12304000009179
Param Type = n
trn_rcms_mhearingid=12304000009139
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:29
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/01/2024 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2021/153
Param Type = c
court_code=10167
Param Type = c
trn_rcms_caseid=12330000006785
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=10/01/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=40
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 = 3914069936673
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 219993 idvalue 0
Mapped case_no Row = 1 value = 2014/00057 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 219993
case_no = 2014/00057
prev_hearing_date = 10/01/2024
hearing_date = 28/02/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 = 17
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12304000009180
MapName trcmf1
SourceId 12304000009140
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/02/2024
case_no = 2014/00057
trn_rcms_caseregid = 219993
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009180
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009140
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:29
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39: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=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2014/00057
Param Type = c
trn_rcms_caseregid=219993
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 220006 idvalue 0
Mapped case_no Row = 1 value = 2014/00066 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 220006
case_no = 2014/00066
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
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 = 2
RecordId = 12304000009181
MapName trcmf1
SourceId 12304000009141
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/02/2024
case_no = 2014/00066
trn_rcms_caseregid = 220006
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009181
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009141
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:29
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39: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=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2014/00066
Param Type = c
trn_rcms_caseregid=220006
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10068000004953 idvalue 0
Mapped case_no Row = 1 value = 2014/00138 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 10068000004953
case_no = 2014/00138
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009182
MapName trcmf1
SourceId 12304000009142
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/02/2024
case_no = 2014/00138
trn_rcms_caseregid = 10068000004953
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009182
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009142
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:29
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39: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=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2014/00138
Param Type = c
trn_rcms_caseregid=10068000004953
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10665000000270 idvalue 0
Mapped case_no Row = 1 value = 2016/00041 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 10665000000270
case_no = 2016/00041
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12304000009183
MapName trcmf1
SourceId 12304000009143
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/02/2024
case_no = 2016/00041
trn_rcms_caseregid = 10665000000270
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009183
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009143
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:29
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39: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=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2016/00041
Param Type = c
trn_rcms_caseregid=10665000000270
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14351000001702 idvalue 0
Mapped case_no Row = 1 value = 2017/00194 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 14351000001702
case_no = 2017/00194
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009184
MapName trcmf1
SourceId 12304000009144
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/02/2024
case_no = 2017/00194
trn_rcms_caseregid = 14351000001702
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009184
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009144
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:30
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2017/00194
Param Type = c
trn_rcms_caseregid=14351000001702
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11711000002529 idvalue 0
Mapped case_no Row = 1 value = 2018/00111 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 12/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 11711000002529
case_no = 2018/00111
prev_hearing_date = 10/01/2024
hearing_date = 12/01/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12304000009185
MapName trcmf1
SourceId 12304000009145
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 12/01/2024
case_no = 2018/00111
trn_rcms_caseregid = 11711000002529
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009185
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009145
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:30
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=12/01/2024 00:00:00
Param Type = c
case_no=2018/00111
Param Type = c
trn_rcms_caseregid=11711000002529
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17482000002780 idvalue 0
Mapped case_no Row = 1 value = 2018/00114 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 17482000002780
case_no = 2018/00114
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12304000009186
MapName trcmf1
SourceId 12304000009146
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/02/2024
case_no = 2018/00114
trn_rcms_caseregid = 17482000002780
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009186
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009146
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:30
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2018/00114
Param Type = c
trn_rcms_caseregid=17482000002780
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13598000005232 idvalue 0
Mapped case_no Row = 1 value = 2019/00123 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 13598000005232
case_no = 2019/00123
prev_hearing_date = 10/01/2024
hearing_date = 24/01/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12304000009187
MapName trcmf1
SourceId 12304000009147
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/01/2024
case_no = 2019/00123
trn_rcms_caseregid = 13598000005232
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009187
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009147
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:30
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=24/01/2024 00:00:00
Param Type = c
case_no=2019/00123
Param Type = c
trn_rcms_caseregid=13598000005232
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13659000005385 idvalue 0
Mapped case_no Row = 1 value = 2020/00078 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 13659000005385
case_no = 2020/00078
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12304000009188
MapName trcmf1
SourceId 12304000009148
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/02/2024
case_no = 2020/00078
trn_rcms_caseregid = 13659000005385
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009188
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009148
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:30
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2020/00078
Param Type = c
trn_rcms_caseregid=13659000005385
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17385000006160 idvalue 0
Mapped case_no Row = 1 value = 2020/00114 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 17385000006160
case_no = 2020/00114
prev_hearing_date = 10/01/2024
hearing_date = 24/01/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
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 = 12304000009189
MapName trcmf1
SourceId 12304000009149
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/01/2024
case_no = 2020/00114
trn_rcms_caseregid = 17385000006160
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009189
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009149
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:30
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=24/01/2024 00:00:00
Param Type = c
case_no=2020/00114
Param Type = c
trn_rcms_caseregid=17385000006160
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19970000006334 idvalue 0
Mapped case_no Row = 1 value = 2021/101 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 19970000006334
case_no = 2021/101
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12304000009190
MapName trcmf1
SourceId 12304000009150
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/02/2024
case_no = 2021/101
trn_rcms_caseregid = 19970000006334
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009190
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009150
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:30
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2021/101
Param Type = c
trn_rcms_caseregid=19970000006334
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19978000006120 idvalue 0
Mapped case_no Row = 1 value = 2021/102 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 19978000006120
case_no = 2021/102
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009191
MapName trcmf1
SourceId 12304000009151
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/02/2024
case_no = 2021/102
trn_rcms_caseregid = 19978000006120
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009191
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009151
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:30
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2021/102
Param Type = c
trn_rcms_caseregid=19978000006120
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15971000008089 idvalue 0
Mapped case_no Row = 1 value = 2021/149 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 15971000008089
case_no = 2021/149
prev_hearing_date = 10/01/2024
hearing_date = 24/01/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12304000009192
MapName trcmf1
SourceId 12304000009152
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/01/2024
case_no = 2021/149
trn_rcms_caseregid = 15971000008089
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009192
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009152
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:30
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=24/01/2024 00:00:00
Param Type = c
case_no=2021/149
Param Type = c
trn_rcms_caseregid=15971000008089
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15982000005560 idvalue 0
Mapped case_no Row = 1 value = 2021/150 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 15982000005560
case_no = 2021/150
prev_hearing_date = 10/01/2024
hearing_date = 24/01/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009193
MapName trcmf1
SourceId 12304000009153
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/01/2024
case_no = 2021/150
trn_rcms_caseregid = 15982000005560
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009193
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009153
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:31
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39: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=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=24/01/2024 00:00:00
Param Type = c
case_no=2021/150
Param Type = c
trn_rcms_caseregid=15982000005560
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12344000006198 idvalue 0
Mapped case_no Row = 1 value = 2021/157 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 12344000006198
case_no = 2021/157
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12304000009194
MapName trcmf1
SourceId 12304000009154
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/02/2024
case_no = 2021/157
trn_rcms_caseregid = 12344000006198
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009194
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009154
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:31
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39: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=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2021/157
Param Type = c
trn_rcms_caseregid=12344000006198
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14566000006462 idvalue 0
Mapped case_no Row = 1 value = 2022/103 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 14566000006462
case_no = 2022/103
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12304000009195
MapName trcmf1
SourceId 12304000009155
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/02/2024
case_no = 2022/103
trn_rcms_caseregid = 14566000006462
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009195
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009155
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:31
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39: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=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2022/103
Param Type = c
trn_rcms_caseregid=14566000006462
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13598000006605 idvalue 0
Mapped case_no Row = 1 value = 2022/130 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 13598000006605
case_no = 2022/130
prev_hearing_date = 10/01/2024
hearing_date = 24/01/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12304000009196
MapName trcmf1
SourceId 12304000009156
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/01/2024
case_no = 2022/130
trn_rcms_caseregid = 13598000006605
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009196
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009156
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:31
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39: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=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=24/01/2024 00:00:00
Param Type = c
case_no=2022/130
Param Type = c
trn_rcms_caseregid=13598000006605
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18898000007861 idvalue 0
Mapped case_no Row = 1 value = 2023/115 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 18898000007861
case_no = 2023/115
prev_hearing_date = 10/01/2024
hearing_date = 24/01/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12304000009197
MapName trcmf1
SourceId 12304000009157
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/01/2024
case_no = 2023/115
trn_rcms_caseregid = 18898000007861
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009197
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009157
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:31
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39: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=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=24/01/2024 00:00:00
Param Type = c
case_no=2023/115
Param Type = c
trn_rcms_caseregid=18898000007861
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10012000008289 idvalue 0
Mapped case_no Row = 1 value = 2023/133 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 12/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 10012000008289
case_no = 2023/133
prev_hearing_date = 10/01/2024
hearing_date = 12/01/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009198
MapName trcmf1
SourceId 12304000009158
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 12/01/2024
case_no = 2023/133
trn_rcms_caseregid = 10012000008289
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009198
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009158
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:31
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39: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=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=12/01/2024 00:00:00
Param Type = c
case_no=2023/133
Param Type = c
trn_rcms_caseregid=10012000008289
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10036000007700 idvalue 0
Mapped case_no Row = 1 value = 2023/134 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 12/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 10036000007700
case_no = 2023/134
prev_hearing_date = 10/01/2024
hearing_date = 12/01/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009199
MapName trcmf1
SourceId 12304000009159
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 12/01/2024
case_no = 2023/134
trn_rcms_caseregid = 10036000007700
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009199
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009159
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:31
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39: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=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=12/01/2024 00:00:00
Param Type = c
case_no=2023/134
Param Type = c
trn_rcms_caseregid=10036000007700
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14185000008035 idvalue 0
Mapped case_no Row = 1 value = 2023/137 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 24/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 14185000008035
case_no = 2023/137
prev_hearing_date = 10/01/2024
hearing_date = 24/01/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
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 = 2
RecordId = 12304000009200
MapName trcmf1
SourceId 12304000009160
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 24/01/2024
case_no = 2023/137
trn_rcms_caseregid = 14185000008035
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009200
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009160
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:31
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39: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=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=24/01/2024 00:00:00
Param Type = c
case_no=2023/137
Param Type = c
trn_rcms_caseregid=14185000008035
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17384000007562 idvalue 0
Mapped case_no Row = 1 value = 2023/164 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 12/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 17384000007562
case_no = 2023/164
prev_hearing_date = 10/01/2024
hearing_date = 12/01/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12304000009201
MapName trcmf1
SourceId 12304000009161
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 12/01/2024
case_no = 2023/164
trn_rcms_caseregid = 17384000007562
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009201
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009161
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:31
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39: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=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=12/01/2024 00:00:00
Param Type = c
case_no=2023/164
Param Type = c
trn_rcms_caseregid=17384000007562
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17405000008533 idvalue 0
Mapped case_no Row = 1 value = 2023/165 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 12/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 17405000008533
case_no = 2023/165
prev_hearing_date = 10/01/2024
hearing_date = 12/01/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009202
MapName trcmf1
SourceId 12304000009162
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 12/01/2024
case_no = 2023/165
trn_rcms_caseregid = 17405000008533
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009202
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009162
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:32
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=12/01/2024 00:00:00
Param Type = c
case_no=2023/165
Param Type = c
trn_rcms_caseregid=17405000008533
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10164000008139 idvalue 0
Mapped case_no Row = 1 value = 2023/75 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 10164000008139
case_no = 2023/75
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12304000009203
MapName trcmf1
SourceId 12304000009163
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/02/2024
case_no = 2023/75
trn_rcms_caseregid = 10164000008139
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009203
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009163
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:32
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2023/75
Param Type = c
trn_rcms_caseregid=10164000008139
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10183000007748 idvalue 0
Mapped case_no Row = 1 value = 2023/76 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 10183000007748
case_no = 2023/76
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12304000009204
MapName trcmf1
SourceId 12304000009164
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/02/2024
case_no = 2023/76
trn_rcms_caseregid = 10183000007748
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009204
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009164
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:32
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2023/76
Param Type = c
trn_rcms_caseregid=10183000007748
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10188000008141 idvalue 0
Mapped case_no Row = 1 value = 2023/77 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 10188000008141
case_no = 2023/77
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 12304000009205
MapName trcmf1
SourceId 12304000009165
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/02/2024
case_no = 2023/77
trn_rcms_caseregid = 10188000008141
court_code = 10167
case_purpose = 1000492
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009205
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009165
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:32
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2023/77
Param Type = c
trn_rcms_caseregid=10188000008141
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 219779 idvalue 0
Mapped case_no Row = 1 value = 2010/00002 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/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 = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 219779
case_no = 2010/00002
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purposename=???
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???
Time elapsed = 4
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009206
MapName trcmf1
SourceId 12304000009166
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 28/02/2024
case_no = 2010/00002
trn_rcms_caseregid = 219779
court_code = 10167
case_purpose = 18473000000000
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009206
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009166
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:32
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2010/00002
Param Type = c
trn_rcms_caseregid=219779
Param Type = c
court_code=10167
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 220181 idvalue 0
Mapped case_no Row = 1 value = 2011/00036 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/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/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 220181
case_no = 2011/00036
prev_hearing_date = 10/01/2024
hearing_date = 24/01/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
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 = 2
RecordId = 12304000009207
MapName trcmf1
SourceId 12304000009167
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 24/01/2024
case_no = 2011/00036
trn_rcms_caseregid = 220181
court_code = 10167
case_purpose = 18473000000000
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009207
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009167
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:32
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=24/01/2024 00:00:00
Param Type = c
case_no=2011/00036
Param Type = c
trn_rcms_caseregid=220181
Param Type = c
court_code=10167
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 220050 idvalue 0
Mapped case_no Row = 1 value = 2012/00059 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/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 = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 220050
case_no = 2012/00059
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009208
MapName trcmf1
SourceId 12304000009168
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 28/02/2024
case_no = 2012/00059
trn_rcms_caseregid = 220050
court_code = 10167
case_purpose = 18473000000000
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009208
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009168
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:32
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2012/00059
Param Type = c
trn_rcms_caseregid=220050
Param Type = c
court_code=10167
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 219995 idvalue 0
Mapped case_no Row = 1 value = 2013/00052 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/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/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 219995
case_no = 2013/00052
prev_hearing_date = 10/01/2024
hearing_date = 24/01/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009209
MapName trcmf1
SourceId 12304000009169
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 24/01/2024
case_no = 2013/00052
trn_rcms_caseregid = 219995
court_code = 10167
case_purpose = 18473000000000
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009209
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009169
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:32
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=24/01/2024 00:00:00
Param Type = c
case_no=2013/00052
Param Type = c
trn_rcms_caseregid=219995
Param Type = c
court_code=10167
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 219992 idvalue 0
Mapped case_no Row = 1 value = 2014/00056 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/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 = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 219992
case_no = 2014/00056
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009210
MapName trcmf1
SourceId 12304000009170
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 28/02/2024
case_no = 2014/00056
trn_rcms_caseregid = 219992
court_code = 10167
case_purpose = 18473000000000
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009210
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009170
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:33
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2014/00056
Param Type = c
trn_rcms_caseregid=219992
Param Type = c
court_code=10167
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11208000001132 idvalue 0
Mapped case_no Row = 1 value = 2017/00139 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/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 = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 11208000001132
case_no = 2017/00139
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12304000009211
MapName trcmf1
SourceId 12304000009171
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 28/02/2024
case_no = 2017/00139
trn_rcms_caseregid = 11208000001132
court_code = 10167
case_purpose = 18473000000000
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009211
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009171
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:33
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2017/00139
Param Type = c
trn_rcms_caseregid=11208000001132
Param Type = c
court_code=10167
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14497000001624 idvalue 0
Mapped case_no Row = 1 value = 2017/00196 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/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 = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 14497000001624
case_no = 2017/00196
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009212
MapName trcmf1
SourceId 12304000009172
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 28/02/2024
case_no = 2017/00196
trn_rcms_caseregid = 14497000001624
court_code = 10167
case_purpose = 18473000000000
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009212
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009172
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:33
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2017/00196
Param Type = c
trn_rcms_caseregid=14497000001624
Param Type = c
court_code=10167
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11669000002543 idvalue 0
Mapped case_no Row = 1 value = 2018/00110 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/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/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 11669000002543
case_no = 2018/00110
prev_hearing_date = 10/01/2024
hearing_date = 24/01/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12304000009213
MapName trcmf1
SourceId 12304000009173
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 24/01/2024
case_no = 2018/00110
trn_rcms_caseregid = 11669000002543
court_code = 10167
case_purpose = 18473000000000
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009213
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009173
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:33
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=24/01/2024 00:00:00
Param Type = c
case_no=2018/00110
Param Type = c
trn_rcms_caseregid=11669000002543
Param Type = c
court_code=10167
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11745000000396 idvalue 0
Mapped case_no Row = 1 value = 2015/00110 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 11415000000002 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 11745000000396
case_no = 2015/00110
prev_hearing_date = 10/01/2024
hearing_date = 28/02/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 = 11415000000002
case_purpose = 11415000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12304000009214
MapName trcmf1
SourceId 12304000009174
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 11415000000002
hearing_date = 28/02/2024
case_no = 2015/00110
trn_rcms_caseregid = 11745000000396
court_code = 10167
case_purpose = 11415000000002
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009214
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009174
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:33
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=11415000000002
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2015/00110
Param Type = c
trn_rcms_caseregid=11745000000396
Param Type = c
court_code=10167
Param Type = c
case_purpose=11415000000002
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14433000001509 idvalue 0
Mapped case_no Row = 1 value = 2017/00195 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 11415000000002 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 14433000001509
case_no = 2017/00195
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ????? ???????
prev_case_purpose =
prev_case_purpose after validation = 11415000000002
case_purpose = 11415000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12304000009215
MapName trcmf1
SourceId 12304000009175
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 11415000000002
hearing_date = 28/02/2024
case_no = 2017/00195
trn_rcms_caseregid = 14433000001509
court_code = 10167
case_purpose = 11415000000002
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009215
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009175
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:33
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=11415000000002
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2017/00195
Param Type = c
trn_rcms_caseregid=14433000001509
Param Type = c
court_code=10167
Param Type = c
case_purpose=11415000000002
Param Type = c
prev_hearing_date=10/01/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 = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 219999 idvalue 0
Mapped case_no Row = 1 value = 2014/00060 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 219999
case_no = 2014/00060
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purposename=???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????
Time elapsed = 4
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009216
MapName trcmf1
SourceId 12304000009176
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 28/02/2024
case_no = 2014/00060
trn_rcms_caseregid = 219999
court_code = 10167
case_purpose = 1000525
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009216
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009176
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:33
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2014/00060
Param Type = c
trn_rcms_caseregid=219999
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=10/01/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 38
>>Mapping
Mapped court_code Row = 1 value = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15739000000224 idvalue 0
Mapped case_no Row = 1 value = 2015/00092 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 15739000000224
case_no = 2015/00092
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12304000009217
MapName trcmf1
SourceId 12304000009177
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 28/02/2024
case_no = 2015/00092
trn_rcms_caseregid = 15739000000224
court_code = 10167
case_purpose = 1000525
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009217
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009177
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:33
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2015/00092
Param Type = c
trn_rcms_caseregid=15739000000224
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=10/01/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 39
>>Mapping
Mapped court_code Row = 1 value = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17055000003318 idvalue 0
Mapped case_no Row = 1 value = 2018/00125 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 17055000003318
case_no = 2018/00125
prev_hearing_date = 10/01/2024
hearing_date = 28/02/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purposename=???? ?????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????????
Time elapsed = 4
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009218
MapName trcmf1
SourceId 12304000009178
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 28/02/2024
case_no = 2018/00125
trn_rcms_caseregid = 17055000003318
court_code = 10167
case_purpose = 1000497
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009218
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009178
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:33
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2018/00125
Param Type = c
trn_rcms_caseregid=17055000003318
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=10/01/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 40
>>Mapping
Mapped court_code Row = 1 value = 10167 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12330000006785 idvalue 0
Mapped case_no Row = 1 value = 2021/153 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 24/01/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10167
trn_rcms_caseregid = 12330000006785
case_no = 2021/153
prev_hearing_date = 10/01/2024
hearing_date = 24/01/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12304000009219
MapName trcmf1
SourceId 12304000009179
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 24/01/2024
case_no = 2021/153
trn_rcms_caseregid = 12330000006785
court_code = 10167
case_purpose = 1000497
prev_hearing_date = 10/01/2024
Posting record
Param Type = n
trn_rcms_case_histid=12304000009219
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12304000009179
Param Type = c
cancel=F
Param Type = c
createdby=SDO_aamet
Param Type = c
createdon=10/01/2024 17:39:34
Param Type = c
username=SDO_aamet
Param Type = c
modifiedon=10/01/2024 17:39:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=24/01/2024 00:00:00
Param Type = c
case_no=2021/153
Param Type = c
trn_rcms_caseregid=12330000006785
Param Type = c
court_code=10167
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=10/01/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 = 3914069941252
Time elapsed for MD Map = 3914069941253
Time elapsed for Save History = 3914069941254
Time elapsed for Save Attachment = 3914069941255
Time elapsed for After Save WF Exec = 3914069941259
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"12304000009139"}]}
Savedata webservice completed
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=SDO_aamet
Param Type = c
calledon=10/01/2024 17:38:52
Param Type = c
callfinished=10/01/2024 17:39:01
Param Type = c
structname=trcmf
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=success
Param Type = n
timetaken=8368
Param Type = n
dbtimetaken=5104
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