eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_GHRWS52L dependencies on HR_API

Line 10: ,p_per_group1 in ghr_api.per_group1_type

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

Line 11: ,p_per_retained_grade in ghr_api.per_retained_grade_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

Line 12: ,p_per_sep_retire in ghr_api.per_sep_retire_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

Line 13: ,p_per_conversions in ghr_api.per_conversions_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

Line 14: ,p_per_uniformed_services in ghr_api.per_uniformed_services_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

Line 15: ,p_pos_grp1 in ghr_api.pos_grp1_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

Line 16: ,p_pos_valid_grade in ghr_api.pos_valid_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
20: ,p_agency_code in varchar2

Line 17: ,p_loc_info in ghr_api.loc_info_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
21: ,p_gov_awards_type in ghr_api.government_awards_type

Line 18: ,p_sf52_from_data in ghr_api.prior_sf52_data_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

Line 19: ,p_personal_info in ghr_api.personal_info_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

Line 21: ,p_gov_awards_type in ghr_api.government_awards_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
24: ,p_race_ethnic_info in ghr_api.per_race_ethnic_type -- Bug 4724337 Race or National Origin changes
25: ,p_per_scd_info in ghr_api.per_scd_info_type --Bug# 11726461

Line 22: ,p_perf_appraisal_type in ghr_api.performance_appraisal_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: ,p_per_scd_info in ghr_api.per_scd_info_type --Bug# 11726461
26: )

Line 24: ,p_race_ethnic_info in ghr_api.per_race_ethnic_type -- Bug 4724337 Race or National Origin changes

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: ,p_per_scd_info in ghr_api.per_scd_info_type --Bug# 11726461
26: )
27: is
28: --

Line 25: ,p_per_scd_info in ghr_api.per_scd_info_type --Bug# 11726461

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: ,p_per_scd_info in ghr_api.per_scd_info_type --Bug# 11726461
26: )
27: is
28: --
29: l_proc varchar2(61) := 'GHR_GHRWS52L.GHRWS52';

Line 286: and nvl(rei_information30,hr_api.g_varchar2) <> 'Original RPA';

282: from ghr_pa_request_extra_info
283: where pa_request_id = p_pa_request_rec.pa_request_id
284: and information_type = 'GHR_US_PAR_TERM_RG_POSN_CHG'
285: and rei_information5 = 'Y'
286: and nvl(rei_information30,hr_api.g_varchar2) <> 'Original RPA';
287:
288: Cursor c_rg_pei is
289: SELECT count(person_extra_info_id) pei_count
290: FROM per_people_extra_info pei