APPS.UIUTIL dependencies on DBMS_LOB

Line 233: lob_bytes_remaining := dbms_lob.getLength(v_clob);

229:
230: begin
231:
232: v_clob := c_clob;
233: lob_bytes_remaining := dbms_lob.getLength(v_clob);
234: chunksize := dbms_lob.getchunksize(v_clob);
235: if (chunksize < 32767) then
236: amount := (32767 / chunksize) * chunksize;
237: end if;

Line 234: chunksize := dbms_lob.getchunksize(v_clob);

230: begin
231:
232: v_clob := c_clob;
233: lob_bytes_remaining := dbms_lob.getLength(v_clob);
234: chunksize := dbms_lob.getchunksize(v_clob);
235: if (chunksize < 32767) then
236: amount := (32767 / chunksize) * chunksize;
237: end if;
238:

Line 239: dbms_lob.open(v_clob, DBMS_LOB.LOB_READONLY);

235: if (chunksize < 32767) then
236: amount := (32767 / chunksize) * chunksize;
237: end if;
238:
239: dbms_lob.open(v_clob, DBMS_LOB.LOB_READONLY);
240:
241: while (lob_bytes_remaining > 0) loop
242: if (lob_bytes_remaining < amount) then
243: amount := lob_bytes_remaining;

Line 245: dbms_lob.read(v_clob, amount, position, buffer);

241: while (lob_bytes_remaining > 0) loop
242: if (lob_bytes_remaining < amount) then
243: amount := lob_bytes_remaining;
244: end if;
245: dbms_lob.read(v_clob, amount, position, buffer);
246: htp.prn(buffer);
247: position := position + amount;
248: lob_bytes_remaining := lob_bytes_remaining - amount;
249: end loop;

Line 250: dbms_lob.close(v_clob);

246: htp.prn(buffer);
247: position := position + amount;
248: lob_bytes_remaining := lob_bytes_remaining - amount;
249: end loop;
250: dbms_lob.close(v_clob);
251:
252: end clob_prn;
253:
254: procedure cabo1(c_title in varchar2 := 'Oracle eTRM') is