274: ,p_bnft_or_option_rstrctn_cd => p_bnft_or_option_rstrctn_cd
275: ,p_effective_date => trunc(p_effective_date)
276: );
277: exception
278: when hr_api.cannot_find_prog_unit then
279: hr_api.cannot_find_prog_unit_error
280: (
281: p_module_name => 'CREATE_Plan_in_Program'
282: ,p_hook_type => 'BP'
275: ,p_effective_date => trunc(p_effective_date)
276: );
277: exception
278: when hr_api.cannot_find_prog_unit then
279: hr_api.cannot_find_prog_unit_error
280: (
281: p_module_name => 'CREATE_Plan_in_Program'
282: ,p_hook_type => 'BP'
283: );
487: ,p_bnft_or_option_rstrctn_cd => p_bnft_or_option_rstrctn_cd
488: ,p_effective_date => trunc(p_effective_date)
489: );
490: exception
491: when hr_api.cannot_find_prog_unit then
492: hr_api.cannot_find_prog_unit_error
493: (p_module_name => 'CREATE_Plan_in_Program'
494: ,p_hook_type => 'AP'
495: );
488: ,p_effective_date => trunc(p_effective_date)
489: );
490: exception
491: when hr_api.cannot_find_prog_unit then
492: hr_api.cannot_find_prog_unit_error
493: (p_module_name => 'CREATE_Plan_in_Program'
494: ,p_hook_type => 'AP'
495: );
496: --
542: -- When in validation only mode raise the Validate_Enabled exception
543: --
544:
545: if p_validate then
546: raise hr_api.validate_enabled;
547: end if;
548: --
549: -- Set all output arguments
550: --
556: hr_utility.set_location(' Leaving:'||l_proc, 70);
557: --
558: exception
559: --
560: when hr_api.validate_enabled then
561: --
562: -- As the Validate_Enabled exception has been raised
563: -- we must rollback to the savepoint
564: --
590: (p_validate in boolean default false
591: ,p_plip_id in number
592: ,p_effective_start_date out nocopy date
593: ,p_effective_end_date out nocopy date
594: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
595: ,p_plip_stat_cd in varchar2 default hr_api.g_varchar2
596: ,p_dflt_enrt_cd in varchar2 default hr_api.g_varchar2
597: ,p_dflt_enrt_det_rl in number default hr_api.g_number
598: ,p_ordr_num in number default hr_api.g_number
591: ,p_plip_id in number
592: ,p_effective_start_date out nocopy date
593: ,p_effective_end_date out nocopy date
594: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
595: ,p_plip_stat_cd in varchar2 default hr_api.g_varchar2
596: ,p_dflt_enrt_cd in varchar2 default hr_api.g_varchar2
597: ,p_dflt_enrt_det_rl in number default hr_api.g_number
598: ,p_ordr_num in number default hr_api.g_number
599: ,p_ivr_ident in varchar2 default hr_api.g_varchar2
592: ,p_effective_start_date out nocopy date
593: ,p_effective_end_date out nocopy date
594: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
595: ,p_plip_stat_cd in varchar2 default hr_api.g_varchar2
596: ,p_dflt_enrt_cd in varchar2 default hr_api.g_varchar2
597: ,p_dflt_enrt_det_rl in number default hr_api.g_number
598: ,p_ordr_num in number default hr_api.g_number
599: ,p_ivr_ident in varchar2 default hr_api.g_varchar2
600: ,p_enrt_cd in varchar2 default hr_api.g_varchar2
593: ,p_effective_end_date out nocopy date
594: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
595: ,p_plip_stat_cd in varchar2 default hr_api.g_varchar2
596: ,p_dflt_enrt_cd in varchar2 default hr_api.g_varchar2
597: ,p_dflt_enrt_det_rl in number default hr_api.g_number
598: ,p_ordr_num in number default hr_api.g_number
599: ,p_ivr_ident in varchar2 default hr_api.g_varchar2
600: ,p_enrt_cd in varchar2 default hr_api.g_varchar2
601: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
594: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
595: ,p_plip_stat_cd in varchar2 default hr_api.g_varchar2
596: ,p_dflt_enrt_cd in varchar2 default hr_api.g_varchar2
597: ,p_dflt_enrt_det_rl in number default hr_api.g_number
598: ,p_ordr_num in number default hr_api.g_number
599: ,p_ivr_ident in varchar2 default hr_api.g_varchar2
600: ,p_enrt_cd in varchar2 default hr_api.g_varchar2
601: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
602: ,p_auto_enrt_mthd_rl in number default hr_api.g_number
595: ,p_plip_stat_cd in varchar2 default hr_api.g_varchar2
596: ,p_dflt_enrt_cd in varchar2 default hr_api.g_varchar2
597: ,p_dflt_enrt_det_rl in number default hr_api.g_number
598: ,p_ordr_num in number default hr_api.g_number
599: ,p_ivr_ident in varchar2 default hr_api.g_varchar2
600: ,p_enrt_cd in varchar2 default hr_api.g_varchar2
601: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
602: ,p_auto_enrt_mthd_rl in number default hr_api.g_number
603: ,p_enrt_rl in number default hr_api.g_number
596: ,p_dflt_enrt_cd in varchar2 default hr_api.g_varchar2
597: ,p_dflt_enrt_det_rl in number default hr_api.g_number
598: ,p_ordr_num in number default hr_api.g_number
599: ,p_ivr_ident in varchar2 default hr_api.g_varchar2
600: ,p_enrt_cd in varchar2 default hr_api.g_varchar2
601: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
602: ,p_auto_enrt_mthd_rl in number default hr_api.g_number
603: ,p_enrt_rl in number default hr_api.g_number
604: ,p_alws_unrstrctd_enrt_flag in varchar2 default hr_api.g_varchar2
597: ,p_dflt_enrt_det_rl in number default hr_api.g_number
598: ,p_ordr_num in number default hr_api.g_number
599: ,p_ivr_ident in varchar2 default hr_api.g_varchar2
600: ,p_enrt_cd in varchar2 default hr_api.g_varchar2
601: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
602: ,p_auto_enrt_mthd_rl in number default hr_api.g_number
603: ,p_enrt_rl in number default hr_api.g_number
604: ,p_alws_unrstrctd_enrt_flag in varchar2 default hr_api.g_varchar2
605: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
598: ,p_ordr_num in number default hr_api.g_number
599: ,p_ivr_ident in varchar2 default hr_api.g_varchar2
600: ,p_enrt_cd in varchar2 default hr_api.g_varchar2
601: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
602: ,p_auto_enrt_mthd_rl in number default hr_api.g_number
603: ,p_enrt_rl in number default hr_api.g_number
604: ,p_alws_unrstrctd_enrt_flag in varchar2 default hr_api.g_varchar2
605: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
606: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
599: ,p_ivr_ident in varchar2 default hr_api.g_varchar2
600: ,p_enrt_cd in varchar2 default hr_api.g_varchar2
601: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
602: ,p_auto_enrt_mthd_rl in number default hr_api.g_number
603: ,p_enrt_rl in number default hr_api.g_number
604: ,p_alws_unrstrctd_enrt_flag in varchar2 default hr_api.g_varchar2
605: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
606: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
607: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
600: ,p_enrt_cd in varchar2 default hr_api.g_varchar2
601: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
602: ,p_auto_enrt_mthd_rl in number default hr_api.g_number
603: ,p_enrt_rl in number default hr_api.g_number
604: ,p_alws_unrstrctd_enrt_flag in varchar2 default hr_api.g_varchar2
605: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
606: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
607: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
608: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
601: ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
602: ,p_auto_enrt_mthd_rl in number default hr_api.g_number
603: ,p_enrt_rl in number default hr_api.g_number
604: ,p_alws_unrstrctd_enrt_flag in varchar2 default hr_api.g_varchar2
605: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
606: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
607: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
608: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
609: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
602: ,p_auto_enrt_mthd_rl in number default hr_api.g_number
603: ,p_enrt_rl in number default hr_api.g_number
604: ,p_alws_unrstrctd_enrt_flag in varchar2 default hr_api.g_varchar2
605: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
606: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
607: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
608: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
609: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
610: ,p_rt_strt_dt_rl in number default hr_api.g_number
603: ,p_enrt_rl in number default hr_api.g_number
604: ,p_alws_unrstrctd_enrt_flag in varchar2 default hr_api.g_varchar2
605: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
606: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
607: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
608: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
609: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
610: ,p_rt_strt_dt_rl in number default hr_api.g_number
611: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
604: ,p_alws_unrstrctd_enrt_flag in varchar2 default hr_api.g_varchar2
605: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
606: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
607: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
608: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
609: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
610: ,p_rt_strt_dt_rl in number default hr_api.g_number
611: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
612: ,p_rt_end_dt_rl in number default hr_api.g_number
605: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
606: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
607: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
608: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
609: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
610: ,p_rt_strt_dt_rl in number default hr_api.g_number
611: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
612: ,p_rt_end_dt_rl in number default hr_api.g_number
613: ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
606: ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
607: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
608: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
609: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
610: ,p_rt_strt_dt_rl in number default hr_api.g_number
611: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
612: ,p_rt_end_dt_rl in number default hr_api.g_number
613: ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
614: ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
607: ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
608: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
609: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
610: ,p_rt_strt_dt_rl in number default hr_api.g_number
611: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
612: ,p_rt_end_dt_rl in number default hr_api.g_number
613: ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
614: ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
615: ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
608: ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
609: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
610: ,p_rt_strt_dt_rl in number default hr_api.g_number
611: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
612: ,p_rt_end_dt_rl in number default hr_api.g_number
613: ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
614: ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
615: ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
616: ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
609: ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
610: ,p_rt_strt_dt_rl in number default hr_api.g_number
611: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
612: ,p_rt_end_dt_rl in number default hr_api.g_number
613: ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
614: ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
615: ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
616: ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
617: ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
610: ,p_rt_strt_dt_rl in number default hr_api.g_number
611: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
612: ,p_rt_end_dt_rl in number default hr_api.g_number
613: ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
614: ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
615: ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
616: ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
617: ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
618: ,p_postelcn_edit_rl in number default hr_api.g_number
611: ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
612: ,p_rt_end_dt_rl in number default hr_api.g_number
613: ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
614: ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
615: ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
616: ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
617: ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
618: ,p_postelcn_edit_rl in number default hr_api.g_number
619: ,p_pgm_id in number default hr_api.g_number
612: ,p_rt_end_dt_rl in number default hr_api.g_number
613: ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
614: ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
615: ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
616: ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
617: ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
618: ,p_postelcn_edit_rl in number default hr_api.g_number
619: ,p_pgm_id in number default hr_api.g_number
620: ,p_pl_id in number default hr_api.g_number
613: ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
614: ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
615: ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
616: ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
617: ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
618: ,p_postelcn_edit_rl in number default hr_api.g_number
619: ,p_pgm_id in number default hr_api.g_number
620: ,p_pl_id in number default hr_api.g_number
621: ,p_cmbn_plip_id in number default hr_api.g_number
614: ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
615: ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
616: ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
617: ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
618: ,p_postelcn_edit_rl in number default hr_api.g_number
619: ,p_pgm_id in number default hr_api.g_number
620: ,p_pl_id in number default hr_api.g_number
621: ,p_cmbn_plip_id in number default hr_api.g_number
622: ,p_business_group_id in number default hr_api.g_number
615: ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
616: ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
617: ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
618: ,p_postelcn_edit_rl in number default hr_api.g_number
619: ,p_pgm_id in number default hr_api.g_number
620: ,p_pl_id in number default hr_api.g_number
621: ,p_cmbn_plip_id in number default hr_api.g_number
622: ,p_business_group_id in number default hr_api.g_number
623: ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
616: ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
617: ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
618: ,p_postelcn_edit_rl in number default hr_api.g_number
619: ,p_pgm_id in number default hr_api.g_number
620: ,p_pl_id in number default hr_api.g_number
621: ,p_cmbn_plip_id in number default hr_api.g_number
622: ,p_business_group_id in number default hr_api.g_number
623: ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
624: ,p_short_name in varchar2 default hr_api.g_varchar2
617: ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
618: ,p_postelcn_edit_rl in number default hr_api.g_number
619: ,p_pgm_id in number default hr_api.g_number
620: ,p_pl_id in number default hr_api.g_number
621: ,p_cmbn_plip_id in number default hr_api.g_number
622: ,p_business_group_id in number default hr_api.g_number
623: ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
624: ,p_short_name in varchar2 default hr_api.g_varchar2
625: ,p_short_code in varchar2 default hr_api.g_varchar2
618: ,p_postelcn_edit_rl in number default hr_api.g_number
619: ,p_pgm_id in number default hr_api.g_number
620: ,p_pl_id in number default hr_api.g_number
621: ,p_cmbn_plip_id in number default hr_api.g_number
622: ,p_business_group_id in number default hr_api.g_number
623: ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
624: ,p_short_name in varchar2 default hr_api.g_varchar2
625: ,p_short_code in varchar2 default hr_api.g_varchar2
626: ,p_legislation_code in varchar2 default hr_api.g_varchar2
619: ,p_pgm_id in number default hr_api.g_number
620: ,p_pl_id in number default hr_api.g_number
621: ,p_cmbn_plip_id in number default hr_api.g_number
622: ,p_business_group_id in number default hr_api.g_number
623: ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
624: ,p_short_name in varchar2 default hr_api.g_varchar2
625: ,p_short_code in varchar2 default hr_api.g_varchar2
626: ,p_legislation_code in varchar2 default hr_api.g_varchar2
627: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
620: ,p_pl_id in number default hr_api.g_number
621: ,p_cmbn_plip_id in number default hr_api.g_number
622: ,p_business_group_id in number default hr_api.g_number
623: ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
624: ,p_short_name in varchar2 default hr_api.g_varchar2
625: ,p_short_code in varchar2 default hr_api.g_varchar2
626: ,p_legislation_code in varchar2 default hr_api.g_varchar2
627: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
628: ,P_vrfy_fmly_mmbr_rl in number default hr_api.g_number
621: ,p_cmbn_plip_id in number default hr_api.g_number
622: ,p_business_group_id in number default hr_api.g_number
623: ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
624: ,p_short_name in varchar2 default hr_api.g_varchar2
625: ,p_short_code in varchar2 default hr_api.g_varchar2
626: ,p_legislation_code in varchar2 default hr_api.g_varchar2
627: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
628: ,P_vrfy_fmly_mmbr_rl in number default hr_api.g_number
629: ,P_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
622: ,p_business_group_id in number default hr_api.g_number
623: ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
624: ,p_short_name in varchar2 default hr_api.g_varchar2
625: ,p_short_code in varchar2 default hr_api.g_varchar2
626: ,p_legislation_code in varchar2 default hr_api.g_varchar2
627: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
628: ,P_vrfy_fmly_mmbr_rl in number default hr_api.g_number
629: ,P_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
630: ,P_use_csd_rsd_prccng_cd in varchar2 default hr_api.g_varchar2
623: ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
624: ,p_short_name in varchar2 default hr_api.g_varchar2
625: ,p_short_code in varchar2 default hr_api.g_varchar2
626: ,p_legislation_code in varchar2 default hr_api.g_varchar2
627: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
628: ,P_vrfy_fmly_mmbr_rl in number default hr_api.g_number
629: ,P_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
630: ,P_use_csd_rsd_prccng_cd in varchar2 default hr_api.g_varchar2
631: ,p_cpp_attribute_category in varchar2 default hr_api.g_varchar2
624: ,p_short_name in varchar2 default hr_api.g_varchar2
625: ,p_short_code in varchar2 default hr_api.g_varchar2
626: ,p_legislation_code in varchar2 default hr_api.g_varchar2
627: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
628: ,P_vrfy_fmly_mmbr_rl in number default hr_api.g_number
629: ,P_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
630: ,P_use_csd_rsd_prccng_cd in varchar2 default hr_api.g_varchar2
631: ,p_cpp_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_cpp_attribute1 in varchar2 default hr_api.g_varchar2
625: ,p_short_code in varchar2 default hr_api.g_varchar2
626: ,p_legislation_code in varchar2 default hr_api.g_varchar2
627: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
628: ,P_vrfy_fmly_mmbr_rl in number default hr_api.g_number
629: ,P_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
630: ,P_use_csd_rsd_prccng_cd in varchar2 default hr_api.g_varchar2
631: ,p_cpp_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_cpp_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_cpp_attribute2 in varchar2 default hr_api.g_varchar2
626: ,p_legislation_code in varchar2 default hr_api.g_varchar2
627: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
628: ,P_vrfy_fmly_mmbr_rl in number default hr_api.g_number
629: ,P_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
630: ,P_use_csd_rsd_prccng_cd in varchar2 default hr_api.g_varchar2
631: ,p_cpp_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_cpp_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_cpp_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_cpp_attribute3 in varchar2 default hr_api.g_varchar2
627: ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
628: ,P_vrfy_fmly_mmbr_rl in number default hr_api.g_number
629: ,P_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
630: ,P_use_csd_rsd_prccng_cd in varchar2 default hr_api.g_varchar2
631: ,p_cpp_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_cpp_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_cpp_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_cpp_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_cpp_attribute4 in varchar2 default hr_api.g_varchar2
628: ,P_vrfy_fmly_mmbr_rl in number default hr_api.g_number
629: ,P_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
630: ,P_use_csd_rsd_prccng_cd in varchar2 default hr_api.g_varchar2
631: ,p_cpp_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_cpp_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_cpp_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_cpp_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_cpp_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_cpp_attribute5 in varchar2 default hr_api.g_varchar2
629: ,P_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
630: ,P_use_csd_rsd_prccng_cd in varchar2 default hr_api.g_varchar2
631: ,p_cpp_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_cpp_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_cpp_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_cpp_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_cpp_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_cpp_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_cpp_attribute6 in varchar2 default hr_api.g_varchar2
630: ,P_use_csd_rsd_prccng_cd in varchar2 default hr_api.g_varchar2
631: ,p_cpp_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_cpp_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_cpp_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_cpp_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_cpp_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_cpp_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_cpp_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_cpp_attribute7 in varchar2 default hr_api.g_varchar2
631: ,p_cpp_attribute_category in varchar2 default hr_api.g_varchar2
632: ,p_cpp_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_cpp_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_cpp_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_cpp_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_cpp_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_cpp_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_cpp_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_cpp_attribute8 in varchar2 default hr_api.g_varchar2
632: ,p_cpp_attribute1 in varchar2 default hr_api.g_varchar2
633: ,p_cpp_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_cpp_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_cpp_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_cpp_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_cpp_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_cpp_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_cpp_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_cpp_attribute9 in varchar2 default hr_api.g_varchar2
633: ,p_cpp_attribute2 in varchar2 default hr_api.g_varchar2
634: ,p_cpp_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_cpp_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_cpp_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_cpp_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_cpp_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_cpp_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_cpp_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_cpp_attribute10 in varchar2 default hr_api.g_varchar2
634: ,p_cpp_attribute3 in varchar2 default hr_api.g_varchar2
635: ,p_cpp_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_cpp_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_cpp_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_cpp_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_cpp_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_cpp_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_cpp_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_cpp_attribute11 in varchar2 default hr_api.g_varchar2
635: ,p_cpp_attribute4 in varchar2 default hr_api.g_varchar2
636: ,p_cpp_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_cpp_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_cpp_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_cpp_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_cpp_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_cpp_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_cpp_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_cpp_attribute12 in varchar2 default hr_api.g_varchar2
636: ,p_cpp_attribute5 in varchar2 default hr_api.g_varchar2
637: ,p_cpp_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_cpp_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_cpp_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_cpp_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_cpp_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_cpp_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_cpp_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_cpp_attribute13 in varchar2 default hr_api.g_varchar2
637: ,p_cpp_attribute6 in varchar2 default hr_api.g_varchar2
638: ,p_cpp_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_cpp_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_cpp_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_cpp_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_cpp_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_cpp_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_cpp_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_cpp_attribute14 in varchar2 default hr_api.g_varchar2
638: ,p_cpp_attribute7 in varchar2 default hr_api.g_varchar2
639: ,p_cpp_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_cpp_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_cpp_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_cpp_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_cpp_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_cpp_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_cpp_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_cpp_attribute15 in varchar2 default hr_api.g_varchar2
639: ,p_cpp_attribute8 in varchar2 default hr_api.g_varchar2
640: ,p_cpp_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_cpp_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_cpp_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_cpp_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_cpp_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_cpp_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_cpp_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_cpp_attribute16 in varchar2 default hr_api.g_varchar2
640: ,p_cpp_attribute9 in varchar2 default hr_api.g_varchar2
641: ,p_cpp_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_cpp_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_cpp_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_cpp_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_cpp_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_cpp_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_cpp_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_cpp_attribute17 in varchar2 default hr_api.g_varchar2
641: ,p_cpp_attribute10 in varchar2 default hr_api.g_varchar2
642: ,p_cpp_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_cpp_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_cpp_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_cpp_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_cpp_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_cpp_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_cpp_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_cpp_attribute18 in varchar2 default hr_api.g_varchar2
642: ,p_cpp_attribute11 in varchar2 default hr_api.g_varchar2
643: ,p_cpp_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_cpp_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_cpp_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_cpp_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_cpp_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_cpp_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_cpp_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_cpp_attribute19 in varchar2 default hr_api.g_varchar2
643: ,p_cpp_attribute12 in varchar2 default hr_api.g_varchar2
644: ,p_cpp_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_cpp_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_cpp_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_cpp_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_cpp_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_cpp_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_cpp_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_cpp_attribute20 in varchar2 default hr_api.g_varchar2
644: ,p_cpp_attribute13 in varchar2 default hr_api.g_varchar2
645: ,p_cpp_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_cpp_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_cpp_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_cpp_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_cpp_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_cpp_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_cpp_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_cpp_attribute21 in varchar2 default hr_api.g_varchar2
645: ,p_cpp_attribute14 in varchar2 default hr_api.g_varchar2
646: ,p_cpp_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_cpp_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_cpp_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_cpp_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_cpp_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_cpp_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_cpp_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_cpp_attribute22 in varchar2 default hr_api.g_varchar2
646: ,p_cpp_attribute15 in varchar2 default hr_api.g_varchar2
647: ,p_cpp_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_cpp_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_cpp_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_cpp_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_cpp_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_cpp_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_cpp_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_cpp_attribute23 in varchar2 default hr_api.g_varchar2
647: ,p_cpp_attribute16 in varchar2 default hr_api.g_varchar2
648: ,p_cpp_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_cpp_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_cpp_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_cpp_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_cpp_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_cpp_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_cpp_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_cpp_attribute24 in varchar2 default hr_api.g_varchar2
648: ,p_cpp_attribute17 in varchar2 default hr_api.g_varchar2
649: ,p_cpp_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_cpp_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_cpp_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_cpp_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_cpp_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_cpp_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_cpp_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_cpp_attribute25 in varchar2 default hr_api.g_varchar2
649: ,p_cpp_attribute18 in varchar2 default hr_api.g_varchar2
650: ,p_cpp_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_cpp_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_cpp_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_cpp_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_cpp_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_cpp_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_cpp_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_cpp_attribute26 in varchar2 default hr_api.g_varchar2
650: ,p_cpp_attribute19 in varchar2 default hr_api.g_varchar2
651: ,p_cpp_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_cpp_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_cpp_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_cpp_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_cpp_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_cpp_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_cpp_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_cpp_attribute27 in varchar2 default hr_api.g_varchar2
651: ,p_cpp_attribute20 in varchar2 default hr_api.g_varchar2
652: ,p_cpp_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_cpp_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_cpp_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_cpp_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_cpp_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_cpp_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_cpp_attribute27 in varchar2 default hr_api.g_varchar2
659: ,p_cpp_attribute28 in varchar2 default hr_api.g_varchar2
652: ,p_cpp_attribute21 in varchar2 default hr_api.g_varchar2
653: ,p_cpp_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_cpp_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_cpp_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_cpp_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_cpp_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_cpp_attribute27 in varchar2 default hr_api.g_varchar2
659: ,p_cpp_attribute28 in varchar2 default hr_api.g_varchar2
660: ,p_cpp_attribute29 in varchar2 default hr_api.g_varchar2
653: ,p_cpp_attribute22 in varchar2 default hr_api.g_varchar2
654: ,p_cpp_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_cpp_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_cpp_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_cpp_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_cpp_attribute27 in varchar2 default hr_api.g_varchar2
659: ,p_cpp_attribute28 in varchar2 default hr_api.g_varchar2
660: ,p_cpp_attribute29 in varchar2 default hr_api.g_varchar2
661: ,p_cpp_attribute30 in varchar2 default hr_api.g_varchar2
654: ,p_cpp_attribute23 in varchar2 default hr_api.g_varchar2
655: ,p_cpp_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_cpp_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_cpp_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_cpp_attribute27 in varchar2 default hr_api.g_varchar2
659: ,p_cpp_attribute28 in varchar2 default hr_api.g_varchar2
660: ,p_cpp_attribute29 in varchar2 default hr_api.g_varchar2
661: ,p_cpp_attribute30 in varchar2 default hr_api.g_varchar2
662: ,p_object_version_number in out nocopy number
655: ,p_cpp_attribute24 in varchar2 default hr_api.g_varchar2
656: ,p_cpp_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_cpp_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_cpp_attribute27 in varchar2 default hr_api.g_varchar2
659: ,p_cpp_attribute28 in varchar2 default hr_api.g_varchar2
660: ,p_cpp_attribute29 in varchar2 default hr_api.g_varchar2
661: ,p_cpp_attribute30 in varchar2 default hr_api.g_varchar2
662: ,p_object_version_number in out nocopy number
663: ,p_url_ref_name in varchar2 default hr_api.g_varchar2
656: ,p_cpp_attribute25 in varchar2 default hr_api.g_varchar2
657: ,p_cpp_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_cpp_attribute27 in varchar2 default hr_api.g_varchar2
659: ,p_cpp_attribute28 in varchar2 default hr_api.g_varchar2
660: ,p_cpp_attribute29 in varchar2 default hr_api.g_varchar2
661: ,p_cpp_attribute30 in varchar2 default hr_api.g_varchar2
662: ,p_object_version_number in out nocopy number
663: ,p_url_ref_name in varchar2 default hr_api.g_varchar2
664: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
657: ,p_cpp_attribute26 in varchar2 default hr_api.g_varchar2
658: ,p_cpp_attribute27 in varchar2 default hr_api.g_varchar2
659: ,p_cpp_attribute28 in varchar2 default hr_api.g_varchar2
660: ,p_cpp_attribute29 in varchar2 default hr_api.g_varchar2
661: ,p_cpp_attribute30 in varchar2 default hr_api.g_varchar2
662: ,p_object_version_number in out nocopy number
663: ,p_url_ref_name in varchar2 default hr_api.g_varchar2
664: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
665: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
659: ,p_cpp_attribute28 in varchar2 default hr_api.g_varchar2
660: ,p_cpp_attribute29 in varchar2 default hr_api.g_varchar2
661: ,p_cpp_attribute30 in varchar2 default hr_api.g_varchar2
662: ,p_object_version_number in out nocopy number
663: ,p_url_ref_name in varchar2 default hr_api.g_varchar2
664: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
665: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
666: ,p_mn_cvg_amt in number default hr_api.g_number
667: ,p_mn_cvg_rl in number default hr_api.g_number
660: ,p_cpp_attribute29 in varchar2 default hr_api.g_varchar2
661: ,p_cpp_attribute30 in varchar2 default hr_api.g_varchar2
662: ,p_object_version_number in out nocopy number
663: ,p_url_ref_name in varchar2 default hr_api.g_varchar2
664: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
665: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
666: ,p_mn_cvg_amt in number default hr_api.g_number
667: ,p_mn_cvg_rl in number default hr_api.g_number
668: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
661: ,p_cpp_attribute30 in varchar2 default hr_api.g_varchar2
662: ,p_object_version_number in out nocopy number
663: ,p_url_ref_name in varchar2 default hr_api.g_varchar2
664: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
665: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
666: ,p_mn_cvg_amt in number default hr_api.g_number
667: ,p_mn_cvg_rl in number default hr_api.g_number
668: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
669: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
662: ,p_object_version_number in out nocopy number
663: ,p_url_ref_name in varchar2 default hr_api.g_varchar2
664: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
665: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
666: ,p_mn_cvg_amt in number default hr_api.g_number
667: ,p_mn_cvg_rl in number default hr_api.g_number
668: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
669: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
670: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
663: ,p_url_ref_name in varchar2 default hr_api.g_varchar2
664: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
665: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
666: ,p_mn_cvg_amt in number default hr_api.g_number
667: ,p_mn_cvg_rl in number default hr_api.g_number
668: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
669: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
670: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
671: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
664: ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
665: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
666: ,p_mn_cvg_amt in number default hr_api.g_number
667: ,p_mn_cvg_rl in number default hr_api.g_number
668: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
669: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
670: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
671: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
672: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
665: ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
666: ,p_mn_cvg_amt in number default hr_api.g_number
667: ,p_mn_cvg_rl in number default hr_api.g_number
668: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
669: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
670: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
671: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
672: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
673: ,p_mx_cvg_rl in number default hr_api.g_number
666: ,p_mn_cvg_amt in number default hr_api.g_number
667: ,p_mn_cvg_rl in number default hr_api.g_number
668: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
669: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
670: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
671: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
672: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
673: ,p_mx_cvg_rl in number default hr_api.g_number
674: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
667: ,p_mn_cvg_rl in number default hr_api.g_number
668: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
669: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
670: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
671: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
672: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
673: ,p_mx_cvg_rl in number default hr_api.g_number
674: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
675: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
668: ,p_mx_cvg_alwd_amt in number default hr_api.g_number
669: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
670: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
671: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
672: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
673: ,p_mx_cvg_rl in number default hr_api.g_number
674: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
675: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
676: ,p_no_mn_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
669: ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
670: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
671: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
672: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
673: ,p_mx_cvg_rl in number default hr_api.g_number
674: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
675: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
676: ,p_no_mn_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
677: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
670: ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
671: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
672: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
673: ,p_mx_cvg_rl in number default hr_api.g_number
674: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
675: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
676: ,p_no_mn_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
677: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
678: ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
671: ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
672: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
673: ,p_mx_cvg_rl in number default hr_api.g_number
674: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
675: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
676: ,p_no_mn_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
677: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
678: ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
679: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
672: ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
673: ,p_mx_cvg_rl in number default hr_api.g_number
674: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
675: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
676: ,p_no_mn_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
677: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
678: ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
679: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
680: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
673: ,p_mx_cvg_rl in number default hr_api.g_number
674: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
675: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
676: ,p_no_mn_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
677: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
678: ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
679: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
680: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
681: ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default hr_api.g_varchar2
674: ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
675: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
676: ,p_no_mn_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
677: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
678: ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
679: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
680: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
681: ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default hr_api.g_varchar2
682: ,p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number
675: ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
676: ,p_no_mn_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
677: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
678: ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
679: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
680: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
681: ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default hr_api.g_varchar2
682: ,p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number
683: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
676: ,p_no_mn_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
677: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
678: ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
679: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
680: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
681: ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default hr_api.g_varchar2
682: ,p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number
683: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
684: ,p_bnft_or_option_rstrctn_cd in varchar2 default hr_api.g_varchar2
677: ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
678: ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
679: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
680: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
681: ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default hr_api.g_varchar2
682: ,p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number
683: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
684: ,p_bnft_or_option_rstrctn_cd in varchar2 default hr_api.g_varchar2
685: ,p_effective_date in date
678: ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
679: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
680: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
681: ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default hr_api.g_varchar2
682: ,p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number
683: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
684: ,p_bnft_or_option_rstrctn_cd in varchar2 default hr_api.g_varchar2
685: ,p_effective_date in date
686: ,p_datetrack_mode in varchar2
679: ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
680: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
681: ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default hr_api.g_varchar2
682: ,p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number
683: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
684: ,p_bnft_or_option_rstrctn_cd in varchar2 default hr_api.g_varchar2
685: ,p_effective_date in date
686: ,p_datetrack_mode in varchar2
687: ) is
680: ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
681: ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default hr_api.g_varchar2
682: ,p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number
683: ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
684: ,p_bnft_or_option_rstrctn_cd in varchar2 default hr_api.g_varchar2
685: ,p_effective_date in date
686: ,p_datetrack_mode in varchar2
687: ) is
688: --
808: ,p_effective_date => trunc(p_effective_date)
809: ,p_datetrack_mode => p_datetrack_mode
810: );
811: exception
812: when hr_api.cannot_find_prog_unit then
813: hr_api.cannot_find_prog_unit_error
814: (p_module_name => 'UPDATE_Plan_in_Program'
815: ,p_hook_type => 'BP'
816: );
809: ,p_datetrack_mode => p_datetrack_mode
810: );
811: exception
812: when hr_api.cannot_find_prog_unit then
813: hr_api.cannot_find_prog_unit_error
814: (p_module_name => 'UPDATE_Plan_in_Program'
815: ,p_hook_type => 'BP'
816: );
817: --
1022: ,p_effective_date => trunc(p_effective_date)
1023: ,p_datetrack_mode => p_datetrack_mode
1024: );
1025: exception
1026: when hr_api.cannot_find_prog_unit then
1027: hr_api.cannot_find_prog_unit_error
1028: (p_module_name => 'UPDATE_Plan_in_Program'
1029: ,p_hook_type => 'AP'
1030: );
1023: ,p_datetrack_mode => p_datetrack_mode
1024: );
1025: exception
1026: when hr_api.cannot_find_prog_unit then
1027: hr_api.cannot_find_prog_unit_error
1028: (p_module_name => 'UPDATE_Plan_in_Program'
1029: ,p_hook_type => 'AP'
1030: );
1031: --
1037: --
1038: -- When in validation only mode raise the Validate_Enabled exception
1039: --
1040: if p_validate then
1041: raise hr_api.validate_enabled;
1042: end if;
1043: --
1044: -- Set all output arguments
1045: --
1050: hr_utility.set_location(' Leaving:'||l_proc, 70);
1051: --
1052: exception
1053: --
1054: when hr_api.validate_enabled then
1055: --
1056: -- As the Validate_Enabled exception has been raised
1057: -- we must rollback to the savepoint
1058: --
1132: ,p_effective_date => trunc(p_effective_date)
1133: ,p_datetrack_mode => p_datetrack_mode
1134: );
1135: exception
1136: when hr_api.cannot_find_prog_unit then
1137: hr_api.cannot_find_prog_unit_error
1138: (p_module_name => 'DELETE_Plan_in_Program'
1139: ,p_hook_type => 'BP'
1140: );
1133: ,p_datetrack_mode => p_datetrack_mode
1134: );
1135: exception
1136: when hr_api.cannot_find_prog_unit then
1137: hr_api.cannot_find_prog_unit_error
1138: (p_module_name => 'DELETE_Plan_in_Program'
1139: ,p_hook_type => 'BP'
1140: );
1141: --
1166: ,p_effective_date => trunc(p_effective_date)
1167: ,p_datetrack_mode => p_datetrack_mode
1168: );
1169: exception
1170: when hr_api.cannot_find_prog_unit then
1171: hr_api.cannot_find_prog_unit_error
1172: (p_module_name => 'DELETE_Plan_in_Program'
1173: ,p_hook_type => 'AP'
1174: );
1167: ,p_datetrack_mode => p_datetrack_mode
1168: );
1169: exception
1170: when hr_api.cannot_find_prog_unit then
1171: hr_api.cannot_find_prog_unit_error
1172: (p_module_name => 'DELETE_Plan_in_Program'
1173: ,p_hook_type => 'AP'
1174: );
1175: --
1181: --
1182: -- When in validation only mode raise the Validate_Enabled exception
1183: --
1184: if p_validate then
1185: raise hr_api.validate_enabled;
1186: end if;
1187: --
1188: hr_utility.set_location(' Leaving:'||l_proc, 70);
1189: --
1188: hr_utility.set_location(' Leaving:'||l_proc, 70);
1189: --
1190: exception
1191: --
1192: when hr_api.validate_enabled then
1193: --
1194: -- As the Validate_Enabled exception has been raised
1195: -- we must rollback to the savepoint
1196: --