eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_XML_PUB_UTILITY dependencies on DBMS_LOB

Line 22: l_length_clob := dbms_lob.getlength(p_clob);

18:
19: begin
20: hr_utility.set_location('Entered Procedure clob to blob',120);
21: select userenv('LANGUAGE') into g_nls_db_char from dual;
22: l_length_clob := dbms_lob.getlength(p_clob);
23: l_offset := 1;
24: while l_length_clob > 0 loop
25: hr_utility.trace('l_length_clob '|| l_length_clob);
26: if l_length_clob < l_buffer_len then

Line 31: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);

27: l_chunk_len := l_length_clob;
28: else
29: l_chunk_len := l_buffer_len;
30: end if;
31: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
32: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
33: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
34: 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));
35: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);

Line 36: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);

32: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
33: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
34: 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));
35: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
36: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
37: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
38: l_blob_offset := l_blob_offset + l_raw_buffer_len;
39:
40: l_offset := l_offset + l_chunk_len;

Line 37: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);

33: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
34: 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));
35: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
36: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
37: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
38: l_blob_offset := l_blob_offset + l_raw_buffer_len;
39:
40: l_offset := l_offset + l_chunk_len;
41: l_length_clob := l_length_clob - l_chunk_len;

Line 42: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

38: l_blob_offset := l_blob_offset + l_raw_buffer_len;
39:
40: l_offset := l_offset + l_chunk_len;
41: l_length_clob := l_length_clob - l_chunk_len;
42: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
43: end loop;
44:
45: exception
46: when others then