DBA Data[Home] [Help]

APPS.ISC_DBI_BACKLOG_PDUE_TREND_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(32000);
11: l_mv1 VARCHAR2(100);
12: l_mv2 VARCHAR2(100);

Line 34: l_custom_rec BIS_QUERY_ATTRIBUTES;

30: l_curr_suffix VARCHAR2(120);
31: l_item_cat_flag NUMBER;
32: l_cust_flag NUMBER;
33:
34: l_custom_rec BIS_QUERY_ATTRIBUTES;
35:
36: BEGIN
37:
38: l_curr_g := '''FII_GLOBAL1''';

Line 145: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

141: l_item_cat_flag := 0; -- product
142: END IF;
143:
144: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
145: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
146:
147: IF ((l_prod IS NULL OR l_prod = 'All') AND
148: (l_cust IS NULL OR l_cust = 'All'))
149: THEN