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="dikshabor" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>dikshabor</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">23/05/2023</cldate><cltype rowno="001">A</cltype><benchname rowno="001">??. ??-3</benchname><benchcode rowno="001">4</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">dikshabor</puname><court_name rowno="001">11599000000000</court_name><court_code rowno="001">10006</court_code><docid rowno="001">100062022/5759</docid><case_no rowno="001">2022/5759</case_no><trn_bor_caseid rowno="001">18667000007503</trn_bor_caseid><manual_case_no rowno="001"></manual_case_no><bench_code rowno="001">4</bench_code><prev_case_purpose rowno="001">???????? ??????</prev_case_purpose><prev_purpose_code rowno="001">229</prev_purpose_code><prev_hear_date rowno="001">23/05/2023</prev_hear_date><next_hear_date rowno="001">25/05/2023</next_hear_date><new_case_purpose rowno="001">11356000002249</new_case_purpose><new_purpose_code rowno="001">229</new_purpose_code><new_purpose_group rowno="001">19966000000909</new_purpose_group><axp_recid2 rowno="002">0</axp_recid2><puname rowno="002">dikshabor</puname><court_name rowno="002">11599000000000</court_name><court_code rowno="002">10006</court_code><docid rowno="002">100062023/277</docid><case_no rowno="002">2023/277</case_no><trn_bor_caseid rowno="002">15806000006591</trn_bor_caseid><manual_case_no rowno="002"></manual_case_no><bench_code rowno="002">4</bench_code><prev_case_purpose rowno="002">?????? ????</prev_case_purpose><prev_purpose_code rowno="002">121</prev_purpose_code><prev_hear_date rowno="002">23/05/2023</prev_hear_date><next_hear_date rowno="002">26/05/2023</next_hear_date><new_case_purpose rowno="002">10109000001043</new_case_purpose><new_purpose_code rowno="002">121</new_purpose_code><new_purpose_group rowno="002">19966000000909</new_purpose_group><axp_recid2 rowno="003">0</axp_recid2><puname rowno="003">dikshabor</puname><court_name rowno="003">11599000000000</court_name><court_code rowno="003">10006</court_code><docid rowno="003">100062023/875</docid><case_no rowno="003">2023/875</case_no><trn_bor_caseid rowno="003">12463000008330</trn_bor_caseid><manual_case_no rowno="003"></manual_case_no><bench_code rowno="003">4</bench_code><prev_case_purpose rowno="003">?????? ????</prev_case_purpose><prev_purpose_code rowno="003">121</prev_purpose_code><prev_hear_date rowno="003">23/05/2023</prev_hear_date><next_hear_date rowno="003">19/10/2023</next_hear_date><new_case_purpose rowno="003">10109000001043</new_case_purpose><new_purpose_code rowno="003">121</new_purpose_code><new_purpose_group rowno="003">19966000000909</new_purpose_group><axp_recid2 rowno="004">0</axp_recid2><puname rowno="004">dikshabor</puname><court_name rowno="004">11599000000000</court_name><court_code rowno="004">10006</court_code><docid rowno="004">100062023/991</docid><case_no rowno="004">2023/991</case_no><trn_bor_caseid rowno="004">10095000007426</trn_bor_caseid><manual_case_no rowno="004"></manual_case_no><bench_code rowno="004">4</bench_code><prev_case_purpose rowno="004">?????? ???? ??????</prev_case_purpose><prev_purpose_code rowno="004">73</prev_purpose_code><prev_hear_date rowno="004">23/05/2023</prev_hear_date><next_hear_date rowno="004">25/05/2023</next_hear_date><new_case_purpose rowno="004">17553000001243</new_case_purpose><new_purpose_code rowno="004">73</new_purpose_code><new_purpose_group rowno="004">19966000000909</new_purpose_group><axp_recid2 rowno="005">0</axp_recid2><puname rowno="005">dikshabor</puname><court_name rowno="005">11599000000000</court_name><court_code rowno="005">10006</court_code><docid rowno="005">100062023/1462</docid><case_no rowno="005">2023/1462</case_no><trn_bor_caseid rowno="005">16022000007510</trn_bor_caseid><manual_case_no rowno="005"></manual_case_no><bench_code rowno="005">4</bench_code><prev_case_purpose rowno="005">?????? ????</prev_case_purpose><prev_purpose_code rowno="005">121</prev_purpose_code><prev_hear_date rowno="005">23/05/2023</prev_hear_date><next_hear_date rowno="005">25/05/2023</next_hear_date><new_case_purpose rowno="005">10109000001043</new_case_purpose><new_purpose_code rowno="005">121</new_purpose_code><new_purpose_group rowno="005">19966000000909</new_purpose_group><axp_recid2 rowno="006">0</axp_recid2><puname rowno="006">dikshabor</puname><court_name rowno="006">11599000000000</court_name><court_code rowno="006">10006</court_code><docid rowno="006">100062023/1589</docid><case_no rowno="006">2023/1589</case_no><trn_bor_caseid rowno="006">13390000008450</trn_bor_caseid><manual_case_no rowno="006"></manual_case_no><bench_code rowno="006">4</bench_code><prev_case_purpose rowno="006">?????? ????</prev_case_purpose><prev_purpose_code rowno="006">121</prev_purpose_code><prev_hear_date rowno="006">23/05/2023</prev_hear_date><next_hear_date rowno="006">25/05/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">dikshabor</puname><court_name rowno="007">11599000000000</court_name><court_code rowno="007">10006</court_code><docid rowno="007">100062023/1783</docid><case_no rowno="007">2023/1783</case_no><trn_bor_caseid rowno="007">10294000007624</trn_bor_caseid><manual_case_no rowno="007"></manual_case_no><bench_code rowno="007">4</bench_code><prev_case_purpose rowno="007">?????? ????</prev_case_purpose><prev_purpose_code rowno="007">121</prev_purpose_code><prev_hear_date rowno="007">23/05/2023</prev_hear_date><next_hear_date rowno="007">26/05/2023</next_hear_date><new_case_purpose rowno="007">10109000001043</new_case_purpose><new_purpose_code rowno="007">121</new_purpose_code><new_purpose_group rowno="007">19966000000909</new_purpose_group><axp_recid2 rowno="008">0</axp_recid2><puname rowno="008">dikshabor</puname><court_name rowno="008">11599000000000</court_name><court_code rowno="008">10006</court_code><docid rowno="008">100062023/1884</docid><case_no rowno="008">2023/1884</case_no><trn_bor_caseid rowno="008">19897000007745</trn_bor_caseid><manual_case_no rowno="008"></manual_case_no><bench_code rowno="008">4</bench_code><prev_case_purpose rowno="008">?????? ????</prev_case_purpose><prev_purpose_code rowno="008">121</prev_purpose_code><prev_hear_date rowno="008">23/05/2023</prev_hear_date><next_hear_date rowno="008">25/05/2023</next_hear_date><new_case_purpose rowno="008">10109000001043</new_case_purpose><new_purpose_code rowno="008">121</new_purpose_code><new_purpose_group rowno="008">19966000000909</new_purpose_group><axp_recid2 rowno="009">0</axp_recid2><puname rowno="009">dikshabor</puname><court_name rowno="009">11599000000000</court_name><court_code rowno="009">10006</court_code><docid rowno="009">100062023/1885</docid><case_no rowno="009">2023/1885</case_no><trn_bor_caseid rowno="009">10105000007834</trn_bor_caseid><manual_case_no rowno="009"></manual_case_no><bench_code rowno="009">4</bench_code><prev_case_purpose rowno="009">?????? ????</prev_case_purpose><prev_purpose_code rowno="009">121</prev_purpose_code><prev_hear_date rowno="009">23/05/2023</prev_hear_date><next_hear_date rowno="009">25/05/2023</next_hear_date><new_case_purpose rowno="009">10109000001043</new_case_purpose><new_purpose_code rowno="009">121</new_purpose_code><new_purpose_group rowno="009">19966000000909</new_purpose_group><axp_recid2 rowno="0010">0</axp_recid2><puname rowno="0010">dikshabor</puname><court_name rowno="0010">11599000000000</court_name><court_code rowno="0010">10006</court_code><docid rowno="0010">100062023/1945</docid><case_no rowno="0010">2023/1945</case_no><trn_bor_caseid rowno="0010">11807000007555</trn_bor_caseid><manual_case_no rowno="0010"></manual_case_no><bench_code rowno="0010">4</bench_code><prev_case_purpose rowno="0010">??? ???? ?????? ????</prev_case_purpose><prev_purpose_code rowno="0010">108</prev_purpose_code><prev_hear_date rowno="0010">23/05/2023</prev_hear_date><next_hear_date rowno="0010">25/05/2023</next_hear_date><new_case_purpose rowno="0010">10024000000944</new_case_purpose><new_purpose_code rowno="0010">108</new_purpose_code><new_purpose_group rowno="0010">19966000000909</new_purpose_group><axp_recid2 rowno="0011">0</axp_recid2><puname rowno="0011">dikshabor</puname><court_name rowno="0011">11599000000000</court_name><court_code rowno="0011">10006</court_code><docid rowno="0011">100062023/2034</docid><case_no rowno="0011">2023/2034</case_no><trn_bor_caseid rowno="0011">13324000007373</trn_bor_caseid><manual_case_no rowno="0011"></manual_case_no><bench_code rowno="0011">4</bench_code><prev_case_purpose rowno="0011">?????? ????</prev_case_purpose><prev_purpose_code rowno="0011">121</prev_purpose_code><prev_hear_date rowno="0011">23/05/2023</prev_hear_date><next_hear_date rowno="0011">26/05/2023</next_hear_date><new_case_purpose rowno="0011">10109000001043</new_case_purpose><new_purpose_code rowno="0011">121</new_purpose_code><new_purpose_group rowno="0011">19966000000909</new_purpose_group><axp_recid2 rowno="0012">0</axp_recid2><puname rowno="0012">dikshabor</puname><court_name rowno="0012">11599000000000</court_name><court_code rowno="0012">10006</court_code><docid rowno="0012">100062023/2126</docid><case_no rowno="0012">2023/2126</case_no><trn_bor_caseid rowno="0012">17183000007765</trn_bor_caseid><manual_case_no rowno="0012"></manual_case_no><bench_code rowno="0012">4</bench_code><prev_case_purpose rowno="0012">??????</prev_case_purpose><prev_purpose_code rowno="0012">2</prev_purpose_code><prev_hear_date rowno="0012">23/05/2023</prev_hear_date><next_hear_date rowno="0012">25/05/2023</next_hear_date><new_case_purpose rowno="0012">10001000000775</new_case_purpose><new_purpose_code rowno="0012">2</new_purpose_code><new_purpose_group rowno="0012">19966000000909</new_purpose_group><axp_recid2 rowno="0013">0</axp_recid2><puname rowno="0013">dikshabor</puname><court_name rowno="0013">11599000000000</court_name><court_code rowno="0013">10006</court_code><docid rowno="0013">100062023/2202</docid><case_no rowno="0013">2023/2202</case_no><trn_bor_caseid rowno="0013">19059000007938</trn_bor_caseid><manual_case_no rowno="0013"></manual_case_no><bench_code rowno="0013">4</bench_code><prev_case_purpose rowno="0013">?????? ???? ??????</prev_case_purpose><prev_purpose_code rowno="0013">73</prev_purpose_code><prev_hear_date rowno="0013">23/05/2023</prev_hear_date><next_hear_date rowno="0013">25/05/2023</next_hear_date><new_case_purpose rowno="0013">17553000001243</new_case_purpose><new_purpose_code rowno="0013">73</new_purpose_code><new_purpose_group rowno="0013">19966000000909</new_purpose_group><axp_recid2 rowno="0014">0</axp_recid2><puname rowno="0014">dikshabor</puname><court_name rowno="0014">11599000000000</court_name><court_code rowno="0014">10006</court_code><docid rowno="0014">100062023/2236</docid><case_no rowno="0014">2023/2236</case_no><trn_bor_caseid rowno="0014">17260000007794</trn_bor_caseid><manual_case_no rowno="0014"></manual_case_no><bench_code rowno="0014">4</bench_code><prev_case_purpose rowno="0014">?????? ????</prev_case_purpose><prev_purpose_code rowno="0014">121</prev_purpose_code><prev_hear_date rowno="0014">23/05/2023</prev_hear_date><next_hear_date rowno="0014">25/05/2023</next_hear_date><new_case_purpose rowno="0014">10109000001043</new_case_purpose><new_purpose_code rowno="0014">121</new_purpose_code><new_purpose_group rowno="0014">19966000000909</new_purpose_group><axp_recid2 rowno="0015">0</axp_recid2><puname rowno="0015">dikshabor</puname><court_name rowno="0015">11599000000000</court_name><court_code rowno="0015">10006</court_code><docid rowno="0015">100062023/2266</docid><case_no rowno="0015">2023/2266</case_no><trn_bor_caseid rowno="0015">11165000006943</trn_bor_caseid><manual_case_no rowno="0015"></manual_case_no><bench_code rowno="0015">4</bench_code><prev_case_purpose rowno="0015">?????? ???? ??????</prev_case_purpose><prev_purpose_code rowno="0015">73</prev_purpose_code><prev_hear_date rowno="0015">23/05/2023</prev_hear_date><next_hear_date rowno="0015">25/05/2023</next_hear_date><new_case_purpose rowno="0015">17553000001243</new_case_purpose><new_purpose_code rowno="0015">73</new_purpose_code><new_purpose_group rowno="0015">19966000000909</new_purpose_group><axp_recid2 rowno="0016">0</axp_recid2><puname rowno="0016">dikshabor</puname><court_name rowno="0016">11599000000000</court_name><court_code rowno="0016">10006</court_code><docid rowno="0016">100062023/2299</docid><case_no rowno="0016">2023/2299</case_no><trn_bor_caseid rowno="0016">15762000007428</trn_bor_caseid><manual_case_no rowno="0016"></manual_case_no><bench_code rowno="0016">4</bench_code><prev_case_purpose rowno="0016">?????? ????</prev_case_purpose><prev_purpose_code rowno="0016">121</prev_purpose_code><prev_hear_date rowno="0016">23/05/2023</prev_hear_date><next_hear_date rowno="0016">25/05/2023</next_hear_date><new_case_purpose rowno="0016">10109000001043</new_case_purpose><new_purpose_code rowno="0016">121</new_purpose_code><new_purpose_group rowno="0016">19966000000909</new_purpose_group><axp_recid2 rowno="0017">0</axp_recid2><puname rowno="0017">dikshabor</puname><court_name rowno="0017">11599000000000</court_name><court_code rowno="0017">10006</court_code><docid rowno="0017">100062023/2341</docid><case_no rowno="0017">2023/2341</case_no><trn_bor_caseid rowno="0017">12184000008816</trn_bor_caseid><manual_case_no rowno="0017"></manual_case_no><bench_code rowno="0017">4</bench_code><prev_case_purpose rowno="0017">?????? ????</prev_case_purpose><prev_purpose_code rowno="0017">121</prev_purpose_code><prev_hear_date rowno="0017">23/05/2023</prev_hear_date><next_hear_date rowno="0017">25/05/2023</next_hear_date><new_case_purpose rowno="0017">10109000001043</new_case_purpose><new_purpose_code rowno="0017">121</new_purpose_code><new_purpose_group rowno="0017">19966000000909</new_purpose_group><axp_recid2 rowno="0018">0</axp_recid2><puname rowno="0018">dikshabor</puname><court_name rowno="0018">11599000000000</court_name><court_code rowno="0018">10006</court_code><docid rowno="0018">100062023/2368</docid><case_no rowno="0018">2023/2368</case_no><trn_bor_caseid rowno="0018">15306000006326</trn_bor_caseid><manual_case_no rowno="0018"></manual_case_no><bench_code rowno="0018">4</bench_code><prev_case_purpose rowno="0018">?????? ????</prev_case_purpose><prev_purpose_code rowno="0018">121</prev_purpose_code><prev_hear_date rowno="0018">23/05/2023</prev_hear_date><next_hear_date rowno="0018">25/05/2023</next_hear_date><new_case_purpose rowno="0018">10109000001043</new_case_purpose><new_purpose_code rowno="0018">121</new_purpose_code><new_purpose_group rowno="0018">19966000000909</new_purpose_group><axp_recid2 rowno="0019">0</axp_recid2><puname rowno="0019">dikshabor</puname><court_name rowno="0019">11599000000000</court_name><court_code rowno="0019">10006</court_code><docid rowno="0019">100062023/2407</docid><case_no rowno="0019">2023/2407</case_no><trn_bor_caseid rowno="0019">11914000008414</trn_bor_caseid><manual_case_no rowno="0019"></manual_case_no><bench_code rowno="0019">4</bench_code><prev_case_purpose rowno="0019">?????? ???? ??????</prev_case_purpose><prev_purpose_code rowno="0019">73</prev_purpose_code><prev_hear_date rowno="0019">23/05/2023</prev_hear_date><next_hear_date rowno="0019">23/05/2023</next_hear_date><new_case_purpose rowno="0019">15904000000025</new_case_purpose><new_purpose_code rowno="0019">301</new_purpose_code><new_purpose_group rowno="0019">18437000000000</new_purpose_group><axp_recid2 rowno="0020">0</axp_recid2><puname rowno="0020">dikshabor</puname><court_name rowno="0020">11599000000000</court_name><court_code rowno="0020">10006</court_code><docid rowno="0020">100062023/2410</docid><case_no rowno="0020">2023/2410</case_no><trn_bor_caseid rowno="0020">12150000007854</trn_bor_caseid><manual_case_no rowno="0020"></manual_case_no><bench_code rowno="0020">4</bench_code><prev_case_purpose rowno="0020">?????? ????</prev_case_purpose><prev_purpose_code rowno="0020">121</prev_purpose_code><prev_hear_date rowno="0020">23/05/2023</prev_hear_date><next_hear_date rowno="0020">25/05/2023</next_hear_date><new_case_purpose rowno="0020">10109000001043</new_case_purpose><new_purpose_code rowno="0020">121</new_purpose_code><new_purpose_group rowno="0020">19966000000909</new_purpose_group><axp_recid2 rowno="0021">0</axp_recid2><puname rowno="0021">dikshabor</puname><court_name rowno="0021">11599000000000</court_name><court_code rowno="0021">10006</court_code><docid rowno="0021">100062023/2449</docid><case_no rowno="0021">2023/2449</case_no><trn_bor_caseid rowno="0021">18476000007371</trn_bor_caseid><manual_case_no rowno="0021"></manual_case_no><bench_code rowno="0021">4</bench_code><prev_case_purpose rowno="0021">?????? ????</prev_case_purpose><prev_purpose_code rowno="0021">121</prev_purpose_code><prev_hear_date rowno="0021">23/05/2023</prev_hear_date><next_hear_date rowno="0021">25/05/2023</next_hear_date><new_case_purpose rowno="0021">10109000001043</new_case_purpose><new_purpose_code rowno="0021">121</new_purpose_code><new_purpose_group rowno="0021">19966000000909</new_purpose_group><axp_recid2 rowno="0022">0</axp_recid2><puname rowno="0022">dikshabor</puname><court_name rowno="0022">11599000000000</court_name><court_code rowno="0022">10006</court_code><docid rowno="0022">100062016/5600</docid><case_no rowno="0022">2016/5600</case_no><trn_bor_caseid rowno="0022">990144427</trn_bor_caseid><manual_case_no rowno="0022"></manual_case_no><bench_code rowno="0022">4</bench_code><prev_case_purpose rowno="0022">???????? ????????? ????</prev_case_purpose><prev_purpose_code rowno="0022">120</prev_purpose_code><prev_hear_date rowno="0022">23/05/2023</prev_hear_date><next_hear_date rowno="0022">25/05/2023</next_hear_date><new_case_purpose rowno="0022">10107000000777</new_case_purpose><new_purpose_code rowno="0022">120</new_purpose_code><new_purpose_group rowno="0022">19973000000612</new_purpose_group><axp_recid2 rowno="0023">0</axp_recid2><puname rowno="0023">dikshabor</puname><court_name rowno="0023">11599000000000</court_name><court_code rowno="0023">10006</court_code><docid rowno="0023">100062018/7614</docid><case_no rowno="0023">2018/7614</case_no><trn_bor_caseid rowno="0023">10615000002766</trn_bor_caseid><manual_case_no rowno="0023"></manual_case_no><bench_code rowno="0023">4</bench_code><prev_case_purpose rowno="0023">???????? ????????? ????</prev_case_purpose><prev_purpose_code rowno="0023">120</prev_purpose_code><prev_hear_date rowno="0023">23/05/2023</prev_hear_date><next_hear_date rowno="0023">25/05/2023</next_hear_date><new_case_purpose rowno="0023">10107000000777</new_case_purpose><new_purpose_code rowno="0023">120</new_purpose_code><new_purpose_group rowno="0023">19973000000612</new_purpose_group><axp_recid2 rowno="0024">0</axp_recid2><puname rowno="0024">dikshabor</puname><court_name rowno="0024">11599000000000</court_name><court_code rowno="0024">10006</court_code><docid rowno="0024">100062022/2571</docid><case_no rowno="0024">2022/2571</case_no><trn_bor_caseid rowno="0024">19062000007384</trn_bor_caseid><manual_case_no rowno="0024"></manual_case_no><bench_code rowno="0024">4</bench_code><prev_case_purpose rowno="0024">???????? ????????? ????</prev_case_purpose><prev_purpose_code rowno="0024">120</prev_purpose_code><prev_hear_date rowno="0024">23/05/2023</prev_hear_date><next_hear_date rowno="0024">26/05/2023</next_hear_date><new_case_purpose rowno="0024">10107000000777</new_case_purpose><new_purpose_code rowno="0024">120</new_purpose_code><new_purpose_group rowno="0024">19973000000612</new_purpose_group><axp_recid2 rowno="0025">0</axp_recid2><puname rowno="0025">dikshabor</puname><court_name rowno="0025">11599000000000</court_name><court_code rowno="0025">10006</court_code><docid rowno="0025">100062023/437</docid><case_no rowno="0025">2023/437</case_no><trn_bor_caseid rowno="0025">18065000007303</trn_bor_caseid><manual_case_no rowno="0025"></manual_case_no><bench_code rowno="0025">4</bench_code><prev_case_purpose rowno="0025">???????? ????????? ????</prev_case_purpose><prev_purpose_code rowno="0025">120</prev_purpose_code><prev_hear_date rowno="0025">23/05/2023</prev_hear_date><next_hear_date rowno="0025">29/05/2023</next_hear_date><new_case_purpose rowno="0025">10107000000777</new_case_purpose><new_purpose_code rowno="0025">120</new_purpose_code><new_purpose_group rowno="0025">19973000000612</new_purpose_group><axp_recid3 rowno="001">0</axp_recid3><trn_bor_caseregid rowno="001">11914000008414</trn_bor_caseregid><officer_mastid rowno="001">1939660006405</officer_mastid><request_type rowno="001">RESERVED</request_type><mem_inactive rowno="001">NO</mem_inactive><memcount rowno="001">1</memcount><axp_recid4 rowno="001">0</axp_recid4><is_update rowno="001">1</is_update><trn_bor_case_id rowno="001">11914000008414</trn_bor_case_id><memupdate rowno="001">1</memupdate></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"dikshabor","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"bocup","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtname":"11599000000000","courtcode":"10006","cldate":"23/05/2023","cltype":"A","benchname":"??. ??-3","benchcode":"4","cluser":"","bench_mem1":"0","bench_mem2":"0"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062022/5759","case_no":"2022/5759","trn_bor_caseid":"18667000007503","manual_case_no":"","bench_code":"4","prev_case_purpose":"???????? ??????","prev_purpose_code":"229","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"11356000002249","new_purpose_code":"229","new_purpose_group":"19966000000909"}},{"rowno":"002","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/277","case_no":"2023/277","trn_bor_caseid":"15806000006591","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"23/05/2023","next_hear_date":"26/05/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"003","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/875","case_no":"2023/875","trn_bor_caseid":"12463000008330","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"23/05/2023","next_hear_date":"19/10/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"004","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/991","case_no":"2023/991","trn_bor_caseid":"10095000007426","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ???? ??????","prev_purpose_code":"73","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"17553000001243","new_purpose_code":"73","new_purpose_group":"19966000000909"}},{"rowno":"005","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/1462","case_no":"2023/1462","trn_bor_caseid":"16022000007510","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"006","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/1589","case_no":"2023/1589","trn_bor_caseid":"13390000008450","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"007","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/1783","case_no":"2023/1783","trn_bor_caseid":"10294000007624","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"23/05/2023","next_hear_date":"26/05/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"008","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/1884","case_no":"2023/1884","trn_bor_caseid":"19897000007745","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"009","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/1885","case_no":"2023/1885","trn_bor_caseid":"10105000007834","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"0010","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/1945","case_no":"2023/1945","trn_bor_caseid":"11807000007555","manual_case_no":"","bench_code":"4","prev_case_purpose":"??? ???? ?????? ????","prev_purpose_code":"108","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"10024000000944","new_purpose_code":"108","new_purpose_group":"19966000000909"}},{"rowno":"0011","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/2034","case_no":"2023/2034","trn_bor_caseid":"13324000007373","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"23/05/2023","next_hear_date":"26/05/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"0012","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/2126","case_no":"2023/2126","trn_bor_caseid":"17183000007765","manual_case_no":"","bench_code":"4","prev_case_purpose":"??????","prev_purpose_code":"2","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"10001000000775","new_purpose_code":"2","new_purpose_group":"19966000000909"}},{"rowno":"0013","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/2202","case_no":"2023/2202","trn_bor_caseid":"19059000007938","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ???? ??????","prev_purpose_code":"73","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"17553000001243","new_purpose_code":"73","new_purpose_group":"19966000000909"}},{"rowno":"0014","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/2236","case_no":"2023/2236","trn_bor_caseid":"17260000007794","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"0015","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/2266","case_no":"2023/2266","trn_bor_caseid":"11165000006943","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ???? ??????","prev_purpose_code":"73","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"17553000001243","new_purpose_code":"73","new_purpose_group":"19966000000909"}},{"rowno":"0016","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/2299","case_no":"2023/2299","trn_bor_caseid":"15762000007428","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"0017","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/2341","case_no":"2023/2341","trn_bor_caseid":"12184000008816","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"0018","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/2368","case_no":"2023/2368","trn_bor_caseid":"15306000006326","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"0019","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/2407","case_no":"2023/2407","trn_bor_caseid":"11914000008414","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ???? ??????","prev_purpose_code":"73","prev_hear_date":"23/05/2023","next_hear_date":"23/05/2023","new_case_purpose":"15904000000025","new_purpose_code":"301","new_purpose_group":"18437000000000"}},{"rowno":"0020","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/2410","case_no":"2023/2410","trn_bor_caseid":"12150000007854","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"0021","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/2449","case_no":"2023/2449","trn_bor_caseid":"18476000007371","manual_case_no":"","bench_code":"4","prev_case_purpose":"?????? ????","prev_purpose_code":"121","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"10109000001043","new_purpose_code":"121","new_purpose_group":"19966000000909"}},{"rowno":"0022","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062016/5600","case_no":"2016/5600","trn_bor_caseid":"990144427","manual_case_no":"","bench_code":"4","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"0023","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062018/7614","case_no":"2018/7614","trn_bor_caseid":"10615000002766","manual_case_no":"","bench_code":"4","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"23/05/2023","next_hear_date":"25/05/2023","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"0024","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062022/2571","case_no":"2022/2571","trn_bor_caseid":"19062000007384","manual_case_no":"","bench_code":"4","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"23/05/2023","next_hear_date":"26/05/2023","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"0025","text":"0","columns":{"puname":"dikshabor","court_name":"11599000000000","court_code":"10006","docid":"100062023/437","case_no":"2023/437","trn_bor_caseid":"18065000007303","manual_case_no":"","bench_code":"4","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"23/05/2023","next_hear_date":"29/05/2023","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}}]},{"axp_recid3":[{"rowno":"001","text":"0","columns":{"trn_bor_caseregid":"11914000008414","officer_mastid":"1939660006405","request_type":"RESERVED","mem_inactive":"NO","memcount":"1"}}]},{"axp_recid4":[{"rowno":"001","text":"0","columns":{"is_update":"1","trn_bor_case_id":"11914000008414","memupdate":"1"}}]}]}}
Verifying username and password
User Name : dikshabor
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=dikshabor
Time elapsed = 15
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 6
Result : 
Verifying completed...
Page Access Category : 
User Name : dikshabor
Select sysdate as sdt from dual
Time elapsed = 4
dt=24/05/2023 10:39:37
Select sysdate as sdt from dual
Time elapsed = 5
Select usergroup from AXUSERLEVELGROUPS WHERE (lower(username) =:U) and ((startdate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') >= startdate) or (startdate is null)) and ((enddate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') <= enddate) or (enddate is null))
U=dikshabor
dt=24/05/2023 10:39:37
dt=24/05/2023 10:39:37
Time elapsed = 12
User Groups: rb_admin
select userroles from axusergroups where groupname in ( 'rb_admin' )
Time elapsed = 4
User Roles : rb_admin
Loading App/User vars
reading the props xml
Step3
Sql : select props from axprops where lower(name)= :name  order by blobno

Paramval : app
ParamTYpe : c
Param List : name

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

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

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

Paramval : rb_admin,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:4407
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 = 4
select * from Axusers where 1=2
Time elapsed = 5
select distinct(fldname) from AxTempUserFields
Time elapsed = 5
select * from AxAttachWorkflow where lower(transid) = 'bocup'
Time elapsed = 7
select distinct(schemaname) from axschema where lower(transid)='rbcrt'
Time elapsed = 4
select trn_bor_caseregid from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 4
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 = 4
select case_purpose_name from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 5
select distinct(schemaname) from axschema where lower(transid)='rbcrt'
Time elapsed = 4
select case_purpose_code from trn_bor_casereg where trn_bor_caseregid=0
Time elapsed = 3
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:2090
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 = 6
select * from trn_bor_case_hist where trn_bor_case_histid=0
Time elapsed = 5
   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 = 23/05/2023
cltype = A
benchname = ??. ??-3
benchcode = 4
cluser = 
bench_mem1 = 0
bench_mem2 = 0
time zone difference  = 0

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

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

Time elapsed = 4
RecordId = 15837000007057
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
cluser = 
benchcode = 4
bench_mem2 = 0
bench_mem1 = 0
benchname = ??. ??-3
courtcode = 10006
courtname = 11599000000000
cltype = A
cldate = 23/05/2023
Posting record
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:37
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
benchcode=4
Param Type = c
bench_mem2=0
Param Type = c
bench_mem1=0
Param Type = c
benchname=??. ??-3
Param Type = c
courtcode=10006
Param Type = c
courtname=11599000000000
Param Type = c
cltype=A
Param Type = c
cldate=23/05/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_CASEMEMBER
select * from TRN_BOR_CASEMEMBER where  TRN_BOR_CASEMEMBERid=0
Time elapsed = 3
Adding new record to store data from Frame 3, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 15837000007058
Select sysdate as sdt from dual
Time elapsed = 4
officer_mastid = 1939660006405
trn_bor_caseregid = 11914000008414
mem_inactive = NO
request_type = RESERVED
TRN_BOR_CASEMEMBERrow = 1
Posting record
Param Type = n
trn_bor_casememberid=15837000007058
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = c
officer_mastid=1939660006405
Param Type = n
trn_bor_caseregid=11914000008414
Param Type = c
mem_inactive=NO
Param Type = c
request_type=RESERVED
Param Type = n
trn_bor_casememberrow=1
insert into TRN_BOR_CASEMEMBER (trn_bor_casememberid,trn_bor_mhearingid,officer_mastid,trn_bor_caseregid,mem_inactive,request_type,trn_bor_casememberrow) values (:trn_bor_casememberid,:trn_bor_mhearingid,:officer_mastid,:trn_bor_caseregid,:mem_inactive,:request_type,:trn_bor_casememberrow)

Saving to table TRN_BOR_HEARING
select * from TRN_BOR_HEARING where  TRN_BOR_HEARINGid=0
Time elapsed = 7
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 = 15837000007059
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
case_no = 2022/5759
trn_bor_caseid = 18667000007503
manual_case_no = 
docid = 100062022/5759
puname = dikshabor
court_name = 11599000000000
court_code = 10006
new_purpose_code = 229
new_purpose_group = 19966000000909
next_hear_date = 25/05/2023
new_case_purpose = 11356000002249
bench_code = 4
prev_purpose_code = 229
prev_hear_date = 23/05/2023
TRN_BOR_HEARINGrow = 1
Posting record
Param Type = n
trn_bor_hearingid=15837000007059
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:37
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:37
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2022/5759
Param Type = n
trn_bor_caseid=18667000007503
Param Type = c
docid=100062022/5759
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=229
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = c
new_case_purpose=11356000002249
Param Type = c
bench_code=4
Param Type = c
prev_purpose_code=229
Param Type = c
prev_hear_date=23/05/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 = 4
RecordId = 15837000007060
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2023/277
trn_bor_caseid = 15806000006591
manual_case_no = 
docid = 100062023/277
puname = dikshabor
court_name = 11599000000000
court_code = 10006
new_purpose_code = 121
new_purpose_group = 19966000000909
next_hear_date = 26/05/2023
new_case_purpose = 10109000001043
bench_code = 4
prev_purpose_code = 121
prev_hear_date = 23/05/2023
TRN_BOR_HEARINGrow = 2
Posting record
Param Type = n
trn_bor_hearingid=15837000007060
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:38
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/277
Param Type = n
trn_bor_caseid=15806000006591
Param Type = c
docid=100062023/277
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=121
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=26/05/2023 00:00:00
Param Type = c
new_case_purpose=10109000001043
Param Type = c
bench_code=4
Param Type = c
prev_purpose_code=121
Param Type = c
prev_hear_date=23/05/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 = 15837000007061
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 8
case_no = 2023/875
trn_bor_caseid = 12463000008330
manual_case_no = 
docid = 100062023/875
puname = dikshabor
court_name = 11599000000000
court_code = 10006
new_purpose_code = 121
new_purpose_group = 19966000000909
next_hear_date = 19/10/2023
new_case_purpose = 10109000001043
bench_code = 4
prev_purpose_code = 121
prev_hear_date = 23/05/2023
TRN_BOR_HEARINGrow = 3
Posting record
Param Type = n
trn_bor_hearingid=15837000007061
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:38
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/875
Param Type = n
trn_bor_caseid=12463000008330
Param Type = c
docid=100062023/875
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=121
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=19/10/2023 00:00:00
Param Type = c
new_case_purpose=10109000001043
Param Type = c
bench_code=4
Param Type = c
prev_purpose_code=121
Param Type = c
prev_hear_date=23/05/2023 00:00:00
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,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 = 6
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 = 15837000007062
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
prev_hear_date = 23/05/2023
prev_purpose_code = 73
bench_code = 4
new_case_purpose = 17553000001243
next_hear_date = 25/05/2023
new_purpose_group = 19966000000909
new_purpose_code = 73
court_code = 10006
court_name = 11599000000000
puname = dikshabor
docid = 100062023/991
manual_case_no = 
trn_bor_caseid = 10095000007426
case_no = 2023/991
TRN_BOR_HEARINGrow = 4
Posting record
Param Type = n
trn_bor_hearingid=15837000007062
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:38
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
prev_purpose_code=73
Param Type = c
bench_code=4
Param Type = c
new_case_purpose=17553000001243
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = n
new_purpose_group=19966000000909
Param Type = c
new_purpose_code=73
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
puname=dikshabor
Param Type = c
docid=100062023/991
Param Type = n
trn_bor_caseid=10095000007426
Param Type = c
case_no=2023/991
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,prev_hear_date,prev_purpose_code,bench_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_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,:bench_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:court_name,:puname,:docid,null,:trn_bor_caseid,:case_no,: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 = 15837000007063
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2023/1462
trn_bor_caseid = 16022000007510
manual_case_no = 
docid = 100062023/1462
puname = dikshabor
court_name = 11599000000000
court_code = 10006
new_purpose_group = 19966000000909
next_hear_date = 25/05/2023
new_case_purpose = 10109000001043
new_purpose_code = 121
bench_code = 4
prev_purpose_code = 121
prev_hear_date = 23/05/2023
TRN_BOR_HEARINGrow = 5
Posting record
Param Type = n
trn_bor_hearingid=15837000007063
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:38
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/1462
Param Type = n
trn_bor_caseid=16022000007510
Param Type = c
docid=100062023/1462
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = c
new_case_purpose=10109000001043
Param Type = c
new_purpose_code=121
Param Type = c
bench_code=4
Param Type = c
prev_purpose_code=121
Param Type = c
prev_hear_date=23/05/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_group,next_hear_date,new_case_purpose,new_purpose_code,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_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:new_purpose_code,: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 6 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 15837000007064
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
docid = 100062023/1589
case_no = 2023/1589
puname = dikshabor
court_name = 11599000000000
court_code = 10006
trn_bor_caseid = 13390000008450
new_purpose_code = 121
new_case_purpose = 10109000001043
next_hear_date = 25/05/2023
new_purpose_group = 19966000000909
bench_code = 4
manual_case_no = 
prev_hear_date = 23/05/2023
prev_purpose_code = 121
TRN_BOR_HEARINGrow = 6
Posting record
Param Type = n
trn_bor_hearingid=15837000007064
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:38
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
docid=100062023/1589
Param Type = c
case_no=2023/1589
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = n
trn_bor_caseid=13390000008450
Param Type = c
new_purpose_code=121
Param Type = c
new_case_purpose=10109000001043
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = n
new_purpose_group=19966000000909
Param Type = c
bench_code=4
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
prev_purpose_code=121
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,docid,case_no,puname,court_name,court_code,trn_bor_caseid,new_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,bench_code,manual_case_no,prev_hear_date,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,:docid,:case_no,:puname,:court_name,:court_code,:trn_bor_caseid,:new_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:bench_code,null,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_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 7 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 15837000007065
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
bench_code = 4
prev_purpose_code = 121
manual_case_no = 
court_name = 11599000000000
puname = dikshabor
next_hear_date = 26/05/2023
new_purpose_group = 19966000000909
new_purpose_code = 121
prev_hear_date = 23/05/2023
new_case_purpose = 10109000001043
case_no = 2023/1783
trn_bor_caseid = 10294000007624
court_code = 10006
docid = 100062023/1783
TRN_BOR_HEARINGrow = 7
Posting record
Param Type = n
trn_bor_hearingid=15837000007065
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:38
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
bench_code=4
Param Type = c
prev_purpose_code=121
Param Type = c
court_name=11599000000000
Param Type = c
puname=dikshabor
Param Type = c
next_hear_date=26/05/2023 00:00:00
Param Type = n
new_purpose_group=19966000000909
Param Type = c
new_purpose_code=121
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
new_case_purpose=10109000001043
Param Type = c
case_no=2023/1783
Param Type = n
trn_bor_caseid=10294000007624
Param Type = c
court_code=10006
Param Type = c
docid=100062023/1783
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,bench_code,prev_purpose_code,manual_case_no,court_name,puname,next_hear_date,new_purpose_group,new_purpose_code,prev_hear_date,new_case_purpose,case_no,trn_bor_caseid,court_code,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,:bench_code,:prev_purpose_code,null,:court_name,:puname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:case_no,:trn_bor_caseid,:court_code,: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 8 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 15837000007066
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
court_code = 10006
docid = 100062023/1884
case_no = 2023/1884
court_name = 11599000000000
prev_purpose_code = 121
prev_hear_date = 23/05/2023
puname = dikshabor
next_hear_date = 25/05/2023
trn_bor_caseid = 19897000007745
bench_code = 4
new_purpose_group = 19966000000909
new_case_purpose = 10109000001043
manual_case_no = 
new_purpose_code = 121
TRN_BOR_HEARINGrow = 8
Posting record
Param Type = n
trn_bor_hearingid=15837000007066
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:38
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10006
Param Type = c
docid=100062023/1884
Param Type = c
case_no=2023/1884
Param Type = c
court_name=11599000000000
Param Type = c
prev_purpose_code=121
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
puname=dikshabor
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = n
trn_bor_caseid=19897000007745
Param Type = c
bench_code=4
Param Type = n
new_purpose_group=19966000000909
Param Type = c
new_case_purpose=10109000001043
Param Type = c
new_purpose_code=121
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,court_code,docid,case_no,court_name,prev_purpose_code,prev_hear_date,puname,next_hear_date,trn_bor_caseid,bench_code,new_purpose_group,new_case_purpose,manual_case_no,new_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,:court_code,:docid,:case_no,:court_name,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:puname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_caseid,:bench_code,:new_purpose_group,:new_case_purpose,null,:new_purpose_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 9 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 15837000007067
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
case_no = 2023/1885
trn_bor_caseid = 10105000007834
manual_case_no = 
docid = 100062023/1885
puname = dikshabor
court_name = 11599000000000
court_code = 10006
new_purpose_code = 121
new_purpose_group = 19966000000909
next_hear_date = 25/05/2023
new_case_purpose = 10109000001043
bench_code = 4
prev_purpose_code = 121
prev_hear_date = 23/05/2023
TRN_BOR_HEARINGrow = 9
Posting record
Param Type = n
trn_bor_hearingid=15837000007067
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:38
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/1885
Param Type = n
trn_bor_caseid=10105000007834
Param Type = c
docid=100062023/1885
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=121
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = c
new_case_purpose=10109000001043
Param Type = c
bench_code=4
Param Type = c
prev_purpose_code=121
Param Type = c
prev_hear_date=23/05/2023 00:00:00
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,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 10 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 15837000007068
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
case_no = 2023/1945
trn_bor_caseid = 11807000007555
manual_case_no = 
docid = 100062023/1945
puname = dikshabor
court_name = 11599000000000
court_code = 10006
new_purpose_code = 108
new_purpose_group = 19966000000909
next_hear_date = 25/05/2023
new_case_purpose = 10024000000944
bench_code = 4
prev_purpose_code = 108
prev_hear_date = 23/05/2023
TRN_BOR_HEARINGrow = 10
Posting record
Param Type = n
trn_bor_hearingid=15837000007068
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:38
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/1945
Param Type = n
trn_bor_caseid=11807000007555
Param Type = c
docid=100062023/1945
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=108
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = c
new_case_purpose=10024000000944
Param Type = c
bench_code=4
Param Type = c
prev_purpose_code=108
Param Type = c
prev_hear_date=23/05/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,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 11 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 15837000007069
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
prev_hear_date = 23/05/2023
prev_purpose_code = 121
bench_code = 4
new_case_purpose = 10109000001043
next_hear_date = 26/05/2023
new_purpose_group = 19966000000909
new_purpose_code = 121
court_code = 10006
court_name = 11599000000000
puname = dikshabor
docid = 100062023/2034
manual_case_no = 
trn_bor_caseid = 13324000007373
case_no = 2023/2034
TRN_BOR_HEARINGrow = 11
Posting record
Param Type = n
trn_bor_hearingid=15837000007069
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:38
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
prev_purpose_code=121
Param Type = c
bench_code=4
Param Type = c
new_case_purpose=10109000001043
Param Type = c
next_hear_date=26/05/2023 00:00:00
Param Type = n
new_purpose_group=19966000000909
Param Type = c
new_purpose_code=121
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
puname=dikshabor
Param Type = c
docid=100062023/2034
Param Type = n
trn_bor_caseid=13324000007373
Param Type = c
case_no=2023/2034
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,prev_hear_date,prev_purpose_code,bench_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_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,:bench_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:court_name,:puname,:docid,null,:trn_bor_caseid,: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 = 15837000007070
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_purpose_code = 2
prev_hear_date = 23/05/2023
new_case_purpose = 10001000000775
case_no = 2023/2126
trn_bor_caseid = 17183000007765
manual_case_no = 
bench_code = 4
court_code = 10006
court_name = 11599000000000
puname = dikshabor
docid = 100062023/2126
new_purpose_code = 2
new_purpose_group = 19966000000909
next_hear_date = 25/05/2023
TRN_BOR_HEARINGrow = 12
Posting record
Param Type = n
trn_bor_hearingid=15837000007070
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:38
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:38
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_purpose_code=2
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
new_case_purpose=10001000000775
Param Type = c
case_no=2023/2126
Param Type = n
trn_bor_caseid=17183000007765
Param Type = c
bench_code=4
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
puname=dikshabor
Param Type = c
docid=100062023/2126
Param Type = c
new_purpose_code=2
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=25/05/2023 00:00:00
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,prev_purpose_code,prev_hear_date,new_case_purpose,case_no,trn_bor_caseid,manual_case_no,bench_code,court_code,court_name,puname,docid,new_purpose_code,new_purpose_group,next_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,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:case_no,:trn_bor_caseid,null,:bench_code,:court_code,:court_name,:puname,:docid,:new_purpose_code,:new_purpose_group,to_date(:next_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 13 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 15837000007071
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
court_code = 10006
next_hear_date = 25/05/2023
docid = 100062023/2202
court_name = 11599000000000
new_purpose_group = 19966000000909
new_purpose_code = 73
puname = dikshabor
case_no = 2023/2202
new_case_purpose = 17553000001243
prev_purpose_code = 73
prev_hear_date = 23/05/2023
bench_code = 4
trn_bor_caseid = 19059000007938
manual_case_no = 
TRN_BOR_HEARINGrow = 13
Posting record
Param Type = n
trn_bor_hearingid=15837000007071
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:39
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_code=10006
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = c
docid=100062023/2202
Param Type = c
court_name=11599000000000
Param Type = n
new_purpose_group=19966000000909
Param Type = c
new_purpose_code=73
Param Type = c
puname=dikshabor
Param Type = c
case_no=2023/2202
Param Type = c
new_case_purpose=17553000001243
Param Type = c
prev_purpose_code=73
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
bench_code=4
Param Type = n
trn_bor_caseid=19059000007938
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,court_code,next_hear_date,docid,court_name,new_purpose_group,new_purpose_code,puname,case_no,new_case_purpose,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,:court_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:docid,:court_name,:new_purpose_group,:new_purpose_code,:puname,:case_no,:new_case_purpose,: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 14 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 2
RecordId = 15837000007072
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
court_name = 11599000000000
puname = dikshabor
new_case_purpose = 10109000001043
prev_hear_date = 23/05/2023
prev_purpose_code = 121
next_hear_date = 25/05/2023
new_purpose_group = 19966000000909
new_purpose_code = 121
trn_bor_caseid = 17260000007794
case_no = 2023/2236
docid = 100062023/2236
court_code = 10006
bench_code = 4
manual_case_no = 
TRN_BOR_HEARINGrow = 14
Posting record
Param Type = n
trn_bor_hearingid=15837000007072
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:39
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
court_name=11599000000000
Param Type = c
puname=dikshabor
Param Type = c
new_case_purpose=10109000001043
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
prev_purpose_code=121
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = n
new_purpose_group=19966000000909
Param Type = c
new_purpose_code=121
Param Type = n
trn_bor_caseid=17260000007794
Param Type = c
case_no=2023/2236
Param Type = c
docid=100062023/2236
Param Type = c
court_code=10006
Param Type = c
bench_code=4
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,court_name,puname,new_case_purpose,prev_hear_date,prev_purpose_code,next_hear_date,new_purpose_group,new_purpose_code,trn_bor_caseid,case_no,docid,court_code,bench_code,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,:court_name,:puname,:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:trn_bor_caseid,:case_no,:docid,:court_code,:bench_code,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 15 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 15837000007073
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
puname = dikshabor
bench_code = 4
docid = 100062023/2266
prev_purpose_code = 73
case_no = 2023/2266
trn_bor_caseid = 11165000006943
manual_case_no = 
prev_hear_date = 23/05/2023
next_hear_date = 25/05/2023
court_code = 10006
court_name = 11599000000000
new_case_purpose = 17553000001243
new_purpose_code = 73
new_purpose_group = 19966000000909
TRN_BOR_HEARINGrow = 15
Posting record
Param Type = n
trn_bor_hearingid=15837000007073
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:39
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
puname=dikshabor
Param Type = c
bench_code=4
Param Type = c
docid=100062023/2266
Param Type = c
prev_purpose_code=73
Param Type = c
case_no=2023/2266
Param Type = n
trn_bor_caseid=11165000006943
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
new_case_purpose=17553000001243
Param Type = c
new_purpose_code=73
Param Type = n
new_purpose_group=19966000000909
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,puname,bench_code,docid,prev_purpose_code,case_no,trn_bor_caseid,manual_case_no,prev_hear_date,next_hear_date,court_code,court_name,new_case_purpose,new_purpose_code,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,:puname,:bench_code,:docid,:prev_purpose_code,:case_no,:trn_bor_caseid,null,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:court_name,:new_case_purpose,:new_purpose_code,:new_purpose_group,: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 16 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 15837000007074
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
case_no = 2023/2299
trn_bor_caseid = 15762000007428
manual_case_no = 
docid = 100062023/2299
puname = dikshabor
court_name = 11599000000000
court_code = 10006
new_purpose_code = 121
new_purpose_group = 19966000000909
next_hear_date = 25/05/2023
new_case_purpose = 10109000001043
bench_code = 4
prev_purpose_code = 121
prev_hear_date = 23/05/2023
TRN_BOR_HEARINGrow = 16
Posting record
Param Type = n
trn_bor_hearingid=15837000007074
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:39
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
case_no=2023/2299
Param Type = n
trn_bor_caseid=15762000007428
Param Type = c
docid=100062023/2299
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_purpose_code=121
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = c
new_case_purpose=10109000001043
Param Type = c
bench_code=4
Param Type = c
prev_purpose_code=121
Param Type = c
prev_hear_date=23/05/2023 00:00:00
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,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 = 6
Adding new record to store data from Frame 2, Row 17 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 6
RecordId = 15837000007075
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 6
next_hear_date = 25/05/2023
docid = 100062023/2341
new_purpose_group = 19966000000909
case_no = 2023/2341
puname = dikshabor
court_name = 11599000000000
court_code = 10006
trn_bor_caseid = 12184000008816
prev_purpose_code = 121
prev_hear_date = 23/05/2023
new_case_purpose = 10109000001043
manual_case_no = 
bench_code = 4
new_purpose_code = 121
TRN_BOR_HEARINGrow = 17
Posting record
Param Type = n
trn_bor_hearingid=15837000007075
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:39
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = c
docid=100062023/2341
Param Type = n
new_purpose_group=19966000000909
Param Type = c
case_no=2023/2341
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = n
trn_bor_caseid=12184000008816
Param Type = c
prev_purpose_code=121
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
new_case_purpose=10109000001043
Param Type = c
bench_code=4
Param Type = c
new_purpose_code=121
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,next_hear_date,docid,new_purpose_group,case_no,puname,court_name,court_code,trn_bor_caseid,prev_purpose_code,prev_hear_date,new_case_purpose,manual_case_no,bench_code,new_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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:docid,:new_purpose_group,:case_no,:puname,:court_name,:court_code,:trn_bor_caseid,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,null,:bench_code,:new_purpose_code,:trn_bor_hearingrow)

select * from TRN_BOR_HEARING where  TRN_BOR_HEARINGid=0
Time elapsed = 11
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 = 15837000007076
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
next_hear_date = 25/05/2023
docid = 100062023/2368
case_no = 2023/2368
trn_bor_caseid = 15306000006326
puname = dikshabor
court_name = 11599000000000
court_code = 10006
manual_case_no = 
new_case_purpose = 10109000001043
new_purpose_code = 121
new_purpose_group = 19966000000909
bench_code = 4
prev_purpose_code = 121
prev_hear_date = 23/05/2023
TRN_BOR_HEARINGrow = 18
Posting record
Param Type = n
trn_bor_hearingid=15837000007076
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:39
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = c
docid=100062023/2368
Param Type = c
case_no=2023/2368
Param Type = n
trn_bor_caseid=15306000006326
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
new_case_purpose=10109000001043
Param Type = c
new_purpose_code=121
Param Type = n
new_purpose_group=19966000000909
Param Type = c
bench_code=4
Param Type = c
prev_purpose_code=121
Param Type = c
prev_hear_date=23/05/2023 00:00:00
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,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 19 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 15837000007077
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
next_hear_date = 23/05/2023
new_purpose_group = 18437000000000
docid = 100062023/2407
case_no = 2023/2407
trn_bor_caseid = 11914000008414
puname = dikshabor
court_name = 11599000000000
court_code = 10006
prev_hear_date = 23/05/2023
new_case_purpose = 15904000000025
new_purpose_code = 301
manual_case_no = 
bench_code = 4
prev_purpose_code = 73
TRN_BOR_HEARINGrow = 19
Posting record
Param Type = n
trn_bor_hearingid=15837000007077
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:39
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
next_hear_date=23/05/2023 00:00:00
Param Type = n
new_purpose_group=18437000000000
Param Type = c
docid=100062023/2407
Param Type = c
case_no=2023/2407
Param Type = n
trn_bor_caseid=11914000008414
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = c
court_code=10006
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
new_case_purpose=15904000000025
Param Type = c
new_purpose_code=301
Param Type = c
bench_code=4
Param Type = c
prev_purpose_code=73
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,next_hear_date,new_purpose_group,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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,: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 = 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 = 6
RecordId = 15837000007078
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
new_purpose_group = 19966000000909
next_hear_date = 25/05/2023
trn_bor_caseid = 12150000007854
case_no = 2023/2410
docid = 100062023/2410
bench_code = 4
prev_hear_date = 23/05/2023
manual_case_no = 
prev_purpose_code = 121
new_case_purpose = 10109000001043
new_purpose_code = 121
court_code = 10006
court_name = 11599000000000
puname = dikshabor
TRN_BOR_HEARINGrow = 20
Posting record
Param Type = n
trn_bor_hearingid=15837000007078
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:39
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = n
trn_bor_caseid=12150000007854
Param Type = c
case_no=2023/2410
Param Type = c
docid=100062023/2410
Param Type = c
bench_code=4
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
prev_purpose_code=121
Param Type = c
new_case_purpose=10109000001043
Param Type = c
new_purpose_code=121
Param Type = c
court_code=10006
Param Type = c
court_name=11599000000000
Param Type = c
puname=dikshabor
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,new_purpose_group,next_hear_date,trn_bor_caseid,case_no,docid,bench_code,prev_hear_date,manual_case_no,prev_purpose_code,new_case_purpose,new_purpose_code,court_code,court_name,puname,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'),:trn_bor_caseid,:case_no,:docid,:bench_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:prev_purpose_code,:new_case_purpose,:new_purpose_code,:court_code,:court_name,:puname,: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 21 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 5
RecordId = 15837000007079
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
new_purpose_group = 19966000000909
next_hear_date = 25/05/2023
new_purpose_code = 121
docid = 100062023/2449
case_no = 2023/2449
court_code = 10006
puname = dikshabor
court_name = 11599000000000
trn_bor_caseid = 18476000007371
prev_hear_date = 23/05/2023
new_case_purpose = 10109000001043
prev_purpose_code = 121
manual_case_no = 
bench_code = 4
TRN_BOR_HEARINGrow = 21
Posting record
Param Type = n
trn_bor_hearingid=15837000007079
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:39
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
new_purpose_group=19966000000909
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = c
new_purpose_code=121
Param Type = c
docid=100062023/2449
Param Type = c
case_no=2023/2449
Param Type = c
court_code=10006
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = n
trn_bor_caseid=18476000007371
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
new_case_purpose=10109000001043
Param Type = c
prev_purpose_code=121
Param Type = c
bench_code=4
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,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 = 4
Adding new record to store data from Frame 2, Row 22 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 15837000007080
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
new_purpose_code = 120
new_purpose_group = 19973000000612
next_hear_date = 25/05/2023
docid = 100062016/5600
case_no = 2016/5600
court_code = 10006
puname = dikshabor
court_name = 11599000000000
trn_bor_caseid = 990144427
prev_hear_date = 23/05/2023
new_case_purpose = 10107000000777
prev_purpose_code = 120
manual_case_no = 
bench_code = 4
TRN_BOR_HEARINGrow = 22
Posting record
Param Type = n
trn_bor_hearingid=15837000007080
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:39
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_purpose_code=120
Param Type = n
new_purpose_group=19973000000612
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = c
docid=100062016/5600
Param Type = c
case_no=2016/5600
Param Type = c
court_code=10006
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = n
trn_bor_caseid=990144427
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
new_case_purpose=10107000000777
Param Type = c
prev_purpose_code=120
Param Type = c
bench_code=4
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,new_purpose_code,new_purpose_group,next_hear_date,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_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),: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 = 4
Adding new record to store data from Frame 2, Row 23 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 15837000007081
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
new_purpose_code = 120
new_purpose_group = 19973000000612
next_hear_date = 25/05/2023
new_case_purpose = 10107000000777
court_code = 10006
docid = 100062018/7614
court_name = 11599000000000
manual_case_no = 
puname = dikshabor
prev_purpose_code = 120
prev_hear_date = 23/05/2023
bench_code = 4
case_no = 2018/7614
trn_bor_caseid = 10615000002766
TRN_BOR_HEARINGrow = 23
Posting record
Param Type = n
trn_bor_hearingid=15837000007081
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:39
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:39
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_purpose_code=120
Param Type = n
new_purpose_group=19973000000612
Param Type = c
next_hear_date=25/05/2023 00:00:00
Param Type = c
new_case_purpose=10107000000777
Param Type = c
court_code=10006
Param Type = c
docid=100062018/7614
Param Type = c
court_name=11599000000000
Param Type = c
puname=dikshabor
Param Type = c
prev_purpose_code=120
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
bench_code=4
Param Type = c
case_no=2018/7614
Param Type = n
trn_bor_caseid=10615000002766
Param Type = n
trn_bor_hearingrow=23
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,court_code,docid,court_name,manual_case_no,puname,prev_purpose_code,prev_hear_date,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_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:court_code,:docid,:court_name,null,:puname,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),: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 24 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 3
RecordId = 15837000007082
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
new_purpose_code = 120
new_case_purpose = 10107000000777
next_hear_date = 26/05/2023
new_purpose_group = 19973000000612
docid = 100062022/2571
case_no = 2022/2571
court_code = 10006
puname = dikshabor
court_name = 11599000000000
prev_purpose_code = 120
prev_hear_date = 23/05/2023
bench_code = 4
trn_bor_caseid = 19062000007384
manual_case_no = 
TRN_BOR_HEARINGrow = 24
Posting record
Param Type = n
trn_bor_hearingid=15837000007082
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:40
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_purpose_code=120
Param Type = c
new_case_purpose=10107000000777
Param Type = c
next_hear_date=26/05/2023 00:00:00
Param Type = n
new_purpose_group=19973000000612
Param Type = c
docid=100062022/2571
Param Type = c
case_no=2022/2571
Param Type = c
court_code=10006
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = c
prev_purpose_code=120
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
bench_code=4
Param Type = n
trn_bor_caseid=19062000007384
Param Type = n
trn_bor_hearingrow=24
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 = 5
Adding new record to store data from Frame 2, Row 25 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 15837000007083
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
new_case_purpose = 10107000000777
new_purpose_code = 120
next_hear_date = 29/05/2023
new_purpose_group = 19973000000612
prev_hear_date = 23/05/2023
court_code = 10006
docid = 100062023/437
puname = dikshabor
court_name = 11599000000000
case_no = 2023/437
bench_code = 4
prev_purpose_code = 120
trn_bor_caseid = 18065000007303
manual_case_no = 
TRN_BOR_HEARINGrow = 25
Posting record
Param Type = n
trn_bor_hearingid=15837000007083
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:40
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:40
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
new_case_purpose=10107000000777
Param Type = c
new_purpose_code=120
Param Type = c
next_hear_date=29/05/2023 00:00:00
Param Type = n
new_purpose_group=19973000000612
Param Type = c
prev_hear_date=23/05/2023 00:00:00
Param Type = c
court_code=10006
Param Type = c
docid=100062023/437
Param Type = c
puname=dikshabor
Param Type = c
court_name=11599000000000
Param Type = c
case_no=2023/437
Param Type = c
bench_code=4
Param Type = c
prev_purpose_code=120
Param Type = n
trn_bor_caseid=18065000007303
Param Type = n
trn_bor_hearingrow=25
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_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,: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_code,:docid,:puname,:court_name,:case_no,:bench_code,:prev_purpose_code,:trn_bor_caseid,null,:trn_bor_hearingrow)

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

Time elapsed = 4
RecordId = 15837000007084
Select sysdate as sdt from dual
Time elapsed = 5
memupdate = 1
trn_bor_case_id = 11914000008414
is_update = 1
TRN_BOR_ZFUPDATErow = 1
Posting record
Param Type = n
trn_bor_zfupdateid=15837000007084
Param Type = n
trn_bor_mhearingid=15837000007057
Param Type = n
memupdate=1
Param Type = n
trn_bor_case_id=11914000008414
Param Type = n
is_update=1
Param Type = n
trn_bor_zfupdaterow=1
insert into TRN_BOR_ZFUPDATE (trn_bor_zfupdateid,trn_bor_mhearingid,memupdate,trn_bor_case_id,is_update,trn_bor_zfupdaterow) values (:trn_bor_zfupdateid,:trn_bor_mhearingid,:memupdate,:trn_bor_case_id,:is_update,:trn_bor_zfupdaterow)

Time elapsed for insert/update = 3894086324050

>>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 = 2022/5759 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ?????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 18667000007503 idvalue 0
Mapped case_docid Row = 1 value = 100062022/5759 idvalue 0
Mapped case_purpose Row = 1 value = 11356000002249 idvalue 0
Mapped case_purpose_code Row = 1 value = 229 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 18667000007503
case_docid = 100062022/5759
case_no = 2022/5759
prev_hearing_date = 23/05/2023
hearing_date = 25/05/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 = 6
prev_case_purpose after validation = 11356000002249
case_purpose = 11356000002249
case_purpose_code = 229
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 = 15837000007085
MapName bocup1
SourceId 15837000007059
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 7
prev_case_purpose = 11356000002249
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 229
hearing_date = 25/05/2023
prev_case_purposename = ???????? ??????
court_code = 10006
case_no = 2022/5759
case_docid = 100062022/5759
case_purpose = 11356000002249
trn_bor_caseregid = 18667000007503
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007085
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007059
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:41
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:41
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=11356000002249
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=24/05/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=229
Param Type = c
hearing_date=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=???????? ??????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/5759
Param Type = c
case_docid=100062022/5759
Param Type = c
case_purpose=11356000002249
Param Type = n
trn_bor_caseregid=18667000007503
Param Type = c
prev_hearing_date=23/05/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 = 2023/277 idvalue 0
Mapped hearing_date Row = 1 value = 26/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 15806000006591 idvalue 0
Mapped case_docid Row = 1 value = 100062023/277 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 15806000006591
case_docid = 100062023/277
case_no = 2023/277
prev_hearing_date = 23/05/2023
hearing_date = 26/05/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 = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 15837000007086
MapName bocup1
SourceId 15837000007060
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 = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 26/05/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/277
case_docid = 100062023/277
case_purpose = 10109000001043
trn_bor_caseregid = 15806000006591
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007086
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007060
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:41
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:41
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=24/05/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=26/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/277
Param Type = c
case_docid=100062023/277
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=15806000006591
Param Type = c
prev_hearing_date=23/05/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 = 2023/875 idvalue 0
Mapped hearing_date Row = 1 value = 19/10/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 12463000008330 idvalue 0
Mapped case_docid Row = 1 value = 100062023/875 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 12463000008330
case_docid = 100062023/875
case_no = 2023/875
prev_hearing_date = 23/05/2023
hearing_date = 19/10/2023
prev_case_purposename = ?????? ????
prev_case_purpose = 
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 = 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 = 15837000007087
MapName bocup1
SourceId 15837000007061
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10109000001043
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 19/10/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/875
case_docid = 100062023/875
case_purpose = 10109000001043
trn_bor_caseregid = 12463000008330
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007087
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007061
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:41
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:41
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=24/05/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=19/10/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/875
Param Type = c
case_docid=100062023/875
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=12463000008330
Param Type = c
prev_hearing_date=23/05/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 = 2023/991 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? ?????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 10095000007426 idvalue 0
Mapped case_docid Row = 1 value = 100062023/991 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 10095000007426
case_docid = 100062023/991
case_no = 2023/991
prev_hearing_date = 23/05/2023
hearing_date = 25/05/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 = 8
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 = 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 = 15837000007088
MapName bocup1
SourceId 15837000007062
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
prev_case_purpose = 17553000001243
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 73
hearing_date = 25/05/2023
prev_case_purposename = ?????? ???? ??????
court_code = 10006
case_no = 2023/991
case_docid = 100062023/991
case_purpose = 17553000001243
trn_bor_caseregid = 10095000007426
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007088
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007062
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:41
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39: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=24/05/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=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ???? ??????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/991
Param Type = c
case_docid=100062023/991
Param Type = c
case_purpose=17553000001243
Param Type = n
trn_bor_caseregid=10095000007426
Param Type = c
prev_hearing_date=23/05/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/1462 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 16022000007510 idvalue 0
Mapped case_docid Row = 1 value = 100062023/1462 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 16022000007510
case_docid = 100062023/1462
case_no = 2023/1462
prev_hearing_date = 23/05/2023
hearing_date = 25/05/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 = 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 = 15837000007089
MapName bocup1
SourceId 15837000007063
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 5
prev_case_purpose = 10109000001043
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/1462
case_docid = 100062023/1462
case_purpose = 10109000001043
trn_bor_caseregid = 16022000007510
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007089
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007063
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:41
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:41
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=24/05/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=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/1462
Param Type = c
case_docid=100062023/1462
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=16022000007510
Param Type = c
prev_hearing_date=23/05/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/1589 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 13390000008450 idvalue 0
Mapped case_docid Row = 1 value = 100062023/1589 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 13390000008450
case_docid = 100062023/1589
case_no = 2023/1589
prev_hearing_date = 23/05/2023
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
prev_case_purpose = 
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 = 6
Adding new record to store data from Frame 1, Row 1 Parent Row 0
update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn

Time elapsed = 4
RecordId = 15837000007090
MapName bocup1
SourceId 15837000007064
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10109000001043
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/1589
case_docid = 100062023/1589
case_purpose = 10109000001043
trn_bor_caseregid = 13390000008450
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007090
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007064
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:41
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:41
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=24/05/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=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/1589
Param Type = c
case_docid=100062023/1589
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=13390000008450
Param Type = c
prev_hearing_date=23/05/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/1783 idvalue 0
Mapped hearing_date Row = 1 value = 26/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 10294000007624 idvalue 0
Mapped case_docid Row = 1 value = 100062023/1783 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 10294000007624
case_docid = 100062023/1783
case_no = 2023/1783
prev_hearing_date = 23/05/2023
hearing_date = 26/05/2023
prev_case_purposename = ?????? ????
prev_case_purpose = 
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 = 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 = 15837000007091
MapName bocup1
SourceId 15837000007065
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10109000001043
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 26/05/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/1783
case_docid = 100062023/1783
case_purpose = 10109000001043
trn_bor_caseregid = 10294000007624
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007091
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007065
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:41
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:41
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=24/05/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=26/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/1783
Param Type = c
case_docid=100062023/1783
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=10294000007624
Param Type = c
prev_hearing_date=23/05/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 = 2023/1884 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 19897000007745 idvalue 0
Mapped case_docid Row = 1 value = 100062023/1884 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 19897000007745
case_docid = 100062023/1884
case_no = 2023/1884
prev_hearing_date = 23/05/2023
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
prev_case_purpose = 
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 = 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 = 15837000007092
MapName bocup1
SourceId 15837000007066
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10109000001043
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/1884
case_docid = 100062023/1884
case_purpose = 10109000001043
trn_bor_caseregid = 19897000007745
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007092
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007066
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:42
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:42
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=24/05/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=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/1884
Param Type = c
case_docid=100062023/1884
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=19897000007745
Param Type = c
prev_hearing_date=23/05/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 = 2023/1885 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 10105000007834 idvalue 0
Mapped case_docid Row = 1 value = 100062023/1885 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 10105000007834
case_docid = 100062023/1885
case_no = 2023/1885
prev_hearing_date = 23/05/2023
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
prev_case_purpose = 
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 = 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 = 15837000007093
MapName bocup1
SourceId 15837000007067
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
prev_case_purpose = 10109000001043
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/1885
case_docid = 100062023/1885
case_purpose = 10109000001043
trn_bor_caseregid = 10105000007834
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007093
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007067
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:42
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:42
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=24/05/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=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/1885
Param Type = c
case_docid=100062023/1885
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=10105000007834
Param Type = c
prev_hearing_date=23/05/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 = 2023/1945 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ??? ???? ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 11807000007555 idvalue 0
Mapped case_docid Row = 1 value = 100062023/1945 idvalue 0
Mapped case_purpose Row = 1 value = 10024000000944 idvalue 0
Mapped case_purpose_code Row = 1 value = 108 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 11807000007555
case_docid = 100062023/1945
case_no = 2023/1945
prev_hearing_date = 23/05/2023
hearing_date = 25/05/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 = 10024000000944
case_purpose = 10024000000944
case_purpose_code = 108
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 = 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 = 15837000007094
MapName bocup1
SourceId 15837000007068
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
prev_case_purpose = 10024000000944
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 108
hearing_date = 25/05/2023
prev_case_purposename = ??? ???? ?????? ????
court_code = 10006
case_no = 2023/1945
case_docid = 100062023/1945
case_purpose = 10024000000944
trn_bor_caseregid = 11807000007555
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007094
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007068
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:42
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10024000000944
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=24/05/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=108
Param Type = c
hearing_date=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=??? ???? ?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/1945
Param Type = c
case_docid=100062023/1945
Param Type = c
case_purpose=10024000000944
Param Type = n
trn_bor_caseregid=11807000007555
Param Type = c
prev_hearing_date=23/05/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 = 2023/2034 idvalue 0
Mapped hearing_date Row = 1 value = 26/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 13324000007373 idvalue 0
Mapped case_docid Row = 1 value = 100062023/2034 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 13324000007373
case_docid = 100062023/2034
case_no = 2023/2034
prev_hearing_date = 23/05/2023
hearing_date = 26/05/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 = 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 = 15837000007095
MapName bocup1
SourceId 15837000007069
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 5
prev_case_purpose = 10109000001043
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 26/05/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/2034
case_docid = 100062023/2034
case_purpose = 10109000001043
trn_bor_caseregid = 13324000007373
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007095
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007069
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:42
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:42
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=24/05/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=26/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/2034
Param Type = c
case_docid=100062023/2034
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=13324000007373
Param Type = c
prev_hearing_date=23/05/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 = 2023/2126 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 17183000007765 idvalue 0
Mapped case_docid Row = 1 value = 100062023/2126 idvalue 0
Mapped case_purpose Row = 1 value = 10001000000775 idvalue 0
Mapped case_purpose_code Row = 1 value = 2 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 17183000007765
case_docid = 100062023/2126
case_no = 2023/2126
prev_hearing_date = 23/05/2023
hearing_date = 25/05/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 = 6
prev_case_purpose after validation = 10001000000775
case_purpose = 10001000000775
case_purpose_code = 2
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 = 15837000007096
MapName bocup1
SourceId 15837000007070
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10001000000775
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 2
hearing_date = 25/05/2023
prev_case_purposename = ??????
court_code = 10006
case_no = 2023/2126
case_docid = 100062023/2126
case_purpose = 10001000000775
trn_bor_caseregid = 17183000007765
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007096
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007070
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:42
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:42
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10001000000775
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=24/05/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=2
Param Type = c
hearing_date=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=??????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/2126
Param Type = c
case_docid=100062023/2126
Param Type = c
case_purpose=10001000000775
Param Type = n
trn_bor_caseregid=17183000007765
Param Type = c
prev_hearing_date=23/05/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 = 2023/2202 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? ?????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 19059000007938 idvalue 0
Mapped case_docid Row = 1 value = 100062023/2202 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 19059000007938
case_docid = 100062023/2202
case_no = 2023/2202
prev_hearing_date = 23/05/2023
hearing_date = 25/05/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 = 6
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 = 3
RecordId = 15837000007097
MapName bocup1
SourceId 15837000007071
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 = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 73
hearing_date = 25/05/2023
prev_case_purposename = ?????? ???? ??????
court_code = 10006
case_no = 2023/2202
case_docid = 100062023/2202
case_purpose = 17553000001243
trn_bor_caseregid = 19059000007938
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007097
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007071
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:42
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:42
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=24/05/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=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ???? ??????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/2202
Param Type = c
case_docid=100062023/2202
Param Type = c
case_purpose=17553000001243
Param Type = n
trn_bor_caseregid=19059000007938
Param Type = c
prev_hearing_date=23/05/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 = 2023/2236 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 17260000007794 idvalue 0
Mapped case_docid Row = 1 value = 100062023/2236 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 17260000007794
case_docid = 100062023/2236
case_no = 2023/2236
prev_hearing_date = 23/05/2023
hearing_date = 25/05/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 = 6
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 = 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 = 15837000007098
MapName bocup1
SourceId 15837000007072
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 = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/2236
case_docid = 100062023/2236
case_purpose = 10109000001043
trn_bor_caseregid = 17260000007794
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007098
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007072
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:42
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:42
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=24/05/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=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/2236
Param Type = c
case_docid=100062023/2236
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=17260000007794
Param Type = c
prev_hearing_date=23/05/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 = 2023/2266 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? ?????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 11165000006943 idvalue 0
Mapped case_docid Row = 1 value = 100062023/2266 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 11165000006943
case_docid = 100062023/2266
case_no = 2023/2266
prev_hearing_date = 23/05/2023
hearing_date = 25/05/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 = 15837000007099
MapName bocup1
SourceId 15837000007073
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 17553000001243
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 73
hearing_date = 25/05/2023
prev_case_purposename = ?????? ???? ??????
court_code = 10006
case_no = 2023/2266
case_docid = 100062023/2266
case_purpose = 17553000001243
trn_bor_caseregid = 11165000006943
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007099
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007073
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:43
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:43
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=24/05/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=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ???? ??????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/2266
Param Type = c
case_docid=100062023/2266
Param Type = c
case_purpose=17553000001243
Param Type = n
trn_bor_caseregid=11165000006943
Param Type = c
prev_hearing_date=23/05/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 = 2023/2299 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 15762000007428 idvalue 0
Mapped case_docid Row = 1 value = 100062023/2299 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 15762000007428
case_docid = 100062023/2299
case_no = 2023/2299
prev_hearing_date = 23/05/2023
hearing_date = 25/05/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 = 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 = 15837000007100
MapName bocup1
SourceId 15837000007074
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10109000001043
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/2299
case_docid = 100062023/2299
case_purpose = 10109000001043
trn_bor_caseregid = 15762000007428
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007100
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007074
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:43
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:43
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=24/05/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=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/2299
Param Type = c
case_docid=100062023/2299
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=15762000007428
Param Type = c
prev_hearing_date=23/05/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 = 2023/2341 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 12184000008816 idvalue 0
Mapped case_docid Row = 1 value = 100062023/2341 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 12184000008816
case_docid = 100062023/2341
case_no = 2023/2341
prev_hearing_date = 23/05/2023
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
prev_case_purpose = 
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 = 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 = 15837000007101
MapName bocup1
SourceId 15837000007075
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10109000001043
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/2341
case_docid = 100062023/2341
case_purpose = 10109000001043
trn_bor_caseregid = 12184000008816
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007101
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007075
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:43
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:43
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=24/05/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=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/2341
Param Type = c
case_docid=100062023/2341
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=12184000008816
Param Type = c
prev_hearing_date=23/05/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 = 2023/2368 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 15306000006326 idvalue 0
Mapped case_docid Row = 1 value = 100062023/2368 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 15306000006326
case_docid = 100062023/2368
case_no = 2023/2368
prev_hearing_date = 23/05/2023
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
prev_case_purpose = 
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 = 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 = 15837000007102
MapName bocup1
SourceId 15837000007076
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 = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/2368
case_docid = 100062023/2368
case_purpose = 10109000001043
trn_bor_caseregid = 15306000006326
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007102
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007076
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:43
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:43
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=24/05/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=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/2368
Param Type = c
case_docid=100062023/2368
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=15306000006326
Param Type = c
prev_hearing_date=23/05/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 = 2023/2407 idvalue 0
Mapped hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? ?????? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 11914000008414 idvalue 0
Mapped case_docid Row = 1 value = 100062023/2407 idvalue 0
Mapped case_purpose Row = 1 value = 15904000000025 idvalue 0
Mapped case_purpose_code Row = 1 value = 301 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 11914000008414
case_docid = 100062023/2407
case_no = 2023/2407
prev_hearing_date = 23/05/2023
hearing_date = 23/05/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 = 15904000000025
case_purpose_code = 301
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 = 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 = 15837000007103
MapName bocup1
SourceId 15837000007077
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 17553000001243
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 301
hearing_date = 23/05/2023
prev_case_purposename = ?????? ???? ??????
court_code = 10006
case_no = 2023/2407
case_docid = 100062023/2407
case_purpose = 15904000000025
trn_bor_caseregid = 11914000008414
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007103
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007077
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:43
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:43
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=24/05/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=301
Param Type = c
hearing_date=23/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ???? ??????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/2407
Param Type = c
case_docid=100062023/2407
Param Type = c
case_purpose=15904000000025
Param Type = n
trn_bor_caseregid=11914000008414
Param Type = c
prev_hearing_date=23/05/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 = 2023/2410 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 12150000007854 idvalue 0
Mapped case_docid Row = 1 value = 100062023/2410 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 12150000007854
case_docid = 100062023/2410
case_no = 2023/2410
prev_hearing_date = 23/05/2023
hearing_date = 25/05/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 = 8
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 = 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 = 15837000007104
MapName bocup1
SourceId 15837000007078
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 = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/2410
case_docid = 100062023/2410
case_purpose = 10109000001043
trn_bor_caseregid = 12150000007854
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007104
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007078
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:43
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:43
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=24/05/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=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/2410
Param Type = c
case_docid=100062023/2410
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=12150000007854
Param Type = c
prev_hearing_date=23/05/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 = 2023/2449 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ?????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 18476000007371 idvalue 0
Mapped case_docid Row = 1 value = 100062023/2449 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 18476000007371
case_docid = 100062023/2449
case_no = 2023/2449
prev_hearing_date = 23/05/2023
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
prev_case_purpose = 
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 = 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 = 15837000007105
MapName bocup1
SourceId 15837000007079
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10109000001043
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 121
hearing_date = 25/05/2023
prev_case_purposename = ?????? ????
court_code = 10006
case_no = 2023/2449
case_docid = 100062023/2449
case_purpose = 10109000001043
trn_bor_caseregid = 18476000007371
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007105
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007079
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:43
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:43
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=24/05/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=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=?????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/2449
Param Type = c
case_docid=100062023/2449
Param Type = c
case_purpose=10109000001043
Param Type = n
trn_bor_caseregid=18476000007371
Param Type = c
prev_hearing_date=23/05/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 = 2016/5600 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 990144427 idvalue 0
Mapped case_docid Row = 1 value = 100062016/5600 idvalue 0
Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0
Mapped case_purpose_code Row = 1 value = 120 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 990144427
case_docid = 100062016/5600
case_no = 2016/5600
prev_hearing_date = 23/05/2023
hearing_date = 25/05/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 = 10107000000777
case_purpose = 10107000000777
case_purpose_code = 120
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 = 15837000007106
MapName bocup1
SourceId 15837000007080
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10107000000777
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 120
hearing_date = 25/05/2023
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2016/5600
case_docid = 100062016/5600
case_purpose = 10107000000777
trn_bor_caseregid = 990144427
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007106
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007080
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:44
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10107000000777
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=24/05/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=120
Param Type = c
hearing_date=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2016/5600
Param Type = c
case_docid=100062016/5600
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=990144427
Param Type = c
prev_hearing_date=23/05/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 23

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2018/7614 idvalue 0
Mapped hearing_date Row = 1 value = 25/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 10615000002766 idvalue 0
Mapped case_docid Row = 1 value = 100062018/7614 idvalue 0
Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0
Mapped case_purpose_code Row = 1 value = 120 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 10615000002766
case_docid = 100062018/7614
case_no = 2018/7614
prev_hearing_date = 23/05/2023
hearing_date = 25/05/2023
prev_case_purposename = ???????? ????????? ????
prev_case_purpose = 
prev_case_purpose after validation = 10107000000777
case_purpose = 10107000000777
case_purpose_code = 120
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 = 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 = 15837000007107
MapName bocup1
SourceId 15837000007081
Select sysdate as sdt from dual
Time elapsed = 4
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10107000000777
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 120
hearing_date = 25/05/2023
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2018/7614
case_docid = 100062018/7614
case_purpose = 10107000000777
trn_bor_caseregid = 10615000002766
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007107
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007081
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:44
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10107000000777
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=24/05/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=120
Param Type = c
hearing_date=25/05/2023 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2018/7614
Param Type = c
case_docid=100062018/7614
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=10615000002766
Param Type = c
prev_hearing_date=23/05/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 24

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2022/2571 idvalue 0
Mapped hearing_date Row = 1 value = 26/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 19062000007384 idvalue 0
Mapped case_docid Row = 1 value = 100062022/2571 idvalue 0
Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0
Mapped case_purpose_code Row = 1 value = 120 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 19062000007384
case_docid = 100062022/2571
case_no = 2022/2571
prev_hearing_date = 23/05/2023
hearing_date = 26/05/2023
prev_case_purposename = ???????? ????????? ????
prev_case_purpose = 
prev_case_purpose after validation = 10107000000777
case_purpose = 10107000000777
case_purpose_code = 120
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 = 15837000007108
MapName bocup1
SourceId 15837000007082
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 4
prev_case_purpose = 10107000000777
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 120
hearing_date = 26/05/2023
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2022/2571
case_docid = 100062022/2571
case_purpose = 10107000000777
trn_bor_caseregid = 19062000007384
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007108
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007082
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:44
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10107000000777
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=24/05/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=120
Param Type = c
hearing_date=26/05/2023 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2022/2571
Param Type = c
case_docid=100062022/2571
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=19062000007384
Param Type = c
prev_hearing_date=23/05/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 25

>>Mapping
Mapped court_code Row = 1 value = 10006 idvalue 0
Mapped case_no Row = 1 value = 2023/437 idvalue 0
Mapped hearing_date Row = 1 value = 29/05/2023 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 23/05/2023 idvalue 0
Mapped trn_bor_caseregid Row = 1 value = 18065000007303 idvalue 0
Mapped case_docid Row = 1 value = 100062023/437 idvalue 0
Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0
Mapped case_purpose_code Row = 1 value = 120 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 = 24/05/2023
doc_date after validation = 24/05/2023
court_code = 10006
trn_bor_caseregid = 18065000007303
case_docid = 100062023/437
case_no = 2023/437
prev_hearing_date = 23/05/2023
hearing_date = 29/05/2023
prev_case_purposename = ???????? ????????? ????
prev_case_purpose = 
prev_case_purpose after validation = 10107000000777
case_purpose = 10107000000777
case_purpose_code = 120
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 = 4
RecordId = 15837000007109
MapName bocup1
SourceId 15837000007083
Select sysdate as sdt from dual
Time elapsed = 3
Select sysdate as sdt from dual
Time elapsed = 3
prev_case_purpose = 10107000000777
bench_type = 
trans_type = Cause List Update (Custom)
doc_date = 24/05/2023
decision_date = 
module = Feedback
bench_name = 
decision_type = 0
case_purpose_code = 120
hearing_date = 29/05/2023
prev_case_purposename = ???????? ????????? ????
court_code = 10006
case_no = 2023/437
case_docid = 100062023/437
case_purpose = 10107000000777
trn_bor_caseregid = 18065000007303
prev_hearing_date = 23/05/2023
Posting record
Param Type = n
trn_bor_case_histid=15837000007109
Param Type = c
mapname=bocup1
Param Type = n
sourceid=15837000007083
Param Type = c
cancel=F
Param Type = c
createdby=dikshabor
Param Type = c
createdon=24/05/2023 10:39:44
Param Type = c
username=dikshabor
Param Type = c
modifiedon=24/05/2023 10:39:44
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_case_purpose=10107000000777
Param Type = c
trans_type=Cause List Update (Custom)
Param Type = c
doc_date=24/05/2023 00:00:00
Param Type = c
module=Feedback
Param Type = n
decision_type=0
Param Type = c
case_purpose_code=120
Param Type = c
hearing_date=29/05/2023 00:00:00
Param Type = c
prev_case_purposename=???????? ????????? ????
Param Type = c
court_code=10006
Param Type = c
case_no=2023/437
Param Type = c
case_docid=100062023/437
Param Type = c
case_purpose=10107000000777
Param Type = n
trn_bor_caseregid=18065000007303
Param Type = c
prev_hearing_date=23/05/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 = 3894086327632

>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=18667000007503
@trn_bor_caseregid=18667000007503
*hearingdate=25/05/2023
*case_purpose_name=11356000002249
*case_purpose_code=229
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=18667000007503 for update 
Time elapsed = 39
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=18667000007503
Time elapsed = 30
Param Type = c
hearingdate=25/05/2023 00:00:00
Param Type = c
case_purpose_name=11356000002249
Param Type = c
case_purpose_code=229
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=18667000007503


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=15806000006591
@trn_bor_caseregid=15806000006591
*hearingdate=26/05/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=15806000006591 for update 
Time elapsed = 27
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=15806000006591
Time elapsed = 23
Param Type = c
hearingdate=26/05/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=15806000006591


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=12463000008330
@trn_bor_caseregid=12463000008330
*hearingdate=19/10/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=12463000008330 for update 
Time elapsed = 24
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=12463000008330
Time elapsed = 25
Param Type = c
hearingdate=19/10/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=12463000008330


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=10095000007426
@trn_bor_caseregid=10095000007426
*hearingdate=25/05/2023
*case_purpose_name=17553000001243
*case_purpose_code=73
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=10095000007426 for update 
Time elapsed = 22
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=10095000007426
Time elapsed = 23
Param Type = c
hearingdate=25/05/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=10095000007426


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=16022000007510
@trn_bor_caseregid=16022000007510
*hearingdate=25/05/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=16022000007510 for update 
Time elapsed = 20
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=16022000007510
Time elapsed = 21
Param Type = c
hearingdate=25/05/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=16022000007510


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=13390000008450
@trn_bor_caseregid=13390000008450
*hearingdate=25/05/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=13390000008450 for update 
Time elapsed = 27
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=13390000008450
Time elapsed = 25
Param Type = c
hearingdate=25/05/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=13390000008450


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=10294000007624
@trn_bor_caseregid=10294000007624
*hearingdate=26/05/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=10294000007624 for update 
Time elapsed = 25
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=10294000007624
Time elapsed = 29
Param Type = c
hearingdate=26/05/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=10294000007624


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=19897000007745
@trn_bor_caseregid=19897000007745
*hearingdate=25/05/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=19897000007745 for update 
Time elapsed = 20
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=19897000007745
Time elapsed = 21
Param Type = c
hearingdate=25/05/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=19897000007745


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=10105000007834
@trn_bor_caseregid=10105000007834
*hearingdate=25/05/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=10105000007834 for update 
Time elapsed = 29
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=10105000007834
Time elapsed = 31
Param Type = c
hearingdate=25/05/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=10105000007834


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=11807000007555
@trn_bor_caseregid=11807000007555
*hearingdate=25/05/2023
*case_purpose_name=10024000000944
*case_purpose_code=108
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=11807000007555 for update 
Time elapsed = 24
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=11807000007555
Time elapsed = 25
Param Type = c
hearingdate=25/05/2023 00:00:00
Param Type = c
case_purpose_name=10024000000944
Param Type = c
case_purpose_code=108
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=11807000007555


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=13324000007373
@trn_bor_caseregid=13324000007373
*hearingdate=26/05/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=13324000007373 for update 
Time elapsed = 24
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=13324000007373
Time elapsed = 25
Param Type = c
hearingdate=26/05/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=13324000007373


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=17183000007765
@trn_bor_caseregid=17183000007765
*hearingdate=25/05/2023
*case_purpose_name=10001000000775
*case_purpose_code=2
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=17183000007765 for update 
Time elapsed = 24
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=17183000007765
Time elapsed = 27
Param Type = c
hearingdate=25/05/2023 00:00:00
Param Type = c
case_purpose_name=10001000000775
Param Type = c
case_purpose_code=2
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=17183000007765


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=19059000007938
@trn_bor_caseregid=19059000007938
*hearingdate=25/05/2023
*case_purpose_name=17553000001243
*case_purpose_code=73
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=19059000007938 for update 
Time elapsed = 31
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=19059000007938
Time elapsed = 25
Param Type = c
hearingdate=25/05/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=19059000007938


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=17260000007794
@trn_bor_caseregid=17260000007794
*hearingdate=25/05/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=17260000007794 for update 
Time elapsed = 24
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=17260000007794
Time elapsed = 25
Param Type = c
hearingdate=25/05/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=17260000007794


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=11165000006943
@trn_bor_caseregid=11165000006943
*hearingdate=25/05/2023
*case_purpose_name=17553000001243
*case_purpose_code=73
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=11165000006943 for update 
Time elapsed = 26
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=11165000006943
Time elapsed = 23
Param Type = c
hearingdate=25/05/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=11165000006943


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=15762000007428
@trn_bor_caseregid=15762000007428
*hearingdate=25/05/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=15762000007428 for update 
Time elapsed = 25
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=15762000007428
Time elapsed = 23
Param Type = c
hearingdate=25/05/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=15762000007428


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=12184000008816
@trn_bor_caseregid=12184000008816
*hearingdate=25/05/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=12184000008816 for update 
Time elapsed = 26
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=12184000008816
Time elapsed = 24
Param Type = c
hearingdate=25/05/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=12184000008816


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=15306000006326
@trn_bor_caseregid=15306000006326
*hearingdate=25/05/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=15306000006326 for update 
Time elapsed = 25
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=15306000006326
Time elapsed = 28
Param Type = c
hearingdate=25/05/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=15306000006326


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=11914000008414
@trn_bor_caseregid=11914000008414
*hearingdate=23/05/2023
*case_purpose_name=15904000000025
*case_purpose_code=301
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=11914000008414 for update 
Time elapsed = 26
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=11914000008414
Time elapsed = 25
Param Type = c
hearingdate=23/05/2023 00:00:00
Param Type = c
case_purpose_name=15904000000025
Param Type = c
case_purpose_code=301
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=11914000008414


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=12150000007854
@trn_bor_caseregid=12150000007854
*hearingdate=25/05/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=12150000007854 for update 
Time elapsed = 30
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=12150000007854
Time elapsed = 23
Param Type = c
hearingdate=25/05/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=12150000007854


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=18476000007371
@trn_bor_caseregid=18476000007371
*hearingdate=25/05/2023
*case_purpose_name=10109000001043
*case_purpose_code=121
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=18476000007371 for update 
Time elapsed = 27
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=18476000007371
Time elapsed = 23
Param Type = c
hearingdate=25/05/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=18476000007371


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=990144427
@trn_bor_caseregid=990144427
*hearingdate=25/05/2023
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990144427 for update 
Time elapsed = 26
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=990144427
Time elapsed = 24
Param Type = c
hearingdate=25/05/2023 00:00:00
Param Type = c
case_purpose_name=10107000000777
Param Type = c
case_purpose_code=120
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=990144427


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=10615000002766
@trn_bor_caseregid=10615000002766
*hearingdate=25/05/2023
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=10615000002766 for update 
Time elapsed = 29
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=10615000002766
Time elapsed = 25
Param Type = c
hearingdate=25/05/2023 00:00:00
Param Type = c
case_purpose_name=10107000000777
Param Type = c
case_purpose_code=120
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=10615000002766


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=19062000007384
@trn_bor_caseregid=19062000007384
*hearingdate=26/05/2023
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=19062000007384 for update 
Time elapsed = 22
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=19062000007384
Time elapsed = 25
Param Type = c
hearingdate=26/05/2023 00:00:00
Param Type = c
case_purpose_name=10107000000777
Param Type = c
case_purpose_code=120
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=19062000007384


>>Posting MD Maps : 
Select * from trn_bor_casereg where trn_bor_casereg where  trn_bor_caseregid=18065000007303
@trn_bor_caseregid=18065000007303
*hearingdate=29/05/2023
*case_purpose_name=10107000000777
*case_purpose_code=120
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=18065000007303 for update 
Time elapsed = 28
SELECT * FROM trn_bor_casereg where  trn_bor_caseregid=18065000007303
Time elapsed = 30
Param Type = c
hearingdate=29/05/2023 00:00:00
Param Type = c
case_purpose_name=10107000000777
Param Type = c
case_purpose_code=120
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=18065000007303

Time elapsed for MD Map = 3894086329821
Time elapsed for Save History = 3894086329822
Time elapsed for Save Attachment = 3894086329824
Time elapsed for After Save WF Exec = 3894086329827
Transaction commited
Result : {"message":[{"msg":"Cause List Feedback Saved","recordid":"15837000007057"}]}
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=dikshabor
Param Type = c
calledon=24/05/2023 10:38:40
Param Type = c
callfinished=24/05/2023 10:38:49
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=9643
Param Type = n
dbtimetaken=6325
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