20: ,p_enable_flag in varchar2 default null
21: ,p_width in number default null
22: ,p_object_version_number out nocopy number
23: ,p_effective_date in date
24: ,p_language_code in varchar2 default hr_api.userenv_lang
25: ,p_region_itemname in varchar2 default null
26: ,p_attribute_itemname in varchar2 default null
27: ,p_decode_function_name in varchar2 default null
28: ) is
63: ,p_attribute_itemname => p_attribute_itemname
64: ,p_decode_function_name => p_decode_function_name
65: );
66: exception
67: when hr_api.cannot_find_prog_unit then
68: hr_api.cannot_find_prog_unit_error
69: (
70: p_module_name => 'CREATE_ATTRIBUTE'
71: ,p_hook_type => 'BP'
64: ,p_decode_function_name => p_decode_function_name
65: );
66: exception
67: when hr_api.cannot_find_prog_unit then
68: hr_api.cannot_find_prog_unit_error
69: (
70: p_module_name => 'CREATE_ATTRIBUTE'
71: ,p_hook_type => 'BP'
72: );
119: ,p_attribute_itemname => p_attribute_itemname
120: ,p_decode_function_name => p_decode_function_name
121: );
122: exception
123: when hr_api.cannot_find_prog_unit then
124: hr_api.cannot_find_prog_unit_error
125: (p_module_name => 'CREATE_ATTRIBUTE'
126: ,p_hook_type => 'AP'
127: );
120: ,p_decode_function_name => p_decode_function_name
121: );
122: exception
123: when hr_api.cannot_find_prog_unit then
124: hr_api.cannot_find_prog_unit_error
125: (p_module_name => 'CREATE_ATTRIBUTE'
126: ,p_hook_type => 'AP'
127: );
128: --
134: --
135: -- When in validation only mode raise the Validate_Enabled exception
136: --
137: if p_validate then
138: raise hr_api.validate_enabled;
139: end if;
140: --
141: -- Set all output arguments
142: --
146: hr_utility.set_location(' Leaving:'||l_proc, 70);
147: --
148: exception
149: --
150: when hr_api.validate_enabled then
151: --
152: -- As the Validate_Enabled exception has been raised
153: -- we must rollback to the savepoint
154: --
178: --
179: procedure update_ATTRIBUTE
180: (p_validate in boolean default false
181: ,p_attribute_id in number
182: ,p_attribute_name in varchar2 default hr_api.g_varchar2
183: ,p_master_attribute_id in number default hr_api.g_number
184: ,p_master_table_route_id in number default hr_api.g_number
185: ,p_column_name in varchar2 default hr_api.g_varchar2
186: ,p_column_type in varchar2 default hr_api.g_varchar2
179: procedure update_ATTRIBUTE
180: (p_validate in boolean default false
181: ,p_attribute_id in number
182: ,p_attribute_name in varchar2 default hr_api.g_varchar2
183: ,p_master_attribute_id in number default hr_api.g_number
184: ,p_master_table_route_id in number default hr_api.g_number
185: ,p_column_name in varchar2 default hr_api.g_varchar2
186: ,p_column_type in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
180: (p_validate in boolean default false
181: ,p_attribute_id in number
182: ,p_attribute_name in varchar2 default hr_api.g_varchar2
183: ,p_master_attribute_id in number default hr_api.g_number
184: ,p_master_table_route_id in number default hr_api.g_number
185: ,p_column_name in varchar2 default hr_api.g_varchar2
186: ,p_column_type in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_width in number default hr_api.g_number
181: ,p_attribute_id in number
182: ,p_attribute_name in varchar2 default hr_api.g_varchar2
183: ,p_master_attribute_id in number default hr_api.g_number
184: ,p_master_table_route_id in number default hr_api.g_number
185: ,p_column_name in varchar2 default hr_api.g_varchar2
186: ,p_column_type in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_width in number default hr_api.g_number
189: ,p_object_version_number in out nocopy number
182: ,p_attribute_name in varchar2 default hr_api.g_varchar2
183: ,p_master_attribute_id in number default hr_api.g_number
184: ,p_master_table_route_id in number default hr_api.g_number
185: ,p_column_name in varchar2 default hr_api.g_varchar2
186: ,p_column_type in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_width in number default hr_api.g_number
189: ,p_object_version_number in out nocopy number
190: ,p_effective_date in date
183: ,p_master_attribute_id in number default hr_api.g_number
184: ,p_master_table_route_id in number default hr_api.g_number
185: ,p_column_name in varchar2 default hr_api.g_varchar2
186: ,p_column_type in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_width in number default hr_api.g_number
189: ,p_object_version_number in out nocopy number
190: ,p_effective_date in date
191: ,p_language_code in varchar2 default hr_api.userenv_lang
184: ,p_master_table_route_id in number default hr_api.g_number
185: ,p_column_name in varchar2 default hr_api.g_varchar2
186: ,p_column_type in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_width in number default hr_api.g_number
189: ,p_object_version_number in out nocopy number
190: ,p_effective_date in date
191: ,p_language_code in varchar2 default hr_api.userenv_lang
192: ,p_region_itemname in varchar2 default hr_api.g_varchar2
187: ,p_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_width in number default hr_api.g_number
189: ,p_object_version_number in out nocopy number
190: ,p_effective_date in date
191: ,p_language_code in varchar2 default hr_api.userenv_lang
192: ,p_region_itemname in varchar2 default hr_api.g_varchar2
193: ,p_attribute_itemname in varchar2 default hr_api.g_varchar2
194: ,p_decode_function_name in varchar2 default hr_api.g_varchar2
195: ) is
188: ,p_width in number default hr_api.g_number
189: ,p_object_version_number in out nocopy number
190: ,p_effective_date in date
191: ,p_language_code in varchar2 default hr_api.userenv_lang
192: ,p_region_itemname in varchar2 default hr_api.g_varchar2
193: ,p_attribute_itemname in varchar2 default hr_api.g_varchar2
194: ,p_decode_function_name in varchar2 default hr_api.g_varchar2
195: ) is
196: --
189: ,p_object_version_number in out nocopy number
190: ,p_effective_date in date
191: ,p_language_code in varchar2 default hr_api.userenv_lang
192: ,p_region_itemname in varchar2 default hr_api.g_varchar2
193: ,p_attribute_itemname in varchar2 default hr_api.g_varchar2
194: ,p_decode_function_name in varchar2 default hr_api.g_varchar2
195: ) is
196: --
197: -- Declare cursors and local variables
190: ,p_effective_date in date
191: ,p_language_code in varchar2 default hr_api.userenv_lang
192: ,p_region_itemname in varchar2 default hr_api.g_varchar2
193: ,p_attribute_itemname in varchar2 default hr_api.g_varchar2
194: ,p_decode_function_name in varchar2 default hr_api.g_varchar2
195: ) is
196: --
197: -- Declare cursors and local variables
198: --
233: ,p_attribute_itemname => p_attribute_itemname
234: ,p_decode_function_name => p_decode_function_name
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'UPDATE_ATTRIBUTE'
240: ,p_hook_type => 'BP'
241: );
234: ,p_decode_function_name => p_decode_function_name
235: );
236: exception
237: when hr_api.cannot_find_prog_unit then
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'UPDATE_ATTRIBUTE'
240: ,p_hook_type => 'BP'
241: );
242: --
288: ,p_attribute_itemname => p_attribute_itemname
289: ,p_decode_function_name => p_decode_function_name
290: );
291: exception
292: when hr_api.cannot_find_prog_unit then
293: hr_api.cannot_find_prog_unit_error
294: (p_module_name => 'UPDATE_ATTRIBUTE'
295: ,p_hook_type => 'AP'
296: );
289: ,p_decode_function_name => p_decode_function_name
290: );
291: exception
292: when hr_api.cannot_find_prog_unit then
293: hr_api.cannot_find_prog_unit_error
294: (p_module_name => 'UPDATE_ATTRIBUTE'
295: ,p_hook_type => 'AP'
296: );
297: --
303: --
304: -- When in validation only mode raise the Validate_Enabled exception
305: --
306: if p_validate then
307: raise hr_api.validate_enabled;
308: end if;
309: --
310: -- Set all output arguments
311: --
314: hr_utility.set_location(' Leaving:'||l_proc, 70);
315: --
316: exception
317: --
318: when hr_api.validate_enabled then
319: --
320: -- As the Validate_Enabled exception has been raised
321: -- we must rollback to the savepoint
322: --
378: ,p_object_version_number => p_object_version_number
379: ,p_effective_date => trunc(p_effective_date)
380: );
381: exception
382: when hr_api.cannot_find_prog_unit then
383: hr_api.cannot_find_prog_unit_error
384: (p_module_name => 'DELETE_ATTRIBUTE'
385: ,p_hook_type => 'BP'
386: );
379: ,p_effective_date => trunc(p_effective_date)
380: );
381: exception
382: when hr_api.cannot_find_prog_unit then
383: hr_api.cannot_find_prog_unit_error
384: (p_module_name => 'DELETE_ATTRIBUTE'
385: ,p_hook_type => 'BP'
386: );
387: --
419: ,p_object_version_number => l_object_version_number
420: ,p_effective_date => trunc(p_effective_date)
421: );
422: exception
423: when hr_api.cannot_find_prog_unit then
424: hr_api.cannot_find_prog_unit_error
425: (p_module_name => 'DELETE_ATTRIBUTE'
426: ,p_hook_type => 'AP'
427: );
420: ,p_effective_date => trunc(p_effective_date)
421: );
422: exception
423: when hr_api.cannot_find_prog_unit then
424: hr_api.cannot_find_prog_unit_error
425: (p_module_name => 'DELETE_ATTRIBUTE'
426: ,p_hook_type => 'AP'
427: );
428: --
434: --
435: -- When in validation only mode raise the Validate_Enabled exception
436: --
437: if p_validate then
438: raise hr_api.validate_enabled;
439: end if;
440: --
441: hr_utility.set_location(' Leaving:'||l_proc, 70);
442: --
441: hr_utility.set_location(' Leaving:'||l_proc, 70);
442: --
443: exception
444: --
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: --