DBA Data[Home] [Help]

APPS.ISC_DBI_PLAN_PRS_TREND_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

2: /* $Header: ISCRGB4B.pls 120.0 2005/05/25 17:39:55 appldev noship $ */
3:
4:
5: PROCEDURE GET_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,x_custom_sql OUT NOCOPY VARCHAR2,
6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
7:
8: l_stmt VARCHAR2(32000);
9: l_plan VARCHAR2(10000);
10: l_plan2 VARCHAR2(10000);

Line 25: l_custom_rec BIS_QUERY_ATTRIBUTES ;

21: l_curr_suffix VARCHAR2(15);
22: l_period_type_id NUMBER;
23: l_period_id VARCHAR2(30);
24: l_loop NUMBER;
25: l_custom_rec BIS_QUERY_ATTRIBUTES ;
26:
27:
28:
29: BEGIN

Line 140: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

136: END LOOP;
137:
138:
139: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
140: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
141:
142: IF (l_plan IS NULL OR l_plan2 IS NULL)
143: THEN l_stmt := '
144: SELECT 0 VIEWBY,