DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_WF_SUP dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 15: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

11: --
12: PROCEDURE get_kpi
13: (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) IS
16:
17: l_SQLText VARCHAR2(32000);
18: l_security_clause VARCHAR2(4000);
19: l_custom_rec BIS_QUERY_ATTRIBUTES ;

Line 33: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

29: BEGIN
30:
31: /* Initialize out parameters */
32: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
33: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
34:
35: /* Get security clause for Manager based security */
36: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
37:

Line 94: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

90: -- ***************************************************
91: --
92: PROCEDURE get_sql(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
93: x_custom_sql OUT NOCOPY VARCHAR2,
94: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
95:
96: l_sqltext VARCHAR2(32767);
97: l_security_clause VARCHAR2(4000);
98: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 150: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

146: BEGIN
147:
148: /* Initialize out parameters */
149: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
150: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
151:
152: /* Get common parameter values */
153: hri_oltp_pmv_util_param.get_parameters_from_table
154: (p_page_parameter_tbl => p_page_parameter_tbl,