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 1786: ghr_pa_requests_pkg.get_noa_pm_family

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

Line 1797: ghr_pa_requests_pkg.get_person_details

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

Line 1892: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1888: --End Bug# 4748927
1889: hr_utility.set_location(l_proc,35);
1890: l_pa_request_rec.duty_station_location_id := l_duty_station_location_id;
1891:
1892: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1893: (p_location_id => l_duty_station_location_id
1894: ,p_duty_station_id => l_pa_request_rec.duty_station_id);
1895:
1896: ghr_pa_requests_pkg.get_duty_station_details

Line 1896: ghr_pa_requests_pkg.get_duty_station_details

1892: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1893: (p_location_id => l_duty_station_location_id
1894: ,p_duty_station_id => l_pa_request_rec.duty_station_id);
1895:
1896: ghr_pa_requests_pkg.get_duty_station_details
1897: (p_duty_station_id => l_pa_request_rec.duty_station_id
1898: ,p_effective_date => l_pa_request_rec.effective_date
1899: ,p_duty_station_code => l_pa_request_rec.duty_station_code
1900: ,p_duty_station_desc => l_pa_request_rec.duty_station_desc);

Line 1922: ghr_pa_requests_pkg.get_sf52_pos_ddf_details

1918: l_pa_request_rec.to_position_org_line5 := l_pa_request_rec.from_position_org_line5;
1919: l_pa_request_rec.to_position_org_line6 := l_pa_request_rec.from_position_org_line6;
1920:
1921: hr_utility.set_location(l_proc,40);
1922: ghr_pa_requests_pkg.get_sf52_pos_ddf_details
1923: (p_position_id => p_position_id
1924: ,p_date_Effective => l_pa_request_rec.effective_date
1925: ,p_flsa_category => l_pa_request_rec.flsa_category
1926: ,p_bargaining_unit_status => l_pa_request_rec.bargaining_unit_status

Line 1958: l_pa_request_rec.employee_dept_or_agency := ghr_pa_requests_pkg.get_lookup_meaning

1954: ,p_effective_date => p_effective_date
1955: );
1956: hr_utility.set_location('Agency Code ' || l_pa_request_rec.agency_code ,52);
1957:
1958: l_pa_request_rec.employee_dept_or_agency := ghr_pa_requests_pkg.get_lookup_meaning
1959: (800
1960: ,'GHR_US_AGENCY_CODE'
1961: ,l_pa_request_rec.agency_code
1962: );

Line 2208: ghr_pa_requests_pkg.get_SF52_person_ddf_details

2204:
2205: l_pa_request_rec.first_noa_desc := l_first_noa_desc;
2206: -- Bug#3648118 Changes completed.
2207: hr_utility.set_location(l_proc,55);
2208: ghr_pa_requests_pkg.get_SF52_person_ddf_details
2209: (p_person_id => l_pa_request_rec.person_id,
2210: p_date_effective => l_pa_request_rec.effective_date,
2211: p_citizenship => l_pa_request_rec.citizenship,
2212: p_veterans_preference => l_pa_request_rec.veterans_preference,

Line 2233: ghr_pa_requests_pkg.get_SF52_asg_ddf_details

2229: p_year_degree_attained => l_pa_request_rec.year_degree_attained
2230: );
2231:
2232: hr_utility.set_location(l_proc,80);
2233: ghr_pa_requests_pkg.get_SF52_asg_ddf_details
2234: (p_assignment_id => l_pa_request_rec.employee_assignment_id
2235: ,p_date_effective => l_pa_request_rec.effective_date
2236: ,p_tenure => l_pa_request_rec.tenure
2237: ,p_annuitant_indicator => l_pa_request_rec.annuitant_indicator

Line 2244: l_pa_request_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning

2240: ,p_part_time_hours => l_pa_request_rec.part_time_hours
2241: );
2242:
2243: -- Annuitant_indicator
2244: l_pa_request_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning
2245: (800
2246: ,'GHR_US_ANNUITANT_INDICATOR'
2247: ,l_pa_request_rec.annuitant_indicator
2248: );

Line 2251: l_pa_request_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning

2247: ,l_pa_request_rec.annuitant_indicator
2248: );
2249:
2250: --WORK_SCHEDULE
2251: l_pa_request_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning
2252: (800
2253: ,'GHR_US_WORK_SCHEDULE'
2254: ,l_pa_request_rec.work_schedule
2255: );

Line 2269: l_pa_request_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning

2265: ,p_value => l_pa_request_rec.fegli
2266: ,p_multiple_error_flag => l_multiple_error_flag
2267: );
2268:
2269: l_pa_request_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
2270: (800
2271: ,'GHR_US_FEGLI'
2272: ,l_pa_request_rec.fegli
2273: );

Line 2287: l_pa_request_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning

2283: ,p_value => l_pa_request_rec.retirement_plan
2284: ,p_multiple_error_flag => l_multiple_error_flag
2285: );
2286:
2287: l_pa_request_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning
2288: (800
2289: ,'GHR_US_RETIREMENT_PLAN'
2290: ,l_pa_request_rec.retirement_plan
2291: );

Line 2711: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

2707:
2708: PROCEDURE refresh_award_details
2709: (
2710: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
2711: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
2712: p_effective_date in date,
2713: p_person_id in per_people_f.person_id%TYPE,
2714: p_pa_request_id in ghr_pa_requests.pa_request_id%type
2715: )

Line 2714: p_pa_request_id in ghr_pa_requests.pa_request_id%type

2710: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
2711: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
2712: p_effective_date in date,
2713: p_person_id in per_people_f.person_id%TYPE,
2714: p_pa_request_id in ghr_pa_requests.pa_request_id%type
2715: )
2716:
2717: IS
2718:

Line 2728: l_t_award_amount ghr_pa_requests.award_amount%type;

2724: l_dummy varchar2(30);
2725: --l_information_type varchar2(40) := 'GHR_US_PAR_AWARDS_BONUS';
2726:
2727:
2728: l_t_award_amount ghr_pa_requests.award_amount%type;
2729: l_t_award_uom ghr_pa_requests.award_uom%type;
2730: l_t_award_percentage ghr_pa_requests.award_percentage%type;
2731: l_t_award_agency varchar2(150);
2732: l_t_award_type varchar2(150);

Line 2729: l_t_award_uom ghr_pa_requests.award_uom%type;

2725: --l_information_type varchar2(40) := 'GHR_US_PAR_AWARDS_BONUS';
2726:
2727:
2728: l_t_award_amount ghr_pa_requests.award_amount%type;
2729: l_t_award_uom ghr_pa_requests.award_uom%type;
2730: l_t_award_percentage ghr_pa_requests.award_percentage%type;
2731: l_t_award_agency varchar2(150);
2732: l_t_award_type varchar2(150);
2733: l_t_group_award varchar2(150);

Line 2730: l_t_award_percentage ghr_pa_requests.award_percentage%type;

2726:
2727:
2728: l_t_award_amount ghr_pa_requests.award_amount%type;
2729: l_t_award_uom ghr_pa_requests.award_uom%type;
2730: l_t_award_percentage ghr_pa_requests.award_percentage%type;
2731: l_t_award_agency varchar2(150);
2732: l_t_award_type varchar2(150);
2733: l_t_group_award varchar2(150);
2734: l_t_tbd varchar2(150);

Line 2738: l_d_award_amount ghr_pa_requests.award_amount%type;

2734: l_t_tbd varchar2(150);
2735: l_t_date_award_earn varchar2(150);
2736: l_t_appropriation_code varchar2(150);
2737:
2738: l_d_award_amount ghr_pa_requests.award_amount%type;
2739: l_d_award_uom ghr_pa_requests.award_uom%type;
2740: l_d_award_percentage ghr_pa_requests.award_percentage%type;
2741: l_d_award_agency varchar2(150);
2742: l_d_award_type varchar2(150);

Line 2739: l_d_award_uom ghr_pa_requests.award_uom%type;

2735: l_t_date_award_earn varchar2(150);
2736: l_t_appropriation_code varchar2(150);
2737:
2738: l_d_award_amount ghr_pa_requests.award_amount%type;
2739: l_d_award_uom ghr_pa_requests.award_uom%type;
2740: l_d_award_percentage ghr_pa_requests.award_percentage%type;
2741: l_d_award_agency varchar2(150);
2742: l_d_award_type varchar2(150);
2743: l_d_group_award varchar2(150);

Line 2740: l_d_award_percentage ghr_pa_requests.award_percentage%type;

2736: l_t_appropriation_code varchar2(150);
2737:
2738: l_d_award_amount ghr_pa_requests.award_amount%type;
2739: l_d_award_uom ghr_pa_requests.award_uom%type;
2740: l_d_award_percentage ghr_pa_requests.award_percentage%type;
2741: l_d_award_agency varchar2(150);
2742: l_d_award_type varchar2(150);
2743: l_d_group_award varchar2(150);
2744: l_d_tbd varchar2(150);

Line 2748: l_s_award_amount ghr_pa_requests.award_amount%type;

2744: l_d_tbd varchar2(150);
2745: l_d_date_award_earn varchar2(150);
2746: l_d_appropriation_code varchar2(150);
2747:
2748: l_s_award_amount ghr_pa_requests.award_amount%type;
2749: l_s_award_uom ghr_pa_requests.award_uom%type;
2750: l_s_award_percentage ghr_pa_requests.award_percentage%type;
2751: l_s_award_agency varchar2(150);
2752: l_s_award_type varchar2(150);

Line 2749: l_s_award_uom ghr_pa_requests.award_uom%type;

2745: l_d_date_award_earn varchar2(150);
2746: l_d_appropriation_code varchar2(150);
2747:
2748: l_s_award_amount ghr_pa_requests.award_amount%type;
2749: l_s_award_uom ghr_pa_requests.award_uom%type;
2750: l_s_award_percentage ghr_pa_requests.award_percentage%type;
2751: l_s_award_agency varchar2(150);
2752: l_s_award_type varchar2(150);
2753: l_s_group_award varchar2(150);

Line 2750: l_s_award_percentage ghr_pa_requests.award_percentage%type;

2746: l_d_appropriation_code varchar2(150);
2747:
2748: l_s_award_amount ghr_pa_requests.award_amount%type;
2749: l_s_award_uom ghr_pa_requests.award_uom%type;
2750: l_s_award_percentage ghr_pa_requests.award_percentage%type;
2751: l_s_award_agency varchar2(150);
2752: l_s_award_type varchar2(150);
2753: l_s_group_award varchar2(150);
2754: l_s_tbd varchar2(150);

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

2973: RAISE;
2974:
2975: End set_ei;
2976:
2977: Procedure create_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype) is
2978: Begin
2979: insert into ghr_pa_request_shadow(
2980: pa_request_id
2981: ,academic_discipline

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

3081: ,p_rpa_data.award_uom
3082: ,p_rpa_data.award_percentage );
3083: end create_shadow_row;
3084:
3085: Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,
3086: p_result out nocopy Boolean ) is
3087: Begin
3088: update ghr_pa_request_shadow
3089: set

Line 3160: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

3156: end update_shadow_row;
3157:
3158: Procedure create_remarks
3159: (p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
3160: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
3161: p_effective_date in date,
3162: p_pa_request_id in ghr_pa_requests.pa_request_id%type
3163: )
3164:

Line 3162: p_pa_request_id in ghr_pa_requests.pa_request_id%type

3158: Procedure create_remarks
3159: (p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
3160: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
3161: p_effective_date in date,
3162: p_pa_request_id in ghr_pa_requests.pa_request_id%type
3163: )
3164:
3165: is
3166:

Line 3190: (select pa_request_id from ghr_pa_requests

3186: remark_code_information4,
3187: remark_code_information5
3188: from ghr_pa_remarks
3189: where pa_request_id =
3190: (select pa_request_id from ghr_pa_requests
3191: where mass_action_id = p_mass_award_id
3192: and rpa_type = p_rpa_type
3193: and person_id is null)
3194: order by pa_remark_id;

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

3255:
3256: end create_remarks;
3257:
3258: Procedure mass_awards_error_handling
3259: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,
3260: p_object_version_number in ghr_pa_requests.object_version_number%type,
3261: p_error in varchar2 default null,
3262: p_result out nocopy boolean
3263: )

Line 3260: p_object_version_number in ghr_pa_requests.object_version_number%type,

3256: end create_remarks;
3257:
3258: Procedure mass_awards_error_handling
3259: ( p_pa_request_id in ghr_pa_requests.pa_request_id%type,
3260: p_object_version_number in ghr_pa_requests.object_version_number%type,
3261: p_error in varchar2 default null,
3262: p_result out nocopy boolean
3263: )
3264:

Line 3270: l_pa_request_id ghr_pa_requests.pa_request_id%type;

3266:
3267: ---
3268: --- Local variables
3269: ---
3270: l_pa_request_id ghr_pa_requests.pa_request_id%type;
3271: l_object_version_number ghr_pa_requests.object_version_number%type;
3272: l_person_id ghr_pa_requests.person_id%type;
3273: l_employee_first_name ghr_pa_requests.employee_first_name%type;
3274: l_employee_last_name ghr_pa_requests.employee_last_name%type;

Line 3271: l_object_version_number ghr_pa_requests.object_version_number%type;

3267: ---
3268: --- Local variables
3269: ---
3270: l_pa_request_id ghr_pa_requests.pa_request_id%type;
3271: l_object_version_number ghr_pa_requests.object_version_number%type;
3272: l_person_id ghr_pa_requests.person_id%type;
3273: l_employee_first_name ghr_pa_requests.employee_first_name%type;
3274: l_employee_last_name ghr_pa_requests.employee_last_name%type;
3275: l_employee_middle_names ghr_pa_requests.employee_middle_names%type;

Line 3272: l_person_id ghr_pa_requests.person_id%type;

3268: --- Local variables
3269: ---
3270: l_pa_request_id ghr_pa_requests.pa_request_id%type;
3271: l_object_version_number ghr_pa_requests.object_version_number%type;
3272: l_person_id ghr_pa_requests.person_id%type;
3273: l_employee_first_name ghr_pa_requests.employee_first_name%type;
3274: l_employee_last_name ghr_pa_requests.employee_last_name%type;
3275: l_employee_middle_names ghr_pa_requests.employee_middle_names%type;
3276: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%type;

Line 3273: l_employee_first_name ghr_pa_requests.employee_first_name%type;

3269: ---
3270: l_pa_request_id ghr_pa_requests.pa_request_id%type;
3271: l_object_version_number ghr_pa_requests.object_version_number%type;
3272: l_person_id ghr_pa_requests.person_id%type;
3273: l_employee_first_name ghr_pa_requests.employee_first_name%type;
3274: l_employee_last_name ghr_pa_requests.employee_last_name%type;
3275: l_employee_middle_names ghr_pa_requests.employee_middle_names%type;
3276: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%type;
3277: l_error varchar2(2000);

Line 3274: l_employee_last_name ghr_pa_requests.employee_last_name%type;

3270: l_pa_request_id ghr_pa_requests.pa_request_id%type;
3271: l_object_version_number ghr_pa_requests.object_version_number%type;
3272: l_person_id ghr_pa_requests.person_id%type;
3273: l_employee_first_name ghr_pa_requests.employee_first_name%type;
3274: l_employee_last_name ghr_pa_requests.employee_last_name%type;
3275: l_employee_middle_names ghr_pa_requests.employee_middle_names%type;
3276: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%type;
3277: l_error varchar2(2000);
3278: l_log_text varchar2(2000);

Line 3275: l_employee_middle_names ghr_pa_requests.employee_middle_names%type;

3271: l_object_version_number ghr_pa_requests.object_version_number%type;
3272: l_person_id ghr_pa_requests.person_id%type;
3273: l_employee_first_name ghr_pa_requests.employee_first_name%type;
3274: l_employee_last_name ghr_pa_requests.employee_last_name%type;
3275: l_employee_middle_names ghr_pa_requests.employee_middle_names%type;
3276: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%type;
3277: l_error varchar2(2000);
3278: l_log_text varchar2(2000);
3279: l_proc varchar2(72) := 'mass_awards_error_handling';

Line 3276: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%type;

3272: l_person_id ghr_pa_requests.person_id%type;
3273: l_employee_first_name ghr_pa_requests.employee_first_name%type;
3274: l_employee_last_name ghr_pa_requests.employee_last_name%type;
3275: l_employee_middle_names ghr_pa_requests.employee_middle_names%type;
3276: l_employee_national_identifier ghr_pa_requests.employee_national_identifier%type;
3277: l_error varchar2(2000);
3278: l_log_text varchar2(2000);
3279: l_proc varchar2(72) := 'mass_awards_error_handling';
3280:

Line 3288: FROM ghr_pa_requests

3284: employee_last_name,
3285: employee_first_name,
3286: employee_middle_names,
3287: employee_national_identifier
3288: FROM ghr_pa_requests
3289: WHERE pa_request_id = l_pa_request_id;
3290:
3291:
3292: begin

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

3357: the fnd_message.get to get the message that we have assigned.
3358: This is to remove the hard coding and using only the messages.
3359: */
3360:
3361: PROCEDURE check_award_amount (p_noa_code ghr_pa_requests.first_noa_code%TYPE,
3362: p_effective_date ghr_pa_requests.effective_date%TYPE,
3363: p_award_amount NUMBER,
3364: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
3365: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,

Line 3362: p_effective_date ghr_pa_requests.effective_date%TYPE,

3358: This is to remove the hard coding and using only the messages.
3359: */
3360:
3361: PROCEDURE check_award_amount (p_noa_code ghr_pa_requests.first_noa_code%TYPE,
3362: p_effective_date ghr_pa_requests.effective_date%TYPE,
3363: p_award_amount NUMBER,
3364: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
3365: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,
3366: p_to_position_id ghr_pa_requests.to_position_id%TYPE,

Line 3364: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,

3360:
3361: PROCEDURE check_award_amount (p_noa_code ghr_pa_requests.first_noa_code%TYPE,
3362: p_effective_date ghr_pa_requests.effective_date%TYPE,
3363: p_award_amount NUMBER,
3364: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
3365: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,
3366: p_to_position_id ghr_pa_requests.to_position_id%TYPE,
3367: p_comments OUT NOCOPY varchar2,
3368: p_error_flg OUT NOCOPY BOOLEAN) IS

Line 3365: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,

3361: PROCEDURE check_award_amount (p_noa_code ghr_pa_requests.first_noa_code%TYPE,
3362: p_effective_date ghr_pa_requests.effective_date%TYPE,
3363: p_award_amount NUMBER,
3364: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
3365: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,
3366: p_to_position_id ghr_pa_requests.to_position_id%TYPE,
3367: p_comments OUT NOCOPY varchar2,
3368: p_error_flg OUT NOCOPY BOOLEAN) IS
3369: l_temp NUMBER;

Line 3366: p_to_position_id ghr_pa_requests.to_position_id%TYPE,

3362: p_effective_date ghr_pa_requests.effective_date%TYPE,
3363: p_award_amount NUMBER,
3364: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
3365: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,
3366: p_to_position_id ghr_pa_requests.to_position_id%TYPE,
3367: p_comments OUT NOCOPY varchar2,
3368: p_error_flg OUT NOCOPY BOOLEAN) IS
3369: l_temp NUMBER;
3370: l_max_allowed_amount NUMBER;

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

3373: l_psi VARCHAR2(10);
3374: BEGIN
3375: --bug 5482191
3376:
3377: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_to_position_id,p_effective_date);
3378:
3379:
3380: p_error_flg := FALSE;
3381: --Check for Maximum Amount.