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);
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:
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);
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: