215: -- Parameters
216: --
217: -- IN
218: -- p_api_version_number IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
223: --
216: --
217: -- IN
218: -- p_api_version_number IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
223: --
224: -- OUT
217: -- IN
218: -- p_api_version_number IN NUMBER Required
219: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
222: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
223: --
224: -- OUT
225: -- x_return_status OUT VARCHAR2
234: --
235:
236: PROCEDURE Create_Supp_Trade_Profile(
237: p_api_version_number IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241:
242: x_return_status OUT NOCOPY VARCHAR2,
235:
236: PROCEDURE Create_Supp_Trade_Profile(
237: p_api_version_number IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241:
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
236: PROCEDURE Create_Supp_Trade_Profile(
237: p_api_version_number IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241:
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
259: -- Parameters
260: --
261: -- IN
262: -- p_api_version_number IN NUMBER Required
263: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
264: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
265: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
266: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
267: --
260: --
261: -- IN
262: -- p_api_version_number IN NUMBER Required
263: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
264: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
265: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
266: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
267: --
268: -- OUT
261: -- IN
262: -- p_api_version_number IN NUMBER Required
263: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
264: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
265: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
266: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
267: --
268: -- OUT
269: -- x_return_status OUT VARCHAR2
278: --
279:
280: PROCEDURE Update_Supp_Trade_Profile(
281: p_api_version_number IN NUMBER,
282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283: p_commit IN VARCHAR2 := FND_API.G_FALSE,
284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285:
286: x_return_status OUT NOCOPY VARCHAR2,
279:
280: PROCEDURE Update_Supp_Trade_Profile(
281: p_api_version_number IN NUMBER,
282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283: p_commit IN VARCHAR2 := FND_API.G_FALSE,
284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285:
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
280: PROCEDURE Update_Supp_Trade_Profile(
281: p_api_version_number IN NUMBER,
282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283: p_commit IN VARCHAR2 := FND_API.G_FALSE,
284: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
285:
286: x_return_status OUT NOCOPY VARCHAR2,
287: x_msg_count OUT NOCOPY NUMBER,
288: x_msg_data OUT NOCOPY VARCHAR2,
303: -- Parameters
304: --
305: -- IN
306: -- p_api_version_number IN NUMBER Required
307: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
308: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
309: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
310: -- p_SUPP_TRADE_PROFILE_ID IN NUMBER
311: -- p_object_version_number IN NUMBER Optional Default = NULL
304: --
305: -- IN
306: -- p_api_version_number IN NUMBER Required
307: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
308: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
309: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
310: -- p_SUPP_TRADE_PROFILE_ID IN NUMBER
311: -- p_object_version_number IN NUMBER Optional Default = NULL
312: --
305: -- IN
306: -- p_api_version_number IN NUMBER Required
307: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
308: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
309: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
310: -- p_SUPP_TRADE_PROFILE_ID IN NUMBER
311: -- p_object_version_number IN NUMBER Optional Default = NULL
312: --
313: -- OUT
323: --
324:
325: PROCEDURE Delete_Supp_Trade_Profile(
326: p_api_version_number IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,
324:
325: PROCEDURE Delete_Supp_Trade_Profile(
326: p_api_version_number IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,
332: x_msg_data OUT NOCOPY VARCHAR2,
325: PROCEDURE Delete_Supp_Trade_Profile(
326: p_api_version_number IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,
332: x_msg_data OUT NOCOPY VARCHAR2,
333: p_supp_trade_profile_id IN NUMBER,
346: -- Parameters
347: --
348: -- IN
349: -- p_api_version_number IN NUMBER Required
350: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
351: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
352: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
353: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
354: --
347: --
348: -- IN
349: -- p_api_version_number IN NUMBER Required
350: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
351: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
352: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
353: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
354: --
355: -- OUT
348: -- IN
349: -- p_api_version_number IN NUMBER Required
350: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
351: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
352: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
353: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
354: --
355: -- OUT
356: -- x_return_status OUT VARCHAR2
365: --
366:
367: PROCEDURE Lock_Supp_Trade_Profile(
368: p_api_version_number IN NUMBER,
369: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
370:
371: x_return_status OUT NOCOPY VARCHAR2,
372: x_msg_count OUT NOCOPY NUMBER,
373: x_msg_data OUT NOCOPY VARCHAR2,
389: -- End of Comments
390:
391: PROCEDURE Validate_supp_trade_profile(
392: p_api_version_number IN NUMBER,
393: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
394: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395: p_supp_trade_profile_rec IN supp_trade_profile_rec_type,
396: x_return_status OUT NOCOPY VARCHAR2,
397: x_msg_count OUT NOCOPY NUMBER,
390:
391: PROCEDURE Validate_supp_trade_profile(
392: p_api_version_number IN NUMBER,
393: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
394: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
395: p_supp_trade_profile_rec IN supp_trade_profile_rec_type,
396: x_return_status OUT NOCOPY VARCHAR2,
397: x_msg_count OUT NOCOPY NUMBER,
398: x_msg_data OUT NOCOPY VARCHAR2
427: -- End of Comments
428:
429: PROCEDURE Validate_supp_trd_prfl_rec(
430: p_api_version_number IN NUMBER,
431: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
432: x_return_status OUT NOCOPY VARCHAR2,
433: x_msg_count OUT NOCOPY NUMBER,
434: x_msg_data OUT NOCOPY VARCHAR2,
435: p_supp_trade_profile_rec IN supp_trade_profile_rec_type