APPS.ISC_DBI_SHIP_LATE_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 5: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

1: PACKAGE BODY ISC_DBI_SHIP_LATE_PKG AS
2: /* $Header: ISCRG67B.pls 120.1 2006/06/26 06:20:08 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: l_formula_sql VARCHAR2(32000);
8: l_inner_sql VARCHAR2(32000);
9: l_outer_sql VARCHAR2(32000);

Line 24: l_custom_rec BIS_QUERY_ATTRIBUTES ;

20: l_lang VARCHAR2(10);
21: l_item_cat_flag NUMBER; -- 0 for item and 1 for inv. category
22: l_cust_flag NUMBER; -- 0 for customer level, 1 for no-customer level
23: l_agg_level NUMBER;
24: l_custom_rec BIS_QUERY_ATTRIBUTES ;
25: l_const NUMBER:=0; -- used for the zero row filter
26:
27: BEGIN
28: FOR i IN 1..p_param.COUNT

Line 134: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

130:
131: l_lang := USERENV('LANG');
132:
133: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
134: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
135:
136: l_formula_sql :='
137: a.late_line_cnt ISC_MEASURE_1,
138: a.late_line_cnt/decode(a.shipped_line_cnt,