DBA Data[Home] [Help]

APPS.ENI_DBI_RVA_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 6: , x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL )

2: /* $Header: ENIRVAPB.pls 120.1 2006/03/22 23:36:32 ajerome 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 )
7: IS
8:
9: l_stmt VARCHAR2(32000);
10: l_measures VARCHAR2(32000);

Line 40: l_custom_rec BIS_QUERY_ATTRIBUTES ;

36: l_lang VARCHAR2(10);
37: l_item_cat_flag NUMBER; -- 0 for product and 1 for product category
38: l_cust_flag NUMBER; -- 0 for customer and 1 for no customer selected
39: l_reason_flag NUMBER; -- 0 for reason and 1 for all reasons
40: l_custom_rec BIS_QUERY_ATTRIBUTES ;
41:
42: l_all_prods BOOLEAN;
43: l_all_prod_cats BOOLEAN;
44: l_all_custs BOOLEAN;

Line 551: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

547:
548: x_custom_sql := l_stmt;
549:
550: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
551: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
552:
553: l_custom_rec.attribute_name := ':ENI_ITEM_CAT_FLAG';
554: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
555: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;