264: ,p_program_update_date => p_program_update_date
265: ,p_effective_date => trunc(p_effective_date)
266: );
267: exception
268: when hr_api.cannot_find_prog_unit then
269: hr_api.cannot_find_prog_unit_error
270: (
271: p_module_name => 'CREATE_PL_BNF_CTFN_PRVDD'
272: ,p_hook_type => 'BP'
265: ,p_effective_date => trunc(p_effective_date)
266: );
267: exception
268: when hr_api.cannot_find_prog_unit then
269: hr_api.cannot_find_prog_unit_error
270: (
271: p_module_name => 'CREATE_PL_BNF_CTFN_PRVDD'
272: ,p_hook_type => 'BP'
273: );
379: ,p_object_version_number => l_object_version_number
380: ,p_effective_date => trunc(p_effective_date)
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'CREATE_PL_BNF_CTFN_PRVDD'
386: ,p_hook_type => 'AP'
387: );
380: ,p_effective_date => trunc(p_effective_date)
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'CREATE_PL_BNF_CTFN_PRVDD'
386: ,p_hook_type => 'AP'
387: );
388: --
394: --
395: -- When in validation only mode raise the Validate_Enabled exception
396: --
397: if p_validate then
398: raise hr_api.validate_enabled;
399: end if;
400: --
401: -- Set all output arguments
402: --
408: hr_utility.set_location(' Leaving:'||l_proc, 70);
409: --
410: exception
411: --
412: when hr_api.validate_enabled then
413: --
414: -- As the Validate_Enabled exception has been raised
415: -- we must rollback to the savepoint
416: --
446: (p_validate in boolean default false
447: ,p_pl_bnf_ctfn_prvdd_id in number
448: ,p_effective_start_date out nocopy date
449: ,p_effective_end_date out nocopy date
450: ,p_bnf_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
451: ,p_bnf_ctfn_recd_dt in date default hr_api.g_date
452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
447: ,p_pl_bnf_ctfn_prvdd_id in number
448: ,p_effective_start_date out nocopy date
449: ,p_effective_end_date out nocopy date
450: ,p_bnf_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
451: ,p_bnf_ctfn_recd_dt in date default hr_api.g_date
452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
448: ,p_effective_start_date out nocopy date
449: ,p_effective_end_date out nocopy date
450: ,p_bnf_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
451: ,p_bnf_ctfn_recd_dt in date default hr_api.g_date
452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
449: ,p_effective_end_date out nocopy date
450: ,p_bnf_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
451: ,p_bnf_ctfn_recd_dt in date default hr_api.g_date
452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
450: ,p_bnf_ctfn_typ_cd in varchar2 default hr_api.g_varchar2
451: ,p_bnf_ctfn_recd_dt in date default hr_api.g_date
452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
451: ,p_bnf_ctfn_recd_dt in date default hr_api.g_date
452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
452: ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
453: ,p_pl_bnf_id in number default hr_api.g_number
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
454: ,p_prtt_enrt_actn_id in number default hr_api.g_number
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
455: ,p_business_group_id in number default hr_api.g_number
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
456: ,p_pbc_attribute_category in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
457: ,p_pbc_attribute1 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
458: ,p_pbc_attribute2 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
459: ,p_pbc_attribute3 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
460: ,p_pbc_attribute4 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
461: ,p_pbc_attribute5 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
462: ,p_pbc_attribute6 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
463: ,p_pbc_attribute7 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
464: ,p_pbc_attribute8 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
465: ,p_pbc_attribute9 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
466: ,p_pbc_attribute10 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
467: ,p_pbc_attribute11 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
468: ,p_pbc_attribute12 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
469: ,p_pbc_attribute13 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
470: ,p_pbc_attribute14 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
471: ,p_pbc_attribute15 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
472: ,p_pbc_attribute16 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
473: ,p_pbc_attribute17 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
474: ,p_pbc_attribute18 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
475: ,p_pbc_attribute19 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
476: ,p_pbc_attribute20 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
477: ,p_pbc_attribute21 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
478: ,p_pbc_attribute22 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
479: ,p_pbc_attribute23 in varchar2 default hr_api.g_varchar2
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
480: ,p_pbc_attribute24 in varchar2 default hr_api.g_varchar2
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
488: ,p_program_application_id in number default hr_api.g_number
481: ,p_pbc_attribute25 in varchar2 default hr_api.g_varchar2
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
488: ,p_program_application_id in number default hr_api.g_number
489: ,p_program_id in number default hr_api.g_number
482: ,p_pbc_attribute26 in varchar2 default hr_api.g_varchar2
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
488: ,p_program_application_id in number default hr_api.g_number
489: ,p_program_id in number default hr_api.g_number
490: ,p_program_update_date in date default hr_api.g_date
483: ,p_pbc_attribute27 in varchar2 default hr_api.g_varchar2
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
488: ,p_program_application_id in number default hr_api.g_number
489: ,p_program_id in number default hr_api.g_number
490: ,p_program_update_date in date default hr_api.g_date
491: ,p_object_version_number in out nocopy number
484: ,p_pbc_attribute28 in varchar2 default hr_api.g_varchar2
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
488: ,p_program_application_id in number default hr_api.g_number
489: ,p_program_id in number default hr_api.g_number
490: ,p_program_update_date in date default hr_api.g_date
491: ,p_object_version_number in out nocopy number
492: ,p_effective_date in date
485: ,p_pbc_attribute29 in varchar2 default hr_api.g_varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
488: ,p_program_application_id in number default hr_api.g_number
489: ,p_program_id in number default hr_api.g_number
490: ,p_program_update_date in date default hr_api.g_date
491: ,p_object_version_number in out nocopy number
492: ,p_effective_date in date
493: ,p_datetrack_mode in varchar2
486: ,p_pbc_attribute30 in varchar2 default hr_api.g_varchar2
487: ,p_request_id in number default hr_api.g_number
488: ,p_program_application_id in number default hr_api.g_number
489: ,p_program_id in number default hr_api.g_number
490: ,p_program_update_date in date default hr_api.g_date
491: ,p_object_version_number in out nocopy number
492: ,p_effective_date in date
493: ,p_datetrack_mode in varchar2
494: ) is
581: ,p_effective_date => trunc(p_effective_date)
582: ,p_datetrack_mode => p_datetrack_mode
583: );
584: exception
585: when hr_api.cannot_find_prog_unit then
586: hr_api.cannot_find_prog_unit_error
587: (p_module_name => 'UPDATE_PL_BNF_CTFN_PRVDD'
588: ,p_hook_type => 'BP'
589: );
582: ,p_datetrack_mode => p_datetrack_mode
583: );
584: exception
585: when hr_api.cannot_find_prog_unit then
586: hr_api.cannot_find_prog_unit_error
587: (p_module_name => 'UPDATE_PL_BNF_CTFN_PRVDD'
588: ,p_hook_type => 'BP'
589: );
590: --
706: ,p_effective_date => trunc(p_effective_date)
707: ,p_datetrack_mode => p_datetrack_mode
708: );
709: exception
710: when hr_api.cannot_find_prog_unit then
711: hr_api.cannot_find_prog_unit_error
712: (p_module_name => 'UPDATE_PL_BNF_CTFN_PRVDD'
713: ,p_hook_type => 'AP'
714: );
707: ,p_datetrack_mode => p_datetrack_mode
708: );
709: exception
710: when hr_api.cannot_find_prog_unit then
711: hr_api.cannot_find_prog_unit_error
712: (p_module_name => 'UPDATE_PL_BNF_CTFN_PRVDD'
713: ,p_hook_type => 'AP'
714: );
715: --
721: --
722: -- When in validation only mode raise the Validate_Enabled exception
723: --
724: if p_validate then
725: raise hr_api.validate_enabled;
726: end if;
727: --
728: -- Set all output arguments
729: --
734: hr_utility.set_location(' Leaving:'||l_proc, 70);
735: --
736: exception
737: --
738: when hr_api.validate_enabled then
739: --
740: -- As the Validate_Enabled exception has been raised
741: -- we must rollback to the savepoint
742: --
864: ,p_effective_date => trunc(p_effective_date)
865: ,p_datetrack_mode => p_datetrack_mode
866: );
867: exception
868: when hr_api.cannot_find_prog_unit then
869: hr_api.cannot_find_prog_unit_error
870: (p_module_name => 'DELETE_PL_BNF_CTFN_PRVDD'
871: ,p_hook_type => 'BP'
872: );
865: ,p_datetrack_mode => p_datetrack_mode
866: );
867: exception
868: when hr_api.cannot_find_prog_unit then
869: hr_api.cannot_find_prog_unit_error
870: (p_module_name => 'DELETE_PL_BNF_CTFN_PRVDD'
871: ,p_hook_type => 'BP'
872: );
873: --
953: ,p_effective_date => trunc(p_effective_date)
954: ,p_datetrack_mode => p_datetrack_mode
955: );
956: exception
957: when hr_api.cannot_find_prog_unit then
958: hr_api.cannot_find_prog_unit_error
959: (p_module_name => 'DELETE_PL_BNF_CTFN_PRVDD'
960: ,p_hook_type => 'AP'
961: );
954: ,p_datetrack_mode => p_datetrack_mode
955: );
956: exception
957: when hr_api.cannot_find_prog_unit then
958: hr_api.cannot_find_prog_unit_error
959: (p_module_name => 'DELETE_PL_BNF_CTFN_PRVDD'
960: ,p_hook_type => 'AP'
961: );
962: --
968: --
969: -- When in validation only mode raise the Validate_Enabled exception
970: --
971: if p_validate then
972: raise hr_api.validate_enabled;
973: end if;
974: --
975: hr_utility.set_location(' Leaving:'||l_proc, 70);
976: --
975: hr_utility.set_location(' Leaving:'||l_proc, 70);
976: --
977: exception
978: --
979: when hr_api.validate_enabled then
980: --
981: -- As the Validate_Enabled exception has been raised
982: -- we must rollback to the savepoint
983: --