APPS.HRI_OLTP_PMV_WMV_TRN_SUP_GRAPH dependencies on HRI_OLTP_PMV_QUERY_TREND

Line 18: l_trend_sql_params hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE;

14: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
15: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
16:
17: /* Dynamic SQL */
18: l_trend_sql_params hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE;
19: l_trend_sql VARCHAR2(10000);
20:
21: /* Pre-calculations */
22: l_anl_factor NUMBER;

Line 59: l_trend_sql := hri_oltp_pmv_query_trend.get_sql

55: l_trend_sql_params.include_sep_inv := 'Y';
56: l_trend_sql_params.include_sep_vol := 'Y';
57:
58: /* Get the inner SQL */
59: l_trend_sql := hri_oltp_pmv_query_trend.get_sql
60: (p_parameter_rec => l_parameter_rec,
61: p_bind_tab => l_bind_tab,
62: p_trend_sql_params => l_trend_sql_params,
63: p_calling_module => 'HRI_OLTP_PMV_WMV_TRN_SUP_GRAPH.GET_SQL2');