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 69: insert into fnd_lob_access (access_id, file_id, timestamp)

65: result number;
66: begin
67: loop
68: begin
69: insert into fnd_lob_access (access_id, file_id, timestamp)
70: values (fnd_crypto.RANDOMNUMBER,
71: file_id, sysdate+1)
72: returning access_id into result;
73: commit;

Line 358: from fnd_lob_access

354: --data into fnd_lobs table
355: --return the file_id corresponding to this access_id
356: select file_id
357: into fid
358: from fnd_lob_access
359: where access_id = confirm_upload.access_id;
360:
361: --raise the alert back so that the wait is ended
362: if wakeup then

Line 437: update fnd_lob_access set file_id = fid

433: if (sql%rowcount <> 1) then
434: raise no_data_found;
435: end if;
436:
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));

Line 469: * from the fnd_lob_access table.

465: /*--------------------------------------------------------------------------*/
466: /*
467: * get_file_id
468: * This function retrieves the file_id for the corresponding access_id
469: * from the fnd_lob_access table.
470: *
471: * access_id the access id
472: */
473: FUNCTION get_file_id(access_id number) return number is

Line 477: from fnd_lob_access

473: FUNCTION get_file_id(access_id number) return number is
474: fid number := -1;
475: begin
476: select file_id into fid
477: from fnd_lob_access
478: where access_id = get_file_id.access_id;
479:
480: if (sql%rowcount <> 1) then
481: raise no_data_found;

Line 630: delete from fnd_lob_access where sysdate > timestamp;

626: end if;
627:
628: if purge_expired.program_name is null then
629: delete from fnd_lobs where sysdate > expiration_date;
630: delete from fnd_lob_access where sysdate > timestamp;
631: commit;
632: else
633: delete from fnd_lobs
634: where fnd_lobs.program_name = purge_expired.program_name

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

1087: end download_blob;
1088:
1089: /*
1090: * one_time_use_store
1091: * Store a value in the FND_LOB_ACCESS table and return a one-time-use
1092: * ticket that can be used by one_time_use_retrieve() to fetch the value.
1093: */
1094:
1095: FUNCTION one_time_use_store(value number) RETURN number IS

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

1098: begin
1099: for i in 1..10 loop
1100: begin
1101: ticket := fnd_crypto.RANDOMNUMBER;
1102: INSERT INTO fnd_lob_access (access_id, file_id, timestamp)
1103: VALUES (ticket, value, sysdate+1);
1104: commit;
1105: return ticket;
1106: exception

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

1138: end;
1139:
1140: /*
1141: * one_time_use_retrieve
1142: * Retrieve a value from the FND_LOB_ACCESS table, given a one-time-use
1143: * ticket that was generated by one_time_use_store().
1144: */
1145: FUNCTION one_time_use_retrieve(ticket number) return number is
1146: pragma autonomous_transaction;

Line 1149: select file_id into value from fnd_lob_access

1145: FUNCTION one_time_use_retrieve(ticket number) return number is
1146: pragma autonomous_transaction;
1147: value number;
1148: begin
1149: select file_id into value from fnd_lob_access
1150: where access_id = ticket for update;
1151: delete from fnd_lob_access where access_id = ticket;
1152: commit;
1153: return value;

Line 1151: delete from fnd_lob_access where access_id = ticket;

1147: value number;
1148: begin
1149: select file_id into value from fnd_lob_access
1150: where access_id = ticket for update;
1151: delete from fnd_lob_access where access_id = ticket;
1152: commit;
1153: return value;
1154: exception
1155: when others then