DBA Data[Home] [Help]

APPS.ISC_DBI_PLAN_PUR_COST_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 30: l_custom_rec BIS_QUERY_ATTRIBUTES;

26: l_time_from DATE;
27: l_lang VARCHAR2(10);
28: l_item_cat_flag NUMBER;
29: l_row_filter VARCHAR2(10000);
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 166: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

162:
163: l_lang := USERENV('LANG');
164:
165: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
166: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
167:
168:
169: IF (l_plan IS NULL OR l_plan2 IS NULL)
170: THEN l_stmt := '