APPS.HRI_OLTP_PMV_WMV_TRN_SUP_BCKT dependencies on HRI_OLTP_PMV_UTIL_PKG

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

88: p_parameter_rec => l_parameter_rec,
89: p_bind_tab => l_bind_tab);
90:
91: /* Get security clause for Manager based security */
92: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
93:
94: /* Get direct reports string */
95: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
96:

Line 98: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by

94: /* Get direct reports string */
95: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
96:
97: /* Swap the viewby column for the default sort order */
98: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
99: (p_order_by_clause => l_parameter_rec.order_by);
100:
101: /* Get termination grand totals */
102: hri_bpl_dbi_calc_period.calc_sup_term_perf_pvt

Line 151: l_view_by_filter := hri_oltp_pmv_util_pkg.set_viewby_filter

147: l_parameter_rec.view_by = 'HRI_LOW+HRI_LOW_BAND_X') THEN
148: /* Outer join to facts, display all rows */
149: l_wmv_outer_join := ' (+)';
150: /* Set the view by filter */
151: l_view_by_filter := hri_oltp_pmv_util_pkg.set_viewby_filter
152: (p_parameter_rec => l_parameter_rec,
153: p_bind_tab => l_bind_tab,
154: p_view_by_alias => 'cl');
155: ELSE

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

517: p_parameter_rec => l_parameter_rec,
518: p_bind_tab => l_bind_tab);
519:
520: /* Get security clause for Manager based security */
521: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
522:
523: /* Get direct reports string */
524: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
525:

Line 630: l_view_by_filter := hri_oltp_pmv_util_pkg.set_viewby_filter

626: l_parameter_rec.view_by = 'HRI_LOW+HRI_LOW_BAND_X') THEN
627: /* Outer join to facts, display all rows */
628: l_wmv_outer_join := ' (+)';
629: /* Set the view by filter */
630: l_view_by_filter := hri_oltp_pmv_util_pkg.set_viewby_filter
631: (p_parameter_rec => l_parameter_rec,
632: p_bind_tab => l_bind_tab,
633: p_view_by_alias => 'cl');
634: ELSE

Line 649: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by

645: 'AND &BIS_CURRENT_ASOF_DATE BETWEEN cl.start_date AND cl.end_date';
646: END IF;
647:
648: /* Swap the viewby column for the default sort order */
649: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
650: (p_order_by_clause => l_parameter_rec.order_by);
651:
652: l_sqltext :=
653: 'SELECT -- Terminations with Length of Service Portlet

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

860: BEGIN
861: --
862: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
863: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
864: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
865: --
866: -- Get the parameter information from the page parameter table
867: --
868: hri_oltp_pmv_util_param.get_parameters_from_table