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
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
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
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
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
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
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,
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,
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,
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
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
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
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
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
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
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,
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,
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);
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
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
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
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
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
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
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,
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,
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,
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:
313: -- PURPOSE
314: -- This function checks if the shipment header is closed.
315: --
316: -- NOTES
317: -- 1. It will return FND_API.g_true/g_false.
318: -- 2. Exception encountered will be raised to the caller.
319: ---------------------------------------------------------------------
320: FUNCTION Is_Order_Header_Closed(
321: p_oe_header_id IN NUMBER
319: ---------------------------------------------------------------------
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
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.
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 :
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
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
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,
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,
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,
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,
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,
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,
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,
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,
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
427: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
428: -- p_module_type IN VARCHAR2 Default NULL.
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
427: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
428: -- p_module_type IN VARCHAR2 Default NULL.
429: -- Standard OUT Parameters :
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
427: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
428: -- p_module_type IN VARCHAR2 Default NULL.
429: -- Standard OUT Parameters :
430: -- x_return_status OUT NOCOPY VARCHAR2 Required
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
427: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
428: -- p_module_type IN VARCHAR2 Default NULL.
429: -- Standard OUT Parameters :
430: -- x_return_status OUT NOCOPY VARCHAR2 Required
431: -- x_msg_count OUT NOCOPY NUMBER Required
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,
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,
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,
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.
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 :
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
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
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,
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,
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,
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.
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 :
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
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
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,
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,
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);