DBA Data[Home] [Help]

APPS.ISC_DBI_FULF_PERF_T_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 8: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

4:
5:
6: PROCEDURE Get_Sql ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
7: x_custom_sql OUT NOCOPY VARCHAR2,
8: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
9:
10: l_stmt VARCHAR2(10000);
11: l_measures VARCHAR2(10000);
12: l_select_stmt VARCHAR2(10000);

Line 36: l_custom_rec BIS_QUERY_ATTRIBUTES;

32: l_lang VARCHAR2(10);
33: l_item_cat_flag NUMBER;
34: l_cust_flag NUMBER;
35:
36: l_custom_rec BIS_QUERY_ATTRIBUTES;
37:
38: BEGIN
39:
40: l_lang := userenv('LANG');

Line 161: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

157: l_item_cat_flag := 0; -- product
158: END IF;
159:
160: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
161: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
162:
163: l_measures := 'ISC_MEASURE_1,ISC_MEASURE_2,ISC_MEASURE_3,ISC_MEASURE_4,ISC_MEASURE_5,
164: ISC_MEASURE_6,ISC_MEASURE_7,ISC_MEASURE_8,ISC_MEASURE_9,ISC_MEASURE_10,
165: ISC_MEASURE_11,ISC_MEASURE_12';