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="SDO_malsisar" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>SDO_malsisar</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">10028</courtcode><hearing_date rowno="001">21/02/2023</hearing_date><axp_recid2 rowno="001">0</axp_recid2><court_code rowno="001">10028</court_code><case_no rowno="001">2013/00297</case_no><trn_rcms_caseid rowno="001">16112000002743</trn_rcms_caseid><pre_case_purpose_name rowno="001">????</pre_case_purpose_name><pre_hear_date rowno="001">21/02/2023</pre_hear_date><pre_case_purpose rowno="001">18678000000000</pre_case_purpose><next_hear_date rowno="001">28/03/2023</next_hear_date><new_case_purpose rowno="001">18678000000000</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">10028</court_code><case_no rowno="002">2010/00051</case_no><trn_rcms_caseid rowno="002">145588</trn_rcms_caseid><pre_case_purpose_name rowno="002">????</pre_case_purpose_name><pre_hear_date rowno="002">21/02/2023</pre_hear_date><pre_case_purpose rowno="002">1407440000046</pre_case_purpose><next_hear_date rowno="002">28/03/2023</next_hear_date><new_case_purpose rowno="002">1407440000046</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">10028</court_code><case_no rowno="003">2013/00304</case_no><trn_rcms_caseid rowno="003">17878000002499</trn_rcms_caseid><pre_case_purpose_name rowno="003">????</pre_case_purpose_name><pre_hear_date rowno="003">21/02/2023</pre_hear_date><pre_case_purpose rowno="003">1407440000046</pre_case_purpose><next_hear_date rowno="003">28/03/2023</next_hear_date><new_case_purpose rowno="003">1407440000046</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">10028</court_code><case_no rowno="004">2016/00088</case_no><trn_rcms_caseid rowno="004">10488000000504</trn_rcms_caseid><pre_case_purpose_name rowno="004">????</pre_case_purpose_name><pre_hear_date rowno="004">21/02/2023</pre_hear_date><pre_case_purpose rowno="004">1407440000046</pre_case_purpose><next_hear_date rowno="004">28/03/2023</next_hear_date><new_case_purpose rowno="004">1407440000046</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">10028</court_code><case_no rowno="005">2007/00035</case_no><trn_rcms_caseid rowno="005">145957</trn_rcms_caseid><pre_case_purpose_name rowno="005">???????  ???? </pre_case_purpose_name><pre_hear_date rowno="005">21/02/2023</pre_hear_date><pre_case_purpose rowno="005">2000041</pre_case_purpose><next_hear_date rowno="005">28/03/2023</next_hear_date><new_case_purpose rowno="005">2000041</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">10028</court_code><case_no rowno="006">2012/00160</case_no><trn_rcms_caseid rowno="006">146021</trn_rcms_caseid><pre_case_purpose_name rowno="006">???????  ???? </pre_case_purpose_name><pre_hear_date rowno="006">21/02/2023</pre_hear_date><pre_case_purpose rowno="006">2000041</pre_case_purpose><next_hear_date rowno="006">28/03/2023</next_hear_date><new_case_purpose rowno="006">2000041</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">10028</court_code><case_no rowno="007">2013/00313</case_no><trn_rcms_caseid rowno="007">11669000002992</trn_rcms_caseid><pre_case_purpose_name rowno="007">???????  ???? </pre_case_purpose_name><pre_hear_date rowno="007">21/02/2023</pre_hear_date><pre_case_purpose rowno="007">2000041</pre_case_purpose><next_hear_date rowno="007">28/03/2023</next_hear_date><new_case_purpose rowno="007">2000041</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">10028</court_code><case_no rowno="008">2016/00016</case_no><trn_rcms_caseid rowno="008">19406000000654</trn_rcms_caseid><pre_case_purpose_name rowno="008">???????  ???? </pre_case_purpose_name><pre_hear_date rowno="008">21/02/2023</pre_hear_date><pre_case_purpose rowno="008">2000041</pre_case_purpose><next_hear_date rowno="008">28/03/2023</next_hear_date><new_case_purpose rowno="008">2000041</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">10028</court_code><case_no rowno="009">2016/00024</case_no><trn_rcms_caseid rowno="009">10064000000483</trn_rcms_caseid><pre_case_purpose_name rowno="009">???????  ???? </pre_case_purpose_name><pre_hear_date rowno="009">21/02/2023</pre_hear_date><pre_case_purpose rowno="009">2000041</pre_case_purpose><next_hear_date rowno="009">28/03/2023</next_hear_date><new_case_purpose rowno="009">2000041</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">10028</court_code><case_no rowno="0010">2016/00177</case_no><trn_rcms_caseid rowno="0010">16535000000585</trn_rcms_caseid><pre_case_purpose_name rowno="0010">???????  ???? </pre_case_purpose_name><pre_hear_date rowno="0010">21/02/2023</pre_hear_date><pre_case_purpose rowno="0010">2000041</pre_case_purpose><next_hear_date rowno="0010">28/03/2023</next_hear_date><new_case_purpose rowno="0010">2000041</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">10028</court_code><case_no rowno="0011">2006/00017</case_no><trn_rcms_caseid rowno="0011">145973</trn_rcms_caseid><pre_case_purpose_name rowno="0011">???? ?????</pre_case_purpose_name><pre_hear_date rowno="0011">21/02/2023</pre_hear_date><pre_case_purpose rowno="0011">10663000002303</pre_case_purpose><next_hear_date rowno="0011">28/03/2023</next_hear_date><new_case_purpose rowno="0011">10663000002303</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">10028</court_code><case_no rowno="0012">2007/00045</case_no><trn_rcms_caseid rowno="0012">14190000003400</trn_rcms_caseid><pre_case_purpose_name rowno="0012">???? ?????</pre_case_purpose_name><pre_hear_date rowno="0012">21/02/2023</pre_hear_date><pre_case_purpose rowno="0012">10663000002303</pre_case_purpose><next_hear_date rowno="0012">28/03/2023</next_hear_date><new_case_purpose rowno="0012">10663000002303</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">10028</court_code><case_no rowno="0013">2013/00280</case_no><trn_rcms_caseid rowno="0013">17471000002878</trn_rcms_caseid><pre_case_purpose_name rowno="0013">???? ?????</pre_case_purpose_name><pre_hear_date rowno="0013">21/02/2023</pre_hear_date><pre_case_purpose rowno="0013">10663000002303</pre_case_purpose><next_hear_date rowno="0013">28/03/2023</next_hear_date><new_case_purpose rowno="0013">10663000002303</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">10028</court_code><case_no rowno="0014">2016/00074</case_no><trn_rcms_caseid rowno="0014">10456000000693</trn_rcms_caseid><pre_case_purpose_name rowno="0014">???????? ????  ?????</pre_case_purpose_name><pre_hear_date rowno="0014">21/02/2023</pre_hear_date><pre_case_purpose rowno="0014">10101000000665</pre_case_purpose><next_hear_date rowno="0014">28/03/2023</next_hear_date><new_case_purpose rowno="0014">10101000000665</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">10028</court_code><case_no rowno="0015">2013/00338</case_no><trn_rcms_caseid rowno="0015">18968000002652</trn_rcms_caseid><pre_case_purpose_name rowno="0015">???</pre_case_purpose_name><pre_hear_date rowno="0015">21/02/2023</pre_hear_date><pre_case_purpose rowno="0015">18473000000000</pre_case_purpose><next_hear_date rowno="0015">28/03/2023</next_hear_date><new_case_purpose rowno="0015">18473000000000</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">10028</court_code><case_no rowno="0016">2016/00119</case_no><trn_rcms_caseid rowno="0016">12350000000479</trn_rcms_caseid><pre_case_purpose_name rowno="0016">???</pre_case_purpose_name><pre_hear_date rowno="0016">21/02/2023</pre_hear_date><pre_case_purpose rowno="0016">18473000000000</pre_case_purpose><next_hear_date rowno="0016">28/03/2023</next_hear_date><new_case_purpose rowno="0016">18473000000000</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">10028</court_code><case_no rowno="0017">2016/00149</case_no><trn_rcms_caseid rowno="0017">14607000000535</trn_rcms_caseid><pre_case_purpose_name rowno="0017">???</pre_case_purpose_name><pre_hear_date rowno="0017">21/02/2023</pre_hear_date><pre_case_purpose rowno="0017">18473000000000</pre_case_purpose><next_hear_date rowno="0017">28/03/2023</next_hear_date><new_case_purpose rowno="0017">18473000000000</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">10028</court_code><case_no rowno="0018">2016/00151</case_no><trn_rcms_caseid rowno="0018">14672000000447</trn_rcms_caseid><pre_case_purpose_name rowno="0018">???</pre_case_purpose_name><pre_hear_date rowno="0018">21/02/2023</pre_hear_date><pre_case_purpose rowno="0018">18473000000000</pre_case_purpose><next_hear_date rowno="0018">28/03/2023</next_hear_date><new_case_purpose rowno="0018">18473000000000</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">10028</court_code><case_no rowno="0019">2016/00147</case_no><trn_rcms_caseid rowno="0019">14529000000314</trn_rcms_caseid><pre_case_purpose_name rowno="0019">??? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="0019">21/02/2023</pre_hear_date><pre_case_purpose rowno="0019">19542000000536</pre_case_purpose><next_hear_date rowno="0019">28/03/2023</next_hear_date><new_case_purpose rowno="0019">19542000000536</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">10028</court_code><case_no rowno="0020">2012/00149</case_no><trn_rcms_caseid rowno="0020">145949</trn_rcms_caseid><pre_case_purpose_name rowno="0020">???? ???? </pre_case_purpose_name><pre_hear_date rowno="0020">21/02/2023</pre_hear_date><pre_case_purpose rowno="0020">1000525</pre_case_purpose><next_hear_date rowno="0020">28/03/2023</next_hear_date><new_case_purpose rowno="0020">1000525</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">10028</court_code><case_no rowno="0021">2013/00353</case_no><trn_rcms_caseid rowno="0021">17226000006615</trn_rcms_caseid><pre_case_purpose_name rowno="0021">???? ???? </pre_case_purpose_name><pre_hear_date rowno="0021">21/02/2023</pre_hear_date><pre_case_purpose rowno="0021">1000525</pre_case_purpose><next_hear_date rowno="0021">28/03/2023</next_hear_date><new_case_purpose rowno="0021">1000525</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">10028</court_code><case_no rowno="0022">2013/00334</case_no><trn_rcms_caseid rowno="0022">15343000002730</trn_rcms_caseid><pre_case_purpose_name rowno="0022">???? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="0022">21/02/2023</pre_hear_date><pre_case_purpose rowno="0022">12555000000002</pre_case_purpose><next_hear_date rowno="0022">28/03/2023</next_hear_date><new_case_purpose rowno="0022">12555000000002</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">10028</court_code><case_no rowno="0023">2016/00069</case_no><trn_rcms_caseid rowno="0023">10446000000400</trn_rcms_caseid><pre_case_purpose_name rowno="0023">???? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="0023">21/02/2023</pre_hear_date><pre_case_purpose rowno="0023">12555000000002</pre_case_purpose><next_hear_date rowno="0023">28/03/2023</next_hear_date><new_case_purpose rowno="0023">12555000000002</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">10028</court_code><case_no rowno="0024">2016/00155</case_no><trn_rcms_caseid rowno="0024">14795000000391</trn_rcms_caseid><pre_case_purpose_name rowno="0024">???? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="0024">21/02/2023</pre_hear_date><pre_case_purpose rowno="0024">12555000000002</pre_case_purpose><next_hear_date rowno="0024">28/03/2023</next_hear_date><new_case_purpose rowno="0024">12555000000002</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">10028</court_code><case_no rowno="0025">2016/00017</case_no><trn_rcms_caseid rowno="0025">19540000000839</trn_rcms_caseid><pre_case_purpose_name rowno="0025">???????? / ???????</pre_case_purpose_name><pre_hear_date rowno="0025">21/02/2023</pre_hear_date><pre_case_purpose rowno="0025">1000490</pre_case_purpose><next_hear_date rowno="0025">28/03/2023</next_hear_date><new_case_purpose rowno="0025">1000490</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">10028</court_code><case_no rowno="0026">2003/00010</case_no><trn_rcms_caseid rowno="0026">145905</trn_rcms_caseid><pre_case_purpose_name rowno="0026">??????? ????????? ???? </pre_case_purpose_name><pre_hear_date rowno="0026">21/02/2023</pre_hear_date><pre_case_purpose rowno="0026">18469000000000</pre_case_purpose><next_hear_date rowno="0026">28/03/2023</next_hear_date><new_case_purpose rowno="0026">18469000000000</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">10028</court_code><case_no rowno="0027">2007/00026</case_no><trn_rcms_caseid rowno="0027">145608</trn_rcms_caseid><pre_case_purpose_name rowno="0027">??????? ???? </pre_case_purpose_name><pre_hear_date rowno="0027">21/02/2023</pre_hear_date><pre_case_purpose rowno="0027">18466000000000</pre_case_purpose><next_hear_date rowno="0027">28/03/2023</next_hear_date><new_case_purpose rowno="0027">18466000000000</new_case_purpose><isadjourn rowno="0027">NO</isadjourn><adjourn_type rowno="0027">0</adjourn_type><adjourn_remark rowno="0027"></adjourn_remark></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"SDO_malsisar","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"trcmf","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtcode":"10028","hearing_date":"21/02/2023"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"court_code":"10028","case_no":"2013/00297","trn_rcms_caseid":"16112000002743","pre_case_purpose_name":"????","pre_hear_date":"21/02/2023","pre_case_purpose":"18678000000000","next_hear_date":"28/03/2023","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"002","text":"0","columns":{"court_code":"10028","case_no":"2010/00051","trn_rcms_caseid":"145588","pre_case_purpose_name":"????","pre_hear_date":"21/02/2023","pre_case_purpose":"1407440000046","next_hear_date":"28/03/2023","new_case_purpose":"1407440000046","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"003","text":"0","columns":{"court_code":"10028","case_no":"2013/00304","trn_rcms_caseid":"17878000002499","pre_case_purpose_name":"????","pre_hear_date":"21/02/2023","pre_case_purpose":"1407440000046","next_hear_date":"28/03/2023","new_case_purpose":"1407440000046","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"004","text":"0","columns":{"court_code":"10028","case_no":"2016/00088","trn_rcms_caseid":"10488000000504","pre_case_purpose_name":"????","pre_hear_date":"21/02/2023","pre_case_purpose":"1407440000046","next_hear_date":"28/03/2023","new_case_purpose":"1407440000046","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"005","text":"0","columns":{"court_code":"10028","case_no":"2007/00035","trn_rcms_caseid":"145957","pre_case_purpose_name":"???????  ???? ","pre_hear_date":"21/02/2023","pre_case_purpose":"2000041","next_hear_date":"28/03/2023","new_case_purpose":"2000041","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"006","text":"0","columns":{"court_code":"10028","case_no":"2012/00160","trn_rcms_caseid":"146021","pre_case_purpose_name":"???????  ???? ","pre_hear_date":"21/02/2023","pre_case_purpose":"2000041","next_hear_date":"28/03/2023","new_case_purpose":"2000041","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"007","text":"0","columns":{"court_code":"10028","case_no":"2013/00313","trn_rcms_caseid":"11669000002992","pre_case_purpose_name":"???????  ???? ","pre_hear_date":"21/02/2023","pre_case_purpose":"2000041","next_hear_date":"28/03/2023","new_case_purpose":"2000041","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"008","text":"0","columns":{"court_code":"10028","case_no":"2016/00016","trn_rcms_caseid":"19406000000654","pre_case_purpose_name":"???????  ???? ","pre_hear_date":"21/02/2023","pre_case_purpose":"2000041","next_hear_date":"28/03/2023","new_case_purpose":"2000041","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"009","text":"0","columns":{"court_code":"10028","case_no":"2016/00024","trn_rcms_caseid":"10064000000483","pre_case_purpose_name":"???????  ???? ","pre_hear_date":"21/02/2023","pre_case_purpose":"2000041","next_hear_date":"28/03/2023","new_case_purpose":"2000041","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0010","text":"0","columns":{"court_code":"10028","case_no":"2016/00177","trn_rcms_caseid":"16535000000585","pre_case_purpose_name":"???????  ???? ","pre_hear_date":"21/02/2023","pre_case_purpose":"2000041","next_hear_date":"28/03/2023","new_case_purpose":"2000041","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0011","text":"0","columns":{"court_code":"10028","case_no":"2006/00017","trn_rcms_caseid":"145973","pre_case_purpose_name":"???? ?????","pre_hear_date":"21/02/2023","pre_case_purpose":"10663000002303","next_hear_date":"28/03/2023","new_case_purpose":"10663000002303","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0012","text":"0","columns":{"court_code":"10028","case_no":"2007/00045","trn_rcms_caseid":"14190000003400","pre_case_purpose_name":"???? ?????","pre_hear_date":"21/02/2023","pre_case_purpose":"10663000002303","next_hear_date":"28/03/2023","new_case_purpose":"10663000002303","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0013","text":"0","columns":{"court_code":"10028","case_no":"2013/00280","trn_rcms_caseid":"17471000002878","pre_case_purpose_name":"???? ?????","pre_hear_date":"21/02/2023","pre_case_purpose":"10663000002303","next_hear_date":"28/03/2023","new_case_purpose":"10663000002303","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0014","text":"0","columns":{"court_code":"10028","case_no":"2016/00074","trn_rcms_caseid":"10456000000693","pre_case_purpose_name":"???????? ????  ?????","pre_hear_date":"21/02/2023","pre_case_purpose":"10101000000665","next_hear_date":"28/03/2023","new_case_purpose":"10101000000665","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0015","text":"0","columns":{"court_code":"10028","case_no":"2013/00338","trn_rcms_caseid":"18968000002652","pre_case_purpose_name":"???","pre_hear_date":"21/02/2023","pre_case_purpose":"18473000000000","next_hear_date":"28/03/2023","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0016","text":"0","columns":{"court_code":"10028","case_no":"2016/00119","trn_rcms_caseid":"12350000000479","pre_case_purpose_name":"???","pre_hear_date":"21/02/2023","pre_case_purpose":"18473000000000","next_hear_date":"28/03/2023","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0017","text":"0","columns":{"court_code":"10028","case_no":"2016/00149","trn_rcms_caseid":"14607000000535","pre_case_purpose_name":"???","pre_hear_date":"21/02/2023","pre_case_purpose":"18473000000000","next_hear_date":"28/03/2023","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0018","text":"0","columns":{"court_code":"10028","case_no":"2016/00151","trn_rcms_caseid":"14672000000447","pre_case_purpose_name":"???","pre_hear_date":"21/02/2023","pre_case_purpose":"18473000000000","next_hear_date":"28/03/2023","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0019","text":"0","columns":{"court_code":"10028","case_no":"2016/00147","trn_rcms_caseid":"14529000000314","pre_case_purpose_name":"??? ????????? ????","pre_hear_date":"21/02/2023","pre_case_purpose":"19542000000536","next_hear_date":"28/03/2023","new_case_purpose":"19542000000536","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0020","text":"0","columns":{"court_code":"10028","case_no":"2012/00149","trn_rcms_caseid":"145949","pre_case_purpose_name":"???? ???? ","pre_hear_date":"21/02/2023","pre_case_purpose":"1000525","next_hear_date":"28/03/2023","new_case_purpose":"1000525","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0021","text":"0","columns":{"court_code":"10028","case_no":"2013/00353","trn_rcms_caseid":"17226000006615","pre_case_purpose_name":"???? ???? ","pre_hear_date":"21/02/2023","pre_case_purpose":"1000525","next_hear_date":"28/03/2023","new_case_purpose":"1000525","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0022","text":"0","columns":{"court_code":"10028","case_no":"2013/00334","trn_rcms_caseid":"15343000002730","pre_case_purpose_name":"???? ????????? ????","pre_hear_date":"21/02/2023","pre_case_purpose":"12555000000002","next_hear_date":"28/03/2023","new_case_purpose":"12555000000002","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0023","text":"0","columns":{"court_code":"10028","case_no":"2016/00069","trn_rcms_caseid":"10446000000400","pre_case_purpose_name":"???? ????????? ????","pre_hear_date":"21/02/2023","pre_case_purpose":"12555000000002","next_hear_date":"28/03/2023","new_case_purpose":"12555000000002","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0024","text":"0","columns":{"court_code":"10028","case_no":"2016/00155","trn_rcms_caseid":"14795000000391","pre_case_purpose_name":"???? ????????? ????","pre_hear_date":"21/02/2023","pre_case_purpose":"12555000000002","next_hear_date":"28/03/2023","new_case_purpose":"12555000000002","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0025","text":"0","columns":{"court_code":"10028","case_no":"2016/00017","trn_rcms_caseid":"19540000000839","pre_case_purpose_name":"???????? / ???????","pre_hear_date":"21/02/2023","pre_case_purpose":"1000490","next_hear_date":"28/03/2023","new_case_purpose":"1000490","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0026","text":"0","columns":{"court_code":"10028","case_no":"2003/00010","trn_rcms_caseid":"145905","pre_case_purpose_name":"??????? ????????? ???? ","pre_hear_date":"21/02/2023","pre_case_purpose":"18469000000000","next_hear_date":"28/03/2023","new_case_purpose":"18469000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0027","text":"0","columns":{"court_code":"10028","case_no":"2007/00026","trn_rcms_caseid":"145608","pre_case_purpose_name":"??????? ???? ","pre_hear_date":"21/02/2023","pre_case_purpose":"18466000000000","next_hear_date":"28/03/2023","new_case_purpose":"18466000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}}]}]}}
Verifying username and password
User Name : SDO_malsisar
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=sdo_malsisar
Time elapsed = 20
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 10
Result : 
Verifying completed...
Page Access Category : 
User Name : sdo_malsisar
Select sysdate as sdt from dual
Time elapsed = 6
dt=22/02/2023 14:39:33
Select sysdate as sdt from dual
Time elapsed = 6
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=sdo_malsisar
dt=22/02/2023 14:39:33
dt=22/02/2023 14:39:33
Time elapsed = 16
User Groups: court_reader
select userroles from axusergroups where groupname in ( 'court_reader' )
Time elapsed = 4
User Roles : court_reader
Loading App/User vars
reading the props xml
Step3
Sql : select props from axprops where lower(name)= :name  order by blobno

Paramval : app
ParamTYpe : c
Param List : name

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

Time elapsed = 3
Step4
axprops\stm size:4235
Step4-123456
<root updatedon="11/01/2023 17:54:47" name="app" caption="app" appverno="10.1.0.0" updusername="" updatedby="admin"><props LocalNum="705"><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=SDO_malsisar
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_malsisar
Time elapsed = 8
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{court_name})
   Calling function sqlget
   Result of sqlget = SDO, ????????,??????
   Result = SDO, ????????,??????
   Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
   Calling function firesql
username=SDO_malsisar
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_malsisar
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type})
   Calling function sqlget
   Result of sqlget = SDO
   Result = SDO
   Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
   Calling function firesql
username=SDO_malsisar
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_malsisar
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{court_name_mastid})
   Calling function sqlget
   Result of sqlget = 12118000000015
   Result = 12118000000015
   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=SDO_malsisar
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{axusersid})
   Calling function sqlget
   Result of sqlget = 3125
   Result = 3125
   Evaluating firesql({m4},{select :username as uname from dual})
   Calling function firesql
select :username as uname from dual
username=SDO_malsisar
Time elapsed = 8
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{uname})
   Calling function sqlget
   Result of sqlget = SDO_malsisar
   Result = SDO_malsisar
   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=SDO_malsisar
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{COURT_CODE})
   Calling function sqlget
   Result of sqlget = 10028
   Result = 10028
   Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
   Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{STATE_NAME})
   Calling function sqlget
   Result of sqlget = ????????
   Result = ????????
   Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=SDO_malsisar
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_malsisar
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m7},{DISTNAMEENG})
   Calling function sqlget
   Result of sqlget = Jhunjhunu
   Result = Jhunjhunu
   Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=SDO_malsisar
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_malsisar
Time elapsed = 7
   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=3125
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=3125
Time elapsed = 8
   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=SDO_malsisar
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type_mastid})
   Calling function sqlget
   Result of sqlget = 10823000000000
   Result = 10823000000000
   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=SDO_malsisar
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=SDO_malsisar
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{groupname})
   Calling function sqlget
   Result of sqlget = court_reader
   Result = court_reader
   Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
   Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({a1},{dd})
   Calling function sqlget
   Result of sqlget = 30/01/2021
   Result = 30/01/2021
   Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
   Calling function firesql
username=SDO_malsisar
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=SDO_malsisar
Time elapsed = 8
   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 = 4
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 8
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 = 5
Reading data from stream

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

Paramval : trcmf
ParamTYpe : c
Param List : name

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

Time elapsed = 6
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 = 6
select * from trn_rcms_mhearing where trn_rcms_mhearingid=0
Time elapsed = 4
select * from Axusers where 1=2
Time elapsed = 5
select distinct(fldname) from AxTempUserFields
Time elapsed = 4
select * from AxAttachWorkflow where lower(transid) = 'trcmf'
Time elapsed = 5
Step3
Sql : select props from tstructs where lower(name)= :name  order by blobno

Paramval : tchdh
ParamTYpe : c
Param List : name

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

Time elapsed = 4
Step4
tstructs\stm size:1907
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tchdh
adxinout=o
Time elapsed = 6
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 4
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 = 10028
hearing_date = 21/02/2023
time zone difference  = 0

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

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

Time elapsed = 4
RecordId = 18984000007630
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
hearing_date = 21/02/2023
courtcode = 10028
Posting record
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:34
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=21/02/2023 00:00:00
Param Type = c
courtcode=10028
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)

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

Time elapsed = 4
RecordId = 18984000007631
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
court_code = 10028
case_no = 2013/00297
trn_rcms_caseid = 16112000002743
new_case_purpose = 18678000000000
isadjourn = NO
pre_case_purpose = 18678000000000
next_hear_date = 28/03/2023
adjourn_remark = 
pre_hear_date = 21/02/2023
adjourn_type = 0
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=18984000007631
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:34
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10028
Param Type = c
case_no=2013/00297
Param Type = c
trn_rcms_caseid=16112000002743
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = c
adjourn_type=0
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,court_code,case_no,trn_rcms_caseid,new_case_purpose,isadjourn,pre_case_purpose,next_hear_date,adjourn_remark,pre_hear_date,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,:court_code,:case_no,:trn_rcms_caseid,:new_case_purpose,:isadjourn,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18984000007632
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
court_code = 10028
pre_hear_date = 21/02/2023
adjourn_type = 0
new_case_purpose = 1407440000046
pre_case_purpose = 1407440000046
trn_rcms_caseid = 145588
adjourn_remark = 
case_no = 2010/00051
isadjourn = NO
next_hear_date = 28/03/2023
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=18984000007632
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:34
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10028
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1407440000046
Param Type = n
pre_case_purpose=1407440000046
Param Type = c
trn_rcms_caseid=145588
Param Type = c
case_no=2010/00051
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=28/03/2023 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,court_code,pre_hear_date,adjourn_type,new_case_purpose,pre_case_purpose,trn_rcms_caseid,adjourn_remark,case_no,isadjourn,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,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,null,:case_no,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 5
RecordId = 18984000007633
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 28/03/2023
new_case_purpose = 1407440000046
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2013/00304
court_code = 10028
trn_rcms_caseid = 17878000002499
pre_case_purpose = 1407440000046
pre_hear_date = 21/02/2023
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=18984000007633
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:34
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
new_case_purpose=1407440000046
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2013/00304
Param Type = c
court_code=10028
Param Type = c
trn_rcms_caseid=17878000002499
Param Type = n
pre_case_purpose=1407440000046
Param Type = c
pre_hear_date=21/02/2023 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,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 = 7
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 = 5
RecordId = 18984000007634
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 28/03/2023
new_case_purpose = 1407440000046
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2016/00088
court_code = 10028
trn_rcms_caseid = 10488000000504
pre_case_purpose = 1407440000046
pre_hear_date = 21/02/2023
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=18984000007634
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:34
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
new_case_purpose=1407440000046
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2016/00088
Param Type = c
court_code=10028
Param Type = c
trn_rcms_caseid=10488000000504
Param Type = n
pre_case_purpose=1407440000046
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18984000007635
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 28/03/2023
new_case_purpose = 2000041
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2007/00035
court_code = 10028
trn_rcms_caseid = 145957
pre_case_purpose = 2000041
pre_hear_date = 21/02/2023
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=18984000007635
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:34
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
new_case_purpose=2000041
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2007/00035
Param Type = c
court_code=10028
Param Type = c
trn_rcms_caseid=145957
Param Type = n
pre_case_purpose=2000041
Param Type = c
pre_hear_date=21/02/2023 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 = 5
Adding new record to store data from Frame 2, Row 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 18984000007636
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 21/02/2023
pre_case_purpose = 2000041
trn_rcms_caseid = 146021
court_code = 10028
case_no = 2012/00160
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 2000041
next_hear_date = 28/03/2023
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=18984000007636
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:34
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = n
pre_case_purpose=2000041
Param Type = c
trn_rcms_caseid=146021
Param Type = c
court_code=10028
Param Type = c
case_no=2012/00160
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=2000041
Param Type = c
next_hear_date=28/03/2023 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 = 4
Adding new record to store data from Frame 2, Row 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 18984000007637
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_case_purpose = 2000041
court_code = 10028
pre_hear_date = 21/02/2023
case_no = 2013/00313
trn_rcms_caseid = 11669000002992
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 2000041
next_hear_date = 28/03/2023
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=18984000007637
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:34
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=2000041
Param Type = c
court_code=10028
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = c
case_no=2013/00313
Param Type = c
trn_rcms_caseid=11669000002992
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=2000041
Param Type = c
next_hear_date=28/03/2023 00:00:00
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,pre_case_purpose,court_code,pre_hear_date,case_no,trn_rcms_caseid,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,:pre_case_purpose,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18984000007638
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 28/03/2023
new_case_purpose = 2000041
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2016/00016
court_code = 10028
trn_rcms_caseid = 19406000000654
pre_case_purpose = 2000041
pre_hear_date = 21/02/2023
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=18984000007638
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:34
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
new_case_purpose=2000041
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2016/00016
Param Type = c
court_code=10028
Param Type = c
trn_rcms_caseid=19406000000654
Param Type = n
pre_case_purpose=2000041
Param Type = c
pre_hear_date=21/02/2023 00:00:00
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,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 = 6
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 = 5
RecordId = 18984000007639
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_case_purpose = 2000041
new_case_purpose = 2000041
next_hear_date = 28/03/2023
pre_hear_date = 21/02/2023
court_code = 10028
case_no = 2016/00024
trn_rcms_caseid = 10064000000483
adjourn_remark = 
adjourn_type = 0
isadjourn = NO
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=18984000007639
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:35
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=2000041
Param Type = c
new_case_purpose=2000041
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = c
court_code=10028
Param Type = c
case_no=2016/00024
Param Type = c
trn_rcms_caseid=10064000000483
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,new_case_purpose,next_hear_date,pre_hear_date,court_code,case_no,trn_rcms_caseid,adjourn_remark,adjourn_type,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,null,:adjourn_type,:isadjourn,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 18984000007640
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trn_rcms_caseid = 16535000000585
new_case_purpose = 2000041
next_hear_date = 28/03/2023
pre_case_purpose = 2000041
court_code = 10028
case_no = 2016/00177
pre_hear_date = 21/02/2023
adjourn_type = 0
isadjourn = NO
adjourn_remark = 
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=18984000007640
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:35
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=16535000000585
Param Type = c
new_case_purpose=2000041
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = n
pre_case_purpose=2000041
Param Type = c
court_code=10028
Param Type = c
case_no=2016/00177
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
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,trn_rcms_caseid,new_case_purpose,next_hear_date,pre_case_purpose,court_code,case_no,pre_hear_date,adjourn_type,isadjourn,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,:trn_rcms_caseid,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 18984000007641
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 28/03/2023
isadjourn = NO
new_case_purpose = 10663000002303
pre_hear_date = 21/02/2023
pre_case_purpose = 10663000002303
trn_rcms_caseid = 145973
court_code = 10028
adjourn_remark = 
case_no = 2006/00017
adjourn_type = 0
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=18984000007641
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:35
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=10663000002303
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = n
pre_case_purpose=10663000002303
Param Type = c
trn_rcms_caseid=145973
Param Type = c
court_code=10028
Param Type = c
case_no=2006/00017
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,new_case_purpose,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,adjourn_remark,case_no,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(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,null,:case_no,:adjourn_type,:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18984000007642
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 21/02/2023
pre_case_purpose = 10663000002303
trn_rcms_caseid = 14190000003400
court_code = 10028
case_no = 2007/00045
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 10663000002303
next_hear_date = 28/03/2023
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=18984000007642
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:35
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = n
pre_case_purpose=10663000002303
Param Type = c
trn_rcms_caseid=14190000003400
Param Type = c
court_code=10028
Param Type = c
case_no=2007/00045
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=10663000002303
Param Type = c
next_hear_date=28/03/2023 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 = 6
Adding new record to store data from Frame 2, Row 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 18984000007643
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 21/02/2023
pre_case_purpose = 10663000002303
trn_rcms_caseid = 17471000002878
court_code = 10028
case_no = 2013/00280
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 10663000002303
next_hear_date = 28/03/2023
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=18984000007643
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:35
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = n
pre_case_purpose=10663000002303
Param Type = c
trn_rcms_caseid=17471000002878
Param Type = c
court_code=10028
Param Type = c
case_no=2013/00280
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=10663000002303
Param Type = c
next_hear_date=28/03/2023 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,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 5
RecordId = 18984000007644
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
court_code = 10028
case_no = 2016/00074
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
next_hear_date = 28/03/2023
new_case_purpose = 10101000000665
pre_case_purpose = 10101000000665
trn_rcms_caseid = 10456000000693
pre_hear_date = 21/02/2023
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=18984000007644
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:35
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10028
Param Type = c
case_no=2016/00074
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
new_case_purpose=10101000000665
Param Type = n
pre_case_purpose=10101000000665
Param Type = c
trn_rcms_caseid=10456000000693
Param Type = c
pre_hear_date=21/02/2023 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,court_code,case_no,isadjourn,adjourn_remark,adjourn_type,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_caseid,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,:court_code,:case_no,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,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 = 6
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 6
RecordId = 18984000007645
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
pre_case_purpose = 18473000000000
trn_rcms_caseid = 18968000002652
court_code = 10028
pre_hear_date = 21/02/2023
new_case_purpose = 18473000000000
adjourn_type = 0
adjourn_remark = 
next_hear_date = 28/03/2023
isadjourn = NO
case_no = 2013/00338
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=18984000007645
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:35
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=18968000002652
Param Type = c
court_code=10028
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2013/00338
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_case_purpose,trn_rcms_caseid,court_code,pre_hear_date,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,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,:pre_case_purpose,:trn_rcms_caseid,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18984000007646
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 7
new_case_purpose = 18473000000000
next_hear_date = 28/03/2023
adjourn_type = 0
isadjourn = NO
adjourn_remark = 
trn_rcms_caseid = 12350000000479
court_code = 10028
pre_hear_date = 21/02/2023
case_no = 2016/00119
pre_case_purpose = 18473000000000
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=18984000007646
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:35
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:35
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=28/03/2023 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=12350000000479
Param Type = c
court_code=10028
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = c
case_no=2016/00119
Param Type = n
pre_case_purpose=18473000000000
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,new_case_purpose,next_hear_date,adjourn_type,isadjourn,adjourn_remark,trn_rcms_caseid,court_code,pre_hear_date,case_no,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:isadjourn,null,:trn_rcms_caseid,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:pre_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 18984000007647
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 21/02/2023
pre_case_purpose = 18473000000000
trn_rcms_caseid = 14607000000535
court_code = 10028
case_no = 2016/00149
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 28/03/2023
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=18984000007647
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:35
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=14607000000535
Param Type = c
court_code=10028
Param Type = c
case_no=2016/00149
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=28/03/2023 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 = 6
Adding new record to store data from Frame 2, Row 18 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 18984000007648
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark = 
trn_rcms_caseid = 14672000000447
adjourn_type = 0
court_code = 10028
case_no = 2016/00151
pre_hear_date = 21/02/2023
new_case_purpose = 18473000000000
next_hear_date = 28/03/2023
pre_case_purpose = 18473000000000
isadjourn = NO
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=18984000007648
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:35
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=14672000000447
Param Type = c
adjourn_type=0
Param Type = c
court_code=10028
Param Type = c
case_no=2016/00151
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,adjourn_type,court_code,case_no,pre_hear_date,new_case_purpose,next_hear_date,pre_case_purpose,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,null,:trn_rcms_caseid,:adjourn_type,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:isadjourn,:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18984000007649
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark = 
trn_rcms_caseid = 14529000000314
pre_hear_date = 21/02/2023
court_code = 10028
case_no = 2016/00147
pre_case_purpose = 19542000000536
isadjourn = NO
adjourn_type = 0
new_case_purpose = 19542000000536
next_hear_date = 28/03/2023
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=18984000007649
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:36
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=14529000000314
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = c
court_code=10028
Param Type = c
case_no=2016/00147
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=19542000000536
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_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 = 6
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 = 4
RecordId = 18984000007650
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 145949
pre_hear_date = 21/02/2023
court_code = 10028
case_no = 2012/00149
next_hear_date = 28/03/2023
isadjourn = NO
pre_case_purpose = 1000525
new_case_purpose = 1000525
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=18984000007650
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:36
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=145949
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = c
court_code=10028
Param Type = c
case_no=2012/00149
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=1000525
Param Type = c
new_case_purpose=1000525
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,adjourn_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18984000007651
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 17226000006615
case_no = 2013/00353
new_case_purpose = 1000525
pre_hear_date = 21/02/2023
next_hear_date = 28/03/2023
isadjourn = NO
court_code = 10028
pre_case_purpose = 1000525
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=18984000007651
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:36
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=17226000006615
Param Type = c
case_no=2013/00353
Param Type = c
new_case_purpose=1000525
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
court_code=10028
Param Type = n
pre_case_purpose=1000525
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_type,adjourn_remark,trn_rcms_caseid,case_no,new_case_purpose,pre_hear_date,next_hear_date,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,:adjourn_type,null,:trn_rcms_caseid,:case_no,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 7
RecordId = 18984000007652
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
trn_rcms_caseid = 15343000002730
case_no = 2013/00334
court_code = 10028
pre_hear_date = 21/02/2023
next_hear_date = 28/03/2023
new_case_purpose = 12555000000002
pre_case_purpose = 12555000000002
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=18984000007652
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:36
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:36
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=15343000002730
Param Type = c
case_no=2013/00334
Param Type = c
court_code=10028
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = n
pre_case_purpose=12555000000002
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_type,adjourn_remark,isadjourn,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,:adjourn_type,null,:isadjourn,: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 = 6
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 18984000007653
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = NO
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 10446000000400
case_no = 2016/00069
court_code = 10028
pre_hear_date = 21/02/2023
next_hear_date = 28/03/2023
new_case_purpose = 12555000000002
pre_case_purpose = 12555000000002
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=18984000007653
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:36
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:36
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=10446000000400
Param Type = c
case_no=2016/00069
Param Type = c
court_code=10028
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = n
pre_case_purpose=12555000000002
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,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 18984000007654
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
next_hear_date = 28/03/2023
case_no = 2016/00155
court_code = 10028
trn_rcms_caseid = 14795000000391
new_case_purpose = 12555000000002
pre_case_purpose = 12555000000002
pre_hear_date = 21/02/2023
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=18984000007654
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:36
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:36
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=28/03/2023 00:00:00
Param Type = c
case_no=2016/00155
Param Type = c
court_code=10028
Param Type = c
trn_rcms_caseid=14795000000391
Param Type = c
new_case_purpose=12555000000002
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
pre_hear_date=21/02/2023 00:00:00
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 5
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 18984000007655
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 28/03/2023
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 19540000000839
case_no = 2016/00017
court_code = 10028
new_case_purpose = 1000490
pre_case_purpose = 1000490
pre_hear_date = 21/02/2023
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=18984000007655
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:36
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=19540000000839
Param Type = c
case_no=2016/00017
Param Type = c
court_code=10028
Param Type = c
new_case_purpose=1000490
Param Type = n
pre_case_purpose=1000490
Param Type = c
pre_hear_date=21/02/2023 00:00:00
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,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 = 7
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 = 5
RecordId = 18984000007656
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 28/03/2023
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 18469000000000
case_no = 2003/00010
court_code = 10028
trn_rcms_caseid = 145905
pre_case_purpose = 18469000000000
pre_hear_date = 21/02/2023
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=18984000007656
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:36
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18469000000000
Param Type = c
case_no=2003/00010
Param Type = c
court_code=10028
Param Type = c
trn_rcms_caseid=145905
Param Type = n
pre_case_purpose=18469000000000
Param Type = c
pre_hear_date=21/02/2023 00:00:00
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,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 5
RecordId = 18984000007657
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 28/03/2023
new_case_purpose = 18466000000000
adjourn_remark = 
adjourn_type = 0
isadjourn = NO
case_no = 2007/00026
court_code = 10028
trn_rcms_caseid = 145608
pre_case_purpose = 18466000000000
pre_hear_date = 21/02/2023
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=18984000007657
Param Type = n
trn_rcms_mhearingid=18984000007630
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:36
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/03/2023 00:00:00
Param Type = c
new_case_purpose=18466000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2007/00026
Param Type = c
court_code=10028
Param Type = c
trn_rcms_caseid=145608
Param Type = n
pre_case_purpose=18466000000000
Param Type = c
pre_hear_date=21/02/2023 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,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 = 3886238352388

>>Executing genmaps

>>Posting from trcmf to tchdh from row 1

>>Mapping
Mapped court_code Row = 1 value = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16112000002743 idvalue 0
Mapped case_no Row = 1 value = 2013/00297 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 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 = 28/03/2023 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 = 10028
trn_rcms_caseregid = 16112000002743
case_no = 2013/00297
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 4
RecordId = 18984000007658
MapName trcmf1
SourceId 18984000007631
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 28/03/2023
case_no = 2013/00297
trn_rcms_caseregid = 16112000002743
court_code = 10028
case_purpose = 18678000000000
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007658
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007631
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:37
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:37
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=28/03/2023 00:00:00
Param Type = c
case_no=2013/00297
Param Type = c
trn_rcms_caseregid=16112000002743
Param Type = c
court_code=10028
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 145588 idvalue 0
Mapped case_no Row = 1 value = 2010/00051 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 1407440000046 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 145588
case_no = 2010/00051
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 3
RecordId = 18984000007659
MapName trcmf1
SourceId 18984000007632
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1407440000046
hearing_date = 28/03/2023
case_no = 2010/00051
trn_rcms_caseregid = 145588
court_code = 10028
case_purpose = 1407440000046
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007659
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007632
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:37
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:37
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=1407440000046
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2010/00051
Param Type = c
trn_rcms_caseregid=145588
Param Type = c
court_code=10028
Param Type = c
case_purpose=1407440000046
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17878000002499 idvalue 0
Mapped case_no Row = 1 value = 2013/00304 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 1407440000046 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 17878000002499
case_no = 2013/00304
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 1407440000046
case_purpose = 1407440000046
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 18984000007660
MapName trcmf1
SourceId 18984000007633
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1407440000046
hearing_date = 28/03/2023
case_no = 2013/00304
trn_rcms_caseregid = 17878000002499
court_code = 10028
case_purpose = 1407440000046
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007660
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007633
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:37
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:37
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=1407440000046
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2013/00304
Param Type = c
trn_rcms_caseregid=17878000002499
Param Type = c
court_code=10028
Param Type = c
case_purpose=1407440000046
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10488000000504 idvalue 0
Mapped case_no Row = 1 value = 2016/00088 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 1407440000046 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 10488000000504
case_no = 2016/00088
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 1407440000046
case_purpose = 1407440000046
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 18984000007661
MapName trcmf1
SourceId 18984000007634
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1407440000046
hearing_date = 28/03/2023
case_no = 2016/00088
trn_rcms_caseregid = 10488000000504
court_code = 10028
case_purpose = 1407440000046
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007661
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007634
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:37
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:37
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=1407440000046
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2016/00088
Param Type = c
trn_rcms_caseregid=10488000000504
Param Type = c
court_code=10028
Param Type = c
case_purpose=1407440000046
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 145957 idvalue 0
Mapped case_no Row = 1 value = 2007/00035 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????  ????  idvalue 0
Mapped case_purpose Row = 1 value = 2000041 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 145957
case_no = 2007/00035
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???????  ???? 
prev_case_purpose = 
prev_case_purposename=???????  ???? 
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 4
RecordId = 18984000007662
MapName trcmf1
SourceId 18984000007635
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 2000041
hearing_date = 28/03/2023
case_no = 2007/00035
trn_rcms_caseregid = 145957
court_code = 10028
case_purpose = 2000041
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007662
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007635
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:37
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:37
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=2000041
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2007/00035
Param Type = c
trn_rcms_caseregid=145957
Param Type = c
court_code=10028
Param Type = c
case_purpose=2000041
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 146021 idvalue 0
Mapped case_no Row = 1 value = 2012/00160 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????  ????  idvalue 0
Mapped case_purpose Row = 1 value = 2000041 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 146021
case_no = 2012/00160
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???????  ???? 
prev_case_purpose = 
prev_case_purpose after validation = 2000041
case_purpose = 2000041
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 = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 18984000007663
MapName trcmf1
SourceId 18984000007636
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 2000041
hearing_date = 28/03/2023
case_no = 2012/00160
trn_rcms_caseregid = 146021
court_code = 10028
case_purpose = 2000041
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007663
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007636
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:37
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:37
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=2000041
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2012/00160
Param Type = c
trn_rcms_caseregid=146021
Param Type = c
court_code=10028
Param Type = c
case_purpose=2000041
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11669000002992 idvalue 0
Mapped case_no Row = 1 value = 2013/00313 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????  ????  idvalue 0
Mapped case_purpose Row = 1 value = 2000041 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 11669000002992
case_no = 2013/00313
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???????  ???? 
prev_case_purpose = 
prev_case_purpose after validation = 2000041
case_purpose = 2000041
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 18984000007664
MapName trcmf1
SourceId 18984000007637
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 2000041
hearing_date = 28/03/2023
case_no = 2013/00313
trn_rcms_caseregid = 11669000002992
court_code = 10028
case_purpose = 2000041
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007664
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007637
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:38
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:38
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=2000041
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2013/00313
Param Type = c
trn_rcms_caseregid=11669000002992
Param Type = c
court_code=10028
Param Type = c
case_purpose=2000041
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19406000000654 idvalue 0
Mapped case_no Row = 1 value = 2016/00016 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????  ????  idvalue 0
Mapped case_purpose Row = 1 value = 2000041 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 19406000000654
case_no = 2016/00016
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???????  ???? 
prev_case_purpose = 
prev_case_purpose after validation = 2000041
case_purpose = 2000041
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18984000007665
MapName trcmf1
SourceId 18984000007638
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 2000041
hearing_date = 28/03/2023
case_no = 2016/00016
trn_rcms_caseregid = 19406000000654
court_code = 10028
case_purpose = 2000041
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007665
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007638
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:38
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:38
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=2000041
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2016/00016
Param Type = c
trn_rcms_caseregid=19406000000654
Param Type = c
court_code=10028
Param Type = c
case_purpose=2000041
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10064000000483 idvalue 0
Mapped case_no Row = 1 value = 2016/00024 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????  ????  idvalue 0
Mapped case_purpose Row = 1 value = 2000041 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 10064000000483
case_no = 2016/00024
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???????  ???? 
prev_case_purpose = 
prev_case_purpose after validation = 2000041
case_purpose = 2000041
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 18984000007666
MapName trcmf1
SourceId 18984000007639
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 2000041
hearing_date = 28/03/2023
case_no = 2016/00024
trn_rcms_caseregid = 10064000000483
court_code = 10028
case_purpose = 2000041
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007666
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007639
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:38
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:38
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=2000041
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2016/00024
Param Type = c
trn_rcms_caseregid=10064000000483
Param Type = c
court_code=10028
Param Type = c
case_purpose=2000041
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16535000000585 idvalue 0
Mapped case_no Row = 1 value = 2016/00177 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????  ????  idvalue 0
Mapped case_purpose Row = 1 value = 2000041 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 16535000000585
case_no = 2016/00177
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???????  ???? 
prev_case_purpose = 
prev_case_purpose after validation = 2000041
case_purpose = 2000041
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18984000007667
MapName trcmf1
SourceId 18984000007640
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 2000041
hearing_date = 28/03/2023
case_no = 2016/00177
trn_rcms_caseregid = 16535000000585
court_code = 10028
case_purpose = 2000041
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007667
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007640
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:38
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:38
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=2000041
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2016/00177
Param Type = c
trn_rcms_caseregid=16535000000585
Param Type = c
court_code=10028
Param Type = c
case_purpose=2000041
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 145973 idvalue 0
Mapped case_no Row = 1 value = 2006/00017 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 10663000002303 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 145973
case_no = 2006/00017
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???? ?????
prev_case_purpose = 
prev_case_purposename=???? ?????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 4
RecordId = 18984000007668
MapName trcmf1
SourceId 18984000007641
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 10663000002303
hearing_date = 28/03/2023
case_no = 2006/00017
trn_rcms_caseregid = 145973
court_code = 10028
case_purpose = 10663000002303
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007668
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007641
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:38
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10663000002303
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2006/00017
Param Type = c
trn_rcms_caseregid=145973
Param Type = c
court_code=10028
Param Type = c
case_purpose=10663000002303
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14190000003400 idvalue 0
Mapped case_no Row = 1 value = 2007/00045 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 10663000002303 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 14190000003400
case_no = 2007/00045
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???? ?????
prev_case_purpose = 
prev_case_purpose after validation = 10663000002303
case_purpose = 10663000002303
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18984000007669
MapName trcmf1
SourceId 18984000007642
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 10663000002303
hearing_date = 28/03/2023
case_no = 2007/00045
trn_rcms_caseregid = 14190000003400
court_code = 10028
case_purpose = 10663000002303
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007669
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007642
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:38
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10663000002303
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2007/00045
Param Type = c
trn_rcms_caseregid=14190000003400
Param Type = c
court_code=10028
Param Type = c
case_purpose=10663000002303
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17471000002878 idvalue 0
Mapped case_no Row = 1 value = 2013/00280 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? idvalue 0
Mapped case_purpose Row = 1 value = 10663000002303 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 17471000002878
case_no = 2013/00280
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???? ?????
prev_case_purpose = 
prev_case_purpose after validation = 10663000002303
case_purpose = 10663000002303
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18984000007670
MapName trcmf1
SourceId 18984000007643
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 10663000002303
hearing_date = 28/03/2023
case_no = 2013/00280
trn_rcms_caseregid = 17471000002878
court_code = 10028
case_purpose = 10663000002303
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007670
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007643
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:38
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10663000002303
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2013/00280
Param Type = c
trn_rcms_caseregid=17471000002878
Param Type = c
court_code=10028
Param Type = c
case_purpose=10663000002303
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10456000000693 idvalue 0
Mapped case_no Row = 1 value = 2016/00074 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????  ????? idvalue 0
Mapped case_purpose Row = 1 value = 10101000000665 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 10456000000693
case_no = 2016/00074
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???????? ????  ?????
prev_case_purpose = 
prev_case_purposename=???????? ????  ?????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 4
RecordId = 18984000007671
MapName trcmf1
SourceId 18984000007644
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 10101000000665
hearing_date = 28/03/2023
case_no = 2016/00074
trn_rcms_caseregid = 10456000000693
court_code = 10028
case_purpose = 10101000000665
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007671
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007644
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:39
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:39
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=10101000000665
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2016/00074
Param Type = c
trn_rcms_caseregid=10456000000693
Param Type = c
court_code=10028
Param Type = c
case_purpose=10101000000665
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18968000002652 idvalue 0
Mapped case_no Row = 1 value = 2013/00338 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 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 = 28/03/2023 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 = 10028
trn_rcms_caseregid = 18968000002652
case_no = 2013/00338
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purposename=???
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=???
Time elapsed = 5
prev_case_purpose after validation = 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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 18984000007672
MapName trcmf1
SourceId 18984000007645
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 28/03/2023
case_no = 2013/00338
trn_rcms_caseregid = 18968000002652
court_code = 10028
case_purpose = 18473000000000
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007672
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007645
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:39
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:39
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=28/03/2023 00:00:00
Param Type = c
case_no=2013/00338
Param Type = c
trn_rcms_caseregid=18968000002652
Param Type = c
court_code=10028
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12350000000479 idvalue 0
Mapped case_no Row = 1 value = 2016/00119 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 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 = 28/03/2023 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 = 10028
trn_rcms_caseregid = 12350000000479
case_no = 2016/00119
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???
prev_case_purpose = 
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 18984000007673
MapName trcmf1
SourceId 18984000007646
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 28/03/2023
case_no = 2016/00119
trn_rcms_caseregid = 12350000000479
court_code = 10028
case_purpose = 18473000000000
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007673
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007646
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:39
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:39
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=28/03/2023 00:00:00
Param Type = c
case_no=2016/00119
Param Type = c
trn_rcms_caseregid=12350000000479
Param Type = c
court_code=10028
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14607000000535 idvalue 0
Mapped case_no Row = 1 value = 2016/00149 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 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 = 28/03/2023 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 = 10028
trn_rcms_caseregid = 14607000000535
case_no = 2016/00149
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???
prev_case_purpose = 
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 = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 18984000007674
MapName trcmf1
SourceId 18984000007647
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 28/03/2023
case_no = 2016/00149
trn_rcms_caseregid = 14607000000535
court_code = 10028
case_purpose = 18473000000000
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007674
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007647
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:39
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:39
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=28/03/2023 00:00:00
Param Type = c
case_no=2016/00149
Param Type = c
trn_rcms_caseregid=14607000000535
Param Type = c
court_code=10028
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14672000000447 idvalue 0
Mapped case_no Row = 1 value = 2016/00151 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 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 = 28/03/2023 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 = 10028
trn_rcms_caseregid = 14672000000447
case_no = 2016/00151
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???
prev_case_purpose = 
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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 18984000007675
MapName trcmf1
SourceId 18984000007648
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 28/03/2023
case_no = 2016/00151
trn_rcms_caseregid = 14672000000447
court_code = 10028
case_purpose = 18473000000000
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007675
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007648
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:39
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:39
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=28/03/2023 00:00:00
Param Type = c
case_no=2016/00151
Param Type = c
trn_rcms_caseregid=14672000000447
Param Type = c
court_code=10028
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14529000000314 idvalue 0
Mapped case_no Row = 1 value = 2016/00147 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 14529000000314
case_no = 2016/00147
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ??? ????????? ????
prev_case_purpose = 
prev_case_purposename=??? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 4
RecordId = 18984000007676
MapName trcmf1
SourceId 18984000007649
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 28/03/2023
case_no = 2016/00147
trn_rcms_caseregid = 14529000000314
court_code = 10028
case_purpose = 19542000000536
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007676
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007649
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:39
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39:39
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=19542000000536
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2016/00147
Param Type = c
trn_rcms_caseregid=14529000000314
Param Type = c
court_code=10028
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 145949 idvalue 0
Mapped case_no Row = 1 value = 2012/00149 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 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 = 28/03/2023 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 = 10028
trn_rcms_caseregid = 145949
case_no = 2012/00149
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???? ???? 
prev_case_purpose = 
prev_case_purposename=???? ???? 
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=???? ???? 
Time elapsed = 6
prev_case_purpose after validation = 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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 18984000007677
MapName trcmf1
SourceId 18984000007650
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 28/03/2023
case_no = 2012/00149
trn_rcms_caseregid = 145949
court_code = 10028
case_purpose = 1000525
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007677
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007650
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:40
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39: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=1000525
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2012/00149
Param Type = c
trn_rcms_caseregid=145949
Param Type = c
court_code=10028
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17226000006615 idvalue 0
Mapped case_no Row = 1 value = 2013/00353 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 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 = 28/03/2023 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 = 10028
trn_rcms_caseregid = 17226000006615
case_no = 2013/00353
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
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 = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
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 = 18984000007678
MapName trcmf1
SourceId 18984000007651
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000525
hearing_date = 28/03/2023
case_no = 2013/00353
trn_rcms_caseregid = 17226000006615
court_code = 10028
case_purpose = 1000525
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007678
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007651
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:40
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39: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=1000525
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2013/00353
Param Type = c
trn_rcms_caseregid=17226000006615
Param Type = c
court_code=10028
Param Type = c
case_purpose=1000525
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15343000002730 idvalue 0
Mapped case_no Row = 1 value = 2013/00334 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 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 = 28/03/2023 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 = 10028
trn_rcms_caseregid = 15343000002730
case_no = 2013/00334
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
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 = 4
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 18984000007679
MapName trcmf1
SourceId 18984000007652
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 28/03/2023
case_no = 2013/00334
trn_rcms_caseregid = 15343000002730
court_code = 10028
case_purpose = 12555000000002
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007679
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007652
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:40
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39: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=12555000000002
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2013/00334
Param Type = c
trn_rcms_caseregid=15343000002730
Param Type = c
court_code=10028
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10446000000400 idvalue 0
Mapped case_no Row = 1 value = 2016/00069 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 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 = 28/03/2023 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 = 10028
trn_rcms_caseregid = 10446000000400
case_no = 2016/00069
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???? ????????? ????
prev_case_purpose = 
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 18984000007680
MapName trcmf1
SourceId 18984000007653
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 28/03/2023
case_no = 2016/00069
trn_rcms_caseregid = 10446000000400
court_code = 10028
case_purpose = 12555000000002
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007680
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007653
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:40
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39: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=12555000000002
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2016/00069
Param Type = c
trn_rcms_caseregid=10446000000400
Param Type = c
court_code=10028
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14795000000391 idvalue 0
Mapped case_no Row = 1 value = 2016/00155 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 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 = 28/03/2023 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 = 10028
trn_rcms_caseregid = 14795000000391
case_no = 2016/00155
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???? ????????? ????
prev_case_purpose = 
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18984000007681
MapName trcmf1
SourceId 18984000007654
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 28/03/2023
case_no = 2016/00155
trn_rcms_caseregid = 14795000000391
court_code = 10028
case_purpose = 12555000000002
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007681
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007654
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:40
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39: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=12555000000002
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2016/00155
Param Type = c
trn_rcms_caseregid=14795000000391
Param Type = c
court_code=10028
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19540000000839 idvalue 0
Mapped case_no Row = 1 value = 2016/00017 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? / ??????? idvalue 0
Mapped case_purpose Row = 1 value = 1000490 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 19540000000839
case_no = 2016/00017
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ???????? / ???????
prev_case_purpose = 
prev_case_purposename=???????? / ???????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 3
RecordId = 18984000007682
MapName trcmf1
SourceId 18984000007655
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000490
hearing_date = 28/03/2023
case_no = 2016/00017
trn_rcms_caseregid = 19540000000839
court_code = 10028
case_purpose = 1000490
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007682
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007655
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:40
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39: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=1000490
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2016/00017
Param Type = c
trn_rcms_caseregid=19540000000839
Param Type = c
court_code=10028
Param Type = c
case_purpose=1000490
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 145905 idvalue 0
Mapped case_no Row = 1 value = 2003/00010 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????????? ????  idvalue 0
Mapped case_purpose Row = 1 value = 18469000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 145905
case_no = 2003/00010
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ??????? ????????? ???? 
prev_case_purpose = 
prev_case_purposename=??????? ????????? ???? 
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 3
RecordId = 18984000007683
MapName trcmf1
SourceId 18984000007656
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18469000000000
hearing_date = 28/03/2023
case_no = 2003/00010
trn_rcms_caseregid = 145905
court_code = 10028
case_purpose = 18469000000000
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007683
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007656
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:40
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39: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=18469000000000
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2003/00010
Param Type = c
trn_rcms_caseregid=145905
Param Type = c
court_code=10028
Param Type = c
case_purpose=18469000000000
Param Type = c
prev_hearing_date=21/02/2023 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 = 10028 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 145608 idvalue 0
Mapped case_no Row = 1 value = 2007/00026 idvalue 0
Mapped prev_hearing_date Row = 1 value = 21/02/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????  idvalue 0
Mapped case_purpose Row = 1 value = 18466000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/03/2023 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 = 10028
trn_rcms_caseregid = 145608
case_no = 2007/00026
prev_hearing_date = 21/02/2023
hearing_date = 28/03/2023
prev_case_purposename = ??????? ???? 
prev_case_purpose = 
prev_case_purposename=??????? ???? 
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 3
RecordId = 18984000007684
MapName trcmf1
SourceId 18984000007657
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18466000000000
hearing_date = 28/03/2023
case_no = 2007/00026
trn_rcms_caseregid = 145608
court_code = 10028
case_purpose = 18466000000000
prev_hearing_date = 21/02/2023
Posting record
Param Type = n
trn_rcms_case_histid=18984000007684
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18984000007657
Param Type = c
cancel=F
Param Type = c
createdby=SDO_malsisar
Param Type = c
createdon=22/02/2023 14:39:40
Param Type = c
username=SDO_malsisar
Param Type = c
modifiedon=22/02/2023 14:39: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=18466000000000
Param Type = c
hearing_date=28/03/2023 00:00:00
Param Type = c
case_no=2007/00026
Param Type = c
trn_rcms_caseregid=145608
Param Type = c
court_code=10028
Param Type = c
case_purpose=18466000000000
Param Type = c
prev_hearing_date=21/02/2023 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 = 3886238356289
Time elapsed for MD Map = 3886238356290
Time elapsed for Save History = 3886238356291
Time elapsed for Save Attachment = 3886238356292
Time elapsed for After Save WF Exec = 3886238356294
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"18984000007630"}]}
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=SDO_malsisar
Param Type = c
calledon=22/02/2023 14:39:08
Param Type = c
callfinished=22/02/2023 14:39:16
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=7584
Param Type = n
dbtimetaken=4498
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