[Home] [Help]
PACKAGE BODY: APPS.BEN_VPF_INS
Source
1 Package Body ben_vpf_ins as
2 /* $Header: bevpfrhi.pkb 120.1.12010000.1 2008/07/29 13:07:55 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ben_vpf_ins.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------------< dt_insert_dml >-----------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This procedure controls the actual dml insert logic for datetrack. The
17 -- functions of this procedure are as follows:
18 -- 1) Get the object_version_number.
19 -- 2) To set the effective start and end dates to the corresponding
20 -- validation start and end dates. Also, the object version number
21 -- record attribute is set.
22 -- 3) To set and unset the g_api_dml status as required (as we are about to
23 -- perform dml).
24 -- 4) To insert the row into the schema with the derived effective start
25 -- and end dates and the object version number.
26 -- 5) To trap any constraint violations that may have occurred.
27 -- 6) To raise any other errors.
28 --
29 -- Prerequisites:
30 -- This is an internal private procedure which must be called from the
31 -- insert_dml and pre_update (logic permitting) procedure and must have
32 -- all mandatory arguments set.
33 --
34 -- In Parameters:
35 -- A Pl/Sql record structre.
36 --
37 -- Post Success:
38 -- The specified row will be inserted into the schema.
39 --
40 -- Post Failure:
41 -- On the insert dml failure it is important to note that we always reset the
42 -- g_api_dml status to false.
43 -- If a check or unique integrity constraint violation is raised the
44 -- constraint_error procedure will be called.
45 -- If any other error is reported, the error will be raised after the
46 -- g_api_dml status is reset.
47 --
48 -- Developer Implementation Notes:
49 -- This is an internal datetrack maintenance procedure which should
50 -- not be modified in anyway.
51 --
52 -- Access Status:
53 -- Internal Row Handler Use Only.
54 --
55 -- {End Of Comments}
56 -- ----------------------------------------------------------------------------
57 Procedure dt_insert_dml
58 (p_rec in out nocopy ben_vpf_shd.g_rec_type,
59 p_effective_date in date,
60 p_datetrack_mode in varchar2,
61 p_validation_start_date in date,
62 p_validation_end_date in date) is
63 --
64 -- Cursor to select 'old' created AOL who column values
65 --
66 Cursor C_Sel1 Is
67 select t.created_by,
68 t.creation_date
69 from ben_vrbl_rt_prfl_f t
70 where t.vrbl_rt_prfl_id = p_rec.vrbl_rt_prfl_id
71 and t.effective_start_date =
72 ben_vpf_shd.g_old_rec.effective_start_date
73 and t.effective_end_date = (p_validation_start_date - 1);
74 --
75 l_proc varchar2(72) := g_package||'dt_insert_dml';
76 l_created_by ben_vrbl_rt_prfl_f.created_by%TYPE;
77 l_creation_date ben_vrbl_rt_prfl_f.creation_date%TYPE;
78 l_last_update_date ben_vrbl_rt_prfl_f.last_update_date%TYPE;
79 l_last_updated_by ben_vrbl_rt_prfl_f.last_updated_by%TYPE;
80 l_last_update_login ben_vrbl_rt_prfl_f.last_update_login%TYPE;
81 --
82 Begin
83 hr_utility.set_location('Entering:'||l_proc, 5);
84 --
85 -- Get the object version number for the insert
86 --
87 p_rec.object_version_number :=
88 dt_api.get_object_version_number
89 (p_base_table_name => 'ben_vrbl_rt_prfl_f',
90 p_base_key_column => 'vrbl_rt_prfl_id',
91 p_base_key_value => p_rec.vrbl_rt_prfl_id);
92 --
93 -- Set the effective start and end dates to the corresponding
94 -- validation start and end dates
95 --
96 p_rec.effective_start_date := p_validation_start_date;
97 p_rec.effective_end_date := p_validation_end_date;
98 --
99 -- If the datetrack_mode is not INSERT then we must populate the WHO
100 -- columns with the 'old' creation values and 'new' updated values.
101 --
102 If (p_datetrack_mode <> 'INSERT') then
103 hr_utility.set_location(l_proc, 10);
104 --
105 -- Select the 'old' created values
106 --
107 Open C_Sel1;
108 Fetch C_Sel1 Into l_created_by, l_creation_date;
109 If C_Sel1%notfound Then
110 --
111 -- The previous 'old' created row has not been found. We need
112 -- to error as an internal datetrack problem exists.
113 --
114 Close C_Sel1;
115 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
116 hr_utility.set_message_token('PROCEDURE', l_proc);
117 hr_utility.set_message_token('STEP','10');
118 hr_utility.raise_error;
119 End If;
120 Close C_Sel1;
121 --
122 -- Set the AOL updated WHO values
123 --
124 l_last_update_date := sysdate;
125 l_last_updated_by := fnd_global.user_id;
126 l_last_update_login := fnd_global.login_id;
127 End If;
128 --
129 ben_vpf_shd.g_api_dml := true; -- Set the api dml status
130 --
131 -- Insert the row into: ben_vrbl_rt_prfl_f
132 --
133 insert into ben_vrbl_rt_prfl_f
134 ( vrbl_rt_prfl_id,
135 effective_start_date,
136 effective_end_date,
137 pl_typ_opt_typ_id,
138 pl_id,
139 oipl_id,
140 comp_lvl_fctr_id,
141 business_group_id,
142 acty_typ_cd,
143 rt_typ_cd,
144 bnft_rt_typ_cd,
145 tx_typ_cd,
146 vrbl_rt_trtmt_cd,
147 acty_ref_perd_cd,
148 mlt_cd,
149 incrmnt_elcn_val,
150 dflt_elcn_val,
151 mx_elcn_val,
152 mn_elcn_val,
153 lwr_lmt_val,
154 lwr_lmt_calc_rl,
155 upr_lmt_val,
156 upr_lmt_calc_rl,
157 ultmt_upr_lmt,
158 ultmt_lwr_lmt,
159 ultmt_upr_lmt_calc_rl,
160 ultmt_lwr_lmt_calc_rl,
161 ann_mn_elcn_val,
162 ann_mx_elcn_val,
163 val,
164 name,
165 no_mn_elcn_val_dfnd_flag,
166 no_mx_elcn_val_dfnd_flag,
167 alwys_sum_all_cvg_flag,
168 alwys_cnt_all_prtts_flag,
169 val_calc_rl,
170 vrbl_rt_prfl_stat_cd,
171 vrbl_usg_cd,
172 asmt_to_use_cd,
173 rndg_cd,
174 rndg_rl,
175 rt_hrly_slrd_flag,
176 rt_pstl_cd_flag,
177 rt_lbr_mmbr_flag,
178 rt_lgl_enty_flag,
179 rt_benfts_grp_flag,
180 rt_wk_loc_flag,
181 rt_brgng_unit_flag,
182 rt_age_flag,
183 rt_los_flag,
184 rt_per_typ_flag,
185 rt_fl_tm_pt_tm_flag,
186 rt_ee_stat_flag,
187 rt_grd_flag,
188 rt_pct_fl_tm_flag,
189 rt_asnt_set_flag,
190 rt_hrs_wkd_flag,
191 rt_comp_lvl_flag,
192 rt_org_unit_flag,
193 rt_loa_rsn_flag,
194 rt_pyrl_flag,
195 rt_schedd_hrs_flag,
196 rt_py_bss_flag,
197 rt_prfl_rl_flag,
198 rt_cmbn_age_los_flag,
199 rt_prtt_pl_flag,
200 rt_svc_area_flag,
201 rt_ppl_grp_flag,
202 rt_dsbld_flag,
203 rt_hlth_cvg_flag,
204 rt_poe_flag,
205 rt_ttl_cvg_vol_flag,
206 rt_ttl_prtt_flag,
207 rt_gndr_flag,
208 rt_tbco_use_flag,
209 vpf_attribute_category,
210 vpf_attribute1,
211 vpf_attribute2,
212 vpf_attribute3,
213 vpf_attribute4,
214 vpf_attribute5,
215 vpf_attribute6,
216 vpf_attribute7,
217 vpf_attribute8,
218 vpf_attribute9,
219 vpf_attribute10,
220 vpf_attribute11,
221 vpf_attribute12,
222 vpf_attribute13,
223 vpf_attribute14,
224 vpf_attribute15,
225 vpf_attribute16,
226 vpf_attribute17,
227 vpf_attribute18,
228 vpf_attribute19,
229 vpf_attribute20,
230 vpf_attribute21,
231 vpf_attribute22,
232 vpf_attribute23,
233 vpf_attribute24,
234 vpf_attribute25,
235 vpf_attribute26,
236 vpf_attribute27,
237 vpf_attribute28,
238 vpf_attribute29,
239 vpf_attribute30,
240 object_version_number,
241 created_by,
242 creation_date,
243 last_update_date,
244 last_updated_by,
245 last_update_login,
246 rt_cntng_prtn_prfl_flag,
247 rt_cbr_quald_bnf_flag ,
248 rt_optd_mdcr_flag ,
249 rt_lvg_rsn_flag ,
250 rt_pstn_flag ,
251 rt_comptncy_flag ,
252 rt_job_flag ,
253 rt_qual_titl_flag ,
254 rt_dpnt_cvrd_pl_flag ,
255 rt_dpnt_cvrd_plip_flag ,
256 rt_dpnt_cvrd_ptip_flag ,
257 rt_dpnt_cvrd_pgm_flag ,
258 rt_enrld_oipl_flag ,
259 rt_enrld_pl_flag ,
260 rt_enrld_plip_flag ,
261 rt_enrld_ptip_flag ,
262 rt_enrld_pgm_flag ,
263 rt_prtt_anthr_pl_flag ,
264 rt_othr_ptip_flag ,
265 rt_no_othr_cvg_flag ,
266 rt_dpnt_othr_ptip_flag ,
267 rt_qua_in_gr_flag,
268 rt_perf_rtng_flag,
269 rt_elig_prfl_flag
270 )
271 Values
272 ( p_rec.vrbl_rt_prfl_id,
273 p_rec.effective_start_date,
274 p_rec.effective_end_date,
275 p_rec.pl_typ_opt_typ_id,
276 p_rec.pl_id,
277 p_rec.oipl_id,
278 p_rec.comp_lvl_fctr_id,
279 p_rec.business_group_id,
280 p_rec.acty_typ_cd,
281 p_rec.rt_typ_cd,
282 p_rec.bnft_rt_typ_cd,
283 p_rec.tx_typ_cd,
284 p_rec.vrbl_rt_trtmt_cd,
285 p_rec.acty_ref_perd_cd,
286 p_rec.mlt_cd,
287 p_rec.incrmnt_elcn_val,
288 p_rec.dflt_elcn_val,
289 p_rec.mx_elcn_val,
290 p_rec.mn_elcn_val,
291 p_rec.lwr_lmt_val,
292 p_rec.lwr_lmt_calc_rl,
293 p_rec.upr_lmt_val,
294 p_rec.upr_lmt_calc_rl,
295 p_rec.ultmt_upr_lmt,
296 p_rec.ultmt_lwr_lmt,
297 p_rec.ultmt_upr_lmt_calc_rl,
298 p_rec.ultmt_lwr_lmt_calc_rl,
299 p_rec.ann_mn_elcn_val,
300 p_rec.ann_mx_elcn_val,
301 p_rec.val,
302 p_rec.name,
303 p_rec.no_mn_elcn_val_dfnd_flag,
304 p_rec.no_mx_elcn_val_dfnd_flag,
305 p_rec.alwys_sum_all_cvg_flag,
306 p_rec.alwys_cnt_all_prtts_flag,
307 p_rec.val_calc_rl,
308 p_rec.vrbl_rt_prfl_stat_cd,
309 p_rec.vrbl_usg_cd,
310 p_rec.asmt_to_use_cd,
311 p_rec.rndg_cd,
312 p_rec.rndg_rl,
313 p_rec.rt_hrly_slrd_flag,
314 p_rec.rt_pstl_cd_flag,
315 p_rec.rt_lbr_mmbr_flag,
316 p_rec.rt_lgl_enty_flag,
317 p_rec.rt_benfts_grp_flag,
318 p_rec.rt_wk_loc_flag,
319 p_rec.rt_brgng_unit_flag,
320 p_rec.rt_age_flag,
321 p_rec.rt_los_flag,
322 p_rec.rt_per_typ_flag,
323 p_rec.rt_fl_tm_pt_tm_flag,
324 p_rec.rt_ee_stat_flag,
325 p_rec.rt_grd_flag,
326 p_rec.rt_pct_fl_tm_flag,
327 p_rec.rt_asnt_set_flag,
328 p_rec.rt_hrs_wkd_flag,
329 p_rec.rt_comp_lvl_flag,
330 p_rec.rt_org_unit_flag,
331 p_rec.rt_loa_rsn_flag,
332 p_rec.rt_pyrl_flag,
333 p_rec.rt_schedd_hrs_flag,
334 p_rec.rt_py_bss_flag,
335 p_rec.rt_prfl_rl_flag,
336 p_rec.rt_cmbn_age_los_flag,
337 p_rec.rt_prtt_pl_flag,
338 p_rec.rt_svc_area_flag,
339 p_rec.rt_ppl_grp_flag,
340 p_rec.rt_dsbld_flag,
341 p_rec.rt_hlth_cvg_flag,
342 p_rec.rt_poe_flag,
343 p_rec.rt_ttl_cvg_vol_flag,
344 p_rec.rt_ttl_prtt_flag,
345 p_rec.rt_gndr_flag,
346 p_rec.rt_tbco_use_flag,
347 p_rec.vpf_attribute_category,
348 p_rec.vpf_attribute1,
349 p_rec.vpf_attribute2,
350 p_rec.vpf_attribute3,
351 p_rec.vpf_attribute4,
352 p_rec.vpf_attribute5,
353 p_rec.vpf_attribute6,
354 p_rec.vpf_attribute7,
355 p_rec.vpf_attribute8,
356 p_rec.vpf_attribute9,
357 p_rec.vpf_attribute10,
358 p_rec.vpf_attribute11,
359 p_rec.vpf_attribute12,
360 p_rec.vpf_attribute13,
361 p_rec.vpf_attribute14,
362 p_rec.vpf_attribute15,
363 p_rec.vpf_attribute16,
364 p_rec.vpf_attribute17,
365 p_rec.vpf_attribute18,
366 p_rec.vpf_attribute19,
367 p_rec.vpf_attribute20,
368 p_rec.vpf_attribute21,
369 p_rec.vpf_attribute22,
370 p_rec.vpf_attribute23,
371 p_rec.vpf_attribute24,
372 p_rec.vpf_attribute25,
373 p_rec.vpf_attribute26,
374 p_rec.vpf_attribute27,
375 p_rec.vpf_attribute28,
376 p_rec.vpf_attribute29,
377 p_rec.vpf_attribute30,
378 p_rec.object_version_number,
379 l_created_by,
380 l_creation_date,
381 l_last_update_date,
382 l_last_updated_by,
383 l_last_update_login,
384 p_rec.rt_cntng_prtn_prfl_flag,
385 p_rec.rt_cbr_quald_bnf_flag,
386 p_rec.rt_optd_mdcr_flag ,
387 p_rec.rt_lvg_rsn_flag ,
388 p_rec.rt_pstn_flag ,
389 p_rec.rt_comptncy_flag ,
390 p_rec.rt_job_flag ,
391 p_rec.rt_qual_titl_flag ,
392 p_rec.rt_dpnt_cvrd_pl_flag ,
393 p_rec.rt_dpnt_cvrd_plip_flag ,
394 p_rec.rt_dpnt_cvrd_ptip_flag ,
395 p_rec.rt_dpnt_cvrd_pgm_flag ,
396 p_rec.rt_enrld_oipl_flag ,
397 p_rec.rt_enrld_pl_flag ,
398 p_rec.rt_enrld_plip_flag ,
399 p_rec.rt_enrld_ptip_flag ,
400 p_rec.rt_enrld_pgm_flag ,
401 p_rec.rt_prtt_anthr_pl_flag ,
402 p_rec.rt_othr_ptip_flag ,
403 p_rec.rt_no_othr_cvg_flag ,
404 p_rec.rt_dpnt_othr_ptip_flag,
405 p_rec.rt_qua_in_gr_flag,
406 p_rec.rt_perf_rtng_flag,
407 p_rec.rt_elig_prfl_flag);
408 --
409 ben_vpf_shd.g_api_dml := false; -- Unset the api dml status
410 hr_utility.set_location(' Leaving:'||l_proc, 15);
411 --
412 Exception
413 When hr_api.check_integrity_violated Then
414 -- A check constraint has been violated
415 ben_vpf_shd.g_api_dml := false; -- Unset the api dml status
416 ben_vpf_shd.constraint_error
417 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
418 When hr_api.unique_integrity_violated Then
419 -- Unique integrity has been violated
420 ben_vpf_shd.g_api_dml := false; -- Unset the api dml status
421 ben_vpf_shd.constraint_error
422 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
423 When Others Then
424 ben_vpf_shd.g_api_dml := false; -- Unset the api dml status
425 Raise;
426 End dt_insert_dml;
427 --
428 -- ----------------------------------------------------------------------------
429 -- |------------------------------< insert_dml >------------------------------|
430 -- ----------------------------------------------------------------------------
431 Procedure insert_dml
432 (p_rec in out nocopy ben_vpf_shd.g_rec_type,
433 p_effective_date in date,
434 p_datetrack_mode in varchar2,
435 p_validation_start_date in date,
436 p_validation_end_date in date) is
437 --
438 l_proc varchar2(72) := g_package||'insert_dml';
439 --
440 Begin
441 hr_utility.set_location('Entering:'||l_proc, 5);
442 --
443 dt_insert_dml(p_rec => p_rec,
444 p_effective_date => p_effective_date,
445 p_datetrack_mode => p_datetrack_mode,
446 p_validation_start_date => p_validation_start_date,
447 p_validation_end_date => p_validation_end_date);
448 --
449 hr_utility.set_location(' Leaving:'||l_proc, 10);
450 End insert_dml;
451 --
452 -- ----------------------------------------------------------------------------
453 -- |------------------------------< pre_insert >------------------------------|
454 -- ----------------------------------------------------------------------------
455 -- {Start Of Comments}
456 --
457 -- Description:
458 -- This private procedure contains any processing which is required before
459 -- the insert dml. Presently, if the entity has a corresponding primary
460 -- key which is maintained by an associating sequence, the primary key for
461 -- the entity will be populated with the next sequence value in
462 -- preparation for the insert dml.
463 -- Also, if comments are defined for this entity, the comments insert
464 -- logic will also be called, generating a comment_id if required.
465 --
466 -- Prerequisites:
467 -- This is an internal procedure which is called from the ins procedure.
468 --
469 -- In Parameters:
470 -- A Pl/Sql record structre.
471 --
472 -- Post Success:
473 -- Processing continues.
474 --
475 -- Post Failure:
476 -- If an error has occurred, an error message and exception will be raised
477 -- but not handled.
478 --
479 -- Developer Implementation Notes:
480 -- Any pre-processing required before the insert dml is issued should be
481 -- coded within this procedure. As stated above, a good example is the
482 -- generation of a primary key number via a corresponding sequence.
483 -- It is important to note that any 3rd party maintenance should be reviewed
484 -- before placing in this procedure.
485 --
486 -- Access Status:
487 -- Internal Row Handler Use Only.
488 --
489 -- {End Of Comments}
490 -- ----------------------------------------------------------------------------
491 Procedure pre_insert
492 (p_rec in out nocopy ben_vpf_shd.g_rec_type,
493 p_effective_date in date,
494 p_datetrack_mode in varchar2,
495 p_validation_start_date in date,
496 p_validation_end_date in date) is
497 --
498 l_proc varchar2(72) := g_package||'pre_insert';
499 --
500 --
501 --
502 Begin
503 hr_utility.set_location('Entering:'||l_proc, 5);
504 --
505 select ben_vrbl_rt_prfl_f_s.nextval into p_rec.vrbl_rt_prfl_id from dual;
506 --
507 --
508 --
509 hr_utility.set_location(' Leaving:'||l_proc, 10);
510 End pre_insert;
511 --
512 -- ----------------------------------------------------------------------------
513 -- |-----------------------------< post_insert >------------------------------|
514 -- ----------------------------------------------------------------------------
515 -- {Start Of Comments}
516 --
517 -- Description:
518 -- This private procedure contains any processing which is required after the
519 -- insert dml.
520 --
521 -- Prerequisites:
522 -- This is an internal procedure which is called from the ins procedure.
523 --
524 -- In Parameters:
525 -- A Pl/Sql record structre.
526 --
527 -- Post Success:
528 -- Processing continues.
529 --
530 -- Post Failure:
531 -- If an error has occurred, an error message and exception will be raised
532 -- but not handled.
533 --
534 -- Developer Implementation Notes:
535 -- Any post-processing required after the insert dml is issued should be
536 -- coded within this procedure. It is important to note that any 3rd party
537 -- maintenance should be reviewed before placing in this procedure.
538 --
539 -- Access Status:
540 -- Internal Row Handler Use Only.
541 --
542 -- {End Of Comments}
543 -- ----------------------------------------------------------------------------
544 Procedure post_insert
545 (p_rec in ben_vpf_shd.g_rec_type,
546 p_effective_date in date,
547 p_datetrack_mode in varchar2,
548 p_validation_start_date in date,
549 p_validation_end_date in date) is
550 --
551 l_proc varchar2(72) := g_package||'post_insert';
552 --
553 Begin
554 hr_utility.set_location('Entering:'||l_proc, 5);
555 --
556 -- Start of API User Hook for post_insert.
557 --
558 begin
559 --
560 ben_vpf_rki.after_insert
561 (p_vrbl_rt_prfl_id =>p_rec.vrbl_rt_prfl_id
562 ,p_effective_start_date =>p_rec.effective_start_date
563 ,p_effective_end_date =>p_rec.effective_end_date
564 ,p_pl_typ_opt_typ_id =>p_rec.pl_typ_opt_typ_id
565 ,p_pl_id =>p_rec.pl_id
566 ,p_oipl_id =>p_rec.oipl_id
567 ,p_comp_lvl_fctr_id =>p_rec.comp_lvl_fctr_id
568 ,p_business_group_id =>p_rec.business_group_id
569 ,p_acty_typ_cd =>p_rec.acty_typ_cd
570 ,p_rt_typ_cd =>p_rec.rt_typ_cd
571 ,p_bnft_rt_typ_cd =>p_rec.bnft_rt_typ_cd
572 ,p_tx_typ_cd =>p_rec.tx_typ_cd
573 ,p_vrbl_rt_trtmt_cd =>p_rec.vrbl_rt_trtmt_cd
574 ,p_acty_ref_perd_cd =>p_rec.acty_ref_perd_cd
575 ,p_mlt_cd =>p_rec.mlt_cd
576 ,p_incrmnt_elcn_val =>p_rec.incrmnt_elcn_val
577 ,p_dflt_elcn_val =>p_rec.dflt_elcn_val
578 ,p_mx_elcn_val =>p_rec.mx_elcn_val
579 ,p_mn_elcn_val =>p_rec.mn_elcn_val
580 ,p_lwr_lmt_val =>p_rec.lwr_lmt_val
581 ,p_lwr_lmt_calc_rl =>p_rec.lwr_lmt_calc_rl
582 ,p_upr_lmt_val =>p_rec.upr_lmt_val
583 ,p_upr_lmt_calc_rl =>p_rec.upr_lmt_calc_rl
584 ,p_ultmt_upr_lmt =>p_rec.ultmt_upr_lmt
585 ,p_ultmt_lwr_lmt =>p_rec.ultmt_lwr_lmt
586 ,p_ultmt_upr_lmt_calc_rl =>p_rec.ultmt_upr_lmt_calc_rl
587 ,p_ultmt_lwr_lmt_calc_rl =>p_rec.ultmt_lwr_lmt_calc_rl
588 ,p_ann_mn_elcn_val =>p_rec.ann_mn_elcn_val
589 ,p_ann_mx_elcn_val =>p_rec.ann_mx_elcn_val
590 ,p_val =>p_rec.val
591 ,p_name =>p_rec.name
592 ,p_no_mn_elcn_val_dfnd_flag =>p_rec.no_mn_elcn_val_dfnd_flag
593 ,p_no_mx_elcn_val_dfnd_flag =>p_rec.no_mx_elcn_val_dfnd_flag
594 ,p_alwys_sum_all_cvg_flag =>p_rec.alwys_sum_all_cvg_flag
595 ,p_alwys_cnt_all_prtts_flag =>p_rec.alwys_cnt_all_prtts_flag
596 ,p_val_calc_rl =>p_rec.val_calc_rl
597 ,p_vrbl_rt_prfl_stat_cd =>p_rec.vrbl_rt_prfl_stat_cd
598 ,p_vrbl_usg_cd =>p_rec.vrbl_usg_cd
599 ,p_asmt_to_use_cd =>p_rec.asmt_to_use_cd
600 ,p_rndg_cd =>p_rec.rndg_cd
601 ,p_rndg_rl =>p_rec.rndg_rl
602 ,p_rt_hrly_slrd_flag =>p_rec.rt_hrly_slrd_flag
603 ,p_rt_pstl_cd_flag =>p_rec.rt_pstl_cd_flag
604 ,p_rt_lbr_mmbr_flag =>p_rec.rt_lbr_mmbr_flag
605 ,p_rt_lgl_enty_flag =>p_rec.rt_lgl_enty_flag
606 ,p_rt_benfts_grp_flag =>p_rec.rt_benfts_grp_flag
607 ,p_rt_wk_loc_flag =>p_rec.rt_wk_loc_flag
608 ,p_rt_brgng_unit_flag =>p_rec.rt_brgng_unit_flag
609 ,p_rt_age_flag =>p_rec.rt_age_flag
610 ,p_rt_los_flag =>p_rec.rt_los_flag
611 ,p_rt_per_typ_flag =>p_rec.rt_per_typ_flag
612 ,p_rt_fl_tm_pt_tm_flag =>p_rec.rt_fl_tm_pt_tm_flag
613 ,p_rt_ee_stat_flag =>p_rec.rt_ee_stat_flag
614 ,p_rt_grd_flag =>p_rec.rt_grd_flag
615 ,p_rt_pct_fl_tm_flag =>p_rec.rt_pct_fl_tm_flag
616 ,p_rt_asnt_set_flag =>p_rec.rt_asnt_set_flag
617 ,p_rt_hrs_wkd_flag =>p_rec.rt_hrs_wkd_flag
618 ,p_rt_comp_lvl_flag =>p_rec.rt_comp_lvl_flag
619 ,p_rt_org_unit_flag =>p_rec.rt_org_unit_flag
620 ,p_rt_loa_rsn_flag =>p_rec.rt_loa_rsn_flag
621 ,p_rt_pyrl_flag =>p_rec.rt_pyrl_flag
622 ,p_rt_schedd_hrs_flag =>p_rec.rt_schedd_hrs_flag
623 ,p_rt_py_bss_flag =>p_rec.rt_py_bss_flag
624 ,p_rt_prfl_rl_flag =>p_rec.rt_prfl_rl_flag
625 ,p_rt_cmbn_age_los_flag =>p_rec.rt_cmbn_age_los_flag
626 ,p_rt_prtt_pl_flag =>p_rec.rt_prtt_pl_flag
627 ,p_rt_svc_area_flag =>p_rec.rt_svc_area_flag
628 ,p_rt_ppl_grp_flag =>p_rec.rt_ppl_grp_flag
629 ,p_rt_dsbld_flag =>p_rec.rt_dsbld_flag
630 ,p_rt_hlth_cvg_flag =>p_rec.rt_hlth_cvg_flag
631 ,p_rt_poe_flag =>p_rec.rt_poe_flag
632 ,p_rt_ttl_cvg_vol_flag =>p_rec.rt_ttl_cvg_vol_flag
633 ,p_rt_ttl_prtt_flag =>p_rec.rt_ttl_prtt_flag
634 ,p_rt_gndr_flag =>p_rec.rt_gndr_flag
635 ,p_rt_tbco_use_flag =>p_rec.rt_tbco_use_flag
636 ,p_vpf_attribute_category =>p_rec.vpf_attribute_category
637 ,p_vpf_attribute1 =>p_rec.vpf_attribute1
638 ,p_vpf_attribute2 =>p_rec.vpf_attribute2
639 ,p_vpf_attribute3 =>p_rec.vpf_attribute3
640 ,p_vpf_attribute4 =>p_rec.vpf_attribute4
641 ,p_vpf_attribute5 =>p_rec.vpf_attribute5
642 ,p_vpf_attribute6 =>p_rec.vpf_attribute6
643 ,p_vpf_attribute7 =>p_rec.vpf_attribute7
644 ,p_vpf_attribute8 =>p_rec.vpf_attribute8
645 ,p_vpf_attribute9 =>p_rec.vpf_attribute9
646 ,p_vpf_attribute10 =>p_rec.vpf_attribute10
647 ,p_vpf_attribute11 =>p_rec.vpf_attribute11
648 ,p_vpf_attribute12 =>p_rec.vpf_attribute12
649 ,p_vpf_attribute13 =>p_rec.vpf_attribute13
650 ,p_vpf_attribute14 =>p_rec.vpf_attribute14
651 ,p_vpf_attribute15 =>p_rec.vpf_attribute15
652 ,p_vpf_attribute16 =>p_rec.vpf_attribute16
653 ,p_vpf_attribute17 =>p_rec.vpf_attribute17
654 ,p_vpf_attribute18 =>p_rec.vpf_attribute18
655 ,p_vpf_attribute19 =>p_rec.vpf_attribute19
656 ,p_vpf_attribute20 =>p_rec.vpf_attribute20
657 ,p_vpf_attribute21 =>p_rec.vpf_attribute21
658 ,p_vpf_attribute22 =>p_rec.vpf_attribute22
659 ,p_vpf_attribute23 =>p_rec.vpf_attribute23
660 ,p_vpf_attribute24 =>p_rec.vpf_attribute24
661 ,p_vpf_attribute25 =>p_rec.vpf_attribute25
662 ,p_vpf_attribute26 =>p_rec.vpf_attribute26
663 ,p_vpf_attribute27 =>p_rec.vpf_attribute27
664 ,p_vpf_attribute28 =>p_rec.vpf_attribute28
665 ,p_vpf_attribute29 =>p_rec.vpf_attribute29
666 ,p_vpf_attribute30 =>p_rec.vpf_attribute30
667 ,p_object_version_number =>p_rec.object_version_number
668 ,p_effective_date =>p_effective_date
669 ,p_validation_start_date =>p_validation_start_date
670 ,p_validation_end_date =>p_validation_end_date
671 ,p_rt_cntng_prtn_prfl_flag =>p_rec.rt_cntng_prtn_prfl_flag
672 ,p_rt_cbr_quald_bnf_flag =>p_rec.rt_cbr_quald_bnf_flag
673 ,p_rt_optd_mdcr_flag =>p_rec.rt_optd_mdcr_flag
674 ,p_rt_lvg_rsn_flag =>p_rec.rt_lvg_rsn_flag
675 ,p_rt_pstn_flag =>p_rec.rt_pstn_flag
676 ,p_rt_comptncy_flag =>p_rec.rt_comptncy_flag
677 ,p_rt_job_flag =>p_rec.rt_job_flag
678 ,p_rt_qual_titl_flag =>p_rec.rt_qual_titl_flag
679 ,p_rt_dpnt_cvrd_pl_flag =>p_rec.rt_dpnt_cvrd_pl_flag
680 ,p_rt_dpnt_cvrd_plip_flag =>p_rec.rt_dpnt_cvrd_plip_flag
681 ,p_rt_dpnt_cvrd_ptip_flag =>p_rec.rt_dpnt_cvrd_ptip_flag
682 ,p_rt_dpnt_cvrd_pgm_flag =>p_rec.rt_dpnt_cvrd_pgm_flag
683 ,p_rt_enrld_oipl_flag =>p_rec.rt_enrld_oipl_flag
684 ,p_rt_enrld_pl_flag =>p_rec.rt_enrld_pl_flag
685 ,p_rt_enrld_plip_flag =>p_rec.rt_enrld_plip_flag
686 ,p_rt_enrld_ptip_flag =>p_rec.rt_enrld_ptip_flag
687 ,p_rt_enrld_pgm_flag =>p_rec.rt_enrld_pgm_flag
688 ,p_rt_prtt_anthr_pl_flag =>p_rec.rt_prtt_anthr_pl_flag
689 ,p_rt_othr_ptip_flag =>p_rec.rt_othr_ptip_flag
690 ,p_rt_no_othr_cvg_flag =>p_rec.rt_no_othr_cvg_flag
691 ,p_rt_dpnt_othr_ptip_flag =>p_rec.rt_dpnt_othr_ptip_flag
692 ,p_rt_qua_in_gr_flag =>p_rec.rt_qua_in_gr_flag
693 ,p_rt_perf_rtng_flag =>p_rec.rt_perf_rtng_flag
694 ,p_rt_elig_prfl_flag =>p_rec.rt_elig_prfl_flag
695 );
696 --
697 exception
698 --
699 when hr_api.cannot_find_prog_unit then
700 --
701 hr_api.cannot_find_prog_unit_error
702 (p_module_name => 'ben_vrbl_rt_prfl_f'
703 ,p_hook_type => 'AI');
704 --
705 end;
706 --
707 -- End of API User Hook for post_insert.
708 --
709 hr_utility.set_location(' Leaving:'||l_proc, 10);
710 --
711 End post_insert;
712 --
713 -- ----------------------------------------------------------------------------
714 -- |-------------------------------< ins_lck >--------------------------------|
715 -- ----------------------------------------------------------------------------
716 -- {Start Of Comments}
717 --
718 -- Description:
719 -- The ins_lck process has one main function to perform. When inserting
720 -- a datetracked row, we must validate the DT mode.
721 -- be manipulated.
722 --
723 -- Prerequisites:
724 -- This procedure can only be called for the datetrack mode of INSERT.
725 --
726 -- In Parameters:
727 --
728 -- Post Success:
729 -- On successful completion of the ins_lck process the parental
730 -- datetracked rows will be locked providing the p_enforce_foreign_locking
731 -- argument value is TRUE.
732 -- If the p_enforce_foreign_locking argument value is FALSE then the
733 -- parential rows are not locked.
734 --
735 -- Post Failure:
736 -- The Lck process can fail for:
737 -- 1) When attempting to lock the row the row could already be locked by
738 -- another user. This will raise the HR_Api.Object_Locked exception.
739 -- 2) When attempting to the lock the parent which doesn't exist.
740 -- For the entity to be locked the parent must exist!
741 --
742 -- Developer Implementation Notes:
743 -- None.
744 --
745 -- Access Status:
746 -- Internal Row Handler Use Only.
747 --
748 -- {End Of Comments}
749 -- ----------------------------------------------------------------------------
750 Procedure ins_lck
751 (p_effective_date in date,
752 p_datetrack_mode in varchar2,
753 p_rec in ben_vpf_shd.g_rec_type,
754 p_validation_start_date out nocopy date,
755 p_validation_end_date out nocopy date) is
756 --
757 l_proc varchar2(72) := g_package||'ins_lck';
758 l_validation_start_date date;
759 l_validation_end_date date;
760 --
761 Begin
762 hr_utility.set_location('Entering:'||l_proc, 5);
763 --
764 -- Validate the datetrack mode mode getting the validation start
765 -- and end dates for the specified datetrack operation.
766 --
767 dt_api.validate_dt_mode
768 (p_effective_date => p_effective_date,
769 p_datetrack_mode => p_datetrack_mode,
770 p_base_table_name => 'ben_vrbl_rt_prfl_f',
771 p_base_key_column => 'vrbl_rt_prfl_id',
772 p_base_key_value => p_rec.vrbl_rt_prfl_id,
773 p_parent_table_name1 => 'ben_oipl_f',
774 p_parent_key_column1 => 'oipl_id',
775 p_parent_key_value1 => p_rec.oipl_id,
776 p_parent_table_name2 => 'ben_pl_f',
777 p_parent_key_column2 => 'pl_id',
778 p_parent_key_value2 => p_rec.pl_id,
779 p_enforce_foreign_locking => true,
780 p_validation_start_date => l_validation_start_date,
781 p_validation_end_date => l_validation_end_date);
782 --
783 -- Set the validation start and end date OUT arguments
784 --
785 p_validation_start_date := l_validation_start_date;
786 p_validation_end_date := l_validation_end_date;
787 --
788 hr_utility.set_location(' Leaving:'||l_proc, 10);
789 --
790 End ins_lck;
791 --
792 -- ----------------------------------------------------------------------------
793 -- |---------------------------------< ins >----------------------------------|
794 -- ----------------------------------------------------------------------------
795 Procedure ins
796 (
797 p_rec in out nocopy ben_vpf_shd.g_rec_type,
798 p_effective_date in date
799 ) is
800 --
801 l_proc varchar2(72) := g_package||'ins';
802 l_datetrack_mode varchar2(30) := 'INSERT';
803 l_validation_start_date date;
804 l_validation_end_date date;
805 --
806 Begin
807 hr_utility.set_location('Entering:'||l_proc, 5);
808 --
809 -- Call the lock operation
810 --
811 ins_lck
812 (p_effective_date => p_effective_date,
813 p_datetrack_mode => l_datetrack_mode,
814 p_rec => p_rec,
815 p_validation_start_date => l_validation_start_date,
816 p_validation_end_date => l_validation_end_date);
817 --
818 -- Call the supporting insert validate operations
819 --
820 ben_vpf_bus.insert_validate
821 (p_rec => p_rec,
822 p_effective_date => p_effective_date,
823 p_datetrack_mode => l_datetrack_mode,
824 p_validation_start_date => l_validation_start_date,
825 p_validation_end_date => l_validation_end_date);
826 --
827 -- Call the supporting pre-insert operation
828 --
829 pre_insert
830 (p_rec => p_rec,
831 p_effective_date => p_effective_date,
832 p_datetrack_mode => l_datetrack_mode,
833 p_validation_start_date => l_validation_start_date,
834 p_validation_end_date => l_validation_end_date);
835 --
836 -- Insert the row
837 --
838 insert_dml
839 (p_rec => p_rec,
840 p_effective_date => p_effective_date,
841 p_datetrack_mode => l_datetrack_mode,
842 p_validation_start_date => l_validation_start_date,
843 p_validation_end_date => l_validation_end_date);
844 --
845 -- Call the supporting post-insert operation
846 --
847 post_insert
848 (p_rec => p_rec,
849 p_effective_date => p_effective_date,
850 p_datetrack_mode => l_datetrack_mode,
851 p_validation_start_date => l_validation_start_date,
852 p_validation_end_date => l_validation_end_date);
853 end ins;
854 --
855 -- ----------------------------------------------------------------------------
856 -- |---------------------------------< ins >----------------------------------|
857 -- ----------------------------------------------------------------------------
858 Procedure ins
859 (
860 p_vrbl_rt_prfl_id out nocopy number,
861 p_effective_start_date out nocopy date,
862 p_effective_end_date out nocopy date,
863 p_pl_typ_opt_typ_id in number default null,
864 p_pl_id in number default null,
865 p_oipl_id in number default null,
866 p_comp_lvl_fctr_id in number default null,
867 p_business_group_id in number,
868 p_acty_typ_cd in varchar2,
869 p_rt_typ_cd in varchar2 default null,
870 p_bnft_rt_typ_cd in varchar2 default null,
871 p_tx_typ_cd in varchar2,
872 p_vrbl_rt_trtmt_cd in varchar2,
873 p_acty_ref_perd_cd in varchar2,
874 p_mlt_cd in varchar2,
875 p_incrmnt_elcn_val in number default null,
876 p_dflt_elcn_val in number default null,
877 p_mx_elcn_val in number default null,
878 p_mn_elcn_val in number default null,
879 p_lwr_lmt_val in number default null,
880 p_lwr_lmt_calc_rl in number default null,
881 p_upr_lmt_val in number default null,
882 p_upr_lmt_calc_rl in number default null,
883 p_ultmt_upr_lmt in number default null,
884 p_ultmt_lwr_lmt in number default null,
885 p_ultmt_upr_lmt_calc_rl in number default null,
886 p_ultmt_lwr_lmt_calc_rl in number default null,
887 p_ann_mn_elcn_val in number default null,
888 p_ann_mx_elcn_val in number default null,
889 p_val in number default null,
890 p_name in varchar2,
891 p_no_mn_elcn_val_dfnd_flag in varchar2,
892 p_no_mx_elcn_val_dfnd_flag in varchar2,
893 p_alwys_sum_all_cvg_flag in varchar2,
894 p_alwys_cnt_all_prtts_flag in varchar2,
895 p_val_calc_rl in number default null,
896 p_vrbl_rt_prfl_stat_cd in varchar2 default null,
897 p_vrbl_usg_cd in varchar2 default null,
898 p_asmt_to_use_cd in varchar2 default null,
899 p_rndg_cd in varchar2 default null,
900 p_rndg_rl in number default null,
901 p_rt_hrly_slrd_flag in varchar2 default null,
902 p_rt_pstl_cd_flag in varchar2 default null,
903 p_rt_lbr_mmbr_flag in varchar2 default null,
904 p_rt_lgl_enty_flag in varchar2 default null,
905 p_rt_benfts_grp_flag in varchar2 default null,
906 p_rt_wk_loc_flag in varchar2 default null,
907 p_rt_brgng_unit_flag in varchar2 default null,
908 p_rt_age_flag in varchar2 default null,
909 p_rt_los_flag in varchar2 default null,
910 p_rt_per_typ_flag in varchar2 default null,
911 p_rt_fl_tm_pt_tm_flag in varchar2 default null,
912 p_rt_ee_stat_flag in varchar2 default null,
913 p_rt_grd_flag in varchar2 default null,
914 p_rt_pct_fl_tm_flag in varchar2 default null,
915 p_rt_asnt_set_flag in varchar2 default null,
916 p_rt_hrs_wkd_flag in varchar2 default null,
917 p_rt_comp_lvl_flag in varchar2 default null,
918 p_rt_org_unit_flag in varchar2 default null,
919 p_rt_loa_rsn_flag in varchar2 default null,
920 p_rt_pyrl_flag in varchar2 default null,
921 p_rt_schedd_hrs_flag in varchar2 default null,
922 p_rt_py_bss_flag in varchar2 default null,
923 p_rt_prfl_rl_flag in varchar2 default null,
924 p_rt_cmbn_age_los_flag in varchar2 default null,
925 p_rt_prtt_pl_flag in varchar2 default null,
926 p_rt_svc_area_flag in varchar2 default null,
927 p_rt_ppl_grp_flag in varchar2 default null,
928 p_rt_dsbld_flag in varchar2 default null,
929 p_rt_hlth_cvg_flag in varchar2 default null,
930 p_rt_poe_flag in varchar2 default null,
931 p_rt_ttl_cvg_vol_flag in varchar2 default null,
932 p_rt_ttl_prtt_flag in varchar2 default null,
933 p_rt_gndr_flag in varchar2 default null,
934 p_rt_tbco_use_flag in varchar2 default null,
935 p_vpf_attribute_category in varchar2 default null,
936 p_vpf_attribute1 in varchar2 default null,
937 p_vpf_attribute2 in varchar2 default null,
938 p_vpf_attribute3 in varchar2 default null,
939 p_vpf_attribute4 in varchar2 default null,
940 p_vpf_attribute5 in varchar2 default null,
941 p_vpf_attribute6 in varchar2 default null,
942 p_vpf_attribute7 in varchar2 default null,
943 p_vpf_attribute8 in varchar2 default null,
944 p_vpf_attribute9 in varchar2 default null,
945 p_vpf_attribute10 in varchar2 default null,
946 p_vpf_attribute11 in varchar2 default null,
947 p_vpf_attribute12 in varchar2 default null,
948 p_vpf_attribute13 in varchar2 default null,
949 p_vpf_attribute14 in varchar2 default null,
950 p_vpf_attribute15 in varchar2 default null,
951 p_vpf_attribute16 in varchar2 default null,
952 p_vpf_attribute17 in varchar2 default null,
953 p_vpf_attribute18 in varchar2 default null,
954 p_vpf_attribute19 in varchar2 default null,
955 p_vpf_attribute20 in varchar2 default null,
956 p_vpf_attribute21 in varchar2 default null,
957 p_vpf_attribute22 in varchar2 default null,
958 p_vpf_attribute23 in varchar2 default null,
959 p_vpf_attribute24 in varchar2 default null,
960 p_vpf_attribute25 in varchar2 default null,
961 p_vpf_attribute26 in varchar2 default null,
962 p_vpf_attribute27 in varchar2 default null,
963 p_vpf_attribute28 in varchar2 default null,
964 p_vpf_attribute29 in varchar2 default null,
965 p_vpf_attribute30 in varchar2 default null,
966 p_object_version_number out nocopy number,
967 p_effective_date in date ,
968 p_rt_cntng_prtn_prfl_flag in varchar2 default null,
969 p_rt_cbr_quald_bnf_flag in varchar2 default null,
970 p_rt_optd_mdcr_flag in varchar2 default null,
971 p_rt_lvg_rsn_flag in varchar2 default null,
972 p_rt_pstn_flag in varchar2 default null,
973 p_rt_comptncy_flag in varchar2 default null,
974 p_rt_job_flag in varchar2 default null,
975 p_rt_qual_titl_flag in varchar2 default null,
976 p_rt_dpnt_cvrd_pl_flag in varchar2 default null,
977 p_rt_dpnt_cvrd_plip_flag in varchar2 default null,
978 p_rt_dpnt_cvrd_ptip_flag in varchar2 default null,
979 p_rt_dpnt_cvrd_pgm_flag in varchar2 default null,
980 p_rt_enrld_oipl_flag in varchar2 default null,
981 p_rt_enrld_pl_flag in varchar2 default null,
982 p_rt_enrld_plip_flag in varchar2 default null,
983 p_rt_enrld_ptip_flag in varchar2 default null,
984 p_rt_enrld_pgm_flag in varchar2 default null,
985 p_rt_prtt_anthr_pl_flag in varchar2 default null,
986 p_rt_othr_ptip_flag in varchar2 default null,
987 p_rt_no_othr_cvg_flag in varchar2 default null,
988 p_rt_dpnt_othr_ptip_flag in varchar2 default null,
989 p_rt_qua_in_gr_flag in varchar2 default null,
990 p_rt_perf_rtng_flag in varchar2 default null,
991 p_rt_elig_prfl_flag in varchar2 default null
992 ) is
993
994 --
995 l_rec ben_vpf_shd.g_rec_type;
996 l_proc varchar2(72) := g_package||'ins';
997 --
998 Begin
999 hr_utility.set_location('Entering:'||l_proc, 5);
1000 --
1001 -- Call conversion function to turn arguments into the
1002 -- p_rec structure.
1003 --
1004 l_rec :=
1005 ben_vpf_shd.convert_args
1006 (
1007 null,
1008 null,
1009 null,
1010 p_pl_typ_opt_typ_id,
1011 p_pl_id,
1012 p_oipl_id,
1013 p_comp_lvl_fctr_id,
1014 p_business_group_id,
1015 p_acty_typ_cd,
1016 p_rt_typ_cd,
1017 p_bnft_rt_typ_cd,
1018 p_tx_typ_cd,
1019 p_vrbl_rt_trtmt_cd,
1020 p_acty_ref_perd_cd,
1021 p_mlt_cd,
1022 p_incrmnt_elcn_val,
1023 p_dflt_elcn_val,
1024 p_mx_elcn_val,
1025 p_mn_elcn_val,
1026 p_lwr_lmt_val,
1027 p_lwr_lmt_calc_rl,
1028 p_upr_lmt_val,
1029 p_upr_lmt_calc_rl,
1030 p_ultmt_upr_lmt,
1031 p_ultmt_lwr_lmt,
1032 p_ultmt_upr_lmt_calc_rl,
1033 p_ultmt_lwr_lmt_calc_rl,
1034 p_ann_mn_elcn_val,
1035 p_ann_mx_elcn_val,
1036 p_val,
1037 p_name,
1038 p_no_mn_elcn_val_dfnd_flag,
1039 p_no_mx_elcn_val_dfnd_flag,
1040 p_alwys_sum_all_cvg_flag,
1041 p_alwys_cnt_all_prtts_flag,
1042 p_val_calc_rl,
1043 p_vrbl_rt_prfl_stat_cd,
1044 p_vrbl_usg_cd,
1045 p_asmt_to_use_cd,
1046 p_rndg_cd,
1047 p_rndg_rl,
1048 p_rt_hrly_slrd_flag,
1049 p_rt_pstl_cd_flag,
1050 p_rt_lbr_mmbr_flag,
1051 p_rt_lgl_enty_flag,
1052 p_rt_benfts_grp_flag,
1053 p_rt_wk_loc_flag,
1054 p_rt_brgng_unit_flag,
1055 p_rt_age_flag,
1056 p_rt_los_flag,
1057 p_rt_per_typ_flag,
1058 p_rt_fl_tm_pt_tm_flag,
1059 p_rt_ee_stat_flag,
1060 p_rt_grd_flag,
1061 p_rt_pct_fl_tm_flag,
1062 p_rt_asnt_set_flag,
1063 p_rt_hrs_wkd_flag,
1064 p_rt_comp_lvl_flag,
1065 p_rt_org_unit_flag,
1066 p_rt_loa_rsn_flag,
1067 p_rt_pyrl_flag,
1068 p_rt_schedd_hrs_flag,
1069 p_rt_py_bss_flag,
1070 p_rt_prfl_rl_flag,
1071 p_rt_cmbn_age_los_flag,
1072 p_rt_prtt_pl_flag,
1073 p_rt_svc_area_flag,
1074 p_rt_ppl_grp_flag,
1075 p_rt_dsbld_flag,
1076 p_rt_hlth_cvg_flag,
1077 p_rt_poe_flag,
1078 p_rt_ttl_cvg_vol_flag,
1079 p_rt_ttl_prtt_flag,
1080 p_rt_gndr_flag,
1081 p_rt_tbco_use_flag,
1082 p_vpf_attribute_category,
1083 p_vpf_attribute1,
1084 p_vpf_attribute2,
1085 p_vpf_attribute3,
1086 p_vpf_attribute4,
1087 p_vpf_attribute5,
1088 p_vpf_attribute6,
1089 p_vpf_attribute7,
1090 p_vpf_attribute8,
1091 p_vpf_attribute9,
1092 p_vpf_attribute10,
1093 p_vpf_attribute11,
1094 p_vpf_attribute12,
1095 p_vpf_attribute13,
1096 p_vpf_attribute14,
1097 p_vpf_attribute15,
1098 p_vpf_attribute16,
1099 p_vpf_attribute17,
1100 p_vpf_attribute18,
1101 p_vpf_attribute19,
1102 p_vpf_attribute20,
1103 p_vpf_attribute21,
1104 p_vpf_attribute22,
1105 p_vpf_attribute23,
1106 p_vpf_attribute24,
1107 p_vpf_attribute25,
1108 p_vpf_attribute26,
1109 p_vpf_attribute27,
1110 p_vpf_attribute28,
1111 p_vpf_attribute29,
1112 p_vpf_attribute30,
1113 null ,
1114 p_rt_cntng_prtn_prfl_flag,
1115 p_rt_cbr_quald_bnf_flag,
1116 p_rt_optd_mdcr_flag,
1117 p_rt_lvg_rsn_flag ,
1118 p_rt_pstn_flag ,
1119 p_rt_comptncy_flag ,
1120 p_rt_job_flag ,
1121 p_rt_qual_titl_flag ,
1122 p_rt_dpnt_cvrd_pl_flag ,
1123 p_rt_dpnt_cvrd_plip_flag ,
1124 p_rt_dpnt_cvrd_ptip_flag ,
1125 p_rt_dpnt_cvrd_pgm_flag ,
1126 p_rt_enrld_oipl_flag ,
1127 p_rt_enrld_pl_flag ,
1128 p_rt_enrld_plip_flag ,
1129 p_rt_enrld_ptip_flag ,
1130 p_rt_enrld_pgm_flag ,
1131 p_rt_prtt_anthr_pl_flag ,
1132 p_rt_othr_ptip_flag ,
1133 p_rt_no_othr_cvg_flag ,
1134 p_rt_dpnt_othr_ptip_flag ,
1135 p_rt_qua_in_gr_flag,
1136 p_rt_perf_rtng_flag,
1137 p_rt_elig_prfl_flag);
1138 --
1139 -- Having converted the arguments into the ben_vpf_rec
1140 -- plsql record structure we call the corresponding record
1141 -- business process.
1142 --
1143 ins(l_rec, p_effective_date);
1144 --
1145 -- Set the OUT arguments.
1146 --
1147 p_vrbl_rt_prfl_id := l_rec.vrbl_rt_prfl_id;
1148 p_effective_start_date := l_rec.effective_start_date;
1149 p_effective_end_date := l_rec.effective_end_date;
1150 p_object_version_number := l_rec.object_version_number;
1151 --
1152 --
1153 hr_utility.set_location(' Leaving:'||l_proc, 10);
1154 End ins;
1155 --
1156 end ben_vpf_ins;