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,
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:
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
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;
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: