1 package ben_evaluate_elig_profiles AUTHID CURRENT_USER as
2 /* $Header: benevlpr.pkh 120.0.12020000.2 2012/07/03 12:36:30 amnaraya ship $ */
3
4 Type profrec is record
5 (eligy_prfl_id number,
6 mndtry_flag varchar2(1),
7 compute_score_flag varchar2(1),
8 trk_scr_for_inelg_flag varchar2(1));
9 Type profTab is Table of profRec index by binary_integer;
10 t_prof_tbl profTab;
11
12 Type scoreRec is Record
13 (eligy_prfl_id number,
14 crit_tab_short_name varchar2(30),
15 crit_tab_pk_id number,
16 computed_score number,
17 benefit_action_id number);
18 Type scoreTab is Table of scoreRec index by binary_integer;
19 t_default_score_tbl scoreTab; --dummy. used as default param only
20
21 g_eligible exception;
22 g_criteria_failed exception;
23 g_skip_profile exception;
24 g_not_eligible exception;
25 g_inelg_rsn_cd varchar2(30);
26
27 l_dpr_rec ben_derive_part_and_rate_facts.g_cache_structure := null;
28
29 procedure write(p_score_tab in out nocopy scoreTab,
30 p_eligy_prfl_id number,
31 p_tab_short_name varchar2,
32 p_pk_id number,
33 p_computed_score number);
34
35 procedure write(p_profile_score_tab in out nocopy scoreTab,
36 p_crit_score_tab in scoreTab);
37
38 -- -----------------------------------------------------------------------------
39 -- |------------------------------< eligible >---------------------------------|
40 -- -----------------------------------------------------------------------------
41 --
42 -- Main function
43 function eligible
44 (p_person_id in number
45 ,p_assignment_id in number default null
46 ,p_business_group_id in number
47 ,p_effective_date in date
48 ,p_eligprof_tab in proftab default t_prof_tbl
49 ,p_vrbl_rt_prfl_id in number default null
50 ,p_lf_evt_ocrd_dt in date default null
51 ,p_dpr_rec in ben_derive_part_and_rate_facts.g_cache_structure default l_dpr_rec
52 ,p_per_in_ler_id in number default null
53 ,p_ler_id in number default null
54 ,p_pgm_id in number default null
55 ,p_ptip_id in number default null
56 ,p_plip_id in number default null
57 ,p_pl_id in number default null
58 ,p_oipl_id in number default null
59 ,p_oiplip_id in number default null
60 ,p_pl_typ_id in number default null
61 ,p_opt_id in number default null
62 ,p_par_pgm_id in number default null
63 ,p_par_plip_id in number default null
64 ,p_par_pl_id in number default null
65 ,p_par_opt_id in number default null
66 ,p_currepe_row in ben_determine_rates.g_curr_epe_rec default ben_determine_rates.g_def_curr_epe_rec
67 ,p_asg_status in varchar2 default 'EMP'
68 ,p_ttl_prtt in number default null
69 ,p_ttl_cvg in number default null
70 ,p_all_prfls in boolean default false
71 ,p_eval_typ in varchar2 default 'E'
72 ,p_comp_obj_mode in boolean default true
73 ,p_source in varchar2 default null
74 ,p_score_tab out nocopy scoreTab
75 ) return boolean;
76
77 end ben_evaluate_elig_profiles;