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_RIF_PKG dependencies on GHR_RIF_CRITERIA

Line 7: p_rif_criteria_id in ghr_rif_criteria.rif_criteria_id%TYPE

3:
4: msl_error EXCEPTION;
5:
6: PROCEDURE run_register (
7: p_rif_criteria_id in ghr_rif_criteria.rif_criteria_id%TYPE
8: ,p_organization_id in ghr_rif_criteria.organization_id%TYPE
9: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
10: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
11: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE

Line 8: ,p_organization_id in ghr_rif_criteria.organization_id%TYPE

4: msl_error EXCEPTION;
5:
6: PROCEDURE run_register (
7: p_rif_criteria_id in ghr_rif_criteria.rif_criteria_id%TYPE
8: ,p_organization_id in ghr_rif_criteria.organization_id%TYPE
9: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
10: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
11: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
12: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE

Line 9: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE

5:
6: PROCEDURE run_register (
7: p_rif_criteria_id in ghr_rif_criteria.rif_criteria_id%TYPE
8: ,p_organization_id in ghr_rif_criteria.organization_id%TYPE
9: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
10: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
11: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
12: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
13: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE

Line 10: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE

6: PROCEDURE run_register (
7: p_rif_criteria_id in ghr_rif_criteria.rif_criteria_id%TYPE
8: ,p_organization_id in ghr_rif_criteria.organization_id%TYPE
9: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
10: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
11: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
12: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
13: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
14: ,p_effective_date in date

Line 11: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE

7: p_rif_criteria_id in ghr_rif_criteria.rif_criteria_id%TYPE
8: ,p_organization_id in ghr_rif_criteria.organization_id%TYPE
9: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
10: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
11: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
12: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
13: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
14: ,p_effective_date in date
15: );

Line 12: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE

8: ,p_organization_id in ghr_rif_criteria.organization_id%TYPE
9: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
10: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
11: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
12: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
13: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
14: ,p_effective_date in date
15: );
16:

Line 13: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE

9: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
10: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
11: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
12: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
13: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
14: ,p_effective_date in date
15: );
16:
17: FUNCTION num_of_vacancies (

Line 18: p_organization_id in ghr_rif_criteria.organization_id%TYPE

14: ,p_effective_date in date
15: );
16:
17: FUNCTION num_of_vacancies (
18: p_organization_id in ghr_rif_criteria.organization_id%TYPE
19: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
20: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
21: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
22: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE

Line 19: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE

15: );
16:
17: FUNCTION num_of_vacancies (
18: p_organization_id in ghr_rif_criteria.organization_id%TYPE
19: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
20: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
21: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
22: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
23: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE

Line 20: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE

16:
17: FUNCTION num_of_vacancies (
18: p_organization_id in ghr_rif_criteria.organization_id%TYPE
19: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
20: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
21: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
22: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
23: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
24: ,p_effective_date in date

Line 21: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE

17: FUNCTION num_of_vacancies (
18: p_organization_id in ghr_rif_criteria.organization_id%TYPE
19: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
20: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
21: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
22: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
23: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
24: ,p_effective_date in date
25: )

Line 22: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE

18: p_organization_id in ghr_rif_criteria.organization_id%TYPE
19: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
20: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
21: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
22: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
23: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
24: ,p_effective_date in date
25: )
26: return number;

Line 23: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE

19: ,p_org_structure_id in ghr_rif_criteria.org_structure_id%TYPE
20: ,p_office_symbol in ghr_rif_criteria.office_symbol%TYPE
21: ,p_agency_code_subelement in ghr_rif_criteria.agency_code_subelement%TYPE
22: ,p_comp_area in ghr_rif_criteria.comp_area%TYPE
23: ,p_comp_level in ghr_rif_criteria.comp_level%TYPE
24: ,p_effective_date in date
25: )
26: return number;
27:

Line 33: PROCEDURE check_unique_name (p_rif_criteria_id IN ghr_rif_criteria.rif_criteria_id%TYPE

29: return varchar2;
30:
31: PROCEDURE purge_register;
32:
33: PROCEDURE check_unique_name (p_rif_criteria_id IN ghr_rif_criteria.rif_criteria_id%TYPE
34: ,p_name IN ghr_rif_criteria.name%TYPE);
35:
36: END ghr_rif_pkg;

Line 34: ,p_name IN ghr_rif_criteria.name%TYPE);

30:
31: PROCEDURE purge_register;
32:
33: PROCEDURE check_unique_name (p_rif_criteria_id IN ghr_rif_criteria.rif_criteria_id%TYPE
34: ,p_name IN ghr_rif_criteria.name%TYPE);
35:
36: END ghr_rif_pkg;