ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
gcmsSDO_Pawta_PRO827ccb0eea8a706c4c34a16891f84e7b![]()
INRF500250000Ffiresql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtname := sqlget({m2},{court_name})firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})m_courttype := sqlget({m3},{court_type})firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})m_courtid := sqlget({m4},{court_name_mastid})firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})login_userid := sqlget({m4},{axusersid})firesql({m4},{select :username as uname from dual})u_name := sqlget({m4},{uname})firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtcode := sqlget({m4},{COURT_CODE})firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})m_statename := sqlget({m2},{STATE_NAME})firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_distName := sqlget({m7},{DISTNAMEENG})firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_courtcatid := sqlget({m8},{COURT_CATEGOTY})firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})m_deptid := sqlget({m4},{department_mastid})firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})m_courttypeid := sqlget({m3},{court_type_mastid})firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })urole := sqlget({m4},{groupname})firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})m_cutoffdt := sqlget({a1},{dd})firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})m_offcount := sqlget({P1},{ct})00000F
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
username=SDO_Pawta_PRO
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Pawta_PRO
Time elapsed = 11
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ????? ???????,?????,????????-??????
Result = ????? ???????,?????,????????-??????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=SDO_Pawta_PRO
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Pawta_PRO
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = SDO
Result = SDO
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=SDO_Pawta_PRO
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Pawta_PRO
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 1863010005726
Result = 1863010005726
Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=SDO_Pawta_PRO
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1791330007708
Result = 1791330007708
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_Pawta_PRO
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_Pawta_PRO
Result = SDO_Pawta_PRO
Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Pawta_PRO
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 18021
Result = 18021
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 = 7
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Pawta_PRO
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Pawta_PRO
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Kotputli-Behrod
Result = Kotputli-Behrod
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Pawta_PRO
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Pawta_PRO
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m8},{COURT_CATEGOTY})
Calling function sqlget
Result of sqlget = 10593000000007
Result = 10593000000007
Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
Calling function firesql
login_userid=1791330007708
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1791330007708
Time elapsed = 11
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=SDO_Pawta_PRO
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10823000000000
Result = 10823000000000
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=SDO_Pawta_PRO
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=SDO_Pawta_PRO
Time elapsed = 11
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_admin
Result = court_admin
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=SDO_Pawta_PRO
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=SDO_Pawta_PRO
Time elapsed = 16
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 2
Result = 2
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_admin') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 9
select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 12
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_admin,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 6
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 = 6
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 = 18021
hearing_date = 02/07/2025
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 2
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 12
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 = 12946000009742
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 14
hearing_date = 02/07/2025
courtcode = 18021
Posting record
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:34
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=02/07/2025 00:00:00
Param Type = c
courtcode=18021
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)
Saving to table TRN_RCMS_HEARING
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12946000009743
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
pre_case_purpose = 19542000000536
court_code = 18021
pre_hear_date = 02/07/2025
case_no = 2021/181
trn_rcms_caseid = 18901000007338
adjourn_remark =
adjourn_type = 0
new_case_purpose = 19542000000536
next_hear_date = 16/07/2025
isadjourn = NO
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=12946000009743
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:34
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
court_code=18021
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = c
case_no=2021/181
Param Type = c
trn_rcms_caseid=18901000007338
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=19542000000536
Param Type = c
next_hear_date=16/07/2025 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 = 5
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12946000009744
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 7
pre_hear_date = 02/07/2025
pre_case_purpose = 19542000000536
trn_rcms_caseid = 18963000007573
court_code = 18021
case_no = 2021/182
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 19542000000536
next_hear_date = 16/07/2025
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=12946000009744
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:34
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
trn_rcms_caseid=18963000007573
Param Type = c
court_code=18021
Param Type = c
case_no=2021/182
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=19542000000536
Param Type = c
next_hear_date=16/07/2025 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 = 12946000009745
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 02/07/2025
pre_case_purpose = 19542000000536
trn_rcms_caseid = 18690000009266
court_code = 18021
case_no = 2021/298
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 19542000000536
next_hear_date = 15/07/2025
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=12946000009745
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:34
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
trn_rcms_caseid=18690000009266
Param Type = c
court_code=18021
Param Type = c
case_no=2021/298
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=19542000000536
Param Type = c
next_hear_date=15/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12946000009746
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 15/07/2025
new_case_purpose = 19542000000536
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2021/299
court_code = 18021
trn_rcms_caseid = 18815000008411
pre_case_purpose = 19542000000536
pre_hear_date = 02/07/2025
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=12946000009746
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:34
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=15/07/2025 00:00:00
Param Type = c
new_case_purpose=19542000000536
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/299
Param Type = c
court_code=18021
Param Type = c
trn_rcms_caseid=18815000008411
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 12946000009747
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 14/07/2025
new_case_purpose = 19542000000536
adjourn_remark =
isadjourn = NO
adjourn_type = 0
case_no = 2023/145
court_code = 18021
trn_rcms_caseid = 17439000009974
pre_case_purpose = 19542000000536
pre_hear_date = 02/07/2025
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=12946000009747
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:34
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=14/07/2025 00:00:00
Param Type = c
new_case_purpose=19542000000536
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/145
Param Type = c
court_code=18021
Param Type = c
trn_rcms_caseid=17439000009974
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_remark,isadjourn,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,null,:isadjourn,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 12946000009748
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 14/07/2025
new_case_purpose = 19542000000536
adjourn_type = 0
isadjourn = NO
pre_case_purpose = 19542000000536
trn_rcms_caseid = 17469000010504
pre_hear_date = 02/07/2025
court_code = 18021
case_no = 2023/146
adjourn_remark =
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=12946000009748
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:34
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=14/07/2025 00:00:00
Param Type = c
new_case_purpose=19542000000536
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
trn_rcms_caseid=17469000010504
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = c
court_code=18021
Param Type = c
case_no=2023/146
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_type,isadjourn,pre_case_purpose,trn_rcms_caseid,pre_hear_date,court_code,case_no,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:isadjourn,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 13
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 = 15
RecordId = 12946000009749
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 19542000000536
next_hear_date = 23/07/2025
court_code = 18021
pre_case_purpose = 19542000000536
case_no = 2023/195
pre_hear_date = 02/07/2025
trn_rcms_caseid = 11948000009933
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=12946000009749
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22: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
new_case_purpose=19542000000536
Param Type = c
next_hear_date=23/07/2025 00:00:00
Param Type = c
court_code=18021
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
case_no=2023/195
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = c
trn_rcms_caseid=11948000009933
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,court_code,pre_case_purpose,case_no,pre_hear_date,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:pre_case_purpose,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 10
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 = 5
RecordId = 12946000009750
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 02/07/2025
pre_case_purpose = 19542000000536
trn_rcms_caseid = 12005000011215
court_code = 18021
case_no = 2023/196
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 19542000000536
next_hear_date = 23/07/2025
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=12946000009750
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
trn_rcms_caseid=12005000011215
Param Type = c
court_code=18021
Param Type = c
case_no=2023/196
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=19542000000536
Param Type = c
next_hear_date=23/07/2025 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 = 5
RecordId = 12946000009751
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 21/07/2025
new_case_purpose = 19542000000536
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/96
court_code = 18021
trn_rcms_caseid = 18769000007730
pre_case_purpose = 19542000000536
pre_hear_date = 02/07/2025
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=12946000009751
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/07/2025 00:00:00
Param Type = c
new_case_purpose=19542000000536
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/96
Param Type = c
court_code=18021
Param Type = c
trn_rcms_caseid=18769000007730
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12946000009752
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
new_case_purpose = 19542000000536
next_hear_date = 21/07/2025
trn_rcms_caseid = 18949000009216
pre_hear_date = 02/07/2025
pre_case_purpose = 19542000000536
case_no = 2023/97
court_code = 18021
adjourn_remark =
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=12946000009752
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=19542000000536
Param Type = c
next_hear_date=21/07/2025 00:00:00
Param Type = c
trn_rcms_caseid=18949000009216
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
case_no=2023/97
Param Type = c
court_code=18021
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,court_code,adjourn_remark,isadjourn,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,null,:isadjourn,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12946000009753
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 14/07/2025
new_case_purpose = 19542000000536
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/100
court_code = 18021
trn_rcms_caseid = 17538000008968
pre_case_purpose = 19542000000536
pre_hear_date = 02/07/2025
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=12946000009753
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=14/07/2025 00:00:00
Param Type = c
new_case_purpose=19542000000536
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/100
Param Type = c
court_code=18021
Param Type = c
trn_rcms_caseid=17538000008968
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 12946000009754
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 14
trn_rcms_caseid = 17557000010573
adjourn_remark =
isadjourn = NO
next_hear_date = 14/07/2025
case_no = 2024/101
court_code = 18021
new_case_purpose = 19542000000536
pre_case_purpose = 19542000000536
pre_hear_date = 02/07/2025
adjourn_type = 0
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=12946000009754
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=17557000010573
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=14/07/2025 00:00:00
Param Type = c
case_no=2024/101
Param Type = c
court_code=18021
Param Type = c
new_case_purpose=19542000000536
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,adjourn_remark,isadjourn,next_hear_date,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,null,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12946000009755
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_remark =
trn_rcms_caseid = 15556000012481
pre_hear_date = 02/07/2025
court_code = 18021
case_no = 2024/112
pre_case_purpose = 19542000000536
isadjourn = NO
adjourn_type = 0
new_case_purpose = 19542000000536
next_hear_date = 01/08/2025
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=12946000009755
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=15556000012481
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = c
court_code=18021
Param Type = c
case_no=2024/112
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=19542000000536
Param Type = c
next_hear_date=01/08/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12946000009756
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_remark =
trn_rcms_caseid = 15579000008478
pre_hear_date = 02/07/2025
court_code = 18021
case_no = 2024/113
pre_case_purpose = 19542000000536
isadjourn = NO
adjourn_type = 0
new_case_purpose = 19542000000536
next_hear_date = 01/08/2025
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=12946000009756
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=15579000008478
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = c
court_code=18021
Param Type = c
case_no=2024/113
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=19542000000536
Param Type = c
next_hear_date=01/08/2025 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 = 5
RecordId = 12946000009757
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 10
adjourn_remark =
adjourn_type = 0
pre_case_purpose = 19542000000536
pre_hear_date = 02/07/2025
new_case_purpose = 19542000000536
next_hear_date = 22/07/2025
court_code = 18021
isadjourn = NO
trn_rcms_caseid = 14704000010264
case_no = 2024/129
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=12946000009757
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22: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=19542000000536
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = c
new_case_purpose=19542000000536
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = c
court_code=18021
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=14704000010264
Param Type = c
case_no=2024/129
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,pre_case_purpose,pre_hear_date,new_case_purpose,next_hear_date,court_code,isadjourn,trn_rcms_caseid,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:isadjourn,:trn_rcms_caseid,:case_no,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12946000009758
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 7
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 14812000008410
pre_hear_date = 02/07/2025
court_code = 18021
case_no = 2024/130
next_hear_date = 22/07/2025
isadjourn = NO
pre_case_purpose = 19542000000536
new_case_purpose = 19542000000536
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=12946000009758
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22: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=14812000008410
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = c
court_code=18021
Param Type = c
case_no=2024/130
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
new_case_purpose=19542000000536
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 12946000009759
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 =
isadjourn = NO
case_no = 2024/147
trn_rcms_caseid = 18965000010733
pre_case_purpose = 19542000000536
court_code = 18021
next_hear_date = 03/07/2025
new_case_purpose = 19542000000536
pre_hear_date = 02/07/2025
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=12946000009759
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22: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/147
Param Type = c
trn_rcms_caseid=18965000010733
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
court_code=18021
Param Type = c
next_hear_date=03/07/2025 00:00:00
Param Type = c
new_case_purpose=19542000000536
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,case_no,trn_rcms_caseid,pre_case_purpose,court_code,next_hear_date,new_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:case_no,:trn_rcms_caseid,:pre_case_purpose,:court_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 8
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 = 4
RecordId = 12946000009760
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 19084000010340
case_no = 2024/148
court_code = 18021
pre_hear_date = 02/07/2025
next_hear_date = 03/07/2025
new_case_purpose = 19542000000536
pre_case_purpose = 19542000000536
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=12946000009760
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22: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=19084000010340
Param Type = c
case_no=2024/148
Param Type = c
court_code=18021
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = c
next_hear_date=03/07/2025 00:00:00
Param Type = c
new_case_purpose=19542000000536
Param Type = n
pre_case_purpose=19542000000536
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12946000009761
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 14
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 18/07/2025
trn_rcms_caseid = 16073000009745
case_no = 2024/266
court_code = 18021
new_case_purpose = 19542000000536
pre_case_purpose = 19542000000536
pre_hear_date = 02/07/2025
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=12946000009761
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22: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=18/07/2025 00:00:00
Param Type = c
trn_rcms_caseid=16073000009745
Param Type = c
case_no=2024/266
Param Type = c
court_code=18021
Param Type = c
new_case_purpose=19542000000536
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 8
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 = 12946000009762
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 25
next_hear_date = 18/07/2025
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 16124000010144
court_code = 18021
case_no = 2024/267
new_case_purpose = 19542000000536
pre_case_purpose = 19542000000536
pre_hear_date = 02/07/2025
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=12946000009762
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=18/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=16124000010144
Param Type = c
court_code=18021
Param Type = c
case_no=2024/267
Param Type = c
new_case_purpose=19542000000536
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,court_code,case_no,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:court_code,:case_no,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12946000009763
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 23/07/2025
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 19542000000536
case_no = 2024/27
court_code = 18021
trn_rcms_caseid = 11935000009172
pre_case_purpose = 19542000000536
pre_hear_date = 02/07/2025
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=12946000009763
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:35
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=23/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=19542000000536
Param Type = c
case_no=2024/27
Param Type = c
court_code=18021
Param Type = c
trn_rcms_caseid=11935000009172
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 3
RecordId = 12946000009764
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 23/07/2025
new_case_purpose = 19542000000536
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2024/28
court_code = 18021
trn_rcms_caseid = 11959000009863
pre_case_purpose = 19542000000536
pre_hear_date = 02/07/2025
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=12946000009764
Param Type = n
trn_rcms_mhearingid=12946000009742
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:36
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=23/07/2025 00:00:00
Param Type = c
new_case_purpose=19542000000536
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/28
Param Type = c
court_code=18021
Param Type = c
trn_rcms_caseid=11959000009863
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
pre_hear_date=02/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3960789766172
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18901000007338 idvalue 0
Mapped case_no Row = 1 value = 2021/181 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 16/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 18901000007338
case_no = 2021/181
prev_hearing_date = 02/07/2025
hearing_date = 16/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purposename=??? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??? ????????? ????
Time elapsed = 6
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12946000009765
MapName trcmf1
SourceId 12946000009743
Select sysdate as sdt from dual
Time elapsed = 21
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 = 19542000000536
hearing_date = 16/07/2025
case_no = 2021/181
trn_rcms_caseregid = 18901000007338
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009765
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009743
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:36
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22: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=19542000000536
Param Type = c
hearing_date=16/07/2025 00:00:00
Param Type = c
case_no=2021/181
Param Type = c
trn_rcms_caseregid=18901000007338
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18963000007573 idvalue 0
Mapped case_no Row = 1 value = 2021/182 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 16/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 18963000007573
case_no = 2021/182
prev_hearing_date = 02/07/2025
hearing_date = 16/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 8
RecordId = 12946000009766
MapName trcmf1
SourceId 12946000009744
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 = 19542000000536
hearing_date = 16/07/2025
case_no = 2021/182
trn_rcms_caseregid = 18963000007573
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009766
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009744
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:41
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22: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=19542000000536
Param Type = c
hearing_date=16/07/2025 00:00:00
Param Type = c
case_no=2021/182
Param Type = c
trn_rcms_caseregid=18963000007573
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18690000009266 idvalue 0
Mapped case_no Row = 1 value = 2021/298 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 15/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 18690000009266
case_no = 2021/298
prev_hearing_date = 02/07/2025
hearing_date = 15/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
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 = 12946000009767
MapName trcmf1
SourceId 12946000009745
Select sysdate as sdt from dual
Time elapsed = 7
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 = 19542000000536
hearing_date = 15/07/2025
case_no = 2021/298
trn_rcms_caseregid = 18690000009266
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009767
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009745
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:46
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=15/07/2025 00:00:00
Param Type = c
case_no=2021/298
Param Type = c
trn_rcms_caseregid=18690000009266
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18815000008411 idvalue 0
Mapped case_no Row = 1 value = 2021/299 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 15/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 18815000008411
case_no = 2021/299
prev_hearing_date = 02/07/2025
hearing_date = 15/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12946000009768
MapName trcmf1
SourceId 12946000009746
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 = 19542000000536
hearing_date = 15/07/2025
case_no = 2021/299
trn_rcms_caseregid = 18815000008411
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009768
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009746
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:50
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=15/07/2025 00:00:00
Param Type = c
case_no=2021/299
Param Type = c
trn_rcms_caseregid=18815000008411
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17439000009974 idvalue 0
Mapped case_no Row = 1 value = 2023/145 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 14/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 17439000009974
case_no = 2023/145
prev_hearing_date = 02/07/2025
hearing_date = 14/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12946000009769
MapName trcmf1
SourceId 12946000009747
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 = 19542000000536
hearing_date = 14/07/2025
case_no = 2023/145
trn_rcms_caseregid = 17439000009974
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009769
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009747
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:54
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22: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=19542000000536
Param Type = c
hearing_date=14/07/2025 00:00:00
Param Type = c
case_no=2023/145
Param Type = c
trn_rcms_caseregid=17439000009974
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17469000010504 idvalue 0
Mapped case_no Row = 1 value = 2023/146 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 14/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 17469000010504
case_no = 2023/146
prev_hearing_date = 02/07/2025
hearing_date = 14/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 15
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 12946000009770
MapName trcmf1
SourceId 12946000009748
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 10
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 14/07/2025
case_no = 2023/146
trn_rcms_caseregid = 17469000010504
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009770
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009748
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:22:59
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:22:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=14/07/2025 00:00:00
Param Type = c
case_no=2023/146
Param Type = c
trn_rcms_caseregid=17469000010504
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11948000009933 idvalue 0
Mapped case_no Row = 1 value = 2023/195 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 23/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 11948000009933
case_no = 2023/195
prev_hearing_date = 02/07/2025
hearing_date = 23/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 10
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 = 12946000009771
MapName trcmf1
SourceId 12946000009749
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 23/07/2025
case_no = 2023/195
trn_rcms_caseregid = 11948000009933
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009771
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009749
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:23:03
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:23:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=23/07/2025 00:00:00
Param Type = c
case_no=2023/195
Param Type = c
trn_rcms_caseregid=11948000009933
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12005000011215 idvalue 0
Mapped case_no Row = 1 value = 2023/196 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 23/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 12005000011215
case_no = 2023/196
prev_hearing_date = 02/07/2025
hearing_date = 23/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 6
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 = 7
RecordId = 12946000009772
MapName trcmf1
SourceId 12946000009750
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 13
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 23/07/2025
case_no = 2023/196
trn_rcms_caseregid = 12005000011215
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009772
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009750
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:23:07
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:23: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=19542000000536
Param Type = c
hearing_date=23/07/2025 00:00:00
Param Type = c
case_no=2023/196
Param Type = c
trn_rcms_caseregid=12005000011215
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18769000007730 idvalue 0
Mapped case_no Row = 1 value = 2023/96 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 21/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 18769000007730
case_no = 2023/96
prev_hearing_date = 02/07/2025
hearing_date = 21/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 9
RecordId = 12946000009773
MapName trcmf1
SourceId 12946000009751
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 = 19542000000536
hearing_date = 21/07/2025
case_no = 2023/96
trn_rcms_caseregid = 18769000007730
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009773
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009751
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:23:11
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:23: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=19542000000536
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2023/96
Param Type = c
trn_rcms_caseregid=18769000007730
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18949000009216 idvalue 0
Mapped case_no Row = 1 value = 2023/97 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 21/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 18949000009216
case_no = 2023/97
prev_hearing_date = 02/07/2025
hearing_date = 21/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12946000009774
MapName trcmf1
SourceId 12946000009752
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 21/07/2025
case_no = 2023/97
trn_rcms_caseregid = 18949000009216
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009774
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009752
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:23:15
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:23: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=19542000000536
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2023/97
Param Type = c
trn_rcms_caseregid=18949000009216
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17538000008968 idvalue 0
Mapped case_no Row = 1 value = 2024/100 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 14/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 17538000008968
case_no = 2024/100
prev_hearing_date = 02/07/2025
hearing_date = 14/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 15
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 12
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 = 12946000009775
MapName trcmf1
SourceId 12946000009753
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 = 19542000000536
hearing_date = 14/07/2025
case_no = 2024/100
trn_rcms_caseregid = 17538000008968
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009775
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009753
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:23:19
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:23: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=19542000000536
Param Type = c
hearing_date=14/07/2025 00:00:00
Param Type = c
case_no=2024/100
Param Type = c
trn_rcms_caseregid=17538000008968
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17557000010573 idvalue 0
Mapped case_no Row = 1 value = 2024/101 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 14/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 17557000010573
case_no = 2024/101
prev_hearing_date = 02/07/2025
hearing_date = 14/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12946000009776
MapName trcmf1
SourceId 12946000009754
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 = 19542000000536
hearing_date = 14/07/2025
case_no = 2024/101
trn_rcms_caseregid = 17557000010573
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009776
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009754
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:23:24
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:23:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=14/07/2025 00:00:00
Param Type = c
case_no=2024/101
Param Type = c
trn_rcms_caseregid=17557000010573
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15556000012481 idvalue 0
Mapped case_no Row = 1 value = 2024/112 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 01/08/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 15556000012481
case_no = 2024/112
prev_hearing_date = 02/07/2025
hearing_date = 01/08/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12946000009777
MapName trcmf1
SourceId 12946000009755
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 01/08/2025
case_no = 2024/112
trn_rcms_caseregid = 15556000012481
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009777
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009755
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:23:28
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:23:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=01/08/2025 00:00:00
Param Type = c
case_no=2024/112
Param Type = c
trn_rcms_caseregid=15556000012481
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15579000008478 idvalue 0
Mapped case_no Row = 1 value = 2024/113 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 01/08/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 15579000008478
case_no = 2024/113
prev_hearing_date = 02/07/2025
hearing_date = 01/08/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
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 = 12946000009778
MapName trcmf1
SourceId 12946000009756
Select sysdate as sdt from dual
Time elapsed = 5
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 = 19542000000536
hearing_date = 01/08/2025
case_no = 2024/113
trn_rcms_caseregid = 15579000008478
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009778
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009756
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:23:33
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:23:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=01/08/2025 00:00:00
Param Type = c
case_no=2024/113
Param Type = c
trn_rcms_caseregid=15579000008478
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14704000010264 idvalue 0
Mapped case_no Row = 1 value = 2024/129 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 14704000010264
case_no = 2024/129
prev_hearing_date = 02/07/2025
hearing_date = 22/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 7
RecordId = 12946000009779
MapName trcmf1
SourceId 12946000009757
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 22/07/2025
case_no = 2024/129
trn_rcms_caseregid = 14704000010264
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009779
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009757
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:23:38
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:23:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2024/129
Param Type = c
trn_rcms_caseregid=14704000010264
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14812000008410 idvalue 0
Mapped case_no Row = 1 value = 2024/130 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 14812000008410
case_no = 2024/130
prev_hearing_date = 02/07/2025
hearing_date = 22/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 12946000009780
MapName trcmf1
SourceId 12946000009758
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 22/07/2025
case_no = 2024/130
trn_rcms_caseregid = 14812000008410
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009780
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009758
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:23:43
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:23: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=19542000000536
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2024/130
Param Type = c
trn_rcms_caseregid=14812000008410
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18965000010733 idvalue 0
Mapped case_no Row = 1 value = 2024/147 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 03/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 18965000010733
case_no = 2024/147
prev_hearing_date = 02/07/2025
hearing_date = 03/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 18
RecordId = 12946000009781
MapName trcmf1
SourceId 12946000009759
Select sysdate as sdt from dual
Time elapsed = 12
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 = 19542000000536
hearing_date = 03/07/2025
case_no = 2024/147
trn_rcms_caseregid = 18965000010733
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009781
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009759
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:23:48
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:23:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=03/07/2025 00:00:00
Param Type = c
case_no=2024/147
Param Type = c
trn_rcms_caseregid=18965000010733
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19084000010340 idvalue 0
Mapped case_no Row = 1 value = 2024/148 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 03/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 19084000010340
case_no = 2024/148
prev_hearing_date = 02/07/2025
hearing_date = 03/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 12
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 = 7
RecordId = 12946000009782
MapName trcmf1
SourceId 12946000009760
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 03/07/2025
case_no = 2024/148
trn_rcms_caseregid = 19084000010340
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009782
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009760
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:23:53
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:23:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=03/07/2025 00:00:00
Param Type = c
case_no=2024/148
Param Type = c
trn_rcms_caseregid=19084000010340
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16073000009745 idvalue 0
Mapped case_no Row = 1 value = 2024/266 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 18/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 16073000009745
case_no = 2024/266
prev_hearing_date = 02/07/2025
hearing_date = 18/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 10
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 = 12946000009783
MapName trcmf1
SourceId 12946000009761
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 13
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 18/07/2025
case_no = 2024/266
trn_rcms_caseregid = 16073000009745
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009783
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009761
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:23:57
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:23:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=18/07/2025 00:00:00
Param Type = c
case_no=2024/266
Param Type = c
trn_rcms_caseregid=16073000009745
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16124000010144 idvalue 0
Mapped case_no Row = 1 value = 2024/267 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 18/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 16124000010144
case_no = 2024/267
prev_hearing_date = 02/07/2025
hearing_date = 18/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12946000009784
MapName trcmf1
SourceId 12946000009762
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 18/07/2025
case_no = 2024/267
trn_rcms_caseregid = 16124000010144
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009784
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009762
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:24:02
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:24:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=18/07/2025 00:00:00
Param Type = c
case_no=2024/267
Param Type = c
trn_rcms_caseregid=16124000010144
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11935000009172 idvalue 0
Mapped case_no Row = 1 value = 2024/27 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 23/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 11935000009172
case_no = 2024/27
prev_hearing_date = 02/07/2025
hearing_date = 23/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12946000009785
MapName trcmf1
SourceId 12946000009763
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 = 19542000000536
hearing_date = 23/07/2025
case_no = 2024/27
trn_rcms_caseregid = 11935000009172
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009785
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009763
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:24:07
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:24: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=19542000000536
Param Type = c
hearing_date=23/07/2025 00:00:00
Param Type = c
case_no=2024/27
Param Type = c
trn_rcms_caseregid=11935000009172
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 18021 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11959000009863 idvalue 0
Mapped case_no Row = 1 value = 2024/28 idvalue 0
Mapped prev_hearing_date Row = 1 value = 02/07/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 23/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18021
trn_rcms_caseregid = 11959000009863
case_no = 2024/28
prev_hearing_date = 02/07/2025
hearing_date = 23/07/2025
prev_case_purposename = ??? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 12946000009786
MapName trcmf1
SourceId 12946000009764
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 = 19542000000536
hearing_date = 23/07/2025
case_no = 2024/28
trn_rcms_caseregid = 11959000009863
court_code = 18021
case_purpose = 19542000000536
prev_hearing_date = 02/07/2025
Posting record
Param Type = n
trn_rcms_case_histid=12946000009786
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12946000009764
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Pawta_PRO
Param Type = c
createdon=04/07/2025 11:24:12
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
modifiedon=04/07/2025 11:24:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=23/07/2025 00:00:00
Param Type = c
case_no=2024/28
Param Type = c
trn_rcms_caseregid=11959000009863
Param Type = c
court_code=18021
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=02/07/2025 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 = 3960789867267
Time elapsed for MD Map = 3960789867268
Time elapsed for Save History = 3960789867269
Time elapsed for Save Attachment = 3960789867269
Time elapsed for After Save WF Exec = 3960789867272
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"12946000009742"}]}
Savedata webservice completed
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=SDO_Pawta_PRO
Param Type = c
calledon=04/07/2025 11:22:43
Param Type = c
callfinished=04/07/2025 11:24:27
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=103332
Param Type = n
dbtimetaken=101969
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