DBA Data[Home] [Help]

APPS.BEN_ELIG_PER_ELC_CHC_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_elig_per_elc_chc >-----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_elig_per_elc_chc
12: (p_validate in number default hr_api.g_false_num
13: ,p_elig_per_elctbl_chc_id out nocopy number
14: ,p_enrt_typ_cycl_cd in varchar2 default null
15: ,p_enrt_cvg_strt_dt_cd in varchar2 default null
16: ,p_enrt_perd_end_dt in date default null

Line 142: hr_api.constant_to_boolean

138: --
139: -- Convert constant values to their corresponding boolean value
140: --
141: l_validate :=
142: hr_api.constant_to_boolean
143: (p_constant_value => p_validate);
144: --
145: -- Register Surrogate ID or user key values
146: --

Line 310: (p_validate in number default hr_api.g_false_num

306: -- ----------------------------------------------------------------------------
307: -- |---------------------< create_perf_elig_per_elc_chc >---------------------|
308: -- ----------------------------------------------------------------------------
309: PROCEDURE create_perf_elig_per_elc_chc
310: (p_validate in number default hr_api.g_false_num
311: ,p_elig_per_elctbl_chc_id out nocopy number
312: ,p_enrt_typ_cycl_cd in varchar2 default null
313: ,p_enrt_cvg_strt_dt_cd in varchar2 default null
314: ,p_enrt_perd_end_dt in date default null

Line 441: hr_api.constant_to_boolean

437: --
438: -- Convert constant values to their corresponding boolean value
439: --
440: l_validate :=
441: hr_api.constant_to_boolean
442: (p_constant_value => p_validate);
443: --
444: -- Register Surrogate ID or user key values
445: --

Line 610: (p_validate in number default hr_api.g_false_num

606: -- ----------------------------------------------------------------------------
607: -- |------------------------< delete_elig_per_elc_chc >-----------------------|
608: -- ----------------------------------------------------------------------------
609: PROCEDURE delete_elig_per_elc_chc
610: (p_validate in number default hr_api.g_false_num
611: ,p_elig_per_elctbl_chc_id in number
612: ,p_object_version_number in out nocopy number
613: ,p_effective_date in date
614: ,p_return_status out nocopy varchar2

Line 643: hr_api.constant_to_boolean

639: --
640: -- Convert constant values to their corresponding boolean value
641: --
642: l_validate :=
643: hr_api.constant_to_boolean
644: (p_constant_value => p_validate);
645: --
646: -- Register Surrogate ID or user key values
647: --

Line 798: (p_validate in number default hr_api.g_false_num

794: -- ----------------------------------------------------------------------------
795: -- |------------------------< update_elig_per_elc_chc >-----------------------|
796: -- ----------------------------------------------------------------------------
797: PROCEDURE update_elig_per_elc_chc
798: (p_validate in number default hr_api.g_false_num
799: ,p_elig_per_elctbl_chc_id in number
800: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
801: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
802: ,p_enrt_perd_end_dt in date default hr_api.g_date

Line 800: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2

796: -- ----------------------------------------------------------------------------
797: PROCEDURE update_elig_per_elc_chc
798: (p_validate in number default hr_api.g_false_num
799: ,p_elig_per_elctbl_chc_id in number
800: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
801: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
802: ,p_enrt_perd_end_dt in date default hr_api.g_date
803: ,p_enrt_perd_strt_dt in date default hr_api.g_date
804: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

Line 801: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

797: PROCEDURE update_elig_per_elc_chc
798: (p_validate in number default hr_api.g_false_num
799: ,p_elig_per_elctbl_chc_id in number
800: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
801: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
802: ,p_enrt_perd_end_dt in date default hr_api.g_date
803: ,p_enrt_perd_strt_dt in date default hr_api.g_date
804: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
805: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

Line 802: ,p_enrt_perd_end_dt in date default hr_api.g_date

798: (p_validate in number default hr_api.g_false_num
799: ,p_elig_per_elctbl_chc_id in number
800: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
801: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
802: ,p_enrt_perd_end_dt in date default hr_api.g_date
803: ,p_enrt_perd_strt_dt in date default hr_api.g_date
804: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
805: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
806: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number

Line 803: ,p_enrt_perd_strt_dt in date default hr_api.g_date

799: ,p_elig_per_elctbl_chc_id in number
800: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
801: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
802: ,p_enrt_perd_end_dt in date default hr_api.g_date
803: ,p_enrt_perd_strt_dt in date default hr_api.g_date
804: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
805: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
806: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
807: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2

Line 804: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

800: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
801: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
802: ,p_enrt_perd_end_dt in date default hr_api.g_date
803: ,p_enrt_perd_strt_dt in date default hr_api.g_date
804: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
805: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
806: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
807: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
808: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2

Line 805: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

801: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
802: ,p_enrt_perd_end_dt in date default hr_api.g_date
803: ,p_enrt_perd_strt_dt in date default hr_api.g_date
804: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
805: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
806: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
807: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
808: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
809: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

Line 806: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number

802: ,p_enrt_perd_end_dt in date default hr_api.g_date
803: ,p_enrt_perd_strt_dt in date default hr_api.g_date
804: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
805: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
806: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
807: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
808: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
809: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
810: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2

Line 807: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2

803: ,p_enrt_perd_strt_dt in date default hr_api.g_date
804: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
805: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
806: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
807: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
808: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
809: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
810: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
811: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2

Line 808: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2

804: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
805: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
806: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
807: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
808: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
809: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
810: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
811: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
812: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2

Line 809: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

805: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
806: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
807: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
808: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
809: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
810: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
811: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
812: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
813: ,p_dflt_enrt_dt in date default hr_api.g_date

Line 810: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2

806: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
807: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
808: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
809: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
810: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
811: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
812: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
813: ,p_dflt_enrt_dt in date default hr_api.g_date
814: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

Line 811: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2

807: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
808: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
809: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
810: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
811: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
812: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
813: ,p_dflt_enrt_dt in date default hr_api.g_date
814: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
815: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

Line 812: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2

808: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
809: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
810: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
811: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
812: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
813: ,p_dflt_enrt_dt in date default hr_api.g_date
814: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
815: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
816: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

Line 813: ,p_dflt_enrt_dt in date default hr_api.g_date

809: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
810: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
811: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
812: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
813: ,p_dflt_enrt_dt in date default hr_api.g_date
814: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
815: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
816: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
817: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2

Line 814: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

810: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
811: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
812: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
813: ,p_dflt_enrt_dt in date default hr_api.g_date
814: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
815: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
816: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
817: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
818: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2

Line 815: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

811: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
812: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
813: ,p_dflt_enrt_dt in date default hr_api.g_date
814: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
815: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
816: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
817: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
818: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
819: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2

Line 816: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

812: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
813: ,p_dflt_enrt_dt in date default hr_api.g_date
814: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
815: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
816: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
817: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
818: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
819: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
820: ,p_erlst_deenrt_dt in date default hr_api.g_date

Line 817: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2

813: ,p_dflt_enrt_dt in date default hr_api.g_date
814: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
815: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
816: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
817: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
818: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
819: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
820: ,p_erlst_deenrt_dt in date default hr_api.g_date
821: ,p_procg_end_dt in date default hr_api.g_date

Line 818: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2

814: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
815: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
816: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
817: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
818: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
819: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
820: ,p_erlst_deenrt_dt in date default hr_api.g_date
821: ,p_procg_end_dt in date default hr_api.g_date
822: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2

Line 819: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2

815: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
816: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
817: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
818: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
819: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
820: ,p_erlst_deenrt_dt in date default hr_api.g_date
821: ,p_procg_end_dt in date default hr_api.g_date
822: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
823: ,p_pl_id in number default hr_api.g_number

Line 820: ,p_erlst_deenrt_dt in date default hr_api.g_date

816: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
817: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
818: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
819: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
820: ,p_erlst_deenrt_dt in date default hr_api.g_date
821: ,p_procg_end_dt in date default hr_api.g_date
822: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
823: ,p_pl_id in number default hr_api.g_number
824: ,p_oipl_id in number default hr_api.g_number

Line 821: ,p_procg_end_dt in date default hr_api.g_date

817: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
818: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
819: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
820: ,p_erlst_deenrt_dt in date default hr_api.g_date
821: ,p_procg_end_dt in date default hr_api.g_date
822: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
823: ,p_pl_id in number default hr_api.g_number
824: ,p_oipl_id in number default hr_api.g_number
825: ,p_pgm_id in number default hr_api.g_number

Line 822: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2

818: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
819: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
820: ,p_erlst_deenrt_dt in date default hr_api.g_date
821: ,p_procg_end_dt in date default hr_api.g_date
822: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
823: ,p_pl_id in number default hr_api.g_number
824: ,p_oipl_id in number default hr_api.g_number
825: ,p_pgm_id in number default hr_api.g_number
826: ,p_plip_id in number default hr_api.g_number

Line 823: ,p_pl_id in number default hr_api.g_number

819: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
820: ,p_erlst_deenrt_dt in date default hr_api.g_date
821: ,p_procg_end_dt in date default hr_api.g_date
822: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
823: ,p_pl_id in number default hr_api.g_number
824: ,p_oipl_id in number default hr_api.g_number
825: ,p_pgm_id in number default hr_api.g_number
826: ,p_plip_id in number default hr_api.g_number
827: ,p_ptip_id in number default hr_api.g_number

Line 824: ,p_oipl_id in number default hr_api.g_number

820: ,p_erlst_deenrt_dt in date default hr_api.g_date
821: ,p_procg_end_dt in date default hr_api.g_date
822: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
823: ,p_pl_id in number default hr_api.g_number
824: ,p_oipl_id in number default hr_api.g_number
825: ,p_pgm_id in number default hr_api.g_number
826: ,p_plip_id in number default hr_api.g_number
827: ,p_ptip_id in number default hr_api.g_number
828: ,p_pl_typ_id in number default hr_api.g_number

Line 825: ,p_pgm_id in number default hr_api.g_number

821: ,p_procg_end_dt in date default hr_api.g_date
822: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
823: ,p_pl_id in number default hr_api.g_number
824: ,p_oipl_id in number default hr_api.g_number
825: ,p_pgm_id in number default hr_api.g_number
826: ,p_plip_id in number default hr_api.g_number
827: ,p_ptip_id in number default hr_api.g_number
828: ,p_pl_typ_id in number default hr_api.g_number
829: ,p_oiplip_id in number default hr_api.g_number

Line 826: ,p_plip_id in number default hr_api.g_number

822: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
823: ,p_pl_id in number default hr_api.g_number
824: ,p_oipl_id in number default hr_api.g_number
825: ,p_pgm_id in number default hr_api.g_number
826: ,p_plip_id in number default hr_api.g_number
827: ,p_ptip_id in number default hr_api.g_number
828: ,p_pl_typ_id in number default hr_api.g_number
829: ,p_oiplip_id in number default hr_api.g_number
830: ,p_cmbn_plip_id in number default hr_api.g_number

Line 827: ,p_ptip_id in number default hr_api.g_number

823: ,p_pl_id in number default hr_api.g_number
824: ,p_oipl_id in number default hr_api.g_number
825: ,p_pgm_id in number default hr_api.g_number
826: ,p_plip_id in number default hr_api.g_number
827: ,p_ptip_id in number default hr_api.g_number
828: ,p_pl_typ_id in number default hr_api.g_number
829: ,p_oiplip_id in number default hr_api.g_number
830: ,p_cmbn_plip_id in number default hr_api.g_number
831: ,p_cmbn_ptip_id in number default hr_api.g_number

Line 828: ,p_pl_typ_id in number default hr_api.g_number

824: ,p_oipl_id in number default hr_api.g_number
825: ,p_pgm_id in number default hr_api.g_number
826: ,p_plip_id in number default hr_api.g_number
827: ,p_ptip_id in number default hr_api.g_number
828: ,p_pl_typ_id in number default hr_api.g_number
829: ,p_oiplip_id in number default hr_api.g_number
830: ,p_cmbn_plip_id in number default hr_api.g_number
831: ,p_cmbn_ptip_id in number default hr_api.g_number
832: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

Line 829: ,p_oiplip_id in number default hr_api.g_number

825: ,p_pgm_id in number default hr_api.g_number
826: ,p_plip_id in number default hr_api.g_number
827: ,p_ptip_id in number default hr_api.g_number
828: ,p_pl_typ_id in number default hr_api.g_number
829: ,p_oiplip_id in number default hr_api.g_number
830: ,p_cmbn_plip_id in number default hr_api.g_number
831: ,p_cmbn_ptip_id in number default hr_api.g_number
832: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
833: ,p_assignment_id in number default hr_api.g_number

Line 830: ,p_cmbn_plip_id in number default hr_api.g_number

826: ,p_plip_id in number default hr_api.g_number
827: ,p_ptip_id in number default hr_api.g_number
828: ,p_pl_typ_id in number default hr_api.g_number
829: ,p_oiplip_id in number default hr_api.g_number
830: ,p_cmbn_plip_id in number default hr_api.g_number
831: ,p_cmbn_ptip_id in number default hr_api.g_number
832: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
833: ,p_assignment_id in number default hr_api.g_number
834: ,p_spcl_rt_pl_id in number default hr_api.g_number

Line 831: ,p_cmbn_ptip_id in number default hr_api.g_number

827: ,p_ptip_id in number default hr_api.g_number
828: ,p_pl_typ_id in number default hr_api.g_number
829: ,p_oiplip_id in number default hr_api.g_number
830: ,p_cmbn_plip_id in number default hr_api.g_number
831: ,p_cmbn_ptip_id in number default hr_api.g_number
832: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
833: ,p_assignment_id in number default hr_api.g_number
834: ,p_spcl_rt_pl_id in number default hr_api.g_number
835: ,p_spcl_rt_oipl_id in number default hr_api.g_number

Line 832: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

828: ,p_pl_typ_id in number default hr_api.g_number
829: ,p_oiplip_id in number default hr_api.g_number
830: ,p_cmbn_plip_id in number default hr_api.g_number
831: ,p_cmbn_ptip_id in number default hr_api.g_number
832: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
833: ,p_assignment_id in number default hr_api.g_number
834: ,p_spcl_rt_pl_id in number default hr_api.g_number
835: ,p_spcl_rt_oipl_id in number default hr_api.g_number
836: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number

Line 833: ,p_assignment_id in number default hr_api.g_number

829: ,p_oiplip_id in number default hr_api.g_number
830: ,p_cmbn_plip_id in number default hr_api.g_number
831: ,p_cmbn_ptip_id in number default hr_api.g_number
832: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
833: ,p_assignment_id in number default hr_api.g_number
834: ,p_spcl_rt_pl_id in number default hr_api.g_number
835: ,p_spcl_rt_oipl_id in number default hr_api.g_number
836: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
837: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number

Line 834: ,p_spcl_rt_pl_id in number default hr_api.g_number

830: ,p_cmbn_plip_id in number default hr_api.g_number
831: ,p_cmbn_ptip_id in number default hr_api.g_number
832: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
833: ,p_assignment_id in number default hr_api.g_number
834: ,p_spcl_rt_pl_id in number default hr_api.g_number
835: ,p_spcl_rt_oipl_id in number default hr_api.g_number
836: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
837: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
838: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

Line 835: ,p_spcl_rt_oipl_id in number default hr_api.g_number

831: ,p_cmbn_ptip_id in number default hr_api.g_number
832: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
833: ,p_assignment_id in number default hr_api.g_number
834: ,p_spcl_rt_pl_id in number default hr_api.g_number
835: ,p_spcl_rt_oipl_id in number default hr_api.g_number
836: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
837: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
838: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
839: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

Line 836: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number

832: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
833: ,p_assignment_id in number default hr_api.g_number
834: ,p_spcl_rt_pl_id in number default hr_api.g_number
835: ,p_spcl_rt_oipl_id in number default hr_api.g_number
836: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
837: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
838: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
839: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
840: ,p_per_in_ler_id in number default hr_api.g_number

Line 837: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number

833: ,p_assignment_id in number default hr_api.g_number
834: ,p_spcl_rt_pl_id in number default hr_api.g_number
835: ,p_spcl_rt_oipl_id in number default hr_api.g_number
836: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
837: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
838: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
839: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
840: ,p_per_in_ler_id in number default hr_api.g_number
841: ,p_yr_perd_id in number default hr_api.g_number

Line 838: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

834: ,p_spcl_rt_pl_id in number default hr_api.g_number
835: ,p_spcl_rt_oipl_id in number default hr_api.g_number
836: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
837: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
838: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
839: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
840: ,p_per_in_ler_id in number default hr_api.g_number
841: ,p_yr_perd_id in number default hr_api.g_number
842: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2

Line 839: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

835: ,p_spcl_rt_oipl_id in number default hr_api.g_number
836: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
837: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
838: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
839: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
840: ,p_per_in_ler_id in number default hr_api.g_number
841: ,p_yr_perd_id in number default hr_api.g_number
842: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
843: ,p_business_group_id in number default hr_api.g_number

Line 840: ,p_per_in_ler_id in number default hr_api.g_number

836: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
837: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
838: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
839: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
840: ,p_per_in_ler_id in number default hr_api.g_number
841: ,p_yr_perd_id in number default hr_api.g_number
842: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
843: ,p_business_group_id in number default hr_api.g_number
844: ,p_pl_ordr_num in number default hr_api.g_number

Line 841: ,p_yr_perd_id in number default hr_api.g_number

837: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
838: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
839: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
840: ,p_per_in_ler_id in number default hr_api.g_number
841: ,p_yr_perd_id in number default hr_api.g_number
842: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
843: ,p_business_group_id in number default hr_api.g_number
844: ,p_pl_ordr_num in number default hr_api.g_number
845: ,p_plip_ordr_num in number default hr_api.g_number

Line 842: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2

838: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
839: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
840: ,p_per_in_ler_id in number default hr_api.g_number
841: ,p_yr_perd_id in number default hr_api.g_number
842: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
843: ,p_business_group_id in number default hr_api.g_number
844: ,p_pl_ordr_num in number default hr_api.g_number
845: ,p_plip_ordr_num in number default hr_api.g_number
846: ,p_ptip_ordr_num in number default hr_api.g_number

Line 843: ,p_business_group_id in number default hr_api.g_number

839: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
840: ,p_per_in_ler_id in number default hr_api.g_number
841: ,p_yr_perd_id in number default hr_api.g_number
842: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
843: ,p_business_group_id in number default hr_api.g_number
844: ,p_pl_ordr_num in number default hr_api.g_number
845: ,p_plip_ordr_num in number default hr_api.g_number
846: ,p_ptip_ordr_num in number default hr_api.g_number
847: ,p_oipl_ordr_num in number default hr_api.g_number

Line 844: ,p_pl_ordr_num in number default hr_api.g_number

840: ,p_per_in_ler_id in number default hr_api.g_number
841: ,p_yr_perd_id in number default hr_api.g_number
842: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
843: ,p_business_group_id in number default hr_api.g_number
844: ,p_pl_ordr_num in number default hr_api.g_number
845: ,p_plip_ordr_num in number default hr_api.g_number
846: ,p_ptip_ordr_num in number default hr_api.g_number
847: ,p_oipl_ordr_num in number default hr_api.g_number
848: ,p_comments in varchar2 default hr_api.g_varchar2

Line 845: ,p_plip_ordr_num in number default hr_api.g_number

841: ,p_yr_perd_id in number default hr_api.g_number
842: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
843: ,p_business_group_id in number default hr_api.g_number
844: ,p_pl_ordr_num in number default hr_api.g_number
845: ,p_plip_ordr_num in number default hr_api.g_number
846: ,p_ptip_ordr_num in number default hr_api.g_number
847: ,p_oipl_ordr_num in number default hr_api.g_number
848: ,p_comments in varchar2 default hr_api.g_varchar2
849: ,p_elig_flag in varchar2 default hr_api.g_varchar2

Line 846: ,p_ptip_ordr_num in number default hr_api.g_number

842: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
843: ,p_business_group_id in number default hr_api.g_number
844: ,p_pl_ordr_num in number default hr_api.g_number
845: ,p_plip_ordr_num in number default hr_api.g_number
846: ,p_ptip_ordr_num in number default hr_api.g_number
847: ,p_oipl_ordr_num in number default hr_api.g_number
848: ,p_comments in varchar2 default hr_api.g_varchar2
849: ,p_elig_flag in varchar2 default hr_api.g_varchar2
850: ,p_elig_ovrid_dt in date default hr_api.g_date

Line 847: ,p_oipl_ordr_num in number default hr_api.g_number

843: ,p_business_group_id in number default hr_api.g_number
844: ,p_pl_ordr_num in number default hr_api.g_number
845: ,p_plip_ordr_num in number default hr_api.g_number
846: ,p_ptip_ordr_num in number default hr_api.g_number
847: ,p_oipl_ordr_num in number default hr_api.g_number
848: ,p_comments in varchar2 default hr_api.g_varchar2
849: ,p_elig_flag in varchar2 default hr_api.g_varchar2
850: ,p_elig_ovrid_dt in date default hr_api.g_date
851: ,p_elig_ovrid_person_id in number default hr_api.g_number

Line 848: ,p_comments in varchar2 default hr_api.g_varchar2

844: ,p_pl_ordr_num in number default hr_api.g_number
845: ,p_plip_ordr_num in number default hr_api.g_number
846: ,p_ptip_ordr_num in number default hr_api.g_number
847: ,p_oipl_ordr_num in number default hr_api.g_number
848: ,p_comments in varchar2 default hr_api.g_varchar2
849: ,p_elig_flag in varchar2 default hr_api.g_varchar2
850: ,p_elig_ovrid_dt in date default hr_api.g_date
851: ,p_elig_ovrid_person_id in number default hr_api.g_number
852: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2

Line 849: ,p_elig_flag in varchar2 default hr_api.g_varchar2

845: ,p_plip_ordr_num in number default hr_api.g_number
846: ,p_ptip_ordr_num in number default hr_api.g_number
847: ,p_oipl_ordr_num in number default hr_api.g_number
848: ,p_comments in varchar2 default hr_api.g_varchar2
849: ,p_elig_flag in varchar2 default hr_api.g_varchar2
850: ,p_elig_ovrid_dt in date default hr_api.g_date
851: ,p_elig_ovrid_person_id in number default hr_api.g_number
852: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
853: ,p_mgr_ovrid_dt in date default hr_api.g_date

Line 850: ,p_elig_ovrid_dt in date default hr_api.g_date

846: ,p_ptip_ordr_num in number default hr_api.g_number
847: ,p_oipl_ordr_num in number default hr_api.g_number
848: ,p_comments in varchar2 default hr_api.g_varchar2
849: ,p_elig_flag in varchar2 default hr_api.g_varchar2
850: ,p_elig_ovrid_dt in date default hr_api.g_date
851: ,p_elig_ovrid_person_id in number default hr_api.g_number
852: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
853: ,p_mgr_ovrid_dt in date default hr_api.g_date
854: ,p_mgr_ovrid_person_id in number default hr_api.g_number

Line 851: ,p_elig_ovrid_person_id in number default hr_api.g_number

847: ,p_oipl_ordr_num in number default hr_api.g_number
848: ,p_comments in varchar2 default hr_api.g_varchar2
849: ,p_elig_flag in varchar2 default hr_api.g_varchar2
850: ,p_elig_ovrid_dt in date default hr_api.g_date
851: ,p_elig_ovrid_person_id in number default hr_api.g_number
852: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
853: ,p_mgr_ovrid_dt in date default hr_api.g_date
854: ,p_mgr_ovrid_person_id in number default hr_api.g_number
855: ,p_ws_mgr_id in number default hr_api.g_number

Line 852: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2

848: ,p_comments in varchar2 default hr_api.g_varchar2
849: ,p_elig_flag in varchar2 default hr_api.g_varchar2
850: ,p_elig_ovrid_dt in date default hr_api.g_date
851: ,p_elig_ovrid_person_id in number default hr_api.g_number
852: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
853: ,p_mgr_ovrid_dt in date default hr_api.g_date
854: ,p_mgr_ovrid_person_id in number default hr_api.g_number
855: ,p_ws_mgr_id in number default hr_api.g_number
856: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2

Line 853: ,p_mgr_ovrid_dt in date default hr_api.g_date

849: ,p_elig_flag in varchar2 default hr_api.g_varchar2
850: ,p_elig_ovrid_dt in date default hr_api.g_date
851: ,p_elig_ovrid_person_id in number default hr_api.g_number
852: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
853: ,p_mgr_ovrid_dt in date default hr_api.g_date
854: ,p_mgr_ovrid_person_id in number default hr_api.g_number
855: ,p_ws_mgr_id in number default hr_api.g_number
856: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
857: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2

Line 854: ,p_mgr_ovrid_person_id in number default hr_api.g_number

850: ,p_elig_ovrid_dt in date default hr_api.g_date
851: ,p_elig_ovrid_person_id in number default hr_api.g_number
852: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
853: ,p_mgr_ovrid_dt in date default hr_api.g_date
854: ,p_mgr_ovrid_person_id in number default hr_api.g_number
855: ,p_ws_mgr_id in number default hr_api.g_number
856: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
857: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
858: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2

Line 855: ,p_ws_mgr_id in number default hr_api.g_number

851: ,p_elig_ovrid_person_id in number default hr_api.g_number
852: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
853: ,p_mgr_ovrid_dt in date default hr_api.g_date
854: ,p_mgr_ovrid_person_id in number default hr_api.g_number
855: ,p_ws_mgr_id in number default hr_api.g_number
856: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
857: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
858: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
859: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2

Line 856: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2

852: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
853: ,p_mgr_ovrid_dt in date default hr_api.g_date
854: ,p_mgr_ovrid_person_id in number default hr_api.g_number
855: ,p_ws_mgr_id in number default hr_api.g_number
856: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
857: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
858: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
859: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
860: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2

Line 857: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2

853: ,p_mgr_ovrid_dt in date default hr_api.g_date
854: ,p_mgr_ovrid_person_id in number default hr_api.g_number
855: ,p_ws_mgr_id in number default hr_api.g_number
856: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
857: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
858: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
859: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
860: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
861: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2

Line 858: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2

854: ,p_mgr_ovrid_person_id in number default hr_api.g_number
855: ,p_ws_mgr_id in number default hr_api.g_number
856: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
857: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
858: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
859: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
860: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
861: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
862: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2

Line 859: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2

855: ,p_ws_mgr_id in number default hr_api.g_number
856: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
857: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
858: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
859: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
860: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
861: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
862: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
863: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2

Line 860: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2

856: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
857: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
858: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
859: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
860: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
861: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
862: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
863: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
864: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2

Line 861: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2

857: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
858: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
859: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
860: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
861: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
862: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
863: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
864: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
865: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2

Line 862: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2

858: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
859: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
860: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
861: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
862: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
863: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
864: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
865: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
866: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2

Line 863: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2

859: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
860: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
861: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
862: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
863: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
864: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
865: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
866: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
867: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2

Line 864: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2

860: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
861: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
862: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
863: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
864: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
865: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
866: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
867: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
868: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2

Line 865: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2

861: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
862: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
863: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
864: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
865: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
866: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
867: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
868: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
869: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2

Line 866: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2

862: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
863: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
864: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
865: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
866: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
867: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
868: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
869: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
870: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2

Line 867: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2

863: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
864: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
865: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
866: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
867: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
868: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
869: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
870: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
871: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2

Line 868: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2

864: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
865: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
866: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
867: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
868: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
869: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
870: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
871: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
872: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2

Line 869: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2

865: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
866: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
867: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
868: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
869: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
870: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
871: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
872: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
873: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2

Line 870: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2

866: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
867: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
868: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
869: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
870: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
871: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
872: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
873: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
874: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2

Line 871: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2

867: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
868: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
869: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
870: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
871: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
872: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
873: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
874: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
875: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2

Line 872: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2

868: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
869: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
870: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
871: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
872: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
873: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
874: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
875: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
876: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2

Line 873: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2

869: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
870: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
871: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
872: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
873: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
874: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
875: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
876: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
877: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2

Line 874: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2

870: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
871: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
872: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
873: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
874: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
875: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
876: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
877: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
878: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2

Line 875: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2

871: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
872: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
873: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
874: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
875: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
876: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
877: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
878: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
879: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2

Line 876: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2

872: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
873: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
874: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
875: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
876: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
877: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
878: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
879: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
880: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2

Line 877: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2

873: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
874: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
875: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
876: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
877: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
878: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
879: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
880: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
881: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2

Line 878: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2

874: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
875: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
876: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
877: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
878: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
879: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
880: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
881: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
882: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2

Line 879: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2

875: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
876: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
877: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
878: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
879: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
880: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
881: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
882: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
883: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2

Line 880: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2

876: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
877: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
878: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
879: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
880: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
881: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
882: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
883: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
884: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2

Line 881: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2

877: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
878: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
879: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
880: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
881: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
882: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
883: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
884: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
885: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2

Line 882: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2

878: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
879: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
880: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
881: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
882: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
883: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
884: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
885: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
886: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2

Line 883: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2

879: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
880: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
881: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
882: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
883: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
884: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
885: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
886: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
887: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2

Line 884: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2

880: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
881: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
882: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
883: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
884: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
885: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
886: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
887: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
888: ,p_request_id in number default hr_api.g_number

Line 885: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2

881: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
882: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
883: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
884: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
885: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
886: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
887: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
888: ,p_request_id in number default hr_api.g_number
889: ,p_program_application_id in number default hr_api.g_number

Line 886: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2

882: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
883: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
884: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
885: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
886: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
887: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
888: ,p_request_id in number default hr_api.g_number
889: ,p_program_application_id in number default hr_api.g_number
890: ,p_program_id in number default hr_api.g_number

Line 887: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2

883: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
884: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
885: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
886: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
887: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
888: ,p_request_id in number default hr_api.g_number
889: ,p_program_application_id in number default hr_api.g_number
890: ,p_program_id in number default hr_api.g_number
891: ,p_program_update_date in date default hr_api.g_date

Line 888: ,p_request_id in number default hr_api.g_number

884: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
885: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
886: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
887: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
888: ,p_request_id in number default hr_api.g_number
889: ,p_program_application_id in number default hr_api.g_number
890: ,p_program_id in number default hr_api.g_number
891: ,p_program_update_date in date default hr_api.g_date
892: ,p_object_version_number in out nocopy number

Line 889: ,p_program_application_id in number default hr_api.g_number

885: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
886: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
887: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
888: ,p_request_id in number default hr_api.g_number
889: ,p_program_application_id in number default hr_api.g_number
890: ,p_program_id in number default hr_api.g_number
891: ,p_program_update_date in date default hr_api.g_date
892: ,p_object_version_number in out nocopy number
893: ,p_effective_date in date

Line 890: ,p_program_id in number default hr_api.g_number

886: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
887: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
888: ,p_request_id in number default hr_api.g_number
889: ,p_program_application_id in number default hr_api.g_number
890: ,p_program_id in number default hr_api.g_number
891: ,p_program_update_date in date default hr_api.g_date
892: ,p_object_version_number in out nocopy number
893: ,p_effective_date in date
894: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2

Line 891: ,p_program_update_date in date default hr_api.g_date

887: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
888: ,p_request_id in number default hr_api.g_number
889: ,p_program_application_id in number default hr_api.g_number
890: ,p_program_id in number default hr_api.g_number
891: ,p_program_update_date in date default hr_api.g_date
892: ,p_object_version_number in out nocopy number
893: ,p_effective_date in date
894: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
895: ,p_return_status out nocopy varchar2

Line 894: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2

890: ,p_program_id in number default hr_api.g_number
891: ,p_program_update_date in date default hr_api.g_date
892: ,p_object_version_number in out nocopy number
893: ,p_effective_date in date
894: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
895: ,p_return_status out nocopy varchar2
896: ) is
897: --
898: -- Variables for API Boolean parameters

Line 924: hr_api.constant_to_boolean

920: --
921: -- Convert constant values to their corresponding boolean value
922: --
923: l_validate :=
924: hr_api.constant_to_boolean
925: (p_constant_value => p_validate);
926: --
927: -- Register Surrogate ID or user key values
928: --

Line 1084: (p_validate in number default hr_api.g_false_num

1080: -- ----------------------------------------------------------------------------
1081: -- |---------------------< update_perf_elig_per_elc_chc >---------------------|
1082: -- ----------------------------------------------------------------------------
1083: PROCEDURE update_perf_elig_per_elc_chc
1084: (p_validate in number default hr_api.g_false_num
1085: ,p_elig_per_elctbl_chc_id in number
1086: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1087: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1088: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

Line 1086: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

1082: -- ----------------------------------------------------------------------------
1083: PROCEDURE update_perf_elig_per_elc_chc
1084: (p_validate in number default hr_api.g_false_num
1085: ,p_elig_per_elctbl_chc_id in number
1086: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1087: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1088: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1089: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1090: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2

Line 1087: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

1083: PROCEDURE update_perf_elig_per_elc_chc
1084: (p_validate in number default hr_api.g_false_num
1085: ,p_elig_per_elctbl_chc_id in number
1086: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1087: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1088: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1089: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1090: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1091: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2

Line 1088: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

1084: (p_validate in number default hr_api.g_false_num
1085: ,p_elig_per_elctbl_chc_id in number
1086: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1087: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1088: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1089: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1090: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1091: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1092: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

Line 1089: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number

1085: ,p_elig_per_elctbl_chc_id in number
1086: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1087: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1088: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1089: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1090: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1091: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1092: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1093: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2

Line 1090: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2

1086: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1087: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1088: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1089: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1090: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1091: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1092: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1093: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1094: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2

Line 1091: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2

1087: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1088: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1089: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1090: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1091: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1092: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1093: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1094: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1095: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2

Line 1092: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

1088: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1089: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1090: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1091: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1092: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1093: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1094: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1095: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1096: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

Line 1093: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2

1089: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1090: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1091: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1092: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1093: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1094: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1095: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1096: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1097: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

Line 1094: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2

1090: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1091: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1092: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1093: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1094: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1095: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1096: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1097: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1098: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

Line 1095: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2

1091: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1092: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1093: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1094: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1095: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1096: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1097: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1098: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1099: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2

Line 1096: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

1092: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1093: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1094: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1095: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1096: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1097: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1098: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1099: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1100: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2

Line 1097: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

1093: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1094: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1095: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1096: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1097: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1098: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1099: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1100: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1101: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2

Line 1098: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

1094: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1095: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1096: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1097: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1098: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1099: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1100: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1101: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1102: ,p_erlst_deenrt_dt in date default hr_api.g_date

Line 1099: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2

1095: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1096: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1097: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1098: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1099: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1100: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1101: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1102: ,p_erlst_deenrt_dt in date default hr_api.g_date
1103: ,p_procg_end_dt in date default hr_api.g_date

Line 1100: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2

1096: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1097: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1098: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1099: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1100: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1101: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1102: ,p_erlst_deenrt_dt in date default hr_api.g_date
1103: ,p_procg_end_dt in date default hr_api.g_date
1104: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2

Line 1101: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2

1097: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1098: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1099: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1100: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1101: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1102: ,p_erlst_deenrt_dt in date default hr_api.g_date
1103: ,p_procg_end_dt in date default hr_api.g_date
1104: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1105: ,p_pl_id in number default hr_api.g_number

Line 1102: ,p_erlst_deenrt_dt in date default hr_api.g_date

1098: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1099: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1100: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1101: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1102: ,p_erlst_deenrt_dt in date default hr_api.g_date
1103: ,p_procg_end_dt in date default hr_api.g_date
1104: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1105: ,p_pl_id in number default hr_api.g_number
1106: ,p_oipl_id in number default hr_api.g_number

Line 1103: ,p_procg_end_dt in date default hr_api.g_date

1099: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1100: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1101: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1102: ,p_erlst_deenrt_dt in date default hr_api.g_date
1103: ,p_procg_end_dt in date default hr_api.g_date
1104: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1105: ,p_pl_id in number default hr_api.g_number
1106: ,p_oipl_id in number default hr_api.g_number
1107: ,p_pgm_id in number default hr_api.g_number

Line 1104: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2

1100: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1101: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1102: ,p_erlst_deenrt_dt in date default hr_api.g_date
1103: ,p_procg_end_dt in date default hr_api.g_date
1104: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1105: ,p_pl_id in number default hr_api.g_number
1106: ,p_oipl_id in number default hr_api.g_number
1107: ,p_pgm_id in number default hr_api.g_number
1108: ,p_plip_id in number default hr_api.g_number

Line 1105: ,p_pl_id in number default hr_api.g_number

1101: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1102: ,p_erlst_deenrt_dt in date default hr_api.g_date
1103: ,p_procg_end_dt in date default hr_api.g_date
1104: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1105: ,p_pl_id in number default hr_api.g_number
1106: ,p_oipl_id in number default hr_api.g_number
1107: ,p_pgm_id in number default hr_api.g_number
1108: ,p_plip_id in number default hr_api.g_number
1109: ,p_ptip_id in number default hr_api.g_number

Line 1106: ,p_oipl_id in number default hr_api.g_number

1102: ,p_erlst_deenrt_dt in date default hr_api.g_date
1103: ,p_procg_end_dt in date default hr_api.g_date
1104: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1105: ,p_pl_id in number default hr_api.g_number
1106: ,p_oipl_id in number default hr_api.g_number
1107: ,p_pgm_id in number default hr_api.g_number
1108: ,p_plip_id in number default hr_api.g_number
1109: ,p_ptip_id in number default hr_api.g_number
1110: ,p_pl_typ_id in number default hr_api.g_number

Line 1107: ,p_pgm_id in number default hr_api.g_number

1103: ,p_procg_end_dt in date default hr_api.g_date
1104: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1105: ,p_pl_id in number default hr_api.g_number
1106: ,p_oipl_id in number default hr_api.g_number
1107: ,p_pgm_id in number default hr_api.g_number
1108: ,p_plip_id in number default hr_api.g_number
1109: ,p_ptip_id in number default hr_api.g_number
1110: ,p_pl_typ_id in number default hr_api.g_number
1111: ,p_oiplip_id in number default hr_api.g_number

Line 1108: ,p_plip_id in number default hr_api.g_number

1104: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1105: ,p_pl_id in number default hr_api.g_number
1106: ,p_oipl_id in number default hr_api.g_number
1107: ,p_pgm_id in number default hr_api.g_number
1108: ,p_plip_id in number default hr_api.g_number
1109: ,p_ptip_id in number default hr_api.g_number
1110: ,p_pl_typ_id in number default hr_api.g_number
1111: ,p_oiplip_id in number default hr_api.g_number
1112: ,p_cmbn_plip_id in number default hr_api.g_number

Line 1109: ,p_ptip_id in number default hr_api.g_number

1105: ,p_pl_id in number default hr_api.g_number
1106: ,p_oipl_id in number default hr_api.g_number
1107: ,p_pgm_id in number default hr_api.g_number
1108: ,p_plip_id in number default hr_api.g_number
1109: ,p_ptip_id in number default hr_api.g_number
1110: ,p_pl_typ_id in number default hr_api.g_number
1111: ,p_oiplip_id in number default hr_api.g_number
1112: ,p_cmbn_plip_id in number default hr_api.g_number
1113: ,p_cmbn_ptip_id in number default hr_api.g_number

Line 1110: ,p_pl_typ_id in number default hr_api.g_number

1106: ,p_oipl_id in number default hr_api.g_number
1107: ,p_pgm_id in number default hr_api.g_number
1108: ,p_plip_id in number default hr_api.g_number
1109: ,p_ptip_id in number default hr_api.g_number
1110: ,p_pl_typ_id in number default hr_api.g_number
1111: ,p_oiplip_id in number default hr_api.g_number
1112: ,p_cmbn_plip_id in number default hr_api.g_number
1113: ,p_cmbn_ptip_id in number default hr_api.g_number
1114: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

Line 1111: ,p_oiplip_id in number default hr_api.g_number

1107: ,p_pgm_id in number default hr_api.g_number
1108: ,p_plip_id in number default hr_api.g_number
1109: ,p_ptip_id in number default hr_api.g_number
1110: ,p_pl_typ_id in number default hr_api.g_number
1111: ,p_oiplip_id in number default hr_api.g_number
1112: ,p_cmbn_plip_id in number default hr_api.g_number
1113: ,p_cmbn_ptip_id in number default hr_api.g_number
1114: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1115: ,p_assignment_id in number default hr_api.g_number

Line 1112: ,p_cmbn_plip_id in number default hr_api.g_number

1108: ,p_plip_id in number default hr_api.g_number
1109: ,p_ptip_id in number default hr_api.g_number
1110: ,p_pl_typ_id in number default hr_api.g_number
1111: ,p_oiplip_id in number default hr_api.g_number
1112: ,p_cmbn_plip_id in number default hr_api.g_number
1113: ,p_cmbn_ptip_id in number default hr_api.g_number
1114: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1115: ,p_assignment_id in number default hr_api.g_number
1116: ,p_spcl_rt_pl_id in number default hr_api.g_number

Line 1113: ,p_cmbn_ptip_id in number default hr_api.g_number

1109: ,p_ptip_id in number default hr_api.g_number
1110: ,p_pl_typ_id in number default hr_api.g_number
1111: ,p_oiplip_id in number default hr_api.g_number
1112: ,p_cmbn_plip_id in number default hr_api.g_number
1113: ,p_cmbn_ptip_id in number default hr_api.g_number
1114: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1115: ,p_assignment_id in number default hr_api.g_number
1116: ,p_spcl_rt_pl_id in number default hr_api.g_number
1117: ,p_spcl_rt_oipl_id in number default hr_api.g_number

Line 1114: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

1110: ,p_pl_typ_id in number default hr_api.g_number
1111: ,p_oiplip_id in number default hr_api.g_number
1112: ,p_cmbn_plip_id in number default hr_api.g_number
1113: ,p_cmbn_ptip_id in number default hr_api.g_number
1114: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1115: ,p_assignment_id in number default hr_api.g_number
1116: ,p_spcl_rt_pl_id in number default hr_api.g_number
1117: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1118: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number

Line 1115: ,p_assignment_id in number default hr_api.g_number

1111: ,p_oiplip_id in number default hr_api.g_number
1112: ,p_cmbn_plip_id in number default hr_api.g_number
1113: ,p_cmbn_ptip_id in number default hr_api.g_number
1114: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1115: ,p_assignment_id in number default hr_api.g_number
1116: ,p_spcl_rt_pl_id in number default hr_api.g_number
1117: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1118: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1119: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number

Line 1116: ,p_spcl_rt_pl_id in number default hr_api.g_number

1112: ,p_cmbn_plip_id in number default hr_api.g_number
1113: ,p_cmbn_ptip_id in number default hr_api.g_number
1114: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1115: ,p_assignment_id in number default hr_api.g_number
1116: ,p_spcl_rt_pl_id in number default hr_api.g_number
1117: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1118: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1119: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1120: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

Line 1117: ,p_spcl_rt_oipl_id in number default hr_api.g_number

1113: ,p_cmbn_ptip_id in number default hr_api.g_number
1114: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1115: ,p_assignment_id in number default hr_api.g_number
1116: ,p_spcl_rt_pl_id in number default hr_api.g_number
1117: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1118: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1119: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1120: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1121: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

Line 1118: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number

1114: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1115: ,p_assignment_id in number default hr_api.g_number
1116: ,p_spcl_rt_pl_id in number default hr_api.g_number
1117: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1118: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1119: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1120: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1121: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1122: ,p_per_in_ler_id in number default hr_api.g_number

Line 1119: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number

1115: ,p_assignment_id in number default hr_api.g_number
1116: ,p_spcl_rt_pl_id in number default hr_api.g_number
1117: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1118: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1119: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1120: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1121: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1122: ,p_per_in_ler_id in number default hr_api.g_number
1123: ,p_yr_perd_id in number default hr_api.g_number

Line 1120: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

1116: ,p_spcl_rt_pl_id in number default hr_api.g_number
1117: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1118: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1119: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1120: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1121: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1122: ,p_per_in_ler_id in number default hr_api.g_number
1123: ,p_yr_perd_id in number default hr_api.g_number
1124: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2

Line 1121: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

1117: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1118: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1119: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1120: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1121: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1122: ,p_per_in_ler_id in number default hr_api.g_number
1123: ,p_yr_perd_id in number default hr_api.g_number
1124: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1125: ,p_business_group_id in number default hr_api.g_number

Line 1122: ,p_per_in_ler_id in number default hr_api.g_number

1118: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1119: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1120: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1121: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1122: ,p_per_in_ler_id in number default hr_api.g_number
1123: ,p_yr_perd_id in number default hr_api.g_number
1124: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1125: ,p_business_group_id in number default hr_api.g_number
1126: ,p_pl_ordr_num in number default hr_api.g_number

Line 1123: ,p_yr_perd_id in number default hr_api.g_number

1119: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1120: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1121: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1122: ,p_per_in_ler_id in number default hr_api.g_number
1123: ,p_yr_perd_id in number default hr_api.g_number
1124: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1125: ,p_business_group_id in number default hr_api.g_number
1126: ,p_pl_ordr_num in number default hr_api.g_number
1127: ,p_plip_ordr_num in number default hr_api.g_number

Line 1124: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2

1120: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1121: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1122: ,p_per_in_ler_id in number default hr_api.g_number
1123: ,p_yr_perd_id in number default hr_api.g_number
1124: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1125: ,p_business_group_id in number default hr_api.g_number
1126: ,p_pl_ordr_num in number default hr_api.g_number
1127: ,p_plip_ordr_num in number default hr_api.g_number
1128: ,p_ptip_ordr_num in number default hr_api.g_number

Line 1125: ,p_business_group_id in number default hr_api.g_number

1121: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1122: ,p_per_in_ler_id in number default hr_api.g_number
1123: ,p_yr_perd_id in number default hr_api.g_number
1124: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1125: ,p_business_group_id in number default hr_api.g_number
1126: ,p_pl_ordr_num in number default hr_api.g_number
1127: ,p_plip_ordr_num in number default hr_api.g_number
1128: ,p_ptip_ordr_num in number default hr_api.g_number
1129: ,p_oipl_ordr_num in number default hr_api.g_number

Line 1126: ,p_pl_ordr_num in number default hr_api.g_number

1122: ,p_per_in_ler_id in number default hr_api.g_number
1123: ,p_yr_perd_id in number default hr_api.g_number
1124: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1125: ,p_business_group_id in number default hr_api.g_number
1126: ,p_pl_ordr_num in number default hr_api.g_number
1127: ,p_plip_ordr_num in number default hr_api.g_number
1128: ,p_ptip_ordr_num in number default hr_api.g_number
1129: ,p_oipl_ordr_num in number default hr_api.g_number
1130: ,p_comments in varchar2 default hr_api.g_varchar2

Line 1127: ,p_plip_ordr_num in number default hr_api.g_number

1123: ,p_yr_perd_id in number default hr_api.g_number
1124: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1125: ,p_business_group_id in number default hr_api.g_number
1126: ,p_pl_ordr_num in number default hr_api.g_number
1127: ,p_plip_ordr_num in number default hr_api.g_number
1128: ,p_ptip_ordr_num in number default hr_api.g_number
1129: ,p_oipl_ordr_num in number default hr_api.g_number
1130: ,p_comments in varchar2 default hr_api.g_varchar2
1131: ,p_elig_flag in varchar2 default hr_api.g_varchar2

Line 1128: ,p_ptip_ordr_num in number default hr_api.g_number

1124: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1125: ,p_business_group_id in number default hr_api.g_number
1126: ,p_pl_ordr_num in number default hr_api.g_number
1127: ,p_plip_ordr_num in number default hr_api.g_number
1128: ,p_ptip_ordr_num in number default hr_api.g_number
1129: ,p_oipl_ordr_num in number default hr_api.g_number
1130: ,p_comments in varchar2 default hr_api.g_varchar2
1131: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1132: ,p_elig_ovrid_dt in date default hr_api.g_date

Line 1129: ,p_oipl_ordr_num in number default hr_api.g_number

1125: ,p_business_group_id in number default hr_api.g_number
1126: ,p_pl_ordr_num in number default hr_api.g_number
1127: ,p_plip_ordr_num in number default hr_api.g_number
1128: ,p_ptip_ordr_num in number default hr_api.g_number
1129: ,p_oipl_ordr_num in number default hr_api.g_number
1130: ,p_comments in varchar2 default hr_api.g_varchar2
1131: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1132: ,p_elig_ovrid_dt in date default hr_api.g_date
1133: ,p_elig_ovrid_person_id in number default hr_api.g_number

Line 1130: ,p_comments in varchar2 default hr_api.g_varchar2

1126: ,p_pl_ordr_num in number default hr_api.g_number
1127: ,p_plip_ordr_num in number default hr_api.g_number
1128: ,p_ptip_ordr_num in number default hr_api.g_number
1129: ,p_oipl_ordr_num in number default hr_api.g_number
1130: ,p_comments in varchar2 default hr_api.g_varchar2
1131: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1132: ,p_elig_ovrid_dt in date default hr_api.g_date
1133: ,p_elig_ovrid_person_id in number default hr_api.g_number
1134: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2

Line 1131: ,p_elig_flag in varchar2 default hr_api.g_varchar2

1127: ,p_plip_ordr_num in number default hr_api.g_number
1128: ,p_ptip_ordr_num in number default hr_api.g_number
1129: ,p_oipl_ordr_num in number default hr_api.g_number
1130: ,p_comments in varchar2 default hr_api.g_varchar2
1131: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1132: ,p_elig_ovrid_dt in date default hr_api.g_date
1133: ,p_elig_ovrid_person_id in number default hr_api.g_number
1134: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1135: ,p_mgr_ovrid_dt in date default hr_api.g_date

Line 1132: ,p_elig_ovrid_dt in date default hr_api.g_date

1128: ,p_ptip_ordr_num in number default hr_api.g_number
1129: ,p_oipl_ordr_num in number default hr_api.g_number
1130: ,p_comments in varchar2 default hr_api.g_varchar2
1131: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1132: ,p_elig_ovrid_dt in date default hr_api.g_date
1133: ,p_elig_ovrid_person_id in number default hr_api.g_number
1134: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1135: ,p_mgr_ovrid_dt in date default hr_api.g_date
1136: ,p_mgr_ovrid_person_id in number default hr_api.g_number

Line 1133: ,p_elig_ovrid_person_id in number default hr_api.g_number

1129: ,p_oipl_ordr_num in number default hr_api.g_number
1130: ,p_comments in varchar2 default hr_api.g_varchar2
1131: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1132: ,p_elig_ovrid_dt in date default hr_api.g_date
1133: ,p_elig_ovrid_person_id in number default hr_api.g_number
1134: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1135: ,p_mgr_ovrid_dt in date default hr_api.g_date
1136: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1137: ,p_ws_mgr_id in number default hr_api.g_number

Line 1134: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2

1130: ,p_comments in varchar2 default hr_api.g_varchar2
1131: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1132: ,p_elig_ovrid_dt in date default hr_api.g_date
1133: ,p_elig_ovrid_person_id in number default hr_api.g_number
1134: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1135: ,p_mgr_ovrid_dt in date default hr_api.g_date
1136: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1137: ,p_ws_mgr_id in number default hr_api.g_number
1138: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2

Line 1135: ,p_mgr_ovrid_dt in date default hr_api.g_date

1131: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1132: ,p_elig_ovrid_dt in date default hr_api.g_date
1133: ,p_elig_ovrid_person_id in number default hr_api.g_number
1134: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1135: ,p_mgr_ovrid_dt in date default hr_api.g_date
1136: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1137: ,p_ws_mgr_id in number default hr_api.g_number
1138: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1139: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2

Line 1136: ,p_mgr_ovrid_person_id in number default hr_api.g_number

1132: ,p_elig_ovrid_dt in date default hr_api.g_date
1133: ,p_elig_ovrid_person_id in number default hr_api.g_number
1134: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1135: ,p_mgr_ovrid_dt in date default hr_api.g_date
1136: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1137: ,p_ws_mgr_id in number default hr_api.g_number
1138: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1139: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1140: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2

Line 1137: ,p_ws_mgr_id in number default hr_api.g_number

1133: ,p_elig_ovrid_person_id in number default hr_api.g_number
1134: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1135: ,p_mgr_ovrid_dt in date default hr_api.g_date
1136: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1137: ,p_ws_mgr_id in number default hr_api.g_number
1138: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1139: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1140: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1141: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2

Line 1138: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2

1134: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1135: ,p_mgr_ovrid_dt in date default hr_api.g_date
1136: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1137: ,p_ws_mgr_id in number default hr_api.g_number
1138: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1139: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1140: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1141: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1142: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2

Line 1139: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2

1135: ,p_mgr_ovrid_dt in date default hr_api.g_date
1136: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1137: ,p_ws_mgr_id in number default hr_api.g_number
1138: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1139: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1140: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1141: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1142: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1143: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2

Line 1140: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2

1136: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1137: ,p_ws_mgr_id in number default hr_api.g_number
1138: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1139: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1140: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1141: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1142: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1143: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1144: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2

Line 1141: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2

1137: ,p_ws_mgr_id in number default hr_api.g_number
1138: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1139: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1140: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1141: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1142: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1143: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1144: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1145: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2

Line 1142: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2

1138: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1139: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1140: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1141: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1142: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1143: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1144: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1145: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1146: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2

Line 1143: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2

1139: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1140: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1141: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1142: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1143: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1144: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1145: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1146: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1147: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2

Line 1144: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2

1140: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1141: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1142: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1143: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1144: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1145: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1146: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1147: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1148: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2

Line 1145: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2

1141: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1142: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1143: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1144: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1145: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1146: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1147: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1148: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1149: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2

Line 1146: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2

1142: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1143: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1144: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1145: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1146: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1147: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1148: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1149: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1150: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2

Line 1147: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2

1143: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1144: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1145: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1146: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1147: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1148: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1149: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1150: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1151: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2

Line 1148: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2

1144: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1145: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1146: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1147: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1148: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1149: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1150: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1151: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1152: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2

Line 1149: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2

1145: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1146: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1147: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1148: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1149: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1150: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1151: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1152: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1153: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2

Line 1150: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2

1146: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1147: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1148: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1149: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1150: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1151: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1152: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1153: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1154: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2

Line 1151: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2

1147: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1148: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1149: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1150: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1151: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1152: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1153: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1154: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1155: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2

Line 1152: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2

1148: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1149: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1150: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1151: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1152: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1153: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1154: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1155: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1156: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2

Line 1153: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2

1149: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1150: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1151: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1152: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1153: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1154: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1155: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1156: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1157: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2

Line 1154: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2

1150: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1151: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1152: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1153: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1154: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1155: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1156: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1157: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1158: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2

Line 1155: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2

1151: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1152: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1153: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1154: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1155: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1156: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1157: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1158: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1159: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2

Line 1156: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2

1152: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1153: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1154: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1155: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1156: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1157: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1158: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1159: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1160: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2

Line 1157: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2

1153: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1154: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1155: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1156: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1157: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1158: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1159: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1160: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1161: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2

Line 1158: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2

1154: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1155: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1156: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1157: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1158: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1159: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1160: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1161: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1162: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2

Line 1159: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2

1155: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1156: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1157: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1158: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1159: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1160: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1161: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1162: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1163: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2

Line 1160: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2

1156: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1157: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1158: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1159: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1160: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1161: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1162: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1163: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1164: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2

Line 1161: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2

1157: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1158: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1159: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1160: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1161: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1162: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1163: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1164: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1165: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2

Line 1162: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2

1158: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1159: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1160: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1161: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1162: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1163: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1164: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1165: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1166: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2

Line 1163: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2

1159: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1160: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1161: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1162: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1163: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1164: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1165: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1166: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1167: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2

Line 1164: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2

1160: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1161: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1162: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1163: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1164: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1165: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1166: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1167: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1168: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2

Line 1165: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2

1161: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1162: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1163: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1164: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1165: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1166: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1167: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1168: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1169: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2

Line 1166: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2

1162: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1163: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1164: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1165: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1166: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1167: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1168: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1169: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1170: ,p_request_id in number default hr_api.g_number

Line 1167: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2

1163: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1164: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1165: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1166: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1167: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1168: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1169: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1170: ,p_request_id in number default hr_api.g_number
1171: ,p_program_application_id in number default hr_api.g_number

Line 1168: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2

1164: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1165: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1166: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1167: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1168: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1169: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1170: ,p_request_id in number default hr_api.g_number
1171: ,p_program_application_id in number default hr_api.g_number
1172: ,p_program_id in number default hr_api.g_number

Line 1169: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2

1165: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1166: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1167: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1168: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1169: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1170: ,p_request_id in number default hr_api.g_number
1171: ,p_program_application_id in number default hr_api.g_number
1172: ,p_program_id in number default hr_api.g_number
1173: ,p_program_update_date in date default hr_api.g_date

Line 1170: ,p_request_id in number default hr_api.g_number

1166: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1167: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1168: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1169: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1170: ,p_request_id in number default hr_api.g_number
1171: ,p_program_application_id in number default hr_api.g_number
1172: ,p_program_id in number default hr_api.g_number
1173: ,p_program_update_date in date default hr_api.g_date
1174: ,p_object_version_number in out nocopy number

Line 1171: ,p_program_application_id in number default hr_api.g_number

1167: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1168: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1169: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1170: ,p_request_id in number default hr_api.g_number
1171: ,p_program_application_id in number default hr_api.g_number
1172: ,p_program_id in number default hr_api.g_number
1173: ,p_program_update_date in date default hr_api.g_date
1174: ,p_object_version_number in out nocopy number
1175: ,p_effective_date in date

Line 1172: ,p_program_id in number default hr_api.g_number

1168: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1169: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1170: ,p_request_id in number default hr_api.g_number
1171: ,p_program_application_id in number default hr_api.g_number
1172: ,p_program_id in number default hr_api.g_number
1173: ,p_program_update_date in date default hr_api.g_date
1174: ,p_object_version_number in out nocopy number
1175: ,p_effective_date in date
1176: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2

Line 1173: ,p_program_update_date in date default hr_api.g_date

1169: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1170: ,p_request_id in number default hr_api.g_number
1171: ,p_program_application_id in number default hr_api.g_number
1172: ,p_program_id in number default hr_api.g_number
1173: ,p_program_update_date in date default hr_api.g_date
1174: ,p_object_version_number in out nocopy number
1175: ,p_effective_date in date
1176: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1177: ,p_return_status out nocopy varchar2

Line 1176: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2

1172: ,p_program_id in number default hr_api.g_number
1173: ,p_program_update_date in date default hr_api.g_date
1174: ,p_object_version_number in out nocopy number
1175: ,p_effective_date in date
1176: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1177: ,p_return_status out nocopy varchar2
1178: ) is
1179: --
1180: -- Variables for API Boolean parameters

Line 1206: hr_api.constant_to_boolean

1202: --
1203: -- Convert constant values to their corresponding boolean value
1204: --
1205: l_validate :=
1206: hr_api.constant_to_boolean
1207: (p_constant_value => p_validate);
1208: --
1209: -- Register Surrogate ID or user key values
1210: --

Line 1365: ,p_validate in number default hr_api.g_false_num

1361: procedure process_api
1362: (
1363: p_document in CLOB
1364: ,p_return_status out nocopy VARCHAR2
1365: ,p_validate in number default hr_api.g_false_num
1366: ,p_effective_date in date default null
1367: )
1368: IS
1369: l_postState VARCHAR2(2);