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="dc_sikar" password="827ccb0eea8a706c4c34a16891f84e7b" seed="" axpapp="gcms"><axpapp>gcms</axpapp><username>dc_sikar</username><password>827ccb0eea8a706c4c34a16891f84e7b</password><seed></seed><s></s><transid>rctcr</transid><recordid>0</recordid><recdata></recdata><data transid="rctcr" recordid="0"><axp_recid1 rowno="001">0</axp_recid1><court_code rowno="001">18165</court_code><trans_ccode rowno="001">10414</trans_ccode><axp_recid2 rowno="001">0</axp_recid2><fromcourt rowno="001">1322440008926</fromcourt><fromccode rowno="001">18165</fromccode><transcourt rowno="001">13289000000049</transcourt><transccode rowno="001">10414</transccode><trn_rcms_caseregid rowno="001">18885000007549</trn_rcms_caseregid><case_no rowno="001">2023/641</case_no><requestno rowno="001">18165-10414#2023/641</requestno><decision_date rowno="001">09/01/2025</decision_date><status rowno="001">0</status><transContFld rowno="001">T</transContFld><axp_recid2 rowno="002">0</axp_recid2><fromcourt rowno="002">1322440008926</fromcourt><fromccode rowno="002">18165</fromccode><transcourt rowno="002">13289000000049</transcourt><transccode rowno="002">10414</transccode><trn_rcms_caseregid rowno="002">10791000008381</trn_rcms_caseregid><case_no rowno="002">2023/957</case_no><requestno rowno="002">18165-10414#2023/957</requestno><decision_date rowno="002">09/01/2025</decision_date><status rowno="002">0</status><transContFld rowno="002">T</transContFld><axp_recid2 rowno="003">0</axp_recid2><fromcourt rowno="003">1322440008926</fromcourt><fromccode rowno="003">18165</fromccode><transcourt rowno="003">13289000000049</transcourt><transccode rowno="003">10414</transccode><trn_rcms_caseregid rowno="003">16966000007791</trn_rcms_caseregid><case_no rowno="003">2023/569</case_no><requestno rowno="003">18165-10414#2023/569</requestno><decision_date rowno="003">09/01/2025</decision_date><status rowno="003">0</status><transContFld rowno="003">T</transContFld><axp_recid2 rowno="004">0</axp_recid2><fromcourt rowno="004">1322440008926</fromcourt><fromccode rowno="004">18165</fromccode><transcourt rowno="004">13289000000049</transcourt><transccode rowno="004">10414</transccode><trn_rcms_caseregid rowno="004">16340000007393</trn_rcms_caseregid><case_no rowno="004">2023/555</case_no><requestno rowno="004">18165-10414#2023/555</requestno><decision_date rowno="004">09/01/2025</decision_date><status rowno="004">0</status><transContFld rowno="004">T</transContFld><axp_recid2 rowno="005">0</axp_recid2><fromcourt rowno="005">1322440008926</fromcourt><fromccode rowno="005">18165</fromccode><transcourt rowno="005">13289000000049</transcourt><transccode rowno="005">10414</transccode><trn_rcms_caseregid rowno="005">12013000008758</trn_rcms_caseregid><case_no rowno="005">2023/463</case_no><requestno rowno="005">18165-10414#2023/463</requestno><decision_date rowno="005">09/01/2025</decision_date><status rowno="005">0</status><transContFld rowno="005">T</transContFld><axp_recid2 rowno="006">0</axp_recid2><fromcourt rowno="006">1322440008926</fromcourt><fromccode rowno="006">18165</fromccode><transcourt rowno="006">13289000000049</transcourt><transccode rowno="006">10414</transccode><trn_rcms_caseregid rowno="006">11112000008534</trn_rcms_caseregid><case_no rowno="006">2023/794</case_no><requestno rowno="006">18165-10414#2023/794</requestno><decision_date rowno="006">09/01/2025</decision_date><status rowno="006">0</status><transContFld rowno="006">T</transContFld><axp_recid2 rowno="007">0</axp_recid2><fromcourt rowno="007">1322440008926</fromcourt><fromccode rowno="007">18165</fromccode><transcourt rowno="007">13289000000049</transcourt><transccode rowno="007">10414</transccode><trn_rcms_caseregid rowno="007">14651000007420</trn_rcms_caseregid><case_no rowno="007">2023/409</case_no><requestno rowno="007">18165-10414#2023/409</requestno><decision_date rowno="007">09/01/2025</decision_date><status rowno="007">0</status><transContFld rowno="007">T</transContFld><axp_recid2 rowno="008">0</axp_recid2><fromcourt rowno="008">1322440008926</fromcourt><fromccode rowno="008">18165</fromccode><transcourt rowno="008">13289000000049</transcourt><transccode rowno="008">10414</transccode><trn_rcms_caseregid rowno="008">17080000008754</trn_rcms_caseregid><case_no rowno="008">2023/572</case_no><requestno rowno="008">18165-10414#2023/572</requestno><decision_date rowno="008">09/01/2025</decision_date><status rowno="008">0</status><transContFld rowno="008">T</transContFld><axp_recid2 rowno="009">0</axp_recid2><fromcourt rowno="009">1322440008926</fromcourt><fromccode rowno="009">18165</fromccode><transcourt rowno="009">13289000000049</transcourt><transccode rowno="009">10414</transccode><trn_rcms_caseregid rowno="009">17066000007458</trn_rcms_caseregid><case_no rowno="009">2023/833</case_no><requestno rowno="009">18165-10414#2023/833</requestno><decision_date rowno="009">09/01/2025</decision_date><status rowno="009">0</status><transContFld rowno="009">T</transContFld><axp_recid2 rowno="0010">0</axp_recid2><fromcourt rowno="0010">1322440008926</fromcourt><fromccode rowno="0010">18165</fromccode><transcourt rowno="0010">13289000000049</transcourt><transccode rowno="0010">10414</transccode><trn_rcms_caseregid rowno="0010">17054000008660</trn_rcms_caseregid><case_no rowno="0010">2023/571</case_no><requestno rowno="0010">18165-10414#2023/571</requestno><decision_date rowno="0010">09/01/2025</decision_date><status rowno="0010">0</status><transContFld rowno="0010">T</transContFld><axp_recid2 rowno="0011">0</axp_recid2><fromcourt rowno="0011">1322440008926</fromcourt><fromccode rowno="0011">18165</fromccode><transcourt rowno="0011">13289000000049</transcourt><transccode rowno="0011">10414</transccode><trn_rcms_caseregid rowno="0011">11519000008343</trn_rcms_caseregid><case_no rowno="0011">2023/386</case_no><requestno rowno="0011">18165-10414#2023/386</requestno><decision_date rowno="0011">09/01/2025</decision_date><status rowno="0011">0</status><transContFld rowno="0011">T</transContFld><axp_recid2 rowno="0012">0</axp_recid2><fromcourt rowno="0012">1322440008926</fromcourt><fromccode rowno="0012">18165</fromccode><transcourt rowno="0012">13289000000049</transcourt><transccode rowno="0012">10414</transccode><trn_rcms_caseregid rowno="0012">16152000007212</trn_rcms_caseregid><case_no rowno="0012">2023/431</case_no><requestno rowno="0012">18165-10414#2023/431</requestno><decision_date rowno="0012">09/01/2025</decision_date><status rowno="0012">0</status><transContFld rowno="0012">T</transContFld><axp_recid2 rowno="0013">0</axp_recid2><fromcourt rowno="0013">1322440008926</fromcourt><fromccode rowno="0013">18165</fromccode><transcourt rowno="0013">13289000000049</transcourt><transccode rowno="0013">10414</transccode><trn_rcms_caseregid rowno="0013">14606000008296</trn_rcms_caseregid><case_no rowno="0013">2023/65</case_no><requestno rowno="0013">18165-10414#2023/65</requestno><decision_date rowno="0013">09/01/2025</decision_date><status rowno="0013">0</status><transContFld rowno="0013">T</transContFld><axp_recid2 rowno="0014">0</axp_recid2><fromcourt rowno="0014">1322440008926</fromcourt><fromccode rowno="0014">18165</fromccode><transcourt rowno="0014">13289000000049</transcourt><transccode rowno="0014">10414</transccode><trn_rcms_caseregid rowno="0014">10734000007763</trn_rcms_caseregid><case_no rowno="0014">2023/953</case_no><requestno rowno="0014">18165-10414#2023/953</requestno><decision_date rowno="0014">09/01/2025</decision_date><status rowno="0014">0</status><transContFld rowno="0014">T</transContFld><axp_recid2 rowno="0015">0</axp_recid2><fromcourt rowno="0015">1322440008926</fromcourt><fromccode rowno="0015">18165</fromccode><transcourt rowno="0015">13289000000049</transcourt><transccode rowno="0015">10414</transccode><trn_rcms_caseregid rowno="0015">15917000007396</trn_rcms_caseregid><case_no rowno="0015">2023/510</case_no><requestno rowno="0015">18165-10414#2023/510</requestno><decision_date rowno="0015">09/01/2025</decision_date><status rowno="0015">0</status><transContFld rowno="0015">T</transContFld><axp_recid2 rowno="0016">0</axp_recid2><fromcourt rowno="0016">1322440008926</fromcourt><fromccode rowno="0016">18165</fromccode><transcourt rowno="0016">13289000000049</transcourt><transccode rowno="0016">10414</transccode><trn_rcms_caseregid rowno="0016">17291000007244</trn_rcms_caseregid><case_no rowno="0016">2023/452</case_no><requestno rowno="0016">18165-10414#2023/452</requestno><decision_date rowno="0016">09/01/2025</decision_date><status rowno="0016">0</status><transContFld rowno="0016">T</transContFld><axp_recid2 rowno="0017">0</axp_recid2><fromcourt rowno="0017">1322440008926</fromcourt><fromccode rowno="0017">18165</fromccode><transcourt rowno="0017">13289000000049</transcourt><transccode rowno="0017">10414</transccode><trn_rcms_caseregid rowno="0017">11459000008378</trn_rcms_caseregid><case_no rowno="0017">2024/64</case_no><requestno rowno="0017">18165-10414#2024/64</requestno><decision_date rowno="0017">09/01/2025</decision_date><status rowno="0017">0</status><transContFld rowno="0017">T</transContFld><axp_recid2 rowno="0018">0</axp_recid2><fromcourt rowno="0018">1322440008926</fromcourt><fromccode rowno="0018">18165</fromccode><transcourt rowno="0018">13289000000049</transcourt><transccode rowno="0018">10414</transccode><trn_rcms_caseregid rowno="0018">17316000009210</trn_rcms_caseregid><case_no rowno="0018">2023/453</case_no><requestno rowno="0018">18165-10414#2023/453</requestno><decision_date rowno="0018">09/01/2025</decision_date><status rowno="0018">0</status><transContFld rowno="0018">T</transContFld><axp_recid2 rowno="0019">0</axp_recid2><fromcourt rowno="0019">1322440008926</fromcourt><fromccode rowno="0019">18165</fromccode><transcourt rowno="0019">13289000000049</transcourt><transccode rowno="0019">10414</transccode><trn_rcms_caseregid rowno="0019">13805000009475</trn_rcms_caseregid><case_no rowno="0019">2023/817</case_no><requestno rowno="0019">18165-10414#2023/817</requestno><decision_date rowno="0019">09/01/2025</decision_date><status rowno="0019">0</status><transContFld rowno="0019">T</transContFld><axp_recid2 rowno="0020">0</axp_recid2><fromcourt rowno="0020">1322440008926</fromcourt><fromccode rowno="0020">18165</fromccode><transcourt rowno="0020">13289000000049</transcourt><transccode rowno="0020">10414</transccode><trn_rcms_caseregid rowno="0020">16308000009115</trn_rcms_caseregid><case_no rowno="0020">2023/554</case_no><requestno rowno="0020">18165-10414#2023/554</requestno><decision_date rowno="0020">09/01/2025</decision_date><status rowno="0020">0</status><transContFld rowno="0020">T</transContFld><axp_recid2 rowno="0021">0</axp_recid2><fromcourt rowno="0021">1322440008926</fromcourt><fromccode rowno="0021">18165</fromccode><transcourt rowno="0021">13289000000049</transcourt><transccode rowno="0021">10414</transccode><trn_rcms_caseregid rowno="0021">18982000008150</trn_rcms_caseregid><case_no rowno="0021">2023/649</case_no><requestno rowno="0021">18165-10414#2023/649</requestno><decision_date rowno="0021">09/01/2025</decision_date><status rowno="0021">0</status><transContFld rowno="0021">T</transContFld><axp_recid2 rowno="0022">0</axp_recid2><fromcourt rowno="0022">1322440008926</fromcourt><fromccode rowno="0022">18165</fromccode><transcourt rowno="0022">13289000000049</transcourt><transccode rowno="0022">10414</transccode><trn_rcms_caseregid rowno="0022">18497000008946</trn_rcms_caseregid><case_no rowno="0022">2023/622</case_no><requestno rowno="0022">18165-10414#2023/622</requestno><decision_date rowno="0022">09/01/2025</decision_date><status rowno="0022">0</status><transContFld rowno="0022">T</transContFld><axp_recid2 rowno="0023">0</axp_recid2><fromcourt rowno="0023">1322440008926</fromcourt><fromccode rowno="0023">18165</fromccode><transcourt rowno="0023">13289000000049</transcourt><transccode rowno="0023">10414</transccode><trn_rcms_caseregid rowno="0023">19618000008595</trn_rcms_caseregid><case_no rowno="0023">2024/41</case_no><requestno rowno="0023">18165-10414#2024/41</requestno><decision_date rowno="0023">09/01/2025</decision_date><status rowno="0023">0</status><transContFld rowno="0023">T</transContFld><axp_recid2 rowno="0024">0</axp_recid2><fromcourt rowno="0024">1322440008926</fromcourt><fromccode rowno="0024">18165</fromccode><transcourt rowno="0024">13289000000049</transcourt><transccode rowno="0024">10414</transccode><trn_rcms_caseregid rowno="0024">16444000008142</trn_rcms_caseregid><case_no rowno="0024">2023/559</case_no><requestno rowno="0024">18165-10414#2023/559</requestno><decision_date rowno="0024">09/01/2025</decision_date><status rowno="0024">0</status><transContFld rowno="0024">T</transContFld><axp_recid2 rowno="0025">0</axp_recid2><fromcourt rowno="0025">1322440008926</fromcourt><fromccode rowno="0025">18165</fromccode><transcourt rowno="0025">13289000000049</transcourt><transccode rowno="0025">10414</transccode><trn_rcms_caseregid rowno="0025">11239000007851</trn_rcms_caseregid><case_no rowno="0025">2023/382</case_no><requestno rowno="0025">18165-10414#2023/382</requestno><decision_date rowno="0025">09/01/2025</decision_date><status rowno="0025">0</status><transContFld rowno="0025">T</transContFld><axp_recid2 rowno="0026">0</axp_recid2><fromcourt rowno="0026">1322440008926</fromcourt><fromccode rowno="0026">18165</fromccode><transcourt rowno="0026">13289000000049</transcourt><transccode rowno="0026">10414</transccode><trn_rcms_caseregid rowno="0026">15744000007713</trn_rcms_caseregid><case_no rowno="0026">2023/505</case_no><requestno rowno="0026">18165-10414#2023/505</requestno><decision_date rowno="0026">09/01/2025</decision_date><status rowno="0026">0</status><transContFld rowno="0026">T</transContFld><axp_recid2 rowno="0027">0</axp_recid2><fromcourt rowno="0027">1322440008926</fromcourt><fromccode rowno="0027">18165</fromccode><transcourt rowno="0027">13289000000049</transcourt><transccode rowno="0027">10414</transccode><trn_rcms_caseregid rowno="0027">12432000007585</trn_rcms_caseregid><case_no rowno="0027">2023/482</case_no><requestno rowno="0027">18165-10414#2023/482</requestno><decision_date rowno="0027">09/01/2025</decision_date><status rowno="0027">0</status><transContFld rowno="0027">T</transContFld><axp_recid2 rowno="0028">0</axp_recid2><fromcourt rowno="0028">1322440008926</fromcourt><fromccode rowno="0028">18165</fromccode><transcourt rowno="0028">13289000000049</transcourt><transccode rowno="0028">10414</transccode><trn_rcms_caseregid rowno="0028">17100000009054</trn_rcms_caseregid><case_no rowno="0028">2023/447</case_no><requestno rowno="0028">18165-10414#2023/447</requestno><decision_date rowno="0028">09/01/2025</decision_date><status rowno="0028">0</status><transContFld rowno="0028">T</transContFld><axp_recid2 rowno="0029">0</axp_recid2><fromcourt rowno="0029">1322440008926</fromcourt><fromccode rowno="0029">18165</fromccode><transcourt rowno="0029">13289000000049</transcourt><transccode rowno="0029">10414</transccode><trn_rcms_caseregid rowno="0029">17390000007123</trn_rcms_caseregid><case_no rowno="0029">2023/455</case_no><requestno rowno="0029">18165-10414#2023/455</requestno><decision_date rowno="0029">09/01/2025</decision_date><status rowno="0029">0</status><transContFld rowno="0029">T</transContFld><axp_recid2 rowno="0030">0</axp_recid2><fromcourt rowno="0030">1322440008926</fromcourt><fromccode rowno="0030">18165</fromccode><transcourt rowno="0030">13289000000049</transcourt><transccode rowno="0030">10414</transccode><trn_rcms_caseregid rowno="0030">15451000009123</trn_rcms_caseregid><case_no rowno="0030">2023/421</case_no><requestno rowno="0030">18165-10414#2023/421</requestno><decision_date rowno="0030">09/01/2025</decision_date><status rowno="0030">0</status><transContFld rowno="0030">T</transContFld><axp_recid2 rowno="0031">0</axp_recid2><fromcourt rowno="0031">1322440008926</fromcourt><fromccode rowno="0031">18165</fromccode><transcourt rowno="0031">13289000000049</transcourt><transccode rowno="0031">10414</transccode><trn_rcms_caseregid rowno="0031">15524000008134</trn_rcms_caseregid><case_no rowno="0031">2023/423</case_no><requestno rowno="0031">18165-10414#2023/423</requestno><decision_date rowno="0031">09/01/2025</decision_date><status rowno="0031">0</status><transContFld rowno="0031">T</transContFld><axp_recid2 rowno="0032">0</axp_recid2><fromcourt rowno="0032">1322440008926</fromcourt><fromccode rowno="0032">18165</fromccode><transcourt rowno="0032">13289000000049</transcourt><transccode rowno="0032">10414</transccode><trn_rcms_caseregid rowno="0032">13533000008124</trn_rcms_caseregid><case_no rowno="0032">2023/804</case_no><requestno rowno="0032">18165-10414#2023/804</requestno><decision_date rowno="0032">09/01/2025</decision_date><status rowno="0032">0</status><transContFld rowno="0032">T</transContFld><axp_recid2 rowno="0033">0</axp_recid2><fromcourt rowno="0033">1322440008926</fromcourt><fromccode rowno="0033">18165</fromccode><transcourt rowno="0033">13289000000049</transcourt><transccode rowno="0033">10414</transccode><trn_rcms_caseregid rowno="0033">17251000008640</trn_rcms_caseregid><case_no rowno="0033">2023/451</case_no><requestno rowno="0033">18165-10414#2023/451</requestno><decision_date rowno="0033">09/01/2025</decision_date><status rowno="0033">0</status><transContFld rowno="0033">T</transContFld><axp_recid2 rowno="0034">0</axp_recid2><fromcourt rowno="0034">1322440008926</fromcourt><fromccode rowno="0034">18165</fromccode><transcourt rowno="0034">13289000000049</transcourt><transccode rowno="0034">10414</transccode><trn_rcms_caseregid rowno="0034">14932000007327</trn_rcms_caseregid><case_no rowno="0034">2023/41</case_no><requestno rowno="0034">18165-10414#2023/41</requestno><decision_date rowno="0034">09/01/2025</decision_date><status rowno="0034">0</status><transContFld rowno="0034">T</transContFld><axp_recid2 rowno="0035">0</axp_recid2><fromcourt rowno="0035">1322440008926</fromcourt><fromccode rowno="0035">18165</fromccode><transcourt rowno="0035">13289000000049</transcourt><transccode rowno="0035">10414</transccode><trn_rcms_caseregid rowno="0035">14904000007549</trn_rcms_caseregid><case_no rowno="0035">2023/40</case_no><requestno rowno="0035">18165-10414#2023/40</requestno><decision_date rowno="0035">09/01/2025</decision_date><status rowno="0035">0</status><transContFld rowno="0035">T</transContFld><axp_recid2 rowno="0036">0</axp_recid2><fromcourt rowno="0036">1322440008926</fromcourt><fromccode rowno="0036">18165</fromccode><transcourt rowno="0036">13289000000049</transcourt><transccode rowno="0036">10414</transccode><trn_rcms_caseregid rowno="0036">10011000008122</trn_rcms_caseregid><case_no rowno="0036">2023/461</case_no><requestno rowno="0036">18165-10414#2023/461</requestno><decision_date rowno="0036">09/01/2025</decision_date><status rowno="0036">0</status><transContFld rowno="0036">T</transContFld><axp_recid2 rowno="0037">0</axp_recid2><fromcourt rowno="0037">1322440008926</fromcourt><fromccode rowno="0037">18165</fromccode><transcourt rowno="0037">13289000000049</transcourt><transccode rowno="0037">10414</transccode><trn_rcms_caseregid rowno="0037">12259000008024</trn_rcms_caseregid><case_no rowno="0037">2023/476</case_no><requestno rowno="0037">18165-10414#2023/476</requestno><decision_date rowno="0037">09/01/2025</decision_date><status rowno="0037">0</status><transContFld rowno="0037">T</transContFld><axp_recid2 rowno="0038">0</axp_recid2><fromcourt rowno="0038">1322440008926</fromcourt><fromccode rowno="0038">18165</fromccode><transcourt rowno="0038">13289000000049</transcourt><transccode rowno="0038">10414</transccode><trn_rcms_caseregid rowno="0038">14558000009668</trn_rcms_caseregid><case_no rowno="0038">2024/157</case_no><requestno rowno="0038">18165-10414#2024/157</requestno><decision_date rowno="0038">09/01/2025</decision_date><status rowno="0038">0</status><transContFld rowno="0038">T</transContFld><axp_recid2 rowno="0039">0</axp_recid2><fromcourt rowno="0039">1322440008926</fromcourt><fromccode rowno="0039">18165</fromccode><transcourt rowno="0039">13289000000049</transcourt><transccode rowno="0039">10414</transccode><trn_rcms_caseregid rowno="0039">19827000007627</trn_rcms_caseregid><case_no rowno="0039">2023/5</case_no><requestno rowno="0039">18165-10414#2023/5</requestno><decision_date rowno="0039">09/01/2025</decision_date><status rowno="0039">0</status><transContFld rowno="0039">T</transContFld><axp_recid2 rowno="0040">0</axp_recid2><fromcourt rowno="0040">1322440008926</fromcourt><fromccode rowno="0040">18165</fromccode><transcourt rowno="0040">13289000000049</transcourt><transccode rowno="0040">10414</transccode><trn_rcms_caseregid rowno="0040">17492000007428</trn_rcms_caseregid><case_no rowno="0040">2023/517</case_no><requestno rowno="0040">18165-10414#2023/517</requestno><decision_date rowno="0040">09/01/2025</decision_date><status rowno="0040">0</status><transContFld rowno="0040">T</transContFld><axp_recid2 rowno="0041">0</axp_recid2><fromcourt rowno="0041">1322440008926</fromcourt><fromccode rowno="0041">18165</fromccode><transcourt rowno="0041">13289000000049</transcourt><transccode rowno="0041">10414</transccode><trn_rcms_caseregid rowno="0041">10930000008580</trn_rcms_caseregid><case_no rowno="0041">2023/43</case_no><requestno rowno="0041">18165-10414#2023/43</requestno><decision_date rowno="0041">09/01/2025</decision_date><status rowno="0041">0</status><transContFld rowno="0041">T</transContFld><axp_recid2 rowno="0042">0</axp_recid2><fromcourt rowno="0042">1322440008926</fromcourt><fromccode rowno="0042">18165</fromccode><transcourt rowno="0042">13289000000049</transcourt><transccode rowno="0042">10414</transccode><trn_rcms_caseregid rowno="0042">11567000008772</trn_rcms_caseregid><case_no rowno="0042">2023/387</case_no><requestno rowno="0042">18165-10414#2023/387</requestno><decision_date rowno="0042">09/01/2025</decision_date><status rowno="0042">0</status><transContFld rowno="0042">T</transContFld><axp_recid2 rowno="0043">0</axp_recid2><fromcourt rowno="0043">1322440008926</fromcourt><fromccode rowno="0043">18165</fromccode><transcourt rowno="0043">13289000000049</transcourt><transccode rowno="0043">10414</transccode><trn_rcms_caseregid rowno="0043">14295000008350</trn_rcms_caseregid><case_no rowno="0043">2023/402</case_no><requestno rowno="0043">18165-10414#2023/402</requestno><decision_date rowno="0043">09/01/2025</decision_date><status rowno="0043">0</status><transContFld rowno="0043">T</transContFld><axp_recid2 rowno="0044">0</axp_recid2><fromcourt rowno="0044">1322440008926</fromcourt><fromccode rowno="0044">18165</fromccode><transcourt rowno="0044">13289000000049</transcourt><transccode rowno="0044">10414</transccode><trn_rcms_caseregid rowno="0044">14248000008037</trn_rcms_caseregid><case_no rowno="0044">2023/401</case_no><requestno rowno="0044">18165-10414#2023/401</requestno><decision_date rowno="0044">09/01/2025</decision_date><status rowno="0044">0</status><transContFld rowno="0044">T</transContFld><axp_recid2 rowno="0045">0</axp_recid2><fromcourt rowno="0045">1322440008926</fromcourt><fromccode rowno="0045">18165</fromccode><transcourt rowno="0045">13289000000049</transcourt><transccode rowno="0045">10414</transccode><trn_rcms_caseregid rowno="0045">18302000008122</trn_rcms_caseregid><case_no rowno="0045">2023/604</case_no><requestno rowno="0045">18165-10414#2023/604</requestno><decision_date rowno="0045">09/01/2025</decision_date><status rowno="0045">0</status><transContFld rowno="0045">T</transContFld><axp_recid2 rowno="0046">0</axp_recid2><fromcourt rowno="0046">1322440008926</fromcourt><fromccode rowno="0046">18165</fromccode><transcourt rowno="0046">13289000000049</transcourt><transccode rowno="0046">10414</transccode><trn_rcms_caseregid rowno="0046">11104000009276</trn_rcms_caseregid><case_no rowno="0046">2023/793</case_no><requestno rowno="0046">18165-10414#2023/793</requestno><decision_date rowno="0046">09/01/2025</decision_date><status rowno="0046">0</status><transContFld rowno="0046">T</transContFld><axp_recid2 rowno="0047">0</axp_recid2><fromcourt rowno="0047">1322440008926</fromcourt><fromccode rowno="0047">18165</fromccode><transcourt rowno="0047">13289000000049</transcourt><transccode rowno="0047">10414</transccode><trn_rcms_caseregid rowno="0047">14206000008980</trn_rcms_caseregid><case_no rowno="0047">2024/153</case_no><requestno rowno="0047">18165-10414#2024/153</requestno><decision_date rowno="0047">09/01/2025</decision_date><status rowno="0047">0</status><transContFld rowno="0047">T</transContFld></data></transaction>

Executing Savedata webservice
-----------------------------
Received JSON : {"savedata":{"axpapp":"gcms","username":"dc_sikar","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"rctcr","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"court_code":"18165","trans_ccode":"10414"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"18885000007549","case_no":"2023/641","requestno":"18165-10414#2023/641","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"002","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"10791000008381","case_no":"2023/957","requestno":"18165-10414#2023/957","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"003","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"16966000007791","case_no":"2023/569","requestno":"18165-10414#2023/569","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"004","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"16340000007393","case_no":"2023/555","requestno":"18165-10414#2023/555","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"005","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"12013000008758","case_no":"2023/463","requestno":"18165-10414#2023/463","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"006","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"11112000008534","case_no":"2023/794","requestno":"18165-10414#2023/794","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"007","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"14651000007420","case_no":"2023/409","requestno":"18165-10414#2023/409","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"008","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"17080000008754","case_no":"2023/572","requestno":"18165-10414#2023/572","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"009","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"17066000007458","case_no":"2023/833","requestno":"18165-10414#2023/833","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0010","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"17054000008660","case_no":"2023/571","requestno":"18165-10414#2023/571","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0011","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"11519000008343","case_no":"2023/386","requestno":"18165-10414#2023/386","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0012","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"16152000007212","case_no":"2023/431","requestno":"18165-10414#2023/431","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0013","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"14606000008296","case_no":"2023/65","requestno":"18165-10414#2023/65","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0014","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"10734000007763","case_no":"2023/953","requestno":"18165-10414#2023/953","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0015","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"15917000007396","case_no":"2023/510","requestno":"18165-10414#2023/510","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0016","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"17291000007244","case_no":"2023/452","requestno":"18165-10414#2023/452","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0017","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"11459000008378","case_no":"2024/64","requestno":"18165-10414#2024/64","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0018","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"17316000009210","case_no":"2023/453","requestno":"18165-10414#2023/453","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0019","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"13805000009475","case_no":"2023/817","requestno":"18165-10414#2023/817","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0020","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"16308000009115","case_no":"2023/554","requestno":"18165-10414#2023/554","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0021","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"18982000008150","case_no":"2023/649","requestno":"18165-10414#2023/649","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0022","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"18497000008946","case_no":"2023/622","requestno":"18165-10414#2023/622","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0023","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"19618000008595","case_no":"2024/41","requestno":"18165-10414#2024/41","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0024","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"16444000008142","case_no":"2023/559","requestno":"18165-10414#2023/559","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0025","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"11239000007851","case_no":"2023/382","requestno":"18165-10414#2023/382","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0026","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"15744000007713","case_no":"2023/505","requestno":"18165-10414#2023/505","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0027","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"12432000007585","case_no":"2023/482","requestno":"18165-10414#2023/482","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0028","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"17100000009054","case_no":"2023/447","requestno":"18165-10414#2023/447","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0029","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"17390000007123","case_no":"2023/455","requestno":"18165-10414#2023/455","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0030","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"15451000009123","case_no":"2023/421","requestno":"18165-10414#2023/421","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0031","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"15524000008134","case_no":"2023/423","requestno":"18165-10414#2023/423","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0032","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"13533000008124","case_no":"2023/804","requestno":"18165-10414#2023/804","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0033","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"17251000008640","case_no":"2023/451","requestno":"18165-10414#2023/451","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0034","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"14932000007327","case_no":"2023/41","requestno":"18165-10414#2023/41","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0035","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"14904000007549","case_no":"2023/40","requestno":"18165-10414#2023/40","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0036","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"10011000008122","case_no":"2023/461","requestno":"18165-10414#2023/461","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0037","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"12259000008024","case_no":"2023/476","requestno":"18165-10414#2023/476","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0038","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"14558000009668","case_no":"2024/157","requestno":"18165-10414#2024/157","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0039","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"19827000007627","case_no":"2023/5","requestno":"18165-10414#2023/5","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0040","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"17492000007428","case_no":"2023/517","requestno":"18165-10414#2023/517","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0041","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"10930000008580","case_no":"2023/43","requestno":"18165-10414#2023/43","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0042","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"11567000008772","case_no":"2023/387","requestno":"18165-10414#2023/387","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0043","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"14295000008350","case_no":"2023/402","requestno":"18165-10414#2023/402","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0044","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"14248000008037","case_no":"2023/401","requestno":"18165-10414#2023/401","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0045","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"18302000008122","case_no":"2023/604","requestno":"18165-10414#2023/604","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0046","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"11104000009276","case_no":"2023/793","requestno":"18165-10414#2023/793","decision_date":"09/01/2025","status":"0","transContFld":"T"}},{"rowno":"0047","text":"0","columns":{"fromcourt":"1322440008926","fromccode":"18165","transcourt":"13289000000049","transccode":"10414","trn_rcms_caseregid":"14206000008980","case_no":"2024/153","requestno":"18165-10414#2024/153","decision_date":"09/01/2025","status":"0","transContFld":"T"}}]}]}}
Verifying username and password
User Name : dc_sikar
Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app'
U=dc_sikar
Time elapsed = 22
Password checking along with max.no of login specified in app.xml
update axusers set logintry = 0 where lower(username) = :U
Time elapsed = 11
Result : 
Verifying completed...
Page Access Category : 
User Name : dc_sikar
Select sysdate as sdt from dual
Time elapsed = 8
dt=11/01/2025 16:24:25
Select sysdate as sdt from dual
Time elapsed = 7
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=dc_sikar
dt=11/01/2025 16:24:25
dt=11/01/2025 16:24:25
Time elapsed = 16
User Groups: court_reader
select userroles from axusergroups where groupname in ( 'court_reader' )
Time elapsed = 5
User Roles : court_reader
Loading App/User vars
reading the props xml
Step3
Sql : select props from axprops where lower(name)= :name  order by blobno

Paramval : app
ParamTYpe : c
Param List : name

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

Time elapsed = 4
Step4
axprops\stm size:4235
Step4-123456
<root updatedon="06/12/2024 17:18:50" name="app" caption="app" appverno="10.1.0.0" updusername="" updatedby="admin"><props LocalNum="738"><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=dc_sikar
select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1
username=dc_sikar
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m2},{court_name})
   Calling function sqlget
   Result of sqlget = ??????? ??????,????
   Result = ??????? ??????,????
   Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1})
   Calling function firesql
username=dc_sikar
select a.court_type from v_axcourts a where a.paxusername= :username order by 1
username=dc_sikar
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type})
   Calling function sqlget
   Result of sqlget = DC
   Result = DC
   Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1})
   Calling function firesql
username=dc_sikar
select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1
username=dc_sikar
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{court_name_mastid})
   Calling function sqlget
   Result of sqlget = 1322440008926
   Result = 1322440008926
   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=dc_sikar
Time elapsed = 7
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{axusersid})
   Calling function sqlget
   Result of sqlget = 1795990007831
   Result = 1795990007831
   Evaluating firesql({m4},{select :username as uname from dual})
   Calling function firesql
select :username as uname from dual
username=dc_sikar
Time elapsed = 6
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{uname})
   Calling function sqlget
   Result of sqlget = dc_sikar
   Result = dc_sikar
   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=dc_sikar
Time elapsed = 8
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{COURT_CODE})
   Calling function sqlget
   Result of sqlget = 18165
   Result = 18165
   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 = 7
   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=dc_sikar
SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=dc_sikar
Time elapsed = 8
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m7},{DISTNAMEENG})
   Calling function sqlget
   Result of sqlget = Sikar
   Result = Sikar
   Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1})
   Calling function firesql
username=dc_sikar
SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1
username=dc_sikar
Time elapsed = 8
   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=1795990007831
select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid
login_userid=1795990007831
Time elapsed = 11
   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=dc_sikar
Time elapsed = 8
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m3},{court_type_mastid})
   Calling function sqlget
   Result of sqlget = 10206000000013
   Result = 10206000000013
   Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username })
   Calling function firesql
username=dc_sikar
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=dc_sikar
Time elapsed = 9
   Result of firesql = 
   Result = 
   Evaluating  sqlget({m4},{groupname})
   Calling function sqlget
   Result of sqlget = court_reader
   Result = court_reader
   Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual})
   Calling function firesql
select to_date('30/01/2021','DD/MM/RRRR') dd from dual
Time elapsed = 5
   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=dc_sikar
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=dc_sikar
Time elapsed = 12
   Result of firesql = 
   Result = 
   Evaluating  sqlget({P1},{ct})
   Calling function sqlget
   Result of sqlget = 2
   Result = 2
3
completed LoadAppVars
Password validation done successfully
select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('court_reader') and lower(sname)='rctcr' and stype = 't' )

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

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

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

Time elapsed = 5
Reading data from stream

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

Paramval : rctcr
ParamTYpe : c
Param List : name

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

Time elapsed = 6
Step4
tstructs\stm size:2355
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
   Evaluating date()
   Result = 
   Evaluating 0
   Result = 
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=rctcr
adxinout=o
Time elapsed = 9
select * from trn_rcms_transreq where trn_rcms_transreqid=0
Time elapsed = 6
select * from Axusers where 1=2
Time elapsed = 8
select distinct(fldname) from AxTempUserFields
Time elapsed = 5
select * from AxAttachWorkflow where lower(transid) = 'rctcr'
Time elapsed = 7
Step3
Sql : select props from tstructs where lower(name)= :name  order by blobno

Paramval : tscd
ParamTYpe : c
Param List : name

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

Time elapsed = 4
Step4
tstructs\stm size:6667
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
select lpad(' ', 250, ' ') LVAL from dual
Time elapsed = 7
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tscd
adxinout=o
Time elapsed = 7
select * from trn_rcms_decision where trn_rcms_decisionid=0
Time elapsed = 6
   Evaluating date()
   Result = 
   Evaluating m_courtname
   Result = 
   Evaluating {AND a1.court_code=:m_courtcode }
   Result = 
   Evaluating iif(hearing_date>currdate,{Hearing Date Can not be greater Than Today },{T})
   Result = 
   Evaluating iif(decision_date>currdate,{Decision Date Can not be greater Than Today },{T})
   Result = 
   Evaluating 0
   Result = 
   Evaluating {F}
   Result = 
   Evaluating {F}
   Result = 
   Evaluating {F}
   Result = 
   Evaluating court_code+case_no
   Result = 
   Evaluating username
   Result = 
   Evaluating {cd.pdf}
   Result = 
   Evaluating iif(recordid>0,{Decision Updated},{Decision Submitted})
   Result = 
   Evaluating iif(recordid>0,{F},{T})
   Result = 
Loading genmaps
Step3
Sql : select props from tstructs where lower(name)= :name  order by blobno

Paramval : tsrcf
ParamTYpe : c
Param List : name

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

Time elapsed = 5
Step4
tstructs\stm size:4166
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=tsrcf
adxinout=o
Time elapsed = 17
select * from trn_rcms_hearing where trn_rcms_hearingid=0
Time elapsed = 5
   Evaluating date()
   Result = 
   Evaluating { AND a1.court_code = :m_courtcode }
   Result = 
   Evaluating m_courtname
   Result = 
   Evaluating case_purpose_name
   Result = 
   Evaluating {NO}
   Result = 
   Evaluating {Feedback Submitted}
   Result = 
Step3
Sql : select props from tstructs where lower(name)= :name  order by blobno

Paramval : tchdh
ParamTYpe : c
Param List : name

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

Time elapsed = 4
Step4
tstructs\stm size:1907
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tchdh
adxinout=o
Time elapsed = 7
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 5
Step3
Sql : select props from tstructs where lower(name)= :name  order by blobno

Paramval : tchdh
ParamTYpe : c
Param List : name

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

Time elapsed = 5
Step4
tstructs\stm size:1907
Step4-0
Step4-1
Step4-2
Step4-3
Step4-4
Step5
Step6
Step9
Post on approve = False
select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout)
tid=tchdh
adxinout=o
Time elapsed = 8
select * from trn_rcms_case_hist where trn_rcms_case_histid=0
Time elapsed = 6
select distinct(schemaname) from axschema where lower(transid)='tscrg'
Time elapsed = 4
select trn_rcms_caseregid from trn_rcms_casereg where trn_rcms_caseregid=0
Time elapsed = 4
select case_decision_date from trn_rcms_casereg where trn_rcms_caseregid=0
Time elapsed = 5
select distinct(schemaname) from axschema where lower(transid)='tscrg'
Time elapsed = 4
select decision_type from trn_rcms_casereg where trn_rcms_caseregid=0
Time elapsed = 4
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 rctcr

>>Frame No 1
currdate = 
Evaluating - date()
   Result of date = 11/01/2025
currdate after validation = 11/01/2025
court_code = 18165
trans_ccode = 10414
case_purpose = 
SELECT b.CASE_PURPOSE_MASTID, b.CASE_PURPOSE_NAME, b.case_purpose_code
    FROM case_purpose_mast b WHERE CASE_PURPOSE_MASTID = 1025550004746

Time elapsed = 10
case_purpose after validation = ????????? Id = 1025550004746
dec_type = 
SELECT DECISION_MASTID, DECISION_NAME
    FROM decision_mast A
   WHERE court_code = '10006' AND a.DECISION_MASTID = 11782000000706
ORDER BY DECISION_NAME

Time elapsed = 6
dec_type after validation = ????????? Id = 11782000000706
time zone difference  = 0

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

Time elapsed = 4
Saving to table TRN_RCMS_TRANSREQ
select * from TRN_RCMS_TRANSREQ where  TRN_RCMS_TRANSREQid=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 = 15792000009415
MapName 
SourceId 0
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
trans_ccode = 10414
court_code = 18165
Posting record
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = n
sourceid=0
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=11/01/2025 16:24:26
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=11/01/2025 16:24:26
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
trans_ccode=10414
Param Type = c
court_code=18165
insert into TRN_RCMS_TRANSREQ (trn_rcms_transreqid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,trans_ccode,court_code) values (:trn_rcms_transreqid,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,:trans_ccode,:court_code)

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

Time elapsed = 6
RecordId = 15792000009416
Select sysdate as sdt from dual
Time elapsed = 13
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/641
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/641
trn_rcms_caseregid = 18885000007549
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 1
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009416
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/641
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/641
Param Type = n
trn_rcms_caseregid=18885000007549
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=1
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

select * from TRN_RCMS_TRANSREQDTL where  TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
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 = 15792000009417
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/957
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/957
trn_rcms_caseregid = 10791000008381
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 2
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009417
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/957
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/957
Param Type = n
trn_rcms_caseregid=10791000008381
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=2
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009418
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/569
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/569
trn_rcms_caseregid = 16966000007791
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 3
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009418
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/569
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/569
Param Type = n
trn_rcms_caseregid=16966000007791
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=3
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

select * from TRN_RCMS_TRANSREQDTL where  TRN_RCMS_TRANSREQDTLid=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 = 4
RecordId = 15792000009419
Select sysdate as sdt from dual
Time elapsed = 7
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/555
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/555
trn_rcms_caseregid = 16340000007393
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 4
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009419
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/555
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/555
Param Type = n
trn_rcms_caseregid=16340000007393
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=4
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009420
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/463
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/463
trn_rcms_caseregid = 12013000008758
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 5
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009420
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/463
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/463
Param Type = n
trn_rcms_caseregid=12013000008758
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=5
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009421
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/794
fromcourt = 1322440008926
fromccode = 18165
transcourt = 13289000000049
case_no = 2023/794
trn_rcms_caseregid = 11112000008534
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 6
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009421
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/794
Param Type = n
fromcourt=1322440008926
Param Type = c
fromccode=18165
Param Type = n
transcourt=13289000000049
Param Type = c
case_no=2023/794
Param Type = n
trn_rcms_caseregid=11112000008534
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=6
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009422
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/409
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/409
trn_rcms_caseregid = 14651000007420
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 7
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009422
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/409
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/409
Param Type = n
trn_rcms_caseregid=14651000007420
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=7
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 6
RecordId = 15792000009423
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/572
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/572
trn_rcms_caseregid = 17080000008754
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 8
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009423
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/572
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/572
Param Type = n
trn_rcms_caseregid=17080000008754
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=8
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

select * from TRN_RCMS_TRANSREQDTL where  TRN_RCMS_TRANSREQDTLid=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 = 15792000009424
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/833
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/833
trn_rcms_caseregid = 17066000007458
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 9
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009424
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/833
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/833
Param Type = n
trn_rcms_caseregid=17066000007458
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=9
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

select * from TRN_RCMS_TRANSREQDTL where  TRN_RCMS_TRANSREQDTLid=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 = 5
RecordId = 15792000009425
Select sysdate as sdt from dual
Time elapsed = 7
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/571
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/571
trn_rcms_caseregid = 17054000008660
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 10
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009425
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/571
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/571
Param Type = n
trn_rcms_caseregid=17054000008660
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=10
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 3
RecordId = 15792000009426
Select sysdate as sdt from dual
Time elapsed = 7
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/386
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/386
trn_rcms_caseregid = 11519000008343
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 11
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009426
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/386
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/386
Param Type = n
trn_rcms_caseregid=11519000008343
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=11
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

select * from TRN_RCMS_TRANSREQDTL where  TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 6
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 = 5
RecordId = 15792000009427
Select sysdate as sdt from dual
Time elapsed = 7
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/431
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/431
trn_rcms_caseregid = 16152000007212
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 12
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009427
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/431
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/431
Param Type = n
trn_rcms_caseregid=16152000007212
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=12
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

select * from TRN_RCMS_TRANSREQDTL where  TRN_RCMS_TRANSREQDTLid=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 = 4
RecordId = 15792000009428
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/65
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/65
trn_rcms_caseregid = 14606000008296
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 13
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009428
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/65
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/65
Param Type = n
trn_rcms_caseregid=14606000008296
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=13
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 5
RecordId = 15792000009429
Select sysdate as sdt from dual
Time elapsed = 7
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/953
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/953
trn_rcms_caseregid = 10734000007763
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 14
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009429
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/953
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/953
Param Type = n
trn_rcms_caseregid=10734000007763
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=14
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

select * from TRN_RCMS_TRANSREQDTL where  TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 6
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 = 5
RecordId = 15792000009430
Select sysdate as sdt from dual
Time elapsed = 7
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/510
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/510
trn_rcms_caseregid = 15917000007396
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 15
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009430
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/510
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/510
Param Type = n
trn_rcms_caseregid=15917000007396
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=15
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

select * from TRN_RCMS_TRANSREQDTL where  TRN_RCMS_TRANSREQDTLid=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 = 5
RecordId = 15792000009431
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/452
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/452
trn_rcms_caseregid = 17291000007244
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 16
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009431
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/452
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/452
Param Type = n
trn_rcms_caseregid=17291000007244
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=16
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009432
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2024/64
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2024/64
trn_rcms_caseregid = 11459000008378
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 17
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009432
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2024/64
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2024/64
Param Type = n
trn_rcms_caseregid=11459000008378
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=17
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009433
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/453
fromcourt = 1322440008926
fromccode = 18165
transcourt = 13289000000049
case_no = 2023/453
trn_rcms_caseregid = 17316000009210
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 18
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009433
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/453
Param Type = n
fromcourt=1322440008926
Param Type = c
fromccode=18165
Param Type = n
transcourt=13289000000049
Param Type = c
case_no=2023/453
Param Type = n
trn_rcms_caseregid=17316000009210
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=18
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009434
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/817
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/817
trn_rcms_caseregid = 13805000009475
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 19
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009434
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/817
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/817
Param Type = n
trn_rcms_caseregid=13805000009475
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=19
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009435
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/554
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/554
trn_rcms_caseregid = 16308000009115
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 20
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009435
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/554
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/554
Param Type = n
trn_rcms_caseregid=16308000009115
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=20
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009436
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/649
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/649
trn_rcms_caseregid = 18982000008150
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 21
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009436
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/649
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/649
Param Type = n
trn_rcms_caseregid=18982000008150
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=21
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 6
RecordId = 15792000009437
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/622
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/622
trn_rcms_caseregid = 18497000008946
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 22
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009437
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/622
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/622
Param Type = n
trn_rcms_caseregid=18497000008946
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=22
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

select * from TRN_RCMS_TRANSREQDTL where  TRN_RCMS_TRANSREQDTLid=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 = 5
RecordId = 15792000009438
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2024/41
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2024/41
trn_rcms_caseregid = 19618000008595
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 23
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009438
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2024/41
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2024/41
Param Type = n
trn_rcms_caseregid=19618000008595
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=23
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 5
RecordId = 15792000009439
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/559
fromcourt = 1322440008926
fromccode = 18165
transcourt = 13289000000049
case_no = 2023/559
trn_rcms_caseregid = 16444000008142
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 24
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009439
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/559
Param Type = n
fromcourt=1322440008926
Param Type = c
fromccode=18165
Param Type = n
transcourt=13289000000049
Param Type = c
case_no=2023/559
Param Type = n
trn_rcms_caseregid=16444000008142
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=24
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

select * from TRN_RCMS_TRANSREQDTL where  TRN_RCMS_TRANSREQDTLid=0
Time elapsed = 4
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 = 15792000009440
Select sysdate as sdt from dual
Time elapsed = 10
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/382
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/382
trn_rcms_caseregid = 11239000007851
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 25
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009440
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/382
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/382
Param Type = n
trn_rcms_caseregid=11239000007851
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=25
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 3
RecordId = 15792000009441
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/505
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/505
trn_rcms_caseregid = 15744000007713
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 26
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009441
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/505
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/505
Param Type = n
trn_rcms_caseregid=15744000007713
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=26
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009442
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/482
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/482
trn_rcms_caseregid = 12432000007585
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 27
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009442
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/482
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/482
Param Type = n
trn_rcms_caseregid=12432000007585
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=27
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 3
RecordId = 15792000009443
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/447
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/447
trn_rcms_caseregid = 17100000009054
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 28
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009443
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/447
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/447
Param Type = n
trn_rcms_caseregid=17100000009054
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=28
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009444
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/455
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/455
trn_rcms_caseregid = 17390000007123
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 29
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009444
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/455
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/455
Param Type = n
trn_rcms_caseregid=17390000007123
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=29
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 5
RecordId = 15792000009445
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/421
fromcourt = 1322440008926
fromccode = 18165
transcourt = 13289000000049
case_no = 2023/421
trn_rcms_caseregid = 15451000009123
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 30
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009445
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/421
Param Type = n
fromcourt=1322440008926
Param Type = c
fromccode=18165
Param Type = n
transcourt=13289000000049
Param Type = c
case_no=2023/421
Param Type = n
trn_rcms_caseregid=15451000009123
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=30
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009446
Select sysdate as sdt from dual
Time elapsed = 4
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/423
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/423
trn_rcms_caseregid = 15524000008134
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 31
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009446
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/423
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/423
Param Type = n
trn_rcms_caseregid=15524000008134
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=31
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 3
RecordId = 15792000009447
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/804
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/804
trn_rcms_caseregid = 13533000008124
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 32
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009447
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/804
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/804
Param Type = n
trn_rcms_caseregid=13533000008124
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=32
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 7
RecordId = 15792000009448
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/451
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/451
trn_rcms_caseregid = 17251000008640
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 33
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009448
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/451
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/451
Param Type = n
trn_rcms_caseregid=17251000008640
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=33
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 5
RecordId = 15792000009449
Select sysdate as sdt from dual
Time elapsed = 9
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/41
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/41
trn_rcms_caseregid = 14932000007327
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 34
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009449
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/41
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/41
Param Type = n
trn_rcms_caseregid=14932000007327
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=34
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009450
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/40
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/40
trn_rcms_caseregid = 14904000007549
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 35
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009450
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/40
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/40
Param Type = n
trn_rcms_caseregid=14904000007549
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=35
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009451
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/461
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/461
trn_rcms_caseregid = 10011000008122
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 36
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009451
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/461
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/461
Param Type = n
trn_rcms_caseregid=10011000008122
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=36
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009452
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/476
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/476
trn_rcms_caseregid = 12259000008024
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 37
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009452
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/476
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/476
Param Type = n
trn_rcms_caseregid=12259000008024
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=37
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009453
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2024/157
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2024/157
trn_rcms_caseregid = 14558000009668
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 38
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009453
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2024/157
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2024/157
Param Type = n
trn_rcms_caseregid=14558000009668
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=38
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 11
RecordId = 15792000009454
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/5
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/5
trn_rcms_caseregid = 19827000007627
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 39
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009454
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/5
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/5
Param Type = n
trn_rcms_caseregid=19827000007627
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=39
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 5
RecordId = 15792000009455
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/517
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/517
trn_rcms_caseregid = 17492000007428
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 40
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009455
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/517
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/517
Param Type = n
trn_rcms_caseregid=17492000007428
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=40
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 5
RecordId = 15792000009456
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/43
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/43
trn_rcms_caseregid = 10930000008580
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 41
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009456
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/43
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/43
Param Type = n
trn_rcms_caseregid=10930000008580
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=41
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 5
RecordId = 15792000009457
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/387
fromcourt = 1322440008926
fromccode = 18165
transcourt = 13289000000049
case_no = 2023/387
trn_rcms_caseregid = 11567000008772
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 42
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009457
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/387
Param Type = n
fromcourt=1322440008926
Param Type = c
fromccode=18165
Param Type = n
transcourt=13289000000049
Param Type = c
case_no=2023/387
Param Type = n
trn_rcms_caseregid=11567000008772
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=42
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 5
RecordId = 15792000009458
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/402
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/402
trn_rcms_caseregid = 14295000008350
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 43
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009458
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/402
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/402
Param Type = n
trn_rcms_caseregid=14295000008350
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=43
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 4
RecordId = 15792000009459
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/401
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2023/401
trn_rcms_caseregid = 14248000008037
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 44
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009459
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/401
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2023/401
Param Type = n
trn_rcms_caseregid=14248000008037
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=44
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 5
RecordId = 15792000009460
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/604
fromcourt = 1322440008926
fromccode = 18165
transcourt = 13289000000049
case_no = 2023/604
trn_rcms_caseregid = 18302000008122
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 45
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009460
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/604
Param Type = n
fromcourt=1322440008926
Param Type = c
fromccode=18165
Param Type = n
transcourt=13289000000049
Param Type = c
case_no=2023/604
Param Type = n
trn_rcms_caseregid=18302000008122
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=45
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 5
RecordId = 15792000009461
Select sysdate as sdt from dual
Time elapsed = 6
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2023/793
fromcourt = 1322440008926
fromccode = 18165
transcourt = 13289000000049
case_no = 2023/793
trn_rcms_caseregid = 11104000009276
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 46
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009461
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2023/793
Param Type = n
fromcourt=1322440008926
Param Type = c
fromccode=18165
Param Type = n
transcourt=13289000000049
Param Type = c
case_no=2023/793
Param Type = n
trn_rcms_caseregid=11104000009276
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=46
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,fromcourt,fromccode,transcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:fromcourt,:fromccode,:transcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

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

Time elapsed = 5
RecordId = 15792000009462
Select sysdate as sdt from dual
Time elapsed = 5
decision_date = 09/01/2025
status = 0
transContFld = T
requestno = 18165-10414#2024/153
transcourt = 13289000000049
fromccode = 18165
fromcourt = 1322440008926
case_no = 2024/153
trn_rcms_caseregid = 14206000008980
transccode = 10414
TRN_RCMS_TRANSREQDTLrow = 47
Posting record
Param Type = n
trn_rcms_transreqdtlid=15792000009462
Param Type = n
trn_rcms_transreqid=15792000009415
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = n
status=0
Param Type = c
transcontfld=T
Param Type = c
requestno=18165-10414#2024/153
Param Type = n
transcourt=13289000000049
Param Type = c
fromccode=18165
Param Type = n
fromcourt=1322440008926
Param Type = c
case_no=2024/153
Param Type = n
trn_rcms_caseregid=14206000008980
Param Type = c
transccode=10414
Param Type = n
trn_rcms_transreqdtlrow=47
insert into TRN_RCMS_TRANSREQDTL (trn_rcms_transreqdtlid,trn_rcms_transreqid,decision_date,status,transcontfld,requestno,transcourt,fromccode,fromcourt,case_no,trn_rcms_caseregid,transccode,trn_rcms_transreqdtlrow) values (:trn_rcms_transreqdtlid,:trn_rcms_transreqid,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),:status,:transcontfld,:requestno,:transcourt,:fromccode,:fromcourt,:case_no,:trn_rcms_caseregid,:transccode,:trn_rcms_transreqdtlrow)

Time elapsed for insert/update = 3945774295487

>>Executing genmaps

>>Posting from rctcr to tscd from row 1

>>Mapping
Mapped court_code Row = 1 value = 18165 idvalue 0
Mapped case_no Row = 1 value = 2023/641 idvalue 0
Mapped new_case_purpose Row = 1 value = ????????? idvalue 1025550004746
Mapped decision_type Row = 1 value = ????????? idvalue 11782000000706
Mapped decision_date Row = 1 value = 09/01/2025 idvalue 0
Mapped hearing_date Row = 1 value = 09/01/2025 idvalue 0
Mapped pagesource Row = 1 value = TRANSPAGE idvalue 0

>>Validating tscd

>>Frame No 1
currdate = 
Evaluating - date()
   Result of date = 11/01/2025
currdate after validation = 11/01/2025
court_name = 
username=dc_sikar
select court_name_mastid,court_name,court_code from v_axcourts  where paxusername=:username

username=dc_sikar
Time elapsed = 8
Evaluating - m_courtname
   m_courtname = ??????? ??????,????
court_name after validation = ??????? ??????,???? Id = 1322440008926
court_code = 18165
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
viewfilter = 
Evaluating - {AND a1.court_code=:m_courtcode }
viewfilter after validation = AND a1.court_code=:m_courtcode 
case_no = 2023/641
casedetails = 
court_code=18165
case_no=2023/641
recordid=0
SELECT A1.COURT_CODE,
       A1.TRN_RCMS_CASEREGID,
       A1.INSTITUTION_DATE,
       A1.CASE_NO,
       A1.MCASE_NO,
       A1.LAST_HEARING_DATE      AS hearing_date,
       B2.DISTRICT_NAME,
       B3.CASE_TYPE,
       B1.CASE_PURPOSE_NAME,
       A1.CASE_PURPOSE_NAME      AS CPID,
       B4.ACT_NAME,
       A1.SECTION_NAME,
       A1.PRIMARY_APPELLANT      AS APPELLANT_NAME,
       A1.PRIMARY_RESPONDENT     AS RESPONDENT_NAME
  FROM trn_rcms_casereg   a1,
       case_purpose_mast  b1,
       district_mast      b2,
       case_type_mast     b3,
       rule_act_mast      b4
 WHERE     A1.CASE_PURPOSE_NAME = B1.CASE_PURPOSE_MASTID
       AND A1.DISTRICT_NAME = B2.DISTRICT_MASTID
       AND A1.ACT_NAME = B4.RULE_ACT_MASTID
       AND A1.CASE_TYPE = B3.CASE_TYPE_MASTID
       AND A1.COURT_CODE = :court_code
       AND a1.CASE_NO = :case_no
       AND (CASE
                WHEN :recordid > 0
                THEN
                    1
                WHEN     :recordid = 0
                     AND b1.CASE_PURPOSE_MASTID <> 1364660005542
                     AND b1.CASE_PURPOSE_GROUP <> 18438000000000
                     AND NOT EXISTS
                             (SELECT 1
                                FROM TRN_RCMS_DECISION
                               WHERE TRN_RCMS_CASEID = a1.TRN_RCMS_CASEREGID)
                THEN
                    1
                ELSE
                    0
            END) = 1

court_code=18165
case_no=2023/641
recordid=0
recordid=0
Time elapsed = 668
casedetails after validation = 18165
trn_rcms_caseid = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
S=18885000007549
Select trn_rcms_caseid from trn_rcms_decision where trn_rcms_caseid = :S
S=18885000007549
Time elapsed = 503
trn_rcms_caseid after validation = 18885000007549
pagesource = TRANSPAGE
instdate = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
instdate after validation = 21/09/2023
case_type = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
case_type after validation = ????
act = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
act after validation = ???????? ??-?????? ?????? 1956
section = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
section after validation = 90(B)
case_purposeid = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
case_purposeid after validation = 18678000000000
purpose = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
purpose after validation = ????
hearing_date = 09/01/2025
Evaluating - iif(hearing_date>currdate,{Hearing Date Can not be greater Than Today },{T})
   hearing_date = 09/01/2025
   currdate = 11/01/2025
   Result of iif = T
escase = 
court_code=18165
case_no=2023/641
SELECT REPLACE (A1.CASE_NO, '/', '')
  FROM trn_rcms_casereg a1
 WHERE A1.COURT_CODE = :court_code AND A1.CASE_NO = :case_no

court_code=18165
case_no=2023/641
Time elapsed = 12
escase after validation = 2023641
appellant = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
appellant after validation = ??????? ????
respondent = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
respondent after validation = ????????? ??????? ???????? ??????
decision_date = 09/01/2025
Evaluating - iif(decision_date>currdate,{Decision Date Can not be greater Than Today },{T})
   decision_date = 09/01/2025
   currdate = 11/01/2025
   Result of iif = T
decision_type = ????????? Id = 11782000000706
recordid=0
pagesource=TRANSPAGE
SELECT DECISION_MASTID, DECISION_NAME
    FROM decision_mast A
   WHERE     court_code = '10006'
         AND DECISION_MASTID NOT IN
                 (11469000000000, 11463000000022, 11776000000009)
         AND (CASE
                  WHEN :recordid > 0
                  THEN
                      1
                  WHEN     NVL ( :recordid, 0) = 0
                       AND DECISION_MASTID != 11782000000706
                  THEN
                      1
                  WHEN     NVL ( :pagesource, 'F') = 'TRANSPAGE'
                       AND DECISION_MASTID = 11782000000706
                  THEN
                      1
                  ELSE
                      0
              END) =
             1
ORDER BY DECISION_NAME

recordid=0
recordid=0
pagesource=TRANSPAGE
Time elapsed = 9
decsion_mastid = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
decsion_mastid after validation = 11782000000706
new_case_purpose = ????????? Id = 1025550004746
decision_type=?????????
SELECT b.CASE_PURPOSE_MASTID, b.CASE_PURPOSE_NAME, b.case_purpose_code
    FROM case_purpose_mast b
   WHERE CASE_PURPOSE_NAME = :decision_type
ORDER BY CASE_PURPOSE_NAME

decision_type=?????????
Time elapsed = 7
new_purpose_id = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
new_purpose_id after validation = 1025550004746
new_purpose_code = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
new_purpose_code after validation = 900
showinactive = 
member_name = 
court_code=18165
showinactive=
SELECT a.OFFICER_NAME ,a.AADHAAR_NO  FROM mst_rcms_officer a,trn_rcms_officer b where  a.MST_RCMS_OFFICERID = b.OFFICER_NAME

AND b.court_code = :court_code AND UPPER (b.INACTIVE) = (CASE WHEN :showinactive = 'T' THEN 'T' ELSE 'F' END)

court_code=18165
showinactive=
Time elapsed = 11
member_name after validation = vandana singhvi
decision_remark = 
template = 
template after validation = General Decision
no_of_page = 
Evaluating - 0
no_of_page after validation = 0
chkfinal = 
Evaluating - {F}
chkfinal after validation = F
isoneside = 
Evaluating - {F}
isoneside after validation = F
chkworth = 
Evaluating - {F}
chkworth after validation = F
dupchk = 
Evaluating - court_code+case_no
   court_code = 18165
   case_no = 2023/641
S=181652023/641
Select dupchk from trn_rcms_decision where lower(dupchk) = :S
S=181652023/641
Time elapsed = 809
dupchk after validation = 181652023/641
usern = 
Evaluating - username
   username = dc_sikar
usern after validation = dc_sikar
adharno = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
adharno after validation = 333892884132
esign_template = 
Evaluating - {cd.pdf}
esign_template after validation = cd.pdf
esign_filename = 
court_code=18165
case_no=2023/641
SELECT UPPER ('CD' || REGEXP_REPLACE ( :court_code || A1.CASE_NO, '[^0-9A-Za-z]', ''))
          AS FileName
  FROM trn_rcms_casereg a1
 WHERE A1.COURT_CODE = :court_code AND A1.CASE_NO = :case_no

court_code=18165
court_code=18165
case_no=2023/641
Time elapsed = 16
esign_filename after validation = CD181652023641
trans_type = 
Evaluating - iif(recordid>0,{Decision Updated},{Decision Submitted})
   recordid = 0
   Result of iif = Decision Submitted
trans_type after validation = Decision Submitted
isfeedback = 
Evaluating - iif(recordid>0,{F},{T})
   recordid = 0
   Result of iif = T
isfeedback after validation = T
rtf_letter_content = 
rtf_letter_content_printable = 
html_letter_content = 
rtf_qr_content = 
rtf_qr_content_printable = 
html_qr_details = 
dc_summ = 

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

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

Time elapsed = 17
RecordId = 15792000009463
MapName rctcr1
SourceId 15792000009416
Select sysdate as sdt from dual
Time elapsed = 7
Select sysdate as sdt from dual
Time elapsed = 5
isoneside = F
chkfinal = F
chkworth = F
trn_rcms_caseid = 18885000007549
dupchk = 181652023/641
no_of_page = 0
showinactive = 
new_purpose_code = 900
member_name = vandana singhvi
template = General Decision
decision_remark = 
decision_type = 11782000000706
decision_date = 09/01/2025
hearing_date = 09/01/2025
court_code = 18165
case_no = 2023/641
new_case_purpose = 1025550004746
Posting record
Param Type = n
trn_rcms_decisionid=15792000009463
Param Type = c
mapname=rctcr1
Param Type = n
sourceid=15792000009416
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=11/01/2025 16:24:32
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=11/01/2025 16:24:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isoneside=F
Param Type = c
chkfinal=F
Param Type = c
chkworth=F
Param Type = n
trn_rcms_caseid=18885000007549
Param Type = c
dupchk=181652023/641
Param Type = n
no_of_page=0
Param Type = c
new_purpose_code=900
Param Type = c
member_name=vandana singhvi
Param Type = c
template=General Decision
Param Type = n
decision_type=11782000000706
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = c
hearing_date=09/01/2025 00:00:00
Param Type = c
court_code=18165
Param Type = c
case_no=2023/641
Param Type = n
new_case_purpose=1025550004746
insert into TRN_RCMS_DECISION (trn_rcms_decisionid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,isoneside,chkfinal,chkworth,trn_rcms_caseid,dupchk,no_of_page,showinactive,new_purpose_code,member_name,template,decision_remark,decision_type,decision_date,hearing_date,court_code,case_no,new_case_purpose) values (:trn_rcms_decisionid,: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,:isoneside,:chkfinal,:chkworth,:trn_rcms_caseid,:dupchk,:no_of_page,null,:new_purpose_code,:member_name,:template,null,:decision_type,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:new_case_purpose)

Saving to table TRN_RCMS_DECCONTENT
select * from TRN_RCMS_DECCONTENT where  TRN_RCMS_DECCONTENTid=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 = 15792000009464
Select sysdate as sdt from dual
Time elapsed = 6
rtf_qr_content_printable = 
html_qr_details = 
dc_summ = 
rtf_qr_content = 
rtf_letter_content = 
rtf_letter_content_printable = 
html_letter_content = 
Posting record
Param Type = n
trn_rcms_deccontentid=15792000009464
Param Type = n
trn_rcms_decisionid=15792000009463
insert into TRN_RCMS_DECCONTENT (trn_rcms_deccontentid,trn_rcms_decisionid,rtf_qr_content_printable,html_qr_details,dc_summ,rtf_qr_content,rtf_letter_content,rtf_letter_content_printable,html_letter_content) values (:trn_rcms_deccontentid,:trn_rcms_decisionid,null,null,null,null,null,null,null)


>>Mapping
Mapped court_code Row = 1 value = 18165 idvalue 0
Mapped case_no Row = 1 value = 2023/641 idvalue 0
Mapped trn_rcms_caseid Row = 1 value = 18885000007549 idvalue 0
Mapped next_hear_date Row = 1 value = 09/01/2025 idvalue 0
Mapped new_case_purpose Row = 1 value = ????????? idvalue 1025550004746
Mapped pagesrc Row = 1 value = DECISION idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Decision) idvalue 0

>>Validating tsrcf

>>Frame No 1
currdate = 
Evaluating - date()
   Result of date = 11/01/2025
currdate after validation = 11/01/2025
pagesrc = DECISION
viewfilter = 
Evaluating - { AND a1.court_code = :m_courtcode }
viewfilter after validation =  AND a1.court_code = :m_courtcode 
court_name = 
username=dc_sikar
select court_name_mastid,court_name,court_code from v_axcourts  where paxusername=:username

username=dc_sikar
Time elapsed = 7
Evaluating - m_courtname
   m_courtname = ??????? ??????,????
court_name after validation = ??????? ??????,???? Id = 1322440008926
court_code = 18165
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
case_no = 2023/641
Dynamicfilter x1.CASE_NO~Case No = 
Query component recreating again
pagesrc=DECISION
court_code=18165
SELECT x1.CASE_NO,x1.TRN_RCMS_CASEREGID
    FROM trn_rcms_casereg x1,CASE_PURPOSE_mast x2
   WHERE  x1.CASE_PURPOSE_NAME = x2.CASE_PURPOSE_mastid         
         AND (x2.CASE_PURPOSE_GROUP <> 18438000000000 OR :pagesrc = 'DECISION')
         AND x1.COURT_CODE = :court_code             
 
ORDER BY CASE_NO


pagesrc=DECISION
court_code=18165
Time elapsed = 67
trn_rcms_caseid = 18885000007549
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
Dynamicfilter x1.CASE_NO~Case No = 
casedetails = 
court_code=18165
trn_rcms_caseid=18885000007549
SELECT DISTINCT A1.CASE_NO,
                A1.DOCID,
                A1.TRN_RCMS_CASEREGID,
                A1.INSTITUTION_DATE,
                A2.ACT_NAME,
                A1.SECTION_NAME,
                A3.CASE_PURPOSE_NAME,
                A4.CASE_PURPOSE_GROUP,
                A1.CASEDESCRIPTION,
                A1.LAST_HEARING_DATE as HEARINGDATE,
                A1.PRIMARY_APPELLANT,
                A1.PRIMARY_RESPONDENT
  FROM trn_rcms_casereg A1,
       rule_Act_mast A2,
       case_purpose_mast A3,
       case_purpose_group_mast A4
 WHERE     A1.ACT_NAME = A2.RULE_ACT_MASTID
       AND A1.COURT_CODE = :court_code
       AND A1.CASE_PURPOSE_NAME = A3.CASE_PURPOSE_MASTID(+)
       AND A3.CASE_PURPOSE_GROUP = A4.CASE_PURPOSE_GROUP_MASTID(+)     
       AND A1.TRN_RCMS_CASEREGID = :trn_rcms_caseid

court_code=18165
trn_rcms_caseid=18885000007549
Time elapsed = 13
casedetails after validation = 2023/641
pre_hear_date = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
pre_hear_date after validation = 29/01/2025
inst_date = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
inst_date after validation = 21/09/2023
act_name = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
act_name after validation = ???????? ??-?????? ?????? 1956
section_name = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
section_name after validation = 90(B)
case_purpose_group = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
case_purpose_group after validation = ?????
case_purpose_name = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
case_purpose_name after validation = ????
appellant_name = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
appellant_name after validation = ??????? ????
respondent_name = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
respondent_name after validation = ????????? ??????? ???????? ??????
description = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
new_case_purpose = ????????? Id = 1025550004746
pagesrc=DECISION
court_code=18165
SELECT b.CASE_PURPOSE_MASTID,
       b.CASE_PURPOSE_NAME,
       b.CASE_PURPOSE_GROUP,
       b.case_purpose_code
  FROM case_purpose_mast b, court_setup_casepurpose a
 WHERE     A.CASE_PURPOSE_NAME = B.CASE_PURPOSE_MASTID
       AND (B.CASE_PURPOSE_GROUP <> 18438000000000 OR :pagesrc = 'DECISION')
       AND CASE_PURPOSE_MASTID != 1364660005542
       AND a.PCOURT_CODE = :court_code
UNION
SELECT b.CASE_PURPOSE_MASTID,
       b.CASE_PURPOSE_NAME,
       b.CASE_PURPOSE_GROUP,
       b.case_purpose_code
  FROM case_purpose_mast b
 WHERE (B.CASE_PURPOSE_GROUP = 18438000000000 AND :pagesrc = 'DECISION')
       OR (case_purpose_code = '1111' AND :pagesrc = 'PRO_ADJ')
ORDER BY 2

pagesrc=DECISION
court_code=18165
pagesrc=DECISION
pagesrc=DECISION
Time elapsed = 16
new_purpose_code = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
new_purpose_code after validation = 900
next_hear_date = 09/01/2025
case_purpose_nameid = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
case_purpose_nameid after validation = 1025550004746
isadjourn = 
Evaluating - {NO}
isadjourn after validation = NO
adjourn_type = 
SELECT A1.ADJOURN_MASTID, A1.ADJOURN_TYPE
    FROM adjourn_mast a1
   WHERE a1.inactive = 'F'
ORDER BY A1.ADJOURN_TYPE

Time elapsed = 5
adj_mastid = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
adjourn_remark = 
trans_type = Feedback Submitted (Decision)

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

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

Time elapsed = 5
RecordId = 15792000009465
MapName tscd2
SourceId 15792000009463
Select sysdate as sdt from dual
Time elapsed = 5
Select sysdate as sdt from dual
Time elapsed = 5
adjourn_type = 0
adjourn_remark = 
pre_hear_date = 29/01/2025
isadjourn = NO
new_case_purpose = 1025550004746
case_no = 2023/641
court_code = 18165
trn_rcms_caseid = 18885000007549
next_hear_date = 09/01/2025
Posting record
Param Type = n
trn_rcms_hearingid=15792000009465
Param Type = c
mapname=tscd2
Param Type = n
sourceid=15792000009463
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=11/01/2025 16:24:32
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=11/01/2025 16:24:32
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = n
adjourn_type=0
Param Type = c
pre_hear_date=29/01/2025 00:00:00
Param Type = c
isadjourn=NO
Param Type = n
new_case_purpose=1025550004746
Param Type = c
case_no=2023/641
Param Type = c
court_code=18165
Param Type = c
trn_rcms_caseid=18885000007549
Param Type = c
next_hear_date=09/01/2025 00:00:00
insert into TRN_RCMS_HEARING (trn_rcms_hearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,adjourn_remark,pre_hear_date,isadjourn,new_case_purpose,case_no,court_code,trn_rcms_caseid,next_hear_date) values (:trn_rcms_hearingid,: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,:adjourn_type,null,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:isadjourn,:new_case_purpose,:case_no,:court_code,:trn_rcms_caseid,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'))


>>Mapping
Mapped court_code Row = 1 value = 18165 idvalue 0
Mapped case_no Row = 1 value = 2023/641 idvalue 0
Mapped hearing_date Row = 1 value = 09/01/2025 idvalue 0
Mapped case_purpose Row = 1 value = 1025550004746 idvalue 0
Mapped trans_type Row = 1 value = Decision Submitted idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18885000007549 idvalue 0
Mapped decision_date Row = 1 value = 09/01/2025 idvalue 0
Mapped decision_type Row = 1 value = 11782000000706 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped prev_hearing_date Row = 1 value = 09/01/2025 idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 18885000007549
case_no = 2023/641
prev_hearing_date = 09/01/2025
hearing_date = 09/01/2025
prev_case_purposename = ????
prev_case_purpose = 
prev_case_purposename=????
SELECT V.CASE_PURPOSE_MASTID
  FROM case_purpose_mast v
 WHERE v.case_purpose_name = :prev_case_purposename

prev_case_purposename=????
Time elapsed = 7
prev_case_purpose after validation = 18678000000000
case_purpose = 1025550004746
trans_type = Decision Submitted
clcheck = 
isadjourn = 
adjourn_type = 
decision_type = 11782000000706
decision_date = 09/01/2025

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

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

Time elapsed = 3
RecordId = 15792000009466
MapName tscd1
SourceId 15792000009463
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 7
prev_hearing_date = 09/01/2025
decision_type = 11782000000706
decision_date = 09/01/2025
adjourn_type = 
isadjourn = 
prev_case_purpose = 18678000000000
hearing_date = 09/01/2025
case_no = 2023/641
court_code = 18165
case_purpose = 1025550004746
trans_type = Decision Submitted
trn_rcms_caseregid = 18885000007549
Posting record
Param Type = n
trn_rcms_case_histid=15792000009466
Param Type = c
mapname=tscd1
Param Type = n
sourceid=15792000009463
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=11/01/2025 16:29:05
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=11/01/2025 16:29:05
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
prev_hearing_date=09/01/2025 00:00:00
Param Type = n
decision_type=11782000000706
Param Type = c
decision_date=09/01/2025 00:00:00
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
hearing_date=09/01/2025 00:00:00
Param Type = c
case_no=2023/641
Param Type = c
court_code=18165
Param Type = c
case_purpose=1025550004746
Param Type = c
trans_type=Decision Submitted
Param Type = c
trn_rcms_caseregid=18885000007549
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hearing_date,decision_type,decision_date,adjourn_type,isadjourn,prev_case_purpose,hearing_date,case_no,court_code,case_purpose,trans_type,trn_rcms_caseregid) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'),:decision_type,to_date(:decision_date,'dd/mm/yyyy hh24:mi:ss'),null,null,:prev_case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:case_purpose,:trans_type,:trn_rcms_caseregid)


>>Mapping
Mapped court_code Row = 1 value = 18165 idvalue 0
Mapped case_no Row = 1 value = 2023/641 idvalue 0
Mapped prev_hearing_date Row = 1 value = 29/01/2025 idvalue 0
Mapped hearing_date Row = 1 value = 09/01/2025 idvalue 0
Mapped prev_case_purposename Row = 1 value = ???? idvalue 0
Mapped case_purpose Row = 1 value = 1025550004746 idvalue 0
Mapped trans_type Row = 1 value = Feedback Submitted (Decision) idvalue 0
Mapped trn_rcms_caseregid Row = 1 value = 18885000007549 idvalue 0
Mapped isadjourn Row = 1 value = NO idvalue 0
Mapped adjourn_type Row = 1 value =  idvalue 0

>>Validating tchdh

>>Frame No 1
court_code = 18165
trn_rcms_caseregid = 18885000007549
case_no = 2023/641
prev_hearing_date = 29/01/2025
hearing_date = 09/01/2025
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 = 18678000000000
case_purpose = 1025550004746
trans_type = Feedback Submitted (Decision)
clcheck = 
isadjourn = NO
adjourn_type = 
decision_type = 
decision_date = 

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

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

Time elapsed = 4
RecordId = 15792000009467
MapName tsrcf1
SourceId 15792000009465
Select sysdate as sdt from dual
Time elapsed = 6
Select sysdate as sdt from dual
Time elapsed = 6
adjourn_type = 
isadjourn = NO
trn_rcms_caseregid = 18885000007549
decision_date = 
decision_type = 0
prev_case_purpose = 18678000000000
trans_type = Feedback Submitted (Decision)
prev_hearing_date = 29/01/2025
case_no = 2023/641
court_code = 18165
case_purpose = 1025550004746
hearing_date = 09/01/2025
Posting record
Param Type = n
trn_rcms_case_histid=15792000009467
Param Type = c
mapname=tsrcf1
Param Type = n
sourceid=15792000009465
Param Type = c
cancel=F
Param Type = c
createdby=dc_sikar
Param Type = c
createdon=11/01/2025 16:29:09
Param Type = c
username=dc_sikar
Param Type = c
modifiedon=11/01/2025 16:29:09
Param Type = c
app_desc=1
Param Type = c
app_level=1
Param Type = c
isadjourn=NO
Param Type = c
trn_rcms_caseregid=18885000007549
Param Type = n
decision_type=0
Param Type = c
prev_case_purpose=18678000000000
Param Type = c
trans_type=Feedback Submitted (Decision)
Param Type = c
prev_hearing_date=29/01/2025 00:00:00
Param Type = c
case_no=2023/641
Param Type = c
court_code=18165
Param Type = c
case_purpose=1025550004746
Param Type = c
hearing_date=09/01/2025 00:00:00
insert into TRN_RCMS_CASE_HIST (trn_rcms_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,adjourn_type,isadjourn,trn_rcms_caseregid,decision_date,decision_type,prev_case_purpose,trans_type,prev_hearing_date,case_no,court_code,case_purpose,hearing_date) values (:trn_rcms_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:isadjourn,:trn_rcms_caseregid,null,:decision_type,:prev_case_purpose,:trans_type,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss'),:case_no,:court_code,:case_purpose,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'))


>>Posting from rctcr to tscd from row 2

>>Mapping
Mapped court_code Row = 1 value = 18165 idvalue 0
Mapped case_no Row = 1 value = 2023/957 idvalue 0
Mapped new_case_purpose Row = 1 value = ????????? idvalue 1025550004746
Mapped decision_type Row = 1 value = ????????? idvalue 11782000000706
Mapped decision_date Row = 1 value = 09/01/2025 idvalue 0
Mapped hearing_date Row = 1 value = 09/01/2025 idvalue 0
Mapped pagesource Row = 1 value = TRANSPAGE idvalue 0

>>Validating tscd

>>Frame No 1
currdate = 
Evaluating - date()
   Result of date = 11/01/2025
currdate after validation = 11/01/2025
court_name = 
Evaluating - m_courtname
   m_courtname = ??????? ??????,????
court_name after validation = ??????? ??????,???? Id = 1322440008926
court_code = 18165
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
viewfilter = 
Evaluating - {AND a1.court_code=:m_courtcode }
viewfilter after validation = AND a1.court_code=:m_courtcode 
case_no = 2023/957
casedetails = 
case_no=2023/957
SELECT A1.COURT_CODE,
       A1.TRN_RCMS_CASEREGID,
       A1.INSTITUTION_DATE,
       A1.CASE_NO,
       A1.MCASE_NO,
       A1.LAST_HEARING_DATE      AS hearing_date,
       B2.DISTRICT_NAME,
       B3.CASE_TYPE,
       B1.CASE_PURPOSE_NAME,
       A1.CASE_PURPOSE_NAME      AS CPID,
       B4.ACT_NAME,
       A1.SECTION_NAME,
       A1.PRIMARY_APPELLANT      AS APPELLANT_NAME,
       A1.PRIMARY_RESPONDENT     AS RESPONDENT_NAME
  FROM trn_rcms_casereg   a1,
       case_purpose_mast  b1,
       district_mast      b2,
       case_type_mast     b3,
       rule_act_mast      b4
 WHERE     A1.CASE_PURPOSE_NAME = B1.CASE_PURPOSE_MASTID
       AND A1.DISTRICT_NAME = B2.DISTRICT_MASTID
       AND A1.ACT_NAME = B4.RULE_ACT_MASTID
       AND A1.CASE_TYPE = B3.CASE_TYPE_MASTID
       AND A1.COURT_CODE = :court_code
       AND a1.CASE_NO = :case_no
       AND (CASE
                WHEN :recordid > 0
                THEN
                    1
                WHEN     :recordid = 0
                     AND b1.CASE_PURPOSE_MASTID <> 1364660005542
                     AND b1.CASE_PURPOSE_GROUP <> 18438000000000
                     AND NOT EXISTS
                             (SELECT 1
                                FROM TRN_RCMS_DECISION
                               WHERE TRN_RCMS_CASEID = a1.TRN_RCMS_CASEREGID)
                THEN
                    1
                ELSE
                    0
            END) = 1

court_code=18165
case_no=2023/957
recordid=0
recordid=0
Time elapsed = 23
trn_rcms_caseid = 
Finding linkfield in fieldenter function
Linkfield found and assigning Query from link field in fieldenter function
Query assigned in fieldenter function
S=0
Select trn_rcms_caseid from trn_rcms_decision where trn_rcms_caseid = :S
S=0
Time elapsed = 889
Duplicate values are not allowed in Case No.
Error : 
Select sysdate as sdt from dual
Time elapsed = 5
insert into axerrorlog values('dc_sikar',to_date('11/01/2025 16:29:10','dd/mm/yyyy hh24:mi:ss'),'rctcr','SaveData','')
Time elapsed = 16
Constraint Name  = 
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=dc_sikar
Param Type = c
calledon=11/01/2025 16:24:50
Param Type = c
callfinished=11/01/2025 16:29:36
Param Type = c
structname=rctcr
Param Type = n
recordid=0
Param Type = c
servicename=Saving data
Param Type = c
serviceresult=Duplicate values are not allowed in Case No.
Param Type = n
timetaken=285858
Param Type = n
dbtimetaken=283236
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