138: ,p_configuration_name => p_configuration_name
139:
140: );
141: exception
142: when hr_api.cannot_find_prog_unit then
143: hr_api.cannot_find_prog_unit_error
144: (p_module_name => 'create_configuration_value'
145: ,p_hook_type => 'BP'
146: );
139:
140: );
141: exception
142: when hr_api.cannot_find_prog_unit then
143: hr_api.cannot_find_prog_unit_error
144: (p_module_name => 'create_configuration_value'
145: ,p_hook_type => 'BP'
146: );
147: end;
260: ,p_configuration_name => p_configuration_name
261:
262: );
263: exception
264: when hr_api.cannot_find_prog_unit then
265: hr_api.cannot_find_prog_unit_error
266: (p_module_name => 'create_configuration_value'
267: ,p_hook_type => 'AP'
268: );
261:
262: );
263: exception
264: when hr_api.cannot_find_prog_unit then
265: hr_api.cannot_find_prog_unit_error
266: (p_module_name => 'create_configuration_value'
267: ,p_hook_type => 'AP'
268: );
269: end;
270: --
271: -- When in validation only mode raise the Validate_Enabled exception
272: --
273: if p_validate then
274: raise hr_api.validate_enabled;
275: end if;
276: --
277: -- Set all IN OUT and OUT parameters with out values
278: --
280: p_object_version_number := l_object_version_number;
281: --
282: hr_utility.set_location(' Leaving:'||l_proc, 70);
283: exception
284: when hr_api.validate_enabled then
285: --
286: -- As the Validate_Enabled exception has been raised
287: -- we must rollback to the savepoint
288: --
319: (p_validate in boolean default false
320: ,p_effective_date in date
321: ,p_business_group_id in number
322: ,p_configuration_value_id in number
323: ,p_legislation_code in varchar2 default hr_api.g_varchar2
324: ,p_pcv_attribute_category in varchar2 default hr_api.g_varchar2
325: ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
320: ,p_effective_date in date
321: ,p_business_group_id in number
322: ,p_configuration_value_id in number
323: ,p_legislation_code in varchar2 default hr_api.g_varchar2
324: ,p_pcv_attribute_category in varchar2 default hr_api.g_varchar2
325: ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
321: ,p_business_group_id in number
322: ,p_configuration_value_id in number
323: ,p_legislation_code in varchar2 default hr_api.g_varchar2
324: ,p_pcv_attribute_category in varchar2 default hr_api.g_varchar2
325: ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
322: ,p_configuration_value_id in number
323: ,p_legislation_code in varchar2 default hr_api.g_varchar2
324: ,p_pcv_attribute_category in varchar2 default hr_api.g_varchar2
325: ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
323: ,p_legislation_code in varchar2 default hr_api.g_varchar2
324: ,p_pcv_attribute_category in varchar2 default hr_api.g_varchar2
325: ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
324: ,p_pcv_attribute_category in varchar2 default hr_api.g_varchar2
325: ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
325: ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
326: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
326: ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
327: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
327: ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
328: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
328: ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
329: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
329: ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
330: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
330: ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
331: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
331: ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
332: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
332: ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
333: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
333: ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
334: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
334: ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
335: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
335: ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
336: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
336: ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
337: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
337: ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
338: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
338: ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
339: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
346: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
339: ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
340: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
346: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
347: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
340: ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
341: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
346: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
347: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
348: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
341: ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
342: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
346: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
347: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
348: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
349: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
342: ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
343: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
346: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
347: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
348: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
349: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
350: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
343: ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
344: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
346: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
347: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
348: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
349: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
350: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
351: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
344: ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
345: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
346: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
347: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
348: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
349: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
350: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
351: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
352: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
345: ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
346: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
347: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
348: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
349: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
350: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
351: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
352: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
353: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
346: ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
347: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
348: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
349: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
350: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
351: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
352: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
353: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
354: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
347: ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
348: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
349: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
350: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
351: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
352: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
353: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
354: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
355: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
348: ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
349: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
350: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
351: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
352: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
353: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
354: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
355: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
356: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
349: ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
350: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
351: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
352: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
353: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
354: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
355: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
356: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
357: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
350: ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
351: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
352: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
353: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
354: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
355: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
356: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
357: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
358: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
351: ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
352: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
353: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
354: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
355: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
356: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
357: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
358: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
359: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
352: ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
353: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
354: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
355: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
356: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
357: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
358: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
359: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
360: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
353: ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
354: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
355: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
356: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
357: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
358: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
359: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
360: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
361: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
354: ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
355: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
356: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
357: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
358: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
359: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
360: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
361: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
362: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
355: ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
356: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
357: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
358: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
359: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
360: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
361: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
362: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
363: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
356: ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
357: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
358: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
359: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
360: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
361: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
362: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
363: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
364: ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
357: ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
358: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
359: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
360: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
361: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
362: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
363: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
364: ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
365: ,p_pcv_information20 in varchar2 default hr_api.g_varchar2
358: ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
359: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
360: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
361: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
362: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
363: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
364: ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
365: ,p_pcv_information20 in varchar2 default hr_api.g_varchar2
366: ,p_object_version_number in out nocopy number
359: ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
360: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
361: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
362: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
363: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
364: ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
365: ,p_pcv_information20 in varchar2 default hr_api.g_varchar2
366: ,p_object_version_number in out nocopy number
367: ,p_configuration_name in varchar2 default hr_api.g_varchar2
360: ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
361: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
362: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
363: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
364: ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
365: ,p_pcv_information20 in varchar2 default hr_api.g_varchar2
366: ,p_object_version_number in out nocopy number
367: ,p_configuration_name in varchar2 default hr_api.g_varchar2
368: ) is
361: ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
362: ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
363: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
364: ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
365: ,p_pcv_information20 in varchar2 default hr_api.g_varchar2
366: ,p_object_version_number in out nocopy number
367: ,p_configuration_name in varchar2 default hr_api.g_varchar2
368: ) is
369: --
363: ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
364: ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
365: ,p_pcv_information20 in varchar2 default hr_api.g_varchar2
366: ,p_object_version_number in out nocopy number
367: ,p_configuration_name in varchar2 default hr_api.g_varchar2
368: ) is
369: --
370: -- Declare cursors and local variables
371: --
443: ,p_configuration_name => p_configuration_name
444:
445: );
446: exception
447: when hr_api.cannot_find_prog_unit then
448: hr_api.cannot_find_prog_unit_error
449: (p_module_name => 'update_configuration_value'
450: ,p_hook_type => 'BP'
451: );
444:
445: );
446: exception
447: when hr_api.cannot_find_prog_unit then
448: hr_api.cannot_find_prog_unit_error
449: (p_module_name => 'update_configuration_value'
450: ,p_hook_type => 'BP'
451: );
452: end;
565: ,p_configuration_name => p_configuration_name
566:
567: );
568: exception
569: when hr_api.cannot_find_prog_unit then
570: hr_api.cannot_find_prog_unit_error
571: (p_module_name => 'update_configuration_value'
572: ,p_hook_type => 'AP'
573: );
566:
567: );
568: exception
569: when hr_api.cannot_find_prog_unit then
570: hr_api.cannot_find_prog_unit_error
571: (p_module_name => 'update_configuration_value'
572: ,p_hook_type => 'AP'
573: );
574: end;
575: --
576: -- When in validation only mode raise the Validate_Enabled exception
577: --
578: if p_validate then
579: raise hr_api.validate_enabled;
580: end if;
581: --
582: -- Set all IN OUT and OUT parameters with out values
583: --
584: p_object_version_number := l_object_version_number;
585: --
586: hr_utility.set_location(' Leaving:'||l_proc, 70);
587: exception
588: when hr_api.validate_enabled then
589: --
590: -- As the Validate_Enabled exception has been raised
591: -- we must rollback to the savepoint
592: --
647: (p_configuration_value_id => p_configuration_value_id
648: ,p_object_version_number => p_object_version_number
649: );
650: exception
651: when hr_api.cannot_find_prog_unit then
652: hr_api.cannot_find_prog_unit_error
653: (p_module_name => 'delete_configuration_value'
654: ,p_hook_type => 'BP'
655: );
648: ,p_object_version_number => p_object_version_number
649: );
650: exception
651: when hr_api.cannot_find_prog_unit then
652: hr_api.cannot_find_prog_unit_error
653: (p_module_name => 'delete_configuration_value'
654: ,p_hook_type => 'BP'
655: );
656: end;
676: (p_configuration_value_id => p_configuration_value_id
677: ,p_object_version_number => p_object_version_number
678: );
679: exception
680: when hr_api.cannot_find_prog_unit then
681: hr_api.cannot_find_prog_unit_error
682: (p_module_name => 'delete_configuration_value'
683: ,p_hook_type => 'AP'
684: );
677: ,p_object_version_number => p_object_version_number
678: );
679: exception
680: when hr_api.cannot_find_prog_unit then
681: hr_api.cannot_find_prog_unit_error
682: (p_module_name => 'delete_configuration_value'
683: ,p_hook_type => 'AP'
684: );
685: end;
686: --
687: -- When in validation only mode raise the Validate_Enabled exception
688: --
689: if p_validate then
690: raise hr_api.validate_enabled;
691: end if;
692: --
693: -- Set all IN OUT and OUT parameters with out values
694: --
695: -- p_object_version_number := l_object_version_number;
696: --
697: hr_utility.set_location(' Leaving:'||l_proc, 70);
698: exception
699: when hr_api.validate_enabled then
700: --
701: -- As the Validate_Enabled exception has been raised
702: -- we must rollback to the savepoint
703: --