[Home] [Help]
PACKAGE BODY: APPS.BEN_CPI_UPD
Source
1 Package Body ben_cpi_upd as
2 /* $Header: becpirhi.pkb 120.0 2005/05/28 01:13 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ben_cpi_upd.'; -- Global package name
9 g_debug boolean := hr_utility.debug_enabled;
10 --
11 -- ----------------------------------------------------------------------------
12 -- |------------------------------< update_dml >------------------------------|
13 -- ----------------------------------------------------------------------------
14 -- {Start Of Comments}
15 --
16 -- Description:
17 -- This procedure controls the actual dml update logic. The processing of
18 -- this procedure is:
19 -- 1) Increment the object_version_number by 1 if the object_version_number
20 -- is defined as an attribute for this entity.
21 -- 2) To set and unset the g_api_dml status as required (as we are about to
22 -- perform dml).
23 -- 3) To update the specified row in the schema using the primary key in
24 -- the predicates.
25 -- 4) To trap any constraint violations that may have occurred.
26 -- 5) To raise any other errors.
27 --
28 -- Prerequisites:
29 -- This is an internal private procedure which must be called from the upd
30 -- procedure.
31 --
32 -- In Parameters:
33 -- A Pl/Sql record structre.
34 --
35 -- Post Success:
36 -- The specified row will be updated in the schema.
37 --
38 -- Post Failure:
39 -- On the update dml failure it is important to note that we always reset the
40 -- g_api_dml status to false.
41 -- If a check, unique or parent integrity constraint violation is raised the
42 -- constraint_error procedure will be called.
43 -- If any other error is reported, the error will be raised after the
44 -- g_api_dml status is reset.
45 --
46 -- Developer Implementation Notes:
47 -- The update 'set' attribute list should be modified if any of your
48 -- attributes are not updateable.
49 --
50 -- Access Status:
51 -- Internal Row Handler Use Only.
52 --
53 -- {End Of Comments}
54 -- ----------------------------------------------------------------------------
55 Procedure update_dml
56 (p_rec in out nocopy ben_cpi_shd.g_rec_type
57 ) is
58 --
59 l_proc varchar2(72) := g_package||'update_dml';
60 --
61 Begin
62 if g_debug then
63 hr_utility.set_location('Entering:'||l_proc, 5);
64 end if;
65 --
66 -- Increment the object version
67 p_rec.object_version_number := p_rec.object_version_number + 1;
68 --
69 ben_cpi_shd.g_api_dml := true; -- Set the api dml status
70 --
71 -- Update the ben_cwb_person_info Row
72 --
73 update ben_cwb_person_info
74 set
75 assignment_id = p_rec.assignment_id
76 ,person_id = p_rec.person_id
77 ,supervisor_id = p_rec.supervisor_id
78 ,effective_date = p_rec.effective_date
79 ,full_name = p_rec.full_name
80 ,brief_name = p_rec.brief_name
81 ,custom_name = p_rec.custom_name
82 ,supervisor_full_name = p_rec.supervisor_full_name
83 ,supervisor_brief_name = p_rec.supervisor_brief_name
84 ,supervisor_custom_name = p_rec.supervisor_custom_name
85 ,legislation_code = p_rec.legislation_code
86 ,years_employed = p_rec.years_employed
87 ,years_in_job = p_rec.years_in_job
88 ,years_in_position = p_rec.years_in_position
89 ,years_in_grade = p_rec.years_in_grade
90 ,employee_number = p_rec.employee_number
91 ,start_date = p_rec.start_date
92 ,original_start_date = p_rec.original_start_date
93 ,adjusted_svc_date = p_rec.adjusted_svc_date
94 ,base_salary = p_rec.base_salary
95 ,base_salary_change_date = p_rec.base_salary_change_date
96 ,payroll_name = p_rec.payroll_name
97 ,performance_rating = p_rec.performance_rating
98 ,performance_rating_type = p_rec.performance_rating_type
99 ,performance_rating_date = p_rec.performance_rating_date
100 ,business_group_id = p_rec.business_group_id
101 ,organization_id = p_rec.organization_id
102 ,job_id = p_rec.job_id
103 ,grade_id = p_rec.grade_id
104 ,position_id = p_rec.position_id
105 ,people_group_id = p_rec.people_group_id
106 ,soft_coding_keyflex_id = p_rec.soft_coding_keyflex_id
107 ,location_id = p_rec.location_id
108 ,pay_rate_id = p_rec.pay_rate_id
109 ,assignment_status_type_id = p_rec.assignment_status_type_id
110 ,frequency = p_rec.frequency
111 ,grade_annulization_factor = p_rec.grade_annulization_factor
112 ,pay_annulization_factor = p_rec.pay_annulization_factor
113 ,grd_min_val = p_rec.grd_min_val
114 ,grd_max_val = p_rec.grd_max_val
115 ,grd_mid_point = p_rec.grd_mid_point
116 ,grd_quartile = p_rec.grd_quartile
117 ,grd_comparatio = p_rec.grd_comparatio
118 ,emp_category = p_rec.emp_category
119 ,change_reason = p_rec.change_reason
120 ,normal_hours = p_rec.normal_hours
121 ,email_address = p_rec.email_address
122 ,base_salary_frequency = p_rec.base_salary_frequency
123 ,new_assgn_ovn = p_rec.new_assgn_ovn
124 ,new_perf_event_id = p_rec.new_perf_event_id
125 ,new_perf_review_id = p_rec.new_perf_review_id
126 ,post_process_stat_cd = p_rec.post_process_stat_cd
127 ,feedback_rating = p_rec.feedback_rating
128 ,feedback_comments = p_rec.feedback_comments
129 ,object_version_number = p_rec.object_version_number
130 ,custom_segment1 = p_rec.custom_segment1
131 ,custom_segment2 = p_rec.custom_segment2
132 ,custom_segment3 = p_rec.custom_segment3
133 ,custom_segment4 = p_rec.custom_segment4
134 ,custom_segment5 = p_rec.custom_segment5
135 ,custom_segment6 = p_rec.custom_segment6
136 ,custom_segment7 = p_rec.custom_segment7
137 ,custom_segment8 = p_rec.custom_segment8
138 ,custom_segment9 = p_rec.custom_segment9
139 ,custom_segment10 = p_rec.custom_segment10
140 ,custom_segment11 = p_rec.custom_segment11
141 ,custom_segment12 = p_rec.custom_segment12
142 ,custom_segment13 = p_rec.custom_segment13
143 ,custom_segment14 = p_rec.custom_segment14
144 ,custom_segment15 = p_rec.custom_segment15
145 ,custom_segment16 = p_rec.custom_segment16
146 ,custom_segment17 = p_rec.custom_segment17
147 ,custom_segment18 = p_rec.custom_segment18
148 ,custom_segment19 = p_rec.custom_segment19
149 ,custom_segment20 = p_rec.custom_segment20
150 ,people_group_name = p_rec.people_group_name
151 ,people_group_segment1 = p_rec.people_group_segment1
152 ,people_group_segment2 = p_rec.people_group_segment2
153 ,people_group_segment3 = p_rec.people_group_segment3
154 ,people_group_segment4 = p_rec.people_group_segment4
155 ,people_group_segment5 = p_rec.people_group_segment5
156 ,people_group_segment6 = p_rec.people_group_segment6
157 ,people_group_segment7 = p_rec.people_group_segment7
158 ,people_group_segment8 = p_rec.people_group_segment8
159 ,people_group_segment9 = p_rec.people_group_segment9
160 ,people_group_segment10 = p_rec.people_group_segment10
161 ,people_group_segment11 = p_rec.people_group_segment11
162 ,ass_attribute_category = p_rec.ass_attribute_category
163 ,ass_attribute1 = p_rec.ass_attribute1
164 ,ass_attribute2 = p_rec.ass_attribute2
165 ,ass_attribute3 = p_rec.ass_attribute3
166 ,ass_attribute4 = p_rec.ass_attribute4
167 ,ass_attribute5 = p_rec.ass_attribute5
168 ,ass_attribute6 = p_rec.ass_attribute6
169 ,ass_attribute7 = p_rec.ass_attribute7
170 ,ass_attribute8 = p_rec.ass_attribute8
171 ,ass_attribute9 = p_rec.ass_attribute9
172 ,ass_attribute10 = p_rec.ass_attribute10
173 ,ass_attribute11 = p_rec.ass_attribute11
174 ,ass_attribute12 = p_rec.ass_attribute12
175 ,ass_attribute13 = p_rec.ass_attribute13
176 ,ass_attribute14 = p_rec.ass_attribute14
177 ,ass_attribute15 = p_rec.ass_attribute15
178 ,ass_attribute16 = p_rec.ass_attribute16
179 ,ass_attribute17 = p_rec.ass_attribute17
180 ,ass_attribute18 = p_rec.ass_attribute18
181 ,ass_attribute19 = p_rec.ass_attribute19
182 ,ass_attribute20 = p_rec.ass_attribute20
183 ,ass_attribute21 = p_rec.ass_attribute21
184 ,ass_attribute22 = p_rec.ass_attribute22
185 ,ass_attribute23 = p_rec.ass_attribute23
186 ,ass_attribute24 = p_rec.ass_attribute24
187 ,ass_attribute25 = p_rec.ass_attribute25
188 ,ass_attribute26 = p_rec.ass_attribute26
189 ,ass_attribute27 = p_rec.ass_attribute27
190 ,ass_attribute28 = p_rec.ass_attribute28
191 ,ass_attribute29 = p_rec.ass_attribute29
192 ,ass_attribute30 = p_rec.ass_attribute30
193 ,ws_comments = p_rec.ws_comments
194 ,cpi_attribute_category = p_rec.cpi_attribute_category
195 ,cpi_attribute1 = p_rec.cpi_attribute1
196 ,cpi_attribute2 = p_rec.cpi_attribute2
197 ,cpi_attribute3 = p_rec.cpi_attribute3
198 ,cpi_attribute4 = p_rec.cpi_attribute4
199 ,cpi_attribute5 = p_rec.cpi_attribute5
200 ,cpi_attribute6 = p_rec.cpi_attribute6
201 ,cpi_attribute7 = p_rec.cpi_attribute7
202 ,cpi_attribute8 = p_rec.cpi_attribute8
203 ,cpi_attribute9 = p_rec.cpi_attribute9
204 ,cpi_attribute10 = p_rec.cpi_attribute10
205 ,cpi_attribute11 = p_rec.cpi_attribute11
206 ,cpi_attribute12 = p_rec.cpi_attribute12
207 ,cpi_attribute13 = p_rec.cpi_attribute13
208 ,cpi_attribute14 = p_rec.cpi_attribute14
209 ,cpi_attribute15 = p_rec.cpi_attribute15
210 ,cpi_attribute16 = p_rec.cpi_attribute16
211 ,cpi_attribute17 = p_rec.cpi_attribute17
212 ,cpi_attribute18 = p_rec.cpi_attribute18
213 ,cpi_attribute19 = p_rec.cpi_attribute19
214 ,cpi_attribute20 = p_rec.cpi_attribute20
215 ,cpi_attribute21 = p_rec.cpi_attribute21
216 ,cpi_attribute22 = p_rec.cpi_attribute22
217 ,cpi_attribute23 = p_rec.cpi_attribute23
218 ,cpi_attribute24 = p_rec.cpi_attribute24
219 ,cpi_attribute25 = p_rec.cpi_attribute25
220 ,cpi_attribute26 = p_rec.cpi_attribute26
221 ,cpi_attribute27 = p_rec.cpi_attribute27
222 ,cpi_attribute28 = p_rec.cpi_attribute28
223 ,cpi_attribute29 = p_rec.cpi_attribute29
224 ,cpi_attribute30 = p_rec.cpi_attribute30
225 ,feedback_date = p_rec.feedback_date
226 where group_per_in_ler_id = p_rec.group_per_in_ler_id;
227 --
228 ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
229 --
230 if g_debug then
231 hr_utility.set_location(' Leaving:'||l_proc, 10);
232 end if;
233 --
234 Exception
235 When hr_api.check_integrity_violated Then
236 -- A check constraint has been violated
237 ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
238 ben_cpi_shd.constraint_error
239 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
240 When hr_api.parent_integrity_violated Then
241 -- Parent integrity has been violated
242 ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
243 ben_cpi_shd.constraint_error
244 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
245 When hr_api.unique_integrity_violated Then
246 -- Unique integrity has been violated
247 ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
248 ben_cpi_shd.constraint_error
249 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
250 When Others Then
251 ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
252 Raise;
253 End update_dml;
254 --
255 -- ----------------------------------------------------------------------------
256 -- |------------------------------< pre_update >------------------------------|
257 -- ----------------------------------------------------------------------------
258 -- {Start Of Comments}
259 --
260 -- Description:
261 -- This private procedure contains any processing which is required before
262 -- the update dml.
263 --
264 -- Prerequisites:
265 -- This is an internal procedure which is called from the upd procedure.
266 --
267 -- In Parameters:
268 -- A Pl/Sql record structure.
269 --
270 -- Post Success:
271 -- Processing continues.
272 --
273 -- Post Failure:
274 -- If an error has occurred, an error message and exception wil be raised
275 -- but not handled.
276 --
277 -- Developer Implementation Notes:
278 -- Any pre-processing required before the update dml is issued should be
279 -- coded within this procedure. It is important to note that any 3rd party
280 -- maintenance should be reviewed before placing in this procedure.
281 --
282 -- Access Status:
283 -- Internal Row Handler Use Only.
284 --
285 -- {End Of Comments}
286 -- ----------------------------------------------------------------------------
287 Procedure pre_update
288 (p_rec in ben_cpi_shd.g_rec_type
289 ) is
290 --
291 l_proc varchar2(72) := g_package||'pre_update';
292 --
293 Begin
294 if g_debug then
295 hr_utility.set_location('Entering:'||l_proc, 5);
296 end if;
297 --
298 if g_debug then
299 hr_utility.set_location(' Leaving:'||l_proc, 10);
300 end if;
301 End pre_update;
302 --
303 -- ----------------------------------------------------------------------------
304 -- |-----------------------------< post_update >------------------------------|
305 -- ----------------------------------------------------------------------------
306 -- {Start Of Comments}
307 --
308 -- Description:
309 -- This private procedure contains any processing which is required after
310 -- the update dml.
311 --
312 -- Prerequisites:
313 -- This is an internal procedure which is called from the upd procedure.
314 --
315 -- In Parameters:
316 -- A Pl/Sql record structure.
317 --
318 -- Post Success:
319 -- Processing continues.
320 --
321 -- Post Failure:
322 -- If an error has occurred, an error message and exception will be raised
323 -- but not handled.
324 --
325 -- Developer Implementation Notes:
326 -- Any post-processing required after the update dml is issued should be
327 -- coded within this procedure. It is important to note that any 3rd party
328 -- maintenance should be reviewed before placing in this procedure.
329 --
330 -- Access Status:
331 -- Internal Row Handler Use Only.
332 --
333 -- {End Of Comments}
334 -- ----------------------------------------------------------------------------
335 Procedure post_update
339 l_proc varchar2(72) := g_package||'post_update';
336 (p_rec in ben_cpi_shd.g_rec_type
337 ) is
338 --
340 --
341 Begin
342 if g_debug then
343 hr_utility.set_location('Entering:'||l_proc, 5);
344 end if;
345 begin
346 --
347 ben_cpi_rku.after_update
348 (p_group_per_in_ler_id
349 => p_rec.group_per_in_ler_id
350 ,p_assignment_id
351 => p_rec.assignment_id
352 ,p_person_id
353 => p_rec.person_id
354 ,p_supervisor_id
355 => p_rec.supervisor_id
356 ,p_effective_date
357 => p_rec.effective_date
358 ,p_full_name
359 => p_rec.full_name
360 ,p_brief_name
361 => p_rec.brief_name
362 ,p_custom_name
363 => p_rec.custom_name
364 ,p_supervisor_full_name
365 => p_rec.supervisor_full_name
366 ,p_supervisor_brief_name
367 => p_rec.supervisor_brief_name
368 ,p_supervisor_custom_name
369 => p_rec.supervisor_custom_name
370 ,p_legislation_code
371 => p_rec.legislation_code
372 ,p_years_employed
373 => p_rec.years_employed
374 ,p_years_in_job
375 => p_rec.years_in_job
376 ,p_years_in_position
377 => p_rec.years_in_position
378 ,p_years_in_grade
379 => p_rec.years_in_grade
380 ,p_employee_number
381 => p_rec.employee_number
382 ,p_start_date
383 => p_rec.start_date
384 ,p_original_start_date
385 => p_rec.original_start_date
386 ,p_adjusted_svc_date
387 => p_rec.adjusted_svc_date
388 ,p_base_salary
389 => p_rec.base_salary
390 ,p_base_salary_change_date
391 => p_rec.base_salary_change_date
392 ,p_payroll_name
393 => p_rec.payroll_name
394 ,p_performance_rating
395 => p_rec.performance_rating
396 ,p_performance_rating_type
397 => p_rec.performance_rating_type
398 ,p_performance_rating_date
399 => p_rec.performance_rating_date
400 ,p_business_group_id
401 => p_rec.business_group_id
402 ,p_organization_id
403 => p_rec.organization_id
404 ,p_job_id
405 => p_rec.job_id
406 ,p_grade_id
407 => p_rec.grade_id
408 ,p_position_id
409 => p_rec.position_id
410 ,p_people_group_id
411 => p_rec.people_group_id
412 ,p_soft_coding_keyflex_id
413 => p_rec.soft_coding_keyflex_id
414 ,p_location_id
415 => p_rec.location_id
416 ,p_pay_rate_id
417 => p_rec.pay_rate_id
418 ,p_assignment_status_type_id
419 => p_rec.assignment_status_type_id
420 ,p_frequency
421 => p_rec.frequency
422 ,p_grade_annulization_factor
423 => p_rec.grade_annulization_factor
424 ,p_pay_annulization_factor
425 => p_rec.pay_annulization_factor
426 ,p_grd_min_val
427 => p_rec.grd_min_val
428 ,p_grd_max_val
429 => p_rec.grd_max_val
430 ,p_grd_mid_point
431 => p_rec.grd_mid_point
432 ,p_grd_quartile
433 => p_rec.grd_quartile
434 ,p_grd_comparatio
435 => p_rec.grd_comparatio
436 ,p_emp_category
437 => p_rec.emp_category
438 ,p_change_reason
439 => p_rec.change_reason
440 ,p_normal_hours
441 => p_rec.normal_hours
442 ,p_email_address
443 => p_rec.email_address
444 ,p_base_salary_frequency
445 => p_rec.base_salary_frequency
446 ,p_new_assgn_ovn
447 => p_rec.new_assgn_ovn
448 ,p_new_perf_event_id
449 => p_rec.new_perf_event_id
450 ,p_new_perf_review_id
451 => p_rec.new_perf_review_id
452 ,p_post_process_stat_cd
453 => p_rec.post_process_stat_cd
454 ,p_feedback_rating
455 => p_rec.feedback_rating
456 ,p_feedback_comments
457 => p_rec.feedback_comments
458 ,p_object_version_number
459 => p_rec.object_version_number
460 ,p_custom_segment1
461 => p_rec.custom_segment1
462 ,p_custom_segment2
463 => p_rec.custom_segment2
464 ,p_custom_segment3
465 => p_rec.custom_segment3
466 ,p_custom_segment4
467 => p_rec.custom_segment4
468 ,p_custom_segment5
469 => p_rec.custom_segment5
470 ,p_custom_segment6
471 => p_rec.custom_segment6
472 ,p_custom_segment7
473 => p_rec.custom_segment7
474 ,p_custom_segment8
475 => p_rec.custom_segment8
476 ,p_custom_segment9
477 => p_rec.custom_segment9
478 ,p_custom_segment10
479 => p_rec.custom_segment10
480 ,p_custom_segment11
481 => p_rec.custom_segment11
482 ,p_custom_segment12
483 => p_rec.custom_segment12
484 ,p_custom_segment13
485 => p_rec.custom_segment13
486 ,p_custom_segment14
487 => p_rec.custom_segment14
488 ,p_custom_segment15
489 => p_rec.custom_segment15
490 ,p_custom_segment16
491 => p_rec.custom_segment16
492 ,p_custom_segment17
493 => p_rec.custom_segment17
494 ,p_custom_segment18
495 => p_rec.custom_segment18
496 ,p_custom_segment19
497 => p_rec.custom_segment19
498 ,p_custom_segment20
499 => p_rec.custom_segment20
500 ,p_people_group_name
501 => p_rec.people_group_name
502 ,p_people_group_segment1
503 => p_rec.people_group_segment1
504 ,p_people_group_segment2
508 ,p_people_group_segment4
505 => p_rec.people_group_segment2
506 ,p_people_group_segment3
507 => p_rec.people_group_segment3
509 => p_rec.people_group_segment4
510 ,p_people_group_segment5
511 => p_rec.people_group_segment5
512 ,p_people_group_segment6
513 => p_rec.people_group_segment6
514 ,p_people_group_segment7
515 => p_rec.people_group_segment7
516 ,p_people_group_segment8
517 => p_rec.people_group_segment8
518 ,p_people_group_segment9
519 => p_rec.people_group_segment9
520 ,p_people_group_segment10
521 => p_rec.people_group_segment10
522 ,p_people_group_segment11
523 => p_rec.people_group_segment11
524 ,p_ass_attribute_category
525 => p_rec.ass_attribute_category
526 ,p_ass_attribute1
527 => p_rec.ass_attribute1
528 ,p_ass_attribute2
529 => p_rec.ass_attribute2
530 ,p_ass_attribute3
531 => p_rec.ass_attribute3
532 ,p_ass_attribute4
533 => p_rec.ass_attribute4
534 ,p_ass_attribute5
535 => p_rec.ass_attribute5
536 ,p_ass_attribute6
537 => p_rec.ass_attribute6
538 ,p_ass_attribute7
539 => p_rec.ass_attribute7
540 ,p_ass_attribute8
541 => p_rec.ass_attribute8
542 ,p_ass_attribute9
543 => p_rec.ass_attribute9
544 ,p_ass_attribute10
545 => p_rec.ass_attribute10
546 ,p_ass_attribute11
547 => p_rec.ass_attribute11
548 ,p_ass_attribute12
549 => p_rec.ass_attribute12
550 ,p_ass_attribute13
551 => p_rec.ass_attribute13
552 ,p_ass_attribute14
553 => p_rec.ass_attribute14
554 ,p_ass_attribute15
555 => p_rec.ass_attribute15
556 ,p_ass_attribute16
557 => p_rec.ass_attribute16
558 ,p_ass_attribute17
559 => p_rec.ass_attribute17
560 ,p_ass_attribute18
561 => p_rec.ass_attribute18
562 ,p_ass_attribute19
563 => p_rec.ass_attribute19
564 ,p_ass_attribute20
565 => p_rec.ass_attribute20
566 ,p_ass_attribute21
567 => p_rec.ass_attribute21
568 ,p_ass_attribute22
569 => p_rec.ass_attribute22
570 ,p_ass_attribute23
571 => p_rec.ass_attribute23
572 ,p_ass_attribute24
573 => p_rec.ass_attribute24
574 ,p_ass_attribute25
575 => p_rec.ass_attribute25
576 ,p_ass_attribute26
577 => p_rec.ass_attribute26
578 ,p_ass_attribute27
579 => p_rec.ass_attribute27
580 ,p_ass_attribute28
581 => p_rec.ass_attribute28
582 ,p_ass_attribute29
583 => p_rec.ass_attribute29
584 ,p_ass_attribute30
585 => p_rec.ass_attribute30
586 ,p_ws_comments
587 => p_rec.ws_comments
588 ,p_cpi_attribute_category
589 => p_rec.cpi_attribute_category
590 ,p_cpi_attribute1
591 => p_rec.cpi_attribute1
592 ,p_cpi_attribute2
593 => p_rec.cpi_attribute2
594 ,p_cpi_attribute3
595 => p_rec.cpi_attribute3
596 ,p_cpi_attribute4
597 => p_rec.cpi_attribute4
598 ,p_cpi_attribute5
599 => p_rec.cpi_attribute5
600 ,p_cpi_attribute6
601 => p_rec.cpi_attribute6
602 ,p_cpi_attribute7
603 => p_rec.cpi_attribute7
604 ,p_cpi_attribute8
605 => p_rec.cpi_attribute8
606 ,p_cpi_attribute9
607 => p_rec.cpi_attribute9
608 ,p_cpi_attribute10
609 => p_rec.cpi_attribute10
610 ,p_cpi_attribute11
611 => p_rec.cpi_attribute11
612 ,p_cpi_attribute12
613 => p_rec.cpi_attribute12
614 ,p_cpi_attribute13
615 => p_rec.cpi_attribute13
616 ,p_cpi_attribute14
617 => p_rec.cpi_attribute14
618 ,p_cpi_attribute15
619 => p_rec.cpi_attribute15
620 ,p_cpi_attribute16
621 => p_rec.cpi_attribute16
622 ,p_cpi_attribute17
623 => p_rec.cpi_attribute17
624 ,p_cpi_attribute18
625 => p_rec.cpi_attribute18
626 ,p_cpi_attribute19
627 => p_rec.cpi_attribute19
628 ,p_cpi_attribute20
629 => p_rec.cpi_attribute20
630 ,p_cpi_attribute21
631 => p_rec.cpi_attribute21
632 ,p_cpi_attribute22
633 => p_rec.cpi_attribute22
634 ,p_cpi_attribute23
635 => p_rec.cpi_attribute23
636 ,p_cpi_attribute24
637 => p_rec.cpi_attribute24
638 ,p_cpi_attribute25
639 => p_rec.cpi_attribute25
640 ,p_cpi_attribute26
641 => p_rec.cpi_attribute26
642 ,p_cpi_attribute27
643 => p_rec.cpi_attribute27
644 ,p_cpi_attribute28
645 => p_rec.cpi_attribute28
646 ,p_cpi_attribute29
647 => p_rec.cpi_attribute29
648 ,p_cpi_attribute30
649 => p_rec.cpi_attribute30
650 ,p_feedback_date
651 => p_rec.feedback_date
652 ,p_assignment_id_o
653 => ben_cpi_shd.g_old_rec.assignment_id
654 ,p_person_id_o
655 => ben_cpi_shd.g_old_rec.person_id
656 ,p_supervisor_id_o
657 => ben_cpi_shd.g_old_rec.supervisor_id
658 ,p_effective_date_o
659 => ben_cpi_shd.g_old_rec.effective_date
660 ,p_full_name_o
661 => ben_cpi_shd.g_old_rec.full_name
662 ,p_brief_name_o
663 => ben_cpi_shd.g_old_rec.brief_name
664 ,p_custom_name_o
665 => ben_cpi_shd.g_old_rec.custom_name
666 ,p_supervisor_full_name_o
667 => ben_cpi_shd.g_old_rec.supervisor_full_name
668 ,p_supervisor_brief_name_o
672 ,p_legislation_code_o
669 => ben_cpi_shd.g_old_rec.supervisor_brief_name
670 ,p_supervisor_custom_name_o
671 => ben_cpi_shd.g_old_rec.supervisor_custom_name
673 => ben_cpi_shd.g_old_rec.legislation_code
674 ,p_years_employed_o
675 => ben_cpi_shd.g_old_rec.years_employed
676 ,p_years_in_job_o
677 => ben_cpi_shd.g_old_rec.years_in_job
678 ,p_years_in_position_o
679 => ben_cpi_shd.g_old_rec.years_in_position
680 ,p_years_in_grade_o
681 => ben_cpi_shd.g_old_rec.years_in_grade
682 ,p_employee_number_o
683 => ben_cpi_shd.g_old_rec.employee_number
684 ,p_start_date_o
685 => ben_cpi_shd.g_old_rec.start_date
686 ,p_original_start_date_o
687 => ben_cpi_shd.g_old_rec.original_start_date
688 ,p_adjusted_svc_date_o
689 => ben_cpi_shd.g_old_rec.adjusted_svc_date
690 ,p_base_salary_o
691 => ben_cpi_shd.g_old_rec.base_salary
692 ,p_base_salary_change_date_o
693 => ben_cpi_shd.g_old_rec.base_salary_change_date
694 ,p_payroll_name_o
695 => ben_cpi_shd.g_old_rec.payroll_name
696 ,p_performance_rating_o
697 => ben_cpi_shd.g_old_rec.performance_rating
698 ,p_performance_rating_type_o
699 => ben_cpi_shd.g_old_rec.performance_rating_type
700 ,p_performance_rating_date_o
701 => ben_cpi_shd.g_old_rec.performance_rating_date
702 ,p_business_group_id_o
703 => ben_cpi_shd.g_old_rec.business_group_id
704 ,p_organization_id_o
705 => ben_cpi_shd.g_old_rec.organization_id
706 ,p_job_id_o
707 => ben_cpi_shd.g_old_rec.job_id
708 ,p_grade_id_o
709 => ben_cpi_shd.g_old_rec.grade_id
710 ,p_position_id_o
711 => ben_cpi_shd.g_old_rec.position_id
712 ,p_people_group_id_o
713 => ben_cpi_shd.g_old_rec.people_group_id
714 ,p_soft_coding_keyflex_id_o
715 => ben_cpi_shd.g_old_rec.soft_coding_keyflex_id
716 ,p_location_id_o
717 => ben_cpi_shd.g_old_rec.location_id
718 ,p_pay_rate_id_o
719 => ben_cpi_shd.g_old_rec.pay_rate_id
720 ,p_assignment_status_type_id_o
721 => ben_cpi_shd.g_old_rec.assignment_status_type_id
722 ,p_frequency_o
723 => ben_cpi_shd.g_old_rec.frequency
724 ,p_grade_annulization_factor_o
725 => ben_cpi_shd.g_old_rec.grade_annulization_factor
726 ,p_pay_annulization_factor_o
727 => ben_cpi_shd.g_old_rec.pay_annulization_factor
728 ,p_grd_min_val_o
729 => ben_cpi_shd.g_old_rec.grd_min_val
730 ,p_grd_max_val_o
731 => ben_cpi_shd.g_old_rec.grd_max_val
732 ,p_grd_mid_point_o
733 => ben_cpi_shd.g_old_rec.grd_mid_point
734 ,p_grd_quartile_o
735 => ben_cpi_shd.g_old_rec.grd_quartile
736 ,p_grd_comparatio_o
737 => ben_cpi_shd.g_old_rec.grd_comparatio
738 ,p_emp_category_o
739 => ben_cpi_shd.g_old_rec.emp_category
740 ,p_change_reason_o
741 => ben_cpi_shd.g_old_rec.change_reason
742 ,p_normal_hours_o
743 => ben_cpi_shd.g_old_rec.normal_hours
744 ,p_email_address_o
745 => ben_cpi_shd.g_old_rec.email_address
746 ,p_base_salary_frequency_o
747 => ben_cpi_shd.g_old_rec.base_salary_frequency
748 ,p_new_assgn_ovn_o
749 => ben_cpi_shd.g_old_rec.new_assgn_ovn
750 ,p_new_perf_event_id_o
751 => ben_cpi_shd.g_old_rec.new_perf_event_id
752 ,p_new_perf_review_id_o
753 => ben_cpi_shd.g_old_rec.new_perf_review_id
754 ,p_post_process_stat_cd_o
755 => ben_cpi_shd.g_old_rec.post_process_stat_cd
756 ,p_feedback_rating_o
757 => ben_cpi_shd.g_old_rec.feedback_rating
758 ,p_feedback_comments_o
759 => ben_cpi_shd.g_old_rec.feedback_comments
760 ,p_object_version_number_o
761 => ben_cpi_shd.g_old_rec.object_version_number
762 ,p_custom_segment1_o
763 => ben_cpi_shd.g_old_rec.custom_segment1
764 ,p_custom_segment2_o
765 => ben_cpi_shd.g_old_rec.custom_segment2
766 ,p_custom_segment3_o
767 => ben_cpi_shd.g_old_rec.custom_segment3
768 ,p_custom_segment4_o
769 => ben_cpi_shd.g_old_rec.custom_segment4
770 ,p_custom_segment5_o
771 => ben_cpi_shd.g_old_rec.custom_segment5
772 ,p_custom_segment6_o
773 => ben_cpi_shd.g_old_rec.custom_segment6
774 ,p_custom_segment7_o
775 => ben_cpi_shd.g_old_rec.custom_segment7
776 ,p_custom_segment8_o
777 => ben_cpi_shd.g_old_rec.custom_segment8
778 ,p_custom_segment9_o
779 => ben_cpi_shd.g_old_rec.custom_segment9
780 ,p_custom_segment10_o
781 => ben_cpi_shd.g_old_rec.custom_segment10
782 ,p_custom_segment11_o
783 => ben_cpi_shd.g_old_rec.custom_segment11
784 ,p_custom_segment12_o
785 => ben_cpi_shd.g_old_rec.custom_segment12
786 ,p_custom_segment13_o
787 => ben_cpi_shd.g_old_rec.custom_segment13
788 ,p_custom_segment14_o
789 => ben_cpi_shd.g_old_rec.custom_segment14
790 ,p_custom_segment15_o
791 => ben_cpi_shd.g_old_rec.custom_segment15
792 ,p_custom_segment16_o
793 => ben_cpi_shd.g_old_rec.custom_segment16
794 ,p_custom_segment17_o
795 => ben_cpi_shd.g_old_rec.custom_segment17
796 ,p_custom_segment18_o
797 => ben_cpi_shd.g_old_rec.custom_segment18
798 ,p_custom_segment19_o
799 => ben_cpi_shd.g_old_rec.custom_segment19
800 ,p_custom_segment20_o
801 => ben_cpi_shd.g_old_rec.custom_segment20
802 ,p_people_group_name_o
803 => ben_cpi_shd.g_old_rec.people_group_name
804 ,p_people_group_segment1_o
805 => ben_cpi_shd.g_old_rec.people_group_segment1
806 ,p_people_group_segment2_o
810 ,p_people_group_segment4_o
807 => ben_cpi_shd.g_old_rec.people_group_segment2
808 ,p_people_group_segment3_o
809 => ben_cpi_shd.g_old_rec.people_group_segment3
811 => ben_cpi_shd.g_old_rec.people_group_segment4
812 ,p_people_group_segment5_o
813 => ben_cpi_shd.g_old_rec.people_group_segment5
814 ,p_people_group_segment6_o
815 => ben_cpi_shd.g_old_rec.people_group_segment6
816 ,p_people_group_segment7_o
817 => ben_cpi_shd.g_old_rec.people_group_segment7
818 ,p_people_group_segment8_o
819 => ben_cpi_shd.g_old_rec.people_group_segment8
820 ,p_people_group_segment9_o
821 => ben_cpi_shd.g_old_rec.people_group_segment9
822 ,p_people_group_segment10_o
823 => ben_cpi_shd.g_old_rec.people_group_segment10
824 ,p_people_group_segment11_o
825 => ben_cpi_shd.g_old_rec.people_group_segment11
826 ,p_ass_attribute_category_o
827 => ben_cpi_shd.g_old_rec.ass_attribute_category
828 ,p_ass_attribute1_o
829 => ben_cpi_shd.g_old_rec.ass_attribute1
830 ,p_ass_attribute2_o
831 => ben_cpi_shd.g_old_rec.ass_attribute2
832 ,p_ass_attribute3_o
833 => ben_cpi_shd.g_old_rec.ass_attribute3
834 ,p_ass_attribute4_o
835 => ben_cpi_shd.g_old_rec.ass_attribute4
836 ,p_ass_attribute5_o
837 => ben_cpi_shd.g_old_rec.ass_attribute5
838 ,p_ass_attribute6_o
839 => ben_cpi_shd.g_old_rec.ass_attribute6
840 ,p_ass_attribute7_o
841 => ben_cpi_shd.g_old_rec.ass_attribute7
842 ,p_ass_attribute8_o
843 => ben_cpi_shd.g_old_rec.ass_attribute8
844 ,p_ass_attribute9_o
845 => ben_cpi_shd.g_old_rec.ass_attribute9
846 ,p_ass_attribute10_o
847 => ben_cpi_shd.g_old_rec.ass_attribute10
848 ,p_ass_attribute11_o
849 => ben_cpi_shd.g_old_rec.ass_attribute11
850 ,p_ass_attribute12_o
851 => ben_cpi_shd.g_old_rec.ass_attribute12
852 ,p_ass_attribute13_o
853 => ben_cpi_shd.g_old_rec.ass_attribute13
854 ,p_ass_attribute14_o
855 => ben_cpi_shd.g_old_rec.ass_attribute14
856 ,p_ass_attribute15_o
857 => ben_cpi_shd.g_old_rec.ass_attribute15
858 ,p_ass_attribute16_o
859 => ben_cpi_shd.g_old_rec.ass_attribute16
860 ,p_ass_attribute17_o
861 => ben_cpi_shd.g_old_rec.ass_attribute17
862 ,p_ass_attribute18_o
863 => ben_cpi_shd.g_old_rec.ass_attribute18
864 ,p_ass_attribute19_o
865 => ben_cpi_shd.g_old_rec.ass_attribute19
866 ,p_ass_attribute20_o
867 => ben_cpi_shd.g_old_rec.ass_attribute20
868 ,p_ass_attribute21_o
869 => ben_cpi_shd.g_old_rec.ass_attribute21
870 ,p_ass_attribute22_o
871 => ben_cpi_shd.g_old_rec.ass_attribute22
872 ,p_ass_attribute23_o
873 => ben_cpi_shd.g_old_rec.ass_attribute23
874 ,p_ass_attribute24_o
875 => ben_cpi_shd.g_old_rec.ass_attribute24
876 ,p_ass_attribute25_o
877 => ben_cpi_shd.g_old_rec.ass_attribute25
878 ,p_ass_attribute26_o
879 => ben_cpi_shd.g_old_rec.ass_attribute26
880 ,p_ass_attribute27_o
881 => ben_cpi_shd.g_old_rec.ass_attribute27
882 ,p_ass_attribute28_o
883 => ben_cpi_shd.g_old_rec.ass_attribute28
884 ,p_ass_attribute29_o
885 => ben_cpi_shd.g_old_rec.ass_attribute29
886 ,p_ass_attribute30_o
887 => ben_cpi_shd.g_old_rec.ass_attribute30
888 ,p_ws_comments_o
889 => ben_cpi_shd.g_old_rec.ws_comments
890 ,p_cpi_attribute_category_o
891 => ben_cpi_shd.g_old_rec.cpi_attribute_category
892 ,p_cpi_attribute1_o
893 => ben_cpi_shd.g_old_rec.cpi_attribute1
894 ,p_cpi_attribute2_o
895 => ben_cpi_shd.g_old_rec.cpi_attribute2
896 ,p_cpi_attribute3_o
897 => ben_cpi_shd.g_old_rec.cpi_attribute3
898 ,p_cpi_attribute4_o
899 => ben_cpi_shd.g_old_rec.cpi_attribute4
900 ,p_cpi_attribute5_o
901 => ben_cpi_shd.g_old_rec.cpi_attribute5
902 ,p_cpi_attribute6_o
903 => ben_cpi_shd.g_old_rec.cpi_attribute6
904 ,p_cpi_attribute7_o
905 => ben_cpi_shd.g_old_rec.cpi_attribute7
906 ,p_cpi_attribute8_o
907 => ben_cpi_shd.g_old_rec.cpi_attribute8
908 ,p_cpi_attribute9_o
909 => ben_cpi_shd.g_old_rec.cpi_attribute9
910 ,p_cpi_attribute10_o
911 => ben_cpi_shd.g_old_rec.cpi_attribute10
912 ,p_cpi_attribute11_o
913 => ben_cpi_shd.g_old_rec.cpi_attribute11
914 ,p_cpi_attribute12_o
915 => ben_cpi_shd.g_old_rec.cpi_attribute12
916 ,p_cpi_attribute13_o
917 => ben_cpi_shd.g_old_rec.cpi_attribute13
918 ,p_cpi_attribute14_o
919 => ben_cpi_shd.g_old_rec.cpi_attribute14
920 ,p_cpi_attribute15_o
921 => ben_cpi_shd.g_old_rec.cpi_attribute15
922 ,p_cpi_attribute16_o
923 => ben_cpi_shd.g_old_rec.cpi_attribute16
924 ,p_cpi_attribute17_o
925 => ben_cpi_shd.g_old_rec.cpi_attribute17
926 ,p_cpi_attribute18_o
927 => ben_cpi_shd.g_old_rec.cpi_attribute18
928 ,p_cpi_attribute19_o
929 => ben_cpi_shd.g_old_rec.cpi_attribute19
930 ,p_cpi_attribute20_o
931 => ben_cpi_shd.g_old_rec.cpi_attribute20
932 ,p_cpi_attribute21_o
933 => ben_cpi_shd.g_old_rec.cpi_attribute21
934 ,p_cpi_attribute22_o
935 => ben_cpi_shd.g_old_rec.cpi_attribute22
936 ,p_cpi_attribute23_o
937 => ben_cpi_shd.g_old_rec.cpi_attribute23
938 ,p_cpi_attribute24_o
939 => ben_cpi_shd.g_old_rec.cpi_attribute24
940 ,p_cpi_attribute25_o
941 => ben_cpi_shd.g_old_rec.cpi_attribute25
942 ,p_cpi_attribute26_o
943 => ben_cpi_shd.g_old_rec.cpi_attribute26
944 ,p_cpi_attribute27_o
948 ,p_cpi_attribute29_o
945 => ben_cpi_shd.g_old_rec.cpi_attribute27
946 ,p_cpi_attribute28_o
947 => ben_cpi_shd.g_old_rec.cpi_attribute28
949 => ben_cpi_shd.g_old_rec.cpi_attribute29
950 ,p_cpi_attribute30_o
951 => ben_cpi_shd.g_old_rec.cpi_attribute30
952 ,p_feedback_date_o
953 => ben_cpi_shd.g_old_rec.feedback_date
954 );
955 --
956 exception
957 --
958 when hr_api.cannot_find_prog_unit then
959 --
960 hr_api.cannot_find_prog_unit_error
961 (p_module_name => 'BEN_CWB_PERSON_INFO'
962 ,p_hook_type => 'AU');
963 --
964 end;
965 --
966 if g_debug then
967 hr_utility.set_location(' Leaving:'||l_proc, 10);
968 end if;
969 End post_update;
970 --
971 -- ----------------------------------------------------------------------------
972 -- |-----------------------------< convert_defs >-----------------------------|
973 -- ----------------------------------------------------------------------------
974 -- {Start Of Comments}
975 --
976 -- Description:
977 -- The Convert_Defs procedure has one very important function:
978 -- It must return the record structure for the row with all system defaulted
979 -- values converted into its corresponding parameter value for update. When
980 -- we attempt to update a row through the Upd process , certain
981 -- parameters can be defaulted which enables flexibility in the calling of
982 -- the upd process (e.g. only attributes which need to be updated need to be
983 -- specified). For the upd process to determine which attributes
984 -- have NOT been specified we need to check if the parameter has a reserved
985 -- system default value. Therefore, for all parameters which have a
986 -- corresponding reserved system default mechanism specified we need to
987 -- check if a system default is being used. If a system default is being
988 -- used then we convert the defaulted value into its corresponding attribute
989 -- value held in the g_old_rec data structure.
990 --
991 -- Prerequisites:
992 -- This private function can only be called from the upd process.
993 --
994 -- In Parameters:
995 -- A Pl/Sql record structure.
996 --
997 -- Post Success:
998 -- The record structure will be returned with all system defaulted parameter
999 -- values converted into its current row attribute value.
1000 --
1001 -- Post Failure:
1002 -- No direct error handling is required within this function. Any possible
1003 -- errors within this procedure will be a PL/SQL value error due to
1004 -- conversion of datatypes or data lengths.
1005 --
1006 -- Developer Implementation Notes:
1007 -- None.
1008 --
1009 -- Access Status:
1010 -- Internal Row Handler Use Only.
1011 --
1012 -- {End Of Comments}
1013 -- ----------------------------------------------------------------------------
1014 Procedure convert_defs
1015 (p_rec in out nocopy ben_cpi_shd.g_rec_type
1016 ) is
1017 --
1018 Begin
1019 --
1020 -- We must now examine each argument value in the
1021 -- p_rec plsql record structure
1022 -- to see if a system default is being used. If a system default
1023 -- is being used then we must set to the 'current' argument value.
1024 --
1025 If (p_rec.assignment_id = hr_api.g_number) then
1026 p_rec.assignment_id :=
1027 ben_cpi_shd.g_old_rec.assignment_id;
1028 End If;
1029 If (p_rec.person_id = hr_api.g_number) then
1030 p_rec.person_id :=
1031 ben_cpi_shd.g_old_rec.person_id;
1032 End If;
1033 If (p_rec.supervisor_id = hr_api.g_number) then
1034 p_rec.supervisor_id :=
1035 ben_cpi_shd.g_old_rec.supervisor_id;
1036 End If;
1037 If (p_rec.effective_date = hr_api.g_date) then
1038 p_rec.effective_date :=
1039 ben_cpi_shd.g_old_rec.effective_date;
1040 End If;
1041 If (p_rec.full_name = hr_api.g_varchar2) then
1042 p_rec.full_name :=
1043 ben_cpi_shd.g_old_rec.full_name;
1044 End If;
1045 If (p_rec.brief_name = hr_api.g_varchar2) then
1046 p_rec.brief_name :=
1047 ben_cpi_shd.g_old_rec.brief_name;
1048 End If;
1049 If (p_rec.custom_name = hr_api.g_varchar2) then
1050 p_rec.custom_name :=
1051 ben_cpi_shd.g_old_rec.custom_name;
1052 End If;
1053 If (p_rec.supervisor_full_name = hr_api.g_varchar2) then
1054 p_rec.supervisor_full_name :=
1055 ben_cpi_shd.g_old_rec.supervisor_full_name;
1056 End If;
1057 If (p_rec.supervisor_brief_name = hr_api.g_varchar2) then
1058 p_rec.supervisor_brief_name :=
1059 ben_cpi_shd.g_old_rec.supervisor_brief_name;
1060 End If;
1061 If (p_rec.supervisor_custom_name = hr_api.g_varchar2) then
1062 p_rec.supervisor_custom_name :=
1063 ben_cpi_shd.g_old_rec.supervisor_custom_name;
1064 End If;
1065 If (p_rec.legislation_code = hr_api.g_varchar2) then
1066 p_rec.legislation_code :=
1067 ben_cpi_shd.g_old_rec.legislation_code;
1068 End If;
1069 If (p_rec.years_employed = hr_api.g_number) then
1070 p_rec.years_employed :=
1071 ben_cpi_shd.g_old_rec.years_employed;
1072 End If;
1073 If (p_rec.years_in_job = hr_api.g_number) then
1074 p_rec.years_in_job :=
1075 ben_cpi_shd.g_old_rec.years_in_job;
1076 End If;
1077 If (p_rec.years_in_position = hr_api.g_number) then
1078 p_rec.years_in_position :=
1079 ben_cpi_shd.g_old_rec.years_in_position;
1080 End If;
1081 If (p_rec.years_in_grade = hr_api.g_number) then
1082 p_rec.years_in_grade :=
1083 ben_cpi_shd.g_old_rec.years_in_grade;
1084 End If;
1085 If (p_rec.employee_number = hr_api.g_varchar2) then
1086 p_rec.employee_number :=
1087 ben_cpi_shd.g_old_rec.employee_number;
1088 End If;
1089 If (p_rec.start_date = hr_api.g_date) then
1090 p_rec.start_date :=
1091 ben_cpi_shd.g_old_rec.start_date;
1092 End If;
1093 If (p_rec.original_start_date = hr_api.g_date) then
1094 p_rec.original_start_date :=
1095 ben_cpi_shd.g_old_rec.original_start_date;
1096 End If;
1097 If (p_rec.adjusted_svc_date = hr_api.g_date) then
1098 p_rec.adjusted_svc_date :=
1099 ben_cpi_shd.g_old_rec.adjusted_svc_date;
1100 End If;
1101 If (p_rec.base_salary = hr_api.g_number) then
1102 p_rec.base_salary :=
1103 ben_cpi_shd.g_old_rec.base_salary;
1104 End If;
1105 If (p_rec.base_salary_change_date = hr_api.g_date) then
1106 p_rec.base_salary_change_date :=
1107 ben_cpi_shd.g_old_rec.base_salary_change_date;
1108 End If;
1109 If (p_rec.payroll_name = hr_api.g_varchar2) then
1110 p_rec.payroll_name :=
1111 ben_cpi_shd.g_old_rec.payroll_name;
1112 End If;
1113 If (p_rec.performance_rating = hr_api.g_varchar2) then
1114 p_rec.performance_rating :=
1115 ben_cpi_shd.g_old_rec.performance_rating;
1116 End If;
1117 If (p_rec.performance_rating_type = hr_api.g_varchar2) then
1118 p_rec.performance_rating_type :=
1119 ben_cpi_shd.g_old_rec.performance_rating_type;
1120 End If;
1121 If (p_rec.performance_rating_date = hr_api.g_date) then
1122 p_rec.performance_rating_date :=
1123 ben_cpi_shd.g_old_rec.performance_rating_date;
1124 End If;
1125 If (p_rec.business_group_id = hr_api.g_number) then
1126 p_rec.business_group_id :=
1127 ben_cpi_shd.g_old_rec.business_group_id;
1128 End If;
1129 If (p_rec.organization_id = hr_api.g_number) then
1130 p_rec.organization_id :=
1131 ben_cpi_shd.g_old_rec.organization_id;
1132 End If;
1133 If (p_rec.job_id = hr_api.g_number) then
1134 p_rec.job_id :=
1135 ben_cpi_shd.g_old_rec.job_id;
1136 End If;
1137 If (p_rec.grade_id = hr_api.g_number) then
1138 p_rec.grade_id :=
1139 ben_cpi_shd.g_old_rec.grade_id;
1140 End If;
1141 If (p_rec.position_id = hr_api.g_number) then
1142 p_rec.position_id :=
1143 ben_cpi_shd.g_old_rec.position_id;
1144 End If;
1145 If (p_rec.people_group_id = hr_api.g_number) then
1146 p_rec.people_group_id :=
1147 ben_cpi_shd.g_old_rec.people_group_id;
1148 End If;
1149 If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
1150 p_rec.soft_coding_keyflex_id :=
1151 ben_cpi_shd.g_old_rec.soft_coding_keyflex_id;
1152 End If;
1156 End If;
1153 If (p_rec.location_id = hr_api.g_number) then
1154 p_rec.location_id :=
1155 ben_cpi_shd.g_old_rec.location_id;
1157 If (p_rec.pay_rate_id = hr_api.g_number) then
1158 p_rec.pay_rate_id :=
1159 ben_cpi_shd.g_old_rec.pay_rate_id;
1160 End If;
1161 If (p_rec.assignment_status_type_id = hr_api.g_number) then
1162 p_rec.assignment_status_type_id :=
1163 ben_cpi_shd.g_old_rec.assignment_status_type_id;
1164 End If;
1165 If (p_rec.frequency = hr_api.g_varchar2) then
1166 p_rec.frequency :=
1167 ben_cpi_shd.g_old_rec.frequency;
1168 End If;
1169 If (p_rec.grade_annulization_factor = hr_api.g_number) then
1170 p_rec.grade_annulization_factor :=
1171 ben_cpi_shd.g_old_rec.grade_annulization_factor;
1172 End If;
1173 If (p_rec.pay_annulization_factor = hr_api.g_number) then
1174 p_rec.pay_annulization_factor :=
1175 ben_cpi_shd.g_old_rec.pay_annulization_factor;
1176 End If;
1177 If (p_rec.grd_min_val = hr_api.g_number) then
1178 p_rec.grd_min_val :=
1179 ben_cpi_shd.g_old_rec.grd_min_val;
1180 End If;
1181 If (p_rec.grd_max_val = hr_api.g_number) then
1182 p_rec.grd_max_val :=
1183 ben_cpi_shd.g_old_rec.grd_max_val;
1184 End If;
1185 If (p_rec.grd_mid_point = hr_api.g_number) then
1186 p_rec.grd_mid_point :=
1187 ben_cpi_shd.g_old_rec.grd_mid_point;
1188 End If;
1189 If (p_rec.grd_quartile = hr_api.g_varchar2) then
1190 p_rec.grd_quartile :=
1191 ben_cpi_shd.g_old_rec.grd_quartile;
1192 End If;
1193 If (p_rec.grd_comparatio = hr_api.g_number) then
1194 p_rec.grd_comparatio :=
1195 ben_cpi_shd.g_old_rec.grd_comparatio;
1196 End If;
1197 If (p_rec.emp_category = hr_api.g_varchar2) then
1198 p_rec.emp_category :=
1199 ben_cpi_shd.g_old_rec.emp_category;
1200 End If;
1201 If (p_rec.change_reason = hr_api.g_varchar2) then
1202 p_rec.change_reason :=
1203 ben_cpi_shd.g_old_rec.change_reason;
1204 End If;
1205 If (p_rec.normal_hours = hr_api.g_number) then
1206 p_rec.normal_hours :=
1207 ben_cpi_shd.g_old_rec.normal_hours;
1208 End If;
1209 If (p_rec.email_address = hr_api.g_varchar2) then
1210 p_rec.email_address :=
1211 ben_cpi_shd.g_old_rec.email_address;
1212 End If;
1213 If (p_rec.base_salary_frequency = hr_api.g_varchar2) then
1214 p_rec.base_salary_frequency :=
1215 ben_cpi_shd.g_old_rec.base_salary_frequency;
1216 End If;
1217 If (p_rec.new_assgn_ovn = hr_api.g_number) then
1218 p_rec.new_assgn_ovn :=
1219 ben_cpi_shd.g_old_rec.new_assgn_ovn;
1220 End If;
1221 If (p_rec.new_perf_event_id = hr_api.g_number) then
1222 p_rec.new_perf_event_id :=
1223 ben_cpi_shd.g_old_rec.new_perf_event_id;
1224 End If;
1225 If (p_rec.new_perf_review_id = hr_api.g_number) then
1226 p_rec.new_perf_review_id :=
1227 ben_cpi_shd.g_old_rec.new_perf_review_id;
1228 End If;
1229 If (p_rec.post_process_stat_cd = hr_api.g_varchar2) then
1230 p_rec.post_process_stat_cd :=
1231 ben_cpi_shd.g_old_rec.post_process_stat_cd;
1232 End If;
1233 If (p_rec.feedback_rating = hr_api.g_varchar2) then
1234 p_rec.feedback_rating :=
1235 ben_cpi_shd.g_old_rec.feedback_rating;
1236 End If;
1237 If (p_rec.feedback_comments = hr_api.g_varchar2) then
1238 p_rec.feedback_comments :=
1239 ben_cpi_shd.g_old_rec.feedback_comments;
1240 End If;
1241 If (p_rec.custom_segment1 = hr_api.g_varchar2) then
1242 p_rec.custom_segment1 :=
1243 ben_cpi_shd.g_old_rec.custom_segment1;
1244 End If;
1245 If (p_rec.custom_segment2 = hr_api.g_varchar2) then
1246 p_rec.custom_segment2 :=
1247 ben_cpi_shd.g_old_rec.custom_segment2;
1248 End If;
1249 If (p_rec.custom_segment3 = hr_api.g_varchar2) then
1250 p_rec.custom_segment3 :=
1251 ben_cpi_shd.g_old_rec.custom_segment3;
1252 End If;
1253 If (p_rec.custom_segment4 = hr_api.g_varchar2) then
1254 p_rec.custom_segment4 :=
1255 ben_cpi_shd.g_old_rec.custom_segment4;
1256 End If;
1257 If (p_rec.custom_segment5 = hr_api.g_varchar2) then
1258 p_rec.custom_segment5 :=
1259 ben_cpi_shd.g_old_rec.custom_segment5;
1260 End If;
1261 If (p_rec.custom_segment6 = hr_api.g_varchar2) then
1262 p_rec.custom_segment6 :=
1263 ben_cpi_shd.g_old_rec.custom_segment6;
1264 End If;
1265 If (p_rec.custom_segment7 = hr_api.g_varchar2) then
1266 p_rec.custom_segment7 :=
1267 ben_cpi_shd.g_old_rec.custom_segment7;
1268 End If;
1269 If (p_rec.custom_segment8 = hr_api.g_varchar2) then
1270 p_rec.custom_segment8 :=
1271 ben_cpi_shd.g_old_rec.custom_segment8;
1272 End If;
1273 If (p_rec.custom_segment9 = hr_api.g_varchar2) then
1274 p_rec.custom_segment9 :=
1275 ben_cpi_shd.g_old_rec.custom_segment9;
1276 End If;
1277 If (p_rec.custom_segment10 = hr_api.g_varchar2) then
1278 p_rec.custom_segment10 :=
1279 ben_cpi_shd.g_old_rec.custom_segment10;
1280 End If;
1281 If (p_rec.custom_segment11 = hr_api.g_number) then
1282 p_rec.custom_segment11 :=
1283 ben_cpi_shd.g_old_rec.custom_segment11;
1284 End If;
1285 If (p_rec.custom_segment12 = hr_api.g_number) then
1286 p_rec.custom_segment12 :=
1287 ben_cpi_shd.g_old_rec.custom_segment12;
1288 End If;
1289 If (p_rec.custom_segment13 = hr_api.g_number) then
1290 p_rec.custom_segment13 :=
1291 ben_cpi_shd.g_old_rec.custom_segment13;
1292 End If;
1293 If (p_rec.custom_segment14 = hr_api.g_number) then
1294 p_rec.custom_segment14 :=
1295 ben_cpi_shd.g_old_rec.custom_segment14;
1296 End If;
1297 If (p_rec.custom_segment15 = hr_api.g_number) then
1298 p_rec.custom_segment15 :=
1299 ben_cpi_shd.g_old_rec.custom_segment15;
1300 End If;
1304 End If;
1301 If (p_rec.custom_segment16 = hr_api.g_number) then
1302 p_rec.custom_segment16 :=
1303 ben_cpi_shd.g_old_rec.custom_segment16;
1305 If (p_rec.custom_segment17 = hr_api.g_number) then
1306 p_rec.custom_segment17 :=
1307 ben_cpi_shd.g_old_rec.custom_segment17;
1308 End If;
1309 If (p_rec.custom_segment18 = hr_api.g_number) then
1310 p_rec.custom_segment18 :=
1311 ben_cpi_shd.g_old_rec.custom_segment18;
1312 End If;
1313 If (p_rec.custom_segment19 = hr_api.g_number) then
1314 p_rec.custom_segment19 :=
1315 ben_cpi_shd.g_old_rec.custom_segment19;
1316 End If;
1317 If (p_rec.custom_segment20 = hr_api.g_number) then
1318 p_rec.custom_segment20 :=
1319 ben_cpi_shd.g_old_rec.custom_segment20;
1320 End If;
1321 If (p_rec.people_group_name = hr_api.g_varchar2) then
1322 p_rec.people_group_name :=
1323 ben_cpi_shd.g_old_rec.people_group_name;
1324 End If;
1325 If (p_rec.people_group_segment1 = hr_api.g_varchar2) then
1326 p_rec.people_group_segment1 :=
1327 ben_cpi_shd.g_old_rec.people_group_segment1;
1328 End If;
1329 If (p_rec.people_group_segment2 = hr_api.g_varchar2) then
1330 p_rec.people_group_segment2 :=
1331 ben_cpi_shd.g_old_rec.people_group_segment2;
1332 End If;
1333 If (p_rec.people_group_segment3 = hr_api.g_varchar2) then
1334 p_rec.people_group_segment3 :=
1335 ben_cpi_shd.g_old_rec.people_group_segment3;
1336 End If;
1337 If (p_rec.people_group_segment4 = hr_api.g_varchar2) then
1338 p_rec.people_group_segment4 :=
1339 ben_cpi_shd.g_old_rec.people_group_segment4;
1340 End If;
1341 If (p_rec.people_group_segment5 = hr_api.g_varchar2) then
1342 p_rec.people_group_segment5 :=
1343 ben_cpi_shd.g_old_rec.people_group_segment5;
1344 End If;
1345 If (p_rec.people_group_segment6 = hr_api.g_varchar2) then
1346 p_rec.people_group_segment6 :=
1347 ben_cpi_shd.g_old_rec.people_group_segment6;
1348 End If;
1349 If (p_rec.people_group_segment7 = hr_api.g_varchar2) then
1350 p_rec.people_group_segment7 :=
1351 ben_cpi_shd.g_old_rec.people_group_segment7;
1352 End If;
1353 If (p_rec.people_group_segment8 = hr_api.g_varchar2) then
1354 p_rec.people_group_segment8 :=
1355 ben_cpi_shd.g_old_rec.people_group_segment8;
1356 End If;
1357 If (p_rec.people_group_segment9 = hr_api.g_varchar2) then
1358 p_rec.people_group_segment9 :=
1359 ben_cpi_shd.g_old_rec.people_group_segment9;
1360 End If;
1361 If (p_rec.people_group_segment10 = hr_api.g_varchar2) then
1362 p_rec.people_group_segment10 :=
1363 ben_cpi_shd.g_old_rec.people_group_segment10;
1364 End If;
1365 If (p_rec.people_group_segment11 = hr_api.g_varchar2) then
1366 p_rec.people_group_segment11 :=
1367 ben_cpi_shd.g_old_rec.people_group_segment11;
1368 End If;
1369 If (p_rec.ass_attribute_category = hr_api.g_varchar2) then
1370 p_rec.ass_attribute_category :=
1371 ben_cpi_shd.g_old_rec.ass_attribute_category;
1372 End If;
1373 If (p_rec.ass_attribute1 = hr_api.g_varchar2) then
1374 p_rec.ass_attribute1 :=
1375 ben_cpi_shd.g_old_rec.ass_attribute1;
1376 End If;
1377 If (p_rec.ass_attribute2 = hr_api.g_varchar2) then
1378 p_rec.ass_attribute2 :=
1379 ben_cpi_shd.g_old_rec.ass_attribute2;
1380 End If;
1381 If (p_rec.ass_attribute3 = hr_api.g_varchar2) then
1382 p_rec.ass_attribute3 :=
1383 ben_cpi_shd.g_old_rec.ass_attribute3;
1384 End If;
1385 If (p_rec.ass_attribute4 = hr_api.g_varchar2) then
1386 p_rec.ass_attribute4 :=
1387 ben_cpi_shd.g_old_rec.ass_attribute4;
1388 End If;
1389 If (p_rec.ass_attribute5 = hr_api.g_varchar2) then
1390 p_rec.ass_attribute5 :=
1391 ben_cpi_shd.g_old_rec.ass_attribute5;
1392 End If;
1393 If (p_rec.ass_attribute6 = hr_api.g_varchar2) then
1394 p_rec.ass_attribute6 :=
1395 ben_cpi_shd.g_old_rec.ass_attribute6;
1396 End If;
1397 If (p_rec.ass_attribute7 = hr_api.g_varchar2) then
1398 p_rec.ass_attribute7 :=
1399 ben_cpi_shd.g_old_rec.ass_attribute7;
1400 End If;
1401 If (p_rec.ass_attribute8 = hr_api.g_varchar2) then
1402 p_rec.ass_attribute8 :=
1403 ben_cpi_shd.g_old_rec.ass_attribute8;
1404 End If;
1405 If (p_rec.ass_attribute9 = hr_api.g_varchar2) then
1406 p_rec.ass_attribute9 :=
1407 ben_cpi_shd.g_old_rec.ass_attribute9;
1408 End If;
1409 If (p_rec.ass_attribute10 = hr_api.g_varchar2) then
1410 p_rec.ass_attribute10 :=
1411 ben_cpi_shd.g_old_rec.ass_attribute10;
1412 End If;
1413 If (p_rec.ass_attribute11 = hr_api.g_varchar2) then
1414 p_rec.ass_attribute11 :=
1415 ben_cpi_shd.g_old_rec.ass_attribute11;
1416 End If;
1417 If (p_rec.ass_attribute12 = hr_api.g_varchar2) then
1418 p_rec.ass_attribute12 :=
1419 ben_cpi_shd.g_old_rec.ass_attribute12;
1420 End If;
1421 If (p_rec.ass_attribute13 = hr_api.g_varchar2) then
1422 p_rec.ass_attribute13 :=
1423 ben_cpi_shd.g_old_rec.ass_attribute13;
1424 End If;
1425 If (p_rec.ass_attribute14 = hr_api.g_varchar2) then
1426 p_rec.ass_attribute14 :=
1427 ben_cpi_shd.g_old_rec.ass_attribute14;
1428 End If;
1429 If (p_rec.ass_attribute15 = hr_api.g_varchar2) then
1430 p_rec.ass_attribute15 :=
1431 ben_cpi_shd.g_old_rec.ass_attribute15;
1432 End If;
1433 If (p_rec.ass_attribute16 = hr_api.g_varchar2) then
1434 p_rec.ass_attribute16 :=
1435 ben_cpi_shd.g_old_rec.ass_attribute16;
1436 End If;
1437 If (p_rec.ass_attribute17 = hr_api.g_varchar2) then
1438 p_rec.ass_attribute17 :=
1439 ben_cpi_shd.g_old_rec.ass_attribute17;
1440 End If;
1441 If (p_rec.ass_attribute18 = hr_api.g_varchar2) then
1442 p_rec.ass_attribute18 :=
1443 ben_cpi_shd.g_old_rec.ass_attribute18;
1444 End If;
1448 End If;
1445 If (p_rec.ass_attribute19 = hr_api.g_varchar2) then
1446 p_rec.ass_attribute19 :=
1447 ben_cpi_shd.g_old_rec.ass_attribute19;
1449 If (p_rec.ass_attribute20 = hr_api.g_varchar2) then
1450 p_rec.ass_attribute20 :=
1451 ben_cpi_shd.g_old_rec.ass_attribute20;
1452 End If;
1453 If (p_rec.ass_attribute21 = hr_api.g_varchar2) then
1454 p_rec.ass_attribute21 :=
1455 ben_cpi_shd.g_old_rec.ass_attribute21;
1456 End If;
1457 If (p_rec.ass_attribute22 = hr_api.g_varchar2) then
1458 p_rec.ass_attribute22 :=
1459 ben_cpi_shd.g_old_rec.ass_attribute22;
1460 End If;
1461 If (p_rec.ass_attribute23 = hr_api.g_varchar2) then
1462 p_rec.ass_attribute23 :=
1463 ben_cpi_shd.g_old_rec.ass_attribute23;
1464 End If;
1465 If (p_rec.ass_attribute24 = hr_api.g_varchar2) then
1466 p_rec.ass_attribute24 :=
1467 ben_cpi_shd.g_old_rec.ass_attribute24;
1468 End If;
1469 If (p_rec.ass_attribute25 = hr_api.g_varchar2) then
1470 p_rec.ass_attribute25 :=
1471 ben_cpi_shd.g_old_rec.ass_attribute25;
1472 End If;
1473 If (p_rec.ass_attribute26 = hr_api.g_varchar2) then
1474 p_rec.ass_attribute26 :=
1475 ben_cpi_shd.g_old_rec.ass_attribute26;
1476 End If;
1477 If (p_rec.ass_attribute27 = hr_api.g_varchar2) then
1478 p_rec.ass_attribute27 :=
1479 ben_cpi_shd.g_old_rec.ass_attribute27;
1480 End If;
1481 If (p_rec.ass_attribute28 = hr_api.g_varchar2) then
1482 p_rec.ass_attribute28 :=
1483 ben_cpi_shd.g_old_rec.ass_attribute28;
1484 End If;
1485 If (p_rec.ass_attribute29 = hr_api.g_varchar2) then
1486 p_rec.ass_attribute29 :=
1487 ben_cpi_shd.g_old_rec.ass_attribute29;
1488 End If;
1489 If (p_rec.ass_attribute30 = hr_api.g_varchar2) then
1490 p_rec.ass_attribute30 :=
1491 ben_cpi_shd.g_old_rec.ass_attribute30;
1492 End If;
1493 If (p_rec.ws_comments = hr_api.g_varchar2) then
1494 p_rec.ws_comments :=
1495 ben_cpi_shd.g_old_rec.ws_comments;
1496 End If;
1497 If (p_rec.cpi_attribute_category = hr_api.g_varchar2) then
1498 p_rec.cpi_attribute_category :=
1499 ben_cpi_shd.g_old_rec.cpi_attribute_category;
1500 End If;
1501 If (p_rec.cpi_attribute1 = hr_api.g_varchar2) then
1502 p_rec.cpi_attribute1 :=
1503 ben_cpi_shd.g_old_rec.cpi_attribute1;
1504 End If;
1505 If (p_rec.cpi_attribute2 = hr_api.g_varchar2) then
1506 p_rec.cpi_attribute2 :=
1507 ben_cpi_shd.g_old_rec.cpi_attribute2;
1508 End If;
1509 If (p_rec.cpi_attribute3 = hr_api.g_varchar2) then
1510 p_rec.cpi_attribute3 :=
1511 ben_cpi_shd.g_old_rec.cpi_attribute3;
1512 End If;
1513 If (p_rec.cpi_attribute4 = hr_api.g_varchar2) then
1514 p_rec.cpi_attribute4 :=
1515 ben_cpi_shd.g_old_rec.cpi_attribute4;
1516 End If;
1517 If (p_rec.cpi_attribute5 = hr_api.g_varchar2) then
1518 p_rec.cpi_attribute5 :=
1519 ben_cpi_shd.g_old_rec.cpi_attribute5;
1520 End If;
1521 If (p_rec.cpi_attribute6 = hr_api.g_varchar2) then
1522 p_rec.cpi_attribute6 :=
1523 ben_cpi_shd.g_old_rec.cpi_attribute6;
1524 End If;
1525 If (p_rec.cpi_attribute7 = hr_api.g_varchar2) then
1526 p_rec.cpi_attribute7 :=
1527 ben_cpi_shd.g_old_rec.cpi_attribute7;
1528 End If;
1529 If (p_rec.cpi_attribute8 = hr_api.g_varchar2) then
1530 p_rec.cpi_attribute8 :=
1531 ben_cpi_shd.g_old_rec.cpi_attribute8;
1532 End If;
1533 If (p_rec.cpi_attribute9 = hr_api.g_varchar2) then
1534 p_rec.cpi_attribute9 :=
1535 ben_cpi_shd.g_old_rec.cpi_attribute9;
1536 End If;
1537 If (p_rec.cpi_attribute10 = hr_api.g_varchar2) then
1538 p_rec.cpi_attribute10 :=
1539 ben_cpi_shd.g_old_rec.cpi_attribute10;
1540 End If;
1541 If (p_rec.cpi_attribute11 = hr_api.g_varchar2) then
1542 p_rec.cpi_attribute11 :=
1543 ben_cpi_shd.g_old_rec.cpi_attribute11;
1544 End If;
1545 If (p_rec.cpi_attribute12 = hr_api.g_varchar2) then
1546 p_rec.cpi_attribute12 :=
1547 ben_cpi_shd.g_old_rec.cpi_attribute12;
1548 End If;
1549 If (p_rec.cpi_attribute13 = hr_api.g_varchar2) then
1550 p_rec.cpi_attribute13 :=
1551 ben_cpi_shd.g_old_rec.cpi_attribute13;
1552 End If;
1553 If (p_rec.cpi_attribute14 = hr_api.g_varchar2) then
1554 p_rec.cpi_attribute14 :=
1555 ben_cpi_shd.g_old_rec.cpi_attribute14;
1556 End If;
1557 If (p_rec.cpi_attribute15 = hr_api.g_varchar2) then
1558 p_rec.cpi_attribute15 :=
1559 ben_cpi_shd.g_old_rec.cpi_attribute15;
1560 End If;
1561 If (p_rec.cpi_attribute16 = hr_api.g_varchar2) then
1562 p_rec.cpi_attribute16 :=
1563 ben_cpi_shd.g_old_rec.cpi_attribute16;
1564 End If;
1565 If (p_rec.cpi_attribute17 = hr_api.g_varchar2) then
1566 p_rec.cpi_attribute17 :=
1567 ben_cpi_shd.g_old_rec.cpi_attribute17;
1568 End If;
1569 If (p_rec.cpi_attribute18 = hr_api.g_varchar2) then
1570 p_rec.cpi_attribute18 :=
1571 ben_cpi_shd.g_old_rec.cpi_attribute18;
1572 End If;
1573 If (p_rec.cpi_attribute19 = hr_api.g_varchar2) then
1574 p_rec.cpi_attribute19 :=
1575 ben_cpi_shd.g_old_rec.cpi_attribute19;
1576 End If;
1577 If (p_rec.cpi_attribute20 = hr_api.g_varchar2) then
1578 p_rec.cpi_attribute20 :=
1579 ben_cpi_shd.g_old_rec.cpi_attribute20;
1580 End If;
1581 If (p_rec.cpi_attribute21 = hr_api.g_varchar2) then
1582 p_rec.cpi_attribute21 :=
1583 ben_cpi_shd.g_old_rec.cpi_attribute21;
1584 End If;
1585 If (p_rec.cpi_attribute22 = hr_api.g_varchar2) then
1586 p_rec.cpi_attribute22 :=
1587 ben_cpi_shd.g_old_rec.cpi_attribute22;
1588 End If;
1589 If (p_rec.cpi_attribute23 = hr_api.g_varchar2) then
1590 p_rec.cpi_attribute23 :=
1591 ben_cpi_shd.g_old_rec.cpi_attribute23;
1592 End If;
1596 End If;
1593 If (p_rec.cpi_attribute24 = hr_api.g_varchar2) then
1594 p_rec.cpi_attribute24 :=
1595 ben_cpi_shd.g_old_rec.cpi_attribute24;
1597 If (p_rec.cpi_attribute25 = hr_api.g_varchar2) then
1598 p_rec.cpi_attribute25 :=
1599 ben_cpi_shd.g_old_rec.cpi_attribute25;
1600 End If;
1601 If (p_rec.cpi_attribute26 = hr_api.g_varchar2) then
1602 p_rec.cpi_attribute26 :=
1603 ben_cpi_shd.g_old_rec.cpi_attribute26;
1604 End If;
1605 If (p_rec.cpi_attribute27 = hr_api.g_varchar2) then
1606 p_rec.cpi_attribute27 :=
1607 ben_cpi_shd.g_old_rec.cpi_attribute27;
1608 End If;
1609 If (p_rec.cpi_attribute28 = hr_api.g_varchar2) then
1610 p_rec.cpi_attribute28 :=
1611 ben_cpi_shd.g_old_rec.cpi_attribute28;
1612 End If;
1613 If (p_rec.cpi_attribute29 = hr_api.g_varchar2) then
1614 p_rec.cpi_attribute29 :=
1615 ben_cpi_shd.g_old_rec.cpi_attribute29;
1616 End If;
1617 If (p_rec.cpi_attribute30 = hr_api.g_varchar2) then
1618 p_rec.cpi_attribute30 :=
1619 ben_cpi_shd.g_old_rec.cpi_attribute30;
1620 End If;
1621 If (p_rec.feedback_date = hr_api.g_date) then
1622 p_rec.feedback_date :=
1623 ben_cpi_shd.g_old_rec.feedback_date;
1624 End If;
1625 --
1626 End convert_defs;
1627 --
1628 -- ----------------------------------------------------------------------------
1629 -- |---------------------------------< upd >----------------------------------|
1630 -- ----------------------------------------------------------------------------
1631 Procedure upd
1632 (p_rec in out nocopy ben_cpi_shd.g_rec_type
1633 ) is
1634 --
1635 l_proc varchar2(72) := g_package||'upd';
1636 --
1637 Begin
1638 if g_debug then
1639 hr_utility.set_location('Entering:'||l_proc, 5);
1640 end if;
1641 --
1642 -- We must lock the row which we need to update.
1643 --
1644 ben_cpi_shd.lck
1645 (p_rec.group_per_in_ler_id
1646 ,p_rec.object_version_number
1647 );
1648 --
1649 -- 1. During an update system defaults are used to determine if
1650 -- arguments have been defaulted or not. We must therefore
1651 -- derive the full record structure values to be updated.
1652 --
1653 -- 2. Call the supporting update validate operations.
1654 --
1655 convert_defs(p_rec);
1656 ben_cpi_bus.update_validate
1657 (p_rec
1658 );
1659 --
1660 -- Call to raise any errors on multi-message list
1661 hr_multi_message.end_validation_set;
1662 --
1663 -- Call the supporting pre-update operation
1664 --
1665 ben_cpi_upd.pre_update(p_rec);
1666 --
1667 -- Update the row.
1668 --
1669 ben_cpi_upd.update_dml(p_rec);
1670 --
1671 -- Call the supporting post-update operation
1672 --
1673 ben_cpi_upd.post_update
1674 (p_rec
1675 );
1676 --
1677 -- Call to raise any errors on multi-message list
1678 hr_multi_message.end_validation_set;
1679 End upd;
1680 --
1681 -- ----------------------------------------------------------------------------
1682 -- |---------------------------------< upd >----------------------------------|
1683 -- ----------------------------------------------------------------------------
1684 Procedure upd
1685 (p_group_per_in_ler_id in number
1686 ,p_object_version_number in out nocopy number
1687 ,p_assignment_id in number default hr_api.g_number
1688 ,p_person_id in number default hr_api.g_number
1689 ,p_supervisor_id in number default hr_api.g_number
1690 ,p_effective_date in date default hr_api.g_date
1691 ,p_full_name in varchar2 default hr_api.g_varchar2
1692 ,p_brief_name in varchar2 default hr_api.g_varchar2
1693 ,p_custom_name in varchar2 default hr_api.g_varchar2
1694 ,p_supervisor_full_name in varchar2 default hr_api.g_varchar2
1695 ,p_supervisor_brief_name in varchar2 default hr_api.g_varchar2
1696 ,p_supervisor_custom_name in varchar2 default hr_api.g_varchar2
1697 ,p_legislation_code in varchar2 default hr_api.g_varchar2
1698 ,p_years_employed in number default hr_api.g_number
1699 ,p_years_in_job in number default hr_api.g_number
1700 ,p_years_in_position in number default hr_api.g_number
1701 ,p_years_in_grade in number default hr_api.g_number
1702 ,p_employee_number in varchar2 default hr_api.g_varchar2
1703 ,p_start_date in date default hr_api.g_date
1704 ,p_original_start_date in date default hr_api.g_date
1705 ,p_adjusted_svc_date in date default hr_api.g_date
1706 ,p_base_salary in number default hr_api.g_number
1707 ,p_base_salary_change_date in date default hr_api.g_date
1708 ,p_payroll_name in varchar2 default hr_api.g_varchar2
1709 ,p_performance_rating in varchar2 default hr_api.g_varchar2
1710 ,p_performance_rating_type in varchar2 default hr_api.g_varchar2
1711 ,p_performance_rating_date in date default hr_api.g_date
1712 ,p_business_group_id in number default hr_api.g_number
1713 ,p_organization_id in number default hr_api.g_number
1714 ,p_job_id in number default hr_api.g_number
1715 ,p_grade_id in number default hr_api.g_number
1716 ,p_position_id in number default hr_api.g_number
1717 ,p_people_group_id in number default hr_api.g_number
1718 ,p_soft_coding_keyflex_id in number default hr_api.g_number
1719 ,p_location_id in number default hr_api.g_number
1723 ,p_grade_annulization_factor in number default hr_api.g_number
1720 ,p_pay_rate_id in number default hr_api.g_number
1721 ,p_assignment_status_type_id in number default hr_api.g_number
1722 ,p_frequency in varchar2 default hr_api.g_varchar2
1724 ,p_pay_annulization_factor in number default hr_api.g_number
1725 ,p_grd_min_val in number default hr_api.g_number
1726 ,p_grd_max_val in number default hr_api.g_number
1727 ,p_grd_mid_point in number default hr_api.g_number
1728 ,p_grd_quartile in varchar2 default hr_api.g_varchar2
1729 ,p_grd_comparatio in number default hr_api.g_number
1730 ,p_emp_category in varchar2 default hr_api.g_varchar2
1731 ,p_change_reason in varchar2 default hr_api.g_varchar2
1732 ,p_normal_hours in number default hr_api.g_number
1733 ,p_email_address in varchar2 default hr_api.g_varchar2
1734 ,p_base_salary_frequency in varchar2 default hr_api.g_varchar2
1735 ,p_new_assgn_ovn in number default hr_api.g_number
1736 ,p_new_perf_event_id in number default hr_api.g_number
1737 ,p_new_perf_review_id in number default hr_api.g_number
1738 ,p_post_process_stat_cd in varchar2 default hr_api.g_varchar2
1739 ,p_feedback_rating in varchar2 default hr_api.g_varchar2
1740 ,p_feedback_comments in varchar2 default hr_api.g_varchar2
1741 ,p_custom_segment1 in varchar2 default hr_api.g_varchar2
1742 ,p_custom_segment2 in varchar2 default hr_api.g_varchar2
1743 ,p_custom_segment3 in varchar2 default hr_api.g_varchar2
1744 ,p_custom_segment4 in varchar2 default hr_api.g_varchar2
1745 ,p_custom_segment5 in varchar2 default hr_api.g_varchar2
1746 ,p_custom_segment6 in varchar2 default hr_api.g_varchar2
1747 ,p_custom_segment7 in varchar2 default hr_api.g_varchar2
1748 ,p_custom_segment8 in varchar2 default hr_api.g_varchar2
1749 ,p_custom_segment9 in varchar2 default hr_api.g_varchar2
1750 ,p_custom_segment10 in varchar2 default hr_api.g_varchar2
1751 ,p_custom_segment11 in number default hr_api.g_number
1752 ,p_custom_segment12 in number default hr_api.g_number
1753 ,p_custom_segment13 in number default hr_api.g_number
1754 ,p_custom_segment14 in number default hr_api.g_number
1755 ,p_custom_segment15 in number default hr_api.g_number
1756 ,p_custom_segment16 in number default hr_api.g_number
1757 ,p_custom_segment17 in number default hr_api.g_number
1758 ,p_custom_segment18 in number default hr_api.g_number
1759 ,p_custom_segment19 in number default hr_api.g_number
1760 ,p_custom_segment20 in number default hr_api.g_number
1761 ,p_people_group_name in varchar2 default hr_api.g_varchar2
1762 ,p_people_group_segment1 in varchar2 default hr_api.g_varchar2
1763 ,p_people_group_segment2 in varchar2 default hr_api.g_varchar2
1764 ,p_people_group_segment3 in varchar2 default hr_api.g_varchar2
1765 ,p_people_group_segment4 in varchar2 default hr_api.g_varchar2
1766 ,p_people_group_segment5 in varchar2 default hr_api.g_varchar2
1767 ,p_people_group_segment6 in varchar2 default hr_api.g_varchar2
1768 ,p_people_group_segment7 in varchar2 default hr_api.g_varchar2
1769 ,p_people_group_segment8 in varchar2 default hr_api.g_varchar2
1770 ,p_people_group_segment9 in varchar2 default hr_api.g_varchar2
1771 ,p_people_group_segment10 in varchar2 default hr_api.g_varchar2
1772 ,p_people_group_segment11 in varchar2 default hr_api.g_varchar2
1773 ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
1774 ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
1775 ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
1776 ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
1777 ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
1778 ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
1779 ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
1780 ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
1781 ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
1782 ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
1783 ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
1784 ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
1785 ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
1786 ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
1787 ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
1788 ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
1789 ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
1790 ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
1791 ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
1792 ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
1793 ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
1794 ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
1795 ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
1796 ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
1797 ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
1798 ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
1802 ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
1799 ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
1800 ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
1801 ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
1803 ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
1804 ,p_ws_comments in varchar2 default hr_api.g_varchar2
1805 ,p_cpi_attribute_category in varchar2 default hr_api.g_varchar2
1806 ,p_cpi_attribute1 in varchar2 default hr_api.g_varchar2
1807 ,p_cpi_attribute2 in varchar2 default hr_api.g_varchar2
1808 ,p_cpi_attribute3 in varchar2 default hr_api.g_varchar2
1809 ,p_cpi_attribute4 in varchar2 default hr_api.g_varchar2
1810 ,p_cpi_attribute5 in varchar2 default hr_api.g_varchar2
1811 ,p_cpi_attribute6 in varchar2 default hr_api.g_varchar2
1812 ,p_cpi_attribute7 in varchar2 default hr_api.g_varchar2
1813 ,p_cpi_attribute8 in varchar2 default hr_api.g_varchar2
1814 ,p_cpi_attribute9 in varchar2 default hr_api.g_varchar2
1815 ,p_cpi_attribute10 in varchar2 default hr_api.g_varchar2
1816 ,p_cpi_attribute11 in varchar2 default hr_api.g_varchar2
1817 ,p_cpi_attribute12 in varchar2 default hr_api.g_varchar2
1818 ,p_cpi_attribute13 in varchar2 default hr_api.g_varchar2
1819 ,p_cpi_attribute14 in varchar2 default hr_api.g_varchar2
1820 ,p_cpi_attribute15 in varchar2 default hr_api.g_varchar2
1821 ,p_cpi_attribute16 in varchar2 default hr_api.g_varchar2
1822 ,p_cpi_attribute17 in varchar2 default hr_api.g_varchar2
1823 ,p_cpi_attribute18 in varchar2 default hr_api.g_varchar2
1824 ,p_cpi_attribute19 in varchar2 default hr_api.g_varchar2
1825 ,p_cpi_attribute20 in varchar2 default hr_api.g_varchar2
1826 ,p_cpi_attribute21 in varchar2 default hr_api.g_varchar2
1827 ,p_cpi_attribute22 in varchar2 default hr_api.g_varchar2
1828 ,p_cpi_attribute23 in varchar2 default hr_api.g_varchar2
1829 ,p_cpi_attribute24 in varchar2 default hr_api.g_varchar2
1830 ,p_cpi_attribute25 in varchar2 default hr_api.g_varchar2
1831 ,p_cpi_attribute26 in varchar2 default hr_api.g_varchar2
1832 ,p_cpi_attribute27 in varchar2 default hr_api.g_varchar2
1833 ,p_cpi_attribute28 in varchar2 default hr_api.g_varchar2
1834 ,p_cpi_attribute29 in varchar2 default hr_api.g_varchar2
1835 ,p_cpi_attribute30 in varchar2 default hr_api.g_varchar2
1836 ,p_feedback_date in date default hr_api.g_date
1837 ) is
1838 --
1839 l_rec ben_cpi_shd.g_rec_type;
1840 l_proc varchar2(72) := g_package||'upd';
1841 --
1842 Begin
1843 if g_debug then
1844 hr_utility.set_location('Entering:'||l_proc, 5);
1845 end if;
1846 --
1847 -- Call conversion function to turn arguments into the
1848 -- l_rec structure.
1849 --
1850 l_rec :=
1851 ben_cpi_shd.convert_args
1852 (p_group_per_in_ler_id
1853 ,p_assignment_id
1854 ,p_person_id
1855 ,p_supervisor_id
1856 ,p_effective_date
1857 ,p_full_name
1858 ,p_brief_name
1859 ,p_custom_name
1860 ,p_supervisor_full_name
1861 ,p_supervisor_brief_name
1862 ,p_supervisor_custom_name
1863 ,p_legislation_code
1864 ,p_years_employed
1865 ,p_years_in_job
1866 ,p_years_in_position
1867 ,p_years_in_grade
1868 ,p_employee_number
1869 ,p_start_date
1870 ,p_original_start_date
1871 ,p_adjusted_svc_date
1872 ,p_base_salary
1873 ,p_base_salary_change_date
1874 ,p_payroll_name
1875 ,p_performance_rating
1876 ,p_performance_rating_type
1877 ,p_performance_rating_date
1878 ,p_business_group_id
1879 ,p_organization_id
1880 ,p_job_id
1881 ,p_grade_id
1882 ,p_position_id
1883 ,p_people_group_id
1884 ,p_soft_coding_keyflex_id
1885 ,p_location_id
1886 ,p_pay_rate_id
1887 ,p_assignment_status_type_id
1888 ,p_frequency
1889 ,p_grade_annulization_factor
1890 ,p_pay_annulization_factor
1891 ,p_grd_min_val
1892 ,p_grd_max_val
1893 ,p_grd_mid_point
1894 ,p_grd_quartile
1895 ,p_grd_comparatio
1896 ,p_emp_category
1897 ,p_change_reason
1898 ,p_normal_hours
1899 ,p_email_address
1900 ,p_base_salary_frequency
1901 ,p_new_assgn_ovn
1902 ,p_new_perf_event_id
1903 ,p_new_perf_review_id
1904 ,p_post_process_stat_cd
1905 ,p_feedback_rating
1906 ,p_feedback_comments
1907 ,p_object_version_number
1908 ,p_custom_segment1
1909 ,p_custom_segment2
1910 ,p_custom_segment3
1911 ,p_custom_segment4
1912 ,p_custom_segment5
1913 ,p_custom_segment6
1914 ,p_custom_segment7
1915 ,p_custom_segment8
1916 ,p_custom_segment9
1917 ,p_custom_segment10
1918 ,p_custom_segment11
1919 ,p_custom_segment12
1920 ,p_custom_segment13
1921 ,p_custom_segment14
1922 ,p_custom_segment15
1923 ,p_custom_segment16
1924 ,p_custom_segment17
1925 ,p_custom_segment18
1926 ,p_custom_segment19
1927 ,p_custom_segment20
1928 ,p_people_group_name
1929 ,p_people_group_segment1
1930 ,p_people_group_segment2
1931 ,p_people_group_segment3
1932 ,p_people_group_segment4
1933 ,p_people_group_segment5
1934 ,p_people_group_segment6
1935 ,p_people_group_segment7
1936 ,p_people_group_segment8
1937 ,p_people_group_segment9
1938 ,p_people_group_segment10
1939 ,p_people_group_segment11
1940 ,p_ass_attribute_category
1941 ,p_ass_attribute1
1942 ,p_ass_attribute2
1943 ,p_ass_attribute3
1944 ,p_ass_attribute4
1945 ,p_ass_attribute5
1946 ,p_ass_attribute6
1947 ,p_ass_attribute7
1948 ,p_ass_attribute8
1949 ,p_ass_attribute9
1950 ,p_ass_attribute10
1951 ,p_ass_attribute11
1952 ,p_ass_attribute12
1953 ,p_ass_attribute13
1954 ,p_ass_attribute14
1955 ,p_ass_attribute15
1956 ,p_ass_attribute16
1957 ,p_ass_attribute17
1958 ,p_ass_attribute18
1959 ,p_ass_attribute19
1960 ,p_ass_attribute20
1961 ,p_ass_attribute21
1962 ,p_ass_attribute22
1963 ,p_ass_attribute23
1964 ,p_ass_attribute24
1965 ,p_ass_attribute25
1966 ,p_ass_attribute26
1967 ,p_ass_attribute27
1968 ,p_ass_attribute28
1969 ,p_ass_attribute29
1970 ,p_ass_attribute30
1971 ,p_ws_comments
1972 ,p_cpi_attribute_category
1973 ,p_cpi_attribute1
1974 ,p_cpi_attribute2
1975 ,p_cpi_attribute3
1976 ,p_cpi_attribute4
1977 ,p_cpi_attribute5
1978 ,p_cpi_attribute6
1979 ,p_cpi_attribute7
1980 ,p_cpi_attribute8
1981 ,p_cpi_attribute9
1982 ,p_cpi_attribute10
1983 ,p_cpi_attribute11
1984 ,p_cpi_attribute12
1985 ,p_cpi_attribute13
1986 ,p_cpi_attribute14
1987 ,p_cpi_attribute15
1988 ,p_cpi_attribute16
1989 ,p_cpi_attribute17
1990 ,p_cpi_attribute18
1991 ,p_cpi_attribute19
1992 ,p_cpi_attribute20
1993 ,p_cpi_attribute21
1994 ,p_cpi_attribute22
1995 ,p_cpi_attribute23
1996 ,p_cpi_attribute24
1997 ,p_cpi_attribute25
1998 ,p_cpi_attribute26
1999 ,p_cpi_attribute27
2000 ,p_cpi_attribute28
2001 ,p_cpi_attribute29
2002 ,p_cpi_attribute30
2003 ,p_feedback_date
2004 );
2005 --
2006 -- Having converted the arguments into the
2007 -- plsql record structure we call the corresponding record
2008 -- business process.
2009 --
2010 ben_cpi_upd.upd
2011 (l_rec
2012 );
2013 p_object_version_number := l_rec.object_version_number;
2014 --
2015 if g_debug then
2016 hr_utility.set_location(' Leaving:'||l_proc, 10);
2017 end if;
2018 End upd;
2019 --
2020 end ben_cpi_upd;