ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
<transaction username="SDO_Chauhtan_PRO" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>SDO_Chauhtan_PRO</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">10519</courtcode><hearing_date rowno="001">23/06/2025</hearing_date><axp_recid2 rowno="001">0</axp_recid2><court_code rowno="001">10519</court_code><case_no rowno="001">2023/664</case_no><trn_rcms_caseid rowno="001">17349000008658</trn_rcms_caseid><pre_case_purpose_name rowno="001">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="001">23/06/2025</pre_hear_date><pre_case_purpose rowno="001">1000497</pre_case_purpose><next_hear_date rowno="001">28/07/2025</next_hear_date><new_case_purpose rowno="001">1000497</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">10519</court_code><case_no rowno="002">2024/217</case_no><trn_rcms_caseid rowno="002">17891000009117</trn_rcms_caseid><pre_case_purpose_name rowno="002">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="002">23/06/2025</pre_hear_date><pre_case_purpose rowno="002">1000497</pre_case_purpose><next_hear_date rowno="002">28/07/2025</next_hear_date><new_case_purpose rowno="002">1000497</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">10519</court_code><case_no rowno="003">2024/218</case_no><trn_rcms_caseid rowno="003">17900000009349</trn_rcms_caseid><pre_case_purpose_name rowno="003">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="003">23/06/2025</pre_hear_date><pre_case_purpose rowno="003">1000497</pre_case_purpose><next_hear_date rowno="003">28/07/2025</next_hear_date><new_case_purpose rowno="003">1000497</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">10519</court_code><case_no rowno="004">2024/257</case_no><trn_rcms_caseid rowno="004">12966000009343</trn_rcms_caseid><pre_case_purpose_name rowno="004">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="004">23/06/2025</pre_hear_date><pre_case_purpose rowno="004">1000497</pre_case_purpose><next_hear_date rowno="004">26/06/2025</next_hear_date><new_case_purpose rowno="004">1000497</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">10519</court_code><case_no rowno="005">2024/275</case_no><trn_rcms_caseid rowno="005">18782000009390</trn_rcms_caseid><pre_case_purpose_name rowno="005">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="005">23/06/2025</pre_hear_date><pre_case_purpose rowno="005">1000497</pre_case_purpose><next_hear_date rowno="005">22/07/2025</next_hear_date><new_case_purpose rowno="005">1000497</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">10519</court_code><case_no rowno="006">2024/317</case_no><trn_rcms_caseid rowno="006">16106000008371</trn_rcms_caseid><pre_case_purpose_name rowno="006">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="006">23/06/2025</pre_hear_date><pre_case_purpose rowno="006">1000497</pre_case_purpose><next_hear_date rowno="006">28/07/2025</next_hear_date><new_case_purpose rowno="006">1000497</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">10519</court_code><case_no rowno="007">2024/364</case_no><trn_rcms_caseid rowno="007">19938000008175</trn_rcms_caseid><pre_case_purpose_name rowno="007">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="007">23/06/2025</pre_hear_date><pre_case_purpose rowno="007">1000497</pre_case_purpose><next_hear_date rowno="007">28/07/2025</next_hear_date><new_case_purpose rowno="007">1000497</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">10519</court_code><case_no rowno="008">2024/404</case_no><trn_rcms_caseid rowno="008">18712000009952</trn_rcms_caseid><pre_case_purpose_name rowno="008">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="008">23/06/2025</pre_hear_date><pre_case_purpose rowno="008">1000497</pre_case_purpose><next_hear_date rowno="008">15/07/2025</next_hear_date><new_case_purpose rowno="008">1000497</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">10519</court_code><case_no rowno="009">2024/433</case_no><trn_rcms_caseid rowno="009">14912000008774</trn_rcms_caseid><pre_case_purpose_name rowno="009">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="009">23/06/2025</pre_hear_date><pre_case_purpose rowno="009">1000497</pre_case_purpose><next_hear_date rowno="009">22/07/2025</next_hear_date><new_case_purpose rowno="009">1000497</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">10519</court_code><case_no rowno="0010">2024/434</case_no><trn_rcms_caseid rowno="0010">14933000009094</trn_rcms_caseid><pre_case_purpose_name rowno="0010">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="0010">23/06/2025</pre_hear_date><pre_case_purpose rowno="0010">1000497</pre_case_purpose><next_hear_date rowno="0010">22/07/2025</next_hear_date><new_case_purpose rowno="0010">1000497</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">10519</court_code><case_no rowno="0011">2024/453</case_no><trn_rcms_caseid rowno="0011">15499000009546</trn_rcms_caseid><pre_case_purpose_name rowno="0011">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="0011">23/06/2025</pre_hear_date><pre_case_purpose rowno="0011">1000497</pre_case_purpose><next_hear_date rowno="0011">15/07/2025</next_hear_date><new_case_purpose rowno="0011">1000497</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">10519</court_code><case_no rowno="0012">2024/492</case_no><trn_rcms_caseid rowno="0012">11443000009548</trn_rcms_caseid><pre_case_purpose_name rowno="0012">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="0012">23/06/2025</pre_hear_date><pre_case_purpose rowno="0012">1000497</pre_case_purpose><next_hear_date rowno="0012">22/07/2025</next_hear_date><new_case_purpose rowno="0012">1000497</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">10519</court_code><case_no rowno="0013">2025/9</case_no><trn_rcms_caseid rowno="0013">18796000008527</trn_rcms_caseid><pre_case_purpose_name rowno="0013">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="0013">23/06/2025</pre_hear_date><pre_case_purpose rowno="0013">1000497</pre_case_purpose><next_hear_date rowno="0013">22/07/2025</next_hear_date><new_case_purpose rowno="0013">1000497</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">10519</court_code><case_no rowno="0014">2023/159</case_no><trn_rcms_caseid rowno="0014">19964000007898</trn_rcms_caseid><pre_case_purpose_name rowno="0014">???? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="0014">23/06/2025</pre_hear_date><pre_case_purpose rowno="0014">12555000000002</pre_case_purpose><next_hear_date rowno="0014">26/06/2025</next_hear_date><new_case_purpose rowno="0014">12555000000002</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">10519</court_code><case_no rowno="0015">2024/391</case_no><trn_rcms_caseid rowno="0015">18133000008666</trn_rcms_caseid><pre_case_purpose_name rowno="0015">???? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="0015">23/06/2025</pre_hear_date><pre_case_purpose rowno="0015">12555000000002</pre_case_purpose><next_hear_date rowno="0015">28/07/2025</next_hear_date><new_case_purpose rowno="0015">12555000000002</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">10519</court_code><case_no rowno="0016">2021/219</case_no><trn_rcms_caseid rowno="0016">13183000006927</trn_rcms_caseid><pre_case_purpose_name rowno="0016">??????? ???? ???????</pre_case_purpose_name><pre_hear_date rowno="0016">23/06/2025</pre_hear_date><pre_case_purpose rowno="0016">18472000000000</pre_case_purpose><next_hear_date rowno="0016">15/07/2025</next_hear_date><new_case_purpose rowno="0016">18472000000000</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">10519</court_code><case_no rowno="0017">2023/206</case_no><trn_rcms_caseid rowno="0017">15269000007593</trn_rcms_caseid><pre_case_purpose_name rowno="0017">??????? ???? ???????</pre_case_purpose_name><pre_hear_date rowno="0017">23/06/2025</pre_hear_date><pre_case_purpose rowno="0017">18472000000000</pre_case_purpose><next_hear_date rowno="0017">15/07/2025</next_hear_date><new_case_purpose rowno="0017">18473000000000</new_case_purpose><isadjourn rowno="0017">NO</isadjourn><adjourn_type rowno="0017">0</adjourn_type><adjourn_remark rowno="0017"></adjourn_remark><axp_recid2 rowno="0018">0</axp_recid2><court_code rowno="0018">10519</court_code><case_no rowno="0018">2023/389</case_no><trn_rcms_caseid rowno="0018">10170000008691</trn_rcms_caseid><pre_case_purpose_name rowno="0018">??????? ???? ???????</pre_case_purpose_name><pre_hear_date rowno="0018">23/06/2025</pre_hear_date><pre_case_purpose rowno="0018">18472000000000</pre_case_purpose><next_hear_date rowno="0018">22/07/2025</next_hear_date><new_case_purpose rowno="0018">18472000000000</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">10519</court_code><case_no rowno="0019">2024/192</case_no><trn_rcms_caseid rowno="0019">10496000008210</trn_rcms_caseid><pre_case_purpose_name rowno="0019">??????? ???? ???????</pre_case_purpose_name><pre_hear_date rowno="0019">23/06/2025</pre_hear_date><pre_case_purpose rowno="0019">18472000000000</pre_case_purpose><next_hear_date rowno="0019">22/07/2025</next_hear_date><new_case_purpose rowno="0019">18472000000000</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">10519</court_code><case_no rowno="0020">2024/74</case_no><trn_rcms_caseid rowno="0020">13740000008811</trn_rcms_caseid><pre_case_purpose_name rowno="0020">??????? ???? ???????</pre_case_purpose_name><pre_hear_date rowno="0020">23/06/2025</pre_hear_date><pre_case_purpose rowno="0020">18472000000000</pre_case_purpose><next_hear_date rowno="0020">15/07/2025</next_hear_date><new_case_purpose rowno="0020">18473000000000</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">10519</court_code><case_no rowno="0021">2025/59</case_no><trn_rcms_caseid rowno="0021">10006000009808</trn_rcms_caseid><pre_case_purpose_name rowno="0021">??????? ???? ???????</pre_case_purpose_name><pre_hear_date rowno="0021">23/06/2025</pre_hear_date><pre_case_purpose rowno="0021">18472000000000</pre_case_purpose><next_hear_date rowno="0021">28/07/2025</next_hear_date><new_case_purpose rowno="0021">18472000000000</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">10519</court_code><case_no rowno="0022">2023/139</case_no><trn_rcms_caseid rowno="0022">18794000007124</trn_rcms_caseid><pre_case_purpose_name rowno="0022">??????? ???????</pre_case_purpose_name><pre_hear_date rowno="0022">23/06/2025</pre_hear_date><pre_case_purpose rowno="0022">11417000000000</pre_case_purpose><next_hear_date rowno="0022">28/07/2025</next_hear_date><new_case_purpose rowno="0022">11417000000000</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">10519</court_code><case_no rowno="0023">2024/285</case_no><trn_rcms_caseid rowno="0023">18812000008182</trn_rcms_caseid><pre_case_purpose_name rowno="0023">??????? ???????</pre_case_purpose_name><pre_hear_date rowno="0023">23/06/2025</pre_hear_date><pre_case_purpose rowno="0023">11417000000000</pre_case_purpose><next_hear_date rowno="0023">15/07/2025</next_hear_date><new_case_purpose rowno="0023">11417000000000</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">10519</court_code><case_no rowno="0024">2024/452</case_no><trn_rcms_caseid rowno="0024">15491000009721</trn_rcms_caseid><pre_case_purpose_name rowno="0024">??????? ???????</pre_case_purpose_name><pre_hear_date rowno="0024">23/06/2025</pre_hear_date><pre_case_purpose rowno="0024">11417000000000</pre_case_purpose><next_hear_date rowno="0024">26/06/2025</next_hear_date><new_case_purpose rowno="0024">1000497</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">10519</court_code><case_no rowno="0025">2025/113</case_no><trn_rcms_caseid rowno="0025">12338000009349</trn_rcms_caseid><pre_case_purpose_name rowno="0025">??????? ???????</pre_case_purpose_name><pre_hear_date rowno="0025">23/06/2025</pre_hear_date><pre_case_purpose rowno="0025">11417000000000</pre_case_purpose><next_hear_date rowno="0025">28/07/2025</next_hear_date><new_case_purpose rowno="0025">11417000000000</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">10519</court_code><case_no rowno="0026">2025/156</case_no><trn_rcms_caseid rowno="0026">13281000009299</trn_rcms_caseid><pre_case_purpose_name rowno="0026">??????? ???????</pre_case_purpose_name><pre_hear_date rowno="0026">23/06/2025</pre_hear_date><pre_case_purpose rowno="0026">11417000000000</pre_case_purpose><next_hear_date rowno="0026">22/07/2025</next_hear_date><new_case_purpose rowno="0026">11417000000000</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">10519</court_code><case_no rowno="0027">2025/165</case_no><trn_rcms_caseid rowno="0027">17698000009964</trn_rcms_caseid><pre_case_purpose_name rowno="0027">??????? ???????</pre_case_purpose_name><pre_hear_date rowno="0027">23/06/2025</pre_hear_date><pre_case_purpose rowno="0027">11417000000000</pre_case_purpose><next_hear_date rowno="0027">28/07/2025</next_hear_date><new_case_purpose rowno="0027">11417000000000</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">10519</court_code><case_no rowno="0028">2023/158</case_no><trn_rcms_caseid rowno="0028">19954000007521</trn_rcms_caseid><pre_case_purpose_name rowno="0028">????</pre_case_purpose_name><pre_hear_date rowno="0028">23/06/2025</pre_hear_date><pre_case_purpose rowno="0028">18678000000000</pre_case_purpose><next_hear_date rowno="0028">26/06/2025</next_hear_date><new_case_purpose rowno="0028">1000490</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">10519</court_code><case_no rowno="0029">2024/383</case_no><trn_rcms_caseid rowno="0029">18453000008787</trn_rcms_caseid><pre_case_purpose_name rowno="0029">????</pre_case_purpose_name><pre_hear_date rowno="0029">23/06/2025</pre_hear_date><pre_case_purpose rowno="0029">18678000000000</pre_case_purpose><next_hear_date rowno="0029">28/07/2025</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">10519</court_code><case_no rowno="0030">2024/384</case_no><trn_rcms_caseid rowno="0030">18532000008623</trn_rcms_caseid><pre_case_purpose_name rowno="0030">????</pre_case_purpose_name><pre_hear_date rowno="0030">23/06/2025</pre_hear_date><pre_case_purpose rowno="0030">18678000000000</pre_case_purpose><next_hear_date rowno="0030">28/07/2025</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">10519</court_code><case_no rowno="0031">2023/425</case_no><trn_rcms_caseid rowno="0031">14639000008265</trn_rcms_caseid><pre_case_purpose_name rowno="0031">??????? ????????? ???? </pre_case_purpose_name><pre_hear_date rowno="0031">23/06/2025</pre_hear_date><pre_case_purpose rowno="0031">18469000000000</pre_case_purpose><next_hear_date rowno="0031">26/06/2025</next_hear_date><new_case_purpose rowno="0031">18469000000000</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">10519</court_code><case_no rowno="0032">2017/00105</case_no><trn_rcms_caseid rowno="0032">18815000001015</trn_rcms_caseid><pre_case_purpose_name rowno="0032">?????</pre_case_purpose_name><pre_hear_date rowno="0032">23/06/2025</pre_hear_date><pre_case_purpose rowno="0032">18479000000906</pre_case_purpose><next_hear_date rowno="0032">30/07/2025</next_hear_date><new_case_purpose rowno="0032">18479000000906</new_case_purpose><isadjourn rowno="0032">NO</isadjourn><adjourn_type rowno="0032">0</adjourn_type><adjourn_remark rowno="0032"></adjourn_remark></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"SDO_Chauhtan_PRO","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"trcmf","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtcode":"10519","hearing_date":"23/06/2025"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"court_code":"10519","case_no":"2023/664","trn_rcms_caseid":"17349000008658","pre_case_purpose_name":"???? ?????????","pre_hear_date":"23/06/2025","pre_case_purpose":"1000497","next_hear_date":"28/07/2025","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"002","text":"0","columns":{"court_code":"10519","case_no":"2024/217","trn_rcms_caseid":"17891000009117","pre_case_purpose_name":"???? ?????????","pre_hear_date":"23/06/2025","pre_case_purpose":"1000497","next_hear_date":"28/07/2025","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"003","text":"0","columns":{"court_code":"10519","case_no":"2024/218","trn_rcms_caseid":"17900000009349","pre_case_purpose_name":"???? ?????????","pre_hear_date":"23/06/2025","pre_case_purpose":"1000497","next_hear_date":"28/07/2025","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"004","text":"0","columns":{"court_code":"10519","case_no":"2024/257","trn_rcms_caseid":"12966000009343","pre_case_purpose_name":"???? ?????????","pre_hear_date":"23/06/2025","pre_case_purpose":"1000497","next_hear_date":"26/06/2025","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"005","text":"0","columns":{"court_code":"10519","case_no":"2024/275","trn_rcms_caseid":"18782000009390","pre_case_purpose_name":"???? ?????????","pre_hear_date":"23/06/2025","pre_case_purpose":"1000497","next_hear_date":"22/07/2025","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"006","text":"0","columns":{"court_code":"10519","case_no":"2024/317","trn_rcms_caseid":"16106000008371","pre_case_purpose_name":"???? ?????????","pre_hear_date":"23/06/2025","pre_case_purpose":"1000497","next_hear_date":"28/07/2025","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"007","text":"0","columns":{"court_code":"10519","case_no":"2024/364","trn_rcms_caseid":"19938000008175","pre_case_purpose_name":"???? ?????????","pre_hear_date":"23/06/2025","pre_case_purpose":"1000497","next_hear_date":"28/07/2025","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"008","text":"0","columns":{"court_code":"10519","case_no":"2024/404","trn_rcms_caseid":"18712000009952","pre_case_purpose_name":"???? ?????????","pre_hear_date":"23/06/2025","pre_case_purpose":"1000497","next_hear_date":"15/07/2025","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"009","text":"0","columns":{"court_code":"10519","case_no":"2024/433","trn_rcms_caseid":"14912000008774","pre_case_purpose_name":"???? ?????????","pre_hear_date":"23/06/2025","pre_case_purpose":"1000497","next_hear_date":"22/07/2025","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0010","text":"0","columns":{"court_code":"10519","case_no":"2024/434","trn_rcms_caseid":"14933000009094","pre_case_purpose_name":"???? ?????????","pre_hear_date":"23/06/2025","pre_case_purpose":"1000497","next_hear_date":"22/07/2025","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0011","text":"0","columns":{"court_code":"10519","case_no":"2024/453","trn_rcms_caseid":"15499000009546","pre_case_purpose_name":"???? ?????????","pre_hear_date":"23/06/2025","pre_case_purpose":"1000497","next_hear_date":"15/07/2025","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0012","text":"0","columns":{"court_code":"10519","case_no":"2024/492","trn_rcms_caseid":"11443000009548","pre_case_purpose_name":"???? ?????????","pre_hear_date":"23/06/2025","pre_case_purpose":"1000497","next_hear_date":"22/07/2025","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0013","text":"0","columns":{"court_code":"10519","case_no":"2025/9","trn_rcms_caseid":"18796000008527","pre_case_purpose_name":"???? ?????????","pre_hear_date":"23/06/2025","pre_case_purpose":"1000497","next_hear_date":"22/07/2025","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0014","text":"0","columns":{"court_code":"10519","case_no":"2023/159","trn_rcms_caseid":"19964000007898","pre_case_purpose_name":"???? ????????? ????","pre_hear_date":"23/06/2025","pre_case_purpose":"12555000000002","next_hear_date":"26/06/2025","new_case_purpose":"12555000000002","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0015","text":"0","columns":{"court_code":"10519","case_no":"2024/391","trn_rcms_caseid":"18133000008666","pre_case_purpose_name":"???? ????????? ????","pre_hear_date":"23/06/2025","pre_case_purpose":"12555000000002","next_hear_date":"28/07/2025","new_case_purpose":"12555000000002","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0016","text":"0","columns":{"court_code":"10519","case_no":"2021/219","trn_rcms_caseid":"13183000006927","pre_case_purpose_name":"??????? ???? ???????","pre_hear_date":"23/06/2025","pre_case_purpose":"18472000000000","next_hear_date":"15/07/2025","new_case_purpose":"18472000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0017","text":"0","columns":{"court_code":"10519","case_no":"2023/206","trn_rcms_caseid":"15269000007593","pre_case_purpose_name":"??????? ???? ???????","pre_hear_date":"23/06/2025","pre_case_purpose":"18472000000000","next_hear_date":"15/07/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0018","text":"0","columns":{"court_code":"10519","case_no":"2023/389","trn_rcms_caseid":"10170000008691","pre_case_purpose_name":"??????? ???? ???????","pre_hear_date":"23/06/2025","pre_case_purpose":"18472000000000","next_hear_date":"22/07/2025","new_case_purpose":"18472000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0019","text":"0","columns":{"court_code":"10519","case_no":"2024/192","trn_rcms_caseid":"10496000008210","pre_case_purpose_name":"??????? ???? ???????","pre_hear_date":"23/06/2025","pre_case_purpose":"18472000000000","next_hear_date":"22/07/2025","new_case_purpose":"18472000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0020","text":"0","columns":{"court_code":"10519","case_no":"2024/74","trn_rcms_caseid":"13740000008811","pre_case_purpose_name":"??????? ???? ???????","pre_hear_date":"23/06/2025","pre_case_purpose":"18472000000000","next_hear_date":"15/07/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0021","text":"0","columns":{"court_code":"10519","case_no":"2025/59","trn_rcms_caseid":"10006000009808","pre_case_purpose_name":"??????? ???? ???????","pre_hear_date":"23/06/2025","pre_case_purpose":"18472000000000","next_hear_date":"28/07/2025","new_case_purpose":"18472000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0022","text":"0","columns":{"court_code":"10519","case_no":"2023/139","trn_rcms_caseid":"18794000007124","pre_case_purpose_name":"??????? ???????","pre_hear_date":"23/06/2025","pre_case_purpose":"11417000000000","next_hear_date":"28/07/2025","new_case_purpose":"11417000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0023","text":"0","columns":{"court_code":"10519","case_no":"2024/285","trn_rcms_caseid":"18812000008182","pre_case_purpose_name":"??????? ???????","pre_hear_date":"23/06/2025","pre_case_purpose":"11417000000000","next_hear_date":"15/07/2025","new_case_purpose":"11417000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0024","text":"0","columns":{"court_code":"10519","case_no":"2024/452","trn_rcms_caseid":"15491000009721","pre_case_purpose_name":"??????? ???????","pre_hear_date":"23/06/2025","pre_case_purpose":"11417000000000","next_hear_date":"26/06/2025","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0025","text":"0","columns":{"court_code":"10519","case_no":"2025/113","trn_rcms_caseid":"12338000009349","pre_case_purpose_name":"??????? ???????","pre_hear_date":"23/06/2025","pre_case_purpose":"11417000000000","next_hear_date":"28/07/2025","new_case_purpose":"11417000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0026","text":"0","columns":{"court_code":"10519","case_no":"2025/156","trn_rcms_caseid":"13281000009299","pre_case_purpose_name":"??????? ???????","pre_hear_date":"23/06/2025","pre_case_purpose":"11417000000000","next_hear_date":"22/07/2025","new_case_purpose":"11417000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0027","text":"0","columns":{"court_code":"10519","case_no":"2025/165","trn_rcms_caseid":"17698000009964","pre_case_purpose_name":"??????? ???????","pre_hear_date":"23/06/2025","pre_case_purpose":"11417000000000","next_hear_date":"28/07/2025","new_case_purpose":"11417000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0028","text":"0","columns":{"court_code":"10519","case_no":"2023/158","trn_rcms_caseid":"19954000007521","pre_case_purpose_name":"????","pre_hear_date":"23/06/2025","pre_case_purpose":"18678000000000","next_hear_date":"26/06/2025","new_case_purpose":"1000490","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0029","text":"0","columns":{"court_code":"10519","case_no":"2024/383","trn_rcms_caseid":"18453000008787","pre_case_purpose_name":"????","pre_hear_date":"23/06/2025","pre_case_purpose":"18678000000000","next_hear_date":"28/07/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0030","text":"0","columns":{"court_code":"10519","case_no":"2024/384","trn_rcms_caseid":"18532000008623","pre_case_purpose_name":"????","pre_hear_date":"23/06/2025","pre_case_purpose":"18678000000000","next_hear_date":"28/07/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0031","text":"0","columns":{"court_code":"10519","case_no":"2023/425","trn_rcms_caseid":"14639000008265","pre_case_purpose_name":"??????? ????????? ???? ","pre_hear_date":"23/06/2025","pre_case_purpose":"18469000000000","next_hear_date":"26/06/2025","new_case_purpose":"18469000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0032","text":"0","columns":{"court_code":"10519","case_no":"2017/00105","trn_rcms_caseid":"18815000001015","pre_case_purpose_name":"?????","pre_hear_date":"23/06/2025","pre_case_purpose":"18479000000906","next_hear_date":"30/07/2025","new_case_purpose":"18479000000906","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}}]}]}}
Verifying username and password
User Name : SDO_Chauhtan_PRO
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=sdo_chauhtan_pro
Time elapsed = 31
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 13
Result : 
Verifying completed...
Page Access Category : 
User Name : sdo_chauhtan_pro
Select sysdate as sdt from dual
Time elapsed = 8
dt=25/06/2025 10:58:26
Select sysdate as sdt from dual
Time elapsed = 8
Select usergroup from AXUSERLEVELGROUPS WHERE (lower(username) =:U) and ((startdate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') >= startdate) or (startdate is null)) and ((enddate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') <= enddate) or (enddate is null))
U=sdo_chauhtan_pro
dt=25/06/2025 10:58:26
dt=25/06/2025 10:58:26
Time elapsed = 27
User Groups: court_admin
select userroles from axusergroups where groupname in ( 'court_admin' )
Time elapsed = 24
User Roles : court_admin
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 = 6
Step4
axprops\stm size:4235
Step4-123456
<root updatedon="18/06/2025 12:26:06" name="app" caption="app" appverno="10.1.0.0" updusername="" updatedby="admin"><props LocalNum="739"><app color="$00EBF5F4" font="Tahoma,8"/><head font="Tahoma,12,tfff" color="$00DDE8E7"/><gridhead color="$00FFE8E8" font=""/><gridrow oddrowcolor="$00FEFCFA" evenrowcolor="$00FEF3ED"></gridrow><imgsfolder>images\</imgsfolder><container color="$00E8F1F0"/><name fontname="" fontsize="" fontbold="" fontitalic="" fontunderline="" fontcolor="" fontstrikeout="">Generalized Court Management System</name><img></img><envvar><currency>INR</currency><millions>F</millions><siteno></siteno><oraerrfrom>500</oraerrfrom><oraerrto>250000</oraerrto><postauto>F</postauto><finyrst></finyrst><finyred></finyred><cursep></cursep></envvar><currencies><INR></INR></currencies><appvars><m_courtname value="" param="f" hidden="false"><l>firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})</l><l>m_courtname := sqlget({m2},{court_name})</l></m_courtname><m_courttype value="" param="f" hidden="false"><l>firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})</l><l>m_courttype := sqlget({m3},{court_type})</l></m_courttype><m_courtid value="" param="f" hidden="false"><l>firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})</l><l>m_courtid := sqlget({m4},{court_name_mastid})</l></m_courtid><login_userid value="" param="f" hidden="false"><l>firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})</l><l>login_userid := sqlget({m4},{axusersid})</l></login_userid><u_name value="" param="f" hidden="false"><l>firesql({m4},{select :username as uname from dual})</l><l>u_name := sqlget({m4},{uname})</l></u_name><m_courtcode value="" param="f" hidden="false"><l>firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})</l><l>m_courtcode := sqlget({m4},{COURT_CODE})</l></m_courtcode><m_statename value="" param="f" hidden="false"><l>firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})</l><l>m_statename := sqlget({m2},{STATE_NAME})</l></m_statename><m_distname value="" param="f" hidden="false"><l>firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})</l><l>m_distName := sqlget({m7},{DISTNAMEENG})</l></m_distname><m_courtcatid value="" param="f" hidden="false"><l>firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})</l><l>m_courtcatid := sqlget({m8},{COURT_CATEGOTY})</l></m_courtcatid><m_deptid value="" param="f" hidden="false"><l>firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})</l><l>m_deptid := sqlget({m4},{department_mastid})</l></m_deptid><m_courttypeid value="" param="f" hidden="false"><l>firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})</l><l>m_courttypeid := sqlget({m3},{court_type_mastid})</l></m_courttypeid><urole value="" param="f" hidden="false"><l>firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })</l><l>urole := sqlget({m4},{groupname})</l></urole><m_cutoffdt value="" param="f" hidden="false"><l>firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})</l><l>m_cutoffdt := sqlget({a1},{dd})</l></m_cutoffdt><m_offcount value="" param="f" hidden="false"><l>firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})</l><l>m_offcount := sqlget({P1},{ct})</l></m_offcount></appvars><readonlyprops readonly_fontcolor="clBlack" readonly_bgcolor="clWindow"/><gfont/><mail><host></host><port></port><userid></userid><password></password></mail><pwdsetting><maxlogintry>0</maxlogintry><pwdexpdays>0</pwdexpdays><pwdalertdays>0</pwdalertdays><pwdminchars>0</pwdminchars><pwdprevnos>0</pwdprevnos><ispwdalphanum>F</ispwdalphanum></pwdsetting></props></root>
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
   Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
   Calling function firesql
username=SDO_Chauhtan_PRO
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Chauhtan_PRO
Time elapsed = 11
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{court_name})
   Calling function sqlget
   Result of sqlget = ????? ???????, ?????,???? -???????
   Result = ????? ???????, ?????,???? -???????
   Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
   Calling function firesql
username=SDO_Chauhtan_PRO
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=SDO_Chauhtan_PRO
Time elapsed = 19
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type})
   Calling function sqlget
   Result of sqlget = SDO
   Result = SDO
   Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
   Calling function firesql
username=SDO_Chauhtan_PRO
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=SDO_Chauhtan_PRO
Time elapsed = 16
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{court_name_mastid})
   Calling function sqlget
   Result of sqlget = 13816000000066
   Result = 13816000000066
   Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})
   Calling function firesql
select a1.axusersid from axusers a1 where a1.username=:username
username=SDO_Chauhtan_PRO
Time elapsed = 11
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{axusersid})
   Calling function sqlget
   Result of sqlget = 1169010009531
   Result = 1169010009531
   Evaluating firesql({m4},{select :username as uname from dual})
   Calling function firesql
select :username as uname from dual
username=SDO_Chauhtan_PRO
Time elapsed = 11
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{uname})
   Calling function sqlget
   Result of sqlget = SDO_Chauhtan_PRO
   Result = SDO_Chauhtan_PRO
   Evaluating firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})
   Calling function firesql
select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=SDO_Chauhtan_PRO
Time elapsed = 30
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{COURT_CODE})
   Calling function sqlget
   Result of sqlget = 10519
   Result = 10519
   Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
   Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 12
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{STATE_NAME})
   Calling function sqlget
   Result of sqlget = ????????
   Result = ????????
   Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=SDO_Chauhtan_PRO
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Chauhtan_PRO
Time elapsed = 11
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m7},{DISTNAMEENG})
   Calling function sqlget
   Result of sqlget = Barmer
   Result = Barmer
   Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=SDO_Chauhtan_PRO
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=SDO_Chauhtan_PRO
Time elapsed = 18
   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=1169010009531
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1169010009531
Time elapsed = 14
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{department_mastid})
   Calling function sqlget
   Result of sqlget = 1579880000000
   Result = 1579880000000
   Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})
   Calling function firesql
select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1
username=SDO_Chauhtan_PRO
Time elapsed = 10
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type_mastid})
   Calling function sqlget
   Result of sqlget = 10823000000000
   Result = 10823000000000
   Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
   Calling function firesql
username=SDO_Chauhtan_PRO
select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username
username=SDO_Chauhtan_PRO
Time elapsed = 12
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{groupname})
   Calling function sqlget
   Result of sqlget = court_admin
   Result = court_admin
   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 = 10
   Result of firesql = 
   Result = 
   Evaluating  sqlget({a1},{dd})
   Calling function sqlget
   Result of sqlget = 30/01/2021
   Result = 30/01/2021
   Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
   Calling function firesql
username=SDO_Chauhtan_PRO
SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0
username=SDO_Chauhtan_PRO
Time elapsed = 34
   Result of firesql = 
   Result = 
   Evaluating  sqlget({P1},{ct})
   Calling function sqlget
   Result of sqlget = 12
   Result = 12
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_admin') and lower(sname)='trcmf' and stype = 't' )

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

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

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

Time elapsed = 5
Reading data from stream

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

Paramval : trcmf
ParamTYpe : c
Param List : name

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

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

Paramval : tchdh
ParamTYpe : c
Param List : name

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

Time elapsed = 4
Step4
tstructs\stm size:1907
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tchdh
adxinout=o
Time elapsed = 7
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 8
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 = 10519
hearing_date = 23/06/2025
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 = 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 = 9
RecordId = 15286000011558
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 8
hearing_date = 23/06/2025
courtcode = 10519
Posting record
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:58:27
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:58:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=23/06/2025 00:00:00
Param Type = c
courtcode=10519
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)

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

Time elapsed = 7
RecordId = 15286000011559
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 18
next_hear_date = 28/07/2025
new_case_purpose = 1000497
isadjourn = NO
adjourn_type = 0
adjourn_remark = 
case_no = 2023/664
court_code = 10519
trn_rcms_caseid = 17349000008658
pre_case_purpose = 1000497
pre_hear_date = 23/06/2025
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=15286000011559
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:58:27
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:58:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/07/2025 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/664
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=17349000008658
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_type,adjourn_remark,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,:adjourn_type,null,: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 = 13
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 = 6
RecordId = 15286000011560
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 28/07/2025
new_case_purpose = 1000497
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2024/217
court_code = 10519
trn_rcms_caseid = 17891000009117
pre_case_purpose = 1000497
pre_hear_date = 23/06/2025
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=15286000011560
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:07
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:07
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/07/2025 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/217
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=17891000009117
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 5
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 = 7
RecordId = 15286000011561
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 8
pre_hear_date = 23/06/2025
pre_case_purpose = 1000497
trn_rcms_caseid = 17900000009349
court_code = 10519
case_no = 2024/218
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 28/07/2025
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=15286000011561
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:08
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=17900000009349
Param Type = c
court_code=10519
Param Type = c
case_no=2024/218
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=28/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 8
RecordId = 15286000011562
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 24
pre_hear_date = 23/06/2025
pre_case_purpose = 1000497
trn_rcms_caseid = 12966000009343
court_code = 10519
case_no = 2024/257
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 26/06/2025
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=15286000011562
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:08
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=12966000009343
Param Type = c
court_code=10519
Param Type = c
case_no=2024/257
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=26/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 7
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 = 8
RecordId = 15286000011563
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 22/07/2025
new_case_purpose = 1000497
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2024/275
court_code = 10519
trn_rcms_caseid = 18782000009390
pre_case_purpose = 1000497
pre_hear_date = 23/06/2025
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=15286000011563
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:08
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/275
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=18782000009390
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 17
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 = 7
RecordId = 15286000011564
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 12
next_hear_date = 28/07/2025
new_case_purpose = 1000497
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2024/317
court_code = 10519
trn_rcms_caseid = 16106000008371
pre_case_purpose = 1000497
pre_hear_date = 23/06/2025
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=15286000011564
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:08
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/07/2025 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/317
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=16106000008371
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 14
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 = 12
RecordId = 15286000011565
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 25
adjourn_type = 0
adjourn_remark = 
pre_case_purpose = 1000497
new_case_purpose = 1000497
next_hear_date = 28/07/2025
isadjourn = NO
trn_rcms_caseid = 19938000008175
pre_hear_date = 23/06/2025
court_code = 10519
case_no = 2024/364
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=15286000011565
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:08
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=1000497
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=28/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=19938000008175
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = c
court_code=10519
Param Type = c
case_no=2024/364
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,adjourn_type,adjourn_remark,pre_case_purpose,new_case_purpose,next_hear_date,isadjourn,trn_rcms_caseid,pre_hear_date,court_code,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_hearingrow)

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

Time elapsed = 9
RecordId = 15286000011566
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 8
case_no = 2024/404
court_code = 10519
adjourn_remark = 
new_case_purpose = 1000497
next_hear_date = 15/07/2025
isadjourn = NO
adjourn_type = 0
trn_rcms_caseid = 18712000009952
pre_hear_date = 23/06/2025
pre_case_purpose = 1000497
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=15286000011566
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:08
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2024/404
Param Type = c
court_code=10519
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=15/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18712000009952
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,court_code,adjourn_remark,new_case_purpose,next_hear_date,isadjourn,adjourn_type,trn_rcms_caseid,pre_hear_date,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:court_code,null,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 6
RecordId = 15286000011567
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 6
new_case_purpose = 1000497
pre_case_purpose = 1000497
isadjourn = NO
next_hear_date = 22/07/2025
pre_hear_date = 23/06/2025
court_code = 10519
adjourn_type = 0
trn_rcms_caseid = 14912000008774
case_no = 2024/433
adjourn_remark = 
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=15286000011567
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:08
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000497
Param Type = n
pre_case_purpose=1000497
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = c
court_code=10519
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=14912000008774
Param Type = c
case_no=2024/433
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,new_case_purpose,pre_case_purpose,isadjourn,next_hear_date,pre_hear_date,court_code,adjourn_type,trn_rcms_caseid,case_no,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,:new_case_purpose,:pre_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:adjourn_type,:trn_rcms_caseid,:case_no,null,:trn_rcms_hearingrow)

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

Time elapsed = 7
RecordId = 15286000011568
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 12
trn_rcms_caseid = 14933000009094
adjourn_remark = 
court_code = 10519
case_no = 2024/434
next_hear_date = 22/07/2025
isadjourn = NO
new_case_purpose = 1000497
pre_case_purpose = 1000497
pre_hear_date = 23/06/2025
adjourn_type = 0
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=15286000011568
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:08
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=14933000009094
Param Type = c
court_code=10519
Param Type = c
case_no=2024/434
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,adjourn_remark,court_code,case_no,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,null,:court_code,:case_no,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'),:adjourn_type,:trn_rcms_hearingrow)

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

Time elapsed = 7
RecordId = 15286000011569
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 7
case_no = 2024/453
new_case_purpose = 1000497
pre_case_purpose = 1000497
trn_rcms_caseid = 15499000009546
pre_hear_date = 23/06/2025
adjourn_remark = 
court_code = 10519
adjourn_type = 0
next_hear_date = 15/07/2025
isadjourn = NO
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=15286000011569
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:08
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2024/453
Param Type = c
new_case_purpose=1000497
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=15499000009546
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = c
court_code=10519
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=15/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,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 = 12
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 = 7
RecordId = 15286000011570
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 18
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 23/06/2025
pre_case_purpose = 1000497
trn_rcms_caseid = 11443000009548
court_code = 10519
case_no = 2024/492
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 22/07/2025
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=15286000011570
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:08
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=11443000009548
Param Type = c
court_code=10519
Param Type = c
case_no=2024/492
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 7
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 = 8
RecordId = 15286000011571
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 23/06/2025
pre_case_purpose = 1000497
trn_rcms_caseid = 18796000008527
court_code = 10519
case_no = 2025/9
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000497
next_hear_date = 22/07/2025
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=15286000011571
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:09
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
pre_case_purpose=1000497
Param Type = c
trn_rcms_caseid=18796000008527
Param Type = c
court_code=10519
Param Type = c
case_no=2025/9
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 7
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 = 6
RecordId = 15286000011572
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 8
next_hear_date = 26/06/2025
new_case_purpose = 12555000000002
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2023/159
court_code = 10519
trn_rcms_caseid = 19964000007898
pre_case_purpose = 12555000000002
pre_hear_date = 23/06/2025
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=15286000011572
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:09
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=26/06/2025 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/159
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=19964000007898
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=14
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 20
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 = 8
RecordId = 15286000011573
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 19
next_hear_date = 28/07/2025
new_case_purpose = 12555000000002
adjourn_remark = 
isadjourn = NO
adjourn_type = 0
case_no = 2024/391
court_code = 10519
trn_rcms_caseid = 18133000008666
pre_case_purpose = 12555000000002
pre_hear_date = 23/06/2025
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=15286000011573
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:09
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/07/2025 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/391
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=18133000008666
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_remark,isadjourn,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,null,:isadjourn,: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 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 10
RecordId = 15286000011574
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 16
Select sysdate as sdt from dual
Time elapsed = 27
pre_hear_date = 23/06/2025
trn_rcms_caseid = 13183000006927
isadjourn = NO
pre_case_purpose = 18472000000000
adjourn_type = 0
court_code = 10519
case_no = 2021/219
adjourn_remark = 
next_hear_date = 15/07/2025
new_case_purpose = 18472000000000
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=15286000011574
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:09
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = c
trn_rcms_caseid=13183000006927
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
adjourn_type=0
Param Type = c
court_code=10519
Param Type = c
case_no=2021/219
Param Type = c
next_hear_date=15/07/2025 00:00:00
Param Type = c
new_case_purpose=18472000000000
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,isadjourn,pre_case_purpose,adjourn_type,court_code,case_no,adjourn_remark,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 = 10
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 = 10
RecordId = 15286000011575
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
court_code = 10519
adjourn_type = 0
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 15/07/2025
trn_rcms_caseid = 15269000007593
pre_case_purpose = 18472000000000
case_no = 2023/206
pre_hear_date = 23/06/2025
adjourn_remark = 
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=15286000011575
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:09
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10519
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=15/07/2025 00:00:00
Param Type = c
trn_rcms_caseid=15269000007593
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
case_no=2023/206
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 14
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 = 10
RecordId = 15286000011576
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 10
pre_hear_date = 23/06/2025
pre_case_purpose = 18472000000000
trn_rcms_caseid = 10170000008691
court_code = 10519
case_no = 2023/389
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18472000000000
next_hear_date = 22/07/2025
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=15286000011576
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:09
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
trn_rcms_caseid=10170000008691
Param Type = c
court_code=10519
Param Type = c
case_no=2023/389
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18472000000000
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 17
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 = 23
RecordId = 15286000011577
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 35
Select sysdate as sdt from dual
Time elapsed = 14
next_hear_date = 22/07/2025
new_case_purpose = 18472000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2024/192
court_code = 10519
trn_rcms_caseid = 10496000008210
pre_case_purpose = 18472000000000
pre_hear_date = 23/06/2025
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=15286000011577
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:09
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = c
new_case_purpose=18472000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/192
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=10496000008210
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 7
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 = 8
RecordId = 15286000011578
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 20
Select sysdate as sdt from dual
Time elapsed = 38
new_case_purpose = 18473000000000
next_hear_date = 15/07/2025
trn_rcms_caseid = 13740000008811
pre_hear_date = 23/06/2025
pre_case_purpose = 18472000000000
case_no = 2024/74
court_code = 10519
adjourn_remark = 
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=15286000011578
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:09
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=15/07/2025 00:00:00
Param Type = c
trn_rcms_caseid=13740000008811
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
case_no=2024/74
Param Type = c
court_code=10519
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 10
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 = 13
RecordId = 15286000011579
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 11
pre_hear_date = 23/06/2025
pre_case_purpose = 18472000000000
trn_rcms_caseid = 10006000009808
court_code = 10519
case_no = 2025/59
isadjourn = NO
adjourn_type = 0
next_hear_date = 28/07/2025
adjourn_remark = 
new_case_purpose = 18472000000000
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=15286000011579
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:09
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
pre_case_purpose=18472000000000
Param Type = c
trn_rcms_caseid=10006000009808
Param Type = c
court_code=10519
Param Type = c
case_no=2025/59
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=28/07/2025 00:00:00
Param Type = c
new_case_purpose=18472000000000
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,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 = 8
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 = 29
RecordId = 15286000011580
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 37
Select sysdate as sdt from dual
Time elapsed = 22
pre_case_purpose = 11417000000000
court_code = 10519
pre_hear_date = 23/06/2025
case_no = 2023/139
trn_rcms_caseid = 18794000007124
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 11417000000000
next_hear_date = 28/07/2025
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=15286000011580
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:10
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=11417000000000
Param Type = c
court_code=10519
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = c
case_no=2023/139
Param Type = c
trn_rcms_caseid=18794000007124
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=11417000000000
Param Type = c
next_hear_date=28/07/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 26
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 = 8
RecordId = 15286000011581
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 9
adjourn_remark = 
new_case_purpose = 11417000000000
adjourn_type = 0
isadjourn = NO
next_hear_date = 15/07/2025
pre_case_purpose = 11417000000000
case_no = 2024/285
court_code = 10519
pre_hear_date = 23/06/2025
trn_rcms_caseid = 18812000008182
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=15286000011581
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:10
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=11417000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=15/07/2025 00:00:00
Param Type = n
pre_case_purpose=11417000000000
Param Type = c
case_no=2024/285
Param Type = c
court_code=10519
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = c
trn_rcms_caseid=18812000008182
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,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 = 10
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 = 6
RecordId = 15286000011582
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 28
adjourn_remark = 
trn_rcms_caseid = 15491000009721
pre_hear_date = 23/06/2025
court_code = 10519
case_no = 2024/452
pre_case_purpose = 11417000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 1000497
next_hear_date = 26/06/2025
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=15286000011582
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:10
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=15491000009721
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = c
court_code=10519
Param Type = c
case_no=2024/452
Param Type = n
pre_case_purpose=11417000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000497
Param Type = c
next_hear_date=26/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 7
RecordId = 15286000011583
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 12
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 12338000009349
case_no = 2025/113
pre_hear_date = 23/06/2025
next_hear_date = 28/07/2025
new_case_purpose = 11417000000000
isadjourn = NO
court_code = 10519
pre_case_purpose = 11417000000000
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=15286000011583
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:10
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=12338000009349
Param Type = c
case_no=2025/113
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = c
next_hear_date=28/07/2025 00:00:00
Param Type = c
new_case_purpose=11417000000000
Param Type = c
isadjourn=NO
Param Type = c
court_code=10519
Param Type = n
pre_case_purpose=11417000000000
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,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 = 11
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 = 8
RecordId = 15286000011584
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 25
Select sysdate as sdt from dual
Time elapsed = 10
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 13281000009299
pre_hear_date = 23/06/2025
court_code = 10519
case_no = 2025/156
next_hear_date = 22/07/2025
isadjourn = NO
pre_case_purpose = 11417000000000
new_case_purpose = 11417000000000
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=15286000011584
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:10
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13281000009299
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = c
court_code=10519
Param Type = c
case_no=2025/156
Param Type = c
next_hear_date=22/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=11417000000000
Param Type = c
new_case_purpose=11417000000000
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,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 = 13
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 = 8
RecordId = 15286000011585
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 27
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
trn_rcms_caseid = 17698000009964
pre_hear_date = 23/06/2025
pre_case_purpose = 11417000000000
case_no = 2025/165
next_hear_date = 28/07/2025
new_case_purpose = 11417000000000
court_code = 10519
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=15286000011585
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:10
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:10
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=17698000009964
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
pre_case_purpose=11417000000000
Param Type = c
case_no=2025/165
Param Type = c
next_hear_date=28/07/2025 00:00:00
Param Type = c
new_case_purpose=11417000000000
Param Type = c
court_code=10519
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,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 = 21
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 = 8
RecordId = 15286000011586
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 6
isadjourn = NO
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 19954000007521
case_no = 2023/158
court_code = 10519
pre_hear_date = 23/06/2025
next_hear_date = 26/06/2025
new_case_purpose = 1000490
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=15286000011586
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:10
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:10
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=19954000007521
Param Type = c
case_no=2023/158
Param Type = c
court_code=10519
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = c
next_hear_date=26/06/2025 00:00:00
Param Type = c
new_case_purpose=1000490
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_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 = 4
Adding new record to store data from Frame 2, Row 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 15286000011587
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
next_hear_date = 28/07/2025
case_no = 2024/383
court_code = 10519
trn_rcms_caseid = 18453000008787
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 23/06/2025
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=15286000011587
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:10
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=28/07/2025 00:00:00
Param Type = c
case_no=2024/383
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=18453000008787
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=29
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,case_no,court_code,trn_rcms_caseid,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 41
RecordId = 15286000011588
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 10
next_hear_date = 28/07/2025
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 18532000008623
case_no = 2024/384
court_code = 10519
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 23/06/2025
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=15286000011588
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:10
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=28/07/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18532000008623
Param Type = c
case_no=2024/384
Param Type = c
court_code=10519
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=23/06/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 = 5
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 = 7
RecordId = 15286000011589
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 26/06/2025
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 18469000000000
case_no = 2023/425
court_code = 10519
trn_rcms_caseid = 14639000008265
pre_case_purpose = 18469000000000
pre_hear_date = 23/06/2025
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=15286000011589
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:10
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=26/06/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18469000000000
Param Type = c
case_no=2023/425
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=14639000008265
Param Type = n
pre_case_purpose=18469000000000
Param Type = c
pre_hear_date=23/06/2025 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,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 = 6
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 = 8
RecordId = 15286000011590
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 32
next_hear_date = 30/07/2025
new_case_purpose = 18479000000906
adjourn_remark = 
adjourn_type = 0
isadjourn = NO
case_no = 2017/00105
court_code = 10519
trn_rcms_caseid = 18815000001015
pre_case_purpose = 18479000000906
pre_hear_date = 23/06/2025
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=15286000011590
Param Type = n
trn_rcms_mhearingid=15286000011558
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:11
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:11
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=30/07/2025 00:00:00
Param Type = c
new_case_purpose=18479000000906
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2017/00105
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=18815000001015
Param Type = n
pre_case_purpose=18479000000906
Param Type = c
pre_hear_date=23/06/2025 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,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 = 3960010754339

>>Executing genmaps

>>Posting from trcmf to tchdh from row 1

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17349000008658 idvalue 0
Mapped case_no Row = 1 value = 2023/664 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 28/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 17349000008658
case_no = 2023/664
prev_hearing_date = 23/06/2025
hearing_date = 28/07/2025
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purposename=???? ?????????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 6
RecordId = 15286000011591
MapName trcmf1
SourceId 15286000011559
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 28/07/2025
case_no = 2023/664
trn_rcms_caseregid = 17349000008658
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011591
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011559
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:11
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59: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=1000497
Param Type = c
hearing_date=28/07/2025 00:00:00
Param Type = c
case_no=2023/664
Param Type = c
trn_rcms_caseregid=17349000008658
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 2

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17891000009117 idvalue 0
Mapped case_no Row = 1 value = 2024/217 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 28/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 17891000009117
case_no = 2024/217
prev_hearing_date = 23/06/2025
hearing_date = 28/07/2025
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 6
RecordId = 15286000011592
MapName trcmf1
SourceId 15286000011560
Select sysdate as sdt from dual
Time elapsed = 28
Select sysdate as sdt from dual
Time elapsed = 16
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 28/07/2025
case_no = 2024/217
trn_rcms_caseregid = 17891000009117
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011592
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011560
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:17
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59: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=1000497
Param Type = c
hearing_date=28/07/2025 00:00:00
Param Type = c
case_no=2024/217
Param Type = c
trn_rcms_caseregid=17891000009117
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 3

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17900000009349 idvalue 0
Mapped case_no Row = 1 value = 2024/218 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 28/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 17900000009349
case_no = 2024/218
prev_hearing_date = 23/06/2025
hearing_date = 28/07/2025
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 11
RecordId = 15286000011593
MapName trcmf1
SourceId 15286000011561
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 28/07/2025
case_no = 2024/218
trn_rcms_caseregid = 17900000009349
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011593
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011561
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:23
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59: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=1000497
Param Type = c
hearing_date=28/07/2025 00:00:00
Param Type = c
case_no=2024/218
Param Type = c
trn_rcms_caseregid=17900000009349
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 4

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12966000009343 idvalue 0
Mapped case_no Row = 1 value = 2024/257 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 26/06/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 12966000009343
case_no = 2024/257
prev_hearing_date = 23/06/2025
hearing_date = 26/06/2025
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 6
RecordId = 15286000011594
MapName trcmf1
SourceId 15286000011562
Select sysdate as sdt from dual
Time elapsed = 19
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 26/06/2025
case_no = 2024/257
trn_rcms_caseregid = 12966000009343
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011594
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011562
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:28
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59: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=1000497
Param Type = c
hearing_date=26/06/2025 00:00:00
Param Type = c
case_no=2024/257
Param Type = c
trn_rcms_caseregid=12966000009343
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 5

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18782000009390 idvalue 0
Mapped case_no Row = 1 value = 2024/275 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 18782000009390
case_no = 2024/275
prev_hearing_date = 23/06/2025
hearing_date = 22/07/2025
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 9
RecordId = 15286000011595
MapName trcmf1
SourceId 15286000011563
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 22/07/2025
case_no = 2024/275
trn_rcms_caseregid = 18782000009390
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011595
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011563
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:33
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59: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=1000497
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2024/275
Param Type = c
trn_rcms_caseregid=18782000009390
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 6

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16106000008371 idvalue 0
Mapped case_no Row = 1 value = 2024/317 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 28/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 16106000008371
case_no = 2024/317
prev_hearing_date = 23/06/2025
hearing_date = 28/07/2025
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 6
RecordId = 15286000011596
MapName trcmf1
SourceId 15286000011564
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 28/07/2025
case_no = 2024/317
trn_rcms_caseregid = 16106000008371
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011596
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011564
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:37
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=28/07/2025 00:00:00
Param Type = c
case_no=2024/317
Param Type = c
trn_rcms_caseregid=16106000008371
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 7

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19938000008175 idvalue 0
Mapped case_no Row = 1 value = 2024/364 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 28/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 19938000008175
case_no = 2024/364
prev_hearing_date = 23/06/2025
hearing_date = 28/07/2025
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 6
RecordId = 15286000011597
MapName trcmf1
SourceId 15286000011565
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 28/07/2025
case_no = 2024/364
trn_rcms_caseregid = 19938000008175
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011597
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011565
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:42
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=28/07/2025 00:00:00
Param Type = c
case_no=2024/364
Param Type = c
trn_rcms_caseregid=19938000008175
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 8

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18712000009952 idvalue 0
Mapped case_no Row = 1 value = 2024/404 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 15/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 18712000009952
case_no = 2024/404
prev_hearing_date = 23/06/2025
hearing_date = 15/07/2025
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 11
RecordId = 15286000011598
MapName trcmf1
SourceId 15286000011566
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 43
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 15/07/2025
case_no = 2024/404
trn_rcms_caseregid = 18712000009952
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011598
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011566
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:46
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=15/07/2025 00:00:00
Param Type = c
case_no=2024/404
Param Type = c
trn_rcms_caseregid=18712000009952
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 9

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14912000008774 idvalue 0
Mapped case_no Row = 1 value = 2024/433 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 14912000008774
case_no = 2024/433
prev_hearing_date = 23/06/2025
hearing_date = 22/07/2025
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 6
RecordId = 15286000011599
MapName trcmf1
SourceId 15286000011567
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 22/07/2025
case_no = 2024/433
trn_rcms_caseregid = 14912000008774
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011599
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011567
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:50
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:50
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2024/433
Param Type = c
trn_rcms_caseregid=14912000008774
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 10

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14933000009094 idvalue 0
Mapped case_no Row = 1 value = 2024/434 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 14933000009094
case_no = 2024/434
prev_hearing_date = 23/06/2025
hearing_date = 22/07/2025
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 7
RecordId = 15286000011600
MapName trcmf1
SourceId 15286000011568
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 22/07/2025
case_no = 2024/434
trn_rcms_caseregid = 14933000009094
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011600
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011568
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:54
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2024/434
Param Type = c
trn_rcms_caseregid=14933000009094
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 11

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15499000009546 idvalue 0
Mapped case_no Row = 1 value = 2024/453 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 15/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 15499000009546
case_no = 2024/453
prev_hearing_date = 23/06/2025
hearing_date = 15/07/2025
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
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 = 6
RecordId = 15286000011601
MapName trcmf1
SourceId 15286000011569
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 15/07/2025
case_no = 2024/453
trn_rcms_caseregid = 15499000009546
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011601
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011569
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 10:59:59
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 10:59:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=15/07/2025 00:00:00
Param Type = c
case_no=2024/453
Param Type = c
trn_rcms_caseregid=15499000009546
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 12

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11443000009548 idvalue 0
Mapped case_no Row = 1 value = 2024/492 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 11443000009548
case_no = 2024/492
prev_hearing_date = 23/06/2025
hearing_date = 22/07/2025
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 15286000011602
MapName trcmf1
SourceId 15286000011570
Select sysdate as sdt from dual
Time elapsed = 20
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 22/07/2025
case_no = 2024/492
trn_rcms_caseregid = 11443000009548
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011602
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011570
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:00:04
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:00:04
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2024/492
Param Type = c
trn_rcms_caseregid=11443000009548
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 13

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18796000008527 idvalue 0
Mapped case_no Row = 1 value = 2025/9 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 18796000008527
case_no = 2025/9
prev_hearing_date = 23/06/2025
hearing_date = 22/07/2025
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 6
RecordId = 15286000011603
MapName trcmf1
SourceId 15286000011571
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000497
hearing_date = 22/07/2025
case_no = 2025/9
trn_rcms_caseregid = 18796000008527
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011603
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011571
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:00:09
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:00: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=1000497
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2025/9
Param Type = c
trn_rcms_caseregid=18796000008527
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 14

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19964000007898 idvalue 0
Mapped case_no Row = 1 value = 2023/159 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 26/06/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 19964000007898
case_no = 2023/159
prev_hearing_date = 23/06/2025
hearing_date = 26/06/2025
prev_case_purposename = ???? ????????? ????
prev_case_purpose = 
prev_case_purposename=???? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 6
RecordId = 15286000011604
MapName trcmf1
SourceId 15286000011572
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 13
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 26/06/2025
case_no = 2023/159
trn_rcms_caseregid = 19964000007898
court_code = 10519
case_purpose = 12555000000002
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011604
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011572
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:00:14
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:00: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=12555000000002
Param Type = c
hearing_date=26/06/2025 00:00:00
Param Type = c
case_no=2023/159
Param Type = c
trn_rcms_caseregid=19964000007898
Param Type = c
court_code=10519
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 15

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18133000008666 idvalue 0
Mapped case_no Row = 1 value = 2024/391 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 28/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 18133000008666
case_no = 2024/391
prev_hearing_date = 23/06/2025
hearing_date = 28/07/2025
prev_case_purposename = ???? ????????? ????
prev_case_purpose = 
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 8
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 = 6
RecordId = 15286000011605
MapName trcmf1
SourceId 15286000011573
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 28/07/2025
case_no = 2024/391
trn_rcms_caseregid = 18133000008666
court_code = 10519
case_purpose = 12555000000002
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011605
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011573
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:00:19
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:00: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=12555000000002
Param Type = c
hearing_date=28/07/2025 00:00:00
Param Type = c
case_no=2024/391
Param Type = c
trn_rcms_caseregid=18133000008666
Param Type = c
court_code=10519
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 16

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13183000006927 idvalue 0
Mapped case_no Row = 1 value = 2021/219 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 13183000006927
case_no = 2021/219
prev_hearing_date = 23/06/2025
hearing_date = 15/07/2025
prev_case_purposename = ??????? ???? ???????
prev_case_purpose = 
prev_case_purposename=??????? ???? ???????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 8
RecordId = 15286000011606
MapName trcmf1
SourceId 15286000011574
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 15/07/2025
case_no = 2021/219
trn_rcms_caseregid = 13183000006927
court_code = 10519
case_purpose = 18472000000000
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011606
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011574
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:00:23
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:00: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=18472000000000
Param Type = c
hearing_date=15/07/2025 00:00:00
Param Type = c
case_no=2021/219
Param Type = c
trn_rcms_caseregid=13183000006927
Param Type = c
court_code=10519
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 17

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15269000007593 idvalue 0
Mapped case_no Row = 1 value = 2023/206 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 15269000007593
case_no = 2023/206
prev_hearing_date = 23/06/2025
hearing_date = 15/07/2025
prev_case_purposename = ??????? ???? ???????
prev_case_purpose = 
prev_case_purpose after validation = 18472000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 8
RecordId = 15286000011607
MapName trcmf1
SourceId 15286000011575
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 15/07/2025
case_no = 2023/206
trn_rcms_caseregid = 15269000007593
court_code = 10519
case_purpose = 18473000000000
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011607
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011575
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:00:27
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:00: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=18472000000000
Param Type = c
hearing_date=15/07/2025 00:00:00
Param Type = c
case_no=2023/206
Param Type = c
trn_rcms_caseregid=15269000007593
Param Type = c
court_code=10519
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 18

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10170000008691 idvalue 0
Mapped case_no Row = 1 value = 2023/389 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 10170000008691
case_no = 2023/389
prev_hearing_date = 23/06/2025
hearing_date = 22/07/2025
prev_case_purposename = ??????? ???? ???????
prev_case_purpose = 
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
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 = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 15286000011608
MapName trcmf1
SourceId 15286000011576
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 22/07/2025
case_no = 2023/389
trn_rcms_caseregid = 10170000008691
court_code = 10519
case_purpose = 18472000000000
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011608
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011576
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:00:32
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:00: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=18472000000000
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2023/389
Param Type = c
trn_rcms_caseregid=10170000008691
Param Type = c
court_code=10519
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 19

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10496000008210 idvalue 0
Mapped case_no Row = 1 value = 2024/192 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 10496000008210
case_no = 2024/192
prev_hearing_date = 23/06/2025
hearing_date = 22/07/2025
prev_case_purposename = ??????? ???? ???????
prev_case_purpose = 
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 6
RecordId = 15286000011609
MapName trcmf1
SourceId 15286000011577
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 22/07/2025
case_no = 2024/192
trn_rcms_caseregid = 10496000008210
court_code = 10519
case_purpose = 18472000000000
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011609
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011577
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:00:36
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:00:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2024/192
Param Type = c
trn_rcms_caseregid=10496000008210
Param Type = c
court_code=10519
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 20

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13740000008811 idvalue 0
Mapped case_no Row = 1 value = 2024/74 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 13740000008811
case_no = 2024/74
prev_hearing_date = 23/06/2025
hearing_date = 15/07/2025
prev_case_purposename = ??????? ???? ???????
prev_case_purpose = 
prev_case_purpose after validation = 18472000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 7
RecordId = 15286000011610
MapName trcmf1
SourceId 15286000011578
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 15/07/2025
case_no = 2024/74
trn_rcms_caseregid = 13740000008811
court_code = 10519
case_purpose = 18473000000000
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011610
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011578
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:00:40
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:00:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=15/07/2025 00:00:00
Param Type = c
case_no=2024/74
Param Type = c
trn_rcms_caseregid=13740000008811
Param Type = c
court_code=10519
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 21

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10006000009808 idvalue 0
Mapped case_no Row = 1 value = 2025/59 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ???? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 18472000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 10006000009808
case_no = 2025/59
prev_hearing_date = 23/06/2025
hearing_date = 28/07/2025
prev_case_purposename = ??????? ???? ???????
prev_case_purpose = 
prev_case_purpose after validation = 18472000000000
case_purpose = 18472000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 15286000011611
MapName trcmf1
SourceId 15286000011579
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18472000000000
hearing_date = 28/07/2025
case_no = 2025/59
trn_rcms_caseregid = 10006000009808
court_code = 10519
case_purpose = 18472000000000
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011611
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011579
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:00:44
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:00:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18472000000000
Param Type = c
hearing_date=28/07/2025 00:00:00
Param Type = c
case_no=2025/59
Param Type = c
trn_rcms_caseregid=10006000009808
Param Type = c
court_code=10519
Param Type = c
case_purpose=18472000000000
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 22

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18794000007124 idvalue 0
Mapped case_no Row = 1 value = 2023/139 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 11417000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 18794000007124
case_no = 2023/139
prev_hearing_date = 23/06/2025
hearing_date = 28/07/2025
prev_case_purposename = ??????? ???????
prev_case_purpose = 
prev_case_purposename=??????? ???????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 7
RecordId = 15286000011612
MapName trcmf1
SourceId 15286000011580
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11417000000000
hearing_date = 28/07/2025
case_no = 2023/139
trn_rcms_caseregid = 18794000007124
court_code = 10519
case_purpose = 11417000000000
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011612
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011580
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:00:49
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:00:49
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=11417000000000
Param Type = c
hearing_date=28/07/2025 00:00:00
Param Type = c
case_no=2023/139
Param Type = c
trn_rcms_caseregid=18794000007124
Param Type = c
court_code=10519
Param Type = c
case_purpose=11417000000000
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 23

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18812000008182 idvalue 0
Mapped case_no Row = 1 value = 2024/285 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 11417000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 18812000008182
case_no = 2024/285
prev_hearing_date = 23/06/2025
hearing_date = 15/07/2025
prev_case_purposename = ??????? ???????
prev_case_purpose = 
prev_case_purpose after validation = 11417000000000
case_purpose = 11417000000000
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 = 7
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 9
RecordId = 15286000011613
MapName trcmf1
SourceId 15286000011581
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11417000000000
hearing_date = 15/07/2025
case_no = 2024/285
trn_rcms_caseregid = 18812000008182
court_code = 10519
case_purpose = 11417000000000
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011613
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011581
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:00:53
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:00:53
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=11417000000000
Param Type = c
hearing_date=15/07/2025 00:00:00
Param Type = c
case_no=2024/285
Param Type = c
trn_rcms_caseregid=18812000008182
Param Type = c
court_code=10519
Param Type = c
case_purpose=11417000000000
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 24

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15491000009721 idvalue 0
Mapped case_no Row = 1 value = 2024/452 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 26/06/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 15491000009721
case_no = 2024/452
prev_hearing_date = 23/06/2025
hearing_date = 26/06/2025
prev_case_purposename = ??????? ???????
prev_case_purpose = 
prev_case_purpose after validation = 11417000000000
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 15286000011614
MapName trcmf1
SourceId 15286000011582
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11417000000000
hearing_date = 26/06/2025
case_no = 2024/452
trn_rcms_caseregid = 15491000009721
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011614
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011582
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:00:57
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:00:57
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=11417000000000
Param Type = c
hearing_date=26/06/2025 00:00:00
Param Type = c
case_no=2024/452
Param Type = c
trn_rcms_caseregid=15491000009721
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 25

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12338000009349 idvalue 0
Mapped case_no Row = 1 value = 2025/113 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 11417000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 12338000009349
case_no = 2025/113
prev_hearing_date = 23/06/2025
hearing_date = 28/07/2025
prev_case_purposename = ??????? ???????
prev_case_purpose = 
prev_case_purpose after validation = 11417000000000
case_purpose = 11417000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 9
RecordId = 15286000011615
MapName trcmf1
SourceId 15286000011583
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11417000000000
hearing_date = 28/07/2025
case_no = 2025/113
trn_rcms_caseregid = 12338000009349
court_code = 10519
case_purpose = 11417000000000
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011615
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011583
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:01:02
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:01:02
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=11417000000000
Param Type = c
hearing_date=28/07/2025 00:00:00
Param Type = c
case_no=2025/113
Param Type = c
trn_rcms_caseregid=12338000009349
Param Type = c
court_code=10519
Param Type = c
case_purpose=11417000000000
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 26

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13281000009299 idvalue 0
Mapped case_no Row = 1 value = 2025/156 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 11417000000000 idvalue 0
Mapped hearing_date Row = 1 value = 22/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 13281000009299
case_no = 2025/156
prev_hearing_date = 23/06/2025
hearing_date = 22/07/2025
prev_case_purposename = ??????? ???????
prev_case_purpose = 
prev_case_purpose after validation = 11417000000000
case_purpose = 11417000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 5
RecordId = 15286000011616
MapName trcmf1
SourceId 15286000011584
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11417000000000
hearing_date = 22/07/2025
case_no = 2025/156
trn_rcms_caseregid = 13281000009299
court_code = 10519
case_purpose = 11417000000000
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011616
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011584
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:01:06
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:01:06
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=11417000000000
Param Type = c
hearing_date=22/07/2025 00:00:00
Param Type = c
case_no=2025/156
Param Type = c
trn_rcms_caseregid=13281000009299
Param Type = c
court_code=10519
Param Type = c
case_purpose=11417000000000
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 27

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17698000009964 idvalue 0
Mapped case_no Row = 1 value = 2025/165 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ??????? idvalue 0
Mapped case_purpose Row = 1 value = 11417000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 17698000009964
case_no = 2025/165
prev_hearing_date = 23/06/2025
hearing_date = 28/07/2025
prev_case_purposename = ??????? ???????
prev_case_purpose = 
prev_case_purpose after validation = 11417000000000
case_purpose = 11417000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 7
RecordId = 15286000011617
MapName trcmf1
SourceId 15286000011585
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11417000000000
hearing_date = 28/07/2025
case_no = 2025/165
trn_rcms_caseregid = 17698000009964
court_code = 10519
case_purpose = 11417000000000
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011617
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011585
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:01:10
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:01: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=11417000000000
Param Type = c
hearing_date=28/07/2025 00:00:00
Param Type = c
case_no=2025/165
Param Type = c
trn_rcms_caseregid=17698000009964
Param Type = c
court_code=10519
Param Type = c
case_purpose=11417000000000
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 28

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19954000007521 idvalue 0
Mapped case_no Row = 1 value = 2023/158 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 1000490 idvalue 0
Mapped hearing_date Row = 1 value = 26/06/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 19954000007521
case_no = 2023/158
prev_hearing_date = 23/06/2025
hearing_date = 26/06/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 5
RecordId = 15286000011618
MapName trcmf1
SourceId 15286000011586
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 26/06/2025
case_no = 2023/158
trn_rcms_caseregid = 19954000007521
court_code = 10519
case_purpose = 1000490
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011618
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011586
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:01:15
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:01: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=26/06/2025 00:00:00
Param Type = c
case_no=2023/158
Param Type = c
trn_rcms_caseregid=19954000007521
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000490
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 29

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18453000008787 idvalue 0
Mapped case_no Row = 1 value = 2024/383 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 18453000008787
case_no = 2024/383
prev_hearing_date = 23/06/2025
hearing_date = 28/07/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 8
RecordId = 15286000011619
MapName trcmf1
SourceId 15286000011587
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 9
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 28/07/2025
case_no = 2024/383
trn_rcms_caseregid = 18453000008787
court_code = 10519
case_purpose = 18678000000000
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011619
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011587
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:01:19
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:01: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=28/07/2025 00:00:00
Param Type = c
case_no=2024/383
Param Type = c
trn_rcms_caseregid=18453000008787
Param Type = c
court_code=10519
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 30

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18532000008623 idvalue 0
Mapped case_no Row = 1 value = 2024/384 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 28/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 18532000008623
case_no = 2024/384
prev_hearing_date = 23/06/2025
hearing_date = 28/07/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 7
RecordId = 15286000011620
MapName trcmf1
SourceId 15286000011588
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 28/07/2025
case_no = 2024/384
trn_rcms_caseregid = 18532000008623
court_code = 10519
case_purpose = 18678000000000
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011620
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011588
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:01:24
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:01: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=28/07/2025 00:00:00
Param Type = c
case_no=2024/384
Param Type = c
trn_rcms_caseregid=18532000008623
Param Type = c
court_code=10519
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 31

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14639000008265 idvalue 0
Mapped case_no Row = 1 value = 2023/425 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??????? ????????? ????  idvalue 0
Mapped case_purpose Row = 1 value = 18469000000000 idvalue 0
Mapped hearing_date Row = 1 value = 26/06/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 14639000008265
case_no = 2023/425
prev_hearing_date = 23/06/2025
hearing_date = 26/06/2025
prev_case_purposename = ??????? ????????? ???? 
prev_case_purpose = 
prev_case_purposename=??????? ????????? ???? 
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 5
RecordId = 15286000011621
MapName trcmf1
SourceId 15286000011589
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18469000000000
hearing_date = 26/06/2025
case_no = 2023/425
trn_rcms_caseregid = 14639000008265
court_code = 10519
case_purpose = 18469000000000
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011621
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011589
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:01:29
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:01: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=18469000000000
Param Type = c
hearing_date=26/06/2025 00:00:00
Param Type = c
case_no=2023/425
Param Type = c
trn_rcms_caseregid=14639000008265
Param Type = c
court_code=10519
Param Type = c
case_purpose=18469000000000
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 32

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18815000001015 idvalue 0
Mapped case_no Row = 1 value = 2017/00105 idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/06/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 18479000000906 idvalue 0
Mapped hearing_date Row = 1 value = 30/07/2025 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 18815000001015
case_no = 2017/00105
prev_hearing_date = 23/06/2025
hearing_date = 30/07/2025
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purposename=?????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=?????
Time elapsed = 8
prev_case_purpose after validation = 18479000000906
case_purpose = 18479000000906
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 = 9
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 15286000011622
MapName trcmf1
SourceId 15286000011590
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18479000000906
hearing_date = 30/07/2025
case_no = 2017/00105
trn_rcms_caseregid = 18815000001015
court_code = 10519
case_purpose = 18479000000906
prev_hearing_date = 23/06/2025
Posting record
Param Type = n
trn_rcms_case_histid=15286000011622
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=15286000011590
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan_PRO
Param Type = c
createdon=25/06/2025 11:01:33
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
modifiedon=25/06/2025 11:01: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=18479000000906
Param Type = c
hearing_date=30/07/2025 00:00:00
Param Type = c
case_no=2017/00105
Param Type = c
trn_rcms_caseregid=18815000001015
Param Type = c
court_code=10519
Param Type = c
case_purpose=18479000000906
Param Type = c
prev_hearing_date=23/06/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))

Time elapsed for Gen Map = 3960010900642
Time elapsed for MD Map = 3960010900642
Time elapsed for Save History = 3960010900644
Time elapsed for Save Attachment = 3960010900645
Time elapsed for After Save WF Exec = 3960010900653
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"15286000011558"}]}
Savedata webservice completed


Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=SDO_Chauhtan_PRO
Param Type = c
calledon=25/06/2025 10:58:29
Param Type = c
callfinished=25/06/2025 11:01:40
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=191064
Param Type = n
dbtimetaken=189255
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