160: ,p_ENRT_PERD_END_DAYS => p_ENRT_PERD_END_DAYS
161: ,p_defer_deenrol_flag => p_defer_deenrol_flag
162: );
163: exception
164: when hr_api.cannot_find_prog_unit then
165: hr_api.cannot_find_prog_unit_error
166: (
167: p_module_name => 'CREATE_Life_Event_Enroll_Rsn'
168: ,p_hook_type => 'BP'
161: ,p_defer_deenrol_flag => p_defer_deenrol_flag
162: );
163: exception
164: when hr_api.cannot_find_prog_unit then
165: hr_api.cannot_find_prog_unit_error
166: (
167: p_module_name => 'CREATE_Life_Event_Enroll_Rsn'
168: ,p_hook_type => 'BP'
169: );
307: ,p_ENRT_PERD_END_DAYS => p_ENRT_PERD_END_DAYS
308: ,p_defer_deenrol_flag => p_defer_deenrol_flag
309: );
310: exception
311: when hr_api.cannot_find_prog_unit then
312: hr_api.cannot_find_prog_unit_error
313: (p_module_name => 'CREATE_Life_Event_Enroll_Rsn'
314: ,p_hook_type => 'AP'
315: );
308: ,p_defer_deenrol_flag => p_defer_deenrol_flag
309: );
310: exception
311: when hr_api.cannot_find_prog_unit then
312: hr_api.cannot_find_prog_unit_error
313: (p_module_name => 'CREATE_Life_Event_Enroll_Rsn'
314: ,p_hook_type => 'AP'
315: );
316: --
322: --
323: -- When in validation only mode raise the Validate_Enabled exception
324: --
325: if p_validate then
326: raise hr_api.validate_enabled;
327: end if;
328: --
329: -- Set all output arguments
330: --
336: hr_utility.set_location(' Leaving:'||l_proc, 70);
337: --
338: exception
339: --
340: when hr_api.validate_enabled then
341: --
342: -- As the Validate_Enabled exception has been raised
343: -- we must rollback to the savepoint
344: --
370: (p_validate in boolean default false
371: ,p_lee_rsn_id in number
372: ,p_effective_start_date out nocopy date
373: ,p_effective_end_date out nocopy date
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
376: ,p_ler_id in number default hr_api.g_number
377: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
378: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
371: ,p_lee_rsn_id in number
372: ,p_effective_start_date out nocopy date
373: ,p_effective_end_date out nocopy date
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
376: ,p_ler_id in number default hr_api.g_number
377: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
378: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
379: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
372: ,p_effective_start_date out nocopy date
373: ,p_effective_end_date out nocopy date
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
376: ,p_ler_id in number default hr_api.g_number
377: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
378: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
379: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
380: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
373: ,p_effective_end_date out nocopy date
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
376: ,p_ler_id in number default hr_api.g_number
377: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
378: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
379: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
380: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
381: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
374: ,p_business_group_id in number default hr_api.g_number
375: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
376: ,p_ler_id in number default hr_api.g_number
377: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
378: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
379: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
380: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
381: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
382: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
375: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
376: ,p_ler_id in number default hr_api.g_number
377: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
378: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
379: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
380: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
381: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
382: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
383: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
376: ,p_ler_id in number default hr_api.g_number
377: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
378: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
379: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
380: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
381: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
382: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
383: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
377: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
378: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
379: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
380: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
381: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
382: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
383: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
385: ,p_addl_procg_dys_num in number default hr_api.g_number
378: ,p_dys_aftr_end_to_dflt_num in number default hr_api.g_number
379: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
380: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
381: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
382: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
383: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
385: ,p_addl_procg_dys_num in number default hr_api.g_number
386: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
379: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
380: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
381: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
382: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
383: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
385: ,p_addl_procg_dys_num in number default hr_api.g_number
386: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
387: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
380: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
381: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
382: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
383: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
385: ,p_addl_procg_dys_num in number default hr_api.g_number
386: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
387: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
388: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
381: ,p_enrt_perd_strt_dt_cd in varchar2 default hr_api.g_varchar2
382: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
383: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
385: ,p_addl_procg_dys_num in number default hr_api.g_number
386: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
387: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
388: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_rt_end_dt_rl in number default hr_api.g_number
382: ,p_enrt_perd_strt_dt_rl in number default hr_api.g_number
383: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
385: ,p_addl_procg_dys_num in number default hr_api.g_number
386: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
387: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
388: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_rt_end_dt_rl in number default hr_api.g_number
390: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
383: ,p_enrt_perd_end_dt_cd in varchar2 default hr_api.g_varchar2
384: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
385: ,p_addl_procg_dys_num in number default hr_api.g_number
386: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
387: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
388: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_rt_end_dt_rl in number default hr_api.g_number
390: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_rt_strt_dt_rl in number default hr_api.g_number
384: ,p_enrt_perd_end_dt_rl in number default hr_api.g_number
385: ,p_addl_procg_dys_num in number default hr_api.g_number
386: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
387: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
388: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_rt_end_dt_rl in number default hr_api.g_number
390: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_rt_strt_dt_rl in number default hr_api.g_number
392: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
385: ,p_addl_procg_dys_num in number default hr_api.g_number
386: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
387: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
388: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_rt_end_dt_rl in number default hr_api.g_number
390: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_rt_strt_dt_rl in number default hr_api.g_number
392: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
393: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
386: ,p_dys_no_enrl_not_elig_num in number default hr_api.g_number
387: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
388: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_rt_end_dt_rl in number default hr_api.g_number
390: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_rt_strt_dt_rl in number default hr_api.g_number
392: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
393: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
394: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
387: ,p_dys_no_enrl_cant_enrl_num in number default hr_api.g_number
388: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_rt_end_dt_rl in number default hr_api.g_number
390: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_rt_strt_dt_rl in number default hr_api.g_number
392: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
393: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
394: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
388: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
389: ,p_rt_end_dt_rl in number default hr_api.g_number
390: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_rt_strt_dt_rl in number default hr_api.g_number
392: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
393: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
394: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
389: ,p_rt_end_dt_rl in number default hr_api.g_number
390: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_rt_strt_dt_rl in number default hr_api.g_number
392: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
393: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
394: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
390: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
391: ,p_rt_strt_dt_rl in number default hr_api.g_number
392: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
393: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
394: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
391: ,p_rt_strt_dt_rl in number default hr_api.g_number
392: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
393: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
394: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
392: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
393: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
394: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
393: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
394: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
394: ,p_len_attribute_category in varchar2 default hr_api.g_varchar2
395: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
395: ,p_len_attribute1 in varchar2 default hr_api.g_varchar2
396: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
396: ,p_len_attribute2 in varchar2 default hr_api.g_varchar2
397: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
397: ,p_len_attribute3 in varchar2 default hr_api.g_varchar2
398: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
398: ,p_len_attribute4 in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
399: ,p_len_attribute5 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
400: ,p_len_attribute6 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
401: ,p_len_attribute7 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
402: ,p_len_attribute8 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
403: ,p_len_attribute9 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
404: ,p_len_attribute10 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
405: ,p_len_attribute11 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
406: ,p_len_attribute12 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
407: ,p_len_attribute13 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
408: ,p_len_attribute14 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
409: ,p_len_attribute15 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
410: ,p_len_attribute16 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
411: ,p_len_attribute17 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
412: ,p_len_attribute18 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
413: ,p_len_attribute19 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
414: ,p_len_attribute20 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
415: ,p_len_attribute21 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute29 in varchar2 default hr_api.g_varchar2
416: ,p_len_attribute22 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute29 in varchar2 default hr_api.g_varchar2
424: ,p_len_attribute30 in varchar2 default hr_api.g_varchar2
417: ,p_len_attribute23 in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute29 in varchar2 default hr_api.g_varchar2
424: ,p_len_attribute30 in varchar2 default hr_api.g_varchar2
425: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
418: ,p_len_attribute24 in varchar2 default hr_api.g_varchar2
419: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute29 in varchar2 default hr_api.g_varchar2
424: ,p_len_attribute30 in varchar2 default hr_api.g_varchar2
425: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
426: ,p_object_version_number in out nocopy number
419: ,p_len_attribute25 in varchar2 default hr_api.g_varchar2
420: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute29 in varchar2 default hr_api.g_varchar2
424: ,p_len_attribute30 in varchar2 default hr_api.g_varchar2
425: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
426: ,p_object_version_number in out nocopy number
427: ,p_effective_date in date
420: ,p_len_attribute26 in varchar2 default hr_api.g_varchar2
421: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute29 in varchar2 default hr_api.g_varchar2
424: ,p_len_attribute30 in varchar2 default hr_api.g_varchar2
425: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
426: ,p_object_version_number in out nocopy number
427: ,p_effective_date in date
428: ,p_datetrack_mode in varchar2
421: ,p_len_attribute27 in varchar2 default hr_api.g_varchar2
422: ,p_len_attribute28 in varchar2 default hr_api.g_varchar2
423: ,p_len_attribute29 in varchar2 default hr_api.g_varchar2
424: ,p_len_attribute30 in varchar2 default hr_api.g_varchar2
425: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
426: ,p_object_version_number in out nocopy number
427: ,p_effective_date in date
428: ,p_datetrack_mode in varchar2
429: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
425: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
426: ,p_object_version_number in out nocopy number
427: ,p_effective_date in date
428: ,p_datetrack_mode in varchar2
429: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
430: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
431: ,p_ENRT_PERD_STRT_DAYS in number default hr_api.g_number
432: ,p_ENRT_PERD_END_DAYS in number default hr_api.g_number
433: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
426: ,p_object_version_number in out nocopy number
427: ,p_effective_date in date
428: ,p_datetrack_mode in varchar2
429: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
430: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
431: ,p_ENRT_PERD_STRT_DAYS in number default hr_api.g_number
432: ,p_ENRT_PERD_END_DAYS in number default hr_api.g_number
433: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
434: ) is
427: ,p_effective_date in date
428: ,p_datetrack_mode in varchar2
429: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
430: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
431: ,p_ENRT_PERD_STRT_DAYS in number default hr_api.g_number
432: ,p_ENRT_PERD_END_DAYS in number default hr_api.g_number
433: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
434: ) is
435: --
428: ,p_datetrack_mode in varchar2
429: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
430: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
431: ,p_ENRT_PERD_STRT_DAYS in number default hr_api.g_number
432: ,p_ENRT_PERD_END_DAYS in number default hr_api.g_number
433: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
434: ) is
435: --
436: -- Declare cursors and local variables
429: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
430: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
431: ,p_ENRT_PERD_STRT_DAYS in number default hr_api.g_number
432: ,p_ENRT_PERD_END_DAYS in number default hr_api.g_number
433: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
434: ) is
435: --
436: -- Declare cursors and local variables
437: --
522: ,p_ENRT_PERD_END_DAYS => p_ENRT_PERD_END_DAYS
523: ,p_defer_deenrol_flag => p_defer_deenrol_flag
524: );
525: exception
526: when hr_api.cannot_find_prog_unit then
527: hr_api.cannot_find_prog_unit_error
528: (p_module_name => 'UPDATE_Life_Event_Enroll_Rsn'
529: ,p_hook_type => 'BP'
530: );
523: ,p_defer_deenrol_flag => p_defer_deenrol_flag
524: );
525: exception
526: when hr_api.cannot_find_prog_unit then
527: hr_api.cannot_find_prog_unit_error
528: (p_module_name => 'UPDATE_Life_Event_Enroll_Rsn'
529: ,p_hook_type => 'BP'
530: );
531: --
670: ,p_ENRT_PERD_END_DAYS => p_ENRT_PERD_END_DAYS
671: ,p_defer_deenrol_flag => p_defer_deenrol_flag
672: );
673: exception
674: when hr_api.cannot_find_prog_unit then
675: hr_api.cannot_find_prog_unit_error
676: (p_module_name => 'UPDATE_Life_Event_Enroll_Rsn'
677: ,p_hook_type => 'AP'
678: );
671: ,p_defer_deenrol_flag => p_defer_deenrol_flag
672: );
673: exception
674: when hr_api.cannot_find_prog_unit then
675: hr_api.cannot_find_prog_unit_error
676: (p_module_name => 'UPDATE_Life_Event_Enroll_Rsn'
677: ,p_hook_type => 'AP'
678: );
679: --
685: --
686: -- When in validation only mode raise the Validate_Enabled exception
687: --
688: if p_validate then
689: raise hr_api.validate_enabled;
690: end if;
691: --
692: -- Set all output arguments
693: --
698: hr_utility.set_location(' Leaving:'||l_proc, 70);
699: --
700: exception
701: --
702: when hr_api.validate_enabled then
703: --
704: -- As the Validate_Enabled exception has been raised
705: -- we must rollback to the savepoint
706: --
771: ,p_effective_date => trunc(p_effective_date)
772: ,p_datetrack_mode => p_datetrack_mode
773: );
774: exception
775: when hr_api.cannot_find_prog_unit then
776: hr_api.cannot_find_prog_unit_error
777: (p_module_name => 'DELETE_Life_Event_Enroll_Rsn'
778: ,p_hook_type => 'BP'
779: );
772: ,p_datetrack_mode => p_datetrack_mode
773: );
774: exception
775: when hr_api.cannot_find_prog_unit then
776: hr_api.cannot_find_prog_unit_error
777: (p_module_name => 'DELETE_Life_Event_Enroll_Rsn'
778: ,p_hook_type => 'BP'
779: );
780: --
805: ,p_effective_date => trunc(p_effective_date)
806: ,p_datetrack_mode => p_datetrack_mode
807: );
808: exception
809: when hr_api.cannot_find_prog_unit then
810: hr_api.cannot_find_prog_unit_error
811: (p_module_name => 'DELETE_Life_Event_Enroll_Rsn'
812: ,p_hook_type => 'AP'
813: );
806: ,p_datetrack_mode => p_datetrack_mode
807: );
808: exception
809: when hr_api.cannot_find_prog_unit then
810: hr_api.cannot_find_prog_unit_error
811: (p_module_name => 'DELETE_Life_Event_Enroll_Rsn'
812: ,p_hook_type => 'AP'
813: );
814: --
820: --
821: -- When in validation only mode raise the Validate_Enabled exception
822: --
823: if p_validate then
824: raise hr_api.validate_enabled;
825: end if;
826: --
827: hr_utility.set_location(' Leaving:'||l_proc, 70);
828: --
827: hr_utility.set_location(' Leaving:'||l_proc, 70);
828: --
829: exception
830: --
831: when hr_api.validate_enabled then
832: --
833: -- As the Validate_Enabled exception has been raised
834: -- we must rollback to the savepoint
835: --