1 package ben_enrollment_process AUTHID CURRENT_USER as
2 /* $Header: benenrol.pkh 120.1 2006/05/03 09:38:25 nkkrishn noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1998 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 --
11 Name
12 Enrollment Process
13 Purpose
14 This is a wrapper procedure for Benefits enrollments,
15 dependents and beneficiaries designation for Enrollments conversion,
16 ongoing mass updates.
17 History
18 Date Who Version What?
19 ---- --- ------- -----
20 01 Nov 05 ikasire 115.0 Created
21 02 May 06 nkkrishn 115.11 Fixed Beneficiary upload
22 */
23 --
24 -- --------------------------------------------------------------------------------
25 -- |-----------------------------< ENROLLMENT_INFORMATION >-------------------------|
26 -- -------------------------------------------------------------------------------+
27 procedure enrollment_information_detail
28 (p_validate in boolean default false
29 ,p_pgm_id in number default null
30 ,p_pl_id in number default null
31 ,p_opt_id in number default null
32 ,p_ler_id in number
33 ,p_life_event_date in date
34 ,p_ended_pl_id in number default null
35 ,p_ended_opt_id in number default null
36 ,p_ended_bnft_val in number default null
37 ,p_effective_date in date
38 ,p_person_id in number
39 ,p_bnft_val in number default null
40 ,p_acty_base_rt_id1 in number default null
41 ,p_rt_val1 in number default null
42 ,p_ann_rt_val1 in number default null
43 ,p_rt_strt_dt1 in date default null
44 ,p_rt_end_dt1 in date default null
45 ,p_acty_base_rt_id2 in number default null
46 ,p_rt_val2 in number default null
47 ,p_ann_rt_val2 in number default null
48 ,p_rt_strt_dt2 in date default null
49 ,p_rt_end_dt2 in date default null
50 ,p_acty_base_rt_id3 in number default null
51 ,p_rt_val3 in number default null
52 ,p_ann_rt_val3 in number default null
53 ,p_rt_strt_dt3 in date default null
54 ,p_rt_end_dt3 in date default null
55 ,p_acty_base_rt_id4 in number default null
56 ,p_rt_val4 in number default null
57 ,p_ann_rt_val4 in number default null
58 ,p_rt_strt_dt4 in date default null
59 ,p_rt_end_dt4 in date default null
60 ,p_business_group_id in number
61 ,p_enrt_cvg_strt_dt in date default null
62 ,p_enrt_cvg_thru_dt in date default null
63 ,p_orgnl_enrt_dt in date default null);
64 --
65 -- --------------------------------------------------------------------------------
66 -- |-----------------------------< POST_ENROLLMENT >------------------------------|
67 -- -------------------------------------------------------------------------------+
68 --
69 procedure post_enrollment
70 (p_validate in boolean default false
71 ,p_person_id in number
72 ,p_ler_id in number
73 ,p_life_event_date in date
74 ,p_pgm_id in number default null
75 ,p_pl_id in number default null
76 -- ,p_flx_cr_flag in varchar2 default 'N'
77 ,p_proc_cd in varchar2 default null
78 ,p_business_group_id in number
79 ,p_effective_date in date );
80 --
81 -- --------------------------------------------------------------------------------
82 -- |-----------------------------< ENROLLMENT_INFORMATION >-------------------------|
83 -- -------------------------------------------------------------------------------+
84 procedure create_enrollment
85 (p_validate in boolean default false
86 ,p_pgm_id in number default null
87 ,p_pl_id in number default null
88 ,p_opt_id in number default null
89 ,p_ler_id in number
90 ,p_life_event_date in date
91 ,p_ended_pl_id in number default null
92 ,p_ended_opt_id in number default null
93 ,p_ended_bnft_val in number default null
94 ,p_effective_date in date
95 ,p_person_id in number
96 ,p_bnft_val in number default null
97 ,p_acty_base_rt_id1 in number default null
98 ,p_rt_val1 in number default null
99 ,p_ann_rt_val1 in number default null
100 ,p_rt_strt_dt1 in date default null
101 ,p_rt_end_dt1 in date default null
102 ,p_acty_base_rt_id2 in number default null
103 ,p_rt_val2 in number default null
104 ,p_ann_rt_val2 in number default null
105 ,p_rt_strt_dt2 in date default null
106 ,p_rt_end_dt2 in date default null
107 ,p_acty_base_rt_id3 in number default null
108 ,p_rt_val3 in number default null
109 ,p_ann_rt_val3 in number default null
110 ,p_rt_strt_dt3 in date default null
111 ,p_rt_end_dt3 in date default null
112 ,p_acty_base_rt_id4 in number default null
113 ,p_rt_val4 in number default null
114 ,p_ann_rt_val4 in number default null
115 ,p_rt_strt_dt4 in date default null
116 ,p_rt_end_dt4 in date default null
117 ,p_business_group_id in number
118 ,p_enrt_cvg_strt_dt in date default null
119 ,p_enrt_cvg_thru_dt in date default null
120 ,p_orgnl_enrt_dt in date default null
121 ,p_proc_cd in varchar2 default null
122 ,p_record_typ_cd in varchar2 );
123 --
124 -- --------------------------------------------------------------------------------
125 -- |-----------------------------< PROCESS_DEPENDENT >-------------------------|
126 -- -------------------------------------------------------------------------------+
127 procedure process_dependent
128 (p_validate in boolean default false
129 ,p_person_id in number
130 ,p_pgm_id in number default null
131 ,p_pl_id in number default null
132 ,p_opt_id in number default null
133 ,p_ler_id in number
134 ,p_life_event_date in date
135 ,p_effective_date in date
136 ,p_contact_person_id in number
137 ,p_business_group_id in number
138 ,p_cvg_strt_dt in date default null
139 ,p_cvg_thru_dt in date default null
140 ,p_multi_row_actn in boolean default false
141 ,p_record_typ_cd in varchar2 );
142
143 --
144 -- --------------------------------------------------------------------------------
145 -- |-----------------------------< PROCESS_BENEFICIARY >-------------------------|
146 -- -------------------------------------------------------------------------------+
147 procedure process_beneficiary
148 (p_validate in boolean default false
149 ,p_person_id in number
150 ,p_pgm_id in number default null
151 ,p_pl_id in number default null
152 ,p_opt_id in number default null
153 ,p_bnft_val in number default null
154 ,p_ler_id in number
155 ,p_life_event_date in date
156 ,p_effective_date in date
157 ,p_bnf_person_id in number
158 ,p_business_group_id in number
159 ,p_dsgn_strt_dt in date default null
160 ,p_dsgn_thru_dt in date default null
161 ,p_prmry_cntngnt_cd in varchar2
162 ,p_pct_dsgd_num in number
163 ,p_amt_dsgd_val in number default null
164 ,p_amt_dsgd_uom in varchar2 default null
165 ,p_addl_instrn_txt in varchar2 default null
166 ,p_multi_row_actn in boolean default true
167 ,p_organization_id in number default null
168 ,p_ttee_person_id in number default null
169 ,p_record_typ_cd in varchar2 );
170 --
171 --
172 end ben_enrollment_process;