PACKAGE: APPS.HRI_BPL_PERIOD_OF_WORK

Source

1 PACKAGE hri_bpl_period_of_work AS
2 /* $Header: hriblow.pkh 120.2 2005/07/05 01:41:02 anmajumd noship $ */
3 
4 FUNCTION normalize_band( p_band_years        NUMBER,
5                          p_band_months       NUMBER,
6                          p_band_weeks        NUMBER,
7                          p_band_days         NUMBER,
8                          p_days_to_month     NUMBER)
9          RETURN NUMBER;
10 
11 FUNCTION get_days_to_month RETURN NUMBER;
12 
13 PROCEDURE set_days_to_months( p_days_to_month  NUMBER);
14 
15 PROCEDURE insert_service_band( p_service_min_years    NUMBER,
16                                p_service_min_months   NUMBER,
17                                p_service_min_weeks    NUMBER,
18                                p_service_min_days     NUMBER);
19 
20 PROCEDURE remove_service_band( p_service_min_years   NUMBER,
21                                p_service_min_months  NUMBER,
22                                p_service_min_weeks   NUMBER,
23                                p_service_min_days    NUMBER);
24 
25 PROCEDURE load_row( p_band_min_yrs       IN NUMBER,
26                     p_band_min_mths      IN NUMBER,
27                     p_band_min_wks       IN NUMBER,
28                     p_band_min_days      IN NUMBER,
29                     p_band_max_yrs       IN NUMBER,
30                     p_band_max_mths      IN NUMBER,
31                     p_band_max_wks       IN NUMBER,
32                     p_band_max_days      IN NUMBER,
33                     p_days_to_month      IN NUMBER,
34                     p_owner              IN VARCHAR2 );
35 
36 FUNCTION get_period_of_work_years(p_person_id       IN NUMBER,
37                                    p_effective_date  IN DATE,
38                                    p_assignment_type IN VARCHAR2)
39                RETURN NUMBER;
40 
41 FUNCTION get_period_of_work_months(p_person_id       IN NUMBER,
42                                    p_effective_date  IN DATE,
43                                    p_assignment_type IN VARCHAR2)
44                RETURN NUMBER;
45 
46 FUNCTION get_latest_hire_date(p_person_id       IN NUMBER,
47                               p_effective_date  IN DATE,
48                               p_assignment_type IN VARCHAR2)
49                RETURN DATE;
50 
51 FUNCTION get_pow_band_high_val(p_band_number       NUMBER,
52                                p_assignment_type   VARCHAR2)
53                RETURN NUMBER;
54 
55 FUNCTION get_pow_band_sk_fk(p_band_number       NUMBER,
56                             p_assignment_type   VARCHAR2)
57 RETURN NUMBER ;
58 
59 END hri_bpl_period_of_work;