APPS.GHR_CORR_CANC_SF52 dependencies on GHR_PA_REQUEST_SHADOW

Line 77: p_shadow in ghr_pa_request_shadow%rowtype,

73: p_last_row out nocopy boolean,
74: p_cannot_cancel out nocopy boolean) ;
75:
76: Procedure convert_shadow_to_sf52 (
77: p_shadow in ghr_pa_request_shadow%rowtype,
78: p_sf52 out nocopy ghr_pa_requests%rowtype);
79:
80: Procedure IF_ZAP_ELE_ENT(
81: p_element_entry_id in number,

Line 2391: l_shadow_data ghr_pa_request_shadow%rowtype;

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);
2393:
2394: -- this cursor gets the noa_family_code for noa_id (nature of action ID) passed.
2395: cursor c_fam (c_noa_id number) is

Line 2421: from ghr_pa_request_shadow

2417: where pa_request_id = c_pa_request_id;
2418:
2419: cursor get_shadow (c_pa_request_id in number) is
2420: select *
2421: from ghr_pa_request_shadow
2422: where pa_request_id = c_pa_request_id;
2423:
2424: l_proc varchar2(30):='correction_sf52';
2425: l_people_data per_all_people_f%rowtype;

Line 2428: p_shadow_rec in out nocopy ghr_pa_request_shadow%rowtype) is

2424: l_proc varchar2(30):='correction_sf52';
2425: l_people_data per_all_people_f%rowtype;
2426:
2427: Procedure Refresh_Cascade_Name( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
2428: p_shadow_rec in out nocopy ghr_pa_request_shadow%rowtype) is
2429:
2430: l_result_code varchar2(30);
2431: l_people_data per_all_people_f%rowtype;
2432: l_hist_id number;

Line 2443: l_shadow_rec ghr_pa_request_shadow%rowtype;

2439: where pa_request_id = p_sf52_rec.altered_pa_request_id and
2440: nature_of_action_id = p_sf52_rec.second_noa_id;
2441:
2442: l_sf52_rec ghr_pa_requests%rowtype;
2443: l_shadow_rec ghr_pa_request_shadow%rowtype;
2444: Begin
2445:
2446: hr_utility.set_location( 'Entering ' || l_proc, 10);
2447: l_sf52_rec := p_sf52_rec;

Line 3243: l_shadow_data ghr_pa_request_shadow%rowtype;

3239: --bug #6356058 start
3240:
3241:
3242:
3243: l_shadow_data ghr_pa_request_shadow%rowtype;
3244: l_proc varchar2(30):='apply_noa_corrections';
3245: begin
3246: hr_utility.set_location('Entering:'|| l_proc, 5);
3247: l_sf52_data_result := p_sf52_data_result;

Line 4872: p_shadow in ghr_pa_request_shadow%rowtype,

4868:
4869: End Undo_Mark_Cancel;
4870:
4871: Procedure convert_shadow_to_sf52 (
4872: p_shadow in ghr_pa_request_shadow%rowtype,
4873: p_sf52 out nocopy ghr_pa_requests%rowtype) is
4874: l_sf52 ghr_pa_requests%rowtype;
4875: Begin
4876:

Line 4936: p_shadow out nocopy ghr_pa_request_shadow%rowtype

4932: End;
4933:
4934: Procedure convert_sf52_to_shadow (
4935: p_sf52 in ghr_pa_requests%rowtype,
4936: p_shadow out nocopy ghr_pa_request_shadow%rowtype
4937: ) is
4938:
4939: Begin
4940:

Line 5017: l_shadow_data ghr_pa_request_shadow%rowtype;

5013: from ghr_pa_requests
5014: connect by prior altered_pa_request_id = pa_request_id
5015: start with pa_request_id = p_pa_request_id
5016: order by level desc;
5017: l_shadow_data ghr_pa_request_shadow%rowtype;
5018: l_proc varchar2(30):='build_corrected_sf52';
5019:
5020: --Bug 2141522
5021: l_session_var ghr_history_api.g_session_var_type;

Line 6319: Delete from ghr_pa_request_shadow

6315: where pa_request_id = l_sf52_canc.pa_request_id;
6316:
6317: -- Delete Cancelation SF50 Shadow row
6318: hr_utility.set_location(' Deleting Shadow ' || l_sf52_canc.pa_request_id || ' ' || l_proc , 130);
6319: Delete from ghr_pa_request_shadow
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;