DBA Data[Home] [Help]

APPS.GCS_DATA_TEMPLATE_UTIL_PKG dependencies on UTL_RAW

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

253: END IF;
254: -- Create a temporary clob to hold manipulated contents
255: DBMS_LOB.CREATETEMPORARY(l_clob, TRUE);
256: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_blob_in) / l_buffer) LOOP
257: l_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(l_blob_in, l_buffer, l_start));
258: DBMS_LOB.WRITEAPPEND(l_clob, LENGTH(l_varchar), l_varchar);
259: l_start := l_start + l_buffer;
260: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
261: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_varchar : '||l_varchar);

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

540:
541: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_clob) / l_buffer) LOOP
542:
543: DBMS_LOB.read ( l_clob, l_buffer, l_start, l_varchar );
544: l_amt_write := utl_raw.length (utl_raw.cast_to_raw( l_varchar) );
545: DBMS_LOB.write( l_blob_out, l_amt_write, l_off_write, utl_raw.cast_to_raw( l_varchar ) );
546: l_off_write := l_off_write + l_amt_write;
547: l_start := l_start + l_buffer;
548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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

541: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(l_clob) / l_buffer) LOOP
542:
543: DBMS_LOB.read ( l_clob, l_buffer, l_start, l_varchar );
544: l_amt_write := utl_raw.length (utl_raw.cast_to_raw( l_varchar) );
545: DBMS_LOB.write( l_blob_out, l_amt_write, l_off_write, utl_raw.cast_to_raw( l_varchar ) );
546: l_off_write := l_off_write + l_amt_write;
547: l_start := l_start + l_buffer;
548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
549: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_api || '.' || 'gcs_replace_dt_proc', 'l_start : '||l_start);