APPS.PON_DATATEMPLATE_PKG dependencies on DBMS_LOB

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

340:
341: if l_addr_sql is not null then
342: l_sql := l_addr_sql || l_where_sql;
343:
344: dbms_lob.createtemporary(clob_addr, true);
345: dbms_lob.open(clob_addr, dbms_lob.lob_readwrite);
346: open c_addr for l_sql using p_header_id,l_attr_grp_id;
347: loop
348: fetch c_addr into l_address;

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

341: if l_addr_sql is not null then
342: l_sql := l_addr_sql || l_where_sql;
343:
344: dbms_lob.createtemporary(clob_addr, true);
345: dbms_lob.open(clob_addr, dbms_lob.lob_readwrite);
346: open c_addr for l_sql using p_header_id,l_attr_grp_id;
347: loop
348: fetch c_addr into l_address;
349: exit when c_addr%notfound;

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

347: loop
348: fetch c_addr into l_address;
349: exit when c_addr%notfound;
350: if l_address is not null then
351: dbms_lob.writeappend(clob_addr, length(l_address), l_address);
352: end if;
353: end loop;
354: dbms_lob.close(clob_addr);
355: end if;

Line 354: dbms_lob.close(clob_addr);

350: if l_address is not null then
351: dbms_lob.writeappend(clob_addr, length(l_address), l_address);
352: end if;
353: end loop;
354: dbms_lob.close(clob_addr);
355: end if;
356: return(clob_addr);
357: end get_addressxml_pvt;
358:

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

396:
397: if l_cnt_sql is not null then
398: l_sql := l_cnt_sql || l_where_sql;
399:
400: dbms_lob.createtemporary(clob_cnt, true);
401: dbms_lob.open(clob_cnt , dbms_lob.lob_readwrite);
402: open c_cnt for l_sql using p_header_id,l_attr_grp_id;
403: loop
404: fetch c_cnt into l_cnt;

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

397: if l_cnt_sql is not null then
398: l_sql := l_cnt_sql || l_where_sql;
399:
400: dbms_lob.createtemporary(clob_cnt, true);
401: dbms_lob.open(clob_cnt , dbms_lob.lob_readwrite);
402: open c_cnt for l_sql using p_header_id,l_attr_grp_id;
403: loop
404: fetch c_cnt into l_cnt;
405: exit when c_cnt%notfound;

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

403: loop
404: fetch c_cnt into l_cnt;
405: exit when c_cnt%notfound;
406: if l_cnt is not null then
407: dbms_lob.writeappend(clob_cnt, length(l_cnt), l_cnt);
408: end if;
409: end loop;
410: dbms_lob.close(clob_cnt);
411: end if;

Line 410: dbms_lob.close(clob_cnt);

406: if l_cnt is not null then
407: dbms_lob.writeappend(clob_cnt, length(l_cnt), l_cnt);
408: end if;
409: end loop;
410: dbms_lob.close(clob_cnt);
411: end if;
412: return(clob_cnt);
413: end get_contactsxml_pvt;
414: