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.IEX_STRATEGY_WORK_ITEMS_PVT dependencies on IEX_STRATEGY_WORK_ITEMS

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 28: v_WORK_ITEM_ID iex_strategy_work_items.strategy_id%TYPE;

24: IS
25: l_api_name CONSTANT VARCHAR2(200) := 'Create_strategy_work_items';
26: l_api_version_number CONSTANT NUMBER := 2.0;
27: l_return_status_full VARCHAR2(1);
28: v_WORK_ITEM_ID iex_strategy_work_items.strategy_id%TYPE;
29: v_object_version_number iex_strategy_work_items.object_version_number%TYPE;
30: v_rowid VARCHAR2(24);
31: --added by vimpi
32: l_msg_Count number ;

Line 29: v_object_version_number iex_strategy_work_items.object_version_number%TYPE;

25: l_api_name CONSTANT VARCHAR2(200) := 'Create_strategy_work_items';
26: l_api_version_number CONSTANT NUMBER := 2.0;
27: l_return_status_full VARCHAR2(1);
28: v_WORK_ITEM_ID iex_strategy_work_items.strategy_id%TYPE;
29: v_object_version_number iex_strategy_work_items.object_version_number%TYPE;
30: v_rowid VARCHAR2(24);
31: --added by vimpi
32: l_msg_Count number ;
33: l_msg_data varchar2(200) ;

Line 37: Cursor c2 is SELECT iex_strategy_work_items_S.nextval from dual;

33: l_msg_data varchar2(200) ;
34: l_return_status varchar2(200) ;
35:
36:
37: Cursor c2 is SELECT iex_strategy_work_items_S.nextval from dual;
38:
39: BEGIN
40: -- IF PG_DEBUG < 10 THEN
41: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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 135: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Insert_Row)

131: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
132: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'Before Calling iex_strategies_pkg.insert_row');
133: END IF;
134:
135: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Insert_Row)
136: IEX_STRATEGY_WORK_ITEMS_PKG.Insert_Row(
137: x_rowid =>v_rowid
138: ,x_WORK_ITEM_ID => v_WORK_ITEM_ID
139: ,x_STRATEGY_ID => p_strategy_work_item_rec.STRATEGY_ID

Line 136: IEX_STRATEGY_WORK_ITEMS_PKG.Insert_Row(

132: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'Before Calling iex_strategies_pkg.insert_row');
133: END IF;
134:
135: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Insert_Row)
136: IEX_STRATEGY_WORK_ITEMS_PKG.Insert_Row(
137: x_rowid =>v_rowid
138: ,x_WORK_ITEM_ID => v_WORK_ITEM_ID
139: ,x_STRATEGY_ID => p_strategy_work_item_rec.STRATEGY_ID
140: ,x_RESOURCE_ID => p_strategy_work_item_rec.RESOURCE_ID

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 305: From IEX_STRATEGY_WORK_ITEMS

301: REQUEST_ID,
302: WORK_TYPE,
303: LAST_UPDATE_DATE,
304: WORK_ITEM_TEMPLATE_ID
305: From IEX_STRATEGY_WORK_ITEMS
306: -- Hint: Developer need to provide Where clause
307: For Update NOWAIT;
308: */
309: l_api_name CONSTANT VARCHAR2(200) := 'Update_strategy_work_items';

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 317: l_object_version_number IEX_strategy_work_items.object_version_number%TYPE:=P_strategy_work_item_Rec.object_version_number;

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
320: l_msg_Count number ;
321: l_msg_data varchar2(200) ;

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 363: IEX_STRATEGY_WORK_ITEMS_PKG.lock_row (

359: -- Api body
360: --
361:
362: -- call locking table handler
363: IEX_STRATEGY_WORK_ITEMS_PKG.lock_row (
364: p_strategy_work_item_rec.WORK_ITEM_ID,
365: l_object_version_number
366: );
367:

Line 368: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Update_Row)

364: p_strategy_work_item_rec.WORK_ITEM_ID,
365: l_object_version_number
366: );
367:
368: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Update_Row)
369: IEX_STRATEGY_WORK_ITEMS_PKG.Update_Row(
370: x_WORK_ITEM_ID => p_strategy_work_item_rec.WORK_ITEM_ID
371: ,x_STRATEGY_ID => p_strategy_work_item_rec.STRATEGY_ID
372: ,x_RESOURCE_ID => p_strategy_work_item_rec.RESOURCE_ID

Line 369: IEX_STRATEGY_WORK_ITEMS_PKG.Update_Row(

365: l_object_version_number
366: );
367:
368: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Update_Row)
369: IEX_STRATEGY_WORK_ITEMS_PKG.Update_Row(
370: x_WORK_ITEM_ID => p_strategy_work_item_rec.WORK_ITEM_ID
371: ,x_STRATEGY_ID => p_strategy_work_item_rec.STRATEGY_ID
372: ,x_RESOURCE_ID => p_strategy_work_item_rec.RESOURCE_ID
373: ,x_STATUS_CODE => p_strategy_work_item_rec.STATUS_CODE

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 576: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Delete_Row)

572: --
573: -- Api body
574: --
575:
576: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Delete_Row)
577: IEX_STRATEGY_WORK_ITEMS_PKG.Delete_Row(p_WORK_ITEM_ID);
578:
579: --
580: -- End of API body

Line 577: IEX_STRATEGY_WORK_ITEMS_PKG.Delete_Row(p_WORK_ITEM_ID);

573: -- Api body
574: --
575:
576: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Delete_Row)
577: IEX_STRATEGY_WORK_ITEMS_PKG.Delete_Row(p_WORK_ITEM_ID);
578:
579: --
580: -- End of API body
581: --

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;