[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;
405:
406: If p_pa_request_rec.from_position_id is not null then
407:
408: ghr_history_api.get_g_session_var(l_session);
409: Ghr_History_Fetch.Fetch_ASGEI_prior_root_sf50
410: (
411: p_assignment_id => p_pa_request_rec.employee_assignment_id,
412: p_information_type => 'GHR_US_ASG_SF52',
413: p_date_effective => p_pa_request_rec.effective_date,
438: l_effective_date := p_pa_request_rec.effective_date;
439: End if;
440: hr_utility.set_location('l_effective_date passed to fetch_assignment '||l_effective_date,3 );
441:
442: Ghr_History_Fetch.Fetch_assignment
443: (
444: p_assignment_id => p_pa_request_rec.employee_assignment_id,
445: p_date_effective => l_effective_date,
446: p_altered_pa_request_id => l_session.altered_pa_request_id,
516: );
517:
518: Else -- for update get from history
519: hr_utility.set_location('populate_record_groups ', 35);
520: ghr_history_fetch.return_special_information
521: (p_person_id => p_pa_request_rec.person_id,
522: p_structure_name => 'US Fed Perf Appraisal',
523: p_effective_date => p_pa_request_rec.effective_date,
524: p_special_info => l_special_info_type
925: hr_utility.set_location(' Date ' || to_Char(p_pa_request_rec.effective_date),2);
926:
927: -- Retrieve asg_sf52
928:
929: ghr_history_fetch.fetch_asgei
930: (p_assignment_id => p_pa_request_rec.employee_assignment_id,
931: p_information_type => 'GHR_US_ASG_SF52',
932: p_date_effective => p_pa_request_rec.effective_date,
933: p_asg_ei_data => l_asg_extra_info_rec
954:
955:
956: -- Retrieve asg_non_sf52
957:
958: ghr_history_fetch.fetch_asgei
959: (p_assignment_id => p_pa_request_rec.employee_assignment_id,
960: p_information_type => 'GHR_US_ASG_NON_SF52',
961: p_date_effective => p_pa_request_rec.effective_date,
962: p_asg_ei_data => l_asg_extra_info_rec
979: l_asg_extra_info_rec := null;
980:
981: -- Retrieve asg_nte_dates
982:
983: ghr_history_fetch.fetch_asgei
984: (p_assignment_id => p_pa_request_rec.employee_assignment_id,
985: p_information_type => 'GHR_US_ASG_NTE_DATES',
986: p_date_effective => p_pa_request_rec.effective_date,
987: p_asg_ei_data => l_asg_extra_info_rec
1012: END IF;
1013:
1014: -- Retrieve PER SF52
1015:
1016: ghr_history_fetch.fetch_peopleei
1017: (p_person_id => p_pa_request_rec.person_id,
1018: p_information_type => 'GHR_US_PER_SF52',
1019: p_date_effective => p_pa_request_rec.effective_date,
1020: p_per_ei_data => l_per_extra_info_rec
1032: l_per_extra_info_rec := null;
1033:
1034: -- Retrieve Per_Group1
1035:
1036: ghr_history_fetch.fetch_peopleei
1037: (p_person_id => p_pa_request_rec.person_id,
1038: p_information_type => 'GHR_US_PER_GROUP1',
1039: p_date_effective => p_pa_request_rec.effective_date,
1040: p_per_ei_data => l_per_extra_info_rec
1071: --
1072:
1073: -- Retrieve Per_scd `
1074:
1075: ghr_history_fetch.fetch_peopleei
1076: (p_person_id => p_pa_request_rec.person_id,
1077: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
1078: p_date_effective => p_pa_request_rec.effective_date,
1079: p_per_ei_data => l_per_extra_info_rec
1097: l_per_extra_info_rec := null;
1098:
1099: -- Retrieve per_probations
1100:
1101: ghr_history_fetch.fetch_peopleei
1102: (p_person_id => p_pa_request_rec.person_id,
1103: p_information_type => 'GHR_US_PER_PROBATIONS',
1104: p_date_effective => p_pa_request_rec.effective_date,
1105: p_per_ei_data => l_per_extra_info_rec
1199: hr_utility.set_location('p_per_separate_retire.agency_code_transfer_to = ' ||
1200: p_per_separate_retire.agency_code_transfer_to ,13);
1201: hr_utility.set_location('l_per_extra_info_rec.pei_information8 = ' ||
1202: l_per_extra_info_rec.pei_information8 ,13);
1203: ghr_history_fetch.fetch_peopleei
1204: (p_person_id => p_pa_request_rec.person_id,
1205: p_information_type => 'GHR_US_PER_SEPARATE_RETIRE',
1206: p_date_effective => p_pa_request_rec.effective_date,
1207: p_per_ei_data => l_per_extra_info_rec
1243:
1244: -- Bug#4486823 RRR Changes
1245: -- Retrieve per_service_obligation
1246:
1247: /* ghr_history_fetch.fetch_peopleei
1248: (p_person_id => p_pa_request_rec.person_id,
1249: p_information_type => 'GHR_US_PER_SERVICE_OBLIGATION',
1250: p_date_effective => p_pa_request_rec.effective_date,
1251: p_per_ei_data => l_per_extra_info_rec
1264: hr_utility.set_location('retrieved per serv oblg ',15); */
1265:
1266: -- Retrieve per_uniformed_services
1267:
1268: ghr_history_fetch.fetch_peopleei
1269: (p_person_id => p_pa_request_rec.person_id,
1270: p_information_type => 'GHR_US_PER_UNIFORMED_SERVICES',
1271: p_date_effective => p_pa_request_rec.effective_date,
1272: p_per_ei_data => l_per_extra_info_rec
1288:
1289:
1290: -- Retrieve per_conversions
1291:
1292: ghr_history_fetch.fetch_peopleei
1293: (p_person_id => p_pa_request_rec.person_id,
1294: p_information_type => 'GHR_US_PER_CONVERSIONS',
1295: p_date_effective => p_pa_request_rec.effective_date,
1296: p_per_ei_data => l_per_extra_info_rec
1307: l_per_extra_info_rec := null;
1308:
1309: -- 4352589 BEN_EIT Changes
1310: -- Retrieve per_benefit_info
1311: ghr_history_fetch.fetch_peopleei
1312: (p_person_id => p_pa_request_rec.person_id,
1313: p_information_type => 'GHR_US_PER_BENEFIT_INFO',
1314: p_date_effective => p_pa_request_rec.effective_date,
1315: p_per_ei_data => l_per_extra_info_rec
1339:
1340:
1341: -- Bug 4724337 Race or National Origin changes
1342: l_per_extra_info_rec := null;
1343: ghr_history_fetch.fetch_peopleei
1344: (p_person_id => p_pa_request_rec.person_id,
1345: p_information_type => 'GHR_US_PER_ETHNICITY_RACE',
1346: p_date_effective => p_pa_request_rec.effective_date,
1347: p_per_ei_data => l_per_extra_info_rec
1363: Else
1364: l_position_id := p_pa_request_rec.to_position_id;
1365: End if;
1366:
1367: ghr_history_fetch.fetch_positionei
1368: (p_position_id => l_position_id,
1369: p_information_type => 'GHR_US_POS_VALID_GRADE',
1370: p_date_effective => p_pa_request_rec.effective_date,
1371: p_pos_ei_data => l_pos_extra_info_rec
1388:
1389: -- Retrieve Position group1
1390:
1391:
1392: ghr_history_fetch.fetch_positionei
1393: (p_position_id => l_position_id,
1394: p_information_type => 'GHR_US_POS_GRP1',
1395: p_date_effective => p_pa_request_rec.effective_date,
1396: p_pos_ei_data => l_pos_extra_info_rec
1432: l_pos_extra_info_rec := null;
1433:
1434: -- Retrieve Position Group2
1435:
1436: ghr_history_fetch.fetch_positionei
1437: (p_position_id => l_position_id,
1438: p_information_type => 'GHR_US_POS_GRP2',
1439: p_date_effective => p_pa_request_rec.effective_date,
1440: p_pos_ei_data => l_pos_extra_info_rec
1467: l_pos_extra_info_rec := null;
1468:
1469: -- Retrieve Position Obligation
1470:
1471: ghr_history_fetch.fetch_positionei
1472: (p_position_id => l_position_id,
1473: p_information_type => 'GHR_US_POS_OBLIG',
1474: p_date_effective => p_pa_request_rec.effective_date,
1475: p_pos_ei_data => l_pos_extra_info_rec
1489: -- Bug 6312144 IPA Benefits Continuation EIT changes
1490:
1491: hr_utility.set_location('Before retrieving IPA Benefits Continuation',19);
1492: l_per_extra_info_rec := null;
1493: ghr_history_fetch.fetch_peopleei
1494: (p_person_id => p_pa_request_rec.person_id,
1495: p_information_type => 'GHR_US_PER_BENEFITS_CONT',
1496: p_date_effective => p_pa_request_rec.effective_date,
1497: p_per_ei_data => l_per_extra_info_rec
1518:
1519: hr_utility.set_location('Before retrieving Retirement System Information',21);
1520: -- Bug 6312144 Retirement System Information EIT changes
1521: l_per_extra_info_rec := null;
1522: ghr_history_fetch.fetch_peopleei
1523: (p_person_id => p_pa_request_rec.person_id,
1524: p_information_type => 'GHR_US_PER_RETIRMENT_SYS_INFO',
1525: p_date_effective => p_pa_request_rec.effective_date,
1526: p_per_ei_data => l_per_extra_info_rec
2544: p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2545: --Added by deenath to fix bug 4542401.
2546: IF (p_pa_request_rec.first_noa_code IN ('781','782') OR
2547: p_pa_request_rec.second_noa_code IN ('781','782')) THEN
2548: ghr_history_fetch.fetch_element_entry_value
2549: (p_element_name => 'Within Grade Increase',
2550: p_input_value_name => 'Last Equivalent Increase',
2551: p_assignment_id => p_pa_request_rec.employee_assignment_id,
2552: p_date_effective => p_pa_request_rec.effective_date,
3023: p_gov_awards.award_flag := 'Y';
3024:
3025: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3026: if p_gov_awards.award_agency is null then
3027: ghr_history_fetch.fetch_element_entry_value
3028: (p_element_name => 'Federal Awards',
3029: p_input_value_name => 'Award Agency',
3030: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3031: p_date_effective => p_pa_request_rec.effective_date,
3032: p_screen_entry_value => p_gov_awards.award_agency
3033: );
3034: end if;
3035: if p_gov_awards.award_type is null then
3036: ghr_history_fetch.fetch_element_entry_value
3037: (p_element_name => 'Federal Awards',
3038: p_input_value_name => 'Award Type',
3039: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3040: p_date_effective => p_pa_request_rec.effective_date,
3041: p_screen_entry_value => p_gov_awards.award_type
3042: );
3043: end if;
3044: if p_gov_awards.group_award is null then
3045: ghr_history_fetch.fetch_element_entry_value
3046: (p_element_name => 'Federal Awards',
3047: p_input_value_name => 'Group Award',
3048: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3049: p_date_effective => p_pa_request_rec.effective_date,
3050: p_screen_entry_value => p_gov_awards.group_award
3051: );
3052: end if;
3053: if p_gov_awards.tangible_benefit_dollars is null then
3054: ghr_history_fetch.fetch_element_entry_value
3055: (p_element_name => 'Federal Awards',
3056: p_input_value_name => 'Tangible Benefit Dollars',
3057: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3058: p_date_effective => p_pa_request_rec.effective_date,
3059: p_screen_entry_value => p_gov_awards.tangible_benefit_dollars
3060: );
3061: end if;
3062: if p_gov_awards.date_award_earned is null then
3063: ghr_history_fetch.fetch_element_entry_value
3064: (p_element_name => 'Federal Awards',
3065: p_input_value_name => 'Date Award Earned',
3066: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3067: p_date_effective => p_pa_request_rec.effective_date,
3068: p_screen_entry_value => p_gov_awards.date_award_earned
3069: );
3070: end if;
3071: if p_gov_awards.award_appropriation_code is null then
3072: ghr_history_fetch.fetch_element_entry_value
3073: (p_element_name => 'Federal Awards',
3074: p_input_value_name => 'Appropriation Code',
3075: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3076: p_date_effective => p_pa_request_rec.effective_date,
3079: end if;
3080: /*
3081: -- Bug 2835929 Allow date_exemp_award to be updated to null.
3082: if p_gov_awards.date_exemp_award is null then
3083: ghr_history_fetch.fetch_element_entry_value
3084: (p_element_name => 'Federal Awards',
3085: p_input_value_name => 'Date Ex Emp Award Paid',
3086: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3087: p_date_effective => p_pa_request_rec.effective_date,
3173:
3174: if l_session.noa_id_correct is not null then
3175: hr_utility.set_location('non_pay_duty_status ', 30);
3176:
3177: ghr_history_fetch.return_special_information
3178: (p_person_id => p_pa_request_rec.person_id,
3179: p_structure_name => 'US Fed Conduct Perf',
3180: p_effective_date => p_pa_request_rec.effective_date,
3181: p_special_info => l_special_info_type
3369: p_entitlement.entitlement_flag := 'Y';
3370: end if;
3371: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3372: if p_entitlement.entitlement_code is null then
3373: ghr_history_fetch.fetch_element_entry_value
3374: (p_element_name => 'Entitlement',
3375: p_input_value_name => 'Code',
3376: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3377: p_date_effective => p_pa_request_rec.effective_date,
3378: p_screen_entry_value => p_entitlement.entitlement_code
3379: );
3380: end if;
3381: if p_entitlement.entitlement_amt_percent is null then
3382: ghr_history_fetch.fetch_element_entry_value
3383: (p_element_name => 'Entitlement',
3384: p_input_value_name => 'Amount or Percent',
3385: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3386: p_date_effective => p_pa_request_rec.effective_date,
3407: p_foreign_lang_prof_pay.for_lang_flag := 'Y';
3408: end if;
3409: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3410: if p_foreign_lang_prof_pay.certification_date is null then
3411: ghr_history_fetch.fetch_element_entry_value
3412: (p_element_name => 'Foreign Lang Proficiency Pay',
3413: p_input_value_name => 'Certification Date',
3414: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3415: p_date_effective => p_pa_request_rec.effective_date,
3416: p_screen_entry_value => p_foreign_lang_prof_pay.certification_date
3417: );
3418: end if;
3419: if p_foreign_lang_prof_pay.pay_level_or_rate is null then
3420: ghr_history_fetch.fetch_element_entry_value
3421: (p_element_name => 'Foreign Lang Proficiency Pay',
3422: p_input_value_name => 'Pay Level or Rate',
3423: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3424: p_date_effective => p_pa_request_rec.effective_date,
3470: p_edp_pay.edp_flag := 'Y';
3471: end if;
3472: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3473: if p_edp_pay.premium_pay_indicator is null then
3474: ghr_history_fetch.fetch_element_entry_value
3475: (p_element_name => 'EDP Pay',
3476: p_input_value_name => 'Premium Pay Ind',
3477: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3478: p_date_effective => p_pa_request_rec.effective_date,
3479: p_screen_entry_value => p_edp_pay.premium_pay_indicator
3480: );
3481: end if;
3482: if p_edp_pay.edp_type is null then
3483: ghr_history_fetch.fetch_element_entry_value
3484: (p_element_name => 'EDP Pay',
3485: p_input_value_name => 'EDP Type',
3486: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3487: p_date_effective => p_pa_request_rec.effective_date,
3508: p_hazard_pay.hazard_flag := 'Y';
3509: end if;
3510: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3511: if p_hazard_pay.premium_pay_indicator is null then
3512: ghr_history_fetch.fetch_element_entry_value
3513: (p_element_name => 'Hazard Pay',
3514: p_input_value_name => 'Premium Pay Ind',
3515: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3516: p_date_effective => p_pa_request_rec.effective_date,
3517: p_screen_entry_value => p_hazard_pay.premium_pay_indicator
3518: );
3519: end if;
3520: if p_hazard_pay.hazard_type is null then
3521: ghr_history_fetch.fetch_element_entry_value
3522: (p_element_name => 'Hazard Pay',
3523: p_input_value_name => 'Hazard Type',
3524: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3525: p_date_effective => p_pa_request_rec.effective_date,
3550: p_health_benefits.health_benefits_flag := 'Y';
3551: end if;
3552: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3553: if p_health_benefits.enrollment is null then
3554: ghr_history_fetch.fetch_element_entry_value
3555: (p_element_name => 'Health Benefits',
3556: p_input_value_name => 'Enrollment',
3557: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3558: p_date_effective => p_pa_request_rec.effective_date,
3559: p_screen_entry_value => p_health_benefits.enrollment
3560: );
3561: end if;
3562: if p_health_benefits.health_plan is null then
3563: ghr_history_fetch.fetch_element_entry_value
3564: (p_element_name => 'Health Benefits',
3565: p_input_value_name => 'Health Plan',
3566: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3567: p_date_effective => p_pa_request_rec.effective_date,
3568: p_screen_entry_value => p_health_benefits.health_plan
3569: );
3570: end if;
3571: if p_health_benefits.temps_total_cost is null then
3572: ghr_history_fetch.fetch_element_entry_value
3573: (p_element_name => 'Health Benefits',
3574: p_input_value_name => 'Temps Total Cost',
3575: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3576: p_date_effective => p_pa_request_rec.effective_date,
3577: p_screen_entry_value => p_health_benefits.temps_total_cost
3578: );
3579: end if;
3580: if p_health_benefits.pre_tax_waiver is null then
3581: ghr_history_fetch.fetch_element_entry_value
3582: (p_element_name => 'Health Benefits',
3583: p_input_value_name => 'Pre tax Waiver',
3584: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3585: p_date_effective => p_pa_request_rec.effective_date,
3608: p_health_ben_pre_tax.health_ben_pre_tax_flag := 'Y';
3609: end if;
3610: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3611: if p_health_ben_pre_tax.enrollment is null then
3612: ghr_history_fetch.fetch_element_entry_value
3613: (p_element_name => 'Health Benefits Pre tax',
3614: p_input_value_name => 'Enrollment',
3615: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3616: p_date_effective => p_pa_request_rec.effective_date,
3617: p_screen_entry_value => p_health_ben_pre_tax.enrollment
3618: );
3619: end if;
3620: if p_health_ben_pre_tax.health_plan is null then
3621: ghr_history_fetch.fetch_element_entry_value
3622: (p_element_name => 'Health Benefits Pre tax',
3623: p_input_value_name => 'Health Plan',
3624: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3625: p_date_effective => p_pa_request_rec.effective_date,
3626: p_screen_entry_value => p_health_ben_pre_tax.health_plan
3627: );
3628: end if;
3629: if p_health_ben_pre_tax.temps_total_cost is null then
3630: ghr_history_fetch.fetch_element_entry_value
3631: (p_element_name => 'Health Benefits Pre Tax',
3632: p_input_value_name => 'Temps Total Cost',
3633: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3634: p_date_effective => p_pa_request_rec.effective_date,
3654: p_danger_pay.danger_flag := 'Y';
3655: end if;
3656: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3657: if p_danger_pay.last_action_code is null then
3658: ghr_history_fetch.fetch_element_entry_value
3659: (p_element_name => 'Danger Pay',
3660: p_input_value_name => 'Last Action Code',
3661: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3662: p_date_effective => p_pa_request_rec.effective_date,
3663: p_screen_entry_value => p_danger_pay.last_action_code
3664: );
3665: end if;
3666: if p_danger_pay.location is null then
3667: ghr_history_fetch.fetch_element_entry_value
3668: (p_element_name => 'Danger Pay',
3669: p_input_value_name => 'Location',
3670: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3671: p_date_effective => p_pa_request_rec.effective_date,
3694: p_imminent_danger_pay.imminent_danger_flag := 'Y';
3695: end if;
3696: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3697: if p_imminent_danger_pay.amount is null then
3698: ghr_history_fetch.fetch_element_entry_value
3699: (p_element_name => 'Imminent Danger Pay',
3700: p_input_value_name => 'Amount',
3701: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3702: p_date_effective => p_pa_request_rec.effective_date,
3703: p_screen_entry_value => p_imminent_danger_pay.amount
3704: );
3705: end if;
3706: if p_imminent_danger_pay.last_action_code is null then
3707: ghr_history_fetch.fetch_element_entry_value
3708: (p_element_name => 'Imminent Danger Pay',
3709: p_input_value_name => 'Last Action Code',
3710: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3711: p_date_effective => p_pa_request_rec.effective_date,
3712: p_screen_entry_value => p_imminent_danger_pay.last_action_code
3713: );
3714: end if;
3715: if p_imminent_danger_pay.location is null then
3716: ghr_history_fetch.fetch_element_entry_value
3717: (p_element_name => 'Imminent Danger Pay',
3718: p_input_value_name => 'Location',
3719: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3720: p_date_effective => p_pa_request_rec.effective_date,
3763: end if;
3764:
3765: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3766: if p_living_quarters_allow.purchase_amount is null then
3767: ghr_history_fetch.fetch_element_entry_value
3768: (p_element_name => 'Living Quarters Allowance',
3769: p_input_value_name => 'Purchase Amount',
3770: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3771: p_date_effective => p_pa_request_rec.effective_date,
3772: p_screen_entry_value => p_living_quarters_allow.purchase_amount
3773: );
3774: end if;
3775: if p_living_quarters_allow.purchase_date is null then
3776: ghr_history_fetch.fetch_element_entry_value
3777: (p_element_name => 'Living Quarters Allowance',
3778: p_input_value_name => 'Purchase Date',
3779: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3780: p_date_effective => p_pa_request_rec.effective_date,
3781: p_screen_entry_value => p_living_quarters_allow.purchase_date
3782: );
3783: end if;
3784: if p_living_quarters_allow.rent_amount is null then
3785: ghr_history_fetch.fetch_element_entry_value
3786: (p_element_name => 'Living Quarters Allowance',
3787: p_input_value_name => 'Rent Amount',
3788: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3789: p_date_effective => p_pa_request_rec.effective_date,
3790: p_screen_entry_value => p_living_quarters_allow.rent_amount
3791: );
3792: end if;
3793: if p_living_quarters_allow.utility_amount is null then
3794: ghr_history_fetch.fetch_element_entry_value
3795: (p_element_name => 'Living Quarters Allowance',
3796: p_input_value_name => 'Utility Amount',
3797: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3798: p_date_effective => p_pa_request_rec.effective_date,
3799: p_screen_entry_value => p_living_quarters_allow.utility_amount
3800: );
3801: end if;
3802: if p_living_quarters_allow.last_action_code is null then
3803: ghr_history_fetch.fetch_element_entry_value
3804: (p_element_name => 'Living Quarters Allowance',
3805: p_input_value_name => 'Last Action 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_living_quarters_allow.last_action_code
3809: );
3810: end if;
3811: if p_living_quarters_allow.location is null then
3812: ghr_history_fetch.fetch_element_entry_value
3813: (p_element_name => 'Living Quarters Allowance',
3814: p_input_value_name => 'Location',
3815: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3816: p_date_effective => p_pa_request_rec.effective_date,
3817: p_screen_entry_value => p_living_quarters_allow.location
3818: );
3819: end if;
3820: if p_living_quarters_allow.quarters_type is null then
3821: ghr_history_fetch.fetch_element_entry_value
3822: (p_element_name => 'Living Quarters Allowance',
3823: p_input_value_name => 'Quarters Type',
3824: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3825: p_date_effective => p_pa_request_rec.effective_date,
3826: p_screen_entry_value => p_living_quarters_allow.quarters_type
3827: );
3828: end if;
3829: if p_living_quarters_allow.shared_percent is null then
3830: ghr_history_fetch.fetch_element_entry_value
3831: (p_element_name => 'Living Quarters Allowance',
3832: p_input_value_name => 'Shared Percent',
3833: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3834: p_date_effective => p_pa_request_rec.effective_date,
3835: p_screen_entry_value => p_living_quarters_allow.shared_percent
3836: );
3837: end if;
3838: if p_living_quarters_allow.no_of_family_members is null then
3839: ghr_history_fetch.fetch_element_entry_value
3840: (p_element_name => 'Living Quarters Allowance',
3841: p_input_value_name => 'No. Family Members',
3842: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3843: p_date_effective => p_pa_request_rec.effective_date,
3844: p_screen_entry_value => p_living_quarters_allow.no_of_family_members
3845: );
3846: end if;
3847: if p_living_quarters_allow.summer_record_ind is null then
3848: ghr_history_fetch.fetch_element_entry_value
3849: (p_element_name => 'Living Quarters Allowance',
3850: p_input_value_name => 'Summer Record Ind',
3851: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3852: p_date_effective => p_pa_request_rec.effective_date,
3853: p_screen_entry_value => p_living_quarters_allow.summer_record_ind
3854: );
3855: end if;
3856: if p_living_quarters_allow.quarters_group is null then
3857: ghr_history_fetch.fetch_element_entry_value
3858: (p_element_name => 'Living Quarters Allowance',
3859: p_input_value_name => 'Quarters Group',
3860: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3861: p_date_effective => p_pa_request_rec.effective_date,
3862: p_screen_entry_value => p_living_quarters_allow.quarters_group
3863: );
3864: end if;
3865: if p_living_quarters_allow.currency is null then
3866: ghr_history_fetch.fetch_element_entry_value
3867: (p_element_name => 'Living Quarters Allowance',
3868: p_input_value_name => 'Currency',
3869: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3870: p_date_effective => p_pa_request_rec.effective_date,
3897: p_post_diff_amt.post_diff_amt_flag := 'Y';
3898: end if;
3899: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3900: if p_post_diff_amt.amount is null then
3901: ghr_history_fetch.fetch_element_entry_value
3902: -- (p_element_name => 'Post Differential Amount', -- Bug 2645878 Renamed element
3903: (p_element_name => 'Post Allowance',
3904: p_input_value_name => 'Amount',
3905: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3907: p_screen_entry_value => p_post_diff_amt.amount
3908: );
3909: end if;
3910: if p_post_diff_amt.last_action_code is null then
3911: ghr_history_fetch.fetch_element_entry_value
3912: -- (p_element_name => 'Post Differential Amount', -- Bug 2645878 Renamed element
3913: (p_element_name => 'Post Allowance',
3914: p_input_value_name => 'Last Action Code',
3915: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3917: p_screen_entry_value => p_post_diff_amt.last_action_code
3918: );
3919: end if;
3920: if p_post_diff_amt.location is null then
3921: ghr_history_fetch.fetch_element_entry_value
3922: -- (p_element_name => 'Post Differential Amount', -- Bug 2645878 Renamed element
3923: (p_element_name => 'Post Allowance',
3924: p_input_value_name => 'Location',
3925: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3927: p_screen_entry_value => p_post_diff_amt.location
3928: );
3929: end if;
3930: if p_post_diff_amt.no_of_family_members is null then
3931: ghr_history_fetch.fetch_element_entry_value
3932: -- (p_element_name => 'Post Differential Amount', -- Bug 2645878 Renamed element
3933: (p_element_name => 'Post Allowance',
3934: p_input_value_name => 'No. Family Members',
3935: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3959: p_post_diff_percent.post_diff_percent_flag := 'Y';
3960: end if;
3961: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
3962: if p_post_diff_percent.percent is null then
3963: ghr_history_fetch.fetch_element_entry_value
3964: -- (p_element_name => 'Post Differential Percent', -- Bug 2645878 Renamed element
3965: (p_element_name => 'Post Differential',
3966: p_input_value_name => 'Percentage',
3967: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3969: p_screen_entry_value => p_post_diff_percent.percent
3970: );
3971: end if;
3972: if p_post_diff_percent.last_action_code is null then
3973: ghr_history_fetch.fetch_element_entry_value
3974: -- (p_element_name => 'Post Differential Percent', -- Bug 2645878 Renamed element
3975: (p_element_name => 'Post Differential',
3976: p_input_value_name => 'Last Action Code',
3977: p_assignment_id => p_pa_request_rec.employee_assignment_id,
3979: p_screen_entry_value => p_post_diff_percent.last_action_code
3980: );
3981: end if;
3982: if p_post_diff_percent.location is null then
3983: ghr_history_fetch.fetch_element_entry_value
3984: -- (p_element_name => 'Post Differential Percent', -- Bug 2645878 Renamed element
3985: (p_element_name => 'Post Differential',
3986: p_input_value_name => 'Location',
3987: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4012: p_sep_maintenance_allow.sep_maint_allow_flag := 'Y';
4013: end if;
4014: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4015: if p_sep_maintenance_allow.amount is null then
4016: ghr_history_fetch.fetch_element_entry_value
4017: (p_element_name => 'Separate Maintenance Allowance',
4018: p_input_value_name => 'Amount',
4019: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4020: p_date_effective => p_pa_request_rec.effective_date,
4021: p_screen_entry_value => p_sep_maintenance_allow.amount
4022: );
4023: end if;
4024: if p_sep_maintenance_allow.last_action_code is null then
4025: ghr_history_fetch.fetch_element_entry_value
4026: (p_element_name => 'Separate Maintenance Allowance',
4027: p_input_value_name => 'Last Action Code',
4028: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4029: p_date_effective => p_pa_request_rec.effective_date,
4030: p_screen_entry_value => p_sep_maintenance_allow.last_action_code
4031: );
4032: end if;
4033: if p_sep_maintenance_allow.category is null then
4034: ghr_history_fetch.fetch_element_entry_value
4035: (p_element_name => 'Separate Maintenance Allowance',
4036: p_input_value_name => 'Category',
4037: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4038: p_date_effective => p_pa_request_rec.effective_date,
4058: p_supplemental_post_allow.sup_post_allow_flag := 'Y';
4059: end if;
4060: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4061: if p_supplemental_post_allow.amount is null then
4062: ghr_history_fetch.fetch_element_entry_value
4063: (p_element_name => 'Supplemental Post Allowance',
4064: p_input_value_name => 'Amount',
4065: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4066: p_date_effective => p_pa_request_rec.effective_date,
4087: p_temp_lodge_allow.temp_lodge_allow_flag := 'Y';
4088: end if;
4089: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4090: if p_temp_lodge_allow.allowance_type is null then
4091: ghr_history_fetch.fetch_element_entry_value
4092: (p_element_name => 'Temporary Lodging Allowance',
4093: p_input_value_name => 'Allowance Type',
4094: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4095: p_date_effective => p_pa_request_rec.effective_date,
4096: p_screen_entry_value => p_temp_lodge_allow.allowance_type
4097: );
4098: end if;
4099: if p_temp_lodge_allow.daily_rate is null then
4100: ghr_history_fetch.fetch_element_entry_value
4101: (p_element_name => 'Temporary Lodging Allowance',
4102: p_input_value_name => 'Daily Rate',
4103: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4104: p_date_effective => p_pa_request_rec.effective_date,
4125: p_premium_pay.premium_pay_flag := 'Y';
4126: end if;
4127: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4128: if p_premium_pay.premium_pay_ind is null then
4129: ghr_history_fetch.fetch_element_entry_value
4130: (p_element_name => 'Premium Pay',
4131: p_input_value_name => 'Premium Pay Ind',
4132: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4133: p_date_effective => p_pa_request_rec.effective_date,
4134: p_screen_entry_value => p_premium_pay.premium_pay_ind
4135: );
4136: end if;
4137: if p_premium_pay.amount is null then
4138: ghr_history_fetch.fetch_element_entry_value
4139: (p_element_name => 'Premium Pay',
4140: p_input_value_name => 'Amount',
4141: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4142: p_date_effective => p_pa_request_rec.effective_date,
4163: p_retirement_annuity.retirement_annuity_flag := 'Y';
4164: end if;
4165: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4166: if p_retirement_annuity.annuity_sum is null then
4167: ghr_history_fetch.fetch_element_entry_value
4168: (p_element_name => 'Retirement Annuity',
4169: p_input_value_name => 'Sum',
4170: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4171: p_date_effective => p_pa_request_rec.effective_date,
4172: p_screen_entry_value => p_retirement_annuity.annuity_sum
4173: );
4174: end if;
4175: if p_retirement_annuity.eligibility_expires is null then
4176: ghr_history_fetch.fetch_element_entry_value
4177: (p_element_name => 'Retirement Annuity',
4178: p_input_value_name => 'Eligibility Expires',
4179: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4180: p_date_effective => p_pa_request_rec.effective_date,
4205: p_severance_pay.severance_pay_flag := 'Y';
4206: end if;
4207: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4208: if p_severance_pay.amount is null then
4209: ghr_history_fetch.fetch_element_entry_value
4210: (p_element_name => 'Severance Pay',
4211: p_input_value_name => 'Amount',
4212: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4213: p_date_effective => p_pa_request_rec.effective_date,
4214: p_screen_entry_value => p_severance_pay.amount
4215: );
4216: end if;
4217: if p_severance_pay.total_entitlement_weeks is null then
4218: ghr_history_fetch.fetch_element_entry_value
4219: (p_element_name => 'Severance Pay',
4220: p_input_value_name => 'Total Entitlement Weeks',
4221: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4222: p_date_effective => p_pa_request_rec.effective_date,
4223: p_screen_entry_value => p_severance_pay.total_entitlement_weeks
4224: );
4225: end if;
4226: if p_severance_pay.number_weeks_paid is null then
4227: ghr_history_fetch.fetch_element_entry_value
4228: (p_element_name => 'Severance Pay',
4229: p_input_value_name => 'Number Weeks Paid',
4230: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4231: p_date_effective => p_pa_request_rec.effective_date,
4232: p_screen_entry_value => p_severance_pay.number_weeks_paid
4233: );
4234: end if;
4235: if p_severance_pay.weekly_amount is null then
4236: ghr_history_fetch.fetch_element_entry_value
4237: (p_element_name => 'Severance Pay',
4238: p_input_value_name => 'Weekly Amount',
4239: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4240: p_date_effective => p_pa_request_rec.effective_date,
4280: p_per_scd_info.per_scd_info_flag, 'Y');
4281:
4282: If l_session.noa_id_correct is not null then -- for correction fetch the existing values
4283: if p_thrift_saving_plan.amount is null then
4284: ghr_history_fetch.fetch_element_entry_value
4285: (p_element_name => 'TSP',
4286: p_input_value_name => 'Amount',
4287: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4288: p_date_effective => p_pa_request_rec.effective_date,
4289: p_screen_entry_value => p_thrift_saving_plan.amount
4290: );
4291: end if;
4292: if p_thrift_saving_plan.rate is null then
4293: ghr_history_fetch.fetch_element_entry_value
4294: (p_element_name => 'TSP',
4295: p_input_value_name => 'Rate',
4296: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4297: p_date_effective => p_pa_request_rec.effective_date,
4298: p_screen_entry_value => p_thrift_saving_plan.rate
4299: );
4300: end if;
4301: if p_thrift_saving_plan.g_fund is null then
4302: ghr_history_fetch.fetch_element_entry_value
4303: (p_element_name => 'TSP',
4304: p_input_value_name => 'G Fund',
4305: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4306: p_date_effective => p_pa_request_rec.effective_date,
4307: p_screen_entry_value => p_thrift_saving_plan.g_fund
4308: );
4309: end if;
4310: if p_thrift_saving_plan.f_fund is null then
4311: ghr_history_fetch.fetch_element_entry_value
4312: (p_element_name => 'TSP',
4313: p_input_value_name => 'F Fund',
4314: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4315: p_date_effective => p_pa_request_rec.effective_date,
4316: p_screen_entry_value => p_thrift_saving_plan.f_fund
4317: );
4318: end if;
4319: if p_thrift_saving_plan.c_fund is null then
4320: ghr_history_fetch.fetch_element_entry_value
4321: (p_element_name => 'TSP',
4322: p_input_value_name => 'C Fund',
4323: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4324: p_date_effective => p_pa_request_rec.effective_date,
4325: p_screen_entry_value => p_thrift_saving_plan.c_fund
4326: );
4327: end if;
4328: if p_thrift_saving_plan.status is null then
4329: ghr_history_fetch.fetch_element_entry_value
4330: (p_element_name => 'TSP',
4331: p_input_value_name => 'Status',
4332: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4333: p_date_effective => p_pa_request_rec.effective_date,
4334: p_screen_entry_value => p_thrift_saving_plan.status
4335: );
4336: end if;
4337: if p_thrift_saving_plan.status_date is null then
4338: ghr_history_fetch.fetch_element_entry_value
4339: (p_element_name => 'TSP',
4340: p_input_value_name => 'Status Date',
4341: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4342: p_date_effective => p_pa_request_rec.effective_date,
4343: p_screen_entry_value => p_thrift_saving_plan.status_date
4344: );
4345: end if;
4346: if p_thrift_saving_plan.agncy_contrib_elig_date is null then
4347: ghr_history_fetch.fetch_element_entry_value
4348: (p_element_name => 'TSP',
4349: p_input_value_name => 'Agncy Contrib Elig Date',
4350: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4351: p_date_effective => p_pa_request_rec.effective_date,
4352: p_screen_entry_value => p_thrift_saving_plan.agncy_contrib_elig_date
4353: );
4354: end if;
4355: if p_thrift_saving_plan.emp_contrib_elig_date is null then
4356: ghr_history_fetch.fetch_element_entry_value
4357: (p_element_name => 'TSP',
4358: p_input_value_name => 'Emp Contrib Elig Date',
4359: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4360: p_date_effective => p_pa_request_rec.effective_date,
4683: -- l_pos_org := p_pos_grp1.positions_organization;
4684: -- Get Element Entry Values in case of 'CORRECTION' -- only those elements that come off an extra_info
4685:
4686: If l_session.noa_id_correct is not null then
4687: ghr_history_fetch.fetch_element_entry_value
4688: (p_element_name => 'Within Grade Increase',
4689: p_input_value_name => 'Date Due',
4690: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4691: p_date_effective => p_pa_request_rec.effective_date,
4690: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4691: p_date_effective => p_pa_request_rec.effective_date,
4692: p_screen_entry_value => p_within_grade_increase.p_date_wgi_due
4693: );
4694: ghr_history_fetch.fetch_element_entry_value
4695: (p_element_name => 'Within Grade Increase',
4696: p_input_value_name => 'Pay Date',
4697: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4698: p_date_effective => p_pa_request_rec.effective_date,
4697: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4698: p_date_effective => p_pa_request_rec.effective_date,
4699: p_screen_entry_value => p_within_grade_increase.p_wgi_pay_date
4700: );
4701: ghr_history_fetch.fetch_element_entry_value
4702: (p_element_name => 'Within Grade Increase',
4703: p_input_value_name => 'Postponmt Effective',
4704: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4705: p_date_effective => p_pa_request_rec.effective_date,
4704: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4705: p_date_effective => p_pa_request_rec.effective_date,
4706: p_screen_entry_value => p_within_grade_increase.p_date_wgi_postpone_effective
4707: );
4708: ghr_history_fetch.fetch_element_entry_value
4709: (p_element_name => 'Within Grade Increase',
4710: p_input_value_name => 'Last Equivalent Increase',
4711: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4712: p_date_effective => p_pa_request_rec.effective_date,
4714: );
4715: -- The foll. if conditions ensure that we fetch the elements only
4716: -- on correction to a noa relevant to the specific elements
4717: If p_pa_request_rec.first_noa_code = '816' then
4718: ghr_history_fetch.fetch_element_entry_value
4719: (p_element_name => 'Relocation Bonus',
4720: p_input_value_name => 'Expiration Date',
4721: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4722: p_date_effective => p_pa_request_rec.effective_date,
4723: p_screen_entry_value => p_relocation_bonus.p_date_reloc_exp
4724: );
4725: End if;
4726: If p_pa_request_rec.first_noa_code = '815' then
4727: ghr_history_fetch.fetch_element_entry_value
4728: (p_element_name => 'Recruitment Bonus',
4729: p_input_value_name => 'Expiration Date',
4730: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4731: p_date_effective => p_pa_request_rec.effective_date,
5180: --End Bug# 6083404
5181: IF l_user_apnt_status = 'Temp. Appointment NTE'
5182: and nvl(l_user_actv_apnt_status,'XXX') <>'Active Appointment' THEN
5183: --Bug# 6083404 added l_user_actv_apnt_status condition
5184: ghr_history_fetch.fetch_asgei
5185: (p_assignment_id => p_pa_request_rec.employee_assignment_id,
5186: p_information_type => 'GHR_US_ASG_NTE_DATES',
5187: p_date_effective => l_user_apnt_eff_date,
5188: p_asg_ei_data => l_asg_extra_info_rec