DBA Data[Home] [Help]

APPS.AHL_PRD_PRINT_PVT dependencies on DBMS_XMLDOM

Line 4943: l_indomdoc DBMS_XMLDOM.DOMDocument;

4939: len2 NUMBER;
4940: n XMLDOM.DOMNODE;
4941: e XMLDOM.DOMELEMENT;
4942: l_parser DBMS_XMLPARSER.parser;
4943: l_indomdoc DBMS_XMLDOM.DOMDocument;
4944: l_pdf_rec PDF_REC_TYPE;
4945: l_index INTEGER;
4946: l_node_name VARCHAR2(2000);
4947: l_parse_jobcards BOOLEAN;

Line 5017: DBMS_XMLDOM.freeDocument(l_indomdoc);

5013: l_pdf_rec.status := xmldom.getNodeValue(xmldom.getFirstChild(n));
5014: x_pdf_table(l_index) := l_pdf_rec;
5015: END IF;
5016: END LOOP;
5017: DBMS_XMLDOM.freeDocument(l_indomdoc);
5018: DBMS_XMLPARSER.freeParser(l_parser);
5019: END parse_enigma_response;
5020:
5021: PROCEDURE APPLY_TRANSFORMATION(

Line 5032: l_indomdoc DBMS_XMLDOM.DOMDocument;

5028: x_msg_count OUT NOCOPY NUMBER,
5029: x_msg_data OUT NOCOPY VARCHAR2
5030: )IS
5031: l_parser DBMS_XMLPARSER.parser;
5032: l_indomdoc DBMS_XMLDOM.DOMDocument;
5033: l_xsltdomdoc DBMS_XMLDOM.DOMDocument;
5034: l_xsl DBMS_XSLPROCESSOR.stylesheet;
5035: l_outdomdocf DBMS_XMLDOM.DOMDocumentFragment;
5036: l_outnode DBMS_XMLDOM.DOMNode;

Line 5033: l_xsltdomdoc DBMS_XMLDOM.DOMDocument;

5029: x_msg_data OUT NOCOPY VARCHAR2
5030: )IS
5031: l_parser DBMS_XMLPARSER.parser;
5032: l_indomdoc DBMS_XMLDOM.DOMDocument;
5033: l_xsltdomdoc DBMS_XMLDOM.DOMDocument;
5034: l_xsl DBMS_XSLPROCESSOR.stylesheet;
5035: l_outdomdocf DBMS_XMLDOM.DOMDocumentFragment;
5036: l_outnode DBMS_XMLDOM.DOMNode;
5037: l_proc DBMS_XSLPROCESSOR.processor;

Line 5035: l_outdomdocf DBMS_XMLDOM.DOMDocumentFragment;

5031: l_parser DBMS_XMLPARSER.parser;
5032: l_indomdoc DBMS_XMLDOM.DOMDocument;
5033: l_xsltdomdoc DBMS_XMLDOM.DOMDocument;
5034: l_xsl DBMS_XSLPROCESSOR.stylesheet;
5035: l_outdomdocf DBMS_XMLDOM.DOMDocumentFragment;
5036: l_outnode DBMS_XMLDOM.DOMNode;
5037: l_proc DBMS_XSLPROCESSOR.processor;
5038: l_clob CLOB;
5039: l_clob_file CLOB;

Line 5036: l_outnode DBMS_XMLDOM.DOMNode;

5032: l_indomdoc DBMS_XMLDOM.DOMDocument;
5033: l_xsltdomdoc DBMS_XMLDOM.DOMDocument;
5034: l_xsl DBMS_XSLPROCESSOR.stylesheet;
5035: l_outdomdocf DBMS_XMLDOM.DOMDocumentFragment;
5036: l_outnode DBMS_XMLDOM.DOMNode;
5037: l_proc DBMS_XSLPROCESSOR.processor;
5038: l_clob CLOB;
5039: l_clob_file CLOB;
5040: l_vchar_header VARCHAR2(40);

Line 5077: DBMS_XMLDOM.freeDocument(l_indomdoc);

5073: DBMS_XSLPROCESSOR.CLOB2FILE(l_clob_file,p_xml_output_dir,p_xml_output_filename);
5074:
5075: DBMS_LOB.close(l_clob_file);
5076: DBMS_LOB.close(l_clob);
5077: DBMS_XMLDOM.freeDocument(l_indomdoc);
5078: DBMS_XMLDOM.freeDocument(l_xsltdomdoc);
5079: DBMS_XMLPARSER.freeParser(l_parser);
5080: DBMS_XSLPROCESSOR.freeProcessor(l_proc);
5081: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 5078: DBMS_XMLDOM.freeDocument(l_xsltdomdoc);

5074:
5075: DBMS_LOB.close(l_clob_file);
5076: DBMS_LOB.close(l_clob);
5077: DBMS_XMLDOM.freeDocument(l_indomdoc);
5078: DBMS_XMLDOM.freeDocument(l_xsltdomdoc);
5079: DBMS_XMLPARSER.freeParser(l_parser);
5080: DBMS_XSLPROCESSOR.freeProcessor(l_proc);
5081: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5082: fnd_log.string (

Line 5107: l_indomdoc DBMS_XMLDOM.DOMDocument;

5103: x_msg_count OUT NOCOPY NUMBER,
5104: x_msg_data OUT NOCOPY VARCHAR2
5105: )IS
5106: l_parser DBMS_XMLPARSER.parser;
5107: l_indomdoc DBMS_XMLDOM.DOMDocument;
5108: l_xsltdomdoc DBMS_XMLDOM.DOMDocument;
5109: l_xsl DBMS_XSLPROCESSOR.stylesheet;
5110: l_outdomdocf DBMS_XMLDOM.DOMDocumentFragment;
5111: l_outnode DBMS_XMLDOM.DOMNode;

Line 5108: l_xsltdomdoc DBMS_XMLDOM.DOMDocument;

5104: x_msg_data OUT NOCOPY VARCHAR2
5105: )IS
5106: l_parser DBMS_XMLPARSER.parser;
5107: l_indomdoc DBMS_XMLDOM.DOMDocument;
5108: l_xsltdomdoc DBMS_XMLDOM.DOMDocument;
5109: l_xsl DBMS_XSLPROCESSOR.stylesheet;
5110: l_outdomdocf DBMS_XMLDOM.DOMDocumentFragment;
5111: l_outnode DBMS_XMLDOM.DOMNode;
5112: l_proc DBMS_XSLPROCESSOR.processor;

Line 5110: l_outdomdocf DBMS_XMLDOM.DOMDocumentFragment;

5106: l_parser DBMS_XMLPARSER.parser;
5107: l_indomdoc DBMS_XMLDOM.DOMDocument;
5108: l_xsltdomdoc DBMS_XMLDOM.DOMDocument;
5109: l_xsl DBMS_XSLPROCESSOR.stylesheet;
5110: l_outdomdocf DBMS_XMLDOM.DOMDocumentFragment;
5111: l_outnode DBMS_XMLDOM.DOMNode;
5112: l_proc DBMS_XSLPROCESSOR.processor;
5113: l_clob CLOB;
5114: l_clob_file CLOB;

Line 5111: l_outnode DBMS_XMLDOM.DOMNode;

5107: l_indomdoc DBMS_XMLDOM.DOMDocument;
5108: l_xsltdomdoc DBMS_XMLDOM.DOMDocument;
5109: l_xsl DBMS_XSLPROCESSOR.stylesheet;
5110: l_outdomdocf DBMS_XMLDOM.DOMDocumentFragment;
5111: l_outnode DBMS_XMLDOM.DOMNode;
5112: l_proc DBMS_XSLPROCESSOR.processor;
5113: l_clob CLOB;
5114: l_clob_file CLOB;
5115: l_vchar_header VARCHAR2(40);

Line 5152: DBMS_XMLDOM.freeDocument(l_indomdoc);

5148: DBMS_XSLPROCESSOR.CLOB2FILE(l_clob_file,p_xml_output_dir,p_xml_output_filename);
5149:
5150: DBMS_LOB.close(l_clob_file);
5151: DBMS_LOB.close(l_clob);
5152: DBMS_XMLDOM.freeDocument(l_indomdoc);
5153: DBMS_XMLDOM.freeDocument(l_xsltdomdoc);
5154: DBMS_XMLPARSER.freeParser(l_parser);
5155: DBMS_XSLPROCESSOR.freeProcessor(l_proc);
5156: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 5153: DBMS_XMLDOM.freeDocument(l_xsltdomdoc);

5149:
5150: DBMS_LOB.close(l_clob_file);
5151: DBMS_LOB.close(l_clob);
5152: DBMS_XMLDOM.freeDocument(l_indomdoc);
5153: DBMS_XMLDOM.freeDocument(l_xsltdomdoc);
5154: DBMS_XMLPARSER.freeParser(l_parser);
5155: DBMS_XSLPROCESSOR.freeProcessor(l_proc);
5156: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5157: fnd_log.string (