52: kpi_mode VARCHAR2(30) DEFAULT 'N',
53: bucket_dim VARCHAR2(100) DEFAULT NULL);
54:
55: PROCEDURE set_fact_table
56: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
57: p_bucket_dim IN VARCHAR2,
58: p_include_hire IN VARCHAR2,
59: p_include_trin IN VARCHAR2,
60: p_include_trout IN VARCHAR2,
65: p_use_snapshot IN OUT NOCOPY BOOLEAN,
66: p_fact_table OUT NOCOPY VARCHAR2);
67:
68: FUNCTION get_sql
69: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
70: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
71: p_wcnt_chg_params IN wcnt_chg_fact_param_type)
72: RETURN VARCHAR2;
73:
66: p_fact_table OUT NOCOPY VARCHAR2);
67:
68: FUNCTION get_sql
69: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
70: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
71: p_wcnt_chg_params IN wcnt_chg_fact_param_type)
72: RETURN VARCHAR2;
73:
74: FUNCTION get_sql
71: p_wcnt_chg_params IN wcnt_chg_fact_param_type)
72: RETURN VARCHAR2;
73:
74: FUNCTION get_sql
75: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
76: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
77: p_wcnt_chg_params IN wcnt_chg_fact_param_type,
78: p_calling_module IN VARCHAR2)
79: RETURN VARCHAR2;
72: RETURN VARCHAR2;
73:
74: FUNCTION get_sql
75: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
76: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
77: p_wcnt_chg_params IN wcnt_chg_fact_param_type,
78: p_calling_module IN VARCHAR2)
79: RETURN VARCHAR2;
80: