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 gcmsjainpriti827ccb0eea8a706c4c34a16891f84e7bbocup00115990000000001000608/04/2024R?????? ?????15bor2019000jainpriti1159900000000010006100062019/5132019/5131331700000290915???.20108/04/202412/08/202410189000000601201199680000005910jainpriti1159900000000010006100062019/5682019/5681326000000218515???????? ????????? ????12008/04/202423/04/202410107000000777120199730000006120jainpriti1159900000000010006100062019/6292019/6291665700000212415?????? ?????11208/04/202412/08/202410035000000979112199710000006020jainpriti1159900000000010006100062019/7232019/7231315400000233915?????? ????? ????12208/04/202412/08/202410110000000719122199710000006020jainpriti1159900000000010006100062019/13012019/13011445800000219015???.20108/04/202416/04/202410189000000601201199680000005910jainpriti1159900000000010006100062019/13672019/13671768200000237415?????? ????? ????12208/04/202412/08/202410110000000719122199710000006020jainpriti1159900000000010006100062019/21152019/21151550200000219315?????? ????? ????12208/04/202412/08/202410110000000719122199710000006020jainpriti1159900000000010006100062019/31832019/31831287300000226115???????? ????????? ????12008/04/202423/04/202410107000000777120199730000006120jainpriti1159900000000010006100062019/32352019/32351554000000300615?????? ?????11208/04/202406/05/202410035000000979112199710000006020jainpriti1159900000000010006100062019/39382019/39381851000000264115???????? ????????? ????12008/04/202406/05/202410107000000777120199730000006120jainpriti1159900000000010006100062019/39752019/39751464300000294615???????? ????????? ????12008/04/202406/05/202410107000000777120199730000006120jainpriti1159900000000010006100062019/39762019/39761472600000275215?????? ???? 11308/04/202412/08/202410037000000780113199710000006020jainpriti1159900000000010006100062019/41162019/41161121400000273715???????? ????????? ????12008/04/202429/04/202410107000000777120199730000006120jainpriti1159900000000010006100062019/41362019/41361420500000257415?????? ????? ????12208/04/202412/08/202410110000000719122199710000006020jainpriti1159900000000010006100062019/42412019/42411569800000246915?????? ?????11208/04/202412/08/202410035000000979112199710000006020jainpriti1159900000000010006100062019/42422019/42421622600000297815?????? ?????11208/04/202412/08/202410035000000979112199710000006020jainpriti1159900000000010006100062019/43752019/43751294800000289515?????? ????? ????12208/04/202412/08/202410110000000719122199710000006020jainpriti1159900000000010006100062019/45192019/45191799000000235315?????? ????? ????12208/04/202412/08/202410110000000719122199710000006020jainpriti1159900000000010006100062019/45202019/45201802900000231715?????? ????? ????12208/04/202412/08/202410110000000719122199710000006020jainpriti1159900000000010006100062019/46002019/46001230800000293615?????? ???? 11308/04/202406/05/202410037000000780113199710000006020jainpriti1159900000000010006100062019/46522019/46521807400000338515???????? ????????? ????12008/04/202406/05/202410107000000777120199730000006120jainpriti1159900000000010006100062019/46912019/46911161900000244115?????? ????? ????12208/04/202412/08/202410110000000719122199710000006020jainpriti1159900000000010006100062019/47212019/47211869600000244615???????? ????????? ????12008/04/202406/05/202410107000000777120199730000006120jainpriti1159900000000010006100062019/50462019/50461678000000278615?????? ????? ????12208/04/202412/08/202410110000000719122199710000006020jainpriti1159900000000010006100062019/51002019/51001797400000343715?????? ????? ????12208/04/202412/08/202410110000000719122199710000006020jainpriti1159900000000010006100062019/51752019/51751782100000296415???.20108/04/202406/05/202410189000000601201199680000005910jainpriti1159900000000010006100062019/52802019/52801431000000381415?????? ?????11208/04/202412/08/202410035000000979112199710000006020jainpriti1159900000000010006100062019/53672019/53671709000000294815???????? ????????? ????12008/04/202406/05/202410107000000777120199730000006120jainpriti1159900000000010006100062019/56052019/56051300300000337115?????? ????? ????12208/04/202421/05/202410110000000719122199710000006020jainpriti1159900000000010006100062019/56222019/56221550000000250415?????? ????? ????12208/04/202412/08/202410110000000719122199710000006020jainpriti1159900000000010006100062019/58902019/58901971200000324915?????? ????? ????12208/04/202412/08/202410110000000719122199710000006020jainpriti1159900000000010006100062019/64262019/64261626800000340715?????? ????? ????12208/04/202412/08/202410110000000719122199710000006020jainpriti1159900000000010006100062019/64272019/64271632400000251015?????? ????? ????12208/04/202412/08/202410110000000719122199710000006020jainpriti1159900000000010006100062019/77162019/77161922300000386915???????? ????????? ????12008/04/202429/04/202410107000000777120199730000006120jainpriti1159900000000010006100062019/78142019/78141282900000313815??????12208/04/202412/08/202400jainpriti1159900000000010006100062019/78172019/78171284600000308215??????12208/04/202412/08/20240 Executing Savedata webservice ----------------------------- Received JSON : {"savedata":{"axpapp":"gcms","username":"jainpriti","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"bocup","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtname":"11599000000000","courtcode":"10006","cldate":"08/04/2024","cltype":"R","benchname":"?????? ?????","benchcode":"15","cluser":"bor2019","bench_mem1":"0","bench_mem2":"0"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/513","case_no":"2019/513","trn_bor_caseid":"13317000002909","manual_case_no":"","bench_code":"15","prev_case_purpose":"???.","prev_purpose_code":"201","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10189000000601","new_purpose_code":"201","new_purpose_group":"19968000000591"}},{"rowno":"002","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/568","case_no":"2019/568","trn_bor_caseid":"13260000002185","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"08/04/2024","next_hear_date":"23/04/2024","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"003","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/629","case_no":"2019/629","trn_bor_caseid":"16657000002124","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ?????","prev_purpose_code":"112","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10035000000979","new_purpose_code":"112","new_purpose_group":"19971000000602"}},{"rowno":"004","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/723","case_no":"2019/723","trn_bor_caseid":"13154000002339","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"005","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/1301","case_no":"2019/1301","trn_bor_caseid":"14458000002190","manual_case_no":"","bench_code":"15","prev_case_purpose":"???.","prev_purpose_code":"201","prev_hear_date":"08/04/2024","next_hear_date":"16/04/2024","new_case_purpose":"10189000000601","new_purpose_code":"201","new_purpose_group":"19968000000591"}},{"rowno":"006","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/1367","case_no":"2019/1367","trn_bor_caseid":"17682000002374","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"007","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/2115","case_no":"2019/2115","trn_bor_caseid":"15502000002193","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"008","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/3183","case_no":"2019/3183","trn_bor_caseid":"12873000002261","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"08/04/2024","next_hear_date":"23/04/2024","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"009","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/3235","case_no":"2019/3235","trn_bor_caseid":"15540000003006","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ?????","prev_purpose_code":"112","prev_hear_date":"08/04/2024","next_hear_date":"06/05/2024","new_case_purpose":"10035000000979","new_purpose_code":"112","new_purpose_group":"19971000000602"}},{"rowno":"0010","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/3938","case_no":"2019/3938","trn_bor_caseid":"18510000002641","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"08/04/2024","next_hear_date":"06/05/2024","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"0011","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/3975","case_no":"2019/3975","trn_bor_caseid":"14643000002946","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"08/04/2024","next_hear_date":"06/05/2024","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"0012","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/3976","case_no":"2019/3976","trn_bor_caseid":"14726000002752","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ???? ","prev_purpose_code":"113","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10037000000780","new_purpose_code":"113","new_purpose_group":"19971000000602"}},{"rowno":"0013","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/4116","case_no":"2019/4116","trn_bor_caseid":"11214000002737","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"08/04/2024","next_hear_date":"29/04/2024","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"0014","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/4136","case_no":"2019/4136","trn_bor_caseid":"14205000002574","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0015","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/4241","case_no":"2019/4241","trn_bor_caseid":"15698000002469","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ?????","prev_purpose_code":"112","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10035000000979","new_purpose_code":"112","new_purpose_group":"19971000000602"}},{"rowno":"0016","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/4242","case_no":"2019/4242","trn_bor_caseid":"16226000002978","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ?????","prev_purpose_code":"112","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10035000000979","new_purpose_code":"112","new_purpose_group":"19971000000602"}},{"rowno":"0017","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/4375","case_no":"2019/4375","trn_bor_caseid":"12948000002895","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0018","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/4519","case_no":"2019/4519","trn_bor_caseid":"17990000002353","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0019","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/4520","case_no":"2019/4520","trn_bor_caseid":"18029000002317","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0020","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/4600","case_no":"2019/4600","trn_bor_caseid":"12308000002936","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ???? ","prev_purpose_code":"113","prev_hear_date":"08/04/2024","next_hear_date":"06/05/2024","new_case_purpose":"10037000000780","new_purpose_code":"113","new_purpose_group":"19971000000602"}},{"rowno":"0021","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/4652","case_no":"2019/4652","trn_bor_caseid":"18074000003385","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"08/04/2024","next_hear_date":"06/05/2024","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"0022","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/4691","case_no":"2019/4691","trn_bor_caseid":"11619000002441","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0023","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/4721","case_no":"2019/4721","trn_bor_caseid":"18696000002446","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"08/04/2024","next_hear_date":"06/05/2024","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"0024","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/5046","case_no":"2019/5046","trn_bor_caseid":"16780000002786","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0025","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/5100","case_no":"2019/5100","trn_bor_caseid":"17974000003437","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0026","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/5175","case_no":"2019/5175","trn_bor_caseid":"17821000002964","manual_case_no":"","bench_code":"15","prev_case_purpose":"???.","prev_purpose_code":"201","prev_hear_date":"08/04/2024","next_hear_date":"06/05/2024","new_case_purpose":"10189000000601","new_purpose_code":"201","new_purpose_group":"19968000000591"}},{"rowno":"0027","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/5280","case_no":"2019/5280","trn_bor_caseid":"14310000003814","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ?????","prev_purpose_code":"112","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10035000000979","new_purpose_code":"112","new_purpose_group":"19971000000602"}},{"rowno":"0028","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/5367","case_no":"2019/5367","trn_bor_caseid":"17090000002948","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"08/04/2024","next_hear_date":"06/05/2024","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"0029","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/5605","case_no":"2019/5605","trn_bor_caseid":"13003000003371","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"21/05/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0030","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/5622","case_no":"2019/5622","trn_bor_caseid":"15500000002504","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0031","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/5890","case_no":"2019/5890","trn_bor_caseid":"19712000003249","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0032","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/6426","case_no":"2019/6426","trn_bor_caseid":"16268000003407","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0033","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/6427","case_no":"2019/6427","trn_bor_caseid":"16324000002510","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0034","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/7716","case_no":"2019/7716","trn_bor_caseid":"19223000003869","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"08/04/2024","next_hear_date":"29/04/2024","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"0035","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/7814","case_no":"2019/7814","trn_bor_caseid":"12829000003138","manual_case_no":"","bench_code":"15","prev_case_purpose":"??????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"0","new_purpose_code":"","new_purpose_group":""}},{"rowno":"0036","text":"0","columns":{"puname":"jainpriti","court_name":"11599000000000","court_code":"10006","docid":"100062019/7817","case_no":"2019/7817","trn_bor_caseid":"12846000003082","manual_case_no":"","bench_code":"15","prev_case_purpose":"??????","prev_purpose_code":"122","prev_hear_date":"08/04/2024","next_hear_date":"12/08/2024","new_case_purpose":"0","new_purpose_code":"","new_purpose_group":""}}]}]}} Verifying username and password User Name : jainpriti Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app' U=jainpriti Time elapsed = 18 Password checking along with max.no of login specified in app.xml update axusers set logintry = 0 where lower(username) = :U Time elapsed = 6 Result : Verifying completed... Page Access Category : User Name : jainpriti Select sysdate as sdt from dual Time elapsed = 4 dt=09/04/2024 11:19:05 Select sysdate as sdt from dual Time elapsed = 4 Select usergroup from AXUSERLEVELGROUPS WHERE (lower(username) =:U) and ((startdate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') >= startdate) or (startdate is null)) and ((enddate is not null and to_date(:dt,'dd/mm/yyyy hh24:mi:ss') <= enddate) or (enddate is null)) U=jainpriti dt=09/04/2024 11:19:05 dt=09/04/2024 11:19:05 Time elapsed = 10 User Groups: rb_fbroom select userroles from axusergroups where groupname in ( 'rb_fbroom' ) Time elapsed = 4 User Roles : rb_fbroom Loading App/User vars reading the props xml Step3 Sql : select props from axprops where lower(name)= :name order by blobno Paramval : app ParamTYpe : c Param List : name select props from axprops where lower(name)= :name order by blobno Time elapsed = 4 Step4 axprops\stm size:4235 Step4-123456 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=jainpriti select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=jainpriti Time elapsed = 7 Result of firesql = Result = Evaluating sqlget({m2},{court_name}) Calling function sqlget Result of sqlget = BOARD OF REVENUE,AJMER Result = BOARD OF REVENUE,AJMER Evaluating firesql({m3},{select a.court_type from v_axcourts a where a.paxusername= :username order by 1}) Calling function firesql username=jainpriti select a.court_type from v_axcourts a where a.paxusername= :username order by 1 username=jainpriti Time elapsed = 6 Result of firesql = Result = Evaluating sqlget({m3},{court_type}) Calling function sqlget Result of sqlget = Revenue Board Result = Revenue Board Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1}) Calling function firesql username=jainpriti select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1 username=jainpriti Time elapsed = 8 Result of firesql = Result = Evaluating sqlget({m4},{court_name_mastid}) Calling function sqlget Result of sqlget = 11599000000000 Result = 11599000000000 Evaluating firesql({m4},{select a1.axusersid from axusers a1 where a1.username=:username}) Calling function firesql select a1.axusersid from axusers a1 where a1.username=:username username=jainpriti Time elapsed = 7 Result of firesql = Result = Evaluating sqlget({m4},{axusersid}) Calling function sqlget Result of sqlget = 1802550008253 Result = 1802550008253 Evaluating firesql({m4},{select :username as uname from dual}) Calling function firesql select :username as uname from dual username=jainpriti Time elapsed = 18 Result of firesql = Result = Evaluating sqlget({m4},{uname}) Calling function sqlget Result of sqlget = jainpriti Result = jainpriti 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=jainpriti Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m4},{COURT_CODE}) Calling function sqlget Result of sqlget = 10006 Result = 10006 Evaluating firesql({m2},{select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ'}) Calling function firesql select A.STATE_NAME from state_mast a where A.STATE_CODE ='RJ' Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m2},{STATE_NAME}) Calling function sqlget Result of sqlget = ???????? Result = ???????? Evaluating firesql({m7},{SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=jainpriti SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=jainpriti Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m7},{DISTNAMEENG}) Calling function sqlget Result of sqlget = Ajmer Result = Ajmer Evaluating firesql({m8},{SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1}) Calling function firesql username=jainpriti SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=jainpriti Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m8},{COURT_CATEGOTY}) Calling function sqlget Result of sqlget = 10593000000007 Result = 10593000000007 Evaluating firesql({m4},{select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid}) Calling function firesql login_userid=1802550008253 select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid login_userid=1802550008253 Time elapsed = 7 Result of firesql = Result = Evaluating sqlget({m4},{department_mastid}) Calling function sqlget Result of sqlget = 1579880000000 Result = 1579880000000 Evaluating firesql({m3},{select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1}) Calling function firesql select a.court_type_mastid from v_axcourts a where a.PAXUSERNAME= :username order by 1 username=jainpriti Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({m3},{court_type_mastid}) Calling function sqlget Result of sqlget = 10206000000012 Result = 10206000000012 Evaluating firesql({m4},{select A3.GROUPNAME from axusers a1, axuserlevelgroups a2,axusergroups a3 where a1.axusersid=A2.AXUSERSID and A2.USERGROUP=A3.GROUPNAME and a1.username= :username }) Calling function firesql username=jainpriti 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=jainpriti Time elapsed = 7 Result of firesql = Result = Evaluating sqlget({m4},{groupname}) Calling function sqlget Result of sqlget = rb_fbroom Result = rb_fbroom Evaluating firesql({a1},{select to_date('30/01/2021','DD/MM/RRRR') dd from dual}) Calling function firesql select to_date('30/01/2021','DD/MM/RRRR') dd from dual Time elapsed = 5 Result of firesql = Result = Evaluating sqlget({a1},{dd}) Calling function sqlget Result of sqlget = 30/01/2021 Result = 30/01/2021 Evaluating firesql({P1},{SELECT count(1) ct FROM trn_rcms_officer WHERE court_code in (select court_code from v_axcourts where paxusername = :username) and officer_name !=0}) Calling function firesql username=jainpriti 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=jainpriti Time elapsed = 9 Result of firesql = Result = Evaluating sqlget({P1},{ct}) Calling function sqlget Result of sqlget = 0 Result = 0 3 completed LoadAppVars Password validation done successfully select name from tstructs where blobno=1 and name in (SELECT SNAME FROM AXUSERACCESS WHERE RNAME IN ('rb_fbroom') and lower(sname)='bocup' and stype = 't' ) Time elapsed = 4 select Props from axuseraccess where lower(rname)='rb_fbroom' and lower(sname)='bocup' and stype = 't' Time elapsed = 7 Sql : select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno Paramval : rb_fbroom,bocup,t ParamTYpe : ccc Param List : rname sname stype select props from axuseraccess where lower(rname)= :rname and lower(sname)= :sname and stype = :stype order by blobno Time elapsed = 4 Reading data from stream Executing GetTransControlString Executing GetTransControl Creating DbCall Structure xml not received from client Step3 Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : bocup ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 4 Step4 tstructs\stm size:4415 Step4-0 Step4-1 Step4-2 Step4-3 Step4-4 Step5 Step6 Step9 Evaluating dtchk Result = Evaluating {NO} Result = Evaluating 1 Result = Evaluating 1 Result = Evaluating 0 Result = select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout) tid=bocup adxinout=o Time elapsed = 7 select * from trn_bor_mhearing where trn_bor_mhearingid=0 Time elapsed = 4 select * from Axusers where 1=2 Time elapsed = 7 select distinct(fldname) from AxTempUserFields Time elapsed = 4 select * from AxAttachWorkflow where lower(transid) = 'bocup' Time elapsed = 6 select distinct(schemaname) from axschema where lower(transid)='rbcrt' Time elapsed = 4 select trn_bor_caseregid from trn_bor_casereg where trn_bor_caseregid=0 Time elapsed = 3 select hearingdate from trn_bor_casereg where trn_bor_caseregid=0 Time elapsed = 4 select distinct(schemaname) from axschema where lower(transid)='rbcrt' Time elapsed = 4 select case_purpose_name from trn_bor_casereg where trn_bor_caseregid=0 Time elapsed = 3 select distinct(schemaname) from axschema where lower(transid)='rbcrt' Time elapsed = 3 select case_purpose_code from trn_bor_casereg where trn_bor_caseregid=0 Time elapsed = 4 Step3 Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : rbchh ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 4 Step4 tstructs\stm size:2091 Step4-0 Step4-1 Step4-2 Step4-3 Step4-4 Step5 Step6 Step9 Post on approve = False select transid from axpexchange where (transid = :tid) and (adxinout = :adxinout) tid=rbchh adxinout=o Time elapsed = 7 select * from trn_bor_case_hist where trn_bor_case_histid=0 Time elapsed = 5 Evaluating date() Result = Evaluating {Feedback} Result = Loading genmaps Creating Action object Submitting data to dbcall Submiting & Registering data Registering Global variables data Registering Global variables data over Setting values over DB Call Validate and save >>Validating bocup >>Frame No 1 courtname = 11599000000000 courtcode = 10006 cldate = 08/04/2024 cltype = R benchname = ?????? ????? benchcode = 15 cluser = bor2019 bench_mem1 = 0 bench_mem2 = 0 time zone difference = 0 >>Writing to tables bocup Select * FROM Sequence WHERE lower(TRANSTYPE) = 'bocup' Time elapsed = 3 Saving to table TRN_BOR_MHEARING select * from TRN_BOR_MHEARING where TRN_BOR_MHEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008246 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 cluser = bor2019 benchcode = 15 bench_mem2 = 0 bench_mem1 = 0 benchname = ?????? ????? courtcode = 10006 courtname = 11599000000000 cltype = R cldate = 08/04/2024 Posting record Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:06 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:06 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c cluser=bor2019 Param Type = c benchcode=15 Param Type = c bench_mem2=0 Param Type = c bench_mem1=0 Param Type = c benchname=?????? ????? Param Type = c courtcode=10006 Param Type = c courtname=11599000000000 Param Type = c cltype=R Param Type = c cldate=08/04/2024 00:00:00 insert into TRN_BOR_MHEARING (trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,cluser,benchcode,bench_mem2,bench_mem1,benchname,courtcode,courtname,cltype,cldate) values (:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:cluser,:benchcode,:bench_mem2,:bench_mem1,:benchname,:courtcode,:courtname,:cltype,to_date(:cldate,'dd/mm/yyyy hh24:mi:ss')) Saving to table TRN_BOR_HEARING select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008247 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 court_name = 11599000000000 next_hear_date = 12/08/2024 puname = jainpriti trn_bor_caseid = 13317000002909 case_no = 2019/513 manual_case_no = new_purpose_code = 201 bench_code = 15 docid = 100062019/513 new_case_purpose = 10189000000601 court_code = 10006 prev_hear_date = 08/04/2024 new_purpose_group = 19968000000591 prev_purpose_code = 201 TRN_BOR_HEARINGrow = 1 Posting record Param Type = n trn_bor_hearingid=17142000008247 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:06 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:06 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c court_name=11599000000000 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = c puname=jainpriti Param Type = n trn_bor_caseid=13317000002909 Param Type = c case_no=2019/513 Param Type = c new_purpose_code=201 Param Type = c bench_code=15 Param Type = c docid=100062019/513 Param Type = c new_case_purpose=10189000000601 Param Type = c court_code=10006 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = n new_purpose_group=19968000000591 Param Type = c prev_purpose_code=201 Param Type = n trn_bor_hearingrow=1 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_name,next_hear_date,puname,trn_bor_caseid,case_no,manual_case_no,new_purpose_code,bench_code,docid,new_case_purpose,court_code,prev_hear_date,new_purpose_group,prev_purpose_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_name,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:puname,:trn_bor_caseid,:case_no,null,:new_purpose_code,:bench_code,:docid,:new_case_purpose,:court_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:prev_purpose_code,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 2 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008248 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 case_no = 2019/568 trn_bor_caseid = 13260000002185 manual_case_no = docid = 100062019/568 puname = jainpriti court_name = 11599000000000 court_code = 10006 new_purpose_code = 120 new_purpose_group = 19973000000612 next_hear_date = 23/04/2024 new_case_purpose = 10107000000777 bench_code = 15 prev_purpose_code = 120 prev_hear_date = 08/04/2024 TRN_BOR_HEARINGrow = 2 Posting record Param Type = n trn_bor_hearingid=17142000008248 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:06 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:06 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2019/568 Param Type = n trn_bor_caseid=13260000002185 Param Type = c docid=100062019/568 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c new_purpose_code=120 Param Type = n new_purpose_group=19973000000612 Param Type = c next_hear_date=23/04/2024 00:00:00 Param Type = c new_case_purpose=10107000000777 Param Type = c bench_code=15 Param Type = c prev_purpose_code=120 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = n trn_bor_hearingrow=2 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 3 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008249 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 4 prev_hear_date = 08/04/2024 prev_purpose_code = 112 bench_code = 15 new_case_purpose = 10035000000979 next_hear_date = 12/08/2024 new_purpose_group = 19971000000602 new_purpose_code = 112 court_code = 10006 court_name = 11599000000000 puname = jainpriti docid = 100062019/629 manual_case_no = trn_bor_caseid = 16657000002124 case_no = 2019/629 TRN_BOR_HEARINGrow = 3 Posting record Param Type = n trn_bor_hearingid=17142000008249 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:06 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:06 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c prev_purpose_code=112 Param Type = c bench_code=15 Param Type = c new_case_purpose=10035000000979 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c new_purpose_code=112 Param Type = c court_code=10006 Param Type = c court_name=11599000000000 Param Type = c puname=jainpriti Param Type = c docid=100062019/629 Param Type = n trn_bor_caseid=16657000002124 Param Type = c case_no=2019/629 Param Type = n trn_bor_hearingrow=3 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,bench_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,court_code,court_name,puname,docid,manual_case_no,trn_bor_caseid,case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:bench_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:court_name,:puname,:docid,null,:trn_bor_caseid,:case_no,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 4 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008250 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 prev_hear_date = 08/04/2024 prev_purpose_code = 122 bench_code = 15 new_case_purpose = 10110000000719 next_hear_date = 12/08/2024 new_purpose_group = 19971000000602 new_purpose_code = 122 court_code = 10006 court_name = 11599000000000 puname = jainpriti docid = 100062019/723 manual_case_no = trn_bor_caseid = 13154000002339 case_no = 2019/723 TRN_BOR_HEARINGrow = 4 Posting record Param Type = n trn_bor_hearingid=17142000008250 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:06 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:06 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c prev_purpose_code=122 Param Type = c bench_code=15 Param Type = c new_case_purpose=10110000000719 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c new_purpose_code=122 Param Type = c court_code=10006 Param Type = c court_name=11599000000000 Param Type = c puname=jainpriti Param Type = c docid=100062019/723 Param Type = n trn_bor_caseid=13154000002339 Param Type = c case_no=2019/723 Param Type = n trn_bor_hearingrow=4 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,bench_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,court_code,court_name,puname,docid,manual_case_no,trn_bor_caseid,case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:bench_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:court_name,:puname,:docid,null,:trn_bor_caseid,:case_no,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 5 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008251 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 27 Select sysdate as sdt from dual Time elapsed = 6 case_no = 2019/1301 trn_bor_caseid = 14458000002190 manual_case_no = court_name = 11599000000000 court_code = 10006 docid = 100062019/1301 bench_code = 15 new_purpose_code = 201 new_purpose_group = 19968000000591 next_hear_date = 16/04/2024 prev_purpose_code = 201 prev_hear_date = 08/04/2024 new_case_purpose = 10189000000601 puname = jainpriti TRN_BOR_HEARINGrow = 5 Posting record Param Type = n trn_bor_hearingid=17142000008251 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:06 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:06 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2019/1301 Param Type = n trn_bor_caseid=14458000002190 Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c docid=100062019/1301 Param Type = c bench_code=15 Param Type = c new_purpose_code=201 Param Type = n new_purpose_group=19968000000591 Param Type = c next_hear_date=16/04/2024 00:00:00 Param Type = c prev_purpose_code=201 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c new_case_purpose=10189000000601 Param Type = c puname=jainpriti Param Type = n trn_bor_hearingrow=5 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,court_name,court_code,docid,bench_code,new_purpose_code,new_purpose_group,next_hear_date,prev_purpose_code,prev_hear_date,new_case_purpose,puname,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:court_name,:court_code,:docid,:bench_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:puname,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 6 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008252 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 4 prev_hear_date = 08/04/2024 prev_purpose_code = 122 bench_code = 15 new_case_purpose = 10110000000719 next_hear_date = 12/08/2024 new_purpose_group = 19971000000602 new_purpose_code = 122 court_code = 10006 court_name = 11599000000000 puname = jainpriti docid = 100062019/1367 manual_case_no = trn_bor_caseid = 17682000002374 case_no = 2019/1367 TRN_BOR_HEARINGrow = 6 Posting record Param Type = n trn_bor_hearingid=17142000008252 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:06 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:06 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c prev_purpose_code=122 Param Type = c bench_code=15 Param Type = c new_case_purpose=10110000000719 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c new_purpose_code=122 Param Type = c court_code=10006 Param Type = c court_name=11599000000000 Param Type = c puname=jainpriti Param Type = c docid=100062019/1367 Param Type = n trn_bor_caseid=17682000002374 Param Type = c case_no=2019/1367 Param Type = n trn_bor_hearingrow=6 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,bench_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,court_code,court_name,puname,docid,manual_case_no,trn_bor_caseid,case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:bench_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:court_name,:puname,:docid,null,:trn_bor_caseid,:case_no,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 7 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008253 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 4 prev_hear_date = 08/04/2024 prev_purpose_code = 122 court_name = 11599000000000 new_case_purpose = 10110000000719 next_hear_date = 12/08/2024 new_purpose_group = 19971000000602 new_purpose_code = 122 case_no = 2019/2115 docid = 100062019/2115 court_code = 10006 trn_bor_caseid = 15502000002193 puname = jainpriti bench_code = 15 manual_case_no = TRN_BOR_HEARINGrow = 7 Posting record Param Type = n trn_bor_hearingid=17142000008253 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:06 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:06 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c prev_purpose_code=122 Param Type = c court_name=11599000000000 Param Type = c new_case_purpose=10110000000719 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c new_purpose_code=122 Param Type = c case_no=2019/2115 Param Type = c docid=100062019/2115 Param Type = c court_code=10006 Param Type = n trn_bor_caseid=15502000002193 Param Type = c puname=jainpriti Param Type = c bench_code=15 Param Type = n trn_bor_hearingrow=7 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,court_name,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,case_no,docid,court_code,trn_bor_caseid,puname,bench_code,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:court_name,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:case_no,:docid,:court_code,:trn_bor_caseid,:puname,:bench_code,null,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 8 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008254 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 case_no = 2019/3183 trn_bor_caseid = 12873000002261 manual_case_no = docid = 100062019/3183 puname = jainpriti court_name = 11599000000000 court_code = 10006 new_purpose_code = 120 new_purpose_group = 19973000000612 next_hear_date = 23/04/2024 new_case_purpose = 10107000000777 bench_code = 15 prev_purpose_code = 120 prev_hear_date = 08/04/2024 TRN_BOR_HEARINGrow = 8 Posting record Param Type = n trn_bor_hearingid=17142000008254 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:07 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2019/3183 Param Type = n trn_bor_caseid=12873000002261 Param Type = c docid=100062019/3183 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c new_purpose_code=120 Param Type = n new_purpose_group=19973000000612 Param Type = c next_hear_date=23/04/2024 00:00:00 Param Type = c new_case_purpose=10107000000777 Param Type = c bench_code=15 Param Type = c prev_purpose_code=120 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = n trn_bor_hearingrow=8 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 6 Adding new record to store data from Frame 2, Row 9 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008255 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 case_no = 2019/3235 trn_bor_caseid = 15540000003006 manual_case_no = docid = 100062019/3235 puname = jainpriti court_name = 11599000000000 court_code = 10006 new_purpose_code = 112 next_hear_date = 06/05/2024 new_purpose_group = 19971000000602 new_case_purpose = 10035000000979 bench_code = 15 prev_purpose_code = 112 prev_hear_date = 08/04/2024 TRN_BOR_HEARINGrow = 9 Posting record Param Type = n trn_bor_hearingid=17142000008255 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:07 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2019/3235 Param Type = n trn_bor_caseid=15540000003006 Param Type = c docid=100062019/3235 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c new_purpose_code=112 Param Type = c next_hear_date=06/05/2024 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c new_case_purpose=10035000000979 Param Type = c bench_code=15 Param Type = c prev_purpose_code=112 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = n trn_bor_hearingrow=9 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,next_hear_date,new_purpose_group,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 10 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008256 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 4 case_no = 2019/3938 docid = 100062019/3938 trn_bor_caseid = 18510000002641 bench_code = 15 manual_case_no = court_code = 10006 prev_hear_date = 08/04/2024 new_purpose_group = 19973000000612 next_hear_date = 06/05/2024 court_name = 11599000000000 puname = jainpriti new_case_purpose = 10107000000777 prev_purpose_code = 120 new_purpose_code = 120 TRN_BOR_HEARINGrow = 10 Posting record Param Type = n trn_bor_hearingid=17142000008256 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:07 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2019/3938 Param Type = c docid=100062019/3938 Param Type = n trn_bor_caseid=18510000002641 Param Type = c bench_code=15 Param Type = c court_code=10006 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = n new_purpose_group=19973000000612 Param Type = c next_hear_date=06/05/2024 00:00:00 Param Type = c court_name=11599000000000 Param Type = c puname=jainpriti Param Type = c new_case_purpose=10107000000777 Param Type = c prev_purpose_code=120 Param Type = c new_purpose_code=120 Param Type = n trn_bor_hearingrow=10 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,docid,trn_bor_caseid,bench_code,manual_case_no,court_code,prev_hear_date,new_purpose_group,next_hear_date,court_name,puname,new_case_purpose,prev_purpose_code,new_purpose_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:docid,:trn_bor_caseid,:bench_code,null,:court_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_name,:puname,:new_case_purpose,:prev_purpose_code,:new_purpose_code,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 11 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008257 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 6 prev_hear_date = 08/04/2024 prev_purpose_code = 120 new_purpose_code = 120 next_hear_date = 06/05/2024 new_purpose_group = 19973000000612 new_case_purpose = 10107000000777 docid = 100062019/3975 court_code = 10006 case_no = 2019/3975 trn_bor_caseid = 14643000002946 manual_case_no = bench_code = 15 court_name = 11599000000000 puname = jainpriti TRN_BOR_HEARINGrow = 11 Posting record Param Type = n trn_bor_hearingid=17142000008257 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:07 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c prev_purpose_code=120 Param Type = c new_purpose_code=120 Param Type = c next_hear_date=06/05/2024 00:00:00 Param Type = n new_purpose_group=19973000000612 Param Type = c new_case_purpose=10107000000777 Param Type = c docid=100062019/3975 Param Type = c court_code=10006 Param Type = c case_no=2019/3975 Param Type = n trn_bor_caseid=14643000002946 Param Type = c bench_code=15 Param Type = c court_name=11599000000000 Param Type = c puname=jainpriti Param Type = n trn_bor_hearingrow=11 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,new_purpose_code,next_hear_date,new_purpose_group,new_case_purpose,docid,court_code,case_no,trn_bor_caseid,manual_case_no,bench_code,court_name,puname,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_case_purpose,:docid,:court_code,:case_no,:trn_bor_caseid,null,:bench_code,:court_name,:puname,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 12 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008258 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 case_no = 2019/3976 trn_bor_caseid = 14726000002752 manual_case_no = docid = 100062019/3976 puname = jainpriti court_name = 11599000000000 court_code = 10006 new_purpose_code = 113 new_purpose_group = 19971000000602 next_hear_date = 12/08/2024 new_case_purpose = 10037000000780 bench_code = 15 prev_purpose_code = 113 prev_hear_date = 08/04/2024 TRN_BOR_HEARINGrow = 12 Posting record Param Type = n trn_bor_hearingid=17142000008258 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:07 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2019/3976 Param Type = n trn_bor_caseid=14726000002752 Param Type = c docid=100062019/3976 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c new_purpose_code=113 Param Type = n new_purpose_group=19971000000602 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = c new_case_purpose=10037000000780 Param Type = c bench_code=15 Param Type = c prev_purpose_code=113 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = n trn_bor_hearingrow=12 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 13 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008259 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 prev_hear_date = 08/04/2024 prev_purpose_code = 120 bench_code = 15 new_case_purpose = 10107000000777 next_hear_date = 29/04/2024 new_purpose_group = 19973000000612 new_purpose_code = 120 court_code = 10006 court_name = 11599000000000 puname = jainpriti docid = 100062019/4116 manual_case_no = trn_bor_caseid = 11214000002737 case_no = 2019/4116 TRN_BOR_HEARINGrow = 13 Posting record Param Type = n trn_bor_hearingid=17142000008259 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:07 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c prev_purpose_code=120 Param Type = c bench_code=15 Param Type = c new_case_purpose=10107000000777 Param Type = c next_hear_date=29/04/2024 00:00:00 Param Type = n new_purpose_group=19973000000612 Param Type = c new_purpose_code=120 Param Type = c court_code=10006 Param Type = c court_name=11599000000000 Param Type = c puname=jainpriti Param Type = c docid=100062019/4116 Param Type = n trn_bor_caseid=11214000002737 Param Type = c case_no=2019/4116 Param Type = n trn_bor_hearingrow=13 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,bench_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,court_code,court_name,puname,docid,manual_case_no,trn_bor_caseid,case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:bench_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:court_name,:puname,:docid,null,:trn_bor_caseid,:case_no,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 14 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008260 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 new_purpose_group = 19971000000602 next_hear_date = 12/08/2024 bench_code = 15 new_purpose_code = 122 prev_purpose_code = 122 prev_hear_date = 08/04/2024 new_case_purpose = 10110000000719 court_code = 10006 court_name = 11599000000000 puname = jainpriti docid = 100062019/4136 manual_case_no = trn_bor_caseid = 14205000002574 case_no = 2019/4136 TRN_BOR_HEARINGrow = 14 Posting record Param Type = n trn_bor_hearingid=17142000008260 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:07 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = n new_purpose_group=19971000000602 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = c bench_code=15 Param Type = c new_purpose_code=122 Param Type = c prev_purpose_code=122 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c new_case_purpose=10110000000719 Param Type = c court_code=10006 Param Type = c court_name=11599000000000 Param Type = c puname=jainpriti Param Type = c docid=100062019/4136 Param Type = n trn_bor_caseid=14205000002574 Param Type = c case_no=2019/4136 Param Type = n trn_bor_hearingrow=14 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_group,next_hear_date,bench_code,new_purpose_code,prev_purpose_code,prev_hear_date,new_case_purpose,court_code,court_name,puname,docid,manual_case_no,trn_bor_caseid,case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,:new_purpose_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:court_code,:court_name,:puname,:docid,null,:trn_bor_caseid,:case_no,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 15 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008261 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 3 manual_case_no = bench_code = 15 trn_bor_caseid = 15698000002469 docid = 100062019/4241 case_no = 2019/4241 prev_purpose_code = 112 new_purpose_group = 19971000000602 next_hear_date = 12/08/2024 new_purpose_code = 112 prev_hear_date = 08/04/2024 new_case_purpose = 10035000000979 puname = jainpriti court_name = 11599000000000 court_code = 10006 TRN_BOR_HEARINGrow = 15 Posting record Param Type = n trn_bor_hearingid=17142000008261 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:07 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c bench_code=15 Param Type = n trn_bor_caseid=15698000002469 Param Type = c docid=100062019/4241 Param Type = c case_no=2019/4241 Param Type = c prev_purpose_code=112 Param Type = n new_purpose_group=19971000000602 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = c new_purpose_code=112 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c new_case_purpose=10035000000979 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = n trn_bor_hearingrow=15 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,manual_case_no,bench_code,trn_bor_caseid,docid,case_no,prev_purpose_code,new_purpose_group,next_hear_date,new_purpose_code,prev_hear_date,new_case_purpose,puname,court_name,court_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,null,:bench_code,:trn_bor_caseid,:docid,:case_no,:prev_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:puname,:court_name,:court_code,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 6 Adding new record to store data from Frame 2, Row 16 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 5 RecordId = 17142000008262 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 case_no = 2019/4242 bench_code = 15 manual_case_no = docid = 100062019/4242 puname = jainpriti court_name = 11599000000000 court_code = 10006 trn_bor_caseid = 16226000002978 new_purpose_group = 19971000000602 next_hear_date = 12/08/2024 new_purpose_code = 112 prev_purpose_code = 112 prev_hear_date = 08/04/2024 new_case_purpose = 10035000000979 TRN_BOR_HEARINGrow = 16 Posting record Param Type = n trn_bor_hearingid=17142000008262 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:07 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2019/4242 Param Type = c bench_code=15 Param Type = c docid=100062019/4242 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = n trn_bor_caseid=16226000002978 Param Type = n new_purpose_group=19971000000602 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = c new_purpose_code=112 Param Type = c prev_purpose_code=112 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c new_case_purpose=10035000000979 Param Type = n trn_bor_hearingrow=16 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,bench_code,manual_case_no,docid,puname,court_name,court_code,trn_bor_caseid,new_purpose_group,next_hear_date,new_purpose_code,prev_purpose_code,prev_hear_date,new_case_purpose,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:bench_code,null,:docid,:puname,:court_name,:court_code,:trn_bor_caseid,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 17 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 10 RecordId = 17142000008263 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 case_no = 2019/4375 trn_bor_caseid = 12948000002895 manual_case_no = docid = 100062019/4375 puname = jainpriti court_name = 11599000000000 court_code = 10006 new_purpose_code = 122 new_purpose_group = 19971000000602 next_hear_date = 12/08/2024 new_case_purpose = 10110000000719 bench_code = 15 prev_purpose_code = 122 prev_hear_date = 08/04/2024 TRN_BOR_HEARINGrow = 17 Posting record Param Type = n trn_bor_hearingid=17142000008263 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:07 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:07 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2019/4375 Param Type = n trn_bor_caseid=12948000002895 Param Type = c docid=100062019/4375 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c new_purpose_code=122 Param Type = n new_purpose_group=19971000000602 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = c new_case_purpose=10110000000719 Param Type = c bench_code=15 Param Type = c prev_purpose_code=122 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = n trn_bor_hearingrow=17 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 18 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008264 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 5 court_name = 11599000000000 court_code = 10006 docid = 100062019/4519 prev_hear_date = 08/04/2024 puname = jainpriti new_purpose_group = 19971000000602 bench_code = 15 next_hear_date = 12/08/2024 prev_purpose_code = 122 case_no = 2019/4519 trn_bor_caseid = 17990000002353 manual_case_no = new_case_purpose = 10110000000719 new_purpose_code = 122 TRN_BOR_HEARINGrow = 18 Posting record Param Type = n trn_bor_hearingid=17142000008264 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:08 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:08 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c docid=100062019/4519 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c puname=jainpriti Param Type = n new_purpose_group=19971000000602 Param Type = c bench_code=15 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = c prev_purpose_code=122 Param Type = c case_no=2019/4519 Param Type = n trn_bor_caseid=17990000002353 Param Type = c new_case_purpose=10110000000719 Param Type = c new_purpose_code=122 Param Type = n trn_bor_hearingrow=18 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_name,court_code,docid,prev_hear_date,puname,new_purpose_group,bench_code,next_hear_date,prev_purpose_code,case_no,trn_bor_caseid,manual_case_no,new_case_purpose,new_purpose_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_name,:court_code,:docid,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:puname,:new_purpose_group,:bench_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:case_no,:trn_bor_caseid,null,:new_case_purpose,:new_purpose_code,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 19 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008265 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 docid = 100062019/4520 prev_purpose_code = 122 puname = jainpriti bench_code = 15 case_no = 2019/4520 trn_bor_caseid = 18029000002317 manual_case_no = new_purpose_code = 122 new_purpose_group = 19971000000602 next_hear_date = 12/08/2024 new_case_purpose = 10110000000719 prev_hear_date = 08/04/2024 court_code = 10006 court_name = 11599000000000 TRN_BOR_HEARINGrow = 19 Posting record Param Type = n trn_bor_hearingid=17142000008265 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:08 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:08 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c docid=100062019/4520 Param Type = c prev_purpose_code=122 Param Type = c puname=jainpriti Param Type = c bench_code=15 Param Type = c case_no=2019/4520 Param Type = n trn_bor_caseid=18029000002317 Param Type = c new_purpose_code=122 Param Type = n new_purpose_group=19971000000602 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = c new_case_purpose=10110000000719 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c court_code=10006 Param Type = c court_name=11599000000000 Param Type = n trn_bor_hearingrow=19 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,docid,prev_purpose_code,puname,bench_code,case_no,trn_bor_caseid,manual_case_no,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,prev_hear_date,court_code,court_name,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:docid,:prev_purpose_code,:puname,:bench_code,:case_no,:trn_bor_caseid,null,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:court_name,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 12 Adding new record to store data from Frame 2, Row 20 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008266 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 case_no = 2019/4600 trn_bor_caseid = 12308000002936 manual_case_no = docid = 100062019/4600 puname = jainpriti court_name = 11599000000000 court_code = 10006 new_purpose_code = 113 new_purpose_group = 19971000000602 next_hear_date = 06/05/2024 new_case_purpose = 10037000000780 bench_code = 15 prev_purpose_code = 113 prev_hear_date = 08/04/2024 TRN_BOR_HEARINGrow = 20 Posting record Param Type = n trn_bor_hearingid=17142000008266 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:08 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:08 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2019/4600 Param Type = n trn_bor_caseid=12308000002936 Param Type = c docid=100062019/4600 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c new_purpose_code=113 Param Type = n new_purpose_group=19971000000602 Param Type = c next_hear_date=06/05/2024 00:00:00 Param Type = c new_case_purpose=10037000000780 Param Type = c bench_code=15 Param Type = c prev_purpose_code=113 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = n trn_bor_hearingrow=20 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 21 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008267 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 4 case_no = 2019/4652 trn_bor_caseid = 18074000003385 manual_case_no = docid = 100062019/4652 puname = jainpriti court_name = 11599000000000 court_code = 10006 new_purpose_code = 120 new_purpose_group = 19973000000612 next_hear_date = 06/05/2024 new_case_purpose = 10107000000777 bench_code = 15 prev_purpose_code = 120 prev_hear_date = 08/04/2024 TRN_BOR_HEARINGrow = 21 Posting record Param Type = n trn_bor_hearingid=17142000008267 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:08 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:08 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2019/4652 Param Type = n trn_bor_caseid=18074000003385 Param Type = c docid=100062019/4652 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c new_purpose_code=120 Param Type = n new_purpose_group=19973000000612 Param Type = c next_hear_date=06/05/2024 00:00:00 Param Type = c new_case_purpose=10107000000777 Param Type = c bench_code=15 Param Type = c prev_purpose_code=120 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = n trn_bor_hearingrow=21 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 8 Adding new record to store data from Frame 2, Row 22 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008268 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 prev_purpose_code = 122 next_hear_date = 12/08/2024 bench_code = 15 prev_hear_date = 08/04/2024 new_purpose_group = 19971000000602 new_purpose_code = 122 new_case_purpose = 10110000000719 court_code = 10006 court_name = 11599000000000 puname = jainpriti docid = 100062019/4691 manual_case_no = trn_bor_caseid = 11619000002441 case_no = 2019/4691 TRN_BOR_HEARINGrow = 22 Posting record Param Type = n trn_bor_hearingid=17142000008268 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:08 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:08 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_purpose_code=122 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = c bench_code=15 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c new_purpose_code=122 Param Type = c new_case_purpose=10110000000719 Param Type = c court_code=10006 Param Type = c court_name=11599000000000 Param Type = c puname=jainpriti Param Type = c docid=100062019/4691 Param Type = n trn_bor_caseid=11619000002441 Param Type = c case_no=2019/4691 Param Type = n trn_bor_hearingrow=22 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_purpose_code,next_hear_date,bench_code,prev_hear_date,new_purpose_group,new_purpose_code,new_case_purpose,court_code,court_name,puname,docid,manual_case_no,trn_bor_caseid,case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:new_case_purpose,:court_code,:court_name,:puname,:docid,null,:trn_bor_caseid,:case_no,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 6 Adding new record to store data from Frame 2, Row 23 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008269 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 next_hear_date = 06/05/2024 docid = 100062019/4721 case_no = 2019/4721 trn_bor_caseid = 18696000002446 puname = jainpriti court_name = 11599000000000 court_code = 10006 manual_case_no = new_case_purpose = 10107000000777 new_purpose_code = 120 new_purpose_group = 19973000000612 bench_code = 15 prev_purpose_code = 120 prev_hear_date = 08/04/2024 TRN_BOR_HEARINGrow = 23 Posting record Param Type = n trn_bor_hearingid=17142000008269 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:08 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:08 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=06/05/2024 00:00:00 Param Type = c docid=100062019/4721 Param Type = c case_no=2019/4721 Param Type = n trn_bor_caseid=18696000002446 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c new_case_purpose=10107000000777 Param Type = c new_purpose_code=120 Param Type = n new_purpose_group=19973000000612 Param Type = c bench_code=15 Param Type = c prev_purpose_code=120 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = n trn_bor_hearingrow=23 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,docid,case_no,trn_bor_caseid,puname,court_name,court_code,manual_case_no,new_case_purpose,new_purpose_code,new_purpose_group,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:docid,:case_no,:trn_bor_caseid,:puname,:court_name,:court_code,null,:new_case_purpose,:new_purpose_code,:new_purpose_group,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 24 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008270 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 4 next_hear_date = 12/08/2024 new_purpose_code = 122 docid = 100062019/5046 case_no = 2019/5046 puname = jainpriti court_name = 11599000000000 court_code = 10006 trn_bor_caseid = 16780000002786 prev_purpose_code = 122 prev_hear_date = 08/04/2024 new_purpose_group = 19971000000602 manual_case_no = bench_code = 15 new_case_purpose = 10110000000719 TRN_BOR_HEARINGrow = 24 Posting record Param Type = n trn_bor_hearingid=17142000008270 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:08 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:08 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = c new_purpose_code=122 Param Type = c docid=100062019/5046 Param Type = c case_no=2019/5046 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = n trn_bor_caseid=16780000002786 Param Type = c prev_purpose_code=122 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c bench_code=15 Param Type = c new_case_purpose=10110000000719 Param Type = n trn_bor_hearingrow=24 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_purpose_code,docid,case_no,puname,court_name,court_code,trn_bor_caseid,prev_purpose_code,prev_hear_date,new_purpose_group,manual_case_no,bench_code,new_case_purpose,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_code,:docid,:case_no,:puname,:court_name,:court_code,:trn_bor_caseid,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,null,:bench_code,:new_case_purpose,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 25 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 5 RecordId = 17142000008271 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 next_hear_date = 12/08/2024 new_purpose_group = 19971000000602 docid = 100062019/5100 case_no = 2019/5100 trn_bor_caseid = 17974000003437 puname = jainpriti court_name = 11599000000000 court_code = 10006 prev_hear_date = 08/04/2024 new_case_purpose = 10110000000719 new_purpose_code = 122 manual_case_no = bench_code = 15 prev_purpose_code = 122 TRN_BOR_HEARINGrow = 25 Posting record Param Type = n trn_bor_hearingid=17142000008271 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:08 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:08 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c docid=100062019/5100 Param Type = c case_no=2019/5100 Param Type = n trn_bor_caseid=17974000003437 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c new_case_purpose=10110000000719 Param Type = c new_purpose_code=122 Param Type = c bench_code=15 Param Type = c prev_purpose_code=122 Param Type = n trn_bor_hearingrow=25 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,new_purpose_group,docid,case_no,trn_bor_caseid,puname,court_name,court_code,prev_hear_date,new_case_purpose,new_purpose_code,manual_case_no,bench_code,prev_purpose_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:docid,:case_no,:trn_bor_caseid,:puname,:court_name,:court_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:new_purpose_code,null,:bench_code,:prev_purpose_code,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 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 = 2 RecordId = 17142000008272 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 new_purpose_group = 19968000000591 next_hear_date = 06/05/2024 manual_case_no = trn_bor_caseid = 17821000002964 case_no = 2019/5175 prev_purpose_code = 201 prev_hear_date = 08/04/2024 bench_code = 15 puname = jainpriti new_case_purpose = 10189000000601 new_purpose_code = 201 docid = 100062019/5175 court_code = 10006 court_name = 11599000000000 TRN_BOR_HEARINGrow = 26 Posting record Param Type = n trn_bor_hearingid=17142000008272 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:09 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:09 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = n new_purpose_group=19968000000591 Param Type = c next_hear_date=06/05/2024 00:00:00 Param Type = n trn_bor_caseid=17821000002964 Param Type = c case_no=2019/5175 Param Type = c prev_purpose_code=201 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c bench_code=15 Param Type = c puname=jainpriti Param Type = c new_case_purpose=10189000000601 Param Type = c new_purpose_code=201 Param Type = c docid=100062019/5175 Param Type = c court_code=10006 Param Type = c court_name=11599000000000 Param Type = n trn_bor_hearingrow=26 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_group,next_hear_date,manual_case_no,trn_bor_caseid,case_no,prev_purpose_code,prev_hear_date,bench_code,puname,new_case_purpose,new_purpose_code,docid,court_code,court_name,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),null,:trn_bor_caseid,:case_no,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,:puname,:new_case_purpose,:new_purpose_code,:docid,:court_code,:court_name,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 6 Adding new record to store data from Frame 2, Row 27 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008273 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 3 new_purpose_group = 19971000000602 next_hear_date = 12/08/2024 new_purpose_code = 112 docid = 100062019/5280 case_no = 2019/5280 court_code = 10006 puname = jainpriti court_name = 11599000000000 trn_bor_caseid = 14310000003814 prev_hear_date = 08/04/2024 new_case_purpose = 10035000000979 prev_purpose_code = 112 manual_case_no = bench_code = 15 TRN_BOR_HEARINGrow = 27 Posting record Param Type = n trn_bor_hearingid=17142000008273 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:09 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:09 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = n new_purpose_group=19971000000602 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = c new_purpose_code=112 Param Type = c docid=100062019/5280 Param Type = c case_no=2019/5280 Param Type = c court_code=10006 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = n trn_bor_caseid=14310000003814 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c new_case_purpose=10035000000979 Param Type = c prev_purpose_code=112 Param Type = c bench_code=15 Param Type = n trn_bor_hearingrow=27 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_group,next_hear_date,new_purpose_code,docid,case_no,court_code,puname,court_name,trn_bor_caseid,prev_hear_date,new_case_purpose,prev_purpose_code,manual_case_no,bench_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_code,:docid,:case_no,:court_code,:puname,:court_name,:trn_bor_caseid,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:prev_purpose_code,null,:bench_code,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 28 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008274 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 new_purpose_code = 120 new_purpose_group = 19973000000612 next_hear_date = 06/05/2024 court_code = 10006 court_name = 11599000000000 docid = 100062019/5367 bench_code = 15 case_no = 2019/5367 puname = jainpriti prev_hear_date = 08/04/2024 new_case_purpose = 10107000000777 prev_purpose_code = 120 trn_bor_caseid = 17090000002948 manual_case_no = TRN_BOR_HEARINGrow = 28 Posting record Param Type = n trn_bor_hearingid=17142000008274 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:09 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:09 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c new_purpose_code=120 Param Type = n new_purpose_group=19973000000612 Param Type = c next_hear_date=06/05/2024 00:00:00 Param Type = c court_code=10006 Param Type = c court_name=11599000000000 Param Type = c docid=100062019/5367 Param Type = c bench_code=15 Param Type = c case_no=2019/5367 Param Type = c puname=jainpriti Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c new_case_purpose=10107000000777 Param Type = c prev_purpose_code=120 Param Type = n trn_bor_caseid=17090000002948 Param Type = n trn_bor_hearingrow=28 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_code,new_purpose_group,next_hear_date,court_code,court_name,docid,bench_code,case_no,puname,prev_hear_date,new_case_purpose,prev_purpose_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:court_name,:docid,:bench_code,:case_no,:puname,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:prev_purpose_code,:trn_bor_caseid,null,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 29 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008275 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 5 new_purpose_code = 122 new_purpose_group = 19971000000602 next_hear_date = 21/05/2024 new_case_purpose = 10110000000719 docid = 100062019/5605 case_no = 2019/5605 court_code = 10006 puname = jainpriti court_name = 11599000000000 prev_purpose_code = 122 prev_hear_date = 08/04/2024 bench_code = 15 trn_bor_caseid = 13003000003371 manual_case_no = TRN_BOR_HEARINGrow = 29 Posting record Param Type = n trn_bor_hearingid=17142000008275 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:09 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:09 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c new_purpose_code=122 Param Type = n new_purpose_group=19971000000602 Param Type = c next_hear_date=21/05/2024 00:00:00 Param Type = c new_case_purpose=10110000000719 Param Type = c docid=100062019/5605 Param Type = c case_no=2019/5605 Param Type = c court_code=10006 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c prev_purpose_code=122 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c bench_code=15 Param Type = n trn_bor_caseid=13003000003371 Param Type = n trn_bor_hearingrow=29 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,docid,case_no,court_code,puname,court_name,prev_purpose_code,prev_hear_date,bench_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:docid,:case_no,:court_code,:puname,:court_name,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,:trn_bor_caseid,null,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 30 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008276 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 new_purpose_code = 122 new_case_purpose = 10110000000719 next_hear_date = 12/08/2024 new_purpose_group = 19971000000602 court_code = 10006 court_name = 11599000000000 docid = 100062019/5622 trn_bor_caseid = 15500000002504 case_no = 2019/5622 prev_purpose_code = 122 prev_hear_date = 08/04/2024 bench_code = 15 puname = jainpriti manual_case_no = TRN_BOR_HEARINGrow = 30 Posting record Param Type = n trn_bor_hearingid=17142000008276 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:09 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:09 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c new_purpose_code=122 Param Type = c new_case_purpose=10110000000719 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c court_code=10006 Param Type = c court_name=11599000000000 Param Type = c docid=100062019/5622 Param Type = n trn_bor_caseid=15500000002504 Param Type = c case_no=2019/5622 Param Type = c prev_purpose_code=122 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c bench_code=15 Param Type = c puname=jainpriti Param Type = n trn_bor_hearingrow=30 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,court_code,court_name,docid,trn_bor_caseid,case_no,prev_purpose_code,prev_hear_date,bench_code,puname,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:court_code,:court_name,:docid,:trn_bor_caseid,:case_no,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,:puname,null,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 31 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008277 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 4 new_case_purpose = 10110000000719 new_purpose_code = 122 next_hear_date = 12/08/2024 new_purpose_group = 19971000000602 prev_hear_date = 08/04/2024 court_code = 10006 docid = 100062019/5890 puname = jainpriti court_name = 11599000000000 case_no = 2019/5890 bench_code = 15 prev_purpose_code = 122 trn_bor_caseid = 19712000003249 manual_case_no = TRN_BOR_HEARINGrow = 31 Posting record Param Type = n trn_bor_hearingid=17142000008277 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:09 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:09 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c new_case_purpose=10110000000719 Param Type = c new_purpose_code=122 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c court_code=10006 Param Type = c docid=100062019/5890 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c case_no=2019/5890 Param Type = c bench_code=15 Param Type = c prev_purpose_code=122 Param Type = n trn_bor_caseid=19712000003249 Param Type = n trn_bor_hearingrow=31 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,new_purpose_code,next_hear_date,new_purpose_group,prev_hear_date,court_code,docid,puname,court_name,case_no,bench_code,prev_purpose_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,:new_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:docid,:puname,:court_name,:case_no,:bench_code,:prev_purpose_code,:trn_bor_caseid,null,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 6 Adding new record to store data from Frame 2, Row 32 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008278 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 new_case_purpose = 10110000000719 prev_hear_date = 08/04/2024 next_hear_date = 12/08/2024 new_purpose_group = 19971000000602 new_purpose_code = 122 court_name = 11599000000000 court_code = 10006 docid = 100062019/6426 puname = jainpriti case_no = 2019/6426 bench_code = 15 prev_purpose_code = 122 trn_bor_caseid = 16268000003407 manual_case_no = TRN_BOR_HEARINGrow = 32 Posting record Param Type = n trn_bor_hearingid=17142000008278 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:09 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:09 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c new_case_purpose=10110000000719 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c new_purpose_code=122 Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c docid=100062019/6426 Param Type = c puname=jainpriti Param Type = c case_no=2019/6426 Param Type = c bench_code=15 Param Type = c prev_purpose_code=122 Param Type = n trn_bor_caseid=16268000003407 Param Type = n trn_bor_hearingrow=32 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,prev_hear_date,next_hear_date,new_purpose_group,new_purpose_code,court_name,court_code,docid,puname,case_no,bench_code,prev_purpose_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_name,:court_code,:docid,:puname,:case_no,:bench_code,:prev_purpose_code,:trn_bor_caseid,null,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 33 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008279 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 new_case_purpose = 10110000000719 prev_hear_date = 08/04/2024 next_hear_date = 12/08/2024 new_purpose_group = 19971000000602 new_purpose_code = 122 prev_purpose_code = 122 court_code = 10006 docid = 100062019/6427 puname = jainpriti court_name = 11599000000000 manual_case_no = bench_code = 15 case_no = 2019/6427 trn_bor_caseid = 16324000002510 TRN_BOR_HEARINGrow = 33 Posting record Param Type = n trn_bor_hearingid=17142000008279 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:09 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:09 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c new_case_purpose=10110000000719 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c new_purpose_code=122 Param Type = c prev_purpose_code=122 Param Type = c court_code=10006 Param Type = c docid=100062019/6427 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c bench_code=15 Param Type = c case_no=2019/6427 Param Type = n trn_bor_caseid=16324000002510 Param Type = n trn_bor_hearingrow=33 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,prev_hear_date,next_hear_date,new_purpose_group,new_purpose_code,prev_purpose_code,court_code,docid,puname,court_name,manual_case_no,bench_code,case_no,trn_bor_caseid,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:prev_purpose_code,:court_code,:docid,:puname,:court_name,null,:bench_code,:case_no,:trn_bor_caseid,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 34 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 17142000008280 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 prev_hear_date = 08/04/2024 prev_purpose_code = 120 new_case_purpose = 10107000000777 next_hear_date = 29/04/2024 new_purpose_group = 19973000000612 new_purpose_code = 120 court_code = 10006 docid = 100062019/7716 court_name = 11599000000000 puname = jainpriti manual_case_no = bench_code = 15 case_no = 2019/7716 trn_bor_caseid = 19223000003869 TRN_BOR_HEARINGrow = 34 Posting record Param Type = n trn_bor_hearingid=17142000008280 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:09 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:09 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c prev_purpose_code=120 Param Type = c new_case_purpose=10107000000777 Param Type = c next_hear_date=29/04/2024 00:00:00 Param Type = n new_purpose_group=19973000000612 Param Type = c new_purpose_code=120 Param Type = c court_code=10006 Param Type = c docid=100062019/7716 Param Type = c court_name=11599000000000 Param Type = c puname=jainpriti Param Type = c bench_code=15 Param Type = c case_no=2019/7716 Param Type = n trn_bor_caseid=19223000003869 Param Type = n trn_bor_hearingrow=34 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,court_code,docid,court_name,puname,manual_case_no,bench_code,case_no,trn_bor_caseid,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:docid,:court_name,:puname,null,:bench_code,:case_no,:trn_bor_caseid,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 35 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 17142000008281 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 4 prev_hear_date = 08/04/2024 prev_purpose_code = 122 new_case_purpose = 0 next_hear_date = 12/08/2024 new_purpose_group = 0 new_purpose_code = court_code = 10006 docid = 100062019/7814 puname = jainpriti court_name = 11599000000000 manual_case_no = bench_code = 15 case_no = 2019/7814 trn_bor_caseid = 12829000003138 TRN_BOR_HEARINGrow = 35 Posting record Param Type = n trn_bor_hearingid=17142000008281 Param Type = n trn_bor_mhearingid=17142000008246 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=jainpriti Param Type = c createdon=09/04/2024 11:19:09 Param Type = c username=jainpriti Param Type = c modifiedon=09/04/2024 11:19:09 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_hear_date=08/04/2024 00:00:00 Param Type = c prev_purpose_code=122 Param Type = c new_case_purpose=0 Param Type = c next_hear_date=12/08/2024 00:00:00 Param Type = n new_purpose_group=0 Param Type = c court_code=10006 Param Type = c docid=100062019/7814 Param Type = c puname=jainpriti Param Type = c court_name=11599000000000 Param Type = c bench_code=15 Param Type = c case_no=2019/7814 Param Type = n trn_bor_caseid=12829000003138 Param Type = n trn_bor_hearingrow=35 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,court_code,docid,puname,court_name,manual_case_no,bench_code,case_no,trn_bor_caseid,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,null,:court_code,:docid,:puname,:court_name,null,:bench_code,:case_no,:trn_bor_caseid,:trn_bor_hearingrow) Error : Select sysdate as sdt from dual Time elapsed = 2 insert into axerrorlog values('jainpriti',to_date('09/04/2024 11:19:10','dd/mm/yyyy hh24:mi:ss'),'bocup','SaveData','') Time elapsed = 130 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=jainpriti Param Type = c calledon=09/04/2024 11:18:50 Param Type = c callfinished=09/04/2024 11:18:54 Param Type = c structname=bocup Param Type = n recordid=0 Param Type = c servicename=Saving data Param Type = c serviceresult=ORA-02291: integrity constraint (GCMS.FK_NEW_CASE_PURPOSE_BORDF) violated - parent key not found Param Type = n timetaken=4813 Param Type = n dbtimetaken=3151 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