DBA Data[Home] [Help]

APPS.AMS_LISTHEADER_PVT dependencies on FND_API

Line 171: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 172: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 173: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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,

Line 196: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

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

Line 202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 203: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 204: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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

Line 229: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 230: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 231: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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

Line 257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 258: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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,

Line 280: -- should not be any FND_API.g_miss_char/num/date in it.

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

Line 286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 287: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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

Line 327: -- as FND_API.g_miss_char/num/date

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

Line 345: -- Initialize all attributes to be FND_API.g_miss_char/num/date.

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: );

Line 358: -- FND_API.g_miss_char/num/date if the user doesn't want to

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

Line 364: -- FND_API.g_miss_char/num/date

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(

Line 375: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

Line 376: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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: );

Line 402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

Line 403: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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: );

Line 434: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 435: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 436: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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,