154: ,p_ctfn_determine_cd => p_ctfn_determine_cd
155: ,p_effective_date => trunc(p_effective_date)
156: );
157: exception
158: when hr_api.cannot_find_prog_unit then
159: hr_api.cannot_find_prog_unit_error
160: (
161: p_module_name => 'CREATE_LER_BNFT_RSTRN'
162: ,p_hook_type => 'BP'
155: ,p_effective_date => trunc(p_effective_date)
156: );
157: exception
158: when hr_api.cannot_find_prog_unit then
159: hr_api.cannot_find_prog_unit_error
160: (
161: p_module_name => 'CREATE_LER_BNFT_RSTRN'
162: ,p_hook_type => 'BP'
163: );
295: ,p_object_version_number => l_object_version_number
296: ,p_effective_date => trunc(p_effective_date)
297: );
298: exception
299: when hr_api.cannot_find_prog_unit then
300: hr_api.cannot_find_prog_unit_error
301: (p_module_name => 'CREATE_LER_BNFT_RSTRN'
302: ,p_hook_type => 'AP'
303: );
296: ,p_effective_date => trunc(p_effective_date)
297: );
298: exception
299: when hr_api.cannot_find_prog_unit then
300: hr_api.cannot_find_prog_unit_error
301: (p_module_name => 'CREATE_LER_BNFT_RSTRN'
302: ,p_hook_type => 'AP'
303: );
304: --
310: --
311: -- When in validation only mode raise the Validate_Enabled exception
312: --
313: if p_validate then
314: raise hr_api.validate_enabled;
315: end if;
316: --
317: -- Set all output arguments
318: --
324: hr_utility.set_location(' Leaving:'||l_proc, 70);
325: --
326: exception
327: --
328: when hr_api.validate_enabled then
329: --
330: -- As the Validate_Enabled exception has been raised
331: -- we must rollback to the savepoint
332: --
358: (p_validate in boolean default false
359: ,p_ler_bnft_rstrn_id in number
360: ,p_effective_start_date out nocopy date
361: ,p_effective_end_date out nocopy date
362: ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
363: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
364: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
365: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
366: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
359: ,p_ler_bnft_rstrn_id in number
360: ,p_effective_start_date out nocopy date
361: ,p_effective_end_date out nocopy date
362: ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
363: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
364: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
365: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
366: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
367: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
360: ,p_effective_start_date out nocopy date
361: ,p_effective_end_date out nocopy date
362: ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
363: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
364: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
365: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
366: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
367: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
368: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
361: ,p_effective_end_date out nocopy date
362: ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
363: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
364: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
365: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
366: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
367: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
368: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
369: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
362: ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
363: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
364: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
365: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
366: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
367: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
368: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
369: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
370: ,p_mx_cvg_rl in number default hr_api.g_number
363: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
364: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
365: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
366: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
367: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
368: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
369: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
370: ,p_mx_cvg_rl in number default hr_api.g_number
371: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
364: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
365: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
366: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
367: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
368: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
369: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
370: ,p_mx_cvg_rl in number default hr_api.g_number
371: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
372: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
365: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
366: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
367: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
368: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
369: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
370: ,p_mx_cvg_rl in number default hr_api.g_number
371: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
372: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
373: ,p_mn_cvg_amt in number default hr_api.g_number
366: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
367: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
368: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
369: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
370: ,p_mx_cvg_rl in number default hr_api.g_number
371: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
372: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
373: ,p_mn_cvg_amt in number default hr_api.g_number
374: ,p_mn_cvg_rl in number default hr_api.g_number
367: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
368: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
369: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
370: ,p_mx_cvg_rl in number default hr_api.g_number
371: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
372: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
373: ,p_mn_cvg_amt in number default hr_api.g_number
374: ,p_mn_cvg_rl in number default hr_api.g_number
375: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
368: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
369: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
370: ,p_mx_cvg_rl in number default hr_api.g_number
371: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
372: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
373: ,p_mn_cvg_amt in number default hr_api.g_number
374: ,p_mn_cvg_rl in number default hr_api.g_number
375: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
376: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
369: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
370: ,p_mx_cvg_rl in number default hr_api.g_number
371: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
372: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
373: ,p_mn_cvg_amt in number default hr_api.g_number
374: ,p_mn_cvg_rl in number default hr_api.g_number
375: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
376: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
377: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
370: ,p_mx_cvg_rl in number default hr_api.g_number
371: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
372: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
373: ,p_mn_cvg_amt in number default hr_api.g_number
374: ,p_mn_cvg_rl in number default hr_api.g_number
375: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
376: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
377: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
378: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
371: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
372: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
373: ,p_mn_cvg_amt in number default hr_api.g_number
374: ,p_mn_cvg_rl in number default hr_api.g_number
375: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
376: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
377: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
378: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
379: ,p_ler_id in number default hr_api.g_number
372: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
373: ,p_mn_cvg_amt in number default hr_api.g_number
374: ,p_mn_cvg_rl in number default hr_api.g_number
375: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
376: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
377: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
378: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
379: ,p_ler_id in number default hr_api.g_number
380: ,p_pl_id in number default hr_api.g_number
373: ,p_mn_cvg_amt in number default hr_api.g_number
374: ,p_mn_cvg_rl in number default hr_api.g_number
375: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
376: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
377: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
378: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
379: ,p_ler_id in number default hr_api.g_number
380: ,p_pl_id in number default hr_api.g_number
381: ,p_business_group_id in number default hr_api.g_number
374: ,p_mn_cvg_rl in number default hr_api.g_number
375: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
376: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
377: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
378: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
379: ,p_ler_id in number default hr_api.g_number
380: ,p_pl_id in number default hr_api.g_number
381: ,p_business_group_id in number default hr_api.g_number
382: ,p_plip_id in number default hr_api.g_number
375: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
376: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
377: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
378: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
379: ,p_ler_id in number default hr_api.g_number
380: ,p_pl_id in number default hr_api.g_number
381: ,p_business_group_id in number default hr_api.g_number
382: ,p_plip_id in number default hr_api.g_number
383: ,p_lbr_attribute_category in varchar2 default hr_api.g_varchar2
376: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
377: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
378: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
379: ,p_ler_id in number default hr_api.g_number
380: ,p_pl_id in number default hr_api.g_number
381: ,p_business_group_id in number default hr_api.g_number
382: ,p_plip_id in number default hr_api.g_number
383: ,p_lbr_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_lbr_attribute1 in varchar2 default hr_api.g_varchar2
377: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
378: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
379: ,p_ler_id in number default hr_api.g_number
380: ,p_pl_id in number default hr_api.g_number
381: ,p_business_group_id in number default hr_api.g_number
382: ,p_plip_id in number default hr_api.g_number
383: ,p_lbr_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_lbr_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_lbr_attribute2 in varchar2 default hr_api.g_varchar2
378: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
379: ,p_ler_id in number default hr_api.g_number
380: ,p_pl_id in number default hr_api.g_number
381: ,p_business_group_id in number default hr_api.g_number
382: ,p_plip_id in number default hr_api.g_number
383: ,p_lbr_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_lbr_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_lbr_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_lbr_attribute3 in varchar2 default hr_api.g_varchar2
379: ,p_ler_id in number default hr_api.g_number
380: ,p_pl_id in number default hr_api.g_number
381: ,p_business_group_id in number default hr_api.g_number
382: ,p_plip_id in number default hr_api.g_number
383: ,p_lbr_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_lbr_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_lbr_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_lbr_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_lbr_attribute4 in varchar2 default hr_api.g_varchar2
380: ,p_pl_id in number default hr_api.g_number
381: ,p_business_group_id in number default hr_api.g_number
382: ,p_plip_id in number default hr_api.g_number
383: ,p_lbr_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_lbr_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_lbr_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_lbr_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_lbr_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_lbr_attribute5 in varchar2 default hr_api.g_varchar2
381: ,p_business_group_id in number default hr_api.g_number
382: ,p_plip_id in number default hr_api.g_number
383: ,p_lbr_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_lbr_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_lbr_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_lbr_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_lbr_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_lbr_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_lbr_attribute6 in varchar2 default hr_api.g_varchar2
382: ,p_plip_id in number default hr_api.g_number
383: ,p_lbr_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_lbr_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_lbr_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_lbr_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_lbr_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_lbr_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_lbr_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_lbr_attribute7 in varchar2 default hr_api.g_varchar2
383: ,p_lbr_attribute_category in varchar2 default hr_api.g_varchar2
384: ,p_lbr_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_lbr_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_lbr_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_lbr_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_lbr_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_lbr_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_lbr_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_lbr_attribute8 in varchar2 default hr_api.g_varchar2
384: ,p_lbr_attribute1 in varchar2 default hr_api.g_varchar2
385: ,p_lbr_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_lbr_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_lbr_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_lbr_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_lbr_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_lbr_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_lbr_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_lbr_attribute9 in varchar2 default hr_api.g_varchar2
385: ,p_lbr_attribute2 in varchar2 default hr_api.g_varchar2
386: ,p_lbr_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_lbr_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_lbr_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_lbr_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_lbr_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_lbr_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_lbr_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_lbr_attribute10 in varchar2 default hr_api.g_varchar2
386: ,p_lbr_attribute3 in varchar2 default hr_api.g_varchar2
387: ,p_lbr_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_lbr_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_lbr_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_lbr_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_lbr_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_lbr_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_lbr_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_lbr_attribute11 in varchar2 default hr_api.g_varchar2
387: ,p_lbr_attribute4 in varchar2 default hr_api.g_varchar2
388: ,p_lbr_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_lbr_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_lbr_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_lbr_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_lbr_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_lbr_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_lbr_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_lbr_attribute12 in varchar2 default hr_api.g_varchar2
388: ,p_lbr_attribute5 in varchar2 default hr_api.g_varchar2
389: ,p_lbr_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_lbr_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_lbr_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_lbr_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_lbr_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_lbr_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_lbr_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_lbr_attribute13 in varchar2 default hr_api.g_varchar2
389: ,p_lbr_attribute6 in varchar2 default hr_api.g_varchar2
390: ,p_lbr_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_lbr_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_lbr_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_lbr_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_lbr_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_lbr_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_lbr_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_lbr_attribute14 in varchar2 default hr_api.g_varchar2
390: ,p_lbr_attribute7 in varchar2 default hr_api.g_varchar2
391: ,p_lbr_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_lbr_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_lbr_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_lbr_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_lbr_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_lbr_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_lbr_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_lbr_attribute15 in varchar2 default hr_api.g_varchar2
391: ,p_lbr_attribute8 in varchar2 default hr_api.g_varchar2
392: ,p_lbr_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_lbr_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_lbr_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_lbr_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_lbr_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_lbr_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_lbr_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_lbr_attribute16 in varchar2 default hr_api.g_varchar2
392: ,p_lbr_attribute9 in varchar2 default hr_api.g_varchar2
393: ,p_lbr_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_lbr_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_lbr_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_lbr_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_lbr_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_lbr_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_lbr_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_lbr_attribute17 in varchar2 default hr_api.g_varchar2
393: ,p_lbr_attribute10 in varchar2 default hr_api.g_varchar2
394: ,p_lbr_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_lbr_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_lbr_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_lbr_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_lbr_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_lbr_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_lbr_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_lbr_attribute18 in varchar2 default hr_api.g_varchar2
394: ,p_lbr_attribute11 in varchar2 default hr_api.g_varchar2
395: ,p_lbr_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_lbr_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_lbr_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_lbr_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_lbr_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_lbr_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_lbr_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_lbr_attribute19 in varchar2 default hr_api.g_varchar2
395: ,p_lbr_attribute12 in varchar2 default hr_api.g_varchar2
396: ,p_lbr_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_lbr_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_lbr_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_lbr_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_lbr_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_lbr_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_lbr_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_lbr_attribute20 in varchar2 default hr_api.g_varchar2
396: ,p_lbr_attribute13 in varchar2 default hr_api.g_varchar2
397: ,p_lbr_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_lbr_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_lbr_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_lbr_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_lbr_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_lbr_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_lbr_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_lbr_attribute21 in varchar2 default hr_api.g_varchar2
397: ,p_lbr_attribute14 in varchar2 default hr_api.g_varchar2
398: ,p_lbr_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_lbr_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_lbr_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_lbr_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_lbr_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_lbr_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_lbr_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_lbr_attribute22 in varchar2 default hr_api.g_varchar2
398: ,p_lbr_attribute15 in varchar2 default hr_api.g_varchar2
399: ,p_lbr_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_lbr_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_lbr_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_lbr_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_lbr_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_lbr_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_lbr_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_lbr_attribute23 in varchar2 default hr_api.g_varchar2
399: ,p_lbr_attribute16 in varchar2 default hr_api.g_varchar2
400: ,p_lbr_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_lbr_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_lbr_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_lbr_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_lbr_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_lbr_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_lbr_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_lbr_attribute24 in varchar2 default hr_api.g_varchar2
400: ,p_lbr_attribute17 in varchar2 default hr_api.g_varchar2
401: ,p_lbr_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_lbr_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_lbr_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_lbr_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_lbr_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_lbr_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_lbr_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_lbr_attribute25 in varchar2 default hr_api.g_varchar2
401: ,p_lbr_attribute18 in varchar2 default hr_api.g_varchar2
402: ,p_lbr_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_lbr_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_lbr_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_lbr_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_lbr_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_lbr_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_lbr_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_lbr_attribute26 in varchar2 default hr_api.g_varchar2
402: ,p_lbr_attribute19 in varchar2 default hr_api.g_varchar2
403: ,p_lbr_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_lbr_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_lbr_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_lbr_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_lbr_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_lbr_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_lbr_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_lbr_attribute27 in varchar2 default hr_api.g_varchar2
403: ,p_lbr_attribute20 in varchar2 default hr_api.g_varchar2
404: ,p_lbr_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_lbr_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_lbr_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_lbr_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_lbr_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_lbr_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_lbr_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_lbr_attribute28 in varchar2 default hr_api.g_varchar2
404: ,p_lbr_attribute21 in varchar2 default hr_api.g_varchar2
405: ,p_lbr_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_lbr_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_lbr_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_lbr_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_lbr_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_lbr_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_lbr_attribute28 in varchar2 default hr_api.g_varchar2
412: ,p_lbr_attribute29 in varchar2 default hr_api.g_varchar2
405: ,p_lbr_attribute22 in varchar2 default hr_api.g_varchar2
406: ,p_lbr_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_lbr_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_lbr_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_lbr_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_lbr_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_lbr_attribute28 in varchar2 default hr_api.g_varchar2
412: ,p_lbr_attribute29 in varchar2 default hr_api.g_varchar2
413: ,p_lbr_attribute30 in varchar2 default hr_api.g_varchar2
406: ,p_lbr_attribute23 in varchar2 default hr_api.g_varchar2
407: ,p_lbr_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_lbr_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_lbr_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_lbr_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_lbr_attribute28 in varchar2 default hr_api.g_varchar2
412: ,p_lbr_attribute29 in varchar2 default hr_api.g_varchar2
413: ,p_lbr_attribute30 in varchar2 default hr_api.g_varchar2
414: ,p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2
407: ,p_lbr_attribute24 in varchar2 default hr_api.g_varchar2
408: ,p_lbr_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_lbr_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_lbr_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_lbr_attribute28 in varchar2 default hr_api.g_varchar2
412: ,p_lbr_attribute29 in varchar2 default hr_api.g_varchar2
413: ,p_lbr_attribute30 in varchar2 default hr_api.g_varchar2
414: ,p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2
415: ,p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
408: ,p_lbr_attribute25 in varchar2 default hr_api.g_varchar2
409: ,p_lbr_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_lbr_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_lbr_attribute28 in varchar2 default hr_api.g_varchar2
412: ,p_lbr_attribute29 in varchar2 default hr_api.g_varchar2
413: ,p_lbr_attribute30 in varchar2 default hr_api.g_varchar2
414: ,p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2
415: ,p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
416: ,p_object_version_number in out nocopy number
409: ,p_lbr_attribute26 in varchar2 default hr_api.g_varchar2
410: ,p_lbr_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_lbr_attribute28 in varchar2 default hr_api.g_varchar2
412: ,p_lbr_attribute29 in varchar2 default hr_api.g_varchar2
413: ,p_lbr_attribute30 in varchar2 default hr_api.g_varchar2
414: ,p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2
415: ,p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
416: ,p_object_version_number in out nocopy number
417: ,p_effective_date in date
410: ,p_lbr_attribute27 in varchar2 default hr_api.g_varchar2
411: ,p_lbr_attribute28 in varchar2 default hr_api.g_varchar2
412: ,p_lbr_attribute29 in varchar2 default hr_api.g_varchar2
413: ,p_lbr_attribute30 in varchar2 default hr_api.g_varchar2
414: ,p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2
415: ,p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
416: ,p_object_version_number in out nocopy number
417: ,p_effective_date in date
418: ,p_datetrack_mode in varchar2
411: ,p_lbr_attribute28 in varchar2 default hr_api.g_varchar2
412: ,p_lbr_attribute29 in varchar2 default hr_api.g_varchar2
413: ,p_lbr_attribute30 in varchar2 default hr_api.g_varchar2
414: ,p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2
415: ,p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
416: ,p_object_version_number in out nocopy number
417: ,p_effective_date in date
418: ,p_datetrack_mode in varchar2
419: ) is
504: ,p_effective_date => trunc(p_effective_date)
505: ,p_datetrack_mode => p_datetrack_mode
506: );
507: exception
508: when hr_api.cannot_find_prog_unit then
509: hr_api.cannot_find_prog_unit_error
510: (p_module_name => 'UPDATE_LER_BNFT_RSTRN'
511: ,p_hook_type => 'BP'
512: );
505: ,p_datetrack_mode => p_datetrack_mode
506: );
507: exception
508: when hr_api.cannot_find_prog_unit then
509: hr_api.cannot_find_prog_unit_error
510: (p_module_name => 'UPDATE_LER_BNFT_RSTRN'
511: ,p_hook_type => 'BP'
512: );
513: --
646: ,p_effective_date => trunc(p_effective_date)
647: ,p_datetrack_mode => p_datetrack_mode
648: );
649: exception
650: when hr_api.cannot_find_prog_unit then
651: hr_api.cannot_find_prog_unit_error
652: (p_module_name => 'UPDATE_LER_BNFT_RSTRN'
653: ,p_hook_type => 'AP'
654: );
647: ,p_datetrack_mode => p_datetrack_mode
648: );
649: exception
650: when hr_api.cannot_find_prog_unit then
651: hr_api.cannot_find_prog_unit_error
652: (p_module_name => 'UPDATE_LER_BNFT_RSTRN'
653: ,p_hook_type => 'AP'
654: );
655: --
661: --
662: -- When in validation only mode raise the Validate_Enabled exception
663: --
664: if p_validate then
665: raise hr_api.validate_enabled;
666: end if;
667: --
668: -- Set all output arguments
669: --
674: hr_utility.set_location(' Leaving:'||l_proc, 70);
675: --
676: exception
677: --
678: when hr_api.validate_enabled then
679: --
680: -- As the Validate_Enabled exception has been raised
681: -- we must rollback to the savepoint
682: --
747: ,p_effective_date => trunc(p_effective_date)
748: ,p_datetrack_mode => p_datetrack_mode
749: );
750: exception
751: when hr_api.cannot_find_prog_unit then
752: hr_api.cannot_find_prog_unit_error
753: (p_module_name => 'DELETE_LER_BNFT_RSTRN'
754: ,p_hook_type => 'BP'
755: );
748: ,p_datetrack_mode => p_datetrack_mode
749: );
750: exception
751: when hr_api.cannot_find_prog_unit then
752: hr_api.cannot_find_prog_unit_error
753: (p_module_name => 'DELETE_LER_BNFT_RSTRN'
754: ,p_hook_type => 'BP'
755: );
756: --
781: ,p_effective_date => trunc(p_effective_date)
782: ,p_datetrack_mode => p_datetrack_mode
783: );
784: exception
785: when hr_api.cannot_find_prog_unit then
786: hr_api.cannot_find_prog_unit_error
787: (p_module_name => 'DELETE_LER_BNFT_RSTRN'
788: ,p_hook_type => 'AP'
789: );
782: ,p_datetrack_mode => p_datetrack_mode
783: );
784: exception
785: when hr_api.cannot_find_prog_unit then
786: hr_api.cannot_find_prog_unit_error
787: (p_module_name => 'DELETE_LER_BNFT_RSTRN'
788: ,p_hook_type => 'AP'
789: );
790: --
796: --
797: -- When in validation only mode raise the Validate_Enabled exception
798: --
799: if p_validate then
800: raise hr_api.validate_enabled;
801: end if;
802: --
803: hr_utility.set_location(' Leaving:'||l_proc, 70);
804: --
803: hr_utility.set_location(' Leaving:'||l_proc, 70);
804: --
805: exception
806: --
807: when hr_api.validate_enabled then
808: --
809: -- As the Validate_Enabled exception has been raised
810: -- we must rollback to the savepoint
811: --