DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_TRN_BCKT_GRAPH 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 144: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');

140: p_parameter_rec => l_parameter_rec,
141: p_bind_tab => l_bind_tab);
142:
143: /* Get security clause for Manager based security */
144: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
145:
146: /* Setup any drill url[s] */
147: l_drill_url1 := 'pFunctionName=HRI_P_WMV_TRN_SUP_DTL&' ||
148: 'VIEW_BY_NAME=VIEW_BY_ID&' ||

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

262: p_parameter_rec => l_parameter_rec,
263: p_bind_tab => l_bind_tab);
264:
265: /* Get security clause for Manager based security */
266: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
267:
268: /* Hard code voluntary separations only */
269: l_bind_tab('HRI_WRKACTVT+HRI_WAC_SEPCAT_X').pmv_bind_string := '''SEP_VOL''';
270: l_bind_tab('HRI_WRKACTVT+HRI_WAC_SEPCAT_X').sql_bind_string := '''SEP_VOL''';