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_REQUESTS

Line 116: p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,

112: PROCEDURE get_pa_request_id_ovn (
113: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
114: p_effective_date in date,
115: p_person_id in per_people_f.person_id%TYPE,
116: p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,
117: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
118: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
119: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,
120: p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,

Line 117: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,

113: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
114: p_effective_date in date,
115: p_person_id in per_people_f.person_id%TYPE,
116: p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,
117: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
118: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
119: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,
120: p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,
121: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE)

Line 118: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,

114: p_effective_date in date,
115: p_person_id in per_people_f.person_id%TYPE,
116: p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,
117: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
118: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
119: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,
120: p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,
121: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE)
122:

Line 119: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,

115: p_person_id in per_people_f.person_id%TYPE,
116: p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,
117: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
118: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
119: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,
120: p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,
121: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE)
122:
123: IS

Line 120: p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,

116: p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,
117: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
118: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
119: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,
120: p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,
121: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE)
122:
123: IS
124:

Line 121: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE)

117: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
118: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
119: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,
120: p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,
121: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE)
122:
123: IS
124:
125: --

Line 135: FROM ghr_pa_requests

131: CURSOR cur_rpa IS
132: SELECT pa_request_id, object_version_number,
133: pa_notification_id,rpa_type, mass_action_select_flag,
134: mass_action_comments
135: FROM ghr_pa_requests
136: WHERE mass_action_id = p_mass_award_id
137: AND effective_date = trunc(p_effective_date)
138: AND person_id = p_person_id;
139:

Line 186: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

182:
183: PROCEDURE get_award_details
184: (
185: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
186: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
187: p_effective_date in date,
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,

Line 188: p_person_id in ghr_pa_requests.person_id%TYPE,

184: (
185: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
186: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
187: p_effective_date in date,
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,

Line 189: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,

185: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
186: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
187: p_effective_date in date,
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,

Line 190: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,

186: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
187: p_effective_date in date,
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,

Line 191: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,

187: p_effective_date in date,
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,

Line 207: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

203: -- local variables
204: --
205:
206: l_proc varchar2(72) := g_package || 'get_award_details';
207: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
208:
209: CURSOR cur_rpa_tmp IS
210: SELECT pa_request_id,
211: award_amount,

Line 214: FROM ghr_pa_requests

210: SELECT pa_request_id,
211: award_amount,
212: award_uom,
213: award_percentage
214: FROM ghr_pa_requests
215: WHERE mass_action_id = p_mass_award_id
216: AND rpa_type = p_rpa_type
217: AND person_id is null;
218:

Line 224: FROM ghr_pa_requests

220: SELECT pa_request_id,
221: award_amount,
222: award_uom,
223: award_percentage
224: FROM ghr_pa_requests
225: WHERE mass_action_id = p_mass_award_id
226: AND rpa_type = p_rpa_type
227: AND person_id = p_person_id;
228:

Line 229: CURSOR cur_award_ei(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS

225: WHERE mass_action_id = p_mass_award_id
226: AND rpa_type = p_rpa_type
227: AND person_id = p_person_id;
228:
229: CURSOR cur_award_ei(c_pa_request_id ghr_pa_requests.pa_request_id%type) IS
230: SELECT rei_information3 award_agency,
231: rei_information4 award_type,
232: rei_information6 group_award,
233: rei_information7 tangible_benefit_dollars,

Line 322: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

318:
319: PROCEDURE get_award_lac
320: (
321: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
322: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
323: p_effective_date in date,
324: p_first_lac1_record out nocopy first_lac1_record,
325: p_first_lac2_record out nocopy first_lac2_record
326: )

Line 335: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

331: -- local variables
332: --
333:
334: l_proc varchar2(72) := g_package || 'get_award_lac';
335: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
336:
337:
338: CURSOR cur_rpa_lac IS
339: SELECT first_action_la_code1,

Line 353: FROM ghr_pa_requests

349: first_lac2_information2,
350: first_lac2_information3,
351: first_lac2_information4,
352: first_lac2_information5
353: FROM ghr_pa_requests
354: WHERE mass_action_id = p_mass_award_id
355: AND rpa_type = p_rpa_type
356: AND person_id is null;
357:

Line 400: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,

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,
404: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,

Line 401: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,

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,
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,

Line 402: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,

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,
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,

Line 418: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

414: -- local variables
415: --
416:
417: l_proc varchar2(72) := g_package || 'get_award_details_shadow';
418: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
419:
420: CURSOR cur_rpa_shadow IS
421: SELECT
422: award_amount,

Line 611: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

607:
608: PROCEDURE upd_elig_flag_bef_selection
609: (
610: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
611: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
612: p_effective_date in date
613: )
614:
615: is

Line 625: from ghr_pa_requests

621:
622: hr_utility.set_location('Entering ' || l_proc,5);
623:
624: select count(*) into l_cntr
625: from ghr_pa_requests
626: where mass_action_id = p_mass_award_id
627: and rpa_type = p_rpa_type
628: and pa_notification_id is null;
629:

Line 632: update ghr_pa_requests set

628: and pa_notification_id is null;
629:
630: hr_utility.set_location('No of rows :' || to_char(l_cntr) || l_proc,10);
631:
632: update ghr_pa_requests set
633: mass_action_eligible_flag = 'N'
634: where mass_action_id = p_mass_award_id
635: and rpa_type = p_rpa_type
636: and pa_notification_id is null;

Line 647: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

643:
644: PROCEDURE del_elig_flag_aft_selection
645: (
646: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
647: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
648: p_effective_date in date
649: )
650:
651: IS

Line 654: l_pa_request_id ghr_pa_requests.pa_request_id%type;

650:
651: IS
652:
653: l_proc varchar2(72) := g_package || 'del_elig_flag_aft_selection';
654: l_pa_request_id ghr_pa_requests.pa_request_id%type;
655:
656: CURSOR cur_rpa_del is
657: SELECT pa_request_id
658: FROM ghr_pa_requests

Line 658: FROM ghr_pa_requests

654: l_pa_request_id ghr_pa_requests.pa_request_id%type;
655:
656: CURSOR cur_rpa_del is
657: SELECT pa_request_id
658: FROM ghr_pa_requests
659: WHERE mass_action_id = p_mass_award_id
660: AND rpa_type = p_rpa_type
661: AND mass_action_eligible_flag = 'N'
662: AND pa_notification_id is null;

Line 693: delete from ghr_pa_requests

689: where pa_request_id = l_pa_request_id;
690:
691: -- Delete the database RPA award record for the given person_id
692: hr_utility.set_location( l_proc,35);
693: delete from ghr_pa_requests
694: where pa_request_id = l_pa_request_id;
695: END LOOP;
696: END del_elig_flag_aft_selection;
697:

Line 702: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

698: Procedure marpa_process
699: (
700: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
701: p_action_type in VARCHAR2,
702: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
703: p_effective_date in date,
704: p_person_id in per_people_f.person_id%TYPE,
705: p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,
706: p_log_text out nocopy varchar2,

Line 705: p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,

701: p_action_type in VARCHAR2,
702: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
703: p_effective_date in date,
704: p_person_id in per_people_f.person_id%TYPE,
705: p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,
706: p_log_text out nocopy varchar2,
707: p_maxcheck out nocopy number
708: )
709:

Line 713: l_pa_request_rec ghr_pa_requests%rowtype;

709:
710: IS
711:
712: l_proc varchar2(72) := g_package || 'marpa_process';
713: l_pa_request_rec ghr_pa_requests%rowtype;
714: l_log_text varchar2(2000);
715: l_result boolean;
716:
717: l_dummy varchar2(30);

Line 719: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

715: l_result boolean;
716:
717: l_dummy varchar2(30);
718: l_dummy_number number;
719: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
720: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
721: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
722: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;
723: --Bug#3804067 Added l_mass_aciton_comments variable

Line 720: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;

716:
717: l_dummy varchar2(30);
718: l_dummy_number number;
719: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
720: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
721: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
722: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;
723: --Bug#3804067 Added l_mass_aciton_comments variable
724: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;

Line 721: l_rpa_type ghr_pa_requests.rpa_type%TYPE;

717: l_dummy varchar2(30);
718: l_dummy_number number;
719: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
720: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
721: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
722: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;
723: --Bug#3804067 Added l_mass_aciton_comments variable
724: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;
725: l_object_version_number ghr_pa_requests.object_version_number%type;

Line 722: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;

718: l_dummy_number number;
719: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
720: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
721: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
722: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;
723: --Bug#3804067 Added l_mass_aciton_comments variable
724: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;
725: l_object_version_number ghr_pa_requests.object_version_number%type;
726:

Line 724: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;

720: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
721: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
722: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;
723: --Bug#3804067 Added l_mass_aciton_comments variable
724: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;
725: l_object_version_number ghr_pa_requests.object_version_number%type;
726:
727: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
728: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

Line 725: l_object_version_number ghr_pa_requests.object_version_number%type;

721: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
722: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;
723: --Bug#3804067 Added l_mass_aciton_comments variable
724: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;
725: l_object_version_number ghr_pa_requests.object_version_number%type;
726:
727: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
728: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
729: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;

Line 727: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;

723: --Bug#3804067 Added l_mass_aciton_comments variable
724: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;
725: l_object_version_number ghr_pa_requests.object_version_number%type;
726:
727: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
728: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
729: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
730: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
731:

Line 729: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;

725: l_object_version_number ghr_pa_requests.object_version_number%type;
726:
727: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
728: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
729: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
730: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
731:
732: l_approval_date date;
733: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;

Line 733: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;

729: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
730: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
731:
732: l_approval_date date;
733: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
734: l_1_approval_status varchar2(10);
735:
736: l_bt_award_amount ghr_pa_requests.award_amount%type;
737: l_bt_award_percentage ghr_pa_requests.award_percentage%type;

Line 736: l_bt_award_amount ghr_pa_requests.award_amount%type;

732: l_approval_date date;
733: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
734: l_1_approval_status varchar2(10);
735:
736: l_bt_award_amount ghr_pa_requests.award_amount%type;
737: l_bt_award_percentage ghr_pa_requests.award_percentage%type;
738: l_bs_award_amount ghr_pa_requests.award_amount%type;
739: l_bs_award_percentage ghr_pa_requests.award_percentage%type;
740: l_bd_award_amount ghr_pa_requests.award_amount%type;

Line 737: l_bt_award_percentage ghr_pa_requests.award_percentage%type;

733: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
734: l_1_approval_status varchar2(10);
735:
736: l_bt_award_amount ghr_pa_requests.award_amount%type;
737: l_bt_award_percentage ghr_pa_requests.award_percentage%type;
738: l_bs_award_amount ghr_pa_requests.award_amount%type;
739: l_bs_award_percentage ghr_pa_requests.award_percentage%type;
740: l_bd_award_amount ghr_pa_requests.award_amount%type;
741: l_bd_award_percentage ghr_pa_requests.award_percentage%type;

Line 738: l_bs_award_amount ghr_pa_requests.award_amount%type;

734: l_1_approval_status varchar2(10);
735:
736: l_bt_award_amount ghr_pa_requests.award_amount%type;
737: l_bt_award_percentage ghr_pa_requests.award_percentage%type;
738: l_bs_award_amount ghr_pa_requests.award_amount%type;
739: l_bs_award_percentage ghr_pa_requests.award_percentage%type;
740: l_bd_award_amount ghr_pa_requests.award_amount%type;
741: l_bd_award_percentage ghr_pa_requests.award_percentage%type;
742:

Line 739: l_bs_award_percentage ghr_pa_requests.award_percentage%type;

735:
736: l_bt_award_amount ghr_pa_requests.award_amount%type;
737: l_bt_award_percentage ghr_pa_requests.award_percentage%type;
738: l_bs_award_amount ghr_pa_requests.award_amount%type;
739: l_bs_award_percentage ghr_pa_requests.award_percentage%type;
740: l_bd_award_amount ghr_pa_requests.award_amount%type;
741: l_bd_award_percentage ghr_pa_requests.award_percentage%type;
742:
743: l_t_award_amount ghr_pa_requests.award_amount%type;

Line 740: l_bd_award_amount ghr_pa_requests.award_amount%type;

736: l_bt_award_amount ghr_pa_requests.award_amount%type;
737: l_bt_award_percentage ghr_pa_requests.award_percentage%type;
738: l_bs_award_amount ghr_pa_requests.award_amount%type;
739: l_bs_award_percentage ghr_pa_requests.award_percentage%type;
740: l_bd_award_amount ghr_pa_requests.award_amount%type;
741: l_bd_award_percentage ghr_pa_requests.award_percentage%type;
742:
743: l_t_award_amount ghr_pa_requests.award_amount%type;
744: l_t_award_uom ghr_pa_requests.award_uom%type;

Line 741: l_bd_award_percentage ghr_pa_requests.award_percentage%type;

737: l_bt_award_percentage ghr_pa_requests.award_percentage%type;
738: l_bs_award_amount ghr_pa_requests.award_amount%type;
739: l_bs_award_percentage ghr_pa_requests.award_percentage%type;
740: l_bd_award_amount ghr_pa_requests.award_amount%type;
741: l_bd_award_percentage ghr_pa_requests.award_percentage%type;
742:
743: l_t_award_amount ghr_pa_requests.award_amount%type;
744: l_t_award_uom ghr_pa_requests.award_uom%type;
745: l_t_award_percentage ghr_pa_requests.award_percentage%type;

Line 743: l_t_award_amount ghr_pa_requests.award_amount%type;

739: l_bs_award_percentage ghr_pa_requests.award_percentage%type;
740: l_bd_award_amount ghr_pa_requests.award_amount%type;
741: l_bd_award_percentage ghr_pa_requests.award_percentage%type;
742:
743: l_t_award_amount ghr_pa_requests.award_amount%type;
744: l_t_award_uom ghr_pa_requests.award_uom%type;
745: l_t_award_percentage ghr_pa_requests.award_percentage%type;
746:
747: l_d_award_amount ghr_pa_requests.award_amount%type;

Line 744: l_t_award_uom ghr_pa_requests.award_uom%type;

740: l_bd_award_amount ghr_pa_requests.award_amount%type;
741: l_bd_award_percentage ghr_pa_requests.award_percentage%type;
742:
743: l_t_award_amount ghr_pa_requests.award_amount%type;
744: l_t_award_uom ghr_pa_requests.award_uom%type;
745: l_t_award_percentage ghr_pa_requests.award_percentage%type;
746:
747: l_d_award_amount ghr_pa_requests.award_amount%type;
748: l_d_award_uom ghr_pa_requests.award_uom%type;

Line 745: l_t_award_percentage ghr_pa_requests.award_percentage%type;

741: l_bd_award_percentage ghr_pa_requests.award_percentage%type;
742:
743: l_t_award_amount ghr_pa_requests.award_amount%type;
744: l_t_award_uom ghr_pa_requests.award_uom%type;
745: l_t_award_percentage ghr_pa_requests.award_percentage%type;
746:
747: l_d_award_amount ghr_pa_requests.award_amount%type;
748: l_d_award_uom ghr_pa_requests.award_uom%type;
749: l_d_award_percentage ghr_pa_requests.award_percentage%type;

Line 747: l_d_award_amount ghr_pa_requests.award_amount%type;

743: l_t_award_amount ghr_pa_requests.award_amount%type;
744: l_t_award_uom ghr_pa_requests.award_uom%type;
745: l_t_award_percentage ghr_pa_requests.award_percentage%type;
746:
747: l_d_award_amount ghr_pa_requests.award_amount%type;
748: l_d_award_uom ghr_pa_requests.award_uom%type;
749: l_d_award_percentage ghr_pa_requests.award_percentage%type;
750:
751: l_s_award_amount ghr_pa_requests.award_amount%type;

Line 748: l_d_award_uom ghr_pa_requests.award_uom%type;

744: l_t_award_uom ghr_pa_requests.award_uom%type;
745: l_t_award_percentage ghr_pa_requests.award_percentage%type;
746:
747: l_d_award_amount ghr_pa_requests.award_amount%type;
748: l_d_award_uom ghr_pa_requests.award_uom%type;
749: l_d_award_percentage ghr_pa_requests.award_percentage%type;
750:
751: l_s_award_amount ghr_pa_requests.award_amount%type;
752: l_s_award_uom ghr_pa_requests.award_uom%type;

Line 749: l_d_award_percentage ghr_pa_requests.award_percentage%type;

745: l_t_award_percentage ghr_pa_requests.award_percentage%type;
746:
747: l_d_award_amount ghr_pa_requests.award_amount%type;
748: l_d_award_uom ghr_pa_requests.award_uom%type;
749: l_d_award_percentage ghr_pa_requests.award_percentage%type;
750:
751: l_s_award_amount ghr_pa_requests.award_amount%type;
752: l_s_award_uom ghr_pa_requests.award_uom%type;
753: l_s_award_percentage ghr_pa_requests.award_percentage%type;

Line 751: l_s_award_amount ghr_pa_requests.award_amount%type;

747: l_d_award_amount ghr_pa_requests.award_amount%type;
748: l_d_award_uom ghr_pa_requests.award_uom%type;
749: l_d_award_percentage ghr_pa_requests.award_percentage%type;
750:
751: l_s_award_amount ghr_pa_requests.award_amount%type;
752: l_s_award_uom ghr_pa_requests.award_uom%type;
753: l_s_award_percentage ghr_pa_requests.award_percentage%type;
754:
755: l_u_prh_object_version_number number;

Line 752: l_s_award_uom ghr_pa_requests.award_uom%type;

748: l_d_award_uom ghr_pa_requests.award_uom%type;
749: l_d_award_percentage ghr_pa_requests.award_percentage%type;
750:
751: l_s_award_amount ghr_pa_requests.award_amount%type;
752: l_s_award_uom ghr_pa_requests.award_uom%type;
753: l_s_award_percentage ghr_pa_requests.award_percentage%type;
754:
755: l_u_prh_object_version_number number;
756: l_i_pa_routing_history_id number;

Line 753: l_s_award_percentage ghr_pa_requests.award_percentage%type;

749: l_d_award_percentage ghr_pa_requests.award_percentage%type;
750:
751: l_s_award_amount ghr_pa_requests.award_amount%type;
752: l_s_award_uom ghr_pa_requests.award_uom%type;
753: l_s_award_percentage ghr_pa_requests.award_percentage%type;
754:
755: l_u_prh_object_version_number number;
756: l_i_pa_routing_history_id number;
757: l_i_prh_object_version_number number;

Line 1607: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

1603: Procedure build_rpa_for_mass_awards
1604: (
1605: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
1606: p_action_type in VARCHAR2,
1607: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
1608: p_effective_date in date,
1609: p_person_id in per_people_f.person_id%TYPE,
1610: p_assignment_id in per_assignments_f.assignment_id%TYPE,
1611: p_position_id in hr_positions_f.position_id%TYPE,

Line 1628: l_pa_request_rec ghr_pa_requests%rowtype;

1624: l_dummy varchar2(30);
1625: l_dummy_number number;
1626: l_business_group_id number;
1627:
1628: l_pa_request_rec ghr_pa_requests%rowtype;
1629:
1630: l_personnel_officer_name per_people_f.full_name%type;
1631: l_approval_date date;
1632: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;

Line 1632: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;

1628: l_pa_request_rec ghr_pa_requests%rowtype;
1629:
1630: l_personnel_officer_name per_people_f.full_name%type;
1631: l_approval_date date;
1632: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
1633: l_1_approval_status varchar2(10);
1634:
1635: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
1636: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

Line 1635: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;

1631: l_approval_date date;
1632: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
1633: l_1_approval_status varchar2(10);
1634:
1635: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
1636: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1637: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
1638: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1639:

Line 1637: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;

1633: l_1_approval_status varchar2(10);
1634:
1635: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
1636: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1637: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
1638: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1639:
1640: l_multiple_error_flag boolean;
1641: l_result boolean;

Line 1645: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;

1641: l_result boolean;
1642:
1643: l_scd_leave varchar2(30);
1644: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
1645: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
1646: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
1647: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
1648: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;
1649: -- Bug#3804067 Added variable l_mass_action_comments

Line 1646: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;

1642:
1643: l_scd_leave varchar2(30);
1644: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
1645: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
1646: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
1647: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
1648: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;
1649: -- Bug#3804067 Added variable l_mass_action_comments
1650: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;

Line 1647: l_rpa_type ghr_pa_requests.rpa_type%TYPE;

1643: l_scd_leave varchar2(30);
1644: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
1645: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
1646: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
1647: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
1648: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;
1649: -- Bug#3804067 Added variable l_mass_action_comments
1650: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;
1651: l_object_version_number ghr_pa_requests.object_version_number%type;

Line 1648: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;

1644: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
1645: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
1646: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
1647: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
1648: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;
1649: -- Bug#3804067 Added variable l_mass_action_comments
1650: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;
1651: l_object_version_number ghr_pa_requests.object_version_number%type;
1652: l_log_text varchar2(2000);

Line 1650: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;

1646: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
1647: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
1648: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;
1649: -- Bug#3804067 Added variable l_mass_action_comments
1650: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;
1651: l_object_version_number ghr_pa_requests.object_version_number%type;
1652: l_log_text varchar2(2000);
1653: l_routing_group_id ghr_pa_requests.routing_group_id%type;
1654: l_groupbox_id ghr_groupboxes.groupbox_id%type;

Line 1651: l_object_version_number ghr_pa_requests.object_version_number%type;

1647: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
1648: l_mass_action_select_flag ghr_pa_requests.mass_action_select_flag%TYPE;
1649: -- Bug#3804067 Added variable l_mass_action_comments
1650: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;
1651: l_object_version_number ghr_pa_requests.object_version_number%type;
1652: l_log_text varchar2(2000);
1653: l_routing_group_id ghr_pa_requests.routing_group_id%type;
1654: l_groupbox_id ghr_groupboxes.groupbox_id%type;
1655: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

Line 1653: l_routing_group_id ghr_pa_requests.routing_group_id%type;

1649: -- Bug#3804067 Added variable l_mass_action_comments
1650: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;
1651: l_object_version_number ghr_pa_requests.object_version_number%type;
1652: l_log_text varchar2(2000);
1653: l_routing_group_id ghr_pa_requests.routing_group_id%type;
1654: l_groupbox_id ghr_groupboxes.groupbox_id%type;
1655: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1656: l_prh_object_version_number ghr_pa_routing_history.object_version_number%type;
1657:

Line 1665: l_bt_award_amount ghr_pa_requests.award_amount%type;

1661: l_duty_station_desc ghr_duty_stations_v.duty_station_desc%TYPE;
1662: l_appropriation_code1 varchar2(30);
1663: l_appropriation_code2 varchar2(30);
1664:
1665: l_bt_award_amount ghr_pa_requests.award_amount%type;
1666: l_bt_award_percentage ghr_pa_requests.award_percentage%type;
1667: l_bs_award_amount ghr_pa_requests.award_amount%type;
1668: l_bs_award_percentage ghr_pa_requests.award_percentage%type;
1669: l_bd_award_amount ghr_pa_requests.award_amount%type;

Line 1666: l_bt_award_percentage ghr_pa_requests.award_percentage%type;

1662: l_appropriation_code1 varchar2(30);
1663: l_appropriation_code2 varchar2(30);
1664:
1665: l_bt_award_amount ghr_pa_requests.award_amount%type;
1666: l_bt_award_percentage ghr_pa_requests.award_percentage%type;
1667: l_bs_award_amount ghr_pa_requests.award_amount%type;
1668: l_bs_award_percentage ghr_pa_requests.award_percentage%type;
1669: l_bd_award_amount ghr_pa_requests.award_amount%type;
1670: l_bd_award_percentage ghr_pa_requests.award_percentage%type;

Line 1667: l_bs_award_amount ghr_pa_requests.award_amount%type;

1663: l_appropriation_code2 varchar2(30);
1664:
1665: l_bt_award_amount ghr_pa_requests.award_amount%type;
1666: l_bt_award_percentage ghr_pa_requests.award_percentage%type;
1667: l_bs_award_amount ghr_pa_requests.award_amount%type;
1668: l_bs_award_percentage ghr_pa_requests.award_percentage%type;
1669: l_bd_award_amount ghr_pa_requests.award_amount%type;
1670: l_bd_award_percentage ghr_pa_requests.award_percentage%type;
1671:

Line 1668: l_bs_award_percentage ghr_pa_requests.award_percentage%type;

1664:
1665: l_bt_award_amount ghr_pa_requests.award_amount%type;
1666: l_bt_award_percentage ghr_pa_requests.award_percentage%type;
1667: l_bs_award_amount ghr_pa_requests.award_amount%type;
1668: l_bs_award_percentage ghr_pa_requests.award_percentage%type;
1669: l_bd_award_amount ghr_pa_requests.award_amount%type;
1670: l_bd_award_percentage ghr_pa_requests.award_percentage%type;
1671:
1672: l_t_award_amount ghr_pa_requests.award_amount%type;

Line 1669: l_bd_award_amount ghr_pa_requests.award_amount%type;

1665: l_bt_award_amount ghr_pa_requests.award_amount%type;
1666: l_bt_award_percentage ghr_pa_requests.award_percentage%type;
1667: l_bs_award_amount ghr_pa_requests.award_amount%type;
1668: l_bs_award_percentage ghr_pa_requests.award_percentage%type;
1669: l_bd_award_amount ghr_pa_requests.award_amount%type;
1670: l_bd_award_percentage ghr_pa_requests.award_percentage%type;
1671:
1672: l_t_award_amount ghr_pa_requests.award_amount%type;
1673: l_t_award_uom ghr_pa_requests.award_uom%type;

Line 1670: l_bd_award_percentage ghr_pa_requests.award_percentage%type;

1666: l_bt_award_percentage ghr_pa_requests.award_percentage%type;
1667: l_bs_award_amount ghr_pa_requests.award_amount%type;
1668: l_bs_award_percentage ghr_pa_requests.award_percentage%type;
1669: l_bd_award_amount ghr_pa_requests.award_amount%type;
1670: l_bd_award_percentage ghr_pa_requests.award_percentage%type;
1671:
1672: l_t_award_amount ghr_pa_requests.award_amount%type;
1673: l_t_award_uom ghr_pa_requests.award_uom%type;
1674: l_t_award_percentage ghr_pa_requests.award_percentage%type;

Line 1672: l_t_award_amount ghr_pa_requests.award_amount%type;

1668: l_bs_award_percentage ghr_pa_requests.award_percentage%type;
1669: l_bd_award_amount ghr_pa_requests.award_amount%type;
1670: l_bd_award_percentage ghr_pa_requests.award_percentage%type;
1671:
1672: l_t_award_amount ghr_pa_requests.award_amount%type;
1673: l_t_award_uom ghr_pa_requests.award_uom%type;
1674: l_t_award_percentage ghr_pa_requests.award_percentage%type;
1675:
1676: l_d_award_amount ghr_pa_requests.award_amount%type;

Line 1673: l_t_award_uom ghr_pa_requests.award_uom%type;

1669: l_bd_award_amount ghr_pa_requests.award_amount%type;
1670: l_bd_award_percentage ghr_pa_requests.award_percentage%type;
1671:
1672: l_t_award_amount ghr_pa_requests.award_amount%type;
1673: l_t_award_uom ghr_pa_requests.award_uom%type;
1674: l_t_award_percentage ghr_pa_requests.award_percentage%type;
1675:
1676: l_d_award_amount ghr_pa_requests.award_amount%type;
1677: l_d_award_uom ghr_pa_requests.award_uom%type;

Line 1674: l_t_award_percentage ghr_pa_requests.award_percentage%type;

1670: l_bd_award_percentage ghr_pa_requests.award_percentage%type;
1671:
1672: l_t_award_amount ghr_pa_requests.award_amount%type;
1673: l_t_award_uom ghr_pa_requests.award_uom%type;
1674: l_t_award_percentage ghr_pa_requests.award_percentage%type;
1675:
1676: l_d_award_amount ghr_pa_requests.award_amount%type;
1677: l_d_award_uom ghr_pa_requests.award_uom%type;
1678: l_d_award_percentage ghr_pa_requests.award_percentage%type;

Line 1676: l_d_award_amount ghr_pa_requests.award_amount%type;

1672: l_t_award_amount ghr_pa_requests.award_amount%type;
1673: l_t_award_uom ghr_pa_requests.award_uom%type;
1674: l_t_award_percentage ghr_pa_requests.award_percentage%type;
1675:
1676: l_d_award_amount ghr_pa_requests.award_amount%type;
1677: l_d_award_uom ghr_pa_requests.award_uom%type;
1678: l_d_award_percentage ghr_pa_requests.award_percentage%type;
1679:
1680: l_s_award_amount ghr_pa_requests.award_amount%type;

Line 1677: l_d_award_uom ghr_pa_requests.award_uom%type;

1673: l_t_award_uom ghr_pa_requests.award_uom%type;
1674: l_t_award_percentage ghr_pa_requests.award_percentage%type;
1675:
1676: l_d_award_amount ghr_pa_requests.award_amount%type;
1677: l_d_award_uom ghr_pa_requests.award_uom%type;
1678: l_d_award_percentage ghr_pa_requests.award_percentage%type;
1679:
1680: l_s_award_amount ghr_pa_requests.award_amount%type;
1681: l_s_award_uom ghr_pa_requests.award_uom%type;

Line 1678: l_d_award_percentage ghr_pa_requests.award_percentage%type;

1674: l_t_award_percentage ghr_pa_requests.award_percentage%type;
1675:
1676: l_d_award_amount ghr_pa_requests.award_amount%type;
1677: l_d_award_uom ghr_pa_requests.award_uom%type;
1678: l_d_award_percentage ghr_pa_requests.award_percentage%type;
1679:
1680: l_s_award_amount ghr_pa_requests.award_amount%type;
1681: l_s_award_uom ghr_pa_requests.award_uom%type;
1682: l_s_award_percentage ghr_pa_requests.award_percentage%type;

Line 1680: l_s_award_amount ghr_pa_requests.award_amount%type;

1676: l_d_award_amount ghr_pa_requests.award_amount%type;
1677: l_d_award_uom ghr_pa_requests.award_uom%type;
1678: l_d_award_percentage ghr_pa_requests.award_percentage%type;
1679:
1680: l_s_award_amount ghr_pa_requests.award_amount%type;
1681: l_s_award_uom ghr_pa_requests.award_uom%type;
1682: l_s_award_percentage ghr_pa_requests.award_percentage%type;
1683:
1684: l_u_prh_object_version_number number;

Line 1681: l_s_award_uom ghr_pa_requests.award_uom%type;

1677: l_d_award_uom ghr_pa_requests.award_uom%type;
1678: l_d_award_percentage ghr_pa_requests.award_percentage%type;
1679:
1680: l_s_award_amount ghr_pa_requests.award_amount%type;
1681: l_s_award_uom ghr_pa_requests.award_uom%type;
1682: l_s_award_percentage ghr_pa_requests.award_percentage%type;
1683:
1684: l_u_prh_object_version_number number;
1685: l_i_pa_routing_history_id number;

Line 1682: l_s_award_percentage ghr_pa_requests.award_percentage%type;

1678: l_d_award_percentage ghr_pa_requests.award_percentage%type;
1679:
1680: l_s_award_amount ghr_pa_requests.award_amount%type;
1681: l_s_award_uom ghr_pa_requests.award_uom%type;
1682: l_s_award_percentage ghr_pa_requests.award_percentage%type;
1683:
1684: l_u_prh_object_version_number number;
1685: l_i_pa_routing_history_id number;
1686: l_i_prh_object_version_number number;

Line 1695: l_first_noa_desc ghr_pa_requests.first_noa_desc%type;

1691: l_lac2 first_lac2_record;
1692: l_rpa_action varchar2(40);
1693:
1694: -- Bug#3648118 Added the following variable to handle NOCOPY behaviour
1695: l_first_noa_desc ghr_pa_requests.first_noa_desc%type;
1696:
1697: l_pa_request_num_prefix varchar2(10) := 'MAW';
1698: l_savepoint varchar2(1);
1699:

Line 1788: ghr_pa_requests_pkg.get_noa_pm_family

1784: l_pa_request_rec.to_job_id := p_job_id;
1785:
1786: l_pa_request_rec.first_noa_id := get_noa_id(p_mass_award_id);
1787: l_pa_request_rec.noa_family_code :=
1788: ghr_pa_requests_pkg.get_noa_pm_family
1789: (p_nature_of_action_id => l_pa_request_rec.first_noa_id);
1790:
1791: hr_utility.set_location(l_proc,15);
1792: get_noa_code_desc

Line 1799: ghr_pa_requests_pkg.get_person_details

1795: p_noa_code => l_pa_request_rec.first_noa_code,
1796: p_noa_desc => l_pa_request_rec.first_noa_desc );
1797:
1798: hr_utility.set_location(l_proc,20);
1799: ghr_pa_requests_pkg.get_person_details
1800: (p_person_id => p_person_id
1801: ,p_effective_date => p_effective_date
1802: ,p_national_identifier => l_pa_request_rec.employee_national_identifier
1803: ,p_date_of_birth => l_pa_request_rec.employee_date_of_birth

Line 1812: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

1808:
1809: --Bug # 9329643
1810:
1811: If p_person_id is not null then
1812: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
1813: (p_person_id => p_person_id,
1814: p_effective_date => p_effective_date);
1815: End if;
1816:

Line 1902: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1898: --End Bug# 4748927
1899: hr_utility.set_location(l_proc,35);
1900: l_pa_request_rec.duty_station_location_id := l_duty_station_location_id;
1901:
1902: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1903: (p_location_id => l_duty_station_location_id
1904: ,p_duty_station_id => l_pa_request_rec.duty_station_id);
1905:
1906: ghr_pa_requests_pkg.get_duty_station_details

Line 1906: ghr_pa_requests_pkg.get_duty_station_details

1902: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1903: (p_location_id => l_duty_station_location_id
1904: ,p_duty_station_id => l_pa_request_rec.duty_station_id);
1905:
1906: ghr_pa_requests_pkg.get_duty_station_details
1907: (p_duty_station_id => l_pa_request_rec.duty_station_id
1908: ,p_effective_date => l_pa_request_rec.effective_date
1909: ,p_duty_station_code => l_pa_request_rec.duty_station_code
1910: ,p_duty_station_desc => l_pa_request_rec.duty_station_desc);

Line 1932: ghr_pa_requests_pkg.get_sf52_pos_ddf_details

1928: l_pa_request_rec.to_position_org_line5 := l_pa_request_rec.from_position_org_line5;
1929: l_pa_request_rec.to_position_org_line6 := l_pa_request_rec.from_position_org_line6;
1930:
1931: hr_utility.set_location(l_proc,40);
1932: ghr_pa_requests_pkg.get_sf52_pos_ddf_details
1933: (p_position_id => p_position_id
1934: ,p_date_Effective => l_pa_request_rec.effective_date
1935: ,p_flsa_category => l_pa_request_rec.flsa_category
1936: ,p_bargaining_unit_status => l_pa_request_rec.bargaining_unit_status

Line 1968: l_pa_request_rec.employee_dept_or_agency := ghr_pa_requests_pkg.get_lookup_meaning

1964: ,p_effective_date => p_effective_date
1965: );
1966: hr_utility.set_location('Agency Code ' || l_pa_request_rec.agency_code ,52);
1967:
1968: l_pa_request_rec.employee_dept_or_agency := ghr_pa_requests_pkg.get_lookup_meaning
1969: (800
1970: ,'GHR_US_AGENCY_CODE'
1971: ,l_pa_request_rec.agency_code
1972: );

Line 2218: ghr_pa_requests_pkg.get_SF52_person_ddf_details

2214:
2215: l_pa_request_rec.first_noa_desc := l_first_noa_desc;
2216: -- Bug#3648118 Changes completed.
2217: hr_utility.set_location(l_proc,55);
2218: ghr_pa_requests_pkg.get_SF52_person_ddf_details
2219: (p_person_id => l_pa_request_rec.person_id,
2220: p_date_effective => l_pa_request_rec.effective_date,
2221: p_citizenship => l_pa_request_rec.citizenship,
2222: p_veterans_preference => l_pa_request_rec.veterans_preference,

Line 2243: ghr_pa_requests_pkg.get_SF52_asg_ddf_details

2239: p_year_degree_attained => l_pa_request_rec.year_degree_attained
2240: );
2241:
2242: hr_utility.set_location(l_proc,80);
2243: ghr_pa_requests_pkg.get_SF52_asg_ddf_details
2244: (p_assignment_id => l_pa_request_rec.employee_assignment_id
2245: ,p_date_effective => l_pa_request_rec.effective_date
2246: ,p_tenure => l_pa_request_rec.tenure
2247: ,p_annuitant_indicator => l_pa_request_rec.annuitant_indicator

Line 2254: l_pa_request_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning

2250: ,p_part_time_hours => l_pa_request_rec.part_time_hours
2251: );
2252:
2253: -- Annuitant_indicator
2254: l_pa_request_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning
2255: (800
2256: ,'GHR_US_ANNUITANT_INDICATOR'
2257: ,l_pa_request_rec.annuitant_indicator
2258: );

Line 2261: l_pa_request_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning

2257: ,l_pa_request_rec.annuitant_indicator
2258: );
2259:
2260: --WORK_SCHEDULE
2261: l_pa_request_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning
2262: (800
2263: ,'GHR_US_WORK_SCHEDULE'
2264: ,l_pa_request_rec.work_schedule
2265: );

Line 2279: l_pa_request_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning

2275: ,p_value => l_pa_request_rec.fegli
2276: ,p_multiple_error_flag => l_multiple_error_flag
2277: );
2278:
2279: l_pa_request_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
2280: (800
2281: ,'GHR_US_FEGLI'
2282: ,l_pa_request_rec.fegli
2283: );

Line 2297: l_pa_request_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning

2293: ,p_value => l_pa_request_rec.retirement_plan
2294: ,p_multiple_error_flag => l_multiple_error_flag
2295: );
2296:
2297: l_pa_request_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning
2298: (800
2299: ,'GHR_US_RETIREMENT_PLAN'
2300: ,l_pa_request_rec.retirement_plan
2301: );

Line 2728: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

2724:
2725: PROCEDURE refresh_award_details
2726: (
2727: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
2728: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
2729: p_effective_date in date,
2730: p_person_id in per_people_f.person_id%TYPE,
2731: p_pa_request_id in ghr_pa_requests.pa_request_id%type
2732: )

Line 2731: p_pa_request_id in ghr_pa_requests.pa_request_id%type

2727: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
2728: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
2729: p_effective_date in date,
2730: p_person_id in per_people_f.person_id%TYPE,
2731: p_pa_request_id in ghr_pa_requests.pa_request_id%type
2732: )
2733:
2734: IS
2735:

Line 2745: l_t_award_amount ghr_pa_requests.award_amount%type;

2741: l_dummy varchar2(30);
2742: --l_information_type varchar2(40) := 'GHR_US_PAR_AWARDS_BONUS';
2743:
2744:
2745: l_t_award_amount ghr_pa_requests.award_amount%type;
2746: l_t_award_uom ghr_pa_requests.award_uom%type;
2747: l_t_award_percentage ghr_pa_requests.award_percentage%type;
2748: l_t_award_agency varchar2(150);
2749: l_t_award_type varchar2(150);

Line 2746: l_t_award_uom ghr_pa_requests.award_uom%type;

2742: --l_information_type varchar2(40) := 'GHR_US_PAR_AWARDS_BONUS';
2743:
2744:
2745: l_t_award_amount ghr_pa_requests.award_amount%type;
2746: l_t_award_uom ghr_pa_requests.award_uom%type;
2747: l_t_award_percentage ghr_pa_requests.award_percentage%type;
2748: l_t_award_agency varchar2(150);
2749: l_t_award_type varchar2(150);
2750: l_t_group_award varchar2(150);

Line 2747: l_t_award_percentage ghr_pa_requests.award_percentage%type;

2743:
2744:
2745: l_t_award_amount ghr_pa_requests.award_amount%type;
2746: l_t_award_uom ghr_pa_requests.award_uom%type;
2747: l_t_award_percentage ghr_pa_requests.award_percentage%type;
2748: l_t_award_agency varchar2(150);
2749: l_t_award_type varchar2(150);
2750: l_t_group_award varchar2(150);
2751: l_t_tbd varchar2(150);

Line 2755: l_d_award_amount ghr_pa_requests.award_amount%type;

2751: l_t_tbd varchar2(150);
2752: l_t_date_award_earn varchar2(150);
2753: l_t_appropriation_code varchar2(150);
2754:
2755: l_d_award_amount ghr_pa_requests.award_amount%type;
2756: l_d_award_uom ghr_pa_requests.award_uom%type;
2757: l_d_award_percentage ghr_pa_requests.award_percentage%type;
2758: l_d_award_agency varchar2(150);
2759: l_d_award_type varchar2(150);

Line 2756: l_d_award_uom ghr_pa_requests.award_uom%type;

2752: l_t_date_award_earn varchar2(150);
2753: l_t_appropriation_code varchar2(150);
2754:
2755: l_d_award_amount ghr_pa_requests.award_amount%type;
2756: l_d_award_uom ghr_pa_requests.award_uom%type;
2757: l_d_award_percentage ghr_pa_requests.award_percentage%type;
2758: l_d_award_agency varchar2(150);
2759: l_d_award_type varchar2(150);
2760: l_d_group_award varchar2(150);

Line 2757: l_d_award_percentage ghr_pa_requests.award_percentage%type;

2753: l_t_appropriation_code varchar2(150);
2754:
2755: l_d_award_amount ghr_pa_requests.award_amount%type;
2756: l_d_award_uom ghr_pa_requests.award_uom%type;
2757: l_d_award_percentage ghr_pa_requests.award_percentage%type;
2758: l_d_award_agency varchar2(150);
2759: l_d_award_type varchar2(150);
2760: l_d_group_award varchar2(150);
2761: l_d_tbd varchar2(150);

Line 2765: l_s_award_amount ghr_pa_requests.award_amount%type;

2761: l_d_tbd varchar2(150);
2762: l_d_date_award_earn varchar2(150);
2763: l_d_appropriation_code varchar2(150);
2764:
2765: l_s_award_amount ghr_pa_requests.award_amount%type;
2766: l_s_award_uom ghr_pa_requests.award_uom%type;
2767: l_s_award_percentage ghr_pa_requests.award_percentage%type;
2768: l_s_award_agency varchar2(150);
2769: l_s_award_type varchar2(150);

Line 2766: l_s_award_uom ghr_pa_requests.award_uom%type;

2762: l_d_date_award_earn varchar2(150);
2763: l_d_appropriation_code varchar2(150);
2764:
2765: l_s_award_amount ghr_pa_requests.award_amount%type;
2766: l_s_award_uom ghr_pa_requests.award_uom%type;
2767: l_s_award_percentage ghr_pa_requests.award_percentage%type;
2768: l_s_award_agency varchar2(150);
2769: l_s_award_type varchar2(150);
2770: l_s_group_award varchar2(150);

Line 2767: l_s_award_percentage ghr_pa_requests.award_percentage%type;

2763: l_d_appropriation_code varchar2(150);
2764:
2765: l_s_award_amount ghr_pa_requests.award_amount%type;
2766: l_s_award_uom ghr_pa_requests.award_uom%type;
2767: l_s_award_percentage ghr_pa_requests.award_percentage%type;
2768: l_s_award_agency varchar2(150);
2769: l_s_award_type varchar2(150);
2770: l_s_group_award varchar2(150);
2771: l_s_tbd varchar2(150);

Line 2994: Procedure create_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype) is

2990: RAISE;
2991:
2992: End set_ei;
2993:
2994: Procedure create_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype) is
2995: Begin
2996: insert into ghr_pa_request_shadow(
2997: pa_request_id
2998: ,academic_discipline

Line 3102: Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,

3098: ,p_rpa_data.award_uom
3099: ,p_rpa_data.award_percentage );
3100: end create_shadow_row;
3101:
3102: Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,
3103: p_result out nocopy Boolean ) is
3104: Begin
3105: update ghr_pa_request_shadow
3106: set

Line 3177: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

3173: end update_shadow_row;
3174:
3175: Procedure create_remarks
3176: (p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
3177: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
3178: p_effective_date in date,
3179: p_pa_request_id in ghr_pa_requests.pa_request_id%type
3180: )
3181:

Line 3179: p_pa_request_id in ghr_pa_requests.pa_request_id%type

3175: Procedure create_remarks
3176: (p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
3177: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
3178: p_effective_date in date,
3179: p_pa_request_id in ghr_pa_requests.pa_request_id%type
3180: )
3181:
3182: is
3183:

Line 3207: (select pa_request_id from ghr_pa_requests

3203: remark_code_information4,
3204: remark_code_information5
3205: from ghr_pa_remarks
3206: where pa_request_id =
3207: (select pa_request_id from ghr_pa_requests
3208: where mass_action_id = p_mass_award_id
3209: and rpa_type = p_rpa_type
3210: and person_id is null)
3211: order by pa_remark_id;

Line 3276: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,

3272:
3273: end create_remarks;
3274:
3275: Procedure mass_awards_error_handling
3276: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,
3277: p_object_version_number in ghr_pa_requests.object_version_number%type,
3278: p_error in varchar2 default null,
3279: p_result out nocopy boolean
3280: )

Line 3277: p_object_version_number in ghr_pa_requests.object_version_number%type,

3273: end create_remarks;
3274:
3275: Procedure mass_awards_error_handling
3276: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,
3277: p_object_version_number in ghr_pa_requests.object_version_number%type,
3278: p_error in varchar2 default null,
3279: p_result out nocopy boolean
3280: )
3281:

Line 3287: l_pa_request_id ghr_pa_requests.pa_request_id%type;

3283:
3284: ---
3285: --- Local variables
3286: ---
3287: l_pa_request_id ghr_pa_requests.pa_request_id%type;
3288: l_object_version_number ghr_pa_requests.object_version_number%type;
3289: l_person_id ghr_pa_requests.person_id%type;
3290: l_employee_first_name ghr_pa_requests.employee_first_name%type;
3291: l_employee_last_name ghr_pa_requests.employee_last_name%type;

Line 3288: l_object_version_number ghr_pa_requests.object_version_number%type;

3284: ---
3285: --- Local variables
3286: ---
3287: l_pa_request_id ghr_pa_requests.pa_request_id%type;
3288: l_object_version_number ghr_pa_requests.object_version_number%type;
3289: l_person_id ghr_pa_requests.person_id%type;
3290: l_employee_first_name ghr_pa_requests.employee_first_name%type;
3291: l_employee_last_name ghr_pa_requests.employee_last_name%type;
3292: l_employee_middle_names ghr_pa_requests.employee_middle_names%type;

Line 3289: l_person_id ghr_pa_requests.person_id%type;

3285: --- Local variables
3286: ---
3287: l_pa_request_id ghr_pa_requests.pa_request_id%type;
3288: l_object_version_number ghr_pa_requests.object_version_number%type;
3289: l_person_id ghr_pa_requests.person_id%type;
3290: l_employee_first_name ghr_pa_requests.employee_first_name%type;
3291: l_employee_last_name ghr_pa_requests.employee_last_name%type;
3292: l_employee_middle_names ghr_pa_requests.employee_middle_names%type;
3293: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%type;

Line 3290: l_employee_first_name ghr_pa_requests.employee_first_name%type;

3286: ---
3287: l_pa_request_id ghr_pa_requests.pa_request_id%type;
3288: l_object_version_number ghr_pa_requests.object_version_number%type;
3289: l_person_id ghr_pa_requests.person_id%type;
3290: l_employee_first_name ghr_pa_requests.employee_first_name%type;
3291: l_employee_last_name ghr_pa_requests.employee_last_name%type;
3292: l_employee_middle_names ghr_pa_requests.employee_middle_names%type;
3293: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%type;
3294: l_error varchar2(2000);

Line 3291: l_employee_last_name ghr_pa_requests.employee_last_name%type;

3287: l_pa_request_id ghr_pa_requests.pa_request_id%type;
3288: l_object_version_number ghr_pa_requests.object_version_number%type;
3289: l_person_id ghr_pa_requests.person_id%type;
3290: l_employee_first_name ghr_pa_requests.employee_first_name%type;
3291: l_employee_last_name ghr_pa_requests.employee_last_name%type;
3292: l_employee_middle_names ghr_pa_requests.employee_middle_names%type;
3293: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%type;
3294: l_error varchar2(2000);
3295: l_log_text varchar2(2000);

Line 3292: l_employee_middle_names ghr_pa_requests.employee_middle_names%type;

3288: l_object_version_number ghr_pa_requests.object_version_number%type;
3289: l_person_id ghr_pa_requests.person_id%type;
3290: l_employee_first_name ghr_pa_requests.employee_first_name%type;
3291: l_employee_last_name ghr_pa_requests.employee_last_name%type;
3292: l_employee_middle_names ghr_pa_requests.employee_middle_names%type;
3293: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%type;
3294: l_error varchar2(2000);
3295: l_log_text varchar2(2000);
3296: l_proc varchar2(72) := 'mass_awards_error_handling';

Line 3293: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%type;

3289: l_person_id ghr_pa_requests.person_id%type;
3290: l_employee_first_name ghr_pa_requests.employee_first_name%type;
3291: l_employee_last_name ghr_pa_requests.employee_last_name%type;
3292: l_employee_middle_names ghr_pa_requests.employee_middle_names%type;
3293: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%type;
3294: l_error varchar2(2000);
3295: l_log_text varchar2(2000);
3296: l_proc varchar2(72) := 'mass_awards_error_handling';
3297:

Line 3306: FROM ghr_pa_requests

3302: employee_first_name,
3303: employee_middle_names,
3304: employee_national_identifier,
3305: effective_date
3306: FROM ghr_pa_requests
3307: WHERE pa_request_id = l_pa_request_id;
3308:
3309: --Bug # 9329643
3310: l_employee_number varchar2(30);

Line 3345: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

3341:
3342:
3343: --Bug # 9329643
3344: If l_person_id is not null then
3345: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
3346: (p_person_id => l_person_id,
3347: p_effective_date => l_effective_date);
3348: End if;
3349:

Line 3393: PROCEDURE check_award_amount (p_noa_code ghr_pa_requests.first_noa_code%TYPE,

3389: the fnd_message.get to get the message that we have assigned.
3390: This is to remove the hard coding and using only the messages.
3391: */
3392:
3393: PROCEDURE check_award_amount (p_noa_code ghr_pa_requests.first_noa_code%TYPE,
3394: p_effective_date ghr_pa_requests.effective_date%TYPE,
3395: p_award_amount NUMBER,
3396: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
3397: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,

Line 3394: p_effective_date ghr_pa_requests.effective_date%TYPE,

3390: This is to remove the hard coding and using only the messages.
3391: */
3392:
3393: PROCEDURE check_award_amount (p_noa_code ghr_pa_requests.first_noa_code%TYPE,
3394: p_effective_date ghr_pa_requests.effective_date%TYPE,
3395: p_award_amount NUMBER,
3396: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
3397: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,
3398: p_to_position_id ghr_pa_requests.to_position_id%TYPE,

Line 3396: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,

3392:
3393: PROCEDURE check_award_amount (p_noa_code ghr_pa_requests.first_noa_code%TYPE,
3394: p_effective_date ghr_pa_requests.effective_date%TYPE,
3395: p_award_amount NUMBER,
3396: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
3397: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,
3398: p_to_position_id ghr_pa_requests.to_position_id%TYPE,
3399: p_comments OUT NOCOPY varchar2,
3400: p_error_flg OUT NOCOPY BOOLEAN) IS

Line 3397: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,

3393: PROCEDURE check_award_amount (p_noa_code ghr_pa_requests.first_noa_code%TYPE,
3394: p_effective_date ghr_pa_requests.effective_date%TYPE,
3395: p_award_amount NUMBER,
3396: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
3397: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,
3398: p_to_position_id ghr_pa_requests.to_position_id%TYPE,
3399: p_comments OUT NOCOPY varchar2,
3400: p_error_flg OUT NOCOPY BOOLEAN) IS
3401: l_temp NUMBER;

Line 3398: p_to_position_id ghr_pa_requests.to_position_id%TYPE,

3394: p_effective_date ghr_pa_requests.effective_date%TYPE,
3395: p_award_amount NUMBER,
3396: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
3397: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,
3398: p_to_position_id ghr_pa_requests.to_position_id%TYPE,
3399: p_comments OUT NOCOPY varchar2,
3400: p_error_flg OUT NOCOPY BOOLEAN) IS
3401: l_temp NUMBER;
3402: l_max_allowed_amount NUMBER;

Line 3409: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_to_position_id,p_effective_date);

3405: l_psi VARCHAR2(10);
3406: BEGIN
3407: --bug 5482191
3408:
3409: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_to_position_id,p_effective_date);
3410:
3411:
3412: p_error_flg := FALSE;
3413: --Check for Maximum Amount.