APPS.HRI_OLTP_PMV_WMV_BCKT_GRAPH dependencies on HRI_OLTP_PMV_QUERY_TREND

Line 23: l_trend_sql_params hri_oltp_pmv_query_trend.trend_sql_params_type;

19: l_projection_periods NUMBER;
20: l_previous_periods NUMBER;
21:
22: /* Dynamic SQL Controls */
23: l_trend_sql_params hri_oltp_pmv_query_trend.trend_sql_params_type;
24: l_trend_sql VARCHAR2(10000);
25:
26: BEGIN
27:

Line 52: l_trend_sql := hri_oltp_pmv_query_trend.get_sql

48: /* Get the trend sql */
49: l_trend_sql_params.bind_format := 'PMV';
50: l_trend_sql_params.include_hdc := 'Y';
51: l_trend_sql_params.bucket_dim := 'HRI_LOW+HRI_LOW_BAND_X';
52: l_trend_sql := hri_oltp_pmv_query_trend.get_sql
53: (p_parameter_rec => l_parameter_rec,
54: p_bind_tab => l_bind_tab,
55: p_trend_sql_params => l_trend_sql_params,
56: p_calling_module => 'HRI_OLTP_PMV_WMV_BCKT_GRAPH.GET_SQL_BCKT_LOW');

Line 131: l_trend_sql_params hri_oltp_pmv_query_trend.trend_sql_params_type;

127: l_projection_periods NUMBER;
128: l_previous_periods NUMBER;
129:
130: /* Dynamic SQL Controls */
131: l_trend_sql_params hri_oltp_pmv_query_trend.trend_sql_params_type;
132: l_trend_sql VARCHAR2(10000);
133:
134: BEGIN
135:

Line 160: l_trend_sql := hri_oltp_pmv_query_trend.get_sql

156: /* Get the trend sql */
157: l_trend_sql_params.bind_format := 'PMV';
158: l_trend_sql_params.include_hdc := 'Y';
159: l_trend_sql_params.bucket_dim := 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X';
160: l_trend_sql := hri_oltp_pmv_query_trend.get_sql
161: (p_parameter_rec => l_parameter_rec,
162: p_bind_tab => l_bind_tab,
163: p_trend_sql_params => l_trend_sql_params,
164: p_calling_module => 'HRI_OLTP_PMV_WMV_BCKT_GRAPH.GET_SQL_BCKT_PERF');