[Home] [Help]
PACKAGE: APPS.WSH_DELIVERY_DETAILS_GRP
Source
4
1 PACKAGE WSH_DELIVERY_DETAILS_GRP AUTHID CURRENT_USER AS
2 /* $Header: WSHDDGPS.pls 120.2.12010000.1 2008/07/29 05:59:29 appldev ship $ */
3
5 -- ---------------------------------------------------------------------------------------------------------
6 -- Procedure: delivery_detail_to_delivery
7 --
8 -- Parameters: 1) table of delivery_detail_ids
9 -- 2) action: assign/unassign
10 -- 3) delivery_id: need to specify delivery id or delivery nameif the action is 'ASSIGN'
11 -- 4) delivery_name: need to specify delivery id or delivery name if the action is 'ASSIGN'
12 -- 5) other standard parameters
13 --
14 -- Description: This procedure assign/unassign delivery_details to a delivery
15 --
16 -- History:
17 -- 06-OCT-00 Changed container_name width from 50 to 30 for meeting wms requirements/changes
21
18 -- ---------------------------------------------------------------------------------------------------------
19
20 TYPE ID_TAB_TYPE IS table of number INDEX BY BINARY_INTEGER;
22 PROCEDURE detail_to_delivery(
23 -- Standard parameters
24 p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 -- program specific parameters
32 p_TabOfDelDets IN WSH_UTIL_CORE.ID_TAB_TYPE,
33 p_action IN VARCHAR2,
34 p_delivery_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
35 p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
36 p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type -- J-IB-NPARIKH
37 );
38
39 --This procedure is for backward compatibility only. Do not use this.
40 PROCEDURE detail_to_delivery(
41 -- Standard parameters
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
44 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
45 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 -- program specific parameters
50 p_TabOfDelDets IN WSH_UTIL_CORE.ID_TAB_TYPE,
51 p_action IN VARCHAR2,
52 p_delivery_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
53 p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
54 );
55
56
57 -- ----------------------------------------------------------------------
58 -- Procedure: split_line
59 -- Parameters: p_from_detail_id: The delivery detail ID to be split
60 -- x_new_detail_id: The new delivery detail ID x_split_quantity: The split quantity
61 --
62 -- Description: This procedure splits a delivery_deatil line
63 --
64 -- ----------------------------------------------------------------------
65
66 PROCEDURE split_line(
67 -- Standard parameters
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
70 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
71 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75
76 -- program specific parameters
77 p_from_detail_id IN NUMBER,
78 x_new_detail_id OUT NOCOPY NUMBER,
79 x_split_quantity IN OUT NOCOPY NUMBER,
80 x_split_quantity2 IN OUT NOCOPY NUMBER,
81 p_manual_split IN VARCHAR2 DEFAULT NULL,-- HW added for OPM
82 p_converted_flag IN VARCHAR2 DEFAULT NULL -- HW added for OPM
83 );
84
85
86 --bug 1747202: default these attributes so they won't be updated.
87 /* Not needed any more since we use WSH_INTERFACE.ChangedAttributeTabType
88 TYPE ChangedAttributeRecType IS RECORD (
89 arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
90 ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
91 attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
92 attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
93 attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
94 attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
95 attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
96 attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
97 attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
98 attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
99 attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
100 attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
101 attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
102 attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
103 attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
104 attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
105 attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
106 attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
107 cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
108 cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
109 carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM,
110 classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
111 commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
112 container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
113 container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
114 container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
115 country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
116 currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR,
117 cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
118 cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
119 customer_dock_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
120 customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
121 customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
122 customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
123 customer_number NUMBER DEFAULT FND_API.G_MISS_NUM,
124 customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
128 cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
125 customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
126 customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
127 cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
129 date_requested DATE DEFAULT FND_API.G_MISS_DATE,
130 date_scheduled DATE DEFAULT FND_API.G_MISS_DATE,
131 deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
132 deliver_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
133 deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
134 delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
135 delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
136 delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
137 dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
138 detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
139 fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
140 fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
141 fob_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
142 freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
143 freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
144 freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
145 freight_terms_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
146 gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
147 hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
148 hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
149 inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
150 intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
151 intmed_ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
152 intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
153 inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
154 inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155 item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
156 line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
157 load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
158 locator_id NUMBER DEFAULT FND_API.G_MISS_NUM,
159 lot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
160 lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
161 lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
162 master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
163 master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
164 maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
165 maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
166 minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
167 move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
168 movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
169 mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
170 net_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
171 oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
172 order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
173 ordered_qty_unit_of_measure VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
174 ordered_qty_unit_of_measure2 VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
175 ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
176 ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
177 ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
178 org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
179 organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
180 original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
181 packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
182 pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
183 picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
184 picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
185 preferred_grade VARCHAR2(4) DEFAULT FND_API.G_MISS_CHAR,
186 project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
187 quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
188 quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
189 released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
190 request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
191 revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
192 seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
193 serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
194 ship_from_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
195 ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
196 ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
197 ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM,
198 ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
199 ship_to_org_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
200 ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
201 ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
202 ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM,
203 ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM,
204 shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
205 shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
206 shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
207 shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR,
208 shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
212 source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM,
209 sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM,
210 sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
211 source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
213 source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
214 source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
215 source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
216 source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
217 split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
218 src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
219 src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
220 src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
221 src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
222 subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
223 sublot_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
224 task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
225 to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
226 top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
227 tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
228 tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
229 tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
230 tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
231 tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
232 tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
233 tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
234 tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
235 tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
236 tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
237 tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
238 tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
239 tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
240 tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
241 tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
242 tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
243 tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
244 transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
245 unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
246 unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
247 volume NUMBER DEFAULT FND_API.G_MISS_NUM,
248 volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
249 volume_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
250 weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
251 weight_uom_desc VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR
252 );
253
254 TYPE ChangedAttributeTabType IS TABLE OF ChangedAttributeRecType
255 INDEX BY BINARY_INTEGER;*/
256
257 -- Patchset I: Harmonization Project Changes Begin
258 --
259 /* do not use type action_parameters_rec_type, use the one defined in
260 wsh_glbl_var_strct_grp
261 */
262 TYPE action_parameters_rec_type IS RECORD
263 (
264 -- Generic
265 Caller VARCHAR2(32767),
266 Action_Code VARCHAR2(32767),
267 Phase NUMBER,
268 -- Assign/Unassign
269 delivery_id NUMBER ,
270 delivery_name VARCHAR2(32767),
271 -- Calculate weight and volume
272 wv_override_flag VARCHAR2(32767),
273 -- Cycle Count
274 quantity_to_split NUMBER,
275 quantity2_to_split NUMBER,
276 -- Pack, Unpack
277 container_name VARCHAR2(32767),
278 container_instance_id NUMBER,
279 container_flag VARCHAR2(1),
280 delivery_flag VARCHAR2(1),
281 -- Autopack
282 group_id_tab wsh_util_core.id_tab_type,
283 -- Split Line
284 split_quantity NUMBER,
285 split_quantity2 NUMBER,
286 -- Process Deliveries
287 group_by_header_flag VARCHAR(1)
288 );
289 --
290 --
291 --
292 /* do not use default_parameters_rec_type, use the record defined in
293 wsh_glbl_var_strct_grp
294 */
295 TYPE default_parameters_rec_type IS RECORD
296 (
297 --
298 quantity_to_cc NUMBER,
299 quantity2_to_cc NUMBER,
300 detail_group_params wsh_delivery_autocreate.grp_attr_rec_type
301 );
302 --
303 --
304 --
305 TYPE trip_rec_type IS RECORD
306 (
307 --
308 trip_id NUMBER,
309 trip_name VARCHAR2(32767)
310 );
311 --
312 /* do not use action_out_rec_type, use the record defined in
313 wsh_glbl_var_strct_grp
314 */
315 TYPE action_out_rec_type IS RECORD
316 (
317 valid_id_tab WSH_UTIL_CORE.id_tab_type,
318 selection_issue_flag VARCHAR2(1),
319 delivery_id_tab WSH_UTIL_CORE.id_tab_type,
320 result_id_tab WSH_UTIL_CORE.id_tab_type,
321 split_quantity NUMBER,
325
322 split_quantity2 NUMBER);
323
324 --
326 /* do not use ActionsInOutRecType, use the record defined in
327 wsh_glbl_var_strct_grp
328 */
329 TYPE actionsInOutRecType IS RECORD
330 (
331 split_quantity NUMBER,
332 split_quantity2 NUMBER
333 );
334 --
335 /* do not use SerialRangeRecType, use the record defined in
336 wsh_glbl_var_strct_grp
337 */
338 TYPE serialRangeRecType IS RECORD
339 (
340 delivery_detail_id NUMBER,
341 from_serial_number VARCHAR2(30),
342 to_serial_number VARCHAR2(30),
343 quantity NUMBER,
344 attribute_category VARCHAR2(30),
345 attribute1 VARCHAR2(150),
346 attribute2 VARCHAR2(150),
347 attribute3 VARCHAR2(150),
348 attribute4 VARCHAR2(150),
349 attribute5 VARCHAR2(150),
350 attribute6 VARCHAR2(150),
351 attribute7 VARCHAR2(150),
352 attribute8 VARCHAR2(150),
353 attribute9 VARCHAR2(150),
354 attribute10 VARCHAR2(150),
355 attribute11 VARCHAR2(150),
356 attribute12 VARCHAR2(150),
357 attribute13 VARCHAR2(150),
358 attribute14 VARCHAR2(150),
359 attribute15 VARCHAR2(150)
360 );
361 --
362 /* do not use serialRangeTabType, use the table defined in wsh_glbl_var_strct_grp */
363
364 TYPE serialRangeTabType IS TABLE OF serialRangeRecType
365 INDEX BY BINARY_INTEGER;
366
367 /* do not use detailInRecType, use the table defined in wsh_glbl_var_strct_grp */
368 TYPE detailInRecType IS RECORD
369 (
370 --
371 caller VARCHAR2(32767),
372 action_code VARCHAR2(32767),
373 phase NUMBER,
374 container_item_id NUMBER,
375 container_item_name VARCHAR2(32767),
376 container_item_seg FND_FLEX_EXT.SegmentArray,
377 organization_id NUMBER,
378 organization_code VARCHAR2(32767),
379 name_prefix VARCHAR2(32767),
380 name_suffix VARCHAR2(32767),
381 base_number NUMBER,
382 num_digits NUMBER,
383 quantity NUMBER,
384 container_name VARCHAR2(32767),
385 lpn_ids wsh_util_core.id_tab_type
386 );
387
388 --
389 /* do not use detailOutRecType, use the table defined in wsh_glbl_var_strct_grp */
390 TYPE detailOutRecType IS RECORD
391 (
392 --
393 detail_ids WSH_UTIL_CORE.Id_Tab_Type
394 );
395
396 -- Patchset I: Harmonization Project Changes End
397
398 --===================
399 -- PROCEDURES
400 --===================
401
402
403 --========================================================================
404 -- PROCEDURE : Update_Shipping_Attributes
405 --
406 -- PARAMETERS: p_api_version_number known api versionerror buffer
407 -- p_init_msg_list initialize message stack
408 -- x_return_status return status
409 -- x_msg_count number of messages in the list
410 -- x_msg_data text of messages
411 -- p_changed_attributes changed attributes for delivery details
412 -- p_source_code source system
413 --
414 --
415 -- COMMENT : Validates Organization_id and Organization_code against view
416 -- org_organization_definitions. If both values are
417 -- specified then only Org_Id is used
418 --========================================================================
419
420 PROCEDURE Update_Shipping_Attributes (
421 p_api_version_number IN NUMBER
422 , p_init_msg_list IN VARCHAR2
423 , p_commit IN VARCHAR2
424 , x_return_status OUT NOCOPY VARCHAR2
425 , x_msg_count OUT NOCOPY NUMBER
426 , x_msg_data OUT NOCOPY VARCHAR2
427 , p_changed_attributes IN OUT NOCOPY WSH_INTERFACE.ChangedAttributeTabType
428 , p_source_code IN VARCHAR2
429 , p_container_flag IN VARCHAR2 DEFAULT NULL
430 );
431
432 PROCEDURE Get_Detail_Status(
433 p_delivery_detail_id IN NUMBER
434 , x_line_status OUT NOCOPY VARCHAR2
435 , x_return_status OUT NOCOPY VARCHAR2
436 );
437
438 -- ---------------------------------------------------------------------
439 -- Procedure: Autocreate_Deliveries
440 --
441 -- change on 8/24/2005 : p_caller is added
442 -- refer to bug 4467032 (R12 Routing Guide)
443 -- -----------------------------------------------------------------------
444 PROCEDURE Autocreate_Deliveries(
445 p_api_version_number IN NUMBER
446 , p_init_msg_list IN VARCHAR2
447 , p_commit IN VARCHAR2
448 , p_caller IN VARCHAR2 DEFAULT NULL
449 , x_return_status OUT NOCOPY VARCHAR2
450 , x_msg_count OUT NOCOPY NUMBER
451 , x_msg_data OUT NOCOPY VARCHAR2
452 , p_line_rows IN WSH_UTIL_CORE.id_tab_type
453 , p_group_by_header_flag IN VARCHAR2 DEFAULT NULL
454 , x_del_rows OUT NOCOPY wsh_util_core.id_tab_type
455 );
456
457 PROCEDURE Autocreate_del_trip(
458 p_api_version_number IN NUMBER
459 , p_init_msg_list IN VARCHAR2
460 , p_commit IN VARCHAR2
461 , x_return_status OUT NOCOPY VARCHAR2
462 , x_msg_count OUT NOCOPY NUMBER
463 , x_msg_data OUT NOCOPY VARCHAR2
464 , p_line_rows IN WSH_UTIL_CORE.id_tab_type
465 , x_del_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
466 , x_trip_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type
467 );
468
469 -- ---------------------------------------------------------------------
470 -- Procedure: Delivery_Detail_Action
471 --
472 -- Parameters:
473 --
474 -- Description: This procedure is the core group API for the
475 -- delivery_detail_action. This is for called by STF directly.
476 -- Public API and other product APIs call the wrapper version.
477 -- The wrapper version, in turn, calls this procedure.
478 -- Created during the Patchset I: Harmonization Project
479 -- -----------------------------------------------------------------------
480
481 PROCEDURE Delivery_Detail_Action(
482 -- Standard Parameters
483 p_api_version_number IN NUMBER,
484 p_init_msg_list IN VARCHAR2,
485 p_commit IN VARCHAR2,
486 x_return_status OUT NOCOPY VARCHAR2,
487 x_msg_count OUT NOCOPY NUMBER,
488 x_msg_data OUT NOCOPY VARCHAR2,
489
490 -- Procedure specific Parameters
491 p_rec_attr_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
492 p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
493 x_defaults OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type, -- defaults
494 x_action_out_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type
495 );
496
497
498 -- ---------------------------------------------------------------------
499 -- Procedure: Create_Update_Delivery_Detail
500 --
501 -- Parameters:
502 --
503 -- Description: This procedure is the new API for wrapping the logic of CREATE/UPDATE of delivery details
504 -- Created during the Patchset I: Harmonization Project
505 -- -----------------------------------------------------------------------
506
507 PROCEDURE Create_Update_Delivery_Detail
508 (
509 -- Standard Parameters
510 p_api_version_number IN NUMBER,
511 p_init_msg_list IN VARCHAR2,
512 p_commit IN VARCHAR2,
513 x_return_status OUT NOCOPY VARCHAR2,
514 x_msg_count OUT NOCOPY NUMBER,
515 x_msg_data OUT NOCOPY VARCHAR2,
516
517 -- Procedure Specific Parameters
518 p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
519 p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
520 x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
521 );
522
523
524
525 /* ---------------------------------------------------------------------
526 Procedure: Create_Update_Delivery_Detail (OVERLOADED)
527
528 Parameters:
529
530 Description: This procedure is the new API for wrapping the logic of CREATE/UPDATE of delivery details
531 This OVERLOADED procedure has the additional parameter 'p_serial_range_tab'
532 Created during the Patchset I: Harmonization Project
533 ----------------------------------------------------------------------- */
534
535 PROCEDURE Create_Update_Delivery_Detail
536 (
537 -- Standard Parameters
538 p_api_version_number IN NUMBER,
539 p_init_msg_list IN VARCHAR2,
540 p_commit IN VARCHAR2,
541 x_return_status OUT NOCOPY VARCHAR2,
542 x_msg_count OUT NOCOPY NUMBER,
543 x_msg_data OUT NOCOPY VARCHAR2,
544
545 -- Procedure Specific Parameters
546 p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
547 p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
548 x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType,
549 p_serial_range_tab IN WSH_GLBL_VAR_STRCT_GRP.ddSerialRangeTabType
550 );
551
552 -- ---------------------------------------------------------------------
553 -- Procedure: Get_Carton_Grouping
554 --
555 -- Parameters:
556 --
557 -- Description: This procedure is the new API for wrapping the logic of autcreate_deliveries.
558 -- Usage: Called by WMS code to return carton grouping table.
559 -- -----------------------------------------------------------------------
560 PROCEDURE Get_Carton_Grouping (p_line_rows IN WSH_UTIL_CORE.id_tab_type,
561 x_grouping_rows OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
562 x_return_status OUT NOCOPY VARCHAR2);
563
564
565 END WSH_DELIVERY_DETAILS_GRP;