[Home] [Help]
PACKAGE BODY: APPS.BEN_VPF_UPD
Source
1 Package Body ben_vpf_upd 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_upd.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------------< dt_update_dml >-----------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This procedure controls the execution of dml from the datetrack mode
17 -- of CORRECTION only. It is important to note that the object version
18 -- number is only increment by 1 because the datetrack correction is
19 -- soley for one datetracked row.
20 -- This procedure controls the actual dml update logic. The functions of this
21 -- procedure are as follows:
22 -- 1) Get the next object_version_number.
23 -- 2) To set and unset the g_api_dml status as required (as we are about to
24 -- perform dml).
25 -- 3) To update the specified row in the schema using the primary key in
26 -- the predicates.
27 -- 4) To trap any constraint violations that may have occurred.
28 -- 5) To raise any other errors.
29 --
30 -- Prerequisites:
31 -- This is an internal private procedure which must be called from the
32 -- update_dml procedure.
33 --
34 -- In Parameters:
35 -- A Pl/Sql record structre.
36 --
37 -- Post Success:
38 -- The specified row will be updated in the schema.
39 --
40 -- Post Failure:
41 -- On the update 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 -- The update 'set' arguments list should be modified if any of your
50 -- attributes are not updateable.
51 --
52 -- Access Status:
53 -- Internal Row Handler Use Only.
54 --
55 -- {End Of Comments}
56 -- ----------------------------------------------------------------------------
57 Procedure dt_update_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 l_proc varchar2(72) := g_package||'dt_update_dml';
65 --
66 Begin
67 hr_utility.set_location('Entering:'||l_proc, 5);
68 --
69 If (p_datetrack_mode = 'CORRECTION') then
70 hr_utility.set_location(l_proc, 10);
71 --
72 -- Because we are updating a row we must get the next object
73 -- version number.
74 --
75 p_rec.object_version_number :=
76 dt_api.get_object_version_number
77 (p_base_table_name => 'ben_vrbl_rt_prfl_f',
78 p_base_key_column => 'vrbl_rt_prfl_id',
79 p_base_key_value => p_rec.vrbl_rt_prfl_id);
80 --
81 ben_vpf_shd.g_api_dml := true; -- Set the api dml status
82 --
83 -- Update the ben_vrbl_rt_prfl_f Row
84 --
85 update ben_vrbl_rt_prfl_f
86 set
87 vrbl_rt_prfl_id = p_rec.vrbl_rt_prfl_id,
88 pl_typ_opt_typ_id = p_rec.pl_typ_opt_typ_id,
89 pl_id = p_rec.pl_id,
90 oipl_id = p_rec.oipl_id,
91 comp_lvl_fctr_id = p_rec.comp_lvl_fctr_id,
92 business_group_id = p_rec.business_group_id,
93 acty_typ_cd = p_rec.acty_typ_cd,
94 rt_typ_cd = p_rec.rt_typ_cd,
95 bnft_rt_typ_cd = p_rec.bnft_rt_typ_cd,
96 tx_typ_cd = p_rec.tx_typ_cd,
97 vrbl_rt_trtmt_cd = p_rec.vrbl_rt_trtmt_cd,
98 acty_ref_perd_cd = p_rec.acty_ref_perd_cd,
99 mlt_cd = p_rec.mlt_cd,
100 incrmnt_elcn_val = p_rec.incrmnt_elcn_val,
101 dflt_elcn_val = p_rec.dflt_elcn_val,
102 mx_elcn_val = p_rec.mx_elcn_val,
103 mn_elcn_val = p_rec.mn_elcn_val,
104 lwr_lmt_val = p_rec.lwr_lmt_val,
105 lwr_lmt_calc_rl = p_rec.lwr_lmt_calc_rl,
106 upr_lmt_val = p_rec.upr_lmt_val,
107 upr_lmt_calc_rl = p_rec.upr_lmt_calc_rl,
108 ultmt_upr_lmt = p_rec.ultmt_upr_lmt,
109 ultmt_lwr_lmt = p_rec.ultmt_lwr_lmt,
110 ultmt_upr_lmt_calc_rl = p_rec.ultmt_upr_lmt_calc_rl,
111 ultmt_lwr_lmt_calc_rl = p_rec.ultmt_lwr_lmt_calc_rl,
112 ann_mn_elcn_val = p_rec.ann_mn_elcn_val,
113 ann_mx_elcn_val = p_rec.ann_mx_elcn_val,
114 val = p_rec.val,
115 name = p_rec.name,
116 no_mn_elcn_val_dfnd_flag = p_rec.no_mn_elcn_val_dfnd_flag,
117 no_mx_elcn_val_dfnd_flag = p_rec.no_mx_elcn_val_dfnd_flag,
118 alwys_sum_all_cvg_flag = p_rec.alwys_sum_all_cvg_flag,
119 alwys_cnt_all_prtts_flag = p_rec.alwys_cnt_all_prtts_flag,
120 val_calc_rl = p_rec.val_calc_rl,
121 vrbl_rt_prfl_stat_cd = p_rec.vrbl_rt_prfl_stat_cd,
122 vrbl_usg_cd = p_rec.vrbl_usg_cd,
123 asmt_to_use_cd = p_rec.asmt_to_use_cd,
124 rndg_cd = p_rec.rndg_cd,
125 rndg_rl = p_rec.rndg_rl,
126 rt_hrly_slrd_flag = p_rec.rt_hrly_slrd_flag,
127 rt_pstl_cd_flag = p_rec.rt_pstl_cd_flag,
128 rt_lbr_mmbr_flag = p_rec.rt_lbr_mmbr_flag,
129 rt_lgl_enty_flag = p_rec.rt_lgl_enty_flag,
130 rt_benfts_grp_flag = p_rec.rt_benfts_grp_flag,
131 rt_wk_loc_flag = p_rec.rt_wk_loc_flag,
132 rt_brgng_unit_flag = p_rec.rt_brgng_unit_flag,
133 rt_age_flag = p_rec.rt_age_flag,
134 rt_los_flag = p_rec.rt_los_flag,
135 rt_per_typ_flag = p_rec.rt_per_typ_flag,
136 rt_fl_tm_pt_tm_flag = p_rec.rt_fl_tm_pt_tm_flag,
137 rt_ee_stat_flag = p_rec.rt_ee_stat_flag,
138 rt_grd_flag = p_rec.rt_grd_flag,
139 rt_pct_fl_tm_flag = p_rec.rt_pct_fl_tm_flag,
140 rt_asnt_set_flag = p_rec.rt_asnt_set_flag,
141 rt_hrs_wkd_flag = p_rec.rt_hrs_wkd_flag,
142 rt_comp_lvl_flag = p_rec.rt_comp_lvl_flag,
143 rt_org_unit_flag = p_rec.rt_org_unit_flag,
144 rt_loa_rsn_flag = p_rec.rt_loa_rsn_flag,
145 rt_pyrl_flag = p_rec.rt_pyrl_flag,
146 rt_schedd_hrs_flag = p_rec.rt_schedd_hrs_flag,
147 rt_py_bss_flag = p_rec.rt_py_bss_flag,
148 rt_prfl_rl_flag = p_rec.rt_prfl_rl_flag,
149 rt_cmbn_age_los_flag = p_rec.rt_cmbn_age_los_flag,
150 rt_prtt_pl_flag = p_rec.rt_prtt_pl_flag,
151 rt_svc_area_flag = p_rec.rt_svc_area_flag,
152 rt_ppl_grp_flag = p_rec.rt_ppl_grp_flag,
153 rt_dsbld_flag = p_rec.rt_dsbld_flag,
154 rt_hlth_cvg_flag = p_rec.rt_hlth_cvg_flag,
155 rt_poe_flag = p_rec.rt_poe_flag,
156 rt_ttl_cvg_vol_flag = p_rec.rt_ttl_cvg_vol_flag,
157 rt_ttl_prtt_flag = p_rec.rt_ttl_prtt_flag,
158 rt_gndr_flag = p_rec.rt_gndr_flag,
159 rt_tbco_use_flag = p_rec.rt_tbco_use_flag,
160 vpf_attribute_category = p_rec.vpf_attribute_category,
161 vpf_attribute1 = p_rec.vpf_attribute1,
162 vpf_attribute2 = p_rec.vpf_attribute2,
163 vpf_attribute3 = p_rec.vpf_attribute3,
164 vpf_attribute4 = p_rec.vpf_attribute4,
165 vpf_attribute5 = p_rec.vpf_attribute5,
166 vpf_attribute6 = p_rec.vpf_attribute6,
167 vpf_attribute7 = p_rec.vpf_attribute7,
168 vpf_attribute8 = p_rec.vpf_attribute8,
169 vpf_attribute9 = p_rec.vpf_attribute9,
170 vpf_attribute10 = p_rec.vpf_attribute10,
171 vpf_attribute11 = p_rec.vpf_attribute11,
172 vpf_attribute12 = p_rec.vpf_attribute12,
173 vpf_attribute13 = p_rec.vpf_attribute13,
174 vpf_attribute14 = p_rec.vpf_attribute14,
175 vpf_attribute15 = p_rec.vpf_attribute15,
176 vpf_attribute16 = p_rec.vpf_attribute16,
177 vpf_attribute17 = p_rec.vpf_attribute17,
178 vpf_attribute18 = p_rec.vpf_attribute18,
179 vpf_attribute19 = p_rec.vpf_attribute19,
180 vpf_attribute20 = p_rec.vpf_attribute20,
181 vpf_attribute21 = p_rec.vpf_attribute21,
182 vpf_attribute22 = p_rec.vpf_attribute22,
183 vpf_attribute23 = p_rec.vpf_attribute23,
184 vpf_attribute24 = p_rec.vpf_attribute24,
185 vpf_attribute25 = p_rec.vpf_attribute25,
186 vpf_attribute26 = p_rec.vpf_attribute26,
187 vpf_attribute27 = p_rec.vpf_attribute27,
188 vpf_attribute28 = p_rec.vpf_attribute28,
189 vpf_attribute29 = p_rec.vpf_attribute29,
190 vpf_attribute30 = p_rec.vpf_attribute30,
191 object_version_number = p_rec.object_version_number,
192 rt_cntng_prtn_prfl_flag = p_rec.rt_cntng_prtn_prfl_flag,
193 rt_cbr_quald_bnf_flag = p_rec.rt_cbr_quald_bnf_flag,
194 rt_optd_mdcr_flag = p_rec.rt_optd_mdcr_flag,
195 rt_lvg_rsn_flag = p_rec.rt_lvg_rsn_flag,
196 rt_pstn_flag = p_rec.rt_pstn_flag ,
197 rt_comptncy_flag = p_rec.rt_comptncy_flag ,
198 rt_job_flag = p_rec.rt_job_flag ,
199 rt_qual_titl_flag = p_rec.rt_qual_titl_flag,
200 rt_dpnt_cvrd_pl_flag = p_rec.rt_dpnt_cvrd_pl_flag ,
201 rt_dpnt_cvrd_plip_flag = p_rec.rt_dpnt_cvrd_plip_flag ,
202 rt_dpnt_cvrd_ptip_flag = p_rec.rt_dpnt_cvrd_ptip_flag ,
203 rt_dpnt_cvrd_pgm_flag = p_rec.rt_dpnt_cvrd_pgm_flag,
204 rt_enrld_oipl_flag = p_rec.rt_enrld_oipl_flag,
205 rt_enrld_pl_flag = p_rec.rt_enrld_pl_flag ,
206 rt_enrld_plip_flag = p_rec.rt_enrld_plip_flag,
207 rt_enrld_ptip_flag = p_rec.rt_enrld_ptip_flag,
208 rt_enrld_pgm_flag = p_rec.rt_enrld_pgm_flag ,
209 rt_prtt_anthr_pl_flag = p_rec.rt_prtt_anthr_pl_flag,
210 rt_othr_ptip_flag = p_rec.rt_othr_ptip_flag ,
211 rt_no_othr_cvg_flag = p_rec.rt_no_othr_cvg_flag,
212 rt_dpnt_othr_ptip_flag = p_rec.rt_dpnt_othr_ptip_flag,
213 rt_qua_in_gr_flag = p_rec.rt_qua_in_gr_flag ,
214 rt_perf_rtng_flag = p_rec.rt_perf_rtng_flag,
215 rt_elig_prfl_flag = p_rec.rt_elig_prfl_flag
216 where vrbl_rt_prfl_id = p_rec.vrbl_rt_prfl_id
217 and effective_start_date = p_validation_start_date
218 and effective_end_date = p_validation_end_date;
219 --
220 ben_vpf_shd.g_api_dml := false; -- Unset the api dml status
221 --
222 -- Set the effective start and end dates
223 --
224 p_rec.effective_start_date := p_validation_start_date;
225 p_rec.effective_end_date := p_validation_end_date;
226 End If;
227 --
228 hr_utility.set_location(' Leaving:'||l_proc, 15);
229 Exception
230 When hr_api.check_integrity_violated Then
231 -- A check constraint has been violated
232 ben_vpf_shd.g_api_dml := false; -- Unset the api dml status
233 ben_vpf_shd.constraint_error
234 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235 When hr_api.unique_integrity_violated Then
236 -- Unique integrity has been violated
237 ben_vpf_shd.g_api_dml := false; -- Unset the api dml status
238 ben_vpf_shd.constraint_error
239 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
240 When Others Then
241 ben_vpf_shd.g_api_dml := false; -- Unset the api dml status
242 Raise;
243 End dt_update_dml;
244 --
245 -- ----------------------------------------------------------------------------
246 -- |------------------------------< update_dml >------------------------------|
247 -- ----------------------------------------------------------------------------
248 -- {Start Of Comments}
249 --
250 -- Description:
251 -- This procedure calls the dt_update_dml control logic which handles
252 -- the actual datetrack dml.
253 --
254 -- Prerequisites:
255 -- This is an internal private procedure which must be called from the upd
256 -- procedure.
257 --
258 -- In Parameters:
259 -- A Pl/Sql record structre.
260 --
261 -- Post Success:
262 -- Processing contines.
263 --
264 -- Post Failure:
265 -- No specific error handling is required within this procedure.
266 --
267 -- Developer Implementation Notes:
268 -- The update 'set' arguments list should be modified if any of your
269 -- attributes are not updateable.
270 --
271 -- Access Status:
272 -- Internal Row Handler Use Only.
273 --
274 -- {End Of Comments}
275 -- ----------------------------------------------------------------------------
276 Procedure update_dml
277 (p_rec in out nocopy ben_vpf_shd.g_rec_type,
278 p_effective_date in date,
279 p_datetrack_mode in varchar2,
280 p_validation_start_date in date,
281 p_validation_end_date in date) is
282 --
283 l_proc varchar2(72) := g_package||'update_dml';
284 --
285 Begin
286 hr_utility.set_location('Entering:'||l_proc, 5);
287 --
288 dt_update_dml(p_rec => p_rec,
289 p_effective_date => p_effective_date,
290 p_datetrack_mode => p_datetrack_mode,
291 p_validation_start_date => p_validation_start_date,
292 p_validation_end_date => p_validation_end_date);
293 --
294 hr_utility.set_location(' Leaving:'||l_proc, 10);
295 End update_dml;
296 --
297 -- ----------------------------------------------------------------------------
298 -- |----------------------------< dt_pre_update >-----------------------------|
299 -- ----------------------------------------------------------------------------
300 -- {Start Of Comments}
301 --
302 -- Description:
303 -- The dt_pre_update procedure controls the execution
304 -- of dml for the datetrack modes of: UPDATE, UPDATE_OVERRIDE
305 -- and UPDATE_CHANGE_INSERT only. The execution required is as
306 -- follows:
307 --
308 -- 1) Providing the datetrack update mode is not 'CORRECTION'
309 -- then set the effective end date of the current row (this
310 -- will be the validation_start_date - 1).
311 -- 2) If the datetrack mode is 'UPDATE_OVERRIDE' then call the
312 -- corresponding delete_dml process to delete any future rows
313 -- where the effective_start_date is greater than or equal to
314 -- the validation_start_date.
315 -- 3) Call the insert_dml process to insert the new updated row
316 -- details..
317 --
318 -- Prerequisites:
319 -- This is an internal procedure which is called from the
320 -- pre_update procedure.
321 --
322 -- In Parameters:
323 --
324 -- Post Success:
325 -- Processing continues.
326 --
327 -- Post Failure:
328 -- If an error has occurred, an error message and exception will be raised
329 -- but not handled.
330 --
331 -- Developer Implementation Notes:
332 -- This is an internal procedure which is required by Datetrack. Don't
333 -- remove or modify.
334 --
335 -- Access Status:
336 -- Internal Row Handler Use Only.
337 --
338 -- {End Of Comments}
339 -- ----------------------------------------------------------------------------
340 Procedure dt_pre_update
341 (p_rec in out nocopy ben_vpf_shd.g_rec_type,
342 p_effective_date in date,
343 p_datetrack_mode in varchar2,
344 p_validation_start_date in date,
345 p_validation_end_date in date) is
346 --
347 l_proc varchar2(72) := g_package||'dt_pre_update';
348 l_dummy_version_number number;
349 --
350 Begin
351 hr_utility.set_location('Entering:'||l_proc, 5);
352 If (p_datetrack_mode <> 'CORRECTION') then
353 hr_utility.set_location(l_proc, 10);
354 --
355 -- Update the current effective end date
356 --
357 ben_vpf_shd.upd_effective_end_date
358 (p_effective_date => p_effective_date,
359 p_base_key_value => p_rec.vrbl_rt_prfl_id,
360 p_new_effective_end_date => (p_validation_start_date - 1),
361 p_validation_start_date => p_validation_start_date,
362 p_validation_end_date => p_validation_end_date,
363 p_object_version_number => l_dummy_version_number);
364 --
365 If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
366 hr_utility.set_location(l_proc, 15);
367 --
368 -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
369 -- delete any future rows
370 --
371 ben_vpf_del.delete_dml
372 (p_rec => p_rec,
373 p_effective_date => p_effective_date,
374 p_datetrack_mode => p_datetrack_mode,
375 p_validation_start_date => p_validation_start_date,
376 p_validation_end_date => p_validation_end_date);
377 End If;
378 hr_utility.set_location(l_proc, 20);
379 --
380 -- We must now insert the updated row
381 --
382 ben_vpf_ins.insert_dml
383 (p_rec => p_rec,
384 p_effective_date => p_effective_date,
385 p_datetrack_mode => p_datetrack_mode,
386 p_validation_start_date => p_validation_start_date,
387 p_validation_end_date => p_validation_end_date);
388 End If;
389 hr_utility.set_location(' Leaving:'||l_proc, 20);
390 End dt_pre_update;
391 --
392 -- ----------------------------------------------------------------------------
393 -- |------------------------------< pre_update >------------------------------|
394 -- ----------------------------------------------------------------------------
395 -- {Start Of Comments}
396 --
397 -- Description:
398 -- This private procedure contains any processing which is required before
399 -- the update dml.
400 --
401 -- Prerequisites:
402 -- This is an internal procedure which is called from the upd procedure.
403 --
404 -- In Parameters:
405 -- A Pl/Sql record structre.
406 --
407 -- Post Success:
408 -- Processing continues.
409 --
410 -- Post Failure:
411 -- If an error has occurred, an error message and exception will be raised
412 -- but not handled.
413 --
414 -- Developer Implementation Notes:
415 -- Any pre-processing required before the update dml is issued should be
416 -- coded within this procedure. It is important to note that any 3rd party
417 -- maintenance should be reviewed before placing in this procedure. The call
418 -- to the dt_update_dml procedure should NOT be removed.
419 --
420 -- Access Status:
421 -- Internal Row Handler Use Only.
422 --
423 -- {End Of Comments}
424 -- ----------------------------------------------------------------------------
425 Procedure pre_update
426 (p_rec in out nocopy ben_vpf_shd.g_rec_type,
427 p_effective_date in date,
428 p_datetrack_mode in varchar2,
429 p_validation_start_date in date,
430 p_validation_end_date in date) is
431 --
432 l_proc varchar2(72) := g_package||'pre_update';
433 --
434 Begin
435 hr_utility.set_location('Entering:'||l_proc, 5);
436 --
437 --
438 --
439 dt_pre_update
440 (p_rec => p_rec,
441 p_effective_date => p_effective_date,
442 p_datetrack_mode => p_datetrack_mode,
443 p_validation_start_date => p_validation_start_date,
444 p_validation_end_date => p_validation_end_date);
445 --
446 hr_utility.set_location(' Leaving:'||l_proc, 10);
447 End pre_update;
448 --
449 -- ----------------------------------------------------------------------------
450 -- |-----------------------------< post_update >------------------------------|
451 -- ----------------------------------------------------------------------------
452 -- {Start Of Comments}
453 --
454 -- Description:
455 -- This private procedure contains any processing which is required after the
456 -- update dml.
457 --
458 -- Prerequisites:
459 -- This is an internal procedure which is called from the upd procedure.
460 --
461 -- In Parameters:
462 -- A Pl/Sql record structre.
463 --
464 -- Post Success:
465 -- Processing continues.
466 --
467 -- Post Failure:
468 -- If an error has occurred, an error message and exception will be raised
469 -- but not handled.
470 --
471 -- Developer Implementation Notes:
472 -- Any post-processing required after the update dml is issued should be
473 -- coded within this procedure. It is important to note that any 3rd party
474 -- maintenance should be reviewed before placing in this procedure.
475 --
476 -- Access Status:
477 -- Internal Row Handler Use Only.
478 --
479 -- {End Of Comments}
480 -- ----------------------------------------------------------------------------
481 Procedure post_update
482 (p_rec in ben_vpf_shd.g_rec_type,
483 p_effective_date in date,
484 p_datetrack_mode in varchar2,
485 p_validation_start_date in date,
486 p_validation_end_date in date) is
487 --
488 l_proc varchar2(72) := g_package||'post_update';
489 --
490 Begin
491 --
492 hr_utility.set_location('Entering:'||l_proc, 5);
493 --
494 -- Start of API User Hook for post_update.
495 --
496 begin
497 --
498 ben_vpf_rku.after_update
499 (p_vrbl_rt_prfl_id =>p_rec.vrbl_rt_prfl_id
500 ,p_effective_start_date =>p_rec.effective_start_date
501 ,p_effective_end_date =>p_rec.effective_end_date
502 ,p_pl_typ_opt_typ_id =>p_rec.pl_typ_opt_typ_id
503 ,p_pl_id =>p_rec.pl_id
504 ,p_oipl_id =>p_rec.oipl_id
505 ,p_comp_lvl_fctr_id =>p_rec.comp_lvl_fctr_id
506 ,p_business_group_id =>p_rec.business_group_id
507 ,p_acty_typ_cd =>p_rec.acty_typ_cd
508 ,p_rt_typ_cd =>p_rec.rt_typ_cd
509 ,p_bnft_rt_typ_cd =>p_rec.bnft_rt_typ_cd
510 ,p_tx_typ_cd =>p_rec.tx_typ_cd
511 ,p_vrbl_rt_trtmt_cd =>p_rec.vrbl_rt_trtmt_cd
512 ,p_acty_ref_perd_cd =>p_rec.acty_ref_perd_cd
513 ,p_mlt_cd =>p_rec.mlt_cd
514 ,p_incrmnt_elcn_val =>p_rec.incrmnt_elcn_val
515 ,p_dflt_elcn_val =>p_rec.dflt_elcn_val
516 ,p_mx_elcn_val =>p_rec.mx_elcn_val
517 ,p_mn_elcn_val =>p_rec.mn_elcn_val
518 ,p_lwr_lmt_val =>p_rec.lwr_lmt_val
519 ,p_lwr_lmt_calc_rl =>p_rec.lwr_lmt_calc_rl
520 ,p_upr_lmt_val =>p_rec.upr_lmt_val
521 ,p_upr_lmt_calc_rl =>p_rec.upr_lmt_calc_rl
522 ,p_ultmt_upr_lmt =>p_rec.ultmt_upr_lmt
523 ,p_ultmt_lwr_lmt =>p_rec.ultmt_lwr_lmt
524 ,p_ultmt_upr_lmt_calc_rl =>p_rec.ultmt_upr_lmt_calc_rl
525 ,p_ultmt_lwr_lmt_calc_rl =>p_rec.ultmt_lwr_lmt_calc_rl
526 ,p_ann_mn_elcn_val =>p_rec.ann_mn_elcn_val
527 ,p_ann_mx_elcn_val =>p_rec.ann_mx_elcn_val
528 ,p_val =>p_rec.val
529 ,p_name =>p_rec.name
530 ,p_no_mn_elcn_val_dfnd_flag =>p_rec.no_mn_elcn_val_dfnd_flag
531 ,p_no_mx_elcn_val_dfnd_flag =>p_rec.no_mx_elcn_val_dfnd_flag
532 ,p_alwys_sum_all_cvg_flag =>p_rec.alwys_sum_all_cvg_flag
533 ,p_alwys_cnt_all_prtts_flag =>p_rec.alwys_cnt_all_prtts_flag
534 ,p_val_calc_rl =>p_rec.val_calc_rl
535 ,p_vrbl_rt_prfl_stat_cd =>p_rec.vrbl_rt_prfl_stat_cd
536 ,p_vrbl_usg_cd =>p_rec.vrbl_usg_cd
537 ,p_asmt_to_use_cd =>p_rec.asmt_to_use_cd
538 ,p_rndg_cd =>p_rec.rndg_cd
539 ,p_rndg_rl =>p_rec.rndg_rl
540 ,p_rt_hrly_slrd_flag =>p_rec.rt_hrly_slrd_flag
541 ,p_rt_pstl_cd_flag =>p_rec.rt_pstl_cd_flag
542 ,p_rt_lbr_mmbr_flag =>p_rec.rt_lbr_mmbr_flag
543 ,p_rt_lgl_enty_flag =>p_rec.rt_lgl_enty_flag
544 ,p_rt_benfts_grp_flag =>p_rec.rt_benfts_grp_flag
545 ,p_rt_wk_loc_flag =>p_rec.rt_wk_loc_flag
546 ,p_rt_brgng_unit_flag =>p_rec.rt_brgng_unit_flag
547 ,p_rt_age_flag =>p_rec.rt_age_flag
548 ,p_rt_los_flag =>p_rec.rt_los_flag
549 ,p_rt_per_typ_flag =>p_rec.rt_per_typ_flag
550 ,p_rt_fl_tm_pt_tm_flag =>p_rec.rt_fl_tm_pt_tm_flag
551 ,p_rt_ee_stat_flag =>p_rec.rt_ee_stat_flag
552 ,p_rt_grd_flag =>p_rec.rt_grd_flag
553 ,p_rt_pct_fl_tm_flag =>p_rec.rt_pct_fl_tm_flag
554 ,p_rt_asnt_set_flag =>p_rec.rt_asnt_set_flag
555 ,p_rt_hrs_wkd_flag =>p_rec.rt_hrs_wkd_flag
556 ,p_rt_comp_lvl_flag =>p_rec.rt_comp_lvl_flag
557 ,p_rt_org_unit_flag =>p_rec.rt_org_unit_flag
558 ,p_rt_loa_rsn_flag =>p_rec.rt_loa_rsn_flag
559 ,p_rt_pyrl_flag =>p_rec.rt_pyrl_flag
560 ,p_rt_schedd_hrs_flag =>p_rec.rt_schedd_hrs_flag
561 ,p_rt_py_bss_flag =>p_rec.rt_py_bss_flag
562 ,p_rt_prfl_rl_flag =>p_rec.rt_prfl_rl_flag
563 ,p_rt_cmbn_age_los_flag =>p_rec.rt_cmbn_age_los_flag
564 ,p_rt_prtt_pl_flag =>p_rec.rt_prtt_pl_flag
565 ,p_rt_svc_area_flag =>p_rec.rt_svc_area_flag
566 ,p_rt_ppl_grp_flag =>p_rec.rt_ppl_grp_flag
567 ,p_rt_dsbld_flag =>p_rec.rt_dsbld_flag
568 ,p_rt_hlth_cvg_flag =>p_rec.rt_hlth_cvg_flag
569 ,p_rt_poe_flag =>p_rec.rt_poe_flag
570 ,p_rt_ttl_cvg_vol_flag =>p_rec.rt_ttl_cvg_vol_flag
571 ,p_rt_ttl_prtt_flag =>p_rec.rt_ttl_prtt_flag
572 ,p_rt_gndr_flag =>p_rec.rt_gndr_flag
573 ,p_rt_tbco_use_flag =>p_rec.rt_tbco_use_flag
574 ,p_vpf_attribute_category =>p_rec.vpf_attribute_category
575 ,p_vpf_attribute1 =>p_rec.vpf_attribute1
576 ,p_vpf_attribute2 =>p_rec.vpf_attribute2
577 ,p_vpf_attribute3 =>p_rec.vpf_attribute3
578 ,p_vpf_attribute4 =>p_rec.vpf_attribute4
579 ,p_vpf_attribute5 =>p_rec.vpf_attribute5
580 ,p_vpf_attribute6 =>p_rec.vpf_attribute6
581 ,p_vpf_attribute7 =>p_rec.vpf_attribute7
582 ,p_vpf_attribute8 =>p_rec.vpf_attribute8
583 ,p_vpf_attribute9 =>p_rec.vpf_attribute9
584 ,p_vpf_attribute10 =>p_rec.vpf_attribute10
585 ,p_vpf_attribute11 =>p_rec.vpf_attribute11
586 ,p_vpf_attribute12 =>p_rec.vpf_attribute12
587 ,p_vpf_attribute13 =>p_rec.vpf_attribute13
588 ,p_vpf_attribute14 =>p_rec.vpf_attribute14
589 ,p_vpf_attribute15 =>p_rec.vpf_attribute15
590 ,p_vpf_attribute16 =>p_rec.vpf_attribute16
591 ,p_vpf_attribute17 =>p_rec.vpf_attribute17
592 ,p_vpf_attribute18 =>p_rec.vpf_attribute18
593 ,p_vpf_attribute19 =>p_rec.vpf_attribute19
594 ,p_vpf_attribute20 =>p_rec.vpf_attribute20
595 ,p_vpf_attribute21 =>p_rec.vpf_attribute21
596 ,p_vpf_attribute22 =>p_rec.vpf_attribute22
597 ,p_vpf_attribute23 =>p_rec.vpf_attribute23
598 ,p_vpf_attribute24 =>p_rec.vpf_attribute24
599 ,p_vpf_attribute25 =>p_rec.vpf_attribute25
600 ,p_vpf_attribute26 =>p_rec.vpf_attribute26
601 ,p_vpf_attribute27 =>p_rec.vpf_attribute27
602 ,p_vpf_attribute28 =>p_rec.vpf_attribute28
603 ,p_vpf_attribute29 =>p_rec.vpf_attribute29
604 ,p_vpf_attribute30 =>p_rec.vpf_attribute30
605 ,p_object_version_number =>p_rec.object_version_number
606 ,p_effective_date =>p_effective_date
607 ,p_datetrack_mode =>p_datetrack_mode
608 ,p_validation_start_date =>p_validation_start_date
609 ,p_validation_end_date =>p_validation_end_date
610 ,p_rt_cntng_prtn_prfl_flag =>p_rec.rt_cntng_prtn_prfl_flag
611 ,p_rt_cbr_quald_bnf_flag =>p_rec.rt_cbr_quald_bnf_flag
612 ,p_rt_optd_mdcr_flag =>p_rec.rt_optd_mdcr_flag
613 ,p_rt_lvg_rsn_flag =>p_rec.rt_lvg_rsn_flag
614 ,p_rt_pstn_flag =>p_rec.rt_pstn_flag
615 ,p_rt_comptncy_flag =>p_rec.rt_comptncy_flag
616 ,p_rt_job_flag =>p_rec.rt_job_flag
617 ,p_rt_qual_titl_flag =>p_rec.rt_qual_titl_flag
618 ,p_rt_dpnt_cvrd_pl_flag =>p_rec.rt_dpnt_cvrd_pl_flag
619 ,p_rt_dpnt_cvrd_plip_flag =>p_rec.rt_dpnt_cvrd_plip_flag
620 ,p_rt_dpnt_cvrd_ptip_flag =>p_rec.rt_dpnt_cvrd_ptip_flag
621 ,p_rt_dpnt_cvrd_pgm_flag =>p_rec.rt_dpnt_cvrd_pgm_flag
622 ,p_rt_enrld_oipl_flag =>p_rec.rt_enrld_oipl_flag
623 ,p_rt_enrld_pl_flag =>p_rec.rt_enrld_pl_flag
624 ,p_rt_enrld_plip_flag =>p_rec.rt_enrld_plip_flag
625 ,p_rt_enrld_ptip_flag =>p_rec.rt_enrld_ptip_flag
626 ,p_rt_enrld_pgm_flag =>p_rec.rt_enrld_pgm_flag
627 ,p_rt_prtt_anthr_pl_flag =>p_rec.rt_prtt_anthr_pl_flag
628 ,p_rt_othr_ptip_flag =>p_rec.rt_othr_ptip_flag
629 ,p_rt_no_othr_cvg_flag =>p_rec.rt_no_othr_cvg_flag
630 ,p_rt_dpnt_othr_ptip_flag =>p_rec.rt_dpnt_othr_ptip_flag
631 ,p_rt_qua_in_gr_flag =>p_rec.rt_qua_in_gr_flag
632 ,p_rt_perf_rtng_flag =>p_rec.rt_perf_rtng_flag
633 ,p_rt_elig_prfl_flag =>p_rec.rt_elig_prfl_flag
634 ,p_effective_start_date_o =>ben_vpf_shd.g_old_rec.effective_start_date
635 ,p_effective_end_date_o =>ben_vpf_shd.g_old_rec.effective_end_date
636 ,p_pl_typ_opt_typ_id_o =>ben_vpf_shd.g_old_rec.pl_typ_opt_typ_id
637 ,p_pl_id_o =>ben_vpf_shd.g_old_rec.pl_id
638 ,p_oipl_id_o =>ben_vpf_shd.g_old_rec.oipl_id
639 ,p_comp_lvl_fctr_id_o =>ben_vpf_shd.g_old_rec.comp_lvl_fctr_id
640 ,p_business_group_id_o =>ben_vpf_shd.g_old_rec.business_group_id
641 ,p_acty_typ_cd_o =>ben_vpf_shd.g_old_rec.acty_typ_cd
642 ,p_rt_typ_cd_o =>ben_vpf_shd.g_old_rec.rt_typ_cd
643 ,p_bnft_rt_typ_cd_o =>ben_vpf_shd.g_old_rec.bnft_rt_typ_cd
644 ,p_tx_typ_cd_o =>ben_vpf_shd.g_old_rec.tx_typ_cd
645 ,p_vrbl_rt_trtmt_cd_o =>ben_vpf_shd.g_old_rec.vrbl_rt_trtmt_cd
646 ,p_acty_ref_perd_cd_o =>ben_vpf_shd.g_old_rec.acty_ref_perd_cd
647 ,p_mlt_cd_o =>ben_vpf_shd.g_old_rec.mlt_cd
648 ,p_incrmnt_elcn_val_o =>ben_vpf_shd.g_old_rec.incrmnt_elcn_val
649 ,p_dflt_elcn_val_o =>ben_vpf_shd.g_old_rec.dflt_elcn_val
650 ,p_mx_elcn_val_o =>ben_vpf_shd.g_old_rec.mx_elcn_val
651 ,p_mn_elcn_val_o =>ben_vpf_shd.g_old_rec.mn_elcn_val
652 ,p_lwr_lmt_val_o =>ben_vpf_shd.g_old_rec.lwr_lmt_val
653 ,p_lwr_lmt_calc_rl_o =>ben_vpf_shd.g_old_rec.lwr_lmt_calc_rl
654 ,p_upr_lmt_val_o =>ben_vpf_shd.g_old_rec.upr_lmt_val
655 ,p_upr_lmt_calc_rl_o =>ben_vpf_shd.g_old_rec.upr_lmt_calc_rl
656 ,p_ultmt_upr_lmt_o =>ben_vpf_shd.g_old_rec.ultmt_upr_lmt
657 ,p_ultmt_lwr_lmt_calc_rl_o =>ben_vpf_shd.g_old_rec.ultmt_lwr_lmt_calc_rl
658 ,p_ultmt_upr_lmt_calc_rl_o =>ben_vpf_shd.g_old_rec.ultmt_upr_lmt_calc_rl
659 ,p_ultmt_lwr_lmt_o =>ben_vpf_shd.g_old_rec.ultmt_lwr_lmt
660 ,p_ann_mn_elcn_val_o =>ben_vpf_shd.g_old_rec.ann_mn_elcn_val
661 ,p_ann_mx_elcn_val_o =>ben_vpf_shd.g_old_rec.ann_mx_elcn_val
662 ,p_val_o =>ben_vpf_shd.g_old_rec.val
663 ,p_name_o =>ben_vpf_shd.g_old_rec.name
664 ,p_no_mn_elcn_val_dfnd_flag_o =>ben_vpf_shd.g_old_rec.no_mn_elcn_val_dfnd_flag
665 ,p_no_mx_elcn_val_dfnd_flag_o =>ben_vpf_shd.g_old_rec.no_mx_elcn_val_dfnd_flag
666 ,p_alwys_sum_all_cvg_flag_o =>ben_vpf_shd.g_old_rec.alwys_sum_all_cvg_flag
667 ,p_alwys_cnt_all_prtts_flag_o =>ben_vpf_shd.g_old_rec.alwys_cnt_all_prtts_flag
668 ,p_val_calc_rl_o =>ben_vpf_shd.g_old_rec.val_calc_rl
669 ,p_vrbl_rt_prfl_stat_cd_o =>ben_vpf_shd.g_old_rec.vrbl_rt_prfl_stat_cd
670 ,p_vrbl_usg_cd_o =>ben_vpf_shd.g_old_rec.vrbl_usg_cd
671 ,p_asmt_to_use_cd_o =>ben_vpf_shd.g_old_rec.asmt_to_use_cd
672 ,p_rndg_cd_o =>ben_vpf_shd.g_old_rec.rndg_cd
673 ,p_rndg_rl_o =>ben_vpf_shd.g_old_rec.rndg_rl
674 ,p_rt_hrly_slrd_flag_o =>ben_vpf_shd.g_old_rec.rt_hrly_slrd_flag
675 ,p_rt_pstl_cd_flag_o =>ben_vpf_shd.g_old_rec.rt_pstl_cd_flag
676 ,p_rt_lbr_mmbr_flag_o =>ben_vpf_shd.g_old_rec.rt_lbr_mmbr_flag
677 ,p_rt_lgl_enty_flag_o =>ben_vpf_shd.g_old_rec.rt_lgl_enty_flag
678 ,p_rt_benfts_grp_flag_o =>ben_vpf_shd.g_old_rec.rt_benfts_grp_flag
679 ,p_rt_wk_loc_flag_o =>ben_vpf_shd.g_old_rec.rt_wk_loc_flag
680 ,p_rt_brgng_unit_flag_o =>ben_vpf_shd.g_old_rec.rt_brgng_unit_flag
681 ,p_rt_age_flag_o =>ben_vpf_shd.g_old_rec.rt_age_flag
682 ,p_rt_los_flag_o =>ben_vpf_shd.g_old_rec.rt_los_flag
683 ,p_rt_per_typ_flag_o =>ben_vpf_shd.g_old_rec.rt_per_typ_flag
684 ,p_rt_fl_tm_pt_tm_flag_o =>ben_vpf_shd.g_old_rec.rt_fl_tm_pt_tm_flag
685 ,p_rt_ee_stat_flag_o =>ben_vpf_shd.g_old_rec.rt_ee_stat_flag
686 ,p_rt_grd_flag_o =>ben_vpf_shd.g_old_rec.rt_grd_flag
687 ,p_rt_pct_fl_tm_flag_o =>ben_vpf_shd.g_old_rec.rt_pct_fl_tm_flag
688 ,p_rt_asnt_set_flag_o =>ben_vpf_shd.g_old_rec.rt_asnt_set_flag
689 ,p_rt_hrs_wkd_flag_o =>ben_vpf_shd.g_old_rec.rt_hrs_wkd_flag
690 ,p_rt_comp_lvl_flag_o =>ben_vpf_shd.g_old_rec.rt_comp_lvl_flag
691 ,p_rt_org_unit_flag_o =>ben_vpf_shd.g_old_rec.rt_org_unit_flag
692 ,p_rt_loa_rsn_flag_o =>ben_vpf_shd.g_old_rec.rt_loa_rsn_flag
693 ,p_rt_pyrl_flag_o =>ben_vpf_shd.g_old_rec.rt_pyrl_flag
694 ,p_rt_schedd_hrs_flag_o =>ben_vpf_shd.g_old_rec.rt_schedd_hrs_flag
695 ,p_rt_py_bss_flag_o =>ben_vpf_shd.g_old_rec.rt_py_bss_flag
696 ,p_rt_prfl_rl_flag_o =>ben_vpf_shd.g_old_rec.rt_prfl_rl_flag
697 ,p_rt_cmbn_age_los_flag_o =>ben_vpf_shd.g_old_rec.rt_cmbn_age_los_flag
698 ,p_rt_prtt_pl_flag_o =>ben_vpf_shd.g_old_rec.rt_prtt_pl_flag
699 ,p_rt_svc_area_flag_o =>ben_vpf_shd.g_old_rec.rt_svc_area_flag
700 ,p_rt_ppl_grp_flag_o =>ben_vpf_shd.g_old_rec.rt_ppl_grp_flag
701 ,p_rt_dsbld_flag_o =>ben_vpf_shd.g_old_rec.rt_dsbld_flag
702 ,p_rt_hlth_cvg_flag_o =>ben_vpf_shd.g_old_rec.rt_hlth_cvg_flag
703 ,p_rt_poe_flag_o =>ben_vpf_shd.g_old_rec.rt_poe_flag
704 ,p_rt_ttl_cvg_vol_flag_o =>ben_vpf_shd.g_old_rec.rt_ttl_cvg_vol_flag
705 ,p_rt_ttl_prtt_flag_o =>ben_vpf_shd.g_old_rec.rt_ttl_prtt_flag
706 ,p_rt_gndr_flag_o =>ben_vpf_shd.g_old_rec.rt_gndr_flag
707 ,p_rt_tbco_use_flag_o =>ben_vpf_shd.g_old_rec.rt_tbco_use_flag
708 ,p_vpf_attribute_category_o =>ben_vpf_shd.g_old_rec.vpf_attribute_category
709 ,p_vpf_attribute1_o =>ben_vpf_shd.g_old_rec.vpf_attribute1
710 ,p_vpf_attribute2_o =>ben_vpf_shd.g_old_rec.vpf_attribute2
711 ,p_vpf_attribute3_o =>ben_vpf_shd.g_old_rec.vpf_attribute3
712 ,p_vpf_attribute4_o =>ben_vpf_shd.g_old_rec.vpf_attribute4
713 ,p_vpf_attribute5_o =>ben_vpf_shd.g_old_rec.vpf_attribute5
714 ,p_vpf_attribute6_o =>ben_vpf_shd.g_old_rec.vpf_attribute6
715 ,p_vpf_attribute7_o =>ben_vpf_shd.g_old_rec.vpf_attribute7
716 ,p_vpf_attribute8_o =>ben_vpf_shd.g_old_rec.vpf_attribute8
717 ,p_vpf_attribute9_o =>ben_vpf_shd.g_old_rec.vpf_attribute9
718 ,p_vpf_attribute10_o =>ben_vpf_shd.g_old_rec.vpf_attribute10
719 ,p_vpf_attribute11_o =>ben_vpf_shd.g_old_rec.vpf_attribute11
720 ,p_vpf_attribute12_o =>ben_vpf_shd.g_old_rec.vpf_attribute12
721 ,p_vpf_attribute13_o =>ben_vpf_shd.g_old_rec.vpf_attribute13
722 ,p_vpf_attribute14_o =>ben_vpf_shd.g_old_rec.vpf_attribute14
723 ,p_vpf_attribute15_o =>ben_vpf_shd.g_old_rec.vpf_attribute15
724 ,p_vpf_attribute16_o =>ben_vpf_shd.g_old_rec.vpf_attribute16
725 ,p_vpf_attribute17_o =>ben_vpf_shd.g_old_rec.vpf_attribute17
726 ,p_vpf_attribute18_o =>ben_vpf_shd.g_old_rec.vpf_attribute18
727 ,p_vpf_attribute19_o =>ben_vpf_shd.g_old_rec.vpf_attribute19
728 ,p_vpf_attribute20_o =>ben_vpf_shd.g_old_rec.vpf_attribute20
729 ,p_vpf_attribute21_o =>ben_vpf_shd.g_old_rec.vpf_attribute21
730 ,p_vpf_attribute22_o =>ben_vpf_shd.g_old_rec.vpf_attribute22
731 ,p_vpf_attribute23_o =>ben_vpf_shd.g_old_rec.vpf_attribute23
732 ,p_vpf_attribute24_o =>ben_vpf_shd.g_old_rec.vpf_attribute24
733 ,p_vpf_attribute25_o =>ben_vpf_shd.g_old_rec.vpf_attribute25
734 ,p_vpf_attribute26_o =>ben_vpf_shd.g_old_rec.vpf_attribute26
735 ,p_vpf_attribute27_o =>ben_vpf_shd.g_old_rec.vpf_attribute27
736 ,p_vpf_attribute28_o =>ben_vpf_shd.g_old_rec.vpf_attribute28
737 ,p_vpf_attribute29_o =>ben_vpf_shd.g_old_rec.vpf_attribute29
738 ,p_vpf_attribute30_o =>ben_vpf_shd.g_old_rec.vpf_attribute30
739 ,p_object_version_number_o =>ben_vpf_shd.g_old_rec.object_version_number
740 ,p_rt_cntng_prtn_prfl_flag_o =>ben_vpf_shd.g_old_rec.rt_cntng_prtn_prfl_flag
741 ,p_rt_cbr_quald_bnf_flag_o =>ben_vpf_shd.g_old_rec.rt_cbr_quald_bnf_flag
742 ,p_rt_optd_mdcr_flag_o =>ben_vpf_shd.g_old_rec.rt_optd_mdcr_flag
743 ,p_rt_lvg_rsn_flag_o =>ben_vpf_shd.g_old_rec.rt_lvg_rsn_flag
744 ,p_rt_pstn_flag_o =>ben_vpf_shd.g_old_rec.rt_pstn_flag
745 ,p_rt_comptncy_flag_o =>ben_vpf_shd.g_old_rec.rt_comptncy_flag
746 ,p_rt_job_flag_o =>ben_vpf_shd.g_old_rec.rt_job_flag
747 ,p_rt_qual_titl_flag_o =>ben_vpf_shd.g_old_rec.rt_qual_titl_flag
748 ,p_rt_dpnt_cvrd_pl_flag_o =>ben_vpf_shd.g_old_rec.rt_dpnt_cvrd_pl_flag
749 ,p_rt_dpnt_cvrd_plip_flag_o =>ben_vpf_shd.g_old_rec.rt_dpnt_cvrd_plip_flag
750 ,p_rt_dpnt_cvrd_ptip_flag_o =>ben_vpf_shd.g_old_rec.rt_dpnt_cvrd_ptip_flag
751 ,p_rt_dpnt_cvrd_pgm_flag_o =>ben_vpf_shd.g_old_rec.rt_dpnt_cvrd_pgm_flag
752 ,p_rt_enrld_oipl_flag_o =>ben_vpf_shd.g_old_rec.rt_enrld_oipl_flag
753 ,p_rt_enrld_pl_flag_o =>ben_vpf_shd.g_old_rec.rt_enrld_pl_flag
754 ,p_rt_enrld_plip_flag_o =>ben_vpf_shd.g_old_rec.rt_enrld_plip_flag
755 ,p_rt_enrld_ptip_flag_o =>ben_vpf_shd.g_old_rec.rt_enrld_ptip_flag
756 ,p_rt_enrld_pgm_flag_o =>ben_vpf_shd.g_old_rec.rt_enrld_pgm_flag
757 ,p_rt_prtt_anthr_pl_flag_o =>ben_vpf_shd.g_old_rec.rt_prtt_anthr_pl_flag
758 ,p_rt_othr_ptip_flag_o =>ben_vpf_shd.g_old_rec.rt_othr_ptip_flag
759 ,p_rt_no_othr_cvg_flag_o =>ben_vpf_shd.g_old_rec.rt_no_othr_cvg_flag
760 ,p_rt_dpnt_othr_ptip_flag_o =>ben_vpf_shd.g_old_rec.rt_dpnt_othr_ptip_flag
761 ,p_rt_qua_in_gr_flag_o =>ben_vpf_shd.g_old_rec.rt_qua_in_gr_flag
762 ,p_rt_perf_rtng_flag_o =>ben_vpf_shd.g_old_rec.rt_perf_rtng_flag
763 ,p_rt_elig_prfl_flag_o =>ben_vpf_shd.g_old_rec.rt_elig_prfl_flag
764 );
765 --
766 exception
767 --
768 when hr_api.cannot_find_prog_unit then
769 --
770 hr_api.cannot_find_prog_unit_error
771 (p_module_name => 'ben_vrbl_rt_prfl_f'
772 ,p_hook_type => 'AU');
773 --
774 end;
775 --
776 -- End of API User Hook for post_update.
777 --
778 --
779 hr_utility.set_location(' Leaving:'||l_proc, 10);
780 End post_update;
781 --
782 -- ----------------------------------------------------------------------------
783 -- |-----------------------------< convert_defs >-----------------------------|
784 -- ----------------------------------------------------------------------------
785 -- {Start Of Comments}
786 --
787 -- Description:
788 -- The Convert_Defs procedure has one very important function:
789 -- It must return the record structure for the row with all system defaulted
790 -- values converted into its corresponding parameter value for update. When
791 -- we attempt to update a row through the Upd process , certain
792 -- parameters can be defaulted which enables flexibility in the calling of
793 -- the upd process (e.g. only attributes which need to be updated need to be
794 -- specified). For the upd process to determine which attributes
795 -- have NOT been specified we need to check if the parameter has a reserved
796 -- system default value. Therefore, for all parameters which have a
797 -- corresponding reserved system default mechanism specified we need to
798 -- check if a system default is being used. If a system default is being
799 -- used then we convert the defaulted value into its corresponding attribute
800 -- value held in the g_old_rec data structure.
801 --
802 -- Prerequisites:
803 -- This private function can only be called from the upd process.
804 --
805 -- In Parameters:
806 -- A Pl/Sql record structre.
807 --
808 -- Post Success:
809 -- The record structure will be returned with all system defaulted parameter
810 -- values converted into its current row attribute value.
811 --
812 -- Post Failure:
813 -- No direct error handling is required within this function. Any possible
814 -- errors within this procedure will be a PL/SQL value error due to conversion
815 -- of datatypes or data lengths.
816 --
817 -- Developer Implementation Notes:
818 -- None.
819 --
820 -- Access Status:
821 -- Internal Row Handler Use Only.
822 --
823 -- {End Of Comments}
824 -- ----------------------------------------------------------------------------
825 Procedure convert_defs(p_rec in out nocopy ben_vpf_shd.g_rec_type) is
826 --
827 l_proc varchar2(72) := g_package||'convert_defs';
828 --
829 Begin
830 --
831 hr_utility.set_location('Entering:'||l_proc, 5);
832 --
833 -- We must now examine each argument value in the
834 -- p_rec plsql record structure
835 -- to see if a system default is being used. If a system default
836 -- is being used then we must set to the 'current' argument value.
837 --
838 If (p_rec.pl_typ_opt_typ_id = hr_api.g_number) then
839 p_rec.pl_typ_opt_typ_id :=
840 ben_vpf_shd.g_old_rec.pl_typ_opt_typ_id;
841 End If;
842 If (p_rec.pl_id = hr_api.g_number) then
843 p_rec.pl_id :=
844 ben_vpf_shd.g_old_rec.pl_id;
845 End If;
846 If (p_rec.oipl_id = hr_api.g_number) then
847 p_rec.oipl_id :=
848 ben_vpf_shd.g_old_rec.oipl_id;
849 End If;
850 If (p_rec.comp_lvl_fctr_id = hr_api.g_number) then
851 p_rec.comp_lvl_fctr_id :=
852 ben_vpf_shd.g_old_rec.comp_lvl_fctr_id;
853 End If;
854 If (p_rec.business_group_id = hr_api.g_number) then
855 p_rec.business_group_id :=
856 ben_vpf_shd.g_old_rec.business_group_id;
857 End If;
858 If (p_rec.acty_typ_cd = hr_api.g_varchar2) then
859 p_rec.acty_typ_cd :=
860 ben_vpf_shd.g_old_rec.acty_typ_cd;
861 End If;
862 If (p_rec.rt_typ_cd = hr_api.g_varchar2) then
863 p_rec.rt_typ_cd :=
864 ben_vpf_shd.g_old_rec.rt_typ_cd;
865 End If;
866 If (p_rec.bnft_rt_typ_cd = hr_api.g_varchar2) then
867 p_rec.bnft_rt_typ_cd :=
868 ben_vpf_shd.g_old_rec.bnft_rt_typ_cd;
869 End If;
870 If (p_rec.tx_typ_cd = hr_api.g_varchar2) then
871 p_rec.tx_typ_cd :=
872 ben_vpf_shd.g_old_rec.tx_typ_cd;
873 End If;
874 If (p_rec.vrbl_rt_trtmt_cd = hr_api.g_varchar2) then
875 p_rec.vrbl_rt_trtmt_cd :=
876 ben_vpf_shd.g_old_rec.vrbl_rt_trtmt_cd;
877 End If;
878 If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
879 p_rec.acty_ref_perd_cd :=
880 ben_vpf_shd.g_old_rec.acty_ref_perd_cd;
881 End If;
882 If (p_rec.mlt_cd = hr_api.g_varchar2) then
883 p_rec.mlt_cd :=
884 ben_vpf_shd.g_old_rec.mlt_cd;
885 End If;
886 If (p_rec.incrmnt_elcn_val = hr_api.g_number) then
887 p_rec.incrmnt_elcn_val :=
888 ben_vpf_shd.g_old_rec.incrmnt_elcn_val;
889 End If;
890 If (p_rec.dflt_elcn_val = hr_api.g_number) then
891 p_rec.dflt_elcn_val :=
892 ben_vpf_shd.g_old_rec.dflt_elcn_val;
893 End If;
894 If (p_rec.mx_elcn_val = hr_api.g_number) then
895 p_rec.mx_elcn_val :=
896 ben_vpf_shd.g_old_rec.mx_elcn_val;
897 End If;
898 If (p_rec.mn_elcn_val = hr_api.g_number) then
899 p_rec.mn_elcn_val :=
900 ben_vpf_shd.g_old_rec.mn_elcn_val;
901 End If;
902 If (p_rec.lwr_lmt_val = hr_api.g_number) then
903 p_rec.lwr_lmt_val :=
904 ben_vpf_shd.g_old_rec.lwr_lmt_val;
905 End If;
906 If (p_rec.lwr_lmt_calc_rl = hr_api.g_number) then
907 p_rec.lwr_lmt_calc_rl :=
908 ben_vpf_shd.g_old_rec.lwr_lmt_calc_rl;
909 End If;
910 If (p_rec.upr_lmt_val = hr_api.g_number) then
911 p_rec.upr_lmt_val :=
912 ben_vpf_shd.g_old_rec.upr_lmt_val;
913 End If;
914 If (p_rec.upr_lmt_calc_rl = hr_api.g_number) then
915 p_rec.upr_lmt_calc_rl :=
916 ben_vpf_shd.g_old_rec.upr_lmt_calc_rl;
917 End If;
918 If (p_rec.ultmt_upr_lmt = hr_api.g_number) then
919 p_rec.ultmt_upr_lmt :=
920 ben_vpf_shd.g_old_rec.ultmt_upr_lmt;
921 End If;
922
923 If (p_rec.ultmt_upr_lmt_calc_rl = hr_api.g_number) then
924 p_rec.ultmt_upr_lmt_calc_rl :=
925 ben_vpf_shd.g_old_rec.ultmt_upr_lmt_calc_rl;
926 End If;
927
928 If (p_rec.ultmt_lwr_lmt = hr_api.g_number) then
929 p_rec.ultmt_lwr_lmt :=
930 ben_vpf_shd.g_old_rec.ultmt_lwr_lmt;
931 End If;
932
933 If (p_rec.ultmt_lwr_lmt_calc_rl = hr_api.g_number) then
934 p_rec.ultmt_lwr_lmt_calc_rl :=
935 ben_vpf_shd.g_old_rec.ultmt_lwr_lmt_calc_rl;
936 End If;
937
938 If (p_rec.ann_mn_elcn_val = hr_api.g_number) then
939 p_rec.ann_mn_elcn_val :=
940 ben_vpf_shd.g_old_rec.ann_mn_elcn_val;
941 End If;
942 If (p_rec.ann_mx_elcn_val = hr_api.g_number) then
943 p_rec.ann_mx_elcn_val :=
944 ben_vpf_shd.g_old_rec.ann_mx_elcn_val;
945 End If;
946 If (p_rec.val = hr_api.g_number) then
947 p_rec.val :=
948 ben_vpf_shd.g_old_rec.val;
949 End If;
950 If (p_rec.name = hr_api.g_varchar2) then
951 p_rec.name :=
952 ben_vpf_shd.g_old_rec.name;
953 End If;
954 If (p_rec.no_mn_elcn_val_dfnd_flag = hr_api.g_varchar2) then
955 p_rec.no_mn_elcn_val_dfnd_flag :=
956 ben_vpf_shd.g_old_rec.no_mn_elcn_val_dfnd_flag;
957 End If;
958 If (p_rec.no_mx_elcn_val_dfnd_flag = hr_api.g_varchar2) then
959 p_rec.no_mx_elcn_val_dfnd_flag :=
960 ben_vpf_shd.g_old_rec.no_mx_elcn_val_dfnd_flag;
961 End If;
962 If (p_rec.alwys_sum_all_cvg_flag = hr_api.g_varchar2) then
963 p_rec.alwys_sum_all_cvg_flag :=
964 ben_vpf_shd.g_old_rec.alwys_sum_all_cvg_flag;
965 End If;
966 If (p_rec.alwys_cnt_all_prtts_flag = hr_api.g_varchar2) then
967 p_rec.alwys_cnt_all_prtts_flag :=
968 ben_vpf_shd.g_old_rec.alwys_cnt_all_prtts_flag;
969 End If;
970 If (p_rec.val_calc_rl = hr_api.g_number) then
971 p_rec.val_calc_rl :=
972 ben_vpf_shd.g_old_rec.val_calc_rl;
973 End If;
974 If (p_rec.vrbl_rt_prfl_stat_cd = hr_api.g_varchar2) then
975 p_rec.vrbl_rt_prfl_stat_cd :=
976 ben_vpf_shd.g_old_rec.vrbl_rt_prfl_stat_cd;
977 End If;
978 If (p_rec.vrbl_usg_cd = hr_api.g_varchar2) then
979 p_rec.vrbl_usg_cd :=
980 ben_vpf_shd.g_old_rec.vrbl_usg_cd;
981 End If;
982 If (p_rec.asmt_to_use_cd = hr_api.g_varchar2) then
983 p_rec.asmt_to_use_cd :=
984 ben_vpf_shd.g_old_rec.asmt_to_use_cd;
985 End If;
986 If (p_rec.rndg_cd = hr_api.g_varchar2) then
987 p_rec.rndg_cd :=
988 ben_vpf_shd.g_old_rec.rndg_cd;
989 End If;
990 If (p_rec.rndg_rl = hr_api.g_number) then
991 p_rec.rndg_rl :=
992 ben_vpf_shd.g_old_rec.rndg_rl;
993 End If;
994 if (p_rec.rt_hrly_slrd_flag = hr_api.g_varchar2) then
995 p_rec.rt_hrly_slrd_flag :=
996 ben_vpf_shd.g_old_rec.rt_hrly_slrd_flag;
997 end if;
998 if (p_rec.rt_pstl_cd_flag = hr_api.g_varchar2) then
999 p_rec.rt_pstl_cd_flag :=
1000 ben_vpf_shd.g_old_rec.rt_pstl_cd_flag;
1001 end if;
1002 if (p_rec.rt_lbr_mmbr_flag = hr_api.g_varchar2) then
1003 p_rec.rt_lbr_mmbr_flag :=
1004 ben_vpf_shd.g_old_rec.rt_lbr_mmbr_flag;
1005 end if;
1006 if (p_rec.rt_lgl_enty_flag = hr_api.g_varchar2) then
1007 p_rec.rt_lgl_enty_flag :=
1008 ben_vpf_shd.g_old_rec.rt_lgl_enty_flag;
1009 end if;
1010 if (p_rec.rt_benfts_grp_flag = hr_api.g_varchar2) then
1011 p_rec.rt_benfts_grp_flag :=
1012 ben_vpf_shd.g_old_rec.rt_benfts_grp_flag;
1013 end if;
1014 if (p_rec.rt_wk_loc_flag = hr_api.g_varchar2) then
1015 p_rec.rt_wk_loc_flag :=
1016 ben_vpf_shd.g_old_rec.rt_wk_loc_flag;
1017 end if;
1018 if (p_rec.rt_brgng_unit_flag = hr_api.g_varchar2) then
1019 p_rec.rt_brgng_unit_flag :=
1020 ben_vpf_shd.g_old_rec.rt_brgng_unit_flag;
1021 end if;
1022 if (p_rec.rt_age_flag = hr_api.g_varchar2) then
1023 p_rec.rt_age_flag :=
1024 ben_vpf_shd.g_old_rec.rt_age_flag;
1025 end if;
1026 if (p_rec.rt_los_flag = hr_api.g_varchar2) then
1027 p_rec.rt_los_flag :=
1028 ben_vpf_shd.g_old_rec.rt_los_flag;
1029 end if;
1030 if (p_rec.rt_per_typ_flag = hr_api.g_varchar2) then
1031 p_rec.rt_per_typ_flag :=
1032 ben_vpf_shd.g_old_rec.rt_per_typ_flag;
1033 end if;
1034 if (p_rec.rt_fl_tm_pt_tm_flag = hr_api.g_varchar2) then
1035 p_rec.rt_fl_tm_pt_tm_flag :=
1036 ben_vpf_shd.g_old_rec.rt_fl_tm_pt_tm_flag;
1037 end if;
1038 if (p_rec.rt_ee_stat_flag = hr_api.g_varchar2) then
1039 p_rec.rt_ee_stat_flag :=
1040 ben_vpf_shd.g_old_rec.rt_ee_stat_flag;
1041 end if;
1042 if (p_rec.rt_grd_flag = hr_api.g_varchar2) then
1043 p_rec.rt_grd_flag :=
1044 ben_vpf_shd.g_old_rec.rt_grd_flag;
1045 end if;
1046 if (p_rec.rt_pct_fl_tm_flag = hr_api.g_varchar2) then
1047 p_rec.rt_pct_fl_tm_flag :=
1048 ben_vpf_shd.g_old_rec.rt_pct_fl_tm_flag;
1049 end if;
1050 if (p_rec.rt_asnt_set_flag = hr_api.g_varchar2) then
1051 p_rec.rt_asnt_set_flag :=
1052 ben_vpf_shd.g_old_rec.rt_asnt_set_flag;
1053 end if;
1054 if (p_rec.rt_hrs_wkd_flag = hr_api.g_varchar2) then
1055 p_rec.rt_hrs_wkd_flag :=
1056 ben_vpf_shd.g_old_rec.rt_hrs_wkd_flag;
1057 end if;
1058 if (p_rec.rt_comp_lvl_flag = hr_api.g_varchar2) then
1059 p_rec.rt_comp_lvl_flag :=
1060 ben_vpf_shd.g_old_rec.rt_comp_lvl_flag;
1061 end if;
1062 if (p_rec.rt_org_unit_flag = hr_api.g_varchar2) then
1063 p_rec.rt_org_unit_flag :=
1064 ben_vpf_shd.g_old_rec.rt_org_unit_flag;
1065 end if;
1066 if (p_rec.rt_loa_rsn_flag = hr_api.g_varchar2) then
1067 p_rec.rt_loa_rsn_flag :=
1068 ben_vpf_shd.g_old_rec.rt_loa_rsn_flag;
1069 end if;
1070 if (p_rec.rt_pyrl_flag = hr_api.g_varchar2) then
1071 p_rec.rt_pyrl_flag :=
1072 ben_vpf_shd.g_old_rec.rt_pyrl_flag;
1073 end if;
1074 if (p_rec.rt_schedd_hrs_flag = hr_api.g_varchar2) then
1075 p_rec.rt_schedd_hrs_flag :=
1076 ben_vpf_shd.g_old_rec.rt_schedd_hrs_flag;
1077 end if;
1078 if (p_rec.rt_py_bss_flag = hr_api.g_varchar2) then
1079 p_rec.rt_py_bss_flag :=
1080 ben_vpf_shd.g_old_rec.rt_py_bss_flag;
1081 end if;
1082 if (p_rec.rt_prfl_rl_flag = hr_api.g_varchar2) then
1083 p_rec.rt_prfl_rl_flag :=
1084 ben_vpf_shd.g_old_rec.rt_prfl_rl_flag;
1085 end if;
1086 if (p_rec.rt_cmbn_age_los_flag = hr_api.g_varchar2) then
1087 p_rec.rt_cmbn_age_los_flag :=
1088 ben_vpf_shd.g_old_rec.rt_cmbn_age_los_flag;
1089 end if;
1090 if (p_rec.rt_prtt_pl_flag = hr_api.g_varchar2) then
1091 p_rec.rt_prtt_pl_flag :=
1092 ben_vpf_shd.g_old_rec.rt_prtt_pl_flag;
1093 end if;
1094 if (p_rec.rt_svc_area_flag = hr_api.g_varchar2) then
1095 p_rec.rt_svc_area_flag :=
1096 ben_vpf_shd.g_old_rec.rt_svc_area_flag;
1097 end if;
1098 if (p_rec.rt_ppl_grp_flag = hr_api.g_varchar2) then
1099 p_rec.rt_ppl_grp_flag :=
1100 ben_vpf_shd.g_old_rec.rt_ppl_grp_flag;
1101 end if;
1102 if (p_rec.rt_dsbld_flag = hr_api.g_varchar2) then
1103 p_rec.rt_dsbld_flag :=
1104 ben_vpf_shd.g_old_rec.rt_dsbld_flag;
1105 end if;
1106 if (p_rec.rt_hlth_cvg_flag = hr_api.g_varchar2) then
1107 p_rec.rt_hlth_cvg_flag :=
1108 ben_vpf_shd.g_old_rec.rt_hlth_cvg_flag;
1109 end if;
1110 if (p_rec.rt_poe_flag = hr_api.g_varchar2) then
1111 p_rec.rt_poe_flag :=
1112 ben_vpf_shd.g_old_rec.rt_poe_flag;
1113 end if;
1114 if (p_rec.rt_ttl_cvg_vol_flag = hr_api.g_varchar2) then
1115 p_rec.rt_ttl_cvg_vol_flag :=
1116 ben_vpf_shd.g_old_rec.rt_ttl_cvg_vol_flag;
1117 end if;
1118 if (p_rec.rt_ttl_prtt_flag = hr_api.g_varchar2) then
1119 p_rec.rt_ttl_prtt_flag :=
1120 ben_vpf_shd.g_old_rec.rt_ttl_prtt_flag;
1121 end if;
1122 if (p_rec.rt_gndr_flag = hr_api.g_varchar2) then
1123 p_rec.rt_gndr_flag :=
1124 ben_vpf_shd.g_old_rec.rt_gndr_flag;
1125 end if;
1126 if (p_rec.rt_tbco_use_flag = hr_api.g_varchar2) then
1127 p_rec.rt_tbco_use_flag :=
1128 ben_vpf_shd.g_old_rec.rt_tbco_use_flag;
1129 end if;
1130 If (p_rec.vpf_attribute_category = hr_api.g_varchar2) then
1131 p_rec.vpf_attribute_category :=
1132 ben_vpf_shd.g_old_rec.vpf_attribute_category;
1133 End If;
1134 If (p_rec.vpf_attribute1 = hr_api.g_varchar2) then
1135 p_rec.vpf_attribute1 :=
1136 ben_vpf_shd.g_old_rec.vpf_attribute1;
1137 End If;
1138 If (p_rec.vpf_attribute2 = hr_api.g_varchar2) then
1139 p_rec.vpf_attribute2 :=
1140 ben_vpf_shd.g_old_rec.vpf_attribute2;
1141 End If;
1142 If (p_rec.vpf_attribute3 = hr_api.g_varchar2) then
1143 p_rec.vpf_attribute3 :=
1144 ben_vpf_shd.g_old_rec.vpf_attribute3;
1145 End If;
1146 If (p_rec.vpf_attribute4 = hr_api.g_varchar2) then
1147 p_rec.vpf_attribute4 :=
1148 ben_vpf_shd.g_old_rec.vpf_attribute4;
1149 End If;
1150 If (p_rec.vpf_attribute5 = hr_api.g_varchar2) then
1151 p_rec.vpf_attribute5 :=
1152 ben_vpf_shd.g_old_rec.vpf_attribute5;
1153 End If;
1154 If (p_rec.vpf_attribute6 = hr_api.g_varchar2) then
1155 p_rec.vpf_attribute6 :=
1156 ben_vpf_shd.g_old_rec.vpf_attribute6;
1157 End If;
1158 If (p_rec.vpf_attribute7 = hr_api.g_varchar2) then
1159 p_rec.vpf_attribute7 :=
1160 ben_vpf_shd.g_old_rec.vpf_attribute7;
1161 End If;
1162 If (p_rec.vpf_attribute8 = hr_api.g_varchar2) then
1163 p_rec.vpf_attribute8 :=
1164 ben_vpf_shd.g_old_rec.vpf_attribute8;
1165 End If;
1166 If (p_rec.vpf_attribute9 = hr_api.g_varchar2) then
1167 p_rec.vpf_attribute9 :=
1168 ben_vpf_shd.g_old_rec.vpf_attribute9;
1169 End If;
1170 If (p_rec.vpf_attribute10 = hr_api.g_varchar2) then
1171 p_rec.vpf_attribute10 :=
1172 ben_vpf_shd.g_old_rec.vpf_attribute10;
1173 End If;
1174 If (p_rec.vpf_attribute11 = hr_api.g_varchar2) then
1175 p_rec.vpf_attribute11 :=
1176 ben_vpf_shd.g_old_rec.vpf_attribute11;
1177 End If;
1178 If (p_rec.vpf_attribute12 = hr_api.g_varchar2) then
1179 p_rec.vpf_attribute12 :=
1180 ben_vpf_shd.g_old_rec.vpf_attribute12;
1181 End If;
1182 If (p_rec.vpf_attribute13 = hr_api.g_varchar2) then
1183 p_rec.vpf_attribute13 :=
1184 ben_vpf_shd.g_old_rec.vpf_attribute13;
1185 End If;
1186 If (p_rec.vpf_attribute14 = hr_api.g_varchar2) then
1187 p_rec.vpf_attribute14 :=
1188 ben_vpf_shd.g_old_rec.vpf_attribute14;
1189 End If;
1190 If (p_rec.vpf_attribute15 = hr_api.g_varchar2) then
1191 p_rec.vpf_attribute15 :=
1192 ben_vpf_shd.g_old_rec.vpf_attribute15;
1193 End If;
1194 If (p_rec.vpf_attribute16 = hr_api.g_varchar2) then
1195 p_rec.vpf_attribute16 :=
1196 ben_vpf_shd.g_old_rec.vpf_attribute16;
1197 End If;
1198 If (p_rec.vpf_attribute17 = hr_api.g_varchar2) then
1199 p_rec.vpf_attribute17 :=
1200 ben_vpf_shd.g_old_rec.vpf_attribute17;
1201 End If;
1202 If (p_rec.vpf_attribute18 = hr_api.g_varchar2) then
1203 p_rec.vpf_attribute18 :=
1204 ben_vpf_shd.g_old_rec.vpf_attribute18;
1205 End If;
1206 If (p_rec.vpf_attribute19 = hr_api.g_varchar2) then
1207 p_rec.vpf_attribute19 :=
1208 ben_vpf_shd.g_old_rec.vpf_attribute19;
1209 End If;
1210 If (p_rec.vpf_attribute20 = hr_api.g_varchar2) then
1211 p_rec.vpf_attribute20 :=
1212 ben_vpf_shd.g_old_rec.vpf_attribute20;
1213 End If;
1214 If (p_rec.vpf_attribute21 = hr_api.g_varchar2) then
1215 p_rec.vpf_attribute21 :=
1216 ben_vpf_shd.g_old_rec.vpf_attribute21;
1217 End If;
1218 If (p_rec.vpf_attribute22 = hr_api.g_varchar2) then
1219 p_rec.vpf_attribute22 :=
1220 ben_vpf_shd.g_old_rec.vpf_attribute22;
1221 End If;
1222 If (p_rec.vpf_attribute23 = hr_api.g_varchar2) then
1223 p_rec.vpf_attribute23 :=
1224 ben_vpf_shd.g_old_rec.vpf_attribute23;
1225 End If;
1226 If (p_rec.vpf_attribute24 = hr_api.g_varchar2) then
1227 p_rec.vpf_attribute24 :=
1228 ben_vpf_shd.g_old_rec.vpf_attribute24;
1229 End If;
1230 If (p_rec.vpf_attribute25 = hr_api.g_varchar2) then
1231 p_rec.vpf_attribute25 :=
1232 ben_vpf_shd.g_old_rec.vpf_attribute25;
1233 End If;
1234 If (p_rec.vpf_attribute26 = hr_api.g_varchar2) then
1235 p_rec.vpf_attribute26 :=
1236 ben_vpf_shd.g_old_rec.vpf_attribute26;
1237 End If;
1238 If (p_rec.vpf_attribute27 = hr_api.g_varchar2) then
1239 p_rec.vpf_attribute27 :=
1240 ben_vpf_shd.g_old_rec.vpf_attribute27;
1241 End If;
1242 If (p_rec.vpf_attribute28 = hr_api.g_varchar2) then
1243 p_rec.vpf_attribute28 :=
1244 ben_vpf_shd.g_old_rec.vpf_attribute28;
1245 End If;
1246 If (p_rec.vpf_attribute29 = hr_api.g_varchar2) then
1247 p_rec.vpf_attribute29 :=
1248 ben_vpf_shd.g_old_rec.vpf_attribute29;
1249 End If;
1250 If (p_rec.vpf_attribute30 = hr_api.g_varchar2) then
1251 p_rec.vpf_attribute30 :=
1252 ben_vpf_shd.g_old_rec.vpf_attribute30;
1253 End If;
1254 If (p_rec.rt_cntng_prtn_prfl_flag = hr_api.g_varchar2) then
1255 p_rec.rt_cntng_prtn_prfl_flag :=
1256 ben_vpf_shd.g_old_rec.rt_cntng_prtn_prfl_flag;
1257 End If;
1258 If (p_rec.rt_cbr_quald_bnf_flag = hr_api.g_varchar2) then
1259 p_rec.rt_cbr_quald_bnf_flag :=
1260 ben_vpf_shd.g_old_rec.rt_cbr_quald_bnf_flag;
1261 End If;
1262 If (p_rec.rt_optd_mdcr_flag = hr_api.g_varchar2 ) then
1263 p_rec.rt_optd_mdcr_flag :=
1264 ben_vpf_shd.g_old_rec.rt_optd_mdcr_flag;
1265 End If;
1266 If (p_rec.rt_lvg_rsn_flag = hr_api.g_varchar2) then
1267 p_rec.rt_lvg_rsn_flag :=
1268 ben_vpf_shd.g_old_rec.rt_lvg_rsn_flag;
1269 End If;
1270 If (p_rec.rt_pstn_flag = hr_api.g_varchar2) then
1271 p_rec.rt_pstn_flag :=
1272 ben_vpf_shd.g_old_rec.rt_pstn_flag;
1273 End If;
1274 If (p_rec.rt_comptncy_flag = hr_api.g_varchar2) then
1275 p_rec.rt_comptncy_flag :=
1276 ben_vpf_shd.g_old_rec.rt_comptncy_flag;
1277 End If;
1278 If (p_rec.rt_job_flag = hr_api.g_varchar2) then
1279 p_rec.rt_job_flag :=
1280 ben_vpf_shd.g_old_rec.rt_job_flag;
1281 End If;
1282 If (p_rec.rt_qual_titl_flag = hr_api.g_varchar2 ) then
1283 p_rec.rt_qual_titl_flag :=
1284 ben_vpf_shd.g_old_rec.rt_qual_titl_flag;
1285 End If;
1286 If (p_rec.rt_dpnt_cvrd_pl_flag = hr_api.g_varchar2) then
1287 p_rec.rt_dpnt_cvrd_pl_flag :=
1288 ben_vpf_shd.g_old_rec.rt_dpnt_cvrd_pl_flag;
1289 End If;
1290 If (p_rec.rt_dpnt_cvrd_plip_flag = hr_api.g_varchar2) then
1291 p_rec.rt_dpnt_cvrd_plip_flag :=
1292 ben_vpf_shd.g_old_rec.rt_dpnt_cvrd_plip_flag;
1293 End If;
1294 If (p_rec.rt_dpnt_cvrd_ptip_flag = hr_api.g_varchar2 ) then
1295 p_rec.rt_dpnt_cvrd_ptip_flag :=
1296 ben_vpf_shd.g_old_rec.rt_dpnt_cvrd_ptip_flag;
1297 End If;
1298 If (p_rec.rt_dpnt_cvrd_pgm_flag = hr_api.g_varchar2) then
1299 p_rec.rt_dpnt_cvrd_pgm_flag :=
1300 ben_vpf_shd.g_old_rec.rt_dpnt_cvrd_pgm_flag;
1301 End If;
1302 If (p_rec.rt_enrld_oipl_flag = hr_api.g_varchar2) then
1303 p_rec.rt_enrld_oipl_flag :=
1304 ben_vpf_shd.g_old_rec.rt_enrld_oipl_flag;
1305 End If;
1306 If (p_rec.rt_enrld_pl_flag = hr_api.g_varchar2 ) then
1307 p_rec.rt_enrld_pl_flag :=
1308 ben_vpf_shd.g_old_rec.rt_enrld_pl_flag;
1309 End If;
1310 If (p_rec.rt_enrld_plip_flag = hr_api.g_varchar2 ) then
1311 p_rec.rt_enrld_plip_flag :=
1312 ben_vpf_shd.g_old_rec.rt_enrld_plip_flag;
1313 End If;
1314 If (p_rec.rt_enrld_ptip_flag = hr_api.g_varchar2 ) then
1315 p_rec.rt_enrld_ptip_flag :=
1316 ben_vpf_shd.g_old_rec.rt_enrld_ptip_flag;
1317 End If;
1318 If (p_rec.rt_enrld_pgm_flag = hr_api.g_varchar2 ) then
1319 p_rec.rt_enrld_pgm_flag :=
1320 ben_vpf_shd.g_old_rec.rt_enrld_pgm_flag;
1321 End If;
1322 If (p_rec.rt_prtt_anthr_pl_flag = hr_api.g_varchar2 ) then
1323 p_rec.rt_prtt_anthr_pl_flag :=
1324 ben_vpf_shd.g_old_rec.rt_prtt_anthr_pl_flag;
1325 End If;
1326 If (p_rec.rt_othr_ptip_flag = hr_api.g_varchar2 ) then
1327 p_rec.rt_othr_ptip_flag :=
1328 ben_vpf_shd.g_old_rec.rt_othr_ptip_flag;
1329 End If;
1330 If (p_rec.rt_no_othr_cvg_flag = hr_api.g_varchar2 ) then
1331 p_rec.rt_no_othr_cvg_flag :=
1332 ben_vpf_shd.g_old_rec.rt_no_othr_cvg_flag;
1333 End If;
1334 If (p_rec.rt_dpnt_othr_ptip_flag = hr_api.g_varchar2 ) then
1335 p_rec.rt_dpnt_othr_ptip_flag :=
1336 ben_vpf_shd.g_old_rec.rt_dpnt_othr_ptip_flag;
1337 End If;
1338 If (p_rec.rt_qua_in_gr_flag = hr_api.g_varchar2 ) then
1339 p_rec.rt_qua_in_gr_flag :=
1340 ben_vpf_shd.g_old_rec.rt_qua_in_gr_flag;
1341 End If;
1342 If (p_rec.rt_perf_rtng_flag = hr_api.g_varchar2 ) then
1343 p_rec.rt_perf_rtng_flag :=
1344 ben_vpf_shd.g_old_rec.rt_perf_rtng_flag;
1345 End If;
1346 --
1347 If (p_rec.rt_elig_prfl_flag = hr_api.g_varchar2 ) then
1348 p_rec.rt_elig_prfl_flag :=
1349 ben_vpf_shd.g_old_rec.rt_elig_prfl_flag;
1350 End If;
1351
1352 hr_utility.set_location(' Leaving:'||l_proc, 10);
1353 --
1354 End convert_defs;
1355 --
1356 -- ----------------------------------------------------------------------------
1357 -- |---------------------------------< upd >----------------------------------|
1358 -- ----------------------------------------------------------------------------
1359 Procedure upd
1360 (
1361 p_rec in out nocopy ben_vpf_shd.g_rec_type,
1362 p_effective_date in date,
1363 p_datetrack_mode in varchar2
1364 ) is
1365 --
1366 l_proc varchar2(72) := g_package||'upd';
1367 l_validation_start_date date;
1368 l_validation_end_date date;
1369 --
1370 Begin
1371 hr_utility.set_location('Entering:'||l_proc, 5);
1372 --
1373 -- Ensure that the DateTrack update mode is valid
1374 --
1375 dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
1376 --
1377 -- We must lock the row which we need to update.
1378 --
1379 ben_vpf_shd.lck
1380 (p_effective_date => p_effective_date,
1381 p_datetrack_mode => p_datetrack_mode,
1382 p_vrbl_rt_prfl_id => p_rec.vrbl_rt_prfl_id,
1383 p_object_version_number => p_rec.object_version_number,
1384 p_validation_start_date => l_validation_start_date,
1385 p_validation_end_date => l_validation_end_date);
1386 --
1387 -- 1. During an update system defaults are used to determine if
1388 -- arguments have been defaulted or not. We must therefore
1389 -- derive the full record structure values to be updated.
1390 --
1391 -- 2. Call the supporting update validate operations.
1392 --
1393 convert_defs(p_rec);
1394 ben_vpf_bus.update_validate
1395 (p_rec => p_rec,
1396 p_effective_date => p_effective_date,
1397 p_datetrack_mode => p_datetrack_mode,
1398 p_validation_start_date => l_validation_start_date,
1399 p_validation_end_date => l_validation_end_date);
1400 --
1401 -- Call the supporting pre-update operation
1402 --
1403 pre_update
1404 (p_rec => p_rec,
1405 p_effective_date => p_effective_date,
1406 p_datetrack_mode => p_datetrack_mode,
1407 p_validation_start_date => l_validation_start_date,
1408 p_validation_end_date => l_validation_end_date);
1409 --
1410 -- Update the row.
1411 --
1412 update_dml
1413 (p_rec => p_rec,
1414 p_effective_date => p_effective_date,
1415 p_datetrack_mode => p_datetrack_mode,
1416 p_validation_start_date => l_validation_start_date,
1417 p_validation_end_date => l_validation_end_date);
1418 --
1419 -- Call the supporting post-update operation
1420 --
1421 post_update
1422 (p_rec => p_rec,
1423 p_effective_date => p_effective_date,
1424 p_datetrack_mode => p_datetrack_mode,
1425 p_validation_start_date => l_validation_start_date,
1426 p_validation_end_date => l_validation_end_date);
1427 End upd;
1428 --
1429 -- ----------------------------------------------------------------------------
1430 -- |---------------------------------< upd >----------------------------------|
1431 -- ----------------------------------------------------------------------------
1432 Procedure upd
1433 (
1434 p_vrbl_rt_prfl_id in number,
1435 p_effective_start_date out nocopy date,
1436 p_effective_end_date out nocopy date,
1437 p_pl_typ_opt_typ_id in number default hr_api.g_number,
1438 p_pl_id in number default hr_api.g_number,
1439 p_oipl_id in number default hr_api.g_number,
1440 p_comp_lvl_fctr_id in number default hr_api.g_number,
1441 p_business_group_id in number default hr_api.g_number,
1442 p_acty_typ_cd in varchar2 default hr_api.g_varchar2,
1443 p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
1444 p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
1445 p_tx_typ_cd in varchar2 default hr_api.g_varchar2,
1446 p_vrbl_rt_trtmt_cd in varchar2 default hr_api.g_varchar2,
1447 p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
1448 p_mlt_cd in varchar2 default hr_api.g_varchar2,
1449 p_incrmnt_elcn_val in number default hr_api.g_number,
1450 p_dflt_elcn_val in number default hr_api.g_number,
1451 p_mx_elcn_val in number default hr_api.g_number,
1452 p_mn_elcn_val in number default hr_api.g_number,
1453 p_lwr_lmt_val in number default hr_api.g_number,
1454 p_lwr_lmt_calc_rl in number default hr_api.g_number,
1455 p_upr_lmt_val in number default hr_api.g_number,
1456 p_upr_lmt_calc_rl in number default hr_api.g_number,
1457 p_ultmt_upr_lmt in number default hr_api.g_number,
1458 p_ultmt_lwr_lmt in number default hr_api.g_number,
1459 p_ultmt_upr_lmt_calc_rl in number default hr_api.g_number,
1460 p_ultmt_lwr_lmt_calc_rl in number default hr_api.g_number,
1461 p_ann_mn_elcn_val in number default hr_api.g_number,
1462 p_ann_mx_elcn_val in number default hr_api.g_number,
1463 p_val in number default hr_api.g_number,
1464 p_name in varchar2 default hr_api.g_varchar2,
1465 p_no_mn_elcn_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
1466 p_no_mx_elcn_val_dfnd_flag in varchar2 default hr_api.g_varchar2,
1467 p_alwys_sum_all_cvg_flag in varchar2 default hr_api.g_varchar2,
1468 p_alwys_cnt_all_prtts_flag in varchar2 default hr_api.g_varchar2,
1469 p_val_calc_rl in number default hr_api.g_number,
1470 p_vrbl_rt_prfl_stat_cd in varchar2 default hr_api.g_varchar2,
1471 p_vrbl_usg_cd in varchar2 default hr_api.g_varchar2,
1472 p_asmt_to_use_cd in varchar2 default hr_api.g_varchar2,
1473 p_rndg_cd in varchar2 default hr_api.g_varchar2,
1474 p_rndg_rl in number default hr_api.g_number,
1475 p_rt_hrly_slrd_flag in varchar2 default hr_api.g_varchar2,
1476 p_rt_pstl_cd_flag in varchar2 default hr_api.g_varchar2,
1477 p_rt_lbr_mmbr_flag in varchar2 default hr_api.g_varchar2,
1478 p_rt_lgl_enty_flag in varchar2 default hr_api.g_varchar2,
1479 p_rt_benfts_grp_flag in varchar2 default hr_api.g_varchar2,
1480 p_rt_wk_loc_flag in varchar2 default hr_api.g_varchar2,
1481 p_rt_brgng_unit_flag in varchar2 default hr_api.g_varchar2,
1482 p_rt_age_flag in varchar2 default hr_api.g_varchar2,
1483 p_rt_los_flag in varchar2 default hr_api.g_varchar2,
1484 p_rt_per_typ_flag in varchar2 default hr_api.g_varchar2,
1485 p_rt_fl_tm_pt_tm_flag in varchar2 default hr_api.g_varchar2,
1486 p_rt_ee_stat_flag in varchar2 default hr_api.g_varchar2,
1487 p_rt_grd_flag in varchar2 default hr_api.g_varchar2,
1488 p_rt_pct_fl_tm_flag in varchar2 default hr_api.g_varchar2,
1489 p_rt_asnt_set_flag in varchar2 default hr_api.g_varchar2,
1490 p_rt_hrs_wkd_flag in varchar2 default hr_api.g_varchar2,
1491 p_rt_comp_lvl_flag in varchar2 default hr_api.g_varchar2,
1492 p_rt_org_unit_flag in varchar2 default hr_api.g_varchar2,
1493 p_rt_loa_rsn_flag in varchar2 default hr_api.g_varchar2,
1494 p_rt_pyrl_flag in varchar2 default hr_api.g_varchar2,
1495 p_rt_schedd_hrs_flag in varchar2 default hr_api.g_varchar2,
1496 p_rt_py_bss_flag in varchar2 default hr_api.g_varchar2,
1497 p_rt_prfl_rl_flag in varchar2 default hr_api.g_varchar2,
1498 p_rt_cmbn_age_los_flag in varchar2 default hr_api.g_varchar2,
1499 p_rt_prtt_pl_flag in varchar2 default hr_api.g_varchar2,
1500 p_rt_svc_area_flag in varchar2 default hr_api.g_varchar2,
1501 p_rt_ppl_grp_flag in varchar2 default hr_api.g_varchar2,
1502 p_rt_dsbld_flag in varchar2 default hr_api.g_varchar2,
1503 p_rt_hlth_cvg_flag in varchar2 default hr_api.g_varchar2,
1504 p_rt_poe_flag in varchar2 default hr_api.g_varchar2,
1505 p_rt_ttl_cvg_vol_flag in varchar2 default hr_api.g_varchar2,
1506 p_rt_ttl_prtt_flag in varchar2 default hr_api.g_varchar2,
1507 p_rt_gndr_flag in varchar2 default hr_api.g_varchar2,
1508 p_rt_tbco_use_flag in varchar2 default hr_api.g_varchar2,
1509 p_vpf_attribute_category in varchar2 default hr_api.g_varchar2,
1510 p_vpf_attribute1 in varchar2 default hr_api.g_varchar2,
1511 p_vpf_attribute2 in varchar2 default hr_api.g_varchar2,
1512 p_vpf_attribute3 in varchar2 default hr_api.g_varchar2,
1513 p_vpf_attribute4 in varchar2 default hr_api.g_varchar2,
1514 p_vpf_attribute5 in varchar2 default hr_api.g_varchar2,
1515 p_vpf_attribute6 in varchar2 default hr_api.g_varchar2,
1516 p_vpf_attribute7 in varchar2 default hr_api.g_varchar2,
1517 p_vpf_attribute8 in varchar2 default hr_api.g_varchar2,
1518 p_vpf_attribute9 in varchar2 default hr_api.g_varchar2,
1519 p_vpf_attribute10 in varchar2 default hr_api.g_varchar2,
1520 p_vpf_attribute11 in varchar2 default hr_api.g_varchar2,
1521 p_vpf_attribute12 in varchar2 default hr_api.g_varchar2,
1522 p_vpf_attribute13 in varchar2 default hr_api.g_varchar2,
1523 p_vpf_attribute14 in varchar2 default hr_api.g_varchar2,
1524 p_vpf_attribute15 in varchar2 default hr_api.g_varchar2,
1525 p_vpf_attribute16 in varchar2 default hr_api.g_varchar2,
1526 p_vpf_attribute17 in varchar2 default hr_api.g_varchar2,
1527 p_vpf_attribute18 in varchar2 default hr_api.g_varchar2,
1528 p_vpf_attribute19 in varchar2 default hr_api.g_varchar2,
1529 p_vpf_attribute20 in varchar2 default hr_api.g_varchar2,
1530 p_vpf_attribute21 in varchar2 default hr_api.g_varchar2,
1531 p_vpf_attribute22 in varchar2 default hr_api.g_varchar2,
1532 p_vpf_attribute23 in varchar2 default hr_api.g_varchar2,
1533 p_vpf_attribute24 in varchar2 default hr_api.g_varchar2,
1534 p_vpf_attribute25 in varchar2 default hr_api.g_varchar2,
1535 p_vpf_attribute26 in varchar2 default hr_api.g_varchar2,
1536 p_vpf_attribute27 in varchar2 default hr_api.g_varchar2,
1537 p_vpf_attribute28 in varchar2 default hr_api.g_varchar2,
1538 p_vpf_attribute29 in varchar2 default hr_api.g_varchar2,
1539 p_vpf_attribute30 in varchar2 default hr_api.g_varchar2,
1540 p_object_version_number in out nocopy number,
1541 p_effective_date in date,
1542 p_datetrack_mode in varchar2 ,
1543 p_rt_cntng_prtn_prfl_flag in varchar2 default hr_api.g_varchar2,
1544 p_rt_cbr_quald_bnf_flag in varchar2 default hr_api.g_varchar2,
1545 p_rt_optd_mdcr_flag in varchar2 default hr_api.g_varchar2,
1546 p_rt_lvg_rsn_flag in varchar2 default hr_api.g_varchar2,
1547 p_rt_pstn_flag in varchar2 default hr_api.g_varchar2,
1548 p_rt_comptncy_flag in varchar2 default hr_api.g_varchar2,
1549 p_rt_job_flag in varchar2 default hr_api.g_varchar2,
1550 p_rt_qual_titl_flag in varchar2 default hr_api.g_varchar2,
1551 p_rt_dpnt_cvrd_pl_flag in varchar2 default hr_api.g_varchar2,
1552 p_rt_dpnt_cvrd_plip_flag in varchar2 default hr_api.g_varchar2,
1553 p_rt_dpnt_cvrd_ptip_flag in varchar2 default hr_api.g_varchar2,
1554 p_rt_dpnt_cvrd_pgm_flag in varchar2 default hr_api.g_varchar2,
1555 p_rt_enrld_oipl_flag in varchar2 default hr_api.g_varchar2,
1556 p_rt_enrld_pl_flag in varchar2 default hr_api.g_varchar2,
1557 p_rt_enrld_plip_flag in varchar2 default hr_api.g_varchar2,
1558 p_rt_enrld_ptip_flag in varchar2 default hr_api.g_varchar2,
1559 p_rt_enrld_pgm_flag in varchar2 default hr_api.g_varchar2,
1560 p_rt_prtt_anthr_pl_flag in varchar2 default hr_api.g_varchar2,
1561 p_rt_othr_ptip_flag in varchar2 default hr_api.g_varchar2,
1562 p_rt_no_othr_cvg_flag in varchar2 default hr_api.g_varchar2,
1563 p_rt_dpnt_othr_ptip_flag in varchar2 default hr_api.g_varchar2,
1564 p_rt_qua_in_gr_flag in varchar2 default hr_api.g_varchar2,
1565 p_rt_perf_rtng_flag in varchar2 default hr_api.g_varchar2,
1566 p_rt_elig_prfl_flag in varchar2 default hr_api.g_varchar2
1567 ) is
1568 --
1569 l_rec ben_vpf_shd.g_rec_type;
1570 l_proc varchar2(72) := g_package||'upd';
1571 --
1572 Begin
1573 hr_utility.set_location('Entering:'||l_proc, 5);
1574 --
1575 -- Call conversion function to turn arguments into the
1576 -- l_rec structure.
1577 --
1578 l_rec :=
1579 ben_vpf_shd.convert_args
1580 (
1581 p_vrbl_rt_prfl_id,
1582 null,
1583 null,
1584 p_pl_typ_opt_typ_id,
1585 p_pl_id,
1586 p_oipl_id,
1587 p_comp_lvl_fctr_id,
1588 p_business_group_id,
1589 p_acty_typ_cd,
1590 p_rt_typ_cd,
1591 p_bnft_rt_typ_cd,
1592 p_tx_typ_cd,
1593 p_vrbl_rt_trtmt_cd,
1594 p_acty_ref_perd_cd,
1595 p_mlt_cd,
1596 p_incrmnt_elcn_val,
1597 p_dflt_elcn_val,
1598 p_mx_elcn_val,
1599 p_mn_elcn_val,
1600 p_lwr_lmt_val,
1601 p_lwr_lmt_calc_rl,
1602 p_upr_lmt_val,
1603 p_upr_lmt_calc_rl,
1604 p_ultmt_upr_lmt,
1605 p_ultmt_lwr_lmt,
1606 p_ultmt_upr_lmt_calc_rl,
1607 p_ultmt_lwr_lmt_calc_rl,
1608 p_ann_mn_elcn_val,
1609 p_ann_mx_elcn_val,
1610 p_val,
1611 p_name,
1612 p_no_mn_elcn_val_dfnd_flag,
1613 p_no_mx_elcn_val_dfnd_flag,
1614 p_alwys_sum_all_cvg_flag,
1615 p_alwys_cnt_all_prtts_flag,
1616 p_val_calc_rl,
1617 p_vrbl_rt_prfl_stat_cd,
1618 p_vrbl_usg_cd,
1619 p_asmt_to_use_cd,
1620 p_rndg_cd,
1621 p_rndg_rl,
1622 p_rt_hrly_slrd_flag,
1623 p_rt_pstl_cd_flag,
1624 p_rt_lbr_mmbr_flag,
1625 p_rt_lgl_enty_flag,
1626 p_rt_benfts_grp_flag,
1627 p_rt_wk_loc_flag,
1628 p_rt_brgng_unit_flag,
1629 p_rt_age_flag,
1630 p_rt_los_flag,
1631 p_rt_per_typ_flag,
1632 p_rt_fl_tm_pt_tm_flag,
1633 p_rt_ee_stat_flag,
1634 p_rt_grd_flag,
1635 p_rt_pct_fl_tm_flag,
1636 p_rt_asnt_set_flag,
1637 p_rt_hrs_wkd_flag,
1638 p_rt_comp_lvl_flag,
1639 p_rt_org_unit_flag,
1640 p_rt_loa_rsn_flag,
1641 p_rt_pyrl_flag,
1642 p_rt_schedd_hrs_flag,
1643 p_rt_py_bss_flag,
1644 p_rt_prfl_rl_flag,
1645 p_rt_cmbn_age_los_flag,
1646 p_rt_prtt_pl_flag,
1647 p_rt_svc_area_flag,
1648 p_rt_ppl_grp_flag,
1649 p_rt_dsbld_flag,
1650 p_rt_hlth_cvg_flag,
1651 p_rt_poe_flag,
1652 p_rt_ttl_cvg_vol_flag,
1653 p_rt_ttl_prtt_flag,
1654 p_rt_gndr_flag,
1655 p_rt_tbco_use_flag,
1656 p_vpf_attribute_category,
1657 p_vpf_attribute1,
1658 p_vpf_attribute2,
1659 p_vpf_attribute3,
1660 p_vpf_attribute4,
1661 p_vpf_attribute5,
1662 p_vpf_attribute6,
1663 p_vpf_attribute7,
1664 p_vpf_attribute8,
1665 p_vpf_attribute9,
1666 p_vpf_attribute10,
1667 p_vpf_attribute11,
1668 p_vpf_attribute12,
1669 p_vpf_attribute13,
1670 p_vpf_attribute14,
1671 p_vpf_attribute15,
1672 p_vpf_attribute16,
1673 p_vpf_attribute17,
1674 p_vpf_attribute18,
1675 p_vpf_attribute19,
1676 p_vpf_attribute20,
1677 p_vpf_attribute21,
1678 p_vpf_attribute22,
1679 p_vpf_attribute23,
1680 p_vpf_attribute24,
1681 p_vpf_attribute25,
1682 p_vpf_attribute26,
1683 p_vpf_attribute27,
1684 p_vpf_attribute28,
1685 p_vpf_attribute29,
1686 p_vpf_attribute30,
1687 p_object_version_number,
1688 p_rt_cntng_prtn_prfl_flag,
1689 p_rt_cbr_quald_bnf_flag,
1690 p_rt_optd_mdcr_flag,
1691 p_rt_lvg_rsn_flag,
1692 p_rt_pstn_flag,
1693 p_rt_comptncy_flag,
1694 p_rt_job_flag,
1695 p_rt_qual_titl_flag,
1696 p_rt_dpnt_cvrd_pl_flag ,
1697 p_rt_dpnt_cvrd_plip_flag,
1698 p_rt_dpnt_cvrd_ptip_flag,
1699 p_rt_dpnt_cvrd_pgm_flag,
1700 p_rt_enrld_oipl_flag,
1701 p_rt_enrld_pl_flag,
1702 p_rt_enrld_plip_flag,
1703 p_rt_enrld_ptip_flag,
1704 p_rt_enrld_pgm_flag,
1705 p_rt_prtt_anthr_pl_flag,
1706 p_rt_othr_ptip_flag,
1707 p_rt_no_othr_cvg_flag,
1708 p_rt_dpnt_othr_ptip_flag,
1709 p_rt_qua_in_gr_flag,
1710 p_rt_perf_rtng_flag,
1711 p_rt_elig_prfl_flag
1712 );
1713 --
1714 -- Having converted the arguments into the
1715 -- plsql record structure we call the corresponding record
1716 -- business process.
1717 --
1718 upd(l_rec, p_effective_date, p_datetrack_mode);
1719 p_object_version_number := l_rec.object_version_number;
1720 p_effective_start_date := l_rec.effective_start_date;
1721 p_effective_end_date := l_rec.effective_end_date;
1722 --
1723 --
1724 hr_utility.set_location(' Leaving:'||l_proc, 10);
1725 End upd;
1726 --
1727 end ben_vpf_upd;