APPS.GMS_NOTIFICATION_PKG dependencies on GMS_NOTIFICATIONS

Line 9: CURSOR C IS SELECT rowid FROM GMS_NOTIFICATIONS

5: X_Award_Id IN NUMBER,
6: X_Event_type IN VARCHAR2,
7: X_User_id IN NUMBER) IS
8:
9: CURSOR C IS SELECT rowid FROM GMS_NOTIFICATIONS
10: WHERE Award_id = X_Award_id and
11: Event_type = X_Event_type and
12: User_id = X_User_id;
13:

Line 15: INSERT into GMS_NOTIFICATIONS(award_id,

11: Event_type = X_Event_type and
12: User_id = X_User_id;
13:
14: BEGIN
15: INSERT into GMS_NOTIFICATIONS(award_id,
16: event_type,
17: user_id)
18: values (X_award_id,
19: X_event_type,

Line 37: cursor c is select * from gms_notifications

33: X_Award_Id IN NUMBER,
34: X_Event_type IN VARCHAR2,
35: X_User_id IN NUMBER) IS
36:
37: cursor c is select * from gms_notifications
38: where rowid = X_rowid
39: for update of Award_id, event_type, user_id nowait;
40: Recinfo c%rowtype;
41: BEGIN

Line 68: delete gms_notifications

64:
65:
66: PROCEDURE Delete_Row(X_Rowid VARCHAR2) is
67: BEGIN
68: delete gms_notifications
69: where rowid = X_Rowid;
70: END Delete_row;
71:
72:

Line 110: INSERT into GMS_NOTIFICATIONS(award_id,

106: -- Bug 1969587 : Added for Installment closeout notification
107:
108: BEGIN
109:
110: INSERT into GMS_NOTIFICATIONS(award_id,
111: event_type,
112: user_id)
113: values (p_award_id,
114: 'INSTALLMENT_CLOSEOUT',

Line 124: INSERT into GMS_NOTIFICATIONS(award_id,

120: END;
121:
122: BEGIN
123:
124: INSERT into GMS_NOTIFICATIONS(award_id,
125: event_type,
126: user_id)
127: values (p_award_id,
128: 'BUDGET_BASELINE',

Line 138: INSERT into GMS_NOTIFICATIONS(award_id,

134: END;
135:
136: BEGIN
137:
138: INSERT into GMS_NOTIFICATIONS(award_id,
139: event_type,
140: user_id)
141: values (p_award_id,
142: 'INSTALLMENT_ACTIVE',

Line 159: INSERT into GMS_NOTIFICATIONS(award_id,

155: fetch report_event_cursor into l_report_template_id;
156: exit when report_event_cursor%notfound;
157: BEGIN
158:
159: INSERT into GMS_NOTIFICATIONS(award_id,
160: event_type,
161: user_id)
162: values (p_award_id,
163: 'REPORT_'||l_report_template_id,

Line 202: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.CRT_DEFAULT_PERSON_EVENTS');

198:
199: APP_EXCEPTION.RAISE_EXCEPTION;
200:
201: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
202: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.CRT_DEFAULT_PERSON_EVENTS');
203: -- fnd_message.set_token('OERRNO',to_char(sqlcode));
204: -- fnd_message.set_token('OERRM',sqlerrm);
205: -- APP_EXCEPTION.raise_exception;
206: END crt_default_person_events;

Line 252: INSERT into GMS_NOTIFICATIONS(award_id,

248: raise user_not_yet_created;
249: end if;
250: close fnd_user_cursor;
251: BEGIN
252: INSERT into GMS_NOTIFICATIONS(award_id,
253: event_type,
254: user_id)
255: values (p_award_id,
256: 'REPORT_'||l_report_template_id,

Line 291: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.CRT_DEFAULT_REPORT_EVENTS');

287:
288: APP_EXCEPTION.RAISE_EXCEPTION;
289:
290: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
291: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.CRT_DEFAULT_REPORT_EVENTS');
292: -- fnd_message.set_token('OERRNO',to_char(sqlcode));
293: -- fnd_message.set_token('OERRM',sqlerrm);
294: -- app_exception.raise_exception;
295: END crt_default_report_events;

Line 321: delete gms_notifications

317: close fnd_user_cursor;
318: raise user_not_yet_created ;
319: end if;
320: close fnd_user_cursor;
321: delete gms_notifications
322: where user_id = l_user_id and
323: award_id = p_award_id and
324:
325: -- Bug 1969587 : Installment closeout Notification

Line 358: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.DEL_DEFAULT_PERSON_EVENTS');

354:
355: APP_EXCEPTION.RAISE_EXCEPTION;
356:
357: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
358: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.DEL_DEFAULT_PERSON_EVENTS');
359: -- fnd_message.set_token('OERRNO',to_char(sqlcode));
360: -- fnd_message.set_token('OERRM',sqlerrm);
361: -- app_exception.raise_exception;
362: END;

Line 373: delete gms_notifications

369: BEGIN
370:
371: x_err_code := 0;
372:
373: delete gms_notifications
374: where award_id = p_award_id and
375: event_type = 'REPORT_'||to_char(p_report_template_id);
376:
377: EXCEPTION

Line 390: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.DEL_DEFAULT_REPORT_EVENTS');

386:
387: APP_EXCEPTION.RAISE_EXCEPTION;
388:
389: -- fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
390: -- fnd_message.set_token('PROGRAM_NAME','GMS_NOTIFICATIONS_PKG.DEL_DEFAULT_REPORT_EVENTS');
391: -- fnd_message.set_token('OERRNO',to_char(sqlcode));
392: -- fnd_message.set_token('OERRM',sqlerrm);
393: -- app_exception.raise_exception;
394: END;