eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PRTT_ENRT_CTFN_PRVDD_API dependencies on HR_API

Line 102: l_datetrack_mode varchar2(30) := hr_api.g_delete;

98: l_proc varchar2(72) := g_package||'.check_dnd_ctfns';
99: l_effective_start_date date;
100: l_effective_end_date date;
101: l_object_version_number number;
102: l_datetrack_mode varchar2(30) := hr_api.g_delete;
103: l_del_enrt varchar2(1) := 'N';
104: l_per_in_ler_id number;
105: --
106: -- Check if any required is denied.

Line 191: l_datetrack_mode := hr_api.g_zap;

187: null; -- result is not suspended, do nothing
188: else
189: --
190: if l_effective_start_date = p_effective_date then
191: l_datetrack_mode := hr_api.g_zap;
192: end if;
193: -- this will end date the enrollment, it's action items and it's
194: -- certifications (all the children).
195: hr_utility.set_location('Leaving:'|| l_proc, 40);

Line 436: when hr_api.cannot_find_prog_unit then

432: ,p_pcs_attribute30 => p_pcs_attribute30
433: ,p_effective_date => trunc(p_effective_date)
434: );
435: exception
436: when hr_api.cannot_find_prog_unit then
437: hr_api.cannot_find_prog_unit_error
438: (
439: p_module_name => 'CREATE_PRTT_ENRT_CTFN_PRVDD'
440: ,p_hook_type => 'BP'

Line 437: hr_api.cannot_find_prog_unit_error

433: ,p_effective_date => trunc(p_effective_date)
434: );
435: exception
436: when hr_api.cannot_find_prog_unit then
437: hr_api.cannot_find_prog_unit_error
438: (
439: p_module_name => 'CREATE_PRTT_ENRT_CTFN_PRVDD'
440: ,p_hook_type => 'BP'
441: );

Line 547: when hr_api.cannot_find_prog_unit then

543: ,p_object_version_number => l_object_version_number
544: ,p_effective_date => trunc(p_effective_date)
545: );
546: exception
547: when hr_api.cannot_find_prog_unit then
548: hr_api.cannot_find_prog_unit_error
549: (p_module_name => 'CREATE_PRTT_ENRT_CTFN_PRVDD'
550: ,p_hook_type => 'AP'
551: );

Line 548: hr_api.cannot_find_prog_unit_error

544: ,p_effective_date => trunc(p_effective_date)
545: );
546: exception
547: when hr_api.cannot_find_prog_unit then
548: hr_api.cannot_find_prog_unit_error
549: (p_module_name => 'CREATE_PRTT_ENRT_CTFN_PRVDD'
550: ,p_hook_type => 'AP'
551: );
552: --

Line 562: raise hr_api.validate_enabled;

558: --
559: -- When in validation only mode raise the Validate_Enabled exception
560: --
561: if p_validate then
562: raise hr_api.validate_enabled;
563: end if;
564: --
565: -- Set all output arguments
566: --

Line 576: when hr_api.validate_enabled then

572: hr_utility.set_location(' Leaving:'||l_proc, 70);
573: --
574: exception
575: --
576: when hr_api.validate_enabled then
577: --
578: -- As the Validate_Enabled exception has been raised
579: -- we must rollback to the savepoint
580: --

Line 617: ,p_enrt_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

613: (p_validate in boolean default false
614: ,p_prtt_enrt_ctfn_prvdd_id in number
615: ,p_effective_start_date out nocopy date
616: ,p_effective_end_date out nocopy date
617: ,p_enrt_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
618: ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
619: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date
620: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
621: ,p_enrt_r_bnft_ctfn_cd in varchar2 default hr_api.g_varchar2

Line 618: ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2

614: ,p_prtt_enrt_ctfn_prvdd_id in number
615: ,p_effective_start_date out nocopy date
616: ,p_effective_end_date out nocopy date
617: ,p_enrt_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
618: ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
619: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date
620: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
621: ,p_enrt_r_bnft_ctfn_cd in varchar2 default hr_api.g_varchar2
622: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

Line 619: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date

615: ,p_effective_start_date out nocopy date
616: ,p_effective_end_date out nocopy date
617: ,p_enrt_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
618: ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
619: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date
620: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
621: ,p_enrt_r_bnft_ctfn_cd in varchar2 default hr_api.g_varchar2
622: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
623: ,p_prtt_enrt_actn_id in number default hr_api.g_number

Line 620: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date

616: ,p_effective_end_date out nocopy date
617: ,p_enrt_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
618: ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
619: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date
620: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
621: ,p_enrt_r_bnft_ctfn_cd in varchar2 default hr_api.g_varchar2
622: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
623: ,p_prtt_enrt_actn_id in number default hr_api.g_number
624: ,p_business_group_id in number default hr_api.g_number

Line 621: ,p_enrt_r_bnft_ctfn_cd in varchar2 default hr_api.g_varchar2

617: ,p_enrt_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
618: ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
619: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date
620: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
621: ,p_enrt_r_bnft_ctfn_cd in varchar2 default hr_api.g_varchar2
622: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
623: ,p_prtt_enrt_actn_id in number default hr_api.g_number
624: ,p_business_group_id in number default hr_api.g_number
625: ,p_pcs_attribute_category in varchar2 default hr_api.g_varchar2

Line 622: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

618: ,p_enrt_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
619: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date
620: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
621: ,p_enrt_r_bnft_ctfn_cd in varchar2 default hr_api.g_varchar2
622: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
623: ,p_prtt_enrt_actn_id in number default hr_api.g_number
624: ,p_business_group_id in number default hr_api.g_number
625: ,p_pcs_attribute_category in varchar2 default hr_api.g_varchar2
626: ,p_pcs_attribute1 in varchar2 default hr_api.g_varchar2

Line 623: ,p_prtt_enrt_actn_id in number default hr_api.g_number

619: ,p_enrt_ctfn_recd_dt in date default hr_api.g_date
620: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
621: ,p_enrt_r_bnft_ctfn_cd in varchar2 default hr_api.g_varchar2
622: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
623: ,p_prtt_enrt_actn_id in number default hr_api.g_number
624: ,p_business_group_id in number default hr_api.g_number
625: ,p_pcs_attribute_category in varchar2 default hr_api.g_varchar2
626: ,p_pcs_attribute1 in varchar2 default hr_api.g_varchar2
627: ,p_pcs_attribute2 in varchar2 default hr_api.g_varchar2

Line 624: ,p_business_group_id in number default hr_api.g_number

620: ,p_enrt_ctfn_dnd_dt in date default hr_api.g_date
621: ,p_enrt_r_bnft_ctfn_cd in varchar2 default hr_api.g_varchar2
622: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
623: ,p_prtt_enrt_actn_id in number default hr_api.g_number
624: ,p_business_group_id in number default hr_api.g_number
625: ,p_pcs_attribute_category in varchar2 default hr_api.g_varchar2
626: ,p_pcs_attribute1 in varchar2 default hr_api.g_varchar2
627: ,p_pcs_attribute2 in varchar2 default hr_api.g_varchar2
628: ,p_pcs_attribute3 in varchar2 default hr_api.g_varchar2

Line 625: ,p_pcs_attribute_category in varchar2 default hr_api.g_varchar2

621: ,p_enrt_r_bnft_ctfn_cd in varchar2 default hr_api.g_varchar2
622: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
623: ,p_prtt_enrt_actn_id in number default hr_api.g_number
624: ,p_business_group_id in number default hr_api.g_number
625: ,p_pcs_attribute_category in varchar2 default hr_api.g_varchar2
626: ,p_pcs_attribute1 in varchar2 default hr_api.g_varchar2
627: ,p_pcs_attribute2 in varchar2 default hr_api.g_varchar2
628: ,p_pcs_attribute3 in varchar2 default hr_api.g_varchar2
629: ,p_pcs_attribute4 in varchar2 default hr_api.g_varchar2

Line 626: ,p_pcs_attribute1 in varchar2 default hr_api.g_varchar2

622: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
623: ,p_prtt_enrt_actn_id in number default hr_api.g_number
624: ,p_business_group_id in number default hr_api.g_number
625: ,p_pcs_attribute_category in varchar2 default hr_api.g_varchar2
626: ,p_pcs_attribute1 in varchar2 default hr_api.g_varchar2
627: ,p_pcs_attribute2 in varchar2 default hr_api.g_varchar2
628: ,p_pcs_attribute3 in varchar2 default hr_api.g_varchar2
629: ,p_pcs_attribute4 in varchar2 default hr_api.g_varchar2
630: ,p_pcs_attribute5 in varchar2 default hr_api.g_varchar2

Line 627: ,p_pcs_attribute2 in varchar2 default hr_api.g_varchar2

623: ,p_prtt_enrt_actn_id in number default hr_api.g_number
624: ,p_business_group_id in number default hr_api.g_number
625: ,p_pcs_attribute_category in varchar2 default hr_api.g_varchar2
626: ,p_pcs_attribute1 in varchar2 default hr_api.g_varchar2
627: ,p_pcs_attribute2 in varchar2 default hr_api.g_varchar2
628: ,p_pcs_attribute3 in varchar2 default hr_api.g_varchar2
629: ,p_pcs_attribute4 in varchar2 default hr_api.g_varchar2
630: ,p_pcs_attribute5 in varchar2 default hr_api.g_varchar2
631: ,p_pcs_attribute6 in varchar2 default hr_api.g_varchar2

Line 628: ,p_pcs_attribute3 in varchar2 default hr_api.g_varchar2

624: ,p_business_group_id in number default hr_api.g_number
625: ,p_pcs_attribute_category in varchar2 default hr_api.g_varchar2
626: ,p_pcs_attribute1 in varchar2 default hr_api.g_varchar2
627: ,p_pcs_attribute2 in varchar2 default hr_api.g_varchar2
628: ,p_pcs_attribute3 in varchar2 default hr_api.g_varchar2
629: ,p_pcs_attribute4 in varchar2 default hr_api.g_varchar2
630: ,p_pcs_attribute5 in varchar2 default hr_api.g_varchar2
631: ,p_pcs_attribute6 in varchar2 default hr_api.g_varchar2
632: ,p_pcs_attribute7 in varchar2 default hr_api.g_varchar2

Line 629: ,p_pcs_attribute4 in varchar2 default hr_api.g_varchar2

625: ,p_pcs_attribute_category in varchar2 default hr_api.g_varchar2
626: ,p_pcs_attribute1 in varchar2 default hr_api.g_varchar2
627: ,p_pcs_attribute2 in varchar2 default hr_api.g_varchar2
628: ,p_pcs_attribute3 in varchar2 default hr_api.g_varchar2
629: ,p_pcs_attribute4 in varchar2 default hr_api.g_varchar2
630: ,p_pcs_attribute5 in varchar2 default hr_api.g_varchar2
631: ,p_pcs_attribute6 in varchar2 default hr_api.g_varchar2
632: ,p_pcs_attribute7 in varchar2 default hr_api.g_varchar2
633: ,p_pcs_attribute8 in varchar2 default hr_api.g_varchar2

Line 630: ,p_pcs_attribute5 in varchar2 default hr_api.g_varchar2

626: ,p_pcs_attribute1 in varchar2 default hr_api.g_varchar2
627: ,p_pcs_attribute2 in varchar2 default hr_api.g_varchar2
628: ,p_pcs_attribute3 in varchar2 default hr_api.g_varchar2
629: ,p_pcs_attribute4 in varchar2 default hr_api.g_varchar2
630: ,p_pcs_attribute5 in varchar2 default hr_api.g_varchar2
631: ,p_pcs_attribute6 in varchar2 default hr_api.g_varchar2
632: ,p_pcs_attribute7 in varchar2 default hr_api.g_varchar2
633: ,p_pcs_attribute8 in varchar2 default hr_api.g_varchar2
634: ,p_pcs_attribute9 in varchar2 default hr_api.g_varchar2

Line 631: ,p_pcs_attribute6 in varchar2 default hr_api.g_varchar2

627: ,p_pcs_attribute2 in varchar2 default hr_api.g_varchar2
628: ,p_pcs_attribute3 in varchar2 default hr_api.g_varchar2
629: ,p_pcs_attribute4 in varchar2 default hr_api.g_varchar2
630: ,p_pcs_attribute5 in varchar2 default hr_api.g_varchar2
631: ,p_pcs_attribute6 in varchar2 default hr_api.g_varchar2
632: ,p_pcs_attribute7 in varchar2 default hr_api.g_varchar2
633: ,p_pcs_attribute8 in varchar2 default hr_api.g_varchar2
634: ,p_pcs_attribute9 in varchar2 default hr_api.g_varchar2
635: ,p_pcs_attribute10 in varchar2 default hr_api.g_varchar2

Line 632: ,p_pcs_attribute7 in varchar2 default hr_api.g_varchar2

628: ,p_pcs_attribute3 in varchar2 default hr_api.g_varchar2
629: ,p_pcs_attribute4 in varchar2 default hr_api.g_varchar2
630: ,p_pcs_attribute5 in varchar2 default hr_api.g_varchar2
631: ,p_pcs_attribute6 in varchar2 default hr_api.g_varchar2
632: ,p_pcs_attribute7 in varchar2 default hr_api.g_varchar2
633: ,p_pcs_attribute8 in varchar2 default hr_api.g_varchar2
634: ,p_pcs_attribute9 in varchar2 default hr_api.g_varchar2
635: ,p_pcs_attribute10 in varchar2 default hr_api.g_varchar2
636: ,p_pcs_attribute11 in varchar2 default hr_api.g_varchar2

Line 633: ,p_pcs_attribute8 in varchar2 default hr_api.g_varchar2

629: ,p_pcs_attribute4 in varchar2 default hr_api.g_varchar2
630: ,p_pcs_attribute5 in varchar2 default hr_api.g_varchar2
631: ,p_pcs_attribute6 in varchar2 default hr_api.g_varchar2
632: ,p_pcs_attribute7 in varchar2 default hr_api.g_varchar2
633: ,p_pcs_attribute8 in varchar2 default hr_api.g_varchar2
634: ,p_pcs_attribute9 in varchar2 default hr_api.g_varchar2
635: ,p_pcs_attribute10 in varchar2 default hr_api.g_varchar2
636: ,p_pcs_attribute11 in varchar2 default hr_api.g_varchar2
637: ,p_pcs_attribute12 in varchar2 default hr_api.g_varchar2

Line 634: ,p_pcs_attribute9 in varchar2 default hr_api.g_varchar2

630: ,p_pcs_attribute5 in varchar2 default hr_api.g_varchar2
631: ,p_pcs_attribute6 in varchar2 default hr_api.g_varchar2
632: ,p_pcs_attribute7 in varchar2 default hr_api.g_varchar2
633: ,p_pcs_attribute8 in varchar2 default hr_api.g_varchar2
634: ,p_pcs_attribute9 in varchar2 default hr_api.g_varchar2
635: ,p_pcs_attribute10 in varchar2 default hr_api.g_varchar2
636: ,p_pcs_attribute11 in varchar2 default hr_api.g_varchar2
637: ,p_pcs_attribute12 in varchar2 default hr_api.g_varchar2
638: ,p_pcs_attribute13 in varchar2 default hr_api.g_varchar2

Line 635: ,p_pcs_attribute10 in varchar2 default hr_api.g_varchar2

631: ,p_pcs_attribute6 in varchar2 default hr_api.g_varchar2
632: ,p_pcs_attribute7 in varchar2 default hr_api.g_varchar2
633: ,p_pcs_attribute8 in varchar2 default hr_api.g_varchar2
634: ,p_pcs_attribute9 in varchar2 default hr_api.g_varchar2
635: ,p_pcs_attribute10 in varchar2 default hr_api.g_varchar2
636: ,p_pcs_attribute11 in varchar2 default hr_api.g_varchar2
637: ,p_pcs_attribute12 in varchar2 default hr_api.g_varchar2
638: ,p_pcs_attribute13 in varchar2 default hr_api.g_varchar2
639: ,p_pcs_attribute14 in varchar2 default hr_api.g_varchar2

Line 636: ,p_pcs_attribute11 in varchar2 default hr_api.g_varchar2

632: ,p_pcs_attribute7 in varchar2 default hr_api.g_varchar2
633: ,p_pcs_attribute8 in varchar2 default hr_api.g_varchar2
634: ,p_pcs_attribute9 in varchar2 default hr_api.g_varchar2
635: ,p_pcs_attribute10 in varchar2 default hr_api.g_varchar2
636: ,p_pcs_attribute11 in varchar2 default hr_api.g_varchar2
637: ,p_pcs_attribute12 in varchar2 default hr_api.g_varchar2
638: ,p_pcs_attribute13 in varchar2 default hr_api.g_varchar2
639: ,p_pcs_attribute14 in varchar2 default hr_api.g_varchar2
640: ,p_pcs_attribute15 in varchar2 default hr_api.g_varchar2

Line 637: ,p_pcs_attribute12 in varchar2 default hr_api.g_varchar2

633: ,p_pcs_attribute8 in varchar2 default hr_api.g_varchar2
634: ,p_pcs_attribute9 in varchar2 default hr_api.g_varchar2
635: ,p_pcs_attribute10 in varchar2 default hr_api.g_varchar2
636: ,p_pcs_attribute11 in varchar2 default hr_api.g_varchar2
637: ,p_pcs_attribute12 in varchar2 default hr_api.g_varchar2
638: ,p_pcs_attribute13 in varchar2 default hr_api.g_varchar2
639: ,p_pcs_attribute14 in varchar2 default hr_api.g_varchar2
640: ,p_pcs_attribute15 in varchar2 default hr_api.g_varchar2
641: ,p_pcs_attribute16 in varchar2 default hr_api.g_varchar2

Line 638: ,p_pcs_attribute13 in varchar2 default hr_api.g_varchar2

634: ,p_pcs_attribute9 in varchar2 default hr_api.g_varchar2
635: ,p_pcs_attribute10 in varchar2 default hr_api.g_varchar2
636: ,p_pcs_attribute11 in varchar2 default hr_api.g_varchar2
637: ,p_pcs_attribute12 in varchar2 default hr_api.g_varchar2
638: ,p_pcs_attribute13 in varchar2 default hr_api.g_varchar2
639: ,p_pcs_attribute14 in varchar2 default hr_api.g_varchar2
640: ,p_pcs_attribute15 in varchar2 default hr_api.g_varchar2
641: ,p_pcs_attribute16 in varchar2 default hr_api.g_varchar2
642: ,p_pcs_attribute17 in varchar2 default hr_api.g_varchar2

Line 639: ,p_pcs_attribute14 in varchar2 default hr_api.g_varchar2

635: ,p_pcs_attribute10 in varchar2 default hr_api.g_varchar2
636: ,p_pcs_attribute11 in varchar2 default hr_api.g_varchar2
637: ,p_pcs_attribute12 in varchar2 default hr_api.g_varchar2
638: ,p_pcs_attribute13 in varchar2 default hr_api.g_varchar2
639: ,p_pcs_attribute14 in varchar2 default hr_api.g_varchar2
640: ,p_pcs_attribute15 in varchar2 default hr_api.g_varchar2
641: ,p_pcs_attribute16 in varchar2 default hr_api.g_varchar2
642: ,p_pcs_attribute17 in varchar2 default hr_api.g_varchar2
643: ,p_pcs_attribute18 in varchar2 default hr_api.g_varchar2

Line 640: ,p_pcs_attribute15 in varchar2 default hr_api.g_varchar2

636: ,p_pcs_attribute11 in varchar2 default hr_api.g_varchar2
637: ,p_pcs_attribute12 in varchar2 default hr_api.g_varchar2
638: ,p_pcs_attribute13 in varchar2 default hr_api.g_varchar2
639: ,p_pcs_attribute14 in varchar2 default hr_api.g_varchar2
640: ,p_pcs_attribute15 in varchar2 default hr_api.g_varchar2
641: ,p_pcs_attribute16 in varchar2 default hr_api.g_varchar2
642: ,p_pcs_attribute17 in varchar2 default hr_api.g_varchar2
643: ,p_pcs_attribute18 in varchar2 default hr_api.g_varchar2
644: ,p_pcs_attribute19 in varchar2 default hr_api.g_varchar2

Line 641: ,p_pcs_attribute16 in varchar2 default hr_api.g_varchar2

637: ,p_pcs_attribute12 in varchar2 default hr_api.g_varchar2
638: ,p_pcs_attribute13 in varchar2 default hr_api.g_varchar2
639: ,p_pcs_attribute14 in varchar2 default hr_api.g_varchar2
640: ,p_pcs_attribute15 in varchar2 default hr_api.g_varchar2
641: ,p_pcs_attribute16 in varchar2 default hr_api.g_varchar2
642: ,p_pcs_attribute17 in varchar2 default hr_api.g_varchar2
643: ,p_pcs_attribute18 in varchar2 default hr_api.g_varchar2
644: ,p_pcs_attribute19 in varchar2 default hr_api.g_varchar2
645: ,p_pcs_attribute20 in varchar2 default hr_api.g_varchar2

Line 642: ,p_pcs_attribute17 in varchar2 default hr_api.g_varchar2

638: ,p_pcs_attribute13 in varchar2 default hr_api.g_varchar2
639: ,p_pcs_attribute14 in varchar2 default hr_api.g_varchar2
640: ,p_pcs_attribute15 in varchar2 default hr_api.g_varchar2
641: ,p_pcs_attribute16 in varchar2 default hr_api.g_varchar2
642: ,p_pcs_attribute17 in varchar2 default hr_api.g_varchar2
643: ,p_pcs_attribute18 in varchar2 default hr_api.g_varchar2
644: ,p_pcs_attribute19 in varchar2 default hr_api.g_varchar2
645: ,p_pcs_attribute20 in varchar2 default hr_api.g_varchar2
646: ,p_pcs_attribute21 in varchar2 default hr_api.g_varchar2

Line 643: ,p_pcs_attribute18 in varchar2 default hr_api.g_varchar2

639: ,p_pcs_attribute14 in varchar2 default hr_api.g_varchar2
640: ,p_pcs_attribute15 in varchar2 default hr_api.g_varchar2
641: ,p_pcs_attribute16 in varchar2 default hr_api.g_varchar2
642: ,p_pcs_attribute17 in varchar2 default hr_api.g_varchar2
643: ,p_pcs_attribute18 in varchar2 default hr_api.g_varchar2
644: ,p_pcs_attribute19 in varchar2 default hr_api.g_varchar2
645: ,p_pcs_attribute20 in varchar2 default hr_api.g_varchar2
646: ,p_pcs_attribute21 in varchar2 default hr_api.g_varchar2
647: ,p_pcs_attribute22 in varchar2 default hr_api.g_varchar2

Line 644: ,p_pcs_attribute19 in varchar2 default hr_api.g_varchar2

640: ,p_pcs_attribute15 in varchar2 default hr_api.g_varchar2
641: ,p_pcs_attribute16 in varchar2 default hr_api.g_varchar2
642: ,p_pcs_attribute17 in varchar2 default hr_api.g_varchar2
643: ,p_pcs_attribute18 in varchar2 default hr_api.g_varchar2
644: ,p_pcs_attribute19 in varchar2 default hr_api.g_varchar2
645: ,p_pcs_attribute20 in varchar2 default hr_api.g_varchar2
646: ,p_pcs_attribute21 in varchar2 default hr_api.g_varchar2
647: ,p_pcs_attribute22 in varchar2 default hr_api.g_varchar2
648: ,p_pcs_attribute23 in varchar2 default hr_api.g_varchar2

Line 645: ,p_pcs_attribute20 in varchar2 default hr_api.g_varchar2

641: ,p_pcs_attribute16 in varchar2 default hr_api.g_varchar2
642: ,p_pcs_attribute17 in varchar2 default hr_api.g_varchar2
643: ,p_pcs_attribute18 in varchar2 default hr_api.g_varchar2
644: ,p_pcs_attribute19 in varchar2 default hr_api.g_varchar2
645: ,p_pcs_attribute20 in varchar2 default hr_api.g_varchar2
646: ,p_pcs_attribute21 in varchar2 default hr_api.g_varchar2
647: ,p_pcs_attribute22 in varchar2 default hr_api.g_varchar2
648: ,p_pcs_attribute23 in varchar2 default hr_api.g_varchar2
649: ,p_pcs_attribute24 in varchar2 default hr_api.g_varchar2

Line 646: ,p_pcs_attribute21 in varchar2 default hr_api.g_varchar2

642: ,p_pcs_attribute17 in varchar2 default hr_api.g_varchar2
643: ,p_pcs_attribute18 in varchar2 default hr_api.g_varchar2
644: ,p_pcs_attribute19 in varchar2 default hr_api.g_varchar2
645: ,p_pcs_attribute20 in varchar2 default hr_api.g_varchar2
646: ,p_pcs_attribute21 in varchar2 default hr_api.g_varchar2
647: ,p_pcs_attribute22 in varchar2 default hr_api.g_varchar2
648: ,p_pcs_attribute23 in varchar2 default hr_api.g_varchar2
649: ,p_pcs_attribute24 in varchar2 default hr_api.g_varchar2
650: ,p_pcs_attribute25 in varchar2 default hr_api.g_varchar2

Line 647: ,p_pcs_attribute22 in varchar2 default hr_api.g_varchar2

643: ,p_pcs_attribute18 in varchar2 default hr_api.g_varchar2
644: ,p_pcs_attribute19 in varchar2 default hr_api.g_varchar2
645: ,p_pcs_attribute20 in varchar2 default hr_api.g_varchar2
646: ,p_pcs_attribute21 in varchar2 default hr_api.g_varchar2
647: ,p_pcs_attribute22 in varchar2 default hr_api.g_varchar2
648: ,p_pcs_attribute23 in varchar2 default hr_api.g_varchar2
649: ,p_pcs_attribute24 in varchar2 default hr_api.g_varchar2
650: ,p_pcs_attribute25 in varchar2 default hr_api.g_varchar2
651: ,p_pcs_attribute26 in varchar2 default hr_api.g_varchar2

Line 648: ,p_pcs_attribute23 in varchar2 default hr_api.g_varchar2

644: ,p_pcs_attribute19 in varchar2 default hr_api.g_varchar2
645: ,p_pcs_attribute20 in varchar2 default hr_api.g_varchar2
646: ,p_pcs_attribute21 in varchar2 default hr_api.g_varchar2
647: ,p_pcs_attribute22 in varchar2 default hr_api.g_varchar2
648: ,p_pcs_attribute23 in varchar2 default hr_api.g_varchar2
649: ,p_pcs_attribute24 in varchar2 default hr_api.g_varchar2
650: ,p_pcs_attribute25 in varchar2 default hr_api.g_varchar2
651: ,p_pcs_attribute26 in varchar2 default hr_api.g_varchar2
652: ,p_pcs_attribute27 in varchar2 default hr_api.g_varchar2

Line 649: ,p_pcs_attribute24 in varchar2 default hr_api.g_varchar2

645: ,p_pcs_attribute20 in varchar2 default hr_api.g_varchar2
646: ,p_pcs_attribute21 in varchar2 default hr_api.g_varchar2
647: ,p_pcs_attribute22 in varchar2 default hr_api.g_varchar2
648: ,p_pcs_attribute23 in varchar2 default hr_api.g_varchar2
649: ,p_pcs_attribute24 in varchar2 default hr_api.g_varchar2
650: ,p_pcs_attribute25 in varchar2 default hr_api.g_varchar2
651: ,p_pcs_attribute26 in varchar2 default hr_api.g_varchar2
652: ,p_pcs_attribute27 in varchar2 default hr_api.g_varchar2
653: ,p_pcs_attribute28 in varchar2 default hr_api.g_varchar2

Line 650: ,p_pcs_attribute25 in varchar2 default hr_api.g_varchar2

646: ,p_pcs_attribute21 in varchar2 default hr_api.g_varchar2
647: ,p_pcs_attribute22 in varchar2 default hr_api.g_varchar2
648: ,p_pcs_attribute23 in varchar2 default hr_api.g_varchar2
649: ,p_pcs_attribute24 in varchar2 default hr_api.g_varchar2
650: ,p_pcs_attribute25 in varchar2 default hr_api.g_varchar2
651: ,p_pcs_attribute26 in varchar2 default hr_api.g_varchar2
652: ,p_pcs_attribute27 in varchar2 default hr_api.g_varchar2
653: ,p_pcs_attribute28 in varchar2 default hr_api.g_varchar2
654: ,p_pcs_attribute29 in varchar2 default hr_api.g_varchar2

Line 651: ,p_pcs_attribute26 in varchar2 default hr_api.g_varchar2

647: ,p_pcs_attribute22 in varchar2 default hr_api.g_varchar2
648: ,p_pcs_attribute23 in varchar2 default hr_api.g_varchar2
649: ,p_pcs_attribute24 in varchar2 default hr_api.g_varchar2
650: ,p_pcs_attribute25 in varchar2 default hr_api.g_varchar2
651: ,p_pcs_attribute26 in varchar2 default hr_api.g_varchar2
652: ,p_pcs_attribute27 in varchar2 default hr_api.g_varchar2
653: ,p_pcs_attribute28 in varchar2 default hr_api.g_varchar2
654: ,p_pcs_attribute29 in varchar2 default hr_api.g_varchar2
655: ,p_pcs_attribute30 in varchar2 default hr_api.g_varchar2

Line 652: ,p_pcs_attribute27 in varchar2 default hr_api.g_varchar2

648: ,p_pcs_attribute23 in varchar2 default hr_api.g_varchar2
649: ,p_pcs_attribute24 in varchar2 default hr_api.g_varchar2
650: ,p_pcs_attribute25 in varchar2 default hr_api.g_varchar2
651: ,p_pcs_attribute26 in varchar2 default hr_api.g_varchar2
652: ,p_pcs_attribute27 in varchar2 default hr_api.g_varchar2
653: ,p_pcs_attribute28 in varchar2 default hr_api.g_varchar2
654: ,p_pcs_attribute29 in varchar2 default hr_api.g_varchar2
655: ,p_pcs_attribute30 in varchar2 default hr_api.g_varchar2
656: ,p_object_version_number in out nocopy number

Line 653: ,p_pcs_attribute28 in varchar2 default hr_api.g_varchar2

649: ,p_pcs_attribute24 in varchar2 default hr_api.g_varchar2
650: ,p_pcs_attribute25 in varchar2 default hr_api.g_varchar2
651: ,p_pcs_attribute26 in varchar2 default hr_api.g_varchar2
652: ,p_pcs_attribute27 in varchar2 default hr_api.g_varchar2
653: ,p_pcs_attribute28 in varchar2 default hr_api.g_varchar2
654: ,p_pcs_attribute29 in varchar2 default hr_api.g_varchar2
655: ,p_pcs_attribute30 in varchar2 default hr_api.g_varchar2
656: ,p_object_version_number in out nocopy number
657: ,p_effective_date in date

Line 654: ,p_pcs_attribute29 in varchar2 default hr_api.g_varchar2

650: ,p_pcs_attribute25 in varchar2 default hr_api.g_varchar2
651: ,p_pcs_attribute26 in varchar2 default hr_api.g_varchar2
652: ,p_pcs_attribute27 in varchar2 default hr_api.g_varchar2
653: ,p_pcs_attribute28 in varchar2 default hr_api.g_varchar2
654: ,p_pcs_attribute29 in varchar2 default hr_api.g_varchar2
655: ,p_pcs_attribute30 in varchar2 default hr_api.g_varchar2
656: ,p_object_version_number in out nocopy number
657: ,p_effective_date in date
658: ,p_datetrack_mode in varchar2

Line 655: ,p_pcs_attribute30 in varchar2 default hr_api.g_varchar2

651: ,p_pcs_attribute26 in varchar2 default hr_api.g_varchar2
652: ,p_pcs_attribute27 in varchar2 default hr_api.g_varchar2
653: ,p_pcs_attribute28 in varchar2 default hr_api.g_varchar2
654: ,p_pcs_attribute29 in varchar2 default hr_api.g_varchar2
655: ,p_pcs_attribute30 in varchar2 default hr_api.g_varchar2
656: ,p_object_version_number in out nocopy number
657: ,p_effective_date in date
658: ,p_datetrack_mode in varchar2
659: ) is

Line 758: when hr_api.cannot_find_prog_unit then

754: ,p_effective_date => trunc(p_effective_date)
755: ,p_datetrack_mode => p_datetrack_mode
756: );
757: exception
758: when hr_api.cannot_find_prog_unit then
759: hr_api.cannot_find_prog_unit_error
760: (p_module_name => 'UPDATE_PRTT_ENRT_CTFN_PRVDD'
761: ,p_hook_type => 'BP'
762: );

Line 759: hr_api.cannot_find_prog_unit_error

755: ,p_datetrack_mode => p_datetrack_mode
756: );
757: exception
758: when hr_api.cannot_find_prog_unit then
759: hr_api.cannot_find_prog_unit_error
760: (p_module_name => 'UPDATE_PRTT_ENRT_CTFN_PRVDD'
761: ,p_hook_type => 'BP'
762: );
763: --

Line 870: when hr_api.cannot_find_prog_unit then

866: ,p_effective_date => trunc(p_effective_date)
867: ,p_datetrack_mode => p_datetrack_mode
868: );
869: exception
870: when hr_api.cannot_find_prog_unit then
871: hr_api.cannot_find_prog_unit_error
872: (p_module_name => 'UPDATE_PRTT_ENRT_CTFN_PRVDD'
873: ,p_hook_type => 'AP'
874: );

Line 871: hr_api.cannot_find_prog_unit_error

867: ,p_datetrack_mode => p_datetrack_mode
868: );
869: exception
870: when hr_api.cannot_find_prog_unit then
871: hr_api.cannot_find_prog_unit_error
872: (p_module_name => 'UPDATE_PRTT_ENRT_CTFN_PRVDD'
873: ,p_hook_type => 'AP'
874: );
875: --

Line 902: raise hr_api.validate_enabled;

898: --
899: -- When in validation only mode raise the Validate_Enabled exception
900: --
901: if p_validate then
902: raise hr_api.validate_enabled;
903: end if;
904: --
905: -- Set all output arguments
906: --

Line 916: when hr_api.validate_enabled then

912: hr_utility.set_location(' Leaving:'||l_proc, 70);
913: --
914: exception
915: --
916: when hr_api.validate_enabled then
917: --
918: -- As the Validate_Enabled exception has been raised
919: -- we must rollback to the savepoint
920: --

Line 1066: when hr_api.cannot_find_prog_unit then

1062: ,p_object_version_number => p_object_version_number
1063: ,p_effective_date => trunc(p_effective_date)
1064: ,p_datetrack_mode => p_datetrack_mode );
1065: exception
1066: when hr_api.cannot_find_prog_unit then
1067: hr_api.cannot_find_prog_unit_error
1068: (p_module_name => 'DELETE_PRTT_ENRT_CTFN_PRVDD'
1069: ,p_hook_type => 'BP'
1070: );

Line 1067: hr_api.cannot_find_prog_unit_error

1063: ,p_effective_date => trunc(p_effective_date)
1064: ,p_datetrack_mode => p_datetrack_mode );
1065: exception
1066: when hr_api.cannot_find_prog_unit then
1067: hr_api.cannot_find_prog_unit_error
1068: (p_module_name => 'DELETE_PRTT_ENRT_CTFN_PRVDD'
1069: ,p_hook_type => 'BP'
1070: );
1071: --

Line 1151: when hr_api.cannot_find_prog_unit then

1147: ,p_effective_date => trunc(p_effective_date)
1148: ,p_datetrack_mode => p_datetrack_mode
1149: );
1150: exception
1151: when hr_api.cannot_find_prog_unit then
1152: hr_api.cannot_find_prog_unit_error
1153: (p_module_name => 'DELETE_PRTT_ENRT_CTFN_PRVDD'
1154: ,p_hook_type => 'AP'
1155: );

Line 1152: hr_api.cannot_find_prog_unit_error

1148: ,p_datetrack_mode => p_datetrack_mode
1149: );
1150: exception
1151: when hr_api.cannot_find_prog_unit then
1152: hr_api.cannot_find_prog_unit_error
1153: (p_module_name => 'DELETE_PRTT_ENRT_CTFN_PRVDD'
1154: ,p_hook_type => 'AP'
1155: );
1156: --

Line 1166: raise hr_api.validate_enabled;

1162: --
1163: -- When in validation only mode raise the Validate_Enabled exception
1164: --
1165: if p_validate then
1166: raise hr_api.validate_enabled;
1167: end if;
1168: --
1169: hr_utility.set_location(' Leaving:'||l_proc, 70);
1170: --

Line 1173: when hr_api.validate_enabled then

1169: hr_utility.set_location(' Leaving:'||l_proc, 70);
1170: --
1171: exception
1172: --
1173: when hr_api.validate_enabled then
1174: --
1175: -- As the Validate_Enabled exception has been raised
1176: -- we must rollback to the savepoint
1177: --