APPS.HRI_BPL_TREND_WRKFC_SQL dependencies on HRI_OLTP_PMV_QUERY_TREND

Line 147: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type)

143: p_include_hdc_trn IN VARCHAR2,
144: p_include_sal IN VARCHAR2,
145: p_use_snapshot IN BOOLEAN,
146: p_select_sql OUT NOCOPY VARCHAR2,
147: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type)
148: IS
149:
150: -- template
151: l_column_bucket VARCHAR2(1000);

Line 386: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,

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,
390: p_use_snapshot OUT NOCOPY BOOLEAN)

Line 389: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_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,
390: p_use_snapshot OUT NOCOPY BOOLEAN)
391: IS
392: --
393: l_trend_periods_tbl VARCHAR2(32767);