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_Aushiya827ccb0eea8a706c4c34a16891f84e7b![]()
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_Aushiya
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Aushiya
Time elapsed = 5
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_Aushiya
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Aushiya
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = SDO
Result = SDO
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=SDO_Aushiya
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Aushiya
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 13816000000024
Result = 13816000000024
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_Aushiya
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 4065
Result = 4065
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_Aushiya
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_Aushiya
Result = SDO_Aushiya
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_Aushiya
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10477
Result = 10477
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_Aushiya
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Aushiya
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Jodhpur (Rural)
Result = Jodhpur (Rural)
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Aushiya
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Aushiya
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m8},{COURT_CATEGOTY})
Calling function sqlget
Result of sqlget = 10593000000007
Result = 10593000000007
Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
Calling function firesql
login_userid=4065
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=4065
Time elapsed = 9
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_Aushiya
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_Aushiya
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_Aushiya
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_reader
Result = court_reader
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=SDO_Aushiya
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_Aushiya
Time elapsed = 10
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 4
Result = 4
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 4
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 7
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_reader,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 4
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : trcmf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 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 = 10477
hearing_date = 14/08/2024
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 3
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 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 = 14969000008919
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
hearing_date = 14/08/2024
courtcode = 10477
Posting record
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:40
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=14/08/2024 00:00:00
Param Type = c
courtcode=10477
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)
Saving to table TRN_RCMS_HEARING
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008920
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
court_code = 10477
case_no = 2024/34
trn_rcms_caseid = 16347000008817
new_case_purpose = 1000507
isadjourn = NO
pre_case_purpose = 1000507
next_hear_date = 11/09/2024
adjourn_remark =
pre_hear_date = 14/08/2024
adjourn_type = 0
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=14969000008920
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:40
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10477
Param Type = c
case_no=2024/34
Param Type = c
trn_rcms_caseid=16347000008817
Param Type = c
new_case_purpose=1000507
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=1000507
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,case_no,trn_rcms_caseid,new_case_purpose,isadjourn,pre_case_purpose,next_hear_date,adjourn_remark,pre_hear_date,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,:trn_rcms_caseid,:new_case_purpose,:isadjourn,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),: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 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008921
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
court_code = 10477
pre_hear_date = 14/08/2024
adjourn_type = 0
new_case_purpose = 18472000000000
pre_case_purpose = 18472000000000
trn_rcms_caseid = 16160000003334
adjourn_remark =
case_no = 2016/00079
isadjourn = NO
next_hear_date = 10/09/2024
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=14969000008921
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:40
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10477
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18472000000000
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
trn_rcms_caseid=16160000003334
Param Type = c
case_no=2016/00079
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=10/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,pre_hear_date,adjourn_type,new_case_purpose,pre_case_purpose,trn_rcms_caseid,adjourn_remark,case_no,isadjourn,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,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,null,:case_no,:isadjourn,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 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14969000008922
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 18/09/2024
new_case_purpose = 18472000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/334
court_code = 10477
trn_rcms_caseid = 18654000007872
pre_case_purpose = 18472000000000
pre_hear_date = 14/08/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=14969000008922
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:40
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=18/09/2024 00:00:00
Param Type = c
new_case_purpose=18472000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/334
Param Type = c
court_code=10477
Param Type = c
trn_rcms_caseid=18654000007872
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008923
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 17/09/2024
new_case_purpose = 18472000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/207
court_code = 10477
trn_rcms_caseid = 16724000010349
pre_case_purpose = 18472000000000
pre_hear_date = 14/08/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=14969000008923
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:40
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=17/09/2024 00:00:00
Param Type = c
new_case_purpose=18472000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/207
Param Type = c
court_code=10477
Param Type = c
trn_rcms_caseid=16724000010349
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
pre_hear_date=14/08/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 = 14969000008924
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 17/09/2024
new_case_purpose = 18470000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2011/00232
court_code = 10477
trn_rcms_caseid = 14221000002799
pre_case_purpose = 18470000000000
pre_hear_date = 14/08/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=14969000008924
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:40
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=17/09/2024 00:00:00
Param Type = c
new_case_purpose=18470000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2011/00232
Param Type = c
court_code=10477
Param Type = c
trn_rcms_caseid=14221000002799
Param Type = n
pre_case_purpose=18470000000000
Param Type = c
pre_hear_date=14/08/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 = 14969000008925
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 14/08/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 17861000003493
court_code = 10477
case_no = 2017/00098
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 09/09/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=14969000008925
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:40
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=17861000003493
Param Type = c
court_code=10477
Param Type = c
case_no=2017/00098
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=09/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008926
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 27
Select sysdate as sdt from dual
Time elapsed = 6
pre_case_purpose = 18678000000000
court_code = 10477
pre_hear_date = 14/08/2024
case_no = 2017/00189
trn_rcms_caseid = 14900000002771
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=14969000008926
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:40
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=10477
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = c
case_no=2017/00189
Param Type = c
trn_rcms_caseid=14900000002771
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,court_code,pre_hear_date,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008927
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 02/10/2024
new_case_purpose = 1000497
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2020/00268
court_code = 10477
trn_rcms_caseid = 12699000005310
pre_case_purpose = 18678000000000
pre_hear_date = 14/08/2024
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=14969000008927
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:40
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=02/10/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=2020/00268
Param Type = c
court_code=10477
Param Type = c
trn_rcms_caseid=12699000005310
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 4
RecordId = 14969000008928
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
pre_case_purpose = 18678000000000
new_case_purpose = 1000497
next_hear_date = 28/10/2024
pre_hear_date = 14/08/2024
court_code = 10477
case_no = 2021/338
trn_rcms_caseid = 11601000005847
adjourn_remark =
adjourn_type = 0
isadjourn = NO
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=14969000008928
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:41
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=28/10/2024 00:00:00
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = c
court_code=10477
Param Type = c
case_no=2021/338
Param Type = c
trn_rcms_caseid=11601000005847
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
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_case_purpose,new_case_purpose,next_hear_date,pre_hear_date,court_code,case_no,trn_rcms_caseid,adjourn_remark,adjourn_type,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,null,:adjourn_type,:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 14969000008929
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trn_rcms_caseid = 15594000006451
new_case_purpose = 1000497
next_hear_date = 16/10/2024
pre_case_purpose = 18678000000000
court_code = 10477
case_no = 2022/320
pre_hear_date = 14/08/2024
adjourn_type = 0
isadjourn = NO
adjourn_remark =
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=14969000008929
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:41
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=15594000006451
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=16/10/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=10477
Param Type = c
case_no=2022/320
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,new_case_purpose,next_hear_date,pre_case_purpose,court_code,case_no,pre_hear_date,adjourn_type,isadjourn,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,:trn_rcms_caseid,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14969000008930
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 16/10/2024
isadjourn = NO
new_case_purpose = 12555000000002
pre_hear_date = 14/08/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 15646000008080
court_code = 10477
adjourn_remark =
case_no = 2022/321
adjourn_type = 0
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=14969000008930
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:41
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=16/10/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=12555000000002
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=15646000008080
Param Type = c
court_code=10477
Param Type = c
case_no=2022/321
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,new_case_purpose,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,adjourn_remark,case_no,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,null,:case_no,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14969000008931
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 14/08/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 11776000007467
court_code = 10477
case_no = 2023/35
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18472000000000
next_hear_date = 17/09/2024
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=14969000008931
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:41
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=11776000007467
Param Type = c
court_code=10477
Param Type = c
case_no=2023/35
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18472000000000
Param Type = c
next_hear_date=17/09/2024 00:00:00
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,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14969000008932
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 14/08/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 13532000008404
court_code = 10477
case_no = 2023/365
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 02/10/2024
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=14969000008932
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:41
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=13532000008404
Param Type = c
court_code=10477
Param Type = c
case_no=2023/365
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=02/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_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 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008933
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
court_code = 10477
case_no = 2023/366
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 02/10/2024
new_case_purpose = 12555000000002
pre_case_purpose = 18678000000000
trn_rcms_caseid = 13534000008659
pre_hear_date = 14/08/2024
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=14969000008933
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:41
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10477
Param Type = c
case_no=2023/366
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=02/10/2024 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=13534000008659
Param Type = c
pre_hear_date=14/08/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,court_code,case_no,isadjourn,adjourn_remark,adjourn_type,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:case_no,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14969000008934
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_case_purpose = 18678000000000
trn_rcms_caseid = 13803000008701
court_code = 10477
pre_hear_date = 14/08/2024
new_case_purpose = 1000497
adjourn_type = 0
adjourn_remark =
next_hear_date = 03/09/2024
isadjourn = NO
case_no = 2023/404
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=14969000008934
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:41
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=13803000008701
Param Type = c
court_code=10477
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=03/09/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2023/404
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_case_purpose,trn_rcms_caseid,court_code,pre_hear_date,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:trn_rcms_caseid,:court_code,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,:case_no,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008935
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 24
new_case_purpose = 12555000000002
next_hear_date = 03/09/2024
adjourn_type = 0
isadjourn = NO
adjourn_remark =
trn_rcms_caseid = 13858000007763
court_code = 10477
pre_hear_date = 14/08/2024
case_no = 2023/405
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=14969000008935
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:41
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=12555000000002
Param Type = c
next_hear_date=03/09/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=13858000007763
Param Type = c
court_code=10477
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = c
case_no=2023/405
Param Type = n
pre_case_purpose=18678000000000
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,new_case_purpose,next_hear_date,adjourn_type,isadjourn,adjourn_remark,trn_rcms_caseid,court_code,pre_hear_date,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,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:trn_rcms_caseid,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14969000008936
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 14/08/2024
pre_case_purpose = 18469000000000
trn_rcms_caseid = 359757
court_code = 10477
case_no = 2012/00102
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18469000000000
next_hear_date = 04/09/2024
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=14969000008936
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:41
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = n
pre_case_purpose=18469000000000
Param Type = c
trn_rcms_caseid=359757
Param Type = c
court_code=10477
Param Type = c
case_no=2012/00102
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18469000000000
Param Type = c
next_hear_date=04/09/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 = 3
RecordId = 14969000008937
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
trn_rcms_caseid = 15543000002493
adjourn_type = 0
court_code = 10477
case_no = 2012/00314
pre_hear_date = 14/08/2024
new_case_purpose = 18469000000000
next_hear_date = 02/09/2024
pre_case_purpose = 18469000000000
isadjourn = NO
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=14969000008937
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:41
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=15543000002493
Param Type = c
adjourn_type=0
Param Type = c
court_code=10477
Param Type = c
case_no=2012/00314
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = c
new_case_purpose=18469000000000
Param Type = c
next_hear_date=02/09/2024 00:00:00
Param Type = n
pre_case_purpose=18469000000000
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,adjourn_type,court_code,case_no,pre_hear_date,new_case_purpose,next_hear_date,pre_case_purpose,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,null,:trn_rcms_caseid,:adjourn_type,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,: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 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008938
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
trn_rcms_caseid = 13351000003571
pre_hear_date = 14/08/2024
court_code = 10477
case_no = 2011/00224
pre_case_purpose = 18466000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18466000000000
next_hear_date = 04/09/2024
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=14969000008938
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:42
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=13351000003571
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = c
court_code=10477
Param Type = c
case_no=2011/00224
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18466000000000
Param Type = c
next_hear_date=04/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14969000008939
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 359620
pre_hear_date = 14/08/2024
court_code = 10477
case_no = 2012/00077
next_hear_date = 11/09/2024
isadjourn = NO
pre_case_purpose = 18466000000000
new_case_purpose = 18466000000000
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=14969000008939
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:42
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=359620
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = c
court_code=10477
Param Type = c
case_no=2012/00077
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
new_case_purpose=18466000000000
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14969000008940
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 =
trn_rcms_caseid = 13066000002839
case_no = 2013/00335
new_case_purpose = 18466000000000
pre_hear_date = 14/08/2024
next_hear_date = 02/10/2024
isadjourn = NO
court_code = 10477
pre_case_purpose = 18466000000000
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=14969000008940
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:42
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13066000002839
Param Type = c
case_no=2013/00335
Param Type = c
new_case_purpose=18466000000000
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = c
next_hear_date=02/10/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
court_code=10477
Param Type = n
pre_case_purpose=18466000000000
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,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,new_case_purpose,pre_hear_date,next_hear_date,isadjourn,court_code,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,:trn_rcms_caseid,:case_no,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008941
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 = 12566000003373
case_no = 2014/00321
court_code = 10477
pre_hear_date = 14/08/2024
next_hear_date = 10/09/2024
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=14969000008941
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:42
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:42
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=12566000003373
Param Type = c
case_no=2014/00321
Param Type = c
court_code=10477
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = c
next_hear_date=10/09/2024 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
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,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14969000008942
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 16230000007768
case_no = 2014/00335
court_code = 10477
pre_hear_date = 14/08/2024
next_hear_date = 02/10/2024
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=14969000008942
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:42
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=16230000007768
Param Type = c
case_no=2014/00335
Param Type = c
court_code=10477
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = c
next_hear_date=02/10/2024 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
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,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14969000008943
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 11/09/2024
case_no = 2016/00119
court_code = 10477
trn_rcms_caseid = 13410000003478
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
pre_hear_date = 14/08/2024
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=14969000008943
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:42
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:42
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=11/09/2024 00:00:00
Param Type = c
case_no=2016/00119
Param Type = c
court_code=10477
Param Type = c
trn_rcms_caseid=13410000003478
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,case_no,court_code,trn_rcms_caseid,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'),:case_no,:court_code,:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14969000008944
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 17/09/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 15570000003836
case_no = 2018/00195
court_code = 10477
new_case_purpose = 18466000000000
pre_case_purpose = 18466000000000
pre_hear_date = 14/08/2024
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=14969000008944
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:42
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=17/09/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=15570000003836
Param Type = c
case_no=2018/00195
Param Type = c
court_code=10477
Param Type = c
new_case_purpose=18466000000000
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,: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 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14969000008945
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 02/09/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18466000000000
case_no = 2022/379
court_code = 10477
trn_rcms_caseid = 10698000006398
pre_case_purpose = 18466000000000
pre_hear_date = 14/08/2024
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=14969000008945
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:42
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=02/09/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18466000000000
Param Type = c
case_no=2022/379
Param Type = c
court_code=10477
Param Type = c
trn_rcms_caseid=10698000006398
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 5
Adding new record to store data from Frame 2, Row 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 14969000008946
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 02/09/2024
new_case_purpose = 18467000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2007/00033
court_code = 10477
trn_rcms_caseid = 360299
pre_case_purpose = 18467000000000
pre_hear_date = 14/08/2024
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=14969000008946
Param Type = n
trn_rcms_mhearingid=14969000008919
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:42
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=02/09/2024 00:00:00
Param Type = c
new_case_purpose=18467000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2007/00033
Param Type = c
court_code=10477
Param Type = c
trn_rcms_caseid=360299
Param Type = n
pre_case_purpose=18467000000000
Param Type = c
pre_hear_date=14/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=27
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3934413931845
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16347000008817 idvalue 0
Mapped case_no Row = 1 value = 2024/34 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000507 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 16347000008817
case_no = 2024/34
prev_hearing_date = 14/08/2024
hearing_date = 11/09/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 = 1000507
case_purpose = 1000507
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 = 14969000008947
MapName trcmf1
SourceId 14969000008920
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 = 1000507
hearing_date = 11/09/2024
case_no = 2024/34
trn_rcms_caseregid = 16347000008817
court_code = 10477
case_purpose = 1000507
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008947
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008920
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:42
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000507
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2024/34
Param Type = c
trn_rcms_caseregid=16347000008817
Param Type = c
court_code=10477
Param Type = c
case_purpose=1000507
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16160000003334 idvalue 0
Mapped case_no Row = 1 value = 2016/00079 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 10/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 16160000003334
case_no = 2016/00079
prev_hearing_date = 14/08/2024
hearing_date = 10/09/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 = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14969000008948
MapName trcmf1
SourceId 14969000008921
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 10/09/2024
case_no = 2016/00079
trn_rcms_caseregid = 16160000003334
court_code = 10477
case_purpose = 18472000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008948
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008921
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:43
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=10/09/2024 00:00:00
Param Type = c
case_no=2016/00079
Param Type = c
trn_rcms_caseregid=16160000003334
Param Type = c
court_code=10477
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18654000007872 idvalue 0
Mapped case_no Row = 1 value = 2023/334 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 18654000007872
case_no = 2023/334
prev_hearing_date = 14/08/2024
hearing_date = 18/09/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008949
MapName trcmf1
SourceId 14969000008922
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 = 18472000000000
hearing_date = 18/09/2024
case_no = 2023/334
trn_rcms_caseregid = 18654000007872
court_code = 10477
case_purpose = 18472000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008949
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008922
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:43
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=18/09/2024 00:00:00
Param Type = c
case_no=2023/334
Param Type = c
trn_rcms_caseregid=18654000007872
Param Type = c
court_code=10477
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16724000010349 idvalue 0
Mapped case_no Row = 1 value = 2024/207 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 17/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 16724000010349
case_no = 2024/207
prev_hearing_date = 14/08/2024
hearing_date = 17/09/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008950
MapName trcmf1
SourceId 14969000008923
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 = 18472000000000
hearing_date = 17/09/2024
case_no = 2024/207
trn_rcms_caseregid = 16724000010349
court_code = 10477
case_purpose = 18472000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008950
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008923
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:43
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=17/09/2024 00:00:00
Param Type = c
case_no=2024/207
Param Type = c
trn_rcms_caseregid=16724000010349
Param Type = c
court_code=10477
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14221000002799 idvalue 0
Mapped case_no Row = 1 value = 2011/00232 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ?????? ???????? idvalue 0
Mapped case_purpose Row = 1 value = 18470000000000 idvalue 0
Mapped hearing_date Row = 1 value = 17/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 14221000002799
case_no = 2011/00232
prev_hearing_date = 14/08/2024
hearing_date = 17/09/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 = 18470000000000
case_purpose = 18470000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14969000008951
MapName trcmf1
SourceId 14969000008924
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18470000000000
hearing_date = 17/09/2024
case_no = 2011/00232
trn_rcms_caseregid = 14221000002799
court_code = 10477
case_purpose = 18470000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008951
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008924
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:43
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18470000000000
Param Type = c
hearing_date=17/09/2024 00:00:00
Param Type = c
case_no=2011/00232
Param Type = c
trn_rcms_caseregid=14221000002799
Param Type = c
court_code=10477
Param Type = c
case_purpose=18470000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17861000003493 idvalue 0
Mapped case_no Row = 1 value = 2017/00098 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/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 = 09/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 17861000003493
case_no = 2017/00098
prev_hearing_date = 14/08/2024
hearing_date = 09/09/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 = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14969000008952
MapName trcmf1
SourceId 14969000008925
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 = 09/09/2024
case_no = 2017/00098
trn_rcms_caseregid = 17861000003493
court_code = 10477
case_purpose = 1000497
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008952
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008925
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:43
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/09/2024 00:00:00
Param Type = c
case_no=2017/00098
Param Type = c
trn_rcms_caseregid=17861000003493
Param Type = c
court_code=10477
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14900000002771 idvalue 0
Mapped case_no Row = 1 value = 2017/00189 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/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 = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 14900000002771
case_no = 2017/00189
prev_hearing_date = 14/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
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 = 24
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 = 14969000008953
MapName trcmf1
SourceId 14969000008926
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/09/2024
case_no = 2017/00189
trn_rcms_caseregid = 14900000002771
court_code = 10477
case_purpose = 1000497
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008953
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008926
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:43
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2017/00189
Param Type = c
trn_rcms_caseregid=14900000002771
Param Type = c
court_code=10477
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12699000005310 idvalue 0
Mapped case_no Row = 1 value = 2020/00268 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 02/10/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 = 10477
trn_rcms_caseregid = 12699000005310
case_no = 2020/00268
prev_hearing_date = 14/08/2024
hearing_date = 02/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
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 = 4
RecordId = 14969000008954
MapName trcmf1
SourceId 14969000008927
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 = 02/10/2024
case_no = 2020/00268
trn_rcms_caseregid = 12699000005310
court_code = 10477
case_purpose = 1000497
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008954
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008927
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:44
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=02/10/2024 00:00:00
Param Type = c
case_no=2020/00268
Param Type = c
trn_rcms_caseregid=12699000005310
Param Type = c
court_code=10477
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11601000005847 idvalue 0
Mapped case_no Row = 1 value = 2021/338 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 28/10/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 = 10477
trn_rcms_caseregid = 11601000005847
case_no = 2021/338
prev_hearing_date = 14/08/2024
hearing_date = 28/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
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 = 4
RecordId = 14969000008955
MapName trcmf1
SourceId 14969000008928
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 = 28/10/2024
case_no = 2021/338
trn_rcms_caseregid = 11601000005847
court_code = 10477
case_purpose = 1000497
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008955
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008928
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:44
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=28/10/2024 00:00:00
Param Type = c
case_no=2021/338
Param Type = c
trn_rcms_caseregid=11601000005847
Param Type = c
court_code=10477
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15594000006451 idvalue 0
Mapped case_no Row = 1 value = 2022/320 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/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 = 16/10/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 = 10477
trn_rcms_caseregid = 15594000006451
case_no = 2022/320
prev_hearing_date = 14/08/2024
hearing_date = 16/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008956
MapName trcmf1
SourceId 14969000008929
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 = 16/10/2024
case_no = 2022/320
trn_rcms_caseregid = 15594000006451
court_code = 10477
case_purpose = 1000497
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008956
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008929
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:44
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=16/10/2024 00:00:00
Param Type = c
case_no=2022/320
Param Type = c
trn_rcms_caseregid=15594000006451
Param Type = c
court_code=10477
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15646000008080 idvalue 0
Mapped case_no Row = 1 value = 2022/321 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 16/10/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 = 10477
trn_rcms_caseregid = 15646000008080
case_no = 2022/321
prev_hearing_date = 14/08/2024
hearing_date = 16/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008957
MapName trcmf1
SourceId 14969000008930
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 = 16/10/2024
case_no = 2022/321
trn_rcms_caseregid = 15646000008080
court_code = 10477
case_purpose = 12555000000002
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008957
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008930
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:44
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=16/10/2024 00:00:00
Param Type = c
case_no=2022/321
Param Type = c
trn_rcms_caseregid=15646000008080
Param Type = c
court_code=10477
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11776000007467 idvalue 0
Mapped case_no Row = 1 value = 2023/35 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 17/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 11776000007467
case_no = 2023/35
prev_hearing_date = 14/08/2024
hearing_date = 17/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 14969000008958
MapName trcmf1
SourceId 14969000008931
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 = 17/09/2024
case_no = 2023/35
trn_rcms_caseregid = 11776000007467
court_code = 10477
case_purpose = 18472000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008958
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008931
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:44
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=17/09/2024 00:00:00
Param Type = c
case_no=2023/35
Param Type = c
trn_rcms_caseregid=11776000007467
Param Type = c
court_code=10477
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13532000008404 idvalue 0
Mapped case_no Row = 1 value = 2023/365 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 02/10/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 = 10477
trn_rcms_caseregid = 13532000008404
case_no = 2023/365
prev_hearing_date = 14/08/2024
hearing_date = 02/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
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 = 4
RecordId = 14969000008959
MapName trcmf1
SourceId 14969000008932
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 = 02/10/2024
case_no = 2023/365
trn_rcms_caseregid = 13532000008404
court_code = 10477
case_purpose = 1000497
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008959
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008932
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:44
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=02/10/2024 00:00:00
Param Type = c
case_no=2023/365
Param Type = c
trn_rcms_caseregid=13532000008404
Param Type = c
court_code=10477
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13534000008659 idvalue 0
Mapped case_no Row = 1 value = 2023/366 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 02/10/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 = 10477
trn_rcms_caseregid = 13534000008659
case_no = 2023/366
prev_hearing_date = 14/08/2024
hearing_date = 02/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 14969000008960
MapName trcmf1
SourceId 14969000008933
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 = 02/10/2024
case_no = 2023/366
trn_rcms_caseregid = 13534000008659
court_code = 10477
case_purpose = 12555000000002
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008960
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008933
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:44
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=02/10/2024 00:00:00
Param Type = c
case_no=2023/366
Param Type = c
trn_rcms_caseregid=13534000008659
Param Type = c
court_code=10477
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13803000008701 idvalue 0
Mapped case_no Row = 1 value = 2023/404 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/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 = 03/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 13803000008701
case_no = 2023/404
prev_hearing_date = 14/08/2024
hearing_date = 03/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008961
MapName trcmf1
SourceId 14969000008934
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 = 03/09/2024
case_no = 2023/404
trn_rcms_caseregid = 13803000008701
court_code = 10477
case_purpose = 1000497
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008961
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008934
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:45
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:45
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=03/09/2024 00:00:00
Param Type = c
case_no=2023/404
Param Type = c
trn_rcms_caseregid=13803000008701
Param Type = c
court_code=10477
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13858000007763 idvalue 0
Mapped case_no Row = 1 value = 2023/405 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 03/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 13858000007763
case_no = 2023/405
prev_hearing_date = 14/08/2024
hearing_date = 03/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 14969000008962
MapName trcmf1
SourceId 14969000008935
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 = 03/09/2024
case_no = 2023/405
trn_rcms_caseregid = 13858000007763
court_code = 10477
case_purpose = 12555000000002
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008962
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008935
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:45
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:45
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=03/09/2024 00:00:00
Param Type = c
case_no=2023/405
Param Type = c
trn_rcms_caseregid=13858000007763
Param Type = c
court_code=10477
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 359757 idvalue 0
Mapped case_no Row = 1 value = 2012/00102 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18469000000000 idvalue 0
Mapped hearing_date Row = 1 value = 04/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 359757
case_no = 2012/00102
prev_hearing_date = 14/08/2024
hearing_date = 04/09/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 = 18469000000000
case_purpose = 18469000000000
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 = 14969000008963
MapName trcmf1
SourceId 14969000008936
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 = 18469000000000
hearing_date = 04/09/2024
case_no = 2012/00102
trn_rcms_caseregid = 359757
court_code = 10477
case_purpose = 18469000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008963
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008936
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:45
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:45
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=18469000000000
Param Type = c
hearing_date=04/09/2024 00:00:00
Param Type = c
case_no=2012/00102
Param Type = c
trn_rcms_caseregid=359757
Param Type = c
court_code=10477
Param Type = c
case_purpose=18469000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15543000002493 idvalue 0
Mapped case_no Row = 1 value = 2012/00314 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18469000000000 idvalue 0
Mapped hearing_date Row = 1 value = 02/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 15543000002493
case_no = 2012/00314
prev_hearing_date = 14/08/2024
hearing_date = 02/09/2024
prev_case_purposename = ??????? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 18469000000000
case_purpose = 18469000000000
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 = 14969000008964
MapName trcmf1
SourceId 14969000008937
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 = 18469000000000
hearing_date = 02/09/2024
case_no = 2012/00314
trn_rcms_caseregid = 15543000002493
court_code = 10477
case_purpose = 18469000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008964
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008937
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:45
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:45
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=18469000000000
Param Type = c
hearing_date=02/09/2024 00:00:00
Param Type = c
case_no=2012/00314
Param Type = c
trn_rcms_caseregid=15543000002493
Param Type = c
court_code=10477
Param Type = c
case_purpose=18469000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13351000003571 idvalue 0
Mapped case_no Row = 1 value = 2011/00224 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/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 = 04/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 13351000003571
case_no = 2011/00224
prev_hearing_date = 14/08/2024
hearing_date = 04/09/2024
prev_case_purposename = ??????? ????
prev_case_purpose =
prev_case_purposename=??????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ????
Time elapsed = 7
prev_case_purpose after validation = 18466000000000
case_purpose = 18466000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 14969000008965
MapName trcmf1
SourceId 14969000008938
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 = 18466000000000
hearing_date = 04/09/2024
case_no = 2011/00224
trn_rcms_caseregid = 13351000003571
court_code = 10477
case_purpose = 18466000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008965
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008938
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:45
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:45
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=04/09/2024 00:00:00
Param Type = c
case_no=2011/00224
Param Type = c
trn_rcms_caseregid=13351000003571
Param Type = c
court_code=10477
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 359620 idvalue 0
Mapped case_no Row = 1 value = 2012/00077 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/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 = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 359620
case_no = 2012/00077
prev_hearing_date = 14/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ??????? ????
prev_case_purpose =
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 = 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 = 14969000008966
MapName trcmf1
SourceId 14969000008939
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 11/09/2024
case_no = 2012/00077
trn_rcms_caseregid = 359620
court_code = 10477
case_purpose = 18466000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008966
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008939
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:45
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:45
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=11/09/2024 00:00:00
Param Type = c
case_no=2012/00077
Param Type = c
trn_rcms_caseregid=359620
Param Type = c
court_code=10477
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13066000002839 idvalue 0
Mapped case_no Row = 1 value = 2013/00335 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 02/10/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 = 10477
trn_rcms_caseregid = 13066000002839
case_no = 2013/00335
prev_hearing_date = 14/08/2024
hearing_date = 02/10/2024
prev_case_purposename = ??????? ????
prev_case_purpose =
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 = 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 = 14969000008967
MapName trcmf1
SourceId 14969000008940
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 = 18466000000000
hearing_date = 02/10/2024
case_no = 2013/00335
trn_rcms_caseregid = 13066000002839
court_code = 10477
case_purpose = 18466000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008967
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008940
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:45
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=02/10/2024 00:00:00
Param Type = c
case_no=2013/00335
Param Type = c
trn_rcms_caseregid=13066000002839
Param Type = c
court_code=10477
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12566000003373 idvalue 0
Mapped case_no Row = 1 value = 2014/00321 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/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 = 10/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 12566000003373
case_no = 2014/00321
prev_hearing_date = 14/08/2024
hearing_date = 10/09/2024
prev_case_purposename = ??????? ????
prev_case_purpose =
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 = 14969000008968
MapName trcmf1
SourceId 14969000008941
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 = 18466000000000
hearing_date = 10/09/2024
case_no = 2014/00321
trn_rcms_caseregid = 12566000003373
court_code = 10477
case_purpose = 18466000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008968
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008941
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:45
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=10/09/2024 00:00:00
Param Type = c
case_no=2014/00321
Param Type = c
trn_rcms_caseregid=12566000003373
Param Type = c
court_code=10477
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16230000007768 idvalue 0
Mapped case_no Row = 1 value = 2014/00335 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 02/10/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 = 10477
trn_rcms_caseregid = 16230000007768
case_no = 2014/00335
prev_hearing_date = 14/08/2024
hearing_date = 02/10/2024
prev_case_purposename = ??????? ????
prev_case_purpose =
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 14969000008969
MapName trcmf1
SourceId 14969000008942
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 = 18466000000000
hearing_date = 02/10/2024
case_no = 2014/00335
trn_rcms_caseregid = 16230000007768
court_code = 10477
case_purpose = 18466000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008969
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008942
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:46
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=02/10/2024 00:00:00
Param Type = c
case_no=2014/00335
Param Type = c
trn_rcms_caseregid=16230000007768
Param Type = c
court_code=10477
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13410000003478 idvalue 0
Mapped case_no Row = 1 value = 2016/00119 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/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 = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 13410000003478
case_no = 2016/00119
prev_hearing_date = 14/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ??????? ????
prev_case_purpose =
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 = 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 = 14969000008970
MapName trcmf1
SourceId 14969000008943
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 11/09/2024
case_no = 2016/00119
trn_rcms_caseregid = 13410000003478
court_code = 10477
case_purpose = 18466000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008970
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008943
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:46
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2016/00119
Param Type = c
trn_rcms_caseregid=13410000003478
Param Type = c
court_code=10477
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15570000003836 idvalue 0
Mapped case_no Row = 1 value = 2018/00195 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/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 = 17/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 15570000003836
case_no = 2018/00195
prev_hearing_date = 14/08/2024
hearing_date = 17/09/2024
prev_case_purposename = ??????? ????
prev_case_purpose =
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 = 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 = 14969000008971
MapName trcmf1
SourceId 14969000008944
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 = 17/09/2024
case_no = 2018/00195
trn_rcms_caseregid = 15570000003836
court_code = 10477
case_purpose = 18466000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008971
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008944
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:46
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=17/09/2024 00:00:00
Param Type = c
case_no=2018/00195
Param Type = c
trn_rcms_caseregid=15570000003836
Param Type = c
court_code=10477
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10698000006398 idvalue 0
Mapped case_no Row = 1 value = 2022/379 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 02/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 10698000006398
case_no = 2022/379
prev_hearing_date = 14/08/2024
hearing_date = 02/09/2024
prev_case_purposename = ??????? ????
prev_case_purpose =
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 = 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 = 14969000008972
MapName trcmf1
SourceId 14969000008945
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 = 02/09/2024
case_no = 2022/379
trn_rcms_caseregid = 10698000006398
court_code = 10477
case_purpose = 18466000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008972
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008945
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:46
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18466000000000
Param Type = c
hearing_date=02/09/2024 00:00:00
Param Type = c
case_no=2022/379
Param Type = c
trn_rcms_caseregid=10698000006398
Param Type = c
court_code=10477
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=14/08/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 = 10477 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 360299 idvalue 0
Mapped case_no Row = 1 value = 2007/00033 idvalue 0
Mapped prev_hearing_date Row = 1 value = 14/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18467000000000 idvalue 0
Mapped hearing_date Row = 1 value = 02/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10477
trn_rcms_caseregid = 360299
case_no = 2007/00033
prev_hearing_date = 14/08/2024
hearing_date = 02/09/2024
prev_case_purposename = ??????? ???? ????
prev_case_purpose =
prev_case_purposename=??????? ???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ???? ????
Time elapsed = 7
prev_case_purpose after validation = 18467000000000
case_purpose = 18467000000000
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 = 14969000008973
MapName trcmf1
SourceId 14969000008946
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 = 18467000000000
hearing_date = 02/09/2024
case_no = 2007/00033
trn_rcms_caseregid = 360299
court_code = 10477
case_purpose = 18467000000000
prev_hearing_date = 14/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=14969000008973
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=14969000008946
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Aushiya
Param Type = c
createdon=02/09/2024 04:45:46
Param Type = c
username=SDO_Aushiya
Param Type = c
modifiedon=02/09/2024 04:45:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18467000000000
Param Type = c
hearing_date=02/09/2024 00:00:00
Param Type = c
case_no=2007/00033
Param Type = c
trn_rcms_caseregid=360299
Param Type = c
court_code=10477
Param Type = c
case_purpose=18467000000000
Param Type = c
prev_hearing_date=14/08/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 = 3934413935707
Time elapsed for MD Map = 3934413935708
Time elapsed for Save History = 3934413935709
Time elapsed for Save Attachment = 3934413935710
Time elapsed for After Save WF Exec = 3934413935713
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"14969000008919"}]}
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_Aushiya
Param Type = c
calledon=02/09/2024 04:45:28
Param Type = c
callfinished=02/09/2024 04:45:35
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=7392
Param Type = n
dbtimetaken=4556
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