[Home] [Help]
PACKAGE: APPS.WSH_INTERFACE
Source
1 PACKAGE WSH_INTERFACE as
2 /* $Header: WSHDDINS.pls 120.0 2005/05/26 17:56:19 appldev noship $ */
3
4 TYPE t_shipper_rec is RECORD
5 (shipper_ID1 VARCHAR2(30),
6 shipper_ID2 VARCHAR2(30),
7 shipper_ID3 VARCHAR2(30),
8 shipper_ID4 VARCHAR2(30),
9 shipper_ID5 VARCHAR2(30));
10
11 TYPE ChangedAttributeRecType IS RECORD -- This record now includes all the columns
12 -- other than the WHO columns in wsh_delivery_details,
13 -- it is also now sorted.
14 (
15 action_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
16 arrival_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
17 ato_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
18 attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
19 attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
20 attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
21 attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
22 attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
23 attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
24 attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
25 attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
26 attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
27 attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
28 attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
29 attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
30 attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
31 attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
32 attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
33 attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
34 cancelled_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
35 cancelled_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
36 carrier_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
37 classification VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
38 commodity_code_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
39 container_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
40 container_name VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
41 container_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
42 country_of_origin VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
43 currency_code VARCHAR2(15) DEFAULT FND_API.G_MISS_CHAR ,
44 cust_model_serial_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
45 cust_po_number VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
46 customer_dock_code VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
47 customer_id NUMBER DEFAULT FND_API.G_MISS_NUM,
48 customer_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
49 customer_job VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
50 customer_prod_seq VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR ,
51 customer_production_line VARCHAR2(50) DEFAULT FND_API.G_MISS_CHAR,
52 customer_requested_lot_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
53 cycle_count_quantity NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for Backordering
54 cycle_count_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
55 date_requested DATE DEFAULT FND_API.G_MISS_DATE ,
56 date_scheduled DATE DEFAULT FND_API.G_MISS_DATE ,
57 deliver_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
58 deliver_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
59 delivered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
60 delivered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
61 delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
62 dep_plan_required_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
63 detail_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
64 fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
65 fob_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
66 freight_carrier_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
67 freight_class_cat_id NUMBER DEFAULT FND_API.G_MISS_NUM,
68 freight_terms_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
69 gross_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
70 hazard_class_id NUMBER DEFAULT FND_API.G_MISS_NUM,
71 hold_code VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
72 inspection_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR , -- added for Contracts
73 intmed_ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
74 intmed_ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
75 inv_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
76 inventory_item_id NUMBER DEFAULT FND_API.G_MISS_NUM,
77 item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
78 item_type_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
79 line_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR, -- Bug 1610845
80 load_seq_number NUMBER DEFAULT FND_API.G_MISS_NUM,
81 locator_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
82 lot_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
83 -- HW OPMCONV. Need to expand length of lot_number to 80
84 lot_number VARCHAR2(80) DEFAULT FND_API.G_MISS_CHAR ,
85 lpn_content_id NUMBER DEFAULT FND_API.G_MISS_NUM,
86 lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM,
87 master_container_item_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
88 master_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
89 maximum_load_weight NUMBER DEFAULT FND_API.G_MISS_NUM,
90 maximum_volume NUMBER DEFAULT FND_API.G_MISS_NUM,
91 minimum_fill_percent NUMBER DEFAULT FND_API.G_MISS_NUM,
92 move_order_line_id NUMBER DEFAULT FND_API.G_MISS_NUM,
93 movement_id NUMBER DEFAULT FND_API.G_MISS_NUM,
94 mvt_stat_status VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
95 net_weight NUMBER DEFAULT FND_API.G_MISS_NUM ,
96 oe_interfaced_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
97 order_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
98 ordered_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
99 ordered_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
100 ordered_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
101 org_id NUMBER DEFAULT FND_API.G_MISS_NUM,
102 organization_id NUMBER DEFAULT FND_API.G_MISS_NUM,
103 original_source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
104 original_subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR,
105 packing_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
106 pending_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
107 pending_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
108 pickable_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
109 picked_quantity NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
110 picked_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM, -- overpicking bug 1848530
111 -- HW OPMCONV. Need to expand length of grade to 150
112 preferred_grade VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR ,
113 project_id NUMBER DEFAULT FND_API.G_MISS_NUM,
114 quality_control_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
115 quality_control_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
116 received_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
117 received_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
118 released_status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR,
119 request_id NUMBER DEFAULT FND_API.G_MISS_NUM,
120 revision VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
121 seal_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
122 serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
123 ship_from_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
124 ship_model_complete_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
125 ship_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
126 ship_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
127 ship_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
128 ship_to_site_use_id NUMBER DEFAULT FND_API.G_MISS_NUM,
129 ship_tolerance_above NUMBER DEFAULT FND_API.G_MISS_NUM ,
130 ship_tolerance_below NUMBER DEFAULT FND_API.G_MISS_NUM ,
131 shipment_priority_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
132 shipped_flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR ,
133 shipped_quantity NUMBER DEFAULT FND_API.G_MISS_NUM ,
134 shipped_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM ,
135 shipping_instructions VARCHAR2(2000) DEFAULT FND_API.G_MISS_CHAR ,
136 shipping_method_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
137 sold_to_contact_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
138 sold_to_org_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
139 source_code VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
140 source_header_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
141 source_header_number VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
142 source_header_type_id NUMBER DEFAULT FND_API.G_MISS_NUM,
143 source_header_type_name VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
144 source_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
145 source_line_set_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
146 split_from_delivery_detail_id NUMBER DEFAULT FND_API.G_MISS_NUM,
147 src_requested_quantity NUMBER DEFAULT FND_API.G_MISS_NUM,
148 src_requested_quantity2 NUMBER DEFAULT FND_API.G_MISS_NUM,
149 src_requested_quantity_uom VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
150 src_requested_quantity_uom2 VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
151 subinventory VARCHAR2(10) DEFAULT FND_API.G_MISS_CHAR ,
152 -- HW OPMCONV. No need for sublot anymore
153 -- sublot_number VARCHAR2(32) DEFAULT FND_API.G_MISS_CHAR ,
154 task_id NUMBER DEFAULT FND_API.G_MISS_NUM,
155 to_serial_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
156 top_model_line_id NUMBER DEFAULT FND_API.G_MISS_NUM ,
157 tp_attribute1 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
158 tp_attribute10 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
159 tp_attribute11 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
160 tp_attribute12 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
161 tp_attribute13 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
162 tp_attribute14 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
163 tp_attribute15 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
164 tp_attribute2 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
165 tp_attribute3 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
166 tp_attribute4 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
167 tp_attribute5 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
168 tp_attribute6 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
169 tp_attribute7 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
170 tp_attribute8 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
171 tp_attribute9 VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
172 tp_attribute_category VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR,
173 tracking_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR ,
174 trans_id NUMBER DEFAULT FND_API.G_MISS_NUM, -- NC OPM changes BUG #1636578
175 transaction_temp_id NUMBER DEFAULT FND_API.G_MISS_NUM,
176 transfer_lpn_id NUMBER DEFAULT FND_API.G_MISS_NUM , -- added for cross-docking
177 unit_number VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
178 unit_price NUMBER DEFAULT FND_API.G_MISS_NUM,
179 volume NUMBER DEFAULT FND_API.G_MISS_NUM,
180 volume_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR ,
181 weight_uom_code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
182 --added for calc. TP dates
183 latest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
184 promise_date DATE DEFAULT FND_API.G_MISS_DATE ,
185 schedule_arrival_date DATE DEFAULT FND_API.G_MISS_DATE ,
186 earliest_acceptable_date DATE DEFAULT FND_API.G_MISS_DATE ,
187 earliest_ship_date DATE DEFAULT FND_API.G_MISS_DATE, --demand_satisfaction_date from TP
188 -- J: W/V Changes
189 filled_volume NUMBER DEFAULT FND_API.G_MISS_NUM
190 );
191
192 TYPE ChangedAttributeTabType IS TABLE OF ChangedAttributeRecType
193 INDEX BY BINARY_INTEGER;
194
195 -- anxsharm for Load Tender
196 -- Used to take the snap shot before the call is made from INV or OM
197 TYPE delivery_detail_rec is RECORD
198 (delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE,
199 requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE,
200 shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE,
201 picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE,
202 gross_weight WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE,
203 net_weight WSH_DELIVERY_DETAILS.NET_WEIGHT%TYPE,
204 weight_uom_code WSH_DELIVERY_DETAILS.WEIGHT_UOM_CODE%TYPE,
205 volume WSH_DELIVERY_DETAILS.VOLUME%TYPE,
206 volume_uom_code WSH_DELIVERY_DETAILS.VOLUME_UOM_CODE%TYPE,
207 delivery_id wsh_delivery_assignments_v.DELIVERY_ID%TYPE,
208 parent_delivery_detail_id wsh_delivery_assignments_v.PARENT_DELIVERY_DETAIL_ID%TYPE,
209 released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE
210 );
211 TYPE DeliveryDetailTab IS TABLE OF delivery_detail_rec INDEX BY BINARY_INTEGER;
212
213 --
214 -- Procedure: Update_Shipping_Attributes
215 -- Parameters: p_source_code,
216 -- p_changed_so_attributes,
217 -- x_return_status
218 -- p_log_level
219 -- Description: This procedure can be called when shipment
220 -- line has been changed or cancelled.
221 -- For example, if Order Entry sales order line
222 -- information has been changed, then the
223 -- p_source_code = "OE",
224 -- p_source_header_id = OE_HEADERS.HEADER_ID,
225 -- p_original_source_entity_id = OE_LINES.LINE_ID.
226 -- The user has to fill up the changed attributes
227 -- table according to what has been changed
228 -- for the specified line. The action will result
229 -- in a staus of 0 - success, 1 - failure.
230 --
231 PROCEDURE Update_Shipping_Attributes
232 (p_source_code IN VARCHAR2,
233 p_changed_attributes IN ChangedAttributeTabType,
234 x_return_status OUT NOCOPY VARCHAR2,
235 p_log_level IN NUMBER DEFAULT FND_API.G_MISS_NUM -- log level fix
236 );
237
238 -- These procedures Get_In_Transit_Qty are for TPA.
239 -- Bug 1569962
240 PROCEDURE Get_In_Transit_Qty(
241 p_source_code IN VARCHAR2 DEFAULT 'OE',
242 p_customer_id IN NUMBER,
243 p_ship_to_org_id IN NUMBER,
244 p_ship_from_org_id IN NUMBER,
245 p_inventory_item_id IN NUMBER,
246 p_order_header_id IN NUMBER,
247 p_shipper_recs IN T_SHIPPER_REC,
248 p_schedule_generation_date IN DATE,
249 x_in_transit_qty OUT NOCOPY NUMBER,
250 x_return_status OUT NOCOPY VARCHAR2);
251 PROCEDURE Get_In_Transit_Qty(
252 p_source_code IN VARCHAR2 DEFAULT 'OE',
253 p_customer_id IN NUMBER,
254 p_ship_to_org_id IN NUMBER,
255 p_ship_from_org_id IN NUMBER,
256 p_inventory_item_id IN NUMBER,
257 p_order_header_id IN NUMBER,
258 p_cust_production_seq_num IN VARCHAR2,
259 p_shipper_recs IN T_SHIPPER_REC,
260 p_schedule_generation_date IN DATE,
261 p_shipment_date IN DATE,
262 x_in_transit_qty OUT NOCOPY NUMBER,
263 x_return_status OUT NOCOPY VARCHAR2);
264
265 --
266 -- Procedure: Import_Delivery_Details
267 -- Parameters: errbuf
268 -- retcode
269 -- p_source_line_id
270 -- p_source_code
271 -- Description: Concurrent program procedure will import a delivery details or all
272 -- eligible delivery details into shipping.
273 --
274
275 PROCEDURE Import_Delivery_Details
276 (errbuf OUT NOCOPY VARCHAR2,
277 retcode OUT NOCOPY VARCHAR2,
278 p_source_line_id IN NUMBER,
279 p_source_code IN VARCHAR2
280 );
281
282 --
283 -- Procedure: Default_Container
284 -- Parameters: p_delivery_detail_id
285 -- x_return_status
286 -- Description: This procedure will set default master and detail container
287 -- item id for delivery details. If there is no
288 -- corresponding master/detail container info for ordered
289 -- item, these two fields will remain as old values.
290 --
291
292 PROCEDURE Default_Container(
293 p_delivery_detail_id IN NUMBER
294 , x_return_status OUT NOCOPY VARCHAR2
295 );
296
297 PROCEDURE Populate_detail_info(
298 p_old_delivery_detail_info IN WSH_DELIVERY_DETAILS%ROWTYPE
299 , x_new_delivery_detail_info OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
300 , x_return_status OUT NOCOPY VARCHAR2
301 );
302
303 PROCEDURE Delete_Details(
304 p_details_id IN WSH_UTIL_CORE.Id_Tab_Type
305 , x_return_status OUT NOCOPY VARCHAR2);
306
307 PROCEDURE Get_Max_Load_Qty(
308 p_move_order_line_id IN NUMBER,
309 x_max_load_quantity OUT NOCOPY NUMBER,
310 x_container_item_id OUT NOCOPY NUMBER,
311 x_return_status OUT NOCOPY VARCHAR2);
312
313
314
315 --
316 -- Procedure: Lock_Records
317 -- Parameters:
318 -- p_source_code source system of records to lock
319 -- p_changed_attributes list of records to lock
320 -- x_interface_flag 'Y' if in OM Interface, 'N' if normal process
321 -- x_return_status return status
322 --
323 -- Description:
324 -- Lock the records' delivery lines if the action is not Import.
325 -- It will check whether the process is normal or during OM Interface.
326 -- If the process is normal, it will verify the records' delivery lines are not
327 -- shipped or in confirmed deliveries.
328 PROCEDURE Lock_Records(
329 p_source_code IN VARCHAR2,
330 p_changed_attributes IN ChangedAttributeTabType,
331 x_interface_flag OUT NOCOPY VARCHAR2,
332 x_return_status OUT NOCOPY VARCHAR2);
333
334
335
336 --
337 -- Procedure: Lock_Delivery_Detail
338 -- Parameters:
339 -- p_delivery_detail_id delivery detail to lock
340 -- p_source_code source system to lock
341 -- x_confirmed_flag set to TRUE if its delivery is confirmed
342 -- x_shipped_flag set to TRUE if it is shipped
343 -- x_interface_flag set to 'Y' if source_line_id < 0
344 -- x_return_status return status
345 --
346 -- Description:
347 -- Lock the delivery line and its assignment record.
348 -- Also set the flags if conditions are met.
349 -- Note: if x_interface_flag becomes 'Y', the other flags will not be updated further.
350 PROCEDURE Lock_Delivery_Detail(
351 p_delivery_detail_id IN NUMBER,
352 p_source_code IN VARCHAR2,
353 x_confirmed_flag IN OUT NOCOPY BOOLEAN,
354 x_shipped_flag IN OUT NOCOPY BOOLEAN,
355 x_interface_flag IN OUT NOCOPY VARCHAR2,
356 x_return_status OUT NOCOPY VARCHAR2);
357
358
359
360 --
361 -- Procedure: Process_Records
362 -- Parameters:
363 -- p_source_code source system of records to process
364 -- p_changed_attributes list of records to process
365 -- p_interface_flag 'Y' if in OM Interface, 'N' if normal process
366 -- x_return_status return status
367 --
368 -- Description:
369 -- Main loop for performing actions on the records.
370 PROCEDURE Process_Records(
371 p_source_code IN VARCHAR2,
372 p_changed_attributes IN ChangedAttributeTabType,
373 p_interface_flag IN VARCHAR2,
374 x_return_status OUT NOCOPY VARCHAR2);
375
376
377
378 --
379 -- Procedure: PRINTMSG
380 -- Parameters:
381 -- txt concurrent log text
382 -- name Message name
383 --
384 -- Description:
385 -- Sets a message if online or prints to log if concurrent.
386 PROCEDURE PRINTMSG (txt VARCHAR2,
387 name VARCHAR2 DEFAULT NULL);
388
389 --
390 -- Procedure: cancel_details
391 -- Parameters:
392 -- p_details_id table of delivery detail ids
393 -- x_return_status return status
394 --
395 -- Description:
396 -- Cancels the delivery details
397 PROCEDURE Cancel_Details(
398 p_details_id IN WSH_UTIL_CORE.Id_Tab_Type
399 , x_return_status OUT NOCOPY VARCHAR2);
400
401
402 END WSH_INTERFACE;