58: ,p_definition => p_definition
59: ,p_description => p_description
60: );
61: exception
62: when hr_api.cannot_find_prog_unit then
63: hr_api.cannot_find_prog_unit_error
64: (p_module_name => 'CREATE_FUNCTION'
65: ,p_hook_type => 'BP'
66: );
59: ,p_description => p_description
60: );
61: exception
62: when hr_api.cannot_find_prog_unit then
63: hr_api.cannot_find_prog_unit_error
64: (p_module_name => 'CREATE_FUNCTION'
65: ,p_hook_type => 'BP'
66: );
67: end;
106: ,p_function_id => l_function_id
107: ,p_object_version_number => l_object_version_number
108: );
109: exception
110: when hr_api.cannot_find_prog_unit then
111: hr_api.cannot_find_prog_unit_error
112: (p_module_name => 'CREATE_FUNCTION'
113: ,p_hook_type => 'AP'
114: );
107: ,p_object_version_number => l_object_version_number
108: );
109: exception
110: when hr_api.cannot_find_prog_unit then
111: hr_api.cannot_find_prog_unit_error
112: (p_module_name => 'CREATE_FUNCTION'
113: ,p_hook_type => 'AP'
114: );
115: end;
116: --
117: -- When in validation only mode raise the Validate_Enabled exception
118: --
119: if p_validate then
120: raise hr_api.validate_enabled;
121: end if;
122: --
123: -- Set all IN OUT and OUT parameters with out values
124: --
126: p_object_version_number := l_object_version_number;
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 70);
129: exception
130: when hr_api.validate_enabled then
131: --
132: -- As the Validate_Enabled exception has been raised
133: -- we must rollback to the savepoint
134: --
167: (p_validate in boolean default false
168: ,p_effective_date in date
169: ,p_function_id in number
170: ,p_object_version_number in out nocopy number
171: ,p_name in varchar2 default hr_api.g_varchar2
172: ,p_class in varchar2 default hr_api.g_varchar2
173: ,p_alias_name in varchar2 default hr_api.g_varchar2
174: ,p_data_type in varchar2 default hr_api.g_varchar2
175: ,p_definition in varchar2 default hr_api.g_varchar2
168: ,p_effective_date in date
169: ,p_function_id in number
170: ,p_object_version_number in out nocopy number
171: ,p_name in varchar2 default hr_api.g_varchar2
172: ,p_class in varchar2 default hr_api.g_varchar2
173: ,p_alias_name in varchar2 default hr_api.g_varchar2
174: ,p_data_type in varchar2 default hr_api.g_varchar2
175: ,p_definition in varchar2 default hr_api.g_varchar2
176: ,p_description in varchar2 default hr_api.g_varchar2
169: ,p_function_id in number
170: ,p_object_version_number in out nocopy number
171: ,p_name in varchar2 default hr_api.g_varchar2
172: ,p_class in varchar2 default hr_api.g_varchar2
173: ,p_alias_name in varchar2 default hr_api.g_varchar2
174: ,p_data_type in varchar2 default hr_api.g_varchar2
175: ,p_definition in varchar2 default hr_api.g_varchar2
176: ,p_description in varchar2 default hr_api.g_varchar2
177: ) is
170: ,p_object_version_number in out nocopy number
171: ,p_name in varchar2 default hr_api.g_varchar2
172: ,p_class in varchar2 default hr_api.g_varchar2
173: ,p_alias_name in varchar2 default hr_api.g_varchar2
174: ,p_data_type in varchar2 default hr_api.g_varchar2
175: ,p_definition in varchar2 default hr_api.g_varchar2
176: ,p_description in varchar2 default hr_api.g_varchar2
177: ) is
178: --
171: ,p_name in varchar2 default hr_api.g_varchar2
172: ,p_class in varchar2 default hr_api.g_varchar2
173: ,p_alias_name in varchar2 default hr_api.g_varchar2
174: ,p_data_type in varchar2 default hr_api.g_varchar2
175: ,p_definition in varchar2 default hr_api.g_varchar2
176: ,p_description in varchar2 default hr_api.g_varchar2
177: ) is
178: --
179: -- Declare cursors and local variables
172: ,p_class in varchar2 default hr_api.g_varchar2
173: ,p_alias_name in varchar2 default hr_api.g_varchar2
174: ,p_data_type in varchar2 default hr_api.g_varchar2
175: ,p_definition in varchar2 default hr_api.g_varchar2
176: ,p_description in varchar2 default hr_api.g_varchar2
177: ) is
178: --
179: -- Declare cursors and local variables
180: --
212: ,p_definition => p_definition
213: ,p_description => p_description
214: );
215: exception
216: when hr_api.cannot_find_prog_unit then
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'UPDATE_FUNCTION'
219: ,p_hook_type => 'BP'
220: );
213: ,p_description => p_description
214: );
215: exception
216: when hr_api.cannot_find_prog_unit then
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'UPDATE_FUNCTION'
219: ,p_hook_type => 'BP'
220: );
221: end;
233: ,p_function_id => p_function_id
234: ,p_object_version_number => l_object_version_number
235: ,p_name => p_name
236: ,p_class => p_class
237: -- ,p_business_group_id => hr_api.g_number
238: -- ,p_legislation_code => hr_api.g_varchar2
239: ,p_alias_name => p_alias_name
240: ,p_data_type => p_data_type
241: ,p_definition => p_definition
234: ,p_object_version_number => l_object_version_number
235: ,p_name => p_name
236: ,p_class => p_class
237: -- ,p_business_group_id => hr_api.g_number
238: -- ,p_legislation_code => hr_api.g_varchar2
239: ,p_alias_name => p_alias_name
240: ,p_data_type => p_data_type
241: ,p_definition => p_definition
242: ,p_description => p_description
258: ,p_definition => p_definition
259: ,p_description => p_description
260: );
261: exception
262: when hr_api.cannot_find_prog_unit then
263: hr_api.cannot_find_prog_unit_error
264: (p_module_name => 'UPDATE_FUNCTION'
265: ,p_hook_type => 'AP'
266: );
259: ,p_description => p_description
260: );
261: exception
262: when hr_api.cannot_find_prog_unit then
263: hr_api.cannot_find_prog_unit_error
264: (p_module_name => 'UPDATE_FUNCTION'
265: ,p_hook_type => 'AP'
266: );
267: end;
268: --
269: -- When in validation only mode raise the Validate_Enabled exception
270: --
271: if p_validate then
272: raise hr_api.validate_enabled;
273: end if;
274: --
275: -- Set all IN OUT and OUT parameters with out values
276: --
277: p_object_version_number := l_object_version_number;
278: --
279: hr_utility.set_location(' Leaving:'||l_proc, 70);
280: exception
281: when hr_api.validate_enabled then
282: --
283: -- As the Validate_Enabled exception has been raised
284: -- we must rollback to the savepoint
285: --
361: ( p_function_id => p_function_id
362: ,p_object_version_number => p_object_version_number
363: );
364: exception
365: when hr_api.cannot_find_prog_unit then
366: hr_api.cannot_find_prog_unit_error
367: (p_module_name => 'DELETE_FUNCTION'
368: ,p_hook_type => 'BP'
369: );
362: ,p_object_version_number => p_object_version_number
363: );
364: exception
365: when hr_api.cannot_find_prog_unit then
366: hr_api.cannot_find_prog_unit_error
367: (p_module_name => 'DELETE_FUNCTION'
368: ,p_hook_type => 'BP'
369: );
370: end;
423: ( p_function_id => p_function_id
424: ,p_object_version_number => p_object_version_number
425: );
426: exception
427: when hr_api.cannot_find_prog_unit then
428: hr_api.cannot_find_prog_unit_error
429: (p_module_name => 'DELETE_FUNCTION'
430: ,p_hook_type => 'AP'
431: );
424: ,p_object_version_number => p_object_version_number
425: );
426: exception
427: when hr_api.cannot_find_prog_unit then
428: hr_api.cannot_find_prog_unit_error
429: (p_module_name => 'DELETE_FUNCTION'
430: ,p_hook_type => 'AP'
431: );
432: end;
433: --
434: -- When in validation only mode raise the Validate_Enabled exception
435: --
436: if p_validate then
437: raise hr_api.validate_enabled;
438: end if;
439: --
440: -- Set all IN OUT and OUT parameters with out values
441: --
441: --
442: --
443: hr_utility.set_location(' Leaving:'||l_proc, 70);
444: exception
445: when hr_api.validate_enabled then
446: --
447: -- As the Validate_Enabled exception has been raised
448: -- we must rollback to the savepoint
449: --