[Home] [Help]
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_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_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_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_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_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_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_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_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_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
54: p_imm_per_probations out nocopy ghr_api.per_probations_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_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
48: p_imm_asg_nte_dates out nocopy ghr_api.asg_nte_dates_type,
49: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
56: p_imm_per_security out nocopy ghr_api.per_security_type,
49: p_imm_per_sf52 out nocopy ghr_api.per_sf52_type,
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
56: p_imm_per_security out nocopy ghr_api.per_security_type,
57: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
50: p_imm_per_group1 out nocopy ghr_api.per_group1_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
56: p_imm_per_security out nocopy ghr_api.per_security_type,
57: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
58: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
51: p_imm_per_group2 out nocopy ghr_api.per_group2_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
56: p_imm_per_security out nocopy ghr_api.per_security_type,
57: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
58: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
59: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
52: p_imm_per_scd_info out nocopy ghr_api.per_scd_info_type,
53: p_imm_per_retained_grade out nocopy ghr_api.per_retained_grade_type,
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
56: p_imm_per_security out nocopy ghr_api.per_security_type,
57: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
58: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
59: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
60: -- 4352589 BEN_EIT Changes
54: p_imm_per_probations out nocopy ghr_api.per_probations_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
56: p_imm_per_security out nocopy ghr_api.per_security_type,
57: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
58: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
59: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
60: -- 4352589 BEN_EIT Changes
61: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
55: p_imm_per_sep_retire out nocopy ghr_api.per_sep_retire_type,
56: p_imm_per_security out nocopy ghr_api.per_security_type,
57: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
58: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
59: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
60: -- 4352589 BEN_EIT Changes
61: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
57: -- Bug#4486823 RRR Changes Added p_imm_per_service_oblig
58: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
59: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
60: -- 4352589 BEN_EIT Changes
61: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
58: p_imm_per_service_oblig out nocopy ghr_api.per_service_oblig_type,
59: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
60: -- 4352589 BEN_EIT Changes
61: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
59: p_imm_per_conversions out nocopy ghr_api.per_conversions_type,
60: -- 4352589 BEN_EIT Changes
61: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
60: -- 4352589 BEN_EIT Changes
61: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
61: p_imm_per_benefit_info out nocopy ghr_api.per_benefit_info_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
62: p_imm_per_uniformed_services out nocopy ghr_api.per_uniformed_services_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
63: p_imm_pos_oblig out nocopy ghr_api.pos_oblig_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
64: p_imm_pos_grp2 out nocopy ghr_api.pos_grp2_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
72: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
65: p_imm_pos_grp1 out nocopy ghr_api.pos_grp1_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
72: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
73: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
66: p_imm_pos_valid_grade out nocopy ghr_api.pos_valid_grade_type,
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
72: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
73: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
74: -- Bug 4724337 Race or National Origin changes
67: p_imm_pos_car_prog out nocopy ghr_api.pos_car_prog_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
72: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
73: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
74: -- Bug 4724337 Race or National Origin changes
75: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
68: p_imm_loc_info out nocopy ghr_api.loc_info_type,
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
72: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
73: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
74: -- Bug 4724337 Race or National Origin changes
75: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
76: -- End race and National Origin changes
69: p_imm_wgi out nocopy ghr_api.within_grade_increase_type,
70: p_imm_gov_awards out nocopy ghr_api.government_awards_type,
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
72: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
73: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
74: -- Bug 4724337 Race or National Origin changes
75: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
76: -- End race and National Origin changes
77: --Pradeep
71: p_imm_recruitment_bonus out nocopy ghr_api.recruitment_bonus_type,
72: p_imm_relocation_bonus out nocopy ghr_api.relocation_bonus_type,
73: p_imm_student_loan_repay out nocopy ghr_api.student_loan_repay_type,
74: -- Bug 4724337 Race or National Origin changes
75: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
76: -- End race and National Origin changes
77: --Pradeep
78: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
79: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
74: -- Bug 4724337 Race or National Origin changes
75: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
76: -- End race and National Origin changes
77: --Pradeep
78: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
79: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
80:
81: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
75: p_imm_per_race_ethnic_info out nocopy ghr_api.per_race_ethnic_type,
76: -- End race and National Origin changes
77: --Pradeep
78: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
79: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
80:
81: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
77: --Pradeep
78: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
79: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
80:
81: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
78: p_imm_mddds_special_pay out nocopy ghr_api.mddds_special_pay_type,
79: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
80:
81: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
79: p_imm_premium_pay_ind out nocopy ghr_api.premium_pay_ind_type,
80:
81: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
80:
81: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
81: p_imm_payroll_type out nocopy ghr_api.government_payroll_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
82: p_imm_perf_appraisal out nocopy ghr_api.performance_appraisal_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
90: p_imm_entitlement out nocopy ghr_api.entitlement_type,
83: p_imm_conduct_performance out nocopy ghr_api.conduct_performance_type,
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
90: p_imm_entitlement out nocopy ghr_api.entitlement_type,
91: -- Bug#2759379 Added Fegli record
84: p_imm_extra_info_rec out nocopy ghr_api.extra_info_rec_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
90: p_imm_entitlement out nocopy ghr_api.entitlement_type,
91: -- Bug#2759379 Added Fegli record
92: p_imm_fegli out nocopy ghr_api.fegli_type,
85: p_imm_sf52_from_data out nocopy ghr_api.prior_sf52_data_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
90: p_imm_entitlement out nocopy ghr_api.entitlement_type,
91: -- Bug#2759379 Added Fegli record
92: p_imm_fegli out nocopy ghr_api.fegli_type,
93: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
86: p_imm_personal_info out nocopy ghr_api.personal_info_type,
87: p_imm_generic_extra_info_rec out nocopy ghr_api.generic_extra_info_rec_type,
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
90: p_imm_entitlement out nocopy ghr_api.entitlement_type,
91: -- Bug#2759379 Added Fegli record
92: p_imm_fegli out nocopy ghr_api.fegli_type,
93: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
94: -- Bug#3385386 Added FTA record
88: p_imm_agency_sf52 out nocopy ghr_api.agency_sf52_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
90: p_imm_entitlement out nocopy ghr_api.entitlement_type,
91: -- Bug#2759379 Added Fegli record
92: p_imm_fegli out nocopy ghr_api.fegli_type,
93: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
94: -- Bug#3385386 Added FTA record
95: p_imm_fta out nocopy ghr_api.fta_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
89: p_imm_par_term_retained_grade out nocopy ghr_api.par_term_retained_grade_type,
90: p_imm_entitlement out nocopy ghr_api.entitlement_type,
91: -- Bug#2759379 Added Fegli record
92: p_imm_fegli out nocopy ghr_api.fegli_type,
93: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
94: -- Bug#3385386 Added FTA record
95: p_imm_fta out nocopy ghr_api.fta_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
91: -- Bug#2759379 Added Fegli record
92: p_imm_fegli out nocopy ghr_api.fegli_type,
93: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
94: -- Bug#3385386 Added FTA record
95: p_imm_fta out nocopy ghr_api.fta_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
92: p_imm_fegli out nocopy ghr_api.fegli_type,
93: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
94: -- Bug#3385386 Added FTA record
95: p_imm_fta out nocopy ghr_api.fta_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
93: p_imm_foreign_lang_prof_pay out nocopy ghr_api.foreign_lang_prof_pay_type,
94: -- Bug#3385386 Added FTA record
95: p_imm_fta out nocopy ghr_api.fta_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
94: -- Bug#3385386 Added FTA record
95: p_imm_fta out nocopy ghr_api.fta_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
95: p_imm_fta out nocopy ghr_api.fta_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
96: p_imm_edp_pay out nocopy ghr_api.edp_pay_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
97: p_imm_hazard_pay out nocopy ghr_api.hazard_pay_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
98: p_imm_health_benefits out nocopy ghr_api.health_benefits_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
99: p_imm_danger_pay out nocopy ghr_api.danger_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
100: p_imm_imminent_danger_pay out nocopy ghr_api.imminent_danger_pay_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
101: p_imm_living_quarters_allow out nocopy ghr_api.living_quarters_allow_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
102: p_imm_post_diff_amt out nocopy ghr_api.post_diff_amt_type,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
110: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
103: p_imm_post_diff_percent out nocopy ghr_api.post_diff_percent_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
110: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
111: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
104: p_imm_sep_maintenance_allow out nocopy ghr_api.sep_maintenance_allow_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
110: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
111: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
112: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
105: p_imm_supplemental_post_allow out nocopy ghr_api.supplemental_post_allow_type,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
110: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
111: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
112: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
113: p_agency_code out nocopy varchar2,
106: p_imm_temp_lodge_allow out nocopy ghr_api.temp_lodge_allow_type,
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
110: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
111: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
112: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
113: p_agency_code out nocopy varchar2,
114: -- Bug#6312144 Added new RPA Benefit EIT
107: p_imm_premium_pay out nocopy ghr_api.premium_pay_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
110: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
111: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
112: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
113: p_agency_code out nocopy varchar2,
114: -- Bug#6312144 Added new RPA Benefit EIT
115: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
108: p_imm_retirement_annuity out nocopy ghr_api.retirement_annuity_type,
109: p_imm_severance_pay out nocopy ghr_api.severance_pay_type,
110: p_imm_thrift_saving_plan out nocopy ghr_api.thrift_saving_plan,
111: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
112: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
113: p_agency_code out nocopy varchar2,
114: -- Bug#6312144 Added new RPA Benefit EIT
115: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
116: p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type
111: p_imm_retention_allow_review out nocopy ghr_api.retention_allow_review_type,
112: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
113: p_agency_code out nocopy varchar2,
114: -- Bug#6312144 Added new RPA Benefit EIT
115: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
116: p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type
117: )
118: is
119:
112: p_imm_health_ben_pre_tax out nocopy ghr_api.health_ben_pre_tax_type,
113: p_agency_code out nocopy varchar2,
114: -- Bug#6312144 Added new RPA Benefit EIT
115: p_imm_ipa_benefits_cont out nocopy ghr_api.per_ipa_ben_cont_info_type,
116: p_imm_retirement_info out nocopy ghr_api.per_retirement_info_type
117: )
118: is
119:
120: -- Cursor to select the person's sex which is required for CPDF Edits
178: from per_all_assignments_f asg
179: Where asg.assignment_id = p_pa_request_rec.employee_assignment_id
180: order by 1 desc;
181:
182: l_imm_asg_sf52 ghr_api.asg_sf52_type;
183: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
184: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
179: Where asg.assignment_id = p_pa_request_rec.employee_assignment_id
180: order by 1 desc;
181:
182: l_imm_asg_sf52 ghr_api.asg_sf52_type;
183: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
184: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
180: order by 1 desc;
181:
182: l_imm_asg_sf52 ghr_api.asg_sf52_type;
183: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
184: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
181:
182: l_imm_asg_sf52 ghr_api.asg_sf52_type;
183: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
184: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
182: l_imm_asg_sf52 ghr_api.asg_sf52_type;
183: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
184: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
190: l_imm_per_probations ghr_api.per_probations_type;
183: l_imm_asg_non_sf52 ghr_api.asg_non_sf52_type;
184: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
190: l_imm_per_probations ghr_api.per_probations_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
184: l_imm_asg_nte_dates ghr_api.asg_nte_dates_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
190: l_imm_per_probations ghr_api.per_probations_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
192: l_imm_per_security ghr_api.per_security_type;
185: l_imm_per_sf52 ghr_api.per_sf52_type;
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
190: l_imm_per_probations ghr_api.per_probations_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
192: l_imm_per_security ghr_api.per_security_type;
193: -- Bug#4486823 RRR changes
186: l_imm_per_group1 ghr_api.per_group1_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
190: l_imm_per_probations ghr_api.per_probations_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
192: l_imm_per_security ghr_api.per_security_type;
193: -- Bug#4486823 RRR changes
194: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
187: l_imm_per_group2 ghr_api.per_group2_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
190: l_imm_per_probations ghr_api.per_probations_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
192: l_imm_per_security ghr_api.per_security_type;
193: -- Bug#4486823 RRR changes
194: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
195: l_imm_per_conversions ghr_api.per_conversions_type;
188: l_imm_per_scd_info ghr_api.per_scd_info_type;
189: l_imm_per_retained_grade ghr_api.per_retained_grade_type;
190: l_imm_per_probations ghr_api.per_probations_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
192: l_imm_per_security ghr_api.per_security_type;
193: -- Bug#4486823 RRR changes
194: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
195: l_imm_per_conversions ghr_api.per_conversions_type;
196: -- 4352589 BEN_EIT Changes
190: l_imm_per_probations ghr_api.per_probations_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
192: l_imm_per_security ghr_api.per_security_type;
193: -- Bug#4486823 RRR changes
194: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
195: l_imm_per_conversions ghr_api.per_conversions_type;
196: -- 4352589 BEN_EIT Changes
197: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
191: l_imm_per_sep_retire ghr_api.per_sep_retire_type;
192: l_imm_per_security ghr_api.per_security_type;
193: -- Bug#4486823 RRR changes
194: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
195: l_imm_per_conversions ghr_api.per_conversions_type;
196: -- 4352589 BEN_EIT Changes
197: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
193: -- Bug#4486823 RRR changes
194: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
195: l_imm_per_conversions ghr_api.per_conversions_type;
196: -- 4352589 BEN_EIT Changes
197: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
194: l_imm_per_service_oblig ghr_api.per_service_oblig_type;
195: l_imm_per_conversions ghr_api.per_conversions_type;
196: -- 4352589 BEN_EIT Changes
197: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
195: l_imm_per_conversions ghr_api.per_conversions_type;
196: -- 4352589 BEN_EIT Changes
197: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
196: -- 4352589 BEN_EIT Changes
197: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
197: l_imm_per_benefit_info ghr_api.per_benefit_info_type;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
198: l_imm_per_uniformed_services ghr_api.per_uniformed_services_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
199: l_imm_pos_oblig ghr_api.pos_oblig_type;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
200: l_imm_pos_grp2 ghr_api.pos_grp2_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
201: l_imm_pos_grp1 ghr_api.pos_grp1_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
209: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
202: l_imm_pos_valid_grade ghr_api.pos_valid_grade_type;
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
209: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
210:
203: l_imm_pos_car_prog ghr_api.pos_car_prog_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
209: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
210:
211: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
204: l_imm_loc_info ghr_api.loc_info_type;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
209: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
210:
211: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
212: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
205: l_imm_wgi ghr_api.within_grade_increase_type ;
206: l_imm_gov_awards ghr_api.government_awards_type;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
209: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
210:
211: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
212: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
213: l_pos_extra_info_rec per_position_extra_info%rowtype;
207: l_imm_recruitment_bonus ghr_api.recruitment_bonus_type ;
208: l_imm_relocation_bonus ghr_api.relocation_bonus_type;
209: l_imm_student_loan_repay ghr_api.student_loan_repay_type;
210:
211: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
212: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
213: l_pos_extra_info_rec per_position_extra_info%rowtype;
214: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
215: l_imm_personal_info ghr_api.personal_info_type;
210:
211: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
212: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
213: l_pos_extra_info_rec per_position_extra_info%rowtype;
214: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
215: l_imm_personal_info ghr_api.personal_info_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
211: l_imm_extra_info_rec ghr_api.extra_info_rec_type;
212: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
213: l_pos_extra_info_rec per_position_extra_info%rowtype;
214: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
215: l_imm_personal_info ghr_api.personal_info_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
212: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
213: l_pos_extra_info_rec per_position_extra_info%rowtype;
214: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
215: l_imm_personal_info ghr_api.personal_info_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
213: l_pos_extra_info_rec per_position_extra_info%rowtype;
214: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
215: l_imm_personal_info ghr_api.personal_info_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
221: l_imm_entitlement ghr_api.entitlement_type;
214: l_imm_sf52_from_data ghr_api.prior_sf52_data_type;
215: l_imm_personal_info ghr_api.personal_info_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
221: l_imm_entitlement ghr_api.entitlement_type;
222: --Bug#2759379 Added Fegli record
215: l_imm_personal_info ghr_api.personal_info_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
221: l_imm_entitlement ghr_api.entitlement_type;
222: --Bug#2759379 Added Fegli record
223: l_imm_fegli ghr_api.fegli_type;
216: l_imm_generic_extra_info_rec ghr_api.generic_extra_info_rec_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
221: l_imm_entitlement ghr_api.entitlement_type;
222: --Bug#2759379 Added Fegli record
223: l_imm_fegli ghr_api.fegli_type;
224: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
217: l_imm_agency_sf52 ghr_api.agency_sf52_type;
218: l_imm_payroll_type ghr_api.government_payroll_type;
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
221: l_imm_entitlement ghr_api.entitlement_type;
222: --Bug#2759379 Added Fegli record
223: l_imm_fegli ghr_api.fegli_type;
224: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
225: -- Bug#3385386 declared FTA record type variable
219: l_imm_perf_appraisal ghr_api.performance_appraisal_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
221: l_imm_entitlement ghr_api.entitlement_type;
222: --Bug#2759379 Added Fegli record
223: l_imm_fegli ghr_api.fegli_type;
224: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
225: -- Bug#3385386 declared FTA record type variable
226: l_imm_fta ghr_api.fta_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
220: l_imm_conduct_performance ghr_api.conduct_performance_type;
221: l_imm_entitlement ghr_api.entitlement_type;
222: --Bug#2759379 Added Fegli record
223: l_imm_fegli ghr_api.fegli_type;
224: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
225: -- Bug#3385386 declared FTA record type variable
226: l_imm_fta ghr_api.fta_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
222: --Bug#2759379 Added Fegli record
223: l_imm_fegli ghr_api.fegli_type;
224: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
225: -- Bug#3385386 declared FTA record type variable
226: l_imm_fta ghr_api.fta_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
223: l_imm_fegli ghr_api.fegli_type;
224: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
225: -- Bug#3385386 declared FTA record type variable
226: l_imm_fta ghr_api.fta_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
224: l_imm_foreign_lang_prof_pay ghr_api.foreign_lang_prof_pay_type;
225: -- Bug#3385386 declared FTA record type variable
226: l_imm_fta ghr_api.fta_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
225: -- Bug#3385386 declared FTA record type variable
226: l_imm_fta ghr_api.fta_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
226: l_imm_fta ghr_api.fta_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
227: l_imm_edp_pay ghr_api.edp_pay_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
228: l_imm_hazard_pay ghr_api.hazard_pay_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
229: l_imm_health_benefits ghr_api.health_benefits_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
230: l_imm_danger_pay ghr_api.danger_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
231: l_imm_imminent_danger_pay ghr_api.imminent_danger_pay_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
232: l_imm_living_quarters_allow ghr_api.living_quarters_allow_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
233: l_imm_post_diff_amt ghr_api.post_diff_amt_type;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
234: l_imm_post_diff_percent ghr_api.post_diff_percent_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
235: l_imm_sep_maintenance_allow ghr_api.sep_maintenance_allow_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
243: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
236: l_imm_supplemental_post_allow ghr_api.supplemental_post_allow_type;
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
243: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
244: l_agency_code varchar2(50);
237: l_imm_temp_lodge_allow ghr_api.temp_lodge_allow_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
243: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
244: l_agency_code varchar2(50);
245: l_special_info_type ghr_api.special_information_type;
238: l_imm_premium_pay ghr_api.premium_pay_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
243: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
244: l_agency_code varchar2(50);
245: l_special_info_type ghr_api.special_information_type;
246: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
239: l_imm_retirement_annuity ghr_api.retirement_annuity_type;
240: l_imm_severance_pay ghr_api.severance_pay_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
243: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
244: l_agency_code varchar2(50);
245: l_special_info_type ghr_api.special_information_type;
246: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
247: l_session ghr_history_api.g_session_var_type;
241: l_imm_thrift_saving_plan ghr_api.thrift_saving_plan;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
243: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
244: l_agency_code varchar2(50);
245: l_special_info_type ghr_api.special_information_type;
246: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
247: l_session ghr_history_api.g_session_var_type;
248: l_asg_ei_data per_assignment_extra_info%rowtype;
249: l_assignment_data per_all_assignments_f%rowtype;
242: l_imm_retention_allow_review ghr_api.retention_allow_review_type;
243: l_imm_health_ben_pre_tax ghr_api.health_ben_pre_tax_type;
244: l_agency_code varchar2(50);
245: l_special_info_type ghr_api.special_information_type;
246: l_imm_par_term_retained_grade ghr_api.par_term_retained_grade_type;
247: l_session ghr_history_api.g_session_var_type;
248: l_asg_ei_data per_assignment_extra_info%rowtype;
249: l_assignment_data per_all_assignments_f%rowtype;
250: l_result_code varchar2(50);
252: l_effective_date date;
253: -- Bug#4054110
254: l_temp_rec_level varchar2(30);
255: --Pradeep
256: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
257: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
258: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
259: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
260: l_imm_retirement_info ghr_api.per_retirement_info_type;
253: -- Bug#4054110
254: l_temp_rec_level varchar2(30);
255: --Pradeep
256: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
257: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
258: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
259: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
260: l_imm_retirement_info ghr_api.per_retirement_info_type;
261:
254: l_temp_rec_level varchar2(30);
255: --Pradeep
256: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
257: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
258: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
259: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
260: l_imm_retirement_info ghr_api.per_retirement_info_type;
261:
262:
255: --Pradeep
256: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
257: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
258: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
259: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
260: l_imm_retirement_info ghr_api.per_retirement_info_type;
261:
262:
263:
256: l_imm_mddds_special_pay ghr_api.mddds_special_pay_type;
257: l_imm_premium_pay_ind ghr_api.premium_pay_ind_type;
258: l_imm_per_race_ethnic_info ghr_api.per_race_ethnic_type; -- Bug 4724337 Race or National Origin changes
259: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;
260: l_imm_retirement_info ghr_api.per_retirement_info_type;
261:
262:
263:
264: Begin
507:
508: If l_session.noa_id_correct is null then
509: hr_utility.set_location('populate_record_groups ', 30);
510:
511: ghr_api.return_special_information
512: (p_person_id => p_pa_request_rec.person_id,
513: p_structure_name => 'US Fed Perf Appraisal',
514: p_effective_date => p_pa_request_rec.effective_date,
515: p_special_info => l_special_info_type
581: perf_appraisal.appr_sys_ident is not null or
582: perf_appraisal.optional_info is not null or
583: perf_appraisal.performance_rating_points is not null then*/
584:
585: if nvl(perf_appraisal.rat_rec,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.rating_rec,hr_api.g_varchar2) then
586: l_imm_perf_appraisal.rating_rec := perf_appraisal.rat_rec;
587: l_imm_perf_appraisal.perf_appr_flag := 'Y';
588: end if;
589: if nvl(perf_appraisal.rec_pattern,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.rating_rec_pattern,hr_api.g_varchar2) then
585: if nvl(perf_appraisal.rat_rec,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.rating_rec,hr_api.g_varchar2) then
586: l_imm_perf_appraisal.rating_rec := perf_appraisal.rat_rec;
587: l_imm_perf_appraisal.perf_appr_flag := 'Y';
588: end if;
589: if nvl(perf_appraisal.rec_pattern,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.rating_rec_pattern,hr_api.g_varchar2) then
590: l_imm_perf_appraisal.rating_rec_pattern := perf_appraisal.rec_pattern;
591: l_imm_perf_appraisal.perf_appr_flag := 'Y';
592: end if;
593:
591: l_imm_perf_appraisal.perf_appr_flag := 'Y';
592: end if;
593:
594: -- Reverted the changes done by Pradeep for bug#4054110.
595: if nvl(perf_appraisal.rec_level,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.rating_rec_level,hr_api.g_varchar2) then
596: l_imm_perf_appraisal.rating_rec_level := perf_appraisal.rec_level;
597: l_imm_perf_appraisal.perf_appr_flag := 'Y';
598: end if;
599:
596: l_imm_perf_appraisal.rating_rec_level := perf_appraisal.rec_level;
597: l_imm_perf_appraisal.perf_appr_flag := 'Y';
598: end if;
599:
600: if nvl(perf_appraisal.app_ends,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.date_appr_ends,hr_api.g_varchar2) then
601: l_imm_perf_appraisal.date_appr_ends := perf_appraisal.app_ends;
602: l_imm_perf_appraisal.perf_appr_flag := 'Y';
603: end if;
604: --Bug# 4753117 28-Feb-07 Veeramani assigning appraisal start date
601: l_imm_perf_appraisal.date_appr_ends := perf_appraisal.app_ends;
602: l_imm_perf_appraisal.perf_appr_flag := 'Y';
603: end if;
604: --Bug# 4753117 28-Feb-07 Veeramani assigning appraisal start date
605: if nvl(perf_appraisal.app_starts,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.date_appr_starts,hr_api.g_varchar2) then
606: l_imm_perf_appraisal.date_appr_starts := perf_appraisal.app_starts;
607: l_imm_perf_appraisal.perf_appr_flag := 'Y';
608: end if;
609:
606: l_imm_perf_appraisal.date_appr_starts := perf_appraisal.app_starts;
607: l_imm_perf_appraisal.perf_appr_flag := 'Y';
608: end if;
609:
610: if nvl(perf_appraisal.app_type,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.appraisal_type,hr_api.g_varchar2) then
611: l_imm_perf_appraisal.appraisal_type := perf_appraisal.app_type;
612: l_imm_perf_appraisal.perf_appr_flag := 'Y';
613: end if;
614: 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
610: if nvl(perf_appraisal.app_type,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.appraisal_type,hr_api.g_varchar2) then
611: l_imm_perf_appraisal.appraisal_type := perf_appraisal.app_type;
612: l_imm_perf_appraisal.perf_appr_flag := 'Y';
613: end if;
614: 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
615: l_imm_perf_appraisal.date_init_appr_due := perf_appraisal.date_init_appr_due;
616: l_imm_perf_appraisal.perf_appr_flag := 'Y';
617: end if;
618: if nvl(perf_appraisal.date_effective,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.date_effective,hr_api.g_varchar2) then
614: 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
615: l_imm_perf_appraisal.date_init_appr_due := perf_appraisal.date_init_appr_due;
616: l_imm_perf_appraisal.perf_appr_flag := 'Y';
617: end if;
618: if nvl(perf_appraisal.date_effective,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.date_effective,hr_api.g_varchar2) then
619: l_imm_perf_appraisal.date_effective := perf_appraisal.date_effective;
620: l_imm_perf_appraisal.perf_appr_flag := 'Y';
621: end if;
622: if nvl(perf_appraisal.unit,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.unit,hr_api.g_varchar2) then
618: if nvl(perf_appraisal.date_effective,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.date_effective,hr_api.g_varchar2) then
619: l_imm_perf_appraisal.date_effective := perf_appraisal.date_effective;
620: l_imm_perf_appraisal.perf_appr_flag := 'Y';
621: end if;
622: if nvl(perf_appraisal.unit,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.unit,hr_api.g_varchar2) then
623: l_imm_perf_appraisal.unit := perf_appraisal.unit;
624: l_imm_perf_appraisal.perf_appr_flag := 'Y';
625: end if;
626: if nvl(perf_appraisal.org_str_id,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.org_structure_id,hr_api.g_varchar2) then
622: if nvl(perf_appraisal.unit,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.unit,hr_api.g_varchar2) then
623: l_imm_perf_appraisal.unit := perf_appraisal.unit;
624: l_imm_perf_appraisal.perf_appr_flag := 'Y';
625: end if;
626: if nvl(perf_appraisal.org_str_id,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.org_structure_id,hr_api.g_varchar2) then
627: l_imm_perf_appraisal.org_structure_id := perf_appraisal.org_str_id;
628: l_imm_perf_appraisal.perf_appr_flag := 'Y';
629: end if;
630: if nvl(perf_appraisal.off_symbol,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.office_symbol,hr_api.g_varchar2) then
626: if nvl(perf_appraisal.org_str_id,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.org_structure_id,hr_api.g_varchar2) then
627: l_imm_perf_appraisal.org_structure_id := perf_appraisal.org_str_id;
628: l_imm_perf_appraisal.perf_appr_flag := 'Y';
629: end if;
630: if nvl(perf_appraisal.off_symbol,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.office_symbol,hr_api.g_varchar2) then
631: l_imm_perf_appraisal.office_symbol := perf_appraisal.off_symbol;
632: l_imm_perf_appraisal.perf_appr_flag := 'Y';
633: end if;
634: if nvl(perf_appraisal.pay_plan,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.pay_plan,hr_api.g_varchar2) then
630: if nvl(perf_appraisal.off_symbol,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.office_symbol,hr_api.g_varchar2) then
631: l_imm_perf_appraisal.office_symbol := perf_appraisal.off_symbol;
632: l_imm_perf_appraisal.perf_appr_flag := 'Y';
633: end if;
634: if nvl(perf_appraisal.pay_plan,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.pay_plan,hr_api.g_varchar2) then
635: l_imm_perf_appraisal.pay_plan := perf_appraisal.pay_plan;
636: l_imm_perf_appraisal.perf_appr_flag := 'Y';
637: end if;
638: if nvl(perf_appraisal.grade,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.grade,hr_api.g_varchar2) then
634: if nvl(perf_appraisal.pay_plan,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.pay_plan,hr_api.g_varchar2) then
635: l_imm_perf_appraisal.pay_plan := perf_appraisal.pay_plan;
636: l_imm_perf_appraisal.perf_appr_flag := 'Y';
637: end if;
638: if nvl(perf_appraisal.grade,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.grade,hr_api.g_varchar2) then
639: l_imm_perf_appraisal.grade := perf_appraisal.grade;
640: l_imm_perf_appraisal.perf_appr_flag := 'Y';
641: end if;
642: if nvl(perf_appraisal.date_due,hr_api.g_varchar2) <>nvl(l_imm_perf_appraisal.date_due,hr_api.g_varchar2) then
638: if nvl(perf_appraisal.grade,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.grade,hr_api.g_varchar2) then
639: l_imm_perf_appraisal.grade := perf_appraisal.grade;
640: l_imm_perf_appraisal.perf_appr_flag := 'Y';
641: end if;
642: if nvl(perf_appraisal.date_due,hr_api.g_varchar2) <>nvl(l_imm_perf_appraisal.date_due,hr_api.g_varchar2) then
643: l_imm_perf_appraisal.date_due := perf_appraisal.date_due;
644: l_imm_perf_appraisal.perf_appr_flag := 'Y';
645: end if;
646: if nvl(perf_appraisal.appr_sys_ident,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.appraisal_system_identifier,hr_api.g_varchar2) then
642: if nvl(perf_appraisal.date_due,hr_api.g_varchar2) <>nvl(l_imm_perf_appraisal.date_due,hr_api.g_varchar2) then
643: l_imm_perf_appraisal.date_due := perf_appraisal.date_due;
644: l_imm_perf_appraisal.perf_appr_flag := 'Y';
645: end if;
646: if nvl(perf_appraisal.appr_sys_ident,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.appraisal_system_identifier,hr_api.g_varchar2) then
647: l_imm_perf_appraisal.appraisal_system_identifier := perf_appraisal.appr_sys_ident;
648: l_imm_perf_appraisal.perf_appr_flag := 'Y';
649: end if;
650: if nvl(perf_appraisal.optional_info,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.optional_information,hr_api.g_varchar2) then
646: if nvl(perf_appraisal.appr_sys_ident,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.appraisal_system_identifier,hr_api.g_varchar2) then
647: l_imm_perf_appraisal.appraisal_system_identifier := perf_appraisal.appr_sys_ident;
648: l_imm_perf_appraisal.perf_appr_flag := 'Y';
649: end if;
650: if nvl(perf_appraisal.optional_info,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.optional_information,hr_api.g_varchar2) then
651: l_imm_perf_appraisal.optional_information := perf_appraisal.optional_info;
652: l_imm_perf_appraisal.perf_appr_flag := 'Y';
653: end if;
654:
653: end if;
654:
655: hr_utility.set_location('performance_rating_points'||perf_appraisal.performance_rating_points, 41);
656:
657: if nvl(perf_appraisal.performance_rating_points,hr_api.g_varchar2) <> nvl(l_imm_perf_appraisal.performance_rating_points,hr_api.g_varchar2) then
658: l_imm_perf_appraisal.performance_rating_points := perf_appraisal.performance_rating_points;
659: l_imm_perf_appraisal.perf_appr_flag := 'Y';
660: end if;
661: l_temp_rec_level := perf_appraisal.rec_level;
660: end if;
661: l_temp_rec_level := perf_appraisal.rec_level;
662: -- end if;
663: end loop;
664: If l_session.noa_id_correct is null and nvl(l_imm_perf_appraisal.perf_appr_flag ,hr_api.g_varchar2) = 'Y' then
665: l_imm_perf_appraisal.person_analysis_id := Null;
666: end if;
667: -- Bug#4054110,4069798
668: l_imm_perf_appraisal.rating_rec_level := l_temp_rec_level;
757: --
758:
759: Procedure retrieve_all_extra_info
760: (p_pa_request_rec in ghr_pa_requests%rowtype,
761: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
762: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
763: p_per_group1 in out nocopy ghr_api.per_group1_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
758:
759: Procedure retrieve_all_extra_info
760: (p_pa_request_rec in ghr_pa_requests%rowtype,
761: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
762: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
763: p_per_group1 in out nocopy ghr_api.per_group1_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
759: Procedure retrieve_all_extra_info
760: (p_pa_request_rec in ghr_pa_requests%rowtype,
761: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
762: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
763: p_per_group1 in out nocopy ghr_api.per_group1_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
760: (p_pa_request_rec in ghr_pa_requests%rowtype,
761: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
762: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
763: p_per_group1 in out nocopy ghr_api.per_group1_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
761: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
762: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
763: p_per_group1 in out nocopy ghr_api.per_group1_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
762: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
763: p_per_group1 in out nocopy ghr_api.per_group1_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
770: -- 4352589 BEN_EIT Changes
763: p_per_group1 in out nocopy ghr_api.per_group1_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
770: -- 4352589 BEN_EIT Changes
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
764: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
770: -- 4352589 BEN_EIT Changes
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
765: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
766: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
770: -- 4352589 BEN_EIT Changes
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
773: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
767: p_loc_info in out nocopy ghr_api.loc_info_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
770: -- 4352589 BEN_EIT Changes
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
773: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
774: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
775: p_per_probations in out nocopy ghr_api.per_probations_type,
768: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
770: -- 4352589 BEN_EIT Changes
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
773: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
774: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
775: p_per_probations in out nocopy ghr_api.per_probations_type,
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
769: p_per_conversions in out nocopy ghr_api.per_conversions_type,
770: -- 4352589 BEN_EIT Changes
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
773: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
774: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
775: p_per_probations in out nocopy ghr_api.per_probations_type,
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
777: --Bug#4486823 RRR Changes
770: -- 4352589 BEN_EIT Changes
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
773: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
774: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
775: p_per_probations in out nocopy ghr_api.per_probations_type,
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
777: --Bug#4486823 RRR Changes
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
771: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
773: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
774: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
775: p_per_probations in out nocopy ghr_api.per_probations_type,
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
777: --Bug#4486823 RRR Changes
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
779: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
772: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
773: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
774: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
775: p_per_probations in out nocopy ghr_api.per_probations_type,
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
777: --Bug#4486823 RRR Changes
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
779: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
780: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
774: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
775: p_per_probations in out nocopy ghr_api.per_probations_type,
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
777: --Bug#4486823 RRR Changes
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
779: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
780: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
781: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
782: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
775: p_per_probations in out nocopy ghr_api.per_probations_type,
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
777: --Bug#4486823 RRR Changes
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
779: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
780: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
781: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
782: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
783: --Bug #6312144 RPA EIT Benefits
776: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
777: --Bug#4486823 RRR Changes
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
779: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
780: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
781: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
782: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
783: --Bug #6312144 RPA EIT Benefits
784: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
777: --Bug#4486823 RRR Changes
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
779: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
780: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
781: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
782: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
783: --Bug #6312144 RPA EIT Benefits
784: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
785: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
778: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
779: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
780: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
781: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
782: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
783: --Bug #6312144 RPA EIT Benefits
784: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
785: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
786: )
780: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type ,
781: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
782: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
783: --Bug #6312144 RPA EIT Benefits
784: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
785: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
786: )
787: is
788: l_per_extra_info_rec per_people_extra_info%rowtype;
781: p_pos_oblig in out nocopy ghr_api.pos_oblig_type,
782: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
783: --Bug #6312144 RPA EIT Benefits
784: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
785: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
786: )
787: is
788: l_per_extra_info_rec per_people_extra_info%rowtype;
789: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
788: l_per_extra_info_rec per_people_extra_info%rowtype;
789: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
790: l_pos_extra_info_rec per_position_extra_info%rowtype;
791: l_proc varchar2(70) := 'Retrieve_all_extra_info';
792: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;
793: l_position_id per_positions.position_id%type;
794: l_retained_grade_rec ghr_pay_calc.retained_grade_rec_type;
795: l_session ghr_history_api.g_session_var_type;
796: l_person_status per_assignment_status_types.user_status%type;
1216: p_per_separate_retire.agency_code_transfer_to := l_per_extra_info_rec.pei_information8;
1217: p_per_separate_retire.date_projected_retirement := l_per_extra_info_rec.pei_information9;
1218: p_per_separate_retire.mandatory_retirement_date := l_per_extra_info_rec.pei_information10;
1219: --Start Bug 1359482
1220: If nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) in ('300','301','302','303','304') then
1221: hr_utility.set_location('separate_pkg_status_indicator defaults to 1',14);
1222: p_per_separate_retire.separate_pkg_status_indicator := '1';
1223: p_per_separate_retire.per_sep_retire_flag := 'Y';
1224: else
1614: p_pa_request_rec.noa_family_code = 'REALIGNMENT' and
1615: l_agency_code is not null then
1616: p_agency_code := l_agency_code;
1617: else
1618: p_agency_code := ghr_api.get_position_agency_code_pos
1619: (p_position_id => l_position_id
1620: ,p_business_group_id => l_bus_gp
1621: ,p_effective_date => p_pa_request_rec.effective_date
1622: );
1633: -- This procedure Updates the various Record Groups with Data from the SF52 Form.
1634:
1635: procedure Process_Sf52_Extra_Info
1636: (p_pa_request_rec in ghr_pa_requests%rowtype,
1637: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1638: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1639: p_per_group1 in out nocopy ghr_api.per_group1_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1634:
1635: procedure Process_Sf52_Extra_Info
1636: (p_pa_request_rec in ghr_pa_requests%rowtype,
1637: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1638: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1639: p_per_group1 in out nocopy ghr_api.per_group1_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1635: procedure Process_Sf52_Extra_Info
1636: (p_pa_request_rec in ghr_pa_requests%rowtype,
1637: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1638: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1639: p_per_group1 in out nocopy ghr_api.per_group1_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1636: (p_pa_request_rec in ghr_pa_requests%rowtype,
1637: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1638: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1639: p_per_group1 in out nocopy ghr_api.per_group1_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1637: p_asg_sf52 in out nocopy ghr_api.asg_sf52_type,
1638: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1639: p_per_group1 in out nocopy ghr_api.per_group1_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1638: p_per_sf52 in out nocopy ghr_api.per_sf52_type,
1639: p_per_group1 in out nocopy ghr_api.per_group1_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1646: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1639: p_per_group1 in out nocopy ghr_api.per_group1_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1646: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1647: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1640: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1646: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1647: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1648: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1641: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1646: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1647: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1648: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1649: is
1642: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1646: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1647: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1648: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1649: is
1650: --
1643: p_loc_info in out nocopy ghr_api.loc_info_type,
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1646: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1647: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1648: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1649: is
1650: --
1651: l_noa_code ghr_nature_of_actions.code%type;
1644: p_recruitment_bonus in out nocopy ghr_api.recruitment_bonus_type ,
1645: p_relocation_bonus in out nocopy ghr_api.relocation_bonus_type,
1646: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
1647: p_extra_info_rec in out nocopy ghr_api.extra_info_rec_type,
1648: p_valid_grade in out nocopy ghr_api.pos_valid_grade_type)
1649: is
1650: --
1651: l_noa_code ghr_nature_of_actions.code%type;
1652: l_proc varchar2(70) := 'Process_Sf52_Extra_Info';
1672: and information_type = l_information_type; */
1673: --
1674: /*l_payroll_office_id ghr_pa_request_extra_info.rei_information4%type;
1675: l_pos_org ghr_pa_request_extra_info.rei_information8%type;*/
1676: l_student_loan_repay ghr_api.student_loan_repay_type;
1677:
1678: --Bug 6881863
1679: l_calc_table_id pay_user_tables.user_table_id%type;
1680: --
1707: --
1708: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,1);
1709: If p_pa_request_rec.to_step_or_rate is not null then
1710: If P_pa_request_rec.to_step_or_rate <>
1711: nvl(p_asg_sf52.step_or_rate,hr_api.g_varchar2) then
1712: hr_utility.set_location(l_proc,20);
1713: p_Asg_sf52.Asg_sf52_flag := 'Y';
1714: p_Asg_Sf52.Step_Or_Rate := P_pa_request_rec.to_Step_Or_Rate;
1715: End if;
1722:
1723:
1724: If p_pa_request_rec.tenure is not null then
1725: If P_pa_request_rec.Tenure <>
1726: nvl(p_asg_sf52.tenure,hr_api.g_varchar2) then
1727: hr_utility.set_location(l_proc,25);
1728: p_asg_sf52.asg_sf52_flag := 'Y';
1729: P_Asg_Sf52.Tenure := P_pa_request_rec.Tenure ;
1730: End if;
1733: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,3);
1734:
1735: If p_pa_request_rec.annuitant_indicator is not null then
1736: If P_pa_request_rec.Annuitant_Indicator <>
1737: nvl(p_asg_sf52.annuitant_indicator,hr_api.g_varchar2)then
1738: hr_utility.set_location(l_proc,30);
1739: p_asg_sf52.asg_sf52_flag := 'Y';
1740: P_Asg_Sf52.Annuitant_Indicator := P_pa_request_rec.Annuitant_Indicator;
1741: End if;
1744: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,4);
1745:
1746: If p_pa_request_rec.pay_rate_determinant is not null then
1747: If P_pa_request_rec.Pay_Rate_Determinant<>
1748: nvl(p_asg_sf52.pay_rate_determinant,hr_api.g_varchar2) then
1749: hr_utility.set_location(l_proc,35);
1750: p_asg_sf52.asg_sf52_flag := 'Y';
1751: p_Asg_Sf52.Pay_Rate_Determinant := P_pa_request_rec.Pay_Rate_Determinant;
1752: End if;
1753: End if;
1754: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,5);
1755: End if;
1756:
1757: If nvl(P_pa_request_rec.work_schedule,hr_api.g_varchar2) <>
1758: nvl(p_asg_sf52.work_schedule,hr_api.g_varchar2) then
1759: hr_utility.set_location(l_proc,35);
1760: p_asg_sf52.asg_sf52_flag := 'Y';
1761: p_Asg_Sf52.work_schedule := P_pa_request_rec.work_schedule;
1754: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,5);
1755: End if;
1756:
1757: If nvl(P_pa_request_rec.work_schedule,hr_api.g_varchar2) <>
1758: nvl(p_asg_sf52.work_schedule,hr_api.g_varchar2) then
1759: hr_utility.set_location(l_proc,35);
1760: p_asg_sf52.asg_sf52_flag := 'Y';
1761: p_Asg_Sf52.work_schedule := P_pa_request_rec.work_schedule;
1762: End if;
1762: End if;
1763:
1764: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,6);
1765:
1766: If nvl(P_pa_request_rec.part_time_hours,hr_api.g_number) <>
1767: nvl(p_asg_sf52.part_time_hours,hr_api.g_number) then
1768: hr_utility.set_location(l_proc,35);
1769: p_asg_sf52.asg_sf52_flag := 'Y';
1770: p_Asg_Sf52.part_time_hours := P_pa_request_rec.part_time_hours;
1763:
1764: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,6);
1765:
1766: If nvl(P_pa_request_rec.part_time_hours,hr_api.g_number) <>
1767: nvl(p_asg_sf52.part_time_hours,hr_api.g_number) then
1768: hr_utility.set_location(l_proc,35);
1769: p_asg_sf52.asg_sf52_flag := 'Y';
1770: p_Asg_Sf52.part_time_hours := P_pa_request_rec.part_time_hours;
1771: End if;
1779:
1780: hr_utility.set_location('ASG FLAG ' || p_asg_sf52.asg_sf52_flag,6);
1781: If p_pa_request_rec.to_pay_table_identifier is not null then
1782: If P_pa_request_rec.to_pay_table_identifier <>
1783: nvl(p_asg_sf52.calc_pay_table,hr_api.g_number)then
1784: hr_utility.set_location(l_proc,30);
1785: p_asg_sf52.asg_sf52_flag := 'Y';
1786: P_Asg_Sf52.calc_pay_table := P_pa_request_rec.to_pay_table_identifier;
1787: End if;
1819: hr_utility.set_location(l_proc,55);
1820: --
1821: --
1822: If p_pa_request_rec.citizenship is not null then
1823: If p_pa_request_rec.Citizenship <> nvl(p_per_sf52.citizenship,hr_api.g_varchar2) then
1824: hr_utility.set_location(l_proc,65);
1825: P_Per_sf52.Per_Sf52_Flag := 'Y';
1826: P_Per_sf52.Citizenship := P_pa_request_rec.Citizenship;
1827: End if;
1828: End if;
1829: --
1830: If p_pa_request_rec.veterans_preference is not null then
1831: If P_pa_request_rec.Veterans_Preference <>
1832: nvl(p_per_sf52.veterans_preference,hr_api.g_varchar2) then
1833: hr_utility.set_location(l_proc,70);
1834: P_Per_sf52.Per_Sf52_Flag := 'Y';
1835: P_Per_sf52.Veterans_Preference := P_pa_request_rec.Veterans_Preference;
1836: End if;
1837: End if;
1838:
1839: If p_pa_request_rec.veterans_pref_for_rif is not null then
1840: If P_pa_request_rec.Veterans_Pref_for_rif <>
1841: nvl(p_per_sf52.veterans_preference_for_rif,hr_api.g_varchar2) then
1842: hr_utility.set_location(l_proc,75);
1843: P_Per_sf52.Per_Sf52_Flag := 'Y';
1844: P_Per_sf52.Veterans_Preference_For_Rif := P_pa_request_rec.Veterans_Pref_for_rif;
1845: End if;
1846: End if;
1847:
1848: If p_pa_request_rec.veterans_status is not null then
1849: If P_pa_request_rec.Veterans_Status <>
1850: nvl(p_per_sf52.veterans_status,hr_api.g_varchar2)then
1851: hr_utility.set_location(l_proc,80);
1852: P_Per_sf52.Per_Sf52_Flag := 'Y';
1853: P_Per_sf52.Veterans_Status := P_pa_request_rec.Veterans_Status;
1854: End if;
1865: hr_utility.set_location(l_proc,85);
1866:
1867: hr_utility.set_location(l_proc,90);
1868: If fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date)
1869: <> nvl(p_per_scd_info.scd_leave,fnd_date.date_to_canonical(hr_api.g_date)) then
1870: hr_utility.set_location(l_proc,95);
1871: p_per_scd_info.scd_leave := fnd_date.date_to_canonical(p_pa_request_rec.service_comp_date);
1872: p_per_scd_info.per_scd_info_flag := 'Y';
1873: End if;
1911: -- row into the history for the table PER_POSITIONS_EXTRA_INFO and thereby making the Position
1912: -- status as invalid when cancellation to any action was done.
1913: /* If p_pa_request_rec.to_occ_code is not null then
1914: If P_pa_request_rec.to_Occ_Code <>
1915: nvl(p_pos_grp1.occupation_category_code,hr_api.g_varchar2) then
1916: hr_utility.set_location(l_proc,105);
1917: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1918: P_Pos_grp1.Occupation_Category_Code := P_pa_request_rec.to_Occ_Code;
1919: End if;
1920: End if; */
1921:
1922: If p_pa_request_rec.bargaining_unit_status is not null then
1923: If P_pa_request_rec.Bargaining_Unit_Status <>
1924: nvl(p_pos_grp1.bargaining_unit_status,hr_api.g_varchar2) then
1925: hr_utility.set_location(l_proc,110);
1926: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1927: P_Pos_grp1.Bargaining_Unit_Status := P_pa_request_rec.Bargaining_Unit_Status;
1928: End if;
1931: -- JH removing comments so position is updated for WS and adding PTH update
1932: -- Bugs 773851, 773795
1933: If p_pa_request_rec.work_schedule is not null then
1934: If P_pa_request_rec.Work_Schedule <>
1935: nvl(p_pos_grp1.work_schedule,hr_api.g_varchar2) then
1936: hr_utility.set_location(l_proc,115);
1937: hr_utility.set_location('JH Rec WS = ' || P_pa_request_rec.work_schedule,115);
1938: hr_utility.set_location('JH Posn Grp1 WS = ' || p_pos_grp1.work_schedule,115);
1939: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1944:
1945: -- JH Hard coded to pass null if WS is F, G, B, I, J.
1946: If p_pa_request_rec.part_time_hours is not null then
1947: If P_pa_request_rec.part_time_hours <>
1948: nvl(p_pos_grp1.part_time_hours,hr_api.g_number) then
1949: hr_utility.set_location(l_proc,117);
1950: hr_utility.set_location('JH Rec PTH = ' || P_pa_request_rec.part_time_hours,117);
1951: hr_utility.set_location('JH Posn Grp1 PTH = ' || p_pos_grp1.part_time_hours,117);
1952: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1959: -- JH End changes
1960:
1961: If p_pa_request_rec.functional_class is not null then
1962: If P_pa_request_rec.Functional_Class <>
1963: nvl(p_pos_grp1.functional_class,hr_api.g_varchar2) then
1964: hr_utility.set_location(l_proc,120);
1965: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1966: P_Pos_grp1.Functional_Class := P_pa_request_rec.Functional_Class;
1967: End if;
1968: End if;
1969:
1970: If p_pa_request_rec.flsa_category is not null then
1971: If P_pa_request_rec.FLSA_Category <>
1972: nvl(p_pos_grp1.flsa_category,hr_api.g_varchar2) then
1973: hr_utility.set_location(l_proc,125);
1974: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1975: P_Pos_grp1.FLSA_Category := P_pa_request_rec.FLSA_Category;
1976: End if;
1977: End if;
1978:
1979: If p_pa_request_rec.supervisory_status is not null then
1980: If P_pa_request_rec.Supervisory_Status <>
1981: nvl(p_pos_grp1.supervisory_status,hr_api.g_varchar2) then
1982: hr_utility.set_location(l_proc,130);
1983: P_Pos_grp1.Pos_Grp1_Flag := 'Y';
1984: P_Pos_grp1.Supervisory_Status := P_pa_request_rec.Supervisory_Status;
1985: End if;
1998: --
1999: hr_utility.set_location(l_proc,135);
2000: --
2001: If p_pa_request_rec.position_occupied is not null then
2002: If p_pa_request_rec.position_occupied <> nvl(p_pos_grp2.position_occupied,hr_api.g_varchar2) then
2003: hr_utility.set_location(l_proc,145);
2004: P_Pos_grp2.Pos_grp2_flag := 'Y';
2005: p_pos_grp2.position_occupied := p_pa_request_rec.position_occupied;
2006: End if;
2006: End if;
2007: End if;
2008:
2009: If p_pa_request_rec.appropriation_code1 is not null then
2010: If P_pa_request_rec.Appropriation_Code1 <> nvl(p_pos_grp2.appropriation_code1,hr_api.g_varchar2) then
2011: hr_utility.set_location(l_proc,150);
2012: P_Pos_grp2.Pos_grp2_flag := 'Y';
2013: P_Pos_grp2.Appropriation_Code1 := P_pa_request_rec.Appropriation_Code1;
2014: End if;
2015: End if;
2016:
2017: --
2018: If p_pa_request_rec.appropriation_code2 is not null then
2019: If p_pa_request_rec.Appropriation_Code2 <> nvl(p_pos_grp2.appropriation_code2,hr_api.g_varchar2) then
2020: hr_utility.set_location(l_proc,155);
2021: P_Pos_grp2.Pos_grp2_flag := 'Y';
2022: P_Pos_grp2.Appropriation_Code2:= P_pa_request_rec.Appropriation_Code2;
2023: End if;
2029: -- Position Valid Grade EIT
2030: -- ************************
2031: -- If Grade is changed, then need to update it to Position Bug 2414903
2032: IF p_pa_request_rec.to_grade_id IS NOT NULL THEN
2033: IF p_pa_request_rec.to_grade_id <> NVL(to_number(p_valid_grade.valid_grade),hr_api.g_number) THEN
2034: p_valid_grade.pos_valid_grade_flag := 'Y';
2035: p_valid_grade.valid_grade := p_pa_request_rec.to_grade_id;
2036: END IF;
2037: END IF;
2040: -- *****************
2041: -- Recruitment Bonus
2042: -- *****************
2043: --
2044: If nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) = '815' then
2045: hr_utility.set_location(l_proc,165);
2046: p_recruitment_bonus.p_recruitment_bonus := p_pa_request_rec.award_amount;
2047: p_recruitment_bonus.p_percentage := p_pa_request_rec.award_percentage;
2048: END IF;
2052: -- ***************
2053: -- Relocation Bonus
2054: -- ***************
2055: --
2056: If nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) = '816' then
2057: hr_utility.set_location(l_proc,170);
2058: p_relocation_bonus.p_relocation_bonus := p_pa_request_rec.award_amount;
2059: p_relocation_bonus.p_percentage := p_pa_request_rec.award_percentage;
2060: End if;
2063: -- ***************
2064: -- Student Loan Repayment
2065: -- ***************
2066: --
2067: If nvl(p_pa_request_rec.first_noa_code,hr_api.g_varchar2) = '817' then
2068: hr_utility.set_location(l_proc,170);
2069: l_student_loan_repay.p_amount := p_pa_request_rec.award_amount;
2070: p_student_loan_repay := l_student_loan_repay;
2071: End if;
2087: PROCEDURE Process_Non_Sf52_Extra_Info
2088: --
2089: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2090: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2091: p_per_group1 in out nocopy ghr_api.per_group1_type,
2092: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2093: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2088: --
2089: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2090: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2091: p_per_group1 in out nocopy ghr_api.per_group1_type,
2092: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2093: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2089: (p_pa_request_rec in out nocopy ghr_pa_requests%rowtype,
2090: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2091: p_per_group1 in out nocopy ghr_api.per_group1_type,
2092: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2093: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2097: -- 4352589 BEN_EIT Changes
2090: p_generic_ei_rec in ghr_pa_request_extra_info%rowtype,
2091: p_per_group1 in out nocopy ghr_api.per_group1_type,
2092: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2093: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2097: -- 4352589 BEN_EIT Changes
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2091: p_per_group1 in out nocopy ghr_api.per_group1_type,
2092: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2093: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2097: -- 4352589 BEN_EIT Changes
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2092: p_per_scd_info in out nocopy ghr_api.per_scd_info_type,
2093: p_pos_grp2 in out nocopy ghr_api.pos_grp2_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2097: -- 4352589 BEN_EIT Changes
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2100: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2094: p_pos_grp1 in out nocopy ghr_api.pos_grp1_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2097: -- 4352589 BEN_EIT Changes
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2100: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2101: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2095: p_per_uniformed_services in out nocopy ghr_api.per_uniformed_services_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2097: -- 4352589 BEN_EIT Changes
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2100: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2101: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2096: p_per_conversions in out nocopy ghr_api.per_conversions_type,
2097: -- 4352589 BEN_EIT Changes
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2100: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2101: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2104: --Bug#4486823 RRR Changes
2097: -- 4352589 BEN_EIT Changes
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2100: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2101: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2104: --Bug#4486823 RRR Changes
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2098: p_per_benefit_info in out nocopy ghr_api.per_benefit_info_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2100: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2101: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2104: --Bug#4486823 RRR Changes
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2099: p_asg_non_sf52 in out nocopy ghr_api.asg_non_sf52_type,
2100: p_per_separate_Retire in out nocopy ghr_api.per_sep_retire_type,
2101: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2104: --Bug#4486823 RRR Changes
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2101: p_asg_nte_dates in out nocopy ghr_api.asg_nte_dates_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2104: --Bug#4486823 RRR Changes
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2102: p_per_probations in out nocopy ghr_api.per_probations_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2104: --Bug#4486823 RRR Changes
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2103: p_per_retained_grade in out nocopy ghr_api.per_retained_grade_type,
2104: --Bug#4486823 RRR Changes
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2104: --Bug#4486823 RRR Changes
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2112: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2105: p_per_service_oblig in out nocopy ghr_api.per_service_oblig_type,
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2112: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2113: --Pradeep
2106: p_within_grade_increase in out nocopy ghr_api.within_grade_increase_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2112: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2113: --Pradeep
2114: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2107: p_gov_awards in out nocopy ghr_api.government_awards_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2112: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2113: --Pradeep
2114: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2115: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2108: p_conduct_performance in out nocopy ghr_api.conduct_performance_type,
2109: p_agency_sf52 in out nocopy ghr_api.agency_sf52_type,
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2112: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2113: --Pradeep
2114: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2115: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2116:
2110: p_recruitment_bonus in out nocopy ghr_apI.recruitment_bonus_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2112: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2113: --Pradeep
2114: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2115: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2116:
2117: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2118: p_entitlement in out nocopy ghr_api.entitlement_type,
2111: p_relocation_bonus in out nocopy ghr_apI.relocation_bonus_type,
2112: p_student_loan_repay in out nocopy ghr_api.student_loan_repay_type,
2113: --Pradeep
2114: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2115: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2116:
2117: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2118: p_entitlement in out nocopy ghr_api.entitlement_type,
2119: -- Bug#2759379 Added Fegli record
2113: --Pradeep
2114: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2115: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2116:
2117: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2118: p_entitlement in out nocopy ghr_api.entitlement_type,
2119: -- Bug#2759379 Added Fegli record
2120: p_fegli in out nocopy ghr_api.fegli_type,
2121: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2114: p_mddds_special_pay in out nocopy ghr_api.mddds_special_pay_type,
2115: p_premium_pay_ind in out nocopy ghr_api.premium_pay_ind_type,
2116:
2117: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2118: p_entitlement in out nocopy ghr_api.entitlement_type,
2119: -- Bug#2759379 Added Fegli record
2120: p_fegli in out nocopy ghr_api.fegli_type,
2121: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2122: -- Bug#3385386 Added FTA record
2116:
2117: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2118: p_entitlement in out nocopy ghr_api.entitlement_type,
2119: -- Bug#2759379 Added Fegli record
2120: p_fegli in out nocopy ghr_api.fegli_type,
2121: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2122: -- Bug#3385386 Added FTA record
2123: p_imm_fta in out nocopy ghr_api.fta_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2117: p_par_term_retained_grade in out nocopy ghr_api.par_term_retained_grade_type,
2118: p_entitlement in out nocopy ghr_api.entitlement_type,
2119: -- Bug#2759379 Added Fegli record
2120: p_fegli in out nocopy ghr_api.fegli_type,
2121: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2122: -- Bug#3385386 Added FTA record
2123: p_imm_fta in out nocopy ghr_api.fta_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2119: -- Bug#2759379 Added Fegli record
2120: p_fegli in out nocopy ghr_api.fegli_type,
2121: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2122: -- Bug#3385386 Added FTA record
2123: p_imm_fta in out nocopy ghr_api.fta_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2120: p_fegli in out nocopy ghr_api.fegli_type,
2121: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2122: -- Bug#3385386 Added FTA record
2123: p_imm_fta in out nocopy ghr_api.fta_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2121: p_foreign_lang_prof_pay in out nocopy ghr_api.foreign_lang_prof_pay_type,
2122: -- Bug#3385386 Added FTA record
2123: p_imm_fta in out nocopy ghr_api.fta_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2122: -- Bug#3385386 Added FTA record
2123: p_imm_fta in out nocopy ghr_api.fta_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2123: p_imm_fta in out nocopy ghr_api.fta_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2124: p_edp_pay in out nocopy ghr_api.edp_pay_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2125: p_hazard_pay in out nocopy ghr_api.hazard_pay_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2126: p_health_benefits in out nocopy ghr_api.health_benefits_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2127: p_danger_pay in out nocopy ghr_api.danger_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2128: p_imminent_danger_pay in out nocopy ghr_api.imminent_danger_pay_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2129: p_living_quarters_allow in out nocopy ghr_api.living_quarters_allow_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2130: p_post_diff_amt in out nocopy ghr_api.post_diff_amt_type,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2131: p_post_diff_percent in out nocopy ghr_api.post_diff_percent_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2132: p_sep_maintenance_allow in out nocopy ghr_api.sep_maintenance_allow_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2133: p_supplemental_post_allow in out nocopy ghr_api.supplemental_post_allow_type,
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2141: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2134: p_temp_lodge_allow in out nocopy ghr_api.temp_lodge_allow_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2141: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2142: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2135: p_premium_pay in out nocopy ghr_api.premium_pay_type,
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2141: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2142: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2143: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
2136: p_retirement_annuity in out nocopy ghr_api.retirement_annuity_type,
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2141: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2142: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2143: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
2144: )
2137: p_severance_pay in out nocopy ghr_api.severance_pay_type,
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2141: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2142: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2143: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
2144: )
2145: --
2138: p_thrift_saving_plan in out nocopy ghr_api.thrift_saving_plan,
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2141: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2142: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2143: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
2144: )
2145: --
2146: IS
2139: p_retention_allow_review in out nocopy ghr_api.retention_allow_review_type,
2140: p_health_ben_pre_tax in out nocopy ghr_api.health_ben_pre_tax_type,
2141: p_race_ethnic_info in out nocopy ghr_api.per_race_ethnic_type, -- Bug 4724337 Race or National Origin changes
2142: p_ipa_benefits_cont in out nocopy ghr_api.per_ipa_ben_cont_info_type,
2143: p_retirement_info in out nocopy ghr_api.per_retirement_info_type
2144: )
2145: --
2146: IS
2147: --
2151: l_noa_code ghr_nature_of_actions.code%type;
2152: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
2153: l_information_type ghr_pa_request_info_types.information_type%type;
2154: l_pa_request_ei_rec ghr_pa_request_extra_info%rowtype;
2155: p_extra_info_agency_rec ghr_api.extra_info_rec_type;
2156: l_session ghr_history_api.g_session_var_type;
2157: l_multiple_error_flag boolean;
2158: -- Bug#5668878
2159: l_psi VARCHAR2(10);
2249: p_update_flag in out nocopy varchar2,
2250: p_auto_populate_flag in varchar2 default 'N'
2251: ) is
2252: Begin
2253: If nvl(p_hr_extra_info,hr_api.g_varchar2)
2254: <> nvl(p_ghr_extra_info,hr_api.g_varchar2) then
2255: If p_auto_populate_flag = 'Y' and
2256: l_session.noa_id_correct is null then
2257: -- since it is autopopulated the user might have made it null
2250: p_auto_populate_flag in varchar2 default 'N'
2251: ) is
2252: Begin
2253: If nvl(p_hr_extra_info,hr_api.g_varchar2)
2254: <> nvl(p_ghr_extra_info,hr_api.g_varchar2) then
2255: If p_auto_populate_flag = 'Y' and
2256: l_session.noa_id_correct is null then
2257: -- since it is autopopulated the user might have made it null
2258: -- and is not a correction
2513: Begin
2514: hr_utility.set_location('Entering ' || l_proc,5);
2515:
2516: -- Bug#4126188 begin
2517: IF NVL(l_pa_request_ei_rec.rei_information3,hr_api.g_varchar2) <>
2518: NVL(p_pos_grp1.personnel_office_id,hr_api.g_varchar2) THEN
2519: set_extra_info(p_asg_non_sf52.date_arr_personnel_office,
2520: l_pa_request_ei_rec.rei_information5, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2521: END IF;
2514: hr_utility.set_location('Entering ' || l_proc,5);
2515:
2516: -- Bug#4126188 begin
2517: IF NVL(l_pa_request_ei_rec.rei_information3,hr_api.g_varchar2) <>
2518: NVL(p_pos_grp1.personnel_office_id,hr_api.g_varchar2) THEN
2519: set_extra_info(p_asg_non_sf52.date_arr_personnel_office,
2520: l_pa_request_ei_rec.rei_information5, p_asg_non_sf52.asg_non_sf52_flag, 'Y');
2521: END IF;
2522: -- Bug#4126188 End
3133: -- -- Bug#4486823 RRR Changes
3134: --
3135: Procedure non_pay_duty_status is
3136: l_proc varchar2(72) := 'non_pay_duty_status';
3137: l_special_info_type ghr_api.special_information_type;
3138:
3139: Begin
3140: set_extra_info(p_per_group1.type_of_employment,
3141: l_pa_request_ei_rec.rei_information3,p_per_group1.per_group1_flag, 'Y');
3347: p_entitlement.entitlement_code := l_pa_request_ei_rec.rei_information3;
3348: p_entitlement.entitlement_amt_percent := l_pa_request_ei_rec.rei_information4;
3349: --Venkat 05/00 -- Bug# 1140536
3350: hr_utility.set_location('entitlement code is '||p_entitlement.entitlement_code ||l_proc,6);
3351: if nvl(p_entitlement.entitlement_code,hr_api.g_varchar2) = '9'
3352: and substr(nvl(p_pa_request_rec.duty_station_code,hr_api.g_varchar2),1,2)
3353: not in ('02','15','AQ','CQ','DQ',
3354: 'FQ','GQ','HQ','JQ','KQ',
3355: 'LQ','MQ','RQ','VQ','WQ') then
3348: p_entitlement.entitlement_amt_percent := l_pa_request_ei_rec.rei_information4;
3349: --Venkat 05/00 -- Bug# 1140536
3350: hr_utility.set_location('entitlement code is '||p_entitlement.entitlement_code ||l_proc,6);
3351: if nvl(p_entitlement.entitlement_code,hr_api.g_varchar2) = '9'
3352: and substr(nvl(p_pa_request_rec.duty_station_code,hr_api.g_varchar2),1,2)
3353: not in ('02','15','AQ','CQ','DQ',
3354: 'FQ','GQ','HQ','JQ','KQ',
3355: 'LQ','MQ','RQ','VQ','WQ') then
3356: hr_utility.set_message(8301,'GHR_38030_INV_DS_4_NON_F_COLA');
3355: 'LQ','MQ','RQ','VQ','WQ') then
3356: hr_utility.set_message(8301,'GHR_38030_INV_DS_4_NON_F_COLA');
3357: hr_utility.raise_error;
3358: end if;
3359: if nvl(p_entitlement.entitlement_code,hr_api.g_varchar2) = 'C'
3360: and substr(nvl(p_pa_request_rec.duty_station_code,hr_api.g_varchar2),1,2)
3361: in ('02','15','AQ','CQ','DQ',
3362: 'FQ','GQ','HQ','JQ','KQ',
3363: 'LQ','MQ','RQ','VQ','WQ') then
3356: hr_utility.set_message(8301,'GHR_38030_INV_DS_4_NON_F_COLA');
3357: hr_utility.raise_error;
3358: end if;
3359: if nvl(p_entitlement.entitlement_code,hr_api.g_varchar2) = 'C'
3360: and substr(nvl(p_pa_request_rec.duty_station_code,hr_api.g_varchar2),1,2)
3361: in ('02','15','AQ','CQ','DQ',
3362: 'FQ','GQ','HQ','JQ','KQ',
3363: 'LQ','MQ','RQ','VQ','WQ') then
3364: hr_utility.set_message(8301,'GHR_38032_INV_DS_4_COLA');
4372: Begin
4373: --
4374: hr_utility.set_location('Entering ' ||l_proc,5);
4375: If p_pa_request_rec.employee_assignment_id is not null then
4376: ghr_api.retrieve_element_entry_value
4377: (p_element_name => 'Retention Allowance',
4378: p_input_value_name => 'Date',
4379: p_assignment_id => p_pa_request_rec.employee_assignment_id,
4380: p_effective_date => nvl(p_pa_request_rec.effective_date,trunc(sysdate)) ,