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 2784: FROM ghr_pa_request_ei_shadow

2780: AND pa_request_id = p_pa_request_id;
2781:
2782: CURSOR cur_rpa_ei_shadow (p_pa_request_id number) is
2783: SELECT pa_request_extra_info_id
2784: FROM ghr_pa_request_ei_shadow
2785: WHERE information_type = l_information_type
2786: AND pa_request_id = p_pa_request_id;
2787:
2788: BEGIN

Line 2921: insert into ghr_pa_request_ei_shadow

2917: p_pa_request_extra_info_id => l_pa_request_extra_info_id,
2918: p_object_version_number => l_pa_object_version_number);
2919: END IF;
2920: IF l_pa_request_extra_info_sh_id is null then
2921: insert into ghr_pa_request_ei_shadow
2922: (pa_request_extra_info_id,
2923: pa_request_id,
2924: information_type,
2925: rei_information3,

Line 2940: ELSE update ghr_pa_request_ei_shadow

2936: l_s_group_award,
2937: l_s_tbd,
2938: l_s_date_award_earn,
2939: l_s_appropriation_code);
2940: ELSE update ghr_pa_request_ei_shadow
2941: set rei_information3 = l_s_award_agency,
2942: rei_information4 = l_s_award_type,
2943: rei_information6 = l_s_group_award,
2944: rei_information7 = l_s_tbd,