DBA Data[Home] [Help]

APPS.HRI_BPL_FACT_ABS_SQL dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 14: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

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,

Line 26: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

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:

Line 27: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

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

Line 32: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_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;

Line 33: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_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: