APPS.ETRM_SEARCH dependencies on DBMS_LOB

Line 294: lob_bytes_remaining := dbms_lob.getlength(lob_rec.file_data);

290: lob_bytes_remaining number(10);
291:
292: begin
293: for lob_rec in cur_get_lob(n_file_id) loop
294: lob_bytes_remaining := dbms_lob.getlength(lob_rec.file_data);
295: htp.p('Content-type: '||lob_rec.file_content_type);
296: htp.p('Content-Disposition: attachement; filename='||lob_rec.file_name);
297: htp.p('Content-Transfer-Encoding: base64');
298: -- htp.p('Content-Disposition: inline; filename='||lob_rec.file_name);

Line 301: chunksize := dbms_lob.getchunksize(lob_rec.file_data);

297: htp.p('Content-Transfer-Encoding: base64');
298: -- htp.p('Content-Disposition: inline; filename='||lob_rec.file_name);
299: htp.p('');
300:
301: chunksize := dbms_lob.getchunksize(lob_rec.file_data);
302: if (chunksize < 32767) then
303: amount := (32767 / chunksize) * chunksize;
304: end if;
305: dbms_lob.open(lob_rec.file_data, DBMS_LOB.LOB_READONLY);

Line 305: dbms_lob.open(lob_rec.file_data, DBMS_LOB.LOB_READONLY);

301: chunksize := dbms_lob.getchunksize(lob_rec.file_data);
302: if (chunksize < 32767) then
303: amount := (32767 / chunksize) * chunksize;
304: end if;
305: dbms_lob.open(lob_rec.file_data, DBMS_LOB.LOB_READONLY);
306:
307: while (lob_bytes_remaining > 0) loop
308: if (lob_bytes_remaining < amount) then
309: amount := lob_bytes_remaining;

Line 311: dbms_lob.read(lob_rec.file_data, amount, position, buffer);

307: while (lob_bytes_remaining > 0) loop
308: if (lob_bytes_remaining < amount) then
309: amount := lob_bytes_remaining;
310: end if;
311: dbms_lob.read(lob_rec.file_data, amount, position, buffer);
312: htp.prn(utl_raw.cast_to_varchar2(buffer));
313: position := position + amount;
314: lob_bytes_remaining := lob_bytes_remaining - amount;
315: end loop;

Line 316: dbms_lob.close(lob_rec.file_data);

312: htp.prn(utl_raw.cast_to_varchar2(buffer));
313: position := position + amount;
314: lob_bytes_remaining := lob_bytes_remaining - amount;
315: end loop;
316: dbms_lob.close(lob_rec.file_data);
317: end loop;
318: end show_file;
319:
320: