DBA Data[Home] [Help]

APPS.FND_GFM dependencies on UTL_RAW

Line 714: l_len number := utl_raw.length(buffer);

710: pragma autonomous_transaction;
711: fh file_handle;
712: flob blob;
713: ocs varchar2(30);
714: l_len number := utl_raw.length(buffer);
715: l_pos number := 1;
716: l_str raw(6000) := null;
717: begin
718: fh := open_file_handles(fd);

Line 729: l_str := utl_raw.substr(buffer,l_pos, 1000);

725: for update of file_data;
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;

Line 735: l_str := utl_raw.substr(buffer, l_pos);

731: l_pos := l_pos + 1000;
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;

Line 754: file_write(fd, lengthb(buffer), utl_raw.cast_to_raw(buffer));

750: -- NOTE: This procedure is implicitly Autonomous Transaction,
751: -- because file_write(....) is autonomous.
752: begin
753: if buffer is not null then
754: file_write(fd, lengthb(buffer), utl_raw.cast_to_raw(buffer));
755: end if;
756: end;
757: /*--------------------------------------------------------------------------*/
758: /*

Line 768: (utl_raw.concat(utl_raw.cast_to_raw(buffer), hextoraw('0D0A'))));

764: -- BUG#1811196
765: -- Combined 2 file_write() calls to 1 for performance gain.
766: begin
767: file_write(fd, (lengthb(buffer)+2),
768: (utl_raw.concat(utl_raw.cast_to_raw(buffer), hextoraw('0D0A'))));
769: end;
770: /*--------------------------------------------------------------------------*/
771: /*
772: * test - testing procedure

Line 950: var :=utl_raw.cast_to_varchar2(buffer);

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
954: var := substr(var, 1, length(var) - 10);

Line 957: buffer := utl_raw.cast_to_raw(var);

953: then
954: var := substr(var, 1, length(var) - 10);
955: end if;
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;

Line 958: buffer := utl_raw.convert(buffer, nce, ocs);

954: var := substr(var, 1, length(var) - 10);
955: end if;
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;

Line 959: b_amount := utl_raw.length(buffer);

955: end if;
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;

Line 966: buffer := utl_raw.convert(buffer, nce, ocs);

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;
970: end if;

Line 967: amount := utl_raw.length(buffer);

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;
970: end if;
971: end loop;

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;