eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_PRINT_PVT dependencies on DBMS_XSLPROCESSOR

Line 3839: DBMS_XSLPROCESSOR.CLOB2FILE(l_merged_lob,p_dir,'ORIG-' || x_file_name);

3835: IF (l_log_statement >= l_log_current_level)THEN
3836: fnd_log.string (
3837: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3838: 'Writing ORIG file ');
3839: DBMS_XSLPROCESSOR.CLOB2FILE(l_merged_lob,p_dir,'ORIG-' || x_file_name);
3840: fnd_log.string (
3841: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3842: 'Done Writing ORIG file ');
3843: END IF;

Line 3851: -- DBMS_XSLPROCESSOR.CLOB2FILE(l_merged_lob,p_dir,'ORIG-' || x_file_name);

3847: --post user hook api call
3848:
3849: IF (JTF_USR_HKS.Ok_to_execute('AHL_PRD_PRINT_PVT', 'GENERATE_JCG_XML', 'A', 'C' )) then
3850: -- start to create file
3851: -- DBMS_XSLPROCESSOR.CLOB2FILE(l_merged_lob,p_dir,'ORIG-' || x_file_name);
3852: -- call customer hook here
3853: -- end to create file
3854: IF (l_log_statement >= l_log_current_level)THEN
3855: fnd_log.string (

Line 5034: l_xsl DBMS_XSLPROCESSOR.stylesheet;

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;
5038: l_clob CLOB;

Line 5037: l_proc DBMS_XSLPROCESSOR.processor;

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);
5041: BEGIN

Line 5057: l_xsl := DBMS_XSLPROCESSOR.newStyleSheet(l_xsltdomdoc, '');

5053: l_indomdoc := DBMS_XMLPARSER.getDocument(l_parser);
5054: --DBMS_XMLPARSER.parse(l_parser, p_xsl_full_path);
5055: DBMS_XMLPARSER.parseClob(l_parser, p_xsl_doc);
5056: l_xsltdomdoc := DBMS_XMLPARSER.getDocument(l_parser);
5057: l_xsl := DBMS_XSLPROCESSOR.newStyleSheet(l_xsltdomdoc, '');
5058: l_proc := DBMS_XSLPROCESSOR.newProcessor;
5059:
5060: DBMS_LOB.createTemporary( l_clob, true );
5061: DBMS_LOB.open( l_clob, DBMS_LOB.lob_readwrite );

Line 5058: l_proc := DBMS_XSLPROCESSOR.newProcessor;

5054: --DBMS_XMLPARSER.parse(l_parser, p_xsl_full_path);
5055: DBMS_XMLPARSER.parseClob(l_parser, p_xsl_doc);
5056: l_xsltdomdoc := DBMS_XMLPARSER.getDocument(l_parser);
5057: l_xsl := DBMS_XSLPROCESSOR.newStyleSheet(l_xsltdomdoc, '');
5058: l_proc := DBMS_XSLPROCESSOR.newProcessor;
5059:
5060: DBMS_LOB.createTemporary( l_clob, true );
5061: DBMS_LOB.open( l_clob, DBMS_LOB.lob_readwrite );
5062: DBMS_LOB.write(l_clob,length(l_vchar_header),length(l_clob)+1,l_vchar_header);

Line 5064: --DBMS_XSLPROCESSOR.processXSL(l_proc, l_xsl, l_indomdoc,p_xml_output_dir,p_xml_output_filename);

5060: DBMS_LOB.createTemporary( l_clob, true );
5061: DBMS_LOB.open( l_clob, DBMS_LOB.lob_readwrite );
5062: DBMS_LOB.write(l_clob,length(l_vchar_header),length(l_clob)+1,l_vchar_header);
5063:
5064: --DBMS_XSLPROCESSOR.processXSL(l_proc, l_xsl, l_indomdoc,p_xml_output_dir,p_xml_output_filename);
5065: DBMS_XSLPROCESSOR.processXSL(l_proc, l_xsl, l_indomdoc,l_clob);
5066:
5067: --DBMS_LOB.APPEND(l_clob_header,l_clob);
5068: DBMS_LOB.createTemporary( l_clob_file, true );

Line 5065: DBMS_XSLPROCESSOR.processXSL(l_proc, l_xsl, l_indomdoc,l_clob);

5061: DBMS_LOB.open( l_clob, DBMS_LOB.lob_readwrite );
5062: DBMS_LOB.write(l_clob,length(l_vchar_header),length(l_clob)+1,l_vchar_header);
5063:
5064: --DBMS_XSLPROCESSOR.processXSL(l_proc, l_xsl, l_indomdoc,p_xml_output_dir,p_xml_output_filename);
5065: DBMS_XSLPROCESSOR.processXSL(l_proc, l_xsl, l_indomdoc,l_clob);
5066:
5067: --DBMS_LOB.APPEND(l_clob_header,l_clob);
5068: DBMS_LOB.createTemporary( l_clob_file, true );
5069: DBMS_LOB.open( l_clob_file, DBMS_LOB.lob_readwrite );

Line 5073: DBMS_XSLPROCESSOR.CLOB2FILE(l_clob_file,p_xml_output_dir,p_xml_output_filename);

5069: DBMS_LOB.open( l_clob_file, DBMS_LOB.lob_readwrite );
5070: DBMS_LOB.write(l_clob_file,length(l_vchar_header),length(l_clob_file)+1,l_vchar_header);
5071: DBMS_LOB.copy(l_clob_file,l_clob,4294967295,40,1);
5072:
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);

Line 5080: DBMS_XSLPROCESSOR.freeProcessor(l_proc);

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 (
5083: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'done transformation');
5084: END IF;

Line 5109: l_xsl DBMS_XSLPROCESSOR.stylesheet;

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;
5113: l_clob CLOB;

Line 5112: l_proc DBMS_XSLPROCESSOR.processor;

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);
5116: BEGIN

Line 5132: l_xsl := DBMS_XSLPROCESSOR.newStyleSheet(l_xsltdomdoc, '');

5128: DBMS_XMLPARSER.parse(l_parser,p_xml_input_fullpath);
5129: l_indomdoc := DBMS_XMLPARSER.getDocument(l_parser);
5130: DBMS_XMLPARSER.parseClob(l_parser, p_xsl_doc);
5131: l_xsltdomdoc := DBMS_XMLPARSER.getDocument(l_parser);
5132: l_xsl := DBMS_XSLPROCESSOR.newStyleSheet(l_xsltdomdoc, '');
5133: l_proc := DBMS_XSLPROCESSOR.newProcessor;
5134:
5135: DBMS_LOB.createTemporary( l_clob, true );
5136: DBMS_LOB.open( l_clob, DBMS_LOB.lob_readwrite );

Line 5133: l_proc := DBMS_XSLPROCESSOR.newProcessor;

5129: l_indomdoc := DBMS_XMLPARSER.getDocument(l_parser);
5130: DBMS_XMLPARSER.parseClob(l_parser, p_xsl_doc);
5131: l_xsltdomdoc := DBMS_XMLPARSER.getDocument(l_parser);
5132: l_xsl := DBMS_XSLPROCESSOR.newStyleSheet(l_xsltdomdoc, '');
5133: l_proc := DBMS_XSLPROCESSOR.newProcessor;
5134:
5135: DBMS_LOB.createTemporary( l_clob, true );
5136: DBMS_LOB.open( l_clob, DBMS_LOB.lob_readwrite );
5137: DBMS_LOB.write(l_clob,length(l_vchar_header),length(l_clob)+1,l_vchar_header);

Line 5139: --DBMS_XSLPROCESSOR.processXSL(l_proc, l_xsl, l_indomdoc,p_xml_output_dir,p_xml_output_filename);

5135: DBMS_LOB.createTemporary( l_clob, true );
5136: DBMS_LOB.open( l_clob, DBMS_LOB.lob_readwrite );
5137: DBMS_LOB.write(l_clob,length(l_vchar_header),length(l_clob)+1,l_vchar_header);
5138:
5139: --DBMS_XSLPROCESSOR.processXSL(l_proc, l_xsl, l_indomdoc,p_xml_output_dir,p_xml_output_filename);
5140: DBMS_XSLPROCESSOR.processXSL(l_proc, l_xsl, l_indomdoc,l_clob);
5141:
5142: --DBMS_LOB.APPEND(l_clob_header,l_clob);
5143: DBMS_LOB.createTemporary( l_clob_file, true );

Line 5140: DBMS_XSLPROCESSOR.processXSL(l_proc, l_xsl, l_indomdoc,l_clob);

5136: DBMS_LOB.open( l_clob, DBMS_LOB.lob_readwrite );
5137: DBMS_LOB.write(l_clob,length(l_vchar_header),length(l_clob)+1,l_vchar_header);
5138:
5139: --DBMS_XSLPROCESSOR.processXSL(l_proc, l_xsl, l_indomdoc,p_xml_output_dir,p_xml_output_filename);
5140: DBMS_XSLPROCESSOR.processXSL(l_proc, l_xsl, l_indomdoc,l_clob);
5141:
5142: --DBMS_LOB.APPEND(l_clob_header,l_clob);
5143: DBMS_LOB.createTemporary( l_clob_file, true );
5144: DBMS_LOB.open( l_clob_file, DBMS_LOB.lob_readwrite );

Line 5148: DBMS_XSLPROCESSOR.CLOB2FILE(l_clob_file,p_xml_output_dir,p_xml_output_filename);

5144: DBMS_LOB.open( l_clob_file, DBMS_LOB.lob_readwrite );
5145: DBMS_LOB.write(l_clob_file,length(l_vchar_header),length(l_clob_file)+1,l_vchar_header);
5146: DBMS_LOB.copy(l_clob_file,l_clob,4294967295,40,1);
5147:
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);

Line 5155: DBMS_XSLPROCESSOR.freeProcessor(l_proc);

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 (
5158: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Done transformation');
5159: END IF;