DBA Data[Home] [Help]

APPS.GHR_PAR_EXTRA_INFO_API dependencies on HR_API

Line 187: when hr_api.cannot_find_prog_unit then

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: );

Line 188: hr_api.cannot_find_prog_unit_error

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;

Line 371: when hr_api.cannot_find_prog_unit then

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: );

Line 372: hr_api.cannot_find_prog_unit_error

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;

Line 383: raise hr_api.validate_enabled;

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

Line 388: when hr_api.validate_enabled then

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: --

Line 419: ,p_rei_attribute_category in varchar2 default hr_api.g_varchar2

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

Line 420: ,p_rei_attribute1 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

Line 421: ,p_rei_attribute2 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

Line 422: ,p_rei_attribute3 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

Line 423: ,p_rei_attribute4 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

Line 424: ,p_rei_attribute5 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

Line 425: ,p_rei_attribute6 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

Line 426: ,p_rei_attribute7 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

Line 427: ,p_rei_attribute8 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

Line 428: ,p_rei_attribute9 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

Line 429: ,p_rei_attribute10 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

Line 430: ,p_rei_attribute11 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

Line 431: ,p_rei_attribute12 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

Line 432: ,p_rei_attribute13 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

Line 433: ,p_rei_attribute14 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

Line 434: ,p_rei_attribute15 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

Line 435: ,p_rei_attribute16 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

Line 436: ,p_rei_attribute17 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

Line 437: ,p_rei_attribute18 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

Line 438: ,p_rei_attribute19 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

Line 439: ,p_rei_attribute20 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

Line 440: ,p_rei_information_category 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

Line 441: ,p_rei_information1 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

Line 442: ,p_rei_information2 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

Line 443: ,p_rei_information3 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

Line 444: ,p_rei_information4 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

Line 445: ,p_rei_information5 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

Line 446: ,p_rei_information6 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

Line 447: ,p_rei_information7 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

Line 448: ,p_rei_information8 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

Line 449: ,p_rei_information9 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

Line 450: ,p_rei_information10 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

Line 451: ,p_rei_information11 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

Line 452: ,p_rei_information12 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

Line 453: ,p_rei_information13 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

Line 454: ,p_rei_information14 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

Line 455: ,p_rei_information15 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

Line 456: ,p_rei_information16 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

Line 457: ,p_rei_information17 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

Line 458: ,p_rei_information18 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

Line 459: ,p_rei_information19 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

Line 460: ,p_rei_information20 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

Line 461: ,p_rei_information21 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

Line 462: ,p_rei_information22 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

Line 463: ,p_rei_information23 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

Line 464: ,p_rei_information24 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

Line 465: ,p_rei_information25 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

Line 466: ,p_rei_information26 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

Line 467: ,p_rei_information27 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'

Line 468: ,p_rei_information28 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'
472: ) is

Line 469: ,p_rei_information29 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
473: --

Line 470: ,p_rei_information30 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: --
474: -- Declare cursors and local variables

Line 561: when hr_api.cannot_find_prog_unit then

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'

Line 563: hr_api.cannot_find_prog_unit_error

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;

Line 752: when hr_api.cannot_find_prog_unit then

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'

Line 754: hr_api.cannot_find_prog_unit_error

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;

Line 765: raise hr_api.validate_enabled;

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

Line 770: when hr_api.validate_enabled then

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: --

Line 822: when hr_api.cannot_find_prog_unit then

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: );

Line 823: hr_api.cannot_find_prog_unit_error

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;

Line 852: when hr_api.cannot_find_prog_unit then

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: );

Line 853: hr_api.cannot_find_prog_unit_error

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;

Line 864: raise hr_api.validate_enabled;

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

Line 869: when hr_api.validate_enabled then

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: --