DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_TRN_SUP_GRAPH dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 14: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

10: l_security_clause VARCHAR2(4000);
11: l_SQLText VARCHAR2(10000) ;
12:
13: /* Parameter values */
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;

Line 15: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

11: l_SQLText VARCHAR2(10000) ;
12:
13: /* Parameter values */
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);

Line 36: hri_oltp_pmv_util_param.get_parameters_from_table

32: /* Get security clause for Manager based security */
33: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
34:
35: /* Get common parameter values */
36: hri_oltp_pmv_util_param.get_parameters_from_table
37: (p_page_parameter_tbl => p_page_parameter_tbl,
38: p_parameter_rec => l_parameter_rec,
39: p_bind_tab => l_bind_tab);
40: