eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CEL_UPD dependencies on HR_API

Line 152: When hr_api.check_integrity_violated Then

148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 10);
150: --
151: Exception
152: When hr_api.check_integrity_violated Then
153: -- A check constraint has been violated
154: per_cel_shd.g_api_dml := false; -- Unset the api dml status
155: per_cel_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

152: When hr_api.check_integrity_violated Then
153: -- A check constraint has been violated
154: per_cel_shd.g_api_dml := false; -- Unset the api dml status
155: per_cel_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.parent_integrity_violated Then
158: -- Parent integrity has been violated
159: per_cel_shd.g_api_dml := false; -- Unset the api dml status
160: per_cel_shd.constraint_error

Line 157: When hr_api.parent_integrity_violated Then

153: -- A check constraint has been violated
154: per_cel_shd.g_api_dml := false; -- Unset the api dml status
155: per_cel_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When hr_api.parent_integrity_violated Then
158: -- Parent integrity has been violated
159: per_cel_shd.g_api_dml := false; -- Unset the api dml status
160: per_cel_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

157: When hr_api.parent_integrity_violated Then
158: -- Parent integrity has been violated
159: per_cel_shd.g_api_dml := false; -- Unset the api dml status
160: per_cel_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: per_cel_shd.g_api_dml := false; -- Unset the api dml status
165: per_cel_shd.constraint_error

Line 162: When hr_api.unique_integrity_violated Then

158: -- Parent integrity has been violated
159: per_cel_shd.g_api_dml := false; -- Unset the api dml status
160: per_cel_shd.constraint_error
161: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: per_cel_shd.g_api_dml := false; -- Unset the api dml status
165: per_cel_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

162: When hr_api.unique_integrity_violated Then
163: -- Unique integrity has been violated
164: per_cel_shd.g_api_dml := false; -- Unset the api dml status
165: per_cel_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When Others Then
168: per_cel_shd.g_api_dml := false; -- Unset the api dml status
169: Raise;
170: End update_dml;

Line 439: when hr_api.cannot_find_prog_unit then

435: p_achieved_date_o => per_cel_shd.g_old_rec.achieved_date ,
436: p_appr_line_score_o => per_cel_shd.g_old_rec.appr_line_score
437: );
438: exception
439: when hr_api.cannot_find_prog_unit then
440: hr_api.cannot_find_prog_unit_error
441: ( p_module_name => 'PER_COMPETENCE_ELEMENTS'
442: ,p_hook_type => 'AU'
443: );

Line 440: hr_api.cannot_find_prog_unit_error

436: p_appr_line_score_o => per_cel_shd.g_old_rec.appr_line_score
437: );
438: exception
439: when hr_api.cannot_find_prog_unit then
440: hr_api.cannot_find_prog_unit_error
441: ( p_module_name => 'PER_COMPETENCE_ELEMENTS'
442: ,p_hook_type => 'AU'
443: );
444: end;

Line 507: If (p_rec.type = hr_api.g_varchar2) then

503: -- p_rec plsql record structure
504: -- to see if a system default is being used. If a system default
505: -- is being used then we must set to the 'current' argument value.
506: --
507: If (p_rec.type = hr_api.g_varchar2) then
508: p_rec.type :=
509: per_cel_shd.g_old_rec.type;
510: End If;
511: If (p_rec.business_group_id = hr_api.g_number) then

Line 511: If (p_rec.business_group_id = hr_api.g_number) then

507: If (p_rec.type = hr_api.g_varchar2) then
508: p_rec.type :=
509: per_cel_shd.g_old_rec.type;
510: End If;
511: If (p_rec.business_group_id = hr_api.g_number) then
512: p_rec.business_group_id :=
513: per_cel_shd.g_old_rec.business_group_id;
514: End If;
515: If (p_rec.competence_id = hr_api.g_number) then

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

511: If (p_rec.business_group_id = hr_api.g_number) then
512: p_rec.business_group_id :=
513: per_cel_shd.g_old_rec.business_group_id;
514: End If;
515: If (p_rec.competence_id = hr_api.g_number) then
516: p_rec.competence_id :=
517: per_cel_shd.g_old_rec.competence_id;
518: End If;
519: If (p_rec.proficiency_level_id = hr_api.g_number) then

Line 519: If (p_rec.proficiency_level_id = hr_api.g_number) then

515: If (p_rec.competence_id = hr_api.g_number) then
516: p_rec.competence_id :=
517: per_cel_shd.g_old_rec.competence_id;
518: End If;
519: If (p_rec.proficiency_level_id = hr_api.g_number) then
520: p_rec.proficiency_level_id :=
521: per_cel_shd.g_old_rec.proficiency_level_id;
522: End If;
523: If (p_rec.high_proficiency_level_id = hr_api.g_number) then

Line 523: If (p_rec.high_proficiency_level_id = hr_api.g_number) then

519: If (p_rec.proficiency_level_id = hr_api.g_number) then
520: p_rec.proficiency_level_id :=
521: per_cel_shd.g_old_rec.proficiency_level_id;
522: End If;
523: If (p_rec.high_proficiency_level_id = hr_api.g_number) then
524: p_rec.high_proficiency_level_id :=
525: per_cel_shd.g_old_rec.high_proficiency_level_id;
526: End If;
527: If (p_rec.weighting_level_id = hr_api.g_number) then

Line 527: If (p_rec.weighting_level_id = hr_api.g_number) then

523: If (p_rec.high_proficiency_level_id = hr_api.g_number) then
524: p_rec.high_proficiency_level_id :=
525: per_cel_shd.g_old_rec.high_proficiency_level_id;
526: End If;
527: If (p_rec.weighting_level_id = hr_api.g_number) then
528: p_rec.weighting_level_id :=
529: per_cel_shd.g_old_rec.weighting_level_id;
530: End If;
531: If (p_rec.rating_level_id = hr_api.g_number) then

Line 531: If (p_rec.rating_level_id = hr_api.g_number) then

527: If (p_rec.weighting_level_id = hr_api.g_number) then
528: p_rec.weighting_level_id :=
529: per_cel_shd.g_old_rec.weighting_level_id;
530: End If;
531: If (p_rec.rating_level_id = hr_api.g_number) then
532: p_rec.rating_level_id :=
533: per_cel_shd.g_old_rec.rating_level_id;
534: End If;
535: If (p_rec.person_id = hr_api.g_number) then

Line 535: If (p_rec.person_id = hr_api.g_number) then

531: If (p_rec.rating_level_id = hr_api.g_number) then
532: p_rec.rating_level_id :=
533: per_cel_shd.g_old_rec.rating_level_id;
534: End If;
535: If (p_rec.person_id = hr_api.g_number) then
536: p_rec.person_id :=
537: per_cel_shd.g_old_rec.person_id;
538: End If;
539: If (p_rec.job_id = hr_api.g_number) then

Line 539: If (p_rec.job_id = hr_api.g_number) then

535: If (p_rec.person_id = hr_api.g_number) then
536: p_rec.person_id :=
537: per_cel_shd.g_old_rec.person_id;
538: End If;
539: If (p_rec.job_id = hr_api.g_number) then
540: p_rec.job_id :=
541: per_cel_shd.g_old_rec.job_id;
542: End If;
543: If (p_rec.valid_grade_id = hr_api.g_number) then

Line 543: If (p_rec.valid_grade_id = hr_api.g_number) then

539: If (p_rec.job_id = hr_api.g_number) then
540: p_rec.job_id :=
541: per_cel_shd.g_old_rec.job_id;
542: End If;
543: If (p_rec.valid_grade_id = hr_api.g_number) then
544: p_rec.valid_grade_id :=
545: per_cel_shd.g_old_rec.valid_grade_id;
546: end if;
547: If (p_rec.enterprise_id = hr_api.g_number) then

Line 547: If (p_rec.enterprise_id = hr_api.g_number) then

543: If (p_rec.valid_grade_id = hr_api.g_number) then
544: p_rec.valid_grade_id :=
545: per_cel_shd.g_old_rec.valid_grade_id;
546: end if;
547: If (p_rec.enterprise_id = hr_api.g_number) then
548: p_rec.enterprise_id :=
549: per_cel_shd.g_old_rec.enterprise_id;
550: End If;
551: If (p_rec.position_id = hr_api.g_number) then

Line 551: If (p_rec.position_id = hr_api.g_number) then

547: If (p_rec.enterprise_id = hr_api.g_number) then
548: p_rec.enterprise_id :=
549: per_cel_shd.g_old_rec.enterprise_id;
550: End If;
551: If (p_rec.position_id = hr_api.g_number) then
552: p_rec.position_id :=
553: per_cel_shd.g_old_rec.position_id;
554: End If;
555: If (p_rec.organization_id = hr_api.g_number) then

Line 555: If (p_rec.organization_id = hr_api.g_number) then

551: If (p_rec.position_id = hr_api.g_number) then
552: p_rec.position_id :=
553: per_cel_shd.g_old_rec.position_id;
554: End If;
555: If (p_rec.organization_id = hr_api.g_number) then
556: p_rec.organization_id :=
557: per_cel_shd.g_old_rec.organization_id;
558: End If;
559: If (p_rec.parent_competence_element_id = hr_api.g_number) then

Line 559: If (p_rec.parent_competence_element_id = hr_api.g_number) then

555: If (p_rec.organization_id = hr_api.g_number) then
556: p_rec.organization_id :=
557: per_cel_shd.g_old_rec.organization_id;
558: End If;
559: If (p_rec.parent_competence_element_id = hr_api.g_number) then
560: p_rec.parent_competence_element_id :=
561: per_cel_shd.g_old_rec.parent_competence_element_id;
562: End If;
563: If (p_rec.activity_version_id = hr_api.g_number) then

Line 563: If (p_rec.activity_version_id = hr_api.g_number) then

559: If (p_rec.parent_competence_element_id = hr_api.g_number) then
560: p_rec.parent_competence_element_id :=
561: per_cel_shd.g_old_rec.parent_competence_element_id;
562: End If;
563: If (p_rec.activity_version_id = hr_api.g_number) then
564: p_rec.activity_version_id :=
565: per_cel_shd.g_old_rec.activity_version_id;
566: End If;
567: If (p_rec.assessment_id = hr_api.g_number) then

Line 567: If (p_rec.assessment_id = hr_api.g_number) then

563: If (p_rec.activity_version_id = hr_api.g_number) then
564: p_rec.activity_version_id :=
565: per_cel_shd.g_old_rec.activity_version_id;
566: End If;
567: If (p_rec.assessment_id = hr_api.g_number) then
568: p_rec.assessment_id :=
569: per_cel_shd.g_old_rec.assessment_id;
570: End If;
571: If (p_rec.assessment_type_id = hr_api.g_number) then

Line 571: If (p_rec.assessment_type_id = hr_api.g_number) then

567: If (p_rec.assessment_id = hr_api.g_number) then
568: p_rec.assessment_id :=
569: per_cel_shd.g_old_rec.assessment_id;
570: End If;
571: If (p_rec.assessment_type_id = hr_api.g_number) then
572: p_rec.assessment_type_id :=
573: per_cel_shd.g_old_rec.assessment_type_id;
574: End If;
575: If (p_rec.mandatory = hr_api.g_varchar2) then

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

571: If (p_rec.assessment_type_id = hr_api.g_number) then
572: p_rec.assessment_type_id :=
573: per_cel_shd.g_old_rec.assessment_type_id;
574: End If;
575: If (p_rec.mandatory = hr_api.g_varchar2) then
576: p_rec.mandatory :=
577: per_cel_shd.g_old_rec.mandatory;
578: End If;
579: If (p_rec.effective_date_from = hr_api.g_date) then

Line 579: If (p_rec.effective_date_from = hr_api.g_date) then

575: If (p_rec.mandatory = hr_api.g_varchar2) then
576: p_rec.mandatory :=
577: per_cel_shd.g_old_rec.mandatory;
578: End If;
579: If (p_rec.effective_date_from = hr_api.g_date) then
580: p_rec.effective_date_from :=
581: per_cel_shd.g_old_rec.effective_date_from;
582: End If;
583: If (p_rec.effective_date_to = hr_api.g_date) then

Line 583: If (p_rec.effective_date_to = hr_api.g_date) then

579: If (p_rec.effective_date_from = hr_api.g_date) then
580: p_rec.effective_date_from :=
581: per_cel_shd.g_old_rec.effective_date_from;
582: End If;
583: If (p_rec.effective_date_to = hr_api.g_date) then
584: p_rec.effective_date_to :=
585: per_cel_shd.g_old_rec.effective_date_to;
586: End If;
587: If (p_rec.group_competence_type = hr_api.g_varchar2) then

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

583: If (p_rec.effective_date_to = hr_api.g_date) then
584: p_rec.effective_date_to :=
585: per_cel_shd.g_old_rec.effective_date_to;
586: End If;
587: If (p_rec.group_competence_type = hr_api.g_varchar2) then
588: p_rec.group_competence_type :=
589: per_cel_shd.g_old_rec.group_competence_type;
590: End If;
591: If (p_rec.competence_type = hr_api.g_varchar2) then

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

587: If (p_rec.group_competence_type = hr_api.g_varchar2) then
588: p_rec.group_competence_type :=
589: per_cel_shd.g_old_rec.group_competence_type;
590: End If;
591: If (p_rec.competence_type = hr_api.g_varchar2) then
592: p_rec.competence_type :=
593: per_cel_shd.g_old_rec.competence_type;
594: End If;
595: If (p_rec.normal_elapse_duration = hr_api.g_number) then

Line 595: If (p_rec.normal_elapse_duration = hr_api.g_number) then

591: If (p_rec.competence_type = hr_api.g_varchar2) then
592: p_rec.competence_type :=
593: per_cel_shd.g_old_rec.competence_type;
594: End If;
595: If (p_rec.normal_elapse_duration = hr_api.g_number) then
596: p_rec.normal_elapse_duration :=
597: per_cel_shd.g_old_rec.normal_elapse_duration;
598: End If;
599: If (p_rec.normal_elapse_duration_unit = hr_api.g_varchar2) then

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

595: If (p_rec.normal_elapse_duration = hr_api.g_number) then
596: p_rec.normal_elapse_duration :=
597: per_cel_shd.g_old_rec.normal_elapse_duration;
598: End If;
599: If (p_rec.normal_elapse_duration_unit = hr_api.g_varchar2) then
600: p_rec.normal_elapse_duration_unit :=
601: per_cel_shd.g_old_rec.normal_elapse_duration_unit;
602: End If;
603: If (p_rec.sequence_number = hr_api.g_number) then

Line 603: If (p_rec.sequence_number = hr_api.g_number) then

599: If (p_rec.normal_elapse_duration_unit = hr_api.g_varchar2) then
600: p_rec.normal_elapse_duration_unit :=
601: per_cel_shd.g_old_rec.normal_elapse_duration_unit;
602: End If;
603: If (p_rec.sequence_number = hr_api.g_number) then
604: p_rec.sequence_number :=
605: per_cel_shd.g_old_rec.sequence_number;
606: End If;
607: If (p_rec.source_of_proficiency_level = hr_api.g_varchar2) then

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

603: If (p_rec.sequence_number = hr_api.g_number) then
604: p_rec.sequence_number :=
605: per_cel_shd.g_old_rec.sequence_number;
606: End If;
607: If (p_rec.source_of_proficiency_level = hr_api.g_varchar2) then
608: p_rec.source_of_proficiency_level :=
609: per_cel_shd.g_old_rec.source_of_proficiency_level;
610: End If;
611: If (p_rec.line_score = hr_api.g_number) then

Line 611: If (p_rec.line_score = hr_api.g_number) then

607: If (p_rec.source_of_proficiency_level = hr_api.g_varchar2) then
608: p_rec.source_of_proficiency_level :=
609: per_cel_shd.g_old_rec.source_of_proficiency_level;
610: End If;
611: If (p_rec.line_score = hr_api.g_number) then
612: p_rec.line_score :=
613: per_cel_shd.g_old_rec.line_score;
614: End If;
615: If (p_rec.certification_date = hr_api.g_date) then

Line 615: If (p_rec.certification_date = hr_api.g_date) then

611: If (p_rec.line_score = hr_api.g_number) then
612: p_rec.line_score :=
613: per_cel_shd.g_old_rec.line_score;
614: End If;
615: If (p_rec.certification_date = hr_api.g_date) then
616: p_rec.certification_date :=
617: per_cel_shd.g_old_rec.certification_date;
618: End If;
619: If (p_rec.certification_method = hr_api.g_varchar2) then

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

615: If (p_rec.certification_date = hr_api.g_date) then
616: p_rec.certification_date :=
617: per_cel_shd.g_old_rec.certification_date;
618: End If;
619: If (p_rec.certification_method = hr_api.g_varchar2) then
620: p_rec.certification_method :=
621: per_cel_shd.g_old_rec.certification_method;
622: End If;
623: If (p_rec.next_certification_date = hr_api.g_date) then

Line 623: If (p_rec.next_certification_date = hr_api.g_date) then

619: If (p_rec.certification_method = hr_api.g_varchar2) then
620: p_rec.certification_method :=
621: per_cel_shd.g_old_rec.certification_method;
622: End If;
623: If (p_rec.next_certification_date = hr_api.g_date) then
624: p_rec.next_certification_date :=
625: per_cel_shd.g_old_rec.next_certification_date;
626: End If;
627: If (p_rec.comments = hr_api.g_varchar2) then

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

623: If (p_rec.next_certification_date = hr_api.g_date) then
624: p_rec.next_certification_date :=
625: per_cel_shd.g_old_rec.next_certification_date;
626: End If;
627: If (p_rec.comments = hr_api.g_varchar2) then
628: p_rec.comments :=
629: per_cel_shd.g_old_rec.comments;
630: End If;
631: If (p_rec.attribute_category = hr_api.g_varchar2) then

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

627: If (p_rec.comments = hr_api.g_varchar2) then
628: p_rec.comments :=
629: per_cel_shd.g_old_rec.comments;
630: End If;
631: If (p_rec.attribute_category = hr_api.g_varchar2) then
632: p_rec.attribute_category :=
633: per_cel_shd.g_old_rec.attribute_category;
634: End If;
635: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

631: If (p_rec.attribute_category = hr_api.g_varchar2) then
632: p_rec.attribute_category :=
633: per_cel_shd.g_old_rec.attribute_category;
634: End If;
635: If (p_rec.attribute1 = hr_api.g_varchar2) then
636: p_rec.attribute1 :=
637: per_cel_shd.g_old_rec.attribute1;
638: End If;
639: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

635: If (p_rec.attribute1 = hr_api.g_varchar2) then
636: p_rec.attribute1 :=
637: per_cel_shd.g_old_rec.attribute1;
638: End If;
639: If (p_rec.attribute2 = hr_api.g_varchar2) then
640: p_rec.attribute2 :=
641: per_cel_shd.g_old_rec.attribute2;
642: End If;
643: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

639: If (p_rec.attribute2 = hr_api.g_varchar2) then
640: p_rec.attribute2 :=
641: per_cel_shd.g_old_rec.attribute2;
642: End If;
643: If (p_rec.attribute3 = hr_api.g_varchar2) then
644: p_rec.attribute3 :=
645: per_cel_shd.g_old_rec.attribute3;
646: End If;
647: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

643: If (p_rec.attribute3 = hr_api.g_varchar2) then
644: p_rec.attribute3 :=
645: per_cel_shd.g_old_rec.attribute3;
646: End If;
647: If (p_rec.attribute4 = hr_api.g_varchar2) then
648: p_rec.attribute4 :=
649: per_cel_shd.g_old_rec.attribute4;
650: End If;
651: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

647: If (p_rec.attribute4 = hr_api.g_varchar2) then
648: p_rec.attribute4 :=
649: per_cel_shd.g_old_rec.attribute4;
650: End If;
651: If (p_rec.attribute5 = hr_api.g_varchar2) then
652: p_rec.attribute5 :=
653: per_cel_shd.g_old_rec.attribute5;
654: End If;
655: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

651: If (p_rec.attribute5 = hr_api.g_varchar2) then
652: p_rec.attribute5 :=
653: per_cel_shd.g_old_rec.attribute5;
654: End If;
655: If (p_rec.attribute6 = hr_api.g_varchar2) then
656: p_rec.attribute6 :=
657: per_cel_shd.g_old_rec.attribute6;
658: End If;
659: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

655: If (p_rec.attribute6 = hr_api.g_varchar2) then
656: p_rec.attribute6 :=
657: per_cel_shd.g_old_rec.attribute6;
658: End If;
659: If (p_rec.attribute7 = hr_api.g_varchar2) then
660: p_rec.attribute7 :=
661: per_cel_shd.g_old_rec.attribute7;
662: End If;
663: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

659: If (p_rec.attribute7 = hr_api.g_varchar2) then
660: p_rec.attribute7 :=
661: per_cel_shd.g_old_rec.attribute7;
662: End If;
663: If (p_rec.attribute8 = hr_api.g_varchar2) then
664: p_rec.attribute8 :=
665: per_cel_shd.g_old_rec.attribute8;
666: End If;
667: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

663: If (p_rec.attribute8 = hr_api.g_varchar2) then
664: p_rec.attribute8 :=
665: per_cel_shd.g_old_rec.attribute8;
666: End If;
667: If (p_rec.attribute9 = hr_api.g_varchar2) then
668: p_rec.attribute9 :=
669: per_cel_shd.g_old_rec.attribute9;
670: End If;
671: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

667: If (p_rec.attribute9 = hr_api.g_varchar2) then
668: p_rec.attribute9 :=
669: per_cel_shd.g_old_rec.attribute9;
670: End If;
671: If (p_rec.attribute10 = hr_api.g_varchar2) then
672: p_rec.attribute10 :=
673: per_cel_shd.g_old_rec.attribute10;
674: End If;
675: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

671: If (p_rec.attribute10 = hr_api.g_varchar2) then
672: p_rec.attribute10 :=
673: per_cel_shd.g_old_rec.attribute10;
674: End If;
675: If (p_rec.attribute11 = hr_api.g_varchar2) then
676: p_rec.attribute11 :=
677: per_cel_shd.g_old_rec.attribute11;
678: End If;
679: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

675: If (p_rec.attribute11 = hr_api.g_varchar2) then
676: p_rec.attribute11 :=
677: per_cel_shd.g_old_rec.attribute11;
678: End If;
679: If (p_rec.attribute12 = hr_api.g_varchar2) then
680: p_rec.attribute12 :=
681: per_cel_shd.g_old_rec.attribute12;
682: End If;
683: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

679: If (p_rec.attribute12 = hr_api.g_varchar2) then
680: p_rec.attribute12 :=
681: per_cel_shd.g_old_rec.attribute12;
682: End If;
683: If (p_rec.attribute13 = hr_api.g_varchar2) then
684: p_rec.attribute13 :=
685: per_cel_shd.g_old_rec.attribute13;
686: End If;
687: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

683: If (p_rec.attribute13 = hr_api.g_varchar2) then
684: p_rec.attribute13 :=
685: per_cel_shd.g_old_rec.attribute13;
686: End If;
687: If (p_rec.attribute14 = hr_api.g_varchar2) then
688: p_rec.attribute14 :=
689: per_cel_shd.g_old_rec.attribute14;
690: End If;
691: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

687: If (p_rec.attribute14 = hr_api.g_varchar2) then
688: p_rec.attribute14 :=
689: per_cel_shd.g_old_rec.attribute14;
690: End If;
691: If (p_rec.attribute15 = hr_api.g_varchar2) then
692: p_rec.attribute15 :=
693: per_cel_shd.g_old_rec.attribute15;
694: End If;
695: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

691: If (p_rec.attribute15 = hr_api.g_varchar2) then
692: p_rec.attribute15 :=
693: per_cel_shd.g_old_rec.attribute15;
694: End If;
695: If (p_rec.attribute16 = hr_api.g_varchar2) then
696: p_rec.attribute16 :=
697: per_cel_shd.g_old_rec.attribute16;
698: End If;
699: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

695: If (p_rec.attribute16 = hr_api.g_varchar2) then
696: p_rec.attribute16 :=
697: per_cel_shd.g_old_rec.attribute16;
698: End If;
699: If (p_rec.attribute17 = hr_api.g_varchar2) then
700: p_rec.attribute17 :=
701: per_cel_shd.g_old_rec.attribute17;
702: End If;
703: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

699: If (p_rec.attribute17 = hr_api.g_varchar2) then
700: p_rec.attribute17 :=
701: per_cel_shd.g_old_rec.attribute17;
702: End If;
703: If (p_rec.attribute18 = hr_api.g_varchar2) then
704: p_rec.attribute18 :=
705: per_cel_shd.g_old_rec.attribute18;
706: End If;
707: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

703: If (p_rec.attribute18 = hr_api.g_varchar2) then
704: p_rec.attribute18 :=
705: per_cel_shd.g_old_rec.attribute18;
706: End If;
707: If (p_rec.attribute19 = hr_api.g_varchar2) then
708: p_rec.attribute19 :=
709: per_cel_shd.g_old_rec.attribute19;
710: End If;
711: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

707: If (p_rec.attribute19 = hr_api.g_varchar2) then
708: p_rec.attribute19 :=
709: per_cel_shd.g_old_rec.attribute19;
710: End If;
711: If (p_rec.attribute20 = hr_api.g_varchar2) then
712: p_rec.attribute20 :=
713: per_cel_shd.g_old_rec.attribute20;
714: End If;
715: if (p_rec.object_id = hr_api.g_number) then

Line 715: if (p_rec.object_id = hr_api.g_number) then

711: If (p_rec.attribute20 = hr_api.g_varchar2) then
712: p_rec.attribute20 :=
713: per_cel_shd.g_old_rec.attribute20;
714: End If;
715: if (p_rec.object_id = hr_api.g_number) then
716: p_rec.object_id :=
717: per_cel_shd.g_old_rec.object_id;
718: End If;
719:

Line 720: If (p_rec.object_name = hr_api.g_varchar2) then

716: p_rec.object_id :=
717: per_cel_shd.g_old_rec.object_id;
718: End If;
719:
720: If (p_rec.object_name = hr_api.g_varchar2) then
721: p_rec.object_name :=
722: per_cel_shd.g_old_rec.object_name;
723: End if;
724: -- ngundura added last two if conditions for object_id and name

Line 725: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge

721: p_rec.object_name :=
722: per_cel_shd.g_old_rec.object_name;
723: End if;
724: -- ngundura added last two if conditions for object_id and name
725: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
726: p_rec.party_id :=
727: per_cel_shd.g_old_rec.party_id;
728: End If;
729: If (p_rec.qualification_type_id = hr_api.g_number) then

Line 729: If (p_rec.qualification_type_id = hr_api.g_number) then

725: If (p_rec.party_id = hr_api.g_number) then -- HR/TCA merge
726: p_rec.party_id :=
727: per_cel_shd.g_old_rec.party_id;
728: End If;
729: If (p_rec.qualification_type_id = hr_api.g_number) then
730: p_rec.qualification_type_id :=
731: per_cel_shd.g_old_rec.qualification_type_id;
732: End If;
733: If (p_rec.unit_standard_type = hr_api.g_varchar2) then

Line 733: If (p_rec.unit_standard_type = hr_api.g_varchar2) then

729: If (p_rec.qualification_type_id = hr_api.g_number) then
730: p_rec.qualification_type_id :=
731: per_cel_shd.g_old_rec.qualification_type_id;
732: End If;
733: If (p_rec.unit_standard_type = hr_api.g_varchar2) then
734: p_rec.unit_standard_type :=
735: per_cel_shd.g_old_rec.unit_standard_type;
736: End If;
737: If (p_rec.status = hr_api.g_varchar2) then

Line 737: If (p_rec.status = hr_api.g_varchar2) then

733: If (p_rec.unit_standard_type = hr_api.g_varchar2) then
734: p_rec.unit_standard_type :=
735: per_cel_shd.g_old_rec.unit_standard_type;
736: End If;
737: If (p_rec.status = hr_api.g_varchar2) then
738: p_rec.status :=
739: per_cel_shd.g_old_rec.status;
740: End If;
741: If (p_rec.information_category = hr_api.g_varchar2) then

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

737: If (p_rec.status = hr_api.g_varchar2) then
738: p_rec.status :=
739: per_cel_shd.g_old_rec.status;
740: End If;
741: If (p_rec.information_category = hr_api.g_varchar2) then
742: p_rec.information_category :=
743: per_cel_shd.g_old_rec.information_category;
744: End If;
745: If (p_rec.information1 = hr_api.g_varchar2) then

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

741: If (p_rec.information_category = hr_api.g_varchar2) then
742: p_rec.information_category :=
743: per_cel_shd.g_old_rec.information_category;
744: End If;
745: If (p_rec.information1 = hr_api.g_varchar2) then
746: p_rec.information1 :=
747: per_cel_shd.g_old_rec.information1;
748: End If;
749: If (p_rec.information2 = hr_api.g_varchar2) then

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

745: If (p_rec.information1 = hr_api.g_varchar2) then
746: p_rec.information1 :=
747: per_cel_shd.g_old_rec.information1;
748: End If;
749: If (p_rec.information2 = hr_api.g_varchar2) then
750: p_rec.information2 :=
751: per_cel_shd.g_old_rec.information2;
752: End If;
753: If (p_rec.information3 = hr_api.g_varchar2) then

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

749: If (p_rec.information2 = hr_api.g_varchar2) then
750: p_rec.information2 :=
751: per_cel_shd.g_old_rec.information2;
752: End If;
753: If (p_rec.information3 = hr_api.g_varchar2) then
754: p_rec.information3 :=
755: per_cel_shd.g_old_rec.information3;
756: End If;
757: If (p_rec.information4 = hr_api.g_varchar2) then

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

753: If (p_rec.information3 = hr_api.g_varchar2) then
754: p_rec.information3 :=
755: per_cel_shd.g_old_rec.information3;
756: End If;
757: If (p_rec.information4 = hr_api.g_varchar2) then
758: p_rec.information4 :=
759: per_cel_shd.g_old_rec.information4;
760: End If;
761: If (p_rec.information5 = hr_api.g_varchar2) then

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

757: If (p_rec.information4 = hr_api.g_varchar2) then
758: p_rec.information4 :=
759: per_cel_shd.g_old_rec.information4;
760: End If;
761: If (p_rec.information5 = hr_api.g_varchar2) then
762: p_rec.information5 :=
763: per_cel_shd.g_old_rec.information5;
764: End If;
765: If (p_rec.information6 = hr_api.g_varchar2) then

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

761: If (p_rec.information5 = hr_api.g_varchar2) then
762: p_rec.information5 :=
763: per_cel_shd.g_old_rec.information5;
764: End If;
765: If (p_rec.information6 = hr_api.g_varchar2) then
766: p_rec.information6 :=
767: per_cel_shd.g_old_rec.information6;
768: End If;
769: If (p_rec.information7 = hr_api.g_varchar2) then

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

765: If (p_rec.information6 = hr_api.g_varchar2) then
766: p_rec.information6 :=
767: per_cel_shd.g_old_rec.information6;
768: End If;
769: If (p_rec.information7 = hr_api.g_varchar2) then
770: p_rec.information7 :=
771: per_cel_shd.g_old_rec.information7;
772: End If;
773: If (p_rec.information8 = hr_api.g_varchar2) then

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

769: If (p_rec.information7 = hr_api.g_varchar2) then
770: p_rec.information7 :=
771: per_cel_shd.g_old_rec.information7;
772: End If;
773: If (p_rec.information8 = hr_api.g_varchar2) then
774: p_rec.information8 :=
775: per_cel_shd.g_old_rec.information8;
776: End If;
777: If (p_rec.information9 = hr_api.g_varchar2) then

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

773: If (p_rec.information8 = hr_api.g_varchar2) then
774: p_rec.information8 :=
775: per_cel_shd.g_old_rec.information8;
776: End If;
777: If (p_rec.information9 = hr_api.g_varchar2) then
778: p_rec.information9 :=
779: per_cel_shd.g_old_rec.information9;
780: End If;
781: If (p_rec.information10 = hr_api.g_varchar2) then

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

777: If (p_rec.information9 = hr_api.g_varchar2) then
778: p_rec.information9 :=
779: per_cel_shd.g_old_rec.information9;
780: End If;
781: If (p_rec.information10 = hr_api.g_varchar2) then
782: p_rec.information10 :=
783: per_cel_shd.g_old_rec.information10;
784: End If;
785: If (p_rec.information11 = hr_api.g_varchar2) then

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

781: If (p_rec.information10 = hr_api.g_varchar2) then
782: p_rec.information10 :=
783: per_cel_shd.g_old_rec.information10;
784: End If;
785: If (p_rec.information11 = hr_api.g_varchar2) then
786: p_rec.information11 :=
787: per_cel_shd.g_old_rec.information11;
788: End If;
789: If (p_rec.information12 = hr_api.g_varchar2) then

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

785: If (p_rec.information11 = hr_api.g_varchar2) then
786: p_rec.information11 :=
787: per_cel_shd.g_old_rec.information11;
788: End If;
789: If (p_rec.information12 = hr_api.g_varchar2) then
790: p_rec.information12 :=
791: per_cel_shd.g_old_rec.information12;
792: End If;
793: If (p_rec.information13 = hr_api.g_varchar2) then

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

789: If (p_rec.information12 = hr_api.g_varchar2) then
790: p_rec.information12 :=
791: per_cel_shd.g_old_rec.information12;
792: End If;
793: If (p_rec.information13 = hr_api.g_varchar2) then
794: p_rec.information13 :=
795: per_cel_shd.g_old_rec.information13;
796: End If;
797: If (p_rec.information14 = hr_api.g_varchar2) then

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

793: If (p_rec.information13 = hr_api.g_varchar2) then
794: p_rec.information13 :=
795: per_cel_shd.g_old_rec.information13;
796: End If;
797: If (p_rec.information14 = hr_api.g_varchar2) then
798: p_rec.information14 :=
799: per_cel_shd.g_old_rec.information14;
800: End If;
801: If (p_rec.information15 = hr_api.g_varchar2) then

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

797: If (p_rec.information14 = hr_api.g_varchar2) then
798: p_rec.information14 :=
799: per_cel_shd.g_old_rec.information14;
800: End If;
801: If (p_rec.information15 = hr_api.g_varchar2) then
802: p_rec.information15 :=
803: per_cel_shd.g_old_rec.information15;
804: End If;
805: If (p_rec.information16 = hr_api.g_varchar2) then

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

801: If (p_rec.information15 = hr_api.g_varchar2) then
802: p_rec.information15 :=
803: per_cel_shd.g_old_rec.information15;
804: End If;
805: If (p_rec.information16 = hr_api.g_varchar2) then
806: p_rec.information16 :=
807: per_cel_shd.g_old_rec.information16;
808: End If;
809: If (p_rec.information17 = hr_api.g_varchar2) then

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

805: If (p_rec.information16 = hr_api.g_varchar2) then
806: p_rec.information16 :=
807: per_cel_shd.g_old_rec.information16;
808: End If;
809: If (p_rec.information17 = hr_api.g_varchar2) then
810: p_rec.information17 :=
811: per_cel_shd.g_old_rec.information17;
812: End If;
813: If (p_rec.information18 = hr_api.g_varchar2) then

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

809: If (p_rec.information17 = hr_api.g_varchar2) then
810: p_rec.information17 :=
811: per_cel_shd.g_old_rec.information17;
812: End If;
813: If (p_rec.information18 = hr_api.g_varchar2) then
814: p_rec.information18 :=
815: per_cel_shd.g_old_rec.information18;
816: End If;
817: If (p_rec.information19 = hr_api.g_varchar2) then

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

813: If (p_rec.information18 = hr_api.g_varchar2) then
814: p_rec.information18 :=
815: per_cel_shd.g_old_rec.information18;
816: End If;
817: If (p_rec.information19 = hr_api.g_varchar2) then
818: p_rec.information19 :=
819: per_cel_shd.g_old_rec.information19;
820: End If;
821: If (p_rec.information20 = hr_api.g_varchar2) then

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

817: If (p_rec.information19 = hr_api.g_varchar2) then
818: p_rec.information19 :=
819: per_cel_shd.g_old_rec.information19;
820: End If;
821: If (p_rec.information20 = hr_api.g_varchar2) then
822: p_rec.information20 :=
823: per_cel_shd.g_old_rec.information20;
824: End If;
825: If (p_rec.achieved_date = hr_api.g_date) then

Line 825: If (p_rec.achieved_date = hr_api.g_date) then

821: If (p_rec.information20 = hr_api.g_varchar2) then
822: p_rec.information20 :=
823: per_cel_shd.g_old_rec.information20;
824: End If;
825: If (p_rec.achieved_date = hr_api.g_date) then
826: p_rec.achieved_date :=
827: per_cel_shd.g_old_rec.achieved_date;
828: End If;
829: If (p_rec.appr_line_score = hr_api.g_number) then

Line 829: If (p_rec.appr_line_score = hr_api.g_number) then

825: If (p_rec.achieved_date = hr_api.g_date) then
826: p_rec.achieved_date :=
827: per_cel_shd.g_old_rec.achieved_date;
828: End If;
829: If (p_rec.appr_line_score = hr_api.g_number) then
830: p_rec.appr_line_score :=
831: per_cel_shd.g_old_rec.appr_line_score;
832: End If;
833: --

Line 901: Raise HR_Api.Validate_Enabled;

897: --
898: -- If we are validating then raise the Validate_Enabled exception
899: --
900: If p_validate then
901: Raise HR_Api.Validate_Enabled;
902: End If;
903: --
904: hr_utility.set_location(' Leaving:'||l_proc, 10);
905: Exception

Line 906: When HR_Api.Validate_Enabled Then

902: End If;
903: --
904: hr_utility.set_location(' Leaving:'||l_proc, 10);
905: Exception
906: When HR_Api.Validate_Enabled Then
907: --
908: -- As the Validate_Enabled exception has been raised
909: -- we must rollback to the savepoint
910: --

Line 921: p_proficiency_level_id in number default hr_api.g_number,

917: Procedure upd
918: (
919: p_competence_element_id in number,
920: p_object_version_number in out nocopy number,
921: p_proficiency_level_id in number default hr_api.g_number,
922: p_high_proficiency_level_id in number default hr_api.g_number,
923: p_weighting_level_id in number default hr_api.g_number,
924: p_rating_level_id in number default hr_api.g_number,
925: p_mandatory in varchar2 default hr_api.g_varchar2,

Line 922: p_high_proficiency_level_id in number default hr_api.g_number,

918: (
919: p_competence_element_id in number,
920: p_object_version_number in out nocopy number,
921: p_proficiency_level_id in number default hr_api.g_number,
922: p_high_proficiency_level_id in number default hr_api.g_number,
923: p_weighting_level_id in number default hr_api.g_number,
924: p_rating_level_id in number default hr_api.g_number,
925: p_mandatory in varchar2 default hr_api.g_varchar2,
926: p_effective_date_from in date default hr_api.g_date,

Line 923: p_weighting_level_id in number default hr_api.g_number,

919: p_competence_element_id in number,
920: p_object_version_number in out nocopy number,
921: p_proficiency_level_id in number default hr_api.g_number,
922: p_high_proficiency_level_id in number default hr_api.g_number,
923: p_weighting_level_id in number default hr_api.g_number,
924: p_rating_level_id in number default hr_api.g_number,
925: p_mandatory in varchar2 default hr_api.g_varchar2,
926: p_effective_date_from in date default hr_api.g_date,
927: p_effective_date_to in date default hr_api.g_date,

Line 924: p_rating_level_id in number default hr_api.g_number,

920: p_object_version_number in out nocopy number,
921: p_proficiency_level_id in number default hr_api.g_number,
922: p_high_proficiency_level_id in number default hr_api.g_number,
923: p_weighting_level_id in number default hr_api.g_number,
924: p_rating_level_id in number default hr_api.g_number,
925: p_mandatory in varchar2 default hr_api.g_varchar2,
926: p_effective_date_from in date default hr_api.g_date,
927: p_effective_date_to in date default hr_api.g_date,
928: p_group_competence_type in varchar2 default hr_api.g_varchar2,

Line 925: p_mandatory in varchar2 default hr_api.g_varchar2,

921: p_proficiency_level_id in number default hr_api.g_number,
922: p_high_proficiency_level_id in number default hr_api.g_number,
923: p_weighting_level_id in number default hr_api.g_number,
924: p_rating_level_id in number default hr_api.g_number,
925: p_mandatory in varchar2 default hr_api.g_varchar2,
926: p_effective_date_from in date default hr_api.g_date,
927: p_effective_date_to in date default hr_api.g_date,
928: p_group_competence_type in varchar2 default hr_api.g_varchar2,
929: p_competence_type in varchar2 default hr_api.g_varchar2,

Line 926: p_effective_date_from in date default hr_api.g_date,

922: p_high_proficiency_level_id in number default hr_api.g_number,
923: p_weighting_level_id in number default hr_api.g_number,
924: p_rating_level_id in number default hr_api.g_number,
925: p_mandatory in varchar2 default hr_api.g_varchar2,
926: p_effective_date_from in date default hr_api.g_date,
927: p_effective_date_to in date default hr_api.g_date,
928: p_group_competence_type in varchar2 default hr_api.g_varchar2,
929: p_competence_type in varchar2 default hr_api.g_varchar2,
930: p_normal_elapse_duration in number default hr_api.g_number,

Line 927: p_effective_date_to in date default hr_api.g_date,

923: p_weighting_level_id in number default hr_api.g_number,
924: p_rating_level_id in number default hr_api.g_number,
925: p_mandatory in varchar2 default hr_api.g_varchar2,
926: p_effective_date_from in date default hr_api.g_date,
927: p_effective_date_to in date default hr_api.g_date,
928: p_group_competence_type in varchar2 default hr_api.g_varchar2,
929: p_competence_type in varchar2 default hr_api.g_varchar2,
930: p_normal_elapse_duration in number default hr_api.g_number,
931: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,

Line 928: p_group_competence_type in varchar2 default hr_api.g_varchar2,

924: p_rating_level_id in number default hr_api.g_number,
925: p_mandatory in varchar2 default hr_api.g_varchar2,
926: p_effective_date_from in date default hr_api.g_date,
927: p_effective_date_to in date default hr_api.g_date,
928: p_group_competence_type in varchar2 default hr_api.g_varchar2,
929: p_competence_type in varchar2 default hr_api.g_varchar2,
930: p_normal_elapse_duration in number default hr_api.g_number,
931: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
932: p_sequence_number in number default hr_api.g_number,

Line 929: p_competence_type in varchar2 default hr_api.g_varchar2,

925: p_mandatory in varchar2 default hr_api.g_varchar2,
926: p_effective_date_from in date default hr_api.g_date,
927: p_effective_date_to in date default hr_api.g_date,
928: p_group_competence_type in varchar2 default hr_api.g_varchar2,
929: p_competence_type in varchar2 default hr_api.g_varchar2,
930: p_normal_elapse_duration in number default hr_api.g_number,
931: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
932: p_sequence_number in number default hr_api.g_number,
933: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,

Line 930: p_normal_elapse_duration in number default hr_api.g_number,

926: p_effective_date_from in date default hr_api.g_date,
927: p_effective_date_to in date default hr_api.g_date,
928: p_group_competence_type in varchar2 default hr_api.g_varchar2,
929: p_competence_type in varchar2 default hr_api.g_varchar2,
930: p_normal_elapse_duration in number default hr_api.g_number,
931: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
932: p_sequence_number in number default hr_api.g_number,
933: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
934: p_line_score in number default hr_api.g_number,

Line 931: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,

927: p_effective_date_to in date default hr_api.g_date,
928: p_group_competence_type in varchar2 default hr_api.g_varchar2,
929: p_competence_type in varchar2 default hr_api.g_varchar2,
930: p_normal_elapse_duration in number default hr_api.g_number,
931: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
932: p_sequence_number in number default hr_api.g_number,
933: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
934: p_line_score in number default hr_api.g_number,
935: p_certification_date in date default hr_api.g_date,

Line 932: p_sequence_number in number default hr_api.g_number,

928: p_group_competence_type in varchar2 default hr_api.g_varchar2,
929: p_competence_type in varchar2 default hr_api.g_varchar2,
930: p_normal_elapse_duration in number default hr_api.g_number,
931: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
932: p_sequence_number in number default hr_api.g_number,
933: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
934: p_line_score in number default hr_api.g_number,
935: p_certification_date in date default hr_api.g_date,
936: p_certification_method in varchar2 default hr_api.g_varchar2,

Line 933: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,

929: p_competence_type in varchar2 default hr_api.g_varchar2,
930: p_normal_elapse_duration in number default hr_api.g_number,
931: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
932: p_sequence_number in number default hr_api.g_number,
933: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
934: p_line_score in number default hr_api.g_number,
935: p_certification_date in date default hr_api.g_date,
936: p_certification_method in varchar2 default hr_api.g_varchar2,
937: p_next_certification_date in date default hr_api.g_date,

Line 934: p_line_score in number default hr_api.g_number,

930: p_normal_elapse_duration in number default hr_api.g_number,
931: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
932: p_sequence_number in number default hr_api.g_number,
933: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
934: p_line_score in number default hr_api.g_number,
935: p_certification_date in date default hr_api.g_date,
936: p_certification_method in varchar2 default hr_api.g_varchar2,
937: p_next_certification_date in date default hr_api.g_date,
938: p_comments in varchar2 default hr_api.g_varchar2,

Line 935: p_certification_date in date default hr_api.g_date,

931: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
932: p_sequence_number in number default hr_api.g_number,
933: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
934: p_line_score in number default hr_api.g_number,
935: p_certification_date in date default hr_api.g_date,
936: p_certification_method in varchar2 default hr_api.g_varchar2,
937: p_next_certification_date in date default hr_api.g_date,
938: p_comments in varchar2 default hr_api.g_varchar2,
939: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 936: p_certification_method in varchar2 default hr_api.g_varchar2,

932: p_sequence_number in number default hr_api.g_number,
933: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
934: p_line_score in number default hr_api.g_number,
935: p_certification_date in date default hr_api.g_date,
936: p_certification_method in varchar2 default hr_api.g_varchar2,
937: p_next_certification_date in date default hr_api.g_date,
938: p_comments in varchar2 default hr_api.g_varchar2,
939: p_attribute_category in varchar2 default hr_api.g_varchar2,
940: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 937: p_next_certification_date in date default hr_api.g_date,

933: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
934: p_line_score in number default hr_api.g_number,
935: p_certification_date in date default hr_api.g_date,
936: p_certification_method in varchar2 default hr_api.g_varchar2,
937: p_next_certification_date in date default hr_api.g_date,
938: p_comments in varchar2 default hr_api.g_varchar2,
939: p_attribute_category in varchar2 default hr_api.g_varchar2,
940: p_attribute1 in varchar2 default hr_api.g_varchar2,
941: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 938: p_comments in varchar2 default hr_api.g_varchar2,

934: p_line_score in number default hr_api.g_number,
935: p_certification_date in date default hr_api.g_date,
936: p_certification_method in varchar2 default hr_api.g_varchar2,
937: p_next_certification_date in date default hr_api.g_date,
938: p_comments in varchar2 default hr_api.g_varchar2,
939: p_attribute_category in varchar2 default hr_api.g_varchar2,
940: p_attribute1 in varchar2 default hr_api.g_varchar2,
941: p_attribute2 in varchar2 default hr_api.g_varchar2,
942: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 939: p_attribute_category in varchar2 default hr_api.g_varchar2,

935: p_certification_date in date default hr_api.g_date,
936: p_certification_method in varchar2 default hr_api.g_varchar2,
937: p_next_certification_date in date default hr_api.g_date,
938: p_comments in varchar2 default hr_api.g_varchar2,
939: p_attribute_category in varchar2 default hr_api.g_varchar2,
940: p_attribute1 in varchar2 default hr_api.g_varchar2,
941: p_attribute2 in varchar2 default hr_api.g_varchar2,
942: p_attribute3 in varchar2 default hr_api.g_varchar2,
943: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 940: p_attribute1 in varchar2 default hr_api.g_varchar2,

936: p_certification_method in varchar2 default hr_api.g_varchar2,
937: p_next_certification_date in date default hr_api.g_date,
938: p_comments in varchar2 default hr_api.g_varchar2,
939: p_attribute_category in varchar2 default hr_api.g_varchar2,
940: p_attribute1 in varchar2 default hr_api.g_varchar2,
941: p_attribute2 in varchar2 default hr_api.g_varchar2,
942: p_attribute3 in varchar2 default hr_api.g_varchar2,
943: p_attribute4 in varchar2 default hr_api.g_varchar2,
944: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 941: p_attribute2 in varchar2 default hr_api.g_varchar2,

937: p_next_certification_date in date default hr_api.g_date,
938: p_comments in varchar2 default hr_api.g_varchar2,
939: p_attribute_category in varchar2 default hr_api.g_varchar2,
940: p_attribute1 in varchar2 default hr_api.g_varchar2,
941: p_attribute2 in varchar2 default hr_api.g_varchar2,
942: p_attribute3 in varchar2 default hr_api.g_varchar2,
943: p_attribute4 in varchar2 default hr_api.g_varchar2,
944: p_attribute5 in varchar2 default hr_api.g_varchar2,
945: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 942: p_attribute3 in varchar2 default hr_api.g_varchar2,

938: p_comments in varchar2 default hr_api.g_varchar2,
939: p_attribute_category in varchar2 default hr_api.g_varchar2,
940: p_attribute1 in varchar2 default hr_api.g_varchar2,
941: p_attribute2 in varchar2 default hr_api.g_varchar2,
942: p_attribute3 in varchar2 default hr_api.g_varchar2,
943: p_attribute4 in varchar2 default hr_api.g_varchar2,
944: p_attribute5 in varchar2 default hr_api.g_varchar2,
945: p_attribute6 in varchar2 default hr_api.g_varchar2,
946: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 943: p_attribute4 in varchar2 default hr_api.g_varchar2,

939: p_attribute_category in varchar2 default hr_api.g_varchar2,
940: p_attribute1 in varchar2 default hr_api.g_varchar2,
941: p_attribute2 in varchar2 default hr_api.g_varchar2,
942: p_attribute3 in varchar2 default hr_api.g_varchar2,
943: p_attribute4 in varchar2 default hr_api.g_varchar2,
944: p_attribute5 in varchar2 default hr_api.g_varchar2,
945: p_attribute6 in varchar2 default hr_api.g_varchar2,
946: p_attribute7 in varchar2 default hr_api.g_varchar2,
947: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 944: p_attribute5 in varchar2 default hr_api.g_varchar2,

940: p_attribute1 in varchar2 default hr_api.g_varchar2,
941: p_attribute2 in varchar2 default hr_api.g_varchar2,
942: p_attribute3 in varchar2 default hr_api.g_varchar2,
943: p_attribute4 in varchar2 default hr_api.g_varchar2,
944: p_attribute5 in varchar2 default hr_api.g_varchar2,
945: p_attribute6 in varchar2 default hr_api.g_varchar2,
946: p_attribute7 in varchar2 default hr_api.g_varchar2,
947: p_attribute8 in varchar2 default hr_api.g_varchar2,
948: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 945: p_attribute6 in varchar2 default hr_api.g_varchar2,

941: p_attribute2 in varchar2 default hr_api.g_varchar2,
942: p_attribute3 in varchar2 default hr_api.g_varchar2,
943: p_attribute4 in varchar2 default hr_api.g_varchar2,
944: p_attribute5 in varchar2 default hr_api.g_varchar2,
945: p_attribute6 in varchar2 default hr_api.g_varchar2,
946: p_attribute7 in varchar2 default hr_api.g_varchar2,
947: p_attribute8 in varchar2 default hr_api.g_varchar2,
948: p_attribute9 in varchar2 default hr_api.g_varchar2,
949: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 946: p_attribute7 in varchar2 default hr_api.g_varchar2,

942: p_attribute3 in varchar2 default hr_api.g_varchar2,
943: p_attribute4 in varchar2 default hr_api.g_varchar2,
944: p_attribute5 in varchar2 default hr_api.g_varchar2,
945: p_attribute6 in varchar2 default hr_api.g_varchar2,
946: p_attribute7 in varchar2 default hr_api.g_varchar2,
947: p_attribute8 in varchar2 default hr_api.g_varchar2,
948: p_attribute9 in varchar2 default hr_api.g_varchar2,
949: p_attribute10 in varchar2 default hr_api.g_varchar2,
950: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 947: p_attribute8 in varchar2 default hr_api.g_varchar2,

943: p_attribute4 in varchar2 default hr_api.g_varchar2,
944: p_attribute5 in varchar2 default hr_api.g_varchar2,
945: p_attribute6 in varchar2 default hr_api.g_varchar2,
946: p_attribute7 in varchar2 default hr_api.g_varchar2,
947: p_attribute8 in varchar2 default hr_api.g_varchar2,
948: p_attribute9 in varchar2 default hr_api.g_varchar2,
949: p_attribute10 in varchar2 default hr_api.g_varchar2,
950: p_attribute11 in varchar2 default hr_api.g_varchar2,
951: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 948: p_attribute9 in varchar2 default hr_api.g_varchar2,

944: p_attribute5 in varchar2 default hr_api.g_varchar2,
945: p_attribute6 in varchar2 default hr_api.g_varchar2,
946: p_attribute7 in varchar2 default hr_api.g_varchar2,
947: p_attribute8 in varchar2 default hr_api.g_varchar2,
948: p_attribute9 in varchar2 default hr_api.g_varchar2,
949: p_attribute10 in varchar2 default hr_api.g_varchar2,
950: p_attribute11 in varchar2 default hr_api.g_varchar2,
951: p_attribute12 in varchar2 default hr_api.g_varchar2,
952: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 949: p_attribute10 in varchar2 default hr_api.g_varchar2,

945: p_attribute6 in varchar2 default hr_api.g_varchar2,
946: p_attribute7 in varchar2 default hr_api.g_varchar2,
947: p_attribute8 in varchar2 default hr_api.g_varchar2,
948: p_attribute9 in varchar2 default hr_api.g_varchar2,
949: p_attribute10 in varchar2 default hr_api.g_varchar2,
950: p_attribute11 in varchar2 default hr_api.g_varchar2,
951: p_attribute12 in varchar2 default hr_api.g_varchar2,
952: p_attribute13 in varchar2 default hr_api.g_varchar2,
953: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 950: p_attribute11 in varchar2 default hr_api.g_varchar2,

946: p_attribute7 in varchar2 default hr_api.g_varchar2,
947: p_attribute8 in varchar2 default hr_api.g_varchar2,
948: p_attribute9 in varchar2 default hr_api.g_varchar2,
949: p_attribute10 in varchar2 default hr_api.g_varchar2,
950: p_attribute11 in varchar2 default hr_api.g_varchar2,
951: p_attribute12 in varchar2 default hr_api.g_varchar2,
952: p_attribute13 in varchar2 default hr_api.g_varchar2,
953: p_attribute14 in varchar2 default hr_api.g_varchar2,
954: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 951: p_attribute12 in varchar2 default hr_api.g_varchar2,

947: p_attribute8 in varchar2 default hr_api.g_varchar2,
948: p_attribute9 in varchar2 default hr_api.g_varchar2,
949: p_attribute10 in varchar2 default hr_api.g_varchar2,
950: p_attribute11 in varchar2 default hr_api.g_varchar2,
951: p_attribute12 in varchar2 default hr_api.g_varchar2,
952: p_attribute13 in varchar2 default hr_api.g_varchar2,
953: p_attribute14 in varchar2 default hr_api.g_varchar2,
954: p_attribute15 in varchar2 default hr_api.g_varchar2,
955: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 952: p_attribute13 in varchar2 default hr_api.g_varchar2,

948: p_attribute9 in varchar2 default hr_api.g_varchar2,
949: p_attribute10 in varchar2 default hr_api.g_varchar2,
950: p_attribute11 in varchar2 default hr_api.g_varchar2,
951: p_attribute12 in varchar2 default hr_api.g_varchar2,
952: p_attribute13 in varchar2 default hr_api.g_varchar2,
953: p_attribute14 in varchar2 default hr_api.g_varchar2,
954: p_attribute15 in varchar2 default hr_api.g_varchar2,
955: p_attribute16 in varchar2 default hr_api.g_varchar2,
956: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 953: p_attribute14 in varchar2 default hr_api.g_varchar2,

949: p_attribute10 in varchar2 default hr_api.g_varchar2,
950: p_attribute11 in varchar2 default hr_api.g_varchar2,
951: p_attribute12 in varchar2 default hr_api.g_varchar2,
952: p_attribute13 in varchar2 default hr_api.g_varchar2,
953: p_attribute14 in varchar2 default hr_api.g_varchar2,
954: p_attribute15 in varchar2 default hr_api.g_varchar2,
955: p_attribute16 in varchar2 default hr_api.g_varchar2,
956: p_attribute17 in varchar2 default hr_api.g_varchar2,
957: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 954: p_attribute15 in varchar2 default hr_api.g_varchar2,

950: p_attribute11 in varchar2 default hr_api.g_varchar2,
951: p_attribute12 in varchar2 default hr_api.g_varchar2,
952: p_attribute13 in varchar2 default hr_api.g_varchar2,
953: p_attribute14 in varchar2 default hr_api.g_varchar2,
954: p_attribute15 in varchar2 default hr_api.g_varchar2,
955: p_attribute16 in varchar2 default hr_api.g_varchar2,
956: p_attribute17 in varchar2 default hr_api.g_varchar2,
957: p_attribute18 in varchar2 default hr_api.g_varchar2,
958: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 955: p_attribute16 in varchar2 default hr_api.g_varchar2,

951: p_attribute12 in varchar2 default hr_api.g_varchar2,
952: p_attribute13 in varchar2 default hr_api.g_varchar2,
953: p_attribute14 in varchar2 default hr_api.g_varchar2,
954: p_attribute15 in varchar2 default hr_api.g_varchar2,
955: p_attribute16 in varchar2 default hr_api.g_varchar2,
956: p_attribute17 in varchar2 default hr_api.g_varchar2,
957: p_attribute18 in varchar2 default hr_api.g_varchar2,
958: p_attribute19 in varchar2 default hr_api.g_varchar2,
959: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 956: p_attribute17 in varchar2 default hr_api.g_varchar2,

952: p_attribute13 in varchar2 default hr_api.g_varchar2,
953: p_attribute14 in varchar2 default hr_api.g_varchar2,
954: p_attribute15 in varchar2 default hr_api.g_varchar2,
955: p_attribute16 in varchar2 default hr_api.g_varchar2,
956: p_attribute17 in varchar2 default hr_api.g_varchar2,
957: p_attribute18 in varchar2 default hr_api.g_varchar2,
958: p_attribute19 in varchar2 default hr_api.g_varchar2,
959: p_attribute20 in varchar2 default hr_api.g_varchar2,
960: p_effective_date in date,

Line 957: p_attribute18 in varchar2 default hr_api.g_varchar2,

953: p_attribute14 in varchar2 default hr_api.g_varchar2,
954: p_attribute15 in varchar2 default hr_api.g_varchar2,
955: p_attribute16 in varchar2 default hr_api.g_varchar2,
956: p_attribute17 in varchar2 default hr_api.g_varchar2,
957: p_attribute18 in varchar2 default hr_api.g_varchar2,
958: p_attribute19 in varchar2 default hr_api.g_varchar2,
959: p_attribute20 in varchar2 default hr_api.g_varchar2,
960: p_effective_date in date,
961: p_party_id in number default hr_api.g_number,

Line 958: p_attribute19 in varchar2 default hr_api.g_varchar2,

954: p_attribute15 in varchar2 default hr_api.g_varchar2,
955: p_attribute16 in varchar2 default hr_api.g_varchar2,
956: p_attribute17 in varchar2 default hr_api.g_varchar2,
957: p_attribute18 in varchar2 default hr_api.g_varchar2,
958: p_attribute19 in varchar2 default hr_api.g_varchar2,
959: p_attribute20 in varchar2 default hr_api.g_varchar2,
960: p_effective_date in date,
961: p_party_id in number default hr_api.g_number,
962: p_validate in boolean default false,

Line 959: p_attribute20 in varchar2 default hr_api.g_varchar2,

955: p_attribute16 in varchar2 default hr_api.g_varchar2,
956: p_attribute17 in varchar2 default hr_api.g_varchar2,
957: p_attribute18 in varchar2 default hr_api.g_varchar2,
958: p_attribute19 in varchar2 default hr_api.g_varchar2,
959: p_attribute20 in varchar2 default hr_api.g_varchar2,
960: p_effective_date in date,
961: p_party_id in number default hr_api.g_number,
962: p_validate in boolean default false,
963: -- p_object_id in number default hr_api.g_number,

Line 961: p_party_id in number default hr_api.g_number,

957: p_attribute18 in varchar2 default hr_api.g_varchar2,
958: p_attribute19 in varchar2 default hr_api.g_varchar2,
959: p_attribute20 in varchar2 default hr_api.g_varchar2,
960: p_effective_date in date,
961: p_party_id in number default hr_api.g_number,
962: p_validate in boolean default false,
963: -- p_object_id in number default hr_api.g_number,
964: -- p_object_name in varchar2 default hr_api.g_varchar2
965: p_qualification_type_id in number default hr_api.g_number,

Line 963: -- p_object_id in number default hr_api.g_number,

959: p_attribute20 in varchar2 default hr_api.g_varchar2,
960: p_effective_date in date,
961: p_party_id in number default hr_api.g_number,
962: p_validate in boolean default false,
963: -- p_object_id in number default hr_api.g_number,
964: -- p_object_name in varchar2 default hr_api.g_varchar2
965: p_qualification_type_id in number default hr_api.g_number,
966: p_unit_standard_type in varchar2 default hr_api.g_varchar2,
967: p_status in varchar2 default hr_api.g_varchar2,

Line 964: -- p_object_name in varchar2 default hr_api.g_varchar2

960: p_effective_date in date,
961: p_party_id in number default hr_api.g_number,
962: p_validate in boolean default false,
963: -- p_object_id in number default hr_api.g_number,
964: -- p_object_name in varchar2 default hr_api.g_varchar2
965: p_qualification_type_id in number default hr_api.g_number,
966: p_unit_standard_type in varchar2 default hr_api.g_varchar2,
967: p_status in varchar2 default hr_api.g_varchar2,
968: p_information_category in varchar2 default hr_api.g_varchar2,

Line 965: p_qualification_type_id in number default hr_api.g_number,

961: p_party_id in number default hr_api.g_number,
962: p_validate in boolean default false,
963: -- p_object_id in number default hr_api.g_number,
964: -- p_object_name in varchar2 default hr_api.g_varchar2
965: p_qualification_type_id in number default hr_api.g_number,
966: p_unit_standard_type in varchar2 default hr_api.g_varchar2,
967: p_status in varchar2 default hr_api.g_varchar2,
968: p_information_category in varchar2 default hr_api.g_varchar2,
969: p_information1 in varchar2 default hr_api.g_varchar2,

Line 966: p_unit_standard_type in varchar2 default hr_api.g_varchar2,

962: p_validate in boolean default false,
963: -- p_object_id in number default hr_api.g_number,
964: -- p_object_name in varchar2 default hr_api.g_varchar2
965: p_qualification_type_id in number default hr_api.g_number,
966: p_unit_standard_type in varchar2 default hr_api.g_varchar2,
967: p_status in varchar2 default hr_api.g_varchar2,
968: p_information_category in varchar2 default hr_api.g_varchar2,
969: p_information1 in varchar2 default hr_api.g_varchar2,
970: p_information2 in varchar2 default hr_api.g_varchar2,

Line 967: p_status in varchar2 default hr_api.g_varchar2,

963: -- p_object_id in number default hr_api.g_number,
964: -- p_object_name in varchar2 default hr_api.g_varchar2
965: p_qualification_type_id in number default hr_api.g_number,
966: p_unit_standard_type in varchar2 default hr_api.g_varchar2,
967: p_status in varchar2 default hr_api.g_varchar2,
968: p_information_category in varchar2 default hr_api.g_varchar2,
969: p_information1 in varchar2 default hr_api.g_varchar2,
970: p_information2 in varchar2 default hr_api.g_varchar2,
971: p_information3 in varchar2 default hr_api.g_varchar2,

Line 968: p_information_category in varchar2 default hr_api.g_varchar2,

964: -- p_object_name in varchar2 default hr_api.g_varchar2
965: p_qualification_type_id in number default hr_api.g_number,
966: p_unit_standard_type in varchar2 default hr_api.g_varchar2,
967: p_status in varchar2 default hr_api.g_varchar2,
968: p_information_category in varchar2 default hr_api.g_varchar2,
969: p_information1 in varchar2 default hr_api.g_varchar2,
970: p_information2 in varchar2 default hr_api.g_varchar2,
971: p_information3 in varchar2 default hr_api.g_varchar2,
972: p_information4 in varchar2 default hr_api.g_varchar2,

Line 969: p_information1 in varchar2 default hr_api.g_varchar2,

965: p_qualification_type_id in number default hr_api.g_number,
966: p_unit_standard_type in varchar2 default hr_api.g_varchar2,
967: p_status in varchar2 default hr_api.g_varchar2,
968: p_information_category in varchar2 default hr_api.g_varchar2,
969: p_information1 in varchar2 default hr_api.g_varchar2,
970: p_information2 in varchar2 default hr_api.g_varchar2,
971: p_information3 in varchar2 default hr_api.g_varchar2,
972: p_information4 in varchar2 default hr_api.g_varchar2,
973: p_information5 in varchar2 default hr_api.g_varchar2,

Line 970: p_information2 in varchar2 default hr_api.g_varchar2,

966: p_unit_standard_type in varchar2 default hr_api.g_varchar2,
967: p_status in varchar2 default hr_api.g_varchar2,
968: p_information_category in varchar2 default hr_api.g_varchar2,
969: p_information1 in varchar2 default hr_api.g_varchar2,
970: p_information2 in varchar2 default hr_api.g_varchar2,
971: p_information3 in varchar2 default hr_api.g_varchar2,
972: p_information4 in varchar2 default hr_api.g_varchar2,
973: p_information5 in varchar2 default hr_api.g_varchar2,
974: p_information6 in varchar2 default hr_api.g_varchar2,

Line 971: p_information3 in varchar2 default hr_api.g_varchar2,

967: p_status in varchar2 default hr_api.g_varchar2,
968: p_information_category in varchar2 default hr_api.g_varchar2,
969: p_information1 in varchar2 default hr_api.g_varchar2,
970: p_information2 in varchar2 default hr_api.g_varchar2,
971: p_information3 in varchar2 default hr_api.g_varchar2,
972: p_information4 in varchar2 default hr_api.g_varchar2,
973: p_information5 in varchar2 default hr_api.g_varchar2,
974: p_information6 in varchar2 default hr_api.g_varchar2,
975: p_information7 in varchar2 default hr_api.g_varchar2,

Line 972: p_information4 in varchar2 default hr_api.g_varchar2,

968: p_information_category in varchar2 default hr_api.g_varchar2,
969: p_information1 in varchar2 default hr_api.g_varchar2,
970: p_information2 in varchar2 default hr_api.g_varchar2,
971: p_information3 in varchar2 default hr_api.g_varchar2,
972: p_information4 in varchar2 default hr_api.g_varchar2,
973: p_information5 in varchar2 default hr_api.g_varchar2,
974: p_information6 in varchar2 default hr_api.g_varchar2,
975: p_information7 in varchar2 default hr_api.g_varchar2,
976: p_information8 in varchar2 default hr_api.g_varchar2,

Line 973: p_information5 in varchar2 default hr_api.g_varchar2,

969: p_information1 in varchar2 default hr_api.g_varchar2,
970: p_information2 in varchar2 default hr_api.g_varchar2,
971: p_information3 in varchar2 default hr_api.g_varchar2,
972: p_information4 in varchar2 default hr_api.g_varchar2,
973: p_information5 in varchar2 default hr_api.g_varchar2,
974: p_information6 in varchar2 default hr_api.g_varchar2,
975: p_information7 in varchar2 default hr_api.g_varchar2,
976: p_information8 in varchar2 default hr_api.g_varchar2,
977: p_information9 in varchar2 default hr_api.g_varchar2,

Line 974: p_information6 in varchar2 default hr_api.g_varchar2,

970: p_information2 in varchar2 default hr_api.g_varchar2,
971: p_information3 in varchar2 default hr_api.g_varchar2,
972: p_information4 in varchar2 default hr_api.g_varchar2,
973: p_information5 in varchar2 default hr_api.g_varchar2,
974: p_information6 in varchar2 default hr_api.g_varchar2,
975: p_information7 in varchar2 default hr_api.g_varchar2,
976: p_information8 in varchar2 default hr_api.g_varchar2,
977: p_information9 in varchar2 default hr_api.g_varchar2,
978: p_information10 in varchar2 default hr_api.g_varchar2,

Line 975: p_information7 in varchar2 default hr_api.g_varchar2,

971: p_information3 in varchar2 default hr_api.g_varchar2,
972: p_information4 in varchar2 default hr_api.g_varchar2,
973: p_information5 in varchar2 default hr_api.g_varchar2,
974: p_information6 in varchar2 default hr_api.g_varchar2,
975: p_information7 in varchar2 default hr_api.g_varchar2,
976: p_information8 in varchar2 default hr_api.g_varchar2,
977: p_information9 in varchar2 default hr_api.g_varchar2,
978: p_information10 in varchar2 default hr_api.g_varchar2,
979: p_information11 in varchar2 default hr_api.g_varchar2,

Line 976: p_information8 in varchar2 default hr_api.g_varchar2,

972: p_information4 in varchar2 default hr_api.g_varchar2,
973: p_information5 in varchar2 default hr_api.g_varchar2,
974: p_information6 in varchar2 default hr_api.g_varchar2,
975: p_information7 in varchar2 default hr_api.g_varchar2,
976: p_information8 in varchar2 default hr_api.g_varchar2,
977: p_information9 in varchar2 default hr_api.g_varchar2,
978: p_information10 in varchar2 default hr_api.g_varchar2,
979: p_information11 in varchar2 default hr_api.g_varchar2,
980: p_information12 in varchar2 default hr_api.g_varchar2,

Line 977: p_information9 in varchar2 default hr_api.g_varchar2,

973: p_information5 in varchar2 default hr_api.g_varchar2,
974: p_information6 in varchar2 default hr_api.g_varchar2,
975: p_information7 in varchar2 default hr_api.g_varchar2,
976: p_information8 in varchar2 default hr_api.g_varchar2,
977: p_information9 in varchar2 default hr_api.g_varchar2,
978: p_information10 in varchar2 default hr_api.g_varchar2,
979: p_information11 in varchar2 default hr_api.g_varchar2,
980: p_information12 in varchar2 default hr_api.g_varchar2,
981: p_information13 in varchar2 default hr_api.g_varchar2,

Line 978: p_information10 in varchar2 default hr_api.g_varchar2,

974: p_information6 in varchar2 default hr_api.g_varchar2,
975: p_information7 in varchar2 default hr_api.g_varchar2,
976: p_information8 in varchar2 default hr_api.g_varchar2,
977: p_information9 in varchar2 default hr_api.g_varchar2,
978: p_information10 in varchar2 default hr_api.g_varchar2,
979: p_information11 in varchar2 default hr_api.g_varchar2,
980: p_information12 in varchar2 default hr_api.g_varchar2,
981: p_information13 in varchar2 default hr_api.g_varchar2,
982: p_information14 in varchar2 default hr_api.g_varchar2,

Line 979: p_information11 in varchar2 default hr_api.g_varchar2,

975: p_information7 in varchar2 default hr_api.g_varchar2,
976: p_information8 in varchar2 default hr_api.g_varchar2,
977: p_information9 in varchar2 default hr_api.g_varchar2,
978: p_information10 in varchar2 default hr_api.g_varchar2,
979: p_information11 in varchar2 default hr_api.g_varchar2,
980: p_information12 in varchar2 default hr_api.g_varchar2,
981: p_information13 in varchar2 default hr_api.g_varchar2,
982: p_information14 in varchar2 default hr_api.g_varchar2,
983: p_information15 in varchar2 default hr_api.g_varchar2,

Line 980: p_information12 in varchar2 default hr_api.g_varchar2,

976: p_information8 in varchar2 default hr_api.g_varchar2,
977: p_information9 in varchar2 default hr_api.g_varchar2,
978: p_information10 in varchar2 default hr_api.g_varchar2,
979: p_information11 in varchar2 default hr_api.g_varchar2,
980: p_information12 in varchar2 default hr_api.g_varchar2,
981: p_information13 in varchar2 default hr_api.g_varchar2,
982: p_information14 in varchar2 default hr_api.g_varchar2,
983: p_information15 in varchar2 default hr_api.g_varchar2,
984: p_information16 in varchar2 default hr_api.g_varchar2,

Line 981: p_information13 in varchar2 default hr_api.g_varchar2,

977: p_information9 in varchar2 default hr_api.g_varchar2,
978: p_information10 in varchar2 default hr_api.g_varchar2,
979: p_information11 in varchar2 default hr_api.g_varchar2,
980: p_information12 in varchar2 default hr_api.g_varchar2,
981: p_information13 in varchar2 default hr_api.g_varchar2,
982: p_information14 in varchar2 default hr_api.g_varchar2,
983: p_information15 in varchar2 default hr_api.g_varchar2,
984: p_information16 in varchar2 default hr_api.g_varchar2,
985: p_information17 in varchar2 default hr_api.g_varchar2,

Line 982: p_information14 in varchar2 default hr_api.g_varchar2,

978: p_information10 in varchar2 default hr_api.g_varchar2,
979: p_information11 in varchar2 default hr_api.g_varchar2,
980: p_information12 in varchar2 default hr_api.g_varchar2,
981: p_information13 in varchar2 default hr_api.g_varchar2,
982: p_information14 in varchar2 default hr_api.g_varchar2,
983: p_information15 in varchar2 default hr_api.g_varchar2,
984: p_information16 in varchar2 default hr_api.g_varchar2,
985: p_information17 in varchar2 default hr_api.g_varchar2,
986: p_information18 in varchar2 default hr_api.g_varchar2,

Line 983: p_information15 in varchar2 default hr_api.g_varchar2,

979: p_information11 in varchar2 default hr_api.g_varchar2,
980: p_information12 in varchar2 default hr_api.g_varchar2,
981: p_information13 in varchar2 default hr_api.g_varchar2,
982: p_information14 in varchar2 default hr_api.g_varchar2,
983: p_information15 in varchar2 default hr_api.g_varchar2,
984: p_information16 in varchar2 default hr_api.g_varchar2,
985: p_information17 in varchar2 default hr_api.g_varchar2,
986: p_information18 in varchar2 default hr_api.g_varchar2,
987: p_information19 in varchar2 default hr_api.g_varchar2,

Line 984: p_information16 in varchar2 default hr_api.g_varchar2,

980: p_information12 in varchar2 default hr_api.g_varchar2,
981: p_information13 in varchar2 default hr_api.g_varchar2,
982: p_information14 in varchar2 default hr_api.g_varchar2,
983: p_information15 in varchar2 default hr_api.g_varchar2,
984: p_information16 in varchar2 default hr_api.g_varchar2,
985: p_information17 in varchar2 default hr_api.g_varchar2,
986: p_information18 in varchar2 default hr_api.g_varchar2,
987: p_information19 in varchar2 default hr_api.g_varchar2,
988: p_information20 in varchar2 default hr_api.g_varchar2,

Line 985: p_information17 in varchar2 default hr_api.g_varchar2,

981: p_information13 in varchar2 default hr_api.g_varchar2,
982: p_information14 in varchar2 default hr_api.g_varchar2,
983: p_information15 in varchar2 default hr_api.g_varchar2,
984: p_information16 in varchar2 default hr_api.g_varchar2,
985: p_information17 in varchar2 default hr_api.g_varchar2,
986: p_information18 in varchar2 default hr_api.g_varchar2,
987: p_information19 in varchar2 default hr_api.g_varchar2,
988: p_information20 in varchar2 default hr_api.g_varchar2,
989: p_achieved_date in date default hr_api.g_date,

Line 986: p_information18 in varchar2 default hr_api.g_varchar2,

982: p_information14 in varchar2 default hr_api.g_varchar2,
983: p_information15 in varchar2 default hr_api.g_varchar2,
984: p_information16 in varchar2 default hr_api.g_varchar2,
985: p_information17 in varchar2 default hr_api.g_varchar2,
986: p_information18 in varchar2 default hr_api.g_varchar2,
987: p_information19 in varchar2 default hr_api.g_varchar2,
988: p_information20 in varchar2 default hr_api.g_varchar2,
989: p_achieved_date in date default hr_api.g_date,
990: p_appr_line_score in number default hr_api.g_number

Line 987: p_information19 in varchar2 default hr_api.g_varchar2,

983: p_information15 in varchar2 default hr_api.g_varchar2,
984: p_information16 in varchar2 default hr_api.g_varchar2,
985: p_information17 in varchar2 default hr_api.g_varchar2,
986: p_information18 in varchar2 default hr_api.g_varchar2,
987: p_information19 in varchar2 default hr_api.g_varchar2,
988: p_information20 in varchar2 default hr_api.g_varchar2,
989: p_achieved_date in date default hr_api.g_date,
990: p_appr_line_score in number default hr_api.g_number
991: ) is

Line 988: p_information20 in varchar2 default hr_api.g_varchar2,

984: p_information16 in varchar2 default hr_api.g_varchar2,
985: p_information17 in varchar2 default hr_api.g_varchar2,
986: p_information18 in varchar2 default hr_api.g_varchar2,
987: p_information19 in varchar2 default hr_api.g_varchar2,
988: p_information20 in varchar2 default hr_api.g_varchar2,
989: p_achieved_date in date default hr_api.g_date,
990: p_appr_line_score in number default hr_api.g_number
991: ) is
992: --

Line 989: p_achieved_date in date default hr_api.g_date,

985: p_information17 in varchar2 default hr_api.g_varchar2,
986: p_information18 in varchar2 default hr_api.g_varchar2,
987: p_information19 in varchar2 default hr_api.g_varchar2,
988: p_information20 in varchar2 default hr_api.g_varchar2,
989: p_achieved_date in date default hr_api.g_date,
990: p_appr_line_score in number default hr_api.g_number
991: ) is
992: --
993: l_rec per_cel_shd.g_rec_type;

Line 990: p_appr_line_score in number default hr_api.g_number

986: p_information18 in varchar2 default hr_api.g_varchar2,
987: p_information19 in varchar2 default hr_api.g_varchar2,
988: p_information20 in varchar2 default hr_api.g_varchar2,
989: p_achieved_date in date default hr_api.g_date,
990: p_appr_line_score in number default hr_api.g_number
991: ) is
992: --
993: l_rec per_cel_shd.g_rec_type;
994: l_proc varchar2(72) := g_package||'upd';

Line 1007: hr_api.g_varchar2,

1003: per_cel_shd.convert_args
1004: (
1005: p_competence_element_id,
1006: p_object_version_number,
1007: hr_api.g_varchar2,
1008: hr_api.g_number,
1009: hr_api.g_number,
1010: hr_api.g_number,
1011: p_proficiency_level_id,

Line 1008: hr_api.g_number,

1004: (
1005: p_competence_element_id,
1006: p_object_version_number,
1007: hr_api.g_varchar2,
1008: hr_api.g_number,
1009: hr_api.g_number,
1010: hr_api.g_number,
1011: p_proficiency_level_id,
1012: p_high_proficiency_level_id,

Line 1009: hr_api.g_number,

1005: p_competence_element_id,
1006: p_object_version_number,
1007: hr_api.g_varchar2,
1008: hr_api.g_number,
1009: hr_api.g_number,
1010: hr_api.g_number,
1011: p_proficiency_level_id,
1012: p_high_proficiency_level_id,
1013: p_weighting_level_id,

Line 1010: hr_api.g_number,

1006: p_object_version_number,
1007: hr_api.g_varchar2,
1008: hr_api.g_number,
1009: hr_api.g_number,
1010: hr_api.g_number,
1011: p_proficiency_level_id,
1012: p_high_proficiency_level_id,
1013: p_weighting_level_id,
1014: p_rating_level_id,

Line 1015: hr_api.g_number,

1011: p_proficiency_level_id,
1012: p_high_proficiency_level_id,
1013: p_weighting_level_id,
1014: p_rating_level_id,
1015: hr_api.g_number,
1016: hr_api.g_number,
1017: hr_api.g_number,
1018: hr_api.g_number,
1019: hr_api.g_number,

Line 1016: hr_api.g_number,

1012: p_high_proficiency_level_id,
1013: p_weighting_level_id,
1014: p_rating_level_id,
1015: hr_api.g_number,
1016: hr_api.g_number,
1017: hr_api.g_number,
1018: hr_api.g_number,
1019: hr_api.g_number,
1020: hr_api.g_number,

Line 1017: hr_api.g_number,

1013: p_weighting_level_id,
1014: p_rating_level_id,
1015: hr_api.g_number,
1016: hr_api.g_number,
1017: hr_api.g_number,
1018: hr_api.g_number,
1019: hr_api.g_number,
1020: hr_api.g_number,
1021: hr_api.g_number,

Line 1018: hr_api.g_number,

1014: p_rating_level_id,
1015: hr_api.g_number,
1016: hr_api.g_number,
1017: hr_api.g_number,
1018: hr_api.g_number,
1019: hr_api.g_number,
1020: hr_api.g_number,
1021: hr_api.g_number,
1022: hr_api.g_number,

Line 1019: hr_api.g_number,

1015: hr_api.g_number,
1016: hr_api.g_number,
1017: hr_api.g_number,
1018: hr_api.g_number,
1019: hr_api.g_number,
1020: hr_api.g_number,
1021: hr_api.g_number,
1022: hr_api.g_number,
1023: hr_api.g_number,

Line 1020: hr_api.g_number,

1016: hr_api.g_number,
1017: hr_api.g_number,
1018: hr_api.g_number,
1019: hr_api.g_number,
1020: hr_api.g_number,
1021: hr_api.g_number,
1022: hr_api.g_number,
1023: hr_api.g_number,
1024: p_mandatory,

Line 1021: hr_api.g_number,

1017: hr_api.g_number,
1018: hr_api.g_number,
1019: hr_api.g_number,
1020: hr_api.g_number,
1021: hr_api.g_number,
1022: hr_api.g_number,
1023: hr_api.g_number,
1024: p_mandatory,
1025: p_effective_date_from,

Line 1022: hr_api.g_number,

1018: hr_api.g_number,
1019: hr_api.g_number,
1020: hr_api.g_number,
1021: hr_api.g_number,
1022: hr_api.g_number,
1023: hr_api.g_number,
1024: p_mandatory,
1025: p_effective_date_from,
1026: p_effective_date_to,

Line 1023: hr_api.g_number,

1019: hr_api.g_number,
1020: hr_api.g_number,
1021: hr_api.g_number,
1022: hr_api.g_number,
1023: hr_api.g_number,
1024: p_mandatory,
1025: p_effective_date_from,
1026: p_effective_date_to,
1027: p_group_competence_type,

Line 1059: hr_api.g_number,

1055: p_attribute17,
1056: p_attribute18,
1057: p_attribute19,
1058: p_attribute20,
1059: hr_api.g_number,
1060: hr_api.g_varchar2,
1061: p_party_id, -- HR/TCA merge
1062: p_qualification_type_id,
1063: p_unit_standard_type,

Line 1060: hr_api.g_varchar2,

1056: p_attribute18,
1057: p_attribute19,
1058: p_attribute20,
1059: hr_api.g_number,
1060: hr_api.g_varchar2,
1061: p_party_id, -- HR/TCA merge
1062: p_qualification_type_id,
1063: p_unit_standard_type,
1064: p_status,