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.CSM_HTML5_PKG dependencies on DBMS_XMLDOM

Line 2707: l_sec_node dbms_xmldom.domnode;

2703: L_NODE_NAME VARCHAR2(300);
2704: L_NODE_VALUE VARCHAR2(300);
2705: L_PIV_NAME VARCHAR2(300);
2706: L_DML_TYPE VARCHAR2(3);
2707: l_sec_node dbms_xmldom.domnode;
2708: L_SEC_LST DBMS_XMLDOM.DOMNODELIST;
2709: l_first_node dbms_xmldom.domnode;
2710: L_FIRST_LST DBMS_XMLDOM.DOMNODELIST;
2711: L_FIRST_LEN NUMBER;

Line 2708: L_SEC_LST DBMS_XMLDOM.DOMNODELIST;

2704: L_NODE_VALUE VARCHAR2(300);
2705: L_PIV_NAME VARCHAR2(300);
2706: L_DML_TYPE VARCHAR2(3);
2707: l_sec_node dbms_xmldom.domnode;
2708: L_SEC_LST DBMS_XMLDOM.DOMNODELIST;
2709: l_first_node dbms_xmldom.domnode;
2710: L_FIRST_LST DBMS_XMLDOM.DOMNODELIST;
2711: L_FIRST_LEN NUMBER;
2712: L_INQ_TABLE_NAME VARCHAR2(256);

Line 2709: l_first_node dbms_xmldom.domnode;

2705: L_PIV_NAME VARCHAR2(300);
2706: L_DML_TYPE VARCHAR2(3);
2707: l_sec_node dbms_xmldom.domnode;
2708: L_SEC_LST DBMS_XMLDOM.DOMNODELIST;
2709: l_first_node dbms_xmldom.domnode;
2710: L_FIRST_LST DBMS_XMLDOM.DOMNODELIST;
2711: L_FIRST_LEN NUMBER;
2712: L_INQ_TABLE_NAME VARCHAR2(256);
2713: L_SYNC_USER_NAME VARCHAR2(500);

Line 2710: L_FIRST_LST DBMS_XMLDOM.DOMNODELIST;

2706: L_DML_TYPE VARCHAR2(3);
2707: l_sec_node dbms_xmldom.domnode;
2708: L_SEC_LST DBMS_XMLDOM.DOMNODELIST;
2709: l_first_node dbms_xmldom.domnode;
2710: L_FIRST_LST DBMS_XMLDOM.DOMNODELIST;
2711: L_FIRST_LEN NUMBER;
2712: L_INQ_TABLE_NAME VARCHAR2(256);
2713: L_SYNC_USER_NAME VARCHAR2(500);
2714: L_RESP_ID NUMBER;

Line 2758: l_first_lst := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(L_XML_DOC),'/SYNC_DATA/PIV');

2754: xmlparser.parseClob(l_xml_parser, l_xml_clob_payload);
2755: L_XML_DOC := XMLPARSER.GETDOCUMENT(L_XML_PARSER);
2756: xmlparser.freeParser(l_xml_parser);
2757:
2758: l_first_lst := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(L_XML_DOC),'/SYNC_DATA/PIV');
2759: l_first_len := dbms_xmldom.getLength(l_first_lst);
2760:
2761: l_sec_lst := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(L_XML_DOC),'/SYNC_DATA/PIV/DATA');
2762: l_sec_node := xmldom.makenode(xmldom.makeelement(xmldom.item(l_sec_lst, 0)));

Line 2759: l_first_len := dbms_xmldom.getLength(l_first_lst);

2755: L_XML_DOC := XMLPARSER.GETDOCUMENT(L_XML_PARSER);
2756: xmlparser.freeParser(l_xml_parser);
2757:
2758: l_first_lst := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(L_XML_DOC),'/SYNC_DATA/PIV');
2759: l_first_len := dbms_xmldom.getLength(l_first_lst);
2760:
2761: l_sec_lst := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(L_XML_DOC),'/SYNC_DATA/PIV/DATA');
2762: l_sec_node := xmldom.makenode(xmldom.makeelement(xmldom.item(l_sec_lst, 0)));
2763:

Line 2761: l_sec_lst := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(L_XML_DOC),'/SYNC_DATA/PIV/DATA');

2757:
2758: l_first_lst := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(L_XML_DOC),'/SYNC_DATA/PIV');
2759: l_first_len := dbms_xmldom.getLength(l_first_lst);
2760:
2761: l_sec_lst := dbms_xslprocessor.selectNodes(dbms_xmldom.makeNode(L_XML_DOC),'/SYNC_DATA/PIV/DATA');
2762: l_sec_node := xmldom.makenode(xmldom.makeelement(xmldom.item(l_sec_lst, 0)));
2763:
2764: IF l_df <> l_htm5_df THEN
2765: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_DATE_FORMAT='''||l_htm5_df||'''';

Line 2784: dbms_xmldom.writetoclob(l_sec_node, part_xml);

2780:
2781: END IF;
2782:
2783: part_xml := ' ';
2784: dbms_xmldom.writetoclob(l_sec_node, part_xml);
2785:
2786: part_xml := REPLACE (part_xml,'','' || '');
2787: part_xml := REPLACE (part_xml,'','');
2788: