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,
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
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:
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: );
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:
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
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,
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
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: );
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.
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:
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