1 PACKAGE FTE_MLS_WRAPPER as
2 /* $Header: FTEMLWRS.pls 120.3 2005/06/30 13:24:15 hbhagava noship $ */
3
4 c_sdebug CONSTANT NUMBER := wsh_debug_sv.c_level1;
5 c_debug CONSTANT NUMBER := wsh_debug_sv.c_level2;
6 G_STOPS_TAB_REC WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
7
8 TYPE stop_seq_rec IS RECORD (
9 OLD_STOP_SEQUENCE_NUMBER NUMBER,
10 NEW_STOP_SEQUENCE_NUMBER NUMBER
11 );
12
13 TYPE stop_seq_rec_tbl_type is TABLE of stop_seq_rec index by binary_integer;
14
15 G_STOPS_SEQ_TAB STOP_SEQ_REC_TBL_TYPE;
16
17
18 --========================================================================
19 -- PROCEDURE : Create_Update_Stop FTE wrapper
20 --
21 -- COMMENT : Wrapper around WSH_TRIP_STOPS_PUB.Create_Update
22 -- Passes in all the parameters reqd (record type input changed to
23 -- number of parameters which are collected, assigned to a record
24 -- and call WSH_TRIP_STOPS_PUB.Create_Update
25 --========================================================================
26 PROCEDURE Create_Update_Stop
27 ( p_api_version_number IN NUMBER,
28 p_init_msg_list IN VARCHAR2,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 p_action_code IN VARCHAR2,
33 p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
34 p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
35 p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
36 p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
37 p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
38 x_stop_id OUT NOCOPY NUMBER,
39 --add trip stop info rec fields
40 pp_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
41 pp_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
42 pp_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
43 pp_STOP_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
44 pp_STOP_LOCATION_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
45 pp_PLANNED_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
46 pp_PLANNED_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
47 pp_ACTUAL_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
48 pp_ACTUAL_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
49 pp_DEPARTURE_GROSS_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
50 pp_DEPARTURE_NET_WEIGHT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
51 pp_WEIGHT_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52 pp_WEIGHT_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53 pp_DEPARTURE_VOLUME IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
54 pp_VOLUME_UOM_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
55 pp_VOLUME_UOM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
56 pp_DEPARTURE_SEAL_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
57 pp_DEPARTURE_FILL_PERCENT IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
58 pp_STOP_SEQUENCE_NUMBER IN NUMBER DEFAULT FND_API.G_MISS_NUM,
59 pp_LOCK_STOP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
60 pp_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
61 pp_PENDING_INTERFACE_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
62 pp_TRANSACTION_HEADER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
63 pp_WSH_LOCATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
64 pp_TRACKING_DRILLDOWN_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
65 pp_TRACKING_REMARKS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
66 pp_CARRIER_EST_DEPARTURE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
67 pp_CARRIER_EST_ARRIVAL_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
68 pp_LOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
69 pp_LOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
70 pp_UNLOADING_START_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
71 pp_UNLOADING_END_DATETIME IN DATE DEFAULT FND_API.G_MISS_DATE,
72 pp_TP_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
73 pp_TP_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
74 pp_TP_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
75 pp_TP_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
76 pp_TP_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
77 pp_TP_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
78 pp_TP_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
79 pp_TP_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
80 pp_TP_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
81 pp_TP_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
82 pp_TP_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
83 pp_TP_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
84 pp_TP_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
85 pp_TP_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
86 pp_TP_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
87 pp_TP_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
88 pp_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
89 pp_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
90 pp_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
91 pp_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
92 pp_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
93 pp_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
94 pp_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
95 pp_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
96 pp_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
97 pp_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
98 pp_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
99 pp_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
100 pp_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
101 pp_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
102 pp_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR ,
103 pp_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
104 pp_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
105 pp_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
106 pp_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
107 pp_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
108 pp_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
109 pp_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
110 pp_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM ,
111 pp_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
112 pp_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
113 p_new_stop_sequence IN NUMBER DEFAULT FND_API.G_MISS_NUM,
114 p_is_temp IN VARCHAR2 DEFAULT 'N',
115 p_wkend_layover_stops IN NUMBER DEFAULT FND_API.G_MISS_NUM,
116 p_wkday_layover_stops IN NUMBER DEFAULT FND_API.G_MISS_NUM,
117 p_shipments_type_flag IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
118 );
119
120 -- Wrapper around wsh_trip_stops_pub.Stop_Action for deleting stops
121 -- PROCEDURE : Stop_Action
122 -- p_action_code 'DELETE'
123 PROCEDURE Stop_Action
124 ( p_api_version_number IN NUMBER,
125 p_init_msg_list IN VARCHAR2,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_action_code IN VARCHAR2,
130 p_stop_id IN NUMBER DEFAULT NULL,
131 p_trip_id IN NUMBER DEFAULT NULL,
132 p_trip_name IN VARCHAR2 DEFAULT NULL,
133 p_stop_location_id IN NUMBER DEFAULT NULL,
134 p_stop_location_code IN VARCHAR2 DEFAULT NULL,
135 p_planned_dep_date IN DATE DEFAULT NULL,
136 p_actual_date IN DATE DEFAULT NULL,
137 p_defer_interface_flag IN VARCHAR2 DEFAULT 'Y');
138
139 -- Wrapper around WSH_DELIVERIES_PUB.Delivery_Action for assign/unassign to trip
140 -- PROCEDURE Delivery_Action
141 -- p_action_code will be either 'ASSIGN-TRIP','UNASSIGN-TRIP'
142 PROCEDURE Delivery_Action
143 ( p_api_version_number IN NUMBER,
144 p_init_msg_list IN VARCHAR2,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_action_code IN VARCHAR2,
149 p_delivery_id IN NUMBER DEFAULT NULL,
150 p_delivery_name IN VARCHAR2 DEFAULT NULL,
151 p_asg_trip_id IN NUMBER DEFAULT NULL,
152 p_asg_trip_name IN VARCHAR2 DEFAULT NULL,
153 p_asg_pickup_stop_id IN NUMBER DEFAULT NULL,
154 p_asg_pickup_loc_id IN NUMBER DEFAULT NULL,
155 p_asg_pickup_loc_code IN VARCHAR2 DEFAULT NULL,
156 p_asg_pickup_arr_date IN DATE DEFAULT NULL,
157 p_asg_pickup_dep_date IN DATE DEFAULT NULL,
158 p_asg_dropoff_stop_id IN NUMBER DEFAULT NULL,
159 p_asg_dropoff_loc_id IN NUMBER DEFAULT NULL,
160 p_asg_dropoff_loc_code IN VARCHAR2 DEFAULT NULL,
161 p_asg_dropoff_arr_date IN DATE DEFAULT NULL,
162 p_asg_dropoff_dep_date IN DATE DEFAULT NULL,
163 p_sc_action_flag IN VARCHAR2 DEFAULT 'S',
164 p_sc_intransit_flag IN VARCHAR2 DEFAULT 'N',
165 p_sc_close_trip_flag IN VARCHAR2 DEFAULT 'N',
166 p_sc_create_bol_flag IN VARCHAR2 DEFAULT 'N',
167 p_sc_stage_del_flag IN VARCHAR2 DEFAULT 'Y',
168 p_sc_trip_ship_method IN VARCHAR2 DEFAULT NULL,
169 p_sc_actual_dep_date IN DATE DEFAULT NULL,
170 p_sc_report_set_id IN NUMBER DEFAULT NULL,
171 p_sc_report_set_name IN VARCHAR2 DEFAULT NULL,
172 p_sc_defer_interface_flag IN VARCHAR2 DEFAULT 'Y',
173 p_wv_override_flag IN VARCHAR2 DEFAULT 'N',
174 x_trip_id OUT NOCOPY VARCHAR2,
175 x_trip_name OUT NOCOPY VARCHAR2,
176 x_delivery_leg_id OUT NOCOPY NUMBER,
177 x_delivery_leg_seq OUT NOCOPY NUMBER
178 );
179
180 PROCEDURE Create_Update_Trip
181
182 ( p_api_version_number IN NUMBER,
183 p_init_msg_list IN VARCHAR2,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 x_trip_id OUT NOCOPY NUMBER,
188 x_trip_name OUT NOCOPY VARCHAR2,
189 p_action_code IN VARCHAR2,
190 p_rec_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
191 p_rec_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
192 p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
193 p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
194 p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
195 p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
196 p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
197 p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
198 p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
199 p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
200 p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
201 p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
202 p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
203 p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
204 p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
205 p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
206 p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
207 p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
208 p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
209 p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
210 p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
211 p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
212 p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
213 p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
214 p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
215 p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
216 p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
217 p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
218 p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
219 p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
220 p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
221 p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
222 p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
223 p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
224 p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
225 p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
226 p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
227 p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
228 p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
229 p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
230 p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
231 p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
232 p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
233 p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
234 p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
235 p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
236 p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
237 p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
238 p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
239 p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
240 p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
241 p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
242 p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
243 p_carrier_contact_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
244 p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
245 p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
246 p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
247 p_wf_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
248 p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
249 p_wf_item_key IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
250 p_load_tender_number IN NUMBER DEFAULT FND_API.G_MISS_NUM,
251 p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
252 p_autoaccept IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
253 p_url IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
254 p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
255 p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
256 p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
257 p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
258 p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
259 p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
260 p_rec_APPEND_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
261 p_rec_RANK_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
262 );
263
264
265
266 --========================================================================
267 -- PROCEDURE : Create_Update_Trip FTE wrapper
268 --
269 -- COMMENT : Wrapper around WSH_TRIPS_PUB.Create_Update_Trip
270 -- Passes in all the parameters reqd (record type input changed to
271 -- number of parameters which are collected, assigned to a record
272 -- and call WSH_TRIPS_PUB.Create_Update_Trip
273 -- MODIFIED 09/04/2002 HBHAGAVA
274 -- Added new paramters for Load Tender
275 -- p_rec_tender_id
276 -- p_delivery_leg_ids
277 --========================================================================
278 PROCEDURE Create_Update_Trip
279 ( p_api_version_number IN NUMBER,
280 p_init_msg_list IN VARCHAR2,
281 x_return_status OUT NOCOPY VARCHAR2,
282 x_msg_count OUT NOCOPY NUMBER,
283 x_msg_data OUT NOCOPY VARCHAR2,
284 x_trip_id OUT NOCOPY NUMBER,
285 x_trip_name OUT NOCOPY VARCHAR2,
286 x_CREATION_DATE OUT NOCOPY DATE,
287 x_CREATED_BY OUT NOCOPY NUMBER,
288 x_LAST_UPDATE_DATE OUT NOCOPY DATE,
289 x_LAST_UPDATED_BY OUT NOCOPY NUMBER,
290 x_LAST_UPDATE_LOGIN OUT NOCOPY NUMBER,
291 p_action_code IN VARCHAR2,
292 p_rec_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
293 p_rec_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
294 p_rec_ARRIVE_AFTER_TRIP_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
295 p_rec_ARRIVE_AFTER_TRIP_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
296 p_rec_VEHICLE_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
297 p_rec_VEHICLE_ITEM_DESC IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
298 p_rec_VEHICLE_ORGANIZATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
299 p_rec_VEHICLE_ORGANIZATION_COD IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
300 p_rec_VEHICLE_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
301 p_rec_VEHICLE_NUM_PREFIX IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
302 p_rec_CARRIER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
303 p_rec_SHIP_METHOD_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
304 p_rec_SHIP_METHOD_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
305 p_rec_ROUTE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
306 p_rec_ROUTING_INSTRUCTIONS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
307 p_rec_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
308 p_rec_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
309 p_rec_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
310 p_rec_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
311 p_rec_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
312 p_rec_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
313 p_rec_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
314 p_rec_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
315 p_rec_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
316 p_rec_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
317 p_rec_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
318 p_rec_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
319 p_rec_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
320 p_rec_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
324 p_rec_MODE_OF_TRANSPORT IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
321 p_rec_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
322 p_rec_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
323 p_rec_SERVICE_LEVEL IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
325 p_rec_CONSOLIDATION_ALLOWED IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
326 p_rec_PLANNED_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
327 p_rec_STATUS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
328 p_rec_FREIGHT_TERMS_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
329 p_rec_LOAD_TENDER_STATUS IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
330 p_rec_ROUTE_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
331 p_rec_LANE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
332 p_rec_SCHEDULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
333 p_rec_BOOKING_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
334 p_rec_CREATION_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
335 p_rec_CREATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
336 p_rec_LAST_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
337 p_rec_LAST_UPDATED_BY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
338 p_rec_LAST_UPDATE_LOGIN IN NUMBER DEFAULT FND_API.G_MISS_NUM,
339 p_rec_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
340 p_rec_PROGRAM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
341 p_rec_PROGRAM_UPDATE_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
342 p_rec_REQUEST_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
343 p_carrier_contact_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
344 p_shipper_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
345 p_shipper_wait_time IN NUMBER DEFAULT FND_API.G_MISS_NUM,
346 p_wait_time_uom IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
347 p_action IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
348 p_carrier_remarks IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
349 p_operator IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
350 p_rec_IGNORE_FOR_PLANNING IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
351 p_rec_CONSIGNEE_CAR_AC_NO IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
352 p_rec_CARRIER_REF_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
353 p_rec_ROUTING_RULE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
354 p_rec_APPEND_FLAG IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
355 p_rec_RANK_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM
356 );
357
358
359
360 --========================================================================
361 -- PROCEDURE : Trip_Action FTE wrapper
362 --========================================================================
363
364 PROCEDURE Trip_Action
365 ( p_api_version_number IN NUMBER,
366 p_init_msg_list IN VARCHAR2,
367 x_return_status OUT NOCOPY VARCHAR2,
368 x_msg_count OUT NOCOPY NUMBER,
369 x_msg_data OUT NOCOPY VARCHAR2,
370 p_action_code IN VARCHAR2,
371 p_trip_id IN NUMBER DEFAULT NULL,
372 p_trip_name IN VARCHAR2 DEFAULT NULL,
373 p_wv_override_flag IN VARCHAR2 DEFAULT 'N');
374 --
375 --
376
377 --========================================================================
378 -- Added Following procedure for PACK J
379 --========================================================================
380
381
382 --========================================================================
383 -- PROCEDURE : TRIP_ACTION Wrapper API PUBLIC
384 --
385 -- PARAMETERS: p_api_version_number known api version error number
386 -- p_init_msg_list FND_API.G_TRUE to reset list
387 -- p_trip_id_tab table of trip id's
388 -- p_action_prms Record of caller, phase, action_code and other
389 -- parameters specific to the actions.
390 -- x_action_out_rec Out rec based on actions.
391 -- x_return_status return status
392 -- x_msg_count number of messages in the list
393 -- x_msg_data text of messages
394 -- VERSION : current version 1.0
395 -- initial version 1.0
396 --========================================================================
397
398 PROCEDURE Trip_Action
399 ( p_api_version_number IN NUMBER,
400 p_init_msg_list IN VARCHAR2,
401 p_trip_id_tab IN FTE_ID_TAB_TYPE,
402 p_action_prms IN FTE_TRIP_ACTION_PARAM_REC,
403 x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC,
404 x_return_status OUT NOCOPY VARCHAR2,
405 x_msg_count OUT NOCOPY NUMBER,
406 x_msg_data OUT NOCOPY VARCHAR2
407 );
408
409
410 --========================================================================
411 -- PROCEDURE : STOP_ACTION Wrapper API PUBLIC
412 --
413 -- PARAMETERS: p_api_version_number known api version error number
414 -- p_init_msg_list FND_API.G_TRUE to reset list
415 -- p_stop_id_tab table of stop id's
416 -- p_action_prms Record of caller, phase, action_code and other
417 -- parameters specific to the actions.
418 -- x_action_out_rec Out rec based on actions.
422 -- VERSION : current version 1.0
419 -- x_return_status return status
420 -- x_msg_count number of messages in the list
421 -- x_msg_data text of messages
423 -- initial version 1.0
424 --========================================================================
425
426 PROCEDURE STOP_ACTION
427 ( p_api_version_number IN NUMBER,
428 p_init_msg_list IN VARCHAR2,
429 p_stop_id_tab IN FTE_ID_TAB_TYPE,
430 p_action_prms IN FTE_STOP_ACTION_PARAM_REC,
431 x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC,
432 x_return_status OUT NOCOPY VARCHAR2,
433 x_msg_count OUT NOCOPY NUMBER,
434 x_msg_data OUT NOCOPY VARCHAR2
435 );
436
437
438 PROCEDURE INIT_STOPS_PLS_TABLE
439 ( p_api_version_number IN NUMBER,
440 p_init_msg_list IN VARCHAR2,
441 x_return_status OUT NOCOPY VARCHAR2,
442 x_msg_count OUT NOCOPY NUMBER,
443 x_msg_data OUT NOCOPY VARCHAR2
444 );
445
446 PROCEDURE CREATE_UPDATE_STOP
447 (
448 p_api_version_number IN NUMBER,
449 p_init_msg_list IN VARCHAR2,
450 p_commit IN VARCHAR2,
451 p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
452 p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
453 x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,
454 x_return_status OUT NOCOPY VARCHAR2,
455 x_msg_count OUT NOCOPY NUMBER,
456 x_msg_data OUT NOCOPY VARCHAR2
457 );
458
459 PROCEDURE PROCESS_STOPS(
460 p_api_version_number IN NUMBER,
461 p_init_msg_list IN VARCHAR2,
462 p_commit IN VARCHAR2,
463 x_stop_out_tab OUT NOCOPY FTE_ID_TAB_TYPE,
464 x_stop_seq_tab OUT NOCOPY FTE_ID_TAB_TYPE,
465 x_return_status OUT NOCOPY VARCHAR2,
466 x_msg_count OUT NOCOPY NUMBER,
467 x_msg_data OUT NOCOPY VARCHAR2
468 );
469
470
471 PROCEDURE REPRICE_TRIP (
472 p_api_version IN NUMBER DEFAULT 1.0,
473 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
474 p_trip_id IN NUMBER,
475 x_return_status OUT NOCOPY VARCHAR2,
476 x_msg_count OUT NOCOPY NUMBER,
477 x_msg_data OUT NOCOPY VARCHAR2
478 );
479 --
480 PROCEDURE Delivery_Detail_Action
481 ( p_api_version_number IN NUMBER,
482 p_init_msg_list IN VARCHAR2,
483 p_mls_id_tab IN FTE_ID_TAB_TYPE,
484 p_action_params IN FTE_DDL_ACTION_PARAM_REC,
485 x_return_status OUT NOCOPY VARCHAR2,
486 x_msg_count OUT NOCOPY NUMBER,
487 x_msg_data OUT NOCOPY VARCHAR2,
488 x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC
489 );
490 --
491 PROCEDURE Create_Update_Delivery_Detail
492 (
493 p_api_version_number IN NUMBER,
494 p_init_msg_list IN VARCHAR2,
495 p_commit IN VARCHAR2,
496 p_detail_info_tab IN FTE_DDL_ATTR_TAB_TYPE,
497 p_action_code IN VARCHAR2,
498 x_return_status OUT NOCOPY VARCHAR2,
499 x_msg_count OUT NOCOPY NUMBER,
500 x_msg_data OUT NOCOPY VARCHAR2,
501 x_detail_id_tab OUT NOCOPY FTE_ID_TAB_TYPE
502 );
503 --
504 PROCEDURE Delivery_Action
505 ( p_api_version_number IN NUMBER,
506 p_init_msg_list IN VARCHAR2,
507 p_mls_id_tab IN FTE_ID_TAB_TYPE,
508 p_action_params IN FTE_DLV_ACTION_PARAM_REC,
509 x_return_status OUT NOCOPY VARCHAR2,
510 x_msg_count OUT NOCOPY NUMBER,
511 x_msg_data OUT NOCOPY VARCHAR2,
512 x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC
513 );
514 --
515 PROCEDURE Delivery_Action_On_Trip
516 ( p_api_version_number IN NUMBER,
517 p_init_msg_list IN VARCHAR2,
518 p_mls_delivery_id_tab IN FTE_ID_TAB_TYPE,
519 p_mls_trip_id_tab IN FTE_ID_TAB_TYPE,
520 p_action_params IN FTE_DLV_ACTION_PARAM_REC,
521 x_return_status OUT NOCOPY VARCHAR2,
522 x_msg_count OUT NOCOPY NUMBER,
523 x_msg_data OUT NOCOPY VARCHAR2,
524 x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC
525 );
526 --
527 PROCEDURE Create_Update_Delivery
528 ( p_api_version_number IN NUMBER,
529 p_init_msg_list IN VARCHAR2,
530 p_commit IN VARCHAR2,
531 p_dlvy_info_tab IN FTE_DLV_ATTR_TAB_TYPE,
532 p_action_code IN VARCHAR2,
533 x_return_status OUT NOCOPY VARCHAR2,
534 x_msg_count OUT NOCOPY NUMBER,
535 x_msg_data OUT NOCOPY VARCHAR2,
536 x_dlvy_id_tab OUT NOCOPY FTE_ID_TAB_TYPE
537 );
538 --
539 PROCEDURE Exception_Action
540 ( p_api_version_number IN NUMBER,
541 p_init_msg_list IN VARCHAR2,
542 p_validation_level IN NUMBER,
543 p_commit IN VARCHAR2,
544 p_action IN VARCHAR2,
545 p_xc_action_tab IN FTE_XC_ACTION_TAB_TYPE,
546 x_return_status OUT NOCOPY VARCHAR2,
547 x_msg_count OUT NOCOPY NUMBER,
548 x_msg_data OUT NOCOPY VARCHAR2,
549 x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC
550 );
551 --
552 PROCEDURE GROUP_DETAIL_SEARCH_DLVY
553 ( p_api_version_number IN NUMBER,
554 p_init_msg_list IN VARCHAR2,
555 p_commit IN VARCHAR2,
556 p_id_tab IN FTE_ID_TAB_TYPE,
560 );
557 x_return_status OUT NOCOPY VARCHAR2,
558 x_msg_count OUT NOCOPY NUMBER,
559 x_msg_data OUT NOCOPY VARCHAR2
561 --
562
563 PROCEDURE Get_Disabled_List
564 ( p_entity_type IN VARCHAR2,
565 p_entity_id IN NUMBER,
566 p_parent_entity_id In NUMBER DEFAULT NULL,
567 x_disabled_list OUT NOCOPY FTE_NAME_TAB_TYPE,
568 x_return_status OUT NOCOPY VARCHAR2,
569 x_msg_count OUT NOCOPY NUMBER,
570 x_msg_data OUT NOCOPY VARCHAR2
571 );
572 --
573 --**************************************************************************
574 -- Rel 12
575 --***************************************************************************
576 --========================================================================
577 -- PROCEDURE : TRIP_ACTION Wrapper API PUBLIC
578 -- Added for Rel 12
579 --
580 -- PARAMETERS: p_api_version_number known api version error number
581 -- p_init_msg_list FND_API.G_TRUE to reset list
582 -- x_return_status return status
583 -- x_msg_count number of messages in the list
584 -- x_msg_data text of messages
585 -- x_action_out_rec Out rec based on actions.
586 -- p_trip_info_rec trip id record
587 -- p_action_prms Record of caller, phase, action_code and other
588 -- parameters specific to the actions.
589 -- VERSION : current version 1.0
590 -- initial version 1.0
591 --========================================================================
592
593 PROCEDURE Trip_Action
594 ( p_api_version_number IN NUMBER,
595 p_init_msg_list IN VARCHAR2,
596 x_return_status OUT NOCOPY VARCHAR2,
597 x_msg_count OUT NOCOPY NUMBER,
598 x_msg_data OUT NOCOPY VARCHAR2,
599 x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC,
600 p_trip_info_rec IN FTE_TENDER_ATTR_REC,
601 p_action_prms IN FTE_TRIP_ACTION_PARAM_REC
602 );
603 --
604
605 --***************************************************************************
606 --========================================================================
607 -- PROCEDURE : TRIP_ACTION Wrapper API PUBLIC
608 -- Added for Rel 12
609 --
610 -- PARAMETERS: p_api_version_number known api version error number
611 -- p_init_msg_list FND_API.G_TRUE to reset list
612 -- x_return_status return status
613 -- x_msg_count number of messages in the list
614 -- x_msg_data text of messages
615 -- x_action_out_rec Out rec based on actions.
616 -- p_tripId trip id
617 -- p_action_prms Record of caller, phase, action_code and other
618 -- parameters specific to the actions.
619 -- VERSION : current version 1.0
620 -- initial version 1.0
621 --========================================================================
622 -- HBHAGAVA Rel12
623 -- This procedure is used to handle trip actions give a trip id
624 PROCEDURE Trip_Action
625 ( p_api_version_number IN NUMBER,
626 p_init_msg_list IN VARCHAR2,
627 x_return_status OUT NOCOPY VARCHAR2,
628 x_msg_count OUT NOCOPY NUMBER,
629 x_msg_data OUT NOCOPY VARCHAR2,
630 x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC,
631 p_tripId IN NUMBER,
632 p_action_prms IN FTE_TRIP_ACTION_PARAM_REC
633 );
634
635
636 --
637 PROCEDURE UPDATE_SERVICE_ON_TRIP
638 (
639 p_API_VERSION_NUMBER IN NUMBER,
640 p_INIT_MSG_LIST IN VARCHAR2,
641 p_COMMIT IN VARCHAR2,
642 p_CALLER IN VARCHAR2,
643 p_SERVICE_ACTION IN VARCHAR2,
644 p_DELIVERY_ID IN NUMBER,
645 p_DELIVERY_LEG_ID IN NUMBER,
646 p_TRIP_ID IN NUMBER,
647 p_LANE_ID IN NUMBER,
648 p_SCHEDULE_ID IN NUMBER,
649 p_CARRIER_ID IN NUMBER,
650 p_SERVICE_LEVEL IN VARCHAR2,
651 p_MODE_OF_TRANSPORT IN VARCHAR2,
652 p_VEHICLE_ITEM_ID IN NUMBER,
653 p_VEHICLE_ORG_ID IN NUMBER,
654 p_CONSIGNEE_CARRIER_AC_NO IN VARCHAR2,
655 p_FREIGHT_TERMS_CODE IN VARCHAR2,
656 x_RETURN_STATUS OUT NOCOPY VARCHAR2,
657 x_MSG_COUNT OUT NOCOPY NUMBER,
658 x_MSG_DATA OUT NOCOPY VARCHAR2
659 );
660
661 PROCEDURE INITIALIZE_TRIP_REC(x_trip_info OUT NOCOPY WSH_TRIPS_PVT.Trip_Rec_Type);
662
663
664 --
665 END FTE_MLS_WRAPPER;