APPS.HRI_OLTP_PMV_WMV_CTR_SUP_GRAPH dependencies on HRI_OLTP_PMV_QUERY_TREND

Line 25: l_trend_sql_params hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE;

21:
22: /* Pre-calculations */
23: l_projection_periods NUMBER;
24: l_previous_periods NUMBER;
25: l_trend_sql_params hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE;
26: --
27: BEGIN
28: --
29: /* Initialize table/record variables */

Line 65: l_trend_sql := hri_oltp_pmv_query_trend.get_sql

61: l_trend_sql_params.include_hdc := 'Y';
62: --
63: -- Get the inner SQL
64: --
65: l_trend_sql := hri_oltp_pmv_query_trend.get_sql
66: (p_parameter_rec => l_parameter_rec,
67: p_bind_tab => l_bind_tab,
68: p_trend_sql_params => l_trend_sql_params,
69: p_calling_module => 'HRI_OLTP_PMV_WMV_CTR_SUP_GRAPH.GET_SQL2');

Line 150: l_trend_sql_params hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE;

146: l_custom_rec BIS_QUERY_ATTRIBUTES;
147: l_sqltext VARCHAR2(10000) ;
148: l_security_clause VARCHAR2(500);
149: l_trend_sql VARCHAR2(32000);
150: l_trend_sql_params hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE;
151:
152: /* Parameter values */
153: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
154: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

Line 198: l_trend_sql := hri_oltp_pmv_query_trend.get_sql

194: l_trend_sql_params.include_sal := 'Y';
195: --
196: -- Get the inner SQL
197: --
198: l_trend_sql := hri_oltp_pmv_query_trend.get_sql
199: (p_parameter_rec => l_parameter_rec,
200: p_bind_tab => l_bind_tab,
201: p_trend_sql_params => l_trend_sql_params,
202: p_calling_module => 'HRI_OLTP_PMV_WMV_CTR_SUP_GRAPH.GET_AVG_SAL_SQL');