APPS.CSFW_SIGNATURE_PVT dependencies on DBMS_LOB

Line 126: l_signature_size := dbms_lob.getLength(p_file_data);

122: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)
123: VALUES (l_fnd_lobs_id, p_file_name, p_file_type, empty_blob(), SYSDATE, l_language, 'binary')
124: RETURN file_data into l_signature_loc;
125:
126: l_signature_size := dbms_lob.getLength(p_file_data);
127: dbms_lob.read(p_file_data, l_signature_size, 1, l_signature_raw);
128:
129: dbms_lob.write(l_signature_loc, l_signature_size, 1, l_signature_raw);
130:

Line 127: dbms_lob.read(p_file_data, l_signature_size, 1, l_signature_raw);

123: VALUES (l_fnd_lobs_id, p_file_name, p_file_type, empty_blob(), SYSDATE, l_language, 'binary')
124: RETURN file_data into l_signature_loc;
125:
126: l_signature_size := dbms_lob.getLength(p_file_data);
127: dbms_lob.read(p_file_data, l_signature_size, 1, l_signature_raw);
128:
129: dbms_lob.write(l_signature_loc, l_signature_size, 1, l_signature_raw);
130:
131: EXCEPTION

Line 129: dbms_lob.write(l_signature_loc, l_signature_size, 1, l_signature_raw);

125:
126: l_signature_size := dbms_lob.getLength(p_file_data);
127: dbms_lob.read(p_file_data, l_signature_size, 1, l_signature_raw);
128:
129: dbms_lob.write(l_signature_loc, l_signature_size, 1, l_signature_raw);
130:
131: EXCEPTION
132: WHEN OTHERS THEN
133: -- check if the record exists

Line 200: dbms_lob.createtemporary(v_clob, true);

196: begin
197: if p_blob_in is null then
198: return null;
199: end if;
200: dbms_lob.createtemporary(v_clob, true);
201: v_offset := 1;
202: for i in 1 .. ceil(dbms_lob.getlength(p_blob_in) / v_chunk_size) loop
203: dbms_lob.read(p_blob_in, v_chunk_size, v_offset, v_buffer_raw);
204: v_buffer_raw := utl_encode.base64_encode(v_buffer_raw);

Line 202: for i in 1 .. ceil(dbms_lob.getlength(p_blob_in) / v_chunk_size) loop

198: return null;
199: end if;
200: dbms_lob.createtemporary(v_clob, true);
201: v_offset := 1;
202: for i in 1 .. ceil(dbms_lob.getlength(p_blob_in) / v_chunk_size) loop
203: dbms_lob.read(p_blob_in, v_chunk_size, v_offset, v_buffer_raw);
204: v_buffer_raw := utl_encode.base64_encode(v_buffer_raw);
205: v_buffer_varchar := utl_raw.cast_to_varchar2(v_buffer_raw);
206: dbms_lob.writeappend(v_clob, length(v_buffer_varchar), v_buffer_varchar);

Line 203: dbms_lob.read(p_blob_in, v_chunk_size, v_offset, v_buffer_raw);

199: end if;
200: dbms_lob.createtemporary(v_clob, true);
201: v_offset := 1;
202: for i in 1 .. ceil(dbms_lob.getlength(p_blob_in) / v_chunk_size) loop
203: dbms_lob.read(p_blob_in, v_chunk_size, v_offset, v_buffer_raw);
204: v_buffer_raw := utl_encode.base64_encode(v_buffer_raw);
205: v_buffer_varchar := utl_raw.cast_to_varchar2(v_buffer_raw);
206: dbms_lob.writeappend(v_clob, length(v_buffer_varchar), v_buffer_varchar);
207: v_offset := v_offset + v_chunk_size;

Line 206: dbms_lob.writeappend(v_clob, length(v_buffer_varchar), v_buffer_varchar);

202: for i in 1 .. ceil(dbms_lob.getlength(p_blob_in) / v_chunk_size) loop
203: dbms_lob.read(p_blob_in, v_chunk_size, v_offset, v_buffer_raw);
204: v_buffer_raw := utl_encode.base64_encode(v_buffer_raw);
205: v_buffer_varchar := utl_raw.cast_to_varchar2(v_buffer_raw);
206: dbms_lob.writeappend(v_clob, length(v_buffer_varchar), v_buffer_varchar);
207: v_offset := v_offset + v_chunk_size;
208: end loop;
209: v_result := v_clob;
210: dbms_lob.freetemporary(v_clob);

Line 210: dbms_lob.freetemporary(v_clob);

206: dbms_lob.writeappend(v_clob, length(v_buffer_varchar), v_buffer_varchar);
207: v_offset := v_offset + v_chunk_size;
208: end loop;
209: v_result := v_clob;
210: dbms_lob.freetemporary(v_clob);
211: return v_result;
212: end encode_base64;
213:
214: END CSFW_SIGNATURE_PVT;