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="dcjai" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>dcjai</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">10414</courtcode><hearing_date rowno="001">09/10/2024</hearing_date><axp_recid2 rowno="001">0</axp_recid2><court_code rowno="001">10414</court_code><case_no rowno="001">2015/00051</case_no><trn_rcms_caseid rowno="001">13126000000618</trn_rcms_caseid><pre_case_purpose_name rowno="001">??? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="001">09/10/2024</pre_hear_date><pre_case_purpose rowno="001">19542000000536</pre_case_purpose><next_hear_date rowno="001">26/11/2024</next_hear_date><new_case_purpose rowno="001">19542000000536</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">10414</court_code><case_no rowno="002">2015/00182</case_no><trn_rcms_caseid rowno="002">18025000006183</trn_rcms_caseid><pre_case_purpose_name rowno="002">??? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="002">09/10/2024</pre_hear_date><pre_case_purpose rowno="002">19542000000536</pre_case_purpose><next_hear_date rowno="002">20/11/2024</next_hear_date><new_case_purpose rowno="002">19542000000536</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">10414</court_code><case_no rowno="003">2017/00256</case_no><trn_rcms_caseid rowno="003">13648000001187</trn_rcms_caseid><pre_case_purpose_name rowno="003">??? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="003">09/10/2024</pre_hear_date><pre_case_purpose rowno="003">19542000000536</pre_case_purpose><next_hear_date rowno="003">18/11/2024</next_hear_date><new_case_purpose rowno="003">18619000000000</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">10414</court_code><case_no rowno="004">2018/00303</case_no><trn_rcms_caseid rowno="004">12648000002763</trn_rcms_caseid><pre_case_purpose_name rowno="004">??? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="004">09/10/2024</pre_hear_date><pre_case_purpose rowno="004">19542000000536</pre_case_purpose><next_hear_date rowno="004">20/11/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">10414</court_code><case_no rowno="005">2019/00207</case_no><trn_rcms_caseid rowno="005">15531000002504</trn_rcms_caseid><pre_case_purpose_name rowno="005">??? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="005">09/10/2024</pre_hear_date><pre_case_purpose rowno="005">19542000000536</pre_case_purpose><next_hear_date rowno="005">06/11/2024</next_hear_date><new_case_purpose rowno="005">18473000000000</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">10414</court_code><case_no rowno="006">2019/00293</case_no><trn_rcms_caseid rowno="006">19597000006272</trn_rcms_caseid><pre_case_purpose_name rowno="006">??? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="006">09/10/2024</pre_hear_date><pre_case_purpose rowno="006">19542000000536</pre_case_purpose><next_hear_date rowno="006">19/11/2024</next_hear_date><new_case_purpose rowno="006">19542000000536</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">10414</court_code><case_no rowno="007">2024/230</case_no><trn_rcms_caseid rowno="007">13295000008611</trn_rcms_caseid><pre_case_purpose_name rowno="007">??? ????????? ????</pre_case_purpose_name><pre_hear_date rowno="007">09/10/2024</pre_hear_date><pre_case_purpose rowno="007">19542000000536</pre_case_purpose><next_hear_date rowno="007">20/11/2024</next_hear_date><new_case_purpose rowno="007">19542000000536</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">10414</court_code><case_no rowno="008">2023/153</case_no><trn_rcms_caseid rowno="008">16791000007269</trn_rcms_caseid><pre_case_purpose_name rowno="008">??? ??????</pre_case_purpose_name><pre_hear_date rowno="008">09/10/2024</pre_hear_date><pre_case_purpose rowno="008">10023000000602</pre_case_purpose><next_hear_date rowno="008">29/10/2024</next_hear_date><new_case_purpose rowno="008">10023000000602</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">10414</court_code><case_no rowno="009">2023/321</case_no><trn_rcms_caseid rowno="009">12067000007942</trn_rcms_caseid><pre_case_purpose_name rowno="009">??? ??????</pre_case_purpose_name><pre_hear_date rowno="009">09/10/2024</pre_hear_date><pre_case_purpose rowno="009">10023000000602</pre_case_purpose><next_hear_date rowno="009">30/10/2024</next_hear_date><new_case_purpose rowno="009">10023000000602</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">10414</court_code><case_no rowno="0010">2023/454</case_no><trn_rcms_caseid rowno="0010">13387000007924</trn_rcms_caseid><pre_case_purpose_name rowno="0010">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0010">09/10/2024</pre_hear_date><pre_case_purpose rowno="0010">10023000000602</pre_case_purpose><next_hear_date rowno="0010">04/12/2024</next_hear_date><new_case_purpose rowno="0010">10023000000602</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">10414</court_code><case_no rowno="0011">2024/111</case_no><trn_rcms_caseid rowno="0011">11611000008018</trn_rcms_caseid><pre_case_purpose_name rowno="0011">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0011">09/10/2024</pre_hear_date><pre_case_purpose rowno="0011">10023000000602</pre_case_purpose><next_hear_date rowno="0011">20/11/2024</next_hear_date><new_case_purpose rowno="0011">18678000000000</new_case_purpose><isadjourn rowno="0011">NO</isadjourn><adjourn_type rowno="0011">0</adjourn_type><adjourn_remark rowno="0011"></adjourn_remark><axp_recid2 rowno="0012">0</axp_recid2><court_code rowno="0012">10414</court_code><case_no rowno="0012">2024/177</case_no><trn_rcms_caseid rowno="0012">16436000008066</trn_rcms_caseid><pre_case_purpose_name rowno="0012">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0012">09/10/2024</pre_hear_date><pre_case_purpose rowno="0012">10023000000602</pre_case_purpose><next_hear_date rowno="0012">30/10/2024</next_hear_date><new_case_purpose rowno="0012">10023000000602</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">10414</court_code><case_no rowno="0013">2024/196</case_no><trn_rcms_caseid rowno="0013">13209000009910</trn_rcms_caseid><pre_case_purpose_name rowno="0013">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0013">09/10/2024</pre_hear_date><pre_case_purpose rowno="0013">10023000000602</pre_case_purpose><next_hear_date rowno="0013">23/10/2024</next_hear_date><new_case_purpose rowno="0013">10023000000602</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">10414</court_code><case_no rowno="0014">2024/203</case_no><trn_rcms_caseid rowno="0014">12589000008771</trn_rcms_caseid><pre_case_purpose_name rowno="0014">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0014">09/10/2024</pre_hear_date><pre_case_purpose rowno="0014">10023000000602</pre_case_purpose><next_hear_date rowno="0014">23/10/2024</next_hear_date><new_case_purpose rowno="0014">10023000000602</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">10414</court_code><case_no rowno="0015">2024/25</case_no><trn_rcms_caseid rowno="0015">18593000008568</trn_rcms_caseid><pre_case_purpose_name rowno="0015">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0015">09/10/2024</pre_hear_date><pre_case_purpose rowno="0015">10023000000602</pre_case_purpose><next_hear_date rowno="0015">30/10/2024</next_hear_date><new_case_purpose rowno="0015">10023000000602</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">10414</court_code><case_no rowno="0016">2024/285</case_no><trn_rcms_caseid rowno="0016">18429000009717</trn_rcms_caseid><pre_case_purpose_name rowno="0016">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0016">09/10/2024</pre_hear_date><pre_case_purpose rowno="0016">10023000000602</pre_case_purpose><next_hear_date rowno="0016">22/10/2024</next_hear_date><new_case_purpose rowno="0016">10023000000602</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">10414</court_code><case_no rowno="0017">2024/327</case_no><trn_rcms_caseid rowno="0017">10239000008721</trn_rcms_caseid><pre_case_purpose_name rowno="0017">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0017">09/10/2024</pre_hear_date><pre_case_purpose rowno="0017">10023000000602</pre_case_purpose><next_hear_date rowno="0017">30/10/2024</next_hear_date><new_case_purpose rowno="0017">10023000000602</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">10414</court_code><case_no rowno="0018">2024/328</case_no><trn_rcms_caseid rowno="0018">10262000007894</trn_rcms_caseid><pre_case_purpose_name rowno="0018">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0018">09/10/2024</pre_hear_date><pre_case_purpose rowno="0018">10023000000602</pre_case_purpose><next_hear_date rowno="0018">30/10/2024</next_hear_date><new_case_purpose rowno="0018">10023000000602</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">10414</court_code><case_no rowno="0019">2024/440</case_no><trn_rcms_caseid rowno="0019">15316000007932</trn_rcms_caseid><pre_case_purpose_name rowno="0019">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0019">09/10/2024</pre_hear_date><pre_case_purpose rowno="0019">10023000000602</pre_case_purpose><next_hear_date rowno="0019">30/10/2024</next_hear_date><new_case_purpose rowno="0019">10023000000602</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">10414</court_code><case_no rowno="0020">2024/463</case_no><trn_rcms_caseid rowno="0020">16241000009127</trn_rcms_caseid><pre_case_purpose_name rowno="0020">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0020">09/10/2024</pre_hear_date><pre_case_purpose rowno="0020">10023000000602</pre_case_purpose><next_hear_date rowno="0020">30/10/2024</next_hear_date><new_case_purpose rowno="0020">10023000000602</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">10414</court_code><case_no rowno="0021">2024/464</case_no><trn_rcms_caseid rowno="0021">16245000008476</trn_rcms_caseid><pre_case_purpose_name rowno="0021">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0021">09/10/2024</pre_hear_date><pre_case_purpose rowno="0021">10023000000602</pre_case_purpose><next_hear_date rowno="0021">30/10/2024</next_hear_date><new_case_purpose rowno="0021">10023000000602</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">10414</court_code><case_no rowno="0022">2024/465</case_no><trn_rcms_caseid rowno="0022">16249000009156</trn_rcms_caseid><pre_case_purpose_name rowno="0022">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0022">09/10/2024</pre_hear_date><pre_case_purpose rowno="0022">10023000000602</pre_case_purpose><next_hear_date rowno="0022">30/10/2024</next_hear_date><new_case_purpose rowno="0022">10023000000602</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">10414</court_code><case_no rowno="0023">2024/467</case_no><trn_rcms_caseid rowno="0023">17043000010258</trn_rcms_caseid><pre_case_purpose_name rowno="0023">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0023">09/10/2024</pre_hear_date><pre_case_purpose rowno="0023">10023000000602</pre_case_purpose><next_hear_date rowno="0023">21/10/2024</next_hear_date><new_case_purpose rowno="0023">10023000000602</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">10414</court_code><case_no rowno="0024">2024/490</case_no><trn_rcms_caseid rowno="0024">13669000010577</trn_rcms_caseid><pre_case_purpose_name rowno="0024">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0024">09/10/2024</pre_hear_date><pre_case_purpose rowno="0024">10023000000602</pre_case_purpose><next_hear_date rowno="0024">22/10/2024</next_hear_date><new_case_purpose rowno="0024">10023000000602</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">10414</court_code><case_no rowno="0025">2024/491</case_no><trn_rcms_caseid rowno="0025">13749000008445</trn_rcms_caseid><pre_case_purpose_name rowno="0025">??? ??????</pre_case_purpose_name><pre_hear_date rowno="0025">09/10/2024</pre_hear_date><pre_case_purpose rowno="0025">10023000000602</pre_case_purpose><next_hear_date rowno="0025">22/10/2024</next_hear_date><new_case_purpose rowno="0025">10023000000602</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">10414</court_code><case_no rowno="0026">2023/181</case_no><trn_rcms_caseid rowno="0026">13919000007932</trn_rcms_caseid><pre_case_purpose_name rowno="0026">?????? ??????</pre_case_purpose_name><pre_hear_date rowno="0026">09/10/2024</pre_hear_date><pre_case_purpose rowno="0026">10119000000827</pre_case_purpose><next_hear_date rowno="0026">06/11/2024</next_hear_date><new_case_purpose rowno="0026">10119000000827</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">10414</court_code><case_no rowno="0027">2023/417</case_no><trn_rcms_caseid rowno="0027">10483000007321</trn_rcms_caseid><pre_case_purpose_name rowno="0027">?????? ??????</pre_case_purpose_name><pre_hear_date rowno="0027">09/10/2024</pre_hear_date><pre_case_purpose rowno="0027">10119000000827</pre_case_purpose><next_hear_date rowno="0027">28/10/2024</next_hear_date><new_case_purpose rowno="0027">10119000000827</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">10414</court_code><case_no rowno="0028">2022/174</case_no><trn_rcms_caseid rowno="0028">15877000005664</trn_rcms_caseid><pre_case_purpose_name rowno="0028">????</pre_case_purpose_name><pre_hear_date rowno="0028">09/10/2024</pre_hear_date><pre_case_purpose rowno="0028">18678000000000</pre_case_purpose><next_hear_date rowno="0028">23/10/2024</next_hear_date><new_case_purpose rowno="0028">18678000000000</new_case_purpose><isadjourn rowno="0028">NO</isadjourn><adjourn_type rowno="0028">0</adjourn_type><adjourn_remark rowno="0028"></adjourn_remark><axp_recid2 rowno="0029">0</axp_recid2><court_code rowno="0029">10414</court_code><case_no rowno="0029">2023/451</case_no><trn_rcms_caseid rowno="0029">12581000007795</trn_rcms_caseid><pre_case_purpose_name rowno="0029">????</pre_case_purpose_name><pre_hear_date rowno="0029">09/10/2024</pre_hear_date><pre_case_purpose rowno="0029">18678000000000</pre_case_purpose><next_hear_date rowno="0029">09/12/2024</next_hear_date><new_case_purpose rowno="0029">18678000000000</new_case_purpose><isadjourn rowno="0029">NO</isadjourn><adjourn_type rowno="0029">0</adjourn_type><adjourn_remark rowno="0029"></adjourn_remark><axp_recid2 rowno="0030">0</axp_recid2><court_code rowno="0030">10414</court_code><case_no rowno="0030">2024/166</case_no><trn_rcms_caseid rowno="0030">16643000009462</trn_rcms_caseid><pre_case_purpose_name rowno="0030">????</pre_case_purpose_name><pre_hear_date rowno="0030">09/10/2024</pre_hear_date><pre_case_purpose rowno="0030">18678000000000</pre_case_purpose><next_hear_date rowno="0030">10/12/2024</next_hear_date><new_case_purpose rowno="0030">18473000000000</new_case_purpose><isadjourn rowno="0030">NO</isadjourn><adjourn_type rowno="0030">0</adjourn_type><adjourn_remark rowno="0030"></adjourn_remark><axp_recid2 rowno="0031">0</axp_recid2><court_code rowno="0031">10414</court_code><case_no rowno="0031">2024/408</case_no><trn_rcms_caseid rowno="0031">15127000007405</trn_rcms_caseid><pre_case_purpose_name rowno="0031">????</pre_case_purpose_name><pre_hear_date rowno="0031">09/10/2024</pre_hear_date><pre_case_purpose rowno="0031">18678000000000</pre_case_purpose><next_hear_date rowno="0031">30/10/2024</next_hear_date><new_case_purpose rowno="0031">18678000000000</new_case_purpose><isadjourn rowno="0031">NO</isadjourn><adjourn_type rowno="0031">0</adjourn_type><adjourn_remark rowno="0031"></adjourn_remark><axp_recid2 rowno="0032">0</axp_recid2><court_code rowno="0032">10414</court_code><case_no rowno="0032">2024/409</case_no><trn_rcms_caseid rowno="0032">15128000008975</trn_rcms_caseid><pre_case_purpose_name rowno="0032">????</pre_case_purpose_name><pre_hear_date rowno="0032">09/10/2024</pre_hear_date><pre_case_purpose rowno="0032">18678000000000</pre_case_purpose><next_hear_date rowno="0032">30/10/2024</next_hear_date><new_case_purpose rowno="0032">18678000000000</new_case_purpose><isadjourn rowno="0032">NO</isadjourn><adjourn_type rowno="0032">0</adjourn_type><adjourn_remark rowno="0032"></adjourn_remark><axp_recid2 rowno="0033">0</axp_recid2><court_code rowno="0033">10414</court_code><case_no rowno="0033">2024/410</case_no><trn_rcms_caseid rowno="0033">15129000008497</trn_rcms_caseid><pre_case_purpose_name rowno="0033">????</pre_case_purpose_name><pre_hear_date rowno="0033">09/10/2024</pre_hear_date><pre_case_purpose rowno="0033">18678000000000</pre_case_purpose><next_hear_date rowno="0033">30/10/2024</next_hear_date><new_case_purpose rowno="0033">18678000000000</new_case_purpose><isadjourn rowno="0033">NO</isadjourn><adjourn_type rowno="0033">0</adjourn_type><adjourn_remark rowno="0033"></adjourn_remark></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"dcjai","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"trcmf","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtcode":"10414","hearing_date":"09/10/2024"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"court_code":"10414","case_no":"2015/00051","trn_rcms_caseid":"13126000000618","pre_case_purpose_name":"??? ????????? ????","pre_hear_date":"09/10/2024","pre_case_purpose":"19542000000536","next_hear_date":"26/11/2024","new_case_purpose":"19542000000536","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"002","text":"0","columns":{"court_code":"10414","case_no":"2015/00182","trn_rcms_caseid":"18025000006183","pre_case_purpose_name":"??? ????????? ????","pre_hear_date":"09/10/2024","pre_case_purpose":"19542000000536","next_hear_date":"20/11/2024","new_case_purpose":"19542000000536","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"003","text":"0","columns":{"court_code":"10414","case_no":"2017/00256","trn_rcms_caseid":"13648000001187","pre_case_purpose_name":"??? ????????? ????","pre_hear_date":"09/10/2024","pre_case_purpose":"19542000000536","next_hear_date":"18/11/2024","new_case_purpose":"18619000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"004","text":"0","columns":{"court_code":"10414","case_no":"2018/00303","trn_rcms_caseid":"12648000002763","pre_case_purpose_name":"??? ????????? ????","pre_hear_date":"09/10/2024","pre_case_purpose":"19542000000536","next_hear_date":"20/11/2024","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"005","text":"0","columns":{"court_code":"10414","case_no":"2019/00207","trn_rcms_caseid":"15531000002504","pre_case_purpose_name":"??? ????????? ????","pre_hear_date":"09/10/2024","pre_case_purpose":"19542000000536","next_hear_date":"06/11/2024","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"006","text":"0","columns":{"court_code":"10414","case_no":"2019/00293","trn_rcms_caseid":"19597000006272","pre_case_purpose_name":"??? ????????? ????","pre_hear_date":"09/10/2024","pre_case_purpose":"19542000000536","next_hear_date":"19/11/2024","new_case_purpose":"19542000000536","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"007","text":"0","columns":{"court_code":"10414","case_no":"2024/230","trn_rcms_caseid":"13295000008611","pre_case_purpose_name":"??? ????????? ????","pre_hear_date":"09/10/2024","pre_case_purpose":"19542000000536","next_hear_date":"20/11/2024","new_case_purpose":"19542000000536","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"008","text":"0","columns":{"court_code":"10414","case_no":"2023/153","trn_rcms_caseid":"16791000007269","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"29/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"009","text":"0","columns":{"court_code":"10414","case_no":"2023/321","trn_rcms_caseid":"12067000007942","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"30/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0010","text":"0","columns":{"court_code":"10414","case_no":"2023/454","trn_rcms_caseid":"13387000007924","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"04/12/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0011","text":"0","columns":{"court_code":"10414","case_no":"2024/111","trn_rcms_caseid":"11611000008018","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"20/11/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0012","text":"0","columns":{"court_code":"10414","case_no":"2024/177","trn_rcms_caseid":"16436000008066","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"30/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0013","text":"0","columns":{"court_code":"10414","case_no":"2024/196","trn_rcms_caseid":"13209000009910","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"23/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0014","text":"0","columns":{"court_code":"10414","case_no":"2024/203","trn_rcms_caseid":"12589000008771","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"23/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0015","text":"0","columns":{"court_code":"10414","case_no":"2024/25","trn_rcms_caseid":"18593000008568","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"30/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0016","text":"0","columns":{"court_code":"10414","case_no":"2024/285","trn_rcms_caseid":"18429000009717","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"22/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0017","text":"0","columns":{"court_code":"10414","case_no":"2024/327","trn_rcms_caseid":"10239000008721","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"30/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0018","text":"0","columns":{"court_code":"10414","case_no":"2024/328","trn_rcms_caseid":"10262000007894","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"30/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0019","text":"0","columns":{"court_code":"10414","case_no":"2024/440","trn_rcms_caseid":"15316000007932","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"30/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0020","text":"0","columns":{"court_code":"10414","case_no":"2024/463","trn_rcms_caseid":"16241000009127","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"30/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0021","text":"0","columns":{"court_code":"10414","case_no":"2024/464","trn_rcms_caseid":"16245000008476","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"30/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0022","text":"0","columns":{"court_code":"10414","case_no":"2024/465","trn_rcms_caseid":"16249000009156","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"30/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0023","text":"0","columns":{"court_code":"10414","case_no":"2024/467","trn_rcms_caseid":"17043000010258","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"21/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0024","text":"0","columns":{"court_code":"10414","case_no":"2024/490","trn_rcms_caseid":"13669000010577","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"22/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0025","text":"0","columns":{"court_code":"10414","case_no":"2024/491","trn_rcms_caseid":"13749000008445","pre_case_purpose_name":"??? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10023000000602","next_hear_date":"22/10/2024","new_case_purpose":"10023000000602","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0026","text":"0","columns":{"court_code":"10414","case_no":"2023/181","trn_rcms_caseid":"13919000007932","pre_case_purpose_name":"?????? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10119000000827","next_hear_date":"06/11/2024","new_case_purpose":"10119000000827","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0027","text":"0","columns":{"court_code":"10414","case_no":"2023/417","trn_rcms_caseid":"10483000007321","pre_case_purpose_name":"?????? ??????","pre_hear_date":"09/10/2024","pre_case_purpose":"10119000000827","next_hear_date":"28/10/2024","new_case_purpose":"10119000000827","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0028","text":"0","columns":{"court_code":"10414","case_no":"2022/174","trn_rcms_caseid":"15877000005664","pre_case_purpose_name":"????","pre_hear_date":"09/10/2024","pre_case_purpose":"18678000000000","next_hear_date":"23/10/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0029","text":"0","columns":{"court_code":"10414","case_no":"2023/451","trn_rcms_caseid":"12581000007795","pre_case_purpose_name":"????","pre_hear_date":"09/10/2024","pre_case_purpose":"18678000000000","next_hear_date":"09/12/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0030","text":"0","columns":{"court_code":"10414","case_no":"2024/166","trn_rcms_caseid":"16643000009462","pre_case_purpose_name":"????","pre_hear_date":"09/10/2024","pre_case_purpose":"18678000000000","next_hear_date":"10/12/2024","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0031","text":"0","columns":{"court_code":"10414","case_no":"2024/408","trn_rcms_caseid":"15127000007405","pre_case_purpose_name":"????","pre_hear_date":"09/10/2024","pre_case_purpose":"18678000000000","next_hear_date":"30/10/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0032","text":"0","columns":{"court_code":"10414","case_no":"2024/409","trn_rcms_caseid":"15128000008975","pre_case_purpose_name":"????","pre_hear_date":"09/10/2024","pre_case_purpose":"18678000000000","next_hear_date":"30/10/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0033","text":"0","columns":{"court_code":"10414","case_no":"2024/410","trn_rcms_caseid":"15129000008497","pre_case_purpose_name":"????","pre_hear_date":"09/10/2024","pre_case_purpose":"18678000000000","next_hear_date":"30/10/2024","new_case_purpose":"18678000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}}]}]}}
Verifying username and password
User Name : dcjai
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=dcjai
Time elapsed = 26
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 11
Result : 
Verifying completed...
Page Access Category : 
User Name : dcjai
Select sysdate as sdt from dual
Time elapsed = 12
dt=17/10/2024 11:14:55
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=dcjai
dt=17/10/2024 11:14:55
dt=17/10/2024 11:14:55
Time elapsed = 13
User Groups: court_reader
select userroles from axusergroups where groupname in ( 'court_reader' )
Time elapsed = 6
User Roles : court_reader
Loading App/User vars
reading the props xml
Step3
Sql : select props from axprops where lower(name)= :name  order by blobno

Paramval : app
ParamTYpe : c
Param List : name

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

Time elapsed = 4
Step4
axprops\stm size:4235
Step4-123456
<root updatedon="27/09/2024 11:32:01" name="app" caption="app" appverno="10.1.0.0" updusername="" updatedby="admin"><props LocalNum="736"><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=dcjai
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=dcjai
Time elapsed = 8
   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=dcjai
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=dcjai
Time elapsed = 9
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type})
   Calling function sqlget
   Result of sqlget = DC
   Result = DC
   Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
   Calling function firesql
username=dcjai
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=dcjai
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{court_name_mastid})
   Calling function sqlget
   Result of sqlget = 13289000000049
   Result = 13289000000049
   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=dcjai
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{axusersid})
   Calling function sqlget
   Result of sqlget = 1068220008977
   Result = 1068220008977
   Evaluating firesql({m4},{select :username as uname from dual})
   Calling function firesql
select :username as uname from dual
username=dcjai
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{uname})
   Calling function sqlget
   Result of sqlget = dcjai
   Result = dcjai
   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=dcjai
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{COURT_CODE})
   Calling function sqlget
   Result of sqlget = 10414
   Result = 10414
   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 = 5
   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=dcjai
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=dcjai
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m7},{DISTNAMEENG})
   Calling function sqlget
   Result of sqlget = Jaipur
   Result = Jaipur
   Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=dcjai
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=dcjai
Time elapsed = 7
   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=1068220008977
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1068220008977
Time elapsed = 9
   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=dcjai
Time elapsed = 234
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type_mastid})
   Calling function sqlget
   Result of sqlget = 10206000000013
   Result = 10206000000013
   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=dcjai
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=dcjai
Time elapsed = 10
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{groupname})
   Calling function sqlget
   Result of sqlget = court_reader
   Result = court_reader
   Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
   Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 9
   Result of firesql = 
   Result = 
   Evaluating  sqlget({a1},{dd})
   Calling function sqlget
   Result of sqlget = 30/01/2021
   Result = 30/01/2021
   Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
   Calling function firesql
username=dcjai
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=dcjai
Time elapsed = 12
   Result of firesql = 
   Result = 
   Evaluating  sqlget({P1},{ct})
   Calling function sqlget
   Result of sqlget = 8
   Result = 8
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 = 5
select Props from axuseraccess where lower(rname)='court_reader' and lower(sname)='trcmf' and stype = 't'
Time elapsed = 9
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 = 8
Step4
tstructs\stm size:2075
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
   Evaluating date()
   Result = 
   Evaluating iif((next_hear_date<currdate) | (next_hear_date<pre_hear_date) ,{Hearing date should be greater or equal to current date/previous hearing date.},{T})
   Result = 
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=trcmf
adxinout=o
Time elapsed = 8
select * from trn_rcms_mhearing where trn_rcms_mhearingid=0
Time elapsed = 5
select * from Axusers where 1=2
Time elapsed = 7
select distinct(fldname) from AxTempUserFields
Time elapsed = 6
select * from AxAttachWorkflow where lower(transid) = 'trcmf'
Time elapsed = 5
Step3
Sql : select props from tstructs where lower(name)= :name  order by blobno

Paramval : tchdh
ParamTYpe : c
Param List : name

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

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

>>Validating trcmf

>>Frame No 1
courtcode = 10414
hearing_date = 09/10/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 = 5
RecordId = 10825000009797
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
hearing_date = 09/10/2024
courtcode = 10414
Posting record
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:56
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=09/10/2024 00:00:00
Param Type = c
courtcode=10414
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)

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

Time elapsed = 4
RecordId = 10825000009798
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2015/00051
trn_rcms_caseid = 13126000000618
pre_hear_date = 09/10/2024
court_code = 10414
isadjourn = NO
adjourn_type = 0
adjourn_remark = 
pre_case_purpose = 19542000000536
new_case_purpose = 19542000000536
next_hear_date = 26/11/2024
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=10825000009798
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:56
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2015/00051
Param Type = c
trn_rcms_caseid=13126000000618
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = c
court_code=10414
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
new_case_purpose=19542000000536
Param Type = c
next_hear_date=26/11/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,case_no,trn_rcms_caseid,pre_hear_date,court_code,isadjourn,adjourn_type,adjourn_remark,pre_case_purpose,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:isadjourn,:adjourn_type,null,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 5
RecordId = 10825000009799
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 20/11/2024
isadjourn = NO
new_case_purpose = 19542000000536
pre_case_purpose = 19542000000536
pre_hear_date = 09/10/2024
case_no = 2015/00182
court_code = 10414
trn_rcms_caseid = 18025000006183
adjourn_type = 0
adjourn_remark = 
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=10825000009799
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:56
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=20/11/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=19542000000536
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = c
case_no=2015/00182
Param Type = c
court_code=10414
Param Type = c
trn_rcms_caseid=18025000006183
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,new_case_purpose,pre_case_purpose,pre_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_type,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:adjourn_type,null,:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 10825000009800
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 09/10/2024
pre_case_purpose = 19542000000536
trn_rcms_caseid = 13648000001187
court_code = 10414
case_no = 2017/00256
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 18619000000000
next_hear_date = 18/11/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=10825000009800
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:56
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
trn_rcms_caseid=13648000001187
Param Type = c
court_code=10414
Param Type = c
case_no=2017/00256
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=18619000000000
Param Type = c
next_hear_date=18/11/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 = 5
RecordId = 10825000009801
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 17
Select sysdate as sdt from dual
Time elapsed = 8
next_hear_date = 20/11/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2018/00303
court_code = 10414
trn_rcms_caseid = 12648000002763
pre_case_purpose = 19542000000536
pre_hear_date = 09/10/2024
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=10825000009801
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:56
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=20/11/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=2018/00303
Param Type = c
court_code=10414
Param Type = c
trn_rcms_caseid=12648000002763
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
pre_hear_date=09/10/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,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 5 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 10825000009802
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 06/11/2024
new_case_purpose = 18473000000000
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2019/00207
court_code = 10414
trn_rcms_caseid = 15531000002504
pre_case_purpose = 19542000000536
pre_hear_date = 09/10/2024
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=10825000009802
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:56
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=06/11/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=2019/00207
Param Type = c
court_code=10414
Param Type = c
trn_rcms_caseid=15531000002504
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
pre_hear_date=09/10/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 = 3
RecordId = 10825000009803
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 8
next_hear_date = 19/11/2024
new_case_purpose = 19542000000536
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2019/00293
court_code = 10414
trn_rcms_caseid = 19597000006272
pre_case_purpose = 19542000000536
pre_hear_date = 09/10/2024
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=10825000009803
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:56
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=19/11/2024 00:00:00
Param Type = c
new_case_purpose=19542000000536
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2019/00293
Param Type = c
court_code=10414
Param Type = c
trn_rcms_caseid=19597000006272
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
pre_hear_date=09/10/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 = 5
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 = 10825000009804
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 09/10/2024
pre_case_purpose = 19542000000536
trn_rcms_caseid = 13295000008611
court_code = 10414
case_no = 2024/230
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 19542000000536
next_hear_date = 20/11/2024
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=10825000009804
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:56
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:56
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = n
pre_case_purpose=19542000000536
Param Type = c
trn_rcms_caseid=13295000008611
Param Type = c
court_code=10414
Param Type = c
case_no=2024/230
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=19542000000536
Param Type = c
next_hear_date=20/11/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=7
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 10825000009805
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
new_case_purpose = 10023000000602
next_hear_date = 29/10/2024
case_no = 2023/153
court_code = 10414
trn_rcms_caseid = 16791000007269
pre_case_purpose = 10023000000602
pre_hear_date = 09/10/2024
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=10825000009805
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:57
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=10023000000602
Param Type = c
next_hear_date=29/10/2024 00:00:00
Param Type = c
case_no=2023/153
Param Type = c
court_code=10414
Param Type = c
trn_rcms_caseid=16791000007269
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=8
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,new_case_purpose,next_hear_date,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 10825000009806
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 8
next_hear_date = 30/10/2024
new_case_purpose = 10023000000602
adjourn_type = 0
isadjourn = NO
pre_case_purpose = 10023000000602
case_no = 2023/321
court_code = 10414
pre_hear_date = 09/10/2024
trn_rcms_caseid = 12067000007942
adjourn_remark = 
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=10825000009806
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:57
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=30/10/2024 00:00:00
Param Type = c
new_case_purpose=10023000000602
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
case_no=2023/321
Param Type = c
court_code=10414
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = c
trn_rcms_caseid=12067000007942
Param Type = n
trn_rcms_hearingrow=9
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_type,isadjourn,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:isadjourn,:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,null,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 5
RecordId = 10825000009807
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
pre_case_purpose = 10023000000602
new_case_purpose = 10023000000602
isadjourn = NO
next_hear_date = 04/12/2024
case_no = 2023/454
court_code = 10414
trn_rcms_caseid = 13387000007924
adjourn_remark = 
pre_hear_date = 09/10/2024
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=10825000009807
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:57
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
new_case_purpose=10023000000602
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=04/12/2024 00:00:00
Param Type = c
case_no=2023/454
Param Type = c
court_code=10414
Param Type = c
trn_rcms_caseid=13387000007924
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=10
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,pre_case_purpose,new_case_purpose,isadjourn,next_hear_date,case_no,court_code,trn_rcms_caseid,adjourn_remark,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,:pre_case_purpose,:new_case_purpose,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:trn_rcms_caseid,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 10825000009808
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
court_code = 10414
adjourn_type = 0
isadjourn = NO
case_no = 2024/111
adjourn_remark = 
next_hear_date = 20/11/2024
pre_case_purpose = 10023000000602
pre_hear_date = 09/10/2024
new_case_purpose = 18678000000000
trn_rcms_caseid = 11611000008018
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=10825000009808
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:57
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10414
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/111
Param Type = c
next_hear_date=20/11/2024 00:00:00
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
trn_rcms_caseid=11611000008018
Param Type = n
trn_rcms_hearingrow=11
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,adjourn_type,isadjourn,case_no,adjourn_remark,next_hear_date,pre_case_purpose,pre_hear_date,new_case_purpose,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:adjourn_type,:isadjourn,:case_no,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_caseid,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 5
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 = 3
RecordId = 10825000009809
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
pre_hear_date = 09/10/2024
pre_case_purpose = 10023000000602
court_code = 10414
case_no = 2024/177
trn_rcms_caseid = 16436000008066
new_case_purpose = 10023000000602
adjourn_type = 0
adjourn_remark = 
next_hear_date = 30/10/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=10825000009809
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:57
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
court_code=10414
Param Type = c
case_no=2024/177
Param Type = c
trn_rcms_caseid=16436000008066
Param Type = c
new_case_purpose=10023000000602
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=30/10/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=12
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,court_code,case_no,trn_rcms_caseid,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:court_code,:case_no,:trn_rcms_caseid,:new_case_purpose,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)

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

Time elapsed = 5
RecordId = 10825000009810
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
case_no = 2024/196
new_case_purpose = 10023000000602
pre_case_purpose = 10023000000602
trn_rcms_caseid = 13209000009910
pre_hear_date = 09/10/2024
adjourn_remark = 
court_code = 10414
adjourn_type = 0
next_hear_date = 23/10/2024
isadjourn = NO
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=10825000009810
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:57
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2024/196
Param Type = c
new_case_purpose=10023000000602
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
trn_rcms_caseid=13209000009910
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = c
court_code=10414
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=23/10/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
trn_rcms_hearingrow=13
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,new_case_purpose,pre_case_purpose,trn_rcms_caseid,pre_hear_date,adjourn_remark,court_code,adjourn_type,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:new_case_purpose,:pre_case_purpose,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 10825000009811
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 23/10/2024
new_case_purpose = 10023000000602
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2024/203
court_code = 10414
trn_rcms_caseid = 12589000008771
pre_case_purpose = 10023000000602
pre_hear_date = 09/10/2024
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=10825000009811
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:57
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=23/10/2024 00:00:00
Param Type = c
new_case_purpose=10023000000602
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/203
Param Type = c
court_code=10414
Param Type = c
trn_rcms_caseid=12589000008771
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
pre_hear_date=09/10/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 = 5
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 = 10825000009812
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 09/10/2024
pre_case_purpose = 10023000000602
trn_rcms_caseid = 18593000008568
court_code = 10414
case_no = 2024/25
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
next_hear_date = 30/10/2024
new_case_purpose = 10023000000602
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=10825000009812
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:57
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
trn_rcms_caseid=18593000008568
Param Type = c
court_code=10414
Param Type = c
case_no=2024/25
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=30/10/2024 00:00:00
Param Type = c
new_case_purpose=10023000000602
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_remark,adjourn_type,next_hear_date,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 10825000009813
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 11
Select sysdate as sdt from dual
Time elapsed = 11
trn_rcms_caseid = 18429000009717
pre_hear_date = 09/10/2024
court_code = 10414
case_no = 2024/285
next_hear_date = 22/10/2024
isadjourn = NO
adjourn_type = 0
pre_case_purpose = 10023000000602
adjourn_remark = 
new_case_purpose = 10023000000602
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=10825000009813
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:58
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=18429000009717
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = c
court_code=10414
Param Type = c
case_no=2024/285
Param Type = c
next_hear_date=22/10/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
new_case_purpose=10023000000602
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,adjourn_type,pre_case_purpose,adjourn_remark,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:adjourn_type,:pre_case_purpose,null,:new_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 5
RecordId = 10825000009814
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 09/10/2024
trn_rcms_caseid = 10239000008721
isadjourn = NO
pre_case_purpose = 10023000000602
adjourn_type = 0
court_code = 10414
case_no = 2024/327
adjourn_remark = 
next_hear_date = 30/10/2024
new_case_purpose = 10023000000602
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=10825000009814
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:58
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = c
trn_rcms_caseid=10239000008721
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
adjourn_type=0
Param Type = c
court_code=10414
Param Type = c
case_no=2024/327
Param Type = c
next_hear_date=30/10/2024 00:00:00
Param Type = c
new_case_purpose=10023000000602
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,trn_rcms_caseid,isadjourn,pre_case_purpose,adjourn_type,court_code,case_no,adjourn_remark,next_hear_date,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:isadjourn,:pre_case_purpose,:adjourn_type,:court_code,:case_no,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 4
RecordId = 10825000009815
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
court_code = 10414
adjourn_type = 0
isadjourn = NO
new_case_purpose = 10023000000602
next_hear_date = 30/10/2024
trn_rcms_caseid = 10262000007894
pre_case_purpose = 10023000000602
case_no = 2024/328
pre_hear_date = 09/10/2024
adjourn_remark = 
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=10825000009815
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:58
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10414
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=10023000000602
Param Type = c
next_hear_date=30/10/2024 00:00:00
Param Type = c
trn_rcms_caseid=10262000007894
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
case_no=2024/328
Param Type = c
pre_hear_date=09/10/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,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 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 10825000009816
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 09/10/2024
pre_case_purpose = 10023000000602
trn_rcms_caseid = 15316000007932
court_code = 10414
case_no = 2024/440
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 10023000000602
next_hear_date = 30/10/2024
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=10825000009816
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:58
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
trn_rcms_caseid=15316000007932
Param Type = c
court_code=10414
Param Type = c
case_no=2024/440
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=10023000000602
Param Type = c
next_hear_date=30/10/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,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 20 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 10825000009817
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 30/10/2024
new_case_purpose = 10023000000602
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2024/463
court_code = 10414
trn_rcms_caseid = 16241000009127
pre_case_purpose = 10023000000602
pre_hear_date = 09/10/2024
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=10825000009817
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:58
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=30/10/2024 00:00:00
Param Type = c
new_case_purpose=10023000000602
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2024/463
Param Type = c
court_code=10414
Param Type = c
trn_rcms_caseid=16241000009127
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=20
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 10825000009818
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
new_case_purpose = 10023000000602
next_hear_date = 30/10/2024
trn_rcms_caseid = 16245000008476
pre_hear_date = 09/10/2024
pre_case_purpose = 10023000000602
case_no = 2024/464
court_code = 10414
adjourn_remark = 
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=10825000009818
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:58
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=10023000000602
Param Type = c
next_hear_date=30/10/2024 00:00:00
Param Type = c
trn_rcms_caseid=16245000008476
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
case_no=2024/464
Param Type = c
court_code=10414
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = n
trn_rcms_hearingrow=21
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,next_hear_date,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,court_code,adjourn_remark,isadjourn,adjourn_type,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,null,:isadjourn,:adjourn_type,:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 10825000009819
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
pre_hear_date = 09/10/2024
pre_case_purpose = 10023000000602
trn_rcms_caseid = 16249000009156
court_code = 10414
case_no = 2024/465
isadjourn = NO
adjourn_type = 0
next_hear_date = 30/10/2024
adjourn_remark = 
new_case_purpose = 10023000000602
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=10825000009819
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:58
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
trn_rcms_caseid=16249000009156
Param Type = c
court_code=10414
Param Type = c
case_no=2024/465
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=30/10/2024 00:00:00
Param Type = c
new_case_purpose=10023000000602
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,pre_hear_date,pre_case_purpose,trn_rcms_caseid,court_code,case_no,isadjourn,adjourn_type,next_hear_date,adjourn_remark,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:trn_rcms_caseid,:court_code,:case_no,:isadjourn,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:new_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 5
RecordId = 10825000009820
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
pre_case_purpose = 10023000000602
court_code = 10414
pre_hear_date = 09/10/2024
case_no = 2024/467
trn_rcms_caseid = 17043000010258
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 10023000000602
next_hear_date = 21/10/2024
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=10825000009820
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:58
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
court_code=10414
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = c
case_no=2024/467
Param Type = c
trn_rcms_caseid=17043000010258
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=10023000000602
Param Type = c
next_hear_date=21/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=23
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 10825000009821
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 28
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_remark = 
new_case_purpose = 10023000000602
adjourn_type = 0
isadjourn = NO
next_hear_date = 22/10/2024
pre_case_purpose = 10023000000602
case_no = 2024/490
court_code = 10414
pre_hear_date = 09/10/2024
trn_rcms_caseid = 13669000010577
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=10825000009821
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:58
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:58
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=10023000000602
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=22/10/2024 00:00:00
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
case_no=2024/490
Param Type = c
court_code=10414
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = c
trn_rcms_caseid=13669000010577
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,new_case_purpose,adjourn_type,isadjourn,next_hear_date,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:new_case_purpose,:adjourn_type,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:trn_rcms_hearingrow)

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

Time elapsed = 5
RecordId = 10825000009822
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark = 
trn_rcms_caseid = 13749000008445
pre_hear_date = 09/10/2024
court_code = 10414
case_no = 2024/491
pre_case_purpose = 10023000000602
isadjourn = NO
adjourn_type = 0
new_case_purpose = 10023000000602
next_hear_date = 22/10/2024
TRN_RCMS_HEARINGrow = 25
Posting record
Param Type = n
trn_rcms_hearingid=10825000009822
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:59
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=13749000008445
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = c
court_code=10414
Param Type = c
case_no=2024/491
Param Type = n
pre_case_purpose=10023000000602
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=10023000000602
Param Type = c
next_hear_date=22/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=25
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,pre_case_purpose,isadjourn,adjourn_type,new_case_purpose,next_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:pre_case_purpose,:isadjourn,:adjourn_type,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 6
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 = 6
RecordId = 10825000009823
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 13919000007932
case_no = 2023/181
pre_hear_date = 09/10/2024
next_hear_date = 06/11/2024
new_case_purpose = 10119000000827
isadjourn = NO
court_code = 10414
pre_case_purpose = 10119000000827
TRN_RCMS_HEARINGrow = 26
Posting record
Param Type = n
trn_rcms_hearingid=10825000009823
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:59
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=13919000007932
Param Type = c
case_no=2023/181
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = c
next_hear_date=06/11/2024 00:00:00
Param Type = c
new_case_purpose=10119000000827
Param Type = c
isadjourn=NO
Param Type = c
court_code=10414
Param Type = n
pre_case_purpose=10119000000827
Param Type = n
trn_rcms_hearingrow=26
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,case_no,pre_hear_date,next_hear_date,new_case_purpose,isadjourn,court_code,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,:court_code,:pre_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 5
RecordId = 10825000009824
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 10483000007321
pre_hear_date = 09/10/2024
court_code = 10414
case_no = 2023/417
next_hear_date = 28/10/2024
isadjourn = NO
pre_case_purpose = 10119000000827
new_case_purpose = 10119000000827
TRN_RCMS_HEARINGrow = 27
Posting record
Param Type = n
trn_rcms_hearingid=10825000009824
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:59
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=10483000007321
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = c
court_code=10414
Param Type = c
case_no=2023/417
Param Type = c
next_hear_date=28/10/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=10119000000827
Param Type = c
new_case_purpose=10119000000827
Param Type = n
trn_rcms_hearingrow=27
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 8
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 = 6
RecordId = 10825000009825
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 8
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
trn_rcms_caseid = 15877000005664
pre_hear_date = 09/10/2024
pre_case_purpose = 18678000000000
case_no = 2022/174
next_hear_date = 23/10/2024
new_case_purpose = 18678000000000
court_code = 10414
TRN_RCMS_HEARINGrow = 28
Posting record
Param Type = n
trn_rcms_hearingid=10825000009825
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:59
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:59
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=15877000005664
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
case_no=2022/174
Param Type = c
next_hear_date=23/10/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
court_code=10414
Param Type = n
trn_rcms_hearingrow=28
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,isadjourn,trn_rcms_caseid,pre_hear_date,pre_case_purpose,case_no,next_hear_date,new_case_purpose,court_code,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:court_code,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 10825000009826
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 6
isadjourn = NO
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 12581000007795
case_no = 2023/451
court_code = 10414
pre_hear_date = 09/10/2024
next_hear_date = 09/12/2024
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
TRN_RCMS_HEARINGrow = 29
Posting record
Param Type = n
trn_rcms_hearingid=10825000009826
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:59
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:59
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=12581000007795
Param Type = c
case_no=2023/451
Param Type = c
court_code=10414
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = c
next_hear_date=09/12/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = n
trn_rcms_hearingrow=29
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isadjourn,adjourn_type,adjourn_remark,trn_rcms_caseid,case_no,court_code,pre_hear_date,next_hear_date,new_case_purpose,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,:adjourn_type,null,:trn_rcms_caseid,:case_no,:court_code,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 5
RecordId = 10825000009827
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 10
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
next_hear_date = 10/12/2024
case_no = 2024/166
court_code = 10414
trn_rcms_caseid = 16643000009462
new_case_purpose = 18473000000000
pre_case_purpose = 18678000000000
pre_hear_date = 09/10/2024
TRN_RCMS_HEARINGrow = 30
Posting record
Param Type = n
trn_rcms_hearingid=10825000009827
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:59
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:59
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=10/12/2024 00:00:00
Param Type = c
case_no=2024/166
Param Type = c
court_code=10414
Param Type = c
trn_rcms_caseid=16643000009462
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=09/10/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,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 = 7
Adding new record to store data from Frame 2, Row 31 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 10825000009828
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 30/10/2024
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 15127000007405
case_no = 2024/408
court_code = 10414
new_case_purpose = 18678000000000
pre_case_purpose = 18678000000000
pre_hear_date = 09/10/2024
TRN_RCMS_HEARINGrow = 31
Posting record
Param Type = n
trn_rcms_hearingid=10825000009828
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:59
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=30/10/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=15127000007405
Param Type = c
case_no=2024/408
Param Type = c
court_code=10414
Param Type = c
new_case_purpose=18678000000000
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=09/10/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,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 = 6
Adding new record to store data from Frame 2, Row 32 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 10825000009829
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 30/10/2024
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 18678000000000
case_no = 2024/409
court_code = 10414
trn_rcms_caseid = 15128000008975
pre_case_purpose = 18678000000000
pre_hear_date = 09/10/2024
TRN_RCMS_HEARINGrow = 32
Posting record
Param Type = n
trn_rcms_hearingid=10825000009829
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:59
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=30/10/2024 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=18678000000000
Param Type = c
case_no=2024/409
Param Type = c
court_code=10414
Param Type = c
trn_rcms_caseid=15128000008975
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=09/10/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,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 10825000009830
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 30/10/2024
new_case_purpose = 18678000000000
adjourn_remark = 
adjourn_type = 0
isadjourn = NO
case_no = 2024/410
court_code = 10414
trn_rcms_caseid = 15129000008497
pre_case_purpose = 18678000000000
pre_hear_date = 09/10/2024
TRN_RCMS_HEARINGrow = 33
Posting record
Param Type = n
trn_rcms_hearingid=10825000009830
Param Type = n
trn_rcms_mhearingid=10825000009797
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:14:59
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:14:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=30/10/2024 00:00:00
Param Type = c
new_case_purpose=18678000000000
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2024/410
Param Type = c
court_code=10414
Param Type = c
trn_rcms_caseid=15129000008497
Param Type = n
pre_case_purpose=18678000000000
Param Type = c
pre_hear_date=09/10/2024 00:00:00
Param Type = n
trn_rcms_hearingrow=33
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,adjourn_remark,adjourn_type,isadjourn,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,null,:adjourn_type,:isadjourn,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

Time elapsed for insert/update = 3938325299409

>>Executing genmaps

>>Posting from trcmf to tchdh from row 1

>>Mapping
Mapped court_code Row = 1 value = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13126000000618 idvalue 0
Mapped case_no Row = 1 value = 2015/00051 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 26/11/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 = 10414
trn_rcms_caseregid = 13126000000618
case_no = 2015/00051
prev_hearing_date = 09/10/2024
hearing_date = 26/11/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 = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 10825000009831
MapName trcmf1
SourceId 10825000009798
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 211
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 26/11/2024
case_no = 2015/00051
trn_rcms_caseregid = 13126000000618
court_code = 10414
case_purpose = 19542000000536
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009831
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009798
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:00
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:00
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=26/11/2024 00:00:00
Param Type = c
case_no=2015/00051
Param Type = c
trn_rcms_caseregid=13126000000618
Param Type = c
court_code=10414
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18025000006183 idvalue 0
Mapped case_no Row = 1 value = 2015/00182 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 20/11/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 = 10414
trn_rcms_caseregid = 18025000006183
case_no = 2015/00182
prev_hearing_date = 09/10/2024
hearing_date = 20/11/2024
prev_case_purposename = ??? ????????? ????
prev_case_purpose = 
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 10825000009832
MapName trcmf1
SourceId 10825000009799
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 20/11/2024
case_no = 2015/00182
trn_rcms_caseregid = 18025000006183
court_code = 10414
case_purpose = 19542000000536
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009832
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009799
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:03
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15: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=19542000000536
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2015/00182
Param Type = c
trn_rcms_caseregid=18025000006183
Param Type = c
court_code=10414
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13648000001187 idvalue 0
Mapped case_no Row = 1 value = 2017/00256 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 18619000000000 idvalue 0
Mapped hearing_date Row = 1 value = 18/11/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 = 10414
trn_rcms_caseregid = 13648000001187
case_no = 2017/00256
prev_hearing_date = 09/10/2024
hearing_date = 18/11/2024
prev_case_purposename = ??? ????????? ????
prev_case_purpose = 
prev_case_purpose after validation = 19542000000536
case_purpose = 18619000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 10825000009833
MapName trcmf1
SourceId 10825000009800
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 18/11/2024
case_no = 2017/00256
trn_rcms_caseregid = 13648000001187
court_code = 10414
case_purpose = 18619000000000
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009833
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009800
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:05
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:05
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=19542000000536
Param Type = c
hearing_date=18/11/2024 00:00:00
Param Type = c
case_no=2017/00256
Param Type = c
trn_rcms_caseregid=13648000001187
Param Type = c
court_code=10414
Param Type = c
case_purpose=18619000000000
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12648000002763 idvalue 0
Mapped case_no Row = 1 value = 2018/00303 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/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 = 20/11/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 = 10414
trn_rcms_caseregid = 12648000002763
case_no = 2018/00303
prev_hearing_date = 09/10/2024
hearing_date = 20/11/2024
prev_case_purposename = ??? ????????? ????
prev_case_purpose = 
prev_case_purpose after validation = 19542000000536
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 = 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 = 10825000009834
MapName trcmf1
SourceId 10825000009801
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 = 19542000000536
hearing_date = 20/11/2024
case_no = 2018/00303
trn_rcms_caseregid = 12648000002763
court_code = 10414
case_purpose = 1000492
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009834
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009801
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:08
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:08
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2018/00303
Param Type = c
trn_rcms_caseregid=12648000002763
Param Type = c
court_code=10414
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15531000002504 idvalue 0
Mapped case_no Row = 1 value = 2019/00207 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/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/11/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 = 10414
trn_rcms_caseregid = 15531000002504
case_no = 2019/00207
prev_hearing_date = 09/10/2024
hearing_date = 06/11/2024
prev_case_purposename = ??? ????????? ????
prev_case_purpose = 
prev_case_purpose after validation = 19542000000536
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 10825000009835
MapName trcmf1
SourceId 10825000009802
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 = 19542000000536
hearing_date = 06/11/2024
case_no = 2019/00207
trn_rcms_caseregid = 15531000002504
court_code = 10414
case_purpose = 18473000000000
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009835
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009802
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:10
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:10
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=06/11/2024 00:00:00
Param Type = c
case_no=2019/00207
Param Type = c
trn_rcms_caseregid=15531000002504
Param Type = c
court_code=10414
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19597000006272 idvalue 0
Mapped case_no Row = 1 value = 2019/00293 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 19/11/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 = 10414
trn_rcms_caseregid = 19597000006272
case_no = 2019/00293
prev_hearing_date = 09/10/2024
hearing_date = 19/11/2024
prev_case_purposename = ??? ????????? ????
prev_case_purpose = 
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 6
RecordId = 10825000009836
MapName trcmf1
SourceId 10825000009803
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 19/11/2024
case_no = 2019/00293
trn_rcms_caseregid = 19597000006272
court_code = 10414
case_purpose = 19542000000536
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009836
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009803
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:12
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:12
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=19/11/2024 00:00:00
Param Type = c
case_no=2019/00293
Param Type = c
trn_rcms_caseregid=19597000006272
Param Type = c
court_code=10414
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13295000008611 idvalue 0
Mapped case_no Row = 1 value = 2024/230 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ????????? ???? idvalue 0
Mapped case_purpose Row = 1 value = 19542000000536 idvalue 0
Mapped hearing_date Row = 1 value = 20/11/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 = 10414
trn_rcms_caseregid = 13295000008611
case_no = 2024/230
prev_hearing_date = 09/10/2024
hearing_date = 20/11/2024
prev_case_purposename = ??? ????????? ????
prev_case_purpose = 
prev_case_purpose after validation = 19542000000536
case_purpose = 19542000000536
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 = 10825000009837
MapName trcmf1
SourceId 10825000009804
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 19542000000536
hearing_date = 20/11/2024
case_no = 2024/230
trn_rcms_caseregid = 13295000008611
court_code = 10414
case_purpose = 19542000000536
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009837
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009804
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:15
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:15
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=19542000000536
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2024/230
Param Type = c
trn_rcms_caseregid=13295000008611
Param Type = c
court_code=10414
Param Type = c
case_purpose=19542000000536
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16791000007269 idvalue 0
Mapped case_no Row = 1 value = 2023/153 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 29/10/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 = 10414
trn_rcms_caseregid = 16791000007269
case_no = 2023/153
prev_hearing_date = 09/10/2024
hearing_date = 29/10/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 = 10023000000602
case_purpose = 10023000000602
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 10825000009838
MapName trcmf1
SourceId 10825000009805
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 10023000000602
hearing_date = 29/10/2024
case_no = 2023/153
trn_rcms_caseregid = 16791000007269
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009838
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009805
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:17
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:17
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=29/10/2024 00:00:00
Param Type = c
case_no=2023/153
Param Type = c
trn_rcms_caseregid=16791000007269
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12067000007942 idvalue 0
Mapped case_no Row = 1 value = 2023/321 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 30/10/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 = 10414
trn_rcms_caseregid = 12067000007942
case_no = 2023/321
prev_hearing_date = 09/10/2024
hearing_date = 30/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
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 = 10825000009839
MapName trcmf1
SourceId 10825000009806
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 = 10023000000602
hearing_date = 30/10/2024
case_no = 2023/321
trn_rcms_caseregid = 12067000007942
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009839
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009806
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:20
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=30/10/2024 00:00:00
Param Type = c
case_no=2023/321
Param Type = c
trn_rcms_caseregid=12067000007942
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13387000007924 idvalue 0
Mapped case_no Row = 1 value = 2023/454 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 04/12/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 = 10414
trn_rcms_caseregid = 13387000007924
case_no = 2023/454
prev_hearing_date = 09/10/2024
hearing_date = 04/12/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
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 = 10825000009840
MapName trcmf1
SourceId 10825000009807
Select sysdate as sdt from dual
Time elapsed = 9
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 = 10023000000602
hearing_date = 04/12/2024
case_no = 2023/454
trn_rcms_caseregid = 13387000007924
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009840
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009807
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:22
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=04/12/2024 00:00:00
Param Type = c
case_no=2023/454
Param Type = c
trn_rcms_caseregid=13387000007924
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11611000008018 idvalue 0
Mapped case_no Row = 1 value = 2024/111 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 20/11/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 = 10414
trn_rcms_caseregid = 11611000008018
case_no = 2024/111
prev_hearing_date = 09/10/2024
hearing_date = 20/11/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 10825000009841
MapName trcmf1
SourceId 10825000009808
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 = 10023000000602
hearing_date = 20/11/2024
case_no = 2024/111
trn_rcms_caseregid = 11611000008018
court_code = 10414
case_purpose = 18678000000000
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009841
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009808
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:24
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=20/11/2024 00:00:00
Param Type = c
case_no=2024/111
Param Type = c
trn_rcms_caseregid=11611000008018
Param Type = c
court_code=10414
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16436000008066 idvalue 0
Mapped case_no Row = 1 value = 2024/177 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 30/10/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 = 10414
trn_rcms_caseregid = 16436000008066
case_no = 2024/177
prev_hearing_date = 09/10/2024
hearing_date = 30/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 10825000009842
MapName trcmf1
SourceId 10825000009809
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 = 10023000000602
hearing_date = 30/10/2024
case_no = 2024/177
trn_rcms_caseregid = 16436000008066
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009842
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009809
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:27
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:27
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=30/10/2024 00:00:00
Param Type = c
case_no=2024/177
Param Type = c
trn_rcms_caseregid=16436000008066
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13209000009910 idvalue 0
Mapped case_no Row = 1 value = 2024/196 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 23/10/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 = 10414
trn_rcms_caseregid = 13209000009910
case_no = 2024/196
prev_hearing_date = 09/10/2024
hearing_date = 23/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
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 = 10825000009843
MapName trcmf1
SourceId 10825000009810
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 = 10023000000602
hearing_date = 23/10/2024
case_no = 2024/196
trn_rcms_caseregid = 13209000009910
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009843
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009810
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:29
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:29
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=23/10/2024 00:00:00
Param Type = c
case_no=2024/196
Param Type = c
trn_rcms_caseregid=13209000009910
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12589000008771 idvalue 0
Mapped case_no Row = 1 value = 2024/203 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 23/10/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 = 10414
trn_rcms_caseregid = 12589000008771
case_no = 2024/203
prev_hearing_date = 09/10/2024
hearing_date = 23/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
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 = 10825000009844
MapName trcmf1
SourceId 10825000009811
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 = 10023000000602
hearing_date = 23/10/2024
case_no = 2024/203
trn_rcms_caseregid = 12589000008771
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009844
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009811
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:31
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:31
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=23/10/2024 00:00:00
Param Type = c
case_no=2024/203
Param Type = c
trn_rcms_caseregid=12589000008771
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18593000008568 idvalue 0
Mapped case_no Row = 1 value = 2024/25 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 30/10/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 = 10414
trn_rcms_caseregid = 18593000008568
case_no = 2024/25
prev_hearing_date = 09/10/2024
hearing_date = 30/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 10825000009845
MapName trcmf1
SourceId 10825000009812
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 10023000000602
hearing_date = 30/10/2024
case_no = 2024/25
trn_rcms_caseregid = 18593000008568
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009845
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009812
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:34
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:34
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=10023000000602
Param Type = c
hearing_date=30/10/2024 00:00:00
Param Type = c
case_no=2024/25
Param Type = c
trn_rcms_caseregid=18593000008568
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18429000009717 idvalue 0
Mapped case_no Row = 1 value = 2024/285 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 22/10/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 = 10414
trn_rcms_caseregid = 18429000009717
case_no = 2024/285
prev_hearing_date = 09/10/2024
hearing_date = 22/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 10825000009846
MapName trcmf1
SourceId 10825000009813
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 = 10023000000602
hearing_date = 22/10/2024
case_no = 2024/285
trn_rcms_caseregid = 18429000009717
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009846
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009813
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:36
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:36
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=22/10/2024 00:00:00
Param Type = c
case_no=2024/285
Param Type = c
trn_rcms_caseregid=18429000009717
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10239000008721 idvalue 0
Mapped case_no Row = 1 value = 2024/327 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 30/10/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 = 10414
trn_rcms_caseregid = 10239000008721
case_no = 2024/327
prev_hearing_date = 09/10/2024
hearing_date = 30/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 10825000009847
MapName trcmf1
SourceId 10825000009814
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 10023000000602
hearing_date = 30/10/2024
case_no = 2024/327
trn_rcms_caseregid = 10239000008721
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009847
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009814
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:39
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=30/10/2024 00:00:00
Param Type = c
case_no=2024/327
Param Type = c
trn_rcms_caseregid=10239000008721
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10262000007894 idvalue 0
Mapped case_no Row = 1 value = 2024/328 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 30/10/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 = 10414
trn_rcms_caseregid = 10262000007894
case_no = 2024/328
prev_hearing_date = 09/10/2024
hearing_date = 30/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
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 = 9
RecordId = 10825000009848
MapName trcmf1
SourceId 10825000009815
Select sysdate as sdt from dual
Time elapsed = 9
Select sysdate as sdt from dual
Time elapsed = 8
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 10023000000602
hearing_date = 30/10/2024
case_no = 2024/328
trn_rcms_caseregid = 10262000007894
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009848
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009815
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:41
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=30/10/2024 00:00:00
Param Type = c
case_no=2024/328
Param Type = c
trn_rcms_caseregid=10262000007894
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15316000007932 idvalue 0
Mapped case_no Row = 1 value = 2024/440 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 30/10/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 = 10414
trn_rcms_caseregid = 15316000007932
case_no = 2024/440
prev_hearing_date = 09/10/2024
hearing_date = 30/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
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 = 10825000009849
MapName trcmf1
SourceId 10825000009816
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 7
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 10023000000602
hearing_date = 30/10/2024
case_no = 2024/440
trn_rcms_caseregid = 15316000007932
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009849
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009816
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:44
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=30/10/2024 00:00:00
Param Type = c
case_no=2024/440
Param Type = c
trn_rcms_caseregid=15316000007932
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16241000009127 idvalue 0
Mapped case_no Row = 1 value = 2024/463 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 30/10/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 = 10414
trn_rcms_caseregid = 16241000009127
case_no = 2024/463
prev_hearing_date = 09/10/2024
hearing_date = 30/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 10825000009850
MapName trcmf1
SourceId 10825000009817
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 = 10023000000602
hearing_date = 30/10/2024
case_no = 2024/463
trn_rcms_caseregid = 16241000009127
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009850
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009817
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:46
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:46
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=30/10/2024 00:00:00
Param Type = c
case_no=2024/463
Param Type = c
trn_rcms_caseregid=16241000009127
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16245000008476 idvalue 0
Mapped case_no Row = 1 value = 2024/464 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 30/10/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 = 10414
trn_rcms_caseregid = 16245000008476
case_no = 2024/464
prev_hearing_date = 09/10/2024
hearing_date = 30/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 7
RecordId = 10825000009851
MapName trcmf1
SourceId 10825000009818
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 = 10023000000602
hearing_date = 30/10/2024
case_no = 2024/464
trn_rcms_caseregid = 16245000008476
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009851
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009818
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:49
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:49
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=30/10/2024 00:00:00
Param Type = c
case_no=2024/464
Param Type = c
trn_rcms_caseregid=16245000008476
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16249000009156 idvalue 0
Mapped case_no Row = 1 value = 2024/465 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 30/10/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 = 10414
trn_rcms_caseregid = 16249000009156
case_no = 2024/465
prev_hearing_date = 09/10/2024
hearing_date = 30/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
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 = 10825000009852
MapName trcmf1
SourceId 10825000009819
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 = 10023000000602
hearing_date = 30/10/2024
case_no = 2024/465
trn_rcms_caseregid = 16249000009156
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009852
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009819
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:52
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:52
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=10023000000602
Param Type = c
hearing_date=30/10/2024 00:00:00
Param Type = c
case_no=2024/465
Param Type = c
trn_rcms_caseregid=16249000009156
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17043000010258 idvalue 0
Mapped case_no Row = 1 value = 2024/467 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 21/10/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 = 10414
trn_rcms_caseregid = 17043000010258
case_no = 2024/467
prev_hearing_date = 09/10/2024
hearing_date = 21/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
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 = 10825000009853
MapName trcmf1
SourceId 10825000009820
Select sysdate as sdt from dual
Time elapsed = 210
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 = 10023000000602
hearing_date = 21/10/2024
case_no = 2024/467
trn_rcms_caseregid = 17043000010258
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009853
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009820
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:54
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:54
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=21/10/2024 00:00:00
Param Type = c
case_no=2024/467
Param Type = c
trn_rcms_caseregid=17043000010258
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13669000010577 idvalue 0
Mapped case_no Row = 1 value = 2024/490 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 22/10/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 = 10414
trn_rcms_caseregid = 13669000010577
case_no = 2024/490
prev_hearing_date = 09/10/2024
hearing_date = 22/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 10825000009854
MapName trcmf1
SourceId 10825000009821
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 = 10023000000602
hearing_date = 22/10/2024
case_no = 2024/490
trn_rcms_caseregid = 13669000010577
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009854
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009821
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:57
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:57
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=22/10/2024 00:00:00
Param Type = c
case_no=2024/490
Param Type = c
trn_rcms_caseregid=13669000010577
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13749000008445 idvalue 0
Mapped case_no Row = 1 value = 2024/491 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10023000000602 idvalue 0
Mapped hearing_date Row = 1 value = 22/10/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 = 10414
trn_rcms_caseregid = 13749000008445
case_no = 2024/491
prev_hearing_date = 09/10/2024
hearing_date = 22/10/2024
prev_case_purposename = ??? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10023000000602
case_purpose = 10023000000602
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 = 10825000009855
MapName trcmf1
SourceId 10825000009822
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 = 10023000000602
hearing_date = 22/10/2024
case_no = 2024/491
trn_rcms_caseregid = 13749000008445
court_code = 10414
case_purpose = 10023000000602
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009855
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009822
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:15:59
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:15:59
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=10023000000602
Param Type = c
hearing_date=22/10/2024 00:00:00
Param Type = c
case_no=2024/491
Param Type = c
trn_rcms_caseregid=13749000008445
Param Type = c
court_code=10414
Param Type = c
case_purpose=10023000000602
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13919000007932 idvalue 0
Mapped case_no Row = 1 value = 2023/181 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10119000000827 idvalue 0
Mapped hearing_date Row = 1 value = 06/11/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 = 10414
trn_rcms_caseregid = 13919000007932
case_no = 2023/181
prev_hearing_date = 09/10/2024
hearing_date = 06/11/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 = 10119000000827
case_purpose = 10119000000827
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 14
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 18
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 = 10825000009856
MapName trcmf1
SourceId 10825000009823
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 = 10119000000827
hearing_date = 06/11/2024
case_no = 2023/181
trn_rcms_caseregid = 13919000007932
court_code = 10414
case_purpose = 10119000000827
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009856
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009823
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:16:02
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:16: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=10119000000827
Param Type = c
hearing_date=06/11/2024 00:00:00
Param Type = c
case_no=2023/181
Param Type = c
trn_rcms_caseregid=13919000007932
Param Type = c
court_code=10414
Param Type = c
case_purpose=10119000000827
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10483000007321 idvalue 0
Mapped case_no Row = 1 value = 2023/417 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ?????? idvalue 0
Mapped case_purpose Row = 1 value = 10119000000827 idvalue 0
Mapped hearing_date Row = 1 value = 28/10/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 = 10414
trn_rcms_caseregid = 10483000007321
case_no = 2023/417
prev_hearing_date = 09/10/2024
hearing_date = 28/10/2024
prev_case_purposename = ?????? ??????
prev_case_purpose = 
prev_case_purpose after validation = 10119000000827
case_purpose = 10119000000827
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 10825000009857
MapName trcmf1
SourceId 10825000009824
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 = 10119000000827
hearing_date = 28/10/2024
case_no = 2023/417
trn_rcms_caseregid = 10483000007321
court_code = 10414
case_purpose = 10119000000827
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009857
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009824
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:16:04
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:16: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=10119000000827
Param Type = c
hearing_date=28/10/2024 00:00:00
Param Type = c
case_no=2023/417
Param Type = c
trn_rcms_caseregid=10483000007321
Param Type = c
court_code=10414
Param Type = c
case_purpose=10119000000827
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15877000005664 idvalue 0
Mapped case_no Row = 1 value = 2022/174 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 23/10/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 = 10414
trn_rcms_caseregid = 15877000005664
case_no = 2022/174
prev_hearing_date = 09/10/2024
hearing_date = 23/10/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

Time elapsed = 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 = 4
RecordId = 10825000009858
MapName trcmf1
SourceId 10825000009825
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 = 18678000000000
hearing_date = 23/10/2024
case_no = 2022/174
trn_rcms_caseregid = 15877000005664
court_code = 10414
case_purpose = 18678000000000
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009858
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009825
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:16:06
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:16:06
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=23/10/2024 00:00:00
Param Type = c
case_no=2022/174
Param Type = c
trn_rcms_caseregid=15877000005664
Param Type = c
court_code=10414
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12581000007795 idvalue 0
Mapped case_no Row = 1 value = 2023/451 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 09/12/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 = 10414
trn_rcms_caseregid = 12581000007795
case_no = 2023/451
prev_hearing_date = 09/10/2024
hearing_date = 09/12/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 6
RecordId = 10825000009859
MapName trcmf1
SourceId 10825000009826
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 09/12/2024
case_no = 2023/451
trn_rcms_caseregid = 12581000007795
court_code = 10414
case_purpose = 18678000000000
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009859
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009826
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:16:09
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:16:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/12/2024 00:00:00
Param Type = c
case_no=2023/451
Param Type = c
trn_rcms_caseregid=12581000007795
Param Type = c
court_code=10414
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16643000009462 idvalue 0
Mapped case_no Row = 1 value = 2024/166 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/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 = 10/12/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 = 10414
trn_rcms_caseregid = 16643000009462
case_no = 2024/166
prev_hearing_date = 09/10/2024
hearing_date = 10/12/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
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 = 10825000009860
MapName trcmf1
SourceId 10825000009827
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 10/12/2024
case_no = 2024/166
trn_rcms_caseregid = 16643000009462
court_code = 10414
case_purpose = 18473000000000
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009860
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009827
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:16:11
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:16:11
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=10/12/2024 00:00:00
Param Type = c
case_no=2024/166
Param Type = c
trn_rcms_caseregid=16643000009462
Param Type = c
court_code=10414
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15127000007405 idvalue 0
Mapped case_no Row = 1 value = 2024/408 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/10/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 = 10414
trn_rcms_caseregid = 15127000007405
case_no = 2024/408
prev_hearing_date = 09/10/2024
hearing_date = 30/10/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 10825000009861
MapName trcmf1
SourceId 10825000009828
Select sysdate as sdt from dual
Time elapsed = 10
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 30/10/2024
case_no = 2024/408
trn_rcms_caseregid = 15127000007405
court_code = 10414
case_purpose = 18678000000000
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009861
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009828
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:16:14
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:16:14
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=30/10/2024 00:00:00
Param Type = c
case_no=2024/408
Param Type = c
trn_rcms_caseregid=15127000007405
Param Type = c
court_code=10414
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=09/10/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 = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15128000008975 idvalue 0
Mapped case_no Row = 1 value = 2024/409 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/10/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 = 10414
trn_rcms_caseregid = 15128000008975
case_no = 2024/409
prev_hearing_date = 09/10/2024
hearing_date = 30/10/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 10825000009862
MapName trcmf1
SourceId 10825000009829
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 30/10/2024
case_no = 2024/409
trn_rcms_caseregid = 15128000008975
court_code = 10414
case_purpose = 18678000000000
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009862
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009829
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:16:16
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:16:16
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=30/10/2024 00:00:00
Param Type = c
case_no=2024/409
Param Type = c
trn_rcms_caseregid=15128000008975
Param Type = c
court_code=10414
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=09/10/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 33

>>Mapping
Mapped court_code Row = 1 value = 10414 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15129000008497 idvalue 0
Mapped case_no Row = 1 value = 2024/410 idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/10/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 18678000000000 idvalue 0
Mapped hearing_date Row = 1 value = 30/10/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 = 10414
trn_rcms_caseregid = 15129000008497
case_no = 2024/410
prev_hearing_date = 09/10/2024
hearing_date = 30/10/2024
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purpose after validation = 18678000000000
case_purpose = 18678000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 10825000009863
MapName trcmf1
SourceId 10825000009830
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
hearing_date = 30/10/2024
case_no = 2024/410
trn_rcms_caseregid = 15129000008497
court_code = 10414
case_purpose = 18678000000000
prev_hearing_date = 09/10/2024
Posting record
Param Type = n
trn_rcms_case_histid=10825000009863
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=10825000009830
Param Type = c
cancel=F
Param Type = c
createdby=dcjai
Param Type = c
createdon=17/10/2024 11:16:19
Param Type = c
username=dcjai
Param Type = c
modifiedon=17/10/2024 11:16:19
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=30/10/2024 00:00:00
Param Type = c
case_no=2024/410
Param Type = c
trn_rcms_caseregid=15129000008497
Param Type = c
court_code=10414
Param Type = c
case_purpose=18678000000000
Param Type = c
prev_hearing_date=09/10/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 = 3938325380879
Time elapsed for MD Map = 3938325380880
Time elapsed for Save History = 3938325380882
Time elapsed for Save Attachment = 3938325380884
Time elapsed for After Save WF Exec = 3938325380899
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"10825000009797"}]}
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=dcjai
Param Type = c
calledon=17/10/2024 11:14:54
Param Type = c
callfinished=17/10/2024 11:16:20
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=86572
Param Type = n
dbtimetaken=82707
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