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="RAA_tonk_R" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>RAA_tonk_R</username><password>827ccb0eea8a706c4c34a16891f84e7b</password><seed></seed><s></s><transid>trcmf</transid><recordid>0</recordid><recdata></recdata><data transid="trcmf" recordid="0"><axp_recid1 rowno="001">0</axp_recid1><courtcode rowno="001">10775</courtcode><hearing_date rowno="001">07/05/2026</hearing_date><axp_recid2 rowno="001">0</axp_recid2><court_code rowno="001">10775</court_code><case_no rowno="001">2011/00062</case_no><trn_rcms_caseid rowno="001">353410</trn_rcms_caseid><pre_case_purpose_name rowno="001">????</pre_case_purpose_name><pre_hear_date rowno="001">07/05/2026</pre_hear_date><pre_case_purpose rowno="001">18678000000000</pre_case_purpose><next_hear_date rowno="001">21/05/2026</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">10775</court_code><case_no rowno="002">2012/00115</case_no><trn_rcms_caseid rowno="002">353492</trn_rcms_caseid><pre_case_purpose_name rowno="002">???</pre_case_purpose_name><pre_hear_date rowno="002">07/05/2026</pre_hear_date><pre_case_purpose rowno="002">18473000000000</pre_case_purpose><next_hear_date rowno="002">21/05/2026</next_hear_date><new_case_purpose rowno="002">18473000000000</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">10775</court_code><case_no rowno="003">2013/00005</case_no><trn_rcms_caseid rowno="003">352806</trn_rcms_caseid><pre_case_purpose_name rowno="003">????</pre_case_purpose_name><pre_hear_date rowno="003">07/05/2026</pre_hear_date><pre_case_purpose rowno="003">18678000000000</pre_case_purpose><next_hear_date rowno="003">21/05/2026</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">10775</court_code><case_no rowno="004">2013/00066</case_no><trn_rcms_caseid rowno="004">353221</trn_rcms_caseid><pre_case_purpose_name rowno="004">????</pre_case_purpose_name><pre_hear_date rowno="004">07/05/2026</pre_hear_date><pre_case_purpose rowno="004">18678000000000</pre_case_purpose><next_hear_date rowno="004">21/05/2026</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">10775</court_code><case_no rowno="005">2019/00215</case_no><trn_rcms_caseid rowno="005">12853000003665</trn_rcms_caseid><pre_case_purpose_name rowno="005">????</pre_case_purpose_name><pre_hear_date rowno="005">07/05/2026</pre_hear_date><pre_case_purpose rowno="005">18678000000000</pre_case_purpose><next_hear_date rowno="005">21/05/2026</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">10775</court_code><case_no rowno="006">2019/00076</case_no><trn_rcms_caseid rowno="006">16972000002532</trn_rcms_caseid><pre_case_purpose_name rowno="006">???</pre_case_purpose_name><pre_hear_date rowno="006">07/05/2026</pre_hear_date><pre_case_purpose rowno="006">18473000000000</pre_case_purpose><next_hear_date rowno="006">21/05/2026</next_hear_date><new_case_purpose rowno="006">18473000000000</new_case_purpose><isadjourn rowno="006">NO</isadjourn><adjourn_type rowno="006">0</adjourn_type><adjourn_remark rowno="006"></adjourn_remark><axp_recid2 rowno="007">0</axp_recid2><court_code rowno="007">10775</court_code><case_no rowno="007">2019/00118</case_no><trn_rcms_caseid rowno="007">19267000002702</trn_rcms_caseid><pre_case_purpose_name rowno="007">???</pre_case_purpose_name><pre_hear_date rowno="007">07/05/2026</pre_hear_date><pre_case_purpose rowno="007">18473000000000</pre_case_purpose><next_hear_date rowno="007">21/05/2026</next_hear_date><new_case_purpose rowno="007">18473000000000</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">10775</court_code><case_no rowno="008">2021/116</case_no><trn_rcms_caseid rowno="008">13538000006377</trn_rcms_caseid><pre_case_purpose_name rowno="008">????</pre_case_purpose_name><pre_hear_date rowno="008">07/05/2026</pre_hear_date><pre_case_purpose rowno="008">18678000000000</pre_case_purpose><next_hear_date rowno="008">21/05/2026</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">10775</court_code><case_no rowno="009">2021/118</case_no><trn_rcms_caseid rowno="009">14679000005682</trn_rcms_caseid><pre_case_purpose_name rowno="009">????</pre_case_purpose_name><pre_hear_date rowno="009">07/05/2026</pre_hear_date><pre_case_purpose rowno="009">18678000000000</pre_case_purpose><next_hear_date rowno="009">21/05/2026</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">10775</court_code><case_no rowno="0010">2023/158</case_no><trn_rcms_caseid rowno="0010">12545000007558</trn_rcms_caseid><pre_case_purpose_name rowno="0010">????</pre_case_purpose_name><pre_hear_date rowno="0010">07/05/2026</pre_hear_date><pre_case_purpose rowno="0010">18678000000000</pre_case_purpose><next_hear_date rowno="0010">21/05/2026</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">10775</court_code><case_no rowno="0011">2023/25</case_no><trn_rcms_caseid rowno="0011">13185000007498</trn_rcms_caseid><pre_case_purpose_name rowno="0011">????</pre_case_purpose_name><pre_hear_date rowno="0011">07/05/2026</pre_hear_date><pre_case_purpose rowno="0011">18678000000000</pre_case_purpose><next_hear_date rowno="0011">21/05/2026</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">10775</court_code><case_no rowno="0012">2023/90</case_no><trn_rcms_caseid rowno="0012">11807000007828</trn_rcms_caseid><pre_case_purpose_name rowno="0012">????</pre_case_purpose_name><pre_hear_date rowno="0012">07/05/2026</pre_hear_date><pre_case_purpose rowno="0012">18678000000000</pre_case_purpose><next_hear_date rowno="0012">21/05/2026</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">10775</court_code><case_no rowno="0013">2023/175</case_no><trn_rcms_caseid rowno="0013">18421000008167</trn_rcms_caseid><pre_case_purpose_name rowno="0013">???</pre_case_purpose_name><pre_hear_date rowno="0013">07/05/2026</pre_hear_date><pre_case_purpose rowno="0013">18473000000000</pre_case_purpose><next_hear_date rowno="0013">21/05/2026</next_hear_date><new_case_purpose rowno="0013">18473000000000</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">10775</court_code><case_no rowno="0014">2023/59</case_no><trn_rcms_caseid rowno="0014">10284000007769</trn_rcms_caseid><pre_case_purpose_name rowno="0014">???</pre_case_purpose_name><pre_hear_date rowno="0014">07/05/2026</pre_hear_date><pre_case_purpose rowno="0014">18473000000000</pre_case_purpose><next_hear_date rowno="0014">21/05/2026</next_hear_date><new_case_purpose rowno="0014">18473000000000</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">10775</court_code><case_no rowno="0015">2024/28</case_no><trn_rcms_caseid rowno="0015">19709000007273</trn_rcms_caseid><pre_case_purpose_name rowno="0015">????</pre_case_purpose_name><pre_hear_date rowno="0015">07/05/2026</pre_hear_date><pre_case_purpose rowno="0015">18678000000000</pre_case_purpose><next_hear_date rowno="0015">21/05/2026</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">10775</court_code><case_no rowno="0016">2024/48</case_no><trn_rcms_caseid rowno="0016">15303000008751</trn_rcms_caseid><pre_case_purpose_name rowno="0016">????</pre_case_purpose_name><pre_hear_date rowno="0016">07/05/2026</pre_hear_date><pre_case_purpose rowno="0016">18678000000000</pre_case_purpose><next_hear_date rowno="0016">21/05/2026</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">10775</court_code><case_no rowno="0017">2024/52</case_no><trn_rcms_caseid rowno="0017">19252000007840</trn_rcms_caseid><pre_case_purpose_name rowno="0017">????</pre_case_purpose_name><pre_hear_date rowno="0017">07/05/2026</pre_hear_date><pre_case_purpose rowno="0017">18678000000000</pre_case_purpose><next_hear_date rowno="0017">21/05/2026</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">10775</court_code><case_no rowno="0018">2025/282</case_no><trn_rcms_caseid rowno="0018">14105000011078</trn_rcms_caseid><pre_case_purpose_name rowno="0018">????</pre_case_purpose_name><pre_hear_date rowno="0018">07/05/2026</pre_hear_date><pre_case_purpose rowno="0018">18678000000000</pre_case_purpose><next_hear_date rowno="0018">21/05/2026</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">10775</court_code><case_no rowno="0019">2025/31</case_no><trn_rcms_caseid rowno="0019">15273000009667</trn_rcms_caseid><pre_case_purpose_name rowno="0019">????</pre_case_purpose_name><pre_hear_date rowno="0019">07/05/2026</pre_hear_date><pre_case_purpose rowno="0019">18678000000000</pre_case_purpose><next_hear_date rowno="0019">21/05/2026</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">10775</court_code><case_no rowno="0020">2025/338</case_no><trn_rcms_caseid rowno="0020">17487000012297</trn_rcms_caseid><pre_case_purpose_name rowno="0020">????</pre_case_purpose_name><pre_hear_date rowno="0020">07/05/2026</pre_hear_date><pre_case_purpose rowno="0020">18678000000000</pre_case_purpose><next_hear_date rowno="0020">21/05/2026</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">10775</court_code><case_no rowno="0021">2025/354</case_no><trn_rcms_caseid rowno="0021">12722000011130</trn_rcms_caseid><pre_case_purpose_name rowno="0021">????</pre_case_purpose_name><pre_hear_date rowno="0021">07/05/2026</pre_hear_date><pre_case_purpose rowno="0021">18678000000000</pre_case_purpose><next_hear_date rowno="0021">21/05/2026</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">10775</court_code><case_no rowno="0022">2025/369</case_no><trn_rcms_caseid rowno="0022">18297000011519</trn_rcms_caseid><pre_case_purpose_name rowno="0022">????</pre_case_purpose_name><pre_hear_date rowno="0022">07/05/2026</pre_hear_date><pre_case_purpose rowno="0022">18678000000000</pre_case_purpose><next_hear_date rowno="0022">21/05/2026</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">10775</court_code><case_no rowno="0023">2025/370</case_no><trn_rcms_caseid rowno="0023">18610000010355</trn_rcms_caseid><pre_case_purpose_name rowno="0023">????</pre_case_purpose_name><pre_hear_date rowno="0023">07/05/2026</pre_hear_date><pre_case_purpose rowno="0023">18678000000000</pre_case_purpose><next_hear_date rowno="0023">21/05/2026</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">10775</court_code><case_no rowno="0024">2025/372</case_no><trn_rcms_caseid rowno="0024">19038000012497</trn_rcms_caseid><pre_case_purpose_name rowno="0024">????</pre_case_purpose_name><pre_hear_date rowno="0024">07/05/2026</pre_hear_date><pre_case_purpose rowno="0024">18678000000000</pre_case_purpose><next_hear_date rowno="0024">21/05/2026</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">10775</court_code><case_no rowno="0025">2025/377</case_no><trn_rcms_caseid rowno="0025">11050000011930</trn_rcms_caseid><pre_case_purpose_name rowno="0025">????</pre_case_purpose_name><pre_hear_date rowno="0025">07/05/2026</pre_hear_date><pre_case_purpose rowno="0025">18678000000000</pre_case_purpose><next_hear_date rowno="0025">21/05/2026</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">10775</court_code><case_no rowno="0026">2025/386</case_no><trn_rcms_caseid rowno="0026">16824000011260</trn_rcms_caseid><pre_case_purpose_name rowno="0026">????</pre_case_purpose_name><pre_hear_date rowno="0026">07/05/2026</pre_hear_date><pre_case_purpose rowno="0026">18678000000000</pre_case_purpose><next_hear_date rowno="0026">21/05/2026</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">10775</court_code><case_no rowno="0027">2025/50</case_no><trn_rcms_caseid rowno="0027">11682000009957</trn_rcms_caseid><pre_case_purpose_name rowno="0027">????</pre_case_purpose_name><pre_hear_date rowno="0027">07/05/2026</pre_hear_date><pre_case_purpose rowno="0027">18678000000000</pre_case_purpose><next_hear_date rowno="0027">21/05/2026</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">10775</court_code><case_no rowno="0028">2025/94</case_no><trn_rcms_caseid rowno="0028">12500000009650</trn_rcms_caseid><pre_case_purpose_name rowno="0028">????</pre_case_purpose_name><pre_hear_date rowno="0028">07/05/2026</pre_hear_date><pre_case_purpose rowno="0028">18678000000000</pre_case_purpose><next_hear_date rowno="0028">21/05/2026</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">10775</court_code><case_no rowno="0029">2026/100</case_no><trn_rcms_caseid rowno="0029">10763000011719</trn_rcms_caseid><pre_case_purpose_name rowno="0029">????</pre_case_purpose_name><pre_hear_date rowno="0029">07/05/2026</pre_hear_date><pre_case_purpose rowno="0029">18678000000000</pre_case_purpose><next_hear_date rowno="0029">21/05/2026</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">10775</court_code><case_no rowno="0030">2026/114</case_no><trn_rcms_caseid rowno="0030">13150000011881</trn_rcms_caseid><pre_case_purpose_name rowno="0030">????</pre_case_purpose_name><pre_hear_date rowno="0030">07/05/2026</pre_hear_date><pre_case_purpose rowno="0030">18678000000000</pre_case_purpose><next_hear_date rowno="0030">21/05/2026</next_hear_date><new_case_purpose rowno="0030">18678000000000</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">10775</court_code><case_no rowno="0031">2026/4</case_no><trn_rcms_caseid rowno="0031">11680000011771</trn_rcms_caseid><pre_case_purpose_name rowno="0031">????</pre_case_purpose_name><pre_hear_date rowno="0031">07/05/2026</pre_hear_date><pre_case_purpose rowno="0031">18678000000000</pre_case_purpose><next_hear_date rowno="0031">21/05/2026</next_hear_date><new_case_purpose rowno="0031">18678000000000</new_case_purpose><isadjourn rowno="0031">NO</isadjourn><adjourn_type rowno="0031">0</adjourn_type><adjourn_remark rowno="0031"></adjourn_remark><axp_recid2 rowno="0032">0</axp_recid2><court_code rowno="0032">10775</court_code><case_no rowno="0032">2026/6</case_no><trn_rcms_caseid rowno="0032">12191000011174</trn_rcms_caseid><pre_case_purpose_name rowno="0032">????</pre_case_purpose_name><pre_hear_date rowno="0032">07/05/2026</pre_hear_date><pre_case_purpose rowno="0032">18678000000000</pre_case_purpose><next_hear_date rowno="0032">21/05/2026</next_hear_date><new_case_purpose rowno="0032">18678000000000</new_case_purpose><isadjourn rowno="0032">NO</isadjourn><adjourn_type rowno="0032">0</adjourn_type><adjourn_remark rowno="0032"></adjourn_remark><axp_recid2 rowno="0033">0</axp_recid2><court_code rowno="0033">10775</court_code><case_no rowno="0033">2026/89</case_no><trn_rcms_caseid rowno="0033">15480000012330</trn_rcms_caseid><pre_case_purpose_name rowno="0033">????</pre_case_purpose_name><pre_hear_date rowno="0033">07/05/2026</pre_hear_date><pre_case_purpose rowno="0033">18678000000000</pre_case_purpose><next_hear_date rowno="0033">21/05/2026</next_hear_date><new_case_purpose rowno="0033">18678000000000</new_case_purpose><isadjourn rowno="0033">NO</isadjourn><adjourn_type rowno="0033">0</adjourn_type><adjourn_remark rowno="0033"></adjourn_remark></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"RAA_tonk_R","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"trcmf","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtcode":"10775","hearing_date":"07/05/2026"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"court_code":"10775","case_no":"2011/00062","trn_rcms_caseid":"353410","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"002","text":"0","columns":{"court_code":"10775","case_no":"2012/00115","trn_rcms_caseid":"353492","pre_case_purpose_name":"???","pre_hear_date":"07/05/2026","pre_case_purpose":"18473000000000","next_hear_date":"21/05/2026","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"003","text":"0","columns":{"court_code":"10775","case_no":"2013/00005","trn_rcms_caseid":"352806","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"004","text":"0","columns":{"court_code":"10775","case_no":"2013/00066","trn_rcms_caseid":"353221","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"005","text":"0","columns":{"court_code":"10775","case_no":"2019/00215","trn_rcms_caseid":"12853000003665","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"006","text":"0","columns":{"court_code":"10775","case_no":"2019/00076","trn_rcms_caseid":"16972000002532","pre_case_purpose_name":"???","pre_hear_date":"07/05/2026","pre_case_purpose":"18473000000000","next_hear_date":"21/05/2026","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"007","text":"0","columns":{"court_code":"10775","case_no":"2019/00118","trn_rcms_caseid":"19267000002702","pre_case_purpose_name":"???","pre_hear_date":"07/05/2026","pre_case_purpose":"18473000000000","next_hear_date":"21/05/2026","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"008","text":"0","columns":{"court_code":"10775","case_no":"2021/116","trn_rcms_caseid":"13538000006377","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"009","text":"0","columns":{"court_code":"10775","case_no":"2021/118","trn_rcms_caseid":"14679000005682","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0010","text":"0","columns":{"court_code":"10775","case_no":"2023/158","trn_rcms_caseid":"12545000007558","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0011","text":"0","columns":{"court_code":"10775","case_no":"2023/25","trn_rcms_caseid":"13185000007498","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0012","text":"0","columns":{"court_code":"10775","case_no":"2023/90","trn_rcms_caseid":"11807000007828","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0013","text":"0","columns":{"court_code":"10775","case_no":"2023/175","trn_rcms_caseid":"18421000008167","pre_case_purpose_name":"???","pre_hear_date":"07/05/2026","pre_case_purpose":"18473000000000","next_hear_date":"21/05/2026","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0014","text":"0","columns":{"court_code":"10775","case_no":"2023/59","trn_rcms_caseid":"10284000007769","pre_case_purpose_name":"???","pre_hear_date":"07/05/2026","pre_case_purpose":"18473000000000","next_hear_date":"21/05/2026","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0015","text":"0","columns":{"court_code":"10775","case_no":"2024/28","trn_rcms_caseid":"19709000007273","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0016","text":"0","columns":{"court_code":"10775","case_no":"2024/48","trn_rcms_caseid":"15303000008751","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0017","text":"0","columns":{"court_code":"10775","case_no":"2024/52","trn_rcms_caseid":"19252000007840","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0018","text":"0","columns":{"court_code":"10775","case_no":"2025/282","trn_rcms_caseid":"14105000011078","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0019","text":"0","columns":{"court_code":"10775","case_no":"2025/31","trn_rcms_caseid":"15273000009667","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0020","text":"0","columns":{"court_code":"10775","case_no":"2025/338","trn_rcms_caseid":"17487000012297","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0021","text":"0","columns":{"court_code":"10775","case_no":"2025/354","trn_rcms_caseid":"12722000011130","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0022","text":"0","columns":{"court_code":"10775","case_no":"2025/369","trn_rcms_caseid":"18297000011519","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0023","text":"0","columns":{"court_code":"10775","case_no":"2025/370","trn_rcms_caseid":"18610000010355","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0024","text":"0","columns":{"court_code":"10775","case_no":"2025/372","trn_rcms_caseid":"19038000012497","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0025","text":"0","columns":{"court_code":"10775","case_no":"2025/377","trn_rcms_caseid":"11050000011930","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0026","text":"0","columns":{"court_code":"10775","case_no":"2025/386","trn_rcms_caseid":"16824000011260","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0027","text":"0","columns":{"court_code":"10775","case_no":"2025/50","trn_rcms_caseid":"11682000009957","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0028","text":"0","columns":{"court_code":"10775","case_no":"2025/94","trn_rcms_caseid":"12500000009650","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0029","text":"0","columns":{"court_code":"10775","case_no":"2026/100","trn_rcms_caseid":"10763000011719","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0030","text":"0","columns":{"court_code":"10775","case_no":"2026/114","trn_rcms_caseid":"13150000011881","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0031","text":"0","columns":{"court_code":"10775","case_no":"2026/4","trn_rcms_caseid":"11680000011771","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0032","text":"0","columns":{"court_code":"10775","case_no":"2026/6","trn_rcms_caseid":"12191000011174","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0033","text":"0","columns":{"court_code":"10775","case_no":"2026/89","trn_rcms_caseid":"15480000012330","pre_case_purpose_name":"????","pre_hear_date":"07/05/2026","pre_case_purpose":"18678000000000","next_hear_date":"21/05/2026","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}}]}]}}
Verifying username and password
User Name : RAA_tonk_R
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=raa_tonk_r
Time elapsed = 17
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 5
Result : 
Verifying completed...
Page Access Category : 
User Name : raa_tonk_r
Select sysdate as sdt from dual
Time elapsed = 2
dt=15/05/2026 10:54:07
Select sysdate as sdt from dual
Time elapsed = 2
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=raa_tonk_r
dt=15/05/2026 10:54:07
dt=15/05/2026 10:54:07
Time elapsed = 7
User Groups: court_reader
select userroles from axusergroups where groupname in ( 'court_reader' )
Time elapsed = 2
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 = 1
Step4
axprops\stm size:4235
Step4-123456
<root updatedon="06/08/2025 14:47:20" name="app" caption="app" appverno="10.1.0.0" updusername="" updatedby="admin"><props LocalNum="750"><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=RAA_tonk_R
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=RAA_tonk_R
Time elapsed = 4
   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=RAA_tonk_R
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=RAA_tonk_R
Time elapsed = 3
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type})
   Calling function sqlget
   Result of sqlget = S.O. Cum R.A.A
   Result = S.O. Cum R.A.A
   Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
   Calling function firesql
username=RAA_tonk_R
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=RAA_tonk_R
Time elapsed = 3
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{court_name_mastid})
   Calling function sqlget
   Result of sqlget = 17034000000005
   Result = 17034000000005
   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=RAA_tonk_R
Time elapsed = 3
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{axusersid})
   Calling function sqlget
   Result of sqlget = 17037000000008
   Result = 17037000000008
   Evaluating firesql({m4},{select :username as uname from dual})
   Calling function firesql
select :username as uname from dual
username=RAA_tonk_R
Time elapsed = 2
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{uname})
   Calling function sqlget
   Result of sqlget = RAA_tonk_R
   Result = RAA_tonk_R
   Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
   Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=RAA_tonk_R
Time elapsed = 2
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{COURT_CODE})
   Calling function sqlget
   Result of sqlget = 10775
   Result = 10775
   Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
   Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{STATE_NAME})
   Calling function sqlget
   Result of sqlget = ????????
   Result = ????????
   Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=RAA_tonk_R
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=RAA_tonk_R
Time elapsed = 1
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m7},{DISTNAMEENG})
   Calling function sqlget
   Result of sqlget = Tonk
   Result = Tonk
   Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=RAA_tonk_R
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=RAA_tonk_R
Time elapsed = 1
   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=17037000000008
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=17037000000008
Time elapsed = 4
   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=RAA_tonk_R
Time elapsed = 2
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type_mastid})
   Calling function sqlget
   Result of sqlget = 15354000000008
   Result = 15354000000008
   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=RAA_tonk_R
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=RAA_tonk_R
Time elapsed = 3
   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 = 2
   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=RAA_tonk_R
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=RAA_tonk_R
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({P1},{ct})
   Calling function sqlget
   Result of sqlget = 7
   Result = 7
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='trcmf' and stype = 't' )

Time elapsed = 2
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 5
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 = 3
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 = 3
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 = 2
select * from trn_rcms_mhearing where trn_rcms_mhearingid=0
Time elapsed = 2
select * from Axusers where 1=2
Time elapsed = 2
select distinct(fldname) from AxTempUserFields
Time elapsed = 2
select * from AxAttachWorkflow where lower(transid) = 'trcmf'
Time elapsed = 4
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 = 1
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 = 2
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 3
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 = 10775
hearing_date = 07/05/2026
time zone difference  = 0

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

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

Time elapsed = 3
RecordId = 13560000011104
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 2
hearing_date = 07/05/2026
courtcode = 10775
Posting record
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=07/05/2026 00:00:00
Param Type = c
courtcode=10775
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 = 2
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 = 1
RecordId = 13560000011105
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
case_no = 2011/00062
trn_rcms_caseid = 353410
pre_hear_date = 07/05/2026
court_code = 10775
isadjourn = NO
adjourn_type = 0
adjourn_remark = 
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
next_hear_date = 21/05/2026
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=13560000011105
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2011/00062
Param Type = c
trn_rcms_caseid=353410
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = c
court_code=10775
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=21/05/2026 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,case_no,trn_rcms_caseid,pre_hear_date,court_code,isadjourn,adjourn_type,adjourn_remark,pre_case_purpose,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,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:isadjourn,:adjourn_type,null,:pre_case_purpose,: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 = 3
Adding new record to store data from Frame 2, Row 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 13560000011106
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 21/05/2026
isadjourn = NO
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
pre_hear_date = 07/05/2026
case_no = 2012/00115
court_code = 10775
trn_rcms_caseid = 353492
adjourn_type = 0
adjourn_remark = 
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=13560000011106
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = c
case_no=2012/00115
Param Type = c
court_code=10775
Param Type = c
trn_rcms_caseid=353492
Param Type = c
adjourn_type=0
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,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_type,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:adjourn_type,null,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 2
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 = 0
RecordId = 13560000011107
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 0
pre_hear_date = 07/05/2026
pre_case_purpose = 18678000000000
trn_rcms_caseid = 352806
court_code = 10775
case_no = 2013/00005
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 21/05/2026
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=13560000011107
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=352806
Param Type = c
court_code=10775
Param Type = c
case_no=2013/00005
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/05/2026 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 = 3
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 13560000011108
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 21/05/2026
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2013/00066
court_code = 10775
trn_rcms_caseid = 353221
pre_case_purpose = 18678000000000
pre_hear_date = 07/05/2026
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=13560000011108
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/05/2026 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=2013/00066
Param Type = c
court_code=10775
Param Type = c
trn_rcms_caseid=353221
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 2
RecordId = 13560000011109
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 21/05/2026
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2019/00215
court_code = 10775
trn_rcms_caseid = 12853000003665
pre_case_purpose = 18678000000000
pre_hear_date = 07/05/2026
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=13560000011109
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/05/2026 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/00215
Param Type = c
court_code=10775
Param Type = c
trn_rcms_caseid=12853000003665
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=07/05/2026 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 = 4
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 = 1
RecordId = 13560000011110
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 21/05/2026
new_case_purpose = 18473000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2019/00076
court_code = 10775
trn_rcms_caseid = 16972000002532
pre_case_purpose = 18473000000000
pre_hear_date = 07/05/2026
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=13560000011110
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2019/00076
Param Type = c
court_code=10775
Param Type = c
trn_rcms_caseid=16972000002532
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=07/05/2026 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 = 2
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 = 2
RecordId = 13560000011111
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 1
pre_hear_date = 07/05/2026
pre_case_purpose = 18473000000000
trn_rcms_caseid = 19267000002702
court_code = 10775
case_no = 2019/00118
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 21/05/2026
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=13560000011111
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=19267000002702
Param Type = c
court_code=10775
Param Type = c
case_no=2019/00118
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_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 = 1
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 = 1
RecordId = 13560000011112
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 21/05/2026
case_no = 2021/116
court_code = 10775
trn_rcms_caseid = 13538000006377
pre_case_purpose = 18678000000000
pre_hear_date = 07/05/2026
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=13560000011112
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
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
new_case_purpose=18678000000000
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
case_no=2021/116
Param Type = c
court_code=10775
Param Type = c
trn_rcms_caseid=13538000006377
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,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,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),: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 = 3
Adding new record to store data from Frame 2, Row 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 13560000011113
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 21/05/2026
new_case_purpose = 18678000000000
adjourn_type = 0
isadjourn = NO
pre_case_purpose = 18678000000000
case_no = 2021/118
court_code = 10775
pre_hear_date = 07/05/2026
trn_rcms_caseid = 14679000005682
adjourn_remark = 
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=13560000011113
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2021/118
Param Type = c
court_code=10775
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = c
trn_rcms_caseid=14679000005682
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,next_hear_date,new_case_purpose,adjourn_type,isadjourn,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:isadjourn,:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 3
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 = 1
RecordId = 13560000011114
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_type = 0
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
isadjourn = NO
next_hear_date = 21/05/2026
case_no = 2023/158
court_code = 10775
trn_rcms_caseid = 12545000007558
adjourn_remark = 
pre_hear_date = 07/05/2026
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=13560000011114
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
case_no=2023/158
Param Type = c
court_code=10775
Param Type = c
trn_rcms_caseid=12545000007558
Param Type = c
pre_hear_date=07/05/2026 00:00:00
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,adjourn_type,pre_case_purpose,new_case_purpose,isadjourn,next_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_remark,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,:adjourn_type,:pre_case_purpose,:new_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,null,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 = 28
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 = 1
RecordId = 13560000011115
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
court_code = 10775
adjourn_type = 0
isadjourn = NO
case_no = 2023/25
adjourn_remark = 
next_hear_date = 21/05/2026
pre_case_purpose = 18678000000000
pre_hear_date = 07/05/2026
new_case_purpose = 18678000000000
trn_rcms_caseid = 13185000007498
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=13560000011115
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10775
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2023/25
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=13185000007498
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,court_code,adjourn_type,isadjourn,case_no,adjourn_remark,next_hear_date,pre_case_purpose,pre_hear_date,new_case_purpose,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:adjourn_type,:isadjourn,:case_no,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_caseid,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 3
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 = 2
RecordId = 13560000011116
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
pre_hear_date = 07/05/2026
pre_case_purpose = 18678000000000
court_code = 10775
case_no = 2023/90
trn_rcms_caseid = 11807000007828
new_case_purpose = 18678000000000
adjourn_type = 0
adjourn_remark = 
next_hear_date = 21/05/2026
isadjourn = NO
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=13560000011116
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=10775
Param Type = c
case_no=2023/90
Param Type = c
trn_rcms_caseid=11807000007828
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
isadjourn=NO
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,court_code,case_no,trn_rcms_caseid,new_case_purpose,adjourn_type,adjourn_remark,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,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,:case_no,:trn_rcms_caseid,:new_case_purpose,:adjourn_type,null,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 = 2
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 = 1
RecordId = 13560000011117
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
case_no = 2023/175
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
trn_rcms_caseid = 18421000008167
pre_hear_date = 07/05/2026
adjourn_remark = 
court_code = 10775
adjourn_type = 0
next_hear_date = 21/05/2026
isadjourn = NO
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=13560000011117
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/175
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=18421000008167
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = c
court_code=10775
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
isadjourn=NO
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,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 = 3
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 13560000011118
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 21/05/2026
new_case_purpose = 18473000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2023/59
court_code = 10775
trn_rcms_caseid = 10284000007769
pre_case_purpose = 18473000000000
pre_hear_date = 07/05/2026
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=13560000011118
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/59
Param Type = c
court_code=10775
Param Type = c
trn_rcms_caseid=10284000007769
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=07/05/2026 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 = 3
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 = 1
RecordId = 13560000011119
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 07/05/2026
pre_case_purpose = 18678000000000
trn_rcms_caseid = 19709000007273
court_code = 10775
case_no = 2024/28
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
next_hear_date = 21/05/2026
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=13560000011119
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=19709000007273
Param Type = c
court_code=10775
Param Type = c
case_no=2024/28
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_remark,adjourn_type,next_hear_date,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,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 3
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 = 2
RecordId = 13560000011120
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trn_rcms_caseid = 15303000008751
pre_hear_date = 07/05/2026
court_code = 10775
case_no = 2024/48
next_hear_date = 21/05/2026
isadjourn = NO
adjourn_type = 0
pre_case_purpose = 18678000000000
adjourn_remark = 
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=13560000011120
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=15303000008751
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = c
court_code=10775
Param Type = c
case_no=2024/48
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
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,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,adjourn_type,pre_case_purpose,adjourn_remark,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,: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,:adjourn_type,:pre_case_purpose,null,:new_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 1
RecordId = 13560000011121
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
pre_hear_date = 07/05/2026
trn_rcms_caseid = 19252000007840
isadjourn = NO
pre_case_purpose = 18678000000000
adjourn_type = 0
court_code = 10775
case_no = 2024/52
adjourn_remark = 
next_hear_date = 21/05/2026
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=13560000011121
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = c
trn_rcms_caseid=19252000007840
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
court_code=10775
Param Type = c
case_no=2024/52
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,isadjourn,pre_case_purpose,adjourn_type,court_code,case_no,adjourn_remark,next_hear_date,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,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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 3
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 = 2
RecordId = 13560000011122
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
court_code = 10775
adjourn_type = 0
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 21/05/2026
trn_rcms_caseid = 14105000011078
pre_case_purpose = 18678000000000
case_no = 2025/282
pre_hear_date = 07/05/2026
adjourn_remark = 
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=13560000011122
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10775
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/05/2026 00:00:00
Param Type = c
trn_rcms_caseid=14105000011078
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2025/282
Param Type = c
pre_hear_date=07/05/2026 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,court_code,adjourn_type,isadjourn,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_case_purpose,case_no,pre_hear_date,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:adjourn_type,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:pre_case_purpose,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 3
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 = 1
RecordId = 13560000011123
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 07/05/2026
pre_case_purpose = 18678000000000
trn_rcms_caseid = 15273000009667
court_code = 10775
case_no = 2025/31
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 21/05/2026
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=13560000011123
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=15273000009667
Param Type = c
court_code=10775
Param Type = c
case_no=2025/31
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/05/2026 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,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 = 3
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 = 1
RecordId = 13560000011124
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 21/05/2026
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2025/338
court_code = 10775
trn_rcms_caseid = 17487000012297
pre_case_purpose = 18678000000000
pre_hear_date = 07/05/2026
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=13560000011124
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/05/2026 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=2025/338
Param Type = c
court_code=10775
Param Type = c
trn_rcms_caseid=17487000012297
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=07/05/2026 00:00:00
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,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 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 13560000011125
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
new_case_purpose = 18678000000000
next_hear_date = 21/05/2026
trn_rcms_caseid = 12722000011130
pre_hear_date = 07/05/2026
pre_case_purpose = 18678000000000
case_no = 2025/354
court_code = 10775
adjourn_remark = 
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=13560000011125
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
trn_rcms_caseid=12722000011130
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2025/354
Param Type = c
court_code=10775
Param Type = c
isadjourn=NO
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,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,court_code,adjourn_remark,isadjourn,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,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,null,:isadjourn,:adjourn_type,:trn_rcms_hearingrow)

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

Time elapsed = 2
RecordId = 13560000011126
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
pre_hear_date = 07/05/2026
pre_case_purpose = 18678000000000
trn_rcms_caseid = 18297000011519
court_code = 10775
case_no = 2025/369
isadjourn = NO
adjourn_type = 0
next_hear_date = 21/05/2026
adjourn_remark = 
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=13560000011126
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=18297000011519
Param Type = c
court_code=10775
Param Type = c
case_no=2025/369
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
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,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_type,next_hear_date,adjourn_remark,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,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,: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 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 13560000011127
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_case_purpose = 18678000000000
court_code = 10775
pre_hear_date = 07/05/2026
case_no = 2025/370
trn_rcms_caseid = 18610000010355
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 21/05/2026
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=13560000011127
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:07
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=10775
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = c
case_no=2025/370
Param Type = c
trn_rcms_caseid=18610000010355
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/05/2026 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,pre_case_purpose,court_code,pre_hear_date,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 3
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 = 2
RecordId = 13560000011128
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark = 
new_case_purpose = 18678000000000
adjourn_type = 0
isadjourn = NO
next_hear_date = 21/05/2026
pre_case_purpose = 18678000000000
case_no = 2025/372
court_code = 10775
pre_hear_date = 07/05/2026
trn_rcms_caseid = 19038000012497
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=13560000011128
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:08
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:08
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
isadjourn=NO
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2025/372
Param Type = c
court_code=10775
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = c
trn_rcms_caseid=19038000012497
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,new_case_purpose,adjourn_type,isadjourn,next_hear_date,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,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,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 2
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 = 1
RecordId = 13560000011129
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_remark = 
trn_rcms_caseid = 11050000011930
pre_hear_date = 07/05/2026
court_code = 10775
case_no = 2025/377
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 21/05/2026
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=13560000011129
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:08
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=11050000011930
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = c
court_code=10775
Param Type = c
case_no=2025/377
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=21/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 2
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 = 1
RecordId = 13560000011130
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 16824000011260
case_no = 2025/386
pre_hear_date = 07/05/2026
next_hear_date = 21/05/2026
new_case_purpose = 18678000000000
isadjourn = NO
court_code = 10775
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=13560000011130
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:08
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=16824000011260
Param Type = c
case_no=2025/386
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
court_code=10775
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3
Adding new record to store data from Frame 2, Row 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 13560000011131
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 11682000009957
pre_hear_date = 07/05/2026
court_code = 10775
case_no = 2025/50
next_hear_date = 21/05/2026
isadjourn = NO
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=13560000011131
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:08
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=11682000009957
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = c
court_code=10775
Param Type = c
case_no=2025/50
Param Type = c
next_hear_date=21/05/2026 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=27
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 = 2
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 = 1
RecordId = 13560000011132
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
trn_rcms_caseid = 12500000009650
pre_hear_date = 07/05/2026
pre_case_purpose = 18678000000000
case_no = 2025/94
next_hear_date = 21/05/2026
new_case_purpose = 18678000000000
court_code = 10775
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=13560000011132
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:08
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:08
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=12500000009650
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2025/94
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
court_code=10775
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,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 = 3
Adding new record to store data from Frame 2, Row 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 13560000011133
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
isadjourn = NO
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 10763000011719
case_no = 2026/100
court_code = 10775
pre_hear_date = 07/05/2026
next_hear_date = 21/05/2026
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=13560000011133
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:08
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:08
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=10763000011719
Param Type = c
case_no=2026/100
Param Type = c
court_code=10775
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
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,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 = 2
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 = 1
RecordId = 13560000011134
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
next_hear_date = 21/05/2026
case_no = 2026/114
court_code = 10775
trn_rcms_caseid = 13150000011881
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 07/05/2026
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=13560000011134
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:08
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:08
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=21/05/2026 00:00:00
Param Type = c
case_no=2026/114
Param Type = c
court_code=10775
Param Type = c
trn_rcms_caseid=13150000011881
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=07/05/2026 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,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 = 2
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 = 1
RecordId = 13560000011135
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 21/05/2026
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 11680000011771
case_no = 2026/4
court_code = 10775
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 07/05/2026
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=13560000011135
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:08
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=11680000011771
Param Type = c
case_no=2026/4
Param Type = c
court_code=10775
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=07/05/2026 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,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 = 2
Adding new record to store data from Frame 2, Row 32 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 13560000011136
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 21/05/2026
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 18678000000000
case_no = 2026/6
court_code = 10775
trn_rcms_caseid = 12191000011174
pre_case_purpose = 18678000000000
pre_hear_date = 07/05/2026
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=13560000011136
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:08
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/05/2026 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
case_no=2026/6
Param Type = c
court_code=10775
Param Type = c
trn_rcms_caseid=12191000011174
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=32
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 33 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 13560000011137
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
next_hear_date = 21/05/2026
new_case_purpose = 18678000000000
adjourn_remark = 
adjourn_type = 0
isadjourn = NO
case_no = 2026/89
court_code = 10775
trn_rcms_caseid = 15480000012330
pre_case_purpose = 18678000000000
pre_hear_date = 07/05/2026
TRN_RCMS_HEARINGrow = 33
Posting record
Param Type = n
trn_rcms_hearingid=13560000011137
Param Type = n
trn_rcms_mhearingid=13560000011104
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:08
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/05/2026 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=2026/89
Param Type = c
court_code=10775
Param Type = c
trn_rcms_caseid=15480000012330
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=07/05/2026 00:00:00
Param Type = n
trn_rcms_hearingrow=33
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 = 3988004046952

>>Executing genmaps

>>Posting from trcmf to tchdh from row 1

>>Mapping
Mapped court_code Row = 1 value = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 353410 idvalue 0
Mapped case_no Row = 1 value = 2011/00062 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 353410
case_no = 2011/00062
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 3
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
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 = 1
RecordId = 13560000011138
MapName trcmf1
SourceId 13560000011105
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2011/00062
trn_rcms_caseregid = 353410
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011138
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011105
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:08
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:08
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/05/2026 00:00:00
Param Type = c
case_no=2011/00062
Param Type = c
trn_rcms_caseregid=353410
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 353492 idvalue 0
Mapped case_no Row = 1 value = 2012/00115 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 21/05/2026 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 = 10775
trn_rcms_caseregid = 353492
case_no = 2012/00115
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purposename=???
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 2
RecordId = 13560000011139
MapName trcmf1
SourceId 13560000011106
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 21/05/2026
case_no = 2012/00115
trn_rcms_caseregid = 353492
court_code = 10775
case_purpose = 18473000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011139
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011106
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:09
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=21/05/2026 00:00:00
Param Type = c
case_no=2012/00115
Param Type = c
trn_rcms_caseregid=353492
Param Type = c
court_code=10775
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 352806 idvalue 0
Mapped case_no Row = 1 value = 2013/00005 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 352806
case_no = 2013/00005
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 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 = 1
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 = 1
RecordId = 13560000011140
MapName trcmf1
SourceId 13560000011107
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2013/00005
trn_rcms_caseregid = 352806
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011140
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011107
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:10
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:10
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/05/2026 00:00:00
Param Type = c
case_no=2013/00005
Param Type = c
trn_rcms_caseregid=352806
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 353221 idvalue 0
Mapped case_no Row = 1 value = 2013/00066 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 353221
case_no = 2013/00066
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 13560000011141
MapName trcmf1
SourceId 13560000011108
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2013/00066
trn_rcms_caseregid = 353221
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011141
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011108
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:11
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:11
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/05/2026 00:00:00
Param Type = c
case_no=2013/00066
Param Type = c
trn_rcms_caseregid=353221
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12853000003665 idvalue 0
Mapped case_no Row = 1 value = 2019/00215 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 12853000003665
case_no = 2019/00215
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
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 = 2
RecordId = 13560000011142
MapName trcmf1
SourceId 13560000011109
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 1
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2019/00215
trn_rcms_caseregid = 12853000003665
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011142
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011109
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:12
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:12
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/05/2026 00:00:00
Param Type = c
case_no=2019/00215
Param Type = c
trn_rcms_caseregid=12853000003665
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16972000002532 idvalue 0
Mapped case_no Row = 1 value = 2019/00076 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 21/05/2026 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 = 10775
trn_rcms_caseregid = 16972000002532
case_no = 2019/00076
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 2
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
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 = 1
RecordId = 13560000011143
MapName trcmf1
SourceId 13560000011110
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 21/05/2026
case_no = 2019/00076
trn_rcms_caseregid = 16972000002532
court_code = 10775
case_purpose = 18473000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011143
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011110
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:12
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=21/05/2026 00:00:00
Param Type = c
case_no=2019/00076
Param Type = c
trn_rcms_caseregid=16972000002532
Param Type = c
court_code=10775
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19267000002702 idvalue 0
Mapped case_no Row = 1 value = 2019/00118 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 21/05/2026 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 = 10775
trn_rcms_caseregid = 19267000002702
case_no = 2019/00118
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
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 = 1
RecordId = 13560000011144
MapName trcmf1
SourceId 13560000011111
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 21/05/2026
case_no = 2019/00118
trn_rcms_caseregid = 19267000002702
court_code = 10775
case_purpose = 18473000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011144
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011111
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:13
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=21/05/2026 00:00:00
Param Type = c
case_no=2019/00118
Param Type = c
trn_rcms_caseregid=19267000002702
Param Type = c
court_code=10775
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13538000006377 idvalue 0
Mapped case_no Row = 1 value = 2021/116 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 13538000006377
case_no = 2021/116
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 3
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 = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 13560000011145
MapName trcmf1
SourceId 13560000011112
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 1
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2021/116
trn_rcms_caseregid = 13538000006377
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011145
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011112
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:14
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:14
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/05/2026 00:00:00
Param Type = c
case_no=2021/116
Param Type = c
trn_rcms_caseregid=13538000006377
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14679000005682 idvalue 0
Mapped case_no Row = 1 value = 2021/118 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 14679000005682
case_no = 2021/118
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 13560000011146
MapName trcmf1
SourceId 13560000011113
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2021/118
trn_rcms_caseregid = 14679000005682
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011146
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011113
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:15
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:15
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/05/2026 00:00:00
Param Type = c
case_no=2021/118
Param Type = c
trn_rcms_caseregid=14679000005682
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12545000007558 idvalue 0
Mapped case_no Row = 1 value = 2023/158 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 12545000007558
case_no = 2023/158
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 13560000011147
MapName trcmf1
SourceId 13560000011114
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2023/158
trn_rcms_caseregid = 12545000007558
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011147
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011114
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:15
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:15
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/05/2026 00:00:00
Param Type = c
case_no=2023/158
Param Type = c
trn_rcms_caseregid=12545000007558
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13185000007498 idvalue 0
Mapped case_no Row = 1 value = 2023/25 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 13185000007498
case_no = 2023/25
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
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 = 1
RecordId = 13560000011148
MapName trcmf1
SourceId 13560000011115
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2023/25
trn_rcms_caseregid = 13185000007498
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011148
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011115
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:16
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:16
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/05/2026 00:00:00
Param Type = c
case_no=2023/25
Param Type = c
trn_rcms_caseregid=13185000007498
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11807000007828 idvalue 0
Mapped case_no Row = 1 value = 2023/90 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 11807000007828
case_no = 2023/90
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 13560000011149
MapName trcmf1
SourceId 13560000011116
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2023/90
trn_rcms_caseregid = 11807000007828
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011149
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011116
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:17
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/05/2026 00:00:00
Param Type = c
case_no=2023/90
Param Type = c
trn_rcms_caseregid=11807000007828
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18421000008167 idvalue 0
Mapped case_no Row = 1 value = 2023/175 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 21/05/2026 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 = 10775
trn_rcms_caseregid = 18421000008167
case_no = 2023/175
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 3
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 2
RecordId = 13560000011150
MapName trcmf1
SourceId 13560000011117
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 21/05/2026
case_no = 2023/175
trn_rcms_caseregid = 18421000008167
court_code = 10775
case_purpose = 18473000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011150
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011117
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:18
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=21/05/2026 00:00:00
Param Type = c
case_no=2023/175
Param Type = c
trn_rcms_caseregid=18421000008167
Param Type = c
court_code=10775
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10284000007769 idvalue 0
Mapped case_no Row = 1 value = 2023/59 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 21/05/2026 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 = 10775
trn_rcms_caseregid = 10284000007769
case_no = 2023/59
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 1
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 = 1
RecordId = 13560000011151
MapName trcmf1
SourceId 13560000011118
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 21/05/2026
case_no = 2023/59
trn_rcms_caseregid = 10284000007769
court_code = 10775
case_purpose = 18473000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011151
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011118
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:18
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:18
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=21/05/2026 00:00:00
Param Type = c
case_no=2023/59
Param Type = c
trn_rcms_caseregid=10284000007769
Param Type = c
court_code=10775
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19709000007273 idvalue 0
Mapped case_no Row = 1 value = 2024/28 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 19709000007273
case_no = 2024/28
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 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 = 1
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 = 1
RecordId = 13560000011152
MapName trcmf1
SourceId 13560000011119
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2024/28
trn_rcms_caseregid = 19709000007273
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011152
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011119
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:19
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:19
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/05/2026 00:00:00
Param Type = c
case_no=2024/28
Param Type = c
trn_rcms_caseregid=19709000007273
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15303000008751 idvalue 0
Mapped case_no Row = 1 value = 2024/48 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 15303000008751
case_no = 2024/48
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 13560000011153
MapName trcmf1
SourceId 13560000011120
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2024/48
trn_rcms_caseregid = 15303000008751
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011153
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011120
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:20
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:20
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/05/2026 00:00:00
Param Type = c
case_no=2024/48
Param Type = c
trn_rcms_caseregid=15303000008751
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19252000007840 idvalue 0
Mapped case_no Row = 1 value = 2024/52 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 19252000007840
case_no = 2024/52
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
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 = 2
RecordId = 13560000011154
MapName trcmf1
SourceId 13560000011121
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2024/52
trn_rcms_caseregid = 19252000007840
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011154
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011121
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:21
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/05/2026 00:00:00
Param Type = c
case_no=2024/52
Param Type = c
trn_rcms_caseregid=19252000007840
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14105000011078 idvalue 0
Mapped case_no Row = 1 value = 2025/282 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 14105000011078
case_no = 2025/282
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
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 = 1
RecordId = 13560000011155
MapName trcmf1
SourceId 13560000011122
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 1
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2025/282
trn_rcms_caseregid = 14105000011078
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011155
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011122
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:21
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/05/2026 00:00:00
Param Type = c
case_no=2025/282
Param Type = c
trn_rcms_caseregid=14105000011078
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15273000009667 idvalue 0
Mapped case_no Row = 1 value = 2025/31 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 15273000009667
case_no = 2025/31
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 13560000011156
MapName trcmf1
SourceId 13560000011123
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2025/31
trn_rcms_caseregid = 15273000009667
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011156
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011123
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:22
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:22
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/05/2026 00:00:00
Param Type = c
case_no=2025/31
Param Type = c
trn_rcms_caseregid=15273000009667
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17487000012297 idvalue 0
Mapped case_no Row = 1 value = 2025/338 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 17487000012297
case_no = 2025/338
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 13560000011157
MapName trcmf1
SourceId 13560000011124
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2025/338
trn_rcms_caseregid = 17487000012297
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011157
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011124
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:23
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:23
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/05/2026 00:00:00
Param Type = c
case_no=2025/338
Param Type = c
trn_rcms_caseregid=17487000012297
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12722000011130 idvalue 0
Mapped case_no Row = 1 value = 2025/354 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 12722000011130
case_no = 2025/354
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 1
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 = 1
RecordId = 13560000011158
MapName trcmf1
SourceId 13560000011125
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2025/354
trn_rcms_caseregid = 12722000011130
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011158
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011125
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:24
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/05/2026 00:00:00
Param Type = c
case_no=2025/354
Param Type = c
trn_rcms_caseregid=12722000011130
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18297000011519 idvalue 0
Mapped case_no Row = 1 value = 2025/369 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 18297000011519
case_no = 2025/369
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 13560000011159
MapName trcmf1
SourceId 13560000011126
Select sysdate as sdt from dual
Time elapsed = 1
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2025/369
trn_rcms_caseregid = 18297000011519
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011159
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011126
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:24
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/05/2026 00:00:00
Param Type = c
case_no=2025/369
Param Type = c
trn_rcms_caseregid=18297000011519
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18610000010355 idvalue 0
Mapped case_no Row = 1 value = 2025/370 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 18610000010355
case_no = 2025/370
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 13560000011160
MapName trcmf1
SourceId 13560000011127
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2025/370
trn_rcms_caseregid = 18610000010355
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011160
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011127
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:25
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/05/2026 00:00:00
Param Type = c
case_no=2025/370
Param Type = c
trn_rcms_caseregid=18610000010355
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19038000012497 idvalue 0
Mapped case_no Row = 1 value = 2025/372 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 19038000012497
case_no = 2025/372
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 13560000011161
MapName trcmf1
SourceId 13560000011128
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2025/372
trn_rcms_caseregid = 19038000012497
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011161
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011128
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:26
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:26
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/05/2026 00:00:00
Param Type = c
case_no=2025/372
Param Type = c
trn_rcms_caseregid=19038000012497
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11050000011930 idvalue 0
Mapped case_no Row = 1 value = 2025/377 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 11050000011930
case_no = 2025/377
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
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 = 1
RecordId = 13560000011162
MapName trcmf1
SourceId 13560000011129
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2025/377
trn_rcms_caseregid = 11050000011930
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011162
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011129
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:27
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:27
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/05/2026 00:00:00
Param Type = c
case_no=2025/377
Param Type = c
trn_rcms_caseregid=11050000011930
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16824000011260 idvalue 0
Mapped case_no Row = 1 value = 2025/386 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 16824000011260
case_no = 2025/386
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 1
RecordId = 13560000011163
MapName trcmf1
SourceId 13560000011130
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2025/386
trn_rcms_caseregid = 16824000011260
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011163
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011130
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:27
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:27
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/05/2026 00:00:00
Param Type = c
case_no=2025/386
Param Type = c
trn_rcms_caseregid=16824000011260
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11682000009957 idvalue 0
Mapped case_no Row = 1 value = 2025/50 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 11682000009957
case_no = 2025/50
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
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 = 1
RecordId = 13560000011164
MapName trcmf1
SourceId 13560000011131
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2025/50
trn_rcms_caseregid = 11682000009957
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011164
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011131
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:28
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:28
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/05/2026 00:00:00
Param Type = c
case_no=2025/50
Param Type = c
trn_rcms_caseregid=11682000009957
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12500000009650 idvalue 0
Mapped case_no Row = 1 value = 2025/94 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 12500000009650
case_no = 2025/94
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 13560000011165
MapName trcmf1
SourceId 13560000011132
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2025/94
trn_rcms_caseregid = 12500000009650
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011165
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011132
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:29
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/05/2026 00:00:00
Param Type = c
case_no=2025/94
Param Type = c
trn_rcms_caseregid=12500000009650
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10763000011719 idvalue 0
Mapped case_no Row = 1 value = 2026/100 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 10763000011719
case_no = 2026/100
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 13560000011166
MapName trcmf1
SourceId 13560000011133
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2026/100
trn_rcms_caseregid = 10763000011719
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011166
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011133
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:30
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:30
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/05/2026 00:00:00
Param Type = c
case_no=2026/100
Param Type = c
trn_rcms_caseregid=10763000011719
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13150000011881 idvalue 0
Mapped case_no Row = 1 value = 2026/114 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 13150000011881
case_no = 2026/114
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 2
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 = 2
RecordId = 13560000011167
MapName trcmf1
SourceId 13560000011134
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2026/114
trn_rcms_caseregid = 13150000011881
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011167
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011134
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:31
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:31
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/05/2026 00:00:00
Param Type = c
case_no=2026/114
Param Type = c
trn_rcms_caseregid=13150000011881
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11680000011771 idvalue 0
Mapped case_no Row = 1 value = 2026/4 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 11680000011771
case_no = 2026/4
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 1
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 2
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 = 1
RecordId = 13560000011168
MapName trcmf1
SourceId 13560000011135
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2026/4
trn_rcms_caseregid = 11680000011771
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011168
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011135
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:31
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:31
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/05/2026 00:00:00
Param Type = c
case_no=2026/4
Param Type = c
trn_rcms_caseregid=11680000011771
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 32

>>Mapping
Mapped court_code Row = 1 value = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12191000011174 idvalue 0
Mapped case_no Row = 1 value = 2026/6 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 12191000011174
case_no = 2026/6
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 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 = 2
RecordId = 13560000011169
MapName trcmf1
SourceId 13560000011136
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 = 21/05/2026
case_no = 2026/6
trn_rcms_caseregid = 12191000011174
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011169
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011136
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:32
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=21/05/2026 00:00:00
Param Type = c
case_no=2026/6
Param Type = c
trn_rcms_caseregid=12191000011174
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 33

>>Mapping
Mapped court_code Row = 1 value = 10775 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15480000012330 idvalue 0
Mapped case_no Row = 1 value = 2026/89 idvalue 0
Mapped prev_hearing_date Row = 1 value = 07/05/2026 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/05/2026 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 = 10775
trn_rcms_caseregid = 15480000012330
case_no = 2026/89
prev_hearing_date = 07/05/2026
hearing_date = 21/05/2026
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 = 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 = 2
RecordId = 13560000011170
MapName trcmf1
SourceId 13560000011137
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 21/05/2026
case_no = 2026/89
trn_rcms_caseregid = 15480000012330
court_code = 10775
case_purpose = 18678000000000
prev_hearing_date = 07/05/2026
Posting record
Param Type = n
trn_rcms_case_histid=13560000011170
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=13560000011137
Param Type = c
cancel=F
Param Type = c
createdby=RAA_tonk_R
Param Type = c
createdon=15/05/2026 10:54:33
Param Type = c
username=RAA_tonk_R
Param Type = c
modifiedon=15/05/2026 10:54:33
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/05/2026 00:00:00
Param Type = c
case_no=2026/89
Param Type = c
trn_rcms_caseregid=15480000012330
Param Type = c
court_code=10775
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=07/05/2026 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 = 3988004072942
Time elapsed for MD Map = 3988004072943
Time elapsed for Save History = 3988004072943
Time elapsed for Save Attachment = 3988004072944
Time elapsed for After Save WF Exec = 3988004072950
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"13560000011104"}]}
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=RAA_tonk_R
Param Type = c
calledon=15/05/2026 10:54:05
Param Type = c
callfinished=15/05/2026 10:54:32
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=27198
Param Type = n
dbtimetaken=26223
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