DBA Data[Home] [Help]

APPS.FEM_DATA_TEMPLATE_UTIL_PKG dependencies on UTL_RAW

Line 220: l_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(l_blob_in, l_buffer, l_start));

216: DBMS_LOB.CREATETEMPORARY(l_clob, TRUE);
217:
218: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_blob_in) / l_buffer) LOOP
219:
220: l_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(l_blob_in, l_buffer, l_start));
221: DBMS_LOB.WRITEAPPEND(l_clob, LENGTH(l_varchar), l_varchar);
222: l_start := l_start + l_buffer;
223:
224: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 326: l_amt_write := utl_raw.length (utl_raw.cast_to_raw( l_varchar) );

322:
323: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_clob) / l_buffer) LOOP
324:
325: DBMS_LOB.read ( l_clob, l_buffer, l_start, l_varchar );
326: l_amt_write := utl_raw.length (utl_raw.cast_to_raw( l_varchar) );
327: DBMS_LOB.write( l_blob_out, l_amt_write, l_off_write, utl_raw.cast_to_raw( l_varchar ) );
328: l_off_write := l_off_write + l_amt_write;
329: l_start := l_start + l_buffer;
330:

Line 327: DBMS_LOB.write( l_blob_out, l_amt_write, l_off_write, utl_raw.cast_to_raw( l_varchar ) );

323: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_clob) / l_buffer) LOOP
324:
325: DBMS_LOB.read ( l_clob, l_buffer, l_start, l_varchar );
326: l_amt_write := utl_raw.length (utl_raw.cast_to_raw( l_varchar) );
327: DBMS_LOB.write( l_blob_out, l_amt_write, l_off_write, utl_raw.cast_to_raw( l_varchar ) );
328: l_off_write := l_off_write + l_amt_write;
329: l_start := l_start + l_buffer;
330:
331: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN