235: -- Parameters
236: --
237: -- IN
238: -- p_api_version_number IN NUMBER Required
239: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
240: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
242: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
243: --
236: --
237: -- IN
238: -- p_api_version_number IN NUMBER Required
239: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
240: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
242: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
243: --
244: -- OUT
237: -- IN
238: -- p_api_version_number IN NUMBER Required
239: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
240: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
242: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
243: --
244: -- OUT
245: -- x_return_status OUT VARCHAR2
254: --
255:
256: PROCEDURE Create_Supp_Trade_Profile(
257: p_api_version_number IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261:
262: x_return_status OUT NOCOPY VARCHAR2,
255:
256: PROCEDURE Create_Supp_Trade_Profile(
257: p_api_version_number IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261:
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
256: PROCEDURE Create_Supp_Trade_Profile(
257: p_api_version_number IN NUMBER,
258: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
259: p_commit IN VARCHAR2 := FND_API.G_FALSE,
260: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
261:
262: x_return_status OUT NOCOPY VARCHAR2,
263: x_msg_count OUT NOCOPY NUMBER,
264: x_msg_data OUT NOCOPY VARCHAR2,
279: -- Parameters
280: --
281: -- IN
282: -- p_api_version_number IN NUMBER Required
283: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
284: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
285: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
286: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
287: --
280: --
281: -- IN
282: -- p_api_version_number IN NUMBER Required
283: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
284: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
285: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
286: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
287: --
288: -- OUT
281: -- IN
282: -- p_api_version_number IN NUMBER Required
283: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
284: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
285: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
286: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
287: --
288: -- OUT
289: -- x_return_status OUT VARCHAR2
298: --
299:
300: PROCEDURE Update_Supp_Trade_Profile(
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303: p_commit IN VARCHAR2 := FND_API.G_FALSE,
304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
305:
306: x_return_status OUT NOCOPY VARCHAR2,
299:
300: PROCEDURE Update_Supp_Trade_Profile(
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303: p_commit IN VARCHAR2 := FND_API.G_FALSE,
304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
305:
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,
300: PROCEDURE Update_Supp_Trade_Profile(
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303: p_commit IN VARCHAR2 := FND_API.G_FALSE,
304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
305:
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,
308: x_msg_data OUT NOCOPY VARCHAR2,
323: -- Parameters
324: --
325: -- IN
326: -- p_api_version_number IN NUMBER Required
327: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
328: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
329: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
330: -- p_SUPP_TRADE_PROFILE_ID IN NUMBER
331: -- p_object_version_number IN NUMBER Optional Default = NULL
324: --
325: -- IN
326: -- p_api_version_number IN NUMBER Required
327: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
328: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
329: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
330: -- p_SUPP_TRADE_PROFILE_ID IN NUMBER
331: -- p_object_version_number IN NUMBER Optional Default = NULL
332: --
325: -- IN
326: -- p_api_version_number IN NUMBER Required
327: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
328: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
329: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
330: -- p_SUPP_TRADE_PROFILE_ID IN NUMBER
331: -- p_object_version_number IN NUMBER Optional Default = NULL
332: --
333: -- OUT
343: --
344:
345: PROCEDURE Delete_Supp_Trade_Profile(
346: p_api_version_number IN NUMBER,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: x_return_status OUT NOCOPY VARCHAR2,
351: x_msg_count OUT NOCOPY NUMBER,
344:
345: PROCEDURE Delete_Supp_Trade_Profile(
346: p_api_version_number IN NUMBER,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: x_return_status OUT NOCOPY VARCHAR2,
351: x_msg_count OUT NOCOPY NUMBER,
352: x_msg_data OUT NOCOPY VARCHAR2,
345: PROCEDURE Delete_Supp_Trade_Profile(
346: p_api_version_number IN NUMBER,
347: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
348: p_commit IN VARCHAR2 := FND_API.G_FALSE,
349: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
350: x_return_status OUT NOCOPY VARCHAR2,
351: x_msg_count OUT NOCOPY NUMBER,
352: x_msg_data OUT NOCOPY VARCHAR2,
353: p_supp_trade_profile_id IN NUMBER,
366: -- Parameters
367: --
368: -- IN
369: -- p_api_version_number IN NUMBER Required
370: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
371: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
372: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
373: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
374: --
367: --
368: -- IN
369: -- p_api_version_number IN NUMBER Required
370: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
371: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
372: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
373: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
374: --
375: -- OUT
368: -- IN
369: -- p_api_version_number IN NUMBER Required
370: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
371: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
372: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
373: -- p_supp_trade_profile_rec IN supp_trade_profile_rec_type Required
374: --
375: -- OUT
376: -- x_return_status OUT VARCHAR2
385: --
386:
387: PROCEDURE Lock_Supp_Trade_Profile(
388: p_api_version_number IN NUMBER,
389: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
390:
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,
409: -- End of Comments
410:
411: PROCEDURE Validate_supp_trade_profile(
412: p_api_version_number IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
414: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
415: p_supp_trade_profile_rec IN supp_trade_profile_rec_type,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,
410:
411: PROCEDURE Validate_supp_trade_profile(
412: p_api_version_number IN NUMBER,
413: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
414: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
415: p_supp_trade_profile_rec IN supp_trade_profile_rec_type,
416: x_return_status OUT NOCOPY VARCHAR2,
417: x_msg_count OUT NOCOPY NUMBER,
418: x_msg_data OUT NOCOPY VARCHAR2
447: -- End of Comments
448:
449: PROCEDURE Validate_supp_trd_prfl_rec(
450: p_api_version_number IN NUMBER,
451: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
452: x_return_status OUT NOCOPY VARCHAR2,
453: x_msg_count OUT NOCOPY NUMBER,
454: x_msg_data OUT NOCOPY VARCHAR2,
455: p_supp_trade_profile_rec IN supp_trade_profile_rec_type