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.0 2004/01/24 03:23:07 appldev noship $ */
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.0 2004/01/24 03:23:07 appldev noship $ */
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 35: CURSOR C2 IS SELECT IEX_STRATEGY_USER_ITEMS_S.nextval FROM sys.dual;

31: ,p_PROGRAM_APPLICATION_ID NUMBER
32: ,p_OPERATION VARCHAR2)
33:
34: IS
35: CURSOR C2 IS SELECT IEX_STRATEGY_USER_ITEMS_S.nextval FROM sys.dual;
36: BEGIN
37: If (px_STRATEGY_USER_ITEM_ID IS NULL) OR (px_STRATEGY_USER_ITEM_ID = FND_API.G_MISS_NUM) then
38: OPEN C2;
39: FETCH C2 INTO px_STRATEGY_USER_ITEM_ID;

Line 42: INSERT INTO IEX_STRATEGY_USER_ITEMS(

38: OPEN C2;
39: FETCH C2 INTO px_STRATEGY_USER_ITEM_ID;
40: CLOSE C2;
41: End If;
42: INSERT INTO IEX_STRATEGY_USER_ITEMS(
43: STRATEGY_USER_ITEM_ID
44: ,STRATEGY_ID
45: ,WORK_ITEM_TEMP_ID
46: ,WORK_ITEM_ORDER

Line 98: Update IEX_STRATEGY_USER_ITEMS

94: ,p_OPERATION VARCHAR2)
95:
96: IS
97: BEGIN
98: Update IEX_STRATEGY_USER_ITEMS
99: SET
100: STRATEGY_ID = decode( p_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, p_STRATEGY_ID)
101: ,WORK_ITEM_TEMP_ID = decode( p_WORK_ITEM_TEMP_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMP_ID, p_WORK_ITEM_TEMP_ID)
102: ,WORK_ITEM_ORDER = decode( p_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, p_WORK_ITEM_ORDER)

Line 126: DELETE FROM IEX_STRATEGY_USER_ITEMS

122: PROCEDURE Delete_Row(
123: p_STRATEGY_USER_ITEM_ID NUMBER)
124: IS
125: BEGIN
126: DELETE FROM IEX_STRATEGY_USER_ITEMS
127: WHERE STRATEGY_USER_ITEM_ID = p_STRATEGY_USER_ITEM_ID;
128: If (SQL%NOTFOUND) then
129: RAISE NO_DATA_FOUND;
130: End If;

Line 154: FROM IEX_STRATEGY_USER_ITEMS

150:
151: IS
152: CURSOR C IS
153: SELECT *
154: FROM IEX_STRATEGY_USER_ITEMS
155: WHERE STRATEGY_USER_ITEM_ID = p_STRATEGY_USER_ITEM_ID
156: FOR UPDATE of STRATEGY_USER_ITEM_ID NOWAIT;
157: Recinfo C%ROWTYPE;
158: BEGIN

Line 222: End IEX_STRATEGY_USER_ITEMS_PKG;

218: APP_EXCEPTION.RAISE_EXCEPTION;
219: End If;
220: END Lock_Row;
221:
222: End IEX_STRATEGY_USER_ITEMS_PKG;