1 Package ben_element_entry AUTHID CURRENT_USER as
2 /* $Header: benelmen.pkh 120.1.12010000.1 2008/07/29 12:22:55 appldev ship $ */
3 --
4 type g_calculated_values is record
5 (element_entry_id number
6 ,zero_pp_date date
7 ,special_pp_date date
8 ,special_amt number
9 ,normal_pp_date date
10 ,normal_amt number
11 ,normal_pp_end_date date
12 ,prtn_flag varchar2(1)
13 ,first_pp_adjustment number
14 ,rt_strt_dt date
15 ,range_start date
16 ,last_pp_end_dt date
17 ,payroll_id number
18 );
19 --
20 type g_cache_quick_payrun is record
21 (person_id number,
22 element_type_id number,
23 assignment_id number,
24 assignment_action_id number,
25 payroll_end_date date);
26
27 type ext_inpval_tab_rec is record
28 (extra_input_value_id number(15),
29 upd_when_ele_ended_cd varchar2(30),
30 input_value_id number(15),
31 return_var_name varchar2(30),
32 return_value varchar2(2000));
33 --
34 type ext_inpval_tab_typ is table of ext_inpval_tab_rec
35 index by binary_integer;
36 --
37 type inpval_tab_rec is record
38 (input_value_id number,
39 value varchar2(60));
40
41 type inpval_tab_typ is table of inpval_tab_rec
42 index by binary_integer;
43
44 type g_cache_quick_payrun_rec is table of g_cache_quick_payrun
45 index by binary_integer;
46
47 g_cache_quick_payrun_object g_cache_quick_payrun_rec;
48
49 g_creee_calc_vals g_calculated_values;
50 --
51 --
52 --g_msg_displayed number :=0; --2530582
53 --g_msg_displayed1 number :=0; --2530582
54 --
55 -- prorates rates, coverage, and actual premiums
56 --
57 -- ----------------------------------------------------------------------------
58 -- |---------------------< prorate_amount >-----------------------------|
59 -- ----------------------------------------------------------------------------
60 function prorate_amount(p_amt IN NUMBER --per month amount
61 ,p_acty_base_rt_id IN NUMBER default null
62 ,p_actl_prem_id in number default null
63 ,p_cvg_amt_calc_mthd_id in number default null
64 ,p_person_id in number
65 ,p_rndg_cd in varchar2 default null
66 ,p_rndg_rl in number default null
67 ,p_pgm_id in number
68 ,p_pl_typ_id in number
69 ,p_pl_id in number
70 ,p_opt_id in number
71 ,p_ler_id in number
72 ,p_prorate_flag IN OUT NOCOPY VARCHAR2
73 ,p_effective_date in DATE
74 ,p_start_or_stop_cd in varchar2
75 ,p_start_or_stop_date in date
76 ,p_business_group_id in number
77 ,p_assignment_id in number
78 ,p_organization_id in number
79 ,p_jurisdiction_code in varchar2
80 ,p_wsh_rl_dy_mo_num in number
81 ,p_prtl_mo_det_mthd_cd in out nocopy varchar2
82 ,p_prtl_mo_det_mthd_rl in number)
83 RETURN NUMBER;
84 --
85 procedure get_link
86 (p_assignment_id in number
87 ,p_element_type_id in number
88 ,p_business_group_id in number
89 ,p_input_value_id in number
90 ,p_effective_date in date
91 --
92 ,p_element_link_id out nocopy number
93 );
94 /*
95 -- This Function checks the existence of a current
96 -- Employee or Benefits assignment
97 -- and returns the assignment_id and payroll_id
98 --
99 */
100 function chk_assign_exists(p_person_id IN NUMBER
101 ,p_business_group_id IN NUMBER
102 ,p_effective_date IN DATE
103 ,p_rate_date IN DATE
104 ,p_acty_base_rt_id IN NUMBER
105 ,p_assignment_id IN OUT NOCOPY NUMBER
106 ,p_organization_id in out nocopy number
107 ,p_payroll_id IN OUT NOCOPY NUMBER)
108 RETURN BOOLEAN;
109
110 -- This Procedure creates a benefits assignments
111 -- If the participant record being enrolled does not
112 -- have an assignment.
113 procedure create_benefits_assignment(p_person_id IN NUMBER
114 ,p_payroll_id IN NUMBER
115 ,p_assignment_id IN OUT NOCOPY NUMBER
116 ,p_business_group_id IN NUMBER
117 ,p_organization_id in out nocopy number
118 ,p_effective_date IN DATE);
119 --
120 procedure create_enrollment_element
121 (p_validate in boolean default false
122 ,p_calculate_only_mode in boolean default false
123 ,p_person_id in number
124 ,p_acty_base_rt_id in number
125 ,p_acty_ref_perd in varchar2
126 ,p_rt_start_date in date
127 ,p_rt in number
128 ,p_business_group_id in number
129 ,p_effective_date in date
130 ,p_cmncd_rt in number default null
131 ,p_ann_rt in number default null
132 ,p_prtt_rt_val_id in number default null
133 ,p_enrt_rslt_id in number default null
134 ,p_input_value_id in number default null
135 ,p_element_type_id in number default null
136 ,p_pl_id in number default null
137 ,p_prv_object_version_number in out nocopy number
138 ,p_element_entry_value_id out nocopy number
139 ,p_eev_screen_entry_value out nocopy number
140 );
141 --
142 procedure reopen_closed_enrollment(p_validate IN BOOLEAN default FALSE
143 ,p_business_group_id number
144 ,p_person_id number
145 ,p_acty_base_rt_id NUMBER
146 ,p_element_type_id NUMBER
147 ,p_prtt_rt_val_id IN NUMBER default null
148 ,p_input_value_id NUMBER
149 ,p_rt NUMBER
150 ,p_rt_start_date DATE
151 ,p_effective_date DATE);
152 --
153 procedure end_enrollment_element(p_validate IN BOOLEAN default FALSE
154 ,p_business_group_id IN NUMBER
155 ,p_person_id IN NUMBER
156 ,p_enrt_rslt_id IN NUMBER
157 ,p_acty_ref_perd in varchar2
158 ,p_acty_base_rt_id in number
159 ,p_element_link_id IN NUMBER
160 ,p_prtt_rt_val_id in number
161 ,p_rt_end_date IN DATE
162 ,p_effective_date IN DATE
163 ,p_dt_delete_mode IN VARCHAR2
164 ,p_amt in number);
165 --
166 procedure get_abr_assignment(p_person_id IN NUMBER
167 ,p_effective_date IN DATE
168 ,p_acty_base_rt_id IN NUMBER
169 ,p_organization_id OUT NOCOPY NUMBER
170 ,p_payroll_id OUT NOCOPY NUMBER
171 ,p_assignment_id OUT NOCOPY NUMBER);
172 --
173 -- ----------------------------------------------------------------------------
174 -- |-----------------------< get_extra_ele_inputs>----------------------------|
175 -- ----------------------------------------------------------------------------
176 --
177 procedure get_extra_ele_inputs
178 (
179 p_effective_date in date
180 ,p_person_id in number
181 ,p_business_group_id in number
182 ,p_assignment_id in number
183 ,p_element_link_id in number
184 ,p_entry_type in varchar2
185 ,p_input_value_id1 in number
186 ,p_entry_value1 in varchar2
187 ,p_element_entry_id in number
188 ,p_acty_base_rt_id in number
189 ,p_input_va_calc_rl in number
190 ,p_abs_ler in boolean
191 ,p_organization_id in number
192 ,p_payroll_id in number
193 ,p_pgm_id in number
194 ,p_pl_id in number
195 ,p_pl_typ_id in number
196 ,p_opt_id in number
197 ,p_ler_id in number
198 ,p_dml_typ in varchar2
199 ,p_jurisdiction_code in varchar2
200 ,p_ext_inpval_tab out nocopy ext_inpval_tab_typ
201 ,p_subpriority out nocopy number);
202 --
203 procedure get_inpval_tab
204 (p_element_entry_id in number,
205 p_effective_date in date,
206 p_inpval_tab out nocopy inpval_tab_typ);
207 --
208 procedure clear_down_cache;
209 --
210 procedure set_no_cache_context;
211 --
212 procedure reset_msg_displayed; --bug 2530582
213 --
214 procedure create_reimburse_element
215 (p_validate in boolean default false
216 ,p_person_id in number
217 ,p_acty_base_rt_id in number
218 ,p_amt in number
219 ,p_business_group_id in number
220 ,p_effective_date in date
221 ,p_prtt_reimbmt_rqst_id in number default null
222 ,p_input_value_id in number default null
223 ,p_element_type_id in number default null
224 ,p_pl_id in number default null
225 ,p_prtt_rmt_aprvd_fr_pymt_id in number
226 ,p_object_version_number in out nocopy number
227 );
228 --
229 procedure end_reimburse_element(p_validate IN BOOLEAN default FALSE
230 ,p_business_group_id IN NUMBER
231 ,p_person_id IN NUMBER
232 ,p_prtt_reimbmt_rqst_id IN NUMBER
233 ,p_element_link_id IN NUMBER default null
234 ,p_prtt_rmt_aprvd_fr_pymt_id in number
235 ,p_effective_date IN DATE
236 ,p_dt_delete_mode IN VARCHAR2 default null
237 ,p_element_entry_value_id in number);
238 --
239 end ben_element_entry;