343: -- the sequence.
344: ---------------------------------------------------------------------
345: PROCEDURE Create_Claim (
346: p_api_version IN NUMBER
347: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
348: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
349: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
350:
351: ,x_return_status OUT NOCOPY VARCHAR2
344: ---------------------------------------------------------------------
345: PROCEDURE Create_Claim (
346: p_api_version IN NUMBER
347: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
348: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
349: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
350:
351: ,x_return_status OUT NOCOPY VARCHAR2
352: ,x_msg_data OUT NOCOPY VARCHAR2
345: PROCEDURE Create_Claim (
346: p_api_version IN NUMBER
347: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
348: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
349: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
350:
351: ,x_return_status OUT NOCOPY VARCHAR2
352: ,x_msg_data OUT NOCOPY VARCHAR2
353: ,x_msg_count OUT NOCOPY NUMBER
370: -- 1. Raise exception if the object_version_number doesn't match.
371: ----------------------------------------------------------------------
372: PROCEDURE Update_Claim (
373: p_api_version IN NUMBER
374: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
375: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
376: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
377:
378: ,x_return_status OUT NOCOPY VARCHAR2
371: ----------------------------------------------------------------------
372: PROCEDURE Update_Claim (
373: p_api_version IN NUMBER
374: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
375: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
376: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
377:
378: ,x_return_status OUT NOCOPY VARCHAR2
379: ,x_msg_data OUT NOCOPY VARCHAR2
372: PROCEDURE Update_Claim (
373: p_api_version IN NUMBER
374: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
375: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
376: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
377:
378: ,x_return_status OUT NOCOPY VARCHAR2
379: ,x_msg_data OUT NOCOPY VARCHAR2
380: ,x_msg_count OUT NOCOPY NUMBER
399: -- 1. Raise exception if the object_version_number doesn't match.
400: ----------------------------------------------------------------------
401: PROCEDURE Delete_Claim (
402: p_api_version_number IN NUMBER
403: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
404: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
405: ,p_object_id IN NUMBER
406: ,p_object_version_number IN NUMBER
407: ,x_return_status OUT NOCOPY VARCHAR2
400: ----------------------------------------------------------------------
401: PROCEDURE Delete_Claim (
402: p_api_version_number IN NUMBER
403: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
404: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
405: ,p_object_id IN NUMBER
406: ,p_object_version_number IN NUMBER
407: ,x_return_status OUT NOCOPY VARCHAR2
408: ,x_msg_count OUT NOCOPY NUMBER
423: --
424: ----------------------------------------------------------------------
425: PROCEDURE Validate_Claim (
426: p_api_version IN NUMBER
427: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
428: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
429: ,x_return_status OUT NOCOPY VARCHAR2
430: ,x_msg_count OUT NOCOPY NUMBER
431: ,x_msg_data OUT NOCOPY VARCHAR2
424: ----------------------------------------------------------------------
425: PROCEDURE Validate_Claim (
426: p_api_version IN NUMBER
427: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
428: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
429: ,x_return_status OUT NOCOPY VARCHAR2
430: ,x_msg_count OUT NOCOPY NUMBER
431: ,x_msg_data OUT NOCOPY VARCHAR2
432: ,p_claim IN claim_rec_type
446: --
447: ----------------------------------------------------------------------
448: PROCEDURE Check_Claim_Common_Element (
449: p_api_version IN NUMBER
450: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
451: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
452: ,x_return_status OUT NOCOPY VARCHAR2
453: ,x_msg_count OUT NOCOPY NUMBER
454: ,x_msg_data OUT NOCOPY VARCHAR2
447: ----------------------------------------------------------------------
448: PROCEDURE Check_Claim_Common_Element (
449: p_api_version IN NUMBER
450: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
451: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
452: ,x_return_status OUT NOCOPY VARCHAR2
453: ,x_msg_count OUT NOCOPY NUMBER
454: ,x_msg_data OUT NOCOPY VARCHAR2
455: ,p_claim IN claim_rec_type
479: -- Complete_Claim_Rec
480: --
481: -- PURPOSE
482: -- For Update_Claim, some attributes may be passed in as
483: -- FND_API.g_miss_char/num/date if the user doesn't want to
484: -- update those attributes. This procedure will replace the
485: -- "g_miss" attributes with current database values.
486: --
487: -- PARAMETERS
485: -- "g_miss" attributes with current database values.
486: --
487: -- PARAMETERS
488: -- p_claim_rec : the record which may contain attributes as
489: -- FND_API.g_miss_char/num/date
490: -- x_complete_rec: the complete record after all "g_miss" items
491: -- have been replaced by current database values
492: ---------------------------------------------------------------------
493: PROCEDURE Complete_Claim_Rec (
557: -- x_dependent_object_tbl OUT ozf_utility_pvt.dependent_objects_tbl_type
558: ---------------------------------------------------------------------
559: PROCEDURE Validate_Delete_Claim (
560: p_api_version_number IN NUMBER,
561: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
562: p_commit IN VARCHAR2 := FND_API.G_FALSE,
563: p_object_id IN NUMBER,
564: p_object_version_number IN NUMBER,
565: x_dependent_object_tbl OUT NOCOPY ams_utility_pvt.dependent_objects_tbl_type,
558: ---------------------------------------------------------------------
559: PROCEDURE Validate_Delete_Claim (
560: p_api_version_number IN NUMBER,
561: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
562: p_commit IN VARCHAR2 := FND_API.G_FALSE,
563: p_object_id IN NUMBER,
564: p_object_version_number IN NUMBER,
565: x_dependent_object_tbl OUT NOCOPY ams_utility_pvt.dependent_objects_tbl_type,
566: x_return_status OUT NOCOPY VARCHAR2,
584: -- Raise exception in case of duplicates.
585: ---------------------------------------------------------------------
586: PROCEDURE Create_Claim_tbl (
587: p_api_version IN NUMBER
588: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
589: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
590: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
591:
592: ,x_return_status OUT NOCOPY VARCHAR2
585: ---------------------------------------------------------------------
586: PROCEDURE Create_Claim_tbl (
587: p_api_version IN NUMBER
588: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
589: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
590: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
591:
592: ,x_return_status OUT NOCOPY VARCHAR2
593: ,x_msg_data OUT NOCOPY VARCHAR2
586: PROCEDURE Create_Claim_tbl (
587: p_api_version IN NUMBER
588: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
589: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
590: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
591:
592: ,x_return_status OUT NOCOPY VARCHAR2
593: ,x_msg_data OUT NOCOPY VARCHAR2
594: ,x_msg_count OUT NOCOPY NUMBER
618: -- Raise exception in case of duplicates.
619: ---------------------------------------------------------------------
620: PROCEDURE Update_Claim_tbl (
621: p_api_version IN NUMBER
622: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
623: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
624: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
625:
626: ,x_return_status OUT NOCOPY VARCHAR2
619: ---------------------------------------------------------------------
620: PROCEDURE Update_Claim_tbl (
621: p_api_version IN NUMBER
622: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
623: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
624: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
625:
626: ,x_return_status OUT NOCOPY VARCHAR2
627: ,x_msg_data OUT NOCOPY VARCHAR2
620: PROCEDURE Update_Claim_tbl (
621: p_api_version IN NUMBER
622: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
623: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
624: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
625:
626: ,x_return_status OUT NOCOPY VARCHAR2
627: ,x_msg_data OUT NOCOPY VARCHAR2
628: ,x_msg_count OUT NOCOPY NUMBER