DBA Data[Home] [Help]

APPS.ISC_DBI_PDUE_PRM_TREND_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_period_type VARCHAR2(10000);
11: l_inv_org VARCHAR2(10000);

Line 29: l_custom_rec BIS_QUERY_ATTRIBUTES;

25: l_curr_suffix VARCHAR2(120);
26: l_item_cat_flag NUMBER;
27: l_cust_flag NUMBER;
28:
29: l_custom_rec BIS_QUERY_ATTRIBUTES;
30:
31: BEGIN
32:
33: l_curr_g := '''FII_GLOBAL1''';

Line 134: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

130: l_item_cat_flag := 0; -- product
131: END IF;
132:
133: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
134: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
135:
136: IF ((l_prod IS NULL OR l_prod = 'All') AND
137: (l_cust IS NULL OR l_cust = 'All'))
138: THEN