APPS.EDR_GENERAL_SUBS dependencies on DBMS_LOB

Line 147: wf_log_pkg.string(6, 'UPLOAD_XSL','file size: '||dbms_lob.getlength(l_file_data));

143: --if (l_event_status = 'SUCCESS') then
144: --Bug 3161353: End
145: EDR_FILE_UTIL_PUB.GET_FILE_DATA(l_event_key, l_file_data);
146:
147: wf_log_pkg.string(6, 'UPLOAD_XSL','file size: '||dbms_lob.getlength(l_file_data));
148:
149: --convert the blob data to clob
150: dbms_lob.createtemporary(l_file_data_c,TRUE);
151: l_data_length := dbms_lob.getlength(l_file_data);

Line 150: dbms_lob.createtemporary(l_file_data_c,TRUE);

146:
147: wf_log_pkg.string(6, 'UPLOAD_XSL','file size: '||dbms_lob.getlength(l_file_data));
148:
149: --convert the blob data to clob
150: dbms_lob.createtemporary(l_file_data_c,TRUE);
151: l_data_length := dbms_lob.getlength(l_file_data);
152: l_block_size := ceil(l_data_length/l_kilo);
153: for j in 1..l_block_size
154: loop

Line 151: l_data_length := dbms_lob.getlength(l_file_data);

147: wf_log_pkg.string(6, 'UPLOAD_XSL','file size: '||dbms_lob.getlength(l_file_data));
148:
149: --convert the blob data to clob
150: dbms_lob.createtemporary(l_file_data_c,TRUE);
151: l_data_length := dbms_lob.getlength(l_file_data);
152: l_block_size := ceil(l_data_length/l_kilo);
153: for j in 1..l_block_size
154: loop
155: if (l_kilo*j <= l_data_length) then

Line 160: dbms_lob.read(l_file_data, l_chunk_size, l_offset, l_buffer1);

156: l_chunk_size :=l_kilo;
157: else
158: l_chunk_size :=l_data_length - l_kilo *(j-1);
159: end if;
160: dbms_lob.read(l_file_data, l_chunk_size, l_offset, l_buffer1);
161: l_buffer2 := utl_raw.cast_to_varchar2(l_buffer1);
162: dbms_lob.writeappend(l_file_data_c, l_chunk_size,l_buffer2);
163: l_offset := l_offset + l_kilo;
164: end loop;

Line 162: dbms_lob.writeappend(l_file_data_c, l_chunk_size,l_buffer2);

158: l_chunk_size :=l_data_length - l_kilo *(j-1);
159: end if;
160: dbms_lob.read(l_file_data, l_chunk_size, l_offset, l_buffer1);
161: l_buffer2 := utl_raw.cast_to_varchar2(l_buffer1);
162: dbms_lob.writeappend(l_file_data_c, l_chunk_size,l_buffer2);
163: l_offset := l_offset + l_kilo;
164: end loop;
165:
166: --get the existing version number for the file