161: -- Parameters
162: --
163: -- IN
164: -- p_api_version_number IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
166: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_offadj_line_rec IN offadj_line_rec_type Required
169: --
162: --
163: -- IN
164: -- p_api_version_number IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
166: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_offadj_line_rec IN offadj_line_rec_type Required
169: --
170: -- OUT
163: -- IN
164: -- p_api_version_number IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
166: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
168: -- p_offadj_line_rec IN offadj_line_rec_type Required
169: --
170: -- OUT
171: -- x_return_status OUT VARCHAR2
183: -- ==============================================================================
184:
185: PROCEDURE Create_Offer_Adj_Line(
186: p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_commit IN VARCHAR2 := FND_API.G_FALSE,
189: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190:
191: x_return_status OUT NOCOPY VARCHAR2,
184:
185: PROCEDURE Create_Offer_Adj_Line(
186: p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_commit IN VARCHAR2 := FND_API.G_FALSE,
189: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190:
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
185: PROCEDURE Create_Offer_Adj_Line(
186: p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_commit IN VARCHAR2 := FND_API.G_FALSE,
189: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190:
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
198:
199:
200: PROCEDURE Create_New_Offer_Adj_Line(
201: p_api_version_number IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205:
206: x_return_status OUT NOCOPY VARCHAR2,
199:
200: PROCEDURE Create_New_Offer_Adj_Line(
201: p_api_version_number IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205:
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
200: PROCEDURE Create_New_Offer_Adj_Line(
201: p_api_version_number IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205:
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
224: -- Parameters
225: --
226: -- IN
227: -- p_api_version_number IN NUMBER Required
228: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
229: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
230: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
231: -- p_offadj_line_rec IN offadj_line_rec_type Required
232: --
225: --
226: -- IN
227: -- p_api_version_number IN NUMBER Required
228: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
229: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
230: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
231: -- p_offadj_line_rec IN offadj_line_rec_type Required
232: --
233: -- OUT
226: -- IN
227: -- p_api_version_number IN NUMBER Required
228: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
229: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
230: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
231: -- p_offadj_line_rec IN offadj_line_rec_type Required
232: --
233: -- OUT
234: -- x_return_status OUT VARCHAR2
246: -- ==============================================================================
247:
248: PROCEDURE Update_Offer_Adj_Line(
249: p_api_version_number IN NUMBER,
250: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
251: p_commit IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253:
254: x_return_status OUT NOCOPY VARCHAR2,
247:
248: PROCEDURE Update_Offer_Adj_Line(
249: p_api_version_number IN NUMBER,
250: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
251: p_commit IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253:
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
248: PROCEDURE Update_Offer_Adj_Line(
249: p_api_version_number IN NUMBER,
250: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
251: p_commit IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253:
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
261:
262:
263: PROCEDURE Update_New_Offer_Adj_Line(
264: p_api_version_number IN NUMBER,
265: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268:
269: x_return_status OUT NOCOPY VARCHAR2,
262:
263: PROCEDURE Update_New_Offer_Adj_Line(
264: p_api_version_number IN NUMBER,
265: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268:
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
263: PROCEDURE Update_New_Offer_Adj_Line(
264: p_api_version_number IN NUMBER,
265: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
266: p_commit IN VARCHAR2 := FND_API.G_FALSE,
267: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
268:
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2,
287: -- Parameters
288: --
289: -- IN
290: -- p_api_version_number IN NUMBER Required
291: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
292: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
293: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
294: -- p_offer_adjustment_line_id IN NUMBER
295: -- p_object_version_number IN NUMBER Optional Default = NULL
288: --
289: -- IN
290: -- p_api_version_number IN NUMBER Required
291: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
292: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
293: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
294: -- p_offer_adjustment_line_id IN NUMBER
295: -- p_object_version_number IN NUMBER Optional Default = NULL
296: --
289: -- IN
290: -- p_api_version_number IN NUMBER Required
291: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
292: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
293: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
294: -- p_offer_adjustment_line_id IN NUMBER
295: -- p_object_version_number IN NUMBER Optional Default = NULL
296: --
297: -- OUT
310: -- ==============================================================================
311:
312: PROCEDURE Delete_Offer_Adj_Line(
313: p_api_version_number IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315: p_commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317: x_return_status OUT NOCOPY VARCHAR2,
318: x_msg_count OUT NOCOPY NUMBER,
311:
312: PROCEDURE Delete_Offer_Adj_Line(
313: p_api_version_number IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315: p_commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317: x_return_status OUT NOCOPY VARCHAR2,
318: x_msg_count OUT NOCOPY NUMBER,
319: x_msg_data OUT NOCOPY VARCHAR2,
312: PROCEDURE Delete_Offer_Adj_Line(
313: p_api_version_number IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315: p_commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
317: x_return_status OUT NOCOPY VARCHAR2,
318: x_msg_count OUT NOCOPY NUMBER,
319: x_msg_data OUT NOCOPY VARCHAR2,
320: p_offer_adjustment_line_id IN NUMBER,
333: -- Parameters
334: --
335: -- IN
336: -- p_api_version_number IN NUMBER Required
337: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
338: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
339: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
340: -- p_offadj_line_rec IN offadj_line_rec_type Required
341: --
334: --
335: -- IN
336: -- p_api_version_number IN NUMBER Required
337: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
338: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
339: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
340: -- p_offadj_line_rec IN offadj_line_rec_type Required
341: --
342: -- OUT
335: -- IN
336: -- p_api_version_number IN NUMBER Required
337: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
338: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
339: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
340: -- p_offadj_line_rec IN offadj_line_rec_type Required
341: --
342: -- OUT
343: -- x_return_status OUT VARCHAR2
355: -- ==============================================================================
356:
357: PROCEDURE Lock_Offer_Adj_Line(
358: p_api_version_number IN NUMBER,
359: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
360:
361: x_return_status OUT NOCOPY VARCHAR2,
362: x_msg_count OUT NOCOPY NUMBER,
363: x_msg_data OUT NOCOPY VARCHAR2,
389:
390:
391: PROCEDURE Validate_Offer_Adj_Line(
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_offadj_line_rec IN offadj_line_rec_type,
396: p_validation_mode IN VARCHAR2,
397: x_return_status OUT NOCOPY VARCHAR2,
390:
391: PROCEDURE Validate_Offer_Adj_Line(
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_offadj_line_rec IN offadj_line_rec_type,
396: p_validation_mode IN VARCHAR2,
397: x_return_status OUT NOCOPY VARCHAR2,
398: x_msg_count OUT NOCOPY NUMBER,
448:
449:
450: PROCEDURE Validate_Offadj_Line_Rec (
451: p_api_version_number IN NUMBER,
452: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,
456: p_offadj_line_rec IN offadj_line_rec_type