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_OTM_RIQ_XML dependencies on XMLTYPE

Line 2612: x_xml_input IN OUT NOCOPY XMLTYPE,

2608: p_source_line_tab IN WSH_OTM_RIQ_LINE_TAB,
2609: p_source_header_rec IN WSH_OTM_RIQ_HEADER_REC,
2610: p_source_type IN VARCHAR2,
2611: p_action IN VARCHAR2,
2612: x_xml_input IN OUT NOCOPY XMLTYPE,
2613: x_return_status OUT NOCOPY VARCHAR2) IS
2614:
2615: l_return_status VARCHAR2(1);
2616: l_debug_on BOOLEAN;

Line 3228: p_xml IN XMLTYPE,

3224:
3225: END Create_RIQ_XML;
3226:
3227: PROCEDURE Fetch_XML_Match(
3228: p_xml IN XMLTYPE,
3229: p_xpath IN VARCHAR2,
3230: x_xml_seq OUT NOCOPY XMLSequenceType,
3231: x_return_status OUT NOCOPY VARCHAR2)
3232: IS

Line 3238: CURSOR c_extract(C_XML_IN IN XMLTYPE,C_XPATH IN VARCHAR2)

3234: l_debug_on BOOLEAN;
3235: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Fetch_XML_Match';
3236:
3237:
3238: CURSOR c_extract(C_XML_IN IN XMLTYPE,C_XPATH IN VARCHAR2)
3239: IS
3240: SELECT XMLSEQUENCE(EXTRACT(C_XML_IN,C_XPATH,g_xml_namespace_map)) XML
3241: FROM DUAL;
3242:

Line 3296: p_xml_output IN XMLTYPE,

3292:
3293:
3294: PROCEDURE Check_Response_Status(
3295: p_xpath_prefix IN VARCHAR2,
3296: p_xml_output IN XMLTYPE,
3297: x_return_status OUT NOCOPY VARCHAR2)
3298: IS
3299:
3300: i NUMBER;

Line 3305: l_tmp_xml XMLTYPE;

3301: l_xml_seq XMLSequenceType;
3302: l_status_code VARCHAR2(30);
3303: l_status_message VARCHAR2(32000);
3304: l_log_message VARCHAR2(32000);
3305: l_tmp_xml XMLTYPE;
3306: l_return_status VARCHAR2(1);
3307: l_debug_on BOOLEAN;
3308: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Check_Response_Status';
3309:

Line 3460: p_xml IN XMLTYPE,

3456: --
3457: END Check_Response_Status;
3458:
3459: PROCEDURE Extract_Single_Cost(
3460: p_xml IN XMLTYPE,
3461: p_xpath_prefix IN VARCHAR2,
3462: p_currency IN VARCHAR2,
3463: x_cost OUT NOCOPY NUMBER,
3464: x_return_status OUT NOCOPY VARCHAR2) IS

Line 3467: l_tmp_xml XMLTYPE;

3463: x_cost OUT NOCOPY NUMBER,
3464: x_return_status OUT NOCOPY VARCHAR2) IS
3465:
3466: l_negative VARCHAR2(1);
3467: l_tmp_xml XMLTYPE;
3468: l_return_status VARCHAR2(1);
3469: l_debug_on BOOLEAN;
3470: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Extract_Single_Cost';
3471:

Line 3670: p_xml IN XMLTYPE,

3666:
3667:
3668:
3669: PROCEDURE Extract_Rate(
3670: p_xml IN XMLTYPE,
3671: p_xpath_prefix IN VARCHAR2,
3672: p_currency IN VARCHAR2,
3673: x_summary_rate OUT NOCOPY NUMBER,
3674: x_base_rate OUT NOCOPY NUMBER,

Line 3681: l_tmp_xml XMLTYPE;

3677: IS
3678:
3679: i NUMBER;
3680: l_xml_seq XMLSequenceType;
3681: l_tmp_xml XMLTYPE;
3682: l_return_status VARCHAR2(1);
3683: l_debug_on BOOLEAN;
3684: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Extract_Rate';
3685:

Line 3901: p_xml IN XMLTYPE,

3897: END Extract_Rate;
3898:
3899:
3900: PROCEDURE Extract_Ship_Method(
3901: p_xml IN XMLTYPE,
3902: p_xpath_prefix IN VARCHAR2,
3903: p_action IN VARCHAR2,
3904: x_carrier_id OUT NOCOPY NUMBER,
3905: x_mode OUT NOCOPY VARCHAR2,

Line 3913: l_tmp_xml XMLTYPE;

3909: x_transit_time_UOM OUT NOCOPY VARCHAR2,
3910: x_return_status OUT NOCOPY VARCHAR2)
3911: IS
3912:
3913: l_tmp_xml XMLTYPE;
3914: l_carrier_prefix VARCHAR2(30);
3915:
3916: l_carrier VARCHAR2(50);
3917: l_carrier_id NUMBER;

Line 4870: p_xml_output IN XMLTYPE,

4866:
4867:
4868:
4869: PROCEDURE Handle_Get_SM_Response(
4870: p_xml_output IN XMLTYPE,
4871: p_source_type IN VARCHAR2,
4872: p_action IN VARCHAR2,
4873: x_source_header_rec IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
4874: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 4893: l_tmp_xml XMLTYPE;

4889: l_service_level VARCHAR2(30);
4890: l_freight_terms VARCHAR2(30);
4891: l_transit_time NUMBER;
4892: l_transit_time_UOM VARCHAR2(30);
4893: l_tmp_xml XMLTYPE;
4894:
4895: l_return_status VARCHAR2(1);
4896: l_debug_on BOOLEAN;
4897: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Handle_Get_SM_Response';

Line 5058: p_xml_output IN XMLTYPE,

5054: END Handle_Get_SM_Response;
5055:
5056:
5057: PROCEDURE Handle_Get_FC_Response(
5058: p_xml_output IN XMLTYPE,
5059: p_source_type IN VARCHAR2,
5060: p_action IN VARCHAR2,
5061: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5062: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,

Line 5071: l_tmp_xml XMLTYPE;

5067:
5068: l_summary_rate NUMBER;
5069: l_base_rate NUMBER;
5070: l_charge_rate NUMBER;
5071: l_tmp_xml XMLTYPE;
5072:
5073: l_return_status VARCHAR2(1);
5074: l_debug_on BOOLEAN;
5075: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Handle_Get_FC_Response';

Line 5242: p_xml_output IN XMLTYPE,

5238: --
5239: END Handle_Get_FC_Response;
5240:
5241: PROCEDURE Handle_Choose_SM_Response(
5242: p_xml_output IN XMLTYPE,
5243: p_source_type IN VARCHAR2,
5244: p_action IN VARCHAR2,
5245: p_source_header_rec IN FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5246: p_source_line_tab IN FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,

Line 5570: p_xml_output IN XMLTYPE,

5566: END Handle_Choose_SM_Response;
5567:
5568:
5569: PROCEDURE Parse_RIQ_Output_XML(
5570: p_xml_output IN XMLTYPE,
5571: p_source_type IN VARCHAR2,
5572: p_action IN VARCHAR2,
5573: x_source_header_rec IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_REC,
5574: x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,

Line 5970: l_xml_input XMLTYPE;

5966: i NUMBER;
5967: l_source_header_tab_xml WSH_OTM_RIQ_HEADER_TAB;
5968: l_source_line_tab_xml WSH_OTM_RIQ_LINE_TAB;
5969: l_xmlCLOB CLOB;
5970: l_xml_input XMLTYPE;
5971: l_xml_output XMLTYPE;
5972: l_total_header_count NUMBER;
5973: l_failed_header_count NUMBER;
5974:

Line 5971: l_xml_output XMLTYPE;

5967: l_source_header_tab_xml WSH_OTM_RIQ_HEADER_TAB;
5968: l_source_line_tab_xml WSH_OTM_RIQ_LINE_TAB;
5969: l_xmlCLOB CLOB;
5970: l_xml_input XMLTYPE;
5971: l_xml_output XMLTYPE;
5972: l_total_header_count NUMBER;
5973: l_failed_header_count NUMBER;
5974:
5975: l_return_status VARCHAR2(1);

Line 6154: WSH_DEBUG_SV.log(l_module_name,'Before creating XMLType');

6150:
6151: IF l_debug_on
6152: THEN
6153:
6154: WSH_DEBUG_SV.log(l_module_name,'Before creating XMLType');
6155: END IF;
6156:
6157:
6158: l_xml_output:=NEW XMLTYPE(l_xmlCLOB);

Line 6158: l_xml_output:=NEW XMLTYPE(l_xmlCLOB);

6154: WSH_DEBUG_SV.log(l_module_name,'Before creating XMLType');
6155: END IF;
6156:
6157:
6158: l_xml_output:=NEW XMLTYPE(l_xmlCLOB);
6159:
6160: IF l_debug_on
6161: THEN
6162:

Line 6163: WSH_DEBUG_SV.log(l_module_name,'After creating XMLType');

6159:
6160: IF l_debug_on
6161: THEN
6162:
6163: WSH_DEBUG_SV.log(l_module_name,'After creating XMLType');
6164: END IF;
6165:
6166:
6167: Parse_RIQ_Output_XML(

Line 6199: --Perform any freeing up of xmltype/CLOB resources

6195:
6196:
6197:
6198:
6199: --Perform any freeing up of xmltype/CLOB resources
6200:
6201:
6202: --
6203: IF l_debug_on THEN