DBA Data[Home] [Help]

APPS.FND_GFM dependencies on UTL_RAW

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

784: pragma autonomous_transaction;
785: fh file_handle;
786: flob blob;
787: ocs varchar2(30);
788: l_len number := utl_raw.length(buffer);
789: l_pos number := 1;
790: l_str raw(6000) := null;
791: begin
792: fh := open_file_handles(fd);

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

799: for update of file_data;
800:
801: -- BUG#1449494, created while loop to bypass convert() limitation.
802: while (l_len > 1000) loop
803: l_str := utl_raw.substr(buffer,l_pos, 1000);
804: dbms_lob.write(flob,1000,fh.offset, convert(l_str,ocs));
805: l_pos := l_pos + 1000;
806: l_len := l_len - 1000;
807: fh.offset := fh.offset + 1000;

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

805: l_pos := l_pos + 1000;
806: l_len := l_len - 1000;
807: fh.offset := fh.offset + 1000;
808: end loop;
809: l_str := utl_raw.substr(buffer, l_pos);
810: dbms_lob.write(flob, l_len, fh.offset, convert(l_str,ocs));
811: fh.offset := fh.offset + l_len;
812: open_file_handles(fd) := fh;
813: commit;

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

824: -- NOTE: This procedure is implicitly Autonomous Transaction,
825: -- because file_write(....) is autonomous.
826: begin
827: if buffer is not null then
828: file_write(fd, lengthb(buffer), utl_raw.cast_to_raw(buffer));
829: end if;
830: end;
831: /*--------------------------------------------------------------------------*/
832: /*

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

838: -- BUG#1811196
839: -- Combined 2 file_write() calls to 1 for performance gain.
840: begin
841: file_write(fd, (lengthb(buffer)+2),
842: (utl_raw.concat(utl_raw.cast_to_raw(buffer), hextoraw('0D0A'))));
843: end;
844: /*--------------------------------------------------------------------------*/
845: /*
846: * test - testing procedure

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

1023: loop
1024: if len > amount
1025: then
1026: dbms_lob.read(doc, amount, offset, buffer);
1027: var :=utl_raw.cast_to_varchar2(buffer);
1028: lenvarb :=lengthb(var);
1029: if length(var) > 10
1030: then
1031: var := substr(var, 1, length(var) - 10);

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

1030: then
1031: var := substr(var, 1, length(var) - 10);
1032: end if;
1033: lenvarb := lenvarb - lengthb(var);
1034: buffer := utl_raw.cast_to_raw(var);
1035: buffer := utl_raw.convert(buffer, nce, ocs);
1036: b_amount := utl_raw.length(buffer);
1037: dbms_lob.write(lob_loc, b_amount, offset2, buffer);
1038: len := len - amount + lenvarb;

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

1031: var := substr(var, 1, length(var) - 10);
1032: end if;
1033: lenvarb := lenvarb - lengthb(var);
1034: buffer := utl_raw.cast_to_raw(var);
1035: buffer := utl_raw.convert(buffer, nce, ocs);
1036: b_amount := utl_raw.length(buffer);
1037: dbms_lob.write(lob_loc, b_amount, offset2, buffer);
1038: len := len - amount + lenvarb;
1039: offset := offset + amount - lenvarb;

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

1032: end if;
1033: lenvarb := lenvarb - lengthb(var);
1034: buffer := utl_raw.cast_to_raw(var);
1035: buffer := utl_raw.convert(buffer, nce, ocs);
1036: b_amount := utl_raw.length(buffer);
1037: dbms_lob.write(lob_loc, b_amount, offset2, buffer);
1038: len := len - amount + lenvarb;
1039: offset := offset + amount - lenvarb;
1040: offset2 := offset2 + b_amount;

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

1039: offset := offset + amount - lenvarb;
1040: offset2 := offset2 + b_amount;
1041: else
1042: dbms_lob.read(doc, len, offset, buffer);
1043: buffer := utl_raw.convert(buffer, nce, ocs);
1044: amount := utl_raw.length(buffer);
1045: dbms_lob.write(lob_loc, amount, offset2, buffer);
1046: exit;
1047: end if;

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

1040: offset2 := offset2 + b_amount;
1041: else
1042: dbms_lob.read(doc, len, offset, buffer);
1043: buffer := utl_raw.convert(buffer, nce, ocs);
1044: amount := utl_raw.length(buffer);
1045: dbms_lob.write(lob_loc, amount, offset2, buffer);
1046: exit;
1047: end if;
1048: end loop;

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

1475:
1476: dbms_lob.read(my_clob, v_CurrentChunkSize, v_InputOffset, varbuf);
1477:
1478: -- Write the current chunk.
1479: DBMS_LOB.writeappend(l_blob_loc, lengthb(varbuf), UTL_RAW.cast_to_raw(varbuf));
1480:
1481: -- Increment the input offset by the current chunk size.
1482: v_InputOffset := v_InputOffset + v_CurrentChunkSize;
1483: END LOOP;