[Home] [Help]
PACKAGE BODY: APPS.BEN_PLN_SHD
Source
1 Package Body ben_pln_shd as
2 /* $Header: beplnrhi.pkb 120.8.12010000.2 2008/08/18 09:47:19 ubhat ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ben_pln_shd.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------< return_api_dml_status >-------------------------|
12 -- ----------------------------------------------------------------------------
13 Function return_api_dml_status Return Boolean Is
14 --
15 l_proc varchar2(72) := g_package||'return_api_dml_status';
16 --
17 Begin
18 hr_utility.set_location('Entering:'||l_proc, 5);
19 --
20 Return (nvl(g_api_dml, false));
21 --
22 hr_utility.set_location(' Leaving:'||l_proc, 10);
23 End return_api_dml_status;
24 --
25 -- ----------------------------------------------------------------------------
26 -- |---------------------------< constraint_error >---------------------------|
27 -- ----------------------------------------------------------------------------
28 Procedure constraint_error
29 (p_constraint_name in all_constraints.constraint_name%TYPE) Is
30 --
31 l_proc varchar2(72) := g_package||'constraint_error';
32 --
33 Begin
34 hr_utility.set_location('Entering:'||l_proc, 5);
35 --
36 If (p_constraint_name = 'BEN_PL_FK1') Then
37 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38 fnd_message.set_token('PROCEDURE', l_proc);
39 fnd_message.set_token('STEP','5');
40 fnd_message.raise_error;
41 ElsIf (p_constraint_name = 'BEN_PL_F_PK') Then
42 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43 fnd_message.set_token('PROCEDURE', l_proc);
44 fnd_message.set_token('STEP','10');
45 fnd_message.raise_error;
46 Else
47 fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
48 fnd_message.set_token('PROCEDURE', l_proc);
49 fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
50 fnd_message.raise_error;
51 End If;
52 --
53 hr_utility.set_location(' Leaving:'||l_proc, 10);
54 End constraint_error;
55 --
56 -- ----------------------------------------------------------------------------
57 -- |-----------------------------< api_updating >-----------------------------|
58 -- ----------------------------------------------------------------------------
59 Function api_updating
60 (p_effective_date in date,
61 p_pl_id in number,
62 p_object_version_number in number
63 ) Return Boolean Is
64 --
65 --
66 -- Cursor selects the 'current' row from the HR Schema
67 --
68 cursor c_sel1 is
69 select
70 pl_id
71 ,effective_start_date
72 ,effective_end_date
73 ,name
74 ,alws_qdro_flag
75 ,alws_qmcso_flag
76 ,alws_reimbmts_flag
77 ,bnf_addl_instn_txt_alwd_flag
78 ,bnf_adrs_rqd_flag
79 ,bnf_cntngt_bnfs_alwd_flag
80 ,bnf_ctfn_rqd_flag
81 ,bnf_dob_rqd_flag
82 ,bnf_dsge_mnr_ttee_rqd_flag
83 ,bnf_incrmt_amt
84 ,bnf_dflt_bnf_cd
85 ,bnf_legv_id_rqd_flag
86 ,bnf_may_dsgt_org_flag
87 ,bnf_mn_dsgntbl_amt
88 ,bnf_mn_dsgntbl_pct_val
89 ,rqd_perd_enrt_nenrt_val
90 ,ordr_num
91 ,bnf_pct_incrmt_val
92 ,bnf_pct_amt_alwd_cd
93 ,bnf_qdro_rl_apls_flag
94 ,dflt_to_asn_pndg_ctfn_cd
95 ,dflt_to_asn_pndg_ctfn_rl
96 ,drvbl_fctr_apls_rts_flag
97 ,drvbl_fctr_prtn_elig_flag
98 ,dpnt_dsgn_cd
99 ,elig_apls_flag
100 ,invk_dcln_prtn_pl_flag
101 ,invk_flx_cr_pl_flag
102 ,imptd_incm_calc_cd
103 ,drvbl_dpnt_elig_flag
104 ,trk_inelig_per_flag
105 ,pl_cd
106 ,auto_enrt_mthd_rl
107 ,ivr_ident
108 ,url_ref_name
109 ,cmpr_clms_to_cvg_or_bal_cd
110 ,cobra_pymt_due_dy_num
111 ,dpnt_cvd_by_othr_apls_flag
112 ,enrt_mthd_cd
113 ,enrt_cd
114 ,enrt_cvg_strt_dt_cd
115 ,enrt_cvg_end_dt_cd
116 ,frfs_aply_flag
117 ,hc_pl_subj_hcfa_aprvl_flag
118 ,hghly_cmpd_rl_apls_flag
119 ,incptn_dt
120 ,mn_cvg_rl
121 ,mn_cvg_rqd_amt
122 ,mn_opts_rqd_num
123 ,mx_cvg_alwd_amt
124 ,mx_cvg_rl
125 ,mx_opts_alwd_num
126 ,mx_cvg_wcfn_mlt_num
127 ,mx_cvg_wcfn_amt
128 ,mx_cvg_incr_alwd_amt
129 ,mx_cvg_incr_wcf_alwd_amt
130 ,mx_cvg_mlt_incr_num
131 ,mx_cvg_mlt_incr_wcf_num
132 ,mx_wtg_dt_to_use_cd
133 ,mx_wtg_dt_to_use_rl
134 ,mx_wtg_perd_prte_uom
135 ,mx_wtg_perd_prte_val
136 ,mx_wtg_perd_rl
137 ,nip_dflt_enrt_cd
138 ,nip_dflt_enrt_det_rl
139 ,dpnt_adrs_rqd_flag
140 ,dpnt_cvg_end_dt_cd
141 ,dpnt_cvg_end_dt_rl
142 ,dpnt_cvg_strt_dt_cd
143 ,dpnt_cvg_strt_dt_rl
144 ,dpnt_dob_rqd_flag
145 ,dpnt_leg_id_rqd_flag
146 ,dpnt_no_ctfn_rqd_flag
147 ,no_mn_cvg_amt_apls_flag
148 ,no_mn_cvg_incr_apls_flag
149 ,no_mn_opts_num_apls_flag
150 ,no_mx_cvg_amt_apls_flag
151 ,no_mx_cvg_incr_apls_flag
152 ,no_mx_opts_num_apls_flag
153 ,nip_pl_uom
154 ,rqd_perd_enrt_nenrt_uom
155 ,nip_acty_ref_perd_cd
156 ,nip_enrt_info_rt_freq_cd
157 ,per_cvrd_cd
158 ,enrt_cvg_end_dt_rl
159 ,postelcn_edit_rl
160 ,enrt_cvg_strt_dt_rl
161 ,prort_prtl_yr_cvg_rstrn_cd
162 ,prort_prtl_yr_cvg_rstrn_rl
163 ,prtn_elig_ovrid_alwd_flag
164 ,svgs_pl_flag
165 ,subj_to_imptd_incm_typ_cd
166 ,use_all_asnts_elig_flag
167 ,use_all_asnts_for_rt_flag
168 ,vstg_apls_flag
169 ,wvbl_flag
170 ,hc_svc_typ_cd
171 ,pl_stat_cd
172 ,prmry_fndg_mthd_cd
173 ,rt_end_dt_cd
174 ,rt_end_dt_rl
175 ,rt_strt_dt_rl
176 ,rt_strt_dt_cd
177 ,bnf_dsgn_cd
178 ,pl_typ_id
179 ,business_group_id
180 ,enrt_pl_opt_flag
181 ,bnft_prvdr_pool_id
182 ,may_enrl_pl_n_oipl_flag
183 ,enrt_rl
184 ,rqd_perd_enrt_nenrt_rl
185 ,alws_unrstrctd_enrt_flag
186 ,bnft_or_option_rstrctn_cd
187 ,cvg_incr_r_decr_only_cd
188 ,unsspnd_enrt_cd
189 ,pln_attribute_category
190 ,pln_attribute1
191 ,pln_attribute2
192 ,pln_attribute3
193 ,pln_attribute4
194 ,pln_attribute5
195 ,pln_attribute6
196 ,pln_attribute7
197 ,pln_attribute8
198 ,pln_attribute9
199 ,pln_attribute10
200 ,pln_attribute11
201 ,pln_attribute12
202 ,pln_attribute13
203 ,pln_attribute14
204 ,pln_attribute15
205 ,pln_attribute16
206 ,pln_attribute17
207 ,pln_attribute18
208 ,pln_attribute19
209 ,pln_attribute20
210 ,pln_attribute21
211 ,pln_attribute22
212 ,pln_attribute23
213 ,pln_attribute24
214 ,pln_attribute25
215 ,pln_attribute26
216 ,pln_attribute27
217 ,pln_attribute28
218 ,pln_attribute29
219 ,pln_attribute30
220 ,susp_if_ctfn_not_prvd_flag
221 ,ctfn_determine_cd
222 ,susp_if_dpnt_ssn_nt_prv_cd
223 ,susp_if_dpnt_dob_nt_prv_cd
224 ,susp_if_dpnt_adr_nt_prv_cd
225 ,susp_if_ctfn_not_dpnt_flag
226 ,susp_if_bnf_ssn_nt_prv_cd
227 ,susp_if_bnf_dob_nt_prv_cd
228 ,susp_if_bnf_adr_nt_prv_cd
229 ,susp_if_ctfn_not_bnf_flag
230 ,dpnt_ctfn_determine_cd
231 ,bnf_ctfn_determine_cd
232 ,last_update_date
233 ,last_updated_by
234 ,last_update_login
235 ,created_by
236 ,creation_date
237 ,object_version_number
238 ,actl_prem_id
239 ,vrfy_fmly_mmbr_cd
240 ,vrfy_fmly_mmbr_rl
241 ,alws_tmpry_id_crd_flag
242 ,nip_dflt_flag
243 ,frfs_distr_mthd_cd
244 ,frfs_distr_mthd_rl
245 ,frfs_cntr_det_cd
246 ,frfs_distr_det_cd
247 ,cost_alloc_keyflex_1_id
248 ,cost_alloc_keyflex_2_id
249 ,post_to_gl_flag
250 ,frfs_val_det_cd
251 ,frfs_mx_cryfwd_val
252 ,frfs_portion_det_cd
253 ,bndry_perd_cd
254 ,short_name
255 ,short_code
256 ,legislation_code
257 ,legislation_subgroup
258 ,group_pl_id
259 ,mapping_table_name
260 ,mapping_table_pk_id
261 ,function_code
262 ,pl_yr_not_applcbl_flag
263 ,use_csd_rsd_prccng_cd
264 from ben_pl_f
265 where pl_id = p_pl_id
266 and p_effective_date
267 between effective_start_date and effective_end_date;
268 --
269 l_proc varchar2(72) := g_package||'api_updating';
270 l_fct_ret boolean;
271 --
272 Begin
273 hr_utility.set_location('Entering:'||l_proc, 5);
274 --
275 If (p_effective_date is null or
276 p_pl_id is null or
277 p_object_version_number is null) Then
278 --
279 -- One of the primary key arguments is null therefore we must
280 -- set the returning function value to false
281 --
282 l_fct_ret := false;
283 Else
284 If (p_pl_id = g_old_rec.pl_id and
285 p_object_version_number = g_old_rec.object_version_number) Then
286 hr_utility.set_location(l_proc, 10);
287 --
288 -- The g_old_rec is current therefore we must
289 -- set the returning function to true
290 --
291 l_fct_ret := true;
292 Else
293 --
294 -- Select the current row
295 --
296 Open C_Sel1;
297 Fetch C_Sel1 Into g_old_rec;
298 If C_Sel1%notfound Then
299 Close C_Sel1;
300 --
301 -- The primary key is invalid therefore we must error
302 --
303 fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
304 fnd_message.raise_error;
305 End If;
306 Close C_Sel1;
307 If (p_object_version_number <> g_old_rec.object_version_number) Then
308 fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
309 fnd_message.raise_error;
310 End If;
311 hr_utility.set_location(l_proc, 15);
312 l_fct_ret := true;
313 End If;
314 End If;
315 hr_utility.set_location(' Leaving:'||l_proc, 20);
316 Return (l_fct_ret);
317 --
318 End api_updating;
319 --
320 -- ----------------------------------------------------------------------------
321 -- |--------------------------< find_dt_del_modes >---------------------------|
322 -- ----------------------------------------------------------------------------
323 --
324 Procedure find_dt_del_modes
325 (p_effective_date in date,
326 p_base_key_value in number,
327 p_zap out nocopy boolean,
328 p_delete out nocopy boolean,
329 p_future_change out nocopy boolean,
330 p_delete_next_change out nocopy boolean) is
331 --
332 l_proc varchar2(72) := g_package||'find_dt_del_modes';
333 --
334 l_parent_key_value1 number;
335 l_parent_key_value2 number;
336 l_parent_key_value3 number;
337 l_parent_key_value4 number;
338 l_parent_key_value5 number;
339 l_parent_key_value6 number;
340 l_parent_key_value7 number;
341 l_parent_key_value8 number;
342 l_parent_key_value9 number;
343 l_parent_key_value10 number;
344 l_parent_key_value11 number;
345 l_parent_key_value12 number;
346 l_parent_key_value13 number;
347 l_parent_key_value14 number;
348 l_parent_key_value15 number;
349 l_parent_key_value16 number;
350 l_zap boolean;
351 l_zap1 boolean;
352 l_delete boolean;
353 l_delete1 boolean;
354 l_future_change boolean;
355 l_future_change1 boolean;
356 l_delete_next_change boolean;
357 l_delete_next_change1 boolean;
358 --
359 Cursor C_Sel1 Is
360 select t.dflt_to_asn_pndg_ctfn_rl,
361 t.auto_enrt_mthd_rl,
362 t.mn_cvg_rl,
363 t.mx_cvg_rl,
364 t.mx_wtg_dt_to_use_rl,
365 t.nip_dflt_enrt_det_rl,
366 t.dpnt_cvg_end_dt_rl,
367 t.dpnt_cvg_strt_dt_rl,
368 t.enrt_cvg_end_dt_rl,
369 t.postelcn_edit_rl,
370 t.enrt_cvg_strt_dt_rl,
371 t.prort_prtl_yr_cvg_rstrn_rl,
372 t.rt_end_dt_rl,
373 t.rt_strt_dt_rl,
374 t.pl_typ_id,
375 t.actl_prem_id
376 from ben_pl_f t
377 where t.pl_id = p_base_key_value
378 and p_effective_date
379 between t.effective_start_date and t.effective_end_date;
380 --
381 Begin
382 hr_utility.set_location('Entering:'||l_proc, 5);
383 Open C_Sel1;
384 Fetch C_Sel1 Into l_parent_key_value1,
385 l_parent_key_value2,
386 l_parent_key_value3,
387 l_parent_key_value4,
388 l_parent_key_value5,
389 l_parent_key_value6,
390 l_parent_key_value7,
391 l_parent_key_value8,
392 l_parent_key_value9,
393 l_parent_key_value10,
394 l_parent_key_value11,
395 l_parent_key_value12,
396 l_parent_key_value13,
397 l_parent_key_value14,
398 l_parent_key_value15,
399 l_parent_key_value16;
400 If C_Sel1%notfound then
401 Close C_Sel1;
402 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
403 fnd_message.set_token('PROCEDURE', l_proc);
404 fnd_message.set_token('STEP','10');
405 fnd_message.raise_error;
406 End If;
407 Close C_Sel1;
408 --
409 -- Call the corresponding datetrack api
410 --
411 dt_api.find_dt_del_modes
412 (p_effective_date => p_effective_date,
413 p_base_table_name => 'ben_pl_f',
414 p_base_key_column => 'pl_id',
415 p_base_key_value => p_base_key_value,
416 p_parent_table_name1 => 'ff_formulas_f',
417 p_parent_key_column1 => 'formula_id',
418 p_parent_key_value1 => l_parent_key_value1,
419 p_parent_table_name2 => 'ff_formulas_f',
420 p_parent_key_column2 => 'formula_id',
421 p_parent_key_value2 => l_parent_key_value2,
422 p_parent_table_name3 => 'ff_formulas_f',
423 p_parent_key_column3 => 'formula_id',
424 p_parent_key_value3 => l_parent_key_value3,
425 p_parent_table_name4 => 'ff_formulas_f',
426 p_parent_key_column4 => 'formula_id',
427 p_parent_key_value4 => l_parent_key_value4,
428 p_parent_table_name5 => 'ff_formulas_f',
429 p_parent_key_column5 => 'formula_id',
430 p_parent_key_value5 => l_parent_key_value5,
431 p_parent_table_name6 => 'ff_formulas_f',
432 p_parent_key_column6 => 'formula_id',
433 p_parent_key_value6 => l_parent_key_value6,
434 p_parent_table_name7 => 'ff_formulas_f',
435 p_parent_key_column7 => 'formula_id',
436 p_parent_key_value7 => l_parent_key_value7,
437 p_parent_table_name8 => 'ff_formulas_f',
438 p_parent_key_column8 => 'formula_id',
439 p_parent_key_value8 => l_parent_key_value8,
440 p_parent_table_name9 => 'ff_formulas_f',
441 p_parent_key_column9 => 'formula_id',
442 p_parent_key_value9 => l_parent_key_value9,
443 p_parent_table_name10 => 'ff_formulas_f',
444 p_parent_key_column10 => 'formula_id',
445 p_parent_key_value10 => l_parent_key_value10,
446 p_zap => l_zap,
447 p_delete => l_delete,
448 p_future_change => l_future_change,
449 p_delete_next_change => l_delete_next_change);
450 --
451 dt_api.find_dt_del_modes
452 (p_effective_date => p_effective_date,
453 p_base_table_name => 'ben_pl_f',
454 p_base_key_column => 'pl_id',
455 p_base_key_value => p_base_key_value,
456 p_parent_table_name1 => 'ff_formulas_f',
460 p_parent_key_column2 => 'formula_id',
457 p_parent_key_column1 => 'formula_id',
458 p_parent_key_value1 => l_parent_key_value11,
459 p_parent_table_name2 => 'ff_formulas_f',
461 p_parent_key_value2 => l_parent_key_value12,
462 p_parent_table_name3 => 'ff_formulas_f',
463 p_parent_key_column3 => 'formula_id',
464 p_parent_key_value3 => l_parent_key_value13,
465 p_parent_table_name4 => 'ff_formulas_f',
466 p_parent_key_column4 => 'formula_id',
467 p_parent_key_value4 => l_parent_key_value14,
468 p_parent_table_name5 => 'ben_pl_typ_f', -- Bug : 3658243 Corrected Arguments
469 p_parent_key_column5 => 'pl_typ_id',
470 p_parent_key_value5 => l_parent_key_value15,
471 -- p_parent_table_name6 => 'ben_pl_typ_f',
472 -- p_parent_key_column6 => 'pl_typ_id',
473 -- p_parent_key_value6 => l_parent_key_value16,
474 -- p_parent_table_name7 => 'ben_actl_prem_f',
475 -- p_parent_key_column7 => 'actl_prem_id',
476 -- p_parent_key_value7 => l_parent_key_value16,
477 p_zap => l_zap1,
478 p_delete => l_delete1,
479 p_future_change => l_future_change1,
480 p_delete_next_change => l_delete_next_change1);
481 --
482 if l_zap and l_zap1 then
483 --
484 p_zap := true;
485 --
486 else
487 --
488 p_zap := false;
489 --
490 end if;
491 --
492 if l_delete and l_delete1 then
493 --
494 p_delete := true;
495 --
496 else
497 --
498 p_delete := false;
499 --
500 end if;
501 --
502 if l_future_change and l_future_change1 then
503 --
504 p_future_change := true;
505 --
506 else
507 --
508 p_future_change := false;
509 --
510 end if;
511 --
512 if l_delete_next_change and l_delete_next_change1 then
513 --
514 p_delete_next_change := true;
515 --
516 else
517 --
518 p_delete_next_change := false;
519 --
520 end if;
521 --
522 hr_utility.set_location(' Leaving:'||l_proc, 10);
523 End find_dt_del_modes;
524 --
525 -- ----------------------------------------------------------------------------
526 -- |--------------------------< find_dt_upd_modes >---------------------------|
527 -- ----------------------------------------------------------------------------
528 --
529 Procedure find_dt_upd_modes
530 (p_effective_date in date,
531 p_base_key_value in number,
532 p_correction out nocopy boolean,
533 p_update out nocopy boolean,
534 p_update_override out nocopy boolean,
535 p_update_change_insert out nocopy boolean) is
536 --
537 l_proc varchar2(72) := g_package||'find_dt_upd_modes';
538 --
539 Begin
540 hr_utility.set_location('Entering:'||l_proc, 5);
541 --
542 -- Call the corresponding datetrack api
543 --
544 dt_api.find_dt_upd_modes
545 (p_effective_date => p_effective_date,
546 p_base_table_name => 'ben_pl_f',
547 p_base_key_column => 'pl_id',
548 p_base_key_value => p_base_key_value,
549 p_correction => p_correction,
550 p_update => p_update,
551 p_update_override => p_update_override,
552 p_update_change_insert => p_update_change_insert);
553 --
554 hr_utility.set_location(' Leaving:'||l_proc, 10);
555 End find_dt_upd_modes;
556 --
557 -- ----------------------------------------------------------------------------
558 -- |------------------------< upd_effective_end_date >------------------------|
559 -- ----------------------------------------------------------------------------
560 --
561 Procedure upd_effective_end_date
562 (p_effective_date in date,
563 p_base_key_value in number,
564 p_new_effective_end_date in date,
565 p_validation_start_date in date,
566 p_validation_end_date in date,
567 p_object_version_number out nocopy number) is
568 --
569 l_proc varchar2(72) := g_package||'upd_effective_end_date';
570 l_object_version_number number;
571 --
572 Begin
573 hr_utility.set_location('Entering:'||l_proc, 5);
574 --
575 -- Because we are updating a row we must get the next object
576 -- version number.
577 --
578 l_object_version_number :=
579 dt_api.get_object_version_number
580 (p_base_table_name => 'ben_pl_f',
581 p_base_key_column => 'pl_id',
582 p_base_key_value => p_base_key_value);
583 --
584 hr_utility.set_location(l_proc, 10);
585 g_api_dml := true; -- Set the api dml status
586 --
587 -- Update the specified datetrack row setting the effective
588 -- end date to the specified new effective end date.
589 --
590 update ben_pl_f t
591 set t.effective_end_date = p_new_effective_end_date,
592 t.object_version_number = l_object_version_number
593 where t.pl_id = p_base_key_value
594 and p_effective_date
595 between t.effective_start_date and t.effective_end_date;
596 --
597 g_api_dml := false; -- Unset the api dml status
598 p_object_version_number := l_object_version_number;
599 hr_utility.set_location(' Leaving:'||l_proc, 15);
600 --
604 Raise;
601 Exception
602 When Others Then
603 g_api_dml := false; -- Unset the api dml status
605 End upd_effective_end_date;
606 --
607 -- ----------------------------------------------------------------------------
608 -- |---------------------------------< lck >----------------------------------|
609 -- ----------------------------------------------------------------------------
610 --
611 Procedure lck
612 (p_effective_date in date,
613 p_datetrack_mode in varchar2,
614 p_pl_id in number,
615 p_object_version_number in number,
616 p_validation_start_date out nocopy date,
617 p_validation_end_date out nocopy date) is
618 --
619 l_proc varchar2(72) := g_package||'lck';
620 l_validation_start_date date;
621 l_validation_end_date date;
622 l_validation_start_date1 date;
623 l_validation_end_date1 date;
624 l_validation_start_date2 date;
625 l_validation_end_date2 date;
626 l_object_invalid exception;
627 l_argument varchar2(30);
628 --
629 -- Cursor C_Sel1 selects the current locked row as of session date
630 -- ensuring that the object version numbers match.
631 --
632 cursor c_sel1 is
633 select
634 pl_id
635 ,effective_start_date
636 ,effective_end_date
637 ,name
638 ,alws_qdro_flag
639 ,alws_qmcso_flag
640 ,alws_reimbmts_flag
641 ,bnf_addl_instn_txt_alwd_flag
642 ,bnf_adrs_rqd_flag
643 ,bnf_cntngt_bnfs_alwd_flag
644 ,bnf_ctfn_rqd_flag
645 ,bnf_dob_rqd_flag
646 ,bnf_dsge_mnr_ttee_rqd_flag
647 ,bnf_incrmt_amt
648 ,bnf_dflt_bnf_cd
649 ,bnf_legv_id_rqd_flag
650 ,bnf_may_dsgt_org_flag
651 ,bnf_mn_dsgntbl_amt
652 ,bnf_mn_dsgntbl_pct_val
653 ,rqd_perd_enrt_nenrt_val
654 ,ordr_num
655 ,bnf_pct_incrmt_val
656 ,bnf_pct_amt_alwd_cd
657 ,bnf_qdro_rl_apls_flag
658 ,dflt_to_asn_pndg_ctfn_cd
659 ,dflt_to_asn_pndg_ctfn_rl
660 ,drvbl_fctr_apls_rts_flag
661 ,drvbl_fctr_prtn_elig_flag
662 ,dpnt_dsgn_cd
663 ,elig_apls_flag
664 ,invk_dcln_prtn_pl_flag
665 ,invk_flx_cr_pl_flag
666 ,imptd_incm_calc_cd
667 ,drvbl_dpnt_elig_flag
668 ,trk_inelig_per_flag
669 ,pl_cd
670 ,auto_enrt_mthd_rl
671 ,ivr_ident
672 ,url_ref_name
673 ,cmpr_clms_to_cvg_or_bal_cd
674 ,cobra_pymt_due_dy_num
675 ,dpnt_cvd_by_othr_apls_flag
676 ,enrt_mthd_cd
677 ,enrt_cd
678 ,enrt_cvg_strt_dt_cd
679 ,enrt_cvg_end_dt_cd
680 ,frfs_aply_flag
681 ,hc_pl_subj_hcfa_aprvl_flag
682 ,hghly_cmpd_rl_apls_flag
683 ,incptn_dt
684 ,mn_cvg_rl
685 ,mn_cvg_rqd_amt
686 ,mn_opts_rqd_num
687 ,mx_cvg_alwd_amt
688 ,mx_cvg_rl
689 ,mx_opts_alwd_num
690 ,mx_cvg_wcfn_mlt_num
691 ,mx_cvg_wcfn_amt
692 ,mx_cvg_incr_alwd_amt
693 ,mx_cvg_incr_wcf_alwd_amt
694 ,mx_cvg_mlt_incr_num
695 ,mx_cvg_mlt_incr_wcf_num
696 ,mx_wtg_dt_to_use_cd
697 ,mx_wtg_dt_to_use_rl
698 ,mx_wtg_perd_prte_uom
699 ,mx_wtg_perd_prte_val
700 ,mx_wtg_perd_rl
701 ,nip_dflt_enrt_cd
702 ,nip_dflt_enrt_det_rl
703 ,dpnt_adrs_rqd_flag
704 ,dpnt_cvg_end_dt_cd
705 ,dpnt_cvg_end_dt_rl
706 ,dpnt_cvg_strt_dt_cd
707 ,dpnt_cvg_strt_dt_rl
708 ,dpnt_dob_rqd_flag
709 ,dpnt_leg_id_rqd_flag
710 ,dpnt_no_ctfn_rqd_flag
711 ,no_mn_cvg_amt_apls_flag
712 ,no_mn_cvg_incr_apls_flag
713 ,no_mn_opts_num_apls_flag
714 ,no_mx_cvg_amt_apls_flag
715 ,no_mx_cvg_incr_apls_flag
716 ,no_mx_opts_num_apls_flag
717 ,nip_pl_uom
718 ,rqd_perd_enrt_nenrt_uom
719 ,nip_acty_ref_perd_cd
720 ,nip_enrt_info_rt_freq_cd
721 ,per_cvrd_cd
722 ,enrt_cvg_end_dt_rl
723 ,postelcn_edit_rl
724 ,enrt_cvg_strt_dt_rl
725 ,prort_prtl_yr_cvg_rstrn_cd
726 ,prort_prtl_yr_cvg_rstrn_rl
727 ,prtn_elig_ovrid_alwd_flag
728 ,svgs_pl_flag
729 ,subj_to_imptd_incm_typ_cd
730 ,use_all_asnts_elig_flag
731 ,use_all_asnts_for_rt_flag
732 ,vstg_apls_flag
733 ,wvbl_flag
734 ,hc_svc_typ_cd
735 ,pl_stat_cd
736 ,prmry_fndg_mthd_cd
737 ,rt_end_dt_cd
738 ,rt_end_dt_rl
739 ,rt_strt_dt_rl
740 ,rt_strt_dt_cd
741 ,bnf_dsgn_cd
742 ,pl_typ_id
743 ,business_group_id
744 ,enrt_pl_opt_flag
745 ,bnft_prvdr_pool_id
746 ,may_enrl_pl_n_oipl_flag
747 ,enrt_rl
748 ,rqd_perd_enrt_nenrt_rl
749 ,alws_unrstrctd_enrt_flag
750 ,bnft_or_option_rstrctn_cd
751 ,cvg_incr_r_decr_only_cd
752 ,unsspnd_enrt_cd
753 ,pln_attribute_category
754 ,pln_attribute1
755 ,pln_attribute2
756 ,pln_attribute3
757 ,pln_attribute4
758 ,pln_attribute5
759 ,pln_attribute6
760 ,pln_attribute7
761 ,pln_attribute8
762 ,pln_attribute9
763 ,pln_attribute10
764 ,pln_attribute11
765 ,pln_attribute12
769 ,pln_attribute16
766 ,pln_attribute13
767 ,pln_attribute14
768 ,pln_attribute15
770 ,pln_attribute17
771 ,pln_attribute18
772 ,pln_attribute19
773 ,pln_attribute20
774 ,pln_attribute21
775 ,pln_attribute22
776 ,pln_attribute23
777 ,pln_attribute24
778 ,pln_attribute25
779 ,pln_attribute26
780 ,pln_attribute27
781 ,pln_attribute28
782 ,pln_attribute29
783 ,pln_attribute30
784 ,susp_if_ctfn_not_prvd_flag
785 ,ctfn_determine_cd
786 ,susp_if_dpnt_ssn_nt_prv_cd
787 ,susp_if_dpnt_dob_nt_prv_cd
788 ,susp_if_dpnt_adr_nt_prv_cd
789 ,susp_if_ctfn_not_dpnt_flag
790 ,susp_if_bnf_ssn_nt_prv_cd
791 ,susp_if_bnf_dob_nt_prv_cd
792 ,susp_if_bnf_adr_nt_prv_cd
793 ,susp_if_ctfn_not_bnf_flag
794 ,dpnt_ctfn_determine_cd
795 ,bnf_ctfn_determine_cd
796 ,last_update_date
797 ,last_updated_by
798 ,last_update_login
799 ,created_by
800 ,creation_date
801 ,object_version_number
802 ,actl_prem_id
803 ,vrfy_fmly_mmbr_cd
804 ,vrfy_fmly_mmbr_rl
805 ,alws_tmpry_id_crd_flag
806 ,nip_dflt_flag
807 ,frfs_distr_mthd_cd
808 ,frfs_distr_mthd_rl
809 ,frfs_cntr_det_cd
810 ,frfs_distr_det_cd
811 ,cost_alloc_keyflex_1_id
812 ,cost_alloc_keyflex_2_id
813 ,post_to_gl_flag
814 ,frfs_val_det_cd
815 ,frfs_mx_cryfwd_val
816 ,frfs_portion_det_cd
817 ,bndry_perd_cd
818 ,short_name
819 ,short_code
820 ,legislation_code
821 ,legislation_subgroup
822 ,group_pl_id
823 ,mapping_table_name
824 ,mapping_table_pk_id
825 ,function_code
826 ,pl_yr_not_applcbl_flag
827 ,use_csd_rsd_prccng_cd
828 from ben_pl_f
829 where pl_id = p_pl_id
830 and p_effective_date
831 between effective_start_date and effective_end_date ;
832 -- for update nowait;
833 --
834 --
835 --
836 Begin
837 hr_utility.set_location('Entering:'||l_proc, 5);
838 --
839 -- Ensure that all the mandatory arguments are not null
840 --
841 hr_api.mandatory_arg_error(p_api_name => l_proc,
842 p_argument => 'effective_date',
843 p_argument_value => p_effective_date);
844 --
845 hr_api.mandatory_arg_error(p_api_name => l_proc,
846 p_argument => 'datetrack_mode',
847 p_argument_value => p_datetrack_mode);
848 --
849 hr_api.mandatory_arg_error(p_api_name => l_proc,
850 p_argument => 'pl_id',
851 p_argument_value => p_pl_id);
852 --
853 hr_api.mandatory_arg_error(p_api_name => l_proc,
854 p_argument => 'object_version_number',
855 p_argument_value => p_object_version_number);
856 --
857 -- Check to ensure the datetrack mode is not INSERT.
858 --
859 If (p_datetrack_mode <> 'INSERT') then
860 --
861 -- We must select and lock the current row.
862 --
863 Open C_Sel1;
864 Fetch C_Sel1 Into g_old_rec;
865 If C_Sel1%notfound then
866 hr_utility.set_location('no record found', 5);
867 Close C_Sel1;
868 --
869 -- The primary key is invalid therefore we must error
870 --
871 fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
872 fnd_message.raise_error;
873 End If;
874 Close C_Sel1;
875 If (p_object_version_number <> g_old_rec.object_version_number) Then
876 fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
877 fnd_message.raise_error;
878 End If;
879 hr_utility.set_location(l_proc, 15);
880 --
881 -- Validate the datetrack mode mode getting the validation start
882 -- and end dates for the specified datetrack operation.
883 --
884 dt_api.validate_dt_mode
885 (p_effective_date => p_effective_date,
886 p_datetrack_mode => p_datetrack_mode,
887 p_base_table_name => 'ben_pl_f',
888 p_base_key_column => 'pl_id',
889 p_base_key_value => p_pl_id,
890 p_parent_table_name1 => 'ff_formulas_f',
891 p_parent_key_column1 => 'formula_id',
892 p_parent_key_value1 => g_old_rec.dflt_to_asn_pndg_ctfn_rl,
893 p_parent_table_name2 => 'ff_formulas_f',
894 p_parent_key_column2 => 'formula_id',
895 p_parent_key_value2 => g_old_rec.auto_enrt_mthd_rl,
896 p_parent_table_name3 => 'ff_formulas_f',
897 p_parent_key_column3 => 'formula_id',
898 p_parent_key_value3 => g_old_rec.mn_cvg_rl,
899 p_parent_table_name4 => 'ff_formulas_f',
900 p_parent_key_column4 => 'formula_id',
901 p_parent_key_value4 => g_old_rec.mx_cvg_rl,
902 p_parent_table_name5 => 'ff_formulas_f',
903 p_parent_key_column5 => 'formula_id',
904 p_parent_key_value5 => g_old_rec.mx_wtg_dt_to_use_rl,
905 p_parent_table_name7 => 'ff_formulas_f',
906 p_parent_key_column7 => 'formula_id',
907 p_parent_key_value7 => g_old_rec.nip_dflt_enrt_det_rl,
908 p_parent_table_name8 => 'ff_formulas_f',
912 p_parent_key_column9 => 'formula_id',
909 p_parent_key_column8 => 'formula_id',
910 p_parent_key_value8 => g_old_rec.dpnt_cvg_end_dt_rl,
911 p_parent_table_name9 => 'ff_formulas_f',
913 p_parent_key_value9 => g_old_rec.dpnt_cvg_strt_dt_rl,
914 p_parent_table_name10 => 'ff_formulas_f',
915 p_parent_key_column10 => 'formula_id',
916 p_parent_key_value10 => g_old_rec.enrt_cvg_end_dt_rl,
917 -- p_child_table_name1 => 'ben_pl_regy_bod_f',
918 -- p_child_key_column1 => 'pl_regy_bod_id',
919 -- p_child_table_name2 => 'ben_drvbl_fctr_uom',
920 -- p_child_key_column2 => 'drvbl_fctr_uom_id',
921 -- p_child_table_name3 => 'ben_oipl_f',
922 -- p_child_key_column3 => 'oipl_id',
923 -- p_child_table_name4 => 'ben_popl_enrt_typ_cycl_f',
924 -- p_child_key_column4 => 'popl_enrt_typ_cycl_id',
925 -- p_child_table_name5 => 'ben_vald_rlshp_for_reimb_f',
926 -- p_child_key_column5 => 'vald_rlshp_for_reimb_id',
927 -- p_child_table_name6 => 'ben_ler_chg_pl_nip_enrt_f',
928 -- p_child_key_column6 => 'ler_chg_pl_nip_enrt_id',
929 -- p_child_table_name7 => 'ben_pl_gd_or_svc_f',
930 -- p_child_key_column7 => 'pl_gd_or_svc_id',
931 -- p_child_table_name8 => 'ben_plip_f',
932 -- p_child_key_column8 => 'plip_id',
933 -- p_child_table_name9 => 'ben_dsgn_rqmt_f',
934 -- p_child_key_column9 => 'dsgn_rqmt_id',
935 -- p_child_table_name10 => 'ben_pl_regn_f',
936 -- p_child_key_column10 => 'pl_regn_id',
937 p_enforce_foreign_locking => false , --true,
938 p_validation_start_date => l_validation_start_date,
939 p_validation_end_date => l_validation_end_date);
940 --
941 dt_api.validate_dt_mode
942 (p_effective_date => p_effective_date,
943 p_datetrack_mode => p_datetrack_mode,
944 p_base_table_name => 'ben_pl_f',
945 p_base_key_column => 'pl_id',
946 p_base_key_value => p_pl_id,
947 p_parent_table_name1 => 'ff_formulas_f',
948 p_parent_key_column1 => 'formula_id',
949 p_parent_key_value1 => g_old_rec.postelcn_edit_rl,
950 p_parent_table_name2 => 'ff_formulas_f',
951 p_parent_key_column2 => 'formula_id',
952 p_parent_key_value2 => g_old_rec.enrt_cvg_strt_dt_rl,
953 p_parent_table_name3 => 'ff_formulas_f',
954 p_parent_key_column3 => 'formula_id',
955 p_parent_key_value3 => g_old_rec.prort_prtl_yr_cvg_rstrn_rl,
956 p_parent_table_name4 => 'ff_formulas_f',
957 p_parent_key_column4 => 'formula_id',
958 p_parent_key_value4 => g_old_rec.rt_end_dt_rl,
959 p_parent_table_name5 => 'ff_formulas_f',
960 p_parent_key_column5 => 'formula_id',
961 p_parent_key_value5 => g_old_rec.rt_strt_dt_rl,
962 p_parent_table_name6 => 'ben_pl_typ_f',
963 p_parent_key_column6 => 'pl_typ_id',
964 p_parent_key_value6 => g_old_rec.pl_typ_id,
965 p_parent_table_name7 => 'ben_bnft_prvdr_pool_f',
966 p_parent_key_column7 => 'bnft_prvdr_pool_id',
967 p_parent_key_value7 => g_old_rec.bnft_prvdr_pool_id,
968 p_parent_table_name8 => 'ff_formulas_f',
969 p_parent_key_column8 => 'formula_id',
970 p_parent_key_value8 => g_old_rec.ENRT_RL,
971 -- p_child_table_name2 => 'ben_prtn_elig_f',
972 -- p_child_key_column2 => 'prtn_elig_id',
973 -- p_child_table_name3 => 'ben_cvg_amt_calc_mthd_f',
974 -- p_child_key_column3 => 'cvg_amt_calc_mthd_id',
975 -- p_child_table_name4 => 'ben_ler_chg_dpnt_cvg_f',
976 -- p_child_key_column4 => 'ler_chg_dpnt_cvg_id',
977 -- p_child_table_name5 => 'ben_popl_org_f',
978 -- p_child_key_column5 => 'popl_org_id',
979 -- p_child_table_name6 => 'ben_elig_per_f',
980 -- p_child_key_column6 => 'elig_per_id',
981 -- p_child_table_name7 => 'ben_elig_prtt_anthr_pl_prte_f',
982 -- p_child_key_column7 => 'elig_prtt_anthr_pl_prte_id',
983 -- p_child_table_name8 => 'ben_pl_r_oipl_asset_f',
984 -- p_child_key_column8 => 'pl_r_oipl_asset_id',
985 p_enforce_foreign_locking => false , --true,
986 p_validation_start_date => l_validation_start_date1,
987 p_validation_end_date => l_validation_end_date1);
988 --
989 dt_api.validate_dt_mode
990 (p_effective_date => p_effective_date,
991 p_datetrack_mode => p_datetrack_mode,
992 p_base_table_name => 'ben_pl_f',
993 p_base_key_column => 'pl_id',
994 p_base_key_value => p_pl_id,
995 -- p_child_table_name1 => 'ben_acty_base_rt_f',
996 -- p_child_key_column1 => 'acty_base_rt_id',
997 -- p_child_table_name2 => 'ben_pl_dpnt_cvg_ctfn_f',
998 -- p_child_key_column2 => 'pl_dpnt_cvg_ctfn_id',
999 -- p_child_table_name3 => 'ben_pl_bnf_ctfn_f',
1000 -- p_child_key_column3 => 'pl_bnf_ctfn_id',
1001 -- p_child_table_name4 => 'ben_popl_rptg_grp_f',
1002 -- p_child_key_column4 => 'popl_rptg_grp_id',
1003 -- p_child_table_name5 => 'ben_prtt_reimbmt_rqst_f',
1004 -- p_child_key_column5 => 'prtt_reimbmt_rqst_id',
1005 -- p_child_table_name6 => 'ben_apld_dpnt_cvg_elig_prfl_f',
1009 -- p_child_table_name8 => 'ben_vrbl_rt_prfl_f',
1006 -- p_child_key_column6 => 'apld_dpnt_cvg_elig_prfl_id',
1007 -- p_child_table_name7 => 'ben_prtt_enrt_rslt_f',
1008 -- p_child_key_column7 => 'prtt_enrt_rslt_id',
1010 -- p_child_key_column8 => 'vrbl_rt_prfl_id',
1011 -- p_child_table_name9 => 'ben_wv_prtn_rsn_pl_f',
1012 -- p_child_key_column9 => 'wv_prtn_rsn_pl_id',
1013 p_enforce_foreign_locking => false , --true,
1014 p_validation_start_date => l_validation_start_date2,
1015 p_validation_end_date => l_validation_end_date2);
1016 --
1017 Else
1018 --
1019 -- We are doing a datetrack 'INSERT' which is illegal within this
1020 -- procedure therefore we must error (note: to lck on insert the
1021 -- private procedure ins_lck should be called).
1022 --
1023 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1024 fnd_message.set_token('PROCEDURE', l_proc);
1025 fnd_message.set_token('STEP','20');
1026 fnd_message.raise_error;
1027 End If;
1028 --
1029 -- Set the validation start and end date OUT arguments
1030 --
1031 if l_validation_start_date > l_validation_start_date1 then
1032 --
1033 if l_validation_start_date2 > l_validation_start_date then
1034 --
1035 p_validation_start_date := l_validation_start_date2;
1036 --
1037 else
1038 --
1039 p_validation_start_date := l_validation_start_date;
1040 --
1041 end if;
1042 --
1043 else
1044 --
1045 if l_validation_start_date2 > l_validation_start_date1 then
1046 --
1047 p_validation_start_date := l_validation_start_date2;
1048 --
1049 else
1050 --
1051 p_validation_start_date := l_validation_start_date1;
1052 --
1053 end if;
1054 --
1055 end if;
1056 --
1057 if l_validation_end_date > l_validation_end_date1 then
1058 --
1059 if l_validation_end_date2 > l_validation_end_date then
1060 --
1061 p_validation_end_date := l_validation_end_date2;
1062 --
1063 else
1064 --
1065 p_validation_end_date := l_validation_end_date;
1066 --
1067 end if;
1068 --
1069 else
1070 --
1071 if l_validation_end_date2 > l_validation_end_date1 then
1072 --
1073 p_validation_end_date := l_validation_end_date2;
1074 --
1075 else
1076 --
1077 p_validation_end_date := l_validation_end_date1;
1078 --
1079 end if;
1080 --
1081 end if;
1082 --
1083 hr_utility.set_location(' Leaving:'||l_proc, 30);
1084 --
1085 -- We need to trap the ORA LOCK exception
1086 --
1087 Exception
1088 When HR_Api.Object_Locked then
1089 --
1090 -- The object is locked therefore we need to supply a meaningful
1091 -- error message.
1092 --
1093 fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1094 fnd_message.set_token('TABLE_NAME', 'ben_pl_f');
1095 fnd_message.raise_error;
1096 When l_object_invalid then
1097 --
1098 -- The object doesn't exist or is invalid
1099 --
1100 fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
1101 fnd_message.set_token('TABLE_NAME', 'ben_pl_f');
1102 fnd_message.raise_error;
1103 End lck;
1104 -- ----------------------------------------------------------------------------
1105 -- |-----------------------------< convert_args >-----------------------------|
1106 -- ----------------------------------------------------------------------------
1107 --
1108 function convert_args
1109 (p_pl_id in number
1110 ,p_effective_start_date in date
1111 ,p_effective_end_date in date
1112 ,p_name in varchar2
1113 ,p_alws_qdro_flag in varchar2
1114 ,p_alws_qmcso_flag in varchar2
1115 ,p_alws_reimbmts_flag in varchar2
1116 ,p_bnf_addl_instn_txt_alwd_flag in varchar2
1117 ,p_bnf_adrs_rqd_flag in varchar2
1118 ,p_bnf_cntngt_bnfs_alwd_flag in varchar2
1119 ,p_bnf_ctfn_rqd_flag in varchar2
1120 ,p_bnf_dob_rqd_flag in varchar2
1121 ,p_bnf_dsge_mnr_ttee_rqd_flag in varchar2
1122 ,p_bnf_incrmt_amt in number
1123 ,p_bnf_dflt_bnf_cd in varchar2
1124 ,p_bnf_legv_id_rqd_flag in varchar2
1125 ,p_bnf_may_dsgt_org_flag in varchar2
1126 ,p_bnf_mn_dsgntbl_amt in number
1127 ,p_bnf_mn_dsgntbl_pct_val in number
1128 ,p_rqd_perd_enrt_nenrt_val in number
1129 ,p_ordr_num in number
1130 ,p_bnf_pct_incrmt_val in number
1131 ,p_bnf_pct_amt_alwd_cd in varchar2
1132 ,p_bnf_qdro_rl_apls_flag in varchar2
1133 ,p_dflt_to_asn_pndg_ctfn_cd in varchar2
1134 ,p_dflt_to_asn_pndg_ctfn_rl in number
1135 ,p_drvbl_fctr_apls_rts_flag in varchar2
1136 ,p_drvbl_fctr_prtn_elig_flag in varchar2
1137 ,p_dpnt_dsgn_cd in varchar2
1138 ,p_elig_apls_flag in varchar2
1139 ,p_invk_dcln_prtn_pl_flag in varchar2
1140 ,p_invk_flx_cr_pl_flag in varchar2
1141 ,p_imptd_incm_calc_cd in varchar2
1145 ,p_auto_enrt_mthd_rl in number
1142 ,p_drvbl_dpnt_elig_flag in varchar2
1143 ,p_trk_inelig_per_flag in varchar2
1144 ,p_pl_cd in varchar2
1146 ,p_ivr_ident in varchar2
1147 ,p_url_ref_name in varchar2
1148 ,p_cmpr_clms_to_cvg_or_bal_cd in varchar2
1149 ,p_cobra_pymt_due_dy_num in number
1150 ,p_dpnt_cvd_by_othr_apls_flag in varchar2
1151 ,p_enrt_mthd_cd in varchar2
1152 ,p_enrt_cd in varchar2
1153 ,p_enrt_cvg_strt_dt_cd in varchar2
1154 ,p_enrt_cvg_end_dt_cd in varchar2
1155 ,p_frfs_aply_flag in varchar2
1156 ,p_hc_pl_subj_hcfa_aprvl_flag in varchar2
1157 ,p_hghly_cmpd_rl_apls_flag in varchar2
1158 ,p_incptn_dt in date
1159 ,p_mn_cvg_rl in number
1160 ,p_mn_cvg_rqd_amt in number
1161 ,p_mn_opts_rqd_num in number
1162 ,p_mx_cvg_alwd_amt in number
1163 ,p_mx_cvg_rl in number
1164 ,p_mx_opts_alwd_num in number
1165 ,p_mx_cvg_wcfn_mlt_num in number
1166 ,p_mx_cvg_wcfn_amt in number
1167 ,p_mx_cvg_incr_alwd_amt in number
1168 ,p_mx_cvg_incr_wcf_alwd_amt in number
1169 ,p_mx_cvg_mlt_incr_num in number
1170 ,p_mx_cvg_mlt_incr_wcf_num in number
1171 ,p_mx_wtg_dt_to_use_cd in varchar2
1172 ,p_mx_wtg_dt_to_use_rl in number
1173 ,p_mx_wtg_perd_prte_uom in varchar2
1174 ,p_mx_wtg_perd_prte_val in number
1175 ,p_mx_wtg_perd_rl in number
1176 ,p_nip_dflt_enrt_cd in varchar2
1177 ,p_nip_dflt_enrt_det_rl in number
1178 ,p_dpnt_adrs_rqd_flag in varchar2
1179 ,p_dpnt_cvg_end_dt_cd in varchar2
1180 ,p_dpnt_cvg_end_dt_rl in number
1181 ,p_dpnt_cvg_strt_dt_cd in varchar2
1182 ,p_dpnt_cvg_strt_dt_rl in number
1183 ,p_dpnt_dob_rqd_flag in varchar2
1184 ,p_dpnt_leg_id_rqd_flag in varchar2
1185 ,p_dpnt_no_ctfn_rqd_flag in varchar2
1186 ,p_no_mn_cvg_amt_apls_flag in varchar2
1187 ,p_no_mn_cvg_incr_apls_flag in varchar2
1188 ,p_no_mn_opts_num_apls_flag in varchar2
1189 ,p_no_mx_cvg_amt_apls_flag in varchar2
1190 ,p_no_mx_cvg_incr_apls_flag in varchar2
1191 ,p_no_mx_opts_num_apls_flag in varchar2
1192 ,p_nip_pl_uom in varchar2
1193 ,p_rqd_perd_enrt_nenrt_uom in varchar2
1194 ,p_nip_acty_ref_perd_cd in varchar2
1195 ,p_nip_enrt_info_rt_freq_cd in varchar2
1196 ,p_per_cvrd_cd in varchar2
1197 ,p_enrt_cvg_end_dt_rl in number
1198 ,p_postelcn_edit_rl in number
1199 ,p_enrt_cvg_strt_dt_rl in number
1200 ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2
1201 ,p_prort_prtl_yr_cvg_rstrn_rl in number
1202 ,p_prtn_elig_ovrid_alwd_flag in varchar2
1203 ,p_svgs_pl_flag in varchar2
1204 ,p_subj_to_imptd_incm_typ_cd in varchar2
1205 ,p_use_all_asnts_elig_flag in varchar2
1206 ,p_use_all_asnts_for_rt_flag in varchar2
1207 ,p_vstg_apls_flag in varchar2
1208 ,p_wvbl_flag in varchar2
1209 ,p_hc_svc_typ_cd in varchar2
1210 ,p_pl_stat_cd in varchar2
1211 ,p_prmry_fndg_mthd_cd in varchar2
1212 ,p_rt_end_dt_cd in varchar2
1213 ,p_rt_end_dt_rl in number
1214 ,p_rt_strt_dt_rl in number
1215 ,p_rt_strt_dt_cd in varchar2
1216 ,p_bnf_dsgn_cd in varchar2
1217 ,p_pl_typ_id in number
1218 ,p_business_group_id in number
1219 ,p_enrt_pl_opt_flag in varchar2
1220 ,p_bnft_prvdr_pool_id in number
1221 ,p_may_enrl_pl_n_oipl_flag in varchar2
1222 ,p_enrt_rl in number
1223 ,p_rqd_perd_enrt_nenrt_rl in number
1224 ,p_alws_unrstrctd_enrt_flag in varchar2
1225 ,p_bnft_or_option_rstrctn_cd in varchar2
1226 ,p_cvg_incr_r_decr_only_cd in varchar2
1227 ,p_unsspnd_enrt_cd in varchar2
1228 ,p_pln_attribute_category in varchar2
1229 ,p_pln_attribute1 in varchar2
1230 ,p_pln_attribute2 in varchar2
1231 ,p_pln_attribute3 in varchar2
1232 ,p_pln_attribute4 in varchar2
1233 ,p_pln_attribute5 in varchar2
1234 ,p_pln_attribute6 in varchar2
1235 ,p_pln_attribute7 in varchar2
1236 ,p_pln_attribute8 in varchar2
1237 ,p_pln_attribute9 in varchar2
1238 ,p_pln_attribute10 in varchar2
1239 ,p_pln_attribute11 in varchar2
1240 ,p_pln_attribute12 in varchar2
1241 ,p_pln_attribute13 in varchar2
1242 ,p_pln_attribute14 in varchar2
1243 ,p_pln_attribute15 in varchar2
1244 ,p_pln_attribute16 in varchar2
1245 ,p_pln_attribute17 in varchar2
1246 ,p_pln_attribute18 in varchar2
1247 ,p_pln_attribute19 in varchar2
1248 ,p_pln_attribute20 in varchar2
1249 ,p_pln_attribute21 in varchar2
1250 ,p_pln_attribute22 in varchar2
1254 ,p_pln_attribute26 in varchar2
1251 ,p_pln_attribute23 in varchar2
1252 ,p_pln_attribute24 in varchar2
1253 ,p_pln_attribute25 in varchar2
1255 ,p_pln_attribute27 in varchar2
1256 ,p_pln_attribute28 in varchar2
1257 ,p_pln_attribute29 in varchar2
1258 ,p_pln_attribute30 in varchar2
1259 ,p_susp_if_ctfn_not_prvd_flag in varchar2
1260 ,p_ctfn_determine_cd in varchar2
1261 ,p_susp_if_dpnt_ssn_nt_prv_cd in varchar2
1262 ,p_susp_if_dpnt_dob_nt_prv_cd in varchar2
1263 ,p_susp_if_dpnt_adr_nt_prv_cd in varchar2
1264 ,p_susp_if_ctfn_not_dpnt_flag in varchar2
1265 ,p_susp_if_bnf_ssn_nt_prv_cd in varchar2
1266 ,p_susp_if_bnf_dob_nt_prv_cd in varchar2
1267 ,p_susp_if_bnf_adr_nt_prv_cd in varchar2
1268 ,p_susp_if_ctfn_not_bnf_flag in varchar2
1269 ,p_dpnt_ctfn_determine_cd in varchar2
1270 ,p_bnf_ctfn_determine_cd in varchar2
1271 ,p_object_version_number in number
1272 ,p_actl_prem_id in number
1273 ,p_vrfy_fmly_mmbr_cd in varchar2
1274 ,p_vrfy_fmly_mmbr_rl in number
1275 ,p_alws_tmpry_id_crd_flag in varchar2
1276 ,p_nip_dflt_flag in varchar2
1277 ,p_frfs_distr_mthd_cd in varchar2
1278 ,p_frfs_distr_mthd_rl in number
1279 ,p_frfs_cntr_det_cd in varchar2
1280 ,p_frfs_distr_det_cd in varchar2
1281 ,p_cost_alloc_keyflex_1_id in number
1282 ,p_cost_alloc_keyflex_2_id in number
1283 ,p_post_to_gl_flag in varchar2
1284 ,p_frfs_val_det_cd in varchar2
1285 ,p_frfs_mx_cryfwd_val in number
1286 ,p_frfs_portion_det_cd in varchar2
1287 ,p_bndry_perd_cd in varchar2
1288 ,p_short_name in varchar2
1289 ,p_short_code in varchar2
1290 ,p_legislation_code in varchar2
1291 ,p_legislation_subgroup in varchar2
1292 ,p_group_pl_id in number
1293 ,p_mapping_table_name in varchar2
1294 ,p_mapping_table_pk_id in number
1295 ,p_function_code in varchar2
1296 ,p_pl_yr_not_applcbl_flag in varchar2
1297 ,p_use_csd_rsd_prccng_cd in varchar2
1298
1299 )
1300 Return g_rec_type is
1301 --
1302 l_rec g_rec_type;
1303 l_proc varchar2(72) := g_package||'convert_args';
1304 --
1305 Begin
1306 --
1307 hr_utility.set_location('Entering:'||l_proc, 5);
1308 --
1309 -- Convert arguments into local l_rec structure.
1310 --
1311 l_rec.pl_id := p_pl_id;
1312 l_rec.effective_start_date := p_effective_start_date;
1313 l_rec.effective_end_date := p_effective_end_date;
1314 l_rec.name := p_name;
1315 l_rec.alws_qdro_flag := p_alws_qdro_flag;
1316 l_rec.alws_qmcso_flag := p_alws_qmcso_flag;
1317 l_rec.alws_reimbmts_flag := p_alws_reimbmts_flag;
1318 l_rec.bnf_addl_instn_txt_alwd_flag := p_bnf_addl_instn_txt_alwd_flag;
1319 l_rec.bnf_adrs_rqd_flag := p_bnf_adrs_rqd_flag;
1320 l_rec.bnf_cntngt_bnfs_alwd_flag := p_bnf_cntngt_bnfs_alwd_flag;
1321 l_rec.bnf_ctfn_rqd_flag := p_bnf_ctfn_rqd_flag;
1322 l_rec.bnf_dob_rqd_flag := p_bnf_dob_rqd_flag;
1323 l_rec.bnf_dsge_mnr_ttee_rqd_flag := p_bnf_dsge_mnr_ttee_rqd_flag;
1324 l_rec.bnf_incrmt_amt := p_bnf_incrmt_amt;
1325 l_rec.bnf_dflt_bnf_cd := p_bnf_dflt_bnf_cd;
1326 l_rec.bnf_legv_id_rqd_flag := p_bnf_legv_id_rqd_flag;
1327 l_rec.bnf_may_dsgt_org_flag := p_bnf_may_dsgt_org_flag;
1328 l_rec.bnf_mn_dsgntbl_amt := p_bnf_mn_dsgntbl_amt;
1329 l_rec.bnf_mn_dsgntbl_pct_val := p_bnf_mn_dsgntbl_pct_val;
1330 l_rec.rqd_perd_enrt_nenrt_val := p_rqd_perd_enrt_nenrt_val;
1331 l_rec.ordr_num := p_ordr_num;
1332 l_rec.bnf_pct_incrmt_val := p_bnf_pct_incrmt_val;
1333 l_rec.bnf_pct_amt_alwd_cd := p_bnf_pct_amt_alwd_cd;
1334 l_rec.bnf_qdro_rl_apls_flag := p_bnf_qdro_rl_apls_flag;
1335 l_rec.dflt_to_asn_pndg_ctfn_cd := p_dflt_to_asn_pndg_ctfn_cd;
1336 l_rec.dflt_to_asn_pndg_ctfn_rl := p_dflt_to_asn_pndg_ctfn_rl;
1337 l_rec.drvbl_fctr_apls_rts_flag := p_drvbl_fctr_apls_rts_flag;
1338 l_rec.drvbl_fctr_prtn_elig_flag := p_drvbl_fctr_prtn_elig_flag;
1339 l_rec.dpnt_dsgn_cd := p_dpnt_dsgn_cd;
1340 l_rec.elig_apls_flag := p_elig_apls_flag;
1341 l_rec.invk_dcln_prtn_pl_flag := p_invk_dcln_prtn_pl_flag;
1342 l_rec.invk_flx_cr_pl_flag := p_invk_flx_cr_pl_flag;
1343 l_rec.imptd_incm_calc_cd := p_imptd_incm_calc_cd;
1344 l_rec.drvbl_dpnt_elig_flag := p_drvbl_dpnt_elig_flag;
1345 l_rec.trk_inelig_per_flag := p_trk_inelig_per_flag;
1346 l_rec.pl_cd := p_pl_cd;
1347 l_rec.auto_enrt_mthd_rl := p_auto_enrt_mthd_rl;
1348 l_rec.ivr_ident := p_ivr_ident;
1349 l_rec.url_ref_name := p_url_ref_name;
1350 l_rec.cmpr_clms_to_cvg_or_bal_cd := p_cmpr_clms_to_cvg_or_bal_cd;
1351 l_rec.cobra_pymt_due_dy_num := p_cobra_pymt_due_dy_num;
1352 l_rec.dpnt_cvd_by_othr_apls_flag := p_dpnt_cvd_by_othr_apls_flag;
1356 l_rec.enrt_cvg_end_dt_cd := p_enrt_cvg_end_dt_cd;
1353 l_rec.enrt_mthd_cd := p_enrt_mthd_cd;
1354 l_rec.enrt_cd := p_enrt_cd;
1355 l_rec.enrt_cvg_strt_dt_cd := p_enrt_cvg_strt_dt_cd;
1357 l_rec.frfs_aply_flag := p_frfs_aply_flag;
1358 l_rec.hc_pl_subj_hcfa_aprvl_flag := p_hc_pl_subj_hcfa_aprvl_flag;
1359 l_rec.hghly_cmpd_rl_apls_flag := p_hghly_cmpd_rl_apls_flag;
1360 l_rec.incptn_dt := p_incptn_dt;
1361 l_rec.mn_cvg_rl := p_mn_cvg_rl;
1362 l_rec.mn_cvg_rqd_amt := p_mn_cvg_rqd_amt;
1363 l_rec.mn_opts_rqd_num := p_mn_opts_rqd_num;
1364 l_rec.mx_cvg_alwd_amt := p_mx_cvg_alwd_amt;
1365 l_rec.mx_cvg_rl := p_mx_cvg_rl;
1366 l_rec.mx_opts_alwd_num := p_mx_opts_alwd_num;
1367 l_rec.mx_cvg_wcfn_mlt_num := p_mx_cvg_wcfn_mlt_num;
1368 l_rec.mx_cvg_wcfn_amt := p_mx_cvg_wcfn_amt;
1369 l_rec.mx_cvg_incr_alwd_amt := p_mx_cvg_incr_alwd_amt;
1370 l_rec.mx_cvg_incr_wcf_alwd_amt := p_mx_cvg_incr_wcf_alwd_amt;
1371 l_rec.mx_cvg_mlt_incr_num := p_mx_cvg_mlt_incr_num;
1372 l_rec.mx_cvg_mlt_incr_wcf_num := p_mx_cvg_mlt_incr_wcf_num;
1373 l_rec.mx_wtg_dt_to_use_cd := p_mx_wtg_dt_to_use_cd;
1374 l_rec.mx_wtg_dt_to_use_rl := p_mx_wtg_dt_to_use_rl;
1375 l_rec.mx_wtg_perd_prte_uom := p_mx_wtg_perd_prte_uom;
1376 l_rec.mx_wtg_perd_prte_val := p_mx_wtg_perd_prte_val;
1377 l_rec.mx_wtg_perd_rl := p_mx_wtg_perd_rl;
1378 l_rec.nip_dflt_enrt_cd := p_nip_dflt_enrt_cd;
1379 l_rec.nip_dflt_enrt_det_rl := p_nip_dflt_enrt_det_rl;
1380 l_rec.dpnt_adrs_rqd_flag := p_dpnt_adrs_rqd_flag;
1381 l_rec.dpnt_cvg_end_dt_cd := p_dpnt_cvg_end_dt_cd;
1382 l_rec.dpnt_cvg_end_dt_rl := p_dpnt_cvg_end_dt_rl;
1383 l_rec.dpnt_cvg_strt_dt_cd := p_dpnt_cvg_strt_dt_cd;
1384 l_rec.dpnt_cvg_strt_dt_rl := p_dpnt_cvg_strt_dt_rl;
1385 l_rec.dpnt_dob_rqd_flag := p_dpnt_dob_rqd_flag;
1386 l_rec.dpnt_leg_id_rqd_flag := p_dpnt_leg_id_rqd_flag;
1387 l_rec.dpnt_no_ctfn_rqd_flag := p_dpnt_no_ctfn_rqd_flag;
1388 l_rec.no_mn_cvg_amt_apls_flag := p_no_mn_cvg_amt_apls_flag;
1389 l_rec.no_mn_cvg_incr_apls_flag := p_no_mn_cvg_incr_apls_flag;
1390 l_rec.no_mn_opts_num_apls_flag := p_no_mn_opts_num_apls_flag;
1391 l_rec.no_mx_cvg_amt_apls_flag := p_no_mx_cvg_amt_apls_flag;
1392 l_rec.no_mx_cvg_incr_apls_flag := p_no_mx_cvg_incr_apls_flag;
1393 l_rec.no_mx_opts_num_apls_flag := p_no_mx_opts_num_apls_flag;
1394 l_rec.nip_pl_uom := p_nip_pl_uom;
1395 l_rec.rqd_perd_enrt_nenrt_uom := p_rqd_perd_enrt_nenrt_uom;
1396 l_rec.nip_acty_ref_perd_cd := p_nip_acty_ref_perd_cd;
1397 l_rec.nip_enrt_info_rt_freq_cd := p_nip_enrt_info_rt_freq_cd;
1398 l_rec.per_cvrd_cd := p_per_cvrd_cd;
1399 l_rec.enrt_cvg_end_dt_rl := p_enrt_cvg_end_dt_rl;
1400 l_rec.postelcn_edit_rl := p_postelcn_edit_rl;
1401 l_rec.enrt_cvg_strt_dt_rl := p_enrt_cvg_strt_dt_rl;
1402 l_rec.prort_prtl_yr_cvg_rstrn_cd := p_prort_prtl_yr_cvg_rstrn_cd;
1403 l_rec.prort_prtl_yr_cvg_rstrn_rl := p_prort_prtl_yr_cvg_rstrn_rl;
1404 l_rec.prtn_elig_ovrid_alwd_flag := p_prtn_elig_ovrid_alwd_flag;
1405 l_rec.svgs_pl_flag := p_svgs_pl_flag;
1406 l_rec.subj_to_imptd_incm_typ_cd := p_subj_to_imptd_incm_typ_cd;
1407 l_rec.use_all_asnts_elig_flag := p_use_all_asnts_elig_flag;
1408 l_rec.use_all_asnts_for_rt_flag := p_use_all_asnts_for_rt_flag;
1409 l_rec.vstg_apls_flag := p_vstg_apls_flag;
1410 l_rec.wvbl_flag := p_wvbl_flag;
1411 l_rec.hc_svc_typ_cd := p_hc_svc_typ_cd;
1412 l_rec.pl_stat_cd := p_pl_stat_cd;
1413 l_rec.prmry_fndg_mthd_cd := p_prmry_fndg_mthd_cd;
1414 l_rec.rt_end_dt_cd := p_rt_end_dt_cd;
1415 l_rec.rt_end_dt_rl := p_rt_end_dt_rl;
1416 l_rec.rt_strt_dt_rl := p_rt_strt_dt_rl;
1417 l_rec.rt_strt_dt_cd := p_rt_strt_dt_cd;
1418 l_rec.bnf_dsgn_cd := p_bnf_dsgn_cd;
1419 l_rec.pl_typ_id := p_pl_typ_id;
1420 l_rec.business_group_id := p_business_group_id;
1421 l_rec.enrt_pl_opt_flag := p_enrt_pl_opt_flag;
1422 l_rec.bnft_prvdr_pool_id := p_bnft_prvdr_pool_id;
1423 l_rec.MAY_ENRL_PL_N_OIPL_FLAG := p_MAY_ENRL_PL_N_OIPL_FLAG;
1424 l_rec.ENRT_RL := p_ENRT_RL;
1425 l_rec.rqd_perd_enrt_nenrt_rl := p_rqd_perd_enrt_nENRT_RL;
1426 l_rec.ALWS_UNRSTRCTD_ENRT_FLAG := p_ALWS_UNRSTRCTD_ENRT_FLAG;
1427 l_rec.BNFT_OR_OPTION_RSTRCTN_CD := p_BNFT_OR_OPTION_RSTRCTN_CD;
1428 l_rec.CVG_INCR_R_DECR_ONLY_CD := p_CVG_INCR_R_DECR_ONLY_CD;
1429 l_rec.unsspnd_enrt_cd := p_unsspnd_enrt_cd;
1430 l_rec.pln_attribute_category := p_pln_attribute_category;
1431 l_rec.pln_attribute1 := p_pln_attribute1;
1432 l_rec.pln_attribute2 := p_pln_attribute2;
1433 l_rec.pln_attribute3 := p_pln_attribute3;
1434 l_rec.pln_attribute4 := p_pln_attribute4;
1435 l_rec.pln_attribute5 := p_pln_attribute5;
1436 l_rec.pln_attribute6 := p_pln_attribute6;
1437 l_rec.pln_attribute7 := p_pln_attribute7;
1438 l_rec.pln_attribute8 := p_pln_attribute8;
1439 l_rec.pln_attribute9 := p_pln_attribute9;
1440 l_rec.pln_attribute10 := p_pln_attribute10;
1441 l_rec.pln_attribute11 := p_pln_attribute11;
1442 l_rec.pln_attribute12 := p_pln_attribute12;
1443 l_rec.pln_attribute13 := p_pln_attribute13;
1444 l_rec.pln_attribute14 := p_pln_attribute14;
1445 l_rec.pln_attribute15 := p_pln_attribute15;
1446 l_rec.pln_attribute16 := p_pln_attribute16;
1447 l_rec.pln_attribute17 := p_pln_attribute17;
1448 l_rec.pln_attribute18 := p_pln_attribute18;
1449 l_rec.pln_attribute19 := p_pln_attribute19;
1450 l_rec.pln_attribute20 := p_pln_attribute20;
1451 l_rec.pln_attribute21 := p_pln_attribute21;
1452 l_rec.pln_attribute22 := p_pln_attribute22;
1453 l_rec.pln_attribute23 := p_pln_attribute23;
1454 l_rec.pln_attribute24 := p_pln_attribute24;
1455 l_rec.pln_attribute25 := p_pln_attribute25;
1456 l_rec.pln_attribute26 := p_pln_attribute26;
1457 l_rec.pln_attribute27 := p_pln_attribute27;
1458 l_rec.pln_attribute28 := p_pln_attribute28;
1459 l_rec.pln_attribute29 := p_pln_attribute29;
1460 l_rec.pln_attribute30 := p_pln_attribute30;
1461 l_rec.susp_if_ctfn_not_prvd_flag := p_susp_if_ctfn_not_prvd_flag;
1462 l_rec.ctfn_determine_cd := p_ctfn_determine_cd ;
1463 l_rec.susp_if_dpnt_ssn_nt_prv_cd := p_susp_if_dpnt_ssn_nt_prv_cd;
1464 l_rec.susp_if_dpnt_dob_nt_prv_cd := p_susp_if_dpnt_dob_nt_prv_cd ;
1465 l_rec.susp_if_dpnt_adr_nt_prv_cd := p_susp_if_dpnt_adr_nt_prv_cd ;
1466 l_rec.susp_if_ctfn_not_dpnt_flag := p_susp_if_ctfn_not_dpnt_flag;
1467 l_rec.susp_if_bnf_ssn_nt_prv_cd := p_susp_if_bnf_ssn_nt_prv_cd;
1468 l_rec.susp_if_bnf_dob_nt_prv_cd := p_susp_if_bnf_dob_nt_prv_cd ;
1469 l_rec.susp_if_bnf_adr_nt_prv_cd := p_susp_if_bnf_adr_nt_prv_cd ;
1470 l_rec.susp_if_ctfn_not_bnf_flag := p_susp_if_ctfn_not_bnf_flag ;
1471 l_rec.dpnt_ctfn_determine_cd := p_dpnt_ctfn_determine_cd ;
1472 l_rec.bnf_ctfn_determine_cd := p_bnf_ctfn_determine_cd ;
1473 l_rec.object_version_number := p_object_version_number;
1474 l_rec.actl_prem_id := p_actl_prem_id;
1475 l_rec.vrfy_fmly_mmbr_cd := p_vrfy_fmly_mmbr_cd;
1476 l_rec.vrfy_fmly_mmbr_rl := p_vrfy_fmly_mmbr_rl;
1477 l_rec.alws_tmpry_id_crd_flag := p_alws_tmpry_id_crd_flag;
1478 l_rec.nip_dflt_flag := p_nip_dflt_flag;
1479 l_rec.frfs_distr_mthd_cd := p_frfs_distr_mthd_cd;
1480 l_rec.frfs_distr_mthd_rl := p_frfs_distr_mthd_rl;
1481 l_rec.frfs_cntr_det_cd := p_frfs_cntr_det_cd;
1482 l_rec.frfs_distr_det_cd := p_frfs_distr_det_cd ;
1483 l_rec.cost_alloc_keyflex_1_id := p_cost_alloc_keyflex_1_id;
1484 l_rec.cost_alloc_keyflex_2_id := p_cost_alloc_keyflex_2_id;
1485 l_rec.post_to_gl_flag := p_post_to_gl_flag ;
1486 l_rec.frfs_val_det_cd := p_frfs_val_det_cd ;
1487 l_rec.frfs_mx_cryfwd_val := p_frfs_mx_cryfwd_val ;
1488 l_rec.frfs_portion_det_cd := p_frfs_portion_det_cd ;
1489 l_rec.bndry_perd_cd := p_bndry_perd_cd;
1490 l_rec.short_name := p_short_name;
1491 l_rec.short_code := p_short_code;
1492 l_rec.legislation_code := p_legislation_code;
1493 l_rec.legislation_subgroup := p_legislation_subgroup;
1494 l_rec.group_pl_id := p_group_pl_id;
1495 l_rec.mapping_table_name := p_mapping_table_name;
1496 l_rec.mapping_table_pk_id := p_mapping_table_pk_id;
1497 l_rec.function_code := p_function_code;
1498 l_rec.pl_yr_not_applcbl_flag := p_pl_yr_not_applcbl_flag;
1499 l_rec.use_csd_rsd_prccng_cd := p_use_csd_rsd_prccng_cd;
1500
1501 --
1502 -- Return the plsql record structure.
1503 --
1504 hr_utility.set_location(' Leaving:'||l_proc, 10);
1505 Return(l_rec);
1506 --
1507 End convert_args;
1508 --
1509 end ben_pln_shd;