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
gcmsDM_bundi827ccb0eea8a706c4c34a16891f84e7b![]()
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=DM_bundi
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=DM_bundi
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ???? ???????,?????
Result = ???? ???????,?????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=DM_bundi
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=DM_bundi
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = DM
Result = DM
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=DM_bundi
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=DM_bundi
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 12836000000155
Result = 12836000000155
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=DM_bundi
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 3638
Result = 3638
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=DM_bundi
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = DM_bundi
Result = DM_bundi
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=DM_bundi
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10402
Result = 10402
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 = 4
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=DM_bundi
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=DM_bundi
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Bundi
Result = Bundi
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=DM_bundi
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=DM_bundi
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m8},{COURT_CATEGOTY})
Calling function sqlget
Result of sqlget = 10593000000007
Result = 10593000000007
Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
Calling function firesql
login_userid=3638
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=3638
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=DM_bundi
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10206000000014
Result = 10206000000014
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=DM_bundi
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=DM_bundi
Time elapsed = 19
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 = 5
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=DM_bundi
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=DM_bundi
Time elapsed = 12
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 5
Result = 5
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 26
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 30
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_reader,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 4
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : trcmf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 7
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 = 10402
hearing_date = 29/10/2024
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 15
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 = 4
RecordId = 15017000008882
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
hearing_date = 29/10/2024
courtcode = 10402
Posting record
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:33
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=29/10/2024 00:00:00
Param Type = c
courtcode=10402
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)
Saving to table TRN_RCMS_HEARING
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008883
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 16
pre_case_purpose = 18473000000000
court_code = 10402
pre_hear_date = 29/10/2024
case_no = 2019/00014
trn_rcms_caseid = 11235000002384
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18473000000000
next_hear_date = 11/11/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=15017000008883
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:33
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
court_code=10402
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = c
case_no=2019/00014
Param Type = c
trn_rcms_caseid=11235000002384
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=11/11/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 = 6
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 = 25
RecordId = 15017000008884
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 29/10/2024
pre_case_purpose = 18473000000000
trn_rcms_caseid = 18608000004716
court_code = 10402
case_no = 2020/00008
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 25/11/2024
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=15017000008884
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:33
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=18608000004716
Param Type = c
court_code=10402
Param Type = c
case_no=2020/00008
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=25/11/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 = 6
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15017000008885
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 29/10/2024
pre_case_purpose = 18473000000000
trn_rcms_caseid = 15090000007055
court_code = 10402
case_no = 2021/102
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 12/11/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=15017000008885
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:34
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=15090000007055
Param Type = c
court_code=10402
Param Type = c
case_no=2021/102
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=12/11/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 = 6
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008886
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 12/11/2024
new_case_purpose = 18473000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2021/103
court_code = 10402
trn_rcms_caseid = 15135000005698
pre_case_purpose = 18473000000000
pre_hear_date = 29/10/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=15017000008886
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:34
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=12/11/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/103
Param Type = c
court_code=10402
Param Type = c
trn_rcms_caseid=15135000005698
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=29/10/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 = 5
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008887
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 27/11/2024
new_case_purpose = 18473000000000
isadjourn = NO
adjourn_type = 0
adjourn_remark =
case_no = 2021/107
court_code = 10402
trn_rcms_caseid = 15274000006115
pre_case_purpose = 18473000000000
pre_hear_date = 29/10/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=15017000008887
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:34
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=27/11/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/107
Param Type = c
court_code=10402
Param Type = c
trn_rcms_caseid=15274000006115
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_type,adjourn_remark,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,:adjourn_type,null,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008888
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_case_purpose = 18473000000000
court_code = 10402
case_no = 2021/145
isadjourn = NO
next_hear_date = 05/11/2024
new_case_purpose = 18473000000000
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 11182000005489
pre_hear_date = 29/10/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=15017000008888
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:34
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
court_code=10402
Param Type = c
case_no=2021/145
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=05/11/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=11182000005489
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,court_code,case_no,isadjourn,next_hear_date,new_case_purpose,adjourn_type,adjourn_remark,trn_rcms_caseid,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:court_code,:case_no,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008889
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
court_code = 10402
case_no = 2021/146
trn_rcms_caseid = 11259000006056
pre_case_purpose = 18473000000000
adjourn_type = 0
isadjourn = NO
next_hear_date = 05/11/2024
pre_hear_date = 29/10/2024
new_case_purpose = 18473000000000
adjourn_remark =
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=15017000008889
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:34
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10402
Param Type = c
case_no=2021/146
Param Type = c
trn_rcms_caseid=11259000006056
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=05/11/2024 00:00:00
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
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,court_code,case_no,trn_rcms_caseid,pre_case_purpose,adjourn_type,isadjourn,next_hear_date,pre_hear_date,new_case_purpose,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:case_no,:trn_rcms_caseid,:pre_case_purpose,:adjourn_type,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008890
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 29/10/2024
pre_case_purpose = 18473000000000
trn_rcms_caseid = 10375000007665
court_code = 10402
case_no = 2022/274
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 26/11/2024
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=15017000008890
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:34
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=10375000007665
Param Type = c
court_code=10402
Param Type = c
case_no=2022/274
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=26/11/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 = 6
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008891
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 29/10/2024
pre_case_purpose = 18473000000000
trn_rcms_caseid = 12435000007187
court_code = 10402
case_no = 2023/15
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 11/11/2024
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=15017000008891
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:34
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=12435000007187
Param Type = c
court_code=10402
Param Type = c
case_no=2023/15
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=11/11/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008892
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 27
next_hear_date = 11/11/2024
new_case_purpose = 18473000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/206
court_code = 10402
trn_rcms_caseid = 11598000009246
pre_case_purpose = 18473000000000
pre_hear_date = 29/10/2024
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=15017000008892
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:34
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/11/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/206
Param Type = c
court_code=10402
Param Type = c
trn_rcms_caseid=11598000009246
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15017000008893
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
new_case_purpose = 18473000000000
next_hear_date = 19/11/2024
trn_rcms_caseid = 14637000007555
pre_hear_date = 29/10/2024
pre_case_purpose = 18473000000000
case_no = 2023/214
court_code = 10402
adjourn_remark =
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=15017000008893
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:34
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
trn_rcms_caseid=14637000007555
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
case_no=2023/214
Param Type = c
court_code=10402
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,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 = 6
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008894
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 03/12/2024
new_case_purpose = 18473000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/225
court_code = 10402
trn_rcms_caseid = 18190000008164
pre_case_purpose = 18473000000000
pre_hear_date = 29/10/2024
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=15017000008894
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:34
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=03/12/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/225
Param Type = c
court_code=10402
Param Type = c
trn_rcms_caseid=18190000008164
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008895
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trn_rcms_caseid = 19630000006989
adjourn_remark =
isadjourn = NO
next_hear_date = 26/11/2024
case_no = 2023/66
court_code = 10402
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
pre_hear_date = 29/10/2024
adjourn_type = 0
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=15017000008895
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:35
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=19630000006989
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=26/11/2024 00:00:00
Param Type = c
case_no=2023/66
Param Type = c
court_code=10402
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = c
adjourn_type=0
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,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 = 6
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008896
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
trn_rcms_caseid = 10578000007507
pre_hear_date = 29/10/2024
court_code = 10402
case_no = 2023/67
pre_case_purpose = 18473000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18473000000000
next_hear_date = 26/11/2024
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=15017000008896
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:35
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=10578000007507
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = c
court_code=10402
Param Type = c
case_no=2023/67
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=26/11/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 = 7
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008897
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
trn_rcms_caseid = 11559000002809
pre_hear_date = 29/10/2024
court_code = 10402
case_no = 2019/00067
pre_case_purpose = 12555000000002
isadjourn = NO
adjourn_type = 0
new_case_purpose = 12555000000002
next_hear_date = 25/11/2024
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=15017000008897
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:35
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=11559000002809
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = c
court_code=10402
Param Type = c
case_no=2019/00067
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=12555000000002
Param Type = c
next_hear_date=25/11/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,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 = 6
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008898
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
adjourn_type = 0
pre_case_purpose = 12555000000002
pre_hear_date = 29/10/2024
new_case_purpose = 12555000000002
next_hear_date = 26/11/2024
court_code = 10402
isadjourn = NO
trn_rcms_caseid = 18593000008469
case_no = 2023/227
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=15017000008898
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:35
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = c
next_hear_date=26/11/2024 00:00:00
Param Type = c
court_code=10402
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=18593000008469
Param Type = c
case_no=2023/227
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_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 = 5
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 15017000008899
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 15808000008996
pre_hear_date = 29/10/2024
court_code = 10402
case_no = 2024/4
next_hear_date = 10/12/2024
isadjourn = NO
pre_case_purpose = 12555000000002
new_case_purpose = 12555000000002
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=15017000008899
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:35
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=15808000008996
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = c
court_code=10402
Param Type = c
case_no=2024/4
Param Type = c
next_hear_date=10/12/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
new_case_purpose=12555000000002
Param Type = n
trn_rcms_hearingrow=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,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 = 6
Adding new record to store data from Frame 2, Row 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 15017000008900
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark =
isadjourn = NO
case_no = 2024/59
trn_rcms_caseid = 13552000007841
pre_case_purpose = 12555000000002
court_code = 10402
next_hear_date = 19/11/2024
new_case_purpose = 18473000000000
pre_hear_date = 29/10/2024
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=15017000008900
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:35
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:35
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=2024/59
Param Type = c
trn_rcms_caseid=13552000007841
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
court_code=10402
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 26
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008901
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 16262000003968
case_no = 2019/00271
court_code = 10402
pre_hear_date = 29/10/2024
next_hear_date = 19/11/2024
new_case_purpose = 12555000000002
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=15017000008901
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:35
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:35
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=16262000003968
Param Type = c
case_no=2019/00271
Param Type = c
court_code=10402
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = n
pre_case_purpose=18678000000000
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_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 = 4
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008902
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 26
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 25/11/2024
trn_rcms_caseid = 18578000003974
case_no = 2020/00027
court_code = 10402
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 29/10/2024
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=15017000008902
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:35
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:35
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=25/11/2024 00:00:00
Param Type = c
trn_rcms_caseid=18578000003974
Param Type = c
case_no=2020/00027
Param Type = c
court_code=10402
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=29/10/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,isadjourn,adjourn_remark,adjourn_type,next_hear_date,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15017000008903
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 10/12/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 18553000006406
court_code = 10402
case_no = 2023/62
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 29/10/2024
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=15017000008903
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:36
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=10/12/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18553000006406
Param Type = c
court_code=10402
Param Type = c
case_no=2023/62
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=29/10/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,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 = 5
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 14
RecordId = 15017000008904
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 05/11/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 10033000000815
case_no = 2024/159
court_code = 10402
trn_rcms_caseid = 15422000008341
pre_case_purpose = 18678000000000
pre_hear_date = 29/10/2024
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=15017000008904
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:36
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/11/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=10033000000815
Param Type = c
case_no=2024/159
Param Type = c
court_code=10402
Param Type = c
trn_rcms_caseid=15422000008341
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=29/10/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,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008905
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 208
next_hear_date = 05/11/2024
new_case_purpose = 10033000000815
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2024/160
court_code = 10402
trn_rcms_caseid = 15461000009324
pre_case_purpose = 18678000000000
pre_hear_date = 29/10/2024
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=15017000008905
Param Type = n
trn_rcms_mhearingid=15017000008882
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:36
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/11/2024 00:00:00
Param Type = c
new_case_purpose=10033000000815
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/160
Param Type = c
court_code=10402
Param Type = c
trn_rcms_caseid=15461000009324
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=29/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,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 = 3939375876476
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11235000002384 idvalue 0
Mapped case_no Row = 1 value = 2019/00014 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/11/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 = 10402
trn_rcms_caseregid = 11235000002384
case_no = 2019/00014
prev_hearing_date = 29/10/2024
hearing_date = 11/11/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purposename=???
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???
Time elapsed = 7
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008906
MapName trcmf1
SourceId 15017000008883
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 11/11/2024
case_no = 2019/00014
trn_rcms_caseregid = 11235000002384
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008906
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008883
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:36
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04: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=18473000000000
Param Type = c
hearing_date=11/11/2024 00:00:00
Param Type = c
case_no=2019/00014
Param Type = c
trn_rcms_caseregid=11235000002384
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18608000004716 idvalue 0
Mapped case_no Row = 1 value = 2020/00008 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 25/11/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 = 10402
trn_rcms_caseregid = 18608000004716
case_no = 2020/00008
prev_hearing_date = 29/10/2024
hearing_date = 25/11/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15017000008907
MapName trcmf1
SourceId 15017000008884
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 25/11/2024
case_no = 2020/00008
trn_rcms_caseregid = 18608000004716
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008907
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008884
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:39
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=25/11/2024 00:00:00
Param Type = c
case_no=2020/00008
Param Type = c
trn_rcms_caseregid=18608000004716
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15090000007055 idvalue 0
Mapped case_no Row = 1 value = 2021/102 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 12/11/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 = 10402
trn_rcms_caseregid = 15090000007055
case_no = 2021/102
prev_hearing_date = 29/10/2024
hearing_date = 12/11/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15017000008908
MapName trcmf1
SourceId 15017000008885
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 12/11/2024
case_no = 2021/102
trn_rcms_caseregid = 15090000007055
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008908
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008885
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:41
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=12/11/2024 00:00:00
Param Type = c
case_no=2021/102
Param Type = c
trn_rcms_caseregid=15090000007055
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15135000005698 idvalue 0
Mapped case_no Row = 1 value = 2021/103 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 12/11/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 = 10402
trn_rcms_caseregid = 15135000005698
case_no = 2021/103
prev_hearing_date = 29/10/2024
hearing_date = 12/11/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008909
MapName trcmf1
SourceId 15017000008886
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 12/11/2024
case_no = 2021/103
trn_rcms_caseregid = 15135000005698
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008909
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008886
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:43
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=12/11/2024 00:00:00
Param Type = c
case_no=2021/103
Param Type = c
trn_rcms_caseregid=15135000005698
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15274000006115 idvalue 0
Mapped case_no Row = 1 value = 2021/107 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 27/11/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 = 10402
trn_rcms_caseregid = 15274000006115
case_no = 2021/107
prev_hearing_date = 29/10/2024
hearing_date = 27/11/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008910
MapName trcmf1
SourceId 15017000008887
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 27/11/2024
case_no = 2021/107
trn_rcms_caseregid = 15274000006115
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008910
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008887
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:45
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=27/11/2024 00:00:00
Param Type = c
case_no=2021/107
Param Type = c
trn_rcms_caseregid=15274000006115
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11182000005489 idvalue 0
Mapped case_no Row = 1 value = 2021/145 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/11/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 = 10402
trn_rcms_caseregid = 11182000005489
case_no = 2021/145
prev_hearing_date = 29/10/2024
hearing_date = 05/11/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008911
MapName trcmf1
SourceId 15017000008888
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 05/11/2024
case_no = 2021/145
trn_rcms_caseregid = 11182000005489
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008911
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008888
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:47
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=05/11/2024 00:00:00
Param Type = c
case_no=2021/145
Param Type = c
trn_rcms_caseregid=11182000005489
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11259000006056 idvalue 0
Mapped case_no Row = 1 value = 2021/146 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/11/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 = 10402
trn_rcms_caseregid = 11259000006056
case_no = 2021/146
prev_hearing_date = 29/10/2024
hearing_date = 05/11/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008912
MapName trcmf1
SourceId 15017000008889
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 05/11/2024
case_no = 2021/146
trn_rcms_caseregid = 11259000006056
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008912
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008889
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:49
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=05/11/2024 00:00:00
Param Type = c
case_no=2021/146
Param Type = c
trn_rcms_caseregid=11259000006056
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10375000007665 idvalue 0
Mapped case_no Row = 1 value = 2022/274 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 26/11/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 = 10402
trn_rcms_caseregid = 10375000007665
case_no = 2022/274
prev_hearing_date = 29/10/2024
hearing_date = 26/11/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15017000008913
MapName trcmf1
SourceId 15017000008890
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 26/11/2024
case_no = 2022/274
trn_rcms_caseregid = 10375000007665
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008913
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008890
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:51
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=26/11/2024 00:00:00
Param Type = c
case_no=2022/274
Param Type = c
trn_rcms_caseregid=10375000007665
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12435000007187 idvalue 0
Mapped case_no Row = 1 value = 2023/15 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/11/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 = 10402
trn_rcms_caseregid = 12435000007187
case_no = 2023/15
prev_hearing_date = 29/10/2024
hearing_date = 11/11/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008914
MapName trcmf1
SourceId 15017000008891
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 11/11/2024
case_no = 2023/15
trn_rcms_caseregid = 12435000007187
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008914
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008891
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:52
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=11/11/2024 00:00:00
Param Type = c
case_no=2023/15
Param Type = c
trn_rcms_caseregid=12435000007187
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11598000009246 idvalue 0
Mapped case_no Row = 1 value = 2023/206 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/11/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 = 10402
trn_rcms_caseregid = 11598000009246
case_no = 2023/206
prev_hearing_date = 29/10/2024
hearing_date = 11/11/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008915
MapName trcmf1
SourceId 15017000008892
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 11/11/2024
case_no = 2023/206
trn_rcms_caseregid = 11598000009246
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008915
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008892
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:54
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=11/11/2024 00:00:00
Param Type = c
case_no=2023/206
Param Type = c
trn_rcms_caseregid=11598000009246
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14637000007555 idvalue 0
Mapped case_no Row = 1 value = 2023/214 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/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 = 10402
trn_rcms_caseregid = 14637000007555
case_no = 2023/214
prev_hearing_date = 29/10/2024
hearing_date = 19/11/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008916
MapName trcmf1
SourceId 15017000008893
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 19/11/2024
case_no = 2023/214
trn_rcms_caseregid = 14637000007555
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008916
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008893
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:56
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/214
Param Type = c
trn_rcms_caseregid=14637000007555
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18190000008164 idvalue 0
Mapped case_no Row = 1 value = 2023/225 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 03/12/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 = 10402
trn_rcms_caseregid = 18190000008164
case_no = 2023/225
prev_hearing_date = 29/10/2024
hearing_date = 03/12/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008917
MapName trcmf1
SourceId 15017000008894
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 03/12/2024
case_no = 2023/225
trn_rcms_caseregid = 18190000008164
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008917
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008894
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:04:58
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:04:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=03/12/2024 00:00:00
Param Type = c
case_no=2023/225
Param Type = c
trn_rcms_caseregid=18190000008164
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19630000006989 idvalue 0
Mapped case_no Row = 1 value = 2023/66 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 26/11/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 = 10402
trn_rcms_caseregid = 19630000006989
case_no = 2023/66
prev_hearing_date = 29/10/2024
hearing_date = 26/11/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 15017000008918
MapName trcmf1
SourceId 15017000008895
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 26/11/2024
case_no = 2023/66
trn_rcms_caseregid = 19630000006989
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008918
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008895
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:05:00
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:05:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=26/11/2024 00:00:00
Param Type = c
case_no=2023/66
Param Type = c
trn_rcms_caseregid=19630000006989
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10578000007507 idvalue 0
Mapped case_no Row = 1 value = 2023/67 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 26/11/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 = 10402
trn_rcms_caseregid = 10578000007507
case_no = 2023/67
prev_hearing_date = 29/10/2024
hearing_date = 26/11/2024
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008919
MapName trcmf1
SourceId 15017000008896
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 26
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 26/11/2024
case_no = 2023/67
trn_rcms_caseregid = 10578000007507
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008919
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008896
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:05:02
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:05:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=26/11/2024 00:00:00
Param Type = c
case_no=2023/67
Param Type = c
trn_rcms_caseregid=10578000007507
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11559000002809 idvalue 0
Mapped case_no Row = 1 value = 2019/00067 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 25/11/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 = 10402
trn_rcms_caseregid = 11559000002809
case_no = 2019/00067
prev_hearing_date = 29/10/2024
hearing_date = 25/11/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purposename=???? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????????? ????
Time elapsed = 7
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 25
RecordId = 15017000008920
MapName trcmf1
SourceId 15017000008897
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 25/11/2024
case_no = 2019/00067
trn_rcms_caseregid = 11559000002809
court_code = 10402
case_purpose = 12555000000002
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008920
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008897
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:05:04
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:05:04
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=25/11/2024 00:00:00
Param Type = c
case_no=2019/00067
Param Type = c
trn_rcms_caseregid=11559000002809
Param Type = c
court_code=10402
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18593000008469 idvalue 0
Mapped case_no Row = 1 value = 2023/227 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 26/11/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 = 10402
trn_rcms_caseregid = 18593000008469
case_no = 2023/227
prev_hearing_date = 29/10/2024
hearing_date = 26/11/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15017000008921
MapName trcmf1
SourceId 15017000008898
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 26/11/2024
case_no = 2023/227
trn_rcms_caseregid = 18593000008469
court_code = 10402
case_purpose = 12555000000002
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008921
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008898
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:05:06
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:05:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=26/11/2024 00:00:00
Param Type = c
case_no=2023/227
Param Type = c
trn_rcms_caseregid=18593000008469
Param Type = c
court_code=10402
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15808000008996 idvalue 0
Mapped case_no Row = 1 value = 2024/4 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/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 = 10402
trn_rcms_caseregid = 15808000008996
case_no = 2024/4
prev_hearing_date = 29/10/2024
hearing_date = 10/12/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008922
MapName trcmf1
SourceId 15017000008899
Select sysdate as sdt from dual
Time elapsed = 28
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 10/12/2024
case_no = 2024/4
trn_rcms_caseregid = 15808000008996
court_code = 10402
case_purpose = 12555000000002
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008922
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008899
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:05:07
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:05:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/4
Param Type = c
trn_rcms_caseregid=15808000008996
Param Type = c
court_code=10402
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13552000007841 idvalue 0
Mapped case_no Row = 1 value = 2024/59 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/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 = 10402
trn_rcms_caseregid = 13552000007841
case_no = 2024/59
prev_hearing_date = 29/10/2024
hearing_date = 19/11/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 12555000000002
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008923
MapName trcmf1
SourceId 15017000008900
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 25
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 19/11/2024
case_no = 2024/59
trn_rcms_caseregid = 13552000007841
court_code = 10402
case_purpose = 18473000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008923
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008900
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:05:09
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:05:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2024/59
Param Type = c
trn_rcms_caseregid=13552000007841
Param Type = c
court_code=10402
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16262000003968 idvalue 0
Mapped case_no Row = 1 value = 2019/00271 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/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 = 10402
trn_rcms_caseregid = 16262000003968
case_no = 2019/00271
prev_hearing_date = 29/10/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 7
prev_case_purpose after validation = 18678000000000
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008924
MapName trcmf1
SourceId 15017000008901
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2019/00271
trn_rcms_caseregid = 16262000003968
court_code = 10402
case_purpose = 12555000000002
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008924
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008901
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:05:11
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:05:11
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2019/00271
Param Type = c
trn_rcms_caseregid=16262000003968
Param Type = c
court_code=10402
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18578000003974 idvalue 0
Mapped case_no Row = 1 value = 2020/00027 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 25/11/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 = 10402
trn_rcms_caseregid = 18578000003974
case_no = 2020/00027
prev_hearing_date = 29/10/2024
hearing_date = 25/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008925
MapName trcmf1
SourceId 15017000008902
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 25/11/2024
case_no = 2020/00027
trn_rcms_caseregid = 18578000003974
court_code = 10402
case_purpose = 18678000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008925
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008902
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:05:13
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:05:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=25/11/2024 00:00:00
Param Type = c
case_no=2020/00027
Param Type = c
trn_rcms_caseregid=18578000003974
Param Type = c
court_code=10402
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18553000006406 idvalue 0
Mapped case_no Row = 1 value = 2023/62 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/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 = 10402
trn_rcms_caseregid = 18553000006406
case_no = 2023/62
prev_hearing_date = 29/10/2024
hearing_date = 10/12/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15017000008926
MapName trcmf1
SourceId 15017000008903
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 10/12/2024
case_no = 2023/62
trn_rcms_caseregid = 18553000006406
court_code = 10402
case_purpose = 18678000000000
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008926
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008903
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:05:15
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:05:15
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2023/62
Param Type = c
trn_rcms_caseregid=18553000006406
Param Type = c
court_code=10402
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=29/10/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 = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15422000008341 idvalue 0
Mapped case_no Row = 1 value = 2024/159 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 10033000000815 idvalue 0
Mapped hearing_date Row = 1 value = 05/11/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 = 10402
trn_rcms_caseregid = 15422000008341
case_no = 2024/159
prev_hearing_date = 29/10/2024
hearing_date = 05/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 10033000000815
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15017000008927
MapName trcmf1
SourceId 15017000008904
Select sysdate as sdt from dual
Time elapsed = 28
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/11/2024
case_no = 2024/159
trn_rcms_caseregid = 15422000008341
court_code = 10402
case_purpose = 10033000000815
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008927
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008904
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:05:17
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:05:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/11/2024 00:00:00
Param Type = c
case_no=2024/159
Param Type = c
trn_rcms_caseregid=15422000008341
Param Type = c
court_code=10402
Param Type = c
case_purpose=10033000000815
Param Type = c
prev_hearing_date=29/10/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 23
>>Mapping
Mapped court_code Row = 1 value = 10402 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15461000009324 idvalue 0
Mapped case_no Row = 1 value = 2024/160 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 10033000000815 idvalue 0
Mapped hearing_date Row = 1 value = 05/11/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 = 10402
trn_rcms_caseregid = 15461000009324
case_no = 2024/160
prev_hearing_date = 29/10/2024
hearing_date = 05/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 10033000000815
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15017000008928
MapName trcmf1
SourceId 15017000008905
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/11/2024
case_no = 2024/160
trn_rcms_caseregid = 15461000009324
court_code = 10402
case_purpose = 10033000000815
prev_hearing_date = 29/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=15017000008928
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15017000008905
Param Type = c
cancel=F
Param Type = c
createdby=DM_bundi
Param Type = c
createdon=29/10/2024 15:05:19
Param Type = c
username=DM_bundi
Param Type = c
modifiedon=29/10/2024 15:05:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/11/2024 00:00:00
Param Type = c
case_no=2024/160
Param Type = c
trn_rcms_caseregid=15461000009324
Param Type = c
court_code=10402
Param Type = c
case_purpose=10033000000815
Param Type = c
prev_hearing_date=29/10/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 = 3939375921397
Time elapsed for MD Map = 3939375921400
Time elapsed for Save History = 3939375921401
Time elapsed for Save Attachment = 3939375921402
Time elapsed for After Save WF Exec = 3939375921405
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"15017000008882"}]}
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=DM_bundi
Param Type = c
calledon=29/10/2024 15:04:32
Param Type = c
callfinished=29/10/2024 15:05:21
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=48787
Param Type = n
dbtimetaken=46079
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