[Home] [Help]
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'
23: ,p_date_effective => p_pa_req_rec.effective_date
24: ,p_per_ei_data => l_pei_extra_info);
25: p_auth_code1 := l_pei_extra_info.pei_information8;
416:
417: If p_pa_request_rec.from_position_id is not null then
418:
419: ghr_history_api.get_g_session_var(l_session);
420: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50
421: (
422: p_assignment_id => p_pa_request_rec.employee_assignment_id,
423: p_information_type => 'GHR_US_ASG_SF52',
424: p_date_effective => p_pa_request_rec.effective_date,
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,
456: p_date_effective => l_effective_date,
457: p_altered_pa_request_id => l_session.altered_pa_request_id,
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,
535: p_special_info => l_special_info_type
941: -- existing pay user status ra value for Conversion Actions as it is a mandatory field
942:
943: IF p_pa_request_rec.noa_family_code in ('CONV_APP') and p_pa_request_rec.employee_assignment_id is not NULL THEN
944:
945: ghr_history_fetch.fetch_asgei
946: (p_assignment_id => p_pa_request_rec.employee_assignment_id,
947: p_information_type => 'GHR_US_ASG_NON_SF52',
948: p_date_effective => p_pa_request_rec.effective_date,
949: p_asg_ei_data => l_asg_extra_info_rec
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
969: (p_assignment_id => p_pa_request_rec.employee_assignment_id,
970: p_information_type => 'GHR_US_ASG_SF52',
971: p_date_effective => p_pa_request_rec.effective_date,
972: p_asg_ei_data => l_asg_extra_info_rec
993:
994:
995: -- Retrieve asg_non_sf52
996:
997: ghr_history_fetch.fetch_asgei
998: (p_assignment_id => p_pa_request_rec.employee_assignment_id,
999: p_information_type => 'GHR_US_ASG_NON_SF52',
1000: p_date_effective => p_pa_request_rec.effective_date,
1001: p_asg_ei_data => l_asg_extra_info_rec
1020: l_asg_extra_info_rec := null;
1021:
1022: -- Retrieve asg_nte_dates
1023:
1024: ghr_history_fetch.fetch_asgei
1025: (p_assignment_id => p_pa_request_rec.employee_assignment_id,
1026: p_information_type => 'GHR_US_ASG_NTE_DATES',
1027: p_date_effective => p_pa_request_rec.effective_date,
1028: p_asg_ei_data => l_asg_extra_info_rec
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,
1058: p_asg_ei_data => l_asg_extra_info_rec
1079: END IF;
1080:
1081: -- Retrieve PER SF52
1082:
1083: ghr_history_fetch.fetch_peopleei
1084: (p_person_id => p_pa_request_rec.person_id,
1085: p_information_type => 'GHR_US_PER_SF52',
1086: p_date_effective => p_pa_request_rec.effective_date,
1087: p_per_ei_data => l_per_extra_info_rec
1099: l_per_extra_info_rec := null;
1100:
1101: -- Retrieve Per_Group1
1102:
1103: ghr_history_fetch.fetch_peopleei
1104: (p_person_id => p_pa_request_rec.person_id,
1105: p_information_type => 'GHR_US_PER_GROUP1',
1106: p_date_effective => p_pa_request_rec.effective_date,
1107: p_per_ei_data => l_per_extra_info_rec
1139:
1140:
1141: --bug # 14276354
1142:
1143: ghr_history_fetch.fetch_peopleei
1144: (p_person_id => p_pa_request_rec.person_id,
1145: p_information_type => 'GHR_US_PER_GROUP2',
1146: p_date_effective => p_pa_request_rec.effective_date,
1147: p_per_ei_data => l_per_extra_info_rec
1166: --
1167:
1168: -- Retrieve Per_scd `
1169:
1170: ghr_history_fetch.fetch_peopleei
1171: (p_person_id => p_pa_request_rec.person_id,
1172: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
1173: p_date_effective => p_pa_request_rec.effective_date,
1174: p_per_ei_data => l_per_extra_info_rec
1196:
1197:
1198: -- Retrieve per_probations
1199:
1200: ghr_history_fetch.fetch_peopleei
1201: (p_person_id => p_pa_request_rec.person_id,
1202: p_information_type => 'GHR_US_PER_PROBATIONS',
1203: p_date_effective => p_pa_request_rec.effective_date,
1204: p_per_ei_data => l_per_extra_info_rec
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',
1305: p_date_effective => p_pa_request_rec.effective_date,
1306: p_per_ei_data => l_per_extra_info_rec
1342:
1343: -- Bug#4486823 RRR Changes
1344: -- Retrieve per_service_obligation
1345:
1346: /* ghr_history_fetch.fetch_peopleei
1347: (p_person_id => p_pa_request_rec.person_id,
1348: p_information_type => 'GHR_US_PER_SERVICE_OBLIGATION',
1349: p_date_effective => p_pa_request_rec.effective_date,
1350: p_per_ei_data => l_per_extra_info_rec
1363: hr_utility.set_location('retrieved per serv oblg ',15); */
1364:
1365: -- Retrieve per_uniformed_services
1366:
1367: ghr_history_fetch.fetch_peopleei
1368: (p_person_id => p_pa_request_rec.person_id,
1369: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
1370: p_date_effective => p_pa_request_rec.effective_date,
1371: p_per_ei_data => l_per_extra_info_rec
1387:
1388:
1389: -- Retrieve per_conversions
1390:
1391: ghr_history_fetch.fetch_peopleei
1392: (p_person_id => p_pa_request_rec.person_id,
1393: p_information_type => 'GHR_US_PER_CONVERSIONS',
1394: p_date_effective => p_pa_request_rec.effective_date,
1395: p_per_ei_data => l_per_extra_info_rec
1406: l_per_extra_info_rec := null;
1407:
1408: -- 4352589 BEN_EIT Changes
1409: -- Retrieve per_benefit_info
1410: ghr_history_fetch.fetch_peopleei
1411: (p_person_id => p_pa_request_rec.person_id,
1412: p_information_type => 'GHR_US_PER_BENEFIT_INFO',
1413: p_date_effective => p_pa_request_rec.effective_date,
1414: p_per_ei_data => l_per_extra_info_rec
1438:
1439:
1440: -- Bug 4724337 Race or National Origin changes
1441: l_per_extra_info_rec := null;
1442: ghr_history_fetch.fetch_peopleei
1443: (p_person_id => p_pa_request_rec.person_id,
1444: p_information_type => 'GHR_US_PER_ETHNICITY_RACE',
1445: p_date_effective => p_pa_request_rec.effective_date,
1446: p_per_ei_data => l_per_extra_info_rec
1462: Else
1463: l_position_id := p_pa_request_rec.to_position_id;
1464: End if;
1465:
1466: ghr_history_fetch.fetch_positionei
1467: (p_position_id => l_position_id,
1468: p_information_type => 'GHR_US_POS_VALID_GRADE',
1469: p_date_effective => p_pa_request_rec.effective_date,
1470: p_pos_ei_data => l_pos_extra_info_rec
1487:
1488: -- Retrieve Position group1
1489:
1490:
1491: ghr_history_fetch.fetch_positionei
1492: (p_position_id => l_position_id,
1493: p_information_type => 'GHR_US_POS_GRP1',
1494: p_date_effective => p_pa_request_rec.effective_date,
1495: p_pos_ei_data => l_pos_extra_info_rec
1531: l_pos_extra_info_rec := null;
1532:
1533: -- Retrieve Position Group2
1534:
1535: ghr_history_fetch.fetch_positionei
1536: (p_position_id => l_position_id,
1537: p_information_type => 'GHR_US_POS_GRP2',
1538: p_date_effective => p_pa_request_rec.effective_date,
1539: p_pos_ei_data => l_pos_extra_info_rec
1566: l_pos_extra_info_rec := null;
1567:
1568: -- Retrieve Position Obligation
1569:
1570: ghr_history_fetch.fetch_positionei
1571: (p_position_id => l_position_id,
1572: p_information_type => 'GHR_US_POS_OBLIG',
1573: p_date_effective => p_pa_request_rec.effective_date,
1574: p_pos_ei_data => l_pos_extra_info_rec
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',
1595: p_date_effective => p_pa_request_rec.effective_date,
1596: p_per_ei_data => l_per_extra_info_rec
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,
1623: p_information_type => 'GHR_US_PER_RETIRMENT_SYS_INFO',
1624: p_date_effective => p_pa_request_rec.effective_date,
1625: p_per_ei_data => l_per_extra_info_rec
2898: p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2899: --Added by deenath to fix bug 4542401.
2900: IF (p_pa_request_rec.first_noa_code IN ('781','782') OR
2901: p_pa_request_rec.second_noa_code IN ('781','782')) THEN
2902: ghr_history_fetch.fetch_element_entry_value
2903: (p_element_name => 'Within Grade Increase',
2904: p_input_value_name => 'Last Equivalent Increase',
2905: p_assignment_id => p_pa_request_rec.employee_assignment_id,
2906: p_date_effective => p_pa_request_rec.effective_date,
3435: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3436: IF NOT(p_pa_request_rec.second_noa_code = '892' AND --Begin Bug 9538056
3437: (NVL(p_pa_request_rec.second_action_la_code1,'111') = 'RBM' or NVL(p_pa_request_rec.second_action_la_code2,'111') = 'RBM')) THEN
3438: if p_gov_awards.award_agency is null then
3439: ghr_history_fetch.fetch_element_entry_value
3440: (p_element_name => 'Federal Awards',
3441: p_input_value_name => 'Award Agency',
3442: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3443: p_date_effective => p_pa_request_rec.effective_date,
3444: p_screen_entry_value => p_gov_awards.award_agency
3445: );
3446: end if;
3447: if p_gov_awards.award_type is null then
3448: ghr_history_fetch.fetch_element_entry_value
3449: (p_element_name => 'Federal Awards',
3450: p_input_value_name => 'Award Type',
3451: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3452: p_date_effective => p_pa_request_rec.effective_date,
3453: p_screen_entry_value => p_gov_awards.award_type
3454: );
3455: end if;
3456: if p_gov_awards.date_award_earned is null then
3457: ghr_history_fetch.fetch_element_entry_value
3458: (p_element_name => 'Federal Awards',
3459: p_input_value_name => 'Date Award Earned',
3460: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3461: p_date_effective => p_pa_request_rec.effective_date,
3463: );
3464: end if;
3465: END IF;-- End Bug 9538056
3466: if p_gov_awards.group_award is null then
3467: ghr_history_fetch.fetch_element_entry_value
3468: (p_element_name => 'Federal Awards',
3469: p_input_value_name => 'Group Award',
3470: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3471: p_date_effective => p_pa_request_rec.effective_date,
3472: p_screen_entry_value => p_gov_awards.group_award
3473: );
3474: end if;
3475: if p_gov_awards.tangible_benefit_dollars is null then
3476: ghr_history_fetch.fetch_element_entry_value
3477: (p_element_name => 'Federal Awards',
3478: p_input_value_name => 'Tangible Benefit Dollars',
3479: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3480: p_date_effective => p_pa_request_rec.effective_date,
3482: );
3483: end if;
3484:
3485: if p_gov_awards.award_appropriation_code is null then
3486: ghr_history_fetch.fetch_element_entry_value
3487: (p_element_name => 'Federal Awards',
3488: p_input_value_name => 'Appropriation Code',
3489: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3490: p_date_effective => p_pa_request_rec.effective_date,
3493: end if;
3494: /*
3495: -- Bug 2835929 Allow date_exemp_award to be updated to null.
3496: if p_gov_awards.date_exemp_award is null then
3497: ghr_history_fetch.fetch_element_entry_value
3498: (p_element_name => 'Federal Awards',
3499: p_input_value_name => 'Date Ex Emp Award Paid',
3500: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3501: p_date_effective => p_pa_request_rec.effective_date,
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
3799: p_entitlement.entitlement_flag := 'Y';
3800: end if;
3801: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3802: if p_entitlement.entitlement_code is null then
3803: ghr_history_fetch.fetch_element_entry_value
3804: (p_element_name => 'Entitlement',
3805: p_input_value_name => 'Code',
3806: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3807: p_date_effective => p_pa_request_rec.effective_date,
3808: p_screen_entry_value => p_entitlement.entitlement_code
3809: );
3810: end if;
3811: if p_entitlement.entitlement_amt_percent is null then
3812: ghr_history_fetch.fetch_element_entry_value
3813: (p_element_name => 'Entitlement',
3814: p_input_value_name => 'Amount or Percent',
3815: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3816: p_date_effective => p_pa_request_rec.effective_date,
3837: p_foreign_lang_prof_pay.for_lang_flag := 'Y';
3838: end if;
3839: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3840: if p_foreign_lang_prof_pay.certification_date is null then
3841: ghr_history_fetch.fetch_element_entry_value
3842: (p_element_name => 'Foreign Lang Proficiency Pay',
3843: p_input_value_name => 'Certification Date',
3844: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3845: p_date_effective => p_pa_request_rec.effective_date,
3846: p_screen_entry_value => p_foreign_lang_prof_pay.certification_date
3847: );
3848: end if;
3849: if p_foreign_lang_prof_pay.pay_level_or_rate is null then
3850: ghr_history_fetch.fetch_element_entry_value
3851: (p_element_name => 'Foreign Lang Proficiency Pay',
3852: p_input_value_name => 'Pay Level or Rate',
3853: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3854: p_date_effective => p_pa_request_rec.effective_date,
3900: p_edp_pay.edp_flag := 'Y';
3901: end if;
3902: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3903: if p_edp_pay.premium_pay_indicator is null then
3904: ghr_history_fetch.fetch_element_entry_value
3905: (p_element_name => 'EDP Pay',
3906: p_input_value_name => 'Premium Pay Ind',
3907: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3908: p_date_effective => p_pa_request_rec.effective_date,
3909: p_screen_entry_value => p_edp_pay.premium_pay_indicator
3910: );
3911: end if;
3912: if p_edp_pay.edp_type is null then
3913: ghr_history_fetch.fetch_element_entry_value
3914: (p_element_name => 'EDP Pay',
3915: p_input_value_name => 'EDP Type',
3916: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3917: p_date_effective => p_pa_request_rec.effective_date,
3938: p_hazard_pay.hazard_flag := 'Y';
3939: end if;
3940: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3941: if p_hazard_pay.premium_pay_indicator is null then
3942: ghr_history_fetch.fetch_element_entry_value
3943: (p_element_name => 'Hazard Pay',
3944: p_input_value_name => 'Premium Pay Ind',
3945: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3946: p_date_effective => p_pa_request_rec.effective_date,
3947: p_screen_entry_value => p_hazard_pay.premium_pay_indicator
3948: );
3949: end if;
3950: if p_hazard_pay.hazard_type is null then
3951: ghr_history_fetch.fetch_element_entry_value
3952: (p_element_name => 'Hazard Pay',
3953: p_input_value_name => 'Hazard Type',
3954: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3955: p_date_effective => p_pa_request_rec.effective_date,
3980: p_health_benefits.health_benefits_flag := 'Y';
3981: end if;
3982: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3983: if p_health_benefits.enrollment is null then
3984: ghr_history_fetch.fetch_element_entry_value
3985: (p_element_name => 'Health Benefits',
3986: p_input_value_name => 'Enrollment',
3987: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3988: p_date_effective => p_pa_request_rec.effective_date,
3989: p_screen_entry_value => p_health_benefits.enrollment
3990: );
3991: end if;
3992: if p_health_benefits.health_plan is null then
3993: ghr_history_fetch.fetch_element_entry_value
3994: (p_element_name => 'Health Benefits',
3995: p_input_value_name => 'Health Plan',
3996: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3997: p_date_effective => p_pa_request_rec.effective_date,
3998: p_screen_entry_value => p_health_benefits.health_plan
3999: );
4000: end if;
4001: if p_health_benefits.temps_total_cost is null then
4002: ghr_history_fetch.fetch_element_entry_value
4003: (p_element_name => 'Health Benefits',
4004: p_input_value_name => 'Temps Total Cost',
4005: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4006: p_date_effective => p_pa_request_rec.effective_date,
4007: p_screen_entry_value => p_health_benefits.temps_total_cost
4008: );
4009: end if;
4010: if p_health_benefits.pre_tax_waiver is null then
4011: ghr_history_fetch.fetch_element_entry_value
4012: (p_element_name => 'Health Benefits',
4013: p_input_value_name => 'Pre tax Waiver',
4014: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4015: p_date_effective => p_pa_request_rec.effective_date,
4038: p_health_ben_pre_tax.health_ben_pre_tax_flag := 'Y';
4039: end if;
4040: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4041: if p_health_ben_pre_tax.enrollment is null then
4042: ghr_history_fetch.fetch_element_entry_value
4043: (p_element_name => 'Health Benefits Pre tax',
4044: p_input_value_name => 'Enrollment',
4045: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4046: p_date_effective => p_pa_request_rec.effective_date,
4047: p_screen_entry_value => p_health_ben_pre_tax.enrollment
4048: );
4049: end if;
4050: if p_health_ben_pre_tax.health_plan is null then
4051: ghr_history_fetch.fetch_element_entry_value
4052: (p_element_name => 'Health Benefits Pre tax',
4053: p_input_value_name => 'Health Plan',
4054: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4055: p_date_effective => p_pa_request_rec.effective_date,
4056: p_screen_entry_value => p_health_ben_pre_tax.health_plan
4057: );
4058: end if;
4059: if p_health_ben_pre_tax.temps_total_cost is null then
4060: ghr_history_fetch.fetch_element_entry_value
4061: (p_element_name => 'Health Benefits Pre Tax',
4062: p_input_value_name => 'Temps Total Cost',
4063: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4064: p_date_effective => p_pa_request_rec.effective_date,
4084: p_danger_pay.danger_flag := 'Y';
4085: end if;
4086: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4087: if p_danger_pay.last_action_code is null then
4088: ghr_history_fetch.fetch_element_entry_value
4089: (p_element_name => 'Danger Pay',
4090: p_input_value_name => 'Last Action Code',
4091: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4092: p_date_effective => p_pa_request_rec.effective_date,
4093: p_screen_entry_value => p_danger_pay.last_action_code
4094: );
4095: end if;
4096: if p_danger_pay.location is null then
4097: ghr_history_fetch.fetch_element_entry_value
4098: (p_element_name => 'Danger Pay',
4099: p_input_value_name => 'Location',
4100: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4101: p_date_effective => p_pa_request_rec.effective_date,
4124: p_imminent_danger_pay.imminent_danger_flag := 'Y';
4125: end if;
4126: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4127: if p_imminent_danger_pay.amount is null then
4128: ghr_history_fetch.fetch_element_entry_value
4129: (p_element_name => 'Imminent Danger Pay',
4130: p_input_value_name => 'Amount',
4131: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4132: p_date_effective => p_pa_request_rec.effective_date,
4133: p_screen_entry_value => p_imminent_danger_pay.amount
4134: );
4135: end if;
4136: if p_imminent_danger_pay.last_action_code is null then
4137: ghr_history_fetch.fetch_element_entry_value
4138: (p_element_name => 'Imminent Danger Pay',
4139: p_input_value_name => 'Last Action Code',
4140: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4141: p_date_effective => p_pa_request_rec.effective_date,
4142: p_screen_entry_value => p_imminent_danger_pay.last_action_code
4143: );
4144: end if;
4145: if p_imminent_danger_pay.location is null then
4146: ghr_history_fetch.fetch_element_entry_value
4147: (p_element_name => 'Imminent Danger Pay',
4148: p_input_value_name => 'Location',
4149: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4150: p_date_effective => p_pa_request_rec.effective_date,
4193: end if;
4194:
4195: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4196: if p_living_quarters_allow.purchase_amount is null then
4197: ghr_history_fetch.fetch_element_entry_value
4198: (p_element_name => 'Living Quarters Allowance',
4199: p_input_value_name => 'Purchase Amount',
4200: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4201: p_date_effective => p_pa_request_rec.effective_date,
4202: p_screen_entry_value => p_living_quarters_allow.purchase_amount
4203: );
4204: end if;
4205: if p_living_quarters_allow.purchase_date is null then
4206: ghr_history_fetch.fetch_element_entry_value
4207: (p_element_name => 'Living Quarters Allowance',
4208: p_input_value_name => 'Purchase Date',
4209: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4210: p_date_effective => p_pa_request_rec.effective_date,
4211: p_screen_entry_value => p_living_quarters_allow.purchase_date
4212: );
4213: end if;
4214: if p_living_quarters_allow.rent_amount is null then
4215: ghr_history_fetch.fetch_element_entry_value
4216: (p_element_name => 'Living Quarters Allowance',
4217: p_input_value_name => 'Rent Amount',
4218: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4219: p_date_effective => p_pa_request_rec.effective_date,
4220: p_screen_entry_value => p_living_quarters_allow.rent_amount
4221: );
4222: end if;
4223: if p_living_quarters_allow.utility_amount is null then
4224: ghr_history_fetch.fetch_element_entry_value
4225: (p_element_name => 'Living Quarters Allowance',
4226: p_input_value_name => 'Utility Amount',
4227: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4228: p_date_effective => p_pa_request_rec.effective_date,
4229: p_screen_entry_value => p_living_quarters_allow.utility_amount
4230: );
4231: end if;
4232: if p_living_quarters_allow.last_action_code is null then
4233: ghr_history_fetch.fetch_element_entry_value
4234: (p_element_name => 'Living Quarters Allowance',
4235: p_input_value_name => 'Last Action Code',
4236: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4237: p_date_effective => p_pa_request_rec.effective_date,
4238: p_screen_entry_value => p_living_quarters_allow.last_action_code
4239: );
4240: end if;
4241: if p_living_quarters_allow.location is null then
4242: ghr_history_fetch.fetch_element_entry_value
4243: (p_element_name => 'Living Quarters Allowance',
4244: p_input_value_name => 'Location',
4245: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4246: p_date_effective => p_pa_request_rec.effective_date,
4247: p_screen_entry_value => p_living_quarters_allow.location
4248: );
4249: end if;
4250: if p_living_quarters_allow.quarters_type is null then
4251: ghr_history_fetch.fetch_element_entry_value
4252: (p_element_name => 'Living Quarters Allowance',
4253: p_input_value_name => 'Quarters Type',
4254: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4255: p_date_effective => p_pa_request_rec.effective_date,
4256: p_screen_entry_value => p_living_quarters_allow.quarters_type
4257: );
4258: end if;
4259: if p_living_quarters_allow.shared_percent is null then
4260: ghr_history_fetch.fetch_element_entry_value
4261: (p_element_name => 'Living Quarters Allowance',
4262: p_input_value_name => 'Shared Percent',
4263: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4264: p_date_effective => p_pa_request_rec.effective_date,
4265: p_screen_entry_value => p_living_quarters_allow.shared_percent
4266: );
4267: end if;
4268: if p_living_quarters_allow.no_of_family_members is null then
4269: ghr_history_fetch.fetch_element_entry_value
4270: (p_element_name => 'Living Quarters Allowance',
4271: p_input_value_name => 'No. Family Members',
4272: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4273: p_date_effective => p_pa_request_rec.effective_date,
4274: p_screen_entry_value => p_living_quarters_allow.no_of_family_members
4275: );
4276: end if;
4277: if p_living_quarters_allow.summer_record_ind is null then
4278: ghr_history_fetch.fetch_element_entry_value
4279: (p_element_name => 'Living Quarters Allowance',
4280: p_input_value_name => 'Summer Record Ind',
4281: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4282: p_date_effective => p_pa_request_rec.effective_date,
4283: p_screen_entry_value => p_living_quarters_allow.summer_record_ind
4284: );
4285: end if;
4286: if p_living_quarters_allow.quarters_group is null then
4287: ghr_history_fetch.fetch_element_entry_value
4288: (p_element_name => 'Living Quarters Allowance',
4289: p_input_value_name => 'Quarters Group',
4290: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4291: p_date_effective => p_pa_request_rec.effective_date,
4292: p_screen_entry_value => p_living_quarters_allow.quarters_group
4293: );
4294: end if;
4295: if p_living_quarters_allow.currency is null then
4296: ghr_history_fetch.fetch_element_entry_value
4297: (p_element_name => 'Living Quarters Allowance',
4298: p_input_value_name => 'Currency',
4299: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4300: p_date_effective => p_pa_request_rec.effective_date,
4327: p_post_diff_amt.post_diff_amt_flag := 'Y';
4328: end if;
4329: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4330: if p_post_diff_amt.amount is null then
4331: ghr_history_fetch.fetch_element_entry_value
4332: -- (p_element_name => 'Post Differential Amount', -- Bug 2645878 Renamed element
4333: (p_element_name => 'Post Allowance',
4334: p_input_value_name => 'Amount',
4335: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4337: p_screen_entry_value => p_post_diff_amt.amount
4338: );
4339: end if;
4340: if p_post_diff_amt.last_action_code is null then
4341: ghr_history_fetch.fetch_element_entry_value
4342: -- (p_element_name => 'Post Differential Amount', -- Bug 2645878 Renamed element
4343: (p_element_name => 'Post Allowance',
4344: p_input_value_name => 'Last Action Code',
4345: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4347: p_screen_entry_value => p_post_diff_amt.last_action_code
4348: );
4349: end if;
4350: if p_post_diff_amt.location is null then
4351: ghr_history_fetch.fetch_element_entry_value
4352: -- (p_element_name => 'Post Differential Amount', -- Bug 2645878 Renamed element
4353: (p_element_name => 'Post Allowance',
4354: p_input_value_name => 'Location',
4355: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4357: p_screen_entry_value => p_post_diff_amt.location
4358: );
4359: end if;
4360: if p_post_diff_amt.no_of_family_members is null then
4361: ghr_history_fetch.fetch_element_entry_value
4362: -- (p_element_name => 'Post Differential Amount', -- Bug 2645878 Renamed element
4363: (p_element_name => 'Post Allowance',
4364: p_input_value_name => 'No. Family Members',
4365: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4389: p_post_diff_percent.post_diff_percent_flag := 'Y';
4390: end if;
4391: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4392: if p_post_diff_percent.percent is null then
4393: ghr_history_fetch.fetch_element_entry_value
4394: -- (p_element_name => 'Post Differential Percent', -- Bug 2645878 Renamed element
4395: (p_element_name => 'Post Differential',
4396: p_input_value_name => 'Percentage',
4397: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4399: p_screen_entry_value => p_post_diff_percent.percent
4400: );
4401: end if;
4402: if p_post_diff_percent.last_action_code is null then
4403: ghr_history_fetch.fetch_element_entry_value
4404: -- (p_element_name => 'Post Differential Percent', -- Bug 2645878 Renamed element
4405: (p_element_name => 'Post Differential',
4406: p_input_value_name => 'Last Action Code',
4407: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4409: p_screen_entry_value => p_post_diff_percent.last_action_code
4410: );
4411: end if;
4412: if p_post_diff_percent.location is null then
4413: ghr_history_fetch.fetch_element_entry_value
4414: -- (p_element_name => 'Post Differential Percent', -- Bug 2645878 Renamed element
4415: (p_element_name => 'Post Differential',
4416: p_input_value_name => 'Location',
4417: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4442: p_sep_maintenance_allow.sep_maint_allow_flag := 'Y';
4443: end if;
4444: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4445: if p_sep_maintenance_allow.amount is null then
4446: ghr_history_fetch.fetch_element_entry_value
4447: (p_element_name => 'Separate Maintenance Allowance',
4448: p_input_value_name => 'Amount',
4449: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4450: p_date_effective => p_pa_request_rec.effective_date,
4451: p_screen_entry_value => p_sep_maintenance_allow.amount
4452: );
4453: end if;
4454: if p_sep_maintenance_allow.last_action_code is null then
4455: ghr_history_fetch.fetch_element_entry_value
4456: (p_element_name => 'Separate Maintenance Allowance',
4457: p_input_value_name => 'Last Action Code',
4458: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4459: p_date_effective => p_pa_request_rec.effective_date,
4460: p_screen_entry_value => p_sep_maintenance_allow.last_action_code
4461: );
4462: end if;
4463: if p_sep_maintenance_allow.category is null then
4464: ghr_history_fetch.fetch_element_entry_value
4465: (p_element_name => 'Separate Maintenance Allowance',
4466: p_input_value_name => 'Category',
4467: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4468: p_date_effective => p_pa_request_rec.effective_date,
4488: p_supplemental_post_allow.sup_post_allow_flag := 'Y';
4489: end if;
4490: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4491: if p_supplemental_post_allow.amount is null then
4492: ghr_history_fetch.fetch_element_entry_value
4493: (p_element_name => 'Supplemental Post Allowance',
4494: p_input_value_name => 'Amount',
4495: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4496: p_date_effective => p_pa_request_rec.effective_date,
4517: p_temp_lodge_allow.temp_lodge_allow_flag := 'Y';
4518: end if;
4519: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4520: if p_temp_lodge_allow.allowance_type is null then
4521: ghr_history_fetch.fetch_element_entry_value
4522: (p_element_name => 'Temporary Lodging Allowance',
4523: p_input_value_name => 'Allowance Type',
4524: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4525: p_date_effective => p_pa_request_rec.effective_date,
4526: p_screen_entry_value => p_temp_lodge_allow.allowance_type
4527: );
4528: end if;
4529: if p_temp_lodge_allow.daily_rate is null then
4530: ghr_history_fetch.fetch_element_entry_value
4531: (p_element_name => 'Temporary Lodging Allowance',
4532: p_input_value_name => 'Daily Rate',
4533: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4534: p_date_effective => p_pa_request_rec.effective_date,
4555: p_premium_pay.premium_pay_flag := 'Y';
4556: end if;
4557: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4558: if p_premium_pay.premium_pay_ind is null then
4559: ghr_history_fetch.fetch_element_entry_value
4560: (p_element_name => 'Premium Pay',
4561: p_input_value_name => 'Premium Pay Ind',
4562: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4563: p_date_effective => p_pa_request_rec.effective_date,
4564: p_screen_entry_value => p_premium_pay.premium_pay_ind
4565: );
4566: end if;
4567: if p_premium_pay.amount is null then
4568: ghr_history_fetch.fetch_element_entry_value
4569: (p_element_name => 'Premium Pay',
4570: p_input_value_name => 'Amount',
4571: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4572: p_date_effective => p_pa_request_rec.effective_date,
4593: p_retirement_annuity.retirement_annuity_flag := 'Y';
4594: end if;
4595: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4596: if p_retirement_annuity.annuity_sum is null then
4597: ghr_history_fetch.fetch_element_entry_value
4598: (p_element_name => 'Retirement Annuity',
4599: p_input_value_name => 'Sum',
4600: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4601: p_date_effective => p_pa_request_rec.effective_date,
4602: p_screen_entry_value => p_retirement_annuity.annuity_sum
4603: );
4604: end if;
4605: if p_retirement_annuity.eligibility_expires is null then
4606: ghr_history_fetch.fetch_element_entry_value
4607: (p_element_name => 'Retirement Annuity',
4608: p_input_value_name => 'Eligibility Expires',
4609: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4610: p_date_effective => p_pa_request_rec.effective_date,
4635: p_severance_pay.severance_pay_flag := 'Y';
4636: end if;
4637: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4638: if p_severance_pay.amount is null then
4639: ghr_history_fetch.fetch_element_entry_value
4640: (p_element_name => 'Severance Pay',
4641: p_input_value_name => 'Amount',
4642: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4643: p_date_effective => p_pa_request_rec.effective_date,
4644: p_screen_entry_value => p_severance_pay.amount
4645: );
4646: end if;
4647: if p_severance_pay.total_entitlement_weeks is null then
4648: ghr_history_fetch.fetch_element_entry_value
4649: (p_element_name => 'Severance Pay',
4650: p_input_value_name => 'Total Entitlement Weeks',
4651: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4652: p_date_effective => p_pa_request_rec.effective_date,
4653: p_screen_entry_value => p_severance_pay.total_entitlement_weeks
4654: );
4655: end if;
4656: if p_severance_pay.number_weeks_paid is null then
4657: ghr_history_fetch.fetch_element_entry_value
4658: (p_element_name => 'Severance Pay',
4659: p_input_value_name => 'Number Weeks Paid',
4660: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4661: p_date_effective => p_pa_request_rec.effective_date,
4662: p_screen_entry_value => p_severance_pay.number_weeks_paid
4663: );
4664: end if;
4665: if p_severance_pay.weekly_amount is null then
4666: ghr_history_fetch.fetch_element_entry_value
4667: (p_element_name => 'Severance Pay',
4668: p_input_value_name => 'Weekly Amount',
4669: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4670: p_date_effective => p_pa_request_rec.effective_date,
4710: p_per_scd_info.per_scd_info_flag, 'Y');
4711:
4712: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4713: if p_thrift_saving_plan.amount is null then
4714: ghr_history_fetch.fetch_element_entry_value
4715: (p_element_name => 'TSP',
4716: p_input_value_name => 'Amount',
4717: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4718: p_date_effective => p_pa_request_rec.effective_date,
4719: p_screen_entry_value => p_thrift_saving_plan.amount
4720: );
4721: end if;
4722: if p_thrift_saving_plan.rate is null then
4723: ghr_history_fetch.fetch_element_entry_value
4724: (p_element_name => 'TSP',
4725: p_input_value_name => 'Rate',
4726: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4727: p_date_effective => p_pa_request_rec.effective_date,
4728: p_screen_entry_value => p_thrift_saving_plan.rate
4729: );
4730: end if;
4731: if p_thrift_saving_plan.g_fund is null then
4732: ghr_history_fetch.fetch_element_entry_value
4733: (p_element_name => 'TSP',
4734: p_input_value_name => 'G Fund',
4735: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4736: p_date_effective => p_pa_request_rec.effective_date,
4737: p_screen_entry_value => p_thrift_saving_plan.g_fund
4738: );
4739: end if;
4740: if p_thrift_saving_plan.f_fund is null then
4741: ghr_history_fetch.fetch_element_entry_value
4742: (p_element_name => 'TSP',
4743: p_input_value_name => 'F Fund',
4744: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4745: p_date_effective => p_pa_request_rec.effective_date,
4746: p_screen_entry_value => p_thrift_saving_plan.f_fund
4747: );
4748: end if;
4749: if p_thrift_saving_plan.c_fund is null then
4750: ghr_history_fetch.fetch_element_entry_value
4751: (p_element_name => 'TSP',
4752: p_input_value_name => 'C Fund',
4753: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4754: p_date_effective => p_pa_request_rec.effective_date,
4755: p_screen_entry_value => p_thrift_saving_plan.c_fund
4756: );
4757: end if;
4758: if p_thrift_saving_plan.status is null then
4759: ghr_history_fetch.fetch_element_entry_value
4760: (p_element_name => 'TSP',
4761: p_input_value_name => 'Status',
4762: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4763: p_date_effective => p_pa_request_rec.effective_date,
4764: p_screen_entry_value => p_thrift_saving_plan.status
4765: );
4766: end if;
4767: if p_thrift_saving_plan.status_date is null then
4768: ghr_history_fetch.fetch_element_entry_value
4769: (p_element_name => 'TSP',
4770: p_input_value_name => 'Status Date',
4771: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4772: p_date_effective => p_pa_request_rec.effective_date,
4773: p_screen_entry_value => p_thrift_saving_plan.status_date
4774: );
4775: end if;
4776: if p_thrift_saving_plan.agncy_contrib_elig_date is null then
4777: ghr_history_fetch.fetch_element_entry_value
4778: (p_element_name => 'TSP',
4779: p_input_value_name => 'Agncy Contrib Elig Date',
4780: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4781: p_date_effective => p_pa_request_rec.effective_date,
4782: p_screen_entry_value => p_thrift_saving_plan.agncy_contrib_elig_date
4783: );
4784: end if;
4785: if p_thrift_saving_plan.emp_contrib_elig_date is null then
4786: ghr_history_fetch.fetch_element_entry_value
4787: (p_element_name => 'TSP',
4788: p_input_value_name => 'Emp Contrib Elig Date',
4789: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4790: p_date_effective => p_pa_request_rec.effective_date,
5166: -- l_pos_org := p_pos_grp1.positions_organization;
5167: -- Get Element Entry Values in case of 'CORRECTION' -- only those elements that come off an extra_info
5168:
5169: If l_session.noa_id_correct is not null then
5170: ghr_history_fetch.fetch_element_entry_value
5171: (p_element_name => 'Within Grade Increase',
5172: p_input_value_name => 'Date Due',
5173: p_assignment_id => p_pa_request_rec.employee_assignment_id,
5174: p_date_effective => p_pa_request_rec.effective_date,
5173: p_assignment_id => p_pa_request_rec.employee_assignment_id,
5174: p_date_effective => p_pa_request_rec.effective_date,
5175: p_screen_entry_value => p_within_grade_increase.p_date_wgi_due
5176: );
5177: ghr_history_fetch.fetch_element_entry_value
5178: (p_element_name => 'Within Grade Increase',
5179: p_input_value_name => 'Pay Date',
5180: p_assignment_id => p_pa_request_rec.employee_assignment_id,
5181: p_date_effective => p_pa_request_rec.effective_date,
5180: p_assignment_id => p_pa_request_rec.employee_assignment_id,
5181: p_date_effective => p_pa_request_rec.effective_date,
5182: p_screen_entry_value => p_within_grade_increase.p_wgi_pay_date
5183: );
5184: ghr_history_fetch.fetch_element_entry_value
5185: (p_element_name => 'Within Grade Increase',
5186: p_input_value_name => 'Postponmt Effective',
5187: p_assignment_id => p_pa_request_rec.employee_assignment_id,
5188: p_date_effective => p_pa_request_rec.effective_date,
5187: p_assignment_id => p_pa_request_rec.employee_assignment_id,
5188: p_date_effective => p_pa_request_rec.effective_date,
5189: p_screen_entry_value => p_within_grade_increase.p_date_wgi_postpone_effective
5190: );
5191: ghr_history_fetch.fetch_element_entry_value
5192: (p_element_name => 'Within Grade Increase',
5193: p_input_value_name => 'Last Equivalent Increase',
5194: p_assignment_id => p_pa_request_rec.employee_assignment_id,
5195: p_date_effective => p_pa_request_rec.effective_date,
5197: );
5198: -- The foll. if conditions ensure that we fetch the elements only
5199: -- on correction to a noa relevant to the specific elements
5200: If p_pa_request_rec.first_noa_code = '816' then
5201: ghr_history_fetch.fetch_element_entry_value
5202: (p_element_name => 'Relocation Bonus',
5203: p_input_value_name => 'Expiration Date',
5204: p_assignment_id => p_pa_request_rec.employee_assignment_id,
5205: p_date_effective => p_pa_request_rec.effective_date,
5206: p_screen_entry_value => p_relocation_bonus.p_date_reloc_exp
5207: );
5208: End if;
5209: If p_pa_request_rec.first_noa_code = '815' then
5210: ghr_history_fetch.fetch_element_entry_value
5211: (p_element_name => 'Recruitment Bonus',
5212: p_input_value_name => 'Expiration Date',
5213: p_assignment_id => p_pa_request_rec.employee_assignment_id,
5214: p_date_effective => p_pa_request_rec.effective_date,
5700: --End Bug# 6083404
5701: IF l_user_apnt_status = 'Temp. Appointment NTE'
5702: and nvl(l_user_actv_apnt_status,'XXX') <>'Active Appointment' THEN
5703: --Bug# 6083404 added l_user_actv_apnt_status condition
5704: ghr_history_fetch.fetch_asgei
5705: (p_assignment_id => p_pa_request_rec.employee_assignment_id,
5706: p_information_type => 'GHR_US_ASG_NTE_DATES',
5707: p_date_effective => l_user_apnt_eff_date,
5708: p_asg_ei_data => l_asg_extra_info_rec
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,
5790: p_pos_ei_data => l_pos_extra_info_rec