ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
gcmsADM_dosa_r827ccb0eea8a706c4c34a16891f84e7brctcr00103661818801283600000011910366153266000830618188158120000076262023/6710366-18188#2023/6708/11/20230T01283600000011910366153266000830618188166370000085072023/1210366-18188#2023/1208/11/20230T01283600000011910366153266000830618188165360000069402023/1110366-18188#2023/1108/11/20230T01283600000011910366153266000830618188108500000071162022/31910366-18188#2022/31908/11/20230T01283600000011910366153266000830618188166360000077662022/31410366-18188#2022/31408/11/20230T01283600000011910366153266000830618188165890000071912022/31310366-18188#2022/31308/11/20230T01283600000011910366153266000830618188183730000068492022/13210366-18188#2022/13208/11/20230T01283600000011910366153266000830618188180210000063902022/13110366-18188#2022/13108/11/20230T01283600000011910366153266000830618188190790000035372019/0030510366-18188#2019/0030508/11/20230T01283600000011910366153266000830618188149500000059362021/13010366-18188#2021/13008/11/20230T01283600000011910366153266000830618188168420000058912021/12710366-18188#2021/12708/11/20230T01283600000011910366153266000830618188168230000059582021/12610366-18188#2021/12608/11/20230T01283600000011910366153266000830618188167880000051582021/12510366-18188#2021/12508/11/20230T01283600000011910366153266000830618188167640000054352021/12410366-18188#2021/12408/11/20230T01283600000011910366153266000830618188171050000067902021/12810366-18188#2021/12808/11/20230T01283600000011910366153266000830618188135050000063662021/14610366-18188#2021/14608/11/20230T01283600000011910366153266000830618188157980000047612021/310366-18188#2021/308/11/20230T01283600000011910366153266000830618188185080000053242020/0014610366-18188#2020/0014608/11/20230T01283600000011910366153266000830618188164790000040282020/0003610366-18188#2020/0003608/11/20230T01283600000011910366153266000830618188127730000023702019/0017110366-18188#2019/0017108/11/20230T01283600000011910366153266000830618188193370000027962019/0014010366-18188#2019/0014008/11/20230T01283600000011910366153266000830618188192310000024252019/0013910366-18188#2019/0013908/11/20230T01283600000011910366153266000830618188189940000024162019/0013810366-18188#2019/0013808/11/20230T01283600000011910366153266000830618188117310000024922018/0029510366-18188#2018/0029508/11/20230T01283600000011910366153266000830618188115810000026452018/0029410366-18188#2018/0029408/11/20230T01283600000011910366153266000830618188111490000016432018/0020010366-18188#2018/0020008/11/20230T01283600000011910366153266000830618188113430000022702018/0016510366-18188#2018/0016508/11/20230T01283600000011910366153266000830618188112970000018352018/0016410366-18188#2018/0016408/11/20230T01283600000011910366153266000830618188112620000020212018/0016310366-18188#2018/0016308/11/20230T01283600000011910366153266000830618188112170000021072018/0016210366-18188#2018/0016208/11/20230T01283600000011910366153266000830618188114120000015312017/0072510366-18188#2017/0072508/11/20230T01283600000011910366153266000830618188107800000013132017/0072110366-18188#2017/0072108/11/20230T01283600000011910366153266000830618188154810000012582017/0054710366-18188#2017/0054708/11/20230T01283600000011910366153266000830618188198390000008592017/0054310366-18188#2017/0054308/11/20230T01283600000011910366153266000830618188108170000002682016/0022210366-18188#2016/0022208/11/20230T01283600000011910366153266000830618188107670000002512016/0022010366-18188#2016/0022008/11/20230T01283600000011910366153266000830618188179650000001852016/0006810366-18188#2016/0006808/11/20230T01283600000011910366153266000830618188178770000001932016/0006710366-18188#2016/0006708/11/20230T01283600000011910366153266000830618188187660000010082016/0036510366-18188#2016/0036508/11/20230T01283600000011910366153266000830618188173450000001462015/0024410366-18188#2015/0024408/11/20230T01283600000011910366153266000830618188181970000003512015/0044710366-18188#2015/0044708/11/20230T01283600000011910366153266000830618188130290000002672014/0008810366-18188#2014/0008808/11/20230T01283600000011910366153266000830618188178430000001952014/0006610366-18188#2014/0006608/11/20230T01283600000011910366153266000830618188172670000003322013/0005910366-18188#2013/0005908/11/20230T01283600000011910366153266000830618188132350000003002013/0004410366-18188#2013/0004408/11/20230T01283600000011910366153266000830618188194800000006072011/0001110366-18188#2011/0001108/11/20230T01283600000011910366153266000830618188140620000002482010/0000610366-18188#2010/0000608/11/20230T01283600000011910366153266000830618188143230000001322010/0000710366-18188#2010/0000708/11/20230T01283600000011910366153266000830618188196610000001052010/0000510366-18188#2010/0000508/11/20230T01283600000011910366153266000830618188164720000002452007/0000510366-18188#2007/0000508/11/20230T01283600000011910366153266000830618188112750000004142005/0000410366-18188#2005/0000408/11/20230T01283600000011910366153266000830618188110530000003322002/0000410366-18188#2002/0000408/11/20230T01283600000011910366153266000830618188104630000004062002/0000210366-18188#2002/0000208/11/20230T01283600000011910366153266000830618188105750000003312002/0000310366-18188#2002/0000308/11/20230T01283600000011910366153266000830618188100390000002032002/0000110366-18188#2002/0000108/11/20230T
Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"ADM_dosa_r","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"rctcr","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"court_code":"10366","trans_ccode":"18188"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"15812000007626","case_no":"2023/67","requestno":"10366-18188#2023/67","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"002","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16637000008507","case_no":"2023/12","requestno":"10366-18188#2023/12","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"003","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16536000006940","case_no":"2023/11","requestno":"10366-18188#2023/11","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"004","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"10850000007116","case_no":"2022/319","requestno":"10366-18188#2022/319","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"005","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16636000007766","case_no":"2022/314","requestno":"10366-18188#2022/314","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"006","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16589000007191","case_no":"2022/313","requestno":"10366-18188#2022/313","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"007","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"18373000006849","case_no":"2022/132","requestno":"10366-18188#2022/132","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"008","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"18021000006390","case_no":"2022/131","requestno":"10366-18188#2022/131","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"009","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"19079000003537","case_no":"2019/00305","requestno":"10366-18188#2019/00305","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0010","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"14950000005936","case_no":"2021/130","requestno":"10366-18188#2021/130","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0011","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16842000005891","case_no":"2021/127","requestno":"10366-18188#2021/127","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0012","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16823000005958","case_no":"2021/126","requestno":"10366-18188#2021/126","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0013","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16788000005158","case_no":"2021/125","requestno":"10366-18188#2021/125","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0014","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16764000005435","case_no":"2021/124","requestno":"10366-18188#2021/124","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0015","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"17105000006790","case_no":"2021/128","requestno":"10366-18188#2021/128","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0016","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"13505000006366","case_no":"2021/146","requestno":"10366-18188#2021/146","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0017","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"15798000004761","case_no":"2021/3","requestno":"10366-18188#2021/3","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0018","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"18508000005324","case_no":"2020/00146","requestno":"10366-18188#2020/00146","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0019","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16479000004028","case_no":"2020/00036","requestno":"10366-18188#2020/00036","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0020","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"12773000002370","case_no":"2019/00171","requestno":"10366-18188#2019/00171","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0021","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"19337000002796","case_no":"2019/00140","requestno":"10366-18188#2019/00140","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0022","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"19231000002425","case_no":"2019/00139","requestno":"10366-18188#2019/00139","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0023","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"18994000002416","case_no":"2019/00138","requestno":"10366-18188#2019/00138","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0024","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11731000002492","case_no":"2018/00295","requestno":"10366-18188#2018/00295","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0025","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11581000002645","case_no":"2018/00294","requestno":"10366-18188#2018/00294","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0026","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11149000001643","case_no":"2018/00200","requestno":"10366-18188#2018/00200","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0027","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11343000002270","case_no":"2018/00165","requestno":"10366-18188#2018/00165","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0028","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11297000001835","case_no":"2018/00164","requestno":"10366-18188#2018/00164","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0029","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11262000002021","case_no":"2018/00163","requestno":"10366-18188#2018/00163","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0030","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11217000002107","case_no":"2018/00162","requestno":"10366-18188#2018/00162","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0031","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11412000001531","case_no":"2017/00725","requestno":"10366-18188#2017/00725","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0032","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"10780000001313","case_no":"2017/00721","requestno":"10366-18188#2017/00721","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0033","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"15481000001258","case_no":"2017/00547","requestno":"10366-18188#2017/00547","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0034","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"19839000000859","case_no":"2017/00543","requestno":"10366-18188#2017/00543","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0035","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"10817000000268","case_no":"2016/00222","requestno":"10366-18188#2016/00222","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0036","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"10767000000251","case_no":"2016/00220","requestno":"10366-18188#2016/00220","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0037","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"17965000000185","case_no":"2016/00068","requestno":"10366-18188#2016/00068","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0038","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"17877000000193","case_no":"2016/00067","requestno":"10366-18188#2016/00067","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0039","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"18766000001008","case_no":"2016/00365","requestno":"10366-18188#2016/00365","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0040","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"17345000000146","case_no":"2015/00244","requestno":"10366-18188#2015/00244","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0041","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"18197000000351","case_no":"2015/00447","requestno":"10366-18188#2015/00447","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0042","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"13029000000267","case_no":"2014/00088","requestno":"10366-18188#2014/00088","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0043","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"17843000000195","case_no":"2014/00066","requestno":"10366-18188#2014/00066","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0044","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"17267000000332","case_no":"2013/00059","requestno":"10366-18188#2013/00059","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0045","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"13235000000300","case_no":"2013/00044","requestno":"10366-18188#2013/00044","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0046","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"19480000000607","case_no":"2011/00011","requestno":"10366-18188#2011/00011","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0047","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"14062000000248","case_no":"2010/00006","requestno":"10366-18188#2010/00006","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0048","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"14323000000132","case_no":"2010/00007","requestno":"10366-18188#2010/00007","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0049","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"19661000000105","case_no":"2010/00005","requestno":"10366-18188#2010/00005","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0050","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"16472000000245","case_no":"2007/00005","requestno":"10366-18188#2007/00005","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0051","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11275000000414","case_no":"2005/00004","requestno":"10366-18188#2005/00004","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0052","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"11053000000332","case_no":"2002/00004","requestno":"10366-18188#2002/00004","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0053","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"10463000000406","case_no":"2002/00002","requestno":"10366-18188#2002/00002","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0054","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"10575000000331","case_no":"2002/00003","requestno":"10366-18188#2002/00003","decision_date":"08/11/2023","status":"0","transContFld":"T"}},{"rowno":"0055","text":"0","columns":{"fromcourt":"12836000000119","fromccode":"10366","transcourt":"1532660008306","transccode":"18188","trn_rcms_caseregid":"10039000000203","case_no":"2002/00001","requestno":"10366-18188#2002/00001","decision_date":"08/11/2023","status":"0","transContFld":"T"}}]}]}}
Verifying username and password
User Name : ADM_dosa_r
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=adm_dosa_r
Time elapsed = 27
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 6
Result :
Verifying completed...
Page Access Category :
User Name : adm_dosa_r
Select sysdate as sdt from dual
Time elapsed = 5
dt=09/02/2024 22:48:50
Select sysdate as sdt from dual
Time elapsed = 5
Select usergroup from AXUSERLEVELGROUPS WHERE (lower(username) =:U) and ((startdate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') >= startdate) or (startdate is null)) and ((enddate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') <= enddate) or (enddate is null))
U=adm_dosa_r
dt=09/02/2024 22:48:50
dt=09/02/2024 22:48:50
Time elapsed = 11
User Groups: court_reader
select userroles from axusergroups where groupname in ( 'court_reader' )
Time elapsed = 4
User Roles : court_reader
Loading App/User vars
reading the props xml
Step3
Sql : select props from axprops where lower(name)= :name order by blobno
Paramval : app
ParamTYpe : c
Param List : name
select props from axprops where lower(name)= :name order by blobno
Time elapsed = 3
Step4
axprops\stm size:4235
Step4-123456
images\Generalized Court Management System
INRF500250000Ffiresql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtname := sqlget({m2},{court_name})firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})m_courttype := sqlget({m3},{court_type})firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})m_courtid := sqlget({m4},{court_name_mastid})firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})login_userid := sqlget({m4},{axusersid})firesql({m4},{select :username as uname from dual})u_name := sqlget({m4},{uname})firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})m_courtcode := sqlget({m4},{COURT_CODE})firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})m_statename := sqlget({m2},{STATE_NAME})firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_distName := sqlget({m7},{DISTNAMEENG})firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})m_courtcatid := sqlget({m8},{COURT_CATEGOTY})firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})m_deptid := sqlget({m4},{department_mastid})firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})m_courttypeid := sqlget({m3},{court_type_mastid})firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })urole := sqlget({m4},{groupname})firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})m_cutoffdt := sqlget({a1},{dd})firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})m_offcount := sqlget({P1},{ct})00000F
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
username=ADM_dosa_r
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=ADM_dosa_r
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m2},{court_name})
Calling function sqlget
Result of sqlget = ???????? ???? ???????,????
Result = ???????? ???? ???????,????
Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
Calling function firesql
username=ADM_dosa_r
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=ADM_dosa_r
Time elapsed = 17
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type})
Calling function sqlget
Result of sqlget = ADM
Result = ADM
Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
Calling function firesql
username=ADM_dosa_r
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=ADM_dosa_r
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m4},{court_name_mastid})
Calling function sqlget
Result of sqlget = 12836000000119
Result = 12836000000119
Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=ADM_dosa_r
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{axusersid})
Calling function sqlget
Result of sqlget = 3683
Result = 3683
Evaluating firesql({m4},{select :username as uname from dual})
Calling function firesql
select :username as uname from dual
username=ADM_dosa_r
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{uname})
Calling function sqlget
Result of sqlget = ADM_dosa_r
Result = ADM_dosa_r
Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=ADM_dosa_r
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m4},{COURT_CODE})
Calling function sqlget
Result of sqlget = 10366
Result = 10366
Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 5
Result of firesql =
Result =
Evaluating sqlget({m2},{STATE_NAME})
Calling function sqlget
Result of sqlget = ????????
Result = ????????
Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=ADM_dosa_r
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ADM_dosa_r
Time elapsed = 6
Result of firesql =
Result =
Evaluating sqlget({m7},{DISTNAMEENG})
Calling function sqlget
Result of sqlget = Dausa
Result = Dausa
Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
Calling function firesql
username=ADM_dosa_r
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ADM_dosa_r
Time elapsed = 5
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=3683
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=3683
Time elapsed = 11
Result of firesql =
Result =
Evaluating sqlget({m4},{department_mastid})
Calling function sqlget
Result of sqlget = 1579880000000
Result = 1579880000000
Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=ADM_dosa_r
Time elapsed = 7
Result of firesql =
Result =
Evaluating sqlget({m3},{court_type_mastid})
Calling function sqlget
Result of sqlget = 10824000000000
Result = 10824000000000
Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
Calling function firesql
username=ADM_dosa_r
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=ADM_dosa_r
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=ADM_dosa_r
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=ADM_dosa_r
Time elapsed = 8
Result of firesql =
Result =
Evaluating sqlget({P1},{ct})
Calling function sqlget
Result of sqlget = 7
Result = 7
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)='rctcr' and stype = 't' )
Time elapsed = 3
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='rctcr' 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,rctcr,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 : rctcr
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 5
Step4
tstructs\stm size:2355
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Evaluating date()
Result =
Evaluating 0
Result =
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=rctcr
adxinout=o
Time elapsed = 17
select * from trn_rcms_transreq where trn_rcms_transreqid=0
Time elapsed = 4
select * from Axusers where 1=2
Time elapsed = 5
select distinct(fldname) from AxTempUserFields
Time elapsed = 5
select * from AxAttachWorkflow where lower(transid) = 'rctcr'
Time elapsed = 6
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : tscd
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 3
Step4
tstructs\stm size:6669
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
select lpad(' ', 250, ' ') LVAL from dual
Time elapsed = 4
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tscd
adxinout=o
Time elapsed = 7
select * from trn_rcms_decision where trn_rcms_decisionid=0
Time elapsed = 5
Evaluating date()
Result =
Evaluating m_courtname
Result =
Evaluating {AND a1.court_code=:m_courtcode }
Result =
Evaluating iif(hearing_date>currdate,{Hearing Date Can not be greater Than Today },{T})
Result =
Evaluating iif(decision_date>currdate,{Decision Date Can not be greater Than Today },{T})
Result =
Evaluating 0
Result =
Evaluating {F}
Result =
Evaluating {F}
Result =
Evaluating {F}
Result =
Evaluating court_code+case_no
Result =
Evaluating username
Result =
Evaluating {cd.pdf}
Result =
Evaluating iif(recordid>0,{Decision Updated},{Decision Submitted})
Result =
Evaluating iif(recordid>0,{F},{T})
Result =
Loading genmaps
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : tsrcf
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 4
Step4
tstructs\stm size:4166
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tsrcf
adxinout=o
Time elapsed = 9
select * from trn_rcms_hearing where trn_rcms_hearingid=0
Time elapsed = 6
Evaluating date()
Result =
Evaluating { AND a1.court_code = :m_courtcode }
Result =
Evaluating m_courtname
Result =
Evaluating case_purpose_name
Result =
Evaluating {NO}
Result =
Evaluating {Feedback Submitted}
Result =
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : tchdh
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 3
Step4
tstructs\stm size:1907
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tchdh
adxinout=o
Time elapsed = 6
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 5
Step3
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : tchdh
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 3
Step4
tstructs\stm size:1907
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tchdh
adxinout=o
Time elapsed = 7
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 14
select distinct(schemaname) from axschema where lower(transid)='tscrg'
Time elapsed = 16
select trn_rcms_caseregid from trn_rcms_casereg where trn_rcms_caseregid=0
Time elapsed = 5
select case_decision_date from trn_rcms_casereg where trn_rcms_caseregid=0
Time elapsed = 4
select distinct(schemaname) from axschema where lower(transid)='tscrg'
Time elapsed = 4
select decision_type from trn_rcms_casereg where trn_rcms_caseregid=0
Time elapsed = 5
Creating Action object
Submitting data to dbcall
Submiting & Registering data
Registering Global variables data
Registering Global variables data over
Setting values over
DB Call Validate and save
>>Validating rctcr
>>Frame No 1
currdate =
Evaluating - date()
Result of date = 09/02/2024
currdate after validation = 09/02/2024
court_code = 10366
trans_ccode = 18188
case_purpose =
SELECT b.CASE_PURPOSE_MASTID, b.CASE_PURPOSE_NAME, b.case_purpose_code
FROM case_purpose_mast b WHERE CASE_PURPOSE_MASTID = 1025550004746
Time elapsed = 4
case_purpose after validation = ????????? Id = 1025550004746
dec_type =
SELECT DECISION_MASTID, DECISION_NAME
FROM decision_mast A
WHERE court_code = '10006' AND a.DECISION_MASTID = 11782000000706
ORDER BY DECISION_NAME
Time elapsed = 5
dec_type after validation = ????????? Id = 11782000000706
time zone difference = 0
>>Writing to tables rctcr
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rctcr'
Time elapsed = 3
Saving to table TRN_RCMS_TRANSREQ
select * from TRN_RCMS_TRANSREQ where TRN_RCMS_TRANSREQid=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 = 12017000009134
MapName
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_ccode = 18188
court_code = 10366
Posting record
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ADM_dosa_r
Param Type = c
createdon=09/02/2024 22:48:51
Param Type = c
username=ADM_dosa_r
Param Type = c
modifiedon=09/02/2024 22:48:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_ccode=18188
Param Type = c
court_code=10366
insert into TRN_RCMS_TRANSREQ (trn_rcms_transreqid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_ccode,court_code) values (:trn_rcms_transreqid,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,:trans_ccode,:court_code)
Saving to table TRN_RCMS_TRANSREQDTL
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
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 = 12017000009135
Select sysdate as sdt from dual
Time elapsed = 16
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2023/67
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2023/67
trn_rcms_caseregid = 15812000007626
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 1
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009135
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2023/67
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2023/67
Param Type = n
trn_rcms_caseregid=15812000007626
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=1
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
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 = 12017000009136
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2023/12
fromcourt = 12836000000119
fromccode = 10366
transcourt = 1532660008306
case_no = 2023/12
trn_rcms_caseregid = 16637000008507
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 2
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009136
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2023/12
Param Type = n
fromcourt=12836000000119
Param Type = c
fromccode=10366
Param Type = n
transcourt=1532660008306
Param Type = c
case_no=2023/12
Param Type = n
trn_rcms_caseregid=16637000008507
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=2
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009137
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2023/11
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2023/11
trn_rcms_caseregid = 16536000006940
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 3
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009137
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2023/11
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2023/11
Param Type = n
trn_rcms_caseregid=16536000006940
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=3
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009138
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2022/319
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2022/319
trn_rcms_caseregid = 10850000007116
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 4
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009138
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2022/319
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2022/319
Param Type = n
trn_rcms_caseregid=10850000007116
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=4
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
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 = 2
RecordId = 12017000009139
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2022/314
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2022/314
trn_rcms_caseregid = 16636000007766
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 5
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009139
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2022/314
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2022/314
Param Type = n
trn_rcms_caseregid=16636000007766
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=5
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009140
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2022/313
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2022/313
trn_rcms_caseregid = 16589000007191
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 6
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009140
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2022/313
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2022/313
Param Type = n
trn_rcms_caseregid=16589000007191
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=6
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
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 = 12017000009141
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2022/132
fromcourt = 12836000000119
fromccode = 10366
transcourt = 1532660008306
case_no = 2022/132
trn_rcms_caseregid = 18373000006849
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 7
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009141
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2022/132
Param Type = n
fromcourt=12836000000119
Param Type = c
fromccode=10366
Param Type = n
transcourt=1532660008306
Param Type = c
case_no=2022/132
Param Type = n
trn_rcms_caseregid=18373000006849
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=7
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
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 = 3
RecordId = 12017000009142
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2022/131
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2022/131
trn_rcms_caseregid = 18021000006390
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 8
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009142
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2022/131
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2022/131
Param Type = n
trn_rcms_caseregid=18021000006390
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=8
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
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 = 12017000009143
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2019/00305
fromcourt = 12836000000119
fromccode = 10366
transcourt = 1532660008306
case_no = 2019/00305
trn_rcms_caseregid = 19079000003537
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 9
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009143
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2019/00305
Param Type = n
fromcourt=12836000000119
Param Type = c
fromccode=10366
Param Type = n
transcourt=1532660008306
Param Type = c
case_no=2019/00305
Param Type = n
trn_rcms_caseregid=19079000003537
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=9
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009144
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2021/130
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2021/130
trn_rcms_caseregid = 14950000005936
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 10
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009144
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2021/130
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2021/130
Param Type = n
trn_rcms_caseregid=14950000005936
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=10
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=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 = 12017000009145
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2021/127
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2021/127
trn_rcms_caseregid = 16842000005891
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 11
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009145
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2021/127
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2021/127
Param Type = n
trn_rcms_caseregid=16842000005891
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=11
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009146
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2021/126
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2021/126
trn_rcms_caseregid = 16823000005958
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 12
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009146
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2021/126
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2021/126
Param Type = n
trn_rcms_caseregid=16823000005958
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=12
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12017000009147
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2021/125
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2021/125
trn_rcms_caseregid = 16788000005158
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 13
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009147
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2021/125
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2021/125
Param Type = n
trn_rcms_caseregid=16788000005158
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=13
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12017000009148
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2021/124
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2021/124
trn_rcms_caseregid = 16764000005435
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 14
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009148
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2021/124
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2021/124
Param Type = n
trn_rcms_caseregid=16764000005435
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=14
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009149
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2021/128
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2021/128
trn_rcms_caseregid = 17105000006790
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 15
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009149
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2021/128
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2021/128
Param Type = n
trn_rcms_caseregid=17105000006790
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=15
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12017000009150
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2021/146
fromcourt = 12836000000119
fromccode = 10366
transcourt = 1532660008306
case_no = 2021/146
trn_rcms_caseregid = 13505000006366
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 16
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009150
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2021/146
Param Type = n
fromcourt=12836000000119
Param Type = c
fromccode=10366
Param Type = n
transcourt=1532660008306
Param Type = c
case_no=2021/146
Param Type = n
trn_rcms_caseregid=13505000006366
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=16
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=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 = 3
RecordId = 12017000009151
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2021/3
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2021/3
trn_rcms_caseregid = 15798000004761
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 17
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009151
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2021/3
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2021/3
Param Type = n
trn_rcms_caseregid=15798000004761
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=17
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=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 = 5
RecordId = 12017000009152
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2020/00146
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2020/00146
trn_rcms_caseregid = 18508000005324
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 18
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009152
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2020/00146
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2020/00146
Param Type = n
trn_rcms_caseregid=18508000005324
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=18
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12017000009153
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2020/00036
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2020/00036
trn_rcms_caseregid = 16479000004028
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 19
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009153
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2020/00036
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2020/00036
Param Type = n
trn_rcms_caseregid=16479000004028
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=19
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12017000009154
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2019/00171
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2019/00171
trn_rcms_caseregid = 12773000002370
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 20
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009154
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2019/00171
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2019/00171
Param Type = n
trn_rcms_caseregid=12773000002370
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=20
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 7
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 = 5
RecordId = 12017000009155
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2019/00140
fromcourt = 12836000000119
fromccode = 10366
transcourt = 1532660008306
case_no = 2019/00140
trn_rcms_caseregid = 19337000002796
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 21
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009155
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2019/00140
Param Type = n
fromcourt=12836000000119
Param Type = c
fromccode=10366
Param Type = n
transcourt=1532660008306
Param Type = c
case_no=2019/00140
Param Type = n
trn_rcms_caseregid=19337000002796
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=21
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=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 = 12017000009156
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2019/00139
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2019/00139
trn_rcms_caseregid = 19231000002425
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 22
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009156
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2019/00139
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2019/00139
Param Type = n
trn_rcms_caseregid=19231000002425
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=22
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12017000009157
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2019/00138
fromcourt = 12836000000119
fromccode = 10366
transcourt = 1532660008306
case_no = 2019/00138
trn_rcms_caseregid = 18994000002416
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 23
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009157
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2019/00138
Param Type = n
fromcourt=12836000000119
Param Type = c
fromccode=10366
Param Type = n
transcourt=1532660008306
Param Type = c
case_no=2019/00138
Param Type = n
trn_rcms_caseregid=18994000002416
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=23
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 7
Adding new record to store data from Frame 2, Row 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009158
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2018/00295
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2018/00295
trn_rcms_caseregid = 11731000002492
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 24
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009158
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2018/00295
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2018/00295
Param Type = n
trn_rcms_caseregid=11731000002492
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=24
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 6
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009159
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2018/00294
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2018/00294
trn_rcms_caseregid = 11581000002645
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 25
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009159
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2018/00294
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2018/00294
Param Type = n
trn_rcms_caseregid=11581000002645
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=25
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009160
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2018/00200
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2018/00200
trn_rcms_caseregid = 11149000001643
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 26
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009160
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2018/00200
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2018/00200
Param Type = n
trn_rcms_caseregid=11149000001643
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=26
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12017000009161
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2018/00165
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2018/00165
trn_rcms_caseregid = 11343000002270
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 27
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009161
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2018/00165
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2018/00165
Param Type = n
trn_rcms_caseregid=11343000002270
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=27
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 28 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 6
RecordId = 12017000009162
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2018/00164
fromcourt = 12836000000119
fromccode = 10366
transcourt = 1532660008306
case_no = 2018/00164
trn_rcms_caseregid = 11297000001835
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 28
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009162
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2018/00164
Param Type = n
fromcourt=12836000000119
Param Type = c
fromccode=10366
Param Type = n
transcourt=1532660008306
Param Type = c
case_no=2018/00164
Param Type = n
trn_rcms_caseregid=11297000001835
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=28
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12017000009163
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2018/00163
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2018/00163
trn_rcms_caseregid = 11262000002021
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 29
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009163
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2018/00163
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2018/00163
Param Type = n
trn_rcms_caseregid=11262000002021
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=29
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 30 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12017000009164
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2018/00162
fromcourt = 12836000000119
fromccode = 10366
transcourt = 1532660008306
case_no = 2018/00162
trn_rcms_caseregid = 11217000002107
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 30
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009164
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2018/00162
Param Type = n
fromcourt=12836000000119
Param Type = c
fromccode=10366
Param Type = n
transcourt=1532660008306
Param Type = c
case_no=2018/00162
Param Type = n
trn_rcms_caseregid=11217000002107
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=30
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 31 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009165
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2017/00725
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2017/00725
trn_rcms_caseregid = 11412000001531
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 31
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009165
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2017/00725
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2017/00725
Param Type = n
trn_rcms_caseregid=11412000001531
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=31
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 32 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12017000009166
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2017/00721
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2017/00721
trn_rcms_caseregid = 10780000001313
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 32
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009166
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2017/00721
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2017/00721
Param Type = n
trn_rcms_caseregid=10780000001313
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=32
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 33 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12017000009167
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2017/00547
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2017/00547
trn_rcms_caseregid = 15481000001258
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 33
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009167
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2017/00547
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2017/00547
Param Type = n
trn_rcms_caseregid=15481000001258
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=33
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 34 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009168
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2017/00543
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2017/00543
trn_rcms_caseregid = 19839000000859
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 34
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009168
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2017/00543
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2017/00543
Param Type = n
trn_rcms_caseregid=19839000000859
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=34
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 35 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12017000009169
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2016/00222
fromcourt = 12836000000119
fromccode = 10366
transcourt = 1532660008306
case_no = 2016/00222
trn_rcms_caseregid = 10817000000268
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 35
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009169
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2016/00222
Param Type = n
fromcourt=12836000000119
Param Type = c
fromccode=10366
Param Type = n
transcourt=1532660008306
Param Type = c
case_no=2016/00222
Param Type = n
trn_rcms_caseregid=10817000000268
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=35
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 36 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12017000009170
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2016/00220
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2016/00220
trn_rcms_caseregid = 10767000000251
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 36
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009170
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2016/00220
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2016/00220
Param Type = n
trn_rcms_caseregid=10767000000251
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=36
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 37 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009171
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2016/00068
fromcourt = 12836000000119
fromccode = 10366
transcourt = 1532660008306
case_no = 2016/00068
trn_rcms_caseregid = 17965000000185
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 37
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009171
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2016/00068
Param Type = n
fromcourt=12836000000119
Param Type = c
fromccode=10366
Param Type = n
transcourt=1532660008306
Param Type = c
case_no=2016/00068
Param Type = n
trn_rcms_caseregid=17965000000185
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=37
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 38 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12017000009172
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2016/00067
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2016/00067
trn_rcms_caseregid = 17877000000193
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 38
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009172
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2016/00067
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2016/00067
Param Type = n
trn_rcms_caseregid=17877000000193
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=38
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 39 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009173
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2016/00365
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2016/00365
trn_rcms_caseregid = 18766000001008
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 39
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009173
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2016/00365
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2016/00365
Param Type = n
trn_rcms_caseregid=18766000001008
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=39
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 40 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009174
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2015/00244
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2015/00244
trn_rcms_caseregid = 17345000000146
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 40
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009174
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2015/00244
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2015/00244
Param Type = n
trn_rcms_caseregid=17345000000146
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=40
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 41 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009175
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2015/00447
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2015/00447
trn_rcms_caseregid = 18197000000351
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 41
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009175
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2015/00447
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2015/00447
Param Type = n
trn_rcms_caseregid=18197000000351
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=41
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 42 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12017000009176
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2014/00088
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2014/00088
trn_rcms_caseregid = 13029000000267
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 42
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009176
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2014/00088
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2014/00088
Param Type = n
trn_rcms_caseregid=13029000000267
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=42
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 43 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12017000009177
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2014/00066
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2014/00066
trn_rcms_caseregid = 17843000000195
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 43
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009177
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2014/00066
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2014/00066
Param Type = n
trn_rcms_caseregid=17843000000195
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=43
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 44 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 2
RecordId = 12017000009178
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2013/00059
fromcourt = 12836000000119
fromccode = 10366
transcourt = 1532660008306
case_no = 2013/00059
trn_rcms_caseregid = 17267000000332
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 44
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009178
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2013/00059
Param Type = n
fromcourt=12836000000119
Param Type = c
fromccode=10366
Param Type = n
transcourt=1532660008306
Param Type = c
case_no=2013/00059
Param Type = n
trn_rcms_caseregid=17267000000332
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=44
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 45 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12017000009179
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2013/00044
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2013/00044
trn_rcms_caseregid = 13235000000300
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 45
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009179
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2013/00044
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2013/00044
Param Type = n
trn_rcms_caseregid=13235000000300
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=45
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 46 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12017000009180
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2011/00011
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2011/00011
trn_rcms_caseregid = 19480000000607
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 46
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009180
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2011/00011
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2011/00011
Param Type = n
trn_rcms_caseregid=19480000000607
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=46
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 47 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12017000009181
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2010/00006
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2010/00006
trn_rcms_caseregid = 14062000000248
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 47
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009181
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2010/00006
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2010/00006
Param Type = n
trn_rcms_caseregid=14062000000248
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=47
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 48 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12017000009182
Select sysdate as sdt from dual
Time elapsed = 7
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2010/00007
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2010/00007
trn_rcms_caseregid = 14323000000132
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 48
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009182
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2010/00007
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2010/00007
Param Type = n
trn_rcms_caseregid=14323000000132
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=48
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 49 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 5
RecordId = 12017000009183
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2010/00005
fromcourt = 12836000000119
fromccode = 10366
transcourt = 1532660008306
case_no = 2010/00005
trn_rcms_caseregid = 19661000000105
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 49
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009183
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2010/00005
Param Type = n
fromcourt=12836000000119
Param Type = c
fromccode=10366
Param Type = n
transcourt=1532660008306
Param Type = c
case_no=2010/00005
Param Type = n
trn_rcms_caseregid=19661000000105
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=49
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 50 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12017000009184
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2007/00005
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2007/00005
trn_rcms_caseregid = 16472000000245
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 50
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009184
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2007/00005
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2007/00005
Param Type = n
trn_rcms_caseregid=16472000000245
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=50
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 5
Adding new record to store data from Frame 2, Row 51 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009185
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2005/00004
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2005/00004
trn_rcms_caseregid = 11275000000414
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 51
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009185
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2005/00004
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2005/00004
Param Type = n
trn_rcms_caseregid=11275000000414
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=51
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 52 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009186
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2002/00004
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2002/00004
trn_rcms_caseregid = 11053000000332
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 52
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009186
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2002/00004
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2002/00004
Param Type = n
trn_rcms_caseregid=11053000000332
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=52
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 3
Adding new record to store data from Frame 2, Row 53 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009187
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2002/00002
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2002/00002
trn_rcms_caseregid = 10463000000406
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 53
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009187
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2002/00002
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2002/00002
Param Type = n
trn_rcms_caseregid=10463000000406
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=53
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 13
Adding new record to store data from Frame 2, Row 54 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 4
RecordId = 12017000009188
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2002/00003
fromcourt = 12836000000119
fromccode = 10366
transcourt = 1532660008306
case_no = 2002/00003
trn_rcms_caseregid = 10575000000331
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 54
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009188
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2002/00003
Param Type = n
fromcourt=12836000000119
Param Type = c
fromccode=10366
Param Type = n
transcourt=1532660008306
Param Type = c
case_no=2002/00003
Param Type = n
trn_rcms_caseregid=10575000000331
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=54
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
select * from TRN_RCMS_TRANSREQDTL where TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
Adding new record to store data from Frame 2, Row 55 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn
Time elapsed = 3
RecordId = 12017000009189
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 08/11/2023
status = 0
transContFld = T
requestno = 10366-18188#2002/00001
transcourt = 1532660008306
fromccode = 10366
fromcourt = 12836000000119
case_no = 2002/00001
trn_rcms_caseregid = 10039000000203
transccode = 18188
TRN_RCMS_TRANSREQDTLrow = 55
Posting record
Param Type = n
trn_rcms_transreqdtlid=12017000009189
Param Type = n
trn_rcms_transreqid=12017000009134
Param Type = c
decision_date=08/11/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10366-18188#2002/00001
Param Type = n
transcourt=1532660008306
Param Type = c
fromccode=10366
Param Type = n
fromcourt=12836000000119
Param Type = c
case_no=2002/00001
Param Type = n
trn_rcms_caseregid=10039000000203
Param Type = c
transccode=18188
Param Type = n
trn_rcms_transreqdtlrow=55
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)
Time elapsed for insert/update = 3916680511938
>>Executing genmaps
>>Posting from rctcr to tscd from row 1
>>Mapping
Mapped court_code Row = 1 value = 10366 idvalue 0
Mapped case_no Row = 1 value = 2023/67 idvalue 0
Mapped new_case_purpose Row = 1 value = ????????? idvalue 1025550004746
Mapped decision_type Row = 1 value = ????????? idvalue 11782000000706
Mapped decision_date Row = 1 value = 08/11/2023 idvalue 0
Mapped hearing_date Row = 1 value = 08/11/2023 idvalue 0
Mapped pagesource Row = 1 value = TRANSPAGE idvalue 0
>>Validating tscd
>>Frame No 1
currdate =
Evaluating - date()
Result of date = 09/02/2024
currdate after validation = 09/02/2024
court_name =
username=ADM_dosa_r
select court_name_mastid,court_name,court_code from v_axcourts where paxusername=:username
username=ADM_dosa_r
Time elapsed = 6
Evaluating - m_courtname
m_courtname = ???????? ???? ???????,????
court_name after validation = ???????? ???? ???????,???? Id = 12836000000119
court_code = 10366
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
viewfilter =
Evaluating - {AND a1.court_code=:m_courtcode }
viewfilter after validation = AND a1.court_code=:m_courtcode
case_no = 2023/67
casedetails =
court_code=10366
case_no=2023/67
recordid=0
SELECT A1.COURT_CODE,
A1.TRN_RCMS_CASEREGID,
A1.INSTITUTION_DATE,
A1.CASE_NO,
A1.MCASE_NO,
A1.LAST_HEARING_DATE AS hearing_date,
B2.DISTRICT_NAME,
B3.CASE_TYPE,
B1.CASE_PURPOSE_NAME,
A1.CASE_PURPOSE_NAME AS CPID,
B4.ACT_NAME,
A1.SECTION_NAME,
A1.PRIMARY_APPELLANT AS APPELLANT_NAME,
A1.PRIMARY_RESPONDENT AS RESPONDENT_NAME
FROM trn_rcms_casereg a1,
case_purpose_mast b1,
district_mast b2,
case_type_mast b3,
rule_act_mast b4
WHERE A1.CASE_PURPOSE_NAME = B1.CASE_PURPOSE_MASTID
AND A1.DISTRICT_NAME = B2.DISTRICT_MASTID
AND A1.ACT_NAME = B4.RULE_ACT_MASTID
AND A1.CASE_TYPE = B3.CASE_TYPE_MASTID
AND A1.COURT_CODE = :court_code
AND a1.CASE_NO = :case_no
AND (CASE
WHEN :recordid > 0
THEN
1
WHEN :recordid = 0
AND b1.CASE_PURPOSE_MASTID <> 1364660005542
AND b1.CASE_PURPOSE_GROUP <> 18438000000000
AND NOT EXISTS
(SELECT 1
FROM TRN_RCMS_DECISION
WHERE TRN_RCMS_CASEID = a1.TRN_RCMS_CASEREGID)
THEN
1
ELSE
0
END) = 1
court_code=10366
case_no=2023/67
recordid=0
recordid=0
Time elapsed = 17
trn_rcms_caseid =
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
S=0
Select trn_rcms_caseid from trn_rcms_decision where trn_rcms_caseid = :S
S=0
Time elapsed = 442
Duplicate values are not allowed in Case No.
Error :
Select sysdate as sdt from dual
Time elapsed = 5
insert into axerrorlog values('ADM_dosa_r',to_date('09/02/2024 22:48:56','dd/mm/yyyy hh24:mi:ss'),'rctcr','SaveData','')
Time elapsed = 14
Constraint Name =
Savedata webservice completed
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=ADM_dosa_r
Param Type = c
calledon=09/02/2024 22:48:26
Param Type = c
callfinished=09/02/2024 22:48:32
Param Type = c
structname=rctcr
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=Duplicate values are not allowed in Case No.
Param Type = n
timetaken=5730
Param Type = n
dbtimetaken=3431
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