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_Choti_Saddi827ccb0eea8a706c4c34a16891f84e7b![]()
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_Choti_Saddi
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Choti_Saddi
Time elapsed = 7
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_Choti_Saddi
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Choti_Saddi
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = SDO
Result = SDO
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=SDO_Choti_Saddi
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Choti_Saddi
Time elapsed = 17
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 13816000000034
Result = 13816000000034
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_Choti_Saddi
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 4091
Result = 4091
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_Choti_Saddi
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_Choti_Saddi
Result = SDO_Choti_Saddi
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_Choti_Saddi
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10487
Result = 10487
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_Choti_Saddi
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Choti_Saddi
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Pratapgarh
Result = Pratapgarh
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Choti_Saddi
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Choti_Saddi
Time elapsed = 7
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=4091
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=4091
Time elapsed = 10
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_Choti_Saddi
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10823000000000
Result = 10823000000000
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=SDO_Choti_Saddi
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_Choti_Saddi
Time elapsed = 10
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_admin
Result = court_admin
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 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_Choti_Saddi
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_Choti_Saddi
Time elapsed = 11
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 5
Result = 5
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_admin') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 4
select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 5
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_admin,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 4
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : trcmf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 5
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 = 10487
hearing_date = 28/05/2024
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 4
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008797
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
hearing_date = 28/05/2024
courtcode = 10487
Posting record
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:43
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=28/05/2024 00:00:00
Param Type = c
courtcode=10487
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)
Saving to table TRN_RCMS_HEARING
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13561000008798
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 0
new_case_purpose = 1000492
trn_rcms_caseid = 11434000002252
court_code = 10487
pre_hear_date = 28/05/2024
pre_case_purpose = 1000492
isadjourn = NO
case_no = 2019/00196
adjourn_remark =
next_hear_date = 12/06/2024
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=13561000008798
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:43
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000492
Param Type = c
trn_rcms_caseid=11434000002252
Param Type = c
court_code=10487
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
case_no=2019/00196
Param Type = c
next_hear_date=12/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,new_case_purpose,trn_rcms_caseid,court_code,pre_hear_date,pre_case_purpose,isadjourn,case_no,adjourn_remark,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,:new_case_purpose,:trn_rcms_caseid,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:isadjourn,:case_no,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13561000008799
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_case_purpose = 18473000000000
court_code = 10487
case_no = 2016/00509
next_hear_date = 11/06/2024
new_case_purpose = 18473000000000
trn_rcms_caseid = 15796000002682
adjourn_type = 0
adjourn_remark =
pre_hear_date = 28/05/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=13561000008799
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:43
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
court_code=10487
Param Type = c
case_no=2016/00509
Param Type = c
next_hear_date=11/06/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=15796000002682
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,court_code,case_no,next_hear_date,new_case_purpose,trn_rcms_caseid,adjourn_type,adjourn_remark,pre_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_caseid,:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13561000008800
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 28/05/2024
pre_case_purpose = 1000497
trn_rcms_caseid = 11413000001702
court_code = 10487
case_no = 2018/00135
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 25/06/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=13561000008800
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:43
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=11413000001702
Param Type = c
court_code=10487
Param Type = c
case_no=2018/00135
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=25/06/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 = 5
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008801
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 25/06/2024
new_case_purpose = 1000497
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2018/00136
court_code = 10487
trn_rcms_caseid = 11432000002213
pre_case_purpose = 1000497
pre_hear_date = 28/05/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=13561000008801
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:43
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=25/06/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/00136
Param Type = c
court_code=10487
Param Type = c
trn_rcms_caseid=11432000002213
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=28/05/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 = 6
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 = 13561000008802
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 05/06/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2020/00094
court_code = 10487
trn_rcms_caseid = 14727000005887
pre_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=13561000008802
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:43
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/06/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2020/00094
Param Type = c
court_code=10487
Param Type = c
trn_rcms_caseid=14727000005887
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/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 = 5
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008803
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 11/06/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2020/00118
court_code = 10487
trn_rcms_caseid = 19658000005654
pre_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=13561000008803
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:43
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/06/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2020/00118
Param Type = c
court_code=10487
Param Type = c
trn_rcms_caseid=19658000005654
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/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 = 6
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 = 13561000008804
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 19/06/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2021/130
court_code = 10487
trn_rcms_caseid = 12219000005425
pre_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=13561000008804
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:44
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=19/06/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/130
Param Type = c
court_code=10487
Param Type = c
trn_rcms_caseid=12219000005425
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/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 = 5
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 = 4
RecordId = 13561000008805
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 19/06/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
adjourn_remark =
case_no = 2021/131
court_code = 10487
trn_rcms_caseid = 12239000005573
pre_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=13561000008805
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:44
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=19/06/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/131
Param Type = c
court_code=10487
Param Type = c
trn_rcms_caseid=12239000005573
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_type,adjourn_remark,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,:adjourn_type,null,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13561000008806
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 28/05/2024
trn_rcms_caseid = 11791000006179
court_code = 10487
case_no = 2021/137
pre_case_purpose = 18678000000000
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 18/06/2024
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=13561000008806
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:44
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
trn_rcms_caseid=11791000006179
Param Type = c
court_code=10487
Param Type = c
case_no=2021/137
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=18/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,court_code,case_no,pre_case_purpose,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:court_code,:case_no,:pre_case_purpose,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008807
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 11/06/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
court_code = 10487
case_no = 2021/1738
trn_rcms_caseid = 17994000005755
pre_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=13561000008807
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:44
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/06/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
court_code=10487
Param Type = c
case_no=2021/1738
Param Type = c
trn_rcms_caseid=17994000005755
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,court_code,case_no,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:court_code,:case_no,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 13561000008808
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_type = 0
court_code = 10487
isadjourn = NO
next_hear_date = 05/06/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
case_no = 2021/216
adjourn_remark =
pre_hear_date = 28/05/2024
trn_rcms_caseid = 14213000005779
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=13561000008808
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:44
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
court_code=10487
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=05/06/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2021/216
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
trn_rcms_caseid=14213000005779
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,court_code,isadjourn,next_hear_date,new_case_purpose,pre_case_purpose,case_no,adjourn_remark,pre_hear_date,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:case_no,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 13561000008809
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
isadjourn = NO
next_hear_date = 05/06/2024
new_case_purpose = 18678000000000
trn_rcms_caseid = 14243000005425
court_code = 10487
adjourn_type = 0
pre_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
adjourn_remark =
case_no = 2021/217
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=13561000008809
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:44
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=05/06/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=14243000005425
Param Type = c
court_code=10487
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
case_no=2021/217
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,next_hear_date,new_case_purpose,trn_rcms_caseid,court_code,adjourn_type,pre_case_purpose,pre_hear_date,adjourn_remark,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_caseid,:court_code,:adjourn_type,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:case_no,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13561000008810
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
new_case_purpose = 18678000000000
next_hear_date = 12/06/2024
adjourn_remark =
case_no = 2021/91
court_code = 10487
trn_rcms_caseid = 14249000006435
pre_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=13561000008810
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:44
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:44
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
new_case_purpose=18678000000000
Param Type = c
next_hear_date=12/06/2024 00:00:00
Param Type = c
case_no=2021/91
Param Type = c
court_code=10487
Param Type = c
trn_rcms_caseid=14249000006435
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,new_case_purpose,next_hear_date,adjourn_remark,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008811
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 28/05/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 15345000006283
court_code = 10487
case_no = 2022/13
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 05/06/2024
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=13561000008811
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:44
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=15345000006283
Param Type = c
court_code=10487
Param Type = c
case_no=2022/13
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=05/06/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 = 6
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13561000008812
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 28/05/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 15368000005674
court_code = 10487
case_no = 2022/14
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 05/06/2024
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=13561000008812
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:44
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=15368000005674
Param Type = c
court_code=10487
Param Type = c
case_no=2022/14
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=05/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,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008813
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 11/06/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2022/187
court_code = 10487
trn_rcms_caseid = 19064000006608
pre_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=13561000008813
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:45
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/06/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/187
Param Type = c
court_code=10487
Param Type = c
trn_rcms_caseid=19064000006608
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
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 = 13561000008814
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 28/05/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 19223000007169
court_code = 10487
case_no = 2022/191
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 10/06/2024
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=13561000008814
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:45
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=19223000007169
Param Type = c
court_code=10487
Param Type = c
case_no=2022/191
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=10/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13561000008815
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 9
pre_hear_date = 28/05/2024
pre_case_purpose = 18678000000000
court_code = 10487
case_no = 2022/210
trn_rcms_caseid = 18927000006983
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 04/06/2024
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=13561000008815
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:45
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=10487
Param Type = c
case_no=2022/210
Param Type = c
trn_rcms_caseid=18927000006983
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=04/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,court_code,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,:case_no,:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008816
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trn_rcms_caseid = 14101000003314
pre_hear_date = 28/05/2024
case_no = 2022/291
adjourn_remark =
court_code = 10487
pre_case_purpose = 18678000000000
next_hear_date = 11/06/2024
isadjourn = NO
new_case_purpose = 18678000000000
adjourn_type = 0
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=13561000008816
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:45
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=14101000003314
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
case_no=2022/291
Param Type = c
court_code=10487
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
next_hear_date=11/06/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,pre_hear_date,case_no,adjourn_remark,court_code,pre_case_purpose,next_hear_date,isadjourn,new_case_purpose,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,null,:court_code,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008817
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
court_code = 10487
case_no = 2022/292
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 14131000006182
pre_hear_date = 28/05/2024
adjourn_remark =
next_hear_date = 19/06/2024
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=13561000008817
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:45
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10487
Param Type = c
case_no=2022/292
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=14131000006182
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
next_hear_date=19/06/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,next_hear_date,isadjourn,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008818
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
new_case_purpose = 18678000000000
isadjourn = NO
next_hear_date = 25/06/2024
pre_case_purpose = 18678000000000
case_no = 2022/30
court_code = 10487
pre_hear_date = 28/05/2024
trn_rcms_caseid = 18309000006364
adjourn_remark =
adjourn_type = 0
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=13561000008818
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:45
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=25/06/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2022/30
Param Type = c
court_code=10487
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
trn_rcms_caseid=18309000006364
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,isadjourn,next_hear_date,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13561000008819
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2022/43
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 11215000006279
pre_hear_date = 28/05/2024
adjourn_remark =
court_code = 10487
adjourn_type = 0
next_hear_date = 19/06/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=13561000008819
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:45
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2022/43
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=11215000006279
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
court_code=10487
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=19/06/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008820
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 11/06/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2022/71
court_code = 10487
trn_rcms_caseid = 11120000007783
pre_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=13561000008820
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:45
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/06/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/71
Param Type = c
court_code=10487
Param Type = c
trn_rcms_caseid=11120000007783
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 3
RecordId = 13561000008821
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 05/06/2024
isadjourn = NO
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
case_no = 2022/72
court_code = 10487
trn_rcms_caseid = 11124000006023
adjourn_type = 0
adjourn_remark =
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=13561000008821
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:46
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/06/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
case_no=2022/72
Param Type = c
court_code=10487
Param Type = c
trn_rcms_caseid=11124000006023
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_type,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:adjourn_type,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008822
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 10
pre_hear_date = 28/05/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 14083000007539
court_code = 10487
case_no = 2023/10
isadjourn = NO
adjourn_type = 0
next_hear_date = 18/06/2024
adjourn_remark =
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=13561000008822
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:46
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=14083000007539
Param Type = c
court_code=10487
Param Type = c
case_no=2023/10
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=18/06/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_type,next_hear_date,adjourn_remark,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008823
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
court_code = 10487
isadjourn = NO
next_hear_date = 18/06/2024
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
trn_rcms_caseid = 15964000006780
case_no = 2023/159
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=13561000008823
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:46
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10487
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=18/06/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
trn_rcms_caseid=15964000006780
Param Type = c
case_no=2023/159
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,pre_hear_date,trn_rcms_caseid,case_no,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13561000008824
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
court_code = 10487
pre_case_purpose = 18678000000000
case_no = 2023/178
trn_rcms_caseid = 14349000008348
pre_hear_date = 28/05/2024
new_case_purpose = 18678000000000
adjourn_type = 0
adjourn_remark =
next_hear_date = 05/06/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=13561000008824
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:46
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10487
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2023/178
Param Type = c
trn_rcms_caseid=14349000008348
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=05/06/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=27
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,pre_case_purpose,case_no,trn_rcms_caseid,pre_hear_date,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:pre_case_purpose,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 215
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 = 13561000008825
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark =
trn_rcms_caseid = 18535000008424
pre_hear_date = 28/05/2024
court_code = 10487
case_no = 2023/182
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 11/06/2024
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=13561000008825
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:46
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=18535000008424
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
court_code=10487
Param Type = c
case_no=2023/182
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=11/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 4
RecordId = 13561000008826
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 18691000008068
pre_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
case_no = 2023/184
new_case_purpose = 18678000000000
adjourn_type = 0
court_code = 10487
next_hear_date = 05/06/2024
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=13561000008826
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:46
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=18691000008068
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
case_no=2023/184
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
court_code=10487
Param Type = c
next_hear_date=05/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=29
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,isadjourn,trn_rcms_caseid,pre_case_purpose,pre_hear_date,case_no,new_case_purpose,adjourn_type,court_code,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:isadjourn,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:new_case_purpose,:adjourn_type,:court_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 13561000008827
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 10384000008331
pre_hear_date = 28/05/2024
court_code = 10487
case_no = 2023/222
next_hear_date = 05/06/2024
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=13561000008827
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:46
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=10384000008331
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
court_code=10487
Param Type = c
case_no=2023/222
Param Type = c
next_hear_date=05/06/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 9
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 = 13561000008828
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark =
pre_hear_date = 28/05/2024
trn_rcms_caseid = 10555000008282
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
next_hear_date = 11/06/2024
isadjourn = NO
case_no = 2023/226
court_code = 10487
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=13561000008828
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:47
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
trn_rcms_caseid=10555000008282
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
next_hear_date=11/06/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2023/226
Param Type = c
court_code=10487
Param Type = n
trn_rcms_hearingrow=31
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,pre_hear_date,trn_rcms_caseid,new_case_purpose,pre_case_purpose,next_hear_date,isadjourn,case_no,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 32 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008829
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 18138000008185
case_no = 2023/243
court_code = 10487
pre_hear_date = 28/05/2024
next_hear_date = 12/06/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=13561000008829
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:47
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:47
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=18138000008185
Param Type = c
case_no=2023/243
Param Type = c
court_code=10487
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
next_hear_date=12/06/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=32
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 8
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 = 5
RecordId = 13561000008830
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
isadjourn = NO
adjourn_type = 0
adjourn_remark =
case_no = 2023/9
court_code = 10487
pre_hear_date = 28/05/2024
trn_rcms_caseid = 14069000006576
next_hear_date = 18/06/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 33
Posting record
Param Type = n
trn_rcms_hearingid=13561000008830
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:47
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:47
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/9
Param Type = c
court_code=10487
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = c
trn_rcms_caseid=14069000006576
Param Type = c
next_hear_date=18/06/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=33
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,case_no,court_code,pre_hear_date,trn_rcms_caseid,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 34 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008831
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 = 19/06/2024
trn_rcms_caseid = 11335000008778
case_no = 2024/10
court_code = 10487
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
TRN_RCMS_HEARINGrow = 34
Posting record
Param Type = n
trn_rcms_hearingid=13561000008831
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:47
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:47
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=19/06/2024 00:00:00
Param Type = c
trn_rcms_caseid=11335000008778
Param Type = c
case_no=2024/10
Param Type = c
court_code=10487
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=34
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 4
RecordId = 13561000008832
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 12/06/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 14905000007568
court_code = 10487
case_no = 2024/33
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
TRN_RCMS_HEARINGrow = 35
Posting record
Param Type = n
trn_rcms_hearingid=13561000008832
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:47
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=12/06/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=14905000007568
Param Type = c
court_code=10487
Param Type = c
case_no=2024/33
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=35
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,court_code,case_no,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:court_code,:case_no,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 36 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13561000008833
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 19/06/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18678000000000
case_no = 2024/36
court_code = 10487
trn_rcms_caseid = 18349000006771
pre_case_purpose = 18678000000000
pre_hear_date = 28/05/2024
TRN_RCMS_HEARINGrow = 36
Posting record
Param Type = n
trn_rcms_hearingid=13561000008833
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:47
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=19/06/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
case_no=2024/36
Param Type = c
court_code=10487
Param Type = c
trn_rcms_caseid=18349000006771
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=36
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 37 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008834
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 12/06/2024
new_case_purpose = 18466000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2017/00023
court_code = 10487
trn_rcms_caseid = 12468000001058
pre_case_purpose = 18466000000000
pre_hear_date = 28/05/2024
TRN_RCMS_HEARINGrow = 37
Posting record
Param Type = n
trn_rcms_hearingid=13561000008834
Param Type = n
trn_rcms_mhearingid=13561000008797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:47
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=12/06/2024 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2017/00023
Param Type = c
court_code=10487
Param Type = c
trn_rcms_caseid=12468000001058
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=28/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=37
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_remark,adjourn_type,isadjourn,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,null,:adjourn_type,:isadjourn,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
Time elapsed for insert/update = 3926657380495
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11434000002252 idvalue 0
Mapped case_no Row = 1 value = 2019/00196 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 12/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 = 10487
trn_rcms_caseregid = 11434000002252
case_no = 2019/00196
prev_hearing_date = 28/05/2024
hearing_date = 12/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 = 6
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 13561000008835
MapName trcmf1
SourceId 13561000008798
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 12/06/2024
case_no = 2019/00196
trn_rcms_caseregid = 11434000002252
court_code = 10487
case_purpose = 1000492
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008835
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008798
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:47
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=12/06/2024 00:00:00
Param Type = c
case_no=2019/00196
Param Type = c
trn_rcms_caseregid=11434000002252
Param Type = c
court_code=10487
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15796000002682 idvalue 0
Mapped case_no Row = 1 value = 2016/00509 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/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 = 11/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 = 10487
trn_rcms_caseregid = 15796000002682
case_no = 2016/00509
prev_hearing_date = 28/05/2024
hearing_date = 11/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 = 6
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 6
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13561000008836
MapName trcmf1
SourceId 13561000008799
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 11/06/2024
case_no = 2016/00509
trn_rcms_caseregid = 15796000002682
court_code = 10487
case_purpose = 18473000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008836
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008799
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:48
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=11/06/2024 00:00:00
Param Type = c
case_no=2016/00509
Param Type = c
trn_rcms_caseregid=15796000002682
Param Type = c
court_code=10487
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11413000001702 idvalue 0
Mapped case_no Row = 1 value = 2018/00135 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/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 = 25/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 = 10487
trn_rcms_caseregid = 11413000001702
case_no = 2018/00135
prev_hearing_date = 28/05/2024
hearing_date = 25/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 = 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 = 13561000008837
MapName trcmf1
SourceId 13561000008800
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 = 25/06/2024
case_no = 2018/00135
trn_rcms_caseregid = 11413000001702
court_code = 10487
case_purpose = 1000497
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008837
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008800
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:48
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=25/06/2024 00:00:00
Param Type = c
case_no=2018/00135
Param Type = c
trn_rcms_caseregid=11413000001702
Param Type = c
court_code=10487
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11432000002213 idvalue 0
Mapped case_no Row = 1 value = 2018/00136 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/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 = 25/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 = 10487
trn_rcms_caseregid = 11432000002213
case_no = 2018/00136
prev_hearing_date = 28/05/2024
hearing_date = 25/06/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 = 13561000008838
MapName trcmf1
SourceId 13561000008801
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 = 1000497
hearing_date = 25/06/2024
case_no = 2018/00136
trn_rcms_caseregid = 11432000002213
court_code = 10487
case_purpose = 1000497
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008838
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008801
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:48
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=25/06/2024 00:00:00
Param Type = c
case_no=2018/00136
Param Type = c
trn_rcms_caseregid=11432000002213
Param Type = c
court_code=10487
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14727000005887 idvalue 0
Mapped case_no Row = 1 value = 2020/00094 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10487
trn_rcms_caseregid = 14727000005887
case_no = 2020/00094
prev_hearing_date = 28/05/2024
hearing_date = 05/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 = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008839
MapName trcmf1
SourceId 13561000008802
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 = 18678000000000
hearing_date = 05/06/2024
case_no = 2020/00094
trn_rcms_caseregid = 14727000005887
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008839
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008802
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:48
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/06/2024 00:00:00
Param Type = c
case_no=2020/00094
Param Type = c
trn_rcms_caseregid=14727000005887
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19658000005654 idvalue 0
Mapped case_no Row = 1 value = 2020/00118 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/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 = 10487
trn_rcms_caseregid = 19658000005654
case_no = 2020/00118
prev_hearing_date = 28/05/2024
hearing_date = 11/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008840
MapName trcmf1
SourceId 13561000008803
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/06/2024
case_no = 2020/00118
trn_rcms_caseregid = 19658000005654
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008840
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008803
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:48
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/06/2024 00:00:00
Param Type = c
case_no=2020/00118
Param Type = c
trn_rcms_caseregid=19658000005654
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12219000005425 idvalue 0
Mapped case_no Row = 1 value = 2021/130 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/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 = 10487
trn_rcms_caseregid = 12219000005425
case_no = 2021/130
prev_hearing_date = 28/05/2024
hearing_date = 19/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008841
MapName trcmf1
SourceId 13561000008804
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/06/2024
case_no = 2021/130
trn_rcms_caseregid = 12219000005425
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008841
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008804
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:48
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/06/2024 00:00:00
Param Type = c
case_no=2021/130
Param Type = c
trn_rcms_caseregid=12219000005425
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12239000005573 idvalue 0
Mapped case_no Row = 1 value = 2021/131 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/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 = 10487
trn_rcms_caseregid = 12239000005573
case_no = 2021/131
prev_hearing_date = 28/05/2024
hearing_date = 19/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 216
RecordId = 13561000008842
MapName trcmf1
SourceId 13561000008805
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/06/2024
case_no = 2021/131
trn_rcms_caseregid = 12239000005573
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008842
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008805
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:49
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/06/2024 00:00:00
Param Type = c
case_no=2021/131
Param Type = c
trn_rcms_caseregid=12239000005573
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11791000006179 idvalue 0
Mapped case_no Row = 1 value = 2021/137 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/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 = 10487
trn_rcms_caseregid = 11791000006179
case_no = 2021/137
prev_hearing_date = 28/05/2024
hearing_date = 18/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008843
MapName trcmf1
SourceId 13561000008806
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 18/06/2024
case_no = 2021/137
trn_rcms_caseregid = 11791000006179
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008843
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008806
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:49
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=18/06/2024 00:00:00
Param Type = c
case_no=2021/137
Param Type = c
trn_rcms_caseregid=11791000006179
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17994000005755 idvalue 0
Mapped case_no Row = 1 value = 2021/1738 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/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 = 10487
trn_rcms_caseregid = 17994000005755
case_no = 2021/1738
prev_hearing_date = 28/05/2024
hearing_date = 11/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008844
MapName trcmf1
SourceId 13561000008807
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/06/2024
case_no = 2021/1738
trn_rcms_caseregid = 17994000005755
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008844
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008807
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:49
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/06/2024 00:00:00
Param Type = c
case_no=2021/1738
Param Type = c
trn_rcms_caseregid=17994000005755
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14213000005779 idvalue 0
Mapped case_no Row = 1 value = 2021/216 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10487
trn_rcms_caseregid = 14213000005779
case_no = 2021/216
prev_hearing_date = 28/05/2024
hearing_date = 05/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008845
MapName trcmf1
SourceId 13561000008808
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/06/2024
case_no = 2021/216
trn_rcms_caseregid = 14213000005779
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008845
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008808
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:49
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/06/2024 00:00:00
Param Type = c
case_no=2021/216
Param Type = c
trn_rcms_caseregid=14213000005779
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14243000005425 idvalue 0
Mapped case_no Row = 1 value = 2021/217 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10487
trn_rcms_caseregid = 14243000005425
case_no = 2021/217
prev_hearing_date = 28/05/2024
hearing_date = 05/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008846
MapName trcmf1
SourceId 13561000008809
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 = 18678000000000
hearing_date = 05/06/2024
case_no = 2021/217
trn_rcms_caseregid = 14243000005425
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008846
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008809
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:49
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/06/2024 00:00:00
Param Type = c
case_no=2021/217
Param Type = c
trn_rcms_caseregid=14243000005425
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14249000006435 idvalue 0
Mapped case_no Row = 1 value = 2021/91 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 12/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 = 10487
trn_rcms_caseregid = 14249000006435
case_no = 2021/91
prev_hearing_date = 28/05/2024
hearing_date = 12/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008847
MapName trcmf1
SourceId 13561000008810
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 = 18678000000000
hearing_date = 12/06/2024
case_no = 2021/91
trn_rcms_caseregid = 14249000006435
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008847
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008810
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:49
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=12/06/2024 00:00:00
Param Type = c
case_no=2021/91
Param Type = c
trn_rcms_caseregid=14249000006435
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15345000006283 idvalue 0
Mapped case_no Row = 1 value = 2022/13 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10487
trn_rcms_caseregid = 15345000006283
case_no = 2022/13
prev_hearing_date = 28/05/2024
hearing_date = 05/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008848
MapName trcmf1
SourceId 13561000008811
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/06/2024
case_no = 2022/13
trn_rcms_caseregid = 15345000006283
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008848
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008811
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:50
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/06/2024 00:00:00
Param Type = c
case_no=2022/13
Param Type = c
trn_rcms_caseregid=15345000006283
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15368000005674 idvalue 0
Mapped case_no Row = 1 value = 2022/14 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10487
trn_rcms_caseregid = 15368000005674
case_no = 2022/14
prev_hearing_date = 28/05/2024
hearing_date = 05/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008849
MapName trcmf1
SourceId 13561000008812
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/06/2024
case_no = 2022/14
trn_rcms_caseregid = 15368000005674
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008849
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008812
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:50
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/06/2024 00:00:00
Param Type = c
case_no=2022/14
Param Type = c
trn_rcms_caseregid=15368000005674
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19064000006608 idvalue 0
Mapped case_no Row = 1 value = 2022/187 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/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 = 10487
trn_rcms_caseregid = 19064000006608
case_no = 2022/187
prev_hearing_date = 28/05/2024
hearing_date = 11/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008850
MapName trcmf1
SourceId 13561000008813
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/06/2024
case_no = 2022/187
trn_rcms_caseregid = 19064000006608
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008850
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008813
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:50
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/06/2024 00:00:00
Param Type = c
case_no=2022/187
Param Type = c
trn_rcms_caseregid=19064000006608
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19223000007169 idvalue 0
Mapped case_no Row = 1 value = 2022/191 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 10/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 = 10487
trn_rcms_caseregid = 19223000007169
case_no = 2022/191
prev_hearing_date = 28/05/2024
hearing_date = 10/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008851
MapName trcmf1
SourceId 13561000008814
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 10/06/2024
case_no = 2022/191
trn_rcms_caseregid = 19223000007169
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008851
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008814
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:50
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=10/06/2024 00:00:00
Param Type = c
case_no=2022/191
Param Type = c
trn_rcms_caseregid=19223000007169
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18927000006983 idvalue 0
Mapped case_no Row = 1 value = 2022/210 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 04/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 = 10487
trn_rcms_caseregid = 18927000006983
case_no = 2022/210
prev_hearing_date = 28/05/2024
hearing_date = 04/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008852
MapName trcmf1
SourceId 13561000008815
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 = 18678000000000
hearing_date = 04/06/2024
case_no = 2022/210
trn_rcms_caseregid = 18927000006983
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008852
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008815
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:50
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=04/06/2024 00:00:00
Param Type = c
case_no=2022/210
Param Type = c
trn_rcms_caseregid=18927000006983
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14101000003314 idvalue 0
Mapped case_no Row = 1 value = 2022/291 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/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 = 10487
trn_rcms_caseregid = 14101000003314
case_no = 2022/291
prev_hearing_date = 28/05/2024
hearing_date = 11/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13561000008853
MapName trcmf1
SourceId 13561000008816
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 = 18678000000000
hearing_date = 11/06/2024
case_no = 2022/291
trn_rcms_caseregid = 14101000003314
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008853
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008816
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:50
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/06/2024 00:00:00
Param Type = c
case_no=2022/291
Param Type = c
trn_rcms_caseregid=14101000003314
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14131000006182 idvalue 0
Mapped case_no Row = 1 value = 2022/292 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/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 = 10487
trn_rcms_caseregid = 14131000006182
case_no = 2022/292
prev_hearing_date = 28/05/2024
hearing_date = 19/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008854
MapName trcmf1
SourceId 13561000008817
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 = 18678000000000
hearing_date = 19/06/2024
case_no = 2022/292
trn_rcms_caseregid = 14131000006182
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008854
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008817
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:50
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/06/2024 00:00:00
Param Type = c
case_no=2022/292
Param Type = c
trn_rcms_caseregid=14131000006182
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18309000006364 idvalue 0
Mapped case_no Row = 1 value = 2022/30 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 25/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 = 10487
trn_rcms_caseregid = 18309000006364
case_no = 2022/30
prev_hearing_date = 28/05/2024
hearing_date = 25/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008855
MapName trcmf1
SourceId 13561000008818
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 25/06/2024
case_no = 2022/30
trn_rcms_caseregid = 18309000006364
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008855
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008818
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:50
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=25/06/2024 00:00:00
Param Type = c
case_no=2022/30
Param Type = c
trn_rcms_caseregid=18309000006364
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11215000006279 idvalue 0
Mapped case_no Row = 1 value = 2022/43 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/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 = 10487
trn_rcms_caseregid = 11215000006279
case_no = 2022/43
prev_hearing_date = 28/05/2024
hearing_date = 19/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008856
MapName trcmf1
SourceId 13561000008819
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 = 18678000000000
hearing_date = 19/06/2024
case_no = 2022/43
trn_rcms_caseregid = 11215000006279
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008856
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008819
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:51
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/06/2024 00:00:00
Param Type = c
case_no=2022/43
Param Type = c
trn_rcms_caseregid=11215000006279
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11120000007783 idvalue 0
Mapped case_no Row = 1 value = 2022/71 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/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 = 10487
trn_rcms_caseregid = 11120000007783
case_no = 2022/71
prev_hearing_date = 28/05/2024
hearing_date = 11/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008857
MapName trcmf1
SourceId 13561000008820
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/06/2024
case_no = 2022/71
trn_rcms_caseregid = 11120000007783
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008857
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008820
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:51
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/06/2024 00:00:00
Param Type = c
case_no=2022/71
Param Type = c
trn_rcms_caseregid=11120000007783
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11124000006023 idvalue 0
Mapped case_no Row = 1 value = 2022/72 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10487
trn_rcms_caseregid = 11124000006023
case_no = 2022/72
prev_hearing_date = 28/05/2024
hearing_date = 05/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008858
MapName trcmf1
SourceId 13561000008821
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/06/2024
case_no = 2022/72
trn_rcms_caseregid = 11124000006023
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008858
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008821
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:51
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/06/2024 00:00:00
Param Type = c
case_no=2022/72
Param Type = c
trn_rcms_caseregid=11124000006023
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14083000007539 idvalue 0
Mapped case_no Row = 1 value = 2023/10 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/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 = 10487
trn_rcms_caseregid = 14083000007539
case_no = 2023/10
prev_hearing_date = 28/05/2024
hearing_date = 18/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13561000008859
MapName trcmf1
SourceId 13561000008822
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 18/06/2024
case_no = 2023/10
trn_rcms_caseregid = 14083000007539
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008859
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008822
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:51
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=18/06/2024 00:00:00
Param Type = c
case_no=2023/10
Param Type = c
trn_rcms_caseregid=14083000007539
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15964000006780 idvalue 0
Mapped case_no Row = 1 value = 2023/159 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/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 = 10487
trn_rcms_caseregid = 15964000006780
case_no = 2023/159
prev_hearing_date = 28/05/2024
hearing_date = 18/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13561000008860
MapName trcmf1
SourceId 13561000008823
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 18/06/2024
case_no = 2023/159
trn_rcms_caseregid = 15964000006780
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008860
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008823
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:51
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=18/06/2024 00:00:00
Param Type = c
case_no=2023/159
Param Type = c
trn_rcms_caseregid=15964000006780
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14349000008348 idvalue 0
Mapped case_no Row = 1 value = 2023/178 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10487
trn_rcms_caseregid = 14349000008348
case_no = 2023/178
prev_hearing_date = 28/05/2024
hearing_date = 05/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008861
MapName trcmf1
SourceId 13561000008824
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/06/2024
case_no = 2023/178
trn_rcms_caseregid = 14349000008348
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008861
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008824
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:51
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/06/2024 00:00:00
Param Type = c
case_no=2023/178
Param Type = c
trn_rcms_caseregid=14349000008348
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18535000008424 idvalue 0
Mapped case_no Row = 1 value = 2023/182 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/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 = 10487
trn_rcms_caseregid = 18535000008424
case_no = 2023/182
prev_hearing_date = 28/05/2024
hearing_date = 11/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008862
MapName trcmf1
SourceId 13561000008825
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/06/2024
case_no = 2023/182
trn_rcms_caseregid = 18535000008424
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008862
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008825
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:52
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/06/2024 00:00:00
Param Type = c
case_no=2023/182
Param Type = c
trn_rcms_caseregid=18535000008424
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18691000008068 idvalue 0
Mapped case_no Row = 1 value = 2023/184 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10487
trn_rcms_caseregid = 18691000008068
case_no = 2023/184
prev_hearing_date = 28/05/2024
hearing_date = 05/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008863
MapName trcmf1
SourceId 13561000008826
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/06/2024
case_no = 2023/184
trn_rcms_caseregid = 18691000008068
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008863
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008826
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:52
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/06/2024 00:00:00
Param Type = c
case_no=2023/184
Param Type = c
trn_rcms_caseregid=18691000008068
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10384000008331 idvalue 0
Mapped case_no Row = 1 value = 2023/222 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/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 = 10487
trn_rcms_caseregid = 10384000008331
case_no = 2023/222
prev_hearing_date = 28/05/2024
hearing_date = 05/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 219
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 = 13561000008864
MapName trcmf1
SourceId 13561000008827
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/06/2024
case_no = 2023/222
trn_rcms_caseregid = 10384000008331
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008864
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008827
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:52
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/06/2024 00:00:00
Param Type = c
case_no=2023/222
Param Type = c
trn_rcms_caseregid=10384000008331
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10555000008282 idvalue 0
Mapped case_no Row = 1 value = 2023/226 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/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 = 10487
trn_rcms_caseregid = 10555000008282
case_no = 2023/226
prev_hearing_date = 28/05/2024
hearing_date = 11/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008865
MapName trcmf1
SourceId 13561000008828
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 = 18678000000000
hearing_date = 11/06/2024
case_no = 2023/226
trn_rcms_caseregid = 10555000008282
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008865
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008828
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:52
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/06/2024 00:00:00
Param Type = c
case_no=2023/226
Param Type = c
trn_rcms_caseregid=10555000008282
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18138000008185 idvalue 0
Mapped case_no Row = 1 value = 2023/243 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 12/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 = 10487
trn_rcms_caseregid = 18138000008185
case_no = 2023/243
prev_hearing_date = 28/05/2024
hearing_date = 12/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008866
MapName trcmf1
SourceId 13561000008829
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 12/06/2024
case_no = 2023/243
trn_rcms_caseregid = 18138000008185
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008866
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008829
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:52
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=12/06/2024 00:00:00
Param Type = c
case_no=2023/243
Param Type = c
trn_rcms_caseregid=18138000008185
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14069000006576 idvalue 0
Mapped case_no Row = 1 value = 2023/9 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/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 = 10487
trn_rcms_caseregid = 14069000006576
case_no = 2023/9
prev_hearing_date = 28/05/2024
hearing_date = 18/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008867
MapName trcmf1
SourceId 13561000008830
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 18/06/2024
case_no = 2023/9
trn_rcms_caseregid = 14069000006576
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008867
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008830
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:53
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=18/06/2024 00:00:00
Param Type = c
case_no=2023/9
Param Type = c
trn_rcms_caseregid=14069000006576
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11335000008778 idvalue 0
Mapped case_no Row = 1 value = 2024/10 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/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 = 10487
trn_rcms_caseregid = 11335000008778
case_no = 2024/10
prev_hearing_date = 28/05/2024
hearing_date = 19/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008868
MapName trcmf1
SourceId 13561000008831
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/06/2024
case_no = 2024/10
trn_rcms_caseregid = 11335000008778
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008868
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008831
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:53
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/06/2024 00:00:00
Param Type = c
case_no=2024/10
Param Type = c
trn_rcms_caseregid=11335000008778
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/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 = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14905000007568 idvalue 0
Mapped case_no Row = 1 value = 2024/33 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 12/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 = 10487
trn_rcms_caseregid = 14905000007568
case_no = 2024/33
prev_hearing_date = 28/05/2024
hearing_date = 12/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13561000008869
MapName trcmf1
SourceId 13561000008832
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 12/06/2024
case_no = 2024/33
trn_rcms_caseregid = 14905000007568
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008869
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008832
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:53
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=12/06/2024 00:00:00
Param Type = c
case_no=2024/33
Param Type = c
trn_rcms_caseregid=14905000007568
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 36
>>Mapping
Mapped court_code Row = 1 value = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18349000006771 idvalue 0
Mapped case_no Row = 1 value = 2024/36 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/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 = 10487
trn_rcms_caseregid = 18349000006771
case_no = 2024/36
prev_hearing_date = 28/05/2024
hearing_date = 19/06/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008870
MapName trcmf1
SourceId 13561000008833
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/06/2024
case_no = 2024/36
trn_rcms_caseregid = 18349000006771
court_code = 10487
case_purpose = 18678000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008870
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008833
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:53
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/06/2024 00:00:00
Param Type = c
case_no=2024/36
Param Type = c
trn_rcms_caseregid=18349000006771
Param Type = c
court_code=10487
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 37
>>Mapping
Mapped court_code Row = 1 value = 10487 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12468000001058 idvalue 0
Mapped case_no Row = 1 value = 2017/00023 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/05/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 = 12/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 = 10487
trn_rcms_caseregid = 12468000001058
case_no = 2017/00023
prev_hearing_date = 28/05/2024
hearing_date = 12/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 = 8
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13561000008871
MapName trcmf1
SourceId 13561000008834
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 = 18466000000000
hearing_date = 12/06/2024
case_no = 2017/00023
trn_rcms_caseregid = 12468000001058
court_code = 10487
case_purpose = 18466000000000
prev_hearing_date = 28/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=13561000008871
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13561000008834
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Choti_Saddi
Param Type = c
createdon=04/06/2024 10:09:53
Param Type = c
username=SDO_Choti_Saddi
Param Type = c
modifiedon=04/06/2024 10:09:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=12/06/2024 00:00:00
Param Type = c
case_no=2017/00023
Param Type = c
trn_rcms_caseregid=12468000001058
Param Type = c
court_code=10487
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=28/05/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 = 3926657386461
Time elapsed for MD Map = 3926657386463
Time elapsed for Save History = 3926657386465
Time elapsed for Save Attachment = 3926657386468
Time elapsed for After Save WF Exec = 3926657386474
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"13561000008797"}]}
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_Choti_Saddi
Param Type = c
calledon=04/06/2024 10:09:35
Param Type = c
callfinished=04/06/2024 10:09:46
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=11283
Param Type = n
dbtimetaken=6923
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