[Home] [Help]
PACKAGE BODY: APPS.BEN_BFT_INS
Source
1 Package Body ben_bft_ins as
2 /* $Header: bebftrhi.pkb 115.23 2003/08/18 05:05:29 rpgupta ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ben_bft_ins.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< insert_dml >------------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This procedure controls the actual dml insert logic. The processing of
17 -- this procedure are as follows:
18 -- 1) Initialise the object_version_number to 1 if the object_version_number
19 -- is defined as an attribute for this entity.
20 -- 2) To set and unset the g_api_dml status as required (as we are about to
21 -- perform dml).
22 -- 3) To insert the row into the schema.
23 -- 4) To trap any constraint violations that may have occurred.
24 -- 5) To raise any other errors.
25 --
26 -- Prerequisites:
27 -- This is an internal private procedure which must be called from the ins
28 -- procedure and must have all mandatory attributes set (except the
29 -- object_version_number which is initialised within this procedure).
30 --
31 -- In Parameters:
32 -- A Pl/Sql record structre.
33 --
34 -- Post Success:
35 -- The specified row will be inserted into the schema.
36 --
37 -- Post Failure:
38 -- On the insert dml failure it is important to note that we always reset the
39 -- g_api_dml status to false.
40 -- If a check, unique or parent integrity constraint violation is raised the
41 -- constraint_error procedure will be called.
42 -- If any other error is reported, the error will be raised after the
43 -- g_api_dml status is reset.
44 --
45 -- Developer Implementation Notes:
46 -- None.
47 --
48 -- Access Status:
49 -- Internal Row Handler Use Only.
50 --
51 -- {End Of Comments}
52 -- ----------------------------------------------------------------------------
53 Procedure insert_dml(p_rec in out nocopy ben_bft_shd.g_rec_type) is
54 --
55 l_proc varchar2(72) := g_package||'insert_dml';
56 --
57 Begin
58 hr_utility.set_location('Entering:'||l_proc, 5);
59 p_rec.object_version_number := 1; -- Initialise the object version
60 --
61 ben_bft_shd.g_api_dml := true; -- Set the api dml status
62 --
63 -- Insert the row into: ben_benefit_actions
64 --
65 insert into ben_benefit_actions
66 ( benefit_action_id,
67 process_date,
68 uneai_effective_date,
69 mode_cd,
70 derivable_factors_flag,
71 close_uneai_flag,
72 validate_flag,
73 person_id,
74 person_type_id,
75 pgm_id,
76 business_group_id,
77 pl_id,
78 popl_enrt_typ_cycl_id,
79 no_programs_flag,
80 no_plans_flag,
81 comp_selection_rl,
82 person_selection_rl,
83 ler_id,
84 organization_id,
85 benfts_grp_id,
86 location_id,
87 pstl_zip_rng_id,
88 rptg_grp_id,
89 pl_typ_id,
90 opt_id,
91 eligy_prfl_id,
92 vrbl_rt_prfl_id,
93 legal_entity_id,
94 payroll_id,
95 debug_messages_flag,
96 cm_trgr_typ_cd,
97 cm_typ_id,
98 age_fctr_id,
99 min_age,
100 max_age,
101 los_fctr_id,
102 min_los,
103 max_los,
104 cmbn_age_los_fctr_id,
105 min_cmbn,
106 max_cmbn,
107 date_from,
108 elig_enrol_cd,
109 actn_typ_id,
110 use_fctr_to_sel_flag,
111 los_det_to_use_cd,
112 audit_log_flag,
113 lmt_prpnip_by_org_flag,
114 lf_evt_ocrd_dt,
115 ptnl_ler_for_per_stat_cd,
116 bft_attribute_category,
117 bft_attribute1,
118 bft_attribute3,
119 bft_attribute4,
120 bft_attribute5,
121 bft_attribute6,
122 bft_attribute7,
123 bft_attribute8,
124 bft_attribute9,
125 bft_attribute10,
126 bft_attribute11,
127 bft_attribute12,
128 bft_attribute13,
129 bft_attribute14,
130 bft_attribute15,
131 bft_attribute16,
132 bft_attribute17,
133 bft_attribute18,
134 bft_attribute19,
135 bft_attribute20,
136 bft_attribute21,
137 bft_attribute22,
138 bft_attribute23,
139 bft_attribute24,
140 bft_attribute25,
141 bft_attribute26,
142 bft_attribute27,
143 bft_attribute28,
144 bft_attribute29,
145 bft_attribute30,
146 request_id,
147 program_application_id,
148 program_id,
149 program_update_date,
150 object_version_number,
151 enrt_perd_id,
152 inelg_action_cd,
153 org_hierarchy_id,
154 org_starting_node_id,
155 grade_ladder_id,
156 asg_events_to_all_sel_dt,
157 rate_id,
158 per_sel_dt_cd,
159 per_sel_freq_cd,
160 per_sel_dt_from,
161 per_sel_dt_to,
162 year_from,
163 year_to,
164 cagr_id,
165 qual_type,
166 qual_status,
167 concat_segs,
168 grant_price_val
169 )
170 Values
171 ( p_rec.benefit_action_id,
172 p_rec.process_date,
173 p_rec.uneai_effective_date,
174 p_rec.mode_cd,
175 p_rec.derivable_factors_flag,
176 p_rec.close_uneai_flag,
177 p_rec.validate_flag,
178 p_rec.person_id,
179 p_rec.person_type_id,
180 p_rec.pgm_id,
181 p_rec.business_group_id,
182 p_rec.pl_id,
183 p_rec.popl_enrt_typ_cycl_id,
184 p_rec.no_programs_flag,
185 p_rec.no_plans_flag,
186 p_rec.comp_selection_rl,
187 p_rec.person_selection_rl,
188 p_rec.ler_id,
189 p_rec.organization_id,
190 p_rec.benfts_grp_id,
191 p_rec.location_id,
192 p_rec.pstl_zip_rng_id,
193 p_rec.rptg_grp_id,
194 p_rec.pl_typ_id,
195 p_rec.opt_id,
196 p_rec.eligy_prfl_id,
197 p_rec.vrbl_rt_prfl_id,
198 p_rec.legal_entity_id,
199 p_rec.payroll_id,
200 p_rec.debug_messages_flag,
201 p_rec.cm_trgr_typ_cd,
202 p_rec.cm_typ_id,
203 p_rec.age_fctr_id,
204 p_rec.min_age,
205 p_rec.max_age,
206 p_rec.los_fctr_id,
207 p_rec.min_los,
208 p_rec.max_los,
209 p_rec.cmbn_age_los_fctr_id,
210 p_rec.min_cmbn,
211 p_rec.max_cmbn,
212 p_rec.date_from,
213 p_rec.elig_enrol_cd,
214 p_rec.actn_typ_id,
215 p_rec.use_fctr_to_sel_flag,
216 p_rec.los_det_to_use_cd,
217 p_rec.audit_log_flag,
218 p_rec.lmt_prpnip_by_org_flag,
219 p_rec.lf_evt_ocrd_dt,
220 p_rec.ptnl_ler_for_per_stat_cd,
221 p_rec.bft_attribute_category,
222 p_rec.bft_attribute1,
223 p_rec.bft_attribute3,
224 p_rec.bft_attribute4,
225 p_rec.bft_attribute5,
226 p_rec.bft_attribute6,
227 p_rec.bft_attribute7,
228 p_rec.bft_attribute8,
229 p_rec.bft_attribute9,
230 p_rec.bft_attribute10,
231 p_rec.bft_attribute11,
232 p_rec.bft_attribute12,
233 p_rec.bft_attribute13,
234 p_rec.bft_attribute14,
235 p_rec.bft_attribute15,
236 p_rec.bft_attribute16,
237 p_rec.bft_attribute17,
238 p_rec.bft_attribute18,
239 p_rec.bft_attribute19,
240 p_rec.bft_attribute20,
241 p_rec.bft_attribute21,
242 p_rec.bft_attribute22,
243 p_rec.bft_attribute23,
244 p_rec.bft_attribute24,
245 p_rec.bft_attribute25,
246 p_rec.bft_attribute26,
247 p_rec.bft_attribute27,
248 p_rec.bft_attribute28,
249 p_rec.bft_attribute29,
250 p_rec.bft_attribute30,
251 p_rec.request_id,
252 p_rec.program_application_id,
253 p_rec.program_id,
254 p_rec.program_update_date,
255 p_rec.object_version_number,
256 p_rec.enrt_perd_id,
257 p_rec.inelg_action_cd,
258 p_rec.org_hierarchy_id,
259 p_rec.org_starting_node_id,
260 p_rec.grade_ladder_id,
261 p_rec.asg_events_to_all_sel_dt,
262 p_rec.rate_id,
263 p_rec.per_sel_dt_cd,
264 p_rec.per_sel_freq_cd,
265 p_rec.per_sel_dt_from,
266 p_rec.per_sel_dt_to,
267 p_rec.year_from,
268 p_rec.year_to,
269 p_rec.cagr_id,
270 p_rec.qual_type,
271 p_rec.qual_status,
272 p_rec.concat_segs,
273 p_rec.grant_price_val
274 );
275 --
276 ben_bft_shd.g_api_dml := false; -- Unset the api dml status
277 --
278 hr_utility.set_location(' Leaving:'||l_proc, 10);
279 Exception
280 When hr_api.check_integrity_violated Then
281 -- A check constraint has been violated
282 ben_bft_shd.g_api_dml := false; -- Unset the api dml status
283 ben_bft_shd.constraint_error
284 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
285 When hr_api.parent_integrity_violated Then
286 -- Parent integrity has been violated
287 ben_bft_shd.g_api_dml := false; -- Unset the api dml status
288 ben_bft_shd.constraint_error
289 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
290 When hr_api.unique_integrity_violated Then
291 -- Unique integrity has been violated
292 ben_bft_shd.g_api_dml := false; -- Unset the api dml status
293 ben_bft_shd.constraint_error
294 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
295 When Others Then
296 ben_bft_shd.g_api_dml := false; -- Unset the api dml status
297 Raise;
298 End insert_dml;
299 --
300 -- ----------------------------------------------------------------------------
301 -- |------------------------------< pre_insert >------------------------------|
302 -- ----------------------------------------------------------------------------
303 -- {Start Of Comments}
304 --
305 -- Description:
306 -- This private procedure contains any processing which is required before
307 -- the insert dml. Presently, if the entity has a corresponding primary
308 -- key which is maintained by an associating sequence, the primary key for
309 -- the entity will be populated with the next sequence value in
310 -- preparation for the insert dml.
311 --
312 -- Prerequisites:
313 -- This is an internal procedure which is called from the ins procedure.
314 --
315 -- In Parameters:
316 -- A Pl/Sql record structre.
317 --
318 -- Post Success:
319 -- Processing continues.
320 --
321 -- Post Failure:
322 -- If an error has occurred, an error message and exception will be raised
323 -- but not handled.
324 --
325 -- Developer Implementation Notes:
326 -- Any pre-processing required before the insert dml is issued should be
327 -- coded within this procedure. As stated above, a good example is the
328 -- generation of a primary key number via a corresponding sequence.
329 -- It is important to note that any 3rd party maintenance should be reviewed
330 -- before placing in this procedure.
331 --
332 -- Access Status:
333 -- Internal Row Handler Use Only.
334 --
335 -- {End Of Comments}
336 -- ----------------------------------------------------------------------------
337 Procedure pre_insert(p_rec in out nocopy ben_bft_shd.g_rec_type) is
338 --
339 l_proc varchar2(72) := g_package||'pre_insert';
340 --
341 Cursor C_Sel1 is select ben_benefit_actions_s.nextval from sys.dual;
342 --
343 Begin
344 hr_utility.set_location('Entering:'||l_proc, 5);
345 --
346 --
347 -- Select the next sequence number
348 --
349 Open C_Sel1;
350 Fetch C_Sel1 Into p_rec.benefit_action_id;
351 Close C_Sel1;
352 --
353 hr_utility.set_location(' Leaving:'||l_proc, 10);
354 End pre_insert;
355 --
356 -- ----------------------------------------------------------------------------
357 -- |-----------------------------< post_insert >------------------------------|
358 -- ----------------------------------------------------------------------------
359 -- {Start Of Comments}
360 --
361 -- Description:
362 -- This private procedure contains any processing which is required after the
363 -- insert dml.
364 --
365 -- Prerequisites:
366 -- This is an internal procedure which is called from the ins procedure.
367 --
368 -- In Parameters:
369 -- A Pl/Sql record structre.
370 --
371 -- Post Success:
372 -- Processing continues.
373 --
374 -- Post Failure:
375 -- If an error has occurred, an error message and exception will be raised
376 -- but not handled.
377 --
378 -- Developer Implementation Notes:
379 -- Any post-processing required after the insert dml is issued should be
380 -- coded within this procedure. It is important to note that any 3rd party
381 -- maintenance should be reviewed before placing in this procedure.
382 --
383 -- Access Status:
384 -- Internal Row Handler Use Only.
385 --
386 -- {End Of Comments}
387 -- ----------------------------------------------------------------------------
388 Procedure post_insert(
389 p_effective_date in date,p_rec in ben_bft_shd.g_rec_type) is
390 --
391 l_proc varchar2(72) := g_package||'post_insert';
392 --
393 Begin
394 hr_utility.set_location('Entering:'||l_proc, 5);
395 --
396 --
397 -- Start of API User Hook for post_insert.
398 --
399 begin
400 --
401 ben_bft_rki.after_insert
402 (
403 p_benefit_action_id =>p_rec.benefit_action_id
404 ,p_process_date =>p_rec.process_date
405 ,p_uneai_effective_date =>p_rec.uneai_effective_date
406 ,p_mode_cd =>p_rec.mode_cd
407 ,p_derivable_factors_flag =>p_rec.derivable_factors_flag
408 ,p_close_uneai_flag =>p_rec.close_uneai_flag
409 ,p_validate_flag =>p_rec.validate_flag
410 ,p_person_id =>p_rec.person_id
411 ,p_person_type_id =>p_rec.person_type_id
412 ,p_pgm_id =>p_rec.pgm_id
413 ,p_business_group_id =>p_rec.business_group_id
414 ,p_pl_id =>p_rec.pl_id
415 ,p_popl_enrt_typ_cycl_id =>p_rec.popl_enrt_typ_cycl_id
416 ,p_no_programs_flag =>p_rec.no_programs_flag
417 ,p_no_plans_flag =>p_rec.no_plans_flag
418 ,p_comp_selection_rl =>p_rec.comp_selection_rl
419 ,p_person_selection_rl =>p_rec.person_selection_rl
420 ,p_ler_id =>p_rec.ler_id
421 ,p_organization_id =>p_rec.organization_id
422 ,p_benfts_grp_id =>p_rec.benfts_grp_id
423 ,p_location_id =>p_rec.location_id
424 ,p_pstl_zip_rng_id =>p_rec.pstl_zip_rng_id
425 ,p_rptg_grp_id =>p_rec.rptg_grp_id
426 ,p_pl_typ_id =>p_rec.pl_typ_id
427 ,p_opt_id =>p_rec.opt_id
428 ,p_eligy_prfl_id =>p_rec.eligy_prfl_id
429 ,p_vrbl_rt_prfl_id =>p_rec.vrbl_rt_prfl_id
430 ,p_legal_entity_id =>p_rec.legal_entity_id
431 ,p_payroll_id =>p_rec.payroll_id
432 ,p_debug_messages_flag =>p_rec.debug_messages_flag
433 ,p_cm_trgr_typ_cd =>p_rec.cm_trgr_typ_cd
434 ,p_cm_typ_id =>p_rec.cm_typ_id
435 ,p_age_fctr_id =>p_rec.age_fctr_id
436 ,p_min_age =>p_rec.min_age
437 ,p_max_age =>p_rec.max_age
438 ,p_los_fctr_id =>p_rec.los_fctr_id
439 ,p_min_los =>p_rec.min_los
440 ,p_max_los =>p_rec.max_los
441 ,p_cmbn_age_los_fctr_id =>p_rec.cmbn_age_los_fctr_id
442 ,p_min_cmbn =>p_rec.min_cmbn
443 ,p_max_cmbn =>p_rec.max_cmbn
444 ,p_date_from =>p_rec.date_from
445 ,p_elig_enrol_cd =>p_rec.elig_enrol_cd
446 ,p_actn_typ_id =>p_rec.actn_typ_id
447 ,p_use_fctr_to_sel_flag =>p_rec.use_fctr_to_sel_flag
448 ,p_los_det_to_use_cd =>p_rec.los_det_to_use_cd
449 ,p_audit_log_flag =>p_rec.audit_log_flag
450 ,p_lmt_prpnip_by_org_flag =>p_rec.lmt_prpnip_by_org_flag
451 ,p_lf_evt_ocrd_dt =>p_rec.lf_evt_ocrd_dt
452 ,p_ptnl_ler_for_per_stat_cd =>p_rec.ptnl_ler_for_per_stat_cd
453 ,p_bft_attribute_category =>p_rec.bft_attribute_category
454 ,p_bft_attribute1 =>p_rec.bft_attribute1
455 ,p_bft_attribute3 =>p_rec.bft_attribute3
456 ,p_bft_attribute4 =>p_rec.bft_attribute4
457 ,p_bft_attribute5 =>p_rec.bft_attribute5
458 ,p_bft_attribute6 =>p_rec.bft_attribute6
459 ,p_bft_attribute7 =>p_rec.bft_attribute7
460 ,p_bft_attribute8 =>p_rec.bft_attribute8
461 ,p_bft_attribute9 =>p_rec.bft_attribute9
462 ,p_bft_attribute10 =>p_rec.bft_attribute10
463 ,p_bft_attribute11 =>p_rec.bft_attribute11
464 ,p_bft_attribute12 =>p_rec.bft_attribute12
465 ,p_bft_attribute13 =>p_rec.bft_attribute13
466 ,p_bft_attribute14 =>p_rec.bft_attribute14
467 ,p_bft_attribute15 =>p_rec.bft_attribute15
468 ,p_bft_attribute16 =>p_rec.bft_attribute16
469 ,p_bft_attribute17 =>p_rec.bft_attribute17
470 ,p_bft_attribute18 =>p_rec.bft_attribute18
471 ,p_bft_attribute19 =>p_rec.bft_attribute19
472 ,p_bft_attribute20 =>p_rec.bft_attribute20
473 ,p_bft_attribute21 =>p_rec.bft_attribute21
474 ,p_bft_attribute22 =>p_rec.bft_attribute22
475 ,p_bft_attribute23 =>p_rec.bft_attribute23
476 ,p_bft_attribute24 =>p_rec.bft_attribute24
477 ,p_bft_attribute25 =>p_rec.bft_attribute25
478 ,p_bft_attribute26 =>p_rec.bft_attribute26
479 ,p_bft_attribute27 =>p_rec.bft_attribute27
480 ,p_bft_attribute28 =>p_rec.bft_attribute28
481 ,p_bft_attribute29 =>p_rec.bft_attribute29
482 ,p_bft_attribute30 =>p_rec.bft_attribute30
483 ,p_effective_date =>p_effective_date
484 ,p_enrt_perd_id =>p_rec.enrt_perd_id
485 ,p_inelg_action_cd =>p_rec.inelg_action_cd
486 ,p_org_hierarchy_id =>p_rec.org_hierarchy_id
487 ,p_org_starting_node_id =>p_rec.org_starting_node_id
488 ,p_grade_ladder_id =>p_rec.grade_ladder_id
489 ,p_asg_events_to_all_sel_dt =>p_rec.asg_events_to_all_sel_dt
490 ,p_rate_id =>p_rec.rate_id
491 ,p_per_sel_dt_cd =>p_rec.per_sel_dt_cd
492 ,p_per_sel_freq_cd =>p_rec.per_sel_freq_cd
493 ,p_per_sel_dt_from =>p_rec.per_sel_dt_from
494 ,p_per_sel_dt_to =>p_rec.per_sel_dt_to
495 ,p_year_from =>p_rec.year_from
496 ,p_year_to =>p_rec.year_to
497 ,p_cagr_id =>p_rec.cagr_id
498 ,p_qual_type =>p_rec.qual_type
499 ,p_qual_status =>p_rec.qual_status
500 ,p_concat_segs =>p_rec.concat_segs
501 ,p_grant_price_val =>p_rec.grant_price_val
502 ,p_object_version_number =>p_rec.object_version_number
503 );
504 --
505 exception
506 --
507 when hr_api.cannot_find_prog_unit then
508 --
509 hr_api.cannot_find_prog_unit_error
510 (p_module_name => 'ben_benefit_actions'
511 ,p_hook_type => 'AI');
512 --
513 end;
514 --
515 -- End of API User Hook for post_insert.
516 --
517 --
518 hr_utility.set_location(' Leaving:'||l_proc, 10);
519 End post_insert;
520 --
521 -- ----------------------------------------------------------------------------
522 -- |---------------------------------< ins >----------------------------------|
523 -- ----------------------------------------------------------------------------
524 Procedure ins
525 (
526 p_effective_date in date,
527 p_rec in out nocopy ben_bft_shd.g_rec_type
528 ) is
529 --
530 l_proc varchar2(72) := g_package||'ins';
531 --
532 Begin
533 hr_utility.set_location('Entering:'||l_proc, 5);
534 --
535 -- Call the supporting insert validate operations
536 --
537 ben_bft_bus.insert_validate(p_rec,p_effective_date);
538 --
539 -- Call the supporting pre-insert operation
540 --
541 pre_insert(p_rec);
542 --
543 -- Insert the row
544 --
545 insert_dml(p_rec);
546 --
547 -- Call the supporting post-insert operation
548 --
549 post_insert(p_effective_date,p_rec);
550 end ins;
551 --
552 -- ----------------------------------------------------------------------------
553 -- |---------------------------------< ins >----------------------------------|
554 -- ----------------------------------------------------------------------------
555 Procedure ins
556 (
557 p_effective_date in date,
558 p_benefit_action_id out nocopy number,
559 p_process_date in date,
560 p_uneai_effective_date in date,
561 p_mode_cd in varchar2,
562 p_derivable_factors_flag in varchar2,
563 p_close_uneai_flag in varchar2,
564 p_validate_flag in varchar2,
565 p_person_id in number default null,
566 p_person_type_id in number default null,
567 p_pgm_id in number default null,
568 p_business_group_id in number,
569 p_pl_id in number default null,
570 p_popl_enrt_typ_cycl_id in number default null,
571 p_no_programs_flag in varchar2,
572 p_no_plans_flag in varchar2,
573 p_comp_selection_rl in number default null,
574 p_person_selection_rl in number default null,
575 p_ler_id in number default null,
576 p_organization_id in number default null,
577 p_benfts_grp_id in number default null,
578 p_location_id in number default null,
579 p_pstl_zip_rng_id in number default null,
580 p_rptg_grp_id in number default null,
581 p_pl_typ_id in number default null,
582 p_opt_id in number default null,
583 p_eligy_prfl_id in number default null,
584 p_vrbl_rt_prfl_id in number default null,
585 p_legal_entity_id in number default null,
586 p_payroll_id in number default null,
587 p_debug_messages_flag in varchar2,
588 p_cm_trgr_typ_cd in varchar2 default null,
589 p_cm_typ_id in number default null,
590 p_age_fctr_id in number default null,
591 p_min_age in number default null,
592 p_max_age in number default null,
593 p_los_fctr_id in number default null,
594 p_min_los in number default null,
595 p_max_los in number default null,
596 p_cmbn_age_los_fctr_id in number default null,
597 p_min_cmbn in number default null,
598 p_max_cmbn in number default null,
599 p_date_from in date default null,
600 p_elig_enrol_cd in varchar2 default null,
601 p_actn_typ_id in number default null,
602 p_use_fctr_to_sel_flag in varchar2 default 'N',
603 p_los_det_to_use_cd in varchar2 default null,
604 p_audit_log_flag in varchar2 default 'N',
605 p_lmt_prpnip_by_org_flag in varchar2 default 'N',
606 p_lf_evt_ocrd_dt in date default null,
607 p_ptnl_ler_for_per_stat_cd in varchar2 default null,
608 p_bft_attribute_category in varchar2 default null,
609 p_bft_attribute1 in varchar2 default null,
610 p_bft_attribute3 in varchar2 default null,
611 p_bft_attribute4 in varchar2 default null,
612 p_bft_attribute5 in varchar2 default null,
613 p_bft_attribute6 in varchar2 default null,
614 p_bft_attribute7 in varchar2 default null,
615 p_bft_attribute8 in varchar2 default null,
616 p_bft_attribute9 in varchar2 default null,
617 p_bft_attribute10 in varchar2 default null,
618 p_bft_attribute11 in varchar2 default null,
619 p_bft_attribute12 in varchar2 default null,
620 p_bft_attribute13 in varchar2 default null,
621 p_bft_attribute14 in varchar2 default null,
622 p_bft_attribute15 in varchar2 default null,
623 p_bft_attribute16 in varchar2 default null,
624 p_bft_attribute17 in varchar2 default null,
625 p_bft_attribute18 in varchar2 default null,
626 p_bft_attribute19 in varchar2 default null,
627 p_bft_attribute20 in varchar2 default null,
628 p_bft_attribute21 in varchar2 default null,
629 p_bft_attribute22 in varchar2 default null,
630 p_bft_attribute23 in varchar2 default null,
631 p_bft_attribute24 in varchar2 default null,
632 p_bft_attribute25 in varchar2 default null,
633 p_bft_attribute26 in varchar2 default null,
634 p_bft_attribute27 in varchar2 default null,
635 p_bft_attribute28 in varchar2 default null,
636 p_bft_attribute29 in varchar2 default null,
637 p_bft_attribute30 in varchar2 default null,
638 p_request_id in number default null,
639 p_program_application_id in number default null,
640 p_program_id in number default null,
641 p_program_update_date in date default null,
642 p_enrt_perd_id in number default null,
643 p_inelg_action_cd in varchar2 default null,
644 p_org_hierarchy_id in number default null,
645 p_org_starting_node_id in number default null,
646 p_grade_ladder_id in number default null,
647 p_asg_events_to_all_sel_dt in varchar2 default null,
648 p_rate_id in number default null,
649 p_per_sel_dt_cd in varchar2 default null,
650 p_per_sel_freq_cd in varchar2 default null,
651 p_per_sel_dt_from in date default null,
652 p_per_sel_dt_to in date default null,
653 p_year_from in number default null,
654 p_year_to in number default null,
655 p_cagr_id in number default null,
656 p_qual_type in number default null,
657 p_qual_status in varchar2 default null,
658 p_concat_segs in varchar2 default null,
659 p_grant_price_val in number default null,
660 p_object_version_number out nocopy number
661 ) is
662 --
663 l_rec ben_bft_shd.g_rec_type;
664 l_proc varchar2(72) := g_package||'ins';
665 --
666 Begin
667 hr_utility.set_location('Entering:'||l_proc, 5);
668 --
669 -- Call conversion function to turn arguments into the
670 -- p_rec structure.
671 --
672 l_rec :=
673 ben_bft_shd.convert_args
674 (
675 null,
676 p_process_date,
677 p_uneai_effective_date,
678 p_mode_cd,
679 p_derivable_factors_flag,
680 p_close_uneai_flag ,
681 p_validate_flag,
682 p_person_id,
683 p_person_type_id,
684 p_pgm_id,
685 p_business_group_id,
686 p_pl_id,
687 p_popl_enrt_typ_cycl_id,
688 p_no_programs_flag,
689 p_no_plans_flag,
690 p_comp_selection_rl,
691 p_person_selection_rl,
692 p_ler_id,
693 p_organization_id,
694 p_benfts_grp_id,
695 p_location_id,
696 p_pstl_zip_rng_id,
697 p_rptg_grp_id,
698 p_pl_typ_id,
699 p_opt_id,
700 p_eligy_prfl_id,
701 p_vrbl_rt_prfl_id,
702 p_legal_entity_id,
703 p_payroll_id,
704 p_debug_messages_flag,
705 p_cm_trgr_typ_cd,
706 p_cm_typ_id,
707 p_age_fctr_id,
708 p_min_age,
709 p_max_age,
710 p_los_fctr_id,
711 p_min_los,
712 p_max_los,
713 p_cmbn_age_los_fctr_id,
714 p_min_cmbn,
715 p_max_cmbn,
716 p_date_from,
717 p_elig_enrol_cd,
718 p_actn_typ_id,
719 p_use_fctr_to_sel_flag,
720 p_los_det_to_use_cd,
721 p_audit_log_flag,
722 p_lmt_prpnip_by_org_flag,
723 p_lf_evt_ocrd_dt,
724 p_ptnl_ler_for_per_stat_cd,
725 p_bft_attribute_category,
726 p_bft_attribute1,
727 p_bft_attribute3,
728 p_bft_attribute4,
729 p_bft_attribute5,
730 p_bft_attribute6,
731 p_bft_attribute7,
732 p_bft_attribute8,
733 p_bft_attribute9,
734 p_bft_attribute10,
735 p_bft_attribute11,
736 p_bft_attribute12,
737 p_bft_attribute13,
738 p_bft_attribute14,
739 p_bft_attribute15,
740 p_bft_attribute16,
741 p_bft_attribute17,
742 p_bft_attribute18,
743 p_bft_attribute19,
744 p_bft_attribute20,
745 p_bft_attribute21,
746 p_bft_attribute22,
747 p_bft_attribute23,
748 p_bft_attribute24,
749 p_bft_attribute25,
750 p_bft_attribute26,
751 p_bft_attribute27,
752 p_bft_attribute28,
753 p_bft_attribute29,
754 p_bft_attribute30,
755 p_request_id,
756 p_program_application_id,
757 p_program_id,
758 p_program_update_date,
759 null,
760 p_enrt_perd_id,
761 p_inelg_action_cd,
762 p_org_hierarchy_id,
763 p_org_starting_node_id,
764 p_grade_ladder_id,
765 p_asg_events_to_all_sel_dt,
766 p_rate_id,
767 p_per_sel_dt_cd,
768 p_per_sel_freq_cd,
769 p_per_sel_dt_from,
770 p_per_sel_dt_to,
771 p_year_from,
772 p_year_to,
773 p_cagr_id,
774 p_qual_type,
775 p_qual_status,
776 p_concat_segs,
777 p_grant_price_val
778 );
779 --
780 -- Having converted the arguments into the ben_bft_rec
781 -- plsql record structure we call the corresponding record business process.
782 --
783 ins(p_effective_date,l_rec);
784 --
785 -- As the primary key argument(s)
786 -- are specified as an OUT's we must set these values.
787 --
788 p_benefit_action_id := l_rec.benefit_action_id;
789 p_object_version_number := l_rec.object_version_number;
790 --
791 hr_utility.set_location(' Leaving:'||l_proc, 10);
792 End ins;
793 --
794 end ben_bft_ins;