315: -- the sequence.
316: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
317: -- Raise exception for invalid flag.
318: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
319: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
320: --------------------------------------------------------------------
321: PROCEDURE Create_Party (
322: p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
319: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
320: --------------------------------------------------------------------
321: PROCEDURE Create_Party (
322: p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
324: p_commit IN VARCHAR2 := FND_API.g_false,
325: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
326:
327: x_return_status OUT NOCOPY VARCHAR2,
320: --------------------------------------------------------------------
321: PROCEDURE Create_Party (
322: p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
324: p_commit IN VARCHAR2 := FND_API.g_false,
325: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
326:
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,
321: PROCEDURE Create_Party (
322: p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
324: p_commit IN VARCHAR2 := FND_API.g_false,
325: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
326:
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,
329: x_msg_data OUT NOCOPY VARCHAR2,
352: -- 1. Raise exception if the object_version_number doesn't match.
353: --------------------------------------------------------------------
354: PROCEDURE Delete_Party (
355: p_api_version IN NUMBER,
356: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
357: p_commit IN VARCHAR2 := FND_API.g_false,
358: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
359:
360: x_return_status OUT NOCOPY VARCHAR2,
353: --------------------------------------------------------------------
354: PROCEDURE Delete_Party (
355: p_api_version IN NUMBER,
356: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
357: p_commit IN VARCHAR2 := FND_API.g_false,
358: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
359:
360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,
354: PROCEDURE Delete_Party (
355: p_api_version IN NUMBER,
356: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
357: p_commit IN VARCHAR2 := FND_API.g_false,
358: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
359:
360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,
383: -- 1. Raise exception if the object_version_number doesn't match.
384: --------------------------------------------------------------------
385: PROCEDURE Lock_Party (
386: p_api_version IN NUMBER,
387: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
388: p_commit IN VARCHAR2 := FND_API.g_false,
389: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
390:
391: x_return_status OUT NOCOPY VARCHAR2,
384: --------------------------------------------------------------------
385: PROCEDURE Lock_Party (
386: p_api_version IN NUMBER,
387: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
388: p_commit IN VARCHAR2 := FND_API.g_false,
389: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
390:
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
385: PROCEDURE Lock_Party (
386: p_api_version IN NUMBER,
387: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
388: p_commit IN VARCHAR2 := FND_API.g_false,
389: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
390:
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,
408: -- p_party_rec: the record representing AMS_PARTY_SOURCES.
409: --
410: -- NOTES
411: -- 1. Raise exception if the object_version_number doesn't match.
412: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
413: -- that column won't be updated.
414: --------------------------------------------------------------------
415: PROCEDURE Update_Party (
416: p_api_version IN NUMBER,
413: -- that column won't be updated.
414: --------------------------------------------------------------------
415: PROCEDURE Update_Party (
416: p_api_version IN NUMBER,
417: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
418: p_commit IN VARCHAR2 := FND_API.g_false,
419: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
420:
421: x_return_status OUT NOCOPY VARCHAR2,
414: --------------------------------------------------------------------
415: PROCEDURE Update_Party (
416: p_api_version IN NUMBER,
417: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
418: p_commit IN VARCHAR2 := FND_API.g_false,
419: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
420:
421: x_return_status OUT NOCOPY VARCHAR2,
422: x_msg_count OUT NOCOPY NUMBER,
415: PROCEDURE Update_Party (
416: p_api_version IN NUMBER,
417: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
418: p_commit IN VARCHAR2 := FND_API.g_false,
419: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
420:
421: x_return_status OUT NOCOPY VARCHAR2,
422: x_msg_count OUT NOCOPY NUMBER,
423: x_msg_data OUT NOCOPY VARCHAR2,
437: -- p_party_rec: the record representing AMS_PARTY_SOURCES.
438: --
439: -- NOTES
440: -- 1. p_party_rec should be the complete list header record. There
441: -- should not be any FND_API.g_miss_char/num/date in it.
442: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
443: -- an exception, as those values are not handled.
444: --------------------------------------------------------------------
445: PROCEDURE Validate_Party (
438: --
439: -- NOTES
440: -- 1. p_party_rec should be the complete list header record. There
441: -- should not be any FND_API.g_miss_char/num/date in it.
442: -- 2. If FND_API.g_miss_char/num/date is in the record, then raise
443: -- an exception, as those values are not handled.
444: --------------------------------------------------------------------
445: PROCEDURE Validate_Party (
446: p_api_version IN NUMBER,
443: -- an exception, as those values are not handled.
444: --------------------------------------------------------------------
445: PROCEDURE Validate_Party (
446: p_api_version IN NUMBER,
447: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
448: p_commit IN VARCHAR2 := FND_API.g_false,
449: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
450:
451: x_return_status OUT NOCOPY VARCHAR2,
444: --------------------------------------------------------------------
445: PROCEDURE Validate_Party (
446: p_api_version IN NUMBER,
447: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
448: p_commit IN VARCHAR2 := FND_API.g_false,
449: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
450:
451: x_return_status OUT NOCOPY VARCHAR2,
452: x_msg_count OUT NOCOPY NUMBER,
445: PROCEDURE Validate_Party (
446: p_api_version IN NUMBER,
447: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
448: p_commit IN VARCHAR2 := FND_API.g_false,
449: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
450:
451: x_return_status OUT NOCOPY VARCHAR2,
452: x_msg_count OUT NOCOPY NUMBER,
453: x_msg_data OUT NOCOPY VARCHAR2,
483: -- Check the record level business rules.
484: --
485: -- PARAMETERS
486: -- p_party_rec: the record to be validated; may contain attributes
487: -- as FND_API.g_miss_char/num/date
488: -- p_complete_rec: the complete record after all "g_miss" items
489: -- have been replaced by current database values
490: ---------------------------------------------------------------------
491: PROCEDURE Check_Party_Record (
499: -- PROCEDURE
500: -- Init_Party_Rec
501: --
502: -- PURPOSE
503: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
504: ---------------------------------------------------------------------
505: PROCEDURE Init_Party_Rec (
506: x_party_rec OUT NOCOPY Party_Rec_Type
507: );
512: -- Complete_Party_Rec
513: --
514: -- PURPOSE
515: -- For Update_Party, some attributes may be passed in as
516: -- FND_API.g_miss_char/num/date if the user doesn't want to
517: -- update those attributes. This procedure will replace the
518: -- "g_miss" attributes with current database values.
519: --
520: -- PARAMETERS
518: -- "g_miss" attributes with current database values.
519: --
520: -- PARAMETERS
521: -- p_listdr_rec: the record which may contain attributes as
522: -- FND_API.g_miss_char/num/date
523: -- x_complete_rec: the complete record after all "g_miss" items
524: -- have been replaced by current database values
525: ---------------------------------------------------------------------
526: PROCEDURE Complete_Party_Rec (
553: -- are then created in AMS_PARTY_SOURCES.
554: --------------------------------------------------------------------
555: PROCEDURE Process_Party (
556: p_api_version IN NUMBER,
557: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
558: p_commit IN VARCHAR2 := FND_API.g_false,
559: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
560:
561: x_return_status OUT NOCOPY VARCHAR2,
554: --------------------------------------------------------------------
555: PROCEDURE Process_Party (
556: p_api_version IN NUMBER,
557: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
558: p_commit IN VARCHAR2 := FND_API.g_false,
559: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
560:
561: x_return_status OUT NOCOPY VARCHAR2,
562: x_msg_count OUT NOCOPY NUMBER,
555: PROCEDURE Process_Party (
556: p_api_version IN NUMBER,
557: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
558: p_commit IN VARCHAR2 := FND_API.g_false,
559: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
560:
561: x_return_status OUT NOCOPY VARCHAR2,
562: x_msg_count OUT NOCOPY NUMBER,
563: x_msg_data OUT NOCOPY VARCHAR2,