APPS.IEX_DEL_STATUSES_PKG dependencies on IEX_DEL_STATUSES

Line 1: PACKAGE BODY IEX_DEL_STATUSES_PKG AS

1: PACKAGE BODY IEX_DEL_STATUSES_PKG AS
2: /* $Header: iextdlsb.pls 120.1 2005/07/12 20:35:40 jsanju noship $ */
3: /* Insert_Row procedure */
4: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
5:

Line 23: CURSOR C IS SELECT ROWID FROM IEX_DEL_STATUSES

19: ,p_LAST_UPDATED_BY NUMBER
20: ,p_LAST_UPDATE_DATE DATE
21: ,p_LAST_UPDATE_LOGIN NUMBER DEFAULT NULL
22: ) IS
23: CURSOR C IS SELECT ROWID FROM IEX_DEL_STATUSES
24: WHERE DEL_STATUS_ID = p_DEL_STATUS_ID;
25:
26: BEGIN
27: INSERT INTO IEX_DEL_STATUSES

Line 27: INSERT INTO IEX_DEL_STATUSES

23: CURSOR C IS SELECT ROWID FROM IEX_DEL_STATUSES
24: WHERE DEL_STATUS_ID = p_DEL_STATUS_ID;
25:
26: BEGIN
27: INSERT INTO IEX_DEL_STATUSES
28: (
29: DEL_STATUS_ID
30: ,OBJECT_VERSION_NUMBER
31: ,SCORE_VALUE_LOW

Line 83: IS SELECT ROWID FROM IEX_DEL_STATUSES

79: ,p_SCORE_ID NUMBER
80: ,Commit_flag VARCHAR2
81: ) IS
82: CURSOR C(p_del_status_id number)
83: IS SELECT ROWID FROM IEX_DEL_STATUSES
84: WHERE DEL_STATUS_ID = p_DEL_STATUS_ID;
85:
86: l_del_status_id Number ;
87:

Line 91: Select IEX_DEL_STATUSES_S.nextval

87:
88: BEGIN
89: -- Slightly modified since a lot of default values will be provided
90:
91: Select IEX_DEL_STATUSES_S.nextval
92: into l_del_status_id
93: From dual ;
94:
95: INSERT INTO IEX_DEL_STATUSES

Line 95: INSERT INTO IEX_DEL_STATUSES

91: Select IEX_DEL_STATUSES_S.nextval
92: into l_del_status_id
93: From dual ;
94:
95: INSERT INTO IEX_DEL_STATUSES
96: (
97: DEL_STATUS_ID
98: ,OBJECT_VERSION_NUMBER
99: ,SCORE_VALUE_LOW

Line 167: UPDATE IEX_DEL_STATUSES SET

163: ,p_LAST_UPDATE_DATE DATE
164: ,p_LAST_UPDATE_LOGIN NUMBER DEFAULT NULL
165: ) IS
166: BEGIN
167: UPDATE IEX_DEL_STATUSES SET
168: DEL_STATUS_ID = p_DEL_STATUS_ID
169: ,OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER
170: ,SCORE_VALUE_LOW = p_SCORE_VALUE_LOW
171: ,SCORE_VALUE_HIGH = p_SCORE_VALUE_HIGH

Line 193: DELETE FROM IEX_DEL_STATUSES

189:
190: /* Delete_Row procedure */
191: PROCEDURE Delete_Row(x_rowid VARCHAR2) IS
192: BEGIN
193: DELETE FROM IEX_DEL_STATUSES
194: WHERE rowid = x_rowid;
195:
196: if (sql%notfound) then
197: -- No action required since this is range delete

Line 207: DELETE FROM IEX_DEL_STATUSES

203: /* Delete_Row procedure */
204: PROCEDURE Delete_del_config(p_scoreId NUMBER)
205: IS
206: BEGIN
207: DELETE FROM IEX_DEL_STATUSES
208: WHERE score_id = p_scoreId;
209:
210: if (sql%notfound) then
211: -- No action required since this is range delete

Line 237: CURSOR C IS SELECT * FROM IEX_DEL_STATUSES

233: ,p_LAST_UPDATED_BY NUMBER
234: ,p_LAST_UPDATE_DATE DATE
235: ,p_LAST_UPDATE_LOGIN NUMBER DEFAULT NULL
236: ) IS
237: CURSOR C IS SELECT * FROM IEX_DEL_STATUSES
238: WHERE rowid = x_rowid
239: FOR UPDATE of DEL_STATUS_ID NOWAIT;
240: Recinfo C%ROWTYPE;
241: BEGIN