APPS.GHR_MASS_AWARDS_PKG dependencies on GHR_PA_REQUEST_EI_SHADOW

Line 399: p_pa_request_id in ghr_pa_request_ei_shadow.pa_request_id%type,

395: END get_award_lac;
396:
397: PROCEDURE get_award_details_shadow
398: (
399: p_pa_request_id in ghr_pa_request_ei_shadow.pa_request_id%type,
400: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
401: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
402: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
403: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,

Line 435: FROM ghr_pa_request_ei_shadow

431: rei_information6 group_award,
432: rei_information7 tangible_benefit_dollars,
433: rei_information9 date_award_earned,
434: rei_information10 appropriation_code
435: FROM ghr_pa_request_ei_shadow
436: WHERE pa_request_id = p_pa_request_id
437: AND information_type = l_information_type;
438:
439: BEGIN

Line 673: delete from ghr_pa_request_ei_shadow

669: l_pa_request_id := cur_rpa_del_rec.pa_request_id;
670:
671: -- Delete the shadow extra information
672: hr_utility.set_location( l_proc,15);
673: delete from ghr_pa_request_ei_shadow
674: where pa_request_id = l_pa_request_id;
675:
676: -- Delete the shadow information
677: hr_utility.set_location( l_proc,20);

Line 778: FROM ghr_pa_request_ei_shadow

774: l_ei_dae ghr_pa_request_extra_info.rei_information9%type;
775:
776: CURSOR cur_rpa_ei_shadow (p_pa_request_id number) is
777: SELECT pa_request_extra_info_id
778: FROM ghr_pa_request_ei_shadow
779: WHERE information_type = l_information_type
780: AND pa_request_id = p_pa_request_id;
781:
782: l_ei_shadow_id ghr_pa_request_ei_shadow.pa_request_extra_info_id%type;

Line 782: l_ei_shadow_id ghr_pa_request_ei_shadow.pa_request_extra_info_id%type;

778: FROM ghr_pa_request_ei_shadow
779: WHERE information_type = l_information_type
780: AND pa_request_id = p_pa_request_id;
781:
782: l_ei_shadow_id ghr_pa_request_ei_shadow.pa_request_extra_info_id%type;
783: L_CNT number(10);
784: l_error_flag BOOLEAN;
785:
786: BEGIN

Line 1145: update ghr_pa_request_ei_shadow

1141: exit;
1142: END LOOP;
1143:
1144: IF l_ei_shadow_id is not null Then
1145: update ghr_pa_request_ei_shadow
1146: set rei_information3 = null,
1147: rei_information4 = null,
1148: rei_information6 = null,
1149: rei_information7 = null,

Line 2767: FROM ghr_pa_request_ei_shadow

2763: AND pa_request_id = p_pa_request_id;
2764:
2765: CURSOR cur_rpa_ei_shadow (p_pa_request_id number) is
2766: SELECT pa_request_extra_info_id
2767: FROM ghr_pa_request_ei_shadow
2768: WHERE information_type = l_information_type
2769: AND pa_request_id = p_pa_request_id;
2770:
2771: BEGIN

Line 2904: insert into ghr_pa_request_ei_shadow

2900: p_pa_request_extra_info_id => l_pa_request_extra_info_id,
2901: p_object_version_number => l_pa_object_version_number);
2902: END IF;
2903: IF l_pa_request_extra_info_sh_id is null then
2904: insert into ghr_pa_request_ei_shadow
2905: (pa_request_extra_info_id,
2906: pa_request_id,
2907: information_type,
2908: rei_information3,

Line 2923: ELSE update ghr_pa_request_ei_shadow

2919: l_s_group_award,
2920: l_s_tbd,
2921: l_s_date_award_earn,
2922: l_s_appropriation_code);
2923: ELSE update ghr_pa_request_ei_shadow
2924: set rei_information3 = l_s_award_agency,
2925: rei_information4 = l_s_award_type,
2926: rei_information6 = l_s_group_award,
2927: rei_information7 = l_s_tbd,