4: --
5:
6: PROCEDURE get_auth_codes
7: (p_pa_req_rec IN ghr_pa_requests%rowtype,
8: p_pei_auth_code1 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,
9: p_pei_auth_code2 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,
10: p_auth_code1 IN OUT nocopy per_people_extra_info.pei_information1%type,
11: p_auth_code2 IN OUT nocopy per_people_extra_info.pei_information1%type)
12: IS
5:
6: PROCEDURE get_auth_codes
7: (p_pa_req_rec IN ghr_pa_requests%rowtype,
8: p_pei_auth_code1 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,
9: p_pei_auth_code2 IN per_people_extra_info.pei_information1%type DEFAULT hr_api.g_varchar2,
10: p_auth_code1 IN OUT nocopy per_people_extra_info.pei_information1%type,
11: p_auth_code2 IN OUT nocopy per_people_extra_info.pei_information1%type)
12: IS
13: l_proc varchar2(70) := 'get_auth_codes';
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'
23: ,p_date_effective => p_pa_req_rec.effective_date
24: ,p_per_ei_data => l_pei_extra_info);
42: --
43: Procedure populate_record_groups
44: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
45: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
46: p_imm_asg_sf52 out nocopy ghr_api.asg_sf52_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
43: Procedure populate_record_groups
44: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
45: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
46: p_imm_asg_sf52 out nocopy ghr_api.asg_sf52_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
44: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
45: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
46: p_imm_asg_sf52 out nocopy ghr_api.asg_sf52_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
45: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
46: p_imm_asg_sf52 out nocopy ghr_api.asg_sf52_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
46: p_imm_asg_sf52 out nocopy ghr_api.asg_sf52_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
47: p_imm_asg_non_sf52 out nocopy ghr_api.asg_non_sf52_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
49: p_imm_asg_detail_info out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
57: p_imm_per_security out nocopy ghr_api.per_security_type,
50: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
57: p_imm_per_security out nocopy ghr_api.per_security_type,
58: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
51: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
57: p_imm_per_security out nocopy ghr_api.per_security_type,
58: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
59: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
52: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
57: p_imm_per_security out nocopy ghr_api.per_security_type,
58: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
59: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
60: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
53: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
54: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
57: p_imm_per_security out nocopy ghr_api.per_security_type,
58: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
59: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
60: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
61: -- 4352589 BEN_EIT Changes
55: p_imm_per_probations out nocopy ghr_api.per_probations_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
57: p_imm_per_security out nocopy ghr_api.per_security_type,
58: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
59: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
60: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
61: -- 4352589 BEN_EIT Changes
62: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
56: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
57: p_imm_per_security out nocopy ghr_api.per_security_type,
58: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
59: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
60: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
61: -- 4352589 BEN_EIT Changes
62: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
58: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
59: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
60: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
61: -- 4352589 BEN_EIT Changes
62: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
59: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
60: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
61: -- 4352589 BEN_EIT Changes
62: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
60: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
61: -- 4352589 BEN_EIT Changes
62: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
61: -- 4352589 BEN_EIT Changes
62: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
62: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
63: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
64: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
65: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
73: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
66: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
73: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
74: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
67: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
73: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
74: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
75: -- Bug 4724337 Race or National Origin changes
68: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
73: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
74: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
75: -- Bug 4724337 Race or National Origin changes
76: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
69: p_imm_loc_info out nocopy ghr_api.loc_info_type,
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
73: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
74: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
75: -- Bug 4724337 Race or National Origin changes
76: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
77: -- End race and National Origin changes
70: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
71: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
73: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
74: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
75: -- Bug 4724337 Race or National Origin changes
76: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
77: -- End race and National Origin changes
78: --Pradeep
72: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
73: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
74: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
75: -- Bug 4724337 Race or National Origin changes
76: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
77: -- End race and National Origin changes
78: --Pradeep
79: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
80: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
75: -- Bug 4724337 Race or National Origin changes
76: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
77: -- End race and National Origin changes
78: --Pradeep
79: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
80: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
81:
82: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
76: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
77: -- End race and National Origin changes
78: --Pradeep
79: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
80: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
81:
82: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
78: --Pradeep
79: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
80: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
81:
82: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
79: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
80: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
81:
82: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
80: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
81:
82: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
81:
82: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
82: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
83: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
91: p_imm_entitlement out nocopy ghr_api.entitlement_type,
84: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
91: p_imm_entitlement out nocopy ghr_api.entitlement_type,
92: -- Bug#2759379 Added Fegli record
85: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
91: p_imm_entitlement out nocopy ghr_api.entitlement_type,
92: -- Bug#2759379 Added Fegli record
93: p_imm_fegli out nocopy ghr_api.fegli_type,
86: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
91: p_imm_entitlement out nocopy ghr_api.entitlement_type,
92: -- Bug#2759379 Added Fegli record
93: p_imm_fegli out nocopy ghr_api.fegli_type,
94: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
87: p_imm_personal_info out nocopy ghr_api.personal_info_type,
88: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
91: p_imm_entitlement out nocopy ghr_api.entitlement_type,
92: -- Bug#2759379 Added Fegli record
93: p_imm_fegli out nocopy ghr_api.fegli_type,
94: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
95: -- Bug#3385386 Added FTA record
89: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
91: p_imm_entitlement out nocopy ghr_api.entitlement_type,
92: -- Bug#2759379 Added Fegli record
93: p_imm_fegli out nocopy ghr_api.fegli_type,
94: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
95: -- Bug#3385386 Added FTA record
96: p_imm_fta out nocopy ghr_api.fta_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
90: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
91: p_imm_entitlement out nocopy ghr_api.entitlement_type,
92: -- Bug#2759379 Added Fegli record
93: p_imm_fegli out nocopy ghr_api.fegli_type,
94: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
95: -- Bug#3385386 Added FTA record
96: p_imm_fta out nocopy ghr_api.fta_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
92: -- Bug#2759379 Added Fegli record
93: p_imm_fegli out nocopy ghr_api.fegli_type,
94: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
95: -- Bug#3385386 Added FTA record
96: p_imm_fta out nocopy ghr_api.fta_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
93: p_imm_fegli out nocopy ghr_api.fegli_type,
94: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
95: -- Bug#3385386 Added FTA record
96: p_imm_fta out nocopy ghr_api.fta_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
94: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
95: -- Bug#3385386 Added FTA record
96: p_imm_fta out nocopy ghr_api.fta_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
95: -- Bug#3385386 Added FTA record
96: p_imm_fta out nocopy ghr_api.fta_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
96: p_imm_fta out nocopy ghr_api.fta_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
97: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
98: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
99: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
100: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
101: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
102: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
103: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
111: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
104: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
111: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
112: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
105: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
111: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
112: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
113: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
106: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
111: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
112: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
113: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
114: p_agency_code out nocopy varchar2,
107: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
111: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
112: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
113: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
114: p_agency_code out nocopy varchar2,
115: -- Bug#6312144 Added new RPA Benefit EIT
108: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
111: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
112: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
113: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
114: p_agency_code out nocopy varchar2,
115: -- Bug#6312144 Added new RPA Benefit EIT
116: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
109: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
110: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
111: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
112: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
113: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
114: p_agency_code out nocopy varchar2,
115: -- Bug#6312144 Added new RPA Benefit EIT
116: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
117: p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type,
112: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
113: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
114: p_agency_code out nocopy varchar2,
115: -- Bug#6312144 Added new RPA Benefit EIT
116: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
117: p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type,
118: --BUG # 13571004 added TSP Roth
119: p_imm_tsp_roth out nocopy ghr_api.tsp_roth_type
120: )
113: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
114: p_agency_code out nocopy varchar2,
115: -- Bug#6312144 Added new RPA Benefit EIT
116: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
117: p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type,
118: --BUG # 13571004 added TSP Roth
119: p_imm_tsp_roth out nocopy ghr_api.tsp_roth_type
120: )
121: is
115: -- Bug#6312144 Added new RPA Benefit EIT
116: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
117: p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type,
118: --BUG # 13571004 added TSP Roth
119: p_imm_tsp_roth out nocopy ghr_api.tsp_roth_type
120: )
121: is
122:
123: -- Cursor to select the person's sex which is required for CPDF Edits
181: from per_all_assignments_f asg
182: Where asg.assignment_id = p_pa_request_rec.employee_assignment_id
183: order by 1 desc;
184:
185: l_imm_asg_sf52 ghr_api.asg_sf52_type;
186: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
187: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
182: Where asg.assignment_id = p_pa_request_rec.employee_assignment_id
183: order by 1 desc;
184:
185: l_imm_asg_sf52 ghr_api.asg_sf52_type;
186: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
187: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
183: order by 1 desc;
184:
185: l_imm_asg_sf52 ghr_api.asg_sf52_type;
186: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
187: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
184:
185: l_imm_asg_sf52 ghr_api.asg_sf52_type;
186: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
187: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
185: l_imm_asg_sf52 ghr_api.asg_sf52_type;
186: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
187: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
186: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
187: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
187: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
188: l_imm_asg_detail_info ghr_api.asg_detail_info_type; --Bug# 8653508
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
189: l_imm_per_sf52 ghr_api.per_sf52_type;
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
190: l_imm_per_group1 ghr_api.per_group1_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
191: l_imm_per_group2 ghr_api.per_group2_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
192: l_imm_per_scd_info ghr_api.per_scd_info_type;
193: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
194: l_imm_per_probations ghr_api.per_probations_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
195: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
196: l_imm_per_security ghr_api.per_security_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
197: -- Bug#4486823 RRR changes
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
198: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
199: l_imm_per_conversions ghr_api.per_conversions_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
200: -- 4352589 BEN_EIT Changes
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
201: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
202: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
203: l_imm_pos_oblig ghr_api.pos_oblig_type;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
204: l_imm_pos_grp2 ghr_api.pos_grp2_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
205: l_imm_pos_grp1 ghr_api.pos_grp1_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
206: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214:
207: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214:
215: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
208: l_imm_loc_info ghr_api.loc_info_type;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214:
215: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
216: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
209: l_imm_wgi ghr_api.within_grade_increase_type ;
210: l_imm_gov_awards ghr_api.government_awards_type;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214:
215: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
216: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
217: l_pos_extra_info_rec per_position_extra_info%rowtype;
211: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
212: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
213: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
214:
215: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
216: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
217: l_pos_extra_info_rec per_position_extra_info%rowtype;
218: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
219: l_imm_personal_info ghr_api.personal_info_type;
214:
215: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
216: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
217: l_pos_extra_info_rec per_position_extra_info%rowtype;
218: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
219: l_imm_personal_info ghr_api.personal_info_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
215: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
216: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
217: l_pos_extra_info_rec per_position_extra_info%rowtype;
218: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
219: l_imm_personal_info ghr_api.personal_info_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
216: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
217: l_pos_extra_info_rec per_position_extra_info%rowtype;
218: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
219: l_imm_personal_info ghr_api.personal_info_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
217: l_pos_extra_info_rec per_position_extra_info%rowtype;
218: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
219: l_imm_personal_info ghr_api.personal_info_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
225: l_imm_entitlement ghr_api.entitlement_type;
218: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
219: l_imm_personal_info ghr_api.personal_info_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
225: l_imm_entitlement ghr_api.entitlement_type;
226: --Bug#2759379 Added Fegli record
219: l_imm_personal_info ghr_api.personal_info_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
225: l_imm_entitlement ghr_api.entitlement_type;
226: --Bug#2759379 Added Fegli record
227: l_imm_fegli ghr_api.fegli_type;
220: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
225: l_imm_entitlement ghr_api.entitlement_type;
226: --Bug#2759379 Added Fegli record
227: l_imm_fegli ghr_api.fegli_type;
228: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
221: l_imm_agency_sf52 ghr_api.agency_sf52_type;
222: l_imm_payroll_type ghr_api.government_payroll_type;
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
225: l_imm_entitlement ghr_api.entitlement_type;
226: --Bug#2759379 Added Fegli record
227: l_imm_fegli ghr_api.fegli_type;
228: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
229: -- Bug#3385386 declared FTA record type variable
223: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
225: l_imm_entitlement ghr_api.entitlement_type;
226: --Bug#2759379 Added Fegli record
227: l_imm_fegli ghr_api.fegli_type;
228: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
229: -- Bug#3385386 declared FTA record type variable
230: l_imm_fta ghr_api.fta_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
224: l_imm_conduct_performance ghr_api.conduct_performance_type;
225: l_imm_entitlement ghr_api.entitlement_type;
226: --Bug#2759379 Added Fegli record
227: l_imm_fegli ghr_api.fegli_type;
228: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
229: -- Bug#3385386 declared FTA record type variable
230: l_imm_fta ghr_api.fta_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
226: --Bug#2759379 Added Fegli record
227: l_imm_fegli ghr_api.fegli_type;
228: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
229: -- Bug#3385386 declared FTA record type variable
230: l_imm_fta ghr_api.fta_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
227: l_imm_fegli ghr_api.fegli_type;
228: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
229: -- Bug#3385386 declared FTA record type variable
230: l_imm_fta ghr_api.fta_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
228: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
229: -- Bug#3385386 declared FTA record type variable
230: l_imm_fta ghr_api.fta_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
229: -- Bug#3385386 declared FTA record type variable
230: l_imm_fta ghr_api.fta_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
230: l_imm_fta ghr_api.fta_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
231: l_imm_edp_pay ghr_api.edp_pay_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
232: l_imm_hazard_pay ghr_api.hazard_pay_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
233: l_imm_health_benefits ghr_api.health_benefits_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
234: l_imm_danger_pay ghr_api.danger_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
235: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
236: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
237: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
238: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
239: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
240: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
248: l_agency_code varchar2(50);
241: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
248: l_agency_code varchar2(50);
249: l_special_info_type ghr_api.special_information_type;
242: l_imm_premium_pay ghr_api.premium_pay_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
248: l_agency_code varchar2(50);
249: l_special_info_type ghr_api.special_information_type;
250: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
243: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
244: l_imm_severance_pay ghr_api.severance_pay_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
248: l_agency_code varchar2(50);
249: l_special_info_type ghr_api.special_information_type;
250: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
251: l_session ghr_history_api.g_session_var_type;
245: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
248: l_agency_code varchar2(50);
249: l_special_info_type ghr_api.special_information_type;
250: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
251: l_session ghr_history_api.g_session_var_type;
252: l_asg_ei_data per_assignment_extra_info%rowtype;
253: l_assignment_data per_all_assignments_f%rowtype;
246: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
247: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
248: l_agency_code varchar2(50);
249: l_special_info_type ghr_api.special_information_type;
250: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
251: l_session ghr_history_api.g_session_var_type;
252: l_asg_ei_data per_assignment_extra_info%rowtype;
253: l_assignment_data per_all_assignments_f%rowtype;
254: l_result_code varchar2(50);
256: l_effective_date date;
257: -- Bug#4054110
258: l_temp_rec_level varchar2(30);
259: --Pradeep
260: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
261: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
262: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
263: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
264: l_imm_retirement_info ghr_api.per_retirement_info_type;
257: -- Bug#4054110
258: l_temp_rec_level varchar2(30);
259: --Pradeep
260: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
261: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
262: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
263: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
264: l_imm_retirement_info ghr_api.per_retirement_info_type;
265: --BUG # 13571004
258: l_temp_rec_level varchar2(30);
259: --Pradeep
260: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
261: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
262: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
263: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
264: l_imm_retirement_info ghr_api.per_retirement_info_type;
265: --BUG # 13571004
266: l_imm_tsp_roth ghr_api.tsp_roth_type;
259: --Pradeep
260: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
261: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
262: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
263: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
264: l_imm_retirement_info ghr_api.per_retirement_info_type;
265: --BUG # 13571004
266: l_imm_tsp_roth ghr_api.tsp_roth_type;
267:
260: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
261: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
262: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
263: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
264: l_imm_retirement_info ghr_api.per_retirement_info_type;
265: --BUG # 13571004
266: l_imm_tsp_roth ghr_api.tsp_roth_type;
267:
268:
262: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
263: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
264: l_imm_retirement_info ghr_api.per_retirement_info_type;
265: --BUG # 13571004
266: l_imm_tsp_roth ghr_api.tsp_roth_type;
267:
268:
269:
270: Begin
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',
525: p_effective_date => p_pa_request_rec.effective_date,
526: p_special_info => l_special_info_type
592: perf_appraisal.appr_sys_ident is not null or
593: perf_appraisal.optional_info is not null or
594: perf_appraisal.performance_rating_points is not null then*/
595:
596: if nvl(perf_appraisal.rat_rec,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.rating_rec,hr_api.g_varchar2) then
597: l_imm_perf_appraisal.rating_rec := perf_appraisal.rat_rec;
598: l_imm_perf_appraisal.perf_appr_flag := 'Y';
599: end if;
600: if nvl(perf_appraisal.rec_pattern,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.rating_rec_pattern,hr_api.g_varchar2) then
596: if nvl(perf_appraisal.rat_rec,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.rating_rec,hr_api.g_varchar2) then
597: l_imm_perf_appraisal.rating_rec := perf_appraisal.rat_rec;
598: l_imm_perf_appraisal.perf_appr_flag := 'Y';
599: end if;
600: if nvl(perf_appraisal.rec_pattern,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.rating_rec_pattern,hr_api.g_varchar2) then
601: l_imm_perf_appraisal.rating_rec_pattern := perf_appraisal.rec_pattern;
602: l_imm_perf_appraisal.perf_appr_flag := 'Y';
603: end if;
604:
602: l_imm_perf_appraisal.perf_appr_flag := 'Y';
603: end if;
604:
605: -- Reverted the changes done by Pradeep for bug#4054110.
606: if nvl(perf_appraisal.rec_level,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.rating_rec_level,hr_api.g_varchar2) then
607: l_imm_perf_appraisal.rating_rec_level := perf_appraisal.rec_level;
608: l_imm_perf_appraisal.perf_appr_flag := 'Y';
609: end if;
610:
607: l_imm_perf_appraisal.rating_rec_level := perf_appraisal.rec_level;
608: l_imm_perf_appraisal.perf_appr_flag := 'Y';
609: end if;
610:
611: if nvl(perf_appraisal.app_ends,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.date_appr_ends,hr_api.g_varchar2) then
612: l_imm_perf_appraisal.date_appr_ends := perf_appraisal.app_ends;
613: l_imm_perf_appraisal.perf_appr_flag := 'Y';
614: end if;
615: --Bug# 4753117 28-Feb-07 Veeramani assigning appraisal start date
612: l_imm_perf_appraisal.date_appr_ends := perf_appraisal.app_ends;
613: l_imm_perf_appraisal.perf_appr_flag := 'Y';
614: end if;
615: --Bug# 4753117 28-Feb-07 Veeramani assigning appraisal start date
616: if nvl(perf_appraisal.app_starts,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.date_appr_starts,hr_api.g_varchar2) then
617: l_imm_perf_appraisal.date_appr_starts := perf_appraisal.app_starts;
618: l_imm_perf_appraisal.perf_appr_flag := 'Y';
619: end if;
620:
617: l_imm_perf_appraisal.date_appr_starts := perf_appraisal.app_starts;
618: l_imm_perf_appraisal.perf_appr_flag := 'Y';
619: end if;
620:
621: if nvl(perf_appraisal.app_type,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.appraisal_type,hr_api.g_varchar2) then
622: l_imm_perf_appraisal.appraisal_type := perf_appraisal.app_type;
623: l_imm_perf_appraisal.perf_appr_flag := 'Y';
624: end if;
625: if nvl(perf_appraisal.date_init_appr_due,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.date_init_appr_due,hr_api.g_varchar2) then
621: if nvl(perf_appraisal.app_type,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.appraisal_type,hr_api.g_varchar2) then
622: l_imm_perf_appraisal.appraisal_type := perf_appraisal.app_type;
623: l_imm_perf_appraisal.perf_appr_flag := 'Y';
624: end if;
625: if nvl(perf_appraisal.date_init_appr_due,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.date_init_appr_due,hr_api.g_varchar2) then
626: l_imm_perf_appraisal.date_init_appr_due := perf_appraisal.date_init_appr_due;
627: l_imm_perf_appraisal.perf_appr_flag := 'Y';
628: end if;
629: if nvl(perf_appraisal.date_effective,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.date_effective,hr_api.g_varchar2) then
625: if nvl(perf_appraisal.date_init_appr_due,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.date_init_appr_due,hr_api.g_varchar2) then
626: l_imm_perf_appraisal.date_init_appr_due := perf_appraisal.date_init_appr_due;
627: l_imm_perf_appraisal.perf_appr_flag := 'Y';
628: end if;
629: if nvl(perf_appraisal.date_effective,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.date_effective,hr_api.g_varchar2) then
630: l_imm_perf_appraisal.date_effective := perf_appraisal.date_effective;
631: l_imm_perf_appraisal.perf_appr_flag := 'Y';
632: end if;
633: if nvl(perf_appraisal.unit,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.unit,hr_api.g_varchar2) then
629: if nvl(perf_appraisal.date_effective,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.date_effective,hr_api.g_varchar2) then
630: l_imm_perf_appraisal.date_effective := perf_appraisal.date_effective;
631: l_imm_perf_appraisal.perf_appr_flag := 'Y';
632: end if;
633: if nvl(perf_appraisal.unit,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.unit,hr_api.g_varchar2) then
634: l_imm_perf_appraisal.unit := perf_appraisal.unit;
635: l_imm_perf_appraisal.perf_appr_flag := 'Y';
636: end if;
637: if nvl(perf_appraisal.org_str_id,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.org_structure_id,hr_api.g_varchar2) then
633: if nvl(perf_appraisal.unit,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.unit,hr_api.g_varchar2) then
634: l_imm_perf_appraisal.unit := perf_appraisal.unit;
635: l_imm_perf_appraisal.perf_appr_flag := 'Y';
636: end if;
637: if nvl(perf_appraisal.org_str_id,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.org_structure_id,hr_api.g_varchar2) then
638: l_imm_perf_appraisal.org_structure_id := perf_appraisal.org_str_id;
639: l_imm_perf_appraisal.perf_appr_flag := 'Y';
640: end if;
641: if nvl(perf_appraisal.off_symbol,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.office_symbol,hr_api.g_varchar2) then
637: if nvl(perf_appraisal.org_str_id,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.org_structure_id,hr_api.g_varchar2) then
638: l_imm_perf_appraisal.org_structure_id := perf_appraisal.org_str_id;
639: l_imm_perf_appraisal.perf_appr_flag := 'Y';
640: end if;
641: if nvl(perf_appraisal.off_symbol,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.office_symbol,hr_api.g_varchar2) then
642: l_imm_perf_appraisal.office_symbol := perf_appraisal.off_symbol;
643: l_imm_perf_appraisal.perf_appr_flag := 'Y';
644: end if;
645: if nvl(perf_appraisal.pay_plan,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.pay_plan,hr_api.g_varchar2) then
641: if nvl(perf_appraisal.off_symbol,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.office_symbol,hr_api.g_varchar2) then
642: l_imm_perf_appraisal.office_symbol := perf_appraisal.off_symbol;
643: l_imm_perf_appraisal.perf_appr_flag := 'Y';
644: end if;
645: if nvl(perf_appraisal.pay_plan,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.pay_plan,hr_api.g_varchar2) then
646: l_imm_perf_appraisal.pay_plan := perf_appraisal.pay_plan;
647: l_imm_perf_appraisal.perf_appr_flag := 'Y';
648: end if;
649: if nvl(perf_appraisal.grade,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.grade,hr_api.g_varchar2) then
645: if nvl(perf_appraisal.pay_plan,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.pay_plan,hr_api.g_varchar2) then
646: l_imm_perf_appraisal.pay_plan := perf_appraisal.pay_plan;
647: l_imm_perf_appraisal.perf_appr_flag := 'Y';
648: end if;
649: if nvl(perf_appraisal.grade,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.grade,hr_api.g_varchar2) then
650: l_imm_perf_appraisal.grade := perf_appraisal.grade;
651: l_imm_perf_appraisal.perf_appr_flag := 'Y';
652: end if;
653: if nvl(perf_appraisal.date_due,hr_api.g_varchar2) <>nvl(l_imm_perf_appraisal.date_due,hr_api.g_varchar2) then
649: if nvl(perf_appraisal.grade,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.grade,hr_api.g_varchar2) then
650: l_imm_perf_appraisal.grade := perf_appraisal.grade;
651: l_imm_perf_appraisal.perf_appr_flag := 'Y';
652: end if;
653: if nvl(perf_appraisal.date_due,hr_api.g_varchar2) <>nvl(l_imm_perf_appraisal.date_due,hr_api.g_varchar2) then
654: l_imm_perf_appraisal.date_due := perf_appraisal.date_due;
655: l_imm_perf_appraisal.perf_appr_flag := 'Y';
656: end if;
657: if nvl(perf_appraisal.appr_sys_ident,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.appraisal_system_identifier,hr_api.g_varchar2) then
653: if nvl(perf_appraisal.date_due,hr_api.g_varchar2) <>nvl(l_imm_perf_appraisal.date_due,hr_api.g_varchar2) then
654: l_imm_perf_appraisal.date_due := perf_appraisal.date_due;
655: l_imm_perf_appraisal.perf_appr_flag := 'Y';
656: end if;
657: if nvl(perf_appraisal.appr_sys_ident,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.appraisal_system_identifier,hr_api.g_varchar2) then
658: l_imm_perf_appraisal.appraisal_system_identifier := perf_appraisal.appr_sys_ident;
659: l_imm_perf_appraisal.perf_appr_flag := 'Y';
660: end if;
661: if nvl(perf_appraisal.optional_info,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.optional_information,hr_api.g_varchar2) then
657: if nvl(perf_appraisal.appr_sys_ident,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.appraisal_system_identifier,hr_api.g_varchar2) then
658: l_imm_perf_appraisal.appraisal_system_identifier := perf_appraisal.appr_sys_ident;
659: l_imm_perf_appraisal.perf_appr_flag := 'Y';
660: end if;
661: if nvl(perf_appraisal.optional_info,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.optional_information,hr_api.g_varchar2) then
662: l_imm_perf_appraisal.optional_information := perf_appraisal.optional_info;
663: l_imm_perf_appraisal.perf_appr_flag := 'Y';
664: end if;
665:
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';
671: end if;
672: l_temp_rec_level := perf_appraisal.rec_level;
671: end if;
672: l_temp_rec_level := perf_appraisal.rec_level;
673: -- end if;
674: end loop;
675: If l_session.noa_id_correct is null and nvl(l_imm_perf_appraisal.perf_appr_flag ,hr_api.g_varchar2) = 'Y' then
676: l_imm_perf_appraisal.person_analysis_id := Null;
677: end if;
678: -- Bug#4054110,4069798
679: --Bug# 12618741 the following statements are commented out, since this code is causing
774: --
775:
776: Procedure retrieve_all_extra_info
777: (p_pa_request_rec in ghr_pa_requests%rowtype,
778: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
779: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
775:
776: Procedure retrieve_all_extra_info
777: (p_pa_request_rec in ghr_pa_requests%rowtype,
778: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
779: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
776: Procedure retrieve_all_extra_info
777: (p_pa_request_rec in ghr_pa_requests%rowtype,
778: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
779: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
784: p_loc_info in out nocopy ghr_api.loc_info_type,
777: (p_pa_request_rec in ghr_pa_requests%rowtype,
778: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
779: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
784: p_loc_info in out nocopy ghr_api.loc_info_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
778: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
779: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
784: p_loc_info in out nocopy ghr_api.loc_info_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
779: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
784: p_loc_info in out nocopy ghr_api.loc_info_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
787: -- 4352589 BEN_EIT Changes
780: p_per_group1 in out nocopy ghr_api.per_group1_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
784: p_loc_info in out nocopy ghr_api.loc_info_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
787: -- 4352589 BEN_EIT Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
781: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
784: p_loc_info in out nocopy ghr_api.loc_info_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
787: -- 4352589 BEN_EIT Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
782: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
783: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
784: p_loc_info in out nocopy ghr_api.loc_info_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
787: -- 4352589 BEN_EIT Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
784: p_loc_info in out nocopy ghr_api.loc_info_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
787: -- 4352589 BEN_EIT Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
791: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
785: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
787: -- 4352589 BEN_EIT Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
791: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
793: p_per_probations in out nocopy ghr_api.per_probations_type,
786: p_per_conversions in out nocopy ghr_api.per_conversions_type,
787: -- 4352589 BEN_EIT Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
791: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
793: p_per_probations in out nocopy ghr_api.per_probations_type,
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
787: -- 4352589 BEN_EIT Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
791: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
793: p_per_probations in out nocopy ghr_api.per_probations_type,
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
795: --Bug#4486823 RRR Changes
788: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
791: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
793: p_per_probations in out nocopy ghr_api.per_probations_type,
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
795: --Bug#4486823 RRR Changes
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
789: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
791: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
793: p_per_probations in out nocopy ghr_api.per_probations_type,
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
795: --Bug#4486823 RRR Changes
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
797: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
790: p_asg_detail_info in out nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
791: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
793: p_per_probations in out nocopy ghr_api.per_probations_type,
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
795: --Bug#4486823 RRR Changes
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
797: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
798: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
792: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
793: p_per_probations in out nocopy ghr_api.per_probations_type,
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
795: --Bug#4486823 RRR Changes
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
797: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
798: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
799: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
800: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
793: p_per_probations in out nocopy ghr_api.per_probations_type,
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
795: --Bug#4486823 RRR Changes
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
797: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
798: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
799: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
800: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
801: --Bug #6312144 RPA EIT Benefits
794: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
795: --Bug#4486823 RRR Changes
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
797: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
798: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
799: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
800: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
801: --Bug #6312144 RPA EIT Benefits
802: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
795: --Bug#4486823 RRR Changes
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
797: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
798: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
799: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
800: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
801: --Bug #6312144 RPA EIT Benefits
802: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
803: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
796: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
797: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
798: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
799: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
800: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
801: --Bug #6312144 RPA EIT Benefits
802: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
803: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
804: --BUG # 14276354 added new Person group2 segments
798: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
799: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
800: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
801: --Bug #6312144 RPA EIT Benefits
802: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
803: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
804: --BUG # 14276354 added new Person group2 segments
805: p_per_group2 in out nocopy ghr_api.per_group2_type
806: )
799: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
800: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
801: --Bug #6312144 RPA EIT Benefits
802: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
803: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
804: --BUG # 14276354 added new Person group2 segments
805: p_per_group2 in out nocopy ghr_api.per_group2_type
806: )
807: is
801: --Bug #6312144 RPA EIT Benefits
802: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
803: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
804: --BUG # 14276354 added new Person group2 segments
805: p_per_group2 in out nocopy ghr_api.per_group2_type
806: )
807: is
808: l_per_extra_info_rec per_people_extra_info%rowtype;
809: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
808: l_per_extra_info_rec per_people_extra_info%rowtype;
809: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
810: l_pos_extra_info_rec per_position_extra_info%rowtype;
811: l_proc varchar2(70) := 'Retrieve_all_extra_info';
812: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
813: l_position_id per_positions.position_id%type;
814: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
815: l_session ghr_history_api.g_session_var_type;
816: l_person_status per_assignment_status_types.user_status%type;
1315: p_per_separate_retire.agency_code_transfer_to := l_per_extra_info_rec.pei_information8;
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
1713: p_pa_request_rec.noa_family_code = 'REALIGNMENT' and
1714: l_agency_code is not null then
1715: p_agency_code := l_agency_code;
1716: else
1717: p_agency_code := ghr_api.get_position_agency_code_pos
1718: (p_position_id => l_position_id
1719: ,p_business_group_id => l_bus_gp
1720: ,p_effective_date => p_pa_request_rec.effective_date
1721: );
1732: -- This procedure Updates the various Record Groups with Data from the SF52 Form.
1733:
1734: procedure Process_Sf52_Extra_Info
1735: (p_pa_request_rec in ghr_pa_requests%rowtype,
1736: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1737: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1733:
1734: procedure Process_Sf52_Extra_Info
1735: (p_pa_request_rec in ghr_pa_requests%rowtype,
1736: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1737: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1734: procedure Process_Sf52_Extra_Info
1735: (p_pa_request_rec in ghr_pa_requests%rowtype,
1736: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1737: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1735: (p_pa_request_rec in ghr_pa_requests%rowtype,
1736: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1737: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1736: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1737: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1737: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1745: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1738: p_per_group1 in out nocopy ghr_api.per_group1_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1745: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1746: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1739: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1745: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1746: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1747: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1740: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1745: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1746: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1747: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1748: is
1741: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1745: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1746: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1747: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1748: is
1749: --
1742: p_loc_info in out nocopy ghr_api.loc_info_type,
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1745: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1746: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1747: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1748: is
1749: --
1750: l_noa_code ghr_nature_of_actions.code%type;
1743: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1744: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1745: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1746: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1747: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1748: is
1749: --
1750: l_noa_code ghr_nature_of_actions.code%type;
1751: l_proc varchar2(70) := 'Process_Sf52_Extra_Info';
1771: and information_type = l_information_type; */
1772: --
1773: /*l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type;
1774: l_pos_org ghr_pa_request_extra_info.rei_information8%type;*/
1775: l_student_loan_repay ghr_api.student_loan_repay_type;
1776:
1777: --Bug 6881863
1778: l_calc_table_id pay_user_tables.user_table_id%type;
1779: --
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);
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;
1821:
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;
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
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;
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
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;
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
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;
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
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;
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);
1868: p_asg_sf52.asg_sf52_flag := 'Y';
1869: p_Asg_Sf52.part_time_hours := P_pa_request_rec.part_time_hours;
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);
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;
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);
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;
1891: IF p_pa_request_rec.to_pay_table_identifier is null and NVL(p_pa_request_rec.pay_rate_determinant,'X') in ('K','J') then
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
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
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;
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);
1975: p_per_scd_info.per_scd_info_flag := 'Y';
1976: End if;
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;
2034: -- JH removing comments so position is updated for WS and adding PTH update
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';
2047:
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';
2062: -- JH End changes
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;
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);
2107: P_Pos_grp2.Pos_grp2_flag := 'Y';
2108: p_pos_grp2.position_occupied := p_pa_request_rec.position_occupied;
2109: End if;
2109: 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;
2132: -- Position Valid Grade EIT
2133: -- ************************
2134: -- If Grade is changed, then need to update it to Position Bug 2414903
2135: IF p_pa_request_rec.to_grade_id IS NOT NULL THEN
2136: IF p_pa_request_rec.to_grade_id <> NVL(to_number(p_valid_grade.valid_grade),hr_api.g_number) THEN
2137: p_valid_grade.pos_valid_grade_flag := 'Y';
2138: p_valid_grade.valid_grade := p_pa_request_rec.to_grade_id;
2139: END IF;
2140: END IF;
2143: -- *****************
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;
2155: -- ***************
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;
2166: -- ***************
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;
2190: PROCEDURE Process_Non_Sf52_Extra_Info
2191: --
2192: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2193: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2194: p_per_group1 in out nocopy ghr_api.per_group1_type,
2195: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2196: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2191: --
2192: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2193: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2194: p_per_group1 in out nocopy ghr_api.per_group1_type,
2195: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2196: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2192: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2193: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2194: p_per_group1 in out nocopy ghr_api.per_group1_type,
2195: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2196: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2200: -- 4352589 BEN_EIT Changes
2193: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2194: p_per_group1 in out nocopy ghr_api.per_group1_type,
2195: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2196: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2200: -- 4352589 BEN_EIT Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2194: p_per_group1 in out nocopy ghr_api.per_group1_type,
2195: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2196: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2200: -- 4352589 BEN_EIT Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2195: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2196: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2200: -- 4352589 BEN_EIT Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2197: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2200: -- 4352589 BEN_EIT Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2204: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2198: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2200: -- 4352589 BEN_EIT Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2204: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2199: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2200: -- 4352589 BEN_EIT Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2204: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2200: -- 4352589 BEN_EIT Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2204: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2208: --Bug#4486823 RRR Changes
2201: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2204: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2208: --Bug#4486823 RRR Changes
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2202: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2204: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2208: --Bug#4486823 RRR Changes
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2203: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2204: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2208: --Bug#4486823 RRR Changes
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2205: p_asg_detail_info IN OUT nocopy ghr_api.asg_detail_info_type, --Bug# 8653508
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2208: --Bug#4486823 RRR Changes
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2206: p_per_probations in out nocopy ghr_api.per_probations_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2208: --Bug#4486823 RRR Changes
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2207: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2208: --Bug#4486823 RRR Changes
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2208: --Bug#4486823 RRR Changes
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2216: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2209: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2216: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2217: --Pradeep
2210: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2216: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2217: --Pradeep
2218: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2211: p_gov_awards in out nocopy ghr_api.government_awards_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2216: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2217: --Pradeep
2218: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2219: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2212: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2213: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2216: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2217: --Pradeep
2218: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2219: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2220:
2214: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2216: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2217: --Pradeep
2218: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2219: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2220:
2221: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2222: p_entitlement in out nocopy ghr_api.entitlement_type,
2215: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2216: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2217: --Pradeep
2218: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2219: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2220:
2221: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2222: p_entitlement in out nocopy ghr_api.entitlement_type,
2223: -- Bug#2759379 Added Fegli record
2217: --Pradeep
2218: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2219: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2220:
2221: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2222: p_entitlement in out nocopy ghr_api.entitlement_type,
2223: -- Bug#2759379 Added Fegli record
2224: p_fegli in out nocopy ghr_api.fegli_type,
2225: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2218: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2219: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2220:
2221: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2222: p_entitlement in out nocopy ghr_api.entitlement_type,
2223: -- Bug#2759379 Added Fegli record
2224: p_fegli in out nocopy ghr_api.fegli_type,
2225: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2226: -- Bug#3385386 Added FTA record
2220:
2221: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2222: p_entitlement in out nocopy ghr_api.entitlement_type,
2223: -- Bug#2759379 Added Fegli record
2224: p_fegli in out nocopy ghr_api.fegli_type,
2225: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2226: -- Bug#3385386 Added FTA record
2227: p_imm_fta in out nocopy ghr_api.fta_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2221: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2222: p_entitlement in out nocopy ghr_api.entitlement_type,
2223: -- Bug#2759379 Added Fegli record
2224: p_fegli in out nocopy ghr_api.fegli_type,
2225: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2226: -- Bug#3385386 Added FTA record
2227: p_imm_fta in out nocopy ghr_api.fta_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2223: -- Bug#2759379 Added Fegli record
2224: p_fegli in out nocopy ghr_api.fegli_type,
2225: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2226: -- Bug#3385386 Added FTA record
2227: p_imm_fta in out nocopy ghr_api.fta_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2224: p_fegli in out nocopy ghr_api.fegli_type,
2225: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2226: -- Bug#3385386 Added FTA record
2227: p_imm_fta in out nocopy ghr_api.fta_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2225: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2226: -- Bug#3385386 Added FTA record
2227: p_imm_fta in out nocopy ghr_api.fta_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2226: -- Bug#3385386 Added FTA record
2227: p_imm_fta in out nocopy ghr_api.fta_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2227: p_imm_fta in out nocopy ghr_api.fta_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2228: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2229: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2230: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2231: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2232: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2233: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2234: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2235: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2236: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2237: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2238: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2246: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2239: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2246: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2247: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
2240: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2246: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2247: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
2248: --BUG # 13571004 added TSP Roth
2241: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2246: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2247: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
2248: --BUG # 13571004 added TSP Roth
2249: p_tsp_roth in out nocopy ghr_api.tsp_roth_type,
2242: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2246: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2247: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
2248: --BUG # 13571004 added TSP Roth
2249: p_tsp_roth in out nocopy ghr_api.tsp_roth_type,
2250: --BUG # 14276354 added new Segments to Per Group2
2243: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2244: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2246: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2247: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
2248: --BUG # 13571004 added TSP Roth
2249: p_tsp_roth in out nocopy ghr_api.tsp_roth_type,
2250: --BUG # 14276354 added new Segments to Per Group2
2251: p_per_group2 in out nocopy ghr_api.per_group2_type --BUG # 14276354
2245: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2246: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2247: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
2248: --BUG # 13571004 added TSP Roth
2249: p_tsp_roth in out nocopy ghr_api.tsp_roth_type,
2250: --BUG # 14276354 added new Segments to Per Group2
2251: p_per_group2 in out nocopy ghr_api.per_group2_type --BUG # 14276354
2252: )
2253: --
2247: p_retirement_info in out nocopy ghr_api.per_retirement_info_type,
2248: --BUG # 13571004 added TSP Roth
2249: p_tsp_roth in out nocopy ghr_api.tsp_roth_type,
2250: --BUG # 14276354 added new Segments to Per Group2
2251: p_per_group2 in out nocopy ghr_api.per_group2_type --BUG # 14276354
2252: )
2253: --
2254: IS
2255: --
2259: l_noa_code ghr_nature_of_actions.code%type;
2260: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
2261: l_information_type ghr_pa_request_info_types.information_type%type;
2262: l_pa_request_ei_rec ghr_pa_request_extra_info%rowtype;
2263: p_extra_info_agency_rec ghr_api.extra_info_rec_type;
2264: l_session ghr_history_api.g_session_var_type;
2265: l_multiple_error_flag boolean;
2266: -- Bug#5668878
2267: l_psi VARCHAR2(10);
2389: p_update_flag in out nocopy varchar2,
2390: p_auto_populate_flag in varchar2 default 'N'
2391: ) is
2392: Begin
2393: If nvl(p_hr_extra_info,hr_api.g_varchar2)
2394: <> nvl(p_ghr_extra_info,hr_api.g_varchar2) then
2395: If p_auto_populate_flag = 'Y' and
2396: l_session.noa_id_correct is null then
2397: -- since it is autopopulated the user might have made it null
2390: p_auto_populate_flag in varchar2 default 'N'
2391: ) is
2392: Begin
2393: If nvl(p_hr_extra_info,hr_api.g_varchar2)
2394: <> nvl(p_ghr_extra_info,hr_api.g_varchar2) then
2395: If p_auto_populate_flag = 'Y' and
2396: l_session.noa_id_correct is null then
2397: -- since it is autopopulated the user might have made it null
2398: -- and is not a correction
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
2873: set_extra_info(p_asg_non_sf52.date_arr_personnel_office,
2874: l_pa_request_ei_rec.rei_information5, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2875: END IF;
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
2873: set_extra_info(p_asg_non_sf52.date_arr_personnel_office,
2874: l_pa_request_ei_rec.rei_information5, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2875: END IF;
2876: -- Bug#4126188 End
3547: -- -- Bug#4486823 RRR Changes
3548: --
3549: Procedure non_pay_duty_status is
3550: l_proc varchar2(72) := 'non_pay_duty_status';
3551: l_special_info_type ghr_api.special_information_type;
3552:
3553: Begin
3554: set_extra_info(p_per_group1.type_of_employment,
3555: l_pa_request_ei_rec.rei_information3,p_per_group1.per_group1_flag, 'Y');
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',
3785: 'LQ','MQ','RQ','VQ','WQ') then
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',
3785: 'LQ','MQ','RQ','VQ','WQ') then
3786: hr_utility.set_message(8301,'GHR_38030_INV_DS_4_NON_F_COLA');
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',
3792: 'FQ','GQ','HQ','JQ','KQ',
3793: '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',
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');
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',
4809: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4810: p_effective_date => nvl(p_pa_request_rec.effective_date,trunc(sysdate)) ,