351: -- the sequence.
352: ---------------------------------------------------------------------
353: PROCEDURE Create_Claim (
354: p_api_version IN NUMBER
355: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
356: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
357: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
358:
359: ,x_return_status OUT NOCOPY VARCHAR2
352: ---------------------------------------------------------------------
353: PROCEDURE Create_Claim (
354: p_api_version IN NUMBER
355: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
356: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
357: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
358:
359: ,x_return_status OUT NOCOPY VARCHAR2
360: ,x_msg_data OUT NOCOPY VARCHAR2
353: PROCEDURE Create_Claim (
354: p_api_version IN NUMBER
355: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
356: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
357: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
358:
359: ,x_return_status OUT NOCOPY VARCHAR2
360: ,x_msg_data OUT NOCOPY VARCHAR2
361: ,x_msg_count OUT NOCOPY NUMBER
378: -- 1. Raise exception if the object_version_number doesn't match.
379: ----------------------------------------------------------------------
380: PROCEDURE Update_Claim (
381: p_api_version IN NUMBER
382: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
383: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
384: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
385:
386: ,x_return_status OUT NOCOPY VARCHAR2
379: ----------------------------------------------------------------------
380: PROCEDURE Update_Claim (
381: p_api_version IN NUMBER
382: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
383: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
384: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
385:
386: ,x_return_status OUT NOCOPY VARCHAR2
387: ,x_msg_data OUT NOCOPY VARCHAR2
380: PROCEDURE Update_Claim (
381: p_api_version IN NUMBER
382: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
383: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
384: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
385:
386: ,x_return_status OUT NOCOPY VARCHAR2
387: ,x_msg_data OUT NOCOPY VARCHAR2
388: ,x_msg_count OUT NOCOPY NUMBER
407: -- 1. Raise exception if the object_version_number doesn't match.
408: ----------------------------------------------------------------------
409: PROCEDURE Delete_Claim (
410: p_api_version_number IN NUMBER
411: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
412: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
413: ,p_object_id IN NUMBER
414: ,p_object_version_number IN NUMBER
415: ,x_return_status OUT NOCOPY VARCHAR2
408: ----------------------------------------------------------------------
409: PROCEDURE Delete_Claim (
410: p_api_version_number IN NUMBER
411: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
412: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
413: ,p_object_id IN NUMBER
414: ,p_object_version_number IN NUMBER
415: ,x_return_status OUT NOCOPY VARCHAR2
416: ,x_msg_count OUT NOCOPY NUMBER
431: --
432: ----------------------------------------------------------------------
433: PROCEDURE Validate_Claim (
434: p_api_version IN NUMBER
435: ,p_init_msg_list 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: ----------------------------------------------------------------------
433: PROCEDURE Validate_Claim (
434: p_api_version IN NUMBER
435: ,p_init_msg_list 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_claim IN claim_rec_type
454: --
455: ----------------------------------------------------------------------
456: PROCEDURE Check_Claim_Common_Element (
457: p_api_version IN NUMBER
458: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
459: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
460: ,x_return_status OUT NOCOPY VARCHAR2
461: ,x_msg_count OUT NOCOPY NUMBER
462: ,x_msg_data OUT NOCOPY VARCHAR2
455: ----------------------------------------------------------------------
456: PROCEDURE Check_Claim_Common_Element (
457: p_api_version IN NUMBER
458: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
459: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
460: ,x_return_status OUT NOCOPY VARCHAR2
461: ,x_msg_count OUT NOCOPY NUMBER
462: ,x_msg_data OUT NOCOPY VARCHAR2
463: ,p_claim IN claim_rec_type
487: -- Complete_Claim_Rec
488: --
489: -- PURPOSE
490: -- For Update_Claim, some attributes may be passed in as
491: -- FND_API.g_miss_char/num/date if the user doesn't want to
492: -- update those attributes. This procedure will replace the
493: -- "g_miss" attributes with current database values.
494: --
495: -- PARAMETERS
493: -- "g_miss" attributes with current database values.
494: --
495: -- PARAMETERS
496: -- p_claim_rec : the record which may contain attributes as
497: -- FND_API.g_miss_char/num/date
498: -- x_complete_rec: the complete record after all "g_miss" items
499: -- have been replaced by current database values
500: ---------------------------------------------------------------------
501: PROCEDURE Complete_Claim_Rec (
565: -- x_dependent_object_tbl OUT ozf_utility_pvt.dependent_objects_tbl_type
566: ---------------------------------------------------------------------
567: PROCEDURE Validate_Delete_Claim (
568: p_api_version_number IN NUMBER,
569: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
570: p_commit IN VARCHAR2 := FND_API.G_FALSE,
571: p_object_id IN NUMBER,
572: p_object_version_number IN NUMBER,
573: x_dependent_object_tbl OUT NOCOPY ams_utility_pvt.dependent_objects_tbl_type,
566: ---------------------------------------------------------------------
567: PROCEDURE Validate_Delete_Claim (
568: p_api_version_number IN NUMBER,
569: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
570: p_commit IN VARCHAR2 := FND_API.G_FALSE,
571: p_object_id IN NUMBER,
572: p_object_version_number IN NUMBER,
573: x_dependent_object_tbl OUT NOCOPY ams_utility_pvt.dependent_objects_tbl_type,
574: x_return_status OUT NOCOPY VARCHAR2,
592: -- Raise exception in case of duplicates.
593: ---------------------------------------------------------------------
594: PROCEDURE Create_Claim_tbl (
595: p_api_version IN NUMBER
596: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
597: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
598: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
599:
600: ,x_return_status OUT NOCOPY VARCHAR2
593: ---------------------------------------------------------------------
594: PROCEDURE Create_Claim_tbl (
595: p_api_version IN NUMBER
596: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
597: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
598: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
599:
600: ,x_return_status OUT NOCOPY VARCHAR2
601: ,x_msg_data OUT NOCOPY VARCHAR2
594: PROCEDURE Create_Claim_tbl (
595: p_api_version IN NUMBER
596: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
597: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
598: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
599:
600: ,x_return_status OUT NOCOPY VARCHAR2
601: ,x_msg_data OUT NOCOPY VARCHAR2
602: ,x_msg_count OUT NOCOPY NUMBER
626: -- Raise exception in case of duplicates.
627: ---------------------------------------------------------------------
628: PROCEDURE Update_Claim_tbl (
629: p_api_version IN NUMBER
630: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
631: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
632: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
633:
634: ,x_return_status OUT NOCOPY VARCHAR2
627: ---------------------------------------------------------------------
628: PROCEDURE Update_Claim_tbl (
629: p_api_version IN NUMBER
630: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
631: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
632: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
633:
634: ,x_return_status OUT NOCOPY VARCHAR2
635: ,x_msg_data OUT NOCOPY VARCHAR2
628: PROCEDURE Update_Claim_tbl (
629: p_api_version IN NUMBER
630: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
631: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
632: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
633:
634: ,x_return_status OUT NOCOPY VARCHAR2
635: ,x_msg_data OUT NOCOPY VARCHAR2
636: ,x_msg_count OUT NOCOPY NUMBER