APPS.HRI_OLTP_PMV_WMV_ABS_SUP_GRAPH dependencies on HRI_OLTP_PMV_QUERY_TREND

Line 27: l_trend_sql_params hri_oltp_pmv_query_trend.trend_sql_params_type;

23: -- Trend Period Parameters
24: l_projection_periods NUMBER;
25: l_previous_periods NUMBER;
26: l_trend_sql VARCHAR2(10000);
27: l_trend_sql_params hri_oltp_pmv_query_trend.trend_sql_params_type;
28:
29: -- dyanamic columns
30: l_period_abs_drtn_metric1 VARCHAR2(1000);
31: l_period_abs_drtn_metric2 VARCHAR2(1000);

Line 88: l_trend_sql := hri_oltp_pmv_query_trend.get_sql

84:
85: END IF;
86:
87: /* Call the UI fact code centralization for the Trend */
88: l_trend_sql := hri_oltp_pmv_query_trend.get_sql
89: (p_parameter_rec => l_parameter_rec,
90: p_bind_tab => l_bind_tab,
91: p_trend_sql_params => l_trend_sql_params,
92: p_calling_module => 'HRI_OLTP_PMV_WMV_ABS_SUP_GRAPH.GET_SQL');