APPS.HRI_OLTP_PMV_WMV_TRN_SUP dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 12: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

8: /* Annualized Turnover Portlet */
9: /******************************************************************************/
10: PROCEDURE get_sql2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
11: x_custom_sql OUT NOCOPY VARCHAR2,
12: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
13:
14: /* Variables for SQL returned */
15: l_sqltext VARCHAR2(30000) ;
16: l_security_clause VARCHAR2(4000);

Line 51: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

47: BEGIN
48:
49: /* Initialize out parameters */
50: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
51: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
52:
53: /* Get security clause for Manager based security */
54: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
55:

Line 312: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

308: /******************************************************************************/
309: PROCEDURE get_actual_detail_sql2
310: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
311: x_custom_sql OUT NOCOPY VARCHAR2,
312: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
313:
314: /* Variables for SQL returned */
315: l_sqltext VARCHAR2(30000) ;
316: l_security_clause VARCHAR2(4000);

Line 387: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

383: 'pParamIds=Y';
384:
385: /* Initialize out parameters */
386: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
387: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
388:
389: /* Get security clause for Manager based security */
390: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
391:

Line 597: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

593: END get_actual_detail_sql2;
594:
595: PROCEDURE GET_SQL_TRN_PVT(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
596: x_custom_sql OUT NOCOPY VARCHAR2,
597: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
598:
599: l_SQLText VARCHAR2(32767) ;
600: l_custom_rec BIS_QUERY_ATTRIBUTES;
601:

Line 637: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

633:
634: BEGIN
635: /* Initialize out parameters */
636: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
637: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
638:
639: /* Get common parameter values */
640: hri_oltp_pmv_util_param.get_parameters_from_table
641: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 887: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

883: -- -----------------------------------------------------------------------
884: --
885: PROCEDURE get_trn_los_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
886: x_custom_sql OUT NOCOPY VARCHAR2,
887: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
888: --
889: l_custom_rec BIS_QUERY_ATTRIBUTES;
890: --
891: -- The security clause

Line 914: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

910: --
911:
912: BEGIN
913: --
914: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
915: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
916: --
917: -- Get the parameter information from the page parameter table
918: --

Line 983: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

979: -- -----------------------------------------------------------------------
980: --
981: PROCEDURE get_wmv_trn_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
982: x_custom_sql OUT NOCOPY VARCHAR2,
983: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
984: --
985: l_custom_rec BIS_QUERY_ATTRIBUTES;
986: --
987: -- The security clause

Line 1022: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1018: l_comp_hdc_end_col VARCHAR2(100);
1019:
1020: BEGIN
1021: --
1022: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1023: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1024: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
1025: --
1026: -- Get the parameter information from the page parameter table