[Home] [Help]
14: l_pei_extra_info per_people_extra_info%rowtype;
15:
16: BEGIN
17:
18: hr_utility.set_location('Entering: ' || l_proc, 10);
19: if (p_pa_req_rec.noa_family_code not in ('CONV_APP','APP','APPT_TRANS') ) then
20: if (p_pei_auth_code1 = hr_api.g_varchar2) then
21: ghr_history_fetch.fetch_peopleei(p_person_id => p_pa_req_rec.person_id
22: ,p_information_type => 'GHR_US_PER_GROUP1'
31: else
32: p_auth_code1 := p_pa_req_rec.first_action_la_code1;
33: p_auth_code2 := p_pa_req_rec.first_action_la_code2;
34: end if;
35: hr_utility.set_location('Leaving: ' || l_proc, 20);
36: END;
37:
38:
39: -- *************************
262:
263:
264: Begin
265:
266: hr_utility.set_location('PERSON ID : ' ||to_char(p_pa_request_rec.person_id) ,1);
267: hr_utility.set_location('EMP ID : ' ||to_char(p_pa_request_rec.employee_assignment_id) ,2);
268: hr_utility.set_location('POS ID : ' ||to_char(p_pa_request_rec.to_position_id) ,3);
269:
270:
263:
264: Begin
265:
266: hr_utility.set_location('PERSON ID : ' ||to_char(p_pa_request_rec.person_id) ,1);
267: hr_utility.set_location('EMP ID : ' ||to_char(p_pa_request_rec.employee_assignment_id) ,2);
268: hr_utility.set_location('POS ID : ' ||to_char(p_pa_request_rec.to_position_id) ,3);
269:
270:
271: -- Retrieve all the extra information (required for CPDFs and for update to HR)
264: Begin
265:
266: hr_utility.set_location('PERSON ID : ' ||to_char(p_pa_request_rec.person_id) ,1);
267: hr_utility.set_location('EMP ID : ' ||to_char(p_pa_request_rec.employee_assignment_id) ,2);
268: hr_utility.set_location('POS ID : ' ||to_char(p_pa_request_rec.to_position_id) ,3);
269:
270:
271: -- Retrieve all the extra information (required for CPDFs and for update to HR)
272: -- from the Core Tables and store them in the respective Record Groups
385: p_ipa_benefits_cont => l_imm_ipa_benefits_cont, -- Bug #6312144 retreiving benefits information
386: p_retirement_info => l_imm_retirement_info
387: );
388:
389: hr_utility.set_location('Relocation Bonus ' || l_imm_relocation_bonus.p_relocation_bonus,1);
390: hr_utility.set_location('Relocation EXP ' || l_imm_relocation_bonus.p_date_reloc_exp,2);
391: hr_utility.set_location('Recruitment EXP ' || l_imm_recruitment_bonus.p_date_recruit_exp,3);
392:
393:
386: p_retirement_info => l_imm_retirement_info
387: );
388:
389: hr_utility.set_location('Relocation Bonus ' || l_imm_relocation_bonus.p_relocation_bonus,1);
390: hr_utility.set_location('Relocation EXP ' || l_imm_relocation_bonus.p_date_reloc_exp,2);
391: hr_utility.set_location('Recruitment EXP ' || l_imm_recruitment_bonus.p_date_recruit_exp,3);
392:
393:
394: -- With the new ghr_pa_requests table, we just need to fetch the agency_code.
387: );
388:
389: hr_utility.set_location('Relocation Bonus ' || l_imm_relocation_bonus.p_relocation_bonus,1);
390: hr_utility.set_location('Relocation EXP ' || l_imm_relocation_bonus.p_date_reloc_exp,2);
391: hr_utility.set_location('Recruitment EXP ' || l_imm_recruitment_bonus.p_date_recruit_exp,3);
392:
393:
394: -- With the new ghr_pa_requests table, we just need to fetch the agency_code.
395: -- And this info. is required by CPDF edits and later by the SF50 Report
436: end loop;
437: Else
438: l_effective_date := p_pa_request_rec.effective_date;
439: End if;
440: hr_utility.set_location('l_effective_date passed to fetch_assignment '||l_effective_date,3 );
441:
442: Ghr_History_Fetch.Fetch_assignment
443: (
444: p_assignment_id => p_pa_request_rec.employee_assignment_id,
451: l_imm_sf52_from_data.duty_station_location_id := l_assignment_data.location_id;
452:
453: End if;
454:
455: hr_utility.set_location('from_duty_station '||l_imm_sf52_from_data.duty_station_location_id,4 );
456:
457:
458: -- Should retrieve Employee_sex(per_people_f for the person_id , for a specific date),
459: -- as it is not stored in the ghr_pa_requests table
505: -- get the session variable
506: ghr_history_api.get_g_session_var(l_session);
507:
508: If l_session.noa_id_correct is null then
509: hr_utility.set_location('populate_record_groups ', 30);
510:
511: ghr_api.return_special_information
512: (p_person_id => p_pa_request_rec.person_id,
513: p_structure_name => 'US Fed Perf Appraisal',
515: p_special_info => l_special_info_type
516: );
517:
518: Else -- for update get from history
519: hr_utility.set_location('populate_record_groups ', 35);
520: ghr_history_fetch.return_special_information
521: (p_person_id => p_pa_request_rec.person_id,
522: p_structure_name => 'US Fed Perf Appraisal',
523: p_effective_date => p_pa_request_rec.effective_date,
555: l_imm_perf_appraisal.performance_rating_points := l_special_info_type.segment16;
556: --Bug# 4753117 28-Feb-07 Veeramani assigning appraisal start date
557: l_imm_perf_appraisal.date_appr_starts := l_special_info_type.segment17;
558:
559: hr_utility.set_location('performance_rating_points'||l_special_info_type.segment16, 39);
560: -- Get user entered details
561: hr_utility.set_location('populate_record_groups ', 40);
562:
563: for perf_appraisal in c_performance_appraisal loop
557: l_imm_perf_appraisal.date_appr_starts := l_special_info_type.segment17;
558:
559: hr_utility.set_location('performance_rating_points'||l_special_info_type.segment16, 39);
560: -- Get user entered details
561: hr_utility.set_location('populate_record_groups ', 40);
562:
563: for perf_appraisal in c_performance_appraisal loop
564:
565: --No need for the IF condition since 'US Fed Perf Appraisal' is a mandatory SIT
651: l_imm_perf_appraisal.optional_information := perf_appraisal.optional_info;
652: l_imm_perf_appraisal.perf_appr_flag := 'Y';
653: end if;
654:
655: hr_utility.set_location('performance_rating_points'||perf_appraisal.performance_rating_points, 41);
656:
657: if nvl(perf_appraisal.performance_rating_points,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.performance_rating_points,hr_api.g_varchar2) then
658: l_imm_perf_appraisal.performance_rating_points := perf_appraisal.performance_rating_points;
659: l_imm_perf_appraisal.perf_appr_flag := 'Y';
864: l_request_id := p_pa_request_id;
865: l_extra_info_id := null;
866: for c1_rec in c1(c_request_id => l_request_id) loop
867: --dbms_output.put_line('inside fetch extra info id loop1');
868: hr_utility.set_location(l_proc,1);
869: l_request_id := c1_rec.altered_pa_request_id;
870: If l_request_id is not null then
871: for c2_rec in c2(l_request_id) loop
872: hr_utility.set_location(l_proc,1);
868: hr_utility.set_location(l_proc,1);
869: l_request_id := c1_rec.altered_pa_request_id;
870: If l_request_id is not null then
871: for c2_rec in c2(l_request_id) loop
872: hr_utility.set_location(l_proc,1);
873: l_extra_info_id := c2_rec.rei_information3;
874: end loop;
875: hr_utility.set_location(l_proc ||'Extra info id is '|| to_char(l_extra_info_id),3);
876: End if;
871: for c2_rec in c2(l_request_id) loop
872: hr_utility.set_location(l_proc,1);
873: l_extra_info_id := c2_rec.rei_information3;
874: end loop;
875: hr_utility.set_location(l_proc ||'Extra info id is '|| to_char(l_extra_info_id),3);
876: End if;
877: If l_extra_info_id is not null then
878: exit;
879: End if;
876: End if;
877: If l_extra_info_id is not null then
878: exit;
879: End if;
880: hr_utility.set_location(l_proc,4);
881: end loop;
882: p_person_extra_info_id := l_extra_info_id;
883: end get_ret_grade;
884:
893: ghr_history_api.get_g_session_var(l_session); -- Bug 3021003
894: -- l_extra_info_rec.l_extra_info_id := null;
895: -- Bug # 1234846 --
896: If p_pa_request_rec.noa_family_code in ('APP','CONV_APP') then
897: hr_utility.set_location(l_proc,12);
898: l_person_type := null;
899: for per_type in c_person_type loop
900: l_person_type := per_type.system_person_type;
901: end loop;
899: for per_type in c_person_type loop
900: l_person_type := per_type.system_person_type;
901: end loop;
902: if l_person_type is null then
903: hr_utility.set_message(8301,'GHR_38133_INVALID_PERSON');
904: hr_utility.raise_error;
905: end if;
906: End if;
907:
900: l_person_type := per_type.system_person_type;
901: end loop;
902: if l_person_type is null then
903: hr_utility.set_message(8301,'GHR_38133_INVALID_PERSON');
904: hr_utility.raise_error;
905: end if;
906: End if;
907:
908: hr_utility.set_location(' Noa Family Code is ' || p_pa_request_rec.noa_family_code ,13);
904: hr_utility.raise_error;
905: end if;
906: End if;
907:
908: hr_utility.set_location(' Noa Family Code is ' || p_pa_request_rec.noa_family_code ,13);
909: hr_utility.set_location(' Person Type is ' || l_person_type,14);
910: -- Bug 3390876 Need to populate record groups even for Conversion of Appointment NTE actions if Suspended
911: IF p_pa_request_rec.employee_assignment_id IS NOT NULL THEN
912: FOR l_user_status IN c_user_status(p_pa_request_rec.employee_assignment_id,g_effective_date) LOOP
905: end if;
906: End if;
907:
908: hr_utility.set_location(' Noa Family Code is ' || p_pa_request_rec.noa_family_code ,13);
909: hr_utility.set_location(' Person Type is ' || l_person_type,14);
910: -- Bug 3390876 Need to populate record groups even for Conversion of Appointment NTE actions if Suspended
911: IF p_pa_request_rec.employee_assignment_id IS NOT NULL THEN
912: FOR l_user_status IN c_user_status(p_pa_request_rec.employee_assignment_id,g_effective_date) LOOP
913: l_person_status := l_user_status.per_system_status;
920: l_person_type <> 'EX_EMP') OR
921: (p_pa_request_rec.first_noa_code IN ('508','515','517','522','548','549','553','554','571','590')) THEN
922: -- AND l_person_status = 'SUSP_ASSIGN') THEN
923: IF p_pa_request_rec.employee_assignment_id is not null then
924: hr_utility.set_location(' asg id ' || to_char(p_pa_request_rec.employee_assignment_id) ,2);
925: hr_utility.set_location(' Date ' || to_Char(p_pa_request_rec.effective_date),2);
926:
927: -- Retrieve asg_sf52
928:
921: (p_pa_request_rec.first_noa_code IN ('508','515','517','522','548','549','553','554','571','590')) THEN
922: -- AND l_person_status = 'SUSP_ASSIGN') THEN
923: IF p_pa_request_rec.employee_assignment_id is not null then
924: hr_utility.set_location(' asg id ' || to_char(p_pa_request_rec.employee_assignment_id) ,2);
925: hr_utility.set_location(' Date ' || to_Char(p_pa_request_rec.effective_date),2);
926:
927: -- Retrieve asg_sf52
928:
929: ghr_history_fetch.fetch_asgei
932: p_date_effective => p_pa_request_rec.effective_date,
933: p_asg_ei_data => l_asg_extra_info_rec
934: );
935:
936: hr_utility.set_location('retrieved asg extra info 1 ',1);
937:
938: p_asg_sf52.assignment_extra_info_id := l_asg_extra_info_rec.assignment_extra_info_id;
939: p_asg_sf52.object_version_number := l_asg_extra_info_rec.object_version_number;
940: p_asg_sf52.step_or_rate := l_asg_extra_info_rec.aei_information3;
944: p_asg_sf52.work_schedule := l_asg_extra_info_rec.aei_information7;
945: p_asg_sf52.part_time_hours := l_asg_extra_info_rec.aei_information8;
946: p_asg_sf52.calc_pay_table := l_asg_extra_info_rec.aei_information9;
947:
948: hr_utility.set_location('After Fetch from local var - tenure ' || l_asg_extra_info_rec.aei_information3,2);
949: hr_utility.set_location('After Fetch from local var - asextrinfoid ' || to_char(l_asg_extra_info_rec.assignment_extra_info_id) ,2);
950: l_asg_extra_info_rec := null;
951: hr_utility.set_location('After Fetch - tenure ' || p_asg_sf52.tenure,2);
952: hr_utility.set_location('After Fetch - annu indic' || p_asg_sf52.annuitant_indicator,2);
945: p_asg_sf52.part_time_hours := l_asg_extra_info_rec.aei_information8;
946: p_asg_sf52.calc_pay_table := l_asg_extra_info_rec.aei_information9;
947:
948: hr_utility.set_location('After Fetch from local var - tenure ' || l_asg_extra_info_rec.aei_information3,2);
949: hr_utility.set_location('After Fetch from local var - asextrinfoid ' || to_char(l_asg_extra_info_rec.assignment_extra_info_id) ,2);
950: l_asg_extra_info_rec := null;
951: hr_utility.set_location('After Fetch - tenure ' || p_asg_sf52.tenure,2);
952: hr_utility.set_location('After Fetch - annu indic' || p_asg_sf52.annuitant_indicator,2);
953: hr_utility.set_location('After Fetch- asextrinfoid ' || to_char(p_asg_sf52.assignment_extra_info_id) ,2);
947:
948: hr_utility.set_location('After Fetch from local var - tenure ' || l_asg_extra_info_rec.aei_information3,2);
949: hr_utility.set_location('After Fetch from local var - asextrinfoid ' || to_char(l_asg_extra_info_rec.assignment_extra_info_id) ,2);
950: l_asg_extra_info_rec := null;
951: hr_utility.set_location('After Fetch - tenure ' || p_asg_sf52.tenure,2);
952: hr_utility.set_location('After Fetch - annu indic' || p_asg_sf52.annuitant_indicator,2);
953: hr_utility.set_location('After Fetch- asextrinfoid ' || to_char(p_asg_sf52.assignment_extra_info_id) ,2);
954:
955:
948: hr_utility.set_location('After Fetch from local var - tenure ' || l_asg_extra_info_rec.aei_information3,2);
949: hr_utility.set_location('After Fetch from local var - asextrinfoid ' || to_char(l_asg_extra_info_rec.assignment_extra_info_id) ,2);
950: l_asg_extra_info_rec := null;
951: hr_utility.set_location('After Fetch - tenure ' || p_asg_sf52.tenure,2);
952: hr_utility.set_location('After Fetch - annu indic' || p_asg_sf52.annuitant_indicator,2);
953: hr_utility.set_location('After Fetch- asextrinfoid ' || to_char(p_asg_sf52.assignment_extra_info_id) ,2);
954:
955:
956: -- Retrieve asg_non_sf52
949: hr_utility.set_location('After Fetch from local var - asextrinfoid ' || to_char(l_asg_extra_info_rec.assignment_extra_info_id) ,2);
950: l_asg_extra_info_rec := null;
951: hr_utility.set_location('After Fetch - tenure ' || p_asg_sf52.tenure,2);
952: hr_utility.set_location('After Fetch - annu indic' || p_asg_sf52.annuitant_indicator,2);
953: hr_utility.set_location('After Fetch- asextrinfoid ' || to_char(p_asg_sf52.assignment_extra_info_id) ,2);
954:
955:
956: -- Retrieve asg_non_sf52
957:
962: p_asg_ei_data => l_asg_extra_info_rec
963: );
964:
965:
966: hr_utility.set_location('retrieved asg extra info 2 ',2);
967:
968: p_asg_non_sf52.assignment_extra_info_id := l_asg_extra_info_rec.assignment_extra_info_id;
969: p_asg_non_sf52.object_version_number := l_asg_extra_info_rec.object_version_number;
970: p_asg_non_sf52.date_arr_personnel_office := l_asg_extra_info_rec.aei_information3;
986: p_date_effective => p_pa_request_rec.effective_date,
987: p_asg_ei_data => l_asg_extra_info_rec
988: );
989:
990: hr_utility.set_location('retrieved asg extra info 3 ',3);
991:
992:
993: p_asg_nte_dates.assignment_extra_info_id := l_asg_extra_info_rec.assignment_extra_info_id;
994: p_asg_nte_dates.object_version_number := l_asg_extra_info_rec.object_version_number;
1019: p_date_effective => p_pa_request_rec.effective_date,
1020: p_per_ei_data => l_per_extra_info_rec
1021: );
1022:
1023: hr_utility.set_location('retrieved per sf52 ',5);
1024:
1025: p_per_sf52.person_extra_info_id := l_per_extra_info_rec.person_extra_info_id;
1026: p_per_sf52.object_version_number := l_per_extra_info_rec.object_version_number;
1027: p_per_sf52.citizenship := l_per_extra_info_rec.pei_information3;
1039: p_date_effective => p_pa_request_rec.effective_date,
1040: p_per_ei_data => l_per_extra_info_rec
1041: );
1042:
1043: hr_utility.set_location('After fetch RINO ' || l_per_extra_info_rec.pei_information5,1);
1044: hr_utility.set_location('After Fetch HANDICAP ' || l_per_extra_info_rec.pei_information11,2);
1045:
1046: hr_utility.set_location('retrieved per group1 ',6);
1047:
1040: p_per_ei_data => l_per_extra_info_rec
1041: );
1042:
1043: hr_utility.set_location('After fetch RINO ' || l_per_extra_info_rec.pei_information5,1);
1044: hr_utility.set_location('After Fetch HANDICAP ' || l_per_extra_info_rec.pei_information11,2);
1045:
1046: hr_utility.set_location('retrieved per group1 ',6);
1047:
1048: p_per_group1.person_extra_info_id := l_per_extra_info_rec.person_extra_info_id;
1042:
1043: hr_utility.set_location('After fetch RINO ' || l_per_extra_info_rec.pei_information5,1);
1044: hr_utility.set_location('After Fetch HANDICAP ' || l_per_extra_info_rec.pei_information11,2);
1045:
1046: hr_utility.set_location('retrieved per group1 ',6);
1047:
1048: p_per_group1.person_extra_info_id := l_per_extra_info_rec.person_extra_info_id;
1049: p_per_group1.object_version_number := l_per_extra_info_rec.object_version_number;
1050: p_per_group1.appointment_type := l_per_extra_info_rec.pei_information3;
1078: p_date_effective => p_pa_request_rec.effective_date,
1079: p_per_ei_data => l_per_extra_info_rec
1080: );
1081:
1082: hr_utility.set_location('After fetch SCD ' || l_per_extra_info_rec.pei_information3,1);
1083:
1084: hr_utility.set_location('retrieved per scd ',8);
1085:
1086: p_per_scd_info.person_extra_info_id := l_per_extra_info_rec.person_extra_info_id;
1080: );
1081:
1082: hr_utility.set_location('After fetch SCD ' || l_per_extra_info_rec.pei_information3,1);
1083:
1084: hr_utility.set_location('retrieved per scd ',8);
1085:
1086: p_per_scd_info.person_extra_info_id := l_per_extra_info_rec.person_extra_info_id;
1087: p_per_scd_info.object_version_number := l_per_extra_info_rec.object_version_number;
1088: p_per_scd_info.scd_leave := l_per_extra_info_rec.pei_information3;
1105: p_per_ei_data => l_per_extra_info_rec
1106: );
1107:
1108:
1109: hr_utility.set_location('retrieved per probations ',9);
1110:
1111: p_per_probations.person_extra_info_id := l_per_extra_info_rec.person_extra_info_id;
1112: p_per_probations.object_version_number := l_per_extra_info_rec.object_version_number;
1113: p_per_probations.date_prob_trial_period_begin := l_per_extra_info_rec.pei_information3;
1162: --End if;
1163: -- Bug 3021003 If Intervening actions are present in WGI, QSI corrections, get the corrected step.
1164: -- Bug 4658890 Removed 894 from first_noa_code
1165: IF p_pa_request_rec.first_noa_code IN ('867','892','893') AND l_session.noa_id_correct IS NOT NULL THEN
1166: hr_utility.set_location('Inside PRUP Sun if condn',10);
1167: ghr_pay_calc.is_retained_ia(p_pa_request_rec.person_id,
1168: p_pa_request_rec.effective_date,
1169: l_retained_grade_rec.pay_plan,
1170: l_retained_grade_rec.grade_or_level,
1172: l_retained_grade_rec.temp_step,
1173: l_ret_flag);
1174: IF l_ret_flag = TRUE THEN
1175: IF l_retained_grade_rec.temp_step IS NOT NULL THEN
1176: hr_utility.set_location('Inside PRUP Sun if temp_step condn' || l_retained_grade_rec.temp_step,10);
1177: p_per_retained_grade.temp_step := ghr_pc_basic_pay.get_next_WGI_step (l_retained_grade_rec.pay_plan,l_retained_grade_rec.temp_step);
1178: ELSE
1179: hr_utility.set_location('Inside PRUP Sun ELSE temp_step condn' || l_retained_grade_rec.step_or_rate,10);
1180: p_per_retained_grade.retain_step_or_rate := ghr_pc_basic_pay.get_next_WGI_step (l_retained_grade_rec.pay_plan,l_retained_grade_rec.step_or_rate);
1175: IF l_retained_grade_rec.temp_step IS NOT NULL THEN
1176: hr_utility.set_location('Inside PRUP Sun if temp_step condn' || l_retained_grade_rec.temp_step,10);
1177: p_per_retained_grade.temp_step := ghr_pc_basic_pay.get_next_WGI_step (l_retained_grade_rec.pay_plan,l_retained_grade_rec.temp_step);
1178: ELSE
1179: hr_utility.set_location('Inside PRUP Sun ELSE temp_step condn' || l_retained_grade_rec.step_or_rate,10);
1180: p_per_retained_grade.retain_step_or_rate := ghr_pc_basic_pay.get_next_WGI_step (l_retained_grade_rec.pay_plan,l_retained_grade_rec.step_or_rate);
1181: END IF;
1182: p_per_sf52.per_sf52_flag := 'Y';
1183: END IF;
1182: p_per_sf52.per_sf52_flag := 'Y';
1183: END IF;
1184: END IF;
1185:
1186: hr_utility.set_location('Retrieved Per_retained_grade',10);
1187:
1188: -- Need to handle this Exception here because it is just a warning to indicate that the pay cannot be calculated
1189: -- which is only apt for the Front End and does not matter in this context.
1190:
1194: end;
1195:
1196: -- Retrieve per_separate_retire
1197:
1198: hr_utility.set_location('retrieved per unif ',13);
1199: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
1200: p_per_separate_retire.agency_code_transfer_to ,13);
1201: hr_utility.set_location('l_per_extra_info_rec.pei_information8 = ' ||
1202: l_per_extra_info_rec.pei_information8 ,13);
1195:
1196: -- Retrieve per_separate_retire
1197:
1198: hr_utility.set_location('retrieved per unif ',13);
1199: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
1200: p_per_separate_retire.agency_code_transfer_to ,13);
1201: hr_utility.set_location('l_per_extra_info_rec.pei_information8 = ' ||
1202: l_per_extra_info_rec.pei_information8 ,13);
1203: ghr_history_fetch.fetch_peopleei
1197:
1198: hr_utility.set_location('retrieved per unif ',13);
1199: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
1200: p_per_separate_retire.agency_code_transfer_to ,13);
1201: hr_utility.set_location('l_per_extra_info_rec.pei_information8 = ' ||
1202: l_per_extra_info_rec.pei_information8 ,13);
1203: ghr_history_fetch.fetch_peopleei
1204: (p_person_id => p_pa_request_rec.person_id,
1205: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
1217: p_per_separate_retire.date_projected_retirement := l_per_extra_info_rec.pei_information9;
1218: p_per_separate_retire.mandatory_retirement_date := l_per_extra_info_rec.pei_information10;
1219: --Start Bug 1359482
1220: If nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) in ('300','301','302','303','304') then
1221: hr_utility.set_location('separate_pkg_status_indicator defaults to 1',14);
1222: p_per_separate_retire.separate_pkg_status_indicator := '1';
1223: p_per_separate_retire.per_sep_retire_flag := 'Y';
1224: else
1225: p_per_separate_retire.separate_pkg_status_indicator := l_per_extra_info_rec.pei_information11;
1234: p_per_separate_retire.date_ret_pkg_to_opm := l_per_extra_info_rec.pei_information17;
1235:
1236: l_per_extra_info_rec := null;
1237:
1238: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
1239: p_per_separate_retire.agency_code_transfer_to ,14);
1240: hr_utility.set_location('l_per_extra_info_rec.pei_information8 = ' ||
1241: l_per_extra_info_rec.pei_information8 ,14);
1242: hr_utility.set_location('retrieved per unif ',14);
1236: l_per_extra_info_rec := null;
1237:
1238: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
1239: p_per_separate_retire.agency_code_transfer_to ,14);
1240: hr_utility.set_location('l_per_extra_info_rec.pei_information8 = ' ||
1241: l_per_extra_info_rec.pei_information8 ,14);
1242: hr_utility.set_location('retrieved per unif ',14);
1243:
1244: -- Bug#4486823 RRR Changes
1238: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
1239: p_per_separate_retire.agency_code_transfer_to ,14);
1240: hr_utility.set_location('l_per_extra_info_rec.pei_information8 = ' ||
1241: l_per_extra_info_rec.pei_information8 ,14);
1242: hr_utility.set_location('retrieved per unif ',14);
1243:
1244: -- Bug#4486823 RRR Changes
1245: -- Retrieve per_service_obligation
1246:
1256: p_per_service_oblig.service_oblig_start_date := l_per_extra_info_rec.pei_information4;
1257: p_per_service_oblig.service_oblig_end_date := l_per_extra_info_rec.pei_information5;
1258: l_per_extra_info_rec := null;
1259:
1260: hr_utility.set_location('p_per_service_oblig.service_oblig_type_code = ' ||
1261: p_per_service_oblig.service_oblig_type_code ,15);
1262: hr_utility.set_location('p_per_service_oblig.service_oblig_start_date = ' ||
1263: p_per_service_oblig.service_oblig_start_date ,15);
1264: hr_utility.set_location('retrieved per serv oblg ',15); */
1258: l_per_extra_info_rec := null;
1259:
1260: hr_utility.set_location('p_per_service_oblig.service_oblig_type_code = ' ||
1261: p_per_service_oblig.service_oblig_type_code ,15);
1262: hr_utility.set_location('p_per_service_oblig.service_oblig_start_date = ' ||
1263: p_per_service_oblig.service_oblig_start_date ,15);
1264: hr_utility.set_location('retrieved per serv oblg ',15); */
1265:
1266: -- Retrieve per_uniformed_services
1260: hr_utility.set_location('p_per_service_oblig.service_oblig_type_code = ' ||
1261: p_per_service_oblig.service_oblig_type_code ,15);
1262: hr_utility.set_location('p_per_service_oblig.service_oblig_start_date = ' ||
1263: p_per_service_oblig.service_oblig_start_date ,15);
1264: hr_utility.set_location('retrieved per serv oblg ',15); */
1265:
1266: -- Retrieve per_uniformed_services
1267:
1268: ghr_history_fetch.fetch_peopleei
1370: p_date_effective => p_pa_request_rec.effective_date,
1371: p_pos_ei_data => l_pos_extra_info_rec
1372: );
1373:
1374: hr_utility.set_location('retrieved pos valid grade ',15);
1375:
1376: p_valid_grade.position_extra_info_id := l_pos_extra_info_rec.position_extra_info_id;
1377: p_valid_grade.object_version_number := l_pos_extra_info_rec.object_version_number;
1378: p_valid_grade.valid_grade := l_pos_extra_info_rec.poei_information3;
1379: p_valid_grade.target_grade := l_pos_extra_info_rec.poei_information4;
1380: p_valid_grade.pay_table_id := l_pos_extra_info_rec.poei_information5;
1381: p_valid_grade.pay_basis := l_pos_extra_info_rec.poei_information6;
1382: p_valid_grade.employment_category_group := l_pos_extra_info_rec.poei_information7;
1383: hr_utility.set_location('POS_VAL_GRADE - POS ID ' || to_char(l_position_id),1);
1384: hr_utility.set_location('POS_VAL_GRADE - OVN ' || to_char(l_pos_extra_info_rec.object_version_number),2);
1385: hr_utility.set_location('POS_VAL_GRADE - POEI ID' || to_char(l_pos_extra_info_rec.position_extra_info_id),3);
1386:
1387: l_pos_extra_info_rec := null;
1380: p_valid_grade.pay_table_id := l_pos_extra_info_rec.poei_information5;
1381: p_valid_grade.pay_basis := l_pos_extra_info_rec.poei_information6;
1382: p_valid_grade.employment_category_group := l_pos_extra_info_rec.poei_information7;
1383: hr_utility.set_location('POS_VAL_GRADE - POS ID ' || to_char(l_position_id),1);
1384: hr_utility.set_location('POS_VAL_GRADE - OVN ' || to_char(l_pos_extra_info_rec.object_version_number),2);
1385: hr_utility.set_location('POS_VAL_GRADE - POEI ID' || to_char(l_pos_extra_info_rec.position_extra_info_id),3);
1386:
1387: l_pos_extra_info_rec := null;
1388:
1381: p_valid_grade.pay_basis := l_pos_extra_info_rec.poei_information6;
1382: p_valid_grade.employment_category_group := l_pos_extra_info_rec.poei_information7;
1383: hr_utility.set_location('POS_VAL_GRADE - POS ID ' || to_char(l_position_id),1);
1384: hr_utility.set_location('POS_VAL_GRADE - OVN ' || to_char(l_pos_extra_info_rec.object_version_number),2);
1385: hr_utility.set_location('POS_VAL_GRADE - POEI ID' || to_char(l_pos_extra_info_rec.position_extra_info_id),3);
1386:
1387: l_pos_extra_info_rec := null;
1388:
1389: -- Retrieve Position group1
1396: p_pos_ei_data => l_pos_extra_info_rec
1397: );
1398:
1399:
1400: hr_utility.set_location('retrieved pos grp 1 ',16);
1401:
1402: p_pos_grp1.position_extra_info_id := l_pos_extra_info_rec.position_extra_info_id;
1403: p_pos_grp1.object_version_number := l_pos_extra_info_rec.object_version_number;
1404: p_pos_grp1.personnel_office_id := l_pos_extra_info_rec.poei_information3;
1424: p_pos_grp1.part_time_hours := l_pos_extra_info_rec.poei_information23;
1425:
1426:
1427:
1428: hr_utility.set_location('POS_gRP1 - POS ID ' || to_char(l_position_id),1);
1429: hr_utility.set_location('POS_GRP1 - OVN ' || to_char(p_pos_grp1.object_version_number),2);
1430: hr_utility.set_location('POS_GRP1 - POEI ID' || to_char(p_pos_grp1.position_extra_info_id),3);
1431:
1432: l_pos_extra_info_rec := null;
1425:
1426:
1427:
1428: hr_utility.set_location('POS_gRP1 - POS ID ' || to_char(l_position_id),1);
1429: hr_utility.set_location('POS_GRP1 - OVN ' || to_char(p_pos_grp1.object_version_number),2);
1430: hr_utility.set_location('POS_GRP1 - POEI ID' || to_char(p_pos_grp1.position_extra_info_id),3);
1431:
1432: l_pos_extra_info_rec := null;
1433:
1426:
1427:
1428: hr_utility.set_location('POS_gRP1 - POS ID ' || to_char(l_position_id),1);
1429: hr_utility.set_location('POS_GRP1 - OVN ' || to_char(p_pos_grp1.object_version_number),2);
1430: hr_utility.set_location('POS_GRP1 - POEI ID' || to_char(p_pos_grp1.position_extra_info_id),3);
1431:
1432: l_pos_extra_info_rec := null;
1433:
1434: -- Retrieve Position Group2
1440: p_pos_ei_data => l_pos_extra_info_rec
1441: );
1442:
1443:
1444: hr_utility.set_location('retrieved pos grp 2 ',17);
1445:
1446:
1447: p_pos_grp2.position_extra_info_id := l_pos_extra_info_rec.position_extra_info_id;
1448: p_pos_grp2.object_version_number := l_pos_extra_info_rec.object_version_number;
1459: p_pos_grp2.appropriation_code1 := l_pos_extra_info_rec.poei_information13;
1460: p_pos_grp2.appropriation_code2 := l_pos_extra_info_rec.poei_information14;
1461: p_pos_grp2.intelligence_position_ind := l_pos_extra_info_rec.poei_information15;
1462: p_pos_grp2.leo_position_indicator := l_pos_extra_info_rec.poei_information16;
1463: hr_utility.set_location('POS_2 - POS ID ' || to_char(l_position_id),1);
1464: hr_utility.set_location('POS_2 - OVN ' || to_char(l_pos_extra_info_rec.object_version_number),2);
1465: hr_utility.set_location('POS_2 - POEI ID' || to_char(l_pos_extra_info_rec.position_extra_info_id),3);
1466:
1467: l_pos_extra_info_rec := null;
1460: p_pos_grp2.appropriation_code2 := l_pos_extra_info_rec.poei_information14;
1461: p_pos_grp2.intelligence_position_ind := l_pos_extra_info_rec.poei_information15;
1462: p_pos_grp2.leo_position_indicator := l_pos_extra_info_rec.poei_information16;
1463: hr_utility.set_location('POS_2 - POS ID ' || to_char(l_position_id),1);
1464: hr_utility.set_location('POS_2 - OVN ' || to_char(l_pos_extra_info_rec.object_version_number),2);
1465: hr_utility.set_location('POS_2 - POEI ID' || to_char(l_pos_extra_info_rec.position_extra_info_id),3);
1466:
1467: l_pos_extra_info_rec := null;
1468:
1461: p_pos_grp2.intelligence_position_ind := l_pos_extra_info_rec.poei_information15;
1462: p_pos_grp2.leo_position_indicator := l_pos_extra_info_rec.poei_information16;
1463: hr_utility.set_location('POS_2 - POS ID ' || to_char(l_position_id),1);
1464: hr_utility.set_location('POS_2 - OVN ' || to_char(l_pos_extra_info_rec.object_version_number),2);
1465: hr_utility.set_location('POS_2 - POEI ID' || to_char(l_pos_extra_info_rec.position_extra_info_id),3);
1466:
1467: l_pos_extra_info_rec := null;
1468:
1469: -- Retrieve Position Obligation
1480: p_pos_oblig.obligation_type := l_pos_extra_info_rec.poei_information4;
1481: p_pos_oblig.employee_ssn := l_pos_extra_info_rec.poei_information5;
1482: l_pos_extra_info_rec := null;
1483:
1484: hr_utility.set_location('retrieved pos oblig ',18);
1485:
1486: /* Retrieve GHR_US_POS_CAR_PROG */
1487:
1488: /* Retrieve GHR_US_PER_BENEFITS_CONT */
1487:
1488: /* Retrieve GHR_US_PER_BENEFITS_CONT */
1489: -- Bug 6312144 IPA Benefits Continuation EIT changes
1490:
1491: hr_utility.set_location('Before retrieving IPA Benefits Continuation',19);
1492: l_per_extra_info_rec := null;
1493: ghr_history_fetch.fetch_peopleei
1494: (p_person_id => p_pa_request_rec.person_id,
1495: p_information_type => 'GHR_US_PER_BENEFITS_CONT',
1511: p_ipa_benefits_cont.Cont_Term_Insuff_Pay_Notf_Date := l_per_extra_info_rec.pei_information10;
1512: p_ipa_benefits_cont.Cont_Term_Insuff_Pmt_Type_Code := l_per_extra_info_rec.pei_information11;
1513:
1514: /* Retrieve GHR_US_PER_BENEFITS_CONT */
1515: hr_utility.set_location('Retrieving IPA Benefits Continuation',20);
1516:
1517: /* Retrieve GHR_US_PER_RETIRMENT_SYS_INFO*/
1518:
1519: hr_utility.set_location('Before retrieving Retirement System Information',21);
1515: hr_utility.set_location('Retrieving IPA Benefits Continuation',20);
1516:
1517: /* Retrieve GHR_US_PER_RETIRMENT_SYS_INFO*/
1518:
1519: hr_utility.set_location('Before retrieving Retirement System Information',21);
1520: -- Bug 6312144 Retirement System Information EIT changes
1521: l_per_extra_info_rec := null;
1522: ghr_history_fetch.fetch_peopleei
1523: (p_person_id => p_pa_request_rec.person_id,
1532: p_retirement_info.App_Exc_FERS_Ind := l_per_extra_info_rec.pei_information3;
1533: p_retirement_info.FICA_Coverage_Ind1 := l_per_extra_info_rec.pei_information4;
1534: p_retirement_info.FICA_Coverage_Ind2 := l_per_extra_info_rec.pei_information5;
1535:
1536: hr_utility.set_location('After Retirement System Information',22);
1537: /* Retrieve GHR_US_PER_RETIRMENT_SYS_INFO*/
1538:
1539: End retrieve_all_extra_info;
1540:
1580: --
1581: Begin
1582: --
1583: g_effective_date := nvl(p_pa_request_rec.effective_date,sysdate);
1584: hr_utility.set_location('Entering ' || l_proc,10);
1585: --
1586: If p_pa_request_rec.to_position_id is null then
1587: l_position_id := p_pa_request_rec.from_position_id;
1588: Else
1620: ,p_business_group_id => l_bus_gp
1621: ,p_effective_date => p_pa_request_rec.effective_date
1622: );
1623: end if;
1624: hr_utility.set_location('Leaving ' ||l_proc,40);
1625: end SF52_br_extra_info;
1626:
1627: --
1628: -- *****************************
1686: /*l_payroll_office_id := p_pos_grp1.payroll_office_id;
1687: l_pos_org := p_pos_grp1.positions_organization;*/
1688: l_student_loan_repay := p_student_loan_repay;
1689:
1690: hr_utility.set_location('Entering ' ||l_proc,5);
1691:
1692: -- **********************
1693: -- Assignment SF52 Extra Info
1694: -- **********************
1701: p_pa_request_rec.to_pay_table_identifier is not null
1702: then
1703: --
1704: --
1705: hr_utility.set_location(l_proc,10);
1706:
1707: --
1708: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,1);
1709: If p_pa_request_rec.to_step_or_rate is not null then
1704: --
1705: hr_utility.set_location(l_proc,10);
1706:
1707: --
1708: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,1);
1709: If p_pa_request_rec.to_step_or_rate is not null then
1710: If P_pa_request_rec.to_step_or_rate <>
1711: nvl(p_asg_sf52.step_or_rate,hr_api.g_varchar2) then
1712: hr_utility.set_location(l_proc,20);
1708: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,1);
1709: If p_pa_request_rec.to_step_or_rate is not null then
1710: If P_pa_request_rec.to_step_or_rate <>
1711: nvl(p_asg_sf52.step_or_rate,hr_api.g_varchar2) then
1712: hr_utility.set_location(l_proc,20);
1713: p_Asg_sf52.Asg_sf52_flag := 'Y';
1714: p_Asg_Sf52.Step_Or_Rate := P_pa_request_rec.to_Step_Or_Rate;
1715: End if;
1716: End if;
1714: p_Asg_Sf52.Step_Or_Rate := P_pa_request_rec.to_Step_Or_Rate;
1715: End if;
1716: End if;
1717: --
1718: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,2);
1719: hr_utility.set_location('old tenure ' || p_asg_sf52.tenure,2);
1720: hr_utility.set_location('new tenure ' || p_pa_request_rec.tenure,2);
1721: hr_utility.set_location('old ann ind ' || p_asg_sf52.annuitant_indicator,2);
1722:
1715: End if;
1716: End if;
1717: --
1718: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,2);
1719: hr_utility.set_location('old tenure ' || p_asg_sf52.tenure,2);
1720: hr_utility.set_location('new tenure ' || p_pa_request_rec.tenure,2);
1721: hr_utility.set_location('old ann ind ' || p_asg_sf52.annuitant_indicator,2);
1722:
1723:
1716: End if;
1717: --
1718: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,2);
1719: hr_utility.set_location('old tenure ' || p_asg_sf52.tenure,2);
1720: hr_utility.set_location('new tenure ' || p_pa_request_rec.tenure,2);
1721: hr_utility.set_location('old ann ind ' || p_asg_sf52.annuitant_indicator,2);
1722:
1723:
1724: If p_pa_request_rec.tenure is not null then
1717: --
1718: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,2);
1719: hr_utility.set_location('old tenure ' || p_asg_sf52.tenure,2);
1720: hr_utility.set_location('new tenure ' || p_pa_request_rec.tenure,2);
1721: hr_utility.set_location('old ann ind ' || p_asg_sf52.annuitant_indicator,2);
1722:
1723:
1724: If p_pa_request_rec.tenure is not null then
1725: If P_pa_request_rec.Tenure <>
1723:
1724: If p_pa_request_rec.tenure is not null then
1725: If P_pa_request_rec.Tenure <>
1726: nvl(p_asg_sf52.tenure,hr_api.g_varchar2) then
1727: hr_utility.set_location(l_proc,25);
1728: p_asg_sf52.asg_sf52_flag := 'Y';
1729: P_Asg_Sf52.Tenure := P_pa_request_rec.Tenure ;
1730: End if;
1731: End if;
1729: P_Asg_Sf52.Tenure := P_pa_request_rec.Tenure ;
1730: End if;
1731: End if;
1732: --
1733: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,3);
1734:
1735: If p_pa_request_rec.annuitant_indicator is not null then
1736: If P_pa_request_rec.Annuitant_Indicator <>
1737: nvl(p_asg_sf52.annuitant_indicator,hr_api.g_varchar2)then
1734:
1735: If p_pa_request_rec.annuitant_indicator is not null then
1736: If P_pa_request_rec.Annuitant_Indicator <>
1737: nvl(p_asg_sf52.annuitant_indicator,hr_api.g_varchar2)then
1738: hr_utility.set_location(l_proc,30);
1739: p_asg_sf52.asg_sf52_flag := 'Y';
1740: P_Asg_Sf52.Annuitant_Indicator := P_pa_request_rec.Annuitant_Indicator;
1741: End if;
1742: End if;
1740: P_Asg_Sf52.Annuitant_Indicator := P_pa_request_rec.Annuitant_Indicator;
1741: End if;
1742: End if;
1743: --
1744: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,4);
1745:
1746: If p_pa_request_rec.pay_rate_determinant is not null then
1747: If P_pa_request_rec.Pay_Rate_Determinant<>
1748: nvl(p_asg_sf52.pay_rate_determinant,hr_api.g_varchar2) then
1745:
1746: If p_pa_request_rec.pay_rate_determinant is not null then
1747: If P_pa_request_rec.Pay_Rate_Determinant<>
1748: nvl(p_asg_sf52.pay_rate_determinant,hr_api.g_varchar2) then
1749: hr_utility.set_location(l_proc,35);
1750: p_asg_sf52.asg_sf52_flag := 'Y';
1751: p_Asg_Sf52.Pay_Rate_Determinant := P_pa_request_rec.Pay_Rate_Determinant;
1752: End if;
1753: End if;
1750: p_asg_sf52.asg_sf52_flag := 'Y';
1751: p_Asg_Sf52.Pay_Rate_Determinant := P_pa_request_rec.Pay_Rate_Determinant;
1752: End if;
1753: End if;
1754: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,5);
1755: End if;
1756:
1757: If nvl(P_pa_request_rec.work_schedule,hr_api.g_varchar2) <>
1758: nvl(p_asg_sf52.work_schedule,hr_api.g_varchar2) then
1755: End if;
1756:
1757: If nvl(P_pa_request_rec.work_schedule,hr_api.g_varchar2) <>
1758: nvl(p_asg_sf52.work_schedule,hr_api.g_varchar2) then
1759: hr_utility.set_location(l_proc,35);
1760: p_asg_sf52.asg_sf52_flag := 'Y';
1761: p_Asg_Sf52.work_schedule := P_pa_request_rec.work_schedule;
1762: End if;
1763:
1760: p_asg_sf52.asg_sf52_flag := 'Y';
1761: p_Asg_Sf52.work_schedule := P_pa_request_rec.work_schedule;
1762: End if;
1763:
1764: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,6);
1765:
1766: If nvl(P_pa_request_rec.part_time_hours,hr_api.g_number) <>
1767: nvl(p_asg_sf52.part_time_hours,hr_api.g_number) then
1768: hr_utility.set_location(l_proc,35);
1764: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,6);
1765:
1766: If nvl(P_pa_request_rec.part_time_hours,hr_api.g_number) <>
1767: nvl(p_asg_sf52.part_time_hours,hr_api.g_number) then
1768: hr_utility.set_location(l_proc,35);
1769: p_asg_sf52.asg_sf52_flag := 'Y';
1770: p_Asg_Sf52.part_time_hours := P_pa_request_rec.part_time_hours;
1771: End if;
1772: -- 809503
1776: p_asg_sf52.asg_sf52_flag := 'Y';
1777: END IF;
1778: end loop;
1779:
1780: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,6);
1781: If p_pa_request_rec.to_pay_table_identifier is not null then
1782: If P_pa_request_rec.to_pay_table_identifier <>
1783: nvl(p_asg_sf52.calc_pay_table,hr_api.g_number)then
1784: hr_utility.set_location(l_proc,30);
1780: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,6);
1781: If p_pa_request_rec.to_pay_table_identifier is not null then
1782: If P_pa_request_rec.to_pay_table_identifier <>
1783: nvl(p_asg_sf52.calc_pay_table,hr_api.g_number)then
1784: hr_utility.set_location(l_proc,30);
1785: p_asg_sf52.asg_sf52_flag := 'Y';
1786: P_Asg_Sf52.calc_pay_table := P_pa_request_rec.to_pay_table_identifier;
1787: End if;
1788: End if;
1795: p_asg_sf52.asg_sf52_flag := 'Y';
1796: P_Asg_Sf52.calc_pay_table := l_calc_table_id;
1797: END IF;
1798: -- 6881863
1799: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,7);
1800:
1801:
1802:
1803: --
1815: If P_pa_request_rec.Citizenship is not null or
1816: P_pa_request_rec.Veterans_Preference is not null or
1817: P_pa_request_rec.Veterans_Pref_for_rif is not null or
1818: P_pa_request_rec.Veterans_Status is not null then
1819: hr_utility.set_location(l_proc,55);
1820: --
1821: --
1822: If p_pa_request_rec.citizenship is not null then
1823: If p_pa_request_rec.Citizenship <> nvl(p_per_sf52.citizenship,hr_api.g_varchar2) then
1820: --
1821: --
1822: If p_pa_request_rec.citizenship is not null then
1823: If p_pa_request_rec.Citizenship <> nvl(p_per_sf52.citizenship,hr_api.g_varchar2) then
1824: hr_utility.set_location(l_proc,65);
1825: P_Per_sf52.Per_Sf52_Flag := 'Y';
1826: P_Per_sf52.Citizenship := P_pa_request_rec.Citizenship;
1827: End if;
1828: End if;
1829: --
1830: If p_pa_request_rec.veterans_preference is not null then
1831: If P_pa_request_rec.Veterans_Preference <>
1832: nvl(p_per_sf52.veterans_preference,hr_api.g_varchar2) then
1833: hr_utility.set_location(l_proc,70);
1834: P_Per_sf52.Per_Sf52_Flag := 'Y';
1835: P_Per_sf52.Veterans_Preference := P_pa_request_rec.Veterans_Preference;
1836: End if;
1837: End if;
1838:
1839: If p_pa_request_rec.veterans_pref_for_rif is not null then
1840: If P_pa_request_rec.Veterans_Pref_for_rif <>
1841: nvl(p_per_sf52.veterans_preference_for_rif,hr_api.g_varchar2) then
1842: hr_utility.set_location(l_proc,75);
1843: P_Per_sf52.Per_Sf52_Flag := 'Y';
1844: P_Per_sf52.Veterans_Preference_For_Rif := P_pa_request_rec.Veterans_Pref_for_rif;
1845: End if;
1846: End if;
1847:
1848: If p_pa_request_rec.veterans_status is not null then
1849: If P_pa_request_rec.Veterans_Status <>
1850: nvl(p_per_sf52.veterans_status,hr_api.g_varchar2)then
1851: hr_utility.set_location(l_proc,80);
1852: P_Per_sf52.Per_Sf52_Flag := 'Y';
1853: P_Per_sf52.Veterans_Status := P_pa_request_rec.Veterans_Status;
1854: End if;
1855: End if;
1861: -- per_scd extra info
1862: -- **********************
1863:
1864: If p_pa_request_rec.service_comp_date is not null then
1865: hr_utility.set_location(l_proc,85);
1866:
1867: hr_utility.set_location(l_proc,90);
1868: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)
1869: <> nvl(p_per_scd_info.scd_leave,fnd_date.date_to_canonical(hr_api.g_date)) then
1863:
1864: If p_pa_request_rec.service_comp_date is not null then
1865: hr_utility.set_location(l_proc,85);
1866:
1867: hr_utility.set_location(l_proc,90);
1868: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)
1869: <> nvl(p_per_scd_info.scd_leave,fnd_date.date_to_canonical(hr_api.g_date)) then
1870: hr_utility.set_location(l_proc,95);
1871: p_per_scd_info.scd_leave := fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date);
1866:
1867: hr_utility.set_location(l_proc,90);
1868: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)
1869: <> nvl(p_per_scd_info.scd_leave,fnd_date.date_to_canonical(hr_api.g_date)) then
1870: hr_utility.set_location(l_proc,95);
1871: p_per_scd_info.scd_leave := fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date);
1872: p_per_scd_info.per_scd_info_flag := 'Y';
1873: End if;
1874: End if;
1880: -- **********************
1881: --
1882: -- JH Add part time Hours
1883: /*if p_pa_request_rec.noa_family_code = 'REALIGNMENT' then
1884: hr_utility.set_location('Inside PRUP realign check'||p_pa_request_rec.noa_family_code,12345);
1885: for c_ei_rec in c_pa_request_extra_info('GHR_US_PAR_REALIGNMENT') loop
1886: If c_ei_rec.rei_information4 is not null then
1887: l_payroll_office_id := c_ei_rec.rei_information4;
1888: end if;
1889: If c_ei_rec.rei_information8 is not null then
1890: l_pos_org := c_ei_rec.rei_information8;
1891: end if;
1892: end loop;
1893: hr_utility.set_location('Inside PRUP payroll check'||l_payroll_office_id,12345);
1894: p_pos_grp1.payroll_office_id := l_payroll_office_id;
1895:
1896: hr_utility.set_location('Inside PRUP pos org check'||l_pos_org,12345);
1897: p_pos_grp1.positions_organization := l_pos_org;
1892: end loop;
1893: hr_utility.set_location('Inside PRUP payroll check'||l_payroll_office_id,12345);
1894: p_pos_grp1.payroll_office_id := l_payroll_office_id;
1895:
1896: hr_utility.set_location('Inside PRUP pos org check'||l_pos_org,12345);
1897: p_pos_grp1.positions_organization := l_pos_org;
1898: end if;*/
1899:
1900: If P_pa_request_rec.to_Occ_Code is not null or
1903: P_pa_request_rec.Functional_Class is not null or
1904: P_pa_request_rec.FLSA_Category is not null or
1905: P_pa_request_rec.Supervisory_Status is not null or
1906: P_pa_request_rec.part_time_hours is not null then
1907: hr_utility.set_location(l_proc,95);
1908: --
1909: --
1910: -- Bug 3226555 Commented below code as they can never be equal. It was unnecessarily inserting a
1911: -- row into the history for the table PER_POSITIONS_EXTRA_INFO and thereby making the Position
1912: -- status as invalid when cancellation to any action was done.
1913: /* If p_pa_request_rec.to_occ_code is not null then
1914: If P_pa_request_rec.to_Occ_Code <>
1915: nvl(p_pos_grp1.occupation_category_code,hr_api.g_varchar2) then
1916: hr_utility.set_location(l_proc,105);
1917: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1918: P_Pos_grp1.Occupation_Category_Code := P_pa_request_rec.to_Occ_Code;
1919: End if;
1920: End if; */
1921:
1922: If p_pa_request_rec.bargaining_unit_status is not null then
1923: If P_pa_request_rec.Bargaining_Unit_Status <>
1924: nvl(p_pos_grp1.bargaining_unit_status,hr_api.g_varchar2) then
1925: hr_utility.set_location(l_proc,110);
1926: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1927: P_Pos_grp1.Bargaining_Unit_Status := P_pa_request_rec.Bargaining_Unit_Status;
1928: End if;
1929: End if;
1932: -- Bugs 773851, 773795
1933: If p_pa_request_rec.work_schedule is not null then
1934: If P_pa_request_rec.Work_Schedule <>
1935: nvl(p_pos_grp1.work_schedule,hr_api.g_varchar2) then
1936: hr_utility.set_location(l_proc,115);
1937: hr_utility.set_location('JH Rec WS = ' || P_pa_request_rec.work_schedule,115);
1938: hr_utility.set_location('JH Posn Grp1 WS = ' || p_pos_grp1.work_schedule,115);
1939: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1940: P_Pos_grp1.Work_Schedule := P_pa_request_rec.Work_Schedule;
1933: If p_pa_request_rec.work_schedule is not null then
1934: If P_pa_request_rec.Work_Schedule <>
1935: nvl(p_pos_grp1.work_schedule,hr_api.g_varchar2) then
1936: hr_utility.set_location(l_proc,115);
1937: hr_utility.set_location('JH Rec WS = ' || P_pa_request_rec.work_schedule,115);
1938: hr_utility.set_location('JH Posn Grp1 WS = ' || p_pos_grp1.work_schedule,115);
1939: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1940: P_Pos_grp1.Work_Schedule := P_pa_request_rec.Work_Schedule;
1941: hr_utility.set_location('JH Update WS = ' || p_pos_grp1.work_schedule,115);
1934: If P_pa_request_rec.Work_Schedule <>
1935: nvl(p_pos_grp1.work_schedule,hr_api.g_varchar2) then
1936: hr_utility.set_location(l_proc,115);
1937: hr_utility.set_location('JH Rec WS = ' || P_pa_request_rec.work_schedule,115);
1938: hr_utility.set_location('JH Posn Grp1 WS = ' || p_pos_grp1.work_schedule,115);
1939: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1940: P_Pos_grp1.Work_Schedule := P_pa_request_rec.Work_Schedule;
1941: hr_utility.set_location('JH Update WS = ' || p_pos_grp1.work_schedule,115);
1942: End if;
1937: hr_utility.set_location('JH Rec WS = ' || P_pa_request_rec.work_schedule,115);
1938: hr_utility.set_location('JH Posn Grp1 WS = ' || p_pos_grp1.work_schedule,115);
1939: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1940: P_Pos_grp1.Work_Schedule := P_pa_request_rec.Work_Schedule;
1941: hr_utility.set_location('JH Update WS = ' || p_pos_grp1.work_schedule,115);
1942: End if;
1943: End if;
1944:
1945: -- JH Hard coded to pass null if WS is F, G, B, I, J.
1945: -- JH Hard coded to pass null if WS is F, G, B, I, J.
1946: If p_pa_request_rec.part_time_hours is not null then
1947: If P_pa_request_rec.part_time_hours <>
1948: nvl(p_pos_grp1.part_time_hours,hr_api.g_number) then
1949: hr_utility.set_location(l_proc,117);
1950: hr_utility.set_location('JH Rec PTH = ' || P_pa_request_rec.part_time_hours,117);
1951: hr_utility.set_location('JH Posn Grp1 PTH = ' || p_pos_grp1.part_time_hours,117);
1952: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1953: P_Pos_grp1.part_time_hours := P_pa_request_rec.part_time_hours;
1946: If p_pa_request_rec.part_time_hours is not null then
1947: If P_pa_request_rec.part_time_hours <>
1948: nvl(p_pos_grp1.part_time_hours,hr_api.g_number) then
1949: hr_utility.set_location(l_proc,117);
1950: hr_utility.set_location('JH Rec PTH = ' || P_pa_request_rec.part_time_hours,117);
1951: hr_utility.set_location('JH Posn Grp1 PTH = ' || p_pos_grp1.part_time_hours,117);
1952: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1953: P_Pos_grp1.part_time_hours := P_pa_request_rec.part_time_hours;
1954: hr_utility.set_location('JH Update PTH = ' || p_pos_grp1.part_time_hours,117);
1947: If P_pa_request_rec.part_time_hours <>
1948: nvl(p_pos_grp1.part_time_hours,hr_api.g_number) then
1949: hr_utility.set_location(l_proc,117);
1950: hr_utility.set_location('JH Rec PTH = ' || P_pa_request_rec.part_time_hours,117);
1951: hr_utility.set_location('JH Posn Grp1 PTH = ' || p_pos_grp1.part_time_hours,117);
1952: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1953: P_Pos_grp1.part_time_hours := P_pa_request_rec.part_time_hours;
1954: hr_utility.set_location('JH Update PTH = ' || p_pos_grp1.part_time_hours,117);
1955: End if;
1950: hr_utility.set_location('JH Rec PTH = ' || P_pa_request_rec.part_time_hours,117);
1951: hr_utility.set_location('JH Posn Grp1 PTH = ' || p_pos_grp1.part_time_hours,117);
1952: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1953: P_Pos_grp1.part_time_hours := P_pa_request_rec.part_time_hours;
1954: hr_utility.set_location('JH Update PTH = ' || p_pos_grp1.part_time_hours,117);
1955: End if;
1956: Elsif P_Pos_grp1.Work_Schedule in ('F', 'G', 'B', 'I', 'J') Then
1957: P_Pos_grp1.part_time_hours := null;
1958: End if;
1960:
1961: If p_pa_request_rec.functional_class is not null then
1962: If P_pa_request_rec.Functional_Class <>
1963: nvl(p_pos_grp1.functional_class,hr_api.g_varchar2) then
1964: hr_utility.set_location(l_proc,120);
1965: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1966: P_Pos_grp1.Functional_Class := P_pa_request_rec.Functional_Class;
1967: End if;
1968: End if;
1969:
1970: If p_pa_request_rec.flsa_category is not null then
1971: If P_pa_request_rec.FLSA_Category <>
1972: nvl(p_pos_grp1.flsa_category,hr_api.g_varchar2) then
1973: hr_utility.set_location(l_proc,125);
1974: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1975: P_Pos_grp1.FLSA_Category := P_pa_request_rec.FLSA_Category;
1976: End if;
1977: End if;
1978:
1979: If p_pa_request_rec.supervisory_status is not null then
1980: If P_pa_request_rec.Supervisory_Status <>
1981: nvl(p_pos_grp1.supervisory_status,hr_api.g_varchar2) then
1982: hr_utility.set_location(l_proc,130);
1983: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1984: P_Pos_grp1.Supervisory_Status := P_pa_request_rec.Supervisory_Status;
1985: End if;
1986: End if;
1995: If P_pa_request_rec.Appropriation_Code1 is not null or
1996: P_pa_request_rec.Appropriation_Code2 is not null or
1997: p_pa_request_rec.position_occupied is not null then --*
1998: --
1999: hr_utility.set_location(l_proc,135);
2000: --
2001: If p_pa_request_rec.position_occupied is not null then
2002: If p_pa_request_rec.position_occupied <> nvl(p_pos_grp2.position_occupied,hr_api.g_varchar2) then
2003: hr_utility.set_location(l_proc,145);
1999: hr_utility.set_location(l_proc,135);
2000: --
2001: If p_pa_request_rec.position_occupied is not null then
2002: If p_pa_request_rec.position_occupied <> nvl(p_pos_grp2.position_occupied,hr_api.g_varchar2) then
2003: hr_utility.set_location(l_proc,145);
2004: P_Pos_grp2.Pos_grp2_flag := 'Y';
2005: p_pos_grp2.position_occupied := p_pa_request_rec.position_occupied;
2006: End if;
2007: End if;
2007: End if;
2008:
2009: If p_pa_request_rec.appropriation_code1 is not null then
2010: If P_pa_request_rec.Appropriation_Code1 <> nvl(p_pos_grp2.appropriation_code1,hr_api.g_varchar2) then
2011: hr_utility.set_location(l_proc,150);
2012: P_Pos_grp2.Pos_grp2_flag := 'Y';
2013: P_Pos_grp2.Appropriation_Code1 := P_pa_request_rec.Appropriation_Code1;
2014: End if;
2015: End if;
2016:
2017: --
2018: If p_pa_request_rec.appropriation_code2 is not null then
2019: If p_pa_request_rec.Appropriation_Code2 <> nvl(p_pos_grp2.appropriation_code2,hr_api.g_varchar2) then
2020: hr_utility.set_location(l_proc,155);
2021: P_Pos_grp2.Pos_grp2_flag := 'Y';
2022: P_Pos_grp2.Appropriation_Code2:= P_pa_request_rec.Appropriation_Code2;
2023: End if;
2024: End if;
2041: -- Recruitment Bonus
2042: -- *****************
2043: --
2044: If nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) = '815' then
2045: hr_utility.set_location(l_proc,165);
2046: p_recruitment_bonus.p_recruitment_bonus := p_pa_request_rec.award_amount;
2047: p_recruitment_bonus.p_percentage := p_pa_request_rec.award_percentage;
2048: END IF;
2049: --
2053: -- Relocation Bonus
2054: -- ***************
2055: --
2056: If nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) = '816' then
2057: hr_utility.set_location(l_proc,170);
2058: p_relocation_bonus.p_relocation_bonus := p_pa_request_rec.award_amount;
2059: p_relocation_bonus.p_percentage := p_pa_request_rec.award_percentage;
2060: End if;
2061: --
2064: -- Student Loan Repayment
2065: -- ***************
2066: --
2067: If nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) = '817' then
2068: hr_utility.set_location(l_proc,170);
2069: l_student_loan_repay.p_amount := p_pa_request_rec.award_amount;
2070: p_student_loan_repay := l_student_loan_repay;
2071: End if;
2072: --
2277: Procedure appt_info is
2278: l_proc varchar2(70) := 'Process_non_sf52 - App1';
2279: --
2280: Begin
2281: hr_utility.set_location('Entering ' ||l_proc,5);
2282: hr_utility.set_location('before retr info in appt-info',1);
2283:
2284: -- If a CORRECTION action is being performed, then, we cannot force the User to
2285: -- enter the Mandatory Items on the SF52, as it might already exist in the Core
2278: l_proc varchar2(70) := 'Process_non_sf52 - App1';
2279: --
2280: Begin
2281: hr_utility.set_location('Entering ' ||l_proc,5);
2282: hr_utility.set_location('before retr info in appt-info',1);
2283:
2284: -- If a CORRECTION action is being performed, then, we cannot force the User to
2285: -- enter the Mandatory Items on the SF52, as it might already exist in the Core
2286: -- Extra Information. In such cases , fetch the value from the CORE Extra information,
2359: l_pa_request_ei_rec.rei_information19,
2360: p_per_separate_retire.per_sep_retire_flag, 'Y');
2361:
2362: --bug 4443968
2363: hr_utility.set_location('Creditable service' ||l_pa_request_ei_rec.rei_information23,0000);
2364: hr_utility.set_location('Populate flag' ||p_per_scd_info.per_scd_info_flag,3333);
2365:
2366: set_extra_info (p_per_scd_info.scd_creditable_svc_annl_leave,
2367: l_pa_request_ei_rec.rei_information23,
2360: p_per_separate_retire.per_sep_retire_flag, 'Y');
2361:
2362: --bug 4443968
2363: hr_utility.set_location('Creditable service' ||l_pa_request_ei_rec.rei_information23,0000);
2364: hr_utility.set_location('Populate flag' ||p_per_scd_info.per_scd_info_flag,3333);
2365:
2366: set_extra_info (p_per_scd_info.scd_creditable_svc_annl_leave,
2367: l_pa_request_ei_rec.rei_information23,
2368: p_per_scd_info.per_scd_info_flag, 'Y');
2365:
2366: set_extra_info (p_per_scd_info.scd_creditable_svc_annl_leave,
2367: l_pa_request_ei_rec.rei_information23,
2368: p_per_scd_info.per_scd_info_flag, 'Y');
2369: hr_utility.set_location('Per Cred leave' ||p_per_scd_info.scd_creditable_svc_annl_leave,4444);
2370: --
2371: --
2372: hr_utility.set_location('Leaving ' || l_proc,20);
2373:
2368: p_per_scd_info.per_scd_info_flag, 'Y');
2369: hr_utility.set_location('Per Cred leave' ||p_per_scd_info.scd_creditable_svc_annl_leave,4444);
2370: --
2371: --
2372: hr_utility.set_location('Leaving ' || l_proc,20);
2373:
2374: End appt_info;
2375: --
2376: --
2377: Procedure appt_transfer is
2378: l_proc varchar2(70) := 'non_sf52_extra_info - app_3 ';
2379:
2380: Begin
2381: hr_utility.set_location('Entering ' || l_proc,5);
2382: --
2383: --
2384: If l_session.noa_id_correct is not null then
2385: set_extra_info(p_per_group1.agency_code_transfer_from ,
2410: --Bug# 4941984(AFHR2)
2411: End if;
2412: p_per_group1.per_group1_flag := 'Y';
2413: End if;
2414: hr_utility.set_location('cOre CMS ' || p_per_uniformed_services.creditable_military_service,1);
2415: hr_utility.set_location('REI 7 ' || l_pa_request_ei_rec.rei_information7,2);
2416: hr_utility.set_location('REI CMS ' || l_pa_request_ei_rec.rei_information6,2);
2417: set_extra_info(p_per_uniformed_services.creditable_military_service,
2418: l_pa_request_ei_rec.rei_information6,
2411: End if;
2412: p_per_group1.per_group1_flag := 'Y';
2413: End if;
2414: hr_utility.set_location('cOre CMS ' || p_per_uniformed_services.creditable_military_service,1);
2415: hr_utility.set_location('REI 7 ' || l_pa_request_ei_rec.rei_information7,2);
2416: hr_utility.set_location('REI CMS ' || l_pa_request_ei_rec.rei_information6,2);
2417: set_extra_info(p_per_uniformed_services.creditable_military_service,
2418: l_pa_request_ei_rec.rei_information6,
2419: p_per_uniformed_services.per_uniformed_services_flag);
2412: p_per_group1.per_group1_flag := 'Y';
2413: End if;
2414: hr_utility.set_location('cOre CMS ' || p_per_uniformed_services.creditable_military_service,1);
2415: hr_utility.set_location('REI 7 ' || l_pa_request_ei_rec.rei_information7,2);
2416: hr_utility.set_location('REI CMS ' || l_pa_request_ei_rec.rei_information6,2);
2417: set_extra_info(p_per_uniformed_services.creditable_military_service,
2418: l_pa_request_ei_rec.rei_information6,
2419: p_per_uniformed_services.per_uniformed_services_flag);
2420: hr_utility.set_location('agency code trans from ' || p_per_group1.agency_code_transfer_from,1);
2416: hr_utility.set_location('REI CMS ' || l_pa_request_ei_rec.rei_information6,2);
2417: set_extra_info(p_per_uniformed_services.creditable_military_service,
2418: l_pa_request_ei_rec.rei_information6,
2419: p_per_uniformed_services.per_uniformed_services_flag);
2420: hr_utility.set_location('agency code trans from ' || p_per_group1.agency_code_transfer_from,1);
2421: hr_utility.set_location('CMS ' || p_per_uniformed_services.creditable_military_service,2);
2422: set_extra_info(p_asg_non_sf52.Date_Arr_Personnel_office,
2423: l_pa_request_ei_rec.rei_information7, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2424: set_extra_info(p_within_grade_increase.p_date_wgi_due,
2417: set_extra_info(p_per_uniformed_services.creditable_military_service,
2418: l_pa_request_ei_rec.rei_information6,
2419: p_per_uniformed_services.per_uniformed_services_flag);
2420: hr_utility.set_location('agency code trans from ' || p_per_group1.agency_code_transfer_from,1);
2421: hr_utility.set_location('CMS ' || p_per_uniformed_services.creditable_military_service,2);
2422: set_extra_info(p_asg_non_sf52.Date_Arr_Personnel_office,
2423: l_pa_request_ei_rec.rei_information7, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2424: set_extra_info(p_within_grade_increase.p_date_wgi_due,
2425: l_pa_request_ei_rec.rei_information8, p_within_grade_increase.p_wgi_flag, 'N');
2451: l_pa_request_ei_rec.rei_information25, p_per_scd_info.per_scd_info_flag, 'Y');
2452:
2453:
2454:
2455: hr_utility.set_location('Leaving ' ||l_proc,20);
2456:
2457: End appt_transfer;
2458: --
2459:
2510: PROCEDURE chg_data_elm is
2511: l_proc varchar2(70) := 'non_sf52_extra - chg_data_elm';
2512: --
2513: Begin
2514: hr_utility.set_location('Entering ' || l_proc,5);
2515:
2516: -- Bug#4126188 begin
2517: IF NVL(l_pa_request_ei_rec.rei_information3,hr_api.g_varchar2) <>
2518: NVL(p_pos_grp1.personnel_office_id,hr_api.g_varchar2) THEN
2521: END IF;
2522: -- Bug#4126188 End
2523: set_extra_info(p_pos_grp1.personnel_office_id,
2524: l_pa_request_ei_rec.rei_information3, p_pos_grp1.pos_grp1_flag, 'Y');
2525: hr_utility.set_location('Leaving '||l_proc,20);
2526:
2527: End chg_data_elm;
2528: --
2529: --
2530: Procedure chg_sched_hours is
2531: l_proc varchar2(70) := 'non_sf52_extra - chg_hours';
2532:
2533: Begin
2534: hr_utility.set_location('Entering ' ||l_proc,5);
2535: set_extra_info(p_per_probations.date_prob_trial_period_begin ,
2536: l_pa_request_ei_rec.rei_information3,p_per_probations.per_probation_flag);
2537: set_extra_info(p_per_probations.date_prob_trial_period_ends ,
2538: l_pa_request_ei_rec.rei_information4,p_per_probations.per_probation_flag);
2552: p_date_effective => p_pa_request_rec.effective_date,
2553: p_screen_entry_value => p_within_grade_increase.p_last_equi_incr);
2554: END IF;
2555: --End added by deenath to fix bug 4542401
2556: hr_utility.set_location('Leaving ' || l_proc,20);
2557:
2558: End chg_sched_hours;
2559: --
2560: --
2561: Procedure chg_ret_plan is
2562: l_proc varchar2(70) := 'non_sf52_extra_info - chg_ret_plan';
2563:
2564: Begin
2565: hr_utility.set_location('Entering ' ||l_proc,5);
2566: set_extra_info(p_per_uniformed_services.creditable_military_service,
2567: l_pa_request_ei_rec.rei_information3,
2568: p_per_uniformed_services.per_uniformed_services_flag, 'Y');
2569: -- Start Bug # 1518650
2575: p_per_separate_Retire.per_sep_Retire_flag, 'Y');
2576: set_extra_info(p_per_separate_retire.prev_retirement_coverage,
2577: l_pa_request_ei_rec.rei_information6,
2578: p_per_separate_Retire.per_sep_Retire_flag, 'Y');
2579: hr_utility.set_location('Leaving ' || l_proc,20);
2580:
2581: END chg_ret_plan;
2582: --
2583: --
2584:
2585: PROCEDURE chg_scd is
2586: l_proc varchar2(70) := 'non_sf52_extra - chg_scd';
2587: Begin
2588: hr_utility.set_location('Entering ' ||l_proc,5);
2589: set_extra_info(p_per_scd_info.scd_rif,l_pa_request_ei_rec.rei_information3,
2590: p_per_scd_info.per_scd_info_flag, 'Y');
2591: set_extra_info(p_per_scd_info.scd_civilian,l_pa_request_ei_rec.rei_information4,
2592: p_per_scd_info.per_scd_info_flag, 'Y');
2617: set_extra_info (p_per_scd_info.scd_creditable_svc_annl_leave,l_pa_request_ei_rec.rei_information12,
2618: p_per_scd_info.per_scd_info_flag, 'Y');
2619:
2620:
2621: hr_utility.set_location('Leaving ' ||l_proc,10);
2622: End chg_scd;
2623: --
2624: --
2625: Procedure conv_appt is
2624: --
2625: Procedure conv_appt is
2626: l_proc varchar2(70) := 'non_sf52_extra - conv_1';
2627: Begin
2628: hr_utility.set_location('Entering ' ||l_proc,5);
2629: If l_session.noa_id_correct is not null then
2630: set_extra_info(p_per_group1.appointment_type,
2631: l_pa_request_ei_rec.rei_information3,p_per_group1.per_group1_flag);
2632: set_extra_info(p_per_group1.org_appointment_auth_code1,
2721: -- set_extra_info(p_within_grade_increase.p_date_wgi_due ,
2722: -- l_pa_request_ei_rec.rei_information6,p_within_grade_increase.p_wgi_flag);
2723:
2724: */
2725: hr_utility.set_location('Leaving ' ||l_proc,10);
2726:
2727: END conv_appt;
2728: --
2729: --
2735: --
2736: --
2737: -- Updating the record groups with NON SF52
2738: --
2739: hr_utility.set_location('Entering ' ||l_proc,5);
2740: If l_session.noa_id_correct is not null then
2741: set_extra_info(p_within_grade_increase.p_date_wgi_due,
2742: l_pa_request_ei_rec.rei_information3,p_within_grade_increase.p_wgi_flag);
2743: set_extra_info(p_within_grade_increase.p_date_wgi_postpone_effective,
2747: p_within_grade_increase.p_date_wgi_postpone_effective := l_pa_request_ei_rec.rei_information4;
2748: p_within_grade_increase.p_wgi_flag := 'Y';
2749: End if;
2750:
2751: hr_utility.set_location('Leaving ' ||l_proc,10);
2752:
2753: End denial_wgi;
2754: --
2755: --
2760:
2761: --
2762: -- Updating the record groups with NON SF52
2763: --
2764: hr_utility.set_location('Entering ' ||l_proc,5);
2765: set_extra_info(p_asg_nte_dates.assignment_nte,
2766: l_pa_request_ei_rec.rei_information3,p_asg_nte_dates.asg_nte_dates_flag);
2767: set_extra_info(p_within_grade_increase.p_date_wgi_due ,
2768: l_pa_request_ei_rec.rei_information4,p_within_grade_increase.p_wgi_flag);
2772: l_pa_request_ei_rec.rei_information6,p_asg_nte_dates.asg_nte_dates_flag);
2773: set_extra_info(p_asg_nte_dates.suspension_nte ,
2774: l_pa_request_ei_rec.rei_information7,p_asg_nte_dates.asg_nte_dates_flag);
2775: --
2776: hr_utility.set_location('Leaving ' ||l_proc,10);
2777:
2778: End ext_asgn_nte ;
2779: --
2780: --
2781: Procedure posn_chg is
2782: l_proc varchar2(72) := 'non_sf52_extra - posn_chg';
2783:
2784: Begin
2785: hr_utility.set_location('Entering ' ||l_proc,5);
2786: set_extra_info(p_per_retained_grade.date_from ,
2787: l_pa_request_ei_rec.rei_information1,p_per_retained_grade.per_retained_grade_flag);
2788: set_extra_info(p_per_retained_grade.date_to ,
2789: l_pa_request_ei_rec.rei_information2,p_per_retained_grade.per_retained_grade_flag);
2802: -- Begin bug# 4126188
2803: set_extra_info(p_asg_non_sf52.date_arr_personnel_office,
2804: l_pa_request_ei_rec.rei_information15, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2805: -- End bug# 4126188
2806: hr_utility.set_location('Leaving ' ||l_proc,10);
2807:
2808: End posn_chg;
2809: --
2810: -- Begin bug# 4126188
2810: -- Begin bug# 4126188
2811: Procedure rg_posn_chg is
2812: l_proc varchar2(72) := 'non_sf52_extra - rg_posn_chg';
2813: Begin
2814: hr_utility.set_location('Entering ' ||l_proc,5);
2815: set_extra_info(p_asg_non_sf52.date_arr_personnel_office,
2816: l_pa_request_ei_rec.rei_information15, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2817: hr_utility.set_location('Leaving ' ||l_proc,10);
2818: End rg_posn_chg;
2813: Begin
2814: hr_utility.set_location('Entering ' ||l_proc,5);
2815: set_extra_info(p_asg_non_sf52.date_arr_personnel_office,
2816: l_pa_request_ei_rec.rei_information15, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2817: hr_utility.set_location('Leaving ' ||l_proc,10);
2818: End rg_posn_chg;
2819: -- End bug# 4126188
2820:
2821: Procedure salary_change is
2821: Procedure salary_change is
2822: l_proc varchar2(72) := 'non_sf52_extra - salary change';
2823:
2824: Begin
2825: hr_utility.set_location('Entering ' ||l_proc,5);
2826: If l_session.noa_id_correct is not null then
2827: set_extra_info(p_within_grade_increase.p_date_wgi_postpone_effective,
2828: l_pa_request_ei_rec.rei_information3,p_within_grade_increase.p_wgi_flag);
2829:
2857: PROCEDURE realign is
2858: l_proc varchar2(70) := 'non_sf52_extra - realign';
2859:
2860: Begin
2861: hr_utility.set_location('Entering ' ||l_proc,5);
2862: set_extra_info(p_asg_non_sf52.Date_Arr_Personnel_office ,
2863: l_pa_request_ei_rec.rei_information3,p_asg_non_sf52.asg_non_sf52_flag);
2864:
2865: set_extra_info(p_pos_grp1.payroll_office_id ,
2890: if l_pa_request_ei_rec.rei_information10 is not null then
2891: p_pa_request_rec.agency_code := l_pa_request_ei_rec.rei_information10;
2892: end If;
2893:
2894: hr_utility.set_location('Leaving ' ||l_proc,10);
2895:
2896: End realign ;
2897: --
2898: --
2898: --
2899: Procedure reassign is
2900: l_proc varchar2(70) := 'non_sf52_extra_info - reassign';
2901: Begin
2902: hr_utility.set_location('Entering ' ||l_proc,5);
2903: /* -- Commented - Venkat - Bug # 957209 -- 08/06/1999
2904: set_extra_info(p_asg_non_sf52.key_emer_essential_empl ,
2905: l_pa_request_ei_rec.rei_information3,p_asg_non_sf52.asg_non_sf52_flag);
2906: */
2913: -- Begin Bug#4126188
2914: set_extra_info(p_asg_non_sf52.date_arr_personnel_office,
2915: l_pa_request_ei_rec.rei_information7, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2916: -- End Bug#4126188
2917: hr_utility.set_location('Leaving ' ||l_proc,10);
2918:
2919: End reassign;
2920: --
2921:
2923: l_proc varchar2(70) := 'non_sf52_extra - return_to_duty';
2924:
2925: Begin
2926:
2927: hr_utility.set_location('Entering ' ||l_proc,5);
2928: set_extra_info(p_per_uniformed_services.creditable_military_service ,
2929: l_pa_request_ei_rec.rei_information3,
2930: p_per_uniformed_services.per_uniformed_services_flag, 'Y');
2931: set_extra_info(p_within_grade_increase.p_date_wgi_due ,
2937: set_extra_info(p_asg_non_sf52.parttime_indicator,
2938: l_pa_request_ei_rec.rei_information7,p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2939: set_extra_info(p_per_group1.type_of_employment,
2940: l_pa_request_ei_rec.rei_information8,p_per_group1.per_group1_flag, 'Y'); -- Bug 3966783
2941: hr_utility.set_location('Leaving ' ||l_proc,10);
2942:
2943: End return_to_duty;
2944: --
2945: --
2947: l_proc varchar2(70) := 'non_sf52_extra - separate3';
2948:
2949: Begin
2950:
2951: hr_utility.set_location('Entering ' ||l_proc,5);
2952: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
2953: p_per_separate_retire.agency_code_transfer_to ,10);
2954: set_extra_info(p_per_separate_retire.agency_code_transfer_to,
2955: l_pa_request_ei_rec.rei_information3,p_per_separate_Retire.per_sep_Retire_flag);
2948:
2949: Begin
2950:
2951: hr_utility.set_location('Entering ' ||l_proc,5);
2952: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
2953: p_per_separate_retire.agency_code_transfer_to ,10);
2954: set_extra_info(p_per_separate_retire.agency_code_transfer_to,
2955: l_pa_request_ei_rec.rei_information3,p_per_separate_Retire.per_sep_Retire_flag);
2956: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
2952: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
2953: p_per_separate_retire.agency_code_transfer_to ,10);
2954: set_extra_info(p_per_separate_retire.agency_code_transfer_to,
2955: l_pa_request_ei_rec.rei_information3,p_per_separate_Retire.per_sep_Retire_flag);
2956: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
2957: p_per_separate_retire.agency_code_transfer_to ,10);
2958: hr_utility.set_location('Leaving ' ||l_proc,10);
2959:
2960: End separate352 ;
2954: set_extra_info(p_per_separate_retire.agency_code_transfer_to,
2955: l_pa_request_ei_rec.rei_information3,p_per_separate_Retire.per_sep_Retire_flag);
2956: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
2957: p_per_separate_retire.agency_code_transfer_to ,10);
2958: hr_utility.set_location('Leaving ' ||l_proc,10);
2959:
2960: End separate352 ;
2961: --
2962: --
2963: Procedure recruitment_bonus is
2964: l_proc varchar2(70) := 'non_sf52_extra - recruitment_bonus';
2965:
2966: Begin
2967: hr_utility.set_location('Entering ' ||l_proc,5);
2968: If l_session.noa_id_correct is not null then
2969: set_extra_info(p_recruitment_bonus.p_date_recruit_exp,
2970: l_pa_request_ei_rec.rei_information3,p_recruitment_bonus.p_recruitment_bonus_flag);
2971: Else
2970: l_pa_request_ei_rec.rei_information3,p_recruitment_bonus.p_recruitment_bonus_flag);
2971: Else
2972: p_recruitment_bonus.p_date_recruit_exp := l_pa_request_ei_rec.rei_information3 ;
2973: p_recruitment_bonus.p_recruitment_bonus_flag := 'Y';
2974: hr_utility.set_location('Leaving ' ||l_proc,10);
2975: End if;
2976:
2977: End recruitment_bonus;
2978: --
2980: Procedure relocation_bonus is
2981: l_proc varchar2(70) := 'non_sf52_extra - relocation_bonus';
2982:
2983: Begin
2984: hr_utility.set_location('Entering ' ||l_proc,5);
2985: If l_session.noa_id_correct is not null then
2986: set_extra_info(p_relocation_bonus.p_date_reloc_exp,
2987: l_pa_request_ei_rec.rei_information3,p_relocation_bonus.p_relocation_bonus_flag );
2988: Else
2988: Else
2989: p_relocation_bonus.p_date_reloc_exp := l_pa_request_ei_rec.rei_information3;
2990: p_relocation_bonus.p_relocation_bonus_flag := 'Y';
2991: End if;
2992: hr_utility.set_location('Leaving ' ||l_proc,10);
2993:
2994: End relocation_bonus;
2995: --
2996:
3010: -- Bug # 1060184 -- Venkat 03/01/00
3011: p_gov_awards.award_appropriation_code := l_pa_request_ei_rec.rei_information10;
3012: p_gov_awards.date_exemp_award := l_pa_request_ei_rec.rei_information11;
3013:
3014: hr_utility.set_location('date award -pre ' || p_gov_awards.date_award_earned,2);
3015: If p_gov_awards.award_agency is not null or
3016: p_gov_awards.award_type is not null or
3017: p_gov_awards.group_award is not null or
3018: p_gov_awards.tangible_benefit_dollars is not null or
3097: Procedure service_obligation is
3098: l_proc varchar2(70) := 'non_sf52_extra - service_obligation';
3099:
3100: Begin
3101: hr_utility.set_location('Entering ' ||l_proc,5);
3102: If l_session.noa_id_correct is null then
3103: --6510320 Added the if condition of not creating the service obligation entry
3104: --in person EI if all the segments are null
3105: If l_pa_request_ei_rec.rei_information3 is not null or
3109: p_per_service_oblig.service_oblig_start_date := l_pa_request_ei_rec.rei_information4;
3110: p_per_service_oblig.service_oblig_end_date := l_pa_request_ei_rec.rei_information5;
3111: p_per_service_oblig.per_service_oblig_flag := 'Y';
3112: End If;
3113: hr_utility.set_location('Leaving ' ||l_proc,10);
3114: End if;
3115:
3116: End service_obligation;
3117: --
3119: Procedure incentive_retention is
3120: l_proc varchar2(70) := 'non_sf52_extra - incentive_retention';
3121:
3122: Begin
3123: hr_utility.set_location('Entering ' ||l_proc,5);
3124: If l_session.noa_id_correct is not null then
3125: set_extra_info(p_per_group1.retention_inc_review_date ,
3126: l_pa_request_ei_rec.rei_information3,
3127: p_per_group1.per_group1_flag);
3151: p_conduct_performance.pip_extensions := l_pa_request_ei_rec.rei_information13;
3152: p_conduct_performance.pip_length := l_pa_request_ei_rec.rei_information14;
3153: p_conduct_performance.date_reprimand_expires := l_pa_request_ei_rec.rei_information15;
3154:
3155: hr_utility.set_location('non_pay_duty_status ', 20);
3156: -- If atleast one of the above is not null , then set the flag to 'Y'
3157:
3158: If p_conduct_performance.adverse_action_noac is not null or
3159: p_conduct_performance.cause_of_disc_action is not null or
3167: p_conduct_performance.pip_extensions is not null or
3168: p_conduct_performance.pip_length is not null or
3169: p_conduct_performance.date_reprimand_expires is not null then
3170: p_conduct_performance.cond_perf_flag := 'Y';
3171: hr_utility.set_location('non_pay_duty_status ', 25);
3172: End if;
3173:
3174: if l_session.noa_id_correct is not null then
3175: hr_utility.set_location('non_pay_duty_status ', 30);
3171: hr_utility.set_location('non_pay_duty_status ', 25);
3172: End if;
3173:
3174: if l_session.noa_id_correct is not null then
3175: hr_utility.set_location('non_pay_duty_status ', 30);
3176:
3177: ghr_history_fetch.return_special_information
3178: (p_person_id => p_pa_request_rec.person_id,
3179: p_structure_name => 'US Fed Conduct Perf',
3180: p_effective_date => p_pa_request_rec.effective_date,
3181: p_special_info => l_special_info_type
3182: );
3183:
3184: hr_utility.set_location('non_pay_duty_status :person analysis id '||l_special_info_type.person_analysis_id, 31);
3185: hr_utility.set_location('non_pay_duty_status :ovn '||l_special_info_type.object_version_number, 32);
3186: hr_utility.set_location('non_pay_duty_status :segment1 '||l_special_info_type.segment1, 33);
3187: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3188: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3181: p_special_info => l_special_info_type
3182: );
3183:
3184: hr_utility.set_location('non_pay_duty_status :person analysis id '||l_special_info_type.person_analysis_id, 31);
3185: hr_utility.set_location('non_pay_duty_status :ovn '||l_special_info_type.object_version_number, 32);
3186: hr_utility.set_location('non_pay_duty_status :segment1 '||l_special_info_type.segment1, 33);
3187: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3188: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3189: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3182: );
3183:
3184: hr_utility.set_location('non_pay_duty_status :person analysis id '||l_special_info_type.person_analysis_id, 31);
3185: hr_utility.set_location('non_pay_duty_status :ovn '||l_special_info_type.object_version_number, 32);
3186: hr_utility.set_location('non_pay_duty_status :segment1 '||l_special_info_type.segment1, 33);
3187: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3188: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3189: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3190: hr_utility.set_location('non_pay_duty_status :segment5 '||l_special_info_type.segment5, 37);
3183:
3184: hr_utility.set_location('non_pay_duty_status :person analysis id '||l_special_info_type.person_analysis_id, 31);
3185: hr_utility.set_location('non_pay_duty_status :ovn '||l_special_info_type.object_version_number, 32);
3186: hr_utility.set_location('non_pay_duty_status :segment1 '||l_special_info_type.segment1, 33);
3187: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3188: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3189: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3190: hr_utility.set_location('non_pay_duty_status :segment5 '||l_special_info_type.segment5, 37);
3191: hr_utility.set_location('non_pay_duty_status :segment6 '||l_special_info_type.segment6, 38);
3184: hr_utility.set_location('non_pay_duty_status :person analysis id '||l_special_info_type.person_analysis_id, 31);
3185: hr_utility.set_location('non_pay_duty_status :ovn '||l_special_info_type.object_version_number, 32);
3186: hr_utility.set_location('non_pay_duty_status :segment1 '||l_special_info_type.segment1, 33);
3187: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3188: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3189: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3190: hr_utility.set_location('non_pay_duty_status :segment5 '||l_special_info_type.segment5, 37);
3191: hr_utility.set_location('non_pay_duty_status :segment6 '||l_special_info_type.segment6, 38);
3192: hr_utility.set_location('non_pay_duty_status :segment7 '||l_special_info_type.segment7, 39);
3185: hr_utility.set_location('non_pay_duty_status :ovn '||l_special_info_type.object_version_number, 32);
3186: hr_utility.set_location('non_pay_duty_status :segment1 '||l_special_info_type.segment1, 33);
3187: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3188: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3189: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3190: hr_utility.set_location('non_pay_duty_status :segment5 '||l_special_info_type.segment5, 37);
3191: hr_utility.set_location('non_pay_duty_status :segment6 '||l_special_info_type.segment6, 38);
3192: hr_utility.set_location('non_pay_duty_status :segment7 '||l_special_info_type.segment7, 39);
3193:
3186: hr_utility.set_location('non_pay_duty_status :segment1 '||l_special_info_type.segment1, 33);
3187: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3188: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3189: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3190: hr_utility.set_location('non_pay_duty_status :segment5 '||l_special_info_type.segment5, 37);
3191: hr_utility.set_location('non_pay_duty_status :segment6 '||l_special_info_type.segment6, 38);
3192: hr_utility.set_location('non_pay_duty_status :segment7 '||l_special_info_type.segment7, 39);
3193:
3194: p_conduct_performance.person_analysis_id := l_special_info_type.person_analysis_id;
3187: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3188: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3189: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3190: hr_utility.set_location('non_pay_duty_status :segment5 '||l_special_info_type.segment5, 37);
3191: hr_utility.set_location('non_pay_duty_status :segment6 '||l_special_info_type.segment6, 38);
3192: hr_utility.set_location('non_pay_duty_status :segment7 '||l_special_info_type.segment7, 39);
3193:
3194: p_conduct_performance.person_analysis_id := l_special_info_type.person_analysis_id;
3195: p_conduct_performance.object_version_number := l_special_info_type.object_version_number;
3188: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3189: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3190: hr_utility.set_location('non_pay_duty_status :segment5 '||l_special_info_type.segment5, 37);
3191: hr_utility.set_location('non_pay_duty_status :segment6 '||l_special_info_type.segment6, 38);
3192: hr_utility.set_location('non_pay_duty_status :segment7 '||l_special_info_type.segment7, 39);
3193:
3194: p_conduct_performance.person_analysis_id := l_special_info_type.person_analysis_id;
3195: p_conduct_performance.object_version_number := l_special_info_type.object_version_number;
3196: if p_conduct_performance.cause_of_disc_action is null then
3230: p_conduct_performance.adverse_action_noac := l_special_info_type.segment12;
3231: end if;
3232:
3233: end if;
3234: hr_utility.set_location('non_pay_duty_status ', 40);
3235:
3236: End non_pay_duty_status;
3237: --
3238: --
3264: begin
3265: l_request_id := p_request_id;
3266: loop
3267: for c2_rec in c2(l_request_id) loop
3268: hr_utility.set_location('inside fetch extra info id loop',1);
3269: if c2_rec.rei_information3 is not null then
3270: l_extra_info_id := c2_rec.rei_information3;
3271: else
3272: l_request_id := c2_rec.pa_request_id;
3275: if l_extra_info_id is not null then
3276: exit;
3277: end if;
3278: end loop;
3279: hr_utility.set_location('Leaving fetch extra_info_id',1);
3280: return(l_extra_info_id);
3281: end fetch_extra_info_id;
3282: --
3283: --
3301: elsif l_pa_request_ei_rec.rei_information3 is not null then
3302: -- fetch the ovn, set flag to Y
3303: for c1_rec in c1(l_pa_request_ei_rec.rei_information3) loop
3304: p_per_retained_grade.person_extra_info_id := c1_rec.person_extra_info_id;
3305: hr_utility.set_location('RG 866 - set pei id',1);
3306: If l_session.noa_id_correct is null then
3307: p_per_retained_grade.object_version_number := c1_rec.object_version_number;
3308: hr_utility.set_location('non correction -- RG 866',1);
3309: p_per_retained_grade.per_retained_grade_flag := 'Y';
3304: p_per_retained_grade.person_extra_info_id := c1_rec.person_extra_info_id;
3305: hr_utility.set_location('RG 866 - set pei id',1);
3306: If l_session.noa_id_correct is null then
3307: p_per_retained_grade.object_version_number := c1_rec.object_version_number;
3308: hr_utility.set_location('non correction -- RG 866',1);
3309: p_per_retained_grade.per_retained_grade_flag := 'Y';
3310: end if;
3311: end loop;
3312: end if;
3311: end loop;
3312: end if;
3313:
3314:
3315: hr_utility.set_location('leaving par term ret gr',1);
3316:
3317: End term_retained_grade;
3318: --
3319: --
3341: l_proc varchar2(70) := 'non_sf52_extra_info - entitlement';
3342:
3343: Begin
3344: --
3345: hr_utility.set_location('Entering ' ||l_proc,5);
3346: --
3347: p_entitlement.entitlement_code := l_pa_request_ei_rec.rei_information3;
3348: p_entitlement.entitlement_amt_percent := l_pa_request_ei_rec.rei_information4;
3349: --Venkat 05/00 -- Bug# 1140536
3346: --
3347: p_entitlement.entitlement_code := l_pa_request_ei_rec.rei_information3;
3348: p_entitlement.entitlement_amt_percent := l_pa_request_ei_rec.rei_information4;
3349: --Venkat 05/00 -- Bug# 1140536
3350: hr_utility.set_location('entitlement code is '||p_entitlement.entitlement_code ||l_proc,6);
3351: if nvl(p_entitlement.entitlement_code,hr_api.g_varchar2) = '9'
3352: and substr(nvl(p_pa_request_rec.duty_station_code,hr_api.g_varchar2),1,2)
3353: not in ('02','15','AQ','CQ','DQ',
3354: 'FQ','GQ','HQ','JQ','KQ',
3352: and substr(nvl(p_pa_request_rec.duty_station_code,hr_api.g_varchar2),1,2)
3353: not in ('02','15','AQ','CQ','DQ',
3354: 'FQ','GQ','HQ','JQ','KQ',
3355: 'LQ','MQ','RQ','VQ','WQ') then
3356: hr_utility.set_message(8301,'GHR_38030_INV_DS_4_NON_F_COLA');
3357: hr_utility.raise_error;
3358: end if;
3359: if nvl(p_entitlement.entitlement_code,hr_api.g_varchar2) = 'C'
3360: and substr(nvl(p_pa_request_rec.duty_station_code,hr_api.g_varchar2),1,2)
3353: not in ('02','15','AQ','CQ','DQ',
3354: 'FQ','GQ','HQ','JQ','KQ',
3355: 'LQ','MQ','RQ','VQ','WQ') then
3356: hr_utility.set_message(8301,'GHR_38030_INV_DS_4_NON_F_COLA');
3357: hr_utility.raise_error;
3358: end if;
3359: if nvl(p_entitlement.entitlement_code,hr_api.g_varchar2) = 'C'
3360: and substr(nvl(p_pa_request_rec.duty_station_code,hr_api.g_varchar2),1,2)
3361: in ('02','15','AQ','CQ','DQ',
3360: and substr(nvl(p_pa_request_rec.duty_station_code,hr_api.g_varchar2),1,2)
3361: in ('02','15','AQ','CQ','DQ',
3362: 'FQ','GQ','HQ','JQ','KQ',
3363: 'LQ','MQ','RQ','VQ','WQ') then
3364: hr_utility.set_message(8301,'GHR_38032_INV_DS_4_COLA');
3365: hr_utility.raise_error;
3366: end if;
3367: if p_entitlement.entitlement_code is not null or
3368: p_entitlement.entitlement_amt_percent is not null then
3361: in ('02','15','AQ','CQ','DQ',
3362: 'FQ','GQ','HQ','JQ','KQ',
3363: 'LQ','MQ','RQ','VQ','WQ') then
3364: hr_utility.set_message(8301,'GHR_38032_INV_DS_4_COLA');
3365: hr_utility.raise_error;
3366: end if;
3367: if p_entitlement.entitlement_code is not null or
3368: p_entitlement.entitlement_amt_percent is not null then
3369: p_entitlement.entitlement_flag := 'Y';
3388: );
3389: end if;
3390: end if;
3391: --
3392: hr_utility.set_location('Leaving ' ||l_proc,5);
3393: --
3394: END entitlement;
3395: --
3396: --
3397: Procedure for_lang_pay is
3398: l_proc varchar2(70) := 'non_sf52_extra_info - for_lang_pay';
3399: Begin
3400: --
3401: hr_utility.set_location('Entering ' ||l_proc,5);
3402: --
3403: p_foreign_lang_prof_pay.certification_date := l_pa_request_ei_rec.rei_information3;
3404: p_foreign_lang_prof_pay.pay_level_or_rate := l_pa_request_ei_rec.rei_information4;
3405: if p_foreign_lang_prof_pay.certification_date is not null or
3426: );
3427: end if;
3428: end if;
3429: --
3430: hr_utility.set_location('Leaving ' ||l_proc,5);
3431: --
3432: END for_lang_pay;
3433: --
3434: Procedure fta is
3434: Procedure fta is
3435: l_proc varchar2(70) := 'non_sf52_extra_info - fta';
3436: Begin
3437: --
3438: hr_utility.set_location('Entering ' ||l_proc,5);
3439: --
3440: p_imm_fta.last_action_code := l_pa_request_ei_rec.rei_information3;
3441: p_imm_fta.number_family_members := l_pa_request_ei_rec.rei_information4;
3442: p_imm_fta.Miscellaneous_Expense:= l_pa_request_ei_rec.rei_information5;
3460: Procedure edp_pay is
3461: l_proc varchar2(70) := 'non_sf52_extra_info - edp_pay';
3462: Begin
3463: --
3464: hr_utility.set_location('Entering ' ||l_proc,5);
3465: --
3466: p_edp_pay.premium_pay_indicator := l_pa_request_ei_rec.rei_information3;
3467: p_edp_pay.edp_type := l_pa_request_ei_rec.rei_information4;
3468: if p_edp_pay.premium_pay_indicator is not null or
3489: );
3490: end if;
3491: end if;
3492: --
3493: hr_utility.set_location('Leaving ' ||l_proc,5);
3494: --
3495: END edp_pay;
3496: --
3497: --
3498: Procedure hazard_pay is
3499: l_proc varchar2(70) := 'non_sf52_extra_info - hazard_pay';
3500: Begin
3501: --
3502: hr_utility.set_location('Entering ' ||l_proc,5);
3503: --
3504: p_hazard_pay.premium_pay_indicator := l_pa_request_ei_rec.rei_information3;
3505: p_hazard_pay.hazard_type := l_pa_request_ei_rec.rei_information4;
3506: if p_hazard_pay.premium_pay_indicator is not null or
3527: );
3528: end if;
3529: end if;
3530: --
3531: hr_utility.set_location('Leaving ' ||l_proc,10);
3532: --
3533: END hazard_pay;
3534: --
3535: --
3536: Procedure health_benefits is
3537: l_proc varchar2(70) := 'non_sf52_extra_info - health_benefits';
3538: Begin
3539: --
3540: hr_utility.set_location('Entering ' ||l_proc,5);
3541: --
3542: p_health_benefits.enrollment := l_pa_request_ei_rec.rei_information3;
3543: p_health_benefits.health_plan := l_pa_request_ei_rec.rei_information4;
3544: p_health_benefits.temps_total_cost := l_pa_request_ei_rec.rei_information5;
3587: );
3588: end if;
3589: end if;
3590: --
3591: hr_utility.set_location('Leaving ' ||l_proc,5);
3592: --
3593: END health_benefits;
3594: --
3595: --
3596: Procedure health_ben_pre_tax is
3597: l_proc varchar2(70) := 'non_sf52_extra_info - health_ben_pre_tax';
3598: Begin
3599: --
3600: hr_utility.set_location('Entering ' ||l_proc,5);
3601: --
3602: p_health_ben_pre_tax.enrollment := l_pa_request_ei_rec.rei_information3;
3603: p_health_ben_pre_tax.health_plan := l_pa_request_ei_rec.rei_information4;
3604: p_health_ben_pre_tax.temps_total_cost := l_pa_request_ei_rec.rei_information5;
3636: );
3637: end if;
3638: end if;
3639: --
3640: hr_utility.set_location('Leaving ' ||l_proc,5);
3641: --
3642: END health_ben_pre_tax;
3643: --
3644: Procedure danger_pay is
3644: Procedure danger_pay is
3645: l_proc varchar2(70) := 'non_sf52_extra_info - danger_pay';
3646: Begin
3647: --
3648: hr_utility.set_location('Entering ' ||l_proc,5);
3649: --
3650: p_danger_pay.last_action_code := l_pa_request_ei_rec.rei_information3;
3651: p_danger_pay.location := l_pa_request_ei_rec.rei_information4;
3652: if p_danger_pay.last_action_code is not null or
3673: );
3674: end if;
3675: end if;
3676: --
3677: hr_utility.set_location('Leaving ' ||l_proc,5);
3678: --
3679: END danger_pay;
3680: --
3681: --
3682: Procedure imminent_danger_pay is
3683: l_proc varchar2(70) := 'non_sf52_extra_info - imminent_danger_pay';
3684: Begin
3685: --
3686: hr_utility.set_location('Entering ' ||l_proc,5);
3687: --
3688: p_imminent_danger_pay.amount := l_pa_request_ei_rec.rei_information3;
3689: p_imminent_danger_pay.location := l_pa_request_ei_rec.rei_information4;
3690: p_imminent_danger_pay.last_action_code := l_pa_request_ei_rec.rei_information5;
3722: );
3723: end if;
3724: end if;
3725: --
3726: hr_utility.set_location('Leaving ' ||l_proc,5);
3727: --
3728: END imminent_danger_pay;
3729: --
3730: --
3731: Procedure living_quarters_allow is
3732: l_proc varchar2(70) := 'non_sf52_extra_info - living_quarters_allow';
3733: Begin
3734: --
3735: hr_utility.set_location('Entering ' ||l_proc,5);
3736: --
3737: p_living_quarters_allow.purchase_amount := l_pa_request_ei_rec.rei_information3;
3738: p_living_quarters_allow.purchase_date := l_pa_request_ei_rec.rei_information4;
3739: p_living_quarters_allow.rent_amount := l_pa_request_ei_rec.rei_information5;
3872: );
3873: end if;
3874: end if;
3875: --
3876: hr_utility.set_location('Leaving ' ||l_proc,5);
3877: --
3878: END living_quarters_allow;
3879: --
3880: --
3881: Procedure post_diff_amt is
3882: l_proc varchar2(70) := 'non_sf52_extra_info - post_diff_amt';
3883: Begin
3884: --
3885: hr_utility.set_location('Entering ' ||l_proc,5);
3886: --
3887: p_post_diff_amt.amount := l_pa_request_ei_rec.rei_information3;
3888: p_post_diff_amt.last_action_code := l_pa_request_ei_rec.rei_information4;
3889: p_post_diff_amt.location := l_pa_request_ei_rec.rei_information5;
3938: );
3939: end if;
3940: end if;
3941: --
3942: hr_utility.set_location('Leaving ' ||l_proc,5);
3943: --
3944: END post_diff_amt;
3945: --
3946: --
3947: Procedure post_diff_percent is
3948: l_proc varchar2(70) := 'non_sf52_extra_info - post_diff_percent';
3949: Begin
3950: --
3951: hr_utility.set_location('Entering ' ||l_proc,5);
3952: --
3953: p_post_diff_percent.percent := l_pa_request_ei_rec.rei_information3;
3954: p_post_diff_percent.last_action_code := l_pa_request_ei_rec.rei_information4;
3955: p_post_diff_percent.location := l_pa_request_ei_rec.rei_information5;
3990: );
3991: end if;
3992: end if;
3993: --
3994: hr_utility.set_location('Leaving ' ||l_proc,5);
3995: --
3996: END post_diff_percent;
3997: --
3998: --
3999: Procedure sep_maintenance_allow is
4000: l_proc varchar2(70) := 'non_sf52_extra_info - sep_maintenance_allow';
4001: Begin
4002: --
4003: hr_utility.set_location('Entering ' ||l_proc,5);
4004: --
4005: p_sep_maintenance_allow.amount := l_pa_request_ei_rec.rei_information3;
4006: p_sep_maintenance_allow.last_action_code := l_pa_request_ei_rec.rei_information4;
4007: p_sep_maintenance_allow.category := l_pa_request_ei_rec.rei_information5;
4040: );
4041: end if;
4042: end if;
4043: --
4044: hr_utility.set_location('Leaving ' ||l_proc,5);
4045: --
4046: END sep_maintenance_allow;
4047: --
4048: --
4049: Procedure supplemental_post_allow is
4050: l_proc varchar2(70) := 'non_sf52_extra_info - supplemental_post_allow';
4051: Begin
4052: --
4053: hr_utility.set_location('Entering ' ||l_proc,5);
4054: --
4055: p_supplemental_post_allow.amount := l_pa_request_ei_rec.rei_information3;
4056:
4057: if p_supplemental_post_allow.amount is not null then
4067: p_screen_entry_value => p_supplemental_post_allow.amount
4068: );
4069: end if;
4070: End if;
4071: hr_utility.set_location('Leaving ' ||l_proc,5);
4072: --
4073: END supplemental_post_allow;
4074: --
4075: --
4076: Procedure temp_lodge_allow is
4077: l_proc varchar2(70) := 'non_sf52_extra_info - temp_lodge_allow';
4078: Begin
4079: --
4080: hr_utility.set_location('Entering ' ||l_proc,5);
4081: --
4082: p_temp_lodge_allow.allowance_type := l_pa_request_ei_rec.rei_information3;
4083: p_temp_lodge_allow.daily_rate := l_pa_request_ei_rec.rei_information4;
4084:
4105: p_screen_entry_value => p_temp_lodge_allow.daily_rate
4106: );
4107: end if;
4108: End if;
4109: hr_utility.set_location('Leaving ' ||l_proc,5);
4110: --
4111: END temp_lodge_allow;
4112: --
4113: --
4114: Procedure premium_pay is
4115: l_proc varchar2(70) := 'non_sf52_extra_info - premium_pay';
4116: Begin
4117: --
4118: hr_utility.set_location('Entering ' ||l_proc,5);
4119: --
4120: p_premium_pay.premium_pay_ind := l_pa_request_ei_rec.rei_information3;
4121: p_premium_pay.amount := l_pa_request_ei_rec.rei_information4;
4122:
4143: p_screen_entry_value => p_premium_pay.amount
4144: );
4145: end if;
4146: End if;
4147: hr_utility.set_location('Leaving ' ||l_proc,5);
4148: --
4149: END premium_pay;
4150: --
4151: --
4152: Procedure retirement_annuity is
4153: l_proc varchar2(70) := 'non_sf52_extra_info - retirement_annuity';
4154: Begin
4155: --
4156: hr_utility.set_location('Entering ' ||l_proc,5);
4157: --
4158: p_retirement_annuity.annuity_sum := l_pa_request_ei_rec.rei_information3;
4159: p_retirement_annuity.eligibility_expires := l_pa_request_ei_rec.rei_information4;
4160:
4181: p_screen_entry_value => p_retirement_annuity.eligibility_expires
4182: );
4183: end if;
4184: End if;
4185: hr_utility.set_location('Leaving ' ||l_proc,5);
4186: --
4187: END retirement_annuity;
4188: --
4189: --
4190: Procedure severance_pay is
4191: l_proc varchar2(70) := 'non_sf52_extra_info - severance_pay';
4192: Begin
4193: --
4194: hr_utility.set_location('Entering ' ||l_proc,5);
4195: --
4196: p_severance_pay.amount := l_pa_request_ei_rec.rei_information3;
4197: p_severance_pay.total_entitlement_weeks := l_pa_request_ei_rec.rei_information4;
4198: p_severance_pay.number_weeks_paid := l_pa_request_ei_rec.rei_information5;
4241: p_screen_entry_value => p_severance_pay.weekly_amount
4242: );
4243: end if;
4244: End if;
4245: hr_utility.set_location('Leaving ' ||l_proc,5);
4246: --
4247: END severance_pay;
4248: --
4249: --
4251: Procedure thrift_saving_plan is
4252: l_proc varchar2(70) := 'non_sf52_extra_info - thrift_saving_plan';
4253: Begin
4254: --
4255: hr_utility.set_location('Entering ' ||l_proc,5);
4256: --
4257: p_thrift_saving_plan.amount := l_pa_request_ei_rec.rei_information3;
4258: p_thrift_saving_plan.rate := l_pa_request_ei_rec.rei_information4;
4259: p_thrift_saving_plan.g_fund := l_pa_request_ei_rec.rei_information5;
4361: p_screen_entry_value => p_thrift_saving_plan.emp_contrib_elig_date
4362: );
4363: end if;
4364: end if;
4365: hr_utility.set_location('Leaving ' ||l_proc,5);
4366: --
4367: END thrift_saving_plan;*/
4368: --
4369: --
4370: Procedure retention_allow_review is
4371: l_proc varchar2(70) := 'non_sf52_extra_info - retention_allow_review';
4372: Begin
4373: --
4374: hr_utility.set_location('Entering ' ||l_proc,5);
4375: If p_pa_request_rec.employee_assignment_id is not null then
4376: ghr_api.retrieve_element_entry_value
4377: (p_element_name => 'Retention Allowance',
4378: p_input_value_name => 'Date',
4390: --
4391: Procedure chg_in_tenure is
4392: l_proc varchar2(70) := 'non_sf52_extra - chg_in_tenure';
4393: Begin
4394: hr_utility.set_location('Entering ' ||l_proc,5);
4395: IF l_session.noa_id_correct is not null THEN
4396: set_extra_info(p_per_group1.appointment_type,l_pa_request_ei_rec.rei_information3,p_per_group1.per_group1_flag);
4397: ELSE
4398: p_per_group1.appointment_type := l_pa_request_ei_rec.rei_information3;
4397: ELSE
4398: p_per_group1.appointment_type := l_pa_request_ei_rec.rei_information3;
4399: p_per_group1.per_group1_flag := 'Y';
4400: END IF;
4401: hr_utility.set_location('Leaving ' ||p_per_group1.appointment_type ||l_proc,10);
4402: End chg_in_tenure;
4403: --
4404: -- 4352589 BEN_EIT Changes Assinging Eligibility Expires to Benefits EIT.
4405: Procedure chg_in_fegli is
4404: -- 4352589 BEN_EIT Changes Assinging Eligibility Expires to Benefits EIT.
4405: Procedure chg_in_fegli is
4406: l_proc varchar2(70) := 'non_sf52_extra - chg_in_fegli';
4407: Begin
4408: hr_utility.set_location('Entering ' ||l_proc,5);
4409: --
4410: p_per_benefit_info.FEGLI_Date_Eligibility_Expires := l_pa_request_ei_rec.rei_information1;
4411: If p_per_benefit_info.FEGLI_Date_Eligibility_Expires is not null then
4412: p_per_benefit_info.per_benefit_info_flag := 'Y';
4410: p_per_benefit_info.FEGLI_Date_Eligibility_Expires := l_pa_request_ei_rec.rei_information1;
4411: If p_per_benefit_info.FEGLI_Date_Eligibility_Expires is not null then
4412: p_per_benefit_info.per_benefit_info_flag := 'Y';
4413: End If;
4414: hr_utility.set_location('Leaving ' ||l_proc,10);
4415: End chg_in_fegli;
4416: --
4417: --Pradeep
4418: Procedure mddds_pay is
4419: l_proc varchar2(72) := 'mddds_pay';
4420:
4421: Begin
4422:
4423: hr_utility.set_location('Entering ' ||l_proc,6);
4424:
4425: set_extra_info(p_mddds_special_pay.Full_Time_Status,
4426: l_pa_request_ei_rec.rei_information9,
4427: p_mddds_special_pay.mddds_special_pay_flag,
4474: l_proc varchar2(72) := 'premium_pay_ind';
4475:
4476: Begin
4477:
4478: hr_utility.set_location('Entering ' ||l_proc,7);
4479:
4480:
4481: set_extra_info(p_premium_pay_ind.premium_pay_ind,
4482: l_pa_request_ei_rec.rei_information3,
4490: l_proc varchar2(72) := 'race_ethnic_info';
4491:
4492: Begin
4493:
4494: hr_utility.set_location('Entering ' ||l_proc,7);
4495:
4496: set_extra_info(p_race_ethnic_info.p_hispanic,l_pa_request_ei_rec.rei_information3,
4497: p_race_ethnic_info.p_race_ethnic_info_flag, 'Y' );
4498: set_extra_info(p_race_ethnic_info.p_american_indian,l_pa_request_ei_rec.rei_information4,
4510: Procedure student_loan_repay is
4511: l_proc varchar2(80):= 'non_sf52_extra - student_loan_repay';
4512:
4513: begin
4514: hr_utility.set_location('Entering ' ||l_proc,5);
4515: --
4516: set_extra_info(p_student_loan_repay.p_amount,
4517: p_pa_request_rec.award_amount,
4518: p_student_loan_repay.p_student_loan_flag,
4535: -- p_student_loan_repay.p_amount :=p_pa_request_rec.award_amount;
4536: -- p_student_loan_repay.p_repay_schedule := l_pa_request_ei_rec.rei_information8;
4537: -- p_student_loan_repay.p_review_date := l_pa_request_ei_rec.rei_information9;
4538:
4539: hr_utility.set_location('Leaving ' ||l_proc,10);
4540: end;
4541:
4542: -- Bug 4280026
4543: Procedure key_emergency_essntl is
4542: -- Bug 4280026
4543: Procedure key_emergency_essntl is
4544: l_proc varchar2(70) := 'non_sf52_extra - key_emergency_essntl';
4545: Begin
4546: hr_utility.set_location('Entering ' ||l_proc,5);
4547: set_extra_info(p_asg_non_sf52.key_emer_essential_empl,
4548: l_pa_request_ei_rec.rei_information3,p_asg_non_sf52.asg_non_sf52_flag, 'Y');
4549: hr_utility.set_location('Leaving ' ||l_proc,10);
4550: End key_emergency_essntl;
4545: Begin
4546: hr_utility.set_location('Entering ' ||l_proc,5);
4547: set_extra_info(p_asg_non_sf52.key_emer_essential_empl,
4548: l_pa_request_ei_rec.rei_information3,p_asg_non_sf52.asg_non_sf52_flag, 'Y');
4549: hr_utility.set_location('Leaving ' ||l_proc,10);
4550: End key_emergency_essntl;
4551:
4552: -- Bug 5482191
4553: Procedure ghr_conv_dates is
4552: -- Bug 5482191
4553: Procedure ghr_conv_dates is
4554: l_proc varchar2(70) := 'non_sf52_extra - ghr_conv_dates';
4555: Begin
4556: hr_utility.set_location('Entering ' ||l_proc,5);
4557: set_extra_info(p_per_conversions.date_conv_career_begins,
4558: l_pa_request_ei_rec.rei_information3,p_per_conversions.per_conversions_flag,'Y');
4559: set_extra_info(p_per_conversions.date_conv_career_due,
4560: l_pa_request_ei_rec.rei_information4,p_per_conversions.per_conversions_flag,'Y');
4563: set_extra_info(p_per_conversions.date_recmd_conv_due,
4564: l_pa_request_ei_rec.rei_information7,p_per_conversions.per_conversions_flag,'Y');
4565: set_extra_info(p_per_conversions.date_vra_conv_due,
4566: l_pa_request_ei_rec.rei_information6,p_per_conversions.per_conversions_flag,'Y');
4567: hr_utility.set_location('Leaving ' ||l_proc,10);
4568: End ghr_conv_dates;
4569:
4570:
4571: -- Start of Bug 6312144 -- New IPA Benefits Continuation EIT
4571: -- Start of Bug 6312144 -- New IPA Benefits Continuation EIT
4572: Procedure ipa_benefits_cont is
4573: l_proc varchar2(70) := 'non_sf52_extra - ipa_benefits_cont';
4574: Begin
4575: hr_utility.set_location('Entering ' ||l_proc,5);
4576: set_extra_info(p_ipa_benefits_cont.FEGLI_Indicator,
4577: l_pa_request_ei_rec.rei_information1,p_ipa_benefits_cont.per_ben_cont_info_flag,'Y');
4578: set_extra_info(p_ipa_benefits_cont.FEGLI_Election_Date,
4579: l_pa_request_ei_rec.rei_information2,p_ipa_benefits_cont.per_ben_cont_info_flag,'Y');
4596: set_extra_info(p_ipa_benefits_cont.Cont_Term_Insuff_Pay_Notf_Date,
4597: l_pa_request_ei_rec.rei_information10,p_ipa_benefits_cont.per_ben_cont_info_flag,'Y');
4598: set_extra_info(p_ipa_benefits_cont.Cont_Term_Insuff_Pmt_Type_Code,
4599: l_pa_request_ei_rec.rei_information11,p_ipa_benefits_cont.per_ben_cont_info_flag,'Y');
4600: hr_utility.set_location('Leaving ' ||l_proc,10);
4601: End ipa_benefits_cont;
4602:
4603:
4604: -- Bug 6312144 -- New Federal Benefits Info EIT
4604: -- Bug 6312144 -- New Federal Benefits Info EIT
4605: Procedure ben_info_cont is
4606: l_proc varchar2(70) := 'non_sf52_extra - Federal Benefit Info';
4607: Begin
4608: hr_utility.set_location('Entering ' ||l_proc,5);
4609: set_extra_info(p_per_benefit_info.FEGLI_Assignment_Ind,
4610: l_pa_request_ei_rec.rei_information1,p_per_benefit_info.per_benefit_info_flag,'Y');
4611: set_extra_info(p_per_benefit_info.FEGLI_Post_Elec_Basic_Ins_Amt,
4612: l_pa_request_ei_rec.rei_information2,p_per_benefit_info.per_benefit_info_flag,'Y');
4615: set_extra_info(p_per_benefit_info.Desg_FEGLI_Benf_Ind,
4616: l_pa_request_ei_rec.rei_information4,p_per_benefit_info.per_benefit_info_flag,'Y');
4617: set_extra_info(p_per_benefit_info.FEHB_Event_Code,
4618: l_pa_request_ei_rec.rei_information5,p_per_benefit_info.per_benefit_info_flag,'Y');
4619: hr_utility.set_location('Leaving ' ||l_proc,10);
4620: End ben_info_cont;
4621:
4622: -- Bug 6312144 -- Retirement system information
4623: Procedure retirement_info is
4622: -- Bug 6312144 -- Retirement system information
4623: Procedure retirement_info is
4624: l_proc varchar2(70) := 'non_sf52_extra - Retirement System Info';
4625: Begin
4626: hr_utility.set_location('Entering ' ||l_proc,5);
4627: set_extra_info(p_retirement_info.special_population_code,
4628: l_pa_request_ei_rec.rei_information1,p_retirement_info.per_retirement_info_flag,'Y');
4629: set_extra_info(p_retirement_info.App_Exc_CSRS_Ind,
4630: l_pa_request_ei_rec.rei_information2,p_retirement_info.per_retirement_info_flag,'Y');
4633: set_extra_info(p_retirement_info.FICA_Coverage_Ind1,
4634: l_pa_request_ei_rec.rei_information4,p_retirement_info.per_retirement_info_flag,'Y');
4635: set_extra_info(p_retirement_info.FICA_Coverage_Ind2,
4636: l_pa_request_ei_rec.rei_information5,p_retirement_info.per_retirement_info_flag,'Y');
4637: hr_utility.set_location('Leaving ' ||l_proc,10);
4638: End retirement_info;
4639: /* --Begin Bug# 4588575
4640: Procedure ghr_prob_info is
4641: l_proc varchar2(70) := 'non_sf52_extra - ghr_prob_info';
4639: /* --Begin Bug# 4588575
4640: Procedure ghr_prob_info is
4641: l_proc varchar2(70) := 'non_sf52_extra - ghr_prob_info';
4642: Begin
4643: hr_utility.set_location('Entering ' ||l_proc,55);
4644: set_extra_info(p_per_probations.date_prob_trial_period_begin ,
4645: l_pa_request_ei_rec.rei_information10,p_per_probations.per_probation_flag);
4646: set_extra_info(p_per_probations.date_prob_trial_period_ends ,
4647: l_pa_request_ei_rec.rei_information11,p_per_probations.per_probation_flag);
4652: set_extra_info(p_per_probations.spvr_mgr_prob_completion ,
4653: l_pa_request_ei_rec.rei_information14,p_per_probations.per_probation_flag);
4654: set_extra_info(p_per_probations.date_ses_prob_expires ,
4655: l_pa_request_ei_rec.rei_information15,p_per_probations.per_probation_flag);
4656: hr_utility.set_location('Leaving ' ||l_proc,56);
4657: End ghr_prob_info;
4658:
4659: PROCEDURE chg_scd_info is
4660: l_proc varchar2(70) := 'non_sf52_extra - chg_scd_info';
4658:
4659: PROCEDURE chg_scd_info is
4660: l_proc varchar2(70) := 'non_sf52_extra - chg_scd_info';
4661: Begin
4662: hr_utility.set_location('Entering ' ||l_proc,6);
4663: set_extra_info(p_per_scd_info.scd_civilian,l_pa_request_ei_rec.rei_information10,
4664: p_per_scd_info.per_scd_info_flag, 'Y');
4665: set_extra_info(p_per_scd_info.scd_rif,l_pa_request_ei_rec.rei_information11,
4666: p_per_scd_info.per_scd_info_flag, 'Y');
4669: set_extra_info(p_per_scd_info.scd_ses,l_pa_request_ei_rec.rei_information13,
4670: p_per_scd_info.per_scd_info_flag, 'Y');
4671: set_extra_info(p_per_scd_info.scd_spl_retirement,l_pa_request_ei_rec.rei_information14,
4672: p_per_scd_info.per_scd_info_flag, 'Y');
4673: hr_utility.set_location('Leaving ' ||l_proc,60);
4674: End chg_scd_info;
4675: --end Bug# 4588575
4676: */ --Backout the changes done for Bug# 4588575
4677: Begin
4737: -- Bug 3260890
4738:
4739: For info_type in c_info_types loop
4740: l_information_type := info_type.information_type;
4741: hr_utility.set_location('l_information_type :' || l_information_type,1);
4742: l_pa_request_ei_rec := null;
4743: FOR pa_request_extra_info IN c_pa_request_extra_info LOOP
4744: l_pa_request_ei_rec := pa_request_extra_info;
4745: END LOOP;
4743: FOR pa_request_extra_info IN c_pa_request_extra_info LOOP
4744: l_pa_request_ei_rec := pa_request_extra_info;
4745: END LOOP;
4746:
4747: hr_utility.set_location('rei 3 ' || l_pa_request_ei_rec.rei_information3,1);
4748: hr_utility.set_location('rei 4 ' || l_pa_request_ei_rec.rei_information4,1);
4749: hr_utility.set_location('rei 5 ' || l_pa_request_ei_rec.rei_information5,1);
4750: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
4751: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
4744: l_pa_request_ei_rec := pa_request_extra_info;
4745: END LOOP;
4746:
4747: hr_utility.set_location('rei 3 ' || l_pa_request_ei_rec.rei_information3,1);
4748: hr_utility.set_location('rei 4 ' || l_pa_request_ei_rec.rei_information4,1);
4749: hr_utility.set_location('rei 5 ' || l_pa_request_ei_rec.rei_information5,1);
4750: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
4751: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
4752: hr_utility.set_location('rei 8 ' || l_pa_request_ei_rec.rei_information8,1);
4745: END LOOP;
4746:
4747: hr_utility.set_location('rei 3 ' || l_pa_request_ei_rec.rei_information3,1);
4748: hr_utility.set_location('rei 4 ' || l_pa_request_ei_rec.rei_information4,1);
4749: hr_utility.set_location('rei 5 ' || l_pa_request_ei_rec.rei_information5,1);
4750: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
4751: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
4752: hr_utility.set_location('rei 8 ' || l_pa_request_ei_rec.rei_information8,1);
4753: hr_utility.set_location('rei 9 ' || l_pa_request_ei_rec.rei_information9,1);
4746:
4747: hr_utility.set_location('rei 3 ' || l_pa_request_ei_rec.rei_information3,1);
4748: hr_utility.set_location('rei 4 ' || l_pa_request_ei_rec.rei_information4,1);
4749: hr_utility.set_location('rei 5 ' || l_pa_request_ei_rec.rei_information5,1);
4750: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
4751: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
4752: hr_utility.set_location('rei 8 ' || l_pa_request_ei_rec.rei_information8,1);
4753: hr_utility.set_location('rei 9 ' || l_pa_request_ei_rec.rei_information9,1);
4754: hr_utility.set_location('rei 11 ' || l_pa_request_ei_rec.rei_information11,1);
4747: hr_utility.set_location('rei 3 ' || l_pa_request_ei_rec.rei_information3,1);
4748: hr_utility.set_location('rei 4 ' || l_pa_request_ei_rec.rei_information4,1);
4749: hr_utility.set_location('rei 5 ' || l_pa_request_ei_rec.rei_information5,1);
4750: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
4751: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
4752: hr_utility.set_location('rei 8 ' || l_pa_request_ei_rec.rei_information8,1);
4753: hr_utility.set_location('rei 9 ' || l_pa_request_ei_rec.rei_information9,1);
4754: hr_utility.set_location('rei 11 ' || l_pa_request_ei_rec.rei_information11,1);
4755:
4748: hr_utility.set_location('rei 4 ' || l_pa_request_ei_rec.rei_information4,1);
4749: hr_utility.set_location('rei 5 ' || l_pa_request_ei_rec.rei_information5,1);
4750: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
4751: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
4752: hr_utility.set_location('rei 8 ' || l_pa_request_ei_rec.rei_information8,1);
4753: hr_utility.set_location('rei 9 ' || l_pa_request_ei_rec.rei_information9,1);
4754: hr_utility.set_location('rei 11 ' || l_pa_request_ei_rec.rei_information11,1);
4755:
4756: --
4749: hr_utility.set_location('rei 5 ' || l_pa_request_ei_rec.rei_information5,1);
4750: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
4751: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
4752: hr_utility.set_location('rei 8 ' || l_pa_request_ei_rec.rei_information8,1);
4753: hr_utility.set_location('rei 9 ' || l_pa_request_ei_rec.rei_information9,1);
4754: hr_utility.set_location('rei 11 ' || l_pa_request_ei_rec.rei_information11,1);
4755:
4756: --
4757: if l_information_type = 'GHR_US_PAR_APPT_INFO' then
4750: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
4751: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
4752: hr_utility.set_location('rei 8 ' || l_pa_request_ei_rec.rei_information8,1);
4753: hr_utility.set_location('rei 9 ' || l_pa_request_ei_rec.rei_information9,1);
4754: hr_utility.set_location('rei 11 ' || l_pa_request_ei_rec.rei_information11,1);
4755:
4756: --
4757: if l_information_type = 'GHR_US_PAR_APPT_INFO' then
4758: hr_utility.set_location(l_proc,5);
4754: hr_utility.set_location('rei 11 ' || l_pa_request_ei_rec.rei_information11,1);
4755:
4756: --
4757: if l_information_type = 'GHR_US_PAR_APPT_INFO' then
4758: hr_utility.set_location(l_proc,5);
4759: hr_utility.set_location('info type ' || l_information_type,1);
4760: appt_info;
4761: elsif l_information_type = 'GHR_US_PAR_APPT_TRANSFER' then
4762: hr_utility.set_location(l_proc,10);
4755:
4756: --
4757: if l_information_type = 'GHR_US_PAR_APPT_INFO' then
4758: hr_utility.set_location(l_proc,5);
4759: hr_utility.set_location('info type ' || l_information_type,1);
4760: appt_info;
4761: elsif l_information_type = 'GHR_US_PAR_APPT_TRANSFER' then
4762: hr_utility.set_location(l_proc,10);
4763: hr_utility.set_location('info type ' || l_information_type,2);
4758: hr_utility.set_location(l_proc,5);
4759: hr_utility.set_location('info type ' || l_information_type,1);
4760: appt_info;
4761: elsif l_information_type = 'GHR_US_PAR_APPT_TRANSFER' then
4762: hr_utility.set_location(l_proc,10);
4763: hr_utility.set_location('info type ' || l_information_type,2);
4764: appt_transfer;
4765: elsif l_information_type = 'GHR_US_PAR_CONV_APP' then
4766: hr_utility.set_location(l_proc,15);
4759: hr_utility.set_location('info type ' || l_information_type,1);
4760: appt_info;
4761: elsif l_information_type = 'GHR_US_PAR_APPT_TRANSFER' then
4762: hr_utility.set_location(l_proc,10);
4763: hr_utility.set_location('info type ' || l_information_type,2);
4764: appt_transfer;
4765: elsif l_information_type = 'GHR_US_PAR_CONV_APP' then
4766: hr_utility.set_location(l_proc,15);
4767: hr_utility.set_location('info type ' || l_information_type,3);
4762: hr_utility.set_location(l_proc,10);
4763: hr_utility.set_location('info type ' || l_information_type,2);
4764: appt_transfer;
4765: elsif l_information_type = 'GHR_US_PAR_CONV_APP' then
4766: hr_utility.set_location(l_proc,15);
4767: hr_utility.set_location('info type ' || l_information_type,3);
4768: conv_appt;
4769: elsif l_information_type = 'GHR_US_PAR_RETURN_TO_DUTY' then
4770: hr_utility.set_location(l_proc,20);
4763: hr_utility.set_location('info type ' || l_information_type,2);
4764: appt_transfer;
4765: elsif l_information_type = 'GHR_US_PAR_CONV_APP' then
4766: hr_utility.set_location(l_proc,15);
4767: hr_utility.set_location('info type ' || l_information_type,3);
4768: conv_appt;
4769: elsif l_information_type = 'GHR_US_PAR_RETURN_TO_DUTY' then
4770: hr_utility.set_location(l_proc,20);
4771: hr_utility.set_location('info type ' || l_information_type,4);
4766: hr_utility.set_location(l_proc,15);
4767: hr_utility.set_location('info type ' || l_information_type,3);
4768: conv_appt;
4769: elsif l_information_type = 'GHR_US_PAR_RETURN_TO_DUTY' then
4770: hr_utility.set_location(l_proc,20);
4771: hr_utility.set_location('info type ' || l_information_type,4);
4772: return_to_duty;
4773: elsif l_information_type = 'GHR_US_PAR_REASSIGNMENT' then
4774: hr_utility.set_location(l_proc,25);
4767: hr_utility.set_location('info type ' || l_information_type,3);
4768: conv_appt;
4769: elsif l_information_type = 'GHR_US_PAR_RETURN_TO_DUTY' then
4770: hr_utility.set_location(l_proc,20);
4771: hr_utility.set_location('info type ' || l_information_type,4);
4772: return_to_duty;
4773: elsif l_information_type = 'GHR_US_PAR_REASSIGNMENT' then
4774: hr_utility.set_location(l_proc,25);
4775: hr_utility.set_location('info type ' || l_information_type,5);
4770: hr_utility.set_location(l_proc,20);
4771: hr_utility.set_location('info type ' || l_information_type,4);
4772: return_to_duty;
4773: elsif l_information_type = 'GHR_US_PAR_REASSIGNMENT' then
4774: hr_utility.set_location(l_proc,25);
4775: hr_utility.set_location('info type ' || l_information_type,5);
4776: reassign;
4777: elsif l_information_type = 'GHR_US_PAR_POSN_CHG' then
4778: hr_utility.set_location(l_proc,30);
4771: hr_utility.set_location('info type ' || l_information_type,4);
4772: return_to_duty;
4773: elsif l_information_type = 'GHR_US_PAR_REASSIGNMENT' then
4774: hr_utility.set_location(l_proc,25);
4775: hr_utility.set_location('info type ' || l_information_type,5);
4776: reassign;
4777: elsif l_information_type = 'GHR_US_PAR_POSN_CHG' then
4778: hr_utility.set_location(l_proc,30);
4779: hr_utility.set_location('info type ' || l_information_type,6);
4774: hr_utility.set_location(l_proc,25);
4775: hr_utility.set_location('info type ' || l_information_type,5);
4776: reassign;
4777: elsif l_information_type = 'GHR_US_PAR_POSN_CHG' then
4778: hr_utility.set_location(l_proc,30);
4779: hr_utility.set_location('info type ' || l_information_type,6);
4780: posn_chg;
4781: elsif l_information_type = 'GHR_US_PAR_CHG_HOURS' then
4782: hr_utility.set_location(l_proc,35);
4775: hr_utility.set_location('info type ' || l_information_type,5);
4776: reassign;
4777: elsif l_information_type = 'GHR_US_PAR_POSN_CHG' then
4778: hr_utility.set_location(l_proc,30);
4779: hr_utility.set_location('info type ' || l_information_type,6);
4780: posn_chg;
4781: elsif l_information_type = 'GHR_US_PAR_CHG_HOURS' then
4782: hr_utility.set_location(l_proc,35);
4783: hr_utility.set_location('info type ' || l_information_type,7);
4778: hr_utility.set_location(l_proc,30);
4779: hr_utility.set_location('info type ' || l_information_type,6);
4780: posn_chg;
4781: elsif l_information_type = 'GHR_US_PAR_CHG_HOURS' then
4782: hr_utility.set_location(l_proc,35);
4783: hr_utility.set_location('info type ' || l_information_type,7);
4784: chg_sched_hours;
4785: elsif l_information_type = 'GHR_US_PAR_REALIGNMENT' then
4786: hr_utility.set_location(l_proc,40);
4779: hr_utility.set_location('info type ' || l_information_type,6);
4780: posn_chg;
4781: elsif l_information_type = 'GHR_US_PAR_CHG_HOURS' then
4782: hr_utility.set_location(l_proc,35);
4783: hr_utility.set_location('info type ' || l_information_type,7);
4784: chg_sched_hours;
4785: elsif l_information_type = 'GHR_US_PAR_REALIGNMENT' then
4786: hr_utility.set_location(l_proc,40);
4787: hr_utility.set_location('info type ' || l_information_type,8);
4782: hr_utility.set_location(l_proc,35);
4783: hr_utility.set_location('info type ' || l_information_type,7);
4784: chg_sched_hours;
4785: elsif l_information_type = 'GHR_US_PAR_REALIGNMENT' then
4786: hr_utility.set_location(l_proc,40);
4787: hr_utility.set_location('info type ' || l_information_type,8);
4788: realign;
4789: elsif l_information_type = 'GHR_US_PAR_CHG_DATA_ELEMENT' then
4790: hr_utility.set_location(l_proc,45);
4783: hr_utility.set_location('info type ' || l_information_type,7);
4784: chg_sched_hours;
4785: elsif l_information_type = 'GHR_US_PAR_REALIGNMENT' then
4786: hr_utility.set_location(l_proc,40);
4787: hr_utility.set_location('info type ' || l_information_type,8);
4788: realign;
4789: elsif l_information_type = 'GHR_US_PAR_CHG_DATA_ELEMENT' then
4790: hr_utility.set_location(l_proc,45);
4791: hr_utility.set_location('info type ' || l_information_type,9);
4786: hr_utility.set_location(l_proc,40);
4787: hr_utility.set_location('info type ' || l_information_type,8);
4788: realign;
4789: elsif l_information_type = 'GHR_US_PAR_CHG_DATA_ELEMENT' then
4790: hr_utility.set_location(l_proc,45);
4791: hr_utility.set_location('info type ' || l_information_type,9);
4792: chg_data_elm;
4793: elsif l_information_type = 'GHR_US_PAR_CHG_RETIRE_PLAN' then
4794: hr_utility.set_location(l_proc,50);
4787: hr_utility.set_location('info type ' || l_information_type,8);
4788: realign;
4789: elsif l_information_type = 'GHR_US_PAR_CHG_DATA_ELEMENT' then
4790: hr_utility.set_location(l_proc,45);
4791: hr_utility.set_location('info type ' || l_information_type,9);
4792: chg_data_elm;
4793: elsif l_information_type = 'GHR_US_PAR_CHG_RETIRE_PLAN' then
4794: hr_utility.set_location(l_proc,50);
4795: hr_utility.set_location('info type ' || l_information_type,10);
4790: hr_utility.set_location(l_proc,45);
4791: hr_utility.set_location('info type ' || l_information_type,9);
4792: chg_data_elm;
4793: elsif l_information_type = 'GHR_US_PAR_CHG_RETIRE_PLAN' then
4794: hr_utility.set_location(l_proc,50);
4795: hr_utility.set_location('info type ' || l_information_type,10);
4796: chg_ret_plan;
4797: elsif l_information_type = 'GHR_US_PAR_CHG_SCD' then
4798: hr_utility.set_location(l_proc,55);
4791: hr_utility.set_location('info type ' || l_information_type,9);
4792: chg_data_elm;
4793: elsif l_information_type = 'GHR_US_PAR_CHG_RETIRE_PLAN' then
4794: hr_utility.set_location(l_proc,50);
4795: hr_utility.set_location('info type ' || l_information_type,10);
4796: chg_ret_plan;
4797: elsif l_information_type = 'GHR_US_PAR_CHG_SCD' then
4798: hr_utility.set_location(l_proc,55);
4799: hr_utility.set_location('info type ' || l_information_type,11);
4794: hr_utility.set_location(l_proc,50);
4795: hr_utility.set_location('info type ' || l_information_type,10);
4796: chg_ret_plan;
4797: elsif l_information_type = 'GHR_US_PAR_CHG_SCD' then
4798: hr_utility.set_location(l_proc,55);
4799: hr_utility.set_location('info type ' || l_information_type,11);
4800: chg_scd;
4801: /* Bug # 1165309
4802: elsif l_information_type = 'GHR_US_PAR_DENIAL_WGI' then
4795: hr_utility.set_location('info type ' || l_information_type,10);
4796: chg_ret_plan;
4797: elsif l_information_type = 'GHR_US_PAR_CHG_SCD' then
4798: hr_utility.set_location(l_proc,55);
4799: hr_utility.set_location('info type ' || l_information_type,11);
4800: chg_scd;
4801: /* Bug # 1165309
4802: elsif l_information_type = 'GHR_US_PAR_DENIAL_WGI' then
4803: hr_utility.set_location(l_proc,60);
4799: hr_utility.set_location('info type ' || l_information_type,11);
4800: chg_scd;
4801: /* Bug # 1165309
4802: elsif l_information_type = 'GHR_US_PAR_DENIAL_WGI' then
4803: hr_utility.set_location(l_proc,60);
4804: hr_utility.set_location('info type ' || l_information_type,12);
4805: denial_wgi;
4806: */
4807: elsif l_information_type = 'GHR_US_PAR_SALARY_CHG' then
4800: chg_scd;
4801: /* Bug # 1165309
4802: elsif l_information_type = 'GHR_US_PAR_DENIAL_WGI' then
4803: hr_utility.set_location(l_proc,60);
4804: hr_utility.set_location('info type ' || l_information_type,12);
4805: denial_wgi;
4806: */
4807: elsif l_information_type = 'GHR_US_PAR_SALARY_CHG' then
4808: hr_utility.set_location(l_proc,65);
4804: hr_utility.set_location('info type ' || l_information_type,12);
4805: denial_wgi;
4806: */
4807: elsif l_information_type = 'GHR_US_PAR_SALARY_CHG' then
4808: hr_utility.set_location(l_proc,65);
4809: hr_utility.set_location('info type ' || l_information_type,13);
4810: salary_change;
4811: elsif l_information_type = 'GHR_US_PAR_RECRUIT_BONUS' then
4812: hr_utility.set_location(l_proc,70);
4805: denial_wgi;
4806: */
4807: elsif l_information_type = 'GHR_US_PAR_SALARY_CHG' then
4808: hr_utility.set_location(l_proc,65);
4809: hr_utility.set_location('info type ' || l_information_type,13);
4810: salary_change;
4811: elsif l_information_type = 'GHR_US_PAR_RECRUIT_BONUS' then
4812: hr_utility.set_location(l_proc,70);
4813: hr_utility.set_location('info type ' || l_information_type,14);
4808: hr_utility.set_location(l_proc,65);
4809: hr_utility.set_location('info type ' || l_information_type,13);
4810: salary_change;
4811: elsif l_information_type = 'GHR_US_PAR_RECRUIT_BONUS' then
4812: hr_utility.set_location(l_proc,70);
4813: hr_utility.set_location('info type ' || l_information_type,14);
4814: recruitment_bonus;
4815: elsif l_information_type = 'GHR_US_PAR_RELOC_BONUS' then
4816: hr_utility.set_location(l_proc,75);
4809: hr_utility.set_location('info type ' || l_information_type,13);
4810: salary_change;
4811: elsif l_information_type = 'GHR_US_PAR_RECRUIT_BONUS' then
4812: hr_utility.set_location(l_proc,70);
4813: hr_utility.set_location('info type ' || l_information_type,14);
4814: recruitment_bonus;
4815: elsif l_information_type = 'GHR_US_PAR_RELOC_BONUS' then
4816: hr_utility.set_location(l_proc,75);
4817: hr_utility.set_location('info type ' || l_information_type,15);
4812: hr_utility.set_location(l_proc,70);
4813: hr_utility.set_location('info type ' || l_information_type,14);
4814: recruitment_bonus;
4815: elsif l_information_type = 'GHR_US_PAR_RELOC_BONUS' then
4816: hr_utility.set_location(l_proc,75);
4817: hr_utility.set_location('info type ' || l_information_type,15);
4818: relocation_bonus;
4819: elsif l_information_type = 'GHR_US_PAR_AWARDS_BONUS' then
4820: hr_utility.set_location(l_proc,80);
4813: hr_utility.set_location('info type ' || l_information_type,14);
4814: recruitment_bonus;
4815: elsif l_information_type = 'GHR_US_PAR_RELOC_BONUS' then
4816: hr_utility.set_location(l_proc,75);
4817: hr_utility.set_location('info type ' || l_information_type,15);
4818: relocation_bonus;
4819: elsif l_information_type = 'GHR_US_PAR_AWARDS_BONUS' then
4820: hr_utility.set_location(l_proc,80);
4821: hr_utility.set_location('info type ' || l_information_type,16);
4816: hr_utility.set_location(l_proc,75);
4817: hr_utility.set_location('info type ' || l_information_type,15);
4818: relocation_bonus;
4819: elsif l_information_type = 'GHR_US_PAR_AWARDS_BONUS' then
4820: hr_utility.set_location(l_proc,80);
4821: hr_utility.set_location('info type ' || l_information_type,16);
4822: government_awards;
4823: elsif l_information_type = 'GHR_US_PAR_NON_PAY_DUTY_STATUS' then
4824: hr_utility.set_location(l_proc,85);
4817: hr_utility.set_location('info type ' || l_information_type,15);
4818: relocation_bonus;
4819: elsif l_information_type = 'GHR_US_PAR_AWARDS_BONUS' then
4820: hr_utility.set_location(l_proc,80);
4821: hr_utility.set_location('info type ' || l_information_type,16);
4822: government_awards;
4823: elsif l_information_type = 'GHR_US_PAR_NON_PAY_DUTY_STATUS' then
4824: hr_utility.set_location(l_proc,85);
4825: hr_utility.set_location('info type ' || l_information_type,17);
4820: hr_utility.set_location(l_proc,80);
4821: hr_utility.set_location('info type ' || l_information_type,16);
4822: government_awards;
4823: elsif l_information_type = 'GHR_US_PAR_NON_PAY_DUTY_STATUS' then
4824: hr_utility.set_location(l_proc,85);
4825: hr_utility.set_location('info type ' || l_information_type,17);
4826: non_pay_duty_status;
4827: elsif l_information_type = 'GHR_US_PAR_TERM_RET_GRADE' then
4828: hr_utility.set_location(l_proc,90);
4821: hr_utility.set_location('info type ' || l_information_type,16);
4822: government_awards;
4823: elsif l_information_type = 'GHR_US_PAR_NON_PAY_DUTY_STATUS' then
4824: hr_utility.set_location(l_proc,85);
4825: hr_utility.set_location('info type ' || l_information_type,17);
4826: non_pay_duty_status;
4827: elsif l_information_type = 'GHR_US_PAR_TERM_RET_GRADE' then
4828: hr_utility.set_location(l_proc,90);
4829: hr_utility.set_location('info type ' || l_information_type,18);
4824: hr_utility.set_location(l_proc,85);
4825: hr_utility.set_location('info type ' || l_information_type,17);
4826: non_pay_duty_status;
4827: elsif l_information_type = 'GHR_US_PAR_TERM_RET_GRADE' then
4828: hr_utility.set_location(l_proc,90);
4829: hr_utility.set_location('info type ' || l_information_type,18);
4830: term_retained_grade;
4831: elsif l_information_type = 'GHR_US_PAR_QSI_AWARD' then
4832: hr_utility.set_location(l_proc,95);
4825: hr_utility.set_location('info type ' || l_information_type,17);
4826: non_pay_duty_status;
4827: elsif l_information_type = 'GHR_US_PAR_TERM_RET_GRADE' then
4828: hr_utility.set_location(l_proc,90);
4829: hr_utility.set_location('info type ' || l_information_type,18);
4830: term_retained_grade;
4831: elsif l_information_type = 'GHR_US_PAR_QSI_AWARD' then
4832: hr_utility.set_location(l_proc,95);
4833: hr_utility.set_location('info type ' || l_information_type,19);
4828: hr_utility.set_location(l_proc,90);
4829: hr_utility.set_location('info type ' || l_information_type,18);
4830: term_retained_grade;
4831: elsif l_information_type = 'GHR_US_PAR_QSI_AWARD' then
4832: hr_utility.set_location(l_proc,95);
4833: hr_utility.set_location('info type ' || l_information_type,19);
4834: quality_step_increase;
4835: elsif l_information_type = 'GHR_US_PAR_LWOP_INFO' then
4836: hr_utility.set_location(l_proc,100);
4829: hr_utility.set_location('info type ' || l_information_type,18);
4830: term_retained_grade;
4831: elsif l_information_type = 'GHR_US_PAR_QSI_AWARD' then
4832: hr_utility.set_location(l_proc,95);
4833: hr_utility.set_location('info type ' || l_information_type,19);
4834: quality_step_increase;
4835: elsif l_information_type = 'GHR_US_PAR_LWOP_INFO' then
4836: hr_utility.set_location(l_proc,100);
4837: hr_utility.set_location('info type ' || l_information_type,20);
4832: hr_utility.set_location(l_proc,95);
4833: hr_utility.set_location('info type ' || l_information_type,19);
4834: quality_step_increase;
4835: elsif l_information_type = 'GHR_US_PAR_LWOP_INFO' then
4836: hr_utility.set_location(l_proc,100);
4837: hr_utility.set_location('info type ' || l_information_type,20);
4838: lwop_info;
4839: elsif l_information_type = 'GHR_US_PAR_ENTITLEMENT' then
4840: hr_utility.set_location(l_proc,105);
4833: hr_utility.set_location('info type ' || l_information_type,19);
4834: quality_step_increase;
4835: elsif l_information_type = 'GHR_US_PAR_LWOP_INFO' then
4836: hr_utility.set_location(l_proc,100);
4837: hr_utility.set_location('info type ' || l_information_type,20);
4838: lwop_info;
4839: elsif l_information_type = 'GHR_US_PAR_ENTITLEMENT' then
4840: hr_utility.set_location(l_proc,105);
4841: hr_utility.set_location('info type ' || l_information_type,21);
4836: hr_utility.set_location(l_proc,100);
4837: hr_utility.set_location('info type ' || l_information_type,20);
4838: lwop_info;
4839: elsif l_information_type = 'GHR_US_PAR_ENTITLEMENT' then
4840: hr_utility.set_location(l_proc,105);
4841: hr_utility.set_location('info type ' || l_information_type,21);
4842: entitlement;
4843: elsif l_information_type = 'GHR_US_PAR_FOR_LANG_PROF_PAY' then
4844: hr_utility.set_location(l_proc,110);
4837: hr_utility.set_location('info type ' || l_information_type,20);
4838: lwop_info;
4839: elsif l_information_type = 'GHR_US_PAR_ENTITLEMENT' then
4840: hr_utility.set_location(l_proc,105);
4841: hr_utility.set_location('info type ' || l_information_type,21);
4842: entitlement;
4843: elsif l_information_type = 'GHR_US_PAR_FOR_LANG_PROF_PAY' then
4844: hr_utility.set_location(l_proc,110);
4845: hr_utility.set_location('info type ' || l_information_type,22);
4840: hr_utility.set_location(l_proc,105);
4841: hr_utility.set_location('info type ' || l_information_type,21);
4842: entitlement;
4843: elsif l_information_type = 'GHR_US_PAR_FOR_LANG_PROF_PAY' then
4844: hr_utility.set_location(l_proc,110);
4845: hr_utility.set_location('info type ' || l_information_type,22);
4846: for_lang_pay;
4847: elsif l_information_type = 'GHR_US_PAR_EDP_PAY' then
4848: hr_utility.set_location(l_proc,115);
4841: hr_utility.set_location('info type ' || l_information_type,21);
4842: entitlement;
4843: elsif l_information_type = 'GHR_US_PAR_FOR_LANG_PROF_PAY' then
4844: hr_utility.set_location(l_proc,110);
4845: hr_utility.set_location('info type ' || l_information_type,22);
4846: for_lang_pay;
4847: elsif l_information_type = 'GHR_US_PAR_EDP_PAY' then
4848: hr_utility.set_location(l_proc,115);
4849: hr_utility.set_location('info type ' || l_information_type,23);
4844: hr_utility.set_location(l_proc,110);
4845: hr_utility.set_location('info type ' || l_information_type,22);
4846: for_lang_pay;
4847: elsif l_information_type = 'GHR_US_PAR_EDP_PAY' then
4848: hr_utility.set_location(l_proc,115);
4849: hr_utility.set_location('info type ' || l_information_type,23);
4850: edp_pay;
4851: elsif l_information_type = 'GHR_US_PAR_HAZARD_PAY' then
4852: hr_utility.set_location(l_proc,116);
4845: hr_utility.set_location('info type ' || l_information_type,22);
4846: for_lang_pay;
4847: elsif l_information_type = 'GHR_US_PAR_EDP_PAY' then
4848: hr_utility.set_location(l_proc,115);
4849: hr_utility.set_location('info type ' || l_information_type,23);
4850: edp_pay;
4851: elsif l_information_type = 'GHR_US_PAR_HAZARD_PAY' then
4852: hr_utility.set_location(l_proc,116);
4853: hr_utility.set_location('info type ' || l_information_type,24);
4848: hr_utility.set_location(l_proc,115);
4849: hr_utility.set_location('info type ' || l_information_type,23);
4850: edp_pay;
4851: elsif l_information_type = 'GHR_US_PAR_HAZARD_PAY' then
4852: hr_utility.set_location(l_proc,116);
4853: hr_utility.set_location('info type ' || l_information_type,24);
4854: hazard_pay;
4855: /* Commented Out as as all future benefits enrollments are either
4856: through the Benefits PUI or FEHB module
4849: hr_utility.set_location('info type ' || l_information_type,23);
4850: edp_pay;
4851: elsif l_information_type = 'GHR_US_PAR_HAZARD_PAY' then
4852: hr_utility.set_location(l_proc,116);
4853: hr_utility.set_location('info type ' || l_information_type,24);
4854: hazard_pay;
4855: /* Commented Out as as all future benefits enrollments are either
4856: through the Benefits PUI or FEHB module
4857: elsif l_information_type = 'GHR_US_PAR_HEALTH_BENEFITS' then
4854: hazard_pay;
4855: /* Commented Out as as all future benefits enrollments are either
4856: through the Benefits PUI or FEHB module
4857: elsif l_information_type = 'GHR_US_PAR_HEALTH_BENEFITS' then
4858: hr_utility.set_location(l_proc,120);
4859: hr_utility.set_location('info type ' || l_information_type,25);
4860: health_benefits;
4861: elsif l_information_type = 'GHR_US_PAR_HEALTH_BEN_PRE_TAX' then
4862: hr_utility.set_location(l_proc,121);
4855: /* Commented Out as as all future benefits enrollments are either
4856: through the Benefits PUI or FEHB module
4857: elsif l_information_type = 'GHR_US_PAR_HEALTH_BENEFITS' then
4858: hr_utility.set_location(l_proc,120);
4859: hr_utility.set_location('info type ' || l_information_type,25);
4860: health_benefits;
4861: elsif l_information_type = 'GHR_US_PAR_HEALTH_BEN_PRE_TAX' then
4862: hr_utility.set_location(l_proc,121);
4863: hr_utility.set_location('info type ' || l_information_type,25);
4858: hr_utility.set_location(l_proc,120);
4859: hr_utility.set_location('info type ' || l_information_type,25);
4860: health_benefits;
4861: elsif l_information_type = 'GHR_US_PAR_HEALTH_BEN_PRE_TAX' then
4862: hr_utility.set_location(l_proc,121);
4863: hr_utility.set_location('info type ' || l_information_type,25);
4864: health_ben_pre_tax;
4865: */
4866: elsif l_information_type = 'GHR_US_PAR_DANGER_PAY' then
4859: hr_utility.set_location('info type ' || l_information_type,25);
4860: health_benefits;
4861: elsif l_information_type = 'GHR_US_PAR_HEALTH_BEN_PRE_TAX' then
4862: hr_utility.set_location(l_proc,121);
4863: hr_utility.set_location('info type ' || l_information_type,25);
4864: health_ben_pre_tax;
4865: */
4866: elsif l_information_type = 'GHR_US_PAR_DANGER_PAY' then
4867: hr_utility.set_location(l_proc,125);
4863: hr_utility.set_location('info type ' || l_information_type,25);
4864: health_ben_pre_tax;
4865: */
4866: elsif l_information_type = 'GHR_US_PAR_DANGER_PAY' then
4867: hr_utility.set_location(l_proc,125);
4868: hr_utility.set_location('info type ' || l_information_type,26);
4869: danger_pay;
4870: elsif l_information_type = 'GHR_US_PAR_IMMNT_DANGER_PAY' then
4871: hr_utility.set_location(l_proc,130);
4864: health_ben_pre_tax;
4865: */
4866: elsif l_information_type = 'GHR_US_PAR_DANGER_PAY' then
4867: hr_utility.set_location(l_proc,125);
4868: hr_utility.set_location('info type ' || l_information_type,26);
4869: danger_pay;
4870: elsif l_information_type = 'GHR_US_PAR_IMMNT_DANGER_PAY' then
4871: hr_utility.set_location(l_proc,130);
4872: hr_utility.set_location('info type ' || l_information_type,27);
4867: hr_utility.set_location(l_proc,125);
4868: hr_utility.set_location('info type ' || l_information_type,26);
4869: danger_pay;
4870: elsif l_information_type = 'GHR_US_PAR_IMMNT_DANGER_PAY' then
4871: hr_utility.set_location(l_proc,130);
4872: hr_utility.set_location('info type ' || l_information_type,27);
4873: imminent_danger_pay;
4874: elsif l_information_type = 'GHR_US_PAR_LIVING_QUART_ALLOW' then
4875: hr_utility.set_location(l_proc,135);
4868: hr_utility.set_location('info type ' || l_information_type,26);
4869: danger_pay;
4870: elsif l_information_type = 'GHR_US_PAR_IMMNT_DANGER_PAY' then
4871: hr_utility.set_location(l_proc,130);
4872: hr_utility.set_location('info type ' || l_information_type,27);
4873: imminent_danger_pay;
4874: elsif l_information_type = 'GHR_US_PAR_LIVING_QUART_ALLOW' then
4875: hr_utility.set_location(l_proc,135);
4876: hr_utility.set_location('info type ' || l_information_type,28);
4871: hr_utility.set_location(l_proc,130);
4872: hr_utility.set_location('info type ' || l_information_type,27);
4873: imminent_danger_pay;
4874: elsif l_information_type = 'GHR_US_PAR_LIVING_QUART_ALLOW' then
4875: hr_utility.set_location(l_proc,135);
4876: hr_utility.set_location('info type ' || l_information_type,28);
4877: living_quarters_allow;
4878: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_PERCENT' then
4879: hr_utility.set_location(l_proc,140);
4872: hr_utility.set_location('info type ' || l_information_type,27);
4873: imminent_danger_pay;
4874: elsif l_information_type = 'GHR_US_PAR_LIVING_QUART_ALLOW' then
4875: hr_utility.set_location(l_proc,135);
4876: hr_utility.set_location('info type ' || l_information_type,28);
4877: living_quarters_allow;
4878: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_PERCENT' then
4879: hr_utility.set_location(l_proc,140);
4880: hr_utility.set_location('info type ' || l_information_type,29);
4875: hr_utility.set_location(l_proc,135);
4876: hr_utility.set_location('info type ' || l_information_type,28);
4877: living_quarters_allow;
4878: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_PERCENT' then
4879: hr_utility.set_location(l_proc,140);
4880: hr_utility.set_location('info type ' || l_information_type,29);
4881: post_diff_percent;
4882: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_AMOUNT' then
4883: hr_utility.set_location(l_proc,145);
4876: hr_utility.set_location('info type ' || l_information_type,28);
4877: living_quarters_allow;
4878: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_PERCENT' then
4879: hr_utility.set_location(l_proc,140);
4880: hr_utility.set_location('info type ' || l_information_type,29);
4881: post_diff_percent;
4882: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_AMOUNT' then
4883: hr_utility.set_location(l_proc,145);
4884: hr_utility.set_location('info type ' || l_information_type,30);
4879: hr_utility.set_location(l_proc,140);
4880: hr_utility.set_location('info type ' || l_information_type,29);
4881: post_diff_percent;
4882: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_AMOUNT' then
4883: hr_utility.set_location(l_proc,145);
4884: hr_utility.set_location('info type ' || l_information_type,30);
4885: post_diff_amt;
4886: elsif l_information_type = 'GHR_US_PAR_SEP_MAINT_ALLOWANCE' then
4887: hr_utility.set_location(l_proc,150);
4880: hr_utility.set_location('info type ' || l_information_type,29);
4881: post_diff_percent;
4882: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_AMOUNT' then
4883: hr_utility.set_location(l_proc,145);
4884: hr_utility.set_location('info type ' || l_information_type,30);
4885: post_diff_amt;
4886: elsif l_information_type = 'GHR_US_PAR_SEP_MAINT_ALLOWANCE' then
4887: hr_utility.set_location(l_proc,150);
4888: hr_utility.set_location('info type ' || l_information_type,31);
4883: hr_utility.set_location(l_proc,145);
4884: hr_utility.set_location('info type ' || l_information_type,30);
4885: post_diff_amt;
4886: elsif l_information_type = 'GHR_US_PAR_SEP_MAINT_ALLOWANCE' then
4887: hr_utility.set_location(l_proc,150);
4888: hr_utility.set_location('info type ' || l_information_type,31);
4889: sep_maintenance_allow;
4890: elsif l_information_type = 'GHR_US_PAR_SUP_POST_ALLOWANCE' then
4891: hr_utility.set_location(l_proc,155);
4884: hr_utility.set_location('info type ' || l_information_type,30);
4885: post_diff_amt;
4886: elsif l_information_type = 'GHR_US_PAR_SEP_MAINT_ALLOWANCE' then
4887: hr_utility.set_location(l_proc,150);
4888: hr_utility.set_location('info type ' || l_information_type,31);
4889: sep_maintenance_allow;
4890: elsif l_information_type = 'GHR_US_PAR_SUP_POST_ALLOWANCE' then
4891: hr_utility.set_location(l_proc,155);
4892: hr_utility.set_location('info type ' || l_information_type,32);
4887: hr_utility.set_location(l_proc,150);
4888: hr_utility.set_location('info type ' || l_information_type,31);
4889: sep_maintenance_allow;
4890: elsif l_information_type = 'GHR_US_PAR_SUP_POST_ALLOWANCE' then
4891: hr_utility.set_location(l_proc,155);
4892: hr_utility.set_location('info type ' || l_information_type,32);
4893: supplemental_post_allow;
4894: elsif l_information_type = 'GHR_US_PAR_TMP_LODGE_ALLOWANCE' then
4895: hr_utility.set_location(l_proc,160);
4888: hr_utility.set_location('info type ' || l_information_type,31);
4889: sep_maintenance_allow;
4890: elsif l_information_type = 'GHR_US_PAR_SUP_POST_ALLOWANCE' then
4891: hr_utility.set_location(l_proc,155);
4892: hr_utility.set_location('info type ' || l_information_type,32);
4893: supplemental_post_allow;
4894: elsif l_information_type = 'GHR_US_PAR_TMP_LODGE_ALLOWANCE' then
4895: hr_utility.set_location(l_proc,160);
4896: hr_utility.set_location('info type ' || l_information_type,33);
4891: hr_utility.set_location(l_proc,155);
4892: hr_utility.set_location('info type ' || l_information_type,32);
4893: supplemental_post_allow;
4894: elsif l_information_type = 'GHR_US_PAR_TMP_LODGE_ALLOWANCE' then
4895: hr_utility.set_location(l_proc,160);
4896: hr_utility.set_location('info type ' || l_information_type,33);
4897: temp_lodge_allow;
4898: elsif l_information_type = 'GHR_US_PAR_PREMIUM_PAY' then
4899: hr_utility.set_location(l_proc,165);
4892: hr_utility.set_location('info type ' || l_information_type,32);
4893: supplemental_post_allow;
4894: elsif l_information_type = 'GHR_US_PAR_TMP_LODGE_ALLOWANCE' then
4895: hr_utility.set_location(l_proc,160);
4896: hr_utility.set_location('info type ' || l_information_type,33);
4897: temp_lodge_allow;
4898: elsif l_information_type = 'GHR_US_PAR_PREMIUM_PAY' then
4899: hr_utility.set_location(l_proc,165);
4900: hr_utility.set_location('info type ' || l_information_type,34);
4895: hr_utility.set_location(l_proc,160);
4896: hr_utility.set_location('info type ' || l_information_type,33);
4897: temp_lodge_allow;
4898: elsif l_information_type = 'GHR_US_PAR_PREMIUM_PAY' then
4899: hr_utility.set_location(l_proc,165);
4900: hr_utility.set_location('info type ' || l_information_type,34);
4901: premium_pay;
4902: elsif l_information_type = 'GHR_US_PAR_RETIREMENT_ANNUITY' then
4903: hr_utility.set_location(l_proc,170);
4896: hr_utility.set_location('info type ' || l_information_type,33);
4897: temp_lodge_allow;
4898: elsif l_information_type = 'GHR_US_PAR_PREMIUM_PAY' then
4899: hr_utility.set_location(l_proc,165);
4900: hr_utility.set_location('info type ' || l_information_type,34);
4901: premium_pay;
4902: elsif l_information_type = 'GHR_US_PAR_RETIREMENT_ANNUITY' then
4903: hr_utility.set_location(l_proc,170);
4904: hr_utility.set_location('info type ' || l_information_type,35);
4899: hr_utility.set_location(l_proc,165);
4900: hr_utility.set_location('info type ' || l_information_type,34);
4901: premium_pay;
4902: elsif l_information_type = 'GHR_US_PAR_RETIREMENT_ANNUITY' then
4903: hr_utility.set_location(l_proc,170);
4904: hr_utility.set_location('info type ' || l_information_type,35);
4905: retirement_annuity;
4906: elsif l_information_type = 'GHR_US_PAR_SEVERANCE_PAY' then
4907: hr_utility.set_location(l_proc,175);
4900: hr_utility.set_location('info type ' || l_information_type,34);
4901: premium_pay;
4902: elsif l_information_type = 'GHR_US_PAR_RETIREMENT_ANNUITY' then
4903: hr_utility.set_location(l_proc,170);
4904: hr_utility.set_location('info type ' || l_information_type,35);
4905: retirement_annuity;
4906: elsif l_information_type = 'GHR_US_PAR_SEVERANCE_PAY' then
4907: hr_utility.set_location(l_proc,175);
4908: hr_utility.set_location('info type ' || l_information_type,36);
4903: hr_utility.set_location(l_proc,170);
4904: hr_utility.set_location('info type ' || l_information_type,35);
4905: retirement_annuity;
4906: elsif l_information_type = 'GHR_US_PAR_SEVERANCE_PAY' then
4907: hr_utility.set_location(l_proc,175);
4908: hr_utility.set_location('info type ' || l_information_type,36);
4909: severance_pay;
4910: /*elsif l_information_type = 'GHR_US_PAR_TSP' then
4911: hr_utility.set_location(l_proc,180);
4904: hr_utility.set_location('info type ' || l_information_type,35);
4905: retirement_annuity;
4906: elsif l_information_type = 'GHR_US_PAR_SEVERANCE_PAY' then
4907: hr_utility.set_location(l_proc,175);
4908: hr_utility.set_location('info type ' || l_information_type,36);
4909: severance_pay;
4910: /*elsif l_information_type = 'GHR_US_PAR_TSP' then
4911: hr_utility.set_location(l_proc,180);
4912: hr_utility.set_location('info type ' || l_information_type,37);
4907: hr_utility.set_location(l_proc,175);
4908: hr_utility.set_location('info type ' || l_information_type,36);
4909: severance_pay;
4910: /*elsif l_information_type = 'GHR_US_PAR_TSP' then
4911: hr_utility.set_location(l_proc,180);
4912: hr_utility.set_location('info type ' || l_information_type,37);
4913: thrift_saving_plan;*/
4914: elsif l_information_type = 'GHR_US_PAR_RET_ALLOWANCE' then
4915: hr_utility.set_location(l_proc,180);
4908: hr_utility.set_location('info type ' || l_information_type,36);
4909: severance_pay;
4910: /*elsif l_information_type = 'GHR_US_PAR_TSP' then
4911: hr_utility.set_location(l_proc,180);
4912: hr_utility.set_location('info type ' || l_information_type,37);
4913: thrift_saving_plan;*/
4914: elsif l_information_type = 'GHR_US_PAR_RET_ALLOWANCE' then
4915: hr_utility.set_location(l_proc,180);
4916: hr_utility.set_location('info type ' || l_information_type,37);
4911: hr_utility.set_location(l_proc,180);
4912: hr_utility.set_location('info type ' || l_information_type,37);
4913: thrift_saving_plan;*/
4914: elsif l_information_type = 'GHR_US_PAR_RET_ALLOWANCE' then
4915: hr_utility.set_location(l_proc,180);
4916: hr_utility.set_location('info type ' || l_information_type,37);
4917: retention_allow_review;
4918: elsif l_information_type = 'GHR_US_PAR_CHG_TEN' then
4919: hr_utility.set_location(l_proc,110);
4912: hr_utility.set_location('info type ' || l_information_type,37);
4913: thrift_saving_plan;*/
4914: elsif l_information_type = 'GHR_US_PAR_RET_ALLOWANCE' then
4915: hr_utility.set_location(l_proc,180);
4916: hr_utility.set_location('info type ' || l_information_type,37);
4917: retention_allow_review;
4918: elsif l_information_type = 'GHR_US_PAR_CHG_TEN' then
4919: hr_utility.set_location(l_proc,110);
4920: chg_in_tenure;
4915: hr_utility.set_location(l_proc,180);
4916: hr_utility.set_location('info type ' || l_information_type,37);
4917: retention_allow_review;
4918: elsif l_information_type = 'GHR_US_PAR_CHG_TEN' then
4919: hr_utility.set_location(l_proc,110);
4920: chg_in_tenure;
4921: --Bug#2759379 Added FEGLI related Code
4922: elsif l_information_type = 'GHR_US_PAR_FEGLI' then
4923: hr_utility.set_location(l_proc,110);
4919: hr_utility.set_location(l_proc,110);
4920: chg_in_tenure;
4921: --Bug#2759379 Added FEGLI related Code
4922: elsif l_information_type = 'GHR_US_PAR_FEGLI' then
4923: hr_utility.set_location(l_proc,110);
4924: chg_in_fegli;
4925: elsif l_information_type = 'GHR_US_PAR_MD_DDS_PAY' then
4926: hr_utility.set_location(l_proc,200);
4927: mddds_pay;
4922: elsif l_information_type = 'GHR_US_PAR_FEGLI' then
4923: hr_utility.set_location(l_proc,110);
4924: chg_in_fegli;
4925: elsif l_information_type = 'GHR_US_PAR_MD_DDS_PAY' then
4926: hr_utility.set_location(l_proc,200);
4927: mddds_pay;
4928: elsif l_information_type = 'GHR_US_PAR_PREMIUM_PAY_IND' then
4929: hr_utility.set_location(l_proc,200);
4930: premium_pay_ind;
4925: elsif l_information_type = 'GHR_US_PAR_MD_DDS_PAY' then
4926: hr_utility.set_location(l_proc,200);
4927: mddds_pay;
4928: elsif l_information_type = 'GHR_US_PAR_PREMIUM_PAY_IND' then
4929: hr_utility.set_location(l_proc,200);
4930: premium_pay_ind;
4931: elsif l_information_type = 'GHR_US_PAR_STUDENT_LOAN' then
4932: hr_utility.set_location(l_proc,190);
4933: student_loan_repay;
4928: elsif l_information_type = 'GHR_US_PAR_PREMIUM_PAY_IND' then
4929: hr_utility.set_location(l_proc,200);
4930: premium_pay_ind;
4931: elsif l_information_type = 'GHR_US_PAR_STUDENT_LOAN' then
4932: hr_utility.set_location(l_proc,190);
4933: student_loan_repay;
4934: -- Bug#3385386 Added FTA condition.
4935: elsif l_information_type = 'GHR_US_PAR_FOR_TRANSER_ALLOW' then
4936: hr_utility.set_location(l_proc,210);
4932: hr_utility.set_location(l_proc,190);
4933: student_loan_repay;
4934: -- Bug#3385386 Added FTA condition.
4935: elsif l_information_type = 'GHR_US_PAR_FOR_TRANSER_ALLOW' then
4936: hr_utility.set_location(l_proc,210);
4937: hr_utility.set_location('info type ' || l_information_type,22);
4938: fta;
4939: elsif l_information_type = 'GHR_US_PAR_BENEFITS' then
4940: hr_utility.set_location(l_proc,210);
4933: student_loan_repay;
4934: -- Bug#3385386 Added FTA condition.
4935: elsif l_information_type = 'GHR_US_PAR_FOR_TRANSER_ALLOW' then
4936: hr_utility.set_location(l_proc,210);
4937: hr_utility.set_location('info type ' || l_information_type,22);
4938: fta;
4939: elsif l_information_type = 'GHR_US_PAR_BENEFITS' then
4940: hr_utility.set_location(l_proc,210);
4941: hr_utility.set_location('info type ' || l_information_type,22);
4936: hr_utility.set_location(l_proc,210);
4937: hr_utility.set_location('info type ' || l_information_type,22);
4938: fta;
4939: elsif l_information_type = 'GHR_US_PAR_BENEFITS' then
4940: hr_utility.set_location(l_proc,210);
4941: hr_utility.set_location('info type ' || l_information_type,22);
4942: appt_benefits;
4943: elsif l_information_type = 'GHR_US_PAR_MASS_TERM' then
4944: hr_utility.set_location(l_proc,210);
4937: hr_utility.set_location('info type ' || l_information_type,22);
4938: fta;
4939: elsif l_information_type = 'GHR_US_PAR_BENEFITS' then
4940: hr_utility.set_location(l_proc,210);
4941: hr_utility.set_location('info type ' || l_information_type,22);
4942: appt_benefits;
4943: elsif l_information_type = 'GHR_US_PAR_MASS_TERM' then
4944: hr_utility.set_location(l_proc,210);
4945: hr_utility.set_location('info type ' || l_information_type,22);
4940: hr_utility.set_location(l_proc,210);
4941: hr_utility.set_location('info type ' || l_information_type,22);
4942: appt_benefits;
4943: elsif l_information_type = 'GHR_US_PAR_MASS_TERM' then
4944: hr_utility.set_location(l_proc,210);
4945: hr_utility.set_location('info type ' || l_information_type,22);
4946: separate352;
4947: -- Bug 4724337 Race or National Origin changes
4948: elsif l_information_type = 'GHR_US_PAR_ETHNICITY_RACE' then
4941: hr_utility.set_location('info type ' || l_information_type,22);
4942: appt_benefits;
4943: elsif l_information_type = 'GHR_US_PAR_MASS_TERM' then
4944: hr_utility.set_location(l_proc,210);
4945: hr_utility.set_location('info type ' || l_information_type,22);
4946: separate352;
4947: -- Bug 4724337 Race or National Origin changes
4948: elsif l_information_type = 'GHR_US_PAR_ETHNICITY_RACE' then
4949: hr_utility.set_location(l_proc,210);
4945: hr_utility.set_location('info type ' || l_information_type,22);
4946: separate352;
4947: -- Bug 4724337 Race or National Origin changes
4948: elsif l_information_type = 'GHR_US_PAR_ETHNICITY_RACE' then
4949: hr_utility.set_location(l_proc,210);
4950: hr_utility.set_location('info type ' || l_information_type,22);
4951: race_ethnic_info;
4952: -- Bug 4486823 RRR Changes
4953: elsif l_information_type = 'GHR_US_PAR_SERVICE_OBLIGATION' then
4946: separate352;
4947: -- Bug 4724337 Race or National Origin changes
4948: elsif l_information_type = 'GHR_US_PAR_ETHNICITY_RACE' then
4949: hr_utility.set_location(l_proc,210);
4950: hr_utility.set_location('info type ' || l_information_type,22);
4951: race_ethnic_info;
4952: -- Bug 4486823 RRR Changes
4953: elsif l_information_type = 'GHR_US_PAR_SERVICE_OBLIGATION' then
4954: hr_utility.set_location(l_proc,220);
4950: hr_utility.set_location('info type ' || l_information_type,22);
4951: race_ethnic_info;
4952: -- Bug 4486823 RRR Changes
4953: elsif l_information_type = 'GHR_US_PAR_SERVICE_OBLIGATION' then
4954: hr_utility.set_location(l_proc,220);
4955: hr_utility.set_location('info type ' || l_information_type,22);
4956: service_obligation;
4957: -- Bug 4724337 Race or National Origin changes
4958: elsif l_information_type = 'GHR_US_PAR_RETENTION_INCENTIVE' then
4951: race_ethnic_info;
4952: -- Bug 4486823 RRR Changes
4953: elsif l_information_type = 'GHR_US_PAR_SERVICE_OBLIGATION' then
4954: hr_utility.set_location(l_proc,220);
4955: hr_utility.set_location('info type ' || l_information_type,22);
4956: service_obligation;
4957: -- Bug 4724337 Race or National Origin changes
4958: elsif l_information_type = 'GHR_US_PAR_RETENTION_INCENTIVE' then
4959: hr_utility.set_location(l_proc,230);
4955: hr_utility.set_location('info type ' || l_information_type,22);
4956: service_obligation;
4957: -- Bug 4724337 Race or National Origin changes
4958: elsif l_information_type = 'GHR_US_PAR_RETENTION_INCENTIVE' then
4959: hr_utility.set_location(l_proc,230);
4960: hr_utility.set_location('info type ' || l_information_type,22);
4961: incentive_retention;
4962: -- Bug 4486823 RRR Changes
4963: elsif l_information_type = 'GHR_US_PAR_EMERG_ESSNTL_ASG' then
4956: service_obligation;
4957: -- Bug 4724337 Race or National Origin changes
4958: elsif l_information_type = 'GHR_US_PAR_RETENTION_INCENTIVE' then
4959: hr_utility.set_location(l_proc,230);
4960: hr_utility.set_location('info type ' || l_information_type,22);
4961: incentive_retention;
4962: -- Bug 4486823 RRR Changes
4963: elsif l_information_type = 'GHR_US_PAR_EMERG_ESSNTL_ASG' then
4964: hr_utility.set_location(l_proc,240);
4960: hr_utility.set_location('info type ' || l_information_type,22);
4961: incentive_retention;
4962: -- Bug 4486823 RRR Changes
4963: elsif l_information_type = 'GHR_US_PAR_EMERG_ESSNTL_ASG' then
4964: hr_utility.set_location(l_proc,240);
4965: hr_utility.set_location('info type ' || l_information_type,22);
4966: key_emergency_essntl;
4967: -- Bug 4280026 Key Emergency Essential Changes .
4968: -- Begin Bug# 4126188
4961: incentive_retention;
4962: -- Bug 4486823 RRR Changes
4963: elsif l_information_type = 'GHR_US_PAR_EMERG_ESSNTL_ASG' then
4964: hr_utility.set_location(l_proc,240);
4965: hr_utility.set_location('info type ' || l_information_type,22);
4966: key_emergency_essntl;
4967: -- Bug 4280026 Key Emergency Essential Changes .
4968: -- Begin Bug# 4126188
4969: elsif l_information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG' then
4966: key_emergency_essntl;
4967: -- Bug 4280026 Key Emergency Essential Changes .
4968: -- Begin Bug# 4126188
4969: elsif l_information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG' then
4970: hr_utility.set_location(l_proc,250);
4971: hr_utility.set_location('info type ' || l_information_type,22);
4972: rg_posn_chg;
4973: -- end Bug# 4126188
4974: elsif l_information_type = 'GHR_US_PAR_CONVERSION_DATES' then
4967: -- Bug 4280026 Key Emergency Essential Changes .
4968: -- Begin Bug# 4126188
4969: elsif l_information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG' then
4970: hr_utility.set_location(l_proc,250);
4971: hr_utility.set_location('info type ' || l_information_type,22);
4972: rg_posn_chg;
4973: -- end Bug# 4126188
4974: elsif l_information_type = 'GHR_US_PAR_CONVERSION_DATES' then
4975: hr_utility.set_location(l_proc,260);
4971: hr_utility.set_location('info type ' || l_information_type,22);
4972: rg_posn_chg;
4973: -- end Bug# 4126188
4974: elsif l_information_type = 'GHR_US_PAR_CONVERSION_DATES' then
4975: hr_utility.set_location(l_proc,260);
4976: hr_utility.set_location('info type ' || l_information_type,22);
4977: ghr_conv_dates;
4978: -- Bug 5482191
4979: --start of Bug# 6312144
4972: rg_posn_chg;
4973: -- end Bug# 4126188
4974: elsif l_information_type = 'GHR_US_PAR_CONVERSION_DATES' then
4975: hr_utility.set_location(l_proc,260);
4976: hr_utility.set_location('info type ' || l_information_type,22);
4977: ghr_conv_dates;
4978: -- Bug 5482191
4979: --start of Bug# 6312144
4980: elsif l_information_type = 'GHR_US_PAR_BENEFITS_CONT' then
4977: ghr_conv_dates;
4978: -- Bug 5482191
4979: --start of Bug# 6312144
4980: elsif l_information_type = 'GHR_US_PAR_BENEFITS_CONT' then
4981: hr_utility.set_location(l_proc,270);
4982: hr_utility.set_location('info type ' || l_information_type,22);
4983: ipa_benefits_cont;
4984: elsif l_information_type = 'GHR_US_PAR_BENEFIT_INFO' then
4985: hr_utility.set_location(l_proc,280);
4978: -- Bug 5482191
4979: --start of Bug# 6312144
4980: elsif l_information_type = 'GHR_US_PAR_BENEFITS_CONT' then
4981: hr_utility.set_location(l_proc,270);
4982: hr_utility.set_location('info type ' || l_information_type,22);
4983: ipa_benefits_cont;
4984: elsif l_information_type = 'GHR_US_PAR_BENEFIT_INFO' then
4985: hr_utility.set_location(l_proc,280);
4986: hr_utility.set_location('info type ' || l_information_type,22);
4981: hr_utility.set_location(l_proc,270);
4982: hr_utility.set_location('info type ' || l_information_type,22);
4983: ipa_benefits_cont;
4984: elsif l_information_type = 'GHR_US_PAR_BENEFIT_INFO' then
4985: hr_utility.set_location(l_proc,280);
4986: hr_utility.set_location('info type ' || l_information_type,22);
4987: ben_info_cont;
4988: elsif l_information_type = 'GHR_US_PAR_RETIRMENT_SYS_INFO' then
4989: hr_utility.set_location(l_proc,290);
4982: hr_utility.set_location('info type ' || l_information_type,22);
4983: ipa_benefits_cont;
4984: elsif l_information_type = 'GHR_US_PAR_BENEFIT_INFO' then
4985: hr_utility.set_location(l_proc,280);
4986: hr_utility.set_location('info type ' || l_information_type,22);
4987: ben_info_cont;
4988: elsif l_information_type = 'GHR_US_PAR_RETIRMENT_SYS_INFO' then
4989: hr_utility.set_location(l_proc,290);
4990: hr_utility.set_location('info type ' || l_information_type,22);
4985: hr_utility.set_location(l_proc,280);
4986: hr_utility.set_location('info type ' || l_information_type,22);
4987: ben_info_cont;
4988: elsif l_information_type = 'GHR_US_PAR_RETIRMENT_SYS_INFO' then
4989: hr_utility.set_location(l_proc,290);
4990: hr_utility.set_location('info type ' || l_information_type,22);
4991: retirement_info;
4992: --end of Bug# 6312144
4993: /* --Begin Bug# 4588575
4986: hr_utility.set_location('info type ' || l_information_type,22);
4987: ben_info_cont;
4988: elsif l_information_type = 'GHR_US_PAR_RETIRMENT_SYS_INFO' then
4989: hr_utility.set_location(l_proc,290);
4990: hr_utility.set_location('info type ' || l_information_type,22);
4991: retirement_info;
4992: --end of Bug# 6312144
4993: /* --Begin Bug# 4588575
4994: elsif l_information_type = 'GHR_US_PAR_PROBATION_INFO' then
4991: retirement_info;
4992: --end of Bug# 6312144
4993: /* --Begin Bug# 4588575
4994: elsif l_information_type = 'GHR_US_PAR_PROBATION_INFO' then
4995: hr_utility.set_location(l_proc,270);
4996: hr_utility.set_location('info type ' || l_information_type,270);
4997: ghr_prob_info;
4998: elsif l_information_type = 'GHR_US_PAR_SCD_INFO' then
4999: hr_utility.set_location(l_proc,280);
4992: --end of Bug# 6312144
4993: /* --Begin Bug# 4588575
4994: elsif l_information_type = 'GHR_US_PAR_PROBATION_INFO' then
4995: hr_utility.set_location(l_proc,270);
4996: hr_utility.set_location('info type ' || l_information_type,270);
4997: ghr_prob_info;
4998: elsif l_information_type = 'GHR_US_PAR_SCD_INFO' then
4999: hr_utility.set_location(l_proc,280);
5000: hr_utility.set_location('info type ' || l_information_type,280);
4995: hr_utility.set_location(l_proc,270);
4996: hr_utility.set_location('info type ' || l_information_type,270);
4997: ghr_prob_info;
4998: elsif l_information_type = 'GHR_US_PAR_SCD_INFO' then
4999: hr_utility.set_location(l_proc,280);
5000: hr_utility.set_location('info type ' || l_information_type,280);
5001: chg_scd_info;
5002: --end Bug# 4588575
5003: */ --Backout the changes done for Bug# 4588575
4996: hr_utility.set_location('info type ' || l_information_type,270);
4997: ghr_prob_info;
4998: elsif l_information_type = 'GHR_US_PAR_SCD_INFO' then
4999: hr_utility.set_location(l_proc,280);
5000: hr_utility.set_location('info type ' || l_information_type,280);
5001: chg_scd_info;
5002: --end Bug# 4588575
5003: */ --Backout the changes done for Bug# 4588575
5004: end if;
5023: -- Bug#5668878 End
5024: -- Rohini
5025: l_noa_code := p_pa_request_rec.first_noa_code;
5026: /* if l_noa_code = '352' then
5027: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
5028: p_per_separate_retire.agency_code_transfer_to ,38);
5029: set_extra_info(p_per_separate_retire.agency_code_transfer_to,
5030: l_pa_request_ei_rec.rei_information3,
5031: ------ AVR p_pa_request_rec.first_noa_information1,
5029: set_extra_info(p_per_separate_retire.agency_code_transfer_to,
5030: l_pa_request_ei_rec.rei_information3,
5031: ------ AVR p_pa_request_rec.first_noa_information1,
5032: p_per_separate_Retire.per_sep_Retire_flag);
5033: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
5034: p_per_separate_retire.agency_code_transfer_to ,38);
5035: End if; */
5036: --
5037: -- Process Generic Agency information
5051: for asg_stat_rec in c_user_status loop
5052: l_old_user_status := asg_stat_rec.user_status;
5053: l_old_system_status := asg_stat_rec.per_system_status;
5054: l_old_effective_start_date := asg_stat_rec.effective_start_date -1;
5055: hr_utility.set_location('Old User status is '||l_old_user_status,96);
5056: exit;
5057: end loop;
5058: -- Bug# 4672772 End
5059:
5056: exit;
5057: end loop;
5058: -- Bug# 4672772 End
5059:
5060: hr_utility.set_location('Leaving - process_non_sf52_extra_info',170);
5061:
5062: -- NTE start dates processing
5063: -- Added 515 -- Venkat 04/26
5064: If l_noa_code in ('108','115','117','122','148','149','153',
5065: '154','171','190','508','515','517','522','548',
5066: '549','553','554','571','590','741') then
5067: --Bug# 4602352 703 is removed from the list
5068: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5069: hr_utility.set_location('inside asg nte dates ',1);
5070: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5071: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5072: --Begin Bug# 4602352
5073: Elsif l_noa_code ='703' and (l_old_user_status <> 'Term Limited Appt') THEN
5066: '549','553','554','571','590','741') then
5067: --Bug# 4602352 703 is removed from the list
5068: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5069: hr_utility.set_location('inside asg nte dates ',1);
5070: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5071: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5072: --Begin Bug# 4602352
5073: Elsif l_noa_code ='703' and (l_old_user_status <> 'Term Limited Appt') THEN
5074: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5071: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5072: --Begin Bug# 4602352
5073: Elsif l_noa_code ='703' and (l_old_user_status <> 'Term Limited Appt') THEN
5074: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5075: hr_utility.set_location('inside asg nte dates for 703 ',111);
5076: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5077: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5078: --End Bug# 4602352
5079: Elsif l_noa_code = '472' then
5072: --Begin Bug# 4602352
5073: Elsif l_noa_code ='703' and (l_old_user_status <> 'Term Limited Appt') THEN
5074: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5075: hr_utility.set_location('inside asg nte dates for 703 ',111);
5076: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5077: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5078: --End Bug# 4602352
5079: Elsif l_noa_code = '472' then
5080: p_asg_nte_dates.furlough_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5100: '154','171','190','508','515','517','522',
5101: '548','549','553','554','571','590',--'703', Removed for Bug# 4602352
5102: '741','750','760','761','762','765','769','770') then
5103: p_asg_nte_dates.assignment_nte := p_pa_request_rec.first_noa_information1;
5104: hr_utility.set_location('dates ' || p_asg_nte_dates.assignment_nte,1);
5105: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5106: --Begin Bug# 4602352
5107: Elsif l_noa_code ='703' and (l_old_user_status <> 'Term Limited Appt') THEN
5108: p_asg_nte_dates.assignment_nte := p_pa_request_rec.first_noa_information1;
5105: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5106: --Begin Bug# 4602352
5107: Elsif l_noa_code ='703' and (l_old_user_status <> 'Term Limited Appt') THEN
5108: p_asg_nte_dates.assignment_nte := p_pa_request_rec.first_noa_information1;
5109: hr_utility.set_location('dates ' || p_asg_nte_dates.assignment_nte,100);
5110: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5111: --End Bug# 4602352
5112: Elsif l_noa_code in ('472','772') then
5113: hr_utility.set_location(' furlough nte dates for 472 and 772',1);
5109: hr_utility.set_location('dates ' || p_asg_nte_dates.assignment_nte,100);
5110: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5111: --End Bug# 4602352
5112: Elsif l_noa_code in ('472','772') then
5113: hr_utility.set_location(' furlough nte dates for 472 and 772',1);
5114: p_asg_nte_dates.furlough_nte := p_pa_request_rec.first_noa_information1;
5115: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5116: Elsif l_noa_code = '462' then
5117: p_asg_nte_dates.lwp_nte := p_pa_request_rec.first_noa_information1;