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.HR_PERSON_ABSENCE_API dependencies on HR_API

Line 628: when hr_api.cannot_find_prog_unit then

624:
625:
626: );
627: exception
628: when hr_api.cannot_find_prog_unit then
629: hr_api.cannot_find_prog_unit_error
630: (p_module_name => 'CREATE_PERSON_ABSENCE'
631: ,p_hook_type => 'BP'
632: );

Line 629: hr_api.cannot_find_prog_unit_error

625:
626: );
627: exception
628: when hr_api.cannot_find_prog_unit then
629: hr_api.cannot_find_prog_unit_error
630: (p_module_name => 'CREATE_PERSON_ABSENCE'
631: ,p_hook_type => 'BP'
632: );
633: end;

Line 922: when hr_api.cannot_find_prog_unit then

918: ,p_abs_day_after_warning => l_abs_day_after_warning
919: ,p_dur_overwritten_warning => l_dur_overwritten_warning
920: );
921: exception
922: when hr_api.cannot_find_prog_unit then
923: hr_api.cannot_find_prog_unit_error
924: (p_module_name => 'CREATE_PERSON_ABSENCE'
925: ,p_hook_type => 'AP'
926: );

Line 923: hr_api.cannot_find_prog_unit_error

919: ,p_dur_overwritten_warning => l_dur_overwritten_warning
920: );
921: exception
922: when hr_api.cannot_find_prog_unit then
923: hr_api.cannot_find_prog_unit_error
924: (p_module_name => 'CREATE_PERSON_ABSENCE'
925: ,p_hook_type => 'AP'
926: );
927: end;

Line 932: raise hr_api.validate_enabled;

928: --
929: -- When in validation only mode raise the Validate_Enabled exception
930: --
931: if p_validate then
932: raise hr_api.validate_enabled;
933: end if;
934: --
935: -- Set all output arguments
936: --

Line 971: when hr_api.validate_enabled then

967:
968: hr_utility.set_location(' Leaving:'||l_proc, 70);
969:
970: exception
971: when hr_api.validate_enabled then
972: --
973: -- As the Validate_Enabled exception has been raised
974: -- we must rollback to the savepoint
975: --

Line 1013: ,p_abs_attendance_reason_id in number default hr_api.g_number

1009: procedure update_person_absence
1010: (p_validate in boolean default false
1011: ,p_effective_date in date
1012: ,p_absence_attendance_id in number
1013: ,p_abs_attendance_reason_id in number default hr_api.g_number
1014: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
1015: ,p_date_notification in date default hr_api.g_date
1016: ,p_date_projected_start in date default hr_api.g_date
1017: ,p_time_projected_start in varchar2 default hr_api.g_varchar2

Line 1014: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792

1010: (p_validate in boolean default false
1011: ,p_effective_date in date
1012: ,p_absence_attendance_id in number
1013: ,p_abs_attendance_reason_id in number default hr_api.g_number
1014: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
1015: ,p_date_notification in date default hr_api.g_date
1016: ,p_date_projected_start in date default hr_api.g_date
1017: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1018: ,p_date_projected_end in date default hr_api.g_date

Line 1015: ,p_date_notification in date default hr_api.g_date

1011: ,p_effective_date in date
1012: ,p_absence_attendance_id in number
1013: ,p_abs_attendance_reason_id in number default hr_api.g_number
1014: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
1015: ,p_date_notification in date default hr_api.g_date
1016: ,p_date_projected_start in date default hr_api.g_date
1017: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1018: ,p_date_projected_end in date default hr_api.g_date
1019: ,p_time_projected_end in varchar2 default hr_api.g_varchar2

Line 1016: ,p_date_projected_start in date default hr_api.g_date

1012: ,p_absence_attendance_id in number
1013: ,p_abs_attendance_reason_id in number default hr_api.g_number
1014: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
1015: ,p_date_notification in date default hr_api.g_date
1016: ,p_date_projected_start in date default hr_api.g_date
1017: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1018: ,p_date_projected_end in date default hr_api.g_date
1019: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1020: ,p_date_start in date default hr_api.g_date

Line 1017: ,p_time_projected_start in varchar2 default hr_api.g_varchar2

1013: ,p_abs_attendance_reason_id in number default hr_api.g_number
1014: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
1015: ,p_date_notification in date default hr_api.g_date
1016: ,p_date_projected_start in date default hr_api.g_date
1017: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1018: ,p_date_projected_end in date default hr_api.g_date
1019: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1020: ,p_date_start in date default hr_api.g_date
1021: ,p_time_start in varchar2 default hr_api.g_varchar2

Line 1018: ,p_date_projected_end in date default hr_api.g_date

1014: ,p_comments in clob default hr_api.g_varchar2 -- Bug#13362792
1015: ,p_date_notification in date default hr_api.g_date
1016: ,p_date_projected_start in date default hr_api.g_date
1017: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1018: ,p_date_projected_end in date default hr_api.g_date
1019: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1020: ,p_date_start in date default hr_api.g_date
1021: ,p_time_start in varchar2 default hr_api.g_varchar2
1022: ,p_date_end in date default hr_api.g_date

Line 1019: ,p_time_projected_end in varchar2 default hr_api.g_varchar2

1015: ,p_date_notification in date default hr_api.g_date
1016: ,p_date_projected_start in date default hr_api.g_date
1017: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1018: ,p_date_projected_end in date default hr_api.g_date
1019: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1020: ,p_date_start in date default hr_api.g_date
1021: ,p_time_start in varchar2 default hr_api.g_varchar2
1022: ,p_date_end in date default hr_api.g_date
1023: ,p_time_end in varchar2 default hr_api.g_varchar2

Line 1020: ,p_date_start in date default hr_api.g_date

1016: ,p_date_projected_start in date default hr_api.g_date
1017: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1018: ,p_date_projected_end in date default hr_api.g_date
1019: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1020: ,p_date_start in date default hr_api.g_date
1021: ,p_time_start in varchar2 default hr_api.g_varchar2
1022: ,p_date_end in date default hr_api.g_date
1023: ,p_time_end in varchar2 default hr_api.g_varchar2
1024: ,p_absence_days in out nocopy number

Line 1021: ,p_time_start in varchar2 default hr_api.g_varchar2

1017: ,p_time_projected_start in varchar2 default hr_api.g_varchar2
1018: ,p_date_projected_end in date default hr_api.g_date
1019: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1020: ,p_date_start in date default hr_api.g_date
1021: ,p_time_start in varchar2 default hr_api.g_varchar2
1022: ,p_date_end in date default hr_api.g_date
1023: ,p_time_end in varchar2 default hr_api.g_varchar2
1024: ,p_absence_days in out nocopy number
1025: ,p_absence_hours in out nocopy number

Line 1022: ,p_date_end in date default hr_api.g_date

1018: ,p_date_projected_end in date default hr_api.g_date
1019: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1020: ,p_date_start in date default hr_api.g_date
1021: ,p_time_start in varchar2 default hr_api.g_varchar2
1022: ,p_date_end in date default hr_api.g_date
1023: ,p_time_end in varchar2 default hr_api.g_varchar2
1024: ,p_absence_days in out nocopy number
1025: ,p_absence_hours in out nocopy number
1026: ,p_authorising_person_id in number default hr_api.g_number

Line 1023: ,p_time_end in varchar2 default hr_api.g_varchar2

1019: ,p_time_projected_end in varchar2 default hr_api.g_varchar2
1020: ,p_date_start in date default hr_api.g_date
1021: ,p_time_start in varchar2 default hr_api.g_varchar2
1022: ,p_date_end in date default hr_api.g_date
1023: ,p_time_end in varchar2 default hr_api.g_varchar2
1024: ,p_absence_days in out nocopy number
1025: ,p_absence_hours in out nocopy number
1026: ,p_authorising_person_id in number default hr_api.g_number
1027: ,p_replacement_person_id in number default hr_api.g_number

Line 1026: ,p_authorising_person_id in number default hr_api.g_number

1022: ,p_date_end in date default hr_api.g_date
1023: ,p_time_end in varchar2 default hr_api.g_varchar2
1024: ,p_absence_days in out nocopy number
1025: ,p_absence_hours in out nocopy number
1026: ,p_authorising_person_id in number default hr_api.g_number
1027: ,p_replacement_person_id in number default hr_api.g_number
1028: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1029: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1027: ,p_replacement_person_id in number default hr_api.g_number

1023: ,p_time_end in varchar2 default hr_api.g_varchar2
1024: ,p_absence_days in out nocopy number
1025: ,p_absence_hours in out nocopy number
1026: ,p_authorising_person_id in number default hr_api.g_number
1027: ,p_replacement_person_id in number default hr_api.g_number
1028: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1029: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1028: ,p_attribute_category in varchar2 default hr_api.g_varchar2

1024: ,p_absence_days in out nocopy number
1025: ,p_absence_hours in out nocopy number
1026: ,p_authorising_person_id in number default hr_api.g_number
1027: ,p_replacement_person_id in number default hr_api.g_number
1028: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1029: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1029: ,p_attribute1 in varchar2 default hr_api.g_varchar2

1025: ,p_absence_hours in out nocopy number
1026: ,p_authorising_person_id in number default hr_api.g_number
1027: ,p_replacement_person_id in number default hr_api.g_number
1028: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1029: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1030: ,p_attribute2 in varchar2 default hr_api.g_varchar2

1026: ,p_authorising_person_id in number default hr_api.g_number
1027: ,p_replacement_person_id in number default hr_api.g_number
1028: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1029: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1031: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1027: ,p_replacement_person_id in number default hr_api.g_number
1028: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1029: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1032: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1028: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1029: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1033: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1029: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1034: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1030: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1035: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1031: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1036: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1032: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1037: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1033: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1038: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1034: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1039: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1035: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1040: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1036: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1041: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1037: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1042: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1038: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1043: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1039: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1044: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1040: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1045: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1041: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1049: ,p_period_of_incapacity_id in number default hr_api.g_number

Line 1046: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1042: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1049: ,p_period_of_incapacity_id in number default hr_api.g_number
1050: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2

Line 1047: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1043: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1049: ,p_period_of_incapacity_id in number default hr_api.g_number
1050: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1051: ,p_maternity_id in number default hr_api.g_number

Line 1048: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1044: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1049: ,p_period_of_incapacity_id in number default hr_api.g_number
1050: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1051: ,p_maternity_id in number default hr_api.g_number
1052: ,p_sickness_start_date in date default hr_api.g_date

Line 1049: ,p_period_of_incapacity_id in number default hr_api.g_number

1045: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1049: ,p_period_of_incapacity_id in number default hr_api.g_number
1050: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1051: ,p_maternity_id in number default hr_api.g_number
1052: ,p_sickness_start_date in date default hr_api.g_date
1053: ,p_sickness_end_date in date default hr_api.g_date

Line 1050: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2

1046: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1049: ,p_period_of_incapacity_id in number default hr_api.g_number
1050: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1051: ,p_maternity_id in number default hr_api.g_number
1052: ,p_sickness_start_date in date default hr_api.g_date
1053: ,p_sickness_end_date in date default hr_api.g_date
1054: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2

Line 1051: ,p_maternity_id in number default hr_api.g_number

1047: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1049: ,p_period_of_incapacity_id in number default hr_api.g_number
1050: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1051: ,p_maternity_id in number default hr_api.g_number
1052: ,p_sickness_start_date in date default hr_api.g_date
1053: ,p_sickness_end_date in date default hr_api.g_date
1054: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1055: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2

Line 1052: ,p_sickness_start_date in date default hr_api.g_date

1048: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1049: ,p_period_of_incapacity_id in number default hr_api.g_number
1050: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1051: ,p_maternity_id in number default hr_api.g_number
1052: ,p_sickness_start_date in date default hr_api.g_date
1053: ,p_sickness_end_date in date default hr_api.g_date
1054: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1055: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1056: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2

Line 1053: ,p_sickness_end_date in date default hr_api.g_date

1049: ,p_period_of_incapacity_id in number default hr_api.g_number
1050: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1051: ,p_maternity_id in number default hr_api.g_number
1052: ,p_sickness_start_date in date default hr_api.g_date
1053: ,p_sickness_end_date in date default hr_api.g_date
1054: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1055: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1056: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1057: ,p_linked_absence_id in number default hr_api.g_number

Line 1054: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2

1050: ,p_ssp1_issued in varchar2 default hr_api.g_varchar2
1051: ,p_maternity_id in number default hr_api.g_number
1052: ,p_sickness_start_date in date default hr_api.g_date
1053: ,p_sickness_end_date in date default hr_api.g_date
1054: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1055: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1056: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1057: ,p_linked_absence_id in number default hr_api.g_number
1058: ,p_batch_id in number default hr_api.g_number

Line 1055: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2

1051: ,p_maternity_id in number default hr_api.g_number
1052: ,p_sickness_start_date in date default hr_api.g_date
1053: ,p_sickness_end_date in date default hr_api.g_date
1054: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1055: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1056: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1057: ,p_linked_absence_id in number default hr_api.g_number
1058: ,p_batch_id in number default hr_api.g_number
1059: ,p_abs_information_category in varchar2 default hr_api.g_varchar2

Line 1056: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2

1052: ,p_sickness_start_date in date default hr_api.g_date
1053: ,p_sickness_end_date in date default hr_api.g_date
1054: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1055: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1056: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1057: ,p_linked_absence_id in number default hr_api.g_number
1058: ,p_batch_id in number default hr_api.g_number
1059: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1060: ,p_abs_information1 in varchar2 default hr_api.g_varchar2

Line 1057: ,p_linked_absence_id in number default hr_api.g_number

1053: ,p_sickness_end_date in date default hr_api.g_date
1054: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1055: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1056: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1057: ,p_linked_absence_id in number default hr_api.g_number
1058: ,p_batch_id in number default hr_api.g_number
1059: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1060: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1061: ,p_abs_information2 in varchar2 default hr_api.g_varchar2

Line 1058: ,p_batch_id in number default hr_api.g_number

1054: ,p_pregnancy_related_illness in varchar2 default hr_api.g_varchar2
1055: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1056: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1057: ,p_linked_absence_id in number default hr_api.g_number
1058: ,p_batch_id in number default hr_api.g_number
1059: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1060: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1061: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1062: ,p_abs_information3 in varchar2 default hr_api.g_varchar2

Line 1059: ,p_abs_information_category in varchar2 default hr_api.g_varchar2

1055: ,p_reason_for_notification_dela in varchar2 default hr_api.g_varchar2
1056: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1057: ,p_linked_absence_id in number default hr_api.g_number
1058: ,p_batch_id in number default hr_api.g_number
1059: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1060: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1061: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1062: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1063: ,p_abs_information4 in varchar2 default hr_api.g_varchar2

Line 1060: ,p_abs_information1 in varchar2 default hr_api.g_varchar2

1056: ,p_accept_late_notification_fla in varchar2 default hr_api.g_varchar2
1057: ,p_linked_absence_id in number default hr_api.g_number
1058: ,p_batch_id in number default hr_api.g_number
1059: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1060: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1061: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1062: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1063: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1064: ,p_abs_information5 in varchar2 default hr_api.g_varchar2

Line 1061: ,p_abs_information2 in varchar2 default hr_api.g_varchar2

1057: ,p_linked_absence_id in number default hr_api.g_number
1058: ,p_batch_id in number default hr_api.g_number
1059: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1060: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1061: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1062: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1063: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1064: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1065: ,p_abs_information6 in varchar2 default hr_api.g_varchar2

Line 1062: ,p_abs_information3 in varchar2 default hr_api.g_varchar2

1058: ,p_batch_id in number default hr_api.g_number
1059: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1060: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1061: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1062: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1063: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1064: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1065: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1066: ,p_abs_information7 in varchar2 default hr_api.g_varchar2

Line 1063: ,p_abs_information4 in varchar2 default hr_api.g_varchar2

1059: ,p_abs_information_category in varchar2 default hr_api.g_varchar2
1060: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1061: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1062: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1063: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1064: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1065: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1066: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1067: ,p_abs_information8 in varchar2 default hr_api.g_varchar2

Line 1064: ,p_abs_information5 in varchar2 default hr_api.g_varchar2

1060: ,p_abs_information1 in varchar2 default hr_api.g_varchar2
1061: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1062: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1063: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1064: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1065: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1066: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1067: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1068: ,p_abs_information9 in varchar2 default hr_api.g_varchar2

Line 1065: ,p_abs_information6 in varchar2 default hr_api.g_varchar2

1061: ,p_abs_information2 in varchar2 default hr_api.g_varchar2
1062: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1063: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1064: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1065: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1066: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1067: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1068: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1069: ,p_abs_information10 in varchar2 default hr_api.g_varchar2

Line 1066: ,p_abs_information7 in varchar2 default hr_api.g_varchar2

1062: ,p_abs_information3 in varchar2 default hr_api.g_varchar2
1063: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1064: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1065: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1066: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1067: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1068: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1069: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1070: ,p_abs_information11 in varchar2 default hr_api.g_varchar2

Line 1067: ,p_abs_information8 in varchar2 default hr_api.g_varchar2

1063: ,p_abs_information4 in varchar2 default hr_api.g_varchar2
1064: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1065: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1066: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1067: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1068: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1069: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1070: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1071: ,p_abs_information12 in varchar2 default hr_api.g_varchar2

Line 1068: ,p_abs_information9 in varchar2 default hr_api.g_varchar2

1064: ,p_abs_information5 in varchar2 default hr_api.g_varchar2
1065: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1066: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1067: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1068: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1069: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1070: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1071: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1072: ,p_abs_information13 in varchar2 default hr_api.g_varchar2

Line 1069: ,p_abs_information10 in varchar2 default hr_api.g_varchar2

1065: ,p_abs_information6 in varchar2 default hr_api.g_varchar2
1066: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1067: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1068: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1069: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1070: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1071: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1072: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1073: ,p_abs_information14 in varchar2 default hr_api.g_varchar2

Line 1070: ,p_abs_information11 in varchar2 default hr_api.g_varchar2

1066: ,p_abs_information7 in varchar2 default hr_api.g_varchar2
1067: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1068: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1069: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1070: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1071: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1072: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1073: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1074: ,p_abs_information15 in varchar2 default hr_api.g_varchar2

Line 1071: ,p_abs_information12 in varchar2 default hr_api.g_varchar2

1067: ,p_abs_information8 in varchar2 default hr_api.g_varchar2
1068: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1069: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1070: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1071: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1072: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1073: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1074: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1075: ,p_abs_information16 in varchar2 default hr_api.g_varchar2

Line 1072: ,p_abs_information13 in varchar2 default hr_api.g_varchar2

1068: ,p_abs_information9 in varchar2 default hr_api.g_varchar2
1069: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1070: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1071: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1072: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1073: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1074: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1075: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1076: ,p_abs_information17 in varchar2 default hr_api.g_varchar2

Line 1073: ,p_abs_information14 in varchar2 default hr_api.g_varchar2

1069: ,p_abs_information10 in varchar2 default hr_api.g_varchar2
1070: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1071: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1072: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1073: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1074: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1075: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1076: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1077: ,p_abs_information18 in varchar2 default hr_api.g_varchar2

Line 1074: ,p_abs_information15 in varchar2 default hr_api.g_varchar2

1070: ,p_abs_information11 in varchar2 default hr_api.g_varchar2
1071: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1072: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1073: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1074: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1075: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1076: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1077: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1078: ,p_abs_information19 in varchar2 default hr_api.g_varchar2

Line 1075: ,p_abs_information16 in varchar2 default hr_api.g_varchar2

1071: ,p_abs_information12 in varchar2 default hr_api.g_varchar2
1072: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1073: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1074: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1075: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1076: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1077: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1078: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1079: ,p_abs_information20 in varchar2 default hr_api.g_varchar2

Line 1076: ,p_abs_information17 in varchar2 default hr_api.g_varchar2

1072: ,p_abs_information13 in varchar2 default hr_api.g_varchar2
1073: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1074: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1075: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1076: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1077: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1078: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1079: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1080: ,p_abs_information21 in varchar2 default hr_api.g_varchar2

Line 1077: ,p_abs_information18 in varchar2 default hr_api.g_varchar2

1073: ,p_abs_information14 in varchar2 default hr_api.g_varchar2
1074: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1075: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1076: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1077: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1078: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1079: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1080: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1081: ,p_abs_information22 in varchar2 default hr_api.g_varchar2

Line 1078: ,p_abs_information19 in varchar2 default hr_api.g_varchar2

1074: ,p_abs_information15 in varchar2 default hr_api.g_varchar2
1075: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1076: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1077: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1078: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1079: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1080: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1081: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1082: ,p_abs_information23 in varchar2 default hr_api.g_varchar2

Line 1079: ,p_abs_information20 in varchar2 default hr_api.g_varchar2

1075: ,p_abs_information16 in varchar2 default hr_api.g_varchar2
1076: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1077: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1078: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1079: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1080: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1081: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1082: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1083: ,p_abs_information24 in varchar2 default hr_api.g_varchar2

Line 1080: ,p_abs_information21 in varchar2 default hr_api.g_varchar2

1076: ,p_abs_information17 in varchar2 default hr_api.g_varchar2
1077: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1078: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1079: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1080: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1081: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1082: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1083: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1084: ,p_abs_information25 in varchar2 default hr_api.g_varchar2

Line 1081: ,p_abs_information22 in varchar2 default hr_api.g_varchar2

1077: ,p_abs_information18 in varchar2 default hr_api.g_varchar2
1078: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1079: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1080: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1081: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1082: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1083: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1084: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1085: ,p_abs_information26 in varchar2 default hr_api.g_varchar2

Line 1082: ,p_abs_information23 in varchar2 default hr_api.g_varchar2

1078: ,p_abs_information19 in varchar2 default hr_api.g_varchar2
1079: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1080: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1081: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1082: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1083: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1084: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1085: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1086: ,p_abs_information27 in varchar2 default hr_api.g_varchar2

Line 1083: ,p_abs_information24 in varchar2 default hr_api.g_varchar2

1079: ,p_abs_information20 in varchar2 default hr_api.g_varchar2
1080: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1081: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1082: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1083: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1084: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1085: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1086: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1087: ,p_abs_information28 in varchar2 default hr_api.g_varchar2

Line 1084: ,p_abs_information25 in varchar2 default hr_api.g_varchar2

1080: ,p_abs_information21 in varchar2 default hr_api.g_varchar2
1081: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1082: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1083: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1084: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1085: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1086: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1087: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1088: ,p_abs_information29 in varchar2 default hr_api.g_varchar2

Line 1085: ,p_abs_information26 in varchar2 default hr_api.g_varchar2

1081: ,p_abs_information22 in varchar2 default hr_api.g_varchar2
1082: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1083: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1084: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1085: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1086: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1087: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1088: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
1089: ,p_abs_information30 in varchar2 default hr_api.g_varchar2

Line 1086: ,p_abs_information27 in varchar2 default hr_api.g_varchar2

1082: ,p_abs_information23 in varchar2 default hr_api.g_varchar2
1083: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1084: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1085: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1086: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1087: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1088: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
1089: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
1090: ,p_absence_case_id in number default hr_api.g_number

Line 1087: ,p_abs_information28 in varchar2 default hr_api.g_varchar2

1083: ,p_abs_information24 in varchar2 default hr_api.g_varchar2
1084: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1085: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1086: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1087: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1088: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
1089: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
1090: ,p_absence_case_id in number default hr_api.g_number
1091: ,p_program_application_id in number default 800

Line 1088: ,p_abs_information29 in varchar2 default hr_api.g_varchar2

1084: ,p_abs_information25 in varchar2 default hr_api.g_varchar2
1085: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1086: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1087: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1088: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
1089: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
1090: ,p_absence_case_id in number default hr_api.g_number
1091: ,p_program_application_id in number default 800
1092: ,p_called_from in number default 800

Line 1089: ,p_abs_information30 in varchar2 default hr_api.g_varchar2

1085: ,p_abs_information26 in varchar2 default hr_api.g_varchar2
1086: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1087: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1088: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
1089: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
1090: ,p_absence_case_id in number default hr_api.g_number
1091: ,p_program_application_id in number default 800
1092: ,p_called_from in number default 800
1093: ,p_object_version_number in out nocopy number

Line 1090: ,p_absence_case_id in number default hr_api.g_number

1086: ,p_abs_information27 in varchar2 default hr_api.g_varchar2
1087: ,p_abs_information28 in varchar2 default hr_api.g_varchar2
1088: ,p_abs_information29 in varchar2 default hr_api.g_varchar2
1089: ,p_abs_information30 in varchar2 default hr_api.g_varchar2
1090: ,p_absence_case_id in number default hr_api.g_number
1091: ,p_program_application_id in number default 800
1092: ,p_called_from in number default 800
1093: ,p_object_version_number in out nocopy number
1094: ,p_dur_dys_less_warning out nocopy boolean

Line 1313: if p_date_start =hr_api.g_date or p_date_end = hr_api.g_date

1309: hr_utility.set_location(' l_timeend ' || l_timeend,22);
1310: hr_utility.set_location(' l_prjtimestart ' || l_prjtimestart,22);
1311: hr_utility.set_location(' l_prjtimeend ' || l_prjtimeend,22);
1312:
1313: if p_date_start =hr_api.g_date or p_date_end = hr_api.g_date
1314: or p_date_projected_start =hr_api.g_date or p_date_projected_end = hr_api.g_date
1315: or p_time_start =hr_api.g_varchar2 or p_time_end = hr_api.g_varchar2
1316: or p_time_projected_start =hr_api.g_varchar2 or p_time_projected_end = hr_api.g_varchar2 then
1317:

Line 1314: or p_date_projected_start =hr_api.g_date or p_date_projected_end = hr_api.g_date

1310: hr_utility.set_location(' l_prjtimestart ' || l_prjtimestart,22);
1311: hr_utility.set_location(' l_prjtimeend ' || l_prjtimeend,22);
1312:
1313: if p_date_start =hr_api.g_date or p_date_end = hr_api.g_date
1314: or p_date_projected_start =hr_api.g_date or p_date_projected_end = hr_api.g_date
1315: or p_time_start =hr_api.g_varchar2 or p_time_end = hr_api.g_varchar2
1316: or p_time_projected_start =hr_api.g_varchar2 or p_time_projected_end = hr_api.g_varchar2 then
1317:
1318: open c_get_absence_dates;

Line 1315: or p_time_start =hr_api.g_varchar2 or p_time_end = hr_api.g_varchar2

1311: hr_utility.set_location(' l_prjtimeend ' || l_prjtimeend,22);
1312:
1313: if p_date_start =hr_api.g_date or p_date_end = hr_api.g_date
1314: or p_date_projected_start =hr_api.g_date or p_date_projected_end = hr_api.g_date
1315: or p_time_start =hr_api.g_varchar2 or p_time_end = hr_api.g_varchar2
1316: or p_time_projected_start =hr_api.g_varchar2 or p_time_projected_end = hr_api.g_varchar2 then
1317:
1318: open c_get_absence_dates;
1319: fetch c_get_absence_dates into l_datestart,l_dateend,l_prjdatestart,

Line 1316: or p_time_projected_start =hr_api.g_varchar2 or p_time_projected_end = hr_api.g_varchar2 then

1312:
1313: if p_date_start =hr_api.g_date or p_date_end = hr_api.g_date
1314: or p_date_projected_start =hr_api.g_date or p_date_projected_end = hr_api.g_date
1315: or p_time_start =hr_api.g_varchar2 or p_time_end = hr_api.g_varchar2
1316: or p_time_projected_start =hr_api.g_varchar2 or p_time_projected_end = hr_api.g_varchar2 then
1317:
1318: open c_get_absence_dates;
1319: fetch c_get_absence_dates into l_datestart,l_dateend,l_prjdatestart,
1320: l_prjdateend,l_timestart,l_timeend,l_prjtimestart,l_prjtimeend;

Line 1323: if p_date_start <> hr_api.g_date and l_datestart is not null then

1319: fetch c_get_absence_dates into l_datestart,l_dateend,l_prjdatestart,
1320: l_prjdateend,l_timestart,l_timeend,l_prjtimestart,l_prjtimeend;
1321: close c_get_absence_dates;
1322: hr_utility.set_location(' l_date_start ' ||l_date_start,20);
1323: if p_date_start <> hr_api.g_date and l_datestart is not null then
1324: l_datestart :=p_date_start;
1325: end if;
1326:
1327: if p_date_end <> hr_api.g_date and l_dateend is not null then

Line 1327: if p_date_end <> hr_api.g_date and l_dateend is not null then

1323: if p_date_start <> hr_api.g_date and l_datestart is not null then
1324: l_datestart :=p_date_start;
1325: end if;
1326:
1327: if p_date_end <> hr_api.g_date and l_dateend is not null then
1328: l_dateend :=p_date_end;
1329: end if;
1330:
1331:

Line 1332: if p_date_projected_start <> hr_api.g_date and l_prjdatestart is not null then

1328: l_dateend :=p_date_end;
1329: end if;
1330:
1331:
1332: if p_date_projected_start <> hr_api.g_date and l_prjdatestart is not null then
1333: l_prjdatestart :=p_date_projected_start;
1334: end if;
1335:
1336: if p_date_projected_end <> hr_api.g_date and l_prjdateend is not null then

Line 1336: if p_date_projected_end <> hr_api.g_date and l_prjdateend is not null then

1332: if p_date_projected_start <> hr_api.g_date and l_prjdatestart is not null then
1333: l_prjdatestart :=p_date_projected_start;
1334: end if;
1335:
1336: if p_date_projected_end <> hr_api.g_date and l_prjdateend is not null then
1337: l_prjdateend :=p_date_projected_end;
1338: end if;
1339:
1340: if p_time_projected_start <> hr_api.g_varchar2 and l_timestart is not null then

Line 1340: if p_time_projected_start <> hr_api.g_varchar2 and l_timestart is not null then

1336: if p_date_projected_end <> hr_api.g_date and l_prjdateend is not null then
1337: l_prjdateend :=p_date_projected_end;
1338: end if;
1339:
1340: if p_time_projected_start <> hr_api.g_varchar2 and l_timestart is not null then
1341: l_prjtimestart :=p_time_projected_start;
1342: end if;
1343:
1344: if p_time_projected_end <> hr_api.g_varchar2 and l_prjtimeend is not null then

Line 1344: if p_time_projected_end <> hr_api.g_varchar2 and l_prjtimeend is not null then

1340: if p_time_projected_start <> hr_api.g_varchar2 and l_timestart is not null then
1341: l_prjtimestart :=p_time_projected_start;
1342: end if;
1343:
1344: if p_time_projected_end <> hr_api.g_varchar2 and l_prjtimeend is not null then
1345: l_prjtimeend :=p_time_projected_end;
1346: end if;
1347:
1348:

Line 1349: if p_time_start <> hr_api.g_varchar2 and l_timestart is not null then

1345: l_prjtimeend :=p_time_projected_end;
1346: end if;
1347:
1348:
1349: if p_time_start <> hr_api.g_varchar2 and l_timestart is not null then
1350: l_timestart :=p_time_start;
1351: end if;
1352:
1353: if p_time_end <> hr_api.g_varchar2 and l_timeend is not null then

Line 1353: if p_time_end <> hr_api.g_varchar2 and l_timeend is not null then

1349: if p_time_start <> hr_api.g_varchar2 and l_timestart is not null then
1350: l_timestart :=p_time_start;
1351: end if;
1352:
1353: if p_time_end <> hr_api.g_varchar2 and l_timeend is not null then
1354: l_timeend :=p_time_end;
1355: end if;
1356:
1357:

Line 1382: --if p_time_projected_start is null or p_date_projected_end = hr_api.g_date or p_time_projected_end is null then

1378: hr_utility.set_message (800,'HR_449868_START_END_DATES5');
1379: hr_utility.raise_error;
1380: end if;
1381:
1382: --if p_time_projected_start is null or p_date_projected_end = hr_api.g_date or p_time_projected_end is null then
1383:
1384: if (l_prjtimestart is null) or (l_prjdateend is null ) or (l_prjtimeend is null ) then
1385:
1386: hr_utility.set_location(' l_hours_or_days 30 ' ||l_hours_or_days,30);

Line 1425: /* if (p_date_projected_start is null or p_date_projected_start= hr_api.g_date)

1421: end if;
1422:
1423: else
1424:
1425: /* if (p_date_projected_start is null or p_date_projected_start= hr_api.g_date)
1426: and ( p_date_projected_end is null or p_date_projected_end = hr_api.g_date) then
1427:
1428: hr_utility.set_message (800,'HR_449864_START_END_DATES1');
1429: hr_utility.raise_error;

Line 1426: and ( p_date_projected_end is null or p_date_projected_end = hr_api.g_date) then

1422:
1423: else
1424:
1425: /* if (p_date_projected_start is null or p_date_projected_start= hr_api.g_date)
1426: and ( p_date_projected_end is null or p_date_projected_end = hr_api.g_date) then
1427:
1428: hr_utility.set_message (800,'HR_449864_START_END_DATES1');
1429: hr_utility.raise_error;
1430: end if;

Line 1486: if p_date_projected_start is null or p_date_projected_start =hr_api.g_date then

1482: l_prjdateend,l_timestart,l_timeend,l_prjtimestart,l_prjtimeend;
1483: close c_get_absence_dates;
1484:
1485:
1486: if p_date_projected_start is null or p_date_projected_start =hr_api.g_date then
1487: ls_prjdatestart := l_prjdatestart;
1488: else
1489: ls_prjdatestart :=p_date_projected_start;
1490: end if;

Line 1492: if p_date_projected_end is null or p_date_projected_end =hr_api.g_date then

1488: else
1489: ls_prjdatestart :=p_date_projected_start;
1490: end if;
1491:
1492: if p_date_projected_end is null or p_date_projected_end =hr_api.g_date then
1493: ls_prjdateend := l_prjdateend;
1494: else
1495: ls_prjdateend :=p_date_projected_end;
1496: end if;

Line 1498: if p_time_projected_start is null or p_time_projected_start = hr_api.g_varchar2 then

1494: else
1495: ls_prjdateend :=p_date_projected_end;
1496: end if;
1497:
1498: if p_time_projected_start is null or p_time_projected_start = hr_api.g_varchar2 then
1499: ls_prjtimestart := l_prjtimestart;
1500: else
1501: ls_prjtimestart := p_time_projected_start;
1502: end if;

Line 1504: if p_time_projected_end is null or p_time_projected_end =hr_api.g_varchar2 then

1500: else
1501: ls_prjtimestart := p_time_projected_start;
1502: end if;
1503:
1504: if p_time_projected_end is null or p_time_projected_end =hr_api.g_varchar2 then
1505: ls_prjtimeend := l_prjtimeend;
1506: else
1507: ls_prjtimeend :=p_time_projected_end;
1508: end if;

Line 1510: if p_date_start is null or p_date_start =hr_api.g_date then

1506: else
1507: ls_prjtimeend :=p_time_projected_end;
1508: end if;
1509:
1510: if p_date_start is null or p_date_start =hr_api.g_date then
1511: ls_datestart := l_datestart;
1512: else
1513: ls_datestart :=p_date_start;
1514: end if;

Line 1516: if p_date_end is null or p_date_end =hr_api.g_date then

1512: else
1513: ls_datestart :=p_date_start;
1514: end if;
1515:
1516: if p_date_end is null or p_date_end =hr_api.g_date then
1517: ls_dateend := l_dateend;
1518: else
1519: ls_dateend :=p_date_end;
1520: end if;

Line 1522: if p_time_start is null or p_time_start =hr_api.g_varchar2 then

1518: else
1519: ls_dateend :=p_date_end;
1520: end if;
1521:
1522: if p_time_start is null or p_time_start =hr_api.g_varchar2 then
1523: ls_timestart := l_timestart;
1524: else
1525: ls_timestart :=p_time_start;
1526: end if;

Line 1528: if p_time_end is null or p_time_end =hr_api.g_varchar2 then

1524: else
1525: ls_timestart :=p_time_start;
1526: end if;
1527:
1528: if p_time_end is null or p_time_end =hr_api.g_varchar2 then
1529: ls_timeend := l_timeend;
1530: else
1531: ls_timeend :=p_time_end;
1532: end if;

Line 1693: when hr_api.cannot_find_prog_unit then

1689: ,p_abs_information29 => p_abs_information29
1690: ,p_abs_information30 => p_abs_information30
1691: );
1692: exception
1693: when hr_api.cannot_find_prog_unit then
1694: hr_api.cannot_find_prog_unit_error
1695: (p_module_name => 'UPDATE_PERSON_ABSENCE'
1696: ,p_hook_type => 'BP'
1697: );

Line 1694: hr_api.cannot_find_prog_unit_error

1690: ,p_abs_information30 => p_abs_information30
1691: );
1692: exception
1693: when hr_api.cannot_find_prog_unit then
1694: hr_api.cannot_find_prog_unit_error
1695: (p_module_name => 'UPDATE_PERSON_ABSENCE'
1696: ,p_hook_type => 'BP'
1697: );
1698: end;

Line 1844: -- values if they are defaulted to hr_api.g_date

1840: close c_get_absence_details;
1841:
1842: --
1843: -- Replace start date and end date by their db row
1844: -- values if they are defaulted to hr_api.g_date
1845: -- for correct element entry validations.
1846: -- This is done for bug 5454141
1847: --
1848:

Line 1849: if (p_date_start = hr_api.g_date)

1845: -- for correct element entry validations.
1846: -- This is done for bug 5454141
1847: --
1848:
1849: if (p_date_start = hr_api.g_date)
1850: then
1851: l_date_start_for_absence := l_date_start1;
1852: else
1853: l_date_start_for_absence := p_date_start;

Line 1856: if (p_date_end = hr_api.g_date)

1852: else
1853: l_date_start_for_absence := p_date_start;
1854: end if;
1855:
1856: if (p_date_end = hr_api.g_date)
1857: then
1858: l_date_end_for_absence := l_date_end1;
1859: else
1860: l_date_end_for_absence := p_date_end;

Line 2031: if l_effective_end_date <> hr_api.g_eot then

2027: -- . still not been entered.
2028: --
2029: hr_utility.set_location('Scenario 7', 75);
2030:
2031: if l_effective_end_date <> hr_api.g_eot then
2032: --
2033: -- End date has been changed or removed so we
2034: -- remove the end date so it continues through
2035: -- until the end of time.

Line 2191: when hr_api.cannot_find_prog_unit then

2187: ,p_dur_overwritten_warning => l_dur_overwritten_warning
2188: ,p_del_element_entry_warning => l_del_element_entry_warning
2189: );
2190: exception
2191: when hr_api.cannot_find_prog_unit then
2192: hr_api.cannot_find_prog_unit_error
2193: (p_module_name => 'UPDATE_PERSON_ABSENCE'
2194: ,p_hook_type => 'AP'
2195: );

Line 2192: hr_api.cannot_find_prog_unit_error

2188: ,p_del_element_entry_warning => l_del_element_entry_warning
2189: );
2190: exception
2191: when hr_api.cannot_find_prog_unit then
2192: hr_api.cannot_find_prog_unit_error
2193: (p_module_name => 'UPDATE_PERSON_ABSENCE'
2194: ,p_hook_type => 'AP'
2195: );
2196: end;

Line 2222: raise hr_api.validate_enabled;

2218: --
2219: -- When in validation only mode raise the Validate_Enabled exception
2220: --
2221: if p_validate then
2222: raise hr_api.validate_enabled;
2223: end if;
2224: --
2225: hr_utility.set_location(' Leaving:'||l_proc, 90);
2226: exception

Line 2227: when hr_api.validate_enabled then

2223: end if;
2224: --
2225: hr_utility.set_location(' Leaving:'||l_proc, 90);
2226: exception
2227: when hr_api.validate_enabled then
2228: --
2229: -- As the Validate_Enabled exception has been raised
2230: -- we must rollback to the savepoint
2231: --

Line 2368: when hr_api.cannot_find_prog_unit then

2364: (p_absence_attendance_id => p_absence_attendance_id
2365: ,p_object_version_number => p_object_version_number
2366: );
2367: exception
2368: when hr_api.cannot_find_prog_unit then
2369: hr_api.cannot_find_prog_unit_error
2370: (p_module_name => 'DELETE_PERSON_ABSENCE'
2371: ,p_hook_type => 'BP'
2372: );

Line 2369: hr_api.cannot_find_prog_unit_error

2365: ,p_object_version_number => p_object_version_number
2366: );
2367: exception
2368: when hr_api.cannot_find_prog_unit then
2369: hr_api.cannot_find_prog_unit_error
2370: (p_module_name => 'DELETE_PERSON_ABSENCE'
2371: ,p_hook_type => 'BP'
2372: );
2373: end;

Line 2451: when hr_api.cannot_find_prog_unit then

2447: ,p_object_version_number => p_object_version_number
2448: ,p_person_id => l_person_id
2449: );
2450: exception
2451: when hr_api.cannot_find_prog_unit then
2452: hr_api.cannot_find_prog_unit_error
2453: (p_module_name => 'DELETE_PERSON_ABSENCE'
2454: ,p_hook_type => 'AP'
2455: );

Line 2452: hr_api.cannot_find_prog_unit_error

2448: ,p_person_id => l_person_id
2449: );
2450: exception
2451: when hr_api.cannot_find_prog_unit then
2452: hr_api.cannot_find_prog_unit_error
2453: (p_module_name => 'DELETE_PERSON_ABSENCE'
2454: ,p_hook_type => 'AP'
2455: );
2456: end;

Line 2469: raise hr_api.validate_enabled;

2465:
2466: -- When in validation only mode raise the Validate_Enabled exception
2467: --
2468: if p_validate then
2469: raise hr_api.validate_enabled;
2470: end if;
2471:
2472: --
2473: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 2475: when hr_api.validate_enabled then

2471:
2472: --
2473: hr_utility.set_location(' Leaving:'||l_proc, 70);
2474: exception
2475: when hr_api.validate_enabled then
2476: --
2477: -- As the Validate_Enabled exception has been raised
2478: -- we must rollback to the savepoint
2479: --

Line 3200: from hr_api_transactions hat,

3196: hat.transaction_ref_id,
3197: pet.ELEMENT_TYPE_ID,
3198: abt.hours_or_days,
3199: decode (hrtsteps.INFORMATION9,'CONFIRMED','Y','N') CONFIRMED_FLAG
3200: from hr_api_transactions hat,
3201: HR_API_TRANSACTION_STEPS hrtsteps,
3202: per_absence_attendance_types abt,
3203: pay_input_values_f piv,
3204: pay_element_types_f pet

Line 3201: HR_API_TRANSACTION_STEPS hrtsteps,

3197: pet.ELEMENT_TYPE_ID,
3198: abt.hours_or_days,
3199: decode (hrtsteps.INFORMATION9,'CONFIRMED','Y','N') CONFIRMED_FLAG
3200: from hr_api_transactions hat,
3201: HR_API_TRANSACTION_STEPS hrtsteps,
3202: per_absence_attendance_types abt,
3203: pay_input_values_f piv,
3204: pay_element_types_f pet
3205: where

Line 3251: from hr_api_transactions hat,

3247: and p_end_date >= nvl(aba.date_start,aba.DATE_PROJECTED_START))
3248:
3249: and aba.absence_attendance_id not in
3250: ( select hat.transaction_ref_id
3251: from hr_api_transactions hat,
3252: HR_API_TRANSACTION_STEPS hrtsteps
3253: where
3254: hat.SELECTED_PERSON_ID = p_person_id
3255: --hat.creator_person_id = 125

Line 3252: HR_API_TRANSACTION_STEPS hrtsteps

3248:
3249: and aba.absence_attendance_id not in
3250: ( select hat.transaction_ref_id
3251: from hr_api_transactions hat,
3252: HR_API_TRANSACTION_STEPS hrtsteps
3253: where
3254: hat.SELECTED_PERSON_ID = p_person_id
3255: --hat.creator_person_id = 125
3256: and hat.TRANSACTION_REF_TABLE = 'PER_ABSENCE_ATTENDANCES'