eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_GFM dependencies on FND_LOBS

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

140: file_ext := '';
141: end if;
142:
143: file_name := 'fnd_gfm'||file_ext;
144: update fnd_lobs set fnd_lobs.expiration_date = sysdate + 0.5
145: where fnd_lobs.file_id = construct_download_url2.file_id;
146:
147: else
148: select instr(file_name,'.',-1) into ext_length

Line 145: where fnd_lobs.file_id = construct_download_url2.file_id;

141: end if;
142:
143: file_name := 'fnd_gfm'||file_ext;
144: update fnd_lobs set fnd_lobs.expiration_date = sysdate + 0.5
145: where fnd_lobs.file_id = construct_download_url2.file_id;
146:
147: else
148: select instr(file_name,'.',-1) into ext_length
149: from fnd_lobs

Line 149: from fnd_lobs

145: where fnd_lobs.file_id = construct_download_url2.file_id;
146:
147: else
148: select instr(file_name,'.',-1) into ext_length
149: from fnd_lobs
150: where file_id = construct_download_url2.file_id;
151:
152: if ext_length > 0 then
153: select substr(file_name,instr(file_name,'/',-1)+1) into file_name

Line 154: from fnd_lobs

150: where file_id = construct_download_url2.file_id;
151:
152: if ext_length > 0 then
153: select substr(file_name,instr(file_name,'/',-1)+1) into file_name
154: from fnd_lobs
155: where file_id = construct_download_url2.file_id;
156: else
157: file_name := 'fnd_gfm';
158: end if;

Line 318: * fnd_lobs table. The new generated file_id is returned to the caller.

314: /*
315: * confirm_upload - confirm the completion of an upload
316: * This procedure must be called from within the user's PL/SQL upload
317: * procedure to authenticate the upload and move the blob into the
318: * fnd_lobs table. The new generated file_id is returned to the caller.
319: *
320: * access_id The access identifier that authorized the upload
321: * file_name The file_name as stored in the fnd_lobs_document table
322: * by WebDB...the value of the file type input field.

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

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

Line 354: --data into fnd_lobs table

350: begin
351: if (getRelease = 12) then
352: begin
353: --we already through the OA page has inserted the
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

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

371: else
372: if (fnd_gfm.authenticate(confirm_upload.access_id)) then
373:
374: if (verify_file_type(file_name => confirm_upload.file_name) = 'Y') then
375: select fnd_lobs_s.nextval into fid from dual;
376:
377: fn := SUBSTR(confirm_upload.file_name, INSTR(confirm_upload.file_name,'/')+1);
378:
379: -- bug 3045375, added select to get length of BLOB.

Line 382: from fnd_lobs_document

378:
379: -- bug 3045375, added select to get length of BLOB.
380: select dbms_lob.getlength(blob_content), mime_type
381: into bloblength, mt
382: from fnd_lobs_document
383: where name = confirm_upload.file_name
384: and rownum=1;
385:
386: -- bug 3045375, added if to check length of blob.

Line 409: insert into fnd_lobs (file_id,

405: ufslim := ufslim * 1000;
406: end if;
407:
408: if bloblength BETWEEN 1 and ufslim then
409: insert into fnd_lobs (file_id,
410: file_name,
411: file_content_type,
412: file_data,
413: upload_date,

Line 429: from fnd_lobs_document ld

425: confirm_upload.program_name,
426: confirm_upload.program_tag,
427: confirm_upload.language,
428: fnd_gfm.set_file_format(mt)
429: from fnd_lobs_document ld
430: where ld.name = confirm_upload.file_name
431: and rownum=1);
432:
433: if (sql%rowcount <> 1) then

Line 452: delete from fnd_lobs_document;

448: else
449: -- bug 9276419 - indicate a restricted file by returning -3
450: fid := -3;
451: end if;
452: delete from fnd_lobs_document;
453: delete from fnd_lobs_documentpart;
454: end if;
455: end if;
456: return fid;

Line 453: delete from fnd_lobs_documentpart;

449: -- bug 9276419 - indicate a restricted file by returning -3
450: fid := -3;
451: end if;
452: delete from fnd_lobs_document;
453: delete from fnd_lobs_documentpart;
454: end if;
455: end if;
456: return fid;
457: exception

Line 459: delete from fnd_lobs_document;

455: end if;
456: return fid;
457: exception
458: when others then
459: delete from fnd_lobs_document;
460: delete from fnd_lobs_documentpart;
461:
462: fnd_gfm.err_msg('confirm_upload');
463: raise;

Line 460: delete from fnd_lobs_documentpart;

456: return fid;
457: exception
458: when others then
459: delete from fnd_lobs_document;
460: delete from fnd_lobs_documentpart;
461:
462: fnd_gfm.err_msg('confirm_upload');
463: raise;
464: end;

Line 574: FROM FND_LOBS FL

570: pragma autonomous_transaction;
571:
572: CURSOR c_orph_attch_lob IS
573: SELECT file_id
574: FROM FND_LOBS FL
575: WHERE NOT EXISTS (SELECT '1'
576: FROM FND_DOCUMENTS_VL FDVL
577: WHERE FDVL.MEDIA_ID = FL.FILE_ID
578: AND FDVL.DATATYPE_ID = 6)

Line 614: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Found orphaned fnd_lobs record: '||l_file_id);

610: and media_id = l_file_id;
611:
612: if (l_doc_cnt = 0) then -- set expiration date
613: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
614: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Found orphaned fnd_lobs record: '||l_file_id);
615: end if;
616:
617: update fnd_lobs fl
618: set expiration_date = sysdate-1

Line 617: update fnd_lobs fl

613: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
614: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Found orphaned fnd_lobs record: '||l_file_id);
615: end if;
616:
617: update fnd_lobs fl
618: set expiration_date = sysdate-1
619: where program_name = 'FNDATTCH'
620: and file_id = l_file_id;
621: end if;

Line 629: delete from fnd_lobs where sysdate > expiration_date;

625: commit;
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

Line 633: delete from fnd_lobs

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
635: and sysdate > expiration_date;
636: commit;
637: end if;

Line 634: where fnd_lobs.program_name = purge_expired.program_name

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
635: and sysdate > expiration_date;
636: commit;
637: end if;
638:

Line 657: delete from fnd_lobs where fnd_lobs.program_name = purge_set.program_name;

653: program_tag varchar2 default null) is
654: pragma autonomous_transaction;
655: begin
656: if program_tag is null then
657: delete from fnd_lobs where fnd_lobs.program_name = purge_set.program_name;
658: else
659: delete from fnd_lobs
660: where fnd_lobs.program_name = purge_set.program_name
661: and fnd_lobs.program_tag = purge_set.program_tag;

Line 659: delete from fnd_lobs

655: begin
656: if program_tag is null then
657: delete from fnd_lobs where fnd_lobs.program_name = purge_set.program_name;
658: else
659: delete from fnd_lobs
660: where fnd_lobs.program_name = purge_set.program_name
661: and fnd_lobs.program_tag = purge_set.program_tag;
662: end if;
663: commit;

Line 660: where fnd_lobs.program_name = purge_set.program_name

656: if program_tag is null then
657: delete from fnd_lobs where fnd_lobs.program_name = purge_set.program_name;
658: else
659: delete from fnd_lobs
660: where fnd_lobs.program_name = purge_set.program_name
661: and fnd_lobs.program_tag = purge_set.program_tag;
662: end if;
663: commit;
664: exception

Line 661: and fnd_lobs.program_tag = purge_set.program_tag;

657: delete from fnd_lobs where fnd_lobs.program_name = purge_set.program_name;
658: else
659: delete from fnd_lobs
660: where fnd_lobs.program_name = purge_set.program_name
661: and fnd_lobs.program_tag = purge_set.program_tag;
662: end if;
663: commit;
664: exception
665: when others then

Line 741: insert into fnd_lobs (file_id, file_name, file_content_type,

737: open_file_handles.extend;
738: fd := open_file_handles.count;
739: end if;
740:
741: insert into fnd_lobs (file_id, file_name, file_content_type,
742: file_data, upload_date, expiration_date, program_name, program_tag,
743: language,oracle_charset,file_format)
744: values (fnd_lobs_s.nextval, file_name, ct,
745: EMPTY_BLOB(), sysdate, sysdate + 1, program_name, program_tag,

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

740:
741: insert into fnd_lobs (file_id, file_name, file_content_type,
742: file_data, upload_date, expiration_date, program_name, program_tag,
743: language,oracle_charset,file_format)
744: values (fnd_lobs_s.nextval, file_name, ct,
745: EMPTY_BLOB(), sysdate, sysdate + 1, program_name, program_tag,
746: l_lang, fnd_gfm.iana_to_oracle(iana_cs), l_file_format)
747: returning file_id into fh.fid;
748:

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

766: begin
767: fh := open_file_handles(fd);
768: open_file_handles(fd) := null;
769:
770: update fnd_lobs set expiration_date = null where file_id = fh.fid;
771: commit;
772:
773: return fh.fid;
774: exception

Line 797: from fnd_lobs

793:
794: -- Re-open blob and get data. We must re-open every time instead of
795: -- caching so that procedures can be made autonomous.
796: select file_data, oracle_charset into flob, ocs
797: from fnd_lobs
798: where file_id = fh.fid
799: for update of file_data;
800:
801: -- BUG#1449494, created while loop to bypass convert() limitation.

Line 945: * delete from fnd_lobs where file_id = download.file_id; */

941:
942: if (purge = 'yes') then
943: /* Instead of deleting the data immediatlely we are setting the
944: * expiration data.
945: * delete from fnd_lobs where file_id = download.file_id; */
946: update fnd_lobs
947: set fnd_lobs.expiration_date = sysdate + 0.5
948: where fnd_lobs.file_id = download.file_id;
949: end if;

Line 946: update fnd_lobs

942: if (purge = 'yes') then
943: /* Instead of deleting the data immediatlely we are setting the
944: * expiration data.
945: * delete from fnd_lobs where file_id = download.file_id; */
946: update fnd_lobs
947: set fnd_lobs.expiration_date = sysdate + 0.5
948: where fnd_lobs.file_id = download.file_id;
949: end if;
950: end if;

Line 947: set fnd_lobs.expiration_date = sysdate + 0.5

943: /* Instead of deleting the data immediatlely we are setting the
944: * expiration data.
945: * delete from fnd_lobs where file_id = download.file_id; */
946: update fnd_lobs
947: set fnd_lobs.expiration_date = sysdate + 0.5
948: where fnd_lobs.file_id = download.file_id;
949: end if;
950: end if;
951: exception

Line 948: where fnd_lobs.file_id = download.file_id;

944: * expiration data.
945: * delete from fnd_lobs where file_id = download.file_id; */
946: update fnd_lobs
947: set fnd_lobs.expiration_date = sysdate + 0.5
948: where fnd_lobs.file_id = download.file_id;
949: end if;
950: end if;
951: exception
952: when others then

Line 988: from fnd_lobs

984:
985: begin
986: select file_content_type, oracle_charset, program_name, file_data, file_name
987: into ct, ocs, pn, doc, fn
988: from fnd_lobs
989: where file_id = download_blob.fid;
990:
991: semi := instr(ct, ';');
992: -- Bug 3966022 - looking now specifically for charset value

Line 1233: from fnd_lobs

1229: end if;
1230:
1231: select lower(program_name),expiration_date
1232: into prog_name, exp_date
1233: from fnd_lobs
1234: where file_id = l_file_id;
1235:
1236: if (prog_name = 'export' and exp_date is not null) then
1237: fnd_profile.get('FND_EXPORT_PURGE_ON_VIEW',p_purge_on_view);

Line 1270: fnd_lobs_rec fnd_lobs%ROWTYPE;

1266: */
1267: FUNCTION copy_lob(fid_from number) return number is
1268: fid_to number;
1269: fnd_usr_rec fnd_user%ROWTYPE;
1270: fnd_lobs_rec fnd_lobs%ROWTYPE;
1271: begin
1272:
1273: SELECT fnd_lobs_s.nextval
1274: INTO fid_to

Line 1273: SELECT fnd_lobs_s.nextval

1269: fnd_usr_rec fnd_user%ROWTYPE;
1270: fnd_lobs_rec fnd_lobs%ROWTYPE;
1271: begin
1272:
1273: SELECT fnd_lobs_s.nextval
1274: INTO fid_to
1275: FROM dual;
1276:
1277: SELECT file_id,

Line 1288: INTO fnd_lobs_rec.file_id,

1284: file_data,
1285: language,
1286: oracle_charset,
1287: file_format
1288: INTO fnd_lobs_rec.file_id,
1289: fnd_lobs_rec.file_name,
1290: fnd_lobs_rec.file_content_type,
1291: fnd_lobs_rec.upload_date,
1292: fnd_lobs_rec.expiration_date,

Line 1289: fnd_lobs_rec.file_name,

1285: language,
1286: oracle_charset,
1287: file_format
1288: INTO fnd_lobs_rec.file_id,
1289: fnd_lobs_rec.file_name,
1290: fnd_lobs_rec.file_content_type,
1291: fnd_lobs_rec.upload_date,
1292: fnd_lobs_rec.expiration_date,
1293: fnd_lobs_rec.program_name,

Line 1290: fnd_lobs_rec.file_content_type,

1286: oracle_charset,
1287: file_format
1288: INTO fnd_lobs_rec.file_id,
1289: fnd_lobs_rec.file_name,
1290: fnd_lobs_rec.file_content_type,
1291: fnd_lobs_rec.upload_date,
1292: fnd_lobs_rec.expiration_date,
1293: fnd_lobs_rec.program_name,
1294: fnd_lobs_rec.program_tag,

Line 1291: fnd_lobs_rec.upload_date,

1287: file_format
1288: INTO fnd_lobs_rec.file_id,
1289: fnd_lobs_rec.file_name,
1290: fnd_lobs_rec.file_content_type,
1291: fnd_lobs_rec.upload_date,
1292: fnd_lobs_rec.expiration_date,
1293: fnd_lobs_rec.program_name,
1294: fnd_lobs_rec.program_tag,
1295: fnd_lobs_rec.file_data,

Line 1292: fnd_lobs_rec.expiration_date,

1288: INTO fnd_lobs_rec.file_id,
1289: fnd_lobs_rec.file_name,
1290: fnd_lobs_rec.file_content_type,
1291: fnd_lobs_rec.upload_date,
1292: fnd_lobs_rec.expiration_date,
1293: fnd_lobs_rec.program_name,
1294: fnd_lobs_rec.program_tag,
1295: fnd_lobs_rec.file_data,
1296: fnd_lobs_rec.language,

Line 1293: fnd_lobs_rec.program_name,

1289: fnd_lobs_rec.file_name,
1290: fnd_lobs_rec.file_content_type,
1291: fnd_lobs_rec.upload_date,
1292: fnd_lobs_rec.expiration_date,
1293: fnd_lobs_rec.program_name,
1294: fnd_lobs_rec.program_tag,
1295: fnd_lobs_rec.file_data,
1296: fnd_lobs_rec.language,
1297: fnd_lobs_rec.oracle_charset,

Line 1294: fnd_lobs_rec.program_tag,

1290: fnd_lobs_rec.file_content_type,
1291: fnd_lobs_rec.upload_date,
1292: fnd_lobs_rec.expiration_date,
1293: fnd_lobs_rec.program_name,
1294: fnd_lobs_rec.program_tag,
1295: fnd_lobs_rec.file_data,
1296: fnd_lobs_rec.language,
1297: fnd_lobs_rec.oracle_charset,
1298: fnd_lobs_rec.file_format

Line 1295: fnd_lobs_rec.file_data,

1291: fnd_lobs_rec.upload_date,
1292: fnd_lobs_rec.expiration_date,
1293: fnd_lobs_rec.program_name,
1294: fnd_lobs_rec.program_tag,
1295: fnd_lobs_rec.file_data,
1296: fnd_lobs_rec.language,
1297: fnd_lobs_rec.oracle_charset,
1298: fnd_lobs_rec.file_format
1299: FROM fnd_lobs

Line 1296: fnd_lobs_rec.language,

1292: fnd_lobs_rec.expiration_date,
1293: fnd_lobs_rec.program_name,
1294: fnd_lobs_rec.program_tag,
1295: fnd_lobs_rec.file_data,
1296: fnd_lobs_rec.language,
1297: fnd_lobs_rec.oracle_charset,
1298: fnd_lobs_rec.file_format
1299: FROM fnd_lobs
1300: WHERE file_id = fid_from;

Line 1297: fnd_lobs_rec.oracle_charset,

1293: fnd_lobs_rec.program_name,
1294: fnd_lobs_rec.program_tag,
1295: fnd_lobs_rec.file_data,
1296: fnd_lobs_rec.language,
1297: fnd_lobs_rec.oracle_charset,
1298: fnd_lobs_rec.file_format
1299: FROM fnd_lobs
1300: WHERE file_id = fid_from;
1301:

Line 1298: fnd_lobs_rec.file_format

1294: fnd_lobs_rec.program_tag,
1295: fnd_lobs_rec.file_data,
1296: fnd_lobs_rec.language,
1297: fnd_lobs_rec.oracle_charset,
1298: fnd_lobs_rec.file_format
1299: FROM fnd_lobs
1300: WHERE file_id = fid_from;
1301:
1302: INSERT INTO fnd_lobs (file_id,

Line 1299: FROM fnd_lobs

1295: fnd_lobs_rec.file_data,
1296: fnd_lobs_rec.language,
1297: fnd_lobs_rec.oracle_charset,
1298: fnd_lobs_rec.file_format
1299: FROM fnd_lobs
1300: WHERE file_id = fid_from;
1301:
1302: INSERT INTO fnd_lobs (file_id,
1303: file_name,

Line 1302: INSERT INTO fnd_lobs (file_id,

1298: fnd_lobs_rec.file_format
1299: FROM fnd_lobs
1300: WHERE file_id = fid_from;
1301:
1302: INSERT INTO fnd_lobs (file_id,
1303: file_name,
1304: file_content_type,
1305: upload_date,
1306: expiration_date,

Line 1314: fnd_lobs_rec.file_name,

1310: language,
1311: oracle_charset,
1312: file_format)
1313: VALUES (fid_to,
1314: fnd_lobs_rec.file_name,
1315: fnd_lobs_rec.file_content_type,
1316: fnd_lobs_rec.upload_date,
1317: fnd_lobs_rec.expiration_date,
1318: fnd_lobs_rec.program_name,

Line 1315: fnd_lobs_rec.file_content_type,

1311: oracle_charset,
1312: file_format)
1313: VALUES (fid_to,
1314: fnd_lobs_rec.file_name,
1315: fnd_lobs_rec.file_content_type,
1316: fnd_lobs_rec.upload_date,
1317: fnd_lobs_rec.expiration_date,
1318: fnd_lobs_rec.program_name,
1319: fnd_lobs_rec.program_tag,

Line 1316: fnd_lobs_rec.upload_date,

1312: file_format)
1313: VALUES (fid_to,
1314: fnd_lobs_rec.file_name,
1315: fnd_lobs_rec.file_content_type,
1316: fnd_lobs_rec.upload_date,
1317: fnd_lobs_rec.expiration_date,
1318: fnd_lobs_rec.program_name,
1319: fnd_lobs_rec.program_tag,
1320: fnd_lobs_rec.file_data,

Line 1317: fnd_lobs_rec.expiration_date,

1313: VALUES (fid_to,
1314: fnd_lobs_rec.file_name,
1315: fnd_lobs_rec.file_content_type,
1316: fnd_lobs_rec.upload_date,
1317: fnd_lobs_rec.expiration_date,
1318: fnd_lobs_rec.program_name,
1319: fnd_lobs_rec.program_tag,
1320: fnd_lobs_rec.file_data,
1321: fnd_lobs_rec.language,

Line 1318: fnd_lobs_rec.program_name,

1314: fnd_lobs_rec.file_name,
1315: fnd_lobs_rec.file_content_type,
1316: fnd_lobs_rec.upload_date,
1317: fnd_lobs_rec.expiration_date,
1318: fnd_lobs_rec.program_name,
1319: fnd_lobs_rec.program_tag,
1320: fnd_lobs_rec.file_data,
1321: fnd_lobs_rec.language,
1322: fnd_lobs_rec.oracle_charset,

Line 1319: fnd_lobs_rec.program_tag,

1315: fnd_lobs_rec.file_content_type,
1316: fnd_lobs_rec.upload_date,
1317: fnd_lobs_rec.expiration_date,
1318: fnd_lobs_rec.program_name,
1319: fnd_lobs_rec.program_tag,
1320: fnd_lobs_rec.file_data,
1321: fnd_lobs_rec.language,
1322: fnd_lobs_rec.oracle_charset,
1323: fnd_lobs_rec.file_format);

Line 1320: fnd_lobs_rec.file_data,

1316: fnd_lobs_rec.upload_date,
1317: fnd_lobs_rec.expiration_date,
1318: fnd_lobs_rec.program_name,
1319: fnd_lobs_rec.program_tag,
1320: fnd_lobs_rec.file_data,
1321: fnd_lobs_rec.language,
1322: fnd_lobs_rec.oracle_charset,
1323: fnd_lobs_rec.file_format);
1324:

Line 1321: fnd_lobs_rec.language,

1317: fnd_lobs_rec.expiration_date,
1318: fnd_lobs_rec.program_name,
1319: fnd_lobs_rec.program_tag,
1320: fnd_lobs_rec.file_data,
1321: fnd_lobs_rec.language,
1322: fnd_lobs_rec.oracle_charset,
1323: fnd_lobs_rec.file_format);
1324:
1325: return fid_to;

Line 1322: fnd_lobs_rec.oracle_charset,

1318: fnd_lobs_rec.program_name,
1319: fnd_lobs_rec.program_tag,
1320: fnd_lobs_rec.file_data,
1321: fnd_lobs_rec.language,
1322: fnd_lobs_rec.oracle_charset,
1323: fnd_lobs_rec.file_format);
1324:
1325: return fid_to;
1326:

Line 1323: fnd_lobs_rec.file_format);

1319: fnd_lobs_rec.program_tag,
1320: fnd_lobs_rec.file_data,
1321: fnd_lobs_rec.language,
1322: fnd_lobs_rec.oracle_charset,
1323: fnd_lobs_rec.file_format);
1324:
1325: return fid_to;
1326:
1327: exception

Line 1334: * set_file_format - This function sets the file_format for fnd_lobs CTX

1330: raise;
1331: end copy_lob;
1332: /*--------------------------------------------------------------------------*/
1333: /*
1334: * set_file_format - This function sets the file_format for fnd_lobs CTX
1335: * Returns file_format derived from file_content_type in fnd_lobs.
1336: */
1337: FUNCTION set_file_format(l_file_content_type VARCHAR2) RETURN VARCHAR2 IS
1338: l_semicol_exists number;

Line 1335: * Returns file_format derived from file_content_type in fnd_lobs.

1331: end copy_lob;
1332: /*--------------------------------------------------------------------------*/
1333: /*
1334: * set_file_format - This function sets the file_format for fnd_lobs CTX
1335: * Returns file_format derived from file_content_type in fnd_lobs.
1336: */
1337: FUNCTION set_file_format(l_file_content_type VARCHAR2) RETURN VARCHAR2 IS
1338: l_semicol_exists number;
1339: l_mime_type varchar2(256);

Line 1375: * or clob and creates a file in fnd_lobs. It will create a file id if none

1371: END set_file_format;
1372: /*--------------------------------------------------------------------------*/
1373: /*
1374: * clob_to_blob This function takes my_clob which can be a varchar2, long,
1375: * or clob and creates a file in fnd_lobs. It will create a file id if none
1376: * is passed in. file_name will need an extension.
1377: */
1378:
1379: PROCEDURE CLOB_TO_BLOB (

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

1405: raise G_EXC_ERROR;
1406: end if;
1407:
1408: if fid is null then
1409: select fnd_lobs_s.nextval into fid from dual;
1410: end if;
1411:
1412: if file_content_type is null then
1413: v_content_type := 'text/plain';

Line 1424: INSERT INTO fnd_lobs (

1420: else
1421: v_language := language;
1422: end if;
1423:
1424: INSERT INTO fnd_lobs (
1425: file_id,
1426: file_name,
1427: file_content_type,
1428: upload_date,

Line 1449: select file_data into l_blob_loc from fnd_lobs

1445: v_language,
1446: fnd_gfm.iana_to_oracle(fnd_gfm.get_iso_charset),
1447: fnd_gfm.set_file_format(v_content_type));
1448:
1449: select file_data into l_blob_loc from fnd_lobs
1450: where file_id = fid;
1451:
1452:
1453: DBMS_LOB.OPEN (l_blob_loc, DBMS_LOB.LOB_READWRITE);

Line 1502: * delete_lob - this api deletes a lob in fnd_lobs using file_id.

1498: END clob_to_blob;
1499: /*--------------------------------------------------------------------------*/
1500:
1501: /*
1502: * delete_lob - this api deletes a lob in fnd_lobs using file_id.
1503: *
1504: */
1505:
1506: PROCEDURE DELETE_LOB (fid number) IS

Line 1508: delete from fnd_lobs where file_id = fid;

1504: */
1505:
1506: PROCEDURE DELETE_LOB (fid number) IS
1507: BEGIN
1508: delete from fnd_lobs where file_id = fid;
1509: commit;
1510: exception
1511: when others then
1512: fnd_gfm.err_msg('delete_lob');

Line 1578: * fnd_lobs

1574:
1575: ------------------------------------------------------------------------------
1576:
1577: /* verify_file_type - returns whether a file type is allowed to be uploaded into
1578: * fnd_lobs
1579: * return Y=do not retrict this filetype
1580: * return N=restrict this filetype
1581: */
1582: FUNCTION verify_file_type (file_name varchar2, file_ext varchar2)