APPS.PER_CEO_UPD dependencies on HR_API

Line 127: When hr_api.check_integrity_violated Then

123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 10);
125: --
126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
130: per_ceo_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
130: per_ceo_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
135: per_ceo_shd.constraint_error

Line 132: When hr_api.parent_integrity_violated Then

128: -- A check constraint has been violated
129: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
130: per_ceo_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
135: per_ceo_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

132: When hr_api.parent_integrity_violated Then
133: -- Parent integrity has been violated
134: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
135: per_ceo_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
140: per_ceo_shd.constraint_error

Line 137: When hr_api.unique_integrity_violated Then

133: -- Parent integrity has been violated
134: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
135: per_ceo_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
140: per_ceo_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

137: When hr_api.unique_integrity_violated Then
138: -- Unique integrity has been violated
139: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
140: per_ceo_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When Others Then
143: per_ceo_shd.g_api_dml := false; -- Unset the api dml status
144: Raise;
145: End update_dml;

Line 430: when hr_api.cannot_find_prog_unit then

426: );
427: --
428: exception
429: --
430: when hr_api.cannot_find_prog_unit then
431: --
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'PER_COMP_ELEMENT_OUTCOMES'
434: ,p_hook_type => 'AU');

Line 432: hr_api.cannot_find_prog_unit_error

428: exception
429: --
430: when hr_api.cannot_find_prog_unit then
431: --
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'PER_COMP_ELEMENT_OUTCOMES'
434: ,p_hook_type => 'AU');
435: --
436: end;

Line 495: If (p_rec.competence_element_id = hr_api.g_number) then

491: -- p_rec plsql record structure
492: -- to see if a system default is being used. If a system default
493: -- is being used then we must set to the 'current' argument value.
494: --
495: If (p_rec.competence_element_id = hr_api.g_number) then
496: p_rec.competence_element_id :=
497: per_ceo_shd.g_old_rec.competence_element_id;
498: End If;
499: If (p_rec.outcome_id = hr_api.g_number) then

Line 499: If (p_rec.outcome_id = hr_api.g_number) then

495: If (p_rec.competence_element_id = hr_api.g_number) then
496: p_rec.competence_element_id :=
497: per_ceo_shd.g_old_rec.competence_element_id;
498: End If;
499: If (p_rec.outcome_id = hr_api.g_number) then
500: p_rec.outcome_id :=
501: per_ceo_shd.g_old_rec.outcome_id;
502: End If;
503: If (p_rec.date_from = hr_api.g_date) then

Line 503: If (p_rec.date_from = hr_api.g_date) then

499: If (p_rec.outcome_id = hr_api.g_number) then
500: p_rec.outcome_id :=
501: per_ceo_shd.g_old_rec.outcome_id;
502: End If;
503: If (p_rec.date_from = hr_api.g_date) then
504: p_rec.date_from :=
505: per_ceo_shd.g_old_rec.date_from;
506: End If;
507: If (p_rec.date_to = hr_api.g_date) then

Line 507: If (p_rec.date_to = hr_api.g_date) then

503: If (p_rec.date_from = hr_api.g_date) then
504: p_rec.date_from :=
505: per_ceo_shd.g_old_rec.date_from;
506: End If;
507: If (p_rec.date_to = hr_api.g_date) then
508: p_rec.date_to :=
509: per_ceo_shd.g_old_rec.date_to;
510: End If;
511: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 511: If (p_rec.attribute_category = hr_api.g_varchar2) then

507: If (p_rec.date_to = hr_api.g_date) then
508: p_rec.date_to :=
509: per_ceo_shd.g_old_rec.date_to;
510: End If;
511: If (p_rec.attribute_category = hr_api.g_varchar2) then
512: p_rec.attribute_category :=
513: per_ceo_shd.g_old_rec.attribute_category;
514: End If;
515: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 515: If (p_rec.attribute1 = hr_api.g_varchar2) then

511: If (p_rec.attribute_category = hr_api.g_varchar2) then
512: p_rec.attribute_category :=
513: per_ceo_shd.g_old_rec.attribute_category;
514: End If;
515: If (p_rec.attribute1 = hr_api.g_varchar2) then
516: p_rec.attribute1 :=
517: per_ceo_shd.g_old_rec.attribute1;
518: End If;
519: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 519: If (p_rec.attribute2 = hr_api.g_varchar2) then

515: If (p_rec.attribute1 = hr_api.g_varchar2) then
516: p_rec.attribute1 :=
517: per_ceo_shd.g_old_rec.attribute1;
518: End If;
519: If (p_rec.attribute2 = hr_api.g_varchar2) then
520: p_rec.attribute2 :=
521: per_ceo_shd.g_old_rec.attribute2;
522: End If;
523: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 523: If (p_rec.attribute3 = hr_api.g_varchar2) then

519: If (p_rec.attribute2 = hr_api.g_varchar2) then
520: p_rec.attribute2 :=
521: per_ceo_shd.g_old_rec.attribute2;
522: End If;
523: If (p_rec.attribute3 = hr_api.g_varchar2) then
524: p_rec.attribute3 :=
525: per_ceo_shd.g_old_rec.attribute3;
526: End If;
527: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 527: If (p_rec.attribute4 = hr_api.g_varchar2) then

523: If (p_rec.attribute3 = hr_api.g_varchar2) then
524: p_rec.attribute3 :=
525: per_ceo_shd.g_old_rec.attribute3;
526: End If;
527: If (p_rec.attribute4 = hr_api.g_varchar2) then
528: p_rec.attribute4 :=
529: per_ceo_shd.g_old_rec.attribute4;
530: End If;
531: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 531: If (p_rec.attribute5 = hr_api.g_varchar2) then

527: If (p_rec.attribute4 = hr_api.g_varchar2) then
528: p_rec.attribute4 :=
529: per_ceo_shd.g_old_rec.attribute4;
530: End If;
531: If (p_rec.attribute5 = hr_api.g_varchar2) then
532: p_rec.attribute5 :=
533: per_ceo_shd.g_old_rec.attribute5;
534: End If;
535: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 535: If (p_rec.attribute6 = hr_api.g_varchar2) then

531: If (p_rec.attribute5 = hr_api.g_varchar2) then
532: p_rec.attribute5 :=
533: per_ceo_shd.g_old_rec.attribute5;
534: End If;
535: If (p_rec.attribute6 = hr_api.g_varchar2) then
536: p_rec.attribute6 :=
537: per_ceo_shd.g_old_rec.attribute6;
538: End If;
539: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 539: If (p_rec.attribute7 = hr_api.g_varchar2) then

535: If (p_rec.attribute6 = hr_api.g_varchar2) then
536: p_rec.attribute6 :=
537: per_ceo_shd.g_old_rec.attribute6;
538: End If;
539: If (p_rec.attribute7 = hr_api.g_varchar2) then
540: p_rec.attribute7 :=
541: per_ceo_shd.g_old_rec.attribute7;
542: End If;
543: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 543: If (p_rec.attribute8 = hr_api.g_varchar2) then

539: If (p_rec.attribute7 = hr_api.g_varchar2) then
540: p_rec.attribute7 :=
541: per_ceo_shd.g_old_rec.attribute7;
542: End If;
543: If (p_rec.attribute8 = hr_api.g_varchar2) then
544: p_rec.attribute8 :=
545: per_ceo_shd.g_old_rec.attribute8;
546: End If;
547: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 547: If (p_rec.attribute9 = hr_api.g_varchar2) then

543: If (p_rec.attribute8 = hr_api.g_varchar2) then
544: p_rec.attribute8 :=
545: per_ceo_shd.g_old_rec.attribute8;
546: End If;
547: If (p_rec.attribute9 = hr_api.g_varchar2) then
548: p_rec.attribute9 :=
549: per_ceo_shd.g_old_rec.attribute9;
550: End If;
551: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 551: If (p_rec.attribute10 = hr_api.g_varchar2) then

547: If (p_rec.attribute9 = hr_api.g_varchar2) then
548: p_rec.attribute9 :=
549: per_ceo_shd.g_old_rec.attribute9;
550: End If;
551: If (p_rec.attribute10 = hr_api.g_varchar2) then
552: p_rec.attribute10 :=
553: per_ceo_shd.g_old_rec.attribute10;
554: End If;
555: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 555: If (p_rec.attribute11 = hr_api.g_varchar2) then

551: If (p_rec.attribute10 = hr_api.g_varchar2) then
552: p_rec.attribute10 :=
553: per_ceo_shd.g_old_rec.attribute10;
554: End If;
555: If (p_rec.attribute11 = hr_api.g_varchar2) then
556: p_rec.attribute11 :=
557: per_ceo_shd.g_old_rec.attribute11;
558: End If;
559: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 559: If (p_rec.attribute12 = hr_api.g_varchar2) then

555: If (p_rec.attribute11 = hr_api.g_varchar2) then
556: p_rec.attribute11 :=
557: per_ceo_shd.g_old_rec.attribute11;
558: End If;
559: If (p_rec.attribute12 = hr_api.g_varchar2) then
560: p_rec.attribute12 :=
561: per_ceo_shd.g_old_rec.attribute12;
562: End If;
563: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 563: If (p_rec.attribute13 = hr_api.g_varchar2) then

559: If (p_rec.attribute12 = hr_api.g_varchar2) then
560: p_rec.attribute12 :=
561: per_ceo_shd.g_old_rec.attribute12;
562: End If;
563: If (p_rec.attribute13 = hr_api.g_varchar2) then
564: p_rec.attribute13 :=
565: per_ceo_shd.g_old_rec.attribute13;
566: End If;
567: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 567: If (p_rec.attribute14 = hr_api.g_varchar2) then

563: If (p_rec.attribute13 = hr_api.g_varchar2) then
564: p_rec.attribute13 :=
565: per_ceo_shd.g_old_rec.attribute13;
566: End If;
567: If (p_rec.attribute14 = hr_api.g_varchar2) then
568: p_rec.attribute14 :=
569: per_ceo_shd.g_old_rec.attribute14;
570: End If;
571: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 571: If (p_rec.attribute15 = hr_api.g_varchar2) then

567: If (p_rec.attribute14 = hr_api.g_varchar2) then
568: p_rec.attribute14 :=
569: per_ceo_shd.g_old_rec.attribute14;
570: End If;
571: If (p_rec.attribute15 = hr_api.g_varchar2) then
572: p_rec.attribute15 :=
573: per_ceo_shd.g_old_rec.attribute15;
574: End If;
575: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 575: If (p_rec.attribute16 = hr_api.g_varchar2) then

571: If (p_rec.attribute15 = hr_api.g_varchar2) then
572: p_rec.attribute15 :=
573: per_ceo_shd.g_old_rec.attribute15;
574: End If;
575: If (p_rec.attribute16 = hr_api.g_varchar2) then
576: p_rec.attribute16 :=
577: per_ceo_shd.g_old_rec.attribute16;
578: End If;
579: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 579: If (p_rec.attribute17 = hr_api.g_varchar2) then

575: If (p_rec.attribute16 = hr_api.g_varchar2) then
576: p_rec.attribute16 :=
577: per_ceo_shd.g_old_rec.attribute16;
578: End If;
579: If (p_rec.attribute17 = hr_api.g_varchar2) then
580: p_rec.attribute17 :=
581: per_ceo_shd.g_old_rec.attribute17;
582: End If;
583: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 583: If (p_rec.attribute18 = hr_api.g_varchar2) then

579: If (p_rec.attribute17 = hr_api.g_varchar2) then
580: p_rec.attribute17 :=
581: per_ceo_shd.g_old_rec.attribute17;
582: End If;
583: If (p_rec.attribute18 = hr_api.g_varchar2) then
584: p_rec.attribute18 :=
585: per_ceo_shd.g_old_rec.attribute18;
586: End If;
587: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 587: If (p_rec.attribute19 = hr_api.g_varchar2) then

583: If (p_rec.attribute18 = hr_api.g_varchar2) then
584: p_rec.attribute18 :=
585: per_ceo_shd.g_old_rec.attribute18;
586: End If;
587: If (p_rec.attribute19 = hr_api.g_varchar2) then
588: p_rec.attribute19 :=
589: per_ceo_shd.g_old_rec.attribute19;
590: End If;
591: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 591: If (p_rec.attribute20 = hr_api.g_varchar2) then

587: If (p_rec.attribute19 = hr_api.g_varchar2) then
588: p_rec.attribute19 :=
589: per_ceo_shd.g_old_rec.attribute19;
590: End If;
591: If (p_rec.attribute20 = hr_api.g_varchar2) then
592: p_rec.attribute20 :=
593: per_ceo_shd.g_old_rec.attribute20;
594: End If;
595: If (p_rec.information_category = hr_api.g_varchar2) then

Line 595: If (p_rec.information_category = hr_api.g_varchar2) then

591: If (p_rec.attribute20 = hr_api.g_varchar2) then
592: p_rec.attribute20 :=
593: per_ceo_shd.g_old_rec.attribute20;
594: End If;
595: If (p_rec.information_category = hr_api.g_varchar2) then
596: p_rec.information_category :=
597: per_ceo_shd.g_old_rec.information_category;
598: End If;
599: If (p_rec.information1 = hr_api.g_varchar2) then

Line 599: If (p_rec.information1 = hr_api.g_varchar2) then

595: If (p_rec.information_category = hr_api.g_varchar2) then
596: p_rec.information_category :=
597: per_ceo_shd.g_old_rec.information_category;
598: End If;
599: If (p_rec.information1 = hr_api.g_varchar2) then
600: p_rec.information1 :=
601: per_ceo_shd.g_old_rec.information1;
602: End If;
603: If (p_rec.information2 = hr_api.g_varchar2) then

Line 603: If (p_rec.information2 = hr_api.g_varchar2) then

599: If (p_rec.information1 = hr_api.g_varchar2) then
600: p_rec.information1 :=
601: per_ceo_shd.g_old_rec.information1;
602: End If;
603: If (p_rec.information2 = hr_api.g_varchar2) then
604: p_rec.information2 :=
605: per_ceo_shd.g_old_rec.information2;
606: End If;
607: If (p_rec.information3 = hr_api.g_varchar2) then

Line 607: If (p_rec.information3 = hr_api.g_varchar2) then

603: If (p_rec.information2 = hr_api.g_varchar2) then
604: p_rec.information2 :=
605: per_ceo_shd.g_old_rec.information2;
606: End If;
607: If (p_rec.information3 = hr_api.g_varchar2) then
608: p_rec.information3 :=
609: per_ceo_shd.g_old_rec.information3;
610: End If;
611: If (p_rec.information4 = hr_api.g_varchar2) then

Line 611: If (p_rec.information4 = hr_api.g_varchar2) then

607: If (p_rec.information3 = hr_api.g_varchar2) then
608: p_rec.information3 :=
609: per_ceo_shd.g_old_rec.information3;
610: End If;
611: If (p_rec.information4 = hr_api.g_varchar2) then
612: p_rec.information4 :=
613: per_ceo_shd.g_old_rec.information4;
614: End If;
615: If (p_rec.information5 = hr_api.g_varchar2) then

Line 615: If (p_rec.information5 = hr_api.g_varchar2) then

611: If (p_rec.information4 = hr_api.g_varchar2) then
612: p_rec.information4 :=
613: per_ceo_shd.g_old_rec.information4;
614: End If;
615: If (p_rec.information5 = hr_api.g_varchar2) then
616: p_rec.information5 :=
617: per_ceo_shd.g_old_rec.information5;
618: End If;
619: If (p_rec.information6 = hr_api.g_varchar2) then

Line 619: If (p_rec.information6 = hr_api.g_varchar2) then

615: If (p_rec.information5 = hr_api.g_varchar2) then
616: p_rec.information5 :=
617: per_ceo_shd.g_old_rec.information5;
618: End If;
619: If (p_rec.information6 = hr_api.g_varchar2) then
620: p_rec.information6 :=
621: per_ceo_shd.g_old_rec.information6;
622: End If;
623: If (p_rec.information7 = hr_api.g_varchar2) then

Line 623: If (p_rec.information7 = hr_api.g_varchar2) then

619: If (p_rec.information6 = hr_api.g_varchar2) then
620: p_rec.information6 :=
621: per_ceo_shd.g_old_rec.information6;
622: End If;
623: If (p_rec.information7 = hr_api.g_varchar2) then
624: p_rec.information7 :=
625: per_ceo_shd.g_old_rec.information7;
626: End If;
627: If (p_rec.information8 = hr_api.g_varchar2) then

Line 627: If (p_rec.information8 = hr_api.g_varchar2) then

623: If (p_rec.information7 = hr_api.g_varchar2) then
624: p_rec.information7 :=
625: per_ceo_shd.g_old_rec.information7;
626: End If;
627: If (p_rec.information8 = hr_api.g_varchar2) then
628: p_rec.information8 :=
629: per_ceo_shd.g_old_rec.information8;
630: End If;
631: If (p_rec.information9 = hr_api.g_varchar2) then

Line 631: If (p_rec.information9 = hr_api.g_varchar2) then

627: If (p_rec.information8 = hr_api.g_varchar2) then
628: p_rec.information8 :=
629: per_ceo_shd.g_old_rec.information8;
630: End If;
631: If (p_rec.information9 = hr_api.g_varchar2) then
632: p_rec.information9 :=
633: per_ceo_shd.g_old_rec.information9;
634: End If;
635: If (p_rec.information10 = hr_api.g_varchar2) then

Line 635: If (p_rec.information10 = hr_api.g_varchar2) then

631: If (p_rec.information9 = hr_api.g_varchar2) then
632: p_rec.information9 :=
633: per_ceo_shd.g_old_rec.information9;
634: End If;
635: If (p_rec.information10 = hr_api.g_varchar2) then
636: p_rec.information10 :=
637: per_ceo_shd.g_old_rec.information10;
638: End If;
639: If (p_rec.information11 = hr_api.g_varchar2) then

Line 639: If (p_rec.information11 = hr_api.g_varchar2) then

635: If (p_rec.information10 = hr_api.g_varchar2) then
636: p_rec.information10 :=
637: per_ceo_shd.g_old_rec.information10;
638: End If;
639: If (p_rec.information11 = hr_api.g_varchar2) then
640: p_rec.information11 :=
641: per_ceo_shd.g_old_rec.information11;
642: End If;
643: If (p_rec.information12 = hr_api.g_varchar2) then

Line 643: If (p_rec.information12 = hr_api.g_varchar2) then

639: If (p_rec.information11 = hr_api.g_varchar2) then
640: p_rec.information11 :=
641: per_ceo_shd.g_old_rec.information11;
642: End If;
643: If (p_rec.information12 = hr_api.g_varchar2) then
644: p_rec.information12 :=
645: per_ceo_shd.g_old_rec.information12;
646: End If;
647: If (p_rec.information13 = hr_api.g_varchar2) then

Line 647: If (p_rec.information13 = hr_api.g_varchar2) then

643: If (p_rec.information12 = hr_api.g_varchar2) then
644: p_rec.information12 :=
645: per_ceo_shd.g_old_rec.information12;
646: End If;
647: If (p_rec.information13 = hr_api.g_varchar2) then
648: p_rec.information13 :=
649: per_ceo_shd.g_old_rec.information13;
650: End If;
651: If (p_rec.information14 = hr_api.g_varchar2) then

Line 651: If (p_rec.information14 = hr_api.g_varchar2) then

647: If (p_rec.information13 = hr_api.g_varchar2) then
648: p_rec.information13 :=
649: per_ceo_shd.g_old_rec.information13;
650: End If;
651: If (p_rec.information14 = hr_api.g_varchar2) then
652: p_rec.information14 :=
653: per_ceo_shd.g_old_rec.information14;
654: End If;
655: If (p_rec.information15 = hr_api.g_varchar2) then

Line 655: If (p_rec.information15 = hr_api.g_varchar2) then

651: If (p_rec.information14 = hr_api.g_varchar2) then
652: p_rec.information14 :=
653: per_ceo_shd.g_old_rec.information14;
654: End If;
655: If (p_rec.information15 = hr_api.g_varchar2) then
656: p_rec.information15 :=
657: per_ceo_shd.g_old_rec.information15;
658: End If;
659: If (p_rec.information16 = hr_api.g_varchar2) then

Line 659: If (p_rec.information16 = hr_api.g_varchar2) then

655: If (p_rec.information15 = hr_api.g_varchar2) then
656: p_rec.information15 :=
657: per_ceo_shd.g_old_rec.information15;
658: End If;
659: If (p_rec.information16 = hr_api.g_varchar2) then
660: p_rec.information16 :=
661: per_ceo_shd.g_old_rec.information16;
662: End If;
663: If (p_rec.information17 = hr_api.g_varchar2) then

Line 663: If (p_rec.information17 = hr_api.g_varchar2) then

659: If (p_rec.information16 = hr_api.g_varchar2) then
660: p_rec.information16 :=
661: per_ceo_shd.g_old_rec.information16;
662: End If;
663: If (p_rec.information17 = hr_api.g_varchar2) then
664: p_rec.information17 :=
665: per_ceo_shd.g_old_rec.information17;
666: End If;
667: If (p_rec.information18 = hr_api.g_varchar2) then

Line 667: If (p_rec.information18 = hr_api.g_varchar2) then

663: If (p_rec.information17 = hr_api.g_varchar2) then
664: p_rec.information17 :=
665: per_ceo_shd.g_old_rec.information17;
666: End If;
667: If (p_rec.information18 = hr_api.g_varchar2) then
668: p_rec.information18 :=
669: per_ceo_shd.g_old_rec.information18;
670: End If;
671: If (p_rec.information19 = hr_api.g_varchar2) then

Line 671: If (p_rec.information19 = hr_api.g_varchar2) then

667: If (p_rec.information18 = hr_api.g_varchar2) then
668: p_rec.information18 :=
669: per_ceo_shd.g_old_rec.information18;
670: End If;
671: If (p_rec.information19 = hr_api.g_varchar2) then
672: p_rec.information19 :=
673: per_ceo_shd.g_old_rec.information19;
674: End If;
675: If (p_rec.information20 = hr_api.g_varchar2) then

Line 675: If (p_rec.information20 = hr_api.g_varchar2) then

671: If (p_rec.information19 = hr_api.g_varchar2) then
672: p_rec.information19 :=
673: per_ceo_shd.g_old_rec.information19;
674: End If;
675: If (p_rec.information20 = hr_api.g_varchar2) then
676: p_rec.information20 :=
677: per_ceo_shd.g_old_rec.information20;
678: End If;
679: --

Line 743: ,p_competence_element_id in number default hr_api.g_number

739: Procedure upd
740: (p_effective_date in date
741: ,p_comp_element_outcome_id in number
742: ,p_object_version_number in out nocopy number
743: ,p_competence_element_id in number default hr_api.g_number
744: ,p_outcome_id in number default hr_api.g_number
745: ,p_date_from in date default hr_api.g_date
746: ,p_date_to in date default hr_api.g_date
747: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 744: ,p_outcome_id in number default hr_api.g_number

740: (p_effective_date in date
741: ,p_comp_element_outcome_id in number
742: ,p_object_version_number in out nocopy number
743: ,p_competence_element_id in number default hr_api.g_number
744: ,p_outcome_id in number default hr_api.g_number
745: ,p_date_from in date default hr_api.g_date
746: ,p_date_to in date default hr_api.g_date
747: ,p_attribute_category in varchar2 default hr_api.g_varchar2
748: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 745: ,p_date_from in date default hr_api.g_date

741: ,p_comp_element_outcome_id in number
742: ,p_object_version_number in out nocopy number
743: ,p_competence_element_id in number default hr_api.g_number
744: ,p_outcome_id in number default hr_api.g_number
745: ,p_date_from in date default hr_api.g_date
746: ,p_date_to in date default hr_api.g_date
747: ,p_attribute_category in varchar2 default hr_api.g_varchar2
748: ,p_attribute1 in varchar2 default hr_api.g_varchar2
749: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 746: ,p_date_to in date default hr_api.g_date

742: ,p_object_version_number in out nocopy number
743: ,p_competence_element_id in number default hr_api.g_number
744: ,p_outcome_id in number default hr_api.g_number
745: ,p_date_from in date default hr_api.g_date
746: ,p_date_to in date default hr_api.g_date
747: ,p_attribute_category in varchar2 default hr_api.g_varchar2
748: ,p_attribute1 in varchar2 default hr_api.g_varchar2
749: ,p_attribute2 in varchar2 default hr_api.g_varchar2
750: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 747: ,p_attribute_category in varchar2 default hr_api.g_varchar2

743: ,p_competence_element_id in number default hr_api.g_number
744: ,p_outcome_id in number default hr_api.g_number
745: ,p_date_from in date default hr_api.g_date
746: ,p_date_to in date default hr_api.g_date
747: ,p_attribute_category in varchar2 default hr_api.g_varchar2
748: ,p_attribute1 in varchar2 default hr_api.g_varchar2
749: ,p_attribute2 in varchar2 default hr_api.g_varchar2
750: ,p_attribute3 in varchar2 default hr_api.g_varchar2
751: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 748: ,p_attribute1 in varchar2 default hr_api.g_varchar2

744: ,p_outcome_id in number default hr_api.g_number
745: ,p_date_from in date default hr_api.g_date
746: ,p_date_to in date default hr_api.g_date
747: ,p_attribute_category in varchar2 default hr_api.g_varchar2
748: ,p_attribute1 in varchar2 default hr_api.g_varchar2
749: ,p_attribute2 in varchar2 default hr_api.g_varchar2
750: ,p_attribute3 in varchar2 default hr_api.g_varchar2
751: ,p_attribute4 in varchar2 default hr_api.g_varchar2
752: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 749: ,p_attribute2 in varchar2 default hr_api.g_varchar2

745: ,p_date_from in date default hr_api.g_date
746: ,p_date_to in date default hr_api.g_date
747: ,p_attribute_category in varchar2 default hr_api.g_varchar2
748: ,p_attribute1 in varchar2 default hr_api.g_varchar2
749: ,p_attribute2 in varchar2 default hr_api.g_varchar2
750: ,p_attribute3 in varchar2 default hr_api.g_varchar2
751: ,p_attribute4 in varchar2 default hr_api.g_varchar2
752: ,p_attribute5 in varchar2 default hr_api.g_varchar2
753: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 750: ,p_attribute3 in varchar2 default hr_api.g_varchar2

746: ,p_date_to in date default hr_api.g_date
747: ,p_attribute_category in varchar2 default hr_api.g_varchar2
748: ,p_attribute1 in varchar2 default hr_api.g_varchar2
749: ,p_attribute2 in varchar2 default hr_api.g_varchar2
750: ,p_attribute3 in varchar2 default hr_api.g_varchar2
751: ,p_attribute4 in varchar2 default hr_api.g_varchar2
752: ,p_attribute5 in varchar2 default hr_api.g_varchar2
753: ,p_attribute6 in varchar2 default hr_api.g_varchar2
754: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 751: ,p_attribute4 in varchar2 default hr_api.g_varchar2

747: ,p_attribute_category in varchar2 default hr_api.g_varchar2
748: ,p_attribute1 in varchar2 default hr_api.g_varchar2
749: ,p_attribute2 in varchar2 default hr_api.g_varchar2
750: ,p_attribute3 in varchar2 default hr_api.g_varchar2
751: ,p_attribute4 in varchar2 default hr_api.g_varchar2
752: ,p_attribute5 in varchar2 default hr_api.g_varchar2
753: ,p_attribute6 in varchar2 default hr_api.g_varchar2
754: ,p_attribute7 in varchar2 default hr_api.g_varchar2
755: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 752: ,p_attribute5 in varchar2 default hr_api.g_varchar2

748: ,p_attribute1 in varchar2 default hr_api.g_varchar2
749: ,p_attribute2 in varchar2 default hr_api.g_varchar2
750: ,p_attribute3 in varchar2 default hr_api.g_varchar2
751: ,p_attribute4 in varchar2 default hr_api.g_varchar2
752: ,p_attribute5 in varchar2 default hr_api.g_varchar2
753: ,p_attribute6 in varchar2 default hr_api.g_varchar2
754: ,p_attribute7 in varchar2 default hr_api.g_varchar2
755: ,p_attribute8 in varchar2 default hr_api.g_varchar2
756: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 753: ,p_attribute6 in varchar2 default hr_api.g_varchar2

749: ,p_attribute2 in varchar2 default hr_api.g_varchar2
750: ,p_attribute3 in varchar2 default hr_api.g_varchar2
751: ,p_attribute4 in varchar2 default hr_api.g_varchar2
752: ,p_attribute5 in varchar2 default hr_api.g_varchar2
753: ,p_attribute6 in varchar2 default hr_api.g_varchar2
754: ,p_attribute7 in varchar2 default hr_api.g_varchar2
755: ,p_attribute8 in varchar2 default hr_api.g_varchar2
756: ,p_attribute9 in varchar2 default hr_api.g_varchar2
757: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 754: ,p_attribute7 in varchar2 default hr_api.g_varchar2

750: ,p_attribute3 in varchar2 default hr_api.g_varchar2
751: ,p_attribute4 in varchar2 default hr_api.g_varchar2
752: ,p_attribute5 in varchar2 default hr_api.g_varchar2
753: ,p_attribute6 in varchar2 default hr_api.g_varchar2
754: ,p_attribute7 in varchar2 default hr_api.g_varchar2
755: ,p_attribute8 in varchar2 default hr_api.g_varchar2
756: ,p_attribute9 in varchar2 default hr_api.g_varchar2
757: ,p_attribute10 in varchar2 default hr_api.g_varchar2
758: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 755: ,p_attribute8 in varchar2 default hr_api.g_varchar2

751: ,p_attribute4 in varchar2 default hr_api.g_varchar2
752: ,p_attribute5 in varchar2 default hr_api.g_varchar2
753: ,p_attribute6 in varchar2 default hr_api.g_varchar2
754: ,p_attribute7 in varchar2 default hr_api.g_varchar2
755: ,p_attribute8 in varchar2 default hr_api.g_varchar2
756: ,p_attribute9 in varchar2 default hr_api.g_varchar2
757: ,p_attribute10 in varchar2 default hr_api.g_varchar2
758: ,p_attribute11 in varchar2 default hr_api.g_varchar2
759: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 756: ,p_attribute9 in varchar2 default hr_api.g_varchar2

752: ,p_attribute5 in varchar2 default hr_api.g_varchar2
753: ,p_attribute6 in varchar2 default hr_api.g_varchar2
754: ,p_attribute7 in varchar2 default hr_api.g_varchar2
755: ,p_attribute8 in varchar2 default hr_api.g_varchar2
756: ,p_attribute9 in varchar2 default hr_api.g_varchar2
757: ,p_attribute10 in varchar2 default hr_api.g_varchar2
758: ,p_attribute11 in varchar2 default hr_api.g_varchar2
759: ,p_attribute12 in varchar2 default hr_api.g_varchar2
760: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 757: ,p_attribute10 in varchar2 default hr_api.g_varchar2

753: ,p_attribute6 in varchar2 default hr_api.g_varchar2
754: ,p_attribute7 in varchar2 default hr_api.g_varchar2
755: ,p_attribute8 in varchar2 default hr_api.g_varchar2
756: ,p_attribute9 in varchar2 default hr_api.g_varchar2
757: ,p_attribute10 in varchar2 default hr_api.g_varchar2
758: ,p_attribute11 in varchar2 default hr_api.g_varchar2
759: ,p_attribute12 in varchar2 default hr_api.g_varchar2
760: ,p_attribute13 in varchar2 default hr_api.g_varchar2
761: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 758: ,p_attribute11 in varchar2 default hr_api.g_varchar2

754: ,p_attribute7 in varchar2 default hr_api.g_varchar2
755: ,p_attribute8 in varchar2 default hr_api.g_varchar2
756: ,p_attribute9 in varchar2 default hr_api.g_varchar2
757: ,p_attribute10 in varchar2 default hr_api.g_varchar2
758: ,p_attribute11 in varchar2 default hr_api.g_varchar2
759: ,p_attribute12 in varchar2 default hr_api.g_varchar2
760: ,p_attribute13 in varchar2 default hr_api.g_varchar2
761: ,p_attribute14 in varchar2 default hr_api.g_varchar2
762: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 759: ,p_attribute12 in varchar2 default hr_api.g_varchar2

755: ,p_attribute8 in varchar2 default hr_api.g_varchar2
756: ,p_attribute9 in varchar2 default hr_api.g_varchar2
757: ,p_attribute10 in varchar2 default hr_api.g_varchar2
758: ,p_attribute11 in varchar2 default hr_api.g_varchar2
759: ,p_attribute12 in varchar2 default hr_api.g_varchar2
760: ,p_attribute13 in varchar2 default hr_api.g_varchar2
761: ,p_attribute14 in varchar2 default hr_api.g_varchar2
762: ,p_attribute15 in varchar2 default hr_api.g_varchar2
763: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 760: ,p_attribute13 in varchar2 default hr_api.g_varchar2

756: ,p_attribute9 in varchar2 default hr_api.g_varchar2
757: ,p_attribute10 in varchar2 default hr_api.g_varchar2
758: ,p_attribute11 in varchar2 default hr_api.g_varchar2
759: ,p_attribute12 in varchar2 default hr_api.g_varchar2
760: ,p_attribute13 in varchar2 default hr_api.g_varchar2
761: ,p_attribute14 in varchar2 default hr_api.g_varchar2
762: ,p_attribute15 in varchar2 default hr_api.g_varchar2
763: ,p_attribute16 in varchar2 default hr_api.g_varchar2
764: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 761: ,p_attribute14 in varchar2 default hr_api.g_varchar2

757: ,p_attribute10 in varchar2 default hr_api.g_varchar2
758: ,p_attribute11 in varchar2 default hr_api.g_varchar2
759: ,p_attribute12 in varchar2 default hr_api.g_varchar2
760: ,p_attribute13 in varchar2 default hr_api.g_varchar2
761: ,p_attribute14 in varchar2 default hr_api.g_varchar2
762: ,p_attribute15 in varchar2 default hr_api.g_varchar2
763: ,p_attribute16 in varchar2 default hr_api.g_varchar2
764: ,p_attribute17 in varchar2 default hr_api.g_varchar2
765: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 762: ,p_attribute15 in varchar2 default hr_api.g_varchar2

758: ,p_attribute11 in varchar2 default hr_api.g_varchar2
759: ,p_attribute12 in varchar2 default hr_api.g_varchar2
760: ,p_attribute13 in varchar2 default hr_api.g_varchar2
761: ,p_attribute14 in varchar2 default hr_api.g_varchar2
762: ,p_attribute15 in varchar2 default hr_api.g_varchar2
763: ,p_attribute16 in varchar2 default hr_api.g_varchar2
764: ,p_attribute17 in varchar2 default hr_api.g_varchar2
765: ,p_attribute18 in varchar2 default hr_api.g_varchar2
766: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 763: ,p_attribute16 in varchar2 default hr_api.g_varchar2

759: ,p_attribute12 in varchar2 default hr_api.g_varchar2
760: ,p_attribute13 in varchar2 default hr_api.g_varchar2
761: ,p_attribute14 in varchar2 default hr_api.g_varchar2
762: ,p_attribute15 in varchar2 default hr_api.g_varchar2
763: ,p_attribute16 in varchar2 default hr_api.g_varchar2
764: ,p_attribute17 in varchar2 default hr_api.g_varchar2
765: ,p_attribute18 in varchar2 default hr_api.g_varchar2
766: ,p_attribute19 in varchar2 default hr_api.g_varchar2
767: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 764: ,p_attribute17 in varchar2 default hr_api.g_varchar2

760: ,p_attribute13 in varchar2 default hr_api.g_varchar2
761: ,p_attribute14 in varchar2 default hr_api.g_varchar2
762: ,p_attribute15 in varchar2 default hr_api.g_varchar2
763: ,p_attribute16 in varchar2 default hr_api.g_varchar2
764: ,p_attribute17 in varchar2 default hr_api.g_varchar2
765: ,p_attribute18 in varchar2 default hr_api.g_varchar2
766: ,p_attribute19 in varchar2 default hr_api.g_varchar2
767: ,p_attribute20 in varchar2 default hr_api.g_varchar2
768: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 765: ,p_attribute18 in varchar2 default hr_api.g_varchar2

761: ,p_attribute14 in varchar2 default hr_api.g_varchar2
762: ,p_attribute15 in varchar2 default hr_api.g_varchar2
763: ,p_attribute16 in varchar2 default hr_api.g_varchar2
764: ,p_attribute17 in varchar2 default hr_api.g_varchar2
765: ,p_attribute18 in varchar2 default hr_api.g_varchar2
766: ,p_attribute19 in varchar2 default hr_api.g_varchar2
767: ,p_attribute20 in varchar2 default hr_api.g_varchar2
768: ,p_information_category in varchar2 default hr_api.g_varchar2
769: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 766: ,p_attribute19 in varchar2 default hr_api.g_varchar2

762: ,p_attribute15 in varchar2 default hr_api.g_varchar2
763: ,p_attribute16 in varchar2 default hr_api.g_varchar2
764: ,p_attribute17 in varchar2 default hr_api.g_varchar2
765: ,p_attribute18 in varchar2 default hr_api.g_varchar2
766: ,p_attribute19 in varchar2 default hr_api.g_varchar2
767: ,p_attribute20 in varchar2 default hr_api.g_varchar2
768: ,p_information_category in varchar2 default hr_api.g_varchar2
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 767: ,p_attribute20 in varchar2 default hr_api.g_varchar2

763: ,p_attribute16 in varchar2 default hr_api.g_varchar2
764: ,p_attribute17 in varchar2 default hr_api.g_varchar2
765: ,p_attribute18 in varchar2 default hr_api.g_varchar2
766: ,p_attribute19 in varchar2 default hr_api.g_varchar2
767: ,p_attribute20 in varchar2 default hr_api.g_varchar2
768: ,p_information_category in varchar2 default hr_api.g_varchar2
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 768: ,p_information_category in varchar2 default hr_api.g_varchar2

764: ,p_attribute17 in varchar2 default hr_api.g_varchar2
765: ,p_attribute18 in varchar2 default hr_api.g_varchar2
766: ,p_attribute19 in varchar2 default hr_api.g_varchar2
767: ,p_attribute20 in varchar2 default hr_api.g_varchar2
768: ,p_information_category in varchar2 default hr_api.g_varchar2
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 769: ,p_information1 in varchar2 default hr_api.g_varchar2

765: ,p_attribute18 in varchar2 default hr_api.g_varchar2
766: ,p_attribute19 in varchar2 default hr_api.g_varchar2
767: ,p_attribute20 in varchar2 default hr_api.g_varchar2
768: ,p_information_category in varchar2 default hr_api.g_varchar2
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 770: ,p_information2 in varchar2 default hr_api.g_varchar2

766: ,p_attribute19 in varchar2 default hr_api.g_varchar2
767: ,p_attribute20 in varchar2 default hr_api.g_varchar2
768: ,p_information_category in varchar2 default hr_api.g_varchar2
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 771: ,p_information3 in varchar2 default hr_api.g_varchar2

767: ,p_attribute20 in varchar2 default hr_api.g_varchar2
768: ,p_information_category in varchar2 default hr_api.g_varchar2
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 772: ,p_information4 in varchar2 default hr_api.g_varchar2

768: ,p_information_category in varchar2 default hr_api.g_varchar2
769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 773: ,p_information5 in varchar2 default hr_api.g_varchar2

769: ,p_information1 in varchar2 default hr_api.g_varchar2
770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 774: ,p_information6 in varchar2 default hr_api.g_varchar2

770: ,p_information2 in varchar2 default hr_api.g_varchar2
771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 775: ,p_information7 in varchar2 default hr_api.g_varchar2

771: ,p_information3 in varchar2 default hr_api.g_varchar2
772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 776: ,p_information8 in varchar2 default hr_api.g_varchar2

772: ,p_information4 in varchar2 default hr_api.g_varchar2
773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 777: ,p_information9 in varchar2 default hr_api.g_varchar2

773: ,p_information5 in varchar2 default hr_api.g_varchar2
774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 778: ,p_information10 in varchar2 default hr_api.g_varchar2

774: ,p_information6 in varchar2 default hr_api.g_varchar2
775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 779: ,p_information11 in varchar2 default hr_api.g_varchar2

775: ,p_information7 in varchar2 default hr_api.g_varchar2
776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 780: ,p_information12 in varchar2 default hr_api.g_varchar2

776: ,p_information8 in varchar2 default hr_api.g_varchar2
777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 781: ,p_information13 in varchar2 default hr_api.g_varchar2

777: ,p_information9 in varchar2 default hr_api.g_varchar2
778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 782: ,p_information14 in varchar2 default hr_api.g_varchar2

778: ,p_information10 in varchar2 default hr_api.g_varchar2
779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 783: ,p_information15 in varchar2 default hr_api.g_varchar2

779: ,p_information11 in varchar2 default hr_api.g_varchar2
780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 784: ,p_information16 in varchar2 default hr_api.g_varchar2

780: ,p_information12 in varchar2 default hr_api.g_varchar2
781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 785: ,p_information17 in varchar2 default hr_api.g_varchar2

781: ,p_information13 in varchar2 default hr_api.g_varchar2
782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2
789: ) is

Line 786: ,p_information18 in varchar2 default hr_api.g_varchar2

782: ,p_information14 in varchar2 default hr_api.g_varchar2
783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2
789: ) is
790: --

Line 787: ,p_information19 in varchar2 default hr_api.g_varchar2

783: ,p_information15 in varchar2 default hr_api.g_varchar2
784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2
789: ) is
790: --
791: l_rec per_ceo_shd.g_rec_type;

Line 788: ,p_information20 in varchar2 default hr_api.g_varchar2

784: ,p_information16 in varchar2 default hr_api.g_varchar2
785: ,p_information17 in varchar2 default hr_api.g_varchar2
786: ,p_information18 in varchar2 default hr_api.g_varchar2
787: ,p_information19 in varchar2 default hr_api.g_varchar2
788: ,p_information20 in varchar2 default hr_api.g_varchar2
789: ) is
790: --
791: l_rec per_ceo_shd.g_rec_type;
792: l_proc varchar2(72) := g_package||'upd';