6:
7: procedure GHRWS52L
8: (
9: p_pa_request_rec in ghr_pa_requests%rowtype
10: ,p_per_group1 in ghr_api.per_group1_type
11: ,p_per_retained_grade in ghr_api.per_retained_grade_type
12: ,p_per_sep_retire in ghr_api.per_sep_retire_type
13: ,p_per_conversions in ghr_api.per_conversions_type
14: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
7: procedure GHRWS52L
8: (
9: p_pa_request_rec in ghr_pa_requests%rowtype
10: ,p_per_group1 in ghr_api.per_group1_type
11: ,p_per_retained_grade in ghr_api.per_retained_grade_type
12: ,p_per_sep_retire in ghr_api.per_sep_retire_type
13: ,p_per_conversions in ghr_api.per_conversions_type
14: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
15: ,p_pos_grp1 in ghr_api.pos_grp1_type
8: (
9: p_pa_request_rec in ghr_pa_requests%rowtype
10: ,p_per_group1 in ghr_api.per_group1_type
11: ,p_per_retained_grade in ghr_api.per_retained_grade_type
12: ,p_per_sep_retire in ghr_api.per_sep_retire_type
13: ,p_per_conversions in ghr_api.per_conversions_type
14: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
15: ,p_pos_grp1 in ghr_api.pos_grp1_type
16: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
9: p_pa_request_rec in ghr_pa_requests%rowtype
10: ,p_per_group1 in ghr_api.per_group1_type
11: ,p_per_retained_grade in ghr_api.per_retained_grade_type
12: ,p_per_sep_retire in ghr_api.per_sep_retire_type
13: ,p_per_conversions in ghr_api.per_conversions_type
14: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
15: ,p_pos_grp1 in ghr_api.pos_grp1_type
16: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
17: ,p_loc_info in ghr_api.loc_info_type
10: ,p_per_group1 in ghr_api.per_group1_type
11: ,p_per_retained_grade in ghr_api.per_retained_grade_type
12: ,p_per_sep_retire in ghr_api.per_sep_retire_type
13: ,p_per_conversions in ghr_api.per_conversions_type
14: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
15: ,p_pos_grp1 in ghr_api.pos_grp1_type
16: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
17: ,p_loc_info in ghr_api.loc_info_type
18: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
11: ,p_per_retained_grade in ghr_api.per_retained_grade_type
12: ,p_per_sep_retire in ghr_api.per_sep_retire_type
13: ,p_per_conversions in ghr_api.per_conversions_type
14: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
15: ,p_pos_grp1 in ghr_api.pos_grp1_type
16: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
17: ,p_loc_info in ghr_api.loc_info_type
18: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
19: ,p_personal_info in ghr_api.personal_info_type
12: ,p_per_sep_retire in ghr_api.per_sep_retire_type
13: ,p_per_conversions in ghr_api.per_conversions_type
14: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
15: ,p_pos_grp1 in ghr_api.pos_grp1_type
16: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
17: ,p_loc_info in ghr_api.loc_info_type
18: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
19: ,p_personal_info in ghr_api.personal_info_type
20: ,p_agency_code in varchar2
13: ,p_per_conversions in ghr_api.per_conversions_type
14: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
15: ,p_pos_grp1 in ghr_api.pos_grp1_type
16: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
17: ,p_loc_info in ghr_api.loc_info_type
18: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
19: ,p_personal_info in ghr_api.personal_info_type
20: ,p_agency_code in varchar2
21: ,p_gov_awards_type in ghr_api.government_awards_type
14: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
15: ,p_pos_grp1 in ghr_api.pos_grp1_type
16: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
17: ,p_loc_info in ghr_api.loc_info_type
18: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
19: ,p_personal_info in ghr_api.personal_info_type
20: ,p_agency_code in varchar2
21: ,p_gov_awards_type in ghr_api.government_awards_type
22: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
15: ,p_pos_grp1 in ghr_api.pos_grp1_type
16: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
17: ,p_loc_info in ghr_api.loc_info_type
18: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
19: ,p_personal_info in ghr_api.personal_info_type
20: ,p_agency_code in varchar2
21: ,p_gov_awards_type in ghr_api.government_awards_type
22: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
23: ,p_health_plan in varchar2
17: ,p_loc_info in ghr_api.loc_info_type
18: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
19: ,p_personal_info in ghr_api.personal_info_type
20: ,p_agency_code in varchar2
21: ,p_gov_awards_type in ghr_api.government_awards_type
22: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
23: ,p_health_plan in varchar2
24: ,p_race_ethnic_info in ghr_api.per_race_ethnic_type -- Bug 4724337 Race or National Origin changes
25: )
18: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
19: ,p_personal_info in ghr_api.personal_info_type
20: ,p_agency_code in varchar2
21: ,p_gov_awards_type in ghr_api.government_awards_type
22: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
23: ,p_health_plan in varchar2
24: ,p_race_ethnic_info in ghr_api.per_race_ethnic_type -- Bug 4724337 Race or National Origin changes
25: )
26: is
20: ,p_agency_code in varchar2
21: ,p_gov_awards_type in ghr_api.government_awards_type
22: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
23: ,p_health_plan in varchar2
24: ,p_race_ethnic_info in ghr_api.per_race_ethnic_type -- Bug 4724337 Race or National Origin changes
25: )
26: is
27: --
28: l_proc varchar2(61) := 'GHR_GHRWS52L.GHRWS52';
277: from ghr_pa_request_extra_info
278: where pa_request_id = p_pa_request_rec.pa_request_id
279: and information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
280: and rei_information5 = 'Y'
281: and nvl(rei_information30,hr_api.g_varchar2) <> 'Original RPA';
282:
283: Cursor c_rg_pei is
284: SELECT count(person_extra_info_id) pei_count
285: FROM per_people_extra_info pei