[Home] [Help]
37: l_last_updated_by number;
38: l_object_version_number number;
39: --
40: begin
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Issue a savepoint
44: --
45: savepoint create_absence_action;
72: ,p_hook_type => 'BP'
73: );
74: end;
75: --
76: hr_utility.set_location('Entering:'|| l_proc, 20);
77: --
78: -- Insert Absence Action
79: --
80: per_naa_ins.ins
133: p_absence_action_id := l_absence_action_id;
134: p_object_version_number := l_object_version_number;
135: -- p_some_warning :=
136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 70);
138: exception
139: when hr_api.validate_enabled then
140: --
141: -- As the Validate_Enabled exception has been raised
149: --
150: p_absence_action_id := null;
151: p_object_version_number := null;
152: -- p_some_warning :=
153: hr_utility.set_location(' Leaving:'||l_proc, 80);
154: when others then
155: --
156: -- A validation or unexpected error has occured
157: --
160: -- set in out parameters and set out parameters
161: --
162: p_absence_action_id := null;
163: p_object_version_number := null;
164: hr_utility.set_location(' Leaving:'||l_proc, 90);
165: raise;
166: end CREATE_ABSENCE_ACTION;
167: --
168: -- ----------------------------------------------------------------------------
198: l_object_version_number number := p_object_version_number;
199: l_ovn number := p_object_version_number;
200: --
201: begin
202: hr_utility.set_location('Entering:'|| l_proc, 10);
203: --
204: -- Issue a savepoint
205: --
206: savepoint update_absence_action;
235: ,p_hook_type => 'BP'
236: );
237: end;
238: --
239: hr_utility.set_location('Entering:'|| l_proc, 20);
240: --
241: -- Update Absence Action
242: --
243: per_naa_upd.upd
295: --
296: p_object_version_number := l_object_version_number;
297: -- p_some_warning :=
298: --
299: hr_utility.set_location(' Leaving:'||l_proc, 70);
300: exception
301: when hr_api.validate_enabled then
302: --
303: -- As the Validate_Enabled exception has been raised
310: -- when validation only mode is being used.)
311: --
312: p_object_version_number := null;
313: -- p_some_warning :=
314: hr_utility.set_location(' Leaving:'||l_proc, 80);
315: when others then
316: --
317: -- A validation or unexpected error has occured
318: --
320: --
321: -- set in out parameters and set out parameters
322: --
323: p_object_version_number := l_ovn;
324: hr_utility.set_location(' Leaving:'||l_proc, 90);
325: raise;
326: end UPDATE_ABSENCE_ACTION;
327: --
328: -- ----------------------------------------------------------------------------
342: -- Declare Out Parameters
343: --
344: --
345: begin
346: hr_utility.set_location('Entering:'|| l_proc, 10);
347: --
348: -- Issue a savepoint
349: --
350: savepoint delete_absence_action;
365: ,p_hook_type => 'BP'
366: );
367: end;
368: --
369: hr_utility.set_location('Entering:'|| l_proc, 20);
370: --
371: -- Delete Absence Action
372: --
373: per_naa_del.del
405: -- Set all output arguments
406: --
407: -- p_some_warning :=
408: --
409: hr_utility.set_location(' Leaving:'||l_proc, 70);
410: exception
411: when hr_api.validate_enabled then
412: --
413: -- As the Validate_Enabled exception has been raised
418: -- Only set output warning arguments
419: -- (Any key or derived arguments must be set to null
420: -- when validation only mode is being used.)
421: --
422: hr_utility.set_location(' Leaving:'||l_proc, 80);
423: when others then
424: --
425: -- A validation or unexpected error has occured
426: --
424: --
425: -- A validation or unexpected error has occured
426: --
427: rollback to DELETE_ABSENCE_ACTION;
428: hr_utility.set_location(' Leaving:'||l_proc, 90);
429: raise;
430: end DELETE_ABSENCE_ACTION;
431: --
432: end HR_NL_ABSENCE_ACTION_api;