58: ,p_context => p_context
59: ,p_effective_date => trunc(p_effective_date)
60: );
61: exception
62: when hr_api.cannot_find_prog_unit then
63: hr_api.cannot_find_prog_unit_error
64: (
65: p_module_name => 'create_special_attribute'
66: ,p_hook_type => 'BP'
59: ,p_effective_date => trunc(p_effective_date)
60: );
61: exception
62: when hr_api.cannot_find_prog_unit then
63: hr_api.cannot_find_prog_unit_error
64: (
65: p_module_name => 'create_special_attribute'
66: ,p_hook_type => 'BP'
67: );
103: ,p_context => p_context
104: ,p_effective_date => trunc(p_effective_date)
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'create_special_attribute'
110: ,p_hook_type => 'AP'
111: );
104: ,p_effective_date => trunc(p_effective_date)
105: );
106: exception
107: when hr_api.cannot_find_prog_unit then
108: hr_api.cannot_find_prog_unit_error
109: (p_module_name => 'create_special_attribute'
110: ,p_hook_type => 'AP'
111: );
112: --
118: --
119: -- When in validation only mode raise the Validate_Enabled exception
120: --
121: if p_validate then
122: raise hr_api.validate_enabled;
123: end if;
124: --
125: -- Set all output arguments
126: --
130: hr_utility.set_location(' Leaving:'||l_proc, 70);
131: --
132: exception
133: --
134: when hr_api.validate_enabled then
135: --
136: -- As the Validate_Enabled exception has been raised
137: -- we must rollback to the savepoint
138: --
162: --
163: procedure update_special_attribute
164: (p_validate in boolean default false
165: ,p_special_attribute_id in number
166: ,p_txn_category_attribute_id in number default hr_api.g_number
167: ,p_attribute_type_cd in varchar2 default hr_api.g_varchar2
168: ,p_key_attribute_type in varchar2 default hr_api.g_varchar2
169: ,p_enable_flag in varchar2 default hr_api.g_varchar2
170: ,p_flex_code in varchar2 default hr_api.g_varchar2
163: procedure update_special_attribute
164: (p_validate in boolean default false
165: ,p_special_attribute_id in number
166: ,p_txn_category_attribute_id in number default hr_api.g_number
167: ,p_attribute_type_cd in varchar2 default hr_api.g_varchar2
168: ,p_key_attribute_type in varchar2 default hr_api.g_varchar2
169: ,p_enable_flag in varchar2 default hr_api.g_varchar2
170: ,p_flex_code in varchar2 default hr_api.g_varchar2
171: ,p_object_version_number in out nocopy number
164: (p_validate in boolean default false
165: ,p_special_attribute_id in number
166: ,p_txn_category_attribute_id in number default hr_api.g_number
167: ,p_attribute_type_cd in varchar2 default hr_api.g_varchar2
168: ,p_key_attribute_type in varchar2 default hr_api.g_varchar2
169: ,p_enable_flag in varchar2 default hr_api.g_varchar2
170: ,p_flex_code in varchar2 default hr_api.g_varchar2
171: ,p_object_version_number in out nocopy number
172: ,p_ddf_column_name in varchar2 default hr_api.g_varchar2
165: ,p_special_attribute_id in number
166: ,p_txn_category_attribute_id in number default hr_api.g_number
167: ,p_attribute_type_cd in varchar2 default hr_api.g_varchar2
168: ,p_key_attribute_type in varchar2 default hr_api.g_varchar2
169: ,p_enable_flag in varchar2 default hr_api.g_varchar2
170: ,p_flex_code in varchar2 default hr_api.g_varchar2
171: ,p_object_version_number in out nocopy number
172: ,p_ddf_column_name in varchar2 default hr_api.g_varchar2
173: ,p_ddf_value_column_name in varchar2 default hr_api.g_varchar2
166: ,p_txn_category_attribute_id in number default hr_api.g_number
167: ,p_attribute_type_cd in varchar2 default hr_api.g_varchar2
168: ,p_key_attribute_type in varchar2 default hr_api.g_varchar2
169: ,p_enable_flag in varchar2 default hr_api.g_varchar2
170: ,p_flex_code in varchar2 default hr_api.g_varchar2
171: ,p_object_version_number in out nocopy number
172: ,p_ddf_column_name in varchar2 default hr_api.g_varchar2
173: ,p_ddf_value_column_name in varchar2 default hr_api.g_varchar2
174: ,p_context in varchar2 default hr_api.g_varchar2
168: ,p_key_attribute_type in varchar2 default hr_api.g_varchar2
169: ,p_enable_flag in varchar2 default hr_api.g_varchar2
170: ,p_flex_code in varchar2 default hr_api.g_varchar2
171: ,p_object_version_number in out nocopy number
172: ,p_ddf_column_name in varchar2 default hr_api.g_varchar2
173: ,p_ddf_value_column_name in varchar2 default hr_api.g_varchar2
174: ,p_context in varchar2 default hr_api.g_varchar2
175: ,p_effective_date in date
176: ) is
169: ,p_enable_flag in varchar2 default hr_api.g_varchar2
170: ,p_flex_code in varchar2 default hr_api.g_varchar2
171: ,p_object_version_number in out nocopy number
172: ,p_ddf_column_name in varchar2 default hr_api.g_varchar2
173: ,p_ddf_value_column_name in varchar2 default hr_api.g_varchar2
174: ,p_context in varchar2 default hr_api.g_varchar2
175: ,p_effective_date in date
176: ) is
177: --
170: ,p_flex_code in varchar2 default hr_api.g_varchar2
171: ,p_object_version_number in out nocopy number
172: ,p_ddf_column_name in varchar2 default hr_api.g_varchar2
173: ,p_ddf_value_column_name in varchar2 default hr_api.g_varchar2
174: ,p_context in varchar2 default hr_api.g_varchar2
175: ,p_effective_date in date
176: ) is
177: --
178: -- Declare cursors and local variables
212: ,p_context => p_context
213: ,p_effective_date => trunc(p_effective_date)
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_special_attribute'
219: ,p_hook_type => 'BP'
220: );
213: ,p_effective_date => trunc(p_effective_date)
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_special_attribute'
219: ,p_hook_type => 'BP'
220: );
221: --
256: ,p_context => p_context
257: ,p_effective_date => trunc(p_effective_date)
258: );
259: exception
260: when hr_api.cannot_find_prog_unit then
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'update_special_attribute'
263: ,p_hook_type => 'AP'
264: );
257: ,p_effective_date => trunc(p_effective_date)
258: );
259: exception
260: when hr_api.cannot_find_prog_unit then
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'update_special_attribute'
263: ,p_hook_type => 'AP'
264: );
265: --
271: --
272: -- When in validation only mode raise the Validate_Enabled exception
273: --
274: if p_validate then
275: raise hr_api.validate_enabled;
276: end if;
277: --
278: -- Set all output arguments
279: --
282: hr_utility.set_location(' Leaving:'||l_proc, 70);
283: --
284: exception
285: --
286: when hr_api.validate_enabled then
287: --
288: -- As the Validate_Enabled exception has been raised
289: -- we must rollback to the savepoint
290: --
346: ,p_object_version_number => p_object_version_number
347: ,p_effective_date => trunc(p_effective_date)
348: );
349: exception
350: when hr_api.cannot_find_prog_unit then
351: hr_api.cannot_find_prog_unit_error
352: (p_module_name => 'delete_special_attribute'
353: ,p_hook_type => 'BP'
354: );
347: ,p_effective_date => trunc(p_effective_date)
348: );
349: exception
350: when hr_api.cannot_find_prog_unit then
351: hr_api.cannot_find_prog_unit_error
352: (p_module_name => 'delete_special_attribute'
353: ,p_hook_type => 'BP'
354: );
355: --
374: ,p_object_version_number => l_object_version_number
375: ,p_effective_date => trunc(p_effective_date)
376: );
377: exception
378: when hr_api.cannot_find_prog_unit then
379: hr_api.cannot_find_prog_unit_error
380: (p_module_name => 'delete_special_attribute'
381: ,p_hook_type => 'AP'
382: );
375: ,p_effective_date => trunc(p_effective_date)
376: );
377: exception
378: when hr_api.cannot_find_prog_unit then
379: hr_api.cannot_find_prog_unit_error
380: (p_module_name => 'delete_special_attribute'
381: ,p_hook_type => 'AP'
382: );
383: --
389: --
390: -- When in validation only mode raise the Validate_Enabled exception
391: --
392: if p_validate then
393: raise hr_api.validate_enabled;
394: end if;
395: --
396: hr_utility.set_location(' Leaving:'||l_proc, 70);
397: --
396: hr_utility.set_location(' Leaving:'||l_proc, 70);
397: --
398: exception
399: --
400: when hr_api.validate_enabled then
401: --
402: -- As the Validate_Enabled exception has been raised
403: -- we must rollback to the savepoint
404: --