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="ekta" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>ekta</username><password>827ccb0eea8a706c4c34a16891f84e7b</password><seed></seed><s></s><transid>bocup</transid><recordid>0</recordid><recdata></recdata><data transid="bocup" recordid="0"><axp_recid1 rowno="001">0</axp_recid1><courtname rowno="001">11599000000000</courtname><courtcode rowno="001">10006</courtcode><cldate rowno="001">04/12/2023</cldate><cltype rowno="001">R</cltype><benchname rowno="001">??. ??. (?????)</benchname><benchcode rowno="001">14</benchcode><cluser rowno="001"></cluser><bench_mem1 rowno="001">0</bench_mem1><bench_mem2 rowno="001">0</bench_mem2><axp_recid2 rowno="001">0</axp_recid2><puname rowno="001">ekta</puname><court_name rowno="001">11599000000000</court_name><court_code rowno="001">10006</court_code><docid rowno="001">100062012/6486</docid><case_no rowno="001">2012/6486</case_no><trn_bor_caseid rowno="001">990109925</trn_bor_caseid><manual_case_no rowno="001"></manual_case_no><bench_code rowno="001">14</bench_code><prev_case_purpose rowno="001">???.</prev_case_purpose><prev_purpose_code rowno="001">201</prev_purpose_code><prev_hear_date rowno="001">04/12/2023</prev_hear_date><next_hear_date rowno="001">08/01/2024</next_hear_date><new_case_purpose rowno="001">10189000000601</new_case_purpose><new_purpose_code rowno="001">201</new_purpose_code><new_purpose_group rowno="001">19968000000591</new_purpose_group><axp_recid2 rowno="002">0</axp_recid2><puname rowno="002">ekta</puname><court_name rowno="002">11599000000000</court_name><court_code rowno="002">10006</court_code><docid rowno="002">100062015/6901</docid><case_no rowno="002">2015/6901</case_no><trn_bor_caseid rowno="002">990136093</trn_bor_caseid><manual_case_no rowno="002"></manual_case_no><bench_code rowno="002">14</bench_code><prev_case_purpose rowno="002">???.</prev_case_purpose><prev_purpose_code rowno="002">201</prev_purpose_code><prev_hear_date rowno="002">04/12/2023</prev_hear_date><next_hear_date rowno="002">08/01/2024</next_hear_date><new_case_purpose rowno="002">10189000000601</new_case_purpose><new_purpose_code rowno="002">201</new_purpose_code><new_purpose_group rowno="002">19968000000591</new_purpose_group><axp_recid2 rowno="003">0</axp_recid2><puname rowno="003">ekta</puname><court_name rowno="003">11599000000000</court_name><court_code rowno="003">10006</court_code><docid rowno="003">100062018/1585</docid><case_no rowno="003">2018/1585</case_no><trn_bor_caseid rowno="003">14491000001395</trn_bor_caseid><manual_case_no rowno="003"></manual_case_no><bench_code rowno="003">14</bench_code><prev_case_purpose rowno="003">???.</prev_case_purpose><prev_purpose_code rowno="003">201</prev_purpose_code><prev_hear_date rowno="003">04/12/2023</prev_hear_date><next_hear_date rowno="003">22/01/2024</next_hear_date><new_case_purpose rowno="003">10189000000601</new_case_purpose><new_purpose_code rowno="003">201</new_purpose_code><new_purpose_group rowno="003">19968000000591</new_purpose_group><axp_recid2 rowno="004">0</axp_recid2><puname rowno="004">ekta</puname><court_name rowno="004">11599000000000</court_name><court_code rowno="004">10006</court_code><docid rowno="004">100062022/7607</docid><case_no rowno="004">2022/7607</case_no><trn_bor_caseid rowno="004">18097000007349</trn_bor_caseid><manual_case_no rowno="004"></manual_case_no><bench_code rowno="004">14</bench_code><prev_case_purpose rowno="004">?????? ??????</prev_case_purpose><prev_purpose_code rowno="004">131</prev_purpose_code><prev_hear_date rowno="004">04/12/2023</prev_hear_date><next_hear_date rowno="004">18/12/2023</next_hear_date><new_case_purpose rowno="004">10119000000827</new_case_purpose><new_purpose_code rowno="004">131</new_purpose_code><new_purpose_group rowno="004">19966000000909</new_purpose_group><axp_recid2 rowno="005">0</axp_recid2><puname rowno="005">ekta</puname><court_name rowno="005">11599000000000</court_name><court_code rowno="005">10006</court_code><docid rowno="005">100062023/500</docid><case_no rowno="005">2023/500</case_no><trn_bor_caseid rowno="005">14667000007493</trn_bor_caseid><manual_case_no rowno="005"></manual_case_no><bench_code rowno="005">14</bench_code><prev_case_purpose rowno="005">?????? ???? ??????</prev_case_purpose><prev_purpose_code rowno="005">73</prev_purpose_code><prev_hear_date rowno="005">04/12/2023</prev_hear_date><next_hear_date rowno="005">18/12/2023</next_hear_date><new_case_purpose rowno="005">17553000001243</new_case_purpose><new_purpose_code rowno="005">73</new_purpose_code><new_purpose_group rowno="005">19966000000909</new_purpose_group><axp_recid2 rowno="006">0</axp_recid2><puname rowno="006">ekta</puname><court_name rowno="006">11599000000000</court_name><court_code rowno="006">10006</court_code><docid rowno="006">100062023/2907</docid><case_no rowno="006">2023/2907</case_no><trn_bor_caseid rowno="006">14027000008055</trn_bor_caseid><manual_case_no rowno="006"></manual_case_no><bench_code rowno="006">14</bench_code><prev_case_purpose rowno="006">?????? ????</prev_case_purpose><prev_purpose_code rowno="006">121</prev_purpose_code><prev_hear_date rowno="006">04/12/2023</prev_hear_date><next_hear_date rowno="006">18/12/2023</next_hear_date><new_case_purpose rowno="006">10109000001043</new_case_purpose><new_purpose_code rowno="006">121</new_purpose_code><new_purpose_group rowno="006">19966000000909</new_purpose_group><axp_recid2 rowno="007">0</axp_recid2><puname rowno="007">ekta</puname><court_name rowno="007">11599000000000</court_name><court_code rowno="007">10006</court_code><docid rowno="007">100062023/5452</docid><case_no rowno="007">2023/5452</case_no><trn_bor_caseid rowno="007">16675000007847</trn_bor_caseid><manual_case_no rowno="007"></manual_case_no><bench_code rowno="007">14</bench_code><prev_case_purpose rowno="007">?????? ???? ??????</prev_case_purpose><prev_purpose_code rowno="007">73</prev_purpose_code><prev_hear_date rowno="007">04/12/2023</prev_hear_date><next_hear_date rowno="007">19/12/2023</next_hear_date><new_case_purpose rowno="007">17553000001243</new_case_purpose><new_purpose_code rowno="007">73</new_purpose_code><new_purpose_group rowno="007">19966000000909</new_purpose_group><axp_recid2 rowno="008">0</axp_recid2><puname rowno="008">ekta</puname><court_name rowno="008">11599000000000</court_name><court_code rowno="008">10006</court_code><docid rowno="008">100062003/1667</docid><case_no rowno="008">2003/1667</case_no><trn_bor_caseid rowno="008">990031029</trn_bor_caseid><manual_case_no rowno="008"></manual_case_no><bench_code rowno="008">14</bench_code><prev_case_purpose rowno="008">?????? ???? </prev_case_purpose><prev_purpose_code rowno="008">113</prev_purpose_code><prev_hear_date rowno="008">04/12/2023</prev_hear_date><next_hear_date rowno="008">22/01/2024</next_hear_date><new_case_purpose rowno="008">10037000000780</new_case_purpose><new_purpose_code rowno="008">113</new_purpose_code><new_purpose_group rowno="008">19971000000602</new_purpose_group><axp_recid2 rowno="009">0</axp_recid2><puname rowno="009">ekta</puname><court_name rowno="009">11599000000000</court_name><court_code rowno="009">10006</court_code><docid rowno="009">100062003/10480</docid><case_no rowno="009">2003/10480</case_no><trn_bor_caseid rowno="009">990027785</trn_bor_caseid><manual_case_no rowno="009"></manual_case_no><bench_code rowno="009">14</bench_code><prev_case_purpose rowno="009">?????? ?????</prev_case_purpose><prev_purpose_code rowno="009">112</prev_purpose_code><prev_hear_date rowno="009">04/12/2023</prev_hear_date><next_hear_date rowno="009">22/01/2024</next_hear_date><new_case_purpose rowno="009">10035000000979</new_case_purpose><new_purpose_code rowno="009">112</new_purpose_code><new_purpose_group rowno="009">19971000000602</new_purpose_group><axp_recid2 rowno="0010">0</axp_recid2><puname rowno="0010">ekta</puname><court_name rowno="0010">11599000000000</court_name><court_code rowno="0010">10006</court_code><docid rowno="0010">100062013/1262</docid><case_no rowno="0010">2013/1262</case_no><trn_bor_caseid rowno="0010">990116928</trn_bor_caseid><manual_case_no rowno="0010"></manual_case_no><bench_code rowno="0010">14</bench_code><prev_case_purpose rowno="0010">?????? ?????</prev_case_purpose><prev_purpose_code rowno="0010">112</prev_purpose_code><prev_hear_date rowno="0010">04/12/2023</prev_hear_date><next_hear_date rowno="0010">05/02/2024</next_hear_date><new_case_purpose rowno="0010">10035000000979</new_case_purpose><new_purpose_code rowno="0010">112</new_purpose_code><new_purpose_group rowno="0010">19971000000602</new_purpose_group><axp_recid2 rowno="0011">0</axp_recid2><puname rowno="0011">ekta</puname><court_name rowno="0011">11599000000000</court_name><court_code rowno="0011">10006</court_code><docid rowno="0011">100062015/8186</docid><case_no rowno="0011">2015/8186</case_no><trn_bor_caseid rowno="0011">990146845</trn_bor_caseid><manual_case_no rowno="0011"></manual_case_no><bench_code rowno="0011">14</bench_code><prev_case_purpose rowno="0011">?????? ???? </prev_case_purpose><prev_purpose_code rowno="0011">113</prev_purpose_code><prev_hear_date rowno="0011">04/12/2023</prev_hear_date><next_hear_date rowno="0011">05/02/2024</next_hear_date><new_case_purpose rowno="0011">10037000000780</new_case_purpose><new_purpose_code rowno="0011">113</new_purpose_code><new_purpose_group rowno="0011">19971000000602</new_purpose_group><axp_recid2 rowno="0012">0</axp_recid2><puname rowno="0012">ekta</puname><court_name rowno="0012">11599000000000</court_name><court_code rowno="0012">10006</court_code><docid rowno="0012">100062016/6416</docid><case_no rowno="0012">2016/6416</case_no><trn_bor_caseid rowno="0012">990143298</trn_bor_caseid><manual_case_no rowno="0012"></manual_case_no><bench_code rowno="0012">14</bench_code><prev_case_purpose rowno="0012">?????? ?????</prev_case_purpose><prev_purpose_code rowno="0012">112</prev_purpose_code><prev_hear_date rowno="0012">04/12/2023</prev_hear_date><next_hear_date rowno="0012">05/02/2024</next_hear_date><new_case_purpose rowno="0012">10035000000979</new_case_purpose><new_purpose_code rowno="0012">112</new_purpose_code><new_purpose_group rowno="0012">19971000000602</new_purpose_group><axp_recid2 rowno="0013">0</axp_recid2><puname rowno="0013">ekta</puname><court_name rowno="0013">11599000000000</court_name><court_code rowno="0013">10006</court_code><docid rowno="0013">100062017/2646</docid><case_no rowno="0013">2017/2646</case_no><trn_bor_caseid rowno="0013">2000154183</trn_bor_caseid><manual_case_no rowno="0013"></manual_case_no><bench_code rowno="0013">14</bench_code><prev_case_purpose rowno="0013">?????? ?????</prev_case_purpose><prev_purpose_code rowno="0013">112</prev_purpose_code><prev_hear_date rowno="0013">04/12/2023</prev_hear_date><next_hear_date rowno="0013">22/01/2024</next_hear_date><new_case_purpose rowno="0013">10035000000979</new_case_purpose><new_purpose_code rowno="0013">112</new_purpose_code><new_purpose_group rowno="0013">19971000000602</new_purpose_group><axp_recid2 rowno="0014">0</axp_recid2><puname rowno="0014">ekta</puname><court_name rowno="0014">11599000000000</court_name><court_code rowno="0014">10006</court_code><docid rowno="0014">100062017/5372</docid><case_no rowno="0014">2017/5372</case_no><trn_bor_caseid rowno="0014">990158828</trn_bor_caseid><manual_case_no rowno="0014"></manual_case_no><bench_code rowno="0014">14</bench_code><prev_case_purpose rowno="0014">?????? ????? ????</prev_case_purpose><prev_purpose_code rowno="0014">122</prev_purpose_code><prev_hear_date rowno="0014">04/12/2023</prev_hear_date><next_hear_date rowno="0014">22/01/2024</next_hear_date><new_case_purpose rowno="0014">10110000000719</new_case_purpose><new_purpose_code rowno="0014">122</new_purpose_code><new_purpose_group rowno="0014">19971000000602</new_purpose_group><axp_recid2 rowno="0015">0</axp_recid2><puname rowno="0015">ekta</puname><court_name rowno="0015">11599000000000</court_name><court_code rowno="0015">10006</court_code><docid rowno="0015">100062018/3887</docid><case_no rowno="0015">2018/3887</case_no><trn_bor_caseid rowno="0015">14077000001981</trn_bor_caseid><manual_case_no rowno="0015"></manual_case_no><bench_code rowno="0015">14</bench_code><prev_case_purpose rowno="0015">?????? ?????</prev_case_purpose><prev_purpose_code rowno="0015">112</prev_purpose_code><prev_hear_date rowno="0015">04/12/2023</prev_hear_date><next_hear_date rowno="0015">22/01/2024</next_hear_date><new_case_purpose rowno="0015">10035000000979</new_case_purpose><new_purpose_code rowno="0015">112</new_purpose_code><new_purpose_group rowno="0015">19971000000602</new_purpose_group><axp_recid2 rowno="0016">0</axp_recid2><puname rowno="0016">ekta</puname><court_name rowno="0016">11599000000000</court_name><court_code rowno="0016">10006</court_code><docid rowno="0016">100062018/4450</docid><case_no rowno="0016">2018/4450</case_no><trn_bor_caseid rowno="0016">10726000002583</trn_bor_caseid><manual_case_no rowno="0016"></manual_case_no><bench_code rowno="0016">14</bench_code><prev_case_purpose rowno="0016">?????? ?????</prev_case_purpose><prev_purpose_code rowno="0016">112</prev_purpose_code><prev_hear_date rowno="0016">04/12/2023</prev_hear_date><next_hear_date rowno="0016">05/02/2024</next_hear_date><new_case_purpose rowno="0016">10035000000979</new_case_purpose><new_purpose_code rowno="0016">112</new_purpose_code><new_purpose_group rowno="0016">19971000000602</new_purpose_group><axp_recid2 rowno="0017">0</axp_recid2><puname rowno="0017">ekta</puname><court_name rowno="0017">11599000000000</court_name><court_code rowno="0017">10006</court_code><docid rowno="0017">100062018/8313</docid><case_no rowno="0017">2018/8313</case_no><trn_bor_caseid rowno="0017">12597000002091</trn_bor_caseid><manual_case_no rowno="0017"></manual_case_no><bench_code rowno="0017">14</bench_code><prev_case_purpose rowno="0017">?????? ????? ????</prev_case_purpose><prev_purpose_code rowno="0017">122</prev_purpose_code><prev_hear_date rowno="0017">04/12/2023</prev_hear_date><next_hear_date rowno="0017">05/02/2024</next_hear_date><new_case_purpose rowno="0017">10110000000719</new_case_purpose><new_purpose_code rowno="0017">122</new_purpose_code><new_purpose_group rowno="0017">19971000000602</new_purpose_group><axp_recid2 rowno="0018">0</axp_recid2><puname rowno="0018">ekta</puname><court_name rowno="0018">11599000000000</court_name><court_code rowno="0018">10006</court_code><docid rowno="0018">100062019/2849</docid><case_no rowno="0018">2019/2849</case_no><trn_bor_caseid rowno="0018">17328000002511</trn_bor_caseid><manual_case_no rowno="0018"></manual_case_no><bench_code rowno="0018">14</bench_code><prev_case_purpose rowno="0018">?????? ???? </prev_case_purpose><prev_purpose_code rowno="0018">113</prev_purpose_code><prev_hear_date rowno="0018">04/12/2023</prev_hear_date><next_hear_date rowno="0018">05/02/2024</next_hear_date><new_case_purpose rowno="0018">10037000000780</new_case_purpose><new_purpose_code rowno="0018">113</new_purpose_code><new_purpose_group rowno="0018">19971000000602</new_purpose_group><axp_recid2 rowno="0019">0</axp_recid2><puname rowno="0019">ekta</puname><court_name rowno="0019">11599000000000</court_name><court_code rowno="0019">10006</court_code><docid rowno="0019">100062021/5803</docid><case_no rowno="0019">2021/5803</case_no><trn_bor_caseid rowno="0019">14259000006248</trn_bor_caseid><manual_case_no rowno="0019"></manual_case_no><bench_code rowno="0019">14</bench_code><prev_case_purpose rowno="0019">?????? ????? ????</prev_case_purpose><prev_purpose_code rowno="0019">122</prev_purpose_code><prev_hear_date rowno="0019">04/12/2023</prev_hear_date><next_hear_date rowno="0019">05/02/2024</next_hear_date><new_case_purpose rowno="0019">10110000000719</new_case_purpose><new_purpose_code rowno="0019">122</new_purpose_code><new_purpose_group rowno="0019">19971000000602</new_purpose_group><axp_recid2 rowno="0020">0</axp_recid2><puname rowno="0020">ekta</puname><court_name rowno="0020">11599000000000</court_name><court_code rowno="0020">10006</court_code><docid rowno="0020">100062022/101</docid><case_no rowno="0020">2022/101</case_no><trn_bor_caseid rowno="0020">16760000005225</trn_bor_caseid><manual_case_no rowno="0020"></manual_case_no><bench_code rowno="0020">14</bench_code><prev_case_purpose rowno="0020">?????? ????? ????</prev_case_purpose><prev_purpose_code rowno="0020">122</prev_purpose_code><prev_hear_date rowno="0020">04/12/2023</prev_hear_date><next_hear_date rowno="0020">05/02/2024</next_hear_date><new_case_purpose rowno="0020">10110000000719</new_case_purpose><new_purpose_code rowno="0020">122</new_purpose_code><new_purpose_group rowno="0020">19971000000602</new_purpose_group><axp_recid2 rowno="0021">0</axp_recid2><puname rowno="0021">ekta</puname><court_name rowno="0021">11599000000000</court_name><court_code rowno="0021">10006</court_code><docid rowno="0021">100062022/611</docid><case_no rowno="0021">2022/611</case_no><trn_bor_caseid rowno="0021">15918000006709</trn_bor_caseid><manual_case_no rowno="0021"></manual_case_no><bench_code rowno="0021">14</bench_code><prev_case_purpose rowno="0021">?????? ?????</prev_case_purpose><prev_purpose_code rowno="0021">112</prev_purpose_code><prev_hear_date rowno="0021">04/12/2023</prev_hear_date><next_hear_date rowno="0021">05/02/2024</next_hear_date><new_case_purpose rowno="0021">10035000000979</new_case_purpose><new_purpose_code rowno="0021">112</new_purpose_code><new_purpose_group rowno="0021">19971000000602</new_purpose_group><axp_recid2 rowno="0022">0</axp_recid2><puname rowno="0022">ekta</puname><court_name rowno="0022">11599000000000</court_name><court_code rowno="0022">10006</court_code><docid rowno="0022">100062023/1317</docid><case_no rowno="0022">2023/1317</case_no><trn_bor_caseid rowno="0022">13695000008192</trn_bor_caseid><manual_case_no rowno="0022"></manual_case_no><bench_code rowno="0022">14</bench_code><prev_case_purpose rowno="0022">?????? ????? ????</prev_case_purpose><prev_purpose_code rowno="0022">122</prev_purpose_code><prev_hear_date rowno="0022">04/12/2023</prev_hear_date><next_hear_date rowno="0022">05/02/2024</next_hear_date><new_case_purpose rowno="0022">10110000000719</new_case_purpose><new_purpose_code rowno="0022">122</new_purpose_code><new_purpose_group rowno="0022">19971000000602</new_purpose_group></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"ekta","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"bocup","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtname":"11599000000000","courtcode":"10006","cldate":"04/12/2023","cltype":"R","benchname":"??. ??. (?????)","benchcode":"14","cluser":"","bench_mem1":"0","bench_mem2":"0"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062012/6486","case_no":"2012/6486","trn_bor_caseid":"990109925","manual_case_no":"","bench_code":"14","prev_case_purpose":"???.","prev_purpose_code":"201","prev_hear_date":"04/12/2023","next_hear_date":"08/01/2024","new_case_purpose":"10189000000601","new_purpose_code":"201","new_purpose_group":"19968000000591"}},{"rowno":"002","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062015/6901","case_no":"2015/6901","trn_bor_caseid":"990136093","manual_case_no":"","bench_code":"14","prev_case_purpose":"???.","prev_purpose_code":"201","prev_hear_date":"04/12/2023","next_hear_date":"08/01/2024","new_case_purpose":"10189000000601","new_purpose_code":"201","new_purpose_group":"19968000000591"}},{"rowno":"003","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062018/1585","case_no":"2018/1585","trn_bor_caseid":"14491000001395","manual_case_no":"","bench_code":"14","prev_case_purpose":"???.","prev_purpose_code":"201","prev_hear_date":"04/12/2023","next_hear_date":"22/01/2024","new_case_purpose":"10189000000601","new_purpose_code":"201","new_purpose_group":"19968000000591"}},{"rowno":"004","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062022/7607","case_no":"2022/7607","trn_bor_caseid":"18097000007349","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ??????","prev_purpose_code":"131","prev_hear_date":"04/12/2023","next_hear_date":"18/12/2023","new_case_purpose":"10119000000827","new_purpose_code":"131","new_purpose_group":"19966000000909"}},{"rowno":"005","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062023/500","case_no":"2023/500","trn_bor_caseid":"14667000007493","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ???? ??????","prev_purpose_code":"73","prev_hear_date":"04/12/2023","next_hear_date":"18/12/2023","new_case_purpose":"17553000001243","new_purpose_code":"73","new_purpose_group":"19966000000909"}},{"rowno":"006","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062023/2907","case_no":"2023/2907","trn_bor_caseid":"14027000008055","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"04/12/2023","next_hear_date":"18/12/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"007","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062023/5452","case_no":"2023/5452","trn_bor_caseid":"16675000007847","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ???? ??????","prev_purpose_code":"73","prev_hear_date":"04/12/2023","next_hear_date":"19/12/2023","new_case_purpose":"17553000001243","new_purpose_code":"73","new_purpose_group":"19966000000909"}},{"rowno":"008","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062003/1667","case_no":"2003/1667","trn_bor_caseid":"990031029","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ???? ","prev_purpose_code":"113","prev_hear_date":"04/12/2023","next_hear_date":"22/01/2024","new_case_purpose":"10037000000780","new_purpose_code":"113","new_purpose_group":"19971000000602"}},{"rowno":"009","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062003/10480","case_no":"2003/10480","trn_bor_caseid":"990027785","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ?????","prev_purpose_code":"112","prev_hear_date":"04/12/2023","next_hear_date":"22/01/2024","new_case_purpose":"10035000000979","new_purpose_code":"112","new_purpose_group":"19971000000602"}},{"rowno":"0010","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062013/1262","case_no":"2013/1262","trn_bor_caseid":"990116928","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ?????","prev_purpose_code":"112","prev_hear_date":"04/12/2023","next_hear_date":"05/02/2024","new_case_purpose":"10035000000979","new_purpose_code":"112","new_purpose_group":"19971000000602"}},{"rowno":"0011","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062015/8186","case_no":"2015/8186","trn_bor_caseid":"990146845","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ???? ","prev_purpose_code":"113","prev_hear_date":"04/12/2023","next_hear_date":"05/02/2024","new_case_purpose":"10037000000780","new_purpose_code":"113","new_purpose_group":"19971000000602"}},{"rowno":"0012","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062016/6416","case_no":"2016/6416","trn_bor_caseid":"990143298","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ?????","prev_purpose_code":"112","prev_hear_date":"04/12/2023","next_hear_date":"05/02/2024","new_case_purpose":"10035000000979","new_purpose_code":"112","new_purpose_group":"19971000000602"}},{"rowno":"0013","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062017/2646","case_no":"2017/2646","trn_bor_caseid":"2000154183","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ?????","prev_purpose_code":"112","prev_hear_date":"04/12/2023","next_hear_date":"22/01/2024","new_case_purpose":"10035000000979","new_purpose_code":"112","new_purpose_group":"19971000000602"}},{"rowno":"0014","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062017/5372","case_no":"2017/5372","trn_bor_caseid":"990158828","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"04/12/2023","next_hear_date":"22/01/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0015","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062018/3887","case_no":"2018/3887","trn_bor_caseid":"14077000001981","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ?????","prev_purpose_code":"112","prev_hear_date":"04/12/2023","next_hear_date":"22/01/2024","new_case_purpose":"10035000000979","new_purpose_code":"112","new_purpose_group":"19971000000602"}},{"rowno":"0016","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062018/4450","case_no":"2018/4450","trn_bor_caseid":"10726000002583","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ?????","prev_purpose_code":"112","prev_hear_date":"04/12/2023","next_hear_date":"05/02/2024","new_case_purpose":"10035000000979","new_purpose_code":"112","new_purpose_group":"19971000000602"}},{"rowno":"0017","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062018/8313","case_no":"2018/8313","trn_bor_caseid":"12597000002091","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"04/12/2023","next_hear_date":"05/02/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0018","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062019/2849","case_no":"2019/2849","trn_bor_caseid":"17328000002511","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ???? ","prev_purpose_code":"113","prev_hear_date":"04/12/2023","next_hear_date":"05/02/2024","new_case_purpose":"10037000000780","new_purpose_code":"113","new_purpose_group":"19971000000602"}},{"rowno":"0019","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062021/5803","case_no":"2021/5803","trn_bor_caseid":"14259000006248","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"04/12/2023","next_hear_date":"05/02/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0020","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062022/101","case_no":"2022/101","trn_bor_caseid":"16760000005225","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"04/12/2023","next_hear_date":"05/02/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0021","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062022/611","case_no":"2022/611","trn_bor_caseid":"15918000006709","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ?????","prev_purpose_code":"112","prev_hear_date":"04/12/2023","next_hear_date":"05/02/2024","new_case_purpose":"10035000000979","new_purpose_code":"112","new_purpose_group":"19971000000602"}},{"rowno":"0022","text":"0","columns":{"puname":"ekta","court_name":"11599000000000","court_code":"10006","docid":"100062023/1317","case_no":"2023/1317","trn_bor_caseid":"13695000008192","manual_case_no":"","bench_code":"14","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"04/12/2023","next_hear_date":"05/02/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}}]}]}}
Verifying username and password
User Name : ekta
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=ekta
Time elapsed = 17
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 : ekta
Select sysdate as sdt from dual
Time elapsed = 3
dt=07/12/2023 13:16:36
Select sysdate as sdt from dual
Time elapsed = 4
Select usergroup from AXUSERLEVELGROUPS WHERE (lower(username) =:U) and ((startdate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') >= startdate) or (startdate is null)) and ((enddate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') <= enddate) or (enddate is null))
U=ekta
dt=07/12/2023 13:16:36
dt=07/12/2023 13:16:36
Time elapsed = 9
User Groups: rb_rgroom
select userroles from axusergroups where groupname in ( 'rb_rgroom' )
Time elapsed = 4
User Roles : rb_rgroom
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 = 3
Step4
axprops\stm size:4235
Step4-123456
<root updatedon="20/10/2023 11:27:24" name="app" caption="app" appverno="10.1.0.0" updusername="" updatedby="admin"><props LocalNum="710"><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=ekta
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=ekta
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{court_name})
   Calling function sqlget
   Result of sqlget = BOARD OF REVENUE,AJMER
   Result = BOARD OF REVENUE,AJMER
   Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
   Calling function firesql
username=ekta
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=ekta
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type})
   Calling function sqlget
   Result of sqlget = Revenue Board
   Result = Revenue Board
   Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
   Calling function firesql
username=ekta
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=ekta
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{court_name_mastid})
   Calling function sqlget
   Result of sqlget = 11599000000000
   Result = 11599000000000
   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=ekta
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{axusersid})
   Calling function sqlget
   Result of sqlget = 16351000001672
   Result = 16351000001672
   Evaluating firesql({m4},{select :username as uname from dual})
   Calling function firesql
select :username as uname from dual
username=ekta
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{uname})
   Calling function sqlget
   Result of sqlget = ekta
   Result = ekta
   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=ekta
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{COURT_CODE})
   Calling function sqlget
   Result of sqlget = 10006
   Result = 10006
   Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'})
   Calling function firesql
select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'
Time elapsed = 5
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{STATE_NAME})
   Calling function sqlget
   Result of sqlget = ????????
   Result = ????????
   Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=ekta
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ekta
Time elapsed = 9
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m7},{DISTNAMEENG})
   Calling function sqlget
   Result of sqlget = Ajmer
   Result = Ajmer
   Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=ekta
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=ekta
Time elapsed = 5
   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=16351000001672
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=16351000001672
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=ekta
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type_mastid})
   Calling function sqlget
   Result of sqlget = 10206000000012
   Result = 10206000000012
   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=ekta
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=ekta
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{groupname})
   Calling function sqlget
   Result of sqlget = rb_rgroom
   Result = rb_rgroom
   Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
   Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 4
   Result of firesql = 
   Result = 
   Evaluating  sqlget({a1},{dd})
   Calling function sqlget
   Result of sqlget = 30/01/2021
   Result = 30/01/2021
   Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0})
   Calling function firesql
username=ekta
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=ekta
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({P1},{ct})
   Calling function sqlget
   Result of sqlget = 0
   Result = 0
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('rb_rgroom') and lower(sname)='bocup' and stype = 't' )

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

Paramval : rb_rgroom,bocup,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 = 4
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 : bocup
ParamTYpe : c
Param List : name

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

Time elapsed = 4
Step4
tstructs\stm size:4415
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
   Evaluating dtchk
   Result = 
   Evaluating {NO}
   Result = 
   Evaluating 1
   Result = 
   Evaluating 1
   Result = 
   Evaluating 0
   Result = 
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=bocup
adxinout=o
Time elapsed = 5
select * from trn_bor_mhearing where trn_bor_mhearingid=0
Time elapsed = 3
select * from Axusers where 1=2
Time elapsed = 5
select distinct(fldname) from AxTempUserFields
Time elapsed = 2
select * from AxAttachWorkflow where lower(transid) = 'bocup'
Time elapsed = 4
select distinct(schemaname) from axschema where lower(transid)='rbcrt'
Time elapsed = 3
select trn_bor_caseregid from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 2
select hearingdate from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 3
select distinct(schemaname) from axschema where lower(transid)='rbcrt'
Time elapsed = 3
select case_purpose_name from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 2
select distinct(schemaname) from axschema where lower(transid)='rbcrt'
Time elapsed = 2
select case_purpose_code from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 4
Step3
Sql : select props from tstructs where lower(name)= :name  order by blobno

Paramval : rbchh
ParamTYpe : c
Param List : name

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

Time elapsed = 3
Step4
tstructs\stm size:2091
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=rbchh
adxinout=o
Time elapsed = 5
select * from trn_bor_case_hist where trn_bor_case_histid=0
Time elapsed = 4
   Evaluating date()
   Result = 
   Evaluating {Feedback}
   Result = 
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 bocup

>>Frame No 1
courtname = 11599000000000
courtcode = 10006
cldate = 04/12/2023
cltype = R
benchname = ??. ??. (?????)
benchcode = 14
cluser = 
bench_mem1 = 0
bench_mem2 = 0
time zone difference  = 0

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

Time elapsed = 2
Saving to table TRN_BOR_MHEARING
select * from TRN_BOR_MHEARING where  TRN_BOR_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 = 15632000008559
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
cluser = 
benchcode = 14
bench_mem2 = 0
bench_mem1 = 0
benchname = ??. ??. (?????)
courtcode = 10006
courtname = 11599000000000
cltype = R
cldate = 04/12/2023
Posting record
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:37
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
benchcode=14
Param Type = c
bench_mem2=0
Param Type = c
bench_mem1=0
Param Type = c
benchname=??. ??. (?????)
Param Type = c
courtcode=10006
Param Type = c
courtname=11599000000000
Param Type = c
cltype=R
Param Type = c
cldate=04/12/2023 00:00:00
insert into TRN_BOR_MHEARING (trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,cluser,benchcode,bench_mem2,bench_mem1,benchname,courtcode,courtname,cltype,cldate) values (:trn_bor_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,:benchcode,:bench_mem2,:bench_mem1,:benchname,:courtcode,:courtname,:cltype,to_date(:cldate,'dd/mm/yyyy hh24:mi:ss'))

Saving to table TRN_BOR_HEARING
select * from TRN_BOR_HEARING where  TRN_BOR_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 = 4
RecordId = 15632000008560
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
case_no = 2012/6486
trn_bor_caseid = 990109925
manual_case_no = 
docid = 100062012/6486
puname = ekta
court_name = 11599000000000
court_code = 10006
new_purpose_code = 201
new_purpose_group = 19968000000591
next_hear_date = 08/01/2024
new_case_purpose = 10189000000601
bench_code = 14
prev_purpose_code = 201
prev_hear_date = 04/12/2023
TRN_BOR_HEARINGrow = 1
Posting record
Param Type = n
trn_bor_hearingid=15632000008560
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:37
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2012/6486
Param Type = n
trn_bor_caseid=990109925
Param Type = c
docid=100062012/6486
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=201
Param Type = n
new_purpose_group=19968000000591
Param Type = c
next_hear_date=08/01/2024 00:00:00
Param Type = c
new_case_purpose=10189000000601
Param Type = c
bench_code=14
Param Type = c
prev_purpose_code=201
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = n
trn_bor_hearingrow=1
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow)

select * from TRN_BOR_HEARING where  TRN_BOR_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 = 3
RecordId = 15632000008561
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 2
case_no = 2015/6901
trn_bor_caseid = 990136093
manual_case_no = 
docid = 100062015/6901
puname = ekta
court_name = 11599000000000
court_code = 10006
new_purpose_code = 201
new_purpose_group = 19968000000591
next_hear_date = 08/01/2024
new_case_purpose = 10189000000601
bench_code = 14
prev_purpose_code = 201
prev_hear_date = 04/12/2023
TRN_BOR_HEARINGrow = 2
Posting record
Param Type = n
trn_bor_hearingid=15632000008561
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:37
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2015/6901
Param Type = n
trn_bor_caseid=990136093
Param Type = c
docid=100062015/6901
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=201
Param Type = n
new_purpose_group=19968000000591
Param Type = c
next_hear_date=08/01/2024 00:00:00
Param Type = c
new_case_purpose=10189000000601
Param Type = c
bench_code=14
Param Type = c
prev_purpose_code=201
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = n
trn_bor_hearingrow=2
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow)

select * from TRN_BOR_HEARING where  TRN_BOR_HEARINGid=0
Time elapsed = 4
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 = 15632000008562
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
trn_bor_caseid = 14491000001395
manual_case_no = 
bench_code = 14
court_code = 10006
docid = 100062018/1585
case_no = 2018/1585
new_purpose_code = 201
new_purpose_group = 19968000000591
next_hear_date = 22/01/2024
prev_purpose_code = 201
prev_hear_date = 04/12/2023
new_case_purpose = 10189000000601
puname = ekta
court_name = 11599000000000
TRN_BOR_HEARINGrow = 3
Posting record
Param Type = n
trn_bor_hearingid=15632000008562
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:37
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
trn_bor_caseid=14491000001395
Param Type = c
bench_code=14
Param Type = c
court_code=10006
Param Type = c
docid=100062018/1585
Param Type = c
case_no=2018/1585
Param Type = c
new_purpose_code=201
Param Type = n
new_purpose_group=19968000000591
Param Type = c
next_hear_date=22/01/2024 00:00:00
Param Type = c
prev_purpose_code=201
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
new_case_purpose=10189000000601
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = n
trn_bor_hearingrow=3
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trn_bor_caseid,manual_case_no,bench_code,court_code,docid,case_no,new_purpose_code,new_purpose_group,next_hear_date,prev_purpose_code,prev_hear_date,new_case_purpose,puname,court_name,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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_bor_caseid,null,:bench_code,:court_code,:docid,:case_no,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:puname,:court_name,:trn_bor_hearingrow)

select * from TRN_BOR_HEARING where  TRN_BOR_HEARINGid=0
Time elapsed = 4
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 = 15632000008563
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
manual_case_no = 
bench_code = 14
case_no = 2022/7607
trn_bor_caseid = 18097000007349
puname = ekta
court_name = 11599000000000
court_code = 10006
new_purpose_code = 131
new_purpose_group = 19966000000909
next_hear_date = 18/12/2023
new_case_purpose = 10119000000827
prev_purpose_code = 131
prev_hear_date = 04/12/2023
docid = 100062022/7607
TRN_BOR_HEARINGrow = 4
Posting record
Param Type = n
trn_bor_hearingid=15632000008563
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:37
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
bench_code=14
Param Type = c
case_no=2022/7607
Param Type = n
trn_bor_caseid=18097000007349
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=131
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=18/12/2023 00:00:00
Param Type = c
new_case_purpose=10119000000827
Param Type = c
prev_purpose_code=131
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
docid=100062022/7607
Param Type = n
trn_bor_hearingrow=4
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,manual_case_no,bench_code,case_no,trn_bor_caseid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,prev_purpose_code,prev_hear_date,docid,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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,:bench_code,:case_no,:trn_bor_caseid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:docid,:trn_bor_hearingrow)

select * from TRN_BOR_HEARING where  TRN_BOR_HEARINGid=0
Time elapsed = 5
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 = 15632000008564
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2023/500
trn_bor_caseid = 14667000007493
manual_case_no = 
docid = 100062023/500
puname = ekta
court_name = 11599000000000
court_code = 10006
new_purpose_code = 73
new_purpose_group = 19966000000909
next_hear_date = 18/12/2023
new_case_purpose = 17553000001243
bench_code = 14
prev_purpose_code = 73
prev_hear_date = 04/12/2023
TRN_BOR_HEARINGrow = 5
Posting record
Param Type = n
trn_bor_hearingid=15632000008564
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:37
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/500
Param Type = n
trn_bor_caseid=14667000007493
Param Type = c
docid=100062023/500
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=73
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=18/12/2023 00:00:00
Param Type = c
new_case_purpose=17553000001243
Param Type = c
bench_code=14
Param Type = c
prev_purpose_code=73
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = n
trn_bor_hearingrow=5
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow)

select * from TRN_BOR_HEARING where  TRN_BOR_HEARINGid=0
Time elapsed = 5
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 = 15632000008565
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
prev_purpose_code = 121
next_hear_date = 18/12/2023
bench_code = 14
new_purpose_code = 121
new_case_purpose = 10109000001043
prev_hear_date = 04/12/2023
manual_case_no = 
court_code = 10006
court_name = 11599000000000
puname = ekta
trn_bor_caseid = 14027000008055
case_no = 2023/2907
docid = 100062023/2907
new_purpose_group = 19966000000909
TRN_BOR_HEARINGrow = 6
Posting record
Param Type = n
trn_bor_hearingid=15632000008565
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:38
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_purpose_code=121
Param Type = c
next_hear_date=18/12/2023 00:00:00
Param Type = c
bench_code=14
Param Type = c
new_purpose_code=121
Param Type = c
new_case_purpose=10109000001043
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
puname=ekta
Param Type = n
trn_bor_caseid=14027000008055
Param Type = c
case_no=2023/2907
Param Type = c
docid=100062023/2907
Param Type = n
new_purpose_group=19966000000909
Param Type = n
trn_bor_hearingrow=6
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_purpose_code,next_hear_date,bench_code,new_purpose_code,new_case_purpose,prev_hear_date,manual_case_no,court_code,court_name,puname,trn_bor_caseid,case_no,docid,new_purpose_group,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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,:prev_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,:new_purpose_code,:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:court_name,:puname,:trn_bor_caseid,:case_no,:docid,:new_purpose_group,:trn_bor_hearingrow)

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

Time elapsed = 3
RecordId = 15632000008566
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
manual_case_no = 
bench_code = 14
puname = ekta
trn_bor_caseid = 16675000007847
court_code = 10006
docid = 100062023/5452
case_no = 2023/5452
new_purpose_code = 73
new_purpose_group = 19966000000909
next_hear_date = 19/12/2023
new_case_purpose = 17553000001243
court_name = 11599000000000
prev_purpose_code = 73
prev_hear_date = 04/12/2023
TRN_BOR_HEARINGrow = 7
Posting record
Param Type = n
trn_bor_hearingid=15632000008566
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:38
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
bench_code=14
Param Type = c
puname=ekta
Param Type = n
trn_bor_caseid=16675000007847
Param Type = c
court_code=10006
Param Type = c
docid=100062023/5452
Param Type = c
case_no=2023/5452
Param Type = c
new_purpose_code=73
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=19/12/2023 00:00:00
Param Type = c
new_case_purpose=17553000001243
Param Type = c
court_name=11599000000000
Param Type = c
prev_purpose_code=73
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = n
trn_bor_hearingrow=7
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,manual_case_no,bench_code,puname,trn_bor_caseid,court_code,docid,case_no,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,court_name,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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,:bench_code,:puname,:trn_bor_caseid,:court_code,:docid,:case_no,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:court_name,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow)

select * from TRN_BOR_HEARING where  TRN_BOR_HEARINGid=0
Time elapsed = 4
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 = 15632000008567
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2003/1667
trn_bor_caseid = 990031029
manual_case_no = 
docid = 100062003/1667
puname = ekta
court_name = 11599000000000
court_code = 10006
new_purpose_code = 113
new_purpose_group = 19971000000602
next_hear_date = 22/01/2024
new_case_purpose = 10037000000780
bench_code = 14
prev_purpose_code = 113
prev_hear_date = 04/12/2023
TRN_BOR_HEARINGrow = 8
Posting record
Param Type = n
trn_bor_hearingid=15632000008567
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:38
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2003/1667
Param Type = n
trn_bor_caseid=990031029
Param Type = c
docid=100062003/1667
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=113
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=22/01/2024 00:00:00
Param Type = c
new_case_purpose=10037000000780
Param Type = c
bench_code=14
Param Type = c
prev_purpose_code=113
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = n
trn_bor_hearingrow=8
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow)

select * from TRN_BOR_HEARING where  TRN_BOR_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 = 2
RecordId = 15632000008568
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 22/01/2024
prev_purpose_code = 112
new_purpose_group = 19971000000602
bench_code = 14
new_purpose_code = 112
new_case_purpose = 10035000000979
prev_hear_date = 04/12/2023
manual_case_no = 
court_code = 10006
court_name = 11599000000000
puname = ekta
trn_bor_caseid = 990027785
case_no = 2003/10480
docid = 100062003/10480
TRN_BOR_HEARINGrow = 9
Posting record
Param Type = n
trn_bor_hearingid=15632000008568
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:38
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=22/01/2024 00:00:00
Param Type = c
prev_purpose_code=112
Param Type = n
new_purpose_group=19971000000602
Param Type = c
bench_code=14
Param Type = c
new_purpose_code=112
Param Type = c
new_case_purpose=10035000000979
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
puname=ekta
Param Type = n
trn_bor_caseid=990027785
Param Type = c
case_no=2003/10480
Param Type = c
docid=100062003/10480
Param Type = n
trn_bor_hearingrow=9
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,prev_purpose_code,new_purpose_group,bench_code,new_purpose_code,new_case_purpose,prev_hear_date,manual_case_no,court_code,court_name,puname,trn_bor_caseid,case_no,docid,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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'),:prev_purpose_code,:new_purpose_group,:bench_code,:new_purpose_code,:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:court_code,:court_name,:puname,:trn_bor_caseid,:case_no,:docid,:trn_bor_hearingrow)

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

Time elapsed = 3
RecordId = 15632000008569
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 05/02/2024
docid = 100062013/1262
case_no = 2013/1262
trn_bor_caseid = 990116928
puname = ekta
court_name = 11599000000000
court_code = 10006
manual_case_no = 
new_case_purpose = 10035000000979
new_purpose_code = 112
new_purpose_group = 19971000000602
bench_code = 14
prev_purpose_code = 112
prev_hear_date = 04/12/2023
TRN_BOR_HEARINGrow = 10
Posting record
Param Type = n
trn_bor_hearingid=15632000008569
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:38
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/02/2024 00:00:00
Param Type = c
docid=100062013/1262
Param Type = c
case_no=2013/1262
Param Type = n
trn_bor_caseid=990116928
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_case_purpose=10035000000979
Param Type = c
new_purpose_code=112
Param Type = n
new_purpose_group=19971000000602
Param Type = c
bench_code=14
Param Type = c
prev_purpose_code=112
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = n
trn_bor_hearingrow=10
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,docid,case_no,trn_bor_caseid,puname,court_name,court_code,manual_case_no,new_case_purpose,new_purpose_code,new_purpose_group,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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'),:docid,:case_no,:trn_bor_caseid,:puname,:court_name,:court_code,null,:new_case_purpose,:new_purpose_code,:new_purpose_group,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow)

select * from TRN_BOR_HEARING where  TRN_BOR_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 = 2
RecordId = 15632000008570
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 05/02/2024
new_purpose_group = 19971000000602
manual_case_no = 
puname = ekta
court_name = 11599000000000
prev_purpose_code = 113
bench_code = 14
new_case_purpose = 10037000000780
prev_hear_date = 04/12/2023
trn_bor_caseid = 990146845
new_purpose_code = 113
court_code = 10006
docid = 100062015/8186
case_no = 2015/8186
TRN_BOR_HEARINGrow = 11
Posting record
Param Type = n
trn_bor_hearingid=15632000008570
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:38
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=05/02/2024 00:00:00
Param Type = n
new_purpose_group=19971000000602
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = c
prev_purpose_code=113
Param Type = c
bench_code=14
Param Type = c
new_case_purpose=10037000000780
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = n
trn_bor_caseid=990146845
Param Type = c
new_purpose_code=113
Param Type = c
court_code=10006
Param Type = c
docid=100062015/8186
Param Type = c
case_no=2015/8186
Param Type = n
trn_bor_hearingrow=11
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_purpose_group,manual_case_no,puname,court_name,prev_purpose_code,bench_code,new_case_purpose,prev_hear_date,trn_bor_caseid,new_purpose_code,court_code,docid,case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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_purpose_group,null,:puname,:court_name,:prev_purpose_code,:bench_code,:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_caseid,:new_purpose_code,:court_code,:docid,:case_no,:trn_bor_hearingrow)

select * from TRN_BOR_HEARING where  TRN_BOR_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 = 3
RecordId = 15632000008571
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
new_purpose_group = 19971000000602
next_hear_date = 05/02/2024
docid = 100062016/6416
case_no = 2016/6416
trn_bor_caseid = 990143298
puname = ekta
court_name = 11599000000000
court_code = 10006
prev_hear_date = 04/12/2023
new_case_purpose = 10035000000979
new_purpose_code = 112
manual_case_no = 
bench_code = 14
prev_purpose_code = 112
TRN_BOR_HEARINGrow = 12
Posting record
Param Type = n
trn_bor_hearingid=15632000008571
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:38
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=05/02/2024 00:00:00
Param Type = c
docid=100062016/6416
Param Type = c
case_no=2016/6416
Param Type = n
trn_bor_caseid=990143298
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
new_case_purpose=10035000000979
Param Type = c
new_purpose_code=112
Param Type = c
bench_code=14
Param Type = c
prev_purpose_code=112
Param Type = n
trn_bor_hearingrow=12
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_group,next_hear_date,docid,case_no,trn_bor_caseid,puname,court_name,court_code,prev_hear_date,new_case_purpose,new_purpose_code,manual_case_no,bench_code,prev_purpose_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:docid,:case_no,:trn_bor_caseid,:puname,:court_name,:court_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:new_purpose_code,null,:bench_code,:prev_purpose_code,:trn_bor_hearingrow)

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

Time elapsed = 4
RecordId = 15632000008572
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
new_purpose_group = 19971000000602
next_hear_date = 22/01/2024
new_purpose_code = 112
docid = 100062017/2646
case_no = 2017/2646
court_code = 10006
puname = ekta
court_name = 11599000000000
trn_bor_caseid = 2000154183
prev_hear_date = 04/12/2023
new_case_purpose = 10035000000979
prev_purpose_code = 112
manual_case_no = 
bench_code = 14
TRN_BOR_HEARINGrow = 13
Posting record
Param Type = n
trn_bor_hearingid=15632000008572
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:38
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=22/01/2024 00:00:00
Param Type = c
new_purpose_code=112
Param Type = c
docid=100062017/2646
Param Type = c
case_no=2017/2646
Param Type = c
court_code=10006
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = n
trn_bor_caseid=2000154183
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
new_case_purpose=10035000000979
Param Type = c
prev_purpose_code=112
Param Type = c
bench_code=14
Param Type = n
trn_bor_hearingrow=13
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_group,next_hear_date,new_purpose_code,docid,case_no,court_code,puname,court_name,trn_bor_caseid,prev_hear_date,new_case_purpose,prev_purpose_code,manual_case_no,bench_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_code,:docid,:case_no,:court_code,:puname,:court_name,:trn_bor_caseid,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:prev_purpose_code,null,:bench_code,:trn_bor_hearingrow)

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

Time elapsed = 3
RecordId = 15632000008573
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
new_purpose_code = 122
new_purpose_group = 19971000000602
next_hear_date = 22/01/2024
court_code = 10006
docid = 100062017/5372
court_name = 11599000000000
bench_code = 14
puname = ekta
case_no = 2017/5372
prev_hear_date = 04/12/2023
new_case_purpose = 10110000000719
prev_purpose_code = 122
trn_bor_caseid = 990158828
manual_case_no = 
TRN_BOR_HEARINGrow = 14
Posting record
Param Type = n
trn_bor_hearingid=15632000008573
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:38
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_purpose_code=122
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=22/01/2024 00:00:00
Param Type = c
court_code=10006
Param Type = c
docid=100062017/5372
Param Type = c
court_name=11599000000000
Param Type = c
bench_code=14
Param Type = c
puname=ekta
Param Type = c
case_no=2017/5372
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
new_case_purpose=10110000000719
Param Type = c
prev_purpose_code=122
Param Type = n
trn_bor_caseid=990158828
Param Type = n
trn_bor_hearingrow=14
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_code,new_purpose_group,next_hear_date,court_code,docid,court_name,bench_code,puname,case_no,prev_hear_date,new_case_purpose,prev_purpose_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:docid,:court_name,:bench_code,:puname,:case_no,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:prev_purpose_code,:trn_bor_caseid,null,:trn_bor_hearingrow)

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

Time elapsed = 3
RecordId = 15632000008574
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
new_purpose_code = 112
new_purpose_group = 19971000000602
next_hear_date = 22/01/2024
new_case_purpose = 10035000000979
docid = 100062018/3887
case_no = 2018/3887
court_code = 10006
puname = ekta
court_name = 11599000000000
prev_purpose_code = 112
prev_hear_date = 04/12/2023
bench_code = 14
trn_bor_caseid = 14077000001981
manual_case_no = 
TRN_BOR_HEARINGrow = 15
Posting record
Param Type = n
trn_bor_hearingid=15632000008574
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:38
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_purpose_code=112
Param Type = n
new_purpose_group=19971000000602
Param Type = c
next_hear_date=22/01/2024 00:00:00
Param Type = c
new_case_purpose=10035000000979
Param Type = c
docid=100062018/3887
Param Type = c
case_no=2018/3887
Param Type = c
court_code=10006
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = c
prev_purpose_code=112
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
bench_code=14
Param Type = n
trn_bor_caseid=14077000001981
Param Type = n
trn_bor_hearingrow=15
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,docid,case_no,court_code,puname,court_name,prev_purpose_code,prev_hear_date,bench_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:docid,:case_no,:court_code,:puname,:court_name,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,:trn_bor_caseid,null,:trn_bor_hearingrow)

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

Time elapsed = 3
RecordId = 15632000008575
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
new_purpose_code = 112
new_case_purpose = 10035000000979
next_hear_date = 05/02/2024
new_purpose_group = 19971000000602
docid = 100062018/4450
case_no = 2018/4450
court_code = 10006
puname = ekta
court_name = 11599000000000
prev_purpose_code = 112
prev_hear_date = 04/12/2023
bench_code = 14
trn_bor_caseid = 10726000002583
manual_case_no = 
TRN_BOR_HEARINGrow = 16
Posting record
Param Type = n
trn_bor_hearingid=15632000008575
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:38
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_purpose_code=112
Param Type = c
new_case_purpose=10035000000979
Param Type = c
next_hear_date=05/02/2024 00:00:00
Param Type = n
new_purpose_group=19971000000602
Param Type = c
docid=100062018/4450
Param Type = c
case_no=2018/4450
Param Type = c
court_code=10006
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = c
prev_purpose_code=112
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
bench_code=14
Param Type = n
trn_bor_caseid=10726000002583
Param Type = n
trn_bor_hearingrow=16
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,docid,case_no,court_code,puname,court_name,prev_purpose_code,prev_hear_date,bench_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:docid,:case_no,:court_code,:puname,:court_name,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,:trn_bor_caseid,null,:trn_bor_hearingrow)

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

Time elapsed = 4
RecordId = 15632000008576
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
new_case_purpose = 10110000000719
new_purpose_code = 122
next_hear_date = 05/02/2024
new_purpose_group = 19971000000602
prev_hear_date = 04/12/2023
court_name = 11599000000000
puname = ekta
case_no = 2018/8313
court_code = 10006
docid = 100062018/8313
bench_code = 14
prev_purpose_code = 122
trn_bor_caseid = 12597000002091
manual_case_no = 
TRN_BOR_HEARINGrow = 17
Posting record
Param Type = n
trn_bor_hearingid=15632000008576
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:38
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=10110000000719
Param Type = c
new_purpose_code=122
Param Type = c
next_hear_date=05/02/2024 00:00:00
Param Type = n
new_purpose_group=19971000000602
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
court_name=11599000000000
Param Type = c
puname=ekta
Param Type = c
case_no=2018/8313
Param Type = c
court_code=10006
Param Type = c
docid=100062018/8313
Param Type = c
bench_code=14
Param Type = c
prev_purpose_code=122
Param Type = n
trn_bor_caseid=12597000002091
Param Type = n
trn_bor_hearingrow=17
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,new_purpose_code,next_hear_date,new_purpose_group,prev_hear_date,court_name,puname,case_no,court_code,docid,bench_code,prev_purpose_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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,:new_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_name,:puname,:case_no,:court_code,:docid,:bench_code,:prev_purpose_code,:trn_bor_caseid,null,:trn_bor_hearingrow)

select * from TRN_BOR_HEARING where  TRN_BOR_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 = 3
RecordId = 15632000008577
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
new_case_purpose = 10037000000780
prev_hear_date = 04/12/2023
next_hear_date = 05/02/2024
new_purpose_group = 19971000000602
new_purpose_code = 113
court_code = 10006
docid = 100062019/2849
puname = ekta
court_name = 11599000000000
case_no = 2019/2849
bench_code = 14
prev_purpose_code = 113
trn_bor_caseid = 17328000002511
manual_case_no = 
TRN_BOR_HEARINGrow = 18
Posting record
Param Type = n
trn_bor_hearingid=15632000008577
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:39
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=10037000000780
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
next_hear_date=05/02/2024 00:00:00
Param Type = n
new_purpose_group=19971000000602
Param Type = c
new_purpose_code=113
Param Type = c
court_code=10006
Param Type = c
docid=100062019/2849
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = c
case_no=2019/2849
Param Type = c
bench_code=14
Param Type = c
prev_purpose_code=113
Param Type = n
trn_bor_caseid=17328000002511
Param Type = n
trn_bor_hearingrow=18
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,prev_hear_date,next_hear_date,new_purpose_group,new_purpose_code,court_code,docid,puname,court_name,case_no,bench_code,prev_purpose_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:docid,:puname,:court_name,:case_no,:bench_code,:prev_purpose_code,:trn_bor_caseid,null,:trn_bor_hearingrow)

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

Time elapsed = 4
RecordId = 15632000008578
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 2
Select sysdate as sdt from dual
Time elapsed = 3
new_case_purpose = 10110000000719
prev_hear_date = 04/12/2023
next_hear_date = 05/02/2024
new_purpose_group = 19971000000602
new_purpose_code = 122
prev_purpose_code = 122
court_code = 10006
docid = 100062021/5803
puname = ekta
court_name = 11599000000000
manual_case_no = 
bench_code = 14
case_no = 2021/5803
trn_bor_caseid = 14259000006248
TRN_BOR_HEARINGrow = 19
Posting record
Param Type = n
trn_bor_hearingid=15632000008578
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:39
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=10110000000719
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
next_hear_date=05/02/2024 00:00:00
Param Type = n
new_purpose_group=19971000000602
Param Type = c
new_purpose_code=122
Param Type = c
prev_purpose_code=122
Param Type = c
court_code=10006
Param Type = c
docid=100062021/5803
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = c
bench_code=14
Param Type = c
case_no=2021/5803
Param Type = n
trn_bor_caseid=14259000006248
Param Type = n
trn_bor_hearingrow=19
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,prev_hear_date,next_hear_date,new_purpose_group,new_purpose_code,prev_purpose_code,court_code,docid,puname,court_name,manual_case_no,bench_code,case_no,trn_bor_caseid,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:prev_purpose_code,:court_code,:docid,:puname,:court_name,null,:bench_code,:case_no,:trn_bor_caseid,:trn_bor_hearingrow)

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

Time elapsed = 5
RecordId = 15632000008579
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
prev_hear_date = 04/12/2023
prev_purpose_code = 122
new_case_purpose = 10110000000719
next_hear_date = 05/02/2024
new_purpose_group = 19971000000602
new_purpose_code = 122
court_code = 10006
docid = 100062022/101
court_name = 11599000000000
puname = ekta
manual_case_no = 
bench_code = 14
case_no = 2022/101
trn_bor_caseid = 16760000005225
TRN_BOR_HEARINGrow = 20
Posting record
Param Type = n
trn_bor_hearingid=15632000008579
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:39
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
prev_purpose_code=122
Param Type = c
new_case_purpose=10110000000719
Param Type = c
next_hear_date=05/02/2024 00:00:00
Param Type = n
new_purpose_group=19971000000602
Param Type = c
new_purpose_code=122
Param Type = c
court_code=10006
Param Type = c
docid=100062022/101
Param Type = c
court_name=11599000000000
Param Type = c
puname=ekta
Param Type = c
bench_code=14
Param Type = c
case_no=2022/101
Param Type = n
trn_bor_caseid=16760000005225
Param Type = n
trn_bor_hearingrow=20
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,court_code,docid,court_name,puname,manual_case_no,bench_code,case_no,trn_bor_caseid,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:docid,:court_name,:puname,null,:bench_code,:case_no,:trn_bor_caseid,:trn_bor_hearingrow)

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

Time elapsed = 3
RecordId = 15632000008580
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
prev_hear_date = 04/12/2023
prev_purpose_code = 112
new_case_purpose = 10035000000979
next_hear_date = 05/02/2024
new_purpose_group = 19971000000602
new_purpose_code = 112
court_code = 10006
docid = 100062022/611
puname = ekta
court_name = 11599000000000
manual_case_no = 
bench_code = 14
case_no = 2022/611
trn_bor_caseid = 15918000006709
TRN_BOR_HEARINGrow = 21
Posting record
Param Type = n
trn_bor_hearingid=15632000008580
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:39
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
prev_purpose_code=112
Param Type = c
new_case_purpose=10035000000979
Param Type = c
next_hear_date=05/02/2024 00:00:00
Param Type = n
new_purpose_group=19971000000602
Param Type = c
new_purpose_code=112
Param Type = c
court_code=10006
Param Type = c
docid=100062022/611
Param Type = c
puname=ekta
Param Type = c
court_name=11599000000000
Param Type = c
bench_code=14
Param Type = c
case_no=2022/611
Param Type = n
trn_bor_caseid=15918000006709
Param Type = n
trn_bor_hearingrow=21
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,court_code,docid,puname,court_name,manual_case_no,bench_code,case_no,trn_bor_caseid,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:docid,:puname,:court_name,null,:bench_code,:case_no,:trn_bor_caseid,:trn_bor_hearingrow)

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

Time elapsed = 4
RecordId = 15632000008581
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_hear_date = 04/12/2023
prev_purpose_code = 122
new_case_purpose = 10110000000719
next_hear_date = 05/02/2024
new_purpose_group = 19971000000602
new_purpose_code = 122
bench_code = 14
court_code = 10006
court_name = 11599000000000
puname = ekta
docid = 100062023/1317
manual_case_no = 
trn_bor_caseid = 13695000008192
case_no = 2023/1317
TRN_BOR_HEARINGrow = 22
Posting record
Param Type = n
trn_bor_hearingid=15632000008581
Param Type = n
trn_bor_mhearingid=15632000008559
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:39
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=04/12/2023 00:00:00
Param Type = c
prev_purpose_code=122
Param Type = c
new_case_purpose=10110000000719
Param Type = c
next_hear_date=05/02/2024 00:00:00
Param Type = n
new_purpose_group=19971000000602
Param Type = c
new_purpose_code=122
Param Type = c
bench_code=14
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
puname=ekta
Param Type = c
docid=100062023/1317
Param Type = n
trn_bor_caseid=13695000008192
Param Type = c
case_no=2023/1317
Param Type = n
trn_bor_hearingrow=22
insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,bench_code,court_code,court_name,puname,docid,manual_case_no,trn_bor_caseid,case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_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(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:bench_code,:court_code,:court_name,:puname,:docid,null,:trn_bor_caseid,:case_no,:trn_bor_hearingrow)

Time elapsed for insert/update = 3911116555017

>>Executing genmaps

>>Posting from bocup to rbchh from row 1

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2012/6486 idvalue 0
Mapped hearing_date Row = 1 value = 08/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???. idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 990109925 idvalue 0
Mapped case_docid Row = 1 value = 100062012/6486 idvalue 0
Mapped case_purpose Row = 1 value = 10189000000601 idvalue 0
Mapped case_purpose_code Row = 1 value = 201 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 990109925
case_docid = 100062012/6486
case_no = 2012/6486
prev_hearing_date = 04/12/2023
hearing_date = 08/01/2024
prev_case_purposename = ???.
prev_case_purpose = 
prev_case_purposename=???.
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=???.
Time elapsed = 5
prev_case_purpose after validation = 10189000000601
case_purpose = 10189000000601
case_purpose_code = 201
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 15632000008582
MapName bocup1
SourceId 15632000008560
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
prev_case_purpose = 10189000000601
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 201
hearing_date = 08/01/2024
prev_case_purposename = ???.
court_code = 10006
case_no = 2012/6486
case_docid = 100062012/6486
case_purpose = 10189000000601
trn_bor_caseregid = 990109925
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008582
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008560
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:39
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10189000000601
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=201
Param Type = c
hearing_date=08/01/2024 00:00:00
Param Type = c
prev_case_purposename=???.
Param Type = c
court_code=10006
Param Type = c
case_no=2012/6486
Param Type = c
case_docid=100062012/6486
Param Type = c
case_purpose=10189000000601
Param Type = n
trn_bor_caseregid=990109925
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 2

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2015/6901 idvalue 0
Mapped hearing_date Row = 1 value = 08/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???. idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 990136093 idvalue 0
Mapped case_docid Row = 1 value = 100062015/6901 idvalue 0
Mapped case_purpose Row = 1 value = 10189000000601 idvalue 0
Mapped case_purpose_code Row = 1 value = 201 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 990136093
case_docid = 100062015/6901
case_no = 2015/6901
prev_hearing_date = 04/12/2023
hearing_date = 08/01/2024
prev_case_purposename = ???.
prev_case_purpose = 
prev_case_purpose after validation = 10189000000601
case_purpose = 10189000000601
case_purpose_code = 201
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_CASE_HISTid=0
Time elapsed = 506
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 = 15632000008583
MapName bocup1
SourceId 15632000008561
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10189000000601
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 201
hearing_date = 08/01/2024
prev_case_purposename = ???.
court_code = 10006
case_no = 2015/6901
case_docid = 100062015/6901
case_purpose = 10189000000601
trn_bor_caseregid = 990136093
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008583
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008561
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:40
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10189000000601
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=201
Param Type = c
hearing_date=08/01/2024 00:00:00
Param Type = c
prev_case_purposename=???.
Param Type = c
court_code=10006
Param Type = c
case_no=2015/6901
Param Type = c
case_docid=100062015/6901
Param Type = c
case_purpose=10189000000601
Param Type = n
trn_bor_caseregid=990136093
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 3

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2018/1585 idvalue 0
Mapped hearing_date Row = 1 value = 22/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???. idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 14491000001395 idvalue 0
Mapped case_docid Row = 1 value = 100062018/1585 idvalue 0
Mapped case_purpose Row = 1 value = 10189000000601 idvalue 0
Mapped case_purpose_code Row = 1 value = 201 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 14491000001395
case_docid = 100062018/1585
case_no = 2018/1585
prev_hearing_date = 04/12/2023
hearing_date = 22/01/2024
prev_case_purposename = ???.
prev_case_purpose = 
prev_case_purpose after validation = 10189000000601
case_purpose = 10189000000601
case_purpose_code = 201
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 15632000008584
MapName bocup1
SourceId 15632000008562
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10189000000601
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 201
hearing_date = 22/01/2024
prev_case_purposename = ???.
court_code = 10006
case_no = 2018/1585
case_docid = 100062018/1585
case_purpose = 10189000000601
trn_bor_caseregid = 14491000001395
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008584
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008562
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:40
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10189000000601
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=201
Param Type = c
hearing_date=22/01/2024 00:00:00
Param Type = c
prev_case_purposename=???.
Param Type = c
court_code=10006
Param Type = c
case_no=2018/1585
Param Type = c
case_docid=100062018/1585
Param Type = c
case_purpose=10189000000601
Param Type = n
trn_bor_caseregid=14491000001395
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 4

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2022/7607 idvalue 0
Mapped hearing_date Row = 1 value = 18/12/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ?????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 18097000007349 idvalue 0
Mapped case_docid Row = 1 value = 100062022/7607 idvalue 0
Mapped case_purpose Row = 1 value = 10119000000827 idvalue 0
Mapped case_purpose_code Row = 1 value = 131 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 18097000007349
case_docid = 100062022/7607
case_no = 2022/7607
prev_hearing_date = 04/12/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 = 4
prev_case_purpose after validation = 10119000000827
case_purpose = 10119000000827
case_purpose_code = 131
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 15632000008585
MapName bocup1
SourceId 15632000008563
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10119000000827
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 131
hearing_date = 18/12/2023
prev_case_purposename = ?????? ??????
court_code = 10006
case_no = 2022/7607
case_docid = 100062022/7607
case_purpose = 10119000000827
trn_bor_caseregid = 18097000007349
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008585
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008563
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:40
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10119000000827
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=131
Param Type = c
hearing_date=18/12/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ??????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/7607
Param Type = c
case_docid=100062022/7607
Param Type = c
case_purpose=10119000000827
Param Type = n
trn_bor_caseregid=18097000007349
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 5

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2023/500 idvalue 0
Mapped hearing_date Row = 1 value = 18/12/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? ?????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 14667000007493 idvalue 0
Mapped case_docid Row = 1 value = 100062023/500 idvalue 0
Mapped case_purpose Row = 1 value = 17553000001243 idvalue 0
Mapped case_purpose_code Row = 1 value = 73 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 14667000007493
case_docid = 100062023/500
case_no = 2023/500
prev_hearing_date = 04/12/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 = 5
prev_case_purpose after validation = 17553000001243
case_purpose = 17553000001243
case_purpose_code = 73
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 15632000008586
MapName bocup1
SourceId 15632000008564
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 17553000001243
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 73
hearing_date = 18/12/2023
prev_case_purposename = ?????? ???? ??????
court_code = 10006
case_no = 2023/500
case_docid = 100062023/500
case_purpose = 17553000001243
trn_bor_caseregid = 14667000007493
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008586
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008564
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:40
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=17553000001243
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=73
Param Type = c
hearing_date=18/12/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ???? ??????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/500
Param Type = c
case_docid=100062023/500
Param Type = c
case_purpose=17553000001243
Param Type = n
trn_bor_caseregid=14667000007493
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 6

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2023/2907 idvalue 0
Mapped hearing_date Row = 1 value = 18/12/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 14027000008055 idvalue 0
Mapped case_docid Row = 1 value = 100062023/2907 idvalue 0
Mapped case_purpose Row = 1 value = 10109000001043 idvalue 0
Mapped case_purpose_code Row = 1 value = 121 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 14027000008055
case_docid = 100062023/2907
case_no = 2023/2907
prev_hearing_date = 04/12/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 = 5
prev_case_purpose after validation = 10109000001043
case_purpose = 10109000001043
case_purpose_code = 121
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

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

Time elapsed = 4
RecordId = 15632000008587
MapName bocup1
SourceId 15632000008565
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10109000001043
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 18/12/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/2907
case_docid = 100062023/2907
case_purpose = 10109000001043
trn_bor_caseregid = 14027000008055
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008587
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008565
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:40
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10109000001043
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=121
Param Type = c
hearing_date=18/12/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/2907
Param Type = c
case_docid=100062023/2907
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=14027000008055
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 7

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2023/5452 idvalue 0
Mapped hearing_date Row = 1 value = 19/12/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? ?????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 16675000007847 idvalue 0
Mapped case_docid Row = 1 value = 100062023/5452 idvalue 0
Mapped case_purpose Row = 1 value = 17553000001243 idvalue 0
Mapped case_purpose_code Row = 1 value = 73 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 16675000007847
case_docid = 100062023/5452
case_no = 2023/5452
prev_hearing_date = 04/12/2023
hearing_date = 19/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 = 5
prev_case_purpose after validation = 17553000001243
case_purpose = 17553000001243
case_purpose_code = 73
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 15632000008588
MapName bocup1
SourceId 15632000008566
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 17553000001243
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 73
hearing_date = 19/12/2023
prev_case_purposename = ?????? ???? ??????
court_code = 10006
case_no = 2023/5452
case_docid = 100062023/5452
case_purpose = 17553000001243
trn_bor_caseregid = 16675000007847
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008588
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008566
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:41
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=17553000001243
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=73
Param Type = c
hearing_date=19/12/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ???? ??????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/5452
Param Type = c
case_docid=100062023/5452
Param Type = c
case_purpose=17553000001243
Param Type = n
trn_bor_caseregid=16675000007847
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 8

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2003/1667 idvalue 0
Mapped hearing_date Row = 1 value = 22/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????  idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 990031029 idvalue 0
Mapped case_docid Row = 1 value = 100062003/1667 idvalue 0
Mapped case_purpose Row = 1 value = 10037000000780 idvalue 0
Mapped case_purpose_code Row = 1 value = 113 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 990031029
case_docid = 100062003/1667
case_no = 2003/1667
prev_hearing_date = 04/12/2023
hearing_date = 22/01/2024
prev_case_purposename = ?????? ???? 
prev_case_purpose = 
prev_case_purposename=?????? ???? 
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=?????? ???? 
Time elapsed = 4
prev_case_purpose after validation = 10037000000780
case_purpose = 10037000000780
case_purpose_code = 113
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 15632000008589
MapName bocup1
SourceId 15632000008567
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 5
prev_case_purpose = 10037000000780
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 113
hearing_date = 22/01/2024
prev_case_purposename = ?????? ???? 
court_code = 10006
case_no = 2003/1667
case_docid = 100062003/1667
case_purpose = 10037000000780
trn_bor_caseregid = 990031029
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008589
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008567
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:41
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10037000000780
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=113
Param Type = c
hearing_date=22/01/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ???? 
Param Type = c
court_code=10006
Param Type = c
case_no=2003/1667
Param Type = c
case_docid=100062003/1667
Param Type = c
case_purpose=10037000000780
Param Type = n
trn_bor_caseregid=990031029
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 9

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2003/10480 idvalue 0
Mapped hearing_date Row = 1 value = 22/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 990027785 idvalue 0
Mapped case_docid Row = 1 value = 100062003/10480 idvalue 0
Mapped case_purpose Row = 1 value = 10035000000979 idvalue 0
Mapped case_purpose_code Row = 1 value = 112 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 990027785
case_docid = 100062003/10480
case_no = 2003/10480
prev_hearing_date = 04/12/2023
hearing_date = 22/01/2024
prev_case_purposename = ?????? ?????
prev_case_purpose = 
prev_case_purposename=?????? ?????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=?????? ?????
Time elapsed = 6
prev_case_purpose after validation = 10035000000979
case_purpose = 10035000000979
case_purpose_code = 112
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 15632000008590
MapName bocup1
SourceId 15632000008568
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10035000000979
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 112
hearing_date = 22/01/2024
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2003/10480
case_docid = 100062003/10480
case_purpose = 10035000000979
trn_bor_caseregid = 990027785
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008590
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008568
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:41
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10035000000979
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=112
Param Type = c
hearing_date=22/01/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2003/10480
Param Type = c
case_docid=100062003/10480
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=990027785
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 10

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2013/1262 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 990116928 idvalue 0
Mapped case_docid Row = 1 value = 100062013/1262 idvalue 0
Mapped case_purpose Row = 1 value = 10035000000979 idvalue 0
Mapped case_purpose_code Row = 1 value = 112 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 990116928
case_docid = 100062013/1262
case_no = 2013/1262
prev_hearing_date = 04/12/2023
hearing_date = 05/02/2024
prev_case_purposename = ?????? ?????
prev_case_purpose = 
prev_case_purpose after validation = 10035000000979
case_purpose = 10035000000979
case_purpose_code = 112
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 15632000008591
MapName bocup1
SourceId 15632000008569
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10035000000979
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 112
hearing_date = 05/02/2024
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2013/1262
case_docid = 100062013/1262
case_purpose = 10035000000979
trn_bor_caseregid = 990116928
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008591
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008569
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:41
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10035000000979
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=112
Param Type = c
hearing_date=05/02/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2013/1262
Param Type = c
case_docid=100062013/1262
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=990116928
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 11

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2015/8186 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????  idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 990146845 idvalue 0
Mapped case_docid Row = 1 value = 100062015/8186 idvalue 0
Mapped case_purpose Row = 1 value = 10037000000780 idvalue 0
Mapped case_purpose_code Row = 1 value = 113 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 990146845
case_docid = 100062015/8186
case_no = 2015/8186
prev_hearing_date = 04/12/2023
hearing_date = 05/02/2024
prev_case_purposename = ?????? ???? 
prev_case_purpose = 
prev_case_purposename=?????? ???? 
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=?????? ???? 
Time elapsed = 4
prev_case_purpose after validation = 10037000000780
case_purpose = 10037000000780
case_purpose_code = 113
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 15632000008592
MapName bocup1
SourceId 15632000008570
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10037000000780
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 113
hearing_date = 05/02/2024
prev_case_purposename = ?????? ???? 
court_code = 10006
case_no = 2015/8186
case_docid = 100062015/8186
case_purpose = 10037000000780
trn_bor_caseregid = 990146845
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008592
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008570
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:41
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10037000000780
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=113
Param Type = c
hearing_date=05/02/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ???? 
Param Type = c
court_code=10006
Param Type = c
case_no=2015/8186
Param Type = c
case_docid=100062015/8186
Param Type = c
case_purpose=10037000000780
Param Type = n
trn_bor_caseregid=990146845
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 12

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2016/6416 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 990143298 idvalue 0
Mapped case_docid Row = 1 value = 100062016/6416 idvalue 0
Mapped case_purpose Row = 1 value = 10035000000979 idvalue 0
Mapped case_purpose_code Row = 1 value = 112 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 990143298
case_docid = 100062016/6416
case_no = 2016/6416
prev_hearing_date = 04/12/2023
hearing_date = 05/02/2024
prev_case_purposename = ?????? ?????
prev_case_purpose = 
prev_case_purposename=?????? ?????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=?????? ?????
Time elapsed = 5
prev_case_purpose after validation = 10035000000979
case_purpose = 10035000000979
case_purpose_code = 112
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 2
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 15632000008593
MapName bocup1
SourceId 15632000008571
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 6
prev_case_purpose = 10035000000979
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 112
hearing_date = 05/02/2024
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2016/6416
case_docid = 100062016/6416
case_purpose = 10035000000979
trn_bor_caseregid = 990143298
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008593
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008571
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:41
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10035000000979
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=112
Param Type = c
hearing_date=05/02/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2016/6416
Param Type = c
case_docid=100062016/6416
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=990143298
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 13

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2017/2646 idvalue 0
Mapped hearing_date Row = 1 value = 22/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 2000154183 idvalue 0
Mapped case_docid Row = 1 value = 100062017/2646 idvalue 0
Mapped case_purpose Row = 1 value = 10035000000979 idvalue 0
Mapped case_purpose_code Row = 1 value = 112 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 2000154183
case_docid = 100062017/2646
case_no = 2017/2646
prev_hearing_date = 04/12/2023
hearing_date = 22/01/2024
prev_case_purposename = ?????? ?????
prev_case_purpose = 
prev_case_purpose after validation = 10035000000979
case_purpose = 10035000000979
case_purpose_code = 112
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

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

Time elapsed = 3
RecordId = 15632000008594
MapName bocup1
SourceId 15632000008572
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10035000000979
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 112
hearing_date = 22/01/2024
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2017/2646
case_docid = 100062017/2646
case_purpose = 10035000000979
trn_bor_caseregid = 2000154183
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008594
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008572
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:41
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10035000000979
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=112
Param Type = c
hearing_date=22/01/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2017/2646
Param Type = c
case_docid=100062017/2646
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=2000154183
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 14

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2017/5372 idvalue 0
Mapped hearing_date Row = 1 value = 22/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 990158828 idvalue 0
Mapped case_docid Row = 1 value = 100062017/5372 idvalue 0
Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0
Mapped case_purpose_code Row = 1 value = 122 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 990158828
case_docid = 100062017/5372
case_no = 2017/5372
prev_hearing_date = 04/12/2023
hearing_date = 22/01/2024
prev_case_purposename = ?????? ????? ????
prev_case_purpose = 
prev_case_purposename=?????? ????? ????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=?????? ????? ????
Time elapsed = 5
prev_case_purpose after validation = 10110000000719
case_purpose = 10110000000719
case_purpose_code = 122
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

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

Time elapsed = 4
RecordId = 15632000008595
MapName bocup1
SourceId 15632000008573
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10110000000719
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 122
hearing_date = 22/01/2024
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2017/5372
case_docid = 100062017/5372
case_purpose = 10110000000719
trn_bor_caseregid = 990158828
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008595
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008573
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:42
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10110000000719
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=122
Param Type = c
hearing_date=22/01/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2017/5372
Param Type = c
case_docid=100062017/5372
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=990158828
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 15

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2018/3887 idvalue 0
Mapped hearing_date Row = 1 value = 22/01/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 14077000001981 idvalue 0
Mapped case_docid Row = 1 value = 100062018/3887 idvalue 0
Mapped case_purpose Row = 1 value = 10035000000979 idvalue 0
Mapped case_purpose_code Row = 1 value = 112 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 14077000001981
case_docid = 100062018/3887
case_no = 2018/3887
prev_hearing_date = 04/12/2023
hearing_date = 22/01/2024
prev_case_purposename = ?????? ?????
prev_case_purpose = 
prev_case_purposename=?????? ?????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=?????? ?????
Time elapsed = 8
prev_case_purpose after validation = 10035000000979
case_purpose = 10035000000979
case_purpose_code = 112
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 15632000008596
MapName bocup1
SourceId 15632000008574
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10035000000979
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 112
hearing_date = 22/01/2024
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2018/3887
case_docid = 100062018/3887
case_purpose = 10035000000979
trn_bor_caseregid = 14077000001981
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008596
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008574
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:42
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10035000000979
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=112
Param Type = c
hearing_date=22/01/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2018/3887
Param Type = c
case_docid=100062018/3887
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=14077000001981
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 16

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2018/4450 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 10726000002583 idvalue 0
Mapped case_docid Row = 1 value = 100062018/4450 idvalue 0
Mapped case_purpose Row = 1 value = 10035000000979 idvalue 0
Mapped case_purpose_code Row = 1 value = 112 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 10726000002583
case_docid = 100062018/4450
case_no = 2018/4450
prev_hearing_date = 04/12/2023
hearing_date = 05/02/2024
prev_case_purposename = ?????? ?????
prev_case_purpose = 
prev_case_purpose after validation = 10035000000979
case_purpose = 10035000000979
case_purpose_code = 112
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 3
RecordId = 15632000008597
MapName bocup1
SourceId 15632000008575
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10035000000979
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 112
hearing_date = 05/02/2024
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2018/4450
case_docid = 100062018/4450
case_purpose = 10035000000979
trn_bor_caseregid = 10726000002583
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008597
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008575
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:42
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10035000000979
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=112
Param Type = c
hearing_date=05/02/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2018/4450
Param Type = c
case_docid=100062018/4450
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=10726000002583
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 17

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2018/8313 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 12597000002091 idvalue 0
Mapped case_docid Row = 1 value = 100062018/8313 idvalue 0
Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0
Mapped case_purpose_code Row = 1 value = 122 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 12597000002091
case_docid = 100062018/8313
case_no = 2018/8313
prev_hearing_date = 04/12/2023
hearing_date = 05/02/2024
prev_case_purposename = ?????? ????? ????
prev_case_purpose = 
prev_case_purposename=?????? ????? ????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=?????? ????? ????
Time elapsed = 5
prev_case_purpose after validation = 10110000000719
case_purpose = 10110000000719
case_purpose_code = 122
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 15632000008598
MapName bocup1
SourceId 15632000008576
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10110000000719
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 122
hearing_date = 05/02/2024
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2018/8313
case_docid = 100062018/8313
case_purpose = 10110000000719
trn_bor_caseregid = 12597000002091
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008598
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008576
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:42
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10110000000719
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=122
Param Type = c
hearing_date=05/02/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2018/8313
Param Type = c
case_docid=100062018/8313
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=12597000002091
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 18

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2019/2849 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????  idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 17328000002511 idvalue 0
Mapped case_docid Row = 1 value = 100062019/2849 idvalue 0
Mapped case_purpose Row = 1 value = 10037000000780 idvalue 0
Mapped case_purpose_code Row = 1 value = 113 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 17328000002511
case_docid = 100062019/2849
case_no = 2019/2849
prev_hearing_date = 04/12/2023
hearing_date = 05/02/2024
prev_case_purposename = ?????? ???? 
prev_case_purpose = 
prev_case_purposename=?????? ???? 
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=?????? ???? 
Time elapsed = 5
prev_case_purpose after validation = 10037000000780
case_purpose = 10037000000780
case_purpose_code = 113
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 15632000008599
MapName bocup1
SourceId 15632000008577
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10037000000780
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 113
hearing_date = 05/02/2024
prev_case_purposename = ?????? ???? 
court_code = 10006
case_no = 2019/2849
case_docid = 100062019/2849
case_purpose = 10037000000780
trn_bor_caseregid = 17328000002511
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008599
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008577
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:42
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10037000000780
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=113
Param Type = c
hearing_date=05/02/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ???? 
Param Type = c
court_code=10006
Param Type = c
case_no=2019/2849
Param Type = c
case_docid=100062019/2849
Param Type = c
case_purpose=10037000000780
Param Type = n
trn_bor_caseregid=17328000002511
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 19

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2021/5803 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 14259000006248 idvalue 0
Mapped case_docid Row = 1 value = 100062021/5803 idvalue 0
Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0
Mapped case_purpose_code Row = 1 value = 122 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 14259000006248
case_docid = 100062021/5803
case_no = 2021/5803
prev_hearing_date = 04/12/2023
hearing_date = 05/02/2024
prev_case_purposename = ?????? ????? ????
prev_case_purpose = 
prev_case_purposename=?????? ????? ????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=?????? ????? ????
Time elapsed = 5
prev_case_purpose after validation = 10110000000719
case_purpose = 10110000000719
case_purpose_code = 122
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

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

Time elapsed = 4
RecordId = 15632000008600
MapName bocup1
SourceId 15632000008578
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10110000000719
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 122
hearing_date = 05/02/2024
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2021/5803
case_docid = 100062021/5803
case_purpose = 10110000000719
trn_bor_caseregid = 14259000006248
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008600
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008578
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:43
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10110000000719
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=122
Param Type = c
hearing_date=05/02/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2021/5803
Param Type = c
case_docid=100062021/5803
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=14259000006248
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 20

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2022/101 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 16760000005225 idvalue 0
Mapped case_docid Row = 1 value = 100062022/101 idvalue 0
Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0
Mapped case_purpose_code Row = 1 value = 122 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 16760000005225
case_docid = 100062022/101
case_no = 2022/101
prev_hearing_date = 04/12/2023
hearing_date = 05/02/2024
prev_case_purposename = ?????? ????? ????
prev_case_purpose = 
prev_case_purpose after validation = 10110000000719
case_purpose = 10110000000719
case_purpose_code = 122
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

Time elapsed = 3
Saving to table TRN_BOR_CASE_HIST
select * from TRN_BOR_CASE_HIST where  TRN_BOR_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 = 15632000008601
MapName bocup1
SourceId 15632000008579
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10110000000719
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 122
hearing_date = 05/02/2024
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2022/101
case_docid = 100062022/101
case_purpose = 10110000000719
trn_bor_caseregid = 16760000005225
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008601
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008579
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:43
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10110000000719
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=122
Param Type = c
hearing_date=05/02/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/101
Param Type = c
case_docid=100062022/101
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=16760000005225
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 21

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2022/611 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 15918000006709 idvalue 0
Mapped case_docid Row = 1 value = 100062022/611 idvalue 0
Mapped case_purpose Row = 1 value = 10035000000979 idvalue 0
Mapped case_purpose_code Row = 1 value = 112 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 15918000006709
case_docid = 100062022/611
case_no = 2022/611
prev_hearing_date = 04/12/2023
hearing_date = 05/02/2024
prev_case_purposename = ?????? ?????
prev_case_purpose = 
prev_case_purposename=?????? ?????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=?????? ?????
Time elapsed = 4
prev_case_purpose after validation = 10035000000979
case_purpose = 10035000000979
case_purpose_code = 112
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

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

Time elapsed = 3
RecordId = 15632000008602
MapName bocup1
SourceId 15632000008580
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10035000000979
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 112
hearing_date = 05/02/2024
prev_case_purposename = ?????? ?????
court_code = 10006
case_no = 2022/611
case_docid = 100062022/611
case_purpose = 10035000000979
trn_bor_caseregid = 15918000006709
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008602
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008580
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:43
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10035000000979
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=112
Param Type = c
hearing_date=05/02/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ?????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/611
Param Type = c
case_docid=100062022/611
Param Type = c
case_purpose=10035000000979
Param Type = n
trn_bor_caseregid=15918000006709
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from bocup to rbchh from row 22

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2023/1317 idvalue 0
Mapped hearing_date Row = 1 value = 05/02/2024 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 04/12/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 13695000008192 idvalue 0
Mapped case_docid Row = 1 value = 100062023/1317 idvalue 0
Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0
Mapped case_purpose_code Row = 1 value = 122 idvalue 0
Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0

>>Validating rbchh

>>Frame No 1
doc_date = 
Evaluating - date()
   Result of date = 07/12/2023
doc_date after validation = 07/12/2023
court_code = 10006
trn_bor_caseregid = 13695000008192
case_docid = 100062023/1317
case_no = 2023/1317
prev_hearing_date = 04/12/2023
hearing_date = 05/02/2024
prev_case_purposename = ?????? ????? ????
prev_case_purpose = 
prev_case_purposename=?????? ????? ????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=?????? ????? ????
Time elapsed = 3
prev_case_purpose after validation = 10110000000719
case_purpose = 10110000000719
case_purpose_code = 122
bench_type = 
bench_name = 
clcheck = 
decision_type = 
decision_date = 
module = 
Evaluating - {Feedback}
module after validation = Feedback
trans_type = Cause List Update (Custom)

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

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

Time elapsed = 3
RecordId = 15632000008603
MapName bocup1
SourceId 15632000008581
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 9
prev_case_purpose = 10110000000719
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 07/12/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 122
hearing_date = 05/02/2024
prev_case_purposename = ?????? ????? ????
court_code = 10006
case_no = 2023/1317
case_docid = 100062023/1317
case_purpose = 10110000000719
trn_bor_caseregid = 13695000008192
prev_hearing_date = 04/12/2023
Posting record
Param Type = n
trn_bor_case_histid=15632000008603
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15632000008581
Param Type = c
cancel=F
Param Type = c
createdby=ekta
Param Type = c
createdon=07/12/2023 13:16:43
Param Type = c
username=ekta
Param Type = c
modifiedon=07/12/2023 13:16:43
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10110000000719
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=07/12/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=122
Param Type = c
hearing_date=05/02/2024 00:00:00
Param Type = c
prev_case_purposename=?????? ????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/1317
Param Type = c
case_docid=100062023/1317
Param Type = c
case_purpose=10110000000719
Param Type = n
trn_bor_caseregid=13695000008192
Param Type = c
prev_hearing_date=04/12/2023 00:00:00
insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_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,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'))

Time elapsed for Gen Map = 3911116558946

>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=990109925
@trn_bor_caseregid=990109925
*hearingdate=08/01/2024
*case_purpose_name=10189000000601
*case_purpose_code=201
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990109925 for update 
Time elapsed = 45
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990109925
Time elapsed = 20
Param Type = c
hearingdate=08/01/2024 00:00:00
Param Type = c
case_purpose_name=10189000000601
Param Type = c
case_purpose_code=201
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=990109925


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=990136093
@trn_bor_caseregid=990136093
*hearingdate=08/01/2024
*case_purpose_name=10189000000601
*case_purpose_code=201
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990136093 for update 
Time elapsed = 25
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990136093
Time elapsed = 24
Param Type = c
hearingdate=08/01/2024 00:00:00
Param Type = c
case_purpose_name=10189000000601
Param Type = c
case_purpose_code=201
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=990136093


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=14491000001395
@trn_bor_caseregid=14491000001395
*hearingdate=22/01/2024
*case_purpose_name=10189000000601
*case_purpose_code=201
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=14491000001395 for update 
Time elapsed = 26
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=14491000001395
Time elapsed = 24
Param Type = c
hearingdate=22/01/2024 00:00:00
Param Type = c
case_purpose_name=10189000000601
Param Type = c
case_purpose_code=201
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=14491000001395


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=18097000007349
@trn_bor_caseregid=18097000007349
*hearingdate=18/12/2023
*case_purpose_name=10119000000827
*case_purpose_code=131
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=18097000007349 for update 
Time elapsed = 28
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=18097000007349
Time elapsed = 23
Param Type = c
hearingdate=18/12/2023 00:00:00
Param Type = c
case_purpose_name=10119000000827
Param Type = c
case_purpose_code=131
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=18097000007349


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=14667000007493
@trn_bor_caseregid=14667000007493
*hearingdate=18/12/2023
*case_purpose_name=17553000001243
*case_purpose_code=73
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=14667000007493 for update 
Time elapsed = 22
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=14667000007493
Time elapsed = 22
Param Type = c
hearingdate=18/12/2023 00:00:00
Param Type = c
case_purpose_name=17553000001243
Param Type = c
case_purpose_code=73
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=14667000007493


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=14027000008055
@trn_bor_caseregid=14027000008055
*hearingdate=18/12/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=14027000008055 for update 
Time elapsed = 23
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=14027000008055
Time elapsed = 27
Param Type = c
hearingdate=18/12/2023 00:00:00
Param Type = c
case_purpose_name=10109000001043
Param Type = c
case_purpose_code=121
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=14027000008055


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=16675000007847
@trn_bor_caseregid=16675000007847
*hearingdate=19/12/2023
*case_purpose_name=17553000001243
*case_purpose_code=73
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=16675000007847 for update 
Time elapsed = 28
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=16675000007847
Time elapsed = 21
Param Type = c
hearingdate=19/12/2023 00:00:00
Param Type = c
case_purpose_name=17553000001243
Param Type = c
case_purpose_code=73
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=16675000007847


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=990031029
@trn_bor_caseregid=990031029
*hearingdate=22/01/2024
*case_purpose_name=10037000000780
*case_purpose_code=113
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990031029 for update 
Time elapsed = 22
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990031029
Time elapsed = 21
Param Type = c
hearingdate=22/01/2024 00:00:00
Param Type = c
case_purpose_name=10037000000780
Param Type = c
case_purpose_code=113
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=990031029


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=990027785
@trn_bor_caseregid=990027785
*hearingdate=22/01/2024
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990027785 for update 
Time elapsed = 25
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990027785
Time elapsed = 26
Param Type = c
hearingdate=22/01/2024 00:00:00
Param Type = c
case_purpose_name=10035000000979
Param Type = c
case_purpose_code=112
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=990027785


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=990116928
@trn_bor_caseregid=990116928
*hearingdate=05/02/2024
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990116928 for update 
Time elapsed = 27
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990116928
Time elapsed = 27
Param Type = c
hearingdate=05/02/2024 00:00:00
Param Type = c
case_purpose_name=10035000000979
Param Type = c
case_purpose_code=112
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=990116928


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=990146845
@trn_bor_caseregid=990146845
*hearingdate=05/02/2024
*case_purpose_name=10037000000780
*case_purpose_code=113
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990146845 for update 
Time elapsed = 25
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990146845
Time elapsed = 22
Param Type = c
hearingdate=05/02/2024 00:00:00
Param Type = c
case_purpose_name=10037000000780
Param Type = c
case_purpose_code=113
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=990146845


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=990143298
@trn_bor_caseregid=990143298
*hearingdate=05/02/2024
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990143298 for update 
Time elapsed = 26
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990143298
Time elapsed = 22
Param Type = c
hearingdate=05/02/2024 00:00:00
Param Type = c
case_purpose_name=10035000000979
Param Type = c
case_purpose_code=112
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=990143298


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=2000154183
@trn_bor_caseregid=2000154183
*hearingdate=22/01/2024
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=2000154183 for update 
Time elapsed = 26
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=2000154183
Time elapsed = 58
Param Type = c
hearingdate=22/01/2024 00:00:00
Param Type = c
case_purpose_name=10035000000979
Param Type = c
case_purpose_code=112
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=2000154183


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=990158828
@trn_bor_caseregid=990158828
*hearingdate=22/01/2024
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990158828 for update 
Time elapsed = 27
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990158828
Time elapsed = 27
Param Type = c
hearingdate=22/01/2024 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=990158828


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=14077000001981
@trn_bor_caseregid=14077000001981
*hearingdate=22/01/2024
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=14077000001981 for update 
Time elapsed = 25
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=14077000001981
Time elapsed = 22
Param Type = c
hearingdate=22/01/2024 00:00:00
Param Type = c
case_purpose_name=10035000000979
Param Type = c
case_purpose_code=112
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=14077000001981


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=10726000002583
@trn_bor_caseregid=10726000002583
*hearingdate=05/02/2024
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=10726000002583 for update 
Time elapsed = 27
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=10726000002583
Time elapsed = 23
Param Type = c
hearingdate=05/02/2024 00:00:00
Param Type = c
case_purpose_name=10035000000979
Param Type = c
case_purpose_code=112
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=10726000002583


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=12597000002091
@trn_bor_caseregid=12597000002091
*hearingdate=05/02/2024
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=12597000002091 for update 
Time elapsed = 23
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=12597000002091
Time elapsed = 524
Param Type = c
hearingdate=05/02/2024 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=12597000002091


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=17328000002511
@trn_bor_caseregid=17328000002511
*hearingdate=05/02/2024
*case_purpose_name=10037000000780
*case_purpose_code=113
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=17328000002511 for update 
Time elapsed = 28
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=17328000002511
Time elapsed = 27
Param Type = c
hearingdate=05/02/2024 00:00:00
Param Type = c
case_purpose_name=10037000000780
Param Type = c
case_purpose_code=113
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=17328000002511


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=14259000006248
@trn_bor_caseregid=14259000006248
*hearingdate=05/02/2024
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=14259000006248 for update 
Time elapsed = 25
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=14259000006248
Time elapsed = 26
Param Type = c
hearingdate=05/02/2024 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=14259000006248


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=16760000005225
@trn_bor_caseregid=16760000005225
*hearingdate=05/02/2024
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=16760000005225 for update 
Time elapsed = 25
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=16760000005225
Time elapsed = 28
Param Type = c
hearingdate=05/02/2024 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=16760000005225


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=15918000006709
@trn_bor_caseregid=15918000006709
*hearingdate=05/02/2024
*case_purpose_name=10035000000979
*case_purpose_code=112
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=15918000006709 for update 
Time elapsed = 28
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=15918000006709
Time elapsed = 20
Param Type = c
hearingdate=05/02/2024 00:00:00
Param Type = c
case_purpose_name=10035000000979
Param Type = c
case_purpose_code=112
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=15918000006709


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=13695000008192
@trn_bor_caseregid=13695000008192
*hearingdate=05/02/2024
*case_purpose_name=10110000000719
*case_purpose_code=122
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=13695000008192 for update 
Time elapsed = 28
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=13695000008192
Time elapsed = 33
Param Type = c
hearingdate=05/02/2024 00:00:00
Param Type = c
case_purpose_name=10110000000719
Param Type = c
case_purpose_code=122
update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code
 where  trn_bor_caseregid=13695000008192

Time elapsed for MD Map = 3911116561368
Time elapsed for Save History = 3911116561369
Time elapsed for Save Attachment = 3911116561371
Time elapsed for After Save WF Exec = 3911116561376
Transaction commited
Result : {"message":[{"msg":"Cause List Feedback Saved","recordid":"15632000008559"}]}
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=ekta
Param Type = c
calledon=07/12/2023 13:15:52
Param Type = c
callfinished=07/12/2023 13:16:01
Param Type = c
structname=bocup
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=success
Param Type = n
timetaken=9142
Param Type = n
dbtimetaken=6052
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