46: -- default is false. The validation is controlled by a savepoint and
47: -- rollback mechanism. The savepoint is issued at the beginning of the
48: -- process and is rollbacked at the end of the process
49: -- when all the processing has been completed. The rollback is controlled
50: -- by raising and handling the exception hr_api.validate_enabled. We use
51: -- the exception because, by raising the exception with the
52: -- process, we can exit successfully without having any of the 'OUT'
53: -- parameters being set.
54: --
121: Procedure upd
122: (
123: p_stoppage_id in number,
124: p_object_version_number in out number,
125: p_absence_attendance_id in number default hr_api.g_number,
126: p_maternity_id in number default hr_api.g_number,
127: p_reason_id in number default hr_api.g_number,
128: p_user_entered in varchar2 default hr_api.g_varchar2,
129: p_override_stoppage in varchar2 default hr_api.g_varchar2,
122: (
123: p_stoppage_id in number,
124: p_object_version_number in out number,
125: p_absence_attendance_id in number default hr_api.g_number,
126: p_maternity_id in number default hr_api.g_number,
127: p_reason_id in number default hr_api.g_number,
128: p_user_entered in varchar2 default hr_api.g_varchar2,
129: p_override_stoppage in varchar2 default hr_api.g_varchar2,
130: p_employee_notified in varchar2 default hr_api.g_varchar2,
123: p_stoppage_id in number,
124: p_object_version_number in out number,
125: p_absence_attendance_id in number default hr_api.g_number,
126: p_maternity_id in number default hr_api.g_number,
127: p_reason_id in number default hr_api.g_number,
128: p_user_entered in varchar2 default hr_api.g_varchar2,
129: p_override_stoppage in varchar2 default hr_api.g_varchar2,
130: p_employee_notified in varchar2 default hr_api.g_varchar2,
131: p_withhold_from in date default hr_api.g_date,
124: p_object_version_number in out number,
125: p_absence_attendance_id in number default hr_api.g_number,
126: p_maternity_id in number default hr_api.g_number,
127: p_reason_id in number default hr_api.g_number,
128: p_user_entered in varchar2 default hr_api.g_varchar2,
129: p_override_stoppage in varchar2 default hr_api.g_varchar2,
130: p_employee_notified in varchar2 default hr_api.g_varchar2,
131: p_withhold_from in date default hr_api.g_date,
132: p_withhold_to in date default hr_api.g_date,
125: p_absence_attendance_id in number default hr_api.g_number,
126: p_maternity_id in number default hr_api.g_number,
127: p_reason_id in number default hr_api.g_number,
128: p_user_entered in varchar2 default hr_api.g_varchar2,
129: p_override_stoppage in varchar2 default hr_api.g_varchar2,
130: p_employee_notified in varchar2 default hr_api.g_varchar2,
131: p_withhold_from in date default hr_api.g_date,
132: p_withhold_to in date default hr_api.g_date,
133: p_validate in boolean default false
126: p_maternity_id in number default hr_api.g_number,
127: p_reason_id in number default hr_api.g_number,
128: p_user_entered in varchar2 default hr_api.g_varchar2,
129: p_override_stoppage in varchar2 default hr_api.g_varchar2,
130: p_employee_notified in varchar2 default hr_api.g_varchar2,
131: p_withhold_from in date default hr_api.g_date,
132: p_withhold_to in date default hr_api.g_date,
133: p_validate in boolean default false
134: );
127: p_reason_id in number default hr_api.g_number,
128: p_user_entered in varchar2 default hr_api.g_varchar2,
129: p_override_stoppage in varchar2 default hr_api.g_varchar2,
130: p_employee_notified in varchar2 default hr_api.g_varchar2,
131: p_withhold_from in date default hr_api.g_date,
132: p_withhold_to in date default hr_api.g_date,
133: p_validate in boolean default false
134: );
135: --
128: p_user_entered in varchar2 default hr_api.g_varchar2,
129: p_override_stoppage in varchar2 default hr_api.g_varchar2,
130: p_employee_notified in varchar2 default hr_api.g_varchar2,
131: p_withhold_from in date default hr_api.g_date,
132: p_withhold_to in date default hr_api.g_date,
133: p_validate in boolean default false
134: );
135: --
136: end ssp_stp_upd;