APPS.PO_XML_UTILS_GRP dependencies on DBMS_LOB

Line 13: dbms_lob.createtemporary(x_attachment_content,TRUE,DBMS_LOB.SESSION);

9: l_long_text long;
10: len number;
11:
12: begin
13: dbms_lob.createtemporary(x_attachment_content,TRUE,DBMS_LOB.SESSION);
14:
15: if (p_datatype_id = 1) then /* short_text */
16: select short_text into l_short_text
17: from fnd_documents_short_text

Line 20: dbms_lob.write( lob_loc => x_attachment_content,

16: select short_text into l_short_text
17: from fnd_documents_short_text
18: where media_id = p_media_id;
19: len := length(l_short_text);
20: dbms_lob.write( lob_loc => x_attachment_content,
21: amount => len,
22: offset => 1,
23: buffer => l_short_text);
24:

Line 30: dbms_lob.write( lob_loc => x_attachment_content,

26: select long_text into l_long_text
27: from fnd_documents_long_text
28: where media_id = p_media_id;
29: len := length(l_long_text);
30: dbms_lob.write( lob_loc => x_attachment_content,
31: amount => len,
32: offset => 1,
33: buffer => l_long_text);
34:

Line 177: dbms_lob.createtemporary(x_TandCcontent,TRUE,DBMS_LOB.SESSION);

173: end;
174: END;
175: END;
176:
177: dbms_lob.createtemporary(x_TandCcontent,TRUE,DBMS_LOB.SESSION);
178:
179: /* Read the file line by line and append it to CLOB */
180: if (UTL_FILE.is_open(v_filehandle) = true) then
181: loop

Line 189: dbms_lob.write(x_TandCcontent,length(l_terms),voffset,l_terms);

185: if (l_terms is null) then
186: l_terms := ' ';
187: end if;
188: l_terms := l_terms||l_newline; --bug#4278861: Appended the new line to the line read from file
189: dbms_lob.write(x_TandCcontent,length(l_terms),voffset,l_terms);
190: voffset := voffset + length(l_terms);
191:
192: --bug#4278861: Commented the code as it adds extra space to the output dbms_lob
193: --l_terms := ' ';

Line 192: --bug#4278861: Commented the code as it adds extra space to the output dbms_lob

188: l_terms := l_terms||l_newline; --bug#4278861: Appended the new line to the line read from file
189: dbms_lob.write(x_TandCcontent,length(l_terms),voffset,l_terms);
190: voffset := voffset + length(l_terms);
191:
192: --bug#4278861: Commented the code as it adds extra space to the output dbms_lob
193: --l_terms := ' ';
194: --dbms_lob.write(x_TandCcontent,length(l_terms),voffset,l_terms);
195: --voffset := voffset + length(l_terms);
196:

Line 194: --dbms_lob.write(x_TandCcontent,length(l_terms),voffset,l_terms);

190: voffset := voffset + length(l_terms);
191:
192: --bug#4278861: Commented the code as it adds extra space to the output dbms_lob
193: --l_terms := ' ';
194: --dbms_lob.write(x_TandCcontent,length(l_terms),voffset,l_terms);
195: --voffset := voffset + length(l_terms);
196:
197:
198: exception when no_data_found then