464: l_string := l_string || '
465: l_string := l_string || '';
466:
467: /* Writing XML File */
468: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
469: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
470: dbms_lob.writeAppend( l_xml, length(l_string), l_string);
471: p_xml := l_xml;
472: dbms_lob.freeTemporary(l_xml);
465: l_string := l_string || '';
466:
467: /* Writing XML File */
468: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
469: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
470: dbms_lob.writeAppend( l_xml, length(l_string), l_string);
471: p_xml := l_xml;
472: dbms_lob.freeTemporary(l_xml);
473:
466:
467: /* Writing XML File */
468: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
469: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
470: dbms_lob.writeAppend( l_xml, length(l_string), l_string);
471: p_xml := l_xml;
472: dbms_lob.freeTemporary(l_xml);
473:
474: IF g_debug THEN
468: dbms_lob.createtemporary(l_xml,FALSE,DBMS_LOB.CALL);
469: dbms_lob.open(l_xml,dbms_lob.lob_readwrite);
470: dbms_lob.writeAppend( l_xml, length(l_string), l_string);
471: p_xml := l_xml;
472: dbms_lob.freeTemporary(l_xml);
473:
474: IF g_debug THEN
475: hr_utility.set_location(' Leaving Procedure GENERATE',2);
476: END IF;