[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy hr_cle_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date
154: Exception
155: When hr_api.check_integrity_violated Then
156: -- A check constraint has been violated
157: --
158: hr_cle_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When hr_api.unique_integrity_violated Then
161: -- Unique integrity has been violated
162: --
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When hr_api.unique_integrity_violated Then
161: -- Unique integrity has been violated
162: --
163: hr_cle_shd.constraint_error
164: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165: When Others Then
166: --
167: Raise;
198: --
199: -- {End Of Comments}
200: -- ----------------------------------------------------------------------------
201: Procedure update_dml
202: (p_rec in out nocopy hr_cle_shd.g_rec_type
203: ,p_effective_date in date
204: ,p_datetrack_mode in varchar2
205: ,p_validation_start_date in date
206: ,p_validation_end_date in date
265: --
266: -- {End Of Comments}
267: -- ----------------------------------------------------------------------------
268: Procedure dt_pre_update
269: (p_rec in out nocopy hr_cle_shd.g_rec_type
270: ,p_effective_date in date
271: ,p_datetrack_mode in varchar2
272: ,p_validation_start_date in date
273: ,p_validation_end_date in date
281: If (p_datetrack_mode <> hr_api.g_correction) then
282: --
283: -- Update the current effective end date
284: --
285: hr_cle_shd.upd_effective_end_date
286: (p_effective_date => p_effective_date
287: ,p_base_key_value => p_rec.soc_ins_contr_lvls_id
288: ,p_new_effective_end_date => (p_validation_start_date - 1)
289: ,p_validation_start_date => p_validation_start_date
350: --
351: -- {End Of Comments}
352: -- ----------------------------------------------------------------------------
353: Procedure pre_update
354: (p_rec in out nocopy hr_cle_shd.g_rec_type
355: ,p_effective_date in date
356: ,p_datetrack_mode in varchar2
357: ,p_validation_start_date in date
358: ,p_validation_end_date in date
408: --
409: -- {End Of Comments}
410: -- ----------------------------------------------------------------------------
411: Procedure post_update
412: (p_rec in hr_cle_shd.g_rec_type
413: ,p_effective_date in date
414: ,p_datetrack_mode in varchar2
415: ,p_validation_start_date in date
416: ,p_validation_end_date in date
539: => p_rec.employee_contribution
540: ,p_contribution_level_type
541: => p_rec.contribution_level_type
542: ,p_organization_id_o
543: => hr_cle_shd.g_old_rec.organization_id
544: ,p_normal_percentage_o
545: => hr_cle_shd.g_old_rec.normal_percentage
546: ,p_normal_amount_o
547: => hr_cle_shd.g_old_rec.normal_amount
541: => p_rec.contribution_level_type
542: ,p_organization_id_o
543: => hr_cle_shd.g_old_rec.organization_id
544: ,p_normal_percentage_o
545: => hr_cle_shd.g_old_rec.normal_percentage
546: ,p_normal_amount_o
547: => hr_cle_shd.g_old_rec.normal_amount
548: ,p_increased_percentage_o
549: => hr_cle_shd.g_old_rec.increased_percentage
543: => hr_cle_shd.g_old_rec.organization_id
544: ,p_normal_percentage_o
545: => hr_cle_shd.g_old_rec.normal_percentage
546: ,p_normal_amount_o
547: => hr_cle_shd.g_old_rec.normal_amount
548: ,p_increased_percentage_o
549: => hr_cle_shd.g_old_rec.increased_percentage
550: ,p_increased_amount_o
551: => hr_cle_shd.g_old_rec.increased_amount
545: => hr_cle_shd.g_old_rec.normal_percentage
546: ,p_normal_amount_o
547: => hr_cle_shd.g_old_rec.normal_amount
548: ,p_increased_percentage_o
549: => hr_cle_shd.g_old_rec.increased_percentage
550: ,p_increased_amount_o
551: => hr_cle_shd.g_old_rec.increased_amount
552: ,p_reduced_percentage_o
553: => hr_cle_shd.g_old_rec.reduced_percentage
547: => hr_cle_shd.g_old_rec.normal_amount
548: ,p_increased_percentage_o
549: => hr_cle_shd.g_old_rec.increased_percentage
550: ,p_increased_amount_o
551: => hr_cle_shd.g_old_rec.increased_amount
552: ,p_reduced_percentage_o
553: => hr_cle_shd.g_old_rec.reduced_percentage
554: ,p_reduced_amount_o
555: => hr_cle_shd.g_old_rec.reduced_amount
549: => hr_cle_shd.g_old_rec.increased_percentage
550: ,p_increased_amount_o
551: => hr_cle_shd.g_old_rec.increased_amount
552: ,p_reduced_percentage_o
553: => hr_cle_shd.g_old_rec.reduced_percentage
554: ,p_reduced_amount_o
555: => hr_cle_shd.g_old_rec.reduced_amount
556: ,p_effective_start_date_o
557: => hr_cle_shd.g_old_rec.effective_start_date
551: => hr_cle_shd.g_old_rec.increased_amount
552: ,p_reduced_percentage_o
553: => hr_cle_shd.g_old_rec.reduced_percentage
554: ,p_reduced_amount_o
555: => hr_cle_shd.g_old_rec.reduced_amount
556: ,p_effective_start_date_o
557: => hr_cle_shd.g_old_rec.effective_start_date
558: ,p_effective_end_date_o
559: => hr_cle_shd.g_old_rec.effective_end_date
553: => hr_cle_shd.g_old_rec.reduced_percentage
554: ,p_reduced_amount_o
555: => hr_cle_shd.g_old_rec.reduced_amount
556: ,p_effective_start_date_o
557: => hr_cle_shd.g_old_rec.effective_start_date
558: ,p_effective_end_date_o
559: => hr_cle_shd.g_old_rec.effective_end_date
560: ,p_attribute_category_o
561: => hr_cle_shd.g_old_rec.attribute_category
555: => hr_cle_shd.g_old_rec.reduced_amount
556: ,p_effective_start_date_o
557: => hr_cle_shd.g_old_rec.effective_start_date
558: ,p_effective_end_date_o
559: => hr_cle_shd.g_old_rec.effective_end_date
560: ,p_attribute_category_o
561: => hr_cle_shd.g_old_rec.attribute_category
562: ,p_attribute1_o
563: => hr_cle_shd.g_old_rec.attribute1
557: => hr_cle_shd.g_old_rec.effective_start_date
558: ,p_effective_end_date_o
559: => hr_cle_shd.g_old_rec.effective_end_date
560: ,p_attribute_category_o
561: => hr_cle_shd.g_old_rec.attribute_category
562: ,p_attribute1_o
563: => hr_cle_shd.g_old_rec.attribute1
564: ,p_attribute2_o
565: => hr_cle_shd.g_old_rec.attribute2
559: => hr_cle_shd.g_old_rec.effective_end_date
560: ,p_attribute_category_o
561: => hr_cle_shd.g_old_rec.attribute_category
562: ,p_attribute1_o
563: => hr_cle_shd.g_old_rec.attribute1
564: ,p_attribute2_o
565: => hr_cle_shd.g_old_rec.attribute2
566: ,p_attribute3_o
567: => hr_cle_shd.g_old_rec.attribute3
561: => hr_cle_shd.g_old_rec.attribute_category
562: ,p_attribute1_o
563: => hr_cle_shd.g_old_rec.attribute1
564: ,p_attribute2_o
565: => hr_cle_shd.g_old_rec.attribute2
566: ,p_attribute3_o
567: => hr_cle_shd.g_old_rec.attribute3
568: ,p_attribute4_o
569: => hr_cle_shd.g_old_rec.attribute4
563: => hr_cle_shd.g_old_rec.attribute1
564: ,p_attribute2_o
565: => hr_cle_shd.g_old_rec.attribute2
566: ,p_attribute3_o
567: => hr_cle_shd.g_old_rec.attribute3
568: ,p_attribute4_o
569: => hr_cle_shd.g_old_rec.attribute4
570: ,p_attribute5_o
571: => hr_cle_shd.g_old_rec.attribute5
565: => hr_cle_shd.g_old_rec.attribute2
566: ,p_attribute3_o
567: => hr_cle_shd.g_old_rec.attribute3
568: ,p_attribute4_o
569: => hr_cle_shd.g_old_rec.attribute4
570: ,p_attribute5_o
571: => hr_cle_shd.g_old_rec.attribute5
572: ,p_attribute6_o
573: => hr_cle_shd.g_old_rec.attribute6
567: => hr_cle_shd.g_old_rec.attribute3
568: ,p_attribute4_o
569: => hr_cle_shd.g_old_rec.attribute4
570: ,p_attribute5_o
571: => hr_cle_shd.g_old_rec.attribute5
572: ,p_attribute6_o
573: => hr_cle_shd.g_old_rec.attribute6
574: ,p_attribute7_o
575: => hr_cle_shd.g_old_rec.attribute7
569: => hr_cle_shd.g_old_rec.attribute4
570: ,p_attribute5_o
571: => hr_cle_shd.g_old_rec.attribute5
572: ,p_attribute6_o
573: => hr_cle_shd.g_old_rec.attribute6
574: ,p_attribute7_o
575: => hr_cle_shd.g_old_rec.attribute7
576: ,p_attribute8_o
577: => hr_cle_shd.g_old_rec.attribute8
571: => hr_cle_shd.g_old_rec.attribute5
572: ,p_attribute6_o
573: => hr_cle_shd.g_old_rec.attribute6
574: ,p_attribute7_o
575: => hr_cle_shd.g_old_rec.attribute7
576: ,p_attribute8_o
577: => hr_cle_shd.g_old_rec.attribute8
578: ,p_attribute9_o
579: => hr_cle_shd.g_old_rec.attribute9
573: => hr_cle_shd.g_old_rec.attribute6
574: ,p_attribute7_o
575: => hr_cle_shd.g_old_rec.attribute7
576: ,p_attribute8_o
577: => hr_cle_shd.g_old_rec.attribute8
578: ,p_attribute9_o
579: => hr_cle_shd.g_old_rec.attribute9
580: ,p_attribute10_o
581: => hr_cle_shd.g_old_rec.attribute10
575: => hr_cle_shd.g_old_rec.attribute7
576: ,p_attribute8_o
577: => hr_cle_shd.g_old_rec.attribute8
578: ,p_attribute9_o
579: => hr_cle_shd.g_old_rec.attribute9
580: ,p_attribute10_o
581: => hr_cle_shd.g_old_rec.attribute10
582: ,p_attribute11_o
583: => hr_cle_shd.g_old_rec.attribute11
577: => hr_cle_shd.g_old_rec.attribute8
578: ,p_attribute9_o
579: => hr_cle_shd.g_old_rec.attribute9
580: ,p_attribute10_o
581: => hr_cle_shd.g_old_rec.attribute10
582: ,p_attribute11_o
583: => hr_cle_shd.g_old_rec.attribute11
584: ,p_attribute12_o
585: => hr_cle_shd.g_old_rec.attribute12
579: => hr_cle_shd.g_old_rec.attribute9
580: ,p_attribute10_o
581: => hr_cle_shd.g_old_rec.attribute10
582: ,p_attribute11_o
583: => hr_cle_shd.g_old_rec.attribute11
584: ,p_attribute12_o
585: => hr_cle_shd.g_old_rec.attribute12
586: ,p_attribute13_o
587: => hr_cle_shd.g_old_rec.attribute13
581: => hr_cle_shd.g_old_rec.attribute10
582: ,p_attribute11_o
583: => hr_cle_shd.g_old_rec.attribute11
584: ,p_attribute12_o
585: => hr_cle_shd.g_old_rec.attribute12
586: ,p_attribute13_o
587: => hr_cle_shd.g_old_rec.attribute13
588: ,p_attribute14_o
589: => hr_cle_shd.g_old_rec.attribute14
583: => hr_cle_shd.g_old_rec.attribute11
584: ,p_attribute12_o
585: => hr_cle_shd.g_old_rec.attribute12
586: ,p_attribute13_o
587: => hr_cle_shd.g_old_rec.attribute13
588: ,p_attribute14_o
589: => hr_cle_shd.g_old_rec.attribute14
590: ,p_attribute15_o
591: => hr_cle_shd.g_old_rec.attribute15
585: => hr_cle_shd.g_old_rec.attribute12
586: ,p_attribute13_o
587: => hr_cle_shd.g_old_rec.attribute13
588: ,p_attribute14_o
589: => hr_cle_shd.g_old_rec.attribute14
590: ,p_attribute15_o
591: => hr_cle_shd.g_old_rec.attribute15
592: ,p_attribute16_o
593: => hr_cle_shd.g_old_rec.attribute16
587: => hr_cle_shd.g_old_rec.attribute13
588: ,p_attribute14_o
589: => hr_cle_shd.g_old_rec.attribute14
590: ,p_attribute15_o
591: => hr_cle_shd.g_old_rec.attribute15
592: ,p_attribute16_o
593: => hr_cle_shd.g_old_rec.attribute16
594: ,p_attribute17_o
595: => hr_cle_shd.g_old_rec.attribute17
589: => hr_cle_shd.g_old_rec.attribute14
590: ,p_attribute15_o
591: => hr_cle_shd.g_old_rec.attribute15
592: ,p_attribute16_o
593: => hr_cle_shd.g_old_rec.attribute16
594: ,p_attribute17_o
595: => hr_cle_shd.g_old_rec.attribute17
596: ,p_attribute18_o
597: => hr_cle_shd.g_old_rec.attribute18
591: => hr_cle_shd.g_old_rec.attribute15
592: ,p_attribute16_o
593: => hr_cle_shd.g_old_rec.attribute16
594: ,p_attribute17_o
595: => hr_cle_shd.g_old_rec.attribute17
596: ,p_attribute18_o
597: => hr_cle_shd.g_old_rec.attribute18
598: ,p_attribute19_o
599: => hr_cle_shd.g_old_rec.attribute19
593: => hr_cle_shd.g_old_rec.attribute16
594: ,p_attribute17_o
595: => hr_cle_shd.g_old_rec.attribute17
596: ,p_attribute18_o
597: => hr_cle_shd.g_old_rec.attribute18
598: ,p_attribute19_o
599: => hr_cle_shd.g_old_rec.attribute19
600: ,p_attribute20_o
601: => hr_cle_shd.g_old_rec.attribute20
595: => hr_cle_shd.g_old_rec.attribute17
596: ,p_attribute18_o
597: => hr_cle_shd.g_old_rec.attribute18
598: ,p_attribute19_o
599: => hr_cle_shd.g_old_rec.attribute19
600: ,p_attribute20_o
601: => hr_cle_shd.g_old_rec.attribute20
602: ,p_object_version_number_o
603: => hr_cle_shd.g_old_rec.object_version_number
597: => hr_cle_shd.g_old_rec.attribute18
598: ,p_attribute19_o
599: => hr_cle_shd.g_old_rec.attribute19
600: ,p_attribute20_o
601: => hr_cle_shd.g_old_rec.attribute20
602: ,p_object_version_number_o
603: => hr_cle_shd.g_old_rec.object_version_number
604: ,p_attribute21_o
605: => hr_cle_shd.g_old_rec.attribute21
599: => hr_cle_shd.g_old_rec.attribute19
600: ,p_attribute20_o
601: => hr_cle_shd.g_old_rec.attribute20
602: ,p_object_version_number_o
603: => hr_cle_shd.g_old_rec.object_version_number
604: ,p_attribute21_o
605: => hr_cle_shd.g_old_rec.attribute21
606: ,p_attribute22_o
607: => hr_cle_shd.g_old_rec.attribute22
601: => hr_cle_shd.g_old_rec.attribute20
602: ,p_object_version_number_o
603: => hr_cle_shd.g_old_rec.object_version_number
604: ,p_attribute21_o
605: => hr_cle_shd.g_old_rec.attribute21
606: ,p_attribute22_o
607: => hr_cle_shd.g_old_rec.attribute22
608: ,p_attribute23_o
609: => hr_cle_shd.g_old_rec.attribute23
603: => hr_cle_shd.g_old_rec.object_version_number
604: ,p_attribute21_o
605: => hr_cle_shd.g_old_rec.attribute21
606: ,p_attribute22_o
607: => hr_cle_shd.g_old_rec.attribute22
608: ,p_attribute23_o
609: => hr_cle_shd.g_old_rec.attribute23
610: ,p_attribute24_o
611: => hr_cle_shd.g_old_rec.attribute24
605: => hr_cle_shd.g_old_rec.attribute21
606: ,p_attribute22_o
607: => hr_cle_shd.g_old_rec.attribute22
608: ,p_attribute23_o
609: => hr_cle_shd.g_old_rec.attribute23
610: ,p_attribute24_o
611: => hr_cle_shd.g_old_rec.attribute24
612: ,p_attribute25_o
613: => hr_cle_shd.g_old_rec.attribute25
607: => hr_cle_shd.g_old_rec.attribute22
608: ,p_attribute23_o
609: => hr_cle_shd.g_old_rec.attribute23
610: ,p_attribute24_o
611: => hr_cle_shd.g_old_rec.attribute24
612: ,p_attribute25_o
613: => hr_cle_shd.g_old_rec.attribute25
614: ,p_attribute26_o
615: => hr_cle_shd.g_old_rec.attribute26
609: => hr_cle_shd.g_old_rec.attribute23
610: ,p_attribute24_o
611: => hr_cle_shd.g_old_rec.attribute24
612: ,p_attribute25_o
613: => hr_cle_shd.g_old_rec.attribute25
614: ,p_attribute26_o
615: => hr_cle_shd.g_old_rec.attribute26
616: ,p_attribute27_o
617: => hr_cle_shd.g_old_rec.attribute27
611: => hr_cle_shd.g_old_rec.attribute24
612: ,p_attribute25_o
613: => hr_cle_shd.g_old_rec.attribute25
614: ,p_attribute26_o
615: => hr_cle_shd.g_old_rec.attribute26
616: ,p_attribute27_o
617: => hr_cle_shd.g_old_rec.attribute27
618: ,p_attribute28_o
619: => hr_cle_shd.g_old_rec.attribute28
613: => hr_cle_shd.g_old_rec.attribute25
614: ,p_attribute26_o
615: => hr_cle_shd.g_old_rec.attribute26
616: ,p_attribute27_o
617: => hr_cle_shd.g_old_rec.attribute27
618: ,p_attribute28_o
619: => hr_cle_shd.g_old_rec.attribute28
620: ,p_attribute29_o
621: => hr_cle_shd.g_old_rec.attribute29
615: => hr_cle_shd.g_old_rec.attribute26
616: ,p_attribute27_o
617: => hr_cle_shd.g_old_rec.attribute27
618: ,p_attribute28_o
619: => hr_cle_shd.g_old_rec.attribute28
620: ,p_attribute29_o
621: => hr_cle_shd.g_old_rec.attribute29
622: ,p_attribute30_o
623: => hr_cle_shd.g_old_rec.attribute30
617: => hr_cle_shd.g_old_rec.attribute27
618: ,p_attribute28_o
619: => hr_cle_shd.g_old_rec.attribute28
620: ,p_attribute29_o
621: => hr_cle_shd.g_old_rec.attribute29
622: ,p_attribute30_o
623: => hr_cle_shd.g_old_rec.attribute30
624: ,p_flat_tax_limit_per_month_o
625: => hr_cle_shd.g_old_rec.flat_tax_limit_per_month
619: => hr_cle_shd.g_old_rec.attribute28
620: ,p_attribute29_o
621: => hr_cle_shd.g_old_rec.attribute29
622: ,p_attribute30_o
623: => hr_cle_shd.g_old_rec.attribute30
624: ,p_flat_tax_limit_per_month_o
625: => hr_cle_shd.g_old_rec.flat_tax_limit_per_month
626: ,p_flat_tax_limit_per_year_o
627: => hr_cle_shd.g_old_rec.flat_tax_limit_per_year
621: => hr_cle_shd.g_old_rec.attribute29
622: ,p_attribute30_o
623: => hr_cle_shd.g_old_rec.attribute30
624: ,p_flat_tax_limit_per_month_o
625: => hr_cle_shd.g_old_rec.flat_tax_limit_per_month
626: ,p_flat_tax_limit_per_year_o
627: => hr_cle_shd.g_old_rec.flat_tax_limit_per_year
628: ,p_min_increased_contribution_o
629: => hr_cle_shd.g_old_rec.min_increased_contribution
623: => hr_cle_shd.g_old_rec.attribute30
624: ,p_flat_tax_limit_per_month_o
625: => hr_cle_shd.g_old_rec.flat_tax_limit_per_month
626: ,p_flat_tax_limit_per_year_o
627: => hr_cle_shd.g_old_rec.flat_tax_limit_per_year
628: ,p_min_increased_contribution_o
629: => hr_cle_shd.g_old_rec.min_increased_contribution
630: ,p_max_increased_contribution_o
631: => hr_cle_shd.g_old_rec.max_increased_contribution
625: => hr_cle_shd.g_old_rec.flat_tax_limit_per_month
626: ,p_flat_tax_limit_per_year_o
627: => hr_cle_shd.g_old_rec.flat_tax_limit_per_year
628: ,p_min_increased_contribution_o
629: => hr_cle_shd.g_old_rec.min_increased_contribution
630: ,p_max_increased_contribution_o
631: => hr_cle_shd.g_old_rec.max_increased_contribution
632: ,p_month1_o
633: => hr_cle_shd.g_old_rec.month1
627: => hr_cle_shd.g_old_rec.flat_tax_limit_per_year
628: ,p_min_increased_contribution_o
629: => hr_cle_shd.g_old_rec.min_increased_contribution
630: ,p_max_increased_contribution_o
631: => hr_cle_shd.g_old_rec.max_increased_contribution
632: ,p_month1_o
633: => hr_cle_shd.g_old_rec.month1
634: ,p_month1_min_contribution_o
635: => hr_cle_shd.g_old_rec.month1_min_contribution
629: => hr_cle_shd.g_old_rec.min_increased_contribution
630: ,p_max_increased_contribution_o
631: => hr_cle_shd.g_old_rec.max_increased_contribution
632: ,p_month1_o
633: => hr_cle_shd.g_old_rec.month1
634: ,p_month1_min_contribution_o
635: => hr_cle_shd.g_old_rec.month1_min_contribution
636: ,p_month1_max_contribution_o
637: => hr_cle_shd.g_old_rec.month1_max_contribution
631: => hr_cle_shd.g_old_rec.max_increased_contribution
632: ,p_month1_o
633: => hr_cle_shd.g_old_rec.month1
634: ,p_month1_min_contribution_o
635: => hr_cle_shd.g_old_rec.month1_min_contribution
636: ,p_month1_max_contribution_o
637: => hr_cle_shd.g_old_rec.month1_max_contribution
638: ,p_month2_o
639: => hr_cle_shd.g_old_rec.month2
633: => hr_cle_shd.g_old_rec.month1
634: ,p_month1_min_contribution_o
635: => hr_cle_shd.g_old_rec.month1_min_contribution
636: ,p_month1_max_contribution_o
637: => hr_cle_shd.g_old_rec.month1_max_contribution
638: ,p_month2_o
639: => hr_cle_shd.g_old_rec.month2
640: ,p_month2_min_contribution_o
641: => hr_cle_shd.g_old_rec.month2_min_contribution
635: => hr_cle_shd.g_old_rec.month1_min_contribution
636: ,p_month1_max_contribution_o
637: => hr_cle_shd.g_old_rec.month1_max_contribution
638: ,p_month2_o
639: => hr_cle_shd.g_old_rec.month2
640: ,p_month2_min_contribution_o
641: => hr_cle_shd.g_old_rec.month2_min_contribution
642: ,p_month2_max_contribution_o
643: => hr_cle_shd.g_old_rec.month2_max_contribution
637: => hr_cle_shd.g_old_rec.month1_max_contribution
638: ,p_month2_o
639: => hr_cle_shd.g_old_rec.month2
640: ,p_month2_min_contribution_o
641: => hr_cle_shd.g_old_rec.month2_min_contribution
642: ,p_month2_max_contribution_o
643: => hr_cle_shd.g_old_rec.month2_max_contribution
644: ,p_employee_contribution_o
645: => hr_cle_shd.g_old_rec.employee_contribution
639: => hr_cle_shd.g_old_rec.month2
640: ,p_month2_min_contribution_o
641: => hr_cle_shd.g_old_rec.month2_min_contribution
642: ,p_month2_max_contribution_o
643: => hr_cle_shd.g_old_rec.month2_max_contribution
644: ,p_employee_contribution_o
645: => hr_cle_shd.g_old_rec.employee_contribution
646: ,p_contribution_level_type_o
647: => hr_cle_shd.g_old_rec.contribution_level_type
641: => hr_cle_shd.g_old_rec.month2_min_contribution
642: ,p_month2_max_contribution_o
643: => hr_cle_shd.g_old_rec.month2_max_contribution
644: ,p_employee_contribution_o
645: => hr_cle_shd.g_old_rec.employee_contribution
646: ,p_contribution_level_type_o
647: => hr_cle_shd.g_old_rec.contribution_level_type
648: );
649: --
643: => hr_cle_shd.g_old_rec.month2_max_contribution
644: ,p_employee_contribution_o
645: => hr_cle_shd.g_old_rec.employee_contribution
646: ,p_contribution_level_type_o
647: => hr_cle_shd.g_old_rec.contribution_level_type
648: );
649: --
650: exception
651: --
703: --
704: -- {End Of Comments}
705: -- ----------------------------------------------------------------------------
706: Procedure convert_defs
707: (p_rec in out nocopy hr_cle_shd.g_rec_type
708: ) is
709: --
710: Begin
711: --
715: -- is being used then we must set to the 'current' argument value.
716: --
717: If (p_rec.organization_id = hr_api.g_number) then
718: p_rec.organization_id :=
719: hr_cle_shd.g_old_rec.organization_id;
720: End If;
721: If (p_rec.normal_percentage = hr_api.g_number) then
722: p_rec.normal_percentage :=
723: hr_cle_shd.g_old_rec.normal_percentage;
719: hr_cle_shd.g_old_rec.organization_id;
720: End If;
721: If (p_rec.normal_percentage = hr_api.g_number) then
722: p_rec.normal_percentage :=
723: hr_cle_shd.g_old_rec.normal_percentage;
724: End If;
725: If (p_rec.normal_amount = hr_api.g_number) then
726: p_rec.normal_amount :=
727: hr_cle_shd.g_old_rec.normal_amount;
723: hr_cle_shd.g_old_rec.normal_percentage;
724: End If;
725: If (p_rec.normal_amount = hr_api.g_number) then
726: p_rec.normal_amount :=
727: hr_cle_shd.g_old_rec.normal_amount;
728: End If;
729: If (p_rec.increased_percentage = hr_api.g_number) then
730: p_rec.increased_percentage :=
731: hr_cle_shd.g_old_rec.increased_percentage;
727: hr_cle_shd.g_old_rec.normal_amount;
728: End If;
729: If (p_rec.increased_percentage = hr_api.g_number) then
730: p_rec.increased_percentage :=
731: hr_cle_shd.g_old_rec.increased_percentage;
732: End If;
733: If (p_rec.increased_amount = hr_api.g_number) then
734: p_rec.increased_amount :=
735: hr_cle_shd.g_old_rec.increased_amount;
731: hr_cle_shd.g_old_rec.increased_percentage;
732: End If;
733: If (p_rec.increased_amount = hr_api.g_number) then
734: p_rec.increased_amount :=
735: hr_cle_shd.g_old_rec.increased_amount;
736: End If;
737: If (p_rec.reduced_percentage = hr_api.g_number) then
738: p_rec.reduced_percentage :=
739: hr_cle_shd.g_old_rec.reduced_percentage;
735: hr_cle_shd.g_old_rec.increased_amount;
736: End If;
737: If (p_rec.reduced_percentage = hr_api.g_number) then
738: p_rec.reduced_percentage :=
739: hr_cle_shd.g_old_rec.reduced_percentage;
740: End If;
741: If (p_rec.reduced_amount = hr_api.g_number) then
742: p_rec.reduced_amount :=
743: hr_cle_shd.g_old_rec.reduced_amount;
739: hr_cle_shd.g_old_rec.reduced_percentage;
740: End If;
741: If (p_rec.reduced_amount = hr_api.g_number) then
742: p_rec.reduced_amount :=
743: hr_cle_shd.g_old_rec.reduced_amount;
744: End If;
745: If (p_rec.attribute_category = hr_api.g_varchar2) then
746: p_rec.attribute_category :=
747: hr_cle_shd.g_old_rec.attribute_category;
743: hr_cle_shd.g_old_rec.reduced_amount;
744: End If;
745: If (p_rec.attribute_category = hr_api.g_varchar2) then
746: p_rec.attribute_category :=
747: hr_cle_shd.g_old_rec.attribute_category;
748: End If;
749: If (p_rec.attribute1 = hr_api.g_varchar2) then
750: p_rec.attribute1 :=
751: hr_cle_shd.g_old_rec.attribute1;
747: hr_cle_shd.g_old_rec.attribute_category;
748: End If;
749: If (p_rec.attribute1 = hr_api.g_varchar2) then
750: p_rec.attribute1 :=
751: hr_cle_shd.g_old_rec.attribute1;
752: End If;
753: If (p_rec.attribute2 = hr_api.g_varchar2) then
754: p_rec.attribute2 :=
755: hr_cle_shd.g_old_rec.attribute2;
751: hr_cle_shd.g_old_rec.attribute1;
752: End If;
753: If (p_rec.attribute2 = hr_api.g_varchar2) then
754: p_rec.attribute2 :=
755: hr_cle_shd.g_old_rec.attribute2;
756: End If;
757: If (p_rec.attribute3 = hr_api.g_varchar2) then
758: p_rec.attribute3 :=
759: hr_cle_shd.g_old_rec.attribute3;
755: hr_cle_shd.g_old_rec.attribute2;
756: End If;
757: If (p_rec.attribute3 = hr_api.g_varchar2) then
758: p_rec.attribute3 :=
759: hr_cle_shd.g_old_rec.attribute3;
760: End If;
761: If (p_rec.attribute4 = hr_api.g_varchar2) then
762: p_rec.attribute4 :=
763: hr_cle_shd.g_old_rec.attribute4;
759: hr_cle_shd.g_old_rec.attribute3;
760: End If;
761: If (p_rec.attribute4 = hr_api.g_varchar2) then
762: p_rec.attribute4 :=
763: hr_cle_shd.g_old_rec.attribute4;
764: End If;
765: If (p_rec.attribute5 = hr_api.g_varchar2) then
766: p_rec.attribute5 :=
767: hr_cle_shd.g_old_rec.attribute5;
763: hr_cle_shd.g_old_rec.attribute4;
764: End If;
765: If (p_rec.attribute5 = hr_api.g_varchar2) then
766: p_rec.attribute5 :=
767: hr_cle_shd.g_old_rec.attribute5;
768: End If;
769: If (p_rec.attribute6 = hr_api.g_varchar2) then
770: p_rec.attribute6 :=
771: hr_cle_shd.g_old_rec.attribute6;
767: hr_cle_shd.g_old_rec.attribute5;
768: End If;
769: If (p_rec.attribute6 = hr_api.g_varchar2) then
770: p_rec.attribute6 :=
771: hr_cle_shd.g_old_rec.attribute6;
772: End If;
773: If (p_rec.attribute7 = hr_api.g_varchar2) then
774: p_rec.attribute7 :=
775: hr_cle_shd.g_old_rec.attribute7;
771: hr_cle_shd.g_old_rec.attribute6;
772: End If;
773: If (p_rec.attribute7 = hr_api.g_varchar2) then
774: p_rec.attribute7 :=
775: hr_cle_shd.g_old_rec.attribute7;
776: End If;
777: If (p_rec.attribute8 = hr_api.g_varchar2) then
778: p_rec.attribute8 :=
779: hr_cle_shd.g_old_rec.attribute8;
775: hr_cle_shd.g_old_rec.attribute7;
776: End If;
777: If (p_rec.attribute8 = hr_api.g_varchar2) then
778: p_rec.attribute8 :=
779: hr_cle_shd.g_old_rec.attribute8;
780: End If;
781: If (p_rec.attribute9 = hr_api.g_varchar2) then
782: p_rec.attribute9 :=
783: hr_cle_shd.g_old_rec.attribute9;
779: hr_cle_shd.g_old_rec.attribute8;
780: End If;
781: If (p_rec.attribute9 = hr_api.g_varchar2) then
782: p_rec.attribute9 :=
783: hr_cle_shd.g_old_rec.attribute9;
784: End If;
785: If (p_rec.attribute10 = hr_api.g_varchar2) then
786: p_rec.attribute10 :=
787: hr_cle_shd.g_old_rec.attribute10;
783: hr_cle_shd.g_old_rec.attribute9;
784: End If;
785: If (p_rec.attribute10 = hr_api.g_varchar2) then
786: p_rec.attribute10 :=
787: hr_cle_shd.g_old_rec.attribute10;
788: End If;
789: If (p_rec.attribute11 = hr_api.g_varchar2) then
790: p_rec.attribute11 :=
791: hr_cle_shd.g_old_rec.attribute11;
787: hr_cle_shd.g_old_rec.attribute10;
788: End If;
789: If (p_rec.attribute11 = hr_api.g_varchar2) then
790: p_rec.attribute11 :=
791: hr_cle_shd.g_old_rec.attribute11;
792: End If;
793: If (p_rec.attribute12 = hr_api.g_varchar2) then
794: p_rec.attribute12 :=
795: hr_cle_shd.g_old_rec.attribute12;
791: hr_cle_shd.g_old_rec.attribute11;
792: End If;
793: If (p_rec.attribute12 = hr_api.g_varchar2) then
794: p_rec.attribute12 :=
795: hr_cle_shd.g_old_rec.attribute12;
796: End If;
797: If (p_rec.attribute13 = hr_api.g_varchar2) then
798: p_rec.attribute13 :=
799: hr_cle_shd.g_old_rec.attribute13;
795: hr_cle_shd.g_old_rec.attribute12;
796: End If;
797: If (p_rec.attribute13 = hr_api.g_varchar2) then
798: p_rec.attribute13 :=
799: hr_cle_shd.g_old_rec.attribute13;
800: End If;
801: If (p_rec.attribute14 = hr_api.g_varchar2) then
802: p_rec.attribute14 :=
803: hr_cle_shd.g_old_rec.attribute14;
799: hr_cle_shd.g_old_rec.attribute13;
800: End If;
801: If (p_rec.attribute14 = hr_api.g_varchar2) then
802: p_rec.attribute14 :=
803: hr_cle_shd.g_old_rec.attribute14;
804: End If;
805: If (p_rec.attribute15 = hr_api.g_varchar2) then
806: p_rec.attribute15 :=
807: hr_cle_shd.g_old_rec.attribute15;
803: hr_cle_shd.g_old_rec.attribute14;
804: End If;
805: If (p_rec.attribute15 = hr_api.g_varchar2) then
806: p_rec.attribute15 :=
807: hr_cle_shd.g_old_rec.attribute15;
808: End If;
809: If (p_rec.attribute16 = hr_api.g_varchar2) then
810: p_rec.attribute16 :=
811: hr_cle_shd.g_old_rec.attribute16;
807: hr_cle_shd.g_old_rec.attribute15;
808: End If;
809: If (p_rec.attribute16 = hr_api.g_varchar2) then
810: p_rec.attribute16 :=
811: hr_cle_shd.g_old_rec.attribute16;
812: End If;
813: If (p_rec.attribute17 = hr_api.g_varchar2) then
814: p_rec.attribute17 :=
815: hr_cle_shd.g_old_rec.attribute17;
811: hr_cle_shd.g_old_rec.attribute16;
812: End If;
813: If (p_rec.attribute17 = hr_api.g_varchar2) then
814: p_rec.attribute17 :=
815: hr_cle_shd.g_old_rec.attribute17;
816: End If;
817: If (p_rec.attribute18 = hr_api.g_varchar2) then
818: p_rec.attribute18 :=
819: hr_cle_shd.g_old_rec.attribute18;
815: hr_cle_shd.g_old_rec.attribute17;
816: End If;
817: If (p_rec.attribute18 = hr_api.g_varchar2) then
818: p_rec.attribute18 :=
819: hr_cle_shd.g_old_rec.attribute18;
820: End If;
821: If (p_rec.attribute19 = hr_api.g_varchar2) then
822: p_rec.attribute19 :=
823: hr_cle_shd.g_old_rec.attribute19;
819: hr_cle_shd.g_old_rec.attribute18;
820: End If;
821: If (p_rec.attribute19 = hr_api.g_varchar2) then
822: p_rec.attribute19 :=
823: hr_cle_shd.g_old_rec.attribute19;
824: End If;
825: If (p_rec.attribute20 = hr_api.g_varchar2) then
826: p_rec.attribute20 :=
827: hr_cle_shd.g_old_rec.attribute20;
823: hr_cle_shd.g_old_rec.attribute19;
824: End If;
825: If (p_rec.attribute20 = hr_api.g_varchar2) then
826: p_rec.attribute20 :=
827: hr_cle_shd.g_old_rec.attribute20;
828: End If;
829: If (p_rec.attribute21 = hr_api.g_varchar2) then
830: p_rec.attribute21 :=
831: hr_cle_shd.g_old_rec.attribute21;
827: hr_cle_shd.g_old_rec.attribute20;
828: End If;
829: If (p_rec.attribute21 = hr_api.g_varchar2) then
830: p_rec.attribute21 :=
831: hr_cle_shd.g_old_rec.attribute21;
832: End If;
833: If (p_rec.attribute22 = hr_api.g_varchar2) then
834: p_rec.attribute22 :=
835: hr_cle_shd.g_old_rec.attribute22;
831: hr_cle_shd.g_old_rec.attribute21;
832: End If;
833: If (p_rec.attribute22 = hr_api.g_varchar2) then
834: p_rec.attribute22 :=
835: hr_cle_shd.g_old_rec.attribute22;
836: End If;
837: If (p_rec.attribute23 = hr_api.g_varchar2) then
838: p_rec.attribute23 :=
839: hr_cle_shd.g_old_rec.attribute23;
835: hr_cle_shd.g_old_rec.attribute22;
836: End If;
837: If (p_rec.attribute23 = hr_api.g_varchar2) then
838: p_rec.attribute23 :=
839: hr_cle_shd.g_old_rec.attribute23;
840: End If;
841: If (p_rec.attribute24 = hr_api.g_varchar2) then
842: p_rec.attribute24 :=
843: hr_cle_shd.g_old_rec.attribute24;
839: hr_cle_shd.g_old_rec.attribute23;
840: End If;
841: If (p_rec.attribute24 = hr_api.g_varchar2) then
842: p_rec.attribute24 :=
843: hr_cle_shd.g_old_rec.attribute24;
844: End If;
845: If (p_rec.attribute25 = hr_api.g_varchar2) then
846: p_rec.attribute25 :=
847: hr_cle_shd.g_old_rec.attribute25;
843: hr_cle_shd.g_old_rec.attribute24;
844: End If;
845: If (p_rec.attribute25 = hr_api.g_varchar2) then
846: p_rec.attribute25 :=
847: hr_cle_shd.g_old_rec.attribute25;
848: End If;
849: If (p_rec.attribute26 = hr_api.g_varchar2) then
850: p_rec.attribute26 :=
851: hr_cle_shd.g_old_rec.attribute26;
847: hr_cle_shd.g_old_rec.attribute25;
848: End If;
849: If (p_rec.attribute26 = hr_api.g_varchar2) then
850: p_rec.attribute26 :=
851: hr_cle_shd.g_old_rec.attribute26;
852: End If;
853: If (p_rec.attribute27 = hr_api.g_varchar2) then
854: p_rec.attribute27 :=
855: hr_cle_shd.g_old_rec.attribute27;
851: hr_cle_shd.g_old_rec.attribute26;
852: End If;
853: If (p_rec.attribute27 = hr_api.g_varchar2) then
854: p_rec.attribute27 :=
855: hr_cle_shd.g_old_rec.attribute27;
856: End If;
857: If (p_rec.attribute28 = hr_api.g_varchar2) then
858: p_rec.attribute28 :=
859: hr_cle_shd.g_old_rec.attribute28;
855: hr_cle_shd.g_old_rec.attribute27;
856: End If;
857: If (p_rec.attribute28 = hr_api.g_varchar2) then
858: p_rec.attribute28 :=
859: hr_cle_shd.g_old_rec.attribute28;
860: End If;
861: If (p_rec.attribute29 = hr_api.g_varchar2) then
862: p_rec.attribute29 :=
863: hr_cle_shd.g_old_rec.attribute29;
859: hr_cle_shd.g_old_rec.attribute28;
860: End If;
861: If (p_rec.attribute29 = hr_api.g_varchar2) then
862: p_rec.attribute29 :=
863: hr_cle_shd.g_old_rec.attribute29;
864: End If;
865: If (p_rec.attribute30 = hr_api.g_varchar2) then
866: p_rec.attribute30 :=
867: hr_cle_shd.g_old_rec.attribute30;
863: hr_cle_shd.g_old_rec.attribute29;
864: End If;
865: If (p_rec.attribute30 = hr_api.g_varchar2) then
866: p_rec.attribute30 :=
867: hr_cle_shd.g_old_rec.attribute30;
868: End If;
869: If (p_rec.flat_tax_limit_per_month= hr_api.g_number) then
870: p_rec.flat_tax_limit_per_month :=
871: hr_cle_shd.g_old_rec.flat_tax_limit_per_month;
867: hr_cle_shd.g_old_rec.attribute30;
868: End If;
869: If (p_rec.flat_tax_limit_per_month= hr_api.g_number) then
870: p_rec.flat_tax_limit_per_month :=
871: hr_cle_shd.g_old_rec.flat_tax_limit_per_month;
872: End If;
873: If (p_rec.flat_tax_limit_per_year = hr_api.g_number) then
874: p_rec.flat_tax_limit_per_year :=
875: hr_cle_shd.g_old_rec.flat_tax_limit_per_year;
871: hr_cle_shd.g_old_rec.flat_tax_limit_per_month;
872: End If;
873: If (p_rec.flat_tax_limit_per_year = hr_api.g_number) then
874: p_rec.flat_tax_limit_per_year :=
875: hr_cle_shd.g_old_rec.flat_tax_limit_per_year;
876: End If;
877: If (p_rec.min_increased_contribution= hr_api.g_number) then
878: p_rec.min_increased_contribution :=
879: hr_cle_shd.g_old_rec.min_increased_contribution;
875: hr_cle_shd.g_old_rec.flat_tax_limit_per_year;
876: End If;
877: If (p_rec.min_increased_contribution= hr_api.g_number) then
878: p_rec.min_increased_contribution :=
879: hr_cle_shd.g_old_rec.min_increased_contribution;
880: End If;
881: If (p_rec.max_increased_contribution= hr_api.g_number) then
882: p_rec.max_increased_contribution :=
883: hr_cle_shd.g_old_rec.max_increased_contribution;
879: hr_cle_shd.g_old_rec.min_increased_contribution;
880: End If;
881: If (p_rec.max_increased_contribution= hr_api.g_number) then
882: p_rec.max_increased_contribution :=
883: hr_cle_shd.g_old_rec.max_increased_contribution;
884: End If;
885: If (p_rec.month1= hr_api.g_varchar2) then
886: p_rec.month1 :=
887: hr_cle_shd.g_old_rec.month1;
883: hr_cle_shd.g_old_rec.max_increased_contribution;
884: End If;
885: If (p_rec.month1= hr_api.g_varchar2) then
886: p_rec.month1 :=
887: hr_cle_shd.g_old_rec.month1;
888: End If;
889: If (p_rec.month1_min_contribution= hr_api.g_number) then
890: p_rec.month1_min_contribution :=
891: hr_cle_shd.g_old_rec.month1_min_contribution;
887: hr_cle_shd.g_old_rec.month1;
888: End If;
889: If (p_rec.month1_min_contribution= hr_api.g_number) then
890: p_rec.month1_min_contribution :=
891: hr_cle_shd.g_old_rec.month1_min_contribution;
892: End If;
893: If (p_rec.month1_max_contribution= hr_api.g_number) then
894: p_rec.month1_max_contribution :=
895: hr_cle_shd.g_old_rec.month1_max_contribution;
891: hr_cle_shd.g_old_rec.month1_min_contribution;
892: End If;
893: If (p_rec.month1_max_contribution= hr_api.g_number) then
894: p_rec.month1_max_contribution :=
895: hr_cle_shd.g_old_rec.month1_max_contribution;
896: End If;
897: If (p_rec.month2= hr_api.g_varchar2) then
898: p_rec.month2 :=
899: hr_cle_shd.g_old_rec.month2;
895: hr_cle_shd.g_old_rec.month1_max_contribution;
896: End If;
897: If (p_rec.month2= hr_api.g_varchar2) then
898: p_rec.month2 :=
899: hr_cle_shd.g_old_rec.month2;
900: End If;
901: If (p_rec.month2_min_contribution = hr_api.g_number) then
902: p_rec.month2_min_contribution :=
903: hr_cle_shd.g_old_rec.month2_min_contribution;
899: hr_cle_shd.g_old_rec.month2;
900: End If;
901: If (p_rec.month2_min_contribution = hr_api.g_number) then
902: p_rec.month2_min_contribution :=
903: hr_cle_shd.g_old_rec.month2_min_contribution;
904: End If;
905: If (p_rec.month2_max_contribution = hr_api.g_number) then
906: p_rec.month2_max_contribution :=
907: hr_cle_shd.g_old_rec.month2_max_contribution;
903: hr_cle_shd.g_old_rec.month2_min_contribution;
904: End If;
905: If (p_rec.month2_max_contribution = hr_api.g_number) then
906: p_rec.month2_max_contribution :=
907: hr_cle_shd.g_old_rec.month2_max_contribution;
908: End If;
909: If (p_rec.employee_contribution= hr_api.g_number) then
910: p_rec.employee_contribution :=
911: hr_cle_shd.g_old_rec.employee_contribution;
907: hr_cle_shd.g_old_rec.month2_max_contribution;
908: End If;
909: If (p_rec.employee_contribution= hr_api.g_number) then
910: p_rec.employee_contribution :=
911: hr_cle_shd.g_old_rec.employee_contribution;
912: End If;
913: If (p_rec.contribution_level_type = hr_api.g_varchar2) then
914: p_rec.contribution_level_type :=
915: hr_cle_shd.g_old_rec.contribution_level_type;
911: hr_cle_shd.g_old_rec.employee_contribution;
912: End If;
913: If (p_rec.contribution_level_type = hr_api.g_varchar2) then
914: p_rec.contribution_level_type :=
915: hr_cle_shd.g_old_rec.contribution_level_type;
916: End If;
917:
918: --
919: End convert_defs;
923: -- ----------------------------------------------------------------------------
924: Procedure upd
925: (p_effective_date in date
926: ,p_datetrack_mode in varchar2
927: ,p_rec in out nocopy hr_cle_shd.g_rec_type
928: ) is
929: --
930: l_proc varchar2(72) := g_package||'upd';
931: l_validation_start_date date;
939: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
940: --
941: -- We must lock the row which we need to update.
942: --
943: hr_cle_shd.lck
944: (p_effective_date => p_effective_date
945: ,p_datetrack_mode => p_datetrack_mode
946: ,p_soc_ins_contr_lvls_id => p_rec.soc_ins_contr_lvls_id
947: ,p_object_version_number => p_rec.object_version_number
1057: ,p_effective_start_date out nocopy date
1058: ,p_effective_end_date out nocopy date
1059: ) is
1060: --
1061: l_rec hr_cle_shd.g_rec_type;
1062: l_proc varchar2(72) := g_package||'upd';
1063: --
1064: Begin
1065: hr_utility.set_location('Entering:'||l_proc, 5);
1067: -- Call conversion function to turn arguments into the
1068: -- l_rec structure.
1069: --
1070: l_rec :=
1071: hr_cle_shd.convert_args
1072: (p_soc_ins_contr_lvls_id
1073: ,p_organization_id
1074: ,p_normal_percentage
1075: ,p_normal_amount