335: DBMS_LOB.erase (l_xml_temp, l_offset,1);
336:
337: l_stmt_num := 100;
338: /*The following 3 lines of code ensures that XML data generated here uses the right encoding*/
339: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
340: l_xml_header := '';
341: DBMS_LOB.writeappend (x_xml_doc, length(l_xml_header), l_xml_header);
342:
343: -- append the REPORT tag to XML