APPS.IEX_STRATEGY_WORK_ITEMS_PVT dependencies on IEX_STRATEGY_WORK_ITEMS_PVT

Line 1: PACKAGE BODY IEX_strategy_work_items_PVT as

1: PACKAGE BODY IEX_strategy_work_items_PVT as
2: /* $Header: iexvswib.pls 120.2.12010000.3 2008/10/20 09:38:32 pnaveenk ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(300):= 'IEX_strategy_work_items_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvswib.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(300):= 'IEX_strategy_work_items_PVT';

1: PACKAGE BODY IEX_strategy_work_items_PVT as
2: /* $Header: iexvswib.pls 120.2.12010000.3 2008/10/20 09:38:32 pnaveenk ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(300):= 'IEX_strategy_work_items_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvswib.pls';
6:
7:
8: -- Hint: Primary key needs to be returned.

Line 42: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_strategy_work_items_PVT.Create_strategy_work_items ******** ');

38:
39: BEGIN
40: -- IF PG_DEBUG < 10 THEN
41: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
42: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_strategy_work_items_PVT.Create_strategy_work_items ******** ');
43: END IF;
44: -- Standard Start of API savepoint
45: SAVEPOINT CREATE_strategy_work_items_PVT;
46:

Line 226: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.Create_strategy_work_items ******** ');

222: );
223:
224: -- IF PG_DEBUG < 10 THEN
225: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
226: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.Create_strategy_work_items ******** ');
227: END IF;
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 314: l_ref_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;

310: l_api_version_number CONSTANT NUMBER := 2.0;
311:
312: -- Local Variables
313: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
314: l_ref_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
315: l_tar_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type := P_strategy_work_item_Rec;
316:
317: l_object_version_number IEX_strategy_work_items.object_version_number%TYPE:=P_strategy_work_item_Rec.object_version_number;
318: l_rowid ROWID;

Line 315: l_tar_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type := P_strategy_work_item_Rec;

311:
312: -- Local Variables
313: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
314: l_ref_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type;
315: l_tar_strategy_work_item_rec IEX_strategy_work_items_PVT.strategy_work_item_Rec_Type := P_strategy_work_item_Rec;
316:
317: l_object_version_number IEX_strategy_work_items.object_version_number%TYPE:=P_strategy_work_item_Rec.object_version_number;
318: l_rowid ROWID;
319: --added by vimpi

Line 331: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');

327: BEGIN
328:
329: -- IF PG_DEBUG < 10 THEN
330: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
331: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');
332: END IF;
333: -- Standard Start of API savepoint
334: SAVEPOINT UPDATE_strategy_work_items_PVT;
335:

Line 496: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');

492: p_data => x_msg_data
493: );
494: -- IF PG_DEBUG < 10 THEN
495: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
496: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');
497: END IF;
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 630: End IEX_strategy_work_items_PVT;

626: ,X_RETURN_STATUS => X_RETURN_STATUS);
627: End Delete_strategy_work_items;
628:
629:
630: End IEX_strategy_work_items_PVT;