[Home] [Help]
PACKAGE BODY: APPS.BEN_CPI_SHD
Source
1 Package Body ben_cpi_shd as
2 /* $Header: becpirhi.pkb 120.0 2005/05/28 01:13:52 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ben_cpi_shd.'; -- Global package name
9 g_debug boolean := hr_utility.debug_enabled;
10 --
11 -- ----------------------------------------------------------------------------
12 -- |------------------------< return_api_dml_status >-------------------------|
13 -- ----------------------------------------------------------------------------
14 Function return_api_dml_status Return Boolean Is
15 --
16 Begin
17 --
18 Return (nvl(g_api_dml, false));
19 --
20 End return_api_dml_status;
21 --
22 -- ----------------------------------------------------------------------------
23 -- |---------------------------< constraint_error >---------------------------|
24 -- ----------------------------------------------------------------------------
25 Procedure constraint_error
26 (p_constraint_name in all_constraints.constraint_name%TYPE
27 ) Is
28 --
29 l_proc varchar2(72) := g_package||'constraint_error';
30 --
31 Begin
32 --
33 If (p_constraint_name = 'BEN_CWB_PERSON_INFO_PK') Then
34 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35 fnd_message.set_token('PROCEDURE', l_proc);
36 fnd_message.set_token('STEP','5');
37 fnd_message.raise_error;
38 Else
39 fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
40 fnd_message.set_token('PROCEDURE', l_proc);
41 fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
42 fnd_message.raise_error;
43 End If;
44 --
45 End constraint_error;
46 --
47 -- ----------------------------------------------------------------------------
48 -- |-----------------------------< api_updating >-----------------------------|
49 -- ----------------------------------------------------------------------------
50 Function api_updating
51 (p_group_per_in_ler_id in number
52 ,p_object_version_number in number
53 )
54 Return Boolean Is
55 --
56 --
57 -- Cursor selects the 'current' row from the HR Schema
58 --
59 Cursor C_Sel1 is
60 select
61 group_per_in_ler_id
62 ,assignment_id
63 ,person_id
64 ,supervisor_id
65 ,effective_date
66 ,full_name
67 ,brief_name
68 ,custom_name
69 ,supervisor_full_name
70 ,supervisor_brief_name
71 ,supervisor_custom_name
72 ,legislation_code
73 ,years_employed
74 ,years_in_job
75 ,years_in_position
76 ,years_in_grade
77 ,employee_number
78 ,start_date
79 ,original_start_date
80 ,adjusted_svc_date
81 ,base_salary
82 ,base_salary_change_date
83 ,payroll_name
84 ,performance_rating
85 ,performance_rating_type
86 ,performance_rating_date
87 ,business_group_id
88 ,organization_id
89 ,job_id
90 ,grade_id
91 ,position_id
92 ,people_group_id
93 ,soft_coding_keyflex_id
94 ,location_id
95 ,pay_rate_id
96 ,assignment_status_type_id
97 ,frequency
98 ,grade_annulization_factor
99 ,pay_annulization_factor
100 ,grd_min_val
101 ,grd_max_val
102 ,grd_mid_point
103 ,grd_quartile
104 ,grd_comparatio
105 ,emp_category
106 ,change_reason
107 ,normal_hours
108 ,email_address
109 ,base_salary_frequency
110 ,new_assgn_ovn
111 ,new_perf_event_id
112 ,new_perf_review_id
113 ,post_process_stat_cd
114 ,feedback_rating
115 ,feedback_comments
116 ,object_version_number
117 ,custom_segment1
118 ,custom_segment2
119 ,custom_segment3
120 ,custom_segment4
121 ,custom_segment5
122 ,custom_segment6
123 ,custom_segment7
124 ,custom_segment8
125 ,custom_segment9
126 ,custom_segment10
127 ,custom_segment11
128 ,custom_segment12
129 ,custom_segment13
130 ,custom_segment14
131 ,custom_segment15
132 ,custom_segment16
133 ,custom_segment17
134 ,custom_segment18
135 ,custom_segment19
136 ,custom_segment20
137 ,people_group_name
138 ,people_group_segment1
139 ,people_group_segment2
140 ,people_group_segment3
141 ,people_group_segment4
142 ,people_group_segment5
143 ,people_group_segment6
144 ,people_group_segment7
145 ,people_group_segment8
146 ,people_group_segment9
147 ,people_group_segment10
148 ,people_group_segment11
149 ,ass_attribute_category
150 ,ass_attribute1
151 ,ass_attribute2
152 ,ass_attribute3
153 ,ass_attribute4
154 ,ass_attribute5
155 ,ass_attribute6
156 ,ass_attribute7
157 ,ass_attribute8
158 ,ass_attribute9
159 ,ass_attribute10
160 ,ass_attribute11
161 ,ass_attribute12
162 ,ass_attribute13
163 ,ass_attribute14
164 ,ass_attribute15
165 ,ass_attribute16
166 ,ass_attribute17
167 ,ass_attribute18
168 ,ass_attribute19
169 ,ass_attribute20
170 ,ass_attribute21
171 ,ass_attribute22
172 ,ass_attribute23
173 ,ass_attribute24
174 ,ass_attribute25
175 ,ass_attribute26
176 ,ass_attribute27
177 ,ass_attribute28
178 ,ass_attribute29
179 ,ass_attribute30
180 ,ws_comments
181 ,cpi_attribute_category
182 ,cpi_attribute1
183 ,cpi_attribute2
184 ,cpi_attribute3
185 ,cpi_attribute4
186 ,cpi_attribute5
187 ,cpi_attribute6
188 ,cpi_attribute7
189 ,cpi_attribute8
190 ,cpi_attribute9
191 ,cpi_attribute10
192 ,cpi_attribute11
193 ,cpi_attribute12
194 ,cpi_attribute13
195 ,cpi_attribute14
196 ,cpi_attribute15
197 ,cpi_attribute16
198 ,cpi_attribute17
199 ,cpi_attribute18
200 ,cpi_attribute19
201 ,cpi_attribute20
202 ,cpi_attribute21
203 ,cpi_attribute22
204 ,cpi_attribute23
205 ,cpi_attribute24
206 ,cpi_attribute25
207 ,cpi_attribute26
208 ,cpi_attribute27
209 ,cpi_attribute28
210 ,cpi_attribute29
211 ,cpi_attribute30
212 ,feedback_date
213 from ben_cwb_person_info
214 where group_per_in_ler_id = p_group_per_in_ler_id;
215 --
216 l_fct_ret boolean;
217 --
218 Begin
219 --
220 If (p_group_per_in_ler_id is null and
221 p_object_version_number is null
222 ) Then
223 --
224 -- One of the primary key arguments is null therefore we must
225 -- set the returning function value to false
226 --
227 l_fct_ret := false;
228 Else
229 If (p_group_per_in_ler_id
230 = ben_cpi_shd.g_old_rec.group_per_in_ler_id and
231 p_object_version_number
232 = ben_cpi_shd.g_old_rec.object_version_number
233 ) Then
234 --
235 -- The g_old_rec is current therefore we must
236 -- set the returning function to true
237 --
238 l_fct_ret := true;
239 Else
240 --
241 -- Select the current row into g_old_rec
242 --
243 Open C_Sel1;
244 Fetch C_Sel1 Into ben_cpi_shd.g_old_rec;
245 If C_Sel1%notfound Then
246 Close C_Sel1;
247 --
248 -- The primary key is invalid therefore we must error
249 --
250 fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
251 fnd_message.raise_error;
252 End If;
253 Close C_Sel1;
254 If (p_object_version_number
255 <> ben_cpi_shd.g_old_rec.object_version_number) Then
256 fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
257 fnd_message.raise_error;
258 End If;
259 l_fct_ret := true;
260 End If;
261 End If;
262 Return (l_fct_ret);
263 --
264 End api_updating;
265 --
266 -- ----------------------------------------------------------------------------
267 -- |---------------------------------< lck >----------------------------------|
268 -- ----------------------------------------------------------------------------
269 Procedure lck
270 (p_group_per_in_ler_id in number
271 ,p_object_version_number in number
272 ) is
273 --
274 -- Cursor selects the 'current' row from the HR Schema
275 --
276 Cursor C_Sel1 is
277 select
278 group_per_in_ler_id
279 ,assignment_id
280 ,person_id
281 ,supervisor_id
282 ,effective_date
283 ,full_name
284 ,brief_name
285 ,custom_name
286 ,supervisor_full_name
287 ,supervisor_brief_name
288 ,supervisor_custom_name
289 ,legislation_code
290 ,years_employed
291 ,years_in_job
292 ,years_in_position
293 ,years_in_grade
294 ,employee_number
295 ,start_date
296 ,original_start_date
297 ,adjusted_svc_date
298 ,base_salary
299 ,base_salary_change_date
300 ,payroll_name
301 ,performance_rating
302 ,performance_rating_type
303 ,performance_rating_date
304 ,business_group_id
305 ,organization_id
306 ,job_id
307 ,grade_id
308 ,position_id
309 ,people_group_id
310 ,soft_coding_keyflex_id
311 ,location_id
312 ,pay_rate_id
313 ,assignment_status_type_id
314 ,frequency
315 ,grade_annulization_factor
316 ,pay_annulization_factor
317 ,grd_min_val
318 ,grd_max_val
319 ,grd_mid_point
320 ,grd_quartile
321 ,grd_comparatio
322 ,emp_category
323 ,change_reason
324 ,normal_hours
325 ,email_address
326 ,base_salary_frequency
327 ,new_assgn_ovn
328 ,new_perf_event_id
329 ,new_perf_review_id
330 ,post_process_stat_cd
331 ,feedback_rating
332 ,feedback_comments
333 ,object_version_number
334 ,custom_segment1
335 ,custom_segment2
336 ,custom_segment3
337 ,custom_segment4
338 ,custom_segment5
339 ,custom_segment6
340 ,custom_segment7
341 ,custom_segment8
342 ,custom_segment9
343 ,custom_segment10
344 ,custom_segment11
345 ,custom_segment12
346 ,custom_segment13
347 ,custom_segment14
348 ,custom_segment15
349 ,custom_segment16
350 ,custom_segment17
351 ,custom_segment18
352 ,custom_segment19
353 ,custom_segment20
354 ,people_group_name
355 ,people_group_segment1
356 ,people_group_segment2
357 ,people_group_segment3
358 ,people_group_segment4
359 ,people_group_segment5
360 ,people_group_segment6
361 ,people_group_segment7
362 ,people_group_segment8
363 ,people_group_segment9
364 ,people_group_segment10
365 ,people_group_segment11
366 ,ass_attribute_category
367 ,ass_attribute1
368 ,ass_attribute2
369 ,ass_attribute3
370 ,ass_attribute4
371 ,ass_attribute5
372 ,ass_attribute6
373 ,ass_attribute7
374 ,ass_attribute8
375 ,ass_attribute9
376 ,ass_attribute10
377 ,ass_attribute11
378 ,ass_attribute12
379 ,ass_attribute13
380 ,ass_attribute14
381 ,ass_attribute15
382 ,ass_attribute16
383 ,ass_attribute17
384 ,ass_attribute18
385 ,ass_attribute19
386 ,ass_attribute20
387 ,ass_attribute21
388 ,ass_attribute22
389 ,ass_attribute23
390 ,ass_attribute24
391 ,ass_attribute25
392 ,ass_attribute26
393 ,ass_attribute27
394 ,ass_attribute28
395 ,ass_attribute29
396 ,ass_attribute30
397 ,ws_comments
398 ,cpi_attribute_category
399 ,cpi_attribute1
400 ,cpi_attribute2
401 ,cpi_attribute3
402 ,cpi_attribute4
403 ,cpi_attribute5
404 ,cpi_attribute6
405 ,cpi_attribute7
406 ,cpi_attribute8
407 ,cpi_attribute9
408 ,cpi_attribute10
409 ,cpi_attribute11
410 ,cpi_attribute12
411 ,cpi_attribute13
412 ,cpi_attribute14
413 ,cpi_attribute15
414 ,cpi_attribute16
415 ,cpi_attribute17
416 ,cpi_attribute18
417 ,cpi_attribute19
418 ,cpi_attribute20
419 ,cpi_attribute21
420 ,cpi_attribute22
421 ,cpi_attribute23
422 ,cpi_attribute24
423 ,cpi_attribute25
424 ,cpi_attribute26
425 ,cpi_attribute27
426 ,cpi_attribute28
427 ,cpi_attribute29
428 ,cpi_attribute30
429 ,feedback_date
430 from ben_cwb_person_info
431 where group_per_in_ler_id = p_group_per_in_ler_id
432 for update nowait;
433 --
434 l_proc varchar2(72) := g_package||'lck';
435 --
436 Begin
437 if g_debug then
438 hr_utility.set_location('Entering:'||l_proc, 5);
439 end if;
440 --
441 hr_api.mandatory_arg_error
442 (p_api_name => l_proc
446 if g_debug then
443 ,p_argument => 'GROUP_PER_IN_LER_ID'
444 ,p_argument_value => p_group_per_in_ler_id
445 );
447 hr_utility.set_location(l_proc,6);
448 end if;
449 hr_api.mandatory_arg_error
450 (p_api_name => l_proc
451 ,p_argument => 'OBJECT_VERSION_NUMBER'
452 ,p_argument_value => p_object_version_number
453 );
454 --
455 Open C_Sel1;
456 Fetch C_Sel1 Into ben_cpi_shd.g_old_rec;
457 If C_Sel1%notfound then
458 Close C_Sel1;
459 --
460 -- The primary key is invalid therefore we must error
461 --
462 fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
463 fnd_message.raise_error;
464 End If;
465 Close C_Sel1;
466 If (p_object_version_number
467 <> ben_cpi_shd.g_old_rec.object_version_number) Then
468 fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
469 fnd_message.raise_error;
470 End If;
471 --
472 if g_debug then
473 hr_utility.set_location(' Leaving:'||l_proc, 10);
474 end if;
475 --
476 -- We need to trap the ORA LOCK exception
477 --
478 Exception
479 When HR_Api.Object_Locked then
480 --
481 -- The object is locked therefore we need to supply a meaningful
482 -- error message.
483 --
484 fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
485 fnd_message.set_token('TABLE_NAME', 'ben_cwb_person_info');
486 fnd_message.raise_error;
487 End lck;
488 --
489 -- ----------------------------------------------------------------------------
490 -- |-----------------------------< convert_args >-----------------------------|
491 -- ----------------------------------------------------------------------------
492 Function convert_args
493 (p_group_per_in_ler_id in number
494 ,p_assignment_id in number
495 ,p_person_id in number
496 ,p_supervisor_id in number
497 ,p_effective_date in date
498 ,p_full_name in varchar2
499 ,p_brief_name in varchar2
500 ,p_custom_name in varchar2
501 ,p_supervisor_full_name in varchar2
502 ,p_supervisor_brief_name in varchar2
503 ,p_supervisor_custom_name in varchar2
504 ,p_legislation_code in varchar2
505 ,p_years_employed in number
506 ,p_years_in_job in number
507 ,p_years_in_position in number
508 ,p_years_in_grade in number
509 ,p_employee_number in varchar2
510 ,p_start_date in date
511 ,p_original_start_date in date
512 ,p_adjusted_svc_date in date
513 ,p_base_salary in number
514 ,p_base_salary_change_date in date
515 ,p_payroll_name in varchar2
516 ,p_performance_rating in varchar2
517 ,p_performance_rating_type in varchar2
518 ,p_performance_rating_date in date
519 ,p_business_group_id in number
520 ,p_organization_id in number
521 ,p_job_id in number
522 ,p_grade_id in number
523 ,p_position_id in number
524 ,p_people_group_id in number
525 ,p_soft_coding_keyflex_id in number
526 ,p_location_id in number
527 ,p_pay_rate_id in number
528 ,p_assignment_status_type_id in number
529 ,p_frequency in varchar2
530 ,p_grade_annulization_factor in number
531 ,p_pay_annulization_factor in number
532 ,p_grd_min_val in number
533 ,p_grd_max_val in number
534 ,p_grd_mid_point in number
535 ,p_grd_quartile in varchar2
536 ,p_grd_comparatio in number
537 ,p_emp_category in varchar2
538 ,p_change_reason in varchar2
539 ,p_normal_hours in number
540 ,p_email_address in varchar2
541 ,p_base_salary_frequency in varchar2
542 ,p_new_assgn_ovn in number
543 ,p_new_perf_event_id in number
544 ,p_new_perf_review_id in number
545 ,p_post_process_stat_cd in varchar2
546 ,p_feedback_rating in varchar2
547 ,p_feedback_comments in varchar2
548 ,p_object_version_number in number
549 ,p_custom_segment1 in varchar2
550 ,p_custom_segment2 in varchar2
551 ,p_custom_segment3 in varchar2
552 ,p_custom_segment4 in varchar2
553 ,p_custom_segment5 in varchar2
554 ,p_custom_segment6 in varchar2
555 ,p_custom_segment7 in varchar2
556 ,p_custom_segment8 in varchar2
557 ,p_custom_segment9 in varchar2
558 ,p_custom_segment10 in varchar2
559 ,p_custom_segment11 in number
560 ,p_custom_segment12 in number
561 ,p_custom_segment13 in number
562 ,p_custom_segment14 in number
563 ,p_custom_segment15 in number
564 ,p_custom_segment16 in number
565 ,p_custom_segment17 in number
566 ,p_custom_segment18 in number
567 ,p_custom_segment19 in number
568 ,p_custom_segment20 in number
569 ,p_people_group_name in varchar2
570 ,p_people_group_segment1 in varchar2
571 ,p_people_group_segment2 in varchar2
572 ,p_people_group_segment3 in varchar2
576 ,p_people_group_segment7 in varchar2
573 ,p_people_group_segment4 in varchar2
574 ,p_people_group_segment5 in varchar2
575 ,p_people_group_segment6 in varchar2
577 ,p_people_group_segment8 in varchar2
578 ,p_people_group_segment9 in varchar2
579 ,p_people_group_segment10 in varchar2
580 ,p_people_group_segment11 in varchar2
581 ,p_ass_attribute_category in varchar2
582 ,p_ass_attribute1 in varchar2
583 ,p_ass_attribute2 in varchar2
584 ,p_ass_attribute3 in varchar2
585 ,p_ass_attribute4 in varchar2
586 ,p_ass_attribute5 in varchar2
587 ,p_ass_attribute6 in varchar2
588 ,p_ass_attribute7 in varchar2
589 ,p_ass_attribute8 in varchar2
590 ,p_ass_attribute9 in varchar2
591 ,p_ass_attribute10 in varchar2
592 ,p_ass_attribute11 in varchar2
593 ,p_ass_attribute12 in varchar2
594 ,p_ass_attribute13 in varchar2
595 ,p_ass_attribute14 in varchar2
596 ,p_ass_attribute15 in varchar2
597 ,p_ass_attribute16 in varchar2
598 ,p_ass_attribute17 in varchar2
599 ,p_ass_attribute18 in varchar2
600 ,p_ass_attribute19 in varchar2
601 ,p_ass_attribute20 in varchar2
602 ,p_ass_attribute21 in varchar2
603 ,p_ass_attribute22 in varchar2
604 ,p_ass_attribute23 in varchar2
605 ,p_ass_attribute24 in varchar2
606 ,p_ass_attribute25 in varchar2
607 ,p_ass_attribute26 in varchar2
608 ,p_ass_attribute27 in varchar2
609 ,p_ass_attribute28 in varchar2
610 ,p_ass_attribute29 in varchar2
611 ,p_ass_attribute30 in varchar2
612 ,p_ws_comments in varchar2
613 ,p_cpi_attribute_category in varchar2
614 ,p_cpi_attribute1 in varchar2
615 ,p_cpi_attribute2 in varchar2
616 ,p_cpi_attribute3 in varchar2
617 ,p_cpi_attribute4 in varchar2
618 ,p_cpi_attribute5 in varchar2
619 ,p_cpi_attribute6 in varchar2
620 ,p_cpi_attribute7 in varchar2
621 ,p_cpi_attribute8 in varchar2
622 ,p_cpi_attribute9 in varchar2
623 ,p_cpi_attribute10 in varchar2
624 ,p_cpi_attribute11 in varchar2
625 ,p_cpi_attribute12 in varchar2
626 ,p_cpi_attribute13 in varchar2
627 ,p_cpi_attribute14 in varchar2
628 ,p_cpi_attribute15 in varchar2
629 ,p_cpi_attribute16 in varchar2
630 ,p_cpi_attribute17 in varchar2
631 ,p_cpi_attribute18 in varchar2
632 ,p_cpi_attribute19 in varchar2
633 ,p_cpi_attribute20 in varchar2
634 ,p_cpi_attribute21 in varchar2
635 ,p_cpi_attribute22 in varchar2
636 ,p_cpi_attribute23 in varchar2
637 ,p_cpi_attribute24 in varchar2
638 ,p_cpi_attribute25 in varchar2
639 ,p_cpi_attribute26 in varchar2
640 ,p_cpi_attribute27 in varchar2
641 ,p_cpi_attribute28 in varchar2
642 ,p_cpi_attribute29 in varchar2
643 ,p_cpi_attribute30 in varchar2
644 ,p_feedback_date in date
645 )
646 Return g_rec_type is
647 --
648 l_rec g_rec_type;
649 --
650 Begin
651 --
652 -- Convert arguments into local l_rec structure.
653 --
654 l_rec.group_per_in_ler_id := p_group_per_in_ler_id;
655 l_rec.assignment_id := p_assignment_id;
656 l_rec.person_id := p_person_id;
657 l_rec.supervisor_id := p_supervisor_id;
658 l_rec.effective_date := p_effective_date;
659 l_rec.full_name := p_full_name;
660 l_rec.brief_name := p_brief_name;
661 l_rec.custom_name := p_custom_name;
662 l_rec.supervisor_full_name := p_supervisor_full_name;
663 l_rec.supervisor_brief_name := p_supervisor_brief_name;
664 l_rec.supervisor_custom_name := p_supervisor_custom_name;
665 l_rec.legislation_code := p_legislation_code;
666 l_rec.years_employed := p_years_employed;
667 l_rec.years_in_job := p_years_in_job;
668 l_rec.years_in_position := p_years_in_position;
669 l_rec.years_in_grade := p_years_in_grade;
670 l_rec.employee_number := p_employee_number;
671 l_rec.start_date := p_start_date;
672 l_rec.original_start_date := p_original_start_date;
673 l_rec.adjusted_svc_date := p_adjusted_svc_date;
674 l_rec.base_salary := p_base_salary;
675 l_rec.base_salary_change_date := p_base_salary_change_date;
676 l_rec.payroll_name := p_payroll_name;
677 l_rec.performance_rating := p_performance_rating;
678 l_rec.performance_rating_type := p_performance_rating_type;
679 l_rec.performance_rating_date := p_performance_rating_date;
680 l_rec.business_group_id := p_business_group_id;
681 l_rec.organization_id := p_organization_id;
682 l_rec.job_id := p_job_id;
683 l_rec.grade_id := p_grade_id;
684 l_rec.position_id := p_position_id;
685 l_rec.people_group_id := p_people_group_id;
689 l_rec.assignment_status_type_id := p_assignment_status_type_id;
686 l_rec.soft_coding_keyflex_id := p_soft_coding_keyflex_id;
687 l_rec.location_id := p_location_id;
688 l_rec.pay_rate_id := p_pay_rate_id;
690 l_rec.frequency := p_frequency;
691 l_rec.grade_annulization_factor := p_grade_annulization_factor;
692 l_rec.pay_annulization_factor := p_pay_annulization_factor;
693 l_rec.grd_min_val := p_grd_min_val;
694 l_rec.grd_max_val := p_grd_max_val;
695 l_rec.grd_mid_point := p_grd_mid_point;
696 l_rec.grd_quartile := p_grd_quartile;
697 l_rec.grd_comparatio := p_grd_comparatio;
698 l_rec.emp_category := p_emp_category;
699 l_rec.change_reason := p_change_reason;
700 l_rec.normal_hours := p_normal_hours;
701 l_rec.email_address := p_email_address;
702 l_rec.base_salary_frequency := p_base_salary_frequency;
703 l_rec.new_assgn_ovn := p_new_assgn_ovn;
704 l_rec.new_perf_event_id := p_new_perf_event_id;
705 l_rec.new_perf_review_id := p_new_perf_review_id;
706 l_rec.post_process_stat_cd := p_post_process_stat_cd;
707 l_rec.feedback_rating := p_feedback_rating;
708 l_rec.feedback_comments := p_feedback_comments;
709 l_rec.object_version_number := p_object_version_number;
710 l_rec.custom_segment1 := p_custom_segment1;
711 l_rec.custom_segment2 := p_custom_segment2;
712 l_rec.custom_segment3 := p_custom_segment3;
713 l_rec.custom_segment4 := p_custom_segment4;
714 l_rec.custom_segment5 := p_custom_segment5;
715 l_rec.custom_segment6 := p_custom_segment6;
716 l_rec.custom_segment7 := p_custom_segment7;
717 l_rec.custom_segment8 := p_custom_segment8;
718 l_rec.custom_segment9 := p_custom_segment9;
719 l_rec.custom_segment10 := p_custom_segment10;
720 l_rec.custom_segment11 := p_custom_segment11;
721 l_rec.custom_segment12 := p_custom_segment12;
722 l_rec.custom_segment13 := p_custom_segment13;
723 l_rec.custom_segment14 := p_custom_segment14;
724 l_rec.custom_segment15 := p_custom_segment15;
725 l_rec.custom_segment16 := p_custom_segment16;
726 l_rec.custom_segment17 := p_custom_segment17;
727 l_rec.custom_segment18 := p_custom_segment18;
728 l_rec.custom_segment19 := p_custom_segment19;
729 l_rec.custom_segment20 := p_custom_segment20;
730 l_rec.people_group_name := p_people_group_name;
731 l_rec.people_group_segment1 := p_people_group_segment1;
732 l_rec.people_group_segment2 := p_people_group_segment2;
733 l_rec.people_group_segment3 := p_people_group_segment3;
734 l_rec.people_group_segment4 := p_people_group_segment4;
735 l_rec.people_group_segment5 := p_people_group_segment5;
736 l_rec.people_group_segment6 := p_people_group_segment6;
737 l_rec.people_group_segment7 := p_people_group_segment7;
738 l_rec.people_group_segment8 := p_people_group_segment8;
739 l_rec.people_group_segment9 := p_people_group_segment9;
740 l_rec.people_group_segment10 := p_people_group_segment10;
741 l_rec.people_group_segment11 := p_people_group_segment11;
742 l_rec.ass_attribute_category := p_ass_attribute_category;
743 l_rec.ass_attribute1 := p_ass_attribute1;
744 l_rec.ass_attribute2 := p_ass_attribute2;
745 l_rec.ass_attribute3 := p_ass_attribute3;
746 l_rec.ass_attribute4 := p_ass_attribute4;
747 l_rec.ass_attribute5 := p_ass_attribute5;
748 l_rec.ass_attribute6 := p_ass_attribute6;
749 l_rec.ass_attribute7 := p_ass_attribute7;
750 l_rec.ass_attribute8 := p_ass_attribute8;
751 l_rec.ass_attribute9 := p_ass_attribute9;
752 l_rec.ass_attribute10 := p_ass_attribute10;
753 l_rec.ass_attribute11 := p_ass_attribute11;
754 l_rec.ass_attribute12 := p_ass_attribute12;
755 l_rec.ass_attribute13 := p_ass_attribute13;
756 l_rec.ass_attribute14 := p_ass_attribute14;
757 l_rec.ass_attribute15 := p_ass_attribute15;
758 l_rec.ass_attribute16 := p_ass_attribute16;
759 l_rec.ass_attribute17 := p_ass_attribute17;
760 l_rec.ass_attribute18 := p_ass_attribute18;
761 l_rec.ass_attribute19 := p_ass_attribute19;
762 l_rec.ass_attribute20 := p_ass_attribute20;
763 l_rec.ass_attribute21 := p_ass_attribute21;
764 l_rec.ass_attribute22 := p_ass_attribute22;
765 l_rec.ass_attribute23 := p_ass_attribute23;
766 l_rec.ass_attribute24 := p_ass_attribute24;
767 l_rec.ass_attribute25 := p_ass_attribute25;
768 l_rec.ass_attribute26 := p_ass_attribute26;
769 l_rec.ass_attribute27 := p_ass_attribute27;
770 l_rec.ass_attribute28 := p_ass_attribute28;
771 l_rec.ass_attribute29 := p_ass_attribute29;
772 l_rec.ass_attribute30 := p_ass_attribute30;
773 l_rec.ws_comments := p_ws_comments;
774 l_rec.cpi_attribute_category := p_cpi_attribute_category;
775 l_rec.cpi_attribute1 := p_cpi_attribute1;
776 l_rec.cpi_attribute2 := p_cpi_attribute2;
777 l_rec.cpi_attribute3 := p_cpi_attribute3;
778 l_rec.cpi_attribute4 := p_cpi_attribute4;
779 l_rec.cpi_attribute5 := p_cpi_attribute5;
780 l_rec.cpi_attribute6 := p_cpi_attribute6;
781 l_rec.cpi_attribute7 := p_cpi_attribute7;
782 l_rec.cpi_attribute8 := p_cpi_attribute8;
783 l_rec.cpi_attribute9 := p_cpi_attribute9;
784 l_rec.cpi_attribute10 := p_cpi_attribute10;
785 l_rec.cpi_attribute11 := p_cpi_attribute11;
786 l_rec.cpi_attribute12 := p_cpi_attribute12;
787 l_rec.cpi_attribute13 := p_cpi_attribute13;
788 l_rec.cpi_attribute14 := p_cpi_attribute14;
789 l_rec.cpi_attribute15 := p_cpi_attribute15;
790 l_rec.cpi_attribute16 := p_cpi_attribute16;
791 l_rec.cpi_attribute17 := p_cpi_attribute17;
792 l_rec.cpi_attribute18 := p_cpi_attribute18;
793 l_rec.cpi_attribute19 := p_cpi_attribute19;
794 l_rec.cpi_attribute20 := p_cpi_attribute20;
795 l_rec.cpi_attribute21 := p_cpi_attribute21;
796 l_rec.cpi_attribute22 := p_cpi_attribute22;
797 l_rec.cpi_attribute23 := p_cpi_attribute23;
798 l_rec.cpi_attribute24 := p_cpi_attribute24;
799 l_rec.cpi_attribute25 := p_cpi_attribute25;
800 l_rec.cpi_attribute26 := p_cpi_attribute26;
801 l_rec.cpi_attribute27 := p_cpi_attribute27;
802 l_rec.cpi_attribute28 := p_cpi_attribute28;
803 l_rec.cpi_attribute29 := p_cpi_attribute29;
804 l_rec.cpi_attribute30 := p_cpi_attribute30;
805 l_rec.feedback_date := p_feedback_date;
806 --
807 -- Return the plsql record structure.
808 --
809 Return(l_rec);
810 --
811 End convert_args;
812 --
813 end ben_cpi_shd;