DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_ABS_WMV_PVT dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 15: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

11: --****************************************************************************
12: --
13: PROCEDURE GET_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
14: ,x_custom_sql OUT NOCOPY VARCHAR2
15: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
16: IS
17:
18: l_SQLText VARCHAR2(32000);
19: l_security_clause VARCHAR2(4000);

Line 58: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

54:
55: BEGIN
56: /* Initialize out parameters */
57: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
58: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
59:
60: /* Get security clause for Manager based security */
61: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
62:

Line 361: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

357: --****************************************************************************
358: --
359: PROCEDURE GET_SQL_KPI(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
360: ,x_custom_sql OUT NOCOPY VARCHAR2
361: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
362: IS
363:
364: l_SQLText VARCHAR2(32000);
365: l_security_clause VARCHAR2(4000);

Line 393: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

389:
390: BEGIN
391: /* Initialize out parameters */
392: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
393: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
394:
395: /* Get security clause for Manager based security */
396: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
397: