[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: -- *************************
268:
269:
270: Begin
271:
272: hr_utility.set_location('PERSON ID : ' ||to_char(p_pa_request_rec.person_id) ,1);
273: hr_utility.set_location('EMP ID : ' ||to_char(p_pa_request_rec.employee_assignment_id) ,2);
274: hr_utility.set_location('POS ID : ' ||to_char(p_pa_request_rec.to_position_id) ,3);
275:
276:
269:
270: Begin
271:
272: hr_utility.set_location('PERSON ID : ' ||to_char(p_pa_request_rec.person_id) ,1);
273: hr_utility.set_location('EMP ID : ' ||to_char(p_pa_request_rec.employee_assignment_id) ,2);
274: hr_utility.set_location('POS ID : ' ||to_char(p_pa_request_rec.to_position_id) ,3);
275:
276:
277: -- Retrieve all the extra information (required for CPDFs and for update to HR)
270: Begin
271:
272: hr_utility.set_location('PERSON ID : ' ||to_char(p_pa_request_rec.person_id) ,1);
273: hr_utility.set_location('EMP ID : ' ||to_char(p_pa_request_rec.employee_assignment_id) ,2);
274: hr_utility.set_location('POS ID : ' ||to_char(p_pa_request_rec.to_position_id) ,3);
275:
276:
277: -- Retrieve all the extra information (required for CPDFs and for update to HR)
278: -- from the Core Tables and store them in the respective Record Groups
396: p_tsp_roth => l_imm_tsp_roth, --BUG # 13571004
397: p_per_group2 => l_imm_per_group2 --BUG # 14276354
398: );
399:
400: hr_utility.set_location('Relocation Bonus ' || l_imm_relocation_bonus.p_relocation_bonus,1);
401: hr_utility.set_location('Relocation EXP ' || l_imm_relocation_bonus.p_date_reloc_exp,2);
402: hr_utility.set_location('Recruitment EXP ' || l_imm_recruitment_bonus.p_date_recruit_exp,3);
403:
404:
397: p_per_group2 => l_imm_per_group2 --BUG # 14276354
398: );
399:
400: hr_utility.set_location('Relocation Bonus ' || l_imm_relocation_bonus.p_relocation_bonus,1);
401: hr_utility.set_location('Relocation EXP ' || l_imm_relocation_bonus.p_date_reloc_exp,2);
402: hr_utility.set_location('Recruitment EXP ' || l_imm_recruitment_bonus.p_date_recruit_exp,3);
403:
404:
405: -- With the new ghr_pa_requests table, we just need to fetch the agency_code.
398: );
399:
400: hr_utility.set_location('Relocation Bonus ' || l_imm_relocation_bonus.p_relocation_bonus,1);
401: hr_utility.set_location('Relocation EXP ' || l_imm_relocation_bonus.p_date_reloc_exp,2);
402: hr_utility.set_location('Recruitment EXP ' || l_imm_recruitment_bonus.p_date_recruit_exp,3);
403:
404:
405: -- With the new ghr_pa_requests table, we just need to fetch the agency_code.
406: -- And this info. is required by CPDF edits and later by the SF50 Report
447: end loop;
448: Else
449: l_effective_date := p_pa_request_rec.effective_date;
450: End if;
451: hr_utility.set_location('l_effective_date passed to fetch_assignment '||l_effective_date,3 );
452:
453: Ghr_History_Fetch.Fetch_assignment
454: (
455: p_assignment_id => p_pa_request_rec.employee_assignment_id,
462: l_imm_sf52_from_data.duty_station_location_id := l_assignment_data.location_id;
463:
464: End if;
465:
466: hr_utility.set_location('from_duty_station '||l_imm_sf52_from_data.duty_station_location_id,4 );
467:
468:
469: -- Should retrieve Employee_sex(per_people_f for the person_id , for a specific date),
470: -- as it is not stored in the ghr_pa_requests table
516: -- get the session variable
517: ghr_history_api.get_g_session_var(l_session);
518:
519: If l_session.noa_id_correct is null then
520: hr_utility.set_location('populate_record_groups ', 30);
521:
522: ghr_api.return_special_information
523: (p_person_id => p_pa_request_rec.person_id,
524: p_structure_name => 'US Fed Perf Appraisal',
526: p_special_info => l_special_info_type
527: );
528:
529: Else -- for update get from history
530: hr_utility.set_location('populate_record_groups ', 35);
531: ghr_history_fetch.return_special_information
532: (p_person_id => p_pa_request_rec.person_id,
533: p_structure_name => 'US Fed Perf Appraisal',
534: p_effective_date => p_pa_request_rec.effective_date,
566: l_imm_perf_appraisal.performance_rating_points := l_special_info_type.segment16;
567: --Bug# 4753117 28-Feb-07 Veeramani assigning appraisal start date
568: l_imm_perf_appraisal.date_appr_starts := l_special_info_type.segment17;
569:
570: hr_utility.set_location('performance_rating_points'||l_special_info_type.segment16, 39);
571: -- Get user entered details
572: hr_utility.set_location('populate_record_groups ', 40);
573:
574: for perf_appraisal in c_performance_appraisal loop
568: l_imm_perf_appraisal.date_appr_starts := l_special_info_type.segment17;
569:
570: hr_utility.set_location('performance_rating_points'||l_special_info_type.segment16, 39);
571: -- Get user entered details
572: hr_utility.set_location('populate_record_groups ', 40);
573:
574: for perf_appraisal in c_performance_appraisal loop
575:
576: --No need for the IF condition since 'US Fed Perf Appraisal' is a mandatory SIT
662: l_imm_perf_appraisal.optional_information := perf_appraisal.optional_info;
663: l_imm_perf_appraisal.perf_appr_flag := 'Y';
664: end if;
665:
666: hr_utility.set_location('performance_rating_points'||perf_appraisal.performance_rating_points, 41);
667:
668: if nvl(perf_appraisal.performance_rating_points,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.performance_rating_points,hr_api.g_varchar2) then
669: l_imm_perf_appraisal.performance_rating_points := perf_appraisal.performance_rating_points;
670: l_imm_perf_appraisal.perf_appr_flag := 'Y';
884: l_request_id := p_pa_request_id;
885: l_extra_info_id := null;
886: for c1_rec in c1(c_request_id => l_request_id) loop
887: --dbms_output.put_line('inside fetch extra info id loop1');
888: hr_utility.set_location(l_proc,1);
889: l_request_id := c1_rec.altered_pa_request_id;
890: If l_request_id is not null then
891: for c2_rec in c2(l_request_id) loop
892: hr_utility.set_location(l_proc,1);
888: hr_utility.set_location(l_proc,1);
889: l_request_id := c1_rec.altered_pa_request_id;
890: If l_request_id is not null then
891: for c2_rec in c2(l_request_id) loop
892: hr_utility.set_location(l_proc,1);
893: l_extra_info_id := c2_rec.rei_information3;
894: end loop;
895: hr_utility.set_location(l_proc ||'Extra info id is '|| to_char(l_extra_info_id),3);
896: End if;
891: for c2_rec in c2(l_request_id) loop
892: hr_utility.set_location(l_proc,1);
893: l_extra_info_id := c2_rec.rei_information3;
894: end loop;
895: hr_utility.set_location(l_proc ||'Extra info id is '|| to_char(l_extra_info_id),3);
896: End if;
897: If l_extra_info_id is not null then
898: exit;
899: End if;
896: End if;
897: If l_extra_info_id is not null then
898: exit;
899: End if;
900: hr_utility.set_location(l_proc,4);
901: end loop;
902: p_person_extra_info_id := l_extra_info_id;
903: end get_ret_grade;
904:
913: ghr_history_api.get_g_session_var(l_session); -- Bug 3021003
914: -- l_extra_info_rec.l_extra_info_id := null;
915: -- Bug # 1234846 --
916: If p_pa_request_rec.noa_family_code in ('APP','CONV_APP') then
917: hr_utility.set_location(l_proc,12);
918: l_person_type := null;
919: for per_type in c_person_type loop
920: l_person_type := per_type.system_person_type;
921: end loop;
919: for per_type in c_person_type loop
920: l_person_type := per_type.system_person_type;
921: end loop;
922: if l_person_type is null then
923: hr_utility.set_message(8301,'GHR_38133_INVALID_PERSON');
924: hr_utility.raise_error;
925: end if;
926: End if;
927:
920: l_person_type := per_type.system_person_type;
921: end loop;
922: if l_person_type is null then
923: hr_utility.set_message(8301,'GHR_38133_INVALID_PERSON');
924: hr_utility.raise_error;
925: end if;
926: End if;
927:
928: hr_utility.set_location(' Noa Family Code is ' || p_pa_request_rec.noa_family_code ,13);
924: hr_utility.raise_error;
925: end if;
926: End if;
927:
928: hr_utility.set_location(' Noa Family Code is ' || p_pa_request_rec.noa_family_code ,13);
929: hr_utility.set_location(' Person Type is ' || l_person_type,14);
930: -- Bug 3390876 Need to populate record groups even for Conversion of Appointment NTE actions if Suspended
931: IF p_pa_request_rec.employee_assignment_id IS NOT NULL THEN
932: FOR l_user_status IN c_user_status(p_pa_request_rec.employee_assignment_id,g_effective_date) LOOP
925: end if;
926: End if;
927:
928: hr_utility.set_location(' Noa Family Code is ' || p_pa_request_rec.noa_family_code ,13);
929: hr_utility.set_location(' Person Type is ' || l_person_type,14);
930: -- Bug 3390876 Need to populate record groups even for Conversion of Appointment NTE actions if Suspended
931: IF p_pa_request_rec.employee_assignment_id IS NOT NULL THEN
932: FOR l_user_status IN c_user_status(p_pa_request_rec.employee_assignment_id,g_effective_date) LOOP
933: l_person_status := l_user_status.per_system_status;
959: l_person_type <> 'EX_EMP') OR
960: (p_pa_request_rec.first_noa_code IN ('508','515','517','522','548','549','553','554','571','590')) THEN
961: -- AND l_person_status = 'SUSP_ASSIGN') THEN
962: IF p_pa_request_rec.employee_assignment_id is not null then
963: hr_utility.set_location(' asg id ' || to_char(p_pa_request_rec.employee_assignment_id) ,2);
964: hr_utility.set_location(' Date ' || to_Char(p_pa_request_rec.effective_date),2);
965:
966: -- Retrieve asg_sf52
967:
960: (p_pa_request_rec.first_noa_code IN ('508','515','517','522','548','549','553','554','571','590')) THEN
961: -- AND l_person_status = 'SUSP_ASSIGN') THEN
962: IF p_pa_request_rec.employee_assignment_id is not null then
963: hr_utility.set_location(' asg id ' || to_char(p_pa_request_rec.employee_assignment_id) ,2);
964: hr_utility.set_location(' Date ' || to_Char(p_pa_request_rec.effective_date),2);
965:
966: -- Retrieve asg_sf52
967:
968: ghr_history_fetch.fetch_asgei
971: p_date_effective => p_pa_request_rec.effective_date,
972: p_asg_ei_data => l_asg_extra_info_rec
973: );
974:
975: hr_utility.set_location('retrieved asg extra info 1 ',1);
976:
977: p_asg_sf52.assignment_extra_info_id := l_asg_extra_info_rec.assignment_extra_info_id;
978: p_asg_sf52.object_version_number := l_asg_extra_info_rec.object_version_number;
979: p_asg_sf52.step_or_rate := l_asg_extra_info_rec.aei_information3;
983: p_asg_sf52.work_schedule := l_asg_extra_info_rec.aei_information7;
984: p_asg_sf52.part_time_hours := l_asg_extra_info_rec.aei_information8;
985: p_asg_sf52.calc_pay_table := l_asg_extra_info_rec.aei_information9;
986:
987: hr_utility.set_location('After Fetch from local var - tenure ' || l_asg_extra_info_rec.aei_information3,2);
988: hr_utility.set_location('After Fetch from local var - asextrinfoid ' || to_char(l_asg_extra_info_rec.assignment_extra_info_id) ,2);
989: l_asg_extra_info_rec := null;
990: hr_utility.set_location('After Fetch - tenure ' || p_asg_sf52.tenure,2);
991: hr_utility.set_location('After Fetch - annu indic' || p_asg_sf52.annuitant_indicator,2);
984: p_asg_sf52.part_time_hours := l_asg_extra_info_rec.aei_information8;
985: p_asg_sf52.calc_pay_table := l_asg_extra_info_rec.aei_information9;
986:
987: hr_utility.set_location('After Fetch from local var - tenure ' || l_asg_extra_info_rec.aei_information3,2);
988: hr_utility.set_location('After Fetch from local var - asextrinfoid ' || to_char(l_asg_extra_info_rec.assignment_extra_info_id) ,2);
989: l_asg_extra_info_rec := null;
990: hr_utility.set_location('After Fetch - tenure ' || p_asg_sf52.tenure,2);
991: hr_utility.set_location('After Fetch - annu indic' || p_asg_sf52.annuitant_indicator,2);
992: hr_utility.set_location('After Fetch- asextrinfoid ' || to_char(p_asg_sf52.assignment_extra_info_id) ,2);
986:
987: hr_utility.set_location('After Fetch from local var - tenure ' || l_asg_extra_info_rec.aei_information3,2);
988: hr_utility.set_location('After Fetch from local var - asextrinfoid ' || to_char(l_asg_extra_info_rec.assignment_extra_info_id) ,2);
989: l_asg_extra_info_rec := null;
990: hr_utility.set_location('After Fetch - tenure ' || p_asg_sf52.tenure,2);
991: hr_utility.set_location('After Fetch - annu indic' || p_asg_sf52.annuitant_indicator,2);
992: hr_utility.set_location('After Fetch- asextrinfoid ' || to_char(p_asg_sf52.assignment_extra_info_id) ,2);
993:
994:
987: hr_utility.set_location('After Fetch from local var - tenure ' || l_asg_extra_info_rec.aei_information3,2);
988: hr_utility.set_location('After Fetch from local var - asextrinfoid ' || to_char(l_asg_extra_info_rec.assignment_extra_info_id) ,2);
989: l_asg_extra_info_rec := null;
990: hr_utility.set_location('After Fetch - tenure ' || p_asg_sf52.tenure,2);
991: hr_utility.set_location('After Fetch - annu indic' || p_asg_sf52.annuitant_indicator,2);
992: hr_utility.set_location('After Fetch- asextrinfoid ' || to_char(p_asg_sf52.assignment_extra_info_id) ,2);
993:
994:
995: -- Retrieve asg_non_sf52
988: hr_utility.set_location('After Fetch from local var - asextrinfoid ' || to_char(l_asg_extra_info_rec.assignment_extra_info_id) ,2);
989: l_asg_extra_info_rec := null;
990: hr_utility.set_location('After Fetch - tenure ' || p_asg_sf52.tenure,2);
991: hr_utility.set_location('After Fetch - annu indic' || p_asg_sf52.annuitant_indicator,2);
992: hr_utility.set_location('After Fetch- asextrinfoid ' || to_char(p_asg_sf52.assignment_extra_info_id) ,2);
993:
994:
995: -- Retrieve asg_non_sf52
996:
1001: p_asg_ei_data => l_asg_extra_info_rec
1002: );
1003:
1004:
1005: hr_utility.set_location('retrieved asg extra info 2 ',2);
1006:
1007: p_asg_non_sf52.assignment_extra_info_id := l_asg_extra_info_rec.assignment_extra_info_id;
1008: p_asg_non_sf52.object_version_number := l_asg_extra_info_rec.object_version_number;
1009: p_asg_non_sf52.date_arr_personnel_office := l_asg_extra_info_rec.aei_information3;
1027: p_date_effective => p_pa_request_rec.effective_date,
1028: p_asg_ei_data => l_asg_extra_info_rec
1029: );
1030:
1031: hr_utility.set_location('retrieved asg extra info 3 ',3);
1032:
1033:
1034: p_asg_nte_dates.assignment_extra_info_id := l_asg_extra_info_rec.assignment_extra_info_id;
1035: p_asg_nte_dates.object_version_number := l_asg_extra_info_rec.object_version_number;
1049: -- p_asg_nte_dates.position_change_nte := l_asg_extra_info_rec.aei_information16; -- ??
1050: l_asg_extra_info_rec := null;
1051:
1052: --Begin Bug# 8653508
1053: hr_utility.set_location('Before retrieving Detail IPA Benefits Continuation',191);
1054: ghr_history_fetch.fetch_asgei
1055: (p_assignment_id => p_pa_request_rec.employee_assignment_id,
1056: p_information_type => 'GHR_US_ASG_DET_INFO',
1057: p_date_effective => p_pa_request_rec.effective_date,
1086: p_date_effective => p_pa_request_rec.effective_date,
1087: p_per_ei_data => l_per_extra_info_rec
1088: );
1089:
1090: hr_utility.set_location('retrieved per sf52 ',5);
1091:
1092: p_per_sf52.person_extra_info_id := l_per_extra_info_rec.person_extra_info_id;
1093: p_per_sf52.object_version_number := l_per_extra_info_rec.object_version_number;
1094: p_per_sf52.citizenship := l_per_extra_info_rec.pei_information3;
1106: p_date_effective => p_pa_request_rec.effective_date,
1107: p_per_ei_data => l_per_extra_info_rec
1108: );
1109:
1110: hr_utility.set_location('After fetch RINO ' || l_per_extra_info_rec.pei_information5,1);
1111: hr_utility.set_location('After Fetch HANDICAP ' || l_per_extra_info_rec.pei_information11,2);
1112:
1113: hr_utility.set_location('retrieved per group1 ',6);
1114:
1107: p_per_ei_data => l_per_extra_info_rec
1108: );
1109:
1110: hr_utility.set_location('After fetch RINO ' || l_per_extra_info_rec.pei_information5,1);
1111: hr_utility.set_location('After Fetch HANDICAP ' || l_per_extra_info_rec.pei_information11,2);
1112:
1113: hr_utility.set_location('retrieved per group1 ',6);
1114:
1115: p_per_group1.person_extra_info_id := l_per_extra_info_rec.person_extra_info_id;
1109:
1110: hr_utility.set_location('After fetch RINO ' || l_per_extra_info_rec.pei_information5,1);
1111: hr_utility.set_location('After Fetch HANDICAP ' || l_per_extra_info_rec.pei_information11,2);
1112:
1113: hr_utility.set_location('retrieved per group1 ',6);
1114:
1115: p_per_group1.person_extra_info_id := l_per_extra_info_rec.person_extra_info_id;
1116: p_per_group1.object_version_number := l_per_extra_info_rec.object_version_number;
1117: p_per_group1.appointment_type := l_per_extra_info_rec.pei_information3;
1173: p_date_effective => p_pa_request_rec.effective_date,
1174: p_per_ei_data => l_per_extra_info_rec
1175: );
1176:
1177: hr_utility.set_location('After fetch SCD ' || l_per_extra_info_rec.pei_information3,1);
1178:
1179: hr_utility.set_location('retrieved per scd ',8);
1180:
1181:
1175: );
1176:
1177: hr_utility.set_location('After fetch SCD ' || l_per_extra_info_rec.pei_information3,1);
1178:
1179: hr_utility.set_location('retrieved per scd ',8);
1180:
1181:
1182: p_per_scd_info.person_extra_info_id := l_per_extra_info_rec.person_extra_info_id;
1183: p_per_scd_info.object_version_number := l_per_extra_info_rec.object_version_number;
1204: p_per_ei_data => l_per_extra_info_rec
1205: );
1206:
1207:
1208: hr_utility.set_location('retrieved per probations ',9);
1209:
1210: p_per_probations.person_extra_info_id := l_per_extra_info_rec.person_extra_info_id;
1211: p_per_probations.object_version_number := l_per_extra_info_rec.object_version_number;
1212: p_per_probations.date_prob_trial_period_begin := l_per_extra_info_rec.pei_information3;
1261: --End if;
1262: -- Bug 3021003 If Intervening actions are present in WGI, QSI corrections, get the corrected step.
1263: -- Bug 4658890 Removed 894 from first_noa_code
1264: IF p_pa_request_rec.first_noa_code IN ('867','892','893') AND l_session.noa_id_correct IS NOT NULL THEN
1265: hr_utility.set_location('Inside PRUP Sun if condn',10);
1266: ghr_pay_calc.is_retained_ia(p_pa_request_rec.person_id,
1267: p_pa_request_rec.effective_date,
1268: l_retained_grade_rec.pay_plan,
1269: l_retained_grade_rec.grade_or_level,
1271: l_retained_grade_rec.temp_step,
1272: l_ret_flag);
1273: IF l_ret_flag = TRUE THEN
1274: IF l_retained_grade_rec.temp_step IS NOT NULL THEN
1275: hr_utility.set_location('Inside PRUP Sun if temp_step condn' || l_retained_grade_rec.temp_step,10);
1276: 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);
1277: ELSE
1278: hr_utility.set_location('Inside PRUP Sun ELSE temp_step condn' || l_retained_grade_rec.step_or_rate,10);
1279: 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);
1274: IF l_retained_grade_rec.temp_step IS NOT NULL THEN
1275: hr_utility.set_location('Inside PRUP Sun if temp_step condn' || l_retained_grade_rec.temp_step,10);
1276: 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);
1277: ELSE
1278: hr_utility.set_location('Inside PRUP Sun ELSE temp_step condn' || l_retained_grade_rec.step_or_rate,10);
1279: 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);
1280: END IF;
1281: p_per_sf52.per_sf52_flag := 'Y';
1282: END IF;
1281: p_per_sf52.per_sf52_flag := 'Y';
1282: END IF;
1283: END IF;
1284:
1285: hr_utility.set_location('Retrieved Per_retained_grade',10);
1286:
1287: -- Need to handle this Exception here because it is just a warning to indicate that the pay cannot be calculated
1288: -- which is only apt for the Front End and does not matter in this context.
1289:
1293: end;
1294:
1295: -- Retrieve per_separate_retire
1296:
1297: hr_utility.set_location('retrieved per unif ',13);
1298: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
1299: p_per_separate_retire.agency_code_transfer_to ,13);
1300: hr_utility.set_location('l_per_extra_info_rec.pei_information8 = ' ||
1301: l_per_extra_info_rec.pei_information8 ,13);
1294:
1295: -- Retrieve per_separate_retire
1296:
1297: hr_utility.set_location('retrieved per unif ',13);
1298: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
1299: p_per_separate_retire.agency_code_transfer_to ,13);
1300: hr_utility.set_location('l_per_extra_info_rec.pei_information8 = ' ||
1301: l_per_extra_info_rec.pei_information8 ,13);
1302: ghr_history_fetch.fetch_peopleei
1296:
1297: hr_utility.set_location('retrieved per unif ',13);
1298: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
1299: p_per_separate_retire.agency_code_transfer_to ,13);
1300: hr_utility.set_location('l_per_extra_info_rec.pei_information8 = ' ||
1301: l_per_extra_info_rec.pei_information8 ,13);
1302: ghr_history_fetch.fetch_peopleei
1303: (p_person_id => p_pa_request_rec.person_id,
1304: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
1316: p_per_separate_retire.date_projected_retirement := l_per_extra_info_rec.pei_information9;
1317: p_per_separate_retire.mandatory_retirement_date := l_per_extra_info_rec.pei_information10;
1318: --Start Bug 1359482
1319: If nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) in ('300','301','302','303','304') then
1320: hr_utility.set_location('separate_pkg_status_indicator defaults to 1',14);
1321: p_per_separate_retire.separate_pkg_status_indicator := '1';
1322: p_per_separate_retire.per_sep_retire_flag := 'Y';
1323: else
1324: p_per_separate_retire.separate_pkg_status_indicator := l_per_extra_info_rec.pei_information11;
1333: p_per_separate_retire.date_ret_pkg_to_opm := l_per_extra_info_rec.pei_information17;
1334:
1335: l_per_extra_info_rec := null;
1336:
1337: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
1338: p_per_separate_retire.agency_code_transfer_to ,14);
1339: hr_utility.set_location('l_per_extra_info_rec.pei_information8 = ' ||
1340: l_per_extra_info_rec.pei_information8 ,14);
1341: hr_utility.set_location('retrieved per unif ',14);
1335: l_per_extra_info_rec := null;
1336:
1337: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
1338: p_per_separate_retire.agency_code_transfer_to ,14);
1339: hr_utility.set_location('l_per_extra_info_rec.pei_information8 = ' ||
1340: l_per_extra_info_rec.pei_information8 ,14);
1341: hr_utility.set_location('retrieved per unif ',14);
1342:
1343: -- Bug#4486823 RRR Changes
1337: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
1338: p_per_separate_retire.agency_code_transfer_to ,14);
1339: hr_utility.set_location('l_per_extra_info_rec.pei_information8 = ' ||
1340: l_per_extra_info_rec.pei_information8 ,14);
1341: hr_utility.set_location('retrieved per unif ',14);
1342:
1343: -- Bug#4486823 RRR Changes
1344: -- Retrieve per_service_obligation
1345:
1355: p_per_service_oblig.service_oblig_start_date := l_per_extra_info_rec.pei_information4;
1356: p_per_service_oblig.service_oblig_end_date := l_per_extra_info_rec.pei_information5;
1357: l_per_extra_info_rec := null;
1358:
1359: hr_utility.set_location('p_per_service_oblig.service_oblig_type_code = ' ||
1360: p_per_service_oblig.service_oblig_type_code ,15);
1361: hr_utility.set_location('p_per_service_oblig.service_oblig_start_date = ' ||
1362: p_per_service_oblig.service_oblig_start_date ,15);
1363: hr_utility.set_location('retrieved per serv oblg ',15); */
1357: l_per_extra_info_rec := null;
1358:
1359: hr_utility.set_location('p_per_service_oblig.service_oblig_type_code = ' ||
1360: p_per_service_oblig.service_oblig_type_code ,15);
1361: hr_utility.set_location('p_per_service_oblig.service_oblig_start_date = ' ||
1362: p_per_service_oblig.service_oblig_start_date ,15);
1363: hr_utility.set_location('retrieved per serv oblg ',15); */
1364:
1365: -- Retrieve per_uniformed_services
1359: hr_utility.set_location('p_per_service_oblig.service_oblig_type_code = ' ||
1360: p_per_service_oblig.service_oblig_type_code ,15);
1361: hr_utility.set_location('p_per_service_oblig.service_oblig_start_date = ' ||
1362: p_per_service_oblig.service_oblig_start_date ,15);
1363: hr_utility.set_location('retrieved per serv oblg ',15); */
1364:
1365: -- Retrieve per_uniformed_services
1366:
1367: ghr_history_fetch.fetch_peopleei
1469: p_date_effective => p_pa_request_rec.effective_date,
1470: p_pos_ei_data => l_pos_extra_info_rec
1471: );
1472:
1473: hr_utility.set_location('retrieved pos valid grade ',15);
1474:
1475: p_valid_grade.position_extra_info_id := l_pos_extra_info_rec.position_extra_info_id;
1476: p_valid_grade.object_version_number := l_pos_extra_info_rec.object_version_number;
1477: p_valid_grade.valid_grade := l_pos_extra_info_rec.poei_information3;
1478: p_valid_grade.target_grade := l_pos_extra_info_rec.poei_information4;
1479: p_valid_grade.pay_table_id := l_pos_extra_info_rec.poei_information5;
1480: p_valid_grade.pay_basis := l_pos_extra_info_rec.poei_information6;
1481: p_valid_grade.employment_category_group := l_pos_extra_info_rec.poei_information7;
1482: hr_utility.set_location('POS_VAL_GRADE - POS ID ' || to_char(l_position_id),1);
1483: hr_utility.set_location('POS_VAL_GRADE - OVN ' || to_char(l_pos_extra_info_rec.object_version_number),2);
1484: hr_utility.set_location('POS_VAL_GRADE - POEI ID' || to_char(l_pos_extra_info_rec.position_extra_info_id),3);
1485:
1486: l_pos_extra_info_rec := null;
1479: p_valid_grade.pay_table_id := l_pos_extra_info_rec.poei_information5;
1480: p_valid_grade.pay_basis := l_pos_extra_info_rec.poei_information6;
1481: p_valid_grade.employment_category_group := l_pos_extra_info_rec.poei_information7;
1482: hr_utility.set_location('POS_VAL_GRADE - POS ID ' || to_char(l_position_id),1);
1483: hr_utility.set_location('POS_VAL_GRADE - OVN ' || to_char(l_pos_extra_info_rec.object_version_number),2);
1484: hr_utility.set_location('POS_VAL_GRADE - POEI ID' || to_char(l_pos_extra_info_rec.position_extra_info_id),3);
1485:
1486: l_pos_extra_info_rec := null;
1487:
1480: p_valid_grade.pay_basis := l_pos_extra_info_rec.poei_information6;
1481: p_valid_grade.employment_category_group := l_pos_extra_info_rec.poei_information7;
1482: hr_utility.set_location('POS_VAL_GRADE - POS ID ' || to_char(l_position_id),1);
1483: hr_utility.set_location('POS_VAL_GRADE - OVN ' || to_char(l_pos_extra_info_rec.object_version_number),2);
1484: hr_utility.set_location('POS_VAL_GRADE - POEI ID' || to_char(l_pos_extra_info_rec.position_extra_info_id),3);
1485:
1486: l_pos_extra_info_rec := null;
1487:
1488: -- Retrieve Position group1
1495: p_pos_ei_data => l_pos_extra_info_rec
1496: );
1497:
1498:
1499: hr_utility.set_location('retrieved pos grp 1 ',16);
1500:
1501: p_pos_grp1.position_extra_info_id := l_pos_extra_info_rec.position_extra_info_id;
1502: p_pos_grp1.object_version_number := l_pos_extra_info_rec.object_version_number;
1503: p_pos_grp1.personnel_office_id := l_pos_extra_info_rec.poei_information3;
1523: p_pos_grp1.part_time_hours := l_pos_extra_info_rec.poei_information23;
1524:
1525:
1526:
1527: hr_utility.set_location('POS_gRP1 - POS ID ' || to_char(l_position_id),1);
1528: hr_utility.set_location('POS_GRP1 - OVN ' || to_char(p_pos_grp1.object_version_number),2);
1529: hr_utility.set_location('POS_GRP1 - POEI ID' || to_char(p_pos_grp1.position_extra_info_id),3);
1530:
1531: l_pos_extra_info_rec := null;
1524:
1525:
1526:
1527: hr_utility.set_location('POS_gRP1 - POS ID ' || to_char(l_position_id),1);
1528: hr_utility.set_location('POS_GRP1 - OVN ' || to_char(p_pos_grp1.object_version_number),2);
1529: hr_utility.set_location('POS_GRP1 - POEI ID' || to_char(p_pos_grp1.position_extra_info_id),3);
1530:
1531: l_pos_extra_info_rec := null;
1532:
1525:
1526:
1527: hr_utility.set_location('POS_gRP1 - POS ID ' || to_char(l_position_id),1);
1528: hr_utility.set_location('POS_GRP1 - OVN ' || to_char(p_pos_grp1.object_version_number),2);
1529: hr_utility.set_location('POS_GRP1 - POEI ID' || to_char(p_pos_grp1.position_extra_info_id),3);
1530:
1531: l_pos_extra_info_rec := null;
1532:
1533: -- Retrieve Position Group2
1539: p_pos_ei_data => l_pos_extra_info_rec
1540: );
1541:
1542:
1543: hr_utility.set_location('retrieved pos grp 2 ',17);
1544:
1545:
1546: p_pos_grp2.position_extra_info_id := l_pos_extra_info_rec.position_extra_info_id;
1547: p_pos_grp2.object_version_number := l_pos_extra_info_rec.object_version_number;
1558: p_pos_grp2.appropriation_code1 := l_pos_extra_info_rec.poei_information13;
1559: p_pos_grp2.appropriation_code2 := l_pos_extra_info_rec.poei_information14;
1560: p_pos_grp2.intelligence_position_ind := l_pos_extra_info_rec.poei_information15;
1561: p_pos_grp2.leo_position_indicator := l_pos_extra_info_rec.poei_information16;
1562: hr_utility.set_location('POS_2 - POS ID ' || to_char(l_position_id),1);
1563: hr_utility.set_location('POS_2 - OVN ' || to_char(l_pos_extra_info_rec.object_version_number),2);
1564: hr_utility.set_location('POS_2 - POEI ID' || to_char(l_pos_extra_info_rec.position_extra_info_id),3);
1565:
1566: l_pos_extra_info_rec := null;
1559: p_pos_grp2.appropriation_code2 := l_pos_extra_info_rec.poei_information14;
1560: p_pos_grp2.intelligence_position_ind := l_pos_extra_info_rec.poei_information15;
1561: p_pos_grp2.leo_position_indicator := l_pos_extra_info_rec.poei_information16;
1562: hr_utility.set_location('POS_2 - POS ID ' || to_char(l_position_id),1);
1563: hr_utility.set_location('POS_2 - OVN ' || to_char(l_pos_extra_info_rec.object_version_number),2);
1564: hr_utility.set_location('POS_2 - POEI ID' || to_char(l_pos_extra_info_rec.position_extra_info_id),3);
1565:
1566: l_pos_extra_info_rec := null;
1567:
1560: p_pos_grp2.intelligence_position_ind := l_pos_extra_info_rec.poei_information15;
1561: p_pos_grp2.leo_position_indicator := l_pos_extra_info_rec.poei_information16;
1562: hr_utility.set_location('POS_2 - POS ID ' || to_char(l_position_id),1);
1563: hr_utility.set_location('POS_2 - OVN ' || to_char(l_pos_extra_info_rec.object_version_number),2);
1564: hr_utility.set_location('POS_2 - POEI ID' || to_char(l_pos_extra_info_rec.position_extra_info_id),3);
1565:
1566: l_pos_extra_info_rec := null;
1567:
1568: -- Retrieve Position Obligation
1579: p_pos_oblig.obligation_type := l_pos_extra_info_rec.poei_information4;
1580: p_pos_oblig.employee_ssn := l_pos_extra_info_rec.poei_information5;
1581: l_pos_extra_info_rec := null;
1582:
1583: hr_utility.set_location('retrieved pos oblig ',18);
1584:
1585: /* Retrieve GHR_US_POS_CAR_PROG */
1586:
1587: /* Retrieve GHR_US_PER_BENEFITS_CONT */
1586:
1587: /* Retrieve GHR_US_PER_BENEFITS_CONT */
1588: -- Bug 6312144 IPA Benefits Continuation EIT changes
1589:
1590: hr_utility.set_location('Before retrieving IPA Benefits Continuation',19);
1591: l_per_extra_info_rec := null;
1592: ghr_history_fetch.fetch_peopleei
1593: (p_person_id => p_pa_request_rec.person_id,
1594: p_information_type => 'GHR_US_PER_BENEFITS_CONT',
1610: p_ipa_benefits_cont.Cont_Term_Insuff_Pay_Notf_Date := l_per_extra_info_rec.pei_information10;
1611: p_ipa_benefits_cont.Cont_Term_Insuff_Pmt_Type_Code := l_per_extra_info_rec.pei_information11;
1612:
1613: /* Retrieve GHR_US_PER_BENEFITS_CONT */
1614: hr_utility.set_location('Retrieving IPA Benefits Continuation',20);
1615:
1616: /* Retrieve GHR_US_PER_RETIRMENT_SYS_INFO*/
1617:
1618: hr_utility.set_location('Before retrieving Retirement System Information',21);
1614: hr_utility.set_location('Retrieving IPA Benefits Continuation',20);
1615:
1616: /* Retrieve GHR_US_PER_RETIRMENT_SYS_INFO*/
1617:
1618: hr_utility.set_location('Before retrieving Retirement System Information',21);
1619: -- Bug 6312144 Retirement System Information EIT changes
1620: l_per_extra_info_rec := null;
1621: ghr_history_fetch.fetch_peopleei
1622: (p_person_id => p_pa_request_rec.person_id,
1631: p_retirement_info.App_Exc_FERS_Ind := l_per_extra_info_rec.pei_information3;
1632: p_retirement_info.FICA_Coverage_Ind1 := l_per_extra_info_rec.pei_information4;
1633: p_retirement_info.FICA_Coverage_Ind2 := l_per_extra_info_rec.pei_information5;
1634:
1635: hr_utility.set_location('After Retirement System Information',22);
1636: /* Retrieve GHR_US_PER_RETIRMENT_SYS_INFO*/
1637:
1638: End retrieve_all_extra_info;
1639:
1679: --
1680: Begin
1681: --
1682: g_effective_date := nvl(p_pa_request_rec.effective_date,sysdate);
1683: hr_utility.set_location('Entering ' || l_proc,10);
1684: --
1685: If p_pa_request_rec.to_position_id is null then
1686: l_position_id := p_pa_request_rec.from_position_id;
1687: Else
1719: ,p_business_group_id => l_bus_gp
1720: ,p_effective_date => p_pa_request_rec.effective_date
1721: );
1722: end if;
1723: hr_utility.set_location('Leaving ' ||l_proc,40);
1724: end SF52_br_extra_info;
1725:
1726: --
1727: -- *****************************
1785: /*l_payroll_office_id := p_pos_grp1.payroll_office_id;
1786: l_pos_org := p_pos_grp1.positions_organization;*/
1787: l_student_loan_repay := p_student_loan_repay;
1788:
1789: hr_utility.set_location('Entering ' ||l_proc,5);
1790:
1791: -- **********************
1792: -- Assignment SF52 Extra Info
1793: -- **********************
1800: p_pa_request_rec.to_pay_table_identifier is not null
1801: then
1802: --
1803: --
1804: hr_utility.set_location(l_proc,10);
1805:
1806: --
1807: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,1);
1808: If p_pa_request_rec.to_step_or_rate is not null then
1803: --
1804: hr_utility.set_location(l_proc,10);
1805:
1806: --
1807: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,1);
1808: If p_pa_request_rec.to_step_or_rate is not null then
1809: If P_pa_request_rec.to_step_or_rate <>
1810: nvl(p_asg_sf52.step_or_rate,hr_api.g_varchar2) then
1811: hr_utility.set_location(l_proc,20);
1807: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,1);
1808: If p_pa_request_rec.to_step_or_rate is not null then
1809: If P_pa_request_rec.to_step_or_rate <>
1810: nvl(p_asg_sf52.step_or_rate,hr_api.g_varchar2) then
1811: hr_utility.set_location(l_proc,20);
1812: p_Asg_sf52.Asg_sf52_flag := 'Y';
1813: p_Asg_Sf52.Step_Or_Rate := P_pa_request_rec.to_Step_Or_Rate;
1814: End if;
1815: End if;
1813: p_Asg_Sf52.Step_Or_Rate := P_pa_request_rec.to_Step_Or_Rate;
1814: End if;
1815: End if;
1816: --
1817: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,2);
1818: hr_utility.set_location('old tenure ' || p_asg_sf52.tenure,2);
1819: hr_utility.set_location('new tenure ' || p_pa_request_rec.tenure,2);
1820: hr_utility.set_location('old ann ind ' || p_asg_sf52.annuitant_indicator,2);
1821:
1814: End if;
1815: End if;
1816: --
1817: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,2);
1818: hr_utility.set_location('old tenure ' || p_asg_sf52.tenure,2);
1819: hr_utility.set_location('new tenure ' || p_pa_request_rec.tenure,2);
1820: hr_utility.set_location('old ann ind ' || p_asg_sf52.annuitant_indicator,2);
1821:
1822:
1815: End if;
1816: --
1817: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,2);
1818: hr_utility.set_location('old tenure ' || p_asg_sf52.tenure,2);
1819: hr_utility.set_location('new tenure ' || p_pa_request_rec.tenure,2);
1820: hr_utility.set_location('old ann ind ' || p_asg_sf52.annuitant_indicator,2);
1821:
1822:
1823: If p_pa_request_rec.tenure is not null then
1816: --
1817: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,2);
1818: hr_utility.set_location('old tenure ' || p_asg_sf52.tenure,2);
1819: hr_utility.set_location('new tenure ' || p_pa_request_rec.tenure,2);
1820: hr_utility.set_location('old ann ind ' || p_asg_sf52.annuitant_indicator,2);
1821:
1822:
1823: If p_pa_request_rec.tenure is not null then
1824: If P_pa_request_rec.Tenure <>
1822:
1823: If p_pa_request_rec.tenure is not null then
1824: If P_pa_request_rec.Tenure <>
1825: nvl(p_asg_sf52.tenure,hr_api.g_varchar2) then
1826: hr_utility.set_location(l_proc,25);
1827: p_asg_sf52.asg_sf52_flag := 'Y';
1828: P_Asg_Sf52.Tenure := P_pa_request_rec.Tenure ;
1829: End if;
1830: End if;
1828: P_Asg_Sf52.Tenure := P_pa_request_rec.Tenure ;
1829: End if;
1830: End if;
1831: --
1832: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,3);
1833:
1834: If p_pa_request_rec.annuitant_indicator is not null then
1835: If P_pa_request_rec.Annuitant_Indicator <>
1836: nvl(p_asg_sf52.annuitant_indicator,hr_api.g_varchar2)then
1833:
1834: If p_pa_request_rec.annuitant_indicator is not null then
1835: If P_pa_request_rec.Annuitant_Indicator <>
1836: nvl(p_asg_sf52.annuitant_indicator,hr_api.g_varchar2)then
1837: hr_utility.set_location(l_proc,30);
1838: p_asg_sf52.asg_sf52_flag := 'Y';
1839: P_Asg_Sf52.Annuitant_Indicator := P_pa_request_rec.Annuitant_Indicator;
1840: End if;
1841: End if;
1839: P_Asg_Sf52.Annuitant_Indicator := P_pa_request_rec.Annuitant_Indicator;
1840: End if;
1841: End if;
1842: --
1843: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,4);
1844:
1845: If p_pa_request_rec.pay_rate_determinant is not null then
1846: If P_pa_request_rec.Pay_Rate_Determinant<>
1847: nvl(p_asg_sf52.pay_rate_determinant,hr_api.g_varchar2) then
1844:
1845: If p_pa_request_rec.pay_rate_determinant is not null then
1846: If P_pa_request_rec.Pay_Rate_Determinant<>
1847: nvl(p_asg_sf52.pay_rate_determinant,hr_api.g_varchar2) then
1848: hr_utility.set_location(l_proc,35);
1849: p_asg_sf52.asg_sf52_flag := 'Y';
1850: p_Asg_Sf52.Pay_Rate_Determinant := P_pa_request_rec.Pay_Rate_Determinant;
1851: End if;
1852: End if;
1849: p_asg_sf52.asg_sf52_flag := 'Y';
1850: p_Asg_Sf52.Pay_Rate_Determinant := P_pa_request_rec.Pay_Rate_Determinant;
1851: End if;
1852: End if;
1853: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,5);
1854: End if;
1855:
1856: If nvl(P_pa_request_rec.work_schedule,hr_api.g_varchar2) <>
1857: nvl(p_asg_sf52.work_schedule,hr_api.g_varchar2) then
1854: End if;
1855:
1856: If nvl(P_pa_request_rec.work_schedule,hr_api.g_varchar2) <>
1857: nvl(p_asg_sf52.work_schedule,hr_api.g_varchar2) then
1858: hr_utility.set_location(l_proc,35);
1859: p_asg_sf52.asg_sf52_flag := 'Y';
1860: p_Asg_Sf52.work_schedule := P_pa_request_rec.work_schedule;
1861: End if;
1862:
1859: p_asg_sf52.asg_sf52_flag := 'Y';
1860: p_Asg_Sf52.work_schedule := P_pa_request_rec.work_schedule;
1861: End if;
1862:
1863: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,6);
1864:
1865: If nvl(P_pa_request_rec.part_time_hours,hr_api.g_number) <>
1866: nvl(p_asg_sf52.part_time_hours,hr_api.g_number) then
1867: hr_utility.set_location(l_proc,35);
1863: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,6);
1864:
1865: If nvl(P_pa_request_rec.part_time_hours,hr_api.g_number) <>
1866: nvl(p_asg_sf52.part_time_hours,hr_api.g_number) then
1867: hr_utility.set_location(l_proc,35);
1868: p_asg_sf52.asg_sf52_flag := 'Y';
1869: p_Asg_Sf52.part_time_hours := P_pa_request_rec.part_time_hours;
1870: End if;
1871: -- 809503
1875: p_asg_sf52.asg_sf52_flag := 'Y';
1876: END IF;
1877: end loop;
1878:
1879: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,6);
1880: If p_pa_request_rec.to_pay_table_identifier is not null then
1881: If P_pa_request_rec.to_pay_table_identifier <>
1882: nvl(p_asg_sf52.calc_pay_table,hr_api.g_number)then
1883: hr_utility.set_location(l_proc,30);
1879: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,6);
1880: If p_pa_request_rec.to_pay_table_identifier is not null then
1881: If P_pa_request_rec.to_pay_table_identifier <>
1882: nvl(p_asg_sf52.calc_pay_table,hr_api.g_number)then
1883: hr_utility.set_location(l_proc,30);
1884: p_asg_sf52.asg_sf52_flag := 'Y';
1885: P_Asg_Sf52.calc_pay_table := P_pa_request_rec.to_pay_table_identifier;
1886: End if;
1887: End if;
1892: l_calc_table_id := ghr_pay_calc.get_user_table_id(p_position_id => p_pa_request_rec.to_position_id,
1893: p_effective_date => p_pa_request_rec.effective_date);
1894: --Bug# 13587903, added below if condition not to update calc pay table every time
1895: IF nvl(p_asg_sf52.calc_pay_table,hr_api.g_number) <> l_calc_table_id THEN
1896: hr_utility.set_location(l_proc,40);
1897: p_asg_sf52.asg_sf52_flag := 'Y';
1898: P_Asg_Sf52.calc_pay_table := l_calc_table_id;
1899: END IF; --Bug# 13587903
1900: END IF;
1898: P_Asg_Sf52.calc_pay_table := l_calc_table_id;
1899: END IF; --Bug# 13587903
1900: END IF;
1901: -- 6881863
1902: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,7);
1903:
1904:
1905:
1906: --
1918: If P_pa_request_rec.Citizenship is not null or
1919: P_pa_request_rec.Veterans_Preference is not null or
1920: P_pa_request_rec.Veterans_Pref_for_rif is not null or
1921: P_pa_request_rec.Veterans_Status is not null then
1922: hr_utility.set_location(l_proc,55);
1923: --
1924: --
1925: If p_pa_request_rec.citizenship is not null then
1926: If p_pa_request_rec.Citizenship <> nvl(p_per_sf52.citizenship,hr_api.g_varchar2) then
1923: --
1924: --
1925: If p_pa_request_rec.citizenship is not null then
1926: If p_pa_request_rec.Citizenship <> nvl(p_per_sf52.citizenship,hr_api.g_varchar2) then
1927: hr_utility.set_location(l_proc,65);
1928: P_Per_sf52.Per_Sf52_Flag := 'Y';
1929: P_Per_sf52.Citizenship := P_pa_request_rec.Citizenship;
1930: End if;
1931: End if;
1932: --
1933: If p_pa_request_rec.veterans_preference is not null then
1934: If P_pa_request_rec.Veterans_Preference <>
1935: nvl(p_per_sf52.veterans_preference,hr_api.g_varchar2) then
1936: hr_utility.set_location(l_proc,70);
1937: P_Per_sf52.Per_Sf52_Flag := 'Y';
1938: P_Per_sf52.Veterans_Preference := P_pa_request_rec.Veterans_Preference;
1939: End if;
1940: End if;
1941:
1942: If p_pa_request_rec.veterans_pref_for_rif is not null then
1943: If P_pa_request_rec.Veterans_Pref_for_rif <>
1944: nvl(p_per_sf52.veterans_preference_for_rif,hr_api.g_varchar2) then
1945: hr_utility.set_location(l_proc,75);
1946: P_Per_sf52.Per_Sf52_Flag := 'Y';
1947: P_Per_sf52.Veterans_Preference_For_Rif := P_pa_request_rec.Veterans_Pref_for_rif;
1948: End if;
1949: End if;
1950:
1951: If p_pa_request_rec.veterans_status is not null then
1952: If P_pa_request_rec.Veterans_Status <>
1953: nvl(p_per_sf52.veterans_status,hr_api.g_varchar2)then
1954: hr_utility.set_location(l_proc,80);
1955: P_Per_sf52.Per_Sf52_Flag := 'Y';
1956: P_Per_sf52.Veterans_Status := P_pa_request_rec.Veterans_Status;
1957: End if;
1958: End if;
1964: -- per_scd extra info
1965: -- **********************
1966:
1967: If p_pa_request_rec.service_comp_date is not null then
1968: hr_utility.set_location(l_proc,85);
1969:
1970: hr_utility.set_location(l_proc,90);
1971: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)
1972: <> nvl(p_per_scd_info.scd_leave,fnd_date.date_to_canonical(hr_api.g_date)) then
1966:
1967: If p_pa_request_rec.service_comp_date is not null then
1968: hr_utility.set_location(l_proc,85);
1969:
1970: hr_utility.set_location(l_proc,90);
1971: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)
1972: <> nvl(p_per_scd_info.scd_leave,fnd_date.date_to_canonical(hr_api.g_date)) then
1973: hr_utility.set_location(l_proc,95);
1974: p_per_scd_info.scd_leave := fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date);
1969:
1970: hr_utility.set_location(l_proc,90);
1971: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)
1972: <> nvl(p_per_scd_info.scd_leave,fnd_date.date_to_canonical(hr_api.g_date)) then
1973: hr_utility.set_location(l_proc,95);
1974: p_per_scd_info.scd_leave := fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date);
1975: p_per_scd_info.per_scd_info_flag := 'Y';
1976: End if;
1977: End if;
1983: -- **********************
1984: --
1985: -- JH Add part time Hours
1986: /*if p_pa_request_rec.noa_family_code = 'REALIGNMENT' then
1987: hr_utility.set_location('Inside PRUP realign check'||p_pa_request_rec.noa_family_code,12345);
1988: for c_ei_rec in c_pa_request_extra_info('GHR_US_PAR_REALIGNMENT') loop
1989: If c_ei_rec.rei_information4 is not null then
1990: l_payroll_office_id := c_ei_rec.rei_information4;
1991: end if;
1992: If c_ei_rec.rei_information8 is not null then
1993: l_pos_org := c_ei_rec.rei_information8;
1994: end if;
1995: end loop;
1996: hr_utility.set_location('Inside PRUP payroll check'||l_payroll_office_id,12345);
1997: p_pos_grp1.payroll_office_id := l_payroll_office_id;
1998:
1999: hr_utility.set_location('Inside PRUP pos org check'||l_pos_org,12345);
2000: p_pos_grp1.positions_organization := l_pos_org;
1995: end loop;
1996: hr_utility.set_location('Inside PRUP payroll check'||l_payroll_office_id,12345);
1997: p_pos_grp1.payroll_office_id := l_payroll_office_id;
1998:
1999: hr_utility.set_location('Inside PRUP pos org check'||l_pos_org,12345);
2000: p_pos_grp1.positions_organization := l_pos_org;
2001: end if;*/
2002:
2003: If P_pa_request_rec.to_Occ_Code is not null or
2006: P_pa_request_rec.Functional_Class is not null or
2007: P_pa_request_rec.FLSA_Category is not null or
2008: P_pa_request_rec.Supervisory_Status is not null or
2009: P_pa_request_rec.part_time_hours is not null then
2010: hr_utility.set_location(l_proc,95);
2011: --
2012: --
2013: -- Bug 3226555 Commented below code as they can never be equal. It was unnecessarily inserting a
2014: -- row into the history for the table PER_POSITIONS_EXTRA_INFO and thereby making the Position
2015: -- status as invalid when cancellation to any action was done.
2016: /* If p_pa_request_rec.to_occ_code is not null then
2017: If P_pa_request_rec.to_Occ_Code <>
2018: nvl(p_pos_grp1.occupation_category_code,hr_api.g_varchar2) then
2019: hr_utility.set_location(l_proc,105);
2020: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
2021: P_Pos_grp1.Occupation_Category_Code := P_pa_request_rec.to_Occ_Code;
2022: End if;
2023: End if; */
2024:
2025: If p_pa_request_rec.bargaining_unit_status is not null then
2026: If P_pa_request_rec.Bargaining_Unit_Status <>
2027: nvl(p_pos_grp1.bargaining_unit_status,hr_api.g_varchar2) then
2028: hr_utility.set_location(l_proc,110);
2029: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
2030: P_Pos_grp1.Bargaining_Unit_Status := P_pa_request_rec.Bargaining_Unit_Status;
2031: End if;
2032: End if;
2035: -- Bugs 773851, 773795
2036: If p_pa_request_rec.work_schedule is not null then
2037: If P_pa_request_rec.Work_Schedule <>
2038: nvl(p_pos_grp1.work_schedule,hr_api.g_varchar2) then
2039: hr_utility.set_location(l_proc,115);
2040: hr_utility.set_location('JH Rec WS = ' || P_pa_request_rec.work_schedule,115);
2041: hr_utility.set_location('JH Posn Grp1 WS = ' || p_pos_grp1.work_schedule,115);
2042: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
2043: P_Pos_grp1.Work_Schedule := P_pa_request_rec.Work_Schedule;
2036: If p_pa_request_rec.work_schedule is not null then
2037: If P_pa_request_rec.Work_Schedule <>
2038: nvl(p_pos_grp1.work_schedule,hr_api.g_varchar2) then
2039: hr_utility.set_location(l_proc,115);
2040: hr_utility.set_location('JH Rec WS = ' || P_pa_request_rec.work_schedule,115);
2041: hr_utility.set_location('JH Posn Grp1 WS = ' || p_pos_grp1.work_schedule,115);
2042: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
2043: P_Pos_grp1.Work_Schedule := P_pa_request_rec.Work_Schedule;
2044: hr_utility.set_location('JH Update WS = ' || p_pos_grp1.work_schedule,115);
2037: If P_pa_request_rec.Work_Schedule <>
2038: nvl(p_pos_grp1.work_schedule,hr_api.g_varchar2) then
2039: hr_utility.set_location(l_proc,115);
2040: hr_utility.set_location('JH Rec WS = ' || P_pa_request_rec.work_schedule,115);
2041: hr_utility.set_location('JH Posn Grp1 WS = ' || p_pos_grp1.work_schedule,115);
2042: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
2043: P_Pos_grp1.Work_Schedule := P_pa_request_rec.Work_Schedule;
2044: hr_utility.set_location('JH Update WS = ' || p_pos_grp1.work_schedule,115);
2045: End if;
2040: hr_utility.set_location('JH Rec WS = ' || P_pa_request_rec.work_schedule,115);
2041: hr_utility.set_location('JH Posn Grp1 WS = ' || p_pos_grp1.work_schedule,115);
2042: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
2043: P_Pos_grp1.Work_Schedule := P_pa_request_rec.Work_Schedule;
2044: hr_utility.set_location('JH Update WS = ' || p_pos_grp1.work_schedule,115);
2045: End if;
2046: End if;
2047:
2048: -- JH Hard coded to pass null if WS is F, G, B, I, J.
2048: -- JH Hard coded to pass null if WS is F, G, B, I, J.
2049: If p_pa_request_rec.part_time_hours is not null then
2050: If P_pa_request_rec.part_time_hours <>
2051: nvl(p_pos_grp1.part_time_hours,hr_api.g_number) then
2052: hr_utility.set_location(l_proc,117);
2053: hr_utility.set_location('JH Rec PTH = ' || P_pa_request_rec.part_time_hours,117);
2054: hr_utility.set_location('JH Posn Grp1 PTH = ' || p_pos_grp1.part_time_hours,117);
2055: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
2056: P_Pos_grp1.part_time_hours := P_pa_request_rec.part_time_hours;
2049: If p_pa_request_rec.part_time_hours is not null then
2050: If P_pa_request_rec.part_time_hours <>
2051: nvl(p_pos_grp1.part_time_hours,hr_api.g_number) then
2052: hr_utility.set_location(l_proc,117);
2053: hr_utility.set_location('JH Rec PTH = ' || P_pa_request_rec.part_time_hours,117);
2054: hr_utility.set_location('JH Posn Grp1 PTH = ' || p_pos_grp1.part_time_hours,117);
2055: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
2056: P_Pos_grp1.part_time_hours := P_pa_request_rec.part_time_hours;
2057: hr_utility.set_location('JH Update PTH = ' || p_pos_grp1.part_time_hours,117);
2050: If P_pa_request_rec.part_time_hours <>
2051: nvl(p_pos_grp1.part_time_hours,hr_api.g_number) then
2052: hr_utility.set_location(l_proc,117);
2053: hr_utility.set_location('JH Rec PTH = ' || P_pa_request_rec.part_time_hours,117);
2054: hr_utility.set_location('JH Posn Grp1 PTH = ' || p_pos_grp1.part_time_hours,117);
2055: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
2056: P_Pos_grp1.part_time_hours := P_pa_request_rec.part_time_hours;
2057: hr_utility.set_location('JH Update PTH = ' || p_pos_grp1.part_time_hours,117);
2058: End if;
2053: hr_utility.set_location('JH Rec PTH = ' || P_pa_request_rec.part_time_hours,117);
2054: hr_utility.set_location('JH Posn Grp1 PTH = ' || p_pos_grp1.part_time_hours,117);
2055: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
2056: P_Pos_grp1.part_time_hours := P_pa_request_rec.part_time_hours;
2057: hr_utility.set_location('JH Update PTH = ' || p_pos_grp1.part_time_hours,117);
2058: End if;
2059: Elsif P_Pos_grp1.Work_Schedule in ('F', 'G', 'B', 'I', 'J') Then
2060: P_Pos_grp1.part_time_hours := null;
2061: End if;
2063:
2064: If p_pa_request_rec.functional_class is not null then
2065: If P_pa_request_rec.Functional_Class <>
2066: nvl(p_pos_grp1.functional_class,hr_api.g_varchar2) then
2067: hr_utility.set_location(l_proc,120);
2068: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
2069: P_Pos_grp1.Functional_Class := P_pa_request_rec.Functional_Class;
2070: End if;
2071: End if;
2072:
2073: If p_pa_request_rec.flsa_category is not null then
2074: If P_pa_request_rec.FLSA_Category <>
2075: nvl(p_pos_grp1.flsa_category,hr_api.g_varchar2) then
2076: hr_utility.set_location(l_proc,125);
2077: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
2078: P_Pos_grp1.FLSA_Category := P_pa_request_rec.FLSA_Category;
2079: End if;
2080: End if;
2081:
2082: If p_pa_request_rec.supervisory_status is not null then
2083: If P_pa_request_rec.Supervisory_Status <>
2084: nvl(p_pos_grp1.supervisory_status,hr_api.g_varchar2) then
2085: hr_utility.set_location(l_proc,130);
2086: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
2087: P_Pos_grp1.Supervisory_Status := P_pa_request_rec.Supervisory_Status;
2088: End if;
2089: End if;
2098: If P_pa_request_rec.Appropriation_Code1 is not null or
2099: P_pa_request_rec.Appropriation_Code2 is not null or
2100: p_pa_request_rec.position_occupied is not null then --*
2101: --
2102: hr_utility.set_location(l_proc,135);
2103: --
2104: If p_pa_request_rec.position_occupied is not null then
2105: If p_pa_request_rec.position_occupied <> nvl(p_pos_grp2.position_occupied,hr_api.g_varchar2) then
2106: hr_utility.set_location(l_proc,145);
2102: hr_utility.set_location(l_proc,135);
2103: --
2104: If p_pa_request_rec.position_occupied is not null then
2105: If p_pa_request_rec.position_occupied <> nvl(p_pos_grp2.position_occupied,hr_api.g_varchar2) then
2106: hr_utility.set_location(l_proc,145);
2107: P_Pos_grp2.Pos_grp2_flag := 'Y';
2108: p_pos_grp2.position_occupied := p_pa_request_rec.position_occupied;
2109: End if;
2110: End if;
2110: End if;
2111:
2112: If p_pa_request_rec.appropriation_code1 is not null then
2113: If P_pa_request_rec.Appropriation_Code1 <> nvl(p_pos_grp2.appropriation_code1,hr_api.g_varchar2) then
2114: hr_utility.set_location(l_proc,150);
2115: P_Pos_grp2.Pos_grp2_flag := 'Y';
2116: P_Pos_grp2.Appropriation_Code1 := P_pa_request_rec.Appropriation_Code1;
2117: End if;
2118: End if;
2119:
2120: --
2121: If p_pa_request_rec.appropriation_code2 is not null then
2122: If p_pa_request_rec.Appropriation_Code2 <> nvl(p_pos_grp2.appropriation_code2,hr_api.g_varchar2) then
2123: hr_utility.set_location(l_proc,155);
2124: P_Pos_grp2.Pos_grp2_flag := 'Y';
2125: P_Pos_grp2.Appropriation_Code2:= P_pa_request_rec.Appropriation_Code2;
2126: End if;
2127: End if;
2144: -- Recruitment Bonus
2145: -- *****************
2146: --
2147: If nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) = '815' then
2148: hr_utility.set_location(l_proc,165);
2149: p_recruitment_bonus.p_recruitment_bonus := p_pa_request_rec.award_amount;
2150: p_recruitment_bonus.p_percentage := p_pa_request_rec.award_percentage;
2151: END IF;
2152: --
2156: -- Relocation Bonus
2157: -- ***************
2158: --
2159: If nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) = '816' then
2160: hr_utility.set_location(l_proc,170);
2161: p_relocation_bonus.p_relocation_bonus := p_pa_request_rec.award_amount;
2162: p_relocation_bonus.p_percentage := p_pa_request_rec.award_percentage;
2163: End if;
2164: --
2167: -- Student Loan Repayment
2168: -- ***************
2169: --
2170: If nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) = '817' then
2171: hr_utility.set_location(l_proc,170);
2172: l_student_loan_repay.p_amount := p_pa_request_rec.award_amount;
2173: p_student_loan_repay := l_student_loan_repay;
2174: End if;
2175: --
2418: Procedure appt_info is
2419: l_proc varchar2(70) := 'Process_non_sf52 - App1';
2420: --
2421: Begin
2422: hr_utility.set_location('Entering ' ||l_proc,5);
2423: hr_utility.set_location('before retr info in appt-info',1);
2424:
2425: -- If a CORRECTION action is being performed, then, we cannot force the User to
2426: -- enter the Mandatory Items on the SF52, as it might already exist in the Core
2419: l_proc varchar2(70) := 'Process_non_sf52 - App1';
2420: --
2421: Begin
2422: hr_utility.set_location('Entering ' ||l_proc,5);
2423: hr_utility.set_location('before retr info in appt-info',1);
2424:
2425: -- If a CORRECTION action is being performed, then, we cannot force the User to
2426: -- enter the Mandatory Items on the SF52, as it might already exist in the Core
2427: -- Extra Information. In such cases , fetch the value from the CORE Extra information,
2529:
2530:
2531:
2532: --bug 4443968
2533: hr_utility.set_location('Creditable service' ||l_pa_request_ei_rec.rei_information23,0000);
2534: hr_utility.set_location('Populate flag' ||p_per_scd_info.per_scd_info_flag,3333);
2535: --
2536: --
2537: hr_utility.set_location('Leaving ' || l_proc,20);
2530:
2531:
2532: --bug 4443968
2533: hr_utility.set_location('Creditable service' ||l_pa_request_ei_rec.rei_information23,0000);
2534: hr_utility.set_location('Populate flag' ||p_per_scd_info.per_scd_info_flag,3333);
2535: --
2536: --
2537: hr_utility.set_location('Leaving ' || l_proc,20);
2538:
2533: hr_utility.set_location('Creditable service' ||l_pa_request_ei_rec.rei_information23,0000);
2534: hr_utility.set_location('Populate flag' ||p_per_scd_info.per_scd_info_flag,3333);
2535: --
2536: --
2537: hr_utility.set_location('Leaving ' || l_proc,20);
2538:
2539: End appt_info;
2540: --
2541: --
2544: Procedure appt_transfer_app is
2545: l_proc varchar2(70) := 'non_sf52_extra_info - appt_transfer_app';
2546:
2547: Begin
2548: hr_utility.set_location('Entering ' || l_proc,5);
2549: set_extra_info(p_per_group1.org_appointment_auth_code1,
2550: nvl(l_pa_request_ei_rec.rei_information1,p_pa_request_rec.first_action_la_code1),p_per_group1.per_group1_flag);
2551: set_extra_info(p_per_group1.org_appointment_desc1,
2552: nvl(l_pa_request_ei_rec.rei_information2,p_pa_request_rec.first_action_la_desc1),p_per_group1.per_group1_flag);
2554: nvl(l_pa_request_ei_rec.rei_information3,p_pa_request_rec.first_action_la_code2),p_per_group1.per_group1_flag);
2555: set_extra_info(p_per_group1.org_appointment_desc2,
2556: nvl(l_pa_request_ei_rec.rei_information4,p_pa_request_rec.first_action_la_desc2),p_per_group1.per_group1_flag);
2557:
2558: hr_utility.set_location('Leaving ' ||l_proc,20);
2559:
2560: End appt_transfer_app;
2561:
2562: Procedure mass_transfer_nte is
2562: Procedure mass_transfer_nte is
2563: l_proc varchar2(70) := 'non_sf52_extra_info - mass_transfer_nte';
2564:
2565: Begin
2566: hr_utility.set_location('Entering ' || l_proc,5);
2567: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
2568: p_asg_nte_dates.asg_nte_start_date := l_pa_request_ei_rec.rei_information10;
2569: p_asg_nte_dates.assignment_nte := l_pa_request_ei_rec.rei_information11;
2570: hr_utility.set_location('Leaving ' ||l_proc,20);
2566: hr_utility.set_location('Entering ' || l_proc,5);
2567: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
2568: p_asg_nte_dates.asg_nte_start_date := l_pa_request_ei_rec.rei_information10;
2569: p_asg_nte_dates.assignment_nte := l_pa_request_ei_rec.rei_information11;
2570: hr_utility.set_location('Leaving ' ||l_proc,20);
2571:
2572: End mass_transfer_nte;
2573: --End Bug# 8724192
2574:
2575: Procedure appt_transfer is
2576: l_proc varchar2(70) := 'non_sf52_extra_info - app_3 ';
2577:
2578: Begin
2579: hr_utility.set_location('Entering ' || l_proc,5);
2580: --
2581: --
2582: If l_session.noa_id_correct is not null then
2583: set_extra_info(p_per_group1.agency_code_transfer_from ,
2608: --Bug# 4941984(AFHR2)
2609: End if;
2610: p_per_group1.per_group1_flag := 'Y';
2611: End if;
2612: hr_utility.set_location('cOre CMS ' || p_per_uniformed_services.creditable_military_service,1);
2613: hr_utility.set_location('REI 7 ' || l_pa_request_ei_rec.rei_information7,2);
2614: hr_utility.set_location('REI CMS ' || l_pa_request_ei_rec.rei_information6,2);
2615: --Begin Bug# 12557463, commented following and added in proc ghr_scd_info
2616: --set_extra_info(p_per_uniformed_services.creditable_military_service,
2609: End if;
2610: p_per_group1.per_group1_flag := 'Y';
2611: End if;
2612: hr_utility.set_location('cOre CMS ' || p_per_uniformed_services.creditable_military_service,1);
2613: hr_utility.set_location('REI 7 ' || l_pa_request_ei_rec.rei_information7,2);
2614: hr_utility.set_location('REI CMS ' || l_pa_request_ei_rec.rei_information6,2);
2615: --Begin Bug# 12557463, commented following and added in proc ghr_scd_info
2616: --set_extra_info(p_per_uniformed_services.creditable_military_service,
2617: -- l_pa_request_ei_rec.rei_information6,
2610: p_per_group1.per_group1_flag := 'Y';
2611: End if;
2612: hr_utility.set_location('cOre CMS ' || p_per_uniformed_services.creditable_military_service,1);
2613: hr_utility.set_location('REI 7 ' || l_pa_request_ei_rec.rei_information7,2);
2614: hr_utility.set_location('REI CMS ' || l_pa_request_ei_rec.rei_information6,2);
2615: --Begin Bug# 12557463, commented following and added in proc ghr_scd_info
2616: --set_extra_info(p_per_uniformed_services.creditable_military_service,
2617: -- l_pa_request_ei_rec.rei_information6,
2618: -- p_per_uniformed_services.per_uniformed_services_flag);
2616: --set_extra_info(p_per_uniformed_services.creditable_military_service,
2617: -- l_pa_request_ei_rec.rei_information6,
2618: -- p_per_uniformed_services.per_uniformed_services_flag);
2619: --End Bug# 12557463
2620: hr_utility.set_location('agency code trans from ' || p_per_group1.agency_code_transfer_from,1);
2621: hr_utility.set_location('CMS ' || p_per_uniformed_services.creditable_military_service,2);
2622: set_extra_info(p_asg_non_sf52.Date_Arr_Personnel_office,
2623: l_pa_request_ei_rec.rei_information7, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2624: set_extra_info(p_within_grade_increase.p_date_wgi_due,
2617: -- l_pa_request_ei_rec.rei_information6,
2618: -- p_per_uniformed_services.per_uniformed_services_flag);
2619: --End Bug# 12557463
2620: hr_utility.set_location('agency code trans from ' || p_per_group1.agency_code_transfer_from,1);
2621: hr_utility.set_location('CMS ' || p_per_uniformed_services.creditable_military_service,2);
2622: set_extra_info(p_asg_non_sf52.Date_Arr_Personnel_office,
2623: l_pa_request_ei_rec.rei_information7, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2624: set_extra_info(p_within_grade_increase.p_date_wgi_due,
2625: l_pa_request_ei_rec.rei_information8, p_within_grade_increase.p_wgi_flag, 'N');
2660: --Begin Bug# 14514445
2661: set_extra_info(p_per_group1.promotion_eligibility_date ,
2662: l_pa_request_ei_rec.rei_information27,p_per_group1.per_group1_flag, 'Y');
2663: --End Bug# 14514445
2664: hr_utility.set_location('Leaving ' ||l_proc,20);
2665:
2666: End appt_transfer;
2667: --
2668:
2864: PROCEDURE chg_data_elm is
2865: l_proc varchar2(70) := 'non_sf52_extra - chg_data_elm';
2866: --
2867: Begin
2868: hr_utility.set_location('Entering ' || l_proc,5);
2869:
2870: -- Bug#4126188 begin
2871: IF NVL(l_pa_request_ei_rec.rei_information3,hr_api.g_varchar2) <>
2872: NVL(p_pos_grp1.personnel_office_id,hr_api.g_varchar2) THEN
2875: END IF;
2876: -- Bug#4126188 End
2877: set_extra_info(p_pos_grp1.personnel_office_id,
2878: l_pa_request_ei_rec.rei_information3, p_pos_grp1.pos_grp1_flag, 'Y');
2879: hr_utility.set_location('Leaving '||l_proc,20);
2880:
2881: End chg_data_elm;
2882: --
2883: --
2884: Procedure chg_sched_hours is
2885: l_proc varchar2(70) := 'non_sf52_extra - chg_hours';
2886:
2887: Begin
2888: hr_utility.set_location('Entering ' ||l_proc,5);
2889: set_extra_info(p_per_probations.date_prob_trial_period_begin ,
2890: l_pa_request_ei_rec.rei_information3,p_per_probations.per_probation_flag);
2891: set_extra_info(p_per_probations.date_prob_trial_period_ends ,
2892: l_pa_request_ei_rec.rei_information4,p_per_probations.per_probation_flag);
2906: p_date_effective => p_pa_request_rec.effective_date,
2907: p_screen_entry_value => p_within_grade_increase.p_last_equi_incr);
2908: END IF;
2909: --End added by deenath to fix bug 4542401
2910: hr_utility.set_location('Leaving ' || l_proc,20);
2911:
2912: End chg_sched_hours;
2913: --
2914: --
2915: Procedure chg_ret_plan is
2916: l_proc varchar2(70) := 'non_sf52_extra_info - chg_ret_plan';
2917:
2918: Begin
2919: hr_utility.set_location('Entering ' ||l_proc,5);
2920: set_extra_info(p_per_uniformed_services.creditable_military_service,
2921: l_pa_request_ei_rec.rei_information3,
2922: p_per_uniformed_services.per_uniformed_services_flag, 'Y');
2923: -- Start Bug # 1518650
2933: --Begin Bug# 14769681
2934: set_extra_info(p_per_scd_info.scd_tsp,l_pa_request_ei_rec.rei_information7,
2935: p_per_scd_info.per_scd_info_flag, 'Y');
2936: --End Bug# 14769681
2937: hr_utility.set_location('Leaving ' || l_proc,20);
2938:
2939: END chg_ret_plan;
2940: --
2941: --
2942: -- Begin Bug# 12557463 commented following proc chg_scd
2943: /*PROCEDURE chg_scd is
2944: l_proc varchar2(70) := 'non_sf52_extra - chg_scd';
2945: Begin
2946: hr_utility.set_location('Entering ' ||l_proc,5);
2947: set_extra_info(p_per_scd_info.scd_rif,l_pa_request_ei_rec.rei_information3,
2948: p_per_scd_info.per_scd_info_flag, 'Y');
2949: set_extra_info(p_per_scd_info.scd_civilian,l_pa_request_ei_rec.rei_information4,
2950: p_per_scd_info.per_scd_info_flag, 'Y');
2975: set_extra_info (p_per_scd_info.scd_creditable_svc_annl_leave,l_pa_request_ei_rec.rei_information12,
2976: p_per_scd_info.per_scd_info_flag, 'Y');
2977:
2978:
2979: hr_utility.set_location('Leaving ' ||l_proc,10);
2980: End chg_scd;*/
2981: --End Bug# 12557463
2982: --
2983: --Begin bug# 14751665,15882322,15882330
2983: --Begin bug# 14751665,15882322,15882330
2984: PROCEDURE prv_ret_info IS
2985: l_proc varchar2(70) DEFAULT 'non_sf52_extra - prv_ret_info';
2986: BEGIN
2987: hr_utility.set_location ('Entering '|| l_proc, 5);
2988:
2989: set_extra_info (p_per_separate_retire.prev_retirement_coverage, l_pa_request_ei_rec.rei_information1
2990: , p_per_separate_retire.per_sep_retire_flag, 'Y');
2991:
2988:
2989: set_extra_info (p_per_separate_retire.prev_retirement_coverage, l_pa_request_ei_rec.rei_information1
2990: , p_per_separate_retire.per_sep_retire_flag, 'Y');
2991:
2992: hr_utility.set_location ('Leaving '|| l_proc, 10);
2993: END prv_ret_info;
2994:
2995: --End Bug# 14751665,15882322,15882330
2996: --
2996: --
2997: Procedure conv_appt is
2998: l_proc varchar2(70) := 'non_sf52_extra - conv_1';
2999: Begin
3000: hr_utility.set_location('Entering ' ||l_proc,5);
3001: If l_session.noa_id_correct is not null then
3002: set_extra_info(p_per_group1.appointment_type,
3003: l_pa_request_ei_rec.rei_information3,p_per_group1.per_group1_flag);
3004: set_extra_info(p_per_group1.org_appointment_auth_code1,
3111: -- set_extra_info(p_within_grade_increase.p_date_wgi_due ,
3112: -- l_pa_request_ei_rec.rei_information6,p_within_grade_increase.p_wgi_flag);
3113:
3114: */
3115: hr_utility.set_location('Leaving ' ||l_proc,10);
3116:
3117: END conv_appt;
3118: --
3119: --
3125: --
3126: --
3127: -- Updating the record groups with NON SF52
3128: --
3129: hr_utility.set_location('Entering ' ||l_proc,5);
3130: If l_session.noa_id_correct is not null then
3131: set_extra_info(p_within_grade_increase.p_date_wgi_due,
3132: l_pa_request_ei_rec.rei_information3,p_within_grade_increase.p_wgi_flag);
3133: set_extra_info(p_within_grade_increase.p_date_wgi_postpone_effective,
3137: p_within_grade_increase.p_date_wgi_postpone_effective := l_pa_request_ei_rec.rei_information4;
3138: p_within_grade_increase.p_wgi_flag := 'Y';
3139: End if;
3140:
3141: hr_utility.set_location('Leaving ' ||l_proc,10);
3142:
3143: End denial_wgi;
3144: --
3145: --
3150:
3151: --
3152: -- Updating the record groups with NON SF52
3153: --
3154: hr_utility.set_location('Entering ' ||l_proc,5);
3155: set_extra_info(p_asg_nte_dates.assignment_nte,
3156: l_pa_request_ei_rec.rei_information3,p_asg_nte_dates.asg_nte_dates_flag);
3157: set_extra_info(p_within_grade_increase.p_date_wgi_due ,
3158: l_pa_request_ei_rec.rei_information4,p_within_grade_increase.p_wgi_flag);
3162: l_pa_request_ei_rec.rei_information6,p_asg_nte_dates.asg_nte_dates_flag);
3163: set_extra_info(p_asg_nte_dates.suspension_nte ,
3164: l_pa_request_ei_rec.rei_information7,p_asg_nte_dates.asg_nte_dates_flag);
3165: --
3166: hr_utility.set_location('Leaving ' ||l_proc,10);
3167:
3168: End ext_asgn_nte ;
3169: --
3170: --
3171: Procedure posn_chg is
3172: l_proc varchar2(72) := 'non_sf52_extra - posn_chg';
3173:
3174: Begin
3175: hr_utility.set_location('Entering ' ||l_proc,5);
3176: set_extra_info(p_per_retained_grade.date_from ,
3177: l_pa_request_ei_rec.rei_information1,p_per_retained_grade.per_retained_grade_flag);
3178: set_extra_info(p_per_retained_grade.date_to ,
3179: l_pa_request_ei_rec.rei_information2,p_per_retained_grade.per_retained_grade_flag);
3192: -- Begin bug# 4126188
3193: set_extra_info(p_asg_non_sf52.date_arr_personnel_office,
3194: l_pa_request_ei_rec.rei_information15, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
3195: -- End bug# 4126188
3196: hr_utility.set_location('Leaving ' ||l_proc,10);
3197:
3198: End posn_chg;
3199: --
3200: -- Begin bug# 4126188
3200: -- Begin bug# 4126188
3201: Procedure rg_posn_chg is
3202: l_proc varchar2(72) := 'non_sf52_extra - rg_posn_chg';
3203: Begin
3204: hr_utility.set_location('Entering ' ||l_proc,5);
3205: set_extra_info(p_asg_non_sf52.date_arr_personnel_office,
3206: l_pa_request_ei_rec.rei_information15, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
3207: hr_utility.set_location('Leaving ' ||l_proc,10);
3208: End rg_posn_chg;
3203: Begin
3204: hr_utility.set_location('Entering ' ||l_proc,5);
3205: set_extra_info(p_asg_non_sf52.date_arr_personnel_office,
3206: l_pa_request_ei_rec.rei_information15, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
3207: hr_utility.set_location('Leaving ' ||l_proc,10);
3208: End rg_posn_chg;
3209: -- End bug# 4126188
3210:
3211: Procedure salary_change is
3211: Procedure salary_change is
3212: l_proc varchar2(72) := 'non_sf52_extra - salary change';
3213:
3214: Begin
3215: hr_utility.set_location('Entering ' ||l_proc,5);
3216: If l_session.noa_id_correct is not null then
3217: set_extra_info(p_within_grade_increase.p_date_wgi_postpone_effective,
3218: l_pa_request_ei_rec.rei_information3,p_within_grade_increase.p_wgi_flag);
3219:
3251: PROCEDURE realign is
3252: l_proc varchar2(70) := 'non_sf52_extra - realign';
3253:
3254: Begin
3255: hr_utility.set_location('Entering ' ||l_proc,5);
3256: set_extra_info(p_asg_non_sf52.Date_Arr_Personnel_office ,
3257: l_pa_request_ei_rec.rei_information3,p_asg_non_sf52.asg_non_sf52_flag);
3258:
3259: set_extra_info(p_pos_grp1.payroll_office_id ,
3284: if l_pa_request_ei_rec.rei_information10 is not null then
3285: p_pa_request_rec.agency_code := l_pa_request_ei_rec.rei_information10;
3286: end If;
3287:
3288: hr_utility.set_location('Leaving ' ||l_proc,10);
3289:
3290: End realign ;
3291: --
3292: --
3292: --
3293: Procedure reassign is
3294: l_proc varchar2(70) := 'non_sf52_extra_info - reassign';
3295: Begin
3296: hr_utility.set_location('Entering ' ||l_proc,5);
3297: /* -- Commented - Venkat - Bug # 957209 -- 08/06/1999
3298: set_extra_info(p_asg_non_sf52.key_emer_essential_empl ,
3299: l_pa_request_ei_rec.rei_information3,p_asg_non_sf52.asg_non_sf52_flag);
3300: */
3311: --Begin Bug# 14514445
3312: set_extra_info(p_per_group1.promotion_eligibility_date ,
3313: l_pa_request_ei_rec.rei_information8,p_per_group1.per_group1_flag, 'Y');
3314: --End Bug# 14514445
3315: hr_utility.set_location('Leaving ' ||l_proc,10);
3316:
3317: End reassign;
3318: --
3319:
3321: l_proc varchar2(70) := 'non_sf52_extra - return_to_duty';
3322:
3323: Begin
3324:
3325: hr_utility.set_location('Entering ' ||l_proc,5);
3326: --Begin Bug# 12557463, commented following and added in proc ghr_scd_info
3327: /*set_extra_info(p_per_uniformed_services.creditable_military_service ,
3328: l_pa_request_ei_rec.rei_information3,
3329: p_per_uniformed_services.per_uniformed_services_flag, 'Y');
3342: --Bug # 12652438
3343: set_extra_info(p_asg_non_sf52.pay_status_userra_status,l_pa_request_ei_rec.rei_information10,
3344: p_asg_non_sf52.asg_non_sf52_flag, 'Y');
3345:
3346: hr_utility.set_location('Leaving ' ||l_proc,10);
3347:
3348: End return_to_duty;
3349: --
3350: --
3352: l_proc varchar2(70) := 'non_sf52_extra - separate3';
3353:
3354: Begin
3355:
3356: hr_utility.set_location('Entering ' ||l_proc,5);
3357: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
3358: p_per_separate_retire.agency_code_transfer_to ,10);
3359: set_extra_info(p_per_separate_retire.agency_code_transfer_to,
3360: l_pa_request_ei_rec.rei_information3,p_per_separate_Retire.per_sep_Retire_flag);
3353:
3354: Begin
3355:
3356: hr_utility.set_location('Entering ' ||l_proc,5);
3357: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
3358: p_per_separate_retire.agency_code_transfer_to ,10);
3359: set_extra_info(p_per_separate_retire.agency_code_transfer_to,
3360: l_pa_request_ei_rec.rei_information3,p_per_separate_Retire.per_sep_Retire_flag);
3361: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
3357: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
3358: p_per_separate_retire.agency_code_transfer_to ,10);
3359: set_extra_info(p_per_separate_retire.agency_code_transfer_to,
3360: l_pa_request_ei_rec.rei_information3,p_per_separate_Retire.per_sep_Retire_flag);
3361: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
3362: p_per_separate_retire.agency_code_transfer_to ,10);
3363: hr_utility.set_location('Leaving ' ||l_proc,10);
3364:
3365: End separate352 ;
3359: set_extra_info(p_per_separate_retire.agency_code_transfer_to,
3360: l_pa_request_ei_rec.rei_information3,p_per_separate_Retire.per_sep_Retire_flag);
3361: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
3362: p_per_separate_retire.agency_code_transfer_to ,10);
3363: hr_utility.set_location('Leaving ' ||l_proc,10);
3364:
3365: End separate352 ;
3366: --
3367: --
3368: Procedure recruitment_bonus is
3369: l_proc varchar2(70) := 'non_sf52_extra - recruitment_bonus';
3370:
3371: Begin
3372: hr_utility.set_location('Entering ' ||l_proc,5);
3373: If l_session.noa_id_correct is not null then
3374: set_extra_info(p_recruitment_bonus.p_date_recruit_exp,
3375: l_pa_request_ei_rec.rei_information3,p_recruitment_bonus.p_recruitment_bonus_flag);
3376: Else
3375: l_pa_request_ei_rec.rei_information3,p_recruitment_bonus.p_recruitment_bonus_flag);
3376: Else
3377: p_recruitment_bonus.p_date_recruit_exp := l_pa_request_ei_rec.rei_information3 ;
3378: p_recruitment_bonus.p_recruitment_bonus_flag := 'Y';
3379: hr_utility.set_location('Leaving ' ||l_proc,10);
3380: End if;
3381:
3382: End recruitment_bonus;
3383: --
3385: Procedure relocation_bonus is
3386: l_proc varchar2(70) := 'non_sf52_extra - relocation_bonus';
3387:
3388: Begin
3389: hr_utility.set_location('Entering ' ||l_proc,5);
3390: If l_session.noa_id_correct is not null then
3391: set_extra_info(p_relocation_bonus.p_date_reloc_exp,
3392: l_pa_request_ei_rec.rei_information3,p_relocation_bonus.p_relocation_bonus_flag );
3393: Else
3393: Else
3394: p_relocation_bonus.p_date_reloc_exp := l_pa_request_ei_rec.rei_information3;
3395: p_relocation_bonus.p_relocation_bonus_flag := 'Y';
3396: End if;
3397: hr_utility.set_location('Leaving ' ||l_proc,10);
3398:
3399: End relocation_bonus;
3400: --
3401:
3420: -- Bug # 1060184 -- Venkat 03/01/00
3421: p_gov_awards.award_appropriation_code := l_pa_request_ei_rec.rei_information10;
3422: p_gov_awards.date_exemp_award := l_pa_request_ei_rec.rei_information11;
3423:
3424: hr_utility.set_location('date award -pre ' || p_gov_awards.date_award_earned,2);
3425: If p_gov_awards.award_agency is not null or
3426: p_gov_awards.award_type is not null or
3427: p_gov_awards.group_award is not null or
3428: p_gov_awards.tangible_benefit_dollars is not null or
3511: Procedure service_obligation is
3512: l_proc varchar2(70) := 'non_sf52_extra - service_obligation';
3513:
3514: Begin
3515: hr_utility.set_location('Entering ' ||l_proc,5);
3516: If l_session.noa_id_correct is null then
3517: --6510320 Added the if condition of not creating the service obligation entry
3518: --in person EI if all the segments are null
3519: If l_pa_request_ei_rec.rei_information3 is not null or
3523: p_per_service_oblig.service_oblig_start_date := l_pa_request_ei_rec.rei_information4;
3524: p_per_service_oblig.service_oblig_end_date := l_pa_request_ei_rec.rei_information5;
3525: p_per_service_oblig.per_service_oblig_flag := 'Y';
3526: End If;
3527: hr_utility.set_location('Leaving ' ||l_proc,10);
3528: End if;
3529:
3530: End service_obligation;
3531: --
3533: Procedure incentive_retention is
3534: l_proc varchar2(70) := 'non_sf52_extra - incentive_retention';
3535:
3536: Begin
3537: hr_utility.set_location('Entering ' ||l_proc,5);
3538: If l_session.noa_id_correct is not null then
3539: set_extra_info(p_per_group1.retention_inc_review_date ,
3540: l_pa_request_ei_rec.rei_information3,
3541: p_per_group1.per_group1_flag);
3565: p_conduct_performance.pip_extensions := l_pa_request_ei_rec.rei_information13;
3566: p_conduct_performance.pip_length := l_pa_request_ei_rec.rei_information14;
3567: p_conduct_performance.date_reprimand_expires := l_pa_request_ei_rec.rei_information15;
3568:
3569: hr_utility.set_location('non_pay_duty_status ', 20);
3570: -- If atleast one of the above is not null , then set the flag to 'Y'
3571:
3572: If p_conduct_performance.adverse_action_noac is not null or
3573: p_conduct_performance.cause_of_disc_action is not null or
3581: p_conduct_performance.pip_extensions is not null or
3582: p_conduct_performance.pip_length is not null or
3583: p_conduct_performance.date_reprimand_expires is not null then
3584: p_conduct_performance.cond_perf_flag := 'Y';
3585: hr_utility.set_location('non_pay_duty_status ', 25);
3586: End if;
3587:
3588: if l_session.noa_id_correct is not null then
3589: hr_utility.set_location('non_pay_duty_status ', 30);
3585: hr_utility.set_location('non_pay_duty_status ', 25);
3586: End if;
3587:
3588: if l_session.noa_id_correct is not null then
3589: hr_utility.set_location('non_pay_duty_status ', 30);
3590:
3591: ghr_history_fetch.return_special_information
3592: (p_person_id => p_pa_request_rec.person_id,
3593: p_structure_name => 'US Fed Conduct Perf',
3594: p_effective_date => p_pa_request_rec.effective_date,
3595: p_special_info => l_special_info_type
3596: );
3597:
3598: hr_utility.set_location('non_pay_duty_status :person analysis id '||l_special_info_type.person_analysis_id, 31);
3599: hr_utility.set_location('non_pay_duty_status :ovn '||l_special_info_type.object_version_number, 32);
3600: hr_utility.set_location('non_pay_duty_status :segment1 '||l_special_info_type.segment1, 33);
3601: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3602: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3595: p_special_info => l_special_info_type
3596: );
3597:
3598: hr_utility.set_location('non_pay_duty_status :person analysis id '||l_special_info_type.person_analysis_id, 31);
3599: hr_utility.set_location('non_pay_duty_status :ovn '||l_special_info_type.object_version_number, 32);
3600: hr_utility.set_location('non_pay_duty_status :segment1 '||l_special_info_type.segment1, 33);
3601: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3602: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3603: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3596: );
3597:
3598: hr_utility.set_location('non_pay_duty_status :person analysis id '||l_special_info_type.person_analysis_id, 31);
3599: hr_utility.set_location('non_pay_duty_status :ovn '||l_special_info_type.object_version_number, 32);
3600: hr_utility.set_location('non_pay_duty_status :segment1 '||l_special_info_type.segment1, 33);
3601: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3602: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3603: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3604: hr_utility.set_location('non_pay_duty_status :segment5 '||l_special_info_type.segment5, 37);
3597:
3598: hr_utility.set_location('non_pay_duty_status :person analysis id '||l_special_info_type.person_analysis_id, 31);
3599: hr_utility.set_location('non_pay_duty_status :ovn '||l_special_info_type.object_version_number, 32);
3600: hr_utility.set_location('non_pay_duty_status :segment1 '||l_special_info_type.segment1, 33);
3601: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3602: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3603: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3604: hr_utility.set_location('non_pay_duty_status :segment5 '||l_special_info_type.segment5, 37);
3605: hr_utility.set_location('non_pay_duty_status :segment6 '||l_special_info_type.segment6, 38);
3598: hr_utility.set_location('non_pay_duty_status :person analysis id '||l_special_info_type.person_analysis_id, 31);
3599: hr_utility.set_location('non_pay_duty_status :ovn '||l_special_info_type.object_version_number, 32);
3600: hr_utility.set_location('non_pay_duty_status :segment1 '||l_special_info_type.segment1, 33);
3601: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3602: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3603: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3604: hr_utility.set_location('non_pay_duty_status :segment5 '||l_special_info_type.segment5, 37);
3605: hr_utility.set_location('non_pay_duty_status :segment6 '||l_special_info_type.segment6, 38);
3606: hr_utility.set_location('non_pay_duty_status :segment7 '||l_special_info_type.segment7, 39);
3599: hr_utility.set_location('non_pay_duty_status :ovn '||l_special_info_type.object_version_number, 32);
3600: hr_utility.set_location('non_pay_duty_status :segment1 '||l_special_info_type.segment1, 33);
3601: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3602: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3603: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3604: hr_utility.set_location('non_pay_duty_status :segment5 '||l_special_info_type.segment5, 37);
3605: hr_utility.set_location('non_pay_duty_status :segment6 '||l_special_info_type.segment6, 38);
3606: hr_utility.set_location('non_pay_duty_status :segment7 '||l_special_info_type.segment7, 39);
3607:
3600: hr_utility.set_location('non_pay_duty_status :segment1 '||l_special_info_type.segment1, 33);
3601: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3602: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3603: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3604: hr_utility.set_location('non_pay_duty_status :segment5 '||l_special_info_type.segment5, 37);
3605: hr_utility.set_location('non_pay_duty_status :segment6 '||l_special_info_type.segment6, 38);
3606: hr_utility.set_location('non_pay_duty_status :segment7 '||l_special_info_type.segment7, 39);
3607:
3608: p_conduct_performance.person_analysis_id := l_special_info_type.person_analysis_id;
3601: hr_utility.set_location('non_pay_duty_status :segment2 '||l_special_info_type.segment2, 34);
3602: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3603: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3604: hr_utility.set_location('non_pay_duty_status :segment5 '||l_special_info_type.segment5, 37);
3605: hr_utility.set_location('non_pay_duty_status :segment6 '||l_special_info_type.segment6, 38);
3606: hr_utility.set_location('non_pay_duty_status :segment7 '||l_special_info_type.segment7, 39);
3607:
3608: p_conduct_performance.person_analysis_id := l_special_info_type.person_analysis_id;
3609: p_conduct_performance.object_version_number := l_special_info_type.object_version_number;
3602: hr_utility.set_location('non_pay_duty_status :segment3 '||l_special_info_type.segment3, 35);
3603: hr_utility.set_location('non_pay_duty_status :segment4 '||l_special_info_type.segment4, 36);
3604: hr_utility.set_location('non_pay_duty_status :segment5 '||l_special_info_type.segment5, 37);
3605: hr_utility.set_location('non_pay_duty_status :segment6 '||l_special_info_type.segment6, 38);
3606: hr_utility.set_location('non_pay_duty_status :segment7 '||l_special_info_type.segment7, 39);
3607:
3608: p_conduct_performance.person_analysis_id := l_special_info_type.person_analysis_id;
3609: p_conduct_performance.object_version_number := l_special_info_type.object_version_number;
3610: if p_conduct_performance.cause_of_disc_action is null then
3649: --Bug # 12652438
3650: set_extra_info(p_asg_non_sf52.pay_status_userra_status,
3651: l_pa_request_ei_rec.rei_information15,
3652: p_asg_non_sf52.asg_non_sf52_flag, 'Y');
3653: hr_utility.set_location('non_pay_duty_status ', 40);
3654:
3655: End non_pay_duty_status;
3656: --
3657: --
3687: begin
3688: l_request_id := p_request_id;
3689: loop
3690: for c2_rec in c2(l_request_id) loop
3691: hr_utility.set_location('inside fetch extra info id loop',1);
3692: if c2_rec.rei_information3 is not null then
3693: l_extra_info_id := c2_rec.rei_information3;
3694: else
3695: l_request_id := c2_rec.pa_request_id;
3698: if l_extra_info_id is not null then
3699: exit;
3700: end if;
3701: end loop;
3702: hr_utility.set_location('Leaving fetch extra_info_id',1);
3703: return(l_extra_info_id);
3704: end fetch_extra_info_id;
3705: --
3706: --
3724: elsif l_pa_request_ei_rec.rei_information3 is not null then
3725: -- fetch the ovn, set flag to Y
3726: for c1_rec in c1(l_pa_request_ei_rec.rei_information3) loop
3727: p_per_retained_grade.person_extra_info_id := c1_rec.person_extra_info_id;
3728: hr_utility.set_location('RG 866 - set pei id',1);
3729: If l_session.noa_id_correct is null then
3730: p_per_retained_grade.object_version_number := c1_rec.object_version_number;
3731: hr_utility.set_location('non correction -- RG 866',1);
3732: p_per_retained_grade.per_retained_grade_flag := 'Y';
3727: p_per_retained_grade.person_extra_info_id := c1_rec.person_extra_info_id;
3728: hr_utility.set_location('RG 866 - set pei id',1);
3729: If l_session.noa_id_correct is null then
3730: p_per_retained_grade.object_version_number := c1_rec.object_version_number;
3731: hr_utility.set_location('non correction -- RG 866',1);
3732: p_per_retained_grade.per_retained_grade_flag := 'Y';
3733: end if;
3734: end loop;
3735: end if;
3734: end loop;
3735: end if;
3736:
3737:
3738: hr_utility.set_location('leaving par term ret gr',1);
3739:
3740: End term_retained_grade;
3741: --
3742: --
3749: (NVL(p_pa_request_rec.first_action_la_code1,'111') = 'RBM' or NVL(p_pa_request_rec.first_action_la_code2,'111') = 'RBM'))
3750: OR
3751: (p_pa_request_rec.second_noa_code = '892' AND
3752: (NVL(p_pa_request_rec.second_action_la_code1,'111') = 'RBM' or NVL(p_pa_request_rec.second_action_la_code2,'111') = 'RBM')) then
3753: hr_utility.set_location('Entering ' ||l_proc,55);
3754: p_gov_awards.award_agency := l_pa_request_ei_rec.rei_information3;
3755: p_gov_awards.award_type := '07';
3756: p_gov_awards.date_award_earned := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
3757:
3771: l_proc varchar2(70) := 'non_sf52_extra_info - entitlement';
3772:
3773: Begin
3774: --
3775: hr_utility.set_location('Entering ' ||l_proc,5);
3776: --
3777: p_entitlement.entitlement_code := l_pa_request_ei_rec.rei_information3;
3778: p_entitlement.entitlement_amt_percent := l_pa_request_ei_rec.rei_information4;
3779: --Venkat 05/00 -- Bug# 1140536
3776: --
3777: p_entitlement.entitlement_code := l_pa_request_ei_rec.rei_information3;
3778: p_entitlement.entitlement_amt_percent := l_pa_request_ei_rec.rei_information4;
3779: --Venkat 05/00 -- Bug# 1140536
3780: hr_utility.set_location('entitlement code is '||p_entitlement.entitlement_code ||l_proc,6);
3781: if nvl(p_entitlement.entitlement_code,hr_api.g_varchar2) = '9'
3782: and substr(nvl(p_pa_request_rec.duty_station_code,hr_api.g_varchar2),1,2)
3783: not in ('02','15','AQ','CQ','DQ',
3784: 'FQ','GQ','HQ','JQ','KQ',
3782: and substr(nvl(p_pa_request_rec.duty_station_code,hr_api.g_varchar2),1,2)
3783: not in ('02','15','AQ','CQ','DQ',
3784: 'FQ','GQ','HQ','JQ','KQ',
3785: 'LQ','MQ','RQ','VQ','WQ') then
3786: hr_utility.set_message(8301,'GHR_38030_INV_DS_4_NON_F_COLA');
3787: hr_utility.raise_error;
3788: end if;
3789: if nvl(p_entitlement.entitlement_code,hr_api.g_varchar2) = 'C'
3790: and substr(nvl(p_pa_request_rec.duty_station_code,hr_api.g_varchar2),1,2)
3783: not in ('02','15','AQ','CQ','DQ',
3784: 'FQ','GQ','HQ','JQ','KQ',
3785: 'LQ','MQ','RQ','VQ','WQ') then
3786: hr_utility.set_message(8301,'GHR_38030_INV_DS_4_NON_F_COLA');
3787: hr_utility.raise_error;
3788: end if;
3789: if nvl(p_entitlement.entitlement_code,hr_api.g_varchar2) = 'C'
3790: and substr(nvl(p_pa_request_rec.duty_station_code,hr_api.g_varchar2),1,2)
3791: in ('02','15','AQ','CQ','DQ',
3790: and substr(nvl(p_pa_request_rec.duty_station_code,hr_api.g_varchar2),1,2)
3791: in ('02','15','AQ','CQ','DQ',
3792: 'FQ','GQ','HQ','JQ','KQ',
3793: 'LQ','MQ','RQ','VQ','WQ') then
3794: hr_utility.set_message(8301,'GHR_38032_INV_DS_4_COLA');
3795: hr_utility.raise_error;
3796: end if;
3797: if p_entitlement.entitlement_code is not null or
3798: p_entitlement.entitlement_amt_percent is not null then
3791: in ('02','15','AQ','CQ','DQ',
3792: 'FQ','GQ','HQ','JQ','KQ',
3793: 'LQ','MQ','RQ','VQ','WQ') then
3794: hr_utility.set_message(8301,'GHR_38032_INV_DS_4_COLA');
3795: hr_utility.raise_error;
3796: end if;
3797: if p_entitlement.entitlement_code is not null or
3798: p_entitlement.entitlement_amt_percent is not null then
3799: p_entitlement.entitlement_flag := 'Y';
3818: );
3819: end if;
3820: end if;
3821: --
3822: hr_utility.set_location('Leaving ' ||l_proc,5);
3823: --
3824: END entitlement;
3825: --
3826: --
3827: Procedure for_lang_pay is
3828: l_proc varchar2(70) := 'non_sf52_extra_info - for_lang_pay';
3829: Begin
3830: --
3831: hr_utility.set_location('Entering ' ||l_proc,5);
3832: --
3833: p_foreign_lang_prof_pay.certification_date := l_pa_request_ei_rec.rei_information3;
3834: p_foreign_lang_prof_pay.pay_level_or_rate := l_pa_request_ei_rec.rei_information4;
3835: if p_foreign_lang_prof_pay.certification_date is not null or
3856: );
3857: end if;
3858: end if;
3859: --
3860: hr_utility.set_location('Leaving ' ||l_proc,5);
3861: --
3862: END for_lang_pay;
3863: --
3864: Procedure fta is
3864: Procedure fta is
3865: l_proc varchar2(70) := 'non_sf52_extra_info - fta';
3866: Begin
3867: --
3868: hr_utility.set_location('Entering ' ||l_proc,5);
3869: --
3870: p_imm_fta.last_action_code := l_pa_request_ei_rec.rei_information3;
3871: p_imm_fta.number_family_members := l_pa_request_ei_rec.rei_information4;
3872: p_imm_fta.Miscellaneous_Expense:= l_pa_request_ei_rec.rei_information5;
3890: Procedure edp_pay is
3891: l_proc varchar2(70) := 'non_sf52_extra_info - edp_pay';
3892: Begin
3893: --
3894: hr_utility.set_location('Entering ' ||l_proc,5);
3895: --
3896: p_edp_pay.premium_pay_indicator := l_pa_request_ei_rec.rei_information3;
3897: p_edp_pay.edp_type := l_pa_request_ei_rec.rei_information4;
3898: if p_edp_pay.premium_pay_indicator is not null or
3919: );
3920: end if;
3921: end if;
3922: --
3923: hr_utility.set_location('Leaving ' ||l_proc,5);
3924: --
3925: END edp_pay;
3926: --
3927: --
3928: Procedure hazard_pay is
3929: l_proc varchar2(70) := 'non_sf52_extra_info - hazard_pay';
3930: Begin
3931: --
3932: hr_utility.set_location('Entering ' ||l_proc,5);
3933: --
3934: p_hazard_pay.premium_pay_indicator := l_pa_request_ei_rec.rei_information3;
3935: p_hazard_pay.hazard_type := l_pa_request_ei_rec.rei_information4;
3936: if p_hazard_pay.premium_pay_indicator is not null or
3957: );
3958: end if;
3959: end if;
3960: --
3961: hr_utility.set_location('Leaving ' ||l_proc,10);
3962: --
3963: END hazard_pay;
3964: --
3965: --
3966: Procedure health_benefits is
3967: l_proc varchar2(70) := 'non_sf52_extra_info - health_benefits';
3968: Begin
3969: --
3970: hr_utility.set_location('Entering ' ||l_proc,5);
3971: --
3972: p_health_benefits.enrollment := l_pa_request_ei_rec.rei_information3;
3973: p_health_benefits.health_plan := l_pa_request_ei_rec.rei_information4;
3974: p_health_benefits.temps_total_cost := l_pa_request_ei_rec.rei_information5;
4017: );
4018: end if;
4019: end if;
4020: --
4021: hr_utility.set_location('Leaving ' ||l_proc,5);
4022: --
4023: END health_benefits;
4024: --
4025: --
4026: Procedure health_ben_pre_tax is
4027: l_proc varchar2(70) := 'non_sf52_extra_info - health_ben_pre_tax';
4028: Begin
4029: --
4030: hr_utility.set_location('Entering ' ||l_proc,5);
4031: --
4032: p_health_ben_pre_tax.enrollment := l_pa_request_ei_rec.rei_information3;
4033: p_health_ben_pre_tax.health_plan := l_pa_request_ei_rec.rei_information4;
4034: p_health_ben_pre_tax.temps_total_cost := l_pa_request_ei_rec.rei_information5;
4066: );
4067: end if;
4068: end if;
4069: --
4070: hr_utility.set_location('Leaving ' ||l_proc,5);
4071: --
4072: END health_ben_pre_tax;
4073: --
4074: Procedure danger_pay is
4074: Procedure danger_pay is
4075: l_proc varchar2(70) := 'non_sf52_extra_info - danger_pay';
4076: Begin
4077: --
4078: hr_utility.set_location('Entering ' ||l_proc,5);
4079: --
4080: p_danger_pay.last_action_code := l_pa_request_ei_rec.rei_information3;
4081: p_danger_pay.location := l_pa_request_ei_rec.rei_information4;
4082: if p_danger_pay.last_action_code is not null or
4103: );
4104: end if;
4105: end if;
4106: --
4107: hr_utility.set_location('Leaving ' ||l_proc,5);
4108: --
4109: END danger_pay;
4110: --
4111: --
4112: Procedure imminent_danger_pay is
4113: l_proc varchar2(70) := 'non_sf52_extra_info - imminent_danger_pay';
4114: Begin
4115: --
4116: hr_utility.set_location('Entering ' ||l_proc,5);
4117: --
4118: p_imminent_danger_pay.amount := l_pa_request_ei_rec.rei_information3;
4119: p_imminent_danger_pay.location := l_pa_request_ei_rec.rei_information4;
4120: p_imminent_danger_pay.last_action_code := l_pa_request_ei_rec.rei_information5;
4152: );
4153: end if;
4154: end if;
4155: --
4156: hr_utility.set_location('Leaving ' ||l_proc,5);
4157: --
4158: END imminent_danger_pay;
4159: --
4160: --
4161: Procedure living_quarters_allow is
4162: l_proc varchar2(70) := 'non_sf52_extra_info - living_quarters_allow';
4163: Begin
4164: --
4165: hr_utility.set_location('Entering ' ||l_proc,5);
4166: --
4167: p_living_quarters_allow.purchase_amount := l_pa_request_ei_rec.rei_information3;
4168: p_living_quarters_allow.purchase_date := l_pa_request_ei_rec.rei_information4;
4169: p_living_quarters_allow.rent_amount := l_pa_request_ei_rec.rei_information5;
4302: );
4303: end if;
4304: end if;
4305: --
4306: hr_utility.set_location('Leaving ' ||l_proc,5);
4307: --
4308: END living_quarters_allow;
4309: --
4310: --
4311: Procedure post_diff_amt is
4312: l_proc varchar2(70) := 'non_sf52_extra_info - post_diff_amt';
4313: Begin
4314: --
4315: hr_utility.set_location('Entering ' ||l_proc,5);
4316: --
4317: p_post_diff_amt.amount := l_pa_request_ei_rec.rei_information3;
4318: p_post_diff_amt.last_action_code := l_pa_request_ei_rec.rei_information4;
4319: p_post_diff_amt.location := l_pa_request_ei_rec.rei_information5;
4368: );
4369: end if;
4370: end if;
4371: --
4372: hr_utility.set_location('Leaving ' ||l_proc,5);
4373: --
4374: END post_diff_amt;
4375: --
4376: --
4377: Procedure post_diff_percent is
4378: l_proc varchar2(70) := 'non_sf52_extra_info - post_diff_percent';
4379: Begin
4380: --
4381: hr_utility.set_location('Entering ' ||l_proc,5);
4382: --
4383: p_post_diff_percent.percent := l_pa_request_ei_rec.rei_information3;
4384: p_post_diff_percent.last_action_code := l_pa_request_ei_rec.rei_information4;
4385: p_post_diff_percent.location := l_pa_request_ei_rec.rei_information5;
4420: );
4421: end if;
4422: end if;
4423: --
4424: hr_utility.set_location('Leaving ' ||l_proc,5);
4425: --
4426: END post_diff_percent;
4427: --
4428: --
4429: Procedure sep_maintenance_allow is
4430: l_proc varchar2(70) := 'non_sf52_extra_info - sep_maintenance_allow';
4431: Begin
4432: --
4433: hr_utility.set_location('Entering ' ||l_proc,5);
4434: --
4435: p_sep_maintenance_allow.amount := l_pa_request_ei_rec.rei_information3;
4436: p_sep_maintenance_allow.last_action_code := l_pa_request_ei_rec.rei_information4;
4437: p_sep_maintenance_allow.category := l_pa_request_ei_rec.rei_information5;
4470: );
4471: end if;
4472: end if;
4473: --
4474: hr_utility.set_location('Leaving ' ||l_proc,5);
4475: --
4476: END sep_maintenance_allow;
4477: --
4478: --
4479: Procedure supplemental_post_allow is
4480: l_proc varchar2(70) := 'non_sf52_extra_info - supplemental_post_allow';
4481: Begin
4482: --
4483: hr_utility.set_location('Entering ' ||l_proc,5);
4484: --
4485: p_supplemental_post_allow.amount := l_pa_request_ei_rec.rei_information3;
4486:
4487: if p_supplemental_post_allow.amount is not null then
4497: p_screen_entry_value => p_supplemental_post_allow.amount
4498: );
4499: end if;
4500: End if;
4501: hr_utility.set_location('Leaving ' ||l_proc,5);
4502: --
4503: END supplemental_post_allow;
4504: --
4505: --
4506: Procedure temp_lodge_allow is
4507: l_proc varchar2(70) := 'non_sf52_extra_info - temp_lodge_allow';
4508: Begin
4509: --
4510: hr_utility.set_location('Entering ' ||l_proc,5);
4511: --
4512: p_temp_lodge_allow.allowance_type := l_pa_request_ei_rec.rei_information3;
4513: p_temp_lodge_allow.daily_rate := l_pa_request_ei_rec.rei_information4;
4514:
4535: p_screen_entry_value => p_temp_lodge_allow.daily_rate
4536: );
4537: end if;
4538: End if;
4539: hr_utility.set_location('Leaving ' ||l_proc,5);
4540: --
4541: END temp_lodge_allow;
4542: --
4543: --
4544: Procedure premium_pay is
4545: l_proc varchar2(70) := 'non_sf52_extra_info - premium_pay';
4546: Begin
4547: --
4548: hr_utility.set_location('Entering ' ||l_proc,5);
4549: --
4550: p_premium_pay.premium_pay_ind := l_pa_request_ei_rec.rei_information3;
4551: p_premium_pay.amount := l_pa_request_ei_rec.rei_information4;
4552:
4573: p_screen_entry_value => p_premium_pay.amount
4574: );
4575: end if;
4576: End if;
4577: hr_utility.set_location('Leaving ' ||l_proc,5);
4578: --
4579: END premium_pay;
4580: --
4581: --
4582: Procedure retirement_annuity is
4583: l_proc varchar2(70) := 'non_sf52_extra_info - retirement_annuity';
4584: Begin
4585: --
4586: hr_utility.set_location('Entering ' ||l_proc,5);
4587: --
4588: p_retirement_annuity.annuity_sum := l_pa_request_ei_rec.rei_information3;
4589: p_retirement_annuity.eligibility_expires := l_pa_request_ei_rec.rei_information4;
4590:
4611: p_screen_entry_value => p_retirement_annuity.eligibility_expires
4612: );
4613: end if;
4614: End if;
4615: hr_utility.set_location('Leaving ' ||l_proc,5);
4616: --
4617: END retirement_annuity;
4618: --
4619: --
4620: Procedure severance_pay is
4621: l_proc varchar2(70) := 'non_sf52_extra_info - severance_pay';
4622: Begin
4623: --
4624: hr_utility.set_location('Entering ' ||l_proc,5);
4625: --
4626: p_severance_pay.amount := l_pa_request_ei_rec.rei_information3;
4627: p_severance_pay.total_entitlement_weeks := l_pa_request_ei_rec.rei_information4;
4628: p_severance_pay.number_weeks_paid := l_pa_request_ei_rec.rei_information5;
4671: p_screen_entry_value => p_severance_pay.weekly_amount
4672: );
4673: end if;
4674: End if;
4675: hr_utility.set_location('Leaving ' ||l_proc,5);
4676: --
4677: END severance_pay;
4678: --
4679: --
4681: Procedure thrift_saving_plan is
4682: l_proc varchar2(70) := 'non_sf52_extra_info - thrift_saving_plan';
4683: Begin
4684: --
4685: hr_utility.set_location('Entering ' ||l_proc,5);
4686: --
4687: p_thrift_saving_plan.amount := l_pa_request_ei_rec.rei_information3;
4688: p_thrift_saving_plan.rate := l_pa_request_ei_rec.rei_information4;
4689: p_thrift_saving_plan.g_fund := l_pa_request_ei_rec.rei_information5;
4791: p_screen_entry_value => p_thrift_saving_plan.emp_contrib_elig_date
4792: );
4793: end if;
4794: end if;
4795: hr_utility.set_location('Leaving ' ||l_proc,5);
4796: --
4797: END thrift_saving_plan;*/
4798: --
4799: --
4800: Procedure retention_allow_review is
4801: l_proc varchar2(70) := 'non_sf52_extra_info - retention_allow_review';
4802: Begin
4803: --
4804: hr_utility.set_location('Entering ' ||l_proc,5);
4805: If p_pa_request_rec.employee_assignment_id is not null then
4806: ghr_api.retrieve_element_entry_value
4807: (p_element_name => 'Retention Allowance',
4808: p_input_value_name => 'Date',
4820: --
4821: Procedure chg_in_tenure is
4822: l_proc varchar2(70) := 'non_sf52_extra - chg_in_tenure';
4823: Begin
4824: hr_utility.set_location('Entering ' ||l_proc,5);
4825: IF l_session.noa_id_correct is not null THEN
4826: set_extra_info(p_per_group1.appointment_type,l_pa_request_ei_rec.rei_information3,p_per_group1.per_group1_flag);
4827: ELSE
4828: p_per_group1.appointment_type := l_pa_request_ei_rec.rei_information3;
4827: ELSE
4828: p_per_group1.appointment_type := l_pa_request_ei_rec.rei_information3;
4829: p_per_group1.per_group1_flag := 'Y';
4830: END IF;
4831: hr_utility.set_location('Leaving ' ||p_per_group1.appointment_type ||l_proc,10);
4832: End chg_in_tenure;
4833: --
4834: -- 4352589 BEN_EIT Changes Assinging Eligibility Expires to Benefits EIT.
4835: Procedure chg_in_fegli is
4834: -- 4352589 BEN_EIT Changes Assinging Eligibility Expires to Benefits EIT.
4835: Procedure chg_in_fegli is
4836: l_proc varchar2(70) := 'non_sf52_extra - chg_in_fegli';
4837: Begin
4838: hr_utility.set_location('Entering ' ||l_proc,5);
4839: --
4840: p_per_benefit_info.FEGLI_Date_Eligibility_Expires := l_pa_request_ei_rec.rei_information1;
4841: If p_per_benefit_info.FEGLI_Date_Eligibility_Expires is not null then
4842: p_per_benefit_info.per_benefit_info_flag := 'Y';
4840: p_per_benefit_info.FEGLI_Date_Eligibility_Expires := l_pa_request_ei_rec.rei_information1;
4841: If p_per_benefit_info.FEGLI_Date_Eligibility_Expires is not null then
4842: p_per_benefit_info.per_benefit_info_flag := 'Y';
4843: End If;
4844: hr_utility.set_location('Leaving ' ||l_proc,10);
4845: End chg_in_fegli;
4846: --
4847: --Pradeep
4848: Procedure mddds_pay is
4849: l_proc varchar2(72) := 'mddds_pay';
4850:
4851: Begin
4852:
4853: hr_utility.set_location('Entering ' ||l_proc,6);
4854:
4855: set_extra_info(p_mddds_special_pay.Full_Time_Status,
4856: l_pa_request_ei_rec.rei_information9,
4857: p_mddds_special_pay.mddds_special_pay_flag,
4904: l_proc varchar2(72) := 'premium_pay_ind';
4905:
4906: Begin
4907:
4908: hr_utility.set_location('Entering ' ||l_proc,7);
4909:
4910:
4911: set_extra_info(p_premium_pay_ind.premium_pay_ind,
4912: l_pa_request_ei_rec.rei_information3,
4920: l_proc varchar2(72) := 'race_ethnic_info';
4921:
4922: Begin
4923:
4924: hr_utility.set_location('Entering ' ||l_proc,7);
4925:
4926: set_extra_info(p_race_ethnic_info.p_hispanic,l_pa_request_ei_rec.rei_information3,
4927: p_race_ethnic_info.p_race_ethnic_info_flag, 'Y' );
4928: set_extra_info(p_race_ethnic_info.p_american_indian,l_pa_request_ei_rec.rei_information4,
4940: Procedure student_loan_repay is
4941: l_proc varchar2(80):= 'non_sf52_extra - student_loan_repay';
4942:
4943: begin
4944: hr_utility.set_location('Entering ' ||l_proc,5);
4945: --
4946: set_extra_info(p_student_loan_repay.p_amount,
4947: p_pa_request_rec.award_amount,
4948: p_student_loan_repay.p_student_loan_flag,
4965: -- p_student_loan_repay.p_amount :=p_pa_request_rec.award_amount;
4966: -- p_student_loan_repay.p_repay_schedule := l_pa_request_ei_rec.rei_information8;
4967: -- p_student_loan_repay.p_review_date := l_pa_request_ei_rec.rei_information9;
4968:
4969: hr_utility.set_location('Leaving ' ||l_proc,10);
4970: end;
4971:
4972: -- Bug 4280026
4973: Procedure key_emergency_essntl is
4972: -- Bug 4280026
4973: Procedure key_emergency_essntl is
4974: l_proc varchar2(70) := 'non_sf52_extra - key_emergency_essntl';
4975: Begin
4976: hr_utility.set_location('Entering ' ||l_proc,5);
4977: set_extra_info(p_asg_non_sf52.key_emer_essential_empl,
4978: l_pa_request_ei_rec.rei_information3,p_asg_non_sf52.asg_non_sf52_flag, 'Y');
4979: hr_utility.set_location('Leaving ' ||l_proc,10);
4980: End key_emergency_essntl;
4975: Begin
4976: hr_utility.set_location('Entering ' ||l_proc,5);
4977: set_extra_info(p_asg_non_sf52.key_emer_essential_empl,
4978: l_pa_request_ei_rec.rei_information3,p_asg_non_sf52.asg_non_sf52_flag, 'Y');
4979: hr_utility.set_location('Leaving ' ||l_proc,10);
4980: End key_emergency_essntl;
4981:
4982: -- Bug 5482191
4983: Procedure ghr_conv_dates is
4982: -- Bug 5482191
4983: Procedure ghr_conv_dates is
4984: l_proc varchar2(70) := 'non_sf52_extra - ghr_conv_dates';
4985: Begin
4986: hr_utility.set_location('Entering ' ||l_proc,5);
4987: set_extra_info(p_per_conversions.date_conv_career_begins,
4988: l_pa_request_ei_rec.rei_information3,p_per_conversions.per_conversions_flag,'Y');
4989: set_extra_info(p_per_conversions.date_conv_career_due,
4990: l_pa_request_ei_rec.rei_information4,p_per_conversions.per_conversions_flag,'Y');
4993: set_extra_info(p_per_conversions.date_recmd_conv_due,
4994: l_pa_request_ei_rec.rei_information7,p_per_conversions.per_conversions_flag,'Y');
4995: set_extra_info(p_per_conversions.date_vra_conv_due,
4996: l_pa_request_ei_rec.rei_information6,p_per_conversions.per_conversions_flag,'Y');
4997: hr_utility.set_location('Leaving ' ||l_proc,10);
4998: End ghr_conv_dates;
4999:
5000:
5001: -- Start of Bug 6312144 -- New IPA Benefits Continuation EIT
5001: -- Start of Bug 6312144 -- New IPA Benefits Continuation EIT
5002: Procedure ipa_benefits_cont is
5003: l_proc varchar2(70) := 'non_sf52_extra - ipa_benefits_cont';
5004: Begin
5005: hr_utility.set_location('Entering ' ||l_proc,5);
5006: set_extra_info(p_ipa_benefits_cont.FEGLI_Indicator,
5007: l_pa_request_ei_rec.rei_information1,p_ipa_benefits_cont.per_ben_cont_info_flag,'Y');
5008: set_extra_info(p_ipa_benefits_cont.FEGLI_Election_Date,
5009: l_pa_request_ei_rec.rei_information2,p_ipa_benefits_cont.per_ben_cont_info_flag,'Y');
5026: set_extra_info(p_ipa_benefits_cont.Cont_Term_Insuff_Pay_Notf_Date,
5027: l_pa_request_ei_rec.rei_information10,p_ipa_benefits_cont.per_ben_cont_info_flag,'Y');
5028: set_extra_info(p_ipa_benefits_cont.Cont_Term_Insuff_Pmt_Type_Code,
5029: l_pa_request_ei_rec.rei_information11,p_ipa_benefits_cont.per_ben_cont_info_flag,'Y');
5030: hr_utility.set_location('Leaving ' ||l_proc,10);
5031: End ipa_benefits_cont;
5032:
5033:
5034: -- Bug 6312144 -- New Federal Benefits Info EIT
5034: -- Bug 6312144 -- New Federal Benefits Info EIT
5035: Procedure ben_info_cont is
5036: l_proc varchar2(70) := 'non_sf52_extra - Federal Benefit Info';
5037: Begin
5038: hr_utility.set_location('Entering ' ||l_proc,5);
5039: set_extra_info(p_per_benefit_info.FEGLI_Assignment_Ind,
5040: l_pa_request_ei_rec.rei_information1,p_per_benefit_info.per_benefit_info_flag,'Y');
5041: set_extra_info(p_per_benefit_info.FEGLI_Post_Elec_Basic_Ins_Amt,
5042: l_pa_request_ei_rec.rei_information2,p_per_benefit_info.per_benefit_info_flag,'Y');
5045: set_extra_info(p_per_benefit_info.Desg_FEGLI_Benf_Ind,
5046: l_pa_request_ei_rec.rei_information4,p_per_benefit_info.per_benefit_info_flag,'Y');
5047: set_extra_info(p_per_benefit_info.FEHB_Event_Code,
5048: l_pa_request_ei_rec.rei_information5,p_per_benefit_info.per_benefit_info_flag,'Y');
5049: hr_utility.set_location('Leaving ' ||l_proc,10);
5050: End ben_info_cont;
5051:
5052: -- Bug 6312144 -- Retirement system information
5053: Procedure retirement_info is
5052: -- Bug 6312144 -- Retirement system information
5053: Procedure retirement_info is
5054: l_proc varchar2(70) := 'non_sf52_extra - Retirement System Info';
5055: Begin
5056: hr_utility.set_location('Entering ' ||l_proc,5);
5057: set_extra_info(p_retirement_info.special_population_code,
5058: l_pa_request_ei_rec.rei_information1,p_retirement_info.per_retirement_info_flag,'Y');
5059: set_extra_info(p_retirement_info.App_Exc_CSRS_Ind,
5060: l_pa_request_ei_rec.rei_information2,p_retirement_info.per_retirement_info_flag,'Y');
5063: set_extra_info(p_retirement_info.FICA_Coverage_Ind1,
5064: l_pa_request_ei_rec.rei_information4,p_retirement_info.per_retirement_info_flag,'Y');
5065: set_extra_info(p_retirement_info.FICA_Coverage_Ind2,
5066: l_pa_request_ei_rec.rei_information5,p_retirement_info.per_retirement_info_flag,'Y');
5067: hr_utility.set_location('Leaving ' ||l_proc,10);
5068: End retirement_info;
5069: -- Start of Bug 8653508 -- Detail Information updating to Assignment EIT
5070: Procedure detail_info is
5071: l_proc varchar2(70) := 'non_sf52_extra - detail_info';
5069: -- Start of Bug 8653508 -- Detail Information updating to Assignment EIT
5070: Procedure detail_info is
5071: l_proc varchar2(70) := 'non_sf52_extra - detail_info';
5072: Begin
5073: hr_utility.set_location('Entering ' ||l_proc,5);
5074: --Begin Bug 10182526
5075: /*set_extra_info(p_asg_detail_info.detail_begin_date,
5076: l_pa_request_ei_rec.rei_information1,p_asg_detail_info.asg_detail_info_flag,'Y');
5077: set_extra_info(p_asg_detail_info.detail_end_date,
5097: set_extra_info(p_asg_detail_info.duty_location,
5098: l_pa_request_ei_rec.rei_information12,p_asg_detail_info.asg_detail_info_flag,'Y');
5099: set_extra_info(p_asg_detail_info.organization,
5100: l_pa_request_ei_rec.rei_information13,p_asg_detail_info.asg_detail_info_flag,'Y');
5101: hr_utility.set_location('Leaving ' ||l_proc,10);
5102: End detail_info;
5103: -- End of Bug 8653508
5104: /* --Begin Bug# 4588575
5105: Procedure ghr_prob_info is
5104: /* --Begin Bug# 4588575
5105: Procedure ghr_prob_info is
5106: l_proc varchar2(70) := 'non_sf52_extra - ghr_prob_info';
5107: Begin
5108: hr_utility.set_location('Entering ' ||l_proc,55);
5109: set_extra_info(p_per_probations.date_prob_trial_period_begin ,
5110: l_pa_request_ei_rec.rei_information10,p_per_probations.per_probation_flag);
5111: set_extra_info(p_per_probations.date_prob_trial_period_ends ,
5112: l_pa_request_ei_rec.rei_information11,p_per_probations.per_probation_flag);
5117: set_extra_info(p_per_probations.spvr_mgr_prob_completion ,
5118: l_pa_request_ei_rec.rei_information14,p_per_probations.per_probation_flag);
5119: set_extra_info(p_per_probations.date_ses_prob_expires ,
5120: l_pa_request_ei_rec.rei_information15,p_per_probations.per_probation_flag);
5121: hr_utility.set_location('Leaving ' ||l_proc,56);
5122: End ghr_prob_info;
5123: --end Bug# 4588575
5124: */ --Backout the changes done for Bug# 4588575
5125: --Begin Bug# 12557463
5125: --Begin Bug# 12557463
5126: PROCEDURE ghr_scd_info is
5127: l_proc varchar2(70) := 'non_sf52_extra - ghr_scd_info';
5128: Begin
5129: hr_utility.set_location('Entering ' ||l_proc,6);
5130: hr_utility.set_location('Entering RPA ' || l_pa_request_ei_rec.rei_information2,61);
5131: hr_utility.set_location('Entering PER ' || p_per_scd_info.scd_retirement,62);
5132: set_extra_info(p_per_scd_info.scd_civilian,l_pa_request_ei_rec.rei_information1,
5133: p_per_scd_info.per_scd_info_flag, 'Y');
5126: PROCEDURE ghr_scd_info is
5127: l_proc varchar2(70) := 'non_sf52_extra - ghr_scd_info';
5128: Begin
5129: hr_utility.set_location('Entering ' ||l_proc,6);
5130: hr_utility.set_location('Entering RPA ' || l_pa_request_ei_rec.rei_information2,61);
5131: hr_utility.set_location('Entering PER ' || p_per_scd_info.scd_retirement,62);
5132: set_extra_info(p_per_scd_info.scd_civilian,l_pa_request_ei_rec.rei_information1,
5133: p_per_scd_info.per_scd_info_flag, 'Y');
5134: set_extra_info(p_per_scd_info.scd_retirement,l_pa_request_ei_rec.rei_information2,
5127: l_proc varchar2(70) := 'non_sf52_extra - ghr_scd_info';
5128: Begin
5129: hr_utility.set_location('Entering ' ||l_proc,6);
5130: hr_utility.set_location('Entering RPA ' || l_pa_request_ei_rec.rei_information2,61);
5131: hr_utility.set_location('Entering PER ' || p_per_scd_info.scd_retirement,62);
5132: set_extra_info(p_per_scd_info.scd_civilian,l_pa_request_ei_rec.rei_information1,
5133: p_per_scd_info.per_scd_info_flag, 'Y');
5134: set_extra_info(p_per_scd_info.scd_retirement,l_pa_request_ei_rec.rei_information2,
5135: p_per_scd_info.per_scd_info_flag, 'Y');
5151: --Begin Bug# 14514445
5152: set_extra_info(p_per_scd_info.scd_Length_of_Service ,
5153: l_pa_request_ei_rec.rei_information10,p_per_scd_info.per_scd_info_flag, 'Y');
5154: --End Bug# 14514445
5155: hr_utility.set_location('Entering PER ' || p_per_scd_info.scd_retirement,62);
5156: hr_utility.set_location('Leaving ' ||l_proc,60);
5157: End ghr_scd_info;
5158: --End Bug# 12557463
5159:
5152: set_extra_info(p_per_scd_info.scd_Length_of_Service ,
5153: l_pa_request_ei_rec.rei_information10,p_per_scd_info.per_scd_info_flag, 'Y');
5154: --End Bug# 14514445
5155: hr_utility.set_location('Entering PER ' || p_per_scd_info.scd_retirement,62);
5156: hr_utility.set_location('Leaving ' ||l_proc,60);
5157: End ghr_scd_info;
5158: --End Bug# 12557463
5159:
5160: Begin
5220: -- Bug 3260890
5221:
5222: For info_type in c_info_types loop
5223: l_information_type := info_type.information_type;
5224: hr_utility.set_location('l_information_type :' || l_information_type,1);
5225: l_pa_request_ei_rec := null;
5226: --Bug # 5584845
5227: IF NVL(l_information_type,'@') = 'GHR_US_PAR_TERM_RET_GRADE' THEN
5228: FOR pa_request_extra_info IN c_pa_term_rg_extra_info LOOP
5233: l_pa_request_ei_rec := pa_request_extra_info;
5234: END LOOP;
5235: END IF;
5236: --Bug # 5584845
5237: hr_utility.set_location('rei 3 ' || l_pa_request_ei_rec.rei_information3,1);
5238: hr_utility.set_location('rei 4 ' || l_pa_request_ei_rec.rei_information4,1);
5239: hr_utility.set_location('rei 5 ' || l_pa_request_ei_rec.rei_information5,1);
5240: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
5241: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
5234: END LOOP;
5235: END IF;
5236: --Bug # 5584845
5237: hr_utility.set_location('rei 3 ' || l_pa_request_ei_rec.rei_information3,1);
5238: hr_utility.set_location('rei 4 ' || l_pa_request_ei_rec.rei_information4,1);
5239: hr_utility.set_location('rei 5 ' || l_pa_request_ei_rec.rei_information5,1);
5240: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
5241: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
5242: hr_utility.set_location('rei 8 ' || l_pa_request_ei_rec.rei_information8,1);
5235: END IF;
5236: --Bug # 5584845
5237: hr_utility.set_location('rei 3 ' || l_pa_request_ei_rec.rei_information3,1);
5238: hr_utility.set_location('rei 4 ' || l_pa_request_ei_rec.rei_information4,1);
5239: hr_utility.set_location('rei 5 ' || l_pa_request_ei_rec.rei_information5,1);
5240: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
5241: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
5242: hr_utility.set_location('rei 8 ' || l_pa_request_ei_rec.rei_information8,1);
5243: hr_utility.set_location('rei 9 ' || l_pa_request_ei_rec.rei_information9,1);
5236: --Bug # 5584845
5237: hr_utility.set_location('rei 3 ' || l_pa_request_ei_rec.rei_information3,1);
5238: hr_utility.set_location('rei 4 ' || l_pa_request_ei_rec.rei_information4,1);
5239: hr_utility.set_location('rei 5 ' || l_pa_request_ei_rec.rei_information5,1);
5240: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
5241: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
5242: hr_utility.set_location('rei 8 ' || l_pa_request_ei_rec.rei_information8,1);
5243: hr_utility.set_location('rei 9 ' || l_pa_request_ei_rec.rei_information9,1);
5244: hr_utility.set_location('rei 11 ' || l_pa_request_ei_rec.rei_information11,1);
5237: hr_utility.set_location('rei 3 ' || l_pa_request_ei_rec.rei_information3,1);
5238: hr_utility.set_location('rei 4 ' || l_pa_request_ei_rec.rei_information4,1);
5239: hr_utility.set_location('rei 5 ' || l_pa_request_ei_rec.rei_information5,1);
5240: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
5241: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
5242: hr_utility.set_location('rei 8 ' || l_pa_request_ei_rec.rei_information8,1);
5243: hr_utility.set_location('rei 9 ' || l_pa_request_ei_rec.rei_information9,1);
5244: hr_utility.set_location('rei 11 ' || l_pa_request_ei_rec.rei_information11,1);
5245:
5238: hr_utility.set_location('rei 4 ' || l_pa_request_ei_rec.rei_information4,1);
5239: hr_utility.set_location('rei 5 ' || l_pa_request_ei_rec.rei_information5,1);
5240: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
5241: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
5242: hr_utility.set_location('rei 8 ' || l_pa_request_ei_rec.rei_information8,1);
5243: hr_utility.set_location('rei 9 ' || l_pa_request_ei_rec.rei_information9,1);
5244: hr_utility.set_location('rei 11 ' || l_pa_request_ei_rec.rei_information11,1);
5245:
5246: --
5239: hr_utility.set_location('rei 5 ' || l_pa_request_ei_rec.rei_information5,1);
5240: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
5241: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
5242: hr_utility.set_location('rei 8 ' || l_pa_request_ei_rec.rei_information8,1);
5243: hr_utility.set_location('rei 9 ' || l_pa_request_ei_rec.rei_information9,1);
5244: hr_utility.set_location('rei 11 ' || l_pa_request_ei_rec.rei_information11,1);
5245:
5246: --
5247: if l_information_type = 'GHR_US_PAR_APPT_INFO' then
5240: hr_utility.set_location('rei 6 ' || l_pa_request_ei_rec.rei_information6,1);
5241: hr_utility.set_location('rei 7 ' || l_pa_request_ei_rec.rei_information7,1);
5242: hr_utility.set_location('rei 8 ' || l_pa_request_ei_rec.rei_information8,1);
5243: hr_utility.set_location('rei 9 ' || l_pa_request_ei_rec.rei_information9,1);
5244: hr_utility.set_location('rei 11 ' || l_pa_request_ei_rec.rei_information11,1);
5245:
5246: --
5247: if l_information_type = 'GHR_US_PAR_APPT_INFO' then
5248: hr_utility.set_location(l_proc,5);
5244: hr_utility.set_location('rei 11 ' || l_pa_request_ei_rec.rei_information11,1);
5245:
5246: --
5247: if l_information_type = 'GHR_US_PAR_APPT_INFO' then
5248: hr_utility.set_location(l_proc,5);
5249: hr_utility.set_location('info type ' || l_information_type,1);
5250: appt_info;
5251: elsif l_information_type = 'GHR_US_PAR_APPT_TRANSFER' then
5252: hr_utility.set_location(l_proc,10);
5245:
5246: --
5247: if l_information_type = 'GHR_US_PAR_APPT_INFO' then
5248: hr_utility.set_location(l_proc,5);
5249: hr_utility.set_location('info type ' || l_information_type,1);
5250: appt_info;
5251: elsif l_information_type = 'GHR_US_PAR_APPT_TRANSFER' then
5252: hr_utility.set_location(l_proc,10);
5253: hr_utility.set_location('info type ' || l_information_type,2);
5248: hr_utility.set_location(l_proc,5);
5249: hr_utility.set_location('info type ' || l_information_type,1);
5250: appt_info;
5251: elsif l_information_type = 'GHR_US_PAR_APPT_TRANSFER' then
5252: hr_utility.set_location(l_proc,10);
5253: hr_utility.set_location('info type ' || l_information_type,2);
5254: appt_transfer;
5255: --Begin Bug# 8724192
5256: elsif l_information_type = 'GHR_US_TRANS_CURN_APP_AUTH' then
5249: hr_utility.set_location('info type ' || l_information_type,1);
5250: appt_info;
5251: elsif l_information_type = 'GHR_US_PAR_APPT_TRANSFER' then
5252: hr_utility.set_location(l_proc,10);
5253: hr_utility.set_location('info type ' || l_information_type,2);
5254: appt_transfer;
5255: --Begin Bug# 8724192
5256: elsif l_information_type = 'GHR_US_TRANS_CURN_APP_AUTH' then
5257: hr_utility.set_location(l_proc,10);
5253: hr_utility.set_location('info type ' || l_information_type,2);
5254: appt_transfer;
5255: --Begin Bug# 8724192
5256: elsif l_information_type = 'GHR_US_TRANS_CURN_APP_AUTH' then
5257: hr_utility.set_location(l_proc,10);
5258: hr_utility.set_location('info type ' || l_information_type,2);
5259: appt_transfer_app;
5260: elsif l_information_type = 'GHR_US_MASS_TRNSFR_NTE_DATES' then
5261: hr_utility.set_location(l_proc,10);
5254: appt_transfer;
5255: --Begin Bug# 8724192
5256: elsif l_information_type = 'GHR_US_TRANS_CURN_APP_AUTH' then
5257: hr_utility.set_location(l_proc,10);
5258: hr_utility.set_location('info type ' || l_information_type,2);
5259: appt_transfer_app;
5260: elsif l_information_type = 'GHR_US_MASS_TRNSFR_NTE_DATES' then
5261: hr_utility.set_location(l_proc,10);
5262: hr_utility.set_location('info type ' || l_information_type,2);
5257: hr_utility.set_location(l_proc,10);
5258: hr_utility.set_location('info type ' || l_information_type,2);
5259: appt_transfer_app;
5260: elsif l_information_type = 'GHR_US_MASS_TRNSFR_NTE_DATES' then
5261: hr_utility.set_location(l_proc,10);
5262: hr_utility.set_location('info type ' || l_information_type,2);
5263: mass_transfer_nte;
5264: --End Bug# 8724192
5265: elsif l_information_type = 'GHR_US_PAR_CONV_APP' then
5258: hr_utility.set_location('info type ' || l_information_type,2);
5259: appt_transfer_app;
5260: elsif l_information_type = 'GHR_US_MASS_TRNSFR_NTE_DATES' then
5261: hr_utility.set_location(l_proc,10);
5262: hr_utility.set_location('info type ' || l_information_type,2);
5263: mass_transfer_nte;
5264: --End Bug# 8724192
5265: elsif l_information_type = 'GHR_US_PAR_CONV_APP' then
5266: hr_utility.set_location(l_proc,15);
5262: hr_utility.set_location('info type ' || l_information_type,2);
5263: mass_transfer_nte;
5264: --End Bug# 8724192
5265: elsif l_information_type = 'GHR_US_PAR_CONV_APP' then
5266: hr_utility.set_location(l_proc,15);
5267: hr_utility.set_location('info type ' || l_information_type,3);
5268: conv_appt;
5269: elsif l_information_type = 'GHR_US_PAR_RETURN_TO_DUTY' then
5270: hr_utility.set_location(l_proc,20);
5263: mass_transfer_nte;
5264: --End Bug# 8724192
5265: elsif l_information_type = 'GHR_US_PAR_CONV_APP' then
5266: hr_utility.set_location(l_proc,15);
5267: hr_utility.set_location('info type ' || l_information_type,3);
5268: conv_appt;
5269: elsif l_information_type = 'GHR_US_PAR_RETURN_TO_DUTY' then
5270: hr_utility.set_location(l_proc,20);
5271: hr_utility.set_location('info type ' || l_information_type,4);
5266: hr_utility.set_location(l_proc,15);
5267: hr_utility.set_location('info type ' || l_information_type,3);
5268: conv_appt;
5269: elsif l_information_type = 'GHR_US_PAR_RETURN_TO_DUTY' then
5270: hr_utility.set_location(l_proc,20);
5271: hr_utility.set_location('info type ' || l_information_type,4);
5272: return_to_duty;
5273: elsif l_information_type = 'GHR_US_PAR_REASSIGNMENT' then
5274: hr_utility.set_location(l_proc,25);
5267: hr_utility.set_location('info type ' || l_information_type,3);
5268: conv_appt;
5269: elsif l_information_type = 'GHR_US_PAR_RETURN_TO_DUTY' then
5270: hr_utility.set_location(l_proc,20);
5271: hr_utility.set_location('info type ' || l_information_type,4);
5272: return_to_duty;
5273: elsif l_information_type = 'GHR_US_PAR_REASSIGNMENT' then
5274: hr_utility.set_location(l_proc,25);
5275: hr_utility.set_location('info type ' || l_information_type,5);
5270: hr_utility.set_location(l_proc,20);
5271: hr_utility.set_location('info type ' || l_information_type,4);
5272: return_to_duty;
5273: elsif l_information_type = 'GHR_US_PAR_REASSIGNMENT' then
5274: hr_utility.set_location(l_proc,25);
5275: hr_utility.set_location('info type ' || l_information_type,5);
5276: reassign;
5277: elsif l_information_type = 'GHR_US_PAR_POSN_CHG' then
5278: hr_utility.set_location(l_proc,30);
5271: hr_utility.set_location('info type ' || l_information_type,4);
5272: return_to_duty;
5273: elsif l_information_type = 'GHR_US_PAR_REASSIGNMENT' then
5274: hr_utility.set_location(l_proc,25);
5275: hr_utility.set_location('info type ' || l_information_type,5);
5276: reassign;
5277: elsif l_information_type = 'GHR_US_PAR_POSN_CHG' then
5278: hr_utility.set_location(l_proc,30);
5279: hr_utility.set_location('info type ' || l_information_type,6);
5274: hr_utility.set_location(l_proc,25);
5275: hr_utility.set_location('info type ' || l_information_type,5);
5276: reassign;
5277: elsif l_information_type = 'GHR_US_PAR_POSN_CHG' then
5278: hr_utility.set_location(l_proc,30);
5279: hr_utility.set_location('info type ' || l_information_type,6);
5280: posn_chg;
5281: elsif l_information_type = 'GHR_US_PAR_CHG_HOURS' then
5282: hr_utility.set_location(l_proc,35);
5275: hr_utility.set_location('info type ' || l_information_type,5);
5276: reassign;
5277: elsif l_information_type = 'GHR_US_PAR_POSN_CHG' then
5278: hr_utility.set_location(l_proc,30);
5279: hr_utility.set_location('info type ' || l_information_type,6);
5280: posn_chg;
5281: elsif l_information_type = 'GHR_US_PAR_CHG_HOURS' then
5282: hr_utility.set_location(l_proc,35);
5283: hr_utility.set_location('info type ' || l_information_type,7);
5278: hr_utility.set_location(l_proc,30);
5279: hr_utility.set_location('info type ' || l_information_type,6);
5280: posn_chg;
5281: elsif l_information_type = 'GHR_US_PAR_CHG_HOURS' then
5282: hr_utility.set_location(l_proc,35);
5283: hr_utility.set_location('info type ' || l_information_type,7);
5284: chg_sched_hours;
5285: elsif l_information_type = 'GHR_US_PAR_REALIGNMENT' then
5286: hr_utility.set_location(l_proc,40);
5279: hr_utility.set_location('info type ' || l_information_type,6);
5280: posn_chg;
5281: elsif l_information_type = 'GHR_US_PAR_CHG_HOURS' then
5282: hr_utility.set_location(l_proc,35);
5283: hr_utility.set_location('info type ' || l_information_type,7);
5284: chg_sched_hours;
5285: elsif l_information_type = 'GHR_US_PAR_REALIGNMENT' then
5286: hr_utility.set_location(l_proc,40);
5287: hr_utility.set_location('info type ' || l_information_type,8);
5282: hr_utility.set_location(l_proc,35);
5283: hr_utility.set_location('info type ' || l_information_type,7);
5284: chg_sched_hours;
5285: elsif l_information_type = 'GHR_US_PAR_REALIGNMENT' then
5286: hr_utility.set_location(l_proc,40);
5287: hr_utility.set_location('info type ' || l_information_type,8);
5288: realign;
5289: elsif l_information_type = 'GHR_US_PAR_CHG_DATA_ELEMENT' then
5290: hr_utility.set_location(l_proc,45);
5283: hr_utility.set_location('info type ' || l_information_type,7);
5284: chg_sched_hours;
5285: elsif l_information_type = 'GHR_US_PAR_REALIGNMENT' then
5286: hr_utility.set_location(l_proc,40);
5287: hr_utility.set_location('info type ' || l_information_type,8);
5288: realign;
5289: elsif l_information_type = 'GHR_US_PAR_CHG_DATA_ELEMENT' then
5290: hr_utility.set_location(l_proc,45);
5291: hr_utility.set_location('info type ' || l_information_type,9);
5286: hr_utility.set_location(l_proc,40);
5287: hr_utility.set_location('info type ' || l_information_type,8);
5288: realign;
5289: elsif l_information_type = 'GHR_US_PAR_CHG_DATA_ELEMENT' then
5290: hr_utility.set_location(l_proc,45);
5291: hr_utility.set_location('info type ' || l_information_type,9);
5292: chg_data_elm;
5293: elsif l_information_type = 'GHR_US_PAR_CHG_RETIRE_PLAN' then
5294: hr_utility.set_location(l_proc,50);
5287: hr_utility.set_location('info type ' || l_information_type,8);
5288: realign;
5289: elsif l_information_type = 'GHR_US_PAR_CHG_DATA_ELEMENT' then
5290: hr_utility.set_location(l_proc,45);
5291: hr_utility.set_location('info type ' || l_information_type,9);
5292: chg_data_elm;
5293: elsif l_information_type = 'GHR_US_PAR_CHG_RETIRE_PLAN' then
5294: hr_utility.set_location(l_proc,50);
5295: hr_utility.set_location('info type ' || l_information_type,10);
5290: hr_utility.set_location(l_proc,45);
5291: hr_utility.set_location('info type ' || l_information_type,9);
5292: chg_data_elm;
5293: elsif l_information_type = 'GHR_US_PAR_CHG_RETIRE_PLAN' then
5294: hr_utility.set_location(l_proc,50);
5295: hr_utility.set_location('info type ' || l_information_type,10);
5296: chg_ret_plan;
5297: --Begin Bug# 12557463 commented following code
5298: /*elsif l_information_type = 'GHR_US_PAR_CHG_SCD' then
5291: hr_utility.set_location('info type ' || l_information_type,9);
5292: chg_data_elm;
5293: elsif l_information_type = 'GHR_US_PAR_CHG_RETIRE_PLAN' then
5294: hr_utility.set_location(l_proc,50);
5295: hr_utility.set_location('info type ' || l_information_type,10);
5296: chg_ret_plan;
5297: --Begin Bug# 12557463 commented following code
5298: /*elsif l_information_type = 'GHR_US_PAR_CHG_SCD' then
5299: hr_utility.set_location(l_proc,55);
5295: hr_utility.set_location('info type ' || l_information_type,10);
5296: chg_ret_plan;
5297: --Begin Bug# 12557463 commented following code
5298: /*elsif l_information_type = 'GHR_US_PAR_CHG_SCD' then
5299: hr_utility.set_location(l_proc,55);
5300: hr_utility.set_location('info type ' || l_information_type,11);
5301: chg_scd;
5302: */
5303: ---End Bug# 12557463
5296: chg_ret_plan;
5297: --Begin Bug# 12557463 commented following code
5298: /*elsif l_information_type = 'GHR_US_PAR_CHG_SCD' then
5299: hr_utility.set_location(l_proc,55);
5300: hr_utility.set_location('info type ' || l_information_type,11);
5301: chg_scd;
5302: */
5303: ---End Bug# 12557463
5304: --Begin bug# 14751665,15882322,15882330
5302: */
5303: ---End Bug# 12557463
5304: --Begin bug# 14751665,15882322,15882330
5305: elsif l_information_type = 'GHR_US_PAR_PRV_RET_INFO' then
5306: hr_utility.set_location(l_proc ,55);
5307: hr_utility.set_location('info type ' || l_information_type,114);
5308: prv_ret_info;
5309: --End Bug# 14751665,15882322,15882330
5310: /* Bug # 1165309
5303: ---End Bug# 12557463
5304: --Begin bug# 14751665,15882322,15882330
5305: elsif l_information_type = 'GHR_US_PAR_PRV_RET_INFO' then
5306: hr_utility.set_location(l_proc ,55);
5307: hr_utility.set_location('info type ' || l_information_type,114);
5308: prv_ret_info;
5309: --End Bug# 14751665,15882322,15882330
5310: /* Bug # 1165309
5311: elsif l_information_type = 'GHR_US_PAR_DENIAL_WGI' then
5308: prv_ret_info;
5309: --End Bug# 14751665,15882322,15882330
5310: /* Bug # 1165309
5311: elsif l_information_type = 'GHR_US_PAR_DENIAL_WGI' then
5312: hr_utility.set_location(l_proc,60);
5313: hr_utility.set_location('info type ' || l_information_type,12);
5314: denial_wgi;
5315: */
5316: elsif l_information_type = 'GHR_US_PAR_SALARY_CHG' then
5309: --End Bug# 14751665,15882322,15882330
5310: /* Bug # 1165309
5311: elsif l_information_type = 'GHR_US_PAR_DENIAL_WGI' then
5312: hr_utility.set_location(l_proc,60);
5313: hr_utility.set_location('info type ' || l_information_type,12);
5314: denial_wgi;
5315: */
5316: elsif l_information_type = 'GHR_US_PAR_SALARY_CHG' then
5317: hr_utility.set_location(l_proc,65);
5313: hr_utility.set_location('info type ' || l_information_type,12);
5314: denial_wgi;
5315: */
5316: elsif l_information_type = 'GHR_US_PAR_SALARY_CHG' then
5317: hr_utility.set_location(l_proc,65);
5318: hr_utility.set_location('info type ' || l_information_type,13);
5319: salary_change;
5320: elsif l_information_type = 'GHR_US_PAR_RECRUIT_BONUS' then
5321: hr_utility.set_location(l_proc,70);
5314: denial_wgi;
5315: */
5316: elsif l_information_type = 'GHR_US_PAR_SALARY_CHG' then
5317: hr_utility.set_location(l_proc,65);
5318: hr_utility.set_location('info type ' || l_information_type,13);
5319: salary_change;
5320: elsif l_information_type = 'GHR_US_PAR_RECRUIT_BONUS' then
5321: hr_utility.set_location(l_proc,70);
5322: hr_utility.set_location('info type ' || l_information_type,14);
5317: hr_utility.set_location(l_proc,65);
5318: hr_utility.set_location('info type ' || l_information_type,13);
5319: salary_change;
5320: elsif l_information_type = 'GHR_US_PAR_RECRUIT_BONUS' then
5321: hr_utility.set_location(l_proc,70);
5322: hr_utility.set_location('info type ' || l_information_type,14);
5323: recruitment_bonus;
5324: elsif l_information_type = 'GHR_US_PAR_RELOC_BONUS' then
5325: hr_utility.set_location(l_proc,75);
5318: hr_utility.set_location('info type ' || l_information_type,13);
5319: salary_change;
5320: elsif l_information_type = 'GHR_US_PAR_RECRUIT_BONUS' then
5321: hr_utility.set_location(l_proc,70);
5322: hr_utility.set_location('info type ' || l_information_type,14);
5323: recruitment_bonus;
5324: elsif l_information_type = 'GHR_US_PAR_RELOC_BONUS' then
5325: hr_utility.set_location(l_proc,75);
5326: hr_utility.set_location('info type ' || l_information_type,15);
5321: hr_utility.set_location(l_proc,70);
5322: hr_utility.set_location('info type ' || l_information_type,14);
5323: recruitment_bonus;
5324: elsif l_information_type = 'GHR_US_PAR_RELOC_BONUS' then
5325: hr_utility.set_location(l_proc,75);
5326: hr_utility.set_location('info type ' || l_information_type,15);
5327: relocation_bonus;
5328: elsif l_information_type = 'GHR_US_PAR_AWARDS_BONUS' then
5329: hr_utility.set_location(l_proc,80);
5322: hr_utility.set_location('info type ' || l_information_type,14);
5323: recruitment_bonus;
5324: elsif l_information_type = 'GHR_US_PAR_RELOC_BONUS' then
5325: hr_utility.set_location(l_proc,75);
5326: hr_utility.set_location('info type ' || l_information_type,15);
5327: relocation_bonus;
5328: elsif l_information_type = 'GHR_US_PAR_AWARDS_BONUS' then
5329: hr_utility.set_location(l_proc,80);
5330: hr_utility.set_location('info type ' || l_information_type,16);
5325: hr_utility.set_location(l_proc,75);
5326: hr_utility.set_location('info type ' || l_information_type,15);
5327: relocation_bonus;
5328: elsif l_information_type = 'GHR_US_PAR_AWARDS_BONUS' then
5329: hr_utility.set_location(l_proc,80);
5330: hr_utility.set_location('info type ' || l_information_type,16);
5331: government_awards;
5332: elsif l_information_type = 'GHR_US_PAR_NON_PAY_DUTY_STATUS' then
5333: hr_utility.set_location(l_proc,85);
5326: hr_utility.set_location('info type ' || l_information_type,15);
5327: relocation_bonus;
5328: elsif l_information_type = 'GHR_US_PAR_AWARDS_BONUS' then
5329: hr_utility.set_location(l_proc,80);
5330: hr_utility.set_location('info type ' || l_information_type,16);
5331: government_awards;
5332: elsif l_information_type = 'GHR_US_PAR_NON_PAY_DUTY_STATUS' then
5333: hr_utility.set_location(l_proc,85);
5334: hr_utility.set_location('info type ' || l_information_type,17);
5329: hr_utility.set_location(l_proc,80);
5330: hr_utility.set_location('info type ' || l_information_type,16);
5331: government_awards;
5332: elsif l_information_type = 'GHR_US_PAR_NON_PAY_DUTY_STATUS' then
5333: hr_utility.set_location(l_proc,85);
5334: hr_utility.set_location('info type ' || l_information_type,17);
5335: non_pay_duty_status;
5336: elsif l_information_type = 'GHR_US_PAR_TERM_RET_GRADE' then
5337: hr_utility.set_location(l_proc,90);
5330: hr_utility.set_location('info type ' || l_information_type,16);
5331: government_awards;
5332: elsif l_information_type = 'GHR_US_PAR_NON_PAY_DUTY_STATUS' then
5333: hr_utility.set_location(l_proc,85);
5334: hr_utility.set_location('info type ' || l_information_type,17);
5335: non_pay_duty_status;
5336: elsif l_information_type = 'GHR_US_PAR_TERM_RET_GRADE' then
5337: hr_utility.set_location(l_proc,90);
5338: hr_utility.set_location('info type ' || l_information_type,18);
5333: hr_utility.set_location(l_proc,85);
5334: hr_utility.set_location('info type ' || l_information_type,17);
5335: non_pay_duty_status;
5336: elsif l_information_type = 'GHR_US_PAR_TERM_RET_GRADE' then
5337: hr_utility.set_location(l_proc,90);
5338: hr_utility.set_location('info type ' || l_information_type,18);
5339: term_retained_grade;
5340: elsif l_information_type = 'GHR_US_PAR_QSI_AWARD' then
5341: hr_utility.set_location(l_proc,95);
5334: hr_utility.set_location('info type ' || l_information_type,17);
5335: non_pay_duty_status;
5336: elsif l_information_type = 'GHR_US_PAR_TERM_RET_GRADE' then
5337: hr_utility.set_location(l_proc,90);
5338: hr_utility.set_location('info type ' || l_information_type,18);
5339: term_retained_grade;
5340: elsif l_information_type = 'GHR_US_PAR_QSI_AWARD' then
5341: hr_utility.set_location(l_proc,95);
5342: hr_utility.set_location('info type ' || l_information_type,19);
5337: hr_utility.set_location(l_proc,90);
5338: hr_utility.set_location('info type ' || l_information_type,18);
5339: term_retained_grade;
5340: elsif l_information_type = 'GHR_US_PAR_QSI_AWARD' then
5341: hr_utility.set_location(l_proc,95);
5342: hr_utility.set_location('info type ' || l_information_type,19);
5343: quality_step_increase;
5344: elsif l_information_type = 'GHR_US_PAR_LWOP_INFO' then
5345: hr_utility.set_location(l_proc,100);
5338: hr_utility.set_location('info type ' || l_information_type,18);
5339: term_retained_grade;
5340: elsif l_information_type = 'GHR_US_PAR_QSI_AWARD' then
5341: hr_utility.set_location(l_proc,95);
5342: hr_utility.set_location('info type ' || l_information_type,19);
5343: quality_step_increase;
5344: elsif l_information_type = 'GHR_US_PAR_LWOP_INFO' then
5345: hr_utility.set_location(l_proc,100);
5346: hr_utility.set_location('info type ' || l_information_type,20);
5341: hr_utility.set_location(l_proc,95);
5342: hr_utility.set_location('info type ' || l_information_type,19);
5343: quality_step_increase;
5344: elsif l_information_type = 'GHR_US_PAR_LWOP_INFO' then
5345: hr_utility.set_location(l_proc,100);
5346: hr_utility.set_location('info type ' || l_information_type,20);
5347: lwop_info;
5348: elsif l_information_type = 'GHR_US_PAR_ENTITLEMENT' then
5349: hr_utility.set_location(l_proc,105);
5342: hr_utility.set_location('info type ' || l_information_type,19);
5343: quality_step_increase;
5344: elsif l_information_type = 'GHR_US_PAR_LWOP_INFO' then
5345: hr_utility.set_location(l_proc,100);
5346: hr_utility.set_location('info type ' || l_information_type,20);
5347: lwop_info;
5348: elsif l_information_type = 'GHR_US_PAR_ENTITLEMENT' then
5349: hr_utility.set_location(l_proc,105);
5350: hr_utility.set_location('info type ' || l_information_type,21);
5345: hr_utility.set_location(l_proc,100);
5346: hr_utility.set_location('info type ' || l_information_type,20);
5347: lwop_info;
5348: elsif l_information_type = 'GHR_US_PAR_ENTITLEMENT' then
5349: hr_utility.set_location(l_proc,105);
5350: hr_utility.set_location('info type ' || l_information_type,21);
5351: entitlement;
5352: elsif l_information_type = 'GHR_US_PAR_FOR_LANG_PROF_PAY' then
5353: hr_utility.set_location(l_proc,110);
5346: hr_utility.set_location('info type ' || l_information_type,20);
5347: lwop_info;
5348: elsif l_information_type = 'GHR_US_PAR_ENTITLEMENT' then
5349: hr_utility.set_location(l_proc,105);
5350: hr_utility.set_location('info type ' || l_information_type,21);
5351: entitlement;
5352: elsif l_information_type = 'GHR_US_PAR_FOR_LANG_PROF_PAY' then
5353: hr_utility.set_location(l_proc,110);
5354: hr_utility.set_location('info type ' || l_information_type,22);
5349: hr_utility.set_location(l_proc,105);
5350: hr_utility.set_location('info type ' || l_information_type,21);
5351: entitlement;
5352: elsif l_information_type = 'GHR_US_PAR_FOR_LANG_PROF_PAY' then
5353: hr_utility.set_location(l_proc,110);
5354: hr_utility.set_location('info type ' || l_information_type,22);
5355: for_lang_pay;
5356: elsif l_information_type = 'GHR_US_PAR_EDP_PAY' then
5357: hr_utility.set_location(l_proc,115);
5350: hr_utility.set_location('info type ' || l_information_type,21);
5351: entitlement;
5352: elsif l_information_type = 'GHR_US_PAR_FOR_LANG_PROF_PAY' then
5353: hr_utility.set_location(l_proc,110);
5354: hr_utility.set_location('info type ' || l_information_type,22);
5355: for_lang_pay;
5356: elsif l_information_type = 'GHR_US_PAR_EDP_PAY' then
5357: hr_utility.set_location(l_proc,115);
5358: hr_utility.set_location('info type ' || l_information_type,23);
5353: hr_utility.set_location(l_proc,110);
5354: hr_utility.set_location('info type ' || l_information_type,22);
5355: for_lang_pay;
5356: elsif l_information_type = 'GHR_US_PAR_EDP_PAY' then
5357: hr_utility.set_location(l_proc,115);
5358: hr_utility.set_location('info type ' || l_information_type,23);
5359: edp_pay;
5360: elsif l_information_type = 'GHR_US_PAR_HAZARD_PAY' then
5361: hr_utility.set_location(l_proc,116);
5354: hr_utility.set_location('info type ' || l_information_type,22);
5355: for_lang_pay;
5356: elsif l_information_type = 'GHR_US_PAR_EDP_PAY' then
5357: hr_utility.set_location(l_proc,115);
5358: hr_utility.set_location('info type ' || l_information_type,23);
5359: edp_pay;
5360: elsif l_information_type = 'GHR_US_PAR_HAZARD_PAY' then
5361: hr_utility.set_location(l_proc,116);
5362: hr_utility.set_location('info type ' || l_information_type,24);
5357: hr_utility.set_location(l_proc,115);
5358: hr_utility.set_location('info type ' || l_information_type,23);
5359: edp_pay;
5360: elsif l_information_type = 'GHR_US_PAR_HAZARD_PAY' then
5361: hr_utility.set_location(l_proc,116);
5362: hr_utility.set_location('info type ' || l_information_type,24);
5363: hazard_pay;
5364: /* Commented Out as as all future benefits enrollments are either
5365: through the Benefits PUI or FEHB module
5358: hr_utility.set_location('info type ' || l_information_type,23);
5359: edp_pay;
5360: elsif l_information_type = 'GHR_US_PAR_HAZARD_PAY' then
5361: hr_utility.set_location(l_proc,116);
5362: hr_utility.set_location('info type ' || l_information_type,24);
5363: hazard_pay;
5364: /* Commented Out as as all future benefits enrollments are either
5365: through the Benefits PUI or FEHB module
5366: elsif l_information_type = 'GHR_US_PAR_HEALTH_BENEFITS' then
5363: hazard_pay;
5364: /* Commented Out as as all future benefits enrollments are either
5365: through the Benefits PUI or FEHB module
5366: elsif l_information_type = 'GHR_US_PAR_HEALTH_BENEFITS' then
5367: hr_utility.set_location(l_proc,120);
5368: hr_utility.set_location('info type ' || l_information_type,25);
5369: health_benefits;
5370: elsif l_information_type = 'GHR_US_PAR_HEALTH_BEN_PRE_TAX' then
5371: hr_utility.set_location(l_proc,121);
5364: /* Commented Out as as all future benefits enrollments are either
5365: through the Benefits PUI or FEHB module
5366: elsif l_information_type = 'GHR_US_PAR_HEALTH_BENEFITS' then
5367: hr_utility.set_location(l_proc,120);
5368: hr_utility.set_location('info type ' || l_information_type,25);
5369: health_benefits;
5370: elsif l_information_type = 'GHR_US_PAR_HEALTH_BEN_PRE_TAX' then
5371: hr_utility.set_location(l_proc,121);
5372: hr_utility.set_location('info type ' || l_information_type,25);
5367: hr_utility.set_location(l_proc,120);
5368: hr_utility.set_location('info type ' || l_information_type,25);
5369: health_benefits;
5370: elsif l_information_type = 'GHR_US_PAR_HEALTH_BEN_PRE_TAX' then
5371: hr_utility.set_location(l_proc,121);
5372: hr_utility.set_location('info type ' || l_information_type,25);
5373: health_ben_pre_tax;
5374: */
5375: elsif l_information_type = 'GHR_US_PAR_DANGER_PAY' then
5368: hr_utility.set_location('info type ' || l_information_type,25);
5369: health_benefits;
5370: elsif l_information_type = 'GHR_US_PAR_HEALTH_BEN_PRE_TAX' then
5371: hr_utility.set_location(l_proc,121);
5372: hr_utility.set_location('info type ' || l_information_type,25);
5373: health_ben_pre_tax;
5374: */
5375: elsif l_information_type = 'GHR_US_PAR_DANGER_PAY' then
5376: hr_utility.set_location(l_proc,125);
5372: hr_utility.set_location('info type ' || l_information_type,25);
5373: health_ben_pre_tax;
5374: */
5375: elsif l_information_type = 'GHR_US_PAR_DANGER_PAY' then
5376: hr_utility.set_location(l_proc,125);
5377: hr_utility.set_location('info type ' || l_information_type,26);
5378: danger_pay;
5379: elsif l_information_type = 'GHR_US_PAR_IMMNT_DANGER_PAY' then
5380: hr_utility.set_location(l_proc,130);
5373: health_ben_pre_tax;
5374: */
5375: elsif l_information_type = 'GHR_US_PAR_DANGER_PAY' then
5376: hr_utility.set_location(l_proc,125);
5377: hr_utility.set_location('info type ' || l_information_type,26);
5378: danger_pay;
5379: elsif l_information_type = 'GHR_US_PAR_IMMNT_DANGER_PAY' then
5380: hr_utility.set_location(l_proc,130);
5381: hr_utility.set_location('info type ' || l_information_type,27);
5376: hr_utility.set_location(l_proc,125);
5377: hr_utility.set_location('info type ' || l_information_type,26);
5378: danger_pay;
5379: elsif l_information_type = 'GHR_US_PAR_IMMNT_DANGER_PAY' then
5380: hr_utility.set_location(l_proc,130);
5381: hr_utility.set_location('info type ' || l_information_type,27);
5382: imminent_danger_pay;
5383: elsif l_information_type = 'GHR_US_PAR_LIVING_QUART_ALLOW' then
5384: hr_utility.set_location(l_proc,135);
5377: hr_utility.set_location('info type ' || l_information_type,26);
5378: danger_pay;
5379: elsif l_information_type = 'GHR_US_PAR_IMMNT_DANGER_PAY' then
5380: hr_utility.set_location(l_proc,130);
5381: hr_utility.set_location('info type ' || l_information_type,27);
5382: imminent_danger_pay;
5383: elsif l_information_type = 'GHR_US_PAR_LIVING_QUART_ALLOW' then
5384: hr_utility.set_location(l_proc,135);
5385: hr_utility.set_location('info type ' || l_information_type,28);
5380: hr_utility.set_location(l_proc,130);
5381: hr_utility.set_location('info type ' || l_information_type,27);
5382: imminent_danger_pay;
5383: elsif l_information_type = 'GHR_US_PAR_LIVING_QUART_ALLOW' then
5384: hr_utility.set_location(l_proc,135);
5385: hr_utility.set_location('info type ' || l_information_type,28);
5386: living_quarters_allow;
5387: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_PERCENT' then
5388: hr_utility.set_location(l_proc,140);
5381: hr_utility.set_location('info type ' || l_information_type,27);
5382: imminent_danger_pay;
5383: elsif l_information_type = 'GHR_US_PAR_LIVING_QUART_ALLOW' then
5384: hr_utility.set_location(l_proc,135);
5385: hr_utility.set_location('info type ' || l_information_type,28);
5386: living_quarters_allow;
5387: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_PERCENT' then
5388: hr_utility.set_location(l_proc,140);
5389: hr_utility.set_location('info type ' || l_information_type,29);
5384: hr_utility.set_location(l_proc,135);
5385: hr_utility.set_location('info type ' || l_information_type,28);
5386: living_quarters_allow;
5387: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_PERCENT' then
5388: hr_utility.set_location(l_proc,140);
5389: hr_utility.set_location('info type ' || l_information_type,29);
5390: post_diff_percent;
5391: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_AMOUNT' then
5392: hr_utility.set_location(l_proc,145);
5385: hr_utility.set_location('info type ' || l_information_type,28);
5386: living_quarters_allow;
5387: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_PERCENT' then
5388: hr_utility.set_location(l_proc,140);
5389: hr_utility.set_location('info type ' || l_information_type,29);
5390: post_diff_percent;
5391: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_AMOUNT' then
5392: hr_utility.set_location(l_proc,145);
5393: hr_utility.set_location('info type ' || l_information_type,30);
5388: hr_utility.set_location(l_proc,140);
5389: hr_utility.set_location('info type ' || l_information_type,29);
5390: post_diff_percent;
5391: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_AMOUNT' then
5392: hr_utility.set_location(l_proc,145);
5393: hr_utility.set_location('info type ' || l_information_type,30);
5394: post_diff_amt;
5395: elsif l_information_type = 'GHR_US_PAR_SEP_MAINT_ALLOWANCE' then
5396: hr_utility.set_location(l_proc,150);
5389: hr_utility.set_location('info type ' || l_information_type,29);
5390: post_diff_percent;
5391: elsif l_information_type = 'GHR_US_PAR_POST_DIFF_AMOUNT' then
5392: hr_utility.set_location(l_proc,145);
5393: hr_utility.set_location('info type ' || l_information_type,30);
5394: post_diff_amt;
5395: elsif l_information_type = 'GHR_US_PAR_SEP_MAINT_ALLOWANCE' then
5396: hr_utility.set_location(l_proc,150);
5397: hr_utility.set_location('info type ' || l_information_type,31);
5392: hr_utility.set_location(l_proc,145);
5393: hr_utility.set_location('info type ' || l_information_type,30);
5394: post_diff_amt;
5395: elsif l_information_type = 'GHR_US_PAR_SEP_MAINT_ALLOWANCE' then
5396: hr_utility.set_location(l_proc,150);
5397: hr_utility.set_location('info type ' || l_information_type,31);
5398: sep_maintenance_allow;
5399: elsif l_information_type = 'GHR_US_PAR_SUP_POST_ALLOWANCE' then
5400: hr_utility.set_location(l_proc,155);
5393: hr_utility.set_location('info type ' || l_information_type,30);
5394: post_diff_amt;
5395: elsif l_information_type = 'GHR_US_PAR_SEP_MAINT_ALLOWANCE' then
5396: hr_utility.set_location(l_proc,150);
5397: hr_utility.set_location('info type ' || l_information_type,31);
5398: sep_maintenance_allow;
5399: elsif l_information_type = 'GHR_US_PAR_SUP_POST_ALLOWANCE' then
5400: hr_utility.set_location(l_proc,155);
5401: hr_utility.set_location('info type ' || l_information_type,32);
5396: hr_utility.set_location(l_proc,150);
5397: hr_utility.set_location('info type ' || l_information_type,31);
5398: sep_maintenance_allow;
5399: elsif l_information_type = 'GHR_US_PAR_SUP_POST_ALLOWANCE' then
5400: hr_utility.set_location(l_proc,155);
5401: hr_utility.set_location('info type ' || l_information_type,32);
5402: supplemental_post_allow;
5403: elsif l_information_type = 'GHR_US_PAR_TMP_LODGE_ALLOWANCE' then
5404: hr_utility.set_location(l_proc,160);
5397: hr_utility.set_location('info type ' || l_information_type,31);
5398: sep_maintenance_allow;
5399: elsif l_information_type = 'GHR_US_PAR_SUP_POST_ALLOWANCE' then
5400: hr_utility.set_location(l_proc,155);
5401: hr_utility.set_location('info type ' || l_information_type,32);
5402: supplemental_post_allow;
5403: elsif l_information_type = 'GHR_US_PAR_TMP_LODGE_ALLOWANCE' then
5404: hr_utility.set_location(l_proc,160);
5405: hr_utility.set_location('info type ' || l_information_type,33);
5400: hr_utility.set_location(l_proc,155);
5401: hr_utility.set_location('info type ' || l_information_type,32);
5402: supplemental_post_allow;
5403: elsif l_information_type = 'GHR_US_PAR_TMP_LODGE_ALLOWANCE' then
5404: hr_utility.set_location(l_proc,160);
5405: hr_utility.set_location('info type ' || l_information_type,33);
5406: temp_lodge_allow;
5407: elsif l_information_type = 'GHR_US_PAR_PREMIUM_PAY' then
5408: hr_utility.set_location(l_proc,165);
5401: hr_utility.set_location('info type ' || l_information_type,32);
5402: supplemental_post_allow;
5403: elsif l_information_type = 'GHR_US_PAR_TMP_LODGE_ALLOWANCE' then
5404: hr_utility.set_location(l_proc,160);
5405: hr_utility.set_location('info type ' || l_information_type,33);
5406: temp_lodge_allow;
5407: elsif l_information_type = 'GHR_US_PAR_PREMIUM_PAY' then
5408: hr_utility.set_location(l_proc,165);
5409: hr_utility.set_location('info type ' || l_information_type,34);
5404: hr_utility.set_location(l_proc,160);
5405: hr_utility.set_location('info type ' || l_information_type,33);
5406: temp_lodge_allow;
5407: elsif l_information_type = 'GHR_US_PAR_PREMIUM_PAY' then
5408: hr_utility.set_location(l_proc,165);
5409: hr_utility.set_location('info type ' || l_information_type,34);
5410: premium_pay;
5411: elsif l_information_type = 'GHR_US_PAR_RETIREMENT_ANNUITY' then
5412: hr_utility.set_location(l_proc,170);
5405: hr_utility.set_location('info type ' || l_information_type,33);
5406: temp_lodge_allow;
5407: elsif l_information_type = 'GHR_US_PAR_PREMIUM_PAY' then
5408: hr_utility.set_location(l_proc,165);
5409: hr_utility.set_location('info type ' || l_information_type,34);
5410: premium_pay;
5411: elsif l_information_type = 'GHR_US_PAR_RETIREMENT_ANNUITY' then
5412: hr_utility.set_location(l_proc,170);
5413: hr_utility.set_location('info type ' || l_information_type,35);
5408: hr_utility.set_location(l_proc,165);
5409: hr_utility.set_location('info type ' || l_information_type,34);
5410: premium_pay;
5411: elsif l_information_type = 'GHR_US_PAR_RETIREMENT_ANNUITY' then
5412: hr_utility.set_location(l_proc,170);
5413: hr_utility.set_location('info type ' || l_information_type,35);
5414: retirement_annuity;
5415: elsif l_information_type = 'GHR_US_PAR_SEVERANCE_PAY' then
5416: hr_utility.set_location(l_proc,175);
5409: hr_utility.set_location('info type ' || l_information_type,34);
5410: premium_pay;
5411: elsif l_information_type = 'GHR_US_PAR_RETIREMENT_ANNUITY' then
5412: hr_utility.set_location(l_proc,170);
5413: hr_utility.set_location('info type ' || l_information_type,35);
5414: retirement_annuity;
5415: elsif l_information_type = 'GHR_US_PAR_SEVERANCE_PAY' then
5416: hr_utility.set_location(l_proc,175);
5417: hr_utility.set_location('info type ' || l_information_type,36);
5412: hr_utility.set_location(l_proc,170);
5413: hr_utility.set_location('info type ' || l_information_type,35);
5414: retirement_annuity;
5415: elsif l_information_type = 'GHR_US_PAR_SEVERANCE_PAY' then
5416: hr_utility.set_location(l_proc,175);
5417: hr_utility.set_location('info type ' || l_information_type,36);
5418: severance_pay;
5419: /*elsif l_information_type = 'GHR_US_PAR_TSP' then
5420: hr_utility.set_location(l_proc,180);
5413: hr_utility.set_location('info type ' || l_information_type,35);
5414: retirement_annuity;
5415: elsif l_information_type = 'GHR_US_PAR_SEVERANCE_PAY' then
5416: hr_utility.set_location(l_proc,175);
5417: hr_utility.set_location('info type ' || l_information_type,36);
5418: severance_pay;
5419: /*elsif l_information_type = 'GHR_US_PAR_TSP' then
5420: hr_utility.set_location(l_proc,180);
5421: hr_utility.set_location('info type ' || l_information_type,37);
5416: hr_utility.set_location(l_proc,175);
5417: hr_utility.set_location('info type ' || l_information_type,36);
5418: severance_pay;
5419: /*elsif l_information_type = 'GHR_US_PAR_TSP' then
5420: hr_utility.set_location(l_proc,180);
5421: hr_utility.set_location('info type ' || l_information_type,37);
5422: thrift_saving_plan;*/
5423: elsif l_information_type = 'GHR_US_PAR_RET_ALLOWANCE' then
5424: hr_utility.set_location(l_proc,180);
5417: hr_utility.set_location('info type ' || l_information_type,36);
5418: severance_pay;
5419: /*elsif l_information_type = 'GHR_US_PAR_TSP' then
5420: hr_utility.set_location(l_proc,180);
5421: hr_utility.set_location('info type ' || l_information_type,37);
5422: thrift_saving_plan;*/
5423: elsif l_information_type = 'GHR_US_PAR_RET_ALLOWANCE' then
5424: hr_utility.set_location(l_proc,180);
5425: hr_utility.set_location('info type ' || l_information_type,37);
5420: hr_utility.set_location(l_proc,180);
5421: hr_utility.set_location('info type ' || l_information_type,37);
5422: thrift_saving_plan;*/
5423: elsif l_information_type = 'GHR_US_PAR_RET_ALLOWANCE' then
5424: hr_utility.set_location(l_proc,180);
5425: hr_utility.set_location('info type ' || l_information_type,37);
5426: retention_allow_review;
5427: elsif l_information_type = 'GHR_US_PAR_CHG_TEN' then
5428: hr_utility.set_location(l_proc,110);
5421: hr_utility.set_location('info type ' || l_information_type,37);
5422: thrift_saving_plan;*/
5423: elsif l_information_type = 'GHR_US_PAR_RET_ALLOWANCE' then
5424: hr_utility.set_location(l_proc,180);
5425: hr_utility.set_location('info type ' || l_information_type,37);
5426: retention_allow_review;
5427: elsif l_information_type = 'GHR_US_PAR_CHG_TEN' then
5428: hr_utility.set_location(l_proc,110);
5429: chg_in_tenure;
5424: hr_utility.set_location(l_proc,180);
5425: hr_utility.set_location('info type ' || l_information_type,37);
5426: retention_allow_review;
5427: elsif l_information_type = 'GHR_US_PAR_CHG_TEN' then
5428: hr_utility.set_location(l_proc,110);
5429: chg_in_tenure;
5430: --Bug#2759379 Added FEGLI related Code
5431: elsif l_information_type = 'GHR_US_PAR_FEGLI' then
5432: hr_utility.set_location(l_proc,110);
5428: hr_utility.set_location(l_proc,110);
5429: chg_in_tenure;
5430: --Bug#2759379 Added FEGLI related Code
5431: elsif l_information_type = 'GHR_US_PAR_FEGLI' then
5432: hr_utility.set_location(l_proc,110);
5433: chg_in_fegli;
5434: elsif l_information_type = 'GHR_US_PAR_MD_DDS_PAY' then
5435: hr_utility.set_location(l_proc,200);
5436: mddds_pay;
5431: elsif l_information_type = 'GHR_US_PAR_FEGLI' then
5432: hr_utility.set_location(l_proc,110);
5433: chg_in_fegli;
5434: elsif l_information_type = 'GHR_US_PAR_MD_DDS_PAY' then
5435: hr_utility.set_location(l_proc,200);
5436: mddds_pay;
5437: elsif l_information_type = 'GHR_US_PAR_PREMIUM_PAY_IND' then
5438: hr_utility.set_location(l_proc,200);
5439: premium_pay_ind;
5434: elsif l_information_type = 'GHR_US_PAR_MD_DDS_PAY' then
5435: hr_utility.set_location(l_proc,200);
5436: mddds_pay;
5437: elsif l_information_type = 'GHR_US_PAR_PREMIUM_PAY_IND' then
5438: hr_utility.set_location(l_proc,200);
5439: premium_pay_ind;
5440: elsif l_information_type = 'GHR_US_PAR_STUDENT_LOAN' then
5441: hr_utility.set_location(l_proc,190);
5442: student_loan_repay;
5437: elsif l_information_type = 'GHR_US_PAR_PREMIUM_PAY_IND' then
5438: hr_utility.set_location(l_proc,200);
5439: premium_pay_ind;
5440: elsif l_information_type = 'GHR_US_PAR_STUDENT_LOAN' then
5441: hr_utility.set_location(l_proc,190);
5442: student_loan_repay;
5443: -- Bug#3385386 Added FTA condition.
5444: elsif l_information_type = 'GHR_US_PAR_FOR_TRANSER_ALLOW' then
5445: hr_utility.set_location(l_proc,210);
5441: hr_utility.set_location(l_proc,190);
5442: student_loan_repay;
5443: -- Bug#3385386 Added FTA condition.
5444: elsif l_information_type = 'GHR_US_PAR_FOR_TRANSER_ALLOW' then
5445: hr_utility.set_location(l_proc,210);
5446: hr_utility.set_location('info type ' || l_information_type,22);
5447: fta;
5448: elsif l_information_type = 'GHR_US_PAR_BENEFITS' then
5449: --Bug # 10420280 Modified to not to call benefits for correction
5442: student_loan_repay;
5443: -- Bug#3385386 Added FTA condition.
5444: elsif l_information_type = 'GHR_US_PAR_FOR_TRANSER_ALLOW' then
5445: hr_utility.set_location(l_proc,210);
5446: hr_utility.set_location('info type ' || l_information_type,22);
5447: fta;
5448: elsif l_information_type = 'GHR_US_PAR_BENEFITS' then
5449: --Bug # 10420280 Modified to not to call benefits for correction
5450: if l_session.noa_id_correct is null then
5447: fta;
5448: elsif l_information_type = 'GHR_US_PAR_BENEFITS' then
5449: --Bug # 10420280 Modified to not to call benefits for correction
5450: if l_session.noa_id_correct is null then
5451: hr_utility.set_location(l_proc,210);
5452: hr_utility.set_location('info type ' || l_information_type,22);
5453: appt_benefits;
5454: end if;
5455: elsif l_information_type = 'GHR_US_PAR_MASS_TERM' then
5448: elsif l_information_type = 'GHR_US_PAR_BENEFITS' then
5449: --Bug # 10420280 Modified to not to call benefits for correction
5450: if l_session.noa_id_correct is null then
5451: hr_utility.set_location(l_proc,210);
5452: hr_utility.set_location('info type ' || l_information_type,22);
5453: appt_benefits;
5454: end if;
5455: elsif l_information_type = 'GHR_US_PAR_MASS_TERM' then
5456: hr_utility.set_location(l_proc,210);
5452: hr_utility.set_location('info type ' || l_information_type,22);
5453: appt_benefits;
5454: end if;
5455: elsif l_information_type = 'GHR_US_PAR_MASS_TERM' then
5456: hr_utility.set_location(l_proc,210);
5457: hr_utility.set_location('info type ' || l_information_type,22);
5458: separate352;
5459: -- Bug 4724337 Race or National Origin changes
5460: elsif l_information_type = 'GHR_US_PAR_ETHNICITY_RACE' then
5453: appt_benefits;
5454: end if;
5455: elsif l_information_type = 'GHR_US_PAR_MASS_TERM' then
5456: hr_utility.set_location(l_proc,210);
5457: hr_utility.set_location('info type ' || l_information_type,22);
5458: separate352;
5459: -- Bug 4724337 Race or National Origin changes
5460: elsif l_information_type = 'GHR_US_PAR_ETHNICITY_RACE' then
5461: hr_utility.set_location(l_proc,210);
5457: hr_utility.set_location('info type ' || l_information_type,22);
5458: separate352;
5459: -- Bug 4724337 Race or National Origin changes
5460: elsif l_information_type = 'GHR_US_PAR_ETHNICITY_RACE' then
5461: hr_utility.set_location(l_proc,210);
5462: hr_utility.set_location('info type ' || l_information_type,22);
5463: race_ethnic_info;
5464: -- Bug 4486823 RRR Changes
5465: elsif l_information_type = 'GHR_US_PAR_SERVICE_OBLIGATION' then
5458: separate352;
5459: -- Bug 4724337 Race or National Origin changes
5460: elsif l_information_type = 'GHR_US_PAR_ETHNICITY_RACE' then
5461: hr_utility.set_location(l_proc,210);
5462: hr_utility.set_location('info type ' || l_information_type,22);
5463: race_ethnic_info;
5464: -- Bug 4486823 RRR Changes
5465: elsif l_information_type = 'GHR_US_PAR_SERVICE_OBLIGATION' then
5466: hr_utility.set_location(l_proc,220);
5462: hr_utility.set_location('info type ' || l_information_type,22);
5463: race_ethnic_info;
5464: -- Bug 4486823 RRR Changes
5465: elsif l_information_type = 'GHR_US_PAR_SERVICE_OBLIGATION' then
5466: hr_utility.set_location(l_proc,220);
5467: hr_utility.set_location('info type ' || l_information_type,22);
5468: service_obligation;
5469: -- Bug 4724337 Race or National Origin changes
5470: elsif l_information_type = 'GHR_US_PAR_RETENTION_INCENTIVE' then
5463: race_ethnic_info;
5464: -- Bug 4486823 RRR Changes
5465: elsif l_information_type = 'GHR_US_PAR_SERVICE_OBLIGATION' then
5466: hr_utility.set_location(l_proc,220);
5467: hr_utility.set_location('info type ' || l_information_type,22);
5468: service_obligation;
5469: -- Bug 4724337 Race or National Origin changes
5470: elsif l_information_type = 'GHR_US_PAR_RETENTION_INCENTIVE' then
5471: hr_utility.set_location(l_proc,230);
5467: hr_utility.set_location('info type ' || l_information_type,22);
5468: service_obligation;
5469: -- Bug 4724337 Race or National Origin changes
5470: elsif l_information_type = 'GHR_US_PAR_RETENTION_INCENTIVE' then
5471: hr_utility.set_location(l_proc,230);
5472: hr_utility.set_location('info type ' || l_information_type,22);
5473: incentive_retention;
5474: -- Bug 4486823 RRR Changes
5475: elsif l_information_type = 'GHR_US_PAR_EMERG_ESSNTL_ASG' then
5468: service_obligation;
5469: -- Bug 4724337 Race or National Origin changes
5470: elsif l_information_type = 'GHR_US_PAR_RETENTION_INCENTIVE' then
5471: hr_utility.set_location(l_proc,230);
5472: hr_utility.set_location('info type ' || l_information_type,22);
5473: incentive_retention;
5474: -- Bug 4486823 RRR Changes
5475: elsif l_information_type = 'GHR_US_PAR_EMERG_ESSNTL_ASG' then
5476: hr_utility.set_location(l_proc,240);
5472: hr_utility.set_location('info type ' || l_information_type,22);
5473: incentive_retention;
5474: -- Bug 4486823 RRR Changes
5475: elsif l_information_type = 'GHR_US_PAR_EMERG_ESSNTL_ASG' then
5476: hr_utility.set_location(l_proc,240);
5477: hr_utility.set_location('info type ' || l_information_type,22);
5478: key_emergency_essntl;
5479: -- Bug 4280026 Key Emergency Essential Changes .
5480: -- Begin Bug# 4126188
5473: incentive_retention;
5474: -- Bug 4486823 RRR Changes
5475: elsif l_information_type = 'GHR_US_PAR_EMERG_ESSNTL_ASG' then
5476: hr_utility.set_location(l_proc,240);
5477: hr_utility.set_location('info type ' || l_information_type,22);
5478: key_emergency_essntl;
5479: -- Bug 4280026 Key Emergency Essential Changes .
5480: -- Begin Bug# 4126188
5481: elsif l_information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG' then
5478: key_emergency_essntl;
5479: -- Bug 4280026 Key Emergency Essential Changes .
5480: -- Begin Bug# 4126188
5481: elsif l_information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG' then
5482: hr_utility.set_location(l_proc,250);
5483: hr_utility.set_location('info type ' || l_information_type,22);
5484: rg_posn_chg;
5485: -- end Bug# 4126188
5486: elsif l_information_type = 'GHR_US_PAR_CONVERSION_DATES' then
5479: -- Bug 4280026 Key Emergency Essential Changes .
5480: -- Begin Bug# 4126188
5481: elsif l_information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG' then
5482: hr_utility.set_location(l_proc,250);
5483: hr_utility.set_location('info type ' || l_information_type,22);
5484: rg_posn_chg;
5485: -- end Bug# 4126188
5486: elsif l_information_type = 'GHR_US_PAR_CONVERSION_DATES' then
5487: hr_utility.set_location(l_proc,260);
5483: hr_utility.set_location('info type ' || l_information_type,22);
5484: rg_posn_chg;
5485: -- end Bug# 4126188
5486: elsif l_information_type = 'GHR_US_PAR_CONVERSION_DATES' then
5487: hr_utility.set_location(l_proc,260);
5488: hr_utility.set_location('info type ' || l_information_type,22);
5489: ghr_conv_dates;
5490: -- Bug 5482191
5491: --start of Bug# 6312144 , Bug# 8653508 added GHR_US_PAR_DET_BENEFIT_CONT
5484: rg_posn_chg;
5485: -- end Bug# 4126188
5486: elsif l_information_type = 'GHR_US_PAR_CONVERSION_DATES' then
5487: hr_utility.set_location(l_proc,260);
5488: hr_utility.set_location('info type ' || l_information_type,22);
5489: ghr_conv_dates;
5490: -- Bug 5482191
5491: --start of Bug# 6312144 , Bug# 8653508 added GHR_US_PAR_DET_BENEFIT_CONT
5492: elsif l_information_type IN ('GHR_US_PAR_BENEFITS_CONT','GHR_US_PAR_DET_BENEFIT_CONT') then
5489: ghr_conv_dates;
5490: -- Bug 5482191
5491: --start of Bug# 6312144 , Bug# 8653508 added GHR_US_PAR_DET_BENEFIT_CONT
5492: elsif l_information_type IN ('GHR_US_PAR_BENEFITS_CONT','GHR_US_PAR_DET_BENEFIT_CONT') then
5493: hr_utility.set_location(l_proc,270);
5494: hr_utility.set_location('info type ' || l_information_type,22);
5495: ipa_benefits_cont;
5496: elsif l_information_type = 'GHR_US_PAR_BENEFIT_INFO' then
5497: hr_utility.set_location(l_proc,280);
5490: -- Bug 5482191
5491: --start of Bug# 6312144 , Bug# 8653508 added GHR_US_PAR_DET_BENEFIT_CONT
5492: elsif l_information_type IN ('GHR_US_PAR_BENEFITS_CONT','GHR_US_PAR_DET_BENEFIT_CONT') then
5493: hr_utility.set_location(l_proc,270);
5494: hr_utility.set_location('info type ' || l_information_type,22);
5495: ipa_benefits_cont;
5496: elsif l_information_type = 'GHR_US_PAR_BENEFIT_INFO' then
5497: hr_utility.set_location(l_proc,280);
5498: hr_utility.set_location('info type ' || l_information_type,22);
5493: hr_utility.set_location(l_proc,270);
5494: hr_utility.set_location('info type ' || l_information_type,22);
5495: ipa_benefits_cont;
5496: elsif l_information_type = 'GHR_US_PAR_BENEFIT_INFO' then
5497: hr_utility.set_location(l_proc,280);
5498: hr_utility.set_location('info type ' || l_information_type,22);
5499: ben_info_cont;
5500: elsif l_information_type = 'GHR_US_PAR_RETIRMENT_SYS_INFO' then
5501: hr_utility.set_location(l_proc,290);
5494: hr_utility.set_location('info type ' || l_information_type,22);
5495: ipa_benefits_cont;
5496: elsif l_information_type = 'GHR_US_PAR_BENEFIT_INFO' then
5497: hr_utility.set_location(l_proc,280);
5498: hr_utility.set_location('info type ' || l_information_type,22);
5499: ben_info_cont;
5500: elsif l_information_type = 'GHR_US_PAR_RETIRMENT_SYS_INFO' then
5501: hr_utility.set_location(l_proc,290);
5502: hr_utility.set_location('info type ' || l_information_type,22);
5497: hr_utility.set_location(l_proc,280);
5498: hr_utility.set_location('info type ' || l_information_type,22);
5499: ben_info_cont;
5500: elsif l_information_type = 'GHR_US_PAR_RETIRMENT_SYS_INFO' then
5501: hr_utility.set_location(l_proc,290);
5502: hr_utility.set_location('info type ' || l_information_type,22);
5503: retirement_info;
5504: --end of Bug# 6312144
5505: --Begin Bug# 8653508
5498: hr_utility.set_location('info type ' || l_information_type,22);
5499: ben_info_cont;
5500: elsif l_information_type = 'GHR_US_PAR_RETIRMENT_SYS_INFO' then
5501: hr_utility.set_location(l_proc,290);
5502: hr_utility.set_location('info type ' || l_information_type,22);
5503: retirement_info;
5504: --end of Bug# 6312144
5505: --Begin Bug# 8653508
5506: elsif l_information_type = 'GHR_US_PAR_DET_INFO' then
5503: retirement_info;
5504: --end of Bug# 6312144
5505: --Begin Bug# 8653508
5506: elsif l_information_type = 'GHR_US_PAR_DET_INFO' then
5507: hr_utility.set_location(l_proc,300);
5508: hr_utility.set_location('info type ' || l_information_type,22);
5509: detail_info;
5510: --End Bug# 8653508
5511: /* --Begin Bug# 4588575
5504: --end of Bug# 6312144
5505: --Begin Bug# 8653508
5506: elsif l_information_type = 'GHR_US_PAR_DET_INFO' then
5507: hr_utility.set_location(l_proc,300);
5508: hr_utility.set_location('info type ' || l_information_type,22);
5509: detail_info;
5510: --End Bug# 8653508
5511: /* --Begin Bug# 4588575
5512: elsif l_information_type = 'GHR_US_PAR_PROBATION_INFO' then
5509: detail_info;
5510: --End Bug# 8653508
5511: /* --Begin Bug# 4588575
5512: elsif l_information_type = 'GHR_US_PAR_PROBATION_INFO' then
5513: hr_utility.set_location(l_proc,270);
5514: hr_utility.set_location('info type ' || l_information_type,270);
5515: ghr_prob_info;
5516: --end Bug# 4588575
5517: */ --Backout the changes done for Bug# 4588575
5510: --End Bug# 8653508
5511: /* --Begin Bug# 4588575
5512: elsif l_information_type = 'GHR_US_PAR_PROBATION_INFO' then
5513: hr_utility.set_location(l_proc,270);
5514: hr_utility.set_location('info type ' || l_information_type,270);
5515: ghr_prob_info;
5516: --end Bug# 4588575
5517: */ --Backout the changes done for Bug# 4588575
5518: --Begin Bug# 12557463
5516: --end Bug# 4588575
5517: */ --Backout the changes done for Bug# 4588575
5518: --Begin Bug# 12557463
5519: elsif l_information_type = 'GHR_US_PAR_SCD_INFO' then
5520: hr_utility.set_location(l_proc,280);
5521: hr_utility.set_location('info type ' || l_information_type,280);
5522: ghr_scd_info;
5523: --End Bug# 12557463
5524: end if;
5517: */ --Backout the changes done for Bug# 4588575
5518: --Begin Bug# 12557463
5519: elsif l_information_type = 'GHR_US_PAR_SCD_INFO' then
5520: hr_utility.set_location(l_proc,280);
5521: hr_utility.set_location('info type ' || l_information_type,280);
5522: ghr_scd_info;
5523: --End Bug# 12557463
5524: end if;
5525: End loop; -- info types
5543: -- Bug#5668878 End
5544: -- Rohini
5545: l_noa_code := p_pa_request_rec.first_noa_code;
5546: /* if l_noa_code = '352' then
5547: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
5548: p_per_separate_retire.agency_code_transfer_to ,38);
5549: set_extra_info(p_per_separate_retire.agency_code_transfer_to,
5550: l_pa_request_ei_rec.rei_information3,
5551: ------ AVR p_pa_request_rec.first_noa_information1,
5549: set_extra_info(p_per_separate_retire.agency_code_transfer_to,
5550: l_pa_request_ei_rec.rei_information3,
5551: ------ AVR p_pa_request_rec.first_noa_information1,
5552: p_per_separate_Retire.per_sep_Retire_flag);
5553: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
5554: p_per_separate_retire.agency_code_transfer_to ,38);
5555: End if; */
5556: --
5557: -- Process Generic Agency information
5571: for asg_stat_rec in c_user_status loop
5572: l_old_user_status := asg_stat_rec.user_status;
5573: l_old_system_status := asg_stat_rec.per_system_status;
5574: l_old_effective_start_date := asg_stat_rec.effective_start_date -1;
5575: hr_utility.set_location('Old User status is '||l_old_user_status,96);
5576: exit;
5577: end loop;
5578: -- Bug# 4672772 End
5579:
5576: exit;
5577: end loop;
5578: -- Bug# 4672772 End
5579:
5580: hr_utility.set_location('Leaving - process_non_sf52_extra_info',170);
5581:
5582: -- NTE start dates processing
5583: -- Added 515 -- Venkat 04/26
5584: If l_noa_code in ('108','115','117','122','148','149','153',
5585: '154','171','190','508','515','517','522','548',
5586: '549','553','554','571','590','741') then
5587: --Bug# 4602352 703 is removed from the list
5588: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5589: hr_utility.set_location('inside asg nte dates ',1);
5590: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5591: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5592: --Begin Bug# 4602352
5593: Elsif l_noa_code ='703' and (l_old_user_status <> 'Term Limited Appt') THEN
5586: '549','553','554','571','590','741') then
5587: --Bug# 4602352 703 is removed from the list
5588: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5589: hr_utility.set_location('inside asg nte dates ',1);
5590: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5591: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5592: --Begin Bug# 4602352
5593: Elsif l_noa_code ='703' and (l_old_user_status <> 'Term Limited Appt') THEN
5594: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5591: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5592: --Begin Bug# 4602352
5593: Elsif l_noa_code ='703' and (l_old_user_status <> 'Term Limited Appt') THEN
5594: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5595: hr_utility.set_location('inside asg nte dates for 703 ',111);
5596: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5597: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5598: --End Bug# 4602352
5599: Elsif l_noa_code = '472' then
5592: --Begin Bug# 4602352
5593: Elsif l_noa_code ='703' and (l_old_user_status <> 'Term Limited Appt') THEN
5594: p_asg_nte_dates.asg_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5595: hr_utility.set_location('inside asg nte dates for 703 ',111);
5596: hr_utility.set_location('nte date ' || (p_asg_nte_dates.asg_nte_start_date),2);
5597: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5598: --End Bug# 4602352
5599: Elsif l_noa_code = '472' then
5600: p_asg_nte_dates.furlough_nte_start_date := fnd_date.date_to_canonical(p_pa_request_rec.effective_date);
5620: '154','171','190','508','515','517','522',
5621: '548','549','553','554','571','590',--'703', Removed for Bug# 4602352
5622: '741','750','760','761','762','765','769','770') then
5623: p_asg_nte_dates.assignment_nte := p_pa_request_rec.first_noa_information1;
5624: hr_utility.set_location('dates ' || p_asg_nte_dates.assignment_nte,1);
5625: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5626: --Begin Bug# 4602352
5627: Elsif l_noa_code ='703' and (l_old_user_status <> 'Term Limited Appt') THEN
5628: p_asg_nte_dates.assignment_nte := p_pa_request_rec.first_noa_information1;
5625: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5626: --Begin Bug# 4602352
5627: Elsif l_noa_code ='703' and (l_old_user_status <> 'Term Limited Appt') THEN
5628: p_asg_nte_dates.assignment_nte := p_pa_request_rec.first_noa_information1;
5629: hr_utility.set_location('dates ' || p_asg_nte_dates.assignment_nte,100);
5630: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5631: --End Bug# 4602352
5632: Elsif l_noa_code in ('472','772') then
5633: hr_utility.set_location(' furlough nte dates for 472 and 772',1);
5629: hr_utility.set_location('dates ' || p_asg_nte_dates.assignment_nte,100);
5630: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5631: --End Bug# 4602352
5632: Elsif l_noa_code in ('472','772') then
5633: hr_utility.set_location(' furlough nte dates for 472 and 772',1);
5634: p_asg_nte_dates.furlough_nte := p_pa_request_rec.first_noa_information1;
5635: p_asg_nte_dates.asg_nte_dates_flag := 'Y';
5636: Elsif l_noa_code = '462' then
5637: p_asg_nte_dates.lwp_nte := p_pa_request_rec.first_noa_information1;
5781: --End Bug# 10182526
5782: --Begin Bug# 13942237
5783: --Bug# 14514445 commented below code since we are getting promotion_eligibility_date from RPA EITs
5784: /*IF l_noa_code IN ('100','101','130','140','141','170','500','501','540','541','570','702','713','721') THEN
5785: hr_utility.set_location('promotion_eligibility_date Position Id '|| NVL(p_pa_request_rec.to_position_id,p_pa_request_rec.from_position_id),350);
5786: ghr_history_fetch.fetch_positionei
5787: (p_position_id => NVL(p_pa_request_rec.to_position_id,p_pa_request_rec.from_position_id),
5788: p_information_type => 'GHR_US_POS_VALID_GRADE',
5789: p_date_effective => p_pa_request_rec.effective_date,
5796: FOR grade_name in grade_id(l_pos_extra_info_rec.poei_information4) LOOP
5797: l_target_grade_name := grade_name.name;
5798: exit;
5799: END LOOP;
5800: hr_utility.set_location('promotion_eligibility_date Valid Grade '|| l_valid_grade_name,351);
5801: hr_utility.set_location('promotion_eligibility_date Target Grade '|| l_target_grade_name,352);
5802:
5803: IF SUBSTR(l_valid_grade_name,1,2) = SUBSTR(l_target_grade_name,1,2) AND
5804: TO_NUMBER(SUBSTR(l_valid_grade_name,4,5)) < TO_NUMBER(SUBSTR(l_target_grade_name,4,5)) THEN
5797: l_target_grade_name := grade_name.name;
5798: exit;
5799: END LOOP;
5800: hr_utility.set_location('promotion_eligibility_date Valid Grade '|| l_valid_grade_name,351);
5801: hr_utility.set_location('promotion_eligibility_date Target Grade '|| l_target_grade_name,352);
5802:
5803: IF SUBSTR(l_valid_grade_name,1,2) = SUBSTR(l_target_grade_name,1,2) AND
5804: TO_NUMBER(SUBSTR(l_valid_grade_name,4,5)) < TO_NUMBER(SUBSTR(l_target_grade_name,4,5)) THEN
5805: hr_utility.set_location('promotion_eligibility_date update '|| l_valid_grade_name,353);
5801: hr_utility.set_location('promotion_eligibility_date Target Grade '|| l_target_grade_name,352);
5802:
5803: IF SUBSTR(l_valid_grade_name,1,2) = SUBSTR(l_target_grade_name,1,2) AND
5804: TO_NUMBER(SUBSTR(l_valid_grade_name,4,5)) < TO_NUMBER(SUBSTR(l_target_grade_name,4,5)) THEN
5805: hr_utility.set_location('promotion_eligibility_date update '|| l_valid_grade_name,353);
5806: set_extra_info(p_per_group1.promotion_eligibility_date,fnd_date.date_to_canonical(p_pa_request_rec.effective_date+365),
5807: p_per_group1.per_group1_flag);
5808: END IF;
5809: