DBA Data[Home] [Help]

APPS.PAY_AE_CHEQUE_REPORT dependencies on UTL_RAW

Line 598: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);

594: l_chunk_len := l_buffer_len;
595: end if;
596: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
597: fnd_file.put_line(fnd_file.log,l_varchar_buffer);
598: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
599: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
600: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
601: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
602: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);

Line 599: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);

595: end if;
596: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
597: fnd_file.put_line(fnd_file.log,l_varchar_buffer);
598: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
599: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
600: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
601: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
602: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
603: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);

Line 600: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));

596: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
597: fnd_file.put_line(fnd_file.log,l_varchar_buffer);
598: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
599: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
600: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
601: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
602: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
603: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
604: l_blob_offset := l_blob_offset + l_raw_buffer_len;