126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: per_pac_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: per_pac_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: per_pac_shd.constraint_error
131: -- A check constraint has been violated
132: --
133: per_pac_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: per_pac_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: per_pac_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: per_pac_shd.constraint_error
136: -- Parent integrity has been violated
137: --
138: per_pac_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: per_pac_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: per_pac_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: --
147: Raise;
148: End update_dml;
437: );
438: --
439: exception
440: --
441: when hr_api.cannot_find_prog_unit then
442: --
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'PER_ALLOCATED_CHECKLISTS'
445: ,p_hook_type => 'AU');
439: exception
440: --
441: when hr_api.cannot_find_prog_unit then
442: --
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'PER_ALLOCATED_CHECKLISTS'
445: ,p_hook_type => 'AU');
446: --
447: end;
502: -- p_rec plsql record structure
503: -- to see if a system default is being used. If a system default
504: -- is being used then we must set to the 'current' argument value.
505: --
506: If (p_rec.checklist_id = hr_api.g_number) then
507: p_rec.checklist_id :=
508: per_pac_shd.g_old_rec.checklist_id;
509: End If;
510: If (p_rec.person_id = hr_api.g_number) then
506: If (p_rec.checklist_id = hr_api.g_number) then
507: p_rec.checklist_id :=
508: per_pac_shd.g_old_rec.checklist_id;
509: End If;
510: If (p_rec.person_id = hr_api.g_number) then
511: p_rec.person_id :=
512: per_pac_shd.g_old_rec.person_id;
513: End If;
514: If (p_rec.assignment_id = hr_api.g_number) then
510: If (p_rec.person_id = hr_api.g_number) then
511: p_rec.person_id :=
512: per_pac_shd.g_old_rec.person_id;
513: End If;
514: If (p_rec.assignment_id = hr_api.g_number) then
515: p_rec.assignment_id :=
516: per_pac_shd.g_old_rec.assignment_id;
517: End If;
518: If (p_rec.checklist_name = hr_api.g_varchar2) then
514: If (p_rec.assignment_id = hr_api.g_number) then
515: p_rec.assignment_id :=
516: per_pac_shd.g_old_rec.assignment_id;
517: End If;
518: If (p_rec.checklist_name = hr_api.g_varchar2) then
519: p_rec.checklist_name :=
520: per_pac_shd.g_old_rec.checklist_name;
521: End If;
522: If (p_rec.description = hr_api.g_varchar2) then
518: If (p_rec.checklist_name = hr_api.g_varchar2) then
519: p_rec.checklist_name :=
520: per_pac_shd.g_old_rec.checklist_name;
521: End If;
522: If (p_rec.description = hr_api.g_varchar2) then
523: p_rec.description :=
524: per_pac_shd.g_old_rec.description;
525: End If;
526: If (p_rec.checklist_category = hr_api.g_varchar2) then
522: If (p_rec.description = hr_api.g_varchar2) then
523: p_rec.description :=
524: per_pac_shd.g_old_rec.description;
525: End If;
526: If (p_rec.checklist_category = hr_api.g_varchar2) then
527: p_rec.checklist_category :=
528: per_pac_shd.g_old_rec.checklist_category;
529: End If;
530: If (p_rec.attribute_category = hr_api.g_varchar2) then
526: If (p_rec.checklist_category = hr_api.g_varchar2) then
527: p_rec.checklist_category :=
528: per_pac_shd.g_old_rec.checklist_category;
529: End If;
530: If (p_rec.attribute_category = hr_api.g_varchar2) then
531: p_rec.attribute_category :=
532: per_pac_shd.g_old_rec.attribute_category;
533: End If;
534: If (p_rec.attribute1 = hr_api.g_varchar2) then
530: If (p_rec.attribute_category = hr_api.g_varchar2) then
531: p_rec.attribute_category :=
532: per_pac_shd.g_old_rec.attribute_category;
533: End If;
534: If (p_rec.attribute1 = hr_api.g_varchar2) then
535: p_rec.attribute1 :=
536: per_pac_shd.g_old_rec.attribute1;
537: End If;
538: If (p_rec.attribute2 = hr_api.g_varchar2) then
534: If (p_rec.attribute1 = hr_api.g_varchar2) then
535: p_rec.attribute1 :=
536: per_pac_shd.g_old_rec.attribute1;
537: End If;
538: If (p_rec.attribute2 = hr_api.g_varchar2) then
539: p_rec.attribute2 :=
540: per_pac_shd.g_old_rec.attribute2;
541: End If;
542: If (p_rec.attribute3 = hr_api.g_varchar2) then
538: If (p_rec.attribute2 = hr_api.g_varchar2) then
539: p_rec.attribute2 :=
540: per_pac_shd.g_old_rec.attribute2;
541: End If;
542: If (p_rec.attribute3 = hr_api.g_varchar2) then
543: p_rec.attribute3 :=
544: per_pac_shd.g_old_rec.attribute3;
545: End If;
546: If (p_rec.attribute4 = hr_api.g_varchar2) then
542: If (p_rec.attribute3 = hr_api.g_varchar2) then
543: p_rec.attribute3 :=
544: per_pac_shd.g_old_rec.attribute3;
545: End If;
546: If (p_rec.attribute4 = hr_api.g_varchar2) then
547: p_rec.attribute4 :=
548: per_pac_shd.g_old_rec.attribute4;
549: End If;
550: If (p_rec.attribute5 = hr_api.g_varchar2) then
546: If (p_rec.attribute4 = hr_api.g_varchar2) then
547: p_rec.attribute4 :=
548: per_pac_shd.g_old_rec.attribute4;
549: End If;
550: If (p_rec.attribute5 = hr_api.g_varchar2) then
551: p_rec.attribute5 :=
552: per_pac_shd.g_old_rec.attribute5;
553: End If;
554: If (p_rec.attribute6 = hr_api.g_varchar2) then
550: If (p_rec.attribute5 = hr_api.g_varchar2) then
551: p_rec.attribute5 :=
552: per_pac_shd.g_old_rec.attribute5;
553: End If;
554: If (p_rec.attribute6 = hr_api.g_varchar2) then
555: p_rec.attribute6 :=
556: per_pac_shd.g_old_rec.attribute6;
557: End If;
558: If (p_rec.attribute7 = hr_api.g_varchar2) then
554: If (p_rec.attribute6 = hr_api.g_varchar2) then
555: p_rec.attribute6 :=
556: per_pac_shd.g_old_rec.attribute6;
557: End If;
558: If (p_rec.attribute7 = hr_api.g_varchar2) then
559: p_rec.attribute7 :=
560: per_pac_shd.g_old_rec.attribute7;
561: End If;
562: If (p_rec.attribute8 = hr_api.g_varchar2) then
558: If (p_rec.attribute7 = hr_api.g_varchar2) then
559: p_rec.attribute7 :=
560: per_pac_shd.g_old_rec.attribute7;
561: End If;
562: If (p_rec.attribute8 = hr_api.g_varchar2) then
563: p_rec.attribute8 :=
564: per_pac_shd.g_old_rec.attribute8;
565: End If;
566: If (p_rec.attribute9 = hr_api.g_varchar2) then
562: If (p_rec.attribute8 = hr_api.g_varchar2) then
563: p_rec.attribute8 :=
564: per_pac_shd.g_old_rec.attribute8;
565: End If;
566: If (p_rec.attribute9 = hr_api.g_varchar2) then
567: p_rec.attribute9 :=
568: per_pac_shd.g_old_rec.attribute9;
569: End If;
570: If (p_rec.attribute10 = hr_api.g_varchar2) then
566: If (p_rec.attribute9 = hr_api.g_varchar2) then
567: p_rec.attribute9 :=
568: per_pac_shd.g_old_rec.attribute9;
569: End If;
570: If (p_rec.attribute10 = hr_api.g_varchar2) then
571: p_rec.attribute10 :=
572: per_pac_shd.g_old_rec.attribute10;
573: End If;
574: If (p_rec.attribute11 = hr_api.g_varchar2) then
570: If (p_rec.attribute10 = hr_api.g_varchar2) then
571: p_rec.attribute10 :=
572: per_pac_shd.g_old_rec.attribute10;
573: End If;
574: If (p_rec.attribute11 = hr_api.g_varchar2) then
575: p_rec.attribute11 :=
576: per_pac_shd.g_old_rec.attribute11;
577: End If;
578: If (p_rec.attribute12 = hr_api.g_varchar2) then
574: If (p_rec.attribute11 = hr_api.g_varchar2) then
575: p_rec.attribute11 :=
576: per_pac_shd.g_old_rec.attribute11;
577: End If;
578: If (p_rec.attribute12 = hr_api.g_varchar2) then
579: p_rec.attribute12 :=
580: per_pac_shd.g_old_rec.attribute12;
581: End If;
582: If (p_rec.attribute13 = hr_api.g_varchar2) then
578: If (p_rec.attribute12 = hr_api.g_varchar2) then
579: p_rec.attribute12 :=
580: per_pac_shd.g_old_rec.attribute12;
581: End If;
582: If (p_rec.attribute13 = hr_api.g_varchar2) then
583: p_rec.attribute13 :=
584: per_pac_shd.g_old_rec.attribute13;
585: End If;
586: If (p_rec.attribute14 = hr_api.g_varchar2) then
582: If (p_rec.attribute13 = hr_api.g_varchar2) then
583: p_rec.attribute13 :=
584: per_pac_shd.g_old_rec.attribute13;
585: End If;
586: If (p_rec.attribute14 = hr_api.g_varchar2) then
587: p_rec.attribute14 :=
588: per_pac_shd.g_old_rec.attribute14;
589: End If;
590: If (p_rec.attribute15 = hr_api.g_varchar2) then
586: If (p_rec.attribute14 = hr_api.g_varchar2) then
587: p_rec.attribute14 :=
588: per_pac_shd.g_old_rec.attribute14;
589: End If;
590: If (p_rec.attribute15 = hr_api.g_varchar2) then
591: p_rec.attribute15 :=
592: per_pac_shd.g_old_rec.attribute15;
593: End If;
594: If (p_rec.attribute16 = hr_api.g_varchar2) then
590: If (p_rec.attribute15 = hr_api.g_varchar2) then
591: p_rec.attribute15 :=
592: per_pac_shd.g_old_rec.attribute15;
593: End If;
594: If (p_rec.attribute16 = hr_api.g_varchar2) then
595: p_rec.attribute16 :=
596: per_pac_shd.g_old_rec.attribute16;
597: End If;
598: If (p_rec.attribute17 = hr_api.g_varchar2) then
594: If (p_rec.attribute16 = hr_api.g_varchar2) then
595: p_rec.attribute16 :=
596: per_pac_shd.g_old_rec.attribute16;
597: End If;
598: If (p_rec.attribute17 = hr_api.g_varchar2) then
599: p_rec.attribute17 :=
600: per_pac_shd.g_old_rec.attribute17;
601: End If;
602: If (p_rec.attribute18 = hr_api.g_varchar2) then
598: If (p_rec.attribute17 = hr_api.g_varchar2) then
599: p_rec.attribute17 :=
600: per_pac_shd.g_old_rec.attribute17;
601: End If;
602: If (p_rec.attribute18 = hr_api.g_varchar2) then
603: p_rec.attribute18 :=
604: per_pac_shd.g_old_rec.attribute18;
605: End If;
606: If (p_rec.attribute19 = hr_api.g_varchar2) then
602: If (p_rec.attribute18 = hr_api.g_varchar2) then
603: p_rec.attribute18 :=
604: per_pac_shd.g_old_rec.attribute18;
605: End If;
606: If (p_rec.attribute19 = hr_api.g_varchar2) then
607: p_rec.attribute19 :=
608: per_pac_shd.g_old_rec.attribute19;
609: End If;
610: If (p_rec.attribute20 = hr_api.g_varchar2) then
606: If (p_rec.attribute19 = hr_api.g_varchar2) then
607: p_rec.attribute19 :=
608: per_pac_shd.g_old_rec.attribute19;
609: End If;
610: If (p_rec.attribute20 = hr_api.g_varchar2) then
611: p_rec.attribute20 :=
612: per_pac_shd.g_old_rec.attribute20;
613: End If;
614: If (p_rec.information_category = hr_api.g_varchar2) then
610: If (p_rec.attribute20 = hr_api.g_varchar2) then
611: p_rec.attribute20 :=
612: per_pac_shd.g_old_rec.attribute20;
613: End If;
614: If (p_rec.information_category = hr_api.g_varchar2) then
615: p_rec.information_category :=
616: per_pac_shd.g_old_rec.information_category;
617: End If;
618: If (p_rec.information1 = hr_api.g_varchar2) then
614: If (p_rec.information_category = hr_api.g_varchar2) then
615: p_rec.information_category :=
616: per_pac_shd.g_old_rec.information_category;
617: End If;
618: If (p_rec.information1 = hr_api.g_varchar2) then
619: p_rec.information1 :=
620: per_pac_shd.g_old_rec.information1;
621: End If;
622: If (p_rec.information2 = hr_api.g_varchar2) then
618: If (p_rec.information1 = hr_api.g_varchar2) then
619: p_rec.information1 :=
620: per_pac_shd.g_old_rec.information1;
621: End If;
622: If (p_rec.information2 = hr_api.g_varchar2) then
623: p_rec.information2 :=
624: per_pac_shd.g_old_rec.information2;
625: End If;
626: If (p_rec.information3 = hr_api.g_varchar2) then
622: If (p_rec.information2 = hr_api.g_varchar2) then
623: p_rec.information2 :=
624: per_pac_shd.g_old_rec.information2;
625: End If;
626: If (p_rec.information3 = hr_api.g_varchar2) then
627: p_rec.information3 :=
628: per_pac_shd.g_old_rec.information3;
629: End If;
630: If (p_rec.information4 = hr_api.g_varchar2) then
626: If (p_rec.information3 = hr_api.g_varchar2) then
627: p_rec.information3 :=
628: per_pac_shd.g_old_rec.information3;
629: End If;
630: If (p_rec.information4 = hr_api.g_varchar2) then
631: p_rec.information4 :=
632: per_pac_shd.g_old_rec.information4;
633: End If;
634: If (p_rec.information5 = hr_api.g_varchar2) then
630: If (p_rec.information4 = hr_api.g_varchar2) then
631: p_rec.information4 :=
632: per_pac_shd.g_old_rec.information4;
633: End If;
634: If (p_rec.information5 = hr_api.g_varchar2) then
635: p_rec.information5 :=
636: per_pac_shd.g_old_rec.information5;
637: End If;
638: If (p_rec.information6 = hr_api.g_varchar2) then
634: If (p_rec.information5 = hr_api.g_varchar2) then
635: p_rec.information5 :=
636: per_pac_shd.g_old_rec.information5;
637: End If;
638: If (p_rec.information6 = hr_api.g_varchar2) then
639: p_rec.information6 :=
640: per_pac_shd.g_old_rec.information6;
641: End If;
642: If (p_rec.information7 = hr_api.g_varchar2) then
638: If (p_rec.information6 = hr_api.g_varchar2) then
639: p_rec.information6 :=
640: per_pac_shd.g_old_rec.information6;
641: End If;
642: If (p_rec.information7 = hr_api.g_varchar2) then
643: p_rec.information7 :=
644: per_pac_shd.g_old_rec.information7;
645: End If;
646: If (p_rec.information8 = hr_api.g_varchar2) then
642: If (p_rec.information7 = hr_api.g_varchar2) then
643: p_rec.information7 :=
644: per_pac_shd.g_old_rec.information7;
645: End If;
646: If (p_rec.information8 = hr_api.g_varchar2) then
647: p_rec.information8 :=
648: per_pac_shd.g_old_rec.information8;
649: End If;
650: If (p_rec.information9 = hr_api.g_varchar2) then
646: If (p_rec.information8 = hr_api.g_varchar2) then
647: p_rec.information8 :=
648: per_pac_shd.g_old_rec.information8;
649: End If;
650: If (p_rec.information9 = hr_api.g_varchar2) then
651: p_rec.information9 :=
652: per_pac_shd.g_old_rec.information9;
653: End If;
654: If (p_rec.information10 = hr_api.g_varchar2) then
650: If (p_rec.information9 = hr_api.g_varchar2) then
651: p_rec.information9 :=
652: per_pac_shd.g_old_rec.information9;
653: End If;
654: If (p_rec.information10 = hr_api.g_varchar2) then
655: p_rec.information10 :=
656: per_pac_shd.g_old_rec.information10;
657: End If;
658: If (p_rec.information11 = hr_api.g_varchar2) then
654: If (p_rec.information10 = hr_api.g_varchar2) then
655: p_rec.information10 :=
656: per_pac_shd.g_old_rec.information10;
657: End If;
658: If (p_rec.information11 = hr_api.g_varchar2) then
659: p_rec.information11 :=
660: per_pac_shd.g_old_rec.information11;
661: End If;
662: If (p_rec.information12 = hr_api.g_varchar2) then
658: If (p_rec.information11 = hr_api.g_varchar2) then
659: p_rec.information11 :=
660: per_pac_shd.g_old_rec.information11;
661: End If;
662: If (p_rec.information12 = hr_api.g_varchar2) then
663: p_rec.information12 :=
664: per_pac_shd.g_old_rec.information12;
665: End If;
666: If (p_rec.information13 = hr_api.g_varchar2) then
662: If (p_rec.information12 = hr_api.g_varchar2) then
663: p_rec.information12 :=
664: per_pac_shd.g_old_rec.information12;
665: End If;
666: If (p_rec.information13 = hr_api.g_varchar2) then
667: p_rec.information13 :=
668: per_pac_shd.g_old_rec.information13;
669: End If;
670: If (p_rec.information14 = hr_api.g_varchar2) then
666: If (p_rec.information13 = hr_api.g_varchar2) then
667: p_rec.information13 :=
668: per_pac_shd.g_old_rec.information13;
669: End If;
670: If (p_rec.information14 = hr_api.g_varchar2) then
671: p_rec.information14 :=
672: per_pac_shd.g_old_rec.information14;
673: End If;
674: If (p_rec.information15 = hr_api.g_varchar2) then
670: If (p_rec.information14 = hr_api.g_varchar2) then
671: p_rec.information14 :=
672: per_pac_shd.g_old_rec.information14;
673: End If;
674: If (p_rec.information15 = hr_api.g_varchar2) then
675: p_rec.information15 :=
676: per_pac_shd.g_old_rec.information15;
677: End If;
678: If (p_rec.information16 = hr_api.g_varchar2) then
674: If (p_rec.information15 = hr_api.g_varchar2) then
675: p_rec.information15 :=
676: per_pac_shd.g_old_rec.information15;
677: End If;
678: If (p_rec.information16 = hr_api.g_varchar2) then
679: p_rec.information16 :=
680: per_pac_shd.g_old_rec.information16;
681: End If;
682: If (p_rec.information17 = hr_api.g_varchar2) then
678: If (p_rec.information16 = hr_api.g_varchar2) then
679: p_rec.information16 :=
680: per_pac_shd.g_old_rec.information16;
681: End If;
682: If (p_rec.information17 = hr_api.g_varchar2) then
683: p_rec.information17 :=
684: per_pac_shd.g_old_rec.information17;
685: End If;
686: If (p_rec.information18 = hr_api.g_varchar2) then
682: If (p_rec.information17 = hr_api.g_varchar2) then
683: p_rec.information17 :=
684: per_pac_shd.g_old_rec.information17;
685: End If;
686: If (p_rec.information18 = hr_api.g_varchar2) then
687: p_rec.information18 :=
688: per_pac_shd.g_old_rec.information18;
689: End If;
690: If (p_rec.information19 = hr_api.g_varchar2) then
686: If (p_rec.information18 = hr_api.g_varchar2) then
687: p_rec.information18 :=
688: per_pac_shd.g_old_rec.information18;
689: End If;
690: If (p_rec.information19 = hr_api.g_varchar2) then
691: p_rec.information19 :=
692: per_pac_shd.g_old_rec.information19;
693: End If;
694: If (p_rec.information20 = hr_api.g_varchar2) then
690: If (p_rec.information19 = hr_api.g_varchar2) then
691: p_rec.information19 :=
692: per_pac_shd.g_old_rec.information19;
693: End If;
694: If (p_rec.information20 = hr_api.g_varchar2) then
695: p_rec.information20 :=
696: per_pac_shd.g_old_rec.information20;
697: End If;
698: --
758: Procedure upd
759: (p_effective_date in date
760: ,p_allocated_checklist_id in number
761: ,p_object_version_number in out nocopy number
762: ,p_checklist_id in number default hr_api.g_number
763: ,p_person_id in number default hr_api.g_number
764: ,p_assignment_id in number default hr_api.g_number
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
759: (p_effective_date in date
760: ,p_allocated_checklist_id in number
761: ,p_object_version_number in out nocopy number
762: ,p_checklist_id in number default hr_api.g_number
763: ,p_person_id in number default hr_api.g_number
764: ,p_assignment_id in number default hr_api.g_number
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
760: ,p_allocated_checklist_id in number
761: ,p_object_version_number in out nocopy number
762: ,p_checklist_id in number default hr_api.g_number
763: ,p_person_id in number default hr_api.g_number
764: ,p_assignment_id in number default hr_api.g_number
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
761: ,p_object_version_number in out nocopy number
762: ,p_checklist_id in number default hr_api.g_number
763: ,p_person_id in number default hr_api.g_number
764: ,p_assignment_id in number default hr_api.g_number
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
762: ,p_checklist_id in number default hr_api.g_number
763: ,p_person_id in number default hr_api.g_number
764: ,p_assignment_id in number default hr_api.g_number
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
763: ,p_person_id in number default hr_api.g_number
764: ,p_assignment_id in number default hr_api.g_number
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
764: ,p_assignment_id in number default hr_api.g_number
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
765: ,p_checklist_name in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
766: ,p_description in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
767: ,p_checklist_category in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
789: ,p_information_category in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
790: ,p_information1 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
791: ,p_information2 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
792: ,p_information3 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
793: ,p_information4 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
794: ,p_information5 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
795: ,p_information6 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
796: ,p_information7 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
797: ,p_information8 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
798: ,p_information9 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
799: ,p_information10 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
807: ,p_information18 in varchar2 default hr_api.g_varchar2
800: ,p_information11 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
807: ,p_information18 in varchar2 default hr_api.g_varchar2
808: ,p_information19 in varchar2 default hr_api.g_varchar2
801: ,p_information12 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
807: ,p_information18 in varchar2 default hr_api.g_varchar2
808: ,p_information19 in varchar2 default hr_api.g_varchar2
809: ,p_information20 in varchar2 default hr_api.g_varchar2
802: ,p_information13 in varchar2 default hr_api.g_varchar2
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
807: ,p_information18 in varchar2 default hr_api.g_varchar2
808: ,p_information19 in varchar2 default hr_api.g_varchar2
809: ,p_information20 in varchar2 default hr_api.g_varchar2
810: ) is
803: ,p_information14 in varchar2 default hr_api.g_varchar2
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
807: ,p_information18 in varchar2 default hr_api.g_varchar2
808: ,p_information19 in varchar2 default hr_api.g_varchar2
809: ,p_information20 in varchar2 default hr_api.g_varchar2
810: ) is
811: --
804: ,p_information15 in varchar2 default hr_api.g_varchar2
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
807: ,p_information18 in varchar2 default hr_api.g_varchar2
808: ,p_information19 in varchar2 default hr_api.g_varchar2
809: ,p_information20 in varchar2 default hr_api.g_varchar2
810: ) is
811: --
812: l_rec per_pac_shd.g_rec_type;
805: ,p_information16 in varchar2 default hr_api.g_varchar2
806: ,p_information17 in varchar2 default hr_api.g_varchar2
807: ,p_information18 in varchar2 default hr_api.g_varchar2
808: ,p_information19 in varchar2 default hr_api.g_varchar2
809: ,p_information20 in varchar2 default hr_api.g_varchar2
810: ) is
811: --
812: l_rec per_pac_shd.g_rec_type;
813: l_proc varchar2(72) := g_package||'upd';