PACKAGE: APPS.HRI_EDW_DIM_SERVICE

Source

1 PACKAGE hri_edw_dim_service AS
2 /* $Header: hriedlwb.pkh 120.0 2005/05/29 07:08:45 appldev noship $ */
3 
4 FUNCTION get_days_to_month RETURN NUMBER;
5 
6 PROCEDURE set_days_to_months( p_days_to_month  NUMBER);
7 
8 FUNCTION normalize_band( p_band_years        NUMBER,
9                          p_band_months       NUMBER,
10                          p_band_weeks        NUMBER,
11                          p_band_days         NUMBER,
12                          p_days_to_month     NUMBER)
13          RETURN 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 END hri_edw_dim_service;