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