APPS.FND_GFM dependencies on DBMS_ALERT

Line 357: dbms_alert.signal('FND_GFM_ALERT'||to_char(access_id), to_char(fid));

353: where access_id = confirm_upload.access_id;
354:
355: --raise the alert back so that the wait is ended
356: if wakeup then
357: dbms_alert.signal('FND_GFM_ALERT'||to_char(access_id), to_char(fid));
358: end if;
359:
360: return fid;
361: exception

Line 433: dbms_alert.signal('FND_GFM_ALERT'||to_char(access_id), to_char(fid));

429: update fnd_lob_access set file_id = fid
430: where access_id = confirm_upload.access_id;
431:
432: if wakeup then
433: dbms_alert.signal('FND_GFM_ALERT'||to_char(access_id), to_char(fid));
434: end if;
435: -- bug 3045375, added else to return fid = -2.
436: else
437: fid := -2;

Line 541: dbms_alert.register(name);

537: message varchar2(32);
538: status integer;
539: begin
540: name := 'FND_GFM_ALERT' || to_char(access_id);
541: dbms_alert.register(name);
542: dbms_alert.waitone(name, message, status, timeout);
543: dbms_alert.remove(name);
544:
545: if status = 1 then

Line 542: dbms_alert.waitone(name, message, status, timeout);

538: status integer;
539: begin
540: name := 'FND_GFM_ALERT' || to_char(access_id);
541: dbms_alert.register(name);
542: dbms_alert.waitone(name, message, status, timeout);
543: dbms_alert.remove(name);
544:
545: if status = 1 then
546: file_id := null;

Line 543: dbms_alert.remove(name);

539: begin
540: name := 'FND_GFM_ALERT' || to_char(access_id);
541: dbms_alert.register(name);
542: dbms_alert.waitone(name, message, status, timeout);
543: dbms_alert.remove(name);
544:
545: if status = 1 then
546: file_id := null;
547: else