APPS.PER_EST_UPD dependencies on HR_API

Line 124: When hr_api.check_integrity_violated Then

120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 10);
122: --
123: Exception
124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: per_est_shd.g_api_dml := false; -- Unset the api dml status
127: per_est_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

124: When hr_api.check_integrity_violated Then
125: -- A check constraint has been violated
126: per_est_shd.g_api_dml := false; -- Unset the api dml status
127: per_est_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: per_est_shd.g_api_dml := false; -- Unset the api dml status
132: per_est_shd.constraint_error

Line 129: When hr_api.parent_integrity_violated Then

125: -- A check constraint has been violated
126: per_est_shd.g_api_dml := false; -- Unset the api dml status
127: per_est_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: per_est_shd.g_api_dml := false; -- Unset the api dml status
132: per_est_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

129: When hr_api.parent_integrity_violated Then
130: -- Parent integrity has been violated
131: per_est_shd.g_api_dml := false; -- Unset the api dml status
132: per_est_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: per_est_shd.g_api_dml := false; -- Unset the api dml status
137: per_est_shd.constraint_error

Line 134: When hr_api.unique_integrity_violated Then

130: -- Parent integrity has been violated
131: per_est_shd.g_api_dml := false; -- Unset the api dml status
132: per_est_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: per_est_shd.g_api_dml := false; -- Unset the api dml status
137: per_est_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

134: When hr_api.unique_integrity_violated Then
135: -- Unique integrity has been violated
136: per_est_shd.g_api_dml := false; -- Unset the api dml status
137: per_est_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: per_est_shd.g_api_dml := false; -- Unset the api dml status
141: Raise;
142: End update_dml;

Line 321: when hr_api.cannot_find_prog_unit then

317: p_est_information20_o => per_est_shd.g_old_rec.est_information20
318: ,p_object_version_number_o =>per_est_shd.g_old_rec.object_version_number
319: );
320: exception
321: when hr_api.cannot_find_prog_unit then
322: hr_api.cannot_find_prog_unit_error
323: ( P_MODULE_NAME => 'PER_ESTABLISHMENTS',
324: p_hook_type => 'AU'
325: );

Line 322: hr_api.cannot_find_prog_unit_error

318: ,p_object_version_number_o =>per_est_shd.g_old_rec.object_version_number
319: );
320: exception
321: when hr_api.cannot_find_prog_unit then
322: hr_api.cannot_find_prog_unit_error
323: ( P_MODULE_NAME => 'PER_ESTABLISHMENTS',
324: p_hook_type => 'AU'
325: );
326: end;

Line 388: If (p_rec.name = hr_api.g_varchar2) then

384: -- p_rec plsql record structure
385: -- to see if a system default is being used. If a system default
386: -- is being used then we must set to the 'current' argument value.
387: --
388: If (p_rec.name = hr_api.g_varchar2) then
389: p_rec.name :=
390: per_est_shd.g_old_rec.name;
391: End If;
392: If (p_rec.location = hr_api.g_varchar2) then

Line 392: If (p_rec.location = hr_api.g_varchar2) then

388: If (p_rec.name = hr_api.g_varchar2) then
389: p_rec.name :=
390: per_est_shd.g_old_rec.name;
391: End If;
392: If (p_rec.location = hr_api.g_varchar2) then
393: p_rec.location :=
394: per_est_shd.g_old_rec.location;
395: End If;
396: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 396: If (p_rec.attribute_category = hr_api.g_varchar2) then

392: If (p_rec.location = hr_api.g_varchar2) then
393: p_rec.location :=
394: per_est_shd.g_old_rec.location;
395: End If;
396: If (p_rec.attribute_category = hr_api.g_varchar2) then
397: p_rec.attribute_category :=
398: per_est_shd.g_old_rec.attribute_category;
399: End If;
400: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 400: If (p_rec.attribute1 = hr_api.g_varchar2) then

396: If (p_rec.attribute_category = hr_api.g_varchar2) then
397: p_rec.attribute_category :=
398: per_est_shd.g_old_rec.attribute_category;
399: End If;
400: If (p_rec.attribute1 = hr_api.g_varchar2) then
401: p_rec.attribute1 :=
402: per_est_shd.g_old_rec.attribute1;
403: End If;
404: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 404: If (p_rec.attribute2 = hr_api.g_varchar2) then

400: If (p_rec.attribute1 = hr_api.g_varchar2) then
401: p_rec.attribute1 :=
402: per_est_shd.g_old_rec.attribute1;
403: End If;
404: If (p_rec.attribute2 = hr_api.g_varchar2) then
405: p_rec.attribute2 :=
406: per_est_shd.g_old_rec.attribute2;
407: End If;
408: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 408: If (p_rec.attribute3 = hr_api.g_varchar2) then

404: If (p_rec.attribute2 = hr_api.g_varchar2) then
405: p_rec.attribute2 :=
406: per_est_shd.g_old_rec.attribute2;
407: End If;
408: If (p_rec.attribute3 = hr_api.g_varchar2) then
409: p_rec.attribute3 :=
410: per_est_shd.g_old_rec.attribute3;
411: End If;
412: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 412: If (p_rec.attribute4 = hr_api.g_varchar2) then

408: If (p_rec.attribute3 = hr_api.g_varchar2) then
409: p_rec.attribute3 :=
410: per_est_shd.g_old_rec.attribute3;
411: End If;
412: If (p_rec.attribute4 = hr_api.g_varchar2) then
413: p_rec.attribute4 :=
414: per_est_shd.g_old_rec.attribute4;
415: End If;
416: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 416: If (p_rec.attribute5 = hr_api.g_varchar2) then

412: If (p_rec.attribute4 = hr_api.g_varchar2) then
413: p_rec.attribute4 :=
414: per_est_shd.g_old_rec.attribute4;
415: End If;
416: If (p_rec.attribute5 = hr_api.g_varchar2) then
417: p_rec.attribute5 :=
418: per_est_shd.g_old_rec.attribute5;
419: End If;
420: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 420: If (p_rec.attribute6 = hr_api.g_varchar2) then

416: If (p_rec.attribute5 = hr_api.g_varchar2) then
417: p_rec.attribute5 :=
418: per_est_shd.g_old_rec.attribute5;
419: End If;
420: If (p_rec.attribute6 = hr_api.g_varchar2) then
421: p_rec.attribute6 :=
422: per_est_shd.g_old_rec.attribute6;
423: End If;
424: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 424: If (p_rec.attribute7 = hr_api.g_varchar2) then

420: If (p_rec.attribute6 = hr_api.g_varchar2) then
421: p_rec.attribute6 :=
422: per_est_shd.g_old_rec.attribute6;
423: End If;
424: If (p_rec.attribute7 = hr_api.g_varchar2) then
425: p_rec.attribute7 :=
426: per_est_shd.g_old_rec.attribute7;
427: End If;
428: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 428: If (p_rec.attribute8 = hr_api.g_varchar2) then

424: If (p_rec.attribute7 = hr_api.g_varchar2) then
425: p_rec.attribute7 :=
426: per_est_shd.g_old_rec.attribute7;
427: End If;
428: If (p_rec.attribute8 = hr_api.g_varchar2) then
429: p_rec.attribute8 :=
430: per_est_shd.g_old_rec.attribute8;
431: End If;
432: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 432: If (p_rec.attribute9 = hr_api.g_varchar2) then

428: If (p_rec.attribute8 = hr_api.g_varchar2) then
429: p_rec.attribute8 :=
430: per_est_shd.g_old_rec.attribute8;
431: End If;
432: If (p_rec.attribute9 = hr_api.g_varchar2) then
433: p_rec.attribute9 :=
434: per_est_shd.g_old_rec.attribute9;
435: End If;
436: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 436: If (p_rec.attribute10 = hr_api.g_varchar2) then

432: If (p_rec.attribute9 = hr_api.g_varchar2) then
433: p_rec.attribute9 :=
434: per_est_shd.g_old_rec.attribute9;
435: End If;
436: If (p_rec.attribute10 = hr_api.g_varchar2) then
437: p_rec.attribute10 :=
438: per_est_shd.g_old_rec.attribute10;
439: End If;
440: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 440: If (p_rec.attribute11 = hr_api.g_varchar2) then

436: If (p_rec.attribute10 = hr_api.g_varchar2) then
437: p_rec.attribute10 :=
438: per_est_shd.g_old_rec.attribute10;
439: End If;
440: If (p_rec.attribute11 = hr_api.g_varchar2) then
441: p_rec.attribute11 :=
442: per_est_shd.g_old_rec.attribute11;
443: End If;
444: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 444: If (p_rec.attribute12 = hr_api.g_varchar2) then

440: If (p_rec.attribute11 = hr_api.g_varchar2) then
441: p_rec.attribute11 :=
442: per_est_shd.g_old_rec.attribute11;
443: End If;
444: If (p_rec.attribute12 = hr_api.g_varchar2) then
445: p_rec.attribute12 :=
446: per_est_shd.g_old_rec.attribute12;
447: End If;
448: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 448: If (p_rec.attribute13 = hr_api.g_varchar2) then

444: If (p_rec.attribute12 = hr_api.g_varchar2) then
445: p_rec.attribute12 :=
446: per_est_shd.g_old_rec.attribute12;
447: End If;
448: If (p_rec.attribute13 = hr_api.g_varchar2) then
449: p_rec.attribute13 :=
450: per_est_shd.g_old_rec.attribute13;
451: End If;
452: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 452: If (p_rec.attribute14 = hr_api.g_varchar2) then

448: If (p_rec.attribute13 = hr_api.g_varchar2) then
449: p_rec.attribute13 :=
450: per_est_shd.g_old_rec.attribute13;
451: End If;
452: If (p_rec.attribute14 = hr_api.g_varchar2) then
453: p_rec.attribute14 :=
454: per_est_shd.g_old_rec.attribute14;
455: End If;
456: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 456: If (p_rec.attribute15 = hr_api.g_varchar2) then

452: If (p_rec.attribute14 = hr_api.g_varchar2) then
453: p_rec.attribute14 :=
454: per_est_shd.g_old_rec.attribute14;
455: End If;
456: If (p_rec.attribute15 = hr_api.g_varchar2) then
457: p_rec.attribute15 :=
458: per_est_shd.g_old_rec.attribute15;
459: End If;
460: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 460: If (p_rec.attribute16 = hr_api.g_varchar2) then

456: If (p_rec.attribute15 = hr_api.g_varchar2) then
457: p_rec.attribute15 :=
458: per_est_shd.g_old_rec.attribute15;
459: End If;
460: If (p_rec.attribute16 = hr_api.g_varchar2) then
461: p_rec.attribute16 :=
462: per_est_shd.g_old_rec.attribute16;
463: End If;
464: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 464: If (p_rec.attribute17 = hr_api.g_varchar2) then

460: If (p_rec.attribute16 = hr_api.g_varchar2) then
461: p_rec.attribute16 :=
462: per_est_shd.g_old_rec.attribute16;
463: End If;
464: If (p_rec.attribute17 = hr_api.g_varchar2) then
465: p_rec.attribute17 :=
466: per_est_shd.g_old_rec.attribute17;
467: End If;
468: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 468: If (p_rec.attribute18 = hr_api.g_varchar2) then

464: If (p_rec.attribute17 = hr_api.g_varchar2) then
465: p_rec.attribute17 :=
466: per_est_shd.g_old_rec.attribute17;
467: End If;
468: If (p_rec.attribute18 = hr_api.g_varchar2) then
469: p_rec.attribute18 :=
470: per_est_shd.g_old_rec.attribute18;
471: End If;
472: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 472: If (p_rec.attribute19 = hr_api.g_varchar2) then

468: If (p_rec.attribute18 = hr_api.g_varchar2) then
469: p_rec.attribute18 :=
470: per_est_shd.g_old_rec.attribute18;
471: End If;
472: If (p_rec.attribute19 = hr_api.g_varchar2) then
473: p_rec.attribute19 :=
474: per_est_shd.g_old_rec.attribute19;
475: End If;
476: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 476: If (p_rec.attribute20 = hr_api.g_varchar2) then

472: If (p_rec.attribute19 = hr_api.g_varchar2) then
473: p_rec.attribute19 :=
474: per_est_shd.g_old_rec.attribute19;
475: End If;
476: If (p_rec.attribute20 = hr_api.g_varchar2) then
477: p_rec.attribute20 :=
478: per_est_shd.g_old_rec.attribute20;
479: End If;
480: If (p_rec.est_information_category = hr_api.g_varchar2) then

Line 480: If (p_rec.est_information_category = hr_api.g_varchar2) then

476: If (p_rec.attribute20 = hr_api.g_varchar2) then
477: p_rec.attribute20 :=
478: per_est_shd.g_old_rec.attribute20;
479: End If;
480: If (p_rec.est_information_category = hr_api.g_varchar2) then
481: p_rec.est_information_category :=
482: per_est_shd.g_old_rec.est_information_category;
483: End If;
484: If (p_rec.est_information1 = hr_api.g_varchar2) then

Line 484: If (p_rec.est_information1 = hr_api.g_varchar2) then

480: If (p_rec.est_information_category = hr_api.g_varchar2) then
481: p_rec.est_information_category :=
482: per_est_shd.g_old_rec.est_information_category;
483: End If;
484: If (p_rec.est_information1 = hr_api.g_varchar2) then
485: p_rec.est_information1 :=
486: per_est_shd.g_old_rec.est_information1;
487: End If;
488: If (p_rec.est_information2 = hr_api.g_varchar2) then

Line 488: If (p_rec.est_information2 = hr_api.g_varchar2) then

484: If (p_rec.est_information1 = hr_api.g_varchar2) then
485: p_rec.est_information1 :=
486: per_est_shd.g_old_rec.est_information1;
487: End If;
488: If (p_rec.est_information2 = hr_api.g_varchar2) then
489: p_rec.est_information2 :=
490: per_est_shd.g_old_rec.est_information2;
491: End If;
492: If (p_rec.est_information3 = hr_api.g_varchar2) then

Line 492: If (p_rec.est_information3 = hr_api.g_varchar2) then

488: If (p_rec.est_information2 = hr_api.g_varchar2) then
489: p_rec.est_information2 :=
490: per_est_shd.g_old_rec.est_information2;
491: End If;
492: If (p_rec.est_information3 = hr_api.g_varchar2) then
493: p_rec.est_information3 :=
494: per_est_shd.g_old_rec.est_information3;
495: End If;
496: If (p_rec.est_information4 = hr_api.g_varchar2) then

Line 496: If (p_rec.est_information4 = hr_api.g_varchar2) then

492: If (p_rec.est_information3 = hr_api.g_varchar2) then
493: p_rec.est_information3 :=
494: per_est_shd.g_old_rec.est_information3;
495: End If;
496: If (p_rec.est_information4 = hr_api.g_varchar2) then
497: p_rec.est_information4 :=
498: per_est_shd.g_old_rec.est_information4;
499: End If;
500: If (p_rec.est_information5 = hr_api.g_varchar2) then

Line 500: If (p_rec.est_information5 = hr_api.g_varchar2) then

496: If (p_rec.est_information4 = hr_api.g_varchar2) then
497: p_rec.est_information4 :=
498: per_est_shd.g_old_rec.est_information4;
499: End If;
500: If (p_rec.est_information5 = hr_api.g_varchar2) then
501: p_rec.est_information5 :=
502: per_est_shd.g_old_rec.est_information5;
503: End If;
504: If (p_rec.est_information6 = hr_api.g_varchar2) then

Line 504: If (p_rec.est_information6 = hr_api.g_varchar2) then

500: If (p_rec.est_information5 = hr_api.g_varchar2) then
501: p_rec.est_information5 :=
502: per_est_shd.g_old_rec.est_information5;
503: End If;
504: If (p_rec.est_information6 = hr_api.g_varchar2) then
505: p_rec.est_information6 :=
506: per_est_shd.g_old_rec.est_information6;
507: End If;
508: If (p_rec.est_information7 = hr_api.g_varchar2) then

Line 508: If (p_rec.est_information7 = hr_api.g_varchar2) then

504: If (p_rec.est_information6 = hr_api.g_varchar2) then
505: p_rec.est_information6 :=
506: per_est_shd.g_old_rec.est_information6;
507: End If;
508: If (p_rec.est_information7 = hr_api.g_varchar2) then
509: p_rec.est_information7 :=
510: per_est_shd.g_old_rec.est_information7;
511: End If;
512: If (p_rec.est_information8 = hr_api.g_varchar2) then

Line 512: If (p_rec.est_information8 = hr_api.g_varchar2) then

508: If (p_rec.est_information7 = hr_api.g_varchar2) then
509: p_rec.est_information7 :=
510: per_est_shd.g_old_rec.est_information7;
511: End If;
512: If (p_rec.est_information8 = hr_api.g_varchar2) then
513: p_rec.est_information8 :=
514: per_est_shd.g_old_rec.est_information8;
515: End If;
516: If (p_rec.est_information9 = hr_api.g_varchar2) then

Line 516: If (p_rec.est_information9 = hr_api.g_varchar2) then

512: If (p_rec.est_information8 = hr_api.g_varchar2) then
513: p_rec.est_information8 :=
514: per_est_shd.g_old_rec.est_information8;
515: End If;
516: If (p_rec.est_information9 = hr_api.g_varchar2) then
517: p_rec.est_information9 :=
518: per_est_shd.g_old_rec.est_information9;
519: End If;
520: If (p_rec.est_information10 = hr_api.g_varchar2) then

Line 520: If (p_rec.est_information10 = hr_api.g_varchar2) then

516: If (p_rec.est_information9 = hr_api.g_varchar2) then
517: p_rec.est_information9 :=
518: per_est_shd.g_old_rec.est_information9;
519: End If;
520: If (p_rec.est_information10 = hr_api.g_varchar2) then
521: p_rec.est_information10 :=
522: per_est_shd.g_old_rec.est_information10;
523: End If;
524: If (p_rec.est_information11 = hr_api.g_varchar2) then

Line 524: If (p_rec.est_information11 = hr_api.g_varchar2) then

520: If (p_rec.est_information10 = hr_api.g_varchar2) then
521: p_rec.est_information10 :=
522: per_est_shd.g_old_rec.est_information10;
523: End If;
524: If (p_rec.est_information11 = hr_api.g_varchar2) then
525: p_rec.est_information11 :=
526: per_est_shd.g_old_rec.est_information11;
527: End If;
528: If (p_rec.est_information12 = hr_api.g_varchar2) then

Line 528: If (p_rec.est_information12 = hr_api.g_varchar2) then

524: If (p_rec.est_information11 = hr_api.g_varchar2) then
525: p_rec.est_information11 :=
526: per_est_shd.g_old_rec.est_information11;
527: End If;
528: If (p_rec.est_information12 = hr_api.g_varchar2) then
529: p_rec.est_information12 :=
530: per_est_shd.g_old_rec.est_information12;
531: End If;
532: If (p_rec.est_information13 = hr_api.g_varchar2) then

Line 532: If (p_rec.est_information13 = hr_api.g_varchar2) then

528: If (p_rec.est_information12 = hr_api.g_varchar2) then
529: p_rec.est_information12 :=
530: per_est_shd.g_old_rec.est_information12;
531: End If;
532: If (p_rec.est_information13 = hr_api.g_varchar2) then
533: p_rec.est_information13 :=
534: per_est_shd.g_old_rec.est_information13;
535: End If;
536: If (p_rec.est_information14 = hr_api.g_varchar2) then

Line 536: If (p_rec.est_information14 = hr_api.g_varchar2) then

532: If (p_rec.est_information13 = hr_api.g_varchar2) then
533: p_rec.est_information13 :=
534: per_est_shd.g_old_rec.est_information13;
535: End If;
536: If (p_rec.est_information14 = hr_api.g_varchar2) then
537: p_rec.est_information14 :=
538: per_est_shd.g_old_rec.est_information14;
539: End If;
540: If (p_rec.est_information15 = hr_api.g_varchar2) then

Line 540: If (p_rec.est_information15 = hr_api.g_varchar2) then

536: If (p_rec.est_information14 = hr_api.g_varchar2) then
537: p_rec.est_information14 :=
538: per_est_shd.g_old_rec.est_information14;
539: End If;
540: If (p_rec.est_information15 = hr_api.g_varchar2) then
541: p_rec.est_information15 :=
542: per_est_shd.g_old_rec.est_information15;
543: End If;
544: If (p_rec.est_information16 = hr_api.g_varchar2) then

Line 544: If (p_rec.est_information16 = hr_api.g_varchar2) then

540: If (p_rec.est_information15 = hr_api.g_varchar2) then
541: p_rec.est_information15 :=
542: per_est_shd.g_old_rec.est_information15;
543: End If;
544: If (p_rec.est_information16 = hr_api.g_varchar2) then
545: p_rec.est_information16 :=
546: per_est_shd.g_old_rec.est_information16;
547: End If;
548: If (p_rec.est_information17 = hr_api.g_varchar2) then

Line 548: If (p_rec.est_information17 = hr_api.g_varchar2) then

544: If (p_rec.est_information16 = hr_api.g_varchar2) then
545: p_rec.est_information16 :=
546: per_est_shd.g_old_rec.est_information16;
547: End If;
548: If (p_rec.est_information17 = hr_api.g_varchar2) then
549: p_rec.est_information17 :=
550: per_est_shd.g_old_rec.est_information17;
551: End If;
552: If (p_rec.est_information18 = hr_api.g_varchar2) then

Line 552: If (p_rec.est_information18 = hr_api.g_varchar2) then

548: If (p_rec.est_information17 = hr_api.g_varchar2) then
549: p_rec.est_information17 :=
550: per_est_shd.g_old_rec.est_information17;
551: End If;
552: If (p_rec.est_information18 = hr_api.g_varchar2) then
553: p_rec.est_information18 :=
554: per_est_shd.g_old_rec.est_information18;
555: End If;
556: If (p_rec.est_information19 = hr_api.g_varchar2) then

Line 556: If (p_rec.est_information19 = hr_api.g_varchar2) then

552: If (p_rec.est_information18 = hr_api.g_varchar2) then
553: p_rec.est_information18 :=
554: per_est_shd.g_old_rec.est_information18;
555: End If;
556: If (p_rec.est_information19 = hr_api.g_varchar2) then
557: p_rec.est_information19 :=
558: per_est_shd.g_old_rec.est_information19;
559: End If;
560: If (p_rec.est_information20 = hr_api.g_varchar2) then

Line 560: If (p_rec.est_information20 = hr_api.g_varchar2) then

556: If (p_rec.est_information19 = hr_api.g_varchar2) then
557: p_rec.est_information19 :=
558: per_est_shd.g_old_rec.est_information19;
559: End If;
560: If (p_rec.est_information20 = hr_api.g_varchar2) then
561: p_rec.est_information20 :=
562: per_est_shd.g_old_rec.est_information20;
563: End If;
564:

Line 625: Raise HR_Api.Validate_Enabled;

621: --
622: -- If we are validating then raise the Validate_Enabled exception
623: --
624: If p_validate then
625: Raise HR_Api.Validate_Enabled;
626: End If;
627: --
628: hr_utility.set_location(' Leaving:'||l_proc, 10);
629: Exception

Line 630: When HR_Api.Validate_Enabled Then

626: End If;
627: --
628: hr_utility.set_location(' Leaving:'||l_proc, 10);
629: Exception
630: When HR_Api.Validate_Enabled Then
631: --
632: -- As the Validate_Enabled exception has been raised
633: -- we must rollback to the savepoint
634: --

Line 644: p_name in varchar2 default hr_api.g_varchar2,

640: -- ----------------------------------------------------------------------------
641: Procedure upd
642: (
643: p_establishment_id in number,
644: p_name in varchar2 default hr_api.g_varchar2,
645: p_location in varchar2 default hr_api.g_varchar2,
646: p_attribute_category in varchar2 default hr_api.g_varchar2,
647: p_attribute1 in varchar2 default hr_api.g_varchar2,
648: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 645: p_location in varchar2 default hr_api.g_varchar2,

641: Procedure upd
642: (
643: p_establishment_id in number,
644: p_name in varchar2 default hr_api.g_varchar2,
645: p_location in varchar2 default hr_api.g_varchar2,
646: p_attribute_category in varchar2 default hr_api.g_varchar2,
647: p_attribute1 in varchar2 default hr_api.g_varchar2,
648: p_attribute2 in varchar2 default hr_api.g_varchar2,
649: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 646: p_attribute_category in varchar2 default hr_api.g_varchar2,

642: (
643: p_establishment_id in number,
644: p_name in varchar2 default hr_api.g_varchar2,
645: p_location in varchar2 default hr_api.g_varchar2,
646: p_attribute_category in varchar2 default hr_api.g_varchar2,
647: p_attribute1 in varchar2 default hr_api.g_varchar2,
648: p_attribute2 in varchar2 default hr_api.g_varchar2,
649: p_attribute3 in varchar2 default hr_api.g_varchar2,
650: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 647: p_attribute1 in varchar2 default hr_api.g_varchar2,

643: p_establishment_id in number,
644: p_name in varchar2 default hr_api.g_varchar2,
645: p_location in varchar2 default hr_api.g_varchar2,
646: p_attribute_category in varchar2 default hr_api.g_varchar2,
647: p_attribute1 in varchar2 default hr_api.g_varchar2,
648: p_attribute2 in varchar2 default hr_api.g_varchar2,
649: p_attribute3 in varchar2 default hr_api.g_varchar2,
650: p_attribute4 in varchar2 default hr_api.g_varchar2,
651: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 648: p_attribute2 in varchar2 default hr_api.g_varchar2,

644: p_name in varchar2 default hr_api.g_varchar2,
645: p_location in varchar2 default hr_api.g_varchar2,
646: p_attribute_category in varchar2 default hr_api.g_varchar2,
647: p_attribute1 in varchar2 default hr_api.g_varchar2,
648: p_attribute2 in varchar2 default hr_api.g_varchar2,
649: p_attribute3 in varchar2 default hr_api.g_varchar2,
650: p_attribute4 in varchar2 default hr_api.g_varchar2,
651: p_attribute5 in varchar2 default hr_api.g_varchar2,
652: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 649: p_attribute3 in varchar2 default hr_api.g_varchar2,

645: p_location in varchar2 default hr_api.g_varchar2,
646: p_attribute_category in varchar2 default hr_api.g_varchar2,
647: p_attribute1 in varchar2 default hr_api.g_varchar2,
648: p_attribute2 in varchar2 default hr_api.g_varchar2,
649: p_attribute3 in varchar2 default hr_api.g_varchar2,
650: p_attribute4 in varchar2 default hr_api.g_varchar2,
651: p_attribute5 in varchar2 default hr_api.g_varchar2,
652: p_attribute6 in varchar2 default hr_api.g_varchar2,
653: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 650: p_attribute4 in varchar2 default hr_api.g_varchar2,

646: p_attribute_category in varchar2 default hr_api.g_varchar2,
647: p_attribute1 in varchar2 default hr_api.g_varchar2,
648: p_attribute2 in varchar2 default hr_api.g_varchar2,
649: p_attribute3 in varchar2 default hr_api.g_varchar2,
650: p_attribute4 in varchar2 default hr_api.g_varchar2,
651: p_attribute5 in varchar2 default hr_api.g_varchar2,
652: p_attribute6 in varchar2 default hr_api.g_varchar2,
653: p_attribute7 in varchar2 default hr_api.g_varchar2,
654: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 651: p_attribute5 in varchar2 default hr_api.g_varchar2,

647: p_attribute1 in varchar2 default hr_api.g_varchar2,
648: p_attribute2 in varchar2 default hr_api.g_varchar2,
649: p_attribute3 in varchar2 default hr_api.g_varchar2,
650: p_attribute4 in varchar2 default hr_api.g_varchar2,
651: p_attribute5 in varchar2 default hr_api.g_varchar2,
652: p_attribute6 in varchar2 default hr_api.g_varchar2,
653: p_attribute7 in varchar2 default hr_api.g_varchar2,
654: p_attribute8 in varchar2 default hr_api.g_varchar2,
655: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 652: p_attribute6 in varchar2 default hr_api.g_varchar2,

648: p_attribute2 in varchar2 default hr_api.g_varchar2,
649: p_attribute3 in varchar2 default hr_api.g_varchar2,
650: p_attribute4 in varchar2 default hr_api.g_varchar2,
651: p_attribute5 in varchar2 default hr_api.g_varchar2,
652: p_attribute6 in varchar2 default hr_api.g_varchar2,
653: p_attribute7 in varchar2 default hr_api.g_varchar2,
654: p_attribute8 in varchar2 default hr_api.g_varchar2,
655: p_attribute9 in varchar2 default hr_api.g_varchar2,
656: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 653: p_attribute7 in varchar2 default hr_api.g_varchar2,

649: p_attribute3 in varchar2 default hr_api.g_varchar2,
650: p_attribute4 in varchar2 default hr_api.g_varchar2,
651: p_attribute5 in varchar2 default hr_api.g_varchar2,
652: p_attribute6 in varchar2 default hr_api.g_varchar2,
653: p_attribute7 in varchar2 default hr_api.g_varchar2,
654: p_attribute8 in varchar2 default hr_api.g_varchar2,
655: p_attribute9 in varchar2 default hr_api.g_varchar2,
656: p_attribute10 in varchar2 default hr_api.g_varchar2,
657: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 654: p_attribute8 in varchar2 default hr_api.g_varchar2,

650: p_attribute4 in varchar2 default hr_api.g_varchar2,
651: p_attribute5 in varchar2 default hr_api.g_varchar2,
652: p_attribute6 in varchar2 default hr_api.g_varchar2,
653: p_attribute7 in varchar2 default hr_api.g_varchar2,
654: p_attribute8 in varchar2 default hr_api.g_varchar2,
655: p_attribute9 in varchar2 default hr_api.g_varchar2,
656: p_attribute10 in varchar2 default hr_api.g_varchar2,
657: p_attribute11 in varchar2 default hr_api.g_varchar2,
658: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 655: p_attribute9 in varchar2 default hr_api.g_varchar2,

651: p_attribute5 in varchar2 default hr_api.g_varchar2,
652: p_attribute6 in varchar2 default hr_api.g_varchar2,
653: p_attribute7 in varchar2 default hr_api.g_varchar2,
654: p_attribute8 in varchar2 default hr_api.g_varchar2,
655: p_attribute9 in varchar2 default hr_api.g_varchar2,
656: p_attribute10 in varchar2 default hr_api.g_varchar2,
657: p_attribute11 in varchar2 default hr_api.g_varchar2,
658: p_attribute12 in varchar2 default hr_api.g_varchar2,
659: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 656: p_attribute10 in varchar2 default hr_api.g_varchar2,

652: p_attribute6 in varchar2 default hr_api.g_varchar2,
653: p_attribute7 in varchar2 default hr_api.g_varchar2,
654: p_attribute8 in varchar2 default hr_api.g_varchar2,
655: p_attribute9 in varchar2 default hr_api.g_varchar2,
656: p_attribute10 in varchar2 default hr_api.g_varchar2,
657: p_attribute11 in varchar2 default hr_api.g_varchar2,
658: p_attribute12 in varchar2 default hr_api.g_varchar2,
659: p_attribute13 in varchar2 default hr_api.g_varchar2,
660: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 657: p_attribute11 in varchar2 default hr_api.g_varchar2,

653: p_attribute7 in varchar2 default hr_api.g_varchar2,
654: p_attribute8 in varchar2 default hr_api.g_varchar2,
655: p_attribute9 in varchar2 default hr_api.g_varchar2,
656: p_attribute10 in varchar2 default hr_api.g_varchar2,
657: p_attribute11 in varchar2 default hr_api.g_varchar2,
658: p_attribute12 in varchar2 default hr_api.g_varchar2,
659: p_attribute13 in varchar2 default hr_api.g_varchar2,
660: p_attribute14 in varchar2 default hr_api.g_varchar2,
661: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 658: p_attribute12 in varchar2 default hr_api.g_varchar2,

654: p_attribute8 in varchar2 default hr_api.g_varchar2,
655: p_attribute9 in varchar2 default hr_api.g_varchar2,
656: p_attribute10 in varchar2 default hr_api.g_varchar2,
657: p_attribute11 in varchar2 default hr_api.g_varchar2,
658: p_attribute12 in varchar2 default hr_api.g_varchar2,
659: p_attribute13 in varchar2 default hr_api.g_varchar2,
660: p_attribute14 in varchar2 default hr_api.g_varchar2,
661: p_attribute15 in varchar2 default hr_api.g_varchar2,
662: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 659: p_attribute13 in varchar2 default hr_api.g_varchar2,

655: p_attribute9 in varchar2 default hr_api.g_varchar2,
656: p_attribute10 in varchar2 default hr_api.g_varchar2,
657: p_attribute11 in varchar2 default hr_api.g_varchar2,
658: p_attribute12 in varchar2 default hr_api.g_varchar2,
659: p_attribute13 in varchar2 default hr_api.g_varchar2,
660: p_attribute14 in varchar2 default hr_api.g_varchar2,
661: p_attribute15 in varchar2 default hr_api.g_varchar2,
662: p_attribute16 in varchar2 default hr_api.g_varchar2,
663: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 660: p_attribute14 in varchar2 default hr_api.g_varchar2,

656: p_attribute10 in varchar2 default hr_api.g_varchar2,
657: p_attribute11 in varchar2 default hr_api.g_varchar2,
658: p_attribute12 in varchar2 default hr_api.g_varchar2,
659: p_attribute13 in varchar2 default hr_api.g_varchar2,
660: p_attribute14 in varchar2 default hr_api.g_varchar2,
661: p_attribute15 in varchar2 default hr_api.g_varchar2,
662: p_attribute16 in varchar2 default hr_api.g_varchar2,
663: p_attribute17 in varchar2 default hr_api.g_varchar2,
664: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 661: p_attribute15 in varchar2 default hr_api.g_varchar2,

657: p_attribute11 in varchar2 default hr_api.g_varchar2,
658: p_attribute12 in varchar2 default hr_api.g_varchar2,
659: p_attribute13 in varchar2 default hr_api.g_varchar2,
660: p_attribute14 in varchar2 default hr_api.g_varchar2,
661: p_attribute15 in varchar2 default hr_api.g_varchar2,
662: p_attribute16 in varchar2 default hr_api.g_varchar2,
663: p_attribute17 in varchar2 default hr_api.g_varchar2,
664: p_attribute18 in varchar2 default hr_api.g_varchar2,
665: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 662: p_attribute16 in varchar2 default hr_api.g_varchar2,

658: p_attribute12 in varchar2 default hr_api.g_varchar2,
659: p_attribute13 in varchar2 default hr_api.g_varchar2,
660: p_attribute14 in varchar2 default hr_api.g_varchar2,
661: p_attribute15 in varchar2 default hr_api.g_varchar2,
662: p_attribute16 in varchar2 default hr_api.g_varchar2,
663: p_attribute17 in varchar2 default hr_api.g_varchar2,
664: p_attribute18 in varchar2 default hr_api.g_varchar2,
665: p_attribute19 in varchar2 default hr_api.g_varchar2,
666: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 663: p_attribute17 in varchar2 default hr_api.g_varchar2,

659: p_attribute13 in varchar2 default hr_api.g_varchar2,
660: p_attribute14 in varchar2 default hr_api.g_varchar2,
661: p_attribute15 in varchar2 default hr_api.g_varchar2,
662: p_attribute16 in varchar2 default hr_api.g_varchar2,
663: p_attribute17 in varchar2 default hr_api.g_varchar2,
664: p_attribute18 in varchar2 default hr_api.g_varchar2,
665: p_attribute19 in varchar2 default hr_api.g_varchar2,
666: p_attribute20 in varchar2 default hr_api.g_varchar2,
667: p_est_information_category in varchar2 default hr_api.g_varchar2,

Line 664: p_attribute18 in varchar2 default hr_api.g_varchar2,

660: p_attribute14 in varchar2 default hr_api.g_varchar2,
661: p_attribute15 in varchar2 default hr_api.g_varchar2,
662: p_attribute16 in varchar2 default hr_api.g_varchar2,
663: p_attribute17 in varchar2 default hr_api.g_varchar2,
664: p_attribute18 in varchar2 default hr_api.g_varchar2,
665: p_attribute19 in varchar2 default hr_api.g_varchar2,
666: p_attribute20 in varchar2 default hr_api.g_varchar2,
667: p_est_information_category in varchar2 default hr_api.g_varchar2,
668: p_est_information1 in varchar2 default hr_api.g_varchar2,

Line 665: p_attribute19 in varchar2 default hr_api.g_varchar2,

661: p_attribute15 in varchar2 default hr_api.g_varchar2,
662: p_attribute16 in varchar2 default hr_api.g_varchar2,
663: p_attribute17 in varchar2 default hr_api.g_varchar2,
664: p_attribute18 in varchar2 default hr_api.g_varchar2,
665: p_attribute19 in varchar2 default hr_api.g_varchar2,
666: p_attribute20 in varchar2 default hr_api.g_varchar2,
667: p_est_information_category in varchar2 default hr_api.g_varchar2,
668: p_est_information1 in varchar2 default hr_api.g_varchar2,
669: p_est_information2 in varchar2 default hr_api.g_varchar2,

Line 666: p_attribute20 in varchar2 default hr_api.g_varchar2,

662: p_attribute16 in varchar2 default hr_api.g_varchar2,
663: p_attribute17 in varchar2 default hr_api.g_varchar2,
664: p_attribute18 in varchar2 default hr_api.g_varchar2,
665: p_attribute19 in varchar2 default hr_api.g_varchar2,
666: p_attribute20 in varchar2 default hr_api.g_varchar2,
667: p_est_information_category in varchar2 default hr_api.g_varchar2,
668: p_est_information1 in varchar2 default hr_api.g_varchar2,
669: p_est_information2 in varchar2 default hr_api.g_varchar2,
670: p_est_information3 in varchar2 default hr_api.g_varchar2,

Line 667: p_est_information_category in varchar2 default hr_api.g_varchar2,

663: p_attribute17 in varchar2 default hr_api.g_varchar2,
664: p_attribute18 in varchar2 default hr_api.g_varchar2,
665: p_attribute19 in varchar2 default hr_api.g_varchar2,
666: p_attribute20 in varchar2 default hr_api.g_varchar2,
667: p_est_information_category in varchar2 default hr_api.g_varchar2,
668: p_est_information1 in varchar2 default hr_api.g_varchar2,
669: p_est_information2 in varchar2 default hr_api.g_varchar2,
670: p_est_information3 in varchar2 default hr_api.g_varchar2,
671: p_est_information4 in varchar2 default hr_api.g_varchar2,

Line 668: p_est_information1 in varchar2 default hr_api.g_varchar2,

664: p_attribute18 in varchar2 default hr_api.g_varchar2,
665: p_attribute19 in varchar2 default hr_api.g_varchar2,
666: p_attribute20 in varchar2 default hr_api.g_varchar2,
667: p_est_information_category in varchar2 default hr_api.g_varchar2,
668: p_est_information1 in varchar2 default hr_api.g_varchar2,
669: p_est_information2 in varchar2 default hr_api.g_varchar2,
670: p_est_information3 in varchar2 default hr_api.g_varchar2,
671: p_est_information4 in varchar2 default hr_api.g_varchar2,
672: p_est_information5 in varchar2 default hr_api.g_varchar2,

Line 669: p_est_information2 in varchar2 default hr_api.g_varchar2,

665: p_attribute19 in varchar2 default hr_api.g_varchar2,
666: p_attribute20 in varchar2 default hr_api.g_varchar2,
667: p_est_information_category in varchar2 default hr_api.g_varchar2,
668: p_est_information1 in varchar2 default hr_api.g_varchar2,
669: p_est_information2 in varchar2 default hr_api.g_varchar2,
670: p_est_information3 in varchar2 default hr_api.g_varchar2,
671: p_est_information4 in varchar2 default hr_api.g_varchar2,
672: p_est_information5 in varchar2 default hr_api.g_varchar2,
673: p_est_information6 in varchar2 default hr_api.g_varchar2,

Line 670: p_est_information3 in varchar2 default hr_api.g_varchar2,

666: p_attribute20 in varchar2 default hr_api.g_varchar2,
667: p_est_information_category in varchar2 default hr_api.g_varchar2,
668: p_est_information1 in varchar2 default hr_api.g_varchar2,
669: p_est_information2 in varchar2 default hr_api.g_varchar2,
670: p_est_information3 in varchar2 default hr_api.g_varchar2,
671: p_est_information4 in varchar2 default hr_api.g_varchar2,
672: p_est_information5 in varchar2 default hr_api.g_varchar2,
673: p_est_information6 in varchar2 default hr_api.g_varchar2,
674: p_est_information7 in varchar2 default hr_api.g_varchar2,

Line 671: p_est_information4 in varchar2 default hr_api.g_varchar2,

667: p_est_information_category in varchar2 default hr_api.g_varchar2,
668: p_est_information1 in varchar2 default hr_api.g_varchar2,
669: p_est_information2 in varchar2 default hr_api.g_varchar2,
670: p_est_information3 in varchar2 default hr_api.g_varchar2,
671: p_est_information4 in varchar2 default hr_api.g_varchar2,
672: p_est_information5 in varchar2 default hr_api.g_varchar2,
673: p_est_information6 in varchar2 default hr_api.g_varchar2,
674: p_est_information7 in varchar2 default hr_api.g_varchar2,
675: p_est_information8 in varchar2 default hr_api.g_varchar2,

Line 672: p_est_information5 in varchar2 default hr_api.g_varchar2,

668: p_est_information1 in varchar2 default hr_api.g_varchar2,
669: p_est_information2 in varchar2 default hr_api.g_varchar2,
670: p_est_information3 in varchar2 default hr_api.g_varchar2,
671: p_est_information4 in varchar2 default hr_api.g_varchar2,
672: p_est_information5 in varchar2 default hr_api.g_varchar2,
673: p_est_information6 in varchar2 default hr_api.g_varchar2,
674: p_est_information7 in varchar2 default hr_api.g_varchar2,
675: p_est_information8 in varchar2 default hr_api.g_varchar2,
676: p_est_information9 in varchar2 default hr_api.g_varchar2,

Line 673: p_est_information6 in varchar2 default hr_api.g_varchar2,

669: p_est_information2 in varchar2 default hr_api.g_varchar2,
670: p_est_information3 in varchar2 default hr_api.g_varchar2,
671: p_est_information4 in varchar2 default hr_api.g_varchar2,
672: p_est_information5 in varchar2 default hr_api.g_varchar2,
673: p_est_information6 in varchar2 default hr_api.g_varchar2,
674: p_est_information7 in varchar2 default hr_api.g_varchar2,
675: p_est_information8 in varchar2 default hr_api.g_varchar2,
676: p_est_information9 in varchar2 default hr_api.g_varchar2,
677: p_est_information10 in varchar2 default hr_api.g_varchar2,

Line 674: p_est_information7 in varchar2 default hr_api.g_varchar2,

670: p_est_information3 in varchar2 default hr_api.g_varchar2,
671: p_est_information4 in varchar2 default hr_api.g_varchar2,
672: p_est_information5 in varchar2 default hr_api.g_varchar2,
673: p_est_information6 in varchar2 default hr_api.g_varchar2,
674: p_est_information7 in varchar2 default hr_api.g_varchar2,
675: p_est_information8 in varchar2 default hr_api.g_varchar2,
676: p_est_information9 in varchar2 default hr_api.g_varchar2,
677: p_est_information10 in varchar2 default hr_api.g_varchar2,
678: p_est_information11 in varchar2 default hr_api.g_varchar2,

Line 675: p_est_information8 in varchar2 default hr_api.g_varchar2,

671: p_est_information4 in varchar2 default hr_api.g_varchar2,
672: p_est_information5 in varchar2 default hr_api.g_varchar2,
673: p_est_information6 in varchar2 default hr_api.g_varchar2,
674: p_est_information7 in varchar2 default hr_api.g_varchar2,
675: p_est_information8 in varchar2 default hr_api.g_varchar2,
676: p_est_information9 in varchar2 default hr_api.g_varchar2,
677: p_est_information10 in varchar2 default hr_api.g_varchar2,
678: p_est_information11 in varchar2 default hr_api.g_varchar2,
679: p_est_information12 in varchar2 default hr_api.g_varchar2,

Line 676: p_est_information9 in varchar2 default hr_api.g_varchar2,

672: p_est_information5 in varchar2 default hr_api.g_varchar2,
673: p_est_information6 in varchar2 default hr_api.g_varchar2,
674: p_est_information7 in varchar2 default hr_api.g_varchar2,
675: p_est_information8 in varchar2 default hr_api.g_varchar2,
676: p_est_information9 in varchar2 default hr_api.g_varchar2,
677: p_est_information10 in varchar2 default hr_api.g_varchar2,
678: p_est_information11 in varchar2 default hr_api.g_varchar2,
679: p_est_information12 in varchar2 default hr_api.g_varchar2,
680: p_est_information13 in varchar2 default hr_api.g_varchar2,

Line 677: p_est_information10 in varchar2 default hr_api.g_varchar2,

673: p_est_information6 in varchar2 default hr_api.g_varchar2,
674: p_est_information7 in varchar2 default hr_api.g_varchar2,
675: p_est_information8 in varchar2 default hr_api.g_varchar2,
676: p_est_information9 in varchar2 default hr_api.g_varchar2,
677: p_est_information10 in varchar2 default hr_api.g_varchar2,
678: p_est_information11 in varchar2 default hr_api.g_varchar2,
679: p_est_information12 in varchar2 default hr_api.g_varchar2,
680: p_est_information13 in varchar2 default hr_api.g_varchar2,
681: p_est_information14 in varchar2 default hr_api.g_varchar2,

Line 678: p_est_information11 in varchar2 default hr_api.g_varchar2,

674: p_est_information7 in varchar2 default hr_api.g_varchar2,
675: p_est_information8 in varchar2 default hr_api.g_varchar2,
676: p_est_information9 in varchar2 default hr_api.g_varchar2,
677: p_est_information10 in varchar2 default hr_api.g_varchar2,
678: p_est_information11 in varchar2 default hr_api.g_varchar2,
679: p_est_information12 in varchar2 default hr_api.g_varchar2,
680: p_est_information13 in varchar2 default hr_api.g_varchar2,
681: p_est_information14 in varchar2 default hr_api.g_varchar2,
682: p_est_information15 in varchar2 default hr_api.g_varchar2,

Line 679: p_est_information12 in varchar2 default hr_api.g_varchar2,

675: p_est_information8 in varchar2 default hr_api.g_varchar2,
676: p_est_information9 in varchar2 default hr_api.g_varchar2,
677: p_est_information10 in varchar2 default hr_api.g_varchar2,
678: p_est_information11 in varchar2 default hr_api.g_varchar2,
679: p_est_information12 in varchar2 default hr_api.g_varchar2,
680: p_est_information13 in varchar2 default hr_api.g_varchar2,
681: p_est_information14 in varchar2 default hr_api.g_varchar2,
682: p_est_information15 in varchar2 default hr_api.g_varchar2,
683: p_est_information16 in varchar2 default hr_api.g_varchar2,

Line 680: p_est_information13 in varchar2 default hr_api.g_varchar2,

676: p_est_information9 in varchar2 default hr_api.g_varchar2,
677: p_est_information10 in varchar2 default hr_api.g_varchar2,
678: p_est_information11 in varchar2 default hr_api.g_varchar2,
679: p_est_information12 in varchar2 default hr_api.g_varchar2,
680: p_est_information13 in varchar2 default hr_api.g_varchar2,
681: p_est_information14 in varchar2 default hr_api.g_varchar2,
682: p_est_information15 in varchar2 default hr_api.g_varchar2,
683: p_est_information16 in varchar2 default hr_api.g_varchar2,
684: p_est_information17 in varchar2 default hr_api.g_varchar2,

Line 681: p_est_information14 in varchar2 default hr_api.g_varchar2,

677: p_est_information10 in varchar2 default hr_api.g_varchar2,
678: p_est_information11 in varchar2 default hr_api.g_varchar2,
679: p_est_information12 in varchar2 default hr_api.g_varchar2,
680: p_est_information13 in varchar2 default hr_api.g_varchar2,
681: p_est_information14 in varchar2 default hr_api.g_varchar2,
682: p_est_information15 in varchar2 default hr_api.g_varchar2,
683: p_est_information16 in varchar2 default hr_api.g_varchar2,
684: p_est_information17 in varchar2 default hr_api.g_varchar2,
685: p_est_information18 in varchar2 default hr_api.g_varchar2,

Line 682: p_est_information15 in varchar2 default hr_api.g_varchar2,

678: p_est_information11 in varchar2 default hr_api.g_varchar2,
679: p_est_information12 in varchar2 default hr_api.g_varchar2,
680: p_est_information13 in varchar2 default hr_api.g_varchar2,
681: p_est_information14 in varchar2 default hr_api.g_varchar2,
682: p_est_information15 in varchar2 default hr_api.g_varchar2,
683: p_est_information16 in varchar2 default hr_api.g_varchar2,
684: p_est_information17 in varchar2 default hr_api.g_varchar2,
685: p_est_information18 in varchar2 default hr_api.g_varchar2,
686: p_est_information19 in varchar2 default hr_api.g_varchar2,

Line 683: p_est_information16 in varchar2 default hr_api.g_varchar2,

679: p_est_information12 in varchar2 default hr_api.g_varchar2,
680: p_est_information13 in varchar2 default hr_api.g_varchar2,
681: p_est_information14 in varchar2 default hr_api.g_varchar2,
682: p_est_information15 in varchar2 default hr_api.g_varchar2,
683: p_est_information16 in varchar2 default hr_api.g_varchar2,
684: p_est_information17 in varchar2 default hr_api.g_varchar2,
685: p_est_information18 in varchar2 default hr_api.g_varchar2,
686: p_est_information19 in varchar2 default hr_api.g_varchar2,
687: p_est_information20 in varchar2 default hr_api.g_varchar2,

Line 684: p_est_information17 in varchar2 default hr_api.g_varchar2,

680: p_est_information13 in varchar2 default hr_api.g_varchar2,
681: p_est_information14 in varchar2 default hr_api.g_varchar2,
682: p_est_information15 in varchar2 default hr_api.g_varchar2,
683: p_est_information16 in varchar2 default hr_api.g_varchar2,
684: p_est_information17 in varchar2 default hr_api.g_varchar2,
685: p_est_information18 in varchar2 default hr_api.g_varchar2,
686: p_est_information19 in varchar2 default hr_api.g_varchar2,
687: p_est_information20 in varchar2 default hr_api.g_varchar2,
688: p_object_version_number in out nocopy number,

Line 685: p_est_information18 in varchar2 default hr_api.g_varchar2,

681: p_est_information14 in varchar2 default hr_api.g_varchar2,
682: p_est_information15 in varchar2 default hr_api.g_varchar2,
683: p_est_information16 in varchar2 default hr_api.g_varchar2,
684: p_est_information17 in varchar2 default hr_api.g_varchar2,
685: p_est_information18 in varchar2 default hr_api.g_varchar2,
686: p_est_information19 in varchar2 default hr_api.g_varchar2,
687: p_est_information20 in varchar2 default hr_api.g_varchar2,
688: p_object_version_number in out nocopy number,
689: p_validate in boolean default false

Line 686: p_est_information19 in varchar2 default hr_api.g_varchar2,

682: p_est_information15 in varchar2 default hr_api.g_varchar2,
683: p_est_information16 in varchar2 default hr_api.g_varchar2,
684: p_est_information17 in varchar2 default hr_api.g_varchar2,
685: p_est_information18 in varchar2 default hr_api.g_varchar2,
686: p_est_information19 in varchar2 default hr_api.g_varchar2,
687: p_est_information20 in varchar2 default hr_api.g_varchar2,
688: p_object_version_number in out nocopy number,
689: p_validate in boolean default false
690: ) is

Line 687: p_est_information20 in varchar2 default hr_api.g_varchar2,

683: p_est_information16 in varchar2 default hr_api.g_varchar2,
684: p_est_information17 in varchar2 default hr_api.g_varchar2,
685: p_est_information18 in varchar2 default hr_api.g_varchar2,
686: p_est_information19 in varchar2 default hr_api.g_varchar2,
687: p_est_information20 in varchar2 default hr_api.g_varchar2,
688: p_object_version_number in out nocopy number,
689: p_validate in boolean default false
690: ) is
691: --