APPS.OKE_PRINT_CONTRACT_WF dependencies on DBMS_LOB

Line 234: dbms_lob.read (l_eventData, l_max_read_amount, 1, l_temp_art_text);-- dbms_lob returns in chars

230: l_eventdata_utf := to_clob('');
231:
232: -- Find the xml declaration ending point.
233: l_max_read_amount := 3333;
234: dbms_lob.read (l_eventData, l_max_read_amount, 1, l_temp_art_text);-- dbms_lob returns in chars
235: l_tag_end_position := InStr(l_temp_art_text,'?>',1);
236: l_read_start_position := l_tag_end_position+2;
237:
238:

Line 240: l_eventData_length := DBMS_LOB.GETLENGTH(l_eventData);

236: l_read_start_position := l_tag_end_position+2;
237:
238:
239: -- Read 3333 bytes from the l_tag_end_position+1 at a stretch and write to the utf clob.
240: l_eventData_length := DBMS_LOB.GETLENGTH(l_eventData);
241: l_amount_left_to_read := l_eventData_length-l_tag_end_position;
242:
243: while (l_amount_left_to_read > 0 ) LOOP
244:

Line 246: dbms_lob.read (l_eventData, l_max_read_amount, l_read_start_position, buf);-- dbms_lob returns in chars

242:
243: while (l_amount_left_to_read > 0 ) LOOP
244:
245: IF l_amount_left_to_read > 3333 THEN
246: dbms_lob.read (l_eventData, l_max_read_amount, l_read_start_position, buf);-- dbms_lob returns in chars
247: l_amount_left_to_read := l_amount_left_to_read-l_max_read_amount;
248: l_read_start_position := l_read_start_position+l_max_read_amount;
249: ELSE
250: dbms_lob.read (l_eventData, l_amount_left_to_read, l_read_start_position, buf);-- dbms_lob returns in chars

Line 250: dbms_lob.read (l_eventData, l_amount_left_to_read, l_read_start_position, buf);-- dbms_lob returns in chars

246: dbms_lob.read (l_eventData, l_max_read_amount, l_read_start_position, buf);-- dbms_lob returns in chars
247: l_amount_left_to_read := l_amount_left_to_read-l_max_read_amount;
248: l_read_start_position := l_read_start_position+l_max_read_amount;
249: ELSE
250: dbms_lob.read (l_eventData, l_amount_left_to_read, l_read_start_position, buf);-- dbms_lob returns in chars
251: l_amount_left_to_read := 0;
252: END IF;
253: dbms_lob.writeappend(l_eventData_utf,Length(buf), buf);
254: END LOOP;

Line 253: dbms_lob.writeappend(l_eventData_utf,Length(buf), buf);

249: ELSE
250: dbms_lob.read (l_eventData, l_amount_left_to_read, l_read_start_position, buf);-- dbms_lob returns in chars
251: l_amount_left_to_read := 0;
252: END IF;
253: dbms_lob.writeappend(l_eventData_utf,Length(buf), buf);
254: END LOOP;
255:
256: return l_eventData_utf;
257: EXCEPTION