192: ,p_reinstate_ovrdn_cd => p_reinstate_ovrdn_cd
193: ,p_defer_deenrol_flag => p_defer_deenrol_flag
194: );
195: exception
196: when hr_api.cannot_find_prog_unit then
197: hr_api.cannot_find_prog_unit_error
198: (
199: p_module_name => 'CREATE_Enrollment_Period'
200: ,p_hook_type => 'BP'
193: ,p_defer_deenrol_flag => p_defer_deenrol_flag
194: );
195: exception
196: when hr_api.cannot_find_prog_unit then
197: hr_api.cannot_find_prog_unit_error
198: (
199: p_module_name => 'CREATE_Enrollment_Period'
200: ,p_hook_type => 'BP'
201: );
370: ,p_reinstate_ovrdn_cd => p_reinstate_ovrdn_cd
371: ,p_defer_deenrol_flag => p_defer_deenrol_flag
372: );
373: exception
374: when hr_api.cannot_find_prog_unit then
375: hr_api.cannot_find_prog_unit_error
376: (p_module_name => 'CREATE_Enrollment_Period'
377: ,p_hook_type => 'AP'
378: );
371: ,p_defer_deenrol_flag => p_defer_deenrol_flag
372: );
373: exception
374: when hr_api.cannot_find_prog_unit then
375: hr_api.cannot_find_prog_unit_error
376: (p_module_name => 'CREATE_Enrollment_Period'
377: ,p_hook_type => 'AP'
378: );
379: --
385: --
386: -- When in validation only mode raise the Validate_Enabled exception
387: --
388: if p_validate then
389: raise hr_api.validate_enabled;
390: end if;
391: --
392: -- Set all output arguments
393: --
397: hr_utility.set_location(' Leaving:'||l_proc, 70);
398: --
399: exception
400: --
401: when hr_api.validate_enabled then
402: --
403: -- As the Validate_Enabled exception has been raised
404: -- we must rollback to the savepoint
405: --
429: --
430: procedure update_Enrollment_Period
431: (p_validate in boolean default false
432: ,p_enrt_perd_id in number
433: ,p_business_group_id in number default hr_api.g_number
434: ,p_yr_perd_id in number default hr_api.g_number
435: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
436: ,p_end_dt in date default hr_api.g_date
437: ,p_strt_dt in date default hr_api.g_date
430: procedure update_Enrollment_Period
431: (p_validate in boolean default false
432: ,p_enrt_perd_id in number
433: ,p_business_group_id in number default hr_api.g_number
434: ,p_yr_perd_id in number default hr_api.g_number
435: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
436: ,p_end_dt in date default hr_api.g_date
437: ,p_strt_dt in date default hr_api.g_date
438: ,p_asnd_lf_evt_dt in date default hr_api.g_date
431: (p_validate in boolean default false
432: ,p_enrt_perd_id in number
433: ,p_business_group_id in number default hr_api.g_number
434: ,p_yr_perd_id in number default hr_api.g_number
435: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
436: ,p_end_dt in date default hr_api.g_date
437: ,p_strt_dt in date default hr_api.g_date
438: ,p_asnd_lf_evt_dt in date default hr_api.g_date
439: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
432: ,p_enrt_perd_id in number
433: ,p_business_group_id in number default hr_api.g_number
434: ,p_yr_perd_id in number default hr_api.g_number
435: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
436: ,p_end_dt in date default hr_api.g_date
437: ,p_strt_dt in date default hr_api.g_date
438: ,p_asnd_lf_evt_dt in date default hr_api.g_date
439: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
440: ,p_dflt_enrt_dt in date default hr_api.g_date
433: ,p_business_group_id in number default hr_api.g_number
434: ,p_yr_perd_id in number default hr_api.g_number
435: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
436: ,p_end_dt in date default hr_api.g_date
437: ,p_strt_dt in date default hr_api.g_date
438: ,p_asnd_lf_evt_dt in date default hr_api.g_date
439: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
440: ,p_dflt_enrt_dt in date default hr_api.g_date
441: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
434: ,p_yr_perd_id in number default hr_api.g_number
435: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
436: ,p_end_dt in date default hr_api.g_date
437: ,p_strt_dt in date default hr_api.g_date
438: ,p_asnd_lf_evt_dt in date default hr_api.g_date
439: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
440: ,p_dflt_enrt_dt in date default hr_api.g_date
441: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
442: ,p_rt_strt_dt_rl in number default hr_api.g_number
435: ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
436: ,p_end_dt in date default hr_api.g_date
437: ,p_strt_dt in date default hr_api.g_date
438: ,p_asnd_lf_evt_dt in date default hr_api.g_date
439: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
440: ,p_dflt_enrt_dt in date default hr_api.g_date
441: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
442: ,p_rt_strt_dt_rl in number default hr_api.g_number
443: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
436: ,p_end_dt in date default hr_api.g_date
437: ,p_strt_dt in date default hr_api.g_date
438: ,p_asnd_lf_evt_dt in date default hr_api.g_date
439: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
440: ,p_dflt_enrt_dt in date default hr_api.g_date
441: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
442: ,p_rt_strt_dt_rl in number default hr_api.g_number
443: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
444: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
437: ,p_strt_dt in date default hr_api.g_date
438: ,p_asnd_lf_evt_dt in date default hr_api.g_date
439: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
440: ,p_dflt_enrt_dt in date default hr_api.g_date
441: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
442: ,p_rt_strt_dt_rl in number default hr_api.g_number
443: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
444: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
445: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
438: ,p_asnd_lf_evt_dt in date default hr_api.g_date
439: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
440: ,p_dflt_enrt_dt in date default hr_api.g_date
441: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
442: ,p_rt_strt_dt_rl in number default hr_api.g_number
443: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
444: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
445: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
446: ,p_procg_end_dt in date default hr_api.g_date
439: ,p_cls_enrt_dt_to_use_cd in varchar2 default hr_api.g_varchar2
440: ,p_dflt_enrt_dt in date default hr_api.g_date
441: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
442: ,p_rt_strt_dt_rl in number default hr_api.g_number
443: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
444: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
445: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
446: ,p_procg_end_dt in date default hr_api.g_date
447: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
440: ,p_dflt_enrt_dt in date default hr_api.g_date
441: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
442: ,p_rt_strt_dt_rl in number default hr_api.g_number
443: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
444: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
445: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
446: ,p_procg_end_dt in date default hr_api.g_date
447: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
441: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
442: ,p_rt_strt_dt_rl in number default hr_api.g_number
443: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
444: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
445: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
446: ,p_procg_end_dt in date default hr_api.g_date
447: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
449: ,p_rt_end_dt_rl in number default hr_api.g_number
442: ,p_rt_strt_dt_rl in number default hr_api.g_number
443: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
444: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
445: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
446: ,p_procg_end_dt in date default hr_api.g_date
447: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
449: ,p_rt_end_dt_rl in number default hr_api.g_number
450: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
443: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
444: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
445: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
446: ,p_procg_end_dt in date default hr_api.g_date
447: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
449: ,p_rt_end_dt_rl in number default hr_api.g_number
450: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
451: ,p_bdgt_upd_end_dt in date default hr_api.g_date
444: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
445: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
446: ,p_procg_end_dt in date default hr_api.g_date
447: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
449: ,p_rt_end_dt_rl in number default hr_api.g_number
450: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
451: ,p_bdgt_upd_end_dt in date default hr_api.g_date
452: ,p_ws_upd_strt_dt in date default hr_api.g_date
445: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
446: ,p_procg_end_dt in date default hr_api.g_date
447: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
449: ,p_rt_end_dt_rl in number default hr_api.g_number
450: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
451: ,p_bdgt_upd_end_dt in date default hr_api.g_date
452: ,p_ws_upd_strt_dt in date default hr_api.g_date
453: ,p_ws_upd_end_dt in date default hr_api.g_date
446: ,p_procg_end_dt in date default hr_api.g_date
447: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
449: ,p_rt_end_dt_rl in number default hr_api.g_number
450: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
451: ,p_bdgt_upd_end_dt in date default hr_api.g_date
452: ,p_ws_upd_strt_dt in date default hr_api.g_date
453: ,p_ws_upd_end_dt in date default hr_api.g_date
454: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
447: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
448: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
449: ,p_rt_end_dt_rl in number default hr_api.g_number
450: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
451: ,p_bdgt_upd_end_dt in date default hr_api.g_date
452: ,p_ws_upd_strt_dt in date default hr_api.g_date
453: ,p_ws_upd_end_dt in date default hr_api.g_date
454: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
455: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
448: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
449: ,p_rt_end_dt_rl in number default hr_api.g_number
450: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
451: ,p_bdgt_upd_end_dt in date default hr_api.g_date
452: ,p_ws_upd_strt_dt in date default hr_api.g_date
453: ,p_ws_upd_end_dt in date default hr_api.g_date
454: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
455: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
456: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
449: ,p_rt_end_dt_rl in number default hr_api.g_number
450: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
451: ,p_bdgt_upd_end_dt in date default hr_api.g_date
452: ,p_ws_upd_strt_dt in date default hr_api.g_date
453: ,p_ws_upd_end_dt in date default hr_api.g_date
454: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
455: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
456: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
457: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
450: ,p_bdgt_upd_strt_dt in date default hr_api.g_date
451: ,p_bdgt_upd_end_dt in date default hr_api.g_date
452: ,p_ws_upd_strt_dt in date default hr_api.g_date
453: ,p_ws_upd_end_dt in date default hr_api.g_date
454: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
455: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
456: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
457: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
458: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
451: ,p_bdgt_upd_end_dt in date default hr_api.g_date
452: ,p_ws_upd_strt_dt in date default hr_api.g_date
453: ,p_ws_upd_end_dt in date default hr_api.g_date
454: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
455: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
456: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
457: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
458: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
459: ,p_pos_structure_version_id in number default hr_api.g_number
452: ,p_ws_upd_strt_dt in date default hr_api.g_date
453: ,p_ws_upd_end_dt in date default hr_api.g_date
454: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
455: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
456: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
457: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
458: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
459: ,p_pos_structure_version_id in number default hr_api.g_number
460: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
453: ,p_ws_upd_end_dt in date default hr_api.g_date
454: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
455: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
456: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
457: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
458: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
459: ,p_pos_structure_version_id in number default hr_api.g_number
460: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
461: ,p_wthn_yr_perd_id in number default hr_api.g_number
454: ,p_dflt_ws_acc_cd in varchar2 default hr_api.g_varchar2
455: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
456: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
457: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
458: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
459: ,p_pos_structure_version_id in number default hr_api.g_number
460: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
461: ,p_wthn_yr_perd_id in number default hr_api.g_number
462: ,p_ler_id in number default hr_api.g_number
455: ,p_prsvr_bdgt_cd in varchar2 default hr_api.g_varchar2
456: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
457: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
458: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
459: ,p_pos_structure_version_id in number default hr_api.g_number
460: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
461: ,p_wthn_yr_perd_id in number default hr_api.g_number
462: ,p_ler_id in number default hr_api.g_number
463: ,p_perf_revw_strt_dt in date default hr_api.g_date
456: ,p_uses_bdgt_flag in varchar2 default hr_api.g_varchar2
457: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
458: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
459: ,p_pos_structure_version_id in number default hr_api.g_number
460: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
461: ,p_wthn_yr_perd_id in number default hr_api.g_number
462: ,p_ler_id in number default hr_api.g_number
463: ,p_perf_revw_strt_dt in date default hr_api.g_date
464: ,p_asg_updt_eff_date in date default hr_api.g_date
457: ,p_auto_distr_flag in varchar2 default hr_api.g_varchar2
458: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
459: ,p_pos_structure_version_id in number default hr_api.g_number
460: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
461: ,p_wthn_yr_perd_id in number default hr_api.g_number
462: ,p_ler_id in number default hr_api.g_number
463: ,p_perf_revw_strt_dt in date default hr_api.g_date
464: ,p_asg_updt_eff_date in date default hr_api.g_date
465: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
458: ,p_hrchy_to_use_cd in varchar2 default hr_api.g_varchar2
459: ,p_pos_structure_version_id in number default hr_api.g_number
460: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
461: ,p_wthn_yr_perd_id in number default hr_api.g_number
462: ,p_ler_id in number default hr_api.g_number
463: ,p_perf_revw_strt_dt in date default hr_api.g_date
464: ,p_asg_updt_eff_date in date default hr_api.g_date
465: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
466: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
459: ,p_pos_structure_version_id in number default hr_api.g_number
460: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
461: ,p_wthn_yr_perd_id in number default hr_api.g_number
462: ,p_ler_id in number default hr_api.g_number
463: ,p_perf_revw_strt_dt in date default hr_api.g_date
464: ,p_asg_updt_eff_date in date default hr_api.g_date
465: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
466: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
467: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
460: ,p_emp_interview_type_cd in varchar2 default hr_api.g_varchar2
461: ,p_wthn_yr_perd_id in number default hr_api.g_number
462: ,p_ler_id in number default hr_api.g_number
463: ,p_perf_revw_strt_dt in date default hr_api.g_date
464: ,p_asg_updt_eff_date in date default hr_api.g_date
465: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
466: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
467: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
468: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
461: ,p_wthn_yr_perd_id in number default hr_api.g_number
462: ,p_ler_id in number default hr_api.g_number
463: ,p_perf_revw_strt_dt in date default hr_api.g_date
464: ,p_asg_updt_eff_date in date default hr_api.g_date
465: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
466: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
467: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
468: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
469: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
462: ,p_ler_id in number default hr_api.g_number
463: ,p_perf_revw_strt_dt in date default hr_api.g_date
464: ,p_asg_updt_eff_date in date default hr_api.g_date
465: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
466: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
467: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
468: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
469: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
463: ,p_perf_revw_strt_dt in date default hr_api.g_date
464: ,p_asg_updt_eff_date in date default hr_api.g_date
465: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
466: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
467: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
468: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
469: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
464: ,p_asg_updt_eff_date in date default hr_api.g_date
465: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
466: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
467: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
468: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
469: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
465: ,p_enp_attribute_category in varchar2 default hr_api.g_varchar2
466: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
467: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
468: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
469: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
466: ,p_enp_attribute1 in varchar2 default hr_api.g_varchar2
467: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
468: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
469: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
467: ,p_enp_attribute2 in varchar2 default hr_api.g_varchar2
468: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
469: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
468: ,p_enp_attribute3 in varchar2 default hr_api.g_varchar2
469: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
469: ,p_enp_attribute4 in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
470: ,p_enp_attribute5 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
471: ,p_enp_attribute6 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
472: ,p_enp_attribute7 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
473: ,p_enp_attribute8 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
474: ,p_enp_attribute9 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
475: ,p_enp_attribute10 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
476: ,p_enp_attribute11 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
477: ,p_enp_attribute12 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
478: ,p_enp_attribute13 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
479: ,p_enp_attribute14 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
480: ,p_enp_attribute15 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
481: ,p_enp_attribute16 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
482: ,p_enp_attribute17 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
483: ,p_enp_attribute18 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
484: ,p_enp_attribute19 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
485: ,p_enp_attribute20 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
486: ,p_enp_attribute21 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
487: ,p_enp_attribute22 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
488: ,p_enp_attribute23 in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
496: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
489: ,p_enp_attribute24 in varchar2 default hr_api.g_varchar2
490: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
496: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
497: --cwb
490: ,p_enp_attribute25 in varchar2 default hr_api.g_varchar2
491: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
496: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
497: --cwb
498: ,p_data_freeze_date in date default hr_api.g_date
491: ,p_enp_attribute26 in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
496: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
497: --cwb
498: ,p_data_freeze_date in date default hr_api.g_date
499: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
492: ,p_enp_attribute27 in varchar2 default hr_api.g_varchar2
493: ,p_enp_attribute28 in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
496: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
497: --cwb
498: ,p_data_freeze_date in date default hr_api.g_date
499: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
500: ,p_Approval_mode_cd in varchar2 default hr_api.g_varchar2
494: ,p_enp_attribute29 in varchar2 default hr_api.g_varchar2
495: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
496: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
497: --cwb
498: ,p_data_freeze_date in date default hr_api.g_date
499: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
500: ,p_Approval_mode_cd in varchar2 default hr_api.g_varchar2
501: ,p_hrchy_ame_trn_cd in varchar2 default hr_api.g_varchar2
502: ,p_hrchy_rl in number default hr_api.g_number
495: ,p_enp_attribute30 in varchar2 default hr_api.g_varchar2
496: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
497: --cwb
498: ,p_data_freeze_date in date default hr_api.g_date
499: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
500: ,p_Approval_mode_cd in varchar2 default hr_api.g_varchar2
501: ,p_hrchy_ame_trn_cd in varchar2 default hr_api.g_varchar2
502: ,p_hrchy_rl in number default hr_api.g_number
503: ,p_hrchy_ame_app_id in number default hr_api.g_number
496: ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2 default hr_api.g_varchar2
497: --cwb
498: ,p_data_freeze_date in date default hr_api.g_date
499: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
500: ,p_Approval_mode_cd in varchar2 default hr_api.g_varchar2
501: ,p_hrchy_ame_trn_cd in varchar2 default hr_api.g_varchar2
502: ,p_hrchy_rl in number default hr_api.g_number
503: ,p_hrchy_ame_app_id in number default hr_api.g_number
504: --
497: --cwb
498: ,p_data_freeze_date in date default hr_api.g_date
499: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
500: ,p_Approval_mode_cd in varchar2 default hr_api.g_varchar2
501: ,p_hrchy_ame_trn_cd in varchar2 default hr_api.g_varchar2
502: ,p_hrchy_rl in number default hr_api.g_number
503: ,p_hrchy_ame_app_id in number default hr_api.g_number
504: --
505: ,p_object_version_number in out nocopy number
498: ,p_data_freeze_date in date default hr_api.g_date
499: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
500: ,p_Approval_mode_cd in varchar2 default hr_api.g_varchar2
501: ,p_hrchy_ame_trn_cd in varchar2 default hr_api.g_varchar2
502: ,p_hrchy_rl in number default hr_api.g_number
503: ,p_hrchy_ame_app_id in number default hr_api.g_number
504: --
505: ,p_object_version_number in out nocopy number
506: ,p_effective_date in date
499: ,p_Sal_chg_reason_cd in varchar2 default hr_api.g_varchar2
500: ,p_Approval_mode_cd in varchar2 default hr_api.g_varchar2
501: ,p_hrchy_ame_trn_cd in varchar2 default hr_api.g_varchar2
502: ,p_hrchy_rl in number default hr_api.g_number
503: ,p_hrchy_ame_app_id in number default hr_api.g_number
504: --
505: ,p_object_version_number in out nocopy number
506: ,p_effective_date in date
507: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
503: ,p_hrchy_ame_app_id in number default hr_api.g_number
504: --
505: ,p_object_version_number in out nocopy number
506: ,p_effective_date in date
507: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
508: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
509: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
510: ) is
511: --
504: --
505: ,p_object_version_number in out nocopy number
506: ,p_effective_date in date
507: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
508: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
509: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
510: ) is
511: --
512: -- Declare cursors and local variables
505: ,p_object_version_number in out nocopy number
506: ,p_effective_date in date
507: ,p_reinstate_cd in varchar2 default hr_api.g_varchar2
508: ,p_reinstate_ovrdn_cd in varchar2 default hr_api.g_varchar2
509: ,p_defer_deenrol_flag in varchar2 default hr_api.g_varchar2
510: ) is
511: --
512: -- Declare cursors and local variables
513: --
613: ,p_reinstate_ovrdn_cd => p_reinstate_ovrdn_cd
614: ,p_defer_deenrol_flag => p_defer_deenrol_flag
615: );
616: exception
617: when hr_api.cannot_find_prog_unit then
618: hr_api.cannot_find_prog_unit_error
619: (p_module_name => 'UPDATE_Enrollment_Period'
620: ,p_hook_type => 'BP'
621: );
614: ,p_defer_deenrol_flag => p_defer_deenrol_flag
615: );
616: exception
617: when hr_api.cannot_find_prog_unit then
618: hr_api.cannot_find_prog_unit_error
619: (p_module_name => 'UPDATE_Enrollment_Period'
620: ,p_hook_type => 'BP'
621: );
622: --
791: ,p_reinstate_ovrdn_cd => p_reinstate_ovrdn_cd
792: ,p_defer_deenrol_flag => p_defer_deenrol_flag
793: );
794: exception
795: when hr_api.cannot_find_prog_unit then
796: hr_api.cannot_find_prog_unit_error
797: (p_module_name => 'UPDATE_Enrollment_Period'
798: ,p_hook_type => 'AP'
799: );
792: ,p_defer_deenrol_flag => p_defer_deenrol_flag
793: );
794: exception
795: when hr_api.cannot_find_prog_unit then
796: hr_api.cannot_find_prog_unit_error
797: (p_module_name => 'UPDATE_Enrollment_Period'
798: ,p_hook_type => 'AP'
799: );
800: --
806: --
807: -- When in validation only mode raise the Validate_Enabled exception
808: --
809: if p_validate then
810: raise hr_api.validate_enabled;
811: end if;
812: --
813: -- Set all output arguments
814: --
817: hr_utility.set_location(' Leaving:'||l_proc, 70);
818: --
819: exception
820: --
821: when hr_api.validate_enabled then
822: --
823: -- As the Validate_Enabled exception has been raised
824: -- we must rollback to the savepoint
825: --
880: ,p_object_version_number => p_object_version_number
881: ,p_effective_date => trunc(p_effective_date)
882: );
883: exception
884: when hr_api.cannot_find_prog_unit then
885: hr_api.cannot_find_prog_unit_error
886: (p_module_name => 'DELETE_Enrollment_Period'
887: ,p_hook_type => 'BP'
888: );
881: ,p_effective_date => trunc(p_effective_date)
882: );
883: exception
884: when hr_api.cannot_find_prog_unit then
885: hr_api.cannot_find_prog_unit_error
886: (p_module_name => 'DELETE_Enrollment_Period'
887: ,p_hook_type => 'BP'
888: );
889: --
908: ,p_object_version_number => l_object_version_number
909: ,p_effective_date => trunc(p_effective_date)
910: );
911: exception
912: when hr_api.cannot_find_prog_unit then
913: hr_api.cannot_find_prog_unit_error
914: (p_module_name => 'DELETE_Enrollment_Period'
915: ,p_hook_type => 'AP'
916: );
909: ,p_effective_date => trunc(p_effective_date)
910: );
911: exception
912: when hr_api.cannot_find_prog_unit then
913: hr_api.cannot_find_prog_unit_error
914: (p_module_name => 'DELETE_Enrollment_Period'
915: ,p_hook_type => 'AP'
916: );
917: --
923: --
924: -- When in validation only mode raise the Validate_Enabled exception
925: --
926: if p_validate then
927: raise hr_api.validate_enabled;
928: end if;
929: --
930: hr_utility.set_location(' Leaving:'||l_proc, 70);
931: --
930: hr_utility.set_location(' Leaving:'||l_proc, 70);
931: --
932: exception
933: --
934: when hr_api.validate_enabled then
935: --
936: -- As the Validate_Enabled exception has been raised
937: -- we must rollback to the savepoint
938: --