8: l_query varchar2(32767);
9: l_jpp_doc CLOB;
10: lv_stylesheet varchar2(32767);
11: l_stylesheet_url varchar2(2000);
12: stylesheetdoc xmldom.DOMDocument;
13: stylesheet xslprocessor.Stylesheet;
14: engine xslprocessor.Processor;
15: parser xmlparser.parser;
16: xmldoc xmldom.DOMDocument;
12: stylesheetdoc xmldom.DOMDocument;
13: stylesheet xslprocessor.Stylesheet;
14: engine xslprocessor.Processor;
15: parser xmlparser.parser;
16: xmldoc xmldom.DOMDocument;
17: clobdoc CLOB;
18: ctx DBMS_XMLQUERY.ctxType;
19: tv_sheet utl_http.html_pieces;
20: l_index number;
456: xslprocessor.processXSL(engine,stylesheet,xmldoc,l_jpp_doc);
457: l_jpp_doc:=dbms_xmlgen.convert(l_jpp_doc,1);
458: xmlParser.freeParser(parser);
459: xslprocessor.freeProcessor(engine);
460: xmldom.freeDocument(xmldoc);
461: xmldom.freeDocument(stylesheetdoc);
462: p_jpp_doc:=l_jpp_doc;
463: -- p_jpp_doc:=clobdoc;
464: -- dbms_lob.write(p_jpp_doc,length(lv_stylesheet),1,lv_stylesheet);
457: l_jpp_doc:=dbms_xmlgen.convert(l_jpp_doc,1);
458: xmlParser.freeParser(parser);
459: xslprocessor.freeProcessor(engine);
460: xmldom.freeDocument(xmldoc);
461: xmldom.freeDocument(stylesheetdoc);
462: p_jpp_doc:=l_jpp_doc;
463: -- p_jpp_doc:=clobdoc;
464: -- dbms_lob.write(p_jpp_doc,length(lv_stylesheet),1,lv_stylesheet);
465: exception when others then
463: -- p_jpp_doc:=clobdoc;
464: -- dbms_lob.write(p_jpp_doc,length(lv_stylesheet),1,lv_stylesheet);
465: exception when others then
466: xslprocessor.freeProcessor(engine);
467: xmldom.freeDocument(xmldoc);
468: xmldom.freeDocument(stylesheetdoc);
469: raise;
470: end generateJPPint;
471: --
464: -- dbms_lob.write(p_jpp_doc,length(lv_stylesheet),1,lv_stylesheet);
465: exception when others then
466: xslprocessor.freeProcessor(engine);
467: xmldom.freeDocument(xmldoc);
468: xmldom.freeDocument(stylesheetdoc);
469: raise;
470: end generateJPPint;
471: --
472: function generateJPP(p_recruitment_activity_id in number