APPS.ISC_DBI_SHIP_PERF_TREND_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 5: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

1: PACKAGE BODY ISC_DBI_SHIP_PERF_TREND_PKG AS
2: /* $Header: ISCRG66B.pls 120.2 2006/06/26 06:17:33 abhdixi noship $ */
3:
4: PROCEDURE GET_SQL(p_param IN BIS_PMV_PAGE_PARAMETER_TBL,x_custom_sql OUT NOCOPY VARCHAR2,
5: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
6:
7:
8: l_SQLText VARCHAR2(15000);
9: l_period_type VARCHAR2(30);

Line 21: l_custom_rec BIS_QUERY_ATTRIBUTES ;

17: l_cust_where VARCHAR2(32000);
18: l_item_cat_flag NUMBER; -- 0 for product and 1 for product category
19: l_cust_flag NUMBER; -- 0 for customer level, 1 for no-customer level
20: l_agg_level NUMBER;
21: l_custom_rec BIS_QUERY_ATTRIBUTES ;
22: l_att_2 varchar(255);
23: BEGIN
24:
25: FOR i IN 1..p_param.COUNT

Line 114: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

110: WHEN (l_item_cat_flag = 3 and l_cust_flag = 1) THEN l_agg_level := 3;
111: END CASE;
112:
113: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
114: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
115:
116: If l_period_type = 'FII_TIME_WEEK' then
117: l_att_2 := '''AS_OF_DATE=''||'|| 'to_char(fii1.end_date,''DD/MM/YYYY'')' || '||''&pFunctionName=ISC_DBI_SHIP_PERF_TREND&TIME+FII_TIME_DAY=TIME+FII_TIME_DAY&pParameters=pParamIds@Y''';
118: else