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_Bandikui827ccb0eea8a706c4c34a16891f84e7b![]()
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_Bandikui
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Bandikui
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ????? ???????, ????????,???? -????
Result = ????? ???????, ????????,???? -????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=SDO_Bandikui
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Bandikui
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = SDO
Result = SDO
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=SDO_Bandikui
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Bandikui
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 18499000000012
Result = 18499000000012
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_Bandikui
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 4133
Result = 4133
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_Bandikui
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_Bandikui
Result = SDO_Bandikui
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_Bandikui
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10742
Result = 10742
Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Bandikui
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Bandikui
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Dausa
Result = Dausa
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Bandikui
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Bandikui
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=4133
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=4133
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=SDO_Bandikui
Time elapsed = 7
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_Bandikui
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_Bandikui
Time elapsed = 10
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_admin
Result = court_admin
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 6
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_Bandikui
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_Bandikui
Time elapsed = 24
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 4
Result = 4
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_admin') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 4
select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 9
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_admin,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 4
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 = 9
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 = 10742
hearing_date = 04/11/2024
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 21
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 16741000009839
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 20
hearing_date = 04/11/2024
courtcode = 10742
Posting record
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:22
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=04/11/2024 00:00:00
Param Type = c
courtcode=10742
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 = 7
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 16741000009840
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 6
court_code = 10742
adjourn_remark =
new_case_purpose = 18473000000000
pre_hear_date = 04/11/2024
case_no = 2019/00303
isadjourn = NO
next_hear_date = 22/11/2024
pre_case_purpose = 18473000000000
adjourn_type = 0
trn_rcms_caseid = 11465000003315
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=16741000009840
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:22
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10742
Param Type = c
new_case_purpose=18473000000000
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
case_no=2019/00303
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=22/11/2024 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=11465000003315
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,adjourn_remark,new_case_purpose,pre_hear_date,case_no,isadjourn,next_hear_date,pre_case_purpose,adjourn_type,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,null,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:adjourn_type,:trn_rcms_caseid,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009841
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
court_code = 10742
case_no = 2021/503
isadjourn = NO
next_hear_date = 02/12/2024
adjourn_remark =
adjourn_type = 0
pre_hear_date = 04/11/2024
trn_rcms_caseid = 14587000005594
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=16741000009841
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:23
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10742
Param Type = c
case_no=2021/503
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=02/12/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
trn_rcms_caseid=14587000005594
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,case_no,isadjourn,next_hear_date,adjourn_remark,adjourn_type,pre_hear_date,trn_rcms_caseid,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,:court_code,:case_no,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 8
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 16741000009842
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 9
pre_hear_date = 04/11/2024
pre_case_purpose = 12555000000002
trn_rcms_caseid = 19657000008069
court_code = 10742
case_no = 2023/187
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 12555000000002
next_hear_date = 05/12/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=16741000009842
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:23
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
trn_rcms_caseid=19657000008069
Param Type = c
court_code=10742
Param Type = c
case_no=2023/187
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=12555000000002
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 17
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 16741000009843
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 18
pre_hear_date = 04/11/2024
pre_case_purpose = 1000525
trn_rcms_caseid = 19605000008424
court_code = 10742
case_no = 2023/186
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000525
next_hear_date = 05/12/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=16741000009843
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:23
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = n
pre_case_purpose=1000525
Param Type = c
trn_rcms_caseid=19605000008424
Param Type = c
court_code=10742
Param Type = c
case_no=2023/186
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 15
RecordId = 16741000009844
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 22/11/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2019/00302
court_code = 10742
trn_rcms_caseid = 11419000002969
pre_case_purpose = 18678000000000
pre_hear_date = 04/11/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=16741000009844
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:23
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/11/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2019/00302
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=11419000002969
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 3
RecordId = 16741000009845
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 18/11/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/155
court_code = 10742
trn_rcms_caseid = 14350000007557
pre_case_purpose = 18678000000000
pre_hear_date = 04/11/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=16741000009845
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:23
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=18/11/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/155
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=14350000007557
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 16741000009846
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
next_hear_date = 08/11/2024
pre_hear_date = 04/11/2024
court_code = 10742
case_no = 2023/363
trn_rcms_caseid = 13311000009673
adjourn_remark =
adjourn_type = 0
isadjourn = NO
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=16741000009846
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:23
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/11/2024 00:00:00
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
court_code=10742
Param Type = c
case_no=2023/363
Param Type = c
trn_rcms_caseid=13311000009673
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,new_case_purpose,next_hear_date,pre_hear_date,court_code,case_no,trn_rcms_caseid,adjourn_remark,adjourn_type,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,null,:adjourn_type,:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 16741000009847
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 5
trn_rcms_caseid = 13384000008470
pre_hear_date = 04/11/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
court_code = 10742
case_no = 2023/364
adjourn_remark =
next_hear_date = 08/11/2024
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=16741000009847
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:23
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=13384000008470
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=10742
Param Type = c
case_no=2023/364
Param Type = c
next_hear_date=08/11/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
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,trn_rcms_caseid,pre_hear_date,new_case_purpose,pre_case_purpose,court_code,case_no,adjourn_remark,next_hear_date,isadjourn,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:court_code,:case_no,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 16741000009848
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
new_case_purpose = 18678000000000
isadjourn = NO
next_hear_date = 04/12/2024
pre_case_purpose = 18678000000000
case_no = 2024/107
court_code = 10742
pre_hear_date = 04/11/2024
trn_rcms_caseid = 15089000009213
adjourn_remark =
adjourn_type = 0
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=16741000009848
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:24
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=04/12/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2024/107
Param Type = c
court_code=10742
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
trn_rcms_caseid=15089000009213
Param Type = c
adjourn_type=0
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,new_case_purpose,isadjourn,next_hear_date,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 18
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 = 4
RecordId = 16741000009849
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2024/108
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 15102000008373
pre_hear_date = 04/11/2024
adjourn_remark =
court_code = 10742
adjourn_type = 0
next_hear_date = 04/12/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=16741000009849
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:24
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2024/108
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=15102000008373
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
court_code=10742
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=04/12/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 5
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009850
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 04/12/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/115
court_code = 10742
trn_rcms_caseid = 18778000009096
pre_case_purpose = 18678000000000
pre_hear_date = 04/11/2024
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=16741000009850
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:24
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=04/12/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/115
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=18778000009096
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 9
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009851
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 29/11/2024
isadjourn = NO
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 04/11/2024
case_no = 2024/125
court_code = 10742
trn_rcms_caseid = 11592000008707
adjourn_type = 0
adjourn_remark =
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=16741000009851
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:24
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=29/11/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
case_no=2024/125
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=11592000008707
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_type,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:adjourn_type,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009852
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 0
case_no = 2024/29
court_code = 10742
isadjourn = NO
next_hear_date = 09/12/2024
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
pre_hear_date = 04/11/2024
adjourn_remark =
trn_rcms_caseid = 12518000009055
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=16741000009852
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:24
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/29
Param Type = c
court_code=10742
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=09/12/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
trn_rcms_caseid=12518000009055
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,case_no,court_code,isadjourn,next_hear_date,pre_case_purpose,new_case_purpose,pre_hear_date,adjourn_remark,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,:case_no,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:trn_rcms_caseid,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 16741000009853
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
court_code = 10742
isadjourn = NO
next_hear_date = 08/11/2024
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18678000000000
pre_hear_date = 04/11/2024
trn_rcms_caseid = 18556000009086
case_no = 2024/295
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=16741000009853
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:24
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10742
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=08/11/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
trn_rcms_caseid=18556000009086
Param Type = c
case_no=2024/295
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=14
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,pre_hear_date,trn_rcms_caseid,case_no,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 16741000009854
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
court_code = 10742
pre_case_purpose = 18678000000000
case_no = 2024/3
trn_rcms_caseid = 16337000009210
pre_hear_date = 04/11/2024
new_case_purpose = 18678000000000
adjourn_type = 0
adjourn_remark =
next_hear_date = 05/12/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=16741000009854
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:24
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10742
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2024/3
Param Type = c
trn_rcms_caseid=16337000009210
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
isadjourn=NO
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,court_code,pre_case_purpose,case_no,trn_rcms_caseid,pre_hear_date,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:pre_case_purpose,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009855
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
trn_rcms_caseid = 10668000008598
pre_hear_date = 04/11/2024
court_code = 10742
case_no = 2024/317
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 05/12/2024
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=16741000009855
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:24
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=10668000008598
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
court_code=10742
Param Type = c
case_no=2024/317
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=05/12/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,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 17
RecordId = 16741000009856
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 10844000009483
court_code = 10742
case_no = 2024/320
pre_hear_date = 04/11/2024
new_case_purpose = 18678000000000
adjourn_type = 0
pre_case_purpose = 18678000000000
next_hear_date = 05/12/2024
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=16741000009856
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:25
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=10844000009483
Param Type = c
court_code=10742
Param Type = c
case_no=2024/320
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
next_hear_date=05/12/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,adjourn_remark,isadjourn,trn_rcms_caseid,court_code,case_no,pre_hear_date,new_case_purpose,adjourn_type,pre_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:isadjourn,:trn_rcms_caseid,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009857
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 16376000008137
pre_hear_date = 04/11/2024
court_code = 10742
case_no = 2024/344
next_hear_date = 18/11/2024
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=16741000009857
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:25
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=16376000008137
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
court_code=10742
Param Type = c
case_no=2024/344
Param Type = c
next_hear_date=18/11/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,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 = 17
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 = 5
RecordId = 16741000009858
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 16371000008891
pre_hear_date = 04/11/2024
court_code = 10742
case_no = 2024/4
next_hear_date = 05/12/2024
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=16741000009858
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:25
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=16371000008891
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
court_code=10742
Param Type = c
case_no=2024/4
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,trn_rcms_caseid,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,:adjourn_type,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009859
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_type = 0
adjourn_remark =
isadjourn = NO
case_no = 2024/61
trn_rcms_caseid = 13430000008335
pre_case_purpose = 18678000000000
court_code = 10742
next_hear_date = 22/11/2024
new_case_purpose = 18678000000000
pre_hear_date = 04/11/2024
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=16741000009859
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:25
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:25
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
case_no=2024/61
Param Type = c
trn_rcms_caseid=13430000008335
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=10742
Param Type = c
next_hear_date=22/11/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=04/11/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,adjourn_type,adjourn_remark,isadjourn,case_no,trn_rcms_caseid,pre_case_purpose,court_code,next_hear_date,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,:adjourn_type,null,:isadjourn,:case_no,:trn_rcms_caseid,:pre_case_purpose,:court_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009860
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 13747000007573
case_no = 2024/62
court_code = 10742
pre_hear_date = 04/11/2024
next_hear_date = 22/11/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=16741000009860
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:25
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13747000007573
Param Type = c
case_no=2024/62
Param Type = c
court_code=10742
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = c
next_hear_date=22/11/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009861
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 18/11/2024
trn_rcms_caseid = 16849000008856
case_no = 2024/80
court_code = 10742
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 04/11/2024
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=16741000009861
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:25
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:25
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=18/11/2024 00:00:00
Param Type = c
trn_rcms_caseid=16849000008856
Param Type = c
case_no=2024/80
Param Type = c
court_code=10742
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=04/11/2024 00:00:00
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,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 = 6
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009862
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 18/11/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 17169000008400
court_code = 10742
case_no = 2024/83
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 04/11/2024
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=16741000009862
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:25
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=18/11/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=17169000008400
Param Type = c
court_code=10742
Param Type = c
case_no=2024/83
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=04/11/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009863
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 16
next_hear_date = 22/11/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18625000000000
case_no = 2022/436
court_code = 10742
trn_rcms_caseid = 13829000006592
pre_case_purpose = 18625000000000
pre_hear_date = 04/11/2024
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=16741000009863
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:26
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/11/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18625000000000
Param Type = c
case_no=2022/436
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=13829000006592
Param Type = n
pre_case_purpose=18625000000000
Param Type = c
pre_hear_date=04/11/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,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009864
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 15
next_hear_date = 03/12/2024
new_case_purpose = 11417000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2022/213
court_code = 10742
trn_rcms_caseid = 17456000007252
pre_case_purpose = 11417000000000
pre_hear_date = 04/11/2024
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=16741000009864
Param Type = n
trn_rcms_mhearingid=16741000009839
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:26
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=03/12/2024 00:00:00
Param Type = c
new_case_purpose=11417000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2022/213
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=17456000007252
Param Type = n
pre_case_purpose=11417000000000
Param Type = c
pre_hear_date=04/11/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,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 = 3939966686920
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11465000003315 idvalue 0
Mapped case_no Row = 1 value = 2019/00303 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/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 = 22/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 11465000003315
case_no = 2019/00303
prev_hearing_date = 04/11/2024
hearing_date = 22/11/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purposename=???
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???
Time elapsed = 7
prev_case_purpose after validation = 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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 16741000009865
MapName trcmf1
SourceId 16741000009840
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 27
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 22/11/2024
case_no = 2019/00303
trn_rcms_caseregid = 11465000003315
court_code = 10742
case_purpose = 18473000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009865
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009840
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:26
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=22/11/2024 00:00:00
Param Type = c
case_no=2019/00303
Param Type = c
trn_rcms_caseregid=11465000003315
Param Type = c
court_code=10742
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 2
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14587000005594 idvalue 0
Mapped case_no Row = 1 value = 2021/503 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 02/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 14587000005594
case_no = 2021/503
prev_hearing_date = 04/11/2024
hearing_date = 02/12/2024
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purposename=??????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ????
Time elapsed = 7
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 6
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 16741000009866
MapName trcmf1
SourceId 16741000009841
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 02/12/2024
case_no = 2021/503
trn_rcms_caseregid = 14587000005594
court_code = 10742
case_purpose = 18466000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009866
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009841
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:28
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=02/12/2024 00:00:00
Param Type = c
case_no=2021/503
Param Type = c
trn_rcms_caseregid=14587000005594
Param Type = c
court_code=10742
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 3
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19657000008069 idvalue 0
Mapped case_no Row = 1 value = 2023/187 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 19657000008069
case_no = 2023/187
prev_hearing_date = 04/11/2024
hearing_date = 05/12/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purposename=???? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????????? ????
Time elapsed = 8
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
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 = 16741000009867
MapName trcmf1
SourceId 16741000009842
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 05/12/2024
case_no = 2023/187
trn_rcms_caseregid = 19657000008069
court_code = 10742
case_purpose = 12555000000002
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009867
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009842
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:30
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11: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=12555000000002
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2023/187
Param Type = c
trn_rcms_caseregid=19657000008069
Param Type = c
court_code=10742
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 4
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19605000008424 idvalue 0
Mapped case_no Row = 1 value = 2023/186 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/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 = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 19605000008424
case_no = 2023/186
prev_hearing_date = 04/11/2024
hearing_date = 05/12/2024
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purposename=???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????
Time elapsed = 6
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009868
MapName trcmf1
SourceId 16741000009843
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 05/12/2024
case_no = 2023/186
trn_rcms_caseregid = 19605000008424
court_code = 10742
case_purpose = 1000525
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009868
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009843
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:31
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11: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=1000525
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2023/186
Param Type = c
trn_rcms_caseregid=19605000008424
Param Type = c
court_code=10742
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 5
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11419000002969 idvalue 0
Mapped case_no Row = 1 value = 2019/00302 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 11419000002969
case_no = 2019/00302
prev_hearing_date = 04/11/2024
hearing_date = 22/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 7
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009869
MapName trcmf1
SourceId 16741000009844
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/11/2024
case_no = 2019/00302
trn_rcms_caseregid = 11419000002969
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009869
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009844
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:33
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/11/2024 00:00:00
Param Type = c
case_no=2019/00302
Param Type = c
trn_rcms_caseregid=11419000002969
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 6
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14350000007557 idvalue 0
Mapped case_no Row = 1 value = 2023/155 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 14350000007557
case_no = 2023/155
prev_hearing_date = 04/11/2024
hearing_date = 18/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009870
MapName trcmf1
SourceId 16741000009845
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 18/11/2024
case_no = 2023/155
trn_rcms_caseregid = 14350000007557
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009870
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009845
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:34
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=18/11/2024 00:00:00
Param Type = c
case_no=2023/155
Param Type = c
trn_rcms_caseregid=14350000007557
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 7
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13311000009673 idvalue 0
Mapped case_no Row = 1 value = 2023/363 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 13311000009673
case_no = 2023/363
prev_hearing_date = 04/11/2024
hearing_date = 08/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 16741000009871
MapName trcmf1
SourceId 16741000009846
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/11/2024
case_no = 2023/363
trn_rcms_caseregid = 13311000009673
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009871
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009846
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:36
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/11/2024 00:00:00
Param Type = c
case_no=2023/363
Param Type = c
trn_rcms_caseregid=13311000009673
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 8
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13384000008470 idvalue 0
Mapped case_no Row = 1 value = 2023/364 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 13384000008470
case_no = 2023/364
prev_hearing_date = 04/11/2024
hearing_date = 08/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
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 = 16741000009872
MapName trcmf1
SourceId 16741000009847
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/11/2024
case_no = 2023/364
trn_rcms_caseregid = 13384000008470
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009872
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009847
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:37
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/11/2024 00:00:00
Param Type = c
case_no=2023/364
Param Type = c
trn_rcms_caseregid=13384000008470
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 9
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15089000009213 idvalue 0
Mapped case_no Row = 1 value = 2024/107 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 04/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 15089000009213
case_no = 2024/107
prev_hearing_date = 04/11/2024
hearing_date = 04/12/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 4
RecordId = 16741000009873
MapName trcmf1
SourceId 16741000009848
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 04/12/2024
case_no = 2024/107
trn_rcms_caseregid = 15089000009213
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009873
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009848
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:38
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=04/12/2024 00:00:00
Param Type = c
case_no=2024/107
Param Type = c
trn_rcms_caseregid=15089000009213
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 10
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15102000008373 idvalue 0
Mapped case_no Row = 1 value = 2024/108 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 04/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 15102000008373
case_no = 2024/108
prev_hearing_date = 04/11/2024
hearing_date = 04/12/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 16741000009874
MapName trcmf1
SourceId 16741000009849
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 04/12/2024
case_no = 2024/108
trn_rcms_caseregid = 15102000008373
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009874
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009849
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:40
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=04/12/2024 00:00:00
Param Type = c
case_no=2024/108
Param Type = c
trn_rcms_caseregid=15102000008373
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 11
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18778000009096 idvalue 0
Mapped case_no Row = 1 value = 2024/115 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 04/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 18778000009096
case_no = 2024/115
prev_hearing_date = 04/11/2024
hearing_date = 04/12/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 9
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 16741000009875
MapName trcmf1
SourceId 16741000009850
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 04/12/2024
case_no = 2024/115
trn_rcms_caseregid = 18778000009096
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009875
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009850
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:41
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=04/12/2024 00:00:00
Param Type = c
case_no=2024/115
Param Type = c
trn_rcms_caseregid=18778000009096
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 12
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11592000008707 idvalue 0
Mapped case_no Row = 1 value = 2024/125 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 29/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 11592000008707
case_no = 2024/125
prev_hearing_date = 04/11/2024
hearing_date = 29/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009876
MapName trcmf1
SourceId 16741000009851
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 29/11/2024
case_no = 2024/125
trn_rcms_caseregid = 11592000008707
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009876
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009851
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:43
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=29/11/2024 00:00:00
Param Type = c
case_no=2024/125
Param Type = c
trn_rcms_caseregid=11592000008707
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 13
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12518000009055 idvalue 0
Mapped case_no Row = 1 value = 2024/29 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 12518000009055
case_no = 2024/29
prev_hearing_date = 04/11/2024
hearing_date = 09/12/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009877
MapName trcmf1
SourceId 16741000009852
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/12/2024
case_no = 2024/29
trn_rcms_caseregid = 12518000009055
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009877
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009852
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:44
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/12/2024 00:00:00
Param Type = c
case_no=2024/29
Param Type = c
trn_rcms_caseregid=12518000009055
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 14
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18556000009086 idvalue 0
Mapped case_no Row = 1 value = 2024/295 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 18556000009086
case_no = 2024/295
prev_hearing_date = 04/11/2024
hearing_date = 08/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16741000009878
MapName trcmf1
SourceId 16741000009853
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/11/2024
case_no = 2024/295
trn_rcms_caseregid = 18556000009086
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009878
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009853
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:46
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/11/2024 00:00:00
Param Type = c
case_no=2024/295
Param Type = c
trn_rcms_caseregid=18556000009086
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 15
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16337000009210 idvalue 0
Mapped case_no Row = 1 value = 2024/3 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 16337000009210
case_no = 2024/3
prev_hearing_date = 04/11/2024
hearing_date = 05/12/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009879
MapName trcmf1
SourceId 16741000009854
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/12/2024
case_no = 2024/3
trn_rcms_caseregid = 16337000009210
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009879
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009854
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:47
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/3
Param Type = c
trn_rcms_caseregid=16337000009210
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 16
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10668000008598 idvalue 0
Mapped case_no Row = 1 value = 2024/317 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 10668000008598
case_no = 2024/317
prev_hearing_date = 04/11/2024
hearing_date = 05/12/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 16741000009880
MapName trcmf1
SourceId 16741000009855
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/12/2024
case_no = 2024/317
trn_rcms_caseregid = 10668000008598
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009880
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009855
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:49
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/317
Param Type = c
trn_rcms_caseregid=10668000008598
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 17
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10844000009483 idvalue 0
Mapped case_no Row = 1 value = 2024/320 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 10844000009483
case_no = 2024/320
prev_hearing_date = 04/11/2024
hearing_date = 05/12/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009881
MapName trcmf1
SourceId 16741000009856
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/12/2024
case_no = 2024/320
trn_rcms_caseregid = 10844000009483
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009881
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009856
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:50
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/320
Param Type = c
trn_rcms_caseregid=10844000009483
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 18
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16376000008137 idvalue 0
Mapped case_no Row = 1 value = 2024/344 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 16376000008137
case_no = 2024/344
prev_hearing_date = 04/11/2024
hearing_date = 18/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 16741000009882
MapName trcmf1
SourceId 16741000009857
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 18/11/2024
case_no = 2024/344
trn_rcms_caseregid = 16376000008137
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009882
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009857
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:51
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=18/11/2024 00:00:00
Param Type = c
case_no=2024/344
Param Type = c
trn_rcms_caseregid=16376000008137
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 19
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16371000008891 idvalue 0
Mapped case_no Row = 1 value = 2024/4 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 16371000008891
case_no = 2024/4
prev_hearing_date = 04/11/2024
hearing_date = 05/12/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 16741000009883
MapName trcmf1
SourceId 16741000009858
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/12/2024
case_no = 2024/4
trn_rcms_caseregid = 16371000008891
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009883
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009858
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:53
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/4
Param Type = c
trn_rcms_caseregid=16371000008891
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 20
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13430000008335 idvalue 0
Mapped case_no Row = 1 value = 2024/61 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 13430000008335
case_no = 2024/61
prev_hearing_date = 04/11/2024
hearing_date = 22/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 16741000009884
MapName trcmf1
SourceId 16741000009859
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/11/2024
case_no = 2024/61
trn_rcms_caseregid = 13430000008335
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009884
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009859
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:54
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/11/2024 00:00:00
Param Type = c
case_no=2024/61
Param Type = c
trn_rcms_caseregid=13430000008335
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 21
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13747000007573 idvalue 0
Mapped case_no Row = 1 value = 2024/62 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 13747000007573
case_no = 2024/62
prev_hearing_date = 04/11/2024
hearing_date = 22/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 16741000009885
MapName trcmf1
SourceId 16741000009860
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/11/2024
case_no = 2024/62
trn_rcms_caseregid = 13747000007573
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009885
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009860
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:56
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/11/2024 00:00:00
Param Type = c
case_no=2024/62
Param Type = c
trn_rcms_caseregid=13747000007573
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 22
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16849000008856 idvalue 0
Mapped case_no Row = 1 value = 2024/80 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 16849000008856
case_no = 2024/80
prev_hearing_date = 04/11/2024
hearing_date = 18/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 16741000009886
MapName trcmf1
SourceId 16741000009861
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 18/11/2024
case_no = 2024/80
trn_rcms_caseregid = 16849000008856
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009886
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009861
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:57
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=18/11/2024 00:00:00
Param Type = c
case_no=2024/80
Param Type = c
trn_rcms_caseregid=16849000008856
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 23
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17169000008400 idvalue 0
Mapped case_no Row = 1 value = 2024/83 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 17169000008400
case_no = 2024/83
prev_hearing_date = 04/11/2024
hearing_date = 18/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 16741000009887
MapName trcmf1
SourceId 16741000009862
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 18/11/2024
case_no = 2024/83
trn_rcms_caseregid = 17169000008400
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009887
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009862
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:11:59
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:11:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=18/11/2024 00:00:00
Param Type = c
case_no=2024/83
Param Type = c
trn_rcms_caseregid=17169000008400
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 24
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13829000006592 idvalue 0
Mapped case_no Row = 1 value = 2022/436 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18625000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 13829000006592
case_no = 2022/436
prev_hearing_date = 04/11/2024
hearing_date = 22/11/2024
prev_case_purposename = ????????? ???????
prev_case_purpose =
prev_case_purposename=????????? ???????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????????? ???????
Time elapsed = 9
prev_case_purpose after validation = 18625000000000
case_purpose = 18625000000000
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 = 17
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 = 16741000009888
MapName trcmf1
SourceId 16741000009863
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18625000000000
hearing_date = 22/11/2024
case_no = 2022/436
trn_rcms_caseregid = 13829000006592
court_code = 10742
case_purpose = 18625000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009888
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009863
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:12:01
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:12:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18625000000000
Param Type = c
hearing_date=22/11/2024 00:00:00
Param Type = c
case_no=2022/436
Param Type = c
trn_rcms_caseregid=13829000006592
Param Type = c
court_code=10742
Param Type = c
case_purpose=18625000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 25
>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17456000007252 idvalue 0
Mapped case_no Row = 1 value = 2022/213 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 11417000000000 idvalue 0
Mapped hearing_date Row = 1 value = 03/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 17456000007252
case_no = 2022/213
prev_hearing_date = 04/11/2024
hearing_date = 03/12/2024
prev_case_purposename = ??????? ???????
prev_case_purpose =
prev_case_purposename=??????? ???????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ???????
Time elapsed = 6
prev_case_purpose after validation = 11417000000000
case_purpose = 11417000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 16741000009889
MapName trcmf1
SourceId 16741000009864
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 11417000000000
hearing_date = 03/12/2024
case_no = 2022/213
trn_rcms_caseregid = 17456000007252
court_code = 10742
case_purpose = 11417000000000
prev_hearing_date = 04/11/2024
Posting record
Param Type = n
trn_rcms_case_histid=16741000009889
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16741000009864
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=05/11/2024 11:12:02
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=05/11/2024 11:12:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=11417000000000
Param Type = c
hearing_date=03/12/2024 00:00:00
Param Type = c
case_no=2022/213
Param Type = c
trn_rcms_caseregid=17456000007252
Param Type = c
court_code=10742
Param Type = c
case_purpose=11417000000000
Param Type = c
prev_hearing_date=04/11/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
Time elapsed for Gen Map = 3939966724473
Time elapsed for MD Map = 3939966724474
Time elapsed for Save History = 3939966724476
Time elapsed for Save Attachment = 3939966724477
Time elapsed for After Save WF Exec = 3939966724480
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"16741000009839"}]}
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_Bandikui
Param Type = c
calledon=05/11/2024 11:11:22
Param Type = c
callfinished=05/11/2024 11:12:04
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=42020
Param Type = n
dbtimetaken=38692
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