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 gcmsPOOJAMEENA827ccb0eea8a706c4c34a16891f84e7bbocup00115990000000001000606/10/2025R?????? ?????15ALL000POOJAMEENA1159900000000010006100062024/53442024/53441847200000970315???????? ????????? ????12006/10/202513/10/202510107000000777120199730000006120POOJAMEENA1159900000000010006100062024/53552024/53551912700000786015?????? ????? ????12206/10/202519/01/202610110000000719122199710000006020POOJAMEENA1159900000000010006100062024/54392024/54391995600000964015???.20106/10/202519/01/202610189000000601201199680000005910POOJAMEENA1159900000000010006100062024/56692024/56691771000000808415?????? ????? ????12206/10/202510/10/202510110000000719122199710000006020POOJAMEENA1159900000000010006100062024/56702024/56701776300000947915???????? ????????? ????12006/10/202510/10/202510107000000777120199730000006120POOJAMEENA1159900000000010006100062024/58762024/58761400100000922915?????? ????? ????12206/10/202517/12/202510110000000719122199710000006020POOJAMEENA1159900000000010006100062024/60692024/60691681700001076315?????? ?????11206/10/202509/10/202510035000000979112199710000006020POOJAMEENA1159900000000010006100062024/61192024/61191712400000986915?????? ????? ????12206/10/202528/10/202510110000000719122199710000006020POOJAMEENA1159900000000010006100062024/61432024/61431577400000965815???????? ????????? ????12006/10/202513/10/202510107000000777120199730000006120POOJAMEENA1159900000000010006100062024/61482024/61481599500000929715???.20106/10/202514/10/202510189000000601201199680000005910POOJAMEENA1159900000000010006100062024/61872024/61871685000001025215???????? ????????? ????12006/10/202528/10/202510107000000777120199730000006120POOJAMEENA1159900000000010006100062024/65682024/65681743200000942015?????? ????? ????12206/10/202519/01/202610110000000719122199710000006020POOJAMEENA1159900000000010006100062024/65692024/65691747300000920215???????? ????????? ????12006/10/202517/11/202510107000000777120199730000006120POOJAMEENA1159900000000010006100062024/65712024/65711752400000877915?????? ????? ????12206/10/202519/01/202610110000000719122199710000006020POOJAMEENA1159900000000010006100062024/67162024/67161567900000903015?????? ????? ????12206/10/202527/10/202510110000000719122199710000006020POOJAMEENA1159900000000010006100062024/68652024/68651994800000978715???????? ????????? ????12006/10/202517/11/202510107000000777120199730000006120POOJAMEENA1159900000000010006100062024/71512024/71511966000000920515?????? ????? ????? ???? 17206/10/202519/01/202610185000000802172199710000006020POOJAMEENA1159900000000010006100062024/72562024/72561106000000901115?????? ????? ????12206/10/202519/01/202610110000000719122199710000006020POOJAMEENA1159900000000010006100062024/73012024/73011364700000969815?????? ????? ????12206/10/202519/01/202610110000000719122199710000006020POOJAMEENA1159900000000010006100062024/73092024/73091420900000884515?????? ????? ????12206/10/202519/01/202610110000000719122199710000006020POOJAMEENA1159900000000010006100062024/73272024/73271657500000859615?????? ????? ????12206/10/202506/11/202510110000000719122199710000006020POOJAMEENA1159900000000010006100062024/73882024/73881420600000899215?????? ????? ????12206/10/202517/10/202510110000000719122199710000006020POOJAMEENA1159900000000010006100062024/75022024/75021289500000941115?????? ????? ????12206/10/202506/11/202510110000000719122199710000006020POOJAMEENA1159900000000010006100062024/75372024/75371220100000858315?????? ????? ????12206/10/202519/01/202610110000000719122199710000006020POOJAMEENA1159900000000010006100062024/75622024/75621050600000847215?????? ????? ????12206/10/202519/01/202610110000000719122199710000006020POOJAMEENA1159900000000010006100062024/75952024/75951241800000973215?????? ????? ????12206/10/202519/01/202610110000000719122199710000006020POOJAMEENA1159900000000010006100062024/76322024/76321624900000921415?????? ????? ????12206/10/202515/10/202510110000000719122199710000006020POOJAMEENA1159900000000010006100062024/76682024/76681412100000869015?????? ????? ????12206/10/202519/01/20261011000000071912219971000000602 Executing Savedata webservice ----------------------------- Received JSON : {"savedata":{"axpapp":"gcms","username":"POOJAMEENA","password":"827ccb0eea8a706c4c34a16891f84e7b","seed":"","s":"","transid":"bocup","recordid":"0","recdata":[{"axp_recid1":[{"rowno":"001","text":"0","columns":{"courtname":"11599000000000","courtcode":"10006","cldate":"06/10/2025","cltype":"R","benchname":"?????? ?????","benchcode":"15","cluser":"ALL","bench_mem1":"0","bench_mem2":"0"}}]},{"axp_recid2":[{"rowno":"001","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/5344","case_no":"2024/5344","trn_bor_caseid":"18472000009703","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"06/10/2025","next_hear_date":"13/10/2025","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"002","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/5355","case_no":"2024/5355","trn_bor_caseid":"19127000007860","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"19/01/2026","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"003","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/5439","case_no":"2024/5439","trn_bor_caseid":"19956000009640","manual_case_no":"","bench_code":"15","prev_case_purpose":"???.","prev_purpose_code":"201","prev_hear_date":"06/10/2025","next_hear_date":"19/01/2026","new_case_purpose":"10189000000601","new_purpose_code":"201","new_purpose_group":"19968000000591"}},{"rowno":"004","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/5669","case_no":"2024/5669","trn_bor_caseid":"17710000008084","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"10/10/2025","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"005","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/5670","case_no":"2024/5670","trn_bor_caseid":"17763000009479","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"06/10/2025","next_hear_date":"10/10/2025","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"006","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/5876","case_no":"2024/5876","trn_bor_caseid":"14001000009229","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"17/12/2025","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"007","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/6069","case_no":"2024/6069","trn_bor_caseid":"16817000010763","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ?????","prev_purpose_code":"112","prev_hear_date":"06/10/2025","next_hear_date":"09/10/2025","new_case_purpose":"10035000000979","new_purpose_code":"112","new_purpose_group":"19971000000602"}},{"rowno":"008","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/6119","case_no":"2024/6119","trn_bor_caseid":"17124000009869","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"28/10/2025","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"009","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/6143","case_no":"2024/6143","trn_bor_caseid":"15774000009658","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"06/10/2025","next_hear_date":"13/10/2025","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"0010","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/6148","case_no":"2024/6148","trn_bor_caseid":"15995000009297","manual_case_no":"","bench_code":"15","prev_case_purpose":"???.","prev_purpose_code":"201","prev_hear_date":"06/10/2025","next_hear_date":"14/10/2025","new_case_purpose":"10189000000601","new_purpose_code":"201","new_purpose_group":"19968000000591"}},{"rowno":"0011","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/6187","case_no":"2024/6187","trn_bor_caseid":"16850000010252","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"06/10/2025","next_hear_date":"28/10/2025","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"0012","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/6568","case_no":"2024/6568","trn_bor_caseid":"17432000009420","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"19/01/2026","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0013","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/6569","case_no":"2024/6569","trn_bor_caseid":"17473000009202","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"06/10/2025","next_hear_date":"17/11/2025","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"0014","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/6571","case_no":"2024/6571","trn_bor_caseid":"17524000008779","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"19/01/2026","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0015","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/6716","case_no":"2024/6716","trn_bor_caseid":"15679000009030","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"27/10/2025","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0016","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/6865","case_no":"2024/6865","trn_bor_caseid":"19948000009787","manual_case_no":"","bench_code":"15","prev_case_purpose":"???????? ????????? ????","prev_purpose_code":"120","prev_hear_date":"06/10/2025","next_hear_date":"17/11/2025","new_case_purpose":"10107000000777","new_purpose_code":"120","new_purpose_group":"19973000000612"}},{"rowno":"0017","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/7151","case_no":"2024/7151","trn_bor_caseid":"19660000009205","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????? ???? ","prev_purpose_code":"172","prev_hear_date":"06/10/2025","next_hear_date":"19/01/2026","new_case_purpose":"10185000000802","new_purpose_code":"172","new_purpose_group":"19971000000602"}},{"rowno":"0018","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/7256","case_no":"2024/7256","trn_bor_caseid":"11060000009011","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"19/01/2026","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0019","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/7301","case_no":"2024/7301","trn_bor_caseid":"13647000009698","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"19/01/2026","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0020","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/7309","case_no":"2024/7309","trn_bor_caseid":"14209000008845","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"19/01/2026","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0021","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/7327","case_no":"2024/7327","trn_bor_caseid":"16575000008596","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"06/11/2025","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0022","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/7388","case_no":"2024/7388","trn_bor_caseid":"14206000008992","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"17/10/2025","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0023","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/7502","case_no":"2024/7502","trn_bor_caseid":"12895000009411","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"06/11/2025","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0024","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/7537","case_no":"2024/7537","trn_bor_caseid":"12201000008583","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"19/01/2026","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0025","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/7562","case_no":"2024/7562","trn_bor_caseid":"10506000008472","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"19/01/2026","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0026","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/7595","case_no":"2024/7595","trn_bor_caseid":"12418000009732","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"19/01/2026","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0027","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/7632","case_no":"2024/7632","trn_bor_caseid":"16249000009214","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"15/10/2025","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}},{"rowno":"0028","text":"0","columns":{"puname":"POOJAMEENA","court_name":"11599000000000","court_code":"10006","docid":"100062024/7668","case_no":"2024/7668","trn_bor_caseid":"14121000008690","manual_case_no":"","bench_code":"15","prev_case_purpose":"?????? ????? ????","prev_purpose_code":"122","prev_hear_date":"06/10/2025","next_hear_date":"19/01/2026","new_case_purpose":"10110000000719","new_purpose_code":"122","new_purpose_group":"19971000000602"}}]}]}} Verifying username and password User Name : POOJAMEENA Select a.*, b.maxlogintry from AXUSERS a , axprops b WHERE lower(a.USERNAME) = :U and b.name = 'app' U=poojameena Time elapsed = 22 Password checking along with max.no of login specified in app.xml update axusers set logintry = 0 where lower(username) = :U Time elapsed = 7 Result : Verifying completed... Page Access Category : User Name : poojameena Select sysdate as sdt from dual Time elapsed = 2 dt=07/10/2025 13:26:15 Select sysdate as sdt from dual Time elapsed = 2 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=poojameena dt=07/10/2025 13:26:15 dt=07/10/2025 13:26:15 Time elapsed = 9 User Groups: rb_fbroom,bor_talbi select userroles from axusergroups where groupname in ( 'rb_fbroom','bor_talbi' ) Time elapsed = 14 User Roles : bor_talbi,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 = 3 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=POOJAMEENA select a.court_name from v_axcourts a where a.PAXUSERNAME = :username order by 1 username=POOJAMEENA Time elapsed = 5 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=POOJAMEENA select a.court_type from v_axcourts a where a.paxusername= :username order by 1 username=POOJAMEENA Time elapsed = 4 Result of firesql = Result = Evaluating sqlget({m3},{court_type}) Calling function sqlget Result of sqlget = Revenue Board Result = Revenue Board Evaluating firesql({m4},{select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1}) Calling function firesql username=POOJAMEENA select a.court_name_mastid from v_axcourts a where a.paxusername = :username order by 1 username=POOJAMEENA Time elapsed = 4 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=POOJAMEENA Time elapsed = 4 Result of firesql = Result = Evaluating sqlget({m4},{axusersid}) Calling function sqlget Result of sqlget = 1686550007217 Result = 1686550007217 Evaluating firesql({m4},{select :username as uname from dual}) Calling function firesql select :username as uname from dual username=POOJAMEENA Time elapsed = 3 Result of firesql = Result = Evaluating sqlget({m4},{uname}) Calling function sqlget Result of sqlget = POOJAMEENA Result = POOJAMEENA 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=POOJAMEENA Time elapsed = 3 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 = 3 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=POOJAMEENA SELECT INITCAP (TRIM (A.DISTNAMEENG)) AS DISTNAMEENG FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=POOJAMEENA Time elapsed = 3 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=POOJAMEENA SELECT A.COURT_CATEGOTY FROM v_axcourts a WHERE A.PAXUSERNAME = :username ORDER BY 1 username=POOJAMEENA Time elapsed = 3 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=1686550007217 select b.department_mastid from axcourts a,department_mast b where a.deptname=b.department_mastid and A.AXUSERSID=:login_userid login_userid=1686550007217 Time elapsed = 8 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=POOJAMEENA Time elapsed = 4 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=POOJAMEENA 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=POOJAMEENA Time elapsed = 6 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 = 3 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=POOJAMEENA 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=POOJAMEENA Time elapsed = 20 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 ('bor_talbi','rb_fbroom') and lower(sname)='bocup' and stype = 't' ) Time elapsed = 2 select Props from axuseraccess where lower(rname)='bor_talbi' and lower(sname)='bocup' and stype = 't' Time elapsed = 6 select Props from axuseraccess where lower(rname)='rb_fbroom' and lower(sname)='bocup' and stype = 't' Time elapsed = 6 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 = 3 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 = 5 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 = 3 select * from trn_bor_mhearing where trn_bor_mhearingid=0 Time elapsed = 3 select * from Axusers where 1=2 Time elapsed = 6 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 = 2 select trn_bor_caseregid from trn_bor_casereg where trn_bor_caseregid=0 Time elapsed = 2 select hearingdate from trn_bor_casereg where trn_bor_caseregid=0 Time elapsed = 2 select distinct(schemaname) from axschema where lower(transid)='rbcrt' Time elapsed = 2 select case_purpose_name from trn_bor_casereg where trn_bor_caseregid=0 Time elapsed = 1 select distinct(schemaname) from axschema where lower(transid)='rbcrt' Time elapsed = 2 select case_purpose_code from trn_bor_casereg where trn_bor_caseregid=0 Time elapsed = 3 Step3 Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : rbchh ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno Time elapsed = 13 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 = 4 select * from trn_bor_case_hist where trn_bor_case_histid=0 Time elapsed = 6 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 = 06/10/2025 cltype = R benchname = ?????? ????? benchcode = 15 cluser = ALL bench_mem1 = 0 bench_mem2 = 0 time zone difference = 0 >>Writing to tables bocup Select * FROM Sequence WHERE lower(TRANSTYPE) = 'bocup' Time elapsed = 2 Saving to table TRN_BOR_MHEARING select * from TRN_BOR_MHEARING where TRN_BOR_MHEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 12467000010803 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 4 cluser = ALL benchcode = 15 bench_mem2 = 0 bench_mem1 = 0 benchname = ?????? ????? courtcode = 10006 courtname = 11599000000000 cltype = R cldate = 06/10/2025 Posting record Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:15 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:15 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c cluser=ALL 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=06/10/2025 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 = 16 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 = 12467000010804 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 case_no = 2024/5344 docid = 100062024/5344 court_code = 10006 new_case_purpose = 10107000000777 prev_hear_date = 06/10/2025 next_hear_date = 13/10/2025 new_purpose_code = 120 new_purpose_group = 19973000000612 prev_purpose_code = 120 manual_case_no = trn_bor_caseid = 18472000009703 bench_code = 15 puname = POOJAMEENA court_name = 11599000000000 TRN_BOR_HEARINGrow = 1 Posting record Param Type = n trn_bor_hearingid=12467000010804 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:15 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:15 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2024/5344 Param Type = c docid=100062024/5344 Param Type = c court_code=10006 Param Type = c new_case_purpose=10107000000777 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c next_hear_date=13/10/2025 00:00:00 Param Type = c new_purpose_code=120 Param Type = n new_purpose_group=19973000000612 Param Type = c prev_purpose_code=120 Param Type = n trn_bor_caseid=18472000009703 Param Type = c bench_code=15 Param Type = c puname=POOJAMEENA Param Type = c court_name=11599000000000 Param Type = n trn_bor_hearingrow=1 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,docid,court_code,new_case_purpose,prev_hear_date,next_hear_date,new_purpose_code,new_purpose_group,prev_purpose_code,manual_case_no,trn_bor_caseid,bench_code,puname,court_name,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:docid,:court_code,: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_code,:new_purpose_group,:prev_purpose_code,null,:trn_bor_caseid,:bench_code,:puname,:court_name,: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 2 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010805 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 case_no = 2024/5355 trn_bor_caseid = 19127000007860 manual_case_no = docid = 100062024/5355 puname = POOJAMEENA court_name = 11599000000000 court_code = 10006 new_purpose_code = 122 new_purpose_group = 19971000000602 next_hear_date = 19/01/2026 new_case_purpose = 10110000000719 bench_code = 15 prev_purpose_code = 122 prev_hear_date = 06/10/2025 TRN_BOR_HEARINGrow = 2 Posting record Param Type = n trn_bor_hearingid=12467000010805 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:15 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:15 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2024/5355 Param Type = n trn_bor_caseid=19127000007860 Param Type = c docid=100062024/5355 Param Type = c puname=POOJAMEENA 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=19/01/2026 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=06/10/2025 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 = 15 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 = 12467000010806 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 2 case_no = 2024/5439 trn_bor_caseid = 19956000009640 manual_case_no = docid = 100062024/5439 puname = POOJAMEENA court_name = 11599000000000 court_code = 10006 new_purpose_code = 201 new_purpose_group = 19968000000591 next_hear_date = 19/01/2026 new_case_purpose = 10189000000601 bench_code = 15 prev_purpose_code = 201 prev_hear_date = 06/10/2025 TRN_BOR_HEARINGrow = 3 Posting record Param Type = n trn_bor_hearingid=12467000010806 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:15 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:15 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2024/5439 Param Type = n trn_bor_caseid=19956000009640 Param Type = c docid=100062024/5439 Param Type = c puname=POOJAMEENA Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c new_purpose_code=201 Param Type = n new_purpose_group=19968000000591 Param Type = c next_hear_date=19/01/2026 00:00:00 Param Type = c new_case_purpose=10189000000601 Param Type = c bench_code=15 Param Type = c prev_purpose_code=201 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = n trn_bor_hearingrow=3 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 4 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 12467000010807 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 15 Select sysdate as sdt from dual Time elapsed = 4 prev_hear_date = 06/10/2025 prev_purpose_code = 122 bench_code = 15 new_case_purpose = 10110000000719 next_hear_date = 10/10/2025 new_purpose_group = 19971000000602 new_purpose_code = 122 court_code = 10006 court_name = 11599000000000 puname = POOJAMEENA docid = 100062024/5669 manual_case_no = trn_bor_caseid = 17710000008084 case_no = 2024/5669 TRN_BOR_HEARINGrow = 4 Posting record Param Type = n trn_bor_hearingid=12467000010807 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:15 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:15 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_hear_date=06/10/2025 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=10/10/2025 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=POOJAMEENA Param Type = c docid=100062024/5669 Param Type = n trn_bor_caseid=17710000008084 Param Type = c case_no=2024/5669 Param Type = n trn_bor_hearingrow=4 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,bench_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,court_code,court_name,puname,docid,manual_case_no,trn_bor_caseid,case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:bench_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:court_name,:puname,:docid,null,:trn_bor_caseid,:case_no,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 5 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 12467000010808 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 case_no = 2024/5670 trn_bor_caseid = 17763000009479 manual_case_no = docid = 100062024/5670 puname = POOJAMEENA court_name = 11599000000000 court_code = 10006 new_purpose_group = 19973000000612 next_hear_date = 10/10/2025 prev_purpose_code = 120 new_purpose_code = 120 bench_code = 15 prev_hear_date = 06/10/2025 new_case_purpose = 10107000000777 TRN_BOR_HEARINGrow = 5 Posting record Param Type = n trn_bor_hearingid=12467000010808 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:15 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:15 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2024/5670 Param Type = n trn_bor_caseid=17763000009479 Param Type = c docid=100062024/5670 Param Type = c puname=POOJAMEENA Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = n new_purpose_group=19973000000612 Param Type = c next_hear_date=10/10/2025 00:00:00 Param Type = c prev_purpose_code=120 Param Type = c new_purpose_code=120 Param Type = c bench_code=15 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c new_case_purpose=10107000000777 Param Type = n trn_bor_hearingrow=5 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_group,next_hear_date,prev_purpose_code,new_purpose_code,bench_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,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_purpose_code,:bench_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 = 3 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 = 12467000010809 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 court_code = 10006 docid = 100062024/5876 puname = POOJAMEENA court_name = 11599000000000 case_no = 2024/5876 new_purpose_code = 122 new_case_purpose = 10110000000719 next_hear_date = 17/12/2025 new_purpose_group = 19971000000602 prev_hear_date = 06/10/2025 manual_case_no = trn_bor_caseid = 14001000009229 prev_purpose_code = 122 bench_code = 15 TRN_BOR_HEARINGrow = 6 Posting record Param Type = n trn_bor_hearingid=12467000010809 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:15 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:15 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c court_code=10006 Param Type = c docid=100062024/5876 Param Type = c puname=POOJAMEENA Param Type = c court_name=11599000000000 Param Type = c case_no=2024/5876 Param Type = c new_purpose_code=122 Param Type = c new_case_purpose=10110000000719 Param Type = c next_hear_date=17/12/2025 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = n trn_bor_caseid=14001000009229 Param Type = c prev_purpose_code=122 Param Type = c bench_code=15 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,court_code,docid,puname,court_name,case_no,new_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,prev_hear_date,manual_case_no,trn_bor_caseid,prev_purpose_code,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,:court_code,:docid,:puname,:court_name,:case_no,:new_purpose_code,:new_case_purpose,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'),null,:trn_bor_caseid,:prev_purpose_code,:bench_code,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 3 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 = 12467000010810 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 13 Select sysdate as sdt from dual Time elapsed = 2 manual_case_no = bench_code = 15 trn_bor_caseid = 16817000010763 puname = POOJAMEENA case_no = 2024/6069 prev_purpose_code = 112 next_hear_date = 09/10/2025 new_purpose_group = 19971000000602 new_purpose_code = 112 prev_hear_date = 06/10/2025 new_case_purpose = 10035000000979 docid = 100062024/6069 court_code = 10006 court_name = 11599000000000 TRN_BOR_HEARINGrow = 7 Posting record Param Type = n trn_bor_hearingid=12467000010810 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:15 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:15 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c bench_code=15 Param Type = n trn_bor_caseid=16817000010763 Param Type = c puname=POOJAMEENA Param Type = c case_no=2024/6069 Param Type = c prev_purpose_code=112 Param Type = c next_hear_date=09/10/2025 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c new_purpose_code=112 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c new_case_purpose=10035000000979 Param Type = c docid=100062024/6069 Param Type = c court_code=10006 Param Type = c court_name=11599000000000 Param Type = n trn_bor_hearingrow=7 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,manual_case_no,bench_code,trn_bor_caseid,puname,case_no,prev_purpose_code,next_hear_date,new_purpose_group,new_purpose_code,prev_hear_date,new_case_purpose,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,null,:bench_code,:trn_bor_caseid,:puname,:case_no,:prev_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:docid,:court_code,:court_name,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 3 Adding new record to store data from Frame 2, Row 8 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010811 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 13 court_code = 10006 prev_purpose_code = 122 prev_hear_date = 06/10/2025 court_name = 11599000000000 bench_code = 15 manual_case_no = puname = POOJAMEENA trn_bor_caseid = 17124000009869 new_purpose_group = 19971000000602 next_hear_date = 28/10/2025 docid = 100062024/6119 new_case_purpose = 10110000000719 case_no = 2024/6119 new_purpose_code = 122 TRN_BOR_HEARINGrow = 8 Posting record Param Type = n trn_bor_hearingid=12467000010811 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:15 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:15 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c court_code=10006 Param Type = c prev_purpose_code=122 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c court_name=11599000000000 Param Type = c bench_code=15 Param Type = c puname=POOJAMEENA Param Type = n trn_bor_caseid=17124000009869 Param Type = n new_purpose_group=19971000000602 Param Type = c next_hear_date=28/10/2025 00:00:00 Param Type = c docid=100062024/6119 Param Type = c new_case_purpose=10110000000719 Param Type = c case_no=2024/6119 Param Type = c new_purpose_code=122 Param Type = n trn_bor_hearingrow=8 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_code,prev_purpose_code,prev_hear_date,court_name,bench_code,manual_case_no,puname,trn_bor_caseid,new_purpose_group,next_hear_date,docid,new_case_purpose,case_no,new_purpose_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_name,:bench_code,null,:puname,:trn_bor_caseid,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:docid,:new_case_purpose,:case_no,:new_purpose_code,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 5 Adding new record to store data from Frame 2, Row 9 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 12467000010812 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 case_no = 2024/6143 trn_bor_caseid = 15774000009658 manual_case_no = docid = 100062024/6143 puname = POOJAMEENA court_name = 11599000000000 court_code = 10006 new_purpose_code = 120 new_purpose_group = 19973000000612 next_hear_date = 13/10/2025 new_case_purpose = 10107000000777 bench_code = 15 prev_purpose_code = 120 prev_hear_date = 06/10/2025 TRN_BOR_HEARINGrow = 9 Posting record Param Type = n trn_bor_hearingid=12467000010812 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:15 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:15 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2024/6143 Param Type = n trn_bor_caseid=15774000009658 Param Type = c docid=100062024/6143 Param Type = c puname=POOJAMEENA 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=13/10/2025 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=06/10/2025 00:00:00 Param Type = n trn_bor_hearingrow=9 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 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 = 12467000010813 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 4 case_no = 2024/6148 trn_bor_caseid = 15995000009297 manual_case_no = docid = 100062024/6148 puname = POOJAMEENA court_name = 11599000000000 court_code = 10006 new_purpose_code = 201 new_purpose_group = 19968000000591 next_hear_date = 14/10/2025 new_case_purpose = 10189000000601 bench_code = 15 prev_purpose_code = 201 prev_hear_date = 06/10/2025 TRN_BOR_HEARINGrow = 10 Posting record Param Type = n trn_bor_hearingid=12467000010813 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:15 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:15 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c case_no=2024/6148 Param Type = n trn_bor_caseid=15995000009297 Param Type = c docid=100062024/6148 Param Type = c puname=POOJAMEENA Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c new_purpose_code=201 Param Type = n new_purpose_group=19968000000591 Param Type = c next_hear_date=14/10/2025 00:00:00 Param Type = c new_case_purpose=10189000000601 Param Type = c bench_code=15 Param Type = c prev_purpose_code=201 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = n trn_bor_hearingrow=10 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,case_no,trn_bor_caseid,manual_case_no,docid,puname,court_name,court_code,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:case_no,:trn_bor_caseid,null,:docid,:puname,:court_name,:court_code,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 11 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010814 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 5 prev_hear_date = 06/10/2025 prev_purpose_code = 120 bench_code = 15 new_case_purpose = 10107000000777 next_hear_date = 28/10/2025 new_purpose_group = 19973000000612 new_purpose_code = 120 court_code = 10006 court_name = 11599000000000 puname = POOJAMEENA docid = 100062024/6187 manual_case_no = trn_bor_caseid = 16850000010252 case_no = 2024/6187 TRN_BOR_HEARINGrow = 11 Posting record Param Type = n trn_bor_hearingid=12467000010814 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_hear_date=06/10/2025 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=28/10/2025 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=POOJAMEENA Param Type = c docid=100062024/6187 Param Type = n trn_bor_caseid=16850000010252 Param Type = c case_no=2024/6187 Param Type = n trn_bor_hearingrow=11 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_hear_date,prev_purpose_code,bench_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,court_code,court_name,puname,docid,manual_case_no,trn_bor_caseid,case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:bench_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:court_name,:puname,:docid,null,:trn_bor_caseid,:case_no,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 16 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 = 12467000010815 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 court_name = 11599000000000 puname = POOJAMEENA new_case_purpose = 10110000000719 prev_hear_date = 06/10/2025 prev_purpose_code = 122 next_hear_date = 19/01/2026 new_purpose_group = 19971000000602 new_purpose_code = 122 trn_bor_caseid = 17432000009420 case_no = 2024/6568 docid = 100062024/6568 court_code = 10006 bench_code = 15 manual_case_no = TRN_BOR_HEARINGrow = 12 Posting record Param Type = n trn_bor_hearingid=12467000010815 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c court_name=11599000000000 Param Type = c puname=POOJAMEENA Param Type = c new_case_purpose=10110000000719 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c prev_purpose_code=122 Param Type = c next_hear_date=19/01/2026 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c new_purpose_code=122 Param Type = n trn_bor_caseid=17432000009420 Param Type = c case_no=2024/6568 Param Type = c docid=100062024/6568 Param Type = c court_code=10006 Param Type = c bench_code=15 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,court_name,puname,new_case_purpose,prev_hear_date,prev_purpose_code,next_hear_date,new_purpose_group,new_purpose_code,trn_bor_caseid,case_no,docid,court_code,bench_code,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_name,:puname,:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:trn_bor_caseid,:case_no,:docid,:court_code,:bench_code,null,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 13 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010816 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 puname = POOJAMEENA bench_code = 15 docid = 100062024/6569 prev_purpose_code = 120 case_no = 2024/6569 trn_bor_caseid = 17473000009202 manual_case_no = prev_hear_date = 06/10/2025 next_hear_date = 17/11/2025 court_code = 10006 court_name = 11599000000000 new_case_purpose = 10107000000777 new_purpose_code = 120 new_purpose_group = 19973000000612 TRN_BOR_HEARINGrow = 13 Posting record Param Type = n trn_bor_hearingid=12467000010816 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c puname=POOJAMEENA Param Type = c bench_code=15 Param Type = c docid=100062024/6569 Param Type = c prev_purpose_code=120 Param Type = c case_no=2024/6569 Param Type = n trn_bor_caseid=17473000009202 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c next_hear_date=17/11/2025 00:00:00 Param Type = c court_code=10006 Param Type = c court_name=11599000000000 Param Type = c new_case_purpose=10107000000777 Param Type = c new_purpose_code=120 Param Type = n new_purpose_group=19973000000612 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,puname,bench_code,docid,prev_purpose_code,case_no,trn_bor_caseid,manual_case_no,prev_hear_date,next_hear_date,court_code,court_name,new_case_purpose,new_purpose_code,new_purpose_group,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:puname,:bench_code,:docid,:prev_purpose_code,:case_no,:trn_bor_caseid,null,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:court_name,:new_case_purpose,:new_purpose_code,:new_purpose_group,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 14 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 12467000010817 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 court_name = 11599000000000 next_hear_date = 19/01/2026 court_code = 10006 puname = POOJAMEENA prev_hear_date = 06/10/2025 prev_purpose_code = 122 new_case_purpose = 10110000000719 manual_case_no = bench_code = 15 new_purpose_code = 122 trn_bor_caseid = 17524000008779 docid = 100062024/6571 case_no = 2024/6571 new_purpose_group = 19971000000602 TRN_BOR_HEARINGrow = 14 Posting record Param Type = n trn_bor_hearingid=12467000010817 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c court_name=11599000000000 Param Type = c next_hear_date=19/01/2026 00:00:00 Param Type = c court_code=10006 Param Type = c puname=POOJAMEENA Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c prev_purpose_code=122 Param Type = c new_case_purpose=10110000000719 Param Type = c bench_code=15 Param Type = c new_purpose_code=122 Param Type = n trn_bor_caseid=17524000008779 Param Type = c docid=100062024/6571 Param Type = c case_no=2024/6571 Param Type = n new_purpose_group=19971000000602 Param Type = n trn_bor_hearingrow=14 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,court_name,next_hear_date,court_code,puname,prev_hear_date,prev_purpose_code,new_case_purpose,manual_case_no,bench_code,new_purpose_code,trn_bor_caseid,docid,case_no,new_purpose_group,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:court_name,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_code,:puname,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_case_purpose,null,:bench_code,:new_purpose_code,:trn_bor_caseid,:docid,:case_no,:new_purpose_group,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 15 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010818 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 next_hear_date = 27/10/2025 docid = 100062024/6716 case_no = 2024/6716 trn_bor_caseid = 15679000009030 puname = POOJAMEENA court_name = 11599000000000 court_code = 10006 manual_case_no = new_case_purpose = 10110000000719 new_purpose_code = 122 new_purpose_group = 19971000000602 bench_code = 15 prev_purpose_code = 122 prev_hear_date = 06/10/2025 TRN_BOR_HEARINGrow = 15 Posting record Param Type = n trn_bor_hearingid=12467000010818 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=27/10/2025 00:00:00 Param Type = c docid=100062024/6716 Param Type = c case_no=2024/6716 Param Type = n trn_bor_caseid=15679000009030 Param Type = c puname=POOJAMEENA Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c new_case_purpose=10110000000719 Param Type = c new_purpose_code=122 Param Type = n new_purpose_group=19971000000602 Param Type = c bench_code=15 Param Type = c prev_purpose_code=122 Param Type = c prev_hear_date=06/10/2025 00:00:00 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,next_hear_date,docid,case_no,trn_bor_caseid,puname,court_name,court_code,manual_case_no,new_case_purpose,new_purpose_code,new_purpose_group,bench_code,prev_purpose_code,prev_hear_date,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:docid,:case_no,:trn_bor_caseid,:puname,:court_name,:court_code,null,:new_case_purpose,:new_purpose_code,:new_purpose_group,:bench_code,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 16 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010819 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 next_hear_date = 17/11/2025 new_purpose_code = 120 bench_code = 15 manual_case_no = new_case_purpose = 10107000000777 prev_hear_date = 06/10/2025 prev_purpose_code = 120 trn_bor_caseid = 19948000009787 court_name = 11599000000000 puname = POOJAMEENA new_purpose_group = 19973000000612 case_no = 2024/6865 docid = 100062024/6865 court_code = 10006 TRN_BOR_HEARINGrow = 16 Posting record Param Type = n trn_bor_hearingid=12467000010819 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=17/11/2025 00:00:00 Param Type = c new_purpose_code=120 Param Type = c bench_code=15 Param Type = c new_case_purpose=10107000000777 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c prev_purpose_code=120 Param Type = n trn_bor_caseid=19948000009787 Param Type = c court_name=11599000000000 Param Type = c puname=POOJAMEENA Param Type = n new_purpose_group=19973000000612 Param Type = c case_no=2024/6865 Param Type = c docid=100062024/6865 Param Type = c court_code=10006 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,next_hear_date,new_purpose_code,bench_code,manual_case_no,new_case_purpose,prev_hear_date,prev_purpose_code,trn_bor_caseid,court_name,puname,new_purpose_group,case_no,docid,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,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_code,:bench_code,null,:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:trn_bor_caseid,:court_name,:puname,:new_purpose_group,:case_no,:docid,:court_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 17 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 12467000010820 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 next_hear_date = 19/01/2026 new_purpose_group = 19971000000602 docid = 100062024/7151 case_no = 2024/7151 trn_bor_caseid = 19660000009205 puname = POOJAMEENA court_name = 11599000000000 court_code = 10006 prev_hear_date = 06/10/2025 new_case_purpose = 10185000000802 new_purpose_code = 172 manual_case_no = bench_code = 15 prev_purpose_code = 172 TRN_BOR_HEARINGrow = 17 Posting record Param Type = n trn_bor_hearingid=12467000010820 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c next_hear_date=19/01/2026 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c docid=100062024/7151 Param Type = c case_no=2024/7151 Param Type = n trn_bor_caseid=19660000009205 Param Type = c puname=POOJAMEENA Param Type = c court_name=11599000000000 Param Type = c court_code=10006 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c new_case_purpose=10185000000802 Param Type = c new_purpose_code=172 Param Type = c bench_code=15 Param Type = c prev_purpose_code=172 Param Type = n trn_bor_hearingrow=17 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,next_hear_date,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 = 14 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 = 2 RecordId = 12467000010821 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 new_purpose_group = 19971000000602 next_hear_date = 19/01/2026 court_code = 10006 docid = 100062024/7256 case_no = 2024/7256 puname = POOJAMEENA prev_hear_date = 06/10/2025 court_name = 11599000000000 prev_purpose_code = 122 new_case_purpose = 10110000000719 new_purpose_code = 122 trn_bor_caseid = 11060000009011 manual_case_no = bench_code = 15 TRN_BOR_HEARINGrow = 18 Posting record Param Type = n trn_bor_hearingid=12467000010821 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 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=19/01/2026 00:00:00 Param Type = c court_code=10006 Param Type = c docid=100062024/7256 Param Type = c case_no=2024/7256 Param Type = c puname=POOJAMEENA Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c court_name=11599000000000 Param Type = c prev_purpose_code=122 Param Type = c new_case_purpose=10110000000719 Param Type = c new_purpose_code=122 Param Type = n trn_bor_caseid=11060000009011 Param Type = c bench_code=15 Param Type = n trn_bor_hearingrow=18 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_group,next_hear_date,court_code,docid,case_no,puname,prev_hear_date,court_name,prev_purpose_code,new_case_purpose,new_purpose_code,trn_bor_caseid,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'),:court_code,:docid,:case_no,:puname,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:court_name,:prev_purpose_code,:new_case_purpose,:new_purpose_code,:trn_bor_caseid,null,:bench_code,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 3 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 = 6 RecordId = 12467000010822 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 = 19/01/2026 new_purpose_code = 122 docid = 100062024/7301 case_no = 2024/7301 court_code = 10006 puname = POOJAMEENA court_name = 11599000000000 trn_bor_caseid = 13647000009698 prev_hear_date = 06/10/2025 new_case_purpose = 10110000000719 prev_purpose_code = 122 manual_case_no = bench_code = 15 TRN_BOR_HEARINGrow = 19 Posting record Param Type = n trn_bor_hearingid=12467000010822 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 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=19/01/2026 00:00:00 Param Type = c new_purpose_code=122 Param Type = c docid=100062024/7301 Param Type = c case_no=2024/7301 Param Type = c court_code=10006 Param Type = c puname=POOJAMEENA Param Type = c court_name=11599000000000 Param Type = n trn_bor_caseid=13647000009698 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c new_case_purpose=10110000000719 Param Type = c prev_purpose_code=122 Param Type = c bench_code=15 Param Type = n trn_bor_hearingrow=19 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_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 = 8 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 = 12467000010823 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 14 new_purpose_code = 122 new_purpose_group = 19971000000602 next_hear_date = 19/01/2026 docid = 100062024/7309 case_no = 2024/7309 court_code = 10006 puname = POOJAMEENA court_name = 11599000000000 trn_bor_caseid = 14209000008845 prev_hear_date = 06/10/2025 new_case_purpose = 10110000000719 prev_purpose_code = 122 manual_case_no = bench_code = 15 TRN_BOR_HEARINGrow = 20 Posting record Param Type = n trn_bor_hearingid=12467000010823 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 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=19/01/2026 00:00:00 Param Type = c docid=100062024/7309 Param Type = c case_no=2024/7309 Param Type = c court_code=10006 Param Type = c puname=POOJAMEENA Param Type = c court_name=11599000000000 Param Type = n trn_bor_caseid=14209000008845 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c new_case_purpose=10110000000719 Param Type = c prev_purpose_code=122 Param Type = c bench_code=15 Param Type = n trn_bor_hearingrow=20 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_code,new_purpose_group,next_hear_date,docid,case_no,court_code,puname,court_name,trn_bor_caseid,prev_hear_date,new_case_purpose,prev_purpose_code,manual_case_no,bench_code,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:docid,:case_no,:court_code,:puname,:court_name,:trn_bor_caseid,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:prev_purpose_code,null,:bench_code,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 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 = 5 RecordId = 12467000010824 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_purpose_group = 19971000000602 next_hear_date = 06/11/2025 new_case_purpose = 10110000000719 court_name = 11599000000000 puname = POOJAMEENA court_code = 10006 manual_case_no = docid = 100062024/7327 prev_purpose_code = 122 prev_hear_date = 06/10/2025 bench_code = 15 case_no = 2024/7327 trn_bor_caseid = 16575000008596 TRN_BOR_HEARINGrow = 21 Posting record Param Type = n trn_bor_hearingid=12467000010824 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 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=06/11/2025 00:00:00 Param Type = c new_case_purpose=10110000000719 Param Type = c court_name=11599000000000 Param Type = c puname=POOJAMEENA Param Type = c court_code=10006 Param Type = c docid=100062024/7327 Param Type = c prev_purpose_code=122 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c bench_code=15 Param Type = c case_no=2024/7327 Param Type = n trn_bor_caseid=16575000008596 Param Type = n trn_bor_hearingrow=21 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_code,new_purpose_group,next_hear_date,new_case_purpose,court_name,puname,court_code,manual_case_no,docid,prev_purpose_code,prev_hear_date,bench_code,case_no,trn_bor_caseid,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_purpose_code,:new_purpose_group,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_case_purpose,:court_name,:puname,:court_code,null,:docid,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,:case_no,:trn_bor_caseid,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 15 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 = 2 RecordId = 12467000010825 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 3 new_purpose_code = 122 new_case_purpose = 10110000000719 next_hear_date = 17/10/2025 new_purpose_group = 19971000000602 docid = 100062024/7388 case_no = 2024/7388 court_code = 10006 puname = POOJAMEENA court_name = 11599000000000 prev_purpose_code = 122 prev_hear_date = 06/10/2025 bench_code = 15 trn_bor_caseid = 14206000008992 manual_case_no = TRN_BOR_HEARINGrow = 22 Posting record Param Type = n trn_bor_hearingid=12467000010825 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 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=17/10/2025 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c docid=100062024/7388 Param Type = c case_no=2024/7388 Param Type = c court_code=10006 Param Type = c puname=POOJAMEENA Param Type = c court_name=11599000000000 Param Type = c prev_purpose_code=122 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c bench_code=15 Param Type = n trn_bor_caseid=14206000008992 Param Type = n trn_bor_hearingrow=22 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,docid,case_no,court_code,puname,court_name,prev_purpose_code,prev_hear_date,bench_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:docid,:case_no,:court_code,:puname,:court_name,:prev_purpose_code,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:bench_code,:trn_bor_caseid,null,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 15 Adding new record to store data from Frame 2, Row 23 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010826 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 new_case_purpose = 10110000000719 new_purpose_code = 122 next_hear_date = 06/11/2025 new_purpose_group = 19971000000602 prev_hear_date = 06/10/2025 court_code = 10006 court_name = 11599000000000 case_no = 2024/7502 docid = 100062024/7502 puname = POOJAMEENA bench_code = 15 prev_purpose_code = 122 trn_bor_caseid = 12895000009411 manual_case_no = TRN_BOR_HEARINGrow = 23 Posting record Param Type = n trn_bor_hearingid=12467000010826 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 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=06/11/2025 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c court_code=10006 Param Type = c court_name=11599000000000 Param Type = c case_no=2024/7502 Param Type = c docid=100062024/7502 Param Type = c puname=POOJAMEENA Param Type = c bench_code=15 Param Type = c prev_purpose_code=122 Param Type = n trn_bor_caseid=12895000009411 Param Type = n trn_bor_hearingrow=23 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,new_purpose_code,next_hear_date,new_purpose_group,prev_hear_date,court_code,court_name,case_no,docid,puname,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,:court_name,:case_no,:docid,:puname,:bench_code,:prev_purpose_code,:trn_bor_caseid,null,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 24 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010827 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 new_case_purpose = 10110000000719 prev_hear_date = 06/10/2025 next_hear_date = 19/01/2026 new_purpose_group = 19971000000602 new_purpose_code = 122 court_code = 10006 docid = 100062024/7537 puname = POOJAMEENA court_name = 11599000000000 case_no = 2024/7537 bench_code = 15 prev_purpose_code = 122 trn_bor_caseid = 12201000008583 manual_case_no = TRN_BOR_HEARINGrow = 24 Posting record Param Type = n trn_bor_hearingid=12467000010827 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 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=06/10/2025 00:00:00 Param Type = c next_hear_date=19/01/2026 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c new_purpose_code=122 Param Type = c court_code=10006 Param Type = c docid=100062024/7537 Param Type = c puname=POOJAMEENA Param Type = c court_name=11599000000000 Param Type = c case_no=2024/7537 Param Type = c bench_code=15 Param Type = c prev_purpose_code=122 Param Type = n trn_bor_caseid=12201000008583 Param Type = n trn_bor_hearingrow=24 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,prev_hear_date,next_hear_date,new_purpose_group,new_purpose_code,court_code,docid,puname,court_name,case_no,bench_code,prev_purpose_code,trn_bor_caseid,manual_case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:new_case_purpose,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:docid,:puname,:court_name,:case_no,:bench_code,:prev_purpose_code,:trn_bor_caseid,null,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 25 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 12467000010828 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 new_case_purpose = 10110000000719 prev_hear_date = 06/10/2025 next_hear_date = 19/01/2026 new_purpose_group = 19971000000602 new_purpose_code = 122 prev_purpose_code = 122 court_code = 10006 docid = 100062024/7562 court_name = 11599000000000 puname = POOJAMEENA manual_case_no = trn_bor_caseid = 10506000008472 case_no = 2024/7562 bench_code = 15 TRN_BOR_HEARINGrow = 25 Posting record Param Type = n trn_bor_hearingid=12467000010828 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 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=06/10/2025 00:00:00 Param Type = c next_hear_date=19/01/2026 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=100062024/7562 Param Type = c court_name=11599000000000 Param Type = c puname=POOJAMEENA Param Type = n trn_bor_caseid=10506000008472 Param Type = c case_no=2024/7562 Param Type = c bench_code=15 Param Type = n trn_bor_hearingrow=25 insert into TRN_BOR_HEARING (trn_bor_hearingid,trn_bor_mhearingid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,new_case_purpose,prev_hear_date,next_hear_date,new_purpose_group,new_purpose_code,prev_purpose_code,court_code,docid,court_name,puname,manual_case_no,trn_bor_caseid,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_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,:court_name,:puname,null,:trn_bor_caseid,:case_no,:bench_code,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 28 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 = 6 RecordId = 12467000010829 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 5 prev_hear_date = 06/10/2025 prev_purpose_code = 122 new_case_purpose = 10110000000719 next_hear_date = 19/01/2026 new_purpose_group = 19971000000602 new_purpose_code = 122 court_code = 10006 docid = 100062024/7595 puname = POOJAMEENA court_name = 11599000000000 manual_case_no = bench_code = 15 case_no = 2024/7595 trn_bor_caseid = 12418000009732 TRN_BOR_HEARINGrow = 26 Posting record Param Type = n trn_bor_hearingid=12467000010829 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c prev_purpose_code=122 Param Type = c new_case_purpose=10110000000719 Param Type = c next_hear_date=19/01/2026 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c new_purpose_code=122 Param Type = c court_code=10006 Param Type = c docid=100062024/7595 Param Type = c puname=POOJAMEENA Param Type = c court_name=11599000000000 Param Type = c bench_code=15 Param Type = c case_no=2024/7595 Param Type = n trn_bor_caseid=12418000009732 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,prev_hear_date,prev_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,court_code,docid,puname,court_name,manual_case_no,bench_code,case_no,trn_bor_caseid,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:docid,:puname,:court_name,null,:bench_code,:case_no,:trn_bor_caseid,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 14 Adding new record to store data from Frame 2, Row 27 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 12467000010830 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 prev_hear_date = 06/10/2025 prev_purpose_code = 122 new_case_purpose = 10110000000719 next_hear_date = 15/10/2025 new_purpose_group = 19971000000602 new_purpose_code = 122 court_code = 10006 docid = 100062024/7632 puname = POOJAMEENA court_name = 11599000000000 manual_case_no = bench_code = 15 case_no = 2024/7632 trn_bor_caseid = 16249000009214 TRN_BOR_HEARINGrow = 27 Posting record Param Type = n trn_bor_hearingid=12467000010830 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c prev_purpose_code=122 Param Type = c new_case_purpose=10110000000719 Param Type = c next_hear_date=15/10/2025 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c new_purpose_code=122 Param Type = c court_code=10006 Param Type = c docid=100062024/7632 Param Type = c puname=POOJAMEENA Param Type = c court_name=11599000000000 Param Type = c bench_code=15 Param Type = c case_no=2024/7632 Param Type = n trn_bor_caseid=16249000009214 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,prev_hear_date,prev_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,court_code,docid,puname,court_name,manual_case_no,bench_code,case_no,trn_bor_caseid,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:court_code,:docid,:puname,:court_name,null,:bench_code,:case_no,:trn_bor_caseid,:trn_bor_hearingrow) select * from TRN_BOR_HEARING where TRN_BOR_HEARINGid=0 Time elapsed = 4 Adding new record to store data from Frame 2, Row 28 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010831 MapName SourceId 0 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 prev_hear_date = 06/10/2025 prev_purpose_code = 122 new_case_purpose = 10110000000719 next_hear_date = 19/01/2026 new_purpose_group = 19971000000602 new_purpose_code = 122 bench_code = 15 court_code = 10006 court_name = 11599000000000 puname = POOJAMEENA docid = 100062024/7668 manual_case_no = trn_bor_caseid = 14121000008690 case_no = 2024/7668 TRN_BOR_HEARINGrow = 28 Posting record Param Type = n trn_bor_hearingid=12467000010831 Param Type = n trn_bor_mhearingid=12467000010803 Param Type = n sourceid=0 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_hear_date=06/10/2025 00:00:00 Param Type = c prev_purpose_code=122 Param Type = c new_case_purpose=10110000000719 Param Type = c next_hear_date=19/01/2026 00:00:00 Param Type = n new_purpose_group=19971000000602 Param Type = c new_purpose_code=122 Param Type = c bench_code=15 Param Type = c court_code=10006 Param Type = c court_name=11599000000000 Param Type = c puname=POOJAMEENA Param Type = c docid=100062024/7668 Param Type = n trn_bor_caseid=14121000008690 Param Type = c case_no=2024/7668 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,prev_hear_date,prev_purpose_code,new_case_purpose,next_hear_date,new_purpose_group,new_purpose_code,bench_code,court_code,court_name,puname,docid,manual_case_no,trn_bor_caseid,case_no,trn_bor_hearingrow) values (:trn_bor_hearingid,:trn_bor_mhearingid,null,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,to_date(:prev_hear_date,'dd/mm/yyyy hh24:mi:ss'),:prev_purpose_code,:new_case_purpose,to_date(:next_hear_date,'dd/mm/yyyy hh24:mi:ss'),:new_purpose_group,:new_purpose_code,:bench_code,:court_code,:court_name,:puname,:docid,null,:trn_bor_caseid,:case_no,:trn_bor_hearingrow) Time elapsed for insert/update = 3969005188202 >>Executing genmaps >>Posting from bocup to rbchh from row 1 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/5344 idvalue 0 Mapped hearing_date Row = 1 value = 13/10/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 18472000009703 idvalue 0 Mapped case_docid Row = 1 value = 100062024/5344 idvalue 0 Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0 Mapped case_purpose_code Row = 1 value = 120 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 18472000009703 case_docid = 100062024/5344 case_no = 2024/5344 prev_hearing_date = 06/10/2025 hearing_date = 13/10/2025 prev_case_purposename = ???????? ????????? ???? prev_case_purpose = prev_case_purposename=???????? ????????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=???????? ????????? ???? Time elapsed = 3 prev_case_purpose after validation = 10107000000777 case_purpose = 10107000000777 case_purpose_code = 120 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010832 MapName bocup1 SourceId 12467000010804 Select sysdate as sdt from dual Time elapsed = 13 Select sysdate as sdt from dual Time elapsed = 14 prev_case_purpose = 10107000000777 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 120 hearing_date = 13/10/2025 prev_case_purposename = ???????? ????????? ???? court_code = 10006 case_no = 2024/5344 case_docid = 100062024/5344 case_purpose = 10107000000777 trn_bor_caseregid = 18472000009703 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010832 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010804 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:16 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:16 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10107000000777 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=120 Param Type = c hearing_date=13/10/2025 00:00:00 Param Type = c prev_case_purposename=???????? ????????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/5344 Param Type = c case_docid=100062024/5344 Param Type = c case_purpose=10107000000777 Param Type = n trn_bor_caseregid=18472000009703 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 2 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/5355 idvalue 0 Mapped hearing_date Row = 1 value = 19/01/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 19127000007860 idvalue 0 Mapped case_docid Row = 1 value = 100062024/5355 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 19127000007860 case_docid = 100062024/5355 case_no = 2024/5355 prev_hearing_date = 06/10/2025 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purposename=?????? ????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=?????? ????? ???? Time elapsed = 4 prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 1 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010833 MapName bocup1 SourceId 12467000010805 Select sysdate as sdt from dual Time elapsed = 16 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/5355 case_docid = 100062024/5355 case_purpose = 10110000000719 trn_bor_caseregid = 19127000007860 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010833 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010805 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:17 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=19/01/2026 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/5355 Param Type = c case_docid=100062024/5355 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=19127000007860 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 3 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/5439 idvalue 0 Mapped hearing_date Row = 1 value = 19/01/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???. idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 19956000009640 idvalue 0 Mapped case_docid Row = 1 value = 100062024/5439 idvalue 0 Mapped case_purpose Row = 1 value = 10189000000601 idvalue 0 Mapped case_purpose_code Row = 1 value = 201 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 19956000009640 case_docid = 100062024/5439 case_no = 2024/5439 prev_hearing_date = 06/10/2025 hearing_date = 19/01/2026 prev_case_purposename = ???. prev_case_purpose = prev_case_purposename=???. SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=???. Time elapsed = 15 prev_case_purpose after validation = 10189000000601 case_purpose = 10189000000601 case_purpose_code = 201 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010834 MapName bocup1 SourceId 12467000010806 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 prev_case_purpose = 10189000000601 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 201 hearing_date = 19/01/2026 prev_case_purposename = ???. court_code = 10006 case_no = 2024/5439 case_docid = 100062024/5439 case_purpose = 10189000000601 trn_bor_caseregid = 19956000009640 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010834 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010806 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:17 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10189000000601 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=201 Param Type = c hearing_date=19/01/2026 00:00:00 Param Type = c prev_case_purposename=???. Param Type = c court_code=10006 Param Type = c case_no=2024/5439 Param Type = c case_docid=100062024/5439 Param Type = c case_purpose=10189000000601 Param Type = n trn_bor_caseregid=19956000009640 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 4 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/5669 idvalue 0 Mapped hearing_date Row = 1 value = 10/10/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 17710000008084 idvalue 0 Mapped case_docid Row = 1 value = 100062024/5669 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 17710000008084 case_docid = 100062024/5669 case_no = 2024/5669 prev_hearing_date = 06/10/2025 hearing_date = 10/10/2025 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purposename=?????? ????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=?????? ????? ???? Time elapsed = 4 prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 12 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010835 MapName bocup1 SourceId 12467000010807 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 10/10/2025 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/5669 case_docid = 100062024/5669 case_purpose = 10110000000719 trn_bor_caseregid = 17710000008084 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010835 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010807 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:17 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=10/10/2025 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/5669 Param Type = c case_docid=100062024/5669 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=17710000008084 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 5 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/5670 idvalue 0 Mapped hearing_date Row = 1 value = 10/10/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 17763000009479 idvalue 0 Mapped case_docid Row = 1 value = 100062024/5670 idvalue 0 Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0 Mapped case_purpose_code Row = 1 value = 120 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 17763000009479 case_docid = 100062024/5670 case_no = 2024/5670 prev_hearing_date = 06/10/2025 hearing_date = 10/10/2025 prev_case_purposename = ???????? ????????? ???? prev_case_purpose = prev_case_purposename=???????? ????????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=???????? ????????? ???? Time elapsed = 4 prev_case_purpose after validation = 10107000000777 case_purpose = 10107000000777 case_purpose_code = 120 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 1 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010836 MapName bocup1 SourceId 12467000010808 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 prev_case_purpose = 10107000000777 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 120 hearing_date = 10/10/2025 prev_case_purposename = ???????? ????????? ???? court_code = 10006 case_no = 2024/5670 case_docid = 100062024/5670 case_purpose = 10107000000777 trn_bor_caseregid = 17763000009479 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010836 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010808 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:17 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10107000000777 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=120 Param Type = c hearing_date=10/10/2025 00:00:00 Param Type = c prev_case_purposename=???????? ????????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/5670 Param Type = c case_docid=100062024/5670 Param Type = c case_purpose=10107000000777 Param Type = n trn_bor_caseregid=17763000009479 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 6 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/5876 idvalue 0 Mapped hearing_date Row = 1 value = 17/12/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 14001000009229 idvalue 0 Mapped case_docid Row = 1 value = 100062024/5876 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 14001000009229 case_docid = 100062024/5876 case_no = 2024/5876 prev_hearing_date = 06/10/2025 hearing_date = 17/12/2025 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purposename=?????? ????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=?????? ????? ???? Time elapsed = 3 prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 13 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 5 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 12467000010837 MapName bocup1 SourceId 12467000010809 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 17/12/2025 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/5876 case_docid = 100062024/5876 case_purpose = 10110000000719 trn_bor_caseregid = 14001000009229 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010837 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010809 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:17 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=17/12/2025 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/5876 Param Type = c case_docid=100062024/5876 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=14001000009229 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 7 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/6069 idvalue 0 Mapped hearing_date Row = 1 value = 09/10/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 16817000010763 idvalue 0 Mapped case_docid Row = 1 value = 100062024/6069 idvalue 0 Mapped case_purpose Row = 1 value = 10035000000979 idvalue 0 Mapped case_purpose_code Row = 1 value = 112 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 16817000010763 case_docid = 100062024/6069 case_no = 2024/6069 prev_hearing_date = 06/10/2025 hearing_date = 09/10/2025 prev_case_purposename = ?????? ????? prev_case_purpose = prev_case_purposename=?????? ????? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=?????? ????? Time elapsed = 3 prev_case_purpose after validation = 10035000000979 case_purpose = 10035000000979 case_purpose_code = 112 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 6 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010838 MapName bocup1 SourceId 12467000010810 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10035000000979 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 112 hearing_date = 09/10/2025 prev_case_purposename = ?????? ????? court_code = 10006 case_no = 2024/6069 case_docid = 100062024/6069 case_purpose = 10035000000979 trn_bor_caseregid = 16817000010763 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010838 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010810 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:17 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10035000000979 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=112 Param Type = c hearing_date=09/10/2025 00:00:00 Param Type = c prev_case_purposename=?????? ????? Param Type = c court_code=10006 Param Type = c case_no=2024/6069 Param Type = c case_docid=100062024/6069 Param Type = c case_purpose=10035000000979 Param Type = n trn_bor_caseregid=16817000010763 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 8 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/6119 idvalue 0 Mapped hearing_date Row = 1 value = 28/10/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 17124000009869 idvalue 0 Mapped case_docid Row = 1 value = 100062024/6119 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 17124000009869 case_docid = 100062024/6119 case_no = 2024/6119 prev_hearing_date = 06/10/2025 hearing_date = 28/10/2025 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purposename=?????? ????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=?????? ????? ???? Time elapsed = 3 prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 1 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010839 MapName bocup1 SourceId 12467000010811 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 2 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 28/10/2025 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/6119 case_docid = 100062024/6119 case_purpose = 10110000000719 trn_bor_caseregid = 17124000009869 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010839 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010811 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:17 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=28/10/2025 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/6119 Param Type = c case_docid=100062024/6119 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=17124000009869 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 9 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/6143 idvalue 0 Mapped hearing_date Row = 1 value = 13/10/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 15774000009658 idvalue 0 Mapped case_docid Row = 1 value = 100062024/6143 idvalue 0 Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0 Mapped case_purpose_code Row = 1 value = 120 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 15774000009658 case_docid = 100062024/6143 case_no = 2024/6143 prev_hearing_date = 06/10/2025 hearing_date = 13/10/2025 prev_case_purposename = ???????? ????????? ???? prev_case_purpose = prev_case_purposename=???????? ????????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=???????? ????????? ???? Time elapsed = 3 prev_case_purpose after validation = 10107000000777 case_purpose = 10107000000777 case_purpose_code = 120 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010840 MapName bocup1 SourceId 12467000010812 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10107000000777 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 120 hearing_date = 13/10/2025 prev_case_purposename = ???????? ????????? ???? court_code = 10006 case_no = 2024/6143 case_docid = 100062024/6143 case_purpose = 10107000000777 trn_bor_caseregid = 15774000009658 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010840 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010812 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:17 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10107000000777 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=120 Param Type = c hearing_date=13/10/2025 00:00:00 Param Type = c prev_case_purposename=???????? ????????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/6143 Param Type = c case_docid=100062024/6143 Param Type = c case_purpose=10107000000777 Param Type = n trn_bor_caseregid=15774000009658 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 10 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/6148 idvalue 0 Mapped hearing_date Row = 1 value = 14/10/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???. idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 15995000009297 idvalue 0 Mapped case_docid Row = 1 value = 100062024/6148 idvalue 0 Mapped case_purpose Row = 1 value = 10189000000601 idvalue 0 Mapped case_purpose_code Row = 1 value = 201 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 15995000009297 case_docid = 100062024/6148 case_no = 2024/6148 prev_hearing_date = 06/10/2025 hearing_date = 14/10/2025 prev_case_purposename = ???. prev_case_purpose = prev_case_purposename=???. SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=???. Time elapsed = 4 prev_case_purpose after validation = 10189000000601 case_purpose = 10189000000601 case_purpose_code = 201 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 3 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010841 MapName bocup1 SourceId 12467000010813 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 prev_case_purpose = 10189000000601 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 201 hearing_date = 14/10/2025 prev_case_purposename = ???. court_code = 10006 case_no = 2024/6148 case_docid = 100062024/6148 case_purpose = 10189000000601 trn_bor_caseregid = 15995000009297 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010841 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010813 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:17 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10189000000601 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=201 Param Type = c hearing_date=14/10/2025 00:00:00 Param Type = c prev_case_purposename=???. Param Type = c court_code=10006 Param Type = c case_no=2024/6148 Param Type = c case_docid=100062024/6148 Param Type = c case_purpose=10189000000601 Param Type = n trn_bor_caseregid=15995000009297 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 11 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/6187 idvalue 0 Mapped hearing_date Row = 1 value = 28/10/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 16850000010252 idvalue 0 Mapped case_docid Row = 1 value = 100062024/6187 idvalue 0 Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0 Mapped case_purpose_code Row = 1 value = 120 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 16850000010252 case_docid = 100062024/6187 case_no = 2024/6187 prev_hearing_date = 06/10/2025 hearing_date = 28/10/2025 prev_case_purposename = ???????? ????????? ???? prev_case_purpose = prev_case_purposename=???????? ????????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=???????? ????????? ???? Time elapsed = 4 prev_case_purpose after validation = 10107000000777 case_purpose = 10107000000777 case_purpose_code = 120 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010842 MapName bocup1 SourceId 12467000010814 Select sysdate as sdt from dual Time elapsed = 14 Select sysdate as sdt from dual Time elapsed = 15 prev_case_purpose = 10107000000777 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 120 hearing_date = 28/10/2025 prev_case_purposename = ???????? ????????? ???? court_code = 10006 case_no = 2024/6187 case_docid = 100062024/6187 case_purpose = 10107000000777 trn_bor_caseregid = 16850000010252 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010842 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010814 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:17 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10107000000777 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=120 Param Type = c hearing_date=28/10/2025 00:00:00 Param Type = c prev_case_purposename=???????? ????????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/6187 Param Type = c case_docid=100062024/6187 Param Type = c case_purpose=10107000000777 Param Type = n trn_bor_caseregid=16850000010252 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 12 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/6568 idvalue 0 Mapped hearing_date Row = 1 value = 19/01/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 17432000009420 idvalue 0 Mapped case_docid Row = 1 value = 100062024/6568 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 17432000009420 case_docid = 100062024/6568 case_no = 2024/6568 prev_hearing_date = 06/10/2025 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purposename=?????? ????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=?????? ????? ???? Time elapsed = 5 prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 1 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010843 MapName bocup1 SourceId 12467000010815 Select sysdate as sdt from dual Time elapsed = 15 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/6568 case_docid = 100062024/6568 case_purpose = 10110000000719 trn_bor_caseregid = 17432000009420 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010843 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010815 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:17 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=19/01/2026 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/6568 Param Type = c case_docid=100062024/6568 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=17432000009420 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 13 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/6569 idvalue 0 Mapped hearing_date Row = 1 value = 17/11/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 17473000009202 idvalue 0 Mapped case_docid Row = 1 value = 100062024/6569 idvalue 0 Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0 Mapped case_purpose_code Row = 1 value = 120 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 17473000009202 case_docid = 100062024/6569 case_no = 2024/6569 prev_hearing_date = 06/10/2025 hearing_date = 17/11/2025 prev_case_purposename = ???????? ????????? ???? prev_case_purpose = prev_case_purposename=???????? ????????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=???????? ????????? ???? Time elapsed = 5 prev_case_purpose after validation = 10107000000777 case_purpose = 10107000000777 case_purpose_code = 120 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 17 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 = 12467000010844 MapName bocup1 SourceId 12467000010816 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10107000000777 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 120 hearing_date = 17/11/2025 prev_case_purposename = ???????? ????????? ???? court_code = 10006 case_no = 2024/6569 case_docid = 100062024/6569 case_purpose = 10107000000777 trn_bor_caseregid = 17473000009202 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010844 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010816 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:17 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10107000000777 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=120 Param Type = c hearing_date=17/11/2025 00:00:00 Param Type = c prev_case_purposename=???????? ????????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/6569 Param Type = c case_docid=100062024/6569 Param Type = c case_purpose=10107000000777 Param Type = n trn_bor_caseregid=17473000009202 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 14 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/6571 idvalue 0 Mapped hearing_date Row = 1 value = 19/01/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 17524000008779 idvalue 0 Mapped case_docid Row = 1 value = 100062024/6571 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 17524000008779 case_docid = 100062024/6571 case_no = 2024/6571 prev_hearing_date = 06/10/2025 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purposename=?????? ????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=?????? ????? ???? Time elapsed = 4 prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 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 = 12467000010845 MapName bocup1 SourceId 12467000010817 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/6571 case_docid = 100062024/6571 case_purpose = 10110000000719 trn_bor_caseregid = 17524000008779 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010845 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010817 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:17 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:17 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=19/01/2026 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/6571 Param Type = c case_docid=100062024/6571 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=17524000008779 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 15 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/6716 idvalue 0 Mapped hearing_date Row = 1 value = 27/10/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 15679000009030 idvalue 0 Mapped case_docid Row = 1 value = 100062024/6716 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 15679000009030 case_docid = 100062024/6716 case_no = 2024/6716 prev_hearing_date = 06/10/2025 hearing_date = 27/10/2025 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010846 MapName bocup1 SourceId 12467000010818 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 27/10/2025 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/6716 case_docid = 100062024/6716 case_purpose = 10110000000719 trn_bor_caseregid = 15679000009030 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010846 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010818 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:18 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=27/10/2025 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/6716 Param Type = c case_docid=100062024/6716 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=15679000009030 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 16 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/6865 idvalue 0 Mapped hearing_date Row = 1 value = 17/11/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ???????? ????????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 19948000009787 idvalue 0 Mapped case_docid Row = 1 value = 100062024/6865 idvalue 0 Mapped case_purpose Row = 1 value = 10107000000777 idvalue 0 Mapped case_purpose_code Row = 1 value = 120 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 19948000009787 case_docid = 100062024/6865 case_no = 2024/6865 prev_hearing_date = 06/10/2025 hearing_date = 17/11/2025 prev_case_purposename = ???????? ????????? ???? prev_case_purpose = prev_case_purposename=???????? ????????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=???????? ????????? ???? Time elapsed = 14 prev_case_purpose after validation = 10107000000777 case_purpose = 10107000000777 case_purpose_code = 120 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 1 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 5 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010847 MapName bocup1 SourceId 12467000010819 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 4 prev_case_purpose = 10107000000777 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 120 hearing_date = 17/11/2025 prev_case_purposename = ???????? ????????? ???? court_code = 10006 case_no = 2024/6865 case_docid = 100062024/6865 case_purpose = 10107000000777 trn_bor_caseregid = 19948000009787 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010847 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010819 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:18 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10107000000777 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=120 Param Type = c hearing_date=17/11/2025 00:00:00 Param Type = c prev_case_purposename=???????? ????????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/6865 Param Type = c case_docid=100062024/6865 Param Type = c case_purpose=10107000000777 Param Type = n trn_bor_caseregid=19948000009787 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 17 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/7151 idvalue 0 Mapped hearing_date Row = 1 value = 19/01/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 19660000009205 idvalue 0 Mapped case_docid Row = 1 value = 100062024/7151 idvalue 0 Mapped case_purpose Row = 1 value = 10185000000802 idvalue 0 Mapped case_purpose_code Row = 1 value = 172 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 19660000009205 case_docid = 100062024/7151 case_no = 2024/7151 prev_hearing_date = 06/10/2025 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ????? ???? prev_case_purpose = prev_case_purposename=?????? ????? ????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=?????? ????? ????? ???? Time elapsed = 6 prev_case_purpose after validation = 10185000000802 case_purpose = 10185000000802 case_purpose_code = 172 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010848 MapName bocup1 SourceId 12467000010820 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 14 prev_case_purpose = 10185000000802 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 172 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ????? ???? court_code = 10006 case_no = 2024/7151 case_docid = 100062024/7151 case_purpose = 10185000000802 trn_bor_caseregid = 19660000009205 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010848 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010820 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:18 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10185000000802 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=172 Param Type = c hearing_date=19/01/2026 00:00:00 Param Type = c prev_case_purposename=?????? ????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/7151 Param Type = c case_docid=100062024/7151 Param Type = c case_purpose=10185000000802 Param Type = n trn_bor_caseregid=19660000009205 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 18 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/7256 idvalue 0 Mapped hearing_date Row = 1 value = 19/01/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 11060000009011 idvalue 0 Mapped case_docid Row = 1 value = 100062024/7256 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 11060000009011 case_docid = 100062024/7256 case_no = 2024/7256 prev_hearing_date = 06/10/2025 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purposename=?????? ????? ???? SELECT V.CASE_PURPOSE_MASTID FROM case_purpose_mast v WHERE v.case_purpose_name = :prev_case_purposename prev_case_purposename=?????? ????? ???? Time elapsed = 4 prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 1 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010849 MapName bocup1 SourceId 12467000010821 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/7256 case_docid = 100062024/7256 case_purpose = 10110000000719 trn_bor_caseregid = 11060000009011 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010849 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010821 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:18 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=19/01/2026 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/7256 Param Type = c case_docid=100062024/7256 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=11060000009011 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 19 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/7301 idvalue 0 Mapped hearing_date Row = 1 value = 19/01/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 13647000009698 idvalue 0 Mapped case_docid Row = 1 value = 100062024/7301 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 13647000009698 case_docid = 100062024/7301 case_no = 2024/7301 prev_hearing_date = 06/10/2025 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010850 MapName bocup1 SourceId 12467000010822 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/7301 case_docid = 100062024/7301 case_purpose = 10110000000719 trn_bor_caseregid = 13647000009698 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010850 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010822 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:18 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=19/01/2026 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/7301 Param Type = c case_docid=100062024/7301 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=13647000009698 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 20 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/7309 idvalue 0 Mapped hearing_date Row = 1 value = 19/01/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 14209000008845 idvalue 0 Mapped case_docid Row = 1 value = 100062024/7309 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 14209000008845 case_docid = 100062024/7309 case_no = 2024/7309 prev_hearing_date = 06/10/2025 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010851 MapName bocup1 SourceId 12467000010823 Select sysdate as sdt from dual Time elapsed = 5 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/7309 case_docid = 100062024/7309 case_purpose = 10110000000719 trn_bor_caseregid = 14209000008845 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010851 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010823 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:18 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=19/01/2026 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/7309 Param Type = c case_docid=100062024/7309 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=14209000008845 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 21 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/7327 idvalue 0 Mapped hearing_date Row = 1 value = 06/11/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 16575000008596 idvalue 0 Mapped case_docid Row = 1 value = 100062024/7327 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 16575000008596 case_docid = 100062024/7327 case_no = 2024/7327 prev_hearing_date = 06/10/2025 hearing_date = 06/11/2025 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010852 MapName bocup1 SourceId 12467000010824 Select sysdate as sdt from dual Time elapsed = 8 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 06/11/2025 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/7327 case_docid = 100062024/7327 case_purpose = 10110000000719 trn_bor_caseregid = 16575000008596 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010852 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010824 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:18 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=06/11/2025 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/7327 Param Type = c case_docid=100062024/7327 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=16575000008596 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 22 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/7388 idvalue 0 Mapped hearing_date Row = 1 value = 17/10/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 14206000008992 idvalue 0 Mapped case_docid Row = 1 value = 100062024/7388 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 14206000008992 case_docid = 100062024/7388 case_no = 2024/7388 prev_hearing_date = 06/10/2025 hearing_date = 17/10/2025 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 1 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 5 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 4 RecordId = 12467000010853 MapName bocup1 SourceId 12467000010825 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 17/10/2025 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/7388 case_docid = 100062024/7388 case_purpose = 10110000000719 trn_bor_caseregid = 14206000008992 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010853 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010825 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:18 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=17/10/2025 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/7388 Param Type = c case_docid=100062024/7388 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=14206000008992 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 23 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/7502 idvalue 0 Mapped hearing_date Row = 1 value = 06/11/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 12895000009411 idvalue 0 Mapped case_docid Row = 1 value = 100062024/7502 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 12895000009411 case_docid = 100062024/7502 case_no = 2024/7502 prev_hearing_date = 06/10/2025 hearing_date = 06/11/2025 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010854 MapName bocup1 SourceId 12467000010826 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 2 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 06/11/2025 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/7502 case_docid = 100062024/7502 case_purpose = 10110000000719 trn_bor_caseregid = 12895000009411 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010854 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010826 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:18 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=06/11/2025 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/7502 Param Type = c case_docid=100062024/7502 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=12895000009411 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 24 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/7537 idvalue 0 Mapped hearing_date Row = 1 value = 19/01/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 12201000008583 idvalue 0 Mapped case_docid Row = 1 value = 100062024/7537 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 12201000008583 case_docid = 100062024/7537 case_no = 2024/7537 prev_hearing_date = 06/10/2025 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 12467000010855 MapName bocup1 SourceId 12467000010827 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/7537 case_docid = 100062024/7537 case_purpose = 10110000000719 trn_bor_caseregid = 12201000008583 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010855 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010827 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:18 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=19/01/2026 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/7537 Param Type = c case_docid=100062024/7537 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=12201000008583 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 25 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/7562 idvalue 0 Mapped hearing_date Row = 1 value = 19/01/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 10506000008472 idvalue 0 Mapped case_docid Row = 1 value = 100062024/7562 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 10506000008472 case_docid = 100062024/7562 case_no = 2024/7562 prev_hearing_date = 06/10/2025 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 2 RecordId = 12467000010856 MapName bocup1 SourceId 12467000010828 Select sysdate as sdt from dual Time elapsed = 2 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/7562 case_docid = 100062024/7562 case_purpose = 10110000000719 trn_bor_caseregid = 10506000008472 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010856 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010828 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:18 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=19/01/2026 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/7562 Param Type = c case_docid=100062024/7562 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=10506000008472 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 26 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/7595 idvalue 0 Mapped hearing_date Row = 1 value = 19/01/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 12418000009732 idvalue 0 Mapped case_docid Row = 1 value = 100062024/7595 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 12418000009732 case_docid = 100062024/7595 case_no = 2024/7595 prev_hearing_date = 06/10/2025 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 6 RecordId = 12467000010857 MapName bocup1 SourceId 12467000010829 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 5 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/7595 case_docid = 100062024/7595 case_purpose = 10110000000719 trn_bor_caseregid = 12418000009732 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010857 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010829 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:18 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=19/01/2026 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/7595 Param Type = c case_docid=100062024/7595 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=12418000009732 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 27 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/7632 idvalue 0 Mapped hearing_date Row = 1 value = 15/10/2025 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 16249000009214 idvalue 0 Mapped case_docid Row = 1 value = 100062024/7632 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 16249000009214 case_docid = 100062024/7632 case_no = 2024/7632 prev_hearing_date = 06/10/2025 hearing_date = 15/10/2025 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 2 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010858 MapName bocup1 SourceId 12467000010830 Select sysdate as sdt from dual Time elapsed = 4 Select sysdate as sdt from dual Time elapsed = 2 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 15/10/2025 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/7632 case_docid = 100062024/7632 case_purpose = 10110000000719 trn_bor_caseregid = 16249000009214 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010858 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010830 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:18 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=15/10/2025 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/7632 Param Type = c case_docid=100062024/7632 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=16249000009214 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) >>Posting from bocup to rbchh from row 28 >>Mapping Mapped court_code Row = 1 value = 10006 idvalue 0 Mapped case_no Row = 1 value = 2024/7668 idvalue 0 Mapped hearing_date Row = 1 value = 19/01/2026 idvalue 0 Mapped prev_case_purposename Row = 1 value = ?????? ????? ???? idvalue 0 Mapped prev_hearing_date Row = 1 value = 06/10/2025 idvalue 0 Mapped trn_bor_caseregid Row = 1 value = 14121000008690 idvalue 0 Mapped case_docid Row = 1 value = 100062024/7668 idvalue 0 Mapped case_purpose Row = 1 value = 10110000000719 idvalue 0 Mapped case_purpose_code Row = 1 value = 122 idvalue 0 Mapped trans_type Row = 1 value = Cause List Update (Custom) idvalue 0 >>Validating rbchh >>Frame No 1 doc_date = Evaluating - date() Result of date = 07/10/2025 doc_date after validation = 07/10/2025 court_code = 10006 trn_bor_caseregid = 14121000008690 case_docid = 100062024/7668 case_no = 2024/7668 prev_hearing_date = 06/10/2025 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? prev_case_purpose = prev_case_purpose after validation = 10110000000719 case_purpose = 10110000000719 case_purpose_code = 122 bench_type = bench_name = clcheck = decision_type = decision_date = module = Evaluating - {Feedback} module after validation = Feedback trans_type = Cause List Update (Custom) >>Writing to tables rbchh Select * FROM Sequence WHERE lower(TRANSTYPE) = 'rbchh' Time elapsed = 3 Saving to table TRN_BOR_CASE_HIST select * from TRN_BOR_CASE_HIST where TRN_BOR_CASE_HISTid=0 Time elapsed = 4 Adding new record to store data from Frame 1, Row 1 Parent Row 0 update connectinfo set lastnumber=:lc,lastupdated=sysdate where connectno = :cn Time elapsed = 3 RecordId = 12467000010859 MapName bocup1 SourceId 12467000010831 Select sysdate as sdt from dual Time elapsed = 3 Select sysdate as sdt from dual Time elapsed = 3 prev_case_purpose = 10110000000719 bench_type = trans_type = Cause List Update (Custom) doc_date = 07/10/2025 decision_date = module = Feedback bench_name = decision_type = 0 case_purpose_code = 122 hearing_date = 19/01/2026 prev_case_purposename = ?????? ????? ???? court_code = 10006 case_no = 2024/7668 case_docid = 100062024/7668 case_purpose = 10110000000719 trn_bor_caseregid = 14121000008690 prev_hearing_date = 06/10/2025 Posting record Param Type = n trn_bor_case_histid=12467000010859 Param Type = c mapname=bocup1 Param Type = n sourceid=12467000010831 Param Type = c cancel=F Param Type = c createdby=POOJAMEENA Param Type = c createdon=07/10/2025 13:26:18 Param Type = c username=POOJAMEENA Param Type = c modifiedon=07/10/2025 13:26:18 Param Type = c app_desc=1 Param Type = c app_level=1 Param Type = c prev_case_purpose=10110000000719 Param Type = c trans_type=Cause List Update (Custom) Param Type = c doc_date=07/10/2025 00:00:00 Param Type = c module=Feedback Param Type = n decision_type=0 Param Type = c case_purpose_code=122 Param Type = c hearing_date=19/01/2026 00:00:00 Param Type = c prev_case_purposename=?????? ????? ???? Param Type = c court_code=10006 Param Type = c case_no=2024/7668 Param Type = c case_docid=100062024/7668 Param Type = c case_purpose=10110000000719 Param Type = n trn_bor_caseregid=14121000008690 Param Type = c prev_hearing_date=06/10/2025 00:00:00 insert into TRN_BOR_CASE_HIST (trn_bor_case_histid,mapname,sourceid,cancel,createdby,createdon,username,modifiedon,app_desc,app_level,prev_case_purpose,bench_type,trans_type,doc_date,decision_date,module,bench_name,decision_type,case_purpose_code,hearing_date,prev_case_purposename,court_code,case_no,case_docid,case_purpose,trn_bor_caseregid,prev_hearing_date) values (:trn_bor_case_histid,:mapname,:sourceid,:cancel,:createdby,to_date(:createdon,'dd/mm/yyyy hh24:mi:ss'),:username,to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss'),:app_desc,:app_level,:prev_case_purpose,null,:trans_type,to_date(:doc_date,'dd/mm/yyyy hh24:mi:ss'),null,:module,null,:decision_type,:case_purpose_code,to_date(:hearing_date,'dd/mm/yyyy hh24:mi:ss'),:prev_case_purposename,:court_code,:case_no,:case_docid,:case_purpose,:trn_bor_caseregid,to_date(:prev_hearing_date,'dd/mm/yyyy hh24:mi:ss')) Time elapsed for Gen Map = 3969005190124 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=18472000009703 @trn_bor_caseregid=18472000009703 *hearingdate=13/10/2025 *case_purpose_name=10107000000777 *case_purpose_code=120 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18472000009703 for update Time elapsed = 185 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=18472000009703 Time elapsed = 70 Param Type = c hearingdate=13/10/2025 00:00:00 Param Type = c case_purpose_name=10107000000777 Param Type = c case_purpose_code=120 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=18472000009703 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=19127000007860 @trn_bor_caseregid=19127000007860 *hearingdate=19/01/2026 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19127000007860 for update Time elapsed = 117 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19127000007860 Time elapsed = 71 Param Type = c hearingdate=19/01/2026 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=19127000007860 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=19956000009640 @trn_bor_caseregid=19956000009640 *hearingdate=19/01/2026 *case_purpose_name=10189000000601 *case_purpose_code=201 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19956000009640 for update Time elapsed = 75 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19956000009640 Time elapsed = 104 Param Type = c hearingdate=19/01/2026 00:00:00 Param Type = c case_purpose_name=10189000000601 Param Type = c case_purpose_code=201 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=19956000009640 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=17710000008084 @trn_bor_caseregid=17710000008084 *hearingdate=10/10/2025 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17710000008084 for update Time elapsed = 71 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17710000008084 Time elapsed = 95 Param Type = c hearingdate=10/10/2025 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=17710000008084 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=17763000009479 @trn_bor_caseregid=17763000009479 *hearingdate=10/10/2025 *case_purpose_name=10107000000777 *case_purpose_code=120 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17763000009479 for update Time elapsed = 69 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17763000009479 Time elapsed = 73 Param Type = c hearingdate=10/10/2025 00:00:00 Param Type = c case_purpose_name=10107000000777 Param Type = c case_purpose_code=120 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=17763000009479 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=14001000009229 @trn_bor_caseregid=14001000009229 *hearingdate=17/12/2025 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14001000009229 for update Time elapsed = 106 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14001000009229 Time elapsed = 84 Param Type = c hearingdate=17/12/2025 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=14001000009229 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=16817000010763 @trn_bor_caseregid=16817000010763 *hearingdate=09/10/2025 *case_purpose_name=10035000000979 *case_purpose_code=112 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16817000010763 for update Time elapsed = 66 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16817000010763 Time elapsed = 92 Param Type = c hearingdate=09/10/2025 00:00:00 Param Type = c case_purpose_name=10035000000979 Param Type = c case_purpose_code=112 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=16817000010763 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=17124000009869 @trn_bor_caseregid=17124000009869 *hearingdate=28/10/2025 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17124000009869 for update Time elapsed = 139 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17124000009869 Time elapsed = 126 Param Type = c hearingdate=28/10/2025 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=17124000009869 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=15774000009658 @trn_bor_caseregid=15774000009658 *hearingdate=13/10/2025 *case_purpose_name=10107000000777 *case_purpose_code=120 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15774000009658 for update Time elapsed = 115 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15774000009658 Time elapsed = 109 Param Type = c hearingdate=13/10/2025 00:00:00 Param Type = c case_purpose_name=10107000000777 Param Type = c case_purpose_code=120 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=15774000009658 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=15995000009297 @trn_bor_caseregid=15995000009297 *hearingdate=14/10/2025 *case_purpose_name=10189000000601 *case_purpose_code=201 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15995000009297 for update Time elapsed = 144 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15995000009297 Time elapsed = 191 Param Type = c hearingdate=14/10/2025 00:00:00 Param Type = c case_purpose_name=10189000000601 Param Type = c case_purpose_code=201 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=15995000009297 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=16850000010252 @trn_bor_caseregid=16850000010252 *hearingdate=28/10/2025 *case_purpose_name=10107000000777 *case_purpose_code=120 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16850000010252 for update Time elapsed = 94 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16850000010252 Time elapsed = 63 Param Type = c hearingdate=28/10/2025 00:00:00 Param Type = c case_purpose_name=10107000000777 Param Type = c case_purpose_code=120 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=16850000010252 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=17432000009420 @trn_bor_caseregid=17432000009420 *hearingdate=19/01/2026 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17432000009420 for update Time elapsed = 93 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17432000009420 Time elapsed = 105 Param Type = c hearingdate=19/01/2026 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=17432000009420 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=17473000009202 @trn_bor_caseregid=17473000009202 *hearingdate=17/11/2025 *case_purpose_name=10107000000777 *case_purpose_code=120 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17473000009202 for update Time elapsed = 181 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17473000009202 Time elapsed = 124 Param Type = c hearingdate=17/11/2025 00:00:00 Param Type = c case_purpose_name=10107000000777 Param Type = c case_purpose_code=120 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=17473000009202 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=17524000008779 @trn_bor_caseregid=17524000008779 *hearingdate=19/01/2026 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17524000008779 for update Time elapsed = 162 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=17524000008779 Time elapsed = 79 Param Type = c hearingdate=19/01/2026 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=17524000008779 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=15679000009030 @trn_bor_caseregid=15679000009030 *hearingdate=27/10/2025 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15679000009030 for update Time elapsed = 242 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=15679000009030 Time elapsed = 170 Param Type = c hearingdate=27/10/2025 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=15679000009030 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=19948000009787 @trn_bor_caseregid=19948000009787 *hearingdate=17/11/2025 *case_purpose_name=10107000000777 *case_purpose_code=120 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19948000009787 for update Time elapsed = 127 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19948000009787 Time elapsed = 101 Param Type = c hearingdate=17/11/2025 00:00:00 Param Type = c case_purpose_name=10107000000777 Param Type = c case_purpose_code=120 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=19948000009787 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=19660000009205 @trn_bor_caseregid=19660000009205 *hearingdate=19/01/2026 *case_purpose_name=10185000000802 *case_purpose_code=172 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19660000009205 for update Time elapsed = 96 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=19660000009205 Time elapsed = 61 Param Type = c hearingdate=19/01/2026 00:00:00 Param Type = c case_purpose_name=10185000000802 Param Type = c case_purpose_code=172 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=19660000009205 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=11060000009011 @trn_bor_caseregid=11060000009011 *hearingdate=19/01/2026 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=11060000009011 for update Time elapsed = 107 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=11060000009011 Time elapsed = 195 Param Type = c hearingdate=19/01/2026 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=11060000009011 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=13647000009698 @trn_bor_caseregid=13647000009698 *hearingdate=19/01/2026 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13647000009698 for update Time elapsed = 121 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=13647000009698 Time elapsed = 67 Param Type = c hearingdate=19/01/2026 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=13647000009698 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=14209000008845 @trn_bor_caseregid=14209000008845 *hearingdate=19/01/2026 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14209000008845 for update Time elapsed = 171 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14209000008845 Time elapsed = 75 Param Type = c hearingdate=19/01/2026 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=14209000008845 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=16575000008596 @trn_bor_caseregid=16575000008596 *hearingdate=06/11/2025 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16575000008596 for update Time elapsed = 133 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16575000008596 Time elapsed = 112 Param Type = c hearingdate=06/11/2025 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=16575000008596 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=14206000008992 @trn_bor_caseregid=14206000008992 *hearingdate=17/10/2025 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14206000008992 for update Time elapsed = 109 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14206000008992 Time elapsed = 85 Param Type = c hearingdate=17/10/2025 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=14206000008992 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=12895000009411 @trn_bor_caseregid=12895000009411 *hearingdate=06/11/2025 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=12895000009411 for update Time elapsed = 120 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=12895000009411 Time elapsed = 103 Param Type = c hearingdate=06/11/2025 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=12895000009411 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=12201000008583 @trn_bor_caseregid=12201000008583 *hearingdate=19/01/2026 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=12201000008583 for update Time elapsed = 89 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=12201000008583 Time elapsed = 156 Param Type = c hearingdate=19/01/2026 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=12201000008583 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=10506000008472 @trn_bor_caseregid=10506000008472 *hearingdate=19/01/2026 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10506000008472 for update Time elapsed = 115 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=10506000008472 Time elapsed = 147 Param Type = c hearingdate=19/01/2026 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=10506000008472 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=12418000009732 @trn_bor_caseregid=12418000009732 *hearingdate=19/01/2026 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=12418000009732 for update Time elapsed = 122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=12418000009732 Time elapsed = 85 Param Type = c hearingdate=19/01/2026 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=12418000009732 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=16249000009214 @trn_bor_caseregid=16249000009214 *hearingdate=15/10/2025 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16249000009214 for update Time elapsed = 100 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=16249000009214 Time elapsed = 198 Param Type = c hearingdate=15/10/2025 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=16249000009214 >>Posting MD Maps : Select * from trn_bor_casereg where trn_bor_casereg where trn_bor_caseregid=14121000008690 @trn_bor_caseregid=14121000008690 *hearingdate=19/01/2026 *case_purpose_name=10110000000719 *case_purpose_code=122 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14121000008690 for update Time elapsed = 128 SELECT * FROM trn_bor_casereg where trn_bor_caseregid=14121000008690 Time elapsed = 169 Param Type = c hearingdate=19/01/2026 00:00:00 Param Type = c case_purpose_name=10110000000719 Param Type = c case_purpose_code=122 update trn_bor_casereg set hearingdate=to_date(:hearingdate,'dd/mm/yyyy hh24:mi:ss'),case_purpose_name=:case_purpose_name,case_purpose_code=:case_purpose_code where trn_bor_caseregid=14121000008690 Time elapsed for MD Map = 3969005199917 Time elapsed for Save History = 3969005199918 Time elapsed for Save Attachment = 3969005199918 Time elapsed for After Save WF Exec = 3969005199922 Transaction commited Result : {"message":[{"msg":"Cause List Feedback Saved","recordid":"12467000010803"}]} 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=POOJAMEENA Param Type = c calledon=07/10/2025 13:26:26 Param Type = c callfinished=07/10/2025 13:26:39 Param Type = c structname=bocup Param Type = n recordid=0 Param Type = c servicename=Saving data Param Type = c serviceresult=success Param Type = n timetaken=13793 Param Type = n dbtimetaken=12021 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