DBA Data[Home] [Help]

APPS.ISC_DBI_RETURN_VALUE_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

2: /* $Header: ISCRGABB.pls 120.1 2006/06/26 06:57:50 abhdixi noship $ */
3:
4: PROCEDURE GET_SQL( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
5: 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_measures VARCHAR2(32000);
10: l_select_stmt VARCHAR2(32000);

Line 37: l_custom_rec BIS_QUERY_ATTRIBUTES ;

33: l_lang VARCHAR2(10);
34: l_item_cat_flag NUMBER; -- 0 for product and 1 for product category
35: l_cust_flag NUMBER; -- 0 for customer and 1 for no customer selected
36: l_reason_flag NUMBER; -- 0 for reason and 1 for all reasons
37: l_custom_rec BIS_QUERY_ATTRIBUTES ;
38:
39: BEGIN
40:
41: l_lang := userenv('LANG');

Line 176: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

172: l_reason_flag := 0;
173: END IF;
174:
175: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
176: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
177:
178: l_measures := 'ISC_MEASURE_1,ISC_MEASURE_2,ISC_MEASURE_3,ISC_MEASURE_4,ISC_MEASURE_5,
179: ISC_MEASURE_6,ISC_MEASURE_7,ISC_MEASURE_8,ISC_MEASURE_9,ISC_MEASURE_10,
180: ISC_MEASURE_11,ISC_MEASURE_12,ISC_MEASURE_13,ISC_MEASURE_14,ISC_MEASURE_15';