1 PACKAGE FTE_FREIGHT_RATING_PUB AUTHID CURRENT_USER AS
2 /* $Header: FTEFRPBS.pls 120.0 2005/05/26 18:18:09 appldev noship $ */
3
4 --Structures for Lane Information,made public to pass it onto TL Release 12
5
6 TYPE lane_info_rec_type IS RECORD -- Make these columns as %TYPE
7 (lane_id NUMBER ,
8 carrier_id NUMBER ,
9 carrier_freight_code VARCHAR2(30),
10 pricelist_id NUMBER ,
11 mode_of_transportation_code VARCHAR2(30) ,
12 origin_id NUMBER ,
13 destination_id NUMBER ,
14 basis VARCHAR2(30) ,
15 commodity_catg_id NUMBER ,
16 service_type_code VARCHAR2(30),
17 classification_code VARCHAR2(10), -- To be added to fte_lanes
18 ship_method_code VARCHAR2(30),
19 transit_time NUMBER,
20 transit_time_uom VARCHAR2(10)
21 );
22
23 TYPE lane_info_tab_type IS TABLE OF lane_info_rec_type INDEX BY BINARY_INTEGER;
24
25
26 -- ----------------------------------------------------------------------------------------
27 --
28 -- Tables and records for input
29 --
30
31 PROCEDURE Get_Freight_Costs(
32 p_api_version IN NUMBER DEFAULT 1.0,
33 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
34 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
35 p_source_line_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_tab,
36 p_source_header_tab IN OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_tab,
37 p_source_type IN VARCHAR2,
38 p_action IN VARCHAR2,
39 x_source_line_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_line_rates_tab,
40 x_source_header_rates_tab OUT NOCOPY FTE_PROCESS_REQUESTS.fte_source_header_rates_tab,
41 x_request_id OUT NOCOPY NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2);
45
46 END FTE_FREIGHT_RATING_PUB;