APPS.CSL_LOBS_PKG dependencies on DBMS_LOB

Line 141: l_signature_size := dbms_lob.getLength(p_record.file_data);

137: VALUES (p_record.file_id, 'INTERNAL', 'image/bmp', empty_blob(),
138: SYSDATE, p_record.language, 'binary')
139: RETURN file_data into l_signature_loc;
140:
141: l_signature_size := dbms_lob.getLength(p_record.file_data);
142: dbms_lob.read(p_record.file_data, l_signature_size, 1, l_signature_raw);
143:
144: dbms_lob.write(l_signature_loc, l_signature_size, 1, l_signature_raw);
145: EXCEPTION

Line 142: dbms_lob.read(p_record.file_data, l_signature_size, 1, l_signature_raw);

138: SYSDATE, p_record.language, 'binary')
139: RETURN file_data into l_signature_loc;
140:
141: l_signature_size := dbms_lob.getLength(p_record.file_data);
142: dbms_lob.read(p_record.file_data, l_signature_size, 1, l_signature_raw);
143:
144: dbms_lob.write(l_signature_loc, l_signature_size, 1, l_signature_raw);
145: EXCEPTION
146: WHEN OTHERS THEN

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

140:
141: l_signature_size := dbms_lob.getLength(p_record.file_data);
142: dbms_lob.read(p_record.file_data, l_signature_size, 1, l_signature_raw);
143:
144: dbms_lob.write(l_signature_loc, l_signature_size, 1, l_signature_raw);
145: EXCEPTION
146: WHEN OTHERS THEN
147: -- check if the record exists
148: open l_lobs_fileid_csr(p_record.file_id) ;