DBA Data[Home] [Help]

APPS.CSP_NOTIFICATIONS_PKG dependencies on CSP_NOTIFICATIONS

Line 1: PACKAGE BODY CSP_NOTIFICATIONS_PKG as

1: PACKAGE BODY CSP_NOTIFICATIONS_PKG as
2: /* $Header: csptpnob.pls 115.9 2002/11/26 07:37:49 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_NOTIFICATIONS_PKG
5: -- Purpose :

Line 4: -- Package name : CSP_NOTIFICATIONS_PKG

1: PACKAGE BODY CSP_NOTIFICATIONS_PKG as
2: /* $Header: csptpnob.pls 115.9 2002/11/26 07:37:49 hhaugeru ship $ */
3: -- Start of Comments
4: -- Package name : CSP_NOTIFICATIONS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_NOTIFICATIONS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csptpnob.pls';
13:
14: PROCEDURE Insert_Row(
15: px_NOTIFICATION_ID IN OUT NOCOPY NUMBER,

Line 54: CURSOR C2 IS SELECT CSP_NOTIFICATIONS_S1.nextval FROM sys.dual;

50: p_SUPPRESS_END_DATE DATE ,
51: p_NOTIFICATION_TYPE VARCHAR2 )
52:
53: IS
54: CURSOR C2 IS SELECT CSP_NOTIFICATIONS_S1.nextval FROM sys.dual;
55: BEGIN
56: If (px_NOTIFICATION_ID IS NULL) OR (px_NOTIFICATION_ID = FND_API.G_MISS_NUM) then
57: OPEN C2;
58: FETCH C2 INTO px_NOTIFICATION_ID;

Line 61: INSERT INTO CSP_NOTIFICATIONS(

57: OPEN C2;
58: FETCH C2 INTO px_NOTIFICATION_ID;
59: CLOSE C2;
60: End If;
61: INSERT INTO CSP_NOTIFICATIONS(
62: NOTIFICATION_ID,
63: CREATED_BY,
64: CREATION_DATE,
65: LAST_UPDATED_BY,

Line 180: Update CSP_NOTIFICATIONS

176: p_NOTIFICATION_TYPE VARCHAR2 )
177:
178: IS
179: BEGIN
180: Update CSP_NOTIFICATIONS
181: SET
182: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
183: CREATION_DATE = decode(p_CREATION_DATE, fnd_api.g_miss_date,creation_date,p_creation_date),
184: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 229: DELETE FROM CSP_NOTIFICATIONS

225: PROCEDURE Delete_Row(
226: p_NOTIFICATION_ID NUMBER)
227: IS
228: BEGIN
229: DELETE FROM CSP_NOTIFICATIONS
230: WHERE NOTIFICATION_ID = p_NOTIFICATION_ID;
231: If (SQL%NOTFOUND) then
232: RAISE NO_DATA_FOUND;
233: End If;

Line 278: FROM CSP_NOTIFICATIONS

274:
275: IS
276: CURSOR C IS
277: SELECT *
278: FROM CSP_NOTIFICATIONS
279: WHERE NOTIFICATION_ID = p_NOTIFICATION_ID
280: FOR UPDATE of NOTIFICATION_ID NOWAIT;
281: Recinfo C%ROWTYPE;
282: BEGIN

Line 409: End CSP_NOTIFICATIONS_PKG;

405: APP_EXCEPTION.RAISE_EXCEPTION;
406: End If;
407: END Lock_Row;
408:
409: End CSP_NOTIFICATIONS_PKG;