1 PACKAGE FTE_DELIVERY_LEGS_PVT as
2 /* $Header: FTEVDLGS.pls 120.3 2005/07/28 12:34:18 nltan ship $ */
3 --{
4 GK_DLEG_WB_PAGE CONSTANT VARCHAR2(32767) := 'FTE_MLS_DLEG_WB_PAGE';
5 GK_SEARCH_SEGMENTS_PAGE CONSTANT VARCHAR2(32767) := 'FTE_MLS_SEARCH_SEG_PAGE';
6
7 PROCEDURE search_segment_save
8 (
9 P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10 X_return_status OUT NOCOPY VARCHAR2,
11 X_msg_count OUT NOCOPY NUMBER,
12 X_msg_data OUT NOCOPY VARCHAR2,
13 p_delivery_id IN NUMBER,
14 p_delivery_name IN VARCHAR2 DEFAULT NULL,
15 p_wsh_trip_id IN NUMBER,
16 p_wsh_trip_name IN VARCHAR2,
17 p_pickup_stop_id IN NUMBER,
18 p_pickup_location_id IN NUMBER,
19 p_pickup_stop_seq IN NUMBER,
20 p_pickup_departure_date IN DATE,
21 p_pickup_arrival_date IN DATE,
22 p_dropoff_stop_id IN NUMBER,
23 p_dropoff_location_id IN NUMBER,
24 p_dropoff_stop_seq IN NUMBER,
25 p_dropoff_departure_date IN DATE,
26 p_dropoff_arrival_date IN DATE,
27 p_move_stop_seq_start IN NUMBER,
28 p_move_stop_seq_to IN NUMBER,
29 p_fte_trip_id IN NUMBER,
30 p_pricing_request_id IN NUMBER,
31 p_lane_id IN NUMBER,
32 p_schedule_id IN NUMBER,
33 p_ignore_for_planning IN VARCHAR2 DEFAULT NULL,
34 x_pickup_stop_id OUT NOCOPY NUMBER,
35 x_dropoff_stop_id OUT NOCOPY NUMBER,
36 x_delivery_leg_id OUT NOCOPY NUMBER,
37 x_delivery_leg_seq OUT NOCOPY NUMBER,
38 x_pickup_stop_seq OUT NOCOPY NUMBER,
39 x_dropoff_stop_seq OUT NOCOPY NUMBER
40 );
41
42 PROCEDURE process_delivery_leg
43 (
44 P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45 X_return_status OUT NOCOPY VARCHAR2,
46 X_msg_count OUT NOCOPY NUMBER,
47 X_msg_data OUT NOCOPY VARCHAR2,
48 p_ui_page_name IN VARCHAR2 DEFAULT GK_DLEG_WB_PAGE,
49 p_delivery_id IN NUMBER,
50 p_delivery_name IN VARCHAR2 DEFAULT NULL,
51 p_delivery_leg_id IN NUMBER DEFAULT NULL,
52 p_delivery_leg_seq IN NUMBER DEFAULT NULL,
53 p_wsh_trip_id IN NUMBER DEFAULT NULL,
54 p_wsh_trip_name IN VARCHAR2 DEFAULT NULL,
55 p_lane_id IN NUMBER DEFAULT NULL,
56 p_schedule_id IN NUMBER DEFAULT NULL,
57 p_carrier_id IN NUMBER DEFAULT NULL,
58 p_mode_of_transport IN VARCHAR2 DEFAULT NULL,
59 p_service_level IN VARCHAR2 DEFAULT NULL,
60 p_carrier_name IN VARCHAR2 DEFAULT NULL,
61 p_mode_of_transport_meaning IN VARCHAR2 DEFAULT NULL,
62 p_service_level_meaning IN VARCHAR2 DEFAULT NULL,
63 p_pickup_stop_id IN NUMBER DEFAULT NULL,
64 p_pickup_stop_seq IN NUMBER DEFAULT NULL,
65 p_pickup_location_id IN NUMBER DEFAULT NULL,
66 p_pickup_departure_date IN DATE DEFAULT NULL,
67 p_pickup_arrival_date IN DATE DEFAULT NULL,
68 p_dropoff_stop_id IN NUMBER DEFAULT NULL,
69 p_dropoff_stop_seq IN NUMBER DEFAULT NULL,
70 p_dropoff_location_id IN NUMBER DEFAULT NULL,
71 p_dropoff_departure_date IN DATE DEFAULT NULL,
72 p_dropoff_arrival_date IN DATE DEFAULT NULL,
73 p_fte_trip_id IN NUMBER DEFAULT NULL,
74 p_fte_trip_name IN VARCHAR2 DEFAULT NULL,
75 p_pricing_request_id IN NUMBER DEFAULT NULL,
76 p_move_stop_seq_start IN NUMBER DEFAULT NULL,
77 p_move_stop_seq_to IN NUMBER DEFAULT NULL,
78 p_first_stop_id IN NUMBER DEFAULT NULL,
79 p_first_stop_location_id IN NUMBER DEFAULT NULL,
80 p_first_stop_seq IN NUMBER DEFAULT NULL,
81 p_first_stop_departure_date IN DATE DEFAULT NULL,
82 p_first_stop_arrival_date IN DATE DEFAULT NULL,
83 p_last_stop_id IN NUMBER DEFAULT NULL,
84 p_last_stop_location_id IN NUMBER DEFAULT NULL,
85 p_last_stop_seq IN NUMBER DEFAULT NULL,
86 p_last_stop_departure_date IN DATE DEFAULT NULL,
87 p_last_stop_arrival_date IN DATE DEFAULT NULL,
88 p_veh_org_id IN NUMBER DEFAULT NULL,
89 p_veh_num IN NUMBER DEFAULT NULL,
90 p_veh_num_pre IN NUMBER DEFAULT NULL,
91 p_ignore_for_planning IN VARCHAR2 DEFAULT NULL,
92 p_veh_item_id IN NUMBER DEFAULT NULL,
93 x_wsh_trip_id OUT NOCOPY NUMBER,
94 x_wsh_trip_name OUT NOCOPY VARCHAR2,
95 x_ship_method_code OUT NOCOPY VARCHAR2,
96 x_fte_trip_id OUT NOCOPY NUMBER,
97 x_fte_trip_name OUT NOCOPY VARCHAR2,
98 x_pickup_stop_id OUT NOCOPY NUMBER,
99 x_dropoff_stop_id OUT NOCOPY NUMBER,
100 x_delivery_leg_id OUT NOCOPY NUMBER,
101 x_delivery_leg_seq OUT NOCOPY NUMBER,
102 x_pickup_stop_seq OUT NOCOPY NUMBER,
103 x_dropoff_stop_seq OUT NOCOPY NUMBER
104 );
105 PROCEDURE assign_service_to_segment
106 (
107 P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108 X_return_status OUT NOCOPY VARCHAR2,
109 X_msg_count OUT NOCOPY NUMBER,
110 X_msg_data OUT NOCOPY VARCHAR2,
111 p_ui_page_name IN VARCHAR2 DEFAULT GK_DLEG_WB_PAGE,
112 p_wsh_trip_id IN NUMBER,
113 p_wsh_trip_name IN VARCHAR2,
114 p_lane_id IN NUMBER,
115 p_carrier_id IN NUMBER,
116 p_mode_of_transport IN VARCHAR2,
117 p_service_level IN VARCHAR2,
118 p_carrier_name IN VARCHAR2,
119 p_mode_of_transport_meaning IN VARCHAR2,
120 p_service_level_meaning IN VARCHAR2,
121 p_ship_method_code IN VARCHAR2 DEFAULT NULL,
122 p_schedule_id IN NUMBER DEFAULT NULL,
123 p_first_stop_id IN NUMBER DEFAULT NULL,
124 p_first_stop_seq IN NUMBER DEFAULT NULL,
125 p_first_stop_location_id IN NUMBER DEFAULT NULL,
126 p_first_stop_new_location_id IN NUMBER DEFAULT NULL,
127 p_first_stop_departure_date IN DATE DEFAULT NULL,
128 p_first_stop_arrival_date IN DATE DEFAULT NULL,
129 p_last_stop_id IN NUMBER DEFAULT NULL,
130 p_last_stop_seq IN NUMBER DEFAULT NULL,
131 p_last_stop_location_id IN NUMBER DEFAULT NULL,
132 p_last_stop_new_location_id IN NUMBER DEFAULT NULL,
133 p_last_stop_departure_date IN DATE DEFAULT NULL,
134 p_last_stop_arrival_date IN DATE DEFAULT NULL,
135 p_veh_org_id IN NUMBER DEFAULT NULL,
136 p_veh_item_id IN NUMBER DEFAULT NULL
137 );
138 --
139 --
140 PROCEDURE build_delivery_leg_info
141 (
142 P_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
143 X_return_status OUT NOCOPY VARCHAR2,
144 X_msg_count OUT NOCOPY NUMBER,
145 X_msg_data OUT NOCOPY VARCHAR2,
146 p_dleg_id IN NUMBER,
147 x_PUStopId OUT NOCOPY NUMBER,
148 x_PUStopLocationId OUT NOCOPY NUMBER,
149 x_PUStopLocation OUT NOCOPY VARCHAR2,
150 x_PUStopCSZ OUT NOCOPY VARCHAR2,
151 x_PUStopCountry OUT NOCOPY VARCHAR2,
152 x_PUStopActualArrivalDate OUT NOCOPY DATE,
153 x_PUStopActualDepartureDate OUT NOCOPY DATE,
154 x_PUStopPlannedArrivalDate OUT NOCOPY DATE,
155 x_PUStopPlannedDepartureDate OUT NOCOPY DATE,
156 x_PUStopSequenceNumber OUT NOCOPY NUMBER,
157 x_PUStopStatusCode OUT NOCOPY VARCHAR2,
158 x_PUStopTripId OUT NOCOPY NUMBER,
159 x_DOStopId OUT NOCOPY NUMBER,
160 x_DOStopLocationId OUT NOCOPY NUMBER,
161 x_DOStopLocation OUT NOCOPY VARCHAR2,
162 x_DOStopCSZ OUT NOCOPY VARCHAR2,
163 x_DOStopCountry OUT NOCOPY VARCHAR2,
164 x_DOStopActualArrivalDate OUT NOCOPY DATE,
165 x_DOStopActualDepartureDate OUT NOCOPY DATE,
166 x_DOStopPlannedArrivalDate OUT NOCOPY DATE,
167 x_DOStopPlannedDepartureDate OUT NOCOPY DATE,
168 x_DOStopSequenceNumber OUT NOCOPY NUMBER,
169 x_DOStopStatusCode OUT NOCOPY VARCHAR2,
170 x_DOStopTripId OUT NOCOPY NUMBER,
171 x_CarrierId OUT NOCOPY NUMBER,
172 x_CarrierName OUT NOCOPY VARCHAR2,
173 x_LaneId OUT NOCOPY NUMBER,
174 x_LaneNumber OUT NOCOPY VARCHAR2,
175 x_ScheduleId OUT NOCOPY NUMBER,
176 x_ModeOfTransport OUT NOCOPY VARCHAR2,
177 x_ModeOfTransportMeaning OUT NOCOPY VARCHAR2,
178 x_ServiceLevel OUT NOCOPY VARCHAR2,
179 x_ServiceLevelMeaning OUT NOCOPY VARCHAR2,
180 x_ShipMethodCode OUT NOCOPY VARCHAR2,
181 x_TripSegmentId OUT NOCOPY NUMBER,
182 x_TripSegmentName OUT NOCOPY VARCHAR2,
183 x_TripSegmentStatusCode OUT NOCOPY VARCHAR2,
184 x_Price OUT NOCOPY NUMBER,
185 x_Currency OUT NOCOPY VARCHAR2,
186 x_OriginStopId OUT NOCOPY NUMBER,
187 x_OriginStopStatusCode OUT NOCOPY VARCHAR2,
188 x_OriginStopSequenceNumber OUT NOCOPY NUMBER,
189 x_OriginStopLocationId OUT NOCOPY NUMBER,
190 x_OriginLocation OUT NOCOPY VARCHAR2,
191 x_OriginCSZ OUT NOCOPY VARCHAR2,
192 x_OriginCountry OUT NOCOPY VARCHAR2,
193 x_OriginDepartureDate OUT NOCOPY DATE,
194 x_OriginArrivalDate OUT NOCOPY DATE,
195 x_DestStopId OUT NOCOPY NUMBER,
196 x_DestStopStatusCode OUT NOCOPY VARCHAR2,
197 x_DestStopSequenceNumber OUT NOCOPY NUMBER,
198 x_DestStopLocationId OUT NOCOPY NUMBER,
199 x_DestLocation OUT NOCOPY VARCHAR2,
200 x_DestCSZ OUT NOCOPY VARCHAR2,
201 x_DestCountry OUT NOCOPY VARCHAR2,
202 x_DestDepartureDate OUT NOCOPY DATE,
203 x_DestArrivalDate OUT NOCOPY DATE,
204 x_TenderStatus OUT NOCOPY VARCHAR2,
205 x_TripPlannedFlag OUT NOCOPY VARCHAR2,
206 x_TripShipmentsTypeFlag OUT NOCOPY VARCHAR2,
207 x_DOStopPhysLocationId OUT NOCOPY NUMBER,
208 x_DestStopPhysLocationId OUT NOCOPY NUMBER,
209 x_BolNumber OUT NOCOPY VARCHAR2,
210 x_VehicleOrgId OUT NOCOPY NUMBER,
211 x_VehicleItemId OUT NOCOPY NUMBER,
212 x_ParentDLegId OUT NOCOPY NUMBER,
213 x_RankId OUT NOCOPY NUMBER,
214 x_RoutingRuleId OUT NOCOPY NUMBER,
215 x_AppendFlag OUT NOCOPY VARCHAR2,
216 x_ParentDlvyName OUT NOCOPY VARCHAR2
217 );
218 --}
219 END FTE_DELIVERY_LEGS_PVT;