eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.GHR_CORR_CANC_SF52 dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 185: l_agency_ei_data ghr_pa_request_extra_info%rowtype;

181: l_interv_on_table boolean;
182: l_interv_on_eff_date boolean;
183: l_hist_data_as_of_date ghr_pa_history%rowtype;
184: l_session_var ghr_history_api.g_session_var_type;
185: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
186: l_imm_asg_sf52 ghr_api.asg_sf52_type;
187: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
188: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
189: l_imm_per_sf52 ghr_api.per_sf52_type;

Line 785: l_agency_ei_data ghr_pa_request_extra_info%rowtype;

781: l_business_group_id number;
782: l_u_prh_object_version_number number;
783: l_i_pa_routing_history_id number;
784: l_i_prh_object_version_number number;
785: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
786: l_imm_asg_sf52 ghr_api.asg_sf52_type;
787: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
788: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
789: l_imm_per_sf52 ghr_api.per_sf52_type;

Line 1475: l_agency_ei_data ghr_pa_request_extra_info%rowtype;

1471: l_session_var ghr_history_api.g_session_var_type;
1472: l_result_code varchar2(30);
1473: l_rec_created_flag boolean;
1474: l_del_mode varchar2(30);
1475: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
1476: l_imm_asg_sf52 ghr_api.asg_sf52_type;
1477: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
1478: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
1479: l_imm_per_sf52 ghr_api.per_sf52_type;

Line 2387: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;

2383:
2384: l_pa_request_id number;
2385: l_today date :=sysdate;
2386: l_session_var ghr_history_api.g_session_var_type;
2387: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
2388: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
2389: l_sf52_data ghr_pa_requests%rowtype;
2390: l_sf52_data1 ghr_pa_requests%rowtype;
2391: l_shadow_data ghr_pa_request_shadow%rowtype;

Line 2388: l_agency_ei_data ghr_pa_request_extra_info%rowtype;

2384: l_pa_request_id number;
2385: l_today date :=sysdate;
2386: l_session_var ghr_history_api.g_session_var_type;
2387: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
2388: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
2389: l_sf52_data ghr_pa_requests%rowtype;
2390: l_sf52_data1 ghr_pa_requests%rowtype;
2391: l_shadow_data ghr_pa_request_shadow%rowtype;
2392: l_result varchar2(1000);

Line 6324: delete ghr_pa_request_extra_info

6320: where pa_request_id = l_sf52_canc.pa_request_id;
6321:
6322: -- Delete Pa_request_EI data
6323: -- for l_sf52_canc.pa_request_id;
6324: delete ghr_pa_request_extra_info
6325: where pa_request_id = l_sf52_canc.pa_request_id;
6326:
6327: -- Delete pa_reques row
6328: l_sf52_canc.object_version_number := get_sf52_ovn( l_sf52_canc.pa_request_id);