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
gcmsadcsikar827ccb0eea8a706c4c34a16891f84e7b![]()
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=adcsikar
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=adcsikar
Time elapsed = 12
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=adcsikar
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=adcsikar
Time elapsed = 12
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = ADC
Result = ADC
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=adcsikar
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=adcsikar
Time elapsed = 13
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 1334770007689
Result = 1334770007689
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=adcsikar
Time elapsed = 32
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1095440008753
Result = 1095440008753
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=adcsikar
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = adcsikar
Result = adcsikar
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=adcsikar
Time elapsed = 13
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 18168
Result = 18168
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 = 14
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=adcsikar
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=adcsikar
Time elapsed = 11
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=adcsikar
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=adcsikar
Time elapsed = 10
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=1095440008753
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1095440008753
Time elapsed = 14
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=adcsikar
Time elapsed = 13
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 17410000000000
Result = 17410000000000
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=adcsikar
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=adcsikar
Time elapsed = 17
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 = 13
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=adcsikar
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=adcsikar
Time elapsed = 225
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 1
Result = 1
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 8
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 17
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 = 8
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : trcmf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 7
Step4
tstructs\stm size:2075
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Evaluating date()
Result =
Evaluating iif((next_hear_date>Validating trcmf
>>Frame No 1
courtcode = 18168
hearing_date = 19/12/2024
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 5
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 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 = 12676000010676
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 11
hearing_date = 19/12/2024
courtcode = 18168
Posting record
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:40
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=19/12/2024 00:00:00
Param Type = c
courtcode=18168
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 = 9
Adding new record to store data from Frame 2, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12676000010677
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 9
pre_hear_date = 19/12/2024
pre_case_purpose = 10189000000601
trn_rcms_caseid = 11436000010436
court_code = 18168
case_no = 2024/108
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 10189000000601
next_hear_date = 09/01/2025
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=12676000010677
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:40
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = n
pre_case_purpose=10189000000601
Param Type = c
trn_rcms_caseid=11436000010436
Param Type = c
court_code=18168
Param Type = c
case_no=2024/108
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=10189000000601
Param Type = c
next_hear_date=09/01/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 8
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12676000010678
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 10
pre_hear_date = 19/12/2024
pre_case_purpose = 10189000000601
trn_rcms_caseid = 11468000008912
court_code = 18168
case_no = 2024/114
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 10189000000601
next_hear_date = 09/01/2025
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=12676000010678
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:40
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = n
pre_case_purpose=10189000000601
Param Type = c
trn_rcms_caseid=11468000008912
Param Type = c
court_code=18168
Param Type = c
case_no=2024/114
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=10189000000601
Param Type = c
next_hear_date=09/01/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12676000010679
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 32
pre_hear_date = 19/12/2024
pre_case_purpose = 10189000000601
trn_rcms_caseid = 11899000008513
court_code = 18168
case_no = 2024/150
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 10189000000601
next_hear_date = 09/01/2025
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=12676000010679
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:40
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = n
pre_case_purpose=10189000000601
Param Type = c
trn_rcms_caseid=11899000008513
Param Type = c
court_code=18168
Param Type = c
case_no=2024/150
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=10189000000601
Param Type = c
next_hear_date=09/01/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 14
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 = 12676000010680
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 09/01/2025
new_case_purpose = 10189000000601
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/86
court_code = 18168
trn_rcms_caseid = 19749000008599
pre_case_purpose = 10189000000601
pre_hear_date = 19/12/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=12676000010680
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:40
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=09/01/2025 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=2024/86
Param Type = c
court_code=18168
Param Type = c
trn_rcms_caseid=19749000008599
Param Type = n
pre_case_purpose=10189000000601
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 12
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12676000010681
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 13
next_hear_date = 09/01/2025
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/120
court_code = 18168
trn_rcms_caseid = 11478000009109
pre_case_purpose = 1000492
pre_hear_date = 19/12/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=12676000010681
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:41
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=09/01/2025 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/120
Param Type = c
court_code=18168
Param Type = c
trn_rcms_caseid=11478000009109
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=19/12/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 = 9
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 = 6
RecordId = 12676000010682
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 9
pre_case_purpose = 1000492
new_case_purpose = 1000492
next_hear_date = 20/02/2025
pre_hear_date = 19/12/2024
court_code = 18168
case_no = 2024/146
trn_rcms_caseid = 11844000008591
adjourn_remark =
adjourn_type = 0
isadjourn = NO
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=12676000010682
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:41
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=20/02/2025 00:00:00
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = c
court_code=18168
Param Type = c
case_no=2024/146
Param Type = c
trn_rcms_caseid=11844000008591
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,new_case_purpose,next_hear_date,pre_hear_date,court_code,case_no,trn_rcms_caseid,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,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,null,:adjourn_type,:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 10
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12676000010683
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 7
trn_rcms_caseid = 13715000009590
pre_hear_date = 19/12/2024
new_case_purpose = 1000492
pre_case_purpose = 1000492
court_code = 18168
case_no = 2024/15
adjourn_remark =
next_hear_date = 20/02/2025
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=12676000010683
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:41
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=13715000009590
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=18168
Param Type = c
case_no=2024/15
Param Type = c
next_hear_date=20/02/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,pre_hear_date,new_case_purpose,pre_case_purpose,court_code,case_no,adjourn_remark,next_hear_date,isadjourn,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:court_code,:case_no,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 12676000010684
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 10
new_case_purpose = 1000492
isadjourn = NO
next_hear_date = 26/02/2025
pre_case_purpose = 1000492
case_no = 2024/169
court_code = 18168
pre_hear_date = 19/12/2024
trn_rcms_caseid = 10497000009062
adjourn_remark =
adjourn_type = 0
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=12676000010684
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:41
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=26/02/2025 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
case_no=2024/169
Param Type = c
court_code=18168
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = c
trn_rcms_caseid=10497000009062
Param Type = c
adjourn_type=0
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,new_case_purpose,isadjourn,next_hear_date,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:adjourn_type,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 9
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 12676000010685
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 218
case_no = 2024/171
new_case_purpose = 1000492
pre_case_purpose = 1000492
trn_rcms_caseid = 10525000008489
pre_hear_date = 19/12/2024
adjourn_remark =
court_code = 18168
adjourn_type = 0
next_hear_date = 17/01/2025
isadjourn = NO
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=12676000010685
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:41
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2024/171
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=10525000008489
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = c
court_code=18168
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=17/01/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 8
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12676000010686
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 11
next_hear_date = 17/01/2025
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2024/176
court_code = 18168
trn_rcms_caseid = 13934000008743
pre_case_purpose = 1000492
pre_hear_date = 19/12/2024
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=12676000010686
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:42
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=17/01/2025 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/176
Param Type = c
court_code=18168
Param Type = c
trn_rcms_caseid=13934000008743
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 9
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 = 7
RecordId = 12676000010687
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 218
next_hear_date = 17/01/2025
isadjourn = NO
new_case_purpose = 1000492
pre_case_purpose = 1000492
pre_hear_date = 19/12/2024
case_no = 2024/181
court_code = 18168
trn_rcms_caseid = 14129000009487
adjourn_type = 0
adjourn_remark =
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=12676000010687
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:42
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=17/01/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = c
case_no=2024/181
Param Type = c
court_code=18168
Param Type = c
trn_rcms_caseid=14129000009487
Param Type = c
adjourn_type=0
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,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_type,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:adjourn_type,null,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12676000010688
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 8
adjourn_type = 0
case_no = 2024/221
court_code = 18168
isadjourn = NO
next_hear_date = 17/01/2025
pre_case_purpose = 1000492
new_case_purpose = 1000492
pre_hear_date = 19/12/2024
adjourn_remark =
trn_rcms_caseid = 11133000007704
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=12676000010688
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:42
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/221
Param Type = c
court_code=18168
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=17/01/2025 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = c
trn_rcms_caseid=11133000007704
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,adjourn_type,case_no,court_code,isadjourn,next_hear_date,pre_case_purpose,new_case_purpose,pre_hear_date,adjourn_remark,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,:case_no,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:trn_rcms_caseid,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 9
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12676000010689
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 11
court_code = 18168
isadjourn = NO
next_hear_date = 17/01/2025
adjourn_remark =
adjourn_type = 0
new_case_purpose = 1000492
pre_hear_date = 19/12/2024
trn_rcms_caseid = 12987000008839
case_no = 2024/302
pre_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=12676000010689
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:42
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=18168
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=17/01/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = c
trn_rcms_caseid=12987000008839
Param Type = c
case_no=2024/302
Param Type = n
pre_case_purpose=1000492
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,court_code,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,pre_hear_date,trn_rcms_caseid,case_no,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 20
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12676000010690
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 12
court_code = 18168
pre_case_purpose = 1000492
case_no = 2024/326
trn_rcms_caseid = 18849000008955
pre_hear_date = 19/12/2024
new_case_purpose = 1000492
adjourn_type = 0
adjourn_remark =
next_hear_date = 17/01/2025
isadjourn = NO
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=12676000010690
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:42
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=18168
Param Type = n
pre_case_purpose=1000492
Param Type = c
case_no=2024/326
Param Type = c
trn_rcms_caseid=18849000008955
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=17/01/2025 00:00:00
Param Type = c
isadjourn=NO
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,court_code,pre_case_purpose,case_no,trn_rcms_caseid,pre_hear_date,new_case_purpose,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,:court_code,:pre_case_purpose,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,: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 = 8
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 = 12676000010691
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 11
adjourn_remark =
trn_rcms_caseid = 16852000007872
pre_hear_date = 19/12/2024
court_code = 18168
case_no = 2024/343
pre_case_purpose = 1000492
isadjourn = NO
adjourn_type = 0
new_case_purpose = 1000492
next_hear_date = 17/01/2025
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=12676000010691
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:42
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=16852000007872
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = c
court_code=18168
Param Type = c
case_no=2024/343
Param Type = n
pre_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=17/01/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 9
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12676000010692
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 30
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 18096000007889
court_code = 18168
case_no = 2024/386
pre_hear_date = 19/12/2024
new_case_purpose = 1000492
adjourn_type = 0
pre_case_purpose = 1000492
next_hear_date = 17/01/2025
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=12676000010692
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:42
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=18096000007889
Param Type = c
court_code=18168
Param Type = c
case_no=2024/386
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=1000492
Param Type = c
next_hear_date=17/01/2025 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,adjourn_remark,isadjourn,trn_rcms_caseid,court_code,case_no,pre_hear_date,new_case_purpose,adjourn_type,pre_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:isadjourn,:trn_rcms_caseid,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:pre_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 = 11
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 12676000010693
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 11
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 18143000009936
pre_hear_date = 19/12/2024
court_code = 18168
case_no = 2024/390
next_hear_date = 27/02/2025
isadjourn = NO
pre_case_purpose = 1000492
new_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=12676000010693
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:43
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18143000009936
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = c
court_code=18168
Param Type = c
case_no=2024/390
Param Type = c
next_hear_date=27/02/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12676000010694
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 9
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 10183000009280
pre_hear_date = 19/12/2024
court_code = 18168
case_no = 2024/393
next_hear_date = 17/01/2025
isadjourn = NO
pre_case_purpose = 1000492
new_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=12676000010694
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:43
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=10183000009280
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = c
court_code=18168
Param Type = c
case_no=2024/393
Param Type = c
next_hear_date=17/01/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12676000010695
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 10
adjourn_type = 0
adjourn_remark =
isadjourn = NO
case_no = 2024/465
trn_rcms_caseid = 11412000009370
pre_case_purpose = 1000492
court_code = 18168
next_hear_date = 17/01/2025
new_case_purpose = 1000492
pre_hear_date = 19/12/2024
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=12676000010695
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:43
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/465
Param Type = c
trn_rcms_caseid=11412000009370
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=18168
Param Type = c
next_hear_date=17/01/2025 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,case_no,trn_rcms_caseid,pre_case_purpose,court_code,next_hear_date,new_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:case_no,:trn_rcms_caseid,:pre_case_purpose,:court_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 25
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 = 10
RecordId = 12676000010696
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 10
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 13030000010440
case_no = 2024/486
court_code = 18168
pre_hear_date = 19/12/2024
next_hear_date = 17/01/2025
new_case_purpose = 1000492
pre_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=12676000010696
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:43
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13030000010440
Param Type = c
case_no=2024/486
Param Type = c
court_code=18168
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = c
next_hear_date=17/01/2025 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
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,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 214
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 = 12676000010697
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 214
Select sysdate as sdt from dual
Time elapsed = 11
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 27/02/2025
trn_rcms_caseid = 13350000009098
case_no = 2024/492
court_code = 18168
new_case_purpose = 1000492
pre_case_purpose = 1000492
pre_hear_date = 19/12/2024
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=12676000010697
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:43
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:44
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=27/02/2025 00:00:00
Param Type = c
trn_rcms_caseid=13350000009098
Param Type = c
case_no=2024/492
Param Type = c
court_code=18168
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 7
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 = 12676000010698
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 11
next_hear_date = 27/02/2025
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 12083000009956
court_code = 18168
case_no = 2024/591
new_case_purpose = 1000492
pre_case_purpose = 1000492
pre_hear_date = 19/12/2024
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=12676000010698
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:44
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=27/02/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=12083000009956
Param Type = c
court_code=18168
Param Type = c
case_no=2024/591
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 = 7
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12676000010699
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 10
next_hear_date = 17/01/2025
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 1000492
case_no = 2024/65
court_code = 18168
trn_rcms_caseid = 15080000008042
pre_case_purpose = 1000492
pre_hear_date = 19/12/2024
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=12676000010699
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:44
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=17/01/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000492
Param Type = c
case_no=2024/65
Param Type = c
court_code=18168
Param Type = c
trn_rcms_caseid=15080000008042
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=19/12/2024 00:00:00
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,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12676000010700
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 12
next_hear_date = 17/01/2025
new_case_purpose = 1000492
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2024/83
court_code = 18168
trn_rcms_caseid = 19736000008847
pre_case_purpose = 1000492
pre_hear_date = 19/12/2024
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=12676000010700
Param Type = n
trn_rcms_mhearingid=12676000010676
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:44
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=17/01/2025 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/83
Param Type = c
court_code=18168
Param Type = c
trn_rcms_caseid=19736000008847
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=19/12/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3944118896962
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11436000010436 idvalue 0
Mapped case_no Row = 1 value = 2024/108 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/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 = 09/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 11436000010436
case_no = 2024/108
prev_hearing_date = 19/12/2024
hearing_date = 09/01/2025
prev_case_purposename = ???.
prev_case_purpose =
prev_case_purposename=???.
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???.
Time elapsed = 9
prev_case_purpose after validation = 10189000000601
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 = 8
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12676000010701
MapName trcmf1
SourceId 12676000010677
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 10189000000601
hearing_date = 09/01/2025
case_no = 2024/108
trn_rcms_caseregid = 11436000010436
court_code = 18168
case_purpose = 10189000000601
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010701
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010677
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:44
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34: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=10189000000601
Param Type = c
hearing_date=09/01/2025 00:00:00
Param Type = c
case_no=2024/108
Param Type = c
trn_rcms_caseregid=11436000010436
Param Type = c
court_code=18168
Param Type = c
case_purpose=10189000000601
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11468000008912 idvalue 0
Mapped case_no Row = 1 value = 2024/114 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/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 = 09/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 11468000008912
case_no = 2024/114
prev_hearing_date = 19/12/2024
hearing_date = 09/01/2025
prev_case_purposename = ???.
prev_case_purpose =
prev_case_purpose after validation = 10189000000601
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 = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12676000010702
MapName trcmf1
SourceId 12676000010678
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 216
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 10189000000601
hearing_date = 09/01/2025
case_no = 2024/114
trn_rcms_caseregid = 11468000008912
court_code = 18168
case_purpose = 10189000000601
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010702
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010678
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:46
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34: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=10189000000601
Param Type = c
hearing_date=09/01/2025 00:00:00
Param Type = c
case_no=2024/114
Param Type = c
trn_rcms_caseregid=11468000008912
Param Type = c
court_code=18168
Param Type = c
case_purpose=10189000000601
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11899000008513 idvalue 0
Mapped case_no Row = 1 value = 2024/150 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/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 = 09/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 11899000008513
case_no = 2024/150
prev_hearing_date = 19/12/2024
hearing_date = 09/01/2025
prev_case_purposename = ???.
prev_case_purpose =
prev_case_purpose after validation = 10189000000601
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 = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12676000010703
MapName trcmf1
SourceId 12676000010679
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 10189000000601
hearing_date = 09/01/2025
case_no = 2024/150
trn_rcms_caseregid = 11899000008513
court_code = 18168
case_purpose = 10189000000601
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010703
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010679
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:48
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34: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=10189000000601
Param Type = c
hearing_date=09/01/2025 00:00:00
Param Type = c
case_no=2024/150
Param Type = c
trn_rcms_caseregid=11899000008513
Param Type = c
court_code=18168
Param Type = c
case_purpose=10189000000601
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19749000008599 idvalue 0
Mapped case_no Row = 1 value = 2024/86 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/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 = 09/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 19749000008599
case_no = 2024/86
prev_hearing_date = 19/12/2024
hearing_date = 09/01/2025
prev_case_purposename = ???.
prev_case_purpose =
prev_case_purpose after validation = 10189000000601
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 = 6
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 12
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12676000010704
MapName trcmf1
SourceId 12676000010680
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 10189000000601
hearing_date = 09/01/2025
case_no = 2024/86
trn_rcms_caseregid = 19749000008599
court_code = 18168
case_purpose = 10189000000601
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010704
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010680
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:50
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34: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=10189000000601
Param Type = c
hearing_date=09/01/2025 00:00:00
Param Type = c
case_no=2024/86
Param Type = c
trn_rcms_caseregid=19749000008599
Param Type = c
court_code=18168
Param Type = c
case_purpose=10189000000601
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11478000009109 idvalue 0
Mapped case_no Row = 1 value = 2024/120 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 09/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 11478000009109
case_no = 2024/120
prev_hearing_date = 19/12/2024
hearing_date = 09/01/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purposename=?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????
Time elapsed = 13
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 10
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 23
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 12676000010705
MapName trcmf1
SourceId 12676000010681
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 13
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 09/01/2025
case_no = 2024/120
trn_rcms_caseregid = 11478000009109
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010705
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010681
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:51
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=09/01/2025 00:00:00
Param Type = c
case_no=2024/120
Param Type = c
trn_rcms_caseregid=11478000009109
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11844000008591 idvalue 0
Mapped case_no Row = 1 value = 2024/146 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 20/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 11844000008591
case_no = 2024/146
prev_hearing_date = 19/12/2024
hearing_date = 20/02/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
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 = 6
RecordId = 12676000010706
MapName trcmf1
SourceId 12676000010682
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 20/02/2025
case_no = 2024/146
trn_rcms_caseregid = 11844000008591
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010706
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010682
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:53
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34: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=1000492
Param Type = c
hearing_date=20/02/2025 00:00:00
Param Type = c
case_no=2024/146
Param Type = c
trn_rcms_caseregid=11844000008591
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13715000009590 idvalue 0
Mapped case_no Row = 1 value = 2024/15 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 20/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 13715000009590
case_no = 2024/15
prev_hearing_date = 19/12/2024
hearing_date = 20/02/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12676000010707
MapName trcmf1
SourceId 12676000010683
Select sysdate as sdt from dual
Time elapsed = 220
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 = 1000492
hearing_date = 20/02/2025
case_no = 2024/15
trn_rcms_caseregid = 13715000009590
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010707
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010683
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:54
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=20/02/2025 00:00:00
Param Type = c
case_no=2024/15
Param Type = c
trn_rcms_caseregid=13715000009590
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10497000009062 idvalue 0
Mapped case_no Row = 1 value = 2024/169 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 26/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 10497000009062
case_no = 2024/169
prev_hearing_date = 19/12/2024
hearing_date = 26/02/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
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 = 7
RecordId = 12676000010708
MapName trcmf1
SourceId 12676000010684
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 = 1000492
hearing_date = 26/02/2025
case_no = 2024/169
trn_rcms_caseregid = 10497000009062
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010708
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010684
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:56
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=26/02/2025 00:00:00
Param Type = c
case_no=2024/169
Param Type = c
trn_rcms_caseregid=10497000009062
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10525000008489 idvalue 0
Mapped case_no Row = 1 value = 2024/171 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 10525000008489
case_no = 2024/171
prev_hearing_date = 19/12/2024
hearing_date = 17/01/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12676000010709
MapName trcmf1
SourceId 12676000010685
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 55
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 17/01/2025
case_no = 2024/171
trn_rcms_caseregid = 10525000008489
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010709
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010685
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:57
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=17/01/2025 00:00:00
Param Type = c
case_no=2024/171
Param Type = c
trn_rcms_caseregid=10525000008489
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13934000008743 idvalue 0
Mapped case_no Row = 1 value = 2024/176 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 13934000008743
case_no = 2024/176
prev_hearing_date = 19/12/2024
hearing_date = 17/01/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12676000010710
MapName trcmf1
SourceId 12676000010686
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 17/01/2025
case_no = 2024/176
trn_rcms_caseregid = 13934000008743
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010710
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010686
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:34:59
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:34: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=1000492
Param Type = c
hearing_date=17/01/2025 00:00:00
Param Type = c
case_no=2024/176
Param Type = c
trn_rcms_caseregid=13934000008743
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14129000009487 idvalue 0
Mapped case_no Row = 1 value = 2024/181 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 14129000009487
case_no = 2024/181
prev_hearing_date = 19/12/2024
hearing_date = 17/01/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12676000010711
MapName trcmf1
SourceId 12676000010687
Select sysdate as sdt from dual
Time elapsed = 9
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 = 1000492
hearing_date = 17/01/2025
case_no = 2024/181
trn_rcms_caseregid = 14129000009487
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010711
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010687
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:35:01
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:35: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=1000492
Param Type = c
hearing_date=17/01/2025 00:00:00
Param Type = c
case_no=2024/181
Param Type = c
trn_rcms_caseregid=14129000009487
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11133000007704 idvalue 0
Mapped case_no Row = 1 value = 2024/221 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 11133000007704
case_no = 2024/221
prev_hearing_date = 19/12/2024
hearing_date = 17/01/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12676000010712
MapName trcmf1
SourceId 12676000010688
Select sysdate as sdt from dual
Time elapsed = 12
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 = 1000492
hearing_date = 17/01/2025
case_no = 2024/221
trn_rcms_caseregid = 11133000007704
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010712
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010688
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:35:02
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:35:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=17/01/2025 00:00:00
Param Type = c
case_no=2024/221
Param Type = c
trn_rcms_caseregid=11133000007704
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12987000008839 idvalue 0
Mapped case_no Row = 1 value = 2024/302 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 12987000008839
case_no = 2024/302
prev_hearing_date = 19/12/2024
hearing_date = 17/01/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 13
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 7
RecordId = 12676000010713
MapName trcmf1
SourceId 12676000010689
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 17/01/2025
case_no = 2024/302
trn_rcms_caseregid = 12987000008839
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010713
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010689
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:35:03
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:35:04
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=17/01/2025 00:00:00
Param Type = c
case_no=2024/302
Param Type = c
trn_rcms_caseregid=12987000008839
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18849000008955 idvalue 0
Mapped case_no Row = 1 value = 2024/326 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 18849000008955
case_no = 2024/326
prev_hearing_date = 19/12/2024
hearing_date = 17/01/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 24
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 = 12676000010714
MapName trcmf1
SourceId 12676000010690
Select sysdate as sdt from dual
Time elapsed = 12
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 = 1000492
hearing_date = 17/01/2025
case_no = 2024/326
trn_rcms_caseregid = 18849000008955
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010714
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010690
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:35:05
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:35: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=1000492
Param Type = c
hearing_date=17/01/2025 00:00:00
Param Type = c
case_no=2024/326
Param Type = c
trn_rcms_caseregid=18849000008955
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16852000007872 idvalue 0
Mapped case_no Row = 1 value = 2024/343 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 16852000007872
case_no = 2024/343
prev_hearing_date = 19/12/2024
hearing_date = 17/01/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12676000010715
MapName trcmf1
SourceId 12676000010691
Select sysdate as sdt from dual
Time elapsed = 30
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 17/01/2025
case_no = 2024/343
trn_rcms_caseregid = 16852000007872
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010715
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010691
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:35:07
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:35: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=1000492
Param Type = c
hearing_date=17/01/2025 00:00:00
Param Type = c
case_no=2024/343
Param Type = c
trn_rcms_caseregid=16852000007872
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18096000007889 idvalue 0
Mapped case_no Row = 1 value = 2024/386 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 18096000007889
case_no = 2024/386
prev_hearing_date = 19/12/2024
hearing_date = 17/01/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 14
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 11
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 12676000010716
MapName trcmf1
SourceId 12676000010692
Select sysdate as sdt from dual
Time elapsed = 27
Select sysdate as sdt from dual
Time elapsed = 18
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 17/01/2025
case_no = 2024/386
trn_rcms_caseregid = 18096000007889
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010716
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010692
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:35:08
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:35:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=17/01/2025 00:00:00
Param Type = c
case_no=2024/386
Param Type = c
trn_rcms_caseregid=18096000007889
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18143000009936 idvalue 0
Mapped case_no Row = 1 value = 2024/390 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 27/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 18143000009936
case_no = 2024/390
prev_hearing_date = 19/12/2024
hearing_date = 27/02/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 25
RecordId = 12676000010717
MapName trcmf1
SourceId 12676000010693
Select sysdate as sdt from dual
Time elapsed = 11
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 = 1000492
hearing_date = 27/02/2025
case_no = 2024/390
trn_rcms_caseregid = 18143000009936
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010717
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010693
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:35:10
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:35:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=27/02/2025 00:00:00
Param Type = c
case_no=2024/390
Param Type = c
trn_rcms_caseregid=18143000009936
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10183000009280 idvalue 0
Mapped case_no Row = 1 value = 2024/393 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 10183000009280
case_no = 2024/393
prev_hearing_date = 19/12/2024
hearing_date = 17/01/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 26
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 = 212
RecordId = 12676000010718
MapName trcmf1
SourceId 12676000010694
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 17/01/2025
case_no = 2024/393
trn_rcms_caseregid = 10183000009280
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010718
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010694
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:35:11
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:35:11
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=17/01/2025 00:00:00
Param Type = c
case_no=2024/393
Param Type = c
trn_rcms_caseregid=10183000009280
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11412000009370 idvalue 0
Mapped case_no Row = 1 value = 2024/465 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 11412000009370
case_no = 2024/465
prev_hearing_date = 19/12/2024
hearing_date = 17/01/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12676000010719
MapName trcmf1
SourceId 12676000010695
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 24
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 17/01/2025
case_no = 2024/465
trn_rcms_caseregid = 11412000009370
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010719
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010695
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:35:13
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:35:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=17/01/2025 00:00:00
Param Type = c
case_no=2024/465
Param Type = c
trn_rcms_caseregid=11412000009370
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13030000010440 idvalue 0
Mapped case_no Row = 1 value = 2024/486 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 13030000010440
case_no = 2024/486
prev_hearing_date = 19/12/2024
hearing_date = 17/01/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12676000010720
MapName trcmf1
SourceId 12676000010696
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 32
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 17/01/2025
case_no = 2024/486
trn_rcms_caseregid = 13030000010440
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010720
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010696
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:35:15
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:35:15
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=17/01/2025 00:00:00
Param Type = c
case_no=2024/486
Param Type = c
trn_rcms_caseregid=13030000010440
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13350000009098 idvalue 0
Mapped case_no Row = 1 value = 2024/492 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 27/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 13350000009098
case_no = 2024/492
prev_hearing_date = 19/12/2024
hearing_date = 27/02/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12676000010721
MapName trcmf1
SourceId 12676000010697
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 27/02/2025
case_no = 2024/492
trn_rcms_caseregid = 13350000009098
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010721
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010697
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:35:16
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:35:16
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=27/02/2025 00:00:00
Param Type = c
case_no=2024/492
Param Type = c
trn_rcms_caseregid=13350000009098
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12083000009956 idvalue 0
Mapped case_no Row = 1 value = 2024/591 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 27/02/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 12083000009956
case_no = 2024/591
prev_hearing_date = 19/12/2024
hearing_date = 27/02/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12676000010722
MapName trcmf1
SourceId 12676000010698
Select sysdate as sdt from dual
Time elapsed = 85
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 27/02/2025
case_no = 2024/591
trn_rcms_caseregid = 12083000009956
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010722
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010698
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:35:18
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:35:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=27/02/2025 00:00:00
Param Type = c
case_no=2024/591
Param Type = c
trn_rcms_caseregid=12083000009956
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15080000008042 idvalue 0
Mapped case_no Row = 1 value = 2024/65 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 15080000008042
case_no = 2024/65
prev_hearing_date = 19/12/2024
hearing_date = 17/01/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 8
RecordId = 12676000010723
MapName trcmf1
SourceId 12676000010699
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 217
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 17/01/2025
case_no = 2024/65
trn_rcms_caseregid = 15080000008042
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010723
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010699
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:35:20
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:35:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=17/01/2025 00:00:00
Param Type = c
case_no=2024/65
Param Type = c
trn_rcms_caseregid=15080000008042
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 18168 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19736000008847 idvalue 0
Mapped case_no Row = 1 value = 2024/83 idvalue 0
Mapped prev_hearing_date Row = 1 value = 19/12/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/01/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 18168
trn_rcms_caseregid = 19736000008847
case_no = 2024/83
prev_hearing_date = 19/12/2024
hearing_date = 17/01/2025
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 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 = 12676000010724
MapName trcmf1
SourceId 12676000010700
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 30
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 17/01/2025
case_no = 2024/83
trn_rcms_caseregid = 19736000008847
court_code = 18168
case_purpose = 1000492
prev_hearing_date = 19/12/2024
Posting record
Param Type = n
trn_rcms_case_histid=12676000010724
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12676000010700
Param Type = c
cancel=F
Param Type = c
createdby=adcsikar
Param Type = c
createdon=23/12/2024 12:35:21
Param Type = c
username=adcsikar
Param Type = c
modifiedon=23/12/2024 12:35: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=1000492
Param Type = c
hearing_date=17/01/2025 00:00:00
Param Type = c
case_no=2024/83
Param Type = c
trn_rcms_caseregid=19736000008847
Param Type = c
court_code=18168
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=19/12/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 = 3944118935757
Time elapsed for MD Map = 3944118935759
Time elapsed for Save History = 3944118935760
Time elapsed for Save Attachment = 3944118935762
Time elapsed for After Save WF Exec = 3944118935764
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"12676000010676"}]}
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=adcsikar
Param Type = c
calledon=23/12/2024 12:34:51
Param Type = c
callfinished=23/12/2024 12:35:35
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=44723
Param Type = n
dbtimetaken=41084
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