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_Bandikui" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>SDO_Bandikui</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">10742</courtcode><hearing_date rowno="001">06/02/2024</hearing_date><axp_recid2 rowno="001">0</axp_recid2><court_code rowno="001">10742</court_code><case_no rowno="001">2019/00572</case_no><trn_rcms_caseid rowno="001">19503000003242</trn_rcms_caseid><pre_case_purpose_name rowno="001">????</pre_case_purpose_name><pre_hear_date rowno="001">06/02/2024</pre_hear_date><pre_case_purpose rowno="001">18678000000000</pre_case_purpose><next_hear_date rowno="001">13/02/2024</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">10742</court_code><case_no rowno="002">2020/00145</case_no><trn_rcms_caseid rowno="002">16398000004870</trn_rcms_caseid><pre_case_purpose_name rowno="002">????</pre_case_purpose_name><pre_hear_date rowno="002">06/02/2024</pre_hear_date><pre_case_purpose rowno="002">18678000000000</pre_case_purpose><next_hear_date rowno="002">21/02/2024</next_hear_date><new_case_purpose rowno="002">18678000000000</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">10742</court_code><case_no rowno="003">2020/00146</case_no><trn_rcms_caseid rowno="003">16456000004203</trn_rcms_caseid><pre_case_purpose_name rowno="003">????</pre_case_purpose_name><pre_hear_date rowno="003">06/02/2024</pre_hear_date><pre_case_purpose rowno="003">18678000000000</pre_case_purpose><next_hear_date rowno="003">21/02/2024</next_hear_date><new_case_purpose rowno="003">18678000000000</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">10742</court_code><case_no rowno="004">2020/00322</case_no><trn_rcms_caseid rowno="004">10241000004507</trn_rcms_caseid><pre_case_purpose_name rowno="004">????</pre_case_purpose_name><pre_hear_date rowno="004">06/02/2024</pre_hear_date><pre_case_purpose rowno="004">18678000000000</pre_case_purpose><next_hear_date rowno="004">14/02/2024</next_hear_date><new_case_purpose rowno="004">18678000000000</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">10742</court_code><case_no rowno="005">2021/695</case_no><trn_rcms_caseid rowno="005">19519000006268</trn_rcms_caseid><pre_case_purpose_name rowno="005">????</pre_case_purpose_name><pre_hear_date rowno="005">06/02/2024</pre_hear_date><pre_case_purpose rowno="005">18678000000000</pre_case_purpose><next_hear_date rowno="005">01/03/2024</next_hear_date><new_case_purpose rowno="005">18678000000000</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">10742</court_code><case_no rowno="006">2021/731</case_no><trn_rcms_caseid rowno="006">12672000006039</trn_rcms_caseid><pre_case_purpose_name rowno="006">????</pre_case_purpose_name><pre_hear_date rowno="006">06/02/2024</pre_hear_date><pre_case_purpose rowno="006">18678000000000</pre_case_purpose><next_hear_date rowno="006">01/03/2024</next_hear_date><new_case_purpose rowno="006">18678000000000</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">10742</court_code><case_no rowno="007">2021/755</case_no><trn_rcms_caseid rowno="007">13063000006770</trn_rcms_caseid><pre_case_purpose_name rowno="007">????</pre_case_purpose_name><pre_hear_date rowno="007">06/02/2024</pre_hear_date><pre_case_purpose rowno="007">18678000000000</pre_case_purpose><next_hear_date rowno="007">01/03/2024</next_hear_date><new_case_purpose rowno="007">18678000000000</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">10742</court_code><case_no rowno="008">2021/756</case_no><trn_rcms_caseid rowno="008">13124000006036</trn_rcms_caseid><pre_case_purpose_name rowno="008">????</pre_case_purpose_name><pre_hear_date rowno="008">06/02/2024</pre_hear_date><pre_case_purpose rowno="008">18678000000000</pre_case_purpose><next_hear_date rowno="008">01/03/2024</next_hear_date><new_case_purpose rowno="008">18678000000000</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">10742</court_code><case_no rowno="009">2022/12</case_no><trn_rcms_caseid rowno="009">16554000005912</trn_rcms_caseid><pre_case_purpose_name rowno="009">????</pre_case_purpose_name><pre_hear_date rowno="009">06/02/2024</pre_hear_date><pre_case_purpose rowno="009">18678000000000</pre_case_purpose><next_hear_date rowno="009">01/03/2024</next_hear_date><new_case_purpose rowno="009">18678000000000</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">10742</court_code><case_no rowno="0010">2022/157</case_no><trn_rcms_caseid rowno="0010">11996000007593</trn_rcms_caseid><pre_case_purpose_name rowno="0010">????</pre_case_purpose_name><pre_hear_date rowno="0010">06/02/2024</pre_hear_date><pre_case_purpose rowno="0010">18678000000000</pre_case_purpose><next_hear_date rowno="0010">01/03/2024</next_hear_date><new_case_purpose rowno="0010">18678000000000</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">10742</court_code><case_no rowno="0011">2022/158</case_no><trn_rcms_caseid rowno="0011">12167000006826</trn_rcms_caseid><pre_case_purpose_name rowno="0011">????</pre_case_purpose_name><pre_hear_date rowno="0011">06/02/2024</pre_hear_date><pre_case_purpose rowno="0011">18678000000000</pre_case_purpose><next_hear_date rowno="0011">01/03/2024</next_hear_date><new_case_purpose rowno="0011">18678000000000</new_case_purpose><isadjourn rowno="0011">NO</isadjourn><adjourn_type rowno="0011">0</adjourn_type><adjourn_remark rowno="0011"></adjourn_remark><axp_recid2 rowno="0012">0</axp_recid2><court_code rowno="0012">10742</court_code><case_no rowno="0012">2022/427</case_no><trn_rcms_caseid rowno="0012">10813000006652</trn_rcms_caseid><pre_case_purpose_name rowno="0012">????</pre_case_purpose_name><pre_hear_date rowno="0012">06/02/2024</pre_hear_date><pre_case_purpose rowno="0012">18678000000000</pre_case_purpose><next_hear_date rowno="0012">28/02/2024</next_hear_date><new_case_purpose rowno="0012">18678000000000</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">10742</court_code><case_no rowno="0013">2022/428</case_no><trn_rcms_caseid rowno="0013">10830000007726</trn_rcms_caseid><pre_case_purpose_name rowno="0013">????</pre_case_purpose_name><pre_hear_date rowno="0013">06/02/2024</pre_hear_date><pre_case_purpose rowno="0013">18678000000000</pre_case_purpose><next_hear_date rowno="0013">28/02/2024</next_hear_date><new_case_purpose rowno="0013">18678000000000</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">10742</court_code><case_no rowno="0014">2022/464</case_no><trn_rcms_caseid rowno="0014">10202000007984</trn_rcms_caseid><pre_case_purpose_name rowno="0014">????</pre_case_purpose_name><pre_hear_date rowno="0014">06/02/2024</pre_hear_date><pre_case_purpose rowno="0014">18678000000000</pre_case_purpose><next_hear_date rowno="0014">07/02/2024</next_hear_date><new_case_purpose rowno="0014">18678000000000</new_case_purpose><isadjourn rowno="0014">NO</isadjourn><adjourn_type rowno="0014">0</adjourn_type><adjourn_remark rowno="0014"></adjourn_remark><axp_recid2 rowno="0015">0</axp_recid2><court_code rowno="0015">10742</court_code><case_no rowno="0015">2022/465</case_no><trn_rcms_caseid rowno="0015">10267000006171</trn_rcms_caseid><pre_case_purpose_name rowno="0015">????</pre_case_purpose_name><pre_hear_date rowno="0015">06/02/2024</pre_hear_date><pre_case_purpose rowno="0015">18678000000000</pre_case_purpose><next_hear_date rowno="0015">07/02/2024</next_hear_date><new_case_purpose rowno="0015">18678000000000</new_case_purpose><isadjourn rowno="0015">NO</isadjourn><adjourn_type rowno="0015">0</adjourn_type><adjourn_remark rowno="0015"></adjourn_remark><axp_recid2 rowno="0016">0</axp_recid2><court_code rowno="0016">10742</court_code><case_no rowno="0016">2022/694</case_no><trn_rcms_caseid rowno="0016">18909000006722</trn_rcms_caseid><pre_case_purpose_name rowno="0016">????</pre_case_purpose_name><pre_hear_date rowno="0016">06/02/2024</pre_hear_date><pre_case_purpose rowno="0016">18678000000000</pre_case_purpose><next_hear_date rowno="0016">01/03/2024</next_hear_date><new_case_purpose rowno="0016">18678000000000</new_case_purpose><isadjourn rowno="0016">NO</isadjourn><adjourn_type rowno="0016">0</adjourn_type><adjourn_remark rowno="0016"></adjourn_remark><axp_recid2 rowno="0017">0</axp_recid2><court_code rowno="0017">10742</court_code><case_no rowno="0017">2022/725</case_no><trn_rcms_caseid rowno="0017">18718000007286</trn_rcms_caseid><pre_case_purpose_name rowno="0017">????</pre_case_purpose_name><pre_hear_date rowno="0017">06/02/2024</pre_hear_date><pre_case_purpose rowno="0017">18678000000000</pre_case_purpose><next_hear_date rowno="0017">28/02/2024</next_hear_date><new_case_purpose rowno="0017">18678000000000</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">10742</court_code><case_no rowno="0018">2022/726</case_no><trn_rcms_caseid rowno="0018">18755000008497</trn_rcms_caseid><pre_case_purpose_name rowno="0018">????</pre_case_purpose_name><pre_hear_date rowno="0018">06/02/2024</pre_hear_date><pre_case_purpose rowno="0018">18678000000000</pre_case_purpose><next_hear_date rowno="0018">28/02/2024</next_hear_date><new_case_purpose rowno="0018">18678000000000</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">10742</court_code><case_no rowno="0019">2023/125</case_no><trn_rcms_caseid rowno="0019">16581000007778</trn_rcms_caseid><pre_case_purpose_name rowno="0019">????</pre_case_purpose_name><pre_hear_date rowno="0019">06/02/2024</pre_hear_date><pre_case_purpose rowno="0019">18678000000000</pre_case_purpose><next_hear_date rowno="0019">28/02/2024</next_hear_date><new_case_purpose rowno="0019">18678000000000</new_case_purpose><isadjourn rowno="0019">NO</isadjourn><adjourn_type rowno="0019">0</adjourn_type><adjourn_remark rowno="0019"></adjourn_remark><axp_recid2 rowno="0020">0</axp_recid2><court_code rowno="0020">10742</court_code><case_no rowno="0020">2023/165</case_no><trn_rcms_caseid rowno="0020">12747000007246</trn_rcms_caseid><pre_case_purpose_name rowno="0020">????</pre_case_purpose_name><pre_hear_date rowno="0020">06/02/2024</pre_hear_date><pre_case_purpose rowno="0020">18678000000000</pre_case_purpose><next_hear_date rowno="0020">01/03/2024</next_hear_date><new_case_purpose rowno="0020">18678000000000</new_case_purpose><isadjourn rowno="0020">NO</isadjourn><adjourn_type rowno="0020">0</adjourn_type><adjourn_remark rowno="0020"></adjourn_remark><axp_recid2 rowno="0021">0</axp_recid2><court_code rowno="0021">10742</court_code><case_no rowno="0021">2023/169</case_no><trn_rcms_caseid rowno="0021">13051000007204</trn_rcms_caseid><pre_case_purpose_name rowno="0021">????</pre_case_purpose_name><pre_hear_date rowno="0021">06/02/2024</pre_hear_date><pre_case_purpose rowno="0021">18678000000000</pre_case_purpose><next_hear_date rowno="0021">01/03/2024</next_hear_date><new_case_purpose rowno="0021">18678000000000</new_case_purpose><isadjourn rowno="0021">NO</isadjourn><adjourn_type rowno="0021">0</adjourn_type><adjourn_remark rowno="0021"></adjourn_remark><axp_recid2 rowno="0022">0</axp_recid2><court_code rowno="0022">10742</court_code><case_no rowno="0022">2023/219</case_no><trn_rcms_caseid rowno="0022">10985000007970</trn_rcms_caseid><pre_case_purpose_name rowno="0022">????</pre_case_purpose_name><pre_hear_date rowno="0022">06/02/2024</pre_hear_date><pre_case_purpose rowno="0022">18678000000000</pre_case_purpose><next_hear_date rowno="0022">12/02/2024</next_hear_date><new_case_purpose rowno="0022">18678000000000</new_case_purpose><isadjourn rowno="0022">NO</isadjourn><adjourn_type rowno="0022">0</adjourn_type><adjourn_remark rowno="0022"></adjourn_remark><axp_recid2 rowno="0023">0</axp_recid2><court_code rowno="0023">10742</court_code><case_no rowno="0023">2023/220</case_no><trn_rcms_caseid rowno="0023">11042000007366</trn_rcms_caseid><pre_case_purpose_name rowno="0023">????</pre_case_purpose_name><pre_hear_date rowno="0023">06/02/2024</pre_hear_date><pre_case_purpose rowno="0023">18678000000000</pre_case_purpose><next_hear_date rowno="0023">12/02/2024</next_hear_date><new_case_purpose rowno="0023">18678000000000</new_case_purpose><isadjourn rowno="0023">NO</isadjourn><adjourn_type rowno="0023">0</adjourn_type><adjourn_remark rowno="0023"></adjourn_remark><axp_recid2 rowno="0024">0</axp_recid2><court_code rowno="0024">10742</court_code><case_no rowno="0024">2023/363</case_no><trn_rcms_caseid rowno="0024">13311000009673</trn_rcms_caseid><pre_case_purpose_name rowno="0024">????</pre_case_purpose_name><pre_hear_date rowno="0024">06/02/2024</pre_hear_date><pre_case_purpose rowno="0024">18678000000000</pre_case_purpose><next_hear_date rowno="0024">15/02/2024</next_hear_date><new_case_purpose rowno="0024">18678000000000</new_case_purpose><isadjourn rowno="0024">NO</isadjourn><adjourn_type rowno="0024">0</adjourn_type><adjourn_remark rowno="0024"></adjourn_remark><axp_recid2 rowno="0025">0</axp_recid2><court_code rowno="0025">10742</court_code><case_no rowno="0025">2023/364</case_no><trn_rcms_caseid rowno="0025">13384000008470</trn_rcms_caseid><pre_case_purpose_name rowno="0025">????</pre_case_purpose_name><pre_hear_date rowno="0025">06/02/2024</pre_hear_date><pre_case_purpose rowno="0025">18678000000000</pre_case_purpose><next_hear_date rowno="0025">15/02/2024</next_hear_date><new_case_purpose rowno="0025">18678000000000</new_case_purpose><isadjourn rowno="0025">NO</isadjourn><adjourn_type rowno="0025">0</adjourn_type><adjourn_remark rowno="0025"></adjourn_remark><axp_recid2 rowno="0026">0</axp_recid2><court_code rowno="0026">10742</court_code><case_no rowno="0026">2023/389</case_no><trn_rcms_caseid rowno="0026">10420000007541</trn_rcms_caseid><pre_case_purpose_name rowno="0026">????</pre_case_purpose_name><pre_hear_date rowno="0026">06/02/2024</pre_hear_date><pre_case_purpose rowno="0026">18678000000000</pre_case_purpose><next_hear_date rowno="0026">01/03/2024</next_hear_date><new_case_purpose rowno="0026">18678000000000</new_case_purpose><isadjourn rowno="0026">NO</isadjourn><adjourn_type rowno="0026">0</adjourn_type><adjourn_remark rowno="0026"></adjourn_remark><axp_recid2 rowno="0027">0</axp_recid2><court_code rowno="0027">10742</court_code><case_no rowno="0027">2023/61</case_no><trn_rcms_caseid rowno="0027">18070000007053</trn_rcms_caseid><pre_case_purpose_name rowno="0027">????</pre_case_purpose_name><pre_hear_date rowno="0027">06/02/2024</pre_hear_date><pre_case_purpose rowno="0027">18678000000000</pre_case_purpose><next_hear_date rowno="0027">28/02/2024</next_hear_date><new_case_purpose rowno="0027">18678000000000</new_case_purpose><isadjourn rowno="0027">NO</isadjourn><adjourn_type rowno="0027">0</adjourn_type><adjourn_remark rowno="0027"></adjourn_remark><axp_recid2 rowno="0028">0</axp_recid2><court_code rowno="0028">10742</court_code><case_no rowno="0028">2023/62</case_no><trn_rcms_caseid rowno="0028">18089000007515</trn_rcms_caseid><pre_case_purpose_name rowno="0028">????</pre_case_purpose_name><pre_hear_date rowno="0028">06/02/2024</pre_hear_date><pre_case_purpose rowno="0028">18678000000000</pre_case_purpose><next_hear_date rowno="0028">28/02/2024</next_hear_date><new_case_purpose rowno="0028">18678000000000</new_case_purpose><isadjourn rowno="0028">NO</isadjourn><adjourn_type rowno="0028">0</adjourn_type><adjourn_remark rowno="0028"></adjourn_remark><axp_recid2 rowno="0029">0</axp_recid2><court_code rowno="0029">10742</court_code><case_no rowno="0029">2023/95</case_no><trn_rcms_caseid rowno="0029">12080000007410</trn_rcms_caseid><pre_case_purpose_name rowno="0029">????</pre_case_purpose_name><pre_hear_date rowno="0029">06/02/2024</pre_hear_date><pre_case_purpose rowno="0029">18678000000000</pre_case_purpose><next_hear_date rowno="0029">28/02/2024</next_hear_date><new_case_purpose rowno="0029">18678000000000</new_case_purpose><isadjourn rowno="0029">NO</isadjourn><adjourn_type rowno="0029">0</adjourn_type><adjourn_remark rowno="0029"></adjourn_remark><axp_recid2 rowno="0030">0</axp_recid2><court_code rowno="0030">10742</court_code><case_no rowno="0030">2020/00170</case_no><trn_rcms_caseid rowno="0030">15443000005372</trn_rcms_caseid><pre_case_purpose_name rowno="0030">????????? ??????? </pre_case_purpose_name><pre_hear_date rowno="0030">06/02/2024</pre_hear_date><pre_case_purpose rowno="0030">18625000000000</pre_case_purpose><next_hear_date rowno="0030">28/02/2024</next_hear_date><new_case_purpose rowno="0030">18625000000000</new_case_purpose><isadjourn rowno="0030">NO</isadjourn><adjourn_type rowno="0030">0</adjourn_type><adjourn_remark rowno="0030"></adjourn_remark><axp_recid2 rowno="0031">0</axp_recid2><court_code rowno="0031">10742</court_code><case_no rowno="0031">2018/00530</case_no><trn_rcms_caseid rowno="0031">16509000002480</trn_rcms_caseid><pre_case_purpose_name rowno="0031">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="0031">06/02/2024</pre_hear_date><pre_case_purpose rowno="0031">1000497</pre_case_purpose><next_hear_date rowno="0031">28/02/2024</next_hear_date><new_case_purpose rowno="0031">1000497</new_case_purpose><isadjourn rowno="0031">NO</isadjourn><adjourn_type rowno="0031">0</adjourn_type><adjourn_remark rowno="0031"></adjourn_remark></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"SDO_Bandikui","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"trcmf","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtcode":"10742","hearing_date":"06/02/2024"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"court_code":"10742","case_no":"2019/00572","trn_rcms_caseid":"19503000003242","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"13/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"002","text":"0","columns":{"court_code":"10742","case_no":"2020/00145","trn_rcms_caseid":"16398000004870","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"21/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"003","text":"0","columns":{"court_code":"10742","case_no":"2020/00146","trn_rcms_caseid":"16456000004203","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"21/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"004","text":"0","columns":{"court_code":"10742","case_no":"2020/00322","trn_rcms_caseid":"10241000004507","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"14/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"005","text":"0","columns":{"court_code":"10742","case_no":"2021/695","trn_rcms_caseid":"19519000006268","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"01/03/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"006","text":"0","columns":{"court_code":"10742","case_no":"2021/731","trn_rcms_caseid":"12672000006039","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"01/03/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"007","text":"0","columns":{"court_code":"10742","case_no":"2021/755","trn_rcms_caseid":"13063000006770","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"01/03/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"008","text":"0","columns":{"court_code":"10742","case_no":"2021/756","trn_rcms_caseid":"13124000006036","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"01/03/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"009","text":"0","columns":{"court_code":"10742","case_no":"2022/12","trn_rcms_caseid":"16554000005912","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"01/03/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0010","text":"0","columns":{"court_code":"10742","case_no":"2022/157","trn_rcms_caseid":"11996000007593","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"01/03/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0011","text":"0","columns":{"court_code":"10742","case_no":"2022/158","trn_rcms_caseid":"12167000006826","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"01/03/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0012","text":"0","columns":{"court_code":"10742","case_no":"2022/427","trn_rcms_caseid":"10813000006652","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"28/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0013","text":"0","columns":{"court_code":"10742","case_no":"2022/428","trn_rcms_caseid":"10830000007726","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"28/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0014","text":"0","columns":{"court_code":"10742","case_no":"2022/464","trn_rcms_caseid":"10202000007984","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"07/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0015","text":"0","columns":{"court_code":"10742","case_no":"2022/465","trn_rcms_caseid":"10267000006171","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"07/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0016","text":"0","columns":{"court_code":"10742","case_no":"2022/694","trn_rcms_caseid":"18909000006722","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"01/03/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0017","text":"0","columns":{"court_code":"10742","case_no":"2022/725","trn_rcms_caseid":"18718000007286","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"28/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0018","text":"0","columns":{"court_code":"10742","case_no":"2022/726","trn_rcms_caseid":"18755000008497","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"28/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0019","text":"0","columns":{"court_code":"10742","case_no":"2023/125","trn_rcms_caseid":"16581000007778","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"28/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0020","text":"0","columns":{"court_code":"10742","case_no":"2023/165","trn_rcms_caseid":"12747000007246","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"01/03/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0021","text":"0","columns":{"court_code":"10742","case_no":"2023/169","trn_rcms_caseid":"13051000007204","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"01/03/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0022","text":"0","columns":{"court_code":"10742","case_no":"2023/219","trn_rcms_caseid":"10985000007970","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"12/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0023","text":"0","columns":{"court_code":"10742","case_no":"2023/220","trn_rcms_caseid":"11042000007366","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"12/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0024","text":"0","columns":{"court_code":"10742","case_no":"2023/363","trn_rcms_caseid":"13311000009673","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"15/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0025","text":"0","columns":{"court_code":"10742","case_no":"2023/364","trn_rcms_caseid":"13384000008470","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"15/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0026","text":"0","columns":{"court_code":"10742","case_no":"2023/389","trn_rcms_caseid":"10420000007541","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"01/03/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0027","text":"0","columns":{"court_code":"10742","case_no":"2023/61","trn_rcms_caseid":"18070000007053","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"28/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0028","text":"0","columns":{"court_code":"10742","case_no":"2023/62","trn_rcms_caseid":"18089000007515","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"28/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0029","text":"0","columns":{"court_code":"10742","case_no":"2023/95","trn_rcms_caseid":"12080000007410","pre_case_purpose_name":"????","pre_hear_date":"06/02/2024","pre_case_purpose":"18678000000000","next_hear_date":"28/02/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0030","text":"0","columns":{"court_code":"10742","case_no":"2020/00170","trn_rcms_caseid":"15443000005372","pre_case_purpose_name":"????????? ??????? ","pre_hear_date":"06/02/2024","pre_case_purpose":"18625000000000","next_hear_date":"28/02/2024","new_case_purpose":"18625000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0031","text":"0","columns":{"court_code":"10742","case_no":"2018/00530","trn_rcms_caseid":"16509000002480","pre_case_purpose_name":"???? ?????????","pre_hear_date":"06/02/2024","pre_case_purpose":"1000497","next_hear_date":"28/02/2024","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}}]}]}}
Verifying username and password
User Name : SDO_Bandikui
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=sdo_bandikui
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 = 8
Result : 
Verifying completed...
Page Access Category : 
User Name : sdo_bandikui
Select sysdate as sdt from dual
Time elapsed = 5
dt=07/02/2024 10:48:33
Select sysdate as sdt from dual
Time elapsed = 5
Select usergroup from AXUSERLEVELGROUPS WHERE (lower(username) =:U) and ((startdate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') >= startdate) or (startdate is null)) and ((enddate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') <= enddate) or (enddate is null))
U=sdo_bandikui
dt=07/02/2024 10:48:33
dt=07/02/2024 10:48:33
Time elapsed = 18
User Groups: court_reader
select userroles from axusergroups where groupname in ( 'court_reader' )
Time elapsed = 5
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 = 4
Step4
axprops\stm size:4235
Step4-123456
<root updatedon="06/02/2024 13:58:07" name="app" caption="app" appverno="10.1.0.0" updusername="" updatedby="admin"><props LocalNum="724"><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_Bandikui
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Bandikui
Time elapsed = 19
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{court_name})
   Calling function sqlget
   Result of sqlget = ????? ???????, ????????,???? -????
   Result = ????? ???????, ????????,???? -????
   Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
   Calling function firesql
username=SDO_Bandikui
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Bandikui
Time elapsed = 8
   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_Bandikui
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Bandikui
Time elapsed = 9
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{court_name_mastid})
   Calling function sqlget
   Result of sqlget = 18499000000012
   Result = 18499000000012
   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_Bandikui
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{axusersid})
   Calling function sqlget
   Result of sqlget = 4133
   Result = 4133
   Evaluating firesql({m4},{select :username as uname from dual})
   Calling function firesql
select :username as uname from dual
username=SDO_Bandikui
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{uname})
   Calling function sqlget
   Result of sqlget = SDO_Bandikui
   Result = SDO_Bandikui
   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_Bandikui
Time elapsed = 31
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{COURT_CODE})
   Calling function sqlget
   Result of sqlget = 10742
   Result = 10742
   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 = 6
   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_Bandikui
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Bandikui
Time elapsed = 8
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m7},{DISTNAMEENG})
   Calling function sqlget
   Result of sqlget = Dausa
   Result = Dausa
   Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=SDO_Bandikui
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Bandikui
Time elapsed = 8
   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=4133
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=4133
Time elapsed = 12
   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_Bandikui
Time elapsed = 9
   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_Bandikui
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_Bandikui
Time elapsed = 11
   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 = 9
   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_Bandikui
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_Bandikui
Time elapsed = 14
   Result of firesql = 
   Result = 
   Evaluating  sqlget({P1},{ct})
   Calling function sqlget
   Result of sqlget = 3
   Result = 3
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 = 7
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 30
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 = 7
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 = 7
select * from trn_rcms_mhearing where trn_rcms_mhearingid=0
Time elapsed = 5
select * from Axusers where 1=2
Time elapsed = 8
select distinct(fldname) from AxTempUserFields
Time elapsed = 4
select * from AxAttachWorkflow where lower(transid) = 'trcmf'
Time elapsed = 7
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 = 6
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 = 10
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 6
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 = 10742
hearing_date = 06/02/2024
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 = 16497000008086
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
hearing_date = 06/02/2024
courtcode = 10742
Posting record
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:34
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=06/02/2024 00:00:00
Param Type = c
courtcode=10742
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 = 8
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 = 16497000008087
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 13/02/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2019/00572
court_code = 10742
trn_rcms_caseid = 19503000003242
pre_case_purpose = 18678000000000
pre_hear_date = 06/02/2024
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=16497000008087
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:34
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=13/02/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2019/00572
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=19503000003242
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 16
RecordId = 16497000008088
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 21/02/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2020/00145
court_code = 10742
trn_rcms_caseid = 16398000004870
pre_case_purpose = 18678000000000
pre_hear_date = 06/02/2024
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=16497000008088
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:34
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/02/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2020/00145
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=16398000004870
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 16497000008089
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 06/02/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16456000004203
court_code = 10742
case_no = 2020/00146
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 21/02/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=16497000008089
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:34
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16456000004203
Param Type = c
court_code=10742
Param Type = c
case_no=2020/00146
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=21/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 6
RecordId = 16497000008090
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 06/02/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 10241000004507
court_code = 10742
case_no = 2020/00322
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 14/02/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=16497000008090
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:34
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=10241000004507
Param Type = c
court_code=10742
Param Type = c
case_no=2020/00322
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=14/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 16497000008091
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
next_hear_date = 01/03/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2021/695
court_code = 10742
trn_rcms_caseid = 19519000006268
pre_case_purpose = 18678000000000
pre_hear_date = 06/02/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=16497000008091
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:34
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=01/03/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/695
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=19519000006268
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 6
RecordId = 16497000008092
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 01/03/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2021/731
court_code = 10742
trn_rcms_caseid = 12672000006039
pre_case_purpose = 18678000000000
pre_hear_date = 06/02/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=16497000008092
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:34
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:34
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=01/03/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/731
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=12672000006039
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/02/2024 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,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 = 9
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 = 6
RecordId = 16497000008093
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
isadjourn = NO
next_hear_date = 01/03/2024
adjourn_type = 0
adjourn_remark = 
pre_hear_date = 06/02/2024
case_no = 2021/755
court_code = 10742
trn_rcms_caseid = 13063000006770
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=16497000008093
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:35
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=01/03/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = c
case_no=2021/755
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=13063000006770
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
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,isadjourn,next_hear_date,adjourn_type,adjourn_remark,pre_hear_date,case_no,court_code,trn_rcms_caseid,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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,: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 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 16497000008094
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
case_no = 2021/756
court_code = 10742
isadjourn = NO
next_hear_date = 01/03/2024
adjourn_remark = 
adjourn_type = 0
pre_hear_date = 06/02/2024
trn_rcms_caseid = 13124000006036
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=16497000008094
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:35
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2021/756
Param Type = c
court_code=10742
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=01/03/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = c
trn_rcms_caseid=13124000006036
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
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,case_no,court_code,isadjourn,next_hear_date,adjourn_remark,adjourn_type,pre_hear_date,trn_rcms_caseid,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,:case_no,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,: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 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 16497000008095
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 06/02/2024
trn_rcms_caseid = 16554000005912
pre_case_purpose = 18678000000000
next_hear_date = 01/03/2024
new_case_purpose = 18678000000000
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
case_no = 2022/12
court_code = 10742
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=16497000008095
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:35
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = c
trn_rcms_caseid=16554000005912
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
next_hear_date=01/03/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2022/12
Param Type = c
court_code=10742
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,pre_case_purpose,next_hear_date,new_case_purpose,adjourn_type,adjourn_remark,isadjourn,case_no,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,:isadjourn,:case_no,:court_code,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 16497000008096
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 06/02/2024
trn_rcms_caseid = 11996000007593
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
next_hear_date = 01/03/2024
adjourn_remark = 
isadjourn = NO
court_code = 10742
adjourn_type = 0
case_no = 2022/157
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=16497000008096
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:35
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = c
trn_rcms_caseid=11996000007593
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=01/03/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
court_code=10742
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/157
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,pre_hear_date,trn_rcms_caseid,pre_case_purpose,new_case_purpose,next_hear_date,adjourn_remark,isadjourn,court_code,adjourn_type,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:isadjourn,:court_code,:adjourn_type,:case_no,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 10
RecordId = 16497000008097
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 10
case_no = 2022/158
isadjourn = NO
next_hear_date = 01/03/2024
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 18678000000000
pre_hear_date = 06/02/2024
trn_rcms_caseid = 12167000006826
court_code = 10742
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=16497000008097
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:35
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2022/158
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=01/03/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = c
trn_rcms_caseid=12167000006826
Param Type = c
court_code=10742
Param Type = n
pre_case_purpose=18678000000000
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,case_no,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,pre_hear_date,trn_rcms_caseid,court_code,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 6
RecordId = 16497000008098
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 06/02/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 10813000006652
court_code = 10742
case_no = 2022/427
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 28/02/2024
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=16497000008098
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:35
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=10813000006652
Param Type = c
court_code=10742
Param Type = c
case_no=2022/427
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=28/02/2024 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 = 5
RecordId = 16497000008099
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
pre_hear_date = 06/02/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 10830000007726
court_code = 10742
case_no = 2022/428
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 28/02/2024
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=16497000008099
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:35
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=10830000007726
Param Type = c
court_code=10742
Param Type = c
case_no=2022/428
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=28/02/2024 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 = 5
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 = 16497000008100
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 14
next_hear_date = 07/02/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2022/464
court_code = 10742
trn_rcms_caseid = 10202000007984
pre_case_purpose = 18678000000000
pre_hear_date = 06/02/2024
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=16497000008100
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:35
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=07/02/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/464
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=10202000007984
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/02/2024 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,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 16497000008101
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark = 
new_case_purpose = 18678000000000
adjourn_type = 0
next_hear_date = 07/02/2024
isadjourn = NO
case_no = 2022/465
court_code = 10742
trn_rcms_caseid = 10267000006171
pre_case_purpose = 18678000000000
pre_hear_date = 06/02/2024
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=16497000008101
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:35
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=07/02/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2022/465
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=10267000006171
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,new_case_purpose,adjourn_type,next_hear_date,isadjourn,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:new_case_purpose,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 11
RecordId = 16497000008102
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 06/02/2024
trn_rcms_caseid = 18909000006722
isadjourn = NO
pre_case_purpose = 18678000000000
adjourn_type = 0
court_code = 10742
case_no = 2022/694
adjourn_remark = 
new_case_purpose = 18678000000000
next_hear_date = 01/03/2024
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=16497000008102
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:36
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = c
trn_rcms_caseid=18909000006722
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
court_code=10742
Param Type = c
case_no=2022/694
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=01/03/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,isadjourn,pre_case_purpose,adjourn_type,court_code,case_no,adjourn_remark,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:isadjourn,:pre_case_purpose,:adjourn_type,:court_code,:case_no,null,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 8
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 = 5
RecordId = 16497000008103
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_type = 0
next_hear_date = 28/02/2024
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
pre_hear_date = 06/02/2024
case_no = 2022/725
adjourn_remark = 
trn_rcms_caseid = 18718000007286
court_code = 10742
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=16497000008103
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:36
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48: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/02/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = c
case_no=2022/725
Param Type = c
trn_rcms_caseid=18718000007286
Param Type = c
court_code=10742
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,isadjourn,adjourn_type,next_hear_date,pre_case_purpose,new_case_purpose,pre_hear_date,case_no,adjourn_remark,trn_rcms_caseid,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,null,:trn_rcms_caseid,:court_code,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 7
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 = 6
RecordId = 16497000008104
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 06/02/2024
pre_case_purpose = 18678000000000
trn_rcms_caseid = 18755000008497
court_code = 10742
case_no = 2022/726
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 28/02/2024
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=16497000008104
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:36
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=18755000008497
Param Type = c
court_code=10742
Param Type = c
case_no=2022/726
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 16
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 = 16497000008105
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 13
next_hear_date = 28/02/2024
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2023/125
court_code = 10742
trn_rcms_caseid = 16581000007778
pre_case_purpose = 18678000000000
pre_hear_date = 06/02/2024
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=16497000008105
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:36
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/125
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=16581000007778
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 16497000008106
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2023/165
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
trn_rcms_caseid = 12747000007246
pre_hear_date = 06/02/2024
adjourn_remark = 
court_code = 10742
adjourn_type = 0
next_hear_date = 01/03/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=16497000008106
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:36
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/165
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=12747000007246
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = c
court_code=10742
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=01/03/2024 00:00:00
Param Type = c
isadjourn=NO
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,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 16497000008107
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 06/02/2024
adjourn_remark = 
trn_rcms_caseid = 13051000007204
court_code = 10742
case_no = 2023/169
next_hear_date = 01/03/2024
isadjourn = NO
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
adjourn_type = 0
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=16497000008107
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:36
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = c
trn_rcms_caseid=13051000007204
Param Type = c
court_code=10742
Param Type = c
case_no=2023/169
Param Type = c
next_hear_date=01/03/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,adjourn_remark,trn_rcms_caseid,court_code,case_no,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:trn_rcms_caseid,:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,:adjourn_type,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 6
RecordId = 16497000008108
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 7
adjourn_remark = 
trn_rcms_caseid = 10985000007970
pre_hear_date = 06/02/2024
court_code = 10742
case_no = 2023/219
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 12/02/2024
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=16497000008108
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:36
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=10985000007970
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = c
court_code=10742
Param Type = c
case_no=2023/219
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=12/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 5
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 16497000008109
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_remark = 
trn_rcms_caseid = 11042000007366
pre_hear_date = 06/02/2024
court_code = 10742
case_no = 2023/220
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 12/02/2024
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=16497000008109
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:36
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=11042000007366
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = c
court_code=10742
Param Type = c
case_no=2023/220
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=12/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 16497000008110
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 13311000009673
case_no = 2023/363
pre_hear_date = 06/02/2024
next_hear_date = 15/02/2024
new_case_purpose = 18678000000000
isadjourn = NO
court_code = 10742
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=16497000008110
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:36
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48: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=13311000009673
Param Type = c
case_no=2023/363
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = c
next_hear_date=15/02/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
court_code=10742
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,case_no,pre_hear_date,next_hear_date,new_case_purpose,isadjourn,court_code,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 10
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 = 9
RecordId = 16497000008111
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 13384000008470
pre_hear_date = 06/02/2024
court_code = 10742
case_no = 2023/364
next_hear_date = 15/02/2024
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=16497000008111
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:37
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13384000008470
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = c
court_code=10742
Param Type = c
case_no=2023/364
Param Type = c
next_hear_date=15/02/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 16497000008112
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 7
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
trn_rcms_caseid = 10420000007541
pre_hear_date = 06/02/2024
pre_case_purpose = 18678000000000
case_no = 2023/389
next_hear_date = 01/03/2024
new_case_purpose = 18678000000000
court_code = 10742
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=16497000008112
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:37
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:37
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=10420000007541
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2023/389
Param Type = c
next_hear_date=01/03/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
court_code=10742
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,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,next_hear_date,new_case_purpose,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:court_code,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 16497000008113
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 18070000007053
case_no = 2023/61
court_code = 10742
pre_hear_date = 06/02/2024
next_hear_date = 28/02/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=16497000008113
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:37
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:37
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=18070000007053
Param Type = c
case_no=2023/61
Param Type = c
court_code=10742
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=27
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_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 28 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 16497000008114
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 27
Select sysdate as sdt from dual
Time elapsed = 6
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
next_hear_date = 28/02/2024
case_no = 2023/62
court_code = 10742
trn_rcms_caseid = 18089000007515
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 06/02/2024
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=16497000008114
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:37
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:37
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/02/2024 00:00:00
Param Type = c
case_no=2023/62
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=18089000007515
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 4
Adding new record to store data from Frame 2, Row 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 16497000008115
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 19
next_hear_date = 28/02/2024
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 12080000007410
case_no = 2023/95
court_code = 10742
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 06/02/2024
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=16497000008115
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:37
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=12080000007410
Param Type = c
case_no=2023/95
Param Type = c
court_code=10742
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=29
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,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 = 16
Adding new record to store data from Frame 2, Row 30 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 16497000008116
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 10
next_hear_date = 28/02/2024
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 18625000000000
case_no = 2020/00170
court_code = 10742
trn_rcms_caseid = 15443000005372
pre_case_purpose = 18625000000000
pre_hear_date = 06/02/2024
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=16497000008116
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:37
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18625000000000
Param Type = c
case_no=2020/00170
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=15443000005372
Param Type = n
pre_case_purpose=18625000000000
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 31 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 16497000008117
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 28/02/2024
new_case_purpose = 1000497
adjourn_remark = 
adjourn_type = 0
isadjourn = NO
case_no = 2018/00530
court_code = 10742
trn_rcms_caseid = 16509000002480
pre_case_purpose = 1000497
pre_hear_date = 06/02/2024
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=16497000008117
Param Type = n
trn_rcms_mhearingid=16497000008086
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:37
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/02/2024 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2018/00530
Param Type = c
court_code=10742
Param Type = c
trn_rcms_caseid=16509000002480
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=06/02/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=31
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 = 3916464493246

>>Executing genmaps

>>Posting from trcmf to tchdh from row 1

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19503000003242 idvalue 0
Mapped case_no Row = 1 value = 2019/00572 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 13/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 19503000003242
case_no = 2019/00572
prev_hearing_date = 06/02/2024
hearing_date = 13/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

Time elapsed = 13
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008118
MapName trcmf1
SourceId 16497000008087
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 = 18678000000000
hearing_date = 13/02/2024
case_no = 2019/00572
trn_rcms_caseregid = 19503000003242
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008118
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008087
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:38
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48: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=18678000000000
Param Type = c
hearing_date=13/02/2024 00:00:00
Param Type = c
case_no=2019/00572
Param Type = c
trn_rcms_caseregid=19503000003242
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 2

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16398000004870 idvalue 0
Mapped case_no Row = 1 value = 2020/00145 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 21/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 16398000004870
case_no = 2020/00145
prev_hearing_date = 06/02/2024
hearing_date = 21/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008119
MapName trcmf1
SourceId 16497000008088
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/02/2024
case_no = 2020/00145
trn_rcms_caseregid = 16398000004870
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008119
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008088
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:38
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48: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=18678000000000
Param Type = c
hearing_date=21/02/2024 00:00:00
Param Type = c
case_no=2020/00145
Param Type = c
trn_rcms_caseregid=16398000004870
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 3

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16456000004203 idvalue 0
Mapped case_no Row = 1 value = 2020/00146 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 21/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 16456000004203
case_no = 2020/00146
prev_hearing_date = 06/02/2024
hearing_date = 21/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 25
RecordId = 16497000008120
MapName trcmf1
SourceId 16497000008089
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/02/2024
case_no = 2020/00146
trn_rcms_caseregid = 16456000004203
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008120
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008089
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:38
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48: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=18678000000000
Param Type = c
hearing_date=21/02/2024 00:00:00
Param Type = c
case_no=2020/00146
Param Type = c
trn_rcms_caseregid=16456000004203
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 4

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10241000004507 idvalue 0
Mapped case_no Row = 1 value = 2020/00322 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 14/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 10241000004507
case_no = 2020/00322
prev_hearing_date = 06/02/2024
hearing_date = 14/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008121
MapName trcmf1
SourceId 16497000008090
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 14/02/2024
case_no = 2020/00322
trn_rcms_caseregid = 10241000004507
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008121
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008090
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:38
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48: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=18678000000000
Param Type = c
hearing_date=14/02/2024 00:00:00
Param Type = c
case_no=2020/00322
Param Type = c
trn_rcms_caseregid=10241000004507
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 5

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19519000006268 idvalue 0
Mapped case_no Row = 1 value = 2021/695 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 01/03/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 19519000006268
case_no = 2021/695
prev_hearing_date = 06/02/2024
hearing_date = 01/03/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008122
MapName trcmf1
SourceId 16497000008091
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 14
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/03/2024
case_no = 2021/695
trn_rcms_caseregid = 19519000006268
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008122
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008091
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:38
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48: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=18678000000000
Param Type = c
hearing_date=01/03/2024 00:00:00
Param Type = c
case_no=2021/695
Param Type = c
trn_rcms_caseregid=19519000006268
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 6

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12672000006039 idvalue 0
Mapped case_no Row = 1 value = 2021/731 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 01/03/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 12672000006039
case_no = 2021/731
prev_hearing_date = 06/02/2024
hearing_date = 01/03/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 9
RecordId = 16497000008123
MapName trcmf1
SourceId 16497000008092
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/03/2024
case_no = 2021/731
trn_rcms_caseregid = 12672000006039
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008123
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008092
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:39
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48: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=18678000000000
Param Type = c
hearing_date=01/03/2024 00:00:00
Param Type = c
case_no=2021/731
Param Type = c
trn_rcms_caseregid=12672000006039
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 7

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13063000006770 idvalue 0
Mapped case_no Row = 1 value = 2021/755 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 01/03/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 13063000006770
case_no = 2021/755
prev_hearing_date = 06/02/2024
hearing_date = 01/03/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 14
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 = 7
RecordId = 16497000008124
MapName trcmf1
SourceId 16497000008093
Select sysdate as sdt from dual
Time elapsed = 28
Select sysdate as sdt from dual
Time elapsed = 29
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/03/2024
case_no = 2021/755
trn_rcms_caseregid = 13063000006770
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008124
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008093
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:39
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48: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=18678000000000
Param Type = c
hearing_date=01/03/2024 00:00:00
Param Type = c
case_no=2021/755
Param Type = c
trn_rcms_caseregid=13063000006770
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 8

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13124000006036 idvalue 0
Mapped case_no Row = 1 value = 2021/756 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 01/03/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 13124000006036
case_no = 2021/756
prev_hearing_date = 06/02/2024
hearing_date = 01/03/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008125
MapName trcmf1
SourceId 16497000008094
Select sysdate as sdt from dual
Time elapsed = 38
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/03/2024
case_no = 2021/756
trn_rcms_caseregid = 13124000006036
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008125
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008094
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:39
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48: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=18678000000000
Param Type = c
hearing_date=01/03/2024 00:00:00
Param Type = c
case_no=2021/756
Param Type = c
trn_rcms_caseregid=13124000006036
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 9

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16554000005912 idvalue 0
Mapped case_no Row = 1 value = 2022/12 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 01/03/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 16554000005912
case_no = 2022/12
prev_hearing_date = 06/02/2024
hearing_date = 01/03/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 16497000008126
MapName trcmf1
SourceId 16497000008095
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 = 18678000000000
hearing_date = 01/03/2024
case_no = 2022/12
trn_rcms_caseregid = 16554000005912
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008126
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008095
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:39
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48: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=18678000000000
Param Type = c
hearing_date=01/03/2024 00:00:00
Param Type = c
case_no=2022/12
Param Type = c
trn_rcms_caseregid=16554000005912
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 10

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11996000007593 idvalue 0
Mapped case_no Row = 1 value = 2022/157 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 01/03/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 11996000007593
case_no = 2022/157
prev_hearing_date = 06/02/2024
hearing_date = 01/03/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 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 = 16497000008127
MapName trcmf1
SourceId 16497000008096
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 = 18678000000000
hearing_date = 01/03/2024
case_no = 2022/157
trn_rcms_caseregid = 11996000007593
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008127
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008096
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:39
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48: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=18678000000000
Param Type = c
hearing_date=01/03/2024 00:00:00
Param Type = c
case_no=2022/157
Param Type = c
trn_rcms_caseregid=11996000007593
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 11

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12167000006826 idvalue 0
Mapped case_no Row = 1 value = 2022/158 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 01/03/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 12167000006826
case_no = 2022/158
prev_hearing_date = 06/02/2024
hearing_date = 01/03/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008128
MapName trcmf1
SourceId 16497000008097
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 = 18678000000000
hearing_date = 01/03/2024
case_no = 2022/158
trn_rcms_caseregid = 12167000006826
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008128
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008097
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:40
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=01/03/2024 00:00:00
Param Type = c
case_no=2022/158
Param Type = c
trn_rcms_caseregid=12167000006826
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 12

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10813000006652 idvalue 0
Mapped case_no Row = 1 value = 2022/427 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 10813000006652
case_no = 2022/427
prev_hearing_date = 06/02/2024
hearing_date = 28/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 7
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 9
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 = 16497000008129
MapName trcmf1
SourceId 16497000008098
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 = 18678000000000
hearing_date = 28/02/2024
case_no = 2022/427
trn_rcms_caseregid = 10813000006652
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008129
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008098
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:40
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2022/427
Param Type = c
trn_rcms_caseregid=10813000006652
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 13

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10830000007726 idvalue 0
Mapped case_no Row = 1 value = 2022/428 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 10830000007726
case_no = 2022/428
prev_hearing_date = 06/02/2024
hearing_date = 28/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 16497000008130
MapName trcmf1
SourceId 16497000008099
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 28/02/2024
case_no = 2022/428
trn_rcms_caseregid = 10830000007726
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008130
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008099
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:40
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2022/428
Param Type = c
trn_rcms_caseregid=10830000007726
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 14

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10202000007984 idvalue 0
Mapped case_no Row = 1 value = 2022/464 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 07/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 10202000007984
case_no = 2022/464
prev_hearing_date = 06/02/2024
hearing_date = 07/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008131
MapName trcmf1
SourceId 16497000008100
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 10
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 07/02/2024
case_no = 2022/464
trn_rcms_caseregid = 10202000007984
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008131
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008100
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:40
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=07/02/2024 00:00:00
Param Type = c
case_no=2022/464
Param Type = c
trn_rcms_caseregid=10202000007984
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 15

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10267000006171 idvalue 0
Mapped case_no Row = 1 value = 2022/465 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 07/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 10267000006171
case_no = 2022/465
prev_hearing_date = 06/02/2024
hearing_date = 07/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008132
MapName trcmf1
SourceId 16497000008101
Select sysdate as sdt from dual
Time elapsed = 42
Select sysdate as sdt from dual
Time elapsed = 10
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 07/02/2024
case_no = 2022/465
trn_rcms_caseregid = 10267000006171
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008132
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008101
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:40
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=07/02/2024 00:00:00
Param Type = c
case_no=2022/465
Param Type = c
trn_rcms_caseregid=10267000006171
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 16

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18909000006722 idvalue 0
Mapped case_no Row = 1 value = 2022/694 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 01/03/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 18909000006722
case_no = 2022/694
prev_hearing_date = 06/02/2024
hearing_date = 01/03/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 7
RecordId = 16497000008133
MapName trcmf1
SourceId 16497000008102
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/03/2024
case_no = 2022/694
trn_rcms_caseregid = 18909000006722
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008133
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008102
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:40
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=01/03/2024 00:00:00
Param Type = c
case_no=2022/694
Param Type = c
trn_rcms_caseregid=18909000006722
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 17

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18718000007286 idvalue 0
Mapped case_no Row = 1 value = 2022/725 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 18718000007286
case_no = 2022/725
prev_hearing_date = 06/02/2024
hearing_date = 28/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 16497000008134
MapName trcmf1
SourceId 16497000008103
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 28/02/2024
case_no = 2022/725
trn_rcms_caseregid = 18718000007286
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008134
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008103
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:41
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:41
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/02/2024 00:00:00
Param Type = c
case_no=2022/725
Param Type = c
trn_rcms_caseregid=18718000007286
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 18

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18755000008497 idvalue 0
Mapped case_no Row = 1 value = 2022/726 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 18755000008497
case_no = 2022/726
prev_hearing_date = 06/02/2024
hearing_date = 28/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 8
RecordId = 16497000008135
MapName trcmf1
SourceId 16497000008104
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 = 18678000000000
hearing_date = 28/02/2024
case_no = 2022/726
trn_rcms_caseregid = 18755000008497
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008135
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008104
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:41
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:41
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/02/2024 00:00:00
Param Type = c
case_no=2022/726
Param Type = c
trn_rcms_caseregid=18755000008497
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 19

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16581000007778 idvalue 0
Mapped case_no Row = 1 value = 2023/125 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 16581000007778
case_no = 2023/125
prev_hearing_date = 06/02/2024
hearing_date = 28/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008136
MapName trcmf1
SourceId 16497000008105
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 28/02/2024
case_no = 2023/125
trn_rcms_caseregid = 16581000007778
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008136
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008105
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:41
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:41
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/02/2024 00:00:00
Param Type = c
case_no=2023/125
Param Type = c
trn_rcms_caseregid=16581000007778
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 20

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12747000007246 idvalue 0
Mapped case_no Row = 1 value = 2023/165 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 01/03/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 12747000007246
case_no = 2023/165
prev_hearing_date = 06/02/2024
hearing_date = 01/03/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008137
MapName trcmf1
SourceId 16497000008106
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/03/2024
case_no = 2023/165
trn_rcms_caseregid = 12747000007246
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008137
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008106
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:41
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:41
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=01/03/2024 00:00:00
Param Type = c
case_no=2023/165
Param Type = c
trn_rcms_caseregid=12747000007246
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 21

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13051000007204 idvalue 0
Mapped case_no Row = 1 value = 2023/169 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 01/03/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 13051000007204
case_no = 2023/169
prev_hearing_date = 06/02/2024
hearing_date = 01/03/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 16497000008138
MapName trcmf1
SourceId 16497000008107
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/03/2024
case_no = 2023/169
trn_rcms_caseregid = 13051000007204
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008138
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008107
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:41
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:41
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=01/03/2024 00:00:00
Param Type = c
case_no=2023/169
Param Type = c
trn_rcms_caseregid=13051000007204
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 22

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10985000007970 idvalue 0
Mapped case_no Row = 1 value = 2023/219 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 12/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 10985000007970
case_no = 2023/219
prev_hearing_date = 06/02/2024
hearing_date = 12/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008139
MapName trcmf1
SourceId 16497000008108
Select sysdate as sdt from dual
Time elapsed = 7
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 = 18678000000000
hearing_date = 12/02/2024
case_no = 2023/219
trn_rcms_caseregid = 10985000007970
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008139
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008108
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:41
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:41
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=12/02/2024 00:00:00
Param Type = c
case_no=2023/219
Param Type = c
trn_rcms_caseregid=10985000007970
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 23

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11042000007366 idvalue 0
Mapped case_no Row = 1 value = 2023/220 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 12/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 11042000007366
case_no = 2023/220
prev_hearing_date = 06/02/2024
hearing_date = 12/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008140
MapName trcmf1
SourceId 16497000008109
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 = 18678000000000
hearing_date = 12/02/2024
case_no = 2023/220
trn_rcms_caseregid = 11042000007366
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008140
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008109
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:41
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:42
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=12/02/2024 00:00:00
Param Type = c
case_no=2023/220
Param Type = c
trn_rcms_caseregid=11042000007366
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 24

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13311000009673 idvalue 0
Mapped case_no Row = 1 value = 2023/363 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 13311000009673
case_no = 2023/363
prev_hearing_date = 06/02/2024
hearing_date = 15/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008141
MapName trcmf1
SourceId 16497000008110
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 = 18678000000000
hearing_date = 15/02/2024
case_no = 2023/363
trn_rcms_caseregid = 13311000009673
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008141
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008110
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:42
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=15/02/2024 00:00:00
Param Type = c
case_no=2023/363
Param Type = c
trn_rcms_caseregid=13311000009673
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 25

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13384000008470 idvalue 0
Mapped case_no Row = 1 value = 2023/364 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 13384000008470
case_no = 2023/364
prev_hearing_date = 06/02/2024
hearing_date = 15/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008142
MapName trcmf1
SourceId 16497000008111
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 15/02/2024
case_no = 2023/364
trn_rcms_caseregid = 13384000008470
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008142
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008111
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:42
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=15/02/2024 00:00:00
Param Type = c
case_no=2023/364
Param Type = c
trn_rcms_caseregid=13384000008470
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 26

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10420000007541 idvalue 0
Mapped case_no Row = 1 value = 2023/389 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 01/03/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 10420000007541
case_no = 2023/389
prev_hearing_date = 06/02/2024
hearing_date = 01/03/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 16497000008143
MapName trcmf1
SourceId 16497000008112
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 01/03/2024
case_no = 2023/389
trn_rcms_caseregid = 10420000007541
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008143
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008112
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:42
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:42
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=01/03/2024 00:00:00
Param Type = c
case_no=2023/389
Param Type = c
trn_rcms_caseregid=10420000007541
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 27

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18070000007053 idvalue 0
Mapped case_no Row = 1 value = 2023/61 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 18070000007053
case_no = 2023/61
prev_hearing_date = 06/02/2024
hearing_date = 28/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 16497000008144
MapName trcmf1
SourceId 16497000008113
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 28/02/2024
case_no = 2023/61
trn_rcms_caseregid = 18070000007053
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008144
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008113
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:42
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:42
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/02/2024 00:00:00
Param Type = c
case_no=2023/61
Param Type = c
trn_rcms_caseregid=18070000007053
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 28

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18089000007515 idvalue 0
Mapped case_no Row = 1 value = 2023/62 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 18089000007515
case_no = 2023/62
prev_hearing_date = 06/02/2024
hearing_date = 28/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 16497000008145
MapName trcmf1
SourceId 16497000008114
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 = 18678000000000
hearing_date = 28/02/2024
case_no = 2023/62
trn_rcms_caseregid = 18089000007515
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008145
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008114
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:42
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:42
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/02/2024 00:00:00
Param Type = c
case_no=2023/62
Param Type = c
trn_rcms_caseregid=18089000007515
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 29

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12080000007410 idvalue 0
Mapped case_no Row = 1 value = 2023/95 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 12080000007410
case_no = 2023/95
prev_hearing_date = 06/02/2024
hearing_date = 28/02/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 16497000008146
MapName trcmf1
SourceId 16497000008115
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 = 18678000000000
hearing_date = 28/02/2024
case_no = 2023/95
trn_rcms_caseregid = 12080000007410
court_code = 10742
case_purpose = 18678000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008146
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008115
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:42
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:42
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/02/2024 00:00:00
Param Type = c
case_no=2023/95
Param Type = c
trn_rcms_caseregid=12080000007410
Param Type = c
court_code=10742
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 30

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15443000005372 idvalue 0
Mapped case_no Row = 1 value = 2020/00170 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????????? ???????  idvalue 0
Mapped case_purpose Row = 1 value = 18625000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 15443000005372
case_no = 2020/00170
prev_hearing_date = 06/02/2024
hearing_date = 28/02/2024
prev_case_purposename = ????????? ??????? 
prev_case_purpose = 
prev_case_purposename=????????? ??????? 
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

Time elapsed = 6
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 = 16497000008147
MapName trcmf1
SourceId 16497000008116
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18625000000000
hearing_date = 28/02/2024
case_no = 2020/00170
trn_rcms_caseregid = 15443000005372
court_code = 10742
case_purpose = 18625000000000
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008147
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008116
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:43
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18625000000000
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2020/00170
Param Type = c
trn_rcms_caseregid=15443000005372
Param Type = c
court_code=10742
Param Type = c
case_purpose=18625000000000
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 31

>>Mapping
Mapped court_code Row = 1 value = 10742 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16509000002480 idvalue 0
Mapped case_no Row = 1 value = 2018/00530 idvalue 0
Mapped prev_hearing_date Row = 1 value = 06/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 28/02/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10742
trn_rcms_caseregid = 16509000002480
case_no = 2018/00530
prev_hearing_date = 06/02/2024
hearing_date = 28/02/2024
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purposename=???? ?????????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

Time elapsed = 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 = 16497000008148
MapName trcmf1
SourceId 16497000008117
Select sysdate as sdt from dual
Time elapsed = 9
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 = 1000497
hearing_date = 28/02/2024
case_no = 2018/00530
trn_rcms_caseregid = 16509000002480
court_code = 10742
case_purpose = 1000497
prev_hearing_date = 06/02/2024
Posting record
Param Type = n
trn_rcms_case_histid=16497000008148
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=16497000008117
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Bandikui
Param Type = c
createdon=07/02/2024 10:48:43
Param Type = c
username=SDO_Bandikui
Param Type = c
modifiedon=07/02/2024 10:48:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=28/02/2024 00:00:00
Param Type = c
case_no=2018/00530
Param Type = c
trn_rcms_caseregid=16509000002480
Param Type = c
court_code=10742
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=06/02/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))

Time elapsed for Gen Map = 3916464498767
Time elapsed for MD Map = 3916464498771
Time elapsed for Save History = 3916464498776
Time elapsed for Save Attachment = 3916464498779
Time elapsed for After Save WF Exec = 3916464498794
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"16497000008086"}]}
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_Bandikui
Param Type = c
calledon=07/02/2024 10:48:08
Param Type = c
callfinished=07/02/2024 10:48:18
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=10388
Param Type = n
dbtimetaken=6245
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