APPS.IBE_BI_CART_ORD_PVT dependencies on IBE_BI_CART_ORD_PVT

Line 1: PACKAGE BODY IBE_BI_CART_ORD_PVT AS

1: PACKAGE BODY IBE_BI_CART_ORD_PVT AS
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,

Line 26: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_cart_ord_pvt.get_cart_ord_port_sql.begin','BEGIN');

22: l_global_primary VARCHAR2(15);
23: l_global_secondary VARCHAR2(15);
24: BEGIN
25: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
26: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_cart_ord_pvt.get_cart_ord_port_sql.begin','BEGIN');
27: END IF;
28:
29: --initializing the variables
30:

Line 73: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_cart_ord_pvt.get_cart_ord_port_sql.parameters',dbg_msg);

69: l_comparison_type||','||'MINISITE:'||l_minisite||','||'MINISITE_ID:'||
70: l_minisite_id||','||'RECORD_TYPE_ID:'||l_record_type_id||','||'PREV_DATE:'||
71: l_prev_date;
72: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
73: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_cart_ord_pvt.get_cart_ord_port_sql.parameters',dbg_msg);
74: END IF;
75: if (trim(l_minisite_id) is null) then
76: --Change in View done for Bug#:4654974. Issue#12 by narao
77: --The Site Dimension now refers to IBW_BI_MSITE_DIMN_V

Line 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);

166:
167: x_custom_sql := l_custom_sql;
168:
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);

Line 220: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_cart_ord_pvt.get_cart_ord_port_sql.end','END');

216:
217: x_custom_output(6) := l_custom_rec;
218:
219: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
220: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_cart_ord_pvt.get_cart_ord_port_sql.end','END');
221: END IF;
222:
223: END GET_CART_ORD_PORT_SQL;
224:

Line 225: END IBE_BI_CART_ORD_PVT;

221: END IF;
222:
223: END GET_CART_ORD_PORT_SQL;
224:
225: END IBE_BI_CART_ORD_PVT;