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
<transaction username="ACEM_khandela" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>ACEM_khandela</username><password>827ccb0eea8a706c4c34a16891f84e7b</password><seed></seed><s></s><transid>rctcr</transid><recordid>0</recordid><recdata></recdata><data transid="rctcr" recordid="0"><axp_recid1 rowno="001">0</axp_recid1><court_code rowno="001">10715</court_code><trans_ccode rowno="001">18162</trans_ccode><axp_recid2 rowno="001">0</axp_recid2><fromcourt rowno="001">18156000000033</fromcourt><fromccode rowno="001">10715</fromccode><transcourt rowno="001">1044010007947</transcourt><transccode rowno="001">18162</transccode><trn_rcms_caseregid rowno="001">12948000007247</trn_rcms_caseregid><case_no rowno="001">2021/611</case_no><requestno rowno="001">10715-18162#2021/611</requestno><decision_date rowno="001">04/07/2023</decision_date><status rowno="001">0</status><transContFld rowno="001">T</transContFld><axp_recid2 rowno="002">0</axp_recid2><fromcourt rowno="002">18156000000033</fromcourt><fromccode rowno="002">10715</fromccode><transcourt rowno="002">1044010007947</transcourt><transccode rowno="002">18162</transccode><trn_rcms_caseregid rowno="002">13804000003507</trn_rcms_caseregid><case_no rowno="002">2018/00272</case_no><requestno rowno="002">10715-18162#2018/00272</requestno><decision_date rowno="002">04/07/2023</decision_date><status rowno="002">0</status><transContFld rowno="002">T</transContFld><axp_recid2 rowno="003">0</axp_recid2><fromcourt rowno="003">18156000000033</fromcourt><fromccode rowno="003">10715</fromccode><transcourt rowno="003">1044010007947</transcourt><transccode rowno="003">18162</transccode><trn_rcms_caseregid rowno="003">14563000006467</trn_rcms_caseregid><case_no rowno="003">2022/41</case_no><requestno rowno="003">10715-18162#2022/41</requestno><decision_date rowno="003">04/07/2023</decision_date><status rowno="003">0</status><transContFld rowno="003">T</transContFld><axp_recid2 rowno="004">0</axp_recid2><fromcourt rowno="004">18156000000033</fromcourt><fromccode rowno="004">10715</fromccode><transcourt rowno="004">1044010007947</transcourt><transccode rowno="004">18162</transccode><trn_rcms_caseregid rowno="004">14605000007924</trn_rcms_caseregid><case_no rowno="004">2022/42</case_no><requestno rowno="004">10715-18162#2022/42</requestno><decision_date rowno="004">04/07/2023</decision_date><status rowno="004">0</status><transContFld rowno="004">T</transContFld><axp_recid2 rowno="005">0</axp_recid2><fromcourt rowno="005">18156000000033</fromcourt><fromccode rowno="005">10715</fromccode><transcourt rowno="005">1044010007947</transcourt><transccode rowno="005">18162</transccode><trn_rcms_caseregid rowno="005">12965000002043</trn_rcms_caseregid><case_no rowno="005">2018/00125</case_no><requestno rowno="005">10715-18162#2018/00125</requestno><decision_date rowno="005">04/07/2023</decision_date><status rowno="005">0</status><transContFld rowno="005">T</transContFld><axp_recid2 rowno="006">0</axp_recid2><fromcourt rowno="006">18156000000033</fromcourt><fromccode rowno="006">10715</fromccode><transcourt rowno="006">1044010007947</transcourt><transccode rowno="006">18162</transccode><trn_rcms_caseregid rowno="006">16963000002558</trn_rcms_caseregid><case_no rowno="006">2018/00219</case_no><requestno rowno="006">10715-18162#2018/00219</requestno><decision_date rowno="006">04/07/2023</decision_date><status rowno="006">0</status><transContFld rowno="006">T</transContFld><axp_recid2 rowno="007">0</axp_recid2><fromcourt rowno="007">18156000000033</fromcourt><fromccode rowno="007">10715</fromccode><transcourt rowno="007">1044010007947</transcourt><transccode rowno="007">18162</transccode><trn_rcms_caseregid rowno="007">12451000006698</trn_rcms_caseregid><case_no rowno="007">2021/239</case_no><requestno rowno="007">10715-18162#2021/239</requestno><decision_date rowno="007">04/07/2023</decision_date><status rowno="007">0</status><transContFld rowno="007">T</transContFld><axp_recid2 rowno="008">0</axp_recid2><fromcourt rowno="008">18156000000033</fromcourt><fromccode rowno="008">10715</fromccode><transcourt rowno="008">1044010007947</transcourt><transccode rowno="008">18162</transccode><trn_rcms_caseregid rowno="008">19969000001126</trn_rcms_caseregid><case_no rowno="008">2017/00070</case_no><requestno rowno="008">10715-18162#2017/00070</requestno><decision_date rowno="008">04/07/2023</decision_date><status rowno="008">0</status><transContFld rowno="008">T</transContFld><axp_recid2 rowno="009">0</axp_recid2><fromcourt rowno="009">18156000000033</fromcourt><fromccode rowno="009">10715</fromccode><transcourt rowno="009">1044010007947</transcourt><transccode rowno="009">18162</transccode><trn_rcms_caseregid rowno="009">19936000000802</trn_rcms_caseregid><case_no rowno="009">2017/00069</case_no><requestno rowno="009">10715-18162#2017/00069</requestno><decision_date rowno="009">04/07/2023</decision_date><status rowno="009">0</status><transContFld rowno="009">T</transContFld><axp_recid2 rowno="0010">0</axp_recid2><fromcourt rowno="0010">18156000000033</fromcourt><fromccode rowno="0010">10715</fromccode><transcourt rowno="0010">1044010007947</transcourt><transccode rowno="0010">18162</transccode><trn_rcms_caseregid rowno="0010">324870</trn_rcms_caseregid><case_no rowno="0010">2001/00016</case_no><requestno rowno="0010">10715-18162#2001/00016</requestno><decision_date rowno="0010">04/07/2023</decision_date><status rowno="0010">0</status><transContFld rowno="0010">T</transContFld><axp_recid2 rowno="0011">0</axp_recid2><fromcourt rowno="0011">18156000000033</fromcourt><fromccode rowno="0011">10715</fromccode><transcourt rowno="0011">1044010007947</transcourt><transccode rowno="0011">18162</transccode><trn_rcms_caseregid rowno="0011">11657000000507</trn_rcms_caseregid><case_no rowno="0011">2016/00225</case_no><requestno rowno="0011">10715-18162#2016/00225</requestno><decision_date rowno="0011">04/07/2023</decision_date><status rowno="0011">0</status><transContFld rowno="0011">T</transContFld><axp_recid2 rowno="0012">0</axp_recid2><fromcourt rowno="0012">18156000000033</fromcourt><fromccode rowno="0012">10715</fromccode><transcourt rowno="0012">1044010007947</transcourt><transccode rowno="0012">18162</transccode><trn_rcms_caseregid rowno="0012">10979000003105</trn_rcms_caseregid><case_no rowno="0012">2019/00206</case_no><requestno rowno="0012">10715-18162#2019/00206</requestno><decision_date rowno="0012">04/07/2023</decision_date><status rowno="0012">0</status><transContFld rowno="0012">T</transContFld><axp_recid2 rowno="0013">0</axp_recid2><fromcourt rowno="0013">18156000000033</fromcourt><fromccode rowno="0013">10715</fromccode><transcourt rowno="0013">1044010007947</transcourt><transccode rowno="0013">18162</transccode><trn_rcms_caseregid rowno="0013">16026000003563</trn_rcms_caseregid><case_no rowno="0013">2019/00282</case_no><requestno rowno="0013">10715-18162#2019/00282</requestno><decision_date rowno="0013">04/07/2023</decision_date><status rowno="0013">0</status><transContFld rowno="0013">T</transContFld><axp_recid2 rowno="0014">0</axp_recid2><fromcourt rowno="0014">18156000000033</fromcourt><fromccode rowno="0014">10715</fromccode><transcourt rowno="0014">1044010007947</transcourt><transccode rowno="0014">18162</transccode><trn_rcms_caseregid rowno="0014">12085000003613</trn_rcms_caseregid><case_no rowno="0014">2015/00367</case_no><requestno rowno="0014">10715-18162#2015/00367</requestno><decision_date rowno="0014">04/07/2023</decision_date><status rowno="0014">0</status><transContFld rowno="0014">T</transContFld><axp_recid2 rowno="0015">0</axp_recid2><fromcourt rowno="0015">18156000000033</fromcourt><fromccode rowno="0015">10715</fromccode><transcourt rowno="0015">1044010007947</transcourt><transccode rowno="0015">18162</transccode><trn_rcms_caseregid rowno="0015">16919000002199</trn_rcms_caseregid><case_no rowno="0015">2018/00218</case_no><requestno rowno="0015">10715-18162#2018/00218</requestno><decision_date rowno="0015">04/07/2023</decision_date><status rowno="0015">0</status><transContFld rowno="0015">T</transContFld><axp_recid2 rowno="0016">0</axp_recid2><fromcourt rowno="0016">18156000000033</fromcourt><fromccode rowno="0016">10715</fromccode><transcourt rowno="0016">1044010007947</transcourt><transccode rowno="0016">18162</transccode><trn_rcms_caseregid rowno="0016">324593</trn_rcms_caseregid><case_no rowno="0016">2000/00021</case_no><requestno rowno="0016">10715-18162#2000/00021</requestno><decision_date rowno="0016">04/07/2023</decision_date><status rowno="0016">0</status><transContFld rowno="0016">T</transContFld><axp_recid2 rowno="0017">0</axp_recid2><fromcourt rowno="0017">18156000000033</fromcourt><fromccode rowno="0017">10715</fromccode><transcourt rowno="0017">1044010007947</transcourt><transccode rowno="0017">18162</transccode><trn_rcms_caseregid rowno="0017">12316000000414</trn_rcms_caseregid><case_no rowno="0017">2016/00227</case_no><requestno rowno="0017">10715-18162#2016/00227</requestno><decision_date rowno="0017">04/07/2023</decision_date><status rowno="0017">0</status><transContFld rowno="0017">T</transContFld><axp_recid2 rowno="0018">0</axp_recid2><fromcourt rowno="0018">18156000000033</fromcourt><fromccode rowno="0018">10715</fromccode><transcourt rowno="0018">1044010007947</transcourt><transccode rowno="0018">18162</transccode><trn_rcms_caseregid rowno="0018">15864000005750</trn_rcms_caseregid><case_no rowno="0018">2021/80</case_no><requestno rowno="0018">10715-18162#2021/80</requestno><decision_date rowno="0018">04/07/2023</decision_date><status rowno="0018">0</status><transContFld rowno="0018">T</transContFld><axp_recid2 rowno="0019">0</axp_recid2><fromcourt rowno="0019">18156000000033</fromcourt><fromccode rowno="0019">10715</fromccode><transcourt rowno="0019">1044010007947</transcourt><transccode rowno="0019">18162</transccode><trn_rcms_caseregid rowno="0019">324253</trn_rcms_caseregid><case_no rowno="0019">2013/00126</case_no><requestno rowno="0019">10715-18162#2013/00126</requestno><decision_date rowno="0019">04/07/2023</decision_date><status rowno="0019">0</status><transContFld rowno="0019">T</transContFld><axp_recid2 rowno="0020">0</axp_recid2><fromcourt rowno="0020">18156000000033</fromcourt><fromccode rowno="0020">10715</fromccode><transcourt rowno="0020">1044010007947</transcourt><transccode rowno="0020">18162</transccode><trn_rcms_caseregid rowno="0020">324843</trn_rcms_caseregid><case_no rowno="0020">2012/00116</case_no><requestno rowno="0020">10715-18162#2012/00116</requestno><decision_date rowno="0020">04/07/2023</decision_date><status rowno="0020">0</status><transContFld rowno="0020">T</transContFld><axp_recid2 rowno="0021">0</axp_recid2><fromcourt rowno="0021">18156000000033</fromcourt><fromccode rowno="0021">10715</fromccode><transcourt rowno="0021">1044010007947</transcourt><transccode rowno="0021">18162</transccode><trn_rcms_caseregid rowno="0021">12982000002326</trn_rcms_caseregid><case_no rowno="0021">2019/00103</case_no><requestno rowno="0021">10715-18162#2019/00103</requestno><decision_date rowno="0021">04/07/2023</decision_date><status rowno="0021">0</status><transContFld rowno="0021">T</transContFld><axp_recid2 rowno="0022">0</axp_recid2><fromcourt rowno="0022">18156000000033</fromcourt><fromccode rowno="0022">10715</fromccode><transcourt rowno="0022">1044010007947</transcourt><transccode rowno="0022">18162</transccode><trn_rcms_caseregid rowno="0022">324649</trn_rcms_caseregid><case_no rowno="0022">1997/00011</case_no><requestno rowno="0022">10715-18162#1997/00011</requestno><decision_date rowno="0022">04/07/2023</decision_date><status rowno="0022">0</status><transContFld rowno="0022">T</transContFld><axp_recid2 rowno="0023">0</axp_recid2><fromcourt rowno="0023">18156000000033</fromcourt><fromccode rowno="0023">10715</fromccode><transcourt rowno="0023">1044010007947</transcourt><transccode rowno="0023">18162</transccode><trn_rcms_caseregid rowno="0023">12614000002976</trn_rcms_caseregid><case_no rowno="0023">2019/00139</case_no><requestno rowno="0023">10715-18162#2019/00139</requestno><decision_date rowno="0023">04/07/2023</decision_date><status rowno="0023">0</status><transContFld rowno="0023">T</transContFld><axp_recid2 rowno="0024">0</axp_recid2><fromcourt rowno="0024">18156000000033</fromcourt><fromccode rowno="0024">10715</fromccode><transcourt rowno="0024">1044010007947</transcourt><transccode rowno="0024">18162</transccode><trn_rcms_caseregid rowno="0024">12477000006775</trn_rcms_caseregid><case_no rowno="0024">2021/240</case_no><requestno rowno="0024">10715-18162#2021/240</requestno><decision_date rowno="0024">04/07/2023</decision_date><status rowno="0024">0</status><transContFld rowno="0024">T</transContFld><axp_recid2 rowno="0025">0</axp_recid2><fromcourt rowno="0025">18156000000033</fromcourt><fromccode rowno="0025">10715</fromccode><transcourt rowno="0025">1044010007947</transcourt><transccode rowno="0025">18162</transccode><trn_rcms_caseregid rowno="0025">11442000006798</trn_rcms_caseregid><case_no rowno="0025">2021/192</case_no><requestno rowno="0025">10715-18162#2021/192</requestno><decision_date rowno="0025">04/07/2023</decision_date><status rowno="0025">0</status><transContFld rowno="0025">T</transContFld><axp_recid2 rowno="0026">0</axp_recid2><fromcourt rowno="0026">18156000000033</fromcourt><fromccode rowno="0026">10715</fromccode><transcourt rowno="0026">1044010007947</transcourt><transccode rowno="0026">18162</transccode><trn_rcms_caseregid rowno="0026">324374</trn_rcms_caseregid><case_no rowno="0026">2013/00144</case_no><requestno rowno="0026">10715-18162#2013/00144</requestno><decision_date rowno="0026">04/07/2023</decision_date><status rowno="0026">0</status><transContFld rowno="0026">T</transContFld><axp_recid2 rowno="0027">0</axp_recid2><fromcourt rowno="0027">18156000000033</fromcourt><fromccode rowno="0027">10715</fromccode><transcourt rowno="0027">1044010007947</transcourt><transccode rowno="0027">18162</transccode><trn_rcms_caseregid rowno="0027">10460000001560</trn_rcms_caseregid><case_no rowno="0027">2017/00115</case_no><requestno rowno="0027">10715-18162#2017/00115</requestno><decision_date rowno="0027">04/07/2023</decision_date><status rowno="0027">0</status><transContFld rowno="0027">T</transContFld><axp_recid2 rowno="0028">0</axp_recid2><fromcourt rowno="0028">18156000000033</fromcourt><fromccode rowno="0028">10715</fromccode><transcourt rowno="0028">1044010007947</transcourt><transccode rowno="0028">18162</transccode><trn_rcms_caseregid rowno="0028">18621000001926</trn_rcms_caseregid><case_no rowno="0028">2019/00078</case_no><requestno rowno="0028">10715-18162#2019/00078</requestno><decision_date rowno="0028">04/07/2023</decision_date><status rowno="0028">0</status><transContFld rowno="0028">T</transContFld><axp_recid2 rowno="0029">0</axp_recid2><fromcourt rowno="0029">18156000000033</fromcourt><fromccode rowno="0029">10715</fromccode><transcourt rowno="0029">1044010007947</transcourt><transccode rowno="0029">18162</transccode><trn_rcms_caseregid rowno="0029">10964000000881</trn_rcms_caseregid><case_no rowno="0029">2013/00288</case_no><requestno rowno="0029">10715-18162#2013/00288</requestno><decision_date rowno="0029">04/07/2023</decision_date><status rowno="0029">0</status><transContFld rowno="0029">T</transContFld></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"ACEM_khandela","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"rctcr","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"court_code":"10715","trans_ccode":"18162"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"12948000007247","case_no":"2021/611","requestno":"10715-18162#2021/611","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"002","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"13804000003507","case_no":"2018/00272","requestno":"10715-18162#2018/00272","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"003","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"14563000006467","case_no":"2022/41","requestno":"10715-18162#2022/41","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"004","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"14605000007924","case_no":"2022/42","requestno":"10715-18162#2022/42","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"005","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"12965000002043","case_no":"2018/00125","requestno":"10715-18162#2018/00125","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"006","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"16963000002558","case_no":"2018/00219","requestno":"10715-18162#2018/00219","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"007","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"12451000006698","case_no":"2021/239","requestno":"10715-18162#2021/239","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"008","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"19969000001126","case_no":"2017/00070","requestno":"10715-18162#2017/00070","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"009","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"19936000000802","case_no":"2017/00069","requestno":"10715-18162#2017/00069","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0010","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"324870","case_no":"2001/00016","requestno":"10715-18162#2001/00016","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0011","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"11657000000507","case_no":"2016/00225","requestno":"10715-18162#2016/00225","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0012","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"10979000003105","case_no":"2019/00206","requestno":"10715-18162#2019/00206","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0013","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"16026000003563","case_no":"2019/00282","requestno":"10715-18162#2019/00282","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0014","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"12085000003613","case_no":"2015/00367","requestno":"10715-18162#2015/00367","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0015","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"16919000002199","case_no":"2018/00218","requestno":"10715-18162#2018/00218","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0016","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"324593","case_no":"2000/00021","requestno":"10715-18162#2000/00021","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0017","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"12316000000414","case_no":"2016/00227","requestno":"10715-18162#2016/00227","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0018","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"15864000005750","case_no":"2021/80","requestno":"10715-18162#2021/80","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0019","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"324253","case_no":"2013/00126","requestno":"10715-18162#2013/00126","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0020","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"324843","case_no":"2012/00116","requestno":"10715-18162#2012/00116","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0021","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"12982000002326","case_no":"2019/00103","requestno":"10715-18162#2019/00103","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0022","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"324649","case_no":"1997/00011","requestno":"10715-18162#1997/00011","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0023","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"12614000002976","case_no":"2019/00139","requestno":"10715-18162#2019/00139","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0024","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"12477000006775","case_no":"2021/240","requestno":"10715-18162#2021/240","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0025","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"11442000006798","case_no":"2021/192","requestno":"10715-18162#2021/192","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0026","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"324374","case_no":"2013/00144","requestno":"10715-18162#2013/00144","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0027","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"10460000001560","case_no":"2017/00115","requestno":"10715-18162#2017/00115","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0028","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"18621000001926","case_no":"2019/00078","requestno":"10715-18162#2019/00078","decision_date":"04/07/2023","status":"0","transContFld":"T"}},{"rowno":"0029","text":"0","columns":{"fromcourt":"18156000000033","fromccode":"10715","transcourt":"1044010007947","transccode":"18162","trn_rcms_caseregid":"10964000000881","case_no":"2013/00288","requestno":"10715-18162#2013/00288","decision_date":"04/07/2023","status":"0","transContFld":"T"}}]}]}}
Verifying username and password
User Name : ACEM_khandela
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=acem_khandela
Time elapsed = 19
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 7
Result : 
Verifying completed...
Page Access Category : 
User Name : acem_khandela
Select sysdate as sdt from dual
Time elapsed = 4
dt=08/04/2024 11:14:01
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=acem_khandela
dt=08/04/2024 11:14:01
dt=08/04/2024 11:14:01
Time elapsed = 12
User Groups: court_reader
select userroles from axusergroups where groupname in ( 'court_reader' )
Time elapsed = 9
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
<root updatedon="22/03/2024 11:49:22" name="app" caption="app" appverno="10.1.0.0" updusername="" updatedby="admin"><props LocalNum="727"><app color="$00EBF5F4" font="Tahoma,8"/><head font="Tahoma,12,tfff" color="$00DDE8E7"/><gridhead color="$00FFE8E8" font=""/><gridrow oddrowcolor="$00FEFCFA" evenrowcolor="$00FEF3ED"></gridrow><imgsfolder>images\</imgsfolder><container color="$00E8F1F0"/><name fontname="" fontsize="" fontbold="" fontitalic="" fontunderline="" fontcolor="" fontstrikeout="">Generalized Court Management System</name><img></img><envvar><currency>INR</currency><millions>F</millions><siteno></siteno><oraerrfrom>500</oraerrfrom><oraerrto>250000</oraerrto><postauto>F</postauto><finyrst></finyrst><finyred></finyred><cursep></cursep></envvar><currencies><INR></INR></currencies><appvars><m_courtname value="" param="f" hidden="false"><l>firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})</l><l>m_courtname := sqlget({m2},{court_name})</l></m_courtname><m_courttype value="" param="f" hidden="false"><l>firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})</l><l>m_courttype := sqlget({m3},{court_type})</l></m_courttype><m_courtid value="" param="f" hidden="false"><l>firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})</l><l>m_courtid := sqlget({m4},{court_name_mastid})</l></m_courtid><login_userid value="" param="f" hidden="false"><l>firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})</l><l>login_userid := sqlget({m4},{axusersid})</l></login_userid><u_name value="" param="f" hidden="false"><l>firesql({m4},{select :username as uname from dual})</l><l>u_name := sqlget({m4},{uname})</l></u_name><m_courtcode value="" param="f" hidden="false"><l>firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})</l><l>m_courtcode := sqlget({m4},{COURT_CODE})</l></m_courtcode><m_statename value="" param="f" hidden="false"><l>firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})</l><l>m_statename := sqlget({m2},{STATE_NAME})</l></m_statename><m_distname value="" param="f" hidden="false"><l>firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})</l><l>m_distName := sqlget({m7},{DISTNAMEENG})</l></m_distname><m_courtcatid value="" param="f" hidden="false"><l>firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})</l><l>m_courtcatid := sqlget({m8},{COURT_CATEGOTY})</l></m_courtcatid><m_deptid value="" param="f" hidden="false"><l>firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})</l><l>m_deptid := sqlget({m4},{department_mastid})</l></m_deptid><m_courttypeid value="" param="f" hidden="false"><l>firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})</l><l>m_courttypeid := sqlget({m3},{court_type_mastid})</l></m_courttypeid><urole value="" param="f" hidden="false"><l>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 })</l><l>urole := sqlget({m4},{groupname})</l></urole><m_cutoffdt value="" param="f" hidden="false"><l>firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})</l><l>m_cutoffdt := sqlget({a1},{dd})</l></m_cutoffdt><m_offcount value="" param="f" hidden="false"><l>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})</l><l>m_offcount := sqlget({P1},{ct})</l></m_offcount></appvars><readonlyprops readonly_fontcolor="clBlack" readonly_bgcolor="clWindow"/><gfont/><mail><host></host><port></port><userid></userid><password></password></mail><pwdsetting><maxlogintry>0</maxlogintry><pwdexpdays>0</pwdexpdays><pwdalertdays>0</pwdalertdays><pwdminchars>0</pwdminchars><pwdprevnos>0</pwdprevnos><ispwdalphanum>F</ispwdalphanum></pwdsetting></props></root>
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
   Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
   Calling function firesql
username=ACEM_khandela
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=ACEM_khandela
Time elapsed = 9
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{court_name})
   Calling function sqlget
   Result of sqlget = ????? ??????? (FT), ???????, ????
   Result = ????? ??????? (FT), ???????, ????
   Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
   Calling function firesql
username=ACEM_khandela
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=ACEM_khandela
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type})
   Calling function sqlget
   Result of sqlget = ACEM FT
   Result = ACEM FT
   Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
   Calling function firesql
username=ACEM_khandela
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=ACEM_khandela
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{court_name_mastid})
   Calling function sqlget
   Result of sqlget = 18156000000033
   Result = 18156000000033
   Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
   Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=ACEM_khandela
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{axusersid})
   Calling function sqlget
   Result of sqlget = 4344
   Result = 4344
   Evaluating firesql({m4},{select :username as uname from dual})
   Calling function firesql
select :username as uname from dual
username=ACEM_khandela
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{uname})
   Calling function sqlget
   Result of sqlget = ACEM_khandela
   Result = ACEM_khandela
   Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
   Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=ACEM_khandela
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{COURT_CODE})
   Calling function sqlget
   Result of sqlget = 10715
   Result = 10715
   Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
   Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{STATE_NAME})
   Calling function sqlget
   Result of sqlget = ????????
   Result = ????????
   Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=ACEM_khandela
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ACEM_khandela
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m7},{DISTNAMEENG})
   Calling function sqlget
   Result of sqlget = Sikar
   Result = Sikar
   Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=ACEM_khandela
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ACEM_khandela
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m8},{COURT_CATEGOTY})
   Calling function sqlget
   Result of sqlget = 10593000000007
   Result = 10593000000007
   Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
   Calling function firesql
login_userid=4344
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=4344
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{department_mastid})
   Calling function sqlget
   Result of sqlget = 1579880000000
   Result = 1579880000000
   Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
   Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=ACEM_khandela
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type_mastid})
   Calling function sqlget
   Result of sqlget = 12487000000154
   Result = 12487000000154
   Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
   Calling function firesql
username=ACEM_khandela
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=ACEM_khandela
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 = 3
   Result of firesql = 
   Result = 
   Evaluating  sqlget({a1},{dd})
   Calling function sqlget
   Result of sqlget = 30/01/2021
   Result = 30/01/2021
   Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
   Calling function firesql
username=ACEM_khandela
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=ACEM_khandela
Time elapsed = 9
   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 = 5
Reading data from stream

Executing GetTransControlString
Executing GetTransControl
Creating DbCall
Structure xml not received from client
Step3
Sql : select props from tstructs where lower(name)= :name  order by blobno

Paramval : 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 = 5
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 = 3
select * from AxAttachWorkflow where lower(transid) = 'rctcr'
Time elapsed = 5
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 = 5
select * from trn_rcms_decision where trn_rcms_decisionid=0
Time elapsed = 4
   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 = 3
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 = 5
select * from trn_rcms_hearing where trn_rcms_hearingid=0
Time elapsed = 4
   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 = 3
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 = 4
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 = 12
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 7
select distinct(schemaname) from axschema where lower(transid)='tscrg'
Time elapsed = 5
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 = 3
select distinct(schemaname) from axschema where lower(transid)='tscrg'
Time elapsed = 7
select decision_type from trn_rcms_casereg where trn_rcms_caseregid=0
Time elapsed = 3
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 = 08/04/2024
currdate after validation = 08/04/2024
court_code = 10715
trans_ccode = 18162
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 = 7
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 = 4
dec_type after validation = ????????? Id = 11782000000706
time zone difference  = 0

>>Writing to tables rctcr
Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rctcr'

Time elapsed = 2
Saving to table TRN_RCMS_TRANSREQ
select * from TRN_RCMS_TRANSREQ where  TRN_RCMS_TRANSREQid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 19427000008905
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 5
trans_ccode = 18162
court_code = 10715
Posting record
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_khandela
Param Type = c
createdon=08/04/2024 11:14:01
Param Type = c
username=ACEM_khandela
Param Type = c
modifiedon=08/04/2024 11:14:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_ccode=18162
Param Type = c
court_code=10715
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 = 19427000008906
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2021/611
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2021/611
trn_rcms_caseregid = 12948000007247
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 1
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008906
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2021/611
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2021/611
Param Type = n
trn_rcms_caseregid=12948000007247
Param Type = c
transccode=18162
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 = 215
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 = 3
RecordId = 19427000008907
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2018/00272
fromcourt = 18156000000033
fromccode = 10715
transcourt = 1044010007947
case_no = 2018/00272
trn_rcms_caseregid = 13804000003507
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 2
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008907
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2018/00272
Param Type = n
fromcourt=18156000000033
Param Type = c
fromccode=10715
Param Type = n
transcourt=1044010007947
Param Type = c
case_no=2018/00272
Param Type = n
trn_rcms_caseregid=13804000003507
Param Type = c
transccode=18162
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 = 7
Adding new record to store data from Frame 2, Row 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 19427000008908
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2022/41
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2022/41
trn_rcms_caseregid = 14563000006467
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 3
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008908
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2022/41
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2022/41
Param Type = n
trn_rcms_caseregid=14563000006467
Param Type = c
transccode=18162
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 = 4
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 = 19427000008909
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2022/42
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2022/42
trn_rcms_caseregid = 14605000007924
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 4
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008909
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2022/42
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2022/42
Param Type = n
trn_rcms_caseregid=14605000007924
Param Type = c
transccode=18162
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 = 5
Adding new record to store data from Frame 2, Row 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 19427000008910
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2018/00125
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2018/00125
trn_rcms_caseregid = 12965000002043
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 5
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008910
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2018/00125
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2018/00125
Param Type = n
trn_rcms_caseregid=12965000002043
Param Type = c
transccode=18162
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 = 5
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 19427000008911
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2018/00219
fromcourt = 18156000000033
fromccode = 10715
transcourt = 1044010007947
case_no = 2018/00219
trn_rcms_caseregid = 16963000002558
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 6
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008911
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2018/00219
Param Type = n
fromcourt=18156000000033
Param Type = c
fromccode=10715
Param Type = n
transcourt=1044010007947
Param Type = c
case_no=2018/00219
Param Type = n
trn_rcms_caseregid=16963000002558
Param Type = c
transccode=18162
Param Type = n
trn_rcms_transreqdtlrow=6
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 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 19427000008912
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2021/239
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2021/239
trn_rcms_caseregid = 12451000006698
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 7
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008912
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2021/239
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2021/239
Param Type = n
trn_rcms_caseregid=12451000006698
Param Type = c
transccode=18162
Param Type = n
trn_rcms_transreqdtlrow=7
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 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 19427000008913
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2017/00070
fromcourt = 18156000000033
fromccode = 10715
transcourt = 1044010007947
case_no = 2017/00070
trn_rcms_caseregid = 19969000001126
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 8
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008913
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2017/00070
Param Type = n
fromcourt=18156000000033
Param Type = c
fromccode=10715
Param Type = n
transcourt=1044010007947
Param Type = c
case_no=2017/00070
Param Type = n
trn_rcms_caseregid=19969000001126
Param Type = c
transccode=18162
Param Type = n
trn_rcms_transreqdtlrow=8
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 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 19427000008914
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2017/00069
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2017/00069
trn_rcms_caseregid = 19936000000802
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 9
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008914
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2017/00069
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2017/00069
Param Type = n
trn_rcms_caseregid=19936000000802
Param Type = c
transccode=18162
Param Type = n
trn_rcms_transreqdtlrow=9
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 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 19427000008915
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2001/00016
fromcourt = 18156000000033
fromccode = 10715
transcourt = 1044010007947
case_no = 2001/00016
trn_rcms_caseregid = 324870
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 10
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008915
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2001/00016
Param Type = n
fromcourt=18156000000033
Param Type = c
fromccode=10715
Param Type = n
transcourt=1044010007947
Param Type = c
case_no=2001/00016
Param Type = n
trn_rcms_caseregid=324870
Param Type = c
transccode=18162
Param Type = n
trn_rcms_transreqdtlrow=10
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 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 19427000008916
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2016/00225
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2016/00225
trn_rcms_caseregid = 11657000000507
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 11
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008916
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2016/00225
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2016/00225
Param Type = n
trn_rcms_caseregid=11657000000507
Param Type = c
transccode=18162
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 = 5
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 19427000008917
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2019/00206
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2019/00206
trn_rcms_caseregid = 10979000003105
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 12
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008917
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2019/00206
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2019/00206
Param Type = n
trn_rcms_caseregid=10979000003105
Param Type = c
transccode=18162
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 = 6
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 19427000008918
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2019/00282
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2019/00282
trn_rcms_caseregid = 16026000003563
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 13
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008918
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2019/00282
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2019/00282
Param Type = n
trn_rcms_caseregid=16026000003563
Param Type = c
transccode=18162
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 = 3
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 = 4
RecordId = 19427000008919
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2015/00367
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2015/00367
trn_rcms_caseregid = 12085000003613
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 14
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008919
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2015/00367
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2015/00367
Param Type = n
trn_rcms_caseregid=12085000003613
Param Type = c
transccode=18162
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 = 4
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 = 19427000008920
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2018/00218
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2018/00218
trn_rcms_caseregid = 16919000002199
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 15
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008920
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2018/00218
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2018/00218
Param Type = n
trn_rcms_caseregid=16919000002199
Param Type = c
transccode=18162
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 = 4
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 19427000008921
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2000/00021
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2000/00021
trn_rcms_caseregid = 324593
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 16
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008921
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2000/00021
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2000/00021
Param Type = n
trn_rcms_caseregid=324593
Param Type = c
transccode=18162
Param Type = n
trn_rcms_transreqdtlrow=16
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 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 19427000008922
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2016/00227
fromcourt = 18156000000033
fromccode = 10715
transcourt = 1044010007947
case_no = 2016/00227
trn_rcms_caseregid = 12316000000414
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 17
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008922
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2016/00227
Param Type = n
fromcourt=18156000000033
Param Type = c
fromccode=10715
Param Type = n
transcourt=1044010007947
Param Type = c
case_no=2016/00227
Param Type = n
trn_rcms_caseregid=12316000000414
Param Type = c
transccode=18162
Param Type = n
trn_rcms_transreqdtlrow=17
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 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 19427000008923
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2021/80
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2021/80
trn_rcms_caseregid = 15864000005750
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 18
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008923
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2021/80
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2021/80
Param Type = n
trn_rcms_caseregid=15864000005750
Param Type = c
transccode=18162
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 = 19427000008924
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2013/00126
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2013/00126
trn_rcms_caseregid = 324253
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 19
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008924
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2013/00126
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2013/00126
Param Type = n
trn_rcms_caseregid=324253
Param Type = c
transccode=18162
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 = 4
Adding new record to store data from Frame 2, Row 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 19427000008925
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2012/00116
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2012/00116
trn_rcms_caseregid = 324843
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 20
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008925
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2012/00116
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2012/00116
Param Type = n
trn_rcms_caseregid=324843
Param Type = c
transccode=18162
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 = 5
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 19427000008926
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2019/00103
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2019/00103
trn_rcms_caseregid = 12982000002326
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 21
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008926
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2019/00103
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2019/00103
Param Type = n
trn_rcms_caseregid=12982000002326
Param Type = c
transccode=18162
Param Type = n
trn_rcms_transreqdtlrow=21
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 = 9
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 = 3
RecordId = 19427000008927
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#1997/00011
fromcourt = 18156000000033
fromccode = 10715
transcourt = 1044010007947
case_no = 1997/00011
trn_rcms_caseregid = 324649
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 22
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008927
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#1997/00011
Param Type = n
fromcourt=18156000000033
Param Type = c
fromccode=10715
Param Type = n
transcourt=1044010007947
Param Type = c
case_no=1997/00011
Param Type = n
trn_rcms_caseregid=324649
Param Type = c
transccode=18162
Param Type = n
trn_rcms_transreqdtlrow=22
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 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 19427000008928
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2019/00139
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2019/00139
trn_rcms_caseregid = 12614000002976
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 23
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008928
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2019/00139
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2019/00139
Param Type = n
trn_rcms_caseregid=12614000002976
Param Type = c
transccode=18162
Param Type = n
trn_rcms_transreqdtlrow=23
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 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 19427000008929
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2021/240
fromcourt = 18156000000033
fromccode = 10715
transcourt = 1044010007947
case_no = 2021/240
trn_rcms_caseregid = 12477000006775
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 24
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008929
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2021/240
Param Type = n
fromcourt=18156000000033
Param Type = c
fromccode=10715
Param Type = n
transcourt=1044010007947
Param Type = c
case_no=2021/240
Param Type = n
trn_rcms_caseregid=12477000006775
Param Type = c
transccode=18162
Param Type = n
trn_rcms_transreqdtlrow=24
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 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 19427000008930
Select sysdate as sdt from dual
Time elapsed = 3
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2021/192
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2021/192
trn_rcms_caseregid = 11442000006798
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 25
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008930
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2021/192
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2021/192
Param Type = n
trn_rcms_caseregid=11442000006798
Param Type = c
transccode=18162
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 = 3
RecordId = 19427000008931
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2013/00144
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2013/00144
trn_rcms_caseregid = 324374
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 26
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008931
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2013/00144
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2013/00144
Param Type = n
trn_rcms_caseregid=324374
Param Type = c
transccode=18162
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 = 3
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 = 14
RecordId = 19427000008932
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2017/00115
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2017/00115
trn_rcms_caseregid = 10460000001560
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 27
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008932
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2017/00115
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2017/00115
Param Type = n
trn_rcms_caseregid=10460000001560
Param Type = c
transccode=18162
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 = 2
RecordId = 19427000008933
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2019/00078
fromcourt = 18156000000033
fromccode = 10715
transcourt = 1044010007947
case_no = 2019/00078
trn_rcms_caseregid = 18621000001926
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 28
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008933
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2019/00078
Param Type = n
fromcourt=18156000000033
Param Type = c
fromccode=10715
Param Type = n
transcourt=1044010007947
Param Type = c
case_no=2019/00078
Param Type = n
trn_rcms_caseregid=18621000001926
Param Type = c
transccode=18162
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 = 3
RecordId = 19427000008934
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 04/07/2023
status = 0
transContFld = T
requestno = 10715-18162#2013/00288
transcourt = 1044010007947
fromccode = 10715
fromcourt = 18156000000033
case_no = 2013/00288
trn_rcms_caseregid = 10964000000881
transccode = 18162
TRN_RCMS_TRANSREQDTLrow = 29
Posting record
Param Type = n
trn_rcms_transreqdtlid=19427000008934
Param Type = n
trn_rcms_transreqid=19427000008905
Param Type = c
decision_date=04/07/2023 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=10715-18162#2013/00288
Param Type = n
transcourt=1044010007947
Param Type = c
fromccode=10715
Param Type = n
fromcourt=18156000000033
Param Type = c
case_no=2013/00288
Param Type = n
trn_rcms_caseregid=10964000000881
Param Type = c
transccode=18162
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)

Time elapsed for insert/update = 3921736429182

>>Executing genmaps

>>Posting from rctcr to tscd from row 1

>>Mapping
Mapped court_code Row = 1 value = 10715 idvalue 0
Mapped case_no Row = 1 value = 2021/611 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 = 04/07/2023 idvalue 0
Mapped hearing_date Row = 1 value = 04/07/2023 idvalue 0
Mapped pagesource Row = 1 value = TRANSPAGE idvalue 0

>>Validating tscd

>>Frame No 1
currdate = 
Evaluating - date()
   Result of date = 08/04/2024
currdate after validation = 08/04/2024
court_name = 
username=ACEM_khandela
select court_name_mastid,court_name,court_code from v_axcourts  where paxusername=:username

username=ACEM_khandela
Time elapsed = 5
Evaluating - m_courtname
   m_courtname = ????? ??????? (FT), ???????, ????
court_name after validation = ????? ??????? (FT), ???????, ???? Id = 18156000000033
court_code = 10715
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 = 2021/611
casedetails = 
court_code=10715
case_no=2021/611
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=10715
case_no=2021/611
recordid=0
recordid=0
Time elapsed = 466
casedetails after validation = 10715
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=12948000007247
Select trn_rcms_caseid from trn_rcms_decision where trn_rcms_caseid = :S
S=12948000007247
Time elapsed = 304
trn_rcms_caseid after validation = 12948000007247
pagesource = TRANSPAGE
instdate = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
instdate after validation = 06/09/2021
case_type = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
case_type after validation = ????
act = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
act after validation = ???????? ????????? ??????? 1955
section = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
section after validation = 188,53
case_purposeid = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
case_purposeid after validation = 1000492
purpose = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
purpose after validation = ?????
hearing_date = 04/07/2023
Evaluating - iif(hearing_date>currdate,{Hearing Date Can not be greater Than Today },{T})
   hearing_date = 04/07/2023
   currdate = 08/04/2024
   Result of iif = T
escase = 
court_code=10715
case_no=2021/611
SELECT REPLACE (A1.CASE_NO, '/', '')
  FROM trn_rcms_casereg a1
 WHERE A1.COURT_CODE = :court_code AND A1.CASE_NO = :case_no

court_code=10715
case_no=2021/611
Time elapsed = 8
escase after validation = 2021611
appellant = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
appellant after validation = ?????? 
respondent = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
respondent after validation = ?????? 
decision_date = 04/07/2023
Evaluating - iif(decision_date>currdate,{Decision Date Can not be greater Than Today },{T})
   decision_date = 04/07/2023
   currdate = 08/04/2024
   Result of iif = T
decision_type = ????????? Id = 11782000000706
recordid=0
pagesource=TRANSPAGE
SELECT DECISION_MASTID, DECISION_NAME
    FROM decision_mast A
   WHERE     court_code = '10006'
         AND DECISION_MASTID NOT IN
                 (11469000000000, 11463000000022, 11776000000009)
         AND (CASE
                  WHEN :recordid > 0
                  THEN
                      1
                  WHEN     NVL ( :recordid, 0) = 0
                       AND DECISION_MASTID != 11782000000706
                  THEN
                      1
                  WHEN     NVL ( :pagesource, 'F') = 'TRANSPAGE'
                       AND DECISION_MASTID = 11782000000706
                  THEN
                      1
                  ELSE
                      0
              END) =
             1
ORDER BY DECISION_NAME

recordid=0
recordid=0
pagesource=TRANSPAGE
Time elapsed = 8
decsion_mastid = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
decsion_mastid after validation = 11782000000706
new_case_purpose = ????????? Id = 1025550004746
decision_type=?????????
SELECT b.CASE_PURPOSE_MASTID, b.CASE_PURPOSE_NAME, b.case_purpose_code
    FROM case_purpose_mast b
   WHERE CASE_PURPOSE_NAME = :decision_type
ORDER BY CASE_PURPOSE_NAME

decision_type=?????????
Time elapsed = 5
new_purpose_id = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
new_purpose_id after validation = 1025550004746
new_purpose_code = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
new_purpose_code after validation = 900
member_name = 
court_code=10715
recordid=0
SELECT G1.OFFICER_NAME, NVL (G1.AADHAAR_NO, 0) AADHAAR_NO
  FROM mst_rcms_officer g1, trn_rcms_officer g2
 WHERE     G1.MST_RCMS_OFFICERID = G2.OFFICER_NAME
       AND NVL (G1.AADHAAR_NO, 0) > 0
       AND G2.COURT_CODE = :court_code
       AND UPPER (G2.INACTIVE) = 'F'
UNION
SELECT OFFICER_NAME, AADHAAR_NO
  FROM (SELECT G.MEMBER_NAME OFFICER_NAME, NVL (G1.AADHAAR_NO, 0) AADHAAR_NO
          FROM trn_rcms_decision g, mst_rcms_officer g1, trn_rcms_officer g2
         WHERE     TRN_RCMS_DECISIONID = :recordid
               AND :recordid > 0
               AND G1.MST_RCMS_OFFICERID = G2.OFFICER_NAME
               AND G2.COURT_CODE = :court_code
               AND G1.INACTIVE = 'F'
               AND UPPER (G.MEMBER_NAME) = UPPER (G1.OFFICER_NAME(+))) P1
ORDER BY OFFICER_NAME

court_code=10715
recordid=0
recordid=0
court_code=10715
Time elapsed = 9
Member Name* cannot be left empty.
Error : 
Select sysdate as sdt from dual
Time elapsed = 3
insert into axerrorlog values('ACEM_khandela',to_date('08/04/2024 11:14:04','dd/mm/yyyy hh24:mi:ss'),'rctcr','SaveData','')
Time elapsed = 29
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=ACEM_khandela
Param Type = c
calledon=08/04/2024 11:13:46
Param Type = c
callfinished=08/04/2024 11:13:50
Param Type = c
structname=rctcr
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=Member Name* cannot be left empty.
Param Type = n
timetaken=4283
Param Type = n
dbtimetaken=2724
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