29: l_object_version_number ben_ext_crit_val.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_EXT_CRIT_VAL;
35: -- Issue a savepoint if operating in validation only mode
36: --
37: savepoint create_EXT_CRIT_VAL;
38: --
39: hr_utility.set_location(l_proc, 20);
40: --
41: -- Process Logic
42: --
43: begin
103: -- End of API User Hook for the after hook of create_EXT_CRIT_VAL
104: --
105: end;
106: --
107: hr_utility.set_location(l_proc, 60);
108: --
109: -- When in validation only mode raise the Validate_Enabled exception
110: --
111: if p_validate then
116: --
117: p_ext_crit_val_id := l_ext_crit_val_id;
118: p_object_version_number := l_object_version_number;
119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 70);
121: --
122: exception
123: --
124: when hr_api.validate_enabled then
133: -- when validation only mode is being used.)
134: --
135: p_ext_crit_val_id := null;
136: p_object_version_number := null;
137: hr_utility.set_location(' Leaving:'||l_proc, 80);
138: --
139: when others then
140: --
141: -- A validation or unexpected error has occured
145: -- NOCOPY changes.
146: --
147: p_ext_crit_val_id := null;
148: p_object_version_number := null;
149: hr_utility.set_location(' Leaving:'||l_proc, 90);
150: --
151: raise;
152: --
153: end create_EXT_CRIT_VAL;
174: l_object_version_number ben_ext_crit_val.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_EXT_CRIT_VAL;
180: -- Issue a savepoint if operating in validation only mode
181: --
182: savepoint update_EXT_CRIT_VAL;
183: --
184: hr_utility.set_location(l_proc, 20);
185: --
186: -- Process Logic
187: --
188: l_object_version_number := p_object_version_number;
251: -- End of API User Hook for the after hook of update_EXT_CRIT_VAL
252: --
253: end;
254: --
255: hr_utility.set_location(l_proc, 60);
256: --
257: -- When in validation only mode raise the Validate_Enabled exception
258: --
259: if p_validate then
263: -- Set all output arguments
264: --
265: p_object_version_number := l_object_version_number;
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 70);
268: --
269: exception
270: --
271: when hr_api.validate_enabled then
278: -- Only set output warning arguments
279: -- (Any key or derived arguments must be set to null
280: -- when validation only mode is being used.)
281: --
282: hr_utility.set_location(' Leaving:'||l_proc, 80);
283: --
284: when others then
285: --
286: -- A validation or unexpected error has occured
289: --
290: -- NOCOPY changes.
291: --
292: p_object_version_number := l_object_version_number;
293: hr_utility.set_location(' Leaving:'||l_proc, 90);
294: --
295: raise;
296: --
297: end update_EXT_CRIT_VAL;
312: l_object_version_number ben_ext_crit_val.object_version_number%TYPE;
313: --
314: begin
315: --
316: hr_utility.set_location('Entering:'|| l_proc, 10);
317: --
318: -- Issue a savepoint if operating in validation only mode
319: --
320: savepoint delete_EXT_CRIT_VAL;
318: -- Issue a savepoint if operating in validation only mode
319: --
320: savepoint delete_EXT_CRIT_VAL;
321: --
322: hr_utility.set_location(l_proc, 20);
323: --
324: -- Process Logic
325: --
326: l_object_version_number := p_object_version_number;
374: -- End of API User Hook for the after hook of delete_EXT_CRIT_VAL
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
407: --
408: -- NOCOPY changes.
409: --
410: p_object_version_number := l_object_version_number;
411: hr_utility.set_location(' Leaving:'||l_proc, 90);
412: --
413: raise;
414: --
415: end delete_EXT_CRIT_VAL;
430: l_proc varchar2(72) := g_package||'lck';
431: --
432: begin
433: --
434: hr_utility.set_location('Entering:'|| l_proc, 10);
435: --
436: ben_xcv_shd.lck
437: (
438: p_ext_crit_val_id => p_ext_crit_val_id
438: p_ext_crit_val_id => p_ext_crit_val_id
439: ,p_object_version_number => p_object_version_number
440: );
441: --
442: hr_utility.set_location(' Leaving:'||l_proc, 70);
443: --
444: end lck;
445: --
446: end ben_EXT_CRIT_VAL_api;