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
gcmsdc_sikar827ccb0eea8a706c4c34a16891f84e7b![]()
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=dc_sikar
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=dc_sikar
Time elapsed = 9
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=dc_sikar
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=dc_sikar
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = DC
Result = DC
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=dc_sikar
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=dc_sikar
Time elapsed = 18
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 1322440008926
Result = 1322440008926
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=dc_sikar
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1795990007831
Result = 1795990007831
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=dc_sikar
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = dc_sikar
Result = dc_sikar
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=dc_sikar
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 18165
Result = 18165
Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=dc_sikar
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=dc_sikar
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Sikar
Result = Sikar
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=dc_sikar
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=dc_sikar
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=1795990007831
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1795990007831
Time elapsed = 9
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=dc_sikar
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10206000000013
Result = 10206000000013
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=dc_sikar
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=dc_sikar
Time elapsed = 7
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 = 4
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=dc_sikar
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=dc_sikar
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 2
Result = 2
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 4
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 7
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_reader,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 4
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : trcmf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 6
Step4
tstructs\stm size:2075
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Evaluating date()
Result =
Evaluating iif((next_hear_date>Validating trcmf
>>Frame No 1
courtcode = 18165
hearing_date = 12/09/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 = 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 = 15312000010300
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
hearing_date = 12/09/2024
courtcode = 18165
Posting record
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:38
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=12/09/2024 00:00:00
Param Type = c
courtcode=18165
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)
Saving to table TRN_RCMS_HEARING
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010301
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
case_no = 2024/23
isadjourn = NO
adjourn_type = 0
trn_rcms_caseid = 15585000008125
adjourn_remark =
pre_case_purpose = 12555000000002
court_code = 18165
pre_hear_date = 12/09/2024
next_hear_date = 19/11/2024
new_case_purpose = 12555000000002
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=15312000010301
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:39
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2024/23
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=15585000008125
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
court_code=18165
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = n
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 = 5
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010302
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_case_purpose = 12555000000002
new_case_purpose = 12555000000002
pre_hear_date = 12/09/2024
court_code = 18165
case_no = 2024/24
trn_rcms_caseid = 15681000007941
adjourn_type = 0
adjourn_remark =
next_hear_date = 19/11/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=15312000010302
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:39
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
new_case_purpose=12555000000002
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = c
court_code=18165
Param Type = c
case_no=2024/24
Param Type = c
trn_rcms_caseid=15681000007941
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=19/11/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 = 5
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010303
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 19/11/2024
new_case_purpose = 10189000000601
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/1050
court_code = 18165
trn_rcms_caseid = 17986000008401
pre_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=15312000010303
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:39
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
new_case_purpose=10189000000601
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/1050
Param Type = c
court_code=18165
Param Type = c
trn_rcms_caseid=17986000008401
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010304
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 12/09/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 13334000008019
court_code = 18165
case_no = 2023/1090
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 10033000000815
next_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=15312000010304
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:39
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=13334000008019
Param Type = c
court_code=18165
Param Type = c
case_no=2023/1090
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=10033000000815
Param Type = c
next_hear_date=19/11/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 = 5
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15312000010305
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 19/11/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/1099
court_code = 18165
trn_rcms_caseid = 13660000007516
pre_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=15312000010305
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:39
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/1099
Param Type = c
court_code=18165
Param Type = c
trn_rcms_caseid=13660000007516
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/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 = 5
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010306
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 19/11/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/1149
court_code = 18165
trn_rcms_caseid = 11255000008084
pre_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=15312000010306
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:39
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/1149
Param Type = c
court_code=18165
Param Type = c
trn_rcms_caseid=11255000008084
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010307
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 19/11/2024
new_case_purpose = 11472000000003
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/1150
court_code = 18165
trn_rcms_caseid = 11272000008700
pre_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=15312000010307
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:39
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
new_case_purpose=11472000000003
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/1150
Param Type = c
court_code=18165
Param Type = c
trn_rcms_caseid=11272000008700
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/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 = 5
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010308
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 20/11/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/1190
court_code = 18165
trn_rcms_caseid = 19992000008192
pre_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=15312000010308
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:39
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=20/11/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/1190
Param Type = c
court_code=18165
Param Type = c
trn_rcms_caseid=19992000008192
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010309
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 19/11/2024
new_case_purpose = 10189000000601
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/1201
court_code = 18165
trn_rcms_caseid = 15910000008081
pre_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=15312000010309
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:39
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
new_case_purpose=10189000000601
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/1201
Param Type = c
court_code=18165
Param Type = c
trn_rcms_caseid=15910000008081
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/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 = 4
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 = 3
RecordId = 15312000010310
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 12/09/2024
pre_case_purpose = 18678000000000
court_code = 18165
case_no = 2023/1206
trn_rcms_caseid = 14169000008263
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 20/11/2024
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=15312000010310
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:39
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=18165
Param Type = c
case_no=2023/1206
Param Type = c
trn_rcms_caseid=14169000008263
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=20/11/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 = 5
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010311
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 19/11/2024
new_case_purpose = 10033000000815
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/134
trn_rcms_caseid = 17730000007112
court_code = 18165
pre_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=15312000010311
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:39
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
new_case_purpose=10033000000815
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/134
Param Type = c
trn_rcms_caseid=17730000007112
Param Type = c
court_code=18165
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 4
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010312
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 4
court_code = 18165
case_no = 2023/142
pre_case_purpose = 18678000000000
new_case_purpose = 10033000000815
next_hear_date = 08/10/2024
adjourn_remark =
adjourn_type = 0
isadjourn = NO
trn_rcms_caseid = 19356000009198
pre_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=15312000010312
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:40
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=18165
Param Type = c
case_no=2023/142
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=10033000000815
Param Type = c
next_hear_date=08/10/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=19356000009198
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3
RecordId = 15312000010313
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trn_rcms_caseid = 14629000007854
court_code = 18165
adjourn_remark =
adjourn_type = 0
isadjourn = NO
next_hear_date = 20/11/2024
new_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
pre_case_purpose = 18678000000000
case_no = 2023/206
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=15312000010313
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:40
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=14629000007854
Param Type = c
court_code=18165
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=20/11/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2023/206
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 = 11
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 = 6
RecordId = 15312000010314
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 12555000000002
next_hear_date = 19/11/2024
case_no = 2023/210
court_code = 18165
trn_rcms_caseid = 14860000009015
pre_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=15312000010314
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:40
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=12555000000002
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/210
Param Type = c
court_code=18165
Param Type = c
trn_rcms_caseid=14860000009015
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/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 = 5
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010315
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 12/09/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 15809000008111
court_code = 18165
case_no = 2023/226
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 20/11/2024
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=15312000010315
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:40
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=15809000008111
Param Type = c
court_code=18165
Param Type = c
case_no=2023/226
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=20/11/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010316
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 12/09/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 19144000007625
court_code = 18165
case_no = 2023/334
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 20/11/2024
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=15312000010316
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:40
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=19144000007625
Param Type = c
court_code=18165
Param Type = c
case_no=2023/334
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=20/11/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 = 5
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010317
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 20/11/2024
new_case_purpose = 11472000000003
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2023/414
court_code = 18165
trn_rcms_caseid = 14853000008211
pre_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=15312000010317
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:40
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=20/11/2024 00:00:00
Param Type = c
new_case_purpose=11472000000003
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/414
Param Type = c
court_code=18165
Param Type = c
trn_rcms_caseid=14853000008211
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15312000010318
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 12/09/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 15301000008199
court_code = 18165
case_no = 2023/416
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 11472000000003
next_hear_date = 20/11/2024
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=15312000010318
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:40
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=15301000008199
Param Type = c
court_code=18165
Param Type = c
case_no=2023/416
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=11472000000003
Param Type = c
next_hear_date=20/11/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 = 4
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15312000010319
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_case_purpose = 18678000000000
court_code = 18165
pre_hear_date = 12/09/2024
case_no = 2023/417
trn_rcms_caseid = 15323000008237
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 10189000000601
next_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=15312000010319
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:40
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=18165
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = c
case_no=2023/417
Param Type = c
trn_rcms_caseid=15323000008237
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=10189000000601
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,court_code,pre_hear_date,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 15312000010320
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 = 18678000000000
isadjourn = NO
next_hear_date = 19/11/2024
new_case_purpose = 10033000000815
pre_hear_date = 12/09/2024
court_code = 18165
case_no = 2023/438
trn_rcms_caseid = 16834000007485
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=15312000010320
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:40
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
new_case_purpose=10033000000815
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = c
court_code=18165
Param Type = c
case_no=2023/438
Param Type = c
trn_rcms_caseid=16834000007485
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 = 16
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 = 15312000010321
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 19/11/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
case_no = 2023/462
trn_rcms_caseid = 11983000008078
pre_hear_date = 12/09/2024
court_code = 18165
adjourn_remark =
adjourn_type = 0
isadjourn = NO
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=15312000010321
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:40
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2023/462
Param Type = c
trn_rcms_caseid=11983000008078
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = c
court_code=18165
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 = 5
RecordId = 15312000010322
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trn_rcms_caseid = 12091000007350
new_case_purpose = 18678000000000
next_hear_date = 19/11/2024
pre_case_purpose = 18678000000000
court_code = 18165
case_no = 2023/468
pre_hear_date = 12/09/2024
adjourn_type = 0
isadjourn = NO
adjourn_remark =
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=15312000010322
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:41
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=12091000007350
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=18165
Param Type = c
case_no=2023/468
Param Type = c
pre_hear_date=12/09/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 = 5
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010323
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 20/11/2024
isadjourn = NO
new_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 12178000007282
court_code = 18165
adjourn_remark =
case_no = 2023/473
adjourn_type = 0
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=15312000010323
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:41
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=20/11/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=12178000007282
Param Type = c
court_code=18165
Param Type = c
case_no=2023/473
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 = 6
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15312000010324
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 12/09/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 12248000007425
court_code = 18165
case_no = 2023/475
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=15312000010324
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:41
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=12248000007425
Param Type = c
court_code=18165
Param Type = c
case_no=2023/475
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=19/11/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 = 6
RecordId = 15312000010325
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 12/09/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 12297000009207
court_code = 18165
case_no = 2023/477
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=15312000010325
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:41
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=12297000009207
Param Type = c
court_code=18165
Param Type = c
case_no=2023/477
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=19/11/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 = 8
RecordId = 15312000010326
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 19/11/2024
new_case_purpose = 11472000000003
adjourn_type = 0
isadjourn = NO
pre_case_purpose = 18678000000000
case_no = 2023/481
court_code = 18165
pre_hear_date = 12/09/2024
trn_rcms_caseid = 12402000007825
adjourn_remark =
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=15312000010326
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:41
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
new_case_purpose=11472000000003
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2023/481
Param Type = c
court_code=18165
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = c
trn_rcms_caseid=12402000007825
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 = 17
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 = 7
RecordId = 15312000010327
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
new_case_purpose = 18678000000000
next_hear_date = 20/11/2024
trn_rcms_caseid = 15394000008835
pre_hear_date = 12/09/2024
pre_case_purpose = 18678000000000
adjourn_type = 0
adjourn_remark =
isadjourn = NO
court_code = 18165
case_no = 2023/497
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=15312000010327
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:41
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=20/11/2024 00:00:00
Param Type = c
trn_rcms_caseid=15394000008835
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
court_code=18165
Param Type = c
case_no=2023/497
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 = 7
Adding new record to store data from Frame 2, Row 28 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15312000010328
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 26
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 12/09/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 17931000007428
court_code = 18165
case_no = 2023/524
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 20/11/2024
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=15312000010328
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:41
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=17931000007428
Param Type = c
court_code=18165
Param Type = c
case_no=2023/524
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=20/11/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 = 5
Adding new record to store data from Frame 2, Row 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15312000010329
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 26
pre_hear_date = 12/09/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 15177000006721
court_code = 18165
case_no = 2023/533
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 10033000000815
next_hear_date = 19/11/2024
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=15312000010329
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:41
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=15177000006721
Param Type = c
court_code=18165
Param Type = c
case_no=2023/533
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=10033000000815
Param Type = c
next_hear_date=19/11/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 = 16
Adding new record to store data from Frame 2, Row 30 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010330
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 = 18678000000000
pre_case_purpose = 18678000000000
isadjourn = NO
next_hear_date = 19/11/2024
case_no = 2023/625
court_code = 18165
pre_hear_date = 12/09/2024
trn_rcms_caseid = 18519000006839
adjourn_type = 0
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=15312000010330
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:41
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/625
Param Type = c
court_code=18165
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = c
trn_rcms_caseid=18519000006839
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 = 5
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 = 15312000010331
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trn_rcms_caseid = 19246000008540
case_no = 2023/658
pre_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
next_hear_date = 19/11/2024
adjourn_type = 0
isadjourn = NO
adjourn_remark =
court_code = 18165
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=15312000010331
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:41
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=19246000008540
Param Type = c
case_no=2023/658
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
court_code=18165
Param Type = c
new_case_purpose=18678000000000
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 = 4
RecordId = 15312000010332
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 18221000007420
pre_hear_date = 12/09/2024
court_code = 18165
case_no = 2023/711
next_hear_date = 04/11/2024
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=15312000010332
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:42
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18221000007420
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = c
court_code=18165
Param Type = c
case_no=2023/711
Param Type = c
next_hear_date=04/11/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=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 = 4
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 = 4
RecordId = 15312000010333
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark =
pre_hear_date = 12/09/2024
trn_rcms_caseid = 18989000008381
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
next_hear_date = 04/11/2024
isadjourn = NO
case_no = 2023/734
court_code = 18165
TRN_RCMS_HEARINGrow = 33
Posting record
Param Type = n
trn_rcms_hearingid=15312000010333
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:42
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = c
trn_rcms_caseid=18989000008381
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
next_hear_date=04/11/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2023/734
Param Type = c
court_code=18165
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 = 7
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 = 3
RecordId = 15312000010334
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_type = 0
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 19110000007876
case_no = 2023/735
court_code = 18165
pre_hear_date = 12/09/2024
next_hear_date = 04/11/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 34
Posting record
Param Type = n
trn_rcms_hearingid=15312000010334
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:42
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:42
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=19110000007876
Param Type = c
case_no=2023/735
Param Type = c
court_code=18165
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = c
next_hear_date=04/11/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
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 = 16
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 = 4
RecordId = 15312000010335
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 9
isadjourn = NO
adjourn_type = 0
adjourn_remark =
case_no = 2023/866
court_code = 18165
pre_hear_date = 12/09/2024
trn_rcms_caseid = 17935000007166
next_hear_date = 19/11/2024
new_case_purpose = 10033000000815
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 35
Posting record
Param Type = n
trn_rcms_hearingid=15312000010335
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:42
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:42
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=2023/866
Param Type = c
court_code=18165
Param Type = c
pre_hear_date=12/09/2024 00:00:00
Param Type = c
trn_rcms_caseid=17935000007166
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
new_case_purpose=10033000000815
Param Type = n
pre_case_purpose=18678000000000
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 = 7
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 = 4
RecordId = 15312000010336
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 19/11/2024
trn_rcms_caseid = 19071000007974
case_no = 2023/873
court_code = 18165
new_case_purpose = 10033000000815
pre_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 36
Posting record
Param Type = n
trn_rcms_hearingid=15312000010336
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:42
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:42
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=19/11/2024 00:00:00
Param Type = c
trn_rcms_caseid=19071000007974
Param Type = c
case_no=2023/873
Param Type = c
court_code=18165
Param Type = c
new_case_purpose=10033000000815
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/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 = 5
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 = 4
RecordId = 15312000010337
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 19/11/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 10378000008656
court_code = 18165
case_no = 2023/924
new_case_purpose = 10189000000601
pre_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 37
Posting record
Param Type = n
trn_rcms_hearingid=15312000010337
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:42
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=10378000008656
Param Type = c
court_code=18165
Param Type = c
case_no=2023/924
Param Type = c
new_case_purpose=10189000000601
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/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 = 5
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 = 4
RecordId = 15312000010338
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 25/09/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 18678000000000
case_no = 2024/39
court_code = 18165
trn_rcms_caseid = 12146000007629
pre_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 38
Posting record
Param Type = n
trn_rcms_hearingid=15312000010338
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:42
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=25/09/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
case_no=2024/39
Param Type = c
court_code=18165
Param Type = c
trn_rcms_caseid=12146000007629
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/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 = 6
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 = 15312000010339
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 10
next_hear_date = 20/11/2024
new_case_purpose = 18678000000000
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2024/49
court_code = 18165
trn_rcms_caseid = 19174000007783
pre_case_purpose = 18678000000000
pre_hear_date = 12/09/2024
TRN_RCMS_HEARINGrow = 39
Posting record
Param Type = n
trn_rcms_hearingid=15312000010339
Param Type = n
trn_rcms_mhearingid=15312000010300
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:42
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=20/11/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/49
Param Type = c
court_code=18165
Param Type = c
trn_rcms_caseid=19174000007783
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=12/09/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 = 3935817581467
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15585000008125 idvalue 0
Mapped case_no Row = 1 value = 2024/23 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 15585000008125
case_no = 2024/23
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purposename=???? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????????? ????
Time elapsed = 6
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 10
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010340
MapName trcmf1
SourceId 15312000010301
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 = 12555000000002
hearing_date = 19/11/2024
case_no = 2024/23
trn_rcms_caseregid = 15585000008125
court_code = 18165
case_purpose = 12555000000002
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010340
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010301
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:42
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2024/23
Param Type = c
trn_rcms_caseregid=15585000008125
Param Type = c
court_code=18165
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15681000007941 idvalue 0
Mapped case_no Row = 1 value = 2024/24 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 15681000007941
case_no = 2024/24
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15312000010341
MapName trcmf1
SourceId 15312000010302
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 = 12555000000002
hearing_date = 19/11/2024
case_no = 2024/24
trn_rcms_caseregid = 15681000007941
court_code = 18165
case_purpose = 12555000000002
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010341
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010302
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:44
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2024/24
Param Type = c
trn_rcms_caseregid=15681000007941
Param Type = c
court_code=18165
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17986000008401 idvalue 0
Mapped case_no Row = 1 value = 2023/1050 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 10189000000601 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 17986000008401
case_no = 2023/1050
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 10
prev_case_purpose after validation = 18678000000000
case_purpose = 10189000000601
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 = 15312000010342
MapName trcmf1
SourceId 15312000010303
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/1050
trn_rcms_caseregid = 17986000008401
court_code = 18165
case_purpose = 10189000000601
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010342
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010303
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:46
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/1050
Param Type = c
trn_rcms_caseregid=17986000008401
Param Type = c
court_code=18165
Param Type = c
case_purpose=10189000000601
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13334000008019 idvalue 0
Mapped case_no Row = 1 value = 2023/1090 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 10033000000815 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 13334000008019
case_no = 2023/1090
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 10033000000815
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15312000010343
MapName trcmf1
SourceId 15312000010304
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/1090
trn_rcms_caseregid = 13334000008019
court_code = 18165
case_purpose = 10033000000815
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010343
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010304
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:47
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39: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=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/1090
Param Type = c
trn_rcms_caseregid=13334000008019
Param Type = c
court_code=18165
Param Type = c
case_purpose=10033000000815
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13660000007516 idvalue 0
Mapped case_no Row = 1 value = 2023/1099 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 13660000007516
case_no = 2023/1099
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010344
MapName trcmf1
SourceId 15312000010305
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 = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/1099
trn_rcms_caseregid = 13660000007516
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010344
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010305
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:49
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/1099
Param Type = c
trn_rcms_caseregid=13660000007516
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11255000008084 idvalue 0
Mapped case_no Row = 1 value = 2023/1149 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 11255000008084
case_no = 2023/1149
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010345
MapName trcmf1
SourceId 15312000010306
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/1149
trn_rcms_caseregid = 11255000008084
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010345
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010306
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:50
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39: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=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/1149
Param Type = c
trn_rcms_caseregid=11255000008084
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11272000008700 idvalue 0
Mapped case_no Row = 1 value = 2023/1150 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 11272000008700
case_no = 2023/1150
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 11472000000003
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 = 15312000010346
MapName trcmf1
SourceId 15312000010307
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/1150
trn_rcms_caseregid = 11272000008700
court_code = 18165
case_purpose = 11472000000003
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010346
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010307
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:52
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39: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=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/1150
Param Type = c
trn_rcms_caseregid=11272000008700
Param Type = c
court_code=18165
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19992000008192 idvalue 0
Mapped case_no Row = 1 value = 2023/1190 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 20/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 19992000008192
case_no = 2023/1190
prev_hearing_date = 12/09/2024
hearing_date = 20/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 16
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 = 15312000010347
MapName trcmf1
SourceId 15312000010308
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 10
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 20/11/2024
case_no = 2023/1190
trn_rcms_caseregid = 19992000008192
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010347
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010308
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:53
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2023/1190
Param Type = c
trn_rcms_caseregid=19992000008192
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15910000008081 idvalue 0
Mapped case_no Row = 1 value = 2023/1201 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 10189000000601 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 15910000008081
case_no = 2023/1201
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 10189000000601
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 = 15312000010348
MapName trcmf1
SourceId 15312000010309
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/1201
trn_rcms_caseregid = 15910000008081
court_code = 18165
case_purpose = 10189000000601
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010348
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010309
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:55
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/1201
Param Type = c
trn_rcms_caseregid=15910000008081
Param Type = c
court_code=18165
Param Type = c
case_purpose=10189000000601
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14169000008263 idvalue 0
Mapped case_no Row = 1 value = 2023/1206 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 20/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 14169000008263
case_no = 2023/1206
prev_hearing_date = 12/09/2024
hearing_date = 20/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 15312000010349
MapName trcmf1
SourceId 15312000010310
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 20/11/2024
case_no = 2023/1206
trn_rcms_caseregid = 14169000008263
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010349
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010310
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:56
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2023/1206
Param Type = c
trn_rcms_caseregid=14169000008263
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17730000007112 idvalue 0
Mapped case_no Row = 1 value = 2023/134 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 10033000000815 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 17730000007112
case_no = 2023/134
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 10033000000815
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010350
MapName trcmf1
SourceId 15312000010311
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/134
trn_rcms_caseregid = 17730000007112
court_code = 18165
case_purpose = 10033000000815
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010350
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010311
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:58
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/134
Param Type = c
trn_rcms_caseregid=17730000007112
Param Type = c
court_code=18165
Param Type = c
case_purpose=10033000000815
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19356000009198 idvalue 0
Mapped case_no Row = 1 value = 2023/142 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 10033000000815 idvalue 0
Mapped hearing_date Row = 1 value = 08/10/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 = 18165
trn_rcms_caseregid = 19356000009198
case_no = 2023/142
prev_hearing_date = 12/09/2024
hearing_date = 08/10/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 10033000000815
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15312000010351
MapName trcmf1
SourceId 15312000010312
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/10/2024
case_no = 2023/142
trn_rcms_caseregid = 19356000009198
court_code = 18165
case_purpose = 10033000000815
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010351
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010312
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:39:59
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:39:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/10/2024 00:00:00
Param Type = c
case_no=2023/142
Param Type = c
trn_rcms_caseregid=19356000009198
Param Type = c
court_code=18165
Param Type = c
case_purpose=10033000000815
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14629000007854 idvalue 0
Mapped case_no Row = 1 value = 2023/206 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 20/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 14629000007854
case_no = 2023/206
prev_hearing_date = 12/09/2024
hearing_date = 20/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 15312000010352
MapName trcmf1
SourceId 15312000010313
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 20/11/2024
case_no = 2023/206
trn_rcms_caseregid = 14629000007854
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010352
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010313
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:01
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2023/206
Param Type = c
trn_rcms_caseregid=14629000007854
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14860000009015 idvalue 0
Mapped case_no Row = 1 value = 2023/210 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 14860000009015
case_no = 2023/210
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 15312000010353
MapName trcmf1
SourceId 15312000010314
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/210
trn_rcms_caseregid = 14860000009015
court_code = 18165
case_purpose = 12555000000002
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010353
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010314
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:03
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/210
Param Type = c
trn_rcms_caseregid=14860000009015
Param Type = c
court_code=18165
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15809000008111 idvalue 0
Mapped case_no Row = 1 value = 2023/226 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 20/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 15809000008111
case_no = 2023/226
prev_hearing_date = 12/09/2024
hearing_date = 20/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 15312000010354
MapName trcmf1
SourceId 15312000010315
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 20/11/2024
case_no = 2023/226
trn_rcms_caseregid = 15809000008111
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010354
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010315
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:05
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:05
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2023/226
Param Type = c
trn_rcms_caseregid=15809000008111
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19144000007625 idvalue 0
Mapped case_no Row = 1 value = 2023/334 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 20/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 19144000007625
case_no = 2023/334
prev_hearing_date = 12/09/2024
hearing_date = 20/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 15312000010355
MapName trcmf1
SourceId 15312000010316
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 20/11/2024
case_no = 2023/334
trn_rcms_caseregid = 19144000007625
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010355
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010316
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:07
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2023/334
Param Type = c
trn_rcms_caseregid=19144000007625
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14853000008211 idvalue 0
Mapped case_no Row = 1 value = 2023/414 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 20/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 14853000008211
case_no = 2023/414
prev_hearing_date = 12/09/2024
hearing_date = 20/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 11472000000003
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 = 15312000010356
MapName trcmf1
SourceId 15312000010317
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 = 18678000000000
hearing_date = 20/11/2024
case_no = 2023/414
trn_rcms_caseregid = 14853000008211
court_code = 18165
case_purpose = 11472000000003
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010356
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010317
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:08
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40: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=18678000000000
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2023/414
Param Type = c
trn_rcms_caseregid=14853000008211
Param Type = c
court_code=18165
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15301000008199 idvalue 0
Mapped case_no Row = 1 value = 2023/416 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 20/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 15301000008199
case_no = 2023/416
prev_hearing_date = 12/09/2024
hearing_date = 20/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 11472000000003
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 = 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 = 15312000010357
MapName trcmf1
SourceId 15312000010318
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 = 18678000000000
hearing_date = 20/11/2024
case_no = 2023/416
trn_rcms_caseregid = 15301000008199
court_code = 18165
case_purpose = 11472000000003
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010357
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010318
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:10
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40: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=18678000000000
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2023/416
Param Type = c
trn_rcms_caseregid=15301000008199
Param Type = c
court_code=18165
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15323000008237 idvalue 0
Mapped case_no Row = 1 value = 2023/417 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 10189000000601 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 15323000008237
case_no = 2023/417
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 10189000000601
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010358
MapName trcmf1
SourceId 15312000010319
Select sysdate as sdt from dual
Time elapsed = 8
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 = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/417
trn_rcms_caseregid = 15323000008237
court_code = 18165
case_purpose = 10189000000601
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010358
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010319
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:12
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/417
Param Type = c
trn_rcms_caseregid=15323000008237
Param Type = c
court_code=18165
Param Type = c
case_purpose=10189000000601
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16834000007485 idvalue 0
Mapped case_no Row = 1 value = 2023/438 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 10033000000815 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 16834000007485
case_no = 2023/438
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 10033000000815
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 15312000010359
MapName trcmf1
SourceId 15312000010320
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/438
trn_rcms_caseregid = 16834000007485
court_code = 18165
case_purpose = 10033000000815
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010359
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010320
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:14
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/438
Param Type = c
trn_rcms_caseregid=16834000007485
Param Type = c
court_code=18165
Param Type = c
case_purpose=10033000000815
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11983000008078 idvalue 0
Mapped case_no Row = 1 value = 2023/462 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 11983000008078
case_no = 2023/462
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15312000010360
MapName trcmf1
SourceId 15312000010321
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 12
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/462
trn_rcms_caseregid = 11983000008078
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010360
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010321
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:17
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/462
Param Type = c
trn_rcms_caseregid=11983000008078
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12091000007350 idvalue 0
Mapped case_no Row = 1 value = 2023/468 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 12091000007350
case_no = 2023/468
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 15312000010361
MapName trcmf1
SourceId 15312000010322
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 = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/468
trn_rcms_caseregid = 12091000007350
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010361
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010322
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:18
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/468
Param Type = c
trn_rcms_caseregid=12091000007350
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12178000007282 idvalue 0
Mapped case_no Row = 1 value = 2023/473 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 20/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 12178000007282
case_no = 2023/473
prev_hearing_date = 12/09/2024
hearing_date = 20/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 6
RecordId = 15312000010362
MapName trcmf1
SourceId 15312000010323
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 10
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 20/11/2024
case_no = 2023/473
trn_rcms_caseregid = 12178000007282
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010362
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010323
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:21
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2023/473
Param Type = c
trn_rcms_caseregid=12178000007282
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12248000007425 idvalue 0
Mapped case_no Row = 1 value = 2023/475 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 12248000007425
case_no = 2023/475
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15312000010363
MapName trcmf1
SourceId 15312000010324
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/475
trn_rcms_caseregid = 12248000007425
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010363
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010324
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:23
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40: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=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/475
Param Type = c
trn_rcms_caseregid=12248000007425
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12297000009207 idvalue 0
Mapped case_no Row = 1 value = 2023/477 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 12297000009207
case_no = 2023/477
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 15312000010364
MapName trcmf1
SourceId 15312000010325
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/477
trn_rcms_caseregid = 12297000009207
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010364
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010325
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:25
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40: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=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/477
Param Type = c
trn_rcms_caseregid=12297000009207
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12402000007825 idvalue 0
Mapped case_no Row = 1 value = 2023/481 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 12402000007825
case_no = 2023/481
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 11472000000003
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 = 15312000010365
MapName trcmf1
SourceId 15312000010326
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/481
trn_rcms_caseregid = 12402000007825
court_code = 18165
case_purpose = 11472000000003
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010365
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010326
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:27
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40: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=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/481
Param Type = c
trn_rcms_caseregid=12402000007825
Param Type = c
court_code=18165
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15394000008835 idvalue 0
Mapped case_no Row = 1 value = 2023/497 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 20/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 15394000008835
case_no = 2023/497
prev_hearing_date = 12/09/2024
hearing_date = 20/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 25
RecordId = 15312000010366
MapName trcmf1
SourceId 15312000010327
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 20/11/2024
case_no = 2023/497
trn_rcms_caseregid = 15394000008835
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010366
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010327
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:29
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40: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=18678000000000
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2023/497
Param Type = c
trn_rcms_caseregid=15394000008835
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17931000007428 idvalue 0
Mapped case_no Row = 1 value = 2023/524 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 20/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 17931000007428
case_no = 2023/524
prev_hearing_date = 12/09/2024
hearing_date = 20/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15312000010367
MapName trcmf1
SourceId 15312000010328
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 20/11/2024
case_no = 2023/524
trn_rcms_caseregid = 17931000007428
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010367
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010328
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:31
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2023/524
Param Type = c
trn_rcms_caseregid=17931000007428
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15177000006721 idvalue 0
Mapped case_no Row = 1 value = 2023/533 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 10033000000815 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 15177000006721
case_no = 2023/533
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 10033000000815
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 15312000010368
MapName trcmf1
SourceId 15312000010329
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/533
trn_rcms_caseregid = 15177000006721
court_code = 18165
case_purpose = 10033000000815
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010368
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010329
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:33
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/533
Param Type = c
trn_rcms_caseregid=15177000006721
Param Type = c
court_code=18165
Param Type = c
case_purpose=10033000000815
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18519000006839 idvalue 0
Mapped case_no Row = 1 value = 2023/625 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 18519000006839
case_no = 2023/625
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15312000010369
MapName trcmf1
SourceId 15312000010330
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/625
trn_rcms_caseregid = 18519000006839
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010369
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010330
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:35
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/625
Param Type = c
trn_rcms_caseregid=18519000006839
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19246000008540 idvalue 0
Mapped case_no Row = 1 value = 2023/658 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 19246000008540
case_no = 2023/658
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 15312000010370
MapName trcmf1
SourceId 15312000010331
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/658
trn_rcms_caseregid = 19246000008540
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010370
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010331
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:37
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/658
Param Type = c
trn_rcms_caseregid=19246000008540
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18221000007420 idvalue 0
Mapped case_no Row = 1 value = 2023/711 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 18221000007420
case_no = 2023/711
prev_hearing_date = 12/09/2024
hearing_date = 04/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 15312000010371
MapName trcmf1
SourceId 15312000010332
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 04/11/2024
case_no = 2023/711
trn_rcms_caseregid = 18221000007420
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010371
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010332
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:38
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40: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=18678000000000
Param Type = c
hearing_date=04/11/2024 00:00:00
Param Type = c
case_no=2023/711
Param Type = c
trn_rcms_caseregid=18221000007420
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18989000008381 idvalue 0
Mapped case_no Row = 1 value = 2023/734 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 18989000008381
case_no = 2023/734
prev_hearing_date = 12/09/2024
hearing_date = 04/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 15312000010372
MapName trcmf1
SourceId 15312000010333
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 04/11/2024
case_no = 2023/734
trn_rcms_caseregid = 18989000008381
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010372
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010333
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:40
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=04/11/2024 00:00:00
Param Type = c
case_no=2023/734
Param Type = c
trn_rcms_caseregid=18989000008381
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19110000007876 idvalue 0
Mapped case_no Row = 1 value = 2023/735 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 04/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 19110000007876
case_no = 2023/735
prev_hearing_date = 12/09/2024
hearing_date = 04/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 15312000010373
MapName trcmf1
SourceId 15312000010334
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 = 18678000000000
hearing_date = 04/11/2024
case_no = 2023/735
trn_rcms_caseregid = 19110000007876
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010373
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010334
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:42
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=04/11/2024 00:00:00
Param Type = c
case_no=2023/735
Param Type = c
trn_rcms_caseregid=19110000007876
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17935000007166 idvalue 0
Mapped case_no Row = 1 value = 2023/866 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 10033000000815 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 17935000007166
case_no = 2023/866
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 10033000000815
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 15312000010374
MapName trcmf1
SourceId 15312000010335
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/866
trn_rcms_caseregid = 17935000007166
court_code = 18165
case_purpose = 10033000000815
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010374
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010335
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:44
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/866
Param Type = c
trn_rcms_caseregid=17935000007166
Param Type = c
court_code=18165
Param Type = c
case_purpose=10033000000815
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19071000007974 idvalue 0
Mapped case_no Row = 1 value = 2023/873 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 10033000000815 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 19071000007974
case_no = 2023/873
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 10033000000815
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 15312000010375
MapName trcmf1
SourceId 15312000010336
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/873
trn_rcms_caseregid = 19071000007974
court_code = 18165
case_purpose = 10033000000815
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010375
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010336
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:46
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/873
Param Type = c
trn_rcms_caseregid=19071000007974
Param Type = c
court_code=18165
Param Type = c
case_purpose=10033000000815
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10378000008656 idvalue 0
Mapped case_no Row = 1 value = 2023/924 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 10189000000601 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 10378000008656
case_no = 2023/924
prev_hearing_date = 12/09/2024
hearing_date = 19/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 10189000000601
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010376
MapName trcmf1
SourceId 15312000010337
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 19/11/2024
case_no = 2023/924
trn_rcms_caseregid = 10378000008656
court_code = 18165
case_purpose = 10189000000601
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010376
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010337
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:48
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40: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=18678000000000
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2023/924
Param Type = c
trn_rcms_caseregid=10378000008656
Param Type = c
court_code=18165
Param Type = c
case_purpose=10189000000601
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12146000007629 idvalue 0
Mapped case_no Row = 1 value = 2024/39 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 25/09/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 12146000007629
case_no = 2024/39
prev_hearing_date = 12/09/2024
hearing_date = 25/09/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15312000010377
MapName trcmf1
SourceId 15312000010338
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 25/09/2024
case_no = 2024/39
trn_rcms_caseregid = 12146000007629
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010377
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010338
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:50
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40: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=18678000000000
Param Type = c
hearing_date=25/09/2024 00:00:00
Param Type = c
case_no=2024/39
Param Type = c
trn_rcms_caseregid=12146000007629
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 18165 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19174000007783 idvalue 0
Mapped case_no Row = 1 value = 2024/49 idvalue 0
Mapped prev_hearing_date Row = 1 value = 12/09/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 20/11/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 19174000007783
case_no = 2024/49
prev_hearing_date = 12/09/2024
hearing_date = 20/11/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15312000010378
MapName trcmf1
SourceId 15312000010339
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 20/11/2024
case_no = 2024/49
trn_rcms_caseregid = 19174000007783
court_code = 18165
case_purpose = 18678000000000
prev_hearing_date = 12/09/2024
Posting record
Param Type = n
trn_rcms_case_histid=15312000010378
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15312000010339
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=18/09/2024 10:40:52
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=18/09/2024 10:40: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=18678000000000
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2024/49
Param Type = c
trn_rcms_caseregid=19174000007783
Param Type = c
court_code=18165
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=12/09/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 = 3935817653325
Time elapsed for MD Map = 3935817653327
Time elapsed for Save History = 3935817653328
Time elapsed for Save Attachment = 3935817653328
Time elapsed for After Save WF Exec = 3935817653333
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"15312000010300"}]}
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=dc_sikar
Param Type = c
calledon=18/09/2024 10:39:36
Param Type = c
callfinished=18/09/2024 10:40:53
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=76475
Param Type = n
dbtimetaken=72784
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