162: ,p_ENRT_PERD_END_DAYS => p_ENRT_PERD_END_DAYS
163: ,p_defer_deenrol_flag => p_defer_deenrol_flag
164: );
165: exception
166: when hr_api.cannot_find_prog_unit then
167: hr_api.cannot_find_prog_unit_error
168: (
169: p_module_name => 'CREATE_Life_Event_Enroll_Rsn'
170: ,p_hook_type => 'BP'
163: ,p_defer_deenrol_flag => p_defer_deenrol_flag
164: );
165: exception
166: when hr_api.cannot_find_prog_unit then
167: hr_api.cannot_find_prog_unit_error
168: (
169: p_module_name => 'CREATE_Life_Event_Enroll_Rsn'
170: ,p_hook_type => 'BP'
171: );
311: ,p_ENRT_PERD_END_DAYS => p_ENRT_PERD_END_DAYS
312: ,p_defer_deenrol_flag => p_defer_deenrol_flag
313: );
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'CREATE_Life_Event_Enroll_Rsn'
318: ,p_hook_type => 'AP'
319: );
312: ,p_defer_deenrol_flag => p_defer_deenrol_flag
313: );
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'CREATE_Life_Event_Enroll_Rsn'
318: ,p_hook_type => 'AP'
319: );
320: --
326: --
327: -- When in validation only mode raise the Validate_Enabled exception
328: --
329: if p_validate then
330: raise hr_api.validate_enabled;
331: end if;
332: --
333: -- Set all output arguments
334: --
340: hr_utility.set_location(' Leaving:'||l_proc, 70);
341: --
342: exception
343: --
344: when hr_api.validate_enabled then
345: --
346: -- As the Validate_Enabled exception has been raised
347: -- we must rollback to the savepoint
348: --
374: (p_validate in boolean default false
375: ,p_lee_rsn_id in number
376: ,p_effective_start_date out nocopy date
377: ,p_effective_end_date out nocopy date
378: ,p_business_group_id in number default hr_api.g_number
379: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
380: ,p_ler_id in number default hr_api.g_number
381: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
382: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
375: ,p_lee_rsn_id in number
376: ,p_effective_start_date out nocopy date
377: ,p_effective_end_date out nocopy date
378: ,p_business_group_id in number default hr_api.g_number
379: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
380: ,p_ler_id in number default hr_api.g_number
381: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
382: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
383: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
376: ,p_effective_start_date out nocopy date
377: ,p_effective_end_date out nocopy date
378: ,p_business_group_id in number default hr_api.g_number
379: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
380: ,p_ler_id in number default hr_api.g_number
381: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
382: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
383: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
377: ,p_effective_end_date out nocopy date
378: ,p_business_group_id in number default hr_api.g_number
379: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
380: ,p_ler_id in number default hr_api.g_number
381: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
382: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
383: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
385: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
378: ,p_business_group_id in number default hr_api.g_number
379: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
380: ,p_ler_id in number default hr_api.g_number
381: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
382: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
383: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
385: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
386: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
379: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
380: ,p_ler_id in number default hr_api.g_number
381: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
382: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
383: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
385: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
386: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
387: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
380: ,p_ler_id in number default hr_api.g_number
381: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
382: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
383: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
385: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
386: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
387: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
388: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
381: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
382: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
383: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
385: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
386: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
387: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
388: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
389: ,p_addl_procg_dys_num in number default hr_api.g_number
382: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
383: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
385: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
386: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
387: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
388: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
389: ,p_addl_procg_dys_num in number default hr_api.g_number
390: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
383: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
385: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
386: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
387: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
388: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
389: ,p_addl_procg_dys_num in number default hr_api.g_number
390: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
391: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
384: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
385: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
386: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
387: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
388: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
389: ,p_addl_procg_dys_num in number default hr_api.g_number
390: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
391: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
392: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
385: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
386: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
387: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
388: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
389: ,p_addl_procg_dys_num in number default hr_api.g_number
390: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
391: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
392: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
393: ,p_rt_end_dt_rl in number default hr_api.g_number
386: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
387: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
388: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
389: ,p_addl_procg_dys_num in number default hr_api.g_number
390: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
391: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
392: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
393: ,p_rt_end_dt_rl in number default hr_api.g_number
394: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
387: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
388: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
389: ,p_addl_procg_dys_num in number default hr_api.g_number
390: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
391: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
392: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
393: ,p_rt_end_dt_rl in number default hr_api.g_number
394: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
395: ,p_rt_strt_dt_rl in number default hr_api.g_number
388: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
389: ,p_addl_procg_dys_num in number default hr_api.g_number
390: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
391: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
392: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
393: ,p_rt_end_dt_rl in number default hr_api.g_number
394: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
395: ,p_rt_strt_dt_rl in number default hr_api.g_number
396: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
389: ,p_addl_procg_dys_num in number default hr_api.g_number
390: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
391: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
392: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
393: ,p_rt_end_dt_rl in number default hr_api.g_number
394: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
395: ,p_rt_strt_dt_rl in number default hr_api.g_number
396: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
397: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
390: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
391: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
392: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
393: ,p_rt_end_dt_rl in number default hr_api.g_number
394: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
395: ,p_rt_strt_dt_rl in number default hr_api.g_number
396: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
397: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
398: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
391: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
392: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
393: ,p_rt_end_dt_rl in number default hr_api.g_number
394: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
395: ,p_rt_strt_dt_rl in number default hr_api.g_number
396: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
397: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
398: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
392: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
393: ,p_rt_end_dt_rl in number default hr_api.g_number
394: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
395: ,p_rt_strt_dt_rl in number default hr_api.g_number
396: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
397: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
398: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
393: ,p_rt_end_dt_rl in number default hr_api.g_number
394: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
395: ,p_rt_strt_dt_rl in number default hr_api.g_number
396: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
397: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
398: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
394: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
395: ,p_rt_strt_dt_rl in number default hr_api.g_number
396: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
397: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
398: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
395: ,p_rt_strt_dt_rl in number default hr_api.g_number
396: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
397: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
398: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
396: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
397: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
398: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
397: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
398: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
398: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
424: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
424: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
425: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
424: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
425: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
426: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
424: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
425: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
426: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
427: ,p_len_attribute29 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
424: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
425: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
426: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
427: ,p_len_attribute29 in varchar2 default hr_api.g_varchar2
428: ,p_len_attribute30 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
424: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
425: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
426: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
427: ,p_len_attribute29 in varchar2 default hr_api.g_varchar2
428: ,p_len_attribute30 in varchar2 default hr_api.g_varchar2
429: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
424: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
425: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
426: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
427: ,p_len_attribute29 in varchar2 default hr_api.g_varchar2
428: ,p_len_attribute30 in varchar2 default hr_api.g_varchar2
429: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
430: ,p_object_version_number in out nocopy number
423: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
424: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
425: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
426: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
427: ,p_len_attribute29 in varchar2 default hr_api.g_varchar2
428: ,p_len_attribute30 in varchar2 default hr_api.g_varchar2
429: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
430: ,p_object_version_number in out nocopy number
431: ,p_effective_date in date
424: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
425: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
426: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
427: ,p_len_attribute29 in varchar2 default hr_api.g_varchar2
428: ,p_len_attribute30 in varchar2 default hr_api.g_varchar2
429: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
430: ,p_object_version_number in out nocopy number
431: ,p_effective_date in date
432: ,p_datetrack_mode in varchar2
425: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
426: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
427: ,p_len_attribute29 in varchar2 default hr_api.g_varchar2
428: ,p_len_attribute30 in varchar2 default hr_api.g_varchar2
429: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
430: ,p_object_version_number in out nocopy number
431: ,p_effective_date in date
432: ,p_datetrack_mode in varchar2
433: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
429: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
430: ,p_object_version_number in out nocopy number
431: ,p_effective_date in date
432: ,p_datetrack_mode in varchar2
433: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
434: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
435: ,p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2
436: ,p_ENRT_PERD_STRT_DAYS in number default hr_api.g_number
437: ,p_ENRT_PERD_END_DAYS in number default hr_api.g_number
430: ,p_object_version_number in out nocopy number
431: ,p_effective_date in date
432: ,p_datetrack_mode in varchar2
433: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
434: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
435: ,p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2
436: ,p_ENRT_PERD_STRT_DAYS in number default hr_api.g_number
437: ,p_ENRT_PERD_END_DAYS in number default hr_api.g_number
438: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
431: ,p_effective_date in date
432: ,p_datetrack_mode in varchar2
433: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
434: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
435: ,p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2
436: ,p_ENRT_PERD_STRT_DAYS in number default hr_api.g_number
437: ,p_ENRT_PERD_END_DAYS in number default hr_api.g_number
438: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
439: ) is
432: ,p_datetrack_mode in varchar2
433: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
434: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
435: ,p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2
436: ,p_ENRT_PERD_STRT_DAYS in number default hr_api.g_number
437: ,p_ENRT_PERD_END_DAYS in number default hr_api.g_number
438: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
439: ) is
440: --
433: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
434: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
435: ,p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2
436: ,p_ENRT_PERD_STRT_DAYS in number default hr_api.g_number
437: ,p_ENRT_PERD_END_DAYS in number default hr_api.g_number
438: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
439: ) is
440: --
441: -- Declare cursors and local variables
434: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
435: ,p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2
436: ,p_ENRT_PERD_STRT_DAYS in number default hr_api.g_number
437: ,p_ENRT_PERD_END_DAYS in number default hr_api.g_number
438: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
439: ) is
440: --
441: -- Declare cursors and local variables
442: --
528: ,p_ENRT_PERD_END_DAYS => p_ENRT_PERD_END_DAYS
529: ,p_defer_deenrol_flag => p_defer_deenrol_flag
530: );
531: exception
532: when hr_api.cannot_find_prog_unit then
533: hr_api.cannot_find_prog_unit_error
534: (p_module_name => 'UPDATE_Life_Event_Enroll_Rsn'
535: ,p_hook_type => 'BP'
536: );
529: ,p_defer_deenrol_flag => p_defer_deenrol_flag
530: );
531: exception
532: when hr_api.cannot_find_prog_unit then
533: hr_api.cannot_find_prog_unit_error
534: (p_module_name => 'UPDATE_Life_Event_Enroll_Rsn'
535: ,p_hook_type => 'BP'
536: );
537: --
678: ,p_ENRT_PERD_END_DAYS => p_ENRT_PERD_END_DAYS
679: ,p_defer_deenrol_flag => p_defer_deenrol_flag
680: );
681: exception
682: when hr_api.cannot_find_prog_unit then
683: hr_api.cannot_find_prog_unit_error
684: (p_module_name => 'UPDATE_Life_Event_Enroll_Rsn'
685: ,p_hook_type => 'AP'
686: );
679: ,p_defer_deenrol_flag => p_defer_deenrol_flag
680: );
681: exception
682: when hr_api.cannot_find_prog_unit then
683: hr_api.cannot_find_prog_unit_error
684: (p_module_name => 'UPDATE_Life_Event_Enroll_Rsn'
685: ,p_hook_type => 'AP'
686: );
687: --
693: --
694: -- When in validation only mode raise the Validate_Enabled exception
695: --
696: if p_validate then
697: raise hr_api.validate_enabled;
698: end if;
699: --
700: -- Set all output arguments
701: --
706: hr_utility.set_location(' Leaving:'||l_proc, 70);
707: --
708: exception
709: --
710: when hr_api.validate_enabled then
711: --
712: -- As the Validate_Enabled exception has been raised
713: -- we must rollback to the savepoint
714: --
779: ,p_effective_date => trunc(p_effective_date)
780: ,p_datetrack_mode => p_datetrack_mode
781: );
782: exception
783: when hr_api.cannot_find_prog_unit then
784: hr_api.cannot_find_prog_unit_error
785: (p_module_name => 'DELETE_Life_Event_Enroll_Rsn'
786: ,p_hook_type => 'BP'
787: );
780: ,p_datetrack_mode => p_datetrack_mode
781: );
782: exception
783: when hr_api.cannot_find_prog_unit then
784: hr_api.cannot_find_prog_unit_error
785: (p_module_name => 'DELETE_Life_Event_Enroll_Rsn'
786: ,p_hook_type => 'BP'
787: );
788: --
813: ,p_effective_date => trunc(p_effective_date)
814: ,p_datetrack_mode => p_datetrack_mode
815: );
816: exception
817: when hr_api.cannot_find_prog_unit then
818: hr_api.cannot_find_prog_unit_error
819: (p_module_name => 'DELETE_Life_Event_Enroll_Rsn'
820: ,p_hook_type => 'AP'
821: );
814: ,p_datetrack_mode => p_datetrack_mode
815: );
816: exception
817: when hr_api.cannot_find_prog_unit then
818: hr_api.cannot_find_prog_unit_error
819: (p_module_name => 'DELETE_Life_Event_Enroll_Rsn'
820: ,p_hook_type => 'AP'
821: );
822: --
828: --
829: -- When in validation only mode raise the Validate_Enabled exception
830: --
831: if p_validate then
832: raise hr_api.validate_enabled;
833: end if;
834: --
835: hr_utility.set_location(' Leaving:'||l_proc, 70);
836: --
835: hr_utility.set_location(' Leaving:'||l_proc, 70);
836: --
837: exception
838: --
839: when hr_api.validate_enabled then
840: --
841: -- As the Validate_Enabled exception has been raised
842: -- we must rollback to the savepoint
843: --