1 Package ben_eligibility_override as
2 /* $Header: benovrel.pkh 120.0.12000000.1 2007/01/19 18:39:19 appldev noship $ */
3 --
4 type g_lvl_typ is record (lvl_name varchar2(60),
5 meaning hr_lookups.meaning%type,
6 counter number);
7 type g_rec is table of g_lvl_typ index by binary_integer;
8
9 procedure update_elig_hierarchy
10 (p_person_id in number,
11 p_pgm_id in number,
12 p_ptip_id in number,
13 p_plip_id in number,
14 p_pl_id in number,
15 p_elig_per_id in number,
16 p_elig_flag in varchar2,
17 p_dt_mode in varchar2,
18 p_business_group_id in number,
19 p_per_in_ler_id in number,
20 p_effective_date in date,
21 p_out_mesg out nocopy varchar2);
22
23 procedure create_elig_hierarchy
24 (p_elig_per in ben_elig_per_f%rowtype,
25 p_cobj_level in varchar2,
26 p_dt_mode in varchar2,
27 p_business_group_id in number,
28 p_effective_date in date,
29 p_out_mesg out nocopy varchar2);
30
31 procedure reset_counter_rec;
32
33 function chk_if_enrolled
34 (p_pgm_id in number,
35 p_pl_id in number,
36 p_oipl_id in number,
37 p_business_group_id in number,
38 p_person_id in number,
39 p_effective_date in date)
40 return varchar2;
41
42 End ben_eligibility_override;