66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.
114: End If;
115: --
116: hr_utility.set_location(' Leaving:'||l_proc, 15);
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: --
121: pay_isb_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: --
121: pay_isb_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: pay_isb_shd.constraint_error
119: -- A check constraint has been violated
120: --
121: pay_isb_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: pay_isb_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: pay_isb_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: --
130: Raise;
131: End dt_update_dml;
240: l_dummy_version_number number;
241: --
242: Begin
243: hr_utility.set_location('Entering:'||l_proc, 5);
244: If (p_datetrack_mode <> hr_api.g_correction) then
245: --
246: -- Update the current effective end date
247: --
248: pay_isb_shd.upd_effective_end_date
253: ,p_validation_end_date => p_validation_end_date
254: ,p_object_version_number => l_dummy_version_number
255: );
256: --
257: If (p_datetrack_mode = hr_api.g_update_override) then
258: --
259: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
260: -- delete any future rows
261: --
463: );
464: --
465: exception
466: --
467: when hr_api.cannot_find_prog_unit then
468: --
469: hr_api.cannot_find_prog_unit_error
470: (p_module_name => 'PAY_IE_SOCIAL_BENEFITS_F'
471: ,p_hook_type => 'AU');
465: exception
466: --
467: when hr_api.cannot_find_prog_unit then
468: --
469: hr_api.cannot_find_prog_unit_error
470: (p_module_name => 'PAY_IE_SOCIAL_BENEFITS_F'
471: ,p_hook_type => 'AU');
472: --
473: end;
528: -- p_rec plsql record structure
529: -- to see if a system default is being used. If a system default
530: -- is being used then we must set to the 'current' argument value.
531: --
532: If (p_rec.assignment_id = hr_api.g_number) then
533: p_rec.assignment_id :=
534: pay_isb_shd.g_old_rec.assignment_id;
535: End If;
536: If (p_rec.absence_start_date = hr_api.g_date) then
532: If (p_rec.assignment_id = hr_api.g_number) then
533: p_rec.assignment_id :=
534: pay_isb_shd.g_old_rec.assignment_id;
535: End If;
536: If (p_rec.absence_start_date = hr_api.g_date) then
537: p_rec.absence_start_date :=
538: pay_isb_shd.g_old_rec.absence_start_date;
539: End If;
540: If (p_rec.absence_end_date = hr_api.g_date) then
536: If (p_rec.absence_start_date = hr_api.g_date) then
537: p_rec.absence_start_date :=
538: pay_isb_shd.g_old_rec.absence_start_date;
539: End If;
540: If (p_rec.absence_end_date = hr_api.g_date) then
541: p_rec.absence_end_date :=
542: pay_isb_shd.g_old_rec.absence_end_date;
543: End If;
544: If (p_rec.benefit_amount = hr_api.g_number) then
540: If (p_rec.absence_end_date = hr_api.g_date) then
541: p_rec.absence_end_date :=
542: pay_isb_shd.g_old_rec.absence_end_date;
543: End If;
544: If (p_rec.benefit_amount = hr_api.g_number) then
545: p_rec.benefit_amount :=
546: pay_isb_shd.g_old_rec.benefit_amount;
547: End If;
548: If (p_rec.benefit_type = hr_api.g_varchar2) then
544: If (p_rec.benefit_amount = hr_api.g_number) then
545: p_rec.benefit_amount :=
546: pay_isb_shd.g_old_rec.benefit_amount;
547: End If;
548: If (p_rec.benefit_type = hr_api.g_varchar2) then
549: p_rec.benefit_type :=
550: pay_isb_shd.g_old_rec.benefit_type;
551: End If;
552: If (p_rec.calculation_option = hr_api.g_varchar2) then
548: If (p_rec.benefit_type = hr_api.g_varchar2) then
549: p_rec.benefit_type :=
550: pay_isb_shd.g_old_rec.benefit_type;
551: End If;
552: If (p_rec.calculation_option = hr_api.g_varchar2) then
553: p_rec.calculation_option :=
554: pay_isb_shd.g_old_rec.calculation_option;
555: End If;
556: If (p_rec.reduced_tax_credit = hr_api.g_number) then
552: If (p_rec.calculation_option = hr_api.g_varchar2) then
553: p_rec.calculation_option :=
554: pay_isb_shd.g_old_rec.calculation_option;
555: End If;
556: If (p_rec.reduced_tax_credit = hr_api.g_number) then
557: p_rec.reduced_tax_credit :=
558: pay_isb_shd.g_old_rec.reduced_tax_credit;
559: End If;
560: If (p_rec.reduced_standard_cutoff = hr_api.g_number) then
556: If (p_rec.reduced_tax_credit = hr_api.g_number) then
557: p_rec.reduced_tax_credit :=
558: pay_isb_shd.g_old_rec.reduced_tax_credit;
559: End If;
560: If (p_rec.reduced_standard_cutoff = hr_api.g_number) then
561: p_rec.reduced_standard_cutoff :=
562: pay_isb_shd.g_old_rec.reduced_standard_cutoff;
563: End If;
564: If (p_rec.incident_id = hr_api.g_number) then
560: If (p_rec.reduced_standard_cutoff = hr_api.g_number) then
561: p_rec.reduced_standard_cutoff :=
562: pay_isb_shd.g_old_rec.reduced_standard_cutoff;
563: End If;
564: If (p_rec.incident_id = hr_api.g_number) then
565: p_rec.incident_id :=
566: pay_isb_shd.g_old_rec.incident_id;
567: End If;
568: If (p_rec.request_id = hr_api.g_number) then
564: If (p_rec.incident_id = hr_api.g_number) then
565: p_rec.incident_id :=
566: pay_isb_shd.g_old_rec.incident_id;
567: End If;
568: If (p_rec.request_id = hr_api.g_number) then
569: p_rec.request_id :=
570: pay_isb_shd.g_old_rec.request_id;
571: End If;
572: If (p_rec.program_application_id = hr_api.g_number) then
568: If (p_rec.request_id = hr_api.g_number) then
569: p_rec.request_id :=
570: pay_isb_shd.g_old_rec.request_id;
571: End If;
572: If (p_rec.program_application_id = hr_api.g_number) then
573: p_rec.program_application_id :=
574: pay_isb_shd.g_old_rec.program_application_id;
575: End If;
576: If (p_rec.program_id = hr_api.g_varchar2) then
572: If (p_rec.program_application_id = hr_api.g_number) then
573: p_rec.program_application_id :=
574: pay_isb_shd.g_old_rec.program_application_id;
575: End If;
576: If (p_rec.program_id = hr_api.g_varchar2) then
577: p_rec.program_id :=
578: pay_isb_shd.g_old_rec.program_id;
579: End If;
580: If (p_rec.program_update_date = hr_api.g_date) then
576: If (p_rec.program_id = hr_api.g_varchar2) then
577: p_rec.program_id :=
578: pay_isb_shd.g_old_rec.program_id;
579: End If;
580: If (p_rec.program_update_date = hr_api.g_date) then
581: p_rec.program_update_date :=
582: pay_isb_shd.g_old_rec.program_update_date;
583: End If;
584: --
669: (p_effective_date in date
670: ,p_datetrack_mode in varchar2
671: ,p_social_benefit_id in number
672: ,p_object_version_number in out nocopy number
673: ,p_assignment_id in number default hr_api.g_number
674: ,p_benefit_amount in number default hr_api.g_number
675: ,p_calculation_option in varchar2 default hr_api.g_varchar2
676: ,p_absence_start_date in date default hr_api.g_date
677: ,p_absence_end_date in date default hr_api.g_date
670: ,p_datetrack_mode in varchar2
671: ,p_social_benefit_id in number
672: ,p_object_version_number in out nocopy number
673: ,p_assignment_id in number default hr_api.g_number
674: ,p_benefit_amount in number default hr_api.g_number
675: ,p_calculation_option in varchar2 default hr_api.g_varchar2
676: ,p_absence_start_date in date default hr_api.g_date
677: ,p_absence_end_date in date default hr_api.g_date
678: ,p_benefit_type in varchar2 default hr_api.g_varchar2
671: ,p_social_benefit_id in number
672: ,p_object_version_number in out nocopy number
673: ,p_assignment_id in number default hr_api.g_number
674: ,p_benefit_amount in number default hr_api.g_number
675: ,p_calculation_option in varchar2 default hr_api.g_varchar2
676: ,p_absence_start_date in date default hr_api.g_date
677: ,p_absence_end_date in date default hr_api.g_date
678: ,p_benefit_type in varchar2 default hr_api.g_varchar2
679: ,p_reduced_tax_credit in number default hr_api.g_number
672: ,p_object_version_number in out nocopy number
673: ,p_assignment_id in number default hr_api.g_number
674: ,p_benefit_amount in number default hr_api.g_number
675: ,p_calculation_option in varchar2 default hr_api.g_varchar2
676: ,p_absence_start_date in date default hr_api.g_date
677: ,p_absence_end_date in date default hr_api.g_date
678: ,p_benefit_type in varchar2 default hr_api.g_varchar2
679: ,p_reduced_tax_credit in number default hr_api.g_number
680: ,p_reduced_standard_cutoff in number default hr_api.g_number
673: ,p_assignment_id in number default hr_api.g_number
674: ,p_benefit_amount in number default hr_api.g_number
675: ,p_calculation_option in varchar2 default hr_api.g_varchar2
676: ,p_absence_start_date in date default hr_api.g_date
677: ,p_absence_end_date in date default hr_api.g_date
678: ,p_benefit_type in varchar2 default hr_api.g_varchar2
679: ,p_reduced_tax_credit in number default hr_api.g_number
680: ,p_reduced_standard_cutoff in number default hr_api.g_number
681: ,p_incident_id in number default hr_api.g_number
674: ,p_benefit_amount in number default hr_api.g_number
675: ,p_calculation_option in varchar2 default hr_api.g_varchar2
676: ,p_absence_start_date in date default hr_api.g_date
677: ,p_absence_end_date in date default hr_api.g_date
678: ,p_benefit_type in varchar2 default hr_api.g_varchar2
679: ,p_reduced_tax_credit in number default hr_api.g_number
680: ,p_reduced_standard_cutoff in number default hr_api.g_number
681: ,p_incident_id in number default hr_api.g_number
682: ,p_request_id in number default hr_api.g_number
675: ,p_calculation_option in varchar2 default hr_api.g_varchar2
676: ,p_absence_start_date in date default hr_api.g_date
677: ,p_absence_end_date in date default hr_api.g_date
678: ,p_benefit_type in varchar2 default hr_api.g_varchar2
679: ,p_reduced_tax_credit in number default hr_api.g_number
680: ,p_reduced_standard_cutoff in number default hr_api.g_number
681: ,p_incident_id in number default hr_api.g_number
682: ,p_request_id in number default hr_api.g_number
683: ,p_program_application_id in number default hr_api.g_number
676: ,p_absence_start_date in date default hr_api.g_date
677: ,p_absence_end_date in date default hr_api.g_date
678: ,p_benefit_type in varchar2 default hr_api.g_varchar2
679: ,p_reduced_tax_credit in number default hr_api.g_number
680: ,p_reduced_standard_cutoff in number default hr_api.g_number
681: ,p_incident_id in number default hr_api.g_number
682: ,p_request_id in number default hr_api.g_number
683: ,p_program_application_id in number default hr_api.g_number
684: ,p_program_id in varchar2 default hr_api.g_varchar2
677: ,p_absence_end_date in date default hr_api.g_date
678: ,p_benefit_type in varchar2 default hr_api.g_varchar2
679: ,p_reduced_tax_credit in number default hr_api.g_number
680: ,p_reduced_standard_cutoff in number default hr_api.g_number
681: ,p_incident_id in number default hr_api.g_number
682: ,p_request_id in number default hr_api.g_number
683: ,p_program_application_id in number default hr_api.g_number
684: ,p_program_id in varchar2 default hr_api.g_varchar2
685: ,p_program_update_date in date default hr_api.g_date
678: ,p_benefit_type in varchar2 default hr_api.g_varchar2
679: ,p_reduced_tax_credit in number default hr_api.g_number
680: ,p_reduced_standard_cutoff in number default hr_api.g_number
681: ,p_incident_id in number default hr_api.g_number
682: ,p_request_id in number default hr_api.g_number
683: ,p_program_application_id in number default hr_api.g_number
684: ,p_program_id in varchar2 default hr_api.g_varchar2
685: ,p_program_update_date in date default hr_api.g_date
686: ,p_effective_start_date out nocopy date
679: ,p_reduced_tax_credit in number default hr_api.g_number
680: ,p_reduced_standard_cutoff in number default hr_api.g_number
681: ,p_incident_id in number default hr_api.g_number
682: ,p_request_id in number default hr_api.g_number
683: ,p_program_application_id in number default hr_api.g_number
684: ,p_program_id in varchar2 default hr_api.g_varchar2
685: ,p_program_update_date in date default hr_api.g_date
686: ,p_effective_start_date out nocopy date
687: ,p_effective_end_date out nocopy date
680: ,p_reduced_standard_cutoff in number default hr_api.g_number
681: ,p_incident_id in number default hr_api.g_number
682: ,p_request_id in number default hr_api.g_number
683: ,p_program_application_id in number default hr_api.g_number
684: ,p_program_id in varchar2 default hr_api.g_varchar2
685: ,p_program_update_date in date default hr_api.g_date
686: ,p_effective_start_date out nocopy date
687: ,p_effective_end_date out nocopy date
688: ) is
681: ,p_incident_id in number default hr_api.g_number
682: ,p_request_id in number default hr_api.g_number
683: ,p_program_application_id in number default hr_api.g_number
684: ,p_program_id in varchar2 default hr_api.g_varchar2
685: ,p_program_update_date in date default hr_api.g_date
686: ,p_effective_start_date out nocopy date
687: ,p_effective_end_date out nocopy date
688: ) is
689: --