APPS.IBE_BI_SM_KPI_PVT dependencies on IBE_BI_SM_KPI_PVT

Line 1: PACKAGE BODY IBE_BI_SM_KPI_PVT AS

1: PACKAGE BODY IBE_BI_SM_KPI_PVT AS
2: /* $Header: IBEVBISMKPIB.pls 120.8 2006/06/26 08:57:11 gjothiku ship $ */
3:
4: PROCEDURE GET_NEW_CUST_KPI_SQL(
5: p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_tbl,

Line 31: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.begin','BEGIN');

27:
28: BEGIN
29:
30: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
31: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.begin','BEGIN');
32: END IF;
33:
34: -- initilization of variables
35:

Line 78: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.parameters',dbg_msg);

74: ','||'MINISITE:'||l_minisite||','||'MINISITE_ID:'||l_minisite_id||','||
75: 'RECORD_TYPE_ID:'||l_record_type_id||','||'PREV_DATE:'||l_prev_date;
76:
77: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
78: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.parameters',dbg_msg);
79: END IF;
80:
81: /**********************************************************************************/
82: /* VIEWBYID : Minisite ID */

Line 142: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.query',l_custom_sql);

138:
139: x_custom_sql := l_custom_sql;
140:
141: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
142: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.query',l_custom_sql);
143: END IF;
144:
145: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
146: x_custom_output.Extend(4);

Line 179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.end','END');

175: x_custom_output(4) := l_custom_rec;
176: */
177:
178: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_new_cust_kpi_sql.end','END');
180: END IF;
181:
182: END GET_NEW_CUST_KPI_SQL;
183:

Line 211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.begin','BEGIN');

207:
208:
209: BEGIN
210: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
211: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.begin','BEGIN');
212: END IF;
213:
214: -- initilization of variables
215:

Line 282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.parameters',dbg_msg);

278: ','||'MINISITE:'||l_minisite||','||'MINISITE_ID:'||l_minisite_id||','||
279: 'RECORD_TYPE_ID:'||l_record_type_id||','||'PREV_DATE:'||l_prev_date;
280:
281: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
282: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.parameters',dbg_msg);
283: END IF;
284:
285: /*********************************************************************************/
286: /* VIEWBYID : Minisite ID */

Line 371: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.query',l_custom_sql);

367:
368: x_custom_sql := l_custom_sql;
369:
370: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.query',l_custom_sql);
372: END IF;
373:
374: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
375: x_custom_output.Extend(8);

Line 439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.end','END');

435:
436:
437:
438: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'ibe.plsql.dbi.ibe_bi_sm_kpi_pvt.get_cart_ord_kpi_sql.end','END');
440: END IF;
441:
442: END GET_CART_ORD_KPIS_SQL;
443:

Line 592: END IBE_BI_SM_KPI_PVT;

588: NULL;
589: END GET_CAMP_ORD_KPI_SQL;
590:
591:
592: END IBE_BI_SM_KPI_PVT;