[Home] [Help]
PACKAGE: APPS.GHR_RIF_PKG
Source
1 PACKAGE ghr_rif_pkg AUTHID CURRENT_USER AS
2 /* $Header: ghrifpkg.pkh 120.0 2005/05/29 03:36:18 appldev noship $ */
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
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 (
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;
27
28 FUNCTION get_org_name(p_organization_id IN per_organization_units.organization_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;