APPS.PER_CPO_UPD dependencies on HR_API

Line 129: When hr_api.check_integrity_violated Then

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

Line 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

Line 134: When hr_api.parent_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
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

134: When hr_api.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

Line 139: When hr_api.unique_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
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 440: when hr_api.cannot_find_prog_unit then

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');

Line 442: hr_api.cannot_find_prog_unit_error

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;

Line 505: If (p_rec.competence_id = hr_api.g_number) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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: --

Line 761: ,p_competence_id in number default hr_api.g_number

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

Line 762: ,p_outcome_number in number default hr_api.g_number

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

Line 763: ,p_name 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

Line 764: ,p_date_from in date default hr_api.g_date

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

Line 765: ,p_date_to in date default hr_api.g_date

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

Line 766: ,p_assessment_criteria 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

Line 767: ,p_attribute_category 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

Line 768: ,p_attribute1 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

Line 769: ,p_attribute2 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

Line 770: ,p_attribute3 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

Line 771: ,p_attribute4 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

Line 772: ,p_attribute5 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

Line 773: ,p_attribute6 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

Line 774: ,p_attribute7 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

Line 775: ,p_attribute8 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

Line 776: ,p_attribute9 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

Line 777: ,p_attribute10 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

Line 778: ,p_attribute11 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

Line 779: ,p_attribute12 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

Line 780: ,p_attribute13 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

Line 781: ,p_attribute14 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

Line 782: ,p_attribute15 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

Line 783: ,p_attribute16 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

Line 784: ,p_attribute17 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

Line 785: ,p_attribute18 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

Line 786: ,p_attribute19 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

Line 787: ,p_attribute20 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

Line 788: ,p_information_category 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

Line 789: ,p_information1 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

Line 790: ,p_information2 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

Line 791: ,p_information3 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

Line 792: ,p_information4 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

Line 793: ,p_information5 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

Line 794: ,p_information6 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

Line 795: ,p_information7 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

Line 796: ,p_information8 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

Line 797: ,p_information9 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

Line 798: ,p_information10 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

Line 799: ,p_information11 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

Line 800: ,p_information12 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

Line 801: ,p_information13 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

Line 802: ,p_information14 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

Line 803: ,p_information15 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

Line 804: ,p_information16 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

Line 805: ,p_information17 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

Line 806: ,p_information18 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
810: --

Line 807: ,p_information19 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: --
811: l_rec per_cpo_shd.g_rec_type;

Line 808: ,p_information20 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;
812: l_proc varchar2(72) := g_package||'upd';