APPS.FND_GFM dependencies on FND_LOBS_S

Line 138: update fnd_lobs set fnd_lobs.expiration_date = sysdate + 0.5

134: file_ext := '';
135: end if;
136:
137: file_name := 'fnd_gfm'||file_ext;
138: update fnd_lobs set fnd_lobs.expiration_date = sysdate + 0.5
139: where fnd_lobs.file_id = construct_download_url2.file_id;
140:
141: else
142: select instr(file_name,'.',-1) into ext_length

Line 367: select fnd_lobs_s.nextval into fid from dual;

363: return -1;
364: end;
365: else
366: if (fnd_gfm.authenticate(confirm_upload.access_id)) then
367: select fnd_lobs_s.nextval into fid from dual;
368:
369: fn := SUBSTR(confirm_upload.file_name, INSTR(confirm_upload.file_name,'/')+1);
370:
371: -- bug 3045375, added select to get length of BLOB.

Line 670: values (fnd_lobs_s.nextval, file_name, ct,

666:
667: insert into fnd_lobs (file_id, file_name, file_content_type,
668: file_data, upload_date, expiration_date, program_name, program_tag,
669: language,oracle_charset,file_format)
670: values (fnd_lobs_s.nextval, file_name, ct,
671: EMPTY_BLOB(), sysdate, sysdate + 1, program_name, program_tag,
672: l_lang, fnd_gfm.iana_to_oracle(iana_cs), l_file_format)
673: returning file_id into fh.fid;
674:

Line 696: update fnd_lobs set expiration_date = null where file_id = fh.fid;

692: begin
693: fh := open_file_handles(fd);
694: open_file_handles(fd) := null;
695:
696: update fnd_lobs set expiration_date = null where file_id = fh.fid;
697: commit;
698:
699: return fh.fid;
700: exception

Line 1146: SELECT fnd_lobs_s.nextval

1142: fnd_usr_rec fnd_user%ROWTYPE;
1143: fnd_lobs_rec fnd_lobs%ROWTYPE;
1144: begin
1145:
1146: SELECT fnd_lobs_s.nextval
1147: INTO fid_to
1148: FROM dual;
1149:
1150: SELECT file_id,

Line 1278: select fnd_lobs_s.nextval into fid from dual;

1274: raise G_EXC_ERROR;
1275: end if;
1276:
1277: if fid is null then
1278: select fnd_lobs_s.nextval into fid from dual;
1279: end if;
1280:
1281: if file_content_type is null then
1282: v_content_type := 'text/plain';