29: l_object_version_number ben_csr_activities.object_version_number%TYPE;
30: --
31: begin
32: --
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Issue a savepoint if operating in validation only mode
36: --
37: savepoint create_online_activity;
35: -- Issue a savepoint if operating in validation only mode
36: --
37: savepoint create_online_activity;
38: --
39: hr_utility.set_location(l_proc, 20);
40: --
41: -- Process Logic
42: --
43: begin
105: -- End of API User Hook for the after hook of create_online_activity
106: --
107: end;
108: --
109: hr_utility.set_location(l_proc, 60);
110: --
111: -- When in validation only mode raise the Validate_Enabled exception
112: --
113: if p_validate then
118: --
119: p_csr_activities_id := l_csr_activities_id;
120: p_object_version_number := l_object_version_number;
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 70);
123: --
124: exception
125: --
126: when hr_api.validate_enabled then
135: -- when validation only mode is being used.)
136: --
137: p_csr_activities_id := null;
138: p_object_version_number := null;
139: hr_utility.set_location(' Leaving:'||l_proc, 80);
140: --
141: when others then
142: --
143: -- A validation or unexpected error has occured
174: l_object_version_number ben_csr_activities.object_version_number%TYPE;
175: --
176: begin
177: --
178: hr_utility.set_location('Entering:'|| l_proc, 10);
179: --
180: -- Issue a savepoint if operating in validation only mode
181: --
182: savepoint update_online_activity;
180: -- Issue a savepoint if operating in validation only mode
181: --
182: savepoint update_online_activity;
183: --
184: hr_utility.set_location(l_proc, 20);
185: --
186: -- Process Logic
187: --
188: l_object_version_number := p_object_version_number;
253: -- End of API User Hook for the after hook of update_online_activity
254: --
255: end;
256: --
257: hr_utility.set_location(l_proc, 60);
258: --
259: -- When in validation only mode raise the Validate_Enabled exception
260: --
261: if p_validate then
265: -- Set all output arguments
266: --
267: p_object_version_number := l_object_version_number;
268: --
269: hr_utility.set_location(' Leaving:'||l_proc, 70);
270: --
271: exception
272: --
273: when hr_api.validate_enabled then
280: -- Only set output warning arguments
281: -- (Any key or derived arguments must be set to null
282: -- when validation only mode is being used.)
283: --
284: hr_utility.set_location(' Leaving:'||l_proc, 80);
285: --
286: when others then
287: --
288: -- A validation or unexpected error has occured
307: l_object_version_number ben_csr_activities.object_version_number%TYPE;
308: --
309: begin
310: --
311: hr_utility.set_location('Entering:'|| l_proc, 10);
312: --
313: -- Issue a savepoint if operating in validation only mode
314: --
315: savepoint delete_online_activity;
313: -- Issue a savepoint if operating in validation only mode
314: --
315: savepoint delete_online_activity;
316: --
317: hr_utility.set_location(l_proc, 20);
318: --
319: -- Process Logic
320: --
321: l_object_version_number := p_object_version_number;
366: -- End of API User Hook for the after hook of delete_online_activity
367: --
368: end;
369: --
370: hr_utility.set_location(l_proc, 60);
371: --
372: -- When in validation only mode raise the Validate_Enabled exception
373: --
374: if p_validate then
374: if p_validate then
375: raise hr_api.validate_enabled;
376: end if;
377: --
378: hr_utility.set_location(' Leaving:'||l_proc, 70);
379: --
380: exception
381: --
382: when hr_api.validate_enabled then
416: l_proc varchar2(72) := g_package||'lck';
417: --
418: begin
419: --
420: hr_utility.set_location('Entering:'|| l_proc, 10);
421: --
422: ben_ola_shd.lck
423: (
424: p_csr_activities_id => p_csr_activities_id
424: p_csr_activities_id => p_csr_activities_id
425: ,p_object_version_number => p_object_version_number
426: );
427: --
428: hr_utility.set_location(' Leaving:'||l_proc, 70);
429: --
430: end lck;
431: --
432: end ben_online_activity_api;