194: ,p_reopen_le_on_reprocess => p_reopen_le_on_reprocess
195: ,p_defer_deenrol_flag => p_defer_deenrol_flag
196: );
197: exception
198: when hr_api.cannot_find_prog_unit then
199: hr_api.cannot_find_prog_unit_error
200: (
201: p_module_name => 'CREATE_Enrollment_Period'
202: ,p_hook_type => 'BP'
195: ,p_defer_deenrol_flag => p_defer_deenrol_flag
196: );
197: exception
198: when hr_api.cannot_find_prog_unit then
199: hr_api.cannot_find_prog_unit_error
200: (
201: p_module_name => 'CREATE_Enrollment_Period'
202: ,p_hook_type => 'BP'
203: );
374: ,p_reopen_le_on_reprocess => p_reopen_le_on_reprocess
375: ,p_defer_deenrol_flag => p_defer_deenrol_flag
376: );
377: exception
378: when hr_api.cannot_find_prog_unit then
379: hr_api.cannot_find_prog_unit_error
380: (p_module_name => 'CREATE_Enrollment_Period'
381: ,p_hook_type => 'AP'
382: );
375: ,p_defer_deenrol_flag => p_defer_deenrol_flag
376: );
377: exception
378: when hr_api.cannot_find_prog_unit then
379: hr_api.cannot_find_prog_unit_error
380: (p_module_name => 'CREATE_Enrollment_Period'
381: ,p_hook_type => 'AP'
382: );
383: --
389: --
390: -- When in validation only mode raise the Validate_Enabled exception
391: --
392: if p_validate then
393: raise hr_api.validate_enabled;
394: end if;
395: --
396: -- Set all output arguments
397: --
401: hr_utility.set_location(' Leaving:'||l_proc, 70);
402: --
403: exception
404: --
405: when hr_api.validate_enabled then
406: --
407: -- As the Validate_Enabled exception has been raised
408: -- we must rollback to the savepoint
409: --
433: --
434: procedure update_Enrollment_Period
435: (p_validate in boolean default false
436: ,p_enrt_perd_id in number
437: ,p_business_group_id in number default hr_api.g_number
438: ,p_yr_perd_id in number default hr_api.g_number
439: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
440: ,p_end_dt in date default hr_api.g_date
441: ,p_strt_dt in date default hr_api.g_date
434: procedure update_Enrollment_Period
435: (p_validate in boolean default false
436: ,p_enrt_perd_id in number
437: ,p_business_group_id in number default hr_api.g_number
438: ,p_yr_perd_id in number default hr_api.g_number
439: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
440: ,p_end_dt in date default hr_api.g_date
441: ,p_strt_dt in date default hr_api.g_date
442: ,p_asnd_lf_evt_dt in date default hr_api.g_date
435: (p_validate in boolean default false
436: ,p_enrt_perd_id in number
437: ,p_business_group_id in number default hr_api.g_number
438: ,p_yr_perd_id in number default hr_api.g_number
439: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
440: ,p_end_dt in date default hr_api.g_date
441: ,p_strt_dt in date default hr_api.g_date
442: ,p_asnd_lf_evt_dt in date default hr_api.g_date
443: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
436: ,p_enrt_perd_id in number
437: ,p_business_group_id in number default hr_api.g_number
438: ,p_yr_perd_id in number default hr_api.g_number
439: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
440: ,p_end_dt in date default hr_api.g_date
441: ,p_strt_dt in date default hr_api.g_date
442: ,p_asnd_lf_evt_dt in date default hr_api.g_date
443: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
444: ,p_dflt_enrt_dt in date default hr_api.g_date
437: ,p_business_group_id in number default hr_api.g_number
438: ,p_yr_perd_id in number default hr_api.g_number
439: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
440: ,p_end_dt in date default hr_api.g_date
441: ,p_strt_dt in date default hr_api.g_date
442: ,p_asnd_lf_evt_dt in date default hr_api.g_date
443: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
444: ,p_dflt_enrt_dt in date default hr_api.g_date
445: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
438: ,p_yr_perd_id in number default hr_api.g_number
439: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
440: ,p_end_dt in date default hr_api.g_date
441: ,p_strt_dt in date default hr_api.g_date
442: ,p_asnd_lf_evt_dt in date default hr_api.g_date
443: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
444: ,p_dflt_enrt_dt in date default hr_api.g_date
445: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
446: ,p_rt_strt_dt_rl in number default hr_api.g_number
439: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
440: ,p_end_dt in date default hr_api.g_date
441: ,p_strt_dt in date default hr_api.g_date
442: ,p_asnd_lf_evt_dt in date default hr_api.g_date
443: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
444: ,p_dflt_enrt_dt in date default hr_api.g_date
445: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
446: ,p_rt_strt_dt_rl in number default hr_api.g_number
447: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
440: ,p_end_dt in date default hr_api.g_date
441: ,p_strt_dt in date default hr_api.g_date
442: ,p_asnd_lf_evt_dt in date default hr_api.g_date
443: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
444: ,p_dflt_enrt_dt in date default hr_api.g_date
445: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
446: ,p_rt_strt_dt_rl in number default hr_api.g_number
447: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
441: ,p_strt_dt in date default hr_api.g_date
442: ,p_asnd_lf_evt_dt in date default hr_api.g_date
443: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
444: ,p_dflt_enrt_dt in date default hr_api.g_date
445: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
446: ,p_rt_strt_dt_rl in number default hr_api.g_number
447: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
449: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
442: ,p_asnd_lf_evt_dt in date default hr_api.g_date
443: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
444: ,p_dflt_enrt_dt in date default hr_api.g_date
445: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
446: ,p_rt_strt_dt_rl in number default hr_api.g_number
447: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
449: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
450: ,p_procg_end_dt in date default hr_api.g_date
443: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
444: ,p_dflt_enrt_dt in date default hr_api.g_date
445: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
446: ,p_rt_strt_dt_rl in number default hr_api.g_number
447: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
449: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
450: ,p_procg_end_dt in date default hr_api.g_date
451: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
444: ,p_dflt_enrt_dt in date default hr_api.g_date
445: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
446: ,p_rt_strt_dt_rl in number default hr_api.g_number
447: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
449: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
450: ,p_procg_end_dt in date default hr_api.g_date
451: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
452: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
445: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
446: ,p_rt_strt_dt_rl in number default hr_api.g_number
447: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
449: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
450: ,p_procg_end_dt in date default hr_api.g_date
451: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
452: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
453: ,p_rt_end_dt_rl in number default hr_api.g_number
446: ,p_rt_strt_dt_rl in number default hr_api.g_number
447: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
449: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
450: ,p_procg_end_dt in date default hr_api.g_date
451: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
452: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
453: ,p_rt_end_dt_rl in number default hr_api.g_number
454: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
447: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
449: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
450: ,p_procg_end_dt in date default hr_api.g_date
451: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
452: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
453: ,p_rt_end_dt_rl in number default hr_api.g_number
454: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
455: ,p_bdgt_upd_end_dt in date default hr_api.g_date
448: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
449: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
450: ,p_procg_end_dt in date default hr_api.g_date
451: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
452: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
453: ,p_rt_end_dt_rl in number default hr_api.g_number
454: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
455: ,p_bdgt_upd_end_dt in date default hr_api.g_date
456: ,p_ws_upd_strt_dt in date default hr_api.g_date
449: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
450: ,p_procg_end_dt in date default hr_api.g_date
451: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
452: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
453: ,p_rt_end_dt_rl in number default hr_api.g_number
454: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
455: ,p_bdgt_upd_end_dt in date default hr_api.g_date
456: ,p_ws_upd_strt_dt in date default hr_api.g_date
457: ,p_ws_upd_end_dt in date default hr_api.g_date
450: ,p_procg_end_dt in date default hr_api.g_date
451: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
452: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
453: ,p_rt_end_dt_rl in number default hr_api.g_number
454: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
455: ,p_bdgt_upd_end_dt in date default hr_api.g_date
456: ,p_ws_upd_strt_dt in date default hr_api.g_date
457: ,p_ws_upd_end_dt in date default hr_api.g_date
458: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
451: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
452: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
453: ,p_rt_end_dt_rl in number default hr_api.g_number
454: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
455: ,p_bdgt_upd_end_dt in date default hr_api.g_date
456: ,p_ws_upd_strt_dt in date default hr_api.g_date
457: ,p_ws_upd_end_dt in date default hr_api.g_date
458: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
459: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
452: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
453: ,p_rt_end_dt_rl in number default hr_api.g_number
454: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
455: ,p_bdgt_upd_end_dt in date default hr_api.g_date
456: ,p_ws_upd_strt_dt in date default hr_api.g_date
457: ,p_ws_upd_end_dt in date default hr_api.g_date
458: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
459: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
460: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
453: ,p_rt_end_dt_rl in number default hr_api.g_number
454: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
455: ,p_bdgt_upd_end_dt in date default hr_api.g_date
456: ,p_ws_upd_strt_dt in date default hr_api.g_date
457: ,p_ws_upd_end_dt in date default hr_api.g_date
458: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
459: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
460: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
461: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
454: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
455: ,p_bdgt_upd_end_dt in date default hr_api.g_date
456: ,p_ws_upd_strt_dt in date default hr_api.g_date
457: ,p_ws_upd_end_dt in date default hr_api.g_date
458: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
459: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
460: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
461: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
462: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
455: ,p_bdgt_upd_end_dt in date default hr_api.g_date
456: ,p_ws_upd_strt_dt in date default hr_api.g_date
457: ,p_ws_upd_end_dt in date default hr_api.g_date
458: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
459: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
460: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
461: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
462: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
463: ,p_pos_structure_version_id in number default hr_api.g_number
456: ,p_ws_upd_strt_dt in date default hr_api.g_date
457: ,p_ws_upd_end_dt in date default hr_api.g_date
458: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
459: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
460: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
461: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
462: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
463: ,p_pos_structure_version_id in number default hr_api.g_number
464: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
457: ,p_ws_upd_end_dt in date default hr_api.g_date
458: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
459: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
460: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
461: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
462: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
463: ,p_pos_structure_version_id in number default hr_api.g_number
464: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
465: ,p_wthn_yr_perd_id in number default hr_api.g_number
458: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
459: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
460: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
461: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
462: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
463: ,p_pos_structure_version_id in number default hr_api.g_number
464: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
465: ,p_wthn_yr_perd_id in number default hr_api.g_number
466: ,p_ler_id in number default hr_api.g_number
459: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
460: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
461: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
462: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
463: ,p_pos_structure_version_id in number default hr_api.g_number
464: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
465: ,p_wthn_yr_perd_id in number default hr_api.g_number
466: ,p_ler_id in number default hr_api.g_number
467: ,p_perf_revw_strt_dt in date default hr_api.g_date
460: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
461: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
462: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
463: ,p_pos_structure_version_id in number default hr_api.g_number
464: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
465: ,p_wthn_yr_perd_id in number default hr_api.g_number
466: ,p_ler_id in number default hr_api.g_number
467: ,p_perf_revw_strt_dt in date default hr_api.g_date
468: ,p_asg_updt_eff_date in date default hr_api.g_date
461: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
462: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
463: ,p_pos_structure_version_id in number default hr_api.g_number
464: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
465: ,p_wthn_yr_perd_id in number default hr_api.g_number
466: ,p_ler_id in number default hr_api.g_number
467: ,p_perf_revw_strt_dt in date default hr_api.g_date
468: ,p_asg_updt_eff_date in date default hr_api.g_date
469: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
462: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
463: ,p_pos_structure_version_id in number default hr_api.g_number
464: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
465: ,p_wthn_yr_perd_id in number default hr_api.g_number
466: ,p_ler_id in number default hr_api.g_number
467: ,p_perf_revw_strt_dt in date default hr_api.g_date
468: ,p_asg_updt_eff_date in date default hr_api.g_date
469: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
463: ,p_pos_structure_version_id in number default hr_api.g_number
464: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
465: ,p_wthn_yr_perd_id in number default hr_api.g_number
466: ,p_ler_id in number default hr_api.g_number
467: ,p_perf_revw_strt_dt in date default hr_api.g_date
468: ,p_asg_updt_eff_date in date default hr_api.g_date
469: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
464: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
465: ,p_wthn_yr_perd_id in number default hr_api.g_number
466: ,p_ler_id in number default hr_api.g_number
467: ,p_perf_revw_strt_dt in date default hr_api.g_date
468: ,p_asg_updt_eff_date in date default hr_api.g_date
469: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
465: ,p_wthn_yr_perd_id in number default hr_api.g_number
466: ,p_ler_id in number default hr_api.g_number
467: ,p_perf_revw_strt_dt in date default hr_api.g_date
468: ,p_asg_updt_eff_date in date default hr_api.g_date
469: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
466: ,p_ler_id in number default hr_api.g_number
467: ,p_perf_revw_strt_dt in date default hr_api.g_date
468: ,p_asg_updt_eff_date in date default hr_api.g_date
469: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
467: ,p_perf_revw_strt_dt in date default hr_api.g_date
468: ,p_asg_updt_eff_date in date default hr_api.g_date
469: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
468: ,p_asg_updt_eff_date in date default hr_api.g_date
469: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
469: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
496: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
496: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
497: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
496: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
497: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
498: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
496: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
497: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
498: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
499: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
496: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
497: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
498: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
499: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
500: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
496: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
497: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
498: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
499: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
500: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
501: --cwb
494: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
496: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
497: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
498: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
499: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
500: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
501: --cwb
502: ,p_data_freeze_date in date default hr_api.g_date
495: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
496: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
497: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
498: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
499: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
500: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
501: --cwb
502: ,p_data_freeze_date in date default hr_api.g_date
503: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
496: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
497: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
498: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
499: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
500: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
501: --cwb
502: ,p_data_freeze_date in date default hr_api.g_date
503: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
504: ,p_Approval_mode_cd in varchar2 default hr_api.g_varchar2
498: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
499: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
500: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
501: --cwb
502: ,p_data_freeze_date in date default hr_api.g_date
503: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
504: ,p_Approval_mode_cd in varchar2 default hr_api.g_varchar2
505: ,p_hrchy_ame_trn_cd in varchar2 default hr_api.g_varchar2
506: ,p_hrchy_rl in number default hr_api.g_number
499: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
500: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
501: --cwb
502: ,p_data_freeze_date in date default hr_api.g_date
503: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
504: ,p_Approval_mode_cd in varchar2 default hr_api.g_varchar2
505: ,p_hrchy_ame_trn_cd in varchar2 default hr_api.g_varchar2
506: ,p_hrchy_rl in number default hr_api.g_number
507: ,p_hrchy_ame_app_id in number default hr_api.g_number
500: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
501: --cwb
502: ,p_data_freeze_date in date default hr_api.g_date
503: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
504: ,p_Approval_mode_cd in varchar2 default hr_api.g_varchar2
505: ,p_hrchy_ame_trn_cd in varchar2 default hr_api.g_varchar2
506: ,p_hrchy_rl in number default hr_api.g_number
507: ,p_hrchy_ame_app_id in number default hr_api.g_number
508: --
501: --cwb
502: ,p_data_freeze_date in date default hr_api.g_date
503: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
504: ,p_Approval_mode_cd in varchar2 default hr_api.g_varchar2
505: ,p_hrchy_ame_trn_cd in varchar2 default hr_api.g_varchar2
506: ,p_hrchy_rl in number default hr_api.g_number
507: ,p_hrchy_ame_app_id in number default hr_api.g_number
508: --
509: ,p_object_version_number in out nocopy number
502: ,p_data_freeze_date in date default hr_api.g_date
503: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
504: ,p_Approval_mode_cd in varchar2 default hr_api.g_varchar2
505: ,p_hrchy_ame_trn_cd in varchar2 default hr_api.g_varchar2
506: ,p_hrchy_rl in number default hr_api.g_number
507: ,p_hrchy_ame_app_id in number default hr_api.g_number
508: --
509: ,p_object_version_number in out nocopy number
510: ,p_effective_date in date
503: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
504: ,p_Approval_mode_cd in varchar2 default hr_api.g_varchar2
505: ,p_hrchy_ame_trn_cd in varchar2 default hr_api.g_varchar2
506: ,p_hrchy_rl in number default hr_api.g_number
507: ,p_hrchy_ame_app_id in number default hr_api.g_number
508: --
509: ,p_object_version_number in out nocopy number
510: ,p_effective_date in date
511: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
507: ,p_hrchy_ame_app_id in number default hr_api.g_number
508: --
509: ,p_object_version_number in out nocopy number
510: ,p_effective_date in date
511: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
512: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
513: ,p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2
514: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
515: ) is
508: --
509: ,p_object_version_number in out nocopy number
510: ,p_effective_date in date
511: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
512: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
513: ,p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2
514: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
515: ) is
516: --
509: ,p_object_version_number in out nocopy number
510: ,p_effective_date in date
511: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
512: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
513: ,p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2
514: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
515: ) is
516: --
517: -- Declare cursors and local variables
510: ,p_effective_date in date
511: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
512: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
513: ,p_reopen_le_on_reprocess in varchar2 default hr_api.g_varchar2
514: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
515: ) is
516: --
517: -- Declare cursors and local variables
518: --
619: ,p_reopen_le_on_reprocess => p_reopen_le_on_reprocess
620: ,p_defer_deenrol_flag => p_defer_deenrol_flag
621: );
622: exception
623: when hr_api.cannot_find_prog_unit then
624: hr_api.cannot_find_prog_unit_error
625: (p_module_name => 'UPDATE_Enrollment_Period'
626: ,p_hook_type => 'BP'
627: );
620: ,p_defer_deenrol_flag => p_defer_deenrol_flag
621: );
622: exception
623: when hr_api.cannot_find_prog_unit then
624: hr_api.cannot_find_prog_unit_error
625: (p_module_name => 'UPDATE_Enrollment_Period'
626: ,p_hook_type => 'BP'
627: );
628: --
799: ,p_reopen_le_on_reprocess => p_reopen_le_on_reprocess
800: ,p_defer_deenrol_flag => p_defer_deenrol_flag
801: );
802: exception
803: when hr_api.cannot_find_prog_unit then
804: hr_api.cannot_find_prog_unit_error
805: (p_module_name => 'UPDATE_Enrollment_Period'
806: ,p_hook_type => 'AP'
807: );
800: ,p_defer_deenrol_flag => p_defer_deenrol_flag
801: );
802: exception
803: when hr_api.cannot_find_prog_unit then
804: hr_api.cannot_find_prog_unit_error
805: (p_module_name => 'UPDATE_Enrollment_Period'
806: ,p_hook_type => 'AP'
807: );
808: --
814: --
815: -- When in validation only mode raise the Validate_Enabled exception
816: --
817: if p_validate then
818: raise hr_api.validate_enabled;
819: end if;
820: --
821: -- Set all output arguments
822: --
825: hr_utility.set_location(' Leaving:'||l_proc, 70);
826: --
827: exception
828: --
829: when hr_api.validate_enabled then
830: --
831: -- As the Validate_Enabled exception has been raised
832: -- we must rollback to the savepoint
833: --
888: ,p_object_version_number => p_object_version_number
889: ,p_effective_date => trunc(p_effective_date)
890: );
891: exception
892: when hr_api.cannot_find_prog_unit then
893: hr_api.cannot_find_prog_unit_error
894: (p_module_name => 'DELETE_Enrollment_Period'
895: ,p_hook_type => 'BP'
896: );
889: ,p_effective_date => trunc(p_effective_date)
890: );
891: exception
892: when hr_api.cannot_find_prog_unit then
893: hr_api.cannot_find_prog_unit_error
894: (p_module_name => 'DELETE_Enrollment_Period'
895: ,p_hook_type => 'BP'
896: );
897: --
916: ,p_object_version_number => l_object_version_number
917: ,p_effective_date => trunc(p_effective_date)
918: );
919: exception
920: when hr_api.cannot_find_prog_unit then
921: hr_api.cannot_find_prog_unit_error
922: (p_module_name => 'DELETE_Enrollment_Period'
923: ,p_hook_type => 'AP'
924: );
917: ,p_effective_date => trunc(p_effective_date)
918: );
919: exception
920: when hr_api.cannot_find_prog_unit then
921: hr_api.cannot_find_prog_unit_error
922: (p_module_name => 'DELETE_Enrollment_Period'
923: ,p_hook_type => 'AP'
924: );
925: --
931: --
932: -- When in validation only mode raise the Validate_Enabled exception
933: --
934: if p_validate then
935: raise hr_api.validate_enabled;
936: end if;
937: --
938: hr_utility.set_location(' Leaving:'||l_proc, 70);
939: --
938: hr_utility.set_location(' Leaving:'||l_proc, 70);
939: --
940: exception
941: --
942: when hr_api.validate_enabled then
943: --
944: -- As the Validate_Enabled exception has been raised
945: -- we must rollback to the savepoint
946: --