1 PACKAGE FTE_ACS_TRIP_PKG AS
2 /* $Header: FTEACSTS.pls 120.2 2005/07/15 04:07:36 alksharm noship $ */
3
4 --
5 -- ----------------------------------------------------------------------
6 -- Procedure: CARRIER_SEL_CREATE_TRIP
7 --
8 -- Parameters: p_delivery_id Delivery ID
9 -- p_carrier_sel_result_rec WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE
10 -- x_trip_id Trip Id
11 -- x_trip_name Trip Name
12 -- x_return_message Return Message
13 -- x_return_status Return Status
14 --
15 -- COMMENT : This procedure is called from Process Carrier Selection API
16 -- in order to create trip for deliveries not assigned to trips
17 --
18 -- It performs the following steps:
19 -- 01. Create trip.
20 -- 02. Create Pick Up and Drop Off Stops for trip created above
21 -- 03. Assign delivery to trip
22 --
23 -- ----------------------------------------------------------------------
24 PROCEDURE CARRIER_SEL_CREATE_TRIP( p_delivery_id IN NUMBER,
25 --p_initial_pickup_loc_id IN NUMBER,
26 --p_ultimate_dropoff_loc_id IN NUMBER,
27 --p_initial_pickup_date IN DATE,
28 --p_ultimate_dropoff_date IN DATE,
29 p_carrier_sel_result_rec IN WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE,
30 x_trip_id OUT NOCOPY NUMBER,
31 x_trip_name OUT NOCOPY VARCHAR2,
32 x_return_message OUT NOCOPY VARCHAR2,
33 x_return_status OUT NOCOPY VARCHAR2);
34
35
36 --
37 -- ----------------------------------------------------------------------
38 -- Procedure: GET_RANKED_RESULTS
39 --
40 -- Parameters: p_rule_id Rule ID
41 -- x_routing_results Ranked list of carriers,mode and service levels
42 -- x_return_status Return Status
43 --
44 -- COMMENT : The procedure queries FTE_SEL_RESULT_ASSIGNMENTS to return results for the given
45 -- rule id. The API returns does not return multileg results.
46 -- ----------------------------------------------------------------------
47 PROCEDURE GET_RANKED_RESULTS( p_rule_id IN NUMBER,
48 x_routing_results OUT NOCOPY FTE_CARRIER_RANK_LIST_PVT.carrier_rank_list_tbl_type,
49 x_return_status OUT NOCOPY VARCHAR2);
50
51 END FTE_ACS_TRIP_PKG;