DBA Data[Home] [Help]

APPS.IBE_BI_CART_ORD_PVT dependencies on BIS_QUERY_ATTRIBUTES

Line 6: x_custom_output OUT NOCOPY bis_query_attributes_TBL

2: /* $Header: IBEVBICARTORDB.pls 120.6 2006/06/26 08:57:42 gjothiku ship $ */
3: PROCEDURE GET_CART_ORD_PORT_SQL(
4: p_pmv_parameters 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: l_custom_sql VARCHAR2(4000);
9: l_parameter_name VARCHAR2(3200);
10: l_asof_date DATE;

Line 20: l_custom_rec BIS_QUERY_ATTRIBUTES;

16: l_minisite VARCHAR2(3200);
17: l_minisite_id VARCHAR2(3200);
18: l_msiteFilter VARCHAR2(1000);
19: l_tableList VARCHAR2(1000);
20: l_custom_rec BIS_QUERY_ATTRIBUTES;
21: dbg_msg VARCHAR2(3200);
22: l_global_primary VARCHAR2(15);
23: l_global_secondary VARCHAR2(15);
24: BEGIN

Line 173: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

169: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_cart_ord_pvt.get_cart_ord_port_sql.query',l_custom_sql);
171: END IF;
172:
173: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
174: x_custom_output.Extend(6);
175:
176: l_custom_rec.attribute_name := ':l_asof_date' ;
177: l_custom_rec.attribute_value:= to_char(l_asof_date,'dd/mm/yyyy');