eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_BI_TOP_ACT_PVT dependencies on FND_LOG

Line 39: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

35: l_global_primary VARCHAR2(15);
36: l_global_secondary VARCHAR2(15) ;
37: BEGIN
38:
39: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
40: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_orders_sql.begin','BEGIN');
41: END IF;
42:
43: -- initilization of variables

Line 40: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_orders_sql.begin','BEGIN');

36: l_global_secondary VARCHAR2(15) ;
37: BEGIN
38:
39: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
40: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_orders_sql.begin','BEGIN');
41: END IF;
42:
43: -- initilization of variables
44:

Line 106: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

102: l_minisite_id||','||'ORDER_BY:'||l_OrderBy||','||'LOOKUP_TYPE:'||
103: l_fnd_rec.lookup_type||','||'QUOTE_LABEL:'||l_QuoteLabel||','||'CART_LABEL:'||
104: l_CartLabel||','||'YES_LABEL:'||l_YesLabel||','||'NO_LABEL:'||l_NoLabel||','||
105: 'RECORD_TYPE_ID:'||l_record_type_id||','||'PREV_DATE:'||l_prev_date;
106: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
107: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_orders_sql.parameters',dbg_msg);
108: END IF;
109:
110: --Change in View done for Bug#:4654974. Issue#12 by narao

Line 107: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_orders_sql.parameters',dbg_msg);

103: l_fnd_rec.lookup_type||','||'QUOTE_LABEL:'||l_QuoteLabel||','||'CART_LABEL:'||
104: l_CartLabel||','||'YES_LABEL:'||l_YesLabel||','||'NO_LABEL:'||l_NoLabel||','||
105: 'RECORD_TYPE_ID:'||l_record_type_id||','||'PREV_DATE:'||l_prev_date;
106: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
107: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_orders_sql.parameters',dbg_msg);
108: END IF;
109:
110: --Change in View done for Bug#:4654974. Issue#12 by narao
111: --The Site Dimension now refers to IBW_BI_MSITE_DIMN_V

Line 197: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

193:
194: x_custom_sql := l_custom_sql;
195:
196:
197: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_orders_sql.query',l_custom_sql);
199: END IF;
200:
201: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_orders_sql.query',l_custom_sql);

194: x_custom_sql := l_custom_sql;
195:
196:
197: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_orders_sql.query',l_custom_sql);
199: END IF;
200:
201: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
202:

Line 283: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

279: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
280:
281: x_custom_output(11) := l_custom_rec;
282:
283: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_orders_sql.end','END');
285: END IF;
286:
287: END GET_TOP_ORDERS_SQL;

Line 284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_orders_sql.end','END');

280:
281: x_custom_output(11) := l_custom_rec;
282:
283: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_orders_sql.end','END');
285: END IF;
286:
287: END GET_TOP_ORDERS_SQL;
288:

Line 324: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

320: l_global_primary VARCHAR2(15);
321: l_global_secondary VARCHAR2(15);
322: BEGIN
323:
324: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
325: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_carts_sql.begin','BEGIN');
326: END IF;
327:
328: -- initilization of variables

Line 325: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_carts_sql.begin','BEGIN');

321: l_global_secondary VARCHAR2(15);
322: BEGIN
323:
324: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
325: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_carts_sql.begin','BEGIN');
326: END IF;
327:
328: -- initilization of variables
329:

Line 396: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

392: 'EXPIRED_LABEL:'||l_ExpiredLabel||','||'YES_LABEL:'||l_YesLabel||','||
393: 'NO_LABEL:'||l_NoLabel||','||'RECORD_TYPE_ID:'||l_record_type_id||','||
394: 'PREV_DATE:'||l_prev_date;
395:
396: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
397: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_carts_sql.parameters',dbg_msg);
398: END IF;
399:
400: --Change in View done for Bug#:4654974. Issue#12 by narao

Line 397: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_carts_sql.parameters',dbg_msg);

393: 'NO_LABEL:'||l_NoLabel||','||'RECORD_TYPE_ID:'||l_record_type_id||','||
394: 'PREV_DATE:'||l_prev_date;
395:
396: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
397: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_carts_sql.parameters',dbg_msg);
398: END IF;
399:
400: --Change in View done for Bug#:4654974. Issue#12 by narao
401: --The Site Dimension now refers to IBW_BI_MSITE_DIMN_V

Line 479: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

475:
476:
477: x_custom_sql := l_custom_sql;
478:
479: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
480: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_carts_sql.query',l_custom_sql);
481: END IF;
482: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
483:

Line 480: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_carts_sql.query',l_custom_sql);

476:
477: x_custom_sql := l_custom_sql;
478:
479: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
480: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_carts_sql.query',l_custom_sql);
481: END IF;
482: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
483:
484: x_custom_output.Extend(11);

Line 565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

561: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
562:
563: x_custom_output(11) := l_custom_rec;
564:
565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
566: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_carts_sql.end','END');
567: END IF;
568:
569: END GET_TOP_CARTS_SQL;

Line 566: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_carts_sql.end','END');

562:
563: x_custom_output(11) := l_custom_rec;
564:
565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
566: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_carts_sql.end','END');
567: END IF;
568:
569: END GET_TOP_CARTS_SQL;
570:

Line 595: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

591: l_global_primary VARCHAR2(15) ;
592: l_global_secondary VARCHAR2(15) ;
593: BEGIN
594:
595: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_customers_sql.begin','BEGIN');
597: END IF;
598:
599: -- initilization of variables

Line 596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_customers_sql.begin','BEGIN');

592: l_global_secondary VARCHAR2(15) ;
593: BEGIN
594:
595: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_customers_sql.begin','BEGIN');
597: END IF;
598:
599: -- initilization of variables
600:

Line 647: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

643: ','||'PERIOD_TYPE:'||l_period_type||','||'COMPARISION_TYPE:'||
644: l_comparison_type||','||'MINISITE:'||l_minisite||','||'MINISITE_ID:'||
645: l_minisite_id||','||'ORDER_BY:'||l_OrderBy||','||'RECORD_TYPE_ID:'||
646: l_record_type_id||','||'PREV_DATE:'||l_prev_date;
647: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
648: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_customers_sql.parameters',dbg_msg);
649: END IF;
650:
651: --Change in View done for Bug#:4654974. Issue#12 by narao

Line 648: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_customers_sql.parameters',dbg_msg);

644: l_comparison_type||','||'MINISITE:'||l_minisite||','||'MINISITE_ID:'||
645: l_minisite_id||','||'ORDER_BY:'||l_OrderBy||','||'RECORD_TYPE_ID:'||
646: l_record_type_id||','||'PREV_DATE:'||l_prev_date;
647: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
648: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_customers_sql.parameters',dbg_msg);
649: END IF;
650:
651: --Change in View done for Bug#:4654974. Issue#12 by narao
652: --The Site Dimension now refers to IBW_BI_MSITE_DIMN_V

Line 740: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

736:
737:
738: x_custom_sql := l_custom_sql;
739:
740: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
741: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_customers_sql.query',l_custom_sql);
742: END IF;
743:
744: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 741: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_customers_sql.query',l_custom_sql);

737:
738: x_custom_sql := l_custom_sql;
739:
740: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
741: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_customers_sql.query',l_custom_sql);
742: END IF;
743:
744: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
745:

Line 799: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

795: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
796:
797: x_custom_output(7) := l_custom_rec;
798:
799: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_customers_sql.end','END');
801: END IF;
802:
803: END GET_TOP_CUSTOMERS_SQL;

Line 800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_customers_sql.end','END');

796:
797: x_custom_output(7) := l_custom_rec;
798:
799: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
800: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_customers_sql.end','END');
801: END IF;
802:
803: END GET_TOP_CUSTOMERS_SQL;
804:

Line 829: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

825: l_global_primary VARCHAR2(15) ;
826: l_global_secondary VARCHAR2(15) ;
827: BEGIN
828:
829: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
830: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_products_sql.begin','BEGIN');
831: END IF;
832:
833: -- initilization of variables

Line 830: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_products_sql.begin','BEGIN');

826: l_global_secondary VARCHAR2(15) ;
827: BEGIN
828:
829: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
830: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_products_sql.begin','BEGIN');
831: END IF;
832:
833: -- initilization of variables
834:

Line 879: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

875: ','||'PERIOD_TYPE:'||l_period_type||','||'COMPARISION_TYPE:'||
876: l_comparison_type||','||'MINISITE:'||l_minisite||','||'MINISITE_ID:'||
877: l_minisite_id||','||'ORDER_BY:'||l_OrderBy||','||'RECORD_TYPE_ID:'||
878: l_record_type_id||','||'PREV_DATE:'||l_prev_date;
879: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
880: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_products_sql.parameters',dbg_msg);
881: END IF;
882:
883: --Change in View done for Bug#:4654974. Issue#12 by narao

Line 880: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_products_sql.parameters',dbg_msg);

876: l_comparison_type||','||'MINISITE:'||l_minisite||','||'MINISITE_ID:'||
877: l_minisite_id||','||'ORDER_BY:'||l_OrderBy||','||'RECORD_TYPE_ID:'||
878: l_record_type_id||','||'PREV_DATE:'||l_prev_date;
879: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
880: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_products_sql.parameters',dbg_msg);
881: END IF;
882:
883: --Change in View done for Bug#:4654974. Issue#12 by narao
884: --The Site Dimension now refers to IBW_BI_MSITE_DIMN_V

Line 977: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

973: --' ORDER BY '||l_orderBy;
974:
975:
976: x_custom_sql := l_custom_sql;
977: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
978: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_products_sql.query',l_custom_sql);
979: END IF;
980:
981: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 978: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_products_sql.query',l_custom_sql);

974:
975:
976: x_custom_sql := l_custom_sql;
977: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
978: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_products_sql.query',l_custom_sql);
979: END IF;
980:
981: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
982:

Line 1036: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1032: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1033:
1034: x_custom_output(7) := l_custom_rec;
1035:
1036: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1037: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_products_sql.end','END');
1038: END IF;
1039:
1040: END GET_TOP_PRODUCTS_SQL;

Line 1037: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_products_sql.end','END');

1033:
1034: x_custom_output(7) := l_custom_rec;
1035:
1036: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1037: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_top_act_pvt.get_top_products_sql.end','END');
1038: END IF;
1039:
1040: END GET_TOP_PRODUCTS_SQL;
1041: