APPS.FND_GFM dependencies on FND_LOBS_DOCUMENT

Line 315: * file_name The file_name as stored in the fnd_lobs_document table

311: * procedure to authenticate the upload and move the blob into the
312: * fnd_lobs table. The new generated file_id is returned to the caller.
313: *
314: * access_id The access identifier that authorized the upload
315: * file_name The file_name as stored in the fnd_lobs_document table
316: * by WebDB...the value of the file type input field.
317: * program_name The application short name to record
318: * program_tag The application tag to record
319: * expiration_date The expiration date to record; typically, this is null

Line 374: from fnd_lobs_document

370:
371: -- bug 3045375, added select to get length of BLOB.
372: select dbms_lob.getlength(blob_content), mime_type
373: into bloblength, mt
374: from fnd_lobs_document
375: where name = confirm_upload.file_name
376: and rownum=1;
377:
378: -- bug 3045375, added if to check length of blob.

Line 421: from fnd_lobs_document ld

417: confirm_upload.program_name,
418: confirm_upload.program_tag,
419: confirm_upload.language,
420: fnd_gfm.set_file_format(mt)
421: from fnd_lobs_document ld
422: where ld.name = confirm_upload.file_name
423: and rownum=1);
424:
425: if (sql%rowcount <> 1) then

Line 439: delete from fnd_lobs_document;

435: -- bug 3045375, added else to return fid = -2.
436: else
437: fid := -2;
438: end if;
439: delete from fnd_lobs_document;
440: delete from fnd_lobs_documentpart;
441: end if;
442: end if;
443: return fid;

Line 440: delete from fnd_lobs_documentpart;

436: else
437: fid := -2;
438: end if;
439: delete from fnd_lobs_document;
440: delete from fnd_lobs_documentpart;
441: end if;
442: end if;
443: return fid;
444: exception

Line 446: delete from fnd_lobs_document;

442: end if;
443: return fid;
444: exception
445: when others then
446: delete from fnd_lobs_document;
447: delete from fnd_lobs_documentpart;
448:
449: fnd_gfm.err_msg('confirm_upload');
450: raise;

Line 447: delete from fnd_lobs_documentpart;

443: return fid;
444: exception
445: when others then
446: delete from fnd_lobs_document;
447: delete from fnd_lobs_documentpart;
448:
449: fnd_gfm.err_msg('confirm_upload');
450: raise;
451: end;