20: ,p_description in varchar2 default null
21: ,p_prompt in varchar2 default null
22: ,p_timecard_field in varchar2
23: ,p_object_version_number out nocopy number
24: ,p_language_code in varchar2 default hr_api.userenv_lang
25: ,p_alias_type_id in number
26: ) is
27: --
28: -- Declare cursors and local variables
51: -- to functions instead of p_language_code from now on, to allow
52: -- an IN OUT parameter to be passed through.
53: --
54: l_language_code := p_language_code;
55: hr_api.validate_language_code(p_language_code => l_language_code);
56: --
57: --
58: -- Call Before Process User Hook
59: --
73: ,p_language_code => l_language_code
74: ,p_alias_type_id => p_alias_type_id
75: );
76: exception
77: when hr_api.cannot_find_prog_unit then
78: hr_api.cannot_find_prog_unit_error
79: (p_module_name => 'create_alias_definition'
80: ,p_hook_type => 'BP'
81: );
74: ,p_alias_type_id => p_alias_type_id
75: );
76: exception
77: when hr_api.cannot_find_prog_unit then
78: hr_api.cannot_find_prog_unit_error
79: (p_module_name => 'create_alias_definition'
80: ,p_hook_type => 'BP'
81: );
82: end;
143: ,p_language_code => l_language_code
144: ,p_alias_type_id => p_alias_type_id
145: );
146: exception
147: when hr_api.cannot_find_prog_unit then
148: hr_api.cannot_find_prog_unit_error
149: (p_module_name => 'create_alias_definition'
150: ,p_hook_type => 'AP'
151: );
144: ,p_alias_type_id => p_alias_type_id
145: );
146: exception
147: when hr_api.cannot_find_prog_unit then
148: hr_api.cannot_find_prog_unit_error
149: (p_module_name => 'create_alias_definition'
150: ,p_hook_type => 'AP'
151: );
152: end;
153: --
154: -- When in validation only mode raise the Validate_Enabled exception
155: --
156: if p_validate then
157: raise hr_api.validate_enabled;
158: end if;
159: --
160: -- Set all output arguments
161: --
165: if g_debug then
166: hr_utility.set_location(' Leaving:'||l_proc, 70);
167: end if;
168: exception
169: when hr_api.validate_enabled then
170: --
171: -- As the Validate_Enabled exception has been raised
172: -- we must rollback to the savepoint
173: --
208: ,p_description in varchar2 default null
209: ,p_prompt in varchar2 default null
210: ,p_timecard_field in varchar2
211: ,p_object_version_number in out nocopy number
212: ,p_language_code in varchar2 default hr_api.userenv_lang
213: ,p_alias_type_id in number
214: ) is
215: --
216: -- Declare cursors and local variables
238: -- to functions instead of p_language_code from now on, to allow
239: -- an IN OUT parameter to be passed through.
240: --
241: l_language_code := p_language_code;
242: hr_api.validate_language_code(p_language_code => l_language_code);
243: --
244:
245: --
246: -- Call Before Process User Hook
263: ,p_language_code => l_language_code
264: ,p_alias_type_id => p_alias_type_id
265: );
266: exception
267: when hr_api.cannot_find_prog_unit then
268: hr_api.cannot_find_prog_unit_error
269: (p_module_name => 'update_alias_definition'
270: ,p_hook_type => 'BP'
271: );
264: ,p_alias_type_id => p_alias_type_id
265: );
266: exception
267: when hr_api.cannot_find_prog_unit then
268: hr_api.cannot_find_prog_unit_error
269: (p_module_name => 'update_alias_definition'
270: ,p_hook_type => 'BP'
271: );
272: end;
333: ,p_language_code => l_language_code
334: ,p_alias_type_id => p_alias_type_id
335: );
336: exception
337: when hr_api.cannot_find_prog_unit then
338: hr_api.cannot_find_prog_unit_error
339: (p_module_name => 'update_alias_definition'
340: ,p_hook_type => 'AP'
341: );
334: ,p_alias_type_id => p_alias_type_id
335: );
336: exception
337: when hr_api.cannot_find_prog_unit then
338: hr_api.cannot_find_prog_unit_error
339: (p_module_name => 'update_alias_definition'
340: ,p_hook_type => 'AP'
341: );
342: end;
343: --
344: -- When in validation only mode raise the Validate_Enabled exception
345: --
346: if p_validate then
347: raise hr_api.validate_enabled;
348: end if;
349: --
350: -- Set all output arguments
351: --
355: if g_debug then
356: hr_utility.set_location(' Leaving:'||l_proc, 70);
357: end if;
358: exception
359: when hr_api.validate_enabled then
360: --
361: -- As the Validate_Enabled exception has been raised
362: -- we must rollback to the savepoint
363: --
424: (p_alias_definition_id => p_alias_definition_id
425: ,p_object_version_number => p_object_version_number
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'delete_alias_definition'
431: ,p_hook_type => 'BP'
432: );
425: ,p_object_version_number => p_object_version_number
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'delete_alias_definition'
431: ,p_hook_type => 'BP'
432: );
433: end;
470: (p_alias_definition_id => p_alias_definition_id
471: ,p_object_version_number => p_object_version_number
472: );
473: exception
474: when hr_api.cannot_find_prog_unit then
475: hr_api.cannot_find_prog_unit_error
476: (p_module_name => 'delete_alias_definition'
477: ,p_hook_type => 'AP'
478: );
471: ,p_object_version_number => p_object_version_number
472: );
473: exception
474: when hr_api.cannot_find_prog_unit then
475: hr_api.cannot_find_prog_unit_error
476: (p_module_name => 'delete_alias_definition'
477: ,p_hook_type => 'AP'
478: );
479: end;
480: --
481: -- When in validation only mode raise the Validate_Enabled exception
482: --
483: if p_validate then
484: raise hr_api.validate_enabled;
485: end if;
486: --
487: -- Set all output arguments
488: --
490: if g_debug then
491: hr_utility.set_location(' Leaving:'||l_proc, 70);
492: end if;
493: exception
494: when hr_api.validate_enabled then
495: --
496: -- As the Validate_Enabled exception has been raised
497: -- we must rollback to the savepoint
498: --