30: l_object_version_number ben_batch_elig_info.object_version_number%TYPE;
31: --
32: begin
33: --
34: hr_utility.set_location('Entering:'|| l_proc, 10);
35: --
36: -- Issue a savepoint if operating in validation only mode
37: --
38: savepoint create_batch_elig_info;
36: -- Issue a savepoint if operating in validation only mode
37: --
38: savepoint create_batch_elig_info;
39: --
40: hr_utility.set_location(l_proc, 20);
41: --
42: -- Process Logic
43: --
44: begin
109: -- End of API User Hook for the after hook of create_batch_elig_info
110: --
111: end;
112: --
113: hr_utility.set_location(l_proc, 60);
114: --
115: -- When in validation only mode raise the Validate_Enabled exception
116: --
117: if p_validate then
122: --
123: p_batch_elig_id := l_batch_elig_id;
124: p_object_version_number := l_object_version_number;
125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 70);
127: --
128: exception
129: --
130: when hr_api.validate_enabled then
139: -- when validation only mode is being used.)
140: --
141: p_batch_elig_id := null;
142: p_object_version_number := null;
143: hr_utility.set_location(' Leaving:'||l_proc, 80);
144: --
145: when others then
146: --
147: -- A validation or unexpected error has occured
177: l_object_version_number ben_batch_elig_info.object_version_number%TYPE;
178: --
179: begin
180: --
181: hr_utility.set_location('Entering:'|| l_proc, 10);
182: --
183: -- Issue a savepoint if operating in validation only mode
184: --
185: savepoint update_batch_elig_info;
183: -- Issue a savepoint if operating in validation only mode
184: --
185: savepoint update_batch_elig_info;
186: --
187: hr_utility.set_location(l_proc, 20);
188: --
189: -- Process Logic
190: --
191: l_object_version_number := p_object_version_number;
258: -- End of API User Hook for the after hook of update_batch_elig_info
259: --
260: end;
261: --
262: hr_utility.set_location(l_proc, 60);
263: --
264: -- When in validation only mode raise the Validate_Enabled exception
265: --
266: if p_validate then
270: -- Set all output arguments
271: --
272: p_object_version_number := l_object_version_number;
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 70);
275: --
276: exception
277: --
278: when hr_api.validate_enabled then
285: -- Only set output warning arguments
286: -- (Any key or derived arguments must be set to null
287: -- when validation only mode is being used.)
288: --
289: hr_utility.set_location(' Leaving:'||l_proc, 80);
290: --
291: when others then
292: --
293: -- A validation or unexpected error has occured
314: l_object_version_number ben_batch_elig_info.object_version_number%TYPE;
315: --
316: begin
317: --
318: hr_utility.set_location('Entering:'|| l_proc, 10);
319: --
320: -- Issue a savepoint if operating in validation only mode
321: --
322: savepoint delete_batch_elig_info;
320: -- Issue a savepoint if operating in validation only mode
321: --
322: savepoint delete_batch_elig_info;
323: --
324: hr_utility.set_location(l_proc, 20);
325: --
326: -- Process Logic
327: --
328: l_object_version_number := p_object_version_number;
374: -- End of API User Hook for the after hook of delete_batch_elig_info
375: --
376: end;
377: --
378: hr_utility.set_location(l_proc, 60);
379: --
380: -- When in validation only mode raise the Validate_Enabled exception
381: --
382: if p_validate then
382: if p_validate then
383: raise hr_api.validate_enabled;
384: end if;
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 70);
387: --
388: exception
389: --
390: when hr_api.validate_enabled then
424: l_proc varchar2(72) := g_package||'lck';
425: --
426: begin
427: --
428: hr_utility.set_location('Entering:'|| l_proc, 10);
429: --
430: ben_bei_shd.lck
431: (p_batch_elig_id => p_batch_elig_id
432: ,p_object_version_number => p_object_version_number);
430: ben_bei_shd.lck
431: (p_batch_elig_id => p_batch_elig_id
432: ,p_object_version_number => p_object_version_number);
433: --
434: hr_utility.set_location(' Leaving:'||l_proc, 70);
435: --
436: end lck;
437: --
438: end ben_batch_elig_info_api;