APPS.HRI_BPL_TREND_ABS_SQL dependencies on HRI_OLTP_PMV_QUERY_TREND

Line 132: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type)

128: p_include_abs_in_period IN VARCHAR2,
129: p_include_abs_ntfctn_period IN VARCHAR2,
130: p_use_snapshot IN BOOLEAN,
131: p_select_sql OUT NOCOPY VARCHAR2,
132: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_type)
133: IS
134:
135: -- template
136: l_column_bucket VARCHAR2(1000);

Line 292: p_trend_sql_params IN hri_oltp_pmv_query_trend.trend_sql_params_type,

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

Line 295: p_measure_columns OUT NOCOPY hri_oltp_pmv_query_trend.trend_measure_cols_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,
296: p_use_snapshot OUT NOCOPY BOOLEAN)
297: IS
298: --
299: l_trend_periods_tbl VARCHAR2(32767);