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 2652: l_shadow_data ghr_pa_request_shadow%rowtype;

2648: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
2649: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
2650: l_sf52_data ghr_pa_requests%rowtype;
2651: l_sf52_data1 ghr_pa_requests%rowtype;
2652: l_shadow_data ghr_pa_request_shadow%rowtype;
2653: l_result varchar2(1000);
2654:
2655: -- this cursor gets the noa_family_code for noa_id (nature of action ID) passed.
2656: cursor c_fam (c_noa_id number) is

Line 2682: from ghr_pa_request_shadow

2678: where pa_request_id = c_pa_request_id;
2679:
2680: cursor get_shadow (c_pa_request_id in number) is
2681: select *
2682: from ghr_pa_request_shadow
2683: where pa_request_id = c_pa_request_id;
2684:
2685: l_proc varchar2(30):='correction_sf52';
2686: l_people_data per_all_people_f%rowtype;

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

2704:
2705:
2706:
2707: Procedure Refresh_Cascade_Name( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
2708: p_shadow_rec in out nocopy ghr_pa_request_shadow%rowtype) is
2709:
2710: l_result_code varchar2(30);
2711: l_people_data per_all_people_f%rowtype;
2712: l_hist_id number;

Line 2723: l_shadow_rec ghr_pa_request_shadow%rowtype;

2719: where pa_request_id = p_sf52_rec.altered_pa_request_id and
2720: nature_of_action_id = p_sf52_rec.second_noa_id;
2721:
2722: l_sf52_rec ghr_pa_requests%rowtype;
2723: l_shadow_rec ghr_pa_request_shadow%rowtype;
2724: Begin
2725:
2726: hr_utility.set_location( 'Entering ' || l_proc, 10);
2727: l_sf52_rec := p_sf52_rec;

Line 3551: l_shadow_data ghr_pa_request_shadow%rowtype;

3547: --bug #6356058 start
3548:
3549:
3550:
3551: l_shadow_data ghr_pa_request_shadow%rowtype;
3552: l_proc varchar2(30):='apply_noa_corrections';
3553: begin
3554: hr_utility.set_location('Entering:'|| l_proc, 5);
3555: l_sf52_data_result := p_sf52_data_result;

Line 5214: p_shadow in ghr_pa_request_shadow%rowtype,

5210:
5211: End Undo_Mark_Cancel;
5212:
5213: Procedure convert_shadow_to_sf52 (
5214: p_shadow in ghr_pa_request_shadow%rowtype,
5215: p_sf52 out nocopy ghr_pa_requests%rowtype) is
5216: l_sf52 ghr_pa_requests%rowtype;
5217: Begin
5218:

Line 5278: p_shadow out nocopy ghr_pa_request_shadow%rowtype

5274: End;
5275:
5276: Procedure convert_sf52_to_shadow (
5277: p_sf52 in ghr_pa_requests%rowtype,
5278: p_shadow out nocopy ghr_pa_request_shadow%rowtype
5279: ) is
5280:
5281: Begin
5282:

Line 5359: l_shadow_data ghr_pa_request_shadow%rowtype;

5355: from ghr_pa_requests
5356: connect by prior altered_pa_request_id = pa_request_id
5357: start with pa_request_id = p_pa_request_id
5358: order by level desc;
5359: l_shadow_data ghr_pa_request_shadow%rowtype;
5360: l_proc varchar2(30):='build_corrected_sf52';
5361:
5362: --Bug 2141522
5363: l_session_var ghr_history_api.g_session_var_type;

Line 6674: Delete from ghr_pa_request_shadow

6670: where pa_request_id = l_sf52_canc.pa_request_id;
6671:
6672: -- Delete Cancelation SF50 Shadow row
6673: hr_utility.set_location(' Deleting Shadow ' || l_sf52_canc.pa_request_id || ' ' || l_proc , 130);
6674: Delete from ghr_pa_request_shadow
6675: where pa_request_id = l_sf52_canc.pa_request_id;
6676:
6677: -- Delete Pa_request_EI data
6678: -- for l_sf52_canc.pa_request_id;

Line 7364: l_shadow_data ghr_pa_request_shadow%rowtype;

7360: connect by pa_request_id = prior altered_pa_request_id
7361: start with pa_request_id = p_pa_request_id));
7362:
7363:
7364: l_shadow_data ghr_pa_request_shadow%rowtype;
7365: l_proc varchar2(30):='apply_dual_noa_corrections';
7366: l_dual_flag varchar2(1);
7367: l_retro_action_exists varchar2(1) := 'N';
7368: begin