DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_WF_SUP_GRAPH dependencies on HRI_OLTP_PMV_QUERY_TREND

Line 16: l_trend_sql_params hri_oltp_pmv_query_trend.TREND_SQL_PARAMS_TYPE;

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

Line 60: l_trend_sql := hri_oltp_pmv_query_trend.get_sql

56: l_trend_sql_params.bind_format := 'PMV';
57: l_trend_sql_params.include_hdc := 'Y';
58: l_trend_sql_params.bucket_dim := 'HRI_PRSNTYP+HRI_WKTH_WKTYP';
59:
60: l_trend_sql := hri_oltp_pmv_query_trend.get_sql
61: (p_parameter_rec => l_parameter_rec,
62: p_bind_tab => l_bind_tab,
63: p_trend_sql_params => l_trend_sql_params,
64: p_calling_module => 'HRI_OLTP_PMV_WMV_WF_SUP_GRAPH.get_sql2');