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 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 139: where fnd_lobs.file_id = construct_download_url2.file_id;

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
143: from fnd_lobs

Line 143: from fnd_lobs

139: where fnd_lobs.file_id = construct_download_url2.file_id;
140:
141: else
142: select instr(file_name,'.',-1) into ext_length
143: from fnd_lobs
144: where file_id = construct_download_url2.file_id;
145:
146: if ext_length > 0 then
147: select substr(file_name,instr(file_name,'/',-1)+1) into file_name

Line 148: from fnd_lobs

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

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

308: /*
309: * confirm_upload - confirm the completion of an upload
310: * This procedure must be called from within the user's PL/SQL upload
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.

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 348: --data into fnd_lobs table

344: begin
345: if (getRelease = 12) then
346: begin
347: --we already through the OA page has inserted the
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

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 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 401: insert into fnd_lobs (file_id,

397: ufslim := ufslim * 1000;
398: end if;
399:
400: if bloblength BETWEEN 1 and ufslim then
401: insert into fnd_lobs (file_id,
402: file_name,
403: file_content_type,
404: file_data,
405: upload_date,

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;

Line 560: delete from fnd_lobs where sysdate > expiration_date;

556: PROCEDURE purge_expired(program_name varchar2 default null) is
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

Line 564: delete from fnd_lobs

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
566: and sysdate > expiration_date;
567: commit;
568: end if;

Line 565: where fnd_lobs.program_name = purge_expired.program_name

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
566: and sysdate > expiration_date;
567: commit;
568: end if;
569: exception

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

579: program_tag varchar2 default null) is
580: pragma autonomous_transaction;
581: begin
582: if program_tag is null then
583: delete from fnd_lobs where fnd_lobs.program_name = purge_set.program_name;
584: else
585: delete from fnd_lobs
586: where fnd_lobs.program_name = purge_set.program_name
587: and fnd_lobs.program_tag = purge_set.program_tag;

Line 585: delete from fnd_lobs

581: begin
582: if program_tag is null then
583: delete from fnd_lobs where fnd_lobs.program_name = purge_set.program_name;
584: else
585: delete from fnd_lobs
586: where fnd_lobs.program_name = purge_set.program_name
587: and fnd_lobs.program_tag = purge_set.program_tag;
588: end if;
589: commit;

Line 586: where fnd_lobs.program_name = purge_set.program_name

582: if program_tag is null then
583: delete from fnd_lobs where fnd_lobs.program_name = purge_set.program_name;
584: else
585: delete from fnd_lobs
586: where fnd_lobs.program_name = purge_set.program_name
587: and fnd_lobs.program_tag = purge_set.program_tag;
588: end if;
589: commit;
590: exception

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

583: delete from fnd_lobs where fnd_lobs.program_name = purge_set.program_name;
584: else
585: delete from fnd_lobs
586: where fnd_lobs.program_name = purge_set.program_name
587: and fnd_lobs.program_tag = purge_set.program_tag;
588: end if;
589: commit;
590: exception
591: when others then

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

663: open_file_handles.extend;
664: fd := open_file_handles.count;
665: end if;
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,

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 723: from fnd_lobs

719:
720: -- Re-open blob and get data. We must re-open every time instead of
721: -- caching so that procedures can be made autonomous.
722: select file_data, oracle_charset into flob, ocs
723: from fnd_lobs
724: where file_id = fh.fid
725: for update of file_data;
726:
727: -- BUG#1449494, created while loop to bypass convert() limitation.

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

867:
868: if (purge = 'yes') then
869: /* Instead of deleting the data immediatlely we are setting the
870: * expiration data.
871: * delete from fnd_lobs where file_id = download.file_id; */
872: update fnd_lobs
873: set fnd_lobs.expiration_date = sysdate + 0.5
874: where fnd_lobs.file_id = download.file_id;
875: end if;

Line 872: update fnd_lobs

868: if (purge = 'yes') then
869: /* Instead of deleting the data immediatlely we are setting the
870: * expiration data.
871: * delete from fnd_lobs where file_id = download.file_id; */
872: update fnd_lobs
873: set fnd_lobs.expiration_date = sysdate + 0.5
874: where fnd_lobs.file_id = download.file_id;
875: end if;
876: end if;

Line 873: set fnd_lobs.expiration_date = sysdate + 0.5

869: /* Instead of deleting the data immediatlely we are setting the
870: * expiration data.
871: * delete from fnd_lobs where file_id = download.file_id; */
872: update fnd_lobs
873: set fnd_lobs.expiration_date = sysdate + 0.5
874: where fnd_lobs.file_id = download.file_id;
875: end if;
876: end if;
877: exception

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

870: * expiration data.
871: * delete from fnd_lobs where file_id = download.file_id; */
872: update fnd_lobs
873: set fnd_lobs.expiration_date = sysdate + 0.5
874: where fnd_lobs.file_id = download.file_id;
875: end if;
876: end if;
877: exception
878: when others then

Line 911: from fnd_lobs

907:
908: begin
909: select file_content_type, oracle_charset, program_name, file_data
910: into ct, ocs, pn, doc
911: from fnd_lobs
912: where file_id = download_blob.fid;
913:
914: semi := instr(ct, ';');
915: -- Bug 3966022 - looking now specifically for charset value

Line 1143: fnd_lobs_rec fnd_lobs%ROWTYPE;

1139: */
1140: FUNCTION copy_lob(fid_from number) return number is
1141: fid_to number;
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

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 1161: INTO fnd_lobs_rec.file_id,

1157: file_data,
1158: language,
1159: oracle_charset,
1160: file_format
1161: INTO fnd_lobs_rec.file_id,
1162: fnd_lobs_rec.file_name,
1163: fnd_lobs_rec.file_content_type,
1164: fnd_lobs_rec.upload_date,
1165: fnd_lobs_rec.expiration_date,

Line 1162: fnd_lobs_rec.file_name,

1158: language,
1159: oracle_charset,
1160: file_format
1161: INTO fnd_lobs_rec.file_id,
1162: fnd_lobs_rec.file_name,
1163: fnd_lobs_rec.file_content_type,
1164: fnd_lobs_rec.upload_date,
1165: fnd_lobs_rec.expiration_date,
1166: fnd_lobs_rec.program_name,

Line 1163: fnd_lobs_rec.file_content_type,

1159: oracle_charset,
1160: file_format
1161: INTO fnd_lobs_rec.file_id,
1162: fnd_lobs_rec.file_name,
1163: fnd_lobs_rec.file_content_type,
1164: fnd_lobs_rec.upload_date,
1165: fnd_lobs_rec.expiration_date,
1166: fnd_lobs_rec.program_name,
1167: fnd_lobs_rec.program_tag,

Line 1164: fnd_lobs_rec.upload_date,

1160: file_format
1161: INTO fnd_lobs_rec.file_id,
1162: fnd_lobs_rec.file_name,
1163: fnd_lobs_rec.file_content_type,
1164: fnd_lobs_rec.upload_date,
1165: fnd_lobs_rec.expiration_date,
1166: fnd_lobs_rec.program_name,
1167: fnd_lobs_rec.program_tag,
1168: fnd_lobs_rec.file_data,

Line 1165: fnd_lobs_rec.expiration_date,

1161: INTO fnd_lobs_rec.file_id,
1162: fnd_lobs_rec.file_name,
1163: fnd_lobs_rec.file_content_type,
1164: fnd_lobs_rec.upload_date,
1165: fnd_lobs_rec.expiration_date,
1166: fnd_lobs_rec.program_name,
1167: fnd_lobs_rec.program_tag,
1168: fnd_lobs_rec.file_data,
1169: fnd_lobs_rec.language,

Line 1166: fnd_lobs_rec.program_name,

1162: fnd_lobs_rec.file_name,
1163: fnd_lobs_rec.file_content_type,
1164: fnd_lobs_rec.upload_date,
1165: fnd_lobs_rec.expiration_date,
1166: fnd_lobs_rec.program_name,
1167: fnd_lobs_rec.program_tag,
1168: fnd_lobs_rec.file_data,
1169: fnd_lobs_rec.language,
1170: fnd_lobs_rec.oracle_charset,

Line 1167: fnd_lobs_rec.program_tag,

1163: fnd_lobs_rec.file_content_type,
1164: fnd_lobs_rec.upload_date,
1165: fnd_lobs_rec.expiration_date,
1166: fnd_lobs_rec.program_name,
1167: fnd_lobs_rec.program_tag,
1168: fnd_lobs_rec.file_data,
1169: fnd_lobs_rec.language,
1170: fnd_lobs_rec.oracle_charset,
1171: fnd_lobs_rec.file_format

Line 1168: fnd_lobs_rec.file_data,

1164: fnd_lobs_rec.upload_date,
1165: fnd_lobs_rec.expiration_date,
1166: fnd_lobs_rec.program_name,
1167: fnd_lobs_rec.program_tag,
1168: fnd_lobs_rec.file_data,
1169: fnd_lobs_rec.language,
1170: fnd_lobs_rec.oracle_charset,
1171: fnd_lobs_rec.file_format
1172: FROM fnd_lobs

Line 1169: fnd_lobs_rec.language,

1165: fnd_lobs_rec.expiration_date,
1166: fnd_lobs_rec.program_name,
1167: fnd_lobs_rec.program_tag,
1168: fnd_lobs_rec.file_data,
1169: fnd_lobs_rec.language,
1170: fnd_lobs_rec.oracle_charset,
1171: fnd_lobs_rec.file_format
1172: FROM fnd_lobs
1173: WHERE file_id = fid_from;

Line 1170: fnd_lobs_rec.oracle_charset,

1166: fnd_lobs_rec.program_name,
1167: fnd_lobs_rec.program_tag,
1168: fnd_lobs_rec.file_data,
1169: fnd_lobs_rec.language,
1170: fnd_lobs_rec.oracle_charset,
1171: fnd_lobs_rec.file_format
1172: FROM fnd_lobs
1173: WHERE file_id = fid_from;
1174:

Line 1171: fnd_lobs_rec.file_format

1167: fnd_lobs_rec.program_tag,
1168: fnd_lobs_rec.file_data,
1169: fnd_lobs_rec.language,
1170: fnd_lobs_rec.oracle_charset,
1171: fnd_lobs_rec.file_format
1172: FROM fnd_lobs
1173: WHERE file_id = fid_from;
1174:
1175: INSERT INTO fnd_lobs (file_id,

Line 1172: FROM fnd_lobs

1168: fnd_lobs_rec.file_data,
1169: fnd_lobs_rec.language,
1170: fnd_lobs_rec.oracle_charset,
1171: fnd_lobs_rec.file_format
1172: FROM fnd_lobs
1173: WHERE file_id = fid_from;
1174:
1175: INSERT INTO fnd_lobs (file_id,
1176: file_name,

Line 1175: INSERT INTO fnd_lobs (file_id,

1171: fnd_lobs_rec.file_format
1172: FROM fnd_lobs
1173: WHERE file_id = fid_from;
1174:
1175: INSERT INTO fnd_lobs (file_id,
1176: file_name,
1177: file_content_type,
1178: upload_date,
1179: expiration_date,

Line 1187: fnd_lobs_rec.file_name,

1183: language,
1184: oracle_charset,
1185: file_format)
1186: VALUES (fid_to,
1187: fnd_lobs_rec.file_name,
1188: fnd_lobs_rec.file_content_type,
1189: fnd_lobs_rec.upload_date,
1190: fnd_lobs_rec.expiration_date,
1191: fnd_lobs_rec.program_name,

Line 1188: fnd_lobs_rec.file_content_type,

1184: oracle_charset,
1185: file_format)
1186: VALUES (fid_to,
1187: fnd_lobs_rec.file_name,
1188: fnd_lobs_rec.file_content_type,
1189: fnd_lobs_rec.upload_date,
1190: fnd_lobs_rec.expiration_date,
1191: fnd_lobs_rec.program_name,
1192: fnd_lobs_rec.program_tag,

Line 1189: fnd_lobs_rec.upload_date,

1185: file_format)
1186: VALUES (fid_to,
1187: fnd_lobs_rec.file_name,
1188: fnd_lobs_rec.file_content_type,
1189: fnd_lobs_rec.upload_date,
1190: fnd_lobs_rec.expiration_date,
1191: fnd_lobs_rec.program_name,
1192: fnd_lobs_rec.program_tag,
1193: fnd_lobs_rec.file_data,

Line 1190: fnd_lobs_rec.expiration_date,

1186: VALUES (fid_to,
1187: fnd_lobs_rec.file_name,
1188: fnd_lobs_rec.file_content_type,
1189: fnd_lobs_rec.upload_date,
1190: fnd_lobs_rec.expiration_date,
1191: fnd_lobs_rec.program_name,
1192: fnd_lobs_rec.program_tag,
1193: fnd_lobs_rec.file_data,
1194: fnd_lobs_rec.language,

Line 1191: fnd_lobs_rec.program_name,

1187: fnd_lobs_rec.file_name,
1188: fnd_lobs_rec.file_content_type,
1189: fnd_lobs_rec.upload_date,
1190: fnd_lobs_rec.expiration_date,
1191: fnd_lobs_rec.program_name,
1192: fnd_lobs_rec.program_tag,
1193: fnd_lobs_rec.file_data,
1194: fnd_lobs_rec.language,
1195: fnd_lobs_rec.oracle_charset,

Line 1192: fnd_lobs_rec.program_tag,

1188: fnd_lobs_rec.file_content_type,
1189: fnd_lobs_rec.upload_date,
1190: fnd_lobs_rec.expiration_date,
1191: fnd_lobs_rec.program_name,
1192: fnd_lobs_rec.program_tag,
1193: fnd_lobs_rec.file_data,
1194: fnd_lobs_rec.language,
1195: fnd_lobs_rec.oracle_charset,
1196: fnd_lobs_rec.file_format);

Line 1193: fnd_lobs_rec.file_data,

1189: fnd_lobs_rec.upload_date,
1190: fnd_lobs_rec.expiration_date,
1191: fnd_lobs_rec.program_name,
1192: fnd_lobs_rec.program_tag,
1193: fnd_lobs_rec.file_data,
1194: fnd_lobs_rec.language,
1195: fnd_lobs_rec.oracle_charset,
1196: fnd_lobs_rec.file_format);
1197:

Line 1194: fnd_lobs_rec.language,

1190: fnd_lobs_rec.expiration_date,
1191: fnd_lobs_rec.program_name,
1192: fnd_lobs_rec.program_tag,
1193: fnd_lobs_rec.file_data,
1194: fnd_lobs_rec.language,
1195: fnd_lobs_rec.oracle_charset,
1196: fnd_lobs_rec.file_format);
1197:
1198: return fid_to;

Line 1195: fnd_lobs_rec.oracle_charset,

1191: fnd_lobs_rec.program_name,
1192: fnd_lobs_rec.program_tag,
1193: fnd_lobs_rec.file_data,
1194: fnd_lobs_rec.language,
1195: fnd_lobs_rec.oracle_charset,
1196: fnd_lobs_rec.file_format);
1197:
1198: return fid_to;
1199:

Line 1196: fnd_lobs_rec.file_format);

1192: fnd_lobs_rec.program_tag,
1193: fnd_lobs_rec.file_data,
1194: fnd_lobs_rec.language,
1195: fnd_lobs_rec.oracle_charset,
1196: fnd_lobs_rec.file_format);
1197:
1198: return fid_to;
1199:
1200: exception

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

1203: raise;
1204: end copy_lob;
1205: /*--------------------------------------------------------------------------*/
1206: /*
1207: * set_file_format - This function sets the file_format for fnd_lobs CTX
1208: * Returns file_format derived from file_content_type in fnd_lobs.
1209: */
1210: FUNCTION set_file_format(l_file_content_type VARCHAR2) RETURN VARCHAR2 IS
1211: l_semicol_exists number;

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

1204: end copy_lob;
1205: /*--------------------------------------------------------------------------*/
1206: /*
1207: * set_file_format - This function sets the file_format for fnd_lobs CTX
1208: * Returns file_format derived from file_content_type in fnd_lobs.
1209: */
1210: FUNCTION set_file_format(l_file_content_type VARCHAR2) RETURN VARCHAR2 IS
1211: l_semicol_exists number;
1212: l_mime_type varchar2(256);

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

1240: END set_file_format;
1241: /*--------------------------------------------------------------------------*/
1242: /*
1243: * clob_to_blob This function takes my_clob which can be a varchar2, long,
1244: * or clob and creates a file in fnd_lobs. It will create a file id if none
1245: * is passed in. file_name will need an extension.
1246: */
1247:
1248: PROCEDURE CLOB_TO_BLOB (

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';

Line 1293: INSERT INTO fnd_lobs (

1289: else
1290: v_language := language;
1291: end if;
1292:
1293: INSERT INTO fnd_lobs (
1294: file_id,
1295: file_name,
1296: file_content_type,
1297: upload_date,

Line 1318: select file_data into l_blob_loc from fnd_lobs

1314: v_language,
1315: fnd_gfm.iana_to_oracle(fnd_gfm.get_iso_charset),
1316: fnd_gfm.set_file_format(v_content_type));
1317:
1318: select file_data into l_blob_loc from fnd_lobs
1319: where file_id = fid;
1320:
1321:
1322: DBMS_LOB.OPEN (l_blob_loc, DBMS_LOB.LOB_READWRITE);

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

1367: END clob_to_blob;
1368: /*--------------------------------------------------------------------------*/
1369:
1370: /*
1371: * delete_lob - this api deletes a lob in fnd_lobs using file_id.
1372: *
1373: */
1374:
1375: PROCEDURE DELETE_LOB (fid number) IS

Line 1377: delete from fnd_lobs where file_id = fid;

1373: */
1374:
1375: PROCEDURE DELETE_LOB (fid number) IS
1376: BEGIN
1377: delete from fnd_lobs where file_id = fid;
1378: commit;
1379: exception
1380: when others then
1381: fnd_gfm.err_msg('delete_lob');