[Home] [Help]
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_abs_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: per_abs_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the per_absence_attendances Row
69: --
70: update per_absence_attendances
158: ,object_version_number = p_rec.object_version_number
159: ,absence_case_id = p_rec.absence_case_id
160: where absence_attendance_id = p_rec.absence_attendance_id;
161: --
162: per_abs_shd.g_api_dml := false; -- Unset the api dml status
163: --
164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: --
166: Exception
165: --
166: Exception
167: When hr_api.check_integrity_violated Then
168: -- A check constraint has been violated
169: per_abs_shd.g_api_dml := false; -- Unset the api dml status
170: per_abs_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.parent_integrity_violated Then
173: -- Parent integrity has been violated
166: Exception
167: When hr_api.check_integrity_violated Then
168: -- A check constraint has been violated
169: per_abs_shd.g_api_dml := false; -- Unset the api dml status
170: per_abs_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.parent_integrity_violated Then
173: -- Parent integrity has been violated
174: per_abs_shd.g_api_dml := false; -- Unset the api dml status
170: per_abs_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.parent_integrity_violated Then
173: -- Parent integrity has been violated
174: per_abs_shd.g_api_dml := false; -- Unset the api dml status
175: per_abs_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.unique_integrity_violated Then
178: -- Unique integrity has been violated
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.parent_integrity_violated Then
173: -- Parent integrity has been violated
174: per_abs_shd.g_api_dml := false; -- Unset the api dml status
175: per_abs_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.unique_integrity_violated Then
178: -- Unique integrity has been violated
179: per_abs_shd.g_api_dml := false; -- Unset the api dml status
175: per_abs_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.unique_integrity_violated Then
178: -- Unique integrity has been violated
179: per_abs_shd.g_api_dml := false; -- Unset the api dml status
180: per_abs_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When Others Then
183: per_abs_shd.g_api_dml := false; -- Unset the api dml status
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.unique_integrity_violated Then
178: -- Unique integrity has been violated
179: per_abs_shd.g_api_dml := false; -- Unset the api dml status
180: per_abs_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When Others Then
183: per_abs_shd.g_api_dml := false; -- Unset the api dml status
184: Raise;
179: per_abs_shd.g_api_dml := false; -- Unset the api dml status
180: per_abs_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When Others Then
183: per_abs_shd.g_api_dml := false; -- Unset the api dml status
184: Raise;
185: End update_dml;
186: --
187: -- ----------------------------------------------------------------------------
216: --
217: -- {End Of Comments}
218: -- ----------------------------------------------------------------------------
219: Procedure pre_update
220: (p_rec in out nocopy per_abs_shd.g_rec_type
221: ,p_effective_date in date
222: ) is
223: --
224: l_proc varchar2(72) := g_package||'pre_update';
251: -- Set the absence durations. Note that the durations are set
252: -- to global variables because the values may have been over-
253: -- written by the system.
254: --
255: p_rec.absence_hours := per_abs_shd.g_absence_hours;
256: p_rec.absence_days := per_abs_shd.g_absence_days;
257:
258: hr_utility.set_location(' Leaving:'||l_proc, 10);
259:
252: -- to global variables because the values may have been over-
253: -- written by the system.
254: --
255: p_rec.absence_hours := per_abs_shd.g_absence_hours;
256: p_rec.absence_days := per_abs_shd.g_absence_days;
257:
258: hr_utility.set_location(' Leaving:'||l_proc, 10);
259:
260: End pre_update;
292: -- {End Of Comments}
293: -- ----------------------------------------------------------------------------
294: Procedure post_update
295: (p_effective_date in date
296: ,p_rec in per_abs_shd.g_rec_type
297: ) is
298: --
299: l_proc varchar2(72) := g_package||'post_update';
300: --
478: => p_rec.batch_id
479: ,p_object_version_number
480: => p_rec.object_version_number
481: ,p_business_group_id_o
482: => per_abs_shd.g_old_rec.business_group_id
483: ,p_absence_attendance_type_id_o
484: => per_abs_shd.g_old_rec.absence_attendance_type_id
485: ,p_abs_attendance_reason_id_o
486: => per_abs_shd.g_old_rec.abs_attendance_reason_id
480: => p_rec.object_version_number
481: ,p_business_group_id_o
482: => per_abs_shd.g_old_rec.business_group_id
483: ,p_absence_attendance_type_id_o
484: => per_abs_shd.g_old_rec.absence_attendance_type_id
485: ,p_abs_attendance_reason_id_o
486: => per_abs_shd.g_old_rec.abs_attendance_reason_id
487: ,p_person_id_o
488: => per_abs_shd.g_old_rec.person_id
482: => per_abs_shd.g_old_rec.business_group_id
483: ,p_absence_attendance_type_id_o
484: => per_abs_shd.g_old_rec.absence_attendance_type_id
485: ,p_abs_attendance_reason_id_o
486: => per_abs_shd.g_old_rec.abs_attendance_reason_id
487: ,p_person_id_o
488: => per_abs_shd.g_old_rec.person_id
489: ,p_authorising_person_id_o
490: => per_abs_shd.g_old_rec.authorising_person_id
484: => per_abs_shd.g_old_rec.absence_attendance_type_id
485: ,p_abs_attendance_reason_id_o
486: => per_abs_shd.g_old_rec.abs_attendance_reason_id
487: ,p_person_id_o
488: => per_abs_shd.g_old_rec.person_id
489: ,p_authorising_person_id_o
490: => per_abs_shd.g_old_rec.authorising_person_id
491: ,p_replacement_person_id_o
492: => per_abs_shd.g_old_rec.replacement_person_id
486: => per_abs_shd.g_old_rec.abs_attendance_reason_id
487: ,p_person_id_o
488: => per_abs_shd.g_old_rec.person_id
489: ,p_authorising_person_id_o
490: => per_abs_shd.g_old_rec.authorising_person_id
491: ,p_replacement_person_id_o
492: => per_abs_shd.g_old_rec.replacement_person_id
493: ,p_period_of_incapacity_id_o
494: => per_abs_shd.g_old_rec.period_of_incapacity_id
488: => per_abs_shd.g_old_rec.person_id
489: ,p_authorising_person_id_o
490: => per_abs_shd.g_old_rec.authorising_person_id
491: ,p_replacement_person_id_o
492: => per_abs_shd.g_old_rec.replacement_person_id
493: ,p_period_of_incapacity_id_o
494: => per_abs_shd.g_old_rec.period_of_incapacity_id
495: ,p_absence_days_o
496: => per_abs_shd.g_old_rec.absence_days
490: => per_abs_shd.g_old_rec.authorising_person_id
491: ,p_replacement_person_id_o
492: => per_abs_shd.g_old_rec.replacement_person_id
493: ,p_period_of_incapacity_id_o
494: => per_abs_shd.g_old_rec.period_of_incapacity_id
495: ,p_absence_days_o
496: => per_abs_shd.g_old_rec.absence_days
497: ,p_absence_hours_o
498: => per_abs_shd.g_old_rec.absence_hours
492: => per_abs_shd.g_old_rec.replacement_person_id
493: ,p_period_of_incapacity_id_o
494: => per_abs_shd.g_old_rec.period_of_incapacity_id
495: ,p_absence_days_o
496: => per_abs_shd.g_old_rec.absence_days
497: ,p_absence_hours_o
498: => per_abs_shd.g_old_rec.absence_hours
499: ,p_comments_o
500: => per_abs_shd.g_old_rec.comments
494: => per_abs_shd.g_old_rec.period_of_incapacity_id
495: ,p_absence_days_o
496: => per_abs_shd.g_old_rec.absence_days
497: ,p_absence_hours_o
498: => per_abs_shd.g_old_rec.absence_hours
499: ,p_comments_o
500: => per_abs_shd.g_old_rec.comments
501: ,p_date_end_o
502: => per_abs_shd.g_old_rec.date_end
496: => per_abs_shd.g_old_rec.absence_days
497: ,p_absence_hours_o
498: => per_abs_shd.g_old_rec.absence_hours
499: ,p_comments_o
500: => per_abs_shd.g_old_rec.comments
501: ,p_date_end_o
502: => per_abs_shd.g_old_rec.date_end
503: ,p_date_notification_o
504: => per_abs_shd.g_old_rec.date_notification
498: => per_abs_shd.g_old_rec.absence_hours
499: ,p_comments_o
500: => per_abs_shd.g_old_rec.comments
501: ,p_date_end_o
502: => per_abs_shd.g_old_rec.date_end
503: ,p_date_notification_o
504: => per_abs_shd.g_old_rec.date_notification
505: ,p_date_projected_end_o
506: => per_abs_shd.g_old_rec.date_projected_end
500: => per_abs_shd.g_old_rec.comments
501: ,p_date_end_o
502: => per_abs_shd.g_old_rec.date_end
503: ,p_date_notification_o
504: => per_abs_shd.g_old_rec.date_notification
505: ,p_date_projected_end_o
506: => per_abs_shd.g_old_rec.date_projected_end
507: ,p_date_projected_start_o
508: => per_abs_shd.g_old_rec.date_projected_start
502: => per_abs_shd.g_old_rec.date_end
503: ,p_date_notification_o
504: => per_abs_shd.g_old_rec.date_notification
505: ,p_date_projected_end_o
506: => per_abs_shd.g_old_rec.date_projected_end
507: ,p_date_projected_start_o
508: => per_abs_shd.g_old_rec.date_projected_start
509: ,p_date_start_o
510: => per_abs_shd.g_old_rec.date_start
504: => per_abs_shd.g_old_rec.date_notification
505: ,p_date_projected_end_o
506: => per_abs_shd.g_old_rec.date_projected_end
507: ,p_date_projected_start_o
508: => per_abs_shd.g_old_rec.date_projected_start
509: ,p_date_start_o
510: => per_abs_shd.g_old_rec.date_start
511: ,p_occurrence_o
512: => per_abs_shd.g_old_rec.occurrence
506: => per_abs_shd.g_old_rec.date_projected_end
507: ,p_date_projected_start_o
508: => per_abs_shd.g_old_rec.date_projected_start
509: ,p_date_start_o
510: => per_abs_shd.g_old_rec.date_start
511: ,p_occurrence_o
512: => per_abs_shd.g_old_rec.occurrence
513: ,p_ssp1_issued_o
514: => per_abs_shd.g_old_rec.ssp1_issued
508: => per_abs_shd.g_old_rec.date_projected_start
509: ,p_date_start_o
510: => per_abs_shd.g_old_rec.date_start
511: ,p_occurrence_o
512: => per_abs_shd.g_old_rec.occurrence
513: ,p_ssp1_issued_o
514: => per_abs_shd.g_old_rec.ssp1_issued
515: ,p_time_end_o
516: => per_abs_shd.g_old_rec.time_end
510: => per_abs_shd.g_old_rec.date_start
511: ,p_occurrence_o
512: => per_abs_shd.g_old_rec.occurrence
513: ,p_ssp1_issued_o
514: => per_abs_shd.g_old_rec.ssp1_issued
515: ,p_time_end_o
516: => per_abs_shd.g_old_rec.time_end
517: ,p_time_projected_end_o
518: => per_abs_shd.g_old_rec.time_projected_end
512: => per_abs_shd.g_old_rec.occurrence
513: ,p_ssp1_issued_o
514: => per_abs_shd.g_old_rec.ssp1_issued
515: ,p_time_end_o
516: => per_abs_shd.g_old_rec.time_end
517: ,p_time_projected_end_o
518: => per_abs_shd.g_old_rec.time_projected_end
519: ,p_time_projected_start_o
520: => per_abs_shd.g_old_rec.time_projected_start
514: => per_abs_shd.g_old_rec.ssp1_issued
515: ,p_time_end_o
516: => per_abs_shd.g_old_rec.time_end
517: ,p_time_projected_end_o
518: => per_abs_shd.g_old_rec.time_projected_end
519: ,p_time_projected_start_o
520: => per_abs_shd.g_old_rec.time_projected_start
521: ,p_time_start_o
522: => per_abs_shd.g_old_rec.time_start
516: => per_abs_shd.g_old_rec.time_end
517: ,p_time_projected_end_o
518: => per_abs_shd.g_old_rec.time_projected_end
519: ,p_time_projected_start_o
520: => per_abs_shd.g_old_rec.time_projected_start
521: ,p_time_start_o
522: => per_abs_shd.g_old_rec.time_start
523: ,p_request_id_o
524: => per_abs_shd.g_old_rec.request_id
518: => per_abs_shd.g_old_rec.time_projected_end
519: ,p_time_projected_start_o
520: => per_abs_shd.g_old_rec.time_projected_start
521: ,p_time_start_o
522: => per_abs_shd.g_old_rec.time_start
523: ,p_request_id_o
524: => per_abs_shd.g_old_rec.request_id
525: ,p_program_application_id_o
526: => per_abs_shd.g_old_rec.program_application_id
520: => per_abs_shd.g_old_rec.time_projected_start
521: ,p_time_start_o
522: => per_abs_shd.g_old_rec.time_start
523: ,p_request_id_o
524: => per_abs_shd.g_old_rec.request_id
525: ,p_program_application_id_o
526: => per_abs_shd.g_old_rec.program_application_id
527: ,p_program_id_o
528: => per_abs_shd.g_old_rec.program_id
522: => per_abs_shd.g_old_rec.time_start
523: ,p_request_id_o
524: => per_abs_shd.g_old_rec.request_id
525: ,p_program_application_id_o
526: => per_abs_shd.g_old_rec.program_application_id
527: ,p_program_id_o
528: => per_abs_shd.g_old_rec.program_id
529: ,p_program_update_date_o
530: => per_abs_shd.g_old_rec.program_update_date
524: => per_abs_shd.g_old_rec.request_id
525: ,p_program_application_id_o
526: => per_abs_shd.g_old_rec.program_application_id
527: ,p_program_id_o
528: => per_abs_shd.g_old_rec.program_id
529: ,p_program_update_date_o
530: => per_abs_shd.g_old_rec.program_update_date
531: ,p_attribute_category_o
532: => per_abs_shd.g_old_rec.attribute_category
526: => per_abs_shd.g_old_rec.program_application_id
527: ,p_program_id_o
528: => per_abs_shd.g_old_rec.program_id
529: ,p_program_update_date_o
530: => per_abs_shd.g_old_rec.program_update_date
531: ,p_attribute_category_o
532: => per_abs_shd.g_old_rec.attribute_category
533: ,p_attribute1_o
534: => per_abs_shd.g_old_rec.attribute1
528: => per_abs_shd.g_old_rec.program_id
529: ,p_program_update_date_o
530: => per_abs_shd.g_old_rec.program_update_date
531: ,p_attribute_category_o
532: => per_abs_shd.g_old_rec.attribute_category
533: ,p_attribute1_o
534: => per_abs_shd.g_old_rec.attribute1
535: ,p_attribute2_o
536: => per_abs_shd.g_old_rec.attribute2
530: => per_abs_shd.g_old_rec.program_update_date
531: ,p_attribute_category_o
532: => per_abs_shd.g_old_rec.attribute_category
533: ,p_attribute1_o
534: => per_abs_shd.g_old_rec.attribute1
535: ,p_attribute2_o
536: => per_abs_shd.g_old_rec.attribute2
537: ,p_attribute3_o
538: => per_abs_shd.g_old_rec.attribute3
532: => per_abs_shd.g_old_rec.attribute_category
533: ,p_attribute1_o
534: => per_abs_shd.g_old_rec.attribute1
535: ,p_attribute2_o
536: => per_abs_shd.g_old_rec.attribute2
537: ,p_attribute3_o
538: => per_abs_shd.g_old_rec.attribute3
539: ,p_attribute4_o
540: => per_abs_shd.g_old_rec.attribute4
534: => per_abs_shd.g_old_rec.attribute1
535: ,p_attribute2_o
536: => per_abs_shd.g_old_rec.attribute2
537: ,p_attribute3_o
538: => per_abs_shd.g_old_rec.attribute3
539: ,p_attribute4_o
540: => per_abs_shd.g_old_rec.attribute4
541: ,p_attribute5_o
542: => per_abs_shd.g_old_rec.attribute5
536: => per_abs_shd.g_old_rec.attribute2
537: ,p_attribute3_o
538: => per_abs_shd.g_old_rec.attribute3
539: ,p_attribute4_o
540: => per_abs_shd.g_old_rec.attribute4
541: ,p_attribute5_o
542: => per_abs_shd.g_old_rec.attribute5
543: ,p_attribute6_o
544: => per_abs_shd.g_old_rec.attribute6
538: => per_abs_shd.g_old_rec.attribute3
539: ,p_attribute4_o
540: => per_abs_shd.g_old_rec.attribute4
541: ,p_attribute5_o
542: => per_abs_shd.g_old_rec.attribute5
543: ,p_attribute6_o
544: => per_abs_shd.g_old_rec.attribute6
545: ,p_attribute7_o
546: => per_abs_shd.g_old_rec.attribute7
540: => per_abs_shd.g_old_rec.attribute4
541: ,p_attribute5_o
542: => per_abs_shd.g_old_rec.attribute5
543: ,p_attribute6_o
544: => per_abs_shd.g_old_rec.attribute6
545: ,p_attribute7_o
546: => per_abs_shd.g_old_rec.attribute7
547: ,p_attribute8_o
548: => per_abs_shd.g_old_rec.attribute8
542: => per_abs_shd.g_old_rec.attribute5
543: ,p_attribute6_o
544: => per_abs_shd.g_old_rec.attribute6
545: ,p_attribute7_o
546: => per_abs_shd.g_old_rec.attribute7
547: ,p_attribute8_o
548: => per_abs_shd.g_old_rec.attribute8
549: ,p_attribute9_o
550: => per_abs_shd.g_old_rec.attribute9
544: => per_abs_shd.g_old_rec.attribute6
545: ,p_attribute7_o
546: => per_abs_shd.g_old_rec.attribute7
547: ,p_attribute8_o
548: => per_abs_shd.g_old_rec.attribute8
549: ,p_attribute9_o
550: => per_abs_shd.g_old_rec.attribute9
551: ,p_attribute10_o
552: => per_abs_shd.g_old_rec.attribute10
546: => per_abs_shd.g_old_rec.attribute7
547: ,p_attribute8_o
548: => per_abs_shd.g_old_rec.attribute8
549: ,p_attribute9_o
550: => per_abs_shd.g_old_rec.attribute9
551: ,p_attribute10_o
552: => per_abs_shd.g_old_rec.attribute10
553: ,p_attribute11_o
554: => per_abs_shd.g_old_rec.attribute11
548: => per_abs_shd.g_old_rec.attribute8
549: ,p_attribute9_o
550: => per_abs_shd.g_old_rec.attribute9
551: ,p_attribute10_o
552: => per_abs_shd.g_old_rec.attribute10
553: ,p_attribute11_o
554: => per_abs_shd.g_old_rec.attribute11
555: ,p_attribute12_o
556: => per_abs_shd.g_old_rec.attribute12
550: => per_abs_shd.g_old_rec.attribute9
551: ,p_attribute10_o
552: => per_abs_shd.g_old_rec.attribute10
553: ,p_attribute11_o
554: => per_abs_shd.g_old_rec.attribute11
555: ,p_attribute12_o
556: => per_abs_shd.g_old_rec.attribute12
557: ,p_attribute13_o
558: => per_abs_shd.g_old_rec.attribute13
552: => per_abs_shd.g_old_rec.attribute10
553: ,p_attribute11_o
554: => per_abs_shd.g_old_rec.attribute11
555: ,p_attribute12_o
556: => per_abs_shd.g_old_rec.attribute12
557: ,p_attribute13_o
558: => per_abs_shd.g_old_rec.attribute13
559: ,p_attribute14_o
560: => per_abs_shd.g_old_rec.attribute14
554: => per_abs_shd.g_old_rec.attribute11
555: ,p_attribute12_o
556: => per_abs_shd.g_old_rec.attribute12
557: ,p_attribute13_o
558: => per_abs_shd.g_old_rec.attribute13
559: ,p_attribute14_o
560: => per_abs_shd.g_old_rec.attribute14
561: ,p_attribute15_o
562: => per_abs_shd.g_old_rec.attribute15
556: => per_abs_shd.g_old_rec.attribute12
557: ,p_attribute13_o
558: => per_abs_shd.g_old_rec.attribute13
559: ,p_attribute14_o
560: => per_abs_shd.g_old_rec.attribute14
561: ,p_attribute15_o
562: => per_abs_shd.g_old_rec.attribute15
563: ,p_attribute16_o
564: => per_abs_shd.g_old_rec.attribute16
558: => per_abs_shd.g_old_rec.attribute13
559: ,p_attribute14_o
560: => per_abs_shd.g_old_rec.attribute14
561: ,p_attribute15_o
562: => per_abs_shd.g_old_rec.attribute15
563: ,p_attribute16_o
564: => per_abs_shd.g_old_rec.attribute16
565: ,p_attribute17_o
566: => per_abs_shd.g_old_rec.attribute17
560: => per_abs_shd.g_old_rec.attribute14
561: ,p_attribute15_o
562: => per_abs_shd.g_old_rec.attribute15
563: ,p_attribute16_o
564: => per_abs_shd.g_old_rec.attribute16
565: ,p_attribute17_o
566: => per_abs_shd.g_old_rec.attribute17
567: ,p_attribute18_o
568: => per_abs_shd.g_old_rec.attribute18
562: => per_abs_shd.g_old_rec.attribute15
563: ,p_attribute16_o
564: => per_abs_shd.g_old_rec.attribute16
565: ,p_attribute17_o
566: => per_abs_shd.g_old_rec.attribute17
567: ,p_attribute18_o
568: => per_abs_shd.g_old_rec.attribute18
569: ,p_attribute19_o
570: => per_abs_shd.g_old_rec.attribute19
564: => per_abs_shd.g_old_rec.attribute16
565: ,p_attribute17_o
566: => per_abs_shd.g_old_rec.attribute17
567: ,p_attribute18_o
568: => per_abs_shd.g_old_rec.attribute18
569: ,p_attribute19_o
570: => per_abs_shd.g_old_rec.attribute19
571: ,p_attribute20_o
572: => per_abs_shd.g_old_rec.attribute20
566: => per_abs_shd.g_old_rec.attribute17
567: ,p_attribute18_o
568: => per_abs_shd.g_old_rec.attribute18
569: ,p_attribute19_o
570: => per_abs_shd.g_old_rec.attribute19
571: ,p_attribute20_o
572: => per_abs_shd.g_old_rec.attribute20
573: ,p_maternity_id_o
574: => per_abs_shd.g_old_rec.maternity_id
568: => per_abs_shd.g_old_rec.attribute18
569: ,p_attribute19_o
570: => per_abs_shd.g_old_rec.attribute19
571: ,p_attribute20_o
572: => per_abs_shd.g_old_rec.attribute20
573: ,p_maternity_id_o
574: => per_abs_shd.g_old_rec.maternity_id
575: ,p_sickness_start_date_o
576: => per_abs_shd.g_old_rec.sickness_start_date
570: => per_abs_shd.g_old_rec.attribute19
571: ,p_attribute20_o
572: => per_abs_shd.g_old_rec.attribute20
573: ,p_maternity_id_o
574: => per_abs_shd.g_old_rec.maternity_id
575: ,p_sickness_start_date_o
576: => per_abs_shd.g_old_rec.sickness_start_date
577: ,p_sickness_end_date_o
578: => per_abs_shd.g_old_rec.sickness_end_date
572: => per_abs_shd.g_old_rec.attribute20
573: ,p_maternity_id_o
574: => per_abs_shd.g_old_rec.maternity_id
575: ,p_sickness_start_date_o
576: => per_abs_shd.g_old_rec.sickness_start_date
577: ,p_sickness_end_date_o
578: => per_abs_shd.g_old_rec.sickness_end_date
579: ,p_pregnancy_related_illness_o
580: => per_abs_shd.g_old_rec.pregnancy_related_illness
574: => per_abs_shd.g_old_rec.maternity_id
575: ,p_sickness_start_date_o
576: => per_abs_shd.g_old_rec.sickness_start_date
577: ,p_sickness_end_date_o
578: => per_abs_shd.g_old_rec.sickness_end_date
579: ,p_pregnancy_related_illness_o
580: => per_abs_shd.g_old_rec.pregnancy_related_illness
581: ,p_reason_for_notification_de_o
582: => per_abs_shd.g_old_rec.reason_for_notification_delay
576: => per_abs_shd.g_old_rec.sickness_start_date
577: ,p_sickness_end_date_o
578: => per_abs_shd.g_old_rec.sickness_end_date
579: ,p_pregnancy_related_illness_o
580: => per_abs_shd.g_old_rec.pregnancy_related_illness
581: ,p_reason_for_notification_de_o
582: => per_abs_shd.g_old_rec.reason_for_notification_delay
583: ,p_accept_late_notification_f_o
584: => per_abs_shd.g_old_rec.accept_late_notification_flag
578: => per_abs_shd.g_old_rec.sickness_end_date
579: ,p_pregnancy_related_illness_o
580: => per_abs_shd.g_old_rec.pregnancy_related_illness
581: ,p_reason_for_notification_de_o
582: => per_abs_shd.g_old_rec.reason_for_notification_delay
583: ,p_accept_late_notification_f_o
584: => per_abs_shd.g_old_rec.accept_late_notification_flag
585: ,p_linked_absence_id_o
586: => per_abs_shd.g_old_rec.linked_absence_id
580: => per_abs_shd.g_old_rec.pregnancy_related_illness
581: ,p_reason_for_notification_de_o
582: => per_abs_shd.g_old_rec.reason_for_notification_delay
583: ,p_accept_late_notification_f_o
584: => per_abs_shd.g_old_rec.accept_late_notification_flag
585: ,p_linked_absence_id_o
586: => per_abs_shd.g_old_rec.linked_absence_id
587: ,p_abs_information_category_o
588: => per_abs_shd.g_old_rec.abs_information_category
582: => per_abs_shd.g_old_rec.reason_for_notification_delay
583: ,p_accept_late_notification_f_o
584: => per_abs_shd.g_old_rec.accept_late_notification_flag
585: ,p_linked_absence_id_o
586: => per_abs_shd.g_old_rec.linked_absence_id
587: ,p_abs_information_category_o
588: => per_abs_shd.g_old_rec.abs_information_category
589: ,p_abs_information1_o
590: => per_abs_shd.g_old_rec.abs_information1
584: => per_abs_shd.g_old_rec.accept_late_notification_flag
585: ,p_linked_absence_id_o
586: => per_abs_shd.g_old_rec.linked_absence_id
587: ,p_abs_information_category_o
588: => per_abs_shd.g_old_rec.abs_information_category
589: ,p_abs_information1_o
590: => per_abs_shd.g_old_rec.abs_information1
591: ,p_abs_information2_o
592: => per_abs_shd.g_old_rec.abs_information2
586: => per_abs_shd.g_old_rec.linked_absence_id
587: ,p_abs_information_category_o
588: => per_abs_shd.g_old_rec.abs_information_category
589: ,p_abs_information1_o
590: => per_abs_shd.g_old_rec.abs_information1
591: ,p_abs_information2_o
592: => per_abs_shd.g_old_rec.abs_information2
593: ,p_abs_information3_o
594: => per_abs_shd.g_old_rec.abs_information3
588: => per_abs_shd.g_old_rec.abs_information_category
589: ,p_abs_information1_o
590: => per_abs_shd.g_old_rec.abs_information1
591: ,p_abs_information2_o
592: => per_abs_shd.g_old_rec.abs_information2
593: ,p_abs_information3_o
594: => per_abs_shd.g_old_rec.abs_information3
595: ,p_abs_information4_o
596: => per_abs_shd.g_old_rec.abs_information4
590: => per_abs_shd.g_old_rec.abs_information1
591: ,p_abs_information2_o
592: => per_abs_shd.g_old_rec.abs_information2
593: ,p_abs_information3_o
594: => per_abs_shd.g_old_rec.abs_information3
595: ,p_abs_information4_o
596: => per_abs_shd.g_old_rec.abs_information4
597: ,p_abs_information5_o
598: => per_abs_shd.g_old_rec.abs_information5
592: => per_abs_shd.g_old_rec.abs_information2
593: ,p_abs_information3_o
594: => per_abs_shd.g_old_rec.abs_information3
595: ,p_abs_information4_o
596: => per_abs_shd.g_old_rec.abs_information4
597: ,p_abs_information5_o
598: => per_abs_shd.g_old_rec.abs_information5
599: ,p_abs_information6_o
600: => per_abs_shd.g_old_rec.abs_information6
594: => per_abs_shd.g_old_rec.abs_information3
595: ,p_abs_information4_o
596: => per_abs_shd.g_old_rec.abs_information4
597: ,p_abs_information5_o
598: => per_abs_shd.g_old_rec.abs_information5
599: ,p_abs_information6_o
600: => per_abs_shd.g_old_rec.abs_information6
601: ,p_abs_information7_o
602: => per_abs_shd.g_old_rec.abs_information7
596: => per_abs_shd.g_old_rec.abs_information4
597: ,p_abs_information5_o
598: => per_abs_shd.g_old_rec.abs_information5
599: ,p_abs_information6_o
600: => per_abs_shd.g_old_rec.abs_information6
601: ,p_abs_information7_o
602: => per_abs_shd.g_old_rec.abs_information7
603: ,p_abs_information8_o
604: => per_abs_shd.g_old_rec.abs_information8
598: => per_abs_shd.g_old_rec.abs_information5
599: ,p_abs_information6_o
600: => per_abs_shd.g_old_rec.abs_information6
601: ,p_abs_information7_o
602: => per_abs_shd.g_old_rec.abs_information7
603: ,p_abs_information8_o
604: => per_abs_shd.g_old_rec.abs_information8
605: ,p_abs_information9_o
606: => per_abs_shd.g_old_rec.abs_information9
600: => per_abs_shd.g_old_rec.abs_information6
601: ,p_abs_information7_o
602: => per_abs_shd.g_old_rec.abs_information7
603: ,p_abs_information8_o
604: => per_abs_shd.g_old_rec.abs_information8
605: ,p_abs_information9_o
606: => per_abs_shd.g_old_rec.abs_information9
607: ,p_abs_information10_o
608: => per_abs_shd.g_old_rec.abs_information10
602: => per_abs_shd.g_old_rec.abs_information7
603: ,p_abs_information8_o
604: => per_abs_shd.g_old_rec.abs_information8
605: ,p_abs_information9_o
606: => per_abs_shd.g_old_rec.abs_information9
607: ,p_abs_information10_o
608: => per_abs_shd.g_old_rec.abs_information10
609: ,p_abs_information11_o
610: => per_abs_shd.g_old_rec.abs_information11
604: => per_abs_shd.g_old_rec.abs_information8
605: ,p_abs_information9_o
606: => per_abs_shd.g_old_rec.abs_information9
607: ,p_abs_information10_o
608: => per_abs_shd.g_old_rec.abs_information10
609: ,p_abs_information11_o
610: => per_abs_shd.g_old_rec.abs_information11
611: ,p_abs_information12_o
612: => per_abs_shd.g_old_rec.abs_information12
606: => per_abs_shd.g_old_rec.abs_information9
607: ,p_abs_information10_o
608: => per_abs_shd.g_old_rec.abs_information10
609: ,p_abs_information11_o
610: => per_abs_shd.g_old_rec.abs_information11
611: ,p_abs_information12_o
612: => per_abs_shd.g_old_rec.abs_information12
613: ,p_abs_information13_o
614: => per_abs_shd.g_old_rec.abs_information13
608: => per_abs_shd.g_old_rec.abs_information10
609: ,p_abs_information11_o
610: => per_abs_shd.g_old_rec.abs_information11
611: ,p_abs_information12_o
612: => per_abs_shd.g_old_rec.abs_information12
613: ,p_abs_information13_o
614: => per_abs_shd.g_old_rec.abs_information13
615: ,p_abs_information14_o
616: => per_abs_shd.g_old_rec.abs_information14
610: => per_abs_shd.g_old_rec.abs_information11
611: ,p_abs_information12_o
612: => per_abs_shd.g_old_rec.abs_information12
613: ,p_abs_information13_o
614: => per_abs_shd.g_old_rec.abs_information13
615: ,p_abs_information14_o
616: => per_abs_shd.g_old_rec.abs_information14
617: ,p_abs_information15_o
618: => per_abs_shd.g_old_rec.abs_information15
612: => per_abs_shd.g_old_rec.abs_information12
613: ,p_abs_information13_o
614: => per_abs_shd.g_old_rec.abs_information13
615: ,p_abs_information14_o
616: => per_abs_shd.g_old_rec.abs_information14
617: ,p_abs_information15_o
618: => per_abs_shd.g_old_rec.abs_information15
619: ,p_abs_information16_o
620: => per_abs_shd.g_old_rec.abs_information16
614: => per_abs_shd.g_old_rec.abs_information13
615: ,p_abs_information14_o
616: => per_abs_shd.g_old_rec.abs_information14
617: ,p_abs_information15_o
618: => per_abs_shd.g_old_rec.abs_information15
619: ,p_abs_information16_o
620: => per_abs_shd.g_old_rec.abs_information16
621: ,p_abs_information17_o
622: => per_abs_shd.g_old_rec.abs_information17
616: => per_abs_shd.g_old_rec.abs_information14
617: ,p_abs_information15_o
618: => per_abs_shd.g_old_rec.abs_information15
619: ,p_abs_information16_o
620: => per_abs_shd.g_old_rec.abs_information16
621: ,p_abs_information17_o
622: => per_abs_shd.g_old_rec.abs_information17
623: ,p_abs_information18_o
624: => per_abs_shd.g_old_rec.abs_information18
618: => per_abs_shd.g_old_rec.abs_information15
619: ,p_abs_information16_o
620: => per_abs_shd.g_old_rec.abs_information16
621: ,p_abs_information17_o
622: => per_abs_shd.g_old_rec.abs_information17
623: ,p_abs_information18_o
624: => per_abs_shd.g_old_rec.abs_information18
625: ,p_abs_information19_o
626: => per_abs_shd.g_old_rec.abs_information19
620: => per_abs_shd.g_old_rec.abs_information16
621: ,p_abs_information17_o
622: => per_abs_shd.g_old_rec.abs_information17
623: ,p_abs_information18_o
624: => per_abs_shd.g_old_rec.abs_information18
625: ,p_abs_information19_o
626: => per_abs_shd.g_old_rec.abs_information19
627: ,p_abs_information20_o
628: => per_abs_shd.g_old_rec.abs_information20
622: => per_abs_shd.g_old_rec.abs_information17
623: ,p_abs_information18_o
624: => per_abs_shd.g_old_rec.abs_information18
625: ,p_abs_information19_o
626: => per_abs_shd.g_old_rec.abs_information19
627: ,p_abs_information20_o
628: => per_abs_shd.g_old_rec.abs_information20
629: ,p_abs_information21_o
630: => per_abs_shd.g_old_rec.abs_information21
624: => per_abs_shd.g_old_rec.abs_information18
625: ,p_abs_information19_o
626: => per_abs_shd.g_old_rec.abs_information19
627: ,p_abs_information20_o
628: => per_abs_shd.g_old_rec.abs_information20
629: ,p_abs_information21_o
630: => per_abs_shd.g_old_rec.abs_information21
631: ,p_abs_information22_o
632: => per_abs_shd.g_old_rec.abs_information22
626: => per_abs_shd.g_old_rec.abs_information19
627: ,p_abs_information20_o
628: => per_abs_shd.g_old_rec.abs_information20
629: ,p_abs_information21_o
630: => per_abs_shd.g_old_rec.abs_information21
631: ,p_abs_information22_o
632: => per_abs_shd.g_old_rec.abs_information22
633: ,p_abs_information23_o
634: => per_abs_shd.g_old_rec.abs_information23
628: => per_abs_shd.g_old_rec.abs_information20
629: ,p_abs_information21_o
630: => per_abs_shd.g_old_rec.abs_information21
631: ,p_abs_information22_o
632: => per_abs_shd.g_old_rec.abs_information22
633: ,p_abs_information23_o
634: => per_abs_shd.g_old_rec.abs_information23
635: ,p_abs_information24_o
636: => per_abs_shd.g_old_rec.abs_information24
630: => per_abs_shd.g_old_rec.abs_information21
631: ,p_abs_information22_o
632: => per_abs_shd.g_old_rec.abs_information22
633: ,p_abs_information23_o
634: => per_abs_shd.g_old_rec.abs_information23
635: ,p_abs_information24_o
636: => per_abs_shd.g_old_rec.abs_information24
637: ,p_abs_information25_o
638: => per_abs_shd.g_old_rec.abs_information25
632: => per_abs_shd.g_old_rec.abs_information22
633: ,p_abs_information23_o
634: => per_abs_shd.g_old_rec.abs_information23
635: ,p_abs_information24_o
636: => per_abs_shd.g_old_rec.abs_information24
637: ,p_abs_information25_o
638: => per_abs_shd.g_old_rec.abs_information25
639: ,p_abs_information26_o
640: => per_abs_shd.g_old_rec.abs_information26
634: => per_abs_shd.g_old_rec.abs_information23
635: ,p_abs_information24_o
636: => per_abs_shd.g_old_rec.abs_information24
637: ,p_abs_information25_o
638: => per_abs_shd.g_old_rec.abs_information25
639: ,p_abs_information26_o
640: => per_abs_shd.g_old_rec.abs_information26
641: ,p_abs_information27_o
642: => per_abs_shd.g_old_rec.abs_information27
636: => per_abs_shd.g_old_rec.abs_information24
637: ,p_abs_information25_o
638: => per_abs_shd.g_old_rec.abs_information25
639: ,p_abs_information26_o
640: => per_abs_shd.g_old_rec.abs_information26
641: ,p_abs_information27_o
642: => per_abs_shd.g_old_rec.abs_information27
643: ,p_abs_information28_o
644: => per_abs_shd.g_old_rec.abs_information28
638: => per_abs_shd.g_old_rec.abs_information25
639: ,p_abs_information26_o
640: => per_abs_shd.g_old_rec.abs_information26
641: ,p_abs_information27_o
642: => per_abs_shd.g_old_rec.abs_information27
643: ,p_abs_information28_o
644: => per_abs_shd.g_old_rec.abs_information28
645: ,p_abs_information29_o
646: => per_abs_shd.g_old_rec.abs_information29
640: => per_abs_shd.g_old_rec.abs_information26
641: ,p_abs_information27_o
642: => per_abs_shd.g_old_rec.abs_information27
643: ,p_abs_information28_o
644: => per_abs_shd.g_old_rec.abs_information28
645: ,p_abs_information29_o
646: => per_abs_shd.g_old_rec.abs_information29
647: ,p_abs_information30_o
648: => per_abs_shd.g_old_rec.abs_information30
642: => per_abs_shd.g_old_rec.abs_information27
643: ,p_abs_information28_o
644: => per_abs_shd.g_old_rec.abs_information28
645: ,p_abs_information29_o
646: => per_abs_shd.g_old_rec.abs_information29
647: ,p_abs_information30_o
648: => per_abs_shd.g_old_rec.abs_information30
649: ,p_batch_id_o
650: => per_abs_shd.g_old_rec.batch_id
644: => per_abs_shd.g_old_rec.abs_information28
645: ,p_abs_information29_o
646: => per_abs_shd.g_old_rec.abs_information29
647: ,p_abs_information30_o
648: => per_abs_shd.g_old_rec.abs_information30
649: ,p_batch_id_o
650: => per_abs_shd.g_old_rec.batch_id
651: ,p_absence_case_id_o
652: => per_abs_shd.g_old_rec.absence_case_id
646: => per_abs_shd.g_old_rec.abs_information29
647: ,p_abs_information30_o
648: => per_abs_shd.g_old_rec.abs_information30
649: ,p_batch_id_o
650: => per_abs_shd.g_old_rec.batch_id
651: ,p_absence_case_id_o
652: => per_abs_shd.g_old_rec.absence_case_id
653: ,p_object_version_number_o
654: => per_abs_shd.g_old_rec.object_version_number
648: => per_abs_shd.g_old_rec.abs_information30
649: ,p_batch_id_o
650: => per_abs_shd.g_old_rec.batch_id
651: ,p_absence_case_id_o
652: => per_abs_shd.g_old_rec.absence_case_id
653: ,p_object_version_number_o
654: => per_abs_shd.g_old_rec.object_version_number
655: );
656: --
650: => per_abs_shd.g_old_rec.batch_id
651: ,p_absence_case_id_o
652: => per_abs_shd.g_old_rec.absence_case_id
653: ,p_object_version_number_o
654: => per_abs_shd.g_old_rec.object_version_number
655: );
656: --
657: exception
658: --
710: --
711: -- {End Of Comments}
712: -- ----------------------------------------------------------------------------
713: Procedure convert_defs
714: (p_rec in out nocopy per_abs_shd.g_rec_type
715: ) is
716: --
717: Begin
718: --
722: -- is being used then we must set to the 'current' argument value.
723: --
724: If (p_rec.business_group_id = hr_api.g_number) then
725: p_rec.business_group_id :=
726: per_abs_shd.g_old_rec.business_group_id;
727: End If;
728: If (p_rec.absence_attendance_type_id = hr_api.g_number) then
729: p_rec.absence_attendance_type_id :=
730: per_abs_shd.g_old_rec.absence_attendance_type_id;
726: per_abs_shd.g_old_rec.business_group_id;
727: End If;
728: If (p_rec.absence_attendance_type_id = hr_api.g_number) then
729: p_rec.absence_attendance_type_id :=
730: per_abs_shd.g_old_rec.absence_attendance_type_id;
731: End If;
732: If (p_rec.abs_attendance_reason_id = hr_api.g_number) then
733: p_rec.abs_attendance_reason_id :=
734: per_abs_shd.g_old_rec.abs_attendance_reason_id;
730: per_abs_shd.g_old_rec.absence_attendance_type_id;
731: End If;
732: If (p_rec.abs_attendance_reason_id = hr_api.g_number) then
733: p_rec.abs_attendance_reason_id :=
734: per_abs_shd.g_old_rec.abs_attendance_reason_id;
735: End If;
736: If (p_rec.person_id = hr_api.g_number) then
737: p_rec.person_id :=
738: per_abs_shd.g_old_rec.person_id;
734: per_abs_shd.g_old_rec.abs_attendance_reason_id;
735: End If;
736: If (p_rec.person_id = hr_api.g_number) then
737: p_rec.person_id :=
738: per_abs_shd.g_old_rec.person_id;
739: End If;
740: If (p_rec.authorising_person_id = hr_api.g_number) then
741: p_rec.authorising_person_id :=
742: per_abs_shd.g_old_rec.authorising_person_id;
738: per_abs_shd.g_old_rec.person_id;
739: End If;
740: If (p_rec.authorising_person_id = hr_api.g_number) then
741: p_rec.authorising_person_id :=
742: per_abs_shd.g_old_rec.authorising_person_id;
743: End If;
744: If (p_rec.replacement_person_id = hr_api.g_number) then
745: p_rec.replacement_person_id :=
746: per_abs_shd.g_old_rec.replacement_person_id;
742: per_abs_shd.g_old_rec.authorising_person_id;
743: End If;
744: If (p_rec.replacement_person_id = hr_api.g_number) then
745: p_rec.replacement_person_id :=
746: per_abs_shd.g_old_rec.replacement_person_id;
747: End If;
748: If (p_rec.period_of_incapacity_id = hr_api.g_number) then
749: p_rec.period_of_incapacity_id :=
750: per_abs_shd.g_old_rec.period_of_incapacity_id;
746: per_abs_shd.g_old_rec.replacement_person_id;
747: End If;
748: If (p_rec.period_of_incapacity_id = hr_api.g_number) then
749: p_rec.period_of_incapacity_id :=
750: per_abs_shd.g_old_rec.period_of_incapacity_id;
751: End If;
752: If (p_rec.absence_days = hr_api.g_number) then
753: p_rec.absence_days :=
754: per_abs_shd.g_old_rec.absence_days;
750: per_abs_shd.g_old_rec.period_of_incapacity_id;
751: End If;
752: If (p_rec.absence_days = hr_api.g_number) then
753: p_rec.absence_days :=
754: per_abs_shd.g_old_rec.absence_days;
755: End If;
756: If (p_rec.absence_hours = hr_api.g_number) then
757: p_rec.absence_hours :=
758: per_abs_shd.g_old_rec.absence_hours;
754: per_abs_shd.g_old_rec.absence_days;
755: End If;
756: If (p_rec.absence_hours = hr_api.g_number) then
757: p_rec.absence_hours :=
758: per_abs_shd.g_old_rec.absence_hours;
759: End If;
760: If (p_rec.comments = hr_api.g_varchar2) then
761: p_rec.comments :=
762: per_abs_shd.g_old_rec.comments;
758: per_abs_shd.g_old_rec.absence_hours;
759: End If;
760: If (p_rec.comments = hr_api.g_varchar2) then
761: p_rec.comments :=
762: per_abs_shd.g_old_rec.comments;
763: End If;
764: If (p_rec.date_end = hr_api.g_date) then
765: p_rec.date_end :=
766: per_abs_shd.g_old_rec.date_end;
762: per_abs_shd.g_old_rec.comments;
763: End If;
764: If (p_rec.date_end = hr_api.g_date) then
765: p_rec.date_end :=
766: per_abs_shd.g_old_rec.date_end;
767: End If;
768: If (p_rec.date_notification = hr_api.g_date) then
769: p_rec.date_notification :=
770: per_abs_shd.g_old_rec.date_notification;
766: per_abs_shd.g_old_rec.date_end;
767: End If;
768: If (p_rec.date_notification = hr_api.g_date) then
769: p_rec.date_notification :=
770: per_abs_shd.g_old_rec.date_notification;
771: End If;
772: If (p_rec.date_projected_end = hr_api.g_date) then
773: p_rec.date_projected_end :=
774: per_abs_shd.g_old_rec.date_projected_end;
770: per_abs_shd.g_old_rec.date_notification;
771: End If;
772: If (p_rec.date_projected_end = hr_api.g_date) then
773: p_rec.date_projected_end :=
774: per_abs_shd.g_old_rec.date_projected_end;
775: End If;
776: If (p_rec.date_projected_start = hr_api.g_date) then
777: p_rec.date_projected_start :=
778: per_abs_shd.g_old_rec.date_projected_start;
774: per_abs_shd.g_old_rec.date_projected_end;
775: End If;
776: If (p_rec.date_projected_start = hr_api.g_date) then
777: p_rec.date_projected_start :=
778: per_abs_shd.g_old_rec.date_projected_start;
779: End If;
780: If (p_rec.date_start = hr_api.g_date) then
781: p_rec.date_start :=
782: per_abs_shd.g_old_rec.date_start;
778: per_abs_shd.g_old_rec.date_projected_start;
779: End If;
780: If (p_rec.date_start = hr_api.g_date) then
781: p_rec.date_start :=
782: per_abs_shd.g_old_rec.date_start;
783: End If;
784: If (p_rec.occurrence = hr_api.g_number) then
785: p_rec.occurrence :=
786: per_abs_shd.g_old_rec.occurrence;
782: per_abs_shd.g_old_rec.date_start;
783: End If;
784: If (p_rec.occurrence = hr_api.g_number) then
785: p_rec.occurrence :=
786: per_abs_shd.g_old_rec.occurrence;
787: End If;
788: If (p_rec.ssp1_issued = hr_api.g_varchar2) then
789: p_rec.ssp1_issued :=
790: per_abs_shd.g_old_rec.ssp1_issued;
786: per_abs_shd.g_old_rec.occurrence;
787: End If;
788: If (p_rec.ssp1_issued = hr_api.g_varchar2) then
789: p_rec.ssp1_issued :=
790: per_abs_shd.g_old_rec.ssp1_issued;
791: End If;
792: If (p_rec.time_end = hr_api.g_varchar2) then
793: p_rec.time_end :=
794: per_abs_shd.g_old_rec.time_end;
790: per_abs_shd.g_old_rec.ssp1_issued;
791: End If;
792: If (p_rec.time_end = hr_api.g_varchar2) then
793: p_rec.time_end :=
794: per_abs_shd.g_old_rec.time_end;
795: End If;
796: If (p_rec.time_projected_end = hr_api.g_varchar2) then
797: p_rec.time_projected_end :=
798: per_abs_shd.g_old_rec.time_projected_end;
794: per_abs_shd.g_old_rec.time_end;
795: End If;
796: If (p_rec.time_projected_end = hr_api.g_varchar2) then
797: p_rec.time_projected_end :=
798: per_abs_shd.g_old_rec.time_projected_end;
799: End If;
800: If (p_rec.time_projected_start = hr_api.g_varchar2) then
801: p_rec.time_projected_start :=
802: per_abs_shd.g_old_rec.time_projected_start;
798: per_abs_shd.g_old_rec.time_projected_end;
799: End If;
800: If (p_rec.time_projected_start = hr_api.g_varchar2) then
801: p_rec.time_projected_start :=
802: per_abs_shd.g_old_rec.time_projected_start;
803: End If;
804: If (p_rec.time_start = hr_api.g_varchar2) then
805: p_rec.time_start :=
806: per_abs_shd.g_old_rec.time_start;
802: per_abs_shd.g_old_rec.time_projected_start;
803: End If;
804: If (p_rec.time_start = hr_api.g_varchar2) then
805: p_rec.time_start :=
806: per_abs_shd.g_old_rec.time_start;
807: End If;
808: If (p_rec.request_id = hr_api.g_number) then
809: p_rec.request_id :=
810: per_abs_shd.g_old_rec.request_id;
806: per_abs_shd.g_old_rec.time_start;
807: End If;
808: If (p_rec.request_id = hr_api.g_number) then
809: p_rec.request_id :=
810: per_abs_shd.g_old_rec.request_id;
811: End If;
812: If (p_rec.program_application_id = hr_api.g_number) then
813: p_rec.program_application_id :=
814: per_abs_shd.g_old_rec.program_application_id;
810: per_abs_shd.g_old_rec.request_id;
811: End If;
812: If (p_rec.program_application_id = hr_api.g_number) then
813: p_rec.program_application_id :=
814: per_abs_shd.g_old_rec.program_application_id;
815: End If;
816: If (p_rec.program_id = hr_api.g_number) then
817: p_rec.program_id :=
818: per_abs_shd.g_old_rec.program_id;
814: per_abs_shd.g_old_rec.program_application_id;
815: End If;
816: If (p_rec.program_id = hr_api.g_number) then
817: p_rec.program_id :=
818: per_abs_shd.g_old_rec.program_id;
819: End If;
820: If (p_rec.program_update_date = hr_api.g_date) then
821: p_rec.program_update_date :=
822: per_abs_shd.g_old_rec.program_update_date;
818: per_abs_shd.g_old_rec.program_id;
819: End If;
820: If (p_rec.program_update_date = hr_api.g_date) then
821: p_rec.program_update_date :=
822: per_abs_shd.g_old_rec.program_update_date;
823: End If;
824: If (p_rec.attribute_category = hr_api.g_varchar2) then
825: p_rec.attribute_category :=
826: per_abs_shd.g_old_rec.attribute_category;
822: per_abs_shd.g_old_rec.program_update_date;
823: End If;
824: If (p_rec.attribute_category = hr_api.g_varchar2) then
825: p_rec.attribute_category :=
826: per_abs_shd.g_old_rec.attribute_category;
827: End If;
828: If (p_rec.attribute1 = hr_api.g_varchar2) then
829: p_rec.attribute1 :=
830: per_abs_shd.g_old_rec.attribute1;
826: per_abs_shd.g_old_rec.attribute_category;
827: End If;
828: If (p_rec.attribute1 = hr_api.g_varchar2) then
829: p_rec.attribute1 :=
830: per_abs_shd.g_old_rec.attribute1;
831: End If;
832: If (p_rec.attribute2 = hr_api.g_varchar2) then
833: p_rec.attribute2 :=
834: per_abs_shd.g_old_rec.attribute2;
830: per_abs_shd.g_old_rec.attribute1;
831: End If;
832: If (p_rec.attribute2 = hr_api.g_varchar2) then
833: p_rec.attribute2 :=
834: per_abs_shd.g_old_rec.attribute2;
835: End If;
836: If (p_rec.attribute3 = hr_api.g_varchar2) then
837: p_rec.attribute3 :=
838: per_abs_shd.g_old_rec.attribute3;
834: per_abs_shd.g_old_rec.attribute2;
835: End If;
836: If (p_rec.attribute3 = hr_api.g_varchar2) then
837: p_rec.attribute3 :=
838: per_abs_shd.g_old_rec.attribute3;
839: End If;
840: If (p_rec.attribute4 = hr_api.g_varchar2) then
841: p_rec.attribute4 :=
842: per_abs_shd.g_old_rec.attribute4;
838: per_abs_shd.g_old_rec.attribute3;
839: End If;
840: If (p_rec.attribute4 = hr_api.g_varchar2) then
841: p_rec.attribute4 :=
842: per_abs_shd.g_old_rec.attribute4;
843: End If;
844: If (p_rec.attribute5 = hr_api.g_varchar2) then
845: p_rec.attribute5 :=
846: per_abs_shd.g_old_rec.attribute5;
842: per_abs_shd.g_old_rec.attribute4;
843: End If;
844: If (p_rec.attribute5 = hr_api.g_varchar2) then
845: p_rec.attribute5 :=
846: per_abs_shd.g_old_rec.attribute5;
847: End If;
848: If (p_rec.attribute6 = hr_api.g_varchar2) then
849: p_rec.attribute6 :=
850: per_abs_shd.g_old_rec.attribute6;
846: per_abs_shd.g_old_rec.attribute5;
847: End If;
848: If (p_rec.attribute6 = hr_api.g_varchar2) then
849: p_rec.attribute6 :=
850: per_abs_shd.g_old_rec.attribute6;
851: End If;
852: If (p_rec.attribute7 = hr_api.g_varchar2) then
853: p_rec.attribute7 :=
854: per_abs_shd.g_old_rec.attribute7;
850: per_abs_shd.g_old_rec.attribute6;
851: End If;
852: If (p_rec.attribute7 = hr_api.g_varchar2) then
853: p_rec.attribute7 :=
854: per_abs_shd.g_old_rec.attribute7;
855: End If;
856: If (p_rec.attribute8 = hr_api.g_varchar2) then
857: p_rec.attribute8 :=
858: per_abs_shd.g_old_rec.attribute8;
854: per_abs_shd.g_old_rec.attribute7;
855: End If;
856: If (p_rec.attribute8 = hr_api.g_varchar2) then
857: p_rec.attribute8 :=
858: per_abs_shd.g_old_rec.attribute8;
859: End If;
860: If (p_rec.attribute9 = hr_api.g_varchar2) then
861: p_rec.attribute9 :=
862: per_abs_shd.g_old_rec.attribute9;
858: per_abs_shd.g_old_rec.attribute8;
859: End If;
860: If (p_rec.attribute9 = hr_api.g_varchar2) then
861: p_rec.attribute9 :=
862: per_abs_shd.g_old_rec.attribute9;
863: End If;
864: If (p_rec.attribute10 = hr_api.g_varchar2) then
865: p_rec.attribute10 :=
866: per_abs_shd.g_old_rec.attribute10;
862: per_abs_shd.g_old_rec.attribute9;
863: End If;
864: If (p_rec.attribute10 = hr_api.g_varchar2) then
865: p_rec.attribute10 :=
866: per_abs_shd.g_old_rec.attribute10;
867: End If;
868: If (p_rec.attribute11 = hr_api.g_varchar2) then
869: p_rec.attribute11 :=
870: per_abs_shd.g_old_rec.attribute11;
866: per_abs_shd.g_old_rec.attribute10;
867: End If;
868: If (p_rec.attribute11 = hr_api.g_varchar2) then
869: p_rec.attribute11 :=
870: per_abs_shd.g_old_rec.attribute11;
871: End If;
872: If (p_rec.attribute12 = hr_api.g_varchar2) then
873: p_rec.attribute12 :=
874: per_abs_shd.g_old_rec.attribute12;
870: per_abs_shd.g_old_rec.attribute11;
871: End If;
872: If (p_rec.attribute12 = hr_api.g_varchar2) then
873: p_rec.attribute12 :=
874: per_abs_shd.g_old_rec.attribute12;
875: End If;
876: If (p_rec.attribute13 = hr_api.g_varchar2) then
877: p_rec.attribute13 :=
878: per_abs_shd.g_old_rec.attribute13;
874: per_abs_shd.g_old_rec.attribute12;
875: End If;
876: If (p_rec.attribute13 = hr_api.g_varchar2) then
877: p_rec.attribute13 :=
878: per_abs_shd.g_old_rec.attribute13;
879: End If;
880: If (p_rec.attribute14 = hr_api.g_varchar2) then
881: p_rec.attribute14 :=
882: per_abs_shd.g_old_rec.attribute14;
878: per_abs_shd.g_old_rec.attribute13;
879: End If;
880: If (p_rec.attribute14 = hr_api.g_varchar2) then
881: p_rec.attribute14 :=
882: per_abs_shd.g_old_rec.attribute14;
883: End If;
884: If (p_rec.attribute15 = hr_api.g_varchar2) then
885: p_rec.attribute15 :=
886: per_abs_shd.g_old_rec.attribute15;
882: per_abs_shd.g_old_rec.attribute14;
883: End If;
884: If (p_rec.attribute15 = hr_api.g_varchar2) then
885: p_rec.attribute15 :=
886: per_abs_shd.g_old_rec.attribute15;
887: End If;
888: If (p_rec.attribute16 = hr_api.g_varchar2) then
889: p_rec.attribute16 :=
890: per_abs_shd.g_old_rec.attribute16;
886: per_abs_shd.g_old_rec.attribute15;
887: End If;
888: If (p_rec.attribute16 = hr_api.g_varchar2) then
889: p_rec.attribute16 :=
890: per_abs_shd.g_old_rec.attribute16;
891: End If;
892: If (p_rec.attribute17 = hr_api.g_varchar2) then
893: p_rec.attribute17 :=
894: per_abs_shd.g_old_rec.attribute17;
890: per_abs_shd.g_old_rec.attribute16;
891: End If;
892: If (p_rec.attribute17 = hr_api.g_varchar2) then
893: p_rec.attribute17 :=
894: per_abs_shd.g_old_rec.attribute17;
895: End If;
896: If (p_rec.attribute18 = hr_api.g_varchar2) then
897: p_rec.attribute18 :=
898: per_abs_shd.g_old_rec.attribute18;
894: per_abs_shd.g_old_rec.attribute17;
895: End If;
896: If (p_rec.attribute18 = hr_api.g_varchar2) then
897: p_rec.attribute18 :=
898: per_abs_shd.g_old_rec.attribute18;
899: End If;
900: If (p_rec.attribute19 = hr_api.g_varchar2) then
901: p_rec.attribute19 :=
902: per_abs_shd.g_old_rec.attribute19;
898: per_abs_shd.g_old_rec.attribute18;
899: End If;
900: If (p_rec.attribute19 = hr_api.g_varchar2) then
901: p_rec.attribute19 :=
902: per_abs_shd.g_old_rec.attribute19;
903: End If;
904: If (p_rec.attribute20 = hr_api.g_varchar2) then
905: p_rec.attribute20 :=
906: per_abs_shd.g_old_rec.attribute20;
902: per_abs_shd.g_old_rec.attribute19;
903: End If;
904: If (p_rec.attribute20 = hr_api.g_varchar2) then
905: p_rec.attribute20 :=
906: per_abs_shd.g_old_rec.attribute20;
907: End If;
908: If (p_rec.maternity_id = hr_api.g_number) then
909: p_rec.maternity_id :=
910: per_abs_shd.g_old_rec.maternity_id;
906: per_abs_shd.g_old_rec.attribute20;
907: End If;
908: If (p_rec.maternity_id = hr_api.g_number) then
909: p_rec.maternity_id :=
910: per_abs_shd.g_old_rec.maternity_id;
911: End If;
912: If (p_rec.sickness_start_date = hr_api.g_date) then
913: p_rec.sickness_start_date :=
914: per_abs_shd.g_old_rec.sickness_start_date;
910: per_abs_shd.g_old_rec.maternity_id;
911: End If;
912: If (p_rec.sickness_start_date = hr_api.g_date) then
913: p_rec.sickness_start_date :=
914: per_abs_shd.g_old_rec.sickness_start_date;
915: End If;
916: If (p_rec.sickness_end_date = hr_api.g_date) then
917: p_rec.sickness_end_date :=
918: per_abs_shd.g_old_rec.sickness_end_date;
914: per_abs_shd.g_old_rec.sickness_start_date;
915: End If;
916: If (p_rec.sickness_end_date = hr_api.g_date) then
917: p_rec.sickness_end_date :=
918: per_abs_shd.g_old_rec.sickness_end_date;
919: End If;
920: If (p_rec.pregnancy_related_illness = hr_api.g_varchar2) then
921: p_rec.pregnancy_related_illness :=
922: per_abs_shd.g_old_rec.pregnancy_related_illness;
918: per_abs_shd.g_old_rec.sickness_end_date;
919: End If;
920: If (p_rec.pregnancy_related_illness = hr_api.g_varchar2) then
921: p_rec.pregnancy_related_illness :=
922: per_abs_shd.g_old_rec.pregnancy_related_illness;
923: End If;
924: If (p_rec.reason_for_notification_delay = hr_api.g_varchar2) then
925: p_rec.reason_for_notification_delay :=
926: per_abs_shd.g_old_rec.reason_for_notification_delay;
922: per_abs_shd.g_old_rec.pregnancy_related_illness;
923: End If;
924: If (p_rec.reason_for_notification_delay = hr_api.g_varchar2) then
925: p_rec.reason_for_notification_delay :=
926: per_abs_shd.g_old_rec.reason_for_notification_delay;
927: End If;
928: If (p_rec.accept_late_notification_flag = hr_api.g_varchar2) then
929: p_rec.accept_late_notification_flag :=
930: per_abs_shd.g_old_rec.accept_late_notification_flag;
926: per_abs_shd.g_old_rec.reason_for_notification_delay;
927: End If;
928: If (p_rec.accept_late_notification_flag = hr_api.g_varchar2) then
929: p_rec.accept_late_notification_flag :=
930: per_abs_shd.g_old_rec.accept_late_notification_flag;
931: End If;
932: If (p_rec.linked_absence_id = hr_api.g_number) then
933: p_rec.linked_absence_id :=
934: per_abs_shd.g_old_rec.linked_absence_id;
930: per_abs_shd.g_old_rec.accept_late_notification_flag;
931: End If;
932: If (p_rec.linked_absence_id = hr_api.g_number) then
933: p_rec.linked_absence_id :=
934: per_abs_shd.g_old_rec.linked_absence_id;
935: End If;
936: If (p_rec.abs_information_category = hr_api.g_varchar2) then
937: p_rec.abs_information_category :=
938: per_abs_shd.g_old_rec.abs_information_category;
934: per_abs_shd.g_old_rec.linked_absence_id;
935: End If;
936: If (p_rec.abs_information_category = hr_api.g_varchar2) then
937: p_rec.abs_information_category :=
938: per_abs_shd.g_old_rec.abs_information_category;
939: End If;
940: If (p_rec.abs_information1 = hr_api.g_varchar2) then
941: p_rec.abs_information1 :=
942: per_abs_shd.g_old_rec.abs_information1;
938: per_abs_shd.g_old_rec.abs_information_category;
939: End If;
940: If (p_rec.abs_information1 = hr_api.g_varchar2) then
941: p_rec.abs_information1 :=
942: per_abs_shd.g_old_rec.abs_information1;
943: End If;
944: If (p_rec.abs_information2 = hr_api.g_varchar2) then
945: p_rec.abs_information2 :=
946: per_abs_shd.g_old_rec.abs_information2;
942: per_abs_shd.g_old_rec.abs_information1;
943: End If;
944: If (p_rec.abs_information2 = hr_api.g_varchar2) then
945: p_rec.abs_information2 :=
946: per_abs_shd.g_old_rec.abs_information2;
947: End If;
948: If (p_rec.abs_information3 = hr_api.g_varchar2) then
949: p_rec.abs_information3 :=
950: per_abs_shd.g_old_rec.abs_information3;
946: per_abs_shd.g_old_rec.abs_information2;
947: End If;
948: If (p_rec.abs_information3 = hr_api.g_varchar2) then
949: p_rec.abs_information3 :=
950: per_abs_shd.g_old_rec.abs_information3;
951: End If;
952: If (p_rec.abs_information4 = hr_api.g_varchar2) then
953: p_rec.abs_information4 :=
954: per_abs_shd.g_old_rec.abs_information4;
950: per_abs_shd.g_old_rec.abs_information3;
951: End If;
952: If (p_rec.abs_information4 = hr_api.g_varchar2) then
953: p_rec.abs_information4 :=
954: per_abs_shd.g_old_rec.abs_information4;
955: End If;
956: If (p_rec.abs_information5 = hr_api.g_varchar2) then
957: p_rec.abs_information5 :=
958: per_abs_shd.g_old_rec.abs_information5;
954: per_abs_shd.g_old_rec.abs_information4;
955: End If;
956: If (p_rec.abs_information5 = hr_api.g_varchar2) then
957: p_rec.abs_information5 :=
958: per_abs_shd.g_old_rec.abs_information5;
959: End If;
960: If (p_rec.abs_information6 = hr_api.g_varchar2) then
961: p_rec.abs_information6 :=
962: per_abs_shd.g_old_rec.abs_information6;
958: per_abs_shd.g_old_rec.abs_information5;
959: End If;
960: If (p_rec.abs_information6 = hr_api.g_varchar2) then
961: p_rec.abs_information6 :=
962: per_abs_shd.g_old_rec.abs_information6;
963: End If;
964: If (p_rec.abs_information7 = hr_api.g_varchar2) then
965: p_rec.abs_information7 :=
966: per_abs_shd.g_old_rec.abs_information7;
962: per_abs_shd.g_old_rec.abs_information6;
963: End If;
964: If (p_rec.abs_information7 = hr_api.g_varchar2) then
965: p_rec.abs_information7 :=
966: per_abs_shd.g_old_rec.abs_information7;
967: End If;
968: If (p_rec.abs_information8 = hr_api.g_varchar2) then
969: p_rec.abs_information8 :=
970: per_abs_shd.g_old_rec.abs_information8;
966: per_abs_shd.g_old_rec.abs_information7;
967: End If;
968: If (p_rec.abs_information8 = hr_api.g_varchar2) then
969: p_rec.abs_information8 :=
970: per_abs_shd.g_old_rec.abs_information8;
971: End If;
972: If (p_rec.abs_information9 = hr_api.g_varchar2) then
973: p_rec.abs_information9 :=
974: per_abs_shd.g_old_rec.abs_information9;
970: per_abs_shd.g_old_rec.abs_information8;
971: End If;
972: If (p_rec.abs_information9 = hr_api.g_varchar2) then
973: p_rec.abs_information9 :=
974: per_abs_shd.g_old_rec.abs_information9;
975: End If;
976: If (p_rec.abs_information10 = hr_api.g_varchar2) then
977: p_rec.abs_information10 :=
978: per_abs_shd.g_old_rec.abs_information10;
974: per_abs_shd.g_old_rec.abs_information9;
975: End If;
976: If (p_rec.abs_information10 = hr_api.g_varchar2) then
977: p_rec.abs_information10 :=
978: per_abs_shd.g_old_rec.abs_information10;
979: End If;
980: If (p_rec.abs_information11 = hr_api.g_varchar2) then
981: p_rec.abs_information11 :=
982: per_abs_shd.g_old_rec.abs_information11;
978: per_abs_shd.g_old_rec.abs_information10;
979: End If;
980: If (p_rec.abs_information11 = hr_api.g_varchar2) then
981: p_rec.abs_information11 :=
982: per_abs_shd.g_old_rec.abs_information11;
983: End If;
984: If (p_rec.abs_information12 = hr_api.g_varchar2) then
985: p_rec.abs_information12 :=
986: per_abs_shd.g_old_rec.abs_information12;
982: per_abs_shd.g_old_rec.abs_information11;
983: End If;
984: If (p_rec.abs_information12 = hr_api.g_varchar2) then
985: p_rec.abs_information12 :=
986: per_abs_shd.g_old_rec.abs_information12;
987: End If;
988: If (p_rec.abs_information13 = hr_api.g_varchar2) then
989: p_rec.abs_information13 :=
990: per_abs_shd.g_old_rec.abs_information13;
986: per_abs_shd.g_old_rec.abs_information12;
987: End If;
988: If (p_rec.abs_information13 = hr_api.g_varchar2) then
989: p_rec.abs_information13 :=
990: per_abs_shd.g_old_rec.abs_information13;
991: End If;
992: If (p_rec.abs_information14 = hr_api.g_varchar2) then
993: p_rec.abs_information14 :=
994: per_abs_shd.g_old_rec.abs_information14;
990: per_abs_shd.g_old_rec.abs_information13;
991: End If;
992: If (p_rec.abs_information14 = hr_api.g_varchar2) then
993: p_rec.abs_information14 :=
994: per_abs_shd.g_old_rec.abs_information14;
995: End If;
996: If (p_rec.abs_information15 = hr_api.g_varchar2) then
997: p_rec.abs_information15 :=
998: per_abs_shd.g_old_rec.abs_information15;
994: per_abs_shd.g_old_rec.abs_information14;
995: End If;
996: If (p_rec.abs_information15 = hr_api.g_varchar2) then
997: p_rec.abs_information15 :=
998: per_abs_shd.g_old_rec.abs_information15;
999: End If;
1000: If (p_rec.abs_information16 = hr_api.g_varchar2) then
1001: p_rec.abs_information16 :=
1002: per_abs_shd.g_old_rec.abs_information16;
998: per_abs_shd.g_old_rec.abs_information15;
999: End If;
1000: If (p_rec.abs_information16 = hr_api.g_varchar2) then
1001: p_rec.abs_information16 :=
1002: per_abs_shd.g_old_rec.abs_information16;
1003: End If;
1004: If (p_rec.abs_information17 = hr_api.g_varchar2) then
1005: p_rec.abs_information17 :=
1006: per_abs_shd.g_old_rec.abs_information17;
1002: per_abs_shd.g_old_rec.abs_information16;
1003: End If;
1004: If (p_rec.abs_information17 = hr_api.g_varchar2) then
1005: p_rec.abs_information17 :=
1006: per_abs_shd.g_old_rec.abs_information17;
1007: End If;
1008: If (p_rec.abs_information18 = hr_api.g_varchar2) then
1009: p_rec.abs_information18 :=
1010: per_abs_shd.g_old_rec.abs_information18;
1006: per_abs_shd.g_old_rec.abs_information17;
1007: End If;
1008: If (p_rec.abs_information18 = hr_api.g_varchar2) then
1009: p_rec.abs_information18 :=
1010: per_abs_shd.g_old_rec.abs_information18;
1011: End If;
1012: If (p_rec.abs_information19 = hr_api.g_varchar2) then
1013: p_rec.abs_information19 :=
1014: per_abs_shd.g_old_rec.abs_information19;
1010: per_abs_shd.g_old_rec.abs_information18;
1011: End If;
1012: If (p_rec.abs_information19 = hr_api.g_varchar2) then
1013: p_rec.abs_information19 :=
1014: per_abs_shd.g_old_rec.abs_information19;
1015: End If;
1016: If (p_rec.abs_information20 = hr_api.g_varchar2) then
1017: p_rec.abs_information20 :=
1018: per_abs_shd.g_old_rec.abs_information20;
1014: per_abs_shd.g_old_rec.abs_information19;
1015: End If;
1016: If (p_rec.abs_information20 = hr_api.g_varchar2) then
1017: p_rec.abs_information20 :=
1018: per_abs_shd.g_old_rec.abs_information20;
1019: End If;
1020: If (p_rec.abs_information21 = hr_api.g_varchar2) then
1021: p_rec.abs_information21 :=
1022: per_abs_shd.g_old_rec.abs_information21;
1018: per_abs_shd.g_old_rec.abs_information20;
1019: End If;
1020: If (p_rec.abs_information21 = hr_api.g_varchar2) then
1021: p_rec.abs_information21 :=
1022: per_abs_shd.g_old_rec.abs_information21;
1023: End If;
1024: If (p_rec.abs_information22 = hr_api.g_varchar2) then
1025: p_rec.abs_information22 :=
1026: per_abs_shd.g_old_rec.abs_information22;
1022: per_abs_shd.g_old_rec.abs_information21;
1023: End If;
1024: If (p_rec.abs_information22 = hr_api.g_varchar2) then
1025: p_rec.abs_information22 :=
1026: per_abs_shd.g_old_rec.abs_information22;
1027: End If;
1028: If (p_rec.abs_information23 = hr_api.g_varchar2) then
1029: p_rec.abs_information23 :=
1030: per_abs_shd.g_old_rec.abs_information23;
1026: per_abs_shd.g_old_rec.abs_information22;
1027: End If;
1028: If (p_rec.abs_information23 = hr_api.g_varchar2) then
1029: p_rec.abs_information23 :=
1030: per_abs_shd.g_old_rec.abs_information23;
1031: End If;
1032: If (p_rec.abs_information24 = hr_api.g_varchar2) then
1033: p_rec.abs_information24 :=
1034: per_abs_shd.g_old_rec.abs_information24;
1030: per_abs_shd.g_old_rec.abs_information23;
1031: End If;
1032: If (p_rec.abs_information24 = hr_api.g_varchar2) then
1033: p_rec.abs_information24 :=
1034: per_abs_shd.g_old_rec.abs_information24;
1035: End If;
1036: If (p_rec.abs_information25 = hr_api.g_varchar2) then
1037: p_rec.abs_information25 :=
1038: per_abs_shd.g_old_rec.abs_information25;
1034: per_abs_shd.g_old_rec.abs_information24;
1035: End If;
1036: If (p_rec.abs_information25 = hr_api.g_varchar2) then
1037: p_rec.abs_information25 :=
1038: per_abs_shd.g_old_rec.abs_information25;
1039: End If;
1040: If (p_rec.abs_information26 = hr_api.g_varchar2) then
1041: p_rec.abs_information26 :=
1042: per_abs_shd.g_old_rec.abs_information26;
1038: per_abs_shd.g_old_rec.abs_information25;
1039: End If;
1040: If (p_rec.abs_information26 = hr_api.g_varchar2) then
1041: p_rec.abs_information26 :=
1042: per_abs_shd.g_old_rec.abs_information26;
1043: End If;
1044: If (p_rec.abs_information27 = hr_api.g_varchar2) then
1045: p_rec.abs_information27 :=
1046: per_abs_shd.g_old_rec.abs_information27;
1042: per_abs_shd.g_old_rec.abs_information26;
1043: End If;
1044: If (p_rec.abs_information27 = hr_api.g_varchar2) then
1045: p_rec.abs_information27 :=
1046: per_abs_shd.g_old_rec.abs_information27;
1047: End If;
1048: If (p_rec.abs_information28 = hr_api.g_varchar2) then
1049: p_rec.abs_information28 :=
1050: per_abs_shd.g_old_rec.abs_information28;
1046: per_abs_shd.g_old_rec.abs_information27;
1047: End If;
1048: If (p_rec.abs_information28 = hr_api.g_varchar2) then
1049: p_rec.abs_information28 :=
1050: per_abs_shd.g_old_rec.abs_information28;
1051: End If;
1052: If (p_rec.abs_information29 = hr_api.g_varchar2) then
1053: p_rec.abs_information29 :=
1054: per_abs_shd.g_old_rec.abs_information29;
1050: per_abs_shd.g_old_rec.abs_information28;
1051: End If;
1052: If (p_rec.abs_information29 = hr_api.g_varchar2) then
1053: p_rec.abs_information29 :=
1054: per_abs_shd.g_old_rec.abs_information29;
1055: End If;
1056: If (p_rec.abs_information30 = hr_api.g_varchar2) then
1057: p_rec.abs_information30 :=
1058: per_abs_shd.g_old_rec.abs_information30;
1054: per_abs_shd.g_old_rec.abs_information29;
1055: End If;
1056: If (p_rec.abs_information30 = hr_api.g_varchar2) then
1057: p_rec.abs_information30 :=
1058: per_abs_shd.g_old_rec.abs_information30;
1059: End If;
1060: If (p_rec.absence_case_id = hr_api.g_number) then
1061: p_rec.absence_case_id :=
1062: per_abs_shd.g_old_rec.absence_case_id;
1058: per_abs_shd.g_old_rec.abs_information30;
1059: End If;
1060: If (p_rec.absence_case_id = hr_api.g_number) then
1061: p_rec.absence_case_id :=
1062: per_abs_shd.g_old_rec.absence_case_id;
1063: End If;
1064: If (p_rec.batch_id = hr_api.g_number) then
1065: p_rec.batch_id :=
1066: per_abs_shd.g_old_rec.batch_id;
1062: per_abs_shd.g_old_rec.absence_case_id;
1063: End If;
1064: If (p_rec.batch_id = hr_api.g_number) then
1065: p_rec.batch_id :=
1066: per_abs_shd.g_old_rec.batch_id;
1067: End If;
1068: --
1069: End convert_defs;
1070: --
1072: -- |---------------------------------< upd >----------------------------------|
1073: -- ----------------------------------------------------------------------------
1074: Procedure upd
1075: (p_effective_date in date
1076: ,p_rec in out nocopy per_abs_shd.g_rec_type
1077: ,p_dur_dys_less_warning out nocopy boolean
1078: ,p_dur_hrs_less_warning out nocopy boolean
1079: ,p_exceeds_pto_entit_warning out nocopy boolean
1080: ,p_exceeds_run_total_warning out nocopy boolean
1089: hr_utility.set_location('Entering:'||l_proc, 5);
1090: --
1091: -- We must lock the row which we need to update.
1092: --
1093: per_abs_shd.lck
1094: (p_rec.absence_attendance_id
1095: ,p_rec.object_version_number
1096: );
1097: --
1236: --
1237: l_person_id number := hr_api.g_number;
1238: l_absence_attendance_type_id number := hr_api.g_number;
1239: l_business_group_id number := hr_api.g_number;
1240: l_rec per_abs_shd.g_rec_type;
1241: l_proc varchar2(72) := g_package||'upd';
1242: --
1243: --
1244: Begin
1247: -- Call conversion function to turn arguments into the
1248: -- l_rec structure.
1249: --
1250: l_rec :=
1251: per_abs_shd.convert_args
1252: (p_absence_attendance_id
1253: ,l_business_group_id
1254: ,l_absence_attendance_type_id
1255: ,p_abs_attendance_reason_id