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

Line 815: doc DBMS_XMLDOM.DOMDocument;

811: , x_msg_count OUT NOCOPY NUMBER
812: , x_msg_data OUT NOCOPY VARCHAR2
813: , x_return_status OUT NOCOPY VARCHAR2 )
814: IS
815: doc DBMS_XMLDOM.DOMDocument;
816: clobdoc CLOB;
817: l_resp_txt CLOB;
818: xdata XMLTYPE;
819: l_xml XMLTYPE;

Line 1313: doc DBMS_XMLDOM.DOMDocument;

1309: , x_msg_count OUT NOCOPY NUMBER
1310: , x_msg_data OUT NOCOPY VARCHAR2
1311: , x_return_status OUT NOCOPY VARCHAR2 )
1312: IS
1313: doc DBMS_XMLDOM.DOMDocument;
1314: clobdoc CLOB;
1315: l_resp_txt CLOB;
1316: xdata XMLTYPE;
1317: l_xml XMLTYPE;

Line 1712: doc := DBMS_XMLDOM.NewDOMDocument(xdata);

1708: END IF;
1709: CLOSE rate_xml_cur;
1710:
1711:
1712: doc := DBMS_XMLDOM.NewDOMDocument(xdata);
1713:
1714: --dbms_xmldom.writetofile(doc, '/usr/tmp/TimeIntransit.xml');
1715:
1716: dbms_xmldom.writeToClob(doc,clobdoc) ;

Line 1714: --dbms_xmldom.writetofile(doc, '/usr/tmp/TimeIntransit.xml');

1710:
1711:
1712: doc := DBMS_XMLDOM.NewDOMDocument(xdata);
1713:
1714: --dbms_xmldom.writetofile(doc, '/usr/tmp/TimeIntransit.xml');
1715:
1716: dbms_xmldom.writeToClob(doc,clobdoc) ;
1717:
1718: IF l_debug_on THEN

Line 1716: dbms_xmldom.writeToClob(doc,clobdoc) ;

1712: doc := DBMS_XMLDOM.NewDOMDocument(xdata);
1713:
1714: --dbms_xmldom.writetofile(doc, '/usr/tmp/TimeIntransit.xml');
1715:
1716: dbms_xmldom.writeToClob(doc,clobdoc) ;
1717:
1718: IF l_debug_on THEN
1719: WSH_DEBUG_SV.log(l_module_name,'Created xml file and the content is ');
1720: WSH_DEBUG_SV.log(l_module_name,clobdoc);

Line 2172: doc DBMS_XMLDOM.DOMDocument;

2168: , x_msg_count OUT NOCOPY NUMBER
2169: , x_msg_data OUT NOCOPY VARCHAR2
2170: , x_return_status OUT NOCOPY VARCHAR2 )
2171: IS
2172: doc DBMS_XMLDOM.DOMDocument;
2173: clobdoc CLOB;
2174: l_resp_txt CLOB;
2175: xdata XMLTYPE;
2176: l_xml XMLTYPE;

Line 2271: doc := DBMS_XMLDOM.NewDOMDocument(xdata);

2267: --RETURN;
2268: END IF;
2269: CLOSE trk_xml_cur;
2270:
2271: doc := DBMS_XMLDOM.NewDOMDocument(xdata);
2272:
2273: --dbms_xmldom.writetofile(doc, '/usr/tmp/TimeIntransit.xml');
2274:
2275: dbms_xmldom.writeToClob(doc,clobdoc) ;

Line 2273: --dbms_xmldom.writetofile(doc, '/usr/tmp/TimeIntransit.xml');

2269: CLOSE trk_xml_cur;
2270:
2271: doc := DBMS_XMLDOM.NewDOMDocument(xdata);
2272:
2273: --dbms_xmldom.writetofile(doc, '/usr/tmp/TimeIntransit.xml');
2274:
2275: dbms_xmldom.writeToClob(doc,clobdoc) ;
2276:
2277: IF l_debug_on THEN

Line 2275: dbms_xmldom.writeToClob(doc,clobdoc) ;

2271: doc := DBMS_XMLDOM.NewDOMDocument(xdata);
2272:
2273: --dbms_xmldom.writetofile(doc, '/usr/tmp/TimeIntransit.xml');
2274:
2275: dbms_xmldom.writeToClob(doc,clobdoc) ;
2276:
2277: IF l_debug_on THEN
2278: WSH_DEBUG_SV.log(l_module_name,'Created xml file and the content is ');
2279: WSH_DEBUG_SV.log(l_module_name,clobdoc);

Line 2690: doc DBMS_XMLDOM.DOMDocument;

2686: , x_msg_count OUT NOCOPY NUMBER
2687: , x_msg_data OUT NOCOPY VARCHAR2
2688: , x_return_status OUT NOCOPY VARCHAR2 )
2689: IS
2690: doc DBMS_XMLDOM.DOMDocument;
2691: clobdoc CLOB;
2692: l_resp_txt CLOB;
2693: xdata XMLTYPE;
2694: l_xml XMLTYPE;

Line 2801: doc := DBMS_XMLDOM.NewDOMDocument(xdata);

2797: END IF;
2798: CLOSE tnt_xml_cur;
2799: l_carrier_api_url := 'https://onlinetools.ups.com/webservices/TimeInTransit'; --UPS Prod URL
2800:
2801: doc := DBMS_XMLDOM.NewDOMDocument(xdata);
2802:
2803: --dbms_xmldom.writetofile(doc, '/usr/tmp/SriTimeIntransit.xml');
2804:
2805: dbms_xmldom.writeToClob(doc,clobdoc) ;

Line 2803: --dbms_xmldom.writetofile(doc, '/usr/tmp/SriTimeIntransit.xml');

2799: l_carrier_api_url := 'https://onlinetools.ups.com/webservices/TimeInTransit'; --UPS Prod URL
2800:
2801: doc := DBMS_XMLDOM.NewDOMDocument(xdata);
2802:
2803: --dbms_xmldom.writetofile(doc, '/usr/tmp/SriTimeIntransit.xml');
2804:
2805: dbms_xmldom.writeToClob(doc,clobdoc) ;
2806:
2807: IF l_debug_on THEN

Line 2805: dbms_xmldom.writeToClob(doc,clobdoc) ;

2801: doc := DBMS_XMLDOM.NewDOMDocument(xdata);
2802:
2803: --dbms_xmldom.writetofile(doc, '/usr/tmp/SriTimeIntransit.xml');
2804:
2805: dbms_xmldom.writeToClob(doc,clobdoc) ;
2806:
2807: IF l_debug_on THEN
2808: WSH_DEBUG_SV.log(l_module_name,'Created xml file and the content is ');
2809: WSH_DEBUG_SV.log(l_module_name,clobdoc);