10: -- ----------------------------------------------------------------------------
11: --
12: procedure create_option_type
13: (p_validate in boolean default false
14: ,p_language_code in varchar2 default hr_api.userenv_lang
15: ,p_option_type_key in varchar2
16: ,p_display_type in varchar2
17: ,p_option_name in varchar2
18: ,p_option_type_id out nocopy number
37: --
38: --l_in_out_parameter := p_in_out_parameter;
39: l_language_code:=p_language_code;
40:
41: hr_api.validate_language_code(p_language_code => l_language_code);
42:
43: --
44: -- Call Before Process User Hook
45: --
50: ,p_display_type => p_display_type
51: ,p_option_name => p_option_name
52: );
53: exception
54: when hr_api.cannot_find_prog_unit then
55: hr_api.cannot_find_prog_unit_error
56: (p_module_name => 'create_option_type'
57: ,p_hook_type => 'BP'
58: );
51: ,p_option_name => p_option_name
52: );
53: exception
54: when hr_api.cannot_find_prog_unit then
55: hr_api.cannot_find_prog_unit_error
56: (p_module_name => 'create_option_type'
57: ,p_hook_type => 'BP'
58: );
59: end;
88: ,p_option_type_id => l_option_type_id
89: ,p_object_version_number => l_object_version_number
90: );
91: exception
92: when hr_api.cannot_find_prog_unit then
93: hr_api.cannot_find_prog_unit_error
94: (p_module_name => 'create_option_type'
95: ,p_hook_type => 'AP'
96: );
89: ,p_object_version_number => l_object_version_number
90: );
91: exception
92: when hr_api.cannot_find_prog_unit then
93: hr_api.cannot_find_prog_unit_error
94: (p_module_name => 'create_option_type'
95: ,p_hook_type => 'AP'
96: );
97: end;
98: --
99: -- When in validation only mode raise the Validate_Enabled exception
100: --
101: if p_validate then
102: raise hr_api.validate_enabled;
103: end if;
104: --
105: -- Set all IN OUT and OUT parameters with out values
106: --
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
116: -- we must rollback to the savepoint
117: --
149: -- ----------------------------------------------------------------------------
150: --
151: procedure update_option_type
152: (p_validate in boolean default false
153: ,p_language_code in varchar2 default hr_api.userenv_lang
154: ,p_display_type in varchar2 default hr_api.g_varchar2
155: ,p_option_name in varchar2 default hr_api.g_varchar2
156: ,p_option_type_id in number
157: ,p_object_version_number in out nocopy number
150: --
151: procedure update_option_type
152: (p_validate in boolean default false
153: ,p_language_code in varchar2 default hr_api.userenv_lang
154: ,p_display_type in varchar2 default hr_api.g_varchar2
155: ,p_option_name in varchar2 default hr_api.g_varchar2
156: ,p_option_type_id in number
157: ,p_object_version_number in out nocopy number
158: ) is
151: procedure update_option_type
152: (p_validate in boolean default false
153: ,p_language_code in varchar2 default hr_api.userenv_lang
154: ,p_display_type in varchar2 default hr_api.g_varchar2
155: ,p_option_name in varchar2 default hr_api.g_varchar2
156: ,p_option_type_id in number
157: ,p_object_version_number in out nocopy number
158: ) is
159: --
174: --
175: --l_in_out_parameter := p_in_out_parameter;
176: l_language_code:=p_language_code;
177:
178: hr_api.validate_language_code(p_language_code => l_language_code);
179:
180: --
181: -- Call Before Process User Hook
182: --
189: ,p_object_version_number => p_object_version_number
190:
191: );
192: exception
193: when hr_api.cannot_find_prog_unit then
194: hr_api.cannot_find_prog_unit_error
195: (p_module_name => 'update_option_type'
196: ,p_hook_type => 'BP'
197: );
190:
191: );
192: exception
193: when hr_api.cannot_find_prog_unit then
194: hr_api.cannot_find_prog_unit_error
195: (p_module_name => 'update_option_type'
196: ,p_hook_type => 'BP'
197: );
198: end;
226: ,p_option_type_id => p_option_type_id
227: ,p_object_version_number => p_object_version_number
228: );
229: exception
230: when hr_api.cannot_find_prog_unit then
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'update_option_type'
233: ,p_hook_type => 'AP'
234: );
227: ,p_object_version_number => p_object_version_number
228: );
229: exception
230: when hr_api.cannot_find_prog_unit then
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'update_option_type'
233: ,p_hook_type => 'AP'
234: );
235: end;
236: --
237: -- When in validation only mode raise the Validate_Enabled exception
238: --
239: if p_validate then
240: raise hr_api.validate_enabled;
241: end if;
242: --
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
252: -- we must rollback to the savepoint
253: --
312: ,p_object_version_number => p_object_version_number
313:
314: );
315: exception
316: when hr_api.cannot_find_prog_unit then
317: hr_api.cannot_find_prog_unit_error
318: (p_module_name => 'delete_option_type'
319: ,p_hook_type => 'BP'
320: );
313:
314: );
315: exception
316: when hr_api.cannot_find_prog_unit then
317: hr_api.cannot_find_prog_unit_error
318: (p_module_name => 'delete_option_type'
319: ,p_hook_type => 'BP'
320: );
321: end;
347: p_option_type_id => p_option_type_id
348: ,p_object_version_number => p_object_version_number
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'delete_option_type'
354: ,p_hook_type => 'AP'
355: );
348: ,p_object_version_number => p_object_version_number
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'delete_option_type'
354: ,p_hook_type => 'AP'
355: );
356: end;
357: --
358: -- When in validation only mode raise the Validate_Enabled exception
359: --
360: if p_validate then
361: raise hr_api.validate_enabled;
362: end if;
363: --
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
373: -- we must rollback to the savepoint
374: --