eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LOCATION_EXTRA_INFO_API dependencies on HR_API

Line 158: when hr_api.cannot_find_prog_unit then

154: p_lei_information29 => p_lei_information29,
155: p_lei_information30 => p_lei_information30
156: );
157: exception
158: when hr_api.cannot_find_prog_unit then
159: hr_api.cannot_find_prog_unit_error
160: (p_module_name => 'CREATE_LOCATION_EXTRA_INFO',
161: p_hook_type => 'BP'
162: );

Line 159: hr_api.cannot_find_prog_unit_error

155: p_lei_information30 => p_lei_information30
156: );
157: exception
158: when hr_api.cannot_find_prog_unit then
159: hr_api.cannot_find_prog_unit_error
160: (p_module_name => 'CREATE_LOCATION_EXTRA_INFO',
161: p_hook_type => 'BP'
162: );
163: end;

Line 299: when hr_api.cannot_find_prog_unit then

295: p_lei_information30 => p_lei_information30,
296: p_object_version_number => l_object_version_number
297: );
298: exception
299: when hr_api.cannot_find_prog_unit then
300: -- Set OUT parameters to null
301: p_location_extra_info_id := null;
302: p_object_version_number := null;
303:

Line 304: hr_api.cannot_find_prog_unit_error

300: -- Set OUT parameters to null
301: p_location_extra_info_id := null;
302: p_object_version_number := null;
303:
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'CREATE_LOCATION_EXTRA_INFO',
306: p_hook_type => 'AP'
307: );
308: end;

Line 313: raise hr_api.validate_enabled;

309: --
310: -- When in validation only mode raise the Validate_Enabled exception
311: --
312: if p_validate then
313: raise hr_api.validate_enabled;
314: end if;
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 11);
317: exception

Line 318: when hr_api.validate_enabled then

314: end if;
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 11);
317: exception
318: when hr_api.validate_enabled then
319: --
320: -- As the Validate_Enabled exception has been raised
321: -- we must rollback to the savepoint
322: --

Line 357: ,p_lei_attribute_category in varchar2 default hr_api.g_varchar2

353: procedure update_location_extra_info
354: (p_validate in boolean default false
355: ,p_location_extra_info_id in number
356: ,p_object_version_number in out nocopy number
357: ,p_lei_attribute_category in varchar2 default hr_api.g_varchar2
358: ,p_lei_attribute1 in varchar2 default hr_api.g_varchar2
359: ,p_lei_attribute2 in varchar2 default hr_api.g_varchar2
360: ,p_lei_attribute3 in varchar2 default hr_api.g_varchar2
361: ,p_lei_attribute4 in varchar2 default hr_api.g_varchar2

Line 358: ,p_lei_attribute1 in varchar2 default hr_api.g_varchar2

354: (p_validate in boolean default false
355: ,p_location_extra_info_id in number
356: ,p_object_version_number in out nocopy number
357: ,p_lei_attribute_category in varchar2 default hr_api.g_varchar2
358: ,p_lei_attribute1 in varchar2 default hr_api.g_varchar2
359: ,p_lei_attribute2 in varchar2 default hr_api.g_varchar2
360: ,p_lei_attribute3 in varchar2 default hr_api.g_varchar2
361: ,p_lei_attribute4 in varchar2 default hr_api.g_varchar2
362: ,p_lei_attribute5 in varchar2 default hr_api.g_varchar2

Line 359: ,p_lei_attribute2 in varchar2 default hr_api.g_varchar2

355: ,p_location_extra_info_id in number
356: ,p_object_version_number in out nocopy number
357: ,p_lei_attribute_category in varchar2 default hr_api.g_varchar2
358: ,p_lei_attribute1 in varchar2 default hr_api.g_varchar2
359: ,p_lei_attribute2 in varchar2 default hr_api.g_varchar2
360: ,p_lei_attribute3 in varchar2 default hr_api.g_varchar2
361: ,p_lei_attribute4 in varchar2 default hr_api.g_varchar2
362: ,p_lei_attribute5 in varchar2 default hr_api.g_varchar2
363: ,p_lei_attribute6 in varchar2 default hr_api.g_varchar2

Line 360: ,p_lei_attribute3 in varchar2 default hr_api.g_varchar2

356: ,p_object_version_number in out nocopy number
357: ,p_lei_attribute_category in varchar2 default hr_api.g_varchar2
358: ,p_lei_attribute1 in varchar2 default hr_api.g_varchar2
359: ,p_lei_attribute2 in varchar2 default hr_api.g_varchar2
360: ,p_lei_attribute3 in varchar2 default hr_api.g_varchar2
361: ,p_lei_attribute4 in varchar2 default hr_api.g_varchar2
362: ,p_lei_attribute5 in varchar2 default hr_api.g_varchar2
363: ,p_lei_attribute6 in varchar2 default hr_api.g_varchar2
364: ,p_lei_attribute7 in varchar2 default hr_api.g_varchar2

Line 361: ,p_lei_attribute4 in varchar2 default hr_api.g_varchar2

357: ,p_lei_attribute_category in varchar2 default hr_api.g_varchar2
358: ,p_lei_attribute1 in varchar2 default hr_api.g_varchar2
359: ,p_lei_attribute2 in varchar2 default hr_api.g_varchar2
360: ,p_lei_attribute3 in varchar2 default hr_api.g_varchar2
361: ,p_lei_attribute4 in varchar2 default hr_api.g_varchar2
362: ,p_lei_attribute5 in varchar2 default hr_api.g_varchar2
363: ,p_lei_attribute6 in varchar2 default hr_api.g_varchar2
364: ,p_lei_attribute7 in varchar2 default hr_api.g_varchar2
365: ,p_lei_attribute8 in varchar2 default hr_api.g_varchar2

Line 362: ,p_lei_attribute5 in varchar2 default hr_api.g_varchar2

358: ,p_lei_attribute1 in varchar2 default hr_api.g_varchar2
359: ,p_lei_attribute2 in varchar2 default hr_api.g_varchar2
360: ,p_lei_attribute3 in varchar2 default hr_api.g_varchar2
361: ,p_lei_attribute4 in varchar2 default hr_api.g_varchar2
362: ,p_lei_attribute5 in varchar2 default hr_api.g_varchar2
363: ,p_lei_attribute6 in varchar2 default hr_api.g_varchar2
364: ,p_lei_attribute7 in varchar2 default hr_api.g_varchar2
365: ,p_lei_attribute8 in varchar2 default hr_api.g_varchar2
366: ,p_lei_attribute9 in varchar2 default hr_api.g_varchar2

Line 363: ,p_lei_attribute6 in varchar2 default hr_api.g_varchar2

359: ,p_lei_attribute2 in varchar2 default hr_api.g_varchar2
360: ,p_lei_attribute3 in varchar2 default hr_api.g_varchar2
361: ,p_lei_attribute4 in varchar2 default hr_api.g_varchar2
362: ,p_lei_attribute5 in varchar2 default hr_api.g_varchar2
363: ,p_lei_attribute6 in varchar2 default hr_api.g_varchar2
364: ,p_lei_attribute7 in varchar2 default hr_api.g_varchar2
365: ,p_lei_attribute8 in varchar2 default hr_api.g_varchar2
366: ,p_lei_attribute9 in varchar2 default hr_api.g_varchar2
367: ,p_lei_attribute10 in varchar2 default hr_api.g_varchar2

Line 364: ,p_lei_attribute7 in varchar2 default hr_api.g_varchar2

360: ,p_lei_attribute3 in varchar2 default hr_api.g_varchar2
361: ,p_lei_attribute4 in varchar2 default hr_api.g_varchar2
362: ,p_lei_attribute5 in varchar2 default hr_api.g_varchar2
363: ,p_lei_attribute6 in varchar2 default hr_api.g_varchar2
364: ,p_lei_attribute7 in varchar2 default hr_api.g_varchar2
365: ,p_lei_attribute8 in varchar2 default hr_api.g_varchar2
366: ,p_lei_attribute9 in varchar2 default hr_api.g_varchar2
367: ,p_lei_attribute10 in varchar2 default hr_api.g_varchar2
368: ,p_lei_attribute11 in varchar2 default hr_api.g_varchar2

Line 365: ,p_lei_attribute8 in varchar2 default hr_api.g_varchar2

361: ,p_lei_attribute4 in varchar2 default hr_api.g_varchar2
362: ,p_lei_attribute5 in varchar2 default hr_api.g_varchar2
363: ,p_lei_attribute6 in varchar2 default hr_api.g_varchar2
364: ,p_lei_attribute7 in varchar2 default hr_api.g_varchar2
365: ,p_lei_attribute8 in varchar2 default hr_api.g_varchar2
366: ,p_lei_attribute9 in varchar2 default hr_api.g_varchar2
367: ,p_lei_attribute10 in varchar2 default hr_api.g_varchar2
368: ,p_lei_attribute11 in varchar2 default hr_api.g_varchar2
369: ,p_lei_attribute12 in varchar2 default hr_api.g_varchar2

Line 366: ,p_lei_attribute9 in varchar2 default hr_api.g_varchar2

362: ,p_lei_attribute5 in varchar2 default hr_api.g_varchar2
363: ,p_lei_attribute6 in varchar2 default hr_api.g_varchar2
364: ,p_lei_attribute7 in varchar2 default hr_api.g_varchar2
365: ,p_lei_attribute8 in varchar2 default hr_api.g_varchar2
366: ,p_lei_attribute9 in varchar2 default hr_api.g_varchar2
367: ,p_lei_attribute10 in varchar2 default hr_api.g_varchar2
368: ,p_lei_attribute11 in varchar2 default hr_api.g_varchar2
369: ,p_lei_attribute12 in varchar2 default hr_api.g_varchar2
370: ,p_lei_attribute13 in varchar2 default hr_api.g_varchar2

Line 367: ,p_lei_attribute10 in varchar2 default hr_api.g_varchar2

363: ,p_lei_attribute6 in varchar2 default hr_api.g_varchar2
364: ,p_lei_attribute7 in varchar2 default hr_api.g_varchar2
365: ,p_lei_attribute8 in varchar2 default hr_api.g_varchar2
366: ,p_lei_attribute9 in varchar2 default hr_api.g_varchar2
367: ,p_lei_attribute10 in varchar2 default hr_api.g_varchar2
368: ,p_lei_attribute11 in varchar2 default hr_api.g_varchar2
369: ,p_lei_attribute12 in varchar2 default hr_api.g_varchar2
370: ,p_lei_attribute13 in varchar2 default hr_api.g_varchar2
371: ,p_lei_attribute14 in varchar2 default hr_api.g_varchar2

Line 368: ,p_lei_attribute11 in varchar2 default hr_api.g_varchar2

364: ,p_lei_attribute7 in varchar2 default hr_api.g_varchar2
365: ,p_lei_attribute8 in varchar2 default hr_api.g_varchar2
366: ,p_lei_attribute9 in varchar2 default hr_api.g_varchar2
367: ,p_lei_attribute10 in varchar2 default hr_api.g_varchar2
368: ,p_lei_attribute11 in varchar2 default hr_api.g_varchar2
369: ,p_lei_attribute12 in varchar2 default hr_api.g_varchar2
370: ,p_lei_attribute13 in varchar2 default hr_api.g_varchar2
371: ,p_lei_attribute14 in varchar2 default hr_api.g_varchar2
372: ,p_lei_attribute15 in varchar2 default hr_api.g_varchar2

Line 369: ,p_lei_attribute12 in varchar2 default hr_api.g_varchar2

365: ,p_lei_attribute8 in varchar2 default hr_api.g_varchar2
366: ,p_lei_attribute9 in varchar2 default hr_api.g_varchar2
367: ,p_lei_attribute10 in varchar2 default hr_api.g_varchar2
368: ,p_lei_attribute11 in varchar2 default hr_api.g_varchar2
369: ,p_lei_attribute12 in varchar2 default hr_api.g_varchar2
370: ,p_lei_attribute13 in varchar2 default hr_api.g_varchar2
371: ,p_lei_attribute14 in varchar2 default hr_api.g_varchar2
372: ,p_lei_attribute15 in varchar2 default hr_api.g_varchar2
373: ,p_lei_attribute16 in varchar2 default hr_api.g_varchar2

Line 370: ,p_lei_attribute13 in varchar2 default hr_api.g_varchar2

366: ,p_lei_attribute9 in varchar2 default hr_api.g_varchar2
367: ,p_lei_attribute10 in varchar2 default hr_api.g_varchar2
368: ,p_lei_attribute11 in varchar2 default hr_api.g_varchar2
369: ,p_lei_attribute12 in varchar2 default hr_api.g_varchar2
370: ,p_lei_attribute13 in varchar2 default hr_api.g_varchar2
371: ,p_lei_attribute14 in varchar2 default hr_api.g_varchar2
372: ,p_lei_attribute15 in varchar2 default hr_api.g_varchar2
373: ,p_lei_attribute16 in varchar2 default hr_api.g_varchar2
374: ,p_lei_attribute17 in varchar2 default hr_api.g_varchar2

Line 371: ,p_lei_attribute14 in varchar2 default hr_api.g_varchar2

367: ,p_lei_attribute10 in varchar2 default hr_api.g_varchar2
368: ,p_lei_attribute11 in varchar2 default hr_api.g_varchar2
369: ,p_lei_attribute12 in varchar2 default hr_api.g_varchar2
370: ,p_lei_attribute13 in varchar2 default hr_api.g_varchar2
371: ,p_lei_attribute14 in varchar2 default hr_api.g_varchar2
372: ,p_lei_attribute15 in varchar2 default hr_api.g_varchar2
373: ,p_lei_attribute16 in varchar2 default hr_api.g_varchar2
374: ,p_lei_attribute17 in varchar2 default hr_api.g_varchar2
375: ,p_lei_attribute18 in varchar2 default hr_api.g_varchar2

Line 372: ,p_lei_attribute15 in varchar2 default hr_api.g_varchar2

368: ,p_lei_attribute11 in varchar2 default hr_api.g_varchar2
369: ,p_lei_attribute12 in varchar2 default hr_api.g_varchar2
370: ,p_lei_attribute13 in varchar2 default hr_api.g_varchar2
371: ,p_lei_attribute14 in varchar2 default hr_api.g_varchar2
372: ,p_lei_attribute15 in varchar2 default hr_api.g_varchar2
373: ,p_lei_attribute16 in varchar2 default hr_api.g_varchar2
374: ,p_lei_attribute17 in varchar2 default hr_api.g_varchar2
375: ,p_lei_attribute18 in varchar2 default hr_api.g_varchar2
376: ,p_lei_attribute19 in varchar2 default hr_api.g_varchar2

Line 373: ,p_lei_attribute16 in varchar2 default hr_api.g_varchar2

369: ,p_lei_attribute12 in varchar2 default hr_api.g_varchar2
370: ,p_lei_attribute13 in varchar2 default hr_api.g_varchar2
371: ,p_lei_attribute14 in varchar2 default hr_api.g_varchar2
372: ,p_lei_attribute15 in varchar2 default hr_api.g_varchar2
373: ,p_lei_attribute16 in varchar2 default hr_api.g_varchar2
374: ,p_lei_attribute17 in varchar2 default hr_api.g_varchar2
375: ,p_lei_attribute18 in varchar2 default hr_api.g_varchar2
376: ,p_lei_attribute19 in varchar2 default hr_api.g_varchar2
377: ,p_lei_attribute20 in varchar2 default hr_api.g_varchar2

Line 374: ,p_lei_attribute17 in varchar2 default hr_api.g_varchar2

370: ,p_lei_attribute13 in varchar2 default hr_api.g_varchar2
371: ,p_lei_attribute14 in varchar2 default hr_api.g_varchar2
372: ,p_lei_attribute15 in varchar2 default hr_api.g_varchar2
373: ,p_lei_attribute16 in varchar2 default hr_api.g_varchar2
374: ,p_lei_attribute17 in varchar2 default hr_api.g_varchar2
375: ,p_lei_attribute18 in varchar2 default hr_api.g_varchar2
376: ,p_lei_attribute19 in varchar2 default hr_api.g_varchar2
377: ,p_lei_attribute20 in varchar2 default hr_api.g_varchar2
378: ,p_lei_information_category in varchar2 default hr_api.g_varchar2

Line 375: ,p_lei_attribute18 in varchar2 default hr_api.g_varchar2

371: ,p_lei_attribute14 in varchar2 default hr_api.g_varchar2
372: ,p_lei_attribute15 in varchar2 default hr_api.g_varchar2
373: ,p_lei_attribute16 in varchar2 default hr_api.g_varchar2
374: ,p_lei_attribute17 in varchar2 default hr_api.g_varchar2
375: ,p_lei_attribute18 in varchar2 default hr_api.g_varchar2
376: ,p_lei_attribute19 in varchar2 default hr_api.g_varchar2
377: ,p_lei_attribute20 in varchar2 default hr_api.g_varchar2
378: ,p_lei_information_category in varchar2 default hr_api.g_varchar2
379: ,p_lei_information1 in varchar2 default hr_api.g_varchar2

Line 376: ,p_lei_attribute19 in varchar2 default hr_api.g_varchar2

372: ,p_lei_attribute15 in varchar2 default hr_api.g_varchar2
373: ,p_lei_attribute16 in varchar2 default hr_api.g_varchar2
374: ,p_lei_attribute17 in varchar2 default hr_api.g_varchar2
375: ,p_lei_attribute18 in varchar2 default hr_api.g_varchar2
376: ,p_lei_attribute19 in varchar2 default hr_api.g_varchar2
377: ,p_lei_attribute20 in varchar2 default hr_api.g_varchar2
378: ,p_lei_information_category in varchar2 default hr_api.g_varchar2
379: ,p_lei_information1 in varchar2 default hr_api.g_varchar2
380: ,p_lei_information2 in varchar2 default hr_api.g_varchar2

Line 377: ,p_lei_attribute20 in varchar2 default hr_api.g_varchar2

373: ,p_lei_attribute16 in varchar2 default hr_api.g_varchar2
374: ,p_lei_attribute17 in varchar2 default hr_api.g_varchar2
375: ,p_lei_attribute18 in varchar2 default hr_api.g_varchar2
376: ,p_lei_attribute19 in varchar2 default hr_api.g_varchar2
377: ,p_lei_attribute20 in varchar2 default hr_api.g_varchar2
378: ,p_lei_information_category in varchar2 default hr_api.g_varchar2
379: ,p_lei_information1 in varchar2 default hr_api.g_varchar2
380: ,p_lei_information2 in varchar2 default hr_api.g_varchar2
381: ,p_lei_information3 in varchar2 default hr_api.g_varchar2

Line 378: ,p_lei_information_category in varchar2 default hr_api.g_varchar2

374: ,p_lei_attribute17 in varchar2 default hr_api.g_varchar2
375: ,p_lei_attribute18 in varchar2 default hr_api.g_varchar2
376: ,p_lei_attribute19 in varchar2 default hr_api.g_varchar2
377: ,p_lei_attribute20 in varchar2 default hr_api.g_varchar2
378: ,p_lei_information_category in varchar2 default hr_api.g_varchar2
379: ,p_lei_information1 in varchar2 default hr_api.g_varchar2
380: ,p_lei_information2 in varchar2 default hr_api.g_varchar2
381: ,p_lei_information3 in varchar2 default hr_api.g_varchar2
382: ,p_lei_information4 in varchar2 default hr_api.g_varchar2

Line 379: ,p_lei_information1 in varchar2 default hr_api.g_varchar2

375: ,p_lei_attribute18 in varchar2 default hr_api.g_varchar2
376: ,p_lei_attribute19 in varchar2 default hr_api.g_varchar2
377: ,p_lei_attribute20 in varchar2 default hr_api.g_varchar2
378: ,p_lei_information_category in varchar2 default hr_api.g_varchar2
379: ,p_lei_information1 in varchar2 default hr_api.g_varchar2
380: ,p_lei_information2 in varchar2 default hr_api.g_varchar2
381: ,p_lei_information3 in varchar2 default hr_api.g_varchar2
382: ,p_lei_information4 in varchar2 default hr_api.g_varchar2
383: ,p_lei_information5 in varchar2 default hr_api.g_varchar2

Line 380: ,p_lei_information2 in varchar2 default hr_api.g_varchar2

376: ,p_lei_attribute19 in varchar2 default hr_api.g_varchar2
377: ,p_lei_attribute20 in varchar2 default hr_api.g_varchar2
378: ,p_lei_information_category in varchar2 default hr_api.g_varchar2
379: ,p_lei_information1 in varchar2 default hr_api.g_varchar2
380: ,p_lei_information2 in varchar2 default hr_api.g_varchar2
381: ,p_lei_information3 in varchar2 default hr_api.g_varchar2
382: ,p_lei_information4 in varchar2 default hr_api.g_varchar2
383: ,p_lei_information5 in varchar2 default hr_api.g_varchar2
384: ,p_lei_information6 in varchar2 default hr_api.g_varchar2

Line 381: ,p_lei_information3 in varchar2 default hr_api.g_varchar2

377: ,p_lei_attribute20 in varchar2 default hr_api.g_varchar2
378: ,p_lei_information_category in varchar2 default hr_api.g_varchar2
379: ,p_lei_information1 in varchar2 default hr_api.g_varchar2
380: ,p_lei_information2 in varchar2 default hr_api.g_varchar2
381: ,p_lei_information3 in varchar2 default hr_api.g_varchar2
382: ,p_lei_information4 in varchar2 default hr_api.g_varchar2
383: ,p_lei_information5 in varchar2 default hr_api.g_varchar2
384: ,p_lei_information6 in varchar2 default hr_api.g_varchar2
385: ,p_lei_information7 in varchar2 default hr_api.g_varchar2

Line 382: ,p_lei_information4 in varchar2 default hr_api.g_varchar2

378: ,p_lei_information_category in varchar2 default hr_api.g_varchar2
379: ,p_lei_information1 in varchar2 default hr_api.g_varchar2
380: ,p_lei_information2 in varchar2 default hr_api.g_varchar2
381: ,p_lei_information3 in varchar2 default hr_api.g_varchar2
382: ,p_lei_information4 in varchar2 default hr_api.g_varchar2
383: ,p_lei_information5 in varchar2 default hr_api.g_varchar2
384: ,p_lei_information6 in varchar2 default hr_api.g_varchar2
385: ,p_lei_information7 in varchar2 default hr_api.g_varchar2
386: ,p_lei_information8 in varchar2 default hr_api.g_varchar2

Line 383: ,p_lei_information5 in varchar2 default hr_api.g_varchar2

379: ,p_lei_information1 in varchar2 default hr_api.g_varchar2
380: ,p_lei_information2 in varchar2 default hr_api.g_varchar2
381: ,p_lei_information3 in varchar2 default hr_api.g_varchar2
382: ,p_lei_information4 in varchar2 default hr_api.g_varchar2
383: ,p_lei_information5 in varchar2 default hr_api.g_varchar2
384: ,p_lei_information6 in varchar2 default hr_api.g_varchar2
385: ,p_lei_information7 in varchar2 default hr_api.g_varchar2
386: ,p_lei_information8 in varchar2 default hr_api.g_varchar2
387: ,p_lei_information9 in varchar2 default hr_api.g_varchar2

Line 384: ,p_lei_information6 in varchar2 default hr_api.g_varchar2

380: ,p_lei_information2 in varchar2 default hr_api.g_varchar2
381: ,p_lei_information3 in varchar2 default hr_api.g_varchar2
382: ,p_lei_information4 in varchar2 default hr_api.g_varchar2
383: ,p_lei_information5 in varchar2 default hr_api.g_varchar2
384: ,p_lei_information6 in varchar2 default hr_api.g_varchar2
385: ,p_lei_information7 in varchar2 default hr_api.g_varchar2
386: ,p_lei_information8 in varchar2 default hr_api.g_varchar2
387: ,p_lei_information9 in varchar2 default hr_api.g_varchar2
388: ,p_lei_information10 in varchar2 default hr_api.g_varchar2

Line 385: ,p_lei_information7 in varchar2 default hr_api.g_varchar2

381: ,p_lei_information3 in varchar2 default hr_api.g_varchar2
382: ,p_lei_information4 in varchar2 default hr_api.g_varchar2
383: ,p_lei_information5 in varchar2 default hr_api.g_varchar2
384: ,p_lei_information6 in varchar2 default hr_api.g_varchar2
385: ,p_lei_information7 in varchar2 default hr_api.g_varchar2
386: ,p_lei_information8 in varchar2 default hr_api.g_varchar2
387: ,p_lei_information9 in varchar2 default hr_api.g_varchar2
388: ,p_lei_information10 in varchar2 default hr_api.g_varchar2
389: ,p_lei_information11 in varchar2 default hr_api.g_varchar2

Line 386: ,p_lei_information8 in varchar2 default hr_api.g_varchar2

382: ,p_lei_information4 in varchar2 default hr_api.g_varchar2
383: ,p_lei_information5 in varchar2 default hr_api.g_varchar2
384: ,p_lei_information6 in varchar2 default hr_api.g_varchar2
385: ,p_lei_information7 in varchar2 default hr_api.g_varchar2
386: ,p_lei_information8 in varchar2 default hr_api.g_varchar2
387: ,p_lei_information9 in varchar2 default hr_api.g_varchar2
388: ,p_lei_information10 in varchar2 default hr_api.g_varchar2
389: ,p_lei_information11 in varchar2 default hr_api.g_varchar2
390: ,p_lei_information12 in varchar2 default hr_api.g_varchar2

Line 387: ,p_lei_information9 in varchar2 default hr_api.g_varchar2

383: ,p_lei_information5 in varchar2 default hr_api.g_varchar2
384: ,p_lei_information6 in varchar2 default hr_api.g_varchar2
385: ,p_lei_information7 in varchar2 default hr_api.g_varchar2
386: ,p_lei_information8 in varchar2 default hr_api.g_varchar2
387: ,p_lei_information9 in varchar2 default hr_api.g_varchar2
388: ,p_lei_information10 in varchar2 default hr_api.g_varchar2
389: ,p_lei_information11 in varchar2 default hr_api.g_varchar2
390: ,p_lei_information12 in varchar2 default hr_api.g_varchar2
391: ,p_lei_information13 in varchar2 default hr_api.g_varchar2

Line 388: ,p_lei_information10 in varchar2 default hr_api.g_varchar2

384: ,p_lei_information6 in varchar2 default hr_api.g_varchar2
385: ,p_lei_information7 in varchar2 default hr_api.g_varchar2
386: ,p_lei_information8 in varchar2 default hr_api.g_varchar2
387: ,p_lei_information9 in varchar2 default hr_api.g_varchar2
388: ,p_lei_information10 in varchar2 default hr_api.g_varchar2
389: ,p_lei_information11 in varchar2 default hr_api.g_varchar2
390: ,p_lei_information12 in varchar2 default hr_api.g_varchar2
391: ,p_lei_information13 in varchar2 default hr_api.g_varchar2
392: ,p_lei_information14 in varchar2 default hr_api.g_varchar2

Line 389: ,p_lei_information11 in varchar2 default hr_api.g_varchar2

385: ,p_lei_information7 in varchar2 default hr_api.g_varchar2
386: ,p_lei_information8 in varchar2 default hr_api.g_varchar2
387: ,p_lei_information9 in varchar2 default hr_api.g_varchar2
388: ,p_lei_information10 in varchar2 default hr_api.g_varchar2
389: ,p_lei_information11 in varchar2 default hr_api.g_varchar2
390: ,p_lei_information12 in varchar2 default hr_api.g_varchar2
391: ,p_lei_information13 in varchar2 default hr_api.g_varchar2
392: ,p_lei_information14 in varchar2 default hr_api.g_varchar2
393: ,p_lei_information15 in varchar2 default hr_api.g_varchar2

Line 390: ,p_lei_information12 in varchar2 default hr_api.g_varchar2

386: ,p_lei_information8 in varchar2 default hr_api.g_varchar2
387: ,p_lei_information9 in varchar2 default hr_api.g_varchar2
388: ,p_lei_information10 in varchar2 default hr_api.g_varchar2
389: ,p_lei_information11 in varchar2 default hr_api.g_varchar2
390: ,p_lei_information12 in varchar2 default hr_api.g_varchar2
391: ,p_lei_information13 in varchar2 default hr_api.g_varchar2
392: ,p_lei_information14 in varchar2 default hr_api.g_varchar2
393: ,p_lei_information15 in varchar2 default hr_api.g_varchar2
394: ,p_lei_information16 in varchar2 default hr_api.g_varchar2

Line 391: ,p_lei_information13 in varchar2 default hr_api.g_varchar2

387: ,p_lei_information9 in varchar2 default hr_api.g_varchar2
388: ,p_lei_information10 in varchar2 default hr_api.g_varchar2
389: ,p_lei_information11 in varchar2 default hr_api.g_varchar2
390: ,p_lei_information12 in varchar2 default hr_api.g_varchar2
391: ,p_lei_information13 in varchar2 default hr_api.g_varchar2
392: ,p_lei_information14 in varchar2 default hr_api.g_varchar2
393: ,p_lei_information15 in varchar2 default hr_api.g_varchar2
394: ,p_lei_information16 in varchar2 default hr_api.g_varchar2
395: ,p_lei_information17 in varchar2 default hr_api.g_varchar2

Line 392: ,p_lei_information14 in varchar2 default hr_api.g_varchar2

388: ,p_lei_information10 in varchar2 default hr_api.g_varchar2
389: ,p_lei_information11 in varchar2 default hr_api.g_varchar2
390: ,p_lei_information12 in varchar2 default hr_api.g_varchar2
391: ,p_lei_information13 in varchar2 default hr_api.g_varchar2
392: ,p_lei_information14 in varchar2 default hr_api.g_varchar2
393: ,p_lei_information15 in varchar2 default hr_api.g_varchar2
394: ,p_lei_information16 in varchar2 default hr_api.g_varchar2
395: ,p_lei_information17 in varchar2 default hr_api.g_varchar2
396: ,p_lei_information18 in varchar2 default hr_api.g_varchar2

Line 393: ,p_lei_information15 in varchar2 default hr_api.g_varchar2

389: ,p_lei_information11 in varchar2 default hr_api.g_varchar2
390: ,p_lei_information12 in varchar2 default hr_api.g_varchar2
391: ,p_lei_information13 in varchar2 default hr_api.g_varchar2
392: ,p_lei_information14 in varchar2 default hr_api.g_varchar2
393: ,p_lei_information15 in varchar2 default hr_api.g_varchar2
394: ,p_lei_information16 in varchar2 default hr_api.g_varchar2
395: ,p_lei_information17 in varchar2 default hr_api.g_varchar2
396: ,p_lei_information18 in varchar2 default hr_api.g_varchar2
397: ,p_lei_information19 in varchar2 default hr_api.g_varchar2

Line 394: ,p_lei_information16 in varchar2 default hr_api.g_varchar2

390: ,p_lei_information12 in varchar2 default hr_api.g_varchar2
391: ,p_lei_information13 in varchar2 default hr_api.g_varchar2
392: ,p_lei_information14 in varchar2 default hr_api.g_varchar2
393: ,p_lei_information15 in varchar2 default hr_api.g_varchar2
394: ,p_lei_information16 in varchar2 default hr_api.g_varchar2
395: ,p_lei_information17 in varchar2 default hr_api.g_varchar2
396: ,p_lei_information18 in varchar2 default hr_api.g_varchar2
397: ,p_lei_information19 in varchar2 default hr_api.g_varchar2
398: ,p_lei_information20 in varchar2 default hr_api.g_varchar2

Line 395: ,p_lei_information17 in varchar2 default hr_api.g_varchar2

391: ,p_lei_information13 in varchar2 default hr_api.g_varchar2
392: ,p_lei_information14 in varchar2 default hr_api.g_varchar2
393: ,p_lei_information15 in varchar2 default hr_api.g_varchar2
394: ,p_lei_information16 in varchar2 default hr_api.g_varchar2
395: ,p_lei_information17 in varchar2 default hr_api.g_varchar2
396: ,p_lei_information18 in varchar2 default hr_api.g_varchar2
397: ,p_lei_information19 in varchar2 default hr_api.g_varchar2
398: ,p_lei_information20 in varchar2 default hr_api.g_varchar2
399: ,p_lei_information21 in varchar2 default hr_api.g_varchar2

Line 396: ,p_lei_information18 in varchar2 default hr_api.g_varchar2

392: ,p_lei_information14 in varchar2 default hr_api.g_varchar2
393: ,p_lei_information15 in varchar2 default hr_api.g_varchar2
394: ,p_lei_information16 in varchar2 default hr_api.g_varchar2
395: ,p_lei_information17 in varchar2 default hr_api.g_varchar2
396: ,p_lei_information18 in varchar2 default hr_api.g_varchar2
397: ,p_lei_information19 in varchar2 default hr_api.g_varchar2
398: ,p_lei_information20 in varchar2 default hr_api.g_varchar2
399: ,p_lei_information21 in varchar2 default hr_api.g_varchar2
400: ,p_lei_information22 in varchar2 default hr_api.g_varchar2

Line 397: ,p_lei_information19 in varchar2 default hr_api.g_varchar2

393: ,p_lei_information15 in varchar2 default hr_api.g_varchar2
394: ,p_lei_information16 in varchar2 default hr_api.g_varchar2
395: ,p_lei_information17 in varchar2 default hr_api.g_varchar2
396: ,p_lei_information18 in varchar2 default hr_api.g_varchar2
397: ,p_lei_information19 in varchar2 default hr_api.g_varchar2
398: ,p_lei_information20 in varchar2 default hr_api.g_varchar2
399: ,p_lei_information21 in varchar2 default hr_api.g_varchar2
400: ,p_lei_information22 in varchar2 default hr_api.g_varchar2
401: ,p_lei_information23 in varchar2 default hr_api.g_varchar2

Line 398: ,p_lei_information20 in varchar2 default hr_api.g_varchar2

394: ,p_lei_information16 in varchar2 default hr_api.g_varchar2
395: ,p_lei_information17 in varchar2 default hr_api.g_varchar2
396: ,p_lei_information18 in varchar2 default hr_api.g_varchar2
397: ,p_lei_information19 in varchar2 default hr_api.g_varchar2
398: ,p_lei_information20 in varchar2 default hr_api.g_varchar2
399: ,p_lei_information21 in varchar2 default hr_api.g_varchar2
400: ,p_lei_information22 in varchar2 default hr_api.g_varchar2
401: ,p_lei_information23 in varchar2 default hr_api.g_varchar2
402: ,p_lei_information24 in varchar2 default hr_api.g_varchar2

Line 399: ,p_lei_information21 in varchar2 default hr_api.g_varchar2

395: ,p_lei_information17 in varchar2 default hr_api.g_varchar2
396: ,p_lei_information18 in varchar2 default hr_api.g_varchar2
397: ,p_lei_information19 in varchar2 default hr_api.g_varchar2
398: ,p_lei_information20 in varchar2 default hr_api.g_varchar2
399: ,p_lei_information21 in varchar2 default hr_api.g_varchar2
400: ,p_lei_information22 in varchar2 default hr_api.g_varchar2
401: ,p_lei_information23 in varchar2 default hr_api.g_varchar2
402: ,p_lei_information24 in varchar2 default hr_api.g_varchar2
403: ,p_lei_information25 in varchar2 default hr_api.g_varchar2

Line 400: ,p_lei_information22 in varchar2 default hr_api.g_varchar2

396: ,p_lei_information18 in varchar2 default hr_api.g_varchar2
397: ,p_lei_information19 in varchar2 default hr_api.g_varchar2
398: ,p_lei_information20 in varchar2 default hr_api.g_varchar2
399: ,p_lei_information21 in varchar2 default hr_api.g_varchar2
400: ,p_lei_information22 in varchar2 default hr_api.g_varchar2
401: ,p_lei_information23 in varchar2 default hr_api.g_varchar2
402: ,p_lei_information24 in varchar2 default hr_api.g_varchar2
403: ,p_lei_information25 in varchar2 default hr_api.g_varchar2
404: ,p_lei_information26 in varchar2 default hr_api.g_varchar2

Line 401: ,p_lei_information23 in varchar2 default hr_api.g_varchar2

397: ,p_lei_information19 in varchar2 default hr_api.g_varchar2
398: ,p_lei_information20 in varchar2 default hr_api.g_varchar2
399: ,p_lei_information21 in varchar2 default hr_api.g_varchar2
400: ,p_lei_information22 in varchar2 default hr_api.g_varchar2
401: ,p_lei_information23 in varchar2 default hr_api.g_varchar2
402: ,p_lei_information24 in varchar2 default hr_api.g_varchar2
403: ,p_lei_information25 in varchar2 default hr_api.g_varchar2
404: ,p_lei_information26 in varchar2 default hr_api.g_varchar2
405: ,p_lei_information27 in varchar2 default hr_api.g_varchar2

Line 402: ,p_lei_information24 in varchar2 default hr_api.g_varchar2

398: ,p_lei_information20 in varchar2 default hr_api.g_varchar2
399: ,p_lei_information21 in varchar2 default hr_api.g_varchar2
400: ,p_lei_information22 in varchar2 default hr_api.g_varchar2
401: ,p_lei_information23 in varchar2 default hr_api.g_varchar2
402: ,p_lei_information24 in varchar2 default hr_api.g_varchar2
403: ,p_lei_information25 in varchar2 default hr_api.g_varchar2
404: ,p_lei_information26 in varchar2 default hr_api.g_varchar2
405: ,p_lei_information27 in varchar2 default hr_api.g_varchar2
406: ,p_lei_information28 in varchar2 default hr_api.g_varchar2

Line 403: ,p_lei_information25 in varchar2 default hr_api.g_varchar2

399: ,p_lei_information21 in varchar2 default hr_api.g_varchar2
400: ,p_lei_information22 in varchar2 default hr_api.g_varchar2
401: ,p_lei_information23 in varchar2 default hr_api.g_varchar2
402: ,p_lei_information24 in varchar2 default hr_api.g_varchar2
403: ,p_lei_information25 in varchar2 default hr_api.g_varchar2
404: ,p_lei_information26 in varchar2 default hr_api.g_varchar2
405: ,p_lei_information27 in varchar2 default hr_api.g_varchar2
406: ,p_lei_information28 in varchar2 default hr_api.g_varchar2
407: ,p_lei_information29 in varchar2 default hr_api.g_varchar2

Line 404: ,p_lei_information26 in varchar2 default hr_api.g_varchar2

400: ,p_lei_information22 in varchar2 default hr_api.g_varchar2
401: ,p_lei_information23 in varchar2 default hr_api.g_varchar2
402: ,p_lei_information24 in varchar2 default hr_api.g_varchar2
403: ,p_lei_information25 in varchar2 default hr_api.g_varchar2
404: ,p_lei_information26 in varchar2 default hr_api.g_varchar2
405: ,p_lei_information27 in varchar2 default hr_api.g_varchar2
406: ,p_lei_information28 in varchar2 default hr_api.g_varchar2
407: ,p_lei_information29 in varchar2 default hr_api.g_varchar2
408: ,p_lei_information30 in varchar2 default hr_api.g_varchar2

Line 405: ,p_lei_information27 in varchar2 default hr_api.g_varchar2

401: ,p_lei_information23 in varchar2 default hr_api.g_varchar2
402: ,p_lei_information24 in varchar2 default hr_api.g_varchar2
403: ,p_lei_information25 in varchar2 default hr_api.g_varchar2
404: ,p_lei_information26 in varchar2 default hr_api.g_varchar2
405: ,p_lei_information27 in varchar2 default hr_api.g_varchar2
406: ,p_lei_information28 in varchar2 default hr_api.g_varchar2
407: ,p_lei_information29 in varchar2 default hr_api.g_varchar2
408: ,p_lei_information30 in varchar2 default hr_api.g_varchar2
409: ) is

Line 406: ,p_lei_information28 in varchar2 default hr_api.g_varchar2

402: ,p_lei_information24 in varchar2 default hr_api.g_varchar2
403: ,p_lei_information25 in varchar2 default hr_api.g_varchar2
404: ,p_lei_information26 in varchar2 default hr_api.g_varchar2
405: ,p_lei_information27 in varchar2 default hr_api.g_varchar2
406: ,p_lei_information28 in varchar2 default hr_api.g_varchar2
407: ,p_lei_information29 in varchar2 default hr_api.g_varchar2
408: ,p_lei_information30 in varchar2 default hr_api.g_varchar2
409: ) is
410: --

Line 407: ,p_lei_information29 in varchar2 default hr_api.g_varchar2

403: ,p_lei_information25 in varchar2 default hr_api.g_varchar2
404: ,p_lei_information26 in varchar2 default hr_api.g_varchar2
405: ,p_lei_information27 in varchar2 default hr_api.g_varchar2
406: ,p_lei_information28 in varchar2 default hr_api.g_varchar2
407: ,p_lei_information29 in varchar2 default hr_api.g_varchar2
408: ,p_lei_information30 in varchar2 default hr_api.g_varchar2
409: ) is
410: --
411: -- Declare cursors and local variables

Line 408: ,p_lei_information30 in varchar2 default hr_api.g_varchar2

404: ,p_lei_information26 in varchar2 default hr_api.g_varchar2
405: ,p_lei_information27 in varchar2 default hr_api.g_varchar2
406: ,p_lei_information28 in varchar2 default hr_api.g_varchar2
407: ,p_lei_information29 in varchar2 default hr_api.g_varchar2
408: ,p_lei_information30 in varchar2 default hr_api.g_varchar2
409: ) is
410: --
411: -- Declare cursors and local variables
412: --

Line 486: when hr_api.cannot_find_prog_unit then

482: p_lei_information30 => p_lei_information30,
483: p_object_version_number => p_object_version_number
484: );
485: exception
486: when hr_api.cannot_find_prog_unit then
487: -- Reset OUT parameters
488: p_object_version_number := l_temp_ovn;
489: hr_api.cannot_find_prog_unit_error
490: (p_module_name => 'UPDATE_LOCATION_EXTRA_INFO',

Line 489: hr_api.cannot_find_prog_unit_error

485: exception
486: when hr_api.cannot_find_prog_unit then
487: -- Reset OUT parameters
488: p_object_version_number := l_temp_ovn;
489: hr_api.cannot_find_prog_unit_error
490: (p_module_name => 'UPDATE_LOCATION_EXTRA_INFO',
491: p_hook_type => 'BP'
492: );
493: end;

Line 627: when hr_api.cannot_find_prog_unit then

623: p_lei_information30 => p_lei_information30,
624: p_object_version_number => p_object_version_number
625: );
626: exception
627: when hr_api.cannot_find_prog_unit then
628: -- Reset OUT parameters
629: p_object_version_number := l_temp_ovn;
630: hr_api.cannot_find_prog_unit_error
631: (p_module_name => 'UPDATE_LOCATION_EXTRA_INFO',

Line 630: hr_api.cannot_find_prog_unit_error

626: exception
627: when hr_api.cannot_find_prog_unit then
628: -- Reset OUT parameters
629: p_object_version_number := l_temp_ovn;
630: hr_api.cannot_find_prog_unit_error
631: (p_module_name => 'UPDATE_LOCATION_EXTRA_INFO',
632: p_hook_type => 'AP'
633: );
634: end;

Line 639: raise hr_api.validate_enabled;

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

Line 644: when hr_api.validate_enabled then

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

Line 703: when hr_api.cannot_find_prog_unit then

699: (p_location_extra_info_id => p_location_extra_info_id,
700: p_object_version_number => p_object_version_number
701: );
702: exception
703: when hr_api.cannot_find_prog_unit then
704: hr_api.cannot_find_prog_unit_error
705: (p_module_name => 'DELETE_LOCATION_EXTRA_INFO',
706: p_hook_type => 'BP'
707: );

Line 704: hr_api.cannot_find_prog_unit_error

700: p_object_version_number => p_object_version_number
701: );
702: exception
703: when hr_api.cannot_find_prog_unit then
704: hr_api.cannot_find_prog_unit_error
705: (p_module_name => 'DELETE_LOCATION_EXTRA_INFO',
706: p_hook_type => 'BP'
707: );
708: end;

Line 732: when hr_api.cannot_find_prog_unit then

728: (p_location_extra_info_id => p_location_extra_info_id,
729: p_object_version_number => p_object_version_number
730: );
731: exception
732: when hr_api.cannot_find_prog_unit then
733: hr_api.cannot_find_prog_unit_error
734: (p_module_name => 'DELETE_LOCATION_EXTRA_INFO',
735: p_hook_type => 'AP'
736: );

Line 733: hr_api.cannot_find_prog_unit_error

729: p_object_version_number => p_object_version_number
730: );
731: exception
732: when hr_api.cannot_find_prog_unit then
733: hr_api.cannot_find_prog_unit_error
734: (p_module_name => 'DELETE_LOCATION_EXTRA_INFO',
735: p_hook_type => 'AP'
736: );
737: end;

Line 742: raise hr_api.validate_enabled;

738: --
739: -- When in validation only mode raise the Validate_Enabled exception
740: --
741: if p_validate then
742: raise hr_api.validate_enabled;
743: end if;
744: --
745: hr_utility.set_location(' Leaving:'||l_proc, 11);
746: exception

Line 747: when hr_api.validate_enabled then

743: end if;
744: --
745: hr_utility.set_location(' Leaving:'||l_proc, 11);
746: exception
747: when hr_api.validate_enabled then
748: --
749: -- As the Validate_Enabled exception has been raised
750: -- we must rollback to the savepoint
751: --