ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
gcmsSDO_Chidava827ccb0eea8a706c4c34a16891f84e7b![]()
INRF500250000Ffiresql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtname := sqlget({m2},{court_name})firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})m_courttype := sqlget({m3},{court_type})firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})m_courtid := sqlget({m4},{court_name_mastid})firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})login_userid := sqlget({m4},{axusersid})firesql({m4},{select :username as uname from dual})u_name := sqlget({m4},{uname})firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtcode := sqlget({m4},{COURT_CODE})firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})m_statename := sqlget({m2},{STATE_NAME})firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_distName := sqlget({m7},{DISTNAMEENG})firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_courtcatid := sqlget({m8},{COURT_CATEGOTY})firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})m_deptid := sqlget({m4},{department_mastid})firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})m_courttypeid := sqlget({m3},{court_type_mastid})firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })urole := sqlget({m4},{groupname})firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})m_cutoffdt := sqlget({a1},{dd})firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})m_offcount := sqlget({P1},{ct})00000F
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
username=SDO_Chidava
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Chidava
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ????? ???????, ??????,???? -???????
Result = ????? ???????, ??????,???? -???????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=SDO_Chidava
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Chidava
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = SDO
Result = SDO
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=SDO_Chidava
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Chidava
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 13816000000027
Result = 13816000000027
Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=SDO_Chidava
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 4085
Result = 4085
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=SDO_Chidava
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = SDO_Chidava
Result = SDO_Chidava
Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Chidava
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10480
Result = 10480
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=SDO_Chidava
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Chidava
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Jhunjhunu
Result = Jhunjhunu
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=SDO_Chidava
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Chidava
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=4085
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=4085
Time elapsed = 10
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=SDO_Chidava
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10823000000000
Result = 10823000000000
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=SDO_Chidava
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=SDO_Chidava
Time elapsed = 12
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_reader
Result = court_reader
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=SDO_Chidava
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=SDO_Chidava
Time elapsed = 11
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 4
Result = 4
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 4
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 9
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_reader,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 5
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 = 30
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 = 10480
hearing_date = 28/08/2024
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 5
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008687
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 9
hearing_date = 28/08/2024
courtcode = 10480
Posting record
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:51
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=28/08/2024 00:00:00
Param Type = c
courtcode=10480
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)
Saving to table TRN_RCMS_HEARING
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15408000008688
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 8
next_hear_date = 11/09/2024
new_case_purpose = 11417000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/434
court_code = 10480
trn_rcms_caseid = 13038000007993
pre_case_purpose = 11417000000000
pre_hear_date = 28/08/2024
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=15408000008688
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:51
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = c
new_case_purpose=11417000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/434
Param Type = c
court_code=10480
Param Type = c
trn_rcms_caseid=13038000007993
Param Type = n
pre_case_purpose=11417000000000
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 15408000008689
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 12/09/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2019/00184
court_code = 10480
trn_rcms_caseid = 10489000002536
pre_case_purpose = 18678000000000
pre_hear_date = 28/08/2024
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=15408000008689
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:51
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=12/09/2024 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=2019/00184
Param Type = c
court_code=10480
Param Type = c
trn_rcms_caseid=10489000002536
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008690
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 8
pre_hear_date = 28/08/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16233000005832
court_code = 10480
case_no = 2021/267
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=15408000008690
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:51
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16233000005832
Param Type = c
court_code=10480
Param Type = c
case_no=2021/267
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 15408000008691
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 9
pre_hear_date = 28/08/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 12305000006102
court_code = 10480
case_no = 2021/293
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 05/09/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=15408000008691
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:51
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=12305000006102
Param Type = c
court_code=10480
Param Type = c
case_no=2021/293
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=05/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15408000008692
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 9
next_hear_date = 03/09/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2022/491
court_code = 10480
trn_rcms_caseid = 12310000006958
pre_case_purpose = 18678000000000
pre_hear_date = 28/08/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=15408000008692
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:51
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=03/09/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/491
Param Type = c
court_code=10480
Param Type = c
trn_rcms_caseid=12310000006958
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15408000008693
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 7
pre_hear_date = 28/08/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 10287000008466
court_code = 10480
case_no = 2023/379
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=15408000008693
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:51
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=10287000008466
Param Type = c
court_code=10480
Param Type = c
case_no=2023/379
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=12/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008694
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 28
new_case_purpose = 18678000000000
next_hear_date = 24/09/2024
trn_rcms_caseid = 17040000007124
pre_hear_date = 28/08/2024
pre_case_purpose = 18678000000000
case_no = 2023/47
court_code = 10480
adjourn_remark =
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=15408000008694
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:51
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=24/09/2024 00:00:00
Param Type = c
trn_rcms_caseid=17040000007124
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2023/47
Param Type = c
court_code=10480
Param Type = c
isadjourn=NO
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,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,court_code,adjourn_remark,isadjourn,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,null,:isadjourn,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 19
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008695
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trn_rcms_caseid = 10939000008865
case_no = 2024/113
pre_hear_date = 28/08/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
adjourn_type = 0
adjourn_remark =
isadjourn = NO
court_code = 10480
next_hear_date = 03/09/2024
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=15408000008695
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:52
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=10939000008865
Param Type = c
case_no=2024/113
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
court_code=10480
Param Type = c
next_hear_date=03/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,case_no,pre_hear_date,new_case_purpose,pre_case_purpose,adjourn_type,adjourn_remark,isadjourn,court_code,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,:trn_rcms_caseid,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:adjourn_type,null,:isadjourn,:court_code,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 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008696
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
adjourn_type = 0
pre_hear_date = 28/08/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 14023000007750
next_hear_date = 03/09/2024
court_code = 10480
case_no = 2024/148
isadjourn = NO
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=15408000008696
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:52
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=14023000007750
Param Type = c
next_hear_date=03/09/2024 00:00:00
Param Type = c
court_code=10480
Param Type = c
case_no=2024/148
Param Type = c
isadjourn=NO
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,adjourn_remark,adjourn_type,pre_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_caseid,next_hear_date,court_code,case_no,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,null,:adjourn_type,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,: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 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008697
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
court_code = 10480
case_no = 2024/155
isadjourn = NO
next_hear_date = 03/09/2024
adjourn_remark =
adjourn_type = 0
pre_hear_date = 28/08/2024
trn_rcms_caseid = 14233000008189
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=15408000008697
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:52
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10480
Param Type = c
case_no=2024/155
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=03/09/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = c
trn_rcms_caseid=14233000008189
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
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,court_code,case_no,isadjourn,next_hear_date,adjourn_remark,adjourn_type,pre_hear_date,trn_rcms_caseid,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:case_no,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 10
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008698
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 28/08/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16570000008790
court_code = 10480
case_no = 2024/229
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=15408000008698
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:52
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16570000008790
Param Type = c
court_code=10480
Param Type = c
case_no=2024/229
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15408000008699
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 24
pre_hear_date = 28/08/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 18861000008232
court_code = 10480
case_no = 2024/270
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=15408000008699
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:52
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=18861000008232
Param Type = c
court_code=10480
Param Type = c
case_no=2024/270
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 4
RecordId = 15408000008700
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 11/09/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/342
court_code = 10480
trn_rcms_caseid = 13613000009436
pre_case_purpose = 18678000000000
pre_hear_date = 28/08/2024
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=15408000008700
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:52
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/09/2024 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=2024/342
Param Type = c
court_code=10480
Param Type = c
trn_rcms_caseid=13613000009436
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15408000008701
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 7
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 11/09/2024
case_no = 2024/351
court_code = 10480
trn_rcms_caseid = 15892000008579
pre_case_purpose = 18678000000000
pre_hear_date = 28/08/2024
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=15408000008701
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:52
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = c
case_no=2024/351
Param Type = c
court_code=10480
Param Type = c
trn_rcms_caseid=15892000008579
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=14
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,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,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),: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 = 9
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 = 3
RecordId = 15408000008702
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 28/08/2024
trn_rcms_caseid = 15965000008720
next_hear_date = 19/09/2024
pre_case_purpose = 18678000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2024/354
court_code = 10480
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=15408000008702
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:52
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = c
trn_rcms_caseid=15965000008720
Param Type = c
next_hear_date=19/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/354
Param Type = c
court_code=10480
Param Type = c
new_case_purpose=18678000000000
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,next_hear_date,pre_case_purpose,adjourn_remark,adjourn_type,isadjourn,case_no,court_code,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,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,null,:adjourn_type,:isadjourn,:case_no,:court_code,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15408000008703
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 11/09/2024
isadjourn = NO
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 28/08/2024
adjourn_remark =
court_code = 10480
trn_rcms_caseid = 16095000008688
case_no = 2024/358
adjourn_type = 0
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=15408000008703
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:53
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/09/2024 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
pre_hear_date=28/08/2024 00:00:00
Param Type = c
court_code=10480
Param Type = c
trn_rcms_caseid=16095000008688
Param Type = c
case_no=2024/358
Param Type = c
adjourn_type=0
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,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,adjourn_remark,court_code,trn_rcms_caseid,case_no,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(: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'),null,:court_code,:trn_rcms_caseid,:case_no,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008704
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 28/08/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 13124000008327
court_code = 10480
case_no = 2024/406
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=15408000008704
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:53
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=13124000008327
Param Type = c
court_code=10480
Param Type = c
case_no=2024/406
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 7
Adding new record to store data from Frame 2, Row 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 15408000008705
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 30
Select sysdate as sdt from dual
Time elapsed = 9
next_hear_date = 11/09/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/407
court_code = 10480
trn_rcms_caseid = 13208000009365
pre_case_purpose = 18678000000000
pre_hear_date = 28/08/2024
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=15408000008705
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:53
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/09/2024 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=2024/407
Param Type = c
court_code=10480
Param Type = c
trn_rcms_caseid=13208000009365
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 16
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15408000008706
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_case_purpose = 18678000000000
court_code = 10480
pre_hear_date = 28/08/2024
case_no = 2024/408
trn_rcms_caseid = 13262000009266
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=15408000008706
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:53
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=10480
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = c
case_no=2024/408
Param Type = c
trn_rcms_caseid=13262000009266
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,court_code,pre_hear_date,case_no,trn_rcms_caseid,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,:pre_case_purpose,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseid,: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 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008707
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 25
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark =
trn_rcms_caseid = 13367000008601
adjourn_type = 0
court_code = 10480
case_no = 2024/409
pre_hear_date = 28/08/2024
new_case_purpose = 18678000000000
next_hear_date = 11/09/2024
pre_case_purpose = 18678000000000
isadjourn = NO
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=15408000008707
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:53
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=13367000008601
Param Type = c
adjourn_type=0
Param Type = c
court_code=10480
Param Type = c
case_no=2024/409
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,adjourn_type,court_code,case_no,pre_hear_date,new_case_purpose,next_hear_date,pre_case_purpose,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,null,:trn_rcms_caseid,:adjourn_type,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008708
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 9
adjourn_remark =
trn_rcms_caseid = 13465000008304
pre_hear_date = 28/08/2024
court_code = 10480
case_no = 2024/410
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 11/09/2024
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=15408000008708
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:53
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=13465000008304
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = c
court_code=10480
Param Type = c
case_no=2024/410
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=11/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008709
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 28
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 13504000008973
pre_hear_date = 28/08/2024
court_code = 10480
case_no = 2024/411
next_hear_date = 11/09/2024
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=15408000008709
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:53
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13504000008973
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = c
court_code=10480
Param Type = c
case_no=2024/411
Param Type = c
next_hear_date=11/09/2024 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=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,adjourn_type,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,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008710
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 10
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 13476000009355
case_no = 2024/415
new_case_purpose = 18678000000000
pre_hear_date = 28/08/2024
next_hear_date = 09/09/2024
isadjourn = NO
court_code = 10480
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=15408000008710
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:53
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13476000009355
Param Type = c
case_no=2024/415
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = c
next_hear_date=09/09/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
court_code=10480
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_type,adjourn_remark,trn_rcms_caseid,case_no,new_case_purpose,pre_hear_date,next_hear_date,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,:adjourn_type,null,:trn_rcms_caseid,:case_no,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 15408000008711
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 9
adjourn_type = 0
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 10019000008541
case_no = 2024/426
court_code = 10480
pre_hear_date = 28/08/2024
next_hear_date = 11/09/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=15408000008711
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:53
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:53
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=10019000008541
Param Type = c
case_no=2024/426
Param Type = c
court_code=10480
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,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,:adjourn_type,null,:isadjourn,: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 = 10
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 = 6
RecordId = 15408000008712
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 8
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 15744000005675
case_no = 2021/24
court_code = 10480
pre_hear_date = 28/08/2024
next_hear_date = 11/09/2024
new_case_purpose = 18472000000000
pre_case_purpose = 18472000000000
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=15408000008712
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:54
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:54
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=15744000005675
Param Type = c
case_no=2021/24
Param Type = c
court_code=10480
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = c
new_case_purpose=18472000000000
Param Type = n
pre_case_purpose=18472000000000
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,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 = 8
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 = 5
RecordId = 15408000008713
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 11/09/2024
case_no = 2022/127
court_code = 10480
trn_rcms_caseid = 16064000006037
new_case_purpose = 18472000000000
pre_case_purpose = 18472000000000
pre_hear_date = 28/08/2024
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=15408000008713
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:54
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:54
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=11/09/2024 00:00:00
Param Type = c
case_no=2022/127
Param Type = c
court_code=10480
Param Type = c
trn_rcms_caseid=16064000006037
Param Type = c
new_case_purpose=18472000000000
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
pre_hear_date=28/08/2024 00:00:00
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_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 = 7
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 = 5
RecordId = 15408000008714
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 30/08/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 11731000008620
case_no = 2023/319
court_code = 10480
new_case_purpose = 18472000000000
pre_case_purpose = 18472000000000
pre_hear_date = 28/08/2024
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=15408000008714
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:54
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=30/08/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=11731000008620
Param Type = c
case_no=2023/319
Param Type = c
court_code=10480
Param Type = c
new_case_purpose=18472000000000
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
pre_hear_date=28/08/2024 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,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 = 4
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 = 4
RecordId = 15408000008715
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 11/09/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18472000000000
case_no = 2023/72
court_code = 10480
trn_rcms_caseid = 17743000007700
pre_case_purpose = 18472000000000
pre_hear_date = 28/08/2024
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=15408000008715
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:54
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18472000000000
Param Type = c
case_no=2023/72
Param Type = c
court_code=10480
Param Type = c
trn_rcms_caseid=17743000007700
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 4
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 = 15408000008716
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 11/09/2024
new_case_purpose = 18472000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2024/50
court_code = 10480
trn_rcms_caseid = 10960000007735
pre_case_purpose = 18472000000000
pre_hear_date = 28/08/2024
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=15408000008716
Param Type = n
trn_rcms_mhearingid=15408000008687
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:54
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/09/2024 00:00:00
Param Type = c
new_case_purpose=18472000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/50
Param Type = c
court_code=10480
Param Type = c
trn_rcms_caseid=10960000007735
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
pre_hear_date=28/08/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=29
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 = 3934090125743
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13038000007993 idvalue 0
Mapped case_no Row = 1 value = 2023/434 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 11417000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 13038000007993
case_no = 2023/434
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ??????? ???????
prev_case_purpose =
prev_case_purposename=??????? ???????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ???????
Time elapsed = 7
prev_case_purpose after validation = 11417000000000
case_purpose = 11417000000000
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 = 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 = 15408000008717
MapName trcmf1
SourceId 15408000008688
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 11417000000000
hearing_date = 11/09/2024
case_no = 2023/434
trn_rcms_caseregid = 13038000007993
court_code = 10480
case_purpose = 11417000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008717
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008688
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:54
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=11417000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2023/434
Param Type = c
trn_rcms_caseregid=13038000007993
Param Type = c
court_code=10480
Param Type = c
case_purpose=11417000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 2
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10489000002536 idvalue 0
Mapped case_no Row = 1 value = 2019/00184 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 10489000002536
case_no = 2019/00184
prev_hearing_date = 28/08/2024
hearing_date = 12/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 11
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 = 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 = 15408000008718
MapName trcmf1
SourceId 15408000008689
Select sysdate as sdt from dual
Time elapsed = 17
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 = 18678000000000
hearing_date = 12/09/2024
case_no = 2019/00184
trn_rcms_caseregid = 10489000002536
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008718
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008689
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:54
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=12/09/2024 00:00:00
Param Type = c
case_no=2019/00184
Param Type = c
trn_rcms_caseregid=10489000002536
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 3
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16233000005832 idvalue 0
Mapped case_no Row = 1 value = 2021/267 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 16233000005832
case_no = 2021/267
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 25
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 15408000008719
MapName trcmf1
SourceId 15408000008690
Select sysdate as sdt from dual
Time elapsed = 12
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 = 18678000000000
hearing_date = 11/09/2024
case_no = 2021/267
trn_rcms_caseregid = 16233000005832
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008719
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008690
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:55
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=18678000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2021/267
Param Type = c
trn_rcms_caseregid=16233000005832
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 4
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12305000006102 idvalue 0
Mapped case_no Row = 1 value = 2021/293 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 12305000006102
case_no = 2021/293
prev_hearing_date = 28/08/2024
hearing_date = 05/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008720
MapName trcmf1
SourceId 15408000008691
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/09/2024
case_no = 2021/293
trn_rcms_caseregid = 12305000006102
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008720
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008691
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:55
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=18678000000000
Param Type = c
hearing_date=05/09/2024 00:00:00
Param Type = c
case_no=2021/293
Param Type = c
trn_rcms_caseregid=12305000006102
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 5
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12310000006958 idvalue 0
Mapped case_no Row = 1 value = 2022/491 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 03/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 12310000006958
case_no = 2022/491
prev_hearing_date = 28/08/2024
hearing_date = 03/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15408000008721
MapName trcmf1
SourceId 15408000008692
Select sysdate as sdt from dual
Time elapsed = 9
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 = 18678000000000
hearing_date = 03/09/2024
case_no = 2022/491
trn_rcms_caseregid = 12310000006958
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008721
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008692
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:55
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=18678000000000
Param Type = c
hearing_date=03/09/2024 00:00:00
Param Type = c
case_no=2022/491
Param Type = c
trn_rcms_caseregid=12310000006958
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 6
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10287000008466 idvalue 0
Mapped case_no Row = 1 value = 2023/379 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 10287000008466
case_no = 2023/379
prev_hearing_date = 28/08/2024
hearing_date = 12/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 15408000008722
MapName trcmf1
SourceId 15408000008693
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 12/09/2024
case_no = 2023/379
trn_rcms_caseregid = 10287000008466
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008722
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008693
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:55
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=18678000000000
Param Type = c
hearing_date=12/09/2024 00:00:00
Param Type = c
case_no=2023/379
Param Type = c
trn_rcms_caseregid=10287000008466
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 7
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17040000007124 idvalue 0
Mapped case_no Row = 1 value = 2023/47 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 24/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 17040000007124
case_no = 2023/47
prev_hearing_date = 28/08/2024
hearing_date = 24/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15408000008723
MapName trcmf1
SourceId 15408000008694
Select sysdate as sdt from dual
Time elapsed = 6
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 = 18678000000000
hearing_date = 24/09/2024
case_no = 2023/47
trn_rcms_caseregid = 17040000007124
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008723
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008694
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:55
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=18678000000000
Param Type = c
hearing_date=24/09/2024 00:00:00
Param Type = c
case_no=2023/47
Param Type = c
trn_rcms_caseregid=17040000007124
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 8
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10939000008865 idvalue 0
Mapped case_no Row = 1 value = 2024/113 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 03/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 10939000008865
case_no = 2024/113
prev_hearing_date = 28/08/2024
hearing_date = 03/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 15408000008724
MapName trcmf1
SourceId 15408000008695
Select sysdate as sdt from dual
Time elapsed = 28
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 03/09/2024
case_no = 2024/113
trn_rcms_caseregid = 10939000008865
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008724
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008695
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:55
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=18678000000000
Param Type = c
hearing_date=03/09/2024 00:00:00
Param Type = c
case_no=2024/113
Param Type = c
trn_rcms_caseregid=10939000008865
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 9
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14023000007750 idvalue 0
Mapped case_no Row = 1 value = 2024/148 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 03/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 14023000007750
case_no = 2024/148
prev_hearing_date = 28/08/2024
hearing_date = 03/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 15408000008725
MapName trcmf1
SourceId 15408000008696
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 03/09/2024
case_no = 2024/148
trn_rcms_caseregid = 14023000007750
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008725
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008696
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:56
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=03/09/2024 00:00:00
Param Type = c
case_no=2024/148
Param Type = c
trn_rcms_caseregid=14023000007750
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 10
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14233000008189 idvalue 0
Mapped case_no Row = 1 value = 2024/155 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 03/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 14233000008189
case_no = 2024/155
prev_hearing_date = 28/08/2024
hearing_date = 03/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15408000008726
MapName trcmf1
SourceId 15408000008697
Select sysdate as sdt from dual
Time elapsed = 7
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 = 18678000000000
hearing_date = 03/09/2024
case_no = 2024/155
trn_rcms_caseregid = 14233000008189
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008726
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008697
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:56
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=03/09/2024 00:00:00
Param Type = c
case_no=2024/155
Param Type = c
trn_rcms_caseregid=14233000008189
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 11
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16570000008790 idvalue 0
Mapped case_no Row = 1 value = 2024/229 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 16570000008790
case_no = 2024/229
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008727
MapName trcmf1
SourceId 15408000008698
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/09/2024
case_no = 2024/229
trn_rcms_caseregid = 16570000008790
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008727
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008698
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:56
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2024/229
Param Type = c
trn_rcms_caseregid=16570000008790
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 12
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18861000008232 idvalue 0
Mapped case_no Row = 1 value = 2024/270 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 18861000008232
case_no = 2024/270
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 209
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 = 15408000008728
MapName trcmf1
SourceId 15408000008699
Select sysdate as sdt from dual
Time elapsed = 10
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 = 18678000000000
hearing_date = 11/09/2024
case_no = 2024/270
trn_rcms_caseregid = 18861000008232
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008728
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008699
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:56
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2024/270
Param Type = c
trn_rcms_caseregid=18861000008232
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 13
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13613000009436 idvalue 0
Mapped case_no Row = 1 value = 2024/342 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 13613000009436
case_no = 2024/342
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 15408000008729
MapName trcmf1
SourceId 15408000008700
Select sysdate as sdt from dual
Time elapsed = 6
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 = 18678000000000
hearing_date = 11/09/2024
case_no = 2024/342
trn_rcms_caseregid = 13613000009436
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008729
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008700
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:56
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2024/342
Param Type = c
trn_rcms_caseregid=13613000009436
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 14
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15892000008579 idvalue 0
Mapped case_no Row = 1 value = 2024/351 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 15892000008579
case_no = 2024/351
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008730
MapName trcmf1
SourceId 15408000008701
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/09/2024
case_no = 2024/351
trn_rcms_caseregid = 15892000008579
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008730
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008701
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:57
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=11/09/2024 00:00:00
Param Type = c
case_no=2024/351
Param Type = c
trn_rcms_caseregid=15892000008579
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 15
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15965000008720 idvalue 0
Mapped case_no Row = 1 value = 2024/354 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 15965000008720
case_no = 2024/354
prev_hearing_date = 28/08/2024
hearing_date = 19/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008731
MapName trcmf1
SourceId 15408000008702
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/09/2024
case_no = 2024/354
trn_rcms_caseregid = 15965000008720
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008731
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008702
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:57
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=19/09/2024 00:00:00
Param Type = c
case_no=2024/354
Param Type = c
trn_rcms_caseregid=15965000008720
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 16
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16095000008688 idvalue 0
Mapped case_no Row = 1 value = 2024/358 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 16095000008688
case_no = 2024/358
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008732
MapName trcmf1
SourceId 15408000008703
Select sysdate as sdt from dual
Time elapsed = 8
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 = 18678000000000
hearing_date = 11/09/2024
case_no = 2024/358
trn_rcms_caseregid = 16095000008688
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008732
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008703
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:57
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=11/09/2024 00:00:00
Param Type = c
case_no=2024/358
Param Type = c
trn_rcms_caseregid=16095000008688
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 17
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13124000008327 idvalue 0
Mapped case_no Row = 1 value = 2024/406 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 13124000008327
case_no = 2024/406
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 15408000008733
MapName trcmf1
SourceId 15408000008704
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/09/2024
case_no = 2024/406
trn_rcms_caseregid = 13124000008327
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008733
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008704
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:57
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=11/09/2024 00:00:00
Param Type = c
case_no=2024/406
Param Type = c
trn_rcms_caseregid=13124000008327
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 18
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13208000009365 idvalue 0
Mapped case_no Row = 1 value = 2024/407 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 13208000009365
case_no = 2024/407
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 15408000008734
MapName trcmf1
SourceId 15408000008705
Select sysdate as sdt from dual
Time elapsed = 9
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 = 18678000000000
hearing_date = 11/09/2024
case_no = 2024/407
trn_rcms_caseregid = 13208000009365
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008734
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008705
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:57
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=11/09/2024 00:00:00
Param Type = c
case_no=2024/407
Param Type = c
trn_rcms_caseregid=13208000009365
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 19
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13262000009266 idvalue 0
Mapped case_no Row = 1 value = 2024/408 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 13262000009266
case_no = 2024/408
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15408000008735
MapName trcmf1
SourceId 15408000008706
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 30
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/09/2024
case_no = 2024/408
trn_rcms_caseregid = 13262000009266
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008735
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008706
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:57
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=11/09/2024 00:00:00
Param Type = c
case_no=2024/408
Param Type = c
trn_rcms_caseregid=13262000009266
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 20
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13367000008601 idvalue 0
Mapped case_no Row = 1 value = 2024/409 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 13367000008601
case_no = 2024/409
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008736
MapName trcmf1
SourceId 15408000008707
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/09/2024
case_no = 2024/409
trn_rcms_caseregid = 13367000008601
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008736
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008707
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:58
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2024/409
Param Type = c
trn_rcms_caseregid=13367000008601
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 21
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13465000008304 idvalue 0
Mapped case_no Row = 1 value = 2024/410 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 13465000008304
case_no = 2024/410
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 15408000008737
MapName trcmf1
SourceId 15408000008708
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/09/2024
case_no = 2024/410
trn_rcms_caseregid = 13465000008304
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008737
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008708
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:58
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2024/410
Param Type = c
trn_rcms_caseregid=13465000008304
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 22
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13504000008973 idvalue 0
Mapped case_no Row = 1 value = 2024/411 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 13504000008973
case_no = 2024/411
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008738
MapName trcmf1
SourceId 15408000008709
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 = 11/09/2024
case_no = 2024/411
trn_rcms_caseregid = 13504000008973
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008738
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008709
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:58
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2024/411
Param Type = c
trn_rcms_caseregid=13504000008973
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 23
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13476000009355 idvalue 0
Mapped case_no Row = 1 value = 2024/415 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 13476000009355
case_no = 2024/415
prev_hearing_date = 28/08/2024
hearing_date = 09/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15408000008739
MapName trcmf1
SourceId 15408000008710
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/09/2024
case_no = 2024/415
trn_rcms_caseregid = 13476000009355
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008739
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008710
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:58
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/09/2024 00:00:00
Param Type = c
case_no=2024/415
Param Type = c
trn_rcms_caseregid=13476000009355
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 24
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10019000008541 idvalue 0
Mapped case_no Row = 1 value = 2024/426 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 10019000008541
case_no = 2024/426
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15408000008740
MapName trcmf1
SourceId 15408000008711
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 11/09/2024
case_no = 2024/426
trn_rcms_caseregid = 10019000008541
court_code = 10480
case_purpose = 18678000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008740
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008711
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:58
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2024/426
Param Type = c
trn_rcms_caseregid=10019000008541
Param Type = c
court_code=10480
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 25
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15744000005675 idvalue 0
Mapped case_no Row = 1 value = 2021/24 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 15744000005675
case_no = 2021/24
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purposename=??????? ???? ???????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ???? ???????
Time elapsed = 7
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15408000008741
MapName trcmf1
SourceId 15408000008712
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 11/09/2024
case_no = 2021/24
trn_rcms_caseregid = 15744000005675
court_code = 10480
case_purpose = 18472000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008741
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008712
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:58
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2021/24
Param Type = c
trn_rcms_caseregid=15744000005675
Param Type = c
court_code=10480
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 26
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16064000006037 idvalue 0
Mapped case_no Row = 1 value = 2022/127 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 16064000006037
case_no = 2022/127
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
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 = 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 = 15408000008742
MapName trcmf1
SourceId 15408000008713
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 11/09/2024
case_no = 2022/127
trn_rcms_caseregid = 16064000006037
court_code = 10480
case_purpose = 18472000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008742
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008713
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:59
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=18472000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2022/127
Param Type = c
trn_rcms_caseregid=16064000006037
Param Type = c
court_code=10480
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 27
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11731000008620 idvalue 0
Mapped case_no Row = 1 value = 2023/319 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/08/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 11731000008620
case_no = 2023/319
prev_hearing_date = 28/08/2024
hearing_date = 30/08/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 15
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 15408000008743
MapName trcmf1
SourceId 15408000008714
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 30/08/2024
case_no = 2023/319
trn_rcms_caseregid = 11731000008620
court_code = 10480
case_purpose = 18472000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008743
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008714
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:59
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=18472000000000
Param Type = c
hearing_date=30/08/2024 00:00:00
Param Type = c
case_no=2023/319
Param Type = c
trn_rcms_caseregid=11731000008620
Param Type = c
court_code=10480
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 28
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17743000007700 idvalue 0
Mapped case_no Row = 1 value = 2023/72 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 17743000007700
case_no = 2023/72
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 15408000008744
MapName trcmf1
SourceId 15408000008715
Select sysdate as sdt from dual
Time elapsed = 8
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 = 18472000000000
hearing_date = 11/09/2024
case_no = 2023/72
trn_rcms_caseregid = 17743000007700
court_code = 10480
case_purpose = 18472000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008744
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008715
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:59
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=18472000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2023/72
Param Type = c
trn_rcms_caseregid=17743000007700
Param Type = c
court_code=10480
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 29
>>Mapping
Mapped court_code Row = 1 value = 10480 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10960000007735 idvalue 0
Mapped case_no Row = 1 value = 2024/50 idvalue 0
Mapped prev_hearing_date Row = 1 value = 28/08/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 11/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 10480
trn_rcms_caseregid = 10960000007735
case_no = 2024/50
prev_hearing_date = 28/08/2024
hearing_date = 11/09/2024
prev_case_purposename = ??????? ???? ???????
prev_case_purpose =
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15408000008745
MapName trcmf1
SourceId 15408000008716
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 = 18472000000000
hearing_date = 11/09/2024
case_no = 2024/50
trn_rcms_caseregid = 10960000007735
court_code = 10480
case_purpose = 18472000000000
prev_hearing_date = 28/08/2024
Posting record
Param Type = n
trn_rcms_case_histid=15408000008745
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15408000008716
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chidava
Param Type = c
createdon=29/08/2024 10:48:59
Param Type = c
username=SDO_Chidava
Param Type = c
modifiedon=29/08/2024 10:48: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=18472000000000
Param Type = c
hearing_date=11/09/2024 00:00:00
Param Type = c
case_no=2024/50
Param Type = c
trn_rcms_caseregid=10960000007735
Param Type = c
court_code=10480
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=28/08/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
Time elapsed for Gen Map = 3934090130694
Time elapsed for MD Map = 3934090130695
Time elapsed for Save History = 3934090130696
Time elapsed for Save Attachment = 3934090130697
Time elapsed for After Save WF Exec = 3934090130700
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"15408000008687"}]}
Savedata webservice completed
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=SDO_Chidava
Param Type = c
calledon=29/08/2024 10:48:41
Param Type = c
callfinished=29/08/2024 10:48:50
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=9204
Param Type = n
dbtimetaken=5866
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