143: p_pli_information29 => p_pli_information29,
144: p_pli_information30 => p_pli_information30
145: );
146: exception
147: when hr_api.cannot_find_prog_unit then
148: hr_api.cannot_find_prog_unit_error
149: (p_module_name => 'create_pl_extra_info',
150: p_hook_type => 'BP'
151: );
144: p_pli_information30 => p_pli_information30
145: );
146: exception
147: when hr_api.cannot_find_prog_unit then
148: hr_api.cannot_find_prog_unit_error
149: (p_module_name => 'create_pl_extra_info',
150: p_hook_type => 'BP'
151: );
152: end;
282: p_pli_information30 => p_pli_information30,
283: p_object_version_number => l_object_version_number
284: );
285: exception
286: when hr_api.cannot_find_prog_unit then
287: hr_api.cannot_find_prog_unit_error
288: (p_module_name => 'create_pl_extra_info',
289: p_hook_type => 'AP'
290: );
283: p_object_version_number => l_object_version_number
284: );
285: exception
286: when hr_api.cannot_find_prog_unit then
287: hr_api.cannot_find_prog_unit_error
288: (p_module_name => 'create_pl_extra_info',
289: p_hook_type => 'AP'
290: );
291: end;
292: --
293: -- When in validation only mode raise the Validate_Enabled exception
294: --
295: if p_validate then
296: raise hr_api.validate_enabled;
297: end if;
298: --
299: hr_utility.set_location(' Leaving:'||l_proc, 11);
300: exception
297: end if;
298: --
299: hr_utility.set_location(' Leaving:'||l_proc, 11);
300: exception
301: when hr_api.validate_enabled then
302: --
303: -- As the Validate_Enabled exception has been raised
304: -- we must rollback to the savepoint
305: --
338: procedure update_pl_extra_info
339: (p_validate in boolean default false
340: ,p_pl_extra_info_id in number
341: ,p_object_version_number in out nocopy number
342: ,p_pli_attribute_category in varchar2 default hr_api.g_varchar2
343: ,p_pli_attribute1 in varchar2 default hr_api.g_varchar2
344: ,p_pli_attribute2 in varchar2 default hr_api.g_varchar2
345: ,p_pli_attribute3 in varchar2 default hr_api.g_varchar2
346: ,p_pli_attribute4 in varchar2 default hr_api.g_varchar2
339: (p_validate in boolean default false
340: ,p_pl_extra_info_id in number
341: ,p_object_version_number in out nocopy number
342: ,p_pli_attribute_category in varchar2 default hr_api.g_varchar2
343: ,p_pli_attribute1 in varchar2 default hr_api.g_varchar2
344: ,p_pli_attribute2 in varchar2 default hr_api.g_varchar2
345: ,p_pli_attribute3 in varchar2 default hr_api.g_varchar2
346: ,p_pli_attribute4 in varchar2 default hr_api.g_varchar2
347: ,p_pli_attribute5 in varchar2 default hr_api.g_varchar2
340: ,p_pl_extra_info_id in number
341: ,p_object_version_number in out nocopy number
342: ,p_pli_attribute_category in varchar2 default hr_api.g_varchar2
343: ,p_pli_attribute1 in varchar2 default hr_api.g_varchar2
344: ,p_pli_attribute2 in varchar2 default hr_api.g_varchar2
345: ,p_pli_attribute3 in varchar2 default hr_api.g_varchar2
346: ,p_pli_attribute4 in varchar2 default hr_api.g_varchar2
347: ,p_pli_attribute5 in varchar2 default hr_api.g_varchar2
348: ,p_pli_attribute6 in varchar2 default hr_api.g_varchar2
341: ,p_object_version_number in out nocopy number
342: ,p_pli_attribute_category in varchar2 default hr_api.g_varchar2
343: ,p_pli_attribute1 in varchar2 default hr_api.g_varchar2
344: ,p_pli_attribute2 in varchar2 default hr_api.g_varchar2
345: ,p_pli_attribute3 in varchar2 default hr_api.g_varchar2
346: ,p_pli_attribute4 in varchar2 default hr_api.g_varchar2
347: ,p_pli_attribute5 in varchar2 default hr_api.g_varchar2
348: ,p_pli_attribute6 in varchar2 default hr_api.g_varchar2
349: ,p_pli_attribute7 in varchar2 default hr_api.g_varchar2
342: ,p_pli_attribute_category in varchar2 default hr_api.g_varchar2
343: ,p_pli_attribute1 in varchar2 default hr_api.g_varchar2
344: ,p_pli_attribute2 in varchar2 default hr_api.g_varchar2
345: ,p_pli_attribute3 in varchar2 default hr_api.g_varchar2
346: ,p_pli_attribute4 in varchar2 default hr_api.g_varchar2
347: ,p_pli_attribute5 in varchar2 default hr_api.g_varchar2
348: ,p_pli_attribute6 in varchar2 default hr_api.g_varchar2
349: ,p_pli_attribute7 in varchar2 default hr_api.g_varchar2
350: ,p_pli_attribute8 in varchar2 default hr_api.g_varchar2
343: ,p_pli_attribute1 in varchar2 default hr_api.g_varchar2
344: ,p_pli_attribute2 in varchar2 default hr_api.g_varchar2
345: ,p_pli_attribute3 in varchar2 default hr_api.g_varchar2
346: ,p_pli_attribute4 in varchar2 default hr_api.g_varchar2
347: ,p_pli_attribute5 in varchar2 default hr_api.g_varchar2
348: ,p_pli_attribute6 in varchar2 default hr_api.g_varchar2
349: ,p_pli_attribute7 in varchar2 default hr_api.g_varchar2
350: ,p_pli_attribute8 in varchar2 default hr_api.g_varchar2
351: ,p_pli_attribute9 in varchar2 default hr_api.g_varchar2
344: ,p_pli_attribute2 in varchar2 default hr_api.g_varchar2
345: ,p_pli_attribute3 in varchar2 default hr_api.g_varchar2
346: ,p_pli_attribute4 in varchar2 default hr_api.g_varchar2
347: ,p_pli_attribute5 in varchar2 default hr_api.g_varchar2
348: ,p_pli_attribute6 in varchar2 default hr_api.g_varchar2
349: ,p_pli_attribute7 in varchar2 default hr_api.g_varchar2
350: ,p_pli_attribute8 in varchar2 default hr_api.g_varchar2
351: ,p_pli_attribute9 in varchar2 default hr_api.g_varchar2
352: ,p_pli_attribute10 in varchar2 default hr_api.g_varchar2
345: ,p_pli_attribute3 in varchar2 default hr_api.g_varchar2
346: ,p_pli_attribute4 in varchar2 default hr_api.g_varchar2
347: ,p_pli_attribute5 in varchar2 default hr_api.g_varchar2
348: ,p_pli_attribute6 in varchar2 default hr_api.g_varchar2
349: ,p_pli_attribute7 in varchar2 default hr_api.g_varchar2
350: ,p_pli_attribute8 in varchar2 default hr_api.g_varchar2
351: ,p_pli_attribute9 in varchar2 default hr_api.g_varchar2
352: ,p_pli_attribute10 in varchar2 default hr_api.g_varchar2
353: ,p_pli_attribute11 in varchar2 default hr_api.g_varchar2
346: ,p_pli_attribute4 in varchar2 default hr_api.g_varchar2
347: ,p_pli_attribute5 in varchar2 default hr_api.g_varchar2
348: ,p_pli_attribute6 in varchar2 default hr_api.g_varchar2
349: ,p_pli_attribute7 in varchar2 default hr_api.g_varchar2
350: ,p_pli_attribute8 in varchar2 default hr_api.g_varchar2
351: ,p_pli_attribute9 in varchar2 default hr_api.g_varchar2
352: ,p_pli_attribute10 in varchar2 default hr_api.g_varchar2
353: ,p_pli_attribute11 in varchar2 default hr_api.g_varchar2
354: ,p_pli_attribute12 in varchar2 default hr_api.g_varchar2
347: ,p_pli_attribute5 in varchar2 default hr_api.g_varchar2
348: ,p_pli_attribute6 in varchar2 default hr_api.g_varchar2
349: ,p_pli_attribute7 in varchar2 default hr_api.g_varchar2
350: ,p_pli_attribute8 in varchar2 default hr_api.g_varchar2
351: ,p_pli_attribute9 in varchar2 default hr_api.g_varchar2
352: ,p_pli_attribute10 in varchar2 default hr_api.g_varchar2
353: ,p_pli_attribute11 in varchar2 default hr_api.g_varchar2
354: ,p_pli_attribute12 in varchar2 default hr_api.g_varchar2
355: ,p_pli_attribute13 in varchar2 default hr_api.g_varchar2
348: ,p_pli_attribute6 in varchar2 default hr_api.g_varchar2
349: ,p_pli_attribute7 in varchar2 default hr_api.g_varchar2
350: ,p_pli_attribute8 in varchar2 default hr_api.g_varchar2
351: ,p_pli_attribute9 in varchar2 default hr_api.g_varchar2
352: ,p_pli_attribute10 in varchar2 default hr_api.g_varchar2
353: ,p_pli_attribute11 in varchar2 default hr_api.g_varchar2
354: ,p_pli_attribute12 in varchar2 default hr_api.g_varchar2
355: ,p_pli_attribute13 in varchar2 default hr_api.g_varchar2
356: ,p_pli_attribute14 in varchar2 default hr_api.g_varchar2
349: ,p_pli_attribute7 in varchar2 default hr_api.g_varchar2
350: ,p_pli_attribute8 in varchar2 default hr_api.g_varchar2
351: ,p_pli_attribute9 in varchar2 default hr_api.g_varchar2
352: ,p_pli_attribute10 in varchar2 default hr_api.g_varchar2
353: ,p_pli_attribute11 in varchar2 default hr_api.g_varchar2
354: ,p_pli_attribute12 in varchar2 default hr_api.g_varchar2
355: ,p_pli_attribute13 in varchar2 default hr_api.g_varchar2
356: ,p_pli_attribute14 in varchar2 default hr_api.g_varchar2
357: ,p_pli_attribute15 in varchar2 default hr_api.g_varchar2
350: ,p_pli_attribute8 in varchar2 default hr_api.g_varchar2
351: ,p_pli_attribute9 in varchar2 default hr_api.g_varchar2
352: ,p_pli_attribute10 in varchar2 default hr_api.g_varchar2
353: ,p_pli_attribute11 in varchar2 default hr_api.g_varchar2
354: ,p_pli_attribute12 in varchar2 default hr_api.g_varchar2
355: ,p_pli_attribute13 in varchar2 default hr_api.g_varchar2
356: ,p_pli_attribute14 in varchar2 default hr_api.g_varchar2
357: ,p_pli_attribute15 in varchar2 default hr_api.g_varchar2
358: ,p_pli_attribute16 in varchar2 default hr_api.g_varchar2
351: ,p_pli_attribute9 in varchar2 default hr_api.g_varchar2
352: ,p_pli_attribute10 in varchar2 default hr_api.g_varchar2
353: ,p_pli_attribute11 in varchar2 default hr_api.g_varchar2
354: ,p_pli_attribute12 in varchar2 default hr_api.g_varchar2
355: ,p_pli_attribute13 in varchar2 default hr_api.g_varchar2
356: ,p_pli_attribute14 in varchar2 default hr_api.g_varchar2
357: ,p_pli_attribute15 in varchar2 default hr_api.g_varchar2
358: ,p_pli_attribute16 in varchar2 default hr_api.g_varchar2
359: ,p_pli_attribute17 in varchar2 default hr_api.g_varchar2
352: ,p_pli_attribute10 in varchar2 default hr_api.g_varchar2
353: ,p_pli_attribute11 in varchar2 default hr_api.g_varchar2
354: ,p_pli_attribute12 in varchar2 default hr_api.g_varchar2
355: ,p_pli_attribute13 in varchar2 default hr_api.g_varchar2
356: ,p_pli_attribute14 in varchar2 default hr_api.g_varchar2
357: ,p_pli_attribute15 in varchar2 default hr_api.g_varchar2
358: ,p_pli_attribute16 in varchar2 default hr_api.g_varchar2
359: ,p_pli_attribute17 in varchar2 default hr_api.g_varchar2
360: ,p_pli_attribute18 in varchar2 default hr_api.g_varchar2
353: ,p_pli_attribute11 in varchar2 default hr_api.g_varchar2
354: ,p_pli_attribute12 in varchar2 default hr_api.g_varchar2
355: ,p_pli_attribute13 in varchar2 default hr_api.g_varchar2
356: ,p_pli_attribute14 in varchar2 default hr_api.g_varchar2
357: ,p_pli_attribute15 in varchar2 default hr_api.g_varchar2
358: ,p_pli_attribute16 in varchar2 default hr_api.g_varchar2
359: ,p_pli_attribute17 in varchar2 default hr_api.g_varchar2
360: ,p_pli_attribute18 in varchar2 default hr_api.g_varchar2
361: ,p_pli_attribute19 in varchar2 default hr_api.g_varchar2
354: ,p_pli_attribute12 in varchar2 default hr_api.g_varchar2
355: ,p_pli_attribute13 in varchar2 default hr_api.g_varchar2
356: ,p_pli_attribute14 in varchar2 default hr_api.g_varchar2
357: ,p_pli_attribute15 in varchar2 default hr_api.g_varchar2
358: ,p_pli_attribute16 in varchar2 default hr_api.g_varchar2
359: ,p_pli_attribute17 in varchar2 default hr_api.g_varchar2
360: ,p_pli_attribute18 in varchar2 default hr_api.g_varchar2
361: ,p_pli_attribute19 in varchar2 default hr_api.g_varchar2
362: ,p_pli_attribute20 in varchar2 default hr_api.g_varchar2
355: ,p_pli_attribute13 in varchar2 default hr_api.g_varchar2
356: ,p_pli_attribute14 in varchar2 default hr_api.g_varchar2
357: ,p_pli_attribute15 in varchar2 default hr_api.g_varchar2
358: ,p_pli_attribute16 in varchar2 default hr_api.g_varchar2
359: ,p_pli_attribute17 in varchar2 default hr_api.g_varchar2
360: ,p_pli_attribute18 in varchar2 default hr_api.g_varchar2
361: ,p_pli_attribute19 in varchar2 default hr_api.g_varchar2
362: ,p_pli_attribute20 in varchar2 default hr_api.g_varchar2
363: ,p_pli_information_category in varchar2 default hr_api.g_varchar2
356: ,p_pli_attribute14 in varchar2 default hr_api.g_varchar2
357: ,p_pli_attribute15 in varchar2 default hr_api.g_varchar2
358: ,p_pli_attribute16 in varchar2 default hr_api.g_varchar2
359: ,p_pli_attribute17 in varchar2 default hr_api.g_varchar2
360: ,p_pli_attribute18 in varchar2 default hr_api.g_varchar2
361: ,p_pli_attribute19 in varchar2 default hr_api.g_varchar2
362: ,p_pli_attribute20 in varchar2 default hr_api.g_varchar2
363: ,p_pli_information_category in varchar2 default hr_api.g_varchar2
364: ,p_pli_information1 in varchar2 default hr_api.g_varchar2
357: ,p_pli_attribute15 in varchar2 default hr_api.g_varchar2
358: ,p_pli_attribute16 in varchar2 default hr_api.g_varchar2
359: ,p_pli_attribute17 in varchar2 default hr_api.g_varchar2
360: ,p_pli_attribute18 in varchar2 default hr_api.g_varchar2
361: ,p_pli_attribute19 in varchar2 default hr_api.g_varchar2
362: ,p_pli_attribute20 in varchar2 default hr_api.g_varchar2
363: ,p_pli_information_category in varchar2 default hr_api.g_varchar2
364: ,p_pli_information1 in varchar2 default hr_api.g_varchar2
365: ,p_pli_information2 in varchar2 default hr_api.g_varchar2
358: ,p_pli_attribute16 in varchar2 default hr_api.g_varchar2
359: ,p_pli_attribute17 in varchar2 default hr_api.g_varchar2
360: ,p_pli_attribute18 in varchar2 default hr_api.g_varchar2
361: ,p_pli_attribute19 in varchar2 default hr_api.g_varchar2
362: ,p_pli_attribute20 in varchar2 default hr_api.g_varchar2
363: ,p_pli_information_category in varchar2 default hr_api.g_varchar2
364: ,p_pli_information1 in varchar2 default hr_api.g_varchar2
365: ,p_pli_information2 in varchar2 default hr_api.g_varchar2
366: ,p_pli_information3 in varchar2 default hr_api.g_varchar2
359: ,p_pli_attribute17 in varchar2 default hr_api.g_varchar2
360: ,p_pli_attribute18 in varchar2 default hr_api.g_varchar2
361: ,p_pli_attribute19 in varchar2 default hr_api.g_varchar2
362: ,p_pli_attribute20 in varchar2 default hr_api.g_varchar2
363: ,p_pli_information_category in varchar2 default hr_api.g_varchar2
364: ,p_pli_information1 in varchar2 default hr_api.g_varchar2
365: ,p_pli_information2 in varchar2 default hr_api.g_varchar2
366: ,p_pli_information3 in varchar2 default hr_api.g_varchar2
367: ,p_pli_information4 in varchar2 default hr_api.g_varchar2
360: ,p_pli_attribute18 in varchar2 default hr_api.g_varchar2
361: ,p_pli_attribute19 in varchar2 default hr_api.g_varchar2
362: ,p_pli_attribute20 in varchar2 default hr_api.g_varchar2
363: ,p_pli_information_category in varchar2 default hr_api.g_varchar2
364: ,p_pli_information1 in varchar2 default hr_api.g_varchar2
365: ,p_pli_information2 in varchar2 default hr_api.g_varchar2
366: ,p_pli_information3 in varchar2 default hr_api.g_varchar2
367: ,p_pli_information4 in varchar2 default hr_api.g_varchar2
368: ,p_pli_information5 in varchar2 default hr_api.g_varchar2
361: ,p_pli_attribute19 in varchar2 default hr_api.g_varchar2
362: ,p_pli_attribute20 in varchar2 default hr_api.g_varchar2
363: ,p_pli_information_category in varchar2 default hr_api.g_varchar2
364: ,p_pli_information1 in varchar2 default hr_api.g_varchar2
365: ,p_pli_information2 in varchar2 default hr_api.g_varchar2
366: ,p_pli_information3 in varchar2 default hr_api.g_varchar2
367: ,p_pli_information4 in varchar2 default hr_api.g_varchar2
368: ,p_pli_information5 in varchar2 default hr_api.g_varchar2
369: ,p_pli_information6 in varchar2 default hr_api.g_varchar2
362: ,p_pli_attribute20 in varchar2 default hr_api.g_varchar2
363: ,p_pli_information_category in varchar2 default hr_api.g_varchar2
364: ,p_pli_information1 in varchar2 default hr_api.g_varchar2
365: ,p_pli_information2 in varchar2 default hr_api.g_varchar2
366: ,p_pli_information3 in varchar2 default hr_api.g_varchar2
367: ,p_pli_information4 in varchar2 default hr_api.g_varchar2
368: ,p_pli_information5 in varchar2 default hr_api.g_varchar2
369: ,p_pli_information6 in varchar2 default hr_api.g_varchar2
370: ,p_pli_information7 in varchar2 default hr_api.g_varchar2
363: ,p_pli_information_category in varchar2 default hr_api.g_varchar2
364: ,p_pli_information1 in varchar2 default hr_api.g_varchar2
365: ,p_pli_information2 in varchar2 default hr_api.g_varchar2
366: ,p_pli_information3 in varchar2 default hr_api.g_varchar2
367: ,p_pli_information4 in varchar2 default hr_api.g_varchar2
368: ,p_pli_information5 in varchar2 default hr_api.g_varchar2
369: ,p_pli_information6 in varchar2 default hr_api.g_varchar2
370: ,p_pli_information7 in varchar2 default hr_api.g_varchar2
371: ,p_pli_information8 in varchar2 default hr_api.g_varchar2
364: ,p_pli_information1 in varchar2 default hr_api.g_varchar2
365: ,p_pli_information2 in varchar2 default hr_api.g_varchar2
366: ,p_pli_information3 in varchar2 default hr_api.g_varchar2
367: ,p_pli_information4 in varchar2 default hr_api.g_varchar2
368: ,p_pli_information5 in varchar2 default hr_api.g_varchar2
369: ,p_pli_information6 in varchar2 default hr_api.g_varchar2
370: ,p_pli_information7 in varchar2 default hr_api.g_varchar2
371: ,p_pli_information8 in varchar2 default hr_api.g_varchar2
372: ,p_pli_information9 in varchar2 default hr_api.g_varchar2
365: ,p_pli_information2 in varchar2 default hr_api.g_varchar2
366: ,p_pli_information3 in varchar2 default hr_api.g_varchar2
367: ,p_pli_information4 in varchar2 default hr_api.g_varchar2
368: ,p_pli_information5 in varchar2 default hr_api.g_varchar2
369: ,p_pli_information6 in varchar2 default hr_api.g_varchar2
370: ,p_pli_information7 in varchar2 default hr_api.g_varchar2
371: ,p_pli_information8 in varchar2 default hr_api.g_varchar2
372: ,p_pli_information9 in varchar2 default hr_api.g_varchar2
373: ,p_pli_information10 in varchar2 default hr_api.g_varchar2
366: ,p_pli_information3 in varchar2 default hr_api.g_varchar2
367: ,p_pli_information4 in varchar2 default hr_api.g_varchar2
368: ,p_pli_information5 in varchar2 default hr_api.g_varchar2
369: ,p_pli_information6 in varchar2 default hr_api.g_varchar2
370: ,p_pli_information7 in varchar2 default hr_api.g_varchar2
371: ,p_pli_information8 in varchar2 default hr_api.g_varchar2
372: ,p_pli_information9 in varchar2 default hr_api.g_varchar2
373: ,p_pli_information10 in varchar2 default hr_api.g_varchar2
374: ,p_pli_information11 in varchar2 default hr_api.g_varchar2
367: ,p_pli_information4 in varchar2 default hr_api.g_varchar2
368: ,p_pli_information5 in varchar2 default hr_api.g_varchar2
369: ,p_pli_information6 in varchar2 default hr_api.g_varchar2
370: ,p_pli_information7 in varchar2 default hr_api.g_varchar2
371: ,p_pli_information8 in varchar2 default hr_api.g_varchar2
372: ,p_pli_information9 in varchar2 default hr_api.g_varchar2
373: ,p_pli_information10 in varchar2 default hr_api.g_varchar2
374: ,p_pli_information11 in varchar2 default hr_api.g_varchar2
375: ,p_pli_information12 in varchar2 default hr_api.g_varchar2
368: ,p_pli_information5 in varchar2 default hr_api.g_varchar2
369: ,p_pli_information6 in varchar2 default hr_api.g_varchar2
370: ,p_pli_information7 in varchar2 default hr_api.g_varchar2
371: ,p_pli_information8 in varchar2 default hr_api.g_varchar2
372: ,p_pli_information9 in varchar2 default hr_api.g_varchar2
373: ,p_pli_information10 in varchar2 default hr_api.g_varchar2
374: ,p_pli_information11 in varchar2 default hr_api.g_varchar2
375: ,p_pli_information12 in varchar2 default hr_api.g_varchar2
376: ,p_pli_information13 in varchar2 default hr_api.g_varchar2
369: ,p_pli_information6 in varchar2 default hr_api.g_varchar2
370: ,p_pli_information7 in varchar2 default hr_api.g_varchar2
371: ,p_pli_information8 in varchar2 default hr_api.g_varchar2
372: ,p_pli_information9 in varchar2 default hr_api.g_varchar2
373: ,p_pli_information10 in varchar2 default hr_api.g_varchar2
374: ,p_pli_information11 in varchar2 default hr_api.g_varchar2
375: ,p_pli_information12 in varchar2 default hr_api.g_varchar2
376: ,p_pli_information13 in varchar2 default hr_api.g_varchar2
377: ,p_pli_information14 in varchar2 default hr_api.g_varchar2
370: ,p_pli_information7 in varchar2 default hr_api.g_varchar2
371: ,p_pli_information8 in varchar2 default hr_api.g_varchar2
372: ,p_pli_information9 in varchar2 default hr_api.g_varchar2
373: ,p_pli_information10 in varchar2 default hr_api.g_varchar2
374: ,p_pli_information11 in varchar2 default hr_api.g_varchar2
375: ,p_pli_information12 in varchar2 default hr_api.g_varchar2
376: ,p_pli_information13 in varchar2 default hr_api.g_varchar2
377: ,p_pli_information14 in varchar2 default hr_api.g_varchar2
378: ,p_pli_information15 in varchar2 default hr_api.g_varchar2
371: ,p_pli_information8 in varchar2 default hr_api.g_varchar2
372: ,p_pli_information9 in varchar2 default hr_api.g_varchar2
373: ,p_pli_information10 in varchar2 default hr_api.g_varchar2
374: ,p_pli_information11 in varchar2 default hr_api.g_varchar2
375: ,p_pli_information12 in varchar2 default hr_api.g_varchar2
376: ,p_pli_information13 in varchar2 default hr_api.g_varchar2
377: ,p_pli_information14 in varchar2 default hr_api.g_varchar2
378: ,p_pli_information15 in varchar2 default hr_api.g_varchar2
379: ,p_pli_information16 in varchar2 default hr_api.g_varchar2
372: ,p_pli_information9 in varchar2 default hr_api.g_varchar2
373: ,p_pli_information10 in varchar2 default hr_api.g_varchar2
374: ,p_pli_information11 in varchar2 default hr_api.g_varchar2
375: ,p_pli_information12 in varchar2 default hr_api.g_varchar2
376: ,p_pli_information13 in varchar2 default hr_api.g_varchar2
377: ,p_pli_information14 in varchar2 default hr_api.g_varchar2
378: ,p_pli_information15 in varchar2 default hr_api.g_varchar2
379: ,p_pli_information16 in varchar2 default hr_api.g_varchar2
380: ,p_pli_information17 in varchar2 default hr_api.g_varchar2
373: ,p_pli_information10 in varchar2 default hr_api.g_varchar2
374: ,p_pli_information11 in varchar2 default hr_api.g_varchar2
375: ,p_pli_information12 in varchar2 default hr_api.g_varchar2
376: ,p_pli_information13 in varchar2 default hr_api.g_varchar2
377: ,p_pli_information14 in varchar2 default hr_api.g_varchar2
378: ,p_pli_information15 in varchar2 default hr_api.g_varchar2
379: ,p_pli_information16 in varchar2 default hr_api.g_varchar2
380: ,p_pli_information17 in varchar2 default hr_api.g_varchar2
381: ,p_pli_information18 in varchar2 default hr_api.g_varchar2
374: ,p_pli_information11 in varchar2 default hr_api.g_varchar2
375: ,p_pli_information12 in varchar2 default hr_api.g_varchar2
376: ,p_pli_information13 in varchar2 default hr_api.g_varchar2
377: ,p_pli_information14 in varchar2 default hr_api.g_varchar2
378: ,p_pli_information15 in varchar2 default hr_api.g_varchar2
379: ,p_pli_information16 in varchar2 default hr_api.g_varchar2
380: ,p_pli_information17 in varchar2 default hr_api.g_varchar2
381: ,p_pli_information18 in varchar2 default hr_api.g_varchar2
382: ,p_pli_information19 in varchar2 default hr_api.g_varchar2
375: ,p_pli_information12 in varchar2 default hr_api.g_varchar2
376: ,p_pli_information13 in varchar2 default hr_api.g_varchar2
377: ,p_pli_information14 in varchar2 default hr_api.g_varchar2
378: ,p_pli_information15 in varchar2 default hr_api.g_varchar2
379: ,p_pli_information16 in varchar2 default hr_api.g_varchar2
380: ,p_pli_information17 in varchar2 default hr_api.g_varchar2
381: ,p_pli_information18 in varchar2 default hr_api.g_varchar2
382: ,p_pli_information19 in varchar2 default hr_api.g_varchar2
383: ,p_pli_information20 in varchar2 default hr_api.g_varchar2
376: ,p_pli_information13 in varchar2 default hr_api.g_varchar2
377: ,p_pli_information14 in varchar2 default hr_api.g_varchar2
378: ,p_pli_information15 in varchar2 default hr_api.g_varchar2
379: ,p_pli_information16 in varchar2 default hr_api.g_varchar2
380: ,p_pli_information17 in varchar2 default hr_api.g_varchar2
381: ,p_pli_information18 in varchar2 default hr_api.g_varchar2
382: ,p_pli_information19 in varchar2 default hr_api.g_varchar2
383: ,p_pli_information20 in varchar2 default hr_api.g_varchar2
384: ,p_pli_information21 in varchar2 default hr_api.g_varchar2
377: ,p_pli_information14 in varchar2 default hr_api.g_varchar2
378: ,p_pli_information15 in varchar2 default hr_api.g_varchar2
379: ,p_pli_information16 in varchar2 default hr_api.g_varchar2
380: ,p_pli_information17 in varchar2 default hr_api.g_varchar2
381: ,p_pli_information18 in varchar2 default hr_api.g_varchar2
382: ,p_pli_information19 in varchar2 default hr_api.g_varchar2
383: ,p_pli_information20 in varchar2 default hr_api.g_varchar2
384: ,p_pli_information21 in varchar2 default hr_api.g_varchar2
385: ,p_pli_information22 in varchar2 default hr_api.g_varchar2
378: ,p_pli_information15 in varchar2 default hr_api.g_varchar2
379: ,p_pli_information16 in varchar2 default hr_api.g_varchar2
380: ,p_pli_information17 in varchar2 default hr_api.g_varchar2
381: ,p_pli_information18 in varchar2 default hr_api.g_varchar2
382: ,p_pli_information19 in varchar2 default hr_api.g_varchar2
383: ,p_pli_information20 in varchar2 default hr_api.g_varchar2
384: ,p_pli_information21 in varchar2 default hr_api.g_varchar2
385: ,p_pli_information22 in varchar2 default hr_api.g_varchar2
386: ,p_pli_information23 in varchar2 default hr_api.g_varchar2
379: ,p_pli_information16 in varchar2 default hr_api.g_varchar2
380: ,p_pli_information17 in varchar2 default hr_api.g_varchar2
381: ,p_pli_information18 in varchar2 default hr_api.g_varchar2
382: ,p_pli_information19 in varchar2 default hr_api.g_varchar2
383: ,p_pli_information20 in varchar2 default hr_api.g_varchar2
384: ,p_pli_information21 in varchar2 default hr_api.g_varchar2
385: ,p_pli_information22 in varchar2 default hr_api.g_varchar2
386: ,p_pli_information23 in varchar2 default hr_api.g_varchar2
387: ,p_pli_information24 in varchar2 default hr_api.g_varchar2
380: ,p_pli_information17 in varchar2 default hr_api.g_varchar2
381: ,p_pli_information18 in varchar2 default hr_api.g_varchar2
382: ,p_pli_information19 in varchar2 default hr_api.g_varchar2
383: ,p_pli_information20 in varchar2 default hr_api.g_varchar2
384: ,p_pli_information21 in varchar2 default hr_api.g_varchar2
385: ,p_pli_information22 in varchar2 default hr_api.g_varchar2
386: ,p_pli_information23 in varchar2 default hr_api.g_varchar2
387: ,p_pli_information24 in varchar2 default hr_api.g_varchar2
388: ,p_pli_information25 in varchar2 default hr_api.g_varchar2
381: ,p_pli_information18 in varchar2 default hr_api.g_varchar2
382: ,p_pli_information19 in varchar2 default hr_api.g_varchar2
383: ,p_pli_information20 in varchar2 default hr_api.g_varchar2
384: ,p_pli_information21 in varchar2 default hr_api.g_varchar2
385: ,p_pli_information22 in varchar2 default hr_api.g_varchar2
386: ,p_pli_information23 in varchar2 default hr_api.g_varchar2
387: ,p_pli_information24 in varchar2 default hr_api.g_varchar2
388: ,p_pli_information25 in varchar2 default hr_api.g_varchar2
389: ,p_pli_information26 in varchar2 default hr_api.g_varchar2
382: ,p_pli_information19 in varchar2 default hr_api.g_varchar2
383: ,p_pli_information20 in varchar2 default hr_api.g_varchar2
384: ,p_pli_information21 in varchar2 default hr_api.g_varchar2
385: ,p_pli_information22 in varchar2 default hr_api.g_varchar2
386: ,p_pli_information23 in varchar2 default hr_api.g_varchar2
387: ,p_pli_information24 in varchar2 default hr_api.g_varchar2
388: ,p_pli_information25 in varchar2 default hr_api.g_varchar2
389: ,p_pli_information26 in varchar2 default hr_api.g_varchar2
390: ,p_pli_information27 in varchar2 default hr_api.g_varchar2
383: ,p_pli_information20 in varchar2 default hr_api.g_varchar2
384: ,p_pli_information21 in varchar2 default hr_api.g_varchar2
385: ,p_pli_information22 in varchar2 default hr_api.g_varchar2
386: ,p_pli_information23 in varchar2 default hr_api.g_varchar2
387: ,p_pli_information24 in varchar2 default hr_api.g_varchar2
388: ,p_pli_information25 in varchar2 default hr_api.g_varchar2
389: ,p_pli_information26 in varchar2 default hr_api.g_varchar2
390: ,p_pli_information27 in varchar2 default hr_api.g_varchar2
391: ,p_pli_information28 in varchar2 default hr_api.g_varchar2
384: ,p_pli_information21 in varchar2 default hr_api.g_varchar2
385: ,p_pli_information22 in varchar2 default hr_api.g_varchar2
386: ,p_pli_information23 in varchar2 default hr_api.g_varchar2
387: ,p_pli_information24 in varchar2 default hr_api.g_varchar2
388: ,p_pli_information25 in varchar2 default hr_api.g_varchar2
389: ,p_pli_information26 in varchar2 default hr_api.g_varchar2
390: ,p_pli_information27 in varchar2 default hr_api.g_varchar2
391: ,p_pli_information28 in varchar2 default hr_api.g_varchar2
392: ,p_pli_information29 in varchar2 default hr_api.g_varchar2
385: ,p_pli_information22 in varchar2 default hr_api.g_varchar2
386: ,p_pli_information23 in varchar2 default hr_api.g_varchar2
387: ,p_pli_information24 in varchar2 default hr_api.g_varchar2
388: ,p_pli_information25 in varchar2 default hr_api.g_varchar2
389: ,p_pli_information26 in varchar2 default hr_api.g_varchar2
390: ,p_pli_information27 in varchar2 default hr_api.g_varchar2
391: ,p_pli_information28 in varchar2 default hr_api.g_varchar2
392: ,p_pli_information29 in varchar2 default hr_api.g_varchar2
393: ,p_pli_information30 in varchar2 default hr_api.g_varchar2
386: ,p_pli_information23 in varchar2 default hr_api.g_varchar2
387: ,p_pli_information24 in varchar2 default hr_api.g_varchar2
388: ,p_pli_information25 in varchar2 default hr_api.g_varchar2
389: ,p_pli_information26 in varchar2 default hr_api.g_varchar2
390: ,p_pli_information27 in varchar2 default hr_api.g_varchar2
391: ,p_pli_information28 in varchar2 default hr_api.g_varchar2
392: ,p_pli_information29 in varchar2 default hr_api.g_varchar2
393: ,p_pli_information30 in varchar2 default hr_api.g_varchar2
394: ) is
387: ,p_pli_information24 in varchar2 default hr_api.g_varchar2
388: ,p_pli_information25 in varchar2 default hr_api.g_varchar2
389: ,p_pli_information26 in varchar2 default hr_api.g_varchar2
390: ,p_pli_information27 in varchar2 default hr_api.g_varchar2
391: ,p_pli_information28 in varchar2 default hr_api.g_varchar2
392: ,p_pli_information29 in varchar2 default hr_api.g_varchar2
393: ,p_pli_information30 in varchar2 default hr_api.g_varchar2
394: ) is
395: --
388: ,p_pli_information25 in varchar2 default hr_api.g_varchar2
389: ,p_pli_information26 in varchar2 default hr_api.g_varchar2
390: ,p_pli_information27 in varchar2 default hr_api.g_varchar2
391: ,p_pli_information28 in varchar2 default hr_api.g_varchar2
392: ,p_pli_information29 in varchar2 default hr_api.g_varchar2
393: ,p_pli_information30 in varchar2 default hr_api.g_varchar2
394: ) is
395: --
396: -- Declare cursors and local variables
389: ,p_pli_information26 in varchar2 default hr_api.g_varchar2
390: ,p_pli_information27 in varchar2 default hr_api.g_varchar2
391: ,p_pli_information28 in varchar2 default hr_api.g_varchar2
392: ,p_pli_information29 in varchar2 default hr_api.g_varchar2
393: ,p_pli_information30 in varchar2 default hr_api.g_varchar2
394: ) is
395: --
396: -- Declare cursors and local variables
397: --
466: p_pli_information30 => p_pli_information30,
467: p_object_version_number => p_object_version_number
468: );
469: exception
470: when hr_api.cannot_find_prog_unit then
471: hr_api.cannot_find_prog_unit_error
472: (p_module_name => 'update_pl_extra_info',
473: p_hook_type => 'BP'
474: );
467: p_object_version_number => p_object_version_number
468: );
469: exception
470: when hr_api.cannot_find_prog_unit then
471: hr_api.cannot_find_prog_unit_error
472: (p_module_name => 'update_pl_extra_info',
473: p_hook_type => 'BP'
474: );
475: end;
604: p_pli_information30 => p_pli_information30,
605: p_object_version_number => p_object_version_number
606: );
607: exception
608: when hr_api.cannot_find_prog_unit then
609: hr_api.cannot_find_prog_unit_error
610: (p_module_name => 'update_pl_extra_info',
611: p_hook_type => 'AP'
612: );
605: p_object_version_number => p_object_version_number
606: );
607: exception
608: when hr_api.cannot_find_prog_unit then
609: hr_api.cannot_find_prog_unit_error
610: (p_module_name => 'update_pl_extra_info',
611: p_hook_type => 'AP'
612: );
613: end;
614: --
615: -- When in validation only mode raise the Validate_Enabled exception
616: --
617: if p_validate then
618: raise hr_api.validate_enabled;
619: end if;
620: --
621: hr_utility.set_location(' Leaving:'||l_proc, 11);
622: exception
619: end if;
620: --
621: hr_utility.set_location(' Leaving:'||l_proc, 11);
622: exception
623: when hr_api.validate_enabled then
624: --
625: -- As the Validate_Enabled exception has been raised
626: -- we must rollback to the savepoint
627: --
681: p_pl_extra_info_id => p_pl_extra_info_id,
682: p_object_version_number => p_object_version_number
683: );
684: exception
685: when hr_api.cannot_find_prog_unit then
686: hr_api.cannot_find_prog_unit_error
687: (p_module_name => 'delete_pl_extra_info',
688: p_hook_type => 'BP'
689: );
682: p_object_version_number => p_object_version_number
683: );
684: exception
685: when hr_api.cannot_find_prog_unit then
686: hr_api.cannot_find_prog_unit_error
687: (p_module_name => 'delete_pl_extra_info',
688: p_hook_type => 'BP'
689: );
690: end;
709: p_pl_extra_info_id => p_pl_extra_info_id,
710: p_object_version_number => p_object_version_number
711: );
712: exception
713: when hr_api.cannot_find_prog_unit then
714: hr_api.cannot_find_prog_unit_error
715: (p_module_name => 'delete_pl_extra_info',
716: p_hook_type => 'AP'
717: );
710: p_object_version_number => p_object_version_number
711: );
712: exception
713: when hr_api.cannot_find_prog_unit then
714: hr_api.cannot_find_prog_unit_error
715: (p_module_name => 'delete_pl_extra_info',
716: p_hook_type => 'AP'
717: );
718: end;
719: --
720: -- When in validation only mode raise the Validate_Enabled exception
721: --
722: if p_validate then
723: raise hr_api.validate_enabled;
724: end if;
725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 11);
727: exception
724: end if;
725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 11);
727: exception
728: when hr_api.validate_enabled then
729: --
730: -- As the Validate_Enabled exception has been raised
731: -- we must rollback to the savepoint
732: --