DBA Data[Home] [Help]

APPS.IRC_JPS_GENERATOR dependencies on XMLDOM

Line 13: stylesheetdoc xmldom.DOMDocument;

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

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

Line 396: xmldom.freeDocument(stylesheetdoc);

392: hr_utility.set_location('Parsing the stylesheet',24);
393: xslprocessor.processXSL(engine,stylesheet,xmldoc,l_formatted_doc);
394: hr_utility.set_location('Parsing Sucess. Freeing parser',25);
395: xslprocessor.freeStylesheet(stylesheet);
396: xmldom.freeDocument(stylesheetdoc);
397: xmlParser.freeParser(parser);
398: xslprocessor.freeProcessor(engine);
399: xmldom.freeDocument(xmldoc);
400: p_raw_doc:=clobdoc;

Line 399: xmldom.freeDocument(xmldoc);

395: xslprocessor.freeStylesheet(stylesheet);
396: xmldom.freeDocument(stylesheetdoc);
397: xmlParser.freeParser(parser);
398: xslprocessor.freeProcessor(engine);
399: xmldom.freeDocument(xmldoc);
400: p_raw_doc:=clobdoc;
401:
402: if(p_stylesheet is null and substr(l_formatted_doc,0,5)<> ' 403: l_formatted_doc :='

Line 417: xmldom.freeDocument(xmldoc);

413: hr_utility.set_location('Exception: '||sqlcode,29);
414: xmlParser.freeParser(parser);
415: xslprocessor.freeProcessor(engine);
416: xslprocessor.freeStylesheet(stylesheet);
417: xmldom.freeDocument(xmldoc);
418: xmldom.freeDocument(stylesheetdoc);
419: raise;
420: end generateJPSint;
421: --

Line 418: xmldom.freeDocument(stylesheetdoc);

414: xmlParser.freeParser(parser);
415: xslprocessor.freeProcessor(engine);
416: xslprocessor.freeStylesheet(stylesheet);
417: xmldom.freeDocument(xmldoc);
418: xmldom.freeDocument(stylesheetdoc);
419: raise;
420: end generateJPSint;
421: --
422: function generateJPS(p_person_id in number