APPS.ENI_DBI_FPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

2: /* $Header: ENIFPTPB.pls 120.0 2005/05/26 19:36:28 appldev 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_period_type VARCHAR2(10000);
10: l_mv1 VARCHAR2(100);

Line 34: l_custom_rec BIS_QUERY_ATTRIBUTES;

30: l_item_cat_flag NUMBER; -- 0 for product, 1 for product category, 3 for no grouping on item dimension
31: l_cust_flag NUMBER; -- 0 for customer and 1 for no customer selected
32:
33: l_order_by VARCHAR2(250);
34: l_custom_rec BIS_QUERY_ATTRIBUTES;
35:
36: BEGIN
37: l_period_type := 'TEST';
38: FOR i IN 1..p_param.COUNT LOOP

Line 263: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

259:
260: x_custom_sql := l_stmt;
261:
262: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
263: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
264:
265: l_custom_rec.attribute_name := ':ENI_ITEM_CAT_FLAG';
266: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
267: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;