DBA Data[Home] [Help]

APPS.IRC_JPS_GENERATOR dependencies on XMLDOM

Line 12: stylesheetdoc xmldom.DOMDocument;

8: l_query varchar2(32767);
9: l_formatted_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;

Line 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;

Line 391: xmldom.freeDocument(stylesheetdoc);

387: hr_utility.set_location('Parsing the stylesheet',24);
388: xslprocessor.processXSL(engine,stylesheet,xmldoc,l_formatted_doc);
389: hr_utility.set_location('Parsing Sucess. Freeing parser',25);
390: xslprocessor.freeStylesheet(stylesheet);
391: xmldom.freeDocument(stylesheetdoc);
392: xmlParser.freeParser(parser);
393: xslprocessor.freeProcessor(engine);
394: xmldom.freeDocument(xmldoc);
395: p_raw_doc:=clobdoc;

Line 394: xmldom.freeDocument(xmldoc);

390: xslprocessor.freeStylesheet(stylesheet);
391: xmldom.freeDocument(stylesheetdoc);
392: xmlParser.freeParser(parser);
393: xslprocessor.freeProcessor(engine);
394: xmldom.freeDocument(xmldoc);
395: p_raw_doc:=clobdoc;
396:
397: if(p_stylesheet is null and substr(l_formatted_doc,0,5)<> ' 398: l_formatted_doc :='

Line 412: xmldom.freeDocument(xmldoc);

408: hr_utility.set_location('Exception: '||sqlcode,29);
409: xmlParser.freeParser(parser);
410: xslprocessor.freeProcessor(engine);
411: xslprocessor.freeStylesheet(stylesheet);
412: xmldom.freeDocument(xmldoc);
413: xmldom.freeDocument(stylesheetdoc);
414: raise;
415: end generateJPSint;
416: --

Line 413: xmldom.freeDocument(stylesheetdoc);

409: xmlParser.freeParser(parser);
410: xslprocessor.freeProcessor(engine);
411: xslprocessor.freeStylesheet(stylesheet);
412: xmldom.freeDocument(xmldoc);
413: xmldom.freeDocument(stylesheetdoc);
414: raise;
415: end generateJPSint;
416: --
417: function generateJPS(p_person_id in number