eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MASS_AWARDS_PKG dependencies on GHR_PA_REQUEST_EXTRA_INFO

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

188: p_person_id in ghr_pa_requests.person_id%TYPE,
189: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
190: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
191: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
192: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
193: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
194: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
195: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
196: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,

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

189: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
190: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
191: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
192: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
193: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
194: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
195: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
196: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
197: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type

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

190: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
191: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
192: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
193: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
194: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
195: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
196: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
197: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
198: )

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

191: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
192: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
193: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
194: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
195: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
196: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
197: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
198: )
199: ---- Fetch Remarks and Legal Authority codes.

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

192: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
193: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
194: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
195: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
196: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
197: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
198: )
199: ---- Fetch Remarks and Legal Authority codes.
200: IS

Line 197: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type

193: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
194: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
195: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
196: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
197: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
198: )
199: ---- Fetch Remarks and Legal Authority codes.
200: IS
201:

Line 236: FROM ghr_pa_request_extra_info

232: rei_information6 group_award,
233: rei_information7 tangible_benefit_dollars,
234: rei_information9 date_award_earned,
235: rei_information10 appropriation_code
236: FROM ghr_pa_request_extra_info
237: WHERE pa_request_id = c_pa_request_id
238: AND information_type = l_information_type;
239:
240: BEGIN

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

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,
404: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
405: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
406: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
407: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,

Line 404: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%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,
404: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
405: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
406: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
407: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
408: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type

Line 405: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%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,
404: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
405: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
406: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
407: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
408: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
409: )

Line 406: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%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,
404: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
405: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
406: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
407: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
408: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
409: )
410:

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

403: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
404: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
405: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
406: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
407: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
408: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
409: )
410:
411: IS

Line 408: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type

404: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
405: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
406: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,
407: p_date_award_earned out nocopy ghr_pa_request_extra_info.rei_information9%type,
408: p_appropriation_code out nocopy ghr_pa_request_extra_info.rei_information10%type
409: )
410:
411: IS
412:

Line 683: delete from ghr_pa_request_extra_info

679: where pa_request_id = l_pa_request_id;
680:
681: -- Delete the database extra information for the given person_id
682: hr_utility.set_location( l_proc,25);
683: delete from ghr_pa_request_extra_info
684: where pa_request_id = l_pa_request_id;
685:
686: -- Delete the database RPA award routing history record for the given person_id
687: hr_utility.set_location( l_proc,35);

Line 768: FROM ghr_pa_request_extra_info

764: CURSOR cur_rpa_ei (p_pa_request_id number) is
765: SELECT pa_request_extra_info_id,
766: object_version_number,
767: rei_information9
768: FROM ghr_pa_request_extra_info
769: WHERE information_type = l_information_type
770: AND pa_request_id = p_pa_request_id;
771:
772: l_ei_pa_request_extra_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;

Line 772: l_ei_pa_request_extra_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;

768: FROM ghr_pa_request_extra_info
769: WHERE information_type = l_information_type
770: AND pa_request_id = p_pa_request_id;
771:
772: l_ei_pa_request_extra_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;
773: l_ei_ovn ghr_pa_request_extra_info.object_version_number%type;
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

Line 773: l_ei_ovn ghr_pa_request_extra_info.object_version_number%type;

769: WHERE information_type = l_information_type
770: AND pa_request_id = p_pa_request_id;
771:
772: l_ei_pa_request_extra_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;
773: l_ei_ovn ghr_pa_request_extra_info.object_version_number%type;
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

Line 774: l_ei_dae ghr_pa_request_extra_info.rei_information9%type;

770: AND pa_request_id = p_pa_request_id;
771:
772: l_ei_pa_request_extra_id ghr_pa_request_extra_info.pa_request_extra_info_id%type;
773: l_ei_ovn ghr_pa_request_extra_info.object_version_number%type;
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

Line 2778: FROM ghr_pa_request_extra_info

2774:
2775: CURSOR cur_rpa_ei (p_pa_request_id number) is
2776: SELECT pa_request_extra_info_id,
2777: object_version_number
2778: FROM ghr_pa_request_extra_info
2779: WHERE information_type = l_information_type
2780: AND pa_request_id = p_pa_request_id;
2781:
2782: CURSOR cur_rpa_ei_shadow (p_pa_request_id number) is

Line 2931: values (ghr_pa_request_extra_info_s.nextval,

2927: rei_information6,
2928: rei_information7,
2929: rei_information9,
2930: rei_information10)
2931: values (ghr_pa_request_extra_info_s.nextval,
2932: p_pa_request_id,
2933: l_information_type,
2934: l_s_award_agency,
2935: l_s_award_type,