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_CTR_UPD dependencies on HR_API

Line 139: When hr_api.check_integrity_violated Then

135: --
136: hr_utility.set_location(' Leaving:'||l_proc, 10);
137: --
138: Exception
139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
141: per_ctr_shd.g_api_dml := false; -- Unset the api dml status
142: per_ctr_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
141: per_ctr_shd.g_api_dml := false; -- Unset the api dml status
142: per_ctr_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: per_ctr_shd.g_api_dml := false; -- Unset the api dml status
147: per_ctr_shd.constraint_error

Line 144: When hr_api.parent_integrity_violated Then

140: -- A check constraint has been violated
141: per_ctr_shd.g_api_dml := false; -- Unset the api dml status
142: per_ctr_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: per_ctr_shd.g_api_dml := false; -- Unset the api dml status
147: per_ctr_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: per_ctr_shd.g_api_dml := false; -- Unset the api dml status
147: per_ctr_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: per_ctr_shd.g_api_dml := false; -- Unset the api dml status
152: per_ctr_shd.constraint_error

Line 149: When hr_api.unique_integrity_violated Then

145: -- Parent integrity has been violated
146: per_ctr_shd.g_api_dml := false; -- Unset the api dml status
147: per_ctr_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: per_ctr_shd.g_api_dml := false; -- Unset the api dml status
152: per_ctr_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: per_ctr_shd.g_api_dml := false; -- Unset the api dml status
152: per_ctr_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: per_ctr_shd.g_api_dml := false; -- Unset the api dml status
156: Raise;
157: End update_dml;

Line 448: when hr_api.cannot_find_prog_unit then

444: ,p_object_version_number_o
445: => per_ctr_shd.g_old_rec.object_version_number
446: );
447: exception
448: when hr_api.cannot_find_prog_unit then
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'PER_CONTACT_RELATIONSHIPS'
451: ,p_hook_type => 'AU'
452: );

Line 449: hr_api.cannot_find_prog_unit_error

445: => per_ctr_shd.g_old_rec.object_version_number
446: );
447: exception
448: when hr_api.cannot_find_prog_unit then
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'PER_CONTACT_RELATIONSHIPS'
451: ,p_hook_type => 'AU'
452: );
453: end;

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

545: -- p_rec plsql record structure
546: -- to see if a system default is being used. If a system default
547: -- is being used then we must set to the 'current' argument value.
548: --
549: If (p_rec.business_group_id = hr_api.g_number) then
550: p_rec.business_group_id :=
551: per_ctr_shd.g_old_rec.business_group_id;
552: End If;
553: If (p_rec.person_id = hr_api.g_number) then

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

549: If (p_rec.business_group_id = hr_api.g_number) then
550: p_rec.business_group_id :=
551: per_ctr_shd.g_old_rec.business_group_id;
552: End If;
553: If (p_rec.person_id = hr_api.g_number) then
554: p_rec.person_id :=
555: per_ctr_shd.g_old_rec.person_id;
556: End If;
557: If (p_rec.contact_person_id = hr_api.g_number) then

Line 557: If (p_rec.contact_person_id = hr_api.g_number) then

553: If (p_rec.person_id = hr_api.g_number) then
554: p_rec.person_id :=
555: per_ctr_shd.g_old_rec.person_id;
556: End If;
557: If (p_rec.contact_person_id = hr_api.g_number) then
558: p_rec.contact_person_id :=
559: per_ctr_shd.g_old_rec.contact_person_id;
560: End If;
561: If (p_rec.contact_type = hr_api.g_varchar2) then

Line 561: If (p_rec.contact_type = hr_api.g_varchar2) then

557: If (p_rec.contact_person_id = hr_api.g_number) then
558: p_rec.contact_person_id :=
559: per_ctr_shd.g_old_rec.contact_person_id;
560: End If;
561: If (p_rec.contact_type = hr_api.g_varchar2) then
562: p_rec.contact_type :=
563: per_ctr_shd.g_old_rec.contact_type;
564: End If;
565: If (p_rec.comments = hr_api.g_varchar2) then

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

561: If (p_rec.contact_type = hr_api.g_varchar2) then
562: p_rec.contact_type :=
563: per_ctr_shd.g_old_rec.contact_type;
564: End If;
565: If (p_rec.comments = hr_api.g_varchar2) then
566: p_rec.comments :=
567: per_ctr_shd.g_old_rec.comments;
568: End If;
569: If (p_rec.primary_contact_flag = hr_api.g_varchar2) then

Line 569: If (p_rec.primary_contact_flag = hr_api.g_varchar2) then

565: If (p_rec.comments = hr_api.g_varchar2) then
566: p_rec.comments :=
567: per_ctr_shd.g_old_rec.comments;
568: End If;
569: If (p_rec.primary_contact_flag = hr_api.g_varchar2) then
570: p_rec.primary_contact_flag :=
571: per_ctr_shd.g_old_rec.primary_contact_flag;
572: End If;
573: If (p_rec.request_id = hr_api.g_number) then

Line 573: If (p_rec.request_id = hr_api.g_number) then

569: If (p_rec.primary_contact_flag = hr_api.g_varchar2) then
570: p_rec.primary_contact_flag :=
571: per_ctr_shd.g_old_rec.primary_contact_flag;
572: End If;
573: If (p_rec.request_id = hr_api.g_number) then
574: p_rec.request_id :=
575: per_ctr_shd.g_old_rec.request_id;
576: End If;
577: If (p_rec.program_application_id = hr_api.g_number) then

Line 577: If (p_rec.program_application_id = hr_api.g_number) then

573: If (p_rec.request_id = hr_api.g_number) then
574: p_rec.request_id :=
575: per_ctr_shd.g_old_rec.request_id;
576: End If;
577: If (p_rec.program_application_id = hr_api.g_number) then
578: p_rec.program_application_id :=
579: per_ctr_shd.g_old_rec.program_application_id;
580: End If;
581: If (p_rec.program_id = hr_api.g_number) then

Line 581: If (p_rec.program_id = hr_api.g_number) then

577: If (p_rec.program_application_id = hr_api.g_number) then
578: p_rec.program_application_id :=
579: per_ctr_shd.g_old_rec.program_application_id;
580: End If;
581: If (p_rec.program_id = hr_api.g_number) then
582: p_rec.program_id :=
583: per_ctr_shd.g_old_rec.program_id;
584: End If;
585: If (p_rec.program_update_date = hr_api.g_date) then

Line 585: If (p_rec.program_update_date = hr_api.g_date) then

581: If (p_rec.program_id = hr_api.g_number) then
582: p_rec.program_id :=
583: per_ctr_shd.g_old_rec.program_id;
584: End If;
585: If (p_rec.program_update_date = hr_api.g_date) then
586: p_rec.program_update_date :=
587: per_ctr_shd.g_old_rec.program_update_date;
588: End If;
589: If (p_rec.date_start = hr_api.g_date) then

Line 589: If (p_rec.date_start = hr_api.g_date) then

585: If (p_rec.program_update_date = hr_api.g_date) then
586: p_rec.program_update_date :=
587: per_ctr_shd.g_old_rec.program_update_date;
588: End If;
589: If (p_rec.date_start = hr_api.g_date) then
590: p_rec.date_start :=
591: per_ctr_shd.g_old_rec.date_start;
592: End If;
593: If (p_rec.start_life_reason_id = hr_api.g_number) then

Line 593: If (p_rec.start_life_reason_id = hr_api.g_number) then

589: If (p_rec.date_start = hr_api.g_date) then
590: p_rec.date_start :=
591: per_ctr_shd.g_old_rec.date_start;
592: End If;
593: If (p_rec.start_life_reason_id = hr_api.g_number) then
594: p_rec.start_life_reason_id :=
595: per_ctr_shd.g_old_rec.start_life_reason_id;
596: End If;
597: If (p_rec.date_end = hr_api.g_date) then

Line 597: If (p_rec.date_end = hr_api.g_date) then

593: If (p_rec.start_life_reason_id = hr_api.g_number) then
594: p_rec.start_life_reason_id :=
595: per_ctr_shd.g_old_rec.start_life_reason_id;
596: End If;
597: If (p_rec.date_end = hr_api.g_date) then
598: p_rec.date_end :=
599: per_ctr_shd.g_old_rec.date_end;
600: End If;
601: If (p_rec.end_life_reason_id = hr_api.g_number) then

Line 601: If (p_rec.end_life_reason_id = hr_api.g_number) then

597: If (p_rec.date_end = hr_api.g_date) then
598: p_rec.date_end :=
599: per_ctr_shd.g_old_rec.date_end;
600: End If;
601: If (p_rec.end_life_reason_id = hr_api.g_number) then
602: p_rec.end_life_reason_id :=
603: per_ctr_shd.g_old_rec.end_life_reason_id;
604: End If;
605: If (p_rec.rltd_per_rsds_w_dsgntr_flag = hr_api.g_varchar2) then

Line 605: If (p_rec.rltd_per_rsds_w_dsgntr_flag = hr_api.g_varchar2) then

601: If (p_rec.end_life_reason_id = hr_api.g_number) then
602: p_rec.end_life_reason_id :=
603: per_ctr_shd.g_old_rec.end_life_reason_id;
604: End If;
605: If (p_rec.rltd_per_rsds_w_dsgntr_flag = hr_api.g_varchar2) then
606: p_rec.rltd_per_rsds_w_dsgntr_flag :=
607: per_ctr_shd.g_old_rec.rltd_per_rsds_w_dsgntr_flag;
608: End If;
609: If (p_rec.personal_flag = hr_api.g_varchar2) then

Line 609: If (p_rec.personal_flag = hr_api.g_varchar2) then

605: If (p_rec.rltd_per_rsds_w_dsgntr_flag = hr_api.g_varchar2) then
606: p_rec.rltd_per_rsds_w_dsgntr_flag :=
607: per_ctr_shd.g_old_rec.rltd_per_rsds_w_dsgntr_flag;
608: End If;
609: If (p_rec.personal_flag = hr_api.g_varchar2) then
610: p_rec.personal_flag :=
611: per_ctr_shd.g_old_rec.personal_flag;
612: End If;
613: If (p_rec.sequence_number = hr_api.g_number) then

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

609: If (p_rec.personal_flag = hr_api.g_varchar2) then
610: p_rec.personal_flag :=
611: per_ctr_shd.g_old_rec.personal_flag;
612: End If;
613: If (p_rec.sequence_number = hr_api.g_number) then
614: p_rec.sequence_number :=
615: per_ctr_shd.g_old_rec.sequence_number;
616: End If;
617: If (p_rec.cont_attribute_category = hr_api.g_varchar2) then

Line 617: If (p_rec.cont_attribute_category = hr_api.g_varchar2) then

613: If (p_rec.sequence_number = hr_api.g_number) then
614: p_rec.sequence_number :=
615: per_ctr_shd.g_old_rec.sequence_number;
616: End If;
617: If (p_rec.cont_attribute_category = hr_api.g_varchar2) then
618: p_rec.cont_attribute_category :=
619: per_ctr_shd.g_old_rec.cont_attribute_category;
620: End If;
621: If (p_rec.cont_attribute1 = hr_api.g_varchar2) then

Line 621: If (p_rec.cont_attribute1 = hr_api.g_varchar2) then

617: If (p_rec.cont_attribute_category = hr_api.g_varchar2) then
618: p_rec.cont_attribute_category :=
619: per_ctr_shd.g_old_rec.cont_attribute_category;
620: End If;
621: If (p_rec.cont_attribute1 = hr_api.g_varchar2) then
622: p_rec.cont_attribute1 :=
623: per_ctr_shd.g_old_rec.cont_attribute1;
624: End If;
625: If (p_rec.cont_attribute2 = hr_api.g_varchar2) then

Line 625: If (p_rec.cont_attribute2 = hr_api.g_varchar2) then

621: If (p_rec.cont_attribute1 = hr_api.g_varchar2) then
622: p_rec.cont_attribute1 :=
623: per_ctr_shd.g_old_rec.cont_attribute1;
624: End If;
625: If (p_rec.cont_attribute2 = hr_api.g_varchar2) then
626: p_rec.cont_attribute2 :=
627: per_ctr_shd.g_old_rec.cont_attribute2;
628: End If;
629: If (p_rec.cont_attribute3 = hr_api.g_varchar2) then

Line 629: If (p_rec.cont_attribute3 = hr_api.g_varchar2) then

625: If (p_rec.cont_attribute2 = hr_api.g_varchar2) then
626: p_rec.cont_attribute2 :=
627: per_ctr_shd.g_old_rec.cont_attribute2;
628: End If;
629: If (p_rec.cont_attribute3 = hr_api.g_varchar2) then
630: p_rec.cont_attribute3 :=
631: per_ctr_shd.g_old_rec.cont_attribute3;
632: End If;
633: If (p_rec.cont_attribute4 = hr_api.g_varchar2) then

Line 633: If (p_rec.cont_attribute4 = hr_api.g_varchar2) then

629: If (p_rec.cont_attribute3 = hr_api.g_varchar2) then
630: p_rec.cont_attribute3 :=
631: per_ctr_shd.g_old_rec.cont_attribute3;
632: End If;
633: If (p_rec.cont_attribute4 = hr_api.g_varchar2) then
634: p_rec.cont_attribute4 :=
635: per_ctr_shd.g_old_rec.cont_attribute4;
636: End If;
637: If (p_rec.cont_attribute5 = hr_api.g_varchar2) then

Line 637: If (p_rec.cont_attribute5 = hr_api.g_varchar2) then

633: If (p_rec.cont_attribute4 = hr_api.g_varchar2) then
634: p_rec.cont_attribute4 :=
635: per_ctr_shd.g_old_rec.cont_attribute4;
636: End If;
637: If (p_rec.cont_attribute5 = hr_api.g_varchar2) then
638: p_rec.cont_attribute5 :=
639: per_ctr_shd.g_old_rec.cont_attribute5;
640: End If;
641: If (p_rec.cont_attribute6 = hr_api.g_varchar2) then

Line 641: If (p_rec.cont_attribute6 = hr_api.g_varchar2) then

637: If (p_rec.cont_attribute5 = hr_api.g_varchar2) then
638: p_rec.cont_attribute5 :=
639: per_ctr_shd.g_old_rec.cont_attribute5;
640: End If;
641: If (p_rec.cont_attribute6 = hr_api.g_varchar2) then
642: p_rec.cont_attribute6 :=
643: per_ctr_shd.g_old_rec.cont_attribute6;
644: End If;
645: If (p_rec.cont_attribute7 = hr_api.g_varchar2) then

Line 645: If (p_rec.cont_attribute7 = hr_api.g_varchar2) then

641: If (p_rec.cont_attribute6 = hr_api.g_varchar2) then
642: p_rec.cont_attribute6 :=
643: per_ctr_shd.g_old_rec.cont_attribute6;
644: End If;
645: If (p_rec.cont_attribute7 = hr_api.g_varchar2) then
646: p_rec.cont_attribute7 :=
647: per_ctr_shd.g_old_rec.cont_attribute7;
648: End If;
649: If (p_rec.cont_attribute8 = hr_api.g_varchar2) then

Line 649: If (p_rec.cont_attribute8 = hr_api.g_varchar2) then

645: If (p_rec.cont_attribute7 = hr_api.g_varchar2) then
646: p_rec.cont_attribute7 :=
647: per_ctr_shd.g_old_rec.cont_attribute7;
648: End If;
649: If (p_rec.cont_attribute8 = hr_api.g_varchar2) then
650: p_rec.cont_attribute8 :=
651: per_ctr_shd.g_old_rec.cont_attribute8;
652: End If;
653: If (p_rec.cont_attribute9 = hr_api.g_varchar2) then

Line 653: If (p_rec.cont_attribute9 = hr_api.g_varchar2) then

649: If (p_rec.cont_attribute8 = hr_api.g_varchar2) then
650: p_rec.cont_attribute8 :=
651: per_ctr_shd.g_old_rec.cont_attribute8;
652: End If;
653: If (p_rec.cont_attribute9 = hr_api.g_varchar2) then
654: p_rec.cont_attribute9 :=
655: per_ctr_shd.g_old_rec.cont_attribute9;
656: End If;
657: If (p_rec.cont_attribute10 = hr_api.g_varchar2) then

Line 657: If (p_rec.cont_attribute10 = hr_api.g_varchar2) then

653: If (p_rec.cont_attribute9 = hr_api.g_varchar2) then
654: p_rec.cont_attribute9 :=
655: per_ctr_shd.g_old_rec.cont_attribute9;
656: End If;
657: If (p_rec.cont_attribute10 = hr_api.g_varchar2) then
658: p_rec.cont_attribute10 :=
659: per_ctr_shd.g_old_rec.cont_attribute10;
660: End If;
661: If (p_rec.cont_attribute11 = hr_api.g_varchar2) then

Line 661: If (p_rec.cont_attribute11 = hr_api.g_varchar2) then

657: If (p_rec.cont_attribute10 = hr_api.g_varchar2) then
658: p_rec.cont_attribute10 :=
659: per_ctr_shd.g_old_rec.cont_attribute10;
660: End If;
661: If (p_rec.cont_attribute11 = hr_api.g_varchar2) then
662: p_rec.cont_attribute11 :=
663: per_ctr_shd.g_old_rec.cont_attribute11;
664: End If;
665: If (p_rec.cont_attribute12 = hr_api.g_varchar2) then

Line 665: If (p_rec.cont_attribute12 = hr_api.g_varchar2) then

661: If (p_rec.cont_attribute11 = hr_api.g_varchar2) then
662: p_rec.cont_attribute11 :=
663: per_ctr_shd.g_old_rec.cont_attribute11;
664: End If;
665: If (p_rec.cont_attribute12 = hr_api.g_varchar2) then
666: p_rec.cont_attribute12 :=
667: per_ctr_shd.g_old_rec.cont_attribute12;
668: End If;
669: If (p_rec.cont_attribute13 = hr_api.g_varchar2) then

Line 669: If (p_rec.cont_attribute13 = hr_api.g_varchar2) then

665: If (p_rec.cont_attribute12 = hr_api.g_varchar2) then
666: p_rec.cont_attribute12 :=
667: per_ctr_shd.g_old_rec.cont_attribute12;
668: End If;
669: If (p_rec.cont_attribute13 = hr_api.g_varchar2) then
670: p_rec.cont_attribute13 :=
671: per_ctr_shd.g_old_rec.cont_attribute13;
672: End If;
673: If (p_rec.cont_attribute14 = hr_api.g_varchar2) then

Line 673: If (p_rec.cont_attribute14 = hr_api.g_varchar2) then

669: If (p_rec.cont_attribute13 = hr_api.g_varchar2) then
670: p_rec.cont_attribute13 :=
671: per_ctr_shd.g_old_rec.cont_attribute13;
672: End If;
673: If (p_rec.cont_attribute14 = hr_api.g_varchar2) then
674: p_rec.cont_attribute14 :=
675: per_ctr_shd.g_old_rec.cont_attribute14;
676: End If;
677: If (p_rec.cont_attribute15 = hr_api.g_varchar2) then

Line 677: If (p_rec.cont_attribute15 = hr_api.g_varchar2) then

673: If (p_rec.cont_attribute14 = hr_api.g_varchar2) then
674: p_rec.cont_attribute14 :=
675: per_ctr_shd.g_old_rec.cont_attribute14;
676: End If;
677: If (p_rec.cont_attribute15 = hr_api.g_varchar2) then
678: p_rec.cont_attribute15 :=
679: per_ctr_shd.g_old_rec.cont_attribute15;
680: End If;
681: If (p_rec.cont_attribute16 = hr_api.g_varchar2) then

Line 681: If (p_rec.cont_attribute16 = hr_api.g_varchar2) then

677: If (p_rec.cont_attribute15 = hr_api.g_varchar2) then
678: p_rec.cont_attribute15 :=
679: per_ctr_shd.g_old_rec.cont_attribute15;
680: End If;
681: If (p_rec.cont_attribute16 = hr_api.g_varchar2) then
682: p_rec.cont_attribute16 :=
683: per_ctr_shd.g_old_rec.cont_attribute16;
684: End If;
685: If (p_rec.cont_attribute17 = hr_api.g_varchar2) then

Line 685: If (p_rec.cont_attribute17 = hr_api.g_varchar2) then

681: If (p_rec.cont_attribute16 = hr_api.g_varchar2) then
682: p_rec.cont_attribute16 :=
683: per_ctr_shd.g_old_rec.cont_attribute16;
684: End If;
685: If (p_rec.cont_attribute17 = hr_api.g_varchar2) then
686: p_rec.cont_attribute17 :=
687: per_ctr_shd.g_old_rec.cont_attribute17;
688: End If;
689: If (p_rec.cont_attribute18 = hr_api.g_varchar2) then

Line 689: If (p_rec.cont_attribute18 = hr_api.g_varchar2) then

685: If (p_rec.cont_attribute17 = hr_api.g_varchar2) then
686: p_rec.cont_attribute17 :=
687: per_ctr_shd.g_old_rec.cont_attribute17;
688: End If;
689: If (p_rec.cont_attribute18 = hr_api.g_varchar2) then
690: p_rec.cont_attribute18 :=
691: per_ctr_shd.g_old_rec.cont_attribute18;
692: End If;
693: If (p_rec.cont_attribute19 = hr_api.g_varchar2) then

Line 693: If (p_rec.cont_attribute19 = hr_api.g_varchar2) then

689: If (p_rec.cont_attribute18 = hr_api.g_varchar2) then
690: p_rec.cont_attribute18 :=
691: per_ctr_shd.g_old_rec.cont_attribute18;
692: End If;
693: If (p_rec.cont_attribute19 = hr_api.g_varchar2) then
694: p_rec.cont_attribute19 :=
695: per_ctr_shd.g_old_rec.cont_attribute19;
696: End If;
697: If (p_rec.cont_attribute20 = hr_api.g_varchar2) then

Line 697: If (p_rec.cont_attribute20 = hr_api.g_varchar2) then

693: If (p_rec.cont_attribute19 = hr_api.g_varchar2) then
694: p_rec.cont_attribute19 :=
695: per_ctr_shd.g_old_rec.cont_attribute19;
696: End If;
697: If (p_rec.cont_attribute20 = hr_api.g_varchar2) then
698: p_rec.cont_attribute20 :=
699: per_ctr_shd.g_old_rec.cont_attribute20;
700: End If;
701: If (p_rec.cont_information_category = hr_api.g_varchar2) then

Line 701: If (p_rec.cont_information_category = hr_api.g_varchar2) then

697: If (p_rec.cont_attribute20 = hr_api.g_varchar2) then
698: p_rec.cont_attribute20 :=
699: per_ctr_shd.g_old_rec.cont_attribute20;
700: End If;
701: If (p_rec.cont_information_category = hr_api.g_varchar2) then
702: p_rec.cont_information_category :=
703: per_ctr_shd.g_old_rec.cont_information_category;
704: End If;
705: If (p_rec.cont_information1 = hr_api.g_varchar2) then

Line 705: If (p_rec.cont_information1 = hr_api.g_varchar2) then

701: If (p_rec.cont_information_category = hr_api.g_varchar2) then
702: p_rec.cont_information_category :=
703: per_ctr_shd.g_old_rec.cont_information_category;
704: End If;
705: If (p_rec.cont_information1 = hr_api.g_varchar2) then
706: p_rec.cont_information1 :=
707: per_ctr_shd.g_old_rec.cont_information1;
708: End If;
709: If (p_rec.cont_information2 = hr_api.g_varchar2) then

Line 709: If (p_rec.cont_information2 = hr_api.g_varchar2) then

705: If (p_rec.cont_information1 = hr_api.g_varchar2) then
706: p_rec.cont_information1 :=
707: per_ctr_shd.g_old_rec.cont_information1;
708: End If;
709: If (p_rec.cont_information2 = hr_api.g_varchar2) then
710: p_rec.cont_information2 :=
711: per_ctr_shd.g_old_rec.cont_information2;
712: End If;
713: If (p_rec.cont_information3 = hr_api.g_varchar2) then

Line 713: If (p_rec.cont_information3 = hr_api.g_varchar2) then

709: If (p_rec.cont_information2 = hr_api.g_varchar2) then
710: p_rec.cont_information2 :=
711: per_ctr_shd.g_old_rec.cont_information2;
712: End If;
713: If (p_rec.cont_information3 = hr_api.g_varchar2) then
714: p_rec.cont_information3 :=
715: per_ctr_shd.g_old_rec.cont_information3;
716: End If;
717: If (p_rec.cont_information4 = hr_api.g_varchar2) then

Line 717: If (p_rec.cont_information4 = hr_api.g_varchar2) then

713: If (p_rec.cont_information3 = hr_api.g_varchar2) then
714: p_rec.cont_information3 :=
715: per_ctr_shd.g_old_rec.cont_information3;
716: End If;
717: If (p_rec.cont_information4 = hr_api.g_varchar2) then
718: p_rec.cont_information4 :=
719: per_ctr_shd.g_old_rec.cont_information4;
720: End If;
721: If (p_rec.cont_information5 = hr_api.g_varchar2) then

Line 721: If (p_rec.cont_information5 = hr_api.g_varchar2) then

717: If (p_rec.cont_information4 = hr_api.g_varchar2) then
718: p_rec.cont_information4 :=
719: per_ctr_shd.g_old_rec.cont_information4;
720: End If;
721: If (p_rec.cont_information5 = hr_api.g_varchar2) then
722: p_rec.cont_information5 :=
723: per_ctr_shd.g_old_rec.cont_information5;
724: End If;
725: If (p_rec.cont_information6 = hr_api.g_varchar2) then

Line 725: If (p_rec.cont_information6 = hr_api.g_varchar2) then

721: If (p_rec.cont_information5 = hr_api.g_varchar2) then
722: p_rec.cont_information5 :=
723: per_ctr_shd.g_old_rec.cont_information5;
724: End If;
725: If (p_rec.cont_information6 = hr_api.g_varchar2) then
726: p_rec.cont_information6 :=
727: per_ctr_shd.g_old_rec.cont_information6;
728: End If;
729: If (p_rec.cont_information7 = hr_api.g_varchar2) then

Line 729: If (p_rec.cont_information7 = hr_api.g_varchar2) then

725: If (p_rec.cont_information6 = hr_api.g_varchar2) then
726: p_rec.cont_information6 :=
727: per_ctr_shd.g_old_rec.cont_information6;
728: End If;
729: If (p_rec.cont_information7 = hr_api.g_varchar2) then
730: p_rec.cont_information7 :=
731: per_ctr_shd.g_old_rec.cont_information7;
732: End If;
733: If (p_rec.cont_information8 = hr_api.g_varchar2) then

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

729: If (p_rec.cont_information7 = hr_api.g_varchar2) then
730: p_rec.cont_information7 :=
731: per_ctr_shd.g_old_rec.cont_information7;
732: End If;
733: If (p_rec.cont_information8 = hr_api.g_varchar2) then
734: p_rec.cont_information8 :=
735: per_ctr_shd.g_old_rec.cont_information8;
736: End If;
737: If (p_rec.cont_information9 = hr_api.g_varchar2) then

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

733: If (p_rec.cont_information8 = hr_api.g_varchar2) then
734: p_rec.cont_information8 :=
735: per_ctr_shd.g_old_rec.cont_information8;
736: End If;
737: If (p_rec.cont_information9 = hr_api.g_varchar2) then
738: p_rec.cont_information9 :=
739: per_ctr_shd.g_old_rec.cont_information9;
740: End If;
741: If (p_rec.cont_information10 = hr_api.g_varchar2) then

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

737: If (p_rec.cont_information9 = hr_api.g_varchar2) then
738: p_rec.cont_information9 :=
739: per_ctr_shd.g_old_rec.cont_information9;
740: End If;
741: If (p_rec.cont_information10 = hr_api.g_varchar2) then
742: p_rec.cont_information10 :=
743: per_ctr_shd.g_old_rec.cont_information10;
744: End If;
745: If (p_rec.cont_information11 = hr_api.g_varchar2) then

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

741: If (p_rec.cont_information10 = hr_api.g_varchar2) then
742: p_rec.cont_information10 :=
743: per_ctr_shd.g_old_rec.cont_information10;
744: End If;
745: If (p_rec.cont_information11 = hr_api.g_varchar2) then
746: p_rec.cont_information11 :=
747: per_ctr_shd.g_old_rec.cont_information11;
748: End If;
749: If (p_rec.cont_information12 = hr_api.g_varchar2) then

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

745: If (p_rec.cont_information11 = hr_api.g_varchar2) then
746: p_rec.cont_information11 :=
747: per_ctr_shd.g_old_rec.cont_information11;
748: End If;
749: If (p_rec.cont_information12 = hr_api.g_varchar2) then
750: p_rec.cont_information12 :=
751: per_ctr_shd.g_old_rec.cont_information12;
752: End If;
753: If (p_rec.cont_information13 = hr_api.g_varchar2) then

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

749: If (p_rec.cont_information12 = hr_api.g_varchar2) then
750: p_rec.cont_information12 :=
751: per_ctr_shd.g_old_rec.cont_information12;
752: End If;
753: If (p_rec.cont_information13 = hr_api.g_varchar2) then
754: p_rec.cont_information13 :=
755: per_ctr_shd.g_old_rec.cont_information13;
756: End If;
757: If (p_rec.cont_information14 = hr_api.g_varchar2) then

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

753: If (p_rec.cont_information13 = hr_api.g_varchar2) then
754: p_rec.cont_information13 :=
755: per_ctr_shd.g_old_rec.cont_information13;
756: End If;
757: If (p_rec.cont_information14 = hr_api.g_varchar2) then
758: p_rec.cont_information14 :=
759: per_ctr_shd.g_old_rec.cont_information14;
760: End If;
761: If (p_rec.cont_information15 = hr_api.g_varchar2) then

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

757: If (p_rec.cont_information14 = hr_api.g_varchar2) then
758: p_rec.cont_information14 :=
759: per_ctr_shd.g_old_rec.cont_information14;
760: End If;
761: If (p_rec.cont_information15 = hr_api.g_varchar2) then
762: p_rec.cont_information15 :=
763: per_ctr_shd.g_old_rec.cont_information15;
764: End If;
765: If (p_rec.cont_information16 = hr_api.g_varchar2) then

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

761: If (p_rec.cont_information15 = hr_api.g_varchar2) then
762: p_rec.cont_information15 :=
763: per_ctr_shd.g_old_rec.cont_information15;
764: End If;
765: If (p_rec.cont_information16 = hr_api.g_varchar2) then
766: p_rec.cont_information16 :=
767: per_ctr_shd.g_old_rec.cont_information16;
768: End If;
769: If (p_rec.cont_information17 = hr_api.g_varchar2) then

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

765: If (p_rec.cont_information16 = hr_api.g_varchar2) then
766: p_rec.cont_information16 :=
767: per_ctr_shd.g_old_rec.cont_information16;
768: End If;
769: If (p_rec.cont_information17 = hr_api.g_varchar2) then
770: p_rec.cont_information17 :=
771: per_ctr_shd.g_old_rec.cont_information17;
772: End If;
773: If (p_rec.cont_information18 = hr_api.g_varchar2) then

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

769: If (p_rec.cont_information17 = hr_api.g_varchar2) then
770: p_rec.cont_information17 :=
771: per_ctr_shd.g_old_rec.cont_information17;
772: End If;
773: If (p_rec.cont_information18 = hr_api.g_varchar2) then
774: p_rec.cont_information18 :=
775: per_ctr_shd.g_old_rec.cont_information18;
776: End If;
777: If (p_rec.cont_information19 = hr_api.g_varchar2) then

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

773: If (p_rec.cont_information18 = hr_api.g_varchar2) then
774: p_rec.cont_information18 :=
775: per_ctr_shd.g_old_rec.cont_information18;
776: End If;
777: If (p_rec.cont_information19 = hr_api.g_varchar2) then
778: p_rec.cont_information19 :=
779: per_ctr_shd.g_old_rec.cont_information19;
780: End If;
781: If (p_rec.cont_information20 = hr_api.g_varchar2) then

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

777: If (p_rec.cont_information19 = hr_api.g_varchar2) then
778: p_rec.cont_information19 :=
779: per_ctr_shd.g_old_rec.cont_information19;
780: End If;
781: If (p_rec.cont_information20 = hr_api.g_varchar2) then
782: p_rec.cont_information20 :=
783: per_ctr_shd.g_old_rec.cont_information20;
784: End If;
785: If (p_rec.third_party_pay_flag = hr_api.g_varchar2) then

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

781: If (p_rec.cont_information20 = hr_api.g_varchar2) then
782: p_rec.cont_information20 :=
783: per_ctr_shd.g_old_rec.cont_information20;
784: End If;
785: If (p_rec.third_party_pay_flag = hr_api.g_varchar2) then
786: p_rec.third_party_pay_flag :=
787: per_ctr_shd.g_old_rec.third_party_pay_flag;
788: End If;
789: If (p_rec.bondholder_flag = hr_api.g_varchar2) then

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

785: If (p_rec.third_party_pay_flag = hr_api.g_varchar2) then
786: p_rec.third_party_pay_flag :=
787: per_ctr_shd.g_old_rec.third_party_pay_flag;
788: End If;
789: If (p_rec.bondholder_flag = hr_api.g_varchar2) then
790: p_rec.bondholder_flag :=
791: per_ctr_shd.g_old_rec.bondholder_flag;
792: End If;
793: If (p_rec.dependent_flag = hr_api.g_varchar2) then

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

789: If (p_rec.bondholder_flag = hr_api.g_varchar2) then
790: p_rec.bondholder_flag :=
791: per_ctr_shd.g_old_rec.bondholder_flag;
792: End If;
793: If (p_rec.dependent_flag = hr_api.g_varchar2) then
794: p_rec.dependent_flag :=
795: per_ctr_shd.g_old_rec.dependent_flag;
796: End If;
797: If (p_rec.beneficiary_flag = hr_api.g_varchar2) then

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

793: If (p_rec.dependent_flag = hr_api.g_varchar2) then
794: p_rec.dependent_flag :=
795: per_ctr_shd.g_old_rec.dependent_flag;
796: End If;
797: If (p_rec.beneficiary_flag = hr_api.g_varchar2) then
798: p_rec.beneficiary_flag :=
799: per_ctr_shd.g_old_rec.beneficiary_flag;
800: End If;
801: --

Line 864: Raise HR_Api.Validate_Enabled;

860: --
861: -- If we are validating then raise the Validate_Enabled exception
862: --
863: If p_validate then
864: Raise HR_Api.Validate_Enabled;
865: End If;
866: --
867: hr_utility.set_location(' Leaving:'||l_proc, 10);
868: Exception

Line 869: When HR_Api.Validate_Enabled Then

865: End If;
866: --
867: hr_utility.set_location(' Leaving:'||l_proc, 10);
868: Exception
869: When HR_Api.Validate_Enabled Then
870: --
871: -- As the Validate_Enabled exception has been raised
872: -- we must rollback to the savepoint
873: --

Line 883: p_contact_type in varchar2 default hr_api.g_varchar2,

879: -- ----------------------------------------------------------------------------
880: Procedure upd
881: (
882: p_contact_relationship_id in number,
883: p_contact_type in varchar2 default hr_api.g_varchar2,
884: p_comments in long default hr_api.g_varchar2,
885: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
886: p_request_id in number default hr_api.g_number,
887: p_program_application_id in number default hr_api.g_number,

Line 884: p_comments in long default hr_api.g_varchar2,

880: Procedure upd
881: (
882: p_contact_relationship_id in number,
883: p_contact_type in varchar2 default hr_api.g_varchar2,
884: p_comments in long default hr_api.g_varchar2,
885: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
886: p_request_id in number default hr_api.g_number,
887: p_program_application_id in number default hr_api.g_number,
888: p_program_id in number default hr_api.g_number,

Line 885: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,

881: (
882: p_contact_relationship_id in number,
883: p_contact_type in varchar2 default hr_api.g_varchar2,
884: p_comments in long default hr_api.g_varchar2,
885: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
886: p_request_id in number default hr_api.g_number,
887: p_program_application_id in number default hr_api.g_number,
888: p_program_id in number default hr_api.g_number,
889: p_program_update_date in date default hr_api.g_date,

Line 886: p_request_id in number default hr_api.g_number,

882: p_contact_relationship_id in number,
883: p_contact_type in varchar2 default hr_api.g_varchar2,
884: p_comments in long default hr_api.g_varchar2,
885: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
886: p_request_id in number default hr_api.g_number,
887: p_program_application_id in number default hr_api.g_number,
888: p_program_id in number default hr_api.g_number,
889: p_program_update_date in date default hr_api.g_date,
890: p_date_start in date default hr_api.g_date,

Line 887: p_program_application_id in number default hr_api.g_number,

883: p_contact_type in varchar2 default hr_api.g_varchar2,
884: p_comments in long default hr_api.g_varchar2,
885: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
886: p_request_id in number default hr_api.g_number,
887: p_program_application_id in number default hr_api.g_number,
888: p_program_id in number default hr_api.g_number,
889: p_program_update_date in date default hr_api.g_date,
890: p_date_start in date default hr_api.g_date,
891: p_start_life_reason_id in number default hr_api.g_number,

Line 888: p_program_id in number default hr_api.g_number,

884: p_comments in long default hr_api.g_varchar2,
885: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
886: p_request_id in number default hr_api.g_number,
887: p_program_application_id in number default hr_api.g_number,
888: p_program_id in number default hr_api.g_number,
889: p_program_update_date in date default hr_api.g_date,
890: p_date_start in date default hr_api.g_date,
891: p_start_life_reason_id in number default hr_api.g_number,
892: p_date_end in date default hr_api.g_date,

Line 889: p_program_update_date in date default hr_api.g_date,

885: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
886: p_request_id in number default hr_api.g_number,
887: p_program_application_id in number default hr_api.g_number,
888: p_program_id in number default hr_api.g_number,
889: p_program_update_date in date default hr_api.g_date,
890: p_date_start in date default hr_api.g_date,
891: p_start_life_reason_id in number default hr_api.g_number,
892: p_date_end in date default hr_api.g_date,
893: p_end_life_reason_id in number default hr_api.g_number,

Line 890: p_date_start in date default hr_api.g_date,

886: p_request_id in number default hr_api.g_number,
887: p_program_application_id in number default hr_api.g_number,
888: p_program_id in number default hr_api.g_number,
889: p_program_update_date in date default hr_api.g_date,
890: p_date_start in date default hr_api.g_date,
891: p_start_life_reason_id in number default hr_api.g_number,
892: p_date_end in date default hr_api.g_date,
893: p_end_life_reason_id in number default hr_api.g_number,
894: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,

Line 891: p_start_life_reason_id in number default hr_api.g_number,

887: p_program_application_id in number default hr_api.g_number,
888: p_program_id in number default hr_api.g_number,
889: p_program_update_date in date default hr_api.g_date,
890: p_date_start in date default hr_api.g_date,
891: p_start_life_reason_id in number default hr_api.g_number,
892: p_date_end in date default hr_api.g_date,
893: p_end_life_reason_id in number default hr_api.g_number,
894: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
895: p_personal_flag in varchar2 default hr_api.g_varchar2,

Line 892: p_date_end in date default hr_api.g_date,

888: p_program_id in number default hr_api.g_number,
889: p_program_update_date in date default hr_api.g_date,
890: p_date_start in date default hr_api.g_date,
891: p_start_life_reason_id in number default hr_api.g_number,
892: p_date_end in date default hr_api.g_date,
893: p_end_life_reason_id in number default hr_api.g_number,
894: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
895: p_personal_flag in varchar2 default hr_api.g_varchar2,
896: p_sequence_number in number default hr_api.g_number,

Line 893: p_end_life_reason_id in number default hr_api.g_number,

889: p_program_update_date in date default hr_api.g_date,
890: p_date_start in date default hr_api.g_date,
891: p_start_life_reason_id in number default hr_api.g_number,
892: p_date_end in date default hr_api.g_date,
893: p_end_life_reason_id in number default hr_api.g_number,
894: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
895: p_personal_flag in varchar2 default hr_api.g_varchar2,
896: p_sequence_number in number default hr_api.g_number,
897: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,

Line 894: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,

890: p_date_start in date default hr_api.g_date,
891: p_start_life_reason_id in number default hr_api.g_number,
892: p_date_end in date default hr_api.g_date,
893: p_end_life_reason_id in number default hr_api.g_number,
894: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
895: p_personal_flag in varchar2 default hr_api.g_varchar2,
896: p_sequence_number in number default hr_api.g_number,
897: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
898: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,

Line 895: p_personal_flag in varchar2 default hr_api.g_varchar2,

891: p_start_life_reason_id in number default hr_api.g_number,
892: p_date_end in date default hr_api.g_date,
893: p_end_life_reason_id in number default hr_api.g_number,
894: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
895: p_personal_flag in varchar2 default hr_api.g_varchar2,
896: p_sequence_number in number default hr_api.g_number,
897: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
898: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
899: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,

Line 896: p_sequence_number in number default hr_api.g_number,

892: p_date_end in date default hr_api.g_date,
893: p_end_life_reason_id in number default hr_api.g_number,
894: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
895: p_personal_flag in varchar2 default hr_api.g_varchar2,
896: p_sequence_number in number default hr_api.g_number,
897: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
898: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
899: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
900: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,

Line 897: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,

893: p_end_life_reason_id in number default hr_api.g_number,
894: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
895: p_personal_flag in varchar2 default hr_api.g_varchar2,
896: p_sequence_number in number default hr_api.g_number,
897: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
898: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
899: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
900: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
901: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,

Line 898: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,

894: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
895: p_personal_flag in varchar2 default hr_api.g_varchar2,
896: p_sequence_number in number default hr_api.g_number,
897: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
898: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
899: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
900: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
901: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
902: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,

Line 899: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,

895: p_personal_flag in varchar2 default hr_api.g_varchar2,
896: p_sequence_number in number default hr_api.g_number,
897: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
898: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
899: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
900: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
901: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
902: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
903: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,

Line 900: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,

896: p_sequence_number in number default hr_api.g_number,
897: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
898: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
899: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
900: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
901: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
902: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
903: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
904: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,

Line 901: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,

897: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
898: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
899: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
900: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
901: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
902: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
903: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
904: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
905: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,

Line 902: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,

898: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
899: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
900: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
901: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
902: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
903: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
904: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
905: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
906: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,

Line 903: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,

899: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
900: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
901: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
902: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
903: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
904: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
905: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
906: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
907: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,

Line 904: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,

900: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
901: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
902: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
903: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
904: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
905: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
906: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
907: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
908: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,

Line 905: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,

901: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
902: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
903: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
904: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
905: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
906: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
907: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
908: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
909: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,

Line 906: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,

902: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
903: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
904: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
905: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
906: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
907: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
908: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
909: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
910: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,

Line 907: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,

903: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
904: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
905: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
906: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
907: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
908: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
909: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
910: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
911: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,

Line 908: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,

904: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
905: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
906: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
907: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
908: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
909: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
910: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
911: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
912: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,

Line 909: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,

905: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
906: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
907: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
908: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
909: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
910: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
911: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
912: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
913: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,

Line 910: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,

906: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
907: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
908: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
909: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
910: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
911: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
912: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
913: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
914: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,

Line 911: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,

907: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
908: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
909: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
910: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
911: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
912: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
913: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
914: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
915: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,

Line 912: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,

908: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
909: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
910: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
911: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
912: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
913: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
914: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
915: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
916: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,

Line 913: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,

909: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
910: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
911: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
912: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
913: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
914: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
915: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
916: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
917: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,

Line 914: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,

910: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
911: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
912: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
913: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
914: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
915: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
916: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
917: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
918: p_cont_information_category in varchar2 default hr_api.g_varchar2,

Line 915: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,

911: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
912: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
913: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
914: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
915: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
916: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
917: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
918: p_cont_information_category in varchar2 default hr_api.g_varchar2,
919: p_cont_information1 in varchar2 default hr_api.g_varchar2,

Line 916: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,

912: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
913: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
914: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
915: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
916: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
917: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
918: p_cont_information_category in varchar2 default hr_api.g_varchar2,
919: p_cont_information1 in varchar2 default hr_api.g_varchar2,
920: p_cont_information2 in varchar2 default hr_api.g_varchar2,

Line 917: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,

913: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
914: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
915: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
916: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
917: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
918: p_cont_information_category in varchar2 default hr_api.g_varchar2,
919: p_cont_information1 in varchar2 default hr_api.g_varchar2,
920: p_cont_information2 in varchar2 default hr_api.g_varchar2,
921: p_cont_information3 in varchar2 default hr_api.g_varchar2,

Line 918: p_cont_information_category in varchar2 default hr_api.g_varchar2,

914: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
915: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
916: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
917: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
918: p_cont_information_category in varchar2 default hr_api.g_varchar2,
919: p_cont_information1 in varchar2 default hr_api.g_varchar2,
920: p_cont_information2 in varchar2 default hr_api.g_varchar2,
921: p_cont_information3 in varchar2 default hr_api.g_varchar2,
922: p_cont_information4 in varchar2 default hr_api.g_varchar2,

Line 919: p_cont_information1 in varchar2 default hr_api.g_varchar2,

915: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
916: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
917: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
918: p_cont_information_category in varchar2 default hr_api.g_varchar2,
919: p_cont_information1 in varchar2 default hr_api.g_varchar2,
920: p_cont_information2 in varchar2 default hr_api.g_varchar2,
921: p_cont_information3 in varchar2 default hr_api.g_varchar2,
922: p_cont_information4 in varchar2 default hr_api.g_varchar2,
923: p_cont_information5 in varchar2 default hr_api.g_varchar2,

Line 920: p_cont_information2 in varchar2 default hr_api.g_varchar2,

916: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
917: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
918: p_cont_information_category in varchar2 default hr_api.g_varchar2,
919: p_cont_information1 in varchar2 default hr_api.g_varchar2,
920: p_cont_information2 in varchar2 default hr_api.g_varchar2,
921: p_cont_information3 in varchar2 default hr_api.g_varchar2,
922: p_cont_information4 in varchar2 default hr_api.g_varchar2,
923: p_cont_information5 in varchar2 default hr_api.g_varchar2,
924: p_cont_information6 in varchar2 default hr_api.g_varchar2,

Line 921: p_cont_information3 in varchar2 default hr_api.g_varchar2,

917: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
918: p_cont_information_category in varchar2 default hr_api.g_varchar2,
919: p_cont_information1 in varchar2 default hr_api.g_varchar2,
920: p_cont_information2 in varchar2 default hr_api.g_varchar2,
921: p_cont_information3 in varchar2 default hr_api.g_varchar2,
922: p_cont_information4 in varchar2 default hr_api.g_varchar2,
923: p_cont_information5 in varchar2 default hr_api.g_varchar2,
924: p_cont_information6 in varchar2 default hr_api.g_varchar2,
925: p_cont_information7 in varchar2 default hr_api.g_varchar2,

Line 922: p_cont_information4 in varchar2 default hr_api.g_varchar2,

918: p_cont_information_category in varchar2 default hr_api.g_varchar2,
919: p_cont_information1 in varchar2 default hr_api.g_varchar2,
920: p_cont_information2 in varchar2 default hr_api.g_varchar2,
921: p_cont_information3 in varchar2 default hr_api.g_varchar2,
922: p_cont_information4 in varchar2 default hr_api.g_varchar2,
923: p_cont_information5 in varchar2 default hr_api.g_varchar2,
924: p_cont_information6 in varchar2 default hr_api.g_varchar2,
925: p_cont_information7 in varchar2 default hr_api.g_varchar2,
926: p_cont_information8 in varchar2 default hr_api.g_varchar2,

Line 923: p_cont_information5 in varchar2 default hr_api.g_varchar2,

919: p_cont_information1 in varchar2 default hr_api.g_varchar2,
920: p_cont_information2 in varchar2 default hr_api.g_varchar2,
921: p_cont_information3 in varchar2 default hr_api.g_varchar2,
922: p_cont_information4 in varchar2 default hr_api.g_varchar2,
923: p_cont_information5 in varchar2 default hr_api.g_varchar2,
924: p_cont_information6 in varchar2 default hr_api.g_varchar2,
925: p_cont_information7 in varchar2 default hr_api.g_varchar2,
926: p_cont_information8 in varchar2 default hr_api.g_varchar2,
927: p_cont_information9 in varchar2 default hr_api.g_varchar2,

Line 924: p_cont_information6 in varchar2 default hr_api.g_varchar2,

920: p_cont_information2 in varchar2 default hr_api.g_varchar2,
921: p_cont_information3 in varchar2 default hr_api.g_varchar2,
922: p_cont_information4 in varchar2 default hr_api.g_varchar2,
923: p_cont_information5 in varchar2 default hr_api.g_varchar2,
924: p_cont_information6 in varchar2 default hr_api.g_varchar2,
925: p_cont_information7 in varchar2 default hr_api.g_varchar2,
926: p_cont_information8 in varchar2 default hr_api.g_varchar2,
927: p_cont_information9 in varchar2 default hr_api.g_varchar2,
928: p_cont_information10 in varchar2 default hr_api.g_varchar2,

Line 925: p_cont_information7 in varchar2 default hr_api.g_varchar2,

921: p_cont_information3 in varchar2 default hr_api.g_varchar2,
922: p_cont_information4 in varchar2 default hr_api.g_varchar2,
923: p_cont_information5 in varchar2 default hr_api.g_varchar2,
924: p_cont_information6 in varchar2 default hr_api.g_varchar2,
925: p_cont_information7 in varchar2 default hr_api.g_varchar2,
926: p_cont_information8 in varchar2 default hr_api.g_varchar2,
927: p_cont_information9 in varchar2 default hr_api.g_varchar2,
928: p_cont_information10 in varchar2 default hr_api.g_varchar2,
929: p_cont_information11 in varchar2 default hr_api.g_varchar2,

Line 926: p_cont_information8 in varchar2 default hr_api.g_varchar2,

922: p_cont_information4 in varchar2 default hr_api.g_varchar2,
923: p_cont_information5 in varchar2 default hr_api.g_varchar2,
924: p_cont_information6 in varchar2 default hr_api.g_varchar2,
925: p_cont_information7 in varchar2 default hr_api.g_varchar2,
926: p_cont_information8 in varchar2 default hr_api.g_varchar2,
927: p_cont_information9 in varchar2 default hr_api.g_varchar2,
928: p_cont_information10 in varchar2 default hr_api.g_varchar2,
929: p_cont_information11 in varchar2 default hr_api.g_varchar2,
930: p_cont_information12 in varchar2 default hr_api.g_varchar2,

Line 927: p_cont_information9 in varchar2 default hr_api.g_varchar2,

923: p_cont_information5 in varchar2 default hr_api.g_varchar2,
924: p_cont_information6 in varchar2 default hr_api.g_varchar2,
925: p_cont_information7 in varchar2 default hr_api.g_varchar2,
926: p_cont_information8 in varchar2 default hr_api.g_varchar2,
927: p_cont_information9 in varchar2 default hr_api.g_varchar2,
928: p_cont_information10 in varchar2 default hr_api.g_varchar2,
929: p_cont_information11 in varchar2 default hr_api.g_varchar2,
930: p_cont_information12 in varchar2 default hr_api.g_varchar2,
931: p_cont_information13 in varchar2 default hr_api.g_varchar2,

Line 928: p_cont_information10 in varchar2 default hr_api.g_varchar2,

924: p_cont_information6 in varchar2 default hr_api.g_varchar2,
925: p_cont_information7 in varchar2 default hr_api.g_varchar2,
926: p_cont_information8 in varchar2 default hr_api.g_varchar2,
927: p_cont_information9 in varchar2 default hr_api.g_varchar2,
928: p_cont_information10 in varchar2 default hr_api.g_varchar2,
929: p_cont_information11 in varchar2 default hr_api.g_varchar2,
930: p_cont_information12 in varchar2 default hr_api.g_varchar2,
931: p_cont_information13 in varchar2 default hr_api.g_varchar2,
932: p_cont_information14 in varchar2 default hr_api.g_varchar2,

Line 929: p_cont_information11 in varchar2 default hr_api.g_varchar2,

925: p_cont_information7 in varchar2 default hr_api.g_varchar2,
926: p_cont_information8 in varchar2 default hr_api.g_varchar2,
927: p_cont_information9 in varchar2 default hr_api.g_varchar2,
928: p_cont_information10 in varchar2 default hr_api.g_varchar2,
929: p_cont_information11 in varchar2 default hr_api.g_varchar2,
930: p_cont_information12 in varchar2 default hr_api.g_varchar2,
931: p_cont_information13 in varchar2 default hr_api.g_varchar2,
932: p_cont_information14 in varchar2 default hr_api.g_varchar2,
933: p_cont_information15 in varchar2 default hr_api.g_varchar2,

Line 930: p_cont_information12 in varchar2 default hr_api.g_varchar2,

926: p_cont_information8 in varchar2 default hr_api.g_varchar2,
927: p_cont_information9 in varchar2 default hr_api.g_varchar2,
928: p_cont_information10 in varchar2 default hr_api.g_varchar2,
929: p_cont_information11 in varchar2 default hr_api.g_varchar2,
930: p_cont_information12 in varchar2 default hr_api.g_varchar2,
931: p_cont_information13 in varchar2 default hr_api.g_varchar2,
932: p_cont_information14 in varchar2 default hr_api.g_varchar2,
933: p_cont_information15 in varchar2 default hr_api.g_varchar2,
934: p_cont_information16 in varchar2 default hr_api.g_varchar2,

Line 931: p_cont_information13 in varchar2 default hr_api.g_varchar2,

927: p_cont_information9 in varchar2 default hr_api.g_varchar2,
928: p_cont_information10 in varchar2 default hr_api.g_varchar2,
929: p_cont_information11 in varchar2 default hr_api.g_varchar2,
930: p_cont_information12 in varchar2 default hr_api.g_varchar2,
931: p_cont_information13 in varchar2 default hr_api.g_varchar2,
932: p_cont_information14 in varchar2 default hr_api.g_varchar2,
933: p_cont_information15 in varchar2 default hr_api.g_varchar2,
934: p_cont_information16 in varchar2 default hr_api.g_varchar2,
935: p_cont_information17 in varchar2 default hr_api.g_varchar2,

Line 932: p_cont_information14 in varchar2 default hr_api.g_varchar2,

928: p_cont_information10 in varchar2 default hr_api.g_varchar2,
929: p_cont_information11 in varchar2 default hr_api.g_varchar2,
930: p_cont_information12 in varchar2 default hr_api.g_varchar2,
931: p_cont_information13 in varchar2 default hr_api.g_varchar2,
932: p_cont_information14 in varchar2 default hr_api.g_varchar2,
933: p_cont_information15 in varchar2 default hr_api.g_varchar2,
934: p_cont_information16 in varchar2 default hr_api.g_varchar2,
935: p_cont_information17 in varchar2 default hr_api.g_varchar2,
936: p_cont_information18 in varchar2 default hr_api.g_varchar2,

Line 933: p_cont_information15 in varchar2 default hr_api.g_varchar2,

929: p_cont_information11 in varchar2 default hr_api.g_varchar2,
930: p_cont_information12 in varchar2 default hr_api.g_varchar2,
931: p_cont_information13 in varchar2 default hr_api.g_varchar2,
932: p_cont_information14 in varchar2 default hr_api.g_varchar2,
933: p_cont_information15 in varchar2 default hr_api.g_varchar2,
934: p_cont_information16 in varchar2 default hr_api.g_varchar2,
935: p_cont_information17 in varchar2 default hr_api.g_varchar2,
936: p_cont_information18 in varchar2 default hr_api.g_varchar2,
937: p_cont_information19 in varchar2 default hr_api.g_varchar2,

Line 934: p_cont_information16 in varchar2 default hr_api.g_varchar2,

930: p_cont_information12 in varchar2 default hr_api.g_varchar2,
931: p_cont_information13 in varchar2 default hr_api.g_varchar2,
932: p_cont_information14 in varchar2 default hr_api.g_varchar2,
933: p_cont_information15 in varchar2 default hr_api.g_varchar2,
934: p_cont_information16 in varchar2 default hr_api.g_varchar2,
935: p_cont_information17 in varchar2 default hr_api.g_varchar2,
936: p_cont_information18 in varchar2 default hr_api.g_varchar2,
937: p_cont_information19 in varchar2 default hr_api.g_varchar2,
938: p_cont_information20 in varchar2 default hr_api.g_varchar2,

Line 935: p_cont_information17 in varchar2 default hr_api.g_varchar2,

931: p_cont_information13 in varchar2 default hr_api.g_varchar2,
932: p_cont_information14 in varchar2 default hr_api.g_varchar2,
933: p_cont_information15 in varchar2 default hr_api.g_varchar2,
934: p_cont_information16 in varchar2 default hr_api.g_varchar2,
935: p_cont_information17 in varchar2 default hr_api.g_varchar2,
936: p_cont_information18 in varchar2 default hr_api.g_varchar2,
937: p_cont_information19 in varchar2 default hr_api.g_varchar2,
938: p_cont_information20 in varchar2 default hr_api.g_varchar2,
939: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,

Line 936: p_cont_information18 in varchar2 default hr_api.g_varchar2,

932: p_cont_information14 in varchar2 default hr_api.g_varchar2,
933: p_cont_information15 in varchar2 default hr_api.g_varchar2,
934: p_cont_information16 in varchar2 default hr_api.g_varchar2,
935: p_cont_information17 in varchar2 default hr_api.g_varchar2,
936: p_cont_information18 in varchar2 default hr_api.g_varchar2,
937: p_cont_information19 in varchar2 default hr_api.g_varchar2,
938: p_cont_information20 in varchar2 default hr_api.g_varchar2,
939: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
940: p_bondholder_flag in varchar2 default hr_api.g_varchar2,

Line 937: p_cont_information19 in varchar2 default hr_api.g_varchar2,

933: p_cont_information15 in varchar2 default hr_api.g_varchar2,
934: p_cont_information16 in varchar2 default hr_api.g_varchar2,
935: p_cont_information17 in varchar2 default hr_api.g_varchar2,
936: p_cont_information18 in varchar2 default hr_api.g_varchar2,
937: p_cont_information19 in varchar2 default hr_api.g_varchar2,
938: p_cont_information20 in varchar2 default hr_api.g_varchar2,
939: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
940: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
941: p_dependent_flag in varchar2 default hr_api.g_varchar2,

Line 938: p_cont_information20 in varchar2 default hr_api.g_varchar2,

934: p_cont_information16 in varchar2 default hr_api.g_varchar2,
935: p_cont_information17 in varchar2 default hr_api.g_varchar2,
936: p_cont_information18 in varchar2 default hr_api.g_varchar2,
937: p_cont_information19 in varchar2 default hr_api.g_varchar2,
938: p_cont_information20 in varchar2 default hr_api.g_varchar2,
939: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
940: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
941: p_dependent_flag in varchar2 default hr_api.g_varchar2,
942: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,

Line 939: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,

935: p_cont_information17 in varchar2 default hr_api.g_varchar2,
936: p_cont_information18 in varchar2 default hr_api.g_varchar2,
937: p_cont_information19 in varchar2 default hr_api.g_varchar2,
938: p_cont_information20 in varchar2 default hr_api.g_varchar2,
939: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
940: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
941: p_dependent_flag in varchar2 default hr_api.g_varchar2,
942: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
943: p_object_version_number in out nocopy number,

Line 940: p_bondholder_flag in varchar2 default hr_api.g_varchar2,

936: p_cont_information18 in varchar2 default hr_api.g_varchar2,
937: p_cont_information19 in varchar2 default hr_api.g_varchar2,
938: p_cont_information20 in varchar2 default hr_api.g_varchar2,
939: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
940: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
941: p_dependent_flag in varchar2 default hr_api.g_varchar2,
942: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
943: p_object_version_number in out nocopy number,
944: p_effective_date in date,

Line 941: p_dependent_flag in varchar2 default hr_api.g_varchar2,

937: p_cont_information19 in varchar2 default hr_api.g_varchar2,
938: p_cont_information20 in varchar2 default hr_api.g_varchar2,
939: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
940: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
941: p_dependent_flag in varchar2 default hr_api.g_varchar2,
942: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
943: p_object_version_number in out nocopy number,
944: p_effective_date in date,
945: p_validate in boolean default false

Line 942: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,

938: p_cont_information20 in varchar2 default hr_api.g_varchar2,
939: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
940: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
941: p_dependent_flag in varchar2 default hr_api.g_varchar2,
942: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
943: p_object_version_number in out nocopy number,
944: p_effective_date in date,
945: p_validate in boolean default false
946: ) is

Line 961: hr_api.g_number,

957: l_rec :=
958: per_ctr_shd.convert_args
959: (
960: p_contact_relationship_id,
961: hr_api.g_number,
962: hr_api.g_number,
963: hr_api.g_number,
964: p_contact_type,
965: p_comments,

Line 962: hr_api.g_number,

958: per_ctr_shd.convert_args
959: (
960: p_contact_relationship_id,
961: hr_api.g_number,
962: hr_api.g_number,
963: hr_api.g_number,
964: p_contact_type,
965: p_comments,
966: p_primary_contact_flag,

Line 963: hr_api.g_number,

959: (
960: p_contact_relationship_id,
961: hr_api.g_number,
962: hr_api.g_number,
963: hr_api.g_number,
964: p_contact_type,
965: p_comments,
966: p_primary_contact_flag,
967: p_request_id,