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 gcmsmobileuser827ccb0eea8a706c4c34a16891f84e7btscmh00100031867990000044576004/04/20250100032010/96676564404/04/2025???Single BenchS-B- Camp Jaipur1867990000044576030/05/2025184730000000001191990000042N0tax_chandra0100032010/96776564504/04/2025???Single BenchS-B- Camp Jaipur1867990000044576030/05/2025184730000000001191990000042N0tax_chandra0100032010/111276579004/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032010/251976719704/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032010/252076719804/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032012/118777155004/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032012/278677314904/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032014/87377649304/04/2025?????Single BenchS-B- Camp Jaipur1867990000044576004/07/202510004921191990000042N0tax_chandra0100032014/90677652604/04/2025?????Single BenchS-B- Camp Jaipur1867990000044576004/07/202510004921191990000042N0tax_chandra0100032014/189377751304/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032014/223477785404/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032014/223877785804/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032014/223977785904/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032014/241977803904/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032016/57578120404/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032016/100578163404/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032016/292878355704/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N02/02/201774860tax_chandra0100032016/292978355804/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N02/02/2017132840tax_chandra0100032017/201978559504/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032018/83178649304/04/2025??? (?????)Single BenchS-B- Camp Jaipur1867990000044576018/07/202510999900001051191990000042N0tax_chandra0100032018/103078669204/04/2025??? (?????)Single BenchS-B- Camp Jaipur1867990000044576018/07/202510999900001051191990000042N0tax_chandra0100032018/138078704204/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032018/138178704304/04/2025???Single BenchS-B- Camp Jaipur1867990000044576004/07/2025184730000000001191990000042N0tax_chandra0100032019/328101699000010304/04/2025??? (?????)Single BenchS-B- Camp Jaipur1867990000044576004/07/202510999900001051191990000042N27/05/2019783494tax_chandra0100032019/883198966000013904/04/2025??? ??????Single BenchS-B- Camp Jaipur1867990000044576004/07/202518372200000631191990000042N0tax_chandra0100032019/1345103499000014804/04/2025???????Single BenchS-B- Camp Jaipur1867990000044576004/07/202514073300000441191990000042N15/11/201976883tax_chandra0100032024/84108022000916604/04/2025???Single BenchS-B- Camp Jaipur1867990000044576030/05/2025184730000000001191990000042N0tax_chandra0100032024/190117333000921504/04/2025?????Single BenchS-B- Camp Jaipur1867990000044576004/07/202510004921191990000042N0tax_chandra0100032024/191119322000966104/04/2025?????Single BenchS-B- Camp Jaipur1867990000044576004/07/202510004921191990000042N0tax_chandra0100032024/192120144000894604/04/2025?????Single BenchS-B- Camp Jaipur1867990000044576004/07/202510004921191990000042N0tax_chandra Executing Savedata webservice ----------------------------- Received JSON : {"savedata":{"axpapp":"gcms","username":"mobileuser","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"tscmh","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"c_code":"10003","bench_type":"1867990000044","bench_name":"5760","prehear_date":"04/04/2025"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"court_code":"10003","case_no":"2010/966","trn_tax_caseid":"765644","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"30/05/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"002","text":"0","columns":{"court_code":"10003","case_no":"2010/967","trn_tax_caseid":"765645","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"30/05/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"003","text":"0","columns":{"court_code":"10003","case_no":"2010/1112","trn_tax_caseid":"765790","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"004","text":"0","columns":{"court_code":"10003","case_no":"2010/2519","trn_tax_caseid":"767197","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"005","text":"0","columns":{"court_code":"10003","case_no":"2010/2520","trn_tax_caseid":"767198","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"006","text":"0","columns":{"court_code":"10003","case_no":"2012/1187","trn_tax_caseid":"771550","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"007","text":"0","columns":{"court_code":"10003","case_no":"2012/2786","trn_tax_caseid":"773149","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"008","text":"0","columns":{"court_code":"10003","case_no":"2014/873","trn_tax_caseid":"776493","pre_hear_date":"04/04/2025","case_purpose_name":"?????","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"1000492","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"009","text":"0","columns":{"court_code":"10003","case_no":"2014/906","trn_tax_caseid":"776526","pre_hear_date":"04/04/2025","case_purpose_name":"?????","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"1000492","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0010","text":"0","columns":{"court_code":"10003","case_no":"2014/1893","trn_tax_caseid":"777513","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0011","text":"0","columns":{"court_code":"10003","case_no":"2014/2234","trn_tax_caseid":"777854","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0012","text":"0","columns":{"court_code":"10003","case_no":"2014/2238","trn_tax_caseid":"777858","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0013","text":"0","columns":{"court_code":"10003","case_no":"2014/2239","trn_tax_caseid":"777859","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0014","text":"0","columns":{"court_code":"10003","case_no":"2014/2419","trn_tax_caseid":"778039","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0015","text":"0","columns":{"court_code":"10003","case_no":"2016/575","trn_tax_caseid":"781204","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0016","text":"0","columns":{"court_code":"10003","case_no":"2016/1005","trn_tax_caseid":"781634","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0017","text":"0","columns":{"court_code":"10003","case_no":"2016/2928","trn_tax_caseid":"783557","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"02/02/2017","stay_amount":"74860","puname":"tax_chandra"}},{"rowno":"0018","text":"0","columns":{"court_code":"10003","case_no":"2016/2929","trn_tax_caseid":"783558","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"02/02/2017","stay_amount":"132840","puname":"tax_chandra"}},{"rowno":"0019","text":"0","columns":{"court_code":"10003","case_no":"2017/2019","trn_tax_caseid":"785595","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0020","text":"0","columns":{"court_code":"10003","case_no":"2018/831","trn_tax_caseid":"786493","pre_hear_date":"04/04/2025","case_purpose_name":"??? (?????)","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"18/07/2025","new_case_purpose":"1099990000105","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0021","text":"0","columns":{"court_code":"10003","case_no":"2018/1030","trn_tax_caseid":"786692","pre_hear_date":"04/04/2025","case_purpose_name":"??? (?????)","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"18/07/2025","new_case_purpose":"1099990000105","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0022","text":"0","columns":{"court_code":"10003","case_no":"2018/1380","trn_tax_caseid":"787042","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0023","text":"0","columns":{"court_code":"10003","case_no":"2018/1381","trn_tax_caseid":"787043","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0024","text":"0","columns":{"court_code":"10003","case_no":"2019/328","trn_tax_caseid":"1016990000103","pre_hear_date":"04/04/2025","case_purpose_name":"??? (?????)","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"1099990000105","casestatus":"1191990000042","supplimentry":"N","stay_date":"27/05/2019","stay_amount":"783494","puname":"tax_chandra"}},{"rowno":"0025","text":"0","columns":{"court_code":"10003","case_no":"2019/883","trn_tax_caseid":"1989660000139","pre_hear_date":"04/04/2025","case_purpose_name":"??? ??????","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"1837220000063","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0026","text":"0","columns":{"court_code":"10003","case_no":"2019/1345","trn_tax_caseid":"1034990000148","pre_hear_date":"04/04/2025","case_purpose_name":"???????","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"1407330000044","casestatus":"1191990000042","supplimentry":"N","stay_date":"15/11/2019","stay_amount":"76883","puname":"tax_chandra"}},{"rowno":"0027","text":"0","columns":{"court_code":"10003","case_no":"2024/84","trn_tax_caseid":"1080220009166","pre_hear_date":"04/04/2025","case_purpose_name":"???","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"30/05/2025","new_case_purpose":"18473000000000","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0028","text":"0","columns":{"court_code":"10003","case_no":"2024/190","trn_tax_caseid":"1173330009215","pre_hear_date":"04/04/2025","case_purpose_name":"?????","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"1000492","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0029","text":"0","columns":{"court_code":"10003","case_no":"2024/191","trn_tax_caseid":"1193220009661","pre_hear_date":"04/04/2025","case_purpose_name":"?????","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"1000492","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}},{"rowno":"0030","text":"0","columns":{"court_code":"10003","case_no":"2024/192","trn_tax_caseid":"1201440008946","pre_hear_date":"04/04/2025","case_purpose_name":"?????","pre_bench_type":"Single Bench","pre_bench_name":"S-B- Camp Jaipur","new_benchtype":"1867990000044","new_benchname":"5760","next_hear_date":"04/07/2025","new_case_purpose":"1000492","casestatus":"1191990000042","supplimentry":"N","stay_date":"","stay_amount":"0","puname":"tax_chandra"}}]}]}} Verifying username and password User Name : mobileuser Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app' U=mobileuser Time elapsed = 39 Password checking along with max.no of login specified in app.xml update axusers set logintry = 0 where lower(username) = :U Time elapsed = 16 Result : Verifying completed... Page Access Category : User Name : mobileuser Select sysdate as sdt from dual Time elapsed = 13 dt=04/04/2025 12:51:54 Select sysdate as sdt from dual Time elapsed = 12 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=mobileuser dt=04/04/2025 12:51:54 dt=04/04/2025 12:51:54 Time elapsed = 48 User Groups: mobileuser select userroles from axusergroups where groupname in ( 'mobileuser' ) Time elapsed = 11 User Roles : mobileuser 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 = 15 Step4 axprops\stm size:4235 Step4-123456 images\Generalized Court Management SystemINRF500250000F00000F 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=mobileuser select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=mobileuser Time elapsed = 23 Result of firesql = Result = Evaluating sqlget({m2},{court_name}) Calling function sqlget Result of sqlget = ??????????? ???????? ????????? ???? ????? (AB-MGRSBY),HO Result = ??????????? ???????? ????????? ???? ????? (AB-MGRSBY),HO Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1}) Calling function firesql username=mobileuser select a.court_type from v_axcourts a where a.paxusername= :username order by 1 username=mobileuser Time elapsed = 18 Result of firesql = Result = Evaluating sqlget({m3},{court_type}) Calling function sqlget Result of sqlget = AB-MGRSBY Result = AB-MGRSBY Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1}) Calling function firesql username=mobileuser select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1 username=mobileuser Time elapsed = 21 Result of firesql = Result = Evaluating sqlget({m4},{court_name_mastid}) Calling function sqlget Result of sqlget = 1245660000858 Result = 1245660000858 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=mobileuser Time elapsed = 30 Result of firesql = Result = Evaluating sqlget({m4},{axusersid}) Calling function sqlget Result of sqlget = 11748000000124 Result = 11748000000124 Evaluating firesql({m4},{select :username as uname from dual}) Calling function firesql select :username as uname from dual username=mobileuser Time elapsed = 20 Result of firesql = Result = Evaluating sqlget({m4},{uname}) Calling function sqlget Result of sqlget = mobileuser Result = mobileuser 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=mobileuser Time elapsed = 22 Result of firesql = Result = Evaluating sqlget({m4},{COURT_CODE}) Calling function sqlget Result of sqlget = 10001 Result = 10001 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 = 12 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=mobileuser SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=mobileuser Time elapsed = 27 Result of firesql = Result = Evaluating sqlget({m7},{DISTNAMEENG}) Calling function sqlget Result of sqlget = Na Result = Na Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=mobileuser SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=mobileuser Time elapsed = 24 Result of firesql = Result = Evaluating sqlget({m8},{COURT_CATEGOTY}) Calling function sqlget Result of sqlget = 1319880000000 Result = 1319880000000 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=11748000000124 select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid login_userid=11748000000124 Time elapsed = 21 Result of firesql = Result = Evaluating sqlget({m4},{department_mastid}) Calling function sqlget Result of sqlget = Result = 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=mobileuser Time elapsed = 23 Result of firesql = Result = Evaluating sqlget({m3},{court_type_mastid}) Calling function sqlget Result of sqlget = 1245550000689 Result = 1245550000689 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=mobileuser 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=mobileuser Time elapsed = 22 Result of firesql = Result = Evaluating sqlget({m4},{groupname}) Calling function sqlget Result of sqlget = Result = 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 = 19 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=mobileuser 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=mobileuser Time elapsed = 36 Result of firesql = Result = Evaluating sqlget({P1},{ct}) Calling function sqlget Result of sqlget = 0 Result = 0 3 completed LoadAppVars Password validation done successfully select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('mobileuser') and lower(sname)='tscmh' and stype = 't' ) Time elapsed = 43 select Props from axuseraccess where lower(rname)='mobileuser' and lower(sname)='tscmh' and stype = 't' Time elapsed = 24 Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno Paramval : mobileuser,tscmh,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 = 11 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 : tscmh ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 17 Step4 tstructs\stm size:4232 Step4-0 Step4-1 Step4-2 Step4-3 Step4-4 Step5 Step6 Step9 Evaluating date() Result = Evaluating m_courtname Result = Evaluating {N} Result = Evaluating c_code Result = Evaluating nxthear_date Result = Evaluating case_purpose_name Result = select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout) tid=tscmh adxinout=o Time elapsed = 35 select * from TRN_TAX_MHEARING where TRN_TAX_MHEARINGid=0 Time elapsed = 30 select * from Axusers where 1=2 Time elapsed = 17 select distinct(fldname) from AxTempUserFields Time elapsed = 14 select * from AxAttachWorkflow where lower(transid) = 'tscmh' Time elapsed = 24 Loading genmaps Creating Action object Submitting data to dbcall Submiting & Registering data Registering Global variables data Registering Global variables data over Setting values over DB Call Validate and save >>Validating tscmh >>Frame No 1 currdate = Evaluating - date() Result of date = 04/04/2025 currdate after validation = 04/04/2025 sourceid = court_name = username=mobileuser SELECT c.court_name_mastid, c.court_name, c.court_code, b.court_type_mastid, b.court_type, b.hierarchy_level, c.district_name, c.division_name, c.tehsil_name,c.sdo_name FROM court_name_mast c, axcourts a, court_type_mast b WHERE a.court_name = c.court_name_mastid AND c.court_type = b.court_type_mastid AND a.court_name != 1 AND a.paxusername = :username UNION SELECT c.court_name_mastid, c.court_name, c.court_code, b.court_type_mastid, b.court_type, b.hierarchy_level, c.district_name, c.division_name, c.tehsil_name,c.sdo_name FROM court_name_mast c, axcourts a, court_type_mast b WHERE a.court_name = 1 AND c.court_type = b.court_type_mastid AND c.court_name_mastid != 1 AND a.paxusername = :username ORDER BY 2, 3 username=mobileuser username=mobileuser Time elapsed = 28 Evaluating - m_courtname m_courtname = ??????????? ???????? ????????? ???? ????? (AB-MGRSBY),HO court_name after validation = ??????????? ???????? ????????? ???? ????? (AB-MGRSBY),HO Id = 1245660000858 c_code = 10003 Finding linkfield in fieldenter function Linkfield found and assigning Query from link field in fieldenter function Query assigned in fieldenter function c_code after validation = 10001 bench_type = 1867990000044 bench_typeid = bench_name = 5760 bench_nameid = s_supplimentry = Evaluating - {N} s_supplimentry after validation = N prehear_date = 04/04/2025 cases = mcases = nw_btype = nbt = nw_bname = nw_bntype = nxthear_date = time zone difference = 0 >>Writing to tables tscmh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'tscmh' Time elapsed = 13 Saving to table TRN_TAX_MHEARING select * from TRN_TAX_MHEARING where TRN_TAX_MHEARINGid=0 Time elapsed = 15 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 14 RecordId = 12577000010024 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 13 Select sysdate as sdt from dual Time elapsed = 13 prehear_date = 04/04/2025 nxthear_date = sourceid = 0 c_code = 10001 bench_type = 1867990000044 bench_name = 5760 Posting record Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:51:57 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:51:57 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prehear_date=04/04/2025 00:00:00 Param Type = c c_code=10001 Param Type = c bench_type=1867990000044 Param Type = c bench_name=5760 insert into TRN_TAX_MHEARING (trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prehear_date,nxthear_date,c_code,bench_type,bench_name) values (:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prehear_date,'dd/mm/yyyy hh24:mi:ss'),null,:c_code,:bench_type,:bench_name) Saving to table TRN_TAX_HEARING select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 255 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 = 14 RecordId = 12577000010025 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 11 Select sysdate as sdt from dual Time elapsed = 14 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2010/966 trn_tax_caseid = 765644 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 18473000000000 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 30/05/2025 TRN_TAX_HEARINGrow = 1 Posting record Param Type = n trn_tax_hearingid=12577000010025 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:51:58 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:51:58 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2010/966 Param Type = c trn_tax_caseid=765644 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=18473000000000 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=30/05/2025 00:00:00 Param Type = n trn_tax_hearingrow=1 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 180 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 = 13 RecordId = 12577000010026 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 16 Select sysdate as sdt from dual Time elapsed = 15 puname = tax_chandra stay_amount = 0 new_benchname = 5760 new_benchtype = 1867990000044 pre_bench_name = S-B- Camp Jaipur next_hear_date = 30/05/2025 supplimentry = N casestatus = 1191990000042 new_case_purpose = 18473000000000 case_no = 2010/967 court_code = 10003 stay_date = trn_tax_caseid = 765645 pre_bench_type = Single Bench case_purpose_name = ??? pre_hear_date = 04/04/2025 TRN_TAX_HEARINGrow = 2 Posting record Param Type = n trn_tax_hearingid=12577000010026 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:51:59 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:51:59 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c new_benchname=5760 Param Type = c new_benchtype=1867990000044 Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c next_hear_date=30/05/2025 00:00:00 Param Type = c supplimentry=N Param Type = c casestatus=1191990000042 Param Type = c new_case_purpose=18473000000000 Param Type = c case_no=2010/967 Param Type = c court_code=10003 Param Type = c trn_tax_caseid=765645 Param Type = c pre_bench_type=Single Bench Param Type = c case_purpose_name=??? Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = n trn_tax_hearingrow=2 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,new_benchname,new_benchtype,pre_bench_name,next_hear_date,supplimentry,casestatus,new_case_purpose,case_no,court_code,stay_date,trn_tax_caseid,pre_bench_type,case_purpose_name,pre_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:new_benchname,:new_benchtype,:pre_bench_name,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:supplimentry,:casestatus,:new_case_purpose,:case_no,:court_code,null,:trn_tax_caseid,:pre_bench_type,:case_purpose_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 191 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 = 13 RecordId = 12577000010027 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 16 Select sysdate as sdt from dual Time elapsed = 13 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2010/1112 trn_tax_caseid = 765790 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 18473000000000 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 3 Posting record Param Type = n trn_tax_hearingid=12577000010027 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:00 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:00 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2010/1112 Param Type = c trn_tax_caseid=765790 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=18473000000000 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=3 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 179 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 = 14 RecordId = 12577000010028 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 14 Select sysdate as sdt from dual Time elapsed = 18 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2010/2519 trn_tax_caseid = 767197 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 18473000000000 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 4 Posting record Param Type = n trn_tax_hearingid=12577000010028 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:01 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:01 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2010/2519 Param Type = c trn_tax_caseid=767197 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=18473000000000 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=4 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 149 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 = 14 RecordId = 12577000010029 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 17 Select sysdate as sdt from dual Time elapsed = 14 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2010/2520 trn_tax_caseid = 767198 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 18473000000000 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 5 Posting record Param Type = n trn_tax_hearingid=12577000010029 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:02 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:02 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2010/2520 Param Type = c trn_tax_caseid=767198 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=18473000000000 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=5 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 184 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 = 16 RecordId = 12577000010030 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 14 Select sysdate as sdt from dual Time elapsed = 17 puname = tax_chandra stay_amount = 0 new_benchname = 5760 new_benchtype = 1867990000044 pre_bench_name = S-B- Camp Jaipur next_hear_date = 04/07/2025 supplimentry = N casestatus = 1191990000042 new_case_purpose = 18473000000000 case_no = 2012/1187 court_code = 10003 stay_date = trn_tax_caseid = 771550 pre_bench_type = Single Bench case_purpose_name = ??? pre_hear_date = 04/04/2025 TRN_TAX_HEARINGrow = 6 Posting record Param Type = n trn_tax_hearingid=12577000010030 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:03 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:03 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c new_benchname=5760 Param Type = c new_benchtype=1867990000044 Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = c supplimentry=N Param Type = c casestatus=1191990000042 Param Type = c new_case_purpose=18473000000000 Param Type = c case_no=2012/1187 Param Type = c court_code=10003 Param Type = c trn_tax_caseid=771550 Param Type = c pre_bench_type=Single Bench Param Type = c case_purpose_name=??? Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = n trn_tax_hearingrow=6 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,new_benchname,new_benchtype,pre_bench_name,next_hear_date,supplimentry,casestatus,new_case_purpose,case_no,court_code,stay_date,trn_tax_caseid,pre_bench_type,case_purpose_name,pre_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:new_benchname,:new_benchtype,:pre_bench_name,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:supplimentry,:casestatus,:new_case_purpose,:case_no,:court_code,null,:trn_tax_caseid,:pre_bench_type,:case_purpose_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 168 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 = 14 RecordId = 12577000010031 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 9 Select sysdate as sdt from dual Time elapsed = 15 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2012/2786 trn_tax_caseid = 773149 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 18473000000000 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 7 Posting record Param Type = n trn_tax_hearingid=12577000010031 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:04 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:04 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2012/2786 Param Type = c trn_tax_caseid=773149 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=18473000000000 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=7 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 151 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 = 14 RecordId = 12577000010032 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 13 Select sysdate as sdt from dual Time elapsed = 21 puname = tax_chandra stay_amount = 0 new_benchname = 5760 new_benchtype = 1867990000044 pre_bench_name = S-B- Camp Jaipur next_hear_date = 04/07/2025 supplimentry = N casestatus = 1191990000042 new_case_purpose = 1000492 case_no = 2014/873 court_code = 10003 stay_date = trn_tax_caseid = 776493 pre_bench_type = Single Bench case_purpose_name = ????? pre_hear_date = 04/04/2025 TRN_TAX_HEARINGrow = 8 Posting record Param Type = n trn_tax_hearingid=12577000010032 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:05 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:05 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c new_benchname=5760 Param Type = c new_benchtype=1867990000044 Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = c supplimentry=N Param Type = c casestatus=1191990000042 Param Type = c new_case_purpose=1000492 Param Type = c case_no=2014/873 Param Type = c court_code=10003 Param Type = c trn_tax_caseid=776493 Param Type = c pre_bench_type=Single Bench Param Type = c case_purpose_name=????? Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = n trn_tax_hearingrow=8 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,new_benchname,new_benchtype,pre_bench_name,next_hear_date,supplimentry,casestatus,new_case_purpose,case_no,court_code,stay_date,trn_tax_caseid,pre_bench_type,case_purpose_name,pre_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:new_benchname,:new_benchtype,:pre_bench_name,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:supplimentry,:casestatus,:new_case_purpose,:case_no,:court_code,null,:trn_tax_caseid,:pre_bench_type,:case_purpose_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 173 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 = 14 RecordId = 12577000010033 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 15 Select sysdate as sdt from dual Time elapsed = 14 puname = tax_chandra stay_amount = 0 case_purpose_name = ????? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2014/906 trn_tax_caseid = 776526 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 1000492 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 9 Posting record Param Type = n trn_tax_hearingid=12577000010033 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:06 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:06 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=????? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2014/906 Param Type = c trn_tax_caseid=776526 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=1000492 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=9 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 178 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 = 16 RecordId = 12577000010034 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 11 Select sysdate as sdt from dual Time elapsed = 11 puname = tax_chandra stay_amount = 0 new_benchname = 5760 new_benchtype = 1867990000044 pre_bench_name = S-B- Camp Jaipur next_hear_date = 04/07/2025 supplimentry = N casestatus = 1191990000042 new_case_purpose = 18473000000000 case_no = 2014/1893 court_code = 10003 stay_date = trn_tax_caseid = 777513 pre_bench_type = Single Bench case_purpose_name = ??? pre_hear_date = 04/04/2025 TRN_TAX_HEARINGrow = 10 Posting record Param Type = n trn_tax_hearingid=12577000010034 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:07 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c new_benchname=5760 Param Type = c new_benchtype=1867990000044 Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = c supplimentry=N Param Type = c casestatus=1191990000042 Param Type = c new_case_purpose=18473000000000 Param Type = c case_no=2014/1893 Param Type = c court_code=10003 Param Type = c trn_tax_caseid=777513 Param Type = c pre_bench_type=Single Bench Param Type = c case_purpose_name=??? Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = n trn_tax_hearingrow=10 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,new_benchname,new_benchtype,pre_bench_name,next_hear_date,supplimentry,casestatus,new_case_purpose,case_no,court_code,stay_date,trn_tax_caseid,pre_bench_type,case_purpose_name,pre_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:new_benchname,:new_benchtype,:pre_bench_name,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:supplimentry,:casestatus,:new_case_purpose,:case_no,:court_code,null,:trn_tax_caseid,:pre_bench_type,:case_purpose_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 166 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 = 15 RecordId = 12577000010035 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 14 Select sysdate as sdt from dual Time elapsed = 19 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2014/2234 trn_tax_caseid = 777854 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 18473000000000 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 11 Posting record Param Type = n trn_tax_hearingid=12577000010035 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:07 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2014/2234 Param Type = c trn_tax_caseid=777854 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=18473000000000 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=11 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 159 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 = 13 RecordId = 12577000010036 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 15 Select sysdate as sdt from dual Time elapsed = 14 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2014/2238 trn_tax_caseid = 777858 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 18473000000000 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 12 Posting record Param Type = n trn_tax_hearingid=12577000010036 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:09 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:09 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2014/2238 Param Type = c trn_tax_caseid=777858 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=18473000000000 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=12 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 153 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 = 12 RecordId = 12577000010037 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 14 Select sysdate as sdt from dual Time elapsed = 17 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2014/2239 trn_tax_caseid = 777859 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 18473000000000 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 13 Posting record Param Type = n trn_tax_hearingid=12577000010037 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:09 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:10 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2014/2239 Param Type = c trn_tax_caseid=777859 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=18473000000000 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=13 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 225 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 = 12 RecordId = 12577000010038 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 35 Select sysdate as sdt from dual Time elapsed = 15 puname = tax_chandra stay_amount = 0 new_benchname = 5760 new_benchtype = 1867990000044 pre_bench_name = S-B- Camp Jaipur next_hear_date = 04/07/2025 supplimentry = N casestatus = 1191990000042 new_case_purpose = 18473000000000 case_no = 2014/2419 court_code = 10003 stay_date = trn_tax_caseid = 778039 pre_bench_type = Single Bench case_purpose_name = ??? pre_hear_date = 04/04/2025 TRN_TAX_HEARINGrow = 14 Posting record Param Type = n trn_tax_hearingid=12577000010038 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:11 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:11 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c new_benchname=5760 Param Type = c new_benchtype=1867990000044 Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = c supplimentry=N Param Type = c casestatus=1191990000042 Param Type = c new_case_purpose=18473000000000 Param Type = c case_no=2014/2419 Param Type = c court_code=10003 Param Type = c trn_tax_caseid=778039 Param Type = c pre_bench_type=Single Bench Param Type = c case_purpose_name=??? Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = n trn_tax_hearingrow=14 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,new_benchname,new_benchtype,pre_bench_name,next_hear_date,supplimentry,casestatus,new_case_purpose,case_no,court_code,stay_date,trn_tax_caseid,pre_bench_type,case_purpose_name,pre_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:new_benchname,:new_benchtype,:pre_bench_name,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:supplimentry,:casestatus,:new_case_purpose,:case_no,:court_code,null,:trn_tax_caseid,:pre_bench_type,:case_purpose_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 177 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 = 11 RecordId = 12577000010039 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 12 Select sysdate as sdt from dual Time elapsed = 20 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2016/575 trn_tax_caseid = 781204 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 18473000000000 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 15 Posting record Param Type = n trn_tax_hearingid=12577000010039 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:12 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:12 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2016/575 Param Type = c trn_tax_caseid=781204 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=18473000000000 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=15 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 186 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 = 16 RecordId = 12577000010040 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 17 Select sysdate as sdt from dual Time elapsed = 13 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2016/1005 trn_tax_caseid = 781634 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 18473000000000 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 16 Posting record Param Type = n trn_tax_hearingid=12577000010040 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:13 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:13 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2016/1005 Param Type = c trn_tax_caseid=781634 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=18473000000000 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=16 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 171 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 = 10 RecordId = 12577000010041 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 14 Select sysdate as sdt from dual Time elapsed = 14 puname = tax_chandra stay_amount = 74860 case_purpose_name = ??? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2016/2928 trn_tax_caseid = 783557 casestatus = 1191990000042 supplimentry = N stay_date = 02/02/2017 new_case_purpose = 18473000000000 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 17 Posting record Param Type = n trn_tax_hearingid=12577000010041 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:14 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:14 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=74860 Param Type = c case_purpose_name=??? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2016/2928 Param Type = c trn_tax_caseid=783557 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c stay_date=02/02/2017 00:00:00 Param Type = c new_case_purpose=18473000000000 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=17 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,to_date(:stay_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 158 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 = 16 RecordId = 12577000010042 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 15 Select sysdate as sdt from dual Time elapsed = 13 puname = tax_chandra stay_amount = 132840 new_benchname = 5760 new_benchtype = 1867990000044 pre_bench_name = S-B- Camp Jaipur next_hear_date = 04/07/2025 supplimentry = N casestatus = 1191990000042 new_case_purpose = 18473000000000 case_no = 2016/2929 court_code = 10003 stay_date = 02/02/2017 trn_tax_caseid = 783558 pre_bench_type = Single Bench case_purpose_name = ??? pre_hear_date = 04/04/2025 TRN_TAX_HEARINGrow = 18 Posting record Param Type = n trn_tax_hearingid=12577000010042 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:15 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:15 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=132840 Param Type = c new_benchname=5760 Param Type = c new_benchtype=1867990000044 Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = c supplimentry=N Param Type = c casestatus=1191990000042 Param Type = c new_case_purpose=18473000000000 Param Type = c case_no=2016/2929 Param Type = c court_code=10003 Param Type = c stay_date=02/02/2017 00:00:00 Param Type = c trn_tax_caseid=783558 Param Type = c pre_bench_type=Single Bench Param Type = c case_purpose_name=??? Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = n trn_tax_hearingrow=18 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,new_benchname,new_benchtype,pre_bench_name,next_hear_date,supplimentry,casestatus,new_case_purpose,case_no,court_code,stay_date,trn_tax_caseid,pre_bench_type,case_purpose_name,pre_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:new_benchname,:new_benchtype,:pre_bench_name,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:supplimentry,:casestatus,:new_case_purpose,:case_no,:court_code,to_date(:stay_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_caseid,:pre_bench_type,:case_purpose_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 155 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 = 12 RecordId = 12577000010043 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 14 Select sysdate as sdt from dual Time elapsed = 19 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2017/2019 trn_tax_caseid = 785595 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 18473000000000 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 19 Posting record Param Type = n trn_tax_hearingid=12577000010043 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:16 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:16 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2017/2019 Param Type = c trn_tax_caseid=785595 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=18473000000000 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=19 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 152 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 = 12 RecordId = 12577000010044 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 13 Select sysdate as sdt from dual Time elapsed = 18 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? (?????) pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2018/831 trn_tax_caseid = 786493 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 1099990000105 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 18/07/2025 TRN_TAX_HEARINGrow = 20 Posting record Param Type = n trn_tax_hearingid=12577000010044 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:17 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? (?????) Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2018/831 Param Type = c trn_tax_caseid=786493 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=1099990000105 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=18/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=20 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 171 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 = 17 RecordId = 12577000010045 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 14 Select sysdate as sdt from dual Time elapsed = 15 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? (?????) pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2018/1030 trn_tax_caseid = 786692 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 1099990000105 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 18/07/2025 TRN_TAX_HEARINGrow = 21 Posting record Param Type = n trn_tax_hearingid=12577000010045 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:18 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? (?????) Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2018/1030 Param Type = c trn_tax_caseid=786692 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=1099990000105 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=18/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=21 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 153 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 = 12 RecordId = 12577000010046 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 15 Select sysdate as sdt from dual Time elapsed = 13 puname = tax_chandra stay_amount = 0 new_benchname = 5760 new_benchtype = 1867990000044 pre_bench_name = S-B- Camp Jaipur next_hear_date = 04/07/2025 supplimentry = N casestatus = 1191990000042 new_case_purpose = 18473000000000 case_no = 2018/1380 court_code = 10003 stay_date = trn_tax_caseid = 787042 pre_bench_type = Single Bench case_purpose_name = ??? pre_hear_date = 04/04/2025 TRN_TAX_HEARINGrow = 22 Posting record Param Type = n trn_tax_hearingid=12577000010046 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:19 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:19 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c new_benchname=5760 Param Type = c new_benchtype=1867990000044 Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = c supplimentry=N Param Type = c casestatus=1191990000042 Param Type = c new_case_purpose=18473000000000 Param Type = c case_no=2018/1380 Param Type = c court_code=10003 Param Type = c trn_tax_caseid=787042 Param Type = c pre_bench_type=Single Bench Param Type = c case_purpose_name=??? Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = n trn_tax_hearingrow=22 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,new_benchname,new_benchtype,pre_bench_name,next_hear_date,supplimentry,casestatus,new_case_purpose,case_no,court_code,stay_date,trn_tax_caseid,pre_bench_type,case_purpose_name,pre_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:new_benchname,:new_benchtype,:pre_bench_name,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:supplimentry,:casestatus,:new_case_purpose,:case_no,:court_code,null,:trn_tax_caseid,:pre_bench_type,:case_purpose_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 190 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 = 13 RecordId = 12577000010047 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 11 Select sysdate as sdt from dual Time elapsed = 16 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2018/1381 trn_tax_caseid = 787043 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 18473000000000 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 23 Posting record Param Type = n trn_tax_hearingid=12577000010047 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:19 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:19 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2018/1381 Param Type = c trn_tax_caseid=787043 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=18473000000000 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=23 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 157 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 = 14 RecordId = 12577000010048 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 18 Select sysdate as sdt from dual Time elapsed = 12 puname = tax_chandra stay_amount = 783494 new_benchname = 5760 new_benchtype = 1867990000044 pre_bench_name = S-B- Camp Jaipur next_hear_date = 04/07/2025 supplimentry = N casestatus = 1191990000042 new_case_purpose = 1099990000105 case_no = 2019/328 court_code = 10003 stay_date = 27/05/2019 trn_tax_caseid = 1016990000103 pre_bench_type = Single Bench case_purpose_name = ??? (?????) pre_hear_date = 04/04/2025 TRN_TAX_HEARINGrow = 24 Posting record Param Type = n trn_tax_hearingid=12577000010048 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:20 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:20 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=783494 Param Type = c new_benchname=5760 Param Type = c new_benchtype=1867990000044 Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = c supplimentry=N Param Type = c casestatus=1191990000042 Param Type = c new_case_purpose=1099990000105 Param Type = c case_no=2019/328 Param Type = c court_code=10003 Param Type = c stay_date=27/05/2019 00:00:00 Param Type = c trn_tax_caseid=1016990000103 Param Type = c pre_bench_type=Single Bench Param Type = c case_purpose_name=??? (?????) Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = n trn_tax_hearingrow=24 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,new_benchname,new_benchtype,pre_bench_name,next_hear_date,supplimentry,casestatus,new_case_purpose,case_no,court_code,stay_date,trn_tax_caseid,pre_bench_type,case_purpose_name,pre_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:new_benchname,:new_benchtype,:pre_bench_name,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:supplimentry,:casestatus,:new_case_purpose,:case_no,:court_code,to_date(:stay_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_caseid,:pre_bench_type,:case_purpose_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 155 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 = 15 RecordId = 12577000010049 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 15 Select sysdate as sdt from dual Time elapsed = 14 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? ?????? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2019/883 trn_tax_caseid = 1989660000139 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 1837220000063 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 25 Posting record Param Type = n trn_tax_hearingid=12577000010049 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:21 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:21 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? ?????? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2019/883 Param Type = c trn_tax_caseid=1989660000139 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=1837220000063 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=25 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 171 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 = 14 RecordId = 12577000010050 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 18 Select sysdate as sdt from dual Time elapsed = 15 puname = tax_chandra stay_amount = 76883 new_benchname = 5760 new_benchtype = 1867990000044 pre_bench_name = S-B- Camp Jaipur next_hear_date = 04/07/2025 supplimentry = N casestatus = 1191990000042 new_case_purpose = 1407330000044 case_no = 2019/1345 court_code = 10003 stay_date = 15/11/2019 trn_tax_caseid = 1034990000148 pre_bench_type = Single Bench case_purpose_name = ??????? pre_hear_date = 04/04/2025 TRN_TAX_HEARINGrow = 26 Posting record Param Type = n trn_tax_hearingid=12577000010050 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:22 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:22 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=76883 Param Type = c new_benchname=5760 Param Type = c new_benchtype=1867990000044 Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = c supplimentry=N Param Type = c casestatus=1191990000042 Param Type = c new_case_purpose=1407330000044 Param Type = c case_no=2019/1345 Param Type = c court_code=10003 Param Type = c stay_date=15/11/2019 00:00:00 Param Type = c trn_tax_caseid=1034990000148 Param Type = c pre_bench_type=Single Bench Param Type = c case_purpose_name=??????? Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = n trn_tax_hearingrow=26 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,new_benchname,new_benchtype,pre_bench_name,next_hear_date,supplimentry,casestatus,new_case_purpose,case_no,court_code,stay_date,trn_tax_caseid,pre_bench_type,case_purpose_name,pre_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:new_benchname,:new_benchtype,:pre_bench_name,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:supplimentry,:casestatus,:new_case_purpose,:case_no,:court_code,to_date(:stay_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_caseid,:pre_bench_type,:case_purpose_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 162 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 = 13 RecordId = 12577000010051 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 15 Select sysdate as sdt from dual Time elapsed = 14 puname = tax_chandra stay_amount = 0 case_purpose_name = ??? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2024/84 trn_tax_caseid = 1080220009166 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 18473000000000 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 30/05/2025 TRN_TAX_HEARINGrow = 27 Posting record Param Type = n trn_tax_hearingid=12577000010051 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:23 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:23 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=??? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2024/84 Param Type = c trn_tax_caseid=1080220009166 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=18473000000000 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=30/05/2025 00:00:00 Param Type = n trn_tax_hearingrow=27 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 202 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 = 13 RecordId = 12577000010052 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 15 Select sysdate as sdt from dual Time elapsed = 15 puname = tax_chandra stay_amount = 0 case_purpose_name = ????? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2024/190 trn_tax_caseid = 1173330009215 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 1000492 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 28 Posting record Param Type = n trn_tax_hearingid=12577000010052 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:24 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:24 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=????? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2024/190 Param Type = c trn_tax_caseid=1173330009215 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=1000492 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=28 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 163 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 = 16 RecordId = 12577000010053 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 19 Select sysdate as sdt from dual Time elapsed = 30 puname = tax_chandra stay_amount = 0 case_purpose_name = ????? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2024/191 trn_tax_caseid = 1193220009661 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 1000492 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 29 Posting record Param Type = n trn_tax_hearingid=12577000010053 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:25 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:25 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=????? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2024/191 Param Type = c trn_tax_caseid=1193220009661 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=1000492 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=29 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) select * from TRN_TAX_HEARING where TRN_TAX_HEARINGid=0 Time elapsed = 177 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 = 22 RecordId = 12577000010054 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 11 Select sysdate as sdt from dual Time elapsed = 11 puname = tax_chandra stay_amount = 0 case_purpose_name = ????? pre_bench_type = Single Bench pre_bench_name = S-B- Camp Jaipur pre_hear_date = 04/04/2025 court_code = 10003 case_no = 2024/192 trn_tax_caseid = 1201440008946 casestatus = 1191990000042 supplimentry = N stay_date = new_case_purpose = 1000492 new_benchtype = 1867990000044 new_benchname = 5760 next_hear_date = 04/07/2025 TRN_TAX_HEARINGrow = 30 Posting record Param Type = n trn_tax_hearingid=12577000010054 Param Type = n trn_tax_mhearingid=12577000010024 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=mobileuser Param Type = c createdon=04/04/2025 12:52:26 Param Type = c username=mobileuser Param Type = c modifiedon=04/04/2025 12:52:26 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=tax_chandra Param Type = n stay_amount=0 Param Type = c case_purpose_name=????? Param Type = c pre_bench_type=Single Bench Param Type = c pre_bench_name=S-B- Camp Jaipur Param Type = c pre_hear_date=04/04/2025 00:00:00 Param Type = c court_code=10003 Param Type = c case_no=2024/192 Param Type = c trn_tax_caseid=1201440008946 Param Type = c casestatus=1191990000042 Param Type = c supplimentry=N Param Type = c new_case_purpose=1000492 Param Type = c new_benchtype=1867990000044 Param Type = c new_benchname=5760 Param Type = c next_hear_date=04/07/2025 00:00:00 Param Type = n trn_tax_hearingrow=30 insert into TRN_TAX_HEARING (trn_tax_hearingid,trn_tax_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,puname,stay_amount,case_purpose_name,pre_bench_type,pre_bench_name,pre_hear_date,court_code,case_no,trn_tax_caseid,casestatus,supplimentry,stay_date,new_case_purpose,new_benchtype,new_benchname,next_hear_date,trn_tax_hearingrow) values (:trn_tax_hearingid,:trn_tax_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:stay_amount,:case_purpose_name,:pre_bench_type,:pre_bench_name,to_date(:pre_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:case_no,:trn_tax_caseid,:casestatus,:supplimentry,null,:new_case_purpose,:new_benchtype,:new_benchname,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_tax_hearingrow) Time elapsed for insert/update = 3952932746471 >>Executing genmaps Time elapsed for Gen Map = 3952932746489 Time elapsed for MD Map = 3952932746498 Time elapsed for Save History = 3952932746506 Time elapsed for Save Attachment = 3952932746516 Time elapsed for After Save WF Exec = 3952932746532 Transaction commited Result : {"message":[{"msg":"Tax Board Custom Multiple Hearing Saved","recordid":"12577000010024"}]} 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=mobileuser Param Type = c calledon=04/04/2025 12:51:53 Param Type = c callfinished=04/04/2025 12:52:26 Param Type = c structname=tscmh Param Type = n recordid=0 Param Type = c servicename=Saving data Param Type = c serviceresult=success Param Type = n timetaken=33595 Param Type = n dbtimetaken=23112 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