PACKAGE: APPS.GHR_RIF_PKG

Source

1 PACKAGE ghr_rif_pkg 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;