ASB XE3/32/64 DLL running
[Compiled on 05/06/2018 1:03:04 PM] [File Version : 1.0.0.0]] [Product Version : 1.0.0.0][]
DB Manager created
<transaction username="SDO_Chauhtan" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>SDO_Chauhtan</username><password>827ccb0eea8a706c4c34a16891f84e7b</password><seed></seed><s></s><transid>trcmf</transid><recordid>0</recordid><recdata></recdata><data transid="trcmf" recordid="0"><axp_recid1 rowno="001">0</axp_recid1><courtcode rowno="001">10519</courtcode><hearing_date rowno="001">04/10/2023</hearing_date><axp_recid2 rowno="001">0</axp_recid2><court_code rowno="001">10519</court_code><case_no rowno="001">2022/142</case_no><trn_rcms_caseid rowno="001">18324000006573</trn_rcms_caseid><pre_case_purpose_name rowno="001">?????</pre_case_purpose_name><pre_hear_date rowno="001">04/10/2023</pre_hear_date><pre_case_purpose rowno="001">1000492</pre_case_purpose><next_hear_date rowno="001">18/12/2023</next_hear_date><new_case_purpose rowno="001">1000492</new_case_purpose><isadjourn rowno="001">NO</isadjourn><adjourn_type rowno="001">0</adjourn_type><adjourn_remark rowno="001"></adjourn_remark><axp_recid2 rowno="002">0</axp_recid2><court_code rowno="002">10519</court_code><case_no rowno="002">2022/250</case_no><trn_rcms_caseid rowno="002">11926000007161</trn_rcms_caseid><pre_case_purpose_name rowno="002">?????</pre_case_purpose_name><pre_hear_date rowno="002">04/10/2023</pre_hear_date><pre_case_purpose rowno="002">1000492</pre_case_purpose><next_hear_date rowno="002">07/11/2023</next_hear_date><new_case_purpose rowno="002">1000492</new_case_purpose><isadjourn rowno="002">NO</isadjourn><adjourn_type rowno="002">0</adjourn_type><adjourn_remark rowno="002"></adjourn_remark><axp_recid2 rowno="003">0</axp_recid2><court_code rowno="003">10519</court_code><case_no rowno="003">2023/153</case_no><trn_rcms_caseid rowno="003">14854000007250</trn_rcms_caseid><pre_case_purpose_name rowno="003">?????</pre_case_purpose_name><pre_hear_date rowno="003">04/10/2023</pre_hear_date><pre_case_purpose rowno="003">1000492</pre_case_purpose><next_hear_date rowno="003">27/01/2024</next_hear_date><new_case_purpose rowno="003">1000492</new_case_purpose><isadjourn rowno="003">NO</isadjourn><adjourn_type rowno="003">0</adjourn_type><adjourn_remark rowno="003"></adjourn_remark><axp_recid2 rowno="004">0</axp_recid2><court_code rowno="004">10519</court_code><case_no rowno="004">2023/154</case_no><trn_rcms_caseid rowno="004">15005000007175</trn_rcms_caseid><pre_case_purpose_name rowno="004">?????</pre_case_purpose_name><pre_hear_date rowno="004">04/10/2023</pre_hear_date><pre_case_purpose rowno="004">1000492</pre_case_purpose><next_hear_date rowno="004">27/01/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">10519</court_code><case_no rowno="005">2023/171</case_no><trn_rcms_caseid rowno="005">18178000008055</trn_rcms_caseid><pre_case_purpose_name rowno="005">?????</pre_case_purpose_name><pre_hear_date rowno="005">04/10/2023</pre_hear_date><pre_case_purpose rowno="005">1000492</pre_case_purpose><next_hear_date rowno="005">18/12/2023</next_hear_date><new_case_purpose rowno="005">1000492</new_case_purpose><isadjourn rowno="005">NO</isadjourn><adjourn_type rowno="005">0</adjourn_type><adjourn_remark rowno="005"></adjourn_remark><axp_recid2 rowno="006">0</axp_recid2><court_code rowno="006">10519</court_code><case_no rowno="006">2023/174</case_no><trn_rcms_caseid rowno="006">19184000006989</trn_rcms_caseid><pre_case_purpose_name rowno="006">?????</pre_case_purpose_name><pre_hear_date rowno="006">04/10/2023</pre_hear_date><pre_case_purpose rowno="006">1000492</pre_case_purpose><next_hear_date rowno="006">16/11/2023</next_hear_date><new_case_purpose rowno="006">1000492</new_case_purpose><isadjourn rowno="006">NO</isadjourn><adjourn_type rowno="006">0</adjourn_type><adjourn_remark rowno="006"></adjourn_remark><axp_recid2 rowno="007">0</axp_recid2><court_code rowno="007">10519</court_code><case_no rowno="007">2023/175</case_no><trn_rcms_caseid rowno="007">19197000006423</trn_rcms_caseid><pre_case_purpose_name rowno="007">?????</pre_case_purpose_name><pre_hear_date rowno="007">04/10/2023</pre_hear_date><pre_case_purpose rowno="007">1000492</pre_case_purpose><next_hear_date rowno="007">16/11/2023</next_hear_date><new_case_purpose rowno="007">1000492</new_case_purpose><isadjourn rowno="007">NO</isadjourn><adjourn_type rowno="007">0</adjourn_type><adjourn_remark rowno="007"></adjourn_remark><axp_recid2 rowno="008">0</axp_recid2><court_code rowno="008">10519</court_code><case_no rowno="008">2023/176</case_no><trn_rcms_caseid rowno="008">19223000008660</trn_rcms_caseid><pre_case_purpose_name rowno="008">?????</pre_case_purpose_name><pre_hear_date rowno="008">04/10/2023</pre_hear_date><pre_case_purpose rowno="008">1000492</pre_case_purpose><next_hear_date rowno="008">18/12/2023</next_hear_date><new_case_purpose rowno="008">1000492</new_case_purpose><isadjourn rowno="008">NO</isadjourn><adjourn_type rowno="008">0</adjourn_type><adjourn_remark rowno="008"></adjourn_remark><axp_recid2 rowno="009">0</axp_recid2><court_code rowno="009">10519</court_code><case_no rowno="009">2023/178</case_no><trn_rcms_caseid rowno="009">13058000008658</trn_rcms_caseid><pre_case_purpose_name rowno="009">?????</pre_case_purpose_name><pre_hear_date rowno="009">04/10/2023</pre_hear_date><pre_case_purpose rowno="009">1000492</pre_case_purpose><next_hear_date rowno="009">18/12/2023</next_hear_date><new_case_purpose rowno="009">1000492</new_case_purpose><isadjourn rowno="009">NO</isadjourn><adjourn_type rowno="009">0</adjourn_type><adjourn_remark rowno="009"></adjourn_remark><axp_recid2 rowno="0010">0</axp_recid2><court_code rowno="0010">10519</court_code><case_no rowno="0010">2023/23</case_no><trn_rcms_caseid rowno="0010">12472000006731</trn_rcms_caseid><pre_case_purpose_name rowno="0010">?????</pre_case_purpose_name><pre_hear_date rowno="0010">04/10/2023</pre_hear_date><pre_case_purpose rowno="0010">1000492</pre_case_purpose><next_hear_date rowno="0010">20/10/2023</next_hear_date><new_case_purpose rowno="0010">1000492</new_case_purpose><isadjourn rowno="0010">NO</isadjourn><adjourn_type rowno="0010">0</adjourn_type><adjourn_remark rowno="0010"></adjourn_remark><axp_recid2 rowno="0011">0</axp_recid2><court_code rowno="0011">10519</court_code><case_no rowno="0011">2023/26</case_no><trn_rcms_caseid rowno="0011">12623000007967</trn_rcms_caseid><pre_case_purpose_name rowno="0011">?????</pre_case_purpose_name><pre_hear_date rowno="0011">04/10/2023</pre_hear_date><pre_case_purpose rowno="0011">1000492</pre_case_purpose><next_hear_date rowno="0011">18/12/2023</next_hear_date><new_case_purpose rowno="0011">1000492</new_case_purpose><isadjourn rowno="0011">NO</isadjourn><adjourn_type rowno="0011">0</adjourn_type><adjourn_remark rowno="0011"></adjourn_remark><axp_recid2 rowno="0012">0</axp_recid2><court_code rowno="0012">10519</court_code><case_no rowno="0012">2023/27</case_no><trn_rcms_caseid rowno="0012">12666000008331</trn_rcms_caseid><pre_case_purpose_name rowno="0012">?????</pre_case_purpose_name><pre_hear_date rowno="0012">04/10/2023</pre_hear_date><pre_case_purpose rowno="0012">1000492</pre_case_purpose><next_hear_date rowno="0012">07/11/2023</next_hear_date><new_case_purpose rowno="0012">1000492</new_case_purpose><isadjourn rowno="0012">NO</isadjourn><adjourn_type rowno="0012">0</adjourn_type><adjourn_remark rowno="0012"></adjourn_remark><axp_recid2 rowno="0013">0</axp_recid2><court_code rowno="0013">10519</court_code><case_no rowno="0013">2023/69</case_no><trn_rcms_caseid rowno="0013">10128000006434</trn_rcms_caseid><pre_case_purpose_name rowno="0013">?????</pre_case_purpose_name><pre_hear_date rowno="0013">04/10/2023</pre_hear_date><pre_case_purpose rowno="0013">1000492</pre_case_purpose><next_hear_date rowno="0013">07/11/2023</next_hear_date><new_case_purpose rowno="0013">1000492</new_case_purpose><isadjourn rowno="0013">NO</isadjourn><adjourn_type rowno="0013">0</adjourn_type><adjourn_remark rowno="0013"></adjourn_remark><axp_recid2 rowno="0014">0</axp_recid2><court_code rowno="0014">10519</court_code><case_no rowno="0014">2023/70</case_no><trn_rcms_caseid rowno="0014">10166000007365</trn_rcms_caseid><pre_case_purpose_name rowno="0014">?????</pre_case_purpose_name><pre_hear_date rowno="0014">04/10/2023</pre_hear_date><pre_case_purpose rowno="0014">1000492</pre_case_purpose><next_hear_date rowno="0014">07/11/2023</next_hear_date><new_case_purpose rowno="0014">1000492</new_case_purpose><isadjourn rowno="0014">NO</isadjourn><adjourn_type rowno="0014">0</adjourn_type><adjourn_remark rowno="0014"></adjourn_remark><axp_recid2 rowno="0015">0</axp_recid2><court_code rowno="0015">10519</court_code><case_no rowno="0015">2023/78</case_no><trn_rcms_caseid rowno="0015">11939000007667</trn_rcms_caseid><pre_case_purpose_name rowno="0015">?????</pre_case_purpose_name><pre_hear_date rowno="0015">04/10/2023</pre_hear_date><pre_case_purpose rowno="0015">1000492</pre_case_purpose><next_hear_date rowno="0015">07/11/2023</next_hear_date><new_case_purpose rowno="0015">1000492</new_case_purpose><isadjourn rowno="0015">NO</isadjourn><adjourn_type rowno="0015">0</adjourn_type><adjourn_remark rowno="0015"></adjourn_remark><axp_recid2 rowno="0016">0</axp_recid2><court_code rowno="0016">10519</court_code><case_no rowno="0016">2023/91</case_no><trn_rcms_caseid rowno="0016">10885000007477</trn_rcms_caseid><pre_case_purpose_name rowno="0016">?????</pre_case_purpose_name><pre_hear_date rowno="0016">04/10/2023</pre_hear_date><pre_case_purpose rowno="0016">1000492</pre_case_purpose><next_hear_date rowno="0016">07/11/2023</next_hear_date><new_case_purpose rowno="0016">1000492</new_case_purpose><isadjourn rowno="0016">NO</isadjourn><adjourn_type rowno="0016">0</adjourn_type><adjourn_remark rowno="0016"></adjourn_remark><axp_recid2 rowno="0017">0</axp_recid2><court_code rowno="0017">10519</court_code><case_no rowno="0017">2019/00127</case_no><trn_rcms_caseid rowno="0017">17292000003284</trn_rcms_caseid><pre_case_purpose_name rowno="0017">???</pre_case_purpose_name><pre_hear_date rowno="0017">04/10/2023</pre_hear_date><pre_case_purpose rowno="0017">18473000000000</pre_case_purpose><next_hear_date rowno="0017">07/11/2023</next_hear_date><new_case_purpose rowno="0017">18473000000000</new_case_purpose><isadjourn rowno="0017">NO</isadjourn><adjourn_type rowno="0017">0</adjourn_type><adjourn_remark rowno="0017"></adjourn_remark><axp_recid2 rowno="0018">0</axp_recid2><court_code rowno="0018">10519</court_code><case_no rowno="0018">2019/00133</case_no><trn_rcms_caseid rowno="0018">18401000003120</trn_rcms_caseid><pre_case_purpose_name rowno="0018">???</pre_case_purpose_name><pre_hear_date rowno="0018">04/10/2023</pre_hear_date><pre_case_purpose rowno="0018">18473000000000</pre_case_purpose><next_hear_date rowno="0018">07/11/2023</next_hear_date><new_case_purpose rowno="0018">18473000000000</new_case_purpose><isadjourn rowno="0018">NO</isadjourn><adjourn_type rowno="0018">0</adjourn_type><adjourn_remark rowno="0018"></adjourn_remark><axp_recid2 rowno="0019">0</axp_recid2><court_code rowno="0019">10519</court_code><case_no rowno="0019">2019/00134</case_no><trn_rcms_caseid rowno="0019">18471000003276</trn_rcms_caseid><pre_case_purpose_name rowno="0019">???</pre_case_purpose_name><pre_hear_date rowno="0019">04/10/2023</pre_hear_date><pre_case_purpose rowno="0019">18473000000000</pre_case_purpose><next_hear_date rowno="0019">07/11/2023</next_hear_date><new_case_purpose rowno="0019">18473000000000</new_case_purpose><isadjourn rowno="0019">NO</isadjourn><adjourn_type rowno="0019">0</adjourn_type><adjourn_remark rowno="0019"></adjourn_remark><axp_recid2 rowno="0020">0</axp_recid2><court_code rowno="0020">10519</court_code><case_no rowno="0020">2021/221</case_no><trn_rcms_caseid rowno="0020">13251000005770</trn_rcms_caseid><pre_case_purpose_name rowno="0020">???</pre_case_purpose_name><pre_hear_date rowno="0020">04/10/2023</pre_hear_date><pre_case_purpose rowno="0020">18473000000000</pre_case_purpose><next_hear_date rowno="0020">27/01/2024</next_hear_date><new_case_purpose rowno="0020">18473000000000</new_case_purpose><isadjourn rowno="0020">NO</isadjourn><adjourn_type rowno="0020">0</adjourn_type><adjourn_remark rowno="0020"></adjourn_remark><axp_recid2 rowno="0021">0</axp_recid2><court_code rowno="0021">10519</court_code><case_no rowno="0021">2022/95</case_no><trn_rcms_caseid rowno="0021">16385000006129</trn_rcms_caseid><pre_case_purpose_name rowno="0021">???</pre_case_purpose_name><pre_hear_date rowno="0021">04/10/2023</pre_hear_date><pre_case_purpose rowno="0021">18473000000000</pre_case_purpose><next_hear_date rowno="0021">18/12/2023</next_hear_date><new_case_purpose rowno="0021">18473000000000</new_case_purpose><isadjourn rowno="0021">NO</isadjourn><adjourn_type rowno="0021">0</adjourn_type><adjourn_remark rowno="0021"></adjourn_remark><axp_recid2 rowno="0022">0</axp_recid2><court_code rowno="0022">10519</court_code><case_no rowno="0022">2022/234</case_no><trn_rcms_caseid rowno="0022">10367000007821</trn_rcms_caseid><pre_case_purpose_name rowno="0022">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="0022">04/10/2023</pre_hear_date><pre_case_purpose rowno="0022">1000497</pre_case_purpose><next_hear_date rowno="0022">12/10/2023</next_hear_date><new_case_purpose rowno="0022">1000497</new_case_purpose><isadjourn rowno="0022">NO</isadjourn><adjourn_type rowno="0022">0</adjourn_type><adjourn_remark rowno="0022"></adjourn_remark><axp_recid2 rowno="0023">0</axp_recid2><court_code rowno="0023">10519</court_code><case_no rowno="0023">2022/235</case_no><trn_rcms_caseid rowno="0023">10374000008091</trn_rcms_caseid><pre_case_purpose_name rowno="0023">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="0023">04/10/2023</pre_hear_date><pre_case_purpose rowno="0023">1000497</pre_case_purpose><next_hear_date rowno="0023">12/10/2023</next_hear_date><new_case_purpose rowno="0023">1000497</new_case_purpose><isadjourn rowno="0023">NO</isadjourn><adjourn_type rowno="0023">0</adjourn_type><adjourn_remark rowno="0023"></adjourn_remark><axp_recid2 rowno="0024">0</axp_recid2><court_code rowno="0024">10519</court_code><case_no rowno="0024">2022/69</case_no><trn_rcms_caseid rowno="0024">10141000006705</trn_rcms_caseid><pre_case_purpose_name rowno="0024">???? ?????????</pre_case_purpose_name><pre_hear_date rowno="0024">04/10/2023</pre_hear_date><pre_case_purpose rowno="0024">1000497</pre_case_purpose><next_hear_date rowno="0024">07/11/2023</next_hear_date><new_case_purpose rowno="0024">1000497</new_case_purpose><isadjourn rowno="0024">NO</isadjourn><adjourn_type rowno="0024">0</adjourn_type><adjourn_remark rowno="0024"></adjourn_remark></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"SDO_Chauhtan","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"trcmf","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtcode":"10519","hearing_date":"04/10/2023"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"court_code":"10519","case_no":"2022/142","trn_rcms_caseid":"18324000006573","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"18/12/2023","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"002","text":"0","columns":{"court_code":"10519","case_no":"2022/250","trn_rcms_caseid":"11926000007161","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"07/11/2023","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"003","text":"0","columns":{"court_code":"10519","case_no":"2023/153","trn_rcms_caseid":"14854000007250","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"27/01/2024","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"004","text":"0","columns":{"court_code":"10519","case_no":"2023/154","trn_rcms_caseid":"15005000007175","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"27/01/2024","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"005","text":"0","columns":{"court_code":"10519","case_no":"2023/171","trn_rcms_caseid":"18178000008055","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"18/12/2023","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"006","text":"0","columns":{"court_code":"10519","case_no":"2023/174","trn_rcms_caseid":"19184000006989","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"16/11/2023","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"007","text":"0","columns":{"court_code":"10519","case_no":"2023/175","trn_rcms_caseid":"19197000006423","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"16/11/2023","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"008","text":"0","columns":{"court_code":"10519","case_no":"2023/176","trn_rcms_caseid":"19223000008660","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"18/12/2023","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"009","text":"0","columns":{"court_code":"10519","case_no":"2023/178","trn_rcms_caseid":"13058000008658","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"18/12/2023","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0010","text":"0","columns":{"court_code":"10519","case_no":"2023/23","trn_rcms_caseid":"12472000006731","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"20/10/2023","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0011","text":"0","columns":{"court_code":"10519","case_no":"2023/26","trn_rcms_caseid":"12623000007967","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"18/12/2023","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0012","text":"0","columns":{"court_code":"10519","case_no":"2023/27","trn_rcms_caseid":"12666000008331","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"07/11/2023","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0013","text":"0","columns":{"court_code":"10519","case_no":"2023/69","trn_rcms_caseid":"10128000006434","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"07/11/2023","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0014","text":"0","columns":{"court_code":"10519","case_no":"2023/70","trn_rcms_caseid":"10166000007365","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"07/11/2023","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0015","text":"0","columns":{"court_code":"10519","case_no":"2023/78","trn_rcms_caseid":"11939000007667","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"07/11/2023","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0016","text":"0","columns":{"court_code":"10519","case_no":"2023/91","trn_rcms_caseid":"10885000007477","pre_case_purpose_name":"?????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000492","next_hear_date":"07/11/2023","new_case_purpose":"1000492","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0017","text":"0","columns":{"court_code":"10519","case_no":"2019/00127","trn_rcms_caseid":"17292000003284","pre_case_purpose_name":"???","pre_hear_date":"04/10/2023","pre_case_purpose":"18473000000000","next_hear_date":"07/11/2023","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0018","text":"0","columns":{"court_code":"10519","case_no":"2019/00133","trn_rcms_caseid":"18401000003120","pre_case_purpose_name":"???","pre_hear_date":"04/10/2023","pre_case_purpose":"18473000000000","next_hear_date":"07/11/2023","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0019","text":"0","columns":{"court_code":"10519","case_no":"2019/00134","trn_rcms_caseid":"18471000003276","pre_case_purpose_name":"???","pre_hear_date":"04/10/2023","pre_case_purpose":"18473000000000","next_hear_date":"07/11/2023","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0020","text":"0","columns":{"court_code":"10519","case_no":"2021/221","trn_rcms_caseid":"13251000005770","pre_case_purpose_name":"???","pre_hear_date":"04/10/2023","pre_case_purpose":"18473000000000","next_hear_date":"27/01/2024","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0021","text":"0","columns":{"court_code":"10519","case_no":"2022/95","trn_rcms_caseid":"16385000006129","pre_case_purpose_name":"???","pre_hear_date":"04/10/2023","pre_case_purpose":"18473000000000","next_hear_date":"18/12/2023","new_case_purpose":"18473000000000","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0022","text":"0","columns":{"court_code":"10519","case_no":"2022/234","trn_rcms_caseid":"10367000007821","pre_case_purpose_name":"???? ?????????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000497","next_hear_date":"12/10/2023","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0023","text":"0","columns":{"court_code":"10519","case_no":"2022/235","trn_rcms_caseid":"10374000008091","pre_case_purpose_name":"???? ?????????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000497","next_hear_date":"12/10/2023","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}},{"rowno":"0024","text":"0","columns":{"court_code":"10519","case_no":"2022/69","trn_rcms_caseid":"10141000006705","pre_case_purpose_name":"???? ?????????","pre_hear_date":"04/10/2023","pre_case_purpose":"1000497","next_hear_date":"07/11/2023","new_case_purpose":"1000497","isadjourn":"NO","adjourn_type":"0","adjourn_remark":""}}]}]}}
Verifying username and password
User Name : SDO_Chauhtan
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=sdo_chauhtan
Time elapsed = 16
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 7
Result : 
Verifying completed...
Page Access Category : 
User Name : sdo_chauhtan
Select sysdate as sdt from dual
Time elapsed = 6
dt=05/10/2023 15:08:20
Select sysdate as sdt from dual
Time elapsed = 5
Select usergroup from AXUSERLEVELGROUPS WHERE (lower(username) =:U) and ((startdate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') >= startdate) or (startdate is null)) and ((enddate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') <= enddate) or (enddate is null))
U=sdo_chauhtan
dt=05/10/2023 15:08:20
dt=05/10/2023 15:08:20
Time elapsed = 12
User Groups: court_reader
select userroles from axusergroups where groupname in ( 'court_reader' )
Time elapsed = 5
User Roles : court_reader
Loading App/User vars
reading the props xml
Step3
Sql : select props from axprops where lower(name)= :name  order by blobno

Paramval : app
ParamTYpe : c
Param List : name

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

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

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

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

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

Time elapsed = 3
Reading data from stream

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

Paramval : trcmf
ParamTYpe : c
Param List : name

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

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

Paramval : tchdh
ParamTYpe : c
Param List : name

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

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

>>Validating trcmf

>>Frame No 1
courtcode = 10519
hearing_date = 04/10/2023
time zone difference  = 0

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

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

Time elapsed = 3
RecordId = 17302000007956
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
hearing_date = 04/10/2023
courtcode = 10519
Posting record
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:20
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
hearing_date=04/10/2023 00:00:00
Param Type = c
courtcode=10519
insert into TRN_RCMS_MHEARING (trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,hearing_date,courtcode) values (:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:courtcode)

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

Time elapsed = 3
RecordId = 17302000007957
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 04/10/2023
pre_case_purpose = 1000492
trn_rcms_caseid = 18324000006573
court_code = 10519
case_no = 2022/142
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 18/12/2023
TRN_RCMS_HEARINGrow = 1
Posting record
Param Type = n
trn_rcms_hearingid=17302000007957
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:20
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=18324000006573
Param Type = c
court_code=10519
Param Type = c
case_no=2022/142
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=18/12/2023 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,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 2 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 17302000007958
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
pre_hear_date = 04/10/2023
pre_case_purpose = 1000492
trn_rcms_caseid = 11926000007161
court_code = 10519
case_no = 2022/250
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 07/11/2023
TRN_RCMS_HEARINGrow = 2
Posting record
Param Type = n
trn_rcms_hearingid=17302000007958
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:20
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=11926000007161
Param Type = c
court_code=10519
Param Type = c
case_no=2022/250
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=07/11/2023 00:00:00
Param Type = n
trn_rcms_hearingrow=2
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 3 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 17302000007959
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
pre_hear_date = 04/10/2023
pre_case_purpose = 1000492
trn_rcms_caseid = 14854000007250
court_code = 10519
case_no = 2023/153
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
new_case_purpose = 1000492
next_hear_date = 27/01/2024
TRN_RCMS_HEARINGrow = 3
Posting record
Param Type = n
trn_rcms_hearingid=17302000007959
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:20
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:20
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=14854000007250
Param Type = c
court_code=10519
Param Type = c
case_no=2023/153
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=27/01/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 = 3
RecordId = 17302000007960
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 27/01/2024
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2023/154
court_code = 10519
trn_rcms_caseid = 15005000007175
pre_case_purpose = 1000492
pre_hear_date = 04/10/2023
TRN_RCMS_HEARINGrow = 4
Posting record
Param Type = n
trn_rcms_hearingid=17302000007960
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=27/01/2024 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/154
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=15005000007175
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=04/10/2023 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 = 3
RecordId = 17302000007961
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 18/12/2023
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2023/171
court_code = 10519
trn_rcms_caseid = 18178000008055
pre_case_purpose = 1000492
pre_hear_date = 04/10/2023
TRN_RCMS_HEARINGrow = 5
Posting record
Param Type = n
trn_rcms_hearingid=17302000007961
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=18/12/2023 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/171
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=18178000008055
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = n
trn_rcms_hearingrow=5
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_case_purpose,isadjourn,adjourn_remark,adjourn_type,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:isadjourn,null,:adjourn_type,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 17302000007962
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
pre_case_purpose = 1000492
new_case_purpose = 1000492
next_hear_date = 16/11/2023
pre_hear_date = 04/10/2023
court_code = 10519
case_no = 2023/174
trn_rcms_caseid = 19184000006989
adjourn_remark = 
adjourn_type = 0
isadjourn = NO
TRN_RCMS_HEARINGrow = 6
Posting record
Param Type = n
trn_rcms_hearingid=17302000007962
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=16/11/2023 00:00:00
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = c
court_code=10519
Param Type = c
case_no=2023/174
Param Type = c
trn_rcms_caseid=19184000006989
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
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,pre_case_purpose,new_case_purpose,next_hear_date,pre_hear_date,court_code,case_no,trn_rcms_caseid,adjourn_remark,adjourn_type,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,:pre_case_purpose,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_rcms_caseid,null,:adjourn_type,:isadjourn,: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 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 17302000007963
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trn_rcms_caseid = 19197000006423
pre_hear_date = 04/10/2023
new_case_purpose = 1000492
pre_case_purpose = 1000492
court_code = 10519
case_no = 2023/175
adjourn_remark = 
next_hear_date = 16/11/2023
isadjourn = NO
adjourn_type = 0
TRN_RCMS_HEARINGrow = 7
Posting record
Param Type = n
trn_rcms_hearingid=17302000007963
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=19197000006423
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
court_code=10519
Param Type = c
case_no=2023/175
Param Type = c
next_hear_date=16/11/2023 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
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,trn_rcms_caseid,pre_hear_date,new_case_purpose,pre_case_purpose,court_code,case_no,adjourn_remark,next_hear_date,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,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:pre_case_purpose,:court_code,:case_no,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:adjourn_type,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 17302000007964
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
new_case_purpose = 1000492
isadjourn = NO
next_hear_date = 18/12/2023
pre_case_purpose = 1000492
case_no = 2023/176
court_code = 10519
pre_hear_date = 04/10/2023
trn_rcms_caseid = 19223000008660
adjourn_remark = 
adjourn_type = 0
TRN_RCMS_HEARINGrow = 8
Posting record
Param Type = n
trn_rcms_hearingid=17302000007964
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=18/12/2023 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
case_no=2023/176
Param Type = c
court_code=10519
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = c
trn_rcms_caseid=19223000008660
Param Type = c
adjourn_type=0
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,new_case_purpose,isadjourn,next_hear_date,pre_case_purpose,case_no,court_code,pre_hear_date,trn_rcms_caseid,adjourn_remark,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,: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,null,:adjourn_type,:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 17302000007965
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2023/178
new_case_purpose = 1000492
pre_case_purpose = 1000492
trn_rcms_caseid = 13058000008658
pre_hear_date = 04/10/2023
adjourn_remark = 
court_code = 10519
adjourn_type = 0
next_hear_date = 18/12/2023
isadjourn = NO
TRN_RCMS_HEARINGrow = 9
Posting record
Param Type = n
trn_rcms_hearingid=17302000007965
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/178
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
trn_rcms_caseid=13058000008658
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = c
court_code=10519
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=18/12/2023 00:00:00
Param Type = c
isadjourn=NO
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,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 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 17302000007966
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
next_hear_date = 20/10/2023
new_case_purpose = 1000492
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
case_no = 2023/23
court_code = 10519
trn_rcms_caseid = 12472000006731
pre_case_purpose = 1000492
pre_hear_date = 04/10/2023
TRN_RCMS_HEARINGrow = 10
Posting record
Param Type = n
trn_rcms_hearingid=17302000007966
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=20/10/2023 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/23
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=12472000006731
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=04/10/2023 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,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 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 17302000007967
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 18/12/2023
isadjourn = NO
new_case_purpose = 1000492
pre_case_purpose = 1000492
pre_hear_date = 04/10/2023
case_no = 2023/26
court_code = 10519
trn_rcms_caseid = 12623000007967
adjourn_type = 0
adjourn_remark = 
TRN_RCMS_HEARINGrow = 11
Posting record
Param Type = n
trn_rcms_hearingid=17302000007967
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=18/12/2023 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
new_case_purpose=1000492
Param Type = n
pre_case_purpose=1000492
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = c
case_no=2023/26
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=12623000007967
Param Type = c
adjourn_type=0
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,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 = 4
Adding new record to store data from Frame 2, Row 12 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 17302000007968
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
adjourn_type = 0
case_no = 2023/27
court_code = 10519
isadjourn = NO
next_hear_date = 07/11/2023
pre_case_purpose = 1000492
new_case_purpose = 1000492
pre_hear_date = 04/10/2023
adjourn_remark = 
trn_rcms_caseid = 12666000008331
TRN_RCMS_HEARINGrow = 12
Posting record
Param Type = n
trn_rcms_hearingid=17302000007968
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
case_no=2023/27
Param Type = c
court_code=10519
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=07/11/2023 00:00:00
Param Type = n
pre_case_purpose=1000492
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = c
trn_rcms_caseid=12666000008331
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,adjourn_type,case_no,court_code,isadjourn,next_hear_date,pre_case_purpose,new_case_purpose,pre_hear_date,adjourn_remark,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,:adjourn_type,:case_no,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:pre_case_purpose,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:trn_rcms_caseid,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 17302000007969
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
court_code = 10519
isadjourn = NO
next_hear_date = 07/11/2023
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 1000492
pre_hear_date = 04/10/2023
trn_rcms_caseid = 10128000006434
case_no = 2023/69
pre_case_purpose = 1000492
TRN_RCMS_HEARINGrow = 13
Posting record
Param Type = n
trn_rcms_hearingid=17302000007969
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10519
Param Type = c
isadjourn=NO
Param Type = c
next_hear_date=07/11/2023 00:00:00
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000492
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = c
trn_rcms_caseid=10128000006434
Param Type = c
case_no=2023/69
Param Type = n
pre_case_purpose=1000492
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,court_code,isadjourn,next_hear_date,adjourn_remark,adjourn_type,new_case_purpose,pre_hear_date,trn_rcms_caseid,case_no,pre_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:isadjourn,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:adjourn_type,:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:pre_case_purpose,:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 17302000007970
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
court_code = 10519
pre_case_purpose = 1000492
case_no = 2023/70
trn_rcms_caseid = 10166000007365
pre_hear_date = 04/10/2023
new_case_purpose = 1000492
adjourn_type = 0
adjourn_remark = 
next_hear_date = 07/11/2023
isadjourn = NO
TRN_RCMS_HEARINGrow = 14
Posting record
Param Type = n
trn_rcms_hearingid=17302000007970
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10519
Param Type = n
pre_case_purpose=1000492
Param Type = c
case_no=2023/70
Param Type = c
trn_rcms_caseid=10166000007365
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
adjourn_type=0
Param Type = c
next_hear_date=07/11/2023 00:00:00
Param Type = c
isadjourn=NO
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,court_code,pre_case_purpose,case_no,trn_rcms_caseid,pre_hear_date,new_case_purpose,adjourn_type,adjourn_remark,next_hear_date,isadjourn,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:pre_case_purpose,:case_no,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,null,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 2
RecordId = 17302000007971
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark = 
trn_rcms_caseid = 11939000007667
pre_hear_date = 04/10/2023
court_code = 10519
case_no = 2023/78
pre_case_purpose = 1000492
isadjourn = NO
adjourn_type = 0
new_case_purpose = 1000492
next_hear_date = 07/11/2023
TRN_RCMS_HEARINGrow = 15
Posting record
Param Type = n
trn_rcms_hearingid=17302000007971
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:21
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:21
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trn_rcms_caseid=11939000007667
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = c
court_code=10519
Param Type = c
case_no=2023/78
Param Type = n
pre_case_purpose=1000492
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000492
Param Type = c
next_hear_date=07/11/2023 00:00:00
Param Type = n
trn_rcms_hearingrow=15
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3
Adding new record to store data from Frame 2, Row 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 17302000007972
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark = 
isadjourn = NO
trn_rcms_caseid = 10885000007477
court_code = 10519
case_no = 2023/91
pre_hear_date = 04/10/2023
new_case_purpose = 1000492
adjourn_type = 0
pre_case_purpose = 1000492
next_hear_date = 07/11/2023
TRN_RCMS_HEARINGrow = 16
Posting record
Param Type = n
trn_rcms_hearingid=17302000007972
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseid=10885000007477
Param Type = c
court_code=10519
Param Type = c
case_no=2023/91
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = c
new_case_purpose=1000492
Param Type = c
adjourn_type=0
Param Type = n
pre_case_purpose=1000492
Param Type = c
next_hear_date=07/11/2023 00:00:00
Param Type = n
trn_rcms_hearingrow=16
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,isadjourn,trn_rcms_caseid,court_code,case_no,pre_hear_date,new_case_purpose,adjourn_type,pre_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,:isadjourn,:trn_rcms_caseid,:court_code,:case_no,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:adjourn_type,:pre_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 = 10
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 17302000007973
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 17292000003284
pre_hear_date = 04/10/2023
court_code = 10519
case_no = 2019/00127
next_hear_date = 07/11/2023
isadjourn = NO
pre_case_purpose = 18473000000000
new_case_purpose = 18473000000000
TRN_RCMS_HEARINGrow = 17
Posting record
Param Type = n
trn_rcms_hearingid=17302000007973
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=17292000003284
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = c
court_code=10519
Param Type = c
case_no=2019/00127
Param Type = c
next_hear_date=07/11/2023 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
new_case_purpose=18473000000000
Param Type = n
trn_rcms_hearingrow=17
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_remark,adjourn_type,trn_rcms_caseid,pre_hear_date,court_code,case_no,next_hear_date,isadjourn,pre_case_purpose,new_case_purpose,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:adjourn_type,:trn_rcms_caseid,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:pre_case_purpose,:new_case_purpose,:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 4
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 = 17302000007974
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 18401000003120
pre_hear_date = 04/10/2023
court_code = 10519
case_no = 2019/00133
next_hear_date = 07/11/2023
isadjourn = NO
pre_case_purpose = 18473000000000
new_case_purpose = 18473000000000
TRN_RCMS_HEARINGrow = 18
Posting record
Param Type = n
trn_rcms_hearingid=17302000007974
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=18401000003120
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = c
court_code=10519
Param Type = c
case_no=2019/00133
Param Type = c
next_hear_date=07/11/2023 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
new_case_purpose=18473000000000
Param Type = n
trn_rcms_hearingrow=18
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 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 17302000007975
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
adjourn_type = 0
adjourn_remark = 
isadjourn = NO
case_no = 2019/00134
trn_rcms_caseid = 18471000003276
pre_case_purpose = 18473000000000
court_code = 10519
next_hear_date = 07/11/2023
new_case_purpose = 18473000000000
pre_hear_date = 04/10/2023
TRN_RCMS_HEARINGrow = 19
Posting record
Param Type = n
trn_rcms_hearingid=17302000007975
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:22
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
case_no=2019/00134
Param Type = c
trn_rcms_caseid=18471000003276
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
court_code=10519
Param Type = c
next_hear_date=07/11/2023 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = c
pre_hear_date=04/10/2023 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,adjourn_type,adjourn_remark,isadjourn,case_no,trn_rcms_caseid,pre_case_purpose,court_code,next_hear_date,new_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:adjourn_type,null,:isadjourn,:case_no,:trn_rcms_caseid,:pre_case_purpose,:court_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 3
RecordId = 17302000007976
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
isadjourn = NO
adjourn_type = 0
adjourn_remark = 
trn_rcms_caseid = 13251000005770
case_no = 2021/221
court_code = 10519
pre_hear_date = 04/10/2023
next_hear_date = 27/01/2024
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
TRN_RCMS_HEARINGrow = 20
Posting record
Param Type = n
trn_rcms_hearingid=17302000007976
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:22
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=13251000005770
Param Type = c
case_no=2021/221
Param Type = c
court_code=10519
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = c
next_hear_date=27/01/2024 00:00:00
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
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,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 = 7
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 = 17302000007977
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
next_hear_date = 18/12/2023
trn_rcms_caseid = 16385000006129
case_no = 2022/95
court_code = 10519
new_case_purpose = 18473000000000
pre_case_purpose = 18473000000000
pre_hear_date = 04/10/2023
TRN_RCMS_HEARINGrow = 21
Posting record
Param Type = n
trn_rcms_hearingid=17302000007977
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:22
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=18/12/2023 00:00:00
Param Type = c
trn_rcms_caseid=16385000006129
Param Type = c
case_no=2022/95
Param Type = c
court_code=10519
Param Type = c
new_case_purpose=18473000000000
Param Type = n
pre_case_purpose=18473000000000
Param Type = c
pre_hear_date=04/10/2023 00:00:00
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,isadjourn,adjourn_remark,adjourn_type,next_hear_date,trn_rcms_caseid,case_no,court_code,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:isadjourn,null,:adjourn_type,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_caseid,:case_no,:court_code,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 2
RecordId = 17302000007978
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 12/10/2023
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
trn_rcms_caseid = 10367000007821
court_code = 10519
case_no = 2022/234
new_case_purpose = 1000497
pre_case_purpose = 1000497
pre_hear_date = 04/10/2023
TRN_RCMS_HEARINGrow = 22
Posting record
Param Type = n
trn_rcms_hearingid=17302000007978
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=12/10/2023 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
trn_rcms_caseid=10367000007821
Param Type = c
court_code=10519
Param Type = c
case_no=2022/234
Param Type = c
new_case_purpose=1000497
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = n
trn_rcms_hearingrow=22
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,isadjourn,adjourn_remark,adjourn_type,trn_rcms_caseid,court_code,case_no,new_case_purpose,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:trn_rcms_caseid,:court_code,:case_no,:new_case_purpose,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

select * from TRN_RCMS_HEARING where  TRN_RCMS_HEARINGid=0
Time elapsed = 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 = 4
RecordId = 17302000007979
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 12/10/2023
isadjourn = NO
adjourn_remark = 
adjourn_type = 0
new_case_purpose = 1000497
case_no = 2022/235
court_code = 10519
trn_rcms_caseid = 10374000008091
pre_case_purpose = 1000497
pre_hear_date = 04/10/2023
TRN_RCMS_HEARINGrow = 23
Posting record
Param Type = n
trn_rcms_hearingid=17302000007979
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=12/10/2023 00:00:00
Param Type = c
isadjourn=NO
Param Type = c
adjourn_type=0
Param Type = c
new_case_purpose=1000497
Param Type = c
case_no=2022/235
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=10374000008091
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=04/10/2023 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,next_hear_date,isadjourn,adjourn_remark,adjourn_type,new_case_purpose,case_no,court_code,trn_rcms_caseid,pre_case_purpose,pre_hear_date,trn_rcms_hearingrow) values (:trn_rcms_hearingid,:trn_rcms_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,null,:adjourn_type,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,:pre_case_purpose,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_rcms_hearingrow)

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

Time elapsed = 4
RecordId = 17302000007980
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 07/11/2023
new_case_purpose = 1000497
adjourn_remark = 
adjourn_type = 0
isadjourn = NO
case_no = 2022/69
court_code = 10519
trn_rcms_caseid = 10141000006705
pre_case_purpose = 1000497
pre_hear_date = 04/10/2023
TRN_RCMS_HEARINGrow = 24
Posting record
Param Type = n
trn_rcms_hearingid=17302000007980
Param Type = n
trn_rcms_mhearingid=17302000007956
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:22
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=07/11/2023 00:00:00
Param Type = c
new_case_purpose=1000497
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = c
case_no=2022/69
Param Type = c
court_code=10519
Param Type = c
trn_rcms_caseid=10141000006705
Param Type = n
pre_case_purpose=1000497
Param Type = c
pre_hear_date=04/10/2023 00:00:00
Param Type = n
trn_rcms_hearingrow=24
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,trn_rcms_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,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 = 3905680049760

>>Executing genmaps

>>Posting from trcmf to tchdh from row 1

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18324000006573 idvalue 0
Mapped case_no Row = 1 value = 2022/142 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 18/12/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 18324000006573
case_no = 2022/142
prev_hearing_date = 04/10/2023
hearing_date = 18/12/2023
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 = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 17302000007981
MapName trcmf1
SourceId 17302000007957
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 2
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 18/12/2023
case_no = 2022/142
trn_rcms_caseregid = 18324000006573
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007981
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007957
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:22
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08: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=1000492
Param Type = c
hearing_date=18/12/2023 00:00:00
Param Type = c
case_no=2022/142
Param Type = c
trn_rcms_caseregid=18324000006573
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 2

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11926000007161 idvalue 0
Mapped case_no Row = 1 value = 2022/250 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 07/11/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 11926000007161
case_no = 2022/250
prev_hearing_date = 04/10/2023
hearing_date = 07/11/2023
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 17302000007982
MapName trcmf1
SourceId 17302000007958
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 07/11/2023
case_no = 2022/250
trn_rcms_caseregid = 11926000007161
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007982
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007958
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=07/11/2023 00:00:00
Param Type = c
case_no=2022/250
Param Type = c
trn_rcms_caseregid=11926000007161
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 3

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 14854000007250 idvalue 0
Mapped case_no Row = 1 value = 2023/153 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 27/01/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 = 10519
trn_rcms_caseregid = 14854000007250
case_no = 2023/153
prev_hearing_date = 04/10/2023
hearing_date = 27/01/2024
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 5
RecordId = 17302000007983
MapName trcmf1
SourceId 17302000007959
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 27/01/2024
case_no = 2023/153
trn_rcms_caseregid = 14854000007250
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007983
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007959
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=27/01/2024 00:00:00
Param Type = c
case_no=2023/153
Param Type = c
trn_rcms_caseregid=14854000007250
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 4

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 15005000007175 idvalue 0
Mapped case_no Row = 1 value = 2023/154 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 27/01/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 = 10519
trn_rcms_caseregid = 15005000007175
case_no = 2023/154
prev_hearing_date = 04/10/2023
hearing_date = 27/01/2024
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 17302000007984
MapName trcmf1
SourceId 17302000007960
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 27/01/2024
case_no = 2023/154
trn_rcms_caseregid = 15005000007175
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007984
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007960
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=27/01/2024 00:00:00
Param Type = c
case_no=2023/154
Param Type = c
trn_rcms_caseregid=15005000007175
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 5

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18178000008055 idvalue 0
Mapped case_no Row = 1 value = 2023/171 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 18/12/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 18178000008055
case_no = 2023/171
prev_hearing_date = 04/10/2023
hearing_date = 18/12/2023
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 17302000007985
MapName trcmf1
SourceId 17302000007961
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 18/12/2023
case_no = 2023/171
trn_rcms_caseregid = 18178000008055
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007985
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007961
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=18/12/2023 00:00:00
Param Type = c
case_no=2023/171
Param Type = c
trn_rcms_caseregid=18178000008055
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 6

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19184000006989 idvalue 0
Mapped case_no Row = 1 value = 2023/174 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 16/11/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 19184000006989
case_no = 2023/174
prev_hearing_date = 04/10/2023
hearing_date = 16/11/2023
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 17302000007986
MapName trcmf1
SourceId 17302000007962
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 16/11/2023
case_no = 2023/174
trn_rcms_caseregid = 19184000006989
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007986
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007962
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=16/11/2023 00:00:00
Param Type = c
case_no=2023/174
Param Type = c
trn_rcms_caseregid=19184000006989
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 7

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19197000006423 idvalue 0
Mapped case_no Row = 1 value = 2023/175 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 16/11/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 19197000006423
case_no = 2023/175
prev_hearing_date = 04/10/2023
hearing_date = 16/11/2023
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 17302000007987
MapName trcmf1
SourceId 17302000007963
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 16/11/2023
case_no = 2023/175
trn_rcms_caseregid = 19197000006423
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007987
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007963
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=16/11/2023 00:00:00
Param Type = c
case_no=2023/175
Param Type = c
trn_rcms_caseregid=19197000006423
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 8

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 19223000008660 idvalue 0
Mapped case_no Row = 1 value = 2023/176 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 18/12/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 19223000008660
case_no = 2023/176
prev_hearing_date = 04/10/2023
hearing_date = 18/12/2023
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 17302000007988
MapName trcmf1
SourceId 17302000007964
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 18/12/2023
case_no = 2023/176
trn_rcms_caseregid = 19223000008660
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007988
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007964
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=18/12/2023 00:00:00
Param Type = c
case_no=2023/176
Param Type = c
trn_rcms_caseregid=19223000008660
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 9

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13058000008658 idvalue 0
Mapped case_no Row = 1 value = 2023/178 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 18/12/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 13058000008658
case_no = 2023/178
prev_hearing_date = 04/10/2023
hearing_date = 18/12/2023
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 17302000007989
MapName trcmf1
SourceId 17302000007965
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 18/12/2023
case_no = 2023/178
trn_rcms_caseregid = 13058000008658
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007989
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007965
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=18/12/2023 00:00:00
Param Type = c
case_no=2023/178
Param Type = c
trn_rcms_caseregid=13058000008658
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 10

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12472000006731 idvalue 0
Mapped case_no Row = 1 value = 2023/23 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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/10/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 12472000006731
case_no = 2023/23
prev_hearing_date = 04/10/2023
hearing_date = 20/10/2023
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 17302000007990
MapName trcmf1
SourceId 17302000007966
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 20/10/2023
case_no = 2023/23
trn_rcms_caseregid = 12472000006731
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007990
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007966
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:23
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:23
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000492
Param Type = c
hearing_date=20/10/2023 00:00:00
Param Type = c
case_no=2023/23
Param Type = c
trn_rcms_caseregid=12472000006731
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 11

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12623000007967 idvalue 0
Mapped case_no Row = 1 value = 2023/26 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 18/12/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 12623000007967
case_no = 2023/26
prev_hearing_date = 04/10/2023
hearing_date = 18/12/2023
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 17302000007991
MapName trcmf1
SourceId 17302000007967
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 18/12/2023
case_no = 2023/26
trn_rcms_caseregid = 12623000007967
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007991
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007967
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:24
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08: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=1000492
Param Type = c
hearing_date=18/12/2023 00:00:00
Param Type = c
case_no=2023/26
Param Type = c
trn_rcms_caseregid=12623000007967
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 12

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 12666000008331 idvalue 0
Mapped case_no Row = 1 value = 2023/27 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 07/11/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 12666000008331
case_no = 2023/27
prev_hearing_date = 04/10/2023
hearing_date = 07/11/2023
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 17302000007992
MapName trcmf1
SourceId 17302000007968
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 07/11/2023
case_no = 2023/27
trn_rcms_caseregid = 12666000008331
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007992
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007968
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:24
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08: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=1000492
Param Type = c
hearing_date=07/11/2023 00:00:00
Param Type = c
case_no=2023/27
Param Type = c
trn_rcms_caseregid=12666000008331
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 13

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10128000006434 idvalue 0
Mapped case_no Row = 1 value = 2023/69 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 07/11/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 10128000006434
case_no = 2023/69
prev_hearing_date = 04/10/2023
hearing_date = 07/11/2023
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 17302000007993
MapName trcmf1
SourceId 17302000007969
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 07/11/2023
case_no = 2023/69
trn_rcms_caseregid = 10128000006434
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007993
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007969
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:24
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08: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=1000492
Param Type = c
hearing_date=07/11/2023 00:00:00
Param Type = c
case_no=2023/69
Param Type = c
trn_rcms_caseregid=10128000006434
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 14

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10166000007365 idvalue 0
Mapped case_no Row = 1 value = 2023/70 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 07/11/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 10166000007365
case_no = 2023/70
prev_hearing_date = 04/10/2023
hearing_date = 07/11/2023
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 17302000007994
MapName trcmf1
SourceId 17302000007970
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 = 1000492
hearing_date = 07/11/2023
case_no = 2023/70
trn_rcms_caseregid = 10166000007365
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007994
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007970
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:24
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08: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=1000492
Param Type = c
hearing_date=07/11/2023 00:00:00
Param Type = c
case_no=2023/70
Param Type = c
trn_rcms_caseregid=10166000007365
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 15

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 11939000007667 idvalue 0
Mapped case_no Row = 1 value = 2023/78 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 07/11/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 11939000007667
case_no = 2023/78
prev_hearing_date = 04/10/2023
hearing_date = 07/11/2023
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 17302000007995
MapName trcmf1
SourceId 17302000007971
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 07/11/2023
case_no = 2023/78
trn_rcms_caseregid = 11939000007667
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007995
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007971
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:24
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08: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=1000492
Param Type = c
hearing_date=07/11/2023 00:00:00
Param Type = c
case_no=2023/78
Param Type = c
trn_rcms_caseregid=11939000007667
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 16

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10885000007477 idvalue 0
Mapped case_no Row = 1 value = 2023/91 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 07/11/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 10885000007477
case_no = 2023/91
prev_hearing_date = 04/10/2023
hearing_date = 07/11/2023
prev_case_purposename = ?????
prev_case_purpose = 
prev_case_purpose after validation = 1000492
case_purpose = 1000492
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 3
RecordId = 17302000007996
MapName trcmf1
SourceId 17302000007972
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 1000492
hearing_date = 07/11/2023
case_no = 2023/91
trn_rcms_caseregid = 10885000007477
court_code = 10519
case_purpose = 1000492
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007996
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007972
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:24
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08: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=1000492
Param Type = c
hearing_date=07/11/2023 00:00:00
Param Type = c
case_no=2023/91
Param Type = c
trn_rcms_caseregid=10885000007477
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000492
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 17

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 17292000003284 idvalue 0
Mapped case_no Row = 1 value = 2019/00127 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 07/11/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 17292000003284
case_no = 2019/00127
prev_hearing_date = 04/10/2023
hearing_date = 07/11/2023
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purposename=???
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

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

Time elapsed = 3
RecordId = 17302000007997
MapName trcmf1
SourceId 17302000007973
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 07/11/2023
case_no = 2019/00127
trn_rcms_caseregid = 17292000003284
court_code = 10519
case_purpose = 18473000000000
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007997
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007973
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:24
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=07/11/2023 00:00:00
Param Type = c
case_no=2019/00127
Param Type = c
trn_rcms_caseregid=17292000003284
Param Type = c
court_code=10519
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 18

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18401000003120 idvalue 0
Mapped case_no Row = 1 value = 2019/00133 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 07/11/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 18401000003120
case_no = 2019/00133
prev_hearing_date = 04/10/2023
hearing_date = 07/11/2023
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 17302000007998
MapName trcmf1
SourceId 17302000007974
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 07/11/2023
case_no = 2019/00133
trn_rcms_caseregid = 18401000003120
court_code = 10519
case_purpose = 18473000000000
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007998
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007974
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:24
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:24
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=07/11/2023 00:00:00
Param Type = c
case_no=2019/00133
Param Type = c
trn_rcms_caseregid=18401000003120
Param Type = c
court_code=10519
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 19

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18471000003276 idvalue 0
Mapped case_no Row = 1 value = 2019/00134 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 07/11/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 18471000003276
case_no = 2019/00134
prev_hearing_date = 04/10/2023
hearing_date = 07/11/2023
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 17302000007999
MapName trcmf1
SourceId 17302000007975
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 07/11/2023
case_no = 2019/00134
trn_rcms_caseregid = 18471000003276
court_code = 10519
case_purpose = 18473000000000
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000007999
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007975
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:25
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=07/11/2023 00:00:00
Param Type = c
case_no=2019/00134
Param Type = c
trn_rcms_caseregid=18471000003276
Param Type = c
court_code=10519
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 20

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 13251000005770 idvalue 0
Mapped case_no Row = 1 value = 2021/221 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? idvalue 0
Mapped case_purpose Row = 1 value = 18473000000000 idvalue 0
Mapped hearing_date Row = 1 value = 27/01/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 = 10519
trn_rcms_caseregid = 13251000005770
case_no = 2021/221
prev_hearing_date = 04/10/2023
hearing_date = 27/01/2024
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 17302000008000
MapName trcmf1
SourceId 17302000007976
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 3
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 27/01/2024
case_no = 2021/221
trn_rcms_caseregid = 13251000005770
court_code = 10519
case_purpose = 18473000000000
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000008000
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007976
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:25
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=27/01/2024 00:00:00
Param Type = c
case_no=2021/221
Param Type = c
trn_rcms_caseregid=13251000005770
Param Type = c
court_code=10519
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 21

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 16385000006129 idvalue 0
Mapped case_no Row = 1 value = 2022/95 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 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 = 18/12/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 16385000006129
case_no = 2022/95
prev_hearing_date = 04/10/2023
hearing_date = 18/12/2023
prev_case_purposename = ???
prev_case_purpose = 
prev_case_purpose after validation = 18473000000000
case_purpose = 18473000000000
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 17302000008001
MapName trcmf1
SourceId 17302000007977
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
trans_type = Feedback Submitted (Custom)
adjourn_type = 0
isadjourn = NO
decision_date = 
decision_type = 0
prev_case_purpose = 18473000000000
hearing_date = 18/12/2023
case_no = 2022/95
trn_rcms_caseregid = 16385000006129
court_code = 10519
case_purpose = 18473000000000
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000008001
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007977
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:25
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18473000000000
Param Type = c
hearing_date=18/12/2023 00:00:00
Param Type = c
case_no=2022/95
Param Type = c
trn_rcms_caseregid=16385000006129
Param Type = c
court_code=10519
Param Type = c
case_purpose=18473000000000
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 22

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10367000007821 idvalue 0
Mapped case_no Row = 1 value = 2022/234 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 12/10/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 10367000007821
case_no = 2022/234
prev_hearing_date = 04/10/2023
hearing_date = 12/10/2023
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purposename=???? ?????????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

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

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 17302000008002
MapName trcmf1
SourceId 17302000007978
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 = 1000497
hearing_date = 12/10/2023
case_no = 2022/234
trn_rcms_caseregid = 10367000007821
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000008002
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007978
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:25
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=12/10/2023 00:00:00
Param Type = c
case_no=2022/234
Param Type = c
trn_rcms_caseregid=10367000007821
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 23

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10374000008091 idvalue 0
Mapped case_no Row = 1 value = 2022/235 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 12/10/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 10374000008091
case_no = 2022/235
prev_hearing_date = 04/10/2023
hearing_date = 12/10/2023
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 4
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 17302000008003
MapName trcmf1
SourceId 17302000007979
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 = 1000497
hearing_date = 12/10/2023
case_no = 2022/235
trn_rcms_caseregid = 10374000008091
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000008003
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007979
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:25
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=12/10/2023 00:00:00
Param Type = c
case_no=2022/235
Param Type = c
trn_rcms_caseregid=10374000008091
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=04/10/2023 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_type,adjourn_type,isadjourn,decision_date,decision_type,prev_case_purpose,hearing_date,case_no,trn_rcms_caseregid,court_code,case_purpose,prev_hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:trans_type,:adjourn_type,:isadjourn,null,:decision_type,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:trn_rcms_caseregid,:court_code,:case_purpose,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from trcmf to tchdh from row 24

>>Mapping
Mapped court_code Row = 1 value = 10519 idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 10141000006705 idvalue 0
Mapped case_no Row = 1 value = 2022/69 idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? ????????? idvalue 0
Mapped case_purpose Row = 1 value = 1000497 idvalue 0
Mapped hearing_date Row = 1 value = 07/11/2023 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value = 0 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Custom) idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 10519
trn_rcms_caseregid = 10141000006705
case_no = 2022/69
prev_hearing_date = 04/10/2023
hearing_date = 07/11/2023
prev_case_purposename = ???? ?????????
prev_case_purpose = 
prev_case_purpose after validation = 1000497
case_purpose = 1000497
trans_type = Feedback Submitted (Custom)
clcheck = 
isadjourn = NO
adjourn_type = 0
decision_type = 
decision_date = 

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

Time elapsed = 3
Saving to table TRN_RCMS_CASE_HIST
select * from TRN_RCMS_CASE_HIST where  TRN_RCMS_CASE_HISTid=0
Time elapsed = 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 = 17302000008004
MapName trcmf1
SourceId 17302000007980
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 = 1000497
hearing_date = 07/11/2023
case_no = 2022/69
trn_rcms_caseregid = 10141000006705
court_code = 10519
case_purpose = 1000497
prev_hearing_date = 04/10/2023
Posting record
Param Type = n
trn_rcms_case_histid=17302000008004
Param Type = c
mapname=trcmf1
Param Type = n
sourceid=17302000007980
Param Type = c
cancel=F
Param Type = c
createdby=SDO_Chauhtan
Param Type = c
createdon=05/10/2023 15:08:25
Param Type = c
username=SDO_Chauhtan
Param Type = c
modifiedon=05/10/2023 15:08:25
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_type=Feedback Submitted (Custom)
Param Type = c
adjourn_type=0
Param Type = c
isadjourn=NO
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=1000497
Param Type = c
hearing_date=07/11/2023 00:00:00
Param Type = c
case_no=2022/69
Param Type = c
trn_rcms_caseregid=10141000006705
Param Type = c
court_code=10519
Param Type = c
case_purpose=1000497
Param Type = c
prev_hearing_date=04/10/2023 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 = 3905680052775
Time elapsed for MD Map = 3905680052776
Time elapsed for Save History = 3905680052777
Time elapsed for Save Attachment = 3905680052778
Time elapsed for After Save WF Exec = 3905680052781
Transaction commited
Result : {"message":[{"msg":"Update Feedback (Custom) Saved","recordid":"17302000007956"}]}
Savedata webservice completed


Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
Closing connection
# 1#Saving to log
Param Type = c
username=SDO_Chauhtan
Param Type = c
calledon=05/10/2023 15:07:27
Param Type = c
callfinished=05/10/2023 15:07:32
Param Type = c
structname=trcmf
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=success
Param Type = n
timetaken=5808
Param Type = n
dbtimetaken=3473
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