PACKAGE: APPS.HRI_EDW_FCT_WRK_ACTVTY

Source

1 PACKAGE hri_edw_fct_wrk_actvty AS
2 /* $Header: hriefwac.pkh 120.0 2005/05/29 07:10:28 appldev noship $ */
3 
4 FUNCTION check_reason( p_change_reason  IN VARCHAR2,
5                        p_instance       IN VARCHAR2 )
6               RETURN VARCHAR2;
7 
8 FUNCTION get_hire_days( p_person_id         IN NUMBER,
9                         p_effective_date    IN DATE )
10                RETURN DATE;
11 
12 FUNCTION get_days_to_last_org_x( p_assignment_id     IN NUMBER,
13                                  p_person_id         IN NUMBER,
14                                  p_change_date       IN DATE )
15             RETURN NUMBER;
16 
17 FUNCTION get_days_to_last_job_x( p_assignment_id     IN NUMBER,
18                                  p_person_id         IN NUMBER,
19                                  p_change_date       IN DATE )
20             RETURN NUMBER;
21 
22 FUNCTION get_days_to_last_pos_x( p_assignment_id     IN NUMBER,
23                                  p_person_id         IN NUMBER,
24                                  p_change_date       IN DATE )
25             RETURN NUMBER;
26 
27 FUNCTION get_days_to_last_grd_x( p_assignment_id     IN NUMBER,
28                                  p_person_id         IN NUMBER,
29                                  p_change_date       IN DATE )
30             RETURN NUMBER;
31 
32 FUNCTION get_days_to_last_geog_x( p_assignment_id     IN NUMBER,
33                                   p_person_id         IN NUMBER,
34                                   p_change_date       IN DATE )
35             RETURN NUMBER;
36 
37 END hri_edw_fct_wrk_actvty;