1 PACKAGE AHL_OSP_SHIPMENT_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPOSHS.pls 120.3 2008/02/05 16:07:36 mpothuku ship $ */
3 /*#
4 * This package Contains Record types and public procedures to process shipment headers, and lines that are related to OSP Orders.
5 * @rep:scope public
6 * @rep:product AHL
7 * @rep:displayname Process OSP Shipment
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY AHL_OSP_ORDER
10 */
11 --Added by mpothuku on 09-Jul-2007 to fix the OGMA Part Number Change ER
12 ------------------------------------------------------------------------------------
13 -- Define Record Types for record structures needed for the Serial Number Change API --
14 ------------------------------------------------------------------------------------
15
16 TYPE Sernum_Change_Rec_Type IS RECORD (
17 ITEM_NUMBER VARCHAR2(40) ,
18 NEW_ITEM_NUMBER VARCHAR2(40) ,
19 NEW_LOT_NUMBER VARCHAR2(30) ,
20 NEW_ITEM_REV_NUMBER VARCHAR2(3) ,
21 OSP_LINE_ID NUMBER ,
22 INSTANCE_ID NUMBER ,
23 CURRENT_SERIAL_NUMBER VARCHAR2(30) ,
24 CURRENT_SERAIL_TAG VARCHAR2(80) ,
25 NEW_SERIAL_NUMBER VARCHAR2(30) ,
26 NEW_SERIAL_TAG_CODE VARCHAR2(30) ,
27 NEW_SERIAL_TAG_MEAN VARCHAR2(80)
28 );
29 --mpothuku End
30
31 ----------------------------------------------
32 -- Define Table Type for records structures --
33 ----------------------------------------------
34 TYPE Sernum_Change_Tbl_Type IS TABLE OF Sernum_Change_Rec_Type INDEX BY BINARY_INTEGER;
35
36 ---------------------------------
37 -- Define Record Type for Node --
38 ---------------------------------
39
40 TYPE Ship_Header_Rec_Type IS RECORD
41 ( header_id NUMBER
42 , order_number NUMBER
43 , booked_flag VARCHAR2(1)
44 , cancelled_flag VARCHAR2(1)
45 , open_flag VARCHAR2(1)
46 , price_list VARCHAR2(240)
47 , price_list_id NUMBER
48 , ship_from_org VARCHAR2(240)
49 , ship_from_org_id NUMBER
50 , ship_to_contact VARCHAR2(240)
51 , ship_to_contact_id NUMBER
52 , ship_to_org VARCHAR2(240)
53 , ship_to_org_id NUMBER
54 , sold_to_custom_number VARCHAR2(50)
55 , sold_to_org_id NUMBER
56 , fob_point VARCHAR2(240)
57 , fob_point_code VARCHAR2(30)
58 , freight_carrier VARCHAR2(240)
59 , freight_carrier_code VARCHAR2(30)
60 , freight_terms VARCHAR2(240)
61 , freight_terms_code VARCHAR2(30)
62 , shipment_priority_code VARCHAR2(30)
63 , shipment_priority VARCHAR2(240)
64 , shipping_method_code VARCHAR2(30)
65 , shipping_method VARCHAR2(240)
66 , osp_order_id NUMBER
67 , osp_order_number VARCHAR2(50)
68 , payment_term_id NUMBER
69 , payment_term VARCHAR2(240)
70 , tax_exempt_flag VARCHAR2(30)
71 , tax_exempt_number VARCHAR2(80)
72 , tax_exempt_reason_code VARCHAR2(30)
73 , tax_exempt_reason VARCHAR2(240)
74 , shipping_instructions VARCHAR2(2000)
75 , packing_instructions VARCHAR2(2000)
76 , operation VARCHAR2(30)
77 );
78
79 -- Line record type
80
81 TYPE Ship_Line_Rec_Type IS RECORD
82 ( line_id NUMBER
83 , line_number NUMBER
84 , header_id NUMBER
85 , order_type VARCHAR2(240)
86 , line_type_id NUMBER
87 , line_type VARCHAR2(240)
88 , job_number VARCHAR2(30)
89 , project_id NUMBER
90 , project VARCHAR2(240)
91 , task_id NUMBER
92 , task VARCHAR2(240)
93 , operation VARCHAR2(30)
94 , inventory_item_id NUMBER
95 , inventory_org_id NUMBER
96 , inventory_item VARCHAR2(240)
97 , LOT_NUMBER mtl_lot_numbers.lot_number%TYPE
98 , INVENTORY_ITEM_UOM VARCHAR2(3)
99 , INVENTORY_ITEM_QUANTITY NUMBER
100 , serial_number VARCHAR2(30)
101 , csi_item_instance_id NUMBER
102 , ordered_quantity NUMBER
103 , order_quantity_uom VARCHAR2(3)
104 , return_reason_code VARCHAR2(30)
105 , return_reason VARCHAR2(240)
106 , schedule_ship_date DATE
107 , packing_instructions VARCHAR2(2000)
108 , ship_from_org VARCHAR2(240)
109 , ship_from_org_id NUMBER
110 , fob_point VARCHAR2(240)
111 , fob_point_code VARCHAR2(30)
112 , freight_carrier VARCHAR2(240)
113 , freight_carrier_code VARCHAR2(30)
114 , freight_terms VARCHAR2(240)
115 , freight_terms_code VARCHAR2(30)
116 , shipment_priority_code VARCHAR2(30)
117 , shipment_priority VARCHAR2(240)
118 , shipping_method_code VARCHAR2(30)
119 , shipping_method VARCHAR2(240)
120 , subinventory VARCHAR2(10)
121 , osp_order_id NUMBER
122 , osp_order_number VARCHAR2(50)
123 , osp_line_id NUMBER
124 , osp_line_number VARCHAR2(50)
125 , instance_id NUMBER
126 , osp_line_flag VARCHAR2(30) -- Possible values Y or N used to check if this line
127 -- corresponds to a line in OSP order.
128 );
129
130 TYPE Ship_Line_Tbl_Type IS TABLE OF Ship_Line_Rec_Type
131 INDEX BY BINARY_INTEGER;
132
133 TYPE Ship_ID_Tbl_Type IS TABLE OF NUMBER
134 INDEX BY BINARY_INTEGER;
135
136 ------------------------
137 -- Declare Procedures --
138 ------------------------
139
140 -- Start of Comments --
141 -- Procedure name : Process_Order
142 -- Type : Public
143 -- Function : For one Shipment Header and a set of Shipment
144 -- Lines, call 1) SO API 2) Update IB with IB trxns.
145 -- Pre-reqs :
146 -- Parameters :
147 --
148 -- Standard IN Parameters :
149 -- p_api_version IN NUMBER Default 1.0
150 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
151 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
152 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
153 -- Standard OUT Parameters :
154 -- x_return_status OUT NOCOPY VARCHAR2 Required
155 -- x_msg_count OUT NOCOPY NUMBER Required
156 -- x_msg_data OUT NOCOPY VARCHAR2 Required
157 --
158 -- Process Order Parameters:
159 -- p_x_Header_rec IN OUT NOCOPY Ship_Header_rec_type Required
160 -- All parameters for SO Shipment Header
161 -- p_x_Lines_tbl IN OUT NOCOPY ship_line_tbl_type Required
162 -- List of all parameters for shipment lines
163 --
164 --
165 -- Version :
166 -- Initial Version 1.0
167 --
168 -- End of Comments.
169 /*#
170 * This procedure is used to process a Shipment order related to an OSP Order.
171 * @param p_api_version API Version Number
172 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
173 * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
174 * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
175 * @param p_module_type Module type of the caller
176 * @param p_x_header_rec Contains the attributes of the Shipment header, of type AHL_OSP_SHIPMENT_PUB.Ship_Header_Rec_Type
177 * @param p_x_lines_tbl Table of Shipment line records, of type AHL_OSP_SHIPMENT_PUB.Ship_Line_Tbl_Type
178 * @param x_return_status return status
179 * @param x_msg_count return message count
180 * @param x_msg_data return message data
181 * @rep:scope public
182 * @rep:lifecycle active
183 * @rep:displayname Process Shipment Order
184 */
185 PROCEDURE Process_Order (
186 p_api_version IN NUMBER := 1.0,
187 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
188 p_commit IN VARCHAR2 := FND_API.G_FALSE,
189 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190 p_module_type IN VARCHAR2 := NULL,
191 p_x_header_rec IN OUT NOCOPY AHL_OSP_SHIPMENT_PUB.Ship_Header_Rec_Type,
192 p_x_lines_tbl IN OUT NOCOPY AHL_OSP_SHIPMENT_PUB.Ship_Line_Tbl_Type,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2);
196
197
198 -------------------------------------------------------------
199 -- Start of Comments --
200 -- Procedure name : Book_Order
201 -- Type : Public
202 -- Function : For one Shipment Header, book the order
203 -- Pre-reqs :
204 -- Parameters :
205 --
206 -- Standard IN Parameters :
207 -- p_api_version IN NUMBER Default 1.0
208 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
209 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
210 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
211 -- Standard OUT Parameters :
212 -- x_return_status OUT NOCOPY VARCHAR2 Required
213 -- x_msg_count OUT NOCOPY NUMBER Required
214 -- x_msg_data OUT NOCOPY VARCHAR2 Required
215 --
216 -- Delete_Cancel_Order Parameters:
217 -- p_oe_header_tbl IN NUMBER
218 -- The table of header_id for the Shipment Header
219 --
220 -- Version :
221 -- Initial Version 1.0
222 --
223 -- End of Comments.
224 /*#
225 * This procedure is used to book one or more shipment orders.
226 * @param p_api_version API Version Number
227 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
228 * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
229 * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
230 * @param p_oe_header_tbl Contains the ids of the shipment headers
231 * @param x_return_status return status
232 * @param x_msg_count return message count
233 * @param x_msg_data return message data
234 * @rep:scope public
235 * @rep:lifecycle active
236 * @rep:displayname Book Shipment Orders
237 */
238 PROCEDURE Book_Order (
239 p_api_version IN NUMBER := 1.0,
240 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
241 p_commit IN VARCHAR2 := FND_API.G_FALSE,
242 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
243 p_oe_header_tbl IN Ship_ID_Tbl_Type,
244 x_return_status OUT NOCOPY VARCHAR2,
245 x_msg_count OUT NOCOPY NUMBER,
246 x_msg_data OUT NOCOPY VARCHAR2);
247
248 -------------------------------------------------------------
249 -- Start of Comments --
250 -- Procedure name : Delete_Cancel_Order
251 -- Type : Public
252 -- Function : For one Shipment Header and a set of Shipment
253 -- Lines, Cancel if booked, delete if possible
254 -- Pre-reqs :
255 -- Parameters :
256 --
257 -- Standard IN Parameters :
258 -- p_api_version IN NUMBER Default 1.0
259 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
260 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
261 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
262 -- Standard OUT Parameters :
263 -- x_return_status OUT NOCOPY VARCHAR2 Required
264 -- x_msg_count OUT NOCOPY NUMBER Required
265 -- x_msg_data OUT NOCOPY VARCHAR2 Required
266 --
267 -- Delete_Cancel_Order Parameters:
268 -- p_oe_header_id IN NUMBER
269 -- The header_id for the Shipment Header
270 -- p_oe_lines_tbl IN ship_id_tbl_type
271 -- All shipment line ids for delete or cancel
272 -- p_cancel_flag IN VARCHAR2
273 -- If true, only do cancels, no deletes.
274 --
275 --
276 -- Version :
277 -- Initial Version 1.0
278 --
279 -- End of Comments.
280 /*#
281 * This procedure is used to Delete or Cancel Shipment Order and lines
282 * @param p_api_version API Version Number
283 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
284 * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
285 * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
286 * @param p_oe_header_id The id of the shipment header
287 * @param p_oe_lines_tbl Contains shipment line ids for delete or cancel
288 * @param p_cancel_flag If true, Cancels otherwise Deletes
289 * @param x_return_status return status
290 * @param x_msg_count return message count
291 * @param x_msg_data return message data
292 * @rep:scope public
293 * @rep:lifecycle active
294 * @rep:displayname Delete or Cancel Shipment Order
295 */
296 PROCEDURE Delete_Cancel_Order (
297 p_api_version IN NUMBER := 1.0,
298 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
299 p_commit IN VARCHAR2 := FND_API.G_FALSE,
300 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
301 p_oe_header_id IN NUMBER,
302 p_oe_lines_tbl IN SHIP_ID_TBL_TYPE,
303 p_cancel_flag IN VARCHAR2 := FND_API.G_FALSE,
304 x_return_status OUT NOCOPY VARCHAR2,
305 x_msg_count OUT NOCOPY NUMBER,
306 x_msg_data OUT NOCOPY VARCHAR2);
307
308
309 ---------------------------------------------------------------------
310 -- FUNCTION
311 -- Is_Order_Header_Closed
312 --
313 -- PURPOSE
314 -- This function checks if the shipment header is closed.
315 --
319 ---------------------------------------------------------------------
316 -- NOTES
317 -- 1. It will return FND_API.g_true/g_false.
318 -- 2. Exception encountered will be raised to the caller.
320 FUNCTION Is_Order_Header_Closed(
321 p_oe_header_id IN NUMBER
322 )
323 RETURN VARCHAR2; -- FND_API.g_true/g_false
324
325 -------------------------------------------------------------
326 -- Start of Comments --
327 -- Procedure name : Convert_SubTxn_Type
328 -- Type : Public
329 -- Function : API to delete OSP shipment return lines and change IB transaction
330 -- sub types for ship-only lines while converting an OSP Order from
331 -- Exchange to Service type or vice versa.
332 -- Pre-reqs :
333 -- Parameters :
334 --
335 -- Standard IN Parameters :
336 -- p_api_version IN NUMBER Default 1.0
337 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
338 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
339 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
340 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
341 -- p_module_type IN VARCHAR2 Default NULL.
342 -- Standard OUT Parameters :
343 -- x_return_status OUT NOCOPY VARCHAR2 Required
344 -- x_msg_count OUT NOCOPY NUMBER Required
345 -- x_msg_data OUT NOCOPY VARCHAR2 Required
346 --
347 -- Convert_SubTxn_Type Parameters:
348 -- p_osp_order_id IN NUMBER
349 -- The header_id for the OSP Order that is going through a type change
350 -- p_old_order_type_code IN VARCHAR2(30)
351 -- The old type of the OSP Order. Can be SERVICE or EXCHANGE only
352 -- p_new_order_type_code IN VARCHAR2(30)
353 -- The new type of the OSP Order. Can be EXCHANGE or SERVICE only.
354 --
355 --
356 -- Version :
357 -- Initial Version 1.0
358 --
359 -- End of Comments.
360
361 PROCEDURE Convert_SubTxn_Type (
362 p_api_version IN NUMBER := 1.0,
363 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
364 p_commit IN VARCHAR2 := FND_API.G_FALSE,
365 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
366 p_default IN VARCHAR2 := FND_API.G_TRUE,
367 p_module_type IN VARCHAR2 := NULL,
368 p_osp_order_id IN NUMBER,
369 p_old_order_type_code IN VARCHAR2,
370 p_new_order_type_code IN VARCHAR2,
371 x_return_status OUT NOCOPY VARCHAR2,
372 x_msg_count OUT NOCOPY NUMBER,
373 x_msg_data OUT NOCOPY VARCHAR2);
374
375
376 PROCEDURE Handle_Vendor_Change (
377 p_api_version IN NUMBER := 1.0,
378 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
379 p_commit IN VARCHAR2 := FND_API.G_FALSE,
380 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
381 p_default IN VARCHAR2 := FND_API.G_TRUE,
382 p_module_type IN VARCHAR2 := NULL,
383 p_osp_order_id IN NUMBER,
384 p_vendor_id IN NUMBER,
385 p_vendor_loc_id IN NUMBER,
386 x_return_status OUT NOCOPY VARCHAR2,
387 x_msg_count OUT NOCOPY NUMBER,
388 x_msg_data OUT NOCOPY VARCHAR2);
389
390 --Added by mpothuku on 01-Jun-2007 to support the part number and serial number change for osp lines
391 ----------------------------------------------------------------------------------------------------
392 -- FUNCTION
393 -- Is_part_chg_valid_for_ospline
394 --
395 -- PURPOSE
396 -- This function checks that the osp line is valid for part number/serial number change.
397 --
398 -- NOTES
399 -- It returns 'N' if
400 -- 1. There is no ship line for the osp line
401 -- 2. Item is not IB tracked
402 -- 3. Line status is PO Deleted/PO Cancelled/Req Deleted/Req Cancelled
403 -- 4. Item is not shipped
404 -- 5. Item has already been received
405 -- 6. Part Number change has already been formed for the osp line.
406 -- Otherwise it will return 'Y'
407 -----------------------------------------------------------------------------------------------------
408
409 FUNCTION Is_part_chg_valid_for_ospline(p_osp_order_line_id IN NUMBER)
410 RETURN VARCHAR2;
411
412 -------------------------------------------------------------
413 -- Start of Comments --
414 -- Procedure name :
415 -- Type : Public
416 -- Function : API to delete or cancel OSP shipment return lines and/or the IB installation
417 -- details before the part number/serial number change is performed from production
418 --
419 -- Pre-reqs :
420 -- Parameters :
421 --
422 -- Standard IN Parameters :
423 -- p_api_version IN NUMBER Default 1.0
424 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
425 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
426 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
430 -- x_return_status OUT NOCOPY VARCHAR2 Required
427 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
428 -- p_module_type IN VARCHAR2 Default NULL.
429 -- Standard OUT Parameters :
431 -- x_msg_count OUT NOCOPY NUMBER Required
432 -- x_msg_data OUT NOCOPY VARCHAR2 Required
433 --
434 -- Process_Osp_SerialNum_Change Parameters:
435 -- p_osp_order_line_id IN NUMBER
436 -- The osp_line_id for of OSP Order for which the part number/serial number change
437 -- p_inv_item_id IN NUMBER
438 -- The inv_item_id chosen by the user to replace the existint item.
439 -- p_serial_number IN VARCHAR2
440 -- The serial_number chosen by the user to replace the existint serial.
441 --
442 --
443 -- Version :
444 -- Initial Version 1.0
445 --
446 -- End of Comments.
447
448 PROCEDURE Process_Osp_SerialNum_Change(
449 p_api_version IN NUMBER := 1.0,
450 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
451 p_commit IN VARCHAR2 := FND_API.G_FALSE,
452 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
453 p_module_type IN VARCHAR2 := NULL,
454 p_serialnum_change_rec IN Sernum_Change_Rec_Type,
455 x_return_status OUT NOCOPY VARCHAR2,
456 x_msg_count OUT NOCOPY NUMBER,
457 x_msg_data OUT NOCOPY VARCHAR2
458 );
459
460 --Added by mpothuku on 05-Feb-2007 to implement the Osp Receiving ER
461 -------------------------------------------------------------
462 -- Start of Comments --
463 -- Procedure name :
464 -- Type : Public
465 -- Function : Create IB Sub transaction for a order line based on osp_order_type and
466 -- line type.
467 --
468 -- Pre-reqs :
469 -- Parameters :
470 --
471 -- Standard IN Parameters :
472 -- p_api_version IN NUMBER Default 1.0
473 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
474 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
475 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
476 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
477 -- p_module_type IN VARCHAR2 Default NULL.
478 -- Standard OUT Parameters :
479 -- x_return_status OUT NOCOPY VARCHAR2 Required
480 -- x_msg_count OUT NOCOPY NUMBER Required
481 -- x_msg_data OUT NOCOPY VARCHAR2 Required
482 --
483 -- Create_IB_Transaction Parameters:
484 -- p_OSP_order_type IN VARCHAR2
485 -- The osp order type to create the transaction as per the profile setup.
486 -- p_oe_line_type IN VARCHAR2
487 -- The shipment line type
488 -- p_oe_line_id IN NUMBER
489 -- The shipment line id corresponding to which the transaction is to be created.
490 -- p_csi_instance_id IN NUMBER
491 -- The instance id corresponding to which the transaction is to be created.
492 --
493 -- Version :
494 -- Initial Version 1.0
495 --
496 -- End of Comments.
497 PROCEDURE Create_IB_Transaction(
498 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
499 p_commit IN VARCHAR2 := FND_API.G_FALSE,
500 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
501 x_return_status OUT NOCOPY VARCHAR2,
502 x_msg_count OUT NOCOPY NUMBER,
503 x_msg_data OUT NOCOPY VARCHAR2,
504 p_OSP_order_type IN VARCHAR2,
505 p_oe_line_type IN VARCHAR2,
506 p_oe_line_id IN NUMBER,
507 p_csi_instance_id IN NUMBER);
508
509 -------------------------------------------------------------
510 -- Start of Comments --
511 -- Procedure name :
512 -- Type : Public
513 -- Function : Delete IB sub transaction for a shipment line.
514 --
515 -- Pre-reqs :
516 -- Parameters :
517 --
518 -- Standard IN Parameters :
519 -- p_api_version IN NUMBER Default 1.0
520 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
521 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
522 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
523 -- p_default IN VARCHAR2 Default FND_API.G_TRUE
524 -- p_module_type IN VARCHAR2 Default NULL.
525 -- Standard OUT Parameters :
526 -- x_return_status OUT NOCOPY VARCHAR2 Required
527 -- x_msg_count OUT NOCOPY NUMBER Required
528 -- x_msg_data OUT NOCOPY VARCHAR2 Required
529 --
530 -- Create_IB_Transaction Parameters:
531 -- p_oe_line_id IN NUMBER
532 -- The shipment line id corresponding to which the transaction is to be deleted.
533 --
534 -- Version :
535 -- Initial Version 1.0
536 --
537 -- End of Comments.
538 PROCEDURE Delete_IB_Transaction(
539 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
540 p_commit IN VARCHAR2 := FND_API.G_FALSE,
541 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
542 x_return_status OUT NOCOPY VARCHAR2,
543 x_msg_count OUT NOCOPY NUMBER,
544 x_msg_data OUT NOCOPY VARCHAR2,
545 p_oe_line_id IN NUMBER);
546
547 --mpothuku End
548
549 End AHL_OSP_SHIPMENT_PUB;