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 XMLTYPE

Line 818: xdata XMLTYPE;

814: IS
815: doc DBMS_XMLDOM.DOMDocument;
816: clobdoc CLOB;
817: l_resp_txt CLOB;
818: xdata XMLTYPE;
819: l_xml XMLTYPE;
820: l_http_req utl_http.req;
821: l_http_resp utl_http.resp;
822: v_read_line VARCHAR2(32767);

Line 819: l_xml XMLTYPE;

815: doc DBMS_XMLDOM.DOMDocument;
816: clobdoc CLOB;
817: l_resp_txt CLOB;
818: xdata XMLTYPE;
819: l_xml XMLTYPE;
820: l_http_req utl_http.req;
821: l_http_resp utl_http.resp;
822: v_read_line VARCHAR2(32767);
823: l_my_scheme VARCHAR2(256);

Line 1089: l_xml := xmltype(l_resp_txt);

1085: IF l_debug_on THEN
1086: WSH_DEBUG_SV.log(l_module_name,'Parsing Response l_resp_txt');
1087: END IF;
1088:
1089: l_xml := xmltype(l_resp_txt);
1090:
1091: l_index := 1;
1092: IF l_xml.Existsnode('/AddressValidationResponse/'||'AddressValidationResult[' || To_Char(l_index) || ']') > 0
1093: THEN

Line 1316: xdata XMLTYPE;

1312: IS
1313: doc DBMS_XMLDOM.DOMDocument;
1314: clobdoc CLOB;
1315: l_resp_txt CLOB;
1316: xdata XMLTYPE;
1317: l_xml XMLTYPE;
1318: l_http_req utl_http.req;
1319: l_http_resp utl_http.resp;
1320: v_read_line VARCHAR2(32767);

Line 1317: l_xml XMLTYPE;

1313: doc DBMS_XMLDOM.DOMDocument;
1314: clobdoc CLOB;
1315: l_resp_txt CLOB;
1316: xdata XMLTYPE;
1317: l_xml XMLTYPE;
1318: l_http_req utl_http.req;
1319: l_http_resp utl_http.resp;
1320: v_read_line VARCHAR2(32767);
1321: l_my_scheme VARCHAR2(256);

Line 1865: l_xml := xmltype(l_resp_txt);

1861: IF l_debug_on THEN
1862: WSH_DEBUG_SV.log(l_module_name,'Parsing Response l_resp_txt');
1863: END IF;
1864:
1865: l_xml := xmltype(l_resp_txt);
1866:
1867: SELECT VALUE
1868: INTO v_decimal
1869: FROM NLS_SESSION_PARAMETERS

Line 2175: xdata XMLTYPE;

2171: IS
2172: doc DBMS_XMLDOM.DOMDocument;
2173: clobdoc CLOB;
2174: l_resp_txt CLOB;
2175: xdata XMLTYPE;
2176: l_xml XMLTYPE;
2177: l_http_req utl_http.req;
2178: l_http_resp utl_http.resp;
2179: v_read_line VARCHAR2(32767);

Line 2176: l_xml XMLTYPE;

2172: doc DBMS_XMLDOM.DOMDocument;
2173: clobdoc CLOB;
2174: l_resp_txt CLOB;
2175: xdata XMLTYPE;
2176: l_xml XMLTYPE;
2177: l_http_req utl_http.req;
2178: l_http_resp utl_http.resp;
2179: v_read_line VARCHAR2(32767);
2180: l_my_scheme VARCHAR2(256);

Line 2424: l_xml := xmltype(l_resp_txt);

2420: IF l_debug_on THEN
2421: WSH_DEBUG_SV.log(l_module_name,'Parsing Response l_resp_txt');
2422: END IF;
2423:
2424: l_xml := xmltype(l_resp_txt);
2425:
2426: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ''.,''';
2427:
2428: l_namespace := 'xmlns:trk="http://www.ups.com/XMLSchema/XOLTWS/Track/v2.0"';

Line 2693: xdata XMLTYPE;

2689: IS
2690: doc DBMS_XMLDOM.DOMDocument;
2691: clobdoc CLOB;
2692: l_resp_txt CLOB;
2693: xdata XMLTYPE;
2694: l_xml XMLTYPE;
2695: l_http_req utl_http.req;
2696: l_http_resp utl_http.resp;
2697: v_read_line VARCHAR2(32767);

Line 2694: l_xml XMLTYPE;

2690: doc DBMS_XMLDOM.DOMDocument;
2691: clobdoc CLOB;
2692: l_resp_txt CLOB;
2693: xdata XMLTYPE;
2694: l_xml XMLTYPE;
2695: l_http_req utl_http.req;
2696: l_http_resp utl_http.resp;
2697: v_read_line VARCHAR2(32767);
2698: l_my_scheme VARCHAR2(256);

Line 2944: l_xml := xmltype(l_resp_txt);

2940: IF l_debug_on THEN
2941: WSH_DEBUG_SV.log(l_module_name,'Parsing Response l_resp_txt');
2942: END IF;
2943:
2944: l_xml := xmltype(l_resp_txt);
2945: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ''.,''';
2946:
2947: l_namespace := 'xmlns:tnt="http://www.ups.com/XMLSchema/XOLTWS/tnt/v1.0"';
2948: l_index := 1;