[Home] [Help]
PACKAGE: APPS.WSH_INTERFACE
Source
4 TYPE t_shipper_rec is RECORD
1 PACKAGE WSH_INTERFACE AUTHID CURRENT_USER as
2 /* $Header: WSHDDINS.pls 120.0.12010000.2 2009/12/03 12:28:03 mvudugul ship $ */
3
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 ,
77 item_description VARCHAR2(250) DEFAULT FND_API.G_MISS_CHAR,
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,
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,
159 tp_attribute11 VARCHAR2(240) 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,
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 client_id NUMBER -- LSP PROJECT
191 );
192
193 TYPE ChangedAttributeTabType IS TABLE OF ChangedAttributeRecType
194 INDEX BY BINARY_INTEGER;
195
196 -- anxsharm for Load Tender
197 -- Used to take the snap shot before the call is made from INV or OM
198 TYPE delivery_detail_rec is RECORD
199 (delivery_detail_id WSH_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE,
200 requested_quantity WSH_DELIVERY_DETAILS.REQUESTED_QUANTITY%TYPE,
201 shipped_quantity WSH_DELIVERY_DETAILS.SHIPPED_QUANTITY%TYPE,
202 picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE,
203 gross_weight WSH_DELIVERY_DETAILS.GROSS_WEIGHT%TYPE,
204 net_weight WSH_DELIVERY_DETAILS.NET_WEIGHT%TYPE,
205 weight_uom_code WSH_DELIVERY_DETAILS.WEIGHT_UOM_CODE%TYPE,
206 volume WSH_DELIVERY_DETAILS.VOLUME%TYPE,
207 volume_uom_code WSH_DELIVERY_DETAILS.VOLUME_UOM_CODE%TYPE,
208 delivery_id wsh_delivery_assignments_v.DELIVERY_ID%TYPE,
209 parent_delivery_detail_id wsh_delivery_assignments_v.PARENT_DELIVERY_DETAIL_ID%TYPE,
210 released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE
211 );
212 TYPE DeliveryDetailTab IS TABLE OF delivery_detail_rec INDEX BY BINARY_INTEGER;
213
214 --
215 -- Procedure: Update_Shipping_Attributes
216 -- Parameters: p_source_code,
217 -- p_changed_so_attributes,
218 -- x_return_status
219 -- p_log_level
220 -- Description: This procedure can be called when shipment
221 -- line has been changed or cancelled.
222 -- For example, if Order Entry sales order line
223 -- information has been changed, then the
224 -- p_source_code = "OE",
225 -- p_source_header_id = OE_HEADERS.HEADER_ID,
226 -- p_original_source_entity_id = OE_LINES.LINE_ID.
227 -- The user has to fill up the changed attributes
228 -- table according to what has been changed
229 -- for the specified line. The action will result
230 -- in a staus of 0 - success, 1 - failure.
231 --
232 PROCEDURE Update_Shipping_Attributes
233 (p_source_code IN VARCHAR2,
234 p_changed_attributes IN ChangedAttributeTabType,
235 x_return_status OUT NOCOPY VARCHAR2,
236 p_log_level IN NUMBER DEFAULT FND_API.G_MISS_NUM -- log level fix
237 );
238
239 -- These procedures Get_In_Transit_Qty are for TPA.
240 -- Bug 1569962
241 PROCEDURE Get_In_Transit_Qty(
242 p_source_code IN VARCHAR2 DEFAULT 'OE',
243 p_customer_id IN NUMBER,
244 p_ship_to_org_id IN NUMBER,
245 p_ship_from_org_id IN NUMBER,
246 p_inventory_item_id IN NUMBER,
247 p_order_header_id IN NUMBER,
248 p_shipper_recs IN T_SHIPPER_REC,
249 p_schedule_generation_date IN DATE,
250 x_in_transit_qty OUT NOCOPY NUMBER,
254 p_customer_id IN NUMBER,
251 x_return_status OUT NOCOPY VARCHAR2);
252 PROCEDURE Get_In_Transit_Qty(
253 p_source_code IN VARCHAR2 DEFAULT 'OE',
255 p_ship_to_org_id IN NUMBER,
256 p_ship_from_org_id IN NUMBER,
257 p_inventory_item_id IN NUMBER,
258 p_order_header_id IN NUMBER,
259 p_cust_production_seq_num IN VARCHAR2,
260 p_shipper_recs IN T_SHIPPER_REC,
261 p_schedule_generation_date IN DATE,
262 p_shipment_date IN DATE,
263 x_in_transit_qty OUT NOCOPY NUMBER,
264 x_return_status OUT NOCOPY VARCHAR2);
265
266 --
267 -- Procedure: Import_Delivery_Details
268 -- Parameters: errbuf
269 -- retcode
270 -- p_source_line_id
271 -- p_source_code
272 -- Description: Concurrent program procedure will import a delivery details or all
273 -- eligible delivery details into shipping.
274 --
275
276 PROCEDURE Import_Delivery_Details
277 (errbuf OUT NOCOPY VARCHAR2,
278 retcode OUT NOCOPY VARCHAR2,
279 p_source_line_id IN NUMBER,
280 p_source_code IN VARCHAR2
281 );
282
283 --
284 -- Procedure: Default_Container
285 -- Parameters: p_delivery_detail_id
286 -- x_return_status
287 -- Description: This procedure will set default master and detail container
288 -- item id for delivery details. If there is no
289 -- corresponding master/detail container info for ordered
290 -- item, these two fields will remain as old values.
291 --
292
293 PROCEDURE Default_Container(
294 p_delivery_detail_id IN NUMBER
295 , x_return_status OUT NOCOPY VARCHAR2
296 );
297
298 PROCEDURE Populate_detail_info(
299 p_old_delivery_detail_info IN WSH_DELIVERY_DETAILS%ROWTYPE
300 , x_new_delivery_detail_info OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_rec_type
301 , x_return_status OUT NOCOPY VARCHAR2
302 );
303
304 PROCEDURE Delete_Details(
305 p_details_id IN WSH_UTIL_CORE.Id_Tab_Type
306 , x_return_status OUT NOCOPY VARCHAR2);
307
308 PROCEDURE Get_Max_Load_Qty(
309 p_move_order_line_id IN NUMBER,
310 x_max_load_quantity OUT NOCOPY NUMBER,
311 x_container_item_id OUT NOCOPY NUMBER,
312 x_return_status OUT NOCOPY VARCHAR2);
313
314
315
316 --
317 -- Procedure: Lock_Records
318 -- Parameters:
319 -- p_source_code source system of records to lock
320 -- p_changed_attributes list of records to lock
321 -- x_interface_flag 'Y' if in OM Interface, 'N' if normal process
322 -- x_return_status return status
323 --
324 -- Description:
325 -- Lock the records' delivery lines if the action is not Import.
326 -- It will check whether the process is normal or during OM Interface.
327 -- If the process is normal, it will verify the records' delivery lines are not
328 -- shipped or in confirmed deliveries.
329 PROCEDURE Lock_Records(
330 p_source_code IN VARCHAR2,
331 p_changed_attributes IN ChangedAttributeTabType,
332 x_interface_flag OUT NOCOPY VARCHAR2,
333 x_return_status OUT NOCOPY VARCHAR2);
334
335
336
337 --
338 -- Procedure: Lock_Delivery_Detail
339 -- Parameters:
340 -- p_delivery_detail_id delivery detail to lock
341 -- p_source_code source system to lock
342 -- x_confirmed_flag set to TRUE if its delivery is confirmed
343 -- x_shipped_flag set to TRUE if it is shipped
344 -- x_interface_flag set to 'Y' if source_line_id < 0
345 -- x_return_status return status
346 --
347 -- Description:
348 -- Lock the delivery line and its assignment record.
349 -- Also set the flags if conditions are met.
350 -- Note: if x_interface_flag becomes 'Y', the other flags will not be updated further.
351 PROCEDURE Lock_Delivery_Detail(
352 p_delivery_detail_id IN NUMBER,
353 p_source_code IN VARCHAR2,
354 x_confirmed_flag IN OUT NOCOPY BOOLEAN,
355 x_shipped_flag IN OUT NOCOPY BOOLEAN,
356 x_interface_flag IN OUT NOCOPY VARCHAR2,
357 x_return_status OUT NOCOPY VARCHAR2);
358
359
360
361 --
362 -- Procedure: Process_Records
363 -- Parameters:
364 -- p_source_code source system of records to process
365 -- p_changed_attributes list of records to process
366 -- p_interface_flag 'Y' if in OM Interface, 'N' if normal process
367 -- x_return_status return status
368 --
369 -- Description:
370 -- Main loop for performing actions on the records.
371 PROCEDURE Process_Records(
372 p_source_code IN VARCHAR2,
373 p_changed_attributes IN ChangedAttributeTabType,
374 p_interface_flag IN VARCHAR2,
375 x_return_status OUT NOCOPY VARCHAR2);
376
377
378
379 --
380 -- Procedure: PRINTMSG
381 -- Parameters:
382 -- txt concurrent log text
383 -- name Message name
384 --
385 -- Description:
386 -- Sets a message if online or prints to log if concurrent.
387 PROCEDURE PRINTMSG (txt VARCHAR2,
388 name VARCHAR2 DEFAULT NULL);
389
390 --
391 -- Procedure: cancel_details
392 -- Parameters:
393 -- p_details_id table of delivery detail ids
394 -- x_return_status return status
395 --
396 -- Description:
397 -- Cancels the delivery details
398 PROCEDURE Cancel_Details(
399 p_details_id IN WSH_UTIL_CORE.Id_Tab_Type
400 , x_return_status OUT NOCOPY VARCHAR2);
401
402
403 END WSH_INTERFACE;