APPS.HRI_OLTP_PMV_WMV_CTR_SUP_GRAPH dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 18: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

14: l_security_clause VARCHAR2(500);
15: l_trend_sql VARCHAR2(32000);
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;
20: l_country_tab hri_oltp_pmv_rank_ctr.country_tab_type;
21:
22: /* Pre-calculations */

Line 19: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

15: l_trend_sql VARCHAR2(32000);
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;
20: l_country_tab hri_oltp_pmv_rank_ctr.country_tab_type;
21:
22: /* Pre-calculations */
23: l_projection_periods NUMBER;

Line 37: hri_oltp_pmv_util_param.get_parameters_from_table

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

Line 153: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

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;
155: l_country_tab hri_oltp_pmv_rank_ctr.country_tab_type;
156:
157: /* Pre-calculations */

Line 154: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

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;
155: l_country_tab hri_oltp_pmv_rank_ctr.country_tab_type;
156:
157: /* Pre-calculations */
158: l_projection_periods NUMBER;

Line 172: hri_oltp_pmv_util_param.get_parameters_from_table

168: /* Get security clause for Manager based security */
169: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
170:
171: /* Get common parameter values */
172: hri_oltp_pmv_util_param.get_parameters_from_table
173: (p_page_parameter_tbl => p_page_parameter_tbl,
174: p_parameter_rec => l_parameter_rec,
175: p_bind_tab => l_bind_tab);
176: