[Home] [Help]
PACKAGE BODY: APPS.BEN_CPD_SHD
Source
1 Package Body ben_cpd_shd as
2 /* $Header: becpdrhi.pkb 120.4.12020000.3 2013/01/02 07:16:14 kmsuresh ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ben_cpd_shd.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------< return_api_dml_status >-------------------------|
15 Begin
12 -- ----------------------------------------------------------------------------
13 Function return_api_dml_status Return Boolean Is
14 --
16 --
17 Return (nvl(g_api_dml, false));
18 --
19 End return_api_dml_status;
20 --
21 -- ----------------------------------------------------------------------------
22 -- |---------------------------< constraint_error >---------------------------|
23 -- ----------------------------------------------------------------------------
24 Procedure constraint_error
25 (p_constraint_name in all_constraints.constraint_name%TYPE
26 ) Is
27 --
28 l_proc varchar2(72) := g_package||'constraint_error';
29 --
30 Begin
31 --
32 If (p_constraint_name = 'BEN_CWB_PL_DSGN_PK') Then
33 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34 fnd_message.set_token('PROCEDURE', l_proc);
35 fnd_message.set_token('STEP','5');
36 fnd_message.raise_error;
37 Else
38 fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39 fnd_message.set_token('PROCEDURE', l_proc);
40 fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41 fnd_message.raise_error;
42 End If;
43 --
44 End constraint_error;
45 --
46 -- ----------------------------------------------------------------------------
47 -- |-----------------------------< api_updating >-----------------------------|
48 -- ----------------------------------------------------------------------------
49 Function api_updating
50 (p_pl_id in number
51 ,p_lf_evt_ocrd_dt in date
52 ,p_oipl_id in number
53 ,p_object_version_number in number
54 )
55 Return Boolean Is
56 --
57 --
58 -- Cursor selects the 'current' row from the HR Schema
59 --
60 Cursor C_Sel1 is
61 select
62 pl_id
63 ,lf_evt_ocrd_dt
64 ,oipl_id
65 ,effective_date
66 ,name
67 ,group_pl_id
68 ,group_oipl_id
69 ,opt_hidden_flag
70 ,opt_id
71 ,pl_uom
72 ,pl_ordr_num
73 ,oipl_ordr_num
74 ,pl_xchg_rate
75 ,opt_count
76 ,uses_bdgt_flag
77 ,prsrv_bdgt_cd
78 ,upd_start_dt
79 ,upd_end_dt
80 ,approval_mode
81 ,enrt_perd_start_dt
82 ,enrt_perd_end_dt
83 ,yr_perd_start_dt
84 ,yr_perd_end_dt
85 ,wthn_yr_start_dt
86 ,wthn_yr_end_dt
87 ,enrt_perd_id
88 ,yr_perd_id
89 ,business_group_id
90 ,perf_revw_strt_dt
91 ,asg_updt_eff_date
92 ,emp_interview_typ_cd
93 ,salary_change_reason
94 ,ws_abr_id
95 ,ws_nnmntry_uom
96 ,ws_rndg_cd
97 ,ws_sub_acty_typ_cd
98 ,dist_bdgt_abr_id
99 ,dist_bdgt_nnmntry_uom
100 ,dist_bdgt_rndg_cd
101 ,ws_bdgt_abr_id
102 ,ws_bdgt_nnmntry_uom
103 ,ws_bdgt_rndg_cd
104 ,rsrv_abr_id
105 ,rsrv_nnmntry_uom
106 ,rsrv_rndg_cd
107 ,elig_sal_abr_id
108 ,elig_sal_nnmntry_uom
109 ,elig_sal_rndg_cd
110 ,misc1_abr_id
111 ,misc1_nnmntry_uom
112 ,misc1_rndg_cd
113 ,misc2_abr_id
114 ,misc2_nnmntry_uom
115 ,misc2_rndg_cd
116 ,misc3_abr_id
117 ,misc3_nnmntry_uom
118 ,misc3_rndg_cd
119 ,stat_sal_abr_id
120 ,stat_sal_nnmntry_uom
121 ,stat_sal_rndg_cd
122 ,rec_abr_id
123 ,rec_nnmntry_uom
124 ,rec_rndg_cd
125 ,tot_comp_abr_id
126 ,tot_comp_nnmntry_uom
127 ,tot_comp_rndg_cd
128 ,oth_comp_abr_id
129 ,oth_comp_nnmntry_uom
130 ,oth_comp_rndg_cd
131 ,actual_flag
132 ,acty_ref_perd_cd
133 ,legislation_code
134 ,pl_annulization_factor
135 ,pl_stat_cd
136 ,uom_precision
137 ,ws_element_type_id
138 ,ws_input_value_id
139 ,data_freeze_date
140 ,ws_amt_edit_cd
141 ,ws_amt_edit_enf_cd_for_nulls
142 ,ws_over_budget_edit_cd
143 ,ws_over_budget_tolerance_pct
144 ,bdgt_over_budget_edit_cd
145 ,bdgt_over_budget_tolerance_pct
146 ,auto_distr_flag
147 ,pqh_document_short_name
148 ,ovrid_rt_strt_dt
149 ,do_not_process_flag
150 ,ovr_perf_revw_strt_dt
151 ,post_zero_salary_increase
152 ,show_appraisals_n_days
153 ,grade_range_validation
154 ,object_version_number
155 , email_password_protected
156 ,email_cc_manager
157 ,email_subject
158 ,email_content
159 ,email_sample_address
160 from ben_cwb_pl_dsgn
161 where pl_id = p_pl_id
162 and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
163 and oipl_id = p_oipl_id;
164 --
165 l_fct_ret boolean;
166 --
167 Begin
168 --
169 If (p_pl_id is null and
170 p_lf_evt_ocrd_dt is null and
171 p_oipl_id is null and
172 p_object_version_number is null
173 ) Then
174 --
175 -- One of the primary key arguments is null therefore we must
176 -- set the returning function value to false
177 --
178 l_fct_ret := false;
179 Else
180 If (p_pl_id
181 = ben_cpd_shd.g_old_rec.pl_id and
185 = ben_cpd_shd.g_old_rec.oipl_id and
182 p_lf_evt_ocrd_dt
183 = ben_cpd_shd.g_old_rec.lf_evt_ocrd_dt and
184 p_oipl_id
186 p_object_version_number
187 = ben_cpd_shd.g_old_rec.object_version_number
188 ) Then
189 --
190 -- The g_old_rec is current therefore we must
191 -- set the returning function to true
192 --
193 l_fct_ret := true;
194 Else
195 --
196 -- Select the current row into g_old_rec
197 --
198 Open C_Sel1;
199 Fetch C_Sel1 Into ben_cpd_shd.g_old_rec;
200 If C_Sel1%notfound Then
201 Close C_Sel1;
202 --
203 -- The primary key is invalid therefore we must error
204 --
205 fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
206 fnd_message.raise_error;
207 End If;
208 Close C_Sel1;
209 If (p_object_version_number
210 <> ben_cpd_shd.g_old_rec.object_version_number) Then
211 fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
212 fnd_message.raise_error;
213 End If;
214 l_fct_ret := true;
215 End If;
216 End If;
217 Return (l_fct_ret);
218 --
219 End api_updating;
220 --
221 -- ----------------------------------------------------------------------------
222 -- |---------------------------------< lck >----------------------------------|
223 -- ----------------------------------------------------------------------------
224 Procedure lck
225 (p_pl_id in number
226 ,p_lf_evt_ocrd_dt in date
227 ,p_oipl_id in number
228 ,p_object_version_number in number
229 ) is
230 --
231 -- Cursor selects the 'current' row from the HR Schema
232 --
233 Cursor C_Sel1 is
234 select
235 pl_id
236 ,lf_evt_ocrd_dt
237 ,oipl_id
238 ,effective_date
239 ,name
240 ,group_pl_id
241 ,group_oipl_id
242 ,opt_hidden_flag
243 ,opt_id
244 ,pl_uom
245 ,pl_ordr_num
246 ,oipl_ordr_num
247 ,pl_xchg_rate
248 ,opt_count
249 ,uses_bdgt_flag
250 ,prsrv_bdgt_cd
251 ,upd_start_dt
252 ,upd_end_dt
253 ,approval_mode
254 ,enrt_perd_start_dt
255 ,enrt_perd_end_dt
256 ,yr_perd_start_dt
257 ,yr_perd_end_dt
258 ,wthn_yr_start_dt
259 ,wthn_yr_end_dt
260 ,enrt_perd_id
261 ,yr_perd_id
262 ,business_group_id
263 ,perf_revw_strt_dt
264 ,asg_updt_eff_date
265 ,emp_interview_typ_cd
266 ,salary_change_reason
267 ,ws_abr_id
268 ,ws_nnmntry_uom
269 ,ws_rndg_cd
270 ,ws_sub_acty_typ_cd
271 ,dist_bdgt_abr_id
272 ,dist_bdgt_nnmntry_uom
273 ,dist_bdgt_rndg_cd
274 ,ws_bdgt_abr_id
275 ,ws_bdgt_nnmntry_uom
276 ,ws_bdgt_rndg_cd
277 ,rsrv_abr_id
278 ,rsrv_nnmntry_uom
279 ,rsrv_rndg_cd
280 ,elig_sal_abr_id
281 ,elig_sal_nnmntry_uom
282 ,elig_sal_rndg_cd
283 ,misc1_abr_id
284 ,misc1_nnmntry_uom
285 ,misc1_rndg_cd
286 ,misc2_abr_id
287 ,misc2_nnmntry_uom
288 ,misc2_rndg_cd
289 ,misc3_abr_id
290 ,misc3_nnmntry_uom
291 ,misc3_rndg_cd
292 ,stat_sal_abr_id
293 ,stat_sal_nnmntry_uom
294 ,stat_sal_rndg_cd
295 ,rec_abr_id
296 ,rec_nnmntry_uom
297 ,rec_rndg_cd
298 ,tot_comp_abr_id
299 ,tot_comp_nnmntry_uom
300 ,tot_comp_rndg_cd
301 ,oth_comp_abr_id
302 ,oth_comp_nnmntry_uom
303 ,oth_comp_rndg_cd
304 ,actual_flag
305 ,acty_ref_perd_cd
306 ,legislation_code
307 ,pl_annulization_factor
308 ,pl_stat_cd
309 ,uom_precision
310 ,ws_element_type_id
311 ,ws_input_value_id
312 ,data_freeze_date
313 ,ws_amt_edit_cd
314 ,ws_amt_edit_enf_cd_for_nulls
315 ,ws_over_budget_edit_cd
316 ,ws_over_budget_tolerance_pct
317 ,bdgt_over_budget_edit_cd
318 ,bdgt_over_budget_tolerance_pct
319 ,auto_distr_flag
320 ,pqh_document_short_name
321 ,ovrid_rt_strt_dt
322 ,do_not_process_flag
323 ,ovr_perf_revw_strt_dt
324 ,post_zero_salary_increase
325 ,show_appraisals_n_days
326 ,grade_range_validation
327 ,object_version_number
328 , email_password_protected
329 ,email_cc_manager
330 ,email_subject
331 ,email_content
332 ,email_sample_address
333 from ben_cwb_pl_dsgn
334 where pl_id = p_pl_id
335 and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
336 and oipl_id = p_oipl_id
337 for update nowait;
338 --
339 l_proc varchar2(72) := g_package||'lck';
340 --
341 Begin
342 hr_utility.set_location('Entering:'||l_proc, 5);
343 --
344 hr_api.mandatory_arg_error
345 (p_api_name => l_proc
346 ,p_argument => 'PL_ID'
347 ,p_argument_value => p_pl_id
348 );
349 hr_utility.set_location(l_proc,6);
350 hr_api.mandatory_arg_error
351 (p_api_name => l_proc
352 ,p_argument => 'LF_EVT_OCRD_DT'
353 ,p_argument_value => p_lf_evt_ocrd_dt
354 );
355 hr_utility.set_location(l_proc,7);
356 hr_api.mandatory_arg_error
357 (p_api_name => l_proc
358 ,p_argument => 'OIPL_ID'
359 ,p_argument_value => p_oipl_id
360 );
361 hr_utility.set_location(l_proc,8);
362 hr_api.mandatory_arg_error
363 (p_api_name => l_proc
364 ,p_argument => 'OBJECT_VERSION_NUMBER'
365 ,p_argument_value => p_object_version_number
366 );
367 --
368 Open C_Sel1;
369 Fetch C_Sel1 Into ben_cpd_shd.g_old_rec;
370 If C_Sel1%notfound then
371 Close C_Sel1;
372 --
373 -- The primary key is invalid therefore we must error
374 --
375 fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
376 fnd_message.raise_error;
377 End If;
378 Close C_Sel1;
379 hr_utility.set_location('ovn : '||p_object_version_number,999);
380 hr_utility.set_location('old ovn : '||ben_cpd_shd.g_old_rec.object_version_number,999);
381 If (p_object_version_number
382 <> ben_cpd_shd.g_old_rec.object_version_number) Then
383 fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
384 fnd_message.raise_error;
385 End If;
386 --
387 hr_utility.set_location(' Leaving:'||l_proc, 10);
388 --
389 -- We need to trap the ORA LOCK exception
390 --
391 Exception
392 When HR_Api.Object_Locked then
393 --
394 -- The object is locked therefore we need to supply a meaningful
395 -- error message.
396 --
397 fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
398 fnd_message.set_token('TABLE_NAME', 'ben_cwb_pl_dsgn');
399 fnd_message.raise_error;
400 End lck;
401 --
402 -- ----------------------------------------------------------------------------
403 -- |-----------------------------< convert_args >-----------------------------|
404 -- ----------------------------------------------------------------------------
405 Function convert_args
406 (p_pl_id in number
407 ,p_oipl_id in number
408 ,p_lf_evt_ocrd_dt in date
409 ,p_effective_date in date
410 ,p_name in varchar2
411 ,p_group_pl_id in number
412 ,p_group_oipl_id in number
413 ,p_opt_hidden_flag in varchar2
414 ,p_opt_id in number
415 ,p_pl_uom in varchar2
416 ,p_pl_ordr_num in number
417 ,p_oipl_ordr_num in number
418 ,p_pl_xchg_rate in number
419 ,p_opt_count in number
420 ,p_uses_bdgt_flag in varchar2
421 ,p_prsrv_bdgt_cd in varchar2
422 ,p_upd_start_dt in date
423 ,p_upd_end_dt in date
424 ,p_approval_mode in varchar2
425 ,p_enrt_perd_start_dt in date
426 ,p_enrt_perd_end_dt in date
427 ,p_yr_perd_start_dt in date
428 ,p_yr_perd_end_dt in date
429 ,p_wthn_yr_start_dt in date
430 ,p_wthn_yr_end_dt in date
431 ,p_enrt_perd_id in number
432 ,p_yr_perd_id in number
433 ,p_business_group_id in number
434 ,p_perf_revw_strt_dt in date
435 ,p_asg_updt_eff_date in date
436 ,p_emp_interview_typ_cd in varchar2
437 ,p_salary_change_reason in varchar2
438 ,p_ws_abr_id in number
439 ,p_ws_nnmntry_uom in varchar2
440 ,p_ws_rndg_cd in varchar2
441 ,p_ws_sub_acty_typ_cd in varchar2
442 ,p_dist_bdgt_abr_id in number
443 ,p_dist_bdgt_nnmntry_uom in varchar2
444 ,p_dist_bdgt_rndg_cd in varchar2
445 ,p_ws_bdgt_abr_id in number
446 ,p_ws_bdgt_nnmntry_uom in varchar2
447 ,p_ws_bdgt_rndg_cd in varchar2
448 ,p_rsrv_abr_id in number
449 ,p_rsrv_nnmntry_uom in varchar2
450 ,p_rsrv_rndg_cd in varchar2
451 ,p_elig_sal_abr_id in number
452 ,p_elig_sal_nnmntry_uom in varchar2
453 ,p_elig_sal_rndg_cd in varchar2
454 ,p_misc1_abr_id in number
455 ,p_misc1_nnmntry_uom in varchar2
456 ,p_misc1_rndg_cd in varchar2
457 ,p_misc2_abr_id in number
458 ,p_misc2_nnmntry_uom in varchar2
459 ,p_misc2_rndg_cd in varchar2
460 ,p_misc3_abr_id in number
461 ,p_misc3_nnmntry_uom in varchar2
462 ,p_misc3_rndg_cd in varchar2
463 ,p_stat_sal_abr_id in number
464 ,p_stat_sal_nnmntry_uom in varchar2
465 ,p_stat_sal_rndg_cd in varchar2
466 ,p_rec_abr_id in number
467 ,p_rec_nnmntry_uom in varchar2
468 ,p_rec_rndg_cd in varchar2
469 ,p_tot_comp_abr_id in number
470 ,p_tot_comp_nnmntry_uom in varchar2
471 ,p_tot_comp_rndg_cd in varchar2
472 ,p_oth_comp_abr_id in number
473 ,p_oth_comp_nnmntry_uom in varchar2
474 ,p_oth_comp_rndg_cd in varchar2
475 ,p_actual_flag in varchar2
476 ,p_acty_ref_perd_cd in varchar2
477 ,p_legislation_code in varchar2
478 ,p_pl_annulization_factor in number
479 ,p_pl_stat_cd in varchar2
480 ,p_uom_precision in number
481 ,p_ws_element_type_id in number
482 ,p_ws_input_value_id in number
483 ,p_data_freeze_date in date
484 ,p_ws_amt_edit_cd in varchar2
485 ,p_ws_amt_edit_enf_cd_for_nul in varchar2
486 ,p_ws_over_budget_edit_cd in varchar2
487 ,p_ws_over_budget_tol_pct in number
488 ,p_bdgt_over_budget_edit_cd in varchar2
489 ,p_bdgt_over_budget_tol_pct in number
490 ,p_auto_distr_flag in varchar2
491 ,p_pqh_document_short_name in varchar2
492 ,p_ovrid_rt_strt_dt in date
493 ,p_do_not_process_flag in varchar2
494 ,p_ovr_perf_revw_strt_dt in date
495 ,p_post_zero_salary_increase in varchar2
496 ,p_show_appraisals_n_days in number
497 ,p_grade_range_validation in varchar2
498 ,p_object_version_number in number
499 ,p_email_password_protected in varchar2
500 ,p_email_cc_manager in varchar2
501 ,p_email_subject in varchar2
502 ,p_email_content in clob
503 ,p_email_sample_address in varchar2
504 )
505 Return g_rec_type is
506 --
507 l_rec g_rec_type;
508 --
509 Begin
510 --
511 -- Convert arguments into local l_rec structure.
512 --
513 l_rec.pl_id := p_pl_id;
514 l_rec.lf_evt_ocrd_dt := p_lf_evt_ocrd_dt;
515 l_rec.oipl_id := p_oipl_id;
516 l_rec.effective_date := p_effective_date;
517 l_rec.name := p_name;
518 l_rec.group_pl_id := p_group_pl_id;
519 l_rec.group_oipl_id := p_group_oipl_id;
520 l_rec.opt_hidden_flag := p_opt_hidden_flag;
521 l_rec.opt_id := p_opt_id;
522 l_rec.pl_uom := p_pl_uom;
523 l_rec.pl_ordr_num := p_pl_ordr_num;
524 l_rec.oipl_ordr_num := p_oipl_ordr_num;
525 l_rec.pl_xchg_rate := p_pl_xchg_rate;
526 l_rec.opt_count := p_opt_count;
527 l_rec.uses_bdgt_flag := p_uses_bdgt_flag;
528 l_rec.prsrv_bdgt_cd := p_prsrv_bdgt_cd;
529 l_rec.upd_start_dt := p_upd_start_dt;
530 l_rec.upd_end_dt := p_upd_end_dt;
531 l_rec.approval_mode := p_approval_mode;
532 l_rec.enrt_perd_start_dt := p_enrt_perd_start_dt;
533 l_rec.enrt_perd_end_dt := p_enrt_perd_end_dt;
534 l_rec.yr_perd_start_dt := p_yr_perd_start_dt;
535 l_rec.yr_perd_end_dt := p_yr_perd_end_dt;
536 l_rec.wthn_yr_start_dt := p_wthn_yr_start_dt;
537 l_rec.wthn_yr_end_dt := p_wthn_yr_end_dt;
538 l_rec.enrt_perd_id := p_enrt_perd_id;
539 l_rec.yr_perd_id := p_yr_perd_id;
540 l_rec.business_group_id := p_business_group_id;
541 l_rec.perf_revw_strt_dt := p_perf_revw_strt_dt;
542 l_rec.asg_updt_eff_date := p_asg_updt_eff_date;
543 l_rec.emp_interview_typ_cd := p_emp_interview_typ_cd;
544 l_rec.salary_change_reason := p_salary_change_reason;
545 l_rec.ws_abr_id := p_ws_abr_id;
546 l_rec.ws_nnmntry_uom := p_ws_nnmntry_uom;
547 l_rec.ws_rndg_cd := p_ws_rndg_cd;
548 l_rec.ws_sub_acty_typ_cd := p_ws_sub_acty_typ_cd;
549 l_rec.dist_bdgt_abr_id := p_dist_bdgt_abr_id;
550 l_rec.dist_bdgt_nnmntry_uom := p_dist_bdgt_nnmntry_uom;
551 l_rec.dist_bdgt_rndg_cd := p_dist_bdgt_rndg_cd;
552 l_rec.ws_bdgt_abr_id := p_ws_bdgt_abr_id;
553 l_rec.ws_bdgt_nnmntry_uom := p_ws_bdgt_nnmntry_uom;
554 l_rec.ws_bdgt_rndg_cd := p_ws_bdgt_rndg_cd;
555 l_rec.rsrv_abr_id := p_rsrv_abr_id;
556 l_rec.rsrv_nnmntry_uom := p_rsrv_nnmntry_uom;
557 l_rec.rsrv_rndg_cd := p_rsrv_rndg_cd;
558 l_rec.elig_sal_abr_id := p_elig_sal_abr_id;
559 l_rec.elig_sal_nnmntry_uom := p_elig_sal_nnmntry_uom;
560 l_rec.elig_sal_rndg_cd := p_elig_sal_rndg_cd;
561 l_rec.misc1_abr_id := p_misc1_abr_id;
562 l_rec.misc1_nnmntry_uom := p_misc1_nnmntry_uom;
563 l_rec.misc1_rndg_cd := p_misc1_rndg_cd;
564 l_rec.misc2_abr_id := p_misc2_abr_id;
565 l_rec.misc2_nnmntry_uom := p_misc2_nnmntry_uom;
566 l_rec.misc2_rndg_cd := p_misc2_rndg_cd;
567 l_rec.misc3_abr_id := p_misc3_abr_id;
568 l_rec.misc3_nnmntry_uom := p_misc3_nnmntry_uom;
569 l_rec.misc3_rndg_cd := p_misc3_rndg_cd;
570 l_rec.stat_sal_abr_id := p_stat_sal_abr_id;
571 l_rec.stat_sal_nnmntry_uom := p_stat_sal_nnmntry_uom;
572 l_rec.stat_sal_rndg_cd := p_stat_sal_rndg_cd;
573 l_rec.rec_abr_id := p_rec_abr_id;
574 l_rec.rec_nnmntry_uom := p_rec_nnmntry_uom;
575 l_rec.rec_rndg_cd := p_rec_rndg_cd;
576 l_rec.tot_comp_abr_id := p_tot_comp_abr_id;
577 l_rec.tot_comp_nnmntry_uom := p_tot_comp_nnmntry_uom;
578 l_rec.tot_comp_rndg_cd := p_tot_comp_rndg_cd;
579 l_rec.oth_comp_abr_id := p_oth_comp_abr_id;
580 l_rec.oth_comp_nnmntry_uom := p_oth_comp_nnmntry_uom;
581 l_rec.oth_comp_rndg_cd := p_oth_comp_rndg_cd;
582 l_rec.actual_flag := p_actual_flag;
583 l_rec.acty_ref_perd_cd := p_acty_ref_perd_cd;
584 l_rec.legislation_code := p_legislation_code;
585 l_rec.pl_annulization_factor := p_pl_annulization_factor;
586 l_rec.pl_stat_cd := p_pl_stat_cd;
587 l_rec.uom_precision := p_uom_precision;
588 l_rec.ws_element_type_id := p_ws_element_type_id;
589 l_rec.ws_input_value_id := p_ws_input_value_id;
590 l_rec.data_freeze_date := p_data_freeze_date;
591 l_rec.ws_amt_edit_cd := p_ws_amt_edit_cd;
592 l_rec.ws_amt_edit_enf_cd_for_nulls := p_ws_amt_edit_enf_cd_for_nul;
593 l_rec.ws_over_budget_edit_cd := p_ws_over_budget_edit_cd;
594 l_rec.ws_over_budget_tolerance_pct := p_ws_over_budget_tol_pct;
595 l_rec.bdgt_over_budget_edit_cd := p_bdgt_over_budget_edit_cd;
596 l_rec.bdgt_over_budget_tolerance_pct := p_bdgt_over_budget_tol_pct;
597 l_rec.auto_distr_flag := p_auto_distr_flag;
598 l_rec.pqh_document_short_name := p_pqh_document_short_name;
599 l_rec.ovrid_rt_strt_dt := p_ovrid_rt_strt_dt;
600 l_rec.do_not_process_flag := p_do_not_process_flag;
601 l_rec.ovr_perf_revw_strt_dt := p_ovr_perf_revw_strt_dt;
602 l_rec.post_zero_salary_increase := p_post_zero_salary_increase;
603 l_rec.show_appraisals_n_days := p_show_appraisals_n_days;
604 l_rec.grade_range_validation := p_grade_range_validation;
605 l_rec.object_version_number := p_object_version_number;
606 l_rec.email_password_protected := p_email_password_protected;
607 l_rec.email_cc_manager := p_email_cc_manager;
608 l_rec.email_subject := p_email_subject;
609 l_rec.email_content := p_email_content;
610 l_rec.email_sample_address := p_email_sample_address;
611 --
612 -- Return the plsql record structure.
613 --
614 Return(l_rec);
615 --
616 End convert_args;
617 --
618 end ben_cpd_shd;