167: -- End Of Comments
168:
169: PROCEDURE Create_Listheader
170: ( p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
168:
169: PROCEDURE Create_Listheader
170: ( p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
169: PROCEDURE Create_Listheader
170: ( p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172: p_commit IN VARCHAR2 := FND_API.G_FALSE,
173: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_listheader_rec IN list_header_rec_type,
192: -- p_listheader_rec The Record to be Updated.
193:
194: -- NOTES
195: -- 1. Raise exception if the object_version_number doesn't match.
196: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
197: -- that column won't be updated.
198: -- End Of Comments
199:
200: PROCEDURE Update_ListHeader
198: -- End Of Comments
199:
200: PROCEDURE Update_ListHeader
201: ( p_api_version 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: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
199:
200: PROCEDURE Update_ListHeader
201: ( p_api_version 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: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
200: PROCEDURE Update_ListHeader
201: ( p_api_version 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: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_listheader_rec IN list_header_rec_type
225: --------------------------------------------------------------------
226:
227: PROCEDURE Delete_ListHeader
228: ( p_api_version IN NUMBER,
229: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
230: p_commit IN VARCHAR2 := FND_API.G_FALSE,
231: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
226:
227: PROCEDURE Delete_ListHeader
228: ( p_api_version IN NUMBER,
229: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
230: p_commit IN VARCHAR2 := FND_API.G_FALSE,
231: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
227: PROCEDURE Delete_ListHeader
228: ( p_api_version IN NUMBER,
229: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
230: p_commit IN VARCHAR2 := FND_API.G_FALSE,
231: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_listheader_id IN NUMBER
253: -- End Of Comments
254:
255: PROCEDURE Lock_ListHeader
256: ( p_api_version IN NUMBER,
257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2,
254:
255: PROCEDURE Lock_ListHeader
256: ( p_api_version IN NUMBER,
257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2,
262: p_listheader_id IN NUMBER,
276: -- p_listheader_rec: the list header record to be validated
277: --
278: -- NOTES
279: -- 1. p_listheader_rec_rec should be the complete list header record. There
280: -- should not be any FND_API.g_miss_char/num/date in it.
281: ----------------------------------------------------------------------
282: -- End Of Comments
283:
284: PROCEDURE Validate_ListHeader
282: -- End Of Comments
283:
284: PROCEDURE Validate_ListHeader
285: ( p_api_version IN NUMBER,
286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
287: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
288: x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
283:
284: PROCEDURE Validate_ListHeader
285: ( p_api_version IN NUMBER,
286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
287: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
288: x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
291: p_listheader_rec IN list_header_rec_type
323: -- Validate the list record level business rules.
324: --
325: -- PARAMETERS
326: -- p_listheader_rec: the record to be validated; may contain attributes
327: -- as FND_API.g_miss_char/num/date
328: -- p_complete_rec: the complete record after all "g_miss" items
329: -- have been replaced by current database values
330: ---------------------------------------------------------------------
331: -- End Of Comments
341: -- PROCEDURE
342: -- Init_ListHeader_rec
343: --
344: -- PURPOSE
345: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
346: ---------------------------------------------------------------------
347: PROCEDURE Init_ListHeader_rec(
348: x_listheader_rec OUT NOCOPY list_header_rec_type
349: );
354: -- Complete_ListHeader_rec
355: --
356: -- PURPOSE
357: -- For update_listheader, 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_listheader_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_ListHeader_rec(
371: );
372:
373: PROCEDURE Update_list_header_count(
374: p_list_header_id IN number,
375: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
376: p_commit IN VARCHAR2 := FND_API.G_FALSE,
377: x_return_status OUT NOCOPY VARCHAR2,
378: x_msg_count OUT NOCOPY NUMBER,
379: x_msg_data OUT NOCOPY VARCHAR2
372:
373: PROCEDURE Update_list_header_count(
374: p_list_header_id IN number,
375: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
376: p_commit IN VARCHAR2 := FND_API.G_FALSE,
377: x_return_status OUT NOCOPY VARCHAR2,
378: x_msg_count OUT NOCOPY NUMBER,
379: x_msg_data OUT NOCOPY VARCHAR2
380: );
398: PROCEDURE Update_Prev_contacted_count(
399: p_used_by_id IN number,
400: p_used_by IN VARCHAR2,
401: p_last_contacted_date IN DATE,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: x_return_status OUT NOCOPY VARCHAR2,
405: x_msg_count OUT NOCOPY NUMBER,
406: x_msg_data OUT NOCOPY VARCHAR2
399: p_used_by_id IN number,
400: p_used_by IN VARCHAR2,
401: p_last_contacted_date IN DATE,
402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
404: x_return_status OUT NOCOPY VARCHAR2,
405: x_msg_count OUT NOCOPY NUMBER,
406: x_msg_data OUT NOCOPY VARCHAR2
407: );
430:
431:
432: PROCEDURE Copy_List
433: ( p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
436: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
431:
432: PROCEDURE Copy_List
433: ( p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
436: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2,
432: PROCEDURE Copy_List
433: ( p_api_version IN NUMBER,
434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
436: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
437: x_return_status OUT NOCOPY VARCHAR2,
438: x_msg_count OUT NOCOPY NUMBER,
439: x_msg_data OUT NOCOPY VARCHAR2,
440: p_source_listheader_id IN NUMBER,