DBA Data[Home] [Help]

APPS.HRI_BPL_FACT_SUP_WRKFC_SQL dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 59: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

55: kpi_mode VARCHAR2(30) DEFAULT 'N',
56: bucket_dim VARCHAR2(100) DEFAULT NULL);
57:
58: PROCEDURE set_fact_table
59: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
60: p_bucket_dim IN VARCHAR2,
61: p_include_sal IN VARCHAR2,
62: p_parameter_count IN PLS_INTEGER,
63: p_single_param IN VARCHAR2,

Line 68: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

64: p_use_snapshot IN OUT NOCOPY BOOLEAN,
65: p_fact_table OUT NOCOPY VARCHAR2);
66:
67: FUNCTION get_sql
68: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
69: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
70: p_wrkfc_params IN wrkfc_fact_param_type)
71: RETURN VARCHAR2;
72:

Line 69: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

65: p_fact_table OUT NOCOPY VARCHAR2);
66:
67: FUNCTION get_sql
68: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
69: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
70: p_wrkfc_params IN wrkfc_fact_param_type)
71: RETURN VARCHAR2;
72:
73: FUNCTION get_sql

Line 74: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

70: p_wrkfc_params IN wrkfc_fact_param_type)
71: RETURN VARCHAR2;
72:
73: FUNCTION get_sql
74: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
75: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
76: p_wrkfc_params IN wrkfc_fact_param_type,
77: p_calling_module IN VARCHAR2)
78: RETURN VARCHAR2;

Line 75: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

71: RETURN VARCHAR2;
72:
73: FUNCTION get_sql
74: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
75: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
76: p_wrkfc_params IN wrkfc_fact_param_type,
77: p_calling_module IN VARCHAR2)
78: RETURN VARCHAR2;
79: