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
gcmsADM_Beawar_R827ccb0eea8a706c4c34a16891f84e7b![]()
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=ADM_Beawar_R
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=ADM_Beawar_R
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=ADM_Beawar_R
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=ADM_Beawar_R
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = ADM
Result = ADM
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=ADM_Beawar_R
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=ADM_Beawar_R
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 1584550008007
Result = 1584550008007
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=ADM_Beawar_R
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1246330009858
Result = 1246330009858
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=ADM_Beawar_R
Time elapsed = 10
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = ADM_Beawar_R
Result = ADM_Beawar_R
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=ADM_Beawar_R
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 18203
Result = 18203
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 = 5
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=ADM_Beawar_R
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ADM_Beawar_R
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Beawer
Result = Beawer
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=ADM_Beawar_R
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ADM_Beawar_R
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m8},{COURT_CATEGOTY})
Calling function sqlget
Result of sqlget = 10593000000007
Result = 10593000000007
Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
Calling function firesql
login_userid=1246330009858
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1246330009858
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=ADM_Beawar_R
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10824000000000
Result = 10824000000000
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=ADM_Beawar_R
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=ADM_Beawar_R
Time elapsed = 9
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=ADM_Beawar_R
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=ADM_Beawar_R
Time elapsed = 11
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 1
Result = 1
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 = 6
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 12
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_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 = 7
Step4
tstructs\stm size:2075
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Evaluating date()
Result =
Evaluating iif((next_hear_date>Validating trcmf
>>Frame No 1
courtcode = 18203
hearing_date = 21/06/2024
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 4
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=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 = 13312000008682
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
hearing_date = 21/06/2024
courtcode = 18203
Posting record
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:06
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=21/06/2024 00:00:00
Param Type = c
courtcode=18203
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 = 8
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13312000008683
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
case_no = 2024/242
isadjourn = NO
adjourn_type = 0
trn_rcms_caseid = 18052000009301
adjourn_remark =
pre_case_purpose = 1000492
court_code = 18203
pre_hear_date = 21/06/2024
next_hear_date = 05/12/2024
new_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=13312000008683
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:06
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2024/242
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18052000009301
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=18203
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
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,case_no,isadjourn,adjourn_type,trn_rcms_caseid,adjourn_remark,pre_case_purpose,court_code,pre_hear_date,next_hear_date,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,:case_no,:isadjourn,:adjourn_type,:trn_rcms_caseid,null,:pre_case_purpose,: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,: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 = 5
RecordId = 13312000008684
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_case_purpose = 1000492
new_case_purpose = 1000492
pre_hear_date = 21/06/2024
court_code = 18203
case_no = 2024/243
trn_rcms_caseid = 18110000009279
adjourn_type = 0
adjourn_remark =
next_hear_date = 05/12/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=13312000008684
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:06
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = c
court_code=18203
Param Type = c
case_no=2024/243
Param Type = c
trn_rcms_caseid=18110000009279
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,new_case_purpose,pre_hear_date,court_code,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 13312000008685
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 05/12/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/244
court_code = 18203
trn_rcms_caseid = 18193000007636
pre_case_purpose = 1000492
pre_hear_date = 21/06/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=13312000008685
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:06
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/244
Param Type = c
court_code=18203
Param Type = c
trn_rcms_caseid=18193000007636
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/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,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 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13312000008686
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 21/06/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 18239000008900
court_code = 18203
case_no = 2024/245
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 05/12/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=13312000008686
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:06
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=18239000008900
Param Type = c
court_code=18203
Param Type = c
case_no=2024/245
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=05/12/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 = 6
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 = 13312000008687
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 05/12/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/246
court_code = 18203
trn_rcms_caseid = 15774000009604
pre_case_purpose = 1000492
pre_hear_date = 21/06/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=13312000008687
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:06
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/246
Param Type = c
court_code=18203
Param Type = c
trn_rcms_caseid=15774000009604
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008688
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 05/12/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/247
court_code = 18203
trn_rcms_caseid = 15889000008582
pre_case_purpose = 1000492
pre_hear_date = 21/06/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=13312000008688
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:06
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/247
Param Type = c
court_code=18203
Param Type = c
trn_rcms_caseid=15889000008582
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/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,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008689
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 05/12/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/248
court_code = 18203
trn_rcms_caseid = 16032000009638
pre_case_purpose = 1000492
pre_hear_date = 21/06/2024
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=13312000008689
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:06
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/248
Param Type = c
court_code=18203
Param Type = c
trn_rcms_caseid=16032000009638
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13312000008690
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 05/12/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/249
court_code = 18203
trn_rcms_caseid = 18006000008752
pre_case_purpose = 1000492
pre_hear_date = 21/06/2024
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=13312000008690
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:07
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/249
Param Type = c
court_code=18203
Param Type = c
trn_rcms_caseid=18006000008752
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/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,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 = 8
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008691
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 05/12/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/250
court_code = 18203
trn_rcms_caseid = 18096000008163
pre_case_purpose = 1000492
pre_hear_date = 21/06/2024
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=13312000008691
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:07
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/250
Param Type = c
court_code=18203
Param Type = c
trn_rcms_caseid=18096000008163
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13312000008692
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 21/06/2024
pre_case_purpose = 1000492
court_code = 18203
case_no = 2024/251
trn_rcms_caseid = 18320000009275
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 05/12/2024
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=13312000008692
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:07
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=18203
Param Type = c
case_no=2024/251
Param Type = c
trn_rcms_caseid=18320000009275
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,court_code,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,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,: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 = 6
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 = 13312000008693
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 05/12/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/252
trn_rcms_caseid = 18376000008639
court_code = 18203
pre_case_purpose = 1000492
pre_hear_date = 21/06/2024
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=13312000008693
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:07
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/252
Param Type = c
trn_rcms_caseid=18376000008639
Param Type = c
court_code=18203
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,trn_rcms_caseid,court_code,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,:trn_rcms_caseid,:court_code,: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 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 13312000008694
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
court_code = 18203
case_no = 2024/253
pre_case_purpose = 1000492
new_case_purpose = 1000492
next_hear_date = 05/12/2024
adjourn_remark =
adjourn_type = 0
isadjourn = NO
trn_rcms_caseid = 18422000010769
pre_hear_date = 21/06/2024
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=13312000008694
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:07
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=18203
Param Type = c
case_no=2024/253
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=18422000010769
Param Type = c
pre_hear_date=21/06/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,court_code,case_no,pre_case_purpose,new_case_purpose,next_hear_date,adjourn_remark,adjourn_type,isadjourn,trn_rcms_caseid,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:case_no,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:isadjourn,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008695
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trn_rcms_caseid = 19899000008303
court_code = 18203
adjourn_remark =
adjourn_type = 0
isadjourn = NO
next_hear_date = 05/12/2024
new_case_purpose = 1000492
pre_hear_date = 21/06/2024
pre_case_purpose = 1000492
case_no = 2024/254
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=13312000008695
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:07
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=19899000008303
Param Type = c
court_code=18203
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
case_no=2024/254
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,court_code,adjourn_remark,adjourn_type,isadjourn,next_hear_date,new_case_purpose,pre_hear_date,pre_case_purpose,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,:court_code,null,:adjourn_type,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008696
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 05/12/2024
case_no = 2024/255
court_code = 18203
trn_rcms_caseid = 19954000008280
pre_case_purpose = 1000492
pre_hear_date = 21/06/2024
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=13312000008696
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:07
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/255
Param Type = c
court_code=18203
Param Type = c
trn_rcms_caseid=19954000008280
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/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 = 6
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008697
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 21/06/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 16585000009162
court_code = 18203
case_no = 2024/256
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 05/12/2024
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=13312000008697
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:07
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=16585000009162
Param Type = c
court_code=18203
Param Type = c
case_no=2024/256
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008698
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 21/06/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 16706000009596
court_code = 18203
case_no = 2024/257
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 05/12/2024
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=13312000008698
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:08
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=16706000009596
Param Type = c
court_code=18203
Param Type = c
case_no=2024/257
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=05/12/2024 00:00:00
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,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 16
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008699
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 05/12/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/258
court_code = 18203
trn_rcms_caseid = 16810000009466
pre_case_purpose = 1000492
pre_hear_date = 21/06/2024
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=13312000008699
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:08
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/258
Param Type = c
court_code=18203
Param Type = c
trn_rcms_caseid=16810000009466
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008700
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 17
pre_hear_date = 21/06/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 16936000008575
court_code = 18203
case_no = 2024/259
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 05/12/2024
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=13312000008700
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:08
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=16936000008575
Param Type = c
court_code=18203
Param Type = c
case_no=2024/259
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=05/12/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,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 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008701
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
pre_case_purpose = 1000492
court_code = 18203
pre_hear_date = 21/06/2024
case_no = 2024/260
trn_rcms_caseid = 16981000009446
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 05/12/2024
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=13312000008701
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:08
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=18203
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = c
case_no=2024/260
Param Type = c
trn_rcms_caseid=16981000009446
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=05/12/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 = 7
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 = 6
RecordId = 13312000008702
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
adjourn_type = 0
pre_case_purpose = 1000492
isadjourn = NO
next_hear_date = 05/12/2024
new_case_purpose = 1000492
pre_hear_date = 21/06/2024
court_code = 18203
case_no = 2024/261
trn_rcms_caseid = 17079000008878
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=13312000008702
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:08
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = c
court_code=18203
Param Type = c
case_no=2024/261
Param Type = c
trn_rcms_caseid=17079000008878
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,adjourn_type,pre_case_purpose,isadjourn,next_hear_date,new_case_purpose,pre_hear_date,court_code,case_no,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:pre_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,: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 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13312000008703
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 05/12/2024
new_case_purpose = 1000492
pre_case_purpose = 1000492
case_no = 2024/262
trn_rcms_caseid = 17223000009811
pre_hear_date = 21/06/2024
court_code = 18203
adjourn_remark =
adjourn_type = 0
isadjourn = NO
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=13312000008703
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:08
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
case_no=2024/262
Param Type = c
trn_rcms_caseid=17223000009811
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = c
court_code=18203
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,pre_case_purpose,case_no,trn_rcms_caseid,pre_hear_date,court_code,adjourn_remark,adjourn_type,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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,null,:adjourn_type,: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 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13312000008704
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trn_rcms_caseid = 17307000008960
new_case_purpose = 1000492
next_hear_date = 05/12/2024
pre_case_purpose = 1000492
court_code = 18203
case_no = 2024/263
pre_hear_date = 21/06/2024
adjourn_type = 0
isadjourn = NO
adjourn_remark =
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=13312000008704
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:08
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=17307000008960
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=18203
Param Type = c
case_no=2024/263
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
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,trn_rcms_caseid,new_case_purpose,next_hear_date,pre_case_purpose,court_code,case_no,pre_hear_date,adjourn_type,isadjourn,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,: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 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 13312000008705
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 05/12/2024
isadjourn = NO
new_case_purpose = 1000492
pre_hear_date = 21/06/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 17355000008737
court_code = 18203
adjourn_remark =
case_no = 2024/264
adjourn_type = 0
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=13312000008705
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:08
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/12/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=17355000008737
Param Type = c
court_code=18203
Param Type = c
case_no=2024/264
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,new_case_purpose,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,adjourn_remark,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,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,null,:case_no,:adjourn_type,: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 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008706
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 21/06/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 17383000010194
court_code = 18203
case_no = 2024/265
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 05/12/2024
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=13312000008706
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:08
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=17383000010194
Param Type = c
court_code=18203
Param Type = c
case_no=2024/265
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=05/12/2024 00:00:00
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,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 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13312000008707
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 21/06/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 18293000008870
court_code = 18203
case_no = 2024/266
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 10/12/2024
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=13312000008707
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:09
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=18293000008870
Param Type = c
court_code=18203
Param Type = c
case_no=2024/266
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=10/12/2024 00:00:00
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,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 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13312000008708
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 10/12/2024
new_case_purpose = 1000492
adjourn_type = 0
isadjourn = NO
pre_case_purpose = 1000492
case_no = 2024/267
court_code = 18203
pre_hear_date = 21/06/2024
trn_rcms_caseid = 18583000007510
adjourn_remark =
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=13312000008708
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:09
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=10/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=1000492
Param Type = c
case_no=2024/267
Param Type = c
court_code=18203
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = c
trn_rcms_caseid=18583000007510
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,next_hear_date,new_case_purpose,adjourn_type,isadjourn,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:isadjourn,:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13312000008709
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
new_case_purpose = 1000492
next_hear_date = 10/12/2024
trn_rcms_caseid = 18836000010848
pre_hear_date = 21/06/2024
pre_case_purpose = 1000492
adjourn_type = 0
adjourn_remark =
isadjourn = NO
court_code = 18203
case_no = 2024/268
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=13312000008709
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:09
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=10/12/2024 00:00:00
Param Type = c
trn_rcms_caseid=18836000010848
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
court_code=18203
Param Type = c
case_no=2024/268
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,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_hear_date,pre_case_purpose,adjourn_type,adjourn_remark,isadjourn,court_code,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,: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,:adjourn_type,null,:isadjourn,:court_code,:case_no,: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 28 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13312000008710
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 21/06/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 19304000008570
court_code = 18203
case_no = 2024/269
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 10/12/2024
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=13312000008710
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:09
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=19304000008570
Param Type = c
court_code=18203
Param Type = c
case_no=2024/269
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=10/12/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,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 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008711
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 21/06/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 19500000008932
court_code = 18203
case_no = 2024/270
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 10/12/2024
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=13312000008711
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:09
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=19500000008932
Param Type = c
court_code=18203
Param Type = c
case_no=2024/270
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=10/12/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,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 30 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008712
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
new_case_purpose = 1000492
pre_case_purpose = 1000492
isadjourn = NO
next_hear_date = 10/12/2024
case_no = 2024/271
court_code = 18203
pre_hear_date = 21/06/2024
trn_rcms_caseid = 15642000009370
adjourn_type = 0
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=13312000008712
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:09
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/271
Param Type = c
court_code=18203
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = c
trn_rcms_caseid=15642000009370
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,new_case_purpose,pre_case_purpose,isadjourn,next_hear_date,case_no,court_code,pre_hear_date,trn_rcms_caseid,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,null,:new_case_purpose,:pre_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 31 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13312000008713
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 4
trn_rcms_caseid = 16109000009661
case_no = 2024/272
pre_case_purpose = 1000492
pre_hear_date = 21/06/2024
next_hear_date = 10/12/2024
adjourn_type = 0
isadjourn = NO
adjourn_remark =
court_code = 18203
new_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=13312000008713
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:09
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=16109000009661
Param Type = c
case_no=2024/272
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = c
next_hear_date=10/12/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
court_code=18203
Param Type = c
new_case_purpose=1000492
Param Type = n
trn_rcms_hearingrow=31
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_case_purpose,pre_hear_date,next_hear_date,adjourn_type,isadjourn,adjourn_remark,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,:trn_rcms_caseid,:case_no,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:court_code,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 32 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008714
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 16326000010094
pre_hear_date = 21/06/2024
court_code = 18203
case_no = 2024/273
next_hear_date = 10/12/2024
isadjourn = NO
pre_case_purpose = 1000492
new_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=13312000008714
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:09
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=16326000010094
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = c
court_code=18203
Param Type = c
case_no=2024/273
Param Type = c
next_hear_date=10/12/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
Param Type = n
trn_rcms_hearingrow=32
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 = 7
Adding new record to store data from Frame 2, Row 33 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 13312000008715
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
adjourn_type = 0
adjourn_remark =
pre_hear_date = 21/06/2024
trn_rcms_caseid = 17861000009484
new_case_purpose = 1000492
pre_case_purpose = 1000492
next_hear_date = 10/12/2024
isadjourn = NO
case_no = 2024/274
court_code = 18203
TRN_RCMS_HEARINGrow = 33
Posting record
Param Type = n
trn_rcms_hearingid=13312000008715
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:09
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = c
trn_rcms_caseid=17861000009484
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
next_hear_date=10/12/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/274
Param Type = c
court_code=18203
Param Type = n
trn_rcms_hearingrow=33
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,pre_hear_date,trn_rcms_caseid,new_case_purpose,pre_case_purpose,next_hear_date,isadjourn,case_no,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:court_code,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 29
Adding new record to store data from Frame 2, Row 34 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 9
RecordId = 13312000008716
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 11
adjourn_type = 0
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 17960000009460
case_no = 2024/275
court_code = 18203
pre_hear_date = 21/06/2024
next_hear_date = 10/12/2024
new_case_purpose = 1000492
pre_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 34
Posting record
Param Type = n
trn_rcms_hearingid=13312000008716
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:10
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:10
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=17960000009460
Param Type = c
case_no=2024/275
Param Type = c
court_code=18203
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = c
next_hear_date=10/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = n
trn_rcms_hearingrow=34
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 = 7
Adding new record to store data from Frame 2, Row 35 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 13312000008717
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
isadjourn = NO
adjourn_type = 0
adjourn_remark =
case_no = 2024/276
court_code = 18203
pre_hear_date = 21/06/2024
trn_rcms_caseid = 18083000011277
next_hear_date = 10/12/2024
new_case_purpose = 1000492
pre_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 35
Posting record
Param Type = n
trn_rcms_hearingid=13312000008717
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:10
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:10
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
case_no=2024/276
Param Type = c
court_code=18203
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = c
trn_rcms_caseid=18083000011277
Param Type = c
next_hear_date=10/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = n
trn_rcms_hearingrow=35
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,case_no,court_code,pre_hear_date,trn_rcms_caseid,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,:case_no,:court_code,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'),:new_case_purpose,:pre_case_purpose,: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 36 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008718
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 10/12/2024
trn_rcms_caseid = 18121000009821
case_no = 2024/277
court_code = 18203
new_case_purpose = 1000492
pre_case_purpose = 1000492
pre_hear_date = 21/06/2024
TRN_RCMS_HEARINGrow = 36
Posting record
Param Type = n
trn_rcms_hearingid=13312000008718
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:10
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:10
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=10/12/2024 00:00:00
Param Type = c
trn_rcms_caseid=18121000009821
Param Type = c
case_no=2024/277
Param Type = c
court_code=18203
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=36
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 8
Adding new record to store data from Frame 2, Row 37 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008719
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 10/12/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 18164000009473
court_code = 18203
case_no = 2024/278
new_case_purpose = 1000492
pre_case_purpose = 1000492
pre_hear_date = 21/06/2024
TRN_RCMS_HEARINGrow = 37
Posting record
Param Type = n
trn_rcms_hearingid=13312000008719
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:10
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=10/12/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18164000009473
Param Type = c
court_code=18203
Param Type = c
case_no=2024/278
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=37
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,court_code,case_no,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:court_code,:case_no,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 10
Adding new record to store data from Frame 2, Row 38 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 13312000008720
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 10/12/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 1000492
case_no = 2024/279
court_code = 18203
trn_rcms_caseid = 18225000007709
pre_case_purpose = 1000492
pre_hear_date = 21/06/2024
TRN_RCMS_HEARINGrow = 38
Posting record
Param Type = n
trn_rcms_hearingid=13312000008720
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:10
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=10/12/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000492
Param Type = c
case_no=2024/279
Param Type = c
court_code=18203
Param Type = c
trn_rcms_caseid=18225000007709
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=38
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 = 7
Adding new record to store data from Frame 2, Row 39 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13312000008721
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 10/12/2024
new_case_purpose = 1000492
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2024/280
court_code = 18203
trn_rcms_caseid = 18274000010511
pre_case_purpose = 1000492
pre_hear_date = 21/06/2024
TRN_RCMS_HEARINGrow = 39
Posting record
Param Type = n
trn_rcms_hearingid=13312000008721
Param Type = n
trn_rcms_mhearingid=13312000008682
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:10
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=10/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/280
Param Type = c
court_code=18203
Param Type = c
trn_rcms_caseid=18274000010511
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=21/06/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=39
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 = 3941197458048
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18052000009301 idvalue 0
Mapped case_no Row = 1 value = 2024/242 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18052000009301
case_no = 2024/242
prev_hearing_date = 21/06/2024
hearing_date = 05/12/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 = 8
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 8
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008722
MapName trcmf1
SourceId 13312000008683
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/242
trn_rcms_caseregid = 18052000009301
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008722
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008683
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:10
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/242
Param Type = c
trn_rcms_caseregid=18052000009301
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 2
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18110000009279 idvalue 0
Mapped case_no Row = 1 value = 2024/243 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18110000009279
case_no = 2024/243
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 212
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 = 13312000008723
MapName trcmf1
SourceId 13312000008684
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/243
trn_rcms_caseregid = 18110000009279
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008723
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008684
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:13
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/243
Param Type = c
trn_rcms_caseregid=18110000009279
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 3
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18193000007636 idvalue 0
Mapped case_no Row = 1 value = 2024/244 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18193000007636
case_no = 2024/244
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 5
RecordId = 13312000008724
MapName trcmf1
SourceId 13312000008685
Select sysdate as sdt from dual
Time elapsed = 8
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 = 1000492
hearing_date = 05/12/2024
case_no = 2024/244
trn_rcms_caseregid = 18193000007636
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008724
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008685
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:15
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:15
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/244
Param Type = c
trn_rcms_caseregid=18193000007636
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 4
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18239000008900 idvalue 0
Mapped case_no Row = 1 value = 2024/245 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18239000008900
case_no = 2024/245
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008725
MapName trcmf1
SourceId 13312000008686
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/245
trn_rcms_caseregid = 18239000008900
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008725
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008686
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:16
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:16
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/245
Param Type = c
trn_rcms_caseregid=18239000008900
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 5
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15774000009604 idvalue 0
Mapped case_no Row = 1 value = 2024/246 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 15774000009604
case_no = 2024/246
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008726
MapName trcmf1
SourceId 13312000008687
Select sysdate as sdt from dual
Time elapsed = 9
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 = 1000492
hearing_date = 05/12/2024
case_no = 2024/246
trn_rcms_caseregid = 15774000009604
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008726
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008687
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:18
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/246
Param Type = c
trn_rcms_caseregid=15774000009604
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 6
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15889000008582 idvalue 0
Mapped case_no Row = 1 value = 2024/247 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 15889000008582
case_no = 2024/247
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008727
MapName trcmf1
SourceId 13312000008688
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/247
trn_rcms_caseregid = 15889000008582
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008727
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008688
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:20
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/247
Param Type = c
trn_rcms_caseregid=15889000008582
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 7
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16032000009638 idvalue 0
Mapped case_no Row = 1 value = 2024/248 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 16032000009638
case_no = 2024/248
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 17
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 = 13312000008728
MapName trcmf1
SourceId 13312000008689
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 = 1000492
hearing_date = 05/12/2024
case_no = 2024/248
trn_rcms_caseregid = 16032000009638
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008728
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008689
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:22
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/248
Param Type = c
trn_rcms_caseregid=16032000009638
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 8
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18006000008752 idvalue 0
Mapped case_no Row = 1 value = 2024/249 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18006000008752
case_no = 2024/249
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 14
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 = 13312000008729
MapName trcmf1
SourceId 13312000008690
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/249
trn_rcms_caseregid = 18006000008752
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008729
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008690
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:23
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/249
Param Type = c
trn_rcms_caseregid=18006000008752
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 9
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18096000008163 idvalue 0
Mapped case_no Row = 1 value = 2024/250 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18096000008163
case_no = 2024/250
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008730
MapName trcmf1
SourceId 13312000008691
Select sysdate as sdt from dual
Time elapsed = 10
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 = 1000492
hearing_date = 05/12/2024
case_no = 2024/250
trn_rcms_caseregid = 18096000008163
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008730
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008691
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:25
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/250
Param Type = c
trn_rcms_caseregid=18096000008163
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 10
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18320000009275 idvalue 0
Mapped case_no Row = 1 value = 2024/251 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18320000009275
case_no = 2024/251
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 7
RecordId = 13312000008731
MapName trcmf1
SourceId 13312000008692
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/251
trn_rcms_caseregid = 18320000009275
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008731
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008692
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:27
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/251
Param Type = c
trn_rcms_caseregid=18320000009275
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 11
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18376000008639 idvalue 0
Mapped case_no Row = 1 value = 2024/252 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18376000008639
case_no = 2024/252
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 11
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 = 13312000008732
MapName trcmf1
SourceId 13312000008693
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/252
trn_rcms_caseregid = 18376000008639
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008732
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008693
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:29
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/252
Param Type = c
trn_rcms_caseregid=18376000008639
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 12
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18422000010769 idvalue 0
Mapped case_no Row = 1 value = 2024/253 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18422000010769
case_no = 2024/253
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 13312000008733
MapName trcmf1
SourceId 13312000008694
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 14
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/253
trn_rcms_caseregid = 18422000010769
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008733
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008694
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:30
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/253
Param Type = c
trn_rcms_caseregid=18422000010769
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 13
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19899000008303 idvalue 0
Mapped case_no Row = 1 value = 2024/254 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 19899000008303
case_no = 2024/254
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008734
MapName trcmf1
SourceId 13312000008695
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/254
trn_rcms_caseregid = 19899000008303
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008734
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008695
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:32
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/254
Param Type = c
trn_rcms_caseregid=19899000008303
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 14
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19954000008280 idvalue 0
Mapped case_no Row = 1 value = 2024/255 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 19954000008280
case_no = 2024/255
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 18
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 = 13312000008735
MapName trcmf1
SourceId 13312000008696
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 = 1000492
hearing_date = 05/12/2024
case_no = 2024/255
trn_rcms_caseregid = 19954000008280
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008735
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008696
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:34
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/255
Param Type = c
trn_rcms_caseregid=19954000008280
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 15
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16585000009162 idvalue 0
Mapped case_no Row = 1 value = 2024/256 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 16585000009162
case_no = 2024/256
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008736
MapName trcmf1
SourceId 13312000008697
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/256
trn_rcms_caseregid = 16585000009162
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008736
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008697
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:36
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/256
Param Type = c
trn_rcms_caseregid=16585000009162
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 16
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16706000009596 idvalue 0
Mapped case_no Row = 1 value = 2024/257 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 16706000009596
case_no = 2024/257
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008737
MapName trcmf1
SourceId 13312000008698
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/257
trn_rcms_caseregid = 16706000009596
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008737
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008698
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:38
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/257
Param Type = c
trn_rcms_caseregid=16706000009596
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 17
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16810000009466 idvalue 0
Mapped case_no Row = 1 value = 2024/258 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 16810000009466
case_no = 2024/258
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008738
MapName trcmf1
SourceId 13312000008699
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/258
trn_rcms_caseregid = 16810000009466
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008738
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008699
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:39
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/258
Param Type = c
trn_rcms_caseregid=16810000009466
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 18
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16936000008575 idvalue 0
Mapped case_no Row = 1 value = 2024/259 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 16936000008575
case_no = 2024/259
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008739
MapName trcmf1
SourceId 13312000008700
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/259
trn_rcms_caseregid = 16936000008575
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008739
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008700
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:41
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/259
Param Type = c
trn_rcms_caseregid=16936000008575
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 19
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16981000009446 idvalue 0
Mapped case_no Row = 1 value = 2024/260 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 16981000009446
case_no = 2024/260
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 13312000008740
MapName trcmf1
SourceId 13312000008701
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 = 1000492
hearing_date = 05/12/2024
case_no = 2024/260
trn_rcms_caseregid = 16981000009446
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008740
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008701
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:43
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/260
Param Type = c
trn_rcms_caseregid=16981000009446
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 20
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17079000008878 idvalue 0
Mapped case_no Row = 1 value = 2024/261 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 17079000008878
case_no = 2024/261
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 5
RecordId = 13312000008741
MapName trcmf1
SourceId 13312000008702
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 = 1000492
hearing_date = 05/12/2024
case_no = 2024/261
trn_rcms_caseregid = 17079000008878
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008741
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008702
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:45
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/261
Param Type = c
trn_rcms_caseregid=17079000008878
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 21
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17223000009811 idvalue 0
Mapped case_no Row = 1 value = 2024/262 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 17223000009811
case_no = 2024/262
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 6
RecordId = 13312000008742
MapName trcmf1
SourceId 13312000008703
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/262
trn_rcms_caseregid = 17223000009811
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008742
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008703
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:47
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/262
Param Type = c
trn_rcms_caseregid=17223000009811
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 22
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17307000008960 idvalue 0
Mapped case_no Row = 1 value = 2024/263 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 17307000008960
case_no = 2024/263
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008743
MapName trcmf1
SourceId 13312000008704
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/263
trn_rcms_caseregid = 17307000008960
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008743
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008704
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:48
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/263
Param Type = c
trn_rcms_caseregid=17307000008960
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 23
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17355000008737 idvalue 0
Mapped case_no Row = 1 value = 2024/264 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 17355000008737
case_no = 2024/264
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008744
MapName trcmf1
SourceId 13312000008705
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 = 1000492
hearing_date = 05/12/2024
case_no = 2024/264
trn_rcms_caseregid = 17355000008737
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008744
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008705
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:50
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/264
Param Type = c
trn_rcms_caseregid=17355000008737
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 24
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17383000010194 idvalue 0
Mapped case_no Row = 1 value = 2024/265 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 05/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 17383000010194
case_no = 2024/265
prev_hearing_date = 21/06/2024
hearing_date = 05/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13312000008745
MapName trcmf1
SourceId 13312000008706
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 05/12/2024
case_no = 2024/265
trn_rcms_caseregid = 17383000010194
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008745
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008706
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:52
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=05/12/2024 00:00:00
Param Type = c
case_no=2024/265
Param Type = c
trn_rcms_caseregid=17383000010194
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 25
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18293000008870 idvalue 0
Mapped case_no Row = 1 value = 2024/266 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18293000008870
case_no = 2024/266
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 13312000008746
MapName trcmf1
SourceId 13312000008707
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 10/12/2024
case_no = 2024/266
trn_rcms_caseregid = 18293000008870
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008746
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008707
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:54
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10: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=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/266
Param Type = c
trn_rcms_caseregid=18293000008870
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 26
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18583000007510 idvalue 0
Mapped case_no Row = 1 value = 2024/267 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18583000007510
case_no = 2024/267
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13312000008747
MapName trcmf1
SourceId 13312000008708
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 10/12/2024
case_no = 2024/267
trn_rcms_caseregid = 18583000007510
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008747
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008708
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:56
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10: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=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/267
Param Type = c
trn_rcms_caseregid=18583000007510
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 27
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18836000010848 idvalue 0
Mapped case_no Row = 1 value = 2024/268 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18836000010848
case_no = 2024/268
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008748
MapName trcmf1
SourceId 13312000008709
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 = 1000492
hearing_date = 10/12/2024
case_no = 2024/268
trn_rcms_caseregid = 18836000010848
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008748
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008709
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:10:58
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:10: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=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/268
Param Type = c
trn_rcms_caseregid=18836000010848
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 28
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19304000008570 idvalue 0
Mapped case_no Row = 1 value = 2024/269 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 19304000008570
case_no = 2024/269
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008749
MapName trcmf1
SourceId 13312000008710
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 10/12/2024
case_no = 2024/269
trn_rcms_caseregid = 19304000008570
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008749
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008710
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:11:00
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:11:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/269
Param Type = c
trn_rcms_caseregid=19304000008570
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 29
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19500000008932 idvalue 0
Mapped case_no Row = 1 value = 2024/270 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 19500000008932
case_no = 2024/270
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008750
MapName trcmf1
SourceId 13312000008711
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 10/12/2024
case_no = 2024/270
trn_rcms_caseregid = 19500000008932
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008750
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008711
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:11:02
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:11:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/270
Param Type = c
trn_rcms_caseregid=19500000008932
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 30
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15642000009370 idvalue 0
Mapped case_no Row = 1 value = 2024/271 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 15642000009370
case_no = 2024/271
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008751
MapName trcmf1
SourceId 13312000008712
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 = 1000492
hearing_date = 10/12/2024
case_no = 2024/271
trn_rcms_caseregid = 15642000009370
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008751
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008712
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:11:04
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:11:04
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/271
Param Type = c
trn_rcms_caseregid=15642000009370
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 31
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16109000009661 idvalue 0
Mapped case_no Row = 1 value = 2024/272 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 16109000009661
case_no = 2024/272
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008752
MapName trcmf1
SourceId 13312000008713
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 10/12/2024
case_no = 2024/272
trn_rcms_caseregid = 16109000009661
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008752
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008713
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:11:06
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:11:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/272
Param Type = c
trn_rcms_caseregid=16109000009661
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 32
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16326000010094 idvalue 0
Mapped case_no Row = 1 value = 2024/273 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 16326000010094
case_no = 2024/273
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 6
RecordId = 13312000008753
MapName trcmf1
SourceId 13312000008714
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 = 1000492
hearing_date = 10/12/2024
case_no = 2024/273
trn_rcms_caseregid = 16326000010094
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008753
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008714
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:11:08
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:11:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/273
Param Type = c
trn_rcms_caseregid=16326000010094
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 33
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17861000009484 idvalue 0
Mapped case_no Row = 1 value = 2024/274 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 17861000009484
case_no = 2024/274
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 4
RecordId = 13312000008754
MapName trcmf1
SourceId 13312000008715
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 10/12/2024
case_no = 2024/274
trn_rcms_caseregid = 17861000009484
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008754
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008715
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:11:10
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:11:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/274
Param Type = c
trn_rcms_caseregid=17861000009484
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 34
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17960000009460 idvalue 0
Mapped case_no Row = 1 value = 2024/275 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 17960000009460
case_no = 2024/275
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008755
MapName trcmf1
SourceId 13312000008716
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 = 1000492
hearing_date = 10/12/2024
case_no = 2024/275
trn_rcms_caseregid = 17960000009460
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008755
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008716
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:11:13
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:11:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/275
Param Type = c
trn_rcms_caseregid=17960000009460
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 35
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18083000011277 idvalue 0
Mapped case_no Row = 1 value = 2024/276 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18083000011277
case_no = 2024/276
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008756
MapName trcmf1
SourceId 13312000008717
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 10/12/2024
case_no = 2024/276
trn_rcms_caseregid = 18083000011277
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008756
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008717
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:11:14
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:11:15
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/276
Param Type = c
trn_rcms_caseregid=18083000011277
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 36
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18121000009821 idvalue 0
Mapped case_no Row = 1 value = 2024/277 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18121000009821
case_no = 2024/277
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008757
MapName trcmf1
SourceId 13312000008718
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 10/12/2024
case_no = 2024/277
trn_rcms_caseregid = 18121000009821
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008757
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008718
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:11:16
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:11:16
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/277
Param Type = c
trn_rcms_caseregid=18121000009821
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 37
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18164000009473 idvalue 0
Mapped case_no Row = 1 value = 2024/278 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18164000009473
case_no = 2024/278
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 13312000008758
MapName trcmf1
SourceId 13312000008719
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 10/12/2024
case_no = 2024/278
trn_rcms_caseregid = 18164000009473
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008758
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008719
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:11:18
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:11:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/278
Param Type = c
trn_rcms_caseregid=18164000009473
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 38
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18225000007709 idvalue 0
Mapped case_no Row = 1 value = 2024/279 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18225000007709
case_no = 2024/279
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 13312000008759
MapName trcmf1
SourceId 13312000008720
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 10/12/2024
case_no = 2024/279
trn_rcms_caseregid = 18225000007709
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008759
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008720
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:11:20
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:11:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/279
Param Type = c
trn_rcms_caseregid=18225000007709
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
>>Posting from trcmf to tchdh from row 39
>>Mapping
Mapped court_code Row = 1 value = 18203 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18274000010511 idvalue 0
Mapped case_no Row = 1 value = 2024/280 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/06/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 10/12/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18203
trn_rcms_caseregid = 18274000010511
case_no = 2024/280
prev_hearing_date = 21/06/2024
hearing_date = 10/12/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 13312000008760
MapName trcmf1
SourceId 13312000008721
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 = 1000492
hearing_date = 10/12/2024
case_no = 2024/280
trn_rcms_caseregid = 18274000010511
court_code = 18203
case_purpose = 1000492
prev_hearing_date = 21/06/2024
Posting record
Param Type = n
trn_rcms_case_histid=13312000008760
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13312000008721
Param Type = c
cancel=F
Param Type = c
createdby=ADM_Beawar_R
Param Type = c
createdon=19/11/2024 17:11:22
Param Type = c
username=ADM_Beawar_R
Param Type = c
modifiedon=19/11/2024 17:11:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/280
Param Type = c
trn_rcms_caseregid=18274000010511
Param Type = c
court_code=18203
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=21/06/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))
Time elapsed for Gen Map = 3941197531994
Time elapsed for MD Map = 3941197531996
Time elapsed for Save History = 3941197531997
Time elapsed for Save Attachment = 3941197531998
Time elapsed for After Save WF Exec = 3941197532002
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"13312000008682"}]}
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=ADM_Beawar_R
Param Type = c
calledon=19/11/2024 17:04:12
Param Type = c
callfinished=19/11/2024 17:05:32
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=79535
Param Type = n
dbtimetaken=74845
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