APPS.ISC_DBI_SHIP_PERF_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

2: /* $Header: ISCRG65B.pls 120.2 2006/06/26 06:09:10 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_formula_sql VARCHAR2(32000);
9: l_inner_sql VARCHAR2(32000);
10: l_outer_sql VARCHAR2(32000);

Line 24: l_custom_rec BIS_QUERY_ATTRIBUTES ;

20: l_cust_flag NUMBER; -- 0 for customer level, 1 for no-customer level
21: l_agg_level NUMBER;
22: l_cust VARCHAR2(32000);
23: l_cust_where VARCHAR2(32000);
24: l_custom_rec BIS_QUERY_ATTRIBUTES ;
25: l_lang varchar2(10);
26: l_period_type varchar2(30);
27:
28:

Line 141: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

137:
138: l_lang := USERENV('LANG');
139:
140: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
141: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
142:
143: l_formula_sql := '
144: c.curr_shipped ISC_MEASURE_1,
145: c.prev_shipped ISC_MEASURE_2,