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