APPS.IEX_SCORE_HISTORIES_PKG dependencies on IEX_SCORE_HISTORIES

Line 1: PACKAGE BODY IEX_SCORE_HISTORIES_PKG AS

1: PACKAGE BODY IEX_SCORE_HISTORIES_PKG AS
2: /* $Header: iextschb.pls 120.0 2004/01/24 03:22:40 appldev noship $ */
3:
4: /* Insert_Row procedure */
5: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

Line 28: CURSOR C IS SELECT ROWID FROM IEX_SCORE_HISTORIES

24: ,p_REQUEST_ID NUMBER DEFAULT NULL
25: ,p_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL
26: ,p_PROGRAM_UPDATE_DATE DATE DEFAULT NULL
27: ) IS
28: CURSOR C IS SELECT ROWID FROM IEX_SCORE_HISTORIES
29: WHERE SCORE_HISTORY_ID = p_SCORE_HISTORY_ID;
30:
31: BEGIN
32: INSERT INTO IEX_SCORE_HISTORIES

Line 32: INSERT INTO IEX_SCORE_HISTORIES

28: CURSOR C IS SELECT ROWID FROM IEX_SCORE_HISTORIES
29: WHERE SCORE_HISTORY_ID = p_SCORE_HISTORY_ID;
30:
31: BEGIN
32: INSERT INTO IEX_SCORE_HISTORIES
33: (
34: SCORE_HISTORY_ID
35: ,OBJECT_VERSION_NUMBER
36: ,PROGRAM_ID

Line 107: UPDATE IEX_SCORE_HISTORIES SET

103: ,p_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL
104: ,p_PROGRAM_UPDATE_DATE DATE DEFAULT NULL
105: ) IS
106: BEGIN
107: UPDATE IEX_SCORE_HISTORIES SET
108: SCORE_HISTORY_ID = p_SCORE_HISTORY_ID
109: ,OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER
110: ,PROGRAM_ID = p_PROGRAM_ID
111: ,LAST_UPDATE_DATE = p_LAST_UPDATE_DATE

Line 137: DELETE FROM IEX_SCORE_HISTORIES

133:
134: /* Delete_Row procedure */
135: PROCEDURE Delete_Row(x_rowid VARCHAR2) IS
136: BEGIN
137: DELETE FROM IEX_SCORE_HISTORIES
138: WHERE rowid = x_rowid;
139:
140: if (sql%notfound) then
141: raise no_data_found;

Line 167: CURSOR C IS SELECT * FROM IEX_SCORE_HISTORIES

163: ,p_REQUEST_ID NUMBER DEFAULT NULL
164: ,p_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL
165: ,p_PROGRAM_UPDATE_DATE DATE DEFAULT NULL
166: ) IS
167: CURSOR C IS SELECT * FROM IEX_SCORE_HISTORIES
168: WHERE rowid = x_rowid
169: FOR UPDATE of SCORE_HISTORY_ID NOWAIT;
170: Recinfo C%ROWTYPE;
171: BEGIN