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_alwer_r" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>ACEM_alwer_r</username><password>827ccb0eea8a706c4c34a16891f84e7b</password><seed></seed><s></s><transid>trcmf</transid><recordid>0</recordid><recdata></recdata><data transid="trcmf" recordid="0"><axp_recid1 rowno="001">0</axp_recid1><courtcode rowno="001">10737</courtcode><hearing_date rowno="001">03/04/2025</hearing_date><axp_recid2 rowno="001">0</axp_recid2><court_code rowno="001">10737</court_code><case_no rowno="001">2025/39</case_no><trn_rcms_caseid rowno="001">10433000009516</trn_rcms_caseid><pre_case_purpose_name rowno="001">???</pre_case_purpose_name><pre_hear_date rowno="001">03/04/2025</pre_hear_date><pre_case_purpose rowno="001">18473000000000</pre_case_purpose><next_hear_date rowno="001">17/04/2025</next_hear_date><new_case_purpose rowno="001">18473000000000</new_case_purpose><isadjourn rowno="001">NO</isadjourn><adjourn_type rowno="001">0</adjourn_type><adjourn_remark rowno="001"></adjourn_remark><axp_recid2 rowno="002">0</axp_recid2><court_code rowno="002">10737</court_code><case_no rowno="002">2024/134</case_no><trn_rcms_caseid rowno="002">10587000008374</trn_rcms_caseid><pre_case_purpose_name rowno="002">???? ???? </pre_case_purpose_name><pre_hear_date rowno="002">03/04/2025</pre_hear_date><pre_case_purpose rowno="002">1000525</pre_case_purpose><next_hear_date rowno="002">08/05/2025</next_hear_date><new_case_purpose rowno="002">1000525</new_case_purpose><isadjourn rowno="002">NO</isadjourn><adjourn_type rowno="002">0</adjourn_type><adjourn_remark rowno="002"></adjourn_remark><axp_recid2 rowno="003">0</axp_recid2><court_code rowno="003">10737</court_code><case_no rowno="003">2024/135</case_no><trn_rcms_caseid rowno="003">10670000007855</trn_rcms_caseid><pre_case_purpose_name rowno="003">???? ???? </pre_case_purpose_name><pre_hear_date rowno="003">03/04/2025</pre_hear_date><pre_case_purpose rowno="003">1000525</pre_case_purpose><next_hear_date rowno="003">08/05/2025</next_hear_date><new_case_purpose rowno="003">1000525</new_case_purpose><isadjourn rowno="003">NO</isadjourn><adjourn_type rowno="003">0</adjourn_type><adjourn_remark rowno="003"></adjourn_remark><axp_recid2 rowno="004">0</axp_recid2><court_code rowno="004">10737</court_code><case_no rowno="004">2024/169</case_no><trn_rcms_caseid rowno="004">15054000009703</trn_rcms_caseid><pre_case_purpose_name rowno="004">???? ???? </pre_case_purpose_name><pre_hear_date rowno="004">03/04/2025</pre_hear_date><pre_case_purpose rowno="004">1000525</pre_case_purpose><next_hear_date rowno="004">22/04/2025</next_hear_date><new_case_purpose rowno="004">1000525</new_case_purpose><isadjourn rowno="004">NO</isadjourn><adjourn_type rowno="004">0</adjourn_type><adjourn_remark rowno="004"></adjourn_remark><axp_recid2 rowno="005">0</axp_recid2><court_code rowno="005">10737</court_code><case_no rowno="005">2024/170</case_no><trn_rcms_caseid rowno="005">15114000009271</trn_rcms_caseid><pre_case_purpose_name rowno="005">???? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="005">03/04/2025</pre_hear_date><pre_case_purpose rowno="005">12555000000002</pre_case_purpose><next_hear_date rowno="005">22/04/2025</next_hear_date><new_case_purpose rowno="005">12555000000002</new_case_purpose><isadjourn rowno="005">NO</isadjourn><adjourn_type rowno="005">0</adjourn_type><adjourn_remark rowno="005"></adjourn_remark><axp_recid2 rowno="006">0</axp_recid2><court_code rowno="006">10737</court_code><case_no rowno="006">2017/00359</case_no><trn_rcms_caseid rowno="006">10281000001909</trn_rcms_caseid><pre_case_purpose_name rowno="006">???????? / ???????</pre_case_purpose_name><pre_hear_date rowno="006">03/04/2025</pre_hear_date><pre_case_purpose rowno="006">1000490</pre_case_purpose><next_hear_date rowno="006">04/04/2025</next_hear_date><new_case_purpose rowno="006">18473000000000</new_case_purpose><isadjourn rowno="006">NO</isadjourn><adjourn_type rowno="006">0</adjourn_type><adjourn_remark rowno="006"></adjourn_remark><axp_recid2 rowno="007">0</axp_recid2><court_code rowno="007">10737</court_code><case_no rowno="007">2023/183</case_no><trn_rcms_caseid rowno="007">18801000007429</trn_rcms_caseid><pre_case_purpose_name rowno="007">????????? ??????? </pre_case_purpose_name><pre_hear_date rowno="007">03/04/2025</pre_hear_date><pre_case_purpose rowno="007">18625000000000</pre_case_purpose><next_hear_date rowno="007">23/04/2025</next_hear_date><new_case_purpose rowno="007">18625000000000</new_case_purpose><isadjourn rowno="007">NO</isadjourn><adjourn_type rowno="007">0</adjourn_type><adjourn_remark rowno="007"></adjourn_remark><axp_recid2 rowno="008">0</axp_recid2><court_code rowno="008">10737</court_code><case_no rowno="008">2023/80</case_no><trn_rcms_caseid rowno="008">14941000007011</trn_rcms_caseid><pre_case_purpose_name rowno="008">????????? ??????? </pre_case_purpose_name><pre_hear_date rowno="008">03/04/2025</pre_hear_date><pre_case_purpose rowno="008">18625000000000</pre_case_purpose><next_hear_date rowno="008">22/04/2025</next_hear_date><new_case_purpose rowno="008">18625000000000</new_case_purpose><isadjourn rowno="008">NO</isadjourn><adjourn_type rowno="008">0</adjourn_type><adjourn_remark rowno="008"></adjourn_remark><axp_recid2 rowno="009">0</axp_recid2><court_code rowno="009">10737</court_code><case_no rowno="009">2023/81</case_no><trn_rcms_caseid rowno="009">14956000007687</trn_rcms_caseid><pre_case_purpose_name rowno="009">????????? ??????? </pre_case_purpose_name><pre_hear_date rowno="009">03/04/2025</pre_hear_date><pre_case_purpose rowno="009">18625000000000</pre_case_purpose><next_hear_date rowno="009">22/04/2025</next_hear_date><new_case_purpose rowno="009">18625000000000</new_case_purpose><isadjourn rowno="009">NO</isadjourn><adjourn_type rowno="009">0</adjourn_type><adjourn_remark rowno="009"></adjourn_remark><axp_recid2 rowno="0010">0</axp_recid2><court_code rowno="0010">10737</court_code><case_no rowno="0010">2024/89</case_no><trn_rcms_caseid rowno="0010">19222000008730</trn_rcms_caseid><pre_case_purpose_name rowno="0010">????????? ??????? </pre_case_purpose_name><pre_hear_date rowno="0010">03/04/2025</pre_hear_date><pre_case_purpose rowno="0010">18625000000000</pre_case_purpose><next_hear_date rowno="0010">15/04/2025</next_hear_date><new_case_purpose rowno="0010">18625000000000</new_case_purpose><isadjourn rowno="0010">NO</isadjourn><adjourn_type rowno="0010">0</adjourn_type><adjourn_remark rowno="0010"></adjourn_remark><axp_recid2 rowno="0011">0</axp_recid2><court_code rowno="0011">10737</court_code><case_no rowno="0011">2022/232</case_no><trn_rcms_caseid rowno="0011">13614000007009</trn_rcms_caseid><pre_case_purpose_name rowno="0011">????</pre_case_purpose_name><pre_hear_date rowno="0011">03/04/2025</pre_hear_date><pre_case_purpose rowno="0011">18678000000000</pre_case_purpose><next_hear_date rowno="0011">30/04/2025</next_hear_date><new_case_purpose rowno="0011">18678000000000</new_case_purpose><isadjourn rowno="0011">NO</isadjourn><adjourn_type rowno="0011">0</adjourn_type><adjourn_remark rowno="0011"></adjourn_remark><axp_recid2 rowno="0012">0</axp_recid2><court_code rowno="0012">10737</court_code><case_no rowno="0012">2022/58</case_no><trn_rcms_caseid rowno="0012">19755000007304</trn_rcms_caseid><pre_case_purpose_name rowno="0012">????</pre_case_purpose_name><pre_hear_date rowno="0012">03/04/2025</pre_hear_date><pre_case_purpose rowno="0012">18678000000000</pre_case_purpose><next_hear_date rowno="0012">22/04/2025</next_hear_date><new_case_purpose rowno="0012">1000525</new_case_purpose><isadjourn rowno="0012">NO</isadjourn><adjourn_type rowno="0012">0</adjourn_type><adjourn_remark rowno="0012"></adjourn_remark><axp_recid2 rowno="0013">0</axp_recid2><court_code rowno="0013">10737</court_code><case_no rowno="0013">2022/59</case_no><trn_rcms_caseid rowno="0013">19785000005784</trn_rcms_caseid><pre_case_purpose_name rowno="0013">????</pre_case_purpose_name><pre_hear_date rowno="0013">03/04/2025</pre_hear_date><pre_case_purpose rowno="0013">18678000000000</pre_case_purpose><next_hear_date rowno="0013">22/04/2025</next_hear_date><new_case_purpose rowno="0013">1000525</new_case_purpose><isadjourn rowno="0013">NO</isadjourn><adjourn_type rowno="0013">0</adjourn_type><adjourn_remark rowno="0013"></adjourn_remark><axp_recid2 rowno="0014">0</axp_recid2><court_code rowno="0014">10737</court_code><case_no rowno="0014">2024/11</case_no><trn_rcms_caseid rowno="0014">13461000008602</trn_rcms_caseid><pre_case_purpose_name rowno="0014">????</pre_case_purpose_name><pre_hear_date rowno="0014">03/04/2025</pre_hear_date><pre_case_purpose rowno="0014">18678000000000</pre_case_purpose><next_hear_date rowno="0014">05/05/2025</next_hear_date><new_case_purpose rowno="0014">18678000000000</new_case_purpose><isadjourn rowno="0014">NO</isadjourn><adjourn_type rowno="0014">0</adjourn_type><adjourn_remark rowno="0014"></adjourn_remark><axp_recid2 rowno="0015">0</axp_recid2><court_code rowno="0015">10737</court_code><case_no rowno="0015">2024/12</case_no><trn_rcms_caseid rowno="0015">13572000007596</trn_rcms_caseid><pre_case_purpose_name rowno="0015">????</pre_case_purpose_name><pre_hear_date rowno="0015">03/04/2025</pre_hear_date><pre_case_purpose rowno="0015">18678000000000</pre_case_purpose><next_hear_date rowno="0015">05/05/2025</next_hear_date><new_case_purpose rowno="0015">18678000000000</new_case_purpose><isadjourn rowno="0015">NO</isadjourn><adjourn_type rowno="0015">0</adjourn_type><adjourn_remark rowno="0015"></adjourn_remark><axp_recid2 rowno="0016">0</axp_recid2><court_code rowno="0016">10737</court_code><case_no rowno="0016">2024/167</case_no><trn_rcms_caseid rowno="0016">13006000008414</trn_rcms_caseid><pre_case_purpose_name rowno="0016">????</pre_case_purpose_name><pre_hear_date rowno="0016">03/04/2025</pre_hear_date><pre_case_purpose rowno="0016">18678000000000</pre_case_purpose><next_hear_date rowno="0016">15/05/2025</next_hear_date><new_case_purpose rowno="0016">18678000000000</new_case_purpose><isadjourn rowno="0016">NO</isadjourn><adjourn_type rowno="0016">0</adjourn_type><adjourn_remark rowno="0016"></adjourn_remark><axp_recid2 rowno="0017">0</axp_recid2><court_code rowno="0017">10737</court_code><case_no rowno="0017">2024/188</case_no><trn_rcms_caseid rowno="0017">17324000008397</trn_rcms_caseid><pre_case_purpose_name rowno="0017">????</pre_case_purpose_name><pre_hear_date rowno="0017">03/04/2025</pre_hear_date><pre_case_purpose rowno="0017">18678000000000</pre_case_purpose><next_hear_date rowno="0017">09/04/2025</next_hear_date><new_case_purpose rowno="0017">1000525</new_case_purpose><isadjourn rowno="0017">NO</isadjourn><adjourn_type rowno="0017">0</adjourn_type><adjourn_remark rowno="0017"></adjourn_remark><axp_recid2 rowno="0018">0</axp_recid2><court_code rowno="0018">10737</court_code><case_no rowno="0018">2024/189</case_no><trn_rcms_caseid rowno="0018">17454000009785</trn_rcms_caseid><pre_case_purpose_name rowno="0018">????</pre_case_purpose_name><pre_hear_date rowno="0018">03/04/2025</pre_hear_date><pre_case_purpose rowno="0018">18678000000000</pre_case_purpose><next_hear_date rowno="0018">09/04/2025</next_hear_date><new_case_purpose rowno="0018">1000525</new_case_purpose><isadjourn rowno="0018">NO</isadjourn><adjourn_type rowno="0018">0</adjourn_type><adjourn_remark rowno="0018"></adjourn_remark><axp_recid2 rowno="0019">0</axp_recid2><court_code rowno="0019">10737</court_code><case_no rowno="0019">2024/267</case_no><trn_rcms_caseid rowno="0019">19295000009296</trn_rcms_caseid><pre_case_purpose_name rowno="0019">????</pre_case_purpose_name><pre_hear_date rowno="0019">03/04/2025</pre_hear_date><pre_case_purpose rowno="0019">18678000000000</pre_case_purpose><next_hear_date rowno="0019">22/04/2025</next_hear_date><new_case_purpose rowno="0019">18678000000000</new_case_purpose><isadjourn rowno="0019">NO</isadjourn><adjourn_type rowno="0019">0</adjourn_type><adjourn_remark rowno="0019"></adjourn_remark><axp_recid2 rowno="0020">0</axp_recid2><court_code rowno="0020">10737</court_code><case_no rowno="0020">2024/268</case_no><trn_rcms_caseid rowno="0020">19368000010561</trn_rcms_caseid><pre_case_purpose_name rowno="0020">????</pre_case_purpose_name><pre_hear_date rowno="0020">03/04/2025</pre_hear_date><pre_case_purpose rowno="0020">18678000000000</pre_case_purpose><next_hear_date rowno="0020">22/04/2025</next_hear_date><new_case_purpose rowno="0020">18678000000000</new_case_purpose><isadjourn rowno="0020">NO</isadjourn><adjourn_type rowno="0020">0</adjourn_type><adjourn_remark rowno="0020"></adjourn_remark><axp_recid2 rowno="0021">0</axp_recid2><court_code rowno="0021">10737</court_code><case_no rowno="0021">2024/272</case_no><trn_rcms_caseid rowno="0021">13221000009474</trn_rcms_caseid><pre_case_purpose_name rowno="0021">????</pre_case_purpose_name><pre_hear_date rowno="0021">03/04/2025</pre_hear_date><pre_case_purpose rowno="0021">18678000000000</pre_case_purpose><next_hear_date rowno="0021">08/04/2025</next_hear_date><new_case_purpose rowno="0021">18678000000000</new_case_purpose><isadjourn rowno="0021">NO</isadjourn><adjourn_type rowno="0021">0</adjourn_type><adjourn_remark rowno="0021"></adjourn_remark><axp_recid2 rowno="0022">0</axp_recid2><court_code rowno="0022">10737</court_code><case_no rowno="0022">2024/273</case_no><trn_rcms_caseid rowno="0022">13955000009420</trn_rcms_caseid><pre_case_purpose_name rowno="0022">????</pre_case_purpose_name><pre_hear_date rowno="0022">03/04/2025</pre_hear_date><pre_case_purpose rowno="0022">18678000000000</pre_case_purpose><next_hear_date rowno="0022">08/04/2025</next_hear_date><new_case_purpose rowno="0022">18678000000000</new_case_purpose><isadjourn rowno="0022">NO</isadjourn><adjourn_type rowno="0022">0</adjourn_type><adjourn_remark rowno="0022"></adjourn_remark><axp_recid2 rowno="0023">0</axp_recid2><court_code rowno="0023">10737</court_code><case_no rowno="0023">2024/73</case_no><trn_rcms_caseid rowno="0023">12866000010345</trn_rcms_caseid><pre_case_purpose_name rowno="0023">????</pre_case_purpose_name><pre_hear_date rowno="0023">03/04/2025</pre_hear_date><pre_case_purpose rowno="0023">18678000000000</pre_case_purpose><next_hear_date rowno="0023">30/04/2025</next_hear_date><new_case_purpose rowno="0023">18678000000000</new_case_purpose><isadjourn rowno="0023">NO</isadjourn><adjourn_type rowno="0023">0</adjourn_type><adjourn_remark rowno="0023"></adjourn_remark><axp_recid2 rowno="0024">0</axp_recid2><court_code rowno="0024">10737</court_code><case_no rowno="0024">2024/74</case_no><trn_rcms_caseid rowno="0024">12908000008068</trn_rcms_caseid><pre_case_purpose_name rowno="0024">????</pre_case_purpose_name><pre_hear_date rowno="0024">03/04/2025</pre_hear_date><pre_case_purpose rowno="0024">18678000000000</pre_case_purpose><next_hear_date rowno="0024">30/04/2025</next_hear_date><new_case_purpose rowno="0024">18678000000000</new_case_purpose><isadjourn rowno="0024">NO</isadjourn><adjourn_type rowno="0024">0</adjourn_type><adjourn_remark rowno="0024"></adjourn_remark><axp_recid2 rowno="0025">0</axp_recid2><court_code rowno="0025">10737</court_code><case_no rowno="0025">2024/75</case_no><trn_rcms_caseid rowno="0025">14327000008004</trn_rcms_caseid><pre_case_purpose_name rowno="0025">????</pre_case_purpose_name><pre_hear_date rowno="0025">03/04/2025</pre_hear_date><pre_case_purpose rowno="0025">18678000000000</pre_case_purpose><next_hear_date rowno="0025">30/04/2025</next_hear_date><new_case_purpose rowno="0025">18678000000000</new_case_purpose><isadjourn rowno="0025">NO</isadjourn><adjourn_type rowno="0025">0</adjourn_type><adjourn_remark rowno="0025"></adjourn_remark><axp_recid2 rowno="0026">0</axp_recid2><court_code rowno="0026">10737</court_code><case_no rowno="0026">2024/76</case_no><trn_rcms_caseid rowno="0026">14392000008434</trn_rcms_caseid><pre_case_purpose_name rowno="0026">????</pre_case_purpose_name><pre_hear_date rowno="0026">03/04/2025</pre_hear_date><pre_case_purpose rowno="0026">18678000000000</pre_case_purpose><next_hear_date rowno="0026">30/04/2025</next_hear_date><new_case_purpose rowno="0026">18678000000000</new_case_purpose><isadjourn rowno="0026">NO</isadjourn><adjourn_type rowno="0026">0</adjourn_type><adjourn_remark rowno="0026"></adjourn_remark><axp_recid2 rowno="0027">0</axp_recid2><court_code rowno="0027">10737</court_code><case_no rowno="0027">2025/38</case_no><trn_rcms_caseid rowno="0027">10399000009823</trn_rcms_caseid><pre_case_purpose_name rowno="0027">????</pre_case_purpose_name><pre_hear_date rowno="0027">03/04/2025</pre_hear_date><pre_case_purpose rowno="0027">18678000000000</pre_case_purpose><next_hear_date rowno="0027">17/04/2025</next_hear_date><new_case_purpose rowno="0027">18678000000000</new_case_purpose><isadjourn rowno="0027">NO</isadjourn><adjourn_type rowno="0027">0</adjourn_type><adjourn_remark rowno="0027"></adjourn_remark><axp_recid2 rowno="0028">0</axp_recid2><court_code rowno="0028">10737</court_code><case_no rowno="0028">2008/00254</case_no><trn_rcms_caseid rowno="0028">241416</trn_rcms_caseid><pre_case_purpose_name rowno="0028">??????? ?????</pre_case_purpose_name><pre_hear_date rowno="0028">03/04/2025</pre_hear_date><pre_case_purpose rowno="0028">18619000000000</pre_case_purpose><next_hear_date rowno="0028">30/04/2025</next_hear_date><new_case_purpose rowno="0028">18619000000000</new_case_purpose><isadjourn rowno="0028">NO</isadjourn><adjourn_type rowno="0028">0</adjourn_type><adjourn_remark rowno="0028"></adjourn_remark><axp_recid2 rowno="0029">0</axp_recid2><court_code rowno="0029">10737</court_code><case_no rowno="0029">2012/00679</case_no><trn_rcms_caseid rowno="0029">17393000001222</trn_rcms_caseid><pre_case_purpose_name rowno="0029">??????? ?????</pre_case_purpose_name><pre_hear_date rowno="0029">03/04/2025</pre_hear_date><pre_case_purpose rowno="0029">18619000000000</pre_case_purpose><next_hear_date rowno="0029">30/04/2025</next_hear_date><new_case_purpose rowno="0029">18619000000000</new_case_purpose><isadjourn rowno="0029">NO</isadjourn><adjourn_type rowno="0029">0</adjourn_type><adjourn_remark rowno="0029"></adjourn_remark><axp_recid2 rowno="0030">0</axp_recid2><court_code rowno="0030">10737</court_code><case_no rowno="0030">2021/195</case_no><trn_rcms_caseid rowno="0030">10210000006622</trn_rcms_caseid><pre_case_purpose_name rowno="0030">??????? ?????</pre_case_purpose_name><pre_hear_date rowno="0030">03/04/2025</pre_hear_date><pre_case_purpose rowno="0030">18619000000000</pre_case_purpose><next_hear_date rowno="0030">22/04/2025</next_hear_date><new_case_purpose rowno="0030">18619000000000</new_case_purpose><isadjourn rowno="0030">NO</isadjourn><adjourn_type rowno="0030">0</adjourn_type><adjourn_remark rowno="0030"></adjourn_remark></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"ACEM_alwer_r","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"trcmf","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtcode":"10737","hearing_date":"03/04/2025"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"court_code":"10737","case_no":"2025/39","trn_rcms_caseid":"10433000009516","pre_case_purpose_name":"???","pre_hear_date":"03/04/2025","pre_case_purpose":"18473000000000","next_hear_date":"17/04/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"002","text":"0","columns":{"court_code":"10737","case_no":"2024/134","trn_rcms_caseid":"10587000008374","pre_case_purpose_name":"???? ???? ","pre_hear_date":"03/04/2025","pre_case_purpose":"1000525","next_hear_date":"08/05/2025","new_case_purpose":"1000525","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"003","text":"0","columns":{"court_code":"10737","case_no":"2024/135","trn_rcms_caseid":"10670000007855","pre_case_purpose_name":"???? ???? ","pre_hear_date":"03/04/2025","pre_case_purpose":"1000525","next_hear_date":"08/05/2025","new_case_purpose":"1000525","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"004","text":"0","columns":{"court_code":"10737","case_no":"2024/169","trn_rcms_caseid":"15054000009703","pre_case_purpose_name":"???? ???? ","pre_hear_date":"03/04/2025","pre_case_purpose":"1000525","next_hear_date":"22/04/2025","new_case_purpose":"1000525","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"005","text":"0","columns":{"court_code":"10737","case_no":"2024/170","trn_rcms_caseid":"15114000009271","pre_case_purpose_name":"???? ????????? ????","pre_hear_date":"03/04/2025","pre_case_purpose":"12555000000002","next_hear_date":"22/04/2025","new_case_purpose":"12555000000002","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"006","text":"0","columns":{"court_code":"10737","case_no":"2017/00359","trn_rcms_caseid":"10281000001909","pre_case_purpose_name":"???????? / ???????","pre_hear_date":"03/04/2025","pre_case_purpose":"1000490","next_hear_date":"04/04/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"007","text":"0","columns":{"court_code":"10737","case_no":"2023/183","trn_rcms_caseid":"18801000007429","pre_case_purpose_name":"????????? ??????? ","pre_hear_date":"03/04/2025","pre_case_purpose":"18625000000000","next_hear_date":"23/04/2025","new_case_purpose":"18625000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"008","text":"0","columns":{"court_code":"10737","case_no":"2023/80","trn_rcms_caseid":"14941000007011","pre_case_purpose_name":"????????? ??????? ","pre_hear_date":"03/04/2025","pre_case_purpose":"18625000000000","next_hear_date":"22/04/2025","new_case_purpose":"18625000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"009","text":"0","columns":{"court_code":"10737","case_no":"2023/81","trn_rcms_caseid":"14956000007687","pre_case_purpose_name":"????????? ??????? ","pre_hear_date":"03/04/2025","pre_case_purpose":"18625000000000","next_hear_date":"22/04/2025","new_case_purpose":"18625000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0010","text":"0","columns":{"court_code":"10737","case_no":"2024/89","trn_rcms_caseid":"19222000008730","pre_case_purpose_name":"????????? ??????? ","pre_hear_date":"03/04/2025","pre_case_purpose":"18625000000000","next_hear_date":"15/04/2025","new_case_purpose":"18625000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0011","text":"0","columns":{"court_code":"10737","case_no":"2022/232","trn_rcms_caseid":"13614000007009","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"30/04/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0012","text":"0","columns":{"court_code":"10737","case_no":"2022/58","trn_rcms_caseid":"19755000007304","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"22/04/2025","new_case_purpose":"1000525","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0013","text":"0","columns":{"court_code":"10737","case_no":"2022/59","trn_rcms_caseid":"19785000005784","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"22/04/2025","new_case_purpose":"1000525","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0014","text":"0","columns":{"court_code":"10737","case_no":"2024/11","trn_rcms_caseid":"13461000008602","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"05/05/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0015","text":"0","columns":{"court_code":"10737","case_no":"2024/12","trn_rcms_caseid":"13572000007596","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"05/05/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0016","text":"0","columns":{"court_code":"10737","case_no":"2024/167","trn_rcms_caseid":"13006000008414","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"15/05/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0017","text":"0","columns":{"court_code":"10737","case_no":"2024/188","trn_rcms_caseid":"17324000008397","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"09/04/2025","new_case_purpose":"1000525","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0018","text":"0","columns":{"court_code":"10737","case_no":"2024/189","trn_rcms_caseid":"17454000009785","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"09/04/2025","new_case_purpose":"1000525","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0019","text":"0","columns":{"court_code":"10737","case_no":"2024/267","trn_rcms_caseid":"19295000009296","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"22/04/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0020","text":"0","columns":{"court_code":"10737","case_no":"2024/268","trn_rcms_caseid":"19368000010561","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"22/04/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0021","text":"0","columns":{"court_code":"10737","case_no":"2024/272","trn_rcms_caseid":"13221000009474","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"08/04/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0022","text":"0","columns":{"court_code":"10737","case_no":"2024/273","trn_rcms_caseid":"13955000009420","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"08/04/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0023","text":"0","columns":{"court_code":"10737","case_no":"2024/73","trn_rcms_caseid":"12866000010345","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"30/04/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0024","text":"0","columns":{"court_code":"10737","case_no":"2024/74","trn_rcms_caseid":"12908000008068","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"30/04/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0025","text":"0","columns":{"court_code":"10737","case_no":"2024/75","trn_rcms_caseid":"14327000008004","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"30/04/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0026","text":"0","columns":{"court_code":"10737","case_no":"2024/76","trn_rcms_caseid":"14392000008434","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"30/04/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0027","text":"0","columns":{"court_code":"10737","case_no":"2025/38","trn_rcms_caseid":"10399000009823","pre_case_purpose_name":"????","pre_hear_date":"03/04/2025","pre_case_purpose":"18678000000000","next_hear_date":"17/04/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0028","text":"0","columns":{"court_code":"10737","case_no":"2008/00254","trn_rcms_caseid":"241416","pre_case_purpose_name":"??????? ?????","pre_hear_date":"03/04/2025","pre_case_purpose":"18619000000000","next_hear_date":"30/04/2025","new_case_purpose":"18619000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0029","text":"0","columns":{"court_code":"10737","case_no":"2012/00679","trn_rcms_caseid":"17393000001222","pre_case_purpose_name":"??????? ?????","pre_hear_date":"03/04/2025","pre_case_purpose":"18619000000000","next_hear_date":"30/04/2025","new_case_purpose":"18619000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0030","text":"0","columns":{"court_code":"10737","case_no":"2021/195","trn_rcms_caseid":"10210000006622","pre_case_purpose_name":"??????? ?????","pre_hear_date":"03/04/2025","pre_case_purpose":"18619000000000","next_hear_date":"22/04/2025","new_case_purpose":"18619000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}}]}]}}
Verifying username and password
User Name : ACEM_alwer_r
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=acem_alwer_r
Time elapsed = 31
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 17
Result : 
Verifying completed...
Page Access Category : 
User Name : acem_alwer_r
Select sysdate as sdt from dual
Time elapsed = 31
dt=04/04/2025 10:22:37
Select sysdate as sdt from dual
Time elapsed = 17
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_alwer_r
dt=04/04/2025 10:22:37
dt=04/04/2025 10:22:37
Time elapsed = 54
User Groups: court_reader
select userroles from axusergroups where groupname in ( 'court_reader' )
Time elapsed = 15
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 = 13
Step4
axprops\stm size:4235
Step4-123456
<root updatedon="06/12/2024 17:18:50" name="app" caption="app" appverno="10.1.0.0" updusername="" updatedby="admin"><props LocalNum="738"><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_alwer_r
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=ACEM_alwer_r
Time elapsed = 22
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{court_name})
   Calling function sqlget
   Result of sqlget = ????? ???????,????
   Result = ????? ???????,????
   Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
   Calling function firesql
username=ACEM_alwer_r
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=ACEM_alwer_r
Time elapsed = 28
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type})
   Calling function sqlget
   Result of sqlget = ACEM
   Result = ACEM
   Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
   Calling function firesql
username=ACEM_alwer_r
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=ACEM_alwer_r
Time elapsed = 27
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{court_name_mastid})
   Calling function sqlget
   Result of sqlget = 18453000000000
   Result = 18453000000000
   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_alwer_r
Time elapsed = 13
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{axusersid})
   Calling function sqlget
   Result of sqlget = 4221
   Result = 4221
   Evaluating firesql({m4},{select :username as uname from dual})
   Calling function firesql
select :username as uname from dual
username=ACEM_alwer_r
Time elapsed = 21
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{uname})
   Calling function sqlget
   Result of sqlget = ACEM_alwer_r
   Result = ACEM_alwer_r
   Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
   Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=ACEM_alwer_r
Time elapsed = 21
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{COURT_CODE})
   Calling function sqlget
   Result of sqlget = 10737
   Result = 10737
   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 = 12
   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_alwer_r
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ACEM_alwer_r
Time elapsed = 24
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m7},{DISTNAMEENG})
   Calling function sqlget
   Result of sqlget = Alwar
   Result = Alwar
   Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=ACEM_alwer_r
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ACEM_alwer_r
Time elapsed = 17
   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=4221
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=4221
Time elapsed = 27
   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_alwer_r
Time elapsed = 20
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type_mastid})
   Calling function sqlget
   Result of sqlget = 10257000000001
   Result = 10257000000001
   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_alwer_r
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=ACEM_alwer_r
Time elapsed = 23
   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 = 14
   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_alwer_r
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=ACEM_alwer_r
Time elapsed = 17
   Result of firesql = 
   Result = 
   Evaluating  sqlget({P1},{ct})
   Calling function sqlget
   Result of sqlget = 6
   Result = 6
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='trcmf' and stype = 't' )

Time elapsed = 14
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 16
Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno

Paramval : court_reader,trcmf,t
ParamTYpe : ccc
Param List : rname
sname
stype

select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno

Time elapsed = 11
Reading data from stream

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

Paramval : trcmf
ParamTYpe : c
Param List : name

select props from tstructs where lower(name)= :name  order by blobno

Time elapsed = 14
Step4
tstructs\stm size:2075
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
   Evaluating date()
   Result = 
   Evaluating iif((next_hear_date<currdate) | (next_hear_date<pre_hear_date) ,{Hearing date should be greater or equal to current date/previous hearing date.},{T})
   Result = 
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=trcmf
adxinout=o
Time elapsed = 28
select * from trn_rcms_mhearing where trn_rcms_mhearingid=0
Time elapsed = 15
select * from Axusers where 1=2
Time elapsed = 12
select distinct(fldname) from AxTempUserFields
Time elapsed = 11
select * from AxAttachWorkflow where lower(transid) = 'trcmf'
Time elapsed = 15
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 = 9
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 = 30
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 18
Loading genmaps
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 trcmf

>>Frame No 1
courtcode = 10737
hearing_date = 03/04/2025
time zone difference  = 0

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

Time elapsed = 14
Saving to table TRN_RCMS_MHEARING
select * from TRN_RCMS_MHEARING where  TRN_RCMS_MHEARINGid=0
Time elapsed = 13
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 11
RecordId = 10453000010889
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 15
hearing_date = 03/04/2025
courtcode = 10737
Posting record
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:40
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=03/04/2025 00:00:00
Param Type = c
courtcode=10737
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)

Saving to table TRN_RCMS_HEARING
select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 12
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 = 17
RecordId = 10453000010890
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 22
Select sysdate as sdt from dual
Time elapsed = 17
new_case_purpose = 18473000000000
next_hear_date = 17/04/2025
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
case_no = 2025/39
court_code = 10737
trn_rcms_caseid = 10433000009516
pre_case_purpose = 18473000000000
pre_hear_date = 03/04/2025
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=10453000010890
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:40
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=17/04/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2025/39
Param Type = c
court_code=10737
Param Type = c
trn_rcms_caseid=10433000009516
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,next_hear_date,adjourn_type,adjourn_remark,isadjourn,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,null,:isadjourn,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 15
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 = 11
RecordId = 10453000010891
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 20
Select sysdate as sdt from dual
Time elapsed = 12
next_hear_date = 08/05/2025
new_case_purpose = 1000525
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2024/134
court_code = 10737
trn_rcms_caseid = 10587000008374
pre_case_purpose = 1000525
pre_hear_date = 03/04/2025
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=10453000010891
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:41
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/05/2025 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/134
Param Type = c
court_code=10737
Param Type = c
trn_rcms_caseid=10587000008374
Param Type = n
pre_case_purpose=1000525
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 17
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 = 12
RecordId = 10453000010892
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 12
pre_hear_date = 03/04/2025
pre_case_purpose = 1000525
trn_rcms_caseid = 10670000007855
court_code = 10737
case_no = 2024/135
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000525
next_hear_date = 08/05/2025
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=10453000010892
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:42
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
pre_case_purpose=1000525
Param Type = c
trn_rcms_caseid=10670000007855
Param Type = c
court_code=10737
Param Type = c
case_no=2024/135
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=08/05/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 10
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 = 13
RecordId = 10453000010893
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 13
pre_hear_date = 03/04/2025
pre_case_purpose = 1000525
trn_rcms_caseid = 15054000009703
court_code = 10737
case_no = 2024/169
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000525
next_hear_date = 22/04/2025
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=10453000010893
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:42
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
pre_case_purpose=1000525
Param Type = c
trn_rcms_caseid=15054000009703
Param Type = c
court_code=10737
Param Type = c
case_no=2024/169
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=22/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 15
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 = 13
RecordId = 10453000010894
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 13
next_hear_date = 22/04/2025
new_case_purpose = 12555000000002
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2024/170
court_code = 10737
trn_rcms_caseid = 15114000009271
pre_case_purpose = 12555000000002
pre_hear_date = 03/04/2025
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=10453000010894
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:43
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/04/2025 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/170
Param Type = c
court_code=10737
Param Type = c
trn_rcms_caseid=15114000009271
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 11
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 = 15
RecordId = 10453000010895
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 11
pre_hear_date = 03/04/2025
pre_case_purpose = 1000490
trn_rcms_caseid = 10281000001909
court_code = 10737
case_no = 2017/00359
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 04/04/2025
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=10453000010895
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:43
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
pre_case_purpose=1000490
Param Type = c
trn_rcms_caseid=10281000001909
Param Type = c
court_code=10737
Param Type = c
case_no=2017/00359
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=04/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 13
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 = 13
RecordId = 10453000010896
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 13
next_hear_date = 23/04/2025
isadjourn = NO
new_case_purpose = 18625000000000
pre_case_purpose = 18625000000000
pre_hear_date = 03/04/2025
case_no = 2023/183
court_code = 10737
trn_rcms_caseid = 18801000007429
adjourn_type = 0
adjourn_remark = 
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=10453000010896
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:44
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=23/04/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18625000000000
Param Type = n
pre_case_purpose=18625000000000
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = c
case_no=2023/183
Param Type = c
court_code=10737
Param Type = c
trn_rcms_caseid=18801000007429
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_type,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:adjourn_type,null,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 25
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 = 13
RecordId = 10453000010897
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 14
pre_hear_date = 03/04/2025
trn_rcms_caseid = 14941000007011
pre_case_purpose = 18625000000000
next_hear_date = 22/04/2025
new_case_purpose = 18625000000000
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
case_no = 2023/80
court_code = 10737
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=10453000010897
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:44
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = c
trn_rcms_caseid=14941000007011
Param Type = n
pre_case_purpose=18625000000000
Param Type = c
next_hear_date=22/04/2025 00:00:00
Param Type = c
new_case_purpose=18625000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2023/80
Param Type = c
court_code=10737
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,pre_case_purpose,next_hear_date,new_case_purpose,adjourn_type,adjourn_remark,isadjourn,case_no,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,:isadjourn,:case_no,:court_code,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 14
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 15
RecordId = 10453000010898
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 18
Select sysdate as sdt from dual
Time elapsed = 16
pre_hear_date = 03/04/2025
trn_rcms_caseid = 14956000007687
pre_case_purpose = 18625000000000
new_case_purpose = 18625000000000
next_hear_date = 22/04/2025
adjourn_remark = 
isadjourn = NO
court_code = 10737
adjourn_type = 0
case_no = 2023/81
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=10453000010898
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:45
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = c
trn_rcms_caseid=14956000007687
Param Type = n
pre_case_purpose=18625000000000
Param Type = c
new_case_purpose=18625000000000
Param Type = c
next_hear_date=22/04/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
court_code=10737
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/81
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,pre_case_purpose,new_case_purpose,next_hear_date,adjourn_remark,isadjourn,court_code,adjourn_type,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:isadjourn,:court_code,:adjourn_type,:case_no,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 15
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 = 13
RecordId = 10453000010899
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 7
case_no = 2024/89
isadjourn = NO
next_hear_date = 15/04/2025
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 18625000000000
pre_hear_date = 03/04/2025
trn_rcms_caseid = 19222000008730
court_code = 10737
pre_case_purpose = 18625000000000
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=10453000010899
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:46
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2024/89
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=15/04/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18625000000000
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = c
trn_rcms_caseid=19222000008730
Param Type = c
court_code=10737
Param Type = n
pre_case_purpose=18625000000000
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,pre_hear_date,trn_rcms_caseid,court_code,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 15
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 = 13
RecordId = 10453000010900
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 15
pre_hear_date = 03/04/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 13614000007009
court_code = 10737
case_no = 2022/232
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 30/04/2025
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=10453000010900
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:46
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=13614000007009
Param Type = c
court_code=10737
Param Type = c
case_no=2022/232
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=30/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 18
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 = 15
RecordId = 10453000010901
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 17
pre_hear_date = 03/04/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 19755000007304
court_code = 10737
case_no = 2022/58
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000525
next_hear_date = 22/04/2025
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=10453000010901
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:47
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=19755000007304
Param Type = c
court_code=10737
Param Type = c
case_no=2022/58
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=22/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 13
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 = 13
RecordId = 10453000010902
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 18
next_hear_date = 22/04/2025
new_case_purpose = 1000525
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2022/59
court_code = 10737
trn_rcms_caseid = 19785000005784
pre_case_purpose = 18678000000000
pre_hear_date = 03/04/2025
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=10453000010902
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:48
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/04/2025 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/59
Param Type = c
court_code=10737
Param Type = c
trn_rcms_caseid=19785000005784
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 15
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 = 14
RecordId = 10453000010903
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 15
adjourn_remark = 
new_case_purpose = 18678000000000
adjourn_type = 0
next_hear_date = 05/05/2025
isadjourn = NO
case_no = 2024/11
court_code = 10737
trn_rcms_caseid = 13461000008602
pre_case_purpose = 18678000000000
pre_hear_date = 03/04/2025
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=10453000010903
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:48
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=05/05/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/11
Param Type = c
court_code=10737
Param Type = c
trn_rcms_caseid=13461000008602
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=14
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,new_case_purpose,adjourn_type,next_hear_date,isadjourn,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:new_case_purpose,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 14
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 = 13
RecordId = 10453000010904
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 17
pre_hear_date = 03/04/2025
trn_rcms_caseid = 13572000007596
isadjourn = NO
pre_case_purpose = 18678000000000
adjourn_type = 0
court_code = 10737
case_no = 2024/12
adjourn_remark = 
new_case_purpose = 18678000000000
next_hear_date = 05/05/2025
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=10453000010904
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:49
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = c
trn_rcms_caseid=13572000007596
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
court_code=10737
Param Type = c
case_no=2024/12
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=05/05/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,isadjourn,pre_case_purpose,adjourn_type,court_code,case_no,adjourn_remark,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:isadjourn,:pre_case_purpose,:adjourn_type,:court_code,:case_no,null,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 12
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 = 13
RecordId = 10453000010905
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 14
isadjourn = NO
adjourn_type = 0
next_hear_date = 15/05/2025
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
pre_hear_date = 03/04/2025
case_no = 2024/167
adjourn_remark = 
trn_rcms_caseid = 13006000008414
court_code = 10737
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=10453000010905
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:50
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=15/05/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = c
case_no=2024/167
Param Type = c
trn_rcms_caseid=13006000008414
Param Type = c
court_code=10737
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,next_hear_date,pre_case_purpose,new_case_purpose,pre_hear_date,case_no,adjourn_remark,trn_rcms_caseid,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,null,:trn_rcms_caseid,:court_code,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 14
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 13
RecordId = 10453000010906
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 15
pre_hear_date = 03/04/2025
pre_case_purpose = 18678000000000
trn_rcms_caseid = 17324000008397
court_code = 10737
case_no = 2024/188
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000525
next_hear_date = 09/04/2025
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=10453000010906
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:50
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=17324000008397
Param Type = c
court_code=10737
Param Type = c
case_no=2024/188
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000525
Param Type = c
next_hear_date=09/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 15
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 = 12
RecordId = 10453000010907
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 12
next_hear_date = 09/04/2025
new_case_purpose = 1000525
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2024/189
court_code = 10737
trn_rcms_caseid = 17454000009785
pre_case_purpose = 18678000000000
pre_hear_date = 03/04/2025
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=10453000010907
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:52
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:52
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=09/04/2025 00:00:00
Param Type = c
new_case_purpose=1000525
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/189
Param Type = c
court_code=10737
Param Type = c
trn_rcms_caseid=17454000009785
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 12
Adding new record to store data from Frame 2, Row 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 11
RecordId = 10453000010908
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 18
Select sysdate as sdt from dual
Time elapsed = 14
case_no = 2024/267
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 19295000009296
pre_hear_date = 03/04/2025
adjourn_remark = 
court_code = 10737
adjourn_type = 0
next_hear_date = 22/04/2025
isadjourn = NO
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=10453000010908
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:53
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:53
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2024/267
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=19295000009296
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = c
court_code=10737
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=22/04/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 15
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 = 14
RecordId = 10453000010909
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 17
pre_hear_date = 03/04/2025
adjourn_remark = 
trn_rcms_caseid = 19368000010561
court_code = 10737
case_no = 2024/268
next_hear_date = 22/04/2025
isadjourn = NO
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
adjourn_type = 0
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=10453000010909
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:54
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = c
trn_rcms_caseid=19368000010561
Param Type = c
court_code=10737
Param Type = c
case_no=2024/268
Param Type = c
next_hear_date=22/04/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,adjourn_remark,trn_rcms_caseid,court_code,case_no,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:trn_rcms_caseid,:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,:adjourn_type,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 17
Adding new record to store data from Frame 2, Row 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 12
RecordId = 10453000010910
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 13
adjourn_remark = 
trn_rcms_caseid = 13221000009474
pre_hear_date = 03/04/2025
court_code = 10737
case_no = 2024/272
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 08/04/2025
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=10453000010910
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:54
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=13221000009474
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = c
court_code=10737
Param Type = c
case_no=2024/272
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 14
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 = 16
RecordId = 10453000010911
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 14
adjourn_remark = 
trn_rcms_caseid = 13955000009420
pre_hear_date = 03/04/2025
court_code = 10737
case_no = 2024/273
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 08/04/2025
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=10453000010911
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:55
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=13955000009420
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = c
court_code=10737
Param Type = c
case_no=2024/273
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 16
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 19
RecordId = 10453000010912
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 16
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 12866000010345
case_no = 2024/73
pre_hear_date = 03/04/2025
next_hear_date = 30/04/2025
new_case_purpose = 18678000000000
isadjourn = NO
court_code = 10737
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=10453000010912
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:56
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=12866000010345
Param Type = c
case_no=2024/73
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = c
next_hear_date=30/04/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
court_code=10737
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,case_no,pre_hear_date,next_hear_date,new_case_purpose,isadjourn,court_code,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 15
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 = 12
RecordId = 10453000010913
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 14
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 12908000008068
pre_hear_date = 03/04/2025
court_code = 10737
case_no = 2024/74
next_hear_date = 30/04/2025
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=10453000010913
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:56
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=12908000008068
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = c
court_code=10737
Param Type = c
case_no=2024/74
Param Type = c
next_hear_date=30/04/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 14
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 = 13
RecordId = 10453000010914
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 12
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
trn_rcms_caseid = 14327000008004
pre_hear_date = 03/04/2025
pre_case_purpose = 18678000000000
case_no = 2024/75
next_hear_date = 30/04/2025
new_case_purpose = 18678000000000
court_code = 10737
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=10453000010914
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:57
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=14327000008004
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2024/75
Param Type = c
next_hear_date=30/04/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
court_code=10737
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,next_hear_date,new_case_purpose,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:court_code,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 16
Adding new record to store data from Frame 2, Row 26 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 14
RecordId = 10453000010915
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 19
isadjourn = NO
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 14392000008434
case_no = 2024/76
court_code = 10737
pre_hear_date = 03/04/2025
next_hear_date = 30/04/2025
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=10453000010915
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:57
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=14392000008434
Param Type = c
case_no=2024/76
Param Type = c
court_code=10737
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = c
next_hear_date=30/04/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 19
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 = 15
RecordId = 10453000010916
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 16
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
next_hear_date = 17/04/2025
case_no = 2025/38
court_code = 10737
trn_rcms_caseid = 10399000009823
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 03/04/2025
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=10453000010916
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:58
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=17/04/2025 00:00:00
Param Type = c
case_no=2025/38
Param Type = c
court_code=10737
Param Type = c
trn_rcms_caseid=10399000009823
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=27
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,case_no,court_code,trn_rcms_caseid,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 13
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 = 13
RecordId = 10453000010917
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 12
next_hear_date = 30/04/2025
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 241416
case_no = 2008/00254
court_code = 10737
new_case_purpose = 18619000000000
pre_case_purpose = 18619000000000
pre_hear_date = 03/04/2025
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=10453000010917
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:59
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=30/04/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=241416
Param Type = c
case_no=2008/00254
Param Type = c
court_code=10737
Param Type = c
new_case_purpose=18619000000000
Param Type = n
pre_case_purpose=18619000000000
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 12
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 = 10
RecordId = 10453000010918
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 11
next_hear_date = 30/04/2025
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 18619000000000
case_no = 2012/00679
court_code = 10737
trn_rcms_caseid = 17393000001222
pre_case_purpose = 18619000000000
pre_hear_date = 03/04/2025
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=10453000010918
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:22:59
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:22:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=30/04/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18619000000000
Param Type = c
case_no=2012/00679
Param Type = c
court_code=10737
Param Type = c
trn_rcms_caseid=17393000001222
Param Type = n
pre_case_purpose=18619000000000
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=29
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 11
Adding new record to store data from Frame 2, Row 30 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 11
RecordId = 10453000010919
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 14
next_hear_date = 22/04/2025
new_case_purpose = 18619000000000
adjourn_remark = 
adjourn_type = 0
isadjourn = NO
case_no = 2021/195
court_code = 10737
trn_rcms_caseid = 10210000006622
pre_case_purpose = 18619000000000
pre_hear_date = 03/04/2025
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=10453000010919
Param Type = n
trn_rcms_mhearingid=10453000010889
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:00
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/04/2025 00:00:00
Param Type = c
new_case_purpose=18619000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2021/195
Param Type = c
court_code=10737
Param Type = c
trn_rcms_caseid=10210000006622
Param Type = n
pre_case_purpose=18619000000000
Param Type = c
pre_hear_date=03/04/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_remark,adjourn_type,isadjourn,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,null,:adjourn_type,:isadjourn,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

Time elapsed for insert/update = 3952923780086

>>Executing genmaps

>>Posting from trcmf to tchdh from row 1

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10433000009516 idvalue 0
Mapped case_no Row = 1 value = 2025/39 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 17/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 10433000009516
case_no = 2025/39
prev_hearing_date = 03/04/2025
hearing_date = 17/04/2025
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purposename=???
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=???
Time elapsed = 20
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 11
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 13
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 12
RecordId = 10453000010920
MapName trcmf1
SourceId 10453000010890
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 13
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 17/04/2025
case_no = 2025/39
trn_rcms_caseregid = 10433000009516
court_code = 10737
case_purpose = 18473000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010920
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010890
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:01
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=17/04/2025 00:00:00
Param Type = c
case_no=2025/39
Param Type = c
trn_rcms_caseregid=10433000009516
Param Type = c
court_code=10737
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 2

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10587000008374 idvalue 0
Mapped case_no Row = 1 value = 2024/134 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????  idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 08/05/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 10587000008374
case_no = 2024/134
prev_hearing_date = 03/04/2025
hearing_date = 08/05/2025
prev_case_purposename = ???? ???? 
prev_case_purpose = 
prev_case_purposename=???? ???? 
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=???? ???? 
Time elapsed = 33
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 11
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 12
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 10453000010921
MapName trcmf1
SourceId 10453000010891
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 12
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 08/05/2025
case_no = 2024/134
trn_rcms_caseregid = 10587000008374
court_code = 10737
case_purpose = 1000525
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010921
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010891
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:05
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:05
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=08/05/2025 00:00:00
Param Type = c
case_no=2024/134
Param Type = c
trn_rcms_caseregid=10587000008374
Param Type = c
court_code=10737
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 3

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10670000007855 idvalue 0
Mapped case_no Row = 1 value = 2024/135 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????  idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 08/05/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 10670000007855
case_no = 2024/135
prev_hearing_date = 03/04/2025
hearing_date = 08/05/2025
prev_case_purposename = ???? ???? 
prev_case_purpose = 
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 12
RecordId = 10453000010922
MapName trcmf1
SourceId 10453000010892
Select sysdate as sdt from dual
Time elapsed = 18
Select sysdate as sdt from dual
Time elapsed = 17
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 08/05/2025
case_no = 2024/135
trn_rcms_caseregid = 10670000007855
court_code = 10737
case_purpose = 1000525
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010922
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010892
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:09
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=08/05/2025 00:00:00
Param Type = c
case_no=2024/135
Param Type = c
trn_rcms_caseregid=10670000007855
Param Type = c
court_code=10737
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 4

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15054000009703 idvalue 0
Mapped case_no Row = 1 value = 2024/169 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????  idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 22/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 15054000009703
case_no = 2024/169
prev_hearing_date = 03/04/2025
hearing_date = 22/04/2025
prev_case_purposename = ???? ???? 
prev_case_purpose = 
prev_case_purpose after validation = 1000525
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 11
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 10
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 13
RecordId = 10453000010923
MapName trcmf1
SourceId 10453000010893
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 13
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 22/04/2025
case_no = 2024/169
trn_rcms_caseregid = 15054000009703
court_code = 10737
case_purpose = 1000525
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010923
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010893
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:13
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000525
Param Type = c
hearing_date=22/04/2025 00:00:00
Param Type = c
case_no=2024/169
Param Type = c
trn_rcms_caseregid=15054000009703
Param Type = c
court_code=10737
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 5

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15114000009271 idvalue 0
Mapped case_no Row = 1 value = 2024/170 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 22/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 15114000009271
case_no = 2024/170
prev_hearing_date = 03/04/2025
hearing_date = 22/04/2025
prev_case_purposename = ???? ????????? ????
prev_case_purpose = 
prev_case_purposename=???? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=???? ????????? ????
Time elapsed = 16
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 10
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 16
RecordId = 10453000010924
MapName trcmf1
SourceId 10453000010894
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 17
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 22/04/2025
case_no = 2024/170
trn_rcms_caseregid = 15114000009271
court_code = 10737
case_purpose = 12555000000002
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010924
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010894
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:17
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=12555000000002
Param Type = c
hearing_date=22/04/2025 00:00:00
Param Type = c
case_no=2024/170
Param Type = c
trn_rcms_caseregid=15114000009271
Param Type = c
court_code=10737
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 6

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10281000001909 idvalue 0
Mapped case_no Row = 1 value = 2017/00359 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? / ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 04/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 10281000001909
case_no = 2017/00359
prev_hearing_date = 03/04/2025
hearing_date = 04/04/2025
prev_case_purposename = ???????? / ???????
prev_case_purpose = 
prev_case_purposename=???????? / ???????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=???????? / ???????
Time elapsed = 19
prev_case_purpose after validation = 1000490
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 12
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 14
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 = 11
RecordId = 10453000010925
MapName trcmf1
SourceId 10453000010895
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 18
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000490
hearing_date = 04/04/2025
case_no = 2017/00359
trn_rcms_caseregid = 10281000001909
court_code = 10737
case_purpose = 18473000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010925
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010895
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:21
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000490
Param Type = c
hearing_date=04/04/2025 00:00:00
Param Type = c
case_no=2017/00359
Param Type = c
trn_rcms_caseregid=10281000001909
Param Type = c
court_code=10737
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 7

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18801000007429 idvalue 0
Mapped case_no Row = 1 value = 2023/183 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????????? ???????  idvalue 0
Mapped case_purpose Row = 1 value = 18625000000000 idvalue 0
Mapped hearing_date Row = 1 value = 23/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 18801000007429
case_no = 2023/183
prev_hearing_date = 03/04/2025
hearing_date = 23/04/2025
prev_case_purposename = ????????? ??????? 
prev_case_purpose = 
prev_case_purposename=????????? ??????? 
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=????????? ??????? 
Time elapsed = 21
prev_case_purpose after validation = 18625000000000
case_purpose = 18625000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 18
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 16
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 12
RecordId = 10453000010926
MapName trcmf1
SourceId 10453000010896
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 10
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18625000000000
hearing_date = 23/04/2025
case_no = 2023/183
trn_rcms_caseregid = 18801000007429
court_code = 10737
case_purpose = 18625000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010926
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010896
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:25
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18625000000000
Param Type = c
hearing_date=23/04/2025 00:00:00
Param Type = c
case_no=2023/183
Param Type = c
trn_rcms_caseregid=18801000007429
Param Type = c
court_code=10737
Param Type = c
case_purpose=18625000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 8

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14941000007011 idvalue 0
Mapped case_no Row = 1 value = 2023/80 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????????? ???????  idvalue 0
Mapped case_purpose Row = 1 value = 18625000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 14941000007011
case_no = 2023/80
prev_hearing_date = 03/04/2025
hearing_date = 22/04/2025
prev_case_purposename = ????????? ??????? 
prev_case_purpose = 
prev_case_purpose after validation = 18625000000000
case_purpose = 18625000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 11
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 15
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 8
RecordId = 10453000010927
MapName trcmf1
SourceId 10453000010897
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 10
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18625000000000
hearing_date = 22/04/2025
case_no = 2023/80
trn_rcms_caseregid = 14941000007011
court_code = 10737
case_purpose = 18625000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010927
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010897
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:29
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18625000000000
Param Type = c
hearing_date=22/04/2025 00:00:00
Param Type = c
case_no=2023/80
Param Type = c
trn_rcms_caseregid=14941000007011
Param Type = c
court_code=10737
Param Type = c
case_purpose=18625000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 9

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14956000007687 idvalue 0
Mapped case_no Row = 1 value = 2023/81 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????????? ???????  idvalue 0
Mapped case_purpose Row = 1 value = 18625000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 14956000007687
case_no = 2023/81
prev_hearing_date = 03/04/2025
hearing_date = 22/04/2025
prev_case_purposename = ????????? ??????? 
prev_case_purpose = 
prev_case_purpose after validation = 18625000000000
case_purpose = 18625000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 10
RecordId = 10453000010928
MapName trcmf1
SourceId 10453000010898
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 13
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18625000000000
hearing_date = 22/04/2025
case_no = 2023/81
trn_rcms_caseregid = 14956000007687
court_code = 10737
case_purpose = 18625000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010928
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010898
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:32
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18625000000000
Param Type = c
hearing_date=22/04/2025 00:00:00
Param Type = c
case_no=2023/81
Param Type = c
trn_rcms_caseregid=14956000007687
Param Type = c
court_code=10737
Param Type = c
case_purpose=18625000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 10

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19222000008730 idvalue 0
Mapped case_no Row = 1 value = 2024/89 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????????? ???????  idvalue 0
Mapped case_purpose Row = 1 value = 18625000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 19222000008730
case_no = 2024/89
prev_hearing_date = 03/04/2025
hearing_date = 15/04/2025
prev_case_purposename = ????????? ??????? 
prev_case_purpose = 
prev_case_purpose after validation = 18625000000000
case_purpose = 18625000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 9
RecordId = 10453000010929
MapName trcmf1
SourceId 10453000010899
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18625000000000
hearing_date = 15/04/2025
case_no = 2024/89
trn_rcms_caseregid = 19222000008730
court_code = 10737
case_purpose = 18625000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010929
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010899
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:36
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18625000000000
Param Type = c
hearing_date=15/04/2025 00:00:00
Param Type = c
case_no=2024/89
Param Type = c
trn_rcms_caseregid=19222000008730
Param Type = c
court_code=10737
Param Type = c
case_purpose=18625000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 11

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13614000007009 idvalue 0
Mapped case_no Row = 1 value = 2022/232 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 13614000007009
case_no = 2022/232
prev_hearing_date = 03/04/2025
hearing_date = 30/04/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=????
Time elapsed = 20
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 10
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 13
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 10
RecordId = 10453000010930
MapName trcmf1
SourceId 10453000010900
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 30/04/2025
case_no = 2022/232
trn_rcms_caseregid = 13614000007009
court_code = 10737
case_purpose = 18678000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010930
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010900
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:40
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=30/04/2025 00:00:00
Param Type = c
case_no=2022/232
Param Type = c
trn_rcms_caseregid=13614000007009
Param Type = c
court_code=10737
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 12

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19755000007304 idvalue 0
Mapped case_no Row = 1 value = 2022/58 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 22/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 19755000007304
case_no = 2022/58
prev_hearing_date = 03/04/2025
hearing_date = 22/04/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 15
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 14
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 = 12
RecordId = 10453000010931
MapName trcmf1
SourceId 10453000010901
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/04/2025
case_no = 2022/58
trn_rcms_caseregid = 19755000007304
court_code = 10737
case_purpose = 1000525
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010931
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010901
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:44
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/04/2025 00:00:00
Param Type = c
case_no=2022/58
Param Type = c
trn_rcms_caseregid=19755000007304
Param Type = c
court_code=10737
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 13

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19785000005784 idvalue 0
Mapped case_no Row = 1 value = 2022/59 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 22/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 19785000005784
case_no = 2022/59
prev_hearing_date = 03/04/2025
hearing_date = 22/04/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 8
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 11
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 9
RecordId = 10453000010932
MapName trcmf1
SourceId 10453000010902
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 14
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/04/2025
case_no = 2022/59
trn_rcms_caseregid = 19785000005784
court_code = 10737
case_purpose = 1000525
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010932
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010902
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:47
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/04/2025 00:00:00
Param Type = c
case_no=2022/59
Param Type = c
trn_rcms_caseregid=19785000005784
Param Type = c
court_code=10737
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 14

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13461000008602 idvalue 0
Mapped case_no Row = 1 value = 2024/11 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/05/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 13461000008602
case_no = 2024/11
prev_hearing_date = 03/04/2025
hearing_date = 05/05/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 10
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 12
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 12
RecordId = 10453000010933
MapName trcmf1
SourceId 10453000010903
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 16
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/05/2025
case_no = 2024/11
trn_rcms_caseregid = 13461000008602
court_code = 10737
case_purpose = 18678000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010933
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010903
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:51
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/05/2025 00:00:00
Param Type = c
case_no=2024/11
Param Type = c
trn_rcms_caseregid=13461000008602
Param Type = c
court_code=10737
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 15

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13572000007596 idvalue 0
Mapped case_no Row = 1 value = 2024/12 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 05/05/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 13572000007596
case_no = 2024/12
prev_hearing_date = 03/04/2025
hearing_date = 05/05/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 21
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 15
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 10
RecordId = 10453000010934
MapName trcmf1
SourceId 10453000010904
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 05/05/2025
case_no = 2024/12
trn_rcms_caseregid = 13572000007596
court_code = 10737
case_purpose = 18678000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010934
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010904
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:23:55
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:23:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=05/05/2025 00:00:00
Param Type = c
case_no=2024/12
Param Type = c
trn_rcms_caseregid=13572000007596
Param Type = c
court_code=10737
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 16

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13006000008414 idvalue 0
Mapped case_no Row = 1 value = 2024/167 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/05/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 13006000008414
case_no = 2024/167
prev_hearing_date = 03/04/2025
hearing_date = 15/05/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 23
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 26
RecordId = 10453000010935
MapName trcmf1
SourceId 10453000010905
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 22
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 15/05/2025
case_no = 2024/167
trn_rcms_caseregid = 13006000008414
court_code = 10737
case_purpose = 18678000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010935
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010905
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:01
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=15/05/2025 00:00:00
Param Type = c
case_no=2024/167
Param Type = c
trn_rcms_caseregid=13006000008414
Param Type = c
court_code=10737
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 17

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17324000008397 idvalue 0
Mapped case_no Row = 1 value = 2024/188 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 09/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 17324000008397
case_no = 2024/188
prev_hearing_date = 03/04/2025
hearing_date = 09/04/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 18
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 40
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 = 15
RecordId = 10453000010936
MapName trcmf1
SourceId 10453000010906
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 14
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/04/2025
case_no = 2024/188
trn_rcms_caseregid = 17324000008397
court_code = 10737
case_purpose = 1000525
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010936
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010906
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:05
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:05
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/04/2025 00:00:00
Param Type = c
case_no=2024/188
Param Type = c
trn_rcms_caseregid=17324000008397
Param Type = c
court_code=10737
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 18

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17454000009785 idvalue 0
Mapped case_no Row = 1 value = 2024/189 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000525 idvalue 0
Mapped hearing_date Row = 1 value = 09/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 17454000009785
case_no = 2024/189
prev_hearing_date = 03/04/2025
hearing_date = 09/04/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 1000525
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 39
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 14
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 = 18
RecordId = 10453000010937
MapName trcmf1
SourceId 10453000010907
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 13
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/04/2025
case_no = 2024/189
trn_rcms_caseregid = 17454000009785
court_code = 10737
case_purpose = 1000525
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010937
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010907
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:09
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/04/2025 00:00:00
Param Type = c
case_no=2024/189
Param Type = c
trn_rcms_caseregid=17454000009785
Param Type = c
court_code=10737
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 19

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19295000009296 idvalue 0
Mapped case_no Row = 1 value = 2024/267 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 19295000009296
case_no = 2024/267
prev_hearing_date = 03/04/2025
hearing_date = 22/04/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 12
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 17
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 18
RecordId = 10453000010938
MapName trcmf1
SourceId 10453000010908
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 23
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/04/2025
case_no = 2024/267
trn_rcms_caseregid = 19295000009296
court_code = 10737
case_purpose = 18678000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010938
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010908
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:13
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/04/2025 00:00:00
Param Type = c
case_no=2024/267
Param Type = c
trn_rcms_caseregid=19295000009296
Param Type = c
court_code=10737
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 20

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19368000010561 idvalue 0
Mapped case_no Row = 1 value = 2024/268 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 19368000010561
case_no = 2024/268
prev_hearing_date = 03/04/2025
hearing_date = 22/04/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 13
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 17
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 12
RecordId = 10453000010939
MapName trcmf1
SourceId 10453000010909
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 16
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 22/04/2025
case_no = 2024/268
trn_rcms_caseregid = 19368000010561
court_code = 10737
case_purpose = 18678000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010939
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010909
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:17
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=22/04/2025 00:00:00
Param Type = c
case_no=2024/268
Param Type = c
trn_rcms_caseregid=19368000010561
Param Type = c
court_code=10737
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 21

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13221000009474 idvalue 0
Mapped case_no Row = 1 value = 2024/272 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 13221000009474
case_no = 2024/272
prev_hearing_date = 03/04/2025
hearing_date = 08/04/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 17
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 13
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 13
RecordId = 10453000010940
MapName trcmf1
SourceId 10453000010910
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/04/2025
case_no = 2024/272
trn_rcms_caseregid = 13221000009474
court_code = 10737
case_purpose = 18678000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010940
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010910
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:21
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/04/2025 00:00:00
Param Type = c
case_no=2024/272
Param Type = c
trn_rcms_caseregid=13221000009474
Param Type = c
court_code=10737
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 22

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13955000009420 idvalue 0
Mapped case_no Row = 1 value = 2024/273 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 13955000009420
case_no = 2024/273
prev_hearing_date = 03/04/2025
hearing_date = 08/04/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 10
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 27
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 = 12
RecordId = 10453000010941
MapName trcmf1
SourceId 10453000010911
Select sysdate as sdt from dual
Time elapsed = 20
Select sysdate as sdt from dual
Time elapsed = 14
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/04/2025
case_no = 2024/273
trn_rcms_caseregid = 13955000009420
court_code = 10737
case_purpose = 18678000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010941
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010911
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:24
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/04/2025 00:00:00
Param Type = c
case_no=2024/273
Param Type = c
trn_rcms_caseregid=13955000009420
Param Type = c
court_code=10737
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 23

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12866000010345 idvalue 0
Mapped case_no Row = 1 value = 2024/73 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 12866000010345
case_no = 2024/73
prev_hearing_date = 03/04/2025
hearing_date = 30/04/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 29
RecordId = 10453000010942
MapName trcmf1
SourceId 10453000010912
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 30/04/2025
case_no = 2024/73
trn_rcms_caseregid = 12866000010345
court_code = 10737
case_purpose = 18678000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010942
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010912
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:28
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=30/04/2025 00:00:00
Param Type = c
case_no=2024/73
Param Type = c
trn_rcms_caseregid=12866000010345
Param Type = c
court_code=10737
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 24

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12908000008068 idvalue 0
Mapped case_no Row = 1 value = 2024/74 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 12908000008068
case_no = 2024/74
prev_hearing_date = 03/04/2025
hearing_date = 30/04/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 11
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 13
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 11
RecordId = 10453000010943
MapName trcmf1
SourceId 10453000010913
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 30/04/2025
case_no = 2024/74
trn_rcms_caseregid = 12908000008068
court_code = 10737
case_purpose = 18678000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010943
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010913
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:32
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=30/04/2025 00:00:00
Param Type = c
case_no=2024/74
Param Type = c
trn_rcms_caseregid=12908000008068
Param Type = c
court_code=10737
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 25

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14327000008004 idvalue 0
Mapped case_no Row = 1 value = 2024/75 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 14327000008004
case_no = 2024/75
prev_hearing_date = 03/04/2025
hearing_date = 30/04/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 15
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 16
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 13
RecordId = 10453000010944
MapName trcmf1
SourceId 10453000010914
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 30/04/2025
case_no = 2024/75
trn_rcms_caseregid = 14327000008004
court_code = 10737
case_purpose = 18678000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010944
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010914
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:36
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=30/04/2025 00:00:00
Param Type = c
case_no=2024/75
Param Type = c
trn_rcms_caseregid=14327000008004
Param Type = c
court_code=10737
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 26

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14392000008434 idvalue 0
Mapped case_no Row = 1 value = 2024/76 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 14392000008434
case_no = 2024/76
prev_hearing_date = 03/04/2025
hearing_date = 30/04/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 10
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 26
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 = 19
RecordId = 10453000010945
MapName trcmf1
SourceId 10453000010915
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 12
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 30/04/2025
case_no = 2024/76
trn_rcms_caseregid = 14392000008434
court_code = 10737
case_purpose = 18678000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010945
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010915
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:40
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=30/04/2025 00:00:00
Param Type = c
case_no=2024/76
Param Type = c
trn_rcms_caseregid=14392000008434
Param Type = c
court_code=10737
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 27

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10399000009823 idvalue 0
Mapped case_no Row = 1 value = 2025/38 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 17/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 10399000009823
case_no = 2025/38
prev_hearing_date = 03/04/2025
hearing_date = 17/04/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 13
RecordId = 10453000010946
MapName trcmf1
SourceId 10453000010916
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 14
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 17/04/2025
case_no = 2025/38
trn_rcms_caseregid = 10399000009823
court_code = 10737
case_purpose = 18678000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010946
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010916
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:44
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=17/04/2025 00:00:00
Param Type = c
case_no=2025/38
Param Type = c
trn_rcms_caseregid=10399000009823
Param Type = c
court_code=10737
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 28

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 241416 idvalue 0
Mapped case_no Row = 1 value = 2008/00254 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????? idvalue 0
Mapped case_purpose Row = 1 value = 18619000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 241416
case_no = 2008/00254
prev_hearing_date = 03/04/2025
hearing_date = 30/04/2025
prev_case_purposename = ??????? ?????
prev_case_purpose = 
prev_case_purposename=??????? ?????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=??????? ?????
Time elapsed = 22
prev_case_purpose after validation = 18619000000000
case_purpose = 18619000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 8
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 26
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 = 16
RecordId = 10453000010947
MapName trcmf1
SourceId 10453000010917
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18619000000000
hearing_date = 30/04/2025
case_no = 2008/00254
trn_rcms_caseregid = 241416
court_code = 10737
case_purpose = 18619000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010947
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010917
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:47
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18619000000000
Param Type = c
hearing_date=30/04/2025 00:00:00
Param Type = c
case_no=2008/00254
Param Type = c
trn_rcms_caseregid=241416
Param Type = c
court_code=10737
Param Type = c
case_purpose=18619000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 29

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17393000001222 idvalue 0
Mapped case_no Row = 1 value = 2012/00679 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????? idvalue 0
Mapped case_purpose Row = 1 value = 18619000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 17393000001222
case_no = 2012/00679
prev_hearing_date = 03/04/2025
hearing_date = 30/04/2025
prev_case_purposename = ??????? ?????
prev_case_purpose = 
prev_case_purpose after validation = 18619000000000
case_purpose = 18619000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 12
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 26
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 = 14
RecordId = 10453000010948
MapName trcmf1
SourceId 10453000010918
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 14
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18619000000000
hearing_date = 30/04/2025
case_no = 2012/00679
trn_rcms_caseregid = 17393000001222
court_code = 10737
case_purpose = 18619000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010948
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010918
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:51
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18619000000000
Param Type = c
hearing_date=30/04/2025 00:00:00
Param Type = c
case_no=2012/00679
Param Type = c
trn_rcms_caseregid=17393000001222
Param Type = c
court_code=10737
Param Type = c
case_purpose=18619000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 30

>>Mapping
Mapped court_code Row = 1 value = 10737 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10210000006622 idvalue 0
Mapped case_no Row = 1 value = 2021/195 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/04/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????? idvalue 0
Mapped case_purpose Row = 1 value = 18619000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/04/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10737
trn_rcms_caseregid = 10210000006622
case_no = 2021/195
prev_hearing_date = 03/04/2025
hearing_date = 22/04/2025
prev_case_purposename = ??????? ?????
prev_case_purpose = 
prev_case_purpose after validation = 18619000000000
case_purpose = 18619000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 9
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 22
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 = 15
RecordId = 10453000010949
MapName trcmf1
SourceId 10453000010919
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 14
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18619000000000
hearing_date = 22/04/2025
case_no = 2021/195
trn_rcms_caseregid = 10210000006622
court_code = 10737
case_purpose = 18619000000000
prev_hearing_date = 03/04/2025
Posting record
Param Type = n
trn_rcms_case_histid=10453000010949
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10453000010919
Param Type = c
cancel=F
Param Type = c
createdby=ACEM_alwer_r
Param Type = c
createdon=04/04/2025 10:25:54
Param Type = c
username=ACEM_alwer_r
Param Type = c
modifiedon=04/04/2025 10:25:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18619000000000
Param Type = c
hearing_date=22/04/2025 00:00:00
Param Type = c
case_no=2021/195
Param Type = c
trn_rcms_caseregid=10210000006622
Param Type = c
court_code=10737
Param Type = c
case_purpose=18619000000000
Param Type = c
prev_hearing_date=03/04/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))

Time elapsed for Gen Map = 3952923957338
Time elapsed for MD Map = 3952923957347
Time elapsed for Save History = 3952923957354
Time elapsed for Save Attachment = 3952923957361
Time elapsed for After Save WF Exec = 3952923957370
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"10453000010889"}]}
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_alwer_r
Param Type = c
calledon=04/04/2025 10:22:36
Param Type = c
callfinished=04/04/2025 10:25:57
Param Type = c
structname=trcmf
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=success
Param Type = n
timetaken=201404
Param Type = n
dbtimetaken=116143
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