APPS.HRI_BPL_TREND_TRM_SQL dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 88: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

84: -- does not have any additional parameters.
85: -- -------------------------------------------------------------------------
86: --
87: PROCEDURE analyze_parameters
88: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
89: p_fact_conditions OUT NOCOPY VARCHAR2,
90: p_parameter_count OUT NOCOPY PLS_INTEGER) IS
91:
92: l_parameter_name VARCHAR2(100);

Line 142: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

138: -- added to outer layers of SQL
139: -- -------------------------------------------------------------------------
140: --
141: PROCEDURE set_select
142: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
143: p_bucket_dim IN VARCHAR2,
144: p_include_sep IN VARCHAR2,
145: p_include_sep_inv IN VARCHAR2,
146: p_include_sep_vol IN VARCHAR2,

Line 318: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

314: -- headcount trend reports
315: -- -------------------------------------------------------------------------
316: --
317: PROCEDURE get_sql
318: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
319: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
320: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,
321: p_fact_sql OUT NOCOPY VARCHAR2,
322: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type)

Line 319: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

315: -- -------------------------------------------------------------------------
316: --
317: PROCEDURE get_sql
318: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
319: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
320: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,
321: p_fact_sql OUT NOCOPY VARCHAR2,
322: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type)
323: IS

Line 331: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

327: l_fact_table VARCHAR2(50);
328: l_fact_condition VARCHAR2(1000);
329: l_param_conditions VARCHAR2(1000);
330: l_parameter_count PLS_INTEGER;
331: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
332: --
333: BEGIN
334: --
335: -- Check whether a snapshot is available