DBA Data[Home] [Help]

APPS.ISC_DBI_PLAN_CB_SUM_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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

Line 29: l_custom_rec BIS_QUERY_ATTRIBUTES;

25: l_lang VARCHAR2(10);
26: l_item_cat_flag NUMBER;
27: l_union1_flag NUMBER := 0;
28: l_row_filter VARCHAR2(10000);
29: l_custom_rec BIS_QUERY_ATTRIBUTES;
30: l_curr VARCHAR2(10000);
31: l_curr_g VARCHAR2(15) := '''FII_GLOBAL1''';
32: l_curr_g1 VARCHAR2(15) := '''FII_GLOBAL2''';
33: l_col1 VARCHAR2(100);

Line 164: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

160:
161: l_lang := USERENV('LANG');
162:
163: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
164: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
165:
166: IF (l_plan IS NULL OR l_plan2 IS NULL)
167: THEN l_stmt := '
168: SELECT 0 VIEWBY,