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 WSH_NEW_DELIVERY_ACTIONS

Line 49: g_carrier_freight_codes WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;

45: --TODO old NS map
46: G_GLOG_NS_MAP CONSTANT VARCHAR2(200):='xmlns="http://glog.com"';
47: G_OTM_NS_MAP CONSTANT VARCHAR2(200):='xmlns="http://xmlns.oracle.com/apps/otm"';
48:
49: g_carrier_freight_codes WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
50: g_carrier_generic_flags WSH_NEW_DELIVERY_ACTIONS.TableVarchar3;
51:
52: g_state_region_type CONSTANT NUMBER:=1;
53: g_price_cost_type_id NUMBER;

Line 50: g_carrier_generic_flags WSH_NEW_DELIVERY_ACTIONS.TableVarchar3;

46: G_GLOG_NS_MAP CONSTANT VARCHAR2(200):='xmlns="http://glog.com"';
47: G_OTM_NS_MAP CONSTANT VARCHAR2(200):='xmlns="http://xmlns.oracle.com/apps/otm"';
48:
49: g_carrier_freight_codes WSH_NEW_DELIVERY_ACTIONS.TableVarchar30;
50: g_carrier_generic_flags WSH_NEW_DELIVERY_ACTIONS.TableVarchar3;
51:
52: g_state_region_type CONSTANT NUMBER:=1;
53: g_price_cost_type_id NUMBER;
54: g_domain_name VARCHAR2(50);

Line 787: p_result_consolidation_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

783:
784:
785:
786: PROCEDURE print_CS_Results(
787: p_result_consolidation_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
788: p_result_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
789: p_result_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
790: p_result_mode_of_transport_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
791: p_result_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 788: p_result_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

784:
785:
786: PROCEDURE print_CS_Results(
787: p_result_consolidation_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
788: p_result_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
789: p_result_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
790: p_result_mode_of_transport_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
791: p_result_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
792: p_result_transit_time_min_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 789: p_result_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

785:
786: PROCEDURE print_CS_Results(
787: p_result_consolidation_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
788: p_result_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
789: p_result_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
790: p_result_mode_of_transport_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
791: p_result_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
792: p_result_transit_time_min_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
793: p_result_transit_time_max_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 790: p_result_mode_of_transport_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

786: PROCEDURE print_CS_Results(
787: p_result_consolidation_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
788: p_result_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
789: p_result_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
790: p_result_mode_of_transport_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
791: p_result_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
792: p_result_transit_time_min_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
793: p_result_transit_time_max_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
794: p_ship_method_code_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 791: p_result_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

787: p_result_consolidation_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
788: p_result_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
789: p_result_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
790: p_result_mode_of_transport_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
791: p_result_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
792: p_result_transit_time_min_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
793: p_result_transit_time_max_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
794: p_ship_method_code_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
795: x_return_status OUT NOCOPY VARCHAR2)

Line 792: p_result_transit_time_min_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

788: p_result_carrier_id_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
789: p_result_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
790: p_result_mode_of_transport_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
791: p_result_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
792: p_result_transit_time_min_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
793: p_result_transit_time_max_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
794: p_ship_method_code_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
795: x_return_status OUT NOCOPY VARCHAR2)
796: IS

Line 793: p_result_transit_time_max_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

789: p_result_service_level_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
790: p_result_mode_of_transport_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
791: p_result_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
792: p_result_transit_time_min_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
793: p_result_transit_time_max_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
794: p_ship_method_code_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
795: x_return_status OUT NOCOPY VARCHAR2)
796: IS
797: i NUMBER;

Line 794: p_ship_method_code_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

790: p_result_mode_of_transport_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
791: p_result_freight_term_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
792: p_result_transit_time_min_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
793: p_result_transit_time_max_tab IN WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
794: p_ship_method_code_tab IN WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
795: x_return_status OUT NOCOPY VARCHAR2)
796: IS
797: i NUMBER;
798: l_return_status VARCHAR2(1);

Line 1457: l_index_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;

1453: l_count NUMBER;
1454:
1455: l_sort_tab WSH_OTM_RIQ_SORT_TAB;
1456: l_sort_rec WSH_OTM_RIQ_SORT_REC;
1457: l_index_tab WSH_NEW_DELIVERY_ACTIONS.TableNumbers;
1458: l_out_tab FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB;
1459:
1460: l_return_status VARCHAR2(1);
1461: l_debug_on BOOLEAN;

Line 4106: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

4102: p_service_level IN VARCHAR2,
4103: p_freight_terms_code IN VARCHAR2,
4104: p_transit_time IN NUMBER,
4105: p_transit_time_UOM IN VARCHAR2,
4106: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4107: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4108: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4109: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4110: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 4107: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

4103: p_freight_terms_code IN VARCHAR2,
4104: p_transit_time IN NUMBER,
4105: p_transit_time_UOM IN VARCHAR2,
4106: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4107: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4108: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4109: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4110: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4111: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 4108: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

4104: p_transit_time IN NUMBER,
4105: p_transit_time_UOM IN VARCHAR2,
4106: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4107: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4108: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4109: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4110: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4111: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4112: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 4109: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

4105: p_transit_time_UOM IN VARCHAR2,
4106: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4107: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4108: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4109: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4110: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4111: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4112: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4113: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 4110: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

4106: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4107: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4108: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4109: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4110: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4111: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4112: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4113: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4114: x_return_status OUT NOCOPY VARCHAR2)

Line 4111: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

4107: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4108: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4109: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4110: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4111: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4112: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4113: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4114: x_return_status OUT NOCOPY VARCHAR2)
4115:

Line 4112: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

4108: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4109: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4110: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4111: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4112: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4113: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4114: x_return_status OUT NOCOPY VARCHAR2)
4115:
4116: IS

Line 4113: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

4109: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4110: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4111: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4112: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4113: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4114: x_return_status OUT NOCOPY VARCHAR2)
4115:
4116: IS
4117: l_freight_terms_code VARCHAR2(30);

Line 4874: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

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,
4875: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4876: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4877: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4878: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 4875: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

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,
4875: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4876: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4877: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4878: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4879: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 4876: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

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,
4875: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4876: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4877: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4878: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4879: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4880: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 4877: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

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,
4875: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4876: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4877: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4878: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4879: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4880: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4881: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 4878: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

4874: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4875: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4876: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4877: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4878: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4879: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4880: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4881: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4882: x_return_status OUT NOCOPY VARCHAR2)

Line 4879: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

4875: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4876: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4877: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4878: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4879: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4880: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4881: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4882: x_return_status OUT NOCOPY VARCHAR2)
4883: IS

Line 4880: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

4876: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4877: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4878: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4879: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4880: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4881: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4882: x_return_status OUT NOCOPY VARCHAR2)
4883: IS
4884:

Line 4881: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

4877: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4878: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4879: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4880: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
4881: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
4882: x_return_status OUT NOCOPY VARCHAR2)
4883: IS
4884:
4885: i NUMBER;

Line 5577: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

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,
5575: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5576: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5577: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5578: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5579: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5580: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5581: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 5578: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

5574: x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
5575: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5576: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5577: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5578: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5579: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5580: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5581: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5582: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 5579: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

5575: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5576: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5577: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5578: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5579: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5580: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5581: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5582: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5583: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 5580: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

5576: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5577: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5578: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5579: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5580: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5581: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5582: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5583: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5584: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 5581: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

5577: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5578: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5579: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5580: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5581: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5582: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5583: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5584: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5585: x_return_status OUT NOCOPY VARCHAR2)

Line 5582: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

5578: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5579: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5580: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5581: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5582: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5583: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5584: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5585: x_return_status OUT NOCOPY VARCHAR2)
5586: IS

Line 5583: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

5579: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5580: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5581: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5582: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5583: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5584: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5585: x_return_status OUT NOCOPY VARCHAR2)
5586: IS
5587:

Line 5584: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

5580: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5581: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5582: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5583: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5584: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5585: x_return_status OUT NOCOPY VARCHAR2)
5586: IS
5587:
5588: l_xpath_status_prefix VARCHAR2(200);

Line 5955: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

5951: p_source_type IN VARCHAR2,
5952: p_action IN VARCHAR2,
5953: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5954: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5955: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5956: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5957: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5958: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5959: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 5956: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

5952: p_action IN VARCHAR2,
5953: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5954: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5955: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5956: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5957: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5958: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5959: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5960: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 5957: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

5953: x_source_line_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
5954: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5955: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5956: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5957: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5958: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5959: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5960: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5961: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 5958: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

5954: x_source_header_rates_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
5955: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5956: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5957: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5958: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5959: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5960: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5961: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5962: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 5959: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

5955: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5956: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5957: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5958: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5959: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5960: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5961: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5962: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5963: x_return_status OUT NOCOPY VARCHAR2)

Line 5960: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

5956: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5957: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5958: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5959: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5960: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5961: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5962: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5963: x_return_status OUT NOCOPY VARCHAR2)
5964: IS

Line 5961: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

5957: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5958: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5959: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5960: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5961: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5962: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5963: x_return_status OUT NOCOPY VARCHAR2)
5964: IS
5965: j NUMBER; -- Bug 6810844

Line 5962: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

5958: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5959: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5960: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5961: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
5962: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
5963: x_return_status OUT NOCOPY VARCHAR2)
5964: IS
5965: j NUMBER; -- Bug 6810844
5966: i NUMBER;

Line 6237: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

6233: p_source_type IN VARCHAR2,
6234: p_action IN VARCHAR2,
6235: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
6236: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
6237: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6238: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6239: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6240: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6241: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 6238: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

6234: p_action IN VARCHAR2,
6235: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
6236: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
6237: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6238: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6239: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6240: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6241: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6242: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 6239: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

6235: x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
6236: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
6237: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6238: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6239: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6240: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6241: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6242: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6243: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

Line 6240: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

6236: x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
6237: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6238: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6239: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6240: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6241: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6242: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6243: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6244: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

Line 6241: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

6237: x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6238: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6239: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6240: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6241: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6242: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6243: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6244: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6245: x_return_status OUT NOCOPY VARCHAR2,

Line 6242: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

6238: x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6239: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6240: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6241: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6242: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6243: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6244: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6245: x_return_status OUT NOCOPY VARCHAR2,
6246: x_msg_count OUT NOCOPY NUMBER,

Line 6243: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,

6239: x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6240: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6241: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6242: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6243: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6244: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6245: x_return_status OUT NOCOPY VARCHAR2,
6246: x_msg_count OUT NOCOPY NUMBER,
6247: x_msg_data OUT NOCOPY VARCHAR2)

Line 6244: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,

6240: x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6241: x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6242: x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6243: x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
6244: x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
6245: x_return_status OUT NOCOPY VARCHAR2,
6246: x_msg_count OUT NOCOPY NUMBER,
6247: x_msg_data OUT NOCOPY VARCHAR2)
6248: IS