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