APPS.HRI_BPL_TREND_ABS_SQL dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 82: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

78: -- does not have any additional parameters.
79: -- -------------------------------------------------------------------------
80: --
81: PROCEDURE analyze_parameters
82: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
83: p_fact_conditions OUT NOCOPY VARCHAR2,
84: p_parameter_count OUT NOCOPY PLS_INTEGER) IS
85:
86: l_parameter_name VARCHAR2(100);

Line 124: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

120: -- specified as the metadata.
121: -- -------------------------------------------------------------------------
122: --
123: PROCEDURE set_select
124: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
125: p_bucket_dim IN VARCHAR2,
126: p_include_abs_drtn_days IN VARCHAR2,
127: p_include_abs_drtn_hrs IN VARCHAR2,
128: p_include_abs_in_period IN VARCHAR2,

Line 290: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

286: -- p_future_trend: Set if SQL has to be generated for future periods
287: -- -------------------------------------------------------------------------
288: --
289: PROCEDURE get_sql
290: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
291: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
292: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,
293: p_date_join_type IN VARCHAR2,
294: p_fact_sql OUT NOCOPY VARCHAR2,

Line 291: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

287: -- -------------------------------------------------------------------------
288: --
289: PROCEDURE get_sql
290: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
291: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
292: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,
293: p_date_join_type IN VARCHAR2,
294: p_fact_sql OUT NOCOPY VARCHAR2,
295: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type,

Line 305: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

301: l_fact_table VARCHAR2(100);
302: l_date_join VARCHAR2(1000);
303: l_fact_condition VARCHAR2(1000);
304: l_use_snapshot BOOLEAN;
305: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
306: l_param_conditions VARCHAR2(1000);
307: l_parameter_count PLS_INTEGER;
308: --
309: BEGIN