DBA Data[Home] [Help]

APPS.AHL_OSP_SHIPMENT_PUB dependencies on FND_API

Line 150: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE

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

Line 151: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

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

Line 152: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

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

Line 172: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE

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

Line 173: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE

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

Line 174: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL

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

Line 187: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 188: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 189: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 208: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE

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

Line 209: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

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

Line 210: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

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

Line 227: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE

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

Line 228: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE

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

Line 229: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL

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

Line 240: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 241: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 242: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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);

Line 259: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE

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

Line 260: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

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

Line 261: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

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

Line 283: * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE

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

Line 284: * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE

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

Line 285: * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL

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

Line 298: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 299: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 300: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 303: p_cancel_flag IN VARCHAR2 := FND_API.G_FALSE,

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:

Line 317: -- 1. It will return FND_API.g_true/g_false.

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

Line 323: RETURN VARCHAR2; -- FND_API.g_true/g_false

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

Line 337: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

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.

Line 338: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

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 :

Line 339: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

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

Line 340: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

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

Line 363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 364: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 366: p_default IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 378: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 379: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 380: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 381: p_default IN VARCHAR2 := FND_API.G_TRUE,

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,

Line 424: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

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.

Line 425: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

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 :

Line 426: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

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

Line 427: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

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

Line 450: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 451: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 452: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 473: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

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.

Line 474: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

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 :

Line 475: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

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

Line 476: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

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

Line 498: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 499: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 500: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 520: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

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.

Line 521: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

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 :

Line 522: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

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

Line 523: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

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

Line 539: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 540: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 541: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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);