APPS.HRI_OLTP_PMV_WMV_TRN_SUP_BCKT dependencies on BIS_QUERY_ATTRIBUTES

Line 38: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

34:
35: PROCEDURE get_sql_bkct_perf
36: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
37: x_custom_sql OUT NOCOPY VARCHAR2,
38: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
39:
40:
41: l_SQLText VARCHAR2(32767) ;
42: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 42: l_custom_rec BIS_QUERY_ATTRIBUTES;

38: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
39:
40:
41: l_SQLText VARCHAR2(32767) ;
42: l_custom_rec BIS_QUERY_ATTRIBUTES;
43: l_security_clause VARCHAR2(4000);
44:
45: /* Parameter values */
46: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

Line 83: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

79:
80: BEGIN
81: /* Initialize out parameters */
82: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
83: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
84:
85: /* Get common parameter values */
86: hri_oltp_pmv_util_param.get_parameters_from_table
87: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 469: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

465: /******************************************************************************/
466: PROCEDURE GET_TRN_POW_SQL
467: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
468: x_custom_sql OUT NOCOPY VARCHAR2,
469: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
470:
471: l_sqltext VARCHAR2(32767);
472: l_custom_rec BIS_QUERY_ATTRIBUTES;
473: l_security_clause VARCHAR2(4000);

Line 472: l_custom_rec BIS_QUERY_ATTRIBUTES;

468: x_custom_sql OUT NOCOPY VARCHAR2,
469: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
470:
471: l_sqltext VARCHAR2(32767);
472: l_custom_rec BIS_QUERY_ATTRIBUTES;
473: l_security_clause VARCHAR2(4000);
474:
475: /* Parameter values */
476: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

Line 512: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

508: BEGIN
509:
510: /* Initialize out parameters */
511: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
512: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
513:
514: /* Get common parameter values */
515: hri_oltp_pmv_util_param.get_parameters_from_table
516: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 837: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

833: --
834: PROCEDURE get_trn_perf_kpi
835: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
836: x_custom_sql OUT NOCOPY VARCHAR2,
837: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
838: --
839: -- The security clause
840: --
841: l_security_clause VARCHAR2(4000);

Line 858: l_custom_rec BIS_QUERY_ATTRIBUTES;

854: --
855: -- Inner SQL
856: --
857: l_inn_sql VARCHAR2(32767);
858: l_custom_rec BIS_QUERY_ATTRIBUTES;
859: --
860: BEGIN
861: --
862: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 862: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

858: l_custom_rec BIS_QUERY_ATTRIBUTES;
859: --
860: BEGIN
861: --
862: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
863: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
864: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
865: --
866: -- Get the parameter information from the page parameter table