APPS.PO_SGD_PKG dependencies on DBMS_LOB

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

40:
41: if l_addr_sql is not null then
42: l_sql := l_addr_sql || l_where_sql;
43:
44: dbms_lob.createtemporary(clob_addr, true);
45: dbms_lob.open(clob_addr, dbms_lob.lob_readwrite);
46: open c_addr for l_sql using p_header_id, p_draft_id, l_attr_grp_id;
47: loop
48: fetch c_addr into l_address;

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

41: if l_addr_sql is not null then
42: l_sql := l_addr_sql || l_where_sql;
43:
44: dbms_lob.createtemporary(clob_addr, true);
45: dbms_lob.open(clob_addr, dbms_lob.lob_readwrite);
46: open c_addr for l_sql using p_header_id, p_draft_id, l_attr_grp_id;
47: loop
48: fetch c_addr into l_address;
49: exit when c_addr%notfound;

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

47: loop
48: fetch c_addr into l_address;
49: exit when c_addr%notfound;
50: if l_address is not null then
51: dbms_lob.writeappend(clob_addr, length(l_address), l_address);
52: end if;
53: end loop;
54: dbms_lob.close(clob_addr);
55: end if;

Line 54: dbms_lob.close(clob_addr);

50: if l_address is not null then
51: dbms_lob.writeappend(clob_addr, length(l_address), l_address);
52: end if;
53: end loop;
54: dbms_lob.close(clob_addr);
55: end if;
56: RETURN(clob_addr);
57: END get_addressxml;
58:

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

97:
98: if l_cnt_sql is not null then
99: l_sql := l_cnt_sql || l_where_sql;
100:
101: dbms_lob.createtemporary(clob_cnt, true);
102: dbms_lob.open(clob_cnt , dbms_lob.lob_readwrite);
103: open c_cnt for l_sql using p_header_id, p_draft_id, l_attr_grp_id;
104: loop
105: fetch c_cnt into l_cnt;

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

98: if l_cnt_sql is not null then
99: l_sql := l_cnt_sql || l_where_sql;
100:
101: dbms_lob.createtemporary(clob_cnt, true);
102: dbms_lob.open(clob_cnt , dbms_lob.lob_readwrite);
103: open c_cnt for l_sql using p_header_id, p_draft_id, l_attr_grp_id;
104: loop
105: fetch c_cnt into l_cnt;
106: exit when c_cnt%notfound;

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

104: loop
105: fetch c_cnt into l_cnt;
106: exit when c_cnt%notfound;
107: if l_cnt is not null then
108: dbms_lob.writeappend(clob_cnt, length(l_cnt), l_cnt);
109: end if;
110: end loop;
111: dbms_lob.close(clob_cnt);
112: end if;

Line 111: dbms_lob.close(clob_cnt);

107: if l_cnt is not null then
108: dbms_lob.writeappend(clob_cnt, length(l_cnt), l_cnt);
109: end if;
110: end loop;
111: dbms_lob.close(clob_cnt);
112: end if;
113: return(clob_cnt);
114: END get_contactsxml;
115: