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 DBMS_LOB

Line 372: select dbms_lob.getlength(blob_content), mime_type

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

Line 730: dbms_lob.write(flob,1000,fh.offset, convert(l_str,ocs));

726:
727: -- BUG#1449494, created while loop to bypass convert() limitation.
728: while (l_len > 1000) loop
729: l_str := utl_raw.substr(buffer,l_pos, 1000);
730: dbms_lob.write(flob,1000,fh.offset, convert(l_str,ocs));
731: l_pos := l_pos + 1000;
732: l_len := l_len - 1000;
733: fh.offset := fh.offset + 1000;
734: end loop;

Line 736: dbms_lob.write(flob, l_len, fh.offset, convert(l_str,ocs));

732: l_len := l_len - 1000;
733: fh.offset := fh.offset + 1000;
734: end loop;
735: l_str := utl_raw.substr(buffer, l_pos);
736: dbms_lob.write(flob, l_len, fh.offset, convert(l_str,ocs));
737: fh.offset := fh.offset + l_len;
738: open_file_handles(fd) := fh;
739: commit;
740: exception

Line 943: dbms_lob.createtemporary(lob_loc,TRUE);

939: if (pn = 'export' and nce is not null) then
940: cs := fnd_gfm.oracle_to_iana(nce);
941: nce := 'american_america.'||nce;
942: ocs := 'american_america.'||ocs;
943: dbms_lob.createtemporary(lob_loc,TRUE);
944: dbms_lob.open(doc, DBMS_LOB.LOB_READONLY);
945: len := dbms_lob.getlength(doc);
946: loop
947: if len > amount

Line 944: dbms_lob.open(doc, DBMS_LOB.LOB_READONLY);

940: cs := fnd_gfm.oracle_to_iana(nce);
941: nce := 'american_america.'||nce;
942: ocs := 'american_america.'||ocs;
943: dbms_lob.createtemporary(lob_loc,TRUE);
944: dbms_lob.open(doc, DBMS_LOB.LOB_READONLY);
945: len := dbms_lob.getlength(doc);
946: loop
947: if len > amount
948: then

Line 945: len := dbms_lob.getlength(doc);

941: nce := 'american_america.'||nce;
942: ocs := 'american_america.'||ocs;
943: dbms_lob.createtemporary(lob_loc,TRUE);
944: dbms_lob.open(doc, DBMS_LOB.LOB_READONLY);
945: len := dbms_lob.getlength(doc);
946: loop
947: if len > amount
948: then
949: dbms_lob.read(doc, amount, offset, buffer);

Line 949: dbms_lob.read(doc, amount, offset, buffer);

945: len := dbms_lob.getlength(doc);
946: loop
947: if len > amount
948: then
949: dbms_lob.read(doc, amount, offset, buffer);
950: var :=utl_raw.cast_to_varchar2(buffer);
951: lenvarb :=lengthb(var);
952: if length(var) > 10
953: then

Line 960: dbms_lob.write(lob_loc, b_amount, offset2, buffer);

956: lenvarb := lenvarb - lengthb(var);
957: buffer := utl_raw.cast_to_raw(var);
958: buffer := utl_raw.convert(buffer, nce, ocs);
959: b_amount := utl_raw.length(buffer);
960: dbms_lob.write(lob_loc, b_amount, offset2, buffer);
961: len := len - amount + lenvarb;
962: offset := offset + amount - lenvarb;
963: offset2 := offset2 + b_amount;
964: else

Line 965: dbms_lob.read(doc, len, offset, buffer);

961: len := len - amount + lenvarb;
962: offset := offset + amount - lenvarb;
963: offset2 := offset2 + b_amount;
964: else
965: dbms_lob.read(doc, len, offset, buffer);
966: buffer := utl_raw.convert(buffer, nce, ocs);
967: amount := utl_raw.length(buffer);
968: dbms_lob.write(lob_loc, amount, offset2, buffer);
969: exit;

Line 968: dbms_lob.write(lob_loc, amount, offset2, buffer);

964: else
965: dbms_lob.read(doc, len, offset, buffer);
966: buffer := utl_raw.convert(buffer, nce, ocs);
967: amount := utl_raw.length(buffer);
968: dbms_lob.write(lob_loc, amount, offset2, buffer);
969: exit;
970: end if;
971: end loop;
972: end if;

Line 976: htp.p( 'Content-length: ' || dbms_lob.getlength(lob_loc));

972: end if;
973:
974: owa_util.mime_header(ctype, FALSE, cs);
975: if (pn = 'export' and nce is not null) then
976: htp.p( 'Content-length: ' || dbms_lob.getlength(lob_loc));
977: else
978: htp.p( 'Content-length: ' || dbms_lob.getlength(doc));
979: end if;
980: /* Commenting out the following do resolve the issue with Export

Line 978: htp.p( 'Content-length: ' || dbms_lob.getlength(doc));

974: owa_util.mime_header(ctype, FALSE, cs);
975: if (pn = 'export' and nce is not null) then
976: htp.p( 'Content-length: ' || dbms_lob.getlength(lob_loc));
977: else
978: htp.p( 'Content-length: ' || dbms_lob.getlength(doc));
979: end if;
980: /* Commenting out the following do resolve the issue with Export
981: failing on Internet Explorer.
982: htp.p( 'Cache-Control: no-cache' ); */

Line 986: dbms_lob.freetemporary(lob_loc);

982: htp.p( 'Cache-Control: no-cache' ); */
983: owa_util.http_header_close;
984: if (pn = 'export' and nce is not null) then
985: wpg_docload.download_file(lob_loc);
986: dbms_lob.freetemporary(lob_loc);
987: dbms_lob.close(doc);
988: else
989: wpg_docload.download_file(doc);
990: end if;

Line 987: dbms_lob.close(doc);

983: owa_util.http_header_close;
984: if (pn = 'export' and nce is not null) then
985: wpg_docload.download_file(lob_loc);
986: dbms_lob.freetemporary(lob_loc);
987: dbms_lob.close(doc);
988: else
989: wpg_docload.download_file(doc);
990: end if;
991:

Line 1322: DBMS_LOB.OPEN (l_blob_loc, DBMS_LOB.LOB_READWRITE);

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);
1323:
1324: -- First determine the input LOB length.
1325: v_LOBLength := DBMS_LOB.GETLENGTH(my_clob);
1326:

Line 1325: v_LOBLength := DBMS_LOB.GETLENGTH(my_clob);

1321:
1322: DBMS_LOB.OPEN (l_blob_loc, DBMS_LOB.LOB_READWRITE);
1323:
1324: -- First determine the input LOB length.
1325: v_LOBLength := DBMS_LOB.GETLENGTH(my_clob);
1326:
1327: -- Set up the initial offsets. The input offset starts at the
1328: -- beginning, the output offset at the end.
1329: v_InputOffset := 1;

Line 1345: dbms_lob.read(my_clob, v_CurrentChunkSize, v_InputOffset, varbuf);

1341: ELSE
1342: v_CurrentChunkSize := v_LOBLength - v_InputOffset + 1;
1343: END IF;
1344:
1345: dbms_lob.read(my_clob, v_CurrentChunkSize, v_InputOffset, varbuf);
1346:
1347: -- Write the current chunk.
1348: DBMS_LOB.writeappend(l_blob_loc, lengthb(varbuf), UTL_RAW.cast_to_raw(varbuf));
1349:

Line 1348: DBMS_LOB.writeappend(l_blob_loc, lengthb(varbuf), UTL_RAW.cast_to_raw(varbuf));

1344:
1345: dbms_lob.read(my_clob, v_CurrentChunkSize, v_InputOffset, varbuf);
1346:
1347: -- Write the current chunk.
1348: DBMS_LOB.writeappend(l_blob_loc, lengthb(varbuf), UTL_RAW.cast_to_raw(varbuf));
1349:
1350: -- Increment the input offset by the current chunk size.
1351: v_InputOffset := v_InputOffset + v_CurrentChunkSize;
1352: END LOOP;

Line 1354: DBMS_LOB.CLOSE(l_blob_loc);

1350: -- Increment the input offset by the current chunk size.
1351: v_InputOffset := v_InputOffset + v_CurrentChunkSize;
1352: END LOOP;
1353:
1354: DBMS_LOB.CLOSE(l_blob_loc);
1355: --return x_return_status;
1356:
1357: exception
1358: when G_EXC_ERROR then