APPS.HRI_OLTP_PMV_WMV_SUP dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 9: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

5: ';
6:
7: PROCEDURE get_sql2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
8: x_custom_sql OUT NOCOPY VARCHAR2,
9: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
10:
11: l_sqltext VARCHAR2(32767);
12: l_security_clause VARCHAR2(4000);
13: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 55: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

51: BEGIN
52:
53: /* Initialize out parameters */
54: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
55: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
56:
57: /* Get common parameter values */
58: hri_oltp_pmv_util_param.get_parameters_from_table
59: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 315: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

311: -- ----------------------------------------------------------------------
312: --
313: PROCEDURE get_wmv_low_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
314: x_custom_sql OUT NOCOPY VARCHAR2,
315: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
316: --
317: -- The security clause
318: --
319: l_security_clause VARCHAR2(4000);

Line 340: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

336: l_custom_rec BIS_QUERY_ATTRIBUTES;
337: --
338: BEGIN
339: --
340: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
341: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
342: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
343: --
344: -- Get the parameter information from the page parameter table

Line 397: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

393:
394: /* CWK KPIs */
395: PROCEDURE get_wmv_c_low_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
396: x_custom_sql OUT NOCOPY VARCHAR2,
397: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
398:
399: l_sqltext VARCHAR2(32767);
400: l_security_clause VARCHAR2(4000);
401: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 419: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

415: BEGIN
416:
417: /* Initialize out parameters */
418: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
419: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
420:
421: /* Get common parameter values */
422: hri_oltp_pmv_util_param.get_parameters_from_table
423: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 483: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

479: END get_wmv_c_low_kpi;
480:
481: PROCEDURE get_wmv_c_atvty_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
482: x_custom_sql OUT NOCOPY VARCHAR2,
483: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
484:
485: l_sqltext VARCHAR2(32767);
486: l_security_clause VARCHAR2(4000);
487: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 505: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

501: BEGIN
502:
503: /* Initialize out parameters */
504: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
505: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
506:
507: /* Get common parameter values */
508: hri_oltp_pmv_util_param.get_parameters_from_table
509: (p_page_parameter_tbl => p_page_parameter_tbl,