PACKAGE: APPS.HRI_EDW_FCT_RECRUITMENT

Source

1 PACKAGE hri_edw_fct_recruitment AS
2 /* $Header: hriefwrt.pkh 120.0 2005/05/29 07:10:50 appldev noship $ */
3 
4 FUNCTION calc_abv(p_assignment_id     IN NUMBER,
5                   p_business_group_id IN NUMBER,
6                   p_budget_type       IN VARCHAR2,
7                   p_effective_date    IN DATE)
8                   RETURN NUMBER;
9 
10 PROCEDURE find_stages(p_assignment_id      IN NUMBER);
11 
12 PROCEDURE find_employment_end(p_person_id  IN NUMBER,
13                               p_date_start IN DATE);
14 
15 FUNCTION find_hire_reason(p_assignment_id  IN NUMBER,
16                           p_person_id      IN NUMBER,
17                           p_hire_date      IN DATE)
18                    RETURN VARCHAR2;
19 
20 FUNCTION find_movement_pk(p_system_status    IN VARCHAR2,
21                           p_gain_type        IN VARCHAR2,
22                           p_success_flag     IN NUMBER)
23                    RETURN VARCHAR2;
24 
25 FUNCTION is_successful(p_assignment_id        IN NUMBER,
26                        p_person_id            IN NUMBER,
27                        p_date_end             IN DATE)
28                  RETURN NUMBER;
29 
30 PROCEDURE populate_recruitment_table;
31 
32 END hri_edw_fct_recruitment;