1 PACKAGE FTE_ESTIMATE_FREIGHT_RATE AS
2 /* $Header: FTEEFRES.pls 120.0 2005/05/26 17:28:38 appldev noship $ */
3 /*
4 -- Global constants
5 -- +======================================================================+
6 -- Procedure :
7 -- Freight Estimate Rate Search
8 --
9 -- Description:
10 -- Call the Service Search and Pricing API to get the rates
11 -- for the given inputs
12 -- Inputs:
13 -- Output:
14 -- No direct
15 -- DB:
16 -- +======================================================================+
17 */
18 PROCEDURE RATE_SEARCH(
19 p_init_msg_list IN VARCHAR2 default fnd_api.g_false,
20 p_api_version_number IN NUMBER default 1.0,
21 p_origin IN VARCHAR2,
22 p_destination IN VARCHAR2,
23 p_org_location_id IN NUMBER,
24 p_dest_location_id IN NUMBER,
25 p_org_country IN VARCHAR2,
26 p_dest_country IN VARCHAR2,
27 p_weight IN NUMBER,
28 p_weight_uom IN VARCHAR2,
29 p_volume IN NUMBER,
30 p_volume_uom IN VARCHAR2,
31 p_distance IN NUMBER,
32 p_distance_uom IN VARCHAR2,
33 p_show_ltl_rates_flag IN VARCHAR2,
34 p_show_tl_rates_flag IN VARCHAR2,
35 p_show_parcel_rates_flag IN VARCHAR2,
36 p_ship_date IN VARCHAR2,
37 p_del_date IN VARCHAR2,
38 p_carrier_id IN NUMBER,
39 p_service_level IN VARCHAR2,
40 p_md_type IN VARCHAR2, -- Markup / Discount Type (M/D)
41 p_md_percent IN NUMBER,
42 p_commodity_catg_id IN NUMBER,
43 p_vehicle_type_id IN NUMBER,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2);
47
48 /* This API will be used to split city_state_zip into city state zip
49 INPUTS can be maximum 3 values seperated by comma
50 if there are 3, it will be converted city, state, zip
51 if there are 2, it will be converted state, zip
52 if there are 1, it will be converted zip
53 */
54
55 PROCEDURE SPLIT_CITY_STATE_ZIP (
56 p_city_state_zip IN VARCHAR2,
57 x_city OUT NOCOPY VARCHAR2,
58 x_state OUT NOCOPY VARCHAR2,
59 x_zip OUT NOCOPY VARCHAR2,
60 x_return_status OUT NOCOPY VARCHAR2);
61
62 END FTE_ESTIMATE_FREIGHT_RATE;