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.
117: End If;
118: --
119: hr_utility.set_location(' Leaving:'||l_proc, 15);
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: --
124: pay_sid_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: --
124: pay_sid_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: --
129: pay_sid_shd.constraint_error
122: -- A check constraint has been violated
123: --
124: pay_sid_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: --
129: pay_sid_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: --
129: pay_sid_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: --
133: Raise;
134: End dt_update_dml;
243: l_dummy_version_number number;
244: --
245: Begin
246: hr_utility.set_location('Entering:'||l_proc, 5);
247: If (p_datetrack_mode <> hr_api.g_correction) then
248: --
249: -- Update the current effective end date
250: --
251: pay_sid_shd.upd_effective_end_date
256: ,p_validation_end_date => p_validation_end_date
257: ,p_object_version_number => l_dummy_version_number
258: );
259: --
260: If (p_datetrack_mode = hr_api.g_update_override) then
261: --
262: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
263: -- delete any future rows
264: --
478: );
479: --
480: exception
481: --
482: when hr_api.cannot_find_prog_unit then
483: --
484: hr_api.cannot_find_prog_unit_error
485: (p_module_name => 'PAY_IE_PRSI_DETAILS_F'
486: ,p_hook_type => 'AU');
480: exception
481: --
482: when hr_api.cannot_find_prog_unit then
483: --
484: hr_api.cannot_find_prog_unit_error
485: (p_module_name => 'PAY_IE_PRSI_DETAILS_F'
486: ,p_hook_type => 'AU');
487: --
488: end;
543: -- p_rec plsql record structure
544: -- to see if a system default is being used. If a system default
545: -- is being used then we must set to the 'current' argument value.
546: --
547: If (p_rec.assignment_id = hr_api.g_number) then
548: p_rec.assignment_id :=
549: pay_sid_shd.g_old_rec.assignment_id;
550: End If;
551: If (p_rec.contribution_class = hr_api.g_varchar2) then
547: If (p_rec.assignment_id = hr_api.g_number) then
548: p_rec.assignment_id :=
549: pay_sid_shd.g_old_rec.assignment_id;
550: End If;
551: If (p_rec.contribution_class = hr_api.g_varchar2) then
552: p_rec.contribution_class :=
553: pay_sid_shd.g_old_rec.contribution_class;
554: End If;
555: If (p_rec.overridden_subclass = hr_api.g_varchar2) then
551: If (p_rec.contribution_class = hr_api.g_varchar2) then
552: p_rec.contribution_class :=
553: pay_sid_shd.g_old_rec.contribution_class;
554: End If;
555: If (p_rec.overridden_subclass = hr_api.g_varchar2) then
556: p_rec.overridden_subclass :=
557: pay_sid_shd.g_old_rec.overridden_subclass;
558: End If;
559: If (p_rec.soc_ben_flag = hr_api.g_varchar2) then
555: If (p_rec.overridden_subclass = hr_api.g_varchar2) then
556: p_rec.overridden_subclass :=
557: pay_sid_shd.g_old_rec.overridden_subclass;
558: End If;
559: If (p_rec.soc_ben_flag = hr_api.g_varchar2) then
560: p_rec.soc_ben_flag :=
561: pay_sid_shd.g_old_rec.soc_ben_flag;
562: End If;
563: If (p_rec.soc_ben_start_date = hr_api.g_date) then
559: If (p_rec.soc_ben_flag = hr_api.g_varchar2) then
560: p_rec.soc_ben_flag :=
561: pay_sid_shd.g_old_rec.soc_ben_flag;
562: End If;
563: If (p_rec.soc_ben_start_date = hr_api.g_date) then
564: p_rec.soc_ben_start_date :=
565: pay_sid_shd.g_old_rec.soc_ben_start_date;
566: End If;
567: If (p_rec.overridden_ins_weeks = hr_api.g_number) then
563: If (p_rec.soc_ben_start_date = hr_api.g_date) then
564: p_rec.soc_ben_start_date :=
565: pay_sid_shd.g_old_rec.soc_ben_start_date;
566: End If;
567: If (p_rec.overridden_ins_weeks = hr_api.g_number) then
568: p_rec.overridden_ins_weeks :=
569: pay_sid_shd.g_old_rec.overridden_ins_weeks;
570: End If;
571: If (p_rec.non_standard_ins_weeks = hr_api.g_number) then
567: If (p_rec.overridden_ins_weeks = hr_api.g_number) then
568: p_rec.overridden_ins_weeks :=
569: pay_sid_shd.g_old_rec.overridden_ins_weeks;
570: End If;
571: If (p_rec.non_standard_ins_weeks = hr_api.g_number) then
572: p_rec.non_standard_ins_weeks :=
573: pay_sid_shd.g_old_rec.non_standard_ins_weeks;
574: End If;
575: If (p_rec.exemption_start_date = hr_api.g_date) then
571: If (p_rec.non_standard_ins_weeks = hr_api.g_number) then
572: p_rec.non_standard_ins_weeks :=
573: pay_sid_shd.g_old_rec.non_standard_ins_weeks;
574: End If;
575: If (p_rec.exemption_start_date = hr_api.g_date) then
576: p_rec.exemption_start_date :=
577: pay_sid_shd.g_old_rec.exemption_start_date;
578: End If;
579: If (p_rec.exemption_end_date = hr_api.g_date) then
575: If (p_rec.exemption_start_date = hr_api.g_date) then
576: p_rec.exemption_start_date :=
577: pay_sid_shd.g_old_rec.exemption_start_date;
578: End If;
579: If (p_rec.exemption_end_date = hr_api.g_date) then
580: p_rec.exemption_end_date :=
581: pay_sid_shd.g_old_rec.exemption_end_date;
582: End If;
583: If (p_rec.cert_issued_by = hr_api.g_varchar2) then
579: If (p_rec.exemption_end_date = hr_api.g_date) then
580: p_rec.exemption_end_date :=
581: pay_sid_shd.g_old_rec.exemption_end_date;
582: End If;
583: If (p_rec.cert_issued_by = hr_api.g_varchar2) then
584: p_rec.cert_issued_by :=
585: pay_sid_shd.g_old_rec.cert_issued_by;
586: End If;
587: If (p_rec.director_flag = hr_api.g_varchar2) then
583: If (p_rec.cert_issued_by = hr_api.g_varchar2) then
584: p_rec.cert_issued_by :=
585: pay_sid_shd.g_old_rec.cert_issued_by;
586: End If;
587: If (p_rec.director_flag = hr_api.g_varchar2) then
588: p_rec.director_flag :=
589: pay_sid_shd.g_old_rec.director_flag;
590: End If;
591: If (p_rec.request_id = hr_api.g_number) then
587: If (p_rec.director_flag = hr_api.g_varchar2) then
588: p_rec.director_flag :=
589: pay_sid_shd.g_old_rec.director_flag;
590: End If;
591: If (p_rec.request_id = hr_api.g_number) then
592: p_rec.request_id :=
593: pay_sid_shd.g_old_rec.request_id;
594: End If;
595: If (p_rec.program_application_id = hr_api.g_number) then
591: If (p_rec.request_id = hr_api.g_number) then
592: p_rec.request_id :=
593: pay_sid_shd.g_old_rec.request_id;
594: End If;
595: If (p_rec.program_application_id = hr_api.g_number) then
596: p_rec.program_application_id :=
597: pay_sid_shd.g_old_rec.program_application_id;
598: End If;
599: If (p_rec.program_id = hr_api.g_number) then
595: If (p_rec.program_application_id = hr_api.g_number) then
596: p_rec.program_application_id :=
597: pay_sid_shd.g_old_rec.program_application_id;
598: End If;
599: If (p_rec.program_id = hr_api.g_number) then
600: p_rec.program_id :=
601: pay_sid_shd.g_old_rec.program_id;
602: End If;
603: If (p_rec.program_update_date = hr_api.g_date) then
599: If (p_rec.program_id = hr_api.g_number) then
600: p_rec.program_id :=
601: pay_sid_shd.g_old_rec.program_id;
602: End If;
603: If (p_rec.program_update_date = hr_api.g_date) then
604: p_rec.program_update_date :=
605: pay_sid_shd.g_old_rec.program_update_date;
606: End If;
607: If (p_rec.community_flag = hr_api.g_varchar2) then
603: If (p_rec.program_update_date = hr_api.g_date) then
604: p_rec.program_update_date :=
605: pay_sid_shd.g_old_rec.program_update_date;
606: End If;
607: If (p_rec.community_flag = hr_api.g_varchar2) then
608: p_rec.community_flag :=
609: pay_sid_shd.g_old_rec.community_flag;
610: End If;
611: --
696: (p_effective_date in date
697: ,p_datetrack_mode in varchar2
698: ,p_prsi_details_id in number
699: ,p_object_version_number in out nocopy number
700: ,p_assignment_id in number default hr_api.g_number
701: ,p_contribution_class in varchar2 default hr_api.g_varchar2
702: ,p_overridden_subclass in varchar2 default hr_api.g_varchar2
703: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
704: ,p_soc_ben_start_date in date default hr_api.g_date
697: ,p_datetrack_mode in varchar2
698: ,p_prsi_details_id in number
699: ,p_object_version_number in out nocopy number
700: ,p_assignment_id in number default hr_api.g_number
701: ,p_contribution_class in varchar2 default hr_api.g_varchar2
702: ,p_overridden_subclass in varchar2 default hr_api.g_varchar2
703: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
704: ,p_soc_ben_start_date in date default hr_api.g_date
705: ,p_overridden_ins_weeks in number default hr_api.g_number
698: ,p_prsi_details_id in number
699: ,p_object_version_number in out nocopy number
700: ,p_assignment_id in number default hr_api.g_number
701: ,p_contribution_class in varchar2 default hr_api.g_varchar2
702: ,p_overridden_subclass in varchar2 default hr_api.g_varchar2
703: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
704: ,p_soc_ben_start_date in date default hr_api.g_date
705: ,p_overridden_ins_weeks in number default hr_api.g_number
706: ,p_non_standard_ins_weeks in number default hr_api.g_number
699: ,p_object_version_number in out nocopy number
700: ,p_assignment_id in number default hr_api.g_number
701: ,p_contribution_class in varchar2 default hr_api.g_varchar2
702: ,p_overridden_subclass in varchar2 default hr_api.g_varchar2
703: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
704: ,p_soc_ben_start_date in date default hr_api.g_date
705: ,p_overridden_ins_weeks in number default hr_api.g_number
706: ,p_non_standard_ins_weeks in number default hr_api.g_number
707: ,p_exemption_start_date in date default hr_api.g_date
700: ,p_assignment_id in number default hr_api.g_number
701: ,p_contribution_class in varchar2 default hr_api.g_varchar2
702: ,p_overridden_subclass in varchar2 default hr_api.g_varchar2
703: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
704: ,p_soc_ben_start_date in date default hr_api.g_date
705: ,p_overridden_ins_weeks in number default hr_api.g_number
706: ,p_non_standard_ins_weeks in number default hr_api.g_number
707: ,p_exemption_start_date in date default hr_api.g_date
708: ,p_exemption_end_date in date default hr_api.g_date
701: ,p_contribution_class in varchar2 default hr_api.g_varchar2
702: ,p_overridden_subclass in varchar2 default hr_api.g_varchar2
703: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
704: ,p_soc_ben_start_date in date default hr_api.g_date
705: ,p_overridden_ins_weeks in number default hr_api.g_number
706: ,p_non_standard_ins_weeks in number default hr_api.g_number
707: ,p_exemption_start_date in date default hr_api.g_date
708: ,p_exemption_end_date in date default hr_api.g_date
709: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
702: ,p_overridden_subclass in varchar2 default hr_api.g_varchar2
703: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
704: ,p_soc_ben_start_date in date default hr_api.g_date
705: ,p_overridden_ins_weeks in number default hr_api.g_number
706: ,p_non_standard_ins_weeks in number default hr_api.g_number
707: ,p_exemption_start_date in date default hr_api.g_date
708: ,p_exemption_end_date in date default hr_api.g_date
709: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
710: ,p_director_flag in varchar2 default hr_api.g_varchar2
703: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2
704: ,p_soc_ben_start_date in date default hr_api.g_date
705: ,p_overridden_ins_weeks in number default hr_api.g_number
706: ,p_non_standard_ins_weeks in number default hr_api.g_number
707: ,p_exemption_start_date in date default hr_api.g_date
708: ,p_exemption_end_date in date default hr_api.g_date
709: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
710: ,p_director_flag in varchar2 default hr_api.g_varchar2
711: ,p_request_id in number default hr_api.g_number
704: ,p_soc_ben_start_date in date default hr_api.g_date
705: ,p_overridden_ins_weeks in number default hr_api.g_number
706: ,p_non_standard_ins_weeks in number default hr_api.g_number
707: ,p_exemption_start_date in date default hr_api.g_date
708: ,p_exemption_end_date in date default hr_api.g_date
709: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
710: ,p_director_flag in varchar2 default hr_api.g_varchar2
711: ,p_request_id in number default hr_api.g_number
712: ,p_program_application_id in number default hr_api.g_number
705: ,p_overridden_ins_weeks in number default hr_api.g_number
706: ,p_non_standard_ins_weeks in number default hr_api.g_number
707: ,p_exemption_start_date in date default hr_api.g_date
708: ,p_exemption_end_date in date default hr_api.g_date
709: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
710: ,p_director_flag in varchar2 default hr_api.g_varchar2
711: ,p_request_id in number default hr_api.g_number
712: ,p_program_application_id in number default hr_api.g_number
713: ,p_program_id in number default hr_api.g_number
706: ,p_non_standard_ins_weeks in number default hr_api.g_number
707: ,p_exemption_start_date in date default hr_api.g_date
708: ,p_exemption_end_date in date default hr_api.g_date
709: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
710: ,p_director_flag in varchar2 default hr_api.g_varchar2
711: ,p_request_id in number default hr_api.g_number
712: ,p_program_application_id in number default hr_api.g_number
713: ,p_program_id in number default hr_api.g_number
714: ,p_program_update_date in date default hr_api.g_date
707: ,p_exemption_start_date in date default hr_api.g_date
708: ,p_exemption_end_date in date default hr_api.g_date
709: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
710: ,p_director_flag in varchar2 default hr_api.g_varchar2
711: ,p_request_id in number default hr_api.g_number
712: ,p_program_application_id in number default hr_api.g_number
713: ,p_program_id in number default hr_api.g_number
714: ,p_program_update_date in date default hr_api.g_date
715: ,p_community_flag in varchar2 default hr_api.g_varchar2
708: ,p_exemption_end_date in date default hr_api.g_date
709: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
710: ,p_director_flag in varchar2 default hr_api.g_varchar2
711: ,p_request_id in number default hr_api.g_number
712: ,p_program_application_id in number default hr_api.g_number
713: ,p_program_id in number default hr_api.g_number
714: ,p_program_update_date in date default hr_api.g_date
715: ,p_community_flag in varchar2 default hr_api.g_varchar2
716: ,p_effective_start_date out nocopy date
709: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2
710: ,p_director_flag in varchar2 default hr_api.g_varchar2
711: ,p_request_id in number default hr_api.g_number
712: ,p_program_application_id in number default hr_api.g_number
713: ,p_program_id in number default hr_api.g_number
714: ,p_program_update_date in date default hr_api.g_date
715: ,p_community_flag in varchar2 default hr_api.g_varchar2
716: ,p_effective_start_date out nocopy date
717: ,p_effective_end_date out nocopy date
710: ,p_director_flag in varchar2 default hr_api.g_varchar2
711: ,p_request_id in number default hr_api.g_number
712: ,p_program_application_id in number default hr_api.g_number
713: ,p_program_id in number default hr_api.g_number
714: ,p_program_update_date in date default hr_api.g_date
715: ,p_community_flag in varchar2 default hr_api.g_varchar2
716: ,p_effective_start_date out nocopy date
717: ,p_effective_end_date out nocopy date
718: ) is
711: ,p_request_id in number default hr_api.g_number
712: ,p_program_application_id in number default hr_api.g_number
713: ,p_program_id in number default hr_api.g_number
714: ,p_program_update_date in date default hr_api.g_date
715: ,p_community_flag in varchar2 default hr_api.g_varchar2
716: ,p_effective_start_date out nocopy date
717: ,p_effective_end_date out nocopy date
718: ) is
719: --