APPS.WSH_OTM_RIQ_XML dependencies on XMLSEQUENCE

Line 3230: x_xml_seq OUT NOCOPY XMLSequenceType,

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
3233: l_return_status VARCHAR2(1);
3234: l_debug_on BOOLEAN;

Line 3240: SELECT XMLSEQUENCE(EXTRACT(C_XML_IN,C_XPATH,g_xml_namespace_map)) XML

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:
3243: BEGIN
3244: --

Line 3301: l_xml_seq XMLSequenceType;

3297: x_return_status OUT NOCOPY VARCHAR2)
3298: IS
3299:
3300: i NUMBER;
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;

Line 3680: l_xml_seq XMLSequenceType;

3676: x_return_status OUT NOCOPY VARCHAR2)
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';

Line 4886: l_xml_seq XMLSequenceType;

4882: x_return_status OUT NOCOPY VARCHAR2)
4883: IS
4884:
4885: i NUMBER;
4886: l_xml_seq XMLSequenceType;
4887: l_carrier_id NUMBER;
4888: l_mode VARCHAR2(30);
4889: l_service_level VARCHAR2(30);
4890: l_freight_terms VARCHAR2(30);

Line 5265: l_xml_seq XMLSequenceType;

5261: l_transit_time NUMBER;
5262: l_transit_time_UOM VARCHAR2(30);
5263:
5264: i NUMBER;
5265: l_xml_seq XMLSequenceType;
5266: l_sm_tab WSH_SM_TAB;
5267: l_sm_rec_empty WSH_SM_REC;
5268: l_sm_rec WSH_SM_REC;
5269: l_sm_rec_hash WSH_SM_REC;