112: ,p_eat_attribute30 => p_eat_attribute30
113: ,p_effective_date => trunc(p_effective_date)
114: );
115: exception
116: when hr_api.cannot_find_prog_unit then
117: hr_api.cannot_find_prog_unit_error
118: (
119: p_module_name => 'CREATE_ACTION_TYPE'
120: ,p_hook_type => 'BP'
113: ,p_effective_date => trunc(p_effective_date)
114: );
115: exception
116: when hr_api.cannot_find_prog_unit then
117: hr_api.cannot_find_prog_unit_error
118: (
119: p_module_name => 'CREATE_ACTION_TYPE'
120: ,p_hook_type => 'BP'
121: );
211: ,p_object_version_number => l_object_version_number
212: ,p_effective_date => trunc(p_effective_date)
213: );
214: exception
215: when hr_api.cannot_find_prog_unit then
216: hr_api.cannot_find_prog_unit_error
217: (p_module_name => 'CREATE_ACTION_TYPE'
218: ,p_hook_type => 'AP'
219: );
212: ,p_effective_date => trunc(p_effective_date)
213: );
214: exception
215: when hr_api.cannot_find_prog_unit then
216: hr_api.cannot_find_prog_unit_error
217: (p_module_name => 'CREATE_ACTION_TYPE'
218: ,p_hook_type => 'AP'
219: );
220: --
226: --
227: -- When in validation only mode raise the Validate_Enabled exception
228: --
229: if p_validate then
230: raise hr_api.validate_enabled;
231: end if;
232: --
233: -- Set all output arguments
234: --
238: hr_utility.set_location(' Leaving:'||l_proc, 70);
239: --
240: exception
241: --
242: when hr_api.validate_enabled then
243: --
244: -- As the Validate_Enabled exception has been raised
245: -- we must rollback to the savepoint
246: --
270: --
271: procedure update_ACTION_TYPE
272: (p_validate in boolean default false
273: ,p_actn_typ_id in number
274: ,p_business_group_id in number default hr_api.g_number
275: ,p_type_cd in varchar2 default hr_api.g_varchar2
276: ,p_name in varchar2 default hr_api.g_varchar2
277: ,p_description in varchar2 default hr_api.g_varchar2
278: ,p_eat_attribute_category in varchar2 default hr_api.g_varchar2
271: procedure update_ACTION_TYPE
272: (p_validate in boolean default false
273: ,p_actn_typ_id in number
274: ,p_business_group_id in number default hr_api.g_number
275: ,p_type_cd in varchar2 default hr_api.g_varchar2
276: ,p_name in varchar2 default hr_api.g_varchar2
277: ,p_description in varchar2 default hr_api.g_varchar2
278: ,p_eat_attribute_category in varchar2 default hr_api.g_varchar2
279: ,p_eat_attribute1 in varchar2 default hr_api.g_varchar2
272: (p_validate in boolean default false
273: ,p_actn_typ_id in number
274: ,p_business_group_id in number default hr_api.g_number
275: ,p_type_cd in varchar2 default hr_api.g_varchar2
276: ,p_name in varchar2 default hr_api.g_varchar2
277: ,p_description in varchar2 default hr_api.g_varchar2
278: ,p_eat_attribute_category in varchar2 default hr_api.g_varchar2
279: ,p_eat_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_eat_attribute2 in varchar2 default hr_api.g_varchar2
273: ,p_actn_typ_id in number
274: ,p_business_group_id in number default hr_api.g_number
275: ,p_type_cd in varchar2 default hr_api.g_varchar2
276: ,p_name in varchar2 default hr_api.g_varchar2
277: ,p_description in varchar2 default hr_api.g_varchar2
278: ,p_eat_attribute_category in varchar2 default hr_api.g_varchar2
279: ,p_eat_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_eat_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_eat_attribute3 in varchar2 default hr_api.g_varchar2
274: ,p_business_group_id in number default hr_api.g_number
275: ,p_type_cd in varchar2 default hr_api.g_varchar2
276: ,p_name in varchar2 default hr_api.g_varchar2
277: ,p_description in varchar2 default hr_api.g_varchar2
278: ,p_eat_attribute_category in varchar2 default hr_api.g_varchar2
279: ,p_eat_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_eat_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_eat_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_eat_attribute4 in varchar2 default hr_api.g_varchar2
275: ,p_type_cd in varchar2 default hr_api.g_varchar2
276: ,p_name in varchar2 default hr_api.g_varchar2
277: ,p_description in varchar2 default hr_api.g_varchar2
278: ,p_eat_attribute_category in varchar2 default hr_api.g_varchar2
279: ,p_eat_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_eat_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_eat_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_eat_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_eat_attribute5 in varchar2 default hr_api.g_varchar2
276: ,p_name in varchar2 default hr_api.g_varchar2
277: ,p_description in varchar2 default hr_api.g_varchar2
278: ,p_eat_attribute_category in varchar2 default hr_api.g_varchar2
279: ,p_eat_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_eat_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_eat_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_eat_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_eat_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_eat_attribute6 in varchar2 default hr_api.g_varchar2
277: ,p_description in varchar2 default hr_api.g_varchar2
278: ,p_eat_attribute_category in varchar2 default hr_api.g_varchar2
279: ,p_eat_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_eat_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_eat_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_eat_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_eat_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_eat_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_eat_attribute7 in varchar2 default hr_api.g_varchar2
278: ,p_eat_attribute_category in varchar2 default hr_api.g_varchar2
279: ,p_eat_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_eat_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_eat_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_eat_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_eat_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_eat_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_eat_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_eat_attribute8 in varchar2 default hr_api.g_varchar2
279: ,p_eat_attribute1 in varchar2 default hr_api.g_varchar2
280: ,p_eat_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_eat_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_eat_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_eat_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_eat_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_eat_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_eat_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_eat_attribute9 in varchar2 default hr_api.g_varchar2
280: ,p_eat_attribute2 in varchar2 default hr_api.g_varchar2
281: ,p_eat_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_eat_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_eat_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_eat_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_eat_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_eat_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_eat_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_eat_attribute10 in varchar2 default hr_api.g_varchar2
281: ,p_eat_attribute3 in varchar2 default hr_api.g_varchar2
282: ,p_eat_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_eat_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_eat_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_eat_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_eat_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_eat_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_eat_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_eat_attribute11 in varchar2 default hr_api.g_varchar2
282: ,p_eat_attribute4 in varchar2 default hr_api.g_varchar2
283: ,p_eat_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_eat_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_eat_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_eat_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_eat_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_eat_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_eat_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_eat_attribute12 in varchar2 default hr_api.g_varchar2
283: ,p_eat_attribute5 in varchar2 default hr_api.g_varchar2
284: ,p_eat_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_eat_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_eat_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_eat_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_eat_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_eat_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_eat_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_eat_attribute13 in varchar2 default hr_api.g_varchar2
284: ,p_eat_attribute6 in varchar2 default hr_api.g_varchar2
285: ,p_eat_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_eat_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_eat_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_eat_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_eat_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_eat_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_eat_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_eat_attribute14 in varchar2 default hr_api.g_varchar2
285: ,p_eat_attribute7 in varchar2 default hr_api.g_varchar2
286: ,p_eat_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_eat_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_eat_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_eat_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_eat_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_eat_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_eat_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_eat_attribute15 in varchar2 default hr_api.g_varchar2
286: ,p_eat_attribute8 in varchar2 default hr_api.g_varchar2
287: ,p_eat_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_eat_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_eat_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_eat_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_eat_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_eat_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_eat_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_eat_attribute16 in varchar2 default hr_api.g_varchar2
287: ,p_eat_attribute9 in varchar2 default hr_api.g_varchar2
288: ,p_eat_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_eat_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_eat_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_eat_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_eat_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_eat_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_eat_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_eat_attribute17 in varchar2 default hr_api.g_varchar2
288: ,p_eat_attribute10 in varchar2 default hr_api.g_varchar2
289: ,p_eat_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_eat_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_eat_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_eat_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_eat_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_eat_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_eat_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_eat_attribute18 in varchar2 default hr_api.g_varchar2
289: ,p_eat_attribute11 in varchar2 default hr_api.g_varchar2
290: ,p_eat_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_eat_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_eat_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_eat_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_eat_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_eat_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_eat_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_eat_attribute19 in varchar2 default hr_api.g_varchar2
290: ,p_eat_attribute12 in varchar2 default hr_api.g_varchar2
291: ,p_eat_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_eat_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_eat_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_eat_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_eat_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_eat_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_eat_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_eat_attribute20 in varchar2 default hr_api.g_varchar2
291: ,p_eat_attribute13 in varchar2 default hr_api.g_varchar2
292: ,p_eat_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_eat_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_eat_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_eat_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_eat_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_eat_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_eat_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_eat_attribute21 in varchar2 default hr_api.g_varchar2
292: ,p_eat_attribute14 in varchar2 default hr_api.g_varchar2
293: ,p_eat_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_eat_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_eat_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_eat_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_eat_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_eat_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_eat_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_eat_attribute22 in varchar2 default hr_api.g_varchar2
293: ,p_eat_attribute15 in varchar2 default hr_api.g_varchar2
294: ,p_eat_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_eat_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_eat_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_eat_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_eat_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_eat_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_eat_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_eat_attribute23 in varchar2 default hr_api.g_varchar2
294: ,p_eat_attribute16 in varchar2 default hr_api.g_varchar2
295: ,p_eat_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_eat_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_eat_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_eat_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_eat_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_eat_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_eat_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_eat_attribute24 in varchar2 default hr_api.g_varchar2
295: ,p_eat_attribute17 in varchar2 default hr_api.g_varchar2
296: ,p_eat_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_eat_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_eat_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_eat_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_eat_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_eat_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_eat_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_eat_attribute25 in varchar2 default hr_api.g_varchar2
296: ,p_eat_attribute18 in varchar2 default hr_api.g_varchar2
297: ,p_eat_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_eat_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_eat_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_eat_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_eat_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_eat_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_eat_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_eat_attribute26 in varchar2 default hr_api.g_varchar2
297: ,p_eat_attribute19 in varchar2 default hr_api.g_varchar2
298: ,p_eat_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_eat_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_eat_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_eat_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_eat_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_eat_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_eat_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_eat_attribute27 in varchar2 default hr_api.g_varchar2
298: ,p_eat_attribute20 in varchar2 default hr_api.g_varchar2
299: ,p_eat_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_eat_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_eat_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_eat_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_eat_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_eat_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_eat_attribute27 in varchar2 default hr_api.g_varchar2
306: ,p_eat_attribute28 in varchar2 default hr_api.g_varchar2
299: ,p_eat_attribute21 in varchar2 default hr_api.g_varchar2
300: ,p_eat_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_eat_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_eat_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_eat_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_eat_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_eat_attribute27 in varchar2 default hr_api.g_varchar2
306: ,p_eat_attribute28 in varchar2 default hr_api.g_varchar2
307: ,p_eat_attribute29 in varchar2 default hr_api.g_varchar2
300: ,p_eat_attribute22 in varchar2 default hr_api.g_varchar2
301: ,p_eat_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_eat_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_eat_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_eat_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_eat_attribute27 in varchar2 default hr_api.g_varchar2
306: ,p_eat_attribute28 in varchar2 default hr_api.g_varchar2
307: ,p_eat_attribute29 in varchar2 default hr_api.g_varchar2
308: ,p_eat_attribute30 in varchar2 default hr_api.g_varchar2
301: ,p_eat_attribute23 in varchar2 default hr_api.g_varchar2
302: ,p_eat_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_eat_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_eat_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_eat_attribute27 in varchar2 default hr_api.g_varchar2
306: ,p_eat_attribute28 in varchar2 default hr_api.g_varchar2
307: ,p_eat_attribute29 in varchar2 default hr_api.g_varchar2
308: ,p_eat_attribute30 in varchar2 default hr_api.g_varchar2
309: ,p_object_version_number in out nocopy number
302: ,p_eat_attribute24 in varchar2 default hr_api.g_varchar2
303: ,p_eat_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_eat_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_eat_attribute27 in varchar2 default hr_api.g_varchar2
306: ,p_eat_attribute28 in varchar2 default hr_api.g_varchar2
307: ,p_eat_attribute29 in varchar2 default hr_api.g_varchar2
308: ,p_eat_attribute30 in varchar2 default hr_api.g_varchar2
309: ,p_object_version_number in out nocopy number
310: ,p_effective_date in date
303: ,p_eat_attribute25 in varchar2 default hr_api.g_varchar2
304: ,p_eat_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_eat_attribute27 in varchar2 default hr_api.g_varchar2
306: ,p_eat_attribute28 in varchar2 default hr_api.g_varchar2
307: ,p_eat_attribute29 in varchar2 default hr_api.g_varchar2
308: ,p_eat_attribute30 in varchar2 default hr_api.g_varchar2
309: ,p_object_version_number in out nocopy number
310: ,p_effective_date in date
311: ) is
304: ,p_eat_attribute26 in varchar2 default hr_api.g_varchar2
305: ,p_eat_attribute27 in varchar2 default hr_api.g_varchar2
306: ,p_eat_attribute28 in varchar2 default hr_api.g_varchar2
307: ,p_eat_attribute29 in varchar2 default hr_api.g_varchar2
308: ,p_eat_attribute30 in varchar2 default hr_api.g_varchar2
309: ,p_object_version_number in out nocopy number
310: ,p_effective_date in date
311: ) is
312: --
374: ,p_object_version_number => p_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 => 'UPDATE_ACTION_TYPE'
381: ,p_hook_type => 'BP'
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 => 'UPDATE_ACTION_TYPE'
381: ,p_hook_type => 'BP'
382: );
383: --
472: ,p_object_version_number => l_object_version_number
473: ,p_effective_date => trunc(p_effective_date)
474: );
475: exception
476: when hr_api.cannot_find_prog_unit then
477: hr_api.cannot_find_prog_unit_error
478: (p_module_name => 'UPDATE_ACTION_TYPE'
479: ,p_hook_type => 'AP'
480: );
473: ,p_effective_date => trunc(p_effective_date)
474: );
475: exception
476: when hr_api.cannot_find_prog_unit then
477: hr_api.cannot_find_prog_unit_error
478: (p_module_name => 'UPDATE_ACTION_TYPE'
479: ,p_hook_type => 'AP'
480: );
481: --
487: --
488: -- When in validation only mode raise the Validate_Enabled exception
489: --
490: if p_validate then
491: raise hr_api.validate_enabled;
492: end if;
493: --
494: -- Set all output arguments
495: --
498: hr_utility.set_location(' Leaving:'||l_proc, 70);
499: --
500: exception
501: --
502: when hr_api.validate_enabled then
503: --
504: -- As the Validate_Enabled exception has been raised
505: -- we must rollback to the savepoint
506: --
561: ,p_object_version_number => p_object_version_number
562: ,p_effective_date => trunc(p_effective_date)
563: );
564: exception
565: when hr_api.cannot_find_prog_unit then
566: hr_api.cannot_find_prog_unit_error
567: (p_module_name => 'DELETE_ACTION_TYPE'
568: ,p_hook_type => 'BP'
569: );
562: ,p_effective_date => trunc(p_effective_date)
563: );
564: exception
565: when hr_api.cannot_find_prog_unit then
566: hr_api.cannot_find_prog_unit_error
567: (p_module_name => 'DELETE_ACTION_TYPE'
568: ,p_hook_type => 'BP'
569: );
570: --
589: ,p_object_version_number => l_object_version_number
590: ,p_effective_date => trunc(p_effective_date)
591: );
592: exception
593: when hr_api.cannot_find_prog_unit then
594: hr_api.cannot_find_prog_unit_error
595: (p_module_name => 'DELETE_ACTION_TYPE'
596: ,p_hook_type => 'AP'
597: );
590: ,p_effective_date => trunc(p_effective_date)
591: );
592: exception
593: when hr_api.cannot_find_prog_unit then
594: hr_api.cannot_find_prog_unit_error
595: (p_module_name => 'DELETE_ACTION_TYPE'
596: ,p_hook_type => 'AP'
597: );
598: --
604: --
605: -- When in validation only mode raise the Validate_Enabled exception
606: --
607: if p_validate then
608: raise hr_api.validate_enabled;
609: end if;
610: --
611: hr_utility.set_location(' Leaving:'||l_proc, 70);
612: --
611: hr_utility.set_location(' Leaving:'||l_proc, 70);
612: --
613: exception
614: --
615: when hr_api.validate_enabled then
616: --
617: -- As the Validate_Enabled exception has been raised
618: -- we must rollback to the savepoint
619: --