134: --
135: hr_utility.set_location(' Leaving:'||l_proc, 10);
136: --
137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
141: hr_lei_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
141: hr_lei_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.parent_integrity_violated Then
144: -- Parent integrity has been violated
145: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
146: hr_lei_shd.constraint_error
139: -- A check constraint has been violated
140: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
141: hr_lei_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.parent_integrity_violated Then
144: -- Parent integrity has been violated
145: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
146: hr_lei_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.parent_integrity_violated Then
144: -- Parent integrity has been violated
145: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
146: hr_lei_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.unique_integrity_violated Then
149: -- Unique integrity has been violated
150: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
151: hr_lei_shd.constraint_error
144: -- Parent integrity has been violated
145: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
146: hr_lei_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.unique_integrity_violated Then
149: -- Unique integrity has been violated
150: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
151: hr_lei_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.unique_integrity_violated Then
149: -- Unique integrity has been violated
150: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
151: hr_lei_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When Others Then
154: -- hr_lei_shd.g_api_dml := false; -- Unset the api dml status
155: Raise;
156: End update_dml;
358: p_lei_information29_o => hr_lei_shd.g_old_rec.lei_information29,
359: p_lei_information30_o => hr_lei_shd.g_old_rec.lei_information30
360: );
361: exception
362: when hr_api.cannot_find_prog_unit then
363: hr_api.cannot_find_prog_unit_error
364: ( p_module_name => 'HR_LOCATION_EXTRA_INFO'
365: ,p_hook_type => 'AU'
366: );
359: p_lei_information30_o => hr_lei_shd.g_old_rec.lei_information30
360: );
361: exception
362: when hr_api.cannot_find_prog_unit then
363: hr_api.cannot_find_prog_unit_error
364: ( p_module_name => 'HR_LOCATION_EXTRA_INFO'
365: ,p_hook_type => 'AU'
366: );
367: end;
426: -- p_rec plsql record structure
427: -- to see if a system default is being used. If a system default
428: -- is being used then we must set to the 'current' argument value.
429: --
430: If (p_rec.information_type = hr_api.g_varchar2) then
431: p_rec.information_type :=
432: hr_lei_shd.g_old_rec.information_type;
433: End If;
434: If (p_rec.location_id = hr_api.g_number) then
430: If (p_rec.information_type = hr_api.g_varchar2) then
431: p_rec.information_type :=
432: hr_lei_shd.g_old_rec.information_type;
433: End If;
434: If (p_rec.location_id = hr_api.g_number) then
435: p_rec.location_id :=
436: hr_lei_shd.g_old_rec.location_id;
437: End If;
438: If (p_rec.request_id = hr_api.g_number) then
434: If (p_rec.location_id = hr_api.g_number) then
435: p_rec.location_id :=
436: hr_lei_shd.g_old_rec.location_id;
437: End If;
438: If (p_rec.request_id = hr_api.g_number) then
439: p_rec.request_id :=
440: hr_lei_shd.g_old_rec.request_id;
441: End If;
442: If (p_rec.program_application_id = hr_api.g_number) then
438: If (p_rec.request_id = hr_api.g_number) then
439: p_rec.request_id :=
440: hr_lei_shd.g_old_rec.request_id;
441: End If;
442: If (p_rec.program_application_id = hr_api.g_number) then
443: p_rec.program_application_id :=
444: hr_lei_shd.g_old_rec.program_application_id;
445: End If;
446: If (p_rec.program_id = hr_api.g_number) then
442: If (p_rec.program_application_id = hr_api.g_number) then
443: p_rec.program_application_id :=
444: hr_lei_shd.g_old_rec.program_application_id;
445: End If;
446: If (p_rec.program_id = hr_api.g_number) then
447: p_rec.program_id :=
448: hr_lei_shd.g_old_rec.program_id;
449: End If;
450: If (p_rec.program_update_date = hr_api.g_date) then
446: If (p_rec.program_id = hr_api.g_number) then
447: p_rec.program_id :=
448: hr_lei_shd.g_old_rec.program_id;
449: End If;
450: If (p_rec.program_update_date = hr_api.g_date) then
451: p_rec.program_update_date :=
452: hr_lei_shd.g_old_rec.program_update_date;
453: End If;
454: If (p_rec.lei_attribute_category = hr_api.g_varchar2) then
450: If (p_rec.program_update_date = hr_api.g_date) then
451: p_rec.program_update_date :=
452: hr_lei_shd.g_old_rec.program_update_date;
453: End If;
454: If (p_rec.lei_attribute_category = hr_api.g_varchar2) then
455: p_rec.lei_attribute_category :=
456: hr_lei_shd.g_old_rec.lei_attribute_category;
457: End If;
458: If (p_rec.lei_attribute1 = hr_api.g_varchar2) then
454: If (p_rec.lei_attribute_category = hr_api.g_varchar2) then
455: p_rec.lei_attribute_category :=
456: hr_lei_shd.g_old_rec.lei_attribute_category;
457: End If;
458: If (p_rec.lei_attribute1 = hr_api.g_varchar2) then
459: p_rec.lei_attribute1 :=
460: hr_lei_shd.g_old_rec.lei_attribute1;
461: End If;
462: If (p_rec.lei_attribute2 = hr_api.g_varchar2) then
458: If (p_rec.lei_attribute1 = hr_api.g_varchar2) then
459: p_rec.lei_attribute1 :=
460: hr_lei_shd.g_old_rec.lei_attribute1;
461: End If;
462: If (p_rec.lei_attribute2 = hr_api.g_varchar2) then
463: p_rec.lei_attribute2 :=
464: hr_lei_shd.g_old_rec.lei_attribute2;
465: End If;
466: If (p_rec.lei_attribute3 = hr_api.g_varchar2) then
462: If (p_rec.lei_attribute2 = hr_api.g_varchar2) then
463: p_rec.lei_attribute2 :=
464: hr_lei_shd.g_old_rec.lei_attribute2;
465: End If;
466: If (p_rec.lei_attribute3 = hr_api.g_varchar2) then
467: p_rec.lei_attribute3 :=
468: hr_lei_shd.g_old_rec.lei_attribute3;
469: End If;
470: If (p_rec.lei_attribute4 = hr_api.g_varchar2) then
466: If (p_rec.lei_attribute3 = hr_api.g_varchar2) then
467: p_rec.lei_attribute3 :=
468: hr_lei_shd.g_old_rec.lei_attribute3;
469: End If;
470: If (p_rec.lei_attribute4 = hr_api.g_varchar2) then
471: p_rec.lei_attribute4 :=
472: hr_lei_shd.g_old_rec.lei_attribute4;
473: End If;
474: If (p_rec.lei_attribute5 = hr_api.g_varchar2) then
470: If (p_rec.lei_attribute4 = hr_api.g_varchar2) then
471: p_rec.lei_attribute4 :=
472: hr_lei_shd.g_old_rec.lei_attribute4;
473: End If;
474: If (p_rec.lei_attribute5 = hr_api.g_varchar2) then
475: p_rec.lei_attribute5 :=
476: hr_lei_shd.g_old_rec.lei_attribute5;
477: End If;
478: If (p_rec.lei_attribute6 = hr_api.g_varchar2) then
474: If (p_rec.lei_attribute5 = hr_api.g_varchar2) then
475: p_rec.lei_attribute5 :=
476: hr_lei_shd.g_old_rec.lei_attribute5;
477: End If;
478: If (p_rec.lei_attribute6 = hr_api.g_varchar2) then
479: p_rec.lei_attribute6 :=
480: hr_lei_shd.g_old_rec.lei_attribute6;
481: End If;
482: If (p_rec.lei_attribute7 = hr_api.g_varchar2) then
478: If (p_rec.lei_attribute6 = hr_api.g_varchar2) then
479: p_rec.lei_attribute6 :=
480: hr_lei_shd.g_old_rec.lei_attribute6;
481: End If;
482: If (p_rec.lei_attribute7 = hr_api.g_varchar2) then
483: p_rec.lei_attribute7 :=
484: hr_lei_shd.g_old_rec.lei_attribute7;
485: End If;
486: If (p_rec.lei_attribute8 = hr_api.g_varchar2) then
482: If (p_rec.lei_attribute7 = hr_api.g_varchar2) then
483: p_rec.lei_attribute7 :=
484: hr_lei_shd.g_old_rec.lei_attribute7;
485: End If;
486: If (p_rec.lei_attribute8 = hr_api.g_varchar2) then
487: p_rec.lei_attribute8 :=
488: hr_lei_shd.g_old_rec.lei_attribute8;
489: End If;
490: If (p_rec.lei_attribute9 = hr_api.g_varchar2) then
486: If (p_rec.lei_attribute8 = hr_api.g_varchar2) then
487: p_rec.lei_attribute8 :=
488: hr_lei_shd.g_old_rec.lei_attribute8;
489: End If;
490: If (p_rec.lei_attribute9 = hr_api.g_varchar2) then
491: p_rec.lei_attribute9 :=
492: hr_lei_shd.g_old_rec.lei_attribute9;
493: End If;
494: If (p_rec.lei_attribute10 = hr_api.g_varchar2) then
490: If (p_rec.lei_attribute9 = hr_api.g_varchar2) then
491: p_rec.lei_attribute9 :=
492: hr_lei_shd.g_old_rec.lei_attribute9;
493: End If;
494: If (p_rec.lei_attribute10 = hr_api.g_varchar2) then
495: p_rec.lei_attribute10 :=
496: hr_lei_shd.g_old_rec.lei_attribute10;
497: End If;
498: If (p_rec.lei_attribute11 = hr_api.g_varchar2) then
494: If (p_rec.lei_attribute10 = hr_api.g_varchar2) then
495: p_rec.lei_attribute10 :=
496: hr_lei_shd.g_old_rec.lei_attribute10;
497: End If;
498: If (p_rec.lei_attribute11 = hr_api.g_varchar2) then
499: p_rec.lei_attribute11 :=
500: hr_lei_shd.g_old_rec.lei_attribute11;
501: End If;
502: If (p_rec.lei_attribute12 = hr_api.g_varchar2) then
498: If (p_rec.lei_attribute11 = hr_api.g_varchar2) then
499: p_rec.lei_attribute11 :=
500: hr_lei_shd.g_old_rec.lei_attribute11;
501: End If;
502: If (p_rec.lei_attribute12 = hr_api.g_varchar2) then
503: p_rec.lei_attribute12 :=
504: hr_lei_shd.g_old_rec.lei_attribute12;
505: End If;
506: If (p_rec.lei_attribute13 = hr_api.g_varchar2) then
502: If (p_rec.lei_attribute12 = hr_api.g_varchar2) then
503: p_rec.lei_attribute12 :=
504: hr_lei_shd.g_old_rec.lei_attribute12;
505: End If;
506: If (p_rec.lei_attribute13 = hr_api.g_varchar2) then
507: p_rec.lei_attribute13 :=
508: hr_lei_shd.g_old_rec.lei_attribute13;
509: End If;
510: If (p_rec.lei_attribute14 = hr_api.g_varchar2) then
506: If (p_rec.lei_attribute13 = hr_api.g_varchar2) then
507: p_rec.lei_attribute13 :=
508: hr_lei_shd.g_old_rec.lei_attribute13;
509: End If;
510: If (p_rec.lei_attribute14 = hr_api.g_varchar2) then
511: p_rec.lei_attribute14 :=
512: hr_lei_shd.g_old_rec.lei_attribute14;
513: End If;
514: If (p_rec.lei_attribute15 = hr_api.g_varchar2) then
510: If (p_rec.lei_attribute14 = hr_api.g_varchar2) then
511: p_rec.lei_attribute14 :=
512: hr_lei_shd.g_old_rec.lei_attribute14;
513: End If;
514: If (p_rec.lei_attribute15 = hr_api.g_varchar2) then
515: p_rec.lei_attribute15 :=
516: hr_lei_shd.g_old_rec.lei_attribute15;
517: End If;
518: If (p_rec.lei_attribute16 = hr_api.g_varchar2) then
514: If (p_rec.lei_attribute15 = hr_api.g_varchar2) then
515: p_rec.lei_attribute15 :=
516: hr_lei_shd.g_old_rec.lei_attribute15;
517: End If;
518: If (p_rec.lei_attribute16 = hr_api.g_varchar2) then
519: p_rec.lei_attribute16 :=
520: hr_lei_shd.g_old_rec.lei_attribute16;
521: End If;
522: If (p_rec.lei_attribute17 = hr_api.g_varchar2) then
518: If (p_rec.lei_attribute16 = hr_api.g_varchar2) then
519: p_rec.lei_attribute16 :=
520: hr_lei_shd.g_old_rec.lei_attribute16;
521: End If;
522: If (p_rec.lei_attribute17 = hr_api.g_varchar2) then
523: p_rec.lei_attribute17 :=
524: hr_lei_shd.g_old_rec.lei_attribute17;
525: End If;
526: If (p_rec.lei_attribute18 = hr_api.g_varchar2) then
522: If (p_rec.lei_attribute17 = hr_api.g_varchar2) then
523: p_rec.lei_attribute17 :=
524: hr_lei_shd.g_old_rec.lei_attribute17;
525: End If;
526: If (p_rec.lei_attribute18 = hr_api.g_varchar2) then
527: p_rec.lei_attribute18 :=
528: hr_lei_shd.g_old_rec.lei_attribute18;
529: End If;
530: If (p_rec.lei_attribute19 = hr_api.g_varchar2) then
526: If (p_rec.lei_attribute18 = hr_api.g_varchar2) then
527: p_rec.lei_attribute18 :=
528: hr_lei_shd.g_old_rec.lei_attribute18;
529: End If;
530: If (p_rec.lei_attribute19 = hr_api.g_varchar2) then
531: p_rec.lei_attribute19 :=
532: hr_lei_shd.g_old_rec.lei_attribute19;
533: End If;
534: If (p_rec.lei_attribute20 = hr_api.g_varchar2) then
530: If (p_rec.lei_attribute19 = hr_api.g_varchar2) then
531: p_rec.lei_attribute19 :=
532: hr_lei_shd.g_old_rec.lei_attribute19;
533: End If;
534: If (p_rec.lei_attribute20 = hr_api.g_varchar2) then
535: p_rec.lei_attribute20 :=
536: hr_lei_shd.g_old_rec.lei_attribute20;
537: End If;
538: If (p_rec.lei_information_category = hr_api.g_varchar2) then
534: If (p_rec.lei_attribute20 = hr_api.g_varchar2) then
535: p_rec.lei_attribute20 :=
536: hr_lei_shd.g_old_rec.lei_attribute20;
537: End If;
538: If (p_rec.lei_information_category = hr_api.g_varchar2) then
539: p_rec.lei_information_category :=
540: hr_lei_shd.g_old_rec.lei_information_category;
541: End If;
542: If (p_rec.lei_information1 = hr_api.g_varchar2) then
538: If (p_rec.lei_information_category = hr_api.g_varchar2) then
539: p_rec.lei_information_category :=
540: hr_lei_shd.g_old_rec.lei_information_category;
541: End If;
542: If (p_rec.lei_information1 = hr_api.g_varchar2) then
543: p_rec.lei_information1 :=
544: hr_lei_shd.g_old_rec.lei_information1;
545: End If;
546: If (p_rec.lei_information2 = hr_api.g_varchar2) then
542: If (p_rec.lei_information1 = hr_api.g_varchar2) then
543: p_rec.lei_information1 :=
544: hr_lei_shd.g_old_rec.lei_information1;
545: End If;
546: If (p_rec.lei_information2 = hr_api.g_varchar2) then
547: p_rec.lei_information2 :=
548: hr_lei_shd.g_old_rec.lei_information2;
549: End If;
550: If (p_rec.lei_information3 = hr_api.g_varchar2) then
546: If (p_rec.lei_information2 = hr_api.g_varchar2) then
547: p_rec.lei_information2 :=
548: hr_lei_shd.g_old_rec.lei_information2;
549: End If;
550: If (p_rec.lei_information3 = hr_api.g_varchar2) then
551: p_rec.lei_information3 :=
552: hr_lei_shd.g_old_rec.lei_information3;
553: End If;
554: If (p_rec.lei_information4 = hr_api.g_varchar2) then
550: If (p_rec.lei_information3 = hr_api.g_varchar2) then
551: p_rec.lei_information3 :=
552: hr_lei_shd.g_old_rec.lei_information3;
553: End If;
554: If (p_rec.lei_information4 = hr_api.g_varchar2) then
555: p_rec.lei_information4 :=
556: hr_lei_shd.g_old_rec.lei_information4;
557: End If;
558: If (p_rec.lei_information5 = hr_api.g_varchar2) then
554: If (p_rec.lei_information4 = hr_api.g_varchar2) then
555: p_rec.lei_information4 :=
556: hr_lei_shd.g_old_rec.lei_information4;
557: End If;
558: If (p_rec.lei_information5 = hr_api.g_varchar2) then
559: p_rec.lei_information5 :=
560: hr_lei_shd.g_old_rec.lei_information5;
561: End If;
562: If (p_rec.lei_information6 = hr_api.g_varchar2) then
558: If (p_rec.lei_information5 = hr_api.g_varchar2) then
559: p_rec.lei_information5 :=
560: hr_lei_shd.g_old_rec.lei_information5;
561: End If;
562: If (p_rec.lei_information6 = hr_api.g_varchar2) then
563: p_rec.lei_information6 :=
564: hr_lei_shd.g_old_rec.lei_information6;
565: End If;
566: If (p_rec.lei_information7 = hr_api.g_varchar2) then
562: If (p_rec.lei_information6 = hr_api.g_varchar2) then
563: p_rec.lei_information6 :=
564: hr_lei_shd.g_old_rec.lei_information6;
565: End If;
566: If (p_rec.lei_information7 = hr_api.g_varchar2) then
567: p_rec.lei_information7 :=
568: hr_lei_shd.g_old_rec.lei_information7;
569: End If;
570: If (p_rec.lei_information8 = hr_api.g_varchar2) then
566: If (p_rec.lei_information7 = hr_api.g_varchar2) then
567: p_rec.lei_information7 :=
568: hr_lei_shd.g_old_rec.lei_information7;
569: End If;
570: If (p_rec.lei_information8 = hr_api.g_varchar2) then
571: p_rec.lei_information8 :=
572: hr_lei_shd.g_old_rec.lei_information8;
573: End If;
574: If (p_rec.lei_information9 = hr_api.g_varchar2) then
570: If (p_rec.lei_information8 = hr_api.g_varchar2) then
571: p_rec.lei_information8 :=
572: hr_lei_shd.g_old_rec.lei_information8;
573: End If;
574: If (p_rec.lei_information9 = hr_api.g_varchar2) then
575: p_rec.lei_information9 :=
576: hr_lei_shd.g_old_rec.lei_information9;
577: End If;
578: If (p_rec.lei_information10 = hr_api.g_varchar2) then
574: If (p_rec.lei_information9 = hr_api.g_varchar2) then
575: p_rec.lei_information9 :=
576: hr_lei_shd.g_old_rec.lei_information9;
577: End If;
578: If (p_rec.lei_information10 = hr_api.g_varchar2) then
579: p_rec.lei_information10 :=
580: hr_lei_shd.g_old_rec.lei_information10;
581: End If;
582: If (p_rec.lei_information11 = hr_api.g_varchar2) then
578: If (p_rec.lei_information10 = hr_api.g_varchar2) then
579: p_rec.lei_information10 :=
580: hr_lei_shd.g_old_rec.lei_information10;
581: End If;
582: If (p_rec.lei_information11 = hr_api.g_varchar2) then
583: p_rec.lei_information11 :=
584: hr_lei_shd.g_old_rec.lei_information11;
585: End If;
586: If (p_rec.lei_information12 = hr_api.g_varchar2) then
582: If (p_rec.lei_information11 = hr_api.g_varchar2) then
583: p_rec.lei_information11 :=
584: hr_lei_shd.g_old_rec.lei_information11;
585: End If;
586: If (p_rec.lei_information12 = hr_api.g_varchar2) then
587: p_rec.lei_information12 :=
588: hr_lei_shd.g_old_rec.lei_information12;
589: End If;
590: If (p_rec.lei_information13 = hr_api.g_varchar2) then
586: If (p_rec.lei_information12 = hr_api.g_varchar2) then
587: p_rec.lei_information12 :=
588: hr_lei_shd.g_old_rec.lei_information12;
589: End If;
590: If (p_rec.lei_information13 = hr_api.g_varchar2) then
591: p_rec.lei_information13 :=
592: hr_lei_shd.g_old_rec.lei_information13;
593: End If;
594: If (p_rec.lei_information14 = hr_api.g_varchar2) then
590: If (p_rec.lei_information13 = hr_api.g_varchar2) then
591: p_rec.lei_information13 :=
592: hr_lei_shd.g_old_rec.lei_information13;
593: End If;
594: If (p_rec.lei_information14 = hr_api.g_varchar2) then
595: p_rec.lei_information14 :=
596: hr_lei_shd.g_old_rec.lei_information14;
597: End If;
598: If (p_rec.lei_information15 = hr_api.g_varchar2) then
594: If (p_rec.lei_information14 = hr_api.g_varchar2) then
595: p_rec.lei_information14 :=
596: hr_lei_shd.g_old_rec.lei_information14;
597: End If;
598: If (p_rec.lei_information15 = hr_api.g_varchar2) then
599: p_rec.lei_information15 :=
600: hr_lei_shd.g_old_rec.lei_information15;
601: End If;
602: If (p_rec.lei_information16 = hr_api.g_varchar2) then
598: If (p_rec.lei_information15 = hr_api.g_varchar2) then
599: p_rec.lei_information15 :=
600: hr_lei_shd.g_old_rec.lei_information15;
601: End If;
602: If (p_rec.lei_information16 = hr_api.g_varchar2) then
603: p_rec.lei_information16 :=
604: hr_lei_shd.g_old_rec.lei_information16;
605: End If;
606: If (p_rec.lei_information17 = hr_api.g_varchar2) then
602: If (p_rec.lei_information16 = hr_api.g_varchar2) then
603: p_rec.lei_information16 :=
604: hr_lei_shd.g_old_rec.lei_information16;
605: End If;
606: If (p_rec.lei_information17 = hr_api.g_varchar2) then
607: p_rec.lei_information17 :=
608: hr_lei_shd.g_old_rec.lei_information17;
609: End If;
610: If (p_rec.lei_information18 = hr_api.g_varchar2) then
606: If (p_rec.lei_information17 = hr_api.g_varchar2) then
607: p_rec.lei_information17 :=
608: hr_lei_shd.g_old_rec.lei_information17;
609: End If;
610: If (p_rec.lei_information18 = hr_api.g_varchar2) then
611: p_rec.lei_information18 :=
612: hr_lei_shd.g_old_rec.lei_information18;
613: End If;
614: If (p_rec.lei_information19 = hr_api.g_varchar2) then
610: If (p_rec.lei_information18 = hr_api.g_varchar2) then
611: p_rec.lei_information18 :=
612: hr_lei_shd.g_old_rec.lei_information18;
613: End If;
614: If (p_rec.lei_information19 = hr_api.g_varchar2) then
615: p_rec.lei_information19 :=
616: hr_lei_shd.g_old_rec.lei_information19;
617: End If;
618: If (p_rec.lei_information20 = hr_api.g_varchar2) then
614: If (p_rec.lei_information19 = hr_api.g_varchar2) then
615: p_rec.lei_information19 :=
616: hr_lei_shd.g_old_rec.lei_information19;
617: End If;
618: If (p_rec.lei_information20 = hr_api.g_varchar2) then
619: p_rec.lei_information20 :=
620: hr_lei_shd.g_old_rec.lei_information20;
621: End If;
622: If (p_rec.lei_information21 = hr_api.g_varchar2) then
618: If (p_rec.lei_information20 = hr_api.g_varchar2) then
619: p_rec.lei_information20 :=
620: hr_lei_shd.g_old_rec.lei_information20;
621: End If;
622: If (p_rec.lei_information21 = hr_api.g_varchar2) then
623: p_rec.lei_information21 :=
624: hr_lei_shd.g_old_rec.lei_information21;
625: End If;
626: If (p_rec.lei_information22 = hr_api.g_varchar2) then
622: If (p_rec.lei_information21 = hr_api.g_varchar2) then
623: p_rec.lei_information21 :=
624: hr_lei_shd.g_old_rec.lei_information21;
625: End If;
626: If (p_rec.lei_information22 = hr_api.g_varchar2) then
627: p_rec.lei_information22 :=
628: hr_lei_shd.g_old_rec.lei_information22;
629: End If;
630: If (p_rec.lei_information23 = hr_api.g_varchar2) then
626: If (p_rec.lei_information22 = hr_api.g_varchar2) then
627: p_rec.lei_information22 :=
628: hr_lei_shd.g_old_rec.lei_information22;
629: End If;
630: If (p_rec.lei_information23 = hr_api.g_varchar2) then
631: p_rec.lei_information23 :=
632: hr_lei_shd.g_old_rec.lei_information23;
633: End If;
634: If (p_rec.lei_information24 = hr_api.g_varchar2) then
630: If (p_rec.lei_information23 = hr_api.g_varchar2) then
631: p_rec.lei_information23 :=
632: hr_lei_shd.g_old_rec.lei_information23;
633: End If;
634: If (p_rec.lei_information24 = hr_api.g_varchar2) then
635: p_rec.lei_information24 :=
636: hr_lei_shd.g_old_rec.lei_information24;
637: End If;
638: If (p_rec.lei_information25 = hr_api.g_varchar2) then
634: If (p_rec.lei_information24 = hr_api.g_varchar2) then
635: p_rec.lei_information24 :=
636: hr_lei_shd.g_old_rec.lei_information24;
637: End If;
638: If (p_rec.lei_information25 = hr_api.g_varchar2) then
639: p_rec.lei_information25 :=
640: hr_lei_shd.g_old_rec.lei_information25;
641: End If;
642: If (p_rec.lei_information26 = hr_api.g_varchar2) then
638: If (p_rec.lei_information25 = hr_api.g_varchar2) then
639: p_rec.lei_information25 :=
640: hr_lei_shd.g_old_rec.lei_information25;
641: End If;
642: If (p_rec.lei_information26 = hr_api.g_varchar2) then
643: p_rec.lei_information26 :=
644: hr_lei_shd.g_old_rec.lei_information26;
645: End If;
646: If (p_rec.lei_information27 = hr_api.g_varchar2) then
642: If (p_rec.lei_information26 = hr_api.g_varchar2) then
643: p_rec.lei_information26 :=
644: hr_lei_shd.g_old_rec.lei_information26;
645: End If;
646: If (p_rec.lei_information27 = hr_api.g_varchar2) then
647: p_rec.lei_information27 :=
648: hr_lei_shd.g_old_rec.lei_information27;
649: End If;
650: If (p_rec.lei_information28 = hr_api.g_varchar2) then
646: If (p_rec.lei_information27 = hr_api.g_varchar2) then
647: p_rec.lei_information27 :=
648: hr_lei_shd.g_old_rec.lei_information27;
649: End If;
650: If (p_rec.lei_information28 = hr_api.g_varchar2) then
651: p_rec.lei_information28 :=
652: hr_lei_shd.g_old_rec.lei_information28;
653: End If;
654: If (p_rec.lei_information29 = hr_api.g_varchar2) then
650: If (p_rec.lei_information28 = hr_api.g_varchar2) then
651: p_rec.lei_information28 :=
652: hr_lei_shd.g_old_rec.lei_information28;
653: End If;
654: If (p_rec.lei_information29 = hr_api.g_varchar2) then
655: p_rec.lei_information29 :=
656: hr_lei_shd.g_old_rec.lei_information29;
657: End If;
658: If (p_rec.lei_information30 = hr_api.g_varchar2) then
654: If (p_rec.lei_information29 = hr_api.g_varchar2) then
655: p_rec.lei_information29 :=
656: hr_lei_shd.g_old_rec.lei_information29;
657: End If;
658: If (p_rec.lei_information30 = hr_api.g_varchar2) then
659: p_rec.lei_information30 :=
660: hr_lei_shd.g_old_rec.lei_information30;
661: End If;
662:
719: --
720: -- If we are validating then raise the Validate_Enabled exception
721: --
722: If p_validate then
723: Raise HR_Api.Validate_Enabled;
724: End If;
725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 10);
727: Exception
724: End If;
725: --
726: hr_utility.set_location(' Leaving:'||l_proc, 10);
727: Exception
728: When HR_Api.Validate_Enabled Then
729: --
730: -- As the Validate_Enabled exception has been raised
731: -- we must rollback to the savepoint
732: --
738: -- ----------------------------------------------------------------------------
739: Procedure upd
740: (
741: p_location_extra_info_id in number,
742: p_information_type in varchar2 default hr_api.g_varchar2,
743: p_location_id in number default hr_api.g_number,
744: p_request_id in number default hr_api.g_number,
745: p_program_application_id in number default hr_api.g_number,
746: p_program_id in number default hr_api.g_number,
739: Procedure upd
740: (
741: p_location_extra_info_id in number,
742: p_information_type in varchar2 default hr_api.g_varchar2,
743: p_location_id in number default hr_api.g_number,
744: p_request_id in number default hr_api.g_number,
745: p_program_application_id in number default hr_api.g_number,
746: p_program_id in number default hr_api.g_number,
747: p_program_update_date in date default hr_api.g_date,
740: (
741: p_location_extra_info_id in number,
742: p_information_type in varchar2 default hr_api.g_varchar2,
743: p_location_id in number default hr_api.g_number,
744: p_request_id in number default hr_api.g_number,
745: p_program_application_id in number default hr_api.g_number,
746: p_program_id in number default hr_api.g_number,
747: p_program_update_date in date default hr_api.g_date,
748: p_lei_attribute_category in varchar2 default hr_api.g_varchar2,
741: p_location_extra_info_id in number,
742: p_information_type in varchar2 default hr_api.g_varchar2,
743: p_location_id in number default hr_api.g_number,
744: p_request_id in number default hr_api.g_number,
745: p_program_application_id in number default hr_api.g_number,
746: p_program_id in number default hr_api.g_number,
747: p_program_update_date in date default hr_api.g_date,
748: p_lei_attribute_category in varchar2 default hr_api.g_varchar2,
749: p_lei_attribute1 in varchar2 default hr_api.g_varchar2,
742: p_information_type in varchar2 default hr_api.g_varchar2,
743: p_location_id in number default hr_api.g_number,
744: p_request_id in number default hr_api.g_number,
745: p_program_application_id in number default hr_api.g_number,
746: p_program_id in number default hr_api.g_number,
747: p_program_update_date in date default hr_api.g_date,
748: p_lei_attribute_category in varchar2 default hr_api.g_varchar2,
749: p_lei_attribute1 in varchar2 default hr_api.g_varchar2,
750: p_lei_attribute2 in varchar2 default hr_api.g_varchar2,
743: p_location_id in number default hr_api.g_number,
744: p_request_id in number default hr_api.g_number,
745: p_program_application_id in number default hr_api.g_number,
746: p_program_id in number default hr_api.g_number,
747: p_program_update_date in date default hr_api.g_date,
748: p_lei_attribute_category in varchar2 default hr_api.g_varchar2,
749: p_lei_attribute1 in varchar2 default hr_api.g_varchar2,
750: p_lei_attribute2 in varchar2 default hr_api.g_varchar2,
751: p_lei_attribute3 in varchar2 default hr_api.g_varchar2,
744: p_request_id in number default hr_api.g_number,
745: p_program_application_id in number default hr_api.g_number,
746: p_program_id in number default hr_api.g_number,
747: p_program_update_date in date default hr_api.g_date,
748: p_lei_attribute_category in varchar2 default hr_api.g_varchar2,
749: p_lei_attribute1 in varchar2 default hr_api.g_varchar2,
750: p_lei_attribute2 in varchar2 default hr_api.g_varchar2,
751: p_lei_attribute3 in varchar2 default hr_api.g_varchar2,
752: p_lei_attribute4 in varchar2 default hr_api.g_varchar2,
745: p_program_application_id in number default hr_api.g_number,
746: p_program_id in number default hr_api.g_number,
747: p_program_update_date in date default hr_api.g_date,
748: p_lei_attribute_category in varchar2 default hr_api.g_varchar2,
749: p_lei_attribute1 in varchar2 default hr_api.g_varchar2,
750: p_lei_attribute2 in varchar2 default hr_api.g_varchar2,
751: p_lei_attribute3 in varchar2 default hr_api.g_varchar2,
752: p_lei_attribute4 in varchar2 default hr_api.g_varchar2,
753: p_lei_attribute5 in varchar2 default hr_api.g_varchar2,
746: p_program_id in number default hr_api.g_number,
747: p_program_update_date in date default hr_api.g_date,
748: p_lei_attribute_category in varchar2 default hr_api.g_varchar2,
749: p_lei_attribute1 in varchar2 default hr_api.g_varchar2,
750: p_lei_attribute2 in varchar2 default hr_api.g_varchar2,
751: p_lei_attribute3 in varchar2 default hr_api.g_varchar2,
752: p_lei_attribute4 in varchar2 default hr_api.g_varchar2,
753: p_lei_attribute5 in varchar2 default hr_api.g_varchar2,
754: p_lei_attribute6 in varchar2 default hr_api.g_varchar2,
747: p_program_update_date in date default hr_api.g_date,
748: p_lei_attribute_category in varchar2 default hr_api.g_varchar2,
749: p_lei_attribute1 in varchar2 default hr_api.g_varchar2,
750: p_lei_attribute2 in varchar2 default hr_api.g_varchar2,
751: p_lei_attribute3 in varchar2 default hr_api.g_varchar2,
752: p_lei_attribute4 in varchar2 default hr_api.g_varchar2,
753: p_lei_attribute5 in varchar2 default hr_api.g_varchar2,
754: p_lei_attribute6 in varchar2 default hr_api.g_varchar2,
755: p_lei_attribute7 in varchar2 default hr_api.g_varchar2,
748: p_lei_attribute_category in varchar2 default hr_api.g_varchar2,
749: p_lei_attribute1 in varchar2 default hr_api.g_varchar2,
750: p_lei_attribute2 in varchar2 default hr_api.g_varchar2,
751: p_lei_attribute3 in varchar2 default hr_api.g_varchar2,
752: p_lei_attribute4 in varchar2 default hr_api.g_varchar2,
753: p_lei_attribute5 in varchar2 default hr_api.g_varchar2,
754: p_lei_attribute6 in varchar2 default hr_api.g_varchar2,
755: p_lei_attribute7 in varchar2 default hr_api.g_varchar2,
756: p_lei_attribute8 in varchar2 default hr_api.g_varchar2,
749: p_lei_attribute1 in varchar2 default hr_api.g_varchar2,
750: p_lei_attribute2 in varchar2 default hr_api.g_varchar2,
751: p_lei_attribute3 in varchar2 default hr_api.g_varchar2,
752: p_lei_attribute4 in varchar2 default hr_api.g_varchar2,
753: p_lei_attribute5 in varchar2 default hr_api.g_varchar2,
754: p_lei_attribute6 in varchar2 default hr_api.g_varchar2,
755: p_lei_attribute7 in varchar2 default hr_api.g_varchar2,
756: p_lei_attribute8 in varchar2 default hr_api.g_varchar2,
757: p_lei_attribute9 in varchar2 default hr_api.g_varchar2,
750: p_lei_attribute2 in varchar2 default hr_api.g_varchar2,
751: p_lei_attribute3 in varchar2 default hr_api.g_varchar2,
752: p_lei_attribute4 in varchar2 default hr_api.g_varchar2,
753: p_lei_attribute5 in varchar2 default hr_api.g_varchar2,
754: p_lei_attribute6 in varchar2 default hr_api.g_varchar2,
755: p_lei_attribute7 in varchar2 default hr_api.g_varchar2,
756: p_lei_attribute8 in varchar2 default hr_api.g_varchar2,
757: p_lei_attribute9 in varchar2 default hr_api.g_varchar2,
758: p_lei_attribute10 in varchar2 default hr_api.g_varchar2,
751: p_lei_attribute3 in varchar2 default hr_api.g_varchar2,
752: p_lei_attribute4 in varchar2 default hr_api.g_varchar2,
753: p_lei_attribute5 in varchar2 default hr_api.g_varchar2,
754: p_lei_attribute6 in varchar2 default hr_api.g_varchar2,
755: p_lei_attribute7 in varchar2 default hr_api.g_varchar2,
756: p_lei_attribute8 in varchar2 default hr_api.g_varchar2,
757: p_lei_attribute9 in varchar2 default hr_api.g_varchar2,
758: p_lei_attribute10 in varchar2 default hr_api.g_varchar2,
759: p_lei_attribute11 in varchar2 default hr_api.g_varchar2,
752: p_lei_attribute4 in varchar2 default hr_api.g_varchar2,
753: p_lei_attribute5 in varchar2 default hr_api.g_varchar2,
754: p_lei_attribute6 in varchar2 default hr_api.g_varchar2,
755: p_lei_attribute7 in varchar2 default hr_api.g_varchar2,
756: p_lei_attribute8 in varchar2 default hr_api.g_varchar2,
757: p_lei_attribute9 in varchar2 default hr_api.g_varchar2,
758: p_lei_attribute10 in varchar2 default hr_api.g_varchar2,
759: p_lei_attribute11 in varchar2 default hr_api.g_varchar2,
760: p_lei_attribute12 in varchar2 default hr_api.g_varchar2,
753: p_lei_attribute5 in varchar2 default hr_api.g_varchar2,
754: p_lei_attribute6 in varchar2 default hr_api.g_varchar2,
755: p_lei_attribute7 in varchar2 default hr_api.g_varchar2,
756: p_lei_attribute8 in varchar2 default hr_api.g_varchar2,
757: p_lei_attribute9 in varchar2 default hr_api.g_varchar2,
758: p_lei_attribute10 in varchar2 default hr_api.g_varchar2,
759: p_lei_attribute11 in varchar2 default hr_api.g_varchar2,
760: p_lei_attribute12 in varchar2 default hr_api.g_varchar2,
761: p_lei_attribute13 in varchar2 default hr_api.g_varchar2,
754: p_lei_attribute6 in varchar2 default hr_api.g_varchar2,
755: p_lei_attribute7 in varchar2 default hr_api.g_varchar2,
756: p_lei_attribute8 in varchar2 default hr_api.g_varchar2,
757: p_lei_attribute9 in varchar2 default hr_api.g_varchar2,
758: p_lei_attribute10 in varchar2 default hr_api.g_varchar2,
759: p_lei_attribute11 in varchar2 default hr_api.g_varchar2,
760: p_lei_attribute12 in varchar2 default hr_api.g_varchar2,
761: p_lei_attribute13 in varchar2 default hr_api.g_varchar2,
762: p_lei_attribute14 in varchar2 default hr_api.g_varchar2,
755: p_lei_attribute7 in varchar2 default hr_api.g_varchar2,
756: p_lei_attribute8 in varchar2 default hr_api.g_varchar2,
757: p_lei_attribute9 in varchar2 default hr_api.g_varchar2,
758: p_lei_attribute10 in varchar2 default hr_api.g_varchar2,
759: p_lei_attribute11 in varchar2 default hr_api.g_varchar2,
760: p_lei_attribute12 in varchar2 default hr_api.g_varchar2,
761: p_lei_attribute13 in varchar2 default hr_api.g_varchar2,
762: p_lei_attribute14 in varchar2 default hr_api.g_varchar2,
763: p_lei_attribute15 in varchar2 default hr_api.g_varchar2,
756: p_lei_attribute8 in varchar2 default hr_api.g_varchar2,
757: p_lei_attribute9 in varchar2 default hr_api.g_varchar2,
758: p_lei_attribute10 in varchar2 default hr_api.g_varchar2,
759: p_lei_attribute11 in varchar2 default hr_api.g_varchar2,
760: p_lei_attribute12 in varchar2 default hr_api.g_varchar2,
761: p_lei_attribute13 in varchar2 default hr_api.g_varchar2,
762: p_lei_attribute14 in varchar2 default hr_api.g_varchar2,
763: p_lei_attribute15 in varchar2 default hr_api.g_varchar2,
764: p_lei_attribute16 in varchar2 default hr_api.g_varchar2,
757: p_lei_attribute9 in varchar2 default hr_api.g_varchar2,
758: p_lei_attribute10 in varchar2 default hr_api.g_varchar2,
759: p_lei_attribute11 in varchar2 default hr_api.g_varchar2,
760: p_lei_attribute12 in varchar2 default hr_api.g_varchar2,
761: p_lei_attribute13 in varchar2 default hr_api.g_varchar2,
762: p_lei_attribute14 in varchar2 default hr_api.g_varchar2,
763: p_lei_attribute15 in varchar2 default hr_api.g_varchar2,
764: p_lei_attribute16 in varchar2 default hr_api.g_varchar2,
765: p_lei_attribute17 in varchar2 default hr_api.g_varchar2,
758: p_lei_attribute10 in varchar2 default hr_api.g_varchar2,
759: p_lei_attribute11 in varchar2 default hr_api.g_varchar2,
760: p_lei_attribute12 in varchar2 default hr_api.g_varchar2,
761: p_lei_attribute13 in varchar2 default hr_api.g_varchar2,
762: p_lei_attribute14 in varchar2 default hr_api.g_varchar2,
763: p_lei_attribute15 in varchar2 default hr_api.g_varchar2,
764: p_lei_attribute16 in varchar2 default hr_api.g_varchar2,
765: p_lei_attribute17 in varchar2 default hr_api.g_varchar2,
766: p_lei_attribute18 in varchar2 default hr_api.g_varchar2,
759: p_lei_attribute11 in varchar2 default hr_api.g_varchar2,
760: p_lei_attribute12 in varchar2 default hr_api.g_varchar2,
761: p_lei_attribute13 in varchar2 default hr_api.g_varchar2,
762: p_lei_attribute14 in varchar2 default hr_api.g_varchar2,
763: p_lei_attribute15 in varchar2 default hr_api.g_varchar2,
764: p_lei_attribute16 in varchar2 default hr_api.g_varchar2,
765: p_lei_attribute17 in varchar2 default hr_api.g_varchar2,
766: p_lei_attribute18 in varchar2 default hr_api.g_varchar2,
767: p_lei_attribute19 in varchar2 default hr_api.g_varchar2,
760: p_lei_attribute12 in varchar2 default hr_api.g_varchar2,
761: p_lei_attribute13 in varchar2 default hr_api.g_varchar2,
762: p_lei_attribute14 in varchar2 default hr_api.g_varchar2,
763: p_lei_attribute15 in varchar2 default hr_api.g_varchar2,
764: p_lei_attribute16 in varchar2 default hr_api.g_varchar2,
765: p_lei_attribute17 in varchar2 default hr_api.g_varchar2,
766: p_lei_attribute18 in varchar2 default hr_api.g_varchar2,
767: p_lei_attribute19 in varchar2 default hr_api.g_varchar2,
768: p_lei_attribute20 in varchar2 default hr_api.g_varchar2,
761: p_lei_attribute13 in varchar2 default hr_api.g_varchar2,
762: p_lei_attribute14 in varchar2 default hr_api.g_varchar2,
763: p_lei_attribute15 in varchar2 default hr_api.g_varchar2,
764: p_lei_attribute16 in varchar2 default hr_api.g_varchar2,
765: p_lei_attribute17 in varchar2 default hr_api.g_varchar2,
766: p_lei_attribute18 in varchar2 default hr_api.g_varchar2,
767: p_lei_attribute19 in varchar2 default hr_api.g_varchar2,
768: p_lei_attribute20 in varchar2 default hr_api.g_varchar2,
769: p_lei_information_category in varchar2 default hr_api.g_varchar2,
762: p_lei_attribute14 in varchar2 default hr_api.g_varchar2,
763: p_lei_attribute15 in varchar2 default hr_api.g_varchar2,
764: p_lei_attribute16 in varchar2 default hr_api.g_varchar2,
765: p_lei_attribute17 in varchar2 default hr_api.g_varchar2,
766: p_lei_attribute18 in varchar2 default hr_api.g_varchar2,
767: p_lei_attribute19 in varchar2 default hr_api.g_varchar2,
768: p_lei_attribute20 in varchar2 default hr_api.g_varchar2,
769: p_lei_information_category in varchar2 default hr_api.g_varchar2,
770: p_lei_information1 in varchar2 default hr_api.g_varchar2,
763: p_lei_attribute15 in varchar2 default hr_api.g_varchar2,
764: p_lei_attribute16 in varchar2 default hr_api.g_varchar2,
765: p_lei_attribute17 in varchar2 default hr_api.g_varchar2,
766: p_lei_attribute18 in varchar2 default hr_api.g_varchar2,
767: p_lei_attribute19 in varchar2 default hr_api.g_varchar2,
768: p_lei_attribute20 in varchar2 default hr_api.g_varchar2,
769: p_lei_information_category in varchar2 default hr_api.g_varchar2,
770: p_lei_information1 in varchar2 default hr_api.g_varchar2,
771: p_lei_information2 in varchar2 default hr_api.g_varchar2,
764: p_lei_attribute16 in varchar2 default hr_api.g_varchar2,
765: p_lei_attribute17 in varchar2 default hr_api.g_varchar2,
766: p_lei_attribute18 in varchar2 default hr_api.g_varchar2,
767: p_lei_attribute19 in varchar2 default hr_api.g_varchar2,
768: p_lei_attribute20 in varchar2 default hr_api.g_varchar2,
769: p_lei_information_category in varchar2 default hr_api.g_varchar2,
770: p_lei_information1 in varchar2 default hr_api.g_varchar2,
771: p_lei_information2 in varchar2 default hr_api.g_varchar2,
772: p_lei_information3 in varchar2 default hr_api.g_varchar2,
765: p_lei_attribute17 in varchar2 default hr_api.g_varchar2,
766: p_lei_attribute18 in varchar2 default hr_api.g_varchar2,
767: p_lei_attribute19 in varchar2 default hr_api.g_varchar2,
768: p_lei_attribute20 in varchar2 default hr_api.g_varchar2,
769: p_lei_information_category in varchar2 default hr_api.g_varchar2,
770: p_lei_information1 in varchar2 default hr_api.g_varchar2,
771: p_lei_information2 in varchar2 default hr_api.g_varchar2,
772: p_lei_information3 in varchar2 default hr_api.g_varchar2,
773: p_lei_information4 in varchar2 default hr_api.g_varchar2,
766: p_lei_attribute18 in varchar2 default hr_api.g_varchar2,
767: p_lei_attribute19 in varchar2 default hr_api.g_varchar2,
768: p_lei_attribute20 in varchar2 default hr_api.g_varchar2,
769: p_lei_information_category in varchar2 default hr_api.g_varchar2,
770: p_lei_information1 in varchar2 default hr_api.g_varchar2,
771: p_lei_information2 in varchar2 default hr_api.g_varchar2,
772: p_lei_information3 in varchar2 default hr_api.g_varchar2,
773: p_lei_information4 in varchar2 default hr_api.g_varchar2,
774: p_lei_information5 in varchar2 default hr_api.g_varchar2,
767: p_lei_attribute19 in varchar2 default hr_api.g_varchar2,
768: p_lei_attribute20 in varchar2 default hr_api.g_varchar2,
769: p_lei_information_category in varchar2 default hr_api.g_varchar2,
770: p_lei_information1 in varchar2 default hr_api.g_varchar2,
771: p_lei_information2 in varchar2 default hr_api.g_varchar2,
772: p_lei_information3 in varchar2 default hr_api.g_varchar2,
773: p_lei_information4 in varchar2 default hr_api.g_varchar2,
774: p_lei_information5 in varchar2 default hr_api.g_varchar2,
775: p_lei_information6 in varchar2 default hr_api.g_varchar2,
768: p_lei_attribute20 in varchar2 default hr_api.g_varchar2,
769: p_lei_information_category in varchar2 default hr_api.g_varchar2,
770: p_lei_information1 in varchar2 default hr_api.g_varchar2,
771: p_lei_information2 in varchar2 default hr_api.g_varchar2,
772: p_lei_information3 in varchar2 default hr_api.g_varchar2,
773: p_lei_information4 in varchar2 default hr_api.g_varchar2,
774: p_lei_information5 in varchar2 default hr_api.g_varchar2,
775: p_lei_information6 in varchar2 default hr_api.g_varchar2,
776: p_lei_information7 in varchar2 default hr_api.g_varchar2,
769: p_lei_information_category in varchar2 default hr_api.g_varchar2,
770: p_lei_information1 in varchar2 default hr_api.g_varchar2,
771: p_lei_information2 in varchar2 default hr_api.g_varchar2,
772: p_lei_information3 in varchar2 default hr_api.g_varchar2,
773: p_lei_information4 in varchar2 default hr_api.g_varchar2,
774: p_lei_information5 in varchar2 default hr_api.g_varchar2,
775: p_lei_information6 in varchar2 default hr_api.g_varchar2,
776: p_lei_information7 in varchar2 default hr_api.g_varchar2,
777: p_lei_information8 in varchar2 default hr_api.g_varchar2,
770: p_lei_information1 in varchar2 default hr_api.g_varchar2,
771: p_lei_information2 in varchar2 default hr_api.g_varchar2,
772: p_lei_information3 in varchar2 default hr_api.g_varchar2,
773: p_lei_information4 in varchar2 default hr_api.g_varchar2,
774: p_lei_information5 in varchar2 default hr_api.g_varchar2,
775: p_lei_information6 in varchar2 default hr_api.g_varchar2,
776: p_lei_information7 in varchar2 default hr_api.g_varchar2,
777: p_lei_information8 in varchar2 default hr_api.g_varchar2,
778: p_lei_information9 in varchar2 default hr_api.g_varchar2,
771: p_lei_information2 in varchar2 default hr_api.g_varchar2,
772: p_lei_information3 in varchar2 default hr_api.g_varchar2,
773: p_lei_information4 in varchar2 default hr_api.g_varchar2,
774: p_lei_information5 in varchar2 default hr_api.g_varchar2,
775: p_lei_information6 in varchar2 default hr_api.g_varchar2,
776: p_lei_information7 in varchar2 default hr_api.g_varchar2,
777: p_lei_information8 in varchar2 default hr_api.g_varchar2,
778: p_lei_information9 in varchar2 default hr_api.g_varchar2,
779: p_lei_information10 in varchar2 default hr_api.g_varchar2,
772: p_lei_information3 in varchar2 default hr_api.g_varchar2,
773: p_lei_information4 in varchar2 default hr_api.g_varchar2,
774: p_lei_information5 in varchar2 default hr_api.g_varchar2,
775: p_lei_information6 in varchar2 default hr_api.g_varchar2,
776: p_lei_information7 in varchar2 default hr_api.g_varchar2,
777: p_lei_information8 in varchar2 default hr_api.g_varchar2,
778: p_lei_information9 in varchar2 default hr_api.g_varchar2,
779: p_lei_information10 in varchar2 default hr_api.g_varchar2,
780: p_lei_information11 in varchar2 default hr_api.g_varchar2,
773: p_lei_information4 in varchar2 default hr_api.g_varchar2,
774: p_lei_information5 in varchar2 default hr_api.g_varchar2,
775: p_lei_information6 in varchar2 default hr_api.g_varchar2,
776: p_lei_information7 in varchar2 default hr_api.g_varchar2,
777: p_lei_information8 in varchar2 default hr_api.g_varchar2,
778: p_lei_information9 in varchar2 default hr_api.g_varchar2,
779: p_lei_information10 in varchar2 default hr_api.g_varchar2,
780: p_lei_information11 in varchar2 default hr_api.g_varchar2,
781: p_lei_information12 in varchar2 default hr_api.g_varchar2,
774: p_lei_information5 in varchar2 default hr_api.g_varchar2,
775: p_lei_information6 in varchar2 default hr_api.g_varchar2,
776: p_lei_information7 in varchar2 default hr_api.g_varchar2,
777: p_lei_information8 in varchar2 default hr_api.g_varchar2,
778: p_lei_information9 in varchar2 default hr_api.g_varchar2,
779: p_lei_information10 in varchar2 default hr_api.g_varchar2,
780: p_lei_information11 in varchar2 default hr_api.g_varchar2,
781: p_lei_information12 in varchar2 default hr_api.g_varchar2,
782: p_lei_information13 in varchar2 default hr_api.g_varchar2,
775: p_lei_information6 in varchar2 default hr_api.g_varchar2,
776: p_lei_information7 in varchar2 default hr_api.g_varchar2,
777: p_lei_information8 in varchar2 default hr_api.g_varchar2,
778: p_lei_information9 in varchar2 default hr_api.g_varchar2,
779: p_lei_information10 in varchar2 default hr_api.g_varchar2,
780: p_lei_information11 in varchar2 default hr_api.g_varchar2,
781: p_lei_information12 in varchar2 default hr_api.g_varchar2,
782: p_lei_information13 in varchar2 default hr_api.g_varchar2,
783: p_lei_information14 in varchar2 default hr_api.g_varchar2,
776: p_lei_information7 in varchar2 default hr_api.g_varchar2,
777: p_lei_information8 in varchar2 default hr_api.g_varchar2,
778: p_lei_information9 in varchar2 default hr_api.g_varchar2,
779: p_lei_information10 in varchar2 default hr_api.g_varchar2,
780: p_lei_information11 in varchar2 default hr_api.g_varchar2,
781: p_lei_information12 in varchar2 default hr_api.g_varchar2,
782: p_lei_information13 in varchar2 default hr_api.g_varchar2,
783: p_lei_information14 in varchar2 default hr_api.g_varchar2,
784: p_lei_information15 in varchar2 default hr_api.g_varchar2,
777: p_lei_information8 in varchar2 default hr_api.g_varchar2,
778: p_lei_information9 in varchar2 default hr_api.g_varchar2,
779: p_lei_information10 in varchar2 default hr_api.g_varchar2,
780: p_lei_information11 in varchar2 default hr_api.g_varchar2,
781: p_lei_information12 in varchar2 default hr_api.g_varchar2,
782: p_lei_information13 in varchar2 default hr_api.g_varchar2,
783: p_lei_information14 in varchar2 default hr_api.g_varchar2,
784: p_lei_information15 in varchar2 default hr_api.g_varchar2,
785: p_lei_information16 in varchar2 default hr_api.g_varchar2,
778: p_lei_information9 in varchar2 default hr_api.g_varchar2,
779: p_lei_information10 in varchar2 default hr_api.g_varchar2,
780: p_lei_information11 in varchar2 default hr_api.g_varchar2,
781: p_lei_information12 in varchar2 default hr_api.g_varchar2,
782: p_lei_information13 in varchar2 default hr_api.g_varchar2,
783: p_lei_information14 in varchar2 default hr_api.g_varchar2,
784: p_lei_information15 in varchar2 default hr_api.g_varchar2,
785: p_lei_information16 in varchar2 default hr_api.g_varchar2,
786: p_lei_information17 in varchar2 default hr_api.g_varchar2,
779: p_lei_information10 in varchar2 default hr_api.g_varchar2,
780: p_lei_information11 in varchar2 default hr_api.g_varchar2,
781: p_lei_information12 in varchar2 default hr_api.g_varchar2,
782: p_lei_information13 in varchar2 default hr_api.g_varchar2,
783: p_lei_information14 in varchar2 default hr_api.g_varchar2,
784: p_lei_information15 in varchar2 default hr_api.g_varchar2,
785: p_lei_information16 in varchar2 default hr_api.g_varchar2,
786: p_lei_information17 in varchar2 default hr_api.g_varchar2,
787: p_lei_information18 in varchar2 default hr_api.g_varchar2,
780: p_lei_information11 in varchar2 default hr_api.g_varchar2,
781: p_lei_information12 in varchar2 default hr_api.g_varchar2,
782: p_lei_information13 in varchar2 default hr_api.g_varchar2,
783: p_lei_information14 in varchar2 default hr_api.g_varchar2,
784: p_lei_information15 in varchar2 default hr_api.g_varchar2,
785: p_lei_information16 in varchar2 default hr_api.g_varchar2,
786: p_lei_information17 in varchar2 default hr_api.g_varchar2,
787: p_lei_information18 in varchar2 default hr_api.g_varchar2,
788: p_lei_information19 in varchar2 default hr_api.g_varchar2,
781: p_lei_information12 in varchar2 default hr_api.g_varchar2,
782: p_lei_information13 in varchar2 default hr_api.g_varchar2,
783: p_lei_information14 in varchar2 default hr_api.g_varchar2,
784: p_lei_information15 in varchar2 default hr_api.g_varchar2,
785: p_lei_information16 in varchar2 default hr_api.g_varchar2,
786: p_lei_information17 in varchar2 default hr_api.g_varchar2,
787: p_lei_information18 in varchar2 default hr_api.g_varchar2,
788: p_lei_information19 in varchar2 default hr_api.g_varchar2,
789: p_lei_information20 in varchar2 default hr_api.g_varchar2,
782: p_lei_information13 in varchar2 default hr_api.g_varchar2,
783: p_lei_information14 in varchar2 default hr_api.g_varchar2,
784: p_lei_information15 in varchar2 default hr_api.g_varchar2,
785: p_lei_information16 in varchar2 default hr_api.g_varchar2,
786: p_lei_information17 in varchar2 default hr_api.g_varchar2,
787: p_lei_information18 in varchar2 default hr_api.g_varchar2,
788: p_lei_information19 in varchar2 default hr_api.g_varchar2,
789: p_lei_information20 in varchar2 default hr_api.g_varchar2,
790: p_lei_information21 in varchar2 default hr_api.g_varchar2,
783: p_lei_information14 in varchar2 default hr_api.g_varchar2,
784: p_lei_information15 in varchar2 default hr_api.g_varchar2,
785: p_lei_information16 in varchar2 default hr_api.g_varchar2,
786: p_lei_information17 in varchar2 default hr_api.g_varchar2,
787: p_lei_information18 in varchar2 default hr_api.g_varchar2,
788: p_lei_information19 in varchar2 default hr_api.g_varchar2,
789: p_lei_information20 in varchar2 default hr_api.g_varchar2,
790: p_lei_information21 in varchar2 default hr_api.g_varchar2,
791: p_lei_information22 in varchar2 default hr_api.g_varchar2,
784: p_lei_information15 in varchar2 default hr_api.g_varchar2,
785: p_lei_information16 in varchar2 default hr_api.g_varchar2,
786: p_lei_information17 in varchar2 default hr_api.g_varchar2,
787: p_lei_information18 in varchar2 default hr_api.g_varchar2,
788: p_lei_information19 in varchar2 default hr_api.g_varchar2,
789: p_lei_information20 in varchar2 default hr_api.g_varchar2,
790: p_lei_information21 in varchar2 default hr_api.g_varchar2,
791: p_lei_information22 in varchar2 default hr_api.g_varchar2,
792: p_lei_information23 in varchar2 default hr_api.g_varchar2,
785: p_lei_information16 in varchar2 default hr_api.g_varchar2,
786: p_lei_information17 in varchar2 default hr_api.g_varchar2,
787: p_lei_information18 in varchar2 default hr_api.g_varchar2,
788: p_lei_information19 in varchar2 default hr_api.g_varchar2,
789: p_lei_information20 in varchar2 default hr_api.g_varchar2,
790: p_lei_information21 in varchar2 default hr_api.g_varchar2,
791: p_lei_information22 in varchar2 default hr_api.g_varchar2,
792: p_lei_information23 in varchar2 default hr_api.g_varchar2,
793: p_lei_information24 in varchar2 default hr_api.g_varchar2,
786: p_lei_information17 in varchar2 default hr_api.g_varchar2,
787: p_lei_information18 in varchar2 default hr_api.g_varchar2,
788: p_lei_information19 in varchar2 default hr_api.g_varchar2,
789: p_lei_information20 in varchar2 default hr_api.g_varchar2,
790: p_lei_information21 in varchar2 default hr_api.g_varchar2,
791: p_lei_information22 in varchar2 default hr_api.g_varchar2,
792: p_lei_information23 in varchar2 default hr_api.g_varchar2,
793: p_lei_information24 in varchar2 default hr_api.g_varchar2,
794: p_lei_information25 in varchar2 default hr_api.g_varchar2,
787: p_lei_information18 in varchar2 default hr_api.g_varchar2,
788: p_lei_information19 in varchar2 default hr_api.g_varchar2,
789: p_lei_information20 in varchar2 default hr_api.g_varchar2,
790: p_lei_information21 in varchar2 default hr_api.g_varchar2,
791: p_lei_information22 in varchar2 default hr_api.g_varchar2,
792: p_lei_information23 in varchar2 default hr_api.g_varchar2,
793: p_lei_information24 in varchar2 default hr_api.g_varchar2,
794: p_lei_information25 in varchar2 default hr_api.g_varchar2,
795: p_lei_information26 in varchar2 default hr_api.g_varchar2,
788: p_lei_information19 in varchar2 default hr_api.g_varchar2,
789: p_lei_information20 in varchar2 default hr_api.g_varchar2,
790: p_lei_information21 in varchar2 default hr_api.g_varchar2,
791: p_lei_information22 in varchar2 default hr_api.g_varchar2,
792: p_lei_information23 in varchar2 default hr_api.g_varchar2,
793: p_lei_information24 in varchar2 default hr_api.g_varchar2,
794: p_lei_information25 in varchar2 default hr_api.g_varchar2,
795: p_lei_information26 in varchar2 default hr_api.g_varchar2,
796: p_lei_information27 in varchar2 default hr_api.g_varchar2,
789: p_lei_information20 in varchar2 default hr_api.g_varchar2,
790: p_lei_information21 in varchar2 default hr_api.g_varchar2,
791: p_lei_information22 in varchar2 default hr_api.g_varchar2,
792: p_lei_information23 in varchar2 default hr_api.g_varchar2,
793: p_lei_information24 in varchar2 default hr_api.g_varchar2,
794: p_lei_information25 in varchar2 default hr_api.g_varchar2,
795: p_lei_information26 in varchar2 default hr_api.g_varchar2,
796: p_lei_information27 in varchar2 default hr_api.g_varchar2,
797: p_lei_information28 in varchar2 default hr_api.g_varchar2,
790: p_lei_information21 in varchar2 default hr_api.g_varchar2,
791: p_lei_information22 in varchar2 default hr_api.g_varchar2,
792: p_lei_information23 in varchar2 default hr_api.g_varchar2,
793: p_lei_information24 in varchar2 default hr_api.g_varchar2,
794: p_lei_information25 in varchar2 default hr_api.g_varchar2,
795: p_lei_information26 in varchar2 default hr_api.g_varchar2,
796: p_lei_information27 in varchar2 default hr_api.g_varchar2,
797: p_lei_information28 in varchar2 default hr_api.g_varchar2,
798: p_lei_information29 in varchar2 default hr_api.g_varchar2,
791: p_lei_information22 in varchar2 default hr_api.g_varchar2,
792: p_lei_information23 in varchar2 default hr_api.g_varchar2,
793: p_lei_information24 in varchar2 default hr_api.g_varchar2,
794: p_lei_information25 in varchar2 default hr_api.g_varchar2,
795: p_lei_information26 in varchar2 default hr_api.g_varchar2,
796: p_lei_information27 in varchar2 default hr_api.g_varchar2,
797: p_lei_information28 in varchar2 default hr_api.g_varchar2,
798: p_lei_information29 in varchar2 default hr_api.g_varchar2,
799: p_lei_information30 in varchar2 default hr_api.g_varchar2,
792: p_lei_information23 in varchar2 default hr_api.g_varchar2,
793: p_lei_information24 in varchar2 default hr_api.g_varchar2,
794: p_lei_information25 in varchar2 default hr_api.g_varchar2,
795: p_lei_information26 in varchar2 default hr_api.g_varchar2,
796: p_lei_information27 in varchar2 default hr_api.g_varchar2,
797: p_lei_information28 in varchar2 default hr_api.g_varchar2,
798: p_lei_information29 in varchar2 default hr_api.g_varchar2,
799: p_lei_information30 in varchar2 default hr_api.g_varchar2,
800: p_object_version_number in out nocopy number,
793: p_lei_information24 in varchar2 default hr_api.g_varchar2,
794: p_lei_information25 in varchar2 default hr_api.g_varchar2,
795: p_lei_information26 in varchar2 default hr_api.g_varchar2,
796: p_lei_information27 in varchar2 default hr_api.g_varchar2,
797: p_lei_information28 in varchar2 default hr_api.g_varchar2,
798: p_lei_information29 in varchar2 default hr_api.g_varchar2,
799: p_lei_information30 in varchar2 default hr_api.g_varchar2,
800: p_object_version_number in out nocopy number,
801: p_validate in boolean default false
794: p_lei_information25 in varchar2 default hr_api.g_varchar2,
795: p_lei_information26 in varchar2 default hr_api.g_varchar2,
796: p_lei_information27 in varchar2 default hr_api.g_varchar2,
797: p_lei_information28 in varchar2 default hr_api.g_varchar2,
798: p_lei_information29 in varchar2 default hr_api.g_varchar2,
799: p_lei_information30 in varchar2 default hr_api.g_varchar2,
800: p_object_version_number in out nocopy number,
801: p_validate in boolean default false
802: ) is
795: p_lei_information26 in varchar2 default hr_api.g_varchar2,
796: p_lei_information27 in varchar2 default hr_api.g_varchar2,
797: p_lei_information28 in varchar2 default hr_api.g_varchar2,
798: p_lei_information29 in varchar2 default hr_api.g_varchar2,
799: p_lei_information30 in varchar2 default hr_api.g_varchar2,
800: p_object_version_number in out nocopy number,
801: p_validate in boolean default false
802: ) is
803: --