157: ,p_object_version_number => l_object_version_number
158: ,p_effective_date => trunc(p_effective_date)
159: );
160: exception
161: when hr_api.cannot_find_prog_unit then
162: hr_api.cannot_find_prog_unit_error
163: (
164: p_module_name => 'CREATE_enrt_bnft'
165: ,p_hook_type => 'BP'
158: ,p_effective_date => trunc(p_effective_date)
159: );
160: exception
161: when hr_api.cannot_find_prog_unit then
162: hr_api.cannot_find_prog_unit_error
163: (
164: p_module_name => 'CREATE_enrt_bnft'
165: ,p_hook_type => 'BP'
166: );
300: ,p_object_version_number => l_object_version_number
301: ,p_effective_date => trunc(p_effective_date)
302: );
303: exception
304: when hr_api.cannot_find_prog_unit then
305: hr_api.cannot_find_prog_unit_error
306: (p_module_name => 'CREATE_enrt_bnft'
307: ,p_hook_type => 'AP'
308: );
301: ,p_effective_date => trunc(p_effective_date)
302: );
303: exception
304: when hr_api.cannot_find_prog_unit then
305: hr_api.cannot_find_prog_unit_error
306: (p_module_name => 'CREATE_enrt_bnft'
307: ,p_hook_type => 'AP'
308: );
309: --
315: --
316: -- When in validation only mode raise the Validate_Enabled exception
317: --
318: if p_validate then
319: raise hr_api.validate_enabled;
320: end if;
321: --
322: -- Set all output arguments
323: --
327: hr_utility.set_location(' Leaving:'||l_proc, 70);
328: --
329: exception
330: --
331: when hr_api.validate_enabled then
332: --
333: -- As the Validate_Enabled exception has been raised
334: -- we must rollback to the savepoint
335: --
361: procedure update_enrt_bnft
362: (
363: p_validate in boolean default false
364: ,p_enrt_bnft_id in number
365: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
366: ,p_val_has_bn_prortd_flag in varchar2 default hr_api.g_varchar2
367: ,p_bndry_perd_cd in varchar2 default hr_api.g_varchar2
368: ,p_val in number default hr_api.g_number
369: ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
362: (
363: p_validate in boolean default false
364: ,p_enrt_bnft_id in number
365: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
366: ,p_val_has_bn_prortd_flag in varchar2 default hr_api.g_varchar2
367: ,p_bndry_perd_cd in varchar2 default hr_api.g_varchar2
368: ,p_val in number default hr_api.g_number
369: ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
370: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
363: p_validate in boolean default false
364: ,p_enrt_bnft_id in number
365: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
366: ,p_val_has_bn_prortd_flag in varchar2 default hr_api.g_varchar2
367: ,p_bndry_perd_cd in varchar2 default hr_api.g_varchar2
368: ,p_val in number default hr_api.g_number
369: ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
370: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
371: ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
364: ,p_enrt_bnft_id in number
365: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
366: ,p_val_has_bn_prortd_flag in varchar2 default hr_api.g_varchar2
367: ,p_bndry_perd_cd in varchar2 default hr_api.g_varchar2
368: ,p_val in number default hr_api.g_number
369: ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
370: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
371: ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
372: ,p_mn_val in number default hr_api.g_number
365: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
366: ,p_val_has_bn_prortd_flag in varchar2 default hr_api.g_varchar2
367: ,p_bndry_perd_cd in varchar2 default hr_api.g_varchar2
368: ,p_val in number default hr_api.g_number
369: ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
370: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
371: ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
372: ,p_mn_val in number default hr_api.g_number
373: ,p_mx_val in number default hr_api.g_number
366: ,p_val_has_bn_prortd_flag in varchar2 default hr_api.g_varchar2
367: ,p_bndry_perd_cd in varchar2 default hr_api.g_varchar2
368: ,p_val in number default hr_api.g_number
369: ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
370: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
371: ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
372: ,p_mn_val in number default hr_api.g_number
373: ,p_mx_val in number default hr_api.g_number
374: ,p_incrmt_val in number default hr_api.g_number
367: ,p_bndry_perd_cd in varchar2 default hr_api.g_varchar2
368: ,p_val in number default hr_api.g_number
369: ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
370: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
371: ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
372: ,p_mn_val in number default hr_api.g_number
373: ,p_mx_val in number default hr_api.g_number
374: ,p_incrmt_val in number default hr_api.g_number
375: ,p_dflt_val in number default hr_api.g_number
368: ,p_val in number default hr_api.g_number
369: ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
370: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
371: ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
372: ,p_mn_val in number default hr_api.g_number
373: ,p_mx_val in number default hr_api.g_number
374: ,p_incrmt_val in number default hr_api.g_number
375: ,p_dflt_val in number default hr_api.g_number
376: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
369: ,p_nnmntry_uom in varchar2 default hr_api.g_varchar2
370: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
371: ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
372: ,p_mn_val in number default hr_api.g_number
373: ,p_mx_val in number default hr_api.g_number
374: ,p_incrmt_val in number default hr_api.g_number
375: ,p_dflt_val in number default hr_api.g_number
376: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
377: ,p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2
370: ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
371: ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
372: ,p_mn_val in number default hr_api.g_number
373: ,p_mx_val in number default hr_api.g_number
374: ,p_incrmt_val in number default hr_api.g_number
375: ,p_dflt_val in number default hr_api.g_number
376: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
377: ,p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2
378: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
371: ,p_entr_val_at_enrt_flag in varchar2 default hr_api.g_varchar2
372: ,p_mn_val in number default hr_api.g_number
373: ,p_mx_val in number default hr_api.g_number
374: ,p_incrmt_val in number default hr_api.g_number
375: ,p_dflt_val in number default hr_api.g_number
376: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
377: ,p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2
378: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
379: ,p_ordr_num in number default hr_api.g_number
372: ,p_mn_val in number default hr_api.g_number
373: ,p_mx_val in number default hr_api.g_number
374: ,p_incrmt_val in number default hr_api.g_number
375: ,p_dflt_val in number default hr_api.g_number
376: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
377: ,p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2
378: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
379: ,p_ordr_num in number default hr_api.g_number
380: ,p_crntly_enrld_flag in varchar2 default hr_api.g_varchar2
373: ,p_mx_val in number default hr_api.g_number
374: ,p_incrmt_val in number default hr_api.g_number
375: ,p_dflt_val in number default hr_api.g_number
376: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
377: ,p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2
378: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
379: ,p_ordr_num in number default hr_api.g_number
380: ,p_crntly_enrld_flag in varchar2 default hr_api.g_varchar2
381: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
374: ,p_incrmt_val in number default hr_api.g_number
375: ,p_dflt_val in number default hr_api.g_number
376: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
377: ,p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2
378: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
379: ,p_ordr_num in number default hr_api.g_number
380: ,p_crntly_enrld_flag in varchar2 default hr_api.g_varchar2
381: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
382: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
375: ,p_dflt_val in number default hr_api.g_number
376: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
377: ,p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2
378: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
379: ,p_ordr_num in number default hr_api.g_number
380: ,p_crntly_enrld_flag in varchar2 default hr_api.g_varchar2
381: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
382: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
383: ,p_comp_lvl_fctr_id in number default hr_api.g_number
376: ,p_rt_typ_cd in varchar2 default hr_api.g_varchar2
377: ,p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2
378: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
379: ,p_ordr_num in number default hr_api.g_number
380: ,p_crntly_enrld_flag in varchar2 default hr_api.g_varchar2
381: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
382: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
383: ,p_comp_lvl_fctr_id in number default hr_api.g_number
384: ,p_business_group_id in number default hr_api.g_number
377: ,p_cvg_mlt_cd in varchar2 default hr_api.g_varchar2
378: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
379: ,p_ordr_num in number default hr_api.g_number
380: ,p_crntly_enrld_flag in varchar2 default hr_api.g_varchar2
381: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
382: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
383: ,p_comp_lvl_fctr_id in number default hr_api.g_number
384: ,p_business_group_id in number default hr_api.g_number
385: ,p_enb_attribute_category in varchar2 default hr_api.g_varchar2
378: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
379: ,p_ordr_num in number default hr_api.g_number
380: ,p_crntly_enrld_flag in varchar2 default hr_api.g_varchar2
381: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
382: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
383: ,p_comp_lvl_fctr_id in number default hr_api.g_number
384: ,p_business_group_id in number default hr_api.g_number
385: ,p_enb_attribute_category in varchar2 default hr_api.g_varchar2
386: ,p_enb_attribute1 in varchar2 default hr_api.g_varchar2
379: ,p_ordr_num in number default hr_api.g_number
380: ,p_crntly_enrld_flag in varchar2 default hr_api.g_varchar2
381: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
382: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
383: ,p_comp_lvl_fctr_id in number default hr_api.g_number
384: ,p_business_group_id in number default hr_api.g_number
385: ,p_enb_attribute_category in varchar2 default hr_api.g_varchar2
386: ,p_enb_attribute1 in varchar2 default hr_api.g_varchar2
387: ,p_enb_attribute2 in varchar2 default hr_api.g_varchar2
380: ,p_crntly_enrld_flag in varchar2 default hr_api.g_varchar2
381: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
382: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
383: ,p_comp_lvl_fctr_id in number default hr_api.g_number
384: ,p_business_group_id in number default hr_api.g_number
385: ,p_enb_attribute_category in varchar2 default hr_api.g_varchar2
386: ,p_enb_attribute1 in varchar2 default hr_api.g_varchar2
387: ,p_enb_attribute2 in varchar2 default hr_api.g_varchar2
388: ,p_enb_attribute3 in varchar2 default hr_api.g_varchar2
381: ,p_elig_per_elctbl_chc_id in number default hr_api.g_number
382: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
383: ,p_comp_lvl_fctr_id in number default hr_api.g_number
384: ,p_business_group_id in number default hr_api.g_number
385: ,p_enb_attribute_category in varchar2 default hr_api.g_varchar2
386: ,p_enb_attribute1 in varchar2 default hr_api.g_varchar2
387: ,p_enb_attribute2 in varchar2 default hr_api.g_varchar2
388: ,p_enb_attribute3 in varchar2 default hr_api.g_varchar2
389: ,p_enb_attribute4 in varchar2 default hr_api.g_varchar2
382: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
383: ,p_comp_lvl_fctr_id in number default hr_api.g_number
384: ,p_business_group_id in number default hr_api.g_number
385: ,p_enb_attribute_category in varchar2 default hr_api.g_varchar2
386: ,p_enb_attribute1 in varchar2 default hr_api.g_varchar2
387: ,p_enb_attribute2 in varchar2 default hr_api.g_varchar2
388: ,p_enb_attribute3 in varchar2 default hr_api.g_varchar2
389: ,p_enb_attribute4 in varchar2 default hr_api.g_varchar2
390: ,p_enb_attribute5 in varchar2 default hr_api.g_varchar2
383: ,p_comp_lvl_fctr_id in number default hr_api.g_number
384: ,p_business_group_id in number default hr_api.g_number
385: ,p_enb_attribute_category in varchar2 default hr_api.g_varchar2
386: ,p_enb_attribute1 in varchar2 default hr_api.g_varchar2
387: ,p_enb_attribute2 in varchar2 default hr_api.g_varchar2
388: ,p_enb_attribute3 in varchar2 default hr_api.g_varchar2
389: ,p_enb_attribute4 in varchar2 default hr_api.g_varchar2
390: ,p_enb_attribute5 in varchar2 default hr_api.g_varchar2
391: ,p_enb_attribute6 in varchar2 default hr_api.g_varchar2
384: ,p_business_group_id in number default hr_api.g_number
385: ,p_enb_attribute_category in varchar2 default hr_api.g_varchar2
386: ,p_enb_attribute1 in varchar2 default hr_api.g_varchar2
387: ,p_enb_attribute2 in varchar2 default hr_api.g_varchar2
388: ,p_enb_attribute3 in varchar2 default hr_api.g_varchar2
389: ,p_enb_attribute4 in varchar2 default hr_api.g_varchar2
390: ,p_enb_attribute5 in varchar2 default hr_api.g_varchar2
391: ,p_enb_attribute6 in varchar2 default hr_api.g_varchar2
392: ,p_enb_attribute7 in varchar2 default hr_api.g_varchar2
385: ,p_enb_attribute_category in varchar2 default hr_api.g_varchar2
386: ,p_enb_attribute1 in varchar2 default hr_api.g_varchar2
387: ,p_enb_attribute2 in varchar2 default hr_api.g_varchar2
388: ,p_enb_attribute3 in varchar2 default hr_api.g_varchar2
389: ,p_enb_attribute4 in varchar2 default hr_api.g_varchar2
390: ,p_enb_attribute5 in varchar2 default hr_api.g_varchar2
391: ,p_enb_attribute6 in varchar2 default hr_api.g_varchar2
392: ,p_enb_attribute7 in varchar2 default hr_api.g_varchar2
393: ,p_enb_attribute8 in varchar2 default hr_api.g_varchar2
386: ,p_enb_attribute1 in varchar2 default hr_api.g_varchar2
387: ,p_enb_attribute2 in varchar2 default hr_api.g_varchar2
388: ,p_enb_attribute3 in varchar2 default hr_api.g_varchar2
389: ,p_enb_attribute4 in varchar2 default hr_api.g_varchar2
390: ,p_enb_attribute5 in varchar2 default hr_api.g_varchar2
391: ,p_enb_attribute6 in varchar2 default hr_api.g_varchar2
392: ,p_enb_attribute7 in varchar2 default hr_api.g_varchar2
393: ,p_enb_attribute8 in varchar2 default hr_api.g_varchar2
394: ,p_enb_attribute9 in varchar2 default hr_api.g_varchar2
387: ,p_enb_attribute2 in varchar2 default hr_api.g_varchar2
388: ,p_enb_attribute3 in varchar2 default hr_api.g_varchar2
389: ,p_enb_attribute4 in varchar2 default hr_api.g_varchar2
390: ,p_enb_attribute5 in varchar2 default hr_api.g_varchar2
391: ,p_enb_attribute6 in varchar2 default hr_api.g_varchar2
392: ,p_enb_attribute7 in varchar2 default hr_api.g_varchar2
393: ,p_enb_attribute8 in varchar2 default hr_api.g_varchar2
394: ,p_enb_attribute9 in varchar2 default hr_api.g_varchar2
395: ,p_enb_attribute10 in varchar2 default hr_api.g_varchar2
388: ,p_enb_attribute3 in varchar2 default hr_api.g_varchar2
389: ,p_enb_attribute4 in varchar2 default hr_api.g_varchar2
390: ,p_enb_attribute5 in varchar2 default hr_api.g_varchar2
391: ,p_enb_attribute6 in varchar2 default hr_api.g_varchar2
392: ,p_enb_attribute7 in varchar2 default hr_api.g_varchar2
393: ,p_enb_attribute8 in varchar2 default hr_api.g_varchar2
394: ,p_enb_attribute9 in varchar2 default hr_api.g_varchar2
395: ,p_enb_attribute10 in varchar2 default hr_api.g_varchar2
396: ,p_enb_attribute11 in varchar2 default hr_api.g_varchar2
389: ,p_enb_attribute4 in varchar2 default hr_api.g_varchar2
390: ,p_enb_attribute5 in varchar2 default hr_api.g_varchar2
391: ,p_enb_attribute6 in varchar2 default hr_api.g_varchar2
392: ,p_enb_attribute7 in varchar2 default hr_api.g_varchar2
393: ,p_enb_attribute8 in varchar2 default hr_api.g_varchar2
394: ,p_enb_attribute9 in varchar2 default hr_api.g_varchar2
395: ,p_enb_attribute10 in varchar2 default hr_api.g_varchar2
396: ,p_enb_attribute11 in varchar2 default hr_api.g_varchar2
397: ,p_enb_attribute12 in varchar2 default hr_api.g_varchar2
390: ,p_enb_attribute5 in varchar2 default hr_api.g_varchar2
391: ,p_enb_attribute6 in varchar2 default hr_api.g_varchar2
392: ,p_enb_attribute7 in varchar2 default hr_api.g_varchar2
393: ,p_enb_attribute8 in varchar2 default hr_api.g_varchar2
394: ,p_enb_attribute9 in varchar2 default hr_api.g_varchar2
395: ,p_enb_attribute10 in varchar2 default hr_api.g_varchar2
396: ,p_enb_attribute11 in varchar2 default hr_api.g_varchar2
397: ,p_enb_attribute12 in varchar2 default hr_api.g_varchar2
398: ,p_enb_attribute13 in varchar2 default hr_api.g_varchar2
391: ,p_enb_attribute6 in varchar2 default hr_api.g_varchar2
392: ,p_enb_attribute7 in varchar2 default hr_api.g_varchar2
393: ,p_enb_attribute8 in varchar2 default hr_api.g_varchar2
394: ,p_enb_attribute9 in varchar2 default hr_api.g_varchar2
395: ,p_enb_attribute10 in varchar2 default hr_api.g_varchar2
396: ,p_enb_attribute11 in varchar2 default hr_api.g_varchar2
397: ,p_enb_attribute12 in varchar2 default hr_api.g_varchar2
398: ,p_enb_attribute13 in varchar2 default hr_api.g_varchar2
399: ,p_enb_attribute14 in varchar2 default hr_api.g_varchar2
392: ,p_enb_attribute7 in varchar2 default hr_api.g_varchar2
393: ,p_enb_attribute8 in varchar2 default hr_api.g_varchar2
394: ,p_enb_attribute9 in varchar2 default hr_api.g_varchar2
395: ,p_enb_attribute10 in varchar2 default hr_api.g_varchar2
396: ,p_enb_attribute11 in varchar2 default hr_api.g_varchar2
397: ,p_enb_attribute12 in varchar2 default hr_api.g_varchar2
398: ,p_enb_attribute13 in varchar2 default hr_api.g_varchar2
399: ,p_enb_attribute14 in varchar2 default hr_api.g_varchar2
400: ,p_enb_attribute15 in varchar2 default hr_api.g_varchar2
393: ,p_enb_attribute8 in varchar2 default hr_api.g_varchar2
394: ,p_enb_attribute9 in varchar2 default hr_api.g_varchar2
395: ,p_enb_attribute10 in varchar2 default hr_api.g_varchar2
396: ,p_enb_attribute11 in varchar2 default hr_api.g_varchar2
397: ,p_enb_attribute12 in varchar2 default hr_api.g_varchar2
398: ,p_enb_attribute13 in varchar2 default hr_api.g_varchar2
399: ,p_enb_attribute14 in varchar2 default hr_api.g_varchar2
400: ,p_enb_attribute15 in varchar2 default hr_api.g_varchar2
401: ,p_enb_attribute16 in varchar2 default hr_api.g_varchar2
394: ,p_enb_attribute9 in varchar2 default hr_api.g_varchar2
395: ,p_enb_attribute10 in varchar2 default hr_api.g_varchar2
396: ,p_enb_attribute11 in varchar2 default hr_api.g_varchar2
397: ,p_enb_attribute12 in varchar2 default hr_api.g_varchar2
398: ,p_enb_attribute13 in varchar2 default hr_api.g_varchar2
399: ,p_enb_attribute14 in varchar2 default hr_api.g_varchar2
400: ,p_enb_attribute15 in varchar2 default hr_api.g_varchar2
401: ,p_enb_attribute16 in varchar2 default hr_api.g_varchar2
402: ,p_enb_attribute17 in varchar2 default hr_api.g_varchar2
395: ,p_enb_attribute10 in varchar2 default hr_api.g_varchar2
396: ,p_enb_attribute11 in varchar2 default hr_api.g_varchar2
397: ,p_enb_attribute12 in varchar2 default hr_api.g_varchar2
398: ,p_enb_attribute13 in varchar2 default hr_api.g_varchar2
399: ,p_enb_attribute14 in varchar2 default hr_api.g_varchar2
400: ,p_enb_attribute15 in varchar2 default hr_api.g_varchar2
401: ,p_enb_attribute16 in varchar2 default hr_api.g_varchar2
402: ,p_enb_attribute17 in varchar2 default hr_api.g_varchar2
403: ,p_enb_attribute18 in varchar2 default hr_api.g_varchar2
396: ,p_enb_attribute11 in varchar2 default hr_api.g_varchar2
397: ,p_enb_attribute12 in varchar2 default hr_api.g_varchar2
398: ,p_enb_attribute13 in varchar2 default hr_api.g_varchar2
399: ,p_enb_attribute14 in varchar2 default hr_api.g_varchar2
400: ,p_enb_attribute15 in varchar2 default hr_api.g_varchar2
401: ,p_enb_attribute16 in varchar2 default hr_api.g_varchar2
402: ,p_enb_attribute17 in varchar2 default hr_api.g_varchar2
403: ,p_enb_attribute18 in varchar2 default hr_api.g_varchar2
404: ,p_enb_attribute19 in varchar2 default hr_api.g_varchar2
397: ,p_enb_attribute12 in varchar2 default hr_api.g_varchar2
398: ,p_enb_attribute13 in varchar2 default hr_api.g_varchar2
399: ,p_enb_attribute14 in varchar2 default hr_api.g_varchar2
400: ,p_enb_attribute15 in varchar2 default hr_api.g_varchar2
401: ,p_enb_attribute16 in varchar2 default hr_api.g_varchar2
402: ,p_enb_attribute17 in varchar2 default hr_api.g_varchar2
403: ,p_enb_attribute18 in varchar2 default hr_api.g_varchar2
404: ,p_enb_attribute19 in varchar2 default hr_api.g_varchar2
405: ,p_enb_attribute20 in varchar2 default hr_api.g_varchar2
398: ,p_enb_attribute13 in varchar2 default hr_api.g_varchar2
399: ,p_enb_attribute14 in varchar2 default hr_api.g_varchar2
400: ,p_enb_attribute15 in varchar2 default hr_api.g_varchar2
401: ,p_enb_attribute16 in varchar2 default hr_api.g_varchar2
402: ,p_enb_attribute17 in varchar2 default hr_api.g_varchar2
403: ,p_enb_attribute18 in varchar2 default hr_api.g_varchar2
404: ,p_enb_attribute19 in varchar2 default hr_api.g_varchar2
405: ,p_enb_attribute20 in varchar2 default hr_api.g_varchar2
406: ,p_enb_attribute21 in varchar2 default hr_api.g_varchar2
399: ,p_enb_attribute14 in varchar2 default hr_api.g_varchar2
400: ,p_enb_attribute15 in varchar2 default hr_api.g_varchar2
401: ,p_enb_attribute16 in varchar2 default hr_api.g_varchar2
402: ,p_enb_attribute17 in varchar2 default hr_api.g_varchar2
403: ,p_enb_attribute18 in varchar2 default hr_api.g_varchar2
404: ,p_enb_attribute19 in varchar2 default hr_api.g_varchar2
405: ,p_enb_attribute20 in varchar2 default hr_api.g_varchar2
406: ,p_enb_attribute21 in varchar2 default hr_api.g_varchar2
407: ,p_enb_attribute22 in varchar2 default hr_api.g_varchar2
400: ,p_enb_attribute15 in varchar2 default hr_api.g_varchar2
401: ,p_enb_attribute16 in varchar2 default hr_api.g_varchar2
402: ,p_enb_attribute17 in varchar2 default hr_api.g_varchar2
403: ,p_enb_attribute18 in varchar2 default hr_api.g_varchar2
404: ,p_enb_attribute19 in varchar2 default hr_api.g_varchar2
405: ,p_enb_attribute20 in varchar2 default hr_api.g_varchar2
406: ,p_enb_attribute21 in varchar2 default hr_api.g_varchar2
407: ,p_enb_attribute22 in varchar2 default hr_api.g_varchar2
408: ,p_enb_attribute23 in varchar2 default hr_api.g_varchar2
401: ,p_enb_attribute16 in varchar2 default hr_api.g_varchar2
402: ,p_enb_attribute17 in varchar2 default hr_api.g_varchar2
403: ,p_enb_attribute18 in varchar2 default hr_api.g_varchar2
404: ,p_enb_attribute19 in varchar2 default hr_api.g_varchar2
405: ,p_enb_attribute20 in varchar2 default hr_api.g_varchar2
406: ,p_enb_attribute21 in varchar2 default hr_api.g_varchar2
407: ,p_enb_attribute22 in varchar2 default hr_api.g_varchar2
408: ,p_enb_attribute23 in varchar2 default hr_api.g_varchar2
409: ,p_enb_attribute24 in varchar2 default hr_api.g_varchar2
402: ,p_enb_attribute17 in varchar2 default hr_api.g_varchar2
403: ,p_enb_attribute18 in varchar2 default hr_api.g_varchar2
404: ,p_enb_attribute19 in varchar2 default hr_api.g_varchar2
405: ,p_enb_attribute20 in varchar2 default hr_api.g_varchar2
406: ,p_enb_attribute21 in varchar2 default hr_api.g_varchar2
407: ,p_enb_attribute22 in varchar2 default hr_api.g_varchar2
408: ,p_enb_attribute23 in varchar2 default hr_api.g_varchar2
409: ,p_enb_attribute24 in varchar2 default hr_api.g_varchar2
410: ,p_enb_attribute25 in varchar2 default hr_api.g_varchar2
403: ,p_enb_attribute18 in varchar2 default hr_api.g_varchar2
404: ,p_enb_attribute19 in varchar2 default hr_api.g_varchar2
405: ,p_enb_attribute20 in varchar2 default hr_api.g_varchar2
406: ,p_enb_attribute21 in varchar2 default hr_api.g_varchar2
407: ,p_enb_attribute22 in varchar2 default hr_api.g_varchar2
408: ,p_enb_attribute23 in varchar2 default hr_api.g_varchar2
409: ,p_enb_attribute24 in varchar2 default hr_api.g_varchar2
410: ,p_enb_attribute25 in varchar2 default hr_api.g_varchar2
411: ,p_enb_attribute26 in varchar2 default hr_api.g_varchar2
404: ,p_enb_attribute19 in varchar2 default hr_api.g_varchar2
405: ,p_enb_attribute20 in varchar2 default hr_api.g_varchar2
406: ,p_enb_attribute21 in varchar2 default hr_api.g_varchar2
407: ,p_enb_attribute22 in varchar2 default hr_api.g_varchar2
408: ,p_enb_attribute23 in varchar2 default hr_api.g_varchar2
409: ,p_enb_attribute24 in varchar2 default hr_api.g_varchar2
410: ,p_enb_attribute25 in varchar2 default hr_api.g_varchar2
411: ,p_enb_attribute26 in varchar2 default hr_api.g_varchar2
412: ,p_enb_attribute27 in varchar2 default hr_api.g_varchar2
405: ,p_enb_attribute20 in varchar2 default hr_api.g_varchar2
406: ,p_enb_attribute21 in varchar2 default hr_api.g_varchar2
407: ,p_enb_attribute22 in varchar2 default hr_api.g_varchar2
408: ,p_enb_attribute23 in varchar2 default hr_api.g_varchar2
409: ,p_enb_attribute24 in varchar2 default hr_api.g_varchar2
410: ,p_enb_attribute25 in varchar2 default hr_api.g_varchar2
411: ,p_enb_attribute26 in varchar2 default hr_api.g_varchar2
412: ,p_enb_attribute27 in varchar2 default hr_api.g_varchar2
413: ,p_enb_attribute28 in varchar2 default hr_api.g_varchar2
406: ,p_enb_attribute21 in varchar2 default hr_api.g_varchar2
407: ,p_enb_attribute22 in varchar2 default hr_api.g_varchar2
408: ,p_enb_attribute23 in varchar2 default hr_api.g_varchar2
409: ,p_enb_attribute24 in varchar2 default hr_api.g_varchar2
410: ,p_enb_attribute25 in varchar2 default hr_api.g_varchar2
411: ,p_enb_attribute26 in varchar2 default hr_api.g_varchar2
412: ,p_enb_attribute27 in varchar2 default hr_api.g_varchar2
413: ,p_enb_attribute28 in varchar2 default hr_api.g_varchar2
414: ,p_enb_attribute29 in varchar2 default hr_api.g_varchar2
407: ,p_enb_attribute22 in varchar2 default hr_api.g_varchar2
408: ,p_enb_attribute23 in varchar2 default hr_api.g_varchar2
409: ,p_enb_attribute24 in varchar2 default hr_api.g_varchar2
410: ,p_enb_attribute25 in varchar2 default hr_api.g_varchar2
411: ,p_enb_attribute26 in varchar2 default hr_api.g_varchar2
412: ,p_enb_attribute27 in varchar2 default hr_api.g_varchar2
413: ,p_enb_attribute28 in varchar2 default hr_api.g_varchar2
414: ,p_enb_attribute29 in varchar2 default hr_api.g_varchar2
415: ,p_enb_attribute30 in varchar2 default hr_api.g_varchar2
408: ,p_enb_attribute23 in varchar2 default hr_api.g_varchar2
409: ,p_enb_attribute24 in varchar2 default hr_api.g_varchar2
410: ,p_enb_attribute25 in varchar2 default hr_api.g_varchar2
411: ,p_enb_attribute26 in varchar2 default hr_api.g_varchar2
412: ,p_enb_attribute27 in varchar2 default hr_api.g_varchar2
413: ,p_enb_attribute28 in varchar2 default hr_api.g_varchar2
414: ,p_enb_attribute29 in varchar2 default hr_api.g_varchar2
415: ,p_enb_attribute30 in varchar2 default hr_api.g_varchar2
416: ,p_request_id in number default hr_api.g_number
409: ,p_enb_attribute24 in varchar2 default hr_api.g_varchar2
410: ,p_enb_attribute25 in varchar2 default hr_api.g_varchar2
411: ,p_enb_attribute26 in varchar2 default hr_api.g_varchar2
412: ,p_enb_attribute27 in varchar2 default hr_api.g_varchar2
413: ,p_enb_attribute28 in varchar2 default hr_api.g_varchar2
414: ,p_enb_attribute29 in varchar2 default hr_api.g_varchar2
415: ,p_enb_attribute30 in varchar2 default hr_api.g_varchar2
416: ,p_request_id in number default hr_api.g_number
417: ,p_program_application_id in number default hr_api.g_number
410: ,p_enb_attribute25 in varchar2 default hr_api.g_varchar2
411: ,p_enb_attribute26 in varchar2 default hr_api.g_varchar2
412: ,p_enb_attribute27 in varchar2 default hr_api.g_varchar2
413: ,p_enb_attribute28 in varchar2 default hr_api.g_varchar2
414: ,p_enb_attribute29 in varchar2 default hr_api.g_varchar2
415: ,p_enb_attribute30 in varchar2 default hr_api.g_varchar2
416: ,p_request_id in number default hr_api.g_number
417: ,p_program_application_id in number default hr_api.g_number
418: ,p_program_id in number default hr_api.g_number
411: ,p_enb_attribute26 in varchar2 default hr_api.g_varchar2
412: ,p_enb_attribute27 in varchar2 default hr_api.g_varchar2
413: ,p_enb_attribute28 in varchar2 default hr_api.g_varchar2
414: ,p_enb_attribute29 in varchar2 default hr_api.g_varchar2
415: ,p_enb_attribute30 in varchar2 default hr_api.g_varchar2
416: ,p_request_id in number default hr_api.g_number
417: ,p_program_application_id in number default hr_api.g_number
418: ,p_program_id in number default hr_api.g_number
419: ,p_program_update_date in date default hr_api.g_date
412: ,p_enb_attribute27 in varchar2 default hr_api.g_varchar2
413: ,p_enb_attribute28 in varchar2 default hr_api.g_varchar2
414: ,p_enb_attribute29 in varchar2 default hr_api.g_varchar2
415: ,p_enb_attribute30 in varchar2 default hr_api.g_varchar2
416: ,p_request_id in number default hr_api.g_number
417: ,p_program_application_id in number default hr_api.g_number
418: ,p_program_id in number default hr_api.g_number
419: ,p_program_update_date in date default hr_api.g_date
420: ,p_mx_wout_ctfn_val in number default hr_api.g_number
413: ,p_enb_attribute28 in varchar2 default hr_api.g_varchar2
414: ,p_enb_attribute29 in varchar2 default hr_api.g_varchar2
415: ,p_enb_attribute30 in varchar2 default hr_api.g_varchar2
416: ,p_request_id in number default hr_api.g_number
417: ,p_program_application_id in number default hr_api.g_number
418: ,p_program_id in number default hr_api.g_number
419: ,p_program_update_date in date default hr_api.g_date
420: ,p_mx_wout_ctfn_val in number default hr_api.g_number
421: ,p_mx_wo_ctfn_flag in varchar2 default hr_api.g_varchar2
414: ,p_enb_attribute29 in varchar2 default hr_api.g_varchar2
415: ,p_enb_attribute30 in varchar2 default hr_api.g_varchar2
416: ,p_request_id in number default hr_api.g_number
417: ,p_program_application_id in number default hr_api.g_number
418: ,p_program_id in number default hr_api.g_number
419: ,p_program_update_date in date default hr_api.g_date
420: ,p_mx_wout_ctfn_val in number default hr_api.g_number
421: ,p_mx_wo_ctfn_flag in varchar2 default hr_api.g_varchar2
422: ,p_object_version_number in out nocopy number
415: ,p_enb_attribute30 in varchar2 default hr_api.g_varchar2
416: ,p_request_id in number default hr_api.g_number
417: ,p_program_application_id in number default hr_api.g_number
418: ,p_program_id in number default hr_api.g_number
419: ,p_program_update_date in date default hr_api.g_date
420: ,p_mx_wout_ctfn_val in number default hr_api.g_number
421: ,p_mx_wo_ctfn_flag in varchar2 default hr_api.g_varchar2
422: ,p_object_version_number in out nocopy number
423: ,p_effective_date in date
416: ,p_request_id in number default hr_api.g_number
417: ,p_program_application_id in number default hr_api.g_number
418: ,p_program_id in number default hr_api.g_number
419: ,p_program_update_date in date default hr_api.g_date
420: ,p_mx_wout_ctfn_val in number default hr_api.g_number
421: ,p_mx_wo_ctfn_flag in varchar2 default hr_api.g_varchar2
422: ,p_object_version_number in out nocopy number
423: ,p_effective_date in date
424: ) is
417: ,p_program_application_id in number default hr_api.g_number
418: ,p_program_id in number default hr_api.g_number
419: ,p_program_update_date in date default hr_api.g_date
420: ,p_mx_wout_ctfn_val in number default hr_api.g_number
421: ,p_mx_wo_ctfn_flag in varchar2 default hr_api.g_varchar2
422: ,p_object_version_number in out nocopy number
423: ,p_effective_date in date
424: ) is
425: --
509: ,p_object_version_number => l_object_version_number
510: ,p_effective_date => trunc(p_effective_date)
511: );
512: exception
513: when hr_api.cannot_find_prog_unit then
514: hr_api.cannot_find_prog_unit_error
515: (p_module_name => 'UPDATE_enrt_bnft'
516: ,p_hook_type => 'BP'
517: );
510: ,p_effective_date => trunc(p_effective_date)
511: );
512: exception
513: when hr_api.cannot_find_prog_unit then
514: hr_api.cannot_find_prog_unit_error
515: (p_module_name => 'UPDATE_enrt_bnft'
516: ,p_hook_type => 'BP'
517: );
518: --
651: ,p_object_version_number => l_object_version_number
652: ,p_effective_date => trunc(p_effective_date)
653: );
654: exception
655: when hr_api.cannot_find_prog_unit then
656: hr_api.cannot_find_prog_unit_error
657: (p_module_name => 'UPDATE_enrt_bnft'
658: ,p_hook_type => 'AP'
659: );
652: ,p_effective_date => trunc(p_effective_date)
653: );
654: exception
655: when hr_api.cannot_find_prog_unit then
656: hr_api.cannot_find_prog_unit_error
657: (p_module_name => 'UPDATE_enrt_bnft'
658: ,p_hook_type => 'AP'
659: );
660: --
666: --
667: -- When in validation only mode raise the Validate_Enabled exception
668: --
669: if p_validate then
670: raise hr_api.validate_enabled;
671: end if;
672: --
673: -- Set all output arguments
674: --
677: hr_utility.set_location(' Leaving:'||l_proc, 70);
678: --
679: exception
680: --
681: when hr_api.validate_enabled then
682: --
683: -- As the Validate_Enabled exception has been raised
684: -- we must rollback to the savepoint
685: --
741: ,p_object_version_number => p_object_version_number
742: ,p_effective_date => trunc(p_effective_date)
743: );
744: exception
745: when hr_api.cannot_find_prog_unit then
746: hr_api.cannot_find_prog_unit_error
747: (p_module_name => 'DELETE_enrt_bnft'
748: ,p_hook_type => 'BP'
749: );
742: ,p_effective_date => trunc(p_effective_date)
743: );
744: exception
745: when hr_api.cannot_find_prog_unit then
746: hr_api.cannot_find_prog_unit_error
747: (p_module_name => 'DELETE_enrt_bnft'
748: ,p_hook_type => 'BP'
749: );
750: --
769: ,p_object_version_number => l_object_version_number
770: ,p_effective_date => trunc(p_effective_date)
771: );
772: exception
773: when hr_api.cannot_find_prog_unit then
774: hr_api.cannot_find_prog_unit_error
775: (p_module_name => 'DELETE_enrt_bnft'
776: ,p_hook_type => 'AP'
777: );
770: ,p_effective_date => trunc(p_effective_date)
771: );
772: exception
773: when hr_api.cannot_find_prog_unit then
774: hr_api.cannot_find_prog_unit_error
775: (p_module_name => 'DELETE_enrt_bnft'
776: ,p_hook_type => 'AP'
777: );
778: --
784: --
785: -- When in validation only mode raise the Validate_Enabled exception
786: --
787: if p_validate then
788: raise hr_api.validate_enabled;
789: end if;
790: --
791: hr_utility.set_location(' Leaving:'||l_proc, 70);
792: --
791: hr_utility.set_location(' Leaving:'||l_proc, 70);
792: --
793: exception
794: --
795: when hr_api.validate_enabled then
796: --
797: -- As the Validate_Enabled exception has been raised
798: -- we must rollback to the savepoint
799: --