APPS.HRI_OLTP_PMV_WMV_SUP_BCKT dependencies on HRI_OLTP_PMV_UTIL_PKG

Line 73: p_dynsql_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by

69:
70: BEGIN
71:
72: /* Set the order by */
73: p_dynsql_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
74: (p_order_by_clause => p_parameter_rec.order_by);
75:
76: /* View by Person */
77: /******************/

Line 120: p_dynsql_rec.viewby_condition := hri_oltp_pmv_util_pkg.set_viewby_filter

116: /* regardless of whether there is any headcount or turnover */
117: p_dynsql_rec.wrkfc_outer_join := '(+)';
118:
119: /* Filter if a view by parameter is set */
120: p_dynsql_rec.viewby_condition := hri_oltp_pmv_util_pkg.set_viewby_filter
121: (p_parameter_rec => p_parameter_rec,
122: p_bind_tab => p_bind_tab,
123: p_view_by_alias => 'vby');
124:

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

241: p_bucket_dim => 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X',
242: p_dynsql_rec => l_dynsql_rec);
243:
244: /* Get security clause for Manager based security */
245: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
246:
247: /* Get direct reports string */
248: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
249:

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

437: l_drill_url5 := l_dynsql_rec.drill_url5;
438: l_drill_url6 := l_dynsql_rec.drill_url6;
439:
440: /* Get security clause for Manager based security */
441: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
442:
443: /* Get direct reports string */
444: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
445:

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

647: BEGIN
648: --
649: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
650: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
651: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
652: --
653: -- Get the parameter information from the page parameter table
654: --
655: hri_oltp_pmv_util_param.get_parameters_from_table