DBA Data[Home] [Help]

APPS.ISC_DBI_PLAN_INV_TURN_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

2: /* $Header: ISCRGAQB.pls 120.1 2006/06/26 06:34:16 abhdixi 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 30: l_custom_rec BIS_QUERY_ATTRIBUTES ;

26: l_pre_end DATE;
27: l_lang varchar2(10);
28: l_viewby_id varchar2(100);
29: l_mon_num NUMBER; -- number of months in the selected period
30: l_custom_rec BIS_QUERY_ATTRIBUTES ;
31: l_curr VARCHAR2(10000);
32: l_curr_g VARCHAR2(15) := '''FII_GLOBAL1''';
33: l_curr_g1 VARCHAR2(15) := '''FII_GLOBAL2''';
34: l_curr_suffix VARCHAR2(15);

Line 195: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

191: END if;
192:
193:
194: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
195: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
196:
197:
198: IF (l_plan IS NULL OR l_plan2 IS NULL)
199: THEN l_stmt := '