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="DM_bikaner" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>DM_bikaner</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">10401</courtcode><hearing_date rowno="001">10/02/2022</hearing_date><axp_recid2 rowno="001">0</axp_recid2><court_code rowno="001">10401</court_code><case_no rowno="001">2021/339</case_no><trn_rcms_caseid rowno="001">16128000005861</trn_rcms_caseid><pre_case_purpose_name rowno="001">????</pre_case_purpose_name><pre_hear_date rowno="001">10/02/2022</pre_hear_date><pre_case_purpose rowno="001">18678000000000</pre_case_purpose><next_hear_date rowno="001">08/09/2025</next_hear_date><new_case_purpose rowno="001">18678000000000</new_case_purpose><isadjourn rowno="001">NO</isadjourn><adjourn_type rowno="001">0</adjourn_type><adjourn_remark rowno="001"></adjourn_remark><axp_recid2 rowno="002">0</axp_recid2><court_code rowno="002">10401</court_code><case_no rowno="002">2021/340</case_no><trn_rcms_caseid rowno="002">16158000005915</trn_rcms_caseid><pre_case_purpose_name rowno="002">????</pre_case_purpose_name><pre_hear_date rowno="002">10/02/2022</pre_hear_date><pre_case_purpose rowno="002">18678000000000</pre_case_purpose><next_hear_date rowno="002">08/09/2025</next_hear_date><new_case_purpose rowno="002">18678000000000</new_case_purpose><isadjourn rowno="002">NO</isadjourn><adjourn_type rowno="002">0</adjourn_type><adjourn_remark rowno="002"></adjourn_remark><axp_recid2 rowno="003">0</axp_recid2><court_code rowno="003">10401</court_code><case_no rowno="003">2021/342</case_no><trn_rcms_caseid rowno="003">16195000005790</trn_rcms_caseid><pre_case_purpose_name rowno="003">????</pre_case_purpose_name><pre_hear_date rowno="003">10/02/2022</pre_hear_date><pre_case_purpose rowno="003">18678000000000</pre_case_purpose><next_hear_date rowno="003">08/09/2025</next_hear_date><new_case_purpose rowno="003">18678000000000</new_case_purpose><isadjourn rowno="003">NO</isadjourn><adjourn_type rowno="003">0</adjourn_type><adjourn_remark rowno="003"></adjourn_remark><axp_recid2 rowno="004">0</axp_recid2><court_code rowno="004">10401</court_code><case_no rowno="004">2021/343</case_no><trn_rcms_caseid rowno="004">16209000005449</trn_rcms_caseid><pre_case_purpose_name rowno="004">????</pre_case_purpose_name><pre_hear_date rowno="004">10/02/2022</pre_hear_date><pre_case_purpose rowno="004">18678000000000</pre_case_purpose><next_hear_date rowno="004">08/09/2025</next_hear_date><new_case_purpose rowno="004">18678000000000</new_case_purpose><isadjourn rowno="004">NO</isadjourn><adjourn_type rowno="004">0</adjourn_type><adjourn_remark rowno="004"></adjourn_remark><axp_recid2 rowno="005">0</axp_recid2><court_code rowno="005">10401</court_code><case_no rowno="005">2021/344</case_no><trn_rcms_caseid rowno="005">16228000005692</trn_rcms_caseid><pre_case_purpose_name rowno="005">????</pre_case_purpose_name><pre_hear_date rowno="005">10/02/2022</pre_hear_date><pre_case_purpose rowno="005">18678000000000</pre_case_purpose><next_hear_date rowno="005">08/09/2025</next_hear_date><new_case_purpose rowno="005">18678000000000</new_case_purpose><isadjourn rowno="005">NO</isadjourn><adjourn_type rowno="005">0</adjourn_type><adjourn_remark rowno="005"></adjourn_remark><axp_recid2 rowno="006">0</axp_recid2><court_code rowno="006">10401</court_code><case_no rowno="006">2021/345</case_no><trn_rcms_caseid rowno="006">16312000006850</trn_rcms_caseid><pre_case_purpose_name rowno="006">????</pre_case_purpose_name><pre_hear_date rowno="006">10/02/2022</pre_hear_date><pre_case_purpose rowno="006">18678000000000</pre_case_purpose><next_hear_date rowno="006">08/09/2025</next_hear_date><new_case_purpose rowno="006">18678000000000</new_case_purpose><isadjourn rowno="006">NO</isadjourn><adjourn_type rowno="006">0</adjourn_type><adjourn_remark rowno="006"></adjourn_remark><axp_recid2 rowno="007">0</axp_recid2><court_code rowno="007">10401</court_code><case_no rowno="007">2021/347</case_no><trn_rcms_caseid rowno="007">16375000006317</trn_rcms_caseid><pre_case_purpose_name rowno="007">????</pre_case_purpose_name><pre_hear_date rowno="007">10/02/2022</pre_hear_date><pre_case_purpose rowno="007">18678000000000</pre_case_purpose><next_hear_date rowno="007">08/09/2025</next_hear_date><new_case_purpose rowno="007">18678000000000</new_case_purpose><isadjourn rowno="007">NO</isadjourn><adjourn_type rowno="007">0</adjourn_type><adjourn_remark rowno="007"></adjourn_remark><axp_recid2 rowno="008">0</axp_recid2><court_code rowno="008">10401</court_code><case_no rowno="008">2021/349</case_no><trn_rcms_caseid rowno="008">16528000005880</trn_rcms_caseid><pre_case_purpose_name rowno="008">????</pre_case_purpose_name><pre_hear_date rowno="008">10/02/2022</pre_hear_date><pre_case_purpose rowno="008">18678000000000</pre_case_purpose><next_hear_date rowno="008">08/09/2025</next_hear_date><new_case_purpose rowno="008">18678000000000</new_case_purpose><isadjourn rowno="008">NO</isadjourn><adjourn_type rowno="008">0</adjourn_type><adjourn_remark rowno="008"></adjourn_remark><axp_recid2 rowno="009">0</axp_recid2><court_code rowno="009">10401</court_code><case_no rowno="009">2021/350</case_no><trn_rcms_caseid rowno="009">16548000007311</trn_rcms_caseid><pre_case_purpose_name rowno="009">????</pre_case_purpose_name><pre_hear_date rowno="009">10/02/2022</pre_hear_date><pre_case_purpose rowno="009">18678000000000</pre_case_purpose><next_hear_date rowno="009">08/09/2025</next_hear_date><new_case_purpose rowno="009">18678000000000</new_case_purpose><isadjourn rowno="009">NO</isadjourn><adjourn_type rowno="009">0</adjourn_type><adjourn_remark rowno="009"></adjourn_remark><axp_recid2 rowno="0010">0</axp_recid2><court_code rowno="0010">10401</court_code><case_no rowno="0010">2021/352</case_no><trn_rcms_caseid rowno="0010">16571000006286</trn_rcms_caseid><pre_case_purpose_name rowno="0010">????</pre_case_purpose_name><pre_hear_date rowno="0010">10/02/2022</pre_hear_date><pre_case_purpose rowno="0010">18678000000000</pre_case_purpose><next_hear_date rowno="0010">08/09/2025</next_hear_date><new_case_purpose rowno="0010">18678000000000</new_case_purpose><isadjourn rowno="0010">NO</isadjourn><adjourn_type rowno="0010">0</adjourn_type><adjourn_remark rowno="0010"></adjourn_remark><axp_recid2 rowno="0011">0</axp_recid2><court_code rowno="0011">10401</court_code><case_no rowno="0011">2021/353</case_no><trn_rcms_caseid rowno="0011">16586000006756</trn_rcms_caseid><pre_case_purpose_name rowno="0011">????</pre_case_purpose_name><pre_hear_date rowno="0011">10/02/2022</pre_hear_date><pre_case_purpose rowno="0011">18678000000000</pre_case_purpose><next_hear_date rowno="0011">08/09/2025</next_hear_date><new_case_purpose rowno="0011">18678000000000</new_case_purpose><isadjourn rowno="0011">NO</isadjourn><adjourn_type rowno="0011">0</adjourn_type><adjourn_remark rowno="0011"></adjourn_remark><axp_recid2 rowno="0012">0</axp_recid2><court_code rowno="0012">10401</court_code><case_no rowno="0012">2021/354</case_no><trn_rcms_caseid rowno="0012">16604000006157</trn_rcms_caseid><pre_case_purpose_name rowno="0012">????</pre_case_purpose_name><pre_hear_date rowno="0012">10/02/2022</pre_hear_date><pre_case_purpose rowno="0012">18678000000000</pre_case_purpose><next_hear_date rowno="0012">08/09/2025</next_hear_date><new_case_purpose rowno="0012">18678000000000</new_case_purpose><isadjourn rowno="0012">NO</isadjourn><adjourn_type rowno="0012">0</adjourn_type><adjourn_remark rowno="0012"></adjourn_remark><axp_recid2 rowno="0013">0</axp_recid2><court_code rowno="0013">10401</court_code><case_no rowno="0013">2021/355</case_no><trn_rcms_caseid rowno="0013">16614000005462</trn_rcms_caseid><pre_case_purpose_name rowno="0013">????</pre_case_purpose_name><pre_hear_date rowno="0013">10/02/2022</pre_hear_date><pre_case_purpose rowno="0013">18678000000000</pre_case_purpose><next_hear_date rowno="0013">08/09/2025</next_hear_date><new_case_purpose rowno="0013">18678000000000</new_case_purpose><isadjourn rowno="0013">NO</isadjourn><adjourn_type rowno="0013">0</adjourn_type><adjourn_remark rowno="0013"></adjourn_remark><axp_recid2 rowno="0014">0</axp_recid2><court_code rowno="0014">10401</court_code><case_no rowno="0014">2021/356</case_no><trn_rcms_caseid rowno="0014">16620000005796</trn_rcms_caseid><pre_case_purpose_name rowno="0014">????</pre_case_purpose_name><pre_hear_date rowno="0014">10/02/2022</pre_hear_date><pre_case_purpose rowno="0014">18678000000000</pre_case_purpose><next_hear_date rowno="0014">08/09/2025</next_hear_date><new_case_purpose rowno="0014">18678000000000</new_case_purpose><isadjourn rowno="0014">NO</isadjourn><adjourn_type rowno="0014">0</adjourn_type><adjourn_remark rowno="0014"></adjourn_remark><axp_recid2 rowno="0015">0</axp_recid2><court_code rowno="0015">10401</court_code><case_no rowno="0015">2021/357</case_no><trn_rcms_caseid rowno="0015">16629000006426</trn_rcms_caseid><pre_case_purpose_name rowno="0015">????</pre_case_purpose_name><pre_hear_date rowno="0015">10/02/2022</pre_hear_date><pre_case_purpose rowno="0015">18678000000000</pre_case_purpose><next_hear_date rowno="0015">08/09/2025</next_hear_date><new_case_purpose rowno="0015">18678000000000</new_case_purpose><isadjourn rowno="0015">NO</isadjourn><adjourn_type rowno="0015">0</adjourn_type><adjourn_remark rowno="0015"></adjourn_remark><axp_recid2 rowno="0016">0</axp_recid2><court_code rowno="0016">10401</court_code><case_no rowno="0016">2021/358</case_no><trn_rcms_caseid rowno="0016">16640000006063</trn_rcms_caseid><pre_case_purpose_name rowno="0016">????</pre_case_purpose_name><pre_hear_date rowno="0016">10/02/2022</pre_hear_date><pre_case_purpose rowno="0016">18678000000000</pre_case_purpose><next_hear_date rowno="0016">08/09/2025</next_hear_date><new_case_purpose rowno="0016">18678000000000</new_case_purpose><isadjourn rowno="0016">NO</isadjourn><adjourn_type rowno="0016">0</adjourn_type><adjourn_remark rowno="0016"></adjourn_remark><axp_recid2 rowno="0017">0</axp_recid2><court_code rowno="0017">10401</court_code><case_no rowno="0017">2021/359</case_no><trn_rcms_caseid rowno="0017">16707000005982</trn_rcms_caseid><pre_case_purpose_name rowno="0017">????</pre_case_purpose_name><pre_hear_date rowno="0017">10/02/2022</pre_hear_date><pre_case_purpose rowno="0017">18678000000000</pre_case_purpose><next_hear_date rowno="0017">08/09/2025</next_hear_date><new_case_purpose rowno="0017">18678000000000</new_case_purpose><isadjourn rowno="0017">NO</isadjourn><adjourn_type rowno="0017">0</adjourn_type><adjourn_remark rowno="0017"></adjourn_remark><axp_recid2 rowno="0018">0</axp_recid2><court_code rowno="0018">10401</court_code><case_no rowno="0018">2021/360</case_no><trn_rcms_caseid rowno="0018">16712000005606</trn_rcms_caseid><pre_case_purpose_name rowno="0018">????</pre_case_purpose_name><pre_hear_date rowno="0018">10/02/2022</pre_hear_date><pre_case_purpose rowno="0018">18678000000000</pre_case_purpose><next_hear_date rowno="0018">08/09/2025</next_hear_date><new_case_purpose rowno="0018">18678000000000</new_case_purpose><isadjourn rowno="0018">NO</isadjourn><adjourn_type rowno="0018">0</adjourn_type><adjourn_remark rowno="0018"></adjourn_remark><axp_recid2 rowno="0019">0</axp_recid2><court_code rowno="0019">10401</court_code><case_no rowno="0019">2021/361</case_no><trn_rcms_caseid rowno="0019">16720000006440</trn_rcms_caseid><pre_case_purpose_name rowno="0019">????</pre_case_purpose_name><pre_hear_date rowno="0019">10/02/2022</pre_hear_date><pre_case_purpose rowno="0019">18678000000000</pre_case_purpose><next_hear_date rowno="0019">08/09/2025</next_hear_date><new_case_purpose rowno="0019">18678000000000</new_case_purpose><isadjourn rowno="0019">NO</isadjourn><adjourn_type rowno="0019">0</adjourn_type><adjourn_remark rowno="0019"></adjourn_remark><axp_recid2 rowno="0020">0</axp_recid2><court_code rowno="0020">10401</court_code><case_no rowno="0020">2021/362</case_no><trn_rcms_caseid rowno="0020">16728000006441</trn_rcms_caseid><pre_case_purpose_name rowno="0020">????</pre_case_purpose_name><pre_hear_date rowno="0020">10/02/2022</pre_hear_date><pre_case_purpose rowno="0020">18678000000000</pre_case_purpose><next_hear_date rowno="0020">08/09/2025</next_hear_date><new_case_purpose rowno="0020">18678000000000</new_case_purpose><isadjourn rowno="0020">NO</isadjourn><adjourn_type rowno="0020">0</adjourn_type><adjourn_remark rowno="0020"></adjourn_remark><axp_recid2 rowno="0021">0</axp_recid2><court_code rowno="0021">10401</court_code><case_no rowno="0021">2021/363</case_no><trn_rcms_caseid rowno="0021">16746000006460</trn_rcms_caseid><pre_case_purpose_name rowno="0021">????</pre_case_purpose_name><pre_hear_date rowno="0021">10/02/2022</pre_hear_date><pre_case_purpose rowno="0021">18678000000000</pre_case_purpose><next_hear_date rowno="0021">08/09/2025</next_hear_date><new_case_purpose rowno="0021">18678000000000</new_case_purpose><isadjourn rowno="0021">NO</isadjourn><adjourn_type rowno="0021">0</adjourn_type><adjourn_remark rowno="0021"></adjourn_remark><axp_recid2 rowno="0022">0</axp_recid2><court_code rowno="0022">10401</court_code><case_no rowno="0022">2021/364</case_no><trn_rcms_caseid rowno="0022">16782000005999</trn_rcms_caseid><pre_case_purpose_name rowno="0022">????</pre_case_purpose_name><pre_hear_date rowno="0022">10/02/2022</pre_hear_date><pre_case_purpose rowno="0022">18678000000000</pre_case_purpose><next_hear_date rowno="0022">08/09/2025</next_hear_date><new_case_purpose rowno="0022">18678000000000</new_case_purpose><isadjourn rowno="0022">NO</isadjourn><adjourn_type rowno="0022">0</adjourn_type><adjourn_remark rowno="0022"></adjourn_remark><axp_recid2 rowno="0023">0</axp_recid2><court_code rowno="0023">10401</court_code><case_no rowno="0023">2021/365</case_no><trn_rcms_caseid rowno="0023">16852000005663</trn_rcms_caseid><pre_case_purpose_name rowno="0023">????</pre_case_purpose_name><pre_hear_date rowno="0023">10/02/2022</pre_hear_date><pre_case_purpose rowno="0023">18678000000000</pre_case_purpose><next_hear_date rowno="0023">08/09/2025</next_hear_date><new_case_purpose rowno="0023">18678000000000</new_case_purpose><isadjourn rowno="0023">NO</isadjourn><adjourn_type rowno="0023">0</adjourn_type><adjourn_remark rowno="0023"></adjourn_remark><axp_recid2 rowno="0024">0</axp_recid2><court_code rowno="0024">10401</court_code><case_no rowno="0024">2021/366</case_no><trn_rcms_caseid rowno="0024">16868000006104</trn_rcms_caseid><pre_case_purpose_name rowno="0024">????</pre_case_purpose_name><pre_hear_date rowno="0024">10/02/2022</pre_hear_date><pre_case_purpose rowno="0024">18678000000000</pre_case_purpose><next_hear_date rowno="0024">08/09/2025</next_hear_date><new_case_purpose rowno="0024">18678000000000</new_case_purpose><isadjourn rowno="0024">NO</isadjourn><adjourn_type rowno="0024">0</adjourn_type><adjourn_remark rowno="0024"></adjourn_remark><axp_recid2 rowno="0025">0</axp_recid2><court_code rowno="0025">10401</court_code><case_no rowno="0025">2021/367</case_no><trn_rcms_caseid rowno="0025">16912000006243</trn_rcms_caseid><pre_case_purpose_name rowno="0025">????</pre_case_purpose_name><pre_hear_date rowno="0025">10/02/2022</pre_hear_date><pre_case_purpose rowno="0025">18678000000000</pre_case_purpose><next_hear_date rowno="0025">08/09/2025</next_hear_date><new_case_purpose rowno="0025">18678000000000</new_case_purpose><isadjourn rowno="0025">NO</isadjourn><adjourn_type rowno="0025">0</adjourn_type><adjourn_remark rowno="0025"></adjourn_remark><axp_recid2 rowno="0026">0</axp_recid2><court_code rowno="0026">10401</court_code><case_no rowno="0026">2021/370</case_no><trn_rcms_caseid rowno="0026">15815000006168</trn_rcms_caseid><pre_case_purpose_name rowno="0026">???</pre_case_purpose_name><pre_hear_date rowno="0026">10/02/2022</pre_hear_date><pre_case_purpose rowno="0026">18473000000000</pre_case_purpose><next_hear_date rowno="0026">08/09/2025</next_hear_date><new_case_purpose rowno="0026">18473000000000</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">10401</court_code><case_no rowno="0027">2021/372</case_no><trn_rcms_caseid rowno="0027">15885000006042</trn_rcms_caseid><pre_case_purpose_name rowno="0027">???</pre_case_purpose_name><pre_hear_date rowno="0027">10/02/2022</pre_hear_date><pre_case_purpose rowno="0027">18473000000000</pre_case_purpose><next_hear_date rowno="0027">08/09/2025</next_hear_date><new_case_purpose rowno="0027">18473000000000</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">10401</court_code><case_no rowno="0028">2021/373</case_no><trn_rcms_caseid rowno="0028">15889000005460</trn_rcms_caseid><pre_case_purpose_name rowno="0028">???</pre_case_purpose_name><pre_hear_date rowno="0028">10/02/2022</pre_hear_date><pre_case_purpose rowno="0028">18473000000000</pre_case_purpose><next_hear_date rowno="0028">08/09/2025</next_hear_date><new_case_purpose rowno="0028">18473000000000</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">10401</court_code><case_no rowno="0029">2021/374</case_no><trn_rcms_caseid rowno="0029">15896000007193</trn_rcms_caseid><pre_case_purpose_name rowno="0029">???</pre_case_purpose_name><pre_hear_date rowno="0029">10/02/2022</pre_hear_date><pre_case_purpose rowno="0029">18473000000000</pre_case_purpose><next_hear_date rowno="0029">08/09/2025</next_hear_date><new_case_purpose rowno="0029">18473000000000</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">10401</court_code><case_no rowno="0030">2021/375</case_no><trn_rcms_caseid rowno="0030">15907000006018</trn_rcms_caseid><pre_case_purpose_name rowno="0030">???</pre_case_purpose_name><pre_hear_date rowno="0030">10/02/2022</pre_hear_date><pre_case_purpose rowno="0030">18473000000000</pre_case_purpose><next_hear_date rowno="0030">08/09/2025</next_hear_date><new_case_purpose rowno="0030">18473000000000</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">10401</court_code><case_no rowno="0031">2021/376</case_no><trn_rcms_caseid rowno="0031">15912000006040</trn_rcms_caseid><pre_case_purpose_name rowno="0031">???</pre_case_purpose_name><pre_hear_date rowno="0031">10/02/2022</pre_hear_date><pre_case_purpose rowno="0031">18473000000000</pre_case_purpose><next_hear_date rowno="0031">08/09/2025</next_hear_date><new_case_purpose rowno="0031">18473000000000</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">10401</court_code><case_no rowno="0032">2021/381</case_no><trn_rcms_caseid rowno="0032">16018000005806</trn_rcms_caseid><pre_case_purpose_name rowno="0032">???</pre_case_purpose_name><pre_hear_date rowno="0032">10/02/2022</pre_hear_date><pre_case_purpose rowno="0032">18473000000000</pre_case_purpose><next_hear_date rowno="0032">08/09/2025</next_hear_date><new_case_purpose rowno="0032">18473000000000</new_case_purpose><isadjourn rowno="0032">NO</isadjourn><adjourn_type rowno="0032">0</adjourn_type><adjourn_remark rowno="0032"></adjourn_remark><axp_recid2 rowno="0033">0</axp_recid2><court_code rowno="0033">10401</court_code><case_no rowno="0033">2021/383</case_no><trn_rcms_caseid rowno="0033">18719000006489</trn_rcms_caseid><pre_case_purpose_name rowno="0033">???</pre_case_purpose_name><pre_hear_date rowno="0033">10/02/2022</pre_hear_date><pre_case_purpose rowno="0033">18473000000000</pre_case_purpose><next_hear_date rowno="0033">08/09/2025</next_hear_date><new_case_purpose rowno="0033">18473000000000</new_case_purpose><isadjourn rowno="0033">NO</isadjourn><adjourn_type rowno="0033">0</adjourn_type><adjourn_remark rowno="0033"></adjourn_remark><axp_recid2 rowno="0034">0</axp_recid2><court_code rowno="0034">10401</court_code><case_no rowno="0034">2021/389</case_no><trn_rcms_caseid rowno="0034">18822000005861</trn_rcms_caseid><pre_case_purpose_name rowno="0034">???</pre_case_purpose_name><pre_hear_date rowno="0034">10/02/2022</pre_hear_date><pre_case_purpose rowno="0034">18473000000000</pre_case_purpose><next_hear_date rowno="0034">08/09/2025</next_hear_date><new_case_purpose rowno="0034">18473000000000</new_case_purpose><isadjourn rowno="0034">NO</isadjourn><adjourn_type rowno="0034">0</adjourn_type><adjourn_remark rowno="0034"></adjourn_remark></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"DM_bikaner","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"trcmf","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtcode":"10401","hearing_date":"10/02/2022"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"court_code":"10401","case_no":"2021/339","trn_rcms_caseid":"16128000005861","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"002","text":"0","columns":{"court_code":"10401","case_no":"2021/340","trn_rcms_caseid":"16158000005915","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"003","text":"0","columns":{"court_code":"10401","case_no":"2021/342","trn_rcms_caseid":"16195000005790","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"004","text":"0","columns":{"court_code":"10401","case_no":"2021/343","trn_rcms_caseid":"16209000005449","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"005","text":"0","columns":{"court_code":"10401","case_no":"2021/344","trn_rcms_caseid":"16228000005692","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"006","text":"0","columns":{"court_code":"10401","case_no":"2021/345","trn_rcms_caseid":"16312000006850","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"007","text":"0","columns":{"court_code":"10401","case_no":"2021/347","trn_rcms_caseid":"16375000006317","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"008","text":"0","columns":{"court_code":"10401","case_no":"2021/349","trn_rcms_caseid":"16528000005880","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"009","text":"0","columns":{"court_code":"10401","case_no":"2021/350","trn_rcms_caseid":"16548000007311","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0010","text":"0","columns":{"court_code":"10401","case_no":"2021/352","trn_rcms_caseid":"16571000006286","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0011","text":"0","columns":{"court_code":"10401","case_no":"2021/353","trn_rcms_caseid":"16586000006756","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0012","text":"0","columns":{"court_code":"10401","case_no":"2021/354","trn_rcms_caseid":"16604000006157","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0013","text":"0","columns":{"court_code":"10401","case_no":"2021/355","trn_rcms_caseid":"16614000005462","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0014","text":"0","columns":{"court_code":"10401","case_no":"2021/356","trn_rcms_caseid":"16620000005796","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0015","text":"0","columns":{"court_code":"10401","case_no":"2021/357","trn_rcms_caseid":"16629000006426","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0016","text":"0","columns":{"court_code":"10401","case_no":"2021/358","trn_rcms_caseid":"16640000006063","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0017","text":"0","columns":{"court_code":"10401","case_no":"2021/359","trn_rcms_caseid":"16707000005982","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0018","text":"0","columns":{"court_code":"10401","case_no":"2021/360","trn_rcms_caseid":"16712000005606","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0019","text":"0","columns":{"court_code":"10401","case_no":"2021/361","trn_rcms_caseid":"16720000006440","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0020","text":"0","columns":{"court_code":"10401","case_no":"2021/362","trn_rcms_caseid":"16728000006441","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0021","text":"0","columns":{"court_code":"10401","case_no":"2021/363","trn_rcms_caseid":"16746000006460","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0022","text":"0","columns":{"court_code":"10401","case_no":"2021/364","trn_rcms_caseid":"16782000005999","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0023","text":"0","columns":{"court_code":"10401","case_no":"2021/365","trn_rcms_caseid":"16852000005663","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0024","text":"0","columns":{"court_code":"10401","case_no":"2021/366","trn_rcms_caseid":"16868000006104","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0025","text":"0","columns":{"court_code":"10401","case_no":"2021/367","trn_rcms_caseid":"16912000006243","pre_case_purpose_name":"????","pre_hear_date":"10/02/2022","pre_case_purpose":"18678000000000","next_hear_date":"08/09/2025","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0026","text":"0","columns":{"court_code":"10401","case_no":"2021/370","trn_rcms_caseid":"15815000006168","pre_case_purpose_name":"???","pre_hear_date":"10/02/2022","pre_case_purpose":"18473000000000","next_hear_date":"08/09/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0027","text":"0","columns":{"court_code":"10401","case_no":"2021/372","trn_rcms_caseid":"15885000006042","pre_case_purpose_name":"???","pre_hear_date":"10/02/2022","pre_case_purpose":"18473000000000","next_hear_date":"08/09/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0028","text":"0","columns":{"court_code":"10401","case_no":"2021/373","trn_rcms_caseid":"15889000005460","pre_case_purpose_name":"???","pre_hear_date":"10/02/2022","pre_case_purpose":"18473000000000","next_hear_date":"08/09/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0029","text":"0","columns":{"court_code":"10401","case_no":"2021/374","trn_rcms_caseid":"15896000007193","pre_case_purpose_name":"???","pre_hear_date":"10/02/2022","pre_case_purpose":"18473000000000","next_hear_date":"08/09/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0030","text":"0","columns":{"court_code":"10401","case_no":"2021/375","trn_rcms_caseid":"15907000006018","pre_case_purpose_name":"???","pre_hear_date":"10/02/2022","pre_case_purpose":"18473000000000","next_hear_date":"08/09/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0031","text":"0","columns":{"court_code":"10401","case_no":"2021/376","trn_rcms_caseid":"15912000006040","pre_case_purpose_name":"???","pre_hear_date":"10/02/2022","pre_case_purpose":"18473000000000","next_hear_date":"08/09/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0032","text":"0","columns":{"court_code":"10401","case_no":"2021/381","trn_rcms_caseid":"16018000005806","pre_case_purpose_name":"???","pre_hear_date":"10/02/2022","pre_case_purpose":"18473000000000","next_hear_date":"08/09/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0033","text":"0","columns":{"court_code":"10401","case_no":"2021/383","trn_rcms_caseid":"18719000006489","pre_case_purpose_name":"???","pre_hear_date":"10/02/2022","pre_case_purpose":"18473000000000","next_hear_date":"08/09/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0034","text":"0","columns":{"court_code":"10401","case_no":"2021/389","trn_rcms_caseid":"18822000005861","pre_case_purpose_name":"???","pre_hear_date":"10/02/2022","pre_case_purpose":"18473000000000","next_hear_date":"08/09/2025","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}}]}]}}
Verifying username and password
User Name : DM_bikaner
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=dm_bikaner
Time elapsed = 20
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 11
Result : 
Verifying completed...
Page Access Category : 
User Name : dm_bikaner
Select sysdate as sdt from dual
Time elapsed = 4
dt=29/08/2025 11:19:37
Select sysdate as sdt from dual
Time elapsed = 13
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=dm_bikaner
dt=29/08/2025 11:19:37
dt=29/08/2025 11:19:37
Time elapsed = 13
User Groups: court_reader
select userroles from axusergroups where groupname in ( 'court_reader' )
Time elapsed = 6
User Roles : court_reader
Loading App/User vars
reading the props xml
Step3
Sql : select props from axprops where lower(name)= :name  order by blobno

Paramval : app
ParamTYpe : c
Param List : name

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

Time elapsed = 4
Step4
axprops\stm size:4235
Step4-123456
<root updatedon="06/08/2025 14:47:20" name="app" caption="app" appverno="10.1.0.0" updusername="" updatedby="admin"><props LocalNum="750"><app color="$00EBF5F4" font="Tahoma,8"/><head font="Tahoma,12,tfff" color="$00DDE8E7"/><gridhead color="$00FFE8E8" font=""/><gridrow oddrowcolor="$00FEFCFA" evenrowcolor="$00FEF3ED"></gridrow><imgsfolder>images\</imgsfolder><container color="$00E8F1F0"/><name fontname="" fontsize="" fontbold="" fontitalic="" fontunderline="" fontcolor="" fontstrikeout="">Generalized Court Management System</name><img></img><envvar><currency>INR</currency><millions>F</millions><siteno></siteno><oraerrfrom>500</oraerrfrom><oraerrto>250000</oraerrto><postauto>F</postauto><finyrst></finyrst><finyred></finyred><cursep></cursep></envvar><currencies><INR></INR></currencies><appvars><m_courtname value="" param="f" hidden="false"><l>firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})</l><l>m_courtname := sqlget({m2},{court_name})</l></m_courtname><m_courttype value="" param="f" hidden="false"><l>firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})</l><l>m_courttype := sqlget({m3},{court_type})</l></m_courttype><m_courtid value="" param="f" hidden="false"><l>firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})</l><l>m_courtid := sqlget({m4},{court_name_mastid})</l></m_courtid><login_userid value="" param="f" hidden="false"><l>firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username})</l><l>login_userid := sqlget({m4},{axusersid})</l></login_userid><u_name value="" param="f" hidden="false"><l>firesql({m4},{select :username as uname from dual})</l><l>u_name := sqlget({m4},{uname})</l></u_name><m_courtcode value="" param="f" hidden="false"><l>firesql({m4},{select a.COURT_CODE from v_axcourts a where a.PAXUSERNAME = :username order by 1})</l><l>m_courtcode := sqlget({m4},{COURT_CODE})</l></m_courtcode><m_statename value="" param="f" hidden="false"><l>firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})</l><l>m_statename := sqlget({m2},{STATE_NAME})</l></m_statename><m_distname value="" param="f" hidden="false"><l>firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})</l><l>m_distName := sqlget({m7},{DISTNAMEENG})</l></m_distname><m_courtcatid value="" param="f" hidden="false"><l>firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})</l><l>m_courtcatid := sqlget({m8},{COURT_CATEGOTY})</l></m_courtcatid><m_deptid value="" param="f" hidden="false"><l>firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})</l><l>m_deptid := sqlget({m4},{department_mastid})</l></m_deptid><m_courttypeid value="" param="f" hidden="false"><l>firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1})</l><l>m_courttypeid := sqlget({m3},{court_type_mastid})</l></m_courttypeid><urole value="" param="f" hidden="false"><l>firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })</l><l>urole := sqlget({m4},{groupname})</l></urole><m_cutoffdt value="" param="f" hidden="false"><l>firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})</l><l>m_cutoffdt := sqlget({a1},{dd})</l></m_cutoffdt><m_offcount value="" param="f" hidden="false"><l>firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})</l><l>m_offcount := sqlget({P1},{ct})</l></m_offcount></appvars><readonlyprops readonly_fontcolor="clBlack" readonly_bgcolor="clWindow"/><gfont/><mail><host></host><port></port><userid></userid><password></password></mail><pwdsetting><maxlogintry>0</maxlogintry><pwdexpdays>0</pwdexpdays><pwdalertdays>0</pwdalertdays><pwdminchars>0</pwdminchars><pwdprevnos>0</pwdprevnos><ispwdalphanum>F</ispwdalphanum></pwdsetting></props></root>
Step4-4
Step5
Step6
Step9
fetched the props xml
10010000-1000000
2
   Evaluating firesql({m2},{select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1})
   Calling function firesql
username=DM_bikaner
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=DM_bikaner
Time elapsed = 9
   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=DM_bikaner
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=DM_bikaner
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type})
   Calling function sqlget
   Result of sqlget = DM
   Result = DM
   Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
   Calling function firesql
username=DM_bikaner
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=DM_bikaner
Time elapsed = 9
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{court_name_mastid})
   Calling function sqlget
   Result of sqlget = 12836000000154
   Result = 12836000000154
   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=DM_bikaner
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{axusersid})
   Calling function sqlget
   Result of sqlget = 3636
   Result = 3636
   Evaluating firesql({m4},{select :username as uname from dual})
   Calling function firesql
select :username as uname from dual
username=DM_bikaner
Time elapsed = 3
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{uname})
   Calling function sqlget
   Result of sqlget = DM_bikaner
   Result = DM_bikaner
   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=DM_bikaner
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{COURT_CODE})
   Calling function sqlget
   Result of sqlget = 10401
   Result = 10401
   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 = 3
   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=DM_bikaner
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=DM_bikaner
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m7},{DISTNAMEENG})
   Calling function sqlget
   Result of sqlget = Bikaner
   Result = Bikaner
   Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=DM_bikaner
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=DM_bikaner
Time elapsed = 8
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m8},{COURT_CATEGOTY})
   Calling function sqlget
   Result of sqlget = 10593000000007
   Result = 10593000000007
   Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid})
   Calling function firesql
login_userid=3636
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=3636
Time elapsed = 11
   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=DM_bikaner
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type_mastid})
   Calling function sqlget
   Result of sqlget = 10206000000014
   Result = 10206000000014
   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=DM_bikaner
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=DM_bikaner
Time elapsed = 8
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{groupname})
   Calling function sqlget
   Result of sqlget = court_reader
   Result = court_reader
   Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
   Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 6
   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=DM_bikaner
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=DM_bikaner
Time elapsed = 15
   Result of firesql = 
   Result = 
   Evaluating  sqlget({P1},{ct})
   Calling function sqlget
   Result of sqlget = 3
   Result = 3
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='trcmf' and stype = 't' )

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

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

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

Time elapsed = 3
Reading data from stream

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

Paramval : trcmf
ParamTYpe : c
Param List : name

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

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

Paramval : tchdh
ParamTYpe : c
Param List : name

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

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

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

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

Time elapsed = 6
RecordId = 12045000010009
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
hearing_date = 10/02/2022
courtcode = 10401
Posting record
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:38
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=10/02/2022 00:00:00
Param Type = c
courtcode=10401
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 = 6
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 = 6
RecordId = 12045000010010
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 18
isadjourn = NO
case_no = 2021/339
new_case_purpose = 18678000000000
pre_hear_date = 10/02/2022
adjourn_type = 0
court_code = 10401
adjourn_remark = 
next_hear_date = 08/09/2025
trn_rcms_caseid = 16128000005861
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=12045000010010
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:38
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
case_no=2021/339
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
court_code=10401
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
trn_rcms_caseid=16128000005861
Param Type = n
pre_case_purpose=18678000000000
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,isadjourn,case_no,new_case_purpose,pre_hear_date,adjourn_type,court_code,adjourn_remark,next_hear_date,trn_rcms_caseid,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,:case_no,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:court_code,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:pre_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 12045000010011
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
trn_rcms_caseid = 16158000005915
next_hear_date = 08/09/2025
new_case_purpose = 18678000000000
adjourn_type = 0
adjourn_remark = 
case_no = 2021/340
pre_hear_date = 10/02/2022
isadjourn = NO
court_code = 10401
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=12045000010011
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:38
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=16158000005915
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/340
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
court_code=10401
Param Type = n
pre_case_purpose=18678000000000
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,trn_rcms_caseid,next_hear_date,new_case_purpose,adjourn_type,adjourn_remark,case_no,pre_hear_date,isadjourn,court_code,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 12045000010012
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 10/02/2022
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16195000005790
court_code = 10401
case_no = 2021/342
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 08/09/2025
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=12045000010012
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:38
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16195000005790
Param Type = c
court_code=10401
Param Type = c
case_no=2021/342
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/09/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 = 11
Adding new record to store data from Frame 2, Row 4 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 6
RecordId = 12045000010013
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 10
next_hear_date = 08/09/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2021/343
court_code = 10401
trn_rcms_caseid = 16209000005449
pre_case_purpose = 18678000000000
pre_hear_date = 10/02/2022
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=12045000010013
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:38
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/343
Param Type = c
court_code=10401
Param Type = c
trn_rcms_caseid=16209000005449
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 7
RecordId = 12045000010014
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 9
next_hear_date = 08/09/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2021/344
court_code = 10401
trn_rcms_caseid = 16228000005692
pre_case_purpose = 18678000000000
pre_hear_date = 10/02/2022
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=12045000010014
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:38
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/344
Param Type = c
court_code=10401
Param Type = c
trn_rcms_caseid=16228000005692
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=10/02/2022 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 = 7
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 = 5
RecordId = 12045000010015
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 9
next_hear_date = 08/09/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2021/345
court_code = 10401
trn_rcms_caseid = 16312000006850
pre_case_purpose = 18678000000000
pre_hear_date = 10/02/2022
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=12045000010015
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:38
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/345
Param Type = c
court_code=10401
Param Type = c
trn_rcms_caseid=16312000006850
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=10/02/2022 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 = 10
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 = 4
RecordId = 12045000010016
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 15
Select sysdate as sdt from dual
Time elapsed = 9
pre_hear_date = 10/02/2022
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16375000006317
court_code = 10401
case_no = 2021/347
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 08/09/2025
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=12045000010016
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:38
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16375000006317
Param Type = c
court_code=10401
Param Type = c
case_no=2021/347
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 15
RecordId = 12045000010017
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 11
adjourn_remark = 
new_case_purpose = 18678000000000
adjourn_type = 0
next_hear_date = 08/09/2025
isadjourn = NO
case_no = 2021/349
court_code = 10401
trn_rcms_caseid = 16528000005880
pre_case_purpose = 18678000000000
pre_hear_date = 10/02/2022
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=12045000010017
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:38
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2021/349
Param Type = c
court_code=10401
Param Type = c
trn_rcms_caseid=16528000005880
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,new_case_purpose,adjourn_type,next_hear_date,isadjourn,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:new_case_purpose,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 12045000010018
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 10
pre_hear_date = 10/02/2022
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16548000007311
court_code = 10401
case_no = 2021/350
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 08/09/2025
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=12045000010018
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:38
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16548000007311
Param Type = c
court_code=10401
Param Type = c
case_no=2021/350
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,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 = 9
Adding new record to store data from Frame 2, Row 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 12045000010019
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 8
new_case_purpose = 18678000000000
adjourn_remark = 
isadjourn = NO
next_hear_date = 08/09/2025
pre_case_purpose = 18678000000000
case_no = 2021/352
court_code = 10401
pre_hear_date = 10/02/2022
trn_rcms_caseid = 16571000006286
adjourn_type = 0
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=12045000010019
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:38
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2021/352
Param Type = c
court_code=10401
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = c
trn_rcms_caseid=16571000006286
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,new_case_purpose,adjourn_remark,isadjourn,next_hear_date,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,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,null,: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,:adjourn_type,:trn_rcms_hearingrow)

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

Time elapsed = 7
RecordId = 12045000010020
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 9
trn_rcms_caseid = 16586000006756
isadjourn = NO
court_code = 10401
adjourn_remark = 
adjourn_type = 0
pre_hear_date = 10/02/2022
pre_case_purpose = 18678000000000
new_case_purpose = 18678000000000
next_hear_date = 08/09/2025
case_no = 2021/353
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=12045000010020
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=16586000006756
Param Type = c
isadjourn=NO
Param Type = c
court_code=10401
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/353
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,trn_rcms_caseid,isadjourn,court_code,adjourn_remark,adjourn_type,pre_hear_date,pre_case_purpose,new_case_purpose,next_hear_date,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,:trn_rcms_caseid,:isadjourn,:court_code,null,:adjourn_type,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),: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 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 10
RecordId = 12045000010021
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
court_code = 10401
isadjourn = NO
next_hear_date = 08/09/2025
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 18678000000000
trn_rcms_caseid = 16604000006157
case_no = 2021/354
pre_case_purpose = 18678000000000
pre_hear_date = 10/02/2022
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=12045000010021
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10401
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16604000006157
Param Type = c
case_no=2021/354
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=10/02/2022 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,court_code,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,trn_rcms_caseid,case_no,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,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,:trn_rcms_caseid,:case_no,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 12045000010022
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 10/02/2022
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16614000005462
court_code = 10401
case_no = 2021/355
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 08/09/2025
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=12045000010022
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16614000005462
Param Type = c
court_code=10401
Param Type = c
case_no=2021/355
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/09/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 = 6
Adding new record to store data from Frame 2, Row 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 12045000010023
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 08/09/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2021/356
court_code = 10401
trn_rcms_caseid = 16620000005796
pre_case_purpose = 18678000000000
pre_hear_date = 10/02/2022
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=12045000010023
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/356
Param Type = c
court_code=10401
Param Type = c
trn_rcms_caseid=16620000005796
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=10/02/2022 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 = 6
Adding new record to store data from Frame 2, Row 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 12045000010024
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 8
pre_hear_date = 10/02/2022
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16629000006426
court_code = 10401
case_no = 2021/357
adjourn_remark = 
adjourn_type = 0
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 08/09/2025
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=12045000010024
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16629000006426
Param Type = c
court_code=10401
Param Type = c
case_no=2021/357
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_remark,adjourn_type,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,null,:adjourn_type,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 12045000010025
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 10/02/2022
trn_rcms_caseid = 16640000006063
court_code = 10401
case_no = 2021/358
pre_case_purpose = 18678000000000
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 08/09/2025
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=12045000010025
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = c
trn_rcms_caseid=16640000006063
Param Type = c
court_code=10401
Param Type = c
case_no=2021/358
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,court_code,case_no,pre_case_purpose,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'),:trn_rcms_caseid,:court_code,:case_no,:pre_case_purpose,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 12045000010026
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 8
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 08/09/2025
pre_hear_date = 10/02/2022
trn_rcms_caseid = 16707000005982
pre_case_purpose = 18678000000000
court_code = 10401
adjourn_remark = 
isadjourn = NO
case_no = 2021/359
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=12045000010026
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = c
trn_rcms_caseid=16707000005982
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
court_code=10401
Param Type = c
isadjourn=NO
Param Type = c
case_no=2021/359
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,adjourn_type,new_case_purpose,next_hear_date,pre_hear_date,trn_rcms_caseid,pre_case_purpose,court_code,adjourn_remark,isadjourn,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:pre_case_purpose,:court_code,null,:isadjourn,:case_no,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 12045000010027
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2021/360
court_code = 10401
pre_case_purpose = 18678000000000
adjourn_type = 0
isadjourn = NO
next_hear_date = 08/09/2025
adjourn_remark = 
trn_rcms_caseid = 16712000005606
new_case_purpose = 18678000000000
pre_hear_date = 10/02/2022
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=12045000010027
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2021/360
Param Type = c
court_code=10401
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
trn_rcms_caseid=16712000005606
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=10/02/2022 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,case_no,court_code,pre_case_purpose,adjourn_type,isadjourn,next_hear_date,adjourn_remark,trn_rcms_caseid,new_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,:case_no,:court_code,:pre_case_purpose,:adjourn_type,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:trn_rcms_caseid,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 12045000010028
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 9
pre_hear_date = 10/02/2022
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16720000006440
court_code = 10401
case_no = 2021/361
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18678000000000
next_hear_date = 08/09/2025
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=12045000010028
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16720000006440
Param Type = c
court_code=10401
Param Type = c
case_no=2021/361
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/09/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,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 5
RecordId = 12045000010029
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 08/09/2025
new_case_purpose = 18678000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2021/362
court_code = 10401
trn_rcms_caseid = 16728000006441
pre_case_purpose = 18678000000000
pre_hear_date = 10/02/2022
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=12045000010029
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2021/362
Param Type = c
court_code=10401
Param Type = c
trn_rcms_caseid=16728000006441
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 12045000010030
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 08/09/2025
isadjourn = NO
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 10/02/2022
case_no = 2021/363
court_code = 10401
trn_rcms_caseid = 16746000006460
adjourn_type = 0
adjourn_remark = 
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=12045000010030
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = c
case_no=2021/363
Param Type = c
court_code=10401
Param Type = c
trn_rcms_caseid=16746000006460
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_type,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:adjourn_type,null,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 12045000010031
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 12
pre_hear_date = 10/02/2022
pre_case_purpose = 18678000000000
trn_rcms_caseid = 16782000005999
court_code = 10401
case_no = 2021/364
isadjourn = NO
adjourn_type = 0
next_hear_date = 08/09/2025
adjourn_remark = 
new_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=12045000010031
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=16782000005999
Param Type = c
court_code=10401
Param Type = c
case_no=2021/364
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_type,next_hear_date,adjourn_remark,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:new_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 2
RecordId = 12045000010032
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 7
court_code = 10401
isadjourn = NO
next_hear_date = 08/09/2025
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 18678000000000
pre_hear_date = 10/02/2022
trn_rcms_caseid = 16852000005663
case_no = 2021/365
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=12045000010032
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10401
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = c
trn_rcms_caseid=16852000005663
Param Type = c
case_no=2021/365
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,pre_hear_date,trn_rcms_caseid,case_no,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,: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 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 12045000010033
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 4
court_code = 10401
pre_case_purpose = 18678000000000
case_no = 2021/366
trn_rcms_caseid = 16868000006104
pre_hear_date = 10/02/2022
new_case_purpose = 18678000000000
adjourn_type = 0
adjourn_remark = 
next_hear_date = 08/09/2025
isadjourn = NO
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=12045000010033
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10401
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2021/366
Param Type = c
trn_rcms_caseid=16868000006104
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
isadjourn=NO
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,court_code,pre_case_purpose,case_no,trn_rcms_caseid,pre_hear_date,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:pre_case_purpose,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)

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

Time elapsed = 5
RecordId = 12045000010034
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark = 
trn_rcms_caseid = 16912000006243
pre_hear_date = 10/02/2022
court_code = 10401
case_no = 2021/367
pre_case_purpose = 18678000000000
isadjourn = NO
adjourn_type = 0
new_case_purpose = 18678000000000
next_hear_date = 08/09/2025
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=12045000010034
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=16912000006243
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = c
court_code=10401
Param Type = c
case_no=2021/367
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 5
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 = 4
RecordId = 12045000010035
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 15
adjourn_remark = 
isadjourn = NO
trn_rcms_caseid = 15815000006168
pre_case_purpose = 18473000000000
pre_hear_date = 10/02/2022
case_no = 2021/370
new_case_purpose = 18473000000000
adjourn_type = 0
court_code = 10401
next_hear_date = 08/09/2025
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=12045000010035
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=15815000006168
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = c
case_no=2021/370
Param Type = c
new_case_purpose=18473000000000
Param Type = c
adjourn_type=0
Param Type = c
court_code=10401
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,isadjourn,trn_rcms_caseid,pre_case_purpose,pre_hear_date,case_no,new_case_purpose,adjourn_type,court_code,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,:isadjourn,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:new_case_purpose,:adjourn_type,:court_code,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 27 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 12045000010036
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 8
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 15885000006042
pre_hear_date = 10/02/2022
court_code = 10401
case_no = 2021/372
next_hear_date = 08/09/2025
isadjourn = NO
pre_case_purpose = 18473000000000
new_case_purpose = 18473000000000
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=12045000010036
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=15885000006042
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = c
court_code=10401
Param Type = c
case_no=2021/372
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
new_case_purpose=18473000000000
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_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 12045000010037
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 24
adjourn_type = 0
adjourn_remark = 
pre_hear_date = 10/02/2022
trn_rcms_caseid = 15889000005460
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
next_hear_date = 08/09/2025
isadjourn = NO
case_no = 2021/373
court_code = 10401
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=12045000010037
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = c
trn_rcms_caseid=15889000005460
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
case_no=2021/373
Param Type = c
court_code=10401
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,pre_hear_date,trn_rcms_caseid,new_case_purpose,pre_case_purpose,next_hear_date,isadjourn,case_no,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:case_no,:court_code,: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 29 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 12045000010038
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 14
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
trn_rcms_caseid = 15896000007193
case_no = 2021/374
court_code = 10401
pre_hear_date = 10/02/2022
next_hear_date = 08/09/2025
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=12045000010038
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:40
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:40
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=15896000007193
Param Type = c
case_no=2021/374
Param Type = c
court_code=10401
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
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,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 12045000010039
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 25
Select sysdate as sdt from dual
Time elapsed = 14
isadjourn = NO
adjourn_type = 0
adjourn_remark = 
case_no = 2021/375
court_code = 10401
pre_hear_date = 10/02/2022
trn_rcms_caseid = 15907000006018
next_hear_date = 08/09/2025
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=12045000010039
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:40
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:40
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
case_no=2021/375
Param Type = c
court_code=10401
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = c
trn_rcms_caseid=15907000006018
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,case_no,court_code,pre_hear_date,trn_rcms_caseid,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,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,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 31 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 6
RecordId = 12045000010040
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 3
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
next_hear_date = 08/09/2025
trn_rcms_caseid = 15912000006040
case_no = 2021/376
court_code = 10401
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
pre_hear_date = 10/02/2022
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=12045000010040
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:40
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:40
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=08/09/2025 00:00:00
Param Type = c
trn_rcms_caseid=15912000006040
Param Type = c
case_no=2021/376
Param Type = c
court_code=10401
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=10/02/2022 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,isadjourn,adjourn_remark,adjourn_type,next_hear_date,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,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 12045000010041
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 24
next_hear_date = 08/09/2025
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 16018000005806
court_code = 10401
case_no = 2021/381
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
pre_hear_date = 10/02/2022
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=12045000010041
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:40
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=16018000005806
Param Type = c
court_code=10401
Param Type = c
case_no=2021/381
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = n
trn_rcms_hearingrow=32
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,court_code,case_no,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,:court_code,:case_no,: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 = 6
Adding new record to store data from Frame 2, Row 33 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 12045000010042
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 08/09/2025
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 18473000000000
case_no = 2021/383
court_code = 10401
trn_rcms_caseid = 18719000006489
pre_case_purpose = 18473000000000
pre_hear_date = 10/02/2022
TRN_RCMS_HEARINGrow = 33
Posting record
Param Type = n
trn_rcms_hearingid=12045000010042
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:40
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18473000000000
Param Type = c
case_no=2021/383
Param Type = c
court_code=10401
Param Type = c
trn_rcms_caseid=18719000006489
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = n
trn_rcms_hearingrow=33
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 34 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 13
RecordId = 12045000010043
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 30
Select sysdate as sdt from dual
Time elapsed = 13
next_hear_date = 08/09/2025
new_case_purpose = 18473000000000
adjourn_remark = 
adjourn_type = 0
isadjourn = NO
case_no = 2021/389
court_code = 10401
trn_rcms_caseid = 18822000005861
pre_case_purpose = 18473000000000
pre_hear_date = 10/02/2022
TRN_RCMS_HEARINGrow = 34
Posting record
Param Type = n
trn_rcms_hearingid=12045000010043
Param Type = n
trn_rcms_mhearingid=12045000010009
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:40
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=08/09/2025 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2021/389
Param Type = c
court_code=10401
Param Type = c
trn_rcms_caseid=18822000005861
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=10/02/2022 00:00:00
Param Type = n
trn_rcms_hearingrow=34
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 = 3965627984386

>>Executing genmaps

>>Posting from trcmf to tchdh from row 1

>>Mapping
Mapped court_code Row = 1 value = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16128000005861 idvalue 0
Mapped case_no Row = 1 value = 2021/339 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16128000005861
case_no = 2021/339
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 28
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 21
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 = 12045000010044
MapName trcmf1
SourceId 12045000010010
Select sysdate as sdt from dual
Time elapsed = 12
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/339
trn_rcms_caseregid = 16128000005861
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010044
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010010
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:40
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/339
Param Type = c
trn_rcms_caseregid=16128000005861
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16158000005915 idvalue 0
Mapped case_no Row = 1 value = 2021/340 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16158000005915
case_no = 2021/340
prev_hearing_date = 10/02/2022
hearing_date = 08/09/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 13
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 4
RecordId = 12045000010045
MapName trcmf1
SourceId 12045000010011
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 16
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/340
trn_rcms_caseregid = 16158000005915
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010045
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010011
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:44
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/340
Param Type = c
trn_rcms_caseregid=16158000005915
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16195000005790 idvalue 0
Mapped case_no Row = 1 value = 2021/342 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16195000005790
case_no = 2021/342
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 2
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 = 4
RecordId = 12045000010046
MapName trcmf1
SourceId 12045000010012
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/342
trn_rcms_caseregid = 16195000005790
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010046
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010012
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:47
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:47
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/342
Param Type = c
trn_rcms_caseregid=16195000005790
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16209000005449 idvalue 0
Mapped case_no Row = 1 value = 2021/343 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16209000005449
case_no = 2021/343
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 7
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 12045000010047
MapName trcmf1
SourceId 12045000010013
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/343
trn_rcms_caseregid = 16209000005449
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010047
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010013
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:50
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19: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=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/343
Param Type = c
trn_rcms_caseregid=16209000005449
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16228000005692 idvalue 0
Mapped case_no Row = 1 value = 2021/344 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16228000005692
case_no = 2021/344
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 5
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 = 4
RecordId = 12045000010048
MapName trcmf1
SourceId 12045000010014
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 27
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/344
trn_rcms_caseregid = 16228000005692
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010048
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010014
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:53
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19: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=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/344
Param Type = c
trn_rcms_caseregid=16228000005692
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16312000006850 idvalue 0
Mapped case_no Row = 1 value = 2021/345 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16312000006850
case_no = 2021/345
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 11
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 24
RecordId = 12045000010049
MapName trcmf1
SourceId 12045000010015
Select sysdate as sdt from dual
Time elapsed = 47
Select sysdate as sdt from dual
Time elapsed = 24
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/345
trn_rcms_caseregid = 16312000006850
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010049
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010015
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:19:56
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:19:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/345
Param Type = c
trn_rcms_caseregid=16312000006850
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16375000006317 idvalue 0
Mapped case_no Row = 1 value = 2021/347 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16375000006317
case_no = 2021/347
prev_hearing_date = 10/02/2022
hearing_date = 08/09/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 11
RecordId = 12045000010050
MapName trcmf1
SourceId 12045000010016
Select sysdate as sdt from dual
Time elapsed = 38
Select sysdate as sdt from dual
Time elapsed = 29
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/347
trn_rcms_caseregid = 16375000006317
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010050
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010016
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:00
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/347
Param Type = c
trn_rcms_caseregid=16375000006317
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16528000005880 idvalue 0
Mapped case_no Row = 1 value = 2021/349 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16528000005880
case_no = 2021/349
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 19
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 = 4
RecordId = 12045000010051
MapName trcmf1
SourceId 12045000010017
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 19
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/349
trn_rcms_caseregid = 16528000005880
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010051
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010017
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:03
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:03
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/349
Param Type = c
trn_rcms_caseregid=16528000005880
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16548000007311 idvalue 0
Mapped case_no Row = 1 value = 2021/350 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16548000007311
case_no = 2021/350
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 3
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 12045000010052
MapName trcmf1
SourceId 12045000010018
Select sysdate as sdt from dual
Time elapsed = 2
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 = 08/09/2025
case_no = 2021/350
trn_rcms_caseregid = 16548000007311
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010052
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010018
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:06
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20: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=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/350
Param Type = c
trn_rcms_caseregid=16548000007311
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16571000006286 idvalue 0
Mapped case_no Row = 1 value = 2021/352 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16571000006286
case_no = 2021/352
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 4
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 12045000010053
MapName trcmf1
SourceId 12045000010019
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/352
trn_rcms_caseregid = 16571000006286
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010053
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010019
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:09
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/352
Param Type = c
trn_rcms_caseregid=16571000006286
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16586000006756 idvalue 0
Mapped case_no Row = 1 value = 2021/353 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16586000006756
case_no = 2021/353
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 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 = 4
RecordId = 12045000010054
MapName trcmf1
SourceId 12045000010020
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 = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/353
trn_rcms_caseregid = 16586000006756
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010054
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010020
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:13
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:13
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/353
Param Type = c
trn_rcms_caseregid=16586000006756
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16604000006157 idvalue 0
Mapped case_no Row = 1 value = 2021/354 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16604000006157
case_no = 2021/354
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 12045000010055
MapName trcmf1
SourceId 12045000010021
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 17
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/354
trn_rcms_caseregid = 16604000006157
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010055
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010021
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:16
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:16
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/354
Param Type = c
trn_rcms_caseregid=16604000006157
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16614000005462 idvalue 0
Mapped case_no Row = 1 value = 2021/355 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16614000005462
case_no = 2021/355
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 21
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 = 12045000010056
MapName trcmf1
SourceId 12045000010022
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 = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/355
trn_rcms_caseregid = 16614000005462
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010056
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010022
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:19
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20: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=08/09/2025 00:00:00
Param Type = c
case_no=2021/355
Param Type = c
trn_rcms_caseregid=16614000005462
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16620000005796 idvalue 0
Mapped case_no Row = 1 value = 2021/356 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16620000005796
case_no = 2021/356
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 12
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 12045000010057
MapName trcmf1
SourceId 12045000010023
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 = 08/09/2025
case_no = 2021/356
trn_rcms_caseregid = 16620000005796
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010057
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010023
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:22
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/356
Param Type = c
trn_rcms_caseregid=16620000005796
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16629000006426 idvalue 0
Mapped case_no Row = 1 value = 2021/357 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16629000006426
case_no = 2021/357
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 17
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 6
RecordId = 12045000010058
MapName trcmf1
SourceId 12045000010024
Select sysdate as sdt from dual
Time elapsed = 12
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 = 08/09/2025
case_no = 2021/357
trn_rcms_caseregid = 16629000006426
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010058
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010024
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:25
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/357
Param Type = c
trn_rcms_caseregid=16629000006426
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16640000006063 idvalue 0
Mapped case_no Row = 1 value = 2021/358 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16640000006063
case_no = 2021/358
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 21
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 = 12045000010059
MapName trcmf1
SourceId 12045000010025
Select sysdate as sdt from dual
Time elapsed = 32
Select sysdate as sdt from dual
Time elapsed = 35
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/358
trn_rcms_caseregid = 16640000006063
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010059
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010025
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:28
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:28
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/358
Param Type = c
trn_rcms_caseregid=16640000006063
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16707000005982 idvalue 0
Mapped case_no Row = 1 value = 2021/359 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16707000005982
case_no = 2021/359
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 5
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 10
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 12045000010060
MapName trcmf1
SourceId 12045000010026
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 18
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/359
trn_rcms_caseregid = 16707000005982
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010060
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010026
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:32
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/359
Param Type = c
trn_rcms_caseregid=16707000005982
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16712000005606 idvalue 0
Mapped case_no Row = 1 value = 2021/360 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16712000005606
case_no = 2021/360
prev_hearing_date = 10/02/2022
hearing_date = 08/09/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12045000010061
MapName trcmf1
SourceId 12045000010027
Select sysdate as sdt from dual
Time elapsed = 28
Select sysdate as sdt from dual
Time elapsed = 24
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/360
trn_rcms_caseregid = 16712000005606
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010061
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010027
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:35
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:35
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/360
Param Type = c
trn_rcms_caseregid=16712000005606
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16720000006440 idvalue 0
Mapped case_no Row = 1 value = 2021/361 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16720000006440
case_no = 2021/361
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 10
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 7
RecordId = 12045000010062
MapName trcmf1
SourceId 12045000010028
Select sysdate as sdt from dual
Time elapsed = 18
Select sysdate as sdt from dual
Time elapsed = 19
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/361
trn_rcms_caseregid = 16720000006440
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010062
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010028
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:39
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/361
Param Type = c
trn_rcms_caseregid=16720000006440
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16728000006441 idvalue 0
Mapped case_no Row = 1 value = 2021/362 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16728000006441
case_no = 2021/362
prev_hearing_date = 10/02/2022
hearing_date = 08/09/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 12045000010063
MapName trcmf1
SourceId 12045000010029
Select sysdate as sdt from dual
Time elapsed = 8
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/362
trn_rcms_caseregid = 16728000006441
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010063
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010029
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:42
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/362
Param Type = c
trn_rcms_caseregid=16728000006441
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16746000006460 idvalue 0
Mapped case_no Row = 1 value = 2021/363 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16746000006460
case_no = 2021/363
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 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 = 12045000010064
MapName trcmf1
SourceId 12045000010030
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 20
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/363
trn_rcms_caseregid = 16746000006460
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010064
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010030
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:45
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:45
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/363
Param Type = c
trn_rcms_caseregid=16746000006460
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16782000005999 idvalue 0
Mapped case_no Row = 1 value = 2021/364 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16782000005999
case_no = 2021/364
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 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 = 4
RecordId = 12045000010065
MapName trcmf1
SourceId 12045000010031
Select sysdate as sdt from dual
Time elapsed = 14
Select sysdate as sdt from dual
Time elapsed = 26
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/364
trn_rcms_caseregid = 16782000005999
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010065
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010031
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:48
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:48
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/364
Param Type = c
trn_rcms_caseregid=16782000005999
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16852000005663 idvalue 0
Mapped case_no Row = 1 value = 2021/365 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16852000005663
case_no = 2021/365
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 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 = 11
RecordId = 12045000010066
MapName trcmf1
SourceId 12045000010032
Select sysdate as sdt from dual
Time elapsed = 13
Select sysdate as sdt from dual
Time elapsed = 37
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/365
trn_rcms_caseregid = 16852000005663
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010066
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010032
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:51
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:51
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/365
Param Type = c
trn_rcms_caseregid=16852000005663
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16868000006104 idvalue 0
Mapped case_no Row = 1 value = 2021/366 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16868000006104
case_no = 2021/366
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 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 = 6
RecordId = 12045000010067
MapName trcmf1
SourceId 12045000010033
Select sysdate as sdt from dual
Time elapsed = 19
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/366
trn_rcms_caseregid = 16868000006104
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010067
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010033
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:55
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:55
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/366
Param Type = c
trn_rcms_caseregid=16868000006104
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16912000006243 idvalue 0
Mapped case_no Row = 1 value = 2021/367 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 08/09/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 = 10401
trn_rcms_caseregid = 16912000006243
case_no = 2021/367
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 12045000010068
MapName trcmf1
SourceId 12045000010034
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 08/09/2025
case_no = 2021/367
trn_rcms_caseregid = 16912000006243
court_code = 10401
case_purpose = 18678000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010068
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010034
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:20:58
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:20:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/367
Param Type = c
trn_rcms_caseregid=16912000006243
Param Type = c
court_code=10401
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15815000006168 idvalue 0
Mapped case_no Row = 1 value = 2021/370 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 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 = 08/09/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 = 10401
trn_rcms_caseregid = 15815000006168
case_no = 2021/370
prev_hearing_date = 10/02/2022
hearing_date = 08/09/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 = 14
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 8
RecordId = 12045000010069
MapName trcmf1
SourceId 12045000010035
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 11
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 08/09/2025
case_no = 2021/370
trn_rcms_caseregid = 15815000006168
court_code = 10401
case_purpose = 18473000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010069
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010035
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:21:01
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:21:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/370
Param Type = c
trn_rcms_caseregid=15815000006168
Param Type = c
court_code=10401
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15885000006042 idvalue 0
Mapped case_no Row = 1 value = 2021/372 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 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 = 08/09/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 = 10401
trn_rcms_caseregid = 15885000006042
case_no = 2021/372
prev_hearing_date = 10/02/2022
hearing_date = 08/09/2025
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 2
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 5
RecordId = 12045000010070
MapName trcmf1
SourceId 12045000010036
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 08/09/2025
case_no = 2021/372
trn_rcms_caseregid = 15885000006042
court_code = 10401
case_purpose = 18473000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010070
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010036
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:21:04
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:21: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=18473000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/372
Param Type = c
trn_rcms_caseregid=15885000006042
Param Type = c
court_code=10401
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15889000005460 idvalue 0
Mapped case_no Row = 1 value = 2021/373 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 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 = 08/09/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 = 10401
trn_rcms_caseregid = 15889000005460
case_no = 2021/373
prev_hearing_date = 10/02/2022
hearing_date = 08/09/2025
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 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 = 4
RecordId = 12045000010071
MapName trcmf1
SourceId 12045000010037
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 08/09/2025
case_no = 2021/373
trn_rcms_caseregid = 15889000005460
court_code = 10401
case_purpose = 18473000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010071
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010037
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:21:07
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:21:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/373
Param Type = c
trn_rcms_caseregid=15889000005460
Param Type = c
court_code=10401
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15896000007193 idvalue 0
Mapped case_no Row = 1 value = 2021/374 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 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 = 08/09/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 = 10401
trn_rcms_caseregid = 15896000007193
case_no = 2021/374
prev_hearing_date = 10/02/2022
hearing_date = 08/09/2025
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 12045000010072
MapName trcmf1
SourceId 12045000010038
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 = 18473000000000
hearing_date = 08/09/2025
case_no = 2021/374
trn_rcms_caseregid = 15896000007193
court_code = 10401
case_purpose = 18473000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010072
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010038
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:21:11
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:21: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=18473000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/374
Param Type = c
trn_rcms_caseregid=15896000007193
Param Type = c
court_code=10401
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15907000006018 idvalue 0
Mapped case_no Row = 1 value = 2021/375 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 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 = 08/09/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 = 10401
trn_rcms_caseregid = 15907000006018
case_no = 2021/375
prev_hearing_date = 10/02/2022
hearing_date = 08/09/2025
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 21
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 = 12045000010073
MapName trcmf1
SourceId 12045000010039
Select sysdate as sdt from dual
Time elapsed = 17
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 = 18473000000000
hearing_date = 08/09/2025
case_no = 2021/375
trn_rcms_caseregid = 15907000006018
court_code = 10401
case_purpose = 18473000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010073
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010039
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:21:14
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:21: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=18473000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/375
Param Type = c
trn_rcms_caseregid=15907000006018
Param Type = c
court_code=10401
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15912000006040 idvalue 0
Mapped case_no Row = 1 value = 2021/376 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 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 = 08/09/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 = 10401
trn_rcms_caseregid = 15912000006040
case_no = 2021/376
prev_hearing_date = 10/02/2022
hearing_date = 08/09/2025
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 19
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 = 12045000010074
MapName trcmf1
SourceId 12045000010040
Select sysdate as sdt from dual
Time elapsed = 39
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 = 18473000000000
hearing_date = 08/09/2025
case_no = 2021/376
trn_rcms_caseregid = 15912000006040
court_code = 10401
case_purpose = 18473000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010074
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010040
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:21:17
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:21: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=18473000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/376
Param Type = c
trn_rcms_caseregid=15912000006040
Param Type = c
court_code=10401
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16018000005806 idvalue 0
Mapped case_no Row = 1 value = 2021/381 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 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 = 08/09/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 = 10401
trn_rcms_caseregid = 16018000005806
case_no = 2021/381
prev_hearing_date = 10/02/2022
hearing_date = 08/09/2025
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 21
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 = 12045000010075
MapName trcmf1
SourceId 12045000010041
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 08/09/2025
case_no = 2021/381
trn_rcms_caseregid = 16018000005806
court_code = 10401
case_purpose = 18473000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010075
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010041
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:21:20
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:21:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/381
Param Type = c
trn_rcms_caseregid=16018000005806
Param Type = c
court_code=10401
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/02/2022 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 33

>>Mapping
Mapped court_code Row = 1 value = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18719000006489 idvalue 0
Mapped case_no Row = 1 value = 2021/383 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 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 = 08/09/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 = 10401
trn_rcms_caseregid = 18719000006489
case_no = 2021/383
prev_hearing_date = 10/02/2022
hearing_date = 08/09/2025
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 9
RecordId = 12045000010076
MapName trcmf1
SourceId 12045000010042
Select sysdate as sdt from dual
Time elapsed = 30
Select sysdate as sdt from dual
Time elapsed = 41
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 08/09/2025
case_no = 2021/383
trn_rcms_caseregid = 18719000006489
court_code = 10401
case_purpose = 18473000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010076
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010042
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:21:24
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:21: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=18473000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/383
Param Type = c
trn_rcms_caseregid=18719000006489
Param Type = c
court_code=10401
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/02/2022 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 34

>>Mapping
Mapped court_code Row = 1 value = 10401 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18822000005861 idvalue 0
Mapped case_no Row = 1 value = 2021/389 idvalue 0
Mapped prev_hearing_date Row = 1 value = 10/02/2022 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 = 08/09/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 = 10401
trn_rcms_caseregid = 18822000005861
case_no = 2021/389
prev_hearing_date = 10/02/2022
hearing_date = 08/09/2025
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 12045000010077
MapName trcmf1
SourceId 12045000010043
Select sysdate as sdt from dual
Time elapsed = 19
Select sysdate as sdt from dual
Time elapsed = 15
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 08/09/2025
case_no = 2021/389
trn_rcms_caseregid = 18822000005861
court_code = 10401
case_purpose = 18473000000000
prev_hearing_date = 10/02/2022
Posting record
Param Type = n
trn_rcms_case_histid=12045000010077
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=12045000010043
Param Type = c
cancel=F
Param Type = c
createdby=DM_bikaner
Param Type = c
createdon=29/08/2025 11:21:27
Param Type = c
username=DM_bikaner
Param Type = c
modifiedon=29/08/2025 11:21: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=18473000000000
Param Type = c
hearing_date=08/09/2025 00:00:00
Param Type = c
case_no=2021/389
Param Type = c
trn_rcms_caseregid=18822000005861
Param Type = c
court_code=10401
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=10/02/2022 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 = 3965628095230
Time elapsed for MD Map = 3965628095230
Time elapsed for Save History = 3965628095231
Time elapsed for Save Attachment = 3965628095231
Time elapsed for After Save WF Exec = 3965628095236
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"12045000010009"}]}
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=DM_bikaner
Param Type = c
calledon=29/08/2025 11:19:41
Param Type = c
callfinished=29/08/2025 11:21:35
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=113696
Param Type = n
dbtimetaken=111645
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