eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_EVALUATE_INCLUSION dependencies on BEN_PRTT_ENRT_RSLT_F

Line 2652: (p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type,

2648: -----------------------------------------------------------------------------
2649: -- The following procedure evaluates plan id.
2650: --
2651: Procedure chk_enrt_plan_incl
2652: (p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type,
2653: p_excld_flag in varchar2)
2654: is
2655: --
2656: l_proc varchar2(72);

Line 2704: (p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type,

2700: -----------------------------------------------------------------------------
2701: -- The following procedure evaluates plans of a particular reporting group id.
2702: --
2703: Procedure chk_enrt_rg_plan_incl
2704: (p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type,
2705: p_excld_flag in varchar2)
2706: is
2707: --
2708: l_proc varchar2(72);

Line 2756: (p_sspndd_flag in ben_prtt_enrt_rslt_f.sspndd_flag%type,

2752: -----------------------------------------------------------------------------
2753: -- The following procedure evaluates plans of a particular reporting group id.
2754: --
2755: Procedure chk_enrt_sspndd_incl
2756: (p_sspndd_flag in ben_prtt_enrt_rslt_f.sspndd_flag%type,
2757: p_excld_flag in varchar2)
2758: is
2759: --
2760: l_proc varchar2(72);

Line 2810: (p_enrt_cvg_strt_dt in ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type,

2806: -----------------------------------------------------------------------------
2807: -- The following procedure evaluates enrt_cvg_strt_dt id.
2808: --
2809: Procedure chk_enrt_cvg_strt_dt_incl
2810: (p_enrt_cvg_strt_dt in ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type,
2811: p_effective_date in date,
2812: p_excld_flag in varchar2,
2813: p_pl_id in number default null )
2814: is

Line 2876: (p_enrt_cvg_strt_dt in ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type,

2872: -- The following procedure evaluates if a person was covered any time during
2873: -- a period.
2874: --
2875: Procedure chk_enrt_cvg_drng_perd_incl
2876: (p_enrt_cvg_strt_dt in ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type,
2877: p_enrt_cvg_thru_dt in ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type,
2878: p_effective_date in date,
2879: p_excld_flag in varchar2,
2880: p_pl_id in number default null )

Line 2877: p_enrt_cvg_thru_dt in ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type,

2873: -- a period.
2874: --
2875: Procedure chk_enrt_cvg_drng_perd_incl
2876: (p_enrt_cvg_strt_dt in ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type,
2877: p_enrt_cvg_thru_dt in ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type,
2878: p_effective_date in date,
2879: p_excld_flag in varchar2,
2880: p_pl_id in number default null )
2881: is

Line 2947: (p_prtt_enrt_rslt_stat_cd in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%type,

2943: -----------------------------------------------------------------------------
2944: -- The following procedure evaluates enrollment status code.
2945: --
2946: Procedure chk_enrt_stat_incl
2947: (p_prtt_enrt_rslt_stat_cd in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%type,
2948: p_excld_flag in varchar2)
2949: is
2950: --
2951: l_proc varchar2(72);

Line 3001: (p_enrt_mthd_cd in ben_prtt_enrt_rslt_f.enrt_mthd_cd%type,

2997: -----------------------------------------------------------------------------
2998: -- The following procedure evaluates enrollment method
2999: --
3000: Procedure chk_enrt_mthd_incl
3001: (p_enrt_mthd_cd in ben_prtt_enrt_rslt_f.enrt_mthd_cd%type,
3002: p_excld_flag in varchar2)
3003: is
3004: --
3005: l_proc varchar2(72);

Line 3055: (p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type,

3051: -----------------------------------------------------------------------------
3052: -- The following procedure evaluates pgm id.
3053: --
3054: Procedure chk_enrt_pgm_incl
3055: (p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type,
3056: p_excld_flag in varchar2)
3057: is
3058: --
3059: l_proc varchar2(72);

Line 3105: (p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type,

3101: -----------------------------------------------------------------------------
3102: -- The following procedure evaluates pl_typ id.
3103: --
3104: Procedure chk_enrt_pl_typ_incl
3105: (p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type,
3106: p_excld_flag in varchar2)
3107: is
3108: --
3109: l_proc varchar2(72);

Line 3155: (p_last_update_date in ben_prtt_enrt_rslt_f.last_update_date%type,

3151: -----------------------------------------------------------------------------
3152: -- The following procedure evaluates enrt_last_upd_dt id.
3153: --
3154: Procedure chk_enrt_last_upd_dt_incl
3155: (p_last_update_date in ben_prtt_enrt_rslt_f.last_update_date%type,
3156: p_effective_date in date,
3157: p_excld_flag in varchar2 ,
3158: p_pl_id in number default null )
3159: is

Line 3450: (p_per_in_ler_id in ben_prtt_enrt_rslt_f.per_in_ler_id%type,

3446: -- The following procedure evaluates the relationships between enrtollment
3447: -- dependent
3448: --
3449: Procedure chk_enrt_dpnt_rltn_incl
3450: (p_per_in_ler_id in ben_prtt_enrt_rslt_f.per_in_ler_id%type,
3451: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type,
3452: p_dpnt_person_id in number,
3453: p_effective_date in date,
3454: p_excld_flag in varchar2) is

Line 3451: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type,

3447: -- dependent
3448: --
3449: Procedure chk_enrt_dpnt_rltn_incl
3450: (p_per_in_ler_id in ben_prtt_enrt_rslt_f.per_in_ler_id%type,
3451: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type,
3452: p_dpnt_person_id in number,
3453: p_effective_date in date,
3454: p_excld_flag in varchar2) is
3455:

Line 3505: (p_per_in_ler_id in ben_prtt_enrt_rslt_f.per_in_ler_id%type,

3501: -- The following procedure evaluates the relationships between enrtollment
3502: -- results and other tables.
3503: --
3504: Procedure chk_enrt_rltn_incl
3505: (p_per_in_ler_id in ben_prtt_enrt_rslt_f.per_in_ler_id%type,
3506: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type,
3507: p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type,
3508: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type,
3509: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type,

Line 3506: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type,

3502: -- results and other tables.
3503: --
3504: Procedure chk_enrt_rltn_incl
3505: (p_per_in_ler_id in ben_prtt_enrt_rslt_f.per_in_ler_id%type,
3506: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type,
3507: p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type,
3508: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type,
3509: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type,
3510: p_effective_date in date,

Line 3507: p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type,

3503: --
3504: Procedure chk_enrt_rltn_incl
3505: (p_per_in_ler_id in ben_prtt_enrt_rslt_f.per_in_ler_id%type,
3506: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type,
3507: p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type,
3508: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type,
3509: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type,
3510: p_effective_date in date,
3511: p_excld_flag in varchar2)

Line 3508: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type,

3504: Procedure chk_enrt_rltn_incl
3505: (p_per_in_ler_id in ben_prtt_enrt_rslt_f.per_in_ler_id%type,
3506: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type,
3507: p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type,
3508: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type,
3509: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type,
3510: p_effective_date in date,
3511: p_excld_flag in varchar2)
3512: is

Line 3509: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type,

3505: (p_per_in_ler_id in ben_prtt_enrt_rslt_f.per_in_ler_id%type,
3506: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type,
3507: p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type,
3508: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type,
3509: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type,
3510: p_effective_date in date,
3511: p_excld_flag in varchar2)
3512: is
3513: --

Line 4291: (p_per_in_ler_id in ben_prtt_enrt_rslt_f.per_in_ler_id%type,

4287: -- The following procedure evaluates the relationships between enrtollment
4288: -- results and other tables.
4289: --
4290: Procedure chk_elct_rltn_incl
4291: (p_per_in_ler_id in ben_prtt_enrt_rslt_f.per_in_ler_id%type,
4292: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type,
4293: p_excld_flag in varchar2)
4294: is
4295: --

Line 4292: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type,

4288: -- results and other tables.
4289: --
4290: Procedure chk_elct_rltn_incl
4291: (p_per_in_ler_id in ben_prtt_enrt_rslt_f.per_in_ler_id%type,
4292: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type,
4293: p_excld_flag in varchar2)
4294: is
4295: --
4296: l_proc varchar2(72);

Line 6319: (p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type default null,

6315: --
6316: -- The following procedure evaluates person inclusion criteria
6317: --
6318: Procedure evaluate_benefit_incl
6319: (p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type default null,
6320: p_sspndd_flag in ben_prtt_enrt_rslt_f.sspndd_flag%type default null,
6321: p_enrt_cvg_strt_dt in ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type default null,
6322: p_enrt_cvg_thru_dt in ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type default null,
6323: p_prtt_enrt_rslt_stat_cd in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%type default null,

Line 6320: p_sspndd_flag in ben_prtt_enrt_rslt_f.sspndd_flag%type default null,

6316: -- The following procedure evaluates person inclusion criteria
6317: --
6318: Procedure evaluate_benefit_incl
6319: (p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type default null,
6320: p_sspndd_flag in ben_prtt_enrt_rslt_f.sspndd_flag%type default null,
6321: p_enrt_cvg_strt_dt in ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type default null,
6322: p_enrt_cvg_thru_dt in ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type default null,
6323: p_prtt_enrt_rslt_stat_cd in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%type default null,
6324: p_enrt_mthd_cd in ben_prtt_enrt_rslt_f.enrt_mthd_cd%type default null,

Line 6321: p_enrt_cvg_strt_dt in ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type default null,

6317: --
6318: Procedure evaluate_benefit_incl
6319: (p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type default null,
6320: p_sspndd_flag in ben_prtt_enrt_rslt_f.sspndd_flag%type default null,
6321: p_enrt_cvg_strt_dt in ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type default null,
6322: p_enrt_cvg_thru_dt in ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type default null,
6323: p_prtt_enrt_rslt_stat_cd in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%type default null,
6324: p_enrt_mthd_cd in ben_prtt_enrt_rslt_f.enrt_mthd_cd%type default null,
6325: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type default null,

Line 6322: p_enrt_cvg_thru_dt in ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type default null,

6318: Procedure evaluate_benefit_incl
6319: (p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type default null,
6320: p_sspndd_flag in ben_prtt_enrt_rslt_f.sspndd_flag%type default null,
6321: p_enrt_cvg_strt_dt in ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type default null,
6322: p_enrt_cvg_thru_dt in ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type default null,
6323: p_prtt_enrt_rslt_stat_cd in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%type default null,
6324: p_enrt_mthd_cd in ben_prtt_enrt_rslt_f.enrt_mthd_cd%type default null,
6325: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type default null,
6326: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type default null,

Line 6323: p_prtt_enrt_rslt_stat_cd in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%type default null,

6319: (p_pl_id in ben_prtt_enrt_rslt_f.pl_id%type default null,
6320: p_sspndd_flag in ben_prtt_enrt_rslt_f.sspndd_flag%type default null,
6321: p_enrt_cvg_strt_dt in ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type default null,
6322: p_enrt_cvg_thru_dt in ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type default null,
6323: p_prtt_enrt_rslt_stat_cd in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%type default null,
6324: p_enrt_mthd_cd in ben_prtt_enrt_rslt_f.enrt_mthd_cd%type default null,
6325: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type default null,
6326: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type default null,
6327: p_opt_id in ben_opt_f.opt_id%type default null,

Line 6324: p_enrt_mthd_cd in ben_prtt_enrt_rslt_f.enrt_mthd_cd%type default null,

6320: p_sspndd_flag in ben_prtt_enrt_rslt_f.sspndd_flag%type default null,
6321: p_enrt_cvg_strt_dt in ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type default null,
6322: p_enrt_cvg_thru_dt in ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type default null,
6323: p_prtt_enrt_rslt_stat_cd in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%type default null,
6324: p_enrt_mthd_cd in ben_prtt_enrt_rslt_f.enrt_mthd_cd%type default null,
6325: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type default null,
6326: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type default null,
6327: p_opt_id in ben_opt_f.opt_id%type default null,
6328: p_last_update_date in ben_prtt_enrt_rslt_f.last_update_date%type default null,

Line 6325: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type default null,

6321: p_enrt_cvg_strt_dt in ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type default null,
6322: p_enrt_cvg_thru_dt in ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type default null,
6323: p_prtt_enrt_rslt_stat_cd in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%type default null,
6324: p_enrt_mthd_cd in ben_prtt_enrt_rslt_f.enrt_mthd_cd%type default null,
6325: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type default null,
6326: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type default null,
6327: p_opt_id in ben_opt_f.opt_id%type default null,
6328: p_last_update_date in ben_prtt_enrt_rslt_f.last_update_date%type default null,
6329: p_ler_id in ben_per_in_ler.ler_id%type default null,

Line 6326: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type default null,

6322: p_enrt_cvg_thru_dt in ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt%type default null,
6323: p_prtt_enrt_rslt_stat_cd in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd%type default null,
6324: p_enrt_mthd_cd in ben_prtt_enrt_rslt_f.enrt_mthd_cd%type default null,
6325: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type default null,
6326: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type default null,
6327: p_opt_id in ben_opt_f.opt_id%type default null,
6328: p_last_update_date in ben_prtt_enrt_rslt_f.last_update_date%type default null,
6329: p_ler_id in ben_per_in_ler.ler_id%type default null,
6330: p_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,

Line 6328: p_last_update_date in ben_prtt_enrt_rslt_f.last_update_date%type default null,

6324: p_enrt_mthd_cd in ben_prtt_enrt_rslt_f.enrt_mthd_cd%type default null,
6325: p_pgm_id in ben_prtt_enrt_rslt_f.pgm_id%type default null,
6326: p_pl_typ_id in ben_prtt_enrt_rslt_f.pl_typ_id%type default null,
6327: p_opt_id in ben_opt_f.opt_id%type default null,
6328: p_last_update_date in ben_prtt_enrt_rslt_f.last_update_date%type default null,
6329: p_ler_id in ben_per_in_ler.ler_id%type default null,
6330: p_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,
6331: p_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,
6332: p_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,

Line 6334: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type default null,

6330: p_ntfn_dt in ben_per_in_ler.ntfn_dt%type default null,
6331: p_lf_evt_ocrd_dt in ben_per_in_ler.lf_evt_ocrd_dt%type default null,
6332: p_per_in_ler_stat_cd in ben_per_in_ler.per_in_ler_stat_cd%type default null,
6333: p_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type default null,
6334: p_prtt_enrt_rslt_id in ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type default null,
6335: p_effective_date in date default null,
6336: p_dpnt_id in number default null,
6337: p_include out nocopy varchar2)
6338: is