APPS.PO_DATATEMPLATE_PKG dependencies on DBMS_LOB

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

613:
614: if l_addr_sql is not null then
615: l_sql := l_addr_sql || l_where_sql;
616:
617: dbms_lob.createtemporary(clob_addr, true);
618: dbms_lob.open(clob_addr, dbms_lob.lob_readwrite);
619: open c_addr for l_sql using p_header_id, p_draft_id, l_attr_grp_id;
620: loop
621: fetch c_addr into l_address;

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

614: if l_addr_sql is not null then
615: l_sql := l_addr_sql || l_where_sql;
616:
617: dbms_lob.createtemporary(clob_addr, true);
618: dbms_lob.open(clob_addr, dbms_lob.lob_readwrite);
619: open c_addr for l_sql using p_header_id, p_draft_id, l_attr_grp_id;
620: loop
621: fetch c_addr into l_address;
622: exit when c_addr%notfound;

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

620: loop
621: fetch c_addr into l_address;
622: exit when c_addr%notfound;
623: if l_address is not null then
624: dbms_lob.writeappend(clob_addr, length(l_address), l_address);
625: end if;
626: end loop;
627: dbms_lob.close(clob_addr);
628: end if;

Line 627: dbms_lob.close(clob_addr);

623: if l_address is not null then
624: dbms_lob.writeappend(clob_addr, length(l_address), l_address);
625: end if;
626: end loop;
627: dbms_lob.close(clob_addr);
628: end if;
629: end if;
630: return(clob_addr);
631: end get_addressxml_pvt;

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

671:
672: if l_cnt_sql is not null then
673: l_sql := l_cnt_sql || l_where_sql;
674:
675: dbms_lob.createtemporary(clob_cnt, true);
676: dbms_lob.open(clob_cnt , dbms_lob.lob_readwrite);
677: open c_cnt for l_sql using p_header_id, p_draft_id, l_attr_grp_id;
678: loop
679: fetch c_cnt into l_cnt;

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

672: if l_cnt_sql is not null then
673: l_sql := l_cnt_sql || l_where_sql;
674:
675: dbms_lob.createtemporary(clob_cnt, true);
676: dbms_lob.open(clob_cnt , dbms_lob.lob_readwrite);
677: open c_cnt for l_sql using p_header_id, p_draft_id, l_attr_grp_id;
678: loop
679: fetch c_cnt into l_cnt;
680: exit when c_cnt%notfound;

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

678: loop
679: fetch c_cnt into l_cnt;
680: exit when c_cnt%notfound;
681: if l_cnt is not null then
682: dbms_lob.writeappend(clob_cnt, length(l_cnt), l_cnt);
683: end if;
684: end loop;
685: dbms_lob.close(clob_cnt);
686: end if;

Line 685: dbms_lob.close(clob_cnt);

681: if l_cnt is not null then
682: dbms_lob.writeappend(clob_cnt, length(l_cnt), l_cnt);
683: end if;
684: end loop;
685: dbms_lob.close(clob_cnt);
686: end if;
687: return(clob_cnt);
688: end get_contactsxml_pvt;
689: