ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
gcmsACEM_chautan_01827ccb0eea8a706c4c34a16891f84e7b![]()
INRF500250000Ffiresql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtname := sqlget({m2},{court_name})firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})m_courttype := sqlget({m3},{court_type})firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})m_courtid := sqlget({m4},{court_name_mastid})firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})login_userid := sqlget({m4},{axusersid})firesql({m4},{select :username as uname from dual})u_name := sqlget({m4},{uname})firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtcode := sqlget({m4},{COURT_CODE})firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})m_statename := sqlget({m2},{STATE_NAME})firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_distName := sqlget({m7},{DISTNAMEENG})firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_courtcatid := sqlget({m8},{COURT_CATEGOTY})firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})m_deptid := sqlget({m4},{department_mastid})firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})m_courttypeid := sqlget({m3},{court_type_mastid})firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })urole := sqlget({m4},{groupname})firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})m_cutoffdt := sqlget({a1},{dd})firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})m_offcount := sqlget({P1},{ct})00000F
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
username=ACEM_chautan_01
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=ACEM_chautan_01
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ????? ??????? (FT), ?????, ???????
Result = ????? ??????? (FT), ?????, ???????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=ACEM_chautan_01
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=ACEM_chautan_01
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = ACEM FT
Result = ACEM FT
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=ACEM_chautan_01
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=ACEM_chautan_01
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 14002000000293
Result = 14002000000293
Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=ACEM_chautan_01
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 1235010008031
Result = 1235010008031
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=ACEM_chautan_01
Time elapsed = 12
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = ACEM_chautan_01
Result = ACEM_chautan_01
Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=ACEM_chautan_01
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 11131
Result = 11131
Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=ACEM_chautan_01
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ACEM_chautan_01
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Barmer
Result = Barmer
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=ACEM_chautan_01
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ACEM_chautan_01
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m8},{COURT_CATEGOTY})
Calling function sqlget
Result of sqlget = 10593000000007
Result = 10593000000007
Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
Calling function firesql
login_userid=1235010008031
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1235010008031
Time elapsed = 9
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=ACEM_chautan_01
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 12487000000154
Result = 12487000000154
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=ACEM_chautan_01
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=ACEM_chautan_01
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{groupname})
Calling function sqlget
Result of sqlget = court_reader
Result = court_reader
Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 4
Result of firesql =
Result =
Evaluating sqlget({a1},{dd})
Calling function sqlget
Result of sqlget = 30/01/2021
Result = 30/01/2021
Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
Calling function firesql
username=ACEM_chautan_01
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=ACEM_chautan_01
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 10
Result = 10
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='trcmf' and stype = 't' )
Time elapsed = 4
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 6
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Paramval : court_reader,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype
select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno
Time elapsed = 4
Reading data from stream
Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : trcmf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 5
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 = 11131
hearing_date = 24/04/2024
time zone difference = 0
>>Writing to tables trcmf
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'trcmf'
Time elapsed = 6
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where TRN_RCMS_MHEARINGid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008677
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 5
hearing_date = 24/04/2024
courtcode = 11131
Posting record
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:28
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=24/04/2024 00:00:00
Param Type = c
courtcode=11131
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 = 5
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 = 3
RecordId = 15284000008678
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 24/04/2024
pre_case_purpose = 1000497
trn_rcms_caseid = 13627000003005
court_code = 11131
case_no = 2018/00223
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 29/07/2024
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=15284000008678
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:28
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=13627000003005
Param Type = c
court_code=11131
Param Type = c
case_no=2018/00223
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008679
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 24/04/2024
pre_case_purpose = 1000490
trn_rcms_caseid = 13654000003301
court_code = 11131
case_no = 2018/00233
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000490
next_hear_date = 29/07/2024
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=15284000008679
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:28
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = n
pre_case_purpose=1000490
Param Type = c
trn_rcms_caseid=13654000003301
Param Type = c
court_code=11131
Param Type = c
case_no=2018/00233
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000490
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15284000008680
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 24/04/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 10437000006199
court_code = 11131
case_no = 2021/29
adjourn_type = 0
adjourn_remark =
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 29/07/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=15284000008680
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:29
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=10437000006199
Param Type = c
court_code=11131
Param Type = c
case_no=2021/29
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)
select * from TRN_RCMS_HEARING where TRN_RCMS_HEARINGid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 15284000008681
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 29/07/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2021/30
court_code = 11131
trn_rcms_caseid = 10447000005395
pre_case_purpose = 1000492
pre_hear_date = 24/04/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=15284000008681
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:29
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/30
Param Type = c
court_code=11131
Param Type = c
trn_rcms_caseid=10447000005395
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=24/04/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 = 5
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15284000008682
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 29/07/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2022/61
court_code = 11131
trn_rcms_caseid = 16875000006854
pre_case_purpose = 1000492
pre_hear_date = 24/04/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=15284000008682
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:29
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/61
Param Type = c
court_code=11131
Param Type = c
trn_rcms_caseid=16875000006854
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=24/04/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 = 4
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15284000008683
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
pre_case_purpose = 1000492
new_case_purpose = 1000492
next_hear_date = 29/07/2024
pre_hear_date = 24/04/2024
court_code = 11131
case_no = 2022/62
trn_rcms_caseid = 16878000007233
adjourn_remark =
adjourn_type = 0
isadjourn = NO
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=15284000008683
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:29
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:29
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=29/07/2024 00:00:00
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = c
court_code=11131
Param Type = c
case_no=2022/62
Param Type = c
trn_rcms_caseid=16878000007233
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 = 4
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008684
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trn_rcms_caseid = 14484000002897
pre_hear_date = 24/04/2024
new_case_purpose = 1000507
pre_case_purpose = 1000507
court_code = 11131
case_no = 2018/00005
adjourn_remark =
next_hear_date = 07/05/2024
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=15284000008684
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:29
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=14484000002897
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = c
new_case_purpose=1000507
Param Type = n
pre_case_purpose=1000507
Param Type = c
court_code=11131
Param Type = c
case_no=2018/00005
Param Type = c
next_hear_date=07/05/2024 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 = 5
Adding new record to store data from Frame 2, Row 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008685
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
new_case_purpose = 1000525
isadjourn = NO
next_hear_date = 29/07/2024
pre_case_purpose = 1000525
case_no = 2018/00015
court_code = 11131
pre_hear_date = 24/04/2024
trn_rcms_caseid = 18403000002494
adjourn_remark =
adjourn_type = 0
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=15284000008685
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:29
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000525
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = n
pre_case_purpose=1000525
Param Type = c
case_no=2018/00015
Param Type = c
court_code=11131
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = c
trn_rcms_caseid=18403000002494
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 = 5
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15284000008686
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
case_no = 2018/00016
new_case_purpose = 12555000000002
pre_case_purpose = 12555000000002
trn_rcms_caseid = 18475000003084
pre_hear_date = 24/04/2024
adjourn_remark =
court_code = 11131
adjourn_type = 0
next_hear_date = 29/07/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=15284000008686
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:29
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2018/00016
Param Type = c
new_case_purpose=12555000000002
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
trn_rcms_caseid=18475000003084
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = c
court_code=11131
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=29/07/2024 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 = 5
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008687
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 11/06/2024
new_case_purpose = 12555000000002
isadjourn = NO
adjourn_remark =
adjourn_type = 0
case_no = 2018/00215
court_code = 11131
trn_rcms_caseid = 12861000003236
pre_case_purpose = 12555000000002
pre_hear_date = 24/04/2024
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=15284000008687
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:29
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/06/2024 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2018/00215
Param Type = c
court_code=11131
Param Type = c
trn_rcms_caseid=12861000003236
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
pre_hear_date=24/04/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 = 4
Adding new record to store data from Frame 2, Row 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15284000008688
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 11/06/2024
isadjourn = NO
new_case_purpose = 12555000000002
pre_case_purpose = 12555000000002
pre_hear_date = 24/04/2024
case_no = 2018/00216
court_code = 11131
trn_rcms_caseid = 12866000003336
adjourn_type = 0
adjourn_remark =
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=15284000008688
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:29
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=11/06/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=12555000000002
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = c
case_no=2018/00216
Param Type = c
court_code=11131
Param Type = c
trn_rcms_caseid=12866000003336
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 = 5
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15284000008689
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 0
case_no = 2018/00232
court_code = 11131
isadjourn = NO
next_hear_date = 29/07/2024
pre_case_purpose = 12555000000002
new_case_purpose = 12555000000002
pre_hear_date = 24/04/2024
adjourn_remark =
trn_rcms_caseid = 13650000003572
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=15284000008689
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:29
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
case_no=2018/00232
Param Type = c
court_code=11131
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
new_case_purpose=12555000000002
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = c
trn_rcms_caseid=13650000003572
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 = 6
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15284000008690
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
court_code = 11131
isadjourn = NO
next_hear_date = 03/05/2024
adjourn_remark =
adjourn_type = 0
new_case_purpose = 12555000000002
pre_hear_date = 24/04/2024
trn_rcms_caseid = 12251000003553
case_no = 2018/00277
pre_case_purpose = 12555000000002
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=15284000008690
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:29
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=11131
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=03/05/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=12555000000002
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = c
trn_rcms_caseid=12251000003553
Param Type = c
case_no=2018/00277
Param Type = n
pre_case_purpose=12555000000002
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 = 4
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15284000008691
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
court_code = 11131
pre_case_purpose = 18468000000000
case_no = 2018/00140
trn_rcms_caseid = 10552000002486
pre_hear_date = 24/04/2024
new_case_purpose = 18468000000000
adjourn_type = 0
adjourn_remark =
next_hear_date = 10/06/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=15284000008691
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:30
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=11131
Param Type = n
pre_case_purpose=18468000000000
Param Type = c
case_no=2018/00140
Param Type = c
trn_rcms_caseid=10552000002486
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = c
new_case_purpose=18468000000000
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=10/06/2024 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 = 5
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 15284000008692
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
trn_rcms_caseid = 16991000002794
pre_hear_date = 24/04/2024
court_code = 11131
case_no = 2018/00002
pre_case_purpose = 18470000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18470000000000
next_hear_date = 29/07/2024
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=15284000008692
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:30
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=16991000002794
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = c
court_code=11131
Param Type = c
case_no=2018/00002
Param Type = n
pre_case_purpose=18470000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18470000000000
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 16
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15284000008693
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
isadjourn = NO
trn_rcms_caseid = 14995000002710
court_code = 11131
case_no = 2018/00094
pre_hear_date = 24/04/2024
new_case_purpose = 18470000000000
adjourn_type = 0
pre_case_purpose = 18470000000000
next_hear_date = 29/07/2024
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=15284000008693
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:30
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=14995000002710
Param Type = c
court_code=11131
Param Type = c
case_no=2018/00094
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = c
new_case_purpose=18470000000000
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=18470000000000
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 4
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008694
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 17712000002765
pre_hear_date = 24/04/2024
court_code = 11131
case_no = 2018/00181
next_hear_date = 29/07/2024
isadjourn = NO
pre_case_purpose = 18470000000000
new_case_purpose = 18470000000000
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=15284000008694
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:30
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=17712000002765
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = c
court_code=11131
Param Type = c
case_no=2018/00181
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18470000000000
Param Type = c
new_case_purpose=18470000000000
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 = 6
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 = 3
RecordId = 15284000008695
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 18880000004589
pre_hear_date = 24/04/2024
court_code = 11131
case_no = 2020/00043
next_hear_date = 29/07/2024
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=15284000008695
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:30
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18880000004589
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = c
court_code=11131
Param Type = c
case_no=2020/00043
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=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 = 3
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008696
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_type = 0
adjourn_remark =
isadjourn = NO
case_no = 2020/00044
trn_rcms_caseid = 18891000003905
pre_case_purpose = 18678000000000
court_code = 11131
next_hear_date = 29/07/2024
new_case_purpose = 18678000000000
pre_hear_date = 24/04/2024
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=15284000008696
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:30
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:30
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=2020/00044
Param Type = c
trn_rcms_caseid=18891000003905
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=11131
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/04/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 = 4
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 = 2
RecordId = 15284000008697
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_type = 0
adjourn_remark =
trn_rcms_caseid = 15455000006182
case_no = 2023/107
court_code = 11131
pre_hear_date = 24/04/2024
next_hear_date = 29/07/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=15284000008697
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:30
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:30
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=15455000006182
Param Type = c
case_no=2023/107
Param Type = c
court_code=11131
Param Type = c
pre_hear_date=24/04/2024 00:00:00
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
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 = 5
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15284000008698
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_remark =
adjourn_type = 0
next_hear_date = 29/07/2024
trn_rcms_caseid = 15466000007498
case_no = 2023/108
court_code = 11131
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 24/04/2024
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=15284000008698
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:30
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:30
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=29/07/2024 00:00:00
Param Type = c
trn_rcms_caseid=15466000007498
Param Type = c
case_no=2023/108
Param Type = c
court_code=11131
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=24/04/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 = 4
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 15284000008699
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 29/07/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
trn_rcms_caseid = 13649000003291
court_code = 11131
case_no = 2018/00231
new_case_purpose = 10663000002303
pre_case_purpose = 10663000002303
pre_hear_date = 24/04/2024
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=15284000008699
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:30
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:30
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13649000003291
Param Type = c
court_code=11131
Param Type = c
case_no=2018/00231
Param Type = c
new_case_purpose=10663000002303
Param Type = n
pre_case_purpose=10663000002303
Param Type = c
pre_hear_date=24/04/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 = 4
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008700
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 25
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 10/06/2024
isadjourn = NO
adjourn_remark =
adjourn_type = 0
new_case_purpose = 10189000000601
case_no = 2018/00141
court_code = 11131
trn_rcms_caseid = 10621000002286
pre_case_purpose = 10189000000601
pre_hear_date = 24/04/2024
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=15284000008700
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:31
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=10/06/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=10189000000601
Param Type = c
case_no=2018/00141
Param Type = c
court_code=11131
Param Type = c
trn_rcms_caseid=10621000002286
Param Type = n
pre_case_purpose=10189000000601
Param Type = c
pre_hear_date=24/04/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 = 4
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 = 3
RecordId = 15284000008701
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 29/07/2024
new_case_purpose = 10189000000601
adjourn_remark =
adjourn_type = 0
isadjourn = NO
case_no = 2018/00234
court_code = 11131
trn_rcms_caseid = 13656000002684
pre_case_purpose = 10189000000601
pre_hear_date = 24/04/2024
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=15284000008701
Param Type = n
trn_rcms_mhearingid=15284000008677
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:31
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=29/07/2024 00:00:00
Param Type = c
new_case_purpose=10189000000601
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2018/00234
Param Type = c
court_code=11131
Param Type = c
trn_rcms_caseid=13656000002684
Param Type = n
pre_case_purpose=10189000000601
Param Type = c
pre_hear_date=24/04/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 = 3923551458130
>>Executing genmaps
>>Posting from trcmf to tchdh from row 1
>>Mapping
Mapped court_code Row = 1 value = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13627000003005 idvalue 0
Mapped case_no Row = 1 value = 2018/00223 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 13627000003005
case_no = 2018/00223
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ???? ?????????
prev_case_purpose =
prev_case_purposename=???? ?????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????????
Time elapsed = 8
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 13
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 16
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008702
MapName trcmf1
SourceId 15284000008678
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 17
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 29/07/2024
case_no = 2018/00223
trn_rcms_caseregid = 13627000003005
court_code = 11131
case_purpose = 1000497
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008702
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008678
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:31
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2018/00223
Param Type = c
trn_rcms_caseregid=13627000003005
Param Type = c
court_code=11131
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13654000003301 idvalue 0
Mapped case_no Row = 1 value = 2018/00233 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? / ??????? idvalue 0
Mapped case_purpose Row = 1 value = 1000490 idvalue 0
Mapped hearing_date Row = 1 value = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 13654000003301
case_no = 2018/00233
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ???????? / ???????
prev_case_purpose =
prev_case_purposename=???????? / ???????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???????? / ???????
Time elapsed = 17
prev_case_purpose after validation = 1000490
case_purpose = 1000490
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008703
MapName trcmf1
SourceId 15284000008679
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000490
hearing_date = 29/07/2024
case_no = 2018/00233
trn_rcms_caseregid = 13654000003301
court_code = 11131
case_purpose = 1000490
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008703
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008679
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:31
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000490
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2018/00233
Param Type = c
trn_rcms_caseregid=13654000003301
Param Type = c
court_code=11131
Param Type = c
case_purpose=1000490
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10437000006199 idvalue 0
Mapped case_no Row = 1 value = 2021/29 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/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 = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 10437000006199
case_no = 2021/29
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purposename=?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=?????
Time elapsed = 5
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008704
MapName trcmf1
SourceId 15284000008680
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 29/07/2024
case_no = 2021/29
trn_rcms_caseregid = 10437000006199
court_code = 11131
case_purpose = 1000492
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008704
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008680
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:31
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2021/29
Param Type = c
trn_rcms_caseregid=10437000006199
Param Type = c
court_code=11131
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10447000005395 idvalue 0
Mapped case_no Row = 1 value = 2021/30 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/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 = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 10447000005395
case_no = 2021/30
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 15284000008705
MapName trcmf1
SourceId 15284000008681
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 29/07/2024
case_no = 2021/30
trn_rcms_caseregid = 10447000005395
court_code = 11131
case_purpose = 1000492
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008705
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008681
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:31
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2021/30
Param Type = c
trn_rcms_caseregid=10447000005395
Param Type = c
court_code=11131
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16875000006854 idvalue 0
Mapped case_no Row = 1 value = 2022/61 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/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 = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 16875000006854
case_no = 2022/61
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15284000008706
MapName trcmf1
SourceId 15284000008682
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 29/07/2024
case_no = 2022/61
trn_rcms_caseregid = 16875000006854
court_code = 11131
case_purpose = 1000492
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008706
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008682
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:31
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2022/61
Param Type = c
trn_rcms_caseregid=16875000006854
Param Type = c
court_code=11131
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16878000007233 idvalue 0
Mapped case_no Row = 1 value = 2022/62 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/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 = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 16878000007233
case_no = 2022/62
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ?????
prev_case_purpose =
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008707
MapName trcmf1
SourceId 15284000008683
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 29/07/2024
case_no = 2022/62
trn_rcms_caseregid = 16878000007233
court_code = 11131
case_purpose = 1000492
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008707
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008683
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:32
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2022/62
Param Type = c
trn_rcms_caseregid=16878000007233
Param Type = c
court_code=11131
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14484000002897 idvalue 0
Mapped case_no Row = 1 value = 2018/00005 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000507 idvalue 0
Mapped hearing_date Row = 1 value = 07/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 14484000002897
case_no = 2018/00005
prev_hearing_date = 24/04/2024
hearing_date = 07/05/2024
prev_case_purposename = ???? ?????
prev_case_purpose =
prev_case_purposename=???? ?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????
Time elapsed = 6
prev_case_purpose after validation = 1000507
case_purpose = 1000507
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15284000008708
MapName trcmf1
SourceId 15284000008684
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000507
hearing_date = 07/05/2024
case_no = 2018/00005
trn_rcms_caseregid = 14484000002897
court_code = 11131
case_purpose = 1000507
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008708
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008684
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:32
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000507
Param Type = c
hearing_date=07/05/2024 00:00:00
Param Type = c
case_no=2018/00005
Param Type = c
trn_rcms_caseregid=14484000002897
Param Type = c
court_code=11131
Param Type = c
case_purpose=1000507
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18403000002494 idvalue 0
Mapped case_no Row = 1 value = 2018/00015 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 18403000002494
case_no = 2018/00015
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ???? ????
prev_case_purpose =
prev_case_purposename=???? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????
Time elapsed = 9
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008709
MapName trcmf1
SourceId 15284000008685
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 29/07/2024
case_no = 2018/00015
trn_rcms_caseregid = 18403000002494
court_code = 11131
case_purpose = 1000525
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008709
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008685
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:32
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2018/00015
Param Type = c
trn_rcms_caseregid=18403000002494
Param Type = c
court_code=11131
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18475000003084 idvalue 0
Mapped case_no Row = 1 value = 2018/00016 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 18475000003084
case_no = 2018/00016
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purposename=???? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ????????? ????
Time elapsed = 7
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008710
MapName trcmf1
SourceId 15284000008686
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 29/07/2024
case_no = 2018/00016
trn_rcms_caseregid = 18475000003084
court_code = 11131
case_purpose = 12555000000002
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008710
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008686
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:32
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2018/00016
Param Type = c
trn_rcms_caseregid=18475000003084
Param Type = c
court_code=11131
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12861000003236 idvalue 0
Mapped case_no Row = 1 value = 2018/00215 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 11/06/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 12861000003236
case_no = 2018/00215
prev_hearing_date = 24/04/2024
hearing_date = 11/06/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15284000008711
MapName trcmf1
SourceId 15284000008687
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 11/06/2024
case_no = 2018/00215
trn_rcms_caseregid = 12861000003236
court_code = 11131
case_purpose = 12555000000002
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008711
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008687
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:32
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=11/06/2024 00:00:00
Param Type = c
case_no=2018/00215
Param Type = c
trn_rcms_caseregid=12861000003236
Param Type = c
court_code=11131
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12866000003336 idvalue 0
Mapped case_no Row = 1 value = 2018/00216 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 11/06/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 12866000003336
case_no = 2018/00216
prev_hearing_date = 24/04/2024
hearing_date = 11/06/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008712
MapName trcmf1
SourceId 15284000008688
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 11/06/2024
case_no = 2018/00216
trn_rcms_caseregid = 12866000003336
court_code = 11131
case_purpose = 12555000000002
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008712
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008688
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:32
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=11/06/2024 00:00:00
Param Type = c
case_no=2018/00216
Param Type = c
trn_rcms_caseregid=12866000003336
Param Type = c
court_code=11131
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13650000003572 idvalue 0
Mapped case_no Row = 1 value = 2018/00232 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 13650000003572
case_no = 2018/00232
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15284000008713
MapName trcmf1
SourceId 15284000008689
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 29/07/2024
case_no = 2018/00232
trn_rcms_caseregid = 13650000003572
court_code = 11131
case_purpose = 12555000000002
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008713
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008689
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:33
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2018/00232
Param Type = c
trn_rcms_caseregid=13650000003572
Param Type = c
court_code=11131
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12251000003553 idvalue 0
Mapped case_no Row = 1 value = 2018/00277 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 12251000003553
case_no = 2018/00277
prev_hearing_date = 24/04/2024
hearing_date = 03/05/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose =
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 18
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008714
MapName trcmf1
SourceId 15284000008690
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 03/05/2024
case_no = 2018/00277
trn_rcms_caseregid = 12251000003553
court_code = 11131
case_purpose = 12555000000002
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008714
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008690
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:33
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=03/05/2024 00:00:00
Param Type = c
case_no=2018/00277
Param Type = c
trn_rcms_caseregid=12251000003553
Param Type = c
court_code=11131
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10552000002486 idvalue 0
Mapped case_no Row = 1 value = 2018/00140 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 18468000000000 idvalue 0
Mapped hearing_date Row = 1 value = 10/06/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 10552000002486
case_no = 2018/00140
prev_hearing_date = 24/04/2024
hearing_date = 10/06/2024
prev_case_purposename = ??????? ?????????
prev_case_purpose =
prev_case_purposename=??????? ?????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ?????????
Time elapsed = 17
prev_case_purpose after validation = 18468000000000
case_purpose = 18468000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 10
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008715
MapName trcmf1
SourceId 15284000008691
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18468000000000
hearing_date = 10/06/2024
case_no = 2018/00140
trn_rcms_caseregid = 10552000002486
court_code = 11131
case_purpose = 18468000000000
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008715
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008691
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:33
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18468000000000
Param Type = c
hearing_date=10/06/2024 00:00:00
Param Type = c
case_no=2018/00140
Param Type = c
trn_rcms_caseregid=10552000002486
Param Type = c
court_code=11131
Param Type = c
case_purpose=18468000000000
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16991000002794 idvalue 0
Mapped case_no Row = 1 value = 2018/00002 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ?????? ???????? idvalue 0
Mapped case_purpose Row = 1 value = 18470000000000 idvalue 0
Mapped hearing_date Row = 1 value = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 16991000002794
case_no = 2018/00002
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ??????? ?????? ????????
prev_case_purpose =
prev_case_purposename=??????? ?????? ????????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=??????? ?????? ????????
Time elapsed = 5
prev_case_purpose after validation = 18470000000000
case_purpose = 18470000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15284000008716
MapName trcmf1
SourceId 15284000008692
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18470000000000
hearing_date = 29/07/2024
case_no = 2018/00002
trn_rcms_caseregid = 16991000002794
court_code = 11131
case_purpose = 18470000000000
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008716
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008692
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:33
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18470000000000
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2018/00002
Param Type = c
trn_rcms_caseregid=16991000002794
Param Type = c
court_code=11131
Param Type = c
case_purpose=18470000000000
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14995000002710 idvalue 0
Mapped case_no Row = 1 value = 2018/00094 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ?????? ???????? idvalue 0
Mapped case_purpose Row = 1 value = 18470000000000 idvalue 0
Mapped hearing_date Row = 1 value = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 14995000002710
case_no = 2018/00094
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ??????? ?????? ????????
prev_case_purpose =
prev_case_purpose after validation = 18470000000000
case_purpose = 18470000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15284000008717
MapName trcmf1
SourceId 15284000008693
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18470000000000
hearing_date = 29/07/2024
case_no = 2018/00094
trn_rcms_caseregid = 14995000002710
court_code = 11131
case_purpose = 18470000000000
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008717
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008693
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:33
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18470000000000
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2018/00094
Param Type = c
trn_rcms_caseregid=14995000002710
Param Type = c
court_code=11131
Param Type = c
case_purpose=18470000000000
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17712000002765 idvalue 0
Mapped case_no Row = 1 value = 2018/00181 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ?????? ???????? idvalue 0
Mapped case_purpose Row = 1 value = 18470000000000 idvalue 0
Mapped hearing_date Row = 1 value = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 17712000002765
case_no = 2018/00181
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ??????? ?????? ????????
prev_case_purpose =
prev_case_purpose after validation = 18470000000000
case_purpose = 18470000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15284000008718
MapName trcmf1
SourceId 15284000008694
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18470000000000
hearing_date = 29/07/2024
case_no = 2018/00181
trn_rcms_caseregid = 17712000002765
court_code = 11131
case_purpose = 18470000000000
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008718
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008694
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:33
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:33
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18470000000000
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2018/00181
Param Type = c
trn_rcms_caseregid=17712000002765
Param Type = c
court_code=11131
Param Type = c
case_purpose=18470000000000
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18880000004589 idvalue 0
Mapped case_no Row = 1 value = 2020/00043 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 18880000004589
case_no = 2020/00043
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=????
Time elapsed = 5
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008719
MapName trcmf1
SourceId 15284000008695
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 29/07/2024
case_no = 2020/00043
trn_rcms_caseregid = 18880000004589
court_code = 11131
case_purpose = 18678000000000
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008719
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008695
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:34
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2020/00043
Param Type = c
trn_rcms_caseregid=18880000004589
Param Type = c
court_code=11131
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18891000003905 idvalue 0
Mapped case_no Row = 1 value = 2020/00044 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 18891000003905
case_no = 2020/00044
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 17
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15284000008720
MapName trcmf1
SourceId 15284000008696
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 29/07/2024
case_no = 2020/00044
trn_rcms_caseregid = 18891000003905
court_code = 11131
case_purpose = 18678000000000
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008720
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008696
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:34
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2020/00044
Param Type = c
trn_rcms_caseregid=18891000003905
Param Type = c
court_code=11131
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15455000006182 idvalue 0
Mapped case_no Row = 1 value = 2023/107 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 15455000006182
case_no = 2023/107
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008721
MapName trcmf1
SourceId 15284000008697
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 29/07/2024
case_no = 2023/107
trn_rcms_caseregid = 15455000006182
court_code = 11131
case_purpose = 18678000000000
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008721
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008697
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:34
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2023/107
Param Type = c
trn_rcms_caseregid=15455000006182
Param Type = c
court_code=11131
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15466000007498 idvalue 0
Mapped case_no Row = 1 value = 2023/108 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 15466000007498
case_no = 2023/108
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ????
prev_case_purpose =
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 15284000008722
MapName trcmf1
SourceId 15284000008698
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 29/07/2024
case_no = 2023/108
trn_rcms_caseregid = 15466000007498
court_code = 11131
case_purpose = 18678000000000
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008722
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008698
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:34
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2023/108
Param Type = c
trn_rcms_caseregid=15466000007498
Param Type = c
court_code=11131
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13649000003291 idvalue 0
Mapped case_no Row = 1 value = 2018/00231 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 10663000002303 idvalue 0
Mapped hearing_date Row = 1 value = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 13649000003291
case_no = 2018/00231
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
prev_case_purposename = ???? ?????
prev_case_purpose =
prev_case_purposename=???? ?????
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???? ?????
Time elapsed = 9
prev_case_purpose after validation = 10663000002303
case_purpose = 10663000002303
trans_type = Feedback Submitted (Custom)
clcheck =
isadjourn = NO
adjourn_type = 0
decision_type =
decision_date =
>>Writing to tables tchdh
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tchdh'
Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 15284000008723
MapName trcmf1
SourceId 15284000008699
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 17
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 10663000002303
hearing_date = 29/07/2024
case_no = 2018/00231
trn_rcms_caseregid = 13649000003291
court_code = 11131
case_purpose = 10663000002303
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008723
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008699
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:34
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10663000002303
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2018/00231
Param Type = c
trn_rcms_caseregid=13649000003291
Param Type = c
court_code=11131
Param Type = c
case_purpose=10663000002303
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10621000002286 idvalue 0
Mapped case_no Row = 1 value = 2018/00141 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/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 = 10/06/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 10621000002286
case_no = 2018/00141
prev_hearing_date = 24/04/2024
hearing_date = 10/06/2024
prev_case_purposename = ???.
prev_case_purpose =
prev_case_purposename=???.
SELECT V.CASE_PURPOSE_MASTID
FROM case_purpose_mast v
WHERE v.case_purpose_name = :prev_case_purposename
prev_case_purposename=???.
Time elapsed = 6
prev_case_purpose after validation = 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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 15284000008724
MapName trcmf1
SourceId 15284000008700
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 10189000000601
hearing_date = 10/06/2024
case_no = 2018/00141
trn_rcms_caseregid = 10621000002286
court_code = 11131
case_purpose = 10189000000601
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008724
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008700
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:35
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10189000000601
Param Type = c
hearing_date=10/06/2024 00:00:00
Param Type = c
case_no=2018/00141
Param Type = c
trn_rcms_caseregid=10621000002286
Param Type = c
court_code=11131
Param Type = c
case_purpose=10189000000601
Param Type = c
prev_hearing_date=24/04/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 = 11131 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13656000002684 idvalue 0
Mapped case_no Row = 1 value = 2018/00234 idvalue 0
Mapped prev_hearing_date Row = 1 value = 24/04/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 = 29/07/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0
>>Validating tchdh
>>Frame No 1
court_code = 11131
trn_rcms_caseregid = 13656000002684
case_no = 2018/00234
prev_hearing_date = 24/04/2024
hearing_date = 29/07/2024
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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where TRN_RCMS_CASE_HISTid=0
Time elapsed = 15
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 = 15284000008725
MapName trcmf1
SourceId 15284000008701
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date =
decision_type = 0
prev_case_purpose = 10189000000601
hearing_date = 29/07/2024
case_no = 2018/00234
trn_rcms_caseregid = 13656000002684
court_code = 11131
case_purpose = 10189000000601
prev_hearing_date = 24/04/2024
Posting record
Param Type = n
trn_rcms_case_histid=15284000008725
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15284000008701
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_chautan_01
Param Type = c
createdon=29/04/2024 11:24:35
Param Type = c
username=ACEM_chautan_01
Param Type = c
modifiedon=29/04/2024 11:24:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10189000000601
Param Type = c
hearing_date=29/07/2024 00:00:00
Param Type = c
case_no=2018/00234
Param Type = c
trn_rcms_caseregid=13656000002684
Param Type = c
court_code=11131
Param Type = c
case_purpose=10189000000601
Param Type = c
prev_hearing_date=24/04/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 = 3923551462197
Time elapsed for MD Map = 3923551462198
Time elapsed for Save History = 3923551462200
Time elapsed for Save Attachment = 3923551462201
Time elapsed for After Save WF Exec = 3923551462206
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"15284000008677"}]}
Savedata webservice completed
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=ACEM_chautan_01
Param Type = c
calledon=29/04/2024 11:24:15
Param Type = c
callfinished=29/04/2024 11:24:22
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=7249
Param Type = n
dbtimetaken=4324
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