9: l_query varchar2(32767);
10: l_jpp_doc CLOB;
11: lv_stylesheet varchar2(32767);
12: l_stylesheet_url varchar2(2000);
13: stylesheetdoc xmldom.DOMDocument;
14: stylesheet xslprocessor.Stylesheet;
15: engine xslprocessor.Processor;
16: parser xmlparser.parser;
17: xmldoc xmldom.DOMDocument;
13: stylesheetdoc xmldom.DOMDocument;
14: stylesheet xslprocessor.Stylesheet;
15: engine xslprocessor.Processor;
16: parser xmlparser.parser;
17: xmldoc xmldom.DOMDocument;
18: clobdoc CLOB;
19: ctx DBMS_XMLQUERY.ctxType;
20: tv_sheet utl_http.html_pieces;
21: l_index number;
513: xslprocessor.processXSL(engine,stylesheet,xmldoc,l_jpp_doc);
514: l_jpp_doc:=dbms_xmlgen.convert(l_jpp_doc,1);
515: xmlParser.freeParser(parser);
516: xslprocessor.freeProcessor(engine);
517: xmldom.freeDocument(xmldoc);
518: xmldom.freeDocument(stylesheetdoc);
519: p_jpp_doc:=l_jpp_doc;
520: -- p_jpp_doc:=clobdoc;
521: -- dbms_lob.write(p_jpp_doc,length(lv_stylesheet),1,lv_stylesheet);
514: l_jpp_doc:=dbms_xmlgen.convert(l_jpp_doc,1);
515: xmlParser.freeParser(parser);
516: xslprocessor.freeProcessor(engine);
517: xmldom.freeDocument(xmldoc);
518: xmldom.freeDocument(stylesheetdoc);
519: p_jpp_doc:=l_jpp_doc;
520: -- p_jpp_doc:=clobdoc;
521: -- dbms_lob.write(p_jpp_doc,length(lv_stylesheet),1,lv_stylesheet);
522: exception when others then
520: -- p_jpp_doc:=clobdoc;
521: -- dbms_lob.write(p_jpp_doc,length(lv_stylesheet),1,lv_stylesheet);
522: exception when others then
523: xslprocessor.freeProcessor(engine);
524: xmldom.freeDocument(xmldoc);
525: xmldom.freeDocument(stylesheetdoc);
526: raise;
527: end generateJPPint;
528: --
521: -- dbms_lob.write(p_jpp_doc,length(lv_stylesheet),1,lv_stylesheet);
522: exception when others then
523: xslprocessor.freeProcessor(engine);
524: xmldom.freeDocument(xmldoc);
525: xmldom.freeDocument(stylesheetdoc);
526: raise;
527: end generateJPPint;
528: --
529: function generateJPP(p_recruitment_activity_id in number