[Home] [Help]
PACKAGE BODY: APPS.BEN_BENEFIT_ACTIONS_API
Source
1 Package Body ben_benefit_actions_api as
2 /* $Header: bebftapi.pkb 115.19 2003/08/18 05:06:05 rpgupta ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' ben_benefit_actions_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_benefit_actions >------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_benefit_actions
13 (p_validate in boolean default false
14 ,p_benefit_action_id out nocopy number
15 ,p_process_date in date default null
16 ,p_uneai_effective_date in date default null
17 ,p_mode_cd in varchar2 default null
18 ,p_derivable_factors_flag in varchar2 default null
19 ,p_close_uneai_flag in varchar2 default 'N'
20 ,p_validate_flag in varchar2 default null
21 ,p_person_id in number default null
22 ,p_person_type_id in number default null
23 ,p_pgm_id in number default null
24 ,p_business_group_id in number default null
25 ,p_pl_id in number default null
26 ,p_popl_enrt_typ_cycl_id in number default null
27 ,p_no_programs_flag in varchar2 default null
28 ,p_no_plans_flag in varchar2 default null
29 ,p_comp_selection_rl in number default null
30 ,p_person_selection_rl in number default null
31 ,p_ler_id in number default null
32 ,p_organization_id in number default null
33 ,p_benfts_grp_id in number default null
34 ,p_location_id in number default null
35 ,p_pstl_zip_rng_id in number default null
36 ,p_rptg_grp_id in number default null
37 ,p_pl_typ_id in number default null
38 ,p_opt_id in number default null
39 ,p_eligy_prfl_id in number default null
40 ,p_vrbl_rt_prfl_id in number default null
41 ,p_legal_entity_id in number default null
42 ,p_payroll_id in number default null
43 ,p_debug_messages_flag in varchar2 default null
44 ,p_cm_trgr_typ_cd in varchar2 default null
45 ,p_cm_typ_id in number default null
46 ,p_age_fctr_id in number default null
47 ,p_min_age in number default null
48 ,p_max_age in number default null
49 ,p_los_fctr_id in number default null
50 ,p_min_los in number default null
51 ,p_max_los in number default null
52 ,p_cmbn_age_los_fctr_id in number default null
53 ,p_min_cmbn in number default null
54 ,p_max_cmbn in number default null
55 ,p_date_from in date default null
56 ,p_elig_enrol_cd in varchar2 default null
57 ,p_actn_typ_id in number default null
58 ,p_use_fctr_to_sel_flag in varchar2 default 'N'
59 ,p_los_det_to_use_cd in varchar2 default null
60 ,p_audit_log_flag in varchar2 default 'N'
61 ,p_lmt_prpnip_by_org_flag in varchar2 default 'N'
65 ,p_bft_attribute1 in varchar2 default null
62 ,p_lf_evt_ocrd_dt in date default null
63 ,p_ptnl_ler_for_per_stat_cd in varchar2 default null
64 ,p_bft_attribute_category in varchar2 default null
66 ,p_bft_attribute3 in varchar2 default null
67 ,p_bft_attribute4 in varchar2 default null
68 ,p_bft_attribute5 in varchar2 default null
69 ,p_bft_attribute6 in varchar2 default null
70 ,p_bft_attribute7 in varchar2 default null
71 ,p_bft_attribute8 in varchar2 default null
72 ,p_bft_attribute9 in varchar2 default null
73 ,p_bft_attribute10 in varchar2 default null
74 ,p_bft_attribute11 in varchar2 default null
75 ,p_bft_attribute12 in varchar2 default null
76 ,p_bft_attribute13 in varchar2 default null
77 ,p_bft_attribute14 in varchar2 default null
78 ,p_bft_attribute15 in varchar2 default null
79 ,p_bft_attribute16 in varchar2 default null
80 ,p_bft_attribute17 in varchar2 default null
81 ,p_bft_attribute18 in varchar2 default null
82 ,p_bft_attribute19 in varchar2 default null
83 ,p_bft_attribute20 in varchar2 default null
84 ,p_bft_attribute21 in varchar2 default null
85 ,p_bft_attribute22 in varchar2 default null
86 ,p_bft_attribute23 in varchar2 default null
87 ,p_bft_attribute24 in varchar2 default null
88 ,p_bft_attribute25 in varchar2 default null
89 ,p_bft_attribute26 in varchar2 default null
90 ,p_bft_attribute27 in varchar2 default null
91 ,p_bft_attribute28 in varchar2 default null
92 ,p_bft_attribute29 in varchar2 default null
93 ,p_bft_attribute30 in varchar2 default null
94 ,p_request_id in number default null
95 ,p_program_application_id in number default null
96 ,p_program_id in number default null
97 ,p_program_update_date in date default null
98 ,p_object_version_number out nocopy number
99 ,p_effective_date in date
100 ,p_enrt_perd_id in number default null
101 ,p_inelg_action_cd in varchar2 default null
102 ,p_org_hierarchy_id in number default null
103 ,p_org_starting_node_id in number default null
104 ,p_grade_ladder_id in number default null
105 ,p_asg_events_to_all_sel_dt in varchar2 default null
106 ,p_rate_id in number default null
107 ,p_per_sel_dt_cd in varchar2 default null
108 ,p_per_sel_freq_cd in varchar2 default null
109 ,p_per_sel_dt_from in date default null
110 ,p_per_sel_dt_to in date default null
111 ,p_year_from in number default null
112 ,p_year_to in number default null
113 ,p_cagr_id in number default null
114 ,p_qual_type in number default null
115 ,p_qual_status in varchar2 default null
116 ,p_concat_segs in varchar2 default null
117 ,p_grant_price_val in number default null) is
118 --
119 -- Declare cursors and local variables
120 --
121 l_benefit_action_id ben_benefit_actions.benefit_action_id%TYPE;
122 l_proc varchar2(72) := g_package||'create_benefit_actions';
123 l_object_version_number ben_benefit_actions.object_version_number%TYPE;
124 --
125 begin
126 --
127 hr_utility.set_location('Entering:'|| l_proc, 10);
128 --
129 -- Issue a savepoint if operating in validation only mode
130 --
131 savepoint create_benefit_actions;
132 --
133 /*
134 hr_utility.set_location(l_proc, 20);
135 */
136
137 --
138 -- Process Logic
139 --
140 begin
141 --
142 -- Start of API User Hook for the before hook of create_benefit_actions
143 --
144 ben_benefit_actions_bk1.create_benefit_actions_b
145 (p_process_date => p_process_date
146 ,p_uneai_effective_date => p_uneai_effective_date
147 ,p_mode_cd => p_mode_cd
148 ,p_derivable_factors_flag => p_derivable_factors_flag
149 ,p_close_uneai_flag => p_close_uneai_flag
150 ,p_validate_flag => p_validate_flag
151 ,p_person_id => p_person_id
152 ,p_person_type_id => p_person_type_id
153 ,p_pgm_id => p_pgm_id
154 ,p_business_group_id => p_business_group_id
155 ,p_pl_id => p_pl_id
156 ,p_popl_enrt_typ_cycl_id => p_popl_enrt_typ_cycl_id
157 ,p_no_programs_flag => p_no_programs_flag
158 ,p_no_plans_flag => p_no_plans_flag
159 ,p_comp_selection_rl => p_comp_selection_rl
160 ,p_person_selection_rl => p_person_selection_rl
161 ,p_ler_id => p_ler_id
162 ,p_organization_id => p_organization_id
163 ,p_benfts_grp_id => p_benfts_grp_id
164 ,p_location_id => p_location_id
165 ,p_pstl_zip_rng_id => p_pstl_zip_rng_id
166 ,p_rptg_grp_id => p_rptg_grp_id
167 ,p_pl_typ_id => p_pl_typ_id
168 ,p_opt_id => p_opt_id
172 ,p_payroll_id => p_payroll_id
169 ,p_eligy_prfl_id => p_eligy_prfl_id
170 ,p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
171 ,p_legal_entity_id => p_legal_entity_id
173 ,p_debug_messages_flag => p_debug_messages_flag
174 ,p_cm_trgr_typ_cd => p_cm_trgr_typ_cd
175 ,p_cm_typ_id => p_cm_typ_id
176 ,p_age_fctr_id => p_age_fctr_id
177 ,p_min_age => p_min_age
178 ,p_max_age => p_max_age
179 ,p_los_fctr_id => p_los_fctr_id
180 ,p_min_los => p_min_los
181 ,p_max_los => p_max_los
182 ,p_cmbn_age_los_fctr_id => p_cmbn_age_los_fctr_id
183 ,p_min_cmbn => p_min_cmbn
184 ,p_max_cmbn => p_max_cmbn
185 ,p_date_from => p_date_from
186 ,p_elig_enrol_cd => p_elig_enrol_cd
187 ,p_actn_typ_id => p_actn_typ_id
188 ,p_use_fctr_to_sel_flag => p_use_fctr_to_sel_flag
189 ,p_los_det_to_use_cd => p_los_det_to_use_cd
190 ,p_audit_log_flag => p_audit_log_flag
191 ,p_lmt_prpnip_by_org_flag => p_lmt_prpnip_by_org_flag
192 ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
193 ,p_ptnl_ler_for_per_stat_cd => p_ptnl_ler_for_per_stat_cd
194 ,p_bft_attribute_category => p_bft_attribute_category
195 ,p_bft_attribute1 => p_bft_attribute1
196 ,p_bft_attribute3 => p_bft_attribute3
197 ,p_bft_attribute4 => p_bft_attribute4
198 ,p_bft_attribute5 => p_bft_attribute5
199 ,p_bft_attribute6 => p_bft_attribute6
200 ,p_bft_attribute7 => p_bft_attribute7
201 ,p_bft_attribute8 => p_bft_attribute8
202 ,p_bft_attribute9 => p_bft_attribute9
203 ,p_bft_attribute10 => p_bft_attribute10
204 ,p_bft_attribute11 => p_bft_attribute11
205 ,p_bft_attribute12 => p_bft_attribute12
206 ,p_bft_attribute13 => p_bft_attribute13
207 ,p_bft_attribute14 => p_bft_attribute14
208 ,p_bft_attribute15 => p_bft_attribute15
209 ,p_bft_attribute16 => p_bft_attribute16
210 ,p_bft_attribute17 => p_bft_attribute17
211 ,p_bft_attribute18 => p_bft_attribute18
212 ,p_bft_attribute19 => p_bft_attribute19
213 ,p_bft_attribute20 => p_bft_attribute20
214 ,p_bft_attribute21 => p_bft_attribute21
215 ,p_bft_attribute22 => p_bft_attribute22
216 ,p_bft_attribute23 => p_bft_attribute23
217 ,p_bft_attribute24 => p_bft_attribute24
218 ,p_bft_attribute25 => p_bft_attribute25
219 ,p_bft_attribute26 => p_bft_attribute26
220 ,p_bft_attribute27 => p_bft_attribute27
221 ,p_bft_attribute28 => p_bft_attribute28
222 ,p_bft_attribute29 => p_bft_attribute29
223 ,p_bft_attribute30 => p_bft_attribute30
224 ,p_effective_date => trunc(p_effective_date)
225 ,p_enrt_perd_id => p_enrt_perd_id
226 ,p_inelg_action_cd => p_inelg_action_cd
227 ,p_org_hierarchy_id => p_org_hierarchy_id
228 ,p_org_starting_node_id => p_org_starting_node_id
229 ,p_grade_ladder_id => p_grade_ladder_id
230 ,p_asg_events_to_all_sel_dt => p_asg_events_to_all_sel_dt
231 ,p_rate_id => p_rate_id
232 ,p_per_sel_dt_cd => p_per_sel_dt_cd
233 ,p_per_sel_freq_cd => p_per_sel_freq_cd
234 ,p_per_sel_dt_from => p_per_sel_dt_from
235 ,p_per_sel_dt_to => p_per_sel_dt_to
236 ,p_year_from => p_year_from
237 ,p_year_to => p_year_to
238 ,p_cagr_id => p_cagr_id
239 ,p_qual_type => p_qual_type
240 ,p_qual_status => p_qual_status
241 ,p_concat_segs => p_concat_segs
242 ,p_grant_price_val => p_grant_price_val);
243 --
244 exception
245 --
246 when hr_api.cannot_find_prog_unit then
247 hr_api.cannot_find_prog_unit_error
248 (p_module_name => 'CREATE_benefit_actions'
249 ,p_hook_type => 'BP');
250 --
251 -- End of API User Hook for the before hook of create_benefit_actions
252 --
253 end;
254 --
255 ben_bft_ins.ins
256 (p_benefit_action_id => l_benefit_action_id
257 ,p_process_date => p_process_date
258 ,p_uneai_effective_date => p_uneai_effective_date
259 ,p_mode_cd => p_mode_cd
260 ,p_derivable_factors_flag => p_derivable_factors_flag
261 ,p_close_uneai_flag => p_close_uneai_flag
262 ,p_validate_flag => p_validate_flag
263 ,p_person_id => p_person_id
264 ,p_person_type_id => p_person_type_id
265 ,p_pgm_id => p_pgm_id
266 ,p_business_group_id => p_business_group_id
267 ,p_pl_id => p_pl_id
268 ,p_popl_enrt_typ_cycl_id => p_popl_enrt_typ_cycl_id
269 ,p_no_programs_flag => p_no_programs_flag
273 ,p_ler_id => p_ler_id
270 ,p_no_plans_flag => p_no_plans_flag
271 ,p_comp_selection_rl => p_comp_selection_rl
272 ,p_person_selection_rl => p_person_selection_rl
274 ,p_organization_id => p_organization_id
275 ,p_benfts_grp_id => p_benfts_grp_id
276 ,p_location_id => p_location_id
277 ,p_pstl_zip_rng_id => p_pstl_zip_rng_id
278 ,p_rptg_grp_id => p_rptg_grp_id
279 ,p_pl_typ_id => p_pl_typ_id
280 ,p_opt_id => p_opt_id
281 ,p_eligy_prfl_id => p_eligy_prfl_id
282 ,p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
283 ,p_legal_entity_id => p_legal_entity_id
284 ,p_payroll_id => p_payroll_id
285 ,p_debug_messages_flag => p_debug_messages_flag
286 ,p_cm_trgr_typ_cd => p_cm_trgr_typ_cd
287 ,p_cm_typ_id => p_cm_typ_id
288 ,p_age_fctr_id => p_age_fctr_id
289 ,p_min_age => p_min_age
290 ,p_max_age => p_max_age
291 ,p_los_fctr_id => p_los_fctr_id
292 ,p_min_los => p_min_los
293 ,p_max_los => p_max_los
294 ,p_cmbn_age_los_fctr_id => p_cmbn_age_los_fctr_id
295 ,p_min_cmbn => p_min_cmbn
296 ,p_max_cmbn => p_max_cmbn
297 ,p_date_from => p_date_from
298 ,p_elig_enrol_cd => p_elig_enrol_cd
299 ,p_actn_typ_id => p_actn_typ_id
300 ,p_use_fctr_to_sel_flag => p_use_fctr_to_sel_flag
301 ,p_los_det_to_use_cd => p_los_det_to_use_cd
302 ,p_audit_log_flag => p_audit_log_flag
303 ,p_lmt_prpnip_by_org_flag => p_lmt_prpnip_by_org_flag
304 ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
305 ,p_ptnl_ler_for_per_stat_cd => p_ptnl_ler_for_per_stat_cd
306 ,p_bft_attribute_category => p_bft_attribute_category
307 ,p_bft_attribute1 => p_bft_attribute1
308 ,p_bft_attribute3 => p_bft_attribute3
309 ,p_bft_attribute4 => p_bft_attribute4
310 ,p_bft_attribute5 => p_bft_attribute5
311 ,p_bft_attribute6 => p_bft_attribute6
312 ,p_bft_attribute7 => p_bft_attribute7
313 ,p_bft_attribute8 => p_bft_attribute8
314 ,p_bft_attribute9 => p_bft_attribute9
315 ,p_bft_attribute10 => p_bft_attribute10
316 ,p_bft_attribute11 => p_bft_attribute11
317 ,p_bft_attribute12 => p_bft_attribute12
318 ,p_bft_attribute13 => p_bft_attribute13
319 ,p_bft_attribute14 => p_bft_attribute14
320 ,p_bft_attribute15 => p_bft_attribute15
321 ,p_bft_attribute16 => p_bft_attribute16
322 ,p_bft_attribute17 => p_bft_attribute17
323 ,p_bft_attribute18 => p_bft_attribute18
324 ,p_bft_attribute19 => p_bft_attribute19
325 ,p_bft_attribute20 => p_bft_attribute20
326 ,p_bft_attribute21 => p_bft_attribute21
327 ,p_bft_attribute22 => p_bft_attribute22
328 ,p_bft_attribute23 => p_bft_attribute23
329 ,p_bft_attribute24 => p_bft_attribute24
330 ,p_bft_attribute25 => p_bft_attribute25
331 ,p_bft_attribute26 => p_bft_attribute26
332 ,p_bft_attribute27 => p_bft_attribute27
333 ,p_bft_attribute28 => p_bft_attribute28
334 ,p_bft_attribute29 => p_bft_attribute29
335 ,p_bft_attribute30 => p_bft_attribute30
336 ,p_request_id => p_request_id
337 ,p_program_application_id => p_program_application_id
338 ,p_program_id => p_program_id
339 ,p_program_update_date => p_program_update_date
340 ,p_object_version_number => l_object_version_number
341 ,p_effective_date => trunc(p_effective_date)
342 ,p_enrt_perd_id => p_enrt_perd_id
343 ,p_inelg_action_cd => p_inelg_action_cd
344 ,p_org_hierarchy_id => p_org_hierarchy_id
345 ,p_org_starting_node_id => p_org_starting_node_id
346 ,p_grade_ladder_id => p_grade_ladder_id
347 ,p_asg_events_to_all_sel_dt => p_asg_events_to_all_sel_dt
348 ,p_rate_id => p_rate_id
349 ,p_per_sel_dt_cd => p_per_sel_dt_cd
350 ,p_per_sel_freq_cd => p_per_sel_freq_cd
351 ,p_per_sel_dt_from => p_per_sel_dt_from
352 ,p_per_sel_dt_to => p_per_sel_dt_to
353 ,p_year_from => p_year_from
354 ,p_year_to => p_year_to
355 ,p_cagr_id => p_cagr_id
356 ,p_qual_type => p_qual_type
357 ,p_qual_status => p_qual_status
358 ,p_concat_segs => p_concat_segs
359 ,p_grant_price_val => p_grant_price_val);
360 --
361 begin
362 --
363 -- Start of API User Hook for the after hook of create_benefit_actions
364 --
365 ben_benefit_actions_bk1.create_benefit_actions_a
366 (p_benefit_action_id => l_benefit_action_id
367 ,p_process_date => p_process_date
368 ,p_uneai_effective_date => p_uneai_effective_date
369 ,p_mode_cd => p_mode_cd
373 ,p_person_id => p_person_id
370 ,p_derivable_factors_flag => p_derivable_factors_flag
371 ,p_close_uneai_flag => p_close_uneai_flag
372 ,p_validate_flag => p_validate_flag
374 ,p_person_type_id => p_person_type_id
375 ,p_pgm_id => p_pgm_id
376 ,p_business_group_id => p_business_group_id
377 ,p_pl_id => p_pl_id
378 ,p_popl_enrt_typ_cycl_id => p_popl_enrt_typ_cycl_id
379 ,p_no_programs_flag => p_no_programs_flag
380 ,p_no_plans_flag => p_no_plans_flag
381 ,p_comp_selection_rl => p_comp_selection_rl
382 ,p_person_selection_rl => p_person_selection_rl
383 ,p_ler_id => p_ler_id
384 ,p_organization_id => p_organization_id
385 ,p_benfts_grp_id => p_benfts_grp_id
386 ,p_location_id => p_location_id
387 ,p_pstl_zip_rng_id => p_pstl_zip_rng_id
388 ,p_rptg_grp_id => p_rptg_grp_id
389 ,p_pl_typ_id => p_pl_typ_id
390 ,p_opt_id => p_opt_id
391 ,p_eligy_prfl_id => p_eligy_prfl_id
392 ,p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
393 ,p_legal_entity_id => p_legal_entity_id
394 ,p_payroll_id => p_payroll_id
395 ,p_debug_messages_flag => p_debug_messages_flag
396 ,p_cm_trgr_typ_cd => p_cm_trgr_typ_cd
397 ,p_cm_typ_id => p_cm_typ_id
398 ,p_age_fctr_id => p_age_fctr_id
399 ,p_min_age => p_min_age
400 ,p_max_age => p_max_age
401 ,p_los_fctr_id => p_los_fctr_id
402 ,p_min_los => p_min_los
403 ,p_max_los => p_max_los
404 ,p_cmbn_age_los_fctr_id => p_cmbn_age_los_fctr_id
405 ,p_min_cmbn => p_min_cmbn
406 ,p_max_cmbn => p_max_cmbn
407 ,p_date_from => p_date_from
408 ,p_elig_enrol_cd => p_elig_enrol_cd
409 ,p_actn_typ_id => p_actn_typ_id
410 ,p_use_fctr_to_sel_flag => p_use_fctr_to_sel_flag
411 ,p_los_det_to_use_cd => p_los_det_to_use_cd
412 ,p_audit_log_flag => p_audit_log_flag
413 ,p_lmt_prpnip_by_org_flag => p_lmt_prpnip_by_org_flag
414 ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
415 ,p_ptnl_ler_for_per_stat_cd => p_ptnl_ler_for_per_stat_cd
416 ,p_bft_attribute_category => p_bft_attribute_category
417 ,p_bft_attribute1 => p_bft_attribute1
418 ,p_bft_attribute3 => p_bft_attribute3
419 ,p_bft_attribute4 => p_bft_attribute4
420 ,p_bft_attribute5 => p_bft_attribute5
421 ,p_bft_attribute6 => p_bft_attribute6
422 ,p_bft_attribute7 => p_bft_attribute7
423 ,p_bft_attribute8 => p_bft_attribute8
424 ,p_bft_attribute9 => p_bft_attribute9
425 ,p_bft_attribute10 => p_bft_attribute10
426 ,p_bft_attribute11 => p_bft_attribute11
427 ,p_bft_attribute12 => p_bft_attribute12
428 ,p_bft_attribute13 => p_bft_attribute13
429 ,p_bft_attribute14 => p_bft_attribute14
430 ,p_bft_attribute15 => p_bft_attribute15
431 ,p_bft_attribute16 => p_bft_attribute16
432 ,p_bft_attribute17 => p_bft_attribute17
433 ,p_bft_attribute18 => p_bft_attribute18
434 ,p_bft_attribute19 => p_bft_attribute19
435 ,p_bft_attribute20 => p_bft_attribute20
436 ,p_bft_attribute21 => p_bft_attribute21
437 ,p_bft_attribute22 => p_bft_attribute22
438 ,p_bft_attribute23 => p_bft_attribute23
439 ,p_bft_attribute24 => p_bft_attribute24
440 ,p_bft_attribute25 => p_bft_attribute25
441 ,p_bft_attribute26 => p_bft_attribute26
442 ,p_bft_attribute27 => p_bft_attribute27
443 ,p_bft_attribute28 => p_bft_attribute28
444 ,p_bft_attribute29 => p_bft_attribute29
445 ,p_bft_attribute30 => p_bft_attribute30
446 ,p_object_version_number => l_object_version_number
447 ,p_effective_date => trunc(p_effective_date)
448 ,p_enrt_perd_id => p_enrt_perd_id
449 ,p_inelg_action_cd => p_inelg_action_cd
450 ,p_org_hierarchy_id => p_org_hierarchy_id
451 ,p_org_starting_node_id => p_org_starting_node_id
452 ,p_grade_ladder_id => p_grade_ladder_id
453 ,p_asg_events_to_all_sel_dt => p_asg_events_to_all_sel_dt
454 ,p_rate_id => p_rate_id
455 ,p_per_sel_dt_cd => p_per_sel_dt_cd
456 ,p_per_sel_freq_cd => p_per_sel_freq_cd
457 ,p_per_sel_dt_from => p_per_sel_dt_from
458 ,p_per_sel_dt_to => p_per_sel_dt_to
459 ,p_year_from => p_year_from
460 ,p_year_to => p_year_to
461 ,p_cagr_id => p_cagr_id
462 ,p_qual_type => p_qual_type
463 ,p_qual_status => p_qual_status
464 ,p_concat_segs => p_concat_segs
468 --
465 ,p_grant_price_val => p_grant_price_val);
466 --
467 exception
469 when hr_api.cannot_find_prog_unit then
470 --
471 hr_api.cannot_find_prog_unit_error
472 (p_module_name => 'CREATE_benefit_actions'
473 ,p_hook_type => 'AP');
474 --
475 -- End of API User Hook for the after hook of create_benefit_actions
476 --
477 end;
478 --
479 /*
480 hr_utility.set_location(l_proc, 60);
481 */
482
483 --
484 -- When in validation only mode raise the Validate_Enabled exception
485 --
486 if p_validate then
487 raise hr_api.validate_enabled;
488 end if;
489 --
490 -- Set all output arguments
491 --
492 p_benefit_action_id := l_benefit_action_id;
493 p_object_version_number := l_object_version_number;
494 --
495 hr_utility.set_location(' Leaving:'||l_proc, 70);
496 --
497 exception
498 --
499 when hr_api.validate_enabled then
500 --
501 -- As the Validate_Enabled exception has been raised
502 -- we must rollback to the savepoint
503 --
504 ROLLBACK TO create_benefit_actions;
505 --
506 -- Only set output warning arguments
507 -- (Any key or derived arguments must be set to null
508 -- when validation only mode is being used.)
509 --
510 p_benefit_action_id := null;
511 p_object_version_number := null;
512 hr_utility.set_location(' Leaving:'||l_proc, 80);
513 --
514 when others then
515 --
516 -- A validation or unexpected error has occured
517 --
518 ROLLBACK TO create_benefit_actions;
519 --nocopy, reset
520 p_benefit_action_id := null;
521 p_object_version_number := null;
522 raise;
523 --
524 end create_benefit_actions;
525 -- ----------------------------------------------------------------------------
526 -- |------------------------< create_perf_benefit_actions >-------------------|
527 -- ----------------------------------------------------------------------------
528 --
529 procedure create_perf_benefit_actions
530 (p_validate in boolean default false
531 ,p_benefit_action_id out nocopy number
532 ,p_process_date in date default null
533 ,p_uneai_effective_date in date default null
534 ,p_mode_cd in varchar2 default null
535 ,p_derivable_factors_flag in varchar2 default null
536 ,p_close_uneai_flag in varchar2 default 'N'
537 ,p_validate_flag in varchar2 default null
538 ,p_person_id in number default null
539 ,p_person_type_id in number default null
540 ,p_pgm_id in number default null
541 ,p_business_group_id in number default null
542 ,p_pl_id in number default null
543 ,p_popl_enrt_typ_cycl_id in number default null
544 ,p_no_programs_flag in varchar2 default null
545 ,p_no_plans_flag in varchar2 default null
546 ,p_comp_selection_rl in number default null
547 ,p_person_selection_rl in number default null
548 ,p_ler_id in number default null
549 ,p_organization_id in number default null
550 ,p_benfts_grp_id in number default null
551 ,p_location_id in number default null
552 ,p_pstl_zip_rng_id in number default null
553 ,p_rptg_grp_id in number default null
554 ,p_pl_typ_id in number default null
555 ,p_opt_id in number default null
556 ,p_eligy_prfl_id in number default null
557 ,p_vrbl_rt_prfl_id in number default null
558 ,p_legal_entity_id in number default null
559 ,p_payroll_id in number default null
560 ,p_debug_messages_flag in varchar2 default null
561 ,p_cm_trgr_typ_cd in varchar2 default null
562 ,p_cm_typ_id in number default null
563 ,p_age_fctr_id in number default null
564 ,p_min_age in number default null
565 ,p_max_age in number default null
566 ,p_los_fctr_id in number default null
567 ,p_min_los in number default null
568 ,p_max_los in number default null
569 ,p_cmbn_age_los_fctr_id in number default null
570 ,p_min_cmbn in number default null
571 ,p_max_cmbn in number default null
572 ,p_date_from in date default null
573 ,p_elig_enrol_cd in varchar2 default null
574 ,p_actn_typ_id in number default null
575 ,p_use_fctr_to_sel_flag in varchar2 default 'N'
576 ,p_los_det_to_use_cd in varchar2 default null
577 ,p_audit_log_flag in varchar2 default 'N'
578 ,p_lmt_prpnip_by_org_flag in varchar2 default 'N'
579 ,p_lf_evt_ocrd_dt in date default null
580 ,p_ptnl_ler_for_per_stat_cd in varchar2 default null
581 ,p_bft_attribute_category in varchar2 default null
582 ,p_bft_attribute1 in varchar2 default null
583 ,p_bft_attribute3 in varchar2 default null
584 ,p_bft_attribute4 in varchar2 default null
585 ,p_bft_attribute5 in varchar2 default null
586 ,p_bft_attribute6 in varchar2 default null
590 ,p_bft_attribute10 in varchar2 default null
587 ,p_bft_attribute7 in varchar2 default null
588 ,p_bft_attribute8 in varchar2 default null
589 ,p_bft_attribute9 in varchar2 default null
591 ,p_bft_attribute11 in varchar2 default null
592 ,p_bft_attribute12 in varchar2 default null
593 ,p_bft_attribute13 in varchar2 default null
594 ,p_bft_attribute14 in varchar2 default null
595 ,p_bft_attribute15 in varchar2 default null
596 ,p_bft_attribute16 in varchar2 default null
597 ,p_bft_attribute17 in varchar2 default null
598 ,p_bft_attribute18 in varchar2 default null
599 ,p_bft_attribute19 in varchar2 default null
600 ,p_bft_attribute20 in varchar2 default null
601 ,p_bft_attribute21 in varchar2 default null
602 ,p_bft_attribute22 in varchar2 default null
603 ,p_bft_attribute23 in varchar2 default null
604 ,p_bft_attribute24 in varchar2 default null
605 ,p_bft_attribute25 in varchar2 default null
606 ,p_bft_attribute26 in varchar2 default null
607 ,p_bft_attribute27 in varchar2 default null
608 ,p_bft_attribute28 in varchar2 default null
609 ,p_bft_attribute29 in varchar2 default null
610 ,p_bft_attribute30 in varchar2 default null
611 ,p_request_id in number default null
612 ,p_program_application_id in number default null
613 ,p_program_id in number default null
614 ,p_program_update_date in date default null
615 ,p_object_version_number out nocopy number
616 ,p_effective_date in date
617 ,p_enrt_perd_id in number default null
618 ,p_inelg_action_cd in varchar2 default null
619 ,p_org_hierarchy_id in number default null
620 ,p_org_starting_node_id in number default null
621 ,p_grade_ladder_id in number default null
622 ,p_asg_events_to_all_sel_dt in varchar2 default null
623 ,p_rate_id in number default null
624 ,p_per_sel_dt_cd in varchar2 default null
625 ,p_per_sel_freq_cd in varchar2 default null
626 ,p_per_sel_dt_from in date default null
627 ,p_per_sel_dt_to in date default null
628 ,p_year_from in number default null
629 ,p_year_to in number default null
630 ,p_cagr_id in number default null
631 ,p_qual_type in number default null
632 ,p_qual_status in varchar2 default null
633 ,p_concat_segs in varchar2 default null
634 ,p_grant_price_val in number default null
635 ) is
636 --
637 -- Declare cursors and local variables
638 --
639 l_benefit_action_id ben_benefit_actions.benefit_action_id%TYPE;
640 l_proc varchar2(72) := g_package||'create_perf_benefit_actions';
641 l_object_version_number ben_benefit_actions.object_version_number%TYPE;
642 --
643 begin
644 --
645
646 hr_utility.set_location('Entering:'|| l_proc, 10);
647
648 --
649 -- Issue a savepoint if operating in validation only mode
650 --
651 savepoint create_perf_benefit_actions;
652 --
653 /*
654 hr_utility.set_location(l_proc, 20);
655 */
656 --
657 -- Process Logic
658 --
659 l_object_version_number := 1;
660 --
661 select ben_benefit_actions_s.nextval
662 into l_benefit_action_id
663 from sys.dual;
664 --
665 insert into ben_benefit_actions
666 (benefit_action_id
667 ,process_date
668 ,uneai_effective_date
669 ,mode_cd
670 ,derivable_factors_flag
671 ,close_uneai_flag
672 ,validate_flag
673 ,person_id
674 ,person_type_id
675 ,pgm_id
676 ,business_group_id
677 ,pl_id
678 ,popl_enrt_typ_cycl_id
679 ,no_programs_flag
680 ,no_plans_flag
681 ,comp_selection_rl
682 ,person_selection_rl
683 ,ler_id
684 ,organization_id
685 ,benfts_grp_id
686 ,location_id
687 ,pstl_zip_rng_id
688 ,rptg_grp_id
689 ,pl_typ_id
690 ,opt_id
691 ,eligy_prfl_id
692 ,vrbl_rt_prfl_id
693 ,legal_entity_id
694 ,payroll_id
695 ,debug_messages_flag
696 ,cm_trgr_typ_cd
697 ,cm_typ_id
698 ,age_fctr_id
699 ,min_age
700 ,max_age
701 ,los_fctr_id
702 ,min_los
703 ,max_los
704 ,cmbn_age_los_fctr_id
705 ,min_cmbn
706 ,max_cmbn
707 ,date_from
708 ,elig_enrol_cd
709 ,actn_typ_id
710 ,use_fctr_to_sel_flag
711 ,los_det_to_use_cd
712 ,audit_log_flag
713 ,lmt_prpnip_by_org_flag
714 ,lf_evt_ocrd_dt
715 ,ptnl_ler_for_per_stat_cd
716 ,bft_attribute_category
717 ,bft_attribute1
718 ,bft_attribute3
719 ,bft_attribute4
720 ,bft_attribute5
721 ,bft_attribute6
722 ,bft_attribute7
723 ,bft_attribute8
724 ,bft_attribute9
725 ,bft_attribute10
726 ,bft_attribute11
727 ,bft_attribute12
728 ,bft_attribute13
729 ,bft_attribute14
730 ,bft_attribute15
731 ,bft_attribute16
732 ,bft_attribute17
733 ,bft_attribute18
734 ,bft_attribute19
735 ,bft_attribute20
736 ,bft_attribute21
737 ,bft_attribute22
738 ,bft_attribute23
739 ,bft_attribute24
740 ,bft_attribute25
741 ,bft_attribute26
742 ,bft_attribute27
743 ,bft_attribute28
744 ,bft_attribute29
745 ,bft_attribute30
746 ,request_id
747 ,program_application_id
748 ,program_id
749 ,program_update_date
750 ,object_version_number
751 ,enrt_perd_id
752 ,inelg_action_cd
753 ,org_hierarchy_id
754 ,org_starting_node_id
755 ,grade_ladder_id
756 ,asg_events_to_all_sel_dt
757 ,rate_id
758 ,per_sel_dt_cd
759 ,per_sel_freq_cd
760 ,per_sel_dt_from
761 ,per_sel_dt_to
762 ,year_from
763 ,year_to
764 ,cagr_id
765 ,qual_type
766 ,qual_status
767 ,concat_segs
768 ,grant_price_val)
769 values
770 (l_benefit_action_id
771 ,p_process_date
772 ,p_uneai_effective_date
773 ,p_mode_cd
774 ,p_derivable_factors_flag
775 ,p_close_uneai_flag
776 ,p_validate_flag
777 ,p_person_id
778 ,p_person_type_id
779 ,p_pgm_id
780 ,p_business_group_id
781 ,p_pl_id
782 ,p_popl_enrt_typ_cycl_id
783 ,p_no_programs_flag
784 ,p_no_plans_flag
785 ,p_comp_selection_rl
786 ,p_person_selection_rl
787 ,p_ler_id
788 ,p_organization_id
789 ,p_benfts_grp_id
790 ,p_location_id
791 ,p_pstl_zip_rng_id
792 ,p_rptg_grp_id
793 ,p_pl_typ_id
794 ,p_opt_id
795 ,p_eligy_prfl_id
796 ,p_vrbl_rt_prfl_id
797 ,p_legal_entity_id
798 ,p_payroll_id
799 ,p_debug_messages_flag
800 ,p_cm_trgr_typ_cd
801 ,p_cm_typ_id
802 ,p_age_fctr_id
803 ,p_min_age
804 ,p_max_age
805 ,p_los_fctr_id
806 ,p_min_los
807 ,p_max_los
808 ,p_cmbn_age_los_fctr_id
809 ,p_min_cmbn
810 ,p_max_cmbn
811 ,p_date_from
812 ,p_elig_enrol_cd
813 ,p_actn_typ_id
814 ,p_use_fctr_to_sel_flag
815 ,p_los_det_to_use_cd
816 ,p_audit_log_flag
817 ,p_lmt_prpnip_by_org_flag
818 ,p_lf_evt_ocrd_dt
819 ,p_ptnl_ler_for_per_stat_cd
820 ,p_bft_attribute_category
821 ,p_bft_attribute1
822 ,p_bft_attribute3
823 ,p_bft_attribute4
824 ,p_bft_attribute5
825 ,p_bft_attribute6
826 ,p_bft_attribute7
827 ,p_bft_attribute8
828 ,p_bft_attribute9
829 ,p_bft_attribute10
830 ,p_bft_attribute11
831 ,p_bft_attribute12
832 ,p_bft_attribute13
833 ,p_bft_attribute14
834 ,p_bft_attribute15
835 ,p_bft_attribute16
836 ,p_bft_attribute17
837 ,p_bft_attribute18
838 ,p_bft_attribute19
839 ,p_bft_attribute20
840 ,p_bft_attribute21
841 ,p_bft_attribute22
842 ,p_bft_attribute23
843 ,p_bft_attribute24
844 ,p_bft_attribute25
845 ,p_bft_attribute26
846 ,p_bft_attribute27
847 ,p_bft_attribute28
848 ,p_bft_attribute29
849 ,p_bft_attribute30
850 ,p_request_id
851 ,p_program_application_id
852 ,p_program_id
853 ,p_program_update_date
854 ,l_object_version_number
855 ,p_enrt_perd_id
856 ,p_inelg_action_cd
857 ,p_org_hierarchy_id
861 ,p_rate_id
858 ,p_org_starting_node_id
859 ,p_grade_ladder_id
860 ,p_asg_events_to_all_sel_dt
862 ,p_per_sel_dt_cd
863 ,p_per_sel_freq_cd
864 ,p_per_sel_dt_from
865 ,p_per_sel_dt_to
866 ,p_year_from
867 ,p_year_to
868 ,p_cagr_id
869 ,p_qual_type
870 ,p_qual_status
871 ,p_concat_segs
872 ,p_grant_price_val);
873 --
874 -- When in validation only mode raise the Validate_Enabled exception
875 --
876 -- Set all output arguments
877 --
878 p_benefit_action_id := l_benefit_action_id;
879 p_object_version_number := l_object_version_number;
880 --
881 /*
882 hr_utility.set_location(' Leaving:'||l_proc, 70);
883 */
884 --
885 exception
886 --
887 when hr_api.validate_enabled then
888 --
889 -- As the Validate_Enabled exception has been raised
890 -- we must rollback to the savepoint
891 --
892 ROLLBACK TO create_perf_benefit_actions;
893 --
894 -- Only set output warning arguments
895 -- (Any key or derived arguments must be set to null
896 -- when validation only mode is being used.)
897 --
898 p_benefit_action_id := null;
899 p_object_version_number := null;
900 hr_utility.set_location(' Leaving:'||l_proc, 80);
901 --
902 when others then
903 --
904 -- A validation or unexpected error has occured
905 --
906 ROLLBACK TO create_perf_benefit_actions;
907 -- nocopy, reset
908 p_benefit_action_id := null;
909 p_object_version_number := null;
910 raise;
911 --
912 end create_perf_benefit_actions;
913 -- ----------------------------------------------------------------------------
914 -- |------------------------< update_benefit_actions >------------------------|
915 -- ----------------------------------------------------------------------------
916 --
917 procedure update_benefit_actions
918 (p_validate in boolean default false
919 ,p_benefit_action_id in number
920 ,p_process_date in date default hr_api.g_date
921 ,p_uneai_effective_date in date default hr_api.g_date
922 ,p_mode_cd in varchar2 default hr_api.g_varchar2
923 ,p_derivable_factors_flag in varchar2 default hr_api.g_varchar2
924 ,p_close_uneai_flag in varchar2 default hr_api.g_varchar2
925 ,p_validate_flag in varchar2 default hr_api.g_varchar2
926 ,p_person_id in number default hr_api.g_number
927 ,p_person_type_id in number default hr_api.g_number
928 ,p_pgm_id in number default hr_api.g_number
929 ,p_business_group_id in number default hr_api.g_number
930 ,p_pl_id in number default hr_api.g_number
931 ,p_popl_enrt_typ_cycl_id in number default hr_api.g_number
932 ,p_no_programs_flag in varchar2 default hr_api.g_varchar2
933 ,p_no_plans_flag in varchar2 default hr_api.g_varchar2
934 ,p_comp_selection_rl in number default hr_api.g_number
935 ,p_person_selection_rl in number default hr_api.g_number
936 ,p_ler_id in number default hr_api.g_number
937 ,p_organization_id in number default hr_api.g_number
938 ,p_benfts_grp_id in number default hr_api.g_number
939 ,p_location_id in number default hr_api.g_number
940 ,p_pstl_zip_rng_id in number default hr_api.g_number
941 ,p_rptg_grp_id in number default hr_api.g_number
942 ,p_pl_typ_id in number default hr_api.g_number
943 ,p_opt_id in number default hr_api.g_number
944 ,p_eligy_prfl_id in number default hr_api.g_number
945 ,p_vrbl_rt_prfl_id in number default hr_api.g_number
946 ,p_legal_entity_id in number default hr_api.g_number
947 ,p_payroll_id in number default hr_api.g_number
948 ,p_debug_messages_flag in varchar2 default hr_api.g_varchar2
949 ,p_cm_trgr_typ_cd in varchar2 default hr_api.g_varchar2
950 ,p_cm_typ_id in number default hr_api.g_number
951 ,p_age_fctr_id in number default hr_api.g_number
952 ,p_min_age in number default hr_api.g_number
953 ,p_max_age in number default hr_api.g_number
954 ,p_los_fctr_id in number default hr_api.g_number
955 ,p_min_los in number default hr_api.g_number
956 ,p_max_los in number default hr_api.g_number
957 ,p_cmbn_age_los_fctr_id in number default hr_api.g_number
958 ,p_min_cmbn in number default hr_api.g_number
959 ,p_max_cmbn in number default hr_api.g_number
960 ,p_date_from in date default hr_api.g_date
961 ,p_elig_enrol_cd in varchar2 default hr_api.g_varchar2
962 ,p_actn_typ_id in number default hr_api.g_number
963 ,p_use_fctr_to_sel_flag in varchar2 default hr_api.g_varchar2
964 ,p_los_det_to_use_cd in varchar2 default hr_api.g_varchar2
965 ,p_audit_log_flag in varchar2 default hr_api.g_varchar2
966 ,p_lmt_prpnip_by_org_flag in varchar2 default hr_api.g_varchar2
967 ,p_lf_evt_ocrd_dt in date default hr_api.g_date
968 ,p_ptnl_ler_for_per_stat_cd in varchar2 default hr_api.g_varchar2
969 ,p_bft_attribute_category in varchar2 default hr_api.g_varchar2
970 ,p_bft_attribute1 in varchar2 default hr_api.g_varchar2
971 ,p_bft_attribute3 in varchar2 default hr_api.g_varchar2
972 ,p_bft_attribute4 in varchar2 default hr_api.g_varchar2
973 ,p_bft_attribute5 in varchar2 default hr_api.g_varchar2
974 ,p_bft_attribute6 in varchar2 default hr_api.g_varchar2
975 ,p_bft_attribute7 in varchar2 default hr_api.g_varchar2
976 ,p_bft_attribute8 in varchar2 default hr_api.g_varchar2
977 ,p_bft_attribute9 in varchar2 default hr_api.g_varchar2
978 ,p_bft_attribute10 in varchar2 default hr_api.g_varchar2
979 ,p_bft_attribute11 in varchar2 default hr_api.g_varchar2
980 ,p_bft_attribute12 in varchar2 default hr_api.g_varchar2
981 ,p_bft_attribute13 in varchar2 default hr_api.g_varchar2
982 ,p_bft_attribute14 in varchar2 default hr_api.g_varchar2
983 ,p_bft_attribute15 in varchar2 default hr_api.g_varchar2
984 ,p_bft_attribute16 in varchar2 default hr_api.g_varchar2
985 ,p_bft_attribute17 in varchar2 default hr_api.g_varchar2
986 ,p_bft_attribute18 in varchar2 default hr_api.g_varchar2
987 ,p_bft_attribute19 in varchar2 default hr_api.g_varchar2
988 ,p_bft_attribute20 in varchar2 default hr_api.g_varchar2
989 ,p_bft_attribute21 in varchar2 default hr_api.g_varchar2
990 ,p_bft_attribute22 in varchar2 default hr_api.g_varchar2
991 ,p_bft_attribute23 in varchar2 default hr_api.g_varchar2
992 ,p_bft_attribute24 in varchar2 default hr_api.g_varchar2
993 ,p_bft_attribute25 in varchar2 default hr_api.g_varchar2
994 ,p_bft_attribute26 in varchar2 default hr_api.g_varchar2
995 ,p_bft_attribute27 in varchar2 default hr_api.g_varchar2
996 ,p_bft_attribute28 in varchar2 default hr_api.g_varchar2
997 ,p_bft_attribute29 in varchar2 default hr_api.g_varchar2
998 ,p_bft_attribute30 in varchar2 default hr_api.g_varchar2
999 ,p_request_id in number
1000 ,p_program_application_id in number
1001 ,p_program_id in number
1002 ,p_program_update_date in date
1003 ,p_object_version_number in out nocopy number
1004 ,p_effective_date in date
1005 ,p_enrt_perd_id in number default hr_api.g_number
1006 ,p_inelg_action_cd in varchar2 default hr_api.g_varchar2
1007 ,p_org_hierarchy_id in number default hr_api.g_number
1008 ,p_org_starting_node_id in number default hr_api.g_number
1009 ,p_grade_ladder_id in number default hr_api.g_number
1010 ,p_asg_events_to_all_sel_dt in varchar2 default hr_api.g_varchar2
1011 ,p_rate_id in number default hr_api.g_number
1012 ,p_per_sel_dt_cd in varchar2 default hr_api.g_varchar2
1013 ,p_per_sel_freq_cd in varchar2 default hr_api.g_varchar2
1014 ,p_per_sel_dt_from in date default hr_api.g_date
1015 ,p_per_sel_dt_to in date default hr_api.g_date
1016 ,p_year_from in number default hr_api.g_number
1017 ,p_year_to in number default hr_api.g_number
1018 ,p_cagr_id in number default hr_api.g_number
1019 ,p_qual_type in number default hr_api.g_number
1020 ,p_qual_status in varchar2 default hr_api.g_varchar2
1021 ,p_concat_segs in varchar2 default hr_api.g_varchar2
1022 ,p_grant_price_val in number default hr_api.g_number) is
1023 --
1024 -- Declare cursors and local variables
1025 --
1026 l_proc varchar2(72) := g_package||'update_benefit_actions';
1027 l_object_version_number ben_benefit_actions.object_version_number%TYPE;
1028 --
1029 begin
1030 --
1031 hr_utility.set_location('Entering:'|| l_proc, 10);
1032 --
1033 -- Issue a savepoint if operating in validation only mode
1034 --
1035 savepoint update_benefit_actions;
1036 --
1037 /*hr_utility.set_location(l_proc, 20); */
1038 --
1039 -- Process Logic
1040 --
1041 l_object_version_number := p_object_version_number;
1042 --
1043 begin
1044 --
1045 -- Start of API User Hook for the before hook of update_benefit_actions
1046 --
1047 ben_benefit_actions_bk2.update_benefit_actions_b
1048 (p_benefit_action_id => p_benefit_action_id
1049 ,p_process_date => p_process_date
1050 ,p_uneai_effective_date => p_uneai_effective_date
1051 ,p_mode_cd => p_mode_cd
1052 ,p_derivable_factors_flag => p_derivable_factors_flag
1053 ,p_close_uneai_flag => p_close_uneai_flag
1054 ,p_validate_flag => p_validate_flag
1055 ,p_person_id => p_person_id
1056 ,p_person_type_id => p_person_type_id
1057 ,p_pgm_id => p_pgm_id
1058 ,p_business_group_id => p_business_group_id
1059 ,p_pl_id => p_pl_id
1060 ,p_popl_enrt_typ_cycl_id => p_popl_enrt_typ_cycl_id
1061 ,p_no_programs_flag => p_no_programs_flag
1062 ,p_no_plans_flag => p_no_plans_flag
1063 ,p_comp_selection_rl => p_comp_selection_rl
1064 ,p_person_selection_rl => p_person_selection_rl
1065 ,p_ler_id => p_ler_id
1066 ,p_organization_id => p_organization_id
1067 ,p_benfts_grp_id => p_benfts_grp_id
1068 ,p_location_id => p_location_id
1069 ,p_pstl_zip_rng_id => p_pstl_zip_rng_id
1070 ,p_rptg_grp_id => p_rptg_grp_id
1071 ,p_pl_typ_id => p_pl_typ_id
1072 ,p_opt_id => p_opt_id
1073 ,p_eligy_prfl_id => p_eligy_prfl_id
1074 ,p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1075 ,p_legal_entity_id => p_legal_entity_id
1076 ,p_payroll_id => p_payroll_id
1077 ,p_debug_messages_flag => p_debug_messages_flag
1078 ,p_cm_trgr_typ_cd => p_cm_trgr_typ_cd
1079 ,p_cm_typ_id => p_cm_typ_id
1080 ,p_age_fctr_id => p_age_fctr_id
1081 ,p_min_age => p_min_age
1082 ,p_max_age => p_max_age
1083 ,p_los_fctr_id => p_los_fctr_id
1084 ,p_min_los => p_min_los
1085 ,p_max_los => p_max_los
1086 ,p_cmbn_age_los_fctr_id => p_cmbn_age_los_fctr_id
1087 ,p_min_cmbn => p_min_cmbn
1088 ,p_max_cmbn => p_max_cmbn
1089 ,p_date_from => p_date_from
1090 ,p_elig_enrol_cd => p_elig_enrol_cd
1091 ,p_actn_typ_id => p_actn_typ_id
1092 ,p_use_fctr_to_sel_flag => p_use_fctr_to_sel_flag
1093 ,p_los_det_to_use_cd => p_los_det_to_use_cd
1094 ,p_audit_log_flag => p_audit_log_flag
1095 ,p_lmt_prpnip_by_org_flag => p_lmt_prpnip_by_org_flag
1096 ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1097 ,p_ptnl_ler_for_per_stat_cd => p_ptnl_ler_for_per_stat_cd
1098 ,p_bft_attribute_category => p_bft_attribute_category
1099 ,p_bft_attribute1 => p_bft_attribute1
1100 ,p_bft_attribute3 => p_bft_attribute3
1101 ,p_bft_attribute4 => p_bft_attribute4
1102 ,p_bft_attribute5 => p_bft_attribute5
1103 ,p_bft_attribute6 => p_bft_attribute6
1104 ,p_bft_attribute7 => p_bft_attribute7
1105 ,p_bft_attribute8 => p_bft_attribute8
1106 ,p_bft_attribute9 => p_bft_attribute9
1107 ,p_bft_attribute10 => p_bft_attribute10
1108 ,p_bft_attribute11 => p_bft_attribute11
1109 ,p_bft_attribute12 => p_bft_attribute12
1110 ,p_bft_attribute13 => p_bft_attribute13
1111 ,p_bft_attribute14 => p_bft_attribute14
1112 ,p_bft_attribute15 => p_bft_attribute15
1113 ,p_bft_attribute16 => p_bft_attribute16
1114 ,p_bft_attribute17 => p_bft_attribute17
1115 ,p_bft_attribute18 => p_bft_attribute18
1116 ,p_bft_attribute19 => p_bft_attribute19
1117 ,p_bft_attribute20 => p_bft_attribute20
1118 ,p_bft_attribute21 => p_bft_attribute21
1119 ,p_bft_attribute22 => p_bft_attribute22
1120 ,p_bft_attribute23 => p_bft_attribute23
1121 ,p_bft_attribute24 => p_bft_attribute24
1122 ,p_bft_attribute25 => p_bft_attribute25
1123 ,p_bft_attribute26 => p_bft_attribute26
1124 ,p_bft_attribute27 => p_bft_attribute27
1125 ,p_bft_attribute28 => p_bft_attribute28
1126 ,p_bft_attribute29 => p_bft_attribute29
1127 ,p_bft_attribute30 => p_bft_attribute30
1128 ,p_object_version_number => p_object_version_number
1129 ,p_effective_date => trunc(p_effective_date)
1130 ,p_enrt_perd_id => p_enrt_perd_id
1131 ,p_inelg_action_cd => p_inelg_action_cd
1132 ,p_org_hierarchy_id => p_org_hierarchy_id
1133 ,p_org_starting_node_id => p_org_starting_node_id
1134 ,p_grade_ladder_id => p_grade_ladder_id
1135 ,p_asg_events_to_all_sel_dt => p_asg_events_to_all_sel_dt
1136 ,p_rate_id => p_rate_id
1137 ,p_per_sel_dt_cd => p_per_sel_dt_cd
1138 ,p_per_sel_freq_cd => p_per_sel_freq_cd
1139 ,p_per_sel_dt_from => p_per_sel_dt_from
1140 ,p_per_sel_dt_to => p_per_sel_dt_to
1141 ,p_year_from => p_year_from
1142 ,p_year_to => p_year_to
1143 ,p_cagr_id => p_cagr_id
1144 ,p_qual_type => p_qual_type
1145 ,p_qual_status => p_qual_status
1146 ,p_concat_segs => p_concat_segs
1147 ,p_grant_price_val => p_grant_price_val);
1148 --
1149 exception
1150 --
1151 when hr_api.cannot_find_prog_unit then
1152 --
1153 hr_api.cannot_find_prog_unit_error
1154 (p_module_name => 'UPDATE_benefit_actions'
1155 ,p_hook_type => 'BP');
1156 --
1157 -- End of API User Hook for the before hook of update_benefit_actions
1158 --
1159 end;
1160 --
1161 ben_bft_upd.upd
1162 (p_benefit_action_id => p_benefit_action_id
1163 ,p_process_date => p_process_date
1164 ,p_uneai_effective_date => p_uneai_effective_date
1165 ,p_mode_cd => p_mode_cd
1166 ,p_derivable_factors_flag => p_derivable_factors_flag
1167 ,p_close_uneai_flag => p_close_uneai_flag
1168 ,p_validate_flag => p_validate_flag
1169 ,p_person_id => p_person_id
1170 ,p_person_type_id => p_person_type_id
1171 ,p_pgm_id => p_pgm_id
1172 ,p_business_group_id => p_business_group_id
1173 ,p_pl_id => p_pl_id
1174 ,p_popl_enrt_typ_cycl_id => p_popl_enrt_typ_cycl_id
1175 ,p_no_programs_flag => p_no_programs_flag
1176 ,p_no_plans_flag => p_no_plans_flag
1177 ,p_comp_selection_rl => p_comp_selection_rl
1178 ,p_person_selection_rl => p_person_selection_rl
1179 ,p_ler_id => p_ler_id
1180 ,p_organization_id => p_organization_id
1181 ,p_benfts_grp_id => p_benfts_grp_id
1182 ,p_location_id => p_location_id
1183 ,p_pstl_zip_rng_id => p_pstl_zip_rng_id
1184 ,p_rptg_grp_id => p_rptg_grp_id
1185 ,p_pl_typ_id => p_pl_typ_id
1186 ,p_opt_id => p_opt_id
1187 ,p_eligy_prfl_id => p_eligy_prfl_id
1188 ,p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1189 ,p_legal_entity_id => p_legal_entity_id
1190 ,p_payroll_id => p_payroll_id
1191 ,p_debug_messages_flag => p_debug_messages_flag
1192 ,p_cm_trgr_typ_cd => p_cm_trgr_typ_cd
1193 ,p_cm_typ_id => p_cm_typ_id
1194 ,p_age_fctr_id => p_age_fctr_id
1195 ,p_min_age => p_min_age
1196 ,p_max_age => p_max_age
1197 ,p_los_fctr_id => p_los_fctr_id
1198 ,p_min_los => p_min_los
1199 ,p_max_los => p_max_los
1200 ,p_cmbn_age_los_fctr_id => p_cmbn_age_los_fctr_id
1201 ,p_min_cmbn => p_min_cmbn
1202 ,p_max_cmbn => p_max_cmbn
1203 ,p_date_from => p_date_from
1204 ,p_elig_enrol_cd => p_elig_enrol_cd
1205 ,p_actn_typ_id => p_actn_typ_id
1206 ,p_use_fctr_to_sel_flag => p_use_fctr_to_sel_flag
1207 ,p_los_det_to_use_cd => p_los_det_to_use_cd
1208 ,p_audit_log_flag => p_audit_log_flag
1209 ,p_lmt_prpnip_by_org_flag => p_lmt_prpnip_by_org_flag
1210 ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1214 ,p_bft_attribute3 => p_bft_attribute3
1211 ,p_ptnl_ler_for_per_stat_cd => p_ptnl_ler_for_per_stat_cd
1212 ,p_bft_attribute_category => p_bft_attribute_category
1213 ,p_bft_attribute1 => p_bft_attribute1
1215 ,p_bft_attribute4 => p_bft_attribute4
1216 ,p_bft_attribute5 => p_bft_attribute5
1217 ,p_bft_attribute6 => p_bft_attribute6
1218 ,p_bft_attribute7 => p_bft_attribute7
1219 ,p_bft_attribute8 => p_bft_attribute8
1220 ,p_bft_attribute9 => p_bft_attribute9
1221 ,p_bft_attribute10 => p_bft_attribute10
1222 ,p_bft_attribute11 => p_bft_attribute11
1223 ,p_bft_attribute12 => p_bft_attribute12
1224 ,p_bft_attribute13 => p_bft_attribute13
1225 ,p_bft_attribute14 => p_bft_attribute14
1226 ,p_bft_attribute15 => p_bft_attribute15
1227 ,p_bft_attribute16 => p_bft_attribute16
1228 ,p_bft_attribute17 => p_bft_attribute17
1229 ,p_bft_attribute18 => p_bft_attribute18
1230 ,p_bft_attribute19 => p_bft_attribute19
1231 ,p_bft_attribute20 => p_bft_attribute20
1232 ,p_bft_attribute21 => p_bft_attribute21
1233 ,p_bft_attribute22 => p_bft_attribute22
1234 ,p_bft_attribute23 => p_bft_attribute23
1235 ,p_bft_attribute24 => p_bft_attribute24
1236 ,p_bft_attribute25 => p_bft_attribute25
1237 ,p_bft_attribute26 => p_bft_attribute26
1238 ,p_bft_attribute27 => p_bft_attribute27
1239 ,p_bft_attribute28 => p_bft_attribute28
1240 ,p_bft_attribute29 => p_bft_attribute29
1241 ,p_bft_attribute30 => p_bft_attribute30
1242 ,p_request_id => p_request_id
1243 ,p_program_application_id => p_program_application_id
1244 ,p_program_id => p_program_id
1245 ,p_program_update_date => p_program_update_date
1246 ,p_object_version_number => l_object_version_number
1247 ,p_effective_date => trunc(p_effective_date)
1248 ,p_enrt_perd_id => p_enrt_perd_id
1249 ,p_inelg_action_cd => p_inelg_action_cd
1250 ,p_org_hierarchy_id => p_org_hierarchy_id
1251 ,p_org_starting_node_id => p_org_starting_node_id
1252 ,p_grade_ladder_id => p_grade_ladder_id
1253 ,p_asg_events_to_all_sel_dt => p_asg_events_to_all_sel_dt
1254 ,p_rate_id => p_rate_id
1255 ,p_per_sel_dt_cd => p_per_sel_dt_cd
1256 ,p_per_sel_freq_cd => p_per_sel_freq_cd
1257 ,p_per_sel_dt_from => p_per_sel_dt_from
1258 ,p_per_sel_dt_to => p_per_sel_dt_to
1259 ,p_year_from => p_year_from
1260 ,p_year_to => p_year_to
1261 ,p_cagr_id => p_cagr_id
1262 ,p_qual_type => p_qual_type
1263 ,p_qual_status => p_qual_status
1264 ,p_concat_segs => p_concat_segs
1265 ,p_grant_price_val => p_grant_price_val);
1266 --
1267 begin
1268 --
1269 -- Start of API User Hook for the after hook of update_benefit_actions
1270 --
1271 ben_benefit_actions_bk2.update_benefit_actions_a
1272 (p_benefit_action_id => p_benefit_action_id
1273 ,p_process_date => p_process_date
1274 ,p_uneai_effective_date => p_uneai_effective_date
1275 ,p_mode_cd => p_mode_cd
1276 ,p_derivable_factors_flag => p_derivable_factors_flag
1277 ,p_close_uneai_flag => p_close_uneai_flag
1278 ,p_validate_flag => p_validate_flag
1279 ,p_person_id => p_person_id
1280 ,p_person_type_id => p_person_type_id
1281 ,p_pgm_id => p_pgm_id
1282 ,p_business_group_id => p_business_group_id
1283 ,p_pl_id => p_pl_id
1284 ,p_popl_enrt_typ_cycl_id => p_popl_enrt_typ_cycl_id
1285 ,p_no_programs_flag => p_no_programs_flag
1286 ,p_no_plans_flag => p_no_plans_flag
1287 ,p_comp_selection_rl => p_comp_selection_rl
1288 ,p_person_selection_rl => p_person_selection_rl
1289 ,p_ler_id => p_ler_id
1290 ,p_organization_id => p_organization_id
1291 ,p_benfts_grp_id => p_benfts_grp_id
1292 ,p_location_id => p_location_id
1293 ,p_pstl_zip_rng_id => p_pstl_zip_rng_id
1294 ,p_rptg_grp_id => p_rptg_grp_id
1295 ,p_pl_typ_id => p_pl_typ_id
1296 ,p_opt_id => p_opt_id
1297 ,p_eligy_prfl_id => p_eligy_prfl_id
1298 ,p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
1299 ,p_legal_entity_id => p_legal_entity_id
1300 ,p_payroll_id => p_payroll_id
1301 ,p_debug_messages_flag => p_debug_messages_flag
1302 ,p_cm_trgr_typ_cd => p_cm_trgr_typ_cd
1303 ,p_cm_typ_id => p_cm_typ_id
1304 ,p_age_fctr_id => p_age_fctr_id
1305 ,p_min_age => p_min_age
1306 ,p_max_age => p_max_age
1307 ,p_los_fctr_id => p_los_fctr_id
1308 ,p_min_los => p_min_los
1309 ,p_max_los => p_max_los
1310 ,p_cmbn_age_los_fctr_id => p_cmbn_age_los_fctr_id
1311 ,p_min_cmbn => p_min_cmbn
1312 ,p_max_cmbn => p_max_cmbn
1313 ,p_date_from => p_date_from
1314 ,p_elig_enrol_cd => p_elig_enrol_cd
1315 ,p_actn_typ_id => p_actn_typ_id
1316 ,p_use_fctr_to_sel_flag => p_use_fctr_to_sel_flag
1317 ,p_los_det_to_use_cd => p_los_det_to_use_cd
1318 ,p_audit_log_flag => p_audit_log_flag
1319 ,p_lmt_prpnip_by_org_flag => p_lmt_prpnip_by_org_flag
1320 ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1321 ,p_ptnl_ler_for_per_stat_cd => p_ptnl_ler_for_per_stat_cd
1322 ,p_bft_attribute_category => p_bft_attribute_category
1323 ,p_bft_attribute1 => p_bft_attribute1
1324 ,p_bft_attribute3 => p_bft_attribute3
1325 ,p_bft_attribute4 => p_bft_attribute4
1326 ,p_bft_attribute5 => p_bft_attribute5
1327 ,p_bft_attribute6 => p_bft_attribute6
1328 ,p_bft_attribute7 => p_bft_attribute7
1329 ,p_bft_attribute8 => p_bft_attribute8
1330 ,p_bft_attribute9 => p_bft_attribute9
1334 ,p_bft_attribute13 => p_bft_attribute13
1331 ,p_bft_attribute10 => p_bft_attribute10
1332 ,p_bft_attribute11 => p_bft_attribute11
1333 ,p_bft_attribute12 => p_bft_attribute12
1335 ,p_bft_attribute14 => p_bft_attribute14
1336 ,p_bft_attribute15 => p_bft_attribute15
1337 ,p_bft_attribute16 => p_bft_attribute16
1338 ,p_bft_attribute17 => p_bft_attribute17
1339 ,p_bft_attribute18 => p_bft_attribute18
1340 ,p_bft_attribute19 => p_bft_attribute19
1341 ,p_bft_attribute20 => p_bft_attribute20
1342 ,p_bft_attribute21 => p_bft_attribute21
1343 ,p_bft_attribute22 => p_bft_attribute22
1344 ,p_bft_attribute23 => p_bft_attribute23
1345 ,p_bft_attribute24 => p_bft_attribute24
1346 ,p_bft_attribute25 => p_bft_attribute25
1347 ,p_bft_attribute26 => p_bft_attribute26
1348 ,p_bft_attribute27 => p_bft_attribute27
1349 ,p_bft_attribute28 => p_bft_attribute28
1350 ,p_bft_attribute29 => p_bft_attribute29
1351 ,p_bft_attribute30 => p_bft_attribute30
1352 ,p_object_version_number => l_object_version_number
1353 ,p_effective_date => trunc(p_effective_date)
1354 ,p_enrt_perd_id => p_enrt_perd_id
1355 ,p_inelg_action_cd => p_inelg_action_cd
1356 ,p_org_hierarchy_id => p_org_hierarchy_id
1357 ,p_org_starting_node_id => p_org_starting_node_id
1358 ,p_grade_ladder_id => p_grade_ladder_id
1359 ,p_asg_events_to_all_sel_dt => p_asg_events_to_all_sel_dt
1360 ,p_rate_id => p_rate_id
1361 ,p_per_sel_dt_cd => p_per_sel_dt_cd
1362 ,p_per_sel_freq_cd => p_per_sel_freq_cd
1363 ,p_per_sel_dt_from => p_per_sel_dt_from
1364 ,p_per_sel_dt_to => p_per_sel_dt_to
1365 ,p_year_from => p_year_from
1366 ,p_year_to => p_year_to
1367 ,p_cagr_id => p_cagr_id
1368 ,p_qual_type => p_qual_type
1369 ,p_qual_status => p_qual_status
1370 ,p_concat_segs => p_concat_segs
1371 ,p_grant_price_val => p_grant_price_val);
1372 --
1373 exception
1374 --
1375 when hr_api.cannot_find_prog_unit then
1376 --
1377 hr_api.cannot_find_prog_unit_error
1378 (p_module_name => 'UPDATE_benefit_actions'
1379 ,p_hook_type => 'AP');
1380 --
1381 -- End of API User Hook for the after hook of update_benefit_actions
1382 --
1383 end;
1384 --
1385 /*hr_utility.set_location(l_proc, 60); */
1386 --
1387 -- When in validation only mode raise the Validate_Enabled exception
1388 --
1389 if p_validate then
1390 raise hr_api.validate_enabled;
1391 end if;
1392 --
1393 -- Set all output arguments
1394 --
1395 p_object_version_number := l_object_version_number;
1396 --
1397 hr_utility.set_location(' Leaving:'||l_proc, 70);
1398 --
1399 exception
1400 --
1401 when hr_api.validate_enabled then
1402 --
1403 -- As the Validate_Enabled exception has been raised
1404 -- we must rollback to the savepoint
1405 --
1406 ROLLBACK TO update_benefit_actions;
1407 --
1408 -- Only set output warning arguments
1409 -- (Any key or derived arguments must be set to null
1410 -- when validation only mode is being used.)
1411 --
1412 hr_utility.set_location(' Leaving:'||l_proc, 80);
1413 --
1414 when others then
1415 --
1416 -- A validation or unexpected error has occured
1417 --
1418 ROLLBACK TO update_benefit_actions;
1419 raise;
1420 --
1421 end update_benefit_actions;
1422 -- ----------------------------------------------------------------------------
1423 -- |------------------------< delete_benefit_actions >------------------------|
1424 -- ----------------------------------------------------------------------------
1425 --
1426 procedure delete_benefit_actions
1427 (p_validate in boolean default false
1428 ,p_benefit_action_id in number
1429 ,p_object_version_number in out nocopy number
1430 ,p_effective_date in date) is
1431 --
1432 -- Declare cursors and local variables
1433 --
1434 l_proc varchar2(72) := g_package||'update_benefit_actions';
1435 l_object_version_number ben_benefit_actions.object_version_number%TYPE;
1436 --
1437 begin
1438 --
1439 hr_utility.set_location('Entering:'|| l_proc, 10);
1440 --
1441 -- Issue a savepoint if operating in validation only mode
1442 --
1443 savepoint delete_benefit_actions;
1444 --
1445 /*hr_utility.set_location(l_proc, 20); */
1446 --
1447 -- Process Logic
1448 --
1449 l_object_version_number := p_object_version_number;
1450 --
1451 begin
1452 --
1453 -- Start of API User Hook for the before hook of delete_benefit_actions
1454 --
1455 ben_benefit_actions_bk3.delete_benefit_actions_b
1456 (p_benefit_action_id => p_benefit_action_id
1457 ,p_object_version_number => p_object_version_number
1458 ,p_effective_date => trunc(p_effective_date));
1459 --
1460 exception
1461 --
1465 (p_module_name => 'DELETE_benefit_actions'
1462 when hr_api.cannot_find_prog_unit then
1463 --
1464 hr_api.cannot_find_prog_unit_error
1466 ,p_hook_type => 'BP');
1467 --
1468 -- End of API User Hook for the before hook of delete_benefit_actions
1469 --
1470 end;
1471 --
1472 ben_bft_del.del
1473 (p_benefit_action_id => p_benefit_action_id
1474 ,p_object_version_number => l_object_version_number
1475 ,p_effective_date => p_effective_date);
1476 --
1477 begin
1478 --
1479 -- Start of API User Hook for the after hook of delete_benefit_actions
1480 --
1481 ben_benefit_actions_bk3.delete_benefit_actions_a
1482 (p_benefit_action_id => p_benefit_action_id
1483 ,p_object_version_number => l_object_version_number
1484 ,p_effective_date => trunc(p_effective_date));
1485 --
1486 exception
1487 --
1488 when hr_api.cannot_find_prog_unit then
1489 --
1490 hr_api.cannot_find_prog_unit_error
1491 (p_module_name => 'DELETE_benefit_actions'
1492 ,p_hook_type => 'AP');
1493 --
1494 -- End of API User Hook for the after hook of delete_benefit_actions
1495 --
1496 end;
1497 --
1498 /*hr_utility.set_location(l_proc, 60); */
1499 --
1500 -- When in validation only mode raise the Validate_Enabled exception
1501 --
1502 if p_validate then
1503 raise hr_api.validate_enabled;
1504 end if;
1505 --
1506 hr_utility.set_location(' Leaving:'||l_proc, 70);
1507 --
1508 exception
1509 --
1510 when hr_api.validate_enabled then
1511 --
1512 -- As the Validate_Enabled exception has been raised
1513 -- we must rollback to the savepoint
1514 --
1515 ROLLBACK TO delete_benefit_actions;
1516 --
1517 -- Only set output warning arguments
1518 -- (Any key or derived arguments must be set to null
1519 -- when validation only mode is being used.)
1520 --
1521 --
1522 when others then
1523 --
1524 -- A validation or unexpected error has occured
1525 --
1526 ROLLBACK TO delete_benefit_actions;
1527 raise;
1528 --
1529 end delete_benefit_actions;
1530 --
1531 -- ----------------------------------------------------------------------------
1532 -- |-------------------------------< lck >------------------------------------|
1533 -- ----------------------------------------------------------------------------
1534 --
1535 procedure lck
1536 (p_benefit_action_id in number
1537 ,p_object_version_number in number) is
1538 --
1539 -- Declare cursors and local variables
1540 --
1541 l_proc varchar2(72) := g_package||'lck';
1542 --
1543 begin
1544 --
1545 hr_utility.set_location('Entering:'|| l_proc, 10);
1546 --
1547 ben_bft_shd.lck
1548 (p_benefit_action_id => p_benefit_action_id
1549 ,p_object_version_number => p_object_version_number);
1550 --
1551 hr_utility.set_location(' Leaving:'||l_proc, 70);
1552 --
1553 end lck;
1554 --
1555 end ben_benefit_actions_api;