DBA Data[Home] [Help]

APPS.ISC_DBI_DAYS_SHIP_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

2: /* $Header: ISCRG70B.pls 120.1 2006/05/03 03:27:24 abhdixi noship $ */
3:
4: PROCEDURE Get_Sql ( p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
5: x_custom_sql OUT NOCOPY VARCHAR2,
6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
7:
8: l_stmt VARCHAR2(10000);
9: l_formula_sql VARCHAR2(10000);
10: l_inner_sql VARCHAR2(10000);

Line 25: l_custom_rec BIS_QUERY_ATTRIBUTES;

21: l_item_cat_flag NUMBER; -- 0 for item, 1 for inv category
22: l_customer_flag NUMBER; -- 0 for customer level, 1 for no-customer level
23: l_agg_level NUMBER;
24: l_lang VARCHAR2(10);
25: l_custom_rec BIS_QUERY_ATTRIBUTES;
26: l_period_type VARCHAR2(30);
27:
28: BEGIN
29:

Line 131: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

127:
128: l_lang := USERENV('LANG');
129:
130: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
131: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
132:
133: l_formula_sql := 'c.curr_booked_to_ship_days ISC_MEASURE_1,
134: c.curr_shipped_line_cnt ISC_MEASURE_2,
135: c.prev_booked_to_ship_days ISC_MEASURE_3,