49: ,p_attribute28 in varchar2 default null
50: ,p_attribute29 in varchar2 default null
51: ,p_attribute30 in varchar2 default null
52: ,p_object_version_number out nocopy number
53: ,p_language_code in varchar2 default hr_api.userenv_lang
54: ) is
55: --
56: -- Declare cursors and local variables
57: --
79: -- to functions instead of p_language_code from now on, to allow
80: -- an IN OUT parameter to be passed through.
81: --
82: l_language_code := p_language_code;
83: hr_api.validate_language_code(p_language_code => l_language_code);
84: --
85: --
86: -- Call Before Process User Hook
87: --
125: ,p_attribute30 => p_attribute30
126: ,p_language_code => l_language_code
127: );
128: exception
129: when hr_api.cannot_find_prog_unit then
130: hr_api.cannot_find_prog_unit_error
131: (p_module_name => 'create_alias_value'
132: ,p_hook_type => 'BP'
133: );
126: ,p_language_code => l_language_code
127: );
128: exception
129: when hr_api.cannot_find_prog_unit then
130: hr_api.cannot_find_prog_unit_error
131: (p_module_name => 'create_alias_value'
132: ,p_hook_type => 'BP'
133: );
134: end;
242: ,p_object_version_number => l_object_version_number
243: ,p_language_code => l_language_code
244: );
245: exception
246: when hr_api.cannot_find_prog_unit then
247: hr_api.cannot_find_prog_unit_error
248: (p_module_name => 'create_alias_value'
249: ,p_hook_type => 'AP'
250: );
243: ,p_language_code => l_language_code
244: );
245: exception
246: when hr_api.cannot_find_prog_unit then
247: hr_api.cannot_find_prog_unit_error
248: (p_module_name => 'create_alias_value'
249: ,p_hook_type => 'AP'
250: );
251: end;
252: --
253: -- When in validation only mode raise the Validate_Enabled exception
254: --
255: if p_validate then
256: raise hr_api.validate_enabled;
257: end if;
258: --
259: -- Set all output arguments
260: --
264: if g_debug then
265: hr_utility.set_location(' Leaving:'||l_proc, 70);
266: end if;
267: exception
268: when hr_api.validate_enabled then
269: --
270: -- As the Validate_Enabled exception has been raised
271: -- we must rollback to the savepoint
272: --
335: ,p_attribute28 in varchar2 default null
336: ,p_attribute29 in varchar2 default null
337: ,p_attribute30 in varchar2 default null
338: ,p_object_version_number in out nocopy number
339: ,p_language_code in varchar2 default hr_api.userenv_lang
340: ) is
341: --
342: -- Declare cursors and local variables
343: --
364: -- to functions instead of p_language_code from now on, to allow
365: -- an IN OUT parameter to be passed through.
366: --
367: l_language_code := p_language_code;
368: hr_api.validate_language_code(p_language_code => l_language_code);
369: --
370:
371: --
372: -- Call Before Process User Hook
413: ,p_object_version_number => p_object_version_number
414: ,p_language_code => l_language_code
415: );
416: exception
417: when hr_api.cannot_find_prog_unit then
418: hr_api.cannot_find_prog_unit_error
419: (p_module_name => 'update_alias_value'
420: ,p_hook_type => 'BP'
421: );
414: ,p_language_code => l_language_code
415: );
416: exception
417: when hr_api.cannot_find_prog_unit then
418: hr_api.cannot_find_prog_unit_error
419: (p_module_name => 'update_alias_value'
420: ,p_hook_type => 'BP'
421: );
422: end;
530: ,p_object_version_number => l_object_version_number
531: ,p_language_code => l_language_code
532: );
533: exception
534: when hr_api.cannot_find_prog_unit then
535: hr_api.cannot_find_prog_unit_error
536: (p_module_name => 'update_alias_value'
537: ,p_hook_type => 'AP'
538: );
531: ,p_language_code => l_language_code
532: );
533: exception
534: when hr_api.cannot_find_prog_unit then
535: hr_api.cannot_find_prog_unit_error
536: (p_module_name => 'update_alias_value'
537: ,p_hook_type => 'AP'
538: );
539: end;
540: --
541: -- When in validation only mode raise the Validate_Enabled exception
542: --
543: if p_validate then
544: raise hr_api.validate_enabled;
545: end if;
546: --
547: -- Set all output arguments
548: --
551: if g_debug then
552: hr_utility.set_location(' Leaving:'||l_proc, 70);
553: end if;
554: exception
555: when hr_api.validate_enabled then
556: --
557: -- As the Validate_Enabled exception has been raised
558: -- we must rollback to the savepoint
559: --
619: (p_alias_value_id => p_alias_value_id
620: ,p_object_version_number => p_object_version_number
621: );
622: exception
623: when hr_api.cannot_find_prog_unit then
624: hr_api.cannot_find_prog_unit_error
625: (p_module_name => 'delete_alias_value'
626: ,p_hook_type => 'BP'
627: );
620: ,p_object_version_number => p_object_version_number
621: );
622: exception
623: when hr_api.cannot_find_prog_unit then
624: hr_api.cannot_find_prog_unit_error
625: (p_module_name => 'delete_alias_value'
626: ,p_hook_type => 'BP'
627: );
628: end;
668: (p_alias_value_id => p_alias_value_id
669: ,p_object_version_number => p_object_version_number
670: );
671: exception
672: when hr_api.cannot_find_prog_unit then
673: hr_api.cannot_find_prog_unit_error
674: (p_module_name => 'delete_alias_value'
675: ,p_hook_type => 'AP'
676: );
669: ,p_object_version_number => p_object_version_number
670: );
671: exception
672: when hr_api.cannot_find_prog_unit then
673: hr_api.cannot_find_prog_unit_error
674: (p_module_name => 'delete_alias_value'
675: ,p_hook_type => 'AP'
676: );
677: end;
678: --
679: -- When in validation only mode raise the Validate_Enabled exception
680: --
681: if p_validate then
682: raise hr_api.validate_enabled;
683: end if;
684: --
685: -- Set all output arguments
686: --
688: if g_debug then
689: hr_utility.set_location(' Leaving:'||l_proc, 70);
690: end if;
691: exception
692: when hr_api.validate_enabled then
693: --
694: -- As the Validate_Enabled exception has been raised
695: -- we must rollback to the savepoint
696: --