APPS.PO_XML_FPDSNG_PKG dependencies on DBMS_LOB

Line 281: dbms_lob.createtemporary(clob_addr, true);

277:
278: if l_addr_sql is not null then
279: l_sql := l_addr_sql || l_where_sql;
280:
281: dbms_lob.createtemporary(clob_addr, true);
282: dbms_lob.open(clob_addr, dbms_lob.lob_readwrite);
283: open c_addr for l_sql using p_header_id, p_draft_id, l_attr_grp_id;
284: loop
285: fetch c_addr into l_address;

Line 282: dbms_lob.open(clob_addr, dbms_lob.lob_readwrite);

278: if l_addr_sql is not null then
279: l_sql := l_addr_sql || l_where_sql;
280:
281: dbms_lob.createtemporary(clob_addr, true);
282: dbms_lob.open(clob_addr, dbms_lob.lob_readwrite);
283: open c_addr for l_sql using p_header_id, p_draft_id, l_attr_grp_id;
284: loop
285: fetch c_addr into l_address;
286: exit when c_addr%notfound;

Line 288: dbms_lob.writeappend(clob_addr, length(l_address), l_address);

284: loop
285: fetch c_addr into l_address;
286: exit when c_addr%notfound;
287: if l_address is not null then
288: dbms_lob.writeappend(clob_addr, length(l_address), l_address);
289: end if;
290: end loop;
291: dbms_lob.close(clob_addr);
292: end if;

Line 291: dbms_lob.close(clob_addr);

287: if l_address is not null then
288: dbms_lob.writeappend(clob_addr, length(l_address), l_address);
289: end if;
290: end loop;
291: dbms_lob.close(clob_addr);
292: end if;
293: return(clob_addr);
294: end get_addressxml_pvt;
295:

Line 338: dbms_lob.createtemporary(clob_cnt, true);

334:
335: if l_cnt_sql is not null then
336: l_sql := l_cnt_sql || l_where_sql;
337:
338: dbms_lob.createtemporary(clob_cnt, true);
339: dbms_lob.open(clob_cnt , dbms_lob.lob_readwrite);
340: open c_cnt for l_sql using p_header_id, p_draft_id, l_attr_grp_id;
341: loop
342: fetch c_cnt into l_cnt;

Line 339: dbms_lob.open(clob_cnt , dbms_lob.lob_readwrite);

335: if l_cnt_sql is not null then
336: l_sql := l_cnt_sql || l_where_sql;
337:
338: dbms_lob.createtemporary(clob_cnt, true);
339: dbms_lob.open(clob_cnt , dbms_lob.lob_readwrite);
340: open c_cnt for l_sql using p_header_id, p_draft_id, l_attr_grp_id;
341: loop
342: fetch c_cnt into l_cnt;
343: exit when c_cnt%notfound;

Line 345: dbms_lob.writeappend(clob_cnt, length(l_cnt), l_cnt);

341: loop
342: fetch c_cnt into l_cnt;
343: exit when c_cnt%notfound;
344: if l_cnt is not null then
345: dbms_lob.writeappend(clob_cnt, length(l_cnt), l_cnt);
346: end if;
347: end loop;
348: dbms_lob.close(clob_cnt);
349: end if;

Line 348: dbms_lob.close(clob_cnt);

344: if l_cnt is not null then
345: dbms_lob.writeappend(clob_cnt, length(l_cnt), l_cnt);
346: end if;
347: end loop;
348: dbms_lob.close(clob_cnt);
349: end if;
350: return(clob_cnt);
351: end get_contactsxml_pvt;
352: