[Home] [Help]
177: l_full_name := l_pa_request_rec.employee_last_name||','|| l_pa_request_rec.employee_first_name||' '|| l_pa_request_rec.employee_middle_names;
178: l_ssn := l_pa_request_rec.employee_national_identifier;
179:
180: --Bug # 9329643
181: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
182: (p_person_id => l_pa_request_rec.person_id,
183: p_effective_date => l_pa_request_rec.effective_date);
184: -- These will be the ones that will be common to all the mass actions.
185: --
499: l_pa_request_rec.to_locality_adj := l_pa_request_rec.from_locality_adj;
500: l_pa_request_rec.to_total_salary := l_pa_request_rec.from_total_salary;
501: ELSIF l_pa_request_rec.first_noa_code IN ('792') THEN
502: IF l_pa_request_rec.duty_station_location_id <> l_duty_station_location_id THEN
503: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
504: (p_location_id => l_duty_station_location_id
505: ,p_duty_station_id => l_target_duty_station_id);
506: IF (ghr_pay_calc.get_lpa_percentage (l_pa_request_rec.duty_station_id, l_pa_request_rec.effective_date)
507: <> ghr_pay_calc.get_lpa_percentage (l_target_duty_station_id, l_pa_request_rec.effective_date)) THEN
517: open get_sal_chg_fam(p_effective_date => l_pa_request_rec.effective_date);
518: fetch get_sal_chg_fam into l_pa_request_rec.noa_Family_Code;
519: close get_sal_chg_fam;
520: l_pa_request_rec.first_action_la_code1 := 'VGR';
521: l_pa_request_rec.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description
522: (800,'GHR_US_LEGAL_AUTHORITY',l_pa_request_rec.first_action_la_code1);
523:
524: END IF;
525: END IF;
553:
554: -- # Bug 711533 : Added the if condition
555: IF p_mass_action_type <> 'MASS_TRANSFER_IN' THEN
556: hr_utility.set_location(l_proc,65);
557: ghr_pa_requests_pkg.get_SF52_person_ddf_details
558: (p_person_id => l_pa_request_rec.person_id,
559: p_date_effective => l_pa_request_rec.effective_date,
560: p_citizenship => l_pa_request_rec.citizenship,
561: p_veterans_preference => l_pa_request_rec.veterans_preference,
589: l_position_id := l_pa_request_rec.from_position_id;
590: END IF;
591: IF p_mass_action_type <> 'MASS_TRANSFER_IN' THEN
592:
593: ghr_pa_requests_pkg.get_sf52_pos_ddf_details
594: (p_position_id => l_position_id
595: ,p_date_Effective => l_pa_request_rec.effective_date
596: ,p_flsa_category => l_pa_request_rec.flsa_category
597: ,p_bargaining_unit_status => l_pa_request_rec.bargaining_unit_status
609: END IF;
610:
611: IF p_mass_action_type = 'MASS_TRANSFER_IN' THEN
612:
613: ghr_pa_requests_pkg.get_sf52_pos_ddf_details
614: (p_position_id => l_position_id
615: ,p_date_Effective => l_pa_request_rec.effective_date
616: ,p_flsa_category => l_dummy
617: ,p_bargaining_unit_status => l_dummy
660: );
661:
662: END IF; -- end for the condn. not = mass transfer in for retrieving elements.
663:
664: l_pa_request_rec.fegli_desc := ghr_pa_requests_pkg.get_lookup_meaning
665: (800
666: ,'GHR_US_FEGLI'
667: ,l_pa_request_rec.fegli
668: );
667: ,l_pa_request_rec.fegli
668: );
669:
670:
671: l_pa_request_rec.retirement_plan_desc := ghr_pa_requests_pkg.get_lookup_meaning
672: (800
673: ,'GHR_US_RETIREMENT_PLAN'
674: ,l_pa_request_rec.retirement_plan
675: );
707:
708: -- Descriptions for the codes passed in
709:
710: -- Annuitant_indicator
711: l_pa_request_rec.annuitant_indicator_desc := ghr_pa_requests_pkg.get_lookup_meaning
712: (800
713: ,'GHR_US_ANNUITANT_INDICATOR'
714: ,l_pa_request_rec.annuitant_indicator
715: );
714: ,l_pa_request_rec.annuitant_indicator
715: );
716:
717: --WORK_SCHEDULE
718: l_pa_request_rec.work_schedule_desc := ghr_pa_requests_pkg.get_lookup_meaning
719: (800
720: ,'GHR_US_WORK_SCHEDULE'
721: ,l_pa_request_rec.work_schedule
722: );
728:
729:
730: --Bug #1295328 initialize
731: IF p_mass_action_type = 'MASS_TRANSFER_OUT' THEN
732: ghr_pa_requests_pkg.get_address_details
733: (p_person_id => l_pa_request_rec.person_id
734: ,p_effective_date => l_pa_request_rec.effective_date
735: ,p_address_line1 => l_pa_request_rec.forwarding_address_line1
736: ,p_address_line2 => l_pa_request_rec.forwarding_address_line2
1004: IF p_mass_action_type IN ('MASS_REALIGNMENT','MASS_NOA_SEL') THEN
1005: -- We need to put into the shadow table, the values that we are changing through
1006: -- the 52 which are AP/UE so that, UPDATE HR will not refresh the values.
1007:
1008: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1009: (p_location_id => l_duty_station_location_id
1010: ,p_duty_station_id => l_pa_request_rec.duty_station_id);
1011:
1012: ghr_pa_requests_pkg.get_duty_station_details
1008: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1009: (p_location_id => l_duty_station_location_id
1010: ,p_duty_station_id => l_pa_request_rec.duty_station_id);
1011:
1012: ghr_pa_requests_pkg.get_duty_station_details
1013: (p_duty_station_id => l_pa_request_rec.duty_station_id
1014: ,p_effective_date => l_pa_request_rec.effective_date
1015: ,p_duty_station_code => l_pa_request_rec.duty_station_code
1016: ,p_duty_station_desc => l_pa_request_rec.duty_station_desc);
1293:
1294: l_sf52_data := p_sf52_data;
1295:
1296: if nvl(p_action, 'xXxX#$%') = 'MASS_TRANSFER_IN' then
1297: ghr_pa_requests_pkg.get_SF52_person_ddf_details
1298: (p_person_id => l_sf52_data.person_id
1299: ,p_date_effective => l_sf52_data.effective_date
1300: ,p_citizenship => l_sf52_data.citizenship
1301: ,p_veterans_preference => l_sf52_data.veterans_preference
1320: -- l_sf52_data.education_level := l_education_level;
1321: -- l_sf52_data.academic_discipline := l_academic_discipline;
1322: -- l_sf52_data.year_degree_attained := l_year_degree_attained;
1323:
1324: ghr_pa_requests_pkg.get_SF52_pos_ddf_details
1325: (p_position_id => l_sf52_data.to_position_id
1326: ,p_date_effective => l_sf52_data.effective_date
1327: ,p_flsa_category => l_sf52_data.flsa_category
1328: ,p_bargaining_unit_status => l_sf52_data.bargaining_unit_status