1 PACKAGE WSH_OTM_RIQ_XML as
2 /* $Header: WSHGLRXS.pls 120.0.12010000.1 2008/07/29 06:08:00 appldev ship $ */
3
4 --This Procedure replaces calls to the FTE Rating(FTE_PROCESS_REQUESTS.FORMAT_CS_CALL)
5 --and FTE Routing Guide(FTE_FREIGHT_RATING_PUB.Get_Freight_Costs) with a call to OTM
6 --when OTM is installed
7
8 PROCEDURE CALL_OTM_FOR_OM(
9 x_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_TAB,
10 x_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_TAB,
11 p_source_type IN VARCHAR2,
12 p_action IN VARCHAR2,
13 x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_LINE_RATES_TAB,
14 x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.FTE_SOURCE_HEADER_RATES_TAB,
15 x_result_consolidation_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
16 x_result_carrier_id_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
17 x_result_service_level_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
18 x_result_mode_of_transport_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
19 x_result_freight_term_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
20 x_result_transit_time_min_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
21 x_result_transit_time_max_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableNumbers,
22 x_ship_method_code_tab IN OUT NOCOPY WSH_NEW_DELIVERY_ACTIONS.TableVarchar30,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2);
26
27
28 --For a given UOM the procedure checks in attribute15 of the mtl UOM table,
29 --if there is a value it returns that otherwise it returns the same UOM passed in.
30 --The API returns Success except when there is an unexpected error. It caches previously queried values to avoid hits to the database.
31
32 PROCEDURE Get_EBS_To_OTM_UOM(
33 p_uom IN VARCHAR2,
34 x_uom OUT NOCOPY VARCHAR2,
35 x_return_status OUT NOCOPY VARCHAR2);
36
37 --For the passed in UOM and class the procedure checks if the UOM exists for that class in the MTL UOM tables
38 --If not it checks if it exists in atribute15 of of a UOM for that UOM class. Otherwise returns null
39 --It caches previously queried values to avoid hits to the database.
40 --The API returns Success except when there is an unexpected error.
41 PROCEDURE Get_OTM_To_EBS_UOM(
42 p_uom IN VARCHAR2,
43 p_uom_class IN VARCHAR2,
44 x_uom OUT NOCOPY VARCHAR2,
45 x_return_status OUT NOCOPY VARCHAR2);
46
47 END WSH_OTM_RIQ_XML;
48
49
50