252: ,p_program_update_date => p_program_update_date
253: ,p_effective_date => trunc(p_effective_date)
254: );
255: exception
256: when hr_api.cannot_find_prog_unit then
257: hr_api.cannot_find_prog_unit_error
258: (
259: p_module_name => 'CREATE_CVRD_DPNT_CTFN_PRVDD'
260: ,p_hook_type => 'BP'
253: ,p_effective_date => trunc(p_effective_date)
254: );
255: exception
256: when hr_api.cannot_find_prog_unit then
257: hr_api.cannot_find_prog_unit_error
258: (
259: p_module_name => 'CREATE_CVRD_DPNT_CTFN_PRVDD'
260: ,p_hook_type => 'BP'
261: );
367: ,p_object_version_number => l_object_version_number
368: ,p_effective_date => trunc(p_effective_date)
369: );
370: exception
371: when hr_api.cannot_find_prog_unit then
372: hr_api.cannot_find_prog_unit_error
373: (p_module_name => 'CREATE_CVRD_DPNT_CTFN_PRVDD'
374: ,p_hook_type => 'AP'
375: );
368: ,p_effective_date => trunc(p_effective_date)
369: );
370: exception
371: when hr_api.cannot_find_prog_unit then
372: hr_api.cannot_find_prog_unit_error
373: (p_module_name => 'CREATE_CVRD_DPNT_CTFN_PRVDD'
374: ,p_hook_type => 'AP'
375: );
376: --
382: --
383: -- When in validation only mode raise the Validate_Enabled exception
384: --
385: if p_validate then
386: raise hr_api.validate_enabled;
387: end if;
388: --
389: -- Set all output arguments
390: --
396: hr_utility.set_location(' Leaving:'||l_proc, 70);
397: --
398: exception
399: --
400: when hr_api.validate_enabled then
401: --
402: -- As the Validate_Enabled exception has been raised
403: -- we must rollback to the savepoint
404: --
430: (p_validate in boolean default false
431: ,p_cvrd_dpnt_ctfn_prvdd_id in number
432: ,p_effective_start_date out nocopy date
433: ,p_effective_end_date out nocopy date
434: ,p_dpnt_dsgn_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
435: ,p_dpnt_dsgn_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
436: ,p_dpnt_dsgn_ctfn_recd_dt in date default hr_api.g_date
437: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
438: ,p_prtt_enrt_actn_id in number default hr_api.g_number
431: ,p_cvrd_dpnt_ctfn_prvdd_id in number
432: ,p_effective_start_date out nocopy date
433: ,p_effective_end_date out nocopy date
434: ,p_dpnt_dsgn_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
435: ,p_dpnt_dsgn_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
436: ,p_dpnt_dsgn_ctfn_recd_dt in date default hr_api.g_date
437: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
438: ,p_prtt_enrt_actn_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
432: ,p_effective_start_date out nocopy date
433: ,p_effective_end_date out nocopy date
434: ,p_dpnt_dsgn_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
435: ,p_dpnt_dsgn_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
436: ,p_dpnt_dsgn_ctfn_recd_dt in date default hr_api.g_date
437: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
438: ,p_prtt_enrt_actn_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_ccp_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_effective_end_date out nocopy date
434: ,p_dpnt_dsgn_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
435: ,p_dpnt_dsgn_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
436: ,p_dpnt_dsgn_ctfn_recd_dt in date default hr_api.g_date
437: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
438: ,p_prtt_enrt_actn_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_ccp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_ccp_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_dpnt_dsgn_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
435: ,p_dpnt_dsgn_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
436: ,p_dpnt_dsgn_ctfn_recd_dt in date default hr_api.g_date
437: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
438: ,p_prtt_enrt_actn_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_ccp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_ccp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_ccp_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_dpnt_dsgn_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
436: ,p_dpnt_dsgn_ctfn_recd_dt in date default hr_api.g_date
437: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
438: ,p_prtt_enrt_actn_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_ccp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_ccp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_ccp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_ccp_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_dpnt_dsgn_ctfn_recd_dt in date default hr_api.g_date
437: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
438: ,p_prtt_enrt_actn_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_ccp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_ccp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_ccp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_ccp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_ccp_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
438: ,p_prtt_enrt_actn_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_ccp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_ccp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_ccp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_ccp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_ccp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_ccp_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_prtt_enrt_actn_id in number default hr_api.g_number
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_ccp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_ccp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_ccp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_ccp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_ccp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_ccp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_ccp_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_business_group_id in number default hr_api.g_number
440: ,p_ccp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_ccp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_ccp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_ccp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_ccp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_ccp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_ccp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_ccp_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_ccp_attribute_category in varchar2 default hr_api.g_varchar2
441: ,p_ccp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_ccp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_ccp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_ccp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_ccp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_ccp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_ccp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_ccp_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_ccp_attribute1 in varchar2 default hr_api.g_varchar2
442: ,p_ccp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_ccp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_ccp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_ccp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_ccp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_ccp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_ccp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_ccp_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_ccp_attribute2 in varchar2 default hr_api.g_varchar2
443: ,p_ccp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_ccp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_ccp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_ccp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_ccp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_ccp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_ccp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_ccp_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_ccp_attribute3 in varchar2 default hr_api.g_varchar2
444: ,p_ccp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_ccp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_ccp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_ccp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_ccp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_ccp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_ccp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_ccp_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_ccp_attribute4 in varchar2 default hr_api.g_varchar2
445: ,p_ccp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_ccp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_ccp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_ccp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_ccp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_ccp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_ccp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_ccp_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_ccp_attribute5 in varchar2 default hr_api.g_varchar2
446: ,p_ccp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_ccp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_ccp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_ccp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_ccp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_ccp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_ccp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_ccp_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_ccp_attribute6 in varchar2 default hr_api.g_varchar2
447: ,p_ccp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_ccp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_ccp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_ccp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_ccp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_ccp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_ccp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_ccp_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_ccp_attribute7 in varchar2 default hr_api.g_varchar2
448: ,p_ccp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_ccp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_ccp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_ccp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_ccp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_ccp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_ccp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_ccp_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_ccp_attribute8 in varchar2 default hr_api.g_varchar2
449: ,p_ccp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_ccp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_ccp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_ccp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_ccp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_ccp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_ccp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_ccp_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_ccp_attribute9 in varchar2 default hr_api.g_varchar2
450: ,p_ccp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_ccp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_ccp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_ccp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_ccp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_ccp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_ccp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_ccp_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_ccp_attribute10 in varchar2 default hr_api.g_varchar2
451: ,p_ccp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_ccp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_ccp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_ccp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_ccp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_ccp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_ccp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_ccp_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_ccp_attribute11 in varchar2 default hr_api.g_varchar2
452: ,p_ccp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_ccp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_ccp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_ccp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_ccp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_ccp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_ccp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_ccp_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_ccp_attribute12 in varchar2 default hr_api.g_varchar2
453: ,p_ccp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_ccp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_ccp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_ccp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_ccp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_ccp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_ccp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_ccp_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_ccp_attribute13 in varchar2 default hr_api.g_varchar2
454: ,p_ccp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_ccp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_ccp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_ccp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_ccp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_ccp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_ccp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_ccp_attribute21 in varchar2 default hr_api.g_varchar2
454: ,p_ccp_attribute14 in varchar2 default hr_api.g_varchar2
455: ,p_ccp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_ccp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_ccp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_ccp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_ccp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_ccp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_ccp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_ccp_attribute22 in varchar2 default hr_api.g_varchar2
455: ,p_ccp_attribute15 in varchar2 default hr_api.g_varchar2
456: ,p_ccp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_ccp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_ccp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_ccp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_ccp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_ccp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_ccp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_ccp_attribute23 in varchar2 default hr_api.g_varchar2
456: ,p_ccp_attribute16 in varchar2 default hr_api.g_varchar2
457: ,p_ccp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_ccp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_ccp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_ccp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_ccp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_ccp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_ccp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_ccp_attribute24 in varchar2 default hr_api.g_varchar2
457: ,p_ccp_attribute17 in varchar2 default hr_api.g_varchar2
458: ,p_ccp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_ccp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_ccp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_ccp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_ccp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_ccp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_ccp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_ccp_attribute25 in varchar2 default hr_api.g_varchar2
458: ,p_ccp_attribute18 in varchar2 default hr_api.g_varchar2
459: ,p_ccp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_ccp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_ccp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_ccp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_ccp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_ccp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_ccp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_ccp_attribute26 in varchar2 default hr_api.g_varchar2
459: ,p_ccp_attribute19 in varchar2 default hr_api.g_varchar2
460: ,p_ccp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_ccp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_ccp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_ccp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_ccp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_ccp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_ccp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_ccp_attribute27 in varchar2 default hr_api.g_varchar2
460: ,p_ccp_attribute20 in varchar2 default hr_api.g_varchar2
461: ,p_ccp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_ccp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_ccp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_ccp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_ccp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_ccp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_ccp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_ccp_attribute28 in varchar2 default hr_api.g_varchar2
461: ,p_ccp_attribute21 in varchar2 default hr_api.g_varchar2
462: ,p_ccp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_ccp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_ccp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_ccp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_ccp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_ccp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_ccp_attribute28 in varchar2 default hr_api.g_varchar2
469: ,p_ccp_attribute29 in varchar2 default hr_api.g_varchar2
462: ,p_ccp_attribute22 in varchar2 default hr_api.g_varchar2
463: ,p_ccp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_ccp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_ccp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_ccp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_ccp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_ccp_attribute28 in varchar2 default hr_api.g_varchar2
469: ,p_ccp_attribute29 in varchar2 default hr_api.g_varchar2
470: ,p_ccp_attribute30 in varchar2 default hr_api.g_varchar2
463: ,p_ccp_attribute23 in varchar2 default hr_api.g_varchar2
464: ,p_ccp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_ccp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_ccp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_ccp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_ccp_attribute28 in varchar2 default hr_api.g_varchar2
469: ,p_ccp_attribute29 in varchar2 default hr_api.g_varchar2
470: ,p_ccp_attribute30 in varchar2 default hr_api.g_varchar2
471: ,p_request_id in number default hr_api.g_number
464: ,p_ccp_attribute24 in varchar2 default hr_api.g_varchar2
465: ,p_ccp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_ccp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_ccp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_ccp_attribute28 in varchar2 default hr_api.g_varchar2
469: ,p_ccp_attribute29 in varchar2 default hr_api.g_varchar2
470: ,p_ccp_attribute30 in varchar2 default hr_api.g_varchar2
471: ,p_request_id in number default hr_api.g_number
472: ,p_program_application_id in number default hr_api.g_number
465: ,p_ccp_attribute25 in varchar2 default hr_api.g_varchar2
466: ,p_ccp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_ccp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_ccp_attribute28 in varchar2 default hr_api.g_varchar2
469: ,p_ccp_attribute29 in varchar2 default hr_api.g_varchar2
470: ,p_ccp_attribute30 in varchar2 default hr_api.g_varchar2
471: ,p_request_id in number default hr_api.g_number
472: ,p_program_application_id in number default hr_api.g_number
473: ,p_program_id in number default hr_api.g_number
466: ,p_ccp_attribute26 in varchar2 default hr_api.g_varchar2
467: ,p_ccp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_ccp_attribute28 in varchar2 default hr_api.g_varchar2
469: ,p_ccp_attribute29 in varchar2 default hr_api.g_varchar2
470: ,p_ccp_attribute30 in varchar2 default hr_api.g_varchar2
471: ,p_request_id in number default hr_api.g_number
472: ,p_program_application_id in number default hr_api.g_number
473: ,p_program_id in number default hr_api.g_number
474: ,p_program_update_date in date default hr_api.g_date
467: ,p_ccp_attribute27 in varchar2 default hr_api.g_varchar2
468: ,p_ccp_attribute28 in varchar2 default hr_api.g_varchar2
469: ,p_ccp_attribute29 in varchar2 default hr_api.g_varchar2
470: ,p_ccp_attribute30 in varchar2 default hr_api.g_varchar2
471: ,p_request_id in number default hr_api.g_number
472: ,p_program_application_id in number default hr_api.g_number
473: ,p_program_id in number default hr_api.g_number
474: ,p_program_update_date in date default hr_api.g_date
475: ,p_object_version_number in out nocopy number
468: ,p_ccp_attribute28 in varchar2 default hr_api.g_varchar2
469: ,p_ccp_attribute29 in varchar2 default hr_api.g_varchar2
470: ,p_ccp_attribute30 in varchar2 default hr_api.g_varchar2
471: ,p_request_id in number default hr_api.g_number
472: ,p_program_application_id in number default hr_api.g_number
473: ,p_program_id in number default hr_api.g_number
474: ,p_program_update_date in date default hr_api.g_date
475: ,p_object_version_number in out nocopy number
476: ,p_effective_date in date
469: ,p_ccp_attribute29 in varchar2 default hr_api.g_varchar2
470: ,p_ccp_attribute30 in varchar2 default hr_api.g_varchar2
471: ,p_request_id in number default hr_api.g_number
472: ,p_program_application_id in number default hr_api.g_number
473: ,p_program_id in number default hr_api.g_number
474: ,p_program_update_date in date default hr_api.g_date
475: ,p_object_version_number in out nocopy number
476: ,p_effective_date in date
477: ,p_datetrack_mode in varchar2
470: ,p_ccp_attribute30 in varchar2 default hr_api.g_varchar2
471: ,p_request_id in number default hr_api.g_number
472: ,p_program_application_id in number default hr_api.g_number
473: ,p_program_id in number default hr_api.g_number
474: ,p_program_update_date in date default hr_api.g_date
475: ,p_object_version_number in out nocopy number
476: ,p_effective_date in date
477: ,p_datetrack_mode in varchar2
478: ) is
565: ,p_effective_date => trunc(p_effective_date)
566: ,p_datetrack_mode => p_datetrack_mode
567: );
568: exception
569: when hr_api.cannot_find_prog_unit then
570: hr_api.cannot_find_prog_unit_error
571: (p_module_name => 'UPDATE_CVRD_DPNT_CTFN_PRVDD'
572: ,p_hook_type => 'BP'
573: );
566: ,p_datetrack_mode => p_datetrack_mode
567: );
568: exception
569: when hr_api.cannot_find_prog_unit then
570: hr_api.cannot_find_prog_unit_error
571: (p_module_name => 'UPDATE_CVRD_DPNT_CTFN_PRVDD'
572: ,p_hook_type => 'BP'
573: );
574: --
689: ,p_effective_date => trunc(p_effective_date)
690: ,p_datetrack_mode => p_datetrack_mode
691: );
692: exception
693: when hr_api.cannot_find_prog_unit then
694: hr_api.cannot_find_prog_unit_error
695: (p_module_name => 'UPDATE_CVRD_DPNT_CTFN_PRVDD'
696: ,p_hook_type => 'AP'
697: );
690: ,p_datetrack_mode => p_datetrack_mode
691: );
692: exception
693: when hr_api.cannot_find_prog_unit then
694: hr_api.cannot_find_prog_unit_error
695: (p_module_name => 'UPDATE_CVRD_DPNT_CTFN_PRVDD'
696: ,p_hook_type => 'AP'
697: );
698: --
704: --
705: -- When in validation only mode raise the Validate_Enabled exception
706: --
707: if p_validate then
708: raise hr_api.validate_enabled;
709: end if;
710: --
711: -- Set all output arguments
712: --
717: hr_utility.set_location(' Leaving:'||l_proc, 70);
718: --
719: exception
720: --
721: when hr_api.validate_enabled then
722: --
723: -- As the Validate_Enabled exception has been raised
724: -- we must rollback to the savepoint
725: --
844: ,p_object_version_number => p_object_version_number
845: ,p_effective_date => trunc(p_effective_date)
846: ,p_datetrack_mode => p_datetrack_mode );
847: exception
848: when hr_api.cannot_find_prog_unit then
849: hr_api.cannot_find_prog_unit_error
850: (p_module_name => 'DELETE_CVRD_DPNT_CTFN_PRVDD'
851: ,p_hook_type => 'BP'
852: );
845: ,p_effective_date => trunc(p_effective_date)
846: ,p_datetrack_mode => p_datetrack_mode );
847: exception
848: when hr_api.cannot_find_prog_unit then
849: hr_api.cannot_find_prog_unit_error
850: (p_module_name => 'DELETE_CVRD_DPNT_CTFN_PRVDD'
851: ,p_hook_type => 'BP'
852: );
853: --
934: ,p_effective_date => trunc(p_effective_date)
935: ,p_datetrack_mode => p_datetrack_mode
936: );
937: exception
938: when hr_api.cannot_find_prog_unit then
939: hr_api.cannot_find_prog_unit_error
940: (p_module_name => 'DELETE_CVRD_DPNT_CTFN_PRVDD'
941: ,p_hook_type => 'AP'
942: );
935: ,p_datetrack_mode => p_datetrack_mode
936: );
937: exception
938: when hr_api.cannot_find_prog_unit then
939: hr_api.cannot_find_prog_unit_error
940: (p_module_name => 'DELETE_CVRD_DPNT_CTFN_PRVDD'
941: ,p_hook_type => 'AP'
942: );
943: --
949: --
950: -- When in validation only mode raise the Validate_Enabled exception
951: --
952: if p_validate then
953: raise hr_api.validate_enabled;
954: end if;
955: --
956: hr_utility.set_location(' Leaving:'||l_proc, 70);
957: --
956: hr_utility.set_location(' Leaving:'||l_proc, 70);
957: --
958: exception
959: --
960: when hr_api.validate_enabled then
961: --
962: -- As the Validate_Enabled exception has been raised
963: -- we must rollback to the savepoint
964: --
1089: ,p_object_version_number => p_object_version_number
1090: ,p_effective_date => trunc(p_effective_date)
1091: ,p_datetrack_mode => p_datetrack_mode );
1092: exception
1093: when hr_api.cannot_find_prog_unit then
1094: hr_api.cannot_find_prog_unit_error
1095: (p_module_name => 'DELETE_CVRD_DPNT_CTFN_PRVDD'
1096: ,p_hook_type => 'BP'
1097: );
1090: ,p_effective_date => trunc(p_effective_date)
1091: ,p_datetrack_mode => p_datetrack_mode );
1092: exception
1093: when hr_api.cannot_find_prog_unit then
1094: hr_api.cannot_find_prog_unit_error
1095: (p_module_name => 'DELETE_CVRD_DPNT_CTFN_PRVDD'
1096: ,p_hook_type => 'BP'
1097: );
1098: --
1183: ,p_effective_date => trunc(p_effective_date)
1184: ,p_datetrack_mode => p_datetrack_mode
1185: );
1186: exception
1187: when hr_api.cannot_find_prog_unit then
1188: hr_api.cannot_find_prog_unit_error
1189: (p_module_name => 'DELETE_CVRD_DPNT_CTFN_PRVDD'
1190: ,p_hook_type => 'AP'
1191: );
1184: ,p_datetrack_mode => p_datetrack_mode
1185: );
1186: exception
1187: when hr_api.cannot_find_prog_unit then
1188: hr_api.cannot_find_prog_unit_error
1189: (p_module_name => 'DELETE_CVRD_DPNT_CTFN_PRVDD'
1190: ,p_hook_type => 'AP'
1191: );
1192: --
1198: --
1199: -- When in validation only mode raise the Validate_Enabled exception
1200: --
1201: if p_validate then
1202: raise hr_api.validate_enabled;
1203: end if;
1204: --
1205: hr_utility.set_location(' Leaving:'||l_proc, 70);
1206: --
1205: hr_utility.set_location(' Leaving:'||l_proc, 70);
1206: --
1207: exception
1208: --
1209: when hr_api.validate_enabled then
1210: --
1211: -- As the Validate_Enabled exception has been raised
1212: -- we must rollback to the savepoint
1213: --