APPS.FND_GFM dependencies on FND_LOB_ACCESS

Line 45: from fnd_lob_access

41: is
42: rowcount number;
43: begin
44: select count(*) into rowcount
45: from fnd_lob_access
46: where nvl(file_id,-1) = nvl(authenticate.file_id, -1)
47: and access_id = authenticate.access_id
48: and timestamp > sysdate;
49:

Line 67: insert into fnd_lob_access (access_id, file_id, timestamp)

63: FUNCTION authorize(file_id number) return number is
64: pragma autonomous_transaction;
65: result number;
66: begin
67: insert into fnd_lob_access (access_id, file_id, timestamp)
68: values (fnd_crypto.SmallRandomNumber,
69: file_id, sysdate+1)
70: returning access_id into result;
71: commit;

Line 352: from fnd_lob_access

348: --data into fnd_lobs table
349: --return the file_id corresponding to this access_id
350: select file_id
351: into fid
352: from fnd_lob_access
353: where access_id = confirm_upload.access_id;
354:
355: --raise the alert back so that the wait is ended
356: if wakeup then

Line 429: update fnd_lob_access set file_id = fid

425: if (sql%rowcount <> 1) then
426: raise no_data_found;
427: end if;
428:
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));

Line 456: * from the fnd_lob_access table.

452: /*--------------------------------------------------------------------------*/
453: /*
454: * get_file_id
455: * This function retrieves the file_id for the corresponding access_id
456: * from the fnd_lob_access table.
457: *
458: * access_id the access id
459: */
460: FUNCTION get_file_id(access_id number) return number is

Line 464: from fnd_lob_access

460: FUNCTION get_file_id(access_id number) return number is
461: fid number := -1;
462: begin
463: select file_id into fid
464: from fnd_lob_access
465: where access_id = get_file_id.access_id;
466:
467: if (sql%rowcount <> 1) then
468: raise no_data_found;

Line 561: delete from fnd_lob_access where sysdate > timestamp;

557: pragma autonomous_transaction;
558: begin
559: if purge_expired.program_name is null then
560: delete from fnd_lobs where sysdate > expiration_date;
561: delete from fnd_lob_access where sysdate > timestamp;
562: commit;
563: else
564: delete from fnd_lobs
565: where fnd_lobs.program_name = purge_expired.program_name

Line 1007: * Store a value in the FND_LOB_ACCESS table and return a one-time-use

1003: end download_blob;
1004:
1005: /*
1006: * one_time_use_store
1007: * Store a value in the FND_LOB_ACCESS table and return a one-time-use
1008: * ticket that can be used by one_time_use_retrieve() to fetch the value.
1009: */
1010:
1011: FUNCTION one_time_use_store(value number) RETURN number IS

Line 1018: INSERT INTO fnd_lob_access (access_id, file_id, timestamp)

1014: begin
1015: for i in 1..10 loop
1016: begin
1017: ticket := fnd_crypto.SmallRandomNumber;
1018: INSERT INTO fnd_lob_access (access_id, file_id, timestamp)
1019: VALUES (ticket, value, sysdate+1);
1020: commit;
1021: return ticket;
1022: exception

Line 1058: * Retrieve a value from the FND_LOB_ACCESS table, given a one-time-use

1054: end;
1055:
1056: /*
1057: * one_time_use_retrieve
1058: * Retrieve a value from the FND_LOB_ACCESS table, given a one-time-use
1059: * ticket that was generated by one_time_use_store().
1060: */
1061: FUNCTION one_time_use_retrieve(ticket number) return number is
1062: pragma autonomous_transaction;

Line 1065: select file_id into value from fnd_lob_access

1061: FUNCTION one_time_use_retrieve(ticket number) return number is
1062: pragma autonomous_transaction;
1063: value number;
1064: begin
1065: select file_id into value from fnd_lob_access
1066: where access_id = ticket for update;
1067: delete from fnd_lob_access where access_id = ticket;
1068: commit;
1069: return value;

Line 1067: delete from fnd_lob_access where access_id = ticket;

1063: value number;
1064: begin
1065: select file_id into value from fnd_lob_access
1066: where access_id = ticket for update;
1067: delete from fnd_lob_access where access_id = ticket;
1068: commit;
1069: return value;
1070: exception
1071: when others then