DBA Data[Home] [Help]

APPS.HR_PERSON_EXTRA_INFO_API dependencies on HR_API

Line 169: when hr_api.cannot_find_prog_unit then

165: p_pei_information29 => p_pei_information29,
166: p_pei_information30 => p_pei_information30
167: );
168: exception
169: when hr_api.cannot_find_prog_unit then
170: hr_api.cannot_find_prog_unit_error
171: (p_module_name => 'CREATE_PERSON_EXTRA_INFO',
172: p_hook_type => 'BP'
173: );

Line 170: hr_api.cannot_find_prog_unit_error

166: p_pei_information30 => p_pei_information30
167: );
168: exception
169: when hr_api.cannot_find_prog_unit then
170: hr_api.cannot_find_prog_unit_error
171: (p_module_name => 'CREATE_PERSON_EXTRA_INFO',
172: p_hook_type => 'BP'
173: );
174: end;

Line 308: when hr_api.cannot_find_prog_unit then

304: p_pei_information30 => p_pei_information30,
305: p_object_version_number => l_object_version_number
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'CREATE_PERSON_EXTRA_INFO',
311: p_hook_type => 'AP'
312: );

Line 309: hr_api.cannot_find_prog_unit_error

305: p_object_version_number => l_object_version_number
306: );
307: exception
308: when hr_api.cannot_find_prog_unit then
309: hr_api.cannot_find_prog_unit_error
310: (p_module_name => 'CREATE_PERSON_EXTRA_INFO',
311: p_hook_type => 'AP'
312: );
313: end;

Line 320: raise hr_api.validate_enabled;

316: --
317: -- When in validation only mode raise the Validate_Enabled exception
318: --
319: if p_validate then
320: raise hr_api.validate_enabled;
321: end if;
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 11);
324: exception

Line 325: when hr_api.validate_enabled then

321: end if;
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 11);
324: exception
325: when hr_api.validate_enabled then
326: --
327: -- As the Validate_Enabled exception has been raised
328: -- we must rollback to the savepoint
329: --

Line 366: ,p_pei_attribute_category in varchar2 default hr_api.g_varchar2

362: procedure update_person_extra_info
363: (p_validate in boolean default false
364: ,p_person_extra_info_id in number
365: ,p_object_version_number in out nocopy number
366: ,p_pei_attribute_category in varchar2 default hr_api.g_varchar2
367: ,p_pei_attribute1 in varchar2 default hr_api.g_varchar2
368: ,p_pei_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_pei_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_pei_attribute4 in varchar2 default hr_api.g_varchar2

Line 367: ,p_pei_attribute1 in varchar2 default hr_api.g_varchar2

363: (p_validate in boolean default false
364: ,p_person_extra_info_id in number
365: ,p_object_version_number in out nocopy number
366: ,p_pei_attribute_category in varchar2 default hr_api.g_varchar2
367: ,p_pei_attribute1 in varchar2 default hr_api.g_varchar2
368: ,p_pei_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_pei_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_pei_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_pei_attribute5 in varchar2 default hr_api.g_varchar2

Line 368: ,p_pei_attribute2 in varchar2 default hr_api.g_varchar2

364: ,p_person_extra_info_id in number
365: ,p_object_version_number in out nocopy number
366: ,p_pei_attribute_category in varchar2 default hr_api.g_varchar2
367: ,p_pei_attribute1 in varchar2 default hr_api.g_varchar2
368: ,p_pei_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_pei_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_pei_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_pei_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_pei_attribute6 in varchar2 default hr_api.g_varchar2

Line 369: ,p_pei_attribute3 in varchar2 default hr_api.g_varchar2

365: ,p_object_version_number in out nocopy number
366: ,p_pei_attribute_category in varchar2 default hr_api.g_varchar2
367: ,p_pei_attribute1 in varchar2 default hr_api.g_varchar2
368: ,p_pei_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_pei_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_pei_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_pei_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_pei_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_pei_attribute7 in varchar2 default hr_api.g_varchar2

Line 370: ,p_pei_attribute4 in varchar2 default hr_api.g_varchar2

366: ,p_pei_attribute_category in varchar2 default hr_api.g_varchar2
367: ,p_pei_attribute1 in varchar2 default hr_api.g_varchar2
368: ,p_pei_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_pei_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_pei_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_pei_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_pei_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_pei_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_pei_attribute8 in varchar2 default hr_api.g_varchar2

Line 371: ,p_pei_attribute5 in varchar2 default hr_api.g_varchar2

367: ,p_pei_attribute1 in varchar2 default hr_api.g_varchar2
368: ,p_pei_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_pei_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_pei_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_pei_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_pei_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_pei_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_pei_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_pei_attribute9 in varchar2 default hr_api.g_varchar2

Line 372: ,p_pei_attribute6 in varchar2 default hr_api.g_varchar2

368: ,p_pei_attribute2 in varchar2 default hr_api.g_varchar2
369: ,p_pei_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_pei_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_pei_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_pei_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_pei_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_pei_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_pei_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_pei_attribute10 in varchar2 default hr_api.g_varchar2

Line 373: ,p_pei_attribute7 in varchar2 default hr_api.g_varchar2

369: ,p_pei_attribute3 in varchar2 default hr_api.g_varchar2
370: ,p_pei_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_pei_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_pei_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_pei_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_pei_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_pei_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_pei_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_pei_attribute11 in varchar2 default hr_api.g_varchar2

Line 374: ,p_pei_attribute8 in varchar2 default hr_api.g_varchar2

370: ,p_pei_attribute4 in varchar2 default hr_api.g_varchar2
371: ,p_pei_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_pei_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_pei_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_pei_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_pei_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_pei_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_pei_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_pei_attribute12 in varchar2 default hr_api.g_varchar2

Line 375: ,p_pei_attribute9 in varchar2 default hr_api.g_varchar2

371: ,p_pei_attribute5 in varchar2 default hr_api.g_varchar2
372: ,p_pei_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_pei_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_pei_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_pei_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_pei_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_pei_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_pei_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_pei_attribute13 in varchar2 default hr_api.g_varchar2

Line 376: ,p_pei_attribute10 in varchar2 default hr_api.g_varchar2

372: ,p_pei_attribute6 in varchar2 default hr_api.g_varchar2
373: ,p_pei_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_pei_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_pei_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_pei_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_pei_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_pei_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_pei_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_pei_attribute14 in varchar2 default hr_api.g_varchar2

Line 377: ,p_pei_attribute11 in varchar2 default hr_api.g_varchar2

373: ,p_pei_attribute7 in varchar2 default hr_api.g_varchar2
374: ,p_pei_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_pei_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_pei_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_pei_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_pei_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_pei_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_pei_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_pei_attribute15 in varchar2 default hr_api.g_varchar2

Line 378: ,p_pei_attribute12 in varchar2 default hr_api.g_varchar2

374: ,p_pei_attribute8 in varchar2 default hr_api.g_varchar2
375: ,p_pei_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_pei_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_pei_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_pei_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_pei_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_pei_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_pei_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_pei_attribute16 in varchar2 default hr_api.g_varchar2

Line 379: ,p_pei_attribute13 in varchar2 default hr_api.g_varchar2

375: ,p_pei_attribute9 in varchar2 default hr_api.g_varchar2
376: ,p_pei_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_pei_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_pei_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_pei_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_pei_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_pei_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_pei_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_pei_attribute17 in varchar2 default hr_api.g_varchar2

Line 380: ,p_pei_attribute14 in varchar2 default hr_api.g_varchar2

376: ,p_pei_attribute10 in varchar2 default hr_api.g_varchar2
377: ,p_pei_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_pei_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_pei_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_pei_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_pei_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_pei_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_pei_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_pei_attribute18 in varchar2 default hr_api.g_varchar2

Line 381: ,p_pei_attribute15 in varchar2 default hr_api.g_varchar2

377: ,p_pei_attribute11 in varchar2 default hr_api.g_varchar2
378: ,p_pei_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_pei_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_pei_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_pei_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_pei_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_pei_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_pei_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_pei_attribute19 in varchar2 default hr_api.g_varchar2

Line 382: ,p_pei_attribute16 in varchar2 default hr_api.g_varchar2

378: ,p_pei_attribute12 in varchar2 default hr_api.g_varchar2
379: ,p_pei_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_pei_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_pei_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_pei_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_pei_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_pei_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_pei_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_pei_attribute20 in varchar2 default hr_api.g_varchar2

Line 383: ,p_pei_attribute17 in varchar2 default hr_api.g_varchar2

379: ,p_pei_attribute13 in varchar2 default hr_api.g_varchar2
380: ,p_pei_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_pei_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_pei_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_pei_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_pei_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_pei_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_pei_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_pei_information_category in varchar2 default hr_api.g_varchar2

Line 384: ,p_pei_attribute18 in varchar2 default hr_api.g_varchar2

380: ,p_pei_attribute14 in varchar2 default hr_api.g_varchar2
381: ,p_pei_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_pei_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_pei_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_pei_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_pei_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_pei_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_pei_information_category in varchar2 default hr_api.g_varchar2
388: ,p_pei_information1 in varchar2 default hr_api.g_varchar2

Line 385: ,p_pei_attribute19 in varchar2 default hr_api.g_varchar2

381: ,p_pei_attribute15 in varchar2 default hr_api.g_varchar2
382: ,p_pei_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_pei_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_pei_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_pei_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_pei_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_pei_information_category in varchar2 default hr_api.g_varchar2
388: ,p_pei_information1 in varchar2 default hr_api.g_varchar2
389: ,p_pei_information2 in varchar2 default hr_api.g_varchar2

Line 386: ,p_pei_attribute20 in varchar2 default hr_api.g_varchar2

382: ,p_pei_attribute16 in varchar2 default hr_api.g_varchar2
383: ,p_pei_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_pei_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_pei_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_pei_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_pei_information_category in varchar2 default hr_api.g_varchar2
388: ,p_pei_information1 in varchar2 default hr_api.g_varchar2
389: ,p_pei_information2 in varchar2 default hr_api.g_varchar2
390: ,p_pei_information3 in varchar2 default hr_api.g_varchar2

Line 387: ,p_pei_information_category in varchar2 default hr_api.g_varchar2

383: ,p_pei_attribute17 in varchar2 default hr_api.g_varchar2
384: ,p_pei_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_pei_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_pei_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_pei_information_category in varchar2 default hr_api.g_varchar2
388: ,p_pei_information1 in varchar2 default hr_api.g_varchar2
389: ,p_pei_information2 in varchar2 default hr_api.g_varchar2
390: ,p_pei_information3 in varchar2 default hr_api.g_varchar2
391: ,p_pei_information4 in varchar2 default hr_api.g_varchar2

Line 388: ,p_pei_information1 in varchar2 default hr_api.g_varchar2

384: ,p_pei_attribute18 in varchar2 default hr_api.g_varchar2
385: ,p_pei_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_pei_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_pei_information_category in varchar2 default hr_api.g_varchar2
388: ,p_pei_information1 in varchar2 default hr_api.g_varchar2
389: ,p_pei_information2 in varchar2 default hr_api.g_varchar2
390: ,p_pei_information3 in varchar2 default hr_api.g_varchar2
391: ,p_pei_information4 in varchar2 default hr_api.g_varchar2
392: ,p_pei_information5 in varchar2 default hr_api.g_varchar2

Line 389: ,p_pei_information2 in varchar2 default hr_api.g_varchar2

385: ,p_pei_attribute19 in varchar2 default hr_api.g_varchar2
386: ,p_pei_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_pei_information_category in varchar2 default hr_api.g_varchar2
388: ,p_pei_information1 in varchar2 default hr_api.g_varchar2
389: ,p_pei_information2 in varchar2 default hr_api.g_varchar2
390: ,p_pei_information3 in varchar2 default hr_api.g_varchar2
391: ,p_pei_information4 in varchar2 default hr_api.g_varchar2
392: ,p_pei_information5 in varchar2 default hr_api.g_varchar2
393: ,p_pei_information6 in varchar2 default hr_api.g_varchar2

Line 390: ,p_pei_information3 in varchar2 default hr_api.g_varchar2

386: ,p_pei_attribute20 in varchar2 default hr_api.g_varchar2
387: ,p_pei_information_category in varchar2 default hr_api.g_varchar2
388: ,p_pei_information1 in varchar2 default hr_api.g_varchar2
389: ,p_pei_information2 in varchar2 default hr_api.g_varchar2
390: ,p_pei_information3 in varchar2 default hr_api.g_varchar2
391: ,p_pei_information4 in varchar2 default hr_api.g_varchar2
392: ,p_pei_information5 in varchar2 default hr_api.g_varchar2
393: ,p_pei_information6 in varchar2 default hr_api.g_varchar2
394: ,p_pei_information7 in varchar2 default hr_api.g_varchar2

Line 391: ,p_pei_information4 in varchar2 default hr_api.g_varchar2

387: ,p_pei_information_category in varchar2 default hr_api.g_varchar2
388: ,p_pei_information1 in varchar2 default hr_api.g_varchar2
389: ,p_pei_information2 in varchar2 default hr_api.g_varchar2
390: ,p_pei_information3 in varchar2 default hr_api.g_varchar2
391: ,p_pei_information4 in varchar2 default hr_api.g_varchar2
392: ,p_pei_information5 in varchar2 default hr_api.g_varchar2
393: ,p_pei_information6 in varchar2 default hr_api.g_varchar2
394: ,p_pei_information7 in varchar2 default hr_api.g_varchar2
395: ,p_pei_information8 in varchar2 default hr_api.g_varchar2

Line 392: ,p_pei_information5 in varchar2 default hr_api.g_varchar2

388: ,p_pei_information1 in varchar2 default hr_api.g_varchar2
389: ,p_pei_information2 in varchar2 default hr_api.g_varchar2
390: ,p_pei_information3 in varchar2 default hr_api.g_varchar2
391: ,p_pei_information4 in varchar2 default hr_api.g_varchar2
392: ,p_pei_information5 in varchar2 default hr_api.g_varchar2
393: ,p_pei_information6 in varchar2 default hr_api.g_varchar2
394: ,p_pei_information7 in varchar2 default hr_api.g_varchar2
395: ,p_pei_information8 in varchar2 default hr_api.g_varchar2
396: ,p_pei_information9 in varchar2 default hr_api.g_varchar2

Line 393: ,p_pei_information6 in varchar2 default hr_api.g_varchar2

389: ,p_pei_information2 in varchar2 default hr_api.g_varchar2
390: ,p_pei_information3 in varchar2 default hr_api.g_varchar2
391: ,p_pei_information4 in varchar2 default hr_api.g_varchar2
392: ,p_pei_information5 in varchar2 default hr_api.g_varchar2
393: ,p_pei_information6 in varchar2 default hr_api.g_varchar2
394: ,p_pei_information7 in varchar2 default hr_api.g_varchar2
395: ,p_pei_information8 in varchar2 default hr_api.g_varchar2
396: ,p_pei_information9 in varchar2 default hr_api.g_varchar2
397: ,p_pei_information10 in varchar2 default hr_api.g_varchar2

Line 394: ,p_pei_information7 in varchar2 default hr_api.g_varchar2

390: ,p_pei_information3 in varchar2 default hr_api.g_varchar2
391: ,p_pei_information4 in varchar2 default hr_api.g_varchar2
392: ,p_pei_information5 in varchar2 default hr_api.g_varchar2
393: ,p_pei_information6 in varchar2 default hr_api.g_varchar2
394: ,p_pei_information7 in varchar2 default hr_api.g_varchar2
395: ,p_pei_information8 in varchar2 default hr_api.g_varchar2
396: ,p_pei_information9 in varchar2 default hr_api.g_varchar2
397: ,p_pei_information10 in varchar2 default hr_api.g_varchar2
398: ,p_pei_information11 in varchar2 default hr_api.g_varchar2

Line 395: ,p_pei_information8 in varchar2 default hr_api.g_varchar2

391: ,p_pei_information4 in varchar2 default hr_api.g_varchar2
392: ,p_pei_information5 in varchar2 default hr_api.g_varchar2
393: ,p_pei_information6 in varchar2 default hr_api.g_varchar2
394: ,p_pei_information7 in varchar2 default hr_api.g_varchar2
395: ,p_pei_information8 in varchar2 default hr_api.g_varchar2
396: ,p_pei_information9 in varchar2 default hr_api.g_varchar2
397: ,p_pei_information10 in varchar2 default hr_api.g_varchar2
398: ,p_pei_information11 in varchar2 default hr_api.g_varchar2
399: ,p_pei_information12 in varchar2 default hr_api.g_varchar2

Line 396: ,p_pei_information9 in varchar2 default hr_api.g_varchar2

392: ,p_pei_information5 in varchar2 default hr_api.g_varchar2
393: ,p_pei_information6 in varchar2 default hr_api.g_varchar2
394: ,p_pei_information7 in varchar2 default hr_api.g_varchar2
395: ,p_pei_information8 in varchar2 default hr_api.g_varchar2
396: ,p_pei_information9 in varchar2 default hr_api.g_varchar2
397: ,p_pei_information10 in varchar2 default hr_api.g_varchar2
398: ,p_pei_information11 in varchar2 default hr_api.g_varchar2
399: ,p_pei_information12 in varchar2 default hr_api.g_varchar2
400: ,p_pei_information13 in varchar2 default hr_api.g_varchar2

Line 397: ,p_pei_information10 in varchar2 default hr_api.g_varchar2

393: ,p_pei_information6 in varchar2 default hr_api.g_varchar2
394: ,p_pei_information7 in varchar2 default hr_api.g_varchar2
395: ,p_pei_information8 in varchar2 default hr_api.g_varchar2
396: ,p_pei_information9 in varchar2 default hr_api.g_varchar2
397: ,p_pei_information10 in varchar2 default hr_api.g_varchar2
398: ,p_pei_information11 in varchar2 default hr_api.g_varchar2
399: ,p_pei_information12 in varchar2 default hr_api.g_varchar2
400: ,p_pei_information13 in varchar2 default hr_api.g_varchar2
401: ,p_pei_information14 in varchar2 default hr_api.g_varchar2

Line 398: ,p_pei_information11 in varchar2 default hr_api.g_varchar2

394: ,p_pei_information7 in varchar2 default hr_api.g_varchar2
395: ,p_pei_information8 in varchar2 default hr_api.g_varchar2
396: ,p_pei_information9 in varchar2 default hr_api.g_varchar2
397: ,p_pei_information10 in varchar2 default hr_api.g_varchar2
398: ,p_pei_information11 in varchar2 default hr_api.g_varchar2
399: ,p_pei_information12 in varchar2 default hr_api.g_varchar2
400: ,p_pei_information13 in varchar2 default hr_api.g_varchar2
401: ,p_pei_information14 in varchar2 default hr_api.g_varchar2
402: ,p_pei_information15 in varchar2 default hr_api.g_varchar2

Line 399: ,p_pei_information12 in varchar2 default hr_api.g_varchar2

395: ,p_pei_information8 in varchar2 default hr_api.g_varchar2
396: ,p_pei_information9 in varchar2 default hr_api.g_varchar2
397: ,p_pei_information10 in varchar2 default hr_api.g_varchar2
398: ,p_pei_information11 in varchar2 default hr_api.g_varchar2
399: ,p_pei_information12 in varchar2 default hr_api.g_varchar2
400: ,p_pei_information13 in varchar2 default hr_api.g_varchar2
401: ,p_pei_information14 in varchar2 default hr_api.g_varchar2
402: ,p_pei_information15 in varchar2 default hr_api.g_varchar2
403: ,p_pei_information16 in varchar2 default hr_api.g_varchar2

Line 400: ,p_pei_information13 in varchar2 default hr_api.g_varchar2

396: ,p_pei_information9 in varchar2 default hr_api.g_varchar2
397: ,p_pei_information10 in varchar2 default hr_api.g_varchar2
398: ,p_pei_information11 in varchar2 default hr_api.g_varchar2
399: ,p_pei_information12 in varchar2 default hr_api.g_varchar2
400: ,p_pei_information13 in varchar2 default hr_api.g_varchar2
401: ,p_pei_information14 in varchar2 default hr_api.g_varchar2
402: ,p_pei_information15 in varchar2 default hr_api.g_varchar2
403: ,p_pei_information16 in varchar2 default hr_api.g_varchar2
404: ,p_pei_information17 in varchar2 default hr_api.g_varchar2

Line 401: ,p_pei_information14 in varchar2 default hr_api.g_varchar2

397: ,p_pei_information10 in varchar2 default hr_api.g_varchar2
398: ,p_pei_information11 in varchar2 default hr_api.g_varchar2
399: ,p_pei_information12 in varchar2 default hr_api.g_varchar2
400: ,p_pei_information13 in varchar2 default hr_api.g_varchar2
401: ,p_pei_information14 in varchar2 default hr_api.g_varchar2
402: ,p_pei_information15 in varchar2 default hr_api.g_varchar2
403: ,p_pei_information16 in varchar2 default hr_api.g_varchar2
404: ,p_pei_information17 in varchar2 default hr_api.g_varchar2
405: ,p_pei_information18 in varchar2 default hr_api.g_varchar2

Line 402: ,p_pei_information15 in varchar2 default hr_api.g_varchar2

398: ,p_pei_information11 in varchar2 default hr_api.g_varchar2
399: ,p_pei_information12 in varchar2 default hr_api.g_varchar2
400: ,p_pei_information13 in varchar2 default hr_api.g_varchar2
401: ,p_pei_information14 in varchar2 default hr_api.g_varchar2
402: ,p_pei_information15 in varchar2 default hr_api.g_varchar2
403: ,p_pei_information16 in varchar2 default hr_api.g_varchar2
404: ,p_pei_information17 in varchar2 default hr_api.g_varchar2
405: ,p_pei_information18 in varchar2 default hr_api.g_varchar2
406: ,p_pei_information19 in varchar2 default hr_api.g_varchar2

Line 403: ,p_pei_information16 in varchar2 default hr_api.g_varchar2

399: ,p_pei_information12 in varchar2 default hr_api.g_varchar2
400: ,p_pei_information13 in varchar2 default hr_api.g_varchar2
401: ,p_pei_information14 in varchar2 default hr_api.g_varchar2
402: ,p_pei_information15 in varchar2 default hr_api.g_varchar2
403: ,p_pei_information16 in varchar2 default hr_api.g_varchar2
404: ,p_pei_information17 in varchar2 default hr_api.g_varchar2
405: ,p_pei_information18 in varchar2 default hr_api.g_varchar2
406: ,p_pei_information19 in varchar2 default hr_api.g_varchar2
407: ,p_pei_information20 in varchar2 default hr_api.g_varchar2

Line 404: ,p_pei_information17 in varchar2 default hr_api.g_varchar2

400: ,p_pei_information13 in varchar2 default hr_api.g_varchar2
401: ,p_pei_information14 in varchar2 default hr_api.g_varchar2
402: ,p_pei_information15 in varchar2 default hr_api.g_varchar2
403: ,p_pei_information16 in varchar2 default hr_api.g_varchar2
404: ,p_pei_information17 in varchar2 default hr_api.g_varchar2
405: ,p_pei_information18 in varchar2 default hr_api.g_varchar2
406: ,p_pei_information19 in varchar2 default hr_api.g_varchar2
407: ,p_pei_information20 in varchar2 default hr_api.g_varchar2
408: ,p_pei_information21 in varchar2 default hr_api.g_varchar2

Line 405: ,p_pei_information18 in varchar2 default hr_api.g_varchar2

401: ,p_pei_information14 in varchar2 default hr_api.g_varchar2
402: ,p_pei_information15 in varchar2 default hr_api.g_varchar2
403: ,p_pei_information16 in varchar2 default hr_api.g_varchar2
404: ,p_pei_information17 in varchar2 default hr_api.g_varchar2
405: ,p_pei_information18 in varchar2 default hr_api.g_varchar2
406: ,p_pei_information19 in varchar2 default hr_api.g_varchar2
407: ,p_pei_information20 in varchar2 default hr_api.g_varchar2
408: ,p_pei_information21 in varchar2 default hr_api.g_varchar2
409: ,p_pei_information22 in varchar2 default hr_api.g_varchar2

Line 406: ,p_pei_information19 in varchar2 default hr_api.g_varchar2

402: ,p_pei_information15 in varchar2 default hr_api.g_varchar2
403: ,p_pei_information16 in varchar2 default hr_api.g_varchar2
404: ,p_pei_information17 in varchar2 default hr_api.g_varchar2
405: ,p_pei_information18 in varchar2 default hr_api.g_varchar2
406: ,p_pei_information19 in varchar2 default hr_api.g_varchar2
407: ,p_pei_information20 in varchar2 default hr_api.g_varchar2
408: ,p_pei_information21 in varchar2 default hr_api.g_varchar2
409: ,p_pei_information22 in varchar2 default hr_api.g_varchar2
410: ,p_pei_information23 in varchar2 default hr_api.g_varchar2

Line 407: ,p_pei_information20 in varchar2 default hr_api.g_varchar2

403: ,p_pei_information16 in varchar2 default hr_api.g_varchar2
404: ,p_pei_information17 in varchar2 default hr_api.g_varchar2
405: ,p_pei_information18 in varchar2 default hr_api.g_varchar2
406: ,p_pei_information19 in varchar2 default hr_api.g_varchar2
407: ,p_pei_information20 in varchar2 default hr_api.g_varchar2
408: ,p_pei_information21 in varchar2 default hr_api.g_varchar2
409: ,p_pei_information22 in varchar2 default hr_api.g_varchar2
410: ,p_pei_information23 in varchar2 default hr_api.g_varchar2
411: ,p_pei_information24 in varchar2 default hr_api.g_varchar2

Line 408: ,p_pei_information21 in varchar2 default hr_api.g_varchar2

404: ,p_pei_information17 in varchar2 default hr_api.g_varchar2
405: ,p_pei_information18 in varchar2 default hr_api.g_varchar2
406: ,p_pei_information19 in varchar2 default hr_api.g_varchar2
407: ,p_pei_information20 in varchar2 default hr_api.g_varchar2
408: ,p_pei_information21 in varchar2 default hr_api.g_varchar2
409: ,p_pei_information22 in varchar2 default hr_api.g_varchar2
410: ,p_pei_information23 in varchar2 default hr_api.g_varchar2
411: ,p_pei_information24 in varchar2 default hr_api.g_varchar2
412: ,p_pei_information25 in varchar2 default hr_api.g_varchar2

Line 409: ,p_pei_information22 in varchar2 default hr_api.g_varchar2

405: ,p_pei_information18 in varchar2 default hr_api.g_varchar2
406: ,p_pei_information19 in varchar2 default hr_api.g_varchar2
407: ,p_pei_information20 in varchar2 default hr_api.g_varchar2
408: ,p_pei_information21 in varchar2 default hr_api.g_varchar2
409: ,p_pei_information22 in varchar2 default hr_api.g_varchar2
410: ,p_pei_information23 in varchar2 default hr_api.g_varchar2
411: ,p_pei_information24 in varchar2 default hr_api.g_varchar2
412: ,p_pei_information25 in varchar2 default hr_api.g_varchar2
413: ,p_pei_information26 in varchar2 default hr_api.g_varchar2

Line 410: ,p_pei_information23 in varchar2 default hr_api.g_varchar2

406: ,p_pei_information19 in varchar2 default hr_api.g_varchar2
407: ,p_pei_information20 in varchar2 default hr_api.g_varchar2
408: ,p_pei_information21 in varchar2 default hr_api.g_varchar2
409: ,p_pei_information22 in varchar2 default hr_api.g_varchar2
410: ,p_pei_information23 in varchar2 default hr_api.g_varchar2
411: ,p_pei_information24 in varchar2 default hr_api.g_varchar2
412: ,p_pei_information25 in varchar2 default hr_api.g_varchar2
413: ,p_pei_information26 in varchar2 default hr_api.g_varchar2
414: ,p_pei_information27 in varchar2 default hr_api.g_varchar2

Line 411: ,p_pei_information24 in varchar2 default hr_api.g_varchar2

407: ,p_pei_information20 in varchar2 default hr_api.g_varchar2
408: ,p_pei_information21 in varchar2 default hr_api.g_varchar2
409: ,p_pei_information22 in varchar2 default hr_api.g_varchar2
410: ,p_pei_information23 in varchar2 default hr_api.g_varchar2
411: ,p_pei_information24 in varchar2 default hr_api.g_varchar2
412: ,p_pei_information25 in varchar2 default hr_api.g_varchar2
413: ,p_pei_information26 in varchar2 default hr_api.g_varchar2
414: ,p_pei_information27 in varchar2 default hr_api.g_varchar2
415: ,p_pei_information28 in varchar2 default hr_api.g_varchar2

Line 412: ,p_pei_information25 in varchar2 default hr_api.g_varchar2

408: ,p_pei_information21 in varchar2 default hr_api.g_varchar2
409: ,p_pei_information22 in varchar2 default hr_api.g_varchar2
410: ,p_pei_information23 in varchar2 default hr_api.g_varchar2
411: ,p_pei_information24 in varchar2 default hr_api.g_varchar2
412: ,p_pei_information25 in varchar2 default hr_api.g_varchar2
413: ,p_pei_information26 in varchar2 default hr_api.g_varchar2
414: ,p_pei_information27 in varchar2 default hr_api.g_varchar2
415: ,p_pei_information28 in varchar2 default hr_api.g_varchar2
416: ,p_pei_information29 in varchar2 default hr_api.g_varchar2

Line 413: ,p_pei_information26 in varchar2 default hr_api.g_varchar2

409: ,p_pei_information22 in varchar2 default hr_api.g_varchar2
410: ,p_pei_information23 in varchar2 default hr_api.g_varchar2
411: ,p_pei_information24 in varchar2 default hr_api.g_varchar2
412: ,p_pei_information25 in varchar2 default hr_api.g_varchar2
413: ,p_pei_information26 in varchar2 default hr_api.g_varchar2
414: ,p_pei_information27 in varchar2 default hr_api.g_varchar2
415: ,p_pei_information28 in varchar2 default hr_api.g_varchar2
416: ,p_pei_information29 in varchar2 default hr_api.g_varchar2
417: ,p_pei_information30 in varchar2 default hr_api.g_varchar2

Line 414: ,p_pei_information27 in varchar2 default hr_api.g_varchar2

410: ,p_pei_information23 in varchar2 default hr_api.g_varchar2
411: ,p_pei_information24 in varchar2 default hr_api.g_varchar2
412: ,p_pei_information25 in varchar2 default hr_api.g_varchar2
413: ,p_pei_information26 in varchar2 default hr_api.g_varchar2
414: ,p_pei_information27 in varchar2 default hr_api.g_varchar2
415: ,p_pei_information28 in varchar2 default hr_api.g_varchar2
416: ,p_pei_information29 in varchar2 default hr_api.g_varchar2
417: ,p_pei_information30 in varchar2 default hr_api.g_varchar2
418: ) is

Line 415: ,p_pei_information28 in varchar2 default hr_api.g_varchar2

411: ,p_pei_information24 in varchar2 default hr_api.g_varchar2
412: ,p_pei_information25 in varchar2 default hr_api.g_varchar2
413: ,p_pei_information26 in varchar2 default hr_api.g_varchar2
414: ,p_pei_information27 in varchar2 default hr_api.g_varchar2
415: ,p_pei_information28 in varchar2 default hr_api.g_varchar2
416: ,p_pei_information29 in varchar2 default hr_api.g_varchar2
417: ,p_pei_information30 in varchar2 default hr_api.g_varchar2
418: ) is
419: --

Line 416: ,p_pei_information29 in varchar2 default hr_api.g_varchar2

412: ,p_pei_information25 in varchar2 default hr_api.g_varchar2
413: ,p_pei_information26 in varchar2 default hr_api.g_varchar2
414: ,p_pei_information27 in varchar2 default hr_api.g_varchar2
415: ,p_pei_information28 in varchar2 default hr_api.g_varchar2
416: ,p_pei_information29 in varchar2 default hr_api.g_varchar2
417: ,p_pei_information30 in varchar2 default hr_api.g_varchar2
418: ) is
419: --
420: -- Declare cursors and local variables

Line 417: ,p_pei_information30 in varchar2 default hr_api.g_varchar2

413: ,p_pei_information26 in varchar2 default hr_api.g_varchar2
414: ,p_pei_information27 in varchar2 default hr_api.g_varchar2
415: ,p_pei_information28 in varchar2 default hr_api.g_varchar2
416: ,p_pei_information29 in varchar2 default hr_api.g_varchar2
417: ,p_pei_information30 in varchar2 default hr_api.g_varchar2
418: ) is
419: --
420: -- Declare cursors and local variables
421: --

Line 493: when hr_api.cannot_find_prog_unit then

489: p_pei_information30 => p_pei_information30,
490: p_object_version_number => p_object_version_number
491: );
492: exception
493: when hr_api.cannot_find_prog_unit then
494: hr_api.cannot_find_prog_unit_error
495: (p_module_name => 'UPDATE_PERSON_EXTRA_INFO',
496: p_hook_type => 'BP'
497: );

Line 494: hr_api.cannot_find_prog_unit_error

490: p_object_version_number => p_object_version_number
491: );
492: exception
493: when hr_api.cannot_find_prog_unit then
494: hr_api.cannot_find_prog_unit_error
495: (p_module_name => 'UPDATE_PERSON_EXTRA_INFO',
496: p_hook_type => 'BP'
497: );
498: end;

Line 631: when hr_api.cannot_find_prog_unit then

627: p_pei_information30 => p_pei_information30,
628: p_object_version_number => p_object_version_number
629: );
630: exception
631: when hr_api.cannot_find_prog_unit then
632: hr_api.cannot_find_prog_unit_error
633: (p_module_name => 'UPDATE_PERSON_EXTRA_INFO',
634: p_hook_type => 'AP'
635: );

Line 632: hr_api.cannot_find_prog_unit_error

628: p_object_version_number => p_object_version_number
629: );
630: exception
631: when hr_api.cannot_find_prog_unit then
632: hr_api.cannot_find_prog_unit_error
633: (p_module_name => 'UPDATE_PERSON_EXTRA_INFO',
634: p_hook_type => 'AP'
635: );
636: end;

Line 643: raise hr_api.validate_enabled;

639: --
640: -- When in validation only mode raise the Validate_Enabled exception
641: --
642: if p_validate then
643: raise hr_api.validate_enabled;
644: end if;
645: --
646: hr_utility.set_location(' Leaving:'||l_proc, 11);
647: exception

Line 648: when hr_api.validate_enabled then

644: end if;
645: --
646: hr_utility.set_location(' Leaving:'||l_proc, 11);
647: exception
648: when hr_api.validate_enabled then
649: --
650: -- As the Validate_Enabled exception has been raised
651: -- we must rollback to the savepoint
652: --

Line 709: when hr_api.cannot_find_prog_unit then

705: (p_person_extra_info_id => p_person_extra_info_id,
706: p_object_version_number => p_object_version_number
707: );
708: exception
709: when hr_api.cannot_find_prog_unit then
710: hr_api.cannot_find_prog_unit_error
711: (p_module_name => 'DELETE_PERSON_EXTRA_INFO',
712: p_hook_type => 'BP'
713: );

Line 710: hr_api.cannot_find_prog_unit_error

706: p_object_version_number => p_object_version_number
707: );
708: exception
709: when hr_api.cannot_find_prog_unit then
710: hr_api.cannot_find_prog_unit_error
711: (p_module_name => 'DELETE_PERSON_EXTRA_INFO',
712: p_hook_type => 'BP'
713: );
714: end;

Line 738: when hr_api.cannot_find_prog_unit then

734: (p_person_extra_info_id => p_person_extra_info_id,
735: p_object_version_number => p_object_version_number
736: );
737: exception
738: when hr_api.cannot_find_prog_unit then
739: hr_api.cannot_find_prog_unit_error
740: (p_module_name => 'DELETE_PERSON_EXTRA_INFO',
741: p_hook_type => 'AP'
742: );

Line 739: hr_api.cannot_find_prog_unit_error

735: p_object_version_number => p_object_version_number
736: );
737: exception
738: when hr_api.cannot_find_prog_unit then
739: hr_api.cannot_find_prog_unit_error
740: (p_module_name => 'DELETE_PERSON_EXTRA_INFO',
741: p_hook_type => 'AP'
742: );
743: end;

Line 750: raise hr_api.validate_enabled;

746: --
747: -- When in validation only mode raise the Validate_Enabled exception
748: --
749: if p_validate then
750: raise hr_api.validate_enabled;
751: end if;
752: --
753: hr_utility.set_location(' Leaving:'||l_proc, 11);
754: exception

Line 755: when hr_api.validate_enabled then

751: end if;
752: --
753: hr_utility.set_location(' Leaving:'||l_proc, 11);
754: exception
755: when hr_api.validate_enabled then
756: --
757: -- As the Validate_Enabled exception has been raised
758: -- we must rollback to the savepoint
759: --