DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_WF_SUP dependencies on HRI_OLTP_PMV_UTIL_PKG

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

32: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
33: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
34:
35: /* Get security clause for Manager based security */
36: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
37:
38: /* Get common parameter values */
39: hri_oltp_pmv_util_param.get_parameters_from_table
40: (p_page_parameter_tbl => p_page_parameter_tbl,

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

204: 'HRI_P_SUPH_RO_CA=HRI_P_SUPH_RO_CA&' ||
205: 'pParamIds=Y';
206:
207: /* Get security clause for Manager based security */
208: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
209:
210: /* Set direct reports string */
211: l_direct_reports_string := hri_oltp_view_message.get_direct_reports_msg;
212:

Line 256: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by

252: l_tot_loss := l_tot_loss_all + l_tot_loss_transfer_all;
253: l_tot_net := l_tot_gain - l_tot_loss;
254:
255: /* Set the dynamic order by from the dimension metadata */
256: l_parameter_rec.order_by := hri_oltp_pmv_util_pkg.set_default_order_by
257: (p_order_by_clause => l_parameter_rec.order_by);
258:
259:
260: /* Currently Using Standalone query */