ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
<transaction username="RAA_kota" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>RAA_kota</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">10421</courtcode><hearing_date rowno="001">03/05/2024</hearing_date><axp_recid2 rowno="001">0</axp_recid2><court_code rowno="001">10421</court_code><case_no rowno="001">2022/159</case_no><trn_rcms_caseid rowno="001">13872000006017</trn_rcms_caseid><pre_case_purpose_name rowno="001">??? ????????? ???? ?????????</pre_case_purpose_name><pre_hear_date rowno="001">03/05/2024</pre_hear_date><pre_case_purpose rowno="001">10151000000586</pre_case_purpose><next_hear_date rowno="001">14/05/2024</next_hear_date><new_case_purpose rowno="001">10151000000586</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">10421</court_code><case_no rowno="002">2014/00103</case_no><trn_rcms_caseid rowno="002">13003000000521</trn_rcms_caseid><pre_case_purpose_name rowno="002">?????</pre_case_purpose_name><pre_hear_date rowno="002">03/05/2024</pre_hear_date><pre_case_purpose rowno="002">1000492</pre_case_purpose><next_hear_date rowno="002">21/05/2024</next_hear_date><new_case_purpose rowno="002">1000492</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">10421</court_code><case_no rowno="003">2016/00076</case_no><trn_rcms_caseid rowno="003">19051000000475</trn_rcms_caseid><pre_case_purpose_name rowno="003">?????</pre_case_purpose_name><pre_hear_date rowno="003">03/05/2024</pre_hear_date><pre_case_purpose rowno="003">1000492</pre_case_purpose><next_hear_date rowno="003">06/05/2024</next_hear_date><new_case_purpose rowno="003">1000492</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">10421</court_code><case_no rowno="004">2018/00294</case_no><trn_rcms_caseid rowno="004">18947000001766</trn_rcms_caseid><pre_case_purpose_name rowno="004">?????</pre_case_purpose_name><pre_hear_date rowno="004">03/05/2024</pre_hear_date><pre_case_purpose rowno="004">1000492</pre_case_purpose><next_hear_date rowno="004">17/05/2024</next_hear_date><new_case_purpose rowno="004">1000492</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">10421</court_code><case_no rowno="005">2019/00364</case_no><trn_rcms_caseid rowno="005">11398000003050</trn_rcms_caseid><pre_case_purpose_name rowno="005">?????</pre_case_purpose_name><pre_hear_date rowno="005">03/05/2024</pre_hear_date><pre_case_purpose rowno="005">1000492</pre_case_purpose><next_hear_date rowno="005">22/05/2024</next_hear_date><new_case_purpose rowno="005">1000492</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">10421</court_code><case_no rowno="006">2023/165</case_no><trn_rcms_caseid rowno="006">16154000007058</trn_rcms_caseid><pre_case_purpose_name rowno="006">?????</pre_case_purpose_name><pre_hear_date rowno="006">03/05/2024</pre_hear_date><pre_case_purpose rowno="006">1000492</pre_case_purpose><next_hear_date rowno="006">15/05/2024</next_hear_date><new_case_purpose rowno="006">1000492</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">10421</court_code><case_no rowno="007">2024/19</case_no><trn_rcms_caseid rowno="007">11360000007305</trn_rcms_caseid><pre_case_purpose_name rowno="007">?????</pre_case_purpose_name><pre_hear_date rowno="007">03/05/2024</pre_hear_date><pre_case_purpose rowno="007">1000492</pre_case_purpose><next_hear_date rowno="007">28/05/2024</next_hear_date><new_case_purpose rowno="007">1000492</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">10421</court_code><case_no rowno="008">2024/23</case_no><trn_rcms_caseid rowno="008">17075000007324</trn_rcms_caseid><pre_case_purpose_name rowno="008">?????</pre_case_purpose_name><pre_hear_date rowno="008">03/05/2024</pre_hear_date><pre_case_purpose rowno="008">1000492</pre_case_purpose><next_hear_date rowno="008">06/05/2024</next_hear_date><new_case_purpose rowno="008">18473000000000</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">10421</court_code><case_no rowno="009">2024/31</case_no><trn_rcms_caseid rowno="009">15316000007452</trn_rcms_caseid><pre_case_purpose_name rowno="009">?????</pre_case_purpose_name><pre_hear_date rowno="009">03/05/2024</pre_hear_date><pre_case_purpose rowno="009">1000492</pre_case_purpose><next_hear_date rowno="009">28/05/2024</next_hear_date><new_case_purpose rowno="009">1000492</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">10421</court_code><case_no rowno="0010">2024/40</case_no><trn_rcms_caseid rowno="0010">15716000007068</trn_rcms_caseid><pre_case_purpose_name rowno="0010">?????</pre_case_purpose_name><pre_hear_date rowno="0010">03/05/2024</pre_hear_date><pre_case_purpose rowno="0010">1000492</pre_case_purpose><next_hear_date rowno="0010">28/05/2024</next_hear_date><new_case_purpose rowno="0010">1000492</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">10421</court_code><case_no rowno="0011">2024/6</case_no><trn_rcms_caseid rowno="0011">19620000009052</trn_rcms_caseid><pre_case_purpose_name rowno="0011">?????</pre_case_purpose_name><pre_hear_date rowno="0011">03/05/2024</pre_hear_date><pre_case_purpose rowno="0011">1000492</pre_case_purpose><next_hear_date rowno="0011">15/05/2024</next_hear_date><new_case_purpose rowno="0011">11472000000003</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">10421</court_code><case_no rowno="0012">2017/00401</case_no><trn_rcms_caseid rowno="0012">14049000001289</trn_rcms_caseid><pre_case_purpose_name rowno="0012">???</pre_case_purpose_name><pre_hear_date rowno="0012">03/05/2024</pre_hear_date><pre_case_purpose rowno="0012">18473000000000</pre_case_purpose><next_hear_date rowno="0012">27/05/2024</next_hear_date><new_case_purpose rowno="0012">18473000000000</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">10421</court_code><case_no rowno="0013">2017/00596</case_no><trn_rcms_caseid rowno="0013">10830000001676</trn_rcms_caseid><pre_case_purpose_name rowno="0013">???</pre_case_purpose_name><pre_hear_date rowno="0013">03/05/2024</pre_hear_date><pre_case_purpose rowno="0013">18473000000000</pre_case_purpose><next_hear_date rowno="0013">15/05/2024</next_hear_date><new_case_purpose rowno="0013">18473000000000</new_case_purpose><isadjourn rowno="0013">NO</isadjourn><adjourn_type rowno="0013">0</adjourn_type><adjourn_remark rowno="0013"></adjourn_remark><axp_recid2 rowno="0014">0</axp_recid2><court_code rowno="0014">10421</court_code><case_no rowno="0014">2022/273</case_no><trn_rcms_caseid rowno="0014">12996000007407</trn_rcms_caseid><pre_case_purpose_name rowno="0014">???</pre_case_purpose_name><pre_hear_date rowno="0014">03/05/2024</pre_hear_date><pre_case_purpose rowno="0014">18473000000000</pre_case_purpose><next_hear_date rowno="0014">13/05/2024</next_hear_date><new_case_purpose rowno="0014">18473000000000</new_case_purpose><isadjourn rowno="0014">NO</isadjourn><adjourn_type rowno="0014">0</adjourn_type><adjourn_remark rowno="0014"></adjourn_remark><axp_recid2 rowno="0015">0</axp_recid2><court_code rowno="0015">10421</court_code><case_no rowno="0015">2023/105</case_no><trn_rcms_caseid rowno="0015">13667000007329</trn_rcms_caseid><pre_case_purpose_name rowno="0015">???</pre_case_purpose_name><pre_hear_date rowno="0015">03/05/2024</pre_hear_date><pre_case_purpose rowno="0015">18473000000000</pre_case_purpose><next_hear_date rowno="0015">17/05/2024</next_hear_date><new_case_purpose rowno="0015">1000492</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">10421</court_code><case_no rowno="0016">2023/142</case_no><trn_rcms_caseid rowno="0016">13239000007451</trn_rcms_caseid><pre_case_purpose_name rowno="0016">???</pre_case_purpose_name><pre_hear_date rowno="0016">03/05/2024</pre_hear_date><pre_case_purpose rowno="0016">18473000000000</pre_case_purpose><next_hear_date rowno="0016">14/05/2024</next_hear_date><new_case_purpose rowno="0016">18473000000000</new_case_purpose><isadjourn rowno="0016">NO</isadjourn><adjourn_type rowno="0016">0</adjourn_type><adjourn_remark rowno="0016"></adjourn_remark><axp_recid2 rowno="0017">0</axp_recid2><court_code rowno="0017">10421</court_code><case_no rowno="0017">2023/213</case_no><trn_rcms_caseid rowno="0017">10013000007354</trn_rcms_caseid><pre_case_purpose_name rowno="0017">???</pre_case_purpose_name><pre_hear_date rowno="0017">03/05/2024</pre_hear_date><pre_case_purpose rowno="0017">18473000000000</pre_case_purpose><next_hear_date rowno="0017">08/05/2024</next_hear_date><new_case_purpose rowno="0017">18473000000000</new_case_purpose><isadjourn rowno="0017">NO</isadjourn><adjourn_type rowno="0017">0</adjourn_type><adjourn_remark rowno="0017"></adjourn_remark><axp_recid2 rowno="0018">0</axp_recid2><court_code rowno="0018">10421</court_code><case_no rowno="0018">2017/00503</case_no><trn_rcms_caseid rowno="0018">11133000001564</trn_rcms_caseid><pre_case_purpose_name rowno="0018">???? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="0018">03/05/2024</pre_hear_date><pre_case_purpose rowno="0018">12555000000002</pre_case_purpose><next_hear_date rowno="0018">27/05/2024</next_hear_date><new_case_purpose rowno="0018">12555000000002</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">10421</court_code><case_no rowno="0019">2023/66</case_no><trn_rcms_caseid rowno="0019">13395000007141</trn_rcms_caseid><pre_case_purpose_name rowno="0019">???? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="0019">03/05/2024</pre_hear_date><pre_case_purpose rowno="0019">12555000000002</pre_case_purpose><next_hear_date rowno="0019">24/05/2024</next_hear_date><new_case_purpose rowno="0019">12555000000002</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">10421</court_code><case_no rowno="0020">2024/60</case_no><trn_rcms_caseid rowno="0020">17685000009171</trn_rcms_caseid><pre_case_purpose_name rowno="0020">???? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="0020">03/05/2024</pre_hear_date><pre_case_purpose rowno="0020">12555000000002</pre_case_purpose><next_hear_date rowno="0020">17/05/2024</next_hear_date><new_case_purpose rowno="0020">12555000000002</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">10421</court_code><case_no rowno="0021">2010/00002</case_no><trn_rcms_caseid rowno="0021">18511000000699</trn_rcms_caseid><pre_case_purpose_name rowno="0021">???? ????? ????</pre_case_purpose_name><pre_hear_date rowno="0021">03/05/2024</pre_hear_date><pre_case_purpose rowno="0021">11472000000003</pre_case_purpose><next_hear_date rowno="0021">17/05/2024</next_hear_date><new_case_purpose rowno="0021">11472000000003</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">10421</court_code><case_no rowno="0022">2012/00142</case_no><trn_rcms_caseid rowno="0022">15222000000649</trn_rcms_caseid><pre_case_purpose_name rowno="0022">???? ????? ????</pre_case_purpose_name><pre_hear_date rowno="0022">03/05/2024</pre_hear_date><pre_case_purpose rowno="0022">11472000000003</pre_case_purpose><next_hear_date rowno="0022">17/05/2024</next_hear_date><new_case_purpose rowno="0022">11472000000003</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">10421</court_code><case_no rowno="0023">2012/00151</case_no><trn_rcms_caseid rowno="0023">13203000000662</trn_rcms_caseid><pre_case_purpose_name rowno="0023">???? ????? ????</pre_case_purpose_name><pre_hear_date rowno="0023">03/05/2024</pre_hear_date><pre_case_purpose rowno="0023">11472000000003</pre_case_purpose><next_hear_date rowno="0023">17/05/2024</next_hear_date><new_case_purpose rowno="0023">11472000000003</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">10421</court_code><case_no rowno="0024">2015/00104</case_no><trn_rcms_caseid rowno="0024">17082000000384</trn_rcms_caseid><pre_case_purpose_name rowno="0024">???? ????? ????</pre_case_purpose_name><pre_hear_date rowno="0024">03/05/2024</pre_hear_date><pre_case_purpose rowno="0024">11472000000003</pre_case_purpose><next_hear_date rowno="0024">20/05/2024</next_hear_date><new_case_purpose rowno="0024">11472000000003</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">10421</court_code><case_no rowno="0025">2017/00402</case_no><trn_rcms_caseid rowno="0025">14056000001317</trn_rcms_caseid><pre_case_purpose_name rowno="0025">???? ????? ????</pre_case_purpose_name><pre_hear_date rowno="0025">03/05/2024</pre_hear_date><pre_case_purpose rowno="0025">11472000000003</pre_case_purpose><next_hear_date rowno="0025">27/05/2024</next_hear_date><new_case_purpose rowno="0025">11472000000003</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">10421</court_code><case_no rowno="0026">2018/00476</case_no><trn_rcms_caseid rowno="0026">17025000002191</trn_rcms_caseid><pre_case_purpose_name rowno="0026">???? ????? ????</pre_case_purpose_name><pre_hear_date rowno="0026">03/05/2024</pre_hear_date><pre_case_purpose rowno="0026">11472000000003</pre_case_purpose><next_hear_date rowno="0026">27/05/2024</next_hear_date><new_case_purpose rowno="0026">11472000000003</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">10421</court_code><case_no rowno="0027">2022/214</case_no><trn_rcms_caseid rowno="0027">16279000006085</trn_rcms_caseid><pre_case_purpose_name rowno="0027">???? ????? ????</pre_case_purpose_name><pre_hear_date rowno="0027">03/05/2024</pre_hear_date><pre_case_purpose rowno="0027">11472000000003</pre_case_purpose><next_hear_date rowno="0027">24/05/2024</next_hear_date><new_case_purpose rowno="0027">11472000000003</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">10421</court_code><case_no rowno="0028">2023/141</case_no><trn_rcms_caseid rowno="0028">13204000006855</trn_rcms_caseid><pre_case_purpose_name rowno="0028">???? ????? ????</pre_case_purpose_name><pre_hear_date rowno="0028">03/05/2024</pre_hear_date><pre_case_purpose rowno="0028">11472000000003</pre_case_purpose><next_hear_date rowno="0028">24/05/2024</next_hear_date><new_case_purpose rowno="0028">11472000000003</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">10421</court_code><case_no rowno="0029">2023/41</case_no><trn_rcms_caseid rowno="0029">19161000006097</trn_rcms_caseid><pre_case_purpose_name rowno="0029">???? ????? ????</pre_case_purpose_name><pre_hear_date rowno="0029">03/05/2024</pre_hear_date><pre_case_purpose rowno="0029">11472000000003</pre_case_purpose><next_hear_date rowno="0029">15/05/2024</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">10421</court_code><case_no rowno="0030">2024/41</case_no><trn_rcms_caseid rowno="0030">15723000008268</trn_rcms_caseid><pre_case_purpose_name rowno="0030">???? ????? ????</pre_case_purpose_name><pre_hear_date rowno="0030">03/05/2024</pre_hear_date><pre_case_purpose rowno="0030">11472000000003</pre_case_purpose><next_hear_date rowno="0030">27/05/2024</next_hear_date><new_case_purpose rowno="0030">11472000000003</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">10421</court_code><case_no rowno="0031">2024/42</case_no><trn_rcms_caseid rowno="0031">15741000007793</trn_rcms_caseid><pre_case_purpose_name rowno="0031">???? ????? ????</pre_case_purpose_name><pre_hear_date rowno="0031">03/05/2024</pre_hear_date><pre_case_purpose rowno="0031">11472000000003</pre_case_purpose><next_hear_date rowno="0031">27/05/2024</next_hear_date><new_case_purpose rowno="0031">11472000000003</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">10421</court_code><case_no rowno="0032">2024/49</case_no><trn_rcms_caseid rowno="0032">11447000008827</trn_rcms_caseid><pre_case_purpose_name rowno="0032">???? ????? ????</pre_case_purpose_name><pre_hear_date rowno="0032">03/05/2024</pre_hear_date><pre_case_purpose rowno="0032">11472000000003</pre_case_purpose><next_hear_date rowno="0032">20/05/2024</next_hear_date><new_case_purpose rowno="0032">11472000000003</new_case_purpose><isadjourn rowno="0032">NO</isadjourn><adjourn_type rowno="0032">0</adjourn_type><adjourn_remark rowno="0032"></adjourn_remark></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"RAA_kota","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"trcmf","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtcode":"10421","hearing_date":"03/05/2024"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"court_code":"10421","case_no":"2022/159","trn_rcms_caseid":"13872000006017","pre_case_purpose_name":"??? ????????? ???? ?????????","pre_hear_date":"03/05/2024","pre_case_purpose":"10151000000586","next_hear_date":"14/05/2024","new_case_purpose":"10151000000586","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"002","text":"0","columns":{"court_code":"10421","case_no":"2014/00103","trn_rcms_caseid":"13003000000521","pre_case_purpose_name":"?????","pre_hear_date":"03/05/2024","pre_case_purpose":"1000492","next_hear_date":"21/05/2024","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"003","text":"0","columns":{"court_code":"10421","case_no":"2016/00076","trn_rcms_caseid":"19051000000475","pre_case_purpose_name":"?????","pre_hear_date":"03/05/2024","pre_case_purpose":"1000492","next_hear_date":"06/05/2024","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"004","text":"0","columns":{"court_code":"10421","case_no":"2018/00294","trn_rcms_caseid":"18947000001766","pre_case_purpose_name":"?????","pre_hear_date":"03/05/2024","pre_case_purpose":"1000492","next_hear_date":"17/05/2024","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"005","text":"0","columns":{"court_code":"10421","case_no":"2019/00364","trn_rcms_caseid":"11398000003050","pre_case_purpose_name":"?????","pre_hear_date":"03/05/2024","pre_case_purpose":"1000492","next_hear_date":"22/05/2024","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"006","text":"0","columns":{"court_code":"10421","case_no":"2023/165","trn_rcms_caseid":"16154000007058","pre_case_purpose_name":"?????","pre_hear_date":"03/05/2024","pre_case_purpose":"1000492","next_hear_date":"15/05/2024","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"007","text":"0","columns":{"court_code":"10421","case_no":"2024/19","trn_rcms_caseid":"11360000007305","pre_case_purpose_name":"?????","pre_hear_date":"03/05/2024","pre_case_purpose":"1000492","next_hear_date":"28/05/2024","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"008","text":"0","columns":{"court_code":"10421","case_no":"2024/23","trn_rcms_caseid":"17075000007324","pre_case_purpose_name":"?????","pre_hear_date":"03/05/2024","pre_case_purpose":"1000492","next_hear_date":"06/05/2024","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"009","text":"0","columns":{"court_code":"10421","case_no":"2024/31","trn_rcms_caseid":"15316000007452","pre_case_purpose_name":"?????","pre_hear_date":"03/05/2024","pre_case_purpose":"1000492","next_hear_date":"28/05/2024","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0010","text":"0","columns":{"court_code":"10421","case_no":"2024/40","trn_rcms_caseid":"15716000007068","pre_case_purpose_name":"?????","pre_hear_date":"03/05/2024","pre_case_purpose":"1000492","next_hear_date":"28/05/2024","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0011","text":"0","columns":{"court_code":"10421","case_no":"2024/6","trn_rcms_caseid":"19620000009052","pre_case_purpose_name":"?????","pre_hear_date":"03/05/2024","pre_case_purpose":"1000492","next_hear_date":"15/05/2024","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0012","text":"0","columns":{"court_code":"10421","case_no":"2017/00401","trn_rcms_caseid":"14049000001289","pre_case_purpose_name":"???","pre_hear_date":"03/05/2024","pre_case_purpose":"18473000000000","next_hear_date":"27/05/2024","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0013","text":"0","columns":{"court_code":"10421","case_no":"2017/00596","trn_rcms_caseid":"10830000001676","pre_case_purpose_name":"???","pre_hear_date":"03/05/2024","pre_case_purpose":"18473000000000","next_hear_date":"15/05/2024","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0014","text":"0","columns":{"court_code":"10421","case_no":"2022/273","trn_rcms_caseid":"12996000007407","pre_case_purpose_name":"???","pre_hear_date":"03/05/2024","pre_case_purpose":"18473000000000","next_hear_date":"13/05/2024","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0015","text":"0","columns":{"court_code":"10421","case_no":"2023/105","trn_rcms_caseid":"13667000007329","pre_case_purpose_name":"???","pre_hear_date":"03/05/2024","pre_case_purpose":"18473000000000","next_hear_date":"17/05/2024","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0016","text":"0","columns":{"court_code":"10421","case_no":"2023/142","trn_rcms_caseid":"13239000007451","pre_case_purpose_name":"???","pre_hear_date":"03/05/2024","pre_case_purpose":"18473000000000","next_hear_date":"14/05/2024","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0017","text":"0","columns":{"court_code":"10421","case_no":"2023/213","trn_rcms_caseid":"10013000007354","pre_case_purpose_name":"???","pre_hear_date":"03/05/2024","pre_case_purpose":"18473000000000","next_hear_date":"08/05/2024","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0018","text":"0","columns":{"court_code":"10421","case_no":"2017/00503","trn_rcms_caseid":"11133000001564","pre_case_purpose_name":"???? ????????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"12555000000002","next_hear_date":"27/05/2024","new_case_purpose":"12555000000002","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0019","text":"0","columns":{"court_code":"10421","case_no":"2023/66","trn_rcms_caseid":"13395000007141","pre_case_purpose_name":"???? ????????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"12555000000002","next_hear_date":"24/05/2024","new_case_purpose":"12555000000002","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0020","text":"0","columns":{"court_code":"10421","case_no":"2024/60","trn_rcms_caseid":"17685000009171","pre_case_purpose_name":"???? ????????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"12555000000002","next_hear_date":"17/05/2024","new_case_purpose":"12555000000002","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0021","text":"0","columns":{"court_code":"10421","case_no":"2010/00002","trn_rcms_caseid":"18511000000699","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"11472000000003","next_hear_date":"17/05/2024","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0022","text":"0","columns":{"court_code":"10421","case_no":"2012/00142","trn_rcms_caseid":"15222000000649","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"11472000000003","next_hear_date":"17/05/2024","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0023","text":"0","columns":{"court_code":"10421","case_no":"2012/00151","trn_rcms_caseid":"13203000000662","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"11472000000003","next_hear_date":"17/05/2024","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0024","text":"0","columns":{"court_code":"10421","case_no":"2015/00104","trn_rcms_caseid":"17082000000384","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"11472000000003","next_hear_date":"20/05/2024","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0025","text":"0","columns":{"court_code":"10421","case_no":"2017/00402","trn_rcms_caseid":"14056000001317","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"11472000000003","next_hear_date":"27/05/2024","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0026","text":"0","columns":{"court_code":"10421","case_no":"2018/00476","trn_rcms_caseid":"17025000002191","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"11472000000003","next_hear_date":"27/05/2024","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0027","text":"0","columns":{"court_code":"10421","case_no":"2022/214","trn_rcms_caseid":"16279000006085","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"11472000000003","next_hear_date":"24/05/2024","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0028","text":"0","columns":{"court_code":"10421","case_no":"2023/141","trn_rcms_caseid":"13204000006855","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"11472000000003","next_hear_date":"24/05/2024","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0029","text":"0","columns":{"court_code":"10421","case_no":"2023/41","trn_rcms_caseid":"19161000006097","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"11472000000003","next_hear_date":"15/05/2024","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0030","text":"0","columns":{"court_code":"10421","case_no":"2024/41","trn_rcms_caseid":"15723000008268","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"11472000000003","next_hear_date":"27/05/2024","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0031","text":"0","columns":{"court_code":"10421","case_no":"2024/42","trn_rcms_caseid":"15741000007793","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"11472000000003","next_hear_date":"27/05/2024","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0032","text":"0","columns":{"court_code":"10421","case_no":"2024/49","trn_rcms_caseid":"11447000008827","pre_case_purpose_name":"???? ????? ????","pre_hear_date":"03/05/2024","pre_case_purpose":"11472000000003","next_hear_date":"20/05/2024","new_case_purpose":"11472000000003","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}}]}]}}
Verifying username and password
User Name : RAA_kota
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=raa_kota
Time elapsed = 14
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 6
Result : 
Verifying completed...
Page Access Category : 
User Name : raa_kota
Select sysdate as sdt from dual
Time elapsed = 4
dt=03/05/2024 16:31:57
Select sysdate as sdt from dual
Time elapsed = 4
Select usergroup from AXUSERLEVELGROUPS WHERE (lower(username) =:U) and ((startdate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') >= startdate) or (startdate is null)) and ((enddate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') <= enddate) or (enddate is null))
U=raa_kota
dt=03/05/2024 16:31:57
dt=03/05/2024 16:31:57
Time elapsed = 12
User Groups: court_reader
select userroles from axusergroups where groupname in ( 'court_reader' )
Time elapsed = 5
User Roles : court_reader
Loading App/User vars
reading the props xml
Step3
Sql : select props from axprops where lower(name)= :name  order by blobno

Paramval : app
ParamTYpe : c
Param List : name

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

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

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

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

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

Time elapsed = 5
Reading data from stream

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

Paramval : trcmf
ParamTYpe : c
Param List : name

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

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

Paramval : tchdh
ParamTYpe : c
Param List : name

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

Time elapsed = 4
Step4
tstructs\stm size:1907
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tchdh
adxinout=o
Time elapsed = 6
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 4
Loading genmaps
Creating Action object
Submitting data to dbcall
Submiting & Registering data 
Registering Global variables data 
Registering Global variables data over
Setting values over
DB Call Validate and save

>>Validating trcmf

>>Frame No 1
courtcode = 10421
hearing_date = 03/05/2024
time zone difference  = 0

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

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

Time elapsed = 3
RecordId = 18556000008599
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
hearing_date = 03/05/2024
courtcode = 10421
Posting record
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:58
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=03/05/2024 00:00:00
Param Type = c
courtcode=10421
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)

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

Time elapsed = 3
RecordId = 18556000008600
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 14/05/2024
new_case_purpose = 10151000000586
isadjourn = NO
adjourn_type = 0
adjourn_remark = 
case_no = 2022/159
court_code = 10421
trn_rcms_caseid = 13872000006017
pre_case_purpose = 10151000000586
pre_hear_date = 03/05/2024
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=18556000008600
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:58
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=14/05/2024 00:00:00
Param Type = c
new_case_purpose=10151000000586
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/159
Param Type = c
court_code=10421
Param Type = c
trn_rcms_caseid=13872000006017
Param Type = n
pre_case_purpose=10151000000586
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=1
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_type,adjourn_remark,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,:adjourn_type,null,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18556000008601
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 21/05/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2014/00103
court_code = 10421
trn_rcms_caseid = 13003000000521
pre_case_purpose = 1000492
pre_hear_date = 03/05/2024
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=18556000008601
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:58
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=21/05/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2014/00103
Param Type = c
court_code=10421
Param Type = c
trn_rcms_caseid=13003000000521
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 18556000008602
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 03/05/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 19051000000475
court_code = 10421
case_no = 2016/00076
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 06/05/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=18556000008602
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:58
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=19051000000475
Param Type = c
court_code=10421
Param Type = c
case_no=2016/00076
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=06/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=3
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 5
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 = 4
RecordId = 18556000008603
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 03/05/2024
pre_case_purpose = 1000492
trn_rcms_caseid = 18947000001766
court_code = 10421
case_no = 2018/00294
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 17/05/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=18556000008603
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:58
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=18947000001766
Param Type = c
court_code=10421
Param Type = c
case_no=2018/00294
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=17/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=4
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18556000008604
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 22/05/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2019/00364
court_code = 10421
trn_rcms_caseid = 11398000003050
pre_case_purpose = 1000492
pre_hear_date = 03/05/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=18556000008604
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:58
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/05/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2019/00364
Param Type = c
court_code=10421
Param Type = c
trn_rcms_caseid=11398000003050
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18556000008605
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 15/05/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2023/165
court_code = 10421
trn_rcms_caseid = 16154000007058
pre_case_purpose = 1000492
pre_hear_date = 03/05/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=18556000008605
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:58
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=15/05/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/165
Param Type = c
court_code=10421
Param Type = c
trn_rcms_caseid=16154000007058
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=6
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 7
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 = 18556000008606
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_type = 0
adjourn_remark = 
pre_case_purpose = 1000492
new_case_purpose = 1000492
next_hear_date = 28/05/2024
isadjourn = NO
trn_rcms_caseid = 11360000007305
pre_hear_date = 03/05/2024
court_code = 10421
case_no = 2024/19
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=18556000008606
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:59
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=28/05/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=11360000007305
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = c
court_code=10421
Param Type = c
case_no=2024/19
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,pre_case_purpose,new_case_purpose,next_hear_date,isadjourn,trn_rcms_caseid,pre_hear_date,court_code,case_no,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 4
RecordId = 18556000008607
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2024/23
court_code = 10421
adjourn_remark = 
new_case_purpose = 18473000000000
next_hear_date = 06/05/2024
isadjourn = NO
adjourn_type = 0
trn_rcms_caseid = 17075000007324
pre_hear_date = 03/05/2024
pre_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=18556000008607
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:59
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2024/23
Param Type = c
court_code=10421
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=06/05/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=17075000007324
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,court_code,adjourn_remark,new_case_purpose,next_hear_date,isadjourn,adjourn_type,trn_rcms_caseid,pre_hear_date,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:court_code,null,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 3
RecordId = 18556000008608
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
new_case_purpose = 1000492
pre_case_purpose = 1000492
isadjourn = NO
next_hear_date = 28/05/2024
pre_hear_date = 03/05/2024
court_code = 10421
adjourn_type = 0
trn_rcms_caseid = 15316000007452
case_no = 2024/31
adjourn_remark = 
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=18556000008608
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:59
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=28/05/2024 00:00:00
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = c
court_code=10421
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=15316000007452
Param Type = c
case_no=2024/31
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,pre_case_purpose,isadjourn,next_hear_date,pre_hear_date,court_code,adjourn_type,trn_rcms_caseid,case_no,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,:pre_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:adjourn_type,:trn_rcms_caseid,:case_no,null,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 18556000008609
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trn_rcms_caseid = 15716000007068
adjourn_remark = 
court_code = 10421
case_no = 2024/40
next_hear_date = 28/05/2024
isadjourn = NO
new_case_purpose = 1000492
pre_case_purpose = 1000492
pre_hear_date = 03/05/2024
adjourn_type = 0
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=18556000008609
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:59
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=15716000007068
Param Type = c
court_code=10421
Param Type = c
case_no=2024/40
Param Type = c
next_hear_date=28/05/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,adjourn_remark,court_code,case_no,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,null,:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:adjourn_type,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 18556000008610
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2024/6
new_case_purpose = 11472000000003
pre_case_purpose = 1000492
trn_rcms_caseid = 19620000009052
pre_hear_date = 03/05/2024
adjourn_remark = 
court_code = 10421
adjourn_type = 0
next_hear_date = 15/05/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=18556000008610
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:59
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2024/6
Param Type = c
new_case_purpose=11472000000003
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=19620000009052
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = c
court_code=10421
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=15/05/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18556000008611
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 03/05/2024
pre_case_purpose = 18473000000000
trn_rcms_caseid = 14049000001289
court_code = 10421
case_no = 2017/00401
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 27/05/2024
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=18556000008611
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:59
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=14049000001289
Param Type = c
court_code=10421
Param Type = c
case_no=2017/00401
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=27/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 5
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 = 3
RecordId = 18556000008612
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 03/05/2024
pre_case_purpose = 18473000000000
trn_rcms_caseid = 10830000001676
court_code = 10421
case_no = 2017/00596
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 15/05/2024
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=18556000008612
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:59
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
trn_rcms_caseid=10830000001676
Param Type = c
court_code=10421
Param Type = c
case_no=2017/00596
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=15/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 18556000008613
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 13/05/2024
new_case_purpose = 18473000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2022/273
court_code = 10421
trn_rcms_caseid = 12996000007407
pre_case_purpose = 18473000000000
pre_hear_date = 03/05/2024
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=18556000008613
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:59
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=13/05/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2022/273
Param Type = c
court_code=10421
Param Type = c
trn_rcms_caseid=12996000007407
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=14
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18556000008614
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 17/05/2024
new_case_purpose = 1000492
adjourn_remark = 
isadjourn = NO
adjourn_type = 0
case_no = 2023/105
court_code = 10421
trn_rcms_caseid = 13667000007329
pre_case_purpose = 18473000000000
pre_hear_date = 03/05/2024
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=18556000008614
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:59
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=17/05/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/105
Param Type = c
court_code=10421
Param Type = c
trn_rcms_caseid=13667000007329
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_remark,isadjourn,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,null,:isadjourn,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 18556000008615
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 03/05/2024
trn_rcms_caseid = 13239000007451
isadjourn = NO
pre_case_purpose = 18473000000000
adjourn_type = 0
court_code = 10421
case_no = 2023/142
adjourn_remark = 
next_hear_date = 14/05/2024
new_case_purpose = 18473000000000
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=18556000008615
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:59
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = c
trn_rcms_caseid=13239000007451
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
adjourn_type=0
Param Type = c
court_code=10421
Param Type = c
case_no=2023/142
Param Type = c
next_hear_date=14/05/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,isadjourn,pre_case_purpose,adjourn_type,court_code,case_no,adjourn_remark,next_hear_date,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:isadjourn,:pre_case_purpose,:adjourn_type,:court_code,:case_no,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 3
RecordId = 18556000008616
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
court_code = 10421
adjourn_type = 0
isadjourn = NO
new_case_purpose = 18473000000000
next_hear_date = 08/05/2024
trn_rcms_caseid = 10013000007354
pre_case_purpose = 18473000000000
case_no = 2023/213
pre_hear_date = 03/05/2024
adjourn_remark = 
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=18556000008616
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:59
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10421
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18473000000000
Param Type = c
next_hear_date=08/05/2024 00:00:00
Param Type = c
trn_rcms_caseid=10013000007354
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
case_no=2023/213
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,adjourn_type,isadjourn,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_case_purpose,case_no,pre_hear_date,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:adjourn_type,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:pre_case_purpose,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 5
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 = 18556000008617
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 03/05/2024
pre_case_purpose = 12555000000002
trn_rcms_caseid = 11133000001564
court_code = 10421
case_no = 2017/00503
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 12555000000002
next_hear_date = 27/05/2024
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=18556000008617
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:31:59
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:31:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
trn_rcms_caseid=11133000001564
Param Type = c
court_code=10421
Param Type = c
case_no=2017/00503
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=12555000000002
Param Type = c
next_hear_date=27/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=18
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 7
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 = 6
RecordId = 18556000008618
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 24/05/2024
new_case_purpose = 12555000000002
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2023/66
court_code = 10421
trn_rcms_caseid = 13395000007141
pre_case_purpose = 12555000000002
pre_hear_date = 03/05/2024
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=18556000008618
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:00
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=24/05/2024 00:00:00
Param Type = c
new_case_purpose=12555000000002
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/66
Param Type = c
court_code=10421
Param Type = c
trn_rcms_caseid=13395000007141
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=19
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 18556000008619
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
new_case_purpose = 12555000000002
next_hear_date = 17/05/2024
trn_rcms_caseid = 17685000009171
pre_hear_date = 03/05/2024
pre_case_purpose = 12555000000002
case_no = 2024/60
court_code = 10421
adjourn_remark = 
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=18556000008619
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:00
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=12555000000002
Param Type = c
next_hear_date=17/05/2024 00:00:00
Param Type = c
trn_rcms_caseid=17685000009171
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
pre_case_purpose=12555000000002
Param Type = c
case_no=2024/60
Param Type = c
court_code=10421
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,court_code,adjourn_remark,isadjourn,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,null,:isadjourn,:adjourn_type,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 11
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 = 5
RecordId = 18556000008620
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 03/05/2024
pre_case_purpose = 11472000000003
trn_rcms_caseid = 18511000000699
court_code = 10421
case_no = 2010/00002
isadjourn = NO
adjourn_type = 0
next_hear_date = 17/05/2024
adjourn_remark = 
new_case_purpose = 11472000000003
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=18556000008620
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:00
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
pre_case_purpose=11472000000003
Param Type = c
trn_rcms_caseid=18511000000699
Param Type = c
court_code=10421
Param Type = c
case_no=2010/00002
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=17/05/2024 00:00:00
Param Type = c
new_case_purpose=11472000000003
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_type,next_hear_date,adjourn_remark,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:new_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 18556000008621
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_case_purpose = 11472000000003
court_code = 10421
pre_hear_date = 03/05/2024
case_no = 2012/00142
trn_rcms_caseid = 15222000000649
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 11472000000003
next_hear_date = 17/05/2024
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=18556000008621
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:00
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=11472000000003
Param Type = c
court_code=10421
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = c
case_no=2012/00142
Param Type = c
trn_rcms_caseid=15222000000649
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=11472000000003
Param Type = c
next_hear_date=17/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_case_purpose,court_code,pre_hear_date,case_no,trn_rcms_caseid,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:pre_case_purpose,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseid,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18556000008622
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark = 
new_case_purpose = 11472000000003
adjourn_type = 0
isadjourn = NO
next_hear_date = 17/05/2024
pre_case_purpose = 11472000000003
case_no = 2012/00151
court_code = 10421
pre_hear_date = 03/05/2024
trn_rcms_caseid = 13203000000662
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=18556000008622
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:00
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=11472000000003
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=17/05/2024 00:00:00
Param Type = n
pre_case_purpose=11472000000003
Param Type = c
case_no=2012/00151
Param Type = c
court_code=10421
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = c
trn_rcms_caseid=13203000000662
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,new_case_purpose,adjourn_type,isadjourn,next_hear_date,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:new_case_purpose,:adjourn_type,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 18556000008623
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark = 
trn_rcms_caseid = 17082000000384
pre_hear_date = 03/05/2024
court_code = 10421
case_no = 2015/00104
pre_case_purpose = 11472000000003
isadjourn = NO
adjourn_type = 0
new_case_purpose = 11472000000003
next_hear_date = 20/05/2024
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=18556000008623
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:00
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=17082000000384
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = c
court_code=10421
Param Type = c
case_no=2015/00104
Param Type = n
pre_case_purpose=11472000000003
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=11472000000003
Param Type = c
next_hear_date=20/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18556000008624
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 14056000001317
case_no = 2017/00402
pre_hear_date = 03/05/2024
next_hear_date = 27/05/2024
new_case_purpose = 11472000000003
isadjourn = NO
court_code = 10421
pre_case_purpose = 11472000000003
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=18556000008624
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:00
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=14056000001317
Param Type = c
case_no=2017/00402
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = c
next_hear_date=27/05/2024 00:00:00
Param Type = c
new_case_purpose=11472000000003
Param Type = c
isadjourn=NO
Param Type = c
court_code=10421
Param Type = n
pre_case_purpose=11472000000003
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,case_no,pre_hear_date,next_hear_date,new_case_purpose,isadjourn,court_code,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 3
RecordId = 18556000008625
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 17025000002191
pre_hear_date = 03/05/2024
court_code = 10421
case_no = 2018/00476
next_hear_date = 27/05/2024
isadjourn = NO
pre_case_purpose = 11472000000003
new_case_purpose = 11472000000003
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=18556000008625
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:00
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=17025000002191
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = c
court_code=10421
Param Type = c
case_no=2018/00476
Param Type = c
next_hear_date=27/05/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=11472000000003
Param Type = c
new_case_purpose=11472000000003
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 5
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 = 3
RecordId = 18556000008626
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
trn_rcms_caseid = 16279000006085
pre_hear_date = 03/05/2024
pre_case_purpose = 11472000000003
case_no = 2022/214
next_hear_date = 24/05/2024
new_case_purpose = 11472000000003
court_code = 10421
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=18556000008626
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:00
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:00
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=16279000006085
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
pre_case_purpose=11472000000003
Param Type = c
case_no=2022/214
Param Type = c
next_hear_date=24/05/2024 00:00:00
Param Type = c
new_case_purpose=11472000000003
Param Type = c
court_code=10421
Param Type = n
trn_rcms_hearingrow=27
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,next_hear_date,new_case_purpose,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:court_code,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 3
RecordId = 18556000008627
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
isadjourn = NO
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 13204000006855
case_no = 2023/141
court_code = 10421
pre_hear_date = 03/05/2024
next_hear_date = 24/05/2024
new_case_purpose = 11472000000003
pre_case_purpose = 11472000000003
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=18556000008627
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:00
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13204000006855
Param Type = c
case_no=2023/141
Param Type = c
court_code=10421
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = c
next_hear_date=24/05/2024 00:00:00
Param Type = c
new_case_purpose=11472000000003
Param Type = n
pre_case_purpose=11472000000003
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18556000008628
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
next_hear_date = 15/05/2024
case_no = 2023/41
court_code = 10421
trn_rcms_caseid = 19161000006097
new_case_purpose = 18473000000000
pre_case_purpose = 11472000000003
pre_hear_date = 03/05/2024
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=18556000008628
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:00
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:00
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=15/05/2024 00:00:00
Param Type = c
case_no=2023/41
Param Type = c
court_code=10421
Param Type = c
trn_rcms_caseid=19161000006097
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=11472000000003
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=29
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_remark,adjourn_type,next_hear_date,case_no,court_code,trn_rcms_caseid,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18556000008629
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 27/05/2024
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 15723000008268
case_no = 2024/41
court_code = 10421
new_case_purpose = 11472000000003
pre_case_purpose = 11472000000003
pre_hear_date = 03/05/2024
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=18556000008629
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:00
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=27/05/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=15723000008268
Param Type = c
case_no=2024/41
Param Type = c
court_code=10421
Param Type = c
new_case_purpose=11472000000003
Param Type = n
pre_case_purpose=11472000000003
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=30
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 4
RecordId = 18556000008630
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 27/05/2024
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 11472000000003
case_no = 2024/42
court_code = 10421
trn_rcms_caseid = 15741000007793
pre_case_purpose = 11472000000003
pre_hear_date = 03/05/2024
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=18556000008630
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:01
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=27/05/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=11472000000003
Param Type = c
case_no=2024/42
Param Type = c
court_code=10421
Param Type = c
trn_rcms_caseid=15741000007793
Param Type = n
pre_case_purpose=11472000000003
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=31
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 18556000008631
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 20/05/2024
new_case_purpose = 11472000000003
adjourn_remark = 
adjourn_type = 0
isadjourn = NO
case_no = 2024/49
court_code = 10421
trn_rcms_caseid = 11447000008827
pre_case_purpose = 11472000000003
pre_hear_date = 03/05/2024
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=18556000008631
Param Type = n
trn_rcms_mhearingid=18556000008599
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:01
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:01
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=20/05/2024 00:00:00
Param Type = c
new_case_purpose=11472000000003
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/49
Param Type = c
court_code=10421
Param Type = c
trn_rcms_caseid=11447000008827
Param Type = n
pre_case_purpose=11472000000003
Param Type = c
pre_hear_date=03/05/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=32
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_remark,adjourn_type,isadjourn,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,null,:adjourn_type,:isadjourn,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

Time elapsed for insert/update = 3923915507434

>>Executing genmaps

>>Posting from trcmf to tchdh from row 1

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13872000006017 idvalue 0
Mapped case_no Row = 1 value = 2022/159 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 10151000000586 idvalue 0
Mapped hearing_date Row = 1 value = 14/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 13872000006017
case_no = 2022/159
prev_hearing_date = 03/05/2024
hearing_date = 14/05/2024
prev_case_purposename = ??? ????????? ???? ?????????
prev_case_purpose = 
prev_case_purposename=??? ????????? ???? ?????????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 2
RecordId = 18556000008632
MapName trcmf1
SourceId 18556000008600
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 10151000000586
hearing_date = 14/05/2024
case_no = 2022/159
trn_rcms_caseregid = 13872000006017
court_code = 10421
case_purpose = 10151000000586
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008632
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008600
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:01
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=10151000000586
Param Type = c
hearing_date=14/05/2024 00:00:00
Param Type = c
case_no=2022/159
Param Type = c
trn_rcms_caseregid=13872000006017
Param Type = c
court_code=10421
Param Type = c
case_purpose=10151000000586
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 2

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13003000000521 idvalue 0
Mapped case_no Row = 1 value = 2014/00103 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 21/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 13003000000521
case_no = 2014/00103
prev_hearing_date = 03/05/2024
hearing_date = 21/05/2024
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purposename=?????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 4
RecordId = 18556000008633
MapName trcmf1
SourceId 18556000008601
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 21/05/2024
case_no = 2014/00103
trn_rcms_caseregid = 13003000000521
court_code = 10421
case_purpose = 1000492
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008633
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008601
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:01
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=1000492
Param Type = c
hearing_date=21/05/2024 00:00:00
Param Type = c
case_no=2014/00103
Param Type = c
trn_rcms_caseregid=13003000000521
Param Type = c
court_code=10421
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 3

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19051000000475 idvalue 0
Mapped case_no Row = 1 value = 2016/00076 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 06/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 19051000000475
case_no = 2016/00076
prev_hearing_date = 03/05/2024
hearing_date = 06/05/2024
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18556000008634
MapName trcmf1
SourceId 18556000008602
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 06/05/2024
case_no = 2016/00076
trn_rcms_caseregid = 19051000000475
court_code = 10421
case_purpose = 1000492
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008634
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008602
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:01
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=1000492
Param Type = c
hearing_date=06/05/2024 00:00:00
Param Type = c
case_no=2016/00076
Param Type = c
trn_rcms_caseregid=19051000000475
Param Type = c
court_code=10421
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 4

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18947000001766 idvalue 0
Mapped case_no Row = 1 value = 2018/00294 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 18947000001766
case_no = 2018/00294
prev_hearing_date = 03/05/2024
hearing_date = 17/05/2024
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 2
RecordId = 18556000008635
MapName trcmf1
SourceId 18556000008603
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 17/05/2024
case_no = 2018/00294
trn_rcms_caseregid = 18947000001766
court_code = 10421
case_purpose = 1000492
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008635
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008603
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:01
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=1000492
Param Type = c
hearing_date=17/05/2024 00:00:00
Param Type = c
case_no=2018/00294
Param Type = c
trn_rcms_caseregid=18947000001766
Param Type = c
court_code=10421
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 5

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11398000003050 idvalue 0
Mapped case_no Row = 1 value = 2019/00364 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 22/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 11398000003050
case_no = 2019/00364
prev_hearing_date = 03/05/2024
hearing_date = 22/05/2024
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 18556000008636
MapName trcmf1
SourceId 18556000008604
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 22/05/2024
case_no = 2019/00364
trn_rcms_caseregid = 11398000003050
court_code = 10421
case_purpose = 1000492
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008636
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008604
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:01
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=1000492
Param Type = c
hearing_date=22/05/2024 00:00:00
Param Type = c
case_no=2019/00364
Param Type = c
trn_rcms_caseregid=11398000003050
Param Type = c
court_code=10421
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 6

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16154000007058 idvalue 0
Mapped case_no Row = 1 value = 2023/165 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 15/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 16154000007058
case_no = 2023/165
prev_hearing_date = 03/05/2024
hearing_date = 15/05/2024
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 18556000008637
MapName trcmf1
SourceId 18556000008605
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 = 1000492
hearing_date = 15/05/2024
case_no = 2023/165
trn_rcms_caseregid = 16154000007058
court_code = 10421
case_purpose = 1000492
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008637
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008605
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:01
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=1000492
Param Type = c
hearing_date=15/05/2024 00:00:00
Param Type = c
case_no=2023/165
Param Type = c
trn_rcms_caseregid=16154000007058
Param Type = c
court_code=10421
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 7

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11360000007305 idvalue 0
Mapped case_no Row = 1 value = 2024/19 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 11360000007305
case_no = 2024/19
prev_hearing_date = 03/05/2024
hearing_date = 28/05/2024
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18556000008638
MapName trcmf1
SourceId 18556000008606
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/05/2024
case_no = 2024/19
trn_rcms_caseregid = 11360000007305
court_code = 10421
case_purpose = 1000492
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008638
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008606
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:01
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=1000492
Param Type = c
hearing_date=28/05/2024 00:00:00
Param Type = c
case_no=2024/19
Param Type = c
trn_rcms_caseregid=11360000007305
Param Type = c
court_code=10421
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 8

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17075000007324 idvalue 0
Mapped case_no Row = 1 value = 2024/23 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 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 = 06/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 17075000007324
case_no = 2024/23
prev_hearing_date = 03/05/2024
hearing_date = 06/05/2024
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 18556000008639
MapName trcmf1
SourceId 18556000008607
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 = 1000492
hearing_date = 06/05/2024
case_no = 2024/23
trn_rcms_caseregid = 17075000007324
court_code = 10421
case_purpose = 18473000000000
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008639
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008607
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:02
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=06/05/2024 00:00:00
Param Type = c
case_no=2024/23
Param Type = c
trn_rcms_caseregid=17075000007324
Param Type = c
court_code=10421
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 9

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15316000007452 idvalue 0
Mapped case_no Row = 1 value = 2024/31 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 15316000007452
case_no = 2024/31
prev_hearing_date = 03/05/2024
hearing_date = 28/05/2024
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
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 = 4
RecordId = 18556000008640
MapName trcmf1
SourceId 18556000008608
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/05/2024
case_no = 2024/31
trn_rcms_caseregid = 15316000007452
court_code = 10421
case_purpose = 1000492
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008640
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008608
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:02
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/05/2024 00:00:00
Param Type = c
case_no=2024/31
Param Type = c
trn_rcms_caseregid=15316000007452
Param Type = c
court_code=10421
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 10

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15716000007068 idvalue 0
Mapped case_no Row = 1 value = 2024/40 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 28/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 15716000007068
case_no = 2024/40
prev_hearing_date = 03/05/2024
hearing_date = 28/05/2024
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 18556000008641
MapName trcmf1
SourceId 18556000008609
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 28/05/2024
case_no = 2024/40
trn_rcms_caseregid = 15716000007068
court_code = 10421
case_purpose = 1000492
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008641
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008609
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:02
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=28/05/2024 00:00:00
Param Type = c
case_no=2024/40
Param Type = c
trn_rcms_caseregid=15716000007068
Param Type = c
court_code=10421
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 11

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19620000009052 idvalue 0
Mapped case_no Row = 1 value = 2024/6 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ????? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 15/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 19620000009052
case_no = 2024/6
prev_hearing_date = 03/05/2024
hearing_date = 15/05/2024
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 11472000000003
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18556000008642
MapName trcmf1
SourceId 18556000008610
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 = 1000492
hearing_date = 15/05/2024
case_no = 2024/6
trn_rcms_caseregid = 19620000009052
court_code = 10421
case_purpose = 11472000000003
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008642
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008610
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:02
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=15/05/2024 00:00:00
Param Type = c
case_no=2024/6
Param Type = c
trn_rcms_caseregid=19620000009052
Param Type = c
court_code=10421
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 12

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14049000001289 idvalue 0
Mapped case_no Row = 1 value = 2017/00401 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 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 = 27/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 14049000001289
case_no = 2017/00401
prev_hearing_date = 03/05/2024
hearing_date = 27/05/2024
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purposename=???
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 4
RecordId = 18556000008643
MapName trcmf1
SourceId 18556000008611
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 27/05/2024
case_no = 2017/00401
trn_rcms_caseregid = 14049000001289
court_code = 10421
case_purpose = 18473000000000
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008643
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008611
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:02
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=27/05/2024 00:00:00
Param Type = c
case_no=2017/00401
Param Type = c
trn_rcms_caseregid=14049000001289
Param Type = c
court_code=10421
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 13

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10830000001676 idvalue 0
Mapped case_no Row = 1 value = 2017/00596 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 10830000001676
case_no = 2017/00596
prev_hearing_date = 03/05/2024
hearing_date = 15/05/2024
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 = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 18556000008644
MapName trcmf1
SourceId 18556000008612
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 = 15/05/2024
case_no = 2017/00596
trn_rcms_caseregid = 10830000001676
court_code = 10421
case_purpose = 18473000000000
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008644
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008612
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:02
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=15/05/2024 00:00:00
Param Type = c
case_no=2017/00596
Param Type = c
trn_rcms_caseregid=10830000001676
Param Type = c
court_code=10421
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 14

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12996000007407 idvalue 0
Mapped case_no Row = 1 value = 2022/273 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 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 = 13/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 12996000007407
case_no = 2022/273
prev_hearing_date = 03/05/2024
hearing_date = 13/05/2024
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 = 5
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 18556000008645
MapName trcmf1
SourceId 18556000008613
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 = 13/05/2024
case_no = 2022/273
trn_rcms_caseregid = 12996000007407
court_code = 10421
case_purpose = 18473000000000
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008645
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008613
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:02
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=13/05/2024 00:00:00
Param Type = c
case_no=2022/273
Param Type = c
trn_rcms_caseregid=12996000007407
Param Type = c
court_code=10421
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 15

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13667000007329 idvalue 0
Mapped case_no Row = 1 value = 2023/105 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 1000492 idvalue 0
Mapped hearing_date Row = 1 value = 17/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 13667000007329
case_no = 2023/105
prev_hearing_date = 03/05/2024
hearing_date = 17/05/2024
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18556000008646
MapName trcmf1
SourceId 18556000008614
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 17/05/2024
case_no = 2023/105
trn_rcms_caseregid = 13667000007329
court_code = 10421
case_purpose = 1000492
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008646
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008614
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:02
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32:02
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=17/05/2024 00:00:00
Param Type = c
case_no=2023/105
Param Type = c
trn_rcms_caseregid=13667000007329
Param Type = c
court_code=10421
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 16

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13239000007451 idvalue 0
Mapped case_no Row = 1 value = 2023/142 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 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 = 14/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 13239000007451
case_no = 2023/142
prev_hearing_date = 03/05/2024
hearing_date = 14/05/2024
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18556000008647
MapName trcmf1
SourceId 18556000008615
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 14/05/2024
case_no = 2023/142
trn_rcms_caseregid = 13239000007451
court_code = 10421
case_purpose = 18473000000000
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008647
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008615
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:03
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=18473000000000
Param Type = c
hearing_date=14/05/2024 00:00:00
Param Type = c
case_no=2023/142
Param Type = c
trn_rcms_caseregid=13239000007451
Param Type = c
court_code=10421
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 17

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10013000007354 idvalue 0
Mapped case_no Row = 1 value = 2023/213 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 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/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 10013000007354
case_no = 2023/213
prev_hearing_date = 03/05/2024
hearing_date = 08/05/2024
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 = 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 = 18556000008648
MapName trcmf1
SourceId 18556000008616
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 08/05/2024
case_no = 2023/213
trn_rcms_caseregid = 10013000007354
court_code = 10421
case_purpose = 18473000000000
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008648
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008616
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:03
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=18473000000000
Param Type = c
hearing_date=08/05/2024 00:00:00
Param Type = c
case_no=2023/213
Param Type = c
trn_rcms_caseregid=10013000007354
Param Type = c
court_code=10421
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 18

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11133000001564 idvalue 0
Mapped case_no Row = 1 value = 2017/00503 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 27/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 11133000001564
case_no = 2017/00503
prev_hearing_date = 03/05/2024
hearing_date = 27/05/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose = 
prev_case_purposename=???? ????????? ????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 3
RecordId = 18556000008649
MapName trcmf1
SourceId 18556000008617
Select sysdate as sdt from dual
Time elapsed = 3
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 = 12555000000002
hearing_date = 27/05/2024
case_no = 2017/00503
trn_rcms_caseregid = 11133000001564
court_code = 10421
case_purpose = 12555000000002
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008649
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008617
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:03
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=12555000000002
Param Type = c
hearing_date=27/05/2024 00:00:00
Param Type = c
case_no=2017/00503
Param Type = c
trn_rcms_caseregid=11133000001564
Param Type = c
court_code=10421
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 19

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13395000007141 idvalue 0
Mapped case_no Row = 1 value = 2023/66 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 24/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 13395000007141
case_no = 2023/66
prev_hearing_date = 03/05/2024
hearing_date = 24/05/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose = 
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 18556000008650
MapName trcmf1
SourceId 18556000008618
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 12555000000002
hearing_date = 24/05/2024
case_no = 2023/66
trn_rcms_caseregid = 13395000007141
court_code = 10421
case_purpose = 12555000000002
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008650
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008618
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:03
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=12555000000002
Param Type = c
hearing_date=24/05/2024 00:00:00
Param Type = c
case_no=2023/66
Param Type = c
trn_rcms_caseregid=13395000007141
Param Type = c
court_code=10421
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 20

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17685000009171 idvalue 0
Mapped case_no Row = 1 value = 2024/60 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 12555000000002 idvalue 0
Mapped hearing_date Row = 1 value = 17/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 17685000009171
case_no = 2024/60
prev_hearing_date = 03/05/2024
hearing_date = 17/05/2024
prev_case_purposename = ???? ????????? ????
prev_case_purpose = 
prev_case_purpose after validation = 12555000000002
case_purpose = 12555000000002
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 18556000008651
MapName trcmf1
SourceId 18556000008619
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 = 12555000000002
hearing_date = 17/05/2024
case_no = 2024/60
trn_rcms_caseregid = 17685000009171
court_code = 10421
case_purpose = 12555000000002
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008651
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008619
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:03
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=12555000000002
Param Type = c
hearing_date=17/05/2024 00:00:00
Param Type = c
case_no=2024/60
Param Type = c
trn_rcms_caseregid=17685000009171
Param Type = c
court_code=10421
Param Type = c
case_purpose=12555000000002
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 21

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18511000000699 idvalue 0
Mapped case_no Row = 1 value = 2010/00002 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 17/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 18511000000699
case_no = 2010/00002
prev_hearing_date = 03/05/2024
hearing_date = 17/05/2024
prev_case_purposename = ???? ????? ????
prev_case_purpose = 
prev_case_purposename=???? ????? ????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 3
RecordId = 18556000008652
MapName trcmf1
SourceId 18556000008620
Select sysdate as sdt from dual
Time elapsed = 3
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 = 11472000000003
hearing_date = 17/05/2024
case_no = 2010/00002
trn_rcms_caseregid = 18511000000699
court_code = 10421
case_purpose = 11472000000003
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008652
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008620
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:03
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=11472000000003
Param Type = c
hearing_date=17/05/2024 00:00:00
Param Type = c
case_no=2010/00002
Param Type = c
trn_rcms_caseregid=18511000000699
Param Type = c
court_code=10421
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 22

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15222000000649 idvalue 0
Mapped case_no Row = 1 value = 2012/00142 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 17/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 15222000000649
case_no = 2012/00142
prev_hearing_date = 03/05/2024
hearing_date = 17/05/2024
prev_case_purposename = ???? ????? ????
prev_case_purpose = 
prev_case_purpose after validation = 11472000000003
case_purpose = 11472000000003
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18556000008653
MapName trcmf1
SourceId 18556000008621
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11472000000003
hearing_date = 17/05/2024
case_no = 2012/00142
trn_rcms_caseregid = 15222000000649
court_code = 10421
case_purpose = 11472000000003
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008653
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008621
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:03
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=11472000000003
Param Type = c
hearing_date=17/05/2024 00:00:00
Param Type = c
case_no=2012/00142
Param Type = c
trn_rcms_caseregid=15222000000649
Param Type = c
court_code=10421
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 23

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13203000000662 idvalue 0
Mapped case_no Row = 1 value = 2012/00151 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 17/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 13203000000662
case_no = 2012/00151
prev_hearing_date = 03/05/2024
hearing_date = 17/05/2024
prev_case_purposename = ???? ????? ????
prev_case_purpose = 
prev_case_purpose after validation = 11472000000003
case_purpose = 11472000000003
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 2
RecordId = 18556000008654
MapName trcmf1
SourceId 18556000008622
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11472000000003
hearing_date = 17/05/2024
case_no = 2012/00151
trn_rcms_caseregid = 13203000000662
court_code = 10421
case_purpose = 11472000000003
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008654
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008622
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:03
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=11472000000003
Param Type = c
hearing_date=17/05/2024 00:00:00
Param Type = c
case_no=2012/00151
Param Type = c
trn_rcms_caseregid=13203000000662
Param Type = c
court_code=10421
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 24

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17082000000384 idvalue 0
Mapped case_no Row = 1 value = 2015/00104 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 20/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 17082000000384
case_no = 2015/00104
prev_hearing_date = 03/05/2024
hearing_date = 20/05/2024
prev_case_purposename = ???? ????? ????
prev_case_purpose = 
prev_case_purpose after validation = 11472000000003
case_purpose = 11472000000003
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18556000008655
MapName trcmf1
SourceId 18556000008623
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11472000000003
hearing_date = 20/05/2024
case_no = 2015/00104
trn_rcms_caseregid = 17082000000384
court_code = 10421
case_purpose = 11472000000003
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008655
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008623
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:04
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=11472000000003
Param Type = c
hearing_date=20/05/2024 00:00:00
Param Type = c
case_no=2015/00104
Param Type = c
trn_rcms_caseregid=17082000000384
Param Type = c
court_code=10421
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 25

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14056000001317 idvalue 0
Mapped case_no Row = 1 value = 2017/00402 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 27/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 14056000001317
case_no = 2017/00402
prev_hearing_date = 03/05/2024
hearing_date = 27/05/2024
prev_case_purposename = ???? ????? ????
prev_case_purpose = 
prev_case_purpose after validation = 11472000000003
case_purpose = 11472000000003
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18556000008656
MapName trcmf1
SourceId 18556000008624
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11472000000003
hearing_date = 27/05/2024
case_no = 2017/00402
trn_rcms_caseregid = 14056000001317
court_code = 10421
case_purpose = 11472000000003
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008656
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008624
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:04
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=11472000000003
Param Type = c
hearing_date=27/05/2024 00:00:00
Param Type = c
case_no=2017/00402
Param Type = c
trn_rcms_caseregid=14056000001317
Param Type = c
court_code=10421
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 26

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17025000002191 idvalue 0
Mapped case_no Row = 1 value = 2018/00476 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 27/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 17025000002191
case_no = 2018/00476
prev_hearing_date = 03/05/2024
hearing_date = 27/05/2024
prev_case_purposename = ???? ????? ????
prev_case_purpose = 
prev_case_purpose after validation = 11472000000003
case_purpose = 11472000000003
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 2
RecordId = 18556000008657
MapName trcmf1
SourceId 18556000008625
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11472000000003
hearing_date = 27/05/2024
case_no = 2018/00476
trn_rcms_caseregid = 17025000002191
court_code = 10421
case_purpose = 11472000000003
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008657
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008625
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:04
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=11472000000003
Param Type = c
hearing_date=27/05/2024 00:00:00
Param Type = c
case_no=2018/00476
Param Type = c
trn_rcms_caseregid=17025000002191
Param Type = c
court_code=10421
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 27

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16279000006085 idvalue 0
Mapped case_no Row = 1 value = 2022/214 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 24/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 16279000006085
case_no = 2022/214
prev_hearing_date = 03/05/2024
hearing_date = 24/05/2024
prev_case_purposename = ???? ????? ????
prev_case_purpose = 
prev_case_purpose after validation = 11472000000003
case_purpose = 11472000000003
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18556000008658
MapName trcmf1
SourceId 18556000008626
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11472000000003
hearing_date = 24/05/2024
case_no = 2022/214
trn_rcms_caseregid = 16279000006085
court_code = 10421
case_purpose = 11472000000003
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008658
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008626
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:04
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=11472000000003
Param Type = c
hearing_date=24/05/2024 00:00:00
Param Type = c
case_no=2022/214
Param Type = c
trn_rcms_caseregid=16279000006085
Param Type = c
court_code=10421
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 28

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13204000006855 idvalue 0
Mapped case_no Row = 1 value = 2023/141 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 24/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 13204000006855
case_no = 2023/141
prev_hearing_date = 03/05/2024
hearing_date = 24/05/2024
prev_case_purposename = ???? ????? ????
prev_case_purpose = 
prev_case_purpose after validation = 11472000000003
case_purpose = 11472000000003
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 18556000008659
MapName trcmf1
SourceId 18556000008627
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11472000000003
hearing_date = 24/05/2024
case_no = 2023/141
trn_rcms_caseregid = 13204000006855
court_code = 10421
case_purpose = 11472000000003
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008659
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008627
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:04
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=11472000000003
Param Type = c
hearing_date=24/05/2024 00:00:00
Param Type = c
case_no=2023/141
Param Type = c
trn_rcms_caseregid=13204000006855
Param Type = c
court_code=10421
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 29

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19161000006097 idvalue 0
Mapped case_no Row = 1 value = 2023/41 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 15/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 19161000006097
case_no = 2023/41
prev_hearing_date = 03/05/2024
hearing_date = 15/05/2024
prev_case_purposename = ???? ????? ????
prev_case_purpose = 
prev_case_purpose after validation = 11472000000003
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 18556000008660
MapName trcmf1
SourceId 18556000008628
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11472000000003
hearing_date = 15/05/2024
case_no = 2023/41
trn_rcms_caseregid = 19161000006097
court_code = 10421
case_purpose = 18473000000000
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008660
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008628
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:04
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=11472000000003
Param Type = c
hearing_date=15/05/2024 00:00:00
Param Type = c
case_no=2023/41
Param Type = c
trn_rcms_caseregid=19161000006097
Param Type = c
court_code=10421
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 30

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15723000008268 idvalue 0
Mapped case_no Row = 1 value = 2024/41 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 27/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 15723000008268
case_no = 2024/41
prev_hearing_date = 03/05/2024
hearing_date = 27/05/2024
prev_case_purposename = ???? ????? ????
prev_case_purpose = 
prev_case_purpose after validation = 11472000000003
case_purpose = 11472000000003
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 18556000008661
MapName trcmf1
SourceId 18556000008629
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11472000000003
hearing_date = 27/05/2024
case_no = 2024/41
trn_rcms_caseregid = 15723000008268
court_code = 10421
case_purpose = 11472000000003
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008661
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008629
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:04
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=11472000000003
Param Type = c
hearing_date=27/05/2024 00:00:00
Param Type = c
case_no=2024/41
Param Type = c
trn_rcms_caseregid=15723000008268
Param Type = c
court_code=10421
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 31

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15741000007793 idvalue 0
Mapped case_no Row = 1 value = 2024/42 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 27/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 15741000007793
case_no = 2024/42
prev_hearing_date = 03/05/2024
hearing_date = 27/05/2024
prev_case_purposename = ???? ????? ????
prev_case_purpose = 
prev_case_purpose after validation = 11472000000003
case_purpose = 11472000000003
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 18556000008662
MapName trcmf1
SourceId 18556000008630
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11472000000003
hearing_date = 27/05/2024
case_no = 2024/42
trn_rcms_caseregid = 15741000007793
court_code = 10421
case_purpose = 11472000000003
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008662
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008630
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:04
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=11472000000003
Param Type = c
hearing_date=27/05/2024 00:00:00
Param Type = c
case_no=2024/42
Param Type = c
trn_rcms_caseregid=15741000007793
Param Type = c
court_code=10421
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 32

>>Mapping
Mapped court_code Row = 1 value = 10421 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11447000008827 idvalue 0
Mapped case_no Row = 1 value = 2024/49 idvalue 0
Mapped prev_hearing_date Row = 1 value = 03/05/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 11472000000003 idvalue 0
Mapped hearing_date Row = 1 value = 20/05/2024 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10421
trn_rcms_caseregid = 11447000008827
case_no = 2024/49
prev_hearing_date = 03/05/2024
hearing_date = 20/05/2024
prev_case_purposename = ???? ????? ????
prev_case_purpose = 
prev_case_purpose after validation = 11472000000003
case_purpose = 11472000000003
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 18556000008663
MapName trcmf1
SourceId 18556000008631
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 11472000000003
hearing_date = 20/05/2024
case_no = 2024/49
trn_rcms_caseregid = 11447000008827
court_code = 10421
case_purpose = 11472000000003
prev_hearing_date = 03/05/2024
Posting record
Param Type = n
trn_rcms_case_histid=18556000008663
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=18556000008631
Param Type = c
cancel=F
Param Type = c
createdby=RAA_kota
Param Type = c
createdon=03/05/2024 16:32:04
Param Type = c
username=RAA_kota
Param Type = c
modifiedon=03/05/2024 16:32: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=11472000000003
Param Type = c
hearing_date=20/05/2024 00:00:00
Param Type = c
case_no=2024/49
Param Type = c
trn_rcms_caseregid=11447000008827
Param Type = c
court_code=10421
Param Type = c
case_purpose=11472000000003
Param Type = c
prev_hearing_date=03/05/2024 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))

Time elapsed for Gen Map = 3923915511270
Time elapsed for MD Map = 3923915511271
Time elapsed for Save History = 3923915511272
Time elapsed for Save Attachment = 3923915511272
Time elapsed for After Save WF Exec = 3923915511275
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"18556000008599"}]}
Savedata webservice completed


Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=RAA_kota
Param Type = c
calledon=03/05/2024 16:31:44
Param Type = c
callfinished=03/05/2024 16:31:51
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=7226
Param Type = n
dbtimetaken=4323
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