1 PACKAGE WSH_DELIVERY_DETAILS_PUB AS
2 /* $Header: WSHDDPBS.pls 120.1 2005/07/14 02:37:15 sgumaste noship $ */
3 /*#
4 * This is the public interface for the Delivery Line entity. It allows
5 * execution of various Delivery Line functions, including creation, update
6 * of delivery lines and other actions.
7 * @rep:scope public
8 * @rep:product WSH
9 * @rep:displayname Delivery Line
10 * @rep:lifecycle active
11 * @rep:category BUSINESS_ENTITY WSH_DELIVERY_LINE
12 */
13
14
15 -- ---------------------------------------------------------------------------------------------------------
16 -- Procedure: delivery_detail_to_delivery
17 --
18 -- Parameters: 1) table of delivery_detail_ids
19 -- 2) action: assign/unassign
20 -- 3) delivery_id: need to specify delivery id or delivery nameif the action is 'ASSIGN'
21 -- 4) delivery_name: need to specify delivery id or delivery name if the action is 'ASSIGN'
22 -- 5) other standard parameters
23 --
24 -- Description: This procedure assign/unassign delivery_details to a delivery
25 --
26 -- History:
27 -- 06-OCT-00 Changed container_name width from 50 to 30 for meeting wms requirements/changes
28 -- ---------------------------------------------------------------------------------------------------------
29
30 TYPE ID_TAB_TYPE IS table of number INDEX BY BINARY_INTEGER;
31
32 /*#
33 * Procedure to assign/unassign delivery lines to a delivery.
34 * Multiple delivery lines can be assigned to or unassigned from a delivery
35 * with a single procedure call by passing in the required parameters.
36 * @param p_api_version version number of the API
37 * @param p_init_msg_list messages will be initialized if set as true
38 * @param p_commit commit the transaction, if set as true
39 * @param p_validation_level validation level will be set as none if set as 0
40 * @param x_return_status return status of the API
41 * @param x_msg_count number of messages, if any
42 * @param x_msg_data message text, if any
43 * @param p_TabOfDelDets table of the delivery line IDs
44 * @param p_action action to be performed, it should be 'ASSIGN' or 'UNASSIGN'
45 * @param p_delivery_id ID of the delivery to be assigned to. If the action is 'ASSIGN', you need to specify either p_delivery_id or p_delivery_name
46 * @param p_delivery_name name of the delivery to be assigned to. If the action is 'ASSIGN', you need to specify either p_delivery_id or p_delivery_name
47 * @rep:scope public
48 * @rep:lifecycle active
49 * @rep:displayname Assign/Unassign Delivery Lines
50 */
51
52 PROCEDURE detail_to_delivery(
53 -- Standard parameters
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61
62 -- program specific parameters
63 p_TabOfDelDets IN ID_TAB_TYPE,
64 p_action IN VARCHAR2,
65 p_delivery_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
66 p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
67 );
68
69
70 -- ----------------------------------------------------------------------
71 -- Procedure: split_line
72 -- Parameters: p_from_detail_id: The delivery detail ID to be split
73 -- x_new_detail_id: The new delivery detail ID x_split_quantity: The split quantity
74 --
75 -- Description: This procedure splits a delivery_deatil line
76 --
77 -- ----------------------------------------------------------------------
78
79 /*#
80 * Procedure to split quantity of a delivery line.
81 * @param p_api_version version number of the API
82 * @param p_init_msg_list messages will be initialized if set as true
83 * @param p_commit commit the transaction, if set as true
84 * @param p_validation_level validation level will be set as none if set as 0
85 * @param x_return_status return status of the API
86 * @param x_msg_count number of messages, if any
87 * @param x_msg_data message text, if any
88 * @param p_from_detail_id delivery detail ID to be split
89 * @param x_new_detail_id output parameter to hold the new delivery line ID
90 * @param x_split_quantity primary quantity to split
91 * @param x_split_quantity2 secondary quantity to split
92 * @rep:scope public
93 * @rep:lifecycle active
94 * @rep:displayname Split Delivery Line
95 */
96 PROCEDURE split_line(
97 -- Standard parameters
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
100 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
101 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105
106 -- program specific parameters
107 p_from_detail_id IN NUMBER,
108 x_new_detail_id OUT NOCOPY NUMBER,
109 x_split_quantity IN OUT NOCOPY NUMBER,
110 x_split_quantity2 IN OUT NOCOPY NUMBER /* added for OPM */
111 );
112
113
114 --bug 1747202: default these attributes so they won't be updated.
115 TYPE ChangedAttributeRecType IS RECORD (
116 source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
117 source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
118 sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
119 customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
120 sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121 ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122 ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
123 ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
124 ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
125 ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
126 deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
127 deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
128 deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129 intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
130 intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
131 intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132 ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
133 ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
134 ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135 ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* added for OPM*/
136 order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
137 ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
138 -- HW OPMCONV -changed size of grade to 150
139 preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM */
140 ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
141 ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR, /* added for OPM*/
142 subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
143 revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
144 -- HW OPMCONV - Increase the size of lot_number
145 lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR,
146 -- HW OPMCONV - No need for sublot_number
147 --sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
148 customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149 serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
150 locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151 date_requested DATE DEFAULT FND_API.G_MISS_DATE,
152 date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
153 master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
154 detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155 shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156 carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
157 freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
158 freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
159 freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160 shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
161 fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
162 fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
163 dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
164 customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
165 customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
166 gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
167 net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
168 weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
169 weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
170 volume NUMBER DEFAULT FND_API.G_MISS_NUM,
171 volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
172 volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
173 top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
174 ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
175 ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176 arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
177 ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
178 cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
179 released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
180 packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
181 shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182 container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
183 container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
184 delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
185 shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
186 cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
187 shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
188 cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, /* Bug 3055126 */
189 tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
190 attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, /* Bug 3105907 */
191 attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
192 attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
193 attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
194 attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
195 attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
196 attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
197 attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
198 attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
199 attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
200 attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
201 attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
202 attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
203 attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
204 attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
205 attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
206 to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
207 -- Bug 3723831 :tp attributes also part of the public API update_shipping_attributes
208 tp_attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
209 tp_attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
210 tp_attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
211 tp_attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
212 tp_attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
213 tp_attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214 tp_attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
215 tp_attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
216 tp_attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
217 tp_attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
218 tp_attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
219 tp_attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
220 tp_attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
221 tp_attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
222 tp_attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
223 tp_attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
224 -- J: W/V Changes
225 filled_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
226 -- Bug 4146352 : Added seal_code and load_seq_number
227 seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
228 load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM
229 );
230
231 TYPE ChangedAttributeTabType IS TABLE OF ChangedAttributeRecType
232 INDEX BY BINARY_INTEGER;
233
234
235
236
237 --===================
238 -- PROCEDURES
239 --===================
240
241 -- Procedure Init_Changed_Attribute_Rec
242 -- Parameter p_init_rec record that needs to be initialized.
243 -- This procedure takes in a record of ChangedAttributeRecType and
244 -- initializes its attributes to the default FND_API_G values.
245
246 /*#
247 * This procedure takes in a record of ChangedAttributeRecType and
248 * initializes its attributes to the default FND_API_G values.
249 * Usually, it is called before Update_Shipping_Attributes
250 * to make sure the default value are set properly.
251 * @param p_init_rec record of ChangedAttributeRecType with the delivery line attibutes to be changed
252 * @param x_return_status return status of the API
253 * @rep:scope public
254 * @rep:lifecycle active
255 * @rep:displayname Initiate Delivery Line Changed Attributes
256 */
257 Procedure Init_Changed_Attribute_Rec(p_init_rec IN OUT NOCOPY WSH_DELIVERY_DETAILS_PUB.ChangedAttributeRecType,
258 x_return_status OUT NOCOPY VARCHAR2);
259
260
261 --========================================================================
262 -- PROCEDURE : Update_Shipping_Attributes
263 --
264 -- PARAMETERS: p_api_version_number known api versionerror buffer
265 -- p_init_msg_list initialize message stack
266 -- x_return_status return status
267 -- x_msg_count number of messages in the list
268 -- x_msg_data text of messages
269 -- p_changed_attributes changed attributes for delivery details
270 -- p_source_code source system
271 --
272 --
273 -- COMMENT : Validates Organization_id and Organization_code against view
274 -- org_organization_definitions. If both values are
275 -- specified then only Org_Id is used
276 --========================================================================
277
278 /*#
279 * Procedure to change the attributes of multiple delivery lines.
280 * @param p_api_version_number version number of the API
281 * @param p_init_msg_list messages will be initialized if set as true
282 * @param p_commit commit the transaction, if set as true
283 * @param x_return_status return status of the API
284 * @param x_msg_count number of messages, if any
285 * @param x_msg_data message text, if any
286 * @param p_changed_attributes table of ChangedAttributeRecType to hold the changed delivery line attributes
287 * @param p_source_code source system of the delivery lines
288 * @param p_container_flag obselete optional field, you do not need to pass value for this field
289 * @rep:scope public
290 * @rep:lifecycle active
291 * @rep:displayname Update Shipping Attributes
292 */
293 PROCEDURE Update_Shipping_Attributes (
294 p_api_version_number IN NUMBER
295 , p_init_msg_list IN VARCHAR2
296 , p_commit IN VARCHAR2
297 , x_return_status OUT NOCOPY VARCHAR2
298 , x_msg_count OUT NOCOPY NUMBER
299 , x_msg_data OUT NOCOPY VARCHAR2
300 , p_changed_attributes IN WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType
301 , p_source_code IN VARCHAR2
302 , p_container_flag IN VARCHAR2 DEFAULT NULL
303 );
304
305 --========================================================================
306 -- PROCEDURE : Update_Shipping_Attributes (overloaded)
307 --
308 -- PARAMETERS: p_api_version_number known api versionerror buffer
309 -- p_init_msg_list initialize message stack
310 -- x_return_status return status
311 -- x_msg_count number of messages in the list
315 -- p_serial_range_tab serial range table
312 -- x_msg_data text of messages
313 -- p_changed_attributes changed attributes for delivery details
314 -- p_source_code source system
316 --
317 -- COMMENT : Validates Organization_id and Organization_code against view
318 -- org_organization_definitions. If both values are
319 -- specified then only Org_Id is used
320 --
321 --DESCRIPTION: This overloaded version of Update_Shipping_Attributes is created
322 -- to enable entry of multiple serial ranges for a given delivery
323 -- detail
324 --
325 --CREATED: During patchset I
326 --========================================================================
327
328 /*#
329 * This overloaded version of Update_Shipping_Attributes is
330 * to enable entry of multiple serial ranges for a given delivery
331 * detail
332 * @param p_api_version_number version number of the API
333 * @param p_init_msg_list messages will be initialized if set as true
334 * @param p_commit commit the transaction, if set as true
335 * @param x_return_status return status of the API
336 * @param x_msg_count number of messages, if any
337 * @param x_msg_data message text, if any
338 * @param p_changed_attributes table of the changed delivery line attributes
339 * @param p_source_code source system of the delivery lines
340 * @param p_container_flag obselete optional field, you do not need to pass value for this field
341 * @param p_serial_range_tab table of the serial range records
342 * @rep:scope public
343 * @rep:lifecycle active
344 * @rep:displayname Update Shipping Attributes to enable entry of multiple serial ranges
345 */
346 PROCEDURE Update_Shipping_Attributes (
347 p_api_version_number IN NUMBER
348 , p_init_msg_list IN VARCHAR2
349 , p_commit IN VARCHAR2
350 , x_return_status OUT NOCOPY VARCHAR2
351 , x_msg_count OUT NOCOPY NUMBER
352 , x_msg_data OUT NOCOPY VARCHAR2
353 , p_changed_attributes IN WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType
354 , p_source_code IN VARCHAR2
355 , p_container_flag IN VARCHAR2 DEFAULT NULL
356 , p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
357 );
358
359 /*#
360 * Procedure to get the status of a delivery line
361 * The line status could be one of the three values:
362 * 1. 'SIC' - if the delivery associated with the delivery line is
363 * Confirmed, In-Transit, or Closed
364 * 2. 'PK' - if the delivery line is packed into a container
365 * 3. 'OK' - if the delivery line is not packed or not assigned
366 *
367 * @param p_delivery_detail_id delivery line ID
368 * @param x_line_status output parameter, line status
369 * @param x_return_status return status of the api
370 * @rep:scope internal
371 * @rep:lifecycle obsolete
372 * @rep:displayname Get Delivery Line Status
373 */
374 PROCEDURE Get_Detail_Status(
375 p_delivery_detail_id IN NUMBER
376 , x_line_status OUT NOCOPY VARCHAR2
377 , x_return_status OUT NOCOPY VARCHAR2
378 );
379
380 /*#
381 * Procedure to perform autocreate deliveries for multiple delivery lines
382 * @param p_api_version_number version number of the API
383 * @param p_init_msg_list messages will be initialized if set as true
384 * @param p_commit commit the transaction, if set as true
385 * @param x_return_status return status of the API
386 * @param x_msg_count number of messages, if any
387 * @param x_msg_data message text, if any
388 * @param p_line_rows table of the delivery line IDs
389 * @param x_del_rows output table of deliveries created
390 * @rep:scope public
391 * @rep:lifecycle active
392 * @rep:displayname Autocreate Deliveries
393 */
394 PROCEDURE Autocreate_Deliveries(
395 p_api_version_number IN NUMBER
396 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
397 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
398 , x_return_status OUT NOCOPY VARCHAR2
399 , x_msg_count OUT NOCOPY NUMBER
400 , x_msg_data OUT NOCOPY VARCHAR2
401 , p_line_rows IN WSH_UTIL_CORE.id_tab_type
402 , x_del_rows OUT NOCOPY wsh_util_core.id_tab_type
403 );
404
405 /*#
406 * Procedure to perform autocreate a single trip for multiple delivery lines
407 * It also creates deliveries for the delivery lines.
408 * @param p_api_version_number version number of the API
409 * @param p_init_msg_list messages will be initialized if set as true
410 * @param p_commit commit the transaction, if set as true
411 * @param x_return_status return status of the API
412 * @param x_msg_count number of messages, if any
413 * @param x_msg_data message text, if any
414 * @param p_line_rows table of the delivery line IDs
415 * @param x_del_rows output table of deliveries created
416 * @param x_trip_id trip ID of the trip created
417 * @param x_trip_name trip name of the trip created
418 * @rep:scope public
419 * @rep:lifecycle active
420 * @rep:displayname Autocreate Trip
421 */
422 PROCEDURE Autocreate_del_trip(
423 p_api_version_number IN NUMBER
424 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
425 , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
426 , x_return_status OUT NOCOPY VARCHAR2
427 , x_msg_count OUT NOCOPY NUMBER
428 , x_msg_data OUT NOCOPY VARCHAR2
429 , p_line_rows IN WSH_UTIL_CORE.id_tab_type
430 , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
431 , x_trip_id OUT NOCOPY NUMBER
432 , x_trip_name OUT NOCOPY VARCHAR2
433 );
434
435 /*#
436 * Procedure to perform autocreate trips for multiple delivery lines
437 * It also creates deliveries for the delivery lines.
438 * @param p_api_version_number version number of the API
439 * @param p_init_msg_list messages will be initialized if set as true
440 * @param p_commit commit the transaction, if set as true
441 * @param x_return_status return status of the API
442 * @param x_msg_count number of messages, if any
443 * @param x_msg_data message text, if any
444 * @param p_line_rows table of the delivery line IDs
445 * @param x_del_rows output table of deliveries created
446 * @param x_trip_rows trip IDs of the trips created
447 * @rep:scope public
448 * @rep:lifecycle active
449 * @rep:displayname Autocreate Trips
450 */
451 PROCEDURE Autocreate_del_trip(
452 p_api_version_number IN NUMBER
453 , p_init_msg_list IN VARCHAR2
454 , p_commit IN VARCHAR2
455 , x_return_status OUT NOCOPY VARCHAR2
456 , x_msg_count OUT NOCOPY NUMBER
457 , x_msg_data OUT NOCOPY VARCHAR2
458 , p_line_rows IN WSH_UTIL_CORE.id_tab_type
459 , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
460 , x_trip_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
461 );
462
463 END WSH_DELIVERY_DETAILS_PUB;