APPS.FND_GFM dependencies on DBMS_ALERT

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

359: where access_id = confirm_upload.access_id;
360:
361: --raise the alert back so that the wait is ended
362: if wakeup then
363: dbms_alert.signal('FND_GFM_ALERT'||to_char(access_id), to_char(fid));
364: end if;
365:
366: return fid;
367: exception

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

437: update fnd_lob_access set file_id = fid
438: where access_id = confirm_upload.access_id;
439:
440: if wakeup then
441: dbms_alert.signal('FND_GFM_ALERT'||to_char(access_id), to_char(fid));
442: end if;
443: -- bug 3045375, added else to return fid = -2.
444: else
445: -- This indicates that an invalid file size has been uploaded.

Line 554: dbms_alert.register(name);

550: message varchar2(32);
551: status integer;
552: begin
553: name := 'FND_GFM_ALERT' || to_char(access_id);
554: dbms_alert.register(name);
555: dbms_alert.waitone(name, message, status, timeout);
556: dbms_alert.remove(name);
557:
558: if status = 1 then

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

551: status integer;
552: begin
553: name := 'FND_GFM_ALERT' || to_char(access_id);
554: dbms_alert.register(name);
555: dbms_alert.waitone(name, message, status, timeout);
556: dbms_alert.remove(name);
557:
558: if status = 1 then
559: file_id := null;

Line 556: dbms_alert.remove(name);

552: begin
553: name := 'FND_GFM_ALERT' || to_char(access_id);
554: dbms_alert.register(name);
555: dbms_alert.waitone(name, message, status, timeout);
556: dbms_alert.remove(name);
557:
558: if status = 1 then
559: file_id := null;
560: else