[Home] [Help]
PACKAGE: APPS.WSH_DELIVERIES_GRP
Source
1 PACKAGE WSH_DELIVERIES_GRP as
2 /* $Header: WSHDEGPS.pls 120.1.12000000.2 2007/10/04 08:17:21 arimukhe ship $ */
3
4 --===================
5 -- PUBLIC VARS
6 --===================
7
8 -- Bug 6369687: Adding variable to get the action on the delivery
9 G_ACTION VARCHAR2(30) := NULL;
10
11 TYPE Delivery_Pub_Rec_Type IS RECORD (
12 DELIVERY_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
13 NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
14 DELIVERY_TYPE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
15 LOADING_SEQUENCE NUMBER DEFAULT FND_API.G_MISS_NUM,
16 LOADING_ORDER_FLAG VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
17 LOADING_ORDER_DESC VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
18 INITIAL_PICKUP_DATE DATE DEFAULT FND_API.G_MISS_DATE,
19 INITIAL_PICKUP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20 INITIAL_PICKUP_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
21 ORGANIZATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
22 ORGANIZATION_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
23 ULTIMATE_DROPOFF_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
24 ULTIMATE_DROPOFF_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
25 ULTIMATE_DROPOFF_DATE DATE DEFAULT FND_API.G_MISS_DATE,
26 CUSTOMER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
27 CUSTOMER_NUMBER VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
28 INTMED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
29 INTMED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
30 POOLED_SHIP_TO_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
31 POOLED_SHIP_TO_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
32 CARRIER_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
33 CARRIER_CODE VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
34 SHIP_METHOD_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
35 SHIP_METHOD_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
36 FREIGHT_TERMS_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
37 FREIGHT_TERMS_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
38 FOB_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
39 FOB_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
40 FOB_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
41 FOB_LOCATION_CODE VARCHAR2(20) DEFAULT FND_API.G_MISS_CHAR,
42 WAYBILL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
43 DOCK_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44 ACCEPTANCE_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
45 ACCEPTED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46 ACCEPTED_DATE DATE DEFAULT FND_API.G_MISS_DATE,
47 ACKNOWLEDGED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48 CONFIRMED_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49 CONFIRM_DATE DATE DEFAULT FND_API.G_MISS_DATE,
50 ASN_DATE_SENT DATE DEFAULT FND_API.G_MISS_DATE,
51 ASN_STATUS_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
52 ASN_SEQ_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,
53 GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
54 NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
55 WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
56 WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
57 VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
58 VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
59 VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
60 ADDITIONAL_SHIPMENT_INFO VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
61 CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
62 CURRENCY_NAME VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
63 ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64 ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65 ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66 ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67 ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68 ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69 ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70 ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71 ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72 ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73 ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74 ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75 ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76 ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77 ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78 ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79 TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
80 TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
81 TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
82 TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
83 TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
84 TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
85 TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
86 TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
87 TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
88 TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
89 TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
90 TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
91 TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92 TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93 TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94 TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95 GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
96 GLOBAL_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97 GLOBAL_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98 GLOBAL_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99 GLOBAL_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100 GLOBAL_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101 GLOBAL_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102 GLOBAL_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103 GLOBAL_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104 GLOBAL_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105 GLOBAL_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106 GLOBAL_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107 GLOBAL_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
108 GLOBAL_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
109 GLOBAL_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
110 GLOBAL_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
111 GLOBAL_ATTRIBUTE16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
112 GLOBAL_ATTRIBUTE17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
113 GLOBAL_ATTRIBUTE18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
114 GLOBAL_ATTRIBUTE19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
115 GLOBAL_ATTRIBUTE20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116 CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
117 CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
118 LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
119 LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
120 LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
121 PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
122 PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
123 PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
124 REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
125 /* Changes done for the shipping data model Bugfix#1918342*/
126 COD_AMOUNT NUMBER DEFAULT FND_API.G_MISS_NUM,
127 COD_CURRENCY_CODE VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
128 COD_REMIT_TO VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
129 COD_CHARGE_PAID_BY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
130 PROBLEM_CONTACT_REFERENCE VARCHAR2(500) DEFAULT FND_API.G_MISS_CHAR,
131 PORT_OF_LOADING VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
132 PORT_OF_DISCHARGE VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
133 FTZ_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
134 ROUTED_EXPORT_TXN VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
135 ENTRY_NUMBER VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
136 ROUTING_INSTRUCTIONS VARCHAR2(120) DEFAULT FND_API.G_MISS_CHAR,
137 IN_BOND_CODE VARCHAR2(35) DEFAULT FND_API.G_MISS_CHAR,
138 SHIPPING_MARKS VARCHAR2(100) DEFAULT FND_API.G_MISS_CHAR,
139 SERVICE_LEVEL VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140 MODE_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141 ASSIGNED_TO_FTE_TRIPS VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
142 /*BUG 3667348*/
143 REASON_OF_TRANSPORT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
144 DESCRIPTION VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
145 --Non Database field added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
146 PRORATE_WT_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
147 );
148
149 -- I Harmonization: rvishnuv ******* Actions ******
150
151 TYPE default_parameters_rectype is RECORD(
152 autointransit_flag VARCHAR2(1) ,
153 autoclose_flag VARCHAR2(1) ,
154 report_set_id NUMBER ,
155 report_set_name VARCHAR2(30) ,
156 ship_method_name VARCHAR2(240) ,
157 enforce_ship_method VARCHAR2(1),
158 defer_interface_flag VARCHAR2(1),
159 trip_id_tab wsh_util_core.id_tab_type,
160 ac_bol_flag VARCHAR2(1),
161 sc_rule_id NUMBER,
162 sc_rule_name VARCHAR2(30)
163 );
164
165 TYPE action_parameters_rectype is RECORD (
166 caller VARCHAR2(50),
167 phase NUMBER,
168 action_code VARCHAR2(30),
169 trip_id NUMBER , --|
170 trip_name VARCHAR2(30) , --|
171 pickup_stop_id NUMBER , --|
172 pickup_loc_id NUMBER , --|
173 pickup_stop_seq NUMBER , --|
174 pickup_loc_code VARCHAR2(80) , --|
175 pickup_arr_date DATE , --| All these parameters
176 pickup_dep_date DATE , --| are used for the
177 pickup_stop_status VARCHAR2(2), --|
178 dropoff_stop_id NUMBER , --| Action
179 dropoff_loc_id NUMBER , --| 'UNASSIGN-TRIP'
180 dropoff_stop_seq NUMBER , --|
181 dropoff_loc_code VARCHAR2(80) , --|
182 dropoff_arr_date DATE , --|
183 dropoff_dep_date DATE , --|
184 dropoff_stop_status VARCHAR2(2), --|
185 action_flag VARCHAR2(1),
186 intransit_flag VARCHAR2(1),
187 close_trip_flag VARCHAR2(1) ,
188 stage_del_flag VARCHAR2(1),
189 bill_of_lading_flag VARCHAR2(1),
190 mc_bill_of_lading_flag VARCHAR2(1),
191 override_flag VARCHAR2(1),
192 defer_interface_flag VARCHAR2(1),
193 ship_method_code VARCHAR2(240) ,
194 actual_dep_date DATE ,
195 report_set_id NUMBER ,
196 report_set_name VARCHAR2(30) ,
197 send_945_flag VARCHAR2(1) ,
198 sc_rule_id NUMBER ,
199 sc_rule_name VARCHAR2(30) ,
200 action_type VARCHAR2(1) ,
201 document_type VARCHAR2(2) ,
202 organization_id NUMBER ,
203 reason_of_transport VARCHAR2(30),
204 description VARCHAR2(30),
205 maxDelivs NUMBER, /* Pack J : max number of deliveries that can be grouped into a trip */
206 ignore_ineligible_dels VARCHAR2(1),
207 event VARCHAR2(1) ,
208 form_flag VARCHAR2(1) /* Pack J : select carrier when appending limit has been reached */ );
209
210 TYPE Delivery_Action_Out_Rec_Type is RECORD (
211 packing_slip_number VARCHAR2(50),
212 valid_ids_tab wsh_util_core.id_tab_type,
213 result_id_tab wsh_util_core.id_tab_type,
214 selection_issue_flag VARCHAR2(1),
215 num_success_delivs NUMBER /* Pack J : number of deliveries that were successfully grouped into trips */
216 );
217 -- I Harmonization: rvishnuv ******* Actions ******
218
219 -- I Harmonization: rvishnuv ******* Create/Update ******
220
221 TYPE Del_In_Rec_Type is RECORD (
222 caller VARCHAR2(50),
223 phase NUMBER,
224 action_code VARCHAR2(30));
225
226 TYPE Del_Out_Rec_Type is RECORD (
227 delivery_id NUMBER,
228 name VARCHAR2(30),
229 rowid VARCHAR2(4000));
230
231 TYPE Del_Out_Tbl_Type IS Table of Del_Out_Rec_Type INDEX BY BINARY_INTEGER;
232
233 -- I Harmonization: rvishnuv ******* Create/Update ******
234
235
236
237 --===================
238 -- PROCEDURES
239 --===================
240
241 -- I Harmonization: rvishnuv ******* Actions ******
242 --========================================================================
243 -- PROCEDURE : Delivery_Action Must be called only by the Form
244 -- and the Wrapper Group API.
245 --
246 -- PARAMETERS: p_api_version known api version error number
247 -- p_init_msg_list FND_API.G_TRUE to reset list
248 -- x_return_status return status
249 -- x_msg_count number of messages in the list
250 -- x_msg_data text of messages
251 -- p_action_prms Record of caller, phase, action_code and other
252 -- parameters specific to the actions.
253 -- p_rec_attr_tab Table of attributes for the delivery entity
254 -- x_request_id_tab Table of Request Ids returned by the
255 -- action 'PICK-RELEASE'
256 -- x_result_id_tab Table of result ids.
257 -- x_valid_ids_tab Table of valid indexes or ids. If the caller is STF,
258 -- it contains table of valid indexes, else it contains
259 -- table of valid ids.
260 -- x_selection_issue_flag It is a form specific out parameter. It set to 'Y', if
261 -- the Validations in phase 1 return a 'warning'.
262 -- x_defaults_rec Record of Default Parameters that passed for the actions
263 -- 'CONFIRM', 'UNASSIGN-TRIP'.
264 -- x_delivery_out_rec Record of output parameters based on the actions.
265 -- VERSION : current version 1.0
266 -- initial version 1.0
267 -- COMMENT : This procedure is used to perform an action specified
268 -- in p_action_prms.action_code on an existing delivery identified
269 -- by p_rec_attr.delivery_id.
270 --========================================================================
271 PROCEDURE Delivery_Action
272 ( p_api_version_number IN NUMBER,
273 p_init_msg_list IN VARCHAR2,
274 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
275 p_action_prms IN action_parameters_rectype,
276 p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type ,
277 x_delivery_out_rec OUT NOCOPY Delivery_Action_Out_Rec_Type,
278 x_defaults_rec OUT NOCOPY default_parameters_rectype,
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_msg_count OUT NOCOPY NUMBER,
281 x_msg_data OUT NOCOPY VARCHAR2
282 );
283
284 -- I Harmonization: rvishnuv ******* Actions ******
285
286 -- I Harmonization: rvishnuv ******* Create/Update ******
290 --
287 --========================================================================
288 -- PROCEDURE : Create_Update_Delivery Must be called only by the Form
289 -- and the Wrapper Group API.
291 -- PARAMETERS: p_api_version known api version error buffer
292 -- p_init_msg_list FND_API.G_TRUE to reset list
293 -- x_return_status return status
294 -- x_msg_count number of messages in the list
295 -- x_msg_data text of messages
296 -- p_in_rec Record for caller, phase
297 -- and action_code ( CREATE-UPDATE )
298 -- p_rec_attr_tab Table of attributes for the delivery entity
299 -- x_del_out_rec_tab Table of delivery_id, and name of new deliveries,
300 -- VERSION : current version 1.0
301 -- initial version 1.0
302 -- COMMENT : Creates or updates a record in wsh_new_deliveries table with information
303 -- specified in p_delivery_info
304 --========================================================================
305 PROCEDURE Create_Update_Delivery
306 ( p_api_version_number IN NUMBER,
307 p_init_msg_list IN VARCHAR2,
308 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
309 p_in_rec IN del_In_Rec_Type,
310 p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
311 x_del_out_rec_tab OUT NOCOPY Del_Out_Tbl_Type,
312 x_return_status OUT NOCOPY VARCHAR2,
313 x_msg_count OUT NOCOPY NUMBER,
314 x_msg_data OUT NOCOPY VARCHAR2);
315 --========================================================================
316
317 -- I Harmonization: rvishnuv ******* Create/Update ******
318
319 -- The below procedue will be obsoleted after patchset I.
320
321 --========================================================================
322 -- PROCEDURE : Create_Update_Delivery PUBLIC
323 --
324 -- PARAMETERS: p_api_version_number known api versionerror buffer
325 -- p_init_msg_list FND_API.G_TRUE to reset list
326 -- x_return_status return status
327 -- x_msg_count number of messages in the list
328 -- x_msg_data text of messages
329 -- p_delivery_info Attributes for the delivery entity
330 -- p_delivery_name Delivery name for update
331 -- x_delivery_id - delivery_Id of new delivery,
332 -- x_name - Name of delivery
333 -- VERSION : current version 1.0
334 -- initial version 1.0
335 -- COMMENT : Creates or updates a record in wsh_new_deliveries table with information
336 -- specified in p_delivery_info
337 --========================================================================
338 PROCEDURE Create_Update_Delivery
339 ( p_api_version_number IN NUMBER,
340 p_init_msg_list IN VARCHAR2,
341 x_return_status OUT NOCOPY VARCHAR2,
342 x_msg_count OUT NOCOPY NUMBER,
343 x_msg_data OUT NOCOPY VARCHAR2,
344 p_action_code IN VARCHAR2,
345 p_delivery_info IN OUT NOCOPY Delivery_Pub_Rec_Type,
346 p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
347 x_delivery_id OUT NOCOPY NUMBER,
348 x_name OUT NOCOPY VARCHAR2);
349
350
351 --========================================================================
352
353 -- The below procedue will be obsoleted after patchset I.
354 --========================================================================
355 -- PROCEDURE : Delivery_Action PUBLIC
356 --
357 -- PARAMETERS: p_api_version_number known api version error number
358 -- p_init_msg_list FND_API.G_TRUE to reset list
359 -- x_return_status return status
360 -- x_msg_count number of messages in the list
361 -- x_msg_data text of messages
362 -- p_action_code Delivery action code. Valid action codes are
363 -- 'PLAN','UNPLAN',
364 -- 'PACK','CONFIRM','RE-OPEN','IN-TRANSIT','CLOSE'
365 -- 'ASSIGN-TRIP','UNASSIGN-TRIP','AUTOCREATE-TRIP'
366 -- 'WT-VOL',
367 -- 'PICK-RELEASE',
368 -- 'DELETE'
369 -- p_delivery_id Delivery identifier
370 -- p_delivery_name Delivery name
371 -- p_asg_trip_id Trip identifier for assignment
372 -- p_asg_trip_name Trip name for assignment
373 -- p_asg_pickup_stop_id Stop id for pickup assignment
374 -- p_asg_pickup_loc_id Stop location for pickup assignment
375 -- p_asg_pickup_loc_code Stop location code for pickup assignment
376 -- p_asg_pickup_arr_date Stop location arrival date for pickup assignment
377 -- p_asg_pickup_dep_date Stop location departure date for pickup assignment
378 -- p_asg_dropoff_stop_id Stop id for dropoff assignment
379 -- p_asg_dropoff_loc_id Stop location for dropoff assignment
380 -- p_asg_dropoff_loc_code Stop location code for dropoff assignment
381 -- p_asg_dropoff_arr_date Stop location arrival date for dropoff assignment
382 -- p_asg_dropoff_dep_date Stop location departure date for dropoff assignment
383 -- p_sc_action_flag Ship Confirm option - 'S', 'B', 'T', 'A', 'C'
384 -- p_sc_intransit_flag Ship Confirm set in-transit flag
385 -- p_sc_close_trip_flag Ship Confirm close trip flag
386 -- p_sc_create_bol_flag Ship Confirm create BOL flag
387 -- p_sc_stage_del_flag Ship Confirm create delivery for stage qnt flag
388 -- p_sc_trip_ship_method Ship Confirm trip ship method
389 -- p_sc_actual_dep_date Ship Confirm actual departure date
390 -- p_sc_report_set_id Ship Confirm report set id
391 -- p_sc_report_set_name Ship Confirm report set name
392 -- p_wv_override_flag Override flag for weight/volume calc
393 -- x_trip_id Autocreated trip id
394 -- x_trip_name Autocreated trip name
395 -- VERSION : current version 1.0
396 -- initial version 1.0
397 -- COMMENT : This procedure is used to perform an action specified in p_action_code
398 -- on an existing delivery identified by p_delivery_id/p_delivery_name.
399 --========================================================================
400
401 PROCEDURE Delivery_Action
402 ( p_api_version_number IN NUMBER,
403 p_init_msg_list IN VARCHAR2,
404 x_return_status OUT NOCOPY VARCHAR2,
405 x_msg_count OUT NOCOPY NUMBER,
406 x_msg_data OUT NOCOPY VARCHAR2,
407 p_action_code IN VARCHAR2,
408 p_delivery_id IN NUMBER DEFAULT NULL,
409 p_delivery_name IN VARCHAR2 DEFAULT NULL,
410 p_asg_trip_id IN NUMBER DEFAULT NULL,
411 p_asg_trip_name IN VARCHAR2 DEFAULT NULL,
412 p_asg_pickup_stop_id IN NUMBER DEFAULT NULL,
413 p_asg_pickup_loc_id IN NUMBER DEFAULT NULL,
414 p_asg_pickup_stop_seq IN NUMBER DEFAULT NULL,/*h integration anxsharm*/
415 p_asg_pickup_loc_code IN VARCHAR2 DEFAULT NULL,
416 p_asg_pickup_arr_date IN DATE DEFAULT NULL,
417 p_asg_pickup_dep_date IN DATE DEFAULT NULL,
418 p_asg_dropoff_stop_id IN NUMBER DEFAULT NULL,
419 p_asg_dropoff_loc_id IN NUMBER DEFAULT NULL,
420 p_asg_dropoff_stop_seq IN NUMBER DEFAULT NULL,/*h integration anxsharm*/
421 p_asg_dropoff_loc_code IN VARCHAR2 DEFAULT NULL,
422 p_asg_dropoff_arr_date IN DATE DEFAULT NULL,
423 p_asg_dropoff_dep_date IN DATE DEFAULT NULL,
424 p_sc_action_flag IN VARCHAR2 DEFAULT 'S',
425 p_sc_intransit_flag IN VARCHAR2 DEFAULT 'N',
426 p_sc_close_trip_flag IN VARCHAR2 DEFAULT 'N',
427 p_sc_create_bol_flag IN VARCHAR2 DEFAULT 'N',
428 p_sc_stage_del_flag IN VARCHAR2 DEFAULT 'Y',
429 p_sc_trip_ship_method IN VARCHAR2 DEFAULT NULL,
430 p_sc_actual_dep_date IN DATE DEFAULT NULL,
431 p_sc_report_set_id IN NUMBER DEFAULT NULL,
432 p_sc_report_set_name IN VARCHAR2 DEFAULT NULL,
433 p_sc_defer_interface_flag IN VARCHAR2 DEFAULT 'Y',
434 p_sc_send_945_flag IN VARCHAR2 DEFAULT NULL,
435 p_wv_override_flag IN VARCHAR2 DEFAULT 'N',
436 x_trip_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type );
437
438 --========================================================================
439 -- PROCEDURE : Get_Delivery_Status PUBLIC
440 --
441 -- PARAMETERS:
442 -- p_api_version_number known api version error number
443 -- p_init_msg_list FND_API.G_TRUE to reset list
444 -- p_entity_type either DELIVERY/DELIVERY DETAIL/LPN
445 -- p_entity_id either delivery_id/delivery_detail_id/lpn_id
446 -- x_status_code Status of delivery for the entity_type and
447 -- entity id passed
448 -- x_return_status return status
449 -- x_msg_count number of messages in the list
450 -- x_msg_data text of messages
454 ( p_api_version_number IN NUMBER,
451 --========================================================================
452 -- API added for bug 4632726
453 PROCEDURE Get_Delivery_Status
455 p_init_msg_list IN VARCHAR2,
456 p_entity_type IN VARCHAR2,
457 p_entity_id IN NUMBER,
458 x_status_code OUT NOCOPY VARCHAR2,
459 x_return_status OUT NOCOPY VARCHAR2,
460 x_msg_count OUT NOCOPY NUMBER,
461 x_msg_data OUT NOCOPY VARCHAR2 );
462
463
464 END WSH_DELIVERIES_GRP;