DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_CTR_SUP_GRAPH dependencies on HRI_OLTP_PMV_RANK_CTR

Line 20: l_country_tab hri_oltp_pmv_rank_ctr.country_tab_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;
20: l_country_tab hri_oltp_pmv_rank_ctr.country_tab_type;
21:
22: /* Pre-calculations */
23: l_projection_periods NUMBER;
24: l_previous_periods NUMBER;

Line 43: hri_oltp_pmv_rank_ctr.set_top_countries

39: p_parameter_rec => l_parameter_rec,
40: p_bind_tab => l_bind_tab);
41:
42: /* Populate global table with top 4 country names and codes */
43: hri_oltp_pmv_rank_ctr.set_top_countries
44: (p_supervisor_id => l_parameter_rec.peo_supervisor_id,
45: p_effective_date => l_parameter_rec.time_curr_end_date,
46: p_no_countries => 4,
47: p_country_tab => l_country_tab);

Line 155: l_country_tab hri_oltp_pmv_rank_ctr.country_tab_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;
159: l_previous_periods NUMBER;

Line 178: hri_oltp_pmv_rank_ctr.set_top_countries

174: p_parameter_rec => l_parameter_rec,
175: p_bind_tab => l_bind_tab);
176:
177: /* Populate global table with top 4 country names and codes */
178: hri_oltp_pmv_rank_ctr.set_top_countries
179: (p_supervisor_id => l_parameter_rec.peo_supervisor_id,
180: p_effective_date => l_parameter_rec.time_curr_end_date,
181: p_no_countries => 4,
182: p_country_tab => l_country_tab);