PACKAGE: APPS.HRI_BPL_FACT_ABS_SQL

Source

1 PACKAGE HRI_BPL_FACT_ABS_SQL AS
2 /* $Header: hribfabs.pkh 120.0 2005/09/22 07:28 cbridge noship $ */
3 TYPE abs_fact_param_type IS RECORD
4  (bind_format               VARCHAR2(30),
5   include_abs_drtn_days     VARCHAR2(30) DEFAULT 'N',
6   include_abs_drtn_hrs      VARCHAR2(30) DEFAULT 'N',
7   include_abs_in_period     VARCHAR2(30) DEFAULT 'N',
8   include_abs_ntfctn_period VARCHAR2(30) DEFAULT 'N',
9   include_comp              VARCHAR2(30) DEFAULT 'N',
10   kpi_mode                  VARCHAR2(30) DEFAULT 'N',
11   bucket_dim                VARCHAR2(100) DEFAULT NULL);
12 
13 PROCEDURE set_fact_table
14  (p_parameter_rec        IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
15   p_bucket_dim           IN VARCHAR2,
16   p_abs_drtn_days        IN VARCHAR2,
17   p_abs_drtn_hrs         IN VARCHAR2,
18   p_abs_in_period        IN VARCHAR2,
19   p_abs_ntfctn_period    IN VARCHAR2,
20   p_parameter_count      IN PLS_INTEGER,
21   p_single_param         IN VARCHAR2,
22   p_use_snapshot         IN OUT NOCOPY BOOLEAN,
23   p_fact_table           OUT NOCOPY VARCHAR2);
24 
25 FUNCTION get_sql
26  (p_parameter_rec    IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
27   p_bind_tab         IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
28   p_abs_params  IN abs_fact_param_type)
29      RETURN VARCHAR2;
30 
31 FUNCTION get_sql
32  (p_parameter_rec    IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
33   p_bind_tab         IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
34   p_abs_params  IN abs_fact_param_type,
35   p_calling_module   IN VARCHAR2)
36      RETURN VARCHAR2;
37 
38 END HRI_BPL_FACT_ABS_SQL;