183: ,p_rei_information29 => p_rei_information29
184: ,p_rei_information30 => p_rei_information30
185: );
186: exception
187: when hr_api.cannot_find_prog_unit then
188: hr_api.cannot_find_prog_unit_error
189: (p_module_name => 'create_par_extra_info',
190: p_hook_type => 'BP'
191: );
184: ,p_rei_information30 => p_rei_information30
185: );
186: exception
187: when hr_api.cannot_find_prog_unit then
188: hr_api.cannot_find_prog_unit_error
189: (p_module_name => 'create_par_extra_info',
190: p_hook_type => 'BP'
191: );
192: end;
367: ,p_rei_information30 => p_rei_information30
368: ,p_object_version_number => p_object_version_number
369: );
370: exception
371: when hr_api.cannot_find_prog_unit then
372: hr_api.cannot_find_prog_unit_error
373: (p_module_name => 'create_par_extra_info',
374: p_hook_type => 'AP'
375: );
368: ,p_object_version_number => p_object_version_number
369: );
370: exception
371: when hr_api.cannot_find_prog_unit then
372: hr_api.cannot_find_prog_unit_error
373: (p_module_name => 'create_par_extra_info',
374: p_hook_type => 'AP'
375: );
376: end;
379: --
380: -- When in validation only mode raise the Validate_Enabled exception
381: --
382: if p_validate then
383: raise hr_api.validate_enabled;
384: end if;
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 11);
387: exception
384: end if;
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 11);
387: exception
388: when hr_api.validate_enabled then
389: --
390: -- As the Validate_Enabled exception has been raised
391: -- we must rollback to the savepoint
392: --
415: procedure update_pa_request_extra_info
416: (p_validate in boolean default false
417: ,p_pa_request_extra_info_id in number
418: ,p_object_version_number in out NOCOPY number
419: ,p_rei_attribute_category in varchar2 default hr_api.g_varchar2
420: ,p_rei_attribute1 in varchar2 default hr_api.g_varchar2
421: ,p_rei_attribute2 in varchar2 default hr_api.g_varchar2
422: ,p_rei_attribute3 in varchar2 default hr_api.g_varchar2
423: ,p_rei_attribute4 in varchar2 default hr_api.g_varchar2
416: (p_validate in boolean default false
417: ,p_pa_request_extra_info_id in number
418: ,p_object_version_number in out NOCOPY number
419: ,p_rei_attribute_category in varchar2 default hr_api.g_varchar2
420: ,p_rei_attribute1 in varchar2 default hr_api.g_varchar2
421: ,p_rei_attribute2 in varchar2 default hr_api.g_varchar2
422: ,p_rei_attribute3 in varchar2 default hr_api.g_varchar2
423: ,p_rei_attribute4 in varchar2 default hr_api.g_varchar2
424: ,p_rei_attribute5 in varchar2 default hr_api.g_varchar2
417: ,p_pa_request_extra_info_id in number
418: ,p_object_version_number in out NOCOPY number
419: ,p_rei_attribute_category in varchar2 default hr_api.g_varchar2
420: ,p_rei_attribute1 in varchar2 default hr_api.g_varchar2
421: ,p_rei_attribute2 in varchar2 default hr_api.g_varchar2
422: ,p_rei_attribute3 in varchar2 default hr_api.g_varchar2
423: ,p_rei_attribute4 in varchar2 default hr_api.g_varchar2
424: ,p_rei_attribute5 in varchar2 default hr_api.g_varchar2
425: ,p_rei_attribute6 in varchar2 default hr_api.g_varchar2
418: ,p_object_version_number in out NOCOPY number
419: ,p_rei_attribute_category in varchar2 default hr_api.g_varchar2
420: ,p_rei_attribute1 in varchar2 default hr_api.g_varchar2
421: ,p_rei_attribute2 in varchar2 default hr_api.g_varchar2
422: ,p_rei_attribute3 in varchar2 default hr_api.g_varchar2
423: ,p_rei_attribute4 in varchar2 default hr_api.g_varchar2
424: ,p_rei_attribute5 in varchar2 default hr_api.g_varchar2
425: ,p_rei_attribute6 in varchar2 default hr_api.g_varchar2
426: ,p_rei_attribute7 in varchar2 default hr_api.g_varchar2
419: ,p_rei_attribute_category in varchar2 default hr_api.g_varchar2
420: ,p_rei_attribute1 in varchar2 default hr_api.g_varchar2
421: ,p_rei_attribute2 in varchar2 default hr_api.g_varchar2
422: ,p_rei_attribute3 in varchar2 default hr_api.g_varchar2
423: ,p_rei_attribute4 in varchar2 default hr_api.g_varchar2
424: ,p_rei_attribute5 in varchar2 default hr_api.g_varchar2
425: ,p_rei_attribute6 in varchar2 default hr_api.g_varchar2
426: ,p_rei_attribute7 in varchar2 default hr_api.g_varchar2
427: ,p_rei_attribute8 in varchar2 default hr_api.g_varchar2
420: ,p_rei_attribute1 in varchar2 default hr_api.g_varchar2
421: ,p_rei_attribute2 in varchar2 default hr_api.g_varchar2
422: ,p_rei_attribute3 in varchar2 default hr_api.g_varchar2
423: ,p_rei_attribute4 in varchar2 default hr_api.g_varchar2
424: ,p_rei_attribute5 in varchar2 default hr_api.g_varchar2
425: ,p_rei_attribute6 in varchar2 default hr_api.g_varchar2
426: ,p_rei_attribute7 in varchar2 default hr_api.g_varchar2
427: ,p_rei_attribute8 in varchar2 default hr_api.g_varchar2
428: ,p_rei_attribute9 in varchar2 default hr_api.g_varchar2
421: ,p_rei_attribute2 in varchar2 default hr_api.g_varchar2
422: ,p_rei_attribute3 in varchar2 default hr_api.g_varchar2
423: ,p_rei_attribute4 in varchar2 default hr_api.g_varchar2
424: ,p_rei_attribute5 in varchar2 default hr_api.g_varchar2
425: ,p_rei_attribute6 in varchar2 default hr_api.g_varchar2
426: ,p_rei_attribute7 in varchar2 default hr_api.g_varchar2
427: ,p_rei_attribute8 in varchar2 default hr_api.g_varchar2
428: ,p_rei_attribute9 in varchar2 default hr_api.g_varchar2
429: ,p_rei_attribute10 in varchar2 default hr_api.g_varchar2
422: ,p_rei_attribute3 in varchar2 default hr_api.g_varchar2
423: ,p_rei_attribute4 in varchar2 default hr_api.g_varchar2
424: ,p_rei_attribute5 in varchar2 default hr_api.g_varchar2
425: ,p_rei_attribute6 in varchar2 default hr_api.g_varchar2
426: ,p_rei_attribute7 in varchar2 default hr_api.g_varchar2
427: ,p_rei_attribute8 in varchar2 default hr_api.g_varchar2
428: ,p_rei_attribute9 in varchar2 default hr_api.g_varchar2
429: ,p_rei_attribute10 in varchar2 default hr_api.g_varchar2
430: ,p_rei_attribute11 in varchar2 default hr_api.g_varchar2
423: ,p_rei_attribute4 in varchar2 default hr_api.g_varchar2
424: ,p_rei_attribute5 in varchar2 default hr_api.g_varchar2
425: ,p_rei_attribute6 in varchar2 default hr_api.g_varchar2
426: ,p_rei_attribute7 in varchar2 default hr_api.g_varchar2
427: ,p_rei_attribute8 in varchar2 default hr_api.g_varchar2
428: ,p_rei_attribute9 in varchar2 default hr_api.g_varchar2
429: ,p_rei_attribute10 in varchar2 default hr_api.g_varchar2
430: ,p_rei_attribute11 in varchar2 default hr_api.g_varchar2
431: ,p_rei_attribute12 in varchar2 default hr_api.g_varchar2
424: ,p_rei_attribute5 in varchar2 default hr_api.g_varchar2
425: ,p_rei_attribute6 in varchar2 default hr_api.g_varchar2
426: ,p_rei_attribute7 in varchar2 default hr_api.g_varchar2
427: ,p_rei_attribute8 in varchar2 default hr_api.g_varchar2
428: ,p_rei_attribute9 in varchar2 default hr_api.g_varchar2
429: ,p_rei_attribute10 in varchar2 default hr_api.g_varchar2
430: ,p_rei_attribute11 in varchar2 default hr_api.g_varchar2
431: ,p_rei_attribute12 in varchar2 default hr_api.g_varchar2
432: ,p_rei_attribute13 in varchar2 default hr_api.g_varchar2
425: ,p_rei_attribute6 in varchar2 default hr_api.g_varchar2
426: ,p_rei_attribute7 in varchar2 default hr_api.g_varchar2
427: ,p_rei_attribute8 in varchar2 default hr_api.g_varchar2
428: ,p_rei_attribute9 in varchar2 default hr_api.g_varchar2
429: ,p_rei_attribute10 in varchar2 default hr_api.g_varchar2
430: ,p_rei_attribute11 in varchar2 default hr_api.g_varchar2
431: ,p_rei_attribute12 in varchar2 default hr_api.g_varchar2
432: ,p_rei_attribute13 in varchar2 default hr_api.g_varchar2
433: ,p_rei_attribute14 in varchar2 default hr_api.g_varchar2
426: ,p_rei_attribute7 in varchar2 default hr_api.g_varchar2
427: ,p_rei_attribute8 in varchar2 default hr_api.g_varchar2
428: ,p_rei_attribute9 in varchar2 default hr_api.g_varchar2
429: ,p_rei_attribute10 in varchar2 default hr_api.g_varchar2
430: ,p_rei_attribute11 in varchar2 default hr_api.g_varchar2
431: ,p_rei_attribute12 in varchar2 default hr_api.g_varchar2
432: ,p_rei_attribute13 in varchar2 default hr_api.g_varchar2
433: ,p_rei_attribute14 in varchar2 default hr_api.g_varchar2
434: ,p_rei_attribute15 in varchar2 default hr_api.g_varchar2
427: ,p_rei_attribute8 in varchar2 default hr_api.g_varchar2
428: ,p_rei_attribute9 in varchar2 default hr_api.g_varchar2
429: ,p_rei_attribute10 in varchar2 default hr_api.g_varchar2
430: ,p_rei_attribute11 in varchar2 default hr_api.g_varchar2
431: ,p_rei_attribute12 in varchar2 default hr_api.g_varchar2
432: ,p_rei_attribute13 in varchar2 default hr_api.g_varchar2
433: ,p_rei_attribute14 in varchar2 default hr_api.g_varchar2
434: ,p_rei_attribute15 in varchar2 default hr_api.g_varchar2
435: ,p_rei_attribute16 in varchar2 default hr_api.g_varchar2
428: ,p_rei_attribute9 in varchar2 default hr_api.g_varchar2
429: ,p_rei_attribute10 in varchar2 default hr_api.g_varchar2
430: ,p_rei_attribute11 in varchar2 default hr_api.g_varchar2
431: ,p_rei_attribute12 in varchar2 default hr_api.g_varchar2
432: ,p_rei_attribute13 in varchar2 default hr_api.g_varchar2
433: ,p_rei_attribute14 in varchar2 default hr_api.g_varchar2
434: ,p_rei_attribute15 in varchar2 default hr_api.g_varchar2
435: ,p_rei_attribute16 in varchar2 default hr_api.g_varchar2
436: ,p_rei_attribute17 in varchar2 default hr_api.g_varchar2
429: ,p_rei_attribute10 in varchar2 default hr_api.g_varchar2
430: ,p_rei_attribute11 in varchar2 default hr_api.g_varchar2
431: ,p_rei_attribute12 in varchar2 default hr_api.g_varchar2
432: ,p_rei_attribute13 in varchar2 default hr_api.g_varchar2
433: ,p_rei_attribute14 in varchar2 default hr_api.g_varchar2
434: ,p_rei_attribute15 in varchar2 default hr_api.g_varchar2
435: ,p_rei_attribute16 in varchar2 default hr_api.g_varchar2
436: ,p_rei_attribute17 in varchar2 default hr_api.g_varchar2
437: ,p_rei_attribute18 in varchar2 default hr_api.g_varchar2
430: ,p_rei_attribute11 in varchar2 default hr_api.g_varchar2
431: ,p_rei_attribute12 in varchar2 default hr_api.g_varchar2
432: ,p_rei_attribute13 in varchar2 default hr_api.g_varchar2
433: ,p_rei_attribute14 in varchar2 default hr_api.g_varchar2
434: ,p_rei_attribute15 in varchar2 default hr_api.g_varchar2
435: ,p_rei_attribute16 in varchar2 default hr_api.g_varchar2
436: ,p_rei_attribute17 in varchar2 default hr_api.g_varchar2
437: ,p_rei_attribute18 in varchar2 default hr_api.g_varchar2
438: ,p_rei_attribute19 in varchar2 default hr_api.g_varchar2
431: ,p_rei_attribute12 in varchar2 default hr_api.g_varchar2
432: ,p_rei_attribute13 in varchar2 default hr_api.g_varchar2
433: ,p_rei_attribute14 in varchar2 default hr_api.g_varchar2
434: ,p_rei_attribute15 in varchar2 default hr_api.g_varchar2
435: ,p_rei_attribute16 in varchar2 default hr_api.g_varchar2
436: ,p_rei_attribute17 in varchar2 default hr_api.g_varchar2
437: ,p_rei_attribute18 in varchar2 default hr_api.g_varchar2
438: ,p_rei_attribute19 in varchar2 default hr_api.g_varchar2
439: ,p_rei_attribute20 in varchar2 default hr_api.g_varchar2
432: ,p_rei_attribute13 in varchar2 default hr_api.g_varchar2
433: ,p_rei_attribute14 in varchar2 default hr_api.g_varchar2
434: ,p_rei_attribute15 in varchar2 default hr_api.g_varchar2
435: ,p_rei_attribute16 in varchar2 default hr_api.g_varchar2
436: ,p_rei_attribute17 in varchar2 default hr_api.g_varchar2
437: ,p_rei_attribute18 in varchar2 default hr_api.g_varchar2
438: ,p_rei_attribute19 in varchar2 default hr_api.g_varchar2
439: ,p_rei_attribute20 in varchar2 default hr_api.g_varchar2
440: ,p_rei_information_category in varchar2 default hr_api.g_varchar2
433: ,p_rei_attribute14 in varchar2 default hr_api.g_varchar2
434: ,p_rei_attribute15 in varchar2 default hr_api.g_varchar2
435: ,p_rei_attribute16 in varchar2 default hr_api.g_varchar2
436: ,p_rei_attribute17 in varchar2 default hr_api.g_varchar2
437: ,p_rei_attribute18 in varchar2 default hr_api.g_varchar2
438: ,p_rei_attribute19 in varchar2 default hr_api.g_varchar2
439: ,p_rei_attribute20 in varchar2 default hr_api.g_varchar2
440: ,p_rei_information_category in varchar2 default hr_api.g_varchar2
441: ,p_rei_information1 in varchar2 default hr_api.g_varchar2
434: ,p_rei_attribute15 in varchar2 default hr_api.g_varchar2
435: ,p_rei_attribute16 in varchar2 default hr_api.g_varchar2
436: ,p_rei_attribute17 in varchar2 default hr_api.g_varchar2
437: ,p_rei_attribute18 in varchar2 default hr_api.g_varchar2
438: ,p_rei_attribute19 in varchar2 default hr_api.g_varchar2
439: ,p_rei_attribute20 in varchar2 default hr_api.g_varchar2
440: ,p_rei_information_category in varchar2 default hr_api.g_varchar2
441: ,p_rei_information1 in varchar2 default hr_api.g_varchar2
442: ,p_rei_information2 in varchar2 default hr_api.g_varchar2
435: ,p_rei_attribute16 in varchar2 default hr_api.g_varchar2
436: ,p_rei_attribute17 in varchar2 default hr_api.g_varchar2
437: ,p_rei_attribute18 in varchar2 default hr_api.g_varchar2
438: ,p_rei_attribute19 in varchar2 default hr_api.g_varchar2
439: ,p_rei_attribute20 in varchar2 default hr_api.g_varchar2
440: ,p_rei_information_category in varchar2 default hr_api.g_varchar2
441: ,p_rei_information1 in varchar2 default hr_api.g_varchar2
442: ,p_rei_information2 in varchar2 default hr_api.g_varchar2
443: ,p_rei_information3 in varchar2 default hr_api.g_varchar2
436: ,p_rei_attribute17 in varchar2 default hr_api.g_varchar2
437: ,p_rei_attribute18 in varchar2 default hr_api.g_varchar2
438: ,p_rei_attribute19 in varchar2 default hr_api.g_varchar2
439: ,p_rei_attribute20 in varchar2 default hr_api.g_varchar2
440: ,p_rei_information_category in varchar2 default hr_api.g_varchar2
441: ,p_rei_information1 in varchar2 default hr_api.g_varchar2
442: ,p_rei_information2 in varchar2 default hr_api.g_varchar2
443: ,p_rei_information3 in varchar2 default hr_api.g_varchar2
444: ,p_rei_information4 in varchar2 default hr_api.g_varchar2
437: ,p_rei_attribute18 in varchar2 default hr_api.g_varchar2
438: ,p_rei_attribute19 in varchar2 default hr_api.g_varchar2
439: ,p_rei_attribute20 in varchar2 default hr_api.g_varchar2
440: ,p_rei_information_category in varchar2 default hr_api.g_varchar2
441: ,p_rei_information1 in varchar2 default hr_api.g_varchar2
442: ,p_rei_information2 in varchar2 default hr_api.g_varchar2
443: ,p_rei_information3 in varchar2 default hr_api.g_varchar2
444: ,p_rei_information4 in varchar2 default hr_api.g_varchar2
445: ,p_rei_information5 in varchar2 default hr_api.g_varchar2
438: ,p_rei_attribute19 in varchar2 default hr_api.g_varchar2
439: ,p_rei_attribute20 in varchar2 default hr_api.g_varchar2
440: ,p_rei_information_category in varchar2 default hr_api.g_varchar2
441: ,p_rei_information1 in varchar2 default hr_api.g_varchar2
442: ,p_rei_information2 in varchar2 default hr_api.g_varchar2
443: ,p_rei_information3 in varchar2 default hr_api.g_varchar2
444: ,p_rei_information4 in varchar2 default hr_api.g_varchar2
445: ,p_rei_information5 in varchar2 default hr_api.g_varchar2
446: ,p_rei_information6 in varchar2 default hr_api.g_varchar2
439: ,p_rei_attribute20 in varchar2 default hr_api.g_varchar2
440: ,p_rei_information_category in varchar2 default hr_api.g_varchar2
441: ,p_rei_information1 in varchar2 default hr_api.g_varchar2
442: ,p_rei_information2 in varchar2 default hr_api.g_varchar2
443: ,p_rei_information3 in varchar2 default hr_api.g_varchar2
444: ,p_rei_information4 in varchar2 default hr_api.g_varchar2
445: ,p_rei_information5 in varchar2 default hr_api.g_varchar2
446: ,p_rei_information6 in varchar2 default hr_api.g_varchar2
447: ,p_rei_information7 in varchar2 default hr_api.g_varchar2
440: ,p_rei_information_category in varchar2 default hr_api.g_varchar2
441: ,p_rei_information1 in varchar2 default hr_api.g_varchar2
442: ,p_rei_information2 in varchar2 default hr_api.g_varchar2
443: ,p_rei_information3 in varchar2 default hr_api.g_varchar2
444: ,p_rei_information4 in varchar2 default hr_api.g_varchar2
445: ,p_rei_information5 in varchar2 default hr_api.g_varchar2
446: ,p_rei_information6 in varchar2 default hr_api.g_varchar2
447: ,p_rei_information7 in varchar2 default hr_api.g_varchar2
448: ,p_rei_information8 in varchar2 default hr_api.g_varchar2
441: ,p_rei_information1 in varchar2 default hr_api.g_varchar2
442: ,p_rei_information2 in varchar2 default hr_api.g_varchar2
443: ,p_rei_information3 in varchar2 default hr_api.g_varchar2
444: ,p_rei_information4 in varchar2 default hr_api.g_varchar2
445: ,p_rei_information5 in varchar2 default hr_api.g_varchar2
446: ,p_rei_information6 in varchar2 default hr_api.g_varchar2
447: ,p_rei_information7 in varchar2 default hr_api.g_varchar2
448: ,p_rei_information8 in varchar2 default hr_api.g_varchar2
449: ,p_rei_information9 in varchar2 default hr_api.g_varchar2
442: ,p_rei_information2 in varchar2 default hr_api.g_varchar2
443: ,p_rei_information3 in varchar2 default hr_api.g_varchar2
444: ,p_rei_information4 in varchar2 default hr_api.g_varchar2
445: ,p_rei_information5 in varchar2 default hr_api.g_varchar2
446: ,p_rei_information6 in varchar2 default hr_api.g_varchar2
447: ,p_rei_information7 in varchar2 default hr_api.g_varchar2
448: ,p_rei_information8 in varchar2 default hr_api.g_varchar2
449: ,p_rei_information9 in varchar2 default hr_api.g_varchar2
450: ,p_rei_information10 in varchar2 default hr_api.g_varchar2
443: ,p_rei_information3 in varchar2 default hr_api.g_varchar2
444: ,p_rei_information4 in varchar2 default hr_api.g_varchar2
445: ,p_rei_information5 in varchar2 default hr_api.g_varchar2
446: ,p_rei_information6 in varchar2 default hr_api.g_varchar2
447: ,p_rei_information7 in varchar2 default hr_api.g_varchar2
448: ,p_rei_information8 in varchar2 default hr_api.g_varchar2
449: ,p_rei_information9 in varchar2 default hr_api.g_varchar2
450: ,p_rei_information10 in varchar2 default hr_api.g_varchar2
451: ,p_rei_information11 in varchar2 default hr_api.g_varchar2
444: ,p_rei_information4 in varchar2 default hr_api.g_varchar2
445: ,p_rei_information5 in varchar2 default hr_api.g_varchar2
446: ,p_rei_information6 in varchar2 default hr_api.g_varchar2
447: ,p_rei_information7 in varchar2 default hr_api.g_varchar2
448: ,p_rei_information8 in varchar2 default hr_api.g_varchar2
449: ,p_rei_information9 in varchar2 default hr_api.g_varchar2
450: ,p_rei_information10 in varchar2 default hr_api.g_varchar2
451: ,p_rei_information11 in varchar2 default hr_api.g_varchar2
452: ,p_rei_information12 in varchar2 default hr_api.g_varchar2
445: ,p_rei_information5 in varchar2 default hr_api.g_varchar2
446: ,p_rei_information6 in varchar2 default hr_api.g_varchar2
447: ,p_rei_information7 in varchar2 default hr_api.g_varchar2
448: ,p_rei_information8 in varchar2 default hr_api.g_varchar2
449: ,p_rei_information9 in varchar2 default hr_api.g_varchar2
450: ,p_rei_information10 in varchar2 default hr_api.g_varchar2
451: ,p_rei_information11 in varchar2 default hr_api.g_varchar2
452: ,p_rei_information12 in varchar2 default hr_api.g_varchar2
453: ,p_rei_information13 in varchar2 default hr_api.g_varchar2
446: ,p_rei_information6 in varchar2 default hr_api.g_varchar2
447: ,p_rei_information7 in varchar2 default hr_api.g_varchar2
448: ,p_rei_information8 in varchar2 default hr_api.g_varchar2
449: ,p_rei_information9 in varchar2 default hr_api.g_varchar2
450: ,p_rei_information10 in varchar2 default hr_api.g_varchar2
451: ,p_rei_information11 in varchar2 default hr_api.g_varchar2
452: ,p_rei_information12 in varchar2 default hr_api.g_varchar2
453: ,p_rei_information13 in varchar2 default hr_api.g_varchar2
454: ,p_rei_information14 in varchar2 default hr_api.g_varchar2
447: ,p_rei_information7 in varchar2 default hr_api.g_varchar2
448: ,p_rei_information8 in varchar2 default hr_api.g_varchar2
449: ,p_rei_information9 in varchar2 default hr_api.g_varchar2
450: ,p_rei_information10 in varchar2 default hr_api.g_varchar2
451: ,p_rei_information11 in varchar2 default hr_api.g_varchar2
452: ,p_rei_information12 in varchar2 default hr_api.g_varchar2
453: ,p_rei_information13 in varchar2 default hr_api.g_varchar2
454: ,p_rei_information14 in varchar2 default hr_api.g_varchar2
455: ,p_rei_information15 in varchar2 default hr_api.g_varchar2
448: ,p_rei_information8 in varchar2 default hr_api.g_varchar2
449: ,p_rei_information9 in varchar2 default hr_api.g_varchar2
450: ,p_rei_information10 in varchar2 default hr_api.g_varchar2
451: ,p_rei_information11 in varchar2 default hr_api.g_varchar2
452: ,p_rei_information12 in varchar2 default hr_api.g_varchar2
453: ,p_rei_information13 in varchar2 default hr_api.g_varchar2
454: ,p_rei_information14 in varchar2 default hr_api.g_varchar2
455: ,p_rei_information15 in varchar2 default hr_api.g_varchar2
456: ,p_rei_information16 in varchar2 default hr_api.g_varchar2
449: ,p_rei_information9 in varchar2 default hr_api.g_varchar2
450: ,p_rei_information10 in varchar2 default hr_api.g_varchar2
451: ,p_rei_information11 in varchar2 default hr_api.g_varchar2
452: ,p_rei_information12 in varchar2 default hr_api.g_varchar2
453: ,p_rei_information13 in varchar2 default hr_api.g_varchar2
454: ,p_rei_information14 in varchar2 default hr_api.g_varchar2
455: ,p_rei_information15 in varchar2 default hr_api.g_varchar2
456: ,p_rei_information16 in varchar2 default hr_api.g_varchar2
457: ,p_rei_information17 in varchar2 default hr_api.g_varchar2
450: ,p_rei_information10 in varchar2 default hr_api.g_varchar2
451: ,p_rei_information11 in varchar2 default hr_api.g_varchar2
452: ,p_rei_information12 in varchar2 default hr_api.g_varchar2
453: ,p_rei_information13 in varchar2 default hr_api.g_varchar2
454: ,p_rei_information14 in varchar2 default hr_api.g_varchar2
455: ,p_rei_information15 in varchar2 default hr_api.g_varchar2
456: ,p_rei_information16 in varchar2 default hr_api.g_varchar2
457: ,p_rei_information17 in varchar2 default hr_api.g_varchar2
458: ,p_rei_information18 in varchar2 default hr_api.g_varchar2
451: ,p_rei_information11 in varchar2 default hr_api.g_varchar2
452: ,p_rei_information12 in varchar2 default hr_api.g_varchar2
453: ,p_rei_information13 in varchar2 default hr_api.g_varchar2
454: ,p_rei_information14 in varchar2 default hr_api.g_varchar2
455: ,p_rei_information15 in varchar2 default hr_api.g_varchar2
456: ,p_rei_information16 in varchar2 default hr_api.g_varchar2
457: ,p_rei_information17 in varchar2 default hr_api.g_varchar2
458: ,p_rei_information18 in varchar2 default hr_api.g_varchar2
459: ,p_rei_information19 in varchar2 default hr_api.g_varchar2
452: ,p_rei_information12 in varchar2 default hr_api.g_varchar2
453: ,p_rei_information13 in varchar2 default hr_api.g_varchar2
454: ,p_rei_information14 in varchar2 default hr_api.g_varchar2
455: ,p_rei_information15 in varchar2 default hr_api.g_varchar2
456: ,p_rei_information16 in varchar2 default hr_api.g_varchar2
457: ,p_rei_information17 in varchar2 default hr_api.g_varchar2
458: ,p_rei_information18 in varchar2 default hr_api.g_varchar2
459: ,p_rei_information19 in varchar2 default hr_api.g_varchar2
460: ,p_rei_information20 in varchar2 default hr_api.g_varchar2
453: ,p_rei_information13 in varchar2 default hr_api.g_varchar2
454: ,p_rei_information14 in varchar2 default hr_api.g_varchar2
455: ,p_rei_information15 in varchar2 default hr_api.g_varchar2
456: ,p_rei_information16 in varchar2 default hr_api.g_varchar2
457: ,p_rei_information17 in varchar2 default hr_api.g_varchar2
458: ,p_rei_information18 in varchar2 default hr_api.g_varchar2
459: ,p_rei_information19 in varchar2 default hr_api.g_varchar2
460: ,p_rei_information20 in varchar2 default hr_api.g_varchar2
461: ,p_rei_information21 in varchar2 default hr_api.g_varchar2
454: ,p_rei_information14 in varchar2 default hr_api.g_varchar2
455: ,p_rei_information15 in varchar2 default hr_api.g_varchar2
456: ,p_rei_information16 in varchar2 default hr_api.g_varchar2
457: ,p_rei_information17 in varchar2 default hr_api.g_varchar2
458: ,p_rei_information18 in varchar2 default hr_api.g_varchar2
459: ,p_rei_information19 in varchar2 default hr_api.g_varchar2
460: ,p_rei_information20 in varchar2 default hr_api.g_varchar2
461: ,p_rei_information21 in varchar2 default hr_api.g_varchar2
462: ,p_rei_information22 in varchar2 default hr_api.g_varchar2
455: ,p_rei_information15 in varchar2 default hr_api.g_varchar2
456: ,p_rei_information16 in varchar2 default hr_api.g_varchar2
457: ,p_rei_information17 in varchar2 default hr_api.g_varchar2
458: ,p_rei_information18 in varchar2 default hr_api.g_varchar2
459: ,p_rei_information19 in varchar2 default hr_api.g_varchar2
460: ,p_rei_information20 in varchar2 default hr_api.g_varchar2
461: ,p_rei_information21 in varchar2 default hr_api.g_varchar2
462: ,p_rei_information22 in varchar2 default hr_api.g_varchar2
463: ,p_rei_information23 in varchar2 default hr_api.g_varchar2
456: ,p_rei_information16 in varchar2 default hr_api.g_varchar2
457: ,p_rei_information17 in varchar2 default hr_api.g_varchar2
458: ,p_rei_information18 in varchar2 default hr_api.g_varchar2
459: ,p_rei_information19 in varchar2 default hr_api.g_varchar2
460: ,p_rei_information20 in varchar2 default hr_api.g_varchar2
461: ,p_rei_information21 in varchar2 default hr_api.g_varchar2
462: ,p_rei_information22 in varchar2 default hr_api.g_varchar2
463: ,p_rei_information23 in varchar2 default hr_api.g_varchar2
464: ,p_rei_information24 in varchar2 default hr_api.g_varchar2
457: ,p_rei_information17 in varchar2 default hr_api.g_varchar2
458: ,p_rei_information18 in varchar2 default hr_api.g_varchar2
459: ,p_rei_information19 in varchar2 default hr_api.g_varchar2
460: ,p_rei_information20 in varchar2 default hr_api.g_varchar2
461: ,p_rei_information21 in varchar2 default hr_api.g_varchar2
462: ,p_rei_information22 in varchar2 default hr_api.g_varchar2
463: ,p_rei_information23 in varchar2 default hr_api.g_varchar2
464: ,p_rei_information24 in varchar2 default hr_api.g_varchar2
465: ,p_rei_information25 in varchar2 default hr_api.g_varchar2
458: ,p_rei_information18 in varchar2 default hr_api.g_varchar2
459: ,p_rei_information19 in varchar2 default hr_api.g_varchar2
460: ,p_rei_information20 in varchar2 default hr_api.g_varchar2
461: ,p_rei_information21 in varchar2 default hr_api.g_varchar2
462: ,p_rei_information22 in varchar2 default hr_api.g_varchar2
463: ,p_rei_information23 in varchar2 default hr_api.g_varchar2
464: ,p_rei_information24 in varchar2 default hr_api.g_varchar2
465: ,p_rei_information25 in varchar2 default hr_api.g_varchar2
466: ,p_rei_information26 in varchar2 default hr_api.g_varchar2
459: ,p_rei_information19 in varchar2 default hr_api.g_varchar2
460: ,p_rei_information20 in varchar2 default hr_api.g_varchar2
461: ,p_rei_information21 in varchar2 default hr_api.g_varchar2
462: ,p_rei_information22 in varchar2 default hr_api.g_varchar2
463: ,p_rei_information23 in varchar2 default hr_api.g_varchar2
464: ,p_rei_information24 in varchar2 default hr_api.g_varchar2
465: ,p_rei_information25 in varchar2 default hr_api.g_varchar2
466: ,p_rei_information26 in varchar2 default hr_api.g_varchar2
467: ,p_rei_information27 in varchar2 default hr_api.g_varchar2
460: ,p_rei_information20 in varchar2 default hr_api.g_varchar2
461: ,p_rei_information21 in varchar2 default hr_api.g_varchar2
462: ,p_rei_information22 in varchar2 default hr_api.g_varchar2
463: ,p_rei_information23 in varchar2 default hr_api.g_varchar2
464: ,p_rei_information24 in varchar2 default hr_api.g_varchar2
465: ,p_rei_information25 in varchar2 default hr_api.g_varchar2
466: ,p_rei_information26 in varchar2 default hr_api.g_varchar2
467: ,p_rei_information27 in varchar2 default hr_api.g_varchar2
468: ,p_rei_information28 in varchar2 default hr_api.g_varchar2
461: ,p_rei_information21 in varchar2 default hr_api.g_varchar2
462: ,p_rei_information22 in varchar2 default hr_api.g_varchar2
463: ,p_rei_information23 in varchar2 default hr_api.g_varchar2
464: ,p_rei_information24 in varchar2 default hr_api.g_varchar2
465: ,p_rei_information25 in varchar2 default hr_api.g_varchar2
466: ,p_rei_information26 in varchar2 default hr_api.g_varchar2
467: ,p_rei_information27 in varchar2 default hr_api.g_varchar2
468: ,p_rei_information28 in varchar2 default hr_api.g_varchar2
469: ,p_rei_information29 in varchar2 default hr_api.g_varchar2
462: ,p_rei_information22 in varchar2 default hr_api.g_varchar2
463: ,p_rei_information23 in varchar2 default hr_api.g_varchar2
464: ,p_rei_information24 in varchar2 default hr_api.g_varchar2
465: ,p_rei_information25 in varchar2 default hr_api.g_varchar2
466: ,p_rei_information26 in varchar2 default hr_api.g_varchar2
467: ,p_rei_information27 in varchar2 default hr_api.g_varchar2
468: ,p_rei_information28 in varchar2 default hr_api.g_varchar2
469: ,p_rei_information29 in varchar2 default hr_api.g_varchar2
470: ,p_rei_information30 in varchar2 default hr_api.g_varchar2
463: ,p_rei_information23 in varchar2 default hr_api.g_varchar2
464: ,p_rei_information24 in varchar2 default hr_api.g_varchar2
465: ,p_rei_information25 in varchar2 default hr_api.g_varchar2
466: ,p_rei_information26 in varchar2 default hr_api.g_varchar2
467: ,p_rei_information27 in varchar2 default hr_api.g_varchar2
468: ,p_rei_information28 in varchar2 default hr_api.g_varchar2
469: ,p_rei_information29 in varchar2 default hr_api.g_varchar2
470: ,p_rei_information30 in varchar2 default hr_api.g_varchar2
471: ,p_ben_ei_validate in varchar2 default 'FALSE'
464: ,p_rei_information24 in varchar2 default hr_api.g_varchar2
465: ,p_rei_information25 in varchar2 default hr_api.g_varchar2
466: ,p_rei_information26 in varchar2 default hr_api.g_varchar2
467: ,p_rei_information27 in varchar2 default hr_api.g_varchar2
468: ,p_rei_information28 in varchar2 default hr_api.g_varchar2
469: ,p_rei_information29 in varchar2 default hr_api.g_varchar2
470: ,p_rei_information30 in varchar2 default hr_api.g_varchar2
471: ,p_ben_ei_validate in varchar2 default 'FALSE'
472: ) is
465: ,p_rei_information25 in varchar2 default hr_api.g_varchar2
466: ,p_rei_information26 in varchar2 default hr_api.g_varchar2
467: ,p_rei_information27 in varchar2 default hr_api.g_varchar2
468: ,p_rei_information28 in varchar2 default hr_api.g_varchar2
469: ,p_rei_information29 in varchar2 default hr_api.g_varchar2
470: ,p_rei_information30 in varchar2 default hr_api.g_varchar2
471: ,p_ben_ei_validate in varchar2 default 'FALSE'
472: ) is
473: --
466: ,p_rei_information26 in varchar2 default hr_api.g_varchar2
467: ,p_rei_information27 in varchar2 default hr_api.g_varchar2
468: ,p_rei_information28 in varchar2 default hr_api.g_varchar2
469: ,p_rei_information29 in varchar2 default hr_api.g_varchar2
470: ,p_rei_information30 in varchar2 default hr_api.g_varchar2
471: ,p_ben_ei_validate in varchar2 default 'FALSE'
472: ) is
473: --
474: -- Declare cursors and local variables
557: ,p_rei_information30 => p_rei_information30
558: ,p_object_version_number => p_object_version_number
559: );
560: exception
561: when hr_api.cannot_find_prog_unit then
562: p_object_version_number := l_obj_version_number; -- NOCOPY Changes
563: hr_api.cannot_find_prog_unit_error
564: (p_module_name => 'update_par_extra_info',
565: p_hook_type => 'BP'
559: );
560: exception
561: when hr_api.cannot_find_prog_unit then
562: p_object_version_number := l_obj_version_number; -- NOCOPY Changes
563: hr_api.cannot_find_prog_unit_error
564: (p_module_name => 'update_par_extra_info',
565: p_hook_type => 'BP'
566: );
567: end;
748: ,p_object_version_number => p_object_version_number
749:
750: );
751: exception
752: when hr_api.cannot_find_prog_unit then
753: p_object_version_number := l_obj_version_number; -- NOCOPY Changes
754: hr_api.cannot_find_prog_unit_error
755: (p_module_name => 'update_par_extra_info',
756: p_hook_type => 'AP'
750: );
751: exception
752: when hr_api.cannot_find_prog_unit then
753: p_object_version_number := l_obj_version_number; -- NOCOPY Changes
754: hr_api.cannot_find_prog_unit_error
755: (p_module_name => 'update_par_extra_info',
756: p_hook_type => 'AP'
757: );
758: end;
761: --
762: -- When in validation only mode raise the Validate_Enabled exception
763: --
764: if p_validate then
765: raise hr_api.validate_enabled;
766: end if;
767: --
768: hr_utility.set_location(' Leaving:'||l_proc, 11);
769: exception
766: end if;
767: --
768: hr_utility.set_location(' Leaving:'||l_proc, 11);
769: exception
770: when hr_api.validate_enabled then
771: --
772: -- As the Validate_Enabled exception has been raised
773: -- we must rollback to the savepoint
774: --
818: p_pa_request_extra_info_id => p_pa_request_extra_info_id
819: ,p_object_version_number => p_object_version_number
820: );
821: exception
822: when hr_api.cannot_find_prog_unit then
823: hr_api.cannot_find_prog_unit_error
824: (p_module_name => 'delete_par_extra_info',
825: p_hook_type => 'BP'
826: );
819: ,p_object_version_number => p_object_version_number
820: );
821: exception
822: when hr_api.cannot_find_prog_unit then
823: hr_api.cannot_find_prog_unit_error
824: (p_module_name => 'delete_par_extra_info',
825: p_hook_type => 'BP'
826: );
827: end;
848: p_pa_request_extra_info_id => p_pa_request_extra_info_id
849: ,p_object_version_number => p_object_version_number
850: );
851: exception
852: when hr_api.cannot_find_prog_unit then
853: hr_api.cannot_find_prog_unit_error
854: (p_module_name => 'delete_par_extra_info',
855: p_hook_type => 'AP'
856: );
849: ,p_object_version_number => p_object_version_number
850: );
851: exception
852: when hr_api.cannot_find_prog_unit then
853: hr_api.cannot_find_prog_unit_error
854: (p_module_name => 'delete_par_extra_info',
855: p_hook_type => 'AP'
856: );
857: end;
860: --
861: -- When in validation only mode raise the Validate_Enabled exception
862: --
863: if p_validate then
864: raise hr_api.validate_enabled;
865: end if;
866: --
867: hr_utility.set_location(' Leaving:'||l_proc, 11);
868: exception
865: end if;
866: --
867: hr_utility.set_location(' Leaving:'||l_proc, 11);
868: exception
869: when hr_api.validate_enabled then
870: --
871: -- As the Validate_Enabled exception has been raised
872: -- we must rollback to the savepoint
873: --