DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_SAL_SUP_GRAPH dependencies on HRI_OLTP_PMV_QUERY_TREND

Line 15: l_trend_sql_params hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE;

11:
12: l_custom_rec BIS_QUERY_ATTRIBUTES;
13: l_security_clause VARCHAR2(4000);
14: l_SQLText VARCHAR2(32000);
15: l_trend_sql_params hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE;
16:
17: /* Parameter values */
18: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
19: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

Line 55: l_trend_sql := hri_oltp_pmv_query_trend.get_sql

51: l_trend_sql_params.bind_format := 'PMV';
52: l_trend_sql_params.include_hdc := 'Y';
53: l_trend_sql_params.include_sal := 'Y';
54:
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_WMV_SAL_SUP_GRAPH.GET_SQL2');