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_ipd_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_ipd_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_ipd_shd.constraint_error
122: -- A check constraint has been violated
123: --
124: pay_ipd_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_ipd_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_ipd_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_ipd_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_PAYE_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_PAYE_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_ipd_shd.g_old_rec.assignment_id;
550: End If;
551: If (p_rec.info_source = hr_api.g_varchar2) then
547: If (p_rec.assignment_id = hr_api.g_number) then
548: p_rec.assignment_id :=
549: pay_ipd_shd.g_old_rec.assignment_id;
550: End If;
551: If (p_rec.info_source = hr_api.g_varchar2) then
552: p_rec.info_source :=
553: pay_ipd_shd.g_old_rec.info_source;
554: End If;
555: If (p_rec.comm_period_no = hr_api.g_number) then
551: If (p_rec.info_source = hr_api.g_varchar2) then
552: p_rec.info_source :=
553: pay_ipd_shd.g_old_rec.info_source;
554: End If;
555: If (p_rec.comm_period_no = hr_api.g_number) then
556: p_rec.comm_period_no :=
557: pay_ipd_shd.g_old_rec.comm_period_no;
558: End If;
559: If (p_rec.tax_basis = hr_api.g_varchar2) then
555: If (p_rec.comm_period_no = hr_api.g_number) then
556: p_rec.comm_period_no :=
557: pay_ipd_shd.g_old_rec.comm_period_no;
558: End If;
559: If (p_rec.tax_basis = hr_api.g_varchar2) then
560: p_rec.tax_basis :=
561: pay_ipd_shd.g_old_rec.tax_basis;
562: End If;
563: If (p_rec.certificate_start_date = hr_api.g_date) then
559: If (p_rec.tax_basis = hr_api.g_varchar2) then
560: p_rec.tax_basis :=
561: pay_ipd_shd.g_old_rec.tax_basis;
562: End If;
563: If (p_rec.certificate_start_date = hr_api.g_date) then
564: p_rec.certificate_start_date :=
565: pay_ipd_shd.g_old_rec.certificate_start_date;
566: End If;
567: If (p_rec.certificate_end_date = hr_api.g_date) then
563: If (p_rec.certificate_start_date = hr_api.g_date) then
564: p_rec.certificate_start_date :=
565: pay_ipd_shd.g_old_rec.certificate_start_date;
566: End If;
567: If (p_rec.certificate_end_date = hr_api.g_date) then
568: p_rec.certificate_end_date :=
569: pay_ipd_shd.g_old_rec.certificate_end_date;
570: End If;
571: If (p_rec.tax_assess_basis = hr_api.g_varchar2) then
567: If (p_rec.certificate_end_date = hr_api.g_date) then
568: p_rec.certificate_end_date :=
569: pay_ipd_shd.g_old_rec.certificate_end_date;
570: End If;
571: If (p_rec.tax_assess_basis = hr_api.g_varchar2) then
572: p_rec.tax_assess_basis :=
573: pay_ipd_shd.g_old_rec.tax_assess_basis;
574: End If;
575: If (p_rec.weekly_tax_credit = hr_api.g_number) then
571: If (p_rec.tax_assess_basis = hr_api.g_varchar2) then
572: p_rec.tax_assess_basis :=
573: pay_ipd_shd.g_old_rec.tax_assess_basis;
574: End If;
575: If (p_rec.weekly_tax_credit = hr_api.g_number) then
576: p_rec.weekly_tax_credit :=
577: pay_ipd_shd.g_old_rec.weekly_tax_credit;
578: End If;
579: If (p_rec.weekly_std_rate_cut_off = hr_api.g_number) then
575: If (p_rec.weekly_tax_credit = hr_api.g_number) then
576: p_rec.weekly_tax_credit :=
577: pay_ipd_shd.g_old_rec.weekly_tax_credit;
578: End If;
579: If (p_rec.weekly_std_rate_cut_off = hr_api.g_number) then
580: p_rec.weekly_std_rate_cut_off :=
581: pay_ipd_shd.g_old_rec.weekly_std_rate_cut_off;
582: End If;
583: If (p_rec.monthly_tax_credit = hr_api.g_number) then
579: If (p_rec.weekly_std_rate_cut_off = hr_api.g_number) then
580: p_rec.weekly_std_rate_cut_off :=
581: pay_ipd_shd.g_old_rec.weekly_std_rate_cut_off;
582: End If;
583: If (p_rec.monthly_tax_credit = hr_api.g_number) then
584: p_rec.monthly_tax_credit :=
585: pay_ipd_shd.g_old_rec.monthly_tax_credit;
586: End If;
587: If (p_rec.monthly_std_rate_cut_off = hr_api.g_number) then
583: If (p_rec.monthly_tax_credit = hr_api.g_number) then
584: p_rec.monthly_tax_credit :=
585: pay_ipd_shd.g_old_rec.monthly_tax_credit;
586: End If;
587: If (p_rec.monthly_std_rate_cut_off = hr_api.g_number) then
588: p_rec.monthly_std_rate_cut_off :=
589: pay_ipd_shd.g_old_rec.monthly_std_rate_cut_off;
590: End If;
591: If (p_rec.request_id = hr_api.g_number) then
587: If (p_rec.monthly_std_rate_cut_off = hr_api.g_number) then
588: p_rec.monthly_std_rate_cut_off :=
589: pay_ipd_shd.g_old_rec.monthly_std_rate_cut_off;
590: End If;
591: If (p_rec.request_id = hr_api.g_number) then
592: p_rec.request_id :=
593: pay_ipd_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_ipd_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_ipd_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_ipd_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_ipd_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_ipd_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_ipd_shd.g_old_rec.program_update_date;
606: End If;
607: If (p_rec.certificate_issue_date = hr_api.g_date) then
603: If (p_rec.program_update_date = hr_api.g_date) then
604: p_rec.program_update_date :=
605: pay_ipd_shd.g_old_rec.program_update_date;
606: End If;
607: If (p_rec.certificate_issue_date = hr_api.g_date) then
608: p_rec.certificate_issue_date :=
609: pay_ipd_shd.g_old_rec.certificate_issue_date;
610: End If;
611: --
696: (p_effective_date in date
697: ,p_datetrack_mode in varchar2
698: ,p_paye_details_id in number
699: ,p_object_version_number in out nocopy number
700: ,p_info_source in varchar2 default hr_api.g_varchar2
701: ,p_tax_basis in varchar2 default hr_api.g_varchar2
702: ,p_certificate_start_date in date default hr_api.g_date
703: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
704: ,p_certificate_end_date in date default hr_api.g_date
697: ,p_datetrack_mode in varchar2
698: ,p_paye_details_id in number
699: ,p_object_version_number in out nocopy number
700: ,p_info_source in varchar2 default hr_api.g_varchar2
701: ,p_tax_basis in varchar2 default hr_api.g_varchar2
702: ,p_certificate_start_date in date default hr_api.g_date
703: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
704: ,p_certificate_end_date in date default hr_api.g_date
705: ,p_weekly_tax_credit in number default hr_api.g_number
698: ,p_paye_details_id in number
699: ,p_object_version_number in out nocopy number
700: ,p_info_source in varchar2 default hr_api.g_varchar2
701: ,p_tax_basis in varchar2 default hr_api.g_varchar2
702: ,p_certificate_start_date in date default hr_api.g_date
703: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
704: ,p_certificate_end_date in date default hr_api.g_date
705: ,p_weekly_tax_credit in number default hr_api.g_number
706: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
699: ,p_object_version_number in out nocopy number
700: ,p_info_source in varchar2 default hr_api.g_varchar2
701: ,p_tax_basis in varchar2 default hr_api.g_varchar2
702: ,p_certificate_start_date in date default hr_api.g_date
703: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
704: ,p_certificate_end_date in date default hr_api.g_date
705: ,p_weekly_tax_credit in number default hr_api.g_number
706: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
707: ,p_monthly_tax_credit in number default hr_api.g_number
700: ,p_info_source in varchar2 default hr_api.g_varchar2
701: ,p_tax_basis in varchar2 default hr_api.g_varchar2
702: ,p_certificate_start_date in date default hr_api.g_date
703: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
704: ,p_certificate_end_date in date default hr_api.g_date
705: ,p_weekly_tax_credit in number default hr_api.g_number
706: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
707: ,p_monthly_tax_credit in number default hr_api.g_number
708: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
701: ,p_tax_basis in varchar2 default hr_api.g_varchar2
702: ,p_certificate_start_date in date default hr_api.g_date
703: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
704: ,p_certificate_end_date in date default hr_api.g_date
705: ,p_weekly_tax_credit in number default hr_api.g_number
706: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
707: ,p_monthly_tax_credit in number default hr_api.g_number
708: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
709: ,p_request_id in number default hr_api.g_number
702: ,p_certificate_start_date in date default hr_api.g_date
703: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
704: ,p_certificate_end_date in date default hr_api.g_date
705: ,p_weekly_tax_credit in number default hr_api.g_number
706: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
707: ,p_monthly_tax_credit in number default hr_api.g_number
708: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
709: ,p_request_id in number default hr_api.g_number
710: ,p_program_application_id in number default hr_api.g_number
703: ,p_tax_assess_basis in varchar2 default hr_api.g_varchar2
704: ,p_certificate_end_date in date default hr_api.g_date
705: ,p_weekly_tax_credit in number default hr_api.g_number
706: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
707: ,p_monthly_tax_credit in number default hr_api.g_number
708: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
709: ,p_request_id in number default hr_api.g_number
710: ,p_program_application_id in number default hr_api.g_number
711: ,p_program_id in number default hr_api.g_number
704: ,p_certificate_end_date in date default hr_api.g_date
705: ,p_weekly_tax_credit in number default hr_api.g_number
706: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
707: ,p_monthly_tax_credit in number default hr_api.g_number
708: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
709: ,p_request_id in number default hr_api.g_number
710: ,p_program_application_id in number default hr_api.g_number
711: ,p_program_id in number default hr_api.g_number
712: ,p_program_update_date in date default hr_api.g_date
705: ,p_weekly_tax_credit in number default hr_api.g_number
706: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
707: ,p_monthly_tax_credit in number default hr_api.g_number
708: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
709: ,p_request_id in number default hr_api.g_number
710: ,p_program_application_id in number default hr_api.g_number
711: ,p_program_id in number default hr_api.g_number
712: ,p_program_update_date in date default hr_api.g_date
713: ,p_certificate_issue_date in date default hr_api.g_date
706: ,p_weekly_std_rate_cut_off in number default hr_api.g_number
707: ,p_monthly_tax_credit in number default hr_api.g_number
708: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
709: ,p_request_id in number default hr_api.g_number
710: ,p_program_application_id in number default hr_api.g_number
711: ,p_program_id in number default hr_api.g_number
712: ,p_program_update_date in date default hr_api.g_date
713: ,p_certificate_issue_date in date default hr_api.g_date
714: ,p_effective_start_date out nocopy date
707: ,p_monthly_tax_credit in number default hr_api.g_number
708: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
709: ,p_request_id in number default hr_api.g_number
710: ,p_program_application_id in number default hr_api.g_number
711: ,p_program_id in number default hr_api.g_number
712: ,p_program_update_date in date default hr_api.g_date
713: ,p_certificate_issue_date in date default hr_api.g_date
714: ,p_effective_start_date out nocopy date
715: ,p_effective_end_date out nocopy date
708: ,p_monthly_std_rate_cut_off in number default hr_api.g_number
709: ,p_request_id in number default hr_api.g_number
710: ,p_program_application_id in number default hr_api.g_number
711: ,p_program_id in number default hr_api.g_number
712: ,p_program_update_date in date default hr_api.g_date
713: ,p_certificate_issue_date in date default hr_api.g_date
714: ,p_effective_start_date out nocopy date
715: ,p_effective_end_date out nocopy date
716: ) is
709: ,p_request_id in number default hr_api.g_number
710: ,p_program_application_id in number default hr_api.g_number
711: ,p_program_id in number default hr_api.g_number
712: ,p_program_update_date in date default hr_api.g_date
713: ,p_certificate_issue_date in date default hr_api.g_date
714: ,p_effective_start_date out nocopy date
715: ,p_effective_end_date out nocopy date
716: ) is
717: --
729: (p_paye_details_id
730: ,null
731: ,null
732: ,p_object_version_number
733: ,hr_api.g_number
734: ,p_info_source
735: ,hr_api.g_number
736: ,p_tax_basis
737: ,p_certificate_start_date
731: ,null
732: ,p_object_version_number
733: ,hr_api.g_number
734: ,p_info_source
735: ,hr_api.g_number
736: ,p_tax_basis
737: ,p_certificate_start_date
738: ,p_certificate_end_date
739: ,p_tax_assess_basis