APPS.ISC_DBI_RETURN_VALUE_TREND_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

2: /* $Header: ISCRGACB.pls 120.1 2006/06/26 06:59:04 abhdixi noship $ */
3:
4:
5: PROCEDURE GET_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,x_custom_sql OUT NOCOPY VARCHAR2,
6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
7:
8: l_stmt VARCHAR2(32000);
9: l_flags_where VARCHAR2(1000);
10: l_org VARCHAR2(32000);

Line 32: l_custom_rec BIS_QUERY_ATTRIBUTES;

28: l_item_cat_flag NUMBER; -- 0 for product, 1 for product category, 3 for no grouping on item dimension
29: l_cust_flag NUMBER; -- 0 for customer and 1 for no customer selected
30: l_reason_flag NUMBER; -- 0 for reason and 1 for all reasons
31: l_mv VARCHAR2(10);
32: l_custom_rec BIS_QUERY_ATTRIBUTES;
33:
34: BEGIN
35:
36: l_g_currency := '''FII_GLOBAL1''';

Line 161: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

157: l_reason_flag := 0;
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: IF ((l_prod IS NULL OR l_prod = '' OR l_prod = 'All') AND
164: (l_cust IS NULL OR l_cust = '' OR l_cust = 'All') AND
165: (l_ret_reason IS NULL OR l_ret_reason = '' OR l_ret_reason = 'All'))