116: ,p_xrc_attribute30 => p_xrc_attribute30
117: ,p_effective_date => trunc(p_effective_date)
118: );
119: exception
120: when hr_api.cannot_find_prog_unit then
121: hr_api.cannot_find_prog_unit_error
122: (
123: p_module_name => 'CREATE_EXT_RCD'
124: ,p_hook_type => 'BP'
117: ,p_effective_date => trunc(p_effective_date)
118: );
119: exception
120: when hr_api.cannot_find_prog_unit then
121: hr_api.cannot_find_prog_unit_error
122: (
123: p_module_name => 'CREATE_EXT_RCD'
124: ,p_hook_type => 'BP'
125: );
219: ,p_object_version_number => l_object_version_number
220: ,p_effective_date => trunc(p_effective_date)
221: );
222: exception
223: when hr_api.cannot_find_prog_unit then
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'CREATE_EXT_RCD'
226: ,p_hook_type => 'AP'
227: );
220: ,p_effective_date => trunc(p_effective_date)
221: );
222: exception
223: when hr_api.cannot_find_prog_unit then
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'CREATE_EXT_RCD'
226: ,p_hook_type => 'AP'
227: );
228: --
234: --
235: -- When in validation only mode raise the Validate_Enabled exception
236: --
237: if p_validate then
238: raise hr_api.validate_enabled;
239: end if;
240: --
241: -- Set all output arguments
242: --
246: hr_utility.set_location(' Leaving:'||l_proc, 70);
247: --
248: exception
249: --
250: when hr_api.validate_enabled then
251: --
252: -- As the Validate_Enabled exception has been raised
253: -- we must rollback to the savepoint
254: --
279: --
280: procedure update_EXT_RCD
281: (p_validate in boolean default false
282: ,p_ext_rcd_id in number
283: ,p_name in varchar2 default hr_api.g_varchar2
284: ,p_xml_tag_name in varchar2 default hr_api.g_varchar2
285: ,p_rcd_type_cd in varchar2 default hr_api.g_varchar2
286: ,p_low_lvl_cd in varchar2 default hr_api.g_varchar2
287: ,p_business_group_id in number default hr_api.g_number
280: procedure update_EXT_RCD
281: (p_validate in boolean default false
282: ,p_ext_rcd_id in number
283: ,p_name in varchar2 default hr_api.g_varchar2
284: ,p_xml_tag_name in varchar2 default hr_api.g_varchar2
285: ,p_rcd_type_cd in varchar2 default hr_api.g_varchar2
286: ,p_low_lvl_cd in varchar2 default hr_api.g_varchar2
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_legislation_code in varchar2 default hr_api.g_varchar2
281: (p_validate in boolean default false
282: ,p_ext_rcd_id in number
283: ,p_name in varchar2 default hr_api.g_varchar2
284: ,p_xml_tag_name in varchar2 default hr_api.g_varchar2
285: ,p_rcd_type_cd in varchar2 default hr_api.g_varchar2
286: ,p_low_lvl_cd in varchar2 default hr_api.g_varchar2
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_legislation_code in varchar2 default hr_api.g_varchar2
289: ,p_xrc_attribute_category in varchar2 default hr_api.g_varchar2
282: ,p_ext_rcd_id in number
283: ,p_name in varchar2 default hr_api.g_varchar2
284: ,p_xml_tag_name in varchar2 default hr_api.g_varchar2
285: ,p_rcd_type_cd in varchar2 default hr_api.g_varchar2
286: ,p_low_lvl_cd in varchar2 default hr_api.g_varchar2
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_legislation_code in varchar2 default hr_api.g_varchar2
289: ,p_xrc_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_xrc_attribute1 in varchar2 default hr_api.g_varchar2
283: ,p_name in varchar2 default hr_api.g_varchar2
284: ,p_xml_tag_name in varchar2 default hr_api.g_varchar2
285: ,p_rcd_type_cd in varchar2 default hr_api.g_varchar2
286: ,p_low_lvl_cd in varchar2 default hr_api.g_varchar2
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_legislation_code in varchar2 default hr_api.g_varchar2
289: ,p_xrc_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_xrc_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_xrc_attribute2 in varchar2 default hr_api.g_varchar2
284: ,p_xml_tag_name in varchar2 default hr_api.g_varchar2
285: ,p_rcd_type_cd in varchar2 default hr_api.g_varchar2
286: ,p_low_lvl_cd in varchar2 default hr_api.g_varchar2
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_legislation_code in varchar2 default hr_api.g_varchar2
289: ,p_xrc_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_xrc_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_xrc_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_xrc_attribute3 in varchar2 default hr_api.g_varchar2
285: ,p_rcd_type_cd in varchar2 default hr_api.g_varchar2
286: ,p_low_lvl_cd in varchar2 default hr_api.g_varchar2
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_legislation_code in varchar2 default hr_api.g_varchar2
289: ,p_xrc_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_xrc_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_xrc_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_xrc_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_xrc_attribute4 in varchar2 default hr_api.g_varchar2
286: ,p_low_lvl_cd in varchar2 default hr_api.g_varchar2
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_legislation_code in varchar2 default hr_api.g_varchar2
289: ,p_xrc_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_xrc_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_xrc_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_xrc_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_xrc_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_xrc_attribute5 in varchar2 default hr_api.g_varchar2
287: ,p_business_group_id in number default hr_api.g_number
288: ,p_legislation_code in varchar2 default hr_api.g_varchar2
289: ,p_xrc_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_xrc_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_xrc_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_xrc_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_xrc_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_xrc_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_xrc_attribute6 in varchar2 default hr_api.g_varchar2
288: ,p_legislation_code in varchar2 default hr_api.g_varchar2
289: ,p_xrc_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_xrc_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_xrc_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_xrc_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_xrc_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_xrc_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_xrc_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_xrc_attribute7 in varchar2 default hr_api.g_varchar2
289: ,p_xrc_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_xrc_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_xrc_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_xrc_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_xrc_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_xrc_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_xrc_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_xrc_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_xrc_attribute8 in varchar2 default hr_api.g_varchar2
290: ,p_xrc_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_xrc_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_xrc_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_xrc_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_xrc_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_xrc_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_xrc_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_xrc_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_xrc_attribute9 in varchar2 default hr_api.g_varchar2
291: ,p_xrc_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_xrc_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_xrc_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_xrc_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_xrc_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_xrc_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_xrc_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_xrc_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_xrc_attribute10 in varchar2 default hr_api.g_varchar2
292: ,p_xrc_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_xrc_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_xrc_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_xrc_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_xrc_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_xrc_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_xrc_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_xrc_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_xrc_attribute11 in varchar2 default hr_api.g_varchar2
293: ,p_xrc_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_xrc_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_xrc_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_xrc_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_xrc_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_xrc_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_xrc_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_xrc_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_xrc_attribute12 in varchar2 default hr_api.g_varchar2
294: ,p_xrc_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_xrc_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_xrc_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_xrc_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_xrc_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_xrc_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_xrc_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_xrc_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_xrc_attribute13 in varchar2 default hr_api.g_varchar2
295: ,p_xrc_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_xrc_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_xrc_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_xrc_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_xrc_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_xrc_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_xrc_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_xrc_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_xrc_attribute14 in varchar2 default hr_api.g_varchar2
296: ,p_xrc_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_xrc_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_xrc_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_xrc_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_xrc_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_xrc_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_xrc_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_xrc_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_xrc_attribute15 in varchar2 default hr_api.g_varchar2
297: ,p_xrc_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_xrc_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_xrc_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_xrc_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_xrc_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_xrc_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_xrc_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_xrc_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_xrc_attribute16 in varchar2 default hr_api.g_varchar2
298: ,p_xrc_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_xrc_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_xrc_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_xrc_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_xrc_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_xrc_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_xrc_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_xrc_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_xrc_attribute17 in varchar2 default hr_api.g_varchar2
299: ,p_xrc_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_xrc_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_xrc_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_xrc_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_xrc_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_xrc_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_xrc_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_xrc_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_xrc_attribute18 in varchar2 default hr_api.g_varchar2
300: ,p_xrc_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_xrc_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_xrc_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_xrc_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_xrc_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_xrc_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_xrc_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_xrc_attribute18 in varchar2 default hr_api.g_varchar2
308: ,p_xrc_attribute19 in varchar2 default hr_api.g_varchar2
301: ,p_xrc_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_xrc_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_xrc_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_xrc_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_xrc_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_xrc_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_xrc_attribute18 in varchar2 default hr_api.g_varchar2
308: ,p_xrc_attribute19 in varchar2 default hr_api.g_varchar2
309: ,p_xrc_attribute20 in varchar2 default hr_api.g_varchar2
302: ,p_xrc_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_xrc_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_xrc_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_xrc_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_xrc_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_xrc_attribute18 in varchar2 default hr_api.g_varchar2
308: ,p_xrc_attribute19 in varchar2 default hr_api.g_varchar2
309: ,p_xrc_attribute20 in varchar2 default hr_api.g_varchar2
310: ,p_xrc_attribute21 in varchar2 default hr_api.g_varchar2
303: ,p_xrc_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_xrc_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_xrc_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_xrc_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_xrc_attribute18 in varchar2 default hr_api.g_varchar2
308: ,p_xrc_attribute19 in varchar2 default hr_api.g_varchar2
309: ,p_xrc_attribute20 in varchar2 default hr_api.g_varchar2
310: ,p_xrc_attribute21 in varchar2 default hr_api.g_varchar2
311: ,p_xrc_attribute22 in varchar2 default hr_api.g_varchar2
304: ,p_xrc_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_xrc_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_xrc_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_xrc_attribute18 in varchar2 default hr_api.g_varchar2
308: ,p_xrc_attribute19 in varchar2 default hr_api.g_varchar2
309: ,p_xrc_attribute20 in varchar2 default hr_api.g_varchar2
310: ,p_xrc_attribute21 in varchar2 default hr_api.g_varchar2
311: ,p_xrc_attribute22 in varchar2 default hr_api.g_varchar2
312: ,p_xrc_attribute23 in varchar2 default hr_api.g_varchar2
305: ,p_xrc_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_xrc_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_xrc_attribute18 in varchar2 default hr_api.g_varchar2
308: ,p_xrc_attribute19 in varchar2 default hr_api.g_varchar2
309: ,p_xrc_attribute20 in varchar2 default hr_api.g_varchar2
310: ,p_xrc_attribute21 in varchar2 default hr_api.g_varchar2
311: ,p_xrc_attribute22 in varchar2 default hr_api.g_varchar2
312: ,p_xrc_attribute23 in varchar2 default hr_api.g_varchar2
313: ,p_xrc_attribute24 in varchar2 default hr_api.g_varchar2
306: ,p_xrc_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_xrc_attribute18 in varchar2 default hr_api.g_varchar2
308: ,p_xrc_attribute19 in varchar2 default hr_api.g_varchar2
309: ,p_xrc_attribute20 in varchar2 default hr_api.g_varchar2
310: ,p_xrc_attribute21 in varchar2 default hr_api.g_varchar2
311: ,p_xrc_attribute22 in varchar2 default hr_api.g_varchar2
312: ,p_xrc_attribute23 in varchar2 default hr_api.g_varchar2
313: ,p_xrc_attribute24 in varchar2 default hr_api.g_varchar2
314: ,p_xrc_attribute25 in varchar2 default hr_api.g_varchar2
307: ,p_xrc_attribute18 in varchar2 default hr_api.g_varchar2
308: ,p_xrc_attribute19 in varchar2 default hr_api.g_varchar2
309: ,p_xrc_attribute20 in varchar2 default hr_api.g_varchar2
310: ,p_xrc_attribute21 in varchar2 default hr_api.g_varchar2
311: ,p_xrc_attribute22 in varchar2 default hr_api.g_varchar2
312: ,p_xrc_attribute23 in varchar2 default hr_api.g_varchar2
313: ,p_xrc_attribute24 in varchar2 default hr_api.g_varchar2
314: ,p_xrc_attribute25 in varchar2 default hr_api.g_varchar2
315: ,p_xrc_attribute26 in varchar2 default hr_api.g_varchar2
308: ,p_xrc_attribute19 in varchar2 default hr_api.g_varchar2
309: ,p_xrc_attribute20 in varchar2 default hr_api.g_varchar2
310: ,p_xrc_attribute21 in varchar2 default hr_api.g_varchar2
311: ,p_xrc_attribute22 in varchar2 default hr_api.g_varchar2
312: ,p_xrc_attribute23 in varchar2 default hr_api.g_varchar2
313: ,p_xrc_attribute24 in varchar2 default hr_api.g_varchar2
314: ,p_xrc_attribute25 in varchar2 default hr_api.g_varchar2
315: ,p_xrc_attribute26 in varchar2 default hr_api.g_varchar2
316: ,p_xrc_attribute27 in varchar2 default hr_api.g_varchar2
309: ,p_xrc_attribute20 in varchar2 default hr_api.g_varchar2
310: ,p_xrc_attribute21 in varchar2 default hr_api.g_varchar2
311: ,p_xrc_attribute22 in varchar2 default hr_api.g_varchar2
312: ,p_xrc_attribute23 in varchar2 default hr_api.g_varchar2
313: ,p_xrc_attribute24 in varchar2 default hr_api.g_varchar2
314: ,p_xrc_attribute25 in varchar2 default hr_api.g_varchar2
315: ,p_xrc_attribute26 in varchar2 default hr_api.g_varchar2
316: ,p_xrc_attribute27 in varchar2 default hr_api.g_varchar2
317: ,p_xrc_attribute28 in varchar2 default hr_api.g_varchar2
310: ,p_xrc_attribute21 in varchar2 default hr_api.g_varchar2
311: ,p_xrc_attribute22 in varchar2 default hr_api.g_varchar2
312: ,p_xrc_attribute23 in varchar2 default hr_api.g_varchar2
313: ,p_xrc_attribute24 in varchar2 default hr_api.g_varchar2
314: ,p_xrc_attribute25 in varchar2 default hr_api.g_varchar2
315: ,p_xrc_attribute26 in varchar2 default hr_api.g_varchar2
316: ,p_xrc_attribute27 in varchar2 default hr_api.g_varchar2
317: ,p_xrc_attribute28 in varchar2 default hr_api.g_varchar2
318: ,p_xrc_attribute29 in varchar2 default hr_api.g_varchar2
311: ,p_xrc_attribute22 in varchar2 default hr_api.g_varchar2
312: ,p_xrc_attribute23 in varchar2 default hr_api.g_varchar2
313: ,p_xrc_attribute24 in varchar2 default hr_api.g_varchar2
314: ,p_xrc_attribute25 in varchar2 default hr_api.g_varchar2
315: ,p_xrc_attribute26 in varchar2 default hr_api.g_varchar2
316: ,p_xrc_attribute27 in varchar2 default hr_api.g_varchar2
317: ,p_xrc_attribute28 in varchar2 default hr_api.g_varchar2
318: ,p_xrc_attribute29 in varchar2 default hr_api.g_varchar2
319: ,p_xrc_attribute30 in varchar2 default hr_api.g_varchar2
312: ,p_xrc_attribute23 in varchar2 default hr_api.g_varchar2
313: ,p_xrc_attribute24 in varchar2 default hr_api.g_varchar2
314: ,p_xrc_attribute25 in varchar2 default hr_api.g_varchar2
315: ,p_xrc_attribute26 in varchar2 default hr_api.g_varchar2
316: ,p_xrc_attribute27 in varchar2 default hr_api.g_varchar2
317: ,p_xrc_attribute28 in varchar2 default hr_api.g_varchar2
318: ,p_xrc_attribute29 in varchar2 default hr_api.g_varchar2
319: ,p_xrc_attribute30 in varchar2 default hr_api.g_varchar2
320: ,p_object_version_number in out nocopy number
313: ,p_xrc_attribute24 in varchar2 default hr_api.g_varchar2
314: ,p_xrc_attribute25 in varchar2 default hr_api.g_varchar2
315: ,p_xrc_attribute26 in varchar2 default hr_api.g_varchar2
316: ,p_xrc_attribute27 in varchar2 default hr_api.g_varchar2
317: ,p_xrc_attribute28 in varchar2 default hr_api.g_varchar2
318: ,p_xrc_attribute29 in varchar2 default hr_api.g_varchar2
319: ,p_xrc_attribute30 in varchar2 default hr_api.g_varchar2
320: ,p_object_version_number in out nocopy number
321: ,p_effective_date in date
314: ,p_xrc_attribute25 in varchar2 default hr_api.g_varchar2
315: ,p_xrc_attribute26 in varchar2 default hr_api.g_varchar2
316: ,p_xrc_attribute27 in varchar2 default hr_api.g_varchar2
317: ,p_xrc_attribute28 in varchar2 default hr_api.g_varchar2
318: ,p_xrc_attribute29 in varchar2 default hr_api.g_varchar2
319: ,p_xrc_attribute30 in varchar2 default hr_api.g_varchar2
320: ,p_object_version_number in out nocopy number
321: ,p_effective_date in date
322: ) is
315: ,p_xrc_attribute26 in varchar2 default hr_api.g_varchar2
316: ,p_xrc_attribute27 in varchar2 default hr_api.g_varchar2
317: ,p_xrc_attribute28 in varchar2 default hr_api.g_varchar2
318: ,p_xrc_attribute29 in varchar2 default hr_api.g_varchar2
319: ,p_xrc_attribute30 in varchar2 default hr_api.g_varchar2
320: ,p_object_version_number in out nocopy number
321: ,p_effective_date in date
322: ) is
323: --
387: ,p_object_version_number => p_object_version_number
388: ,p_effective_date => trunc(p_effective_date)
389: );
390: exception
391: when hr_api.cannot_find_prog_unit then
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'UPDATE_EXT_RCD'
394: ,p_hook_type => 'BP'
395: );
388: ,p_effective_date => trunc(p_effective_date)
389: );
390: exception
391: when hr_api.cannot_find_prog_unit then
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'UPDATE_EXT_RCD'
394: ,p_hook_type => 'BP'
395: );
396: --
489: ,p_object_version_number => l_object_version_number
490: ,p_effective_date => trunc(p_effective_date)
491: );
492: exception
493: when hr_api.cannot_find_prog_unit then
494: hr_api.cannot_find_prog_unit_error
495: (p_module_name => 'UPDATE_EXT_RCD'
496: ,p_hook_type => 'AP'
497: );
490: ,p_effective_date => trunc(p_effective_date)
491: );
492: exception
493: when hr_api.cannot_find_prog_unit then
494: hr_api.cannot_find_prog_unit_error
495: (p_module_name => 'UPDATE_EXT_RCD'
496: ,p_hook_type => 'AP'
497: );
498: --
504: --
505: -- When in validation only mode raise the Validate_Enabled exception
506: --
507: if p_validate then
508: raise hr_api.validate_enabled;
509: end if;
510: --
511: -- Set all output arguments
512: --
515: hr_utility.set_location(' Leaving:'||l_proc, 70);
516: --
517: exception
518: --
519: when hr_api.validate_enabled then
520: --
521: -- As the Validate_Enabled exception has been raised
522: -- we must rollback to the savepoint
523: --
580: ,p_object_version_number => p_object_version_number
581: ,p_effective_date => trunc(p_effective_date)
582: );
583: exception
584: when hr_api.cannot_find_prog_unit then
585: hr_api.cannot_find_prog_unit_error
586: (p_module_name => 'DELETE_EXT_RCD'
587: ,p_hook_type => 'BP'
588: );
581: ,p_effective_date => trunc(p_effective_date)
582: );
583: exception
584: when hr_api.cannot_find_prog_unit then
585: hr_api.cannot_find_prog_unit_error
586: (p_module_name => 'DELETE_EXT_RCD'
587: ,p_hook_type => 'BP'
588: );
589: --
610: ,p_object_version_number => l_object_version_number
611: ,p_effective_date => trunc(p_effective_date)
612: );
613: exception
614: when hr_api.cannot_find_prog_unit then
615: hr_api.cannot_find_prog_unit_error
616: (p_module_name => 'DELETE_EXT_RCD'
617: ,p_hook_type => 'AP'
618: );
611: ,p_effective_date => trunc(p_effective_date)
612: );
613: exception
614: when hr_api.cannot_find_prog_unit then
615: hr_api.cannot_find_prog_unit_error
616: (p_module_name => 'DELETE_EXT_RCD'
617: ,p_hook_type => 'AP'
618: );
619: --
625: --
626: -- When in validation only mode raise the Validate_Enabled exception
627: --
628: if p_validate then
629: raise hr_api.validate_enabled;
630: end if;
631: --
632: hr_utility.set_location(' Leaving:'||l_proc, 70);
633: --
632: hr_utility.set_location(' Leaving:'||l_proc, 70);
633: --
634: exception
635: --
636: when hr_api.validate_enabled then
637: --
638: -- As the Validate_Enabled exception has been raised
639: -- we must rollback to the savepoint
640: --