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
gcmssdm_chaumu_PRO827ccb0eea8a706c4c34a16891f84e7b![]()
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=sdm_chaumu_PRO
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=sdm_chaumu_PRO
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ????? ???????,?????,????? (???????)
Result = ????? ???????,?????,????? (???????)
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=sdm_chaumu_PRO
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=sdm_chaumu_PRO
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = SDO
Result = SDO
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=sdm_chaumu_PRO
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=sdm_chaumu_PRO
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 12118000000011
Result = 12118000000011
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=sdm_chaumu_PRO
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1062660008411
Result = 1062660008411
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=sdm_chaumu_PRO
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = sdm_chaumu_PRO
Result = sdm_chaumu_PRO
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=sdm_chaumu_PRO
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10024
Result = 10024
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=sdm_chaumu_PRO
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=sdm_chaumu_PRO
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Jaipur (Rural)
Result = Jaipur (Rural)
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=sdm_chaumu_PRO
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=sdm_chaumu_PRO
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=1062660008411
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1062660008411
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=sdm_chaumu_PRO
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=sdm_chaumu_PRO
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=sdm_chaumu_PRO
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_admin
Result = court_admin
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=sdm_chaumu_PRO
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=sdm_chaumu_PRO
Time elapsed = 10
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 20
Result = 20
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_admin') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 4
select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 6
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_admin,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 4
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : trcmf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 5
Step4
tstructs\stm size:2075
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Evaluating date()
Result =
Evaluating iif((next_hear_date>Validating trcmf
>>Frame No 1
courtcode = 10024
hearing_date = 12/12/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 = 4
RecordId = 12209000010468
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
hearing_date = 12/12/2024
courtcode = 10024
Posting record
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:34
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=12/12/2024 00:00:00
Param Type = c
courtcode=10024
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 = 6
RecordId = 12209000010469
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 31/01/2025
new_case_purpose = 18473000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2015/00235
court_code = 10024
trn_rcms_caseid = 19647000000083
pre_case_purpose = 18473000000000
pre_hear_date = 12/12/2024
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=12209000010469
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:34
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=31/01/2025 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2015/00235
Param Type = c
court_code=10024
Param Type = c
trn_rcms_caseid=19647000000083
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010470
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 31/01/2025
new_case_purpose = 18473000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2015/00328
court_code = 10024
trn_rcms_caseid = 17907000000421
pre_case_purpose = 18473000000000
pre_hear_date = 12/12/2024
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=12209000010470
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:34
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=31/01/2025 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2015/00328
Param Type = c
court_code=10024
Param Type = c
trn_rcms_caseid=17907000000421
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=12/12/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,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 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010471
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 12/12/2024
pre_case_purpose = 18473000000000
trn_rcms_caseid = 12730000001199
court_code = 10024
case_no = 2016/00442
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 31/01/2025
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=12209000010471
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:34
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=12730000001199
Param Type = c
court_code=10024
Param Type = c
case_no=2016/00442
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=31/01/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010472
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 12/12/2024
pre_case_purpose = 1000525
trn_rcms_caseid = 17858000000669
court_code = 10024
case_no = 2014/00492
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000525
next_hear_date = 31/01/2025
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=12209000010472
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:34
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = n
pre_case_purpose=1000525
Param Type = c
trn_rcms_caseid=17858000000669
Param Type = c
court_code=10024
Param Type = c
case_no=2014/00492
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=31/01/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 6
RecordId = 12209000010473
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 31/01/2025
new_case_purpose = 12555000000002
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2016/00443
court_code = 10024
trn_rcms_caseid = 12764000000664
pre_case_purpose = 12555000000002
pre_hear_date = 12/12/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=12209000010473
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:34
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=31/01/2025 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2016/00443
Param Type = c
court_code=10024
Param Type = c
trn_rcms_caseid=12764000000664
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12209000010474
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 15/01/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2015/00412
court_code = 10024
trn_rcms_caseid = 19538000000762
pre_case_purpose = 18678000000000
pre_hear_date = 12/12/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=12209000010474
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:34
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=15/01/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2015/00412
Param Type = c
court_code=10024
Param Type = c
trn_rcms_caseid=19538000000762
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12209000010475
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = NO
next_hear_date = 15/01/2025
adjourn_type = 0
adjourn_remark =
pre_hear_date = 12/12/2024
case_no = 2015/00413
court_code = 10024
trn_rcms_caseid = 19553000001074
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=12209000010475
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:35
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=15/01/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = c
case_no=2015/00413
Param Type = c
court_code=10024
Param Type = c
trn_rcms_caseid=19553000001074
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
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,isadjourn,next_hear_date,adjourn_type,adjourn_remark,pre_hear_date,case_no,court_code,trn_rcms_caseid,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12209000010476
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
case_no = 2018/00098
court_code = 10024
isadjourn = NO
next_hear_date = 31/01/2025
adjourn_remark =
adjourn_type = 0
pre_hear_date = 12/12/2024
trn_rcms_caseid = 18534000002212
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=12209000010476
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:35
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2018/00098
Param Type = c
court_code=10024
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=31/01/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = c
trn_rcms_caseid=18534000002212
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
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,case_no,court_code,isadjourn,next_hear_date,adjourn_remark,adjourn_type,pre_hear_date,trn_rcms_caseid,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 6
RecordId = 12209000010477
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 12/12/2024
trn_rcms_caseid = 11911000006101
pre_case_purpose = 18678000000000
next_hear_date = 03/02/2025
new_case_purpose = 18678000000000
adjourn_type = 0
adjourn_remark =
isadjourn = NO
case_no = 2021/184
court_code = 10024
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=12209000010477
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:35
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = c
trn_rcms_caseid=11911000006101
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
next_hear_date=03/02/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2021/184
Param Type = c
court_code=10024
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,pre_case_purpose,next_hear_date,new_case_purpose,adjourn_type,adjourn_remark,isadjourn,case_no,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,:isadjourn,:case_no,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010478
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 12/12/2024
trn_rcms_caseid = 11939000005626
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
next_hear_date = 03/02/2025
adjourn_remark =
isadjourn = NO
court_code = 10024
adjourn_type = 0
case_no = 2021/185
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=12209000010478
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:35
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = c
trn_rcms_caseid=11939000005626
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=03/02/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
court_code=10024
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/185
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,pre_case_purpose,new_case_purpose,next_hear_date,adjourn_remark,isadjourn,court_code,adjourn_type,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,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:isadjourn,:court_code,:adjourn_type,:case_no,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010479
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2021/52
isadjourn = NO
next_hear_date = 03/02/2025
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18678000000000
pre_hear_date = 12/12/2024
trn_rcms_caseid = 17682000005372
court_code = 10024
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=12209000010479
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:35
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2021/52
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=03/02/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = c
trn_rcms_caseid=17682000005372
Param Type = c
court_code=10024
Param Type = n
pre_case_purpose=18678000000000
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,case_no,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,pre_hear_date,trn_rcms_caseid,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,:case_no,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 19
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12209000010480
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 12/12/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 11034000006790
court_code = 10024
case_no = 2022/201
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 05/02/2025
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=12209000010480
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:35
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=11034000006790
Param Type = c
court_code=10024
Param Type = c
case_no=2022/201
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=05/02/2025 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 = 6
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 = 7
RecordId = 12209000010481
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 12/12/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 11075000006609
court_code = 10024
case_no = 2022/202
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 05/02/2025
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=12209000010481
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:35
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=11075000006609
Param Type = c
court_code=10024
Param Type = c
case_no=2022/202
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=05/02/2025 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 = 12209000010482
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 05/02/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2022/203
court_code = 10024
trn_rcms_caseid = 11169000006686
pre_case_purpose = 18678000000000
pre_hear_date = 12/12/2024
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=12209000010482
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:35
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/02/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/203
Param Type = c
court_code=10024
Param Type = c
trn_rcms_caseid=11169000006686
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/12/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,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 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 12209000010483
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
new_case_purpose = 18678000000000
adjourn_type = 0
next_hear_date = 05/02/2025
isadjourn = NO
case_no = 2022/205
court_code = 10024
trn_rcms_caseid = 12232000006993
pre_case_purpose = 18678000000000
pre_hear_date = 12/12/2024
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=12209000010483
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:35
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=05/02/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2022/205
Param Type = c
court_code=10024
Param Type = c
trn_rcms_caseid=12232000006993
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,new_case_purpose,adjourn_type,next_hear_date,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,null,:new_case_purpose,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),: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)
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 = 5
RecordId = 12209000010484
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 12/12/2024
trn_rcms_caseid = 13339000008463
isadjourn = NO
pre_case_purpose = 18678000000000
adjourn_type = 0
court_code = 10024
case_no = 2022/515
adjourn_remark =
new_case_purpose = 18678000000000
next_hear_date = 05/02/2025
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=12209000010484
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:35
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = c
trn_rcms_caseid=13339000008463
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
court_code=10024
Param Type = c
case_no=2022/515
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=05/02/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,isadjourn,pre_case_purpose,adjourn_type,court_code,case_no,adjourn_remark,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:isadjourn,:pre_case_purpose,:adjourn_type,:court_code,:case_no,null,: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 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010485
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_type = 0
next_hear_date = 05/02/2025
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
pre_hear_date = 12/12/2024
case_no = 2022/523
adjourn_remark =
trn_rcms_caseid = 15983000007498
court_code = 10024
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=12209000010485
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:36
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:36
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=05/02/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = c
case_no=2022/523
Param Type = c
trn_rcms_caseid=15983000007498
Param Type = c
court_code=10024
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,isadjourn,adjourn_type,next_hear_date,pre_case_purpose,new_case_purpose,pre_hear_date,case_no,adjourn_remark,trn_rcms_caseid,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,null,:trn_rcms_caseid,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010486
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 12/12/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 19525000008453
court_code = 10024
case_no = 2023/370
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 08/01/2025
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=12209000010486
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:36
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=19525000008453
Param Type = c
court_code=10024
Param Type = c
case_no=2023/370
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/01/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010487
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 08/01/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/423
court_code = 10024
trn_rcms_caseid = 14581000008386
pre_case_purpose = 18678000000000
pre_hear_date = 12/12/2024
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=12209000010487
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:36
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/01/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/423
Param Type = c
court_code=10024
Param Type = c
trn_rcms_caseid=14581000008386
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/12/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,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 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010488
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2023/424
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 14584000008864
pre_hear_date = 12/12/2024
adjourn_remark =
court_code = 10024
adjourn_type = 0
next_hear_date = 08/01/2025
isadjourn = NO
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=12209000010488
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:36
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/424
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=14584000008864
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = c
court_code=10024
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=08/01/2025 00:00:00
Param Type = c
isadjourn=NO
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,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010489
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 12/12/2024
adjourn_remark =
trn_rcms_caseid = 15643000007777
court_code = 10024
case_no = 2024/329
next_hear_date = 08/01/2025
isadjourn = NO
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
adjourn_type = 0
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=12209000010489
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:36
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = c
trn_rcms_caseid=15643000007777
Param Type = c
court_code=10024
Param Type = c
case_no=2024/329
Param Type = c
next_hear_date=08/01/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,adjourn_remark,trn_rcms_caseid,court_code,case_no,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:trn_rcms_caseid,:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 8
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12209000010490
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
trn_rcms_caseid = 15856000008216
pre_hear_date = 12/12/2024
court_code = 10024
case_no = 2024/330
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 08/01/2025
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=12209000010490
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:36
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=15856000008216
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = c
court_code=10024
Param Type = c
case_no=2024/330
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/01/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12209000010491
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
trn_rcms_caseid = 13372000008350
pre_hear_date = 12/12/2024
court_code = 10024
case_no = 2024/384
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 08/01/2025
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=12209000010491
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:36
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=13372000008350
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = c
court_code=10024
Param Type = c
case_no=2024/384
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/01/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12209000010492
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 11215000008516
case_no = 2024/485
pre_hear_date = 12/12/2024
next_hear_date = 24/01/2025
new_case_purpose = 18678000000000
isadjourn = NO
court_code = 10024
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=12209000010492
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:36
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=11215000008516
Param Type = c
case_no=2024/485
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = c
next_hear_date=24/01/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
court_code=10024
Param Type = n
pre_case_purpose=18678000000000
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,adjourn_remark,adjourn_type,trn_rcms_caseid,case_no,pre_hear_date,next_hear_date,new_case_purpose,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,null,:adjourn_type,:trn_rcms_caseid,:case_no,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,:isadjourn,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12209000010493
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 11235000008606
pre_hear_date = 12/12/2024
court_code = 10024
case_no = 2024/486
next_hear_date = 24/01/2025
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=12209000010493
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:36
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=11235000008606
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = c
court_code=10024
Param Type = c
case_no=2024/486
Param Type = c
next_hear_date=24/01/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 11
RecordId = 12209000010494
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_type = 0
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 18779000009808
pre_hear_date = 12/12/2024
pre_case_purpose = 18678000000000
case_no = 2024/557
next_hear_date = 22/01/2025
new_case_purpose = 18678000000000
court_code = 10024
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=12209000010494
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:36
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:36
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=18779000009808
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2024/557
Param Type = c
next_hear_date=22/01/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
court_code=10024
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,next_hear_date,new_case_purpose,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 12209000010495
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 18783000009481
case_no = 2024/558
court_code = 10024
pre_hear_date = 12/12/2024
next_hear_date = 22/01/2025
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=12209000010495
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:37
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:37
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=18783000009481
Param Type = c
case_no=2024/558
Param Type = c
court_code=10024
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = c
next_hear_date=22/01/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
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,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 = 6
Adding new record to store data from Frame 2, Row 28 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 12209000010496
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 30/01/2025
case_no = 2024/705
court_code = 10024
trn_rcms_caseid = 13045000008888
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 12/12/2024
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=12209000010496
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:37
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:37
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=30/01/2025 00:00:00
Param Type = c
case_no=2024/705
Param Type = c
court_code=10024
Param Type = c
trn_rcms_caseid=13045000008888
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 6
Adding new record to store data from Frame 2, Row 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12209000010497
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 30/01/2025
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 13057000009379
case_no = 2024/706
court_code = 10024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 12/12/2024
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=12209000010497
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:37
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=30/01/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13057000009379
Param Type = c
case_no=2024/706
Param Type = c
court_code=10024
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=29
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 = 5
Adding new record to store data from Frame 2, Row 30 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010498
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 30/01/2025
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18678000000000
case_no = 2024/707
court_code = 10024
trn_rcms_caseid = 13091000009584
pre_case_purpose = 18678000000000
pre_hear_date = 12/12/2024
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=12209000010498
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:37
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=30/01/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
case_no=2024/707
Param Type = c
court_code=10024
Param Type = c
trn_rcms_caseid=13091000009584
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 31 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12209000010499
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 31/01/2025
new_case_purpose = 19542000000536
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2015/00084
court_code = 10024
trn_rcms_caseid = 461340
pre_case_purpose = 19542000000536
pre_hear_date = 12/12/2024
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=12209000010499
Param Type = n
trn_rcms_mhearingid=12209000010468
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:37
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=31/01/2025 00:00:00
Param Type = c
new_case_purpose=19542000000536
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2015/00084
Param Type = c
court_code=10024
Param Type = c
trn_rcms_caseid=461340
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
pre_hear_date=12/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=31
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3945153958760
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19647000000083 idvalue 0
Mapped case_no Row = 1 value = 2015/00235 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 31/01/2025 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 = 10024
trn_rcms_caseregid = 19647000000083
case_no = 2015/00235
prev_hearing_date = 12/12/2024
hearing_date = 31/01/2025
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 = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12209000010500
MapName trcmf1
SourceId 12209000010469
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 = 18473000000000
hearing_date = 31/01/2025
case_no = 2015/00235
trn_rcms_caseregid = 19647000000083
court_code = 10024
case_purpose = 18473000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010500
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010469
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:37
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=31/01/2025 00:00:00
Param Type = c
case_no=2015/00235
Param Type = c
trn_rcms_caseregid=19647000000083
Param Type = c
court_code=10024
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17907000000421 idvalue 0
Mapped case_no Row = 1 value = 2015/00328 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 31/01/2025 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 = 10024
trn_rcms_caseregid = 17907000000421
case_no = 2015/00328
prev_hearing_date = 12/12/2024
hearing_date = 31/01/2025
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010501
MapName trcmf1
SourceId 12209000010470
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 31/01/2025
case_no = 2015/00328
trn_rcms_caseregid = 17907000000421
court_code = 10024
case_purpose = 18473000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010501
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010470
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:40
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=31/01/2025 00:00:00
Param Type = c
case_no=2015/00328
Param Type = c
trn_rcms_caseregid=17907000000421
Param Type = c
court_code=10024
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12730000001199 idvalue 0
Mapped case_no Row = 1 value = 2016/00442 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 31/01/2025 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 = 10024
trn_rcms_caseregid = 12730000001199
case_no = 2016/00442
prev_hearing_date = 12/12/2024
hearing_date = 31/01/2025
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12209000010502
MapName trcmf1
SourceId 12209000010471
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 = 18473000000000
hearing_date = 31/01/2025
case_no = 2016/00442
trn_rcms_caseregid = 12730000001199
court_code = 10024
case_purpose = 18473000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010502
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010471
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:43
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05: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=18473000000000
Param Type = c
hearing_date=31/01/2025 00:00:00
Param Type = c
case_no=2016/00442
Param Type = c
trn_rcms_caseregid=12730000001199
Param Type = c
court_code=10024
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17858000000669 idvalue 0
Mapped case_no Row = 1 value = 2014/00492 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 31/01/2025 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 = 10024
trn_rcms_caseregid = 17858000000669
case_no = 2014/00492
prev_hearing_date = 12/12/2024
hearing_date = 31/01/2025
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 = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12209000010503
MapName trcmf1
SourceId 12209000010472
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 31/01/2025
case_no = 2014/00492
trn_rcms_caseregid = 17858000000669
court_code = 10024
case_purpose = 1000525
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010503
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010472
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:46
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05: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=1000525
Param Type = c
hearing_date=31/01/2025 00:00:00
Param Type = c
case_no=2014/00492
Param Type = c
trn_rcms_caseregid=17858000000669
Param Type = c
court_code=10024
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12764000000664 idvalue 0
Mapped case_no Row = 1 value = 2016/00443 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/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 = 31/01/2025 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 = 10024
trn_rcms_caseregid = 12764000000664
case_no = 2016/00443
prev_hearing_date = 12/12/2024
hearing_date = 31/01/2025
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purposename=???? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????????? ????
Time elapsed = 8
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12209000010504
MapName trcmf1
SourceId 12209000010473
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 31/01/2025
case_no = 2016/00443
trn_rcms_caseregid = 12764000000664
court_code = 10024
case_purpose = 12555000000002
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010504
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010473
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:48
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=31/01/2025 00:00:00
Param Type = c
case_no=2016/00443
Param Type = c
trn_rcms_caseregid=12764000000664
Param Type = c
court_code=10024
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19538000000762 idvalue 0
Mapped case_no Row = 1 value = 2015/00412 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/01/2025 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 = 10024
trn_rcms_caseregid = 19538000000762
case_no = 2015/00412
prev_hearing_date = 12/12/2024
hearing_date = 15/01/2025
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 = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12209000010505
MapName trcmf1
SourceId 12209000010474
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 = 15/01/2025
case_no = 2015/00412
trn_rcms_caseregid = 19538000000762
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010505
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010474
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:51
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=15/01/2025 00:00:00
Param Type = c
case_no=2015/00412
Param Type = c
trn_rcms_caseregid=19538000000762
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19553000001074 idvalue 0
Mapped case_no Row = 1 value = 2015/00413 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/01/2025 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 = 10024
trn_rcms_caseregid = 19553000001074
case_no = 2015/00413
prev_hearing_date = 12/12/2024
hearing_date = 15/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12209000010506
MapName trcmf1
SourceId 12209000010475
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 = 15/01/2025
case_no = 2015/00413
trn_rcms_caseregid = 19553000001074
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010506
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010475
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:54
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=15/01/2025 00:00:00
Param Type = c
case_no=2015/00413
Param Type = c
trn_rcms_caseregid=19553000001074
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18534000002212 idvalue 0
Mapped case_no Row = 1 value = 2018/00098 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 31/01/2025 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 = 10024
trn_rcms_caseregid = 18534000002212
case_no = 2018/00098
prev_hearing_date = 12/12/2024
hearing_date = 31/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010507
MapName trcmf1
SourceId 12209000010476
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 = 31/01/2025
case_no = 2018/00098
trn_rcms_caseregid = 18534000002212
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010507
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010476
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:56
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=31/01/2025 00:00:00
Param Type = c
case_no=2018/00098
Param Type = c
trn_rcms_caseregid=18534000002212
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11911000006101 idvalue 0
Mapped case_no Row = 1 value = 2021/184 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 03/02/2025 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 = 10024
trn_rcms_caseregid = 11911000006101
case_no = 2021/184
prev_hearing_date = 12/12/2024
hearing_date = 03/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 6
RecordId = 12209000010508
MapName trcmf1
SourceId 12209000010477
Select sysdate as sdt from dual
Time elapsed = 15
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 = 03/02/2025
case_no = 2021/184
trn_rcms_caseregid = 11911000006101
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010508
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010477
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:05:59
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:05:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=03/02/2025 00:00:00
Param Type = c
case_no=2021/184
Param Type = c
trn_rcms_caseregid=11911000006101
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11939000005626 idvalue 0
Mapped case_no Row = 1 value = 2021/185 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 03/02/2025 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 = 10024
trn_rcms_caseregid = 11939000005626
case_no = 2021/185
prev_hearing_date = 12/12/2024
hearing_date = 03/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 17
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12209000010509
MapName trcmf1
SourceId 12209000010478
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/02/2025
case_no = 2021/185
trn_rcms_caseregid = 11939000005626
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010509
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010478
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:02
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=03/02/2025 00:00:00
Param Type = c
case_no=2021/185
Param Type = c
trn_rcms_caseregid=11939000005626
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17682000005372 idvalue 0
Mapped case_no Row = 1 value = 2021/52 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 03/02/2025 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 = 10024
trn_rcms_caseregid = 17682000005372
case_no = 2021/52
prev_hearing_date = 12/12/2024
hearing_date = 03/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12209000010510
MapName trcmf1
SourceId 12209000010479
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 03/02/2025
case_no = 2021/52
trn_rcms_caseregid = 17682000005372
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010510
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010479
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:05
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:05
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/02/2025 00:00:00
Param Type = c
case_no=2021/52
Param Type = c
trn_rcms_caseregid=17682000005372
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11034000006790 idvalue 0
Mapped case_no Row = 1 value = 2022/201 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2025 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 = 10024
trn_rcms_caseregid = 11034000006790
case_no = 2022/201
prev_hearing_date = 12/12/2024
hearing_date = 05/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12209000010511
MapName trcmf1
SourceId 12209000010480
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/02/2025
case_no = 2022/201
trn_rcms_caseregid = 11034000006790
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010511
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010480
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:08
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/02/2025 00:00:00
Param Type = c
case_no=2022/201
Param Type = c
trn_rcms_caseregid=11034000006790
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11075000006609 idvalue 0
Mapped case_no Row = 1 value = 2022/202 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2025 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 = 10024
trn_rcms_caseregid = 11075000006609
case_no = 2022/202
prev_hearing_date = 12/12/2024
hearing_date = 05/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010512
MapName trcmf1
SourceId 12209000010481
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 = 05/02/2025
case_no = 2022/202
trn_rcms_caseregid = 11075000006609
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010512
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010481
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:11
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:11
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/02/2025 00:00:00
Param Type = c
case_no=2022/202
Param Type = c
trn_rcms_caseregid=11075000006609
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11169000006686 idvalue 0
Mapped case_no Row = 1 value = 2022/203 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2025 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 = 10024
trn_rcms_caseregid = 11169000006686
case_no = 2022/203
prev_hearing_date = 12/12/2024
hearing_date = 05/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 12209000010513
MapName trcmf1
SourceId 12209000010482
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/02/2025
case_no = 2022/203
trn_rcms_caseregid = 11169000006686
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010513
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010482
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:14
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/02/2025 00:00:00
Param Type = c
case_no=2022/203
Param Type = c
trn_rcms_caseregid=11169000006686
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12232000006993 idvalue 0
Mapped case_no Row = 1 value = 2022/205 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2025 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 = 10024
trn_rcms_caseregid = 12232000006993
case_no = 2022/205
prev_hearing_date = 12/12/2024
hearing_date = 05/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12209000010514
MapName trcmf1
SourceId 12209000010483
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/02/2025
case_no = 2022/205
trn_rcms_caseregid = 12232000006993
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010514
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010483
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:17
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/02/2025 00:00:00
Param Type = c
case_no=2022/205
Param Type = c
trn_rcms_caseregid=12232000006993
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13339000008463 idvalue 0
Mapped case_no Row = 1 value = 2022/515 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2025 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 = 10024
trn_rcms_caseregid = 13339000008463
case_no = 2022/515
prev_hearing_date = 12/12/2024
hearing_date = 05/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 12
RecordId = 12209000010515
MapName trcmf1
SourceId 12209000010484
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/02/2025
case_no = 2022/515
trn_rcms_caseregid = 13339000008463
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010515
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010484
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:20
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/02/2025 00:00:00
Param Type = c
case_no=2022/515
Param Type = c
trn_rcms_caseregid=13339000008463
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15983000007498 idvalue 0
Mapped case_no Row = 1 value = 2022/523 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2025 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 = 10024
trn_rcms_caseregid = 15983000007498
case_no = 2022/523
prev_hearing_date = 12/12/2024
hearing_date = 05/02/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010516
MapName trcmf1
SourceId 12209000010485
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/02/2025
case_no = 2022/523
trn_rcms_caseregid = 15983000007498
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010516
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010485
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:22
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/02/2025 00:00:00
Param Type = c
case_no=2022/523
Param Type = c
trn_rcms_caseregid=15983000007498
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19525000008453 idvalue 0
Mapped case_no Row = 1 value = 2023/370 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/01/2025 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 = 10024
trn_rcms_caseregid = 19525000008453
case_no = 2023/370
prev_hearing_date = 12/12/2024
hearing_date = 08/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010517
MapName trcmf1
SourceId 12209000010486
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/01/2025
case_no = 2023/370
trn_rcms_caseregid = 19525000008453
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010517
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010486
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:25
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/01/2025 00:00:00
Param Type = c
case_no=2023/370
Param Type = c
trn_rcms_caseregid=19525000008453
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14581000008386 idvalue 0
Mapped case_no Row = 1 value = 2023/423 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/01/2025 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 = 10024
trn_rcms_caseregid = 14581000008386
case_no = 2023/423
prev_hearing_date = 12/12/2024
hearing_date = 08/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12209000010518
MapName trcmf1
SourceId 12209000010487
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 = 08/01/2025
case_no = 2023/423
trn_rcms_caseregid = 14581000008386
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010518
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010487
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:28
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/01/2025 00:00:00
Param Type = c
case_no=2023/423
Param Type = c
trn_rcms_caseregid=14581000008386
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14584000008864 idvalue 0
Mapped case_no Row = 1 value = 2023/424 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/01/2025 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 = 10024
trn_rcms_caseregid = 14584000008864
case_no = 2023/424
prev_hearing_date = 12/12/2024
hearing_date = 08/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 210
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 = 12209000010519
MapName trcmf1
SourceId 12209000010488
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 = 08/01/2025
case_no = 2023/424
trn_rcms_caseregid = 14584000008864
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010519
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010488
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:31
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/01/2025 00:00:00
Param Type = c
case_no=2023/424
Param Type = c
trn_rcms_caseregid=14584000008864
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15643000007777 idvalue 0
Mapped case_no Row = 1 value = 2024/329 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/01/2025 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 = 10024
trn_rcms_caseregid = 15643000007777
case_no = 2024/329
prev_hearing_date = 12/12/2024
hearing_date = 08/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
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 = 12209000010520
MapName trcmf1
SourceId 12209000010489
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/01/2025
case_no = 2024/329
trn_rcms_caseregid = 15643000007777
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010520
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010489
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:33
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/01/2025 00:00:00
Param Type = c
case_no=2024/329
Param Type = c
trn_rcms_caseregid=15643000007777
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15856000008216 idvalue 0
Mapped case_no Row = 1 value = 2024/330 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/01/2025 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 = 10024
trn_rcms_caseregid = 15856000008216
case_no = 2024/330
prev_hearing_date = 12/12/2024
hearing_date = 08/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12209000010521
MapName trcmf1
SourceId 12209000010490
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 = 08/01/2025
case_no = 2024/330
trn_rcms_caseregid = 15856000008216
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010521
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010490
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:36
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/01/2025 00:00:00
Param Type = c
case_no=2024/330
Param Type = c
trn_rcms_caseregid=15856000008216
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13372000008350 idvalue 0
Mapped case_no Row = 1 value = 2024/384 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/01/2025 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 = 10024
trn_rcms_caseregid = 13372000008350
case_no = 2024/384
prev_hearing_date = 12/12/2024
hearing_date = 08/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010522
MapName trcmf1
SourceId 12209000010491
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/01/2025
case_no = 2024/384
trn_rcms_caseregid = 13372000008350
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010522
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010491
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:39
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/01/2025 00:00:00
Param Type = c
case_no=2024/384
Param Type = c
trn_rcms_caseregid=13372000008350
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11215000008516 idvalue 0
Mapped case_no Row = 1 value = 2024/485 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 24/01/2025 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 = 10024
trn_rcms_caseregid = 11215000008516
case_no = 2024/485
prev_hearing_date = 12/12/2024
hearing_date = 24/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010523
MapName trcmf1
SourceId 12209000010492
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 24/01/2025
case_no = 2024/485
trn_rcms_caseregid = 11215000008516
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010523
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010492
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:42
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06: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=18678000000000
Param Type = c
hearing_date=24/01/2025 00:00:00
Param Type = c
case_no=2024/485
Param Type = c
trn_rcms_caseregid=11215000008516
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11235000008606 idvalue 0
Mapped case_no Row = 1 value = 2024/486 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 24/01/2025 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 = 10024
trn_rcms_caseregid = 11235000008606
case_no = 2024/486
prev_hearing_date = 12/12/2024
hearing_date = 24/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010524
MapName trcmf1
SourceId 12209000010493
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 = 24/01/2025
case_no = 2024/486
trn_rcms_caseregid = 11235000008606
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010524
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010493
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:44
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06: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=24/01/2025 00:00:00
Param Type = c
case_no=2024/486
Param Type = c
trn_rcms_caseregid=11235000008606
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18779000009808 idvalue 0
Mapped case_no Row = 1 value = 2024/557 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/01/2025 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 = 10024
trn_rcms_caseregid = 18779000009808
case_no = 2024/557
prev_hearing_date = 12/12/2024
hearing_date = 22/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12209000010525
MapName trcmf1
SourceId 12209000010494
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 = 22/01/2025
case_no = 2024/557
trn_rcms_caseregid = 18779000009808
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010525
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010494
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:47
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/01/2025 00:00:00
Param Type = c
case_no=2024/557
Param Type = c
trn_rcms_caseregid=18779000009808
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/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 = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18783000009481 idvalue 0
Mapped case_no Row = 1 value = 2024/558 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/01/2025 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 = 10024
trn_rcms_caseregid = 18783000009481
case_no = 2024/558
prev_hearing_date = 12/12/2024
hearing_date = 22/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 6
RecordId = 12209000010526
MapName trcmf1
SourceId 12209000010495
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/01/2025
case_no = 2024/558
trn_rcms_caseregid = 18783000009481
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010526
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010495
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:50
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/01/2025 00:00:00
Param Type = c
case_no=2024/558
Param Type = c
trn_rcms_caseregid=18783000009481
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 28
>>Mapping
Mapped court_code Row = 1 value = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13045000008888 idvalue 0
Mapped case_no Row = 1 value = 2024/705 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/01/2025 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 = 10024
trn_rcms_caseregid = 13045000008888
case_no = 2024/705
prev_hearing_date = 12/12/2024
hearing_date = 30/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12209000010527
MapName trcmf1
SourceId 12209000010496
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 = 30/01/2025
case_no = 2024/705
trn_rcms_caseregid = 13045000008888
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010527
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010496
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:53
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=30/01/2025 00:00:00
Param Type = c
case_no=2024/705
Param Type = c
trn_rcms_caseregid=13045000008888
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 29
>>Mapping
Mapped court_code Row = 1 value = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13057000009379 idvalue 0
Mapped case_no Row = 1 value = 2024/706 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/01/2025 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 = 10024
trn_rcms_caseregid = 13057000009379
case_no = 2024/706
prev_hearing_date = 12/12/2024
hearing_date = 30/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 6
RecordId = 12209000010528
MapName trcmf1
SourceId 12209000010497
Select sysdate as sdt from dual
Time elapsed = 213
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 = 30/01/2025
case_no = 2024/706
trn_rcms_caseregid = 13057000009379
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010528
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010497
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:56
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=30/01/2025 00:00:00
Param Type = c
case_no=2024/706
Param Type = c
trn_rcms_caseregid=13057000009379
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 30
>>Mapping
Mapped court_code Row = 1 value = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13091000009584 idvalue 0
Mapped case_no Row = 1 value = 2024/707 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/01/2025 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 = 10024
trn_rcms_caseregid = 13091000009584
case_no = 2024/707
prev_hearing_date = 12/12/2024
hearing_date = 30/01/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12209000010529
MapName trcmf1
SourceId 12209000010498
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 = 30/01/2025
case_no = 2024/707
trn_rcms_caseregid = 13091000009584
court_code = 10024
case_purpose = 18678000000000
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010529
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010498
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:06:59
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:06:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=30/01/2025 00:00:00
Param Type = c
case_no=2024/707
Param Type = c
trn_rcms_caseregid=13091000009584
Param Type = c
court_code=10024
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/12/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 31
>>Mapping
Mapped court_code Row = 1 value = 10024 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 461340 idvalue 0
Mapped case_no Row = 1 value = 2015/00084 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 31/01/2025 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 = 10024
trn_rcms_caseregid = 461340
case_no = 2015/00084
prev_hearing_date = 12/12/2024
hearing_date = 31/01/2025
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 = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12209000010530
MapName trcmf1
SourceId 12209000010499
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 = 19542000000536
hearing_date = 31/01/2025
case_no = 2015/00084
trn_rcms_caseregid = 461340
court_code = 10024
case_purpose = 19542000000536
prev_hearing_date = 12/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12209000010530
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12209000010499
Param Type = c
cancel=F
Param Type = c
createdby=sdm_chaumu_PRO
Param Type = c
createdon=04/01/2025 12:07:02
Param Type = c
username=sdm_chaumu_PRO
Param Type = c
modifiedon=04/01/2025 12:07:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=31/01/2025 00:00:00
Param Type = c
case_no=2015/00084
Param Type = c
trn_rcms_caseregid=461340
Param Type = c
court_code=10024
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=12/12/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 = 3945154045983
Time elapsed for MD Map = 3945154045985
Time elapsed for Save History = 3945154045987
Time elapsed for Save Attachment = 3945154045988
Time elapsed for After Save WF Exec = 3945154045991
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"12209000010468"}]}
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=sdm_chaumu_PRO
Param Type = c
calledon=04/01/2025 12:05:55
Param Type = c
callfinished=04/01/2025 12:07:26
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=91007
Param Type = n
dbtimetaken=87429
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