eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SID_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

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.

Line 121: When hr_api.check_integrity_violated Then

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));

Line 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

Line 126: When hr_api.unique_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
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 247: If (p_datetrack_mode <> hr_api.g_correction) then

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

Line 260: If (p_datetrack_mode = hr_api.g_update_override) then

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: --

Line 482: when hr_api.cannot_find_prog_unit then

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');

Line 484: hr_api.cannot_find_prog_unit_error

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;

Line 547: If (p_rec.assignment_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 700: ,p_assignment_id in number default hr_api.g_number

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

Line 701: ,p_contribution_class in varchar2 default hr_api.g_varchar2

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

Line 702: ,p_overridden_subclass in varchar2 default hr_api.g_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
706: ,p_non_standard_ins_weeks in number default hr_api.g_number

Line 703: ,p_soc_ben_flag in varchar2 default hr_api.g_varchar2

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

Line 704: ,p_soc_ben_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

Line 705: ,p_overridden_ins_weeks 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
709: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2

Line 706: ,p_non_standard_ins_weeks in number default hr_api.g_number

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

Line 707: ,p_exemption_start_date in date default hr_api.g_date

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

Line 708: ,p_exemption_end_date in date default hr_api.g_date

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

Line 709: ,p_cert_issued_by in varchar2 default hr_api.g_varchar2

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

Line 710: ,p_director_flag in varchar2 default hr_api.g_varchar2

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

Line 711: ,p_request_id 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
715: ,p_community_flag in varchar2 default hr_api.g_varchar2

Line 712: ,p_program_application_id in number default hr_api.g_number

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

Line 713: ,p_program_id in number default hr_api.g_number

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

Line 714: ,p_program_update_date in date default hr_api.g_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

Line 715: ,p_community_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
719: --