DBA Data[Home] [Help]

APPS.HRI_BPL_FACT_SUP_WCNT_CHG_SQL dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 56: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

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,

Line 69: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

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:

Line 70: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

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

Line 75: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

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;

Line 76: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_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;
80: