APPS.PO_XML_UTILS_GRP dependencies on DBMS_LOB

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

17: l_long_text clob;
18: len number;
19:
20: begin
21: dbms_lob.createtemporary(x_attachment_content,TRUE,DBMS_LOB.SESSION);
22:
23: if (p_datatype_id = 1) then /* short_text */
24: select short_text into l_short_text
25: from fnd_documents_short_text

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

24: select short_text into l_short_text
25: from fnd_documents_short_text
26: where media_id = p_media_id;
27: len := length(l_short_text);
28: dbms_lob.write( lob_loc => x_attachment_content,
29: amount => len,
30: offset => 1,
31: buffer => l_short_text);
32:

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

34: select long_text into l_long_text
35: from fnd_documents_long_text
36: where media_id = p_media_id;
37: len := length(l_long_text);
38: dbms_lob.write( lob_loc => x_attachment_content,
39: amount => len,
40: offset => 1,
41: buffer => l_long_text);
42:

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

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

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

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

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

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

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

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