APPS.CSFW_ATTACHMENT_PVT dependencies on DBMS_LOB

Line 121: l_attachment_size := dbms_lob.getLength(p_file_data);

117: INSERT INTO fnd_lobs(file_id, file_name, file_content_type, file_data, upload_date, language, file_format)
118: VALUES (l_fnd_lobs_id, p_file_name, p_file_content_type, empty_blob(), SYSDATE, l_language, 'binary')
119: RETURN file_data into l_attachment_loc;
120:
121: l_attachment_size := dbms_lob.getLength(p_file_data);
122: --insert into shakti_audit(msg) values('File size : '|| l_attachment_size);
123:
124: l_rw_offset := 1;
125: while (l_attachment_size > 0) loop

Line 134: dbms_lob.read(p_file_data, l_rw_amount, l_rw_offset, l_attachment_raw);

130: end if;
131: l_attachment_size := l_attachment_size - l_rw_amount;
132: --insert into shakti_audit(msg) values('New attachment size : '|| l_attachment_size);
133:
134: dbms_lob.read(p_file_data, l_rw_amount, l_rw_offset, l_attachment_raw);
135: --insert into shakti_audit(msg) values('Read complete');
136:
137: dbms_lob.write(l_attachment_loc, l_rw_amount, l_rw_offset, l_attachment_raw);
138: --insert into shakti_audit(msg) values('Write complete');

Line 137: dbms_lob.write(l_attachment_loc, l_rw_amount, l_rw_offset, l_attachment_raw);

133:
134: dbms_lob.read(p_file_data, l_rw_amount, l_rw_offset, l_attachment_raw);
135: --insert into shakti_audit(msg) values('Read complete');
136:
137: dbms_lob.write(l_attachment_loc, l_rw_amount, l_rw_offset, l_attachment_raw);
138: --insert into shakti_audit(msg) values('Write complete');
139:
140: l_rw_offset := l_rw_offset + 32767;
141: --insert into shakti_audit(msg) values('New offset : '|| l_rw_offset);