APPS.ECX_DIAGNOSTICS_TEST dependencies on DBMS_LOB

Line 458: dbms_lob.createtemporary(v_out,false,dbms_lob.session);

454: l_xsl := l_xsl || '';
455: l_xml_clob := l_xml;
456: l_xsl_clob := l_xsl;
457: p_xdkversion:= ecx_utils.xmlversion;
458: dbms_lob.createtemporary(v_out,false,dbms_lob.session);
459: -- parse and get ge DOMDocument from xml
460: v_parser_xml := xmlparser.newparser;
461: xmlparser.setvalidationmode(v_parser_xml, false);
462: xmlparser.parseclob(v_parser_xml,l_xml_clob);

Line 479: if trim(dbms_lob.substr(v_out,235,1))= expected_output then

475: -- process xsl
476: v_processor := xslprocessor.newprocessor;
477: --one way [will not escape any characters] $ as $
478: xslprocessor.processxsl(v_processor, v_stylesheet, v_xmldoc,v_out);
479: if trim(dbms_lob.substr(v_out,235,1))= expected_output then
480: p_result := 'TRUE';
481: else
482: p_result:= 'FALSE';
483: end if;

Line 491: dbms_lob.freetemporary(v_out);

487: xmldom.freedocument(v_xmldoc_xsl);
488: xmlparser.freeparser(v_parser_xsl);
489: xmldom.freedocument(v_xmldoc);
490: xmlparser.freeparser(v_parser_xml);
491: dbms_lob.freetemporary(v_out);
492: --p_result:= 'TRUE';
493: exception
494: when others then
495: p_result := 'FALSE';