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_Chauhtan827ccb0eea8a706c4c34a16891f84e7b![]()
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_Chauhtan
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Chauhtan
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_Chauhtan
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Chauhtan
Time elapsed = 7
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_Chauhtan
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Chauhtan
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 13816000000066
Result = 13816000000066
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_Chauhtan
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 4089
Result = 4089
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_Chauhtan
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_Chauhtan
Result = SDO_Chauhtan
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_Chauhtan
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10519
Result = 10519
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_Chauhtan
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Chauhtan
Time elapsed = 17
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Barmer
Result = Barmer
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Chauhtan
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Chauhtan
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m8},{COURT_CATEGOTY})
Calling function sqlget
Result of sqlget = 10593000000007
Result = 10593000000007
Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
Calling function firesql
login_userid=4089
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=4089
Time elapsed = 18
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_Chauhtan
Time elapsed = 10
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_Chauhtan
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_Chauhtan
Time elapsed = 10
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_reader
Result = court_reader
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 4
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_Chauhtan
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_Chauhtan
Time elapsed = 11
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 10
Result = 10
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 4
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 8
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_reader,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 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 = 4
Step4
tstructs\stm size:2075
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Evaluating date()
Result =
Evaluating iif((next_hear_date>Validating trcmf
>>Frame No 1
courtcode = 10519
hearing_date = 24/06/2024
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 3
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007247
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 4
hearing_date = 24/06/2024
courtcode = 10519
Posting record
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:16
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:16
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=24/06/2024 00:00:00
Param Type = c
courtcode=10519
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 = 5
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007248
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = NO
case_no = 2015/00202
trn_rcms_caseid = 11990000000706
court_code = 10519
new_case_purpose = 1000497
pre_hear_date = 24/06/2024
adjourn_type = 0
next_hear_date = 20/08/2024
pre_case_purpose = 1000497
adjourn_remark =
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=10500000007248
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:16
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:16
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
case_no=2015/00202
Param Type = c
trn_rcms_caseid=11990000000706
Param Type = c
court_code=10519
Param Type = c
new_case_purpose=1000497
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=20/08/2024 00:00:00
Param Type = n
pre_case_purpose=1000497
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,isadjourn,case_no,trn_rcms_caseid,court_code,new_case_purpose,pre_hear_date,adjourn_type,next_hear_date,pre_case_purpose,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,:isadjourn,:case_no,:trn_rcms_caseid,:court_code,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,null,: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 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007249
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 17
pre_hear_date = 24/06/2024
next_hear_date = 24/09/2024
new_case_purpose = 1000497
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 19381000001530
pre_case_purpose = 1000497
adjourn_type = 0
case_no = 2017/00303
court_code = 10519
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=10500000007249
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:16
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:16
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
next_hear_date=24/09/2024 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=19381000001530
Param Type = n
pre_case_purpose=1000497
Param Type = c
adjourn_type=0
Param Type = c
case_no=2017/00303
Param Type = c
court_code=10519
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,next_hear_date,new_case_purpose,adjourn_remark,isadjourn,trn_rcms_caseid,pre_case_purpose,adjourn_type,case_no,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,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,null,:isadjourn,:trn_rcms_caseid,:pre_case_purpose,:adjourn_type,:case_no,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007250
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 24/06/2024
pre_case_purpose = 1000497
trn_rcms_caseid = 19484000001221
court_code = 10519
case_no = 2017/00304
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 24/09/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=10500000007250
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:16
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:16
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=19484000001221
Param Type = c
court_code=10519
Param Type = c
case_no=2017/00304
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=24/09/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 = 4
RecordId = 10500000007251
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 24/09/2024
new_case_purpose = 1000497
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2018/00047
court_code = 10519
trn_rcms_caseid = 12393000001767
pre_case_purpose = 1000497
pre_hear_date = 24/06/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=10500000007251
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:16
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:16
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/09/2024 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2018/00047
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=12393000001767
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 17
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007252
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 18/07/2024
new_case_purpose = 1000497
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2022/142
court_code = 10519
trn_rcms_caseid = 18324000006573
pre_case_purpose = 1000497
pre_hear_date = 24/06/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=10500000007252
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:16
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:16
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=18/07/2024 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/142
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=18324000006573
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007253
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 02/07/2024
new_case_purpose = 1000497
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/123
court_code = 10519
trn_rcms_caseid = 11652000007655
pre_case_purpose = 1000497
pre_hear_date = 24/06/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=10500000007253
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:17
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=02/07/2024 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/123
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=11652000007655
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=24/06/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 = 3
RecordId = 10500000007254
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 02/07/2024
new_case_purpose = 1000497
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/153
court_code = 10519
trn_rcms_caseid = 14854000007250
pre_case_purpose = 1000497
pre_hear_date = 24/06/2024
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=10500000007254
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:17
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=02/07/2024 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/153
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=14854000007250
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007255
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = NO
new_case_purpose = 1000497
adjourn_type = 0
next_hear_date = 02/07/2024
adjourn_remark =
case_no = 2023/154
court_code = 10519
trn_rcms_caseid = 15005000007175
pre_case_purpose = 1000497
pre_hear_date = 24/06/2024
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=10500000007255
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:17
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=02/07/2024 00:00:00
Param Type = c
case_no=2023/154
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=15005000007175
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,new_case_purpose,adjourn_type,next_hear_date,adjourn_remark,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:new_case_purpose,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007256
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trn_rcms_caseid = 18008000007448
court_code = 10519
case_no = 2023/231
pre_hear_date = 24/06/2024
isadjourn = NO
adjourn_type = 0
adjourn_remark =
pre_case_purpose = 1000497
new_case_purpose = 1000497
next_hear_date = 02/07/2024
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=10500000007256
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:17
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=18008000007448
Param Type = c
court_code=10519
Param Type = c
case_no=2023/231
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=1000497
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=02/07/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,court_code,case_no,pre_hear_date,isadjourn,adjourn_type,adjourn_remark,pre_case_purpose,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,:trn_rcms_caseid,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:adjourn_type,null,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007257
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 24/06/2024
pre_case_purpose = 1000497
trn_rcms_caseid = 18072000007899
court_code = 10519
case_no = 2023/240
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 08/07/2024
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=10500000007257
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:17
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=18072000007899
Param Type = c
court_code=10519
Param Type = c
case_no=2023/240
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=08/07/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,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 = 8
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 = 10500000007258
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
new_case_purpose = 1000497
adjourn_remark =
isadjourn = NO
next_hear_date = 24/09/2024
pre_case_purpose = 1000497
case_no = 2023/507
court_code = 10519
pre_hear_date = 24/06/2024
trn_rcms_caseid = 13883000007964
adjourn_type = 0
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=10500000007258
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:17
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=24/09/2024 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
case_no=2023/507
Param Type = c
court_code=10519
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
trn_rcms_caseid=13883000007964
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,adjourn_remark,isadjourn,next_hear_date,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,null,: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,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007259
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trn_rcms_caseid = 13889000008792
isadjourn = NO
court_code = 10519
adjourn_remark =
adjourn_type = 0
pre_hear_date = 24/06/2024
pre_case_purpose = 1000497
new_case_purpose = 1000497
next_hear_date = 24/09/2024
case_no = 2023/508
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=10500000007259
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:17
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=13889000008792
Param Type = c
isadjourn=NO
Param Type = c
court_code=10519
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=24/09/2024 00:00:00
Param Type = c
case_no=2023/508
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,isadjourn,court_code,adjourn_remark,adjourn_type,pre_hear_date,pre_case_purpose,new_case_purpose,next_hear_date,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,:isadjourn,:court_code,null,:adjourn_type,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007260
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
court_code = 10519
isadjourn = NO
next_hear_date = 20/08/2024
adjourn_remark =
adjourn_type = 0
new_case_purpose = 1000497
trn_rcms_caseid = 13896000007951
case_no = 2023/510
pre_case_purpose = 1000497
pre_hear_date = 24/06/2024
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=10500000007260
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:17
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10519
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=20/08/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000497
Param Type = c
trn_rcms_caseid=13896000007951
Param Type = c
case_no=2023/510
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,trn_rcms_caseid,case_no,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,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,:trn_rcms_caseid,:case_no,: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 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007261
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 24/06/2024
pre_case_purpose = 1000497
trn_rcms_caseid = 14063000009232
court_code = 10519
case_no = 2023/542
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 24/09/2024
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=10500000007261
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:17
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=14063000009232
Param Type = c
court_code=10519
Param Type = c
case_no=2023/542
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=24/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=14
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007262
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 24/09/2024
new_case_purpose = 1000497
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/543
court_code = 10519
trn_rcms_caseid = 14070000007512
pre_case_purpose = 1000497
pre_hear_date = 24/06/2024
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=10500000007262
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:18
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/09/2024 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/543
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=14070000007512
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007263
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 24/06/2024
pre_case_purpose = 1000497
trn_rcms_caseid = 18401000006970
court_code = 10519
case_no = 2023/57
adjourn_remark =
adjourn_type = 0
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 02/07/2024
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=10500000007263
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:18
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=18401000006970
Param Type = c
court_code=10519
Param Type = c
case_no=2023/57
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=02/07/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_remark,adjourn_type,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,null,:adjourn_type,: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 = 8
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007264
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 24/06/2024
trn_rcms_caseid = 12212000009835
court_code = 10519
case_no = 2023/621
pre_case_purpose = 1000497
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 20/08/2024
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=10500000007264
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:18
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
trn_rcms_caseid=12212000009835
Param Type = c
court_code=10519
Param Type = c
case_no=2023/621
Param Type = n
pre_case_purpose=1000497
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=20/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,court_code,case_no,pre_case_purpose,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:court_code,:case_no,:pre_case_purpose,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 9
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 = 10500000007265
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_type = 0
new_case_purpose = 18466000000000
next_hear_date = 24/09/2024
pre_hear_date = 24/06/2024
trn_rcms_caseid = 12356000008249
pre_case_purpose = 1000497
court_code = 10519
adjourn_remark =
isadjourn = NO
case_no = 2023/627
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=10500000007265
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:18
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18466000000000
Param Type = c
next_hear_date=24/09/2024 00:00:00
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
trn_rcms_caseid=12356000008249
Param Type = n
pre_case_purpose=1000497
Param Type = c
court_code=10519
Param Type = c
isadjourn=NO
Param Type = c
case_no=2023/627
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_type,new_case_purpose,next_hear_date,pre_hear_date,trn_rcms_caseid,pre_case_purpose,court_code,adjourn_remark,isadjourn,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,: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'),:trn_rcms_caseid,:pre_case_purpose,:court_code,null,:isadjourn,:case_no,: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 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007266
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2023/628
court_code = 10519
pre_case_purpose = 1000497
adjourn_type = 0
isadjourn = NO
next_hear_date = 24/09/2024
adjourn_remark =
trn_rcms_caseid = 12384000007650
new_case_purpose = 18473000000000
pre_hear_date = 24/06/2024
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=10500000007266
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:18
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/628
Param Type = c
court_code=10519
Param Type = n
pre_case_purpose=1000497
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=24/09/2024 00:00:00
Param Type = c
trn_rcms_caseid=12384000007650
Param Type = c
new_case_purpose=18473000000000
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,court_code,pre_case_purpose,adjourn_type,isadjourn,next_hear_date,adjourn_remark,trn_rcms_caseid,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,:case_no,:court_code,:pre_case_purpose,:adjourn_type,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:trn_rcms_caseid,: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 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007267
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 24/06/2024
pre_case_purpose = 1000497
trn_rcms_caseid = 17349000008658
court_code = 10519
case_no = 2023/664
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 02/07/2024
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=10500000007267
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:18
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=17349000008658
Param Type = c
court_code=10519
Param Type = c
case_no=2023/664
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=02/07/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,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007268
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 08/07/2024
new_case_purpose = 1000497
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/161
court_code = 10519
trn_rcms_caseid = 15054000009408
pre_case_purpose = 1000497
pre_hear_date = 24/06/2024
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=10500000007268
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:18
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/07/2024 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/161
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=15054000009408
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,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 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007269
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 08/07/2024
isadjourn = NO
new_case_purpose = 1000497
pre_case_purpose = 1000497
pre_hear_date = 24/06/2024
case_no = 2024/162
court_code = 10519
trn_rcms_caseid = 15121000008170
adjourn_type = 0
adjourn_remark =
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=10500000007269
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:18
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/07/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
case_no=2024/162
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=15121000008170
Param Type = c
adjourn_type=0
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,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 = 5
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 = 10500000007270
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 24/06/2024
pre_case_purpose = 12555000000002
trn_rcms_caseid = 16041000000960
court_code = 10519
case_no = 2012/00227
isadjourn = NO
adjourn_type = 0
next_hear_date = 18/07/2024
adjourn_remark =
new_case_purpose = 12555000000002
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=10500000007270
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:18
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
trn_rcms_caseid=16041000000960
Param Type = c
court_code=10519
Param Type = c
case_no=2012/00227
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=18/07/2024 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_type,next_hear_date,adjourn_remark,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007271
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
court_code = 10519
isadjourn = NO
next_hear_date = 20/08/2024
adjourn_remark =
adjourn_type = 0
new_case_purpose = 12555000000002
pre_hear_date = 24/06/2024
trn_rcms_caseid = 12008000000530
case_no = 2015/00203
pre_case_purpose = 12555000000002
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=10500000007271
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:19
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10519
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=20/08/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=12555000000002
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
trn_rcms_caseid=12008000000530
Param Type = c
case_no=2015/00203
Param Type = n
pre_case_purpose=12555000000002
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,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 = 4
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007272
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
court_code = 10519
pre_case_purpose = 12555000000002
case_no = 2018/00048
trn_rcms_caseid = 12394000001490
pre_hear_date = 24/06/2024
new_case_purpose = 12555000000002
adjourn_type = 0
adjourn_remark =
next_hear_date = 24/09/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=10500000007272
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:19
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10519
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
case_no=2018/00048
Param Type = c
trn_rcms_caseid=12394000001490
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=24/09/2024 00:00:00
Param Type = c
isadjourn=NO
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,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 = 6
Adding new record to store data from Frame 2, Row 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007273
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
trn_rcms_caseid = 12335000005679
pre_hear_date = 24/06/2024
court_code = 10519
case_no = 2020/00106
pre_case_purpose = 12555000000002
isadjourn = NO
adjourn_type = 0
new_case_purpose = 12555000000002
next_hear_date = 06/08/2024
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=10500000007273
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:19
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=12335000005679
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
court_code=10519
Param Type = c
case_no=2020/00106
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=12555000000002
Param Type = c
next_hear_date=06/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 5
Adding new record to store data from Frame 2, Row 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007274
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 16977000006723
pre_case_purpose = 12555000000002
pre_hear_date = 24/06/2024
case_no = 2023/216
new_case_purpose = 12555000000002
adjourn_type = 0
court_code = 10519
next_hear_date = 18/07/2024
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=10500000007274
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:19
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=16977000006723
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
case_no=2023/216
Param Type = c
new_case_purpose=12555000000002
Param Type = c
adjourn_type=0
Param Type = c
court_code=10519
Param Type = c
next_hear_date=18/07/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=27
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,isadjourn,trn_rcms_caseid,pre_case_purpose,pre_hear_date,case_no,new_case_purpose,adjourn_type,court_code,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:isadjourn,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:new_case_purpose,:adjourn_type,:court_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 17
Adding new record to store data from Frame 2, Row 28 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007275
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 18022000008532
pre_hear_date = 24/06/2024
court_code = 10519
case_no = 2023/232
next_hear_date = 02/07/2024
isadjourn = NO
pre_case_purpose = 12555000000002
new_case_purpose = 12555000000002
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=10500000007275
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:19
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18022000008532
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
court_code=10519
Param Type = c
case_no=2023/232
Param Type = c
next_hear_date=02/07/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
new_case_purpose=12555000000002
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007276
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 0
adjourn_remark =
pre_hear_date = 24/06/2024
trn_rcms_caseid = 16020000001471
new_case_purpose = 18472000000000
pre_case_purpose = 18472000000000
next_hear_date = 18/07/2024
isadjourn = NO
case_no = 2011/00198
court_code = 10519
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=10500000007276
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:19
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
trn_rcms_caseid=16020000001471
Param Type = c
new_case_purpose=18472000000000
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
next_hear_date=18/07/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2011/00198
Param Type = c
court_code=10519
Param Type = n
trn_rcms_hearingrow=29
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,pre_hear_date,trn_rcms_caseid,new_case_purpose,pre_case_purpose,next_hear_date,isadjourn,case_no,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 30 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007277
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 =
isadjourn = NO
trn_rcms_caseid = 19945000005259
case_no = 2021/188
court_code = 10519
pre_hear_date = 24/06/2024
next_hear_date = 18/07/2024
new_case_purpose = 18472000000000
pre_case_purpose = 18472000000000
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=10500000007277
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:19
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=19945000005259
Param Type = c
case_no=2021/188
Param Type = c
court_code=10519
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
next_hear_date=18/07/2024 00:00:00
Param Type = c
new_case_purpose=18472000000000
Param Type = n
pre_case_purpose=18472000000000
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 31 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007278
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_type = 0
adjourn_remark =
case_no = 2023/140
court_code = 10519
pre_hear_date = 24/06/2024
trn_rcms_caseid = 18823000007646
next_hear_date = 18/07/2024
new_case_purpose = 18472000000000
pre_case_purpose = 18472000000000
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=10500000007278
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:19
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/140
Param Type = c
court_code=10519
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = c
trn_rcms_caseid=18823000007646
Param Type = c
next_hear_date=18/07/2024 00:00:00
Param Type = c
new_case_purpose=18472000000000
Param Type = n
pre_case_purpose=18472000000000
Param Type = n
trn_rcms_hearingrow=31
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,case_no,court_code,pre_hear_date,trn_rcms_caseid,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 32 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007279
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 02/07/2024
trn_rcms_caseid = 18123000007803
case_no = 2023/165
court_code = 10519
new_case_purpose = 11417000000000
pre_case_purpose = 11417000000000
pre_hear_date = 24/06/2024
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=10500000007279
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:19
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:19
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=02/07/2024 00:00:00
Param Type = c
trn_rcms_caseid=18123000007803
Param Type = c
case_no=2023/165
Param Type = c
court_code=10519
Param Type = c
new_case_purpose=11417000000000
Param Type = n
pre_case_purpose=11417000000000
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=32
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 4
Adding new record to store data from Frame 2, Row 33 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007280
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 26/06/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 17469000000895
court_code = 10519
case_no = 2015/00277
new_case_purpose = 12555000000002
pre_case_purpose = 18470000000000
pre_hear_date = 24/06/2024
TRN_RCMS_HEARINGrow = 33
Posting record
Param Type = n
trn_rcms_hearingid=10500000007280
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:20
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=26/06/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=17469000000895
Param Type = c
court_code=10519
Param Type = c
case_no=2015/00277
Param Type = c
new_case_purpose=12555000000002
Param Type = n
pre_case_purpose=18470000000000
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=33
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 8
Adding new record to store data from Frame 2, Row 34 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007281
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 02/07/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18470000000000
case_no = 2023/276
court_code = 10519
trn_rcms_caseid = 18498000008205
pre_case_purpose = 18470000000000
pre_hear_date = 24/06/2024
TRN_RCMS_HEARINGrow = 34
Posting record
Param Type = n
trn_rcms_hearingid=10500000007281
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:20
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=02/07/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18470000000000
Param Type = c
case_no=2023/276
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=18498000008205
Param Type = n
pre_case_purpose=18470000000000
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=34
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 35 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007282
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 20/08/2024
new_case_purpose = 18470000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2023/521
court_code = 10519
trn_rcms_caseid = 13918000007544
pre_case_purpose = 18470000000000
pre_hear_date = 24/06/2024
TRN_RCMS_HEARINGrow = 35
Posting record
Param Type = n
trn_rcms_hearingid=10500000007282
Param Type = n
trn_rcms_mhearingid=10500000007247
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:20
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=20/08/2024 00:00:00
Param Type = c
new_case_purpose=18470000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2023/521
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=13918000007544
Param Type = n
pre_case_purpose=18470000000000
Param Type = c
pre_hear_date=24/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=35
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 = 3928587616794
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11990000000706 idvalue 0
Mapped case_no Row = 1 value = 2015/00202 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 20/08/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 = 10519
trn_rcms_caseregid = 11990000000706
case_no = 2015/00202
prev_hearing_date = 24/06/2024
hearing_date = 20/08/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 = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007283
MapName trcmf1
SourceId 10500000007248
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 = 1000497
hearing_date = 20/08/2024
case_no = 2015/00202
trn_rcms_caseregid = 11990000000706
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007283
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007248
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:20
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=20/08/2024 00:00:00
Param Type = c
case_no=2015/00202
Param Type = c
trn_rcms_caseregid=11990000000706
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19381000001530 idvalue 0
Mapped case_no Row = 1 value = 2017/00303 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 24/09/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 = 10519
trn_rcms_caseregid = 19381000001530
case_no = 2017/00303
prev_hearing_date = 24/06/2024
hearing_date = 24/09/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 10500000007284
MapName trcmf1
SourceId 10500000007249
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 = 1000497
hearing_date = 24/09/2024
case_no = 2017/00303
trn_rcms_caseregid = 19381000001530
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007284
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007249
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:20
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=24/09/2024 00:00:00
Param Type = c
case_no=2017/00303
Param Type = c
trn_rcms_caseregid=19381000001530
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19484000001221 idvalue 0
Mapped case_no Row = 1 value = 2017/00304 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 24/09/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 = 10519
trn_rcms_caseregid = 19484000001221
case_no = 2017/00304
prev_hearing_date = 24/06/2024
hearing_date = 24/09/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007285
MapName trcmf1
SourceId 10500000007250
Select sysdate as sdt from dual
Time elapsed = 18
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 = 1000497
hearing_date = 24/09/2024
case_no = 2017/00304
trn_rcms_caseregid = 19484000001221
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007285
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007250
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:20
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=24/09/2024 00:00:00
Param Type = c
case_no=2017/00304
Param Type = c
trn_rcms_caseregid=19484000001221
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12393000001767 idvalue 0
Mapped case_no Row = 1 value = 2018/00047 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 24/09/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 = 10519
trn_rcms_caseregid = 12393000001767
case_no = 2018/00047
prev_hearing_date = 24/06/2024
hearing_date = 24/09/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007286
MapName trcmf1
SourceId 10500000007251
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 = 1000497
hearing_date = 24/09/2024
case_no = 2018/00047
trn_rcms_caseregid = 12393000001767
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007286
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007251
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=24/09/2024 00:00:00
Param Type = c
case_no=2018/00047
Param Type = c
trn_rcms_caseregid=12393000001767
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18324000006573 idvalue 0
Mapped case_no Row = 1 value = 2022/142 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 18/07/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 = 10519
trn_rcms_caseregid = 18324000006573
case_no = 2022/142
prev_hearing_date = 24/06/2024
hearing_date = 18/07/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 10500000007287
MapName trcmf1
SourceId 10500000007252
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 18/07/2024
case_no = 2022/142
trn_rcms_caseregid = 18324000006573
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007287
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007252
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=18/07/2024 00:00:00
Param Type = c
case_no=2022/142
Param Type = c
trn_rcms_caseregid=18324000006573
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11652000007655 idvalue 0
Mapped case_no Row = 1 value = 2023/123 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 02/07/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 = 10519
trn_rcms_caseregid = 11652000007655
case_no = 2023/123
prev_hearing_date = 24/06/2024
hearing_date = 02/07/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007288
MapName trcmf1
SourceId 10500000007253
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 02/07/2024
case_no = 2023/123
trn_rcms_caseregid = 11652000007655
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007288
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007253
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=02/07/2024 00:00:00
Param Type = c
case_no=2023/123
Param Type = c
trn_rcms_caseregid=11652000007655
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14854000007250 idvalue 0
Mapped case_no Row = 1 value = 2023/153 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 02/07/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 = 10519
trn_rcms_caseregid = 14854000007250
case_no = 2023/153
prev_hearing_date = 24/06/2024
hearing_date = 02/07/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 5
RecordId = 10500000007289
MapName trcmf1
SourceId 10500000007254
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 = 1000497
hearing_date = 02/07/2024
case_no = 2023/153
trn_rcms_caseregid = 14854000007250
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007289
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007254
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=02/07/2024 00:00:00
Param Type = c
case_no=2023/153
Param Type = c
trn_rcms_caseregid=14854000007250
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15005000007175 idvalue 0
Mapped case_no Row = 1 value = 2023/154 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 02/07/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 = 10519
trn_rcms_caseregid = 15005000007175
case_no = 2023/154
prev_hearing_date = 24/06/2024
hearing_date = 02/07/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007290
MapName trcmf1
SourceId 10500000007255
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 = 1000497
hearing_date = 02/07/2024
case_no = 2023/154
trn_rcms_caseregid = 15005000007175
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007290
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007255
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=02/07/2024 00:00:00
Param Type = c
case_no=2023/154
Param Type = c
trn_rcms_caseregid=15005000007175
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18008000007448 idvalue 0
Mapped case_no Row = 1 value = 2023/231 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 02/07/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 = 10519
trn_rcms_caseregid = 18008000007448
case_no = 2023/231
prev_hearing_date = 24/06/2024
hearing_date = 02/07/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007291
MapName trcmf1
SourceId 10500000007256
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 = 1000497
hearing_date = 02/07/2024
case_no = 2023/231
trn_rcms_caseregid = 18008000007448
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007291
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007256
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=02/07/2024 00:00:00
Param Type = c
case_no=2023/231
Param Type = c
trn_rcms_caseregid=18008000007448
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18072000007899 idvalue 0
Mapped case_no Row = 1 value = 2023/240 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 08/07/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 = 10519
trn_rcms_caseregid = 18072000007899
case_no = 2023/240
prev_hearing_date = 24/06/2024
hearing_date = 08/07/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007292
MapName trcmf1
SourceId 10500000007257
Select sysdate as sdt from dual
Time elapsed = 4
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 = 1000497
hearing_date = 08/07/2024
case_no = 2023/240
trn_rcms_caseregid = 18072000007899
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007292
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007257
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=08/07/2024 00:00:00
Param Type = c
case_no=2023/240
Param Type = c
trn_rcms_caseregid=18072000007899
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13883000007964 idvalue 0
Mapped case_no Row = 1 value = 2023/507 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 24/09/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 = 10519
trn_rcms_caseregid = 13883000007964
case_no = 2023/507
prev_hearing_date = 24/06/2024
hearing_date = 24/09/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007293
MapName trcmf1
SourceId 10500000007258
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 = 1000497
hearing_date = 24/09/2024
case_no = 2023/507
trn_rcms_caseregid = 13883000007964
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007293
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007258
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=24/09/2024 00:00:00
Param Type = c
case_no=2023/507
Param Type = c
trn_rcms_caseregid=13883000007964
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13889000008792 idvalue 0
Mapped case_no Row = 1 value = 2023/508 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 24/09/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 = 10519
trn_rcms_caseregid = 13889000008792
case_no = 2023/508
prev_hearing_date = 24/06/2024
hearing_date = 24/09/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007294
MapName trcmf1
SourceId 10500000007259
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 = 1000497
hearing_date = 24/09/2024
case_no = 2023/508
trn_rcms_caseregid = 13889000008792
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007294
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007259
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=24/09/2024 00:00:00
Param Type = c
case_no=2023/508
Param Type = c
trn_rcms_caseregid=13889000008792
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13896000007951 idvalue 0
Mapped case_no Row = 1 value = 2023/510 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 20/08/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 = 10519
trn_rcms_caseregid = 13896000007951
case_no = 2023/510
prev_hearing_date = 24/06/2024
hearing_date = 20/08/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007295
MapName trcmf1
SourceId 10500000007260
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 20/08/2024
case_no = 2023/510
trn_rcms_caseregid = 13896000007951
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007295
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007260
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=20/08/2024 00:00:00
Param Type = c
case_no=2023/510
Param Type = c
trn_rcms_caseregid=13896000007951
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14063000009232 idvalue 0
Mapped case_no Row = 1 value = 2023/542 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 24/09/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 = 10519
trn_rcms_caseregid = 14063000009232
case_no = 2023/542
prev_hearing_date = 24/06/2024
hearing_date = 24/09/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007296
MapName trcmf1
SourceId 10500000007261
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 = 1000497
hearing_date = 24/09/2024
case_no = 2023/542
trn_rcms_caseregid = 14063000009232
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007296
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007261
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=24/09/2024 00:00:00
Param Type = c
case_no=2023/542
Param Type = c
trn_rcms_caseregid=14063000009232
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14070000007512 idvalue 0
Mapped case_no Row = 1 value = 2023/543 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 24/09/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 = 10519
trn_rcms_caseregid = 14070000007512
case_no = 2023/543
prev_hearing_date = 24/06/2024
hearing_date = 24/09/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 10500000007297
MapName trcmf1
SourceId 10500000007262
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 24/09/2024
case_no = 2023/543
trn_rcms_caseregid = 14070000007512
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007297
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007262
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=24/09/2024 00:00:00
Param Type = c
case_no=2023/543
Param Type = c
trn_rcms_caseregid=14070000007512
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18401000006970 idvalue 0
Mapped case_no Row = 1 value = 2023/57 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 02/07/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 = 10519
trn_rcms_caseregid = 18401000006970
case_no = 2023/57
prev_hearing_date = 24/06/2024
hearing_date = 02/07/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 10500000007298
MapName trcmf1
SourceId 10500000007263
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 = 1000497
hearing_date = 02/07/2024
case_no = 2023/57
trn_rcms_caseregid = 18401000006970
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007298
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007263
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=02/07/2024 00:00:00
Param Type = c
case_no=2023/57
Param Type = c
trn_rcms_caseregid=18401000006970
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12212000009835 idvalue 0
Mapped case_no Row = 1 value = 2023/621 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 20/08/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 = 10519
trn_rcms_caseregid = 12212000009835
case_no = 2023/621
prev_hearing_date = 24/06/2024
hearing_date = 20/08/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
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 = 10500000007299
MapName trcmf1
SourceId 10500000007264
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 = 1000497
hearing_date = 20/08/2024
case_no = 2023/621
trn_rcms_caseregid = 12212000009835
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007299
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007264
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=20/08/2024 00:00:00
Param Type = c
case_no=2023/621
Param Type = c
trn_rcms_caseregid=12212000009835
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12356000008249 idvalue 0
Mapped case_no Row = 1 value = 2023/627 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/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 = 24/09/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 = 10519
trn_rcms_caseregid = 12356000008249
case_no = 2023/627
prev_hearing_date = 24/06/2024
hearing_date = 24/09/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
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 = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 10500000007300
MapName trcmf1
SourceId 10500000007265
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 = 1000497
hearing_date = 24/09/2024
case_no = 2023/627
trn_rcms_caseregid = 12356000008249
court_code = 10519
case_purpose = 18466000000000
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007300
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007265
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=24/09/2024 00:00:00
Param Type = c
case_no=2023/627
Param Type = c
trn_rcms_caseregid=12356000008249
Param Type = c
court_code=10519
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12384000007650 idvalue 0
Mapped case_no Row = 1 value = 2023/628 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 24/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = 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 = 10519
trn_rcms_caseregid = 12384000007650
case_no = 2023/628
prev_hearing_date = 24/06/2024
hearing_date = 24/09/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
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 = 4
RecordId = 10500000007301
MapName trcmf1
SourceId 10500000007266
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 = 1000497
hearing_date = 24/09/2024
case_no = 2023/628
trn_rcms_caseregid = 12384000007650
court_code = 10519
case_purpose = 18473000000000
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007301
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007266
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=24/09/2024 00:00:00
Param Type = c
case_no=2023/628
Param Type = c
trn_rcms_caseregid=12384000007650
Param Type = c
court_code=10519
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17349000008658 idvalue 0
Mapped case_no Row = 1 value = 2023/664 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 02/07/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 = 10519
trn_rcms_caseregid = 17349000008658
case_no = 2023/664
prev_hearing_date = 24/06/2024
hearing_date = 02/07/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 10500000007302
MapName trcmf1
SourceId 10500000007267
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 02/07/2024
case_no = 2023/664
trn_rcms_caseregid = 17349000008658
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007302
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007267
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=02/07/2024 00:00:00
Param Type = c
case_no=2023/664
Param Type = c
trn_rcms_caseregid=17349000008658
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15054000009408 idvalue 0
Mapped case_no Row = 1 value = 2024/161 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 08/07/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 = 10519
trn_rcms_caseregid = 15054000009408
case_no = 2024/161
prev_hearing_date = 24/06/2024
hearing_date = 08/07/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007303
MapName trcmf1
SourceId 10500000007268
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 08/07/2024
case_no = 2024/161
trn_rcms_caseregid = 15054000009408
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007303
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007268
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=08/07/2024 00:00:00
Param Type = c
case_no=2024/161
Param Type = c
trn_rcms_caseregid=15054000009408
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15121000008170 idvalue 0
Mapped case_no Row = 1 value = 2024/162 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 08/07/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 = 10519
trn_rcms_caseregid = 15121000008170
case_no = 2024/162
prev_hearing_date = 24/06/2024
hearing_date = 08/07/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007304
MapName trcmf1
SourceId 10500000007269
Select sysdate as sdt from dual
Time elapsed = 4
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 = 1000497
hearing_date = 08/07/2024
case_no = 2024/162
trn_rcms_caseregid = 15121000008170
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007304
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007269
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=08/07/2024 00:00:00
Param Type = c
case_no=2024/162
Param Type = c
trn_rcms_caseregid=15121000008170
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16041000000960 idvalue 0
Mapped case_no Row = 1 value = 2012/00227 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/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 = 18/07/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 = 10519
trn_rcms_caseregid = 16041000000960
case_no = 2012/00227
prev_hearing_date = 24/06/2024
hearing_date = 18/07/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 = 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 = 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 = 3
RecordId = 10500000007305
MapName trcmf1
SourceId 10500000007270
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 18/07/2024
case_no = 2012/00227
trn_rcms_caseregid = 16041000000960
court_code = 10519
case_purpose = 12555000000002
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007305
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007270
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=18/07/2024 00:00:00
Param Type = c
case_no=2012/00227
Param Type = c
trn_rcms_caseregid=16041000000960
Param Type = c
court_code=10519
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12008000000530 idvalue 0
Mapped case_no Row = 1 value = 2015/00203 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/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 = 20/08/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 = 10519
trn_rcms_caseregid = 12008000000530
case_no = 2015/00203
prev_hearing_date = 24/06/2024
hearing_date = 20/08/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
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 = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007306
MapName trcmf1
SourceId 10500000007271
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 20/08/2024
case_no = 2015/00203
trn_rcms_caseregid = 12008000000530
court_code = 10519
case_purpose = 12555000000002
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007306
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007271
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:24
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=20/08/2024 00:00:00
Param Type = c
case_no=2015/00203
Param Type = c
trn_rcms_caseregid=12008000000530
Param Type = c
court_code=10519
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=24/06/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 = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12394000001490 idvalue 0
Mapped case_no Row = 1 value = 2018/00048 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/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 = 24/09/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 = 10519
trn_rcms_caseregid = 12394000001490
case_no = 2018/00048
prev_hearing_date = 24/06/2024
hearing_date = 24/09/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
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 = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007307
MapName trcmf1
SourceId 10500000007272
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 24/09/2024
case_no = 2018/00048
trn_rcms_caseregid = 12394000001490
court_code = 10519
case_purpose = 12555000000002
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007307
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007272
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:24
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=24/09/2024 00:00:00
Param Type = c
case_no=2018/00048
Param Type = c
trn_rcms_caseregid=12394000001490
Param Type = c
court_code=10519
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=24/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 26
>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12335000005679 idvalue 0
Mapped case_no Row = 1 value = 2020/00106 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/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 = 06/08/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 = 10519
trn_rcms_caseregid = 12335000005679
case_no = 2020/00106
prev_hearing_date = 24/06/2024
hearing_date = 06/08/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007308
MapName trcmf1
SourceId 10500000007273
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 06/08/2024
case_no = 2020/00106
trn_rcms_caseregid = 12335000005679
court_code = 10519
case_purpose = 12555000000002
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007308
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007273
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:24
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=06/08/2024 00:00:00
Param Type = c
case_no=2020/00106
Param Type = c
trn_rcms_caseregid=12335000005679
Param Type = c
court_code=10519
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=24/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 27
>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16977000006723 idvalue 0
Mapped case_no Row = 1 value = 2023/216 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/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 = 18/07/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 = 10519
trn_rcms_caseregid = 16977000006723
case_no = 2023/216
prev_hearing_date = 24/06/2024
hearing_date = 18/07/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
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 = 10500000007309
MapName trcmf1
SourceId 10500000007274
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 = 18/07/2024
case_no = 2023/216
trn_rcms_caseregid = 16977000006723
court_code = 10519
case_purpose = 12555000000002
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007309
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007274
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:24
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=18/07/2024 00:00:00
Param Type = c
case_no=2023/216
Param Type = c
trn_rcms_caseregid=16977000006723
Param Type = c
court_code=10519
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=24/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 28
>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18022000008532 idvalue 0
Mapped case_no Row = 1 value = 2023/232 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/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 = 02/07/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 = 10519
trn_rcms_caseregid = 18022000008532
case_no = 2023/232
prev_hearing_date = 24/06/2024
hearing_date = 02/07/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
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 = 10500000007310
MapName trcmf1
SourceId 10500000007275
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 = 12555000000002
hearing_date = 02/07/2024
case_no = 2023/232
trn_rcms_caseregid = 18022000008532
court_code = 10519
case_purpose = 12555000000002
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007310
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007275
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:24
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=02/07/2024 00:00:00
Param Type = c
case_no=2023/232
Param Type = c
trn_rcms_caseregid=18022000008532
Param Type = c
court_code=10519
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=24/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 29
>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16020000001471 idvalue 0
Mapped case_no Row = 1 value = 2011/00198 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/07/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 = 10519
trn_rcms_caseregid = 16020000001471
case_no = 2011/00198
prev_hearing_date = 24/06/2024
hearing_date = 18/07/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 = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007311
MapName trcmf1
SourceId 10500000007276
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 = 18472000000000
hearing_date = 18/07/2024
case_no = 2011/00198
trn_rcms_caseregid = 16020000001471
court_code = 10519
case_purpose = 18472000000000
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007311
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007276
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:24
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=18/07/2024 00:00:00
Param Type = c
case_no=2011/00198
Param Type = c
trn_rcms_caseregid=16020000001471
Param Type = c
court_code=10519
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=24/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 30
>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19945000005259 idvalue 0
Mapped case_no Row = 1 value = 2021/188 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/07/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 = 10519
trn_rcms_caseregid = 19945000005259
case_no = 2021/188
prev_hearing_date = 24/06/2024
hearing_date = 18/07/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
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 = 10500000007312
MapName trcmf1
SourceId 10500000007277
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 = 18472000000000
hearing_date = 18/07/2024
case_no = 2021/188
trn_rcms_caseregid = 19945000005259
court_code = 10519
case_purpose = 18472000000000
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007312
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007277
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:25
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=18/07/2024 00:00:00
Param Type = c
case_no=2021/188
Param Type = c
trn_rcms_caseregid=19945000005259
Param Type = c
court_code=10519
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=24/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 31
>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18823000007646 idvalue 0
Mapped case_no Row = 1 value = 2023/140 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/07/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 = 10519
trn_rcms_caseregid = 18823000007646
case_no = 2023/140
prev_hearing_date = 24/06/2024
hearing_date = 18/07/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
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 = 10500000007313
MapName trcmf1
SourceId 10500000007278
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 18/07/2024
case_no = 2023/140
trn_rcms_caseregid = 18823000007646
court_code = 10519
case_purpose = 18472000000000
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007313
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007278
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:25
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=18/07/2024 00:00:00
Param Type = c
case_no=2023/140
Param Type = c
trn_rcms_caseregid=18823000007646
Param Type = c
court_code=10519
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=24/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 32
>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18123000007803 idvalue 0
Mapped case_no Row = 1 value = 2023/165 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/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 = 02/07/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 = 10519
trn_rcms_caseregid = 18123000007803
case_no = 2023/165
prev_hearing_date = 24/06/2024
hearing_date = 02/07/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 = 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 = 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 = 10500000007314
MapName trcmf1
SourceId 10500000007279
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 11417000000000
hearing_date = 02/07/2024
case_no = 2023/165
trn_rcms_caseregid = 18123000007803
court_code = 10519
case_purpose = 11417000000000
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007314
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007279
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:25
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=11417000000000
Param Type = c
hearing_date=02/07/2024 00:00:00
Param Type = c
case_no=2023/165
Param Type = c
trn_rcms_caseregid=18123000007803
Param Type = c
court_code=10519
Param Type = c
case_purpose=11417000000000
Param Type = c
prev_hearing_date=24/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 33
>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17469000000895 idvalue 0
Mapped case_no Row = 1 value = 2015/00277 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/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 = 26/06/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 = 10519
trn_rcms_caseregid = 17469000000895
case_no = 2015/00277
prev_hearing_date = 24/06/2024
hearing_date = 26/06/2024
prev_case_purposename = ??????? ?????? ????????
prev_case_purpose =
prev_case_purposename=??????? ?????? ????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ?????? ????????
Time elapsed = 5
prev_case_purpose after validation = 18470000000000
case_purpose = 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 = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 10500000007315
MapName trcmf1
SourceId 10500000007280
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 = 18470000000000
hearing_date = 26/06/2024
case_no = 2015/00277
trn_rcms_caseregid = 17469000000895
court_code = 10519
case_purpose = 12555000000002
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007315
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007280
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:25
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18470000000000
Param Type = c
hearing_date=26/06/2024 00:00:00
Param Type = c
case_no=2015/00277
Param Type = c
trn_rcms_caseregid=17469000000895
Param Type = c
court_code=10519
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=24/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 34
>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18498000008205 idvalue 0
Mapped case_no Row = 1 value = 2023/276 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ?????? ???????? idvalue 0
Mapped case_purpose Row = 1 value = 18470000000000 idvalue 0
Mapped hearing_date Row = 1 value = 02/07/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 = 10519
trn_rcms_caseregid = 18498000008205
case_no = 2023/276
prev_hearing_date = 24/06/2024
hearing_date = 02/07/2024
prev_case_purposename = ??????? ?????? ????????
prev_case_purpose =
prev_case_purpose after validation = 18470000000000
case_purpose = 18470000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 10500000007316
MapName trcmf1
SourceId 10500000007281
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18470000000000
hearing_date = 02/07/2024
case_no = 2023/276
trn_rcms_caseregid = 18498000008205
court_code = 10519
case_purpose = 18470000000000
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007316
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007281
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:25
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18470000000000
Param Type = c
hearing_date=02/07/2024 00:00:00
Param Type = c
case_no=2023/276
Param Type = c
trn_rcms_caseregid=18498000008205
Param Type = c
court_code=10519
Param Type = c
case_purpose=18470000000000
Param Type = c
prev_hearing_date=24/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 35
>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13918000007544 idvalue 0
Mapped case_no Row = 1 value = 2023/521 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ?????? ???????? idvalue 0
Mapped case_purpose Row = 1 value = 18470000000000 idvalue 0
Mapped hearing_date Row = 1 value = 20/08/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 = 10519
trn_rcms_caseregid = 13918000007544
case_no = 2023/521
prev_hearing_date = 24/06/2024
hearing_date = 20/08/2024
prev_case_purposename = ??????? ?????? ????????
prev_case_purpose =
prev_case_purpose after validation = 18470000000000
case_purpose = 18470000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 10500000007317
MapName trcmf1
SourceId 10500000007282
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 = 18470000000000
hearing_date = 20/08/2024
case_no = 2023/521
trn_rcms_caseregid = 13918000007544
court_code = 10519
case_purpose = 18470000000000
prev_hearing_date = 24/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=10500000007317
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10500000007282
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=26/06/2024 18:20:25
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=26/06/2024 18:20:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18470000000000
Param Type = c
hearing_date=20/08/2024 00:00:00
Param Type = c
case_no=2023/521
Param Type = c
trn_rcms_caseregid=13918000007544
Param Type = c
court_code=10519
Param Type = c
case_purpose=18470000000000
Param Type = c
prev_hearing_date=24/06/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 = 3928587622327
Time elapsed for MD Map = 3928587622328
Time elapsed for Save History = 3928587622330
Time elapsed for Save Attachment = 3928587622331
Time elapsed for After Save WF Exec = 3928587622335
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"10500000007247"}]}
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_Chauhtan
Param Type = c
calledon=26/06/2024 18:20:11
Param Type = c
callfinished=26/06/2024 18:20:22
Param Type = c
structname=trcmf
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=success
Param Type = n
timetaken=10676
Param Type = n
dbtimetaken=6248
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