APPS.GHR_MASS_AWARDS_PKG dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 62: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,

58: p_person_id in ghr_pa_requests.person_id%TYPE,
59: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
60: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
61: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
62: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
63: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
64: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
65: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
66: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,

Line 63: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,

59: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
60: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
61: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
62: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
63: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
64: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
65: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
66: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
67: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type

Line 64: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,

60: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
61: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
62: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
63: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
64: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
65: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
66: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
67: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
68:

Line 65: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,

61: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
62: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
63: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
64: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
65: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
66: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
67: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
68:
69: );

Line 66: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,

62: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
63: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
64: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
65: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
66: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
67: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
68:
69: );
70:

Line 67: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type

63: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
64: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
65: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
66: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
67: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
68:
69: );
70:
71: PROCEDURE get_award_lac

Line 87: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,

83: p_pa_request_id in ghr_pa_request_ei_shadow.pa_request_id%type,
84: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
85: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
86: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
87: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
88: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
89: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
90: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
91: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,

Line 88: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,

84: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
85: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
86: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
87: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
88: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
89: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
90: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
91: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
92: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type

Line 89: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,

85: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
86: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
87: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
88: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
89: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
90: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
91: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
92: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
93: );

Line 90: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,

86: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
87: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
88: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
89: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
90: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
91: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
92: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
93: );
94: ---- Fetch Remarks and Legal Authority codes.

Line 91: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,

87: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
88: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
89: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
90: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
91: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
92: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
93: );
94: ---- Fetch Remarks and Legal Authority codes.
95:

Line 92: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type

88: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
89: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
90: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
91: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
92: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
93: );
94: ---- Fetch Remarks and Legal Authority codes.
95:
96: PROCEDURE main_awards