APPS.HRI_OLTP_PMV_TRN_BCKT_GRAPH dependencies on HRI_OLTP_PMV_QUERY_TREND

Line 26: l_trend_sql_params hri_oltp_pmv_query_trend.trend_sql_params_type;

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

Line 55: l_trend_sql := hri_oltp_pmv_query_trend.get_sql

51: /* Get the trend sql */
52: l_trend_sql_params.bind_format := 'PMV';
53: l_trend_sql_params.include_sep := 'Y';
54: l_trend_sql_params.bucket_dim := 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X';
55: l_trend_sql := hri_oltp_pmv_query_trend.get_sql
56: (p_parameter_rec => l_parameter_rec,
57: p_bind_tab => l_bind_tab,
58: p_trend_sql_params => l_trend_sql_params,
59: p_calling_module => 'HRI_OLTP_PMV_TRN_BCKT_GRAPH.GET_SQL_BCKT_PERF');