[Home] [Help]
31: l_object_version_number pqh_special_attributes.object_version_number%TYPE;
32: --
33: begin
34: --
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Issue a savepoint if operating in validation only mode
38: --
39: savepoint create_special_attribute;
37: -- Issue a savepoint if operating in validation only mode
38: --
39: savepoint create_special_attribute;
40: --
41: hr_utility.set_location(l_proc, 20);
42: --
43: -- Process Logic
44: --
45: begin
113: -- End of API User Hook for the after hook of create_special_attribute
114: --
115: end;
116: --
117: hr_utility.set_location(l_proc, 60);
118: --
119: -- When in validation only mode raise the Validate_Enabled exception
120: --
121: if p_validate then
126: --
127: p_special_attribute_id := l_special_attribute_id;
128: p_object_version_number := l_object_version_number;
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 70);
131: --
132: exception
133: --
134: when hr_api.validate_enabled then
143: -- when validation only mode is being used.)
144: --
145: p_special_attribute_id := null;
146: p_object_version_number := null;
147: hr_utility.set_location(' Leaving:'||l_proc, 80);
148: --
149: when others then
150: p_special_attribute_id := null;
151: p_object_version_number := null;
181: l_object_version_number pqh_special_attributes.object_version_number%TYPE;
182: --
183: begin
184: --
185: hr_utility.set_location('Entering:'|| l_proc, 10);
186: --
187: -- Issue a savepoint if operating in validation only mode
188: --
189: savepoint update_special_attribute;
187: -- Issue a savepoint if operating in validation only mode
188: --
189: savepoint update_special_attribute;
190: --
191: hr_utility.set_location(l_proc, 20);
192: --
193: -- Process Logic
194: --
195: l_object_version_number := p_object_version_number;
266: -- End of API User Hook for the after hook of update_special_attribute
267: --
268: end;
269: --
270: hr_utility.set_location(l_proc, 60);
271: --
272: -- When in validation only mode raise the Validate_Enabled exception
273: --
274: if p_validate then
278: -- Set all output arguments
279: --
280: p_object_version_number := l_object_version_number;
281: --
282: hr_utility.set_location(' Leaving:'||l_proc, 70);
283: --
284: exception
285: --
286: when hr_api.validate_enabled then
293: -- Only set output warning arguments
294: -- (Any key or derived arguments must be set to null
295: -- when validation only mode is being used.)
296: --
297: hr_utility.set_location(' Leaving:'||l_proc, 80);
298: --
299: when others then
300: p_object_version_number := l_object_version_number;
301: --
322: l_object_version_number pqh_special_attributes.object_version_number%TYPE;
323: --
324: begin
325: --
326: hr_utility.set_location('Entering:'|| l_proc, 10);
327: --
328: -- Issue a savepoint if operating in validation only mode
329: --
330: savepoint delete_special_attribute;
328: -- Issue a savepoint if operating in validation only mode
329: --
330: savepoint delete_special_attribute;
331: --
332: hr_utility.set_location(l_proc, 20);
333: --
334: -- Process Logic
335: --
336: l_object_version_number := p_object_version_number;
384: -- End of API User Hook for the after hook of delete_special_attribute
385: --
386: end;
387: --
388: hr_utility.set_location(l_proc, 60);
389: --
390: -- When in validation only mode raise the Validate_Enabled exception
391: --
392: if p_validate then
392: if p_validate then
393: raise hr_api.validate_enabled;
394: end if;
395: --
396: hr_utility.set_location(' Leaving:'||l_proc, 70);
397: --
398: exception
399: --
400: when hr_api.validate_enabled then
434: l_proc varchar2(72) := g_package||'lck';
435: --
436: begin
437: --
438: hr_utility.set_location('Entering:'|| l_proc, 10);
439: --
440: pqh_sat_shd.lck
441: (
442: p_special_attribute_id => p_special_attribute_id
442: p_special_attribute_id => p_special_attribute_id
443: ,p_object_version_number => p_object_version_number
444: );
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 70);
447: --
448: end lck;
449: --
450: --