21: dbg_msg VARCHAR2(3200);
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
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:
68: ','||'PERIOD_TYPE:'||l_period_type||','||'COMPARISION_TYPE:'||
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
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
165: '''IBE_QOT_QUOTING'',8 )) ORDER BY OB';
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();
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);
215: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
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;
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: