DBA Data[Home] [Help]

APPS.BEN_EXT_EVALUATE_INCLUSION dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 3672: (p_pl_id in ben_elig_per_elctbl_chc.pl_id%type,

3668: -----------------------------------------------------------------------------
3669: -- The following procedure evaluates plan id.
3670: --
3671: Procedure chk_elct_plan_incl
3672: (p_pl_id in ben_elig_per_elctbl_chc.pl_id%type,
3673: p_excld_flag in varchar2)
3674: is
3675: --
3676: l_proc varchar2(72);

Line 3725: (p_pl_id in ben_elig_per_elctbl_chc.pl_id%type,

3721: -----------------------------------------------------------------------------
3722: -- The following procedure evaluates plans of a particular reporting group id.
3723: --
3724: Procedure chk_elct_rg_plan_incl
3725: (p_pl_id in ben_elig_per_elctbl_chc.pl_id%type,
3726: p_excld_flag in varchar2)
3727: is
3728: --
3729: l_proc varchar2(72);

Line 3777: (p_elct_enrt_strt_dt in ben_elig_per_elctbl_chc.enrt_cvg_strt_dt%type,

3773: -----------------------------------------------------------------------------
3774: -- The following procedure evaluates elct_enrt_strt_dt id.
3775: --
3776: Procedure chk_elct_enrt_strt_dt_incl
3777: (p_elct_enrt_strt_dt in ben_elig_per_elctbl_chc.enrt_cvg_strt_dt%type,
3778: p_effective_date in date,
3779: p_excld_flag in varchar2 ,
3780: p_pl_id in number default null )
3781: is

Line 3841: (p_pgm_id in ben_elig_per_elctbl_chc.pgm_id%type,

3837: -----------------------------------------------------------------------------
3838: -- The following procedure evaluates pgm id.
3839: --
3840: Procedure chk_elct_pgm_incl
3841: (p_pgm_id in ben_elig_per_elctbl_chc.pgm_id%type,
3842: p_excld_flag in varchar2)
3843: is
3844: --
3845: l_proc varchar2(72);

Line 3892: (p_pl_typ_id in ben_elig_per_elctbl_chc.pl_typ_id%type,

3888: -----------------------------------------------------------------------------
3889: -- The following procedure evaluates pl_typ id.
3890: --
3891: Procedure chk_elct_pl_typ_incl
3892: (p_pl_typ_id in ben_elig_per_elctbl_chc.pl_typ_id%type,
3893: p_excld_flag in varchar2)
3894: is
3895: --
3896: l_proc varchar2(72);

Line 3943: (p_last_update_date in ben_elig_per_elctbl_chc.last_update_date%type,

3939: -----------------------------------------------------------------------------
3940: -- The following procedure evaluates elct_last_upd_dt id.
3941: --
3942: Procedure chk_elct_last_upd_dt_incl
3943: (p_last_update_date in ben_elig_per_elctbl_chc.last_update_date%type,
3944: p_effective_date in date,
3945: p_excld_flag in varchar2,
3946: p_pl_id in number default null )
3947: is

Line 4110: (p_yrprd_id in ben_elig_per_elctbl_chc.yr_perd_id%type,

4106: -----------------------------------------------------------------------------
4107: -- The following procedure evaluates year period
4108: --
4109: Procedure chk_elct_yrprd_incl
4110: (p_yrprd_id in ben_elig_per_elctbl_chc.yr_perd_id%type,
4111: p_excld_flag in varchar2)
4112: is
4113: --
4114: l_proc varchar2(72);

Line 6478: (p_elct_pl_id in ben_elig_per_elctbl_chc.pl_id%type default null,

6474: --
6475: -- The following procedure evaluates person inclusion criteria
6476: --
6477: Procedure evaluate_eligibility_incl
6478: (p_elct_pl_id in ben_elig_per_elctbl_chc.pl_id%type default null,
6479: p_elct_enrt_strt_dt in ben_elig_per_elctbl_chc.enrt_cvg_strt_dt%type default null,
6480: p_elct_yrprd_id in ben_elig_per_elctbl_chc.yr_perd_id%type default null,
6481: p_elct_pgm_id in ben_elig_per_elctbl_chc.pgm_id%type default null,
6482: p_elct_pl_typ_id in ben_elig_per_elctbl_chc.pl_typ_id%type default null,

Line 6479: p_elct_enrt_strt_dt in ben_elig_per_elctbl_chc.enrt_cvg_strt_dt%type default null,

6475: -- The following procedure evaluates person inclusion criteria
6476: --
6477: Procedure evaluate_eligibility_incl
6478: (p_elct_pl_id in ben_elig_per_elctbl_chc.pl_id%type default null,
6479: p_elct_enrt_strt_dt in ben_elig_per_elctbl_chc.enrt_cvg_strt_dt%type default null,
6480: p_elct_yrprd_id in ben_elig_per_elctbl_chc.yr_perd_id%type default null,
6481: p_elct_pgm_id in ben_elig_per_elctbl_chc.pgm_id%type default null,
6482: p_elct_pl_typ_id in ben_elig_per_elctbl_chc.pl_typ_id%type default null,
6483: p_elct_opt_id in ben_opt_f.opt_id%type default null,

Line 6480: p_elct_yrprd_id in ben_elig_per_elctbl_chc.yr_perd_id%type default null,

6476: --
6477: Procedure evaluate_eligibility_incl
6478: (p_elct_pl_id in ben_elig_per_elctbl_chc.pl_id%type default null,
6479: p_elct_enrt_strt_dt in ben_elig_per_elctbl_chc.enrt_cvg_strt_dt%type default null,
6480: p_elct_yrprd_id in ben_elig_per_elctbl_chc.yr_perd_id%type default null,
6481: p_elct_pgm_id in ben_elig_per_elctbl_chc.pgm_id%type default null,
6482: p_elct_pl_typ_id in ben_elig_per_elctbl_chc.pl_typ_id%type default null,
6483: p_elct_opt_id in ben_opt_f.opt_id%type default null,
6484: p_elct_last_upd_dt in ben_elig_per_elctbl_chc.last_update_date%type default null,

Line 6481: p_elct_pgm_id in ben_elig_per_elctbl_chc.pgm_id%type default null,

6477: Procedure evaluate_eligibility_incl
6478: (p_elct_pl_id in ben_elig_per_elctbl_chc.pl_id%type default null,
6479: p_elct_enrt_strt_dt in ben_elig_per_elctbl_chc.enrt_cvg_strt_dt%type default null,
6480: p_elct_yrprd_id in ben_elig_per_elctbl_chc.yr_perd_id%type default null,
6481: p_elct_pgm_id in ben_elig_per_elctbl_chc.pgm_id%type default null,
6482: p_elct_pl_typ_id in ben_elig_per_elctbl_chc.pl_typ_id%type default null,
6483: p_elct_opt_id in ben_opt_f.opt_id%type default null,
6484: p_elct_last_upd_dt in ben_elig_per_elctbl_chc.last_update_date%type default null,
6485: p_elct_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,

Line 6482: p_elct_pl_typ_id in ben_elig_per_elctbl_chc.pl_typ_id%type default null,

6478: (p_elct_pl_id in ben_elig_per_elctbl_chc.pl_id%type default null,
6479: p_elct_enrt_strt_dt in ben_elig_per_elctbl_chc.enrt_cvg_strt_dt%type default null,
6480: p_elct_yrprd_id in ben_elig_per_elctbl_chc.yr_perd_id%type default null,
6481: p_elct_pgm_id in ben_elig_per_elctbl_chc.pgm_id%type default null,
6482: p_elct_pl_typ_id in ben_elig_per_elctbl_chc.pl_typ_id%type default null,
6483: p_elct_opt_id in ben_opt_f.opt_id%type default null,
6484: p_elct_last_upd_dt in ben_elig_per_elctbl_chc.last_update_date%type default null,
6485: p_elct_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,
6486: p_elct_ler_id in ben_per_in_ler.ler_id%type default null,

Line 6484: p_elct_last_upd_dt in ben_elig_per_elctbl_chc.last_update_date%type default null,

6480: p_elct_yrprd_id in ben_elig_per_elctbl_chc.yr_perd_id%type default null,
6481: p_elct_pgm_id in ben_elig_per_elctbl_chc.pgm_id%type default null,
6482: p_elct_pl_typ_id in ben_elig_per_elctbl_chc.pl_typ_id%type default null,
6483: p_elct_opt_id in ben_opt_f.opt_id%type default null,
6484: p_elct_last_upd_dt in ben_elig_per_elctbl_chc.last_update_date%type default null,
6485: p_elct_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,
6486: p_elct_ler_id in ben_per_in_ler.ler_id%type default null,
6487: p_elct_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,
6488: p_elct_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,

Line 6490: p_prtt_enrt_rslt_id in ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type default null,

6486: p_elct_ler_id in ben_per_in_ler.ler_id%type default null,
6487: p_elct_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,
6488: p_elct_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,
6489: p_elct_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,
6490: p_prtt_enrt_rslt_id in ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type default null,
6491: p_effective_date in date default null,
6492: p_include out nocopy varchar2)
6493:
6494: is