ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
gcmsACEM_Behroad_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=ACEM_Behroad_PRO
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=ACEM_Behroad_PRO
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ????? ???????,?????,????????-??????
Result = ????? ???????,?????,????????-??????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=ACEM_Behroad_PRO
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=ACEM_Behroad_PRO
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = ACEM
Result = ACEM
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=ACEM_Behroad_PRO
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=ACEM_Behroad_PRO
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 18156000000039
Result = 18156000000039
Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=ACEM_Behroad_PRO
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1860990010033
Result = 1860990010033
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=ACEM_Behroad_PRO
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = ACEM_Behroad_PRO
Result = ACEM_Behroad_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=ACEM_Behroad_PRO
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10721
Result = 10721
Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=ACEM_Behroad_PRO
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ACEM_Behroad_PRO
Time elapsed = 5
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=ACEM_Behroad_PRO
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ACEM_Behroad_PRO
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m8},{COURT_CATEGOTY})
Calling function sqlget
Result of sqlget = 10593000000007
Result = 10593000000007
Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
Calling function firesql
login_userid=1860990010033
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1860990010033
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=ACEM_Behroad_PRO
Time elapsed = 15
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10257000000001
Result = 10257000000001
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=ACEM_Behroad_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=ACEM_Behroad_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 = 4
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=ACEM_Behroad_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=ACEM_Behroad_PRO
Time elapsed = 14
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 9
Result = 9
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 = 3
select Props from axuseraccess where lower(rname)='court_admin' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 7
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_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 = 3
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 = 4
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 = 10721
hearing_date = 21/05/2025
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 3
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010719
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
hearing_date = 21/05/2025
courtcode = 10721
Posting record
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=21/05/2025 00:00:00
Param Type = c
courtcode=10721
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 = 16
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 = 5
RecordId = 13389000010720
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
new_case_purpose = 11415000000002
next_hear_date = 21/07/2025
adjourn_type = 0
adjourn_remark =
isadjourn = NO
case_no = 2024/203
court_code = 10721
trn_rcms_caseid = 16433000008311
pre_case_purpose = 11415000000002
pre_hear_date = 21/05/2025
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=13389000010720
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=11415000000002
Param Type = c
next_hear_date=21/07/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/203
Param Type = c
court_code=10721
Param Type = c
trn_rcms_caseid=16433000008311
Param Type = n
pre_case_purpose=11415000000002
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,next_hear_date,adjourn_type,adjourn_remark,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,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,null,:isadjourn,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010721
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 21/07/2025
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2021/135
court_code = 10721
trn_rcms_caseid = 14393000006252
pre_case_purpose = 1000492
pre_hear_date = 21/05/2025
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=13389000010721
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
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=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/135
Param Type = c
court_code=10721
Param Type = c
trn_rcms_caseid=14393000006252
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/05/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,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010722
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 21/05/2025
pre_case_purpose = 1000492
trn_rcms_caseid = 14592000005446
court_code = 10721
case_no = 2021/46
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 09/06/2025
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=13389000010722
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=14592000005446
Param Type = c
court_code=10721
Param Type = c
case_no=2021/46
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=09/06/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 = 4
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010723
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 21/05/2025
pre_case_purpose = 1000492
trn_rcms_caseid = 13300000007103
court_code = 10721
case_no = 2022/219
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 25/06/2025
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=13389000010723
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=13300000007103
Param Type = c
court_code=10721
Param Type = c
case_no=2022/219
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=25/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 3
RecordId = 13389000010724
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 25/06/2025
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/88
court_code = 10721
trn_rcms_caseid = 10237000007215
pre_case_purpose = 1000492
pre_hear_date = 21/05/2025
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=13389000010724
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=25/06/2025 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/88
Param Type = c
court_code=10721
Param Type = c
trn_rcms_caseid=10237000007215
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/05/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,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010725
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 21/05/2025
pre_case_purpose = 18473000000000
trn_rcms_caseid = 19252000001401
court_code = 10721
case_no = 2017/00140
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 25/06/2025
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=13389000010725
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=19252000001401
Param Type = c
court_code=10721
Param Type = c
case_no=2017/00140
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=25/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010726
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 04/06/2025
isadjourn = NO
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
pre_hear_date = 21/05/2025
case_no = 2018/00125
court_code = 10721
trn_rcms_caseid = 14269000002764
adjourn_type = 0
adjourn_remark =
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=13389000010726
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=04/06/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = c
case_no=2018/00125
Param Type = c
court_code=10721
Param Type = c
trn_rcms_caseid=14269000002764
Param Type = c
adjourn_type=0
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,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_type,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'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:adjourn_type,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010727
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 21/05/2025
trn_rcms_caseid = 19756000009203
pre_case_purpose = 1000497
next_hear_date = 04/06/2025
new_case_purpose = 1000497
adjourn_type = 0
adjourn_remark =
isadjourn = NO
case_no = 2024/246
court_code = 10721
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=13389000010727
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = c
trn_rcms_caseid=19756000009203
Param Type = n
pre_case_purpose=1000497
Param Type = c
next_hear_date=04/06/2025 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/246
Param Type = c
court_code=10721
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,trn_rcms_caseid,pre_case_purpose,next_hear_date,new_case_purpose,adjourn_type,adjourn_remark,isadjourn,case_no,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,:isadjourn,:case_no,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 3
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 = 3
RecordId = 13389000010728
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 21/05/2025
trn_rcms_caseid = 11849000000259
pre_case_purpose = 12555000000002
new_case_purpose = 12555000000002
next_hear_date = 09/06/2025
adjourn_remark =
isadjourn = NO
court_code = 10721
adjourn_type = 0
case_no = 2016/00076
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=13389000010728
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = c
trn_rcms_caseid=11849000000259
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
new_case_purpose=12555000000002
Param Type = c
next_hear_date=09/06/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
court_code=10721
Param Type = c
adjourn_type=0
Param Type = c
case_no=2016/00076
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,pre_case_purpose,new_case_purpose,next_hear_date,adjourn_remark,isadjourn,court_code,adjourn_type,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:isadjourn,:court_code,:adjourn_type,:case_no,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 6
RecordId = 13389000010729
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2018/00015
isadjourn = NO
next_hear_date = 21/07/2025
adjourn_remark =
adjourn_type = 0
new_case_purpose = 12555000000002
pre_hear_date = 21/05/2025
trn_rcms_caseid = 18606000002164
court_code = 10721
pre_case_purpose = 12555000000002
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=13389000010729
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2018/00015
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=21/07/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=12555000000002
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = c
trn_rcms_caseid=18606000002164
Param Type = c
court_code=10721
Param Type = n
pre_case_purpose=12555000000002
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,case_no,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,pre_hear_date,trn_rcms_caseid,court_code,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 16
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010730
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 21/05/2025
pre_case_purpose = 12555000000002
trn_rcms_caseid = 19817000008728
court_code = 10721
case_no = 2024/247
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 12555000000002
next_hear_date = 04/06/2025
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=13389000010730
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
trn_rcms_caseid=19817000008728
Param Type = c
court_code=10721
Param Type = c
case_no=2024/247
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=12555000000002
Param Type = c
next_hear_date=04/06/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,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010731
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 21/05/2025
pre_case_purpose = 1000525
trn_rcms_caseid = 11802000000407
court_code = 10721
case_no = 2016/00075
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000525
next_hear_date = 09/06/2025
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=13389000010731
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = n
pre_case_purpose=1000525
Param Type = c
trn_rcms_caseid=11802000000407
Param Type = c
court_code=10721
Param Type = c
case_no=2016/00075
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=09/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010732
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 21/07/2025
new_case_purpose = 1000525
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2022/159
court_code = 10721
trn_rcms_caseid = 10356000005683
pre_case_purpose = 1000525
pre_hear_date = 21/05/2025
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=13389000010732
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
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=1000525
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/159
Param Type = c
court_code=10721
Param Type = c
trn_rcms_caseid=10356000005683
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=21/05/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,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010733
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
new_case_purpose = 1000490
adjourn_type = 0
next_hear_date = 12/06/2025
isadjourn = NO
case_no = 2022/178
court_code = 10721
trn_rcms_caseid = 19582000005934
pre_case_purpose = 1000490
pre_hear_date = 21/05/2025
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=13389000010733
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000490
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=12/06/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2022/178
Param Type = c
court_code=10721
Param Type = c
trn_rcms_caseid=19582000005934
Param Type = n
pre_case_purpose=1000490
Param Type = c
pre_hear_date=21/05/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,new_case_purpose,adjourn_type,next_hear_date,isadjourn,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:new_case_purpose,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13389000010734
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 9
pre_hear_date = 21/05/2025
trn_rcms_caseid = 16962000002235
isadjourn = NO
pre_case_purpose = 18678000000000
adjourn_type = 0
court_code = 10721
case_no = 2019/00076
adjourn_remark =
new_case_purpose = 18678000000000
next_hear_date = 04/06/2025
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=13389000010734
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = c
trn_rcms_caseid=16962000002235
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
court_code=10721
Param Type = c
case_no=2019/00076
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=04/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,isadjourn,pre_case_purpose,adjourn_type,court_code,case_no,adjourn_remark,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:isadjourn,:pre_case_purpose,:adjourn_type,:court_code,:case_no,null,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 3
RecordId = 13389000010735
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_type = 0
next_hear_date = 21/07/2025
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
pre_hear_date = 21/05/2025
case_no = 2020/00011
adjourn_remark =
trn_rcms_caseid = 19517000003936
court_code = 10721
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=13389000010735
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:39
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=21/07/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = c
case_no=2020/00011
Param Type = c
trn_rcms_caseid=19517000003936
Param Type = c
court_code=10721
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,isadjourn,adjourn_type,next_hear_date,pre_case_purpose,new_case_purpose,pre_hear_date,case_no,adjourn_remark,trn_rcms_caseid,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,null,:trn_rcms_caseid,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010736
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 10
pre_hear_date = 21/05/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 14372000006519
court_code = 10721
case_no = 2021/134
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 21/07/2025
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=13389000010736
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=14372000006519
Param Type = c
court_code=10721
Param Type = c
case_no=2021/134
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=21/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,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 = 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 = 13389000010737
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 21/07/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2021/167
court_code = 10721
trn_rcms_caseid = 17089000006398
pre_case_purpose = 18678000000000
pre_hear_date = 21/05/2025
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=13389000010737
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
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=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/167
Param Type = c
court_code=10721
Param Type = c
trn_rcms_caseid=17089000006398
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010738
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2021/45
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 13884000005130
pre_hear_date = 21/05/2025
adjourn_remark =
court_code = 10721
adjourn_type = 0
next_hear_date = 09/06/2025
isadjourn = NO
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=13389000010738
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2021/45
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=13884000005130
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = c
court_code=10721
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=09/06/2025 00:00:00
Param Type = c
isadjourn=NO
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,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010739
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 21/05/2025
adjourn_remark =
trn_rcms_caseid = 19544000008289
court_code = 10721
case_no = 2022/177
next_hear_date = 12/06/2025
isadjourn = NO
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
adjourn_type = 0
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=13389000010739
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = c
trn_rcms_caseid=19544000008289
Param Type = c
court_code=10721
Param Type = c
case_no=2022/177
Param Type = c
next_hear_date=12/06/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,adjourn_remark,trn_rcms_caseid,court_code,case_no,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:trn_rcms_caseid,:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010740
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark =
trn_rcms_caseid = 19454000006518
pre_hear_date = 21/05/2025
court_code = 10721
case_no = 2022/195
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 21/07/2025
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=13389000010740
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=19454000006518
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = c
court_code=10721
Param Type = c
case_no=2022/195
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=21/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,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13389000010741
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark =
trn_rcms_caseid = 10998000007448
pre_hear_date = 21/05/2025
court_code = 10721
case_no = 2022/206
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 21/07/2025
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=13389000010741
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=10998000007448
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = c
court_code=10721
Param Type = c
case_no=2022/206
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=21/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,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 = 20
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010742
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 13270000007231
case_no = 2022/218
pre_hear_date = 21/05/2025
next_hear_date = 25/06/2025
new_case_purpose = 18678000000000
isadjourn = NO
court_code = 10721
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=13389000010742
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13270000007231
Param Type = c
case_no=2022/218
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = c
next_hear_date=25/06/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
court_code=10721
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,case_no,pre_hear_date,next_hear_date,new_case_purpose,isadjourn,court_code,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010743
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 19753000007145
pre_hear_date = 21/05/2025
court_code = 10721
case_no = 2023/47
next_hear_date = 09/06/2025
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=13389000010743
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=19753000007145
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = c
court_code=10721
Param Type = c
case_no=2023/47
Param Type = c
next_hear_date=09/06/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=24
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 = 15
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010744
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 0
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 12056000008081
pre_hear_date = 21/05/2025
pre_case_purpose = 18678000000000
case_no = 2023/57
next_hear_date = 21/07/2025
new_case_purpose = 18678000000000
court_code = 10721
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=13389000010744
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=12056000008081
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2023/57
Param Type = c
next_hear_date=21/07/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
court_code=10721
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,next_hear_date,new_case_purpose,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010745
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 14302000008823
case_no = 2024/14
court_code = 10721
pre_hear_date = 21/05/2025
next_hear_date = 21/07/2025
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=13389000010745
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
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=14302000008823
Param Type = c
case_no=2024/14
Param Type = c
court_code=10721
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = c
next_hear_date=21/07/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010746
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 21/07/2025
case_no = 2024/232
court_code = 10721
trn_rcms_caseid = 10877000009221
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 21/05/2025
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=13389000010746
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
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=21/07/2025 00:00:00
Param Type = c
case_no=2024/232
Param Type = c
court_code=10721
Param Type = c
trn_rcms_caseid=10877000009221
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=27
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,case_no,court_code,trn_rcms_caseid,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 14
Adding new record to store data from Frame 2, Row 28 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13389000010747
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
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 11049000009586
case_no = 2024/233
court_code = 10721
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 21/05/2025
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=13389000010747
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
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
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=11049000009586
Param Type = c
case_no=2024/233
Param Type = c
court_code=10721
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010748
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 25/06/2025
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18625000000000
case_no = 2016/00152
court_code = 10721
trn_rcms_caseid = 15709000000907
pre_case_purpose = 18625000000000
pre_hear_date = 21/05/2025
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=13389000010748
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=25/06/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18625000000000
Param Type = c
case_no=2016/00152
Param Type = c
court_code=10721
Param Type = c
trn_rcms_caseid=15709000000907
Param Type = n
pre_case_purpose=18625000000000
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=29
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 30 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010749
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 21/07/2025
new_case_purpose = 18619000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2019/00013
court_code = 10721
trn_rcms_caseid = 15960000002353
pre_case_purpose = 18619000000000
pre_hear_date = 21/05/2025
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=13389000010749
Param Type = n
trn_rcms_mhearingid=13389000010719
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
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=18619000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2019/00013
Param Type = c
court_code=10721
Param Type = c
trn_rcms_caseid=15960000002353
Param Type = n
pre_case_purpose=18619000000000
Param Type = c
pre_hear_date=21/05/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 = 3958038160040
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16433000008311 idvalue 0
Mapped case_no Row = 1 value = 2024/203 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 11415000000002 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 = 10721
trn_rcms_caseregid = 16433000008311
case_no = 2024/203
prev_hearing_date = 21/05/2025
hearing_date = 21/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 = 17
prev_case_purpose after validation = 11415000000002
case_purpose = 11415000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 13389000010750
MapName trcmf1
SourceId 13389000010720
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 11415000000002
hearing_date = 21/07/2025
case_no = 2024/203
trn_rcms_caseregid = 16433000008311
court_code = 10721
case_purpose = 11415000000002
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010750
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010720
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:40
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=11415000000002
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2024/203
Param Type = c
trn_rcms_caseregid=16433000008311
Param Type = c
court_code=10721
Param Type = c
case_purpose=11415000000002
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14393000006252 idvalue 0
Mapped case_no Row = 1 value = 2021/135 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10721
trn_rcms_caseregid = 14393000006252
case_no = 2021/135
prev_hearing_date = 21/05/2025
hearing_date = 21/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 = 4
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010751
MapName trcmf1
SourceId 13389000010721
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 21/07/2025
case_no = 2021/135
trn_rcms_caseregid = 14393000006252
court_code = 10721
case_purpose = 1000492
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010751
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010721
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:45
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2021/135
Param Type = c
trn_rcms_caseregid=14393000006252
Param Type = c
court_code=10721
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14592000005446 idvalue 0
Mapped case_no Row = 1 value = 2021/46 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 09/06/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 = 10721
trn_rcms_caseregid = 14592000005446
case_no = 2021/46
prev_hearing_date = 21/05/2025
hearing_date = 09/06/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010752
MapName trcmf1
SourceId 13389000010722
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 09/06/2025
case_no = 2021/46
trn_rcms_caseregid = 14592000005446
court_code = 10721
case_purpose = 1000492
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010752
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010722
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:48
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02: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=1000492
Param Type = c
hearing_date=09/06/2025 00:00:00
Param Type = c
case_no=2021/46
Param Type = c
trn_rcms_caseregid=14592000005446
Param Type = c
court_code=10721
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13300000007103 idvalue 0
Mapped case_no Row = 1 value = 2022/219 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 25/06/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 = 10721
trn_rcms_caseregid = 13300000007103
case_no = 2022/219
prev_hearing_date = 21/05/2025
hearing_date = 25/06/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13389000010753
MapName trcmf1
SourceId 13389000010723
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 = 1000492
hearing_date = 25/06/2025
case_no = 2022/219
trn_rcms_caseregid = 13300000007103
court_code = 10721
case_purpose = 1000492
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010753
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010723
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:52
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=25/06/2025 00:00:00
Param Type = c
case_no=2022/219
Param Type = c
trn_rcms_caseregid=13300000007103
Param Type = c
court_code=10721
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10237000007215 idvalue 0
Mapped case_no Row = 1 value = 2023/88 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 25/06/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 = 10721
trn_rcms_caseregid = 10237000007215
case_no = 2023/88
prev_hearing_date = 21/05/2025
hearing_date = 25/06/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 4
RecordId = 13389000010754
MapName trcmf1
SourceId 13389000010724
Select sysdate as sdt from dual
Time elapsed = 9
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 = 1000492
hearing_date = 25/06/2025
case_no = 2023/88
trn_rcms_caseregid = 10237000007215
court_code = 10721
case_purpose = 1000492
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010754
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010724
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:55
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=25/06/2025 00:00:00
Param Type = c
case_no=2023/88
Param Type = c
trn_rcms_caseregid=10237000007215
Param Type = c
court_code=10721
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19252000001401 idvalue 0
Mapped case_no Row = 1 value = 2017/00140 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 25/06/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 = 10721
trn_rcms_caseregid = 19252000001401
case_no = 2017/00140
prev_hearing_date = 21/05/2025
hearing_date = 25/06/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 = 3
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 7
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010755
MapName trcmf1
SourceId 13389000010725
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 25/06/2025
case_no = 2017/00140
trn_rcms_caseregid = 19252000001401
court_code = 10721
case_purpose = 18473000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010755
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010725
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:02:59
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:02: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=18473000000000
Param Type = c
hearing_date=25/06/2025 00:00:00
Param Type = c
case_no=2017/00140
Param Type = c
trn_rcms_caseregid=19252000001401
Param Type = c
court_code=10721
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14269000002764 idvalue 0
Mapped case_no Row = 1 value = 2018/00125 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 04/06/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 = 10721
trn_rcms_caseregid = 14269000002764
case_no = 2018/00125
prev_hearing_date = 21/05/2025
hearing_date = 04/06/2025
prev_case_purposename = ???
prev_case_purpose =
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010756
MapName trcmf1
SourceId 13389000010726
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 04/06/2025
case_no = 2018/00125
trn_rcms_caseregid = 14269000002764
court_code = 10721
case_purpose = 18473000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010756
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010726
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:02
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=04/06/2025 00:00:00
Param Type = c
case_no=2018/00125
Param Type = c
trn_rcms_caseregid=14269000002764
Param Type = c
court_code=10721
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19756000009203 idvalue 0
Mapped case_no Row = 1 value = 2024/246 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 04/06/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 = 10721
trn_rcms_caseregid = 19756000009203
case_no = 2024/246
prev_hearing_date = 21/05/2025
hearing_date = 04/06/2025
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purposename=???? ?????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????????
Time elapsed = 5
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13389000010757
MapName trcmf1
SourceId 13389000010727
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 04/06/2025
case_no = 2024/246
trn_rcms_caseregid = 19756000009203
court_code = 10721
case_purpose = 1000497
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010757
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010727
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:06
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=04/06/2025 00:00:00
Param Type = c
case_no=2024/246
Param Type = c
trn_rcms_caseregid=19756000009203
Param Type = c
court_code=10721
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11849000000259 idvalue 0
Mapped case_no Row = 1 value = 2016/00076 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 09/06/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 = 10721
trn_rcms_caseregid = 11849000000259
case_no = 2016/00076
prev_hearing_date = 21/05/2025
hearing_date = 09/06/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 = 3
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13389000010758
MapName trcmf1
SourceId 13389000010728
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 09/06/2025
case_no = 2016/00076
trn_rcms_caseregid = 11849000000259
court_code = 10721
case_purpose = 12555000000002
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010758
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010728
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:10
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=09/06/2025 00:00:00
Param Type = c
case_no=2016/00076
Param Type = c
trn_rcms_caseregid=11849000000259
Param Type = c
court_code=10721
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18606000002164 idvalue 0
Mapped case_no Row = 1 value = 2018/00015 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10721
trn_rcms_caseregid = 18606000002164
case_no = 2018/00015
prev_hearing_date = 21/05/2025
hearing_date = 21/07/2025
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 9
RecordId = 13389000010759
MapName trcmf1
SourceId 13389000010729
Select sysdate as sdt from dual
Time elapsed = 23
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 = 12555000000002
hearing_date = 21/07/2025
case_no = 2018/00015
trn_rcms_caseregid = 18606000002164
court_code = 10721
case_purpose = 12555000000002
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010759
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010729
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:13
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2018/00015
Param Type = c
trn_rcms_caseregid=18606000002164
Param Type = c
court_code=10721
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19817000008728 idvalue 0
Mapped case_no Row = 1 value = 2024/247 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 04/06/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 = 10721
trn_rcms_caseregid = 19817000008728
case_no = 2024/247
prev_hearing_date = 21/05/2025
hearing_date = 04/06/2025
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 13389000010760
MapName trcmf1
SourceId 13389000010730
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 = 12555000000002
hearing_date = 04/06/2025
case_no = 2024/247
trn_rcms_caseregid = 19817000008728
court_code = 10721
case_purpose = 12555000000002
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010760
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010730
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:16
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03:16
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=04/06/2025 00:00:00
Param Type = c
case_no=2024/247
Param Type = c
trn_rcms_caseregid=19817000008728
Param Type = c
court_code=10721
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11802000000407 idvalue 0
Mapped case_no Row = 1 value = 2016/00075 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 09/06/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 = 10721
trn_rcms_caseregid = 11802000000407
case_no = 2016/00075
prev_hearing_date = 21/05/2025
hearing_date = 09/06/2025
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purposename=???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????
Time elapsed = 5
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010761
MapName trcmf1
SourceId 13389000010731
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 = 1000525
hearing_date = 09/06/2025
case_no = 2016/00075
trn_rcms_caseregid = 11802000000407
court_code = 10721
case_purpose = 1000525
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010761
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010731
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:20
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=09/06/2025 00:00:00
Param Type = c
case_no=2016/00075
Param Type = c
trn_rcms_caseregid=11802000000407
Param Type = c
court_code=10721
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10356000005683 idvalue 0
Mapped case_no Row = 1 value = 2022/159 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10721
trn_rcms_caseregid = 10356000005683
case_no = 2022/159
prev_hearing_date = 21/05/2025
hearing_date = 21/07/2025
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 13389000010762
MapName trcmf1
SourceId 13389000010732
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 21/07/2025
case_no = 2022/159
trn_rcms_caseregid = 10356000005683
court_code = 10721
case_purpose = 1000525
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010762
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010732
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:24
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03: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=1000525
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2022/159
Param Type = c
trn_rcms_caseregid=10356000005683
Param Type = c
court_code=10721
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19582000005934 idvalue 0
Mapped case_no Row = 1 value = 2022/178 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? / ??????? idvalue 0
Mapped case_purpose Row = 1 value = 1000490 idvalue 0
Mapped hearing_date Row = 1 value = 12/06/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 = 10721
trn_rcms_caseregid = 19582000005934
case_no = 2022/178
prev_hearing_date = 21/05/2025
hearing_date = 12/06/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 = 4
prev_case_purpose after validation = 1000490
case_purpose = 1000490
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010763
MapName trcmf1
SourceId 13389000010733
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000490
hearing_date = 12/06/2025
case_no = 2022/178
trn_rcms_caseregid = 19582000005934
court_code = 10721
case_purpose = 1000490
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010763
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010733
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:27
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03:27
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=1000490
Param Type = c
hearing_date=12/06/2025 00:00:00
Param Type = c
case_no=2022/178
Param Type = c
trn_rcms_caseregid=19582000005934
Param Type = c
court_code=10721
Param Type = c
case_purpose=1000490
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16962000002235 idvalue 0
Mapped case_no Row = 1 value = 2019/00076 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 04/06/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 = 10721
trn_rcms_caseregid = 16962000002235
case_no = 2019/00076
prev_hearing_date = 21/05/2025
hearing_date = 04/06/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 = 4
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010764
MapName trcmf1
SourceId 13389000010734
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 20
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 04/06/2025
case_no = 2019/00076
trn_rcms_caseregid = 16962000002235
court_code = 10721
case_purpose = 18678000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010764
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010734
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:31
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=04/06/2025 00:00:00
Param Type = c
case_no=2019/00076
Param Type = c
trn_rcms_caseregid=16962000002235
Param Type = c
court_code=10721
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19517000003936 idvalue 0
Mapped case_no Row = 1 value = 2020/00011 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10721
trn_rcms_caseregid = 19517000003936
case_no = 2020/00011
prev_hearing_date = 21/05/2025
hearing_date = 21/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 6
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 = 12
RecordId = 13389000010765
MapName trcmf1
SourceId 13389000010735
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/07/2025
case_no = 2020/00011
trn_rcms_caseregid = 19517000003936
court_code = 10721
case_purpose = 18678000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010765
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010735
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:35
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2020/00011
Param Type = c
trn_rcms_caseregid=19517000003936
Param Type = c
court_code=10721
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14372000006519 idvalue 0
Mapped case_no Row = 1 value = 2021/134 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10721
trn_rcms_caseregid = 14372000006519
case_no = 2021/134
prev_hearing_date = 21/05/2025
hearing_date = 21/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13389000010766
MapName trcmf1
SourceId 13389000010736
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/07/2025
case_no = 2021/134
trn_rcms_caseregid = 14372000006519
court_code = 10721
case_purpose = 18678000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010766
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010736
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:39
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2021/134
Param Type = c
trn_rcms_caseregid=14372000006519
Param Type = c
court_code=10721
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17089000006398 idvalue 0
Mapped case_no Row = 1 value = 2021/167 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10721
trn_rcms_caseregid = 17089000006398
case_no = 2021/167
prev_hearing_date = 21/05/2025
hearing_date = 21/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
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 = 13389000010767
MapName trcmf1
SourceId 13389000010737
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/07/2025
case_no = 2021/167
trn_rcms_caseregid = 17089000006398
court_code = 10721
case_purpose = 18678000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010767
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010737
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:42
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2021/167
Param Type = c
trn_rcms_caseregid=17089000006398
Param Type = c
court_code=10721
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13884000005130 idvalue 0
Mapped case_no Row = 1 value = 2021/45 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/06/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 = 10721
trn_rcms_caseregid = 13884000005130
case_no = 2021/45
prev_hearing_date = 21/05/2025
hearing_date = 09/06/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 13389000010768
MapName trcmf1
SourceId 13389000010738
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/06/2025
case_no = 2021/45
trn_rcms_caseregid = 13884000005130
court_code = 10721
case_purpose = 18678000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010768
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010738
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:46
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03: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=18678000000000
Param Type = c
hearing_date=09/06/2025 00:00:00
Param Type = c
case_no=2021/45
Param Type = c
trn_rcms_caseregid=13884000005130
Param Type = c
court_code=10721
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19544000008289 idvalue 0
Mapped case_no Row = 1 value = 2022/177 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 12/06/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 = 10721
trn_rcms_caseregid = 19544000008289
case_no = 2022/177
prev_hearing_date = 21/05/2025
hearing_date = 12/06/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010769
MapName trcmf1
SourceId 13389000010739
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 12/06/2025
case_no = 2022/177
trn_rcms_caseregid = 19544000008289
court_code = 10721
case_purpose = 18678000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010769
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010739
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:49
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=12/06/2025 00:00:00
Param Type = c
case_no=2022/177
Param Type = c
trn_rcms_caseregid=19544000008289
Param Type = c
court_code=10721
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19454000006518 idvalue 0
Mapped case_no Row = 1 value = 2022/195 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10721
trn_rcms_caseregid = 19454000006518
case_no = 2022/195
prev_hearing_date = 21/05/2025
hearing_date = 21/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 19
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 = 13389000010770
MapName trcmf1
SourceId 13389000010740
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/07/2025
case_no = 2022/195
trn_rcms_caseregid = 19454000006518
court_code = 10721
case_purpose = 18678000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010770
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010740
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:53
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2022/195
Param Type = c
trn_rcms_caseregid=19454000006518
Param Type = c
court_code=10721
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/05/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 = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10998000007448 idvalue 0
Mapped case_no Row = 1 value = 2022/206 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10721
trn_rcms_caseregid = 10998000007448
case_no = 2022/206
prev_hearing_date = 21/05/2025
hearing_date = 21/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010771
MapName trcmf1
SourceId 13389000010741
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/07/2025
case_no = 2022/206
trn_rcms_caseregid = 10998000007448
court_code = 10721
case_purpose = 18678000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010771
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010741
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:03:57
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:03: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=18678000000000
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2022/206
Param Type = c
trn_rcms_caseregid=10998000007448
Param Type = c
court_code=10721
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/05/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 23
>>Mapping
Mapped court_code Row = 1 value = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13270000007231 idvalue 0
Mapped case_no Row = 1 value = 2022/218 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 25/06/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 = 10721
trn_rcms_caseregid = 13270000007231
case_no = 2022/218
prev_hearing_date = 21/05/2025
hearing_date = 25/06/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 13389000010772
MapName trcmf1
SourceId 13389000010742
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 25/06/2025
case_no = 2022/218
trn_rcms_caseregid = 13270000007231
court_code = 10721
case_purpose = 18678000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010772
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010742
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:04:00
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:04:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=25/06/2025 00:00:00
Param Type = c
case_no=2022/218
Param Type = c
trn_rcms_caseregid=13270000007231
Param Type = c
court_code=10721
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/05/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 24
>>Mapping
Mapped court_code Row = 1 value = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19753000007145 idvalue 0
Mapped case_no Row = 1 value = 2023/47 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/06/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 = 10721
trn_rcms_caseregid = 19753000007145
case_no = 2023/47
prev_hearing_date = 21/05/2025
hearing_date = 09/06/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 13389000010773
MapName trcmf1
SourceId 13389000010743
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/06/2025
case_no = 2023/47
trn_rcms_caseregid = 19753000007145
court_code = 10721
case_purpose = 18678000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010773
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010743
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:04:04
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:04:04
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/06/2025 00:00:00
Param Type = c
case_no=2023/47
Param Type = c
trn_rcms_caseregid=19753000007145
Param Type = c
court_code=10721
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/05/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 25
>>Mapping
Mapped court_code Row = 1 value = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12056000008081 idvalue 0
Mapped case_no Row = 1 value = 2023/57 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10721
trn_rcms_caseregid = 12056000008081
case_no = 2023/57
prev_hearing_date = 21/05/2025
hearing_date = 21/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010774
MapName trcmf1
SourceId 13389000010744
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/07/2025
case_no = 2023/57
trn_rcms_caseregid = 12056000008081
court_code = 10721
case_purpose = 18678000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010774
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010744
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:04:07
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:04: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=18678000000000
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2023/57
Param Type = c
trn_rcms_caseregid=12056000008081
Param Type = c
court_code=10721
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/05/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 26
>>Mapping
Mapped court_code Row = 1 value = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14302000008823 idvalue 0
Mapped case_no Row = 1 value = 2024/14 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10721
trn_rcms_caseregid = 14302000008823
case_no = 2024/14
prev_hearing_date = 21/05/2025
hearing_date = 21/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 13389000010775
MapName trcmf1
SourceId 13389000010745
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/07/2025
case_no = 2024/14
trn_rcms_caseregid = 14302000008823
court_code = 10721
case_purpose = 18678000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010775
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010745
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:04:11
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:04:11
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2024/14
Param Type = c
trn_rcms_caseregid=14302000008823
Param Type = c
court_code=10721
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/05/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 27
>>Mapping
Mapped court_code Row = 1 value = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10877000009221 idvalue 0
Mapped case_no Row = 1 value = 2024/232 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10721
trn_rcms_caseregid = 10877000009221
case_no = 2024/232
prev_hearing_date = 21/05/2025
hearing_date = 21/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 6
RecordId = 13389000010776
MapName trcmf1
SourceId 13389000010746
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/07/2025
case_no = 2024/232
trn_rcms_caseregid = 10877000009221
court_code = 10721
case_purpose = 18678000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010776
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010746
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:04:14
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:04:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2024/232
Param Type = c
trn_rcms_caseregid=10877000009221
Param Type = c
court_code=10721
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/05/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 28
>>Mapping
Mapped court_code Row = 1 value = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11049000009586 idvalue 0
Mapped case_no Row = 1 value = 2024/233 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 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 = 10721
trn_rcms_caseregid = 11049000009586
case_no = 2024/233
prev_hearing_date = 21/05/2025
hearing_date = 21/07/2025
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13389000010777
MapName trcmf1
SourceId 13389000010747
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/07/2025
case_no = 2024/233
trn_rcms_caseregid = 11049000009586
court_code = 10721
case_purpose = 18678000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010777
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010747
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:04:18
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:04:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2024/233
Param Type = c
trn_rcms_caseregid=11049000009586
Param Type = c
court_code=10721
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/05/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 29
>>Mapping
Mapped court_code Row = 1 value = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15709000000907 idvalue 0
Mapped case_no Row = 1 value = 2016/00152 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18625000000000 idvalue 0
Mapped hearing_date Row = 1 value = 25/06/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 = 10721
trn_rcms_caseregid = 15709000000907
case_no = 2016/00152
prev_hearing_date = 21/05/2025
hearing_date = 25/06/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 = 4
prev_case_purpose after validation = 18625000000000
case_purpose = 18625000000000
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 = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010778
MapName trcmf1
SourceId 13389000010748
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18625000000000
hearing_date = 25/06/2025
case_no = 2016/00152
trn_rcms_caseregid = 15709000000907
court_code = 10721
case_purpose = 18625000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010778
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010748
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:04:21
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:04:21
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=18625000000000
Param Type = c
hearing_date=25/06/2025 00:00:00
Param Type = c
case_no=2016/00152
Param Type = c
trn_rcms_caseregid=15709000000907
Param Type = c
court_code=10721
Param Type = c
case_purpose=18625000000000
Param Type = c
prev_hearing_date=21/05/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 30
>>Mapping
Mapped court_code Row = 1 value = 10721 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15960000002353 idvalue 0
Mapped case_no Row = 1 value = 2019/00013 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/05/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????? idvalue 0
Mapped case_purpose Row = 1 value = 18619000000000 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 = 10721
trn_rcms_caseregid = 15960000002353
case_no = 2019/00013
prev_hearing_date = 21/05/2025
hearing_date = 21/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 = 4
prev_case_purpose after validation = 18619000000000
case_purpose = 18619000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13389000010779
MapName trcmf1
SourceId 13389000010749
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18619000000000
hearing_date = 21/07/2025
case_no = 2019/00013
trn_rcms_caseregid = 15960000002353
court_code = 10721
case_purpose = 18619000000000
prev_hearing_date = 21/05/2025
Posting record
Param Type = n
trn_rcms_case_histid=13389000010779
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13389000010749
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_Behroad_PRO
Param Type = c
createdon=02/06/2025 15:04:25
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
modifiedon=02/06/2025 15:04:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18619000000000
Param Type = c
hearing_date=21/07/2025 00:00:00
Param Type = c
case_no=2019/00013
Param Type = c
trn_rcms_caseregid=15960000002353
Param Type = c
court_code=10721
Param Type = c
case_purpose=18619000000000
Param Type = c
prev_hearing_date=21/05/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 = 3958038267904
Time elapsed for MD Map = 3958038267904
Time elapsed for Save History = 3958038267905
Time elapsed for Save Attachment = 3958038267905
Time elapsed for After Save WF Exec = 3958038267909
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"13389000010719"}]}
Savedata webservice completed
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=ACEM_Behroad_PRO
Param Type = c
calledon=02/06/2025 15:02:37
Param Type = c
callfinished=02/06/2025 15:04: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=110062
Param Type = n
dbtimetaken=108570
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