78: -- Parameters
79: --
80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
86: --
79: --
80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
86: --
87: -- OUT
80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
86: --
87: -- OUT
88: -- x_return_status OUT VARCHAR2
100: -- ==============================================================================
101:
102: PROCEDURE Create_Vol_Offr(
103: p_api_version_number IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
101:
102: PROCEDURE Create_Vol_Offr(
103: p_api_version_number IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
102: PROCEDURE Create_Vol_Offr(
103: p_api_version_number IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
125: -- Parameters
126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
133: --
126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
133: --
134: -- OUT
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
133: --
134: -- OUT
135: -- x_return_status OUT VARCHAR2
147: -- ==============================================================================
148:
149: PROCEDURE Update_Vol_Offr(
150: p_api_version_number IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154:
155: x_return_status OUT NOCOPY VARCHAR2,
148:
149: PROCEDURE Update_Vol_Offr(
150: p_api_version_number IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154:
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
149: PROCEDURE Update_Vol_Offr(
150: p_api_version_number IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154:
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
172: -- Parameters
173: --
174: -- IN
175: -- p_api_version_number IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- p_volume_offer_tiers_id IN NUMBER
180: -- p_object_version_number IN NUMBER Optional Default = NULL
173: --
174: -- IN
175: -- p_api_version_number IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- p_volume_offer_tiers_id IN NUMBER
180: -- p_object_version_number IN NUMBER Optional Default = NULL
181: --
174: -- IN
175: -- p_api_version_number IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- p_volume_offer_tiers_id IN NUMBER
180: -- p_object_version_number IN NUMBER Optional Default = NULL
181: --
182: -- OUT
195: -- ==============================================================================
196:
197: PROCEDURE Delete_Vol_Offr(
198: p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
196:
197: PROCEDURE Delete_Vol_Offr(
198: p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
197: PROCEDURE Delete_Vol_Offr(
198: p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_volume_offer_tiers_id IN NUMBER,
218: -- Parameters
219: --
220: -- IN
221: -- p_api_version_number IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
223: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
226: --
219: --
220: -- IN
221: -- p_api_version_number IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
223: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
226: --
227: -- OUT
220: -- IN
221: -- p_api_version_number IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
223: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
226: --
227: -- OUT
228: -- x_return_status OUT VARCHAR2
240: -- ==============================================================================
241:
242: PROCEDURE Lock_Vol_Offr(
243: p_api_version_number IN NUMBER,
244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245:
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,
274:
275:
276: PROCEDURE Validate_Vol_Offr(
277: p_api_version_number IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: p_vol_offr_tier_rec IN vol_offr_tier_rec_type,
281: p_validation_mode IN VARCHAR2,
282: x_return_status OUT NOCOPY VARCHAR2,
275:
276: PROCEDURE Validate_Vol_Offr(
277: p_api_version_number IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: p_vol_offr_tier_rec IN vol_offr_tier_rec_type,
281: p_validation_mode IN VARCHAR2,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
333:
334:
335: PROCEDURE Validate_Vol_Offr_Tier_Rec (
336: p_api_version_number IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: x_return_status OUT NOCOPY VARCHAR2,
339: x_msg_count OUT NOCOPY NUMBER,
340: x_msg_data OUT NOCOPY VARCHAR2,
341: p_vol_offr_tier_rec IN vol_offr_tier_rec_type