30: l_object_version_number ghr_noac_las.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_noac_las;
36: -- Issue a savepoint if operating in validation only mode
37: --
38: savepoint create_noac_las;
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_noac_las
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_noac_la_id := l_noac_la_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_noac_la_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
174: l_object_version_number ghr_noac_las.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_noac_las;
180: -- Issue a savepoint if operating in validation only mode
181: --
182: savepoint update_noac_las;
183: --
184: hr_utility.set_location(l_proc, 20);
185: --
186: -- Process Logic
187: --
188: l_object_version_number := p_object_version_number;
256: -- End of API User Hook for the after hook of update_noac_las
257: --
258: end;
259: --
260: hr_utility.set_location(l_proc, 60);
261: --
262: -- When in validation only mode raise the Validate_Enabled exception
263: --
264: if p_validate then
268: -- Set all output arguments
269: --
270: p_object_version_number := l_object_version_number;
271: --
272: hr_utility.set_location(' Leaving:'||l_proc, 70);
273: --
274: exception
275: --
276: when hr_api.validate_enabled then
283: -- Only set output warning arguments
284: -- (Any key or derived arguments must be set to null
285: -- when validation only mode is being used.)
286: --
287: hr_utility.set_location(' Leaving:'||l_proc, 80);
288: --
289: when others then
290: --
291: -- A validation or unexpected error has occured
311: l_object_version_number ghr_noac_las.object_version_number%TYPE;
312: --
313: begin
314: --
315: hr_utility.set_location('Entering:'|| l_proc, 10);
316: --
317: -- Issue a savepoint if operating in validation only mode
318: --
319: savepoint delete_noac_las;
317: -- Issue a savepoint if operating in validation only mode
318: --
319: savepoint delete_noac_las;
320: --
321: hr_utility.set_location(l_proc, 20);
322: --
323: -- Process Logic
324: --
325: l_object_version_number := p_object_version_number;
373: -- End of API User Hook for the after hook of delete_noac_las
374: --
375: end;
376: --
377: hr_utility.set_location(l_proc, 60);
378: --
379: -- When in validation only mode raise the Validate_Enabled exception
380: --
381: if p_validate then
381: if p_validate then
382: raise hr_api.validate_enabled;
383: end if;
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 70);
386: --
387: exception
388: --
389: when hr_api.validate_enabled then
423: l_proc varchar2(72) := g_package||'lck';
424: --
425: begin
426: --
427: hr_utility.set_location('Entering:'|| l_proc, 10);
428: --
429: ghr_nla_shd.lck
430: (
431: p_noac_la_id => p_noac_la_id
431: p_noac_la_id => p_noac_la_id
432: ,p_object_version_number => p_object_version_number
433: );
434: --
435: hr_utility.set_location(' Leaving:'||l_proc, 70);
436: --
437: end lck;
438: --
439: end ghr_noac_las_api;