APPS.HRI_OLTP_PMV_WMV_TRN_CTR dependencies on HRI_OLTP_PMV_UTIL_PKG

Line 43: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

39: p_parameter_rec => l_parameter_rec,
40: p_bind_tab => l_bind_tab);
41:
42: /* Get security clause for Manager based security */
43: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
44:
45: /* Get the annualization factor for the different periods */
46: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor
47: (p_period_type => l_parameter_rec.page_period_type);

Line 46: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor

42: /* Get security clause for Manager based security */
43: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
44:
45: /* Get the annualization factor for the different periods */
46: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor
47: (p_period_type => l_parameter_rec.page_period_type);
48:
49: /* Get bind values for number of time periods */
50: hri_oltp_pmv_query_time.get_period_binds

Line 227: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

223: /* Force the View By parameter to Country */
224: l_parameter_rec.view_by := 'GEOGRAPHY+COUNTRY';
225:
226: /* Get security clause for Manager based security */
227: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
228:
229: /* Get the annualization factor for the different periods */
230: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor
231: (p_period_type => l_parameter_rec.page_period_type);

Line 230: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor

226: /* Get security clause for Manager based security */
227: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
228:
229: /* Get the annualization factor for the different periods */
230: l_calc_anl_factor := hri_oltp_pmv_util_pkg.calc_anl_factor
231: (p_period_type => l_parameter_rec.page_period_type);
232:
233: /* Generate the Turnover Fact SQL */
234: l_wcnt_chg_params.bind_format := 'PMV';