APPS.HRI_BPL_TREND_WRKFC_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 136: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

132: -- specified as the metadata.
133: -- -------------------------------------------------------------------------
134: --
135: PROCEDURE set_select
136: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
137: p_bucket_dim IN VARCHAR2,
138: p_include_hdc IN VARCHAR2,
139: p_include_pasg_cnt IN VARCHAR2,
140: p_include_pasg_pow IN VARCHAR2,

Line 384: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

380: -- p_future_trend: Set if SQL has to be generated for future periods
381: -- -------------------------------------------------------------------------
382: --
383: PROCEDURE get_sql
384: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
385: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
386: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,
387: p_date_join_type IN VARCHAR2,
388: p_fact_sql OUT NOCOPY VARCHAR2,

Line 385: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

381: -- -------------------------------------------------------------------------
382: --
383: PROCEDURE get_sql
384: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
385: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
386: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,
387: p_date_join_type IN VARCHAR2,
388: p_fact_sql OUT NOCOPY VARCHAR2,
389: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type,

Line 399: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

395: l_fact_table VARCHAR2(100);
396: l_date_join VARCHAR2(1000);
397: l_fact_condition VARCHAR2(1000);
398: l_use_snapshot BOOLEAN;
399: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
400: l_param_conditions VARCHAR2(1000);
401: l_parameter_count PLS_INTEGER;
402: --
403: BEGIN