APPS.HRI_OLTP_PMV_ABS_CAT dependencies on HRI_OLTP_PMV_UTIL_PKG

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

50: p_parameter_rec => l_parameter_rec,
51: p_bind_tab => l_bind_tab);
52:
53: /* Get security clause for Manager based security */
54: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
55:
56: /* Get bind values for number of time periods */
57: hri_oltp_pmv_query_time.get_period_binds
58: (p_page_period_type => l_parameter_rec.page_period_type

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

242: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
243: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
244:
245: /* Get security clause for Manager based security */
246: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
247:
248: /* Get common parameter values */
249: hri_oltp_pmv_util_param.get_parameters_from_table
250: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 261: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by

257: 'VIEW_BY_NAME=VIEW_BY_ID&' ||
258: 'pParamIds=Y';
259:
260: /* Set order by */
261: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
262: (p_order_by_clause => l_parameter_rec.order_by);
263:
264: /* formulate the dynmaic column selection based on Absence Duration
265: unit of measure paramter selection Default Days */