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
gcmsacem_mavli827ccb0eea8a706c4c34a16891f84e7b![]()
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=acem_mavli
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=acem_mavli
Time elapsed = 16
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=acem_mavli
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=acem_mavli
Time elapsed = 16
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=acem_mavli
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=acem_mavli
Time elapsed = 15
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 12122000000106
Result = 12122000000106
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=acem_mavli
Time elapsed = 16
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 4102
Result = 4102
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=acem_mavli
Time elapsed = 15
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = acem_mavli
Result = acem_mavli
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=acem_mavli
Time elapsed = 0
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10229
Result = 10229
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 = 0
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=acem_mavli
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=acem_mavli
Time elapsed = 16
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Udaipur
Result = Udaipur
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=acem_mavli
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=acem_mavli
Time elapsed = 0
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=4102
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=4102
Time elapsed = 0
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=acem_mavli
Time elapsed = 15
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=acem_mavli
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=acem_mavli
Time elapsed = 0
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_reader
Result = court_reader
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 0
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=acem_mavli
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=acem_mavli
Time elapsed = 16
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 13
Result = 13
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 0
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 0
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_reader,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 0
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 = 0
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 = 10229
hearing_date = 27/06/2024
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 0
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 15
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 = 0
RecordId = 12026000008742
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
hearing_date = 27/06/2024
courtcode = 10229
Posting record
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:32
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=27/06/2024 00:00:00
Param Type = c
courtcode=10229
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 = 0
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 = 0
RecordId = 12026000008743
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
pre_case_purpose = 1000492
court_code = 10229
pre_hear_date = 27/06/2024
case_no = 2024/186
trn_rcms_caseid = 17505000009159
adjourn_remark =
adjourn_type = 0
new_case_purpose = 1000492
next_hear_date = 22/08/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=12026000008743
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:32
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=10229
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = c
case_no=2024/186
Param Type = c
trn_rcms_caseid=17505000009159
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=22/08/2024 00:00:00
Param Type = c
isadjourn=NO
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,pre_case_purpose,court_code,pre_hear_date,case_no,trn_rcms_caseid,adjourn_remark,adjourn_type,new_case_purpose,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,:pre_case_purpose,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseid,null,:adjourn_type,:new_case_purpose,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 = 15
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 = 0
RecordId = 12026000008744
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 0
pre_hear_date = 27/06/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 17628000007838
court_code = 10229
case_no = 2024/187
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 22/08/2024
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=12026000008744
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:32
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=17628000007838
Param Type = c
court_code=10229
Param Type = c
case_no=2024/187
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=22/08/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,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 = 16
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 = 0
RecordId = 12026000008745
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 0
pre_hear_date = 27/06/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 17702000007217
court_code = 10229
case_no = 2024/188
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 22/08/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=12026000008745
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:33
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=17702000007217
Param Type = c
court_code=10229
Param Type = c
case_no=2024/188
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=22/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 0
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 = 0
RecordId = 12026000008746
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
next_hear_date = 02/08/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/190
court_code = 10229
trn_rcms_caseid = 17891000009061
pre_case_purpose = 1000492
pre_hear_date = 27/06/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=12026000008746
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:33
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=02/08/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/190
Param Type = c
court_code=10229
Param Type = c
trn_rcms_caseid=17891000009061
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008747
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 15
next_hear_date = 20/08/2024
new_case_purpose = 1000492
adjourn_remark =
isadjourn = NO
adjourn_type = 0
case_no = 2024/191
court_code = 10229
trn_rcms_caseid = 15696000008792
pre_case_purpose = 1000492
pre_hear_date = 27/06/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=12026000008747
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:33
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=20/08/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/191
Param Type = c
court_code=10229
Param Type = c
trn_rcms_caseid=15696000008792
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_remark,isadjourn,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,null,:isadjourn,: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 = 16
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 = 0
RecordId = 12026000008748
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 0
next_hear_date = 02/08/2024
new_case_purpose = 1000492
adjourn_type = 0
isadjourn = NO
pre_case_purpose = 1000492
trn_rcms_caseid = 15760000009231
pre_hear_date = 27/06/2024
court_code = 10229
case_no = 2024/192
adjourn_remark =
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=12026000008748
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:33
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=02/08/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=15760000009231
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = c
court_code=10229
Param Type = c
case_no=2024/192
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,adjourn_type,isadjourn,pre_case_purpose,trn_rcms_caseid,pre_hear_date,court_code,case_no,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:isadjourn,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 15
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 = 0
RecordId = 12026000008749
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 0
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 02/08/2024
court_code = 10229
pre_case_purpose = 1000492
case_no = 2024/193
pre_hear_date = 27/06/2024
trn_rcms_caseid = 15819000007911
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=12026000008749
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:33
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:33
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
new_case_purpose=1000492
Param Type = c
next_hear_date=02/08/2024 00:00:00
Param Type = c
court_code=10229
Param Type = n
pre_case_purpose=1000492
Param Type = c
case_no=2024/193
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = c
trn_rcms_caseid=15819000007911
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,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,court_code,pre_case_purpose,case_no,pre_hear_date,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:pre_case_purpose,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 15
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 = 0
RecordId = 12026000008750
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
pre_hear_date = 27/06/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 10525000008482
court_code = 10229
case_no = 2024/206
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 29/08/2024
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=12026000008750
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:33
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=10525000008482
Param Type = c
court_code=10229
Param Type = c
case_no=2024/206
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=29/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 0
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 = 0
RecordId = 12026000008751
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 16
next_hear_date = 29/08/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/207
court_code = 10229
trn_rcms_caseid = 10575000008742
pre_case_purpose = 1000492
pre_hear_date = 27/06/2024
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=12026000008751
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:33
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=29/08/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/207
Param Type = c
court_code=10229
Param Type = c
trn_rcms_caseid=10575000008742
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 16
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 = 0
RecordId = 12026000008752
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 0
new_case_purpose = 1000492
next_hear_date = 19/09/2024
trn_rcms_caseid = 10630000008357
pre_hear_date = 27/06/2024
pre_case_purpose = 1000492
case_no = 2024/208
court_code = 10229
adjourn_remark =
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=12026000008752
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:33
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=19/09/2024 00:00:00
Param Type = c
trn_rcms_caseid=10630000008357
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
case_no=2024/208
Param Type = c
court_code=10229
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
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,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,court_code,adjourn_remark,isadjourn,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,null,:isadjourn,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008753
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
next_hear_date = 19/09/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/209
court_code = 10229
trn_rcms_caseid = 10660000009495
pre_case_purpose = 1000492
pre_hear_date = 27/06/2024
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=12026000008753
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:33
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=19/09/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/209
Param Type = c
court_code=10229
Param Type = c
trn_rcms_caseid=10660000009495
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008754
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
trn_rcms_caseid = 11233000008532
adjourn_remark =
isadjourn = NO
next_hear_date = 30/07/2024
case_no = 2024/217
court_code = 10229
new_case_purpose = 1000492
pre_case_purpose = 1000492
pre_hear_date = 27/06/2024
adjourn_type = 0
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=12026000008754
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:33
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=11233000008532
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=30/07/2024 00:00:00
Param Type = c
case_no=2024/217
Param Type = c
court_code=10229
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,adjourn_remark,isadjourn,next_hear_date,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,null,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008755
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
adjourn_remark =
trn_rcms_caseid = 248951
pre_hear_date = 27/06/2024
court_code = 10229
case_no = 2015/00088
pre_case_purpose = 1000525
isadjourn = NO
adjourn_type = 0
new_case_purpose = 1000525
next_hear_date = 29/07/2024
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=12026000008755
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:34
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=248951
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = c
court_code=10229
Param Type = c
case_no=2015/00088
Param Type = n
pre_case_purpose=1000525
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 0
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 = 0
RecordId = 12026000008756
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 15
adjourn_remark =
trn_rcms_caseid = 15603000000760
pre_hear_date = 27/06/2024
court_code = 10229
case_no = 2017/00103
pre_case_purpose = 1000525
isadjourn = NO
adjourn_type = 0
new_case_purpose = 1000525
next_hear_date = 29/08/2024
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=12026000008756
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:34
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=15603000000760
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = c
court_code=10229
Param Type = c
case_no=2017/00103
Param Type = n
pre_case_purpose=1000525
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=29/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=14
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 0
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 = 16
RecordId = 12026000008757
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 15
adjourn_remark =
adjourn_type = 0
pre_case_purpose = 1000525
pre_hear_date = 27/06/2024
new_case_purpose = 1000525
next_hear_date = 05/07/2024
court_code = 10229
isadjourn = NO
trn_rcms_caseid = 15603000001816
case_no = 2018/00073
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=12026000008757
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:34
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=05/07/2024 00:00:00
Param Type = c
court_code=10229
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=15603000001816
Param Type = c
case_no=2018/00073
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,adjourn_type,pre_case_purpose,pre_hear_date,new_case_purpose,next_hear_date,court_code,isadjourn,trn_rcms_caseid,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,null,:adjourn_type,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:isadjourn,:trn_rcms_caseid,:case_no,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 15
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 = 0
RecordId = 12026000008758
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 13645000003865
pre_hear_date = 27/06/2024
court_code = 10229
case_no = 2019/00266
next_hear_date = 17/09/2024
isadjourn = NO
pre_case_purpose = 1000525
new_case_purpose = 1000525
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=12026000008758
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:34
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13645000003865
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = c
court_code=10229
Param Type = c
case_no=2019/00266
Param Type = c
next_hear_date=17/09/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=1000525
Param Type = c
new_case_purpose=1000525
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_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 = 0
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 = 16
RecordId = 12026000008759
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 15
adjourn_type = 0
adjourn_remark =
isadjourn = NO
case_no = 2020/00168
trn_rcms_caseid = 10485000005488
pre_case_purpose = 1000525
court_code = 10229
next_hear_date = 19/07/2024
new_case_purpose = 1000525
pre_hear_date = 27/06/2024
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=12026000008759
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:34
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2020/00168
Param Type = c
trn_rcms_caseid=10485000005488
Param Type = n
pre_case_purpose=1000525
Param Type = c
court_code=10229
Param Type = c
next_hear_date=19/07/2024 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,case_no,trn_rcms_caseid,pre_case_purpose,court_code,next_hear_date,new_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:case_no,:trn_rcms_caseid,:pre_case_purpose,:court_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008760
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 16
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 11964000004767
case_no = 2020/00231
court_code = 10229
pre_hear_date = 27/06/2024
next_hear_date = 29/07/2024
new_case_purpose = 1000525
pre_case_purpose = 1000525
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=12026000008760
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:34
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:34
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=11964000004767
Param Type = c
case_no=2020/00231
Param Type = c
court_code=10229
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = n
pre_case_purpose=1000525
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,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 = 15
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 = 0
RecordId = 12026000008761
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 0
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 29/07/2024
trn_rcms_caseid = 19690000005877
case_no = 2021/228
court_code = 10229
new_case_purpose = 1000525
pre_case_purpose = 1000525
pre_hear_date = 27/06/2024
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=12026000008761
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:34
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:34
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=29/07/2024 00:00:00
Param Type = c
trn_rcms_caseid=19690000005877
Param Type = c
case_no=2021/228
Param Type = c
court_code=10229
Param Type = c
new_case_purpose=1000525
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008762
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
next_hear_date = 29/07/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 19726000005791
court_code = 10229
case_no = 2021/229
new_case_purpose = 1000525
pre_case_purpose = 1000525
pre_hear_date = 27/06/2024
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=12026000008762
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:34
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=19726000005791
Param Type = c
court_code=10229
Param Type = c
case_no=2021/229
Param Type = c
new_case_purpose=1000525
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,court_code,case_no,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:court_code,:case_no,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 16
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 = 0
RecordId = 12026000008763
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 0
next_hear_date = 01/07/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 1000525
case_no = 2021/347
court_code = 10229
trn_rcms_caseid = 15464000006490
pre_case_purpose = 1000525
pre_hear_date = 27/06/2024
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=12026000008763
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:34
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=01/07/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000525
Param Type = c
case_no=2021/347
Param Type = c
court_code=10229
Param Type = c
trn_rcms_caseid=15464000006490
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 = 0
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 = 0
RecordId = 12026000008764
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 0
next_hear_date = 12/07/2024
new_case_purpose = 1000525
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2021/348
court_code = 10229
trn_rcms_caseid = 15493000005479
pre_case_purpose = 1000525
pre_hear_date = 27/06/2024
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=12026000008764
Param Type = n
trn_rcms_mhearingid=12026000008742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:34
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=12/07/2024 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2021/348
Param Type = c
court_code=10229
Param Type = c
trn_rcms_caseid=15493000005479
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=27/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3928726831084
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17505000009159 idvalue 0
Mapped case_no Row = 1 value = 2024/186 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 22/08/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 17505000009159
case_no = 2024/186
prev_hearing_date = 27/06/2024
hearing_date = 22/08/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purposename=?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????
Time elapsed = 0
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008765
MapName trcmf1
SourceId 12026000008743
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 22/08/2024
case_no = 2024/186
trn_rcms_caseregid = 17505000009159
court_code = 10229
case_purpose = 1000492
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008765
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008743
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:35
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=22/08/2024 00:00:00
Param Type = c
case_no=2024/186
Param Type = c
trn_rcms_caseregid=17505000009159
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 2
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17628000007838 idvalue 0
Mapped case_no Row = 1 value = 2024/187 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 22/08/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 17628000007838
case_no = 2024/187
prev_hearing_date = 27/06/2024
hearing_date = 22/08/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 16
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 = 0
RecordId = 12026000008766
MapName trcmf1
SourceId 12026000008744
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 22/08/2024
case_no = 2024/187
trn_rcms_caseregid = 17628000007838
court_code = 10229
case_purpose = 1000492
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008766
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008744
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:35
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=22/08/2024 00:00:00
Param Type = c
case_no=2024/187
Param Type = c
trn_rcms_caseregid=17628000007838
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 3
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17702000007217 idvalue 0
Mapped case_no Row = 1 value = 2024/188 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 22/08/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 17702000007217
case_no = 2024/188
prev_hearing_date = 27/06/2024
hearing_date = 22/08/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008767
MapName trcmf1
SourceId 12026000008745
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 22/08/2024
case_no = 2024/188
trn_rcms_caseregid = 17702000007217
court_code = 10229
case_purpose = 1000492
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008767
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008745
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:35
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=22/08/2024 00:00:00
Param Type = c
case_no=2024/188
Param Type = c
trn_rcms_caseregid=17702000007217
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 4
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17891000009061 idvalue 0
Mapped case_no Row = 1 value = 2024/190 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 02/08/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 17891000009061
case_no = 2024/190
prev_hearing_date = 27/06/2024
hearing_date = 02/08/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 15
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 16
RecordId = 12026000008768
MapName trcmf1
SourceId 12026000008746
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 02/08/2024
case_no = 2024/190
trn_rcms_caseregid = 17891000009061
court_code = 10229
case_purpose = 1000492
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008768
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008746
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:35
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=02/08/2024 00:00:00
Param Type = c
case_no=2024/190
Param Type = c
trn_rcms_caseregid=17891000009061
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 5
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15696000008792 idvalue 0
Mapped case_no Row = 1 value = 2024/191 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 20/08/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 15696000008792
case_no = 2024/191
prev_hearing_date = 27/06/2024
hearing_date = 20/08/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008769
MapName trcmf1
SourceId 12026000008747
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 20/08/2024
case_no = 2024/191
trn_rcms_caseregid = 15696000008792
court_code = 10229
case_purpose = 1000492
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008769
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008747
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:35
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=20/08/2024 00:00:00
Param Type = c
case_no=2024/191
Param Type = c
trn_rcms_caseregid=15696000008792
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 6
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15760000009231 idvalue 0
Mapped case_no Row = 1 value = 2024/192 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 02/08/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 15760000009231
case_no = 2024/192
prev_hearing_date = 27/06/2024
hearing_date = 02/08/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008770
MapName trcmf1
SourceId 12026000008748
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 16
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 02/08/2024
case_no = 2024/192
trn_rcms_caseregid = 15760000009231
court_code = 10229
case_purpose = 1000492
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008770
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008748
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:35
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=02/08/2024 00:00:00
Param Type = c
case_no=2024/192
Param Type = c
trn_rcms_caseregid=15760000009231
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 7
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15819000007911 idvalue 0
Mapped case_no Row = 1 value = 2024/193 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 02/08/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 15819000007911
case_no = 2024/193
prev_hearing_date = 27/06/2024
hearing_date = 02/08/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 16
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 = 0
RecordId = 12026000008771
MapName trcmf1
SourceId 12026000008749
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 02/08/2024
case_no = 2024/193
trn_rcms_caseregid = 15819000007911
court_code = 10229
case_purpose = 1000492
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008771
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008749
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:35
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=02/08/2024 00:00:00
Param Type = c
case_no=2024/193
Param Type = c
trn_rcms_caseregid=15819000007911
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 8
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10525000008482 idvalue 0
Mapped case_no Row = 1 value = 2024/206 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 29/08/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 10525000008482
case_no = 2024/206
prev_hearing_date = 27/06/2024
hearing_date = 29/08/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008772
MapName trcmf1
SourceId 12026000008750
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 16
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 29/08/2024
case_no = 2024/206
trn_rcms_caseregid = 10525000008482
court_code = 10229
case_purpose = 1000492
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008772
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008750
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:36
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00: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=1000492
Param Type = c
hearing_date=29/08/2024 00:00:00
Param Type = c
case_no=2024/206
Param Type = c
trn_rcms_caseregid=10525000008482
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 9
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10575000008742 idvalue 0
Mapped case_no Row = 1 value = 2024/207 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 29/08/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 10575000008742
case_no = 2024/207
prev_hearing_date = 27/06/2024
hearing_date = 29/08/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008773
MapName trcmf1
SourceId 12026000008751
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 29/08/2024
case_no = 2024/207
trn_rcms_caseregid = 10575000008742
court_code = 10229
case_purpose = 1000492
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008773
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008751
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:36
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00: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=1000492
Param Type = c
hearing_date=29/08/2024 00:00:00
Param Type = c
case_no=2024/207
Param Type = c
trn_rcms_caseregid=10575000008742
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 10
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10630000008357 idvalue 0
Mapped case_no Row = 1 value = 2024/208 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 19/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 10630000008357
case_no = 2024/208
prev_hearing_date = 27/06/2024
hearing_date = 19/09/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 15
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 = 0
RecordId = 12026000008774
MapName trcmf1
SourceId 12026000008752
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 19/09/2024
case_no = 2024/208
trn_rcms_caseregid = 10630000008357
court_code = 10229
case_purpose = 1000492
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008774
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008752
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:36
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00: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=1000492
Param Type = c
hearing_date=19/09/2024 00:00:00
Param Type = c
case_no=2024/208
Param Type = c
trn_rcms_caseregid=10630000008357
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 11
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10660000009495 idvalue 0
Mapped case_no Row = 1 value = 2024/209 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 19/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 10660000009495
case_no = 2024/209
prev_hearing_date = 27/06/2024
hearing_date = 19/09/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 16
RecordId = 12026000008775
MapName trcmf1
SourceId 12026000008753
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 19/09/2024
case_no = 2024/209
trn_rcms_caseregid = 10660000009495
court_code = 10229
case_purpose = 1000492
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008775
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008753
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:36
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00: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=1000492
Param Type = c
hearing_date=19/09/2024 00:00:00
Param Type = c
case_no=2024/209
Param Type = c
trn_rcms_caseregid=10660000009495
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 12
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11233000008532 idvalue 0
Mapped case_no Row = 1 value = 2024/217 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 30/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 11233000008532
case_no = 2024/217
prev_hearing_date = 27/06/2024
hearing_date = 30/07/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 16
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 = 0
RecordId = 12026000008776
MapName trcmf1
SourceId 12026000008754
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 30/07/2024
case_no = 2024/217
trn_rcms_caseregid = 11233000008532
court_code = 10229
case_purpose = 1000492
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008776
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008754
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:36
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00: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=1000492
Param Type = c
hearing_date=30/07/2024 00:00:00
Param Type = c
case_no=2024/217
Param Type = c
trn_rcms_caseregid=11233000008532
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 13
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 248951 idvalue 0
Mapped case_no Row = 1 value = 2015/00088 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/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 = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 248951
case_no = 2015/00088
prev_hearing_date = 27/06/2024
hearing_date = 29/07/2024
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purposename=???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????
Time elapsed = 0
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 = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 15
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 = 0
RecordId = 12026000008777
MapName trcmf1
SourceId 12026000008755
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 29/07/2024
case_no = 2015/00088
trn_rcms_caseregid = 248951
court_code = 10229
case_purpose = 1000525
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008777
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008755
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:36
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00: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=1000525
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2015/00088
Param Type = c
trn_rcms_caseregid=248951
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 14
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15603000000760 idvalue 0
Mapped case_no Row = 1 value = 2017/00103 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/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 = 29/08/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 15603000000760
case_no = 2017/00103
prev_hearing_date = 27/06/2024
hearing_date = 29/08/2024
prev_case_purposename = ???? ????
prev_case_purpose =
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 = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008778
MapName trcmf1
SourceId 12026000008756
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 29/08/2024
case_no = 2017/00103
trn_rcms_caseregid = 15603000000760
court_code = 10229
case_purpose = 1000525
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008778
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008756
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:37
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00: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=1000525
Param Type = c
hearing_date=29/08/2024 00:00:00
Param Type = c
case_no=2017/00103
Param Type = c
trn_rcms_caseregid=15603000000760
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 15
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15603000001816 idvalue 0
Mapped case_no Row = 1 value = 2018/00073 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 05/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 15603000001816
case_no = 2018/00073
prev_hearing_date = 27/06/2024
hearing_date = 05/07/2024
prev_case_purposename = ???? ????
prev_case_purpose =
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 = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 15
RecordId = 12026000008779
MapName trcmf1
SourceId 12026000008757
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 05/07/2024
case_no = 2018/00073
trn_rcms_caseregid = 15603000001816
court_code = 10229
case_purpose = 1000525
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008779
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008757
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:37
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00: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=1000525
Param Type = c
hearing_date=05/07/2024 00:00:00
Param Type = c
case_no=2018/00073
Param Type = c
trn_rcms_caseregid=15603000001816
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 16
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13645000003865 idvalue 0
Mapped case_no Row = 1 value = 2019/00266 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/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 = 17/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 13645000003865
case_no = 2019/00266
prev_hearing_date = 27/06/2024
hearing_date = 17/09/2024
prev_case_purposename = ???? ????
prev_case_purpose =
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 = 16
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 15
RecordId = 12026000008780
MapName trcmf1
SourceId 12026000008758
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 17/09/2024
case_no = 2019/00266
trn_rcms_caseregid = 13645000003865
court_code = 10229
case_purpose = 1000525
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008780
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008758
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:37
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00: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=1000525
Param Type = c
hearing_date=17/09/2024 00:00:00
Param Type = c
case_no=2019/00266
Param Type = c
trn_rcms_caseregid=13645000003865
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 17
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10485000005488 idvalue 0
Mapped case_no Row = 1 value = 2020/00168 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/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 = 19/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 10485000005488
case_no = 2020/00168
prev_hearing_date = 27/06/2024
hearing_date = 19/07/2024
prev_case_purposename = ???? ????
prev_case_purpose =
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 = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008781
MapName trcmf1
SourceId 12026000008759
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 16
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 19/07/2024
case_no = 2020/00168
trn_rcms_caseregid = 10485000005488
court_code = 10229
case_purpose = 1000525
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008781
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008759
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:37
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00: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=1000525
Param Type = c
hearing_date=19/07/2024 00:00:00
Param Type = c
case_no=2020/00168
Param Type = c
trn_rcms_caseregid=10485000005488
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 18
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11964000004767 idvalue 0
Mapped case_no Row = 1 value = 2020/00231 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/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 = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 11964000004767
case_no = 2020/00231
prev_hearing_date = 27/06/2024
hearing_date = 29/07/2024
prev_case_purposename = ???? ????
prev_case_purpose =
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 = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008782
MapName trcmf1
SourceId 12026000008760
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 29/07/2024
case_no = 2020/00231
trn_rcms_caseregid = 11964000004767
court_code = 10229
case_purpose = 1000525
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008782
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008760
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:37
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00: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=1000525
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2020/00231
Param Type = c
trn_rcms_caseregid=11964000004767
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 19
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19690000005877 idvalue 0
Mapped case_no Row = 1 value = 2021/228 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/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 = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 19690000005877
case_no = 2021/228
prev_hearing_date = 27/06/2024
hearing_date = 29/07/2024
prev_case_purposename = ???? ????
prev_case_purpose =
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 = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 16
RecordId = 12026000008783
MapName trcmf1
SourceId 12026000008761
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 29/07/2024
case_no = 2021/228
trn_rcms_caseregid = 19690000005877
court_code = 10229
case_purpose = 1000525
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008783
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008761
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:37
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00: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=1000525
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2021/228
Param Type = c
trn_rcms_caseregid=19690000005877
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 20
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19726000005791 idvalue 0
Mapped case_no Row = 1 value = 2021/229 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/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 = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 19726000005791
case_no = 2021/229
prev_hearing_date = 27/06/2024
hearing_date = 29/07/2024
prev_case_purposename = ???? ????
prev_case_purpose =
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 = 16
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008784
MapName trcmf1
SourceId 12026000008762
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 29/07/2024
case_no = 2021/229
trn_rcms_caseregid = 19726000005791
court_code = 10229
case_purpose = 1000525
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008784
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008762
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:37
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00: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=1000525
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2021/229
Param Type = c
trn_rcms_caseregid=19726000005791
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 21
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15464000006490 idvalue 0
Mapped case_no Row = 1 value = 2021/347 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/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 = 01/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 15464000006490
case_no = 2021/347
prev_hearing_date = 27/06/2024
hearing_date = 01/07/2024
prev_case_purposename = ???? ????
prev_case_purpose =
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 = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 16
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 = 12026000008785
MapName trcmf1
SourceId 12026000008763
Select sysdate as sdt from dual
Time elapsed = 0
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 01/07/2024
case_no = 2021/347
trn_rcms_caseregid = 15464000006490
court_code = 10229
case_purpose = 1000525
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008785
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008763
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:38
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=01/07/2024 00:00:00
Param Type = c
case_no=2021/347
Param Type = c
trn_rcms_caseregid=15464000006490
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 22
>>Mapping
Mapped court_code Row = 1 value = 10229 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15493000005479 idvalue 0
Mapped case_no Row = 1 value = 2021/348 idvalue 0
Mapped prev_hearing_date Row = 1 value = 27/06/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 = 12/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10229
trn_rcms_caseregid = 15493000005479
case_no = 2021/348
prev_hearing_date = 27/06/2024
hearing_date = 12/07/2024
prev_case_purposename = ???? ????
prev_case_purpose =
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 = 0
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 0
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 = 0
RecordId = 12026000008786
MapName trcmf1
SourceId 12026000008764
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 0
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 12/07/2024
case_no = 2021/348
trn_rcms_caseregid = 15493000005479
court_code = 10229
case_purpose = 1000525
prev_hearing_date = 27/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=12026000008786
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12026000008764
Param Type = c
cancel=F
Param Type = c
createdby=acem_mavli
Param Type = c
createdon=28/06/2024 09:00:38
Param Type = c
username=acem_mavli
Param Type = c
modifiedon=28/06/2024 09:00:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=12/07/2024 00:00:00
Param Type = c
case_no=2021/348
Param Type = c
trn_rcms_caseregid=15493000005479
Param Type = c
court_code=10229
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=27/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
Time elapsed for Gen Map = 3928726834311
Time elapsed for MD Map = 3928726834326
Time elapsed for Save History = 3928726834326
Time elapsed for Save Attachment = 3928726834326
Time elapsed for After Save WF Exec = 3928726834326
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"12026000008742"}]}
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=acem_mavli
Param Type = c
calledon=28/06/2024 09:00:28
Param Type = c
callfinished=28/06/2024 09:00:34
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=6337
Param Type = n
dbtimetaken=3647
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