1 PACKAGE ben_evaluate_dpnt_elg_profiles as
2 /* $Header: bendpelg.pkh 120.0.12010000.2 2008/08/05 14:40:22 ubhat ship $ */
3 -----------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1998 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10
11
12 Name
13 Manage Dependent Eligibility
14 Purpose
15 This package is used to determine if a specific dependent is eligible for
16 a specific electable choice for a participant. It returns the eligibility
17 in the p_dependent_eligible_flag as an out nocopy parameter.
18 History
19 Date Who Version What?
20 ---- --- ------- -----
21 09 Apr 98 M Rosen/JM 110.0 Created.
22 16 Apr 98 M Rosen/JM Added age calulation
23 03 Jun 98 J Mohapatra Replaced age calculation with a new
24 procedure call.
25 21 Dec 98 jcarpent 115.2 added get_elig_change_dt function
26 18 Jan 99 G Perry 115.3 LED V ED
27 31 May 99 S Tee 115.4 New eligibility crteria
28 BEN_DPNT_ANTHR_PL_CVG_F
29 BEN_DSGNTR_ENRLD_CVG_F.
30 30 Aug 99 maagrawa 115.5 Added p_dpnt_inelig_rsn_cd
31 to procedure main.
32 Added p_inelig_rsn_cd
33 to all check procedures.
34 31 Mar 00 maagrawa 115.6 Added optional parameter
35 p_dpnt_cvg_strt_dt.(4929)
36 26 Jun 00 gperry 115.7 Added p_contact_person_id
37 to check_age_elig so that
38 we drive off the correct
39 person for dependent info.
40 27 Apr 08 stee 115.9 Added p_contact_person_id
41 to check_contact_elig
42 - Bug 6956648.
43 */
44 -----------------------------------------------------------------------
45 g_package varchar2(80) := 'bendpelg';
46 --
47 procedure main
48 (p_contact_relationship_id in number,
49 p_contact_person_id in number,
50 p_pgm_id in number default null,
51 p_pl_id in number,
52 p_ptip_id in number default null,
53 p_oipl_id in number default null,
54 p_business_group_id in number,
55 p_per_in_ler_id in number,
56 p_effective_date in date,
57 p_lf_evt_ocrd_dt in date,
58 p_dpnt_cvg_strt_dt in date default null,
59 p_level in varchar2 default null,
60 p_dependent_eligible_flag out nocopy varchar2,
61 p_dpnt_inelig_rsn_cd out nocopy varchar2);
62 --
63 procedure check_age_elig
64 (p_eligy_prfl_id in number,
65 p_person_id in number,
66 p_contact_person_id in number,
67 p_pgm_id in number,
68 p_pl_id in number,
69 p_oipl_id in number,
70 p_business_group_id in number,
71 p_per_in_ler_id in number,
72 p_effective_date in date,
73 p_lf_evt_ocrd_dt in date,
74 p_eligible_flag out nocopy varchar2,
75 p_inelig_rsn_cd out nocopy varchar2) ;
76 --
77 procedure check_marital_elig
78 (p_eligy_prfl_id in number,
79 p_person_id in number,
80 p_business_group_id in number,
81 p_effective_date in date,
82 p_lf_evt_ocrd_dt in date,
83 p_marital_cd in varchar2,
84 p_eligible_flag out nocopy varchar2,
85 p_inelig_rsn_cd out nocopy varchar2) ;
86 --
87 procedure check_military_elig
88 (p_eligy_prfl_id in number,
89 p_person_id in number,
90 p_business_group_id in number,
91 p_effective_date in date,
92 p_lf_evt_ocrd_dt in date,
93 p_military_service in varchar2,
94 p_eligible_flag out nocopy varchar2,
95 p_inelig_rsn_cd out nocopy varchar2) ;
96 --
97 procedure check_student_elig
98 (p_eligy_prfl_id in number,
99 p_person_id in number,
100 p_business_group_id in number,
101 p_effective_date in date,
102 p_lf_evt_ocrd_dt in date,
103 p_student_status in varchar2,
104 p_eligible_flag out nocopy varchar2,
105 p_inelig_rsn_cd out nocopy varchar2) ;
106 --
107 procedure check_contact_elig
108 (p_eligy_prfl_id in number,
109 p_person_id in number,
110 p_contact_person_id in number,
111 p_business_group_id in number,
112 p_effective_date in date,
113 p_lf_evt_ocrd_dt in date,
114 p_contact_type in varchar2,
115 p_eligible_flag out nocopy varchar2,
116 p_inelig_rsn_cd out nocopy varchar2) ;
117 --
118 procedure check_disabled_elig
119 (p_eligy_prfl_id in number,
120 p_person_id in number,
121 p_business_group_id in number,
122 p_effective_date in date,
123 p_lf_evt_ocrd_dt in date,
124 p_per_dsbld_type in varchar2,
125 p_eligible_flag out nocopy varchar2,
126 p_inelig_rsn_cd out nocopy varchar2);
127 --
128 procedure check_postal_elig
129 (p_eligy_prfl_id in number,
130 p_person_id in number,
131 p_business_group_id in number,
132 p_effective_date in date,
133 p_lf_evt_ocrd_dt in date,
134 p_postal_code in varchar2,
135 p_eligible_flag out nocopy varchar2,
136 p_inelig_rsn_cd out nocopy varchar2);
137 --
138 procedure check_cvrd_anthr_pl_elig
139 (p_eligy_prfl_id in number,
140 p_person_id in number,
141 p_business_group_id in number,
142 p_effective_date in date,
143 p_lf_evt_ocrd_dt in date,
144 p_pl_id in number,
145 p_eligible_flag out nocopy varchar2,
146 p_inelig_rsn_cd out nocopy varchar2);
147 --
148 procedure check_dsgntr_enrld_cvg_elig
149 (p_eligy_prfl_id in number,
150 p_person_id in number,
151 p_dsgntr_id in number,
152 p_business_group_id in number,
153 p_effective_date in date,
154 p_lf_evt_ocrd_dt in date,
155 p_pgm_id in number,
156 p_eligible_flag out nocopy varchar2,
157 p_inelig_rsn_cd out nocopy varchar2);
158 --
159 function get_elig_change_dt return date;
160 --
161 END;