167: -- the sequence.
168: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
169: -- Raise exception for invalid flag.
170: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
171: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
172: ---------------------------------------------------------------------
173:
174: PROCEDURE create_event_offer(
175: p_api_version IN NUMBER,
172: ---------------------------------------------------------------------
173:
174: PROCEDURE create_event_offer(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
177: p_commit IN VARCHAR2 := FND_API.g_false,
178: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
179:
180: p_evo_rec IN evo_rec_type,
173:
174: PROCEDURE create_event_offer(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
177: p_commit IN VARCHAR2 := FND_API.g_false,
178: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
179:
180: p_evo_rec IN evo_rec_type,
181:
174: PROCEDURE create_event_offer(
175: p_api_version IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
177: p_commit IN VARCHAR2 := FND_API.g_false,
178: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
179:
180: p_evo_rec IN evo_rec_type,
181:
182: x_return_status OUT NOCOPY VARCHAR2,
202: -- 1. Raise exception if the object_version_number doesn't match.
203: --------------------------------------------------------------------
204: PROCEDURE delete_event_offer(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
207: p_commit IN VARCHAR2 := FND_API.g_false,
208:
209: p_evo_id IN NUMBER,
210: p_object_version IN NUMBER,
203: --------------------------------------------------------------------
204: PROCEDURE delete_event_offer(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
207: p_commit IN VARCHAR2 := FND_API.g_false,
208:
209: p_evo_id IN NUMBER,
210: p_object_version IN NUMBER,
211:
230: -- 1. Raise exception if the object_version_number doesn't match.
231: --------------------------------------------------------------------
232: PROCEDURE lock_event_offer(
233: p_api_version IN NUMBER,
234: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
235:
236: p_evo_id IN NUMBER,
237: p_object_version IN NUMBER,
238:
253: -- p_evo_rec: the record with new items
254: --
255: -- NOTES
256: -- 1. Raise exception if the object_version_number doesn't match.
257: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
258: -- that column won't be updated.
259: ----------------------------------------------------------------------
260: PROCEDURE update_event_offer(
261: p_api_version IN NUMBER,
258: -- that column won't be updated.
259: ----------------------------------------------------------------------
260: PROCEDURE update_event_offer(
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
263: p_commit IN VARCHAR2 := FND_API.g_false,
264: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
265:
266: p_evo_rec IN evo_rec_type,
259: ----------------------------------------------------------------------
260: PROCEDURE update_event_offer(
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
263: p_commit IN VARCHAR2 := FND_API.g_false,
264: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
265:
266: p_evo_rec IN evo_rec_type,
267:
260: PROCEDURE update_event_offer(
261: p_api_version IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
263: p_commit IN VARCHAR2 := FND_API.g_false,
264: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
265:
266: p_evo_rec IN evo_rec_type,
267:
268: x_return_status OUT NOCOPY VARCHAR2,
282: -- p_evo_rec: the event offer record to be validated
283: --
284: -- NOTES
285: -- 1. p_evo_rec should be the complete event offer record. There
286: -- should not be any FND_API.g_miss_char/num/date in it.
287: ----------------------------------------------------------------------
288: PROCEDURE validate_event_offer(
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
286: -- should not be any FND_API.g_miss_char/num/date in it.
287: ----------------------------------------------------------------------
288: PROCEDURE validate_event_offer(
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
291: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
292:
293: p_evo_rec IN evo_rec_type,
294:
287: ----------------------------------------------------------------------
288: PROCEDURE validate_event_offer(
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
291: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
292:
293: p_evo_rec IN evo_rec_type,
294:
295: x_return_status OUT NOCOPY VARCHAR2,
325: -- Check the record level business rules.
326: --
327: -- PARAMETERS
328: -- p_evo_rec: the record to be validated; may contain attributes
329: -- as FND_API.g_miss_char/num/date
330: -- p_complete_rec: the complete record after all "g_miss" items
331: -- have been replaced by current database values
332: ---------------------------------------------------------------------
333: PROCEDURE check_evo_record(
341: -- PROCEDURE
342: -- init_evo_rec
343: --
344: -- PURPOSE
345: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
346: ---------------------------------------------------------------------
347: PROCEDURE init_evo_rec(
348: x_evo_rec OUT NOCOPY evo_rec_type
349: );
354: -- complete_evo_rec
355: --
356: -- PURPOSE
357: -- For update_event_offer, some attributes may be passed in as
358: -- FND_API.g_miss_char/num/date if the user doesn't want to
359: -- update those attributes. This procedure will replace the
360: -- "g_miss" attributes with current database values.
361: --
362: -- PARAMETERS
360: -- "g_miss" attributes with current database values.
361: --
362: -- PARAMETERS
363: -- p_evo_rec: the record which may contain attributes as
364: -- FND_API.g_miss_char/num/date
365: -- x_complete_rec: the complete record after all "g_miss" items
366: -- have been replaced by current database values
367: ---------------------------------------------------------------------
368: PROCEDURE complete_evo_rec(