26: l_language_code varchar2(30);
27: l_object_version_number number;
28:
29: begin
30: hr_utility.set_location('Entering:'|| l_proc, 10);
31: --
32: -- Issue a savepoint
33: --
34: savepoint create_option_type;
107: p_option_type_id := l_option_type_id;
108: p_object_version_number := l_object_version_number;
109:
110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 70);
112: exception
113: when hr_api.validate_enabled then
114: --
115: -- As the Validate_Enabled exception has been raised
124:
125: p_option_type_id := null;
126: p_object_version_number := null;
127:
128: hr_utility.set_location(' Leaving:'||l_proc, 80);
129: when others then
130: --
131: -- A validation or unexpected error has occured
132: --
138:
139: p_option_type_id := null;
140: p_object_version_number := null;
141:
142: hr_utility.set_location(' Leaving:'||l_proc, 90);
143: raise;
144: end create_option_type;
145: --
146: --
163: l_language_code varchar2(30);
164: l_object_version_number number := p_object_version_number;
165:
166: begin
167: hr_utility.set_location('Entering:'|| l_proc, 10);
168: --
169: -- Issue a savepoint
170: --
171: savepoint update_option_type;
243: -- Set all IN OUT and OUT parameters with out values
244: --
245:
246: --
247: hr_utility.set_location(' Leaving:'||l_proc, 70);
248: exception
249: when hr_api.validate_enabled then
250: --
251: -- As the Validate_Enabled exception has been raised
259: --
260:
261: p_object_version_number := l_object_version_number;
262:
263: hr_utility.set_location(' Leaving:'||l_proc, 80);
264: when others then
265: --
266: -- A validation or unexpected error has occured
267: --
272: --
273:
274: p_object_version_number := l_object_version_number;
275:
276: hr_utility.set_location(' Leaving:'||l_proc, 90);
277: raise;
278: end update_option_type;
279: --
280: --
293: --
294: l_proc varchar2(72) := g_package||'delete_option_type';
295:
296: begin
297: hr_utility.set_location('Entering:'|| l_proc, 10);
298: --
299: -- Issue a savepoint
300: --
301: savepoint delete_option_type;
364: -- Set all IN OUT and OUT parameters with out values
365: --
366:
367: --
368: hr_utility.set_location(' Leaving:'||l_proc, 70);
369: exception
370: when hr_api.validate_enabled then
371: --
372: -- As the Validate_Enabled exception has been raised
378: -- (Any key or derived arguments must be set to null
379: -- when validation only mode is being used.)
380: --
381:
382: hr_utility.set_location(' Leaving:'||l_proc, 80);
383: when others then
384: --
385: -- A validation or unexpected error has occured
386: --
388: --
389: -- Reset IN OUT parameters and set all
390: -- OUT parameters, including warnings, to null
391: --
392: hr_utility.set_location(' Leaving:'||l_proc, 90);
393: raise;
394: end delete_option_type;
395: end HR_KI_OPTION_TYPES_API;