APPS.IEX_STRATEGY_USER_ITEMS_PKG dependencies on IEX_STRATEGY_USER_ITEMS

Line 1: PACKAGE BODY IEX_STRATEGY_USER_ITEMS_PKG as

1: PACKAGE BODY IEX_STRATEGY_USER_ITEMS_PKG as
2: /* $Header: iextsuib.pls 120.4 2010/12/21 12:54:53 pnaveenk ship $ */
3: -- Start of Comments
4: -- Package name : IEX_STRATEGY_USER_ITEMS_PKG
5: -- Purpose :

Line 4: -- Package name : IEX_STRATEGY_USER_ITEMS_PKG

1: PACKAGE BODY IEX_STRATEGY_USER_ITEMS_PKG as
2: /* $Header: iextsuib.pls 120.4 2010/12/21 12:54:53 pnaveenk ship $ */
3: -- Start of Comments
4: -- Package name : IEX_STRATEGY_USER_ITEMS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_STRATEGY_USER_ITEMS_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_STRATEGY_USER_ITEMS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iextsuib.pls';
13:
14: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
15:

Line 49: CURSOR C2 IS SELECT IEX_STRATEGY_USER_ITEMS_S.nextval FROM sys.dual;

45: ,p_resource_id NUMBER
46: ,p_custom_workflow_type VARCHAR2)
47:
48: IS
49: CURSOR C2 IS SELECT IEX_STRATEGY_USER_ITEMS_S.nextval FROM sys.dual;
50: BEGIN
51: If (px_STRATEGY_USER_ITEM_ID IS NULL) OR (px_STRATEGY_USER_ITEM_ID = FND_API.G_MISS_NUM) then
52: OPEN C2;
53: FETCH C2 INTO px_STRATEGY_USER_ITEM_ID;

Line 56: INSERT INTO IEX_STRATEGY_USER_ITEMS(

52: OPEN C2;
53: FETCH C2 INTO px_STRATEGY_USER_ITEM_ID;
54: CLOSE C2;
55: End If;
56: INSERT INTO IEX_STRATEGY_USER_ITEMS(
57: STRATEGY_USER_ITEM_ID
58: ,STRATEGY_ID
59: ,WORK_ITEM_TEMP_ID
60: ,WORK_ITEM_ORDER

Line 154: Update IEX_STRATEGY_USER_ITEMS

150: ,p_custom_workflow_type VARCHAR2)
151:
152: IS
153: BEGIN
154: Update IEX_STRATEGY_USER_ITEMS
155: SET
156: STRATEGY_ID = decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, p_STRATEGY_ID)
157: ,WORK_ITEM_TEMP_ID = decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMP_ID, p_WORK_ITEM_TEMP_ID)
158: ,WORK_ITEM_ORDER = decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, p_WORK_ITEM_ORDER)

Line 196: DELETE FROM IEX_STRATEGY_USER_ITEMS

192: PROCEDURE Delete_Row(
193: p_STRATEGY_USER_ITEM_ID NUMBER)
194: IS
195: BEGIN
196: DELETE FROM IEX_STRATEGY_USER_ITEMS
197: WHERE STRATEGY_USER_ITEM_ID = p_STRATEGY_USER_ITEM_ID;
198: If (SQL%NOTFOUND) then
199: RAISE NO_DATA_FOUND;
200: End If;

Line 238: FROM IEX_STRATEGY_USER_ITEMS

234:
235: IS
236: CURSOR C IS
237: SELECT *
238: FROM IEX_STRATEGY_USER_ITEMS
239: WHERE STRATEGY_USER_ITEM_ID = p_STRATEGY_USER_ITEM_ID
240: FOR UPDATE of STRATEGY_USER_ITEM_ID NOWAIT;
241: Recinfo C%ROWTYPE;
242: BEGIN

Line 306: End IEX_STRATEGY_USER_ITEMS_PKG;

302: APP_EXCEPTION.RAISE_EXCEPTION;
303: End If;
304: END Lock_Row;
305:
306: End IEX_STRATEGY_USER_ITEMS_PKG;